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.WMA_FLOW dependencies on WIP_LOGGER

Line 19: l_params wip_logger.param_tbl_t;

15: errMessage OUT NOCOPY VARCHAR2) IS
16: flowRec FlowRecord;
17: errMsg VARCHAR2(241);
18: l_returnStatus VARCHAR2(1);
19: l_params wip_logger.param_tbl_t;
20: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
21: Begin
22: status := 0;
23: if (l_logLevel <= wip_constants.trace_logging) then

Line 26: wip_logger.entryPoint(p_procName => 'wma_flow.insertParentRecord',

22: status := 0;
23: if (l_logLevel <= wip_constants.trace_logging) then
24: l_params(1).paramName := 'not printing params';
25: l_params(1).paramValue := ' ';
26: wip_logger.entryPoint(p_procName => 'wma_flow.insertParentRecord',
27: p_params => l_params,
28: x_returnStatus => l_returnStatus);
29: end if;
30:

Line 35: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecord',

31: if ( derive(param, flowRec, errMsg) = false ) then
32: status := -1;
33: errMessage := errMsg;
34: if (l_logLevel <= wip_constants.trace_logging) then
35: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecord',
36: p_procReturnStatus => status,
37: p_msg => errMessage,
38: x_returnStatus => l_returnStatus);
39: end if;

Line 47: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecord',

43: if ( put(flowRec, errMsg) = false ) then
44: status := -1;
45: errMessage := errMsg;
46: if (l_logLevel <= wip_constants.trace_logging) then
47: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecord',
48: p_procReturnStatus => status,
49: p_msg => errMessage,
50: x_returnStatus => l_returnStatus);
51: end if;

Line 56: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecord',

52: return;
53: end if;
54:
55: if (l_logLevel <= wip_constants.trace_logging) then
56: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecord',
57: p_procReturnStatus => status,
58: p_msg => 'success',
59: x_returnStatus => l_returnStatus);
60: end if;

Line 70: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecord',

66: fnd_message.set_token ('FUNCTION', 'wma_flow.insertParentRecord');
67: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
68: errMessage := fnd_message.get;
69: if (l_logLevel <= wip_constants.trace_logging) then
70: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecord',
71: p_procReturnStatus => status,
72: p_msg => errMessage,
73: x_returnStatus => l_returnStatus);
74: end if;

Line 90: l_params wip_logger.param_tbl_t;

86: errMessage OUT NOCOPY VARCHAR2) IS
87: flowRec FlowRecord;
88: errMsg VARCHAR2(241);
89: l_returnStatus VARCHAR2(1);
90: l_params wip_logger.param_tbl_t;
91: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
92: Begin
93:
94: if (l_logLevel <= wip_constants.trace_logging) then

Line 97: wip_logger.entryPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',

93:
94: if (l_logLevel <= wip_constants.trace_logging) then
95: l_params(1).paramName := 'not printing params';
96: l_params(1).paramValue := ' ';
97: wip_logger.entryPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',
98: p_params => l_params,
99: x_returnStatus => l_returnStatus);
100: end if;
101:

Line 106: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',

102: if ( derive(param, flowRec, errMsg) = false ) then
103: status := -1;
104: errMessage := errMsg;
105: if (l_logLevel <= wip_constants.trace_logging) then
106: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',
107: p_procReturnStatus => status,
108: p_msg => errMessage,
109: x_returnStatus => l_returnStatus);
110: end if;

Line 118: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',

114: if ( putIntoMMTT(flowRec, errMsg) = false ) then
115: status := -1;
116: errMessage := errMsg;
117: if (l_logLevel <= wip_constants.trace_logging) then
118: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',
119: p_procReturnStatus => status,
120: p_msg => errMessage,
121: x_returnStatus => l_returnStatus);
122: end if;

Line 127: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',

123: return;
124: end if;
125:
126: if (l_logLevel <= wip_constants.trace_logging) then
127: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',
128: p_procReturnStatus => status,
129: p_msg => 'success',
130: x_returnStatus => l_returnStatus);
131: end if;

Line 141: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',

137: fnd_message.set_token ('FUNCTION', 'wma_flow.insertParentRecordintoMMTT');
138: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
139: errMessage := fnd_message.get;
140: if (l_logLevel <= wip_constants.trace_logging) then
141: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',
142: p_procReturnStatus => status,
143: p_msg => errMessage,
144: x_returnStatus => l_returnStatus);
145: end if;

Line 397: wip_logger.log('lpnid: ' || flowRec.lpn_id, l_dummy);

393: */
394: Function put(flowRec FlowRecord, errMsg OUT NOCOPY VARCHAR2) return boolean IS
395: l_dummy varchar2(1);
396: Begin
397: wip_logger.log('lpnid: ' || flowRec.lpn_id, l_dummy);
398: INSERT INTO mtl_transactions_interface
399: (transaction_interface_id,
400: transaction_header_id,
401: completion_transaction_id,

Line 525: wip_logger.log('lpnid: ' || flowRec.lpn_id, l_dummy);

521: and mtlt.transaction_temp_id = l_txnTmpID;
522: /* End - Fix for bug #6216695, which is an FP of 6082623 */
523:
524: Begin
525: wip_logger.log('lpnid: ' || flowRec.lpn_id, l_dummy);
526: INSERT INTO mtl_material_transactions_temp
527: (transaction_temp_id,
528: transaction_header_id,
529: completion_transaction_id,

Line 997: l_params wip_logger.param_tbl_t;

993: l_compTbl system.wip_component_tbl_t;
994: l_bomRevDate date := null;
995: l_count number;
996: l_returnStatus VARCHAR2(1);
997: l_params wip_logger.param_tbl_t;
998: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
999:
1000: l_alt_bom VARCHAR2(10);
1001: l_alt_rtg VARCHAR2(10);

Line 1022: wip_logger.entryPoint(p_procName => 'wma_flow.explodeBOMAndDerive',

1018:
1019: if (l_logLevel <= wip_constants.trace_logging) then
1020: l_params(1).paramName := 'not printing params';
1021: l_params(1).paramValue := ' ';
1022: wip_logger.entryPoint(p_procName => 'wma_flow.explodeBOMAndDerive',
1023: p_params => l_params,
1024: x_returnStatus => l_returnStatus);
1025: end if;
1026:

Line 1078: wip_logger.log('Done with explosion of components',l_returnStatus);

1074: raise fnd_api.g_exc_unexpected_error;
1075: end if;
1076:
1077: if (l_logLevel <= wip_constants.full_logging) then
1078: wip_logger.log('Done with explosion of components',l_returnStatus);
1079: end if;
1080:
1081: -- fetch flow schedule's information into wfs_info
1082: for c_wfs_info in wfs_info_cursor(p_wipEntityID) loop

Line 1095: wip_logger.log('Removed non txn enabled component: '+l_compTbl(l_count).item_name, l_returnStatus);

1091: if ((nvl(l_compTbl(l_count).wip_supply_type, -1) <> 6) and
1092: (l_compTbl(l_count).mtl_transactions_enabled_flag <> 'Y')) then
1093: l_compTbl.delete(l_count);
1094: if (l_logLevel <= wip_constants.full_logging) then
1095: wip_logger.log('Removed non txn enabled component: '+l_compTbl(l_count).item_name, l_returnStatus);
1096: end if;
1097: goto continue_loop;
1098: end if;
1099:

Line 1136: wip_logger.log('Done with lot derivation',l_returnStatus);

1132: raise fnd_api.g_exc_unexpected_error;
1133: end if;
1134:
1135: if (l_logLevel <= wip_constants.full_logging) then
1136: wip_logger.log('Done with lot derivation',l_returnStatus);
1137: end if;
1138:
1139: --now that we have exploded components and derived lots
1140: --merge these with recorded details

Line 1159: wip_logger.exitPoint(p_procName => 'wma_flow.explodeBOMAndDerive',

1155: x_compInfo => x_compInfo,
1156: x_returnStatus => x_returnStatus);
1157:
1158: if (l_logLevel <= wip_constants.trace_logging) then
1159: wip_logger.exitPoint(p_procName => 'wma_flow.explodeBOMAndDerive',
1160: p_procReturnStatus => x_returnStatus,
1161: p_msg => 'success',
1162: x_returnStatus => l_returnStatus);
1163: end if;

Line 1170: wip_logger.exitPoint(p_procName => 'wma_flow.explodeBOMAndDerive',

1166: when fnd_api.g_exc_unexpected_error then
1167: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1168: x_errMessage := fnd_msg_pub.get(p_encoded => 'F');
1169: if (l_logLevel <= wip_constants.trace_logging) then
1170: wip_logger.exitPoint(p_procName => 'wma_flow.explodeBOMAndDerive',
1171: p_procReturnStatus => x_returnStatus,
1172: p_msg => x_errMessage,
1173: x_returnStatus => l_returnStatus);
1174: end if;

Line 1182: wip_logger.exitPoint(p_procName => 'wma_flow.explodeBOMAndDerive',

1178: when others then
1179: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1180: x_errMessage := SQLERRM;
1181: if (l_logLevel <= wip_constants.trace_logging) then
1182: wip_logger.exitPoint(p_procName => 'wma_flow.explodeBOMAndDerive',
1183: p_procReturnStatus => x_returnStatus,
1184: p_msg => x_errMessage,
1185: x_returnStatus => l_returnStatus);
1186: end if;