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_BATCH_MOVE

Line 1: PACKAGE BODY wip_batch_move AS

1: PACKAGE BODY wip_batch_move AS
2: /* $Header: wipbmovb.pls 120.7.12010000.2 2008/09/09 22:48:02 ntangjee ship $*/
3:
4: ---------------
5: --private types

Line 98: x_move_table_pvt IN OUT NOCOPY wip_batch_move.move_table_pvt,

94: p_fm_op_seq IN NUMBER,
95: p_move_qty IN NUMBER,
96: p_default_step_type IN NUMBER,
97: p_fm_step_type IN NUMBER,
98: x_move_table_pvt IN OUT NOCOPY wip_batch_move.move_table_pvt,
99: x_return_status OUT NOCOPY VARCHAR2) IS
100:
101: CURSOR c_move_info IS
102: SELECT p_wip_entity_id wip_entity_id,

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 271: x_move_table_pvt IN OUT NOCOPY wip_batch_move.move_table_pvt,

267: p_default_scrap_acct_id IN NUMBER,
268: p_default_step_type IN NUMBER,
269: p_fm_step_type IN NUMBER,
270: p_resp_key IN VARCHAR2,
271: x_move_table_pvt IN OUT NOCOPY wip_batch_move.move_table_pvt,
272: x_return_status OUT NOCOPY VARCHAR2) IS
273:
274: CURSOR c_scrap_info IS
275: SELECT p_wip_entity_id wip_entity_id,

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 486: x_move_table_pvt OUT NOCOPY wip_batch_move.move_table_pvt,

482: p_default_scrap_acct_id IN NUMBER,
483: p_default_step_type IN NUMBER,
484: p_fm_step_type IN NUMBER,
485: p_resp_key IN VARCHAR2,
486: x_move_table_pvt OUT NOCOPY wip_batch_move.move_table_pvt,
487: x_return_status OUT NOCOPY VARCHAR2) IS
488:
489: l_log_level NUMBER := fnd_log.g_current_runtime_level;
490: l_error_msg VARCHAR2(240);

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 539: l_error_msg := 'wip_batch_move.derive_move failed';

535: x_move_table_pvt => x_move_table_pvt,
536: x_return_status => x_return_status);
537:
538: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
539: l_error_msg := 'wip_batch_move.derive_move failed';
540: raise fnd_api.g_exc_unexpected_error;
541: END IF;
542: END IF;
543: l_process_phase := '3';

Line 560: l_error_msg := 'wip_batch_move.derive_scrap failed';

556: x_move_table_pvt => x_move_table_pvt,
557: x_return_status => x_return_status);
558:
559: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
560: l_error_msg := 'wip_batch_move.derive_scrap failed';
561: raise fnd_api.g_exc_unexpected_error;
562: END IF;
563: END IF;
564:

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 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 719: p_move_table_pvt IN wip_batch_move.move_table_pvt,

715: END initialize_lookups;
716:
717: PROCEDURE insert_move_records(p_org_id IN NUMBER,
718: p_employee_id IN NUMBER,
719: p_move_table_pvt IN wip_batch_move.move_table_pvt,
720: p_assy_serial IN VARCHAR2,
721: x_group_id OUT NOCOPY NUMBER,
722: x_return_status OUT NOCOPY VARCHAR2) IS
723:

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 960: fnd_message.set_name('WIP', 'WIP_BATCH_MOVE_ERROR');

956: BEGIN
957:
958: total_errors := error_lists.count;
959: WHILE (error_no <= total_errors) LOOP
960: fnd_message.set_name('WIP', 'WIP_BATCH_MOVE_ERROR');
961: fnd_message.set_token('JOB', error_lists(error_no).job_name);
962: fnd_message.set_token('OPERATION', error_lists(error_no).op_seq_num);
963: fnd_message.set_token('ERROR',error_lists(error_no).error_text);
964: fnd_msg_pub.add;

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 1102: p_move_tbl IN wip_batch_move.move_table_pvt,

1098: fnd_msg_pub.add;
1099: END process_move_records;
1100:
1101: PROCEDURE quality_require(p_org_id IN NUMBER,
1102: p_move_tbl IN wip_batch_move.move_table_pvt,
1103: x_quality_require OUT NOCOPY VARCHAR2,
1104: x_plan_names OUT NOCOPY VARCHAR2,
1105: x_return_status OUT NOCOPY VARCHAR2)IS
1106:

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 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 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 1328: x_move_table_pvt OUT NOCOPY wip_batch_move.move_table_pvt,

