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_BATCH_MOVE dependencies on WIP_LOGGER

Line 162: l_params wip_logger.param_tbl_t;

158: l_process_phase VARCHAR2(3);
159: l_return_status VARCHAR(1);
160: l_move_info c_move_info%ROWTYPE;
161: l_move_record move_record_pvt;
162: l_params wip_logger.param_tbl_t;
163: l_next_op_seq_num NUMBER; /*Bug 12960152: Enhance express move to support ez completion*/
164: l_express_cmp NUMBER;/*Bug 12960152: Enhance express move to support ez completion*/
165: l_hook_to_op_seq NUMBER := NULL;
166: l_hook_to_step_type NUMBER := NULL;

Line 191: wip_logger.entryPoint(p_procName => 'wip_batch_move.derive_move',

187: l_params(6).paramValue := p_default_step_type;
188: l_params(7).paramName := 'p_fm_step_type';
189: l_params(7).paramValue := p_fm_step_type;
190:
191: wip_logger.entryPoint(p_procName => 'wip_batch_move.derive_move',
192: p_params => l_params,
193: x_returnStatus => l_return_status);
194: END IF;
195:

Line 209: wip_logger.log('Calling MOVE_TO_STEP_HOOK', l_return_status);

205: l_move_record.fm_department_code := l_move_info.fm_dept_code;
206: l_move_record.fm_intraoperation_step_type := l_move_info.fm_step_type;
207: l_move_record.fm_intraoperation_step := get_step_meaning(l_move_info.fm_step_type);
208:
209: wip_logger.log('Calling MOVE_TO_STEP_HOOK', l_return_status);
210: wip_logger.log('fm_department_id: ' || l_move_record.fm_department_id, l_return_status);
211: wip_logger.log('l_hook_to_op_seq: ' || l_hook_to_op_seq, l_return_status);
212: wip_logger.log('l_hook_to_step_type: ' || l_hook_to_step_type, l_return_status);
213: WIP_WS_CUSTOM.MOVE_TO_STEP_HOOK(

Line 210: wip_logger.log('fm_department_id: ' || l_move_record.fm_department_id, l_return_status);

206: l_move_record.fm_intraoperation_step_type := l_move_info.fm_step_type;
207: l_move_record.fm_intraoperation_step := get_step_meaning(l_move_info.fm_step_type);
208:
209: wip_logger.log('Calling MOVE_TO_STEP_HOOK', l_return_status);
210: wip_logger.log('fm_department_id: ' || l_move_record.fm_department_id, l_return_status);
211: wip_logger.log('l_hook_to_op_seq: ' || l_hook_to_op_seq, l_return_status);
212: wip_logger.log('l_hook_to_step_type: ' || l_hook_to_step_type, l_return_status);
213: WIP_WS_CUSTOM.MOVE_TO_STEP_HOOK(
214: org_id => p_org_id,

Line 211: wip_logger.log('l_hook_to_op_seq: ' || l_hook_to_op_seq, l_return_status);

207: l_move_record.fm_intraoperation_step := get_step_meaning(l_move_info.fm_step_type);
208:
209: wip_logger.log('Calling MOVE_TO_STEP_HOOK', l_return_status);
210: wip_logger.log('fm_department_id: ' || l_move_record.fm_department_id, l_return_status);
211: wip_logger.log('l_hook_to_op_seq: ' || l_hook_to_op_seq, l_return_status);
212: wip_logger.log('l_hook_to_step_type: ' || l_hook_to_step_type, l_return_status);
213: WIP_WS_CUSTOM.MOVE_TO_STEP_HOOK(
214: org_id => p_org_id,
215: wip_entity_id => p_wip_entity_id,

Line 212: wip_logger.log('l_hook_to_step_type: ' || l_hook_to_step_type, l_return_status);

208:
209: wip_logger.log('Calling MOVE_TO_STEP_HOOK', l_return_status);
210: wip_logger.log('fm_department_id: ' || l_move_record.fm_department_id, l_return_status);
211: wip_logger.log('l_hook_to_op_seq: ' || l_hook_to_op_seq, l_return_status);
212: wip_logger.log('l_hook_to_step_type: ' || l_hook_to_step_type, l_return_status);
213: WIP_WS_CUSTOM.MOVE_TO_STEP_HOOK(
214: org_id => p_org_id,
215: wip_entity_id => p_wip_entity_id,
216: fm_op_seq => p_fm_op_seq,

Line 223: wip_logger.log('Done calling MOVE_TO_STEP_HOOK', l_return_status);

219: to_op_seq => l_hook_to_op_seq,
220: to_op_step_type => l_hook_to_step_type,
221: return_status => l_custom_returnStatus, --'S': Success
222: return_message => l_return_message);
223: wip_logger.log('Done calling MOVE_TO_STEP_HOOK', l_return_status);
224: wip_logger.log('hook returned. op_seq: ' || l_hook_to_op_seq || ' op_step: ' || l_hook_to_step_type, l_return_status);
225:
226: IF(l_custom_returnStatus = 'S' and l_hook_to_op_seq is not null and l_hook_to_step_type is not null) THEN
227: --Case 1: Success and to_op_seq/step. Carry out the transaction with value provided by the hook.

Line 224: wip_logger.log('hook returned. op_seq: ' || l_hook_to_op_seq || ' op_step: ' || l_hook_to_step_type, l_return_status);

220: to_op_step_type => l_hook_to_step_type,
221: return_status => l_custom_returnStatus, --'S': Success
222: return_message => l_return_message);
223: wip_logger.log('Done calling MOVE_TO_STEP_HOOK', l_return_status);
224: wip_logger.log('hook returned. op_seq: ' || l_hook_to_op_seq || ' op_step: ' || l_hook_to_step_type, l_return_status);
225:
226: IF(l_custom_returnStatus = 'S' and l_hook_to_op_seq is not null and l_hook_to_step_type is not null) THEN
227: --Case 1: Success and to_op_seq/step. Carry out the transaction with value provided by the hook.
228: select wo.department_id, bd.department_code

Line 235: wip_logger.log('department_id: ' || l_department_id || ' department_code: ' || l_department_code, l_return_status);

231: where wo.wip_entity_id = p_wip_entity_id
232: and wo.organization_id = p_org_id
233: and wo.OPERATION_SEQ_NUM = l_hook_to_op_seq
234: and wo.department_id = bd.department_id;
235: wip_logger.log('department_id: ' || l_department_id || ' department_code: ' || l_department_code, l_return_status);
236:
237: BEGIN
238: select bso.operation_code
239: into l_operation_code

Line 247: wip_logger.log('not a standard operation. operation_seq: ' || l_hook_to_op_seq, l_return_status);

243: and wo.OPERATION_SEQ_NUM = l_hook_to_op_seq
244: and wo.standard_operation_id = bso.standard_operation_id(+);
245: EXCEPTION
246: WHEN NO_DATA_FOUND THEN
247: wip_logger.log('not a standard operation. operation_seq: ' || l_hook_to_op_seq, l_return_status);
248: END;
249:
250: /*Using Hook's returned values*/
251: l_move_record.to_operation_seq_num := l_hook_to_op_seq;

Line 271: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',

267: CLOSE c_move_info;
268: END IF;
269: l_error_msg := 'MOVE_TO_STEP_HOOK errored out: ' || l_return_message;
270: IF (l_log_level <= wip_constants.trace_logging) THEN
271: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',
272: p_procReturnStatus => x_return_status,
273: p_msg => l_error_msg,
274: x_returnStatus => l_return_status);
275: END IF;

Line 304: wip_logger.log('current responsiblity key: '||WIP_WS_UTIL.GET_CURRENT_RESP_KEY,l_return_status);

300: /*Bug 12960152: Enhance express move to support ez completion
301: Whenever to_op_seq is the last operation and to_intraoperation_step_type is TOMOVE,
302: we will complete the quantity based on MES preference value
303: */
304: wip_logger.log('current responsiblity key: '||WIP_WS_UTIL.GET_CURRENT_RESP_KEY,l_return_status);
305: l_express_cmp := wip_ws_util.get_preference_value_code(p_pref_id => 44, --Express Move and Complete at Last Operation
306: p_resp_key => WIP_WS_UTIL.get_current_resp_key,
307: p_org_id => p_org_id,
308: p_dept_id => l_move_info.to_dept_id);

Line 309: wip_logger.log('l_express_cmp: '||l_express_cmp,l_return_status);

305: l_express_cmp := wip_ws_util.get_preference_value_code(p_pref_id => 44, --Express Move and Complete at Last Operation
306: p_resp_key => WIP_WS_UTIL.get_current_resp_key,
307: p_org_id => p_org_id,
308: p_dept_id => l_move_info.to_dept_id);
309: wip_logger.log('l_express_cmp: '||l_express_cmp,l_return_status);
310:
311: select next_operation_seq_num
312: into l_next_op_seq_num
313: from wip_operations

Line 320: wip_logger.log('EZ completion',l_return_status);

316: and operation_seq_num = l_move_record.to_operation_seq_num;
317:
318: --only do express complete when preference Express Move and Complete at Last Operation is set to yes
319: IF(l_express_cmp = 1 AND l_next_op_seq_num is null AND l_move_record.to_intraoperation_step_type = WIP_CONSTANTS.TOMOVE) THEN
320: wip_logger.log('EZ completion',l_return_status);
321: l_move_record.transaction_type := WIP_CONSTANTS.COMP_TXN;
322: ELSE
323: wip_logger.log('Normal Move',l_return_status);
324: l_move_record.transaction_type := WIP_CONSTANTS.MOVE_TXN;

Line 323: wip_logger.log('Normal Move',l_return_status);

319: IF(l_express_cmp = 1 AND l_next_op_seq_num is null AND l_move_record.to_intraoperation_step_type = WIP_CONSTANTS.TOMOVE) THEN
320: wip_logger.log('EZ completion',l_return_status);
321: l_move_record.transaction_type := WIP_CONSTANTS.COMP_TXN;
322: ELSE
323: wip_logger.log('Normal Move',l_return_status);
324: l_move_record.transaction_type := WIP_CONSTANTS.MOVE_TXN;
325: END IF;
326:
327: l_move_record.to_intraoperation_step := get_step_meaning(l_move_info.to_step_type);

Line 346: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',

342: x_return_status := fnd_api.g_ret_sts_success;
343:
344: -- write to the log file
345: IF (l_log_level <= wip_constants.trace_logging) THEN
346: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',
347: p_procReturnStatus => x_return_status,
348: p_msg => 'procedure complete',
349: x_returnStatus => l_return_status);
350: END IF;

Line 361: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',

357: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
358: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
359:
360: IF (l_log_level <= wip_constants.trace_logging) THEN
361: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',
362: p_procReturnStatus => x_return_status,
363: p_msg => l_error_msg,
364: x_returnStatus => l_return_status);
365: END IF;

Line 449: l_params wip_logger.param_tbl_t;

445: l_process_phase VARCHAR2(3);
446: l_return_status VARCHAR2(1);
447: l_scrap_info c_scrap_info%ROWTYPE;
448: l_scrap_record move_record_pvt;
449: l_params wip_logger.param_tbl_t;
450: BEGIN
451: l_process_phase := '1';
452: -- write parameter value to log file
453: IF (l_log_level <= wip_constants.trace_logging) THEN

Line 475: wip_logger.entryPoint(p_procName => 'wip_batch_move.derive_scrap',

471: l_params(9).paramValue := p_fm_step_type;
472: l_params(10).paramName := 'p_resp_key';
473: l_params(10).paramValue := p_resp_key;
474:
475: wip_logger.entryPoint(p_procName => 'wip_batch_move.derive_scrap',
476: p_params => l_params,
477: x_returnStatus => l_return_status);
478: END IF;
479:

Line 549: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_scrap',

545: x_return_status := fnd_api.g_ret_sts_success;
546:
547: -- write to the log file
548: IF (l_log_level <= wip_constants.trace_logging) THEN
549: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_scrap',
550: p_procReturnStatus => x_return_status,
551: p_msg => 'procedure complete',
552: x_returnStatus => l_return_status);
553: END IF;

