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.INV_RECEIVING_TRANSACTION dependencies on FND_API

Line 121: x_return_status := FND_API.G_RET_STS_SUCCESS;

117: WHERE wlh.source_header_id = p_group_id;
118:
119: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
120: BEGIN
121: x_return_status := FND_API.G_RET_STS_SUCCESS;
122: IF (l_debug = 1) THEN
123: print_debug('rcv_txn_clean_up entered 10'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);
124: print_debug('rcv_txn_clean_up 10.1: Parameters passed : p_group_id - '||p_group_id, 4);
125: END IF;

Line 232: IF x_return_status <> fnd_api.g_ret_sts_success THEN

228: p_match_mtl_status => NULL
229: );
230: end if;
231:
232: IF x_return_status <> fnd_api.g_ret_sts_success THEN
233: IF (l_debug = 1) THEN
234: print_debug('rcv_txn_clean_up 30: Could not undo the pack/unpack changes, exitting - '||x_msg_data,1);
235: END IF;
236: RAISE FND_API.g_exc_error; --RETURN;

Line 236: RAISE FND_API.g_exc_error; --RETURN;

232: IF x_return_status <> fnd_api.g_ret_sts_success THEN
233: IF (l_debug = 1) THEN
234: print_debug('rcv_txn_clean_up 30: Could not undo the pack/unpack changes, exitting - '||x_msg_data,1);
235: END IF;
236: RAISE FND_API.g_exc_error; --RETURN;
237: END IF;
238: IF (l_debug = 1) THEN
239: print_debug('rcv_txn_clean_up 30.1: pack/unpack done',1);
240: END IF;

Line 355: WHEN FND_API.g_exc_error THEN

351: END IF;
352:
353: EXCEPTION
354:
355: WHEN FND_API.g_exc_error THEN
356: IF (l_debug = 1) THEN
357: print_debug('rcv_txn_clean_up: Execution error',4);
358: END IF;
359: ROLLBACK TO rcv_cleanup_sp;

Line 362: x_return_status := FND_API.G_RET_STS_ERROR;

358: END IF;
359: ROLLBACK TO rcv_cleanup_sp;
360: CLOSE lpn_pack_histroy_cur;
361:
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
364:
365: WHEN OTHERS THEN
366: IF (l_debug = 1) THEN

Line 372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

368: END IF;
369: ROLLBACK TO rcv_cleanup_sp;
370: CLOSE lpn_pack_histroy_cur;
371:
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373:
374: IF SQLCODE IS NOT NULL THEN
375: inv_mobile_helper_functions.sql_error('inv_receiving_transaction.rcv_txn_clean_up', l_progress, SQLCODE);
376: IF (l_debug = 1) THEN

Line 400: x_return_status := fnd_api.g_ret_sts_success;

396: l_txn_mode_code VARCHAR2(25);--BUG 5090595
397:
398: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
399: BEGIN
400: x_return_status := fnd_api.g_ret_sts_success;
401: IF (l_debug = 1) THEN
402: print_debug('TXN_COMPLETE - Enter txn_complete : 10: '|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);
403: print_debug('TXN_COMPLETE - Parameters passed : 10.1: p_group_id - '||p_group_id, 4);
404: print_debug('TXN_COMPLETE - Parameters passed : 10.2: p_txn_status - '||p_txn_status, 4);

Line 891: x_return_status := fnd_api.g_ret_sts_success;

887: --Must call wms_return_sv.txn_complete to take care of deleting
888: --reservations for non-express case.
889: IF l_transaction_type in ('CORRECT','RETURN TO VENDOR','RETURN TO RECEIVING','RETURN TO CUSTOMER') THEN
890:
891: x_return_status := fnd_api.g_ret_sts_success;
892: wms_return_sv.txn_complete(
893: p_group_id => p_group_id,
894: p_txn_status => p_txn_status,
895: p_txn_mode => p_txn_mode,

Line 900: IF ( x_return_status = fnd_api.g_ret_sts_error OR

896: x_return_status => x_return_status,
897: x_msg_data => x_msg_data,
898: x_msg_count => x_msg_count);
899:
900: IF ( x_return_status = fnd_api.g_ret_sts_error OR
901: x_return_status = fnd_api.g_ret_sts_unexp_error ) THEN
902: IF (l_debug = 1) THEN
903: print_debug('Error return from wms_return_sv.txn_complete, exitting - '||x_msg_data||' : 101',1);
904: END IF;

Line 901: x_return_status = fnd_api.g_ret_sts_unexp_error ) THEN

897: x_msg_data => x_msg_data,
898: x_msg_count => x_msg_count);
899:
900: IF ( x_return_status = fnd_api.g_ret_sts_error OR
901: x_return_status = fnd_api.g_ret_sts_unexp_error ) THEN
902: IF (l_debug = 1) THEN
903: print_debug('Error return from wms_return_sv.txn_complete, exitting - '||x_msg_data||' : 101',1);
904: END IF;
905: IF p_txn_mode <> 'ONLINE' THEN

Line 909: IF x_return_status = fnd_api.g_ret_sts_error THEN

905: IF p_txn_mode <> 'ONLINE' THEN
906: create_errors(p_group_id => p_group_id,
907: p_msg => 'inv_receiving_transaction.txn_complete - 102 -'||x_msg_data);
908: END IF;
909: IF x_return_status = fnd_api.g_ret_sts_error THEN
910: RAISE fnd_api.g_exc_error;
911: ELSE
912: RAISE fnd_api.g_exc_unexpected_error;
913: END IF;

Line 910: RAISE fnd_api.g_exc_error;

906: create_errors(p_group_id => p_group_id,
907: p_msg => 'inv_receiving_transaction.txn_complete - 102 -'||x_msg_data);
908: END IF;
909: IF x_return_status = fnd_api.g_ret_sts_error THEN
910: RAISE fnd_api.g_exc_error;
911: ELSE
912: RAISE fnd_api.g_exc_unexpected_error;
913: END IF;
914: END IF;

Line 912: RAISE fnd_api.g_exc_unexpected_error;

908: END IF;
909: IF x_return_status = fnd_api.g_ret_sts_error THEN
910: RAISE fnd_api.g_exc_error;
911: ELSE
912: RAISE fnd_api.g_exc_unexpected_error;
913: END IF;
914: END IF;
915:
916: x_return_status := fnd_api.g_ret_sts_success;

Line 916: x_return_status := fnd_api.g_ret_sts_success;

912: RAISE fnd_api.g_exc_unexpected_error;
913: END IF;
914: END IF;
915:
916: x_return_status := fnd_api.g_ret_sts_success;
917:
918: END IF; --IF l_transaction_type in ('CORRECT','RETURN TO VENDOR','RETURN TO RECEIVING','RETURN TO CUSTOMER') THEN
919:
920: END IF; --IF (p_txn_status = 'FALSE') THEN

Line 937: WHEN fnd_api.g_exc_error THEN

933: AND operation_mode = -99999;
934:
935: --End bug 4611237
936: EXCEPTION
937: WHEN fnd_api.g_exc_error THEN
938: IF (l_debug = 1) THEN
939: print_debug('Execution error in txn_complete',4);
940: END IF;
941: x_return_status := fnd_api.g_ret_sts_error;

Line 941: x_return_status := fnd_api.g_ret_sts_error;

937: WHEN fnd_api.g_exc_error THEN
938: IF (l_debug = 1) THEN
939: print_debug('Execution error in txn_complete',4);
940: END IF;
941: x_return_status := fnd_api.g_ret_sts_error;
942: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
943:
944: WHEN fnd_api.g_exc_unexpected_error THEN
945: IF (l_debug = 1) THEN

Line 944: WHEN fnd_api.g_exc_unexpected_error THEN

940: END IF;
941: x_return_status := fnd_api.g_ret_sts_error;
942: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
943:
944: WHEN fnd_api.g_exc_unexpected_error THEN
945: IF (l_debug = 1) THEN
946: print_debug('Unexpected error in txn_complete',4);
947: END IF;
948: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 948: x_return_status := fnd_api.g_ret_sts_unexp_error ;

944: WHEN fnd_api.g_exc_unexpected_error THEN
945: IF (l_debug = 1) THEN
946: print_debug('Unexpected error in txn_complete',4);
947: END IF;
948: x_return_status := fnd_api.g_ret_sts_unexp_error ;
949: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
950:
951: WHEN OTHERS THEN
952: IF (l_debug = 1) THEN

Line 955: x_return_status := fnd_api.g_ret_sts_unexp_error ;

951: WHEN OTHERS THEN
952: IF (l_debug = 1) THEN
953: print_debug('Exception in txn_complete',4);
954: END IF;
955: x_return_status := fnd_api.g_ret_sts_unexp_error ;
956: --
957: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
958: THEN
959: fnd_msg_pub.add_exc_msg

Line 1000: x_return_status := fnd_api.g_ret_sts_success;

996:
997: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
998: BEGIN
999:
1000: x_return_status := fnd_api.g_ret_sts_success;
1001: IF (l_debug = 1) THEN
1002: print_debug('TXN_COMPLETE - Enter txn_complete : 10: '|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);
1003: print_debug('TXN_COMPLETE - Parameters passed : 10.1: p_group_id - '||p_group_id, 4);
1004: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Parameters passed : 10.1: p_rti_rec_count - '||p_rti_rec_count, 4);

Line 1046: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1042: l_wms_install_status := 'I';
1043: ELSE
1044: l_wms_install_status := 'U';
1045: END IF;
1046: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1047: IF (l_debug = 1) THEN
1048: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Could not get wms installed status, exitting - '||x_msg_data||' : 40',1);
1049: END IF;
1050: RAISE fnd_api.g_exc_error; --RETURN;

Line 1050: RAISE fnd_api.g_exc_error; --RETURN;

1046: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1047: IF (l_debug = 1) THEN
1048: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Could not get wms installed status, exitting - '||x_msg_data||' : 40',1);
1049: END IF;
1050: RAISE fnd_api.g_exc_error; --RETURN;
1051: END IF;
1052:
1053: IF l_wms_install_status = 'I' THEN
1054:

Line 1085: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1081: , x_return_status =>x_return_status
1082: , x_msg_count =>x_msg_count
1083: , x_msg_data =>x_msg_data
1084: );
1085: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1086: IF (l_debug = 1) THEN
1087: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Could not archive tasks, exiting - '||x_msg_data||' : 105',1);
1088: END IF;
1089: END IF;

Line 1190: WHEN fnd_api.g_exc_error THEN

1186: END IF;
1187: END IF; --IF (l_patch_j_code = FALSE) THEN
1188:
1189: EXCEPTION
1190: WHEN fnd_api.g_exc_error THEN
1191: IF (l_debug = 1) THEN
1192: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Execution error in TXN_MOBILE_TIMEOUT_CLEANUP',4);
1193: END IF;
1194: x_return_status := fnd_api.g_ret_sts_error;

Line 1194: x_return_status := fnd_api.g_ret_sts_error;

1190: WHEN fnd_api.g_exc_error THEN
1191: IF (l_debug = 1) THEN
1192: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Execution error in TXN_MOBILE_TIMEOUT_CLEANUP',4);
1193: END IF;
1194: x_return_status := fnd_api.g_ret_sts_error;
1195: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
1196:
1197: WHEN fnd_api.g_exc_unexpected_error THEN
1198: IF (l_debug = 1) THEN

Line 1197: WHEN fnd_api.g_exc_unexpected_error THEN

1193: END IF;
1194: x_return_status := fnd_api.g_ret_sts_error;
1195: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
1196:
1197: WHEN fnd_api.g_exc_unexpected_error THEN
1198: IF (l_debug = 1) THEN
1199: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Unexpected error in TXN_MOBILE_TIMEOUT_CLEANUP',4);
1200: END IF;
1201: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1201: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1197: WHEN fnd_api.g_exc_unexpected_error THEN
1198: IF (l_debug = 1) THEN
1199: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Unexpected error in TXN_MOBILE_TIMEOUT_CLEANUP',4);
1200: END IF;
1201: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1202: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
1203:
1204: WHEN OTHERS THEN
1205: IF (l_debug = 1) THEN

Line 1208: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1204: WHEN OTHERS THEN
1205: IF (l_debug = 1) THEN
1206: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Exception in TXN_MOBILE_TIMEOUT_CLEANUP',4);
1207: END IF;
1208: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1209: --
1210: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1211: THEN
1212: fnd_msg_pub.add_exc_msg