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.MSC_CL_RPO_PRE_PROCESS dependencies on MSC_ST_UTIL

Line 37: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

33:
34: BEGIN
35:
36:
37: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
38: (p_app_short_name => 'MSC',
39: p_error_code => 'MSC_PP_DUP_REC_FOR_XML',
40: p_message_text => lv_message_text,
41: p_error_text => lv_error_text);

Line 71: msc_st_util.log_message(lv_sql_stmt);

67:
68:
69:
70: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
71: msc_st_util.log_message(lv_sql_stmt);
72: END IF;
73:
74: EXECUTE IMMEDIATE lv_sql_stmt
75: USING MSC_CL_PRE_PROCESS.v_instance_code;

Line 77: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

73:
74: EXECUTE IMMEDIATE lv_sql_stmt
75: USING MSC_CL_PRE_PROCESS.v_instance_code;
76:
77: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
78: (p_app_short_name => 'MSC',
79: p_error_code => 'MSC_PP_DUP_REC_FOR_BATCH_LOAD',
80: p_message_text => lv_message_text,
81: p_error_text => lv_error_text);

Line 111: msc_st_util.log_message(lv_sql_stmt);

107: ||' AND mss1.sr_instance_code = :v_instance_code'
108: ||' AND NVL(mss1.message_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||') = '||MSC_CL_PRE_PROCESS.NULL_VALUE;
109:
110: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
111: msc_st_util.log_message(lv_sql_stmt);
112: END IF;
113:
114: EXECUTE IMMEDIATE lv_sql_stmt
115: USING MSC_CL_PRE_PROCESS.v_instance_code;

Line 156: msc_st_util.log_message(lv_sql_stmt);

152: ||' AND rownum <= '||MSC_CL_PRE_PROCESS.v_batch_size;
153:
154:
155: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
156: msc_st_util.log_message(lv_sql_stmt);
157: END IF;
158:
159: EXECUTE IMMEDIATE lv_sql_stmt
160: USING lv_batch_id,

Line 182: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

