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.10.12020000.2 2012/07/18 07:49:56 ankohli 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 191: wip_logger.entryPoint(p_procName => 'wip_batch_move.derive_move',

187: l_params(6).paramValue := p_default_step_type;
188: l_params(7).paramName := 'p_fm_step_type';
189: l_params(7).paramValue := p_fm_step_type;
190:
191: wip_logger.entryPoint(p_procName => 'wip_batch_move.derive_move',
192: p_params => l_params,
193: x_returnStatus => l_return_status);
194: END IF;
195:

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

267: CLOSE c_move_info;
268: END IF;
269: l_error_msg := 'MOVE_TO_STEP_HOOK errored out: ' || l_return_message;
270: IF (l_log_level <= wip_constants.trace_logging) THEN
271: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',
272: p_procReturnStatus => x_return_status,
273: p_msg => l_error_msg,
274: x_returnStatus => l_return_status);
275: END IF;

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

342: x_return_status := fnd_api.g_ret_sts_success;
343:
344: -- write to the log file
345: IF (l_log_level <= wip_constants.trace_logging) THEN
346: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',
347: p_procReturnStatus => x_return_status,
348: p_msg => 'procedure complete',
349: x_returnStatus => l_return_status);
350: END IF;

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

357: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
358: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
359:
360: IF (l_log_level <= wip_constants.trace_logging) THEN
361: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',
362: p_procReturnStatus => x_return_status,
363: p_msg => l_error_msg,
364: x_returnStatus => l_return_status);
365: END IF;

Line 382: x_move_table_pvt IN OUT NOCOPY wip_batch_move.move_table_pvt,

378: p_default_scrap_acct_id IN NUMBER,
379: p_default_step_type IN NUMBER,
380: p_fm_step_type IN NUMBER,
381: p_resp_key IN VARCHAR2,
382: x_move_table_pvt IN OUT NOCOPY wip_batch_move.move_table_pvt,
383: x_return_status OUT NOCOPY VARCHAR2) IS
384:
385: CURSOR c_scrap_info IS
386: SELECT p_wip_entity_id wip_entity_id,

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

471: l_params(9).paramValue := p_fm_step_type;
472: l_params(10).paramName := 'p_resp_key';
473: l_params(10).paramValue := p_resp_key;
474:
475: wip_logger.entryPoint(p_procName => 'wip_batch_move.derive_scrap',
476: p_params => l_params,
477: x_returnStatus => l_return_status);
478: END IF;
479:

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

545: x_return_status := fnd_api.g_ret_sts_success;
546:
547: -- write to the log file
548: IF (l_log_level <= wip_constants.trace_logging) THEN
549: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_scrap',
550: p_procReturnStatus => x_return_status,
551: p_msg => 'procedure complete',
552: x_returnStatus => l_return_status);
553: END IF;

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

557: IF(c_scrap_info%ISOPEN) THEN
558: CLOSE c_scrap_info;
559: END IF;
560: IF (l_log_level <= wip_constants.trace_logging) THEN
561: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_scrap',
562: p_procReturnStatus => x_return_status,
563: p_msg => l_error_msg,
564: x_returnStatus => l_return_status);
565: END IF;

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

571: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
572: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
573:
574: IF (l_log_level <= wip_constants.trace_logging) THEN
575: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_scrap',
576: p_procReturnStatus => x_return_status,
577: p_msg => l_error_msg,
578: x_returnStatus => l_return_status);
579: END IF;

Line 597: x_move_table_pvt OUT NOCOPY wip_batch_move.move_table_pvt,

593: p_default_scrap_acct_id IN NUMBER,
594: p_default_step_type IN NUMBER,
595: p_fm_step_type IN NUMBER,
596: p_resp_key IN VARCHAR2,
597: x_move_table_pvt OUT NOCOPY wip_batch_move.move_table_pvt,
598: x_return_status OUT NOCOPY VARCHAR2) IS
599:
600: l_log_level NUMBER := fnd_log.g_current_runtime_level;
601: l_error_msg VARCHAR2(240);

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

628: l_params(10).paramValue := p_fm_step_type;
629: l_params(11).paramName := 'p_resp_key';
630: l_params(11).paramValue := p_resp_key;
631:
632: wip_logger.entryPoint(p_procName => 'wip_batch_move.derive_row',
633: p_params => l_params,
634: x_returnStatus => l_return_status);
635: END IF;
636: l_process_phase := '2';

Line 650: l_error_msg := 'wip_batch_move.derive_move failed';

646: x_move_table_pvt => x_move_table_pvt,
647: x_return_status => x_return_status);
648:
649: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
650: l_error_msg := 'wip_batch_move.derive_move failed';
651: raise fnd_api.g_exc_unexpected_error;
652: END IF;
653: END IF;
654: l_process_phase := '3';

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

667: x_move_table_pvt => x_move_table_pvt,
668: x_return_status => x_return_status);
669:
670: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
671: l_error_msg := 'wip_batch_move.derive_scrap failed';
672: raise fnd_api.g_exc_unexpected_error;
673: END IF;
674: END IF;
675:

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

675:
676: x_return_status := fnd_api.g_ret_sts_success;
677: -- write to the log file
678: IF (l_log_level <= wip_constants.trace_logging) THEN
679: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_row',
680: p_procReturnStatus => x_return_status,
681: p_msg => 'procedure complete',
682: x_returnStatus => l_return_status);
683: END IF;

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

685: EXCEPTION
686: WHEN fnd_api.g_exc_unexpected_error THEN
687: x_return_status := fnd_api.g_ret_sts_error;
688: IF (l_log_level <= wip_constants.trace_logging) THEN
689: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_row',
690: p_procReturnStatus => x_return_status,
691: p_msg => l_error_msg,
692: x_returnStatus => l_return_status);
693: END IF;

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

697: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
698: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
699:
700: IF (l_log_level <= wip_constants.trace_logging) THEN
701: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_row',
702: p_procReturnStatus => x_return_status,
703: p_msg => l_error_msg,
704: x_returnStatus => l_return_status);
705: END IF;

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

730: l_params(2).paramValue := p_org_id;
731: l_params(3).paramName := 'p_dept_id';
732: l_params(3).paramValue := p_dept_id;
733:
734: wip_logger.entryPoint(p_procName => 'wip_batch_move.get_preferences',
735: p_params => l_params,
736: x_returnStatus => l_return_status);
737: END IF;
738: l_process_phase := '2';

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

763: x_return_status := fnd_api.g_ret_sts_success;
764:
765: -- write to the log file
766: IF (l_log_level <= wip_constants.trace_logging) THEN
767: wip_logger.exitPoint(p_procName => 'wip_batch_move.get_preferences',
768: p_procReturnStatus => x_return_status,
769: p_msg => 'procedure complete',
770: x_returnStatus => l_return_status);
771: END IF;

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

775: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
776: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
777:
778: IF (l_log_level <= wip_constants.trace_logging) THEN
779: wip_logger.exitPoint(p_procName => 'wip_batch_move.get_preferences',
780: p_procReturnStatus => x_return_status,
781: p_msg => l_error_msg,
782: x_returnStatus => l_return_status);
783: END IF;

Line 830: p_move_table_pvt IN wip_batch_move.move_table_pvt,

826: END initialize_lookups;
827:
828: PROCEDURE insert_move_records(p_org_id IN NUMBER,
829: p_employee_id IN NUMBER,
830: p_move_table_pvt IN wip_batch_move.move_table_pvt,
831: p_assy_serial IN VARCHAR2,
832: x_group_id OUT NOCOPY NUMBER,
833: x_return_status OUT NOCOPY VARCHAR2) IS
834:

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

849: l_params(2).paramValue := p_employee_id;
850: l_params(3).paramName := 'p_assy_serial';
851: l_params(3).paramValue := p_assy_serial;
852:
853: wip_logger.entryPoint(p_procName => 'wip_batch_move.insert_move_records',
854: p_params => l_params,
855: x_returnStatus => l_return_status);
856: END IF;
857: l_process_phase := '2';

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

1038:
1039: x_return_status := fnd_api.g_ret_sts_success;
1040: -- write to the log file
1041: IF (l_log_level <= wip_constants.trace_logging) THEN
1042: wip_logger.exitPoint(p_procName => 'wip_batch_move.insert_move_records',
1043: p_procReturnStatus => x_return_status,
1044: p_msg => 'procedure complete',
1045: x_returnStatus => l_return_status);
1046: END IF;

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

1051: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
1052: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1053:
1054: IF (l_log_level <= wip_constants.trace_logging) THEN
1055: wip_logger.exitPoint(p_procName => 'wip_batch_move.insert_move_records',
1056: p_procReturnStatus => x_return_status,
1057: p_msg => l_error_msg,
1058: x_returnStatus => l_return_status);
1059: END IF;

Line 1071: fnd_message.set_name('WIP', 'WIP_BATCH_MOVE_ERROR');

1067: BEGIN
1068:
1069: total_errors := error_lists.count;
1070: WHILE (error_no <= total_errors) LOOP
1071: fnd_message.set_name('WIP', 'WIP_BATCH_MOVE_ERROR');
1072: fnd_message.set_token('JOB', error_lists(error_no).job_name);
1073: fnd_message.set_token('OPERATION', error_lists(error_no).op_seq_num);
1074: fnd_message.set_token('ERROR',error_lists(error_no).error_text);
1075: fnd_msg_pub.add;

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

1115: IF (l_log_level <= wip_constants.trace_logging) THEN
1116: l_params(1).paramName := 'p_group_id';
1117: l_params(1).paramValue := p_group_id;
1118:
1119: wip_logger.entryPoint(p_procName => 'wip_batch_move.process_move_records',
1120: p_params => l_params,
1121: x_returnStatus => l_return_status);
1122: END IF;
1123: l_process_phase := '2';

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

1157: END IF;
1158:
1159: -- write to the log file
1160: IF (l_log_level <= wip_constants.trace_logging) THEN
1161: wip_logger.exitPoint(p_procName => 'wip_batch_move.process_move_records',
1162: p_procReturnStatus => x_return_status,
1163: p_msg => 'procedure complete',
1164: x_returnStatus => l_return_status);
1165: END IF;

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

1178: l_errors.error_message || '; ';
1179: END LOOP;
1180:
1181: IF (l_log_level <= wip_constants.trace_logging) THEN
1182: wip_logger.exitPoint(p_procName => 'wip_batch_move.process_move_records',
1183: p_procReturnStatus => x_return_status,
1184: p_msg => 'wip_movProc_grp.processInterface failed',
1185: x_returnStatus => l_return_status);
1186: END IF;

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

1198: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
1199: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1200:
1201: IF (l_log_level <= wip_constants.trace_logging) THEN
1202: wip_logger.exitPoint(p_procName => 'wip_batch_move.process_move_records',
1203: p_procReturnStatus => x_return_status,
1204: p_msg => l_error_msg,
1205: x_returnStatus => l_return_status);
1206: END IF;

Line 1213: p_move_tbl IN wip_batch_move.move_table_pvt,

1209: fnd_msg_pub.add;
1210: END process_move_records;
1211:
1212: PROCEDURE quality_require(p_org_id IN NUMBER,
1213: p_move_tbl IN wip_batch_move.move_table_pvt,
1214: p_assy_serial IN VARCHAR2,
1215: x_quality_require OUT NOCOPY VARCHAR2,
1216: x_plan_names OUT NOCOPY VARCHAR2,
1217: x_return_status OUT NOCOPY VARCHAR2)IS

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

1236: IF (l_log_level <= wip_constants.trace_logging) THEN
1237: l_params(1).paramName := 'p_org_id';
1238: l_params(1).paramValue := p_org_id;
1239:
1240: wip_logger.entryPoint(p_procName => 'wip_batch_move.quality_require',
1241: p_params => l_params,
1242: x_returnStatus => l_return_status);
1243: END IF;
1244: x_quality_require := fnd_api.g_false;

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

1376: END LOOP;
1377:
1378: -- write to the log file
1379: IF (l_log_level <= wip_constants.trace_logging) THEN
1380: wip_logger.exitPoint(p_procName => 'wip_batch_move.quality_require',
1381: p_procReturnStatus => fnd_api.g_ret_sts_success,
1382: p_msg => 'procedure complete',
1383: x_returnStatus => l_return_status);
1384: END IF;

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

1386: x_return_status := fnd_api.g_ret_sts_success;
1387:
1388: -- write to the log file
1389: IF (l_log_level <= wip_constants.trace_logging) THEN
1390: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',
1391: p_procReturnStatus => x_return_status,
1392: p_msg => 'procedure complete',
1393: x_returnStatus => l_return_status);
1394: END IF;

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

1397: x_return_status := fnd_api.g_ret_sts_error;
1398: l_error_msg := ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1399:
1400: IF (l_log_level <= wip_constants.trace_logging) THEN
1401: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',
1402: p_procReturnStatus => x_return_status,
1403: p_msg => l_error_msg,
1404: x_returnStatus => l_return_status);
1405: END IF;

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

1420: IF (l_log_level <= wip_constants.trace_logging) THEN
1421: l_params(1).paramName := 'p_default_step_type';
1422: l_params(1).paramValue := p_default_step_type;
1423:
1424: wip_logger.entryPoint(p_procName => 'wip_batch_move.validate_batch',
1425: p_params => l_params,
1426: x_returnStatus => l_return_status);
1427: END IF;
1428: l_process_phase := '2';

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

1451:
1452: x_return_status := fnd_api.g_ret_sts_success;
1453: -- write to the log file
1454: IF (l_log_level <= wip_constants.trace_logging) THEN
1455: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_batch',
1456: p_procReturnStatus => x_return_status,
1457: p_msg => 'procedure complete',
1458: x_returnStatus => l_return_status);
1459: END IF;

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

1461: WHEN fnd_api.g_exc_unexpected_error THEN
1462: x_return_status := fnd_api.g_ret_sts_error;
1463:
1464: IF (l_log_level <= wip_constants.trace_logging) THEN
1465: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_batch',
1466: p_procReturnStatus => x_return_status,
1467: p_msg => l_error_msg,
1468: x_returnStatus => l_return_status);
1469: END IF;

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

1473: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
1474: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1475:
1476: IF (l_log_level <= wip_constants.trace_logging) THEN
1477: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_batch',
1478: p_procReturnStatus => x_return_status,
1479: p_msg => l_error_msg,
1480: x_returnStatus => l_return_status);
1481: END IF;

Line 1498: x_move_table_pvt OUT NOCOPY wip_batch_move.move_table_pvt,

1494: p_default_step_type IN NUMBER,
1495: p_default_scrap_acct_id IN NUMBER,
1496: p_resp_key IN VARCHAR2,
1497: p_assy_serial IN VARCHAR2,
1498: x_move_table_pvt OUT NOCOPY wip_batch_move.move_table_pvt,
1499: x_return_status OUT NOCOPY VARCHAR2) IS
1500:
1501: l_available_qty NUMBER;
1502: l_fm_step_type NUMBER;

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

1550: l_params(9).paramName := 'p_resp_key';
1551: l_params(9).paramValue := p_resp_key;
1552: l_params(10).paramName := 'p_assy_serial';
1553: l_params(10).paramValue := p_assy_serial;
1554: wip_logger.entryPoint(p_procName => 'wip_batch_move.validate_row',
1555: p_params => l_params,
1556: x_returnStatus => l_return_status);
1557: END IF;
1558:

Line 1660: l_error_msg := 'wip_batch_move.derive_row failed';

1656: x_move_table_pvt => x_move_table_pvt,
1657: x_return_status => x_return_status);
1658:
1659: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
1660: l_error_msg := 'wip_batch_move.derive_row failed';
1661: raise fnd_api.g_exc_unexpected_error;
1662: END IF;
1663: l_process_phase := '6';
1664: -- Check whether quality collection is mandatory or not.

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

1683: x_return_status => x_return_status);
1684: end if;
1685:
1686: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
1687: l_error_msg := 'wip_batch_move.quality_require failed';
1688: raise fnd_api.g_exc_unexpected_error;
1689: ELSE -- If success, check whether quality is mandatory or not.
1690: IF(l_quality_require = fnd_api.g_true) THEN
1691: -- Fixed bug 5335024. Change error message from a generic error message

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

1702: x_return_status := fnd_api.g_ret_sts_success;
1703:
1704: -- write to the log file
1705: IF (l_log_level <= wip_constants.trace_logging) THEN
1706: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_row',
1707: p_procReturnStatus => x_return_status,
1708: p_msg => 'procedure complete',
1709: x_returnStatus => l_return_status);
1710: END IF;

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

1711: EXCEPTION
1712: WHEN fnd_api.g_exc_unexpected_error THEN
1713: x_return_status := fnd_api.g_ret_sts_error;
1714: IF (l_log_level <= wip_constants.trace_logging) THEN
1715: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_row',
1716: p_procReturnStatus => x_return_status,
1717: p_msg => l_error_msg,
1718: x_returnStatus => l_return_status);
1719: END IF;

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

1723: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
1724: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1725:
1726: IF (l_log_level <= wip_constants.trace_logging) THEN
1727: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_row',
1728: p_procReturnStatus => x_return_status,
1729: p_msg => l_error_msg,
1730: x_returnStatus => l_return_status);
1731: END IF;

Line 1737: PROCEDURE process(p_move_table IN wip_batch_move.move_table,

1733: fnd_message.set_token('MESSAGE', l_error_msg);
1734: fnd_msg_pub.add;
1735: END validate_row;
1736:
1737: PROCEDURE process(p_move_table IN wip_batch_move.move_table,
1738: p_resp_key IN VARCHAR2,
1739: p_org_id IN NUMBER,
1740: p_dept_id IN NUMBER,
1741: p_employee_id IN NUMBER,

Line 1753: l_move_table_pvt wip_batch_move.move_table_pvt;

1749: l_total_row NUMBER;
1750: l_error_msg VARCHAR2(240);
1751: l_error_text VARCHAR2(2000);
1752: l_return_status VARCHAR2(1);
1753: l_move_table_pvt wip_batch_move.move_table_pvt;
1754: l_params wip_logger.param_tbl_t;
1755: BEGIN
1756: -- write parameter value to log file
1757: IF (l_log_level <= wip_constants.trace_logging) THEN

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

1762: l_params(3).paramName := 'p_dept_id';
1763: l_params(3).paramValue := p_dept_id;
1764: l_params(4).paramName := 'p_employee_id';
1765: l_params(4).paramValue := p_employee_id;
1766: wip_logger.entryPoint(p_procName => 'wip_batch_move.process',
1767: p_params => l_params,
1768: x_returnStatus => l_return_status);
1769: END IF;
1770:

Line 1784: l_error_msg := 'wip_batch_move.get_preferences failed';

1780: x_default_scrap_acct_id => l_default_scrap_acct_id,
1781: x_return_status => x_return_status);
1782:
1783: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
1784: l_error_msg := 'wip_batch_move.get_preferences failed';
1785: raise fnd_api.g_exc_unexpected_error;
1786: END IF;
1787: -- Perform generic validation for the whole batch.
1788: validate_batch(p_default_step_type => l_default_step_type,

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

1788: validate_batch(p_default_step_type => l_default_step_type,
1789: x_return_status => x_return_status);
1790:
1791: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
1792: l_error_msg := 'wip_batch_move.validate_batch failed';
1793: raise fnd_api.g_exc_unexpected_error;
1794: END IF;
1795:
1796: l_total_row := p_move_table.count;

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

1812: x_move_table_pvt => l_move_table_pvt,
1813: x_return_status => x_return_status);
1814:
1815: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
1816: l_error_msg := 'wip_batch_move.validate_row failed';
1817: raise fnd_api.g_exc_unexpected_error;
1818: END IF;
1819: -- Insert move/scrap record into WMTI
1820: insert_move_records(p_org_id => p_org_id,

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

1824: x_group_id => l_group_id,
1825: x_return_status => x_return_status);
1826:
1827: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
1828: l_error_msg := 'wip_batch_move.insert_move_records failed';
1829: raise fnd_api.g_exc_unexpected_error;
1830: END IF;
1831: -- Clear all move information.
1832: l_move_table_pvt.delete;

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

1835: process_move_records(p_group_id => l_group_id,
1836: x_return_status => x_return_status);
1837:
1838: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
1839: l_error_msg := 'wip_batch_move.process_move_records failed';
1840: raise fnd_api.g_exc_unexpected_error;
1841: ELSE
1842: -- Initialize message stack to clear "Txn Success" inventory put in
1843: -- the stack.

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

1886: x_return_status := fnd_api.g_ret_sts_error;
1887: END IF;
1888: -- Write to the log file.
1889: IF (l_log_level <= wip_constants.trace_logging) THEN
1890: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',
1891: p_procReturnStatus => x_return_status,
1892: p_msg => 'procedure complete',
1893: x_returnStatus => l_return_status);
1894: wip_logger.cleanUp(x_returnStatus => l_return_status);

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

1896: EXCEPTION
1897: WHEN fnd_api.g_exc_unexpected_error THEN
1898: x_return_status := fnd_api.g_ret_sts_error;
1899: IF (l_log_level <= wip_constants.trace_logging) THEN
1900: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',
1901: p_procReturnStatus => x_return_status,
1902: p_msg => l_error_msg,
1903: x_returnStatus => l_return_status);
1904: wip_logger.cleanUp(x_returnStatus => l_return_status);

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

1908: x_return_status := fnd_api.g_ret_sts_error;
1909: l_error_msg := ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1910:
1911: IF (l_log_level <= wip_constants.trace_logging) THEN
1912: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',
1913: p_procReturnStatus => x_return_status,
1914: p_msg => l_error_msg,
1915: x_returnStatus => l_return_status);
1916: wip_logger.cleanUp(x_returnStatus => l_return_status);

Line 1922: END wip_batch_move;

1918: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1919: fnd_message.set_token('MESSAGE', l_error_msg);
1920: fnd_msg_pub.add;
1921: END process;
1922: END wip_batch_move;