eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_RULES_WORKBENCH_PVT dependencies on FND_API

Line 872: if x_return_status = fnd_api.g_ret_sts_success then

868: ,l_return_type_code
869: ,l_return_type_id
870: );
871: -- leave the actual procedure, if stub procedure already found a strategy
872: if x_return_status = fnd_api.g_ret_sts_success then
873: if l_debug = 1 then
874: log_event(l_api_name, 'Custom Type is found : ',l_return_type_code);
875: log_event(l_api_name, 'Custom Strategy/Rule/value found : ',l_return_type_id);
876: end if;

Line 885: elsif x_return_status = fnd_api.g_ret_sts_unexp_error then

881: x_sequence_number := 0;
882:
883: return;
884: -- leave the actual procedure, if stub procedure got an unexpected error
885: elsif x_return_status = fnd_api.g_ret_sts_unexp_error then
886: raise fnd_api.g_exc_unexpected_error;
887: -- continue strategy search, if stub procedure didn't find strategy already
888: elsif x_return_status = fnd_api.g_ret_sts_error then
889: -- Re-Initialize API return status to success

Line 886: raise fnd_api.g_exc_unexpected_error;

882:
883: return;
884: -- leave the actual procedure, if stub procedure got an unexpected error
885: elsif x_return_status = fnd_api.g_ret_sts_unexp_error then
886: raise fnd_api.g_exc_unexpected_error;
887: -- continue strategy search, if stub procedure didn't find strategy already
888: elsif x_return_status = fnd_api.g_ret_sts_error then
889: -- Re-Initialize API return status to success
890: x_return_status := fnd_api.g_ret_sts_success;

Line 888: elsif x_return_status = fnd_api.g_ret_sts_error then

884: -- leave the actual procedure, if stub procedure got an unexpected error
885: elsif x_return_status = fnd_api.g_ret_sts_unexp_error then
886: raise fnd_api.g_exc_unexpected_error;
887: -- continue strategy search, if stub procedure didn't find strategy already
888: elsif x_return_status = fnd_api.g_ret_sts_error then
889: -- Re-Initialize API return status to success
890: x_return_status := fnd_api.g_ret_sts_success;
891: -- every other return status seems to be unexpected: leave
892: else

Line 890: x_return_status := fnd_api.g_ret_sts_success;

886: raise fnd_api.g_exc_unexpected_error;
887: -- continue strategy search, if stub procedure didn't find strategy already
888: elsif x_return_status = fnd_api.g_ret_sts_error then
889: -- Re-Initialize API return status to success
890: x_return_status := fnd_api.g_ret_sts_success;
891: -- every other return status seems to be unexpected: leave
892: else
893: fnd_message.set_name('WMS','WMS_INVALID_RETURN_STATUS');
894: -- WMS_re_Custom_PUB.SearchForStrategy returned wrong status

Line 897: raise fnd_api.g_exc_unexpected_error;

893: fnd_message.set_name('WMS','WMS_INVALID_RETURN_STATUS');
894: -- WMS_re_Custom_PUB.SearchForStrategy returned wrong status
895: fnd_msg_pub.add;
896: log_error_msg(l_api_name, 'bad_return_status');
897: raise fnd_api.g_exc_unexpected_error;
898: end if;
899: --- end of Bug # 2935052 -----
900:
901: if l_debug = 1 then

Line 906: if fnd_api.to_boolean( p_init_msg_list ) then

902: log_procedure(l_api_name,'','Start selection Criteria ');
903: log_event(l_api_name,'Move order line: ', p_transaction_temp_id);
904: end if;
905: -- Initialize message list if p_init_msg_list is set to TRUE
906: if fnd_api.to_boolean( p_init_msg_list ) then
907: fnd_msg_pub.initialize;
908: end if;
909:
910: -- Initialize API return status to success

Line 911: x_return_status := fnd_api.g_ret_sts_success;

907: fnd_msg_pub.initialize;
908: end if;
909:
910: -- Initialize API return status to success
911: x_return_status := fnd_api.g_ret_sts_success;
912:
913: -- Bug 5264987 - Fetching the MO_lines from the Cache instead of querying ,
914:
915: l_return_value := INV_CACHE.set_mol_rec(p_transaction_temp_id);

Line 920: raise fnd_api.g_exc_unexpected_error;

916: IF NOT l_return_value THEN
917: If l_debug = 1 THEN
918: log_event(l_api_name,'','Move order line cursor not found ');
919: End If;
920: raise fnd_api.g_exc_unexpected_error;
921: END IF;
922: log_event(l_api_name,'','test:Move order line fetched from cache');
923: l_rec_mtrl := INV_CACHE.mol_rec;
924:

Line 1044: x_return_status := fnd_api.g_ret_sts_success;

