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 401: x_return_status := fnd_api.g_ret_sts_success;

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

Line 1133: x_return_status := fnd_api.g_ret_sts_success;

1129: --Must call wms_return_sv.txn_complete to take care of deleting
1130: --reservations for non-express case.
1131: IF l_transaction_type in ('CORRECT','RETURN TO VENDOR','RETURN TO RECEIVING','RETURN TO CUSTOMER') THEN
1132:
1133: x_return_status := fnd_api.g_ret_sts_success;
1134: wms_return_sv.txn_complete(
1135: p_group_id => p_group_id,
1136: p_txn_status => p_txn_status,
1137: p_txn_mode => p_txn_mode,

Line 1142: IF ( x_return_status = fnd_api.g_ret_sts_error OR

1138: x_return_status => x_return_status,
1139: x_msg_data => x_msg_data,
1140: x_msg_count => x_msg_count);
1141:
1142: IF ( x_return_status = fnd_api.g_ret_sts_error OR
1143: x_return_status = fnd_api.g_ret_sts_unexp_error ) THEN
1144: IF (l_debug = 1) THEN
1145: print_debug('Error return from wms_return_sv.txn_complete, exitting - '||x_msg_data||' : 101',1);
1146: END IF;

Line 1143: x_return_status = fnd_api.g_ret_sts_unexp_error ) THEN

1139: x_msg_data => x_msg_data,
1140: x_msg_count => x_msg_count);
1141:
1142: IF ( x_return_status = fnd_api.g_ret_sts_error OR
1143: x_return_status = fnd_api.g_ret_sts_unexp_error ) THEN
1144: IF (l_debug = 1) THEN
1145: print_debug('Error return from wms_return_sv.txn_complete, exitting - '||x_msg_data||' : 101',1);
1146: END IF;
1147: IF p_txn_mode <> 'ONLINE' THEN

Line 1151: IF x_return_status = fnd_api.g_ret_sts_error THEN

1147: IF p_txn_mode <> 'ONLINE' THEN
1148: create_errors(p_group_id => p_group_id,
1149: p_msg => 'inv_receiving_transaction.txn_complete - 102 -'||x_msg_data);
1150: END IF;
1151: IF x_return_status = fnd_api.g_ret_sts_error THEN
1152: RAISE fnd_api.g_exc_error;
1153: ELSE
1154: RAISE fnd_api.g_exc_unexpected_error;
1155: END IF;

Line 1152: RAISE fnd_api.g_exc_error;

1148: create_errors(p_group_id => p_group_id,
1149: p_msg => 'inv_receiving_transaction.txn_complete - 102 -'||x_msg_data);
1150: END IF;
1151: IF x_return_status = fnd_api.g_ret_sts_error THEN
1152: RAISE fnd_api.g_exc_error;
1153: ELSE
1154: RAISE fnd_api.g_exc_unexpected_error;
1155: END IF;
1156: END IF;

Line 1154: RAISE fnd_api.g_exc_unexpected_error;

1150: END IF;
1151: IF x_return_status = fnd_api.g_ret_sts_error THEN
1152: RAISE fnd_api.g_exc_error;
1153: ELSE
1154: RAISE fnd_api.g_exc_unexpected_error;
1155: END IF;
1156: END IF;
1157:
1158: x_return_status := fnd_api.g_ret_sts_success;

Line 1158: x_return_status := fnd_api.g_ret_sts_success;

1154: RAISE fnd_api.g_exc_unexpected_error;
1155: END IF;
1156: END IF;
1157:
1158: x_return_status := fnd_api.g_ret_sts_success;
1159:
1160: END IF; --IF l_transaction_type in ('CORRECT','RETURN TO VENDOR','RETURN TO RECEIVING','RETURN TO CUSTOMER') THEN
1161:
1162: END IF; --IF (p_txn_status = 'FALSE') THEN

Line 1179: WHEN fnd_api.g_exc_error THEN

1175: AND operation_mode = -99999;
1176:
1177: --End bug 4611237
1178: EXCEPTION
1179: WHEN fnd_api.g_exc_error THEN
1180: IF (l_debug = 1) THEN
1181: print_debug('Execution error in txn_complete',4);
1182: END IF;
1183: x_return_status := fnd_api.g_ret_sts_error;

Line 1183: x_return_status := fnd_api.g_ret_sts_error;

1179: WHEN fnd_api.g_exc_error THEN
1180: IF (l_debug = 1) THEN
1181: print_debug('Execution error in txn_complete',4);
1182: END IF;
1183: x_return_status := fnd_api.g_ret_sts_error;
1184: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
1185:
1186: WHEN fnd_api.g_exc_unexpected_error THEN
1187: IF (l_debug = 1) THEN

Line 1186: WHEN fnd_api.g_exc_unexpected_error THEN

1182: END IF;
1183: x_return_status := fnd_api.g_ret_sts_error;
1184: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
1185:
1186: WHEN fnd_api.g_exc_unexpected_error THEN
1187: IF (l_debug = 1) THEN
1188: print_debug('Unexpected error in txn_complete',4);
1189: END IF;
1190: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1190: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1186: WHEN fnd_api.g_exc_unexpected_error THEN
1187: IF (l_debug = 1) THEN
1188: print_debug('Unexpected error in txn_complete',4);
1189: END IF;
1190: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1191: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
1192:
1193: WHEN OTHERS THEN
1194: IF (l_debug = 1) THEN

Line 1197: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1193: WHEN OTHERS THEN
1194: IF (l_debug = 1) THEN
1195: print_debug('Exception in txn_complete',4);
1196: END IF;
1197: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1198: --
1199: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1200: THEN
1201: fnd_msg_pub.add_exc_msg

Line 1242: x_return_status := fnd_api.g_ret_sts_success;

1238:
1239: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1240: BEGIN
1241:
1242: x_return_status := fnd_api.g_ret_sts_success;
1243: IF (l_debug = 1) THEN
1244: print_debug('TXN_COMPLETE - Enter txn_complete : 10: '|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);
1245: print_debug('TXN_COMPLETE - Parameters passed : 10.1: p_group_id - '||p_group_id, 4);
1246: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Parameters passed : 10.1: p_rti_rec_count - '||p_rti_rec_count, 4);

Line 1288: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1284: l_wms_install_status := 'I';
1285: ELSE
1286: l_wms_install_status := 'U';
1287: END IF;
1288: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1289: IF (l_debug = 1) THEN
1290: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Could not get wms installed status, exitting - '||x_msg_data||' : 40',1);
1291: END IF;
1292: RAISE fnd_api.g_exc_error; --RETURN;

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

1288: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1289: IF (l_debug = 1) THEN
1290: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Could not get wms installed status, exitting - '||x_msg_data||' : 40',1);
1291: END IF;
1292: RAISE fnd_api.g_exc_error; --RETURN;
1293: END IF;
1294:
1295: IF l_wms_install_status = 'I' THEN
1296:

Line 1327: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1323: , x_return_status =>x_return_status
1324: , x_msg_count =>x_msg_count
1325: , x_msg_data =>x_msg_data
1326: );
1327: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1328: IF (l_debug = 1) THEN
1329: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Could not archive tasks, exiting - '||x_msg_data||' : 105',1);
1330: END IF;
1331: END IF;

Line 1432: WHEN fnd_api.g_exc_error THEN

1428: END IF;
1429: END IF; --IF (l_patch_j_code = FALSE) THEN
1430:
1431: EXCEPTION
1432: WHEN fnd_api.g_exc_error THEN
1433: IF (l_debug = 1) THEN
1434: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Execution error in TXN_MOBILE_TIMEOUT_CLEANUP',4);
1435: END IF;
1436: x_return_status := fnd_api.g_ret_sts_error;

Line 1436: x_return_status := fnd_api.g_ret_sts_error;

1432: WHEN fnd_api.g_exc_error THEN
1433: IF (l_debug = 1) THEN
1434: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Execution error in TXN_MOBILE_TIMEOUT_CLEANUP',4);
1435: END IF;
1436: x_return_status := fnd_api.g_ret_sts_error;
1437: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
1438:
1439: WHEN fnd_api.g_exc_unexpected_error THEN
1440: IF (l_debug = 1) THEN

Line 1439: WHEN fnd_api.g_exc_unexpected_error THEN

1435: END IF;
1436: x_return_status := fnd_api.g_ret_sts_error;
1437: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
1438:
1439: WHEN fnd_api.g_exc_unexpected_error THEN
1440: IF (l_debug = 1) THEN
1441: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Unexpected error in TXN_MOBILE_TIMEOUT_CLEANUP',4);
1442: END IF;
1443: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1443: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1439: WHEN fnd_api.g_exc_unexpected_error THEN
1440: IF (l_debug = 1) THEN
1441: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Unexpected error in TXN_MOBILE_TIMEOUT_CLEANUP',4);
1442: END IF;
1443: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1444: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
1445:
1446: WHEN OTHERS THEN
1447: IF (l_debug = 1) THEN

Line 1450: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1446: WHEN OTHERS THEN
1447: IF (l_debug = 1) THEN
1448: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Exception in TXN_MOBILE_TIMEOUT_CLEANUP',4);
1449: END IF;
1450: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1451: --
1452: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1453: THEN
1454: fnd_msg_pub.add_exc_msg