DBA Data[Home] [Help]

APPS.EGO_GTIN_PVT dependencies on FND_MESSAGE

Line 2399: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);

2395:
2396:
2397: EXCEPTION
2398: WHEN OTHERS THEN
2399: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
2400: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
2401: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
2402: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
2403: x_error_message := FND_MSG_PUB.Get;

Line 2400: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);

2396:
2397: EXCEPTION
2398: WHEN OTHERS THEN
2399: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
2400: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
2401: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
2402: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
2403: x_error_message := FND_MSG_PUB.Get;
2404: WRITE_DEBUG_LOG(x_error_message);

Line 2401: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);

2397: EXCEPTION
2398: WHEN OTHERS THEN
2399: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
2400: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
2401: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
2402: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
2403: x_error_message := FND_MSG_PUB.Get;
2404: WRITE_DEBUG_LOG(x_error_message);
2405: RETURN;

Line 2402: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

2398: WHEN OTHERS THEN
2399: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
2400: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
2401: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
2402: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
2403: x_error_message := FND_MSG_PUB.Get;
2404: WRITE_DEBUG_LOG(x_error_message);
2405: RETURN;
2406: END Item_Propagate_Attributes;

Line 2734: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

2730: write_debug_log(l_api_name||': failed: '||sqlerrm);
2731:
2732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2733:
2734: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2735: FND_MESSAGE.Set_Token('PKG_NAME', g_pkg_name);
2736: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2737: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2738: FND_MSG_PUB.Add;

Line 2735: FND_MESSAGE.Set_Token('PKG_NAME', g_pkg_name);

2731:
2732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2733:
2734: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2735: FND_MESSAGE.Set_Token('PKG_NAME', g_pkg_name);
2736: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2737: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2738: FND_MSG_PUB.Add;
2739: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 2736: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

2732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2733:
2734: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2735: FND_MESSAGE.Set_Token('PKG_NAME', g_pkg_name);
2736: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2737: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2738: FND_MSG_PUB.Add;
2739: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2740: ,p_count => x_msg_count

Line 2737: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

2733:
2734: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2735: FND_MESSAGE.Set_Token('PKG_NAME', g_pkg_name);
2736: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2737: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2738: FND_MSG_PUB.Add;
2739: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2740: ,p_count => x_msg_count
2741: ,p_data => x_msg_data);

Line 3775: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');

3771: Get_Associated_Page_Details(l_catalog_group_id, 'EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_DEP_VAL_DATE_INFO', l_page_id, l_page_display_name);
3772: l_error_table.EXTEND;
3773: l_error_rec.PAGE_ID := l_page_id;
3774: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
3775: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
3776: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_DEP_VAL_DATE_INFO', 'DEPOSIT_VALUE_EFFECTIVE_DATE');
3777: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_DEP_VAL_DATE_INFO', 'DEPOSIT_VALUE_END_DATE');
3778: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
3779: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);

Line 3778: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);

3774: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
3775: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
3776: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_DEP_VAL_DATE_INFO', 'DEPOSIT_VALUE_EFFECTIVE_DATE');
3777: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_DEP_VAL_DATE_INFO', 'DEPOSIT_VALUE_END_DATE');
3778: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
3779: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
3780: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
3781: l_error_rec.ERROR_LEVEL := 'I';
3782: l_error_table(l_error_table.LAST) := l_error_rec;

Line 3779: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);

3775: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
3776: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_DEP_VAL_DATE_INFO', 'DEPOSIT_VALUE_EFFECTIVE_DATE');
3777: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_DEP_VAL_DATE_INFO', 'DEPOSIT_VALUE_END_DATE');
3778: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
3779: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
3780: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
3781: l_error_rec.ERROR_LEVEL := 'I';
3782: l_error_table(l_error_table.LAST) := l_error_rec;
3783: END IF;

Line 3780: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();

3776: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_DEP_VAL_DATE_INFO', 'DEPOSIT_VALUE_EFFECTIVE_DATE');
3777: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_DEP_VAL_DATE_INFO', 'DEPOSIT_VALUE_END_DATE');
3778: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
3779: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
3780: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
3781: l_error_rec.ERROR_LEVEL := 'I';
3782: l_error_table(l_error_table.LAST) := l_error_rec;
3783: END IF;
3784: EXCEPTION

Line 3809: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');

3805: Get_Associated_Page_Details(l_catalog_group_id, 'EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_CAMPAIGN_INFO', l_page_id, l_page_display_name);
3806: l_error_table.EXTEND;
3807: l_error_rec.PAGE_ID := l_page_id;
3808: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
3809: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
3810: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_CAMPAIGN_INFO', 'CAMPAIGN_START_DATE');
3811: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_CAMPAIGN_INFO', 'CAMPAIGN_END_DATE');
3812: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
3813: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);

Line 3812: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);

3808: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
3809: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
3810: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_CAMPAIGN_INFO', 'CAMPAIGN_START_DATE');
3811: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_CAMPAIGN_INFO', 'CAMPAIGN_END_DATE');
3812: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
3813: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
3814: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
3815: l_error_rec.ERROR_LEVEL := 'I';
3816: l_error_table(l_error_table.LAST) := l_error_rec;