1040: end if;
1041: l_return_type_code := NULL;
1042: l_return_type_id := NULL;
1043: l_sequence_number := NULL;
1044: x_return_status := fnd_api.g_ret_sts_success;
1045:
1046: --- setting global variables used by Rules simulator and trace execution forms
1047: IF p_type_code = 1 THEN
1048: wms_search_order_globals_pvt.g_putaway_strategy_id := -999;

Line 1095: x_return_status := fnd_api.g_ret_sts_success;

1091:
1092: x_return_type := l_return_type_code;
1093: x_return_type_id := l_return_type_id;
1094: x_sequence_number := l_sequence_number;
1095: x_return_status := fnd_api.g_ret_sts_success;
1096:
1097: --- setting global variables used by Rules simulator and trace execution forms
1098:
1099: IF l_return_type_code = 'S' THEN

Line 1201: WHEN fnd_api.g_exc_error THEN

1197:
1198: End if;
1199: Exception
1200:
1201: WHEN fnd_api.g_exc_error THEN
1202: x_return_status := fnd_api.g_ret_sts_error;
1203: If cur_stg_selection%ISOPEN then
1204: CLOSE cur_stg_selection;
1205: End if;

Line 1202: x_return_status := fnd_api.g_ret_sts_error;

1198: End if;
1199: Exception
1200:
1201: WHEN fnd_api.g_exc_error THEN
1202: x_return_status := fnd_api.g_ret_sts_error;
1203: If cur_stg_selection%ISOPEN then
1204: CLOSE cur_stg_selection;
1205: End if;
1206:

Line 1214: WHEN fnd_api.g_exc_unexpected_error THEN

1210: ,p_data => x_msg_data);
1211: log_error(l_api_name, 'error', 'Error in selection Criteria - ' ||
1212: x_msg_data);
1213: --
1214: WHEN fnd_api.g_exc_unexpected_error THEN
1215: x_return_status := fnd_api.g_ret_sts_unexp_error;
1216:
1217: If cur_stg_selection%ISOPEN then
1218: CLOSE cur_stg_selection;

Line 1215: x_return_status := fnd_api.g_ret_sts_unexp_error;

1211: log_error(l_api_name, 'error', 'Error in selection Criteria - ' ||
1212: x_msg_data);
1213: --
1214: WHEN fnd_api.g_exc_unexpected_error THEN
1215: x_return_status := fnd_api.g_ret_sts_unexp_error;
1216:
1217: If cur_stg_selection%ISOPEN then
1218: CLOSE cur_stg_selection;
1219: End if;

Line 1230: x_return_status := fnd_api.g_ret_sts_unexp_error;

1226: WHEN OTHERS THEN
1227: if l_debug = 1 then
1228: log_event(l_api_name,'',' Exception in selection Criteria');
1229: end if;
1230: x_return_status := fnd_api.g_ret_sts_unexp_error;
1231:
1232: If cur_stg_selection%ISOPEN then
1233: CLOSE cur_stg_selection;
1234: End if;

Line 1402: if x_return_status = fnd_api.g_ret_sts_success then

1398: ,l_return_type_code
1399: ,l_return_type_id
1400: );
1401: -- leave the actual procedure, if stub procedure already found a strategy
1402: if x_return_status = fnd_api.g_ret_sts_success then
1403: log_event(l_api_name,'custom Type is d', l_return_type_code);
1404: log_event(l_api_name,'custom strategyRule/Value found', l_return_type_id);
1405: --- reassign the l_strategy_id to the new variables
1406: x_return_type := l_return_type_code;

Line 1411: elsif x_return_status = fnd_api.g_ret_sts_unexp_error then

1407: x_return_type_id := l_return_type_id;
1408: x_sequence_number := 0;
1409: return;
1410: -- leave the actual procedure, if stub procedure got an unexpected error
1411: elsif x_return_status = fnd_api.g_ret_sts_unexp_error then
1412: raise fnd_api.g_exc_unexpected_error;
1413: -- continue strategy search, if stub procedure didn't find strategy already
1414: elsif x_return_status = fnd_api.g_ret_sts_error then
1415: -- Re-Initialize API return status to success

Line 1412: raise fnd_api.g_exc_unexpected_error;

1408: x_sequence_number := 0;
1409: return;
1410: -- leave the actual procedure, if stub procedure got an unexpected error
1411: elsif x_return_status = fnd_api.g_ret_sts_unexp_error then
1412: raise fnd_api.g_exc_unexpected_error;
1413: -- continue strategy search, if stub procedure didn't find strategy already
1414: elsif x_return_status = fnd_api.g_ret_sts_error then
1415: -- Re-Initialize API return status to success
1416: x_return_status := fnd_api.g_ret_sts_success;

Line 1414: elsif x_return_status = fnd_api.g_ret_sts_error then

1410: -- leave the actual procedure, if stub procedure got an unexpected error
1411: elsif x_return_status = fnd_api.g_ret_sts_unexp_error then
1412: raise fnd_api.g_exc_unexpected_error;
1413: -- continue strategy search, if stub procedure didn't find strategy already
1414: elsif x_return_status = fnd_api.g_ret_sts_error then
1415: -- Re-Initialize API return status to success
1416: x_return_status := fnd_api.g_ret_sts_success;
1417: -- every other return status seems to be unexpected: leave
1418: else

Line 1416: x_return_status := fnd_api.g_ret_sts_success;

1412: raise fnd_api.g_exc_unexpected_error;
1413: -- continue strategy search, if stub procedure didn't find strategy already
1414: elsif x_return_status = fnd_api.g_ret_sts_error then
1415: -- Re-Initialize API return status to success
1416: x_return_status := fnd_api.g_ret_sts_success;
1417: -- every other return status seems to be unexpected: leave
1418: else
1419: fnd_message.set_name('WMS','WMS_INVALID_RETURN_STATUS');
1420: -- WMS_re_Custom_PUB.SearchForStrategy returned wrong status

Line 1423: raise fnd_api.g_exc_unexpected_error;

1419: fnd_message.set_name('WMS','WMS_INVALID_RETURN_STATUS');
1420: -- WMS_re_Custom_PUB.SearchForStrategy returned wrong status
1421: fnd_msg_pub.add;
1422: log_error_msg(l_api_name, 'bad_return_status');
1423: raise fnd_api.g_exc_unexpected_error;
1424: end if;
1425: ---- end of Bug # 2935052 -----
1426: if l_debug = 1 then
1427: log_event(l_api_name,'','Start');

Line 1432: if fnd_api.to_boolean( p_init_msg_list ) then

1428: log_event(l_api_name,'MMTT line id: ', to_char(p_transaction_temp_id));
1429: end if;
1430:
1431: -- Initialize message list if p_init_msg_list is set to TRUE
1432: if fnd_api.to_boolean( p_init_msg_list ) then
1433: fnd_msg_pub.initialize;
1434: end if;
1435: -- Initialize API return status to success
1436: x_return_status := fnd_api.g_ret_sts_success;

Line 1436: x_return_status := fnd_api.g_ret_sts_success;

1432: if fnd_api.to_boolean( p_init_msg_list ) then
1433: fnd_msg_pub.initialize;
1434: end if;
1435: -- Initialize API return status to success
1436: x_return_status := fnd_api.g_ret_sts_success;
1437:
1438: open cur_mmt;
1439: fetch cur_mmt into l_rec_mtrl;
1440:

Line 1532: x_return_status := fnd_api.g_ret_sts_success;

1528: IF p_type_code = 5 THEN
1529: wms_search_order_globals_pvt.g_costgroup_strategy_id := -999;
1530: wms_search_order_globals_pvt.g_costgroup_seq_num := -999;
1531: END IF;
1532: x_return_status := fnd_api.g_ret_sts_success;
1533: End if;
1534:
1535: If (cur_stg_selection%FOUND) Then
1536: x_return_type := l_return_type_code;

Line 1539: x_return_status := fnd_api.g_ret_sts_success;

1535: If (cur_stg_selection%FOUND) Then
1536: x_return_type := l_return_type_code;
1537: x_return_type_id := l_return_type_id;
1538: x_sequence_number := l_sequence_number;
1539: x_return_status := fnd_api.g_ret_sts_success;
1540:
1541: if l_debug = 1 then
1542: log_event(l_api_name, '',' Open/fetching stg_selection cursor');
1543: end if;

Line 1574: WHEN fnd_api.g_exc_error THEN

1570: CLOSE cur_stg_selection;
1571: END IF; --Added ofr 3224420
1572: End if;
1573: Exception
1574: WHEN fnd_api.g_exc_error THEN
1575: x_return_status := fnd_api.g_ret_sts_error;
1576: IF cur_mmt%ISOPEN then
1577: CLOSE cur_mmt;
1578: End if;

Line 1575: x_return_status := fnd_api.g_ret_sts_error;

1571: END IF; --Added ofr 3224420
1572: End if;
1573: Exception
1574: WHEN fnd_api.g_exc_error THEN
1575: x_return_status := fnd_api.g_ret_sts_error;
1576: IF cur_mmt%ISOPEN then
1577: CLOSE cur_mmt;
1578: End if;
1579:

Line 1588: WHEN fnd_api.g_exc_unexpected_error THEN

1584: ( p_count => x_msg_count
1585: ,p_data => x_msg_data);
1586: log_error(l_api_name, 'error', 'Error in selection Criteria - ' ||
1587: x_msg_data);
1588: WHEN fnd_api.g_exc_unexpected_error THEN
1589: x_return_status := fnd_api.g_ret_sts_unexp_error;
1590: IF cur_mmt%ISOPEN then
1591: CLOSE cur_mmt;
1592: End if;