1324: p_default_step_type IN NUMBER,
1325: p_default_scrap_acct_id IN NUMBER,
1326: p_resp_key IN VARCHAR2,
1327: p_assy_serial IN VARCHAR2,
1328: x_move_table_pvt OUT NOCOPY wip_batch_move.move_table_pvt,
1329: x_return_status OUT NOCOPY VARCHAR2) IS
1330:
1331: l_available_qty NUMBER;
1332: l_fm_step_type NUMBER;

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 1466: l_error_msg := 'wip_batch_move.derive_row failed';

1462: x_move_table_pvt => x_move_table_pvt,
1463: x_return_status => x_return_status);
1464:
1465: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
1466: l_error_msg := 'wip_batch_move.derive_row failed';
1467: raise fnd_api.g_exc_unexpected_error;
1468: END IF;
1469: l_process_phase := '6';
1470: -- Check whether quality collection is mandatory or not.

Line 1478: l_error_msg := 'wip_batch_move.quality_require failed';

1474: x_plan_names => l_plan_names,
1475: x_return_status => x_return_status);
1476:
1477: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
1478: l_error_msg := 'wip_batch_move.quality_require failed';
1479: raise fnd_api.g_exc_unexpected_error;
1480: ELSE -- If success, check whether quality is mandatory or not.
1481: IF(l_quality_require = fnd_api.g_true) THEN
1482: -- Fixed bug 5335024. Change error message from a generic error message

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 1528: PROCEDURE process(p_move_table IN wip_batch_move.move_table,

1524: fnd_message.set_token('MESSAGE', l_error_msg);
1525: fnd_msg_pub.add;
1526: END validate_row;
1527:
1528: PROCEDURE process(p_move_table IN wip_batch_move.move_table,
1529: p_resp_key IN VARCHAR2,
1530: p_org_id IN NUMBER,
1531: p_dept_id IN NUMBER,
1532: p_employee_id IN NUMBER,

Line 1544: l_move_table_pvt wip_batch_move.move_table_pvt;

1540: l_total_row NUMBER;
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

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 1575: l_error_msg := 'wip_batch_move.get_preferences failed';

1571: x_default_scrap_acct_id => l_default_scrap_acct_id,
1572: x_return_status => x_return_status);
1573:
1574: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
1575: l_error_msg := 'wip_batch_move.get_preferences failed';
1576: raise fnd_api.g_exc_unexpected_error;
1577: END IF;
1578: -- Perform generic validation for the whole batch.
1579: validate_batch(p_default_step_type => l_default_step_type,

Line 1583: l_error_msg := 'wip_batch_move.validate_batch failed';

1579: validate_batch(p_default_step_type => l_default_step_type,
1580: x_return_status => x_return_status);
1581:
1582: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
1583: l_error_msg := 'wip_batch_move.validate_batch failed';
1584: raise fnd_api.g_exc_unexpected_error;
1585: END IF;
1586:
1587: l_total_row := p_move_table.count;

Line 1607: l_error_msg := 'wip_batch_move.validate_row failed';

1603: x_move_table_pvt => l_move_table_pvt,
1604: x_return_status => x_return_status);
1605:
1606: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
1607: l_error_msg := 'wip_batch_move.validate_row failed';
1608: raise fnd_api.g_exc_unexpected_error;
1609: END IF;
1610: -- Insert move/scrap record into WMTI
1611: insert_move_records(p_org_id => p_org_id,

Line 1619: l_error_msg := 'wip_batch_move.insert_move_records failed';

1615: x_group_id => l_group_id,
1616: x_return_status => x_return_status);
1617:
1618: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
1619: l_error_msg := 'wip_batch_move.insert_move_records failed';
1620: raise fnd_api.g_exc_unexpected_error;
1621: END IF;
1622: -- Clear all move information.
1623: l_move_table_pvt.delete;

Line 1630: l_error_msg := 'wip_batch_move.process_move_records failed';

1626: process_move_records(p_group_id => l_group_id,
1627: x_return_status => x_return_status);
1628:
1629: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
1630: l_error_msg := 'wip_batch_move.process_move_records failed';
1631: raise fnd_api.g_exc_unexpected_error;
1632: ELSE
1633: -- Initialize message stack to clear "Txn Success" inventory put in
1634: -- the stack.

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 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 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 1713: END wip_batch_move;

1709: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1710: fnd_message.set_token('MESSAGE', l_error_msg);
1711: fnd_msg_pub.add;
1712: END process;
1713: END wip_batch_move;