DBA Data[Home] [Help]

APPS.MSC_CL_RPO_ODS_LOAD dependencies on FND_MESSAGE

Line 604: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

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');
607: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
608: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 605: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_IRO_DEMAND');

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');
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;

Line 606: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');

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');
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;

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 1197: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

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);
1201:

Line 1198: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');

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);
1201:
1202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1199: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');

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);
1201:
1202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1203: RAISE;

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 1210: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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));
1213: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1214:

Line 1211: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');

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));
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');

Line 1212: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));

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));
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');

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 1215: 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',
1218: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1219: MSC_CL_COLLECTION.v_instance_id));

Line 1216: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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',
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);

Line 1217: FND_MESSAGE.SET_TOKEN('VALUE',

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',
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:

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 1222: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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));
1225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1226:

Line 1223: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');

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));
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');

Line 1224: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEMAND_TYPE));

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));
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');

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 1227: 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',
1230: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
1231: lv_ORIGINATION_TYPE));

Line 1228: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_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',
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);

Line 1229: FND_MESSAGE.SET_TOKEN('VALUE',

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',
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:

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;