Line 3813: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);

3809: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
3810: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_CAMPAIGN_INFO', 'CAMPAIGN_START_DATE');
3811: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_CAMPAIGN_INFO', 'CAMPAIGN_END_DATE');
3812: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
3813: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
3814: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
3815: l_error_rec.ERROR_LEVEL := 'I';
3816: l_error_table(l_error_table.LAST) := l_error_rec;
3817: END IF;

Line 3814: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();

3810: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_CAMPAIGN_INFO', 'CAMPAIGN_START_DATE');
3811: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_CAMPAIGN_INFO', 'CAMPAIGN_END_DATE');
3812: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
3813: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
3814: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
3815: l_error_rec.ERROR_LEVEL := 'I';
3816: l_error_table(l_error_table.LAST) := l_error_rec;
3817: END IF;
3818: EXCEPTION

Line 3843: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');

3839: Get_Associated_Page_Details(l_catalog_group_id, 'EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_SEASON_AVL_DATE', l_page_id, l_page_display_name);
3840: l_error_table.EXTEND;
3841: l_error_rec.PAGE_ID := l_page_id;
3842: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
3843: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
3844: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_SEASON_AVL_DATE', 'SEASONAL_AVL_START_DATE');
3845: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_SEASON_AVL_DATE', 'SEASONAL_AVL_END_DATE');
3846: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
3847: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);

Line 3846: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);

3842: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
3843: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
3844: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_SEASON_AVL_DATE', 'SEASONAL_AVL_START_DATE');
3845: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_SEASON_AVL_DATE', 'SEASONAL_AVL_END_DATE');
3846: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
3847: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
3848: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
3849: l_error_rec.ERROR_LEVEL := 'I';
3850: l_error_table(l_error_table.LAST) := l_error_rec;

Line 3847: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);

3843: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
3844: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_SEASON_AVL_DATE', 'SEASONAL_AVL_START_DATE');
3845: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_SEASON_AVL_DATE', 'SEASONAL_AVL_END_DATE');
3846: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
3847: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
3848: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
3849: l_error_rec.ERROR_LEVEL := 'I';
3850: l_error_table(l_error_table.LAST) := l_error_rec;
3851: END IF;

Line 3848: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();

3844: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_SEASON_AVL_DATE', 'SEASONAL_AVL_START_DATE');
3845: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_SEASON_AVL_DATE', 'SEASONAL_AVL_END_DATE');
3846: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
3847: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
3848: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
3849: l_error_rec.ERROR_LEVEL := 'I';
3850: l_error_table(l_error_table.LAST) := l_error_rec;
3851: END IF;
3852: EXCEPTION

Line 3886: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');

3882: END IF;
3883: l_error_table.EXTEND;
3884: l_error_rec.PAGE_ID := l_page_id;
3885: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
3886: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
3887: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_STRG_HNDLG_HUMIDTY', 'STORAGE_HNDLNG_HUMDTY_MIN');
3888: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_STRG_HNDLG_HUMIDTY', 'STORAGE_HNDLNG_HUMDTY_MAX');
3889: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
3890: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);

Line 3889: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);

3885: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
3886: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
3887: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_STRG_HNDLG_HUMIDTY', 'STORAGE_HNDLNG_HUMDTY_MIN');
3888: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_STRG_HNDLG_HUMIDTY', 'STORAGE_HNDLNG_HUMDTY_MAX');
3889: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
3890: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
3891: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
3892: l_error_rec.ERROR_LEVEL := 'I';
3893: l_error_table(l_error_table.LAST) := l_error_rec;

Line 3890: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);

3886: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
3887: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_STRG_HNDLG_HUMIDTY', 'STORAGE_HNDLNG_HUMDTY_MIN');
3888: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_STRG_HNDLG_HUMIDTY', 'STORAGE_HNDLNG_HUMDTY_MAX');
3889: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
3890: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
3891: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
3892: l_error_rec.ERROR_LEVEL := 'I';
3893: l_error_table(l_error_table.LAST) := l_error_rec;
3894: END IF;

Line 3891: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();

3887: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_STRG_HNDLG_HUMIDTY', 'STORAGE_HNDLNG_HUMDTY_MIN');
3888: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_STRG_HNDLG_HUMIDTY', 'STORAGE_HNDLNG_HUMDTY_MAX');
3889: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
3890: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
3891: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
3892: l_error_rec.ERROR_LEVEL := 'I';
3893: l_error_table(l_error_table.LAST) := l_error_rec;
3894: END IF;
3895: END LOOP;

Line 3932: FND_MESSAGE.SET_NAME('EGO', 'EGO_3ATTRS_MUST_COEXIST');

3928: Get_Associated_Page_Details(l_catalog_group_id, 'EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_TRADE_ITEM_INFO', l_page_id, l_page_display_name);
3929: l_error_table.EXTEND;
3930: l_error_rec.PAGE_ID := l_page_id;
3931: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
3932: FND_MESSAGE.SET_NAME('EGO', 'EGO_3ATTRS_MUST_COEXIST');
3933: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_TRADE_ITEM_INFO', 'PEG_HOLE_NUMBER');
3934: l_attr2_name := Get_Attr_Display_Name('EGO_ITEM_GTIN_ATTRS', 'Trade_Item_Measurements', 'Peg_Horizontal');
3935: l_attr3_name := Get_Attr_Display_Name('EGO_ITEM_GTIN_ATTRS', 'Trade_Item_Measurements', 'Peg_Vertical');
3936: FND_MESSAGE.SET_TOKEN('ATTR1', l_attr1_name);

Line 3936: FND_MESSAGE.SET_TOKEN('ATTR1', l_attr1_name);

3932: FND_MESSAGE.SET_NAME('EGO', 'EGO_3ATTRS_MUST_COEXIST');
3933: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_TRADE_ITEM_INFO', 'PEG_HOLE_NUMBER');
3934: l_attr2_name := Get_Attr_Display_Name('EGO_ITEM_GTIN_ATTRS', 'Trade_Item_Measurements', 'Peg_Horizontal');
3935: l_attr3_name := Get_Attr_Display_Name('EGO_ITEM_GTIN_ATTRS', 'Trade_Item_Measurements', 'Peg_Vertical');
3936: FND_MESSAGE.SET_TOKEN('ATTR1', l_attr1_name);
3937: FND_MESSAGE.SET_TOKEN('ATTR2', l_attr2_name);
3938: FND_MESSAGE.SET_TOKEN('ATTR3', l_attr3_name);
3939: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
3940: l_error_rec.ERROR_LEVEL := 'I';

Line 3937: FND_MESSAGE.SET_TOKEN('ATTR2', l_attr2_name);

3933: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_TRADE_ITEM_INFO', 'PEG_HOLE_NUMBER');
3934: l_attr2_name := Get_Attr_Display_Name('EGO_ITEM_GTIN_ATTRS', 'Trade_Item_Measurements', 'Peg_Horizontal');
3935: l_attr3_name := Get_Attr_Display_Name('EGO_ITEM_GTIN_ATTRS', 'Trade_Item_Measurements', 'Peg_Vertical');
3936: FND_MESSAGE.SET_TOKEN('ATTR1', l_attr1_name);
3937: FND_MESSAGE.SET_TOKEN('ATTR2', l_attr2_name);
3938: FND_MESSAGE.SET_TOKEN('ATTR3', l_attr3_name);
3939: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
3940: l_error_rec.ERROR_LEVEL := 'I';
3941: l_error_table(l_error_table.LAST) := l_error_rec;

Line 3938: FND_MESSAGE.SET_TOKEN('ATTR3', l_attr3_name);

3934: l_attr2_name := Get_Attr_Display_Name('EGO_ITEM_GTIN_ATTRS', 'Trade_Item_Measurements', 'Peg_Horizontal');
3935: l_attr3_name := Get_Attr_Display_Name('EGO_ITEM_GTIN_ATTRS', 'Trade_Item_Measurements', 'Peg_Vertical');
3936: FND_MESSAGE.SET_TOKEN('ATTR1', l_attr1_name);
3937: FND_MESSAGE.SET_TOKEN('ATTR2', l_attr2_name);
3938: FND_MESSAGE.SET_TOKEN('ATTR3', l_attr3_name);
3939: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
3940: l_error_rec.ERROR_LEVEL := 'I';
3941: l_error_table(l_error_table.LAST) := l_error_rec;
3942: END IF;

Line 3939: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();

3935: l_attr3_name := Get_Attr_Display_Name('EGO_ITEM_GTIN_ATTRS', 'Trade_Item_Measurements', 'Peg_Vertical');
3936: FND_MESSAGE.SET_TOKEN('ATTR1', l_attr1_name);
3937: FND_MESSAGE.SET_TOKEN('ATTR2', l_attr2_name);
3938: FND_MESSAGE.SET_TOKEN('ATTR3', l_attr3_name);
3939: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
3940: l_error_rec.ERROR_LEVEL := 'I';
3941: l_error_table(l_error_table.LAST) := l_error_rec;
3942: END IF;
3943: EXCEPTION

Line 3977: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_REQD');

3973: END IF;
3974: l_error_table.EXTEND;
3975: l_error_rec.PAGE_ID := l_page_id;
3976: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
3977: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_REQD');
3978: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_PRC_CMPRSN_MSRMT', 'PRICE_COMPARISON_MSRMNT');
3979: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
3980: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
3981: l_error_rec.ERROR_LEVEL := 'I';

Line 3979: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);

3975: l_error_rec.PAGE_ID := l_page_id;
3976: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
3977: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_REQD');
3978: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_PRC_CMPRSN_MSRMT', 'PRICE_COMPARISON_MSRMNT');
3979: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
3980: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
3981: l_error_rec.ERROR_LEVEL := 'I';
3982: l_error_table(l_error_table.LAST) := l_error_rec;
3983: END IF;

Line 3980: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();

