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_LOGGER

Line 90: l_params wip_logger.param_tbl_t;

86: WIP_CONSTANTS.RETASSY_ACTION);
87: l_returnStatus varchar2(1);
88: l_validationException exception;
89:
90: l_params wip_logger.param_tbl_t;
91:
92: l_fromUI NUMBER;--> 0 if the record originated from oracle user interfaces
93:
94: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);

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 330: wip_logger.log(p_msg => 'Error defaulting/validating interface ' ||

326: end if;
327: exception
328: when l_validationException then
329: if (l_logLevel <= wip_constants.full_logging) then
330: wip_logger.log(p_msg => 'Error defaulting/validating interface ' ||
331: to_char(flow_rec.transaction_interface_id) || ':' || l_errMsg,
332: x_returnStatus => l_returnStatus);
333: end if;
334: -- skip this one, validate next record. pl/sql doesn't have continue;

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 716: l_params wip_logger.param_tbl_t;

712:
713: l_insert varchar2(1) ; /*BUG 6134576*/
714: l_service_item_flag varchar2(1) ; /*BUG 6134576*/
715:
716: l_params wip_logger.param_tbl_t;
717: l_returnStatus varchar2(1);
718: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
719: l_errMsg VARCHAR2(2000);
720:

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 973: wip_logger.log(p_msg => 'Insert item ' || l_compTbl(l_count).inventory_item_id ||

969: p_projectID,
970: p_taskID);
971:
972: if (l_logLevel <= wip_constants.full_logging) then
973: wip_logger.log(p_msg => 'Insert item ' || l_compTbl(l_count).inventory_item_id ||
974: ' under op ' || l_compTbl(l_count).operation_seq_num,
975: x_returnStatus => l_returnStatus);
976: end if;
977: end if;

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 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 1438: l_params wip_logger.param_tbl_t;

1434: l_stdCostAdjustmentAccount number;
1435: l_overheadAccount number;
1436: l_overheadVarianceAccount number ;
1437:
1438: l_params wip_logger.param_tbl_t;
1439: l_returnStatus varchar2(1);
1440: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1441:
1442: l_prjID NUMBER;

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 1491: wip_logger.log('MTI rowcount is ' || l_count, l_returnStatus);

1487: select count(*)
1488: into l_count
1489: from mtl_transactions_interface
1490: where transaction_interface_id = p_txnInterfaceID;
1491: wip_logger.log('MTI rowcount is ' || l_count, l_returnStatus);
1492:
1493: for l_paramRec in c_MTIparams loop
1494: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);
1495: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);

Line 1494: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);

1490: where transaction_interface_id = p_txnInterfaceID;
1491: wip_logger.log('MTI rowcount is ' || l_count, l_returnStatus);
1492:
1493: for l_paramRec in c_MTIparams loop
1494: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);
1495: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);
1496: wip_logger.log('transaction_action_id:' || l_paramRec.transaction_action_id, l_returnStatus);
1497: wip_logger.log('scheduled_flag:' || l_paramRec.scheduled_flag, l_returnStatus);
1498: wip_logger.log('process_flag:' || l_paramRec.process_flag, l_returnStatus);

Line 1495: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);

1491: wip_logger.log('MTI rowcount is ' || l_count, l_returnStatus);
1492:
1493: for l_paramRec in c_MTIparams loop
1494: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);
1495: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);
1496: wip_logger.log('transaction_action_id:' || l_paramRec.transaction_action_id, l_returnStatus);
1497: wip_logger.log('scheduled_flag:' || l_paramRec.scheduled_flag, l_returnStatus);
1498: wip_logger.log('process_flag:' || l_paramRec.process_flag, l_returnStatus);
1499: end loop;

Line 1496: wip_logger.log('transaction_action_id:' || l_paramRec.transaction_action_id, l_returnStatus);

1492:
1493: for l_paramRec in c_MTIparams loop
1494: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);
1495: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);
1496: wip_logger.log('transaction_action_id:' || l_paramRec.transaction_action_id, l_returnStatus);
1497: wip_logger.log('scheduled_flag:' || l_paramRec.scheduled_flag, l_returnStatus);
1498: wip_logger.log('process_flag:' || l_paramRec.process_flag, l_returnStatus);
1499: end loop;
1500: else

Line 1497: wip_logger.log('scheduled_flag:' || l_paramRec.scheduled_flag, l_returnStatus);

1493: for l_paramRec in c_MTIparams loop
1494: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);
1495: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);
1496: wip_logger.log('transaction_action_id:' || l_paramRec.transaction_action_id, l_returnStatus);
1497: wip_logger.log('scheduled_flag:' || l_paramRec.scheduled_flag, l_returnStatus);
1498: wip_logger.log('process_flag:' || l_paramRec.process_flag, l_returnStatus);
1499: end loop;
1500: else
1501: select count(*)

Line 1498: wip_logger.log('process_flag:' || l_paramRec.process_flag, l_returnStatus);

1494: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);
1495: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);
1496: wip_logger.log('transaction_action_id:' || l_paramRec.transaction_action_id, l_returnStatus);
1497: wip_logger.log('scheduled_flag:' || l_paramRec.scheduled_flag, l_returnStatus);
1498: wip_logger.log('process_flag:' || l_paramRec.process_flag, l_returnStatus);
1499: end loop;
1500: else
1501: select count(*)
1502: into l_count

Line 1505: wip_logger.log('MMTT rowcount is ' || l_count, l_returnStatus);

1501: select count(*)
1502: into l_count
1503: from mtl_material_transactions_temp
1504: where transaction_temp_id = p_txnTmpID;
1505: wip_logger.log('MMTT rowcount is ' || l_count, l_returnStatus);
1506:
1507: for l_paramRec in c_MMTTparams loop
1508: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);
1509: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);

Line 1508: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);

1504: where transaction_temp_id = p_txnTmpID;
1505: wip_logger.log('MMTT rowcount is ' || l_count, l_returnStatus);
1506:
1507: for l_paramRec in c_MMTTparams loop
1508: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);
1509: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);
1510: wip_logger.log('transaction_action_id:' || l_paramRec.transaction_action_id, l_returnStatus);
1511: wip_logger.log('scheduled_flag:' || l_paramRec.scheduled_flag, l_returnStatus);
1512: wip_logger.log('process_flag:' || l_paramRec.process_flag, l_returnStatus);

Line 1509: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);

1505: wip_logger.log('MMTT rowcount is ' || l_count, l_returnStatus);
1506:
1507: for l_paramRec in c_MMTTparams loop
1508: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);
1509: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);
1510: wip_logger.log('transaction_action_id:' || l_paramRec.transaction_action_id, l_returnStatus);
1511: wip_logger.log('scheduled_flag:' || l_paramRec.scheduled_flag, l_returnStatus);
1512: wip_logger.log('process_flag:' || l_paramRec.process_flag, l_returnStatus);
1513: end loop;

Line 1510: wip_logger.log('transaction_action_id:' || l_paramRec.transaction_action_id, l_returnStatus);

1506:
1507: for l_paramRec in c_MMTTparams loop
1508: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);
1509: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);
1510: wip_logger.log('transaction_action_id:' || l_paramRec.transaction_action_id, l_returnStatus);
1511: wip_logger.log('scheduled_flag:' || l_paramRec.scheduled_flag, l_returnStatus);
1512: wip_logger.log('process_flag:' || l_paramRec.process_flag, l_returnStatus);
1513: end loop;
1514: end if;

Line 1511: wip_logger.log('scheduled_flag:' || l_paramRec.scheduled_flag, l_returnStatus);

1507: for l_paramRec in c_MMTTparams loop
1508: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);
1509: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);
1510: wip_logger.log('transaction_action_id:' || l_paramRec.transaction_action_id, l_returnStatus);
1511: wip_logger.log('scheduled_flag:' || l_paramRec.scheduled_flag, l_returnStatus);
1512: wip_logger.log('process_flag:' || l_paramRec.process_flag, l_returnStatus);
1513: end loop;
1514: end if;
1515: end;

Line 1512: wip_logger.log('process_flag:' || l_paramRec.process_flag, l_returnStatus);

1508: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);
1509: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);
1510: wip_logger.log('transaction_action_id:' || l_paramRec.transaction_action_id, l_returnStatus);
1511: wip_logger.log('scheduled_flag:' || l_paramRec.scheduled_flag, l_returnStatus);
1512: wip_logger.log('process_flag:' || l_paramRec.process_flag, l_returnStatus);
1513: end loop;
1514: end if;
1515: end;
1516: end if;

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 1718: wip_logger.log(p_msg => 'wip entity id: ' || x_wipEntityID,

1714:
1715: x_wipEntityID := l_wipEntityID;
1716:
1717: if (l_logLevel <= wip_constants.full_logging) then
1718: wip_logger.log(p_msg => 'wip entity id: ' || x_wipEntityID,
1719: x_returnStatus => l_returnStatus);
1720: wip_logger.log(p_msg => 'src prjID: ' || l_flowRec.source_project_id,
1721: x_returnStatus => l_returnStatus);
1722: wip_logger.log(p_msg => 'projID: ' || l_flowRec.project_id,

Line 1720: wip_logger.log(p_msg => 'src prjID: ' || l_flowRec.source_project_id,

1716:
1717: if (l_logLevel <= wip_constants.full_logging) then
1718: wip_logger.log(p_msg => 'wip entity id: ' || x_wipEntityID,
1719: x_returnStatus => l_returnStatus);
1720: wip_logger.log(p_msg => 'src prjID: ' || l_flowRec.source_project_id,
1721: x_returnStatus => l_returnStatus);
1722: wip_logger.log(p_msg => 'projID: ' || l_flowRec.project_id,
1723: x_returnStatus => l_returnStatus);
1724: wip_logger.log(p_msg => 'prjID: ' || l_prjID,

Line 1722: wip_logger.log(p_msg => 'projID: ' || l_flowRec.project_id,

1718: wip_logger.log(p_msg => 'wip entity id: ' || x_wipEntityID,
1719: x_returnStatus => l_returnStatus);
1720: wip_logger.log(p_msg => 'src prjID: ' || l_flowRec.source_project_id,
1721: x_returnStatus => l_returnStatus);
1722: wip_logger.log(p_msg => 'projID: ' || l_flowRec.project_id,
1723: x_returnStatus => l_returnStatus);
1724: wip_logger.log(p_msg => 'prjID: ' || l_prjID,
1725: x_returnStatus => l_returnStatus);
1726: wip_logger.log(p_msg => 'tskID:' || l_tskID,

Line 1724: wip_logger.log(p_msg => 'prjID: ' || l_prjID,

1720: wip_logger.log(p_msg => 'src prjID: ' || l_flowRec.source_project_id,
1721: x_returnStatus => l_returnStatus);
1722: wip_logger.log(p_msg => 'projID: ' || l_flowRec.project_id,
1723: x_returnStatus => l_returnStatus);
1724: wip_logger.log(p_msg => 'prjID: ' || l_prjID,
1725: x_returnStatus => l_returnStatus);
1726: wip_logger.log(p_msg => 'tskID:' || l_tskID,
1727: x_returnStatus => l_returnStatus);
1728: wip_logger.log(p_msg => 'Flow schedule ' || l_wipEntityID || ' was created!',

Line 1726: wip_logger.log(p_msg => 'tskID:' || l_tskID,

1722: wip_logger.log(p_msg => 'projID: ' || l_flowRec.project_id,
1723: x_returnStatus => l_returnStatus);
1724: wip_logger.log(p_msg => 'prjID: ' || l_prjID,
1725: x_returnStatus => l_returnStatus);
1726: wip_logger.log(p_msg => 'tskID:' || l_tskID,
1727: x_returnStatus => l_returnStatus);
1728: wip_logger.log(p_msg => 'Flow schedule ' || l_wipEntityID || ' was created!',
1729: x_returnStatus => l_returnStatus);
1730: end if;

Line 1728: wip_logger.log(p_msg => 'Flow schedule ' || l_wipEntityID || ' was created!',

1724: wip_logger.log(p_msg => 'prjID: ' || l_prjID,
1725: x_returnStatus => l_returnStatus);
1726: wip_logger.log(p_msg => 'tskID:' || l_tskID,
1727: x_returnStatus => l_returnStatus);
1728: wip_logger.log(p_msg => 'Flow schedule ' || l_wipEntityID || ' was created!',
1729: x_returnStatus => l_returnStatus);
1730: end if;
1731:
1732: -- set the transaction_source_id for the assembly record (if from MTI)

Line 1748: wip_logger.log(p_msg => SQL%ROWCOUNT || 'MTI rows updated!',

1744: where transaction_header_id = l_flowRec.transaction_header_id
1745: and completion_transaction_id = l_flowRec.completion_transaction_id;
1746:
1747: if (l_logLevel <= wip_constants.full_logging) then
1748: wip_logger.log(p_msg => SQL%ROWCOUNT || 'MTI rows updated!',
1749: x_returnStatus => l_returnStatus);
1750: end if;
1751:
1752: --if txn originated from MMTT, update the assy record

Line 1768: wip_logger.log(p_msg => SQL%ROWCOUNT || 'MMTT rows updated!',

1764: where transaction_temp_id = p_txnTmpID;
1765: end if;
1766:
1767: if (l_logLevel <= wip_constants.full_logging) then
1768: wip_logger.log(p_msg => SQL%ROWCOUNT || 'MMTT rows updated!',
1769: x_returnStatus => l_returnStatus);
1770: end if;
1771:
1772: if (l_logLevel <= wip_constants.trace_logging) then

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 1809: l_params wip_logger.param_tbl_t;

1805: l_completedQty number;
1806: l_plannedQty number;
1807: l_newCompletedQty number;
1808:
1809: l_params wip_logger.param_tbl_t;
1810: l_returnStatus varchar2(1);
1811: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1812: begin
1813:

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 2014: wip_logger.log(p_msg => x_compTbl.count || ' components exploded!',

2010: return;
2011: end if;
2012:
2013: if (l_logLevel <= wip_constants.full_logging) then
2014: wip_logger.log(p_msg => x_compTbl.count || ' components exploded!',
2015: x_returnStatus => l_returnStatus);
2016: end if;
2017:
2018: -- get the routing type

Line 2060: wip_logger.log(p_msg => 'Qty too small, component ' ||

2056: if (round(abs(x_compTbl(l_count).primary_quantity),
2057: WIP_CONSTANTS.INV_MAX_PRECISION) = 0) then
2058: if(p_txnFlag) then
2059: if (l_logLevel <= wip_constants.full_logging) then
2060: wip_logger.log(p_msg => 'Qty too small, component ' ||
2061: x_compTbl(l_count).inventory_item_id || ' stripped!',
2062: x_returnStatus => l_returnStatus);
2063: end if;
2064: x_compTbl.delete(l_count);

Line 2082: wip_logger.log(p_msg => 'Op ' || x_compTbl(l_count).operation_seq_num ||

2078: elsif ( l_cfmRouting <> 1 ) then
2079: if ( x_compTbl(l_count).operation_seq_num > p_toOpSeqNum ) then
2080: -- delete the comp that has op seq greater than to op seq num
2081: if (l_logLevel <= wip_constants.full_logging) then
2082: wip_logger.log(p_msg => 'Op ' || x_compTbl(l_count).operation_seq_num ||
2083: ' after terminal op, item ' ||
2084: x_compTbl(l_count).inventory_item_id || ' stripped!',
2085: x_returnStatus => l_returnStatus);
2086: end if;

Line 2112: wip_logger.log(p_msg => 'Event ' || x_compTbl(l_count).operation_seq_num ||

2108: l_lineOpTbl) ) then
2109: l_checkPass := true;
2110: else
2111: if (l_logLevel <= wip_constants.full_logging) then
2112: wip_logger.log(p_msg => 'Event ' || x_compTbl(l_count).operation_seq_num ||
2113: ' belongs to line op that after terminal op, item ' ||
2114: x_compTbl(l_count).inventory_item_id || ' stripped!',
2115: x_returnStatus => l_returnStatus);
2116: end if;

Line 2131: wip_logger.log(p_msg => 'Nonrelated supply type item ' ||

2127: -- type components should be exploded for discrete jobs.
2128: if ( l_checkPass and p_txnFlag and
2129: nvl(x_compTbl(l_count).wip_supply_type, 1) not in (1, 2, 3, 6) ) then
2130: if (l_logLevel <= wip_constants.full_logging) then
2131: wip_logger.log(p_msg => 'Nonrelated supply type item ' ||
2132: x_compTbl(l_count).inventory_item_id ||
2133: ' at op ' || x_compTbl(l_count).operation_seq_num ||
2134: ' stripped!',
2135: x_returnStatus => l_returnStatus);

Line 2166: wip_logger.log(p_msg => 'Item ' || x_compTbl(l_count).inventory_item_id ||

2162: fnd_message.set_name('WIP', 'WIP_COMP_NOT_TRANSACTABLE');
2163: fnd_message.set_token('ENTITY1', x_compTbl(l_count).item_name);
2164: fnd_msg_pub.add;
2165: if (l_logLevel <= wip_constants.full_logging) then
2166: wip_logger.log(p_msg => 'Item ' || x_compTbl(l_count).inventory_item_id ||
2167: ' not transactable, failed explosion!',
2168: x_returnStatus => l_returnStatus);
2169: end if;
2170: x_compTbl.delete;

Line 2277: l_params wip_logger.param_tbl_t;

2273: l_insertPhantom number;
2274: l_acctPeriodID number;
2275: l_openPastPeriod boolean := false;
2276:
2277: l_params wip_logger.param_tbl_t;
2278: l_returnStatus varchar2(1);
2279: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2280: begin
2281:

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 2435: wip_logger.log(p_msg => 'Insert item ' || l_compTbl(l_count).inventory_item_id ||

2431: from mtl_material_transactions_temp mmtt
2432: where mmtt.transaction_temp_id = p_txnTempID;
2433:
2434: if (l_logLevel <= wip_constants.full_logging) then
2435: wip_logger.log(p_msg => 'Insert item ' || l_compTbl(l_count).inventory_item_id ||
2436: ' under op ' || l_compTbl(l_count).operation_seq_num,
2437: x_returnStatus => l_returnStatus);
2438: end if;
2439: end if;

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 2676: l_params wip_logger.param_tbl_t;

2672: WIP_CONSTANTS.ISSNEGC_ACTION,
2673: WIP_CONSTANTS.RETNEGC_ACTION)
2674: order by operation_seq_num;
2675:
2676: l_params wip_logger.param_tbl_t;
2677: l_returnStatus varchar2(1);
2678: l_success boolean;
2679:
2680: l_orgID number;

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;