178: WHERE rowid = lb_rowid(j);
179:
180: -- set the error message
181:
182: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
183: (p_app_short_name => 'MSC',
184: p_error_code => 'MSC_PP_INVALID_COL_VALUE',
185: p_message_text => lv_message_text,
186: p_error_text => lv_error_text,

Line 201: lv_return := MSC_ST_UTIL.LOG_ERROR

197: ' AND NVL(deleted_flag,'||MSC_CL_PRE_PROCESS.NULL_VALUE||') '
198: ||' NOT IN(1,2)';
199: --Log a warning for those records where the deleted_flag has a value other
200: --than SYS_NO
201: lv_return := MSC_ST_UTIL.LOG_ERROR
202: (p_table_name => 'MSC_ST_SUPPLIES',
203: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
204: p_row => lv_column_names,
205: p_severity => MSC_CL_PRE_PROCESS.G_SEV_WARNING,

Line 218: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

214: IF lv_return <> 0 THEN
215: RAISE ex_logging_err;
216: END IF;
217:
218: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
219: (p_app_short_name => 'MSC',
220: p_error_code => 'MSC_PP_INVALID_VALUE',
221: p_message_text => lv_message_text,
222: p_error_text => lv_error_text,

Line 231: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID

227: RAISE ex_logging_err;
228: END IF;
229:
230: --Derive Organization_id
231: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
232: (p_table_name => 'MSC_ST_SUPPLIES',
233: p_org_partner_name => 'ORGANIZATION_CODE',
234: p_org_partner_id => 'ORGANIZATION_ID',
235: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,

Line 248: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

244: IF lv_return <> 0 THEN
245: RAISE ex_logging_err;
246: END IF;
247:
248: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
249: (p_app_short_name => 'MSC',
250: p_error_code => 'MSC_PP_INVALID_VALUE',
251: p_message_text => lv_message_text,
252: p_error_text => lv_error_text,

Line 261: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID

257: RAISE ex_logging_err;
258: END IF;
259:
260: --Derive Inventory_item_id
261: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
262: (p_table_name => 'MSC_ST_SUPPLIES',
263: p_item_col_name => 'ITEM_NAME',
264: p_item_col_id => 'INVENTORY_ITEM_ID',
265: p_instance_id => MSC_CL_PRE_PROCESS.v_instance_id,

Line 279: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

275: RAISE ex_logging_err;
276: END IF;
277:
278: --- error out the record if new_order_quantity is null
279: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
280: (p_app_short_name => 'MSC',
281: p_error_code => 'MSC_PP_COL_VAL_NULL',
282: p_message_text => lv_message_text,
283: p_error_text => lv_error_text,

Line 303: msc_st_util.log_message(lv_sql_stmt);

299: ||' AND NVL(batch_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||') = :lv_batch_id'
300: ||' AND sr_instance_code = :v_instance_code';
301:
302: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
303: msc_st_util.log_message(lv_sql_stmt);
304: END IF;
305:
306: EXECUTE IMMEDIATE lv_sql_stmt
307: USING lv_batch_id,

Line 311: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

307: USING lv_batch_id,
308: MSC_CL_PRE_PROCESS.v_instance_code;
309:
310: --- error out record which has new_schedule_date and ro_creation_date both as null
311: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
312: (p_app_short_name => 'MSC',
313: p_error_code => 'MSC_PP_COL_VAL_NULL',
314: p_message_text => lv_message_text,
315: p_error_text => lv_error_text,

Line 336: msc_st_util.log_message(lv_sql_stmt);

332: ||' AND NVL(batch_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||') = :lv_batch_id'
333: ||' AND sr_instance_code = :v_instance_code';
334:
335: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
336: msc_st_util.log_message(lv_sql_stmt);
337: END IF;
338:
339: EXECUTE IMMEDIATE lv_sql_stmt
340: USING lv_batch_id,

Line 344: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

340: USING lv_batch_id,
341: MSC_CL_PRE_PROCESS.v_instance_code;
342:
343: --- error out record if repair_number is null:
344: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
345: (p_app_short_name => 'MSC',
346: p_error_code => 'MSC_PP_COL_VAL_NULL',
347: p_message_text => lv_message_text,
348: p_error_text => lv_error_text,

Line 367: msc_st_util.log_message(lv_sql_stmt);

363: ||' AND NVL(batch_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||')= :lv_batch_id'
364: ||' AND sr_instance_code = :v_instance_code';
365:
366: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
367: msc_st_util.log_message(lv_sql_stmt);
368: END IF;
369:
370: EXECUTE IMMEDIATE lv_sql_stmt
371: USING lv_batch_id,

Line 390: msc_st_util.log_message(lv_sql_stmt);

386: ||' AND NVL(batch_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||') = :lv_batch_id'
387: ||' AND sr_instance_code = :v_instance_code';
388:
389: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
390: msc_st_util.log_message(lv_sql_stmt);
391: END IF;
392:
393: EXECUTE IMMEDIATE lv_sql_stmt
394: USING lv_batch_id,

Line 400: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

396:
397:
398: ---error out the record where repair line is null and deleted flag is SYS_YES
399:
400: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
401: (p_app_short_name => 'MSC',
402: p_error_code => 'MSC_PP_DELETE_FAIL',
403: p_message_text => lv_message_text,
404: p_error_text => lv_error_text);

Line 422: msc_st_util.log_message(lv_sql_stmt);

418: ||' AND NVL(batch_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||')= :lv_batch_id '
419: ||' AND sr_instance_code =:v_instance_code';
420:
421: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
422: msc_st_util.log_message(lv_sql_stmt);
423: END IF;
424:
425: EXECUTE IMMEDIATE lv_sql_stmt
426: USING lv_batch_id,

Line 430: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

426: USING lv_batch_id,
427: MSC_CL_PRE_PROCESS.v_instance_code;
428:
429: --- uom code validated
430: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
431: (p_app_short_name => 'MSC',
432: p_error_code => 'MSC_PP_COL_REF_NOT_EXIST',
433: p_message_text => lv_message_text,
434: p_error_text => lv_error_text,

Line 463: msc_st_util.log_message(lv_sql_stmt);

459: ||' AND mic.batch_id = :lv_batch_id'
460: ||' AND mic.process_flag = '||MSC_CL_PRE_PROCESS.G_IN_PROCESS ;
461:
462: IF MSC_CL_PRE_PROCESS.v_debug THEN
463: msc_st_util.log_message(lv_sql_stmt);
464: END IF;
465:
466: EXECUTE IMMEDIATE lv_sql_stmt
467: USING MSC_CL_PRE_PROCESS.v_instance_id,

Line 526: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID

522: WHERE rowid = lb_rowid(j);
523: END IF ;
524: close c2;
525: ---- validating project and task :
526: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
527: (p_table_name => 'MSC_ST_SUPPLIES',
528: p_proj_col_name => 'PROJECT_NUMBER',
529: p_proj_task_col_id => 'PROJECT_ID',
530: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,

Line 542: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

538: IF lv_return <> 0 THEN
539: RAISE ex_logging_err;
540: END IF;
541:
542: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
543: (p_app_short_name => 'MSC',
544: p_error_code => 'MSC_PP_FK_REF_NOT_EXIST',
545: p_message_text => lv_message_text,
546: p_error_text => lv_error_text,

Line 559: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID

555: RAISE ex_logging_err;
556: END IF;
557:
558: --Derive Task Id.
559: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
560: (p_table_name => 'MSC_ST_SUPPLIES',
561: p_proj_col_name => 'PROJECT_NUMBER',
562: p_proj_task_col_id => 'TASK_ID',
563: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,

Line 591: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG

587: IF NVL(lv_return,0) <> 0 THEN
588: RAISE ex_logging_err;
589: END IF;
590:
591: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
592: (p_table_name => 'MSC_ST_SUPPLIES',
593: p_instance_id => MSC_CL_PRE_PROCESS.v_instance_id,
594: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
595: p_process_flag => MSC_CL_PRE_PROCESS.G_VALID,

Line 604: lv_return := MSC_ST_UTIL.LOG_ERROR

600: IF lv_return <> 0 THEN
601: RAISE ex_logging_err;
602: END IF;
603:
604: lv_return := MSC_ST_UTIL.LOG_ERROR
605: (p_table_name => 'MSC_ST_SUPPLIES',
606: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
607: p_row => lv_column_names,
608: p_severity => MSC_CL_PRE_PROCESS.G_SEV_ERROR,

Line 628: msc_st_util.log_message(lv_error_text);

624: ||MSC_CL_PRE_PROCESS.v_sql_stmt||')'|| SQLERRM, 1, 240);
625: ROLLBACK ;
626:
627: WHEN ex_logging_err THEN
628: msc_st_util.log_message(lv_error_text);
629: ROLLBACK;
630:
631: WHEN OTHERS THEN
632: lv_error_text := substr('MSC_CL_PRE_PROCESS.MSC_ST_SUPPLIES '||'('

Line 634: msc_st_util.log_message(lv_error_text);

630:
631: WHEN OTHERS THEN
632: lv_error_text := substr('MSC_CL_PRE_PROCESS.MSC_ST_SUPPLIES '||'('
633: ||MSC_CL_PRE_PROCESS.v_sql_stmt||')'|| SQLERRM, 1, 240);
634: msc_st_util.log_message(lv_error_text);
635: ROLLBACK;
636:
637: END LOAD_IRO_SUPPLY;
638:

Line 661: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

657: AND sr_instance_code = MSC_CL_PRE_PROCESS.v_instance_code;
658:
659: BEGIN
660:
661: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
662: (p_app_short_name => 'MSC',
663: p_error_code => 'MSC_PP_DUP_REC_FOR_BATCH_LOAD',
664: p_message_text => lv_message_text,
665: p_error_text => lv_error_text);

Line 700: msc_st_util.log_message(lv_sql_stmt);

696: ||' AND msd1.message_id IS NULL';
697:
698:
699: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
700: msc_st_util.log_message(lv_sql_stmt);
701: END IF;
702:
703: EXECUTE IMMEDIATE lv_sql_stmt
704: USING MSC_CL_PRE_PROCESS.v_instance_code;

Line 745: msc_st_util.log_message(lv_sql_stmt);

741: ||' AND rownum <= '||MSC_CL_PRE_PROCESS.v_batch_size;
742:
743:
744: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
745: msc_st_util.log_message(lv_sql_stmt);
746: END IF;
747:
748: EXECUTE IMMEDIATE lv_sql_stmt
749: USING lv_batch_id,

Line 771: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

767: WHERE rowid = lb_rowid(j);
768:
769: -- set the error message
770:
771: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
772: (p_app_short_name => 'MSC',
773: p_error_code => 'MSC_PP_INVALID_COL_VALUE',
774: p_message_text => lv_message_text,
775: p_error_text => lv_error_text,

Line 790: lv_return := MSC_ST_UTIL.LOG_ERROR

786: ' AND NVL(deleted_flag,'||MSC_CL_PRE_PROCESS.NULL_VALUE||') '
787: ||' NOT IN(1,2)';
788: --Log a warning for those records where the deleted_flag has a value other
789: --than SYS_NO
790: lv_return := MSC_ST_UTIL.LOG_ERROR
791: (p_table_name => 'MSC_ST_DEMANDS',
792: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
793: p_row => lv_column_names,
794: p_severity => MSC_CL_PRE_PROCESS.G_SEV_WARNING,

Line 807: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

803: IF lv_return <> 0 THEN
804: RAISE ex_logging_err;
805: END IF;
806:
807: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
808: (p_app_short_name => 'MSC',
809: p_error_code => 'MSC_PP_INVALID_VALUE',
810: p_message_text => lv_message_text,
811: p_error_text => lv_error_text,

Line 820: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID

816: RAISE ex_logging_err;
817: END IF;
818:
819: --Derive Organization_id
820: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
821: (p_table_name => 'MSC_ST_DEMANDS',
822: p_org_partner_name => 'ORGANIZATION_CODE',
823: p_org_partner_id => 'ORGANIZATION_ID',
824: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,

Line 837: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

833: IF lv_return <> 0 THEN
834: RAISE ex_logging_err;
835: END IF;
836:
837: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
838: (p_app_short_name => 'MSC',
839: p_error_code => 'MSC_PP_INVALID_VALUE',
840: p_message_text => lv_message_text,
841: p_error_text => lv_error_text,

Line 850: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID

846: RAISE ex_logging_err;
847: END IF;
848:
849: --Derive Inventory_item_id
850: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
851: (p_table_name => 'MSC_ST_DEMANDS',
852: p_item_col_name => 'ITEM_NAME',
853: p_item_col_id => 'INVENTORY_ITEM_ID',
854: p_instance_id => MSC_CL_PRE_PROCESS.v_instance_id,

Line 868: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

864: RAISE ex_logging_err;
865: END IF;
866:
867: -- Set the message
868: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
869: (p_app_short_name => 'MSC',
870: p_error_code => 'MSC_PP_INVALID_VALUE',
871: p_message_text => lv_message_text,
872: p_error_text => lv_error_text,

Line 881: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID

877: RAISE ex_logging_err;
878: END IF;
879:
880: --Derive Inventory_item_id
881: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
882: (p_table_name => 'MSC_ST_DEMANDS',
883: p_item_col_name => 'USING_ASSEMBLY_ITEM_NAME',
884: p_item_col_id => 'USING_ASSEMBLY_ITEM_ID',
885: p_instance_id => MSC_CL_PRE_PROCESS.v_instance_id,

Line 900: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

896: END IF;
897:
898: --- error out records where USING_REQUIREMENT_QUANTITY is NULL and using_assembly_demand_date is NULL
899:
900: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
901: (p_app_short_name => 'MSC',
902: p_error_code => 'MSC_PP_COL_VAL_NULL',
903: p_message_text => lv_message_text,
904: p_error_text => lv_error_text,

Line 926: msc_st_util.log_message(lv_sql_stmt);

922: ||' AND NVL(batch_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||') = :lv_batch_id'
923: ||' AND sr_instance_code = :v_instance_code';
924:
925: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
926: msc_st_util.log_message(lv_sql_stmt);
927: END IF;
928:
929: EXECUTE IMMEDIATE lv_sql_stmt
930: USING lv_batch_id,

Line 934: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

930: USING lv_batch_id,
931: MSC_CL_PRE_PROCESS.v_instance_code;
932:
933: --- error out record if repair_number is null:
934: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
935: (p_app_short_name => 'MSC',
936: p_error_code => 'MSC_PP_COL_VAL_NULL',
937: p_message_text => lv_message_text,
938: p_error_text => lv_error_text,

Line 957: msc_st_util.log_message(lv_sql_stmt);

953: ||' AND NVL(batch_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||')= :lv_batch_id'
954: ||' AND sr_instance_code = :v_instance_code';
955:
956: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
957: msc_st_util.log_message(lv_sql_stmt);
958: END IF;
959:
960: EXECUTE IMMEDIATE lv_sql_stmt
961: USING lv_batch_id,

Line 980: msc_st_util.log_message(lv_sql_stmt);

976: ||' AND NVL(batch_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||') = :lv_batch_id'
977: ||' AND sr_instance_code = :v_instance_code';
978:
979: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
980: msc_st_util.log_message(lv_sql_stmt);
981: END IF;
982:
983: EXECUTE IMMEDIATE lv_sql_stmt
984: USING lv_batch_id,

Line 990: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

986:
987:
988: ---error out the record where repair line is null and deleted flag is SYS_YES
989:
990: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
991: (p_app_short_name => 'MSC',
992: p_error_code => 'MSC_PP_DELETE_FAIL',
993: p_message_text => lv_message_text,
994: p_error_text => lv_error_text);

Line 1012: msc_st_util.log_message(lv_sql_stmt);

1008: ||' AND NVL(batch_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||')= :lv_batch_id '
1009: ||' AND sr_instance_code =:v_instance_code';
1010:
1011: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
1012: msc_st_util.log_message(lv_sql_stmt);
1013: END IF;
1014:
1015: EXECUTE IMMEDIATE lv_sql_stmt
1016: USING lv_batch_id,

Line 1019: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

1015: EXECUTE IMMEDIATE lv_sql_stmt
1016: USING lv_batch_id,
1017: MSC_CL_PRE_PROCESS.v_instance_code;
1018: --- error out record if ITEM_TYPE_VALUE is null:
1019: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
1020: (p_app_short_name => 'MSC',
1021: p_error_code => 'MSC_PP_INVALID_VALUE',
1022: p_message_text => lv_message_text,
1023: p_error_text => lv_error_text,

Line 1042: msc_st_util.log_message(lv_sql_stmt);

1038: ||' AND NVL(batch_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||')= :lv_batch_id'
1039: ||' AND sr_instance_code = :v_instance_code';
1040:
1041: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
1042: msc_st_util.log_message(lv_sql_stmt);
1043: END IF;
1044:
1045: EXECUTE IMMEDIATE lv_sql_stmt
1046: USING lv_batch_id,

Line 1050: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID

1046: USING lv_batch_id,
1047: MSC_CL_PRE_PROCESS.v_instance_code;
1048:
1049: ---- validating project and task :
1050: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
1051: (p_table_name => 'MSC_ST_DEMANDS',
1052: p_proj_col_name => 'PROJECT_NUMBER',
1053: p_proj_task_col_id => 'PROJECT_ID',
1054: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,

Line 1066: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

1062: IF lv_return <> 0 THEN
1063: RAISE ex_logging_err;
1064: END IF;
1065:
1066: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
1067: (p_app_short_name => 'MSC',
1068: p_error_code => 'MSC_PP_FK_REF_NOT_EXIST',
1069: p_message_text => lv_message_text,
1070: p_error_text => lv_error_text,

Line 1083: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID

1079: RAISE ex_logging_err;
1080: END IF;
1081:
1082: --Derive Task Id.
1083: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
1084: (p_table_name => 'MSC_ST_DEMANDS',
1085: p_proj_col_name => 'PROJECT_NUMBER',
1086: p_proj_task_col_id => 'TASK_ID',
1087: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,

Line 1114: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG

1110: IF NVL(lv_return,0) <> 0 THEN
1111: RAISE ex_logging_err;
1112: END IF;
1113:
1114: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
1115: (p_table_name => 'MSC_ST_DEMANDS',
1116: p_instance_id => MSC_CL_PRE_PROCESS.v_instance_id,
1117: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
1118: p_process_flag => MSC_CL_PRE_PROCESS.G_VALID,

Line 1127: lv_return := MSC_ST_UTIL.LOG_ERROR

1123: IF lv_return <> 0 THEN
1124: RAISE ex_logging_err;
1125: END IF;
1126:
1127: lv_return := MSC_ST_UTIL.LOG_ERROR
1128: (p_table_name => 'MSC_ST_DEMANDS',
1129: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
1130: p_row => lv_column_names,
1131: p_severity => MSC_CL_PRE_PROCESS.G_SEV_ERROR,

Line 1151: msc_st_util.log_message(lv_error_text);

1147: ||MSC_CL_PRE_PROCESS.v_sql_stmt||')'|| SQLERRM, 1, 240);
1148: ROLLBACK ;
1149:
1150: WHEN ex_logging_err THEN
1151: msc_st_util.log_message(lv_error_text);
1152: ROLLBACK;
1153:
1154: WHEN OTHERS THEN
1155: lv_error_text := substr('MSC_CL_PRE_PROCESS.MSC_ST_DEMANDS '||'('

Line 1157: msc_st_util.log_message(lv_error_text);

1153:
1154: WHEN OTHERS THEN
1155: lv_error_text := substr('MSC_CL_PRE_PROCESS.MSC_ST_DEMANDS '||'('
1156: ||MSC_CL_PRE_PROCESS.v_sql_stmt||')'|| SQLERRM, 1, 240);
1157: msc_st_util.log_message(lv_error_text);
1158: ROLLBACK;
1159:
1160: END LOAD_IRO_DEMAND;
1161:

Line 1213: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

1209: AND deleted_flag = MSC_CL_PRE_PROCESS.SYS_NO;
1210:
1211: BEGIN
1212:
1213: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
1214: (p_app_short_name => 'MSC',
1215: p_error_code => 'MSC_PP_DUP_REC_FOR_XML',
1216: p_message_text => lv_message_text,
1217: p_error_text => lv_error_text);

Line 1247: msc_st_util.log_message(lv_sql_stmt);

1243: ||' AND mss1.sr_instance_code = :v_instance_code'
1244: ||' AND NVL(mss1.message_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||') <> '||MSC_CL_PRE_PROCESS.NULL_VALUE;
1245:
1246: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
1247: msc_st_util.log_message(lv_sql_stmt);
1248: END IF;
1249:
1250: EXECUTE IMMEDIATE lv_sql_stmt
1251: USING MSC_CL_PRE_PROCESS.v_instance_code;

Line 1254: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

1250: EXECUTE IMMEDIATE lv_sql_stmt
1251: USING MSC_CL_PRE_PROCESS.v_instance_code;
1252:
1253:
1254: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
1255: (p_app_short_name => 'MSC',
1256: p_error_code => 'MSC_PP_DUP_REC_FOR_BATCH_LOAD',
1257: p_message_text => lv_message_text,
1258: p_error_text => lv_error_text);

Line 1292: msc_st_util.log_message(lv_sql_stmt);

1288: ||' AND mss1.sr_instance_code = :v_instance_code'
1289: ||' AND NVL(mss1.message_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||') = '||MSC_CL_PRE_PROCESS.NULL_VALUE;
1290:
1291: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
1292: msc_st_util.log_message(lv_sql_stmt);
1293: END IF;
1294:
1295: EXECUTE IMMEDIATE lv_sql_stmt USING MSC_CL_PRE_PROCESS.v_instance_code;
1296:

Line 1347: msc_st_util.log_message(lv_sql_stmt);

1343: ||' AND NVL(batch_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||') = '||MSC_CL_PRE_PROCESS.NULL_VALUE
1344: ||' AND rownum <= '||MSC_CL_PRE_PROCESS.v_batch_size;
1345:
1346: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
1347: msc_st_util.log_message(lv_sql_stmt);
1348: END IF;
1349:
1350: EXECUTE IMMEDIATE lv_sql_stmt
1351: USING lv_batch_id,

Line 1371: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

1367: creation_date = MSC_CL_PRE_PROCESS.v_current_date,
1368: created_by = MSC_CL_PRE_PROCESS.v_current_user
1369: WHERE rowid = lb_rowid(j);
1370:
1371: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
1372: (p_app_short_name => 'MSC',
1373: p_error_code => 'MSC_PP_INVALID_COL_VALUE',
1374: p_message_text => lv_message_text,
1375: p_error_text => lv_error_text,

Line 1389: lv_return := MSC_ST_UTIL.LOG_ERROR

1385: lv_where_str :=
1386: ' AND NVL(deleted_flag,'||MSC_CL_PRE_PROCESS.NULL_VALUE||') NOT IN(1,2)';
1387: --Log a warning for those records where the deleted_flag has a value other
1388: --SYS_NO
1389: lv_return := MSC_ST_UTIL.LOG_ERROR
1390: (p_table_name => 'MSC_ST_SUPPLIES',
1391: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
1392: p_row => lv_column_names,
1393: p_severity => MSC_CL_PRE_PROCESS.G_SEV_WARNING,

Line 1406: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

1402: IF lv_return <> 0 THEN
1403: RAISE ex_logging_err;
1404: END IF;
1405:
1406: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
1407: (p_app_short_name => 'MSC',
1408: p_error_code => 'MSC_PP_INVALID_VALUE',
1409: p_message_text => lv_message_text,
1410: p_error_text => lv_error_text,

Line 1419: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID

1415: RAISE ex_logging_err;
1416: END IF;
1417:
1418: --Derive Organization_id
1419: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
1420: (p_table_name => 'MSC_ST_SUPPLIES',
1421: p_org_partner_name => 'ORGANIZATION_CODE',
1422: p_org_partner_id => 'ORGANIZATION_ID',
1423: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,

Line 1436: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

1432: IF lv_return <> 0 THEN
1433: RAISE ex_logging_err;
1434: END IF;
1435:
1436: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
1437: (p_app_short_name => 'MSC',
1438: p_error_code => 'MSC_PP_INVALID_VALUE',
1439: p_message_text => lv_message_text,
1440: p_error_text => lv_error_text,

Line 1449: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID

1445: RAISE ex_logging_err;
1446: END IF;
1447:
1448: --Derive Inventory_item_id
1449: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
1450: (p_table_name => 'MSC_ST_SUPPLIES',
1451: p_item_col_name => 'ITEM_NAME',
1452: p_item_col_id => 'INVENTORY_ITEM_ID',
1453: p_instance_id => MSC_CL_PRE_PROCESS.v_instance_id,

Line 1466: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

1462: IF lv_return <> 0 THEN
1463: RAISE ex_logging_err;
1464: END IF;
1465:
1466: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
1467: (p_app_short_name => 'MSC',
1468: p_error_code => 'MSC_PP_COL_VAL_NULL',
1469: p_message_text => lv_message_text,
1470: p_error_text => lv_error_text,

Line 1491: msc_st_util.log_message(lv_sql_stmt);

1487: ||' AND NVL(batch_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||') = :lv_batch_id'
1488: ||' AND sr_instance_code = :v_instance_code';
1489:
1490: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
1491: msc_st_util.log_message(lv_sql_stmt);
1492: END IF;
1493:
1494: EXECUTE IMMEDIATE lv_sql_stmt
1495: USING lv_batch_id,

Line 1498: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

1494: EXECUTE IMMEDIATE lv_sql_stmt
1495: USING lv_batch_id,
1496: MSC_CL_PRE_PROCESS.v_instance_code;
1497:
1498: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
1499: (p_app_short_name => 'MSC',
1500: p_error_code => 'MSC_PP_COL_VAL_NULL',
1501: p_message_text => lv_message_text,
1502: p_error_text => lv_error_text,

Line 1522: msc_st_util.log_message(lv_sql_stmt);

1518: ||' AND NVL(batch_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||')= :lv_batch_id'
1519: ||' AND sr_instance_code = :v_instance_code';
1520:
1521: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
1522: msc_st_util.log_message(lv_sql_stmt);
1523: END IF;
1524:
1525: EXECUTE IMMEDIATE lv_sql_stmt
1526: USING lv_batch_id,

Line 1529: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

1525: EXECUTE IMMEDIATE lv_sql_stmt
1526: USING lv_batch_id,
1527: MSC_CL_PRE_PROCESS.v_instance_code;
1528:
1529: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
1530: (p_app_short_name => 'MSC',
1531: p_error_code => 'MSC_PP_INVALID_COL_VALUE',
1532: p_message_text => lv_message_text,
1533: p_error_text => lv_error_text,

Line 1550: lv_return := MSC_ST_UTIL.LOG_ERROR

1546:
1547: --Log a warning for those records where the firm_planned_type has a value
1548: --other than 1 and 2
1549:
1550: lv_return := MSC_ST_UTIL.LOG_ERROR
1551: (p_table_name => 'MSC_ST_SUPPLIES',
1552: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
1553: p_row => lv_column_names,
1554: p_severity => MSC_CL_PRE_PROCESS.G_SEV_WARNING,

Line 1567: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

1563: IF lv_return <> 0 THEN
1564: RAISE ex_logging_err;
1565: END IF;
1566:
1567: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
1568: (p_app_short_name => 'MSC',
1569: p_error_code => 'MSC_PP_INVALID_COL_VALUE',
1570: p_message_text => lv_message_text,
1571: p_error_text => lv_error_text,

Line 1588: lv_return := MSC_ST_UTIL.LOG_ERROR

1584:
1585: --Log a warning for those records where the wip_status_code has a value other
1586: --than SYS_NO
1587:
1588: lv_return := MSC_ST_UTIL.LOG_ERROR
1589: (p_table_name => 'MSC_ST_SUPPLIES',
1590: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
1591: p_row => lv_column_names,
1592: p_severity => MSC_CL_PRE_PROCESS.G_SEV_WARNING,

Line 1605: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

1601: IF lv_return <> 0 THEN
1602: RAISE ex_logging_err;
1603: END IF;
1604:
1605: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
1606: (p_app_short_name => 'MSC',
1607: p_error_code => 'MSC_PP_INVALID_COL_VALUE',
1608: p_message_text => lv_message_text,
1609: p_error_text => lv_error_text,

Line 1626: lv_return := MSC_ST_UTIL.LOG_ERROR

1622:
1623: --Log a warning for those records where the firm_planned_type has a value other
1624: --than SYS_NO
1625:
1626: lv_return := MSC_ST_UTIL.LOG_ERROR
1627: (p_table_name => 'MSC_ST_SUPPLIES',
1628: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
1629: p_row => lv_column_names,
1630: p_severity => MSC_CL_PRE_PROCESS.G_SEV_WARNING,

Line 1643: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

1639: IF lv_return <> 0 THEN
1640: RAISE ex_logging_err;
1641: END IF;
1642:
1643: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
1644: (p_app_short_name => 'MSC',
1645: p_error_code => 'MSC_PP_INVALID_COL_VALUE',
1646: p_message_text => lv_message_text,
1647: p_error_text => lv_error_text,

Line 1664: lv_return := MSC_ST_UTIL.LOG_ERROR

1660:
1661: --Log a warning for those records where the wip_supply_type has a value other
1662: --than SYS_NO
1663:
1664: lv_return := MSC_ST_UTIL.LOG_ERROR
1665: (p_table_name => 'MSC_ST_SUPPLIES',
1666: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
1667: p_row => lv_column_names,
1668: p_severity => MSC_CL_PRE_PROCESS.G_SEV_WARNING,

Line 1693: msc_st_util.log_message(lv_sql_stmt);

1689: ||' AND NVL(batch_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||') = :lv_batch_id'
1690: ||' AND sr_instance_code = :v_instance_code';
1691:
1692: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
1693: msc_st_util.log_message(lv_sql_stmt);
1694: END IF;
1695:
1696: EXECUTE IMMEDIATE lv_sql_stmt
1697: USING lv_batch_id,

Line 1717: msc_st_util.log_message(lv_sql_stmt);

1713: ||' <> '||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''
1714: ||' AND batch_id = :lv_batch_id';
1715:
1716: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
1717: msc_st_util.log_message(lv_sql_stmt);
1718: END IF;
1719:
1720: EXECUTE IMMEDIATE lv_sql_stmt USING MSC_CL_PRE_PROCESS.v_instance_code,lv_batch_id;
1721:

Line 1740: msc_st_util.log_message(lv_sql_stmt);

1736: ||' <> '||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''
1737: ||' AND batch_id = :lv_batch_id ';
1738:
1739: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
1740: msc_st_util.log_message(lv_sql_stmt);
1741: END IF;
1742:
1743: EXECUTE IMMEDIATE lv_sql_stmt USING MSC_CL_PRE_PROCESS.v_instance_code,lv_batch_id;
1744:

Line 1745: lv_return := MSC_ST_UTIL.DERIVE_BILL_SEQUENCE_ID

1741: END IF;
1742:
1743: EXECUTE IMMEDIATE lv_sql_stmt USING MSC_CL_PRE_PROCESS.v_instance_code,lv_batch_id;
1744:
1745: lv_return := MSC_ST_UTIL.DERIVE_BILL_SEQUENCE_ID
1746: (p_table_name => 'MSC_ST_SUPPLIES',
1747: p_bom_col_name => 'BILL_NAME',
1748: p_bom_col_id => 'BILL_SEQUENCE_ID',
1749: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,

Line 1759: lv_return := MSC_ST_UTIL.DERIVE_ROUTING_SEQUENCE_ID

1755: IF (lv_return <> 0 ) THEN
1756: RAISE ex_logging_err;
1757: END IF;
1758:
1759: lv_return := MSC_ST_UTIL.DERIVE_ROUTING_SEQUENCE_ID
1760: (p_table_name => 'MSC_ST_SUPPLIES',
1761: p_rtg_col_name => 'ROUTING_NAME',
1762: p_rtg_col_id => 'ROUTING_SEQUENCE_ID',
1763: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,

Line 1812: msc_st_util.log_message(lv_sql_stmt);

1808: ||' AND NVL(batch_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||')= :lv_batch_id'
1809: ||' AND sr_instance_code = :v_instance_code';
1810:
1811: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
1812: msc_st_util.log_message(lv_sql_stmt);
1813: END IF;
1814:
1815: EXECUTE IMMEDIATE lv_sql_stmt
1816: USING lv_batch_id,

Line 1820: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

1816: USING lv_batch_id,
1817: MSC_CL_PRE_PROCESS.v_instance_code;
1818:
1819:
1820: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
1821: (p_app_short_name => 'MSC',
1822: p_error_code => 'MSC_PP_INVALID_COL_VALUE',
1823: p_message_text => lv_message_text,
1824: p_error_text => lv_error_text,

Line 1842: lv_return := MSC_ST_UTIL.LOG_ERROR

1838:
1839: --Log a warning for those records where the bill_sequence_id or
1840: --routing_sequence_id has null values
1841:
1842: lv_return := MSC_ST_UTIL.LOG_ERROR
1843: (p_table_name => 'MSC_ST_SUPPLIES',
1844: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
1845: p_row => lv_column_names,
1846: p_severity => MSC_CL_PRE_PROCESS.G_SEV_WARNING,

Line 1874: msc_st_util.log_message(lv_sql_stmt);

1870: ||' AND NVL(batch_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||') = :lv_batch_id'
1871: ||' AND sr_instance_code = :v_instance_code';
1872:
1873: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
1874: msc_st_util.log_message(lv_sql_stmt);
1875: END IF;
1876:
1877: EXECUTE IMMEDIATE lv_sql_stmt
1878: USING lv_batch_id,

Line 1882: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

1878: USING lv_batch_id,
1879: MSC_CL_PRE_PROCESS.v_instance_code;
1880:
1881:
1882: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
1883: (p_app_short_name => 'MSC',
1884: p_error_code => 'MSC_PP_DELETE_FAIL',
1885: p_message_text => lv_message_text,
1886: p_error_text => lv_error_text);

Line 1905: msc_st_util.log_message(lv_sql_stmt);

1901: ||' AND NVL(batch_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||')= :lv_batch_id '
1902: ||' AND sr_instance_code =:v_instance_code';
1903:
1904: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
1905: msc_st_util.log_message(lv_sql_stmt);
1906: END IF;
1907:
1908: EXECUTE IMMEDIATE lv_sql_stmt
1909: USING lv_batch_id,

Line 1926: msc_st_util.log_message(lv_sql_stmt);

1922: ||' AND order_type =86'
1923: ||' AND sr_instance_code =:v_instance_code';
1924:
1925: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
1926: msc_st_util.log_message(lv_sql_stmt);
1927: END IF;
1928:
1929: EXECUTE IMMEDIATE lv_sql_stmt
1930: USING lv_batch_id,

Line 1957: msc_st_util.log_message(lv_sql_stmt);

1953: ||' AND sr_instance_code = :v_instance_code';
1954:
1955:
1956: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
1957: msc_st_util.log_message(lv_sql_stmt);
1958: END IF;
1959:
1960: EXECUTE IMMEDIATE lv_sql_stmt
1961: USING lv_batch_id,

Line 2104: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

2100: WHERE process_flag = MSC_CL_PRE_PROCESS.G_IN_PROCESS
2101: AND batch_id = lv_batch_id
2102: AND sr_instance_code = MSC_CL_PRE_PROCESS.v_instance_code;
2103:
2104: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
2105: (p_app_short_name => 'MSC',
2106: p_error_code => 'MSC_PP_FK_REF_NOT_EXIST',
2107: p_message_text => lv_message_text,
2108: p_error_text => lv_error_text,

Line 2120: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID

2116: RAISE ex_logging_err;
2117: END IF;
2118:
2119: --Derive Project Id.
2120: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
2121: (p_table_name => 'MSC_ST_SUPPLIES',
2122: p_proj_col_name => 'PROJECT_NUMBER',
2123: p_proj_task_col_id => 'PROJECT_ID',
2124: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,

Line 2136: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

2132: IF lv_return <> 0 THEN
2133: RAISE ex_logging_err;
2134: END IF;
2135:
2136: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
2137: (p_app_short_name => 'MSC',
2138: p_error_code => 'MSC_PP_FK_REF_NOT_EXIST',
2139: p_message_text => lv_message_text,
2140: p_error_text => lv_error_text,

Line 2153: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID

2149: RAISE ex_logging_err;
2150: END IF;
2151:
2152: --Derive Task Id.
2153: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
2154: (p_table_name => 'MSC_ST_SUPPLIES',
2155: p_proj_col_name => 'PROJECT_NUMBER',
2156: p_proj_task_col_id => 'TASK_ID',
2157: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,

Line 2190: msc_st_util.log_message(lv_sql_stmt);

2186: ||' AND NVL(batch_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||')= :lv_batch_id'
2187: ||' AND sr_instance_code = :v_instance_code';
2188:
2189: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
2190: msc_st_util.log_message(lv_sql_stmt);
2191: END IF;
2192:
2193: EXECUTE IMMEDIATE lv_sql_stmt
2194: USING lv_batch_id,

Line 2212: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG

2208: WHERE rowid = lb_rowid(j);
2209: END IF;
2210: CLOSE c4;
2211:
2212: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
2213: (p_table_name => 'MSC_ST_SUPPLIES',
2214: p_instance_id => MSC_CL_PRE_PROCESS.v_instance_id,
2215: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
2216: p_process_flag => MSC_CL_PRE_PROCESS.G_VALID,

Line 2224: lv_return := MSC_ST_UTIL.LOG_ERROR

2220: IF lv_return <> 0 THEN
2221: RAISE ex_logging_err;
2222: END IF;
2223:
2224: lv_return := MSC_ST_UTIL.LOG_ERROR
2225: (p_table_name => 'MSC_ST_SUPPLIES',
2226: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
2227: p_row => lv_column_names,
2228: p_severity => MSC_CL_PRE_PROCESS.G_SEV_ERROR,

Line 2244: msc_st_util.log_message(lv_error_text);

2240: EXCEPTION
2241: WHEN too_many_rows THEN
2242: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ERO_SUPPLY'||'('
2243: ||MSC_CL_PRE_PROCESS.v_sql_stmt||')'|| SQLERRM, 1, 240);
2244: msc_st_util.log_message(lv_error_text);
2245: ROLLBACK;
2246:
2247: WHEN ex_logging_err THEN
2248: msc_st_util.log_message(lv_error_text);

Line 2248: msc_st_util.log_message(lv_error_text);

2244: msc_st_util.log_message(lv_error_text);
2245: ROLLBACK;
2246:
2247: WHEN ex_logging_err THEN
2248: msc_st_util.log_message(lv_error_text);
2249: ROLLBACK;
2250:
2251: WHEN OTHERS THEN
2252: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_WO_SUPPLY'||'('

Line 2254: msc_st_util.log_message(lv_error_text);

2250:
2251: WHEN OTHERS THEN
2252: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_WO_SUPPLY'||'('
2253: ||MSC_CL_PRE_PROCESS.v_sql_stmt||')'|| SQLERRM, 1, 240);
2254: msc_st_util.log_message(lv_error_text);
2255: ROLLBACK;
2256:
2257: END LOAD_ERO_SUPPLY;
2258:

Line 2310: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

2306:
2307: --For WIP component demand
2308:
2309: --Duplicate records check for the records whose source is XML
2310: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
2311: (p_app_short_name => 'MSC',
2312: p_error_code => 'MSC_PP_DUP_REC_FOR_XML',
2313: p_message_text => lv_message_text,
2314: p_error_text => lv_error_text);

Line 2350: msc_st_util.log_message(lv_sql_stmt);

2346: ||' AND msd1.sr_instance_code = :v_instance_code '
2347: ||' AND NVL(msd1.message_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||')<> '||MSC_CL_PRE_PROCESS.NULL_VALUE;
2348:
2349: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
2350: msc_st_util.log_message(lv_sql_stmt);
2351: END IF;
2352:
2353: EXECUTE IMMEDIATE lv_sql_stmt USING MSC_CL_PRE_PROCESS.v_instance_code;
2354:

Line 2357: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

2353: EXECUTE IMMEDIATE lv_sql_stmt USING MSC_CL_PRE_PROCESS.v_instance_code;
2354:
2355: --Duplicate records check for the records whose source is batch load
2356:
2357: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
2358: (p_app_short_name => 'MSC',
2359: p_error_code => 'MSC_PP_DUP_REC_FOR_BATCH_LOAD',
2360: p_message_text => lv_message_text,
2361: p_error_text => lv_error_text);

Line 2400: msc_st_util.log_message(lv_sql_stmt);

2396: ||' AND msd1.sr_instance_code = :v_instance_code'
2397: ||' AND NVL(msd1.message_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||') = '||MSC_CL_PRE_PROCESS.NULL_VALUE;
2398:
2399: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
2400: msc_st_util.log_message(lv_sql_stmt);
2401: END IF;
2402:
2403: EXECUTE IMMEDIATE lv_sql_stmt USING MSC_CL_PRE_PROCESS.v_instance_code;
2404:

Line 2446: msc_st_util.log_message(lv_sql_stmt);

2442: ||' AND rownum <= '||MSC_CL_PRE_PROCESS.v_batch_size;
2443:
2444:
2445: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
2446: msc_st_util.log_message(lv_sql_stmt);
2447: END IF;
2448:
2449: EXECUTE IMMEDIATE lv_sql_stmt
2450: USING lv_batch_id,

Line 2471: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

2467: created_by = MSC_CL_PRE_PROCESS.v_current_user
2468: WHERE rowid = lb_rowid(j);
2469:
2470: -- Set the error message
2471: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
2472: (p_app_short_name => 'MSC',
2473: p_error_code => 'MSC_PP_INVALID_COL_VALUE',
2474: p_message_text => lv_message_text,
2475: p_error_text => lv_error_text,

Line 2490: lv_return := MSC_ST_UTIL.LOG_ERROR

2486:
2487: lv_where_str :=
2488: ' AND NVL(deleted_flag,'||MSC_CL_PRE_PROCESS.NULL_VALUE||') NOT IN(1,2)';
2489:
2490: lv_return := MSC_ST_UTIL.LOG_ERROR
2491: (p_table_name => 'MSC_ST_DEMANDS',
2492: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
2493: p_row => lv_column_names,
2494: p_severity => MSC_CL_PRE_PROCESS.G_SEV_WARNING,

Line 2508: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

2504: RAISE ex_logging_err;
2505: END IF;
2506:
2507: -- Set the message
2508: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
2509: (p_app_short_name => 'MSC',
2510: p_error_code => 'MSC_PP_INVALID_VALUE',
2511: p_message_text => lv_message_text,
2512: p_error_text => lv_error_text,

Line 2521: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID

2517: RAISE ex_logging_err;
2518: END IF;
2519:
2520: --Derive Organization_id
2521: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
2522: (p_table_name => 'MSC_ST_DEMANDS',
2523: p_org_partner_name => 'ORGANIZATION_CODE',
2524: p_org_partner_id => 'ORGANIZATION_ID',
2525: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,

Line 2539: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

2535: RAISE ex_logging_err;
2536: END IF;
2537:
2538: -- Set the message
2539: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
2540: (p_app_short_name => 'MSC',
2541: p_error_code => 'MSC_PP_INVALID_VALUE',
2542: p_message_text => lv_message_text,
2543: p_error_text => lv_error_text,

Line 2552: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID

2548: RAISE ex_logging_err;
2549: END IF;
2550:
2551: --Derive Inventory_item_id
2552: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
2553: (p_table_name => 'MSC_ST_DEMANDS',
2554: p_item_col_name => 'ITEM_NAME',
2555: p_item_col_id => 'INVENTORY_ITEM_ID',
2556: p_instance_id => MSC_CL_PRE_PROCESS.v_instance_id,

Line 2570: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

2566: RAISE ex_logging_err;
2567: END IF;
2568:
2569: -- Set the message
2570: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
2571: (p_app_short_name => 'MSC',
2572: p_error_code => 'MSC_PP_INVALID_VALUE',
2573: p_message_text => lv_message_text,
2574: p_error_text => lv_error_text,

Line 2583: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID

2579: RAISE ex_logging_err;
2580: END IF;
2581:
2582: --Derive Using_assembly_item_id
2583: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
2584: (p_table_name => 'MSC_ST_DEMANDS',
2585: p_item_col_name => 'USING_ASSEMBLY_ITEM_NAME',
2586: p_item_col_id => 'USING_ASSEMBLY_ITEM_ID',
2587: p_instance_id => MSC_CL_PRE_PROCESS.v_instance_id,

Line 2620: msc_st_util.log_message(lv_sql_stmt);

2616: ||' AND batch_id = :lv_batch_id'
2617: ||' AND sr_instance_code =:v_instance_code';
2618:
2619: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
2620: msc_st_util.log_message(lv_sql_stmt);
2621: END IF;
2622:
2623: EXECUTE IMMEDIATE lv_sql_stmt USING lv_batch_id,MSC_CL_PRE_PROCESS.v_instance_code;
2624:

Line 2626: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

2622:
2623: EXECUTE IMMEDIATE lv_sql_stmt USING lv_batch_id,MSC_CL_PRE_PROCESS.v_instance_code;
2624:
2625: -- Set the error message
2626: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
2627: (p_app_short_name => 'MSC',
2628: p_error_code => 'MSC_PP_COL_REF_NOT_EXIST',
2629: p_message_text => lv_message_text,
2630: p_error_text => lv_error_text,

Line 2658: msc_st_util.log_message(lv_sql_stmt);

2654: ||' AND batch_id = :lv_batch_id'
2655: ||' AND sr_instance_code = :v_instance_code';
2656:
2657: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
2658: msc_st_util.log_message(lv_sql_stmt);
2659: END IF;
2660:
2661: EXECUTE IMMEDIATE lv_sql_stmt USING lv_batch_id,MSC_CL_PRE_PROCESS.v_instance_code;
2662:

Line 2665: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

2661: EXECUTE IMMEDIATE lv_sql_stmt USING lv_batch_id,MSC_CL_PRE_PROCESS.v_instance_code;
2662:
2663:
2664: -- Set the message
2665: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
2666: (p_app_short_name => 'MSC',
2667: p_error_code => 'MSC_PP_COL_VAL_NULL',
2668: p_message_text => lv_message_text,
2669: p_error_text => lv_error_text,

Line 2697: msc_st_util.log_message(lv_sql_stmt);

2693: ||' AND batch_id = :lv_batch_id'
2694: ||' AND sr_instance_code = :v_instance_code';
2695:
2696: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
2697: msc_st_util.log_message(lv_sql_stmt);
2698: END IF;
2699:
2700: EXECUTE IMMEDIATE lv_sql_stmt USING lv_batch_id,MSC_CL_PRE_PROCESS.v_instance_code;
2701:

Line 2720: msc_st_util.log_message(lv_sql_stmt);

2716: ||' AND deleted_flag = '||MSC_CL_PRE_PROCESS.SYS_NO
2717: ||' AND sr_instance_code = :v_instance_code';
2718:
2719: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
2720: msc_st_util.log_message(lv_sql_stmt);
2721: END IF;
2722:
2723: EXECUTE IMMEDIATE lv_sql_stmt USING lv_batch_id,MSC_CL_PRE_PROCESS.v_instance_code;
2724:

Line 2741: msc_st_util.log_message(lv_sql_stmt);

2737: ||' AND batch_id = :lv_batch_id'
2738: ||' AND sr_instance_code = :v_instance_code';
2739:
2740: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
2741: msc_st_util.log_message(lv_sql_stmt);
2742: END IF;
2743:
2744: EXECUTE IMMEDIATE lv_sql_stmt USING lv_batch_id,MSC_CL_PRE_PROCESS.v_instance_code;
2745:

Line 2762: msc_st_util.log_message(lv_sql_stmt);

2758: ||' AND batch_id = :lv_batch_id'
2759: ||' AND sr_instance_code = :v_instance_code';
2760:
2761: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
2762: msc_st_util.log_message(lv_sql_stmt);
2763: END IF;
2764:
2765: EXECUTE IMMEDIATE lv_sql_stmt USING lv_batch_id,MSC_CL_PRE_PROCESS.v_instance_code;
2766:

Line 2786: msc_st_util.log_message(lv_sql_stmt);

2782: ||' AND batch_id = :lv_batch_id'
2783: ||' AND sr_instance_code = :v_instance_code';
2784:
2785: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
2786: msc_st_util.log_message(lv_sql_stmt);
2787: END IF;
2788:
2789: EXECUTE IMMEDIATE lv_sql_stmt USING lv_batch_id,MSC_CL_PRE_PROCESS.v_instance_code;
2790:

Line 2793: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

2789: EXECUTE IMMEDIATE lv_sql_stmt USING lv_batch_id,MSC_CL_PRE_PROCESS.v_instance_code;
2790:
2791:
2792: -- Set the error message
2793: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
2794: (p_app_short_name => 'MSC',
2795: p_error_code => 'MSC_PP_INVALID_COL_VALUE',
2796: p_message_text => lv_message_text,
2797: p_error_text => lv_error_text,

Line 2814: lv_return := MSC_ST_UTIL.LOG_ERROR

2810: ||' = '||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''
2811: ||' AND origination_type =77'
2812: ||' AND ENTITY=''ERO''';
2813:
2814: lv_return := MSC_ST_UTIL.LOG_ERROR
2815: (p_table_name => 'MSC_ST_DEMANDS',
2816: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
2817: p_row => lv_column_names,
2818: p_severity => MSC_CL_PRE_PROCESS.G_SEV_WARNING,

Line 2832: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

2828: RAISE ex_logging_err;
2829: END IF;
2830:
2831: -- Set the error message
2832: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
2833: (p_app_short_name => 'MSC',
2834: p_error_code => 'MSC_PP_COL_VAL_NULL_DEFAULT',
2835: p_message_text => lv_message_text,
2836: p_error_text => lv_error_text,

Line 2853: lv_return := MSC_ST_UTIL.LOG_ERROR

2849: ' AND NVL(operation_effectivity_date,SYSDATE-36500 ) = SYSDATE-36500 '
2850: ||' AND origination_type =77'
2851: ||' AND ENTITY=''ERO''' ;
2852:
2853: lv_return := MSC_ST_UTIL.LOG_ERROR
2854: (p_table_name => 'MSC_ST_DEMANDS',
2855: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
2856: p_row => lv_column_names,
2857: p_severity => MSC_CL_PRE_PROCESS.G_SEV_WARNING,

Line 2886: msc_st_util.log_message(lv_sql_stmt);

2882: ||' AND batch_id = :lv_batch_id'
2883: ||' AND sr_instance_code = :v_instance_code';
2884:
2885: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
2886: msc_st_util.log_message(lv_sql_stmt);
2887: END IF;
2888:
2889: EXECUTE IMMEDIATE lv_sql_stmt USING lv_batch_id,MSC_CL_PRE_PROCESS.v_instance_code;
2890:

Line 2896: lv_return :=msc_st_util.derive_routing_sequence_id

2892: IF MSC_CL_PRE_PROCESS.v_instance_type <> MSC_CL_PRE_PROCESS.G_INS_OTHER THEN
2893:
2894: -- Derive the ROUTING_SEQUENCE_ID from LOCAL ID table
2895:
2896: lv_return :=msc_st_util.derive_routing_sequence_id
2897: (p_table_name => 'MSC_ST_DEMANDS',
2898: p_rtg_col_name => 'ROUTING_NAME',
2899: p_rtg_col_id =>'ROUTING_SEQUENCE_ID',
2900: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,

Line 2907: msc_st_util.log_message(lv_error_text);

2903: p_error_text => lv_error_text,
2904: p_item_id => 'using_assembly_item_id');
2905:
2906: if (lv_return <> 0 )then
2907: msc_st_util.log_message(lv_error_text);
2908: end if;
2909:
2910: MSC_CL_PRE_PROCESS.v_sql_stmt := 11;
2911: lv_sql_stmt:=

Line 2928: msc_st_util.log_message(lv_sql_stmt);

2924: ||' AND process_flag = '|| MSC_CL_PRE_PROCESS.G_IN_PROCESS
2925: ||' AND batch_id = :lv_batch_id ';
2926:
2927: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
2928: msc_st_util.log_message(lv_sql_stmt);
2929: END IF;
2930:
2931: EXECUTE IMMEDIATE lv_sql_stmt USING MSC_CL_PRE_PROCESS.v_instance_code,lv_batch_id;
2932: END IF;

Line 2958: msc_st_util.log_message(lv_sql_stmt);

2954: ||' AND operation_seq_num is null'; /* bug 3768813 */
2955:
2956:
2957: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
2958: msc_st_util.log_message(lv_sql_stmt);
2959: END IF;
2960:
2961: EXECUTE IMMEDIATE lv_sql_stmt USING MSC_CL_PRE_PROCESS.v_instance_code,lv_batch_id;
2962:

Line 2965: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

2961: EXECUTE IMMEDIATE lv_sql_stmt USING MSC_CL_PRE_PROCESS.v_instance_code,lv_batch_id;
2962:
2963: -- Set the message
2964:
2965: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
2966: (p_app_short_name => 'MSC',
2967: p_error_code => 'MSC_PP_DELETE_FAIL',
2968: p_message_text => lv_message_text,
2969: p_error_text => lv_error_text);

Line 2992: msc_st_util.log_message(lv_sql_stmt);

2988: ||' AND batch_id = :lv_batch_id'
2989: ||' AND sr_instance_code =:v_instance_code';
2990:
2991: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
2992: msc_st_util.log_message(lv_sql_stmt);
2993: END IF;
2994:
2995: EXECUTE IMMEDIATE lv_sql_stmt USING lv_batch_id,MSC_CL_PRE_PROCESS.v_instance_code;
2996:

Line 2998: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

2994:
2995: EXECUTE IMMEDIATE lv_sql_stmt USING lv_batch_id,MSC_CL_PRE_PROCESS.v_instance_code;
2996:
2997: -- Set the error message
2998: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
2999: (p_app_short_name => 'MSC',
3000: p_error_code => 'MSC_PP_FK_REF_NOT_EXIST',
3001: p_message_text => lv_message_text,
3002: p_error_text => lv_error_text,

Line 3014: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID

3010: RAISE ex_logging_err;
3011: END IF;
3012:
3013: --Derive Project Id.
3014: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
3015: (p_table_name => 'MSC_ST_DEMANDS',
3016: p_proj_col_name => 'PROJECT_NUMBER',
3017: p_proj_task_col_id => 'PROJECT_ID',
3018: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,

Line 3031: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

3027: RAISE ex_logging_err;
3028: END IF;
3029:
3030: -- Set the error message
3031: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
3032: (p_app_short_name => 'MSC',
3033: p_error_code => 'MSC_PP_FK_REF_NOT_EXIST',
3034: p_message_text => lv_message_text,
3035: p_error_text => lv_error_text,

Line 3048: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID

3044: RAISE ex_logging_err;
3045: END IF;
3046:
3047: --Derive Task Id.
3048: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
3049: (p_table_name => 'MSC_ST_DEMANDS',
3050: p_proj_col_name => 'PROJECT_NUMBER',
3051: p_proj_task_col_id => 'TASK_ID',
3052: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,

Line 3067: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

3063: RAISE ex_logging_err;
3064: END IF;
3065:
3066: -- Set the error message
3067: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
3068: (p_app_short_name => 'MSC',
3069: p_error_code => 'MSC_PP_INVALID_COL_VALUE',
3070: p_message_text => lv_message_text,
3071: p_error_text => lv_error_text,

Line 3087: lv_return := MSC_ST_UTIL.LOG_ERROR

3083: lv_where_str := ' AND NVL(demand_type,'||MSC_CL_PRE_PROCESS.NULL_VALUE||') <> '||MSC_CL_PRE_PROCESS.G_DEMAND_TYPE
3084: ||' AND origination_type =77 AND deleted_flag ='||MSC_CL_PRE_PROCESS.SYS_NO
3085: ||' AND ENTITY=''ERO''' ;
3086:
3087: lv_return := MSC_ST_UTIL.LOG_ERROR
3088: (p_table_name => 'MSC_ST_DEMANDS',
3089: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
3090: p_row => lv_column_names,
3091: p_severity => MSC_CL_PRE_PROCESS.G_SEV_WARNING,

Line 3106: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

3102: END IF;
3103:
3104:
3105: -- Set the error message
3106: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
3107: (p_app_short_name => 'MSC',
3108: p_error_code => 'MSC_PP_INVALID_COL_VALUE',
3109: p_message_text => lv_message_text,
3110: p_error_text => lv_error_text,

Line 3126: lv_return := MSC_ST_UTIL.LOG_ERROR

3122: lv_where_str := ' AND NVL(wip_supply_type,'||MSC_CL_PRE_PROCESS.NULL_VALUE||') NOT IN (1,2,3,4,5,6,7)'
3123: ||' AND origination_type =77 AND deleted_flag ='||MSC_CL_PRE_PROCESS.SYS_NO
3124: ||' AND ENTITY=''ERO''' ;
3125:
3126: lv_return := MSC_ST_UTIL.LOG_ERROR
3127: (p_table_name => 'MSC_ST_DEMANDS',
3128: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
3129: p_row => lv_column_names,
3130: p_severity => MSC_CL_PRE_PROCESS.G_SEV_WARNING,

Line 3145: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

3141: END IF;
3142:
3143:
3144: -- Set the error message
3145: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
3146: (p_app_short_name => 'MSC',
3147: p_error_code => 'MSC_PP_INVALID_COL_VALUE',
3148: p_message_text => lv_message_text,
3149: p_error_text => lv_error_text,

Line 3165: lv_return := MSC_ST_UTIL.LOG_ERROR

3161: lv_where_str := ' AND NVL(wip_status_code,'||MSC_CL_PRE_PROCESS.NULL_VALUE||') NOT IN (1,3,4,6,7,12)'
3162: ||' AND origination_type =77 AND deleted_flag ='||MSC_CL_PRE_PROCESS.SYS_NO
3163: ||' AND ENTITY=''ERO''' ;
3164:
3165: lv_return := MSC_ST_UTIL.LOG_ERROR
3166: (p_table_name => 'MSC_ST_DEMANDS',
3167: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
3168: p_row => lv_column_names,
3169: p_severity => MSC_CL_PRE_PROCESS.G_SEV_WARNING,

Line 3298: msc_st_util.log_message(lv_sql_stmt);

3294: ||' AND batch_id = :lv_batch_id';
3295:
3296:
3297: IF MSC_CL_PRE_PROCESS.V_DEBUG THEN
3298: msc_st_util.log_message(lv_sql_stmt);
3299: END IF;
3300:
3301: EXECUTE IMMEDIATE lv_sql_stmt USING MSC_CL_PRE_PROCESS.v_instance_code,lv_batch_id;
3302:

Line 3304: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG

3300:
3301: EXECUTE IMMEDIATE lv_sql_stmt USING MSC_CL_PRE_PROCESS.v_instance_code,lv_batch_id;
3302:
3303:
3304: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
3305: (p_table_name => 'MSC_ST_DEMANDS',
3306: p_instance_id => MSC_CL_PRE_PROCESS.v_instance_id,
3307: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
3308: p_process_flag => MSC_CL_PRE_PROCESS.G_VALID,

Line 3317: lv_return := MSC_ST_UTIL.LOG_ERROR

3313: IF lv_return <> 0 THEN
3314: RAISE ex_logging_err;
3315: END IF;
3316:
3317: lv_return := MSC_ST_UTIL.LOG_ERROR
3318: (p_table_name => 'MSC_ST_DEMANDS',
3319: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
3320: p_row => lv_column_names,
3321: p_severity => MSC_CL_PRE_PROCESS.G_SEV_ERROR,

Line 3338: msc_st_util.log_message(lv_error_text);

3334: EXCEPTION
3335: WHEN too_many_rows THEN
3336: lv_error_text := substr('MSC_CL__RPO_PRE_PROCESS.LOAD_ERO_DEMAND'||'('
3337: ||MSC_CL_PRE_PROCESS.v_sql_stmt||')'|| SQLERRM, 1, 240);
3338: msc_st_util.log_message(lv_error_text);
3339: ROLLBACK ;
3340:
3341: WHEN ex_logging_err THEN
3342: msc_st_util.log_message(lv_error_text);

Line 3342: msc_st_util.log_message(lv_error_text);

3338: msc_st_util.log_message(lv_error_text);
3339: ROLLBACK ;
3340:
3341: WHEN ex_logging_err THEN
3342: msc_st_util.log_message(lv_error_text);
3343: ROLLBACK;
3344:
3345: WHEN OTHERS THEN
3346: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ERO_DEMAND'||'('

Line 3348: msc_st_util.log_message(lv_error_text);

3344:
3345: WHEN OTHERS THEN
3346: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ERO_DEMAND'||'('
3347: ||MSC_CL_PRE_PROCESS.v_sql_stmt||')'|| SQLERRM, 1, 240);
3348: msc_st_util.log_message(lv_error_text);
3349: ROLLBACK;
3350:
3351: END LOAD_ERO_DEMAND;
3352: