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

357: end if;
358: exception
359: when l_validationException then
360: if (l_logLevel <= wip_constants.full_logging) then
361: wip_logger.log(p_msg => 'Error defaulting/validating interface ' ||
362: to_char(flow_rec.transaction_interface_id) || ':' || l_errMsg,
363: x_returnStatus => l_returnStatus);
364: end if;
365: -- skip this one, validate next record. pl/sql doesn't have continue;

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

743:
744: l_insert varchar2(1) ; /*BUG 6134576*/
745: l_service_item_flag varchar2(1) ; /*BUG 6134576*/
746:
747: l_params wip_logger.param_tbl_t;
748: l_returnStatus varchar2(1);
749: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
750: l_errMsg VARCHAR2(2000);
751:

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

1000: p_projectID,
1001: p_taskID);
1002:
1003: if (l_logLevel <= wip_constants.full_logging) then
1004: wip_logger.log(p_msg => 'Insert item ' || l_compTbl(l_count).inventory_item_id ||
1005: ' under op ' || l_compTbl(l_count).operation_seq_num,
1006: x_returnStatus => l_returnStatus);
1007: end if;
1008: end if;

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

1465: l_stdCostAdjustmentAccount number;
1466: l_overheadAccount number;
1467: l_overheadVarianceAccount number ;
1468:
1469: l_params wip_logger.param_tbl_t;
1470: l_returnStatus varchar2(1);
1471: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1472:
1473: l_prjID NUMBER;

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

1518: select count(*)
1519: into l_count
1520: from mtl_transactions_interface
1521: where transaction_interface_id = p_txnInterfaceID;
1522: wip_logger.log('MTI rowcount is ' || l_count, l_returnStatus);
1523:
1524: for l_paramRec in c_MTIparams loop
1525: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);
1526: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);

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

1521: where transaction_interface_id = p_txnInterfaceID;
1522: wip_logger.log('MTI rowcount is ' || l_count, l_returnStatus);
1523:
1524: for l_paramRec in c_MTIparams loop
1525: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);
1526: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);
1527: wip_logger.log('transaction_action_id:' || l_paramRec.transaction_action_id, l_returnStatus);
1528: wip_logger.log('scheduled_flag:' || l_paramRec.scheduled_flag, l_returnStatus);
1529: wip_logger.log('process_flag:' || l_paramRec.process_flag, l_returnStatus);

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

1522: wip_logger.log('MTI rowcount is ' || l_count, l_returnStatus);
1523:
1524: for l_paramRec in c_MTIparams loop
1525: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);
1526: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);
1527: wip_logger.log('transaction_action_id:' || l_paramRec.transaction_action_id, l_returnStatus);
1528: wip_logger.log('scheduled_flag:' || l_paramRec.scheduled_flag, l_returnStatus);
1529: wip_logger.log('process_flag:' || l_paramRec.process_flag, l_returnStatus);
1530: end loop;

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

1523:
1524: for l_paramRec in c_MTIparams loop
1525: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);
1526: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);
1527: wip_logger.log('transaction_action_id:' || l_paramRec.transaction_action_id, l_returnStatus);
1528: wip_logger.log('scheduled_flag:' || l_paramRec.scheduled_flag, l_returnStatus);
1529: wip_logger.log('process_flag:' || l_paramRec.process_flag, l_returnStatus);
1530: end loop;
1531: else

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

1524: for l_paramRec in c_MTIparams loop
1525: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);
1526: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);
1527: wip_logger.log('transaction_action_id:' || l_paramRec.transaction_action_id, l_returnStatus);
1528: wip_logger.log('scheduled_flag:' || l_paramRec.scheduled_flag, l_returnStatus);
1529: wip_logger.log('process_flag:' || l_paramRec.process_flag, l_returnStatus);
1530: end loop;
1531: else
1532: select count(*)

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

1525: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);
1526: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);
1527: wip_logger.log('transaction_action_id:' || l_paramRec.transaction_action_id, l_returnStatus);
1528: wip_logger.log('scheduled_flag:' || l_paramRec.scheduled_flag, l_returnStatus);
1529: wip_logger.log('process_flag:' || l_paramRec.process_flag, l_returnStatus);
1530: end loop;
1531: else
1532: select count(*)
1533: into l_count

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

1532: select count(*)
1533: into l_count
1534: from mtl_material_transactions_temp
1535: where transaction_temp_id = p_txnTmpID;
1536: wip_logger.log('MMTT rowcount is ' || l_count, l_returnStatus);
1537:
1538: for l_paramRec in c_MMTTparams loop
1539: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);
1540: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);

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

1535: where transaction_temp_id = p_txnTmpID;
1536: wip_logger.log('MMTT rowcount is ' || l_count, l_returnStatus);
1537:
1538: for l_paramRec in c_MMTTparams loop
1539: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);
1540: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);
1541: wip_logger.log('transaction_action_id:' || l_paramRec.transaction_action_id, l_returnStatus);
1542: wip_logger.log('scheduled_flag:' || l_paramRec.scheduled_flag, l_returnStatus);
1543: wip_logger.log('process_flag:' || l_paramRec.process_flag, l_returnStatus);

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

1536: wip_logger.log('MMTT rowcount is ' || l_count, l_returnStatus);
1537:
1538: for l_paramRec in c_MMTTparams loop
1539: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);
1540: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);
1541: wip_logger.log('transaction_action_id:' || l_paramRec.transaction_action_id, l_returnStatus);
1542: wip_logger.log('scheduled_flag:' || l_paramRec.scheduled_flag, l_returnStatus);
1543: wip_logger.log('process_flag:' || l_paramRec.process_flag, l_returnStatus);
1544: end loop;

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

1537:
1538: for l_paramRec in c_MMTTparams loop
1539: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);
1540: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);
1541: wip_logger.log('transaction_action_id:' || l_paramRec.transaction_action_id, l_returnStatus);
1542: wip_logger.log('scheduled_flag:' || l_paramRec.scheduled_flag, l_returnStatus);
1543: wip_logger.log('process_flag:' || l_paramRec.process_flag, l_returnStatus);
1544: end loop;
1545: end if;

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

1538: for l_paramRec in c_MMTTparams loop
1539: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);
1540: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);
1541: wip_logger.log('transaction_action_id:' || l_paramRec.transaction_action_id, l_returnStatus);
1542: wip_logger.log('scheduled_flag:' || l_paramRec.scheduled_flag, l_returnStatus);
1543: wip_logger.log('process_flag:' || l_paramRec.process_flag, l_returnStatus);
1544: end loop;
1545: end if;
1546: end;

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

1539: wip_logger.log('transaction_source_id:' || l_paramRec.transaction_source_id, l_returnStatus);
1540: wip_logger.log('flow_schedule:' || l_paramRec.flow_schedule, l_returnStatus);
1541: wip_logger.log('transaction_action_id:' || l_paramRec.transaction_action_id, l_returnStatus);
1542: wip_logger.log('scheduled_flag:' || l_paramRec.scheduled_flag, l_returnStatus);
1543: wip_logger.log('process_flag:' || l_paramRec.process_flag, l_returnStatus);
1544: end loop;
1545: end if;
1546: end;
1547: end if;

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

1745:
1746: x_wipEntityID := l_wipEntityID;
1747:
1748: if (l_logLevel <= wip_constants.full_logging) then
1749: wip_logger.log(p_msg => 'wip entity id: ' || x_wipEntityID,
1750: x_returnStatus => l_returnStatus);
1751: wip_logger.log(p_msg => 'src prjID: ' || l_flowRec.source_project_id,
1752: x_returnStatus => l_returnStatus);
1753: wip_logger.log(p_msg => 'projID: ' || l_flowRec.project_id,

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

1747:
1748: if (l_logLevel <= wip_constants.full_logging) then
1749: wip_logger.log(p_msg => 'wip entity id: ' || x_wipEntityID,
1750: x_returnStatus => l_returnStatus);
1751: wip_logger.log(p_msg => 'src prjID: ' || l_flowRec.source_project_id,
1752: x_returnStatus => l_returnStatus);
1753: wip_logger.log(p_msg => 'projID: ' || l_flowRec.project_id,
1754: x_returnStatus => l_returnStatus);
1755: wip_logger.log(p_msg => 'prjID: ' || l_prjID,

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

1749: wip_logger.log(p_msg => 'wip entity id: ' || x_wipEntityID,
1750: x_returnStatus => l_returnStatus);
1751: wip_logger.log(p_msg => 'src prjID: ' || l_flowRec.source_project_id,
1752: x_returnStatus => l_returnStatus);
1753: wip_logger.log(p_msg => 'projID: ' || l_flowRec.project_id,
1754: x_returnStatus => l_returnStatus);
1755: wip_logger.log(p_msg => 'prjID: ' || l_prjID,
1756: x_returnStatus => l_returnStatus);
1757: wip_logger.log(p_msg => 'tskID:' || l_tskID,

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

1751: wip_logger.log(p_msg => 'src prjID: ' || l_flowRec.source_project_id,
1752: x_returnStatus => l_returnStatus);
1753: wip_logger.log(p_msg => 'projID: ' || l_flowRec.project_id,
1754: x_returnStatus => l_returnStatus);
1755: wip_logger.log(p_msg => 'prjID: ' || l_prjID,
1756: x_returnStatus => l_returnStatus);
1757: wip_logger.log(p_msg => 'tskID:' || l_tskID,
1758: x_returnStatus => l_returnStatus);
1759: wip_logger.log(p_msg => 'Flow schedule ' || l_wipEntityID || ' was created!',

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

1753: wip_logger.log(p_msg => 'projID: ' || l_flowRec.project_id,
1754: x_returnStatus => l_returnStatus);
1755: wip_logger.log(p_msg => 'prjID: ' || l_prjID,
1756: x_returnStatus => l_returnStatus);
1757: wip_logger.log(p_msg => 'tskID:' || l_tskID,
1758: x_returnStatus => l_returnStatus);
1759: wip_logger.log(p_msg => 'Flow schedule ' || l_wipEntityID || ' was created!',
1760: x_returnStatus => l_returnStatus);
1761: end if;

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

1755: wip_logger.log(p_msg => 'prjID: ' || l_prjID,
1756: x_returnStatus => l_returnStatus);
1757: wip_logger.log(p_msg => 'tskID:' || l_tskID,
1758: x_returnStatus => l_returnStatus);
1759: wip_logger.log(p_msg => 'Flow schedule ' || l_wipEntityID || ' was created!',
1760: x_returnStatus => l_returnStatus);
1761: end if;
1762:
1763: -- set the transaction_source_id for the assembly record (if from MTI)

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

1775: where transaction_header_id = l_flowRec.transaction_header_id
1776: and completion_transaction_id = l_flowRec.completion_transaction_id;
1777:
1778: if (l_logLevel <= wip_constants.full_logging) then
1779: wip_logger.log(p_msg => SQL%ROWCOUNT || 'MTI rows updated!',
1780: x_returnStatus => l_returnStatus);
1781: end if;
1782:
1783: --if txn originated from MMTT, update the assy record

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

1795: where transaction_temp_id = p_txnTmpID;
1796: end if;
1797:
1798: if (l_logLevel <= wip_constants.full_logging) then
1799: wip_logger.log(p_msg => SQL%ROWCOUNT || 'MMTT rows updated!',
1800: x_returnStatus => l_returnStatus);
1801: end if;
1802:
1803: if (l_logLevel <= wip_constants.trace_logging) then

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

1836: l_completedQty number;
1837: l_plannedQty number;
1838: l_newCompletedQty number;
1839:
1840: l_params wip_logger.param_tbl_t;
1841: l_returnStatus varchar2(1);
1842: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1843: begin
1844:

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

2043: return;
2044: end if;
2045:
2046: if (l_logLevel <= wip_constants.full_logging) then
2047: wip_logger.log(p_msg => x_compTbl.count || ' components exploded!',
2048: x_returnStatus => l_returnStatus);
2049: end if;
2050:
2051: -- get the routing type

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

2089: if (round(abs(x_compTbl(l_count).primary_quantity),
2090: WIP_CONSTANTS.INV_MAX_PRECISION) = 0) then
2091: if(p_txnFlag) then
2092: if (l_logLevel <= wip_constants.full_logging) then
2093: wip_logger.log(p_msg => 'Qty too small, component ' ||
2094: x_compTbl(l_count).inventory_item_id || ' stripped!',
2095: x_returnStatus => l_returnStatus);
2096: end if;
2097: x_compTbl.delete(l_count);

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

2117: elsif ( l_cfmRouting <> 1 ) then
2118: if ( x_compTbl(l_count).operation_seq_num > p_toOpSeqNum ) then
2119: -- delete the comp that has op seq greater than to op seq num
2120: if (l_logLevel <= wip_constants.full_logging) then
2121: wip_logger.log(p_msg => 'Op ' || x_compTbl(l_count).operation_seq_num ||
2122: ' after terminal op, item ' ||
2123: x_compTbl(l_count).inventory_item_id || ' stripped!',
2124: x_returnStatus => l_returnStatus);
2125: end if;

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

2147: l_lineOpTbl) ) then
2148: l_checkPass := true;
2149: else
2150: if (l_logLevel <= wip_constants.full_logging) then
2151: wip_logger.log(p_msg => 'Event ' || x_compTbl(l_count).operation_seq_num ||
2152: ' belongs to line op that after terminal op, item ' ||
2153: x_compTbl(l_count).inventory_item_id || ' stripped!',
2154: x_returnStatus => l_returnStatus);
2155: end if;

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

2166: -- type components should be exploded for discrete jobs.
2167: if ( l_checkPass and p_txnFlag and
2168: nvl(x_compTbl(l_count).wip_supply_type, 1) not in (1, 2, 3, 6) ) then
2169: if (l_logLevel <= wip_constants.full_logging) then
2170: wip_logger.log(p_msg => 'Nonrelated supply type item ' ||
2171: x_compTbl(l_count).inventory_item_id ||
2172: ' at op ' || x_compTbl(l_count).operation_seq_num ||
2173: ' stripped!',
2174: x_returnStatus => l_returnStatus);

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

2201: fnd_message.set_name('WIP', 'WIP_COMP_NOT_TRANSACTABLE');
2202: fnd_message.set_token('ENTITY1', x_compTbl(l_count).item_name);
2203: fnd_msg_pub.add;
2204: if (l_logLevel <= wip_constants.full_logging) then
2205: wip_logger.log(p_msg => 'Item ' || x_compTbl(l_count).inventory_item_id ||
2206: ' not transactable, failed explosion!',
2207: x_returnStatus => l_returnStatus);
2208: end if;
2209: x_compTbl.delete;

Line 2316: l_params wip_logger.param_tbl_t;

2312: l_insertPhantom number;
2313: l_acctPeriodID number;
2314: l_openPastPeriod boolean := false;
2315:
2316: l_params wip_logger.param_tbl_t;
2317: l_returnStatus varchar2(1);
2318: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2319: begin
2320:

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

2470: from mtl_material_transactions_temp mmtt
2471: where mmtt.transaction_temp_id = p_txnTempID;
2472:
2473: if (l_logLevel <= wip_constants.full_logging) then
2474: wip_logger.log(p_msg => 'Insert item ' || l_compTbl(l_count).inventory_item_id ||
2475: ' under op ' || l_compTbl(l_count).operation_seq_num,
2476: x_returnStatus => l_returnStatus);
2477: end if;
2478: end if;

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

2711: WIP_CONSTANTS.ISSNEGC_ACTION,
2712: WIP_CONSTANTS.RETNEGC_ACTION)
2713: order by operation_seq_num;
2714:
2715: l_params wip_logger.param_tbl_t;
2716: l_returnStatus varchar2(1);
2717: l_success boolean;
2718:
2719: l_orgID number;

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;