3976: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
3977: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_REQD');
3978: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_PRC_CMPRSN_MSRMT', 'PRICE_COMPARISON_MSRMNT');
3979: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
3980: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
3981: l_error_rec.ERROR_LEVEL := 'I';
3982: l_error_table(l_error_table.LAST) := l_error_rec;
3983: END IF;
3984: END LOOP;

Line 3995: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_CLASS_REQD');

3991: Get_Associated_Page_Details(l_catalog_group_id, 'EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_PRC_CMPRSN_MSRMT', l_page_id, l_page_display_name);
3992: l_error_table.EXTEND;
3993: l_error_rec.PAGE_ID := l_page_id;
3994: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
3995: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_CLASS_REQD');
3996: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_PRC_CMPRSN_MSRMT', 'PRICE_COMPARISON_MSRMNT');
3997: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
3998: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
3999: l_error_rec.ERROR_LEVEL := 'I';

Line 3997: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);

3993: l_error_rec.PAGE_ID := l_page_id;
3994: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
3995: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_CLASS_REQD');
3996: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_PRC_CMPRSN_MSRMT', 'PRICE_COMPARISON_MSRMNT');
3997: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
3998: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
3999: l_error_rec.ERROR_LEVEL := 'I';
4000: l_error_table(l_error_table.LAST) := l_error_rec;
4001: WHEN NO_DATA_FOUND THEN

Line 3998: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();

3994: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
3995: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_CLASS_REQD');
3996: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_PRC_CMPRSN_MSRMT', 'PRICE_COMPARISON_MSRMNT');
3997: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
3998: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
3999: l_error_rec.ERROR_LEVEL := 'I';
4000: l_error_table(l_error_table.LAST) := l_error_rec;
4001: WHEN NO_DATA_FOUND THEN
4002: IF c_ref_cursor%ISOPEN THEN

Line 4030: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_REQD');

4026: Get_Associated_Page_Details(l_catalog_group_id, 'EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_TRADE_ITEM_INFO', l_page_id, l_page_display_name);
4027: l_error_table.EXTEND;
4028: l_error_rec.PAGE_ID := l_page_id;
4029: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4030: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_REQD');
4031: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_TRADE_ITEM_INFO', 'TRADE_ITEM_COMPOSTN_WIDTH');
4032: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4033: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4034: l_error_rec.ERROR_LEVEL := 'I';

Line 4032: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);

4028: l_error_rec.PAGE_ID := l_page_id;
4029: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4030: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_REQD');
4031: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_TRADE_ITEM_INFO', 'TRADE_ITEM_COMPOSTN_WIDTH');
4032: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4033: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4034: l_error_rec.ERROR_LEVEL := 'I';
4035: l_error_table(l_error_table.LAST) := l_error_rec;
4036: END IF;

Line 4033: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();

4029: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4030: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_REQD');
4031: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_TRADE_ITEM_INFO', 'TRADE_ITEM_COMPOSTN_WIDTH');
4032: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4033: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4034: l_error_rec.ERROR_LEVEL := 'I';
4035: l_error_table(l_error_table.LAST) := l_error_rec;
4036: END IF;
4037: EXCEPTION

Line 4043: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_CLASS_REQD');

4039: Get_Associated_Page_Details(l_catalog_group_id, 'EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_TRADE_ITEM_INFO', l_page_id, l_page_display_name);
4040: l_error_table.EXTEND;
4041: l_error_rec.PAGE_ID := l_page_id;
4042: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4043: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_CLASS_REQD');
4044: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_TRADE_ITEM_INFO', 'TRADE_ITEM_COMPOSTN_WIDTH');
4045: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4046: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4047: l_error_rec.ERROR_LEVEL := 'I';

Line 4045: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);

4041: l_error_rec.PAGE_ID := l_page_id;
4042: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4043: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_CLASS_REQD');
4044: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_TRADE_ITEM_INFO', 'TRADE_ITEM_COMPOSTN_WIDTH');
4045: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4046: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4047: l_error_rec.ERROR_LEVEL := 'I';
4048: l_error_table(l_error_table.LAST) := l_error_rec;
4049: WHEN NO_DATA_FOUND THEN

Line 4046: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();

4042: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4043: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_CLASS_REQD');
4044: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_TRADE_ITEM_INFO', 'TRADE_ITEM_COMPOSTN_WIDTH');
4045: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4046: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4047: l_error_rec.ERROR_LEVEL := 'I';
4048: l_error_table(l_error_table.LAST) := l_error_rec;
4049: WHEN NO_DATA_FOUND THEN
4050: NULL;

Line 4073: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_REQD');

4069: Get_Associated_Page_Details(l_catalog_group_id, 'EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_MATERIAL_INFO', l_page_id, l_page_display_name);
4070: l_error_table.EXTEND;
4071: l_error_rec.PAGE_ID := l_page_id;
4072: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4073: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_REQD');
4074: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_MATERIAL_INFO', 'MATERIAL_WEIGHT');
4075: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4076: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4077: l_error_rec.ERROR_LEVEL := 'I';

Line 4075: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);

4071: l_error_rec.PAGE_ID := l_page_id;
4072: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4073: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_REQD');
4074: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_MATERIAL_INFO', 'MATERIAL_WEIGHT');
4075: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4076: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4077: l_error_rec.ERROR_LEVEL := 'I';
4078: l_error_table(l_error_table.LAST) := l_error_rec;
4079: END IF;

Line 4076: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();

4072: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4073: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_REQD');
4074: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_MATERIAL_INFO', 'MATERIAL_WEIGHT');
4075: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4076: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4077: l_error_rec.ERROR_LEVEL := 'I';
4078: l_error_table(l_error_table.LAST) := l_error_rec;
4079: END IF;
4080: EXCEPTION

Line 4086: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_CLASS_REQD');

4082: Get_Associated_Page_Details(l_catalog_group_id, 'EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_MATERIAL_INFO', l_page_id, l_page_display_name);
4083: l_error_table.EXTEND;
4084: l_error_rec.PAGE_ID := l_page_id;
4085: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4086: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_CLASS_REQD');
4087: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_MATERIAL_INFO', 'MATERIAL_WEIGHT');
4088: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4089: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4090: l_error_rec.ERROR_LEVEL := 'I';

Line 4088: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);

4084: l_error_rec.PAGE_ID := l_page_id;
4085: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4086: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_CLASS_REQD');
4087: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_MATERIAL_INFO', 'MATERIAL_WEIGHT');
4088: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4089: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4090: l_error_rec.ERROR_LEVEL := 'I';
4091: l_error_table(l_error_table.LAST) := l_error_rec;
4092: WHEN NO_DATA_FOUND THEN

Line 4089: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();

4085: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4086: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_CLASS_REQD');
4087: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_MATERIAL_INFO', 'MATERIAL_WEIGHT');
4088: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4089: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4090: l_error_rec.ERROR_LEVEL := 'I';
4091: l_error_table(l_error_table.LAST) := l_error_rec;
4092: WHEN NO_DATA_FOUND THEN
4093: NULL;

Line 4126: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_REQD');

4122: END IF;
4123: l_error_table.EXTEND;
4124: l_error_rec.PAGE_ID := l_page_id;
4125: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4126: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_REQD');
4127: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_STRG_HNDLG_HUMIDTY', 'STORAGE_HNDLNG_HUMDTY_MIN');
4128: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4129: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4130: l_error_rec.ERROR_LEVEL := 'I';

Line 4128: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);

4124: l_error_rec.PAGE_ID := l_page_id;
4125: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4126: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_REQD');
4127: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_STRG_HNDLG_HUMIDTY', 'STORAGE_HNDLNG_HUMDTY_MIN');
4128: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4129: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4130: l_error_rec.ERROR_LEVEL := 'I';
4131: l_error_table(l_error_table.LAST) := l_error_rec;
4132: END IF;

Line 4129: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();

4125: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4126: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_REQD');
4127: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_STRG_HNDLG_HUMIDTY', 'STORAGE_HNDLNG_HUMDTY_MIN');
4128: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4129: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4130: l_error_rec.ERROR_LEVEL := 'I';
4131: l_error_table(l_error_table.LAST) := l_error_rec;
4132: END IF;
4133:

Line 4142: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_REQD');

4138: END IF;
4139: l_error_table.EXTEND;
4140: l_error_rec.PAGE_ID := l_page_id;
4141: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4142: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_REQD');
4143: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_STRG_HNDLG_HUMIDTY', 'STORAGE_HNDLNG_HUMDTY_MAX');
4144: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4145: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4146: l_error_rec.ERROR_LEVEL := 'I';

Line 4144: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);

4140: l_error_rec.PAGE_ID := l_page_id;
4141: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4142: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_REQD');
4143: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_STRG_HNDLG_HUMIDTY', 'STORAGE_HNDLNG_HUMDTY_MAX');
4144: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4145: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4146: l_error_rec.ERROR_LEVEL := 'I';
4147: l_error_table(l_error_table.LAST) := l_error_rec;
4148: END IF;

Line 4145: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();

4141: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4142: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_REQD');
4143: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_STRG_HNDLG_HUMIDTY', 'STORAGE_HNDLNG_HUMDTY_MAX');
4144: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4145: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4146: l_error_rec.ERROR_LEVEL := 'I';
4147: l_error_table(l_error_table.LAST) := l_error_rec;
4148: END IF;
4149: END LOOP;

Line 4160: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_CLASS_REQD2');

4156: Get_Associated_Page_Details(l_catalog_group_id, 'EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_STRG_HNDLG_HUMIDTY', l_page_id, l_page_display_name);
4157: l_error_table.EXTEND;
4158: l_error_rec.PAGE_ID := l_page_id;
4159: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4160: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_CLASS_REQD2');
4161: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_STRG_HNDLG_HUMIDTY', 'STORAGE_HNDLNG_HUMDTY_MIN');
4162: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_STRG_HNDLG_HUMIDTY', 'STORAGE_HNDLNG_HUMDTY_MAX');
4163: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4164: FND_MESSAGE.SET_TOKEN('ATTR1_NAME', l_attr2_name);

Line 4163: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);

4159: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4160: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_CLASS_REQD2');
4161: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_STRG_HNDLG_HUMIDTY', 'STORAGE_HNDLNG_HUMDTY_MIN');
4162: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_STRG_HNDLG_HUMIDTY', 'STORAGE_HNDLNG_HUMDTY_MAX');
4163: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4164: FND_MESSAGE.SET_TOKEN('ATTR1_NAME', l_attr2_name);
4165: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4166: l_error_rec.ERROR_LEVEL := 'I';
4167: l_error_table(l_error_table.LAST) := l_error_rec;

Line 4164: FND_MESSAGE.SET_TOKEN('ATTR1_NAME', l_attr2_name);

4160: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_CLASS_REQD2');
4161: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_STRG_HNDLG_HUMIDTY', 'STORAGE_HNDLNG_HUMDTY_MIN');
4162: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_STRG_HNDLG_HUMIDTY', 'STORAGE_HNDLNG_HUMDTY_MAX');
4163: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4164: FND_MESSAGE.SET_TOKEN('ATTR1_NAME', l_attr2_name);
4165: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4166: l_error_rec.ERROR_LEVEL := 'I';
4167: l_error_table(l_error_table.LAST) := l_error_rec;
4168: WHEN NO_DATA_FOUND THEN

Line 4165: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();

4161: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_STRG_HNDLG_HUMIDTY', 'STORAGE_HNDLNG_HUMDTY_MIN');
4162: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_STRG_HNDLG_HUMIDTY', 'STORAGE_HNDLNG_HUMDTY_MAX');
4163: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4164: FND_MESSAGE.SET_TOKEN('ATTR1_NAME', l_attr2_name);
4165: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4166: l_error_rec.ERROR_LEVEL := 'I';
4167: l_error_table(l_error_table.LAST) := l_error_rec;
4168: WHEN NO_DATA_FOUND THEN
4169: IF c_ref_cursor%ISOPEN THEN

Line 4239: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');

4235: END IF; -- IF l_do_tp_validations THEN
4236: END IF;
4237: l_error_rec.PAGE_ID := l_page_id;
4238: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4239: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
4240: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_BUYING_QTY_INFO', 'AGREED_MINIMUM_BUYING_QTY');
4241: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_BUYING_QTY_INFO', 'AGREED_MAXIMUM_BUYING_QTY');
4242: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
4243: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);

Line 4242: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);

4238: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4239: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
4240: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_BUYING_QTY_INFO', 'AGREED_MINIMUM_BUYING_QTY');
4241: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_BUYING_QTY_INFO', 'AGREED_MAXIMUM_BUYING_QTY');
4242: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
4243: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
4244: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4245: l_error_table(l_error_table.LAST) := l_error_rec;
4246: END IF;

Line 4243: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);

4239: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
4240: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_BUYING_QTY_INFO', 'AGREED_MINIMUM_BUYING_QTY');
4241: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_BUYING_QTY_INFO', 'AGREED_MAXIMUM_BUYING_QTY');
4242: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
4243: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
4244: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4245: l_error_table(l_error_table.LAST) := l_error_rec;
4246: END IF;
4247:

Line 4244: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();

4240: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_BUYING_QTY_INFO', 'AGREED_MINIMUM_BUYING_QTY');
4241: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_BUYING_QTY_INFO', 'AGREED_MAXIMUM_BUYING_QTY');
4242: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
4243: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
4244: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4245: l_error_table(l_error_table.LAST) := l_error_rec;
4246: END IF;
4247:
4248: -- 11. START_DATE_MINIMUM_BUYING_QTY can not be more than END_DATE_MINIMUM_BUYING_QTY

Line 4262: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');

4258: END IF; --IF l_do_tp_validations THEN
4259: END IF;
4260: l_error_rec.PAGE_ID := l_page_id;
4261: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4262: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
4263: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_BUYING_QTY_INFO', 'START_DATE_MINIMUM_BUYING_QTY');
4264: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_BUYING_QTY_INFO', 'END_DATE_MINIMUM_BUYING_QTY');
4265: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
4266: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);

Line 4265: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);

4261: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4262: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
4263: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_BUYING_QTY_INFO', 'START_DATE_MINIMUM_BUYING_QTY');
4264: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_BUYING_QTY_INFO', 'END_DATE_MINIMUM_BUYING_QTY');
4265: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
4266: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
4267: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4268: l_error_table(l_error_table.LAST) := l_error_rec;
4269: END IF;

Line 4266: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);

4262: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
4263: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_BUYING_QTY_INFO', 'START_DATE_MINIMUM_BUYING_QTY');
4264: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_BUYING_QTY_INFO', 'END_DATE_MINIMUM_BUYING_QTY');
4265: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
4266: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
4267: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4268: l_error_table(l_error_table.LAST) := l_error_rec;
4269: END IF;
4270:

Line 4267: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();

4263: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_BUYING_QTY_INFO', 'START_DATE_MINIMUM_BUYING_QTY');
4264: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_BUYING_QTY_INFO', 'END_DATE_MINIMUM_BUYING_QTY');
4265: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
4266: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
4267: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4268: l_error_table(l_error_table.LAST) := l_error_rec;
4269: END IF;
4270:
4271: -- 12. START_DATE_MAXIMUM_BUYING_QTY can not be more than END_DATE_MAXIMUM_BUYING_QTY

Line 4285: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');

4281: END IF; --IF l_do_tp_validations THEN
4282: END IF;
4283: l_error_rec.PAGE_ID := l_page_id;
4284: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4285: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
4286: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_BUYING_QTY_INFO', 'START_DATE_MAXIMUM_BUYING_QTY');
4287: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_BUYING_QTY_INFO', 'END_DATE_MAXIMUM_BUYING_QTY');
4288: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
4289: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);

Line 4288: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);

4284: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4285: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
4286: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_BUYING_QTY_INFO', 'START_DATE_MAXIMUM_BUYING_QTY');
4287: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_BUYING_QTY_INFO', 'END_DATE_MAXIMUM_BUYING_QTY');
4288: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
4289: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
4290: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4291: l_error_table(l_error_table.LAST) := l_error_rec;
4292: END IF;

Line 4289: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);

4285: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
4286: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_BUYING_QTY_INFO', 'START_DATE_MAXIMUM_BUYING_QTY');
4287: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_BUYING_QTY_INFO', 'END_DATE_MAXIMUM_BUYING_QTY');
4288: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
4289: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
4290: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4291: l_error_table(l_error_table.LAST) := l_error_rec;
4292: END IF;
4293: EXCEPTION

Line 4290: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();

4286: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_BUYING_QTY_INFO', 'START_DATE_MAXIMUM_BUYING_QTY');
4287: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_BUYING_QTY_INFO', 'END_DATE_MAXIMUM_BUYING_QTY');
4288: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
4289: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
4290: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4291: l_error_table(l_error_table.LAST) := l_error_rec;
4292: END IF;
4293: EXCEPTION
4294: WHEN NO_DATA_FOUND THEN

Line 4347: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');

4343: l_error_rec.ERROR_LEVEL := 'I';
4344: END IF; --IF l_do_tp_validations THEN
4345: l_error_rec.PAGE_ID := l_page_id;
4346: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4347: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
4348: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_ORDERING_INFO', 'FIRST_ORDER_DATE');
4349: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_ORDERING_INFO', 'LAST_ORDER_DATE');
4350: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
4351: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);

Line 4350: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);

4346: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4347: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
4348: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_ORDERING_INFO', 'FIRST_ORDER_DATE');
4349: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_ORDERING_INFO', 'LAST_ORDER_DATE');
4350: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
4351: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
4352: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4353: l_error_table(l_error_table.LAST) := l_error_rec;
4354: END IF;

Line 4351: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);

4347: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
4348: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_ORDERING_INFO', 'FIRST_ORDER_DATE');
4349: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_ORDERING_INFO', 'LAST_ORDER_DATE');
4350: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
4351: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
4352: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4353: l_error_table(l_error_table.LAST) := l_error_rec;
4354: END IF;
4355: EXCEPTION

Line 4352: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();

4348: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_ORDERING_INFO', 'FIRST_ORDER_DATE');
4349: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_ORDERING_INFO', 'LAST_ORDER_DATE');
4350: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
4351: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
4352: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4353: l_error_table(l_error_table.LAST) := l_error_rec;
4354: END IF;
4355: EXCEPTION
4356: WHEN NO_DATA_FOUND THEN

Line 4409: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');

4405: l_error_rec.ERROR_LEVEL := 'I';
4406: END IF; --IF l_do_tp_validations THEN
4407: l_error_rec.PAGE_ID := l_page_id;
4408: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4409: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
4410: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_SHIP_EXCL_DATES', 'FIRST_SHIP_DATE');
4411: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_SHIP_EXCL_DATES', 'LAST_SHIP_DATE');
4412: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
4413: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);

Line 4412: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);

4408: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4409: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
4410: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_SHIP_EXCL_DATES', 'FIRST_SHIP_DATE');
4411: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_SHIP_EXCL_DATES', 'LAST_SHIP_DATE');
4412: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
4413: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
4414: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4415: l_error_table(l_error_table.LAST) := l_error_rec;
4416: END IF;

Line 4413: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);

4409: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
4410: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_SHIP_EXCL_DATES', 'FIRST_SHIP_DATE');
4411: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_SHIP_EXCL_DATES', 'LAST_SHIP_DATE');
4412: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
4413: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
4414: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4415: l_error_table(l_error_table.LAST) := l_error_rec;
4416: END IF;
4417: EXCEPTION

Line 4414: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();

4410: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_SHIP_EXCL_DATES', 'FIRST_SHIP_DATE');
4411: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_SHIP_EXCL_DATES', 'LAST_SHIP_DATE');
4412: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
4413: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
4414: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4415: l_error_table(l_error_table.LAST) := l_error_rec;
4416: END IF;
4417: EXCEPTION
4418: WHEN NO_DATA_FOUND THEN

Line 4480: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');

4476: l_error_rec.ERROR_LEVEL := 'I';
4477: END IF; --IF l_do_tp_validations THEN
4478: l_error_rec.PAGE_ID := l_page_id;
4479: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4480: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
4481: l_attr1_name := Get_Attr_Display_Name('EGO_ITEM_CUSTOMER_ATTRS', 'Handling_Information', 'Min_Trade_Item_Life_Arr');
4482: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_TRD_ITM_LIFESPAN', 'MIN_TRADE_ITEM_LIFE_PROD');
4483: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
4484: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);

Line 4483: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);

4479: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4480: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
4481: l_attr1_name := Get_Attr_Display_Name('EGO_ITEM_CUSTOMER_ATTRS', 'Handling_Information', 'Min_Trade_Item_Life_Arr');
4482: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_TRD_ITM_LIFESPAN', 'MIN_TRADE_ITEM_LIFE_PROD');
4483: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
4484: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
4485: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4486: l_error_table(l_error_table.LAST) := l_error_rec;
4487: END IF;

Line 4484: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);

4480: FND_MESSAGE.SET_NAME('EGO', 'EGO_MIN_GT_MAX');
4481: l_attr1_name := Get_Attr_Display_Name('EGO_ITEM_CUSTOMER_ATTRS', 'Handling_Information', 'Min_Trade_Item_Life_Arr');
4482: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_TRD_ITM_LIFESPAN', 'MIN_TRADE_ITEM_LIFE_PROD');
4483: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
4484: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
4485: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4486: l_error_table(l_error_table.LAST) := l_error_rec;
4487: END IF;
4488:

Line 4485: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();

4481: l_attr1_name := Get_Attr_Display_Name('EGO_ITEM_CUSTOMER_ATTRS', 'Handling_Information', 'Min_Trade_Item_Life_Arr');
4482: l_attr2_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_TRD_ITM_LIFESPAN', 'MIN_TRADE_ITEM_LIFE_PROD');
4483: FND_MESSAGE.SET_TOKEN('MIN_ATTR', l_attr1_name);
4484: FND_MESSAGE.SET_TOKEN('MAX_ATTR', l_attr2_name);
4485: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4486: l_error_table(l_error_table.LAST) := l_error_rec;
4487: END IF;
4488:
4489: EXCEPTION

Line 4543: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_REQD');

4539: l_error_rec.ERROR_LEVEL := 'I';
4540: END IF; --IF l_do_tp_validations THEN
4541: l_error_rec.PAGE_ID := l_page_id;
4542: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4543: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_REQD');
4544: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_ORDERING_INFO', 'GOODS_PICK_UP_LEAD_TIME');
4545: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4546: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4547: l_error_table(l_error_table.LAST) := l_error_rec;

Line 4545: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);

4541: l_error_rec.PAGE_ID := l_page_id;
4542: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4543: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_REQD');
4544: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_ORDERING_INFO', 'GOODS_PICK_UP_LEAD_TIME');
4545: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4546: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4547: l_error_table(l_error_table.LAST) := l_error_rec;
4548: END IF;
4549: EXCEPTION

Line 4546: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();

4542: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4543: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_REQD');
4544: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_ORDERING_INFO', 'GOODS_PICK_UP_LEAD_TIME');
4545: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4546: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4547: l_error_table(l_error_table.LAST) := l_error_rec;
4548: END IF;
4549: EXCEPTION
4550: WHEN column_not_found THEN

Line 4555: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_CLASS_REQD');

4551: Get_Associated_Page_Details(l_catalog_group_id, 'EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_ORDERING_INFO', l_page_id, l_page_display_name);
4552: l_error_table.EXTEND;
4553: l_error_rec.PAGE_ID := l_page_id;
4554: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4555: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_CLASS_REQD');
4556: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_ORDERING_INFO', 'GOODS_PICK_UP_LEAD_TIME');
4557: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4558: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4559: IF l_do_tp_validations THEN

Line 4557: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);

4553: l_error_rec.PAGE_ID := l_page_id;
4554: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4555: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_CLASS_REQD');
4556: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_ORDERING_INFO', 'GOODS_PICK_UP_LEAD_TIME');
4557: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4558: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4559: IF l_do_tp_validations THEN
4560: l_error_rec.ERROR_LEVEL := 'C';
4561: ELSE

Line 4558: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();

4554: l_error_rec.PAGE_DISPLAY_NAME := l_page_display_name;
4555: FND_MESSAGE.SET_NAME('EGO', 'EGO_UOM_CLASS_REQD');
4556: l_attr1_name := Get_Attr_Display_Name('EGO_ITEMMGMT_GROUP', 'EGOINT_GDSN_ORDERING_INFO', 'GOODS_PICK_UP_LEAD_TIME');
4557: FND_MESSAGE.SET_TOKEN('ATTR_NAME', l_attr1_name);
4558: l_error_rec.ERROR_MESSAGE := FND_MESSAGE.GET();
4559: IF l_do_tp_validations THEN
4560: l_error_rec.ERROR_LEVEL := 'C';
4561: ELSE
4562: l_error_rec.ERROR_LEVEL := 'I';