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_SUPPLY_ODS_LOAD dependencies on FND_MESSAGE

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

2089:
2090: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2091:
2092: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQLCODE========================================');
2093: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2094: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
2095: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2096: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2097:

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

2090: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2091:
2092: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQLCODE========================================');
2093: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2094: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
2095: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2096: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2097:
2098: update msc_apps_instances

Line 2095: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');

2091:
2092: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQLCODE========================================');
2093: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2094: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
2095: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2096: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2097:
2098: update msc_apps_instances
2099: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR

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

2092: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQLCODE========================================');
2093: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2094: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
2095: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2096: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2097:
2098: update msc_apps_instances
2099: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
2100: where instance_id = MSC_CL_COLLECTION.v_instance_id;

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

2106: ELSE
2107: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2108:
2109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'OTHER========================================');
2110: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2111: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
2112: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2113: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2114:

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

2107: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2108:
2109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'OTHER========================================');
2110: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2111: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
2112: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2113: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2114:
2115: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2112: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');

2108:
2109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'OTHER========================================');
2110: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2111: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
2112: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2113: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2114:
2115: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2116: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

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

2109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'OTHER========================================');
2110: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2111: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
2112: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2113: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2114:
2115: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2116: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2117: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

Line 2115: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2111: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
2112: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2113: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2114:
2115: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2116: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2117: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
2118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2119:

Line 2116: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

2112: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2113: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2114:
2115: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2116: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2117: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
2118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2119:
2120: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2117: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

2113: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2114:
2115: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2116: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2117: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
2118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2119:
2120: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2121: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

2114:
2115: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2116: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2117: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
2118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2119:
2120: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2121: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2122: FND_MESSAGE.SET_TOKEN('VALUE',

Line 2120: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2116: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2117: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
2118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2119:
2120: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2121: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2122: FND_MESSAGE.SET_TOKEN('VALUE',
2123: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2124: MSC_CL_COLLECTION.v_instance_id));

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

2117: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
2118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2119:
2120: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2121: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2122: FND_MESSAGE.SET_TOKEN('VALUE',
2123: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2124: MSC_CL_COLLECTION.v_instance_id));
2125: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2122: FND_MESSAGE.SET_TOKEN('VALUE',

2118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2119:
2120: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2121: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2122: FND_MESSAGE.SET_TOKEN('VALUE',
2123: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2124: MSC_CL_COLLECTION.v_instance_id));
2125: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2126:

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

2121: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2122: FND_MESSAGE.SET_TOKEN('VALUE',
2123: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2124: MSC_CL_COLLECTION.v_instance_id));
2125: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2126:
2127: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2128: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
2129: FND_MESSAGE.SET_TOKEN('VALUE',

Line 2127: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2123: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2124: MSC_CL_COLLECTION.v_instance_id));
2125: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2126:
2127: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2128: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
2129: FND_MESSAGE.SET_TOKEN('VALUE',
2130: MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE',c_rec.ORDER_TYPE));
2131: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2128: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');

2124: MSC_CL_COLLECTION.v_instance_id));
2125: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2126:
2127: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2128: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
2129: FND_MESSAGE.SET_TOKEN('VALUE',
2130: MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE',c_rec.ORDER_TYPE));
2131: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2132:

Line 2129: FND_MESSAGE.SET_TOKEN('VALUE',

2125: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2126:
2127: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2128: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
2129: FND_MESSAGE.SET_TOKEN('VALUE',
2130: MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE',c_rec.ORDER_TYPE));
2131: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2132:
2133: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

2127: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2128: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
2129: FND_MESSAGE.SET_TOKEN('VALUE',
2130: MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE',c_rec.ORDER_TYPE));
2131: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2132:
2133: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2134: END IF;
2135:

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

3201:
3202: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3203:
3204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'P========================================');
3205: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3206: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');
3207: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3209:

Line 3206: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');

3202: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3203:
3204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'P========================================');
3205: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3206: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');
3207: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3209:
3210: update msc_apps_instances

Line 3207: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');

3203:
3204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'P========================================');
3205: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3206: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');
3207: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3209:
3210: update msc_apps_instances
3211: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR

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

3204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'P========================================');
3205: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3206: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');
3207: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3209:
3210: update msc_apps_instances
3211: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
3212: where instance_id = MSC_CL_COLLECTION.v_instance_id;

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

3218: ELSE
3219: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3220:
3221: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'E========================================');
3222: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3223: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');
3224: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3226:

Line 3223: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');

3219: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3220:
3221: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'E========================================');
3222: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3223: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');
3224: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3226:
3227: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3224: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');

3220:
3221: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'E========================================');
3222: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3223: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');
3224: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3226:
3227: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3228: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

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

3221: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'E========================================');
3222: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3223: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');
3224: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3226:
3227: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3228: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3229: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

Line 3227: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3223: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');
3224: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3226:
3227: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3228: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3229: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3231:

Line 3228: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

3224: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3226:
3227: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3228: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3229: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3231:
3232: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3229: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

3225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3226:
3227: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3228: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3229: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3231:
3232: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3233: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

3226:
3227: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3228: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3229: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3231:
3232: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3233: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3234: FND_MESSAGE.SET_TOKEN('VALUE',

Line 3232: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3228: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3229: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3231:
3232: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3233: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3234: FND_MESSAGE.SET_TOKEN('VALUE',
3235: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3236: MSC_CL_COLLECTION.v_instance_id));

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

3229: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3231:
3232: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3233: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3234: FND_MESSAGE.SET_TOKEN('VALUE',
3235: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3236: MSC_CL_COLLECTION.v_instance_id));
3237: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3234: FND_MESSAGE.SET_TOKEN('VALUE',

3230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3231:
3232: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3233: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3234: FND_MESSAGE.SET_TOKEN('VALUE',
3235: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3236: MSC_CL_COLLECTION.v_instance_id));
3237: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3238:

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

3233: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3234: FND_MESSAGE.SET_TOKEN('VALUE',
3235: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3236: MSC_CL_COLLECTION.v_instance_id));
3237: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3238:
3239: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3240: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
3241: FND_MESSAGE.SET_TOKEN('VALUE',

Line 3239: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3235: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3236: MSC_CL_COLLECTION.v_instance_id));
3237: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3238:
3239: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3240: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
3241: FND_MESSAGE.SET_TOKEN('VALUE',
3242: MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE',c_rec.ORDER_TYPE));
3243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3240: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');

3236: MSC_CL_COLLECTION.v_instance_id));
3237: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3238:
3239: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3240: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
3241: FND_MESSAGE.SET_TOKEN('VALUE',
3242: MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE',c_rec.ORDER_TYPE));
3243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3244:

Line 3241: FND_MESSAGE.SET_TOKEN('VALUE',

3237: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3238:
3239: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3240: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
3241: FND_MESSAGE.SET_TOKEN('VALUE',
3242: MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE',c_rec.ORDER_TYPE));
3243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3244:
3245: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

3239: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3240: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
3241: FND_MESSAGE.SET_TOKEN('VALUE',
3242: MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE',c_rec.ORDER_TYPE));
3243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3244:
3245: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3246: END IF;
3247:

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

3955:
3956: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3957:
3958: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3959: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3960: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3961: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3962: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3963:

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

3956: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3957:
3958: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3959: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3960: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3961: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3962: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3963:
3964: update msc_apps_instances

Line 3961: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');

3957:
3958: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3959: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3960: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3961: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3962: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3963:
3964: update msc_apps_instances
3965: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR

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

3958: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3959: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3960: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3961: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3962: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3963:
3964: update msc_apps_instances
3965: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
3966: where instance_id = MSC_CL_COLLECTION.v_instance_id;

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

3972: ELSE
3973: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3974:
3975: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3976: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3977: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3978: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3979: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3980:

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

3973: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3974:
3975: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3976: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3977: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3978: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3979: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3980:
3981: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3978: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');

3974:
3975: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3976: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3977: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3978: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3979: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3980:
3981: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3982: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_COLLECTION.ITEM_NAME');

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

3975: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3976: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3977: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3978: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3979: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3980:
3981: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3982: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_COLLECTION.ITEM_NAME');
3983: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));

Line 3981: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3977: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3978: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3979: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3980:
3981: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3982: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_COLLECTION.ITEM_NAME');
3983: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));
3984: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3985:

Line 3982: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_COLLECTION.ITEM_NAME');

3978: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3979: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3980:
3981: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3982: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_COLLECTION.ITEM_NAME');
3983: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));
3984: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3985:
3986: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3983: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));

3979: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3980:
3981: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3982: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_COLLECTION.ITEM_NAME');
3983: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));
3984: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3985:
3986: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3987: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

3980:
3981: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3982: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_COLLECTION.ITEM_NAME');
3983: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));
3984: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3985:
3986: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3987: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3988: FND_MESSAGE.SET_TOKEN('VALUE',

Line 3986: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3982: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_COLLECTION.ITEM_NAME');
3983: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));
3984: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3985:
3986: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3987: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3988: FND_MESSAGE.SET_TOKEN('VALUE',
3989: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
3990: MSC_CL_COLLECTION.v_instance_id));

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

3983: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));
3984: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3985:
3986: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3987: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3988: FND_MESSAGE.SET_TOKEN('VALUE',
3989: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
3990: MSC_CL_COLLECTION.v_instance_id));
3991: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3988: FND_MESSAGE.SET_TOKEN('VALUE',

3984: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3985:
3986: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3987: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3988: FND_MESSAGE.SET_TOKEN('VALUE',
3989: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
3990: MSC_CL_COLLECTION.v_instance_id));
3991: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3992:

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

3987: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3988: FND_MESSAGE.SET_TOKEN('VALUE',
3989: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
3990: MSC_CL_COLLECTION.v_instance_id));
3991: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3992:
3993: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3994: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
3995: FND_MESSAGE.SET_TOKEN('VALUE',

Line 3993: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3989: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
3990: MSC_CL_COLLECTION.v_instance_id));
3991: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3992:
3993: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3994: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
3995: FND_MESSAGE.SET_TOKEN('VALUE',
3996: MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE',lv_ORDER_TYPE));
3997: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3994: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');

3990: MSC_CL_COLLECTION.v_instance_id));
3991: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3992:
3993: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3994: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
3995: FND_MESSAGE.SET_TOKEN('VALUE',
3996: MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE',lv_ORDER_TYPE));
3997: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3998:

Line 3995: FND_MESSAGE.SET_TOKEN('VALUE',

3991: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3992:
3993: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3994: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
3995: FND_MESSAGE.SET_TOKEN('VALUE',
3996: MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE',lv_ORDER_TYPE));
3997: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3998:
3999: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

3993: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3994: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
3995: FND_MESSAGE.SET_TOKEN('VALUE',
3996: MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE',lv_ORDER_TYPE));
3997: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3998:
3999: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4000: END IF;
4001: