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

2017:
2018: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2019:
2020: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQLCODE========================================');
2021: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2022: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
2023: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2024: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2025:

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

2018: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2019:
2020: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQLCODE========================================');
2021: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2022: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
2023: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2024: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2025:
2026: update msc_apps_instances

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

2019:
2020: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQLCODE========================================');
2021: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2022: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
2023: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2024: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2025:
2026: update msc_apps_instances
2027: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR

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

2020: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQLCODE========================================');
2021: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2022: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
2023: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2024: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2025:
2026: update msc_apps_instances
2027: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
2028: where instance_id = MSC_CL_COLLECTION.v_instance_id;

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

2034: ELSE
2035: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2036:
2037: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'OTHER========================================');
2038: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2039: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
2040: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2041: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2042:

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

2035: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2036:
2037: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'OTHER========================================');
2038: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2039: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
2040: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2041: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2042:
2043: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

2036:
2037: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'OTHER========================================');
2038: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2039: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
2040: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2041: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2042:
2043: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2044: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

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

2037: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'OTHER========================================');
2038: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2039: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
2040: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2041: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2042:
2043: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2044: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2045: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

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

2039: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
2040: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2041: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2042:
2043: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2044: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2045: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
2046: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2047:

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

2040: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2041: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2042:
2043: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2044: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2045: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
2046: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2047:
2048: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

2041: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2042:
2043: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2044: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2045: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
2046: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2047:
2048: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2049: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

2042:
2043: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2044: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2045: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
2046: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2047:
2048: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2049: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2050: FND_MESSAGE.SET_TOKEN('VALUE',

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

2044: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2045: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
2046: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2047:
2048: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2049: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2050: FND_MESSAGE.SET_TOKEN('VALUE',
2051: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2052: MSC_CL_COLLECTION.v_instance_id));

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

2045: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
2046: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2047:
2048: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2049: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2050: FND_MESSAGE.SET_TOKEN('VALUE',
2051: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2052: MSC_CL_COLLECTION.v_instance_id));
2053: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2050: FND_MESSAGE.SET_TOKEN('VALUE',

2046: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2047:
2048: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2049: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2050: FND_MESSAGE.SET_TOKEN('VALUE',
2051: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2052: MSC_CL_COLLECTION.v_instance_id));
2053: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2054:

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

2049: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2050: FND_MESSAGE.SET_TOKEN('VALUE',
2051: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2052: MSC_CL_COLLECTION.v_instance_id));
2053: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2054:
2055: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2056: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
2057: FND_MESSAGE.SET_TOKEN('VALUE',

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

2051: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2052: MSC_CL_COLLECTION.v_instance_id));
2053: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2054:
2055: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2056: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
2057: FND_MESSAGE.SET_TOKEN('VALUE',
2058: MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE',c_rec.ORDER_TYPE));
2059: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

2052: MSC_CL_COLLECTION.v_instance_id));
2053: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2054:
2055: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2056: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
2057: FND_MESSAGE.SET_TOKEN('VALUE',
2058: MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE',c_rec.ORDER_TYPE));
2059: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2060:

Line 2057: FND_MESSAGE.SET_TOKEN('VALUE',

2053: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2054:
2055: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2056: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
2057: FND_MESSAGE.SET_TOKEN('VALUE',
2058: MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE',c_rec.ORDER_TYPE));
2059: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2060:
2061: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

2055: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2056: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
2057: FND_MESSAGE.SET_TOKEN('VALUE',
2058: MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE',c_rec.ORDER_TYPE));
2059: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2060:
2061: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2062: END IF;
2063:

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

3041:
3042: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3043:
3044: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'P========================================');
3045: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3046: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');
3047: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3048: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3049:

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

3042: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3043:
3044: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'P========================================');
3045: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3046: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');
3047: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3048: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3049:
3050: update msc_apps_instances

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

3043:
3044: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'P========================================');
3045: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3046: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');
3047: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3048: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3049:
3050: update msc_apps_instances
3051: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR

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

3044: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'P========================================');
3045: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3046: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');
3047: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3048: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3049:
3050: update msc_apps_instances
3051: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
3052: where instance_id = MSC_CL_COLLECTION.v_instance_id;

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

3058: ELSE
3059: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3060:
3061: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'E========================================');
3062: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3063: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');
3064: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3065: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3066:

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

3059: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3060:
3061: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'E========================================');
3062: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3063: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');
3064: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3065: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3066:
3067: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3060:
3061: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'E========================================');
3062: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3063: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');
3064: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3065: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3066:
3067: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3068: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

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

3061: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'E========================================');
3062: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3063: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');
3064: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3065: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3066:
3067: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3068: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3069: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

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

3063: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');
3064: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3065: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3066:
3067: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3068: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3069: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3070: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3071:

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

3064: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3065: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3066:
3067: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3068: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3069: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3070: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3071:
3072: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3065: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3066:
3067: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3068: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3069: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3070: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3071:
3072: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3073: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

3066:
3067: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3068: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3069: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3070: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3071:
3072: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3073: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3074: FND_MESSAGE.SET_TOKEN('VALUE',

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

3068: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3069: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3070: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3071:
3072: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3073: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3074: FND_MESSAGE.SET_TOKEN('VALUE',
3075: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3076: MSC_CL_COLLECTION.v_instance_id));

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

