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_MOVPROC_PRIV dependencies on WIP_MOVPROC_PRIV

Line 1: PACKAGE BODY wip_movProc_priv AS

1: PACKAGE BODY wip_movProc_priv AS
2: /* $Header: wipmovpb.pls 120.66.12020000.8 2013/03/14 07:46:02 akuppa ship $*/
3:
4: TYPE move_profile_rec_t IS RECORD(
5: child_txn_id NUMBER,

Line 226: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.backflush_assy_pull',

222: l_params(4).paramValue := p_move_txn_id;
223: l_params(5).paramName := 'p_entity_type';
224: l_params(5).paramValue := p_entity_type;
225:
226: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.backflush_assy_pull',
227: p_params => l_params,
228: x_returnStatus => l_returnStatus);
229: END IF;
230: IF(p_entity_type = WIP_CONSTANTS.REPETITIVE) THEN

Line 409: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.backflush_assy_pull',

405: END LOOP; -- OSFM
406: END IF; -- entity_type check
407: -- write to the log file
408: IF (l_logLevel <= wip_constants.trace_logging) THEN
409: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.backflush_assy_pull',
410: p_procReturnStatus => 'S',
411: p_msg => 'procedure complete',
412: x_returnStatus => l_returnStatus);
413: END IF;

Line 436: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.component_cleanup',

432: l_params(1).paramName := 'p_mtl_header_id';
433: l_params(1).paramValue := p_mtl_header_id;
434: l_params(2).paramName := 'p_group_id';
435: l_params(2).paramValue := p_group_id;
436: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.component_cleanup',
437: p_params => l_params,
438: x_returnStatus => l_returnStatus);
439: END IF;
440: -- Update status of move record to error if components fail inventory

Line 527: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.component_cleanup',

523: END IF;
524:
525: l_returnStatus := fnd_api.g_ret_sts_success;
526: IF (l_logLevel <= wip_constants.trace_logging) THEN
527: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.component_cleanup',
528: p_procReturnStatus => l_returnStatus,
529: p_msg => 'procedure complete',
530: x_returnStatus => l_returnStatus);
531: END IF;

Line 623: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.write_mtl_errors',

619: -- write parameter value to log file
620: IF (l_logLevel <= wip_constants.trace_logging) THEN
621: l_params(1).paramName := 'p_mtl_header_id';
622: l_params(1).paramValue := p_mtl_header_id;
623: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.write_mtl_errors',
624: p_params => l_params,
625: x_returnStatus => l_returnStatus);
626: END IF;
627: l_count := 0;

Line 656: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.write_mtl_errors',

652: END IF;
653:
654: l_returnStatus := fnd_api.g_ret_sts_success;
655: IF (l_logLevel <= wip_constants.trace_logging) THEN
656: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.write_mtl_errors',
657: p_procReturnStatus => l_returnStatus,
658: p_msg => 'procedure complete',
659: x_returnStatus => l_returnStatus);
660: END IF;

Line 667: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.write_mtl_errors',

663: l_returnStatus := fnd_api.g_ret_sts_unexp_error;
664: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
665:
666: IF (l_logLevel <= wip_constants.trace_logging) THEN
667: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.write_mtl_errors',
668: p_procReturnStatus => l_returnStatus,
669: p_msg => l_errMsg,
670: x_returnStatus => l_returnStatus);
671: END IF;

Line 726: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.lock_wipops',

722: l_params(1).paramName := 'p_group_id';
723: l_params(1).paramValue := p_gib.group_id;
724: l_params(2).paramName := 'p_txn_date';
725: l_params(2).paramValue := p_gib.txn_date;
726: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.lock_wipops',
727: p_params => l_params,
728: x_returnStatus => l_returnStatus);
729: END IF;
730:

Line 741: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.lock_wipops',

737: x_returnStatus := fnd_api.g_ret_sts_success;
738:
739: -- write to the log file
740: IF (l_logLevel <= wip_constants.trace_logging) THEN
741: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.lock_wipops',
742: p_procReturnStatus => x_returnStatus,
743: p_msg => 'procedure complete',
744: x_returnStatus => l_returnStatus);
745: END IF;

Line 756: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.lock_wipops',

752: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
753: l_errMsg := 'Unable to lock the record in wip_operations';
754:
755: IF (l_logLevel <= wip_constants.trace_logging) THEN
756: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.lock_wipops',
757: p_procReturnStatus => x_returnStatus,
758: p_msg => l_errMsg,
759: x_returnStatus => l_returnStatus);
760: END IF;

Line 772: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.lock_wipops',

768: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
769: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
770:
771: IF (l_logLevel <= wip_constants.trace_logging) THEN
772: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.lock_wipops',
773: p_procReturnStatus => x_returnStatus,
774: p_msg => l_errMsg,
775: x_returnStatus => l_returnStatus);
776: END IF;

Line 898: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.schedule_alloc',

894: l_params(11).paramName := 'p_fm_form';
895: l_params(11).paramValue := p_fm_form;
896: l_params(12).paramName := 'p_comp_alloc';
897: l_params(12).paramValue := p_comp_alloc;
898: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.schedule_alloc',
899: p_params => l_params,
900: x_returnStatus => l_returnStatus);
901: END IF;
902:

Line 1030: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.schedule_alloc',

1026: x_returnStatus := fnd_api.g_ret_sts_success;
1027: x_proc_status := WIP_CONSTANTS.RUNNING;
1028: -- write to the log file
1029: IF (l_logLevel <= wip_constants.trace_logging) THEN
1030: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.schedule_alloc',
1031: p_procReturnStatus => x_returnStatus,
1032: p_msg => 'procedure complete',
1033: x_returnStatus => l_returnStatus);
1034: END IF;

Line 1044: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.schedule_alloc',

1040: END IF;
1041: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1042:
1043: IF (l_logLevel <= wip_constants.trace_logging) THEN
1044: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.schedule_alloc',
1045: p_procReturnStatus => x_returnStatus,
1046: p_msg => l_errMsg,
1047: x_returnStatus => l_returnStatus);
1048: END IF;

Line 1052: fnd_message.set_token('ROUTINE', 'wip_movProc_priv.schedule_alloc');

1048: END IF;
1049:
1050: /* Fix for bug 5373061: Passed missing token */
1051: fnd_message.set_name('WIP','WIP_INT_ERROR_NO_SCHED');
1052: fnd_message.set_token('ROUTINE', 'wip_movProc_priv.schedule_alloc');
1053: fnd_msg_pub.add;
1054:
1055: WHEN others THEN
1056: IF(c_rsa%ISOPEN) THEN

Line 1064: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.schedule_alloc',

1060: x_proc_status := WIP_CONSTANTS.ERROR;
1061: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1062:
1063: IF (l_logLevel <= wip_constants.trace_logging) THEN
1064: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.schedule_alloc',
1065: p_procReturnStatus => x_returnStatus,
1066: p_msg => l_errMsg,
1067: x_returnStatus => l_returnStatus);
1068: END IF;

Line 1111: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.insert_alloc_child',

1107: l_params(4).paramName := 'p_parent_txn_id';
1108: l_params(4).paramValue := p_parent_txn_id;
1109: l_params(5).paramName := 'child_txn_id';
1110: l_params(5).paramValue := p_gib.move_profile.child_txn_id;
1111: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.insert_alloc_child',
1112: p_params => l_params,
1113: x_returnStatus => l_returnStatus);
1114: END IF;
1115:

Line 1194: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_alloc_child',

1190: x_returnStatus := fnd_api.g_ret_sts_success;
1191:
1192: -- write to the log file
1193: IF (l_logLevel <= wip_constants.trace_logging) THEN
1194: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_alloc_child',
1195: p_procReturnStatus => x_returnStatus,
1196: p_msg => 'procedure complete',
1197: x_returnStatus => l_returnStatus);
1198: END IF;

Line 1206: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_alloc_child',

1202:
1203: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1204:
1205: IF (l_logLevel <= wip_constants.trace_logging) THEN
1206: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_alloc_child',
1207: p_procReturnStatus => x_returnStatus,
1208: p_msg => l_errMsg,
1209: x_returnStatus => l_returnStatus);
1210: END IF;

Line 1221: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_alloc_child',

1217: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1218: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1219:
1220: IF (l_logLevel <= wip_constants.trace_logging) THEN
1221: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_alloc_child',
1222: p_procReturnStatus => x_returnStatus,
1223: p_msg => l_errMsg,
1224: x_returnStatus => l_returnStatus);
1225: END IF;

Line 1269: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.update_wo_rs',

1265: l_params(9).paramName := 'p_to_step';
1266: l_params(9).paramValue := p_rsa_rec(i).toStep;
1267: l_params(10).paramName := 'p_txn_date';
1268: l_params(10).paramValue := p_txn_date;
1269: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.update_wo_rs',
1270: p_params => l_params,
1271: x_returnStatus => l_returnStatus);
1272: END IF;
1273:

Line 1411: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.update_wo_rs',

1407: x_returnStatus := fnd_api.g_ret_sts_success;
1408:
1409: -- write to the log file
1410: IF (l_logLevel <= wip_constants.trace_logging) THEN
1411: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.update_wo_rs',
1412: p_procReturnStatus => x_returnStatus,
1413: p_msg => 'procedure complete',
1414: x_returnStatus => l_returnStatus);
1415: END IF;

Line 1423: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.update_wo_rs',

1419: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1420: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1421:
1422: IF (l_logLevel <= wip_constants.trace_logging) THEN
1423: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.update_wo_rs',
1424: p_procReturnStatus => x_returnStatus,
1425: p_msg => l_errMsg,
1426: x_returnStatus => l_returnStatus);
1427: END IF;

Line 1457: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.update_wipops',

1453: l_params(2).paramName := 'p_group_id';
1454: l_params(2).paramValue := p_gib.group_id;
1455: l_params(3).paramName := 'p_txn_date';
1456: l_params(3).paramValue := p_gib.txn_date;
1457: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.update_wipops',
1458: p_params => l_params,
1459: x_returnStatus => l_returnStatus);
1460: END IF;
1461:

Line 1523: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.update_wipops',

1519: x_returnStatus := fnd_api.g_ret_sts_success;
1520:
1521: -- write to the log file
1522: IF (l_logLevel <= wip_constants.trace_logging) THEN
1523: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.update_wipops',
1524: p_procReturnStatus => x_returnStatus,
1525: p_msg => 'procedure complete',
1526: x_returnStatus => l_returnStatus);
1527: END IF;

Line 1535: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.update_wipops',

1531: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1532: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1533:
1534: IF (l_logLevel <= wip_constants.trace_logging) THEN
1535: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.update_wipops',
1536: p_procReturnStatus => x_returnStatus,
1537: p_msg => l_errMsg,
1538: x_returnStatus => l_returnStatus);
1539: END IF;

Line 1627: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.rep_move_alloc',

1623: l_params(8).paramName := 'p_move_mode';
1624: l_params(8).paramValue := p_gib.move_mode;
1625: l_params(9).paramName := 'p_backflush_mode';
1626: l_params(9).paramValue := p_gib.bf_mode;
1627: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.rep_move_alloc',
1628: p_params => l_params,
1629: x_returnStatus => l_returnStatus);
1630: END IF;
1631:

Line 1713: l_errMsg := 'wip_movProc_priv.update_wipops failed';

1709: p_gib => p_gib,
1710: x_returnStatus => x_returnStatus);
1711:
1712: IF (x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1713: l_errMsg := 'wip_movProc_priv.update_wipops failed';
1714: raise fnd_api.g_exc_unexpected_error;
1715: END IF;
1716:
1717: END IF; -- child txns

Line 1741: l_errMsg := 'wip_movProc_priv.insert_alloc_child failed';

1737: WHERE transaction_id = l_rs_txn.txn_id
1738: AND group_id = p_gib.group_id;
1739: END IF; -- time out check
1740:
1741: l_errMsg := 'wip_movProc_priv.insert_alloc_child failed';
1742: raise fnd_api.g_exc_unexpected_error;
1743:
1744: ELSE -- insert child success
1745: -- insert assemblies in the queue of the first operation after

Line 1752: l_errMsg := 'wip_movProc_priv.update_wipops failed';

1748: p_gib => p_gib,
1749: x_returnStatus => x_returnStatus);
1750:
1751: IF (x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1752: l_errMsg := 'wip_movProc_priv.update_wipops failed';
1753: raise fnd_api.g_exc_unexpected_error;
1754: END IF;
1755:
1756: -- prepare data before calling update_wo_rs

Line 1778: l_errMsg := 'wip_movProc_priv.update_wo_rs failed';

1774: p_txn_date => l_rs_txn.txn_date,
1775: x_returnStatus => x_returnStatus);
1776:
1777: IF (x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1778: l_errMsg := 'wip_movProc_priv.update_wo_rs failed';
1779: raise fnd_api.g_exc_unexpected_error;
1780: END IF;
1781: END IF; -- insert_alloc_child check
1782:

Line 1836: l_errMsg := 'wip_movProc_priv.update_wo_rs failed';

1832: p_txn_date => l_rs_txn.txn_date,
1833: x_returnStatus => x_returnStatus);
1834:
1835: IF (x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1836: l_errMsg := 'wip_movProc_priv.update_wo_rs failed';
1837: raise fnd_api.g_exc_unexpected_error;
1838: END IF;
1839:
1840: ELSIF(l_proc_status = TVE_OVERCOMPLETION_MISMATCH OR

Line 1876: l_errMsg := 'wip_movProc_priv.schedule_alloc failed';

1872: SET process_status = WIP_CONSTANTS.ERROR
1873: WHERE transaction_id = l_rs_txn.txn_id
1874: AND group_id = p_gib.group_id;
1875:
1876: l_errMsg := 'wip_movProc_priv.schedule_alloc failed';
1877: raise fnd_api.g_exc_unexpected_error;
1878:
1879: END IF; -- process_status
1880:

Line 1961: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.rep_move_alloc',

1957: x_returnStatus := fnd_api.g_ret_sts_success;
1958:
1959: -- write to the log file
1960: IF (l_logLevel <= wip_constants.trace_logging) THEN
1961: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.rep_move_alloc',
1962: p_procReturnStatus => x_returnStatus,
1963: p_msg => 'procedure complete',
1964: x_returnStatus => l_returnStatus);
1965: END IF;

Line 1978: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.rep_move_alloc',

1974: END IF;
1975: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1976:
1977: IF (l_logLevel <= wip_constants.trace_logging) THEN
1978: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.rep_move_alloc',
1979: p_procReturnStatus => x_returnStatus,
1980: p_msg => l_errMsg,
1981: x_returnStatus => l_returnStatus);
1982: END IF;

Line 1991: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.rep_move_alloc',

1987: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1988: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1989:
1990: IF (l_logLevel <= wip_constants.trace_logging) THEN
1991: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.rep_move_alloc',
1992: p_procReturnStatus => x_returnStatus,
1993: p_msg => l_errMsg,
1994: x_returnStatus => l_returnStatus);
1995: END IF;

Line 2042: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.update_wo_dj',

2038: l_params(7).paramName := 'p_org_id';
2039: l_params(7).paramValue := p_org_id;
2040: l_params(8).paramName := 'p_wip_id';
2041: l_params(8).paramValue := p_wip_id;
2042: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.update_wo_dj',
2043: p_params => l_params,
2044: x_returnStatus => l_returnStatus);
2045: END IF;
2046:

Line 2189: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.update_wo_dj',

2185: x_returnStatus := fnd_api.g_ret_sts_success;
2186:
2187: -- write to the log file
2188: IF (l_logLevel <= wip_constants.trace_logging) THEN
2189: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.update_wo_dj',
2190: p_procReturnStatus => x_returnStatus,
2191: p_msg => 'procedure complete',
2192: x_returnStatus => l_returnStatus);
2193: END IF;

Line 2201: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.update_wo_dj',

2197: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2198: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
2199:
2200: IF (l_logLevel <= wip_constants.trace_logging) THEN
2201: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.update_wo_dj',
2202: p_procReturnStatus => x_returnStatus,
2203: p_msg => l_errMsg,
2204: x_returnStatus => l_returnStatus);
2205: END IF;

Line 2317: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.check_qty_dj',

2313: l_params(3).paramName := 'p_txn_date';
2314: l_params(3).paramValue := p_gib.txn_date;
2315: l_params(4).paramName := 'p_move_mode';
2316: l_params(4).paramValue := p_gib.move_mode;
2317: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.check_qty_dj',
2318: p_params => l_params,
2319: x_returnStatus => l_returnStatus);
2320: END IF;
2321:

Line 2414: l_errMsg := 'wip_movProc_priv.update_wipops failed';

2410: p_gib => p_gib,
2411: x_returnStatus => x_returnStatus);
2412:
2413: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
2414: l_errMsg := 'wip_movProc_priv.update_wipops failed';
2415: raise fnd_api.g_exc_unexpected_error;
2416: END IF; -- check return status
2417:
2418: ELSE -- IF it is parent or normal txn, validate qty

Line 2483: l_errMsg := 'wip_movProc_priv.insert_alloc_child failed';

2479: WHERE transaction_id = l_dj_txn.txn_id
2480: AND group_id = p_gib.group_id;
2481: END IF; -- time out check
2482:
2483: l_errMsg := 'wip_movProc_priv.insert_alloc_child failed';
2484: raise fnd_api.g_exc_unexpected_error;
2485:
2486: ELSE -- insert child success
2487: -- insert assemblies in the queue of the first operation after

Line 2494: l_errMsg := 'wip_movProc_priv.update_wipops failed';

2490: p_gib => p_gib,
2491: x_returnStatus => x_returnStatus);
2492:
2493: IF (x_returnStatus <> fnd_api.g_ret_sts_success) THEN
2494: l_errMsg := 'wip_movProc_priv.update_wipops failed';
2495: raise fnd_api.g_exc_unexpected_error;
2496: END IF;
2497:
2498: -- update wip_operations for child move txns

Line 2511: l_errMsg := 'wip_movProc_priv.update_wo_dj failed';

2507: p_txn_date => l_dj_txn.txn_date,
2508: x_returnStatus => x_returnStatus);
2509:
2510: IF (x_returnStatus <> fnd_api.g_ret_sts_success) THEN
2511: l_errMsg := 'wip_movProc_priv.update_wo_dj failed';
2512: raise fnd_api.g_exc_unexpected_error;
2513: END IF;
2514: END IF; -- insert_alloc_child check
2515:

Line 2558: l_errMsg := 'wip_movProc_priv.update_wo_dj failed';

2554: p_txn_date => l_dj_txn.txn_date,
2555: x_returnStatus => x_returnStatus);
2556:
2557: IF (x_returnStatus <> fnd_api.g_ret_sts_success) THEN
2558: l_errMsg := 'wip_movProc_priv.update_wo_dj failed';
2559: raise fnd_api.g_exc_unexpected_error;
2560: END IF;
2561:
2562: END IF; -- check enough qty

Line 2642: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.check_qty_dj',

2638: x_returnStatus := fnd_api.g_ret_sts_success;
2639:
2640: -- write to the log file
2641: IF (l_logLevel <= wip_constants.trace_logging) THEN
2642: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.check_qty_dj',
2643: p_procReturnStatus => x_returnStatus,
2644: p_msg => 'procedure complete',
2645: x_returnStatus => l_returnStatus);
2646: END IF;

Line 2657: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.check_qty_dj',

2653: END IF;
2654: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2655:
2656: IF (l_logLevel <= wip_constants.trace_logging) THEN
2657: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.check_qty_dj',
2658: p_procReturnStatus => x_returnStatus,
2659: p_msg => l_errMsg,
2660: x_returnStatus => l_returnStatus);
2661: END IF;

Line 2671: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.check_qty_dj',

2667: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2668: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
2669:
2670: IF (l_logLevel <= wip_constants.trace_logging) THEN
2671: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.check_qty_dj',
2672: p_procReturnStatus => x_returnStatus,
2673: p_msg => l_errMsg,
2674: x_returnStatus => l_returnStatus);
2675: END IF;

Line 2742: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.get_move_profile',

2738: l_params(17).paramName := 'poReqItem';
2739: l_params(17).paramValue := l_move.poReqItem;
2740: l_params(18).paramName := 'poRegLot';
2741: l_params(18).paramValue := l_move.poReqLot;
2742: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.get_move_profile',
2743: p_params => l_params,
2744: x_returnStatus => l_returnStatus);
2745: END IF;
2746:

Line 2866: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.get_move_profile',

2862: x_returnStatus := fnd_api.g_ret_sts_success;
2863:
2864: -- write to the log file
2865: IF (l_logLevel <= wip_constants.trace_logging) THEN
2866: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.get_move_profile',
2867: p_procReturnStatus => x_returnStatus,
2868: p_msg => 'procedure complete',
2869: x_returnStatus => l_returnStatus);
2870: END IF;

Line 2878: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.get_move_profile',

2874: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2875: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
2876:
2877: IF (l_logLevel <= wip_constants.trace_logging) THEN
2878: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.get_move_profile',
2879: p_procReturnStatus => x_returnStatus,
2880: p_msg => l_errMsg,
2881: x_returnStatus => l_returnStatus);
2882: END IF;

Line 2909: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.insert_txn_history',

2905: l_params(1).paramName := 'p_group_id';
2906: l_params(1).paramValue := p_gib.group_id;
2907: l_params(2).paramName := 'p_txn_date';
2908: l_params(2).paramValue := p_gib.txn_date;
2909: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.insert_txn_history',
2910: p_params => l_params,
2911: x_returnStatus => l_returnStatus);
2912: END IF;
2913:

Line 3242: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_txn_history',

3238: x_returnStatus := fnd_api.g_ret_sts_success;
3239:
3240: -- write to the log file
3241: IF (l_logLevel <= wip_constants.trace_logging) THEN
3242: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_txn_history',
3243: p_procReturnStatus => x_returnStatus,
3244: p_msg => 'procedure complete',
3245: x_returnStatus => l_returnStatus);
3246: END IF;

Line 3254: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_txn_history',

3250: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
3251: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
3252:
3253: IF (l_logLevel <= wip_constants.trace_logging) THEN
3254: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_txn_history',
3255: p_procReturnStatus => x_returnStatus,
3256: p_msg => l_errMsg,
3257: x_returnStatus => l_returnStatus);
3258: END IF;

Line 3286: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.delete_child_txn',

3282: l_params(1).paramName := 'p_group_id';
3283: l_params(1).paramValue := p_gib.group_id;
3284: l_params(2).paramName := 'p_txn_date';
3285: l_params(2).paramValue := p_gib.txn_date;
3286: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.delete_child_txn',
3287: p_params => l_params,
3288: x_returnStatus => l_returnStatus);
3289: END IF;
3290:

Line 3308: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.delete_child_txn',

3304: x_returnStatus := fnd_api.g_ret_sts_success;
3305:
3306: -- write to the log file
3307: IF (l_logLevel <= wip_constants.trace_logging) THEN
3308: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.delete_child_txn',
3309: p_procReturnStatus => x_returnStatus,
3310: p_msg => 'procedure complete',
3311: x_returnStatus => l_returnStatus);
3312: END IF;

Line 3319: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.delete_child_txn',

3315: WHEN others THEN
3316: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
3317: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
3318: IF (l_logLevel <= wip_constants.trace_logging) THEN
3319: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.delete_child_txn',
3320: p_procReturnStatus => x_returnStatus,
3321: p_msg => l_errMsg,
3322: x_returnStatus => l_returnStatus);
3323: END IF;

Line 3384: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.insert_auto_resource',

3380: l_params(16).paramName := 'poReqItem';
3381: l_params(16).paramValue := l_move.poReqItem;
3382: l_params(17).paramName := 'poRegLot';
3383: l_params(17).paramValue := l_move.poReqLot;
3384: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.insert_auto_resource',
3385: p_params => l_params,
3386: x_returnStatus => l_returnStatus);
3387: END IF;
3388:

Line 4460: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_auto_resource',

4456: x_returnStatus := fnd_api.g_ret_sts_success;
4457:
4458: -- write to the log file
4459: IF (l_logLevel <= wip_constants.trace_logging) THEN
4460: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_auto_resource',
4461: p_procReturnStatus => x_returnStatus,
4462: p_msg => 'procedure complete',
4463: x_returnStatus => l_returnStatus);
4464: END IF;

Line 4472: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.insert_auto_resource',

4468: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
4469: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
4470:
4471: IF (l_logLevel <= wip_constants.trace_logging) THEN
4472: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.insert_auto_resource',
4473: p_procReturnStatus => x_returnStatus,
4474: p_msg => l_errMsg,
4475: x_returnStatus => l_returnStatus);
4476: END IF;

Line 4504: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.insert_txn_alloc',

4500: -- write parameter value to log file
4501: IF (l_logLevel <= wip_constants.trace_logging) THEN
4502: l_params(1).paramName := 'p_group_id';
4503: l_params(1).paramValue := p_gib.group_id;
4504: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.insert_txn_alloc',
4505: p_params => l_params,
4506: x_returnStatus => l_returnStatus);
4507: END IF;
4508:

Line 4600: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_txn_alloc',

4596: x_returnStatus := fnd_api.g_ret_sts_success;
4597:
4598: -- write to the log file
4599: IF (l_logLevel <= wip_constants.trace_logging) THEN
4600: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_txn_alloc',
4601: p_procReturnStatus => x_returnStatus,
4602: p_msg => 'procedure complete',
4603: x_returnStatus => l_returnStatus);
4604: END IF;

Line 4612: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.insert_txn_alloc',

4608: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
4609: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
4610:
4611: IF (l_logLevel <= wip_constants.trace_logging) THEN
4612: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.insert_txn_alloc',
4613: p_procReturnStatus => x_returnStatus,
4614: p_msg => l_errMsg,
4615: x_returnStatus => l_returnStatus);
4616: END IF;

Line 4676: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.insert_dept_overhead',

4672: l_params(16).paramName := 'poReqItem';
4673: l_params(16).paramValue := l_move.poReqItem;
4674: l_params(17).paramName := 'poRegLot';
4675: l_params(17).paramValue := l_move.poReqLot;
4676: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.insert_dept_overhead',
4677: p_params => l_params,
4678: x_returnStatus => l_returnStatus);
4679: END IF;
4680:

Line 5731: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_dept_overhead',

5727: x_returnStatus := fnd_api.g_ret_sts_success;
5728:
5729: -- write to the log file
5730: IF (l_logLevel <= wip_constants.trace_logging) THEN
5731: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_dept_overhead',
5732: p_procReturnStatus => x_returnStatus,
5733: p_msg => 'procedure complete',
5734: x_returnStatus => l_returnStatus);
5735: END IF;

Line 5743: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.insert_dept_overhead',

5739: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
5740: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
5741:
5742: IF (l_logLevel <= wip_constants.trace_logging) THEN
5743: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.insert_dept_overhead',
5744: p_procReturnStatus => x_returnStatus,
5745: p_msg => l_errMsg,
5746: x_returnStatus => l_returnStatus);
5747: END IF;

Line 5774: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.release_cost_txn',

5770: l_params(1).paramName := 'p_group_id';
5771: l_params(1).paramValue := p_gib.group_id;
5772: l_params(2).paramName := 'p_txn_date';
5773: l_params(2).paramValue := p_gib.txn_date;
5774: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.release_cost_txn',
5775: p_params => l_params,
5776: x_returnStatus => l_returnStatus);
5777: END IF;
5778:

Line 5798: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.release_cost_txn',

5794: x_returnStatus := fnd_api.g_ret_sts_success;
5795:
5796: -- write to the log file
5797: IF (l_logLevel <= wip_constants.trace_logging) THEN
5798: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.release_cost_txn',
5799: p_procReturnStatus => x_returnStatus,
5800: p_msg => 'procedure complete',
5801: x_returnStatus => l_returnStatus);
5802: END IF;

Line 5810: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.release_cost_txn',

5806: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
5807: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
5808:
5809: IF (l_logLevel <= wip_constants.trace_logging) THEN
5810: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.release_cost_txn',
5811: p_procReturnStatus => x_returnStatus,
5812: p_msg => l_errMsg,
5813: x_returnStatus => l_returnStatus);
5814: END IF;

Line 5940: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.insert_po_req',

5936: l_params(16).paramValue := l_move.poReqItem;
5937: l_params(17).paramName := 'poRegLot';
5938: l_params(17).paramValue := l_move.poReqLot;
5939:
5940: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.insert_po_req',
5941: p_params => l_params,
5942: x_returnStatus => l_returnStatus);
5943: END IF;
5944:

Line 6865: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_po_req',

6861: x_returnStatus := fnd_api.g_ret_sts_success;
6862:
6863: -- write to the log file
6864: IF (l_logLevel <= wip_constants.trace_logging) THEN
6865: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_po_req',
6866: p_procReturnStatus => x_returnStatus,
6867: p_msg => 'procedure complete',
6868: x_returnStatus => l_returnStatus);
6869: END IF;

Line 6880: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.insert_po_req',

6876: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
6877: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
6878:
6879: IF (l_logLevel <= wip_constants.trace_logging) THEN
6880: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.insert_po_req',
6881: p_procReturnStatus => x_returnStatus,
6882: p_msg => l_errMsg,
6883: x_returnStatus => l_returnStatus);
6884: END IF;

Line 6978: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.start_workflow',

6974: l_params(1).paramName := 'p_group_id';
6975: l_params(1).paramValue := p_gib.group_id;
6976: l_params(2).paramName := 'p_txn_date';
6977: l_params(2).paramValue := p_gib.txn_date;
6978: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.start_workflow',
6979: p_params => l_params,
6980: x_returnStatus => l_returnStatus);
6981: END IF;
6982: OPEN c_wmti_txn(p_group_id => p_gib.group_id,

Line 7102: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.start_workflow',

7098: END IF;
7099: x_returnStatus := fnd_api.g_ret_sts_success;
7100: -- write to the log file
7101: IF (l_logLevel <= wip_constants.trace_logging) THEN
7102: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.start_workflow',
7103: p_procReturnStatus => x_returnStatus,
7104: p_msg => 'procedure complete',
7105: x_returnStatus => l_returnStatus);
7106: END IF;

Line 7118: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.start_workflow',

7114: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
7115: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
7116:
7117: IF (l_logLevel <= wip_constants.trace_logging) THEN
7118: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.start_workflow',
7119: p_procReturnStatus => x_returnStatus,
7120: p_msg => l_errMsg,
7121: x_returnStatus => l_returnStatus);
7122: END IF;

Line 7152: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.update_complete_qty',

7148: l_params(2).paramName := 'p_txn_date';
7149: l_params(2).paramValue := p_gib.txn_date;
7150: l_params(3).paramName := 'p_txn_id';
7151: l_params(3).paramValue := p_txn_id;
7152: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.update_complete_qty',
7153: p_params => l_params,
7154: x_returnStatus => l_returnStatus);
7155: END IF;
7156:

Line 7318: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.update_complete_qty',

7314: x_returnStatus := fnd_api.g_ret_sts_success;
7315:
7316: -- write to the log file
7317: IF (l_logLevel <= wip_constants.trace_logging) THEN
7318: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.update_complete_qty',
7319: p_procReturnStatus => x_returnStatus,
7320: p_msg => 'procedure complete',
7321: x_returnStatus => l_returnStatus);
7322: END IF;

Line 7330: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.update_complete_qty',

7326: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
7327: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
7328:
7329: IF (l_logLevel <= wip_constants.trace_logging) THEN
7330: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.update_complete_qty',
7331: p_procReturnStatus => x_returnStatus,
7332: p_msg => l_errMsg,
7333: x_returnStatus => l_returnStatus);
7334: END IF;

Line 7360: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.op_snapshot',

7356: -- write parameter value to log file
7357: IF (l_logLevel <= wip_constants.trace_logging) THEN
7358: l_params(1).paramName := 'p_mtl_temp_id';
7359: l_params(1).paramValue := p_mtl_temp_id;
7360: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.op_snapshot',
7361: p_params => l_params,
7362: x_returnStatus => l_returnStatus);
7363: END IF;
7364:

Line 7379: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.op_snapshot',

7375: x_returnStatus := fnd_api.g_ret_sts_success;
7376:
7377: -- write to the log file
7378: IF (l_logLevel <= wip_constants.trace_logging) THEN
7379: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.op_snapshot',
7380: p_procReturnStatus => x_returnStatus,
7381: p_msg => 'procedure complete',
7382: x_returnStatus => l_returnStatus);
7383: END IF;

Line 7390: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.op_snapshot',

7386: WHEN fnd_api.g_exc_unexpected_error THEN
7387: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
7388:
7389: IF (l_logLevel <= wip_constants.trace_logging) THEN
7390: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.op_snapshot',
7391: p_procReturnStatus => x_returnStatus,
7392: p_msg => l_errMsg,
7393: x_returnStatus => l_returnStatus);
7394: END IF;