Line 1589: x_return_status := fnd_api.g_ret_sts_unexp_error;

1585: ,p_data => x_msg_data);
1586: log_error(l_api_name, 'error', 'Error in selection Criteria - ' ||
1587: x_msg_data);
1588: WHEN fnd_api.g_exc_unexpected_error THEN
1589: x_return_status := fnd_api.g_ret_sts_unexp_error;
1590: IF cur_mmt%ISOPEN then
1591: CLOSE cur_mmt;
1592: End if;
1593:

Line 1612: x_return_status := fnd_api.g_ret_sts_unexp_error;

1608:
1609: if l_debug = 1 then
1610: log_event(l_api_name,'',' Exception in selection Criteria');
1611: end if;
1612: x_return_status := fnd_api.g_ret_sts_unexp_error;
1613:
1614: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) then
1615: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1616: end if;

Line 1639: RAISE fnd_api.g_exc_unexpected_error;

1635: IF NOT l_return_value THEN
1636: If l_debug = 1 THEN
1637: log_event(l_api_name,'','Item not found ');
1638: END IF;
1639: RAISE fnd_api.g_exc_unexpected_error;
1640: END IF;
1641:
1642: l_item_type:=inv_cache.item_rec.item_type;
1643: -- 8809951 end

Line 1868: RAISE fnd_api.g_exc_unexpected_error;

1864: IF NOT l_return_value THEN
1865: IF l_debug = 1 THEN
1866: log_event(l_api_name,'','Move order line not found ');
1867: END IF;
1868: RAISE fnd_api.g_exc_unexpected_error;
1869: END IF;
1870:
1871: /* -- Bug #3387877
1872: select nvl(mtrl.transaction_source_type_id,0) , nvl(mtrl.reference_id, 0)

Line 2144: x_return_status := fnd_api.g_ret_sts_success;

2140: ORDER BY sequence_number;
2141:
2142: BEGIN
2143: -- Initialize the return status
2144: x_return_status := fnd_api.g_ret_sts_success;
2145:
2146: OPEN cur_crossdock_value_selection;
2147: FETCH cur_crossdock_value_selection INTO l_return_type_code, l_return_type_id, l_sequence_number;
2148:

Line 2170: WHEN fnd_api.g_exc_error THEN

2166: END IF;
2167:
2168: EXCEPTION
2169:
2170: WHEN fnd_api.g_exc_error THEN
2171: x_return_status := fnd_api.g_ret_sts_error;
2172: If cur_crossdock_value_selection%ISOPEN then
2173: CLOSE cur_crossdock_value_selection;
2174: End if;

Line 2171: x_return_status := fnd_api.g_ret_sts_error;

2167:
2168: EXCEPTION
2169:
2170: WHEN fnd_api.g_exc_error THEN
2171: x_return_status := fnd_api.g_ret_sts_error;
2172: If cur_crossdock_value_selection%ISOPEN then
2173: CLOSE cur_crossdock_value_selection;
2174: End if;
2175:

Line 2181: WHEN fnd_api.g_exc_unexpected_error THEN

2177: ( p_count => l_msg_count
2178: ,p_data => l_msg_data);
2179: log_error(l_api_name, 'error', 'Error in Cross selection Criteria - ' ||l_msg_data);
2180:
2181: WHEN fnd_api.g_exc_unexpected_error THEN
2182: x_return_status := fnd_api.g_ret_sts_unexp_error;
2183: If cur_crossdock_value_selection%ISOPEN then
2184: CLOSE cur_crossdock_value_selection;
2185: End if;

Line 2182: x_return_status := fnd_api.g_ret_sts_unexp_error;

2178: ,p_data => l_msg_data);
2179: log_error(l_api_name, 'error', 'Error in Cross selection Criteria - ' ||l_msg_data);
2180:
2181: WHEN fnd_api.g_exc_unexpected_error THEN
2182: x_return_status := fnd_api.g_ret_sts_unexp_error;
2183: If cur_crossdock_value_selection%ISOPEN then
2184: CLOSE cur_crossdock_value_selection;
2185: End if;
2186: fnd_msg_pub.Count_And_Get

Line 2195: x_return_status := fnd_api.g_ret_sts_unexp_error;

2191: WHEN OTHERS THEN
2192: if l_debug = 1 then
2193: log_event(l_api_name,'',' Exception in cross selection Criteria');
2194: end if;
2195: x_return_status := fnd_api.g_ret_sts_unexp_error;
2196:
2197: If cur_crossdock_value_selection%ISOPEN then
2198: CLOSE cur_crossdock_value_selection;
2199: End if;