DBA Data[Home] [Help]

APPS.INV_THIRD_PARTY_STOCK_PVT dependencies on FND_MESSAGE

Line 363: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_GL_API_NO_RATE');

359: END IF;
360:
361: EXCEPTION
362: WHEN GL_CURRENCY_API.no_rate THEN
363: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_GL_API_NO_RATE');
364: FND_MESSAGE.Set_Token('SuppName',p_vendor_name);
365: FND_MESSAGE.Set_Token('SiteCode',p_vendor_site);
366: FND_MSG_PUB.ADD;
367: g_error_code := 'INV_CONS_SUP_GL_API_NO_RATE' ;

Line 364: FND_MESSAGE.Set_Token('SuppName',p_vendor_name);

360:
361: EXCEPTION
362: WHEN GL_CURRENCY_API.no_rate THEN
363: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_GL_API_NO_RATE');
364: FND_MESSAGE.Set_Token('SuppName',p_vendor_name);
365: FND_MESSAGE.Set_Token('SiteCode',p_vendor_site);
366: FND_MSG_PUB.ADD;
367: g_error_code := 'INV_CONS_SUP_GL_API_NO_RATE' ;
368: RAISE FND_API.G_EXC_ERROR;

Line 365: FND_MESSAGE.Set_Token('SiteCode',p_vendor_site);

361: EXCEPTION
362: WHEN GL_CURRENCY_API.no_rate THEN
363: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_GL_API_NO_RATE');
364: FND_MESSAGE.Set_Token('SuppName',p_vendor_name);
365: FND_MESSAGE.Set_Token('SiteCode',p_vendor_site);
366: FND_MSG_PUB.ADD;
367: g_error_code := 'INV_CONS_SUP_GL_API_NO_RATE' ;
368: RAISE FND_API.G_EXC_ERROR;
369:

Line 1042: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_NO_TAX_SETUP');

1038: THEN
1039: CLOSE tax_csr_type_rate;
1040: END IF;
1041:
1042: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_NO_TAX_SETUP');
1043: FND_MESSAGE.Set_Token('SuppName',p_vendor_name);
1044: FND_MESSAGE.Set_Token('SiteCode',p_vendor_site);
1045: FND_MSG_PUB.ADD;
1046: g_error_code := 'INV_CONS_SUP_NO_TAX_SETUP' ;

Line 1043: FND_MESSAGE.Set_Token('SuppName',p_vendor_name);

1039: CLOSE tax_csr_type_rate;
1040: END IF;
1041:
1042: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_NO_TAX_SETUP');
1043: FND_MESSAGE.Set_Token('SuppName',p_vendor_name);
1044: FND_MESSAGE.Set_Token('SiteCode',p_vendor_site);
1045: FND_MSG_PUB.ADD;
1046: g_error_code := 'INV_CONS_SUP_NO_TAX_SETUP' ;
1047: RAISE FND_API.G_EXC_ERROR;

Line 1044: FND_MESSAGE.Set_Token('SiteCode',p_vendor_site);

1040: END IF;
1041:
1042: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_NO_TAX_SETUP');
1043: FND_MESSAGE.Set_Token('SuppName',p_vendor_name);
1044: FND_MESSAGE.Set_Token('SiteCode',p_vendor_site);
1045: FND_MSG_PUB.ADD;
1046: g_error_code := 'INV_CONS_SUP_NO_TAX_SETUP' ;
1047: RAISE FND_API.G_EXC_ERROR;
1048:

Line 1575: FND_MESSAGE.Set_Name('INV','INV_CONS_SUP_MANUAL_NUM_CODE');

1571: IF l_header_id IS NULL
1572: THEN
1573: IF NVL(l_global_flag,'N') = 'Y'
1574: THEN
1575: FND_MESSAGE.Set_Name('INV','INV_CONS_SUP_MANUAL_NUM_CODE');
1576: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);
1577: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);
1578: FND_MSG_PUB.ADD;
1579: g_error_code := 'INV_CONS_SUP_MANUAL_NUM_CODE' ;

Line 1576: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);

1572: THEN
1573: IF NVL(l_global_flag,'N') = 'Y'
1574: THEN
1575: FND_MESSAGE.Set_Name('INV','INV_CONS_SUP_MANUAL_NUM_CODE');
1576: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);
1577: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);
1578: FND_MSG_PUB.ADD;
1579: g_error_code := 'INV_CONS_SUP_MANUAL_NUM_CODE' ;
1580: RAISE FND_API.G_EXC_ERROR;

Line 1577: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);

1573: IF NVL(l_global_flag,'N') = 'Y'
1574: THEN
1575: FND_MESSAGE.Set_Name('INV','INV_CONS_SUP_MANUAL_NUM_CODE');
1576: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);
1577: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);
1578: FND_MSG_PUB.ADD;
1579: g_error_code := 'INV_CONS_SUP_MANUAL_NUM_CODE' ;
1580: RAISE FND_API.G_EXC_ERROR;
1581: ELSE

Line 1582: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_NO_BPO_EXISTS');

1578: FND_MSG_PUB.ADD;
1579: g_error_code := 'INV_CONS_SUP_MANUAL_NUM_CODE' ;
1580: RAISE FND_API.G_EXC_ERROR;
1581: ELSE
1582: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_NO_BPO_EXISTS');
1583: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);
1584: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);
1585: FND_MSG_PUB.ADD;
1586: g_error_code := 'INV_CONS_SUP_NO_BPO_EXISTS' ;

Line 1583: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);

1579: g_error_code := 'INV_CONS_SUP_MANUAL_NUM_CODE' ;
1580: RAISE FND_API.G_EXC_ERROR;
1581: ELSE
1582: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_NO_BPO_EXISTS');
1583: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);
1584: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);
1585: FND_MSG_PUB.ADD;
1586: g_error_code := 'INV_CONS_SUP_NO_BPO_EXISTS' ;
1587: RAISE FND_API.G_EXC_ERROR;

Line 1584: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);

1580: RAISE FND_API.G_EXC_ERROR;
1581: ELSE
1582: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_NO_BPO_EXISTS');
1583: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);
1584: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);
1585: FND_MSG_PUB.ADD;
1586: g_error_code := 'INV_CONS_SUP_NO_BPO_EXISTS' ;
1587: RAISE FND_API.G_EXC_ERROR;
1588: END IF;

Line 1678: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_NO_UOM_CONV');

1674: -- If there is no conversion, error out
1675:
1676: IF l_conv_qty IS NULL OR l_conv_qty < 0
1677: THEN
1678: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_NO_UOM_CONV');
1679: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);
1680: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);
1681: FND_MSG_PUB.ADD;
1682: g_error_code := 'INV_CONS_SUP_NO_UOM_CONV' ;

Line 1679: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);

1675:
1676: IF l_conv_qty IS NULL OR l_conv_qty < 0
1677: THEN
1678: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_NO_UOM_CONV');
1679: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);
1680: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);
1681: FND_MSG_PUB.ADD;
1682: g_error_code := 'INV_CONS_SUP_NO_UOM_CONV' ;
1683: RAISE FND_API.G_EXC_ERROR;

Line 1680: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);

1676: IF l_conv_qty IS NULL OR l_conv_qty < 0
1677: THEN
1678: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_NO_UOM_CONV');
1679: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);
1680: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);
1681: FND_MSG_PUB.ADD;
1682: g_error_code := 'INV_CONS_SUP_NO_UOM_CONV' ;
1683: RAISE FND_API.G_EXC_ERROR;
1684: END IF;

Line 1709: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_NO_UOM_CONV');

1705: -- If there is no conversion rate, error out
1706:
1707: IF l_uom_rate IS NULL OR l_uom_rate < 0
1708: THEN
1709: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_NO_UOM_CONV');
1710: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);
1711: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);
1712: FND_MSG_PUB.ADD;
1713: g_error_code := 'INV_CONS_SUP_NO_UOM_CONV' ;

Line 1710: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);

1706:
1707: IF l_uom_rate IS NULL OR l_uom_rate < 0
1708: THEN
1709: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_NO_UOM_CONV');
1710: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);
1711: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);
1712: FND_MSG_PUB.ADD;
1713: g_error_code := 'INV_CONS_SUP_NO_UOM_CONV' ;
1714: RAISE FND_API.G_EXC_ERROR;

Line 1711: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);

1707: IF l_uom_rate IS NULL OR l_uom_rate < 0
1708: THEN
1709: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_NO_UOM_CONV');
1710: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);
1711: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);
1712: FND_MSG_PUB.ADD;
1713: g_error_code := 'INV_CONS_SUP_NO_UOM_CONV' ;
1714: RAISE FND_API.G_EXC_ERROR;
1715: END IF;

Line 1811: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_NO_BPO_EXISTS');

1807: /* Bug 4969420 - End*/
1808:
1809: IF l_po_price IS NULL
1810: THEN
1811: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_NO_BPO_EXISTS');
1812: FND_MSG_PUB.ADD;
1813: RAISE FND_API.G_EXC_ERROR;
1814: END IF;
1815:

Line 1963: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_NO_RATE_SETUP');

1959: WHERE NVL(org_id,-99) = NVL(l_org_id,-99);
1960:
1961: IF l_conv_type IS NULL
1962: THEN
1963: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_NO_RATE_SETUP');
1964: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);
1965: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);
1966: FND_MSG_PUB.ADD;
1967: g_error_code := 'INV_CONS_SUP_NO_RATE_SETUP';

Line 1964: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);

1960:
1961: IF l_conv_type IS NULL
1962: THEN
1963: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_NO_RATE_SETUP');
1964: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);
1965: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);
1966: FND_MSG_PUB.ADD;
1967: g_error_code := 'INV_CONS_SUP_NO_RATE_SETUP';
1968: RAISE FND_API.G_EXC_ERROR;

Line 1965: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);

1961: IF l_conv_type IS NULL
1962: THEN
1963: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_NO_RATE_SETUP');
1964: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);
1965: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);
1966: FND_MSG_PUB.ADD;
1967: g_error_code := 'INV_CONS_SUP_NO_RATE_SETUP';
1968: RAISE FND_API.G_EXC_ERROR;
1969: END IF;

Line 2046: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_AMT_AGREED_FAIL');

2042: IF (NVL(l_bkt_amt_limit,0) > 0) AND
2043: (NVL(l_released_amt,0)+NVL(l_consumed_amt,0)+
2044: NVL(l_purch_uom_price,0) > l_bkt_amt_limit)
2045: THEN
2046: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_AMT_AGREED_FAIL');
2047: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);
2048: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);
2049: FND_MSG_PUB.ADD;
2050: g_error_code := 'INV_CONS_SUP_AMT_AGREED_FAIL' ;

Line 2047: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);

2043: (NVL(l_released_amt,0)+NVL(l_consumed_amt,0)+
2044: NVL(l_purch_uom_price,0) > l_bkt_amt_limit)
2045: THEN
2046: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_AMT_AGREED_FAIL');
2047: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);
2048: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);
2049: FND_MSG_PUB.ADD;
2050: g_error_code := 'INV_CONS_SUP_AMT_AGREED_FAIL' ;
2051: RAISE FND_API.G_EXC_ERROR;

Line 2048: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);

2044: NVL(l_purch_uom_price,0) > l_bkt_amt_limit)
2045: THEN
2046: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_AMT_AGREED_FAIL');
2047: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);
2048: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);
2049: FND_MSG_PUB.ADD;
2050: g_error_code := 'INV_CONS_SUP_AMT_AGREED_FAIL' ;
2051: RAISE FND_API.G_EXC_ERROR;
2052: END IF;

Line 2430: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_GEN_ACCT');

2426: WHERE pov.vendor_id = povs.vendor_id
2427: AND pov.vendor_id = p_vendor_id
2428: AND povs.vendor_site_id = l_vendor_site_id;
2429:
2430: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_GEN_ACCT');
2431: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);
2432: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);
2433: FND_MSG_PUB.ADD;
2434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2431: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);

2427: AND pov.vendor_id = p_vendor_id
2428: AND povs.vendor_site_id = l_vendor_site_id;
2429:
2430: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_GEN_ACCT');
2431: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);
2432: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);
2433: FND_MSG_PUB.ADD;
2434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2435:

Line 2432: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);

2428: AND povs.vendor_site_id = l_vendor_site_id;
2429:
2430: FND_MESSAGE.Set_Name('INV', 'INV_CONS_SUP_GEN_ACCT');
2431: FND_MESSAGE.Set_Token('SuppName',l_vendor_name);
2432: FND_MESSAGE.Set_Token('SiteCode',l_vendor_site);
2433: FND_MSG_PUB.ADD;
2434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2435:
2436: END IF;