Line 561: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_scrap',

557: IF(c_scrap_info%ISOPEN) THEN
558: CLOSE c_scrap_info;
559: END IF;
560: IF (l_log_level <= wip_constants.trace_logging) THEN
561: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_scrap',
562: p_procReturnStatus => x_return_status,
563: p_msg => l_error_msg,
564: x_returnStatus => l_return_status);
565: END IF;

Line 575: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_scrap',

571: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
572: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
573:
574: IF (l_log_level <= wip_constants.trace_logging) THEN
575: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_scrap',
576: p_procReturnStatus => x_return_status,
577: p_msg => l_error_msg,
578: x_returnStatus => l_return_status);
579: END IF;

Line 604: l_params wip_logger.param_tbl_t;

600: l_log_level NUMBER := fnd_log.g_current_runtime_level;
601: l_error_msg VARCHAR2(240);
602: l_process_phase VARCHAR2(3);
603: l_return_status VARCHAR2(1);
604: l_params wip_logger.param_tbl_t;
605: BEGIN
606: l_process_phase := '1';
607: -- write parameter value to log file
608: IF (l_log_level <= wip_constants.trace_logging) THEN

Line 632: wip_logger.entryPoint(p_procName => 'wip_batch_move.derive_row',

628: l_params(10).paramValue := p_fm_step_type;
629: l_params(11).paramName := 'p_resp_key';
630: l_params(11).paramValue := p_resp_key;
631:
632: wip_logger.entryPoint(p_procName => 'wip_batch_move.derive_row',
633: p_params => l_params,
634: x_returnStatus => l_return_status);
635: END IF;
636: l_process_phase := '2';

Line 679: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_row',

675:
676: x_return_status := fnd_api.g_ret_sts_success;
677: -- write to the log file
678: IF (l_log_level <= wip_constants.trace_logging) THEN
679: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_row',
680: p_procReturnStatus => x_return_status,
681: p_msg => 'procedure complete',
682: x_returnStatus => l_return_status);
683: END IF;

Line 689: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_row',

685: EXCEPTION
686: WHEN fnd_api.g_exc_unexpected_error THEN
687: x_return_status := fnd_api.g_ret_sts_error;
688: IF (l_log_level <= wip_constants.trace_logging) THEN
689: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_row',
690: p_procReturnStatus => x_return_status,
691: p_msg => l_error_msg,
692: x_returnStatus => l_return_status);
693: END IF;

Line 701: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_row',

697: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
698: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
699:
700: IF (l_log_level <= wip_constants.trace_logging) THEN
701: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_row',
702: p_procReturnStatus => x_return_status,
703: p_msg => l_error_msg,
704: x_returnStatus => l_return_status);
705: END IF;

Line 722: l_params wip_logger.param_tbl_t;

718: l_default_step_type VARCHAR2(1);
719: l_error_msg VARCHAR2(240);
720: l_process_phase VARCHAR2(3);
721: l_return_status VARCHAR2(1);
722: l_params wip_logger.param_tbl_t;
723: BEGIN
724: l_process_phase := '1';
725: -- write parameter value to log file
726: IF (l_log_level <= wip_constants.trace_logging) THEN

Line 734: wip_logger.entryPoint(p_procName => 'wip_batch_move.get_preferences',

730: l_params(2).paramValue := p_org_id;
731: l_params(3).paramName := 'p_dept_id';
732: l_params(3).paramValue := p_dept_id;
733:
734: wip_logger.entryPoint(p_procName => 'wip_batch_move.get_preferences',
735: p_params => l_params,
736: x_returnStatus => l_return_status);
737: END IF;
738: l_process_phase := '2';

Line 767: wip_logger.exitPoint(p_procName => 'wip_batch_move.get_preferences',

763: x_return_status := fnd_api.g_ret_sts_success;
764:
765: -- write to the log file
766: IF (l_log_level <= wip_constants.trace_logging) THEN
767: wip_logger.exitPoint(p_procName => 'wip_batch_move.get_preferences',
768: p_procReturnStatus => x_return_status,
769: p_msg => 'procedure complete',
770: x_returnStatus => l_return_status);
771: END IF;

Line 779: wip_logger.exitPoint(p_procName => 'wip_batch_move.get_preferences',

775: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
776: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
777:
778: IF (l_log_level <= wip_constants.trace_logging) THEN
779: wip_logger.exitPoint(p_procName => 'wip_batch_move.get_preferences',
780: p_procReturnStatus => x_return_status,
781: p_msg => l_error_msg,
782: x_returnStatus => l_return_status);
783: END IF;

Line 840: l_params wip_logger.param_tbl_t;

836: l_total_row NUMBER;
837: l_error_msg VARCHAR2(240);
838: l_process_phase VARCHAR2(3);
839: l_return_status VARCHAR2(1);
840: l_params wip_logger.param_tbl_t;
841: l_txn_id NUMBER;
842: BEGIN
843: l_process_phase := '1';
844: -- write parameter value to log file

Line 853: wip_logger.entryPoint(p_procName => 'wip_batch_move.insert_move_records',

849: l_params(2).paramValue := p_employee_id;
850: l_params(3).paramName := 'p_assy_serial';
851: l_params(3).paramValue := p_assy_serial;
852:
853: wip_logger.entryPoint(p_procName => 'wip_batch_move.insert_move_records',
854: p_params => l_params,
855: x_returnStatus => l_return_status);
856: END IF;
857: l_process_phase := '2';

Line 1042: wip_logger.exitPoint(p_procName => 'wip_batch_move.insert_move_records',

1038:
1039: x_return_status := fnd_api.g_ret_sts_success;
1040: -- write to the log file
1041: IF (l_log_level <= wip_constants.trace_logging) THEN
1042: wip_logger.exitPoint(p_procName => 'wip_batch_move.insert_move_records',
1043: p_procReturnStatus => x_return_status,
1044: p_msg => 'procedure complete',
1045: x_returnStatus => l_return_status);
1046: END IF;

Line 1055: wip_logger.exitPoint(p_procName => 'wip_batch_move.insert_move_records',

1051: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
1052: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1053:
1054: IF (l_log_level <= wip_constants.trace_logging) THEN
1055: wip_logger.exitPoint(p_procName => 'wip_batch_move.insert_move_records',
1056: p_procReturnStatus => x_return_status,
1057: p_msg => l_error_msg,
1058: x_returnStatus => l_return_status);
1059: END IF;

Line 1110: l_params wip_logger.param_tbl_t;

1106: l_process_phase VARCHAR2(3);
1107: l_return_status VARCHAR2(1);
1108: l_errors c_errors%ROWTYPE;
1109: l_move_intf_records c_move_intf_records%ROWTYPE;
1110: l_params wip_logger.param_tbl_t;
1111:
1112: BEGIN
1113: l_process_phase := '1';
1114: -- write parameter value to log file

Line 1119: wip_logger.entryPoint(p_procName => 'wip_batch_move.process_move_records',

1115: IF (l_log_level <= wip_constants.trace_logging) THEN
1116: l_params(1).paramName := 'p_group_id';
1117: l_params(1).paramValue := p_group_id;
1118:
1119: wip_logger.entryPoint(p_procName => 'wip_batch_move.process_move_records',
1120: p_params => l_params,
1121: x_returnStatus => l_return_status);
1122: END IF;
1123: l_process_phase := '2';

Line 1161: wip_logger.exitPoint(p_procName => 'wip_batch_move.process_move_records',

1157: END IF;
1158:
1159: -- write to the log file
1160: IF (l_log_level <= wip_constants.trace_logging) THEN
1161: wip_logger.exitPoint(p_procName => 'wip_batch_move.process_move_records',
1162: p_procReturnStatus => x_return_status,
1163: p_msg => 'procedure complete',
1164: x_returnStatus => l_return_status);
1165: END IF;

Line 1182: wip_logger.exitPoint(p_procName => 'wip_batch_move.process_move_records',

1178: l_errors.error_message || '; ';
1179: END LOOP;
1180:
1181: IF (l_log_level <= wip_constants.trace_logging) THEN
1182: wip_logger.exitPoint(p_procName => 'wip_batch_move.process_move_records',
1183: p_procReturnStatus => x_return_status,
1184: p_msg => 'wip_movProc_grp.processInterface failed',
1185: x_returnStatus => l_return_status);
1186: END IF;

Line 1202: wip_logger.exitPoint(p_procName => 'wip_batch_move.process_move_records',

1198: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
1199: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1200:
1201: IF (l_log_level <= wip_constants.trace_logging) THEN
1202: wip_logger.exitPoint(p_procName => 'wip_batch_move.process_move_records',
1203: p_procReturnStatus => x_return_status,
1204: p_msg => l_error_msg,
1205: x_returnStatus => l_return_status);
1206: END IF;

Line 1233: l_params wip_logger.param_tbl_t;

1229: l_plan_txn_ids VARCHAR2(10000);
1230: l_plan_ids VARCHAR2(10000);
1231: l_quality_plan_exist VARCHAR2(1);
1232: l_return_status VARCHAR2(1);
1233: l_params wip_logger.param_tbl_t;
1234: BEGIN
1235: -- write parameter value to log file
1236: IF (l_log_level <= wip_constants.trace_logging) THEN
1237: l_params(1).paramName := 'p_org_id';

Line 1240: wip_logger.entryPoint(p_procName => 'wip_batch_move.quality_require',

1236: IF (l_log_level <= wip_constants.trace_logging) THEN
1237: l_params(1).paramName := 'p_org_id';
1238: l_params(1).paramValue := p_org_id;
1239:
1240: wip_logger.entryPoint(p_procName => 'wip_batch_move.quality_require',
1241: p_params => l_params,
1242: x_returnStatus => l_return_status);
1243: END IF;
1244: x_quality_require := fnd_api.g_false;

Line 1300: wip_logger.log(p_msg => 'l_context_values='||l_context_values,

1296: qa_ss_const.project_number||'='||p_move_tbl(i).project_id||'@'||
1297: qa_ss_const.task_number||'='||p_move_tbl(i).task_id;
1298:
1299: IF (l_log_level <= wip_constants.trace_logging) THEN
1300: wip_logger.log(p_msg => 'l_context_values='||l_context_values,
1301: x_returnStatus => l_return_status);
1302: END IF;
1303:
1304: BEGIN

Line 1372: wip_logger.log(p_msg => l_error_msg,

1368: fnd_message.set_token('MESSAGE', l_error_msg);
1369: fnd_msg_pub.add;
1370:
1371: IF (l_log_level <= wip_constants.trace_logging) THEN
1372: wip_logger.log(p_msg => l_error_msg,
1373: x_returnStatus => l_return_status);
1374: END IF;
1375: END;
1376: END LOOP;

Line 1380: wip_logger.exitPoint(p_procName => 'wip_batch_move.quality_require',

1376: END LOOP;
1377:
1378: -- write to the log file
1379: IF (l_log_level <= wip_constants.trace_logging) THEN
1380: wip_logger.exitPoint(p_procName => 'wip_batch_move.quality_require',
1381: p_procReturnStatus => fnd_api.g_ret_sts_success,
1382: p_msg => 'procedure complete',
1383: x_returnStatus => l_return_status);
1384: END IF;

Line 1390: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',

1386: x_return_status := fnd_api.g_ret_sts_success;
1387:
1388: -- write to the log file
1389: IF (l_log_level <= wip_constants.trace_logging) THEN
1390: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',
1391: p_procReturnStatus => x_return_status,
1392: p_msg => 'procedure complete',
1393: x_returnStatus => l_return_status);
1394: END IF;

Line 1401: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',

1397: x_return_status := fnd_api.g_ret_sts_error;
1398: l_error_msg := ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1399:
1400: IF (l_log_level <= wip_constants.trace_logging) THEN
1401: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',
1402: p_procReturnStatus => x_return_status,
1403: p_msg => l_error_msg,
1404: x_returnStatus => l_return_status);
1405: END IF;

Line 1416: l_params wip_logger.param_tbl_t;

1412: l_log_level NUMBER := fnd_log.g_current_runtime_level;
1413: l_error_msg VARCHAR2(240);
1414: l_process_phase VARCHAR2(3);
1415: l_return_status VARCHAR2(1);
1416: l_params wip_logger.param_tbl_t;
1417: BEGIN
1418: l_process_phase := '1';
1419: -- write parameter value to log file
1420: IF (l_log_level <= wip_constants.trace_logging) THEN

Line 1424: wip_logger.entryPoint(p_procName => 'wip_batch_move.validate_batch',

1420: IF (l_log_level <= wip_constants.trace_logging) THEN
1421: l_params(1).paramName := 'p_default_step_type';
1422: l_params(1).paramValue := p_default_step_type;
1423:
1424: wip_logger.entryPoint(p_procName => 'wip_batch_move.validate_batch',
1425: p_params => l_params,
1426: x_returnStatus => l_return_status);
1427: END IF;
1428: l_process_phase := '2';

Line 1455: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_batch',

1451:
1452: x_return_status := fnd_api.g_ret_sts_success;
1453: -- write to the log file
1454: IF (l_log_level <= wip_constants.trace_logging) THEN
1455: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_batch',
1456: p_procReturnStatus => x_return_status,
1457: p_msg => 'procedure complete',
1458: x_returnStatus => l_return_status);
1459: END IF;

Line 1465: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_batch',

1461: WHEN fnd_api.g_exc_unexpected_error THEN
1462: x_return_status := fnd_api.g_ret_sts_error;
1463:
1464: IF (l_log_level <= wip_constants.trace_logging) THEN
1465: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_batch',
1466: p_procReturnStatus => x_return_status,
1467: p_msg => l_error_msg,
1468: x_returnStatus => l_return_status);
1469: END IF;

Line 1477: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_batch',

1473: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
1474: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1475:
1476: IF (l_log_level <= wip_constants.trace_logging) THEN
1477: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_batch',
1478: p_procReturnStatus => x_return_status,
1479: p_msg => l_error_msg,
1480: x_returnStatus => l_return_status);
1481: END IF;

Line 1514: l_params wip_logger.param_tbl_t;

1510: l_quality_require VARCHAR2(1);
1511: l_plan_names VARCHAR2(4000);
1512: l_return_status VARCHAR2(1);
1513: l_is_serialized NUMBER; --Fix bug 13336388
1514: l_params wip_logger.param_tbl_t;
1515:
1516: --Fix bug 13336388
1517: cursor serCur (p_wip_entity_id NUMBER,
1518: p_org_id NUMBER,

Line 1554: wip_logger.entryPoint(p_procName => 'wip_batch_move.validate_row',

1550: l_params(9).paramName := 'p_resp_key';
1551: l_params(9).paramValue := p_resp_key;
1552: l_params(10).paramName := 'p_assy_serial';
1553: l_params(10).paramValue := p_assy_serial;
1554: wip_logger.entryPoint(p_procName => 'wip_batch_move.validate_row',
1555: p_params => l_params,
1556: x_returnStatus => l_return_status);
1557: END IF;
1558:

Line 1706: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_row',

1702: x_return_status := fnd_api.g_ret_sts_success;
1703:
1704: -- write to the log file
1705: IF (l_log_level <= wip_constants.trace_logging) THEN
1706: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_row',
1707: p_procReturnStatus => x_return_status,
1708: p_msg => 'procedure complete',
1709: x_returnStatus => l_return_status);
1710: END IF;

Line 1715: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_row',

1711: EXCEPTION
1712: WHEN fnd_api.g_exc_unexpected_error THEN
1713: x_return_status := fnd_api.g_ret_sts_error;
1714: IF (l_log_level <= wip_constants.trace_logging) THEN
1715: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_row',
1716: p_procReturnStatus => x_return_status,
1717: p_msg => l_error_msg,
1718: x_returnStatus => l_return_status);
1719: END IF;

Line 1727: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_row',

1723: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
1724: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1725:
1726: IF (l_log_level <= wip_constants.trace_logging) THEN
1727: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_row',
1728: p_procReturnStatus => x_return_status,
1729: p_msg => l_error_msg,
1730: x_returnStatus => l_return_status);
1731: END IF;

Line 1754: l_params wip_logger.param_tbl_t;

1750: l_error_msg VARCHAR2(240);
1751: l_error_text VARCHAR2(2000);
1752: l_return_status VARCHAR2(1);
1753: l_move_table_pvt wip_batch_move.move_table_pvt;
1754: l_params wip_logger.param_tbl_t;
1755: BEGIN
1756: -- write parameter value to log file
1757: IF (l_log_level <= wip_constants.trace_logging) THEN
1758: l_params(1).paramName := 'p_resp_key';

Line 1766: wip_logger.entryPoint(p_procName => 'wip_batch_move.process',

1762: l_params(3).paramName := 'p_dept_id';
1763: l_params(3).paramValue := p_dept_id;
1764: l_params(4).paramName := 'p_employee_id';
1765: l_params(4).paramValue := p_employee_id;
1766: wip_logger.entryPoint(p_procName => 'wip_batch_move.process',
1767: p_params => l_params,
1768: x_returnStatus => l_return_status);
1769: END IF;
1770:

Line 1859: wip_logger.log(p_msg => l_error_msg,

1855: p_error_text => l_error_text);
1856: l_error_row := l_error_row + 1;
1857: l_error_msg := 'row = ' || i || ' : ' || l_error_msg;
1858: IF (l_log_level <= wip_constants.trace_logging) THEN
1859: wip_logger.log(p_msg => l_error_msg,
1860: x_returnStatus => l_return_status);
1861: END IF;
1862:
1863: WHEN others THEN

Line 1875: wip_logger.log(p_msg => l_error_msg,

1871: l_error_msg := 'row = ' || i || ' : ' ||
1872: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' ||
1873: SQLCODE;
1874: IF (l_log_level <= wip_constants.trace_logging) THEN
1875: wip_logger.log(p_msg => l_error_msg,
1876: x_returnStatus => l_return_status);
1877: END IF;
1878: END;
1879: END LOOP;

Line 1890: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',

1886: x_return_status := fnd_api.g_ret_sts_error;
1887: END IF;
1888: -- Write to the log file.
1889: IF (l_log_level <= wip_constants.trace_logging) THEN
1890: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',
1891: p_procReturnStatus => x_return_status,
1892: p_msg => 'procedure complete',
1893: x_returnStatus => l_return_status);
1894: wip_logger.cleanUp(x_returnStatus => l_return_status);

Line 1894: wip_logger.cleanUp(x_returnStatus => l_return_status);

1890: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',
1891: p_procReturnStatus => x_return_status,
1892: p_msg => 'procedure complete',
1893: x_returnStatus => l_return_status);
1894: wip_logger.cleanUp(x_returnStatus => l_return_status);
1895: END IF;
1896: EXCEPTION
1897: WHEN fnd_api.g_exc_unexpected_error THEN
1898: x_return_status := fnd_api.g_ret_sts_error;

Line 1900: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',

1896: EXCEPTION
1897: WHEN fnd_api.g_exc_unexpected_error THEN
1898: x_return_status := fnd_api.g_ret_sts_error;
1899: IF (l_log_level <= wip_constants.trace_logging) THEN
1900: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',
1901: p_procReturnStatus => x_return_status,
1902: p_msg => l_error_msg,
1903: x_returnStatus => l_return_status);
1904: wip_logger.cleanUp(x_returnStatus => l_return_status);

Line 1904: wip_logger.cleanUp(x_returnStatus => l_return_status);

1900: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',
1901: p_procReturnStatus => x_return_status,
1902: p_msg => l_error_msg,
1903: x_returnStatus => l_return_status);
1904: wip_logger.cleanUp(x_returnStatus => l_return_status);
1905: END IF;
1906:
1907: WHEN others THEN
1908: x_return_status := fnd_api.g_ret_sts_error;

Line 1912: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',

1908: x_return_status := fnd_api.g_ret_sts_error;
1909: l_error_msg := ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1910:
1911: IF (l_log_level <= wip_constants.trace_logging) THEN
1912: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',
1913: p_procReturnStatus => x_return_status,
1914: p_msg => l_error_msg,
1915: x_returnStatus => l_return_status);
1916: wip_logger.cleanUp(x_returnStatus => l_return_status);

Line 1916: wip_logger.cleanUp(x_returnStatus => l_return_status);

1912: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',
1913: p_procReturnStatus => x_return_status,
1914: p_msg => l_error_msg,
1915: x_returnStatus => l_return_status);
1916: wip_logger.cleanUp(x_returnStatus => l_return_status);
1917: END IF;
1918: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1919: fnd_message.set_token('MESSAGE', l_error_msg);
1920: fnd_msg_pub.add;