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_FLOWUTIL_PRIV dependencies on WIP_FLOWUTIL_PRIV

Line 1: package body wip_flowUtil_priv as

1: package body wip_flowUtil_priv as
2: /* $Header: wipfscmb.pls 120.21.12010000.2 2008/10/07 05:59:10 awongwai ship $ */
3:
4: function checkSubstitution(p_parentID in number) return varchar2;
5:

Line 107: wip_logger.entryPoint(p_procName => 'wip_flowutil_priv.processFlowInterfaceRecords',

103:
104: if (l_logLevel <= wip_constants.trace_logging) then
105: l_params(1).paramName := 'p_txnHeaderID';
106: l_params(1).paramValue := p_txnHeaderID;
107: wip_logger.entryPoint(p_procName => 'wip_flowutil_priv.processFlowInterfaceRecords',
108: p_params => l_params,
109: x_returnStatus => l_returnStatus);
110: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
111: raise fnd_api.g_exc_unexpected_error;

Line 339: wip_logger.exitPoint(p_procName => 'wip_flowutil_priv.processFlowInterfaceRecords',

335: end;
336: end loop;
337:
338: if (l_logLevel <= wip_constants.trace_logging) then
339: wip_logger.exitPoint(p_procName => 'wip_flowutil_priv.processFlowInterfaceRecords',
340: p_procReturnStatus => fnd_api.g_ret_sts_success,
341: p_msg => 'Finished processFlowInterfaceRecords',
342: x_returnStatus => l_returnStatus); --discard logging return status
343: end if;

Line 785: wip_logger.entryPoint(p_procName => 'wip_flowutil_priv.explodeRequirementsToMTI',

781: l_params(20).paramName := 'p_txnBatchSeq';
782: l_params(20).paramValue := p_txnBatchSeq;
783: l_params(20).paramName := 'p_defaultPushSubinv';
784: l_params(20).paramValue := p_defaultPushSubinv;
785: wip_logger.entryPoint(p_procName => 'wip_flowutil_priv.explodeRequirementsToMTI',
786: p_params => l_params,
787: x_returnStatus => x_returnStatus);
788: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
789: raise fnd_api.g_exc_unexpected_error;

Line 984: wip_logger.exitPoint(p_procName => 'wip_flowutil_priv.explodeRequirementsToMTI',

980: l_count := l_compTbl.next(l_count);
981: end loop;
982:
983: if (l_logLevel <= wip_constants.trace_logging) then
984: wip_logger.exitPoint(p_procName => 'wip_flowutil_priv.explodeRequirementsToMTI',
985: p_procReturnStatus => x_returnStatus,
986: p_msg => 'Explode BOM to MTI successfully for interface ' ||
987: to_char(p_parentID) || ' successfully!',
988: x_returnStatus => l_returnStatus); --discard logging return status

Line 998: wip_logger.exitPoint(p_procName => 'wip_flowutil_priv.explodeRequirementsToMTI',

994: wip_utilities.get_message_stack(p_msg => l_errMsg,
995: p_delete_stack => fnd_api.g_false);
996:
997: if (l_logLevel <= wip_constants.trace_logging) then
998: wip_logger.exitPoint(p_procName => 'wip_flowutil_priv.explodeRequirementsToMTI',
999: p_procReturnStatus => x_returnStatus,
1000: p_msg => 'explosion error: ' || l_errMsg || ' for exploding interface '
1001: || to_char(p_parentID),
1002: x_returnStatus => l_returnStatus); --discard logging return status

Line 1015: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_flowutil_priv',

1011: when others then
1012: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1013: if (l_logLevel <= wip_constants.trace_logging) then
1014:
1015: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_flowutil_priv',
1016: p_procedure_name => 'explodeRequirementsToMTI',
1017: p_error_text => SQLERRM);
1018:
1019: wip_logger.exitPoint(p_procName => 'wip_flowutil_priv.explodeRequirementsToMTI',

Line 1019: wip_logger.exitPoint(p_procName => 'wip_flowutil_priv.explodeRequirementsToMTI',

1015: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_flowutil_priv',
1016: p_procedure_name => 'explodeRequirementsToMTI',
1017: p_error_text => SQLERRM);
1018:
1019: wip_logger.exitPoint(p_procName => 'wip_flowutil_priv.explodeRequirementsToMTI',
1020: p_procReturnStatus => x_returnStatus,
1021: p_msg => 'unexpected error: ' || l_errMsg || ' for exploding interface '
1022: || to_char(p_parentID),
1023: x_returnStatus => l_returnStatus); --discard logging return status

Line 1474: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.createFlowSchedule',

1470:
1471: if (l_logLevel <= wip_constants.trace_logging) then
1472: l_params(1).paramName := 'p_txnInterfaceID';
1473: l_params(1).paramValue := p_txnInterfaceID;
1474: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.createFlowSchedule',
1475: p_params => l_params,
1476: x_returnStatus => x_returnStatus);
1477: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1478: raise fnd_api.g_exc_unexpected_error;

Line 1530: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.createFlowSchedule',

1526: end if;
1527:
1528: if(l_flowRec.organization_id is null) then --org id column is not null in both MTI and MMTT
1529: if(l_logLevel <= wip_constants.trace_logging) then
1530: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.createFlowSchedule',
1531: p_procReturnStatus => x_returnStatus,
1532: p_msg => 'Flow schedule creation not necessary.',
1533: x_returnStatus => l_returnStatus); --discard logging return status
1534: end if;

Line 1773: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.createFlowSchedule',

1769: x_returnStatus => l_returnStatus);
1770: end if;
1771:
1772: if (l_logLevel <= wip_constants.trace_logging) then
1773: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.createFlowSchedule',
1774: p_procReturnStatus => x_returnStatus,
1775: p_msg => 'Flow schedules created successfully!',
1776: x_returnStatus => l_returnStatus); --discard logging return status
1777: end if;

Line 1782: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.createFlowSchedule',

1778: exception
1779: when others then
1780: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1781: if (l_logLevel <= wip_constants.trace_logging) then
1782: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.createFlowSchedule',
1783: p_procReturnStatus => x_returnStatus,
1784: p_msg => 'unexpected error: ' || SQLERRM,
1785: x_returnStatus => l_returnStatus); --discard logging return status
1786: end if;

Line 1817: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.updateFlowSchedule',

1813:
1814: if (l_logLevel <= wip_constants.trace_logging) then
1815: l_params(1).paramName := 'p_txnTempID';
1816: l_params(1).paramValue := p_txnTempID;
1817: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.updateFlowSchedule',
1818: p_params => l_params,
1819: x_returnStatus => x_returnStatus);
1820: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1821: raise fnd_api.g_exc_unexpected_error;

Line 1896: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.updateFlowSchedule',

1892: status)
1893: where wip_entity_id = l_wipEntityID;
1894:
1895: if (l_logLevel <= wip_constants.trace_logging) then
1896: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.updateFlowSchedule',
1897: p_procReturnStatus => x_returnStatus,
1898: p_msg => 'Flow schedules updated successfully!',
1899: x_returnStatus => l_returnStatus); --discard logging return status
1900: end if;

Line 1905: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.updateFlowSchedule',

1901: exception
1902: when others then
1903: x_returnStatus := fnd_api.g_ret_sts_error;
1904: if (l_logLevel <= wip_constants.trace_logging) then
1905: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.updateFlowSchedule',
1906: p_procReturnStatus => x_returnStatus,
1907: p_msg => 'unexpected error: ' || SQLERRM,
1908: x_returnStatus => l_returnStatus); --discard logging return status
1909: end if;

Line 2305: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.explodeRequirementsToMMTT',

2301: l_params(10).paramName := 'p_toOpSeqNum';
2302: l_params(10).paramValue := p_toOpSeqNum;
2303: l_params(11).paramName := 'p_altRoutDesig';
2304: l_params(11).paramValue := p_altRoutDesig;
2305: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.explodeRequirementsToMMTT',
2306: p_params => l_params,
2307: x_returnStatus => x_returnStatus);
2308: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2309: raise fnd_api.g_exc_unexpected_error;

Line 2446: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.explodeRequirementsToMMTT',

2442: end loop;
2443:
2444: l_compTbl.delete;
2445: if (l_logLevel <= wip_constants.trace_logging) then
2446: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.explodeRequirementsToMMTT',
2447: p_procReturnStatus => x_returnStatus,
2448: p_msg => 'Exploded BOM to MMTT successfully!',
2449: x_returnStatus => l_returnStatus); --discard logging return status
2450: end if;

Line 2455: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.explodeRequirementsToMMTT',

2451: exception
2452: when others then
2453: x_returnStatus := fnd_api.g_ret_sts_error;
2454: if (l_logLevel <= wip_constants.trace_logging) then
2455: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.explodeRequirementsToMMTT',
2456: p_procReturnStatus => x_returnStatus,
2457: p_msg => 'unexpected error: ' || SQLERRM,
2458: x_returnStatus => l_returnStatus); --discard logging return status
2459: end if;

Line 2692: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.generateCompLocator',

2688: begin
2689: if (l_logLevel <= wip_constants.trace_logging) then
2690: l_params(1).paramName := 'p_parentID';
2691: l_params(1).paramValue := p_parentID;
2692: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.generateCompLocator',
2693: p_params => l_params,
2694: x_returnStatus => x_returnStatus);
2695: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2696: raise fnd_api.g_exc_unexpected_error;

Line 2722: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.generateCompLocator',

2718: where organization_id = l_orgID;
2719:
2720: if ( (l_srcProjectID is null) or (l_projRefEnabled <> 1) ) then
2721: if (l_logLevel <= wip_constants.trace_logging) then
2722: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.generateCompLocator',
2723: p_procReturnStatus => x_returnStatus,
2724: p_msg => 'Source project id is null or the org parameter ' ||
2725: 'does not has project reference enabled',
2726: x_returnStatus => l_returnStatus); --discard logging return status

Line 2744: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.generateCompLocator',

2740: p_org_loc_control => l_orgLocControl);
2741: if ( l_success = false ) then
2742: x_returnStatus := fnd_api.g_ret_sts_error;
2743: if (l_logLevel <= wip_constants.trace_logging) then
2744: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.generateCompLocator',
2745: p_procReturnStatus => x_returnStatus,
2746: p_msg => 'Error in calling '||
2747: 'pjm_project_locator.get_component_projectsupply!',
2748: x_returnStatus => l_returnStatus); --discard logging return status

Line 2767: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.generateCompLocator',

2763: end if;
2764: end loop;
2765:
2766: if (l_logLevel <= wip_constants.trace_logging) then
2767: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.generateCompLocator',
2768: p_procReturnStatus => x_returnStatus,
2769: p_msg => 'Finished!',
2770: x_returnStatus => l_returnStatus); --discard logging return status
2771: end if;

Line 2774: end wip_flowUtil_priv;

2770: x_returnStatus => l_returnStatus); --discard logging return status
2771: end if;
2772: end generateCompLocator;
2773:
2774: end wip_flowUtil_priv;