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 766: if x_return_status = fnd_api.g_ret_sts_success then

762: ,l_return_type_code
763: ,l_return_type_id
764: );
765: -- leave the actual procedure, if stub procedure already found a strategy
766: if x_return_status = fnd_api.g_ret_sts_success then
767: if l_debug = 1 then
768: log_event(l_api_name, 'Custom Type is found : ',l_return_type_code);
769: log_event(l_api_name, 'Custom Strategy/Rule/value found : ',l_return_type_id);
770: end if;

Line 779: elsif x_return_status = fnd_api.g_ret_sts_unexp_error then

775: x_sequence_number := 0;
776:
777: return;
778: -- leave the actual procedure, if stub procedure got an unexpected error
779: elsif x_return_status = fnd_api.g_ret_sts_unexp_error then
780: raise fnd_api.g_exc_unexpected_error;
781: -- continue strategy search, if stub procedure didn't find strategy already
782: elsif x_return_status = fnd_api.g_ret_sts_error then
783: -- Re-Initialize API return status to success

Line 780: raise fnd_api.g_exc_unexpected_error;

776:
777: return;
778: -- leave the actual procedure, if stub procedure got an unexpected error
779: elsif x_return_status = fnd_api.g_ret_sts_unexp_error then
780: raise fnd_api.g_exc_unexpected_error;
781: -- continue strategy search, if stub procedure didn't find strategy already
782: elsif x_return_status = fnd_api.g_ret_sts_error then
783: -- Re-Initialize API return status to success
784: x_return_status := fnd_api.g_ret_sts_success;

Line 782: elsif x_return_status = fnd_api.g_ret_sts_error then

778: -- leave the actual procedure, if stub procedure got an unexpected error
779: elsif x_return_status = fnd_api.g_ret_sts_unexp_error then
780: raise fnd_api.g_exc_unexpected_error;
781: -- continue strategy search, if stub procedure didn't find strategy already
782: elsif x_return_status = fnd_api.g_ret_sts_error then
783: -- Re-Initialize API return status to success
784: x_return_status := fnd_api.g_ret_sts_success;
785: -- every other return status seems to be unexpected: leave
786: else

Line 784: x_return_status := fnd_api.g_ret_sts_success;

780: raise fnd_api.g_exc_unexpected_error;
781: -- continue strategy search, if stub procedure didn't find strategy already
782: elsif x_return_status = fnd_api.g_ret_sts_error then
783: -- Re-Initialize API return status to success
784: x_return_status := fnd_api.g_ret_sts_success;
785: -- every other return status seems to be unexpected: leave
786: else
787: fnd_message.set_name('WMS','WMS_INVALID_RETURN_STATUS');
788: -- WMS_re_Custom_PUB.SearchForStrategy returned wrong status

Line 791: raise fnd_api.g_exc_unexpected_error;

787: fnd_message.set_name('WMS','WMS_INVALID_RETURN_STATUS');
788: -- WMS_re_Custom_PUB.SearchForStrategy returned wrong status
789: fnd_msg_pub.add;
790: log_error_msg(l_api_name, 'bad_return_status');
791: raise fnd_api.g_exc_unexpected_error;
792: end if;
793: --- end of Bug # 2935052 -----
794:
795: if l_debug = 1 then

Line 800: if fnd_api.to_boolean( p_init_msg_list ) then

796: log_procedure(l_api_name,'','Start selection Criteria ');
797: log_event(l_api_name,'Move order line: ', p_transaction_temp_id);
798: end if;
799: -- Initialize message list if p_init_msg_list is set to TRUE
800: if fnd_api.to_boolean( p_init_msg_list ) then
801: fnd_msg_pub.initialize;
802: end if;
803:
804: -- Initialize API return status to success

Line 805: x_return_status := fnd_api.g_ret_sts_success;

801: fnd_msg_pub.initialize;
802: end if;
803:
804: -- Initialize API return status to success
805: x_return_status := fnd_api.g_ret_sts_success;
806:
807: -- Bug 5264987 - Fetching the MO_lines from the Cache instead of querying ,
808:
809: l_return_value := INV_CACHE.set_mol_rec(p_transaction_temp_id);

Line 814: raise fnd_api.g_exc_unexpected_error;

810: IF NOT l_return_value THEN
811: If l_debug = 1 THEN
812: log_event(l_api_name,'','Move order line cursor not found ');
813: End If;
814: raise fnd_api.g_exc_unexpected_error;
815: END IF;
816: log_event(l_api_name,'','test:Move order line fetched from cache');
817: l_rec_mtrl := INV_CACHE.mol_rec;
818:

Line 911: x_return_status := fnd_api.g_ret_sts_success;

907: end if;
908: l_return_type_code := NULL;
909: l_return_type_id := NULL;
910: l_sequence_number := NULL;
911: x_return_status := fnd_api.g_ret_sts_success;
912:
913: --- setting global variables used by Rules simulator and trace execution forms
914: IF p_type_code = 1 THEN
915: wms_search_order_globals_pvt.g_putaway_strategy_id := -999;

Line 935: x_return_status := fnd_api.g_ret_sts_success;

931:
932: x_return_type := l_return_type_code;
933: x_return_type_id := l_return_type_id;
934: x_sequence_number := l_sequence_number;
935: x_return_status := fnd_api.g_ret_sts_success;
936:
937: --- setting global variables used by Rules simulator and trace execution forms
938:
939: IF l_return_type_code = 'S' THEN

Line 1005: WHEN fnd_api.g_exc_error THEN

1001:
1002: End if;
1003: Exception
1004:
1005: WHEN fnd_api.g_exc_error THEN
1006: x_return_status := fnd_api.g_ret_sts_error;
1007: If cur_stg_selection%ISOPEN then
1008: CLOSE cur_stg_selection;
1009: End if;

Line 1006: x_return_status := fnd_api.g_ret_sts_error;

1002: End if;
1003: Exception
1004:
1005: WHEN fnd_api.g_exc_error THEN
1006: x_return_status := fnd_api.g_ret_sts_error;
1007: If cur_stg_selection%ISOPEN then
1008: CLOSE cur_stg_selection;
1009: End if;
1010:

Line 1018: WHEN fnd_api.g_exc_unexpected_error THEN

1014: ,p_data => x_msg_data);
1015: log_error(l_api_name, 'error', 'Error in selection Criteria - ' ||
1016: x_msg_data);
1017: --
1018: WHEN fnd_api.g_exc_unexpected_error THEN
1019: x_return_status := fnd_api.g_ret_sts_unexp_error;
1020:
1021: If cur_stg_selection%ISOPEN then
1022: CLOSE cur_stg_selection;

Line 1019: x_return_status := fnd_api.g_ret_sts_unexp_error;

1015: log_error(l_api_name, 'error', 'Error in selection Criteria - ' ||
1016: x_msg_data);
1017: --
1018: WHEN fnd_api.g_exc_unexpected_error THEN
1019: x_return_status := fnd_api.g_ret_sts_unexp_error;
1020:
1021: If cur_stg_selection%ISOPEN then
1022: CLOSE cur_stg_selection;
1023: End if;

Line 1034: x_return_status := fnd_api.g_ret_sts_unexp_error;

1030: WHEN OTHERS THEN
1031: if l_debug = 1 then
1032: log_event(l_api_name,'',' Exception in selection Criteria');
1033: end if;
1034: x_return_status := fnd_api.g_ret_sts_unexp_error;
1035:
1036: If cur_stg_selection%ISOPEN then
1037: CLOSE cur_stg_selection;
1038: End if;

Line 1206: if x_return_status = fnd_api.g_ret_sts_success then

1202: ,l_return_type_code
1203: ,l_return_type_id
1204: );
1205: -- leave the actual procedure, if stub procedure already found a strategy
1206: if x_return_status = fnd_api.g_ret_sts_success then
1207: log_event(l_api_name,'custom Type is d', l_return_type_code);
1208: log_event(l_api_name,'custom strategyRule/Value found', l_return_type_id);
1209: --- reassign the l_strategy_id to the new variables
1210: x_return_type := l_return_type_code;

Line 1215: elsif x_return_status = fnd_api.g_ret_sts_unexp_error then

1211: x_return_type_id := l_return_type_id;
1212: x_sequence_number := 0;
1213: return;
1214: -- leave the actual procedure, if stub procedure got an unexpected error
1215: elsif x_return_status = fnd_api.g_ret_sts_unexp_error then
1216: raise fnd_api.g_exc_unexpected_error;
1217: -- continue strategy search, if stub procedure didn't find strategy already
1218: elsif x_return_status = fnd_api.g_ret_sts_error then
1219: -- Re-Initialize API return status to success

Line 1216: raise fnd_api.g_exc_unexpected_error;

