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_BFLPROC_PRIV dependencies on WIP_BFLPROC_PRIV

Line 1: package body wip_bflProc_priv as

1: package body wip_bflProc_priv as
2: /* $Header: wipbflpb.pls 120.75.12020000.7 2013/02/18 09:48:36 akuppa ship $ */
3:
4: ---------------
5: --private types

Line 341: wip_logger.entryPoint(p_procName => 'wip_bflProc_priv.processRequirements',

337: l_params(21).paramName := 'p_reference';
338: l_params(21).paramValue := p_reference;
339: l_params(22).paramName := 'p_mtlTxnMode';
340: l_params(22).paramValue := p_mtlTxnMode;
341: wip_logger.entryPoint(p_procName => 'wip_bflProc_priv.processRequirements',
342: p_params => l_params,
343: x_returnStatus => x_returnStatus);
344: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
345: raise fnd_api.g_exc_unexpected_error;

Line 819: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.processRequirements',

815: end if;
816:
817: x_returnStatus := fnd_api.g_ret_sts_success;
818: if (l_logLevel <= wip_constants.trace_logging) then
819: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.processRequirements',
820: p_procReturnStatus => x_returnStatus,
821: p_msg => 'procedure succeeded',
822: x_returnStatus => l_returnStatus); --discard logging return status
823: end if;

Line 832: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.processRequirements',

828: exception
829: when fnd_api.g_exc_unexpected_error then
830: rollback to wipbflpb20;
831: if (l_logLevel <= wip_constants.trace_logging) then
832: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.processRequirements',
833: p_procReturnStatus => x_returnStatus,
834: p_msg => l_errMsg,
835: x_returnStatus => l_returnStatus); --discard logging return status
836: end if;

Line 844: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_bflProc_priv',

840: end if;
841: when others then
842: rollback to wipbflpb20;
843: x_returnStatus := fnd_api.g_ret_sts_unexp_error;--unexpec error if exception occurs
844: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_bflProc_priv',
845: p_procedure_name => 'processRequirements',
846: p_error_text => SQLERRM);
847: if (l_logLevel <= wip_constants.trace_logging) then
848: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.processRequirements',

Line 848: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.processRequirements',

844: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_bflProc_priv',
845: p_procedure_name => 'processRequirements',
846: p_error_text => SQLERRM);
847: if (l_logLevel <= wip_constants.trace_logging) then
848: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.processRequirements',
849: p_procReturnStatus => x_returnStatus,
850: p_msg => 'unexpected error: ' || SQLERRM,
851: x_returnStatus => l_returnStatus); --discard logging return status
852: end if;

Line 1040: wip_logger.entryPoint(p_procName => 'wip_bflProc_priv.explodeRequirements',

1036: l_params(8).paramName := 'p_implFlag';
1037: l_params(8).paramValue := p_implFlag;
1038:
1039:
1040: wip_logger.entryPoint(p_procName => 'wip_bflProc_priv.explodeRequirements',
1041: p_params => l_params,
1042: x_returnStatus => x_returnStatus);
1043: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1044: raise fnd_api.g_exc_unexpected_error;

Line 1099: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.explodeRequirements',

1095: x_returnStatus := fnd_api.g_ret_sts_success;
1096: x_compTbl := system.wip_component_tbl_t();
1097:
1098: if (l_logLevel <= wip_constants.trace_logging) then
1099: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.explodeRequirements',
1100: p_procReturnStatus => x_returnStatus,
1101: p_msg => 'no bom for this item!',
1102: x_returnStatus => l_returnStatus); --discard logging return status
1103: end if;

Line 1486: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.explodeRequirements',

1482: where group_id = l_grpID;
1483:
1484: x_returnStatus := fnd_api.g_ret_sts_success;
1485: if (l_logLevel <= wip_constants.trace_logging) then
1486: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.explodeRequirements',
1487: p_procReturnStatus => x_returnStatus,
1488: p_msg => 'procedure success',
1489: x_returnStatus => l_returnStatus); --discard logging return status
1490: end if;