Line 7404: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.op_snapshot',

7400: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
7401: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
7402:
7403: IF (l_logLevel <= wip_constants.trace_logging) THEN
7404: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.op_snapshot',
7405: p_procReturnStatus => x_returnStatus,
7406: p_msg => l_errMsg,
7407: x_returnStatus => l_returnStatus);
7408: END IF;

Line 7457: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.snapshot_online',

7453: l_params(4).paramName := 'p_txn_type_id';
7454: l_params(4).paramValue := p_txn_type_id;
7455: l_params(5).paramName := 'p_txn_action_id';
7456: l_params(5).paramValue := p_txn_action_id;
7457: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.snapshot_online',
7458: p_params => l_params,
7459: x_returnStatus => l_returnStatus);
7460: END IF;
7461:

Line 7501: l_errMsg := 'wip_movProc_priv.op_snapshot failed';

7497: op_snapshot(p_mtl_temp_id => l_mmtt.mtl_temp_id,
7498: x_returnStatus => x_returnStatus);
7499:
7500: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
7501: l_errMsg := 'wip_movProc_priv.op_snapshot failed';
7502: raise fnd_api.g_exc_unexpected_error;
7503: END IF; -- check return status
7504: END LOOP; -- END for loop
7505: END IF;

Line 7511: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.snapshot_online',

7507: x_returnStatus := fnd_api.g_ret_sts_success;
7508:
7509: -- write to the log file
7510: IF (l_logLevel <= wip_constants.trace_logging) THEN
7511: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.snapshot_online',
7512: p_procReturnStatus => x_returnStatus,
7513: p_msg => 'procedure complete',
7514: x_returnStatus => l_returnStatus);
7515: END IF;

Line 7522: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.snapshot_online',

7518: WHEN fnd_api.g_exc_unexpected_error THEN
7519: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
7520:
7521: IF (l_logLevel <= wip_constants.trace_logging) THEN
7522: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.snapshot_online',
7523: p_procReturnStatus => x_returnStatus,
7524: p_msg => l_errMsg,
7525: x_returnStatus => l_returnStatus);
7526: END IF;

Line 7533: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.snapshot_online',

7529: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
7530: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
7531:
7532: IF (l_logLevel <= wip_constants.trace_logging) THEN
7533: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.snapshot_online',
7534: p_procReturnStatus => x_returnStatus,
7535: p_msg => l_errMsg,
7536: x_returnStatus => l_returnStatus);
7537: END IF;

Line 7630: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.snapshot_background',

7626: l_params(2).paramName := 'p_txn_date';
7627: l_params(2).paramValue := p_txn_date;
7628: l_params(3).paramName := 'p_txn_id';
7629: l_params(3).paramValue := p_txn_id;
7630: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.snapshot_background',
7631: p_params => l_params,
7632: x_returnStatus => l_returnStatus);
7633: END IF;
7634:

Line 7715: l_errMsg := 'wip_movProc_priv.op_snapshot failed';

7711: op_snapshot(p_mtl_temp_id => l_txns.mtl_temp_id,
7712: x_returnStatus => x_returnStatus);
7713:
7714: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
7715: l_errMsg := 'wip_movProc_priv.op_snapshot failed';
7716: raise fnd_api.g_exc_unexpected_error;
7717: END IF; -- check return status
7718: END IF; -- check load from interface and source code
7719: END LOOP;

Line 7726: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.snapshot_background',

7722: x_returnStatus := fnd_api.g_ret_sts_success;
7723:
7724: -- write to the log file
7725: IF (l_logLevel <= wip_constants.trace_logging) THEN
7726: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.snapshot_background',
7727: p_procReturnStatus => x_returnStatus,
7728: p_msg => 'procedure complete',
7729: x_returnStatus => l_returnStatus);
7730: END IF;

Line 7737: wip_logger.exitPoint(p_procName =>'wip_movProc_priv.snapshot_background',

7733: WHEN fnd_api.g_exc_unexpected_error THEN
7734: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
7735:
7736: IF (l_logLevel <= wip_constants.trace_logging) THEN
7737: wip_logger.exitPoint(p_procName =>'wip_movProc_priv.snapshot_background',
7738: p_procReturnStatus => x_returnStatus,
7739: p_msg => l_errMsg,
7740: x_returnStatus => l_returnStatus);
7741: END IF;

Line 7748: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.snapshot_background',

7744: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
7745: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
7746:
7747: IF (l_logLevel <= wip_constants.trace_logging) THEN
7748: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.snapshot_background',
7749: p_procReturnStatus => x_returnStatus,
7750: p_msg => l_errMsg,
7751: x_returnStatus => l_returnStatus);
7752: END IF;

Line 7786: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.update_wo_and_snapshot',

7782: l_params(2).paramName := 'p_gib.txn_date';
7783: l_params(2).paramValue := p_gib.txn_date;
7784: l_params(3).paramName := 'p_gib.seq_move';
7785: l_params(3).paramValue := p_gib.seq_move;
7786: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.update_wo_and_snapshot',
7787: p_params => l_params,
7788: x_returnStatus => l_returnStatus);
7789: END IF;
7790:

Line 7799: l_errMsg := 'wip_movProc_priv.update_complete_qty failed';

7795: p_txn_id => l_move_rec.txn_id,
7796: x_returnStatus => x_returnStatus);
7797:
7798: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
7799: l_errMsg := 'wip_movProc_priv.update_complete_qty failed';
7800: raise fnd_api.g_exc_unexpected_error;
7801: END IF; -- check return status
7802:
7803: snapshot_background(p_group_id => p_gib.group_id,

Line 7809: l_errMsg := 'wip_movProc_priv.snapshot_background failed';

7805: p_txn_date => p_gib.txn_date,
7806: x_returnStatus => x_returnStatus);
7807:
7808: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
7809: l_errMsg := 'wip_movProc_priv.snapshot_background failed';
7810: raise fnd_api.g_exc_unexpected_error;
7811: END IF; -- check return status
7812: END LOOP;
7813: ELSE

Line 7819: l_errMsg := 'wip_movProc_priv.update_complete_qty failed';

7815: update_complete_qty(p_gib => p_gib,
7816: x_returnStatus => x_returnStatus);
7817:
7818: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
7819: l_errMsg := 'wip_movProc_priv.update_complete_qty failed';
7820: raise fnd_api.g_exc_unexpected_error;
7821: END IF; -- check return status
7822:
7823: snapshot_background(p_group_id => p_gib.group_id,

Line 7828: l_errMsg := 'wip_movProc_priv.snapshot_background failed';

7824: p_txn_date => p_gib.txn_date,
7825: x_returnStatus => x_returnStatus);
7826:
7827: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
7828: l_errMsg := 'wip_movProc_priv.snapshot_background failed';
7829: raise fnd_api.g_exc_unexpected_error;
7830: END IF; -- check return status
7831: END IF;
7832:

Line 7836: wip_logger.exitPoint(p_procName =>'wip_movProc_priv.update_wo_and_snapshot',

7832:
7833: x_returnStatus := fnd_api.g_ret_sts_success;
7834: -- write to the log file
7835: IF (l_logLevel <= wip_constants.trace_logging) THEN
7836: wip_logger.exitPoint(p_procName =>'wip_movProc_priv.update_wo_and_snapshot',
7837: p_procReturnStatus => x_returnStatus,
7838: p_msg => 'procedure complete',
7839: x_returnStatus => l_returnStatus);
7840: END IF;

Line 7845: wip_logger.exitPoint(p_procName =>'wip_movProc_priv.update_wo_and_snapshot',

7841: EXCEPTION
7842: WHEN fnd_api.g_exc_unexpected_error THEN
7843: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
7844: IF (l_logLevel <= wip_constants.trace_logging) THEN
7845: wip_logger.exitPoint(p_procName =>'wip_movProc_priv.update_wo_and_snapshot',
7846: p_procReturnStatus => x_returnStatus,
7847: p_msg => l_errMsg,
7848: x_returnStatus => l_returnStatus);
7849: END IF;

Line 7856: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.update_wo_and_snapshot',

7852: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
7853: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
7854:
7855: IF (l_logLevel <= wip_constants.trace_logging) THEN
7856: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.update_wo_and_snapshot',
7857: p_procReturnStatus => x_returnStatus,
7858: p_msg => l_errMsg,
7859: x_returnStatus => l_returnStatus);
7860: END IF;

Line 7989: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.scrap_txns',

7985: l_params(19).paramName := 'p_move_mode';
7986: l_params(19).paramValue := p_gib.move_mode;
7987: l_params(20).paramName := 'p_mtl_mode';
7988: l_params(20).paramValue := p_gib.mtl_mode;
7989: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.scrap_txns',
7990: p_params => l_params,
7991: x_returnStatus => l_returnStatus);
7992: END IF;
7993:

Line 8522: l_errMsg := 'wip_movProc_priv.snapshot_online failed';

8518: p_txn_action_id => WIP_CONSTANTS.SCRASSY_ACTION,
8519: x_returnStatus => x_returnStatus);
8520:
8521: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
8522: l_errMsg := 'wip_movProc_priv.snapshot_online failed';
8523: raise fnd_api.g_exc_unexpected_error;
8524: END IF; -- check return status
8525: END IF; -- move mode check
8526: END IF; -- IF job txns

Line 8589: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.scrap_txns',

8585: x_returnStatus := fnd_api.g_ret_sts_success;
8586:
8587: -- write to the log file
8588: IF (l_logLevel <= wip_constants.trace_logging) THEN
8589: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.scrap_txns',
8590: p_procReturnStatus => x_returnStatus,
8591: p_msg => 'procedure complete',
8592: x_returnStatus => l_returnStatus);
8593: END IF;

Line 8599: wip_logger.exitPoint(p_procName =>'wip_movProc_priv.scrap_txns',

8595: EXCEPTION
8596: WHEN fnd_api.g_exc_unexpected_error THEN
8597: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
8598: IF (l_logLevel <= wip_constants.trace_logging) THEN
8599: wip_logger.exitPoint(p_procName =>'wip_movProc_priv.scrap_txns',
8600: p_procReturnStatus => x_returnStatus,
8601: p_msg => l_errMsg,
8602: x_returnStatus => l_returnStatus);
8603: END IF;

Line 8610: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.scrap_txns',

8606: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
8607: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
8608:
8609: IF (l_logLevel <= wip_constants.trace_logging) THEN
8610: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.scrap_txns',
8611: p_procReturnStatus => x_returnStatus,
8612: p_msg => l_errMsg,
8613: x_returnStatus => l_returnStatus);
8614: END IF;

Line 8713: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.ez_completion',

8709: l_params(21).paramValue := p_txn_type;
8710: l_params(22).paramName := 'p_assy_header_id';
8711: l_params(22).paramValue := p_gib.assy_header_id;
8712:
8713: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.ez_completion',
8714: p_params => l_params,
8715: x_returnStatus => l_returnStatus);
8716: END IF;
8717:

Line 9400: l_errMsg := 'wip_movProc_priv.snapshot_online failed';

9396: p_txn_action_id => l_txn_action_id,
9397: x_returnStatus => x_returnStatus);
9398:
9399: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9400: l_errMsg := 'wip_movProc_priv.snapshot_online failed';
9401: raise fnd_api.g_exc_unexpected_error;
9402: END IF; -- check return status
9403: ELSE -- move is background
9404: IF(p_txn_type = WIP_CONSTANTS.RET_TXN) THEN

Line 9410: l_errMsg := 'wip_movProc_priv.snapshot_background failed';

9406: p_txn_date => p_gib.txn_date,
9407: x_returnStatus => x_returnStatus);
9408:
9409: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9410: l_errMsg := 'wip_movProc_priv.snapshot_background failed';
9411: raise fnd_api.g_exc_unexpected_error;
9412: END IF; -- check return status
9413: END IF; -- return transaction
9414: END IF; -- move mode check

Line 9420: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.ez_completion',

9416: x_returnStatus := fnd_api.g_ret_sts_success;
9417:
9418: -- write to the log file
9419: IF (l_logLevel <= wip_constants.trace_logging) THEN
9420: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.ez_completion',
9421: p_procReturnStatus => x_returnStatus,
9422: p_msg => 'procedure complete',
9423: x_returnStatus => l_returnStatus);
9424: END IF;

Line 9430: wip_logger.exitPoint(p_procName =>'wip_movProc_priv.ez_completion',

9426: EXCEPTION
9427: WHEN fnd_api.g_exc_unexpected_error THEN
9428: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
9429: IF (l_logLevel <= wip_constants.trace_logging) THEN
9430: wip_logger.exitPoint(p_procName =>'wip_movProc_priv.ez_completion',
9431: p_procReturnStatus => x_returnStatus,
9432: p_msg => l_errMsg,
9433: x_returnStatus => l_returnStatus);
9434: END IF;

Line 9441: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.ez_completion',

9437: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
9438: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
9439:
9440: IF (l_logLevel <= wip_constants.trace_logging) THEN
9441: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.ez_completion',
9442: p_procReturnStatus => x_returnStatus,
9443: p_msg => l_errMsg,
9444: x_returnStatus => l_returnStatus);
9445: END IF;

Line 9471: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.update_wro',

9467: l_params(1).paramName := 'p_group_id';
9468: l_params(1).paramValue := p_gib.group_id;
9469: l_params(2).paramName := 'p_txn_date';
9470: l_params(2).paramValue := p_gib.txn_date;
9471: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.update_wro',
9472: p_params => l_params,
9473: x_returnStatus => l_returnStatus);
9474: END IF;
9475:

Line 9540: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.update_wro',

9536: x_returnStatus := fnd_api.g_ret_sts_success;
9537:
9538: -- write to the log file
9539: IF (l_logLevel <= wip_constants.trace_logging) THEN
9540: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.update_wro',
9541: p_procReturnStatus => x_returnStatus,
9542: p_msg => 'procedure complete',
9543: x_returnStatus => l_returnStatus);
9544: END IF;

Line 9552: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.update_wro',

9548: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
9549: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
9550:
9551: IF (l_logLevel <= wip_constants.trace_logging) THEN
9552: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.update_wro',
9553: p_procReturnStatus => x_returnStatus,
9554: p_msg => l_errMsg,
9555: x_returnStatus => l_returnStatus);
9556: END IF;

Line 9646: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.move_txns',

9642: l_params(30).paramName := 'p_poReqItem';
9643: l_params(30).paramValue := l_move.poReqItem;
9644: l_params(31).paramName := 'p_poReqLot';
9645: l_params(31).paramValue := l_move.poReqLot;
9646: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.move_txns',
9647: p_params => l_params,
9648: x_returnStatus => l_returnStatus);
9649: END IF;
9650:

Line 9656: l_errMsg := 'wip_movProc_priv.lock_wipops failed';

9652: lock_wipops(p_gib => p_gib,
9653: x_returnStatus => x_returnStatus);
9654:
9655: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9656: l_errMsg := 'wip_movProc_priv.lock_wipops failed';
9657: raise fnd_api.g_exc_unexpected_error;
9658: END IF; -- check return status
9659:
9660: -- Call repetitive allocatioin for repetitive schedule

Line 9666: l_errMsg := 'wip_movProc_priv.rep_move_alloc failed';

9662: rep_move_alloc(p_gib => p_gib,
9663: x_returnStatus => x_returnStatus);
9664:
9665: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9666: l_errMsg := 'wip_movProc_priv.rep_move_alloc failed';
9667: raise fnd_api.g_exc_unexpected_error;
9668: END IF; -- check return status
9669: END IF; -- check repetitive schedules
9670:

Line 9677: l_errMsg := 'wip_movProc_priv.check_qty_dj failed';

9673: check_qty_dj(p_gib => p_gib,
9674: x_returnStatus => x_returnStatus);
9675:
9676: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9677: l_errMsg := 'wip_movProc_priv.check_qty_dj failed';
9678: raise fnd_api.g_exc_unexpected_error;
9679: END IF; -- check return status
9680: END IF; -- check discrete and OSFM jobs
9681:

Line 9688: l_errMsg := 'wip_movProc_priv.update_wro failed';

9684: update_wro(p_gib => p_gib,
9685: x_returnStatus => x_returnStatus);
9686:
9687: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9688: l_errMsg := 'wip_movProc_priv.update_wro failed';
9689: raise fnd_api.g_exc_unexpected_error;
9690: END IF; -- check return status
9691:
9692: -- Record move transactions history in WIP_MOVE_TRANSACTIONS

Line 9697: l_errMsg := 'wip_movProc_priv.insert_txn_history failed';

9693: insert_txn_history(p_gib => p_gib,
9694: x_returnStatus => x_returnStatus);
9695:
9696: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9697: l_errMsg := 'wip_movProc_priv.insert_txn_history failed';
9698: raise fnd_api.g_exc_unexpected_error;
9699: END IF; -- check return status
9700:
9701: -- Delete child record (overmove/overcompletion/overreturn)

Line 9707: l_errMsg := 'wip_movProc_priv.delete_child_txn failed';

9703: x_returnStatus => x_returnStatus);
9704:
9705: -- Delete child record (overmove/overcompletion/overreturn)
9706: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9707: l_errMsg := 'wip_movProc_priv.delete_child_txn failed';
9708: raise fnd_api.g_exc_unexpected_error;
9709: END IF; -- check return status
9710:
9711: -- Delete child record (overmove/overcompletion/overreturn)

Line 9718: l_errMsg := 'wip_movProc_priv.insert_auto_resource failed';

9714: insert_auto_resource(p_gib => p_gib,
9715: x_returnStatus => x_returnStatus);
9716:
9717: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9718: l_errMsg := 'wip_movProc_priv.insert_auto_resource failed';
9719: raise fnd_api.g_exc_unexpected_error;
9720: END IF; -- check return status
9721:
9722: -- Only call the cost allocation IF schedule transactions and auto resource

Line 9731: l_errMsg := 'wip_movProc_priv.insert_txn_alloc failed';

9727: insert_txn_alloc(p_gib => p_gib,
9728: x_returnStatus => x_returnStatus);
9729:
9730: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9731: l_errMsg := 'wip_movProc_priv.insert_txn_alloc failed';
9732: raise fnd_api.g_exc_unexpected_error;
9733: END IF; -- check return status
9734: END IF; -- repetitive schedule and resource per item exist
9735:

Line 9741: l_errMsg := 'wip_movProc_priv.insert_dept_overhead failed';

9737: insert_dept_overhead(p_gib => p_gib,
9738: x_returnStatus => x_returnStatus);
9739:
9740: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9741: l_errMsg := 'wip_movProc_priv.insert_dept_overhead failed';
9742: raise fnd_api.g_exc_unexpected_error;
9743: END IF; -- check return status
9744:
9745: -- Release costing transactions

Line 9750: l_errMsg := 'wip_movProc_priv.release_cost_txn failed';

9746: release_cost_txn(p_gib => p_gib,
9747: x_returnStatus => x_returnStatus);
9748:
9749: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9750: l_errMsg := 'wip_movProc_priv.release_cost_txn failed';
9751: raise fnd_api.g_exc_unexpected_error;
9752: END IF; -- check return status
9753:
9754: -- IF PO installed and PO, insert PO info into PO_REQUISITIONS_INTERFACE_ALL

Line 9770: l_errMsg := 'wip_movProc_priv.insert_po_req failed';

9766: insert_po_req(p_gib => p_gib,
9767: x_returnStatus => x_returnStatus);
9768:
9769: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9770: l_errMsg := 'wip_movProc_priv.insert_po_req failed';
9771: raise fnd_api.g_exc_unexpected_error;
9772: END IF; -- check return status
9773: END IF;
9774: END IF;

Line 9783: l_errMsg := 'wip_movProc_priv.update_complete_qty failed';

9779: update_complete_qty(p_gib => p_gib,
9780: x_returnStatus => x_returnStatus);
9781:
9782: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9783: l_errMsg := 'wip_movProc_priv.update_complete_qty failed';
9784: raise fnd_api.g_exc_unexpected_error;
9785: END IF; -- check return status
9786: END IF;
9787:

Line 9794: l_errMsg := 'wip_movProc_priv.scrap_txns failed';

9790: scrap_txns(p_gib => p_gib,
9791: x_returnStatus => x_returnStatus);
9792:
9793: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9794: l_errMsg := 'wip_movProc_priv.scrap_txns failed';
9795: raise fnd_api.g_exc_unexpected_error;
9796: END IF; -- check return status
9797:
9798: -- Start workflow for OSP stuff

Line 9803: l_errMsg := 'wip_movProc_priv.start_workflow failed';

9799: start_workflow(p_gib => p_gib,
9800: x_returnStatus => x_returnStatus);
9801:
9802: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9803: l_errMsg := 'wip_movProc_priv.start_workflow failed';
9804: raise fnd_api.g_exc_unexpected_error;
9805: END IF; -- check return status
9806:
9807: x_returnStatus := fnd_api.g_ret_sts_success;

Line 9811: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.move_txns',

9807: x_returnStatus := fnd_api.g_ret_sts_success;
9808:
9809: -- write to the log file
9810: IF (l_logLevel <= wip_constants.trace_logging) THEN
9811: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.move_txns',
9812: p_procReturnStatus => x_returnStatus,
9813: p_msg => 'procedure complete',
9814: x_returnStatus => l_returnStatus);
9815: END IF;

Line 9821: wip_logger.exitPoint(p_procName =>'wip_movProc_priv.move_txns',

9817: EXCEPTION
9818: WHEN fnd_api.g_exc_unexpected_error THEN
9819: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
9820: IF (l_logLevel <= wip_constants.trace_logging) THEN
9821: wip_logger.exitPoint(p_procName =>'wip_movProc_priv.move_txns',
9822: p_procReturnStatus => x_returnStatus,
9823: p_msg => l_errMsg,
9824: x_returnStatus => l_returnStatus);
9825: END IF;

Line 9832: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.move_txns',

9828: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
9829: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
9830:
9831: IF (l_logLevel <= wip_constants.trace_logging) THEN
9832: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.move_txns',
9833: p_procReturnStatus => x_returnStatus,
9834: p_msg => l_errMsg,
9835: x_returnStatus => l_returnStatus);
9836: END IF;

Line 10011: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.processIntf',

10007: l_params(12).paramValue := p_assy_header_id;
10008: l_params(13).paramName := 'p_allow_partial_commit';
10009: l_params(13).paramValue := p_allow_partial_commit;
10010:
10011: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.processIntf',
10012: p_params => l_params,
10013: x_returnStatus => l_returnStatus);
10014: END IF;
10015:

Line 10222: l_errMsg := 'wip_movProc_priv.get_move_profile failed';

10218: get_move_profile(p_gib => l_gib,
10219: x_returnStatus => x_returnStatus);
10220:
10221: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
10222: l_errMsg := 'wip_movProc_priv.get_move_profile failed';
10223: raise fnd_api.g_exc_unexpected_error;
10224: END IF; -- check return status
10225:
10226: -- check IF easy return txns

Line 10234: l_errMsg := 'wip_movProc_priv.ez_completion (return) failed';

10230: p_txn_type => WIP_CONSTANTS.RET_TXN,
10231: x_returnStatus => x_returnStatus);
10232:
10233: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
10234: l_errMsg := 'wip_movProc_priv.ez_completion (return) failed';
10235: raise fnd_api.g_exc_unexpected_error;
10236: END IF; -- check return status
10237: ELSE /* Bug fix 5026797 (base 4901865) - Assembly completion/return transaction through Discrete Workstation are
10238: processed with p_insertAssy = fnd_api.g_false. Added the following call to snapshot

Line 10248: l_errMsg := 'wip_movProc_priv.snapshot_online (return) failed';

10244: p_txn_action_id => WIP_CONSTANTS.RETASSY_ACTION,
10245: x_returnStatus => x_returnStatus);
10246:
10247: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
10248: l_errMsg := 'wip_movProc_priv.snapshot_online (return) failed';
10249: raise fnd_api.g_exc_unexpected_error;
10250: END IF; -- check return status
10251: END IF; -- p_insertAssy = fnd_api.g_true
10252: /* End of bug fix 5026797 */

Line 10285: l_errMsg := 'wip_movProc_priv.move_txns failed';

10281: move_txns(p_gib => l_gib,
10282: x_returnStatus => x_returnStatus);
10283:
10284: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
10285: l_errMsg := 'wip_movProc_priv.move_txns failed';
10286: raise fnd_api.g_exc_unexpected_error;
10287: END IF; -- check return status
10288:
10289: -- check IF easy completion txns

Line 10297: l_errMsg := 'wip_movProc_priv.ez_completion (complete) failed';

10293: p_txn_type => WIP_CONSTANTS.COMP_TXN,
10294: x_returnStatus => x_returnStatus);
10295:
10296: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
10297: l_errMsg := 'wip_movProc_priv.ez_completion (complete) failed';
10298: raise fnd_api.g_exc_unexpected_error;
10299: END IF; -- check return status
10300: ELSE /* Bug fix 5026797 (base 4901865) - Assembly completion/return transaction through Discrete Workstation are
10301: processed with p_insertAssy = fnd_api.g_false. Added the following call to snapshot for assembly completion transaction.*/

Line 10310: l_errMsg := 'wip_movProc_priv.snapshot_online(complete) failed';

10306: p_txn_action_id => WIP_CONSTANTS.CPLASSY_ACTION,
10307: x_returnStatus => x_returnStatus);
10308:
10309: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
10310: l_errMsg := 'wip_movProc_priv.snapshot_online(complete) failed';
10311: raise fnd_api.g_exc_unexpected_error;
10312: END IF; -- check return status
10313: END IF; -- p_insertAssy = fnd_api.g_true
10314: /* End of bug fix 5026797 */

Line 10323: l_errMsg := 'wip_movProc_priv.update_wo_and_snapshot';

10319: IF(l_gib.move_mode = WIP_CONSTANTS.BACKGROUND) THEN
10320: update_wo_and_snapshot(p_gib => l_gib,
10321: x_returnStatus => x_returnStatus);
10322: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
10323: l_errMsg := 'wip_movProc_priv.update_wo_and_snapshot';
10324: raise fnd_api.g_exc_unexpected_error;
10325: END IF; -- check return status
10326: END IF;
10327:

Line 10758: wip_logger.exitPoint(p_procName =>'wip_movProc_priv.processIntf',

10754: ROLLBACK TO SAVEPOINT s_move_proc;
10755: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
10756: END IF;
10757: IF (l_logLevel <= wip_constants.trace_logging) THEN
10758: wip_logger.exitPoint(p_procName =>'wip_movProc_priv.processIntf',
10759: p_procReturnStatus => x_returnStatus,
10760: p_msg => l_errMsg,
10761: x_returnStatus => l_returnStatus);
10762: END IF;

Line 10819: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.processIntf',

10815: WHERE wtie.transaction_id = wmti.transaction_id);
10816: ELSE -- move mode is online
10817: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
10818: IF (l_logLevel <= wip_constants.trace_logging) THEN
10819: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.processIntf',
10820: p_procReturnStatus => x_returnStatus,
10821: p_msg => 'unexpected error: ' || SQLERRM,
10822: x_returnStatus => l_returnStatus);
10823: END IF;

Line 10895: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.processIntf',

10891: -- applicable for background transaction.
10892: --fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
10893: --fnd_msg_pub.add;
10894: IF (l_logLevel <= wip_constants.trace_logging) THEN
10895: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.processIntf',
10896: p_procReturnStatus => x_returnStatus,
10897: p_msg => 'some records error out',
10898: x_returnStatus => l_returnStatus);
10899: END IF;

Line 10914: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.processIntf',

10910: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
10911: ELSE
10912: x_returnStatus := fnd_api.g_ret_sts_success;
10913: IF (l_logLevel <= wip_constants.trace_logging) THEN
10914: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.processIntf',
10915: p_procReturnStatus => x_returnStatus,
10916: p_msg => 'no record in this group error out',
10917: x_returnStatus => l_returnStatus);
10918: END IF;

Line 10963: wip_movProc_priv.processIntf

10959: -- should not delete lock record from their temp table. These lock records
10960: -- will be deleted when wip call inv_table_lock_pvt.release_locks.
10961: WIP_CONSTANTS.WIP_MOVE_WORKER := 'Y';
10962:
10963: wip_movProc_priv.processIntf
10964: (p_group_id => p_group_id,
10965: p_proc_phase => p_proc_phase,
10966: p_time_out => p_time_out,
10967: p_move_mode => WIP_CONSTANTS.BACKGROUND,

Line 10986: -- instead of wip_movProc_priv.processIntf().

10982: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
10983: retcode := 2; -- error
10984: -- Fixed bug 5355443. Since WIP_SOME_RECORDS_ERROR message is only
10985: -- applicable to background transaction, we should set error message here
10986: -- instead of wip_movProc_priv.processIntf().
10987: --wip_utilities.get_message_stack(p_msg =>errbuf);
10988: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
10989: errbuf := fnd_message.get;
10990: END IF;

Line 11010: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.repetitive_scrap',

11006: -- write parameter value to log file
11007: IF (l_logLevel <= wip_constants.trace_logging) THEN
11008: l_params(1).paramName := 'p_tmp_id';
11009: l_params(1).paramValue := p_tmp_id;
11010: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.repetitive_scrap',
11011: p_params => l_params,
11012: x_returnStatus => l_returnStatus);
11013: END IF;
11014: -- insert into mtl_material_txn_allocations for repetitive schedule

Line 11075: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.repetitive_scrap',

11071: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
11072: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
11073:
11074: IF (l_logLevel <= wip_constants.trace_logging) THEN
11075: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.repetitive_scrap',
11076: p_procReturnStatus => x_returnStatus,
11077: p_msg => l_msg,
11078: x_returnStatus => l_returnStatus);
11079: END IF;

Line 11373: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.processOATxn',

11369: l_params(6).paramValue := p_print_label; /* VJ Label Printing */
11370: l_params(7).paramName := 'p_print_cmpl_label'; /*Bug 13103060*/
11371: l_params(7).paramValue := p_print_cmpl_label; /*Bug 13103060*/
11372:
11373: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.processOATxn',
11374: p_params => l_params,
11375: x_returnStatus => l_return_status);
11376: END IF;
11377: l_process_phase := '2';

Line 11538: wip_movProc_priv.processIntf

11534: wip_move_validator.validateOATxn(p_group_id => p_group_id);
11535: l_process_phase := '4';
11536:
11537: -- Process move and material records.
11538: wip_movProc_priv.processIntf
11539: (p_group_id => p_group_id,
11540: p_child_txn_id => p_child_txn_id,
11541: p_mtl_header_id => p_mtl_header_id,
11542: p_assy_header_id => p_mtl_header_id,

Line 11597: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.processOATxn',

11593: x_returnStatus := fnd_api.g_ret_sts_success;
11594:
11595: -- write to the log file
11596: IF (l_log_level <= wip_constants.trace_logging) THEN
11597: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.processOATxn',
11598: p_procReturnStatus => x_returnStatus,
11599: p_msg => 'procedure complete',
11600: x_returnStatus => l_return_status);
11601: END IF;

Line 11618: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.processOATxn',

11614: END LOOP;
11615: ROLLBACK TO SAVEPOINT s_oa_txn_proc;
11616: x_returnStatus := fnd_api.g_ret_sts_error;
11617: IF (l_log_level <= wip_constants.trace_logging) THEN
11618: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.processOATxn',
11619: p_procReturnStatus => x_returnStatus,
11620: p_msg => 'wip_movProc_priv.processOATxn failed : '
11621: || l_process_phase,
11622: x_returnStatus => l_return_status);

Line 11620: p_msg => 'wip_movProc_priv.processOATxn failed : '

11616: x_returnStatus := fnd_api.g_ret_sts_error;
11617: IF (l_log_level <= wip_constants.trace_logging) THEN
11618: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.processOATxn',
11619: p_procReturnStatus => x_returnStatus,
11620: p_msg => 'wip_movProc_priv.processOATxn failed : '
11621: || l_process_phase,
11622: x_returnStatus => l_return_status);
11623: END IF;
11624: -- close log file

Line 11636: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.processOATxn',

11632: fnd_message.set_token('MESSAGE', l_error_msg);
11633: fnd_msg_pub.add;
11634:
11635: IF (l_log_level <= wip_constants.trace_logging) THEN
11636: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.processOATxn',
11637: p_procReturnStatus => x_returnStatus,
11638: p_msg => l_error_msg || ' : ' || l_process_phase,
11639: x_returnStatus => l_return_status);
11640: END IF;

Line 11659: END wip_movProc_priv;

11655: WHERE transaction_header_id = p_assy_header_id;
11656:
11657: END clean_up;
11658:
11659: END wip_movProc_priv;