DBA Data[Home] [Help]

APPS.MSC_CL_RPO_ODS_LOAD dependencies on FND_MESSAGE

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

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

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

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

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

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

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

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

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

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

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

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);
1205:
1206: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1207: RAISE;

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

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

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

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

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

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

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

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

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

Line 1221: FND_MESSAGE.SET_TOKEN('VALUE',

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

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

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

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

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

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

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

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

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

Line 1233: FND_MESSAGE.SET_TOKEN('VALUE',

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

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;