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_ODS_LOAD dependencies on MSC_UTIL

Line 7: -- v_warning_flag NUMBER:= MSC_UTIL.SYS_NO; --2 be changed

3:
4: v_sql_stmt VARCHAR2(4000);
5: lv_sql_stmt1 VARCHAR2(4000);
6: v_sub_str VARCHAR2(4000);
7: -- v_warning_flag NUMBER:= MSC_UTIL.SYS_NO; --2 be changed
8: -- v_is_cont_refresh BOOLEAN; -- 2 be changed
9: -- v_chr9 VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(9);
10: -- v_chr10 VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(10);
11: -- v_chr13 VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(13);

Line 82: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

78: BEGIN
79: NULL;
80: c_count:=0;
81: -- ========= Prepare the Cursor Statement ==========
82: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
83: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
84: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
85: ELSE
86: lv_tbl:= 'MSC_DEMANDS';

Line 90: IF MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' THEN

86: lv_tbl:= 'MSC_DEMANDS';
87: lv_supplies_tbl:= 'MSC_SUPPLIES';
88: END IF;
89:
90: IF MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' THEN
91: IF MSC_CL_COLLECTION.v_is_legacy_refresh THEN
92: lv_ITEM_TYPE_ID := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
93: lv_sel_sql_stmt := 'ITEM_TYPE_ID,ITEM_TYPE_VALUE';
94: lv_data_sql_stmt := lv_ITEM_TYPE_ID||','||'msdd.ITEM_TYPE_VALUE,';

Line 92: lv_ITEM_TYPE_ID := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;

88: END IF;
89:
90: IF MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' THEN
91: IF MSC_CL_COLLECTION.v_is_legacy_refresh THEN
92: lv_ITEM_TYPE_ID := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
93: lv_sel_sql_stmt := 'ITEM_TYPE_ID,ITEM_TYPE_VALUE';
94: lv_data_sql_stmt := lv_ITEM_TYPE_ID||','||'msdd.ITEM_TYPE_VALUE,';
95: ELSE
96: lv_ITEM_TYPE_ID := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;

Line 96: lv_ITEM_TYPE_ID := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;

92: lv_ITEM_TYPE_ID := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
93: lv_sel_sql_stmt := 'ITEM_TYPE_ID,ITEM_TYPE_VALUE';
94: lv_data_sql_stmt := lv_ITEM_TYPE_ID||','||'msdd.ITEM_TYPE_VALUE,';
95: ELSE
96: lv_ITEM_TYPE_ID := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
97: lv_ITEM_TYPE_VALUE := MSC_UTIL.G_PARTCONDN_GOOD;
98: lv_sel_sql_stmt := 'ITEM_TYPE_ID,ITEM_TYPE_VALUE,';
99: lv_data_sql_stmt := lv_ITEM_TYPE_ID||','||lv_ITEM_TYPE_VALUE||',';
100: END IF;

Line 97: lv_ITEM_TYPE_VALUE := MSC_UTIL.G_PARTCONDN_GOOD;

93: lv_sel_sql_stmt := 'ITEM_TYPE_ID,ITEM_TYPE_VALUE';
94: lv_data_sql_stmt := lv_ITEM_TYPE_ID||','||'msdd.ITEM_TYPE_VALUE,';
95: ELSE
96: lv_ITEM_TYPE_ID := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
97: lv_ITEM_TYPE_VALUE := MSC_UTIL.G_PARTCONDN_GOOD;
98: lv_sel_sql_stmt := 'ITEM_TYPE_ID,ITEM_TYPE_VALUE,';
99: lv_data_sql_stmt := lv_ITEM_TYPE_ID||','||lv_ITEM_TYPE_VALUE||',';
100: END IF;
101: ELSE

Line 135: lv_del_stmt := lv_del_stmt || ' And mshr.organization_id '||MSC_UTIL.v_depot_org_str;

131:
132: if MSC_CL_COLLECTION.v_is_legacy_refresh then
133: lv_del_stmt := lv_del_stmt || ' And mshr.ENTITY=''IRO''' ;
134: else
135: lv_del_stmt := lv_del_stmt || ' And mshr.organization_id '||MSC_UTIL.v_depot_org_str;
136: end if ;
137:
138: lv_del_stmt2 := 'SELECT
139: mshr.REPAIR_LINE_ID,

Line 150: ||' AND mshr.DELETED_FLAG= '||MSC_UTIL.SYS_YES

146: mshr.wip_entity_name
147: FROM MSC_ST_DEMANDS mshr,
148: msc_item_id_lid t1
149: WHERE mshr.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
150: ||' AND mshr.DELETED_FLAG= '||MSC_UTIL.SYS_YES
151: ||' AND mshr.ORIGINATION_TYPE=77
152: AND t1.SR_INVENTORY_ITEM_ID(+)= mshr.inventory_item_id
153: AND t1.sr_instance_id(+)= mshr.sr_instance_id ';
154:

Line 159: lv_del_stmt2 := lv_del_stmt2 || 'And mshr.organization_id '||MSC_UTIL.v_depot_org_str;

155:
156: if MSC_CL_COLLECTION.v_is_legacy_refresh then
157: lv_del_stmt2 := lv_del_stmt2 || ' And mshr.ENTITY=''IRO''' ;
158: else
159: lv_del_stmt2 := lv_del_stmt2 || 'And mshr.organization_id '||MSC_UTIL.v_depot_org_str;
160: end if ;
161:
162: lv_cursor_stmt:=
163: 'SELECT'

Line 209: ||' AND msdd.DELETED_FLAG= '||MSC_UTIL.SYS_NO

205: || lv_supplies_tbl||' ms,'
206: ||' MSC_ST_DEMANDS msdd'
207: ||' WHERE msdd.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
208: ||' AND msdd.ORIGINATION_TYPE = 77' /* 50 eam demand: ds change change SRP Change 5909379*/
209: ||' AND msdd.DELETED_FLAG= '||MSC_UTIL.SYS_NO
210: ||' AND t1.SR_INVENTORY_ITEM_ID= msdd.inventory_item_id'
211: ||' AND t1.sr_instance_id= msdd.SR_INSTANCE_ID'
212: ||' AND t2.SR_INVENTORY_ITEM_ID= msdd.using_assembly_item_id'
213: ||' AND t2.sr_instance_id= msdd.SR_INSTANCE_ID'

Line 606: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

602: EXCEPTION
603:
604: WHEN OTHERS THEN
605:
606: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
607:
608: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
609: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_IRO_DEMAND');
610: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');

Line 611: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

607:
608: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
609: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_IRO_DEMAND');
610: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
611: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
612: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
613: RAISE;
614: END;
615:

Line 612: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

608: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
609: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_IRO_DEMAND');
610: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
611: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
612: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
613: RAISE;
614: END;
615:
616: END LOOP;

Line 642: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');

638:
639: EXCEPTION
640: WHEN OTHERS THEN
641:
642: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
643: IF lv_sql_stmt IS NOT NULL THEN
644: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);
645: END IF;
646: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 644: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);

640: WHEN OTHERS THEN
641:
642: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
643: IF lv_sql_stmt IS NOT NULL THEN
644: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);
645: END IF;
646: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
647: -- log_message ('Error Occured'||SQLERRM);
648:

Line 646: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

642: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
643: IF lv_sql_stmt IS NOT NULL THEN
644: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);
645: END IF;
646: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
647: -- log_message ('Error Occured'||SQLERRM);
648:
649:
650: END;

Line 679: AND msd.DELETED_FLAG= MSC_UTIL.SYS_YES

675: FROM MSC_ITEM_ID_LID t1,
676: MSC_ST_DEMANDS msd
677: WHERE msd.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
678: AND msd.ORIGINATION_TYPE = 77
679: AND msd.DELETED_FLAG= MSC_UTIL.SYS_YES
680: AND t1.SR_INVENTORY_ITEM_ID(+)= msd.inventory_item_id
681: AND t1.sr_instance_id(+)= MSC_CL_COLLECTION.v_instance_id;*/
682:
683: lv_DISPOSITION_ID NUMBER;

Line 730: AND msd1.DELETED_FLAG= '|| MSC_UTIL.SYS_YES

726: FROM MSC_ITEM_ID_LID t1,
727: MSC_ST_DEMANDS msd1
728: WHERE msd1.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
729: ||' AND msd1.ORIGINATION_TYPE = 77
730: AND msd1.DELETED_FLAG= '|| MSC_UTIL.SYS_YES
731: ||' AND t1.SR_INVENTORY_ITEM_ID(+)= msd1.inventory_item_id
732: AND t1.sr_instance_id(+)= '||MSC_CL_COLLECTION.v_instance_id ;
733:
734: if MSC_CL_COLLECTION.v_is_legacy_refresh then

Line 737: lv_del_stmt:=lv_del_stmt ||' AND msd1.ORGANIZATION_ID '||MSC_UTIL.v_non_depot_org_str;

733:
734: if MSC_CL_COLLECTION.v_is_legacy_refresh then
735: lv_del_stmt:=lv_del_stmt ||' AND msd1.ENTITY=''ERO''';
736: else
737: lv_del_stmt:=lv_del_stmt ||' AND msd1.ORGANIZATION_ID '||MSC_UTIL.v_non_depot_org_str;
738: end if ;
739:
740:
741: OPEN c2_d for lv_del_stmt;

Line 776: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

772:
773: c_count:=0;
774:
775: -- ========= Prepare the Cursor Statement ==========
776: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
777: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
778: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
779: ELSE
780: lv_tbl:= 'MSC_DEMANDS';

Line 785: IF MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' THEN

781: lv_supplies_tbl:= 'MSC_SUPPLIES';
782: END IF;
783:
784:
785: IF MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' THEN
786: lv_ITEM_TYPE_ID := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
787: lv_ITEM_TYPE_VALUE := MSC_UTIL.G_PARTCONDN_BAD;
788: lv_sel_sql_stmt := 'ITEM_TYPE_ID,ITEM_TYPE_VALUE,';
789: lv_data_sql_stmt := lv_ITEM_TYPE_ID||','||lv_ITEM_TYPE_VALUE||',';

Line 786: lv_ITEM_TYPE_ID := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;

782: END IF;
783:
784:
785: IF MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' THEN
786: lv_ITEM_TYPE_ID := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
787: lv_ITEM_TYPE_VALUE := MSC_UTIL.G_PARTCONDN_BAD;
788: lv_sel_sql_stmt := 'ITEM_TYPE_ID,ITEM_TYPE_VALUE,';
789: lv_data_sql_stmt := lv_ITEM_TYPE_ID||','||lv_ITEM_TYPE_VALUE||',';
790: ELSE

Line 787: lv_ITEM_TYPE_VALUE := MSC_UTIL.G_PARTCONDN_BAD;

783:
784:
785: IF MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' THEN
786: lv_ITEM_TYPE_ID := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
787: lv_ITEM_TYPE_VALUE := MSC_UTIL.G_PARTCONDN_BAD;
788: lv_sel_sql_stmt := 'ITEM_TYPE_ID,ITEM_TYPE_VALUE,';
789: lv_data_sql_stmt := lv_ITEM_TYPE_ID||','||lv_ITEM_TYPE_VALUE||',';
790: ELSE
791: lv_ITEM_TYPE_ID := NULL;

Line 843: ||' AND msd.DELETED_FLAG= '||MSC_UTIL.SYS_NO

839: || lv_supplies_tbl||' ms,'
840: ||' MSC_ST_DEMANDS msd'
841: ||' WHERE msd.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
842: ||' AND msd.ORIGINATION_TYPE = 77' /* 50 eam demand: ds change change SRP Change 5909379*/
843: ||' AND msd.DELETED_FLAG= '||MSC_UTIL.SYS_NO
844: ||' AND t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id'
845: ||' AND t1.sr_instance_id= msd.SR_INSTANCE_ID'
846: ||' AND t2.SR_INVENTORY_ITEM_ID= msd.using_assembly_item_id'
847: ||' AND t2.sr_instance_id= msd.SR_INSTANCE_ID'

Line 920: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');

916:
917: EXCEPTION
918: WHEN OTHERS THEN
919:
920: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
921: IF lv_sql_stmt IS NOT NULL THEN
922: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);
923: END IF;
924: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 922: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);

918: WHEN OTHERS THEN
919:
920: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
921: IF lv_sql_stmt IS NOT NULL THEN
922: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);
923: END IF;
924: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
925: -- log_message ('Error Occured'||SQLERRM);
926:

Line 924: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

920: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
921: IF lv_sql_stmt IS NOT NULL THEN
922: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);
923: END IF;
924: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
925: -- log_message ('Error Occured'||SQLERRM);
926:
927: END;
928: END IF; --v_is_complete_refresh

Line 1056: ||' AND msd.DELETED_FLAG= '||MSC_UTIL.SYS_NO

1052: || lv_supplies_tbl||' ms,'
1053: ||' MSC_ST_DEMANDS msd'
1054: ||' WHERE msd.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
1055: ||' AND msd.ORIGINATION_TYPE = 77' /* 50 eam demand: ds change change*/
1056: ||' AND msd.DELETED_FLAG= '||MSC_UTIL.SYS_NO
1057: ||' AND t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id'
1058: ||' AND t1.sr_instance_id= msd.SR_INSTANCE_ID'
1059: ||' AND t2.SR_INVENTORY_ITEM_ID= msd.using_assembly_item_id'
1060: ||' AND t2.sr_instance_id= msd.SR_INSTANCE_ID'

Line 1149: IF ( lv_DELETED_FLAG<> MSC_UTIL.SYS_YES ) AND ( lv_ORIGINATION_TYPE= 77)

1145: AND INVENTORY_ITEM_ID= lv_INVENTORY_ITEM_ID ;
1146:
1147: END IF; -- Origination_Type
1148:
1149: IF ( lv_DELETED_FLAG<> MSC_UTIL.SYS_YES ) AND ( lv_ORIGINATION_TYPE= 77)
1150: AND SQL%NOTFOUND THEN
1151:
1152:
1153: EXECUTE IMMEDIATE lv_sql_stmt

Line 1200: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1196: WHEN OTHERS THEN
1197:
1198: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1199:
1200: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1201: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1202: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
1203: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1200: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1201: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1202: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
1203: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1205:
1206: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1207: RAISE;
1208:

Line 1206: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1202: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
1203: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1205:
1206: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1207: RAISE;
1208:
1209: ELSE
1210: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

Line 1210: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

1206: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1207: RAISE;
1208:
1209: ELSE
1210: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1211:
1212: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1213:
1214: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1212: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1208:
1209: ELSE
1210: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1211:
1212: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1213:
1214: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1215: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');
1216: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));

Line 1217: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1213:
1214: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1215: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');
1216: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));
1217: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1218:
1219: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1220: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1221: FND_MESSAGE.SET_TOKEN('VALUE',

Line 1224: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1220: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1221: FND_MESSAGE.SET_TOKEN('VALUE',
1222: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1223: MSC_CL_COLLECTION.v_instance_id));
1224: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1225:
1226: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1227: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
1228: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEMAND_TYPE));

Line 1229: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1225:
1226: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1227: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
1228: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEMAND_TYPE));
1229: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1230:
1231: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1232: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
1233: FND_MESSAGE.SET_TOKEN('VALUE',

Line 1236: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1232: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
1233: FND_MESSAGE.SET_TOKEN('VALUE',
1234: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
1235: lv_ORIGINATION_TYPE));
1236: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1237:
1238: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1239: END IF;
1240: END;

Line 1238: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1234: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
1235: lv_ORIGINATION_TYPE));
1236: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1237:
1238: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1239: END IF;
1240: END;
1241:
1242: c_count:= c_count+1;

Line 1257: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');

1253: EXCEPTION
1254: WHEN OTHERS THEN
1255: IF c2%ISOPEN THEN CLOSE c2; END IF;
1256:
1257: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
1258: IF lv_cursor_stmt IS NOT NULL THEN
1259: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
1260: END IF;
1261: IF lv_sql_stmt IS NOT NULL THEN

Line 1259: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);

1255: IF c2%ISOPEN THEN CLOSE c2; END IF;
1256:
1257: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
1258: IF lv_cursor_stmt IS NOT NULL THEN
1259: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
1260: END IF;
1261: IF lv_sql_stmt IS NOT NULL THEN
1262: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
1263: END IF;

Line 1262: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);

1258: IF lv_cursor_stmt IS NOT NULL THEN
1259: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
1260: END IF;
1261: IF lv_sql_stmt IS NOT NULL THEN
1262: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
1263: END IF;
1264: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1265: RAISE;
1266: END LOAD_ERO_DEMAND;

Line 1264: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1260: END IF;
1261: IF lv_sql_stmt IS NOT NULL THEN
1262: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
1263: END IF;
1264: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1265: RAISE;
1266: END LOAD_ERO_DEMAND;
1267:
1268: