[Home] [Help]
56: l_params wip_logger.param_tbl_t;
57: l_msgCount NUMBER;
58: l_jobStatus NUMBER;
59: l_jobStatusCode VARCHAR2(240);
60: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
61: begin
62: savepoint wipmtlpb_SP1;
63:
64: if(fnd_api.to_boolean(p_initMsgList)) then
369: l_errMsg VARCHAR2(240);
370: l_returnStatus VARCHAR2(1);
371: l_newRequiredQty NUMBER;
372: l_newIssuedQty NUMBER;
373: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
374: l_dept_id NUMBER := null; /* Bugfix 5401362 */
375: begin
376: if (l_logLevel <= wip_constants.full_logging) then
377: wip_logger.log('processTxn: p_issueQty: ' || p_issueQty, l_returnStatus);
915: l_issueQty NUMBER;
916: l_params wip_logger.param_tbl_t;
917: l_errMsg VARCHAR2(240);
918: l_returnStatus VARCHAR2(1);
919: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
920: l_schedTbl num_tbl_t;--TABLE OF NUMBER;
921: l_qtyTbl num_tbl_t;--TABLE OF NUMBER;
922: l_mmta_schedIdTbl num_tbl_t := num_tbl_t();
923: l_mmta_priQtyTbl num_tbl_t := num_tbl_t();
1151:
1152: procedure writeError(p_txnTmpID IN NUMBER) is
1153: l_errCode VARCHAR2(2000);
1154: l_errExpl VARCHAR2(2000);
1155: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1156: l_returnStatus VARCHAR(1);
1157: begin
1158: wip_utilities.get_message_stack(p_delete_stack => fnd_api.g_false,
1159: p_msg => l_errExpl);
1176:
1177: PROCEDURE processOATxn(p_mtl_header_id IN NUMBER,
1178: x_returnStatus OUT NOCOPY VARCHAR2) IS
1179:
1180: l_log_level NUMBER := fnd_log.g_current_runtime_level;
1181: l_ret_value NUMBER;
1182: l_error_msg VARCHAR2(1000);
1183: l_process_phase VARCHAR2(3);
1184: l_return_status VARCHAR(1);