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_PR_PICK_SLIP_NUMBER dependencies on INV_LOG_UTIL

Line 105: inv_log_util.trace('Exception: ' || SQLERRM,'INV_PR_PICK_SLIP_NUMBER.INSERT_KEY',3);

101: EXCEPTION
102: WHEN OTHERS THEN
103: x_error_message := 'Error occurred in INV_PR_PICK_NUMBER.INSERT_KEY';
104: IF g_trace_on = 1 THEN
105: inv_log_util.trace('Exception: ' || SQLERRM,'INV_PR_PICK_SLIP_NUMBER.INSERT_KEY',3);
106: END IF;
107: END insert_key;
108:
109: --

Line 265: inv_log_util.trace('Exception: ' || SQLERRM,'INV_PR_PICK_SLIP_NUMBER.CREATE_HASH',3);

261: EXCEPTION
262: WHEN OTHERS THEN
263: x_error_message := 'Error occurred in INV_PR_PICK_NUMBER.CREATE_HASH';
264: IF g_trace_on = 1 THEN
265: inv_log_util.trace('Exception: ' || SQLERRM,'INV_PR_PICK_SLIP_NUMBER.CREATE_HASH',3);
266: END IF;
267: END create_hash;
268:
269: --

Line 570: inv_log_util.trace('Exception: ' || SQLERRM,'INV_PR_PICK_SLIP_NUMBER.GET_PICK_SLIP_NUMBER',3);

566: EXCEPTION
567: WHEN OTHERS THEN
568: x_error_message := 'Error occurred in INV_PR_PICK_NUMBER.GET_PICK_SLIP_NUMBER';
569: IF g_trace_on = 1 THEN
570: inv_log_util.trace('Exception: ' || SQLERRM,'INV_PR_PICK_SLIP_NUMBER.GET_PICK_SLIP_NUMBER',3);
571: END IF;
572: x_api_status := fnd_api.g_ret_sts_unexp_error;
573: END get_pick_slip_number;
574:

Line 607: inv_log_util.trace('Exception: ' || SQLERRM,'INV_PR_PICK_SLIP_NUMBER.INSERT_KEY',3);

603: EXCEPTION
604: WHEN OTHERS THEN
605: x_error_message := 'Error occurred in INV_PR_PICK_NUMBER.INSERT_KEY';
606: IF g_trace_on = 1 THEN
607: inv_log_util.trace('Exception: ' || SQLERRM,'INV_PR_PICK_SLIP_NUMBER.INSERT_KEY',3);
608: END IF;
609: END insert_key;
610:
611: --

Line 746: inv_log_util.trace('Exception: ' || SQLERRM,'INV_PR_PICK_SLIP_NUMBER.CREATE_HASH',3);

742: EXCEPTION
743: WHEN OTHERS THEN
744: x_error_message := 'Error occurred in INV_PR_PICK_NUMBER.CREATE_HASH';
745: IF g_trace_on = 1 THEN
746: inv_log_util.trace('Exception: ' || SQLERRM,'INV_PR_PICK_SLIP_NUMBER.CREATE_HASH',3);
747: END IF;
748: END create_hash;
749:
750: --

Line 957: inv_log_util.trace('Exception: ' || SQLERRM,'INV_PR_PICK_SLIP_NUMBER.GET_PICK_SLIP_NUMBER',3);

953: EXCEPTION
954: WHEN OTHERS THEN
955: x_error_message := 'Error occurred in INV_PR_PICK_NUMBER.GET_PICK_SLIP_NUMBER';
956: IF g_trace_on = 1 THEN
957: inv_log_util.trace('Exception: ' || SQLERRM,'INV_PR_PICK_SLIP_NUMBER.GET_PICK_SLIP_NUMBER',3);
958: END IF;
959: x_api_status := fnd_api.g_ret_sts_unexp_error;
960: END get_pick_slip_number;
961:

Line 1028: inv_log_util.trace('Exception: ' || SQLERRM,'INV_PR_PICK_SLIP_NUMBER.DELETE_WIP_PS_TBL', 3);

1024: BEGIN
1025: g_wip_pskey_table.DELETE;
1026: EXCEPTION
1027: WHEN OTHERS THEN
1028: inv_log_util.trace('Exception: ' || SQLERRM,'INV_PR_PICK_SLIP_NUMBER.DELETE_WIP_PS_TBL', 3);
1029: END delete_wip_ps_tbl;
1030:
1031: -- /* For Parallel Pick-Release */
1032: -- Name

Line 1164: inv_log_util.trace('Exception: ' || SQLERRM,'INV_PR_PICK_SLIP_NUMBER.CREATE_PICK_SLIP_STRING',3);

1160: EXCEPTION
1161: WHEN OTHERS THEN
1162: x_error_message := 'Error occurred in INV_PR_PICK_NUMBER.CREATE_PICK_SLIP_STRING';
1163: IF g_trace_on = 1 THEN
1164: inv_log_util.trace('Exception: ' || SQLERRM,'INV_PR_PICK_SLIP_NUMBER.CREATE_PICK_SLIP_STRING',3);
1165: END IF;
1166: END create_pick_slip_string;
1167:
1168: -- /* For Parallel Pick-Release */

Line 1208: inv_log_util.trace('p_hash_string = ' || p_hash_string,

1204: x_api_status := fnd_api.g_ret_sts_success;
1205: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1206:
1207: IF (l_debug = 1) THEN
1208: inv_log_util.trace('p_hash_string = ' || p_hash_string,
1209: 'INV_PR_PICK_SLIP_NUMBER.GEN_PARALLEL_PICK_SLIP_NUMBER', 3);
1210: inv_log_util.trace('p_limit = ' || p_limit,
1211: 'INV_PR_PICK_SLIP_NUMBER.GEN_PARALLEL_PICK_SLIP_NUMBER', 3);
1212: END IF;

Line 1210: inv_log_util.trace('p_limit = ' || p_limit,

1206:
1207: IF (l_debug = 1) THEN
1208: inv_log_util.trace('p_hash_string = ' || p_hash_string,
1209: 'INV_PR_PICK_SLIP_NUMBER.GEN_PARALLEL_PICK_SLIP_NUMBER', 3);
1210: inv_log_util.trace('p_limit = ' || p_limit,
1211: 'INV_PR_PICK_SLIP_NUMBER.GEN_PARALLEL_PICK_SLIP_NUMBER', 3);
1212: END IF;
1213:
1214: l_success := FALSE;

Line 1240: inv_log_util.trace('l_num_attempts = ' || l_num_attempts,

1236: -- exit loop
1237: -- exception others
1238: -- exit loop
1239: IF (l_debug = 1) THEN
1240: inv_log_util.trace('l_num_attempts = ' || l_num_attempts,
1241: 'INV_PR_PICK_SLIP_NUMBER.GEN_PARALLEL_PICK_SLIP_NUMBER', 3);
1242: END IF;
1243: BEGIN
1244: INSERT INTO mtl_pick_slip_numbers

Line 1262: inv_log_util.trace('Inserted pick slip # ' || l_pick_slip_number,

1258: RETURNING pick_slip_number
1259: INTO l_pick_slip_number;
1260:
1261: IF (l_debug = 1) THEN
1262: inv_log_util.trace('Inserted pick slip # ' || l_pick_slip_number,
1263: 'INV_PR_PICK_SLIP_NUMBER.GEN_PARALLEL_PICK_SLIP_NUMBER', 3);
1264: END IF;
1265: l_success := TRUE;
1266: EXCEPTION

Line 1270: inv_log_util.trace('INSERT failed, row already exists',

1266: EXCEPTION
1267: -- {
1268: WHEN unique_constraint_exc THEN
1269: IF (l_debug = 1) THEN
1270: inv_log_util.trace('INSERT failed, row already exists',
1271: 'INV_PR_PICK_SLIP_NUMBER.GEN_PARALLEL_PICK_SLIP_NUMBER', 3);
1272: END IF;
1273: BEGIN
1274: SELECT pick_slip_number

Line 1286: inv_log_util.trace('Locked row, pick slip # is ' || l_pick_slip_number

1282:
1283: l_success := TRUE;
1284:
1285: IF (l_debug = 1) THEN
1286: inv_log_util.trace('Locked row, pick slip # is ' || l_pick_slip_number
1287: || ', pick slip count is ' || l_pick_slip_count,
1288: 'INV_PR_PICK_SLIP_NUMBER.GEN_PARALLEL_PICK_SLIP_NUMBER', 3);
1289: END IF;
1290: EXCEPTION

Line 1293: inv_log_util.trace('Timeout waiting for lock',

1289: END IF;
1290: EXCEPTION
1291: WHEN wait_timeout_exc THEN
1292: IF (l_debug = 1) THEN
1293: inv_log_util.trace('Timeout waiting for lock',
1294: 'INV_PR_PICK_SLIP_NUMBER.GEN_PARALLEL_PICK_SLIP_NUMBER', 3);
1295: END IF;
1296: l_success := FALSE;
1297: WHEN NO_DATA_FOUND THEN

Line 1299: inv_log_util.trace('No data found, so retrying INSERT',

1295: END IF;
1296: l_success := FALSE;
1297: WHEN NO_DATA_FOUND THEN
1298: IF (l_debug = 1) THEN
1299: inv_log_util.trace('No data found, so retrying INSERT',
1300: 'INV_PR_PICK_SLIP_NUMBER.GEN_PARALLEL_PICK_SLIP_NUMBER', 3);
1301: END IF;
1302: l_success := FALSE;
1303: WHEN OTHERS THEN

Line 1305: inv_log_util.trace('Other exception: ' || sqlerrm,

1301: END IF;
1302: l_success := FALSE;
1303: WHEN OTHERS THEN
1304: IF (l_debug = 1) THEN
1305: inv_log_util.trace('Other exception: ' || sqlerrm,
1306: 'INV_PR_PICK_SLIP_NUMBER.GEN_PARALLEL_PICK_SLIP_NUMBER', 3);
1307: END IF;
1308: l_success := FALSE;
1309: EXIT;

Line 1313: inv_log_util.trace('Other exception: ' || sqlerrm,

1309: EXIT;
1310: END;
1311: WHEN OTHERS THEN
1312: IF (l_debug = 1) THEN
1313: inv_log_util.trace('Other exception: ' || sqlerrm,
1314: 'INV_PR_PICK_SLIP_NUMBER.GEN_PARALLEL_PICK_SLIP_NUMBER', 3);
1315: END IF;
1316: l_success := FALSE;
1317: EXIT;

Line 1330: inv_log_util.trace('Failed to INSERT or LOCK pick slip record. Returning next value: '

1326: INTO l_pick_slip_number
1327: FROM dual;
1328: l_pick_slip_status := 2;
1329: IF (l_debug = 1) THEN
1330: inv_log_util.trace('Failed to INSERT or LOCK pick slip record. Returning next value: '
1331: || l_pick_slip_number,
1332: 'INV_PR_PICK_SLIP_NUMBER.GEN_PARALLEL_PICK_SLIP_NUMBER', 3);
1333: END IF;
1334: ELSE

Line 1345: inv_log_util.trace('Updated count to ' || l_pick_slip_count ||

1341: WHERE pick_slip_identifier = p_hash_string
1342: AND status = 1
1343: RETURNING pick_slip_count INTO l_pick_slip_count;
1344: IF (l_debug = 1) AND SQL%FOUND THEN
1345: inv_log_util.trace('Updated count to ' || l_pick_slip_count ||
1346: ', status to ' || l_pick_slip_status,
1347: 'INV_PR_PICK_SLIP_NUMBER.GEN_PARALLEL_PICK_SLIP_NUMBER', 3);
1348: END IF;
1349: END IF;

Line 1361: inv_log_util.trace('Exception: ' || SQLERRM,

1357: WHEN OTHERS THEN
1358: x_error_message := 'Error occurred in GEN_PARALLEL_PICK_SLIP_NUMBER';
1359: x_api_status := fnd_api.g_ret_sts_unexp_error;
1360: IF (l_debug = 1) THEN
1361: inv_log_util.trace('Exception: ' || SQLERRM,
1362: 'INV_PR_PICK_SLIP_NUMBER.GEN_PARALLEL_PICK_SLIP_NUMBER',3);
1363: END IF;
1364: END gen_parallel_pick_slip_number;
1365:

Line 1597: inv_log_util.trace('Exception: ' || SQLERRM,'INV_PR_PICK_SLIP_NUMBER.GET_PICK_SLIP_NUMBER',3);

1593: EXCEPTION
1594: WHEN OTHERS THEN
1595: x_error_message := 'Error occurred in INV_PR_PICK_SLIP_NUMBER.GET_PICK_SLIP_NUMBER';
1596: IF g_trace_on = 1 THEN
1597: inv_log_util.trace('Exception: ' || SQLERRM,'INV_PR_PICK_SLIP_NUMBER.GET_PICK_SLIP_NUMBER',3);
1598: END IF;
1599: x_api_status := fnd_api.g_ret_sts_unexp_error;
1600:
1601: END get_pick_slip_number_parallel;