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.52.12010000.2 2008/09/02 21:53:58 hliew ship $*/
3:
4: TYPE move_profile_rec_t IS RECORD(
5: child_txn_id NUMBER,

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

189: l_params(4).paramValue := p_move_txn_id;
190: l_params(5).paramName := 'p_entity_type';
191: l_params(5).paramValue := p_entity_type;
192:
193: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.backflush_assy_pull',
194: p_params => l_params,
195: x_returnStatus => l_returnStatus);
196: END IF;
197: IF(p_entity_type = WIP_CONSTANTS.REPETITIVE) THEN

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

323: END LOOP; -- OSFM
324: END IF; -- entity_type check
325: -- write to the log file
326: IF (l_logLevel <= wip_constants.trace_logging) THEN
327: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.backflush_assy_pull',
328: p_procReturnStatus => 'S',
329: p_msg => 'procedure complete',
330: x_returnStatus => l_returnStatus);
331: END IF;

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

350: l_params(1).paramName := 'p_mtl_header_id';
351: l_params(1).paramValue := p_mtl_header_id;
352: l_params(2).paramName := 'p_group_id';
353: l_params(2).paramValue := p_group_id;
354: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.component_cleanup',
355: p_params => l_params,
356: x_returnStatus => l_returnStatus);
357: END IF;
358: -- Update status of move record to error if components fail inventory

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

402: END IF;
403:
404: l_returnStatus := fnd_api.g_ret_sts_success;
405: IF (l_logLevel <= wip_constants.trace_logging) THEN
406: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.component_cleanup',
407: p_procReturnStatus => l_returnStatus,
408: p_msg => 'procedure complete',
409: x_returnStatus => l_returnStatus);
410: END IF;

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

498: -- write parameter value to log file
499: IF (l_logLevel <= wip_constants.trace_logging) THEN
500: l_params(1).paramName := 'p_mtl_header_id';
501: l_params(1).paramValue := p_mtl_header_id;
502: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.write_mtl_errors',
503: p_params => l_params,
504: x_returnStatus => l_returnStatus);
505: END IF;
506: l_count := 0;

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

531: END IF;
532:
533: l_returnStatus := fnd_api.g_ret_sts_success;
534: IF (l_logLevel <= wip_constants.trace_logging) THEN
535: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.write_mtl_errors',
536: p_procReturnStatus => l_returnStatus,
537: p_msg => 'procedure complete',
538: x_returnStatus => l_returnStatus);
539: END IF;

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

542: l_returnStatus := fnd_api.g_ret_sts_unexp_error;
543: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
544:
545: IF (l_logLevel <= wip_constants.trace_logging) THEN
546: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.write_mtl_errors',
547: p_procReturnStatus => l_returnStatus,
548: p_msg => l_errMsg,
549: x_returnStatus => l_returnStatus);
550: END IF;

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

601: l_params(1).paramName := 'p_group_id';
602: l_params(1).paramValue := p_gib.group_id;
603: l_params(2).paramName := 'p_txn_date';
604: l_params(2).paramValue := p_gib.txn_date;
605: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.lock_wipops',
606: p_params => l_params,
607: x_returnStatus => l_returnStatus);
608: END IF;
609:

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

616: x_returnStatus := fnd_api.g_ret_sts_success;
617:
618: -- write to the log file
619: IF (l_logLevel <= wip_constants.trace_logging) THEN
620: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.lock_wipops',
621: p_procReturnStatus => x_returnStatus,
622: p_msg => 'procedure complete',
623: x_returnStatus => l_returnStatus);
624: END IF;

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

631: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
632: l_errMsg := 'Unable to lock the record in wip_operations';
633:
634: IF (l_logLevel <= wip_constants.trace_logging) THEN
635: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.lock_wipops',
636: p_procReturnStatus => x_returnStatus,
637: p_msg => l_errMsg,
638: x_returnStatus => l_returnStatus);
639: END IF;

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

647: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
648: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
649:
650: IF (l_logLevel <= wip_constants.trace_logging) THEN
651: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.lock_wipops',
652: p_procReturnStatus => x_returnStatus,
653: p_msg => l_errMsg,
654: x_returnStatus => l_returnStatus);
655: END IF;

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

773: l_params(11).paramName := 'p_fm_form';
774: l_params(11).paramValue := p_fm_form;
775: l_params(12).paramName := 'p_comp_alloc';
776: l_params(12).paramValue := p_comp_alloc;
777: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.schedule_alloc',
778: p_params => l_params,
779: x_returnStatus => l_returnStatus);
780: END IF;
781:

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

905: x_returnStatus := fnd_api.g_ret_sts_success;
906: x_proc_status := WIP_CONSTANTS.RUNNING;
907: -- write to the log file
908: IF (l_logLevel <= wip_constants.trace_logging) THEN
909: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.schedule_alloc',
910: p_procReturnStatus => x_returnStatus,
911: p_msg => 'procedure complete',
912: x_returnStatus => l_returnStatus);
913: END IF;

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

919: END IF;
920: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
921:
922: IF (l_logLevel <= wip_constants.trace_logging) THEN
923: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.schedule_alloc',
924: p_procReturnStatus => x_returnStatus,
925: p_msg => l_errMsg,
926: x_returnStatus => l_returnStatus);
927: END IF;

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

927: END IF;
928:
929: /* Fix for bug 5373061: Passed missing token */
930: fnd_message.set_name('WIP','WIP_INT_ERROR_NO_SCHED');
931: fnd_message.set_token('ROUTINE', 'wip_movProc_priv.schedule_alloc');
932: fnd_msg_pub.add;
933:
934: WHEN others THEN
935: IF(c_rsa%ISOPEN) THEN

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

939: x_proc_status := WIP_CONSTANTS.ERROR;
940: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
941:
942: IF (l_logLevel <= wip_constants.trace_logging) THEN
943: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.schedule_alloc',
944: p_procReturnStatus => x_returnStatus,
945: p_msg => l_errMsg,
946: x_returnStatus => l_returnStatus);
947: END IF;

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

986: l_params(4).paramName := 'p_parent_txn_id';
987: l_params(4).paramValue := p_parent_txn_id;
988: l_params(5).paramName := 'child_txn_id';
989: l_params(5).paramValue := p_gib.move_profile.child_txn_id;
990: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.insert_alloc_child',
991: p_params => l_params,
992: x_returnStatus => l_returnStatus);
993: END IF;
994:

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

1069: x_returnStatus := fnd_api.g_ret_sts_success;
1070:
1071: -- write to the log file
1072: IF (l_logLevel <= wip_constants.trace_logging) THEN
1073: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_alloc_child',
1074: p_procReturnStatus => x_returnStatus,
1075: p_msg => 'procedure complete',
1076: x_returnStatus => l_returnStatus);
1077: END IF;

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

1081:
1082: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1083:
1084: IF (l_logLevel <= wip_constants.trace_logging) THEN
1085: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_alloc_child',
1086: p_procReturnStatus => x_returnStatus,
1087: p_msg => l_errMsg,
1088: x_returnStatus => l_returnStatus);
1089: END IF;

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

1096: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1097: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1098:
1099: IF (l_logLevel <= wip_constants.trace_logging) THEN
1100: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_alloc_child',
1101: p_procReturnStatus => x_returnStatus,
1102: p_msg => l_errMsg,
1103: x_returnStatus => l_returnStatus);
1104: END IF;

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

1144: l_params(9).paramName := 'p_to_step';
1145: l_params(9).paramValue := p_rsa_rec(i).toStep;
1146: l_params(10).paramName := 'p_txn_date';
1147: l_params(10).paramValue := p_txn_date;
1148: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.update_wo_rs',
1149: p_params => l_params,
1150: x_returnStatus => l_returnStatus);
1151: END IF;
1152:

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

1286: x_returnStatus := fnd_api.g_ret_sts_success;
1287:
1288: -- write to the log file
1289: IF (l_logLevel <= wip_constants.trace_logging) THEN
1290: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.update_wo_rs',
1291: p_procReturnStatus => x_returnStatus,
1292: p_msg => 'procedure complete',
1293: x_returnStatus => l_returnStatus);
1294: END IF;

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

1298: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1299: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1300:
1301: IF (l_logLevel <= wip_constants.trace_logging) THEN
1302: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.update_wo_rs',
1303: p_procReturnStatus => x_returnStatus,
1304: p_msg => l_errMsg,
1305: x_returnStatus => l_returnStatus);
1306: END IF;

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

1332: l_params(2).paramName := 'p_group_id';
1333: l_params(2).paramValue := p_gib.group_id;
1334: l_params(3).paramName := 'p_txn_date';
1335: l_params(3).paramValue := p_gib.txn_date;
1336: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.update_wipops',
1337: p_params => l_params,
1338: x_returnStatus => l_returnStatus);
1339: END IF;
1340:

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

1398: x_returnStatus := fnd_api.g_ret_sts_success;
1399:
1400: -- write to the log file
1401: IF (l_logLevel <= wip_constants.trace_logging) THEN
1402: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.update_wipops',
1403: p_procReturnStatus => x_returnStatus,
1404: p_msg => 'procedure complete',
1405: x_returnStatus => l_returnStatus);
1406: END IF;

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

1410: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1411: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1412:
1413: IF (l_logLevel <= wip_constants.trace_logging) THEN
1414: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.update_wipops',
1415: p_procReturnStatus => x_returnStatus,
1416: p_msg => l_errMsg,
1417: x_returnStatus => l_returnStatus);
1418: END IF;

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

1502: l_params(8).paramName := 'p_move_mode';
1503: l_params(8).paramValue := p_gib.move_mode;
1504: l_params(9).paramName := 'p_backflush_mode';
1505: l_params(9).paramValue := p_gib.bf_mode;
1506: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.rep_move_alloc',
1507: p_params => l_params,
1508: x_returnStatus => l_returnStatus);
1509: END IF;
1510:

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

1588: p_gib => p_gib,
1589: x_returnStatus => x_returnStatus);
1590:
1591: IF (x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1592: l_errMsg := 'wip_movProc_priv.update_wipops failed';
1593: raise fnd_api.g_exc_unexpected_error;
1594: END IF;
1595:
1596: END IF; -- child txns

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

1616: WHERE transaction_id = l_rs_txn.txn_id
1617: AND group_id = p_gib.group_id;
1618: END IF; -- time out check
1619:
1620: l_errMsg := 'wip_movProc_priv.insert_alloc_child failed';
1621: raise fnd_api.g_exc_unexpected_error;
1622:
1623: ELSE -- insert child success
1624: -- insert assemblies in the queue of the first operation after

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

1627: p_gib => p_gib,
1628: x_returnStatus => x_returnStatus);
1629:
1630: IF (x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1631: l_errMsg := 'wip_movProc_priv.update_wipops failed';
1632: raise fnd_api.g_exc_unexpected_error;
1633: END IF;
1634:
1635: -- prepare data before calling update_wo_rs

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

1653: p_txn_date => l_rs_txn.txn_date,
1654: x_returnStatus => x_returnStatus);
1655:
1656: IF (x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1657: l_errMsg := 'wip_movProc_priv.update_wo_rs failed';
1658: raise fnd_api.g_exc_unexpected_error;
1659: END IF;
1660: END IF; -- insert_alloc_child check
1661:

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

1711: p_txn_date => l_rs_txn.txn_date,
1712: x_returnStatus => x_returnStatus);
1713:
1714: IF (x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1715: l_errMsg := 'wip_movProc_priv.update_wo_rs failed';
1716: raise fnd_api.g_exc_unexpected_error;
1717: END IF;
1718:
1719: ELSIF(l_proc_status = TVE_OVERCOMPLETION_MISMATCH OR

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

1751: SET process_status = WIP_CONSTANTS.ERROR
1752: WHERE transaction_id = l_rs_txn.txn_id
1753: AND group_id = p_gib.group_id;
1754:
1755: l_errMsg := 'wip_movProc_priv.schedule_alloc failed';
1756: raise fnd_api.g_exc_unexpected_error;
1757:
1758: END IF; -- process_status
1759:

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

1836: x_returnStatus := fnd_api.g_ret_sts_success;
1837:
1838: -- write to the log file
1839: IF (l_logLevel <= wip_constants.trace_logging) THEN
1840: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.rep_move_alloc',
1841: p_procReturnStatus => x_returnStatus,
1842: p_msg => 'procedure complete',
1843: x_returnStatus => l_returnStatus);
1844: END IF;

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

1853: END IF;
1854: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1855:
1856: IF (l_logLevel <= wip_constants.trace_logging) THEN
1857: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.rep_move_alloc',
1858: p_procReturnStatus => x_returnStatus,
1859: p_msg => l_errMsg,
1860: x_returnStatus => l_returnStatus);
1861: END IF;

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

1866: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1867: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1868:
1869: IF (l_logLevel <= wip_constants.trace_logging) THEN
1870: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.rep_move_alloc',
1871: p_procReturnStatus => x_returnStatus,
1872: p_msg => l_errMsg,
1873: x_returnStatus => l_returnStatus);
1874: END IF;

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

1917: l_params(7).paramName := 'p_org_id';
1918: l_params(7).paramValue := p_org_id;
1919: l_params(8).paramName := 'p_wip_id';
1920: l_params(8).paramValue := p_wip_id;
1921: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.update_wo_dj',
1922: p_params => l_params,
1923: x_returnStatus => l_returnStatus);
1924: END IF;
1925:

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

2064: x_returnStatus := fnd_api.g_ret_sts_success;
2065:
2066: -- write to the log file
2067: IF (l_logLevel <= wip_constants.trace_logging) THEN
2068: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.update_wo_dj',
2069: p_procReturnStatus => x_returnStatus,
2070: p_msg => 'procedure complete',
2071: x_returnStatus => l_returnStatus);
2072: END IF;

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

2076: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2077: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
2078:
2079: IF (l_logLevel <= wip_constants.trace_logging) THEN
2080: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.update_wo_dj',
2081: p_procReturnStatus => x_returnStatus,
2082: p_msg => l_errMsg,
2083: x_returnStatus => l_returnStatus);
2084: END IF;

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

2192: l_params(3).paramName := 'p_txn_date';
2193: l_params(3).paramValue := p_gib.txn_date;
2194: l_params(4).paramName := 'p_move_mode';
2195: l_params(4).paramValue := p_gib.move_mode;
2196: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.check_qty_dj',
2197: p_params => l_params,
2198: x_returnStatus => l_returnStatus);
2199: END IF;
2200:

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

2285: p_gib => p_gib,
2286: x_returnStatus => x_returnStatus);
2287:
2288: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
2289: l_errMsg := 'wip_movProc_priv.update_wipops failed';
2290: raise fnd_api.g_exc_unexpected_error;
2291: END IF; -- check return status
2292:
2293: ELSE -- IF it is parent or normal txn, validate qty

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

2354: WHERE transaction_id = l_dj_txn.txn_id
2355: AND group_id = p_gib.group_id;
2356: END IF; -- time out check
2357:
2358: l_errMsg := 'wip_movProc_priv.insert_alloc_child failed';
2359: raise fnd_api.g_exc_unexpected_error;
2360:
2361: ELSE -- insert child success
2362: -- insert assemblies in the queue of the first operation after

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

2365: p_gib => p_gib,
2366: x_returnStatus => x_returnStatus);
2367:
2368: IF (x_returnStatus <> fnd_api.g_ret_sts_success) THEN
2369: l_errMsg := 'wip_movProc_priv.update_wipops failed';
2370: raise fnd_api.g_exc_unexpected_error;
2371: END IF;
2372:
2373: -- update wip_operations for child move txns

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

2382: p_txn_date => l_dj_txn.txn_date,
2383: x_returnStatus => x_returnStatus);
2384:
2385: IF (x_returnStatus <> fnd_api.g_ret_sts_success) THEN
2386: l_errMsg := 'wip_movProc_priv.update_wo_dj failed';
2387: raise fnd_api.g_exc_unexpected_error;
2388: END IF;
2389: END IF; -- insert_alloc_child check
2390:

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

2429: p_txn_date => l_dj_txn.txn_date,
2430: x_returnStatus => x_returnStatus);
2431:
2432: IF (x_returnStatus <> fnd_api.g_ret_sts_success) THEN
2433: l_errMsg := 'wip_movProc_priv.update_wo_dj failed';
2434: raise fnd_api.g_exc_unexpected_error;
2435: END IF;
2436:
2437: END IF; -- check enough qty

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

2509: x_returnStatus := fnd_api.g_ret_sts_success;
2510:
2511: -- write to the log file
2512: IF (l_logLevel <= wip_constants.trace_logging) THEN
2513: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.check_qty_dj',
2514: p_procReturnStatus => x_returnStatus,
2515: p_msg => 'procedure complete',
2516: x_returnStatus => l_returnStatus);
2517: END IF;

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

2524: END IF;
2525: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2526:
2527: IF (l_logLevel <= wip_constants.trace_logging) THEN
2528: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.check_qty_dj',
2529: p_procReturnStatus => x_returnStatus,
2530: p_msg => l_errMsg,
2531: x_returnStatus => l_returnStatus);
2532: END IF;

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

2538: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2539: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
2540:
2541: IF (l_logLevel <= wip_constants.trace_logging) THEN
2542: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.check_qty_dj',
2543: p_procReturnStatus => x_returnStatus,
2544: p_msg => l_errMsg,
2545: x_returnStatus => l_returnStatus);
2546: END IF;

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

2609: l_params(17).paramName := 'poReqItem';
2610: l_params(17).paramValue := l_move.poReqItem;
2611: l_params(18).paramName := 'poRegLot';
2612: l_params(18).paramValue := l_move.poReqLot;
2613: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.get_move_profile',
2614: p_params => l_params,
2615: x_returnStatus => l_returnStatus);
2616: END IF;
2617:

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

2733: x_returnStatus := fnd_api.g_ret_sts_success;
2734:
2735: -- write to the log file
2736: IF (l_logLevel <= wip_constants.trace_logging) THEN
2737: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.get_move_profile',
2738: p_procReturnStatus => x_returnStatus,
2739: p_msg => 'procedure complete',
2740: x_returnStatus => l_returnStatus);
2741: END IF;

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

2745: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2746: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
2747:
2748: IF (l_logLevel <= wip_constants.trace_logging) THEN
2749: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.get_move_profile',
2750: p_procReturnStatus => x_returnStatus,
2751: p_msg => l_errMsg,
2752: x_returnStatus => l_returnStatus);
2753: END IF;

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

2776: l_params(1).paramName := 'p_group_id';
2777: l_params(1).paramValue := p_gib.group_id;
2778: l_params(2).paramName := 'p_txn_date';
2779: l_params(2).paramValue := p_gib.txn_date;
2780: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.insert_txn_history',
2781: p_params => l_params,
2782: x_returnStatus => l_returnStatus);
2783: END IF;
2784:

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

3109: x_returnStatus := fnd_api.g_ret_sts_success;
3110:
3111: -- write to the log file
3112: IF (l_logLevel <= wip_constants.trace_logging) THEN
3113: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_txn_history',
3114: p_procReturnStatus => x_returnStatus,
3115: p_msg => 'procedure complete',
3116: x_returnStatus => l_returnStatus);
3117: END IF;

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

3121: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
3122: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
3123:
3124: IF (l_logLevel <= wip_constants.trace_logging) THEN
3125: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_txn_history',
3126: p_procReturnStatus => x_returnStatus,
3127: p_msg => l_errMsg,
3128: x_returnStatus => l_returnStatus);
3129: END IF;

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

3153: l_params(1).paramName := 'p_group_id';
3154: l_params(1).paramValue := p_gib.group_id;
3155: l_params(2).paramName := 'p_txn_date';
3156: l_params(2).paramValue := p_gib.txn_date;
3157: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.delete_child_txn',
3158: p_params => l_params,
3159: x_returnStatus => l_returnStatus);
3160: END IF;
3161:

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

3175: x_returnStatus := fnd_api.g_ret_sts_success;
3176:
3177: -- write to the log file
3178: IF (l_logLevel <= wip_constants.trace_logging) THEN
3179: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.delete_child_txn',
3180: p_procReturnStatus => x_returnStatus,
3181: p_msg => 'procedure complete',
3182: x_returnStatus => l_returnStatus);
3183: END IF;

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

3186: WHEN others THEN
3187: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
3188: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
3189: IF (l_logLevel <= wip_constants.trace_logging) THEN
3190: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.delete_child_txn',
3191: p_procReturnStatus => x_returnStatus,
3192: p_msg => l_errMsg,
3193: x_returnStatus => l_returnStatus);
3194: END IF;

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

3251: l_params(16).paramName := 'poReqItem';
3252: l_params(16).paramValue := l_move.poReqItem;
3253: l_params(17).paramName := 'poRegLot';
3254: l_params(17).paramValue := l_move.poReqLot;
3255: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.insert_auto_resource',
3256: p_params => l_params,
3257: x_returnStatus => l_returnStatus);
3258: END IF;
3259:

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

4327: x_returnStatus := fnd_api.g_ret_sts_success;
4328:
4329: -- write to the log file
4330: IF (l_logLevel <= wip_constants.trace_logging) THEN
4331: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_auto_resource',
4332: p_procReturnStatus => x_returnStatus,
4333: p_msg => 'procedure complete',
4334: x_returnStatus => l_returnStatus);
4335: END IF;

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

4339: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
4340: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
4341:
4342: IF (l_logLevel <= wip_constants.trace_logging) THEN
4343: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.insert_auto_resource',
4344: p_procReturnStatus => x_returnStatus,
4345: p_msg => l_errMsg,
4346: x_returnStatus => l_returnStatus);
4347: END IF;

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

4371: -- write parameter value to log file
4372: IF (l_logLevel <= wip_constants.trace_logging) THEN
4373: l_params(1).paramName := 'p_group_id';
4374: l_params(1).paramValue := p_gib.group_id;
4375: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.insert_txn_alloc',
4376: p_params => l_params,
4377: x_returnStatus => l_returnStatus);
4378: END IF;
4379:

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

4467: x_returnStatus := fnd_api.g_ret_sts_success;
4468:
4469: -- write to the log file
4470: IF (l_logLevel <= wip_constants.trace_logging) THEN
4471: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_txn_alloc',
4472: p_procReturnStatus => x_returnStatus,
4473: p_msg => 'procedure complete',
4474: x_returnStatus => l_returnStatus);
4475: END IF;

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

4479: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
4480: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
4481:
4482: IF (l_logLevel <= wip_constants.trace_logging) THEN
4483: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.insert_txn_alloc',
4484: p_procReturnStatus => x_returnStatus,
4485: p_msg => l_errMsg,
4486: x_returnStatus => l_returnStatus);
4487: END IF;

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

4543: l_params(16).paramName := 'poReqItem';
4544: l_params(16).paramValue := l_move.poReqItem;
4545: l_params(17).paramName := 'poRegLot';
4546: l_params(17).paramValue := l_move.poReqLot;
4547: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.insert_dept_overhead',
4548: p_params => l_params,
4549: x_returnStatus => l_returnStatus);
4550: END IF;
4551:

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

5598: x_returnStatus := fnd_api.g_ret_sts_success;
5599:
5600: -- write to the log file
5601: IF (l_logLevel <= wip_constants.trace_logging) THEN
5602: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_dept_overhead',
5603: p_procReturnStatus => x_returnStatus,
5604: p_msg => 'procedure complete',
5605: x_returnStatus => l_returnStatus);
5606: END IF;

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

5610: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
5611: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
5612:
5613: IF (l_logLevel <= wip_constants.trace_logging) THEN
5614: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.insert_dept_overhead',
5615: p_procReturnStatus => x_returnStatus,
5616: p_msg => l_errMsg,
5617: x_returnStatus => l_returnStatus);
5618: END IF;

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

5641: l_params(1).paramName := 'p_group_id';
5642: l_params(1).paramValue := p_gib.group_id;
5643: l_params(2).paramName := 'p_txn_date';
5644: l_params(2).paramValue := p_gib.txn_date;
5645: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.release_cost_txn',
5646: p_params => l_params,
5647: x_returnStatus => l_returnStatus);
5648: END IF;
5649:

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

5665: x_returnStatus := fnd_api.g_ret_sts_success;
5666:
5667: -- write to the log file
5668: IF (l_logLevel <= wip_constants.trace_logging) THEN
5669: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.release_cost_txn',
5670: p_procReturnStatus => x_returnStatus,
5671: p_msg => 'procedure complete',
5672: x_returnStatus => l_returnStatus);
5673: END IF;

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

5677: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
5678: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
5679:
5680: IF (l_logLevel <= wip_constants.trace_logging) THEN
5681: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.release_cost_txn',
5682: p_procReturnStatus => x_returnStatus,
5683: p_msg => l_errMsg,
5684: x_returnStatus => l_returnStatus);
5685: END IF;

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

5807: l_params(16).paramValue := l_move.poReqItem;
5808: l_params(17).paramName := 'poRegLot';
5809: l_params(17).paramValue := l_move.poReqLot;
5810:
5811: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.insert_po_req',
5812: p_params => l_params,
5813: x_returnStatus => l_returnStatus);
5814: END IF;
5815:

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

6704: x_returnStatus := fnd_api.g_ret_sts_success;
6705:
6706: -- write to the log file
6707: IF (l_logLevel <= wip_constants.trace_logging) THEN
6708: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.insert_po_req',
6709: p_procReturnStatus => x_returnStatus,
6710: p_msg => 'procedure complete',
6711: x_returnStatus => l_returnStatus);
6712: END IF;

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

6719: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
6720: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
6721:
6722: IF (l_logLevel <= wip_constants.trace_logging) THEN
6723: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.insert_po_req',
6724: p_procReturnStatus => x_returnStatus,
6725: p_msg => l_errMsg,
6726: x_returnStatus => l_returnStatus);
6727: END IF;

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

6813: l_params(1).paramName := 'p_group_id';
6814: l_params(1).paramValue := p_gib.group_id;
6815: l_params(2).paramName := 'p_txn_date';
6816: l_params(2).paramValue := p_gib.txn_date;
6817: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.start_workflow',
6818: p_params => l_params,
6819: x_returnStatus => l_returnStatus);
6820: END IF;
6821: OPEN c_wmti_txn(p_group_id => p_gib.group_id,

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

6899: END IF;
6900: x_returnStatus := fnd_api.g_ret_sts_success;
6901: -- write to the log file
6902: IF (l_logLevel <= wip_constants.trace_logging) THEN
6903: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.start_workflow',
6904: p_procReturnStatus => x_returnStatus,
6905: p_msg => 'procedure complete',
6906: x_returnStatus => l_returnStatus);
6907: END IF;

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

6915: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
6916: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
6917:
6918: IF (l_logLevel <= wip_constants.trace_logging) THEN
6919: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.start_workflow',
6920: p_procReturnStatus => x_returnStatus,
6921: p_msg => l_errMsg,
6922: x_returnStatus => l_returnStatus);
6923: END IF;

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

6949: l_params(2).paramName := 'p_txn_date';
6950: l_params(2).paramValue := p_gib.txn_date;
6951: l_params(3).paramName := 'p_txn_id';
6952: l_params(3).paramValue := p_txn_id;
6953: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.update_complete_qty',
6954: p_params => l_params,
6955: x_returnStatus => l_returnStatus);
6956: END IF;
6957:

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

7113: x_returnStatus := fnd_api.g_ret_sts_success;
7114:
7115: -- write to the log file
7116: IF (l_logLevel <= wip_constants.trace_logging) THEN
7117: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.update_complete_qty',
7118: p_procReturnStatus => x_returnStatus,
7119: p_msg => 'procedure complete',
7120: x_returnStatus => l_returnStatus);
7121: END IF;

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

7125: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
7126: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
7127:
7128: IF (l_logLevel <= wip_constants.trace_logging) THEN
7129: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.update_complete_qty',
7130: p_procReturnStatus => x_returnStatus,
7131: p_msg => l_errMsg,
7132: x_returnStatus => l_returnStatus);
7133: END IF;

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

7155: -- write parameter value to log file
7156: IF (l_logLevel <= wip_constants.trace_logging) THEN
7157: l_params(1).paramName := 'p_mtl_temp_id';
7158: l_params(1).paramValue := p_mtl_temp_id;
7159: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.op_snapshot',
7160: p_params => l_params,
7161: x_returnStatus => l_returnStatus);
7162: END IF;
7163:

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

7174: x_returnStatus := fnd_api.g_ret_sts_success;
7175:
7176: -- write to the log file
7177: IF (l_logLevel <= wip_constants.trace_logging) THEN
7178: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.op_snapshot',
7179: p_procReturnStatus => x_returnStatus,
7180: p_msg => 'procedure complete',
7181: x_returnStatus => l_returnStatus);
7182: END IF;

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

7185: WHEN fnd_api.g_exc_unexpected_error THEN
7186: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
7187:
7188: IF (l_logLevel <= wip_constants.trace_logging) THEN
7189: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.op_snapshot',
7190: p_procReturnStatus => x_returnStatus,
7191: p_msg => l_errMsg,
7192: x_returnStatus => l_returnStatus);
7193: END IF;

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

7199: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
7200: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
7201:
7202: IF (l_logLevel <= wip_constants.trace_logging) THEN
7203: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.op_snapshot',
7204: p_procReturnStatus => x_returnStatus,
7205: p_msg => l_errMsg,
7206: x_returnStatus => l_returnStatus);
7207: END IF;

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

7251: l_params(4).paramName := 'p_txn_type_id';
7252: l_params(4).paramValue := p_txn_type_id;
7253: l_params(5).paramName := 'p_txn_action_id';
7254: l_params(5).paramValue := p_txn_action_id;
7255: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.snapshot_online',
7256: p_params => l_params,
7257: x_returnStatus => l_returnStatus);
7258: END IF;
7259:

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

7295: op_snapshot(p_mtl_temp_id => l_mmtt.mtl_temp_id,
7296: x_returnStatus => x_returnStatus);
7297:
7298: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
7299: l_errMsg := 'wip_movProc_priv.op_snapshot failed';
7300: raise fnd_api.g_exc_unexpected_error;
7301: END IF; -- check return status
7302: END LOOP; -- END for loop
7303: END IF;

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

7305: x_returnStatus := fnd_api.g_ret_sts_success;
7306:
7307: -- write to the log file
7308: IF (l_logLevel <= wip_constants.trace_logging) THEN
7309: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.snapshot_online',
7310: p_procReturnStatus => x_returnStatus,
7311: p_msg => 'procedure complete',
7312: x_returnStatus => l_returnStatus);
7313: END IF;

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

7316: WHEN fnd_api.g_exc_unexpected_error THEN
7317: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
7318:
7319: IF (l_logLevel <= wip_constants.trace_logging) THEN
7320: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.snapshot_online',
7321: p_procReturnStatus => x_returnStatus,
7322: p_msg => l_errMsg,
7323: x_returnStatus => l_returnStatus);
7324: END IF;

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

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

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

7424: l_params(2).paramName := 'p_txn_date';
7425: l_params(2).paramValue := p_txn_date;
7426: l_params(3).paramName := 'p_txn_id';
7427: l_params(3).paramValue := p_txn_id;
7428: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.snapshot_background',
7429: p_params => l_params,
7430: x_returnStatus => l_returnStatus);
7431: END IF;
7432:

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

7510: op_snapshot(p_mtl_temp_id => l_txns.mtl_temp_id,
7511: x_returnStatus => x_returnStatus);
7512:
7513: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
7514: l_errMsg := 'wip_movProc_priv.op_snapshot failed';
7515: raise fnd_api.g_exc_unexpected_error;
7516: END IF; -- check return status
7517: END IF; -- check load from interface and source code
7518: END LOOP;

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

7521: x_returnStatus := fnd_api.g_ret_sts_success;
7522:
7523: -- write to the log file
7524: IF (l_logLevel <= wip_constants.trace_logging) THEN
7525: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.snapshot_background',
7526: p_procReturnStatus => x_returnStatus,
7527: p_msg => 'procedure complete',
7528: x_returnStatus => l_returnStatus);
7529: END IF;

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

7532: WHEN fnd_api.g_exc_unexpected_error THEN
7533: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
7534:
7535: IF (l_logLevel <= wip_constants.trace_logging) THEN
7536: wip_logger.exitPoint(p_procName =>'wip_movProc_priv.snapshot_background',
7537: p_procReturnStatus => x_returnStatus,
7538: p_msg => l_errMsg,
7539: x_returnStatus => l_returnStatus);
7540: END IF;

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

7543: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
7544: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
7545:
7546: IF (l_logLevel <= wip_constants.trace_logging) THEN
7547: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.snapshot_background',
7548: p_procReturnStatus => x_returnStatus,
7549: p_msg => l_errMsg,
7550: x_returnStatus => l_returnStatus);
7551: END IF;

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

7581: l_params(2).paramName := 'p_gib.txn_date';
7582: l_params(2).paramValue := p_gib.txn_date;
7583: l_params(3).paramName := 'p_gib.seq_move';
7584: l_params(3).paramValue := p_gib.seq_move;
7585: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.update_wo_and_snapshot',
7586: p_params => l_params,
7587: x_returnStatus => l_returnStatus);
7588: END IF;
7589:

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

7594: p_txn_id => l_move_rec.txn_id,
7595: x_returnStatus => x_returnStatus);
7596:
7597: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
7598: l_errMsg := 'wip_movProc_priv.update_complete_qty failed';
7599: raise fnd_api.g_exc_unexpected_error;
7600: END IF; -- check return status
7601:
7602: snapshot_background(p_group_id => p_gib.group_id,

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

7604: p_txn_date => p_gib.txn_date,
7605: x_returnStatus => x_returnStatus);
7606:
7607: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
7608: l_errMsg := 'wip_movProc_priv.snapshot_background failed';
7609: raise fnd_api.g_exc_unexpected_error;
7610: END IF; -- check return status
7611: END LOOP;
7612: ELSE

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

7614: update_complete_qty(p_gib => p_gib,
7615: x_returnStatus => x_returnStatus);
7616:
7617: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
7618: l_errMsg := 'wip_movProc_priv.update_complete_qty failed';
7619: raise fnd_api.g_exc_unexpected_error;
7620: END IF; -- check return status
7621:
7622: snapshot_background(p_group_id => p_gib.group_id,

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

7623: p_txn_date => p_gib.txn_date,
7624: x_returnStatus => x_returnStatus);
7625:
7626: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
7627: l_errMsg := 'wip_movProc_priv.snapshot_background failed';
7628: raise fnd_api.g_exc_unexpected_error;
7629: END IF; -- check return status
7630: END IF;
7631:

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

7631:
7632: x_returnStatus := fnd_api.g_ret_sts_success;
7633: -- write to the log file
7634: IF (l_logLevel <= wip_constants.trace_logging) THEN
7635: wip_logger.exitPoint(p_procName =>'wip_movProc_priv.update_wo_and_snapshot',
7636: p_procReturnStatus => x_returnStatus,
7637: p_msg => 'procedure complete',
7638: x_returnStatus => l_returnStatus);
7639: END IF;

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

7640: EXCEPTION
7641: WHEN fnd_api.g_exc_unexpected_error THEN
7642: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
7643: IF (l_logLevel <= wip_constants.trace_logging) THEN
7644: wip_logger.exitPoint(p_procName =>'wip_movProc_priv.update_wo_and_snapshot',
7645: p_procReturnStatus => x_returnStatus,
7646: p_msg => l_errMsg,
7647: x_returnStatus => l_returnStatus);
7648: END IF;

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

7651: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
7652: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
7653:
7654: IF (l_logLevel <= wip_constants.trace_logging) THEN
7655: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.update_wo_and_snapshot',
7656: p_procReturnStatus => x_returnStatus,
7657: p_msg => l_errMsg,
7658: x_returnStatus => l_returnStatus);
7659: END IF;

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

7782: l_params(19).paramName := 'p_move_mode';
7783: l_params(19).paramValue := p_gib.move_mode;
7784: l_params(20).paramName := 'p_mtl_mode';
7785: l_params(20).paramValue := p_gib.mtl_mode;
7786: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.scrap_txns',
7787: p_params => l_params,
7788: x_returnStatus => l_returnStatus);
7789: END IF;
7790:

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

8307: p_txn_action_id => WIP_CONSTANTS.SCRASSY_ACTION,
8308: x_returnStatus => x_returnStatus);
8309:
8310: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
8311: l_errMsg := 'wip_movProc_priv.snapshot_online failed';
8312: raise fnd_api.g_exc_unexpected_error;
8313: END IF; -- check return status
8314: END IF; -- move mode check
8315: END IF; -- IF job txns

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

8342: x_returnStatus := fnd_api.g_ret_sts_success;
8343:
8344: -- write to the log file
8345: IF (l_logLevel <= wip_constants.trace_logging) THEN
8346: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.scrap_txns',
8347: p_procReturnStatus => x_returnStatus,
8348: p_msg => 'procedure complete',
8349: x_returnStatus => l_returnStatus);
8350: END IF;

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

8352: EXCEPTION
8353: WHEN fnd_api.g_exc_unexpected_error THEN
8354: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
8355: IF (l_logLevel <= wip_constants.trace_logging) THEN
8356: wip_logger.exitPoint(p_procName =>'wip_movProc_priv.scrap_txns',
8357: p_procReturnStatus => x_returnStatus,
8358: p_msg => l_errMsg,
8359: x_returnStatus => l_returnStatus);
8360: END IF;

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

8363: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
8364: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
8365:
8366: IF (l_logLevel <= wip_constants.trace_logging) THEN
8367: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.scrap_txns',
8368: p_procReturnStatus => x_returnStatus,
8369: p_msg => l_errMsg,
8370: x_returnStatus => l_returnStatus);
8371: END IF;

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

8466: l_params(21).paramValue := p_txn_type;
8467: l_params(22).paramName := 'p_assy_header_id';
8468: l_params(22).paramValue := p_gib.assy_header_id;
8469:
8470: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.ez_completion',
8471: p_params => l_params,
8472: x_returnStatus => l_returnStatus);
8473: END IF;
8474:

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

9123: p_txn_action_id => l_txn_action_id,
9124: x_returnStatus => x_returnStatus);
9125:
9126: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9127: l_errMsg := 'wip_movProc_priv.snapshot_online failed';
9128: raise fnd_api.g_exc_unexpected_error;
9129: END IF; -- check return status
9130: ELSE -- move is background
9131: IF(p_txn_type = WIP_CONSTANTS.RET_TXN) THEN

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

9133: p_txn_date => p_gib.txn_date,
9134: x_returnStatus => x_returnStatus);
9135:
9136: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9137: l_errMsg := 'wip_movProc_priv.snapshot_background failed';
9138: raise fnd_api.g_exc_unexpected_error;
9139: END IF; -- check return status
9140: END IF; -- return transaction
9141: END IF; -- move mode check

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

9143: x_returnStatus := fnd_api.g_ret_sts_success;
9144:
9145: -- write to the log file
9146: IF (l_logLevel <= wip_constants.trace_logging) THEN
9147: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.ez_completion',
9148: p_procReturnStatus => x_returnStatus,
9149: p_msg => 'procedure complete',
9150: x_returnStatus => l_returnStatus);
9151: END IF;

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

9153: EXCEPTION
9154: WHEN fnd_api.g_exc_unexpected_error THEN
9155: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
9156: IF (l_logLevel <= wip_constants.trace_logging) THEN
9157: wip_logger.exitPoint(p_procName =>'wip_movProc_priv.ez_completion',
9158: p_procReturnStatus => x_returnStatus,
9159: p_msg => l_errMsg,
9160: x_returnStatus => l_returnStatus);
9161: END IF;

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

9164: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
9165: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
9166:
9167: IF (l_logLevel <= wip_constants.trace_logging) THEN
9168: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.ez_completion',
9169: p_procReturnStatus => x_returnStatus,
9170: p_msg => l_errMsg,
9171: x_returnStatus => l_returnStatus);
9172: END IF;

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

9194: l_params(1).paramName := 'p_group_id';
9195: l_params(1).paramValue := p_gib.group_id;
9196: l_params(2).paramName := 'p_txn_date';
9197: l_params(2).paramValue := p_gib.txn_date;
9198: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.update_wro',
9199: p_params => l_params,
9200: x_returnStatus => l_returnStatus);
9201: END IF;
9202:

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

9263: x_returnStatus := fnd_api.g_ret_sts_success;
9264:
9265: -- write to the log file
9266: IF (l_logLevel <= wip_constants.trace_logging) THEN
9267: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.update_wro',
9268: p_procReturnStatus => x_returnStatus,
9269: p_msg => 'procedure complete',
9270: x_returnStatus => l_returnStatus);
9271: END IF;

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

9275: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
9276: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
9277:
9278: IF (l_logLevel <= wip_constants.trace_logging) THEN
9279: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.update_wro',
9280: p_procReturnStatus => x_returnStatus,
9281: p_msg => l_errMsg,
9282: x_returnStatus => l_returnStatus);
9283: END IF;

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

9369: l_params(30).paramName := 'p_poReqItem';
9370: l_params(30).paramValue := l_move.poReqItem;
9371: l_params(31).paramName := 'p_poReqLot';
9372: l_params(31).paramValue := l_move.poReqLot;
9373: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.move_txns',
9374: p_params => l_params,
9375: x_returnStatus => l_returnStatus);
9376: END IF;
9377:

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

9379: lock_wipops(p_gib => p_gib,
9380: x_returnStatus => x_returnStatus);
9381:
9382: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9383: l_errMsg := 'wip_movProc_priv.lock_wipops failed';
9384: raise fnd_api.g_exc_unexpected_error;
9385: END IF; -- check return status
9386:
9387: -- Call repetitive allocatioin for repetitive schedule

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

9389: rep_move_alloc(p_gib => p_gib,
9390: x_returnStatus => x_returnStatus);
9391:
9392: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9393: l_errMsg := 'wip_movProc_priv.rep_move_alloc failed';
9394: raise fnd_api.g_exc_unexpected_error;
9395: END IF; -- check return status
9396: END IF; -- check repetitive schedules
9397:

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

9400: check_qty_dj(p_gib => p_gib,
9401: x_returnStatus => x_returnStatus);
9402:
9403: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9404: l_errMsg := 'wip_movProc_priv.check_qty_dj failed';
9405: raise fnd_api.g_exc_unexpected_error;
9406: END IF; -- check return status
9407: END IF; -- check discrete and OSFM jobs
9408:

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