Line 1501: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.explodeRequirements',

1497: when fnd_api.g_exc_unexpected_error then
1498: rollback to wipbflpb30;
1499: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1500: if (l_logLevel <= wip_constants.trace_logging) then
1501: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.explodeRequirements',
1502: p_procReturnStatus => x_returnStatus,
1503: p_msg => l_errMsg,
1504: x_returnStatus => l_returnStatus); --discard logging return status
1505: end if;

Line 1518: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.explodeRequirements',

1514: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
1515: fnd_message.set_token('ERROR_TEXT', SQLERRM);
1516: fnd_msg_pub.add;
1517: if (l_logLevel <= wip_constants.trace_logging) then
1518: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.explodeRequirements',
1519: p_procReturnStatus => x_returnStatus,
1520: p_msg => 'unexpected error: ' || SQLERRM,
1521: x_returnStatus => l_returnStatus); --discard logging return status
1522: end if;

Line 1668: wip_logger.entryPoint(p_procName => 'wip_bflProc_priv.backflush',

1664: l_params(24).paramValue := p_reasonID;
1665: l_params(25).paramName := 'p_reference';
1666: l_params(25).paramValue := p_reference;
1667:
1668: wip_logger.entryPoint(p_procName => 'wip_bflProc_priv.backflush',
1669: p_params => l_params,
1670: x_returnStatus => l_returnStatus);
1671: END IF;
1672: IF(p_batchSeq IS NULL) THEN

Line 1753: wip_bflProc_priv.processRequirements

1749: -- again.
1750:
1751: /*Backflush all assembly pull component*/
1752: FOR l_repAssyPull IN c_repAssyPull LOOP
1753: wip_bflProc_priv.processRequirements
1754: (p_wipEntityID => p_wipEntityID,
1755: p_wipEntityType => p_entityType,
1756: p_repSchedID => l_repAssyPull.scheID,
1757: p_repLineID => p_lineID,

Line 1785: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;

1781: x_compTbl => l_compTbl,
1782: x_returnStatus => l_returnStatus);
1783:
1784: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
1785: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;
1786: raise fnd_api.g_exc_unexpected_error;
1787: END IF;
1788: END LOOP;
1789:

Line 1868: -- before call wip_bflProc_priv.processRequirements for

1864: l_first_bf_op := -1;
1865: l_last_bf_op := -1;
1866:
1867: -- Call bf_require to derive first_bf_op, last_bf_op, and bf_qty
1868: -- before call wip_bflProc_priv.processRequirements for
1869: -- Operation Pull components
1870: wma_move.bf_require(p_jobID => p_wipEntityID,
1871: p_fm_op => l_fm_op,
1872: p_fm_step => l_fm_step,

Line 1901: wip_bflProc_priv.processRequirements

1897: * Call backflush processor to insert record into MMTT
1898: * for each schedule found in l_rsa.
1899: * This is only for operation pull components.
1900: **/
1901: wip_bflProc_priv.processRequirements
1902: (p_wipEntityID => p_wipEntityID,
1903: p_wipEntityType => p_entityType,
1904: p_repSchedID => l_rsa(i).scheID,
1905: p_repLineID => p_lineID,

Line 1930: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;

1926: x_compTbl => l_compTbl,
1927: x_returnStatus => l_returnStatus);
1928:
1929: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
1930: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;
1931: raise fnd_api.g_exc_unexpected_error;
1932: END IF;
1933: END LOOP;
1934: END IF; -- l_first_bf_op <> -1

Line 1937: -- and bf_qty before call wip_bflProc_priv.processRequirements

1933: END LOOP;
1934: END IF; -- l_first_bf_op <> -1
1935:
1936: -- Call assy_pull_bf to derive first_bf_op, last_bf_op,
1937: -- and bf_qty before call wip_bflProc_priv.processRequirements
1938: -- for Assembly Pull components. This is only for Scrap txns
1939:
1940: -- set l_first_bf_op and l_last_bf_op back to -1
1941: l_first_bf_op := -1;

Line 1976: wip_bflProc_priv.processRequirements

1972: * Call backflush processor to insert record into MMTT
1973: * for each schedule found in l_rsa
1974: * This is only for assembly pull components.
1975: **/
1976: wip_bflProc_priv.processRequirements
1977: (p_wipEntityID => p_wipEntityID,
1978: p_wipEntityType => p_entityType,
1979: p_repSchedID => l_rsa(i).scheID,
1980: p_repLineID => p_lineID,

Line 2005: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;

2001: x_compTbl => l_compTbl,
2002: x_returnStatus => l_returnStatus);
2003:
2004: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
2005: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;
2006: raise fnd_api.g_exc_unexpected_error;
2007: END IF;
2008: END LOOP;
2009: END IF; -- l_first_bf_op <> -1

Line 2097: wip_bflProc_priv.processRequirements

2093: * Call backflush processor to insert record into MMTT
2094: * for each schedule found in l_rsa
2095: * This is only for assembly pull components(Completion/Return).
2096: **/
2097: wip_bflProc_priv.processRequirements
2098: (p_wipEntityID => p_wipEntityID,
2099: p_wipEntityType => p_entityType,
2100: p_repSchedID => l_rsa(i).scheID,
2101: p_repLineID => p_lineID,

Line 2129: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;

2125: x_compTbl => l_compTbl,
2126: x_returnStatus => l_returnStatus);
2127:
2128: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
2129: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;
2130: raise fnd_api.g_exc_unexpected_error;
2131: END IF;
2132: END LOOP;
2133: END IF; -- Completion/return txns

Line 2216: -- before call wip_bflProc_priv.processRequirements for

2212: x_returnStatus => l_returnStatus);
2213: END LOOP;
2214: END IF;
2215: -- Call bf_require to derive first_bf_op, last_bf_op, and bf_qty
2216: -- before call wip_bflProc_priv.processRequirements for
2217: -- Operation Pull components
2218:
2219: -- set l_first_bf_op and l_last_bf_op back to -1
2220: l_first_bf_op := -1;

Line 2252: wip_bflProc_priv.processRequirements

2248: * Call backflush processor to insert record into MMTT
2249: * for each schedule found in l_rsa.
2250: * This is only for operation pull components.
2251: **/
2252: wip_bflProc_priv.processRequirements
2253: (p_wipEntityID => p_wipEntityID,
2254: p_wipEntityType => p_entityType,
2255: p_repSchedID => l_rsa(i).scheID,
2256: p_repLineID => p_lineID,

Line 2281: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;

2277: x_compTbl => l_compTbl,
2278: x_returnStatus => l_returnStatus);
2279:
2280: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
2281: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;
2282: raise fnd_api.g_exc_unexpected_error;
2283: END IF;
2284: END LOOP;
2285: END IF; -- l_first_bf_op <> -1

Line 2287: -- and bf_qty before call wip_bflProc_priv.processRequirements

2283: END IF;
2284: END LOOP;
2285: END IF; -- l_first_bf_op <> -1
2286: -- Call assy_pull_bf to derive first_bf_op, last_bf_op,
2287: -- and bf_qty before call wip_bflProc_priv.processRequirements
2288: -- for Assembly Pull components. This is only for Scrap txns
2289:
2290: -- set l_first_bf_op and l_last_bf_op back to -1
2291: l_first_bf_op := -1;

Line 2326: wip_bflProc_priv.processRequirements

2322: * Call backflush processor to insert record into MMTT
2323: * for each schedule found in l_rsa
2324: * This is only for assembly pull components.
2325: **/
2326: wip_bflProc_priv.processRequirements
2327: (p_wipEntityID => p_wipEntityID,
2328: p_wipEntityType => p_entityType,
2329: p_repSchedID => l_rsa(i).scheID,
2330: p_repLineID => p_lineID,

Line 2355: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;

2351: x_compTbl => l_compTbl,
2352: x_returnStatus => l_returnStatus);
2353:
2354: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
2355: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;
2356: raise fnd_api.g_exc_unexpected_error;
2357: END IF;
2358: END LOOP;
2359: END IF; -- l_first_bf_op <> -1

Line 2369: -- before call wip_bflProc_priv.processRequirements for

2365: -- set l_first_bf_op and l_last_bf_op back to -1
2366: l_first_bf_op := -1;
2367: l_last_bf_op := -1;
2368: -- Call bf_require to derive first_bf_op, last_bf_op, and bf_qty
2369: -- before call wip_bflProc_priv.processRequirements for
2370: -- Operation Pull components
2371: wma_move.bf_require(p_jobID => p_wipEntityID,
2372: p_fm_op => l_fm_op,
2373: p_fm_step => l_fm_step,

Line 2389: wip_bflProc_priv.processRequirements

2385: fnd_msg_pub.add;
2386: raise fnd_api.g_exc_unexpected_error;
2387: END IF;
2388: IF(l_first_bf_op <> -1) THEN
2389: wip_bflProc_priv.processRequirements
2390: (p_wipEntityID => p_wipEntityID,
2391: p_wipEntityType => p_entityType,
2392: p_repSchedID => null,
2393: p_repLineID => null,

Line 2418: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;

2414: x_compTbl => l_compTbl,
2415: x_returnStatus => l_returnStatus);
2416:
2417: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
2418: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;
2419: raise fnd_api.g_exc_unexpected_error;
2420: END IF;
2421: END IF; -- l_first_bf_op <> -1
2422:

Line 2424: -- and bf_qty before call wip_bflProc_priv.processRequirements

2420: END IF;
2421: END IF; -- l_first_bf_op <> -1
2422:
2423: -- Call assy_pull_bf to derive first_bf_op, last_bf_op,
2424: -- and bf_qty before call wip_bflProc_priv.processRequirements
2425: -- for Assembly Pull components. This is only for Scrap txns
2426:
2427: -- set l_first_bf_op and l_last_bf_op back to -1
2428: l_first_bf_op := -1;

Line 2456: wip_bflProc_priv.processRequirements

2452: * Call backflush processor to insert record into MMTT
2453: * for each schedule found in l_rsa
2454: * This is only for assembly pull components.
2455: **/
2456: wip_bflProc_priv.processRequirements
2457: (p_wipEntityID => p_wipEntityID,
2458: p_wipEntityType => p_entityType,
2459: p_repSchedID => null,
2460: p_repLineID => null,

Line 2485: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;

2481: x_compTbl => l_compTbl,
2482: x_returnStatus => l_returnStatus);
2483:
2484: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
2485: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;
2486: raise fnd_api.g_exc_unexpected_error;
2487: END IF;
2488: END IF; -- l_first_bf_op <> -1
2489: END IF; -- call from Move form

Line 2500: wip_bflProc_priv.processRequirements

2496: l_bf_qty := p_primaryQty;
2497: ELSIF(p_txnType = WIP_CONSTANTS.RET_TXN) THEN
2498: l_bf_qty := -1 * p_primaryQty;
2499: END IF;
2500: wip_bflProc_priv.processRequirements
2501: (p_wipEntityID => p_wipEntityID,
2502: p_wipEntityType => p_entityType,
2503: p_repSchedID => null,
2504: p_repLineID => null,

Line 2532: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;

2528: x_compTbl => l_compTbl,
2529: x_returnStatus => l_returnStatus);
2530:
2531: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
2532: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;
2533: raise fnd_api.g_exc_unexpected_error;
2534: END IF;
2535: END IF; -- Completion/Return/EZ Completion/EZ Return
2536:

Line 2552: -- before call wip_bflProc_priv.processRequirements for

2548: l_to_op := p_fmOp;
2549: l_to_step := p_fmStep;
2550: END IF;
2551: -- Call bf_require to derive first_bf_op, last_bf_op, and bf_qty
2552: -- before call wip_bflProc_priv.processRequirements for
2553: -- Operation Pull components
2554:
2555: -- set l_first_bf_op and l_last_bf_op back to -1
2556: l_first_bf_op := -1;

Line 2581: wip_bflProc_priv.processRequirements

2577: * Call backflush processor to insert record into MMTT
2578: * for each schedule found in l_rsa.
2579: * This is only for operation pull components.
2580: **/
2581: wip_bflProc_priv.processRequirements
2582: (p_wipEntityID => p_wipEntityID,
2583: p_wipEntityType => p_entityType,
2584: p_repSchedID => null,
2585: p_repLineID => null,

Line 2617: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;

2613: AND transaction_action_id in (wip_constants.isscomp_action, wip_constants.retcomp_action,
2614: wip_constants.issnegc_action, wip_constants.retnegc_action);
2615:
2616: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
2617: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;
2618: raise fnd_api.g_exc_unexpected_error;
2619: END IF;
2620: END IF; -- l_first_bf_op <> -1
2621:

Line 2623: -- and bf_qty before call wip_bflProc_priv.processRequirements

2619: END IF;
2620: END IF; -- l_first_bf_op <> -1
2621:
2622: -- Call assy_pull_bf to derive first_bf_op, last_bf_op,
2623: -- and bf_qty before call wip_bflProc_priv.processRequirements
2624: -- for Assembly Pull components. This is only for Scrap txns
2625:
2626: -- set l_first_bf_op and l_last_bf_op back to -1
2627: l_first_bf_op := -1;

Line 2654: wip_bflProc_priv.processRequirements

2650: * Call backflush processor to insert record into MMTT
2651: * for each schedule found in l_rsa
2652: * This is only for assembly pull components.
2653: **/
2654: wip_bflProc_priv.processRequirements
2655: (p_wipEntityID => p_wipEntityID,
2656: p_wipEntityType => p_entityType,
2657: p_repSchedID => null,
2658: p_repLineID => null,

Line 2683: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;

2679: x_compTbl => l_compTbl,
2680: x_returnStatus => l_returnStatus);
2681:
2682: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
2683: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;
2684: raise fnd_api.g_exc_unexpected_error;
2685: END IF;
2686: END IF; -- l_first_bf_op <> -1
2687: END IF; -- Overmove/ Overcompletion

Line 2989: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.backflush',

2985: END IF; -- WIP_CONSTANTS.MMTT_TBL
2986:
2987: x_returnStatus := fnd_api.g_ret_sts_success;
2988: IF (l_logLevel <= wip_constants.trace_logging) THEN
2989: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.backflush',
2990: p_procReturnStatus => x_returnStatus,
2991: p_msg => 'Succesfully inserted components into MMTT',
2992: x_returnStatus => l_returnStatus);
2993: END IF;

Line 2999: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.backflush',

2995: WHEN fnd_api.g_exc_unexpected_error THEN
2996: ROLLBACK TO SAVEPOINT s_backflush;
2997: x_returnStatus := fnd_api.g_ret_sts_error;
2998: IF (l_logLevel <= wip_constants.trace_logging) THEN
2999: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.backflush',
3000: p_procReturnStatus => x_returnStatus,
3001: p_msg => l_errMsg,
3002: x_returnStatus => l_returnStatus);
3003: END IF;

Line 3008: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.backflush',

3004: WHEN others THEN
3005: ROLLBACK TO SAVEPOINT s_backflush;
3006: x_returnStatus := fnd_api.g_ret_sts_error;
3007: IF (l_logLevel <= wip_constants.trace_logging) THEN
3008: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.backflush',
3009: p_procReturnStatus => x_returnStatus,
3010: p_msg => 'Unexpected error : ' || SQLERRM,
3011: x_returnStatus => l_returnStatus);
3012: END IF;

Line 3107: wip_logger.entryPoint(p_procName => 'wip_bflProc_priv.backflush',

3103: l_params(13).paramValue := p_childMovTxnID;
3104: l_params(14).paramName := 'p_movTxnID';
3105: l_params(14).paramValue := p_movTxnID;
3106:
3107: wip_logger.entryPoint(p_procName => 'wip_bflProc_priv.backflush',
3108: p_params => l_params,
3109: x_returnStatus => l_returnStatus);
3110: END IF;
3111:

Line 3172: -- before call wip_bflProc_priv.processRequirements for

3168: -- set l_first_bf_op and l_last_bf_op back to -1
3169: l_first_bf_op := -1;
3170: l_last_bf_op := -1;
3171: -- Call bf_require to derive first_bf_op, last_bf_op, and bf_qty
3172: -- before call wip_bflProc_priv.processRequirements for
3173: -- Operation Pull components
3174: wma_move.bf_require(p_jobID => p_wipEntityID,
3175: p_fm_op => l_fm_op,
3176: p_fm_step => l_fm_step,

Line 3192: wip_bflProc_priv.processRequirements

3188: fnd_msg_pub.add;
3189: raise fnd_api.g_exc_unexpected_error;
3190: END IF;
3191: IF(l_first_bf_op <> -1) THEN
3192: wip_bflProc_priv.processRequirements
3193: (p_wipEntityID => p_wipEntityID,
3194: p_wipEntityType => p_entityType,
3195: p_cplTxnID => null,
3196: p_movTxnID => p_movTxnID,

Line 3214: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;

3210: x_compTbl => l_compTbl,
3211: x_returnStatus => l_returnStatus);
3212:
3213: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
3214: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;
3215: raise fnd_api.g_exc_unexpected_error;
3216: END IF;
3217: END IF; -- l_first_bf_op <> -1
3218:

Line 3220: -- and bf_qty before call wip_bflProc_priv.processRequirements

3216: END IF;
3217: END IF; -- l_first_bf_op <> -1
3218:
3219: -- Call assy_pull_bf to derive first_bf_op, last_bf_op,
3220: -- and bf_qty before call wip_bflProc_priv.processRequirements
3221: -- for Assembly Pull components. This is only for Scrap txns
3222:
3223: -- set l_first_bf_op and l_last_bf_op back to -1
3224: l_first_bf_op := -1;

Line 3246: wip_bflProc_priv.processRequirements

3242: fnd_msg_pub.add;
3243: raise fnd_api.g_exc_unexpected_error;
3244: END IF;
3245: IF(l_first_bf_op <> -1) THEN
3246: wip_bflProc_priv.processRequirements
3247: (p_wipEntityID => p_wipEntityID,
3248: p_wipEntityType => p_entityType,
3249: p_cplTxnID => null,
3250: p_movTxnID => p_movTxnID,

Line 3268: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;

3264: x_compTbl => l_compTbl,
3265: x_returnStatus => l_returnStatus);
3266:
3267: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
3268: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;
3269: raise fnd_api.g_exc_unexpected_error;
3270: END IF;
3271: END IF; -- l_first_bf_op <> -1
3272: END IF; -- Move related transactions

Line 3282: wip_bflProc_priv.processRequirements

3278: l_bf_qty := p_primaryQty;
3279: ELSIF(p_txnType = WIP_CONSTANTS.RET_TXN) THEN
3280: l_bf_qty := -1 * p_primaryQty;
3281: END IF;
3282: wip_bflProc_priv.processRequirements
3283: (p_wipEntityID => p_wipEntityID,
3284: p_wipEntityType => p_entityType,
3285: p_cplTxnID => p_cplTxnID,
3286: -- Fixed bug 5014211. Stamp move_transaction_id for assembly

Line 3307: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;

3303: x_compTbl => l_compTbl,
3304: x_returnStatus => l_returnStatus);
3305:
3306: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
3307: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;
3308: raise fnd_api.g_exc_unexpected_error;
3309: END IF;
3310: END IF; -- Completion/Return/EZ Completion/EZ Return
3311:

Line 3327: -- before call wip_bflProc_priv.processRequirements for

3323: l_to_op := p_fmOp;
3324: l_to_step := p_fmStep;
3325: END IF;
3326: -- Call bf_require to derive first_bf_op, last_bf_op, and bf_qty
3327: -- before call wip_bflProc_priv.processRequirements for
3328: -- Operation Pull components
3329:
3330: -- set l_first_bf_op and l_last_bf_op back to -1
3331: l_first_bf_op := -1;

Line 3351: wip_bflProc_priv.processRequirements

3347: fnd_msg_pub.add;
3348: raise fnd_api.g_exc_unexpected_error;
3349: END IF;
3350: IF(l_first_bf_op <> -1) THEN
3351: wip_bflProc_priv.processRequirements
3352: (p_wipEntityID => p_wipEntityID,
3353: p_wipEntityType => p_entityType,
3354: p_cplTxnID => null,
3355: p_movTxnID => p_childMovTxnID,

Line 3373: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;

3369: x_compTbl => l_compTbl,
3370: x_returnStatus => l_returnStatus);
3371:
3372: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
3373: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;
3374: raise fnd_api.g_exc_unexpected_error;
3375: END IF;
3376: END IF; -- l_first_bf_op <> -1
3377:

Line 3379: -- and bf_qty before call wip_bflProc_priv.processRequirements

3375: END IF;
3376: END IF; -- l_first_bf_op <> -1
3377:
3378: -- Call assy_pull_bf to derive first_bf_op, last_bf_op,
3379: -- and bf_qty before call wip_bflProc_priv.processRequirements
3380: -- for Assembly Pull components. This is only for Scrap txns
3381:
3382: -- set l_first_bf_op and l_last_bf_op back to -1
3383: l_first_bf_op := -1;

Line 3405: wip_bflProc_priv.processRequirements

3401: fnd_msg_pub.add;
3402: raise fnd_api.g_exc_unexpected_error;
3403: END IF;
3404: IF(l_first_bf_op <> -1) THEN
3405: wip_bflProc_priv.processRequirements
3406: (p_wipEntityID => p_wipEntityID,
3407: p_wipEntityType => p_entityType,
3408: p_cplTxnID => null,
3409: p_movTxnID => p_childMovTxnID,

Line 3427: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;

3423: x_compTbl => l_compTbl,
3424: x_returnStatus => l_returnStatus);
3425:
3426: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
3427: l_errMsg := 'wip_bflProc_priv.procesRequirements failed' ;
3428: raise fnd_api.g_exc_unexpected_error;
3429: END IF;
3430: END IF; -- l_first_bf_op <> -1
3431: END IF; -- Overmove/ Overcompletion

Line 3508: p_procName => 'wip_bflProc_priv.backflush',

3504:
3505: x_returnStatus := fnd_api.g_ret_sts_success;
3506: IF (l_logLevel <= wip_constants.trace_logging) THEN
3507: wip_logger.exitPoint(
3508: p_procName => 'wip_bflProc_priv.backflush',
3509: p_procReturnStatus => x_returnStatus,
3510: p_msg => 'Succesfully inserted components into PL/SQL object',
3511: x_returnStatus => l_returnStatus);
3512: END IF;

Line 3518: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.backflush',

3514: WHEN fnd_api.g_exc_unexpected_error THEN
3515: ROLLBACK TO SAVEPOINT s_backflush2;
3516: x_returnStatus := fnd_api.g_ret_sts_error;
3517: IF (l_logLevel <= wip_constants.trace_logging) THEN
3518: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.backflush',
3519: p_procReturnStatus => x_returnStatus,
3520: p_msg => l_errMsg,
3521: x_returnStatus => l_returnStatus);
3522: END IF;

Line 3527: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.backflush',

3523: WHEN others THEN
3524: ROLLBACK TO SAVEPOINT s_backflush2;
3525: x_returnStatus := fnd_api.g_ret_sts_error;
3526: IF (l_logLevel <= wip_constants.trace_logging) THEN
3527: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.backflush',
3528: p_procReturnStatus => x_returnStatus,
3529: p_msg => 'Unexpected error : ' || SQLERRM,
3530: x_returnStatus => l_returnStatus);
3531: END IF;

Line 3533: end wip_bflProc_priv;

3529: p_msg => 'Unexpected error : ' || SQLERRM,
3530: x_returnStatus => l_returnStatus);
3531: END IF;
3532: END backflush;
3533: end wip_bflProc_priv;