1212: x_sequence_number := 0;
1213: return;
1214: -- leave the actual procedure, if stub procedure got an unexpected error
1215: elsif x_return_status = fnd_api.g_ret_sts_unexp_error then
1216: raise fnd_api.g_exc_unexpected_error;
1217: -- continue strategy search, if stub procedure didn't find strategy already
1218: elsif x_return_status = fnd_api.g_ret_sts_error then
1219: -- Re-Initialize API return status to success
1220: x_return_status := fnd_api.g_ret_sts_success;

Line 1218: elsif x_return_status = fnd_api.g_ret_sts_error then

1214: -- leave the actual procedure, if stub procedure got an unexpected error
1215: elsif x_return_status = fnd_api.g_ret_sts_unexp_error then
1216: raise fnd_api.g_exc_unexpected_error;
1217: -- continue strategy search, if stub procedure didn't find strategy already
1218: elsif x_return_status = fnd_api.g_ret_sts_error then
1219: -- Re-Initialize API return status to success
1220: x_return_status := fnd_api.g_ret_sts_success;
1221: -- every other return status seems to be unexpected: leave
1222: else

Line 1220: x_return_status := fnd_api.g_ret_sts_success;

1216: raise fnd_api.g_exc_unexpected_error;
1217: -- continue strategy search, if stub procedure didn't find strategy already
1218: elsif x_return_status = fnd_api.g_ret_sts_error then
1219: -- Re-Initialize API return status to success
1220: x_return_status := fnd_api.g_ret_sts_success;
1221: -- every other return status seems to be unexpected: leave
1222: else
1223: fnd_message.set_name('WMS','WMS_INVALID_RETURN_STATUS');
1224: -- WMS_re_Custom_PUB.SearchForStrategy returned wrong status

Line 1227: raise fnd_api.g_exc_unexpected_error;

1223: fnd_message.set_name('WMS','WMS_INVALID_RETURN_STATUS');
1224: -- WMS_re_Custom_PUB.SearchForStrategy returned wrong status
1225: fnd_msg_pub.add;
1226: log_error_msg(l_api_name, 'bad_return_status');
1227: raise fnd_api.g_exc_unexpected_error;
1228: end if;
1229: ---- end of Bug # 2935052 -----
1230: if l_debug = 1 then
1231: log_event(l_api_name,'','Start');

Line 1236: if fnd_api.to_boolean( p_init_msg_list ) then

1232: log_event(l_api_name,'MMTT line id: ', to_char(p_transaction_temp_id));
1233: end if;
1234:
1235: -- Initialize message list if p_init_msg_list is set to TRUE
1236: if fnd_api.to_boolean( p_init_msg_list ) then
1237: fnd_msg_pub.initialize;
1238: end if;
1239: -- Initialize API return status to success
1240: x_return_status := fnd_api.g_ret_sts_success;

Line 1240: x_return_status := fnd_api.g_ret_sts_success;

1236: if fnd_api.to_boolean( p_init_msg_list ) then
1237: fnd_msg_pub.initialize;
1238: end if;
1239: -- Initialize API return status to success
1240: x_return_status := fnd_api.g_ret_sts_success;
1241:
1242: open cur_mmt;
1243: fetch cur_mmt into l_rec_mtrl;
1244:

Line 1336: x_return_status := fnd_api.g_ret_sts_success;

1332: IF p_type_code = 5 THEN
1333: wms_search_order_globals_pvt.g_costgroup_strategy_id := -999;
1334: wms_search_order_globals_pvt.g_costgroup_seq_num := -999;
1335: END IF;
1336: x_return_status := fnd_api.g_ret_sts_success;
1337: End if;
1338:
1339: If (cur_stg_selection%FOUND) Then
1340: x_return_type := l_return_type_code;

Line 1343: x_return_status := fnd_api.g_ret_sts_success;

1339: If (cur_stg_selection%FOUND) Then
1340: x_return_type := l_return_type_code;
1341: x_return_type_id := l_return_type_id;
1342: x_sequence_number := l_sequence_number;
1343: x_return_status := fnd_api.g_ret_sts_success;
1344:
1345: if l_debug = 1 then
1346: log_event(l_api_name, '',' Open/fetching stg_selection cursor');
1347: end if;

Line 1378: WHEN fnd_api.g_exc_error THEN

1374: CLOSE cur_stg_selection;
1375: END IF; --Added ofr 3224420
1376: End if;
1377: Exception
1378: WHEN fnd_api.g_exc_error THEN
1379: x_return_status := fnd_api.g_ret_sts_error;
1380: IF cur_mmt%ISOPEN then
1381: CLOSE cur_mmt;
1382: End if;

Line 1379: x_return_status := fnd_api.g_ret_sts_error;

