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 83: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

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

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

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

Line 92: lv_ITEM_TYPE_ID := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;

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

Line 93: lv_ITEM_TYPE_VALUE := MSC_UTIL.G_PARTCONDN_GOOD;

89: END IF;
90:
91: IF MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' THEN
92: lv_ITEM_TYPE_ID := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
93: lv_ITEM_TYPE_VALUE := MSC_UTIL.G_PARTCONDN_GOOD;
94: lv_sel_sql_stmt := 'ITEM_TYPE_ID,ITEM_TYPE_VALUE,';
95: lv_data_sql_stmt := lv_ITEM_TYPE_ID||','||lv_ITEM_TYPE_VALUE||',';
96: ELSE
97: lv_ITEM_TYPE_ID := NULL;

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

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

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

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

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

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

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

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

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

598: EXCEPTION
599:
600: WHEN OTHERS THEN
601:
602: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
603:
604: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
605: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_IRO_DEMAND');
606: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');

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

603:
604: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
605: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_IRO_DEMAND');
606: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
607: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
608: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
609: RAISE;
610: END;
611:

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

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

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

634:
635: EXCEPTION
636: WHEN OTHERS THEN
637:
638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
639: IF lv_sql_stmt IS NOT NULL THEN
640: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);
641: END IF;
642: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

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

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

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

Line 675: AND msd.DELETED_FLAG= MSC_UTIL.SYS_YES

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

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

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

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

729:
730: if MSC_CL_COLLECTION.v_is_legacy_refresh then
731: lv_del_stmt:=lv_del_stmt ||' AND msd1.ENTITY=''ERO''';
732: else
733: lv_del_stmt:=lv_del_stmt ||' AND msd1.ORGANIZATION_ID '||MSC_UTIL.v_non_depot_org_str;
734: end if ;
735:
736:
737: OPEN c2_d for lv_del_stmt;

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

768:
769: c_count:=0;
770:
771: -- ========= Prepare the Cursor Statement ==========
772: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
773: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
774: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
775: ELSE
776: lv_tbl:= 'MSC_DEMANDS';

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

777: lv_supplies_tbl:= 'MSC_SUPPLIES';
778: END IF;
779:
780:
781: IF MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' THEN
782: lv_ITEM_TYPE_ID := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
783: lv_ITEM_TYPE_VALUE := MSC_UTIL.G_PARTCONDN_BAD;
784: lv_sel_sql_stmt := 'ITEM_TYPE_ID,ITEM_TYPE_VALUE,';
785: lv_data_sql_stmt := lv_ITEM_TYPE_ID||','||lv_ITEM_TYPE_VALUE||',';

Line 782: lv_ITEM_TYPE_ID := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;

778: END IF;
779:
780:
781: IF MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' THEN
782: lv_ITEM_TYPE_ID := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
783: lv_ITEM_TYPE_VALUE := MSC_UTIL.G_PARTCONDN_BAD;
784: lv_sel_sql_stmt := 'ITEM_TYPE_ID,ITEM_TYPE_VALUE,';
785: lv_data_sql_stmt := lv_ITEM_TYPE_ID||','||lv_ITEM_TYPE_VALUE||',';
786: ELSE

Line 783: lv_ITEM_TYPE_VALUE := MSC_UTIL.G_PARTCONDN_BAD;

779:
780:
781: IF MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' THEN
782: lv_ITEM_TYPE_ID := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
783: lv_ITEM_TYPE_VALUE := MSC_UTIL.G_PARTCONDN_BAD;
784: lv_sel_sql_stmt := 'ITEM_TYPE_ID,ITEM_TYPE_VALUE,';
785: lv_data_sql_stmt := lv_ITEM_TYPE_ID||','||lv_ITEM_TYPE_VALUE||',';
786: ELSE
787: lv_ITEM_TYPE_ID := NULL;

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

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

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

912:
913: EXCEPTION
914: WHEN OTHERS THEN
915:
916: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
917: IF lv_sql_stmt IS NOT NULL THEN
918: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);
919: END IF;
920: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

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

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

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

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

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

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

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

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

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

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

1196: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1197: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1198: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
1199: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1200: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1201:
1202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1203: RAISE;
1204:

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

1198: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
1199: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1200: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1201:
1202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1203: RAISE;
1204:
1205: ELSE
1206: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

1202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1203: RAISE;
1204:
1205: ELSE
1206: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1207:
1208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1209:
1210: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

1204:
1205: ELSE
1206: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1207:
1208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1209:
1210: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1211: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');
1212: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));

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

1209:
1210: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1211: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');
1212: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));
1213: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1214:
1215: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1216: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1217: FND_MESSAGE.SET_TOKEN('VALUE',

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

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

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

1221:
1222: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1223: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
1224: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEMAND_TYPE));
1225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1226:
1227: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1228: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
1229: FND_MESSAGE.SET_TOKEN('VALUE',

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

1228: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
1229: FND_MESSAGE.SET_TOKEN('VALUE',
1230: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
1231: lv_ORIGINATION_TYPE));
1232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1233:
1234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1235: END IF;
1236: END;

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

1230: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
1231: lv_ORIGINATION_TYPE));
1232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1233:
1234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1235: END IF;
1236: END;
1237:
1238: c_count:= c_count+1;

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

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

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

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

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

1254: IF lv_cursor_stmt IS NOT NULL THEN
1255: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
1256: END IF;
1257: IF lv_sql_stmt IS NOT NULL THEN
1258: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
1259: END IF;
1260: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1261: RAISE;
1262: END LOAD_ERO_DEMAND;

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

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