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.27 2011/01/25 01:04:53 pding 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 370: wip_logger.exitPoint(p_procName => 'wip_flowutil_priv.processFlowInterfaceRecords',

366: end;
367: end loop;
368:
369: if (l_logLevel <= wip_constants.trace_logging) then
370: wip_logger.exitPoint(p_procName => 'wip_flowutil_priv.processFlowInterfaceRecords',
371: p_procReturnStatus => fnd_api.g_ret_sts_success,
372: p_msg => 'Finished processFlowInterfaceRecords',
373: x_returnStatus => l_returnStatus); --discard logging return status
374: end if;

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

812: l_params(20).paramName := 'p_txnBatchSeq';
813: l_params(20).paramValue := p_txnBatchSeq;
814: l_params(20).paramName := 'p_defaultPushSubinv';
815: l_params(20).paramValue := p_defaultPushSubinv;
816: wip_logger.entryPoint(p_procName => 'wip_flowutil_priv.explodeRequirementsToMTI',
817: p_params => l_params,
818: x_returnStatus => x_returnStatus);
819: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
820: raise fnd_api.g_exc_unexpected_error;

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

1011: l_count := l_compTbl.next(l_count);
1012: end loop;
1013:
1014: if (l_logLevel <= wip_constants.trace_logging) then
1015: wip_logger.exitPoint(p_procName => 'wip_flowutil_priv.explodeRequirementsToMTI',
1016: p_procReturnStatus => x_returnStatus,
1017: p_msg => 'Explode BOM to MTI successfully for interface ' ||
1018: to_char(p_parentID) || ' successfully!',
1019: x_returnStatus => l_returnStatus); --discard logging return status

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

1025: wip_utilities.get_message_stack(p_msg => l_errMsg,
1026: p_delete_stack => fnd_api.g_false);
1027:
1028: if (l_logLevel <= wip_constants.trace_logging) then
1029: wip_logger.exitPoint(p_procName => 'wip_flowutil_priv.explodeRequirementsToMTI',
1030: p_procReturnStatus => x_returnStatus,
1031: p_msg => 'explosion error: ' || l_errMsg || ' for exploding interface '
1032: || to_char(p_parentID),
1033: x_returnStatus => l_returnStatus); --discard logging return status

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

1042: when others then
1043: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1044: if (l_logLevel <= wip_constants.trace_logging) then
1045:
1046: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_flowutil_priv',
1047: p_procedure_name => 'explodeRequirementsToMTI',
1048: p_error_text => SQLERRM);
1049:
1050: wip_logger.exitPoint(p_procName => 'wip_flowutil_priv.explodeRequirementsToMTI',

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

1046: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_flowutil_priv',
1047: p_procedure_name => 'explodeRequirementsToMTI',
1048: p_error_text => SQLERRM);
1049:
1050: wip_logger.exitPoint(p_procName => 'wip_flowutil_priv.explodeRequirementsToMTI',
1051: p_procReturnStatus => x_returnStatus,
1052: p_msg => 'unexpected error: ' || l_errMsg || ' for exploding interface '
1053: || to_char(p_parentID),
1054: x_returnStatus => l_returnStatus); --discard logging return status

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

1501:
1502: if (l_logLevel <= wip_constants.trace_logging) then
1503: l_params(1).paramName := 'p_txnInterfaceID';
1504: l_params(1).paramValue := p_txnInterfaceID;
1505: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.createFlowSchedule',
1506: p_params => l_params,
1507: x_returnStatus => x_returnStatus);
1508: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1509: raise fnd_api.g_exc_unexpected_error;

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

1557: end if;
1558:
1559: if(l_flowRec.organization_id is null) then --org id column is not null in both MTI and MMTT
1560: if(l_logLevel <= wip_constants.trace_logging) then
1561: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.createFlowSchedule',
1562: p_procReturnStatus => x_returnStatus,
1563: p_msg => 'Flow schedule creation not necessary.',
1564: x_returnStatus => l_returnStatus); --discard logging return status
1565: end if;

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

1800: x_returnStatus => l_returnStatus);
1801: end if;
1802:
1803: if (l_logLevel <= wip_constants.trace_logging) then
1804: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.createFlowSchedule',
1805: p_procReturnStatus => x_returnStatus,
1806: p_msg => 'Flow schedules created successfully!',
1807: x_returnStatus => l_returnStatus); --discard logging return status
1808: end if;

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

1809: exception
1810: when others then
1811: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1812: if (l_logLevel <= wip_constants.trace_logging) then
1813: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.createFlowSchedule',
1814: p_procReturnStatus => x_returnStatus,
1815: p_msg => 'unexpected error: ' || SQLERRM,
1816: x_returnStatus => l_returnStatus); --discard logging return status
1817: end if;

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

1844:
1845: if (l_logLevel <= wip_constants.trace_logging) then
1846: l_params(1).paramName := 'p_txnTempID';
1847: l_params(1).paramValue := p_txnTempID;
1848: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.updateFlowSchedule',
1849: p_params => l_params,
1850: x_returnStatus => x_returnStatus);
1851: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1852: raise fnd_api.g_exc_unexpected_error;

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

1925: last_update_date = sysdate
1926: where wip_entity_id = l_wipEntityID;
1927:
1928: if (l_logLevel <= wip_constants.trace_logging) then
1929: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.updateFlowSchedule',
1930: p_procReturnStatus => x_returnStatus,
1931: p_msg => 'Flow schedules updated successfully!',
1932: x_returnStatus => l_returnStatus); --discard logging return status
1933: end if;

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

1934: exception
1935: when others then
1936: x_returnStatus := fnd_api.g_ret_sts_error;
1937: if (l_logLevel <= wip_constants.trace_logging) then
1938: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.updateFlowSchedule',
1939: p_procReturnStatus => x_returnStatus,
1940: p_msg => 'unexpected error: ' || SQLERRM,
1941: x_returnStatus => l_returnStatus); --discard logging return status
1942: end if;

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

2340: l_params(10).paramName := 'p_toOpSeqNum';
2341: l_params(10).paramValue := p_toOpSeqNum;
2342: l_params(11).paramName := 'p_altRoutDesig';
2343: l_params(11).paramValue := p_altRoutDesig;
2344: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.explodeRequirementsToMMTT',
2345: p_params => l_params,
2346: x_returnStatus => x_returnStatus);
2347: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2348: raise fnd_api.g_exc_unexpected_error;

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

2481: end loop;
2482:
2483: l_compTbl.delete;
2484: if (l_logLevel <= wip_constants.trace_logging) then
2485: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.explodeRequirementsToMMTT',
2486: p_procReturnStatus => x_returnStatus,
2487: p_msg => 'Exploded BOM to MMTT successfully!',
2488: x_returnStatus => l_returnStatus); --discard logging return status
2489: end if;

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

2490: exception
2491: when others then
2492: x_returnStatus := fnd_api.g_ret_sts_error;
2493: if (l_logLevel <= wip_constants.trace_logging) then
2494: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.explodeRequirementsToMMTT',
2495: p_procReturnStatus => x_returnStatus,
2496: p_msg => 'unexpected error: ' || SQLERRM,
2497: x_returnStatus => l_returnStatus); --discard logging return status
2498: end if;

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

2727: begin
2728: if (l_logLevel <= wip_constants.trace_logging) then
2729: l_params(1).paramName := 'p_parentID';
2730: l_params(1).paramValue := p_parentID;
2731: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.generateCompLocator',
2732: p_params => l_params,
2733: x_returnStatus => x_returnStatus);
2734: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2735: raise fnd_api.g_exc_unexpected_error;

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

2757: where organization_id = l_orgID;
2758:
2759: if ( (l_srcProjectID is null) or (l_projRefEnabled <> 1) ) then
2760: if (l_logLevel <= wip_constants.trace_logging) then
2761: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.generateCompLocator',
2762: p_procReturnStatus => x_returnStatus,
2763: p_msg => 'Source project id is null or the org parameter ' ||
2764: 'does not has project reference enabled',
2765: x_returnStatus => l_returnStatus); --discard logging return status

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

2779: p_org_loc_control => l_orgLocControl);
2780: if ( l_success = false ) then
2781: x_returnStatus := fnd_api.g_ret_sts_error;
2782: if (l_logLevel <= wip_constants.trace_logging) then
2783: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.generateCompLocator',
2784: p_procReturnStatus => x_returnStatus,
2785: p_msg => 'Error in calling '||
2786: 'pjm_project_locator.get_component_projectsupply!',
2787: x_returnStatus => l_returnStatus); --discard logging return status

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

2802: end if;
2803: end loop;
2804:
2805: if (l_logLevel <= wip_constants.trace_logging) then
2806: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.generateCompLocator',
2807: p_procReturnStatus => x_returnStatus,
2808: p_msg => 'Finished!',
2809: x_returnStatus => l_returnStatus); --discard logging return status
2810: end if;

Line 2813: end wip_flowUtil_priv;

2809: x_returnStatus => l_returnStatus); --discard logging return status
2810: end if;
2811: end generateCompLocator;
2812:
2813: end wip_flowUtil_priv;