1375: END IF; --Added ofr 3224420
1376: End if;
1377: Exception
1378: WHEN fnd_api.g_exc_error THEN
1379: x_return_status := fnd_api.g_ret_sts_error;
1380: IF cur_mmt%ISOPEN then
1381: CLOSE cur_mmt;
1382: End if;
1383:

Line 1392: WHEN fnd_api.g_exc_unexpected_error THEN

1388: ( p_count => x_msg_count
1389: ,p_data => x_msg_data);
1390: log_error(l_api_name, 'error', 'Error in selection Criteria - ' ||
1391: x_msg_data);
1392: WHEN fnd_api.g_exc_unexpected_error THEN
1393: x_return_status := fnd_api.g_ret_sts_unexp_error;
1394: IF cur_mmt%ISOPEN then
1395: CLOSE cur_mmt;
1396: End if;

Line 1393: x_return_status := fnd_api.g_ret_sts_unexp_error;

1389: ,p_data => x_msg_data);
1390: log_error(l_api_name, 'error', 'Error in selection Criteria - ' ||
1391: x_msg_data);
1392: WHEN fnd_api.g_exc_unexpected_error THEN
1393: x_return_status := fnd_api.g_ret_sts_unexp_error;
1394: IF cur_mmt%ISOPEN then
1395: CLOSE cur_mmt;
1396: End if;
1397:

Line 1416: x_return_status := fnd_api.g_ret_sts_unexp_error;

1412:
1413: if l_debug = 1 then
1414: log_event(l_api_name,'',' Exception in selection Criteria');
1415: end if;
1416: x_return_status := fnd_api.g_ret_sts_unexp_error;
1417:
1418: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) then
1419: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1420: end if;

Line 1845: x_return_status := fnd_api.g_ret_sts_success;

1841: ORDER BY sequence_number;
1842:
1843: BEGIN
1844: -- Initialize the return status
1845: x_return_status := fnd_api.g_ret_sts_success;
1846:
1847: OPEN cur_crossdock_value_selection;
1848: FETCH cur_crossdock_value_selection INTO l_return_type_code, l_return_type_id, l_sequence_number;
1849:

Line 1871: WHEN fnd_api.g_exc_error THEN

1867: END IF;
1868:
1869: EXCEPTION
1870:
1871: WHEN fnd_api.g_exc_error THEN
1872: x_return_status := fnd_api.g_ret_sts_error;
1873: If cur_crossdock_value_selection%ISOPEN then
1874: CLOSE cur_crossdock_value_selection;
1875: End if;

Line 1872: x_return_status := fnd_api.g_ret_sts_error;

1868:
1869: EXCEPTION
1870:
1871: WHEN fnd_api.g_exc_error THEN
1872: x_return_status := fnd_api.g_ret_sts_error;
1873: If cur_crossdock_value_selection%ISOPEN then
1874: CLOSE cur_crossdock_value_selection;
1875: End if;
1876:

Line 1882: WHEN fnd_api.g_exc_unexpected_error THEN

1878: ( p_count => l_msg_count
1879: ,p_data => l_msg_data);
1880: log_error(l_api_name, 'error', 'Error in Cross selection Criteria - ' ||l_msg_data);
1881:
1882: WHEN fnd_api.g_exc_unexpected_error THEN
1883: x_return_status := fnd_api.g_ret_sts_unexp_error;
1884: If cur_crossdock_value_selection%ISOPEN then
1885: CLOSE cur_crossdock_value_selection;
1886: End if;

Line 1883: x_return_status := fnd_api.g_ret_sts_unexp_error;

1879: ,p_data => l_msg_data);
1880: log_error(l_api_name, 'error', 'Error in Cross selection Criteria - ' ||l_msg_data);
1881:
1882: WHEN fnd_api.g_exc_unexpected_error THEN
1883: x_return_status := fnd_api.g_ret_sts_unexp_error;
1884: If cur_crossdock_value_selection%ISOPEN then
1885: CLOSE cur_crossdock_value_selection;
1886: End if;
1887: fnd_msg_pub.Count_And_Get

Line 1896: x_return_status := fnd_api.g_ret_sts_unexp_error;

1892: WHEN OTHERS THEN
1893: if l_debug = 1 then
1894: log_event(l_api_name,'',' Exception in cross selection Criteria');
1895: end if;
1896: x_return_status := fnd_api.g_ret_sts_unexp_error;
1897:
1898: If cur_crossdock_value_selection%ISOPEN then
1899: CLOSE cur_crossdock_value_selection;
1900: End if;