9411: update_wro(p_gib => p_gib,
9412: x_returnStatus => x_returnStatus);
9413:
9414: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9415: l_errMsg := 'wip_movProc_priv.update_wro failed';
9416: raise fnd_api.g_exc_unexpected_error;
9417: END IF; -- check return status
9418:
9419: -- Record move transactions history in WIP_MOVE_TRANSACTIONS

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

9420: insert_txn_history(p_gib => p_gib,
9421: x_returnStatus => x_returnStatus);
9422:
9423: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9424: l_errMsg := 'wip_movProc_priv.insert_txn_history failed';
9425: raise fnd_api.g_exc_unexpected_error;
9426: END IF; -- check return status
9427:
9428: -- Delete child record (overmove/overcompletion/overreturn)

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

9430: x_returnStatus => x_returnStatus);
9431:
9432: -- Delete child record (overmove/overcompletion/overreturn)
9433: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9434: l_errMsg := 'wip_movProc_priv.delete_child_txn failed';
9435: raise fnd_api.g_exc_unexpected_error;
9436: END IF; -- check return status
9437:
9438: -- Delete child record (overmove/overcompletion/overreturn)

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

9441: insert_auto_resource(p_gib => p_gib,
9442: x_returnStatus => x_returnStatus);
9443:
9444: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9445: l_errMsg := 'wip_movProc_priv.insert_auto_resource failed';
9446: raise fnd_api.g_exc_unexpected_error;
9447: END IF; -- check return status
9448:
9449: -- Only call the cost allocation IF schedule transactions and auto resource

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

9454: insert_txn_alloc(p_gib => p_gib,
9455: x_returnStatus => x_returnStatus);
9456:
9457: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9458: l_errMsg := 'wip_movProc_priv.insert_txn_alloc failed';
9459: raise fnd_api.g_exc_unexpected_error;
9460: END IF; -- check return status
9461: END IF; -- repetitive schedule and resource per item exist
9462:

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

9464: insert_dept_overhead(p_gib => p_gib,
9465: x_returnStatus => x_returnStatus);
9466:
9467: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9468: l_errMsg := 'wip_movProc_priv.insert_dept_overhead failed';
9469: raise fnd_api.g_exc_unexpected_error;
9470: END IF; -- check return status
9471:
9472: -- Release costing transactions

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

9473: release_cost_txn(p_gib => p_gib,
9474: x_returnStatus => x_returnStatus);
9475:
9476: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9477: l_errMsg := 'wip_movProc_priv.release_cost_txn failed';
9478: raise fnd_api.g_exc_unexpected_error;
9479: END IF; -- check return status
9480:
9481: -- IF PO installed and PO, insert PO info into PO_REQUISITIONS_INTERFACE_ALL

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

9493: insert_po_req(p_gib => p_gib,
9494: x_returnStatus => x_returnStatus);
9495:
9496: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9497: l_errMsg := 'wip_movProc_priv.insert_po_req failed';
9498: raise fnd_api.g_exc_unexpected_error;
9499: END IF; -- check return status
9500: END IF;
9501: END IF;

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

9506: update_complete_qty(p_gib => p_gib,
9507: x_returnStatus => x_returnStatus);
9508:
9509: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9510: l_errMsg := 'wip_movProc_priv.update_complete_qty failed';
9511: raise fnd_api.g_exc_unexpected_error;
9512: END IF; -- check return status
9513: END IF;
9514:

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

9517: scrap_txns(p_gib => p_gib,
9518: x_returnStatus => x_returnStatus);
9519:
9520: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9521: l_errMsg := 'wip_movProc_priv.scrap_txns failed';
9522: raise fnd_api.g_exc_unexpected_error;
9523: END IF; -- check return status
9524:
9525: -- Start workflow for OSP stuff

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

9526: start_workflow(p_gib => p_gib,
9527: x_returnStatus => x_returnStatus);
9528:
9529: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9530: l_errMsg := 'wip_movProc_priv.start_workflow failed';
9531: raise fnd_api.g_exc_unexpected_error;
9532: END IF; -- check return status
9533:
9534: x_returnStatus := fnd_api.g_ret_sts_success;

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

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

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

9544: EXCEPTION
9545: WHEN fnd_api.g_exc_unexpected_error THEN
9546: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
9547: IF (l_logLevel <= wip_constants.trace_logging) THEN
9548: wip_logger.exitPoint(p_procName =>'wip_movProc_priv.move_txns',
9549: p_procReturnStatus => x_returnStatus,
9550: p_msg => l_errMsg,
9551: x_returnStatus => l_returnStatus);
9552: END IF;

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

9555: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
9556: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
9557:
9558: IF (l_logLevel <= wip_constants.trace_logging) THEN
9559: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.move_txns',
9560: p_procReturnStatus => x_returnStatus,
9561: p_msg => l_errMsg,
9562: x_returnStatus => l_returnStatus);
9563: END IF;

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

9719: l_params(12).paramValue := p_assy_header_id;
9720: l_params(13).paramName := 'p_allow_partial_commit';
9721: l_params(13).paramValue := p_allow_partial_commit;
9722:
9723: wip_logger.entryPoint(p_procName =>'wip_movProc_priv.processIntf',
9724: p_params => l_params,
9725: x_returnStatus => l_returnStatus);
9726: END IF;
9727:

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

9865: get_move_profile(p_gib => l_gib,
9866: x_returnStatus => x_returnStatus);
9867:
9868: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9869: l_errMsg := 'wip_movProc_priv.get_move_profile failed';
9870: raise fnd_api.g_exc_unexpected_error;
9871: END IF; -- check return status
9872:
9873: -- check IF easy return txns

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

9877: p_txn_type => WIP_CONSTANTS.RET_TXN,
9878: x_returnStatus => x_returnStatus);
9879:
9880: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9881: l_errMsg := 'wip_movProc_priv.ez_completion (return) failed';
9882: raise fnd_api.g_exc_unexpected_error;
9883: END IF; -- check return status
9884: ELSE /* Bug fix 5026797 (base 4901865) - Assembly completion/return transaction through Discrete Workstation are
9885: processed with p_insertAssy = fnd_api.g_false. Added the following call to snapshot

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

9891: p_txn_action_id => WIP_CONSTANTS.RETASSY_ACTION,
9892: x_returnStatus => x_returnStatus);
9893:
9894: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9895: l_errMsg := 'wip_movProc_priv.snapshot_online (return) failed';
9896: raise fnd_api.g_exc_unexpected_error;
9897: END IF; -- check return status
9898: END IF; -- p_insertAssy = fnd_api.g_true
9899: /* End of bug fix 5026797 */

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

9928: move_txns(p_gib => l_gib,
9929: x_returnStatus => x_returnStatus);
9930:
9931: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9932: l_errMsg := 'wip_movProc_priv.move_txns failed';
9933: raise fnd_api.g_exc_unexpected_error;
9934: END IF; -- check return status
9935:
9936: -- check IF easy completion txns

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

9940: p_txn_type => WIP_CONSTANTS.COMP_TXN,
9941: x_returnStatus => x_returnStatus);
9942:
9943: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9944: l_errMsg := 'wip_movProc_priv.ez_completion (complete) failed';
9945: raise fnd_api.g_exc_unexpected_error;
9946: END IF; -- check return status
9947: ELSE /* Bug fix 5026797 (base 4901865) - Assembly completion/return transaction through Discrete Workstation are
9948: processed with p_insertAssy = fnd_api.g_false. Added the following call to snapshot for assembly completion transaction.*/

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

9953: p_txn_action_id => WIP_CONSTANTS.CPLASSY_ACTION,
9954: x_returnStatus => x_returnStatus);
9955:
9956: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9957: l_errMsg := 'wip_movProc_priv.snapshot_online(complete) failed';
9958: raise fnd_api.g_exc_unexpected_error;
9959: END IF; -- check return status
9960: END IF; -- p_insertAssy = fnd_api.g_true
9961: /* End of bug fix 5026797 */

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

9966: IF(l_gib.move_mode = WIP_CONSTANTS.BACKGROUND) THEN
9967: update_wo_and_snapshot(p_gib => l_gib,
9968: x_returnStatus => x_returnStatus);
9969: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9970: l_errMsg := 'wip_movProc_priv.update_wo_and_snapshot';
9971: raise fnd_api.g_exc_unexpected_error;
9972: END IF; -- check return status
9973: END IF;
9974:

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

10397: ROLLBACK TO SAVEPOINT s_move_proc;
10398: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
10399: END IF;
10400: IF (l_logLevel <= wip_constants.trace_logging) THEN
10401: wip_logger.exitPoint(p_procName =>'wip_movProc_priv.processIntf',
10402: p_procReturnStatus => x_returnStatus,
10403: p_msg => l_errMsg,
10404: x_returnStatus => l_returnStatus);
10405: END IF;

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

10458: WHERE wtie.transaction_id = wmti.transaction_id);
10459: ELSE -- move mode is online
10460: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
10461: IF (l_logLevel <= wip_constants.trace_logging) THEN
10462: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.processIntf',
10463: p_procReturnStatus => x_returnStatus,
10464: p_msg => 'unexpected error: ' || SQLERRM,
10465: x_returnStatus => l_returnStatus);
10466: END IF;

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

10534: -- applicable for background transaction.
10535: --fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
10536: --fnd_msg_pub.add;
10537: IF (l_logLevel <= wip_constants.trace_logging) THEN
10538: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.processIntf',
10539: p_procReturnStatus => x_returnStatus,
10540: p_msg => 'some records error out',
10541: x_returnStatus => l_returnStatus);
10542: END IF;

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

10553: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
10554: ELSE
10555: x_returnStatus := fnd_api.g_ret_sts_success;
10556: IF (l_logLevel <= wip_constants.trace_logging) THEN
10557: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.processIntf',
10558: p_procReturnStatus => x_returnStatus,
10559: p_msg => 'no record in this group error out',
10560: x_returnStatus => l_returnStatus);
10561: END IF;

Line 10606: wip_movProc_priv.processIntf

10602: -- should not delete lock record from their temp table. These lock records
10603: -- will be deleted when wip call inv_table_lock_pvt.release_locks.
10604: WIP_CONSTANTS.WIP_MOVE_WORKER := 'Y';
10605:
10606: wip_movProc_priv.processIntf
10607: (p_group_id => p_group_id,
10608: p_proc_phase => p_proc_phase,
10609: p_time_out => p_time_out,
10610: p_move_mode => WIP_CONSTANTS.BACKGROUND,

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

10625: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
10626: retcode := 2; -- error
10627: -- Fixed bug 5355443. Since WIP_SOME_RECORDS_ERROR message is only
10628: -- applicable to background transaction, we should set error message here
10629: -- instead of wip_movProc_priv.processIntf().
10630: --wip_utilities.get_message_stack(p_msg =>errbuf);
10631: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
10632: errbuf := fnd_message.get;
10633: END IF;

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

10649: -- write parameter value to log file
10650: IF (l_logLevel <= wip_constants.trace_logging) THEN
10651: l_params(1).paramName := 'p_tmp_id';
10652: l_params(1).paramValue := p_tmp_id;
10653: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.repetitive_scrap',
10654: p_params => l_params,
10655: x_returnStatus => l_returnStatus);
10656: END IF;
10657: -- insert into mtl_material_txn_allocations for repetitive schedule

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

10714: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
10715: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
10716:
10717: IF (l_logLevel <= wip_constants.trace_logging) THEN
10718: wip_logger.exitPoint(p_procName=>'wip_movProc_priv.repetitive_scrap',
10719: p_procReturnStatus => x_returnStatus,
10720: p_msg => l_msg,
10721: x_returnStatus => l_returnStatus);
10722: END IF;

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

11007: l_params(5).paramValue := p_assySerial;
11008: l_params(6).paramName := 'p_print_label'; /* VJ Label Printing */
11009: l_params(6).paramValue := p_print_label; /* VJ Label Printing */
11010:
11011: wip_logger.entryPoint(p_procName => 'wip_movProc_priv.processOATxn',
11012: p_params => l_params,
11013: x_returnStatus => l_return_status);
11014: END IF;
11015: l_process_phase := '2';

Line 11047: wip_movProc_priv.processIntf

11043: wip_move_validator.validateOATxn(p_group_id => p_group_id);
11044: l_process_phase := '4';
11045:
11046: -- Process move and material records.
11047: wip_movProc_priv.processIntf
11048: (p_group_id => p_group_id,
11049: p_child_txn_id => p_child_txn_id,
11050: p_mtl_header_id => p_mtl_header_id,
11051: p_assy_header_id => p_mtl_header_id,

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

11101: x_returnStatus := fnd_api.g_ret_sts_success;
11102:
11103: -- write to the log file
11104: IF (l_log_level <= wip_constants.trace_logging) THEN
11105: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.processOATxn',
11106: p_procReturnStatus => x_returnStatus,
11107: p_msg => 'procedure complete',
11108: x_returnStatus => l_return_status);
11109: END IF;

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

11122: END LOOP;
11123: ROLLBACK TO SAVEPOINT s_oa_txn_proc;
11124: x_returnStatus := fnd_api.g_ret_sts_error;
11125: IF (l_log_level <= wip_constants.trace_logging) THEN
11126: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.processOATxn',
11127: p_procReturnStatus => x_returnStatus,
11128: p_msg => 'wip_movProc_priv.processOATxn failed : '
11129: || l_process_phase,
11130: x_returnStatus => l_return_status);

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

11124: x_returnStatus := fnd_api.g_ret_sts_error;
11125: IF (l_log_level <= wip_constants.trace_logging) THEN
11126: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.processOATxn',
11127: p_procReturnStatus => x_returnStatus,
11128: p_msg => 'wip_movProc_priv.processOATxn failed : '
11129: || l_process_phase,
11130: x_returnStatus => l_return_status);
11131: END IF;
11132: -- close log file

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

11140: fnd_message.set_token('MESSAGE', l_error_msg);
11141: fnd_msg_pub.add;
11142:
11143: IF (l_log_level <= wip_constants.trace_logging) THEN
11144: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.processOATxn',
11145: p_procReturnStatus => x_returnStatus,
11146: p_msg => l_error_msg || ' : ' || l_process_phase,
11147: x_returnStatus => l_return_status);
11148: END IF;

Line 11152: END wip_movProc_priv;

11148: END IF;
11149: -- close log file
11150: wip_logger.cleanUp(x_returnStatus => l_return_status);
11151: END processOATxn;
11152: END wip_movProc_priv;