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.WIP_BATCH_MOVE dependencies on WIP_LOGGER

Line 162: l_params wip_logger.param_tbl_t;

158: l_process_phase VARCHAR2(3);
159: l_return_status VARCHAR(1);
160: l_move_info c_move_info%ROWTYPE;
161: l_move_record move_record_pvt;
162: l_params wip_logger.param_tbl_t;
163: BEGIN
164: l_process_phase := '1';
165: -- write parameter value to log file
166: IF (l_log_level <= wip_constants.trace_logging) THEN

Line 182: wip_logger.entryPoint(p_procName => 'wip_batch_move.derive_move',

178: l_params(6).paramValue := p_default_step_type;
179: l_params(7).paramName := 'p_fm_step_type';
180: l_params(7).paramValue := p_fm_step_type;
181:
182: wip_logger.entryPoint(p_procName => 'wip_batch_move.derive_move',
183: p_params => l_params,
184: x_returnStatus => l_return_status);
185: END IF;
186:

Line 235: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',

231: x_return_status := fnd_api.g_ret_sts_success;
232:
233: -- write to the log file
234: IF (l_log_level <= wip_constants.trace_logging) THEN
235: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',
236: p_procReturnStatus => x_return_status,
237: p_msg => 'procedure complete',
238: x_returnStatus => l_return_status);
239: END IF;

Line 250: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',

246: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
247: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
248:
249: IF (l_log_level <= wip_constants.trace_logging) THEN
250: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',
251: p_procReturnStatus => x_return_status,
252: p_msg => l_error_msg,
253: x_returnStatus => l_return_status);
254: END IF;

Line 338: l_params wip_logger.param_tbl_t;

334: l_process_phase VARCHAR2(3);
335: l_return_status VARCHAR2(1);
336: l_scrap_info c_scrap_info%ROWTYPE;
337: l_scrap_record move_record_pvt;
338: l_params wip_logger.param_tbl_t;
339: BEGIN
340: l_process_phase := '1';
341: -- write parameter value to log file
342: IF (l_log_level <= wip_constants.trace_logging) THEN

Line 364: wip_logger.entryPoint(p_procName => 'wip_batch_move.derive_scrap',

360: l_params(9).paramValue := p_fm_step_type;
361: l_params(10).paramName := 'p_resp_key';
362: l_params(10).paramValue := p_resp_key;
363:
364: wip_logger.entryPoint(p_procName => 'wip_batch_move.derive_scrap',
365: p_params => l_params,
366: x_returnStatus => l_return_status);
367: END IF;
368:

Line 438: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_scrap',

434: x_return_status := fnd_api.g_ret_sts_success;
435:
436: -- write to the log file
437: IF (l_log_level <= wip_constants.trace_logging) THEN
438: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_scrap',
439: p_procReturnStatus => x_return_status,
440: p_msg => 'procedure complete',
441: x_returnStatus => l_return_status);
442: END IF;

Line 450: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_scrap',

446: IF(c_scrap_info%ISOPEN) THEN
447: CLOSE c_scrap_info;
448: END IF;
449: IF (l_log_level <= wip_constants.trace_logging) THEN
450: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_scrap',
451: p_procReturnStatus => x_return_status,
452: p_msg => l_error_msg,
453: x_returnStatus => l_return_status);
454: END IF;

Line 464: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_scrap',

460: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
461: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
462:
463: IF (l_log_level <= wip_constants.trace_logging) THEN
464: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_scrap',
465: p_procReturnStatus => x_return_status,
466: p_msg => l_error_msg,
467: x_returnStatus => l_return_status);
468: END IF;

Line 493: l_params wip_logger.param_tbl_t;

489: l_log_level NUMBER := fnd_log.g_current_runtime_level;
490: l_error_msg VARCHAR2(240);
491: l_process_phase VARCHAR2(3);
492: l_return_status VARCHAR2(1);
493: l_params wip_logger.param_tbl_t;
494: BEGIN
495: l_process_phase := '1';
496: -- write parameter value to log file
497: IF (l_log_level <= wip_constants.trace_logging) THEN

Line 521: wip_logger.entryPoint(p_procName => 'wip_batch_move.derive_row',

517: l_params(10).paramValue := p_fm_step_type;
518: l_params(11).paramName := 'p_resp_key';
519: l_params(11).paramValue := p_resp_key;
520:
521: wip_logger.entryPoint(p_procName => 'wip_batch_move.derive_row',
522: p_params => l_params,
523: x_returnStatus => l_return_status);
524: END IF;
525: l_process_phase := '2';

Line 568: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_row',

564:
565: x_return_status := fnd_api.g_ret_sts_success;
566: -- write to the log file
567: IF (l_log_level <= wip_constants.trace_logging) THEN
568: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_row',
569: p_procReturnStatus => x_return_status,
570: p_msg => 'procedure complete',
571: x_returnStatus => l_return_status);
572: END IF;

Line 578: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_row',

574: EXCEPTION
575: WHEN fnd_api.g_exc_unexpected_error THEN
576: x_return_status := fnd_api.g_ret_sts_error;
577: IF (l_log_level <= wip_constants.trace_logging) THEN
578: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_row',
579: p_procReturnStatus => x_return_status,
580: p_msg => l_error_msg,
581: x_returnStatus => l_return_status);
582: END IF;

Line 590: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_row',

586: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
587: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
588:
589: IF (l_log_level <= wip_constants.trace_logging) THEN
590: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_row',
591: p_procReturnStatus => x_return_status,
592: p_msg => l_error_msg,
593: x_returnStatus => l_return_status);
594: END IF;

Line 611: l_params wip_logger.param_tbl_t;

607: l_default_step_type VARCHAR2(1);
608: l_error_msg VARCHAR2(240);
609: l_process_phase VARCHAR2(3);
610: l_return_status VARCHAR2(1);
611: l_params wip_logger.param_tbl_t;
612: BEGIN
613: l_process_phase := '1';
614: -- write parameter value to log file
615: IF (l_log_level <= wip_constants.trace_logging) THEN

Line 623: wip_logger.entryPoint(p_procName => 'wip_batch_move.get_preferences',

619: l_params(2).paramValue := p_org_id;
620: l_params(3).paramName := 'p_dept_id';
621: l_params(3).paramValue := p_dept_id;
622:
623: wip_logger.entryPoint(p_procName => 'wip_batch_move.get_preferences',
624: p_params => l_params,
625: x_returnStatus => l_return_status);
626: END IF;
627: l_process_phase := '2';

Line 656: wip_logger.exitPoint(p_procName => 'wip_batch_move.get_preferences',

652: x_return_status := fnd_api.g_ret_sts_success;
653:
654: -- write to the log file
655: IF (l_log_level <= wip_constants.trace_logging) THEN
656: wip_logger.exitPoint(p_procName => 'wip_batch_move.get_preferences',
657: p_procReturnStatus => x_return_status,
658: p_msg => 'procedure complete',
659: x_returnStatus => l_return_status);
660: END IF;

Line 668: wip_logger.exitPoint(p_procName => 'wip_batch_move.get_preferences',

664: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
665: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
666:
667: IF (l_log_level <= wip_constants.trace_logging) THEN
668: wip_logger.exitPoint(p_procName => 'wip_batch_move.get_preferences',
669: p_procReturnStatus => x_return_status,
670: p_msg => l_error_msg,
671: x_returnStatus => l_return_status);
672: END IF;

Line 729: l_params wip_logger.param_tbl_t;

725: l_total_row NUMBER;
726: l_error_msg VARCHAR2(240);
727: l_process_phase VARCHAR2(3);
728: l_return_status VARCHAR2(1);
729: l_params wip_logger.param_tbl_t;
730: l_txn_id NUMBER;
731: BEGIN
732: l_process_phase := '1';
733: -- write parameter value to log file

Line 742: wip_logger.entryPoint(p_procName => 'wip_batch_move.insert_move_records',

738: l_params(2).paramValue := p_employee_id;
739: l_params(3).paramName := 'p_assy_serial';
740: l_params(3).paramValue := p_assy_serial;
741:
742: wip_logger.entryPoint(p_procName => 'wip_batch_move.insert_move_records',
743: p_params => l_params,
744: x_returnStatus => l_return_status);
745: END IF;
746: l_process_phase := '2';

Line 931: wip_logger.exitPoint(p_procName => 'wip_batch_move.insert_move_records',

927:
928: x_return_status := fnd_api.g_ret_sts_success;
929: -- write to the log file
930: IF (l_log_level <= wip_constants.trace_logging) THEN
931: wip_logger.exitPoint(p_procName => 'wip_batch_move.insert_move_records',
932: p_procReturnStatus => x_return_status,
933: p_msg => 'procedure complete',
934: x_returnStatus => l_return_status);
935: END IF;

Line 944: wip_logger.exitPoint(p_procName => 'wip_batch_move.insert_move_records',

940: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
941: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
942:
943: IF (l_log_level <= wip_constants.trace_logging) THEN
944: wip_logger.exitPoint(p_procName => 'wip_batch_move.insert_move_records',
945: p_procReturnStatus => x_return_status,
946: p_msg => l_error_msg,
947: x_returnStatus => l_return_status);
948: END IF;

Line 999: l_params wip_logger.param_tbl_t;

995: l_process_phase VARCHAR2(3);
996: l_return_status VARCHAR2(1);
997: l_errors c_errors%ROWTYPE;
998: l_move_intf_records c_move_intf_records%ROWTYPE;
999: l_params wip_logger.param_tbl_t;
1000:
1001: BEGIN
1002: l_process_phase := '1';
1003: -- write parameter value to log file

Line 1008: wip_logger.entryPoint(p_procName => 'wip_batch_move.process_move_records',

1004: IF (l_log_level <= wip_constants.trace_logging) THEN
1005: l_params(1).paramName := 'p_group_id';
1006: l_params(1).paramValue := p_group_id;
1007:
1008: wip_logger.entryPoint(p_procName => 'wip_batch_move.process_move_records',
1009: p_params => l_params,
1010: x_returnStatus => l_return_status);
1011: END IF;
1012: l_process_phase := '2';

Line 1050: wip_logger.exitPoint(p_procName => 'wip_batch_move.process_move_records',

1046: END IF;
1047:
1048: -- write to the log file
1049: IF (l_log_level <= wip_constants.trace_logging) THEN
1050: wip_logger.exitPoint(p_procName => 'wip_batch_move.process_move_records',
1051: p_procReturnStatus => x_return_status,
1052: p_msg => 'procedure complete',
1053: x_returnStatus => l_return_status);
1054: END IF;

Line 1071: wip_logger.exitPoint(p_procName => 'wip_batch_move.process_move_records',

1067: l_errors.error_message || '; ';
1068: END LOOP;
1069:
1070: IF (l_log_level <= wip_constants.trace_logging) THEN
1071: wip_logger.exitPoint(p_procName => 'wip_batch_move.process_move_records',
1072: p_procReturnStatus => x_return_status,
1073: p_msg => 'wip_movProc_grp.processInterface failed',
1074: x_returnStatus => l_return_status);
1075: END IF;

Line 1091: wip_logger.exitPoint(p_procName => 'wip_batch_move.process_move_records',

1087: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
1088: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1089:
1090: IF (l_log_level <= wip_constants.trace_logging) THEN
1091: wip_logger.exitPoint(p_procName => 'wip_batch_move.process_move_records',
1092: p_procReturnStatus => x_return_status,
1093: p_msg => l_error_msg,
1094: x_returnStatus => l_return_status);
1095: END IF;

Line 1116: l_params wip_logger.param_tbl_t;

1112: l_plan_txn_ids VARCHAR2(10000);
1113: l_plan_ids VARCHAR2(10000);
1114: l_quality_plan_exist VARCHAR2(1);
1115: l_return_status VARCHAR2(1);
1116: l_params wip_logger.param_tbl_t;
1117: BEGIN
1118: -- write parameter value to log file
1119: IF (l_log_level <= wip_constants.trace_logging) THEN
1120: l_params(1).paramName := 'p_org_id';

Line 1123: wip_logger.entryPoint(p_procName => 'wip_batch_move.quality_require',

1119: IF (l_log_level <= wip_constants.trace_logging) THEN
1120: l_params(1).paramName := 'p_org_id';
1121: l_params(1).paramValue := p_org_id;
1122:
1123: wip_logger.entryPoint(p_procName => 'wip_batch_move.quality_require',
1124: p_params => l_params,
1125: x_returnStatus => l_return_status);
1126: END IF;
1127: x_quality_require := fnd_api.g_false;

Line 1156: wip_logger.log(p_msg => 'l_context_values='||l_context_values,

1152: qa_ss_const.task_number||'='||p_move_tbl(i).task_number||'@'||
1153: qa_ss_const.bom_revision||'='||p_move_tbl(i).bom_revision;
1154:
1155: IF (l_log_level <= wip_constants.trace_logging) THEN
1156: wip_logger.log(p_msg => 'l_context_values='||l_context_values,
1157: x_returnStatus => l_return_status);
1158: END IF;
1159:
1160: BEGIN

Line 1202: wip_logger.log(p_msg => l_error_msg,

1198: fnd_message.set_token('MESSAGE', l_error_msg);
1199: fnd_msg_pub.add;
1200:
1201: IF (l_log_level <= wip_constants.trace_logging) THEN
1202: wip_logger.log(p_msg => l_error_msg,
1203: x_returnStatus => l_return_status);
1204: END IF;
1205: END;
1206: END LOOP;

Line 1210: wip_logger.exitPoint(p_procName => 'wip_batch_move.quality_require',

1206: END LOOP;
1207:
1208: -- write to the log file
1209: IF (l_log_level <= wip_constants.trace_logging) THEN
1210: wip_logger.exitPoint(p_procName => 'wip_batch_move.quality_require',
1211: p_procReturnStatus => fnd_api.g_ret_sts_success,
1212: p_msg => 'procedure complete',
1213: x_returnStatus => l_return_status);
1214: END IF;

Line 1220: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',

1216: x_return_status := fnd_api.g_ret_sts_success;
1217:
1218: -- write to the log file
1219: IF (l_log_level <= wip_constants.trace_logging) THEN
1220: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',
1221: p_procReturnStatus => x_return_status,
1222: p_msg => 'procedure complete',
1223: x_returnStatus => l_return_status);
1224: END IF;

Line 1231: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',

1227: x_return_status := fnd_api.g_ret_sts_error;
1228: l_error_msg := ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1229:
1230: IF (l_log_level <= wip_constants.trace_logging) THEN
1231: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',
1232: p_procReturnStatus => x_return_status,
1233: p_msg => l_error_msg,
1234: x_returnStatus => l_return_status);
1235: END IF;

Line 1246: l_params wip_logger.param_tbl_t;

1242: l_log_level NUMBER := fnd_log.g_current_runtime_level;
1243: l_error_msg VARCHAR2(240);
1244: l_process_phase VARCHAR2(3);
1245: l_return_status VARCHAR2(1);
1246: l_params wip_logger.param_tbl_t;
1247: BEGIN
1248: l_process_phase := '1';
1249: -- write parameter value to log file
1250: IF (l_log_level <= wip_constants.trace_logging) THEN

Line 1254: wip_logger.entryPoint(p_procName => 'wip_batch_move.validate_batch',

1250: IF (l_log_level <= wip_constants.trace_logging) THEN
1251: l_params(1).paramName := 'p_default_step_type';
1252: l_params(1).paramValue := p_default_step_type;
1253:
1254: wip_logger.entryPoint(p_procName => 'wip_batch_move.validate_batch',
1255: p_params => l_params,
1256: x_returnStatus => l_return_status);
1257: END IF;
1258: l_process_phase := '2';

Line 1285: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_batch',

1281:
1282: x_return_status := fnd_api.g_ret_sts_success;
1283: -- write to the log file
1284: IF (l_log_level <= wip_constants.trace_logging) THEN
1285: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_batch',
1286: p_procReturnStatus => x_return_status,
1287: p_msg => 'procedure complete',
1288: x_returnStatus => l_return_status);
1289: END IF;

Line 1295: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_batch',

1291: WHEN fnd_api.g_exc_unexpected_error THEN
1292: x_return_status := fnd_api.g_ret_sts_error;
1293:
1294: IF (l_log_level <= wip_constants.trace_logging) THEN
1295: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_batch',
1296: p_procReturnStatus => x_return_status,
1297: p_msg => l_error_msg,
1298: x_returnStatus => l_return_status);
1299: END IF;

Line 1307: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_batch',

1303: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
1304: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1305:
1306: IF (l_log_level <= wip_constants.trace_logging) THEN
1307: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_batch',
1308: p_procReturnStatus => x_return_status,
1309: p_msg => l_error_msg,
1310: x_returnStatus => l_return_status);
1311: END IF;

Line 1343: l_params wip_logger.param_tbl_t;

1339: l_process_phase VARCHAR2(3);
1340: l_quality_require VARCHAR2(1);
1341: l_plan_names VARCHAR2(4000);
1342: l_return_status VARCHAR2(1);
1343: l_params wip_logger.param_tbl_t;
1344: BEGIN
1345: l_process_phase := '1';
1346: -- write parameter value to log file
1347: IF (l_log_level <= wip_constants.trace_logging) THEN

Line 1368: wip_logger.entryPoint(p_procName => 'wip_batch_move.validate_row',

1364: l_params(9).paramName := 'p_resp_key';
1365: l_params(9).paramValue := p_resp_key;
1366: l_params(10).paramName := 'p_assy_serial';
1367: l_params(10).paramValue := p_assy_serial;
1368: wip_logger.entryPoint(p_procName => 'wip_batch_move.validate_row',
1369: p_params => l_params,
1370: x_returnStatus => l_return_status);
1371: END IF;
1372:

Line 1497: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_row',

1493: x_return_status := fnd_api.g_ret_sts_success;
1494:
1495: -- write to the log file
1496: IF (l_log_level <= wip_constants.trace_logging) THEN
1497: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_row',
1498: p_procReturnStatus => x_return_status,
1499: p_msg => 'procedure complete',
1500: x_returnStatus => l_return_status);
1501: END IF;

Line 1506: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_row',

1502: EXCEPTION
1503: WHEN fnd_api.g_exc_unexpected_error THEN
1504: x_return_status := fnd_api.g_ret_sts_error;
1505: IF (l_log_level <= wip_constants.trace_logging) THEN
1506: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_row',
1507: p_procReturnStatus => x_return_status,
1508: p_msg => l_error_msg,
1509: x_returnStatus => l_return_status);
1510: END IF;

Line 1518: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_row',

1514: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
1515: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1516:
1517: IF (l_log_level <= wip_constants.trace_logging) THEN
1518: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_row',
1519: p_procReturnStatus => x_return_status,
1520: p_msg => l_error_msg,
1521: x_returnStatus => l_return_status);
1522: END IF;

Line 1545: l_params wip_logger.param_tbl_t;

1541: l_error_msg VARCHAR2(240);
1542: l_error_text VARCHAR2(2000);
1543: l_return_status VARCHAR2(1);
1544: l_move_table_pvt wip_batch_move.move_table_pvt;
1545: l_params wip_logger.param_tbl_t;
1546: BEGIN
1547: -- write parameter value to log file
1548: IF (l_log_level <= wip_constants.trace_logging) THEN
1549: l_params(1).paramName := 'p_resp_key';

Line 1557: wip_logger.entryPoint(p_procName => 'wip_batch_move.process',

1553: l_params(3).paramName := 'p_dept_id';
1554: l_params(3).paramValue := p_dept_id;
1555: l_params(4).paramName := 'p_employee_id';
1556: l_params(4).paramValue := p_employee_id;
1557: wip_logger.entryPoint(p_procName => 'wip_batch_move.process',
1558: p_params => l_params,
1559: x_returnStatus => l_return_status);
1560: END IF;
1561:

Line 1650: wip_logger.log(p_msg => l_error_msg,

1646: p_error_text => l_error_text);
1647: l_error_row := l_error_row + 1;
1648: l_error_msg := 'row = ' || i || ' : ' || l_error_msg;
1649: IF (l_log_level <= wip_constants.trace_logging) THEN
1650: wip_logger.log(p_msg => l_error_msg,
1651: x_returnStatus => l_return_status);
1652: END IF;
1653:
1654: WHEN others THEN

Line 1666: wip_logger.log(p_msg => l_error_msg,

1662: l_error_msg := 'row = ' || i || ' : ' ||
1663: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' ||
1664: SQLCODE;
1665: IF (l_log_level <= wip_constants.trace_logging) THEN
1666: wip_logger.log(p_msg => l_error_msg,
1667: x_returnStatus => l_return_status);
1668: END IF;
1669: END;
1670: END LOOP;

Line 1681: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',

1677: x_return_status := fnd_api.g_ret_sts_error;
1678: END IF;
1679: -- Write to the log file.
1680: IF (l_log_level <= wip_constants.trace_logging) THEN
1681: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',
1682: p_procReturnStatus => x_return_status,
1683: p_msg => 'procedure complete',
1684: x_returnStatus => l_return_status);
1685: wip_logger.cleanUp(x_returnStatus => l_return_status);

Line 1685: wip_logger.cleanUp(x_returnStatus => l_return_status);

1681: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',
1682: p_procReturnStatus => x_return_status,
1683: p_msg => 'procedure complete',
1684: x_returnStatus => l_return_status);
1685: wip_logger.cleanUp(x_returnStatus => l_return_status);
1686: END IF;
1687: EXCEPTION
1688: WHEN fnd_api.g_exc_unexpected_error THEN
1689: x_return_status := fnd_api.g_ret_sts_error;

Line 1691: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',

1687: EXCEPTION
1688: WHEN fnd_api.g_exc_unexpected_error THEN
1689: x_return_status := fnd_api.g_ret_sts_error;
1690: IF (l_log_level <= wip_constants.trace_logging) THEN
1691: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',
1692: p_procReturnStatus => x_return_status,
1693: p_msg => l_error_msg,
1694: x_returnStatus => l_return_status);
1695: wip_logger.cleanUp(x_returnStatus => l_return_status);

Line 1695: wip_logger.cleanUp(x_returnStatus => l_return_status);

1691: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',
1692: p_procReturnStatus => x_return_status,
1693: p_msg => l_error_msg,
1694: x_returnStatus => l_return_status);
1695: wip_logger.cleanUp(x_returnStatus => l_return_status);
1696: END IF;
1697:
1698: WHEN others THEN
1699: x_return_status := fnd_api.g_ret_sts_error;

Line 1703: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',

1699: x_return_status := fnd_api.g_ret_sts_error;
1700: l_error_msg := ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1701:
1702: IF (l_log_level <= wip_constants.trace_logging) THEN
1703: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',
1704: p_procReturnStatus => x_return_status,
1705: p_msg => l_error_msg,
1706: x_returnStatus => l_return_status);
1707: wip_logger.cleanUp(x_returnStatus => l_return_status);

Line 1707: wip_logger.cleanUp(x_returnStatus => l_return_status);

1703: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',
1704: p_procReturnStatus => x_return_status,
1705: p_msg => l_error_msg,
1706: x_returnStatus => l_return_status);
1707: wip_logger.cleanUp(x_returnStatus => l_return_status);
1708: END IF;
1709: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1710: fnd_message.set_token('MESSAGE', l_error_msg);
1711: fnd_msg_pub.add;