3069: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3070: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3071:
3072: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3073: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3074: FND_MESSAGE.SET_TOKEN('VALUE',
3075: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3076: MSC_CL_COLLECTION.v_instance_id));
3077: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3074: FND_MESSAGE.SET_TOKEN('VALUE',

3070: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3071:
3072: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3073: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3074: FND_MESSAGE.SET_TOKEN('VALUE',
3075: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3076: MSC_CL_COLLECTION.v_instance_id));
3077: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3078:

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

3073: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3074: FND_MESSAGE.SET_TOKEN('VALUE',
3075: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3076: MSC_CL_COLLECTION.v_instance_id));
3077: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3078:
3079: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3080: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
3081: FND_MESSAGE.SET_TOKEN('VALUE',

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

3075: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3076: MSC_CL_COLLECTION.v_instance_id));
3077: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3078:
3079: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3080: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
3081: FND_MESSAGE.SET_TOKEN('VALUE',
3082: MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE',c_rec.ORDER_TYPE));
3083: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

3076: MSC_CL_COLLECTION.v_instance_id));
3077: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3078:
3079: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3080: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
3081: FND_MESSAGE.SET_TOKEN('VALUE',
3082: MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE',c_rec.ORDER_TYPE));
3083: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3084:

Line 3081: FND_MESSAGE.SET_TOKEN('VALUE',

3077: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3078:
3079: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3080: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
3081: FND_MESSAGE.SET_TOKEN('VALUE',
3082: MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE',c_rec.ORDER_TYPE));
3083: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3084:
3085: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

3079: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3080: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
3081: FND_MESSAGE.SET_TOKEN('VALUE',
3082: MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE',c_rec.ORDER_TYPE));
3083: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3084:
3085: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3086: END IF;
3087:

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

3732:
3733: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3734:
3735: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3736: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3737: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3738: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3739: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3740:

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

3733: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3734:
3735: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3736: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3737: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3738: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3739: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3740:
3741: update msc_apps_instances

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

3734:
3735: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3736: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3737: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3738: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3739: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3740:
3741: update msc_apps_instances
3742: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR

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

3735: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3736: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3737: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3738: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3739: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3740:
3741: update msc_apps_instances
3742: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
3743: where instance_id = MSC_CL_COLLECTION.v_instance_id;

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

3749: ELSE
3750: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3751:
3752: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3753: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3754: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3755: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3756: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3757:

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

3750: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3751:
3752: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3753: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3754: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3755: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3756: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3757:
3758: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3751:
3752: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3753: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3754: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3755: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3756: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3757:
3758: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3759: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_COLLECTION.ITEM_NAME');

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

3752: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3753: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3754: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3755: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3756: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3757:
3758: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3759: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_COLLECTION.ITEM_NAME');
3760: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));

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

3754: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3755: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3756: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3757:
3758: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3759: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_COLLECTION.ITEM_NAME');
3760: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));
3761: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3762:

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

3755: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3756: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3757:
3758: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3759: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_COLLECTION.ITEM_NAME');
3760: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));
3761: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3762:
3763: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3756: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3757:
3758: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3759: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_COLLECTION.ITEM_NAME');
3760: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));
3761: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3762:
3763: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3764: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

3757:
3758: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3759: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_COLLECTION.ITEM_NAME');
3760: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));
3761: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3762:
3763: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3764: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3765: FND_MESSAGE.SET_TOKEN('VALUE',

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

3759: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_COLLECTION.ITEM_NAME');
3760: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));
3761: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3762:
3763: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3764: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3765: FND_MESSAGE.SET_TOKEN('VALUE',
3766: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
3767: MSC_CL_COLLECTION.v_instance_id));

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

3760: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));
3761: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3762:
3763: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3764: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3765: FND_MESSAGE.SET_TOKEN('VALUE',
3766: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
3767: MSC_CL_COLLECTION.v_instance_id));
3768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3765: FND_MESSAGE.SET_TOKEN('VALUE',

3761: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3762:
3763: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3764: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3765: FND_MESSAGE.SET_TOKEN('VALUE',
3766: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
3767: MSC_CL_COLLECTION.v_instance_id));
3768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3769:

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

3764: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3765: FND_MESSAGE.SET_TOKEN('VALUE',
3766: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
3767: MSC_CL_COLLECTION.v_instance_id));
3768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3769:
3770: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3771: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
3772: FND_MESSAGE.SET_TOKEN('VALUE',

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

3766: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
3767: MSC_CL_COLLECTION.v_instance_id));
3768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3769:
3770: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3771: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
3772: FND_MESSAGE.SET_TOKEN('VALUE',
3773: MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE',lv_ORDER_TYPE));
3774: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

3767: MSC_CL_COLLECTION.v_instance_id));
3768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3769:
3770: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3771: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
3772: FND_MESSAGE.SET_TOKEN('VALUE',
3773: MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE',lv_ORDER_TYPE));
3774: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3775:

Line 3772: FND_MESSAGE.SET_TOKEN('VALUE',

3768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3769:
3770: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3771: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
3772: FND_MESSAGE.SET_TOKEN('VALUE',
3773: MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE',lv_ORDER_TYPE));
3774: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3775:
3776: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

3770: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3771: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');
3772: FND_MESSAGE.SET_TOKEN('VALUE',
3773: MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE',lv_ORDER_TYPE));
3774: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3775:
3776: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3777: END IF;
3778: