APPS.INL_INTEGRATION_GRP dependencies on FND_MSG_PUB

Line 69: FND_MSG_PUB.initialize;

65: SAVEPOINT Insert_LCMInterface_GRP;
66:
67: -- Initialize message list IF p_init_msg_list is SET to TRUE.
68: IF FND_API.to_Boolean (p_init_msg_list) THEN
69: FND_MSG_PUB.initialize;
70: END IF;
71:
72: -- Check FOR call compatibility.
73: IF NOT FND_API.Compatible_API_Call (

Line 396: FND_MSG_PUB.Count_And_Get(

392: COMMIT WORK;
393: END IF;
394:
395: -- Standard call to get message count and if count is 1, get message info.
396: FND_MSG_PUB.Count_And_Get(
397: p_encoded => FND_API.g_false,
398: p_count => x_msg_count,
399: p_data => x_msg_data);
400:

Line 414: FND_MSG_PUB.Count_And_Get(

410: p_module_name => g_module_name,
411: p_procedure_name => l_api_name);
412: ROLLBACK TO Insert_LCMInterface_GRP;
413: x_return_status := FND_API.G_RET_STS_ERROR;
414: FND_MSG_PUB.Count_And_Get(
415: p_encoded => FND_API.g_false,
416: p_count => x_msg_count,
417: p_data => x_msg_data);
418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 425: FND_MSG_PUB.Count_And_Get(

421: p_module_name => g_module_name,
422: p_procedure_name => l_api_name);
423: ROLLBACK TO Insert_LCMInterface_GRP;
424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
425: FND_MSG_PUB.Count_And_Get(
426: p_encoded => FND_API.g_false,
427: p_count => x_msg_count,
428: p_data => x_msg_data);
429: WHEN OTHERS THEN

Line 436: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

432: p_module_name => g_module_name,
433: p_procedure_name => l_api_name);
434: ROLLBACK TO Insert_LCMInterface_GRP;
435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
436: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
437: THEN
438: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,l_api_name);
439: END IF;
440: FND_MSG_PUB.Count_And_Get(

Line 438: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,l_api_name);

434: ROLLBACK TO Insert_LCMInterface_GRP;
435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
436: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
437: THEN
438: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,l_api_name);
439: END IF;
440: FND_MSG_PUB.Count_And_Get(
441: p_encoded => FND_API.g_false,
442: p_count => x_msg_count,

Line 440: FND_MSG_PUB.Count_And_Get(

436: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
437: THEN
438: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,l_api_name);
439: END IF;
440: FND_MSG_PUB.Count_And_Get(
441: p_encoded => FND_API.g_false,
442: p_count => x_msg_count,
443: p_data => x_msg_data);
444: END Insert_LCMInterface;

Line 530: FND_MSG_PUB.initialize;

526: p_procedure_name => l_proc_name);
527:
528: -- Initialize message list IF p_init_msg_list is SET to TRUE.
529: -- IF FND_API.to_Boolean (p_init_msg_list) THEN
530: FND_MSG_PUB.initialize;
531: -- END IF;
532:
533: -- Initialize API return status to success
534: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 572: FND_MSG_PUB.ADD;

568: -- In order to import data from RCV to LCM OI tables,
569: -- the INL:Default Shipment Type profile must be setup.
570: IF l_ship_type_id IS NULL OR l_ship_type_id = 0 THEN
571: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_SHIP_TYP_PROF') ;
572: FND_MSG_PUB.ADD;
573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
574: END IF;
575:
576: -- Set the number of records to be processed

Line 806: FND_MSG_PUB.ADD;

802: p_debug_info => 'Ship To Organization has not been setup in LCM Options');
803:
804: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_NO_LCM_OPT_DEF_ORG') ;
805: FND_MESSAGE.SET_TOKEN ('INV_ORG_NAME', l_ship_to_org_name) ;
806: FND_MSG_PUB.ADD;
807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
808: END;
809:
810: IF l_user_defined_ship_num_code = 'AUTOMATIC' THEN --Bug#8971617

Line 891: FND_MSG_PUB.ADD;

887: -- is no way to validate Third Party Sites Allowed
888: IF l_taxation_country IS NULL THEN
889: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_LOC_COUNTRY_NULL') ;
890: FND_MESSAGE.SET_TOKEN ('LOCATION_CODE', l_ship_to_location_code) ;
891: FND_MSG_PUB.ADD;
892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
893: END IF;
894:
895: INL_LOGGING_PVT.Log_Statement (

Line 1265: FND_MSG_PUB.ADD; --Bug#9737425

1261: EXCEPTION
1262: WHEN OTHERS THEN
1263: FND_MESSAGE.SET_NAME ('INL', 'INL_UNEXPECTED_ERR') ; --Bug#9737425
1264: FND_MESSAGE.SET_TOKEN ('ERROR_CODE', substr(SQLERRM, 1, 1000)) ; --Bug#9737425
1265: FND_MSG_PUB.ADD; --Bug#9737425
1266: INL_LOGGING_PVT.Log_UnexpecError (
1267: p_module_name => g_module_name,
1268: p_procedure_name => l_proc_name);
1269: INL_LOGGING_PVT.Log_Variable (

Line 1403: FND_MSG_PUB.Count_And_Get (

1399: END IF;
1400: --Bug#10381495
1401:
1402: -- Standard call to get message count and if count is 1, get message info.
1403: FND_MSG_PUB.Count_And_Get (
1404: p_encoded => FND_API.g_false,
1405: p_count => x_msg_count,
1406: p_data => x_msg_data) ;
1407:

Line 1434: FND_MSG_PUB.Count_And_Get (

1430: );
1431: mo_global.set_policy_context( l_previous_access_mode, l_previous_org_id);
1432: END IF;
1433: --Bug#10381495
1434: FND_MSG_PUB.Count_And_Get (
1435: p_encoded => FND_API.g_false,
1436: p_count => x_msg_count,
1437: p_data => x_msg_data) ;
1438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1458: FND_MSG_PUB.Count_And_Get (

1454: );
1455: mo_global.set_policy_context( l_previous_access_mode, l_previous_org_id);
1456: END IF;
1457: --Bug#10381495
1458: FND_MSG_PUB.Count_And_Get (
1459: p_encoded => FND_API.g_false,
1460: p_count => x_msg_count,
1461: p_data => x_msg_data) ;
1462: WHEN OTHERS THEN

Line 1482: FND_MSG_PUB.Count_And_Get (

1478: );
1479: mo_global.set_policy_context( l_previous_access_mode, l_previous_org_id);
1480: END IF;
1481: --Bug#10381495
1482: FND_MSG_PUB.Count_And_Get (
1483: p_encoded => FND_API.g_false,
1484: p_count => x_msg_count,
1485: p_data => x_msg_data) ;
1486: END Import_FromRCV;

Line 1548: FND_MSG_PUB.initialize;

1544: SAVEPOINT Get_LandedCost_GRP;
1545:
1546: -- Initialize message list IF p_init_msg_list is SET to TRUE.
1547: IF FND_API.to_Boolean (p_init_msg_list) THEN
1548: FND_MSG_PUB.initialize;
1549: END IF;
1550:
1551: -- Check FOR call compatibility.
1552: IF NOT FND_API.Compatible_API_Call (p_current_version_number => l_api_version,

Line 1609: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,

1605: COMMIT WORK;
1606: END IF;
1607:
1608: -- Get message count AND IF count is 1, get message info.
1609: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
1610: p_count => x_msg_count,
1611: p_data => x_msg_data) ;
1612:
1613: -- End of Procedure Logging

Line 1624: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,

1620: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name,
1621: p_procedure_name => l_api_name) ;
1622: ROLLBACK TO Get_LandedCost_GRP;
1623: x_return_status := FND_API.G_RET_STS_ERROR;
1624: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
1625: p_count => x_msg_count,
1626: p_data => x_msg_data) ;
1627: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1628: -- Standard Unexpected Error Logging

Line 1633: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,

1629: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
1630: p_procedure_name => l_api_name) ;
1631: ROLLBACK TO Get_LandedCost_GRP;
1632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1633: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
1634: p_count => x_msg_count,
1635: p_data => x_msg_data) ;
1636: WHEN OTHERS THEN
1637: -- Standard Unexpected Error Logging

Line 1642: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1638: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
1639: p_procedure_name => l_api_name) ;
1640: ROLLBACK TO Get_LandedCost_GRP;
1641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1642: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1643: FND_MSG_PUB.Add_Exc_Msg ( p_pkg_name => g_pkg_name,
1644: p_procedure_name => l_api_name) ;
1645: END IF;
1646: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,

Line 1643: FND_MSG_PUB.Add_Exc_Msg ( p_pkg_name => g_pkg_name,

1639: p_procedure_name => l_api_name) ;
1640: ROLLBACK TO Get_LandedCost_GRP;
1641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1642: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1643: FND_MSG_PUB.Add_Exc_Msg ( p_pkg_name => g_pkg_name,
1644: p_procedure_name => l_api_name) ;
1645: END IF;
1646: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
1647: p_count => x_msg_count,

Line 1646: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,

1642: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1643: FND_MSG_PUB.Add_Exc_Msg ( p_pkg_name => g_pkg_name,
1644: p_procedure_name => l_api_name) ;
1645: END IF;
1646: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
1647: p_count => x_msg_count,
1648: p_data => x_msg_data);
1649: END Get_LandedCost;
1650:

Line 1867: IF FND_MSG_PUB.Check_Msg_Level(p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1863: INL_LOGGING_PVT.Log_UnexpecError (
1864: p_module_name => g_module_name,
1865: p_procedure_name => l_proc_name);
1866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1867: IF FND_MSG_PUB.Check_Msg_Level(p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1868: FND_MSG_PUB.Add_Exc_Msg(
1869: p_pkg_name => g_pkg_name,
1870: p_procedure_name => l_proc_name);
1871: END IF;

Line 1868: FND_MSG_PUB.Add_Exc_Msg(

1864: p_module_name => g_module_name,
1865: p_procedure_name => l_proc_name);
1866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1867: IF FND_MSG_PUB.Check_Msg_Level(p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1868: FND_MSG_PUB.Add_Exc_Msg(
1869: p_pkg_name => g_pkg_name,
1870: p_procedure_name => l_proc_name);
1871: END IF;
1872: END Call_UpdateRCV;

Line 1919: FND_MSG_PUB.initialize;

1915: SAVEPOINT Call_StampLC_GRP;
1916:
1917: -- Initialize message list IF p_init_msg_list is SET to TRUE.
1918: IF FND_API.to_Boolean (p_init_msg_list) THEN
1919: FND_MSG_PUB.initialize;
1920: END IF;
1921:
1922: -- Check FOR call compatibility.
1923: IF NOT FND_API.Compatible_API_Call (p_current_version_number => l_api_version,

Line 1969: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,

1965: COMMIT WORK;
1966: END IF;
1967:
1968: -- Get message count AND IF count is 1, get message info.
1969: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
1970: p_count => x_msg_count,
1971: p_data => x_msg_data);
1972:
1973: -- End of Procedure Logging

Line 1983: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,

1979: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name,
1980: p_procedure_name => l_api_name);
1981: ROLLBACK TO Call_StampLC_GRP;
1982: x_return_status := FND_API.G_RET_STS_ERROR;
1983: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
1984: p_count => x_msg_count,
1985: p_data => x_msg_data);
1986: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1987: -- Standard Unexpected Error Logging

Line 1992: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,

1988: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
1989: p_procedure_name => l_api_name);
1990: ROLLBACK TO Call_StampLC_GRP;
1991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1992: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
1993: p_count => x_msg_count,
1994: p_data => x_msg_data) ;
1995: WHEN OTHERS THEN
1996: -- Standard Unexpected Error Logging

Line 2001: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1997: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
1998: p_procedure_name => l_api_name) ;
1999: ROLLBACK TO Call_StampLC_GRP;
2000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2001: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2002: FND_MSG_PUB.Add_Exc_Msg ( p_pkg_name => g_pkg_name,
2003: p_procedure_name => l_api_name) ;
2004: END IF;
2005: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,

Line 2002: FND_MSG_PUB.Add_Exc_Msg ( p_pkg_name => g_pkg_name,

1998: p_procedure_name => l_api_name) ;
1999: ROLLBACK TO Call_StampLC_GRP;
2000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2001: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2002: FND_MSG_PUB.Add_Exc_Msg ( p_pkg_name => g_pkg_name,
2003: p_procedure_name => l_api_name) ;
2004: END IF;
2005: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
2006: p_count => x_msg_count,

Line 2005: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,

2001: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2002: FND_MSG_PUB.Add_Exc_Msg ( p_pkg_name => g_pkg_name,
2003: p_procedure_name => l_api_name) ;
2004: END IF;
2005: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
2006: p_count => x_msg_count,
2007: p_data => x_msg_data) ;
2008: END Call_StampLC;
2009:

Line 2138: IF FND_MSG_PUB.Check_Msg_Level(p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2134: INL_LOGGING_PVT.Log_UnexpecError(
2135: p_module_name => g_module_name,
2136: p_procedure_name => l_proc_name);
2137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2138: IF FND_MSG_PUB.Check_Msg_Level(p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2139: FND_MSG_PUB.Add_Exc_Msg(
2140: p_pkg_name => g_pkg_name,
2141: p_procedure_name => l_proc_name);
2142: END IF;

Line 2139: FND_MSG_PUB.Add_Exc_Msg(

2135: p_module_name => g_module_name,
2136: p_procedure_name => l_proc_name);
2137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2138: IF FND_MSG_PUB.Check_Msg_Level(p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2139: FND_MSG_PUB.Add_Exc_Msg(
2140: p_pkg_name => g_pkg_name,
2141: p_procedure_name => l_proc_name);
2142: END IF;
2143: END Call_InsertRCV;

Line 2192: FND_MSG_PUB.initialize;

2188: SAVEPOINT Export_ToRCV_GRP;
2189:
2190: -- Initialize message list IF p_init_msg_list is SET to TRUE.
2191: IF FND_API.to_Boolean (p_init_msg_list) THEN
2192: FND_MSG_PUB.initialize;
2193: END IF;
2194:
2195: -- Check FOR call compatibility.
2196: IF NOT FND_API.Compatible_API_Call (p_current_version_number => l_api_version,

Line 2249: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2245: IF FND_API.To_Boolean (p_commit) THEN
2246: COMMIT WORK;
2247: END IF;
2248: -- Get message count AND IF count is 1, get message info.
2249: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2250: p_count => x_msg_count,
2251: p_data => x_msg_data) ;
2252: -- End of Procedure Logging
2253: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,

Line 2262: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2258: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_name,
2259: p_procedure_name => l_api_name) ;
2260: ROLLBACK TO Export_ToRCV_GRP;
2261: x_return_status := FND_API.G_RET_STS_ERROR;
2262: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2263: p_count => x_msg_count,
2264: p_data => x_msg_data) ;
2265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2266: -- Standard Unexpected Error Logging

Line 2271: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2267: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,
2268: p_procedure_name => l_api_name) ;
2269: ROLLBACK TO Export_ToRCV_GRP;
2270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2271: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2272: p_count => x_msg_count,
2273: p_data => x_msg_data) ;
2274: WHEN OTHERS THEN
2275: -- Standard Unexpected Error Logging

Line 2280: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2276: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,
2277: p_procedure_name => l_api_name) ;
2278: ROLLBACK TO Export_ToRCV_GRP;
2279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2280: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2281: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
2282: p_procedure_name => l_api_name) ;
2283: END IF;
2284: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 2281: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,

2277: p_procedure_name => l_api_name) ;
2278: ROLLBACK TO Export_ToRCV_GRP;
2279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2280: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2281: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
2282: p_procedure_name => l_api_name) ;
2283: END IF;
2284: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2285: p_count => x_msg_count,

Line 2284: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2280: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2281: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
2282: p_procedure_name => l_api_name) ;
2283: END IF;
2284: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2285: p_count => x_msg_count,
2286: p_data => x_msg_data) ;
2287: END Export_ToRCV;
2288:

Line 2417: FND_MSG_PUB.initialize;

2413: SAVEPOINT Export_ToCST_GRP;
2414:
2415: -- Initialize message list IF p_init_msg_list is SET to TRUE.
2416: IF FND_API.to_Boolean (p_init_msg_list) THEN
2417: FND_MSG_PUB.initialize;
2418: END IF;
2419:
2420: -- Check FOR call compatibility.
2421: IF NOT FND_API.Compatible_API_Call (p_current_version_number => l_api_version,

Line 2577: FND_MSG_PUB.Count_And_Get (

2573: IF FND_API.To_Boolean (p_commit) THEN
2574: COMMIT WORK;
2575: END IF;
2576: -- Get message count AND IF count is 1, get message info.
2577: FND_MSG_PUB.Count_And_Get (
2578: p_encoded => FND_API.g_false,
2579: p_count => x_msg_count,
2580: p_data => x_msg_data
2581: ) ;

Line 2595: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,

2591: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name,
2592: p_procedure_name => l_api_name) ;
2593: ROLLBACK TO Export_ToCST_GRP;
2594: x_return_status := FND_API.G_RET_STS_ERROR;
2595: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
2596: p_count => x_msg_count,
2597: p_data => x_msg_data) ;
2598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2599: -- Standard Unexpected Error Logging

Line 2604: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,

2600: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
2601: p_procedure_name => l_api_name) ;
2602: ROLLBACK TO Export_ToCST_GRP;
2603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2604: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
2605: p_count => x_msg_count,
2606: p_data => x_msg_data) ;
2607: WHEN OTHERS THEN
2608: -- Standard Unexpected Error Logging

Line 2613: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2609: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
2610: p_procedure_name => l_api_name) ;
2611: ROLLBACK TO Export_ToCST_GRP;
2612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2613: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2614: FND_MSG_PUB.Add_Exc_Msg ( p_pkg_name => g_pkg_name,
2615: p_procedure_name => l_api_name) ;
2616: END IF;
2617: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,

Line 2614: FND_MSG_PUB.Add_Exc_Msg ( p_pkg_name => g_pkg_name,

2610: p_procedure_name => l_api_name) ;
2611: ROLLBACK TO Export_ToCST_GRP;
2612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2613: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2614: FND_MSG_PUB.Add_Exc_Msg ( p_pkg_name => g_pkg_name,
2615: p_procedure_name => l_api_name) ;
2616: END IF;
2617: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
2618: p_count => x_msg_count,

Line 2617: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,

2613: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2614: FND_MSG_PUB.Add_Exc_Msg ( p_pkg_name => g_pkg_name,
2615: p_procedure_name => l_api_name) ;
2616: END IF;
2617: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
2618: p_count => x_msg_count,
2619: p_data => x_msg_data) ;
2620: END Export_ToCST;
2621:

Line 2678: FND_MSG_PUB.initialize;

2674: SAVEPOINT Get_CurrencyInfo_GRP;
2675:
2676: -- Initialize message list if p_init_msg_list is set to TRUE.
2677: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2678: FND_MSG_PUB.initialize;
2679: END IF;
2680:
2681: -- Check for call compatibility.
2682: IF NOT FND_API.Compatible_API_Call (

Line 2725: FND_MSG_PUB.Count_And_Get(

2721: COMMIT WORK;
2722: END IF;
2723:
2724: -- Standard call to get message count and if count is 1, get message info.
2725: FND_MSG_PUB.Count_And_Get(
2726: p_encoded => FND_API.g_false,
2727: p_count => x_msg_count,
2728: p_data => x_msg_data);
2729:

Line 2743: FND_MSG_PUB.Count_And_Get(

2739: p_procedure_name => l_api_name
2740: );
2741: ROLLBACK TO Get_CurrencyInfo_GRP;
2742: x_return_status := FND_API.G_RET_STS_ERROR;
2743: FND_MSG_PUB.Count_And_Get(
2744: p_encoded => FND_API.g_false,
2745: p_count => x_msg_count,
2746: p_data => x_msg_data
2747: );

Line 2755: FND_MSG_PUB.Count_And_Get(

2751: p_module_name => g_module_name,
2752: p_procedure_name => l_api_name);
2753: ROLLBACK TO Get_CurrencyInfo_GRP;
2754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2755: FND_MSG_PUB.Count_And_Get(
2756: p_encoded => FND_API.g_false,
2757: p_count => x_msg_count,
2758: p_data => x_msg_data);
2759: WHEN OTHERS THEN

Line 2766: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2762: p_module_name => g_module_name,
2763: p_procedure_name => l_api_name);
2764: ROLLBACK TO Get_CurrencyInfo_GRP;
2765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2766: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2767: THEN
2768: FND_MSG_PUB.Add_Exc_Msg(
2769: g_pkg_name,
2770: l_api_name);

Line 2768: FND_MSG_PUB.Add_Exc_Msg(

2764: ROLLBACK TO Get_CurrencyInfo_GRP;
2765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2766: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2767: THEN
2768: FND_MSG_PUB.Add_Exc_Msg(
2769: g_pkg_name,
2770: l_api_name);
2771: END IF;
2772: FND_MSG_PUB.Count_And_Get(

Line 2772: FND_MSG_PUB.Count_And_Get(

2768: FND_MSG_PUB.Add_Exc_Msg(
2769: g_pkg_name,
2770: l_api_name);
2771: END IF;
2772: FND_MSG_PUB.Count_And_Get(
2773: p_encoded => FND_API.g_false,
2774: p_count => x_msg_count,
2775: p_data => x_msg_data);
2776: END Get_CurrencyInfo;

Line 2973: FND_MSG_PUB.ADD;

2969: p_var_value => l_ship_type_id );
2970:
2971: IF l_ship_type_id IS NULL OR l_ship_type_id = 0 THEN
2972: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_SHIP_TYP_PROF') ;
2973: FND_MSG_PUB.ADD;
2974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2975: END IF;
2976:
2977: INL_LOGGING_PVT.Log_Statement (

Line 3011: FND_MSG_PUB.ADD;

3007:
3008: -- The Shipment Line Type should be defined for the Shipment Type
3009: IF l_ship_line_type_id IS NULL THEN
3010: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_NO_SHIP_LN_DEF') ;
3011: FND_MSG_PUB.ADD;
3012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3013: END IF;
3014:
3015: -- Get last task code from INL_CUSTOM_PUB.Get_LastTaskCodeForSimul

Line 3026: FND_MSG_PUB.ADD;

3022: p_var_value => l_last_task_code );
3023:
3024: IF l_last_task_code IS NULL OR l_last_task_code NOT IN('10','20','30','40','50','60') THEN
3025: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_LAST_TASK_CODE') ;
3026: FND_MSG_PUB.ADD;
3027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3028: END IF;
3029:
3030: INL_LOGGING_PVT.Log_Statement (

Line 3194: FND_MSG_PUB.ADD;

3190: p_procedure_name => l_proc_name,
3191: p_debug_info => 'Ship To Organization has not been setup in LCM Options');
3192: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_NO_LCM_OPT_DEF_ORG') ;
3193: FND_MESSAGE.SET_TOKEN ('INV_ORG_NAME', l_ship_to_location_code);
3194: FND_MSG_PUB.ADD;
3195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3196: END;
3197:
3198: l_organization_id := l_ship_to_organization_id;

Line 3253: FND_MSG_PUB.ADD;

3249: -- validate Third Party Sites Allowed
3250: IF l_taxation_country IS NULL THEN
3251: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_LOC_COUNTRY_NULL') ;
3252: FND_MESSAGE.SET_TOKEN ('LOCATION_CODE', l_ship_to_location_code) ;
3253: FND_MSG_PUB.ADD;
3254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3255: END IF;
3256:
3257: -- Get the UOM Code

Line 3440: IF FND_MSG_PUB.Check_Msg_Level(p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3436: INL_LOGGING_PVT.Log_UnexpecError (
3437: p_module_name => g_module_name,
3438: p_procedure_name => l_proc_name);
3439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3440: IF FND_MSG_PUB.Check_Msg_Level(p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3441: FND_MSG_PUB.Add_Exc_Msg(
3442: p_pkg_name => g_pkg_name,
3443: p_procedure_name => l_proc_name);
3444: END IF;

Line 3441: FND_MSG_PUB.Add_Exc_Msg(

3437: p_module_name => g_module_name,
3438: p_procedure_name => l_proc_name);
3439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3440: IF FND_MSG_PUB.Check_Msg_Level(p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3441: FND_MSG_PUB.Add_Exc_Msg(
3442: p_pkg_name => g_pkg_name,
3443: p_procedure_name => l_proc_name);
3444: END IF;
3445: END Import_FromPO;

Line 3498: FND_MSG_PUB.initialize;

3494: SAVEPOINT Create_POSimulation_GRP;
3495:
3496: -- Initialize message list if p_init_msg_list is set to TRUE.
3497: IF FND_API.to_Boolean(p_init_msg_list) THEN
3498: FND_MSG_PUB.initialize;
3499: END IF;
3500:
3501: -- Standard call to check for call compatibility
3502: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

Line 3737: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;

3733: p_procedure_name => l_api_name,
3734: p_debug_info => l_debug_info);
3735:
3736: -- Standard call to get message count and if count is 1, get message info.
3737: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
3738: -- Standard End of Procedure/Function Logging
3739: INL_LOGGING_PVT.Log_EndProc(
3740: p_module_name => g_module_name,
3741: p_procedure_name => l_api_name);

Line 3751: FND_MSG_PUB.Count_And_Get(

3747: p_module_name => g_module_name,
3748: p_procedure_name => l_api_name);
3749: ROLLBACK TO Create_POSimulation_GRP;
3750: x_return_status := FND_API.G_RET_STS_ERROR;
3751: FND_MSG_PUB.Count_And_Get(
3752: p_encoded => FND_API.g_false,
3753: p_count => x_msg_count,
3754: p_data => x_msg_data);
3755: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3762: FND_MSG_PUB.Count_And_Get(

3758: p_module_name => g_module_name,
3759: p_procedure_name => l_api_name);
3760: ROLLBACK TO Create_POSimulation_GRP;
3761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3762: FND_MSG_PUB.Count_And_Get(
3763: p_encoded => FND_API.g_false,
3764: p_count => x_msg_count,
3765: p_data => x_msg_data);
3766: WHEN OTHERS THEN

Line 3773: IF FND_MSG_PUB.Check_Msg_Level(

3769: p_module_name => g_module_name,
3770: p_procedure_name => l_api_name);
3771: ROLLBACK TO Create_POSimulation_GRP;
3772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3773: IF FND_MSG_PUB.Check_Msg_Level(
3774: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3775: ) THEN
3776: FND_MSG_PUB.Add_Exc_Msg(
3777: p_pkg_name => g_pkg_name,

Line 3774: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3770: p_procedure_name => l_api_name);
3771: ROLLBACK TO Create_POSimulation_GRP;
3772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3773: IF FND_MSG_PUB.Check_Msg_Level(
3774: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3775: ) THEN
3776: FND_MSG_PUB.Add_Exc_Msg(
3777: p_pkg_name => g_pkg_name,
3778: p_procedure_name => l_api_name);

Line 3776: FND_MSG_PUB.Add_Exc_Msg(

3772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3773: IF FND_MSG_PUB.Check_Msg_Level(
3774: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3775: ) THEN
3776: FND_MSG_PUB.Add_Exc_Msg(
3777: p_pkg_name => g_pkg_name,
3778: p_procedure_name => l_api_name);
3779: END IF;
3780: FND_MSG_PUB.Count_And_Get(

Line 3780: FND_MSG_PUB.Count_And_Get(

3776: FND_MSG_PUB.Add_Exc_Msg(
3777: p_pkg_name => g_pkg_name,
3778: p_procedure_name => l_api_name);
3779: END IF;
3780: FND_MSG_PUB.Count_And_Get(
3781: p_encoded => FND_API.g_false,
3782: p_count => x_msg_count,
3783: p_data => x_msg_data);
3784: END Create_POSimulation;

Line 3897: FND_MSG_PUB.ADD;

3893: FND_MESSAGE.SET_TOKEN ('PO_SHIP_NUM', c_po_ln_loc_tab(i).shipment_num); -- Bug #9821615
3894: FND_MESSAGE.SET_TOKEN ('PO_LINE_NUM', c_po_ln_loc_tab(i).line_num);
3895: FND_MESSAGE.SET_TOKEN ('SOURCE_TYPE', l_src_type);
3896: FND_MESSAGE.SET_TOKEN ('SOURCE_NUM', c_po_ln_loc_tab(i).segment1);
3897: FND_MSG_PUB.ADD;
3898: l_po_ship_check := FALSE;
3899:
3900: END LOOP;
3901:

Line 3926: IF FND_MSG_PUB.Check_Msg_Level(p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3922: INL_LOGGING_PVT.Log_UnexpecError (
3923: p_module_name => g_module_name,
3924: p_procedure_name => l_proc_name);
3925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3926: IF FND_MSG_PUB.Check_Msg_Level(p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3927: FND_MSG_PUB.Add_Exc_Msg(
3928: p_pkg_name => g_pkg_name,
3929: p_procedure_name => l_proc_name);
3930: END IF;

Line 3927: FND_MSG_PUB.Add_Exc_Msg(

3923: p_module_name => g_module_name,
3924: p_procedure_name => l_proc_name);
3925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3926: IF FND_MSG_PUB.Check_Msg_Level(p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3927: FND_MSG_PUB.Add_Exc_Msg(
3928: p_pkg_name => g_pkg_name,
3929: p_procedure_name => l_proc_name);
3930: END IF;
3931: END Check_POAgainstShipLines;

Line 4059: FND_MSG_PUB.ADD;

4055: WHEN NO_DATA_FOUND THEN
4056: FND_MESSAGE.SET_NAME('INL','INL_CHK_SIMUL_SRC_LOC_NOT_FOUN');
4057: FND_MESSAGE.SET_TOKEN ('SHIP_LINE_NUM', c_ship_ln_tab(i).ship_line_num) ;
4058: FND_MESSAGE.SET_TOKEN ('SHIP_NUM', c_ship_ln_tab(i).ship_num) ;
4059: FND_MSG_PUB.ADD;
4060: l_ship_ln_check := FALSE;
4061: END;
4062:
4063: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

Line 4112: FND_MSG_PUB.ADD;

4108: FND_MESSAGE.SET_TOKEN('SHIP_NUM', c_ship_ln_tab(i).ship_num);
4109: FND_MESSAGE.SET_TOKEN('SHIP_LINE_NUM', c_ship_ln_tab(i).ship_line_num);
4110: FND_MESSAGE.SET_TOKEN('SOURCE_TYPE', l_src_type);
4111: FND_MESSAGE.SET_TOKEN('SOURCE_NUM', l_po_number);
4112: FND_MSG_PUB.ADD;
4113: l_ship_ln_check := FALSE;
4114: END IF;
4115:
4116: IF NVL(l_po_ln_loc_cancel_flag, 'N') = 'Y' THEN

Line 4122: FND_MSG_PUB.ADD;

4118: FND_MESSAGE.SET_TOKEN('SHIP_NUM', c_ship_ln_tab(i).ship_num);
4119: FND_MESSAGE.SET_TOKEN('SHIP_LINE_NUM', c_ship_ln_tab(i).ship_line_num);
4120: FND_MESSAGE.SET_TOKEN('SOURCE_TYPE', l_src_type);
4121: FND_MESSAGE.SET_TOKEN('SOURCE_NUM', l_po_number);
4122: FND_MSG_PUB.ADD;
4123: l_ship_ln_check := FALSE;
4124: END IF;
4125:
4126: IF c_ship_ln_tab(i).txn_qty <> l_po_ln_loc_qty THEN

Line 4135: FND_MSG_PUB.ADD;

4131: FND_MESSAGE.SET_TOKEN('QTY2', l_po_ln_loc_qty);
4132: FND_MESSAGE.SET_TOKEN('SOURCE_TYPE', l_src_type);
4133: FND_MESSAGE.SET_TOKEN('SOURCE_NUM', l_po_number);
4134: FND_MESSAGE.SET_TOKEN('SOURCE_LINE_NUM', l_po_ln_num);
4135: FND_MSG_PUB.ADD;
4136: l_ship_ln_check := FALSE;
4137: END IF;
4138:
4139: IF c_ship_ln_tab(i).unit_of_measure <> l_po_ln_uom THEN

Line 4148: FND_MSG_PUB.ADD;

4144: FND_MESSAGE.SET_TOKEN('UOM2', l_po_ln_uom);
4145: FND_MESSAGE.SET_TOKEN('SOURCE_TYPE', l_src_type);
4146: FND_MESSAGE.SET_TOKEN('SOURCE_NUM', l_po_number);
4147: FND_MESSAGE.SET_TOKEN('SOURCE_LINE_NUM', l_po_ln_num);
4148: FND_MSG_PUB.ADD;
4149: l_ship_ln_check := FALSE;
4150: END IF;
4151:
4152: IF c_ship_ln_tab(i).txn_unit_price <> l_po_ln_unit_price THEN

Line 4161: FND_MSG_PUB.ADD;

4157: FND_MESSAGE.SET_TOKEN('PRICE2', l_po_ln_unit_price);
4158: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM', l_po_ln_num);
4159: FND_MESSAGE.SET_TOKEN('SOURCE_TYPE', l_src_type);
4160: FND_MESSAGE.SET_TOKEN('SOURCE_NUM', l_po_number);
4161: FND_MSG_PUB.ADD;
4162: l_ship_ln_check := FALSE;
4163: END IF;
4164:
4165: IF c_ship_ln_tab(i).currency_code <> l_po_currency THEN

Line 4173: FND_MSG_PUB.ADD;

4169: FND_MESSAGE.SET_TOKEN('SHIP_LINE_NUM', c_ship_ln_tab(i).ship_line_num);
4170: FND_MESSAGE.SET_TOKEN('CURRENCY2', c_ship_ln_tab(i).currency_code);
4171: FND_MESSAGE.SET_TOKEN('SOURCE_TYPE', l_src_type);
4172: FND_MESSAGE.SET_TOKEN('SOURCE_NUM', l_po_number);
4173: FND_MSG_PUB.ADD;
4174: l_ship_ln_check := FALSE;
4175: END IF;
4176: END IF;
4177: END LOOP;

Line 4204: IF FND_MSG_PUB.Check_Msg_Level(p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4200: INL_LOGGING_PVT.Log_UnexpecError (
4201: p_module_name => g_module_name,
4202: p_procedure_name => l_proc_name);
4203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4204: IF FND_MSG_PUB.Check_Msg_Level(p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4205: FND_MSG_PUB.Add_Exc_Msg(
4206: p_pkg_name => g_pkg_name,
4207: p_procedure_name => l_proc_name);
4208: END IF;

Line 4205: FND_MSG_PUB.Add_Exc_Msg(

4201: p_module_name => g_module_name,
4202: p_procedure_name => l_proc_name);
4203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4204: IF FND_MSG_PUB.Check_Msg_Level(p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4205: FND_MSG_PUB.Add_Exc_Msg(
4206: p_pkg_name => g_pkg_name,
4207: p_procedure_name => l_proc_name);
4208: END IF;
4209: END Check_ShipLinesAgainstPO;

Line 4337: FND_MSG_PUB.ADD;

4333: WHEN NO_DATA_FOUND THEN
4334: FND_MESSAGE.SET_NAME('INL','INL_CHK_SIMUL_SRC_NOT_FOUND');
4335: FND_MESSAGE.SET_TOKEN ('SOURCE_TYPE', l_src_type);
4336: FND_MESSAGE.SET_TOKEN ('SOURCE_NUM', l_po_number);
4337: FND_MSG_PUB.ADD;
4338: l_simulation_check := FALSE;
4339: END;
4340:
4341: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

Line 4419: FND_MSG_PUB.ADD;

4415: FND_MESSAGE.SET_TOKEN ('SOURCE_REV_NUM', l_simu_revision_num);
4416: FND_MESSAGE.SET_TOKEN ('SOURCE_REV_NUM1', l_po_revision_num);
4417: FND_MESSAGE.SET_TOKEN ('SOURCE_TYPE', l_src_type);
4418: FND_MESSAGE.SET_TOKEN ('SOURCE_NUM', l_po_number);
4419: FND_MSG_PUB.ADD;
4420: l_simulation_check := FALSE;
4421: END IF;
4422:
4423: -- Bug 14280113 Check PO Release revision

Line 4446: FND_MSG_PUB.ADD;

4442: FND_MESSAGE.SET_TOKEN ('SOURCE_REL_REV_NUM1', l_po_release_revision_num);
4443: FND_MESSAGE.SET_TOKEN ('SOURCE_REL_NUM', l_po_release_num);
4444: FND_MESSAGE.SET_TOKEN ('SOURCE_TYPE', l_src_type);
4445: FND_MESSAGE.SET_TOKEN ('SOURCE_NUM', l_po_number);
4446: FND_MSG_PUB.ADD;
4447: l_simulation_check := FALSE;
4448: END IF;
4449: -- Bug 14280113
4450:

Line 4458: FND_MSG_PUB.ADD;

4454: FND_MESSAGE.SET_TOKEN ('THIRD_PARTY', l_simu_vendor_name);
4455: FND_MESSAGE.SET_TOKEN ('THIRD_PARTY2', l_po_vendor_name);
4456: FND_MESSAGE.SET_TOKEN ('SOURCE_TYPE', l_src_type);
4457: FND_MESSAGE.SET_TOKEN ('SOURCE_NUM', l_po_number);
4458: FND_MSG_PUB.ADD;
4459: l_simulation_check := FALSE;
4460: END IF;
4461:
4462: -- Check Vendor Site

Line 4469: FND_MSG_PUB.ADD;

4465: FND_MESSAGE.SET_TOKEN ('THIRD_PARTY_SITE', l_simu_vendor_site_code);
4466: FND_MESSAGE.SET_TOKEN ('THIRD_PARTY_SITE2', l_po_vendor_site_code);
4467: FND_MESSAGE.SET_TOKEN ('SOURCE_TYPE', l_src_type);
4468: FND_MESSAGE.SET_TOKEN ('SOURCE_NUM', l_po_number);
4469: FND_MSG_PUB.ADD;
4470: l_simulation_check := FALSE;
4471: END IF;
4472:
4473: -- Check Freight

Line 4480: FND_MSG_PUB.ADD;

4476: FND_MESSAGE.SET_TOKEN ('CARRIER1', l_simu_freight_code);
4477: FND_MESSAGE.SET_TOKEN ('CARRIER2', l_po_freight_code);
4478: FND_MESSAGE.SET_TOKEN ('SOURCE_TYPE', l_src_type);
4479: FND_MESSAGE.SET_TOKEN ('SOURCE_NUM', l_po_number);
4480: FND_MSG_PUB.ADD;
4481: l_simulation_check := FALSE;
4482: END IF;
4483: END IF;
4484:

Line 4510: IF FND_MSG_PUB.Check_Msg_Level(p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4506: INL_LOGGING_PVT.Log_UnexpecError (
4507: p_module_name => g_module_name,
4508: p_procedure_name => l_proc_name);
4509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4510: IF FND_MSG_PUB.Check_Msg_Level(p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4511: FND_MSG_PUB.Add_Exc_Msg(
4512: p_pkg_name => g_pkg_name,
4513: p_procedure_name => l_proc_name);
4514: END IF;

Line 4511: FND_MSG_PUB.Add_Exc_Msg(

4507: p_module_name => g_module_name,
4508: p_procedure_name => l_proc_name);
4509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4510: IF FND_MSG_PUB.Check_Msg_Level(p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4511: FND_MSG_PUB.Add_Exc_Msg(
4512: p_pkg_name => g_pkg_name,
4513: p_procedure_name => l_proc_name);
4514: END IF;
4515: END Check_SimulAgainstPO;

Line 4567: FND_MSG_PUB.initialize;

4563: SAVEPOINT Check_POLcmSynch_GRP;
4564:
4565: -- Initialize message list if p_init_msg_list is set to TRUE.
4566: IF FND_API.to_Boolean(p_init_msg_list) THEN
4567: FND_MSG_PUB.initialize;
4568: END IF;
4569:
4570: -- Standard call to check for call compatibility
4571: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

Line 4647: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;

4643: IF FND_API.To_Boolean(p_commit) THEN
4644: COMMIT WORK;
4645: END IF;
4646: -- Standard call to get message count and if count is 1, get message info.
4647: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
4648: -- Standard End of Procedure/Function Logging
4649: INL_LOGGING_PVT.Log_EndProc(
4650: p_module_name => g_module_name,
4651: p_procedure_name => l_api_name);

Line 4663: FND_MSG_PUB.Count_And_Get(

4659: p_module_name => g_module_name,
4660: p_procedure_name => l_api_name);
4661: ROLLBACK TO Check_POLcmSynch_GRP;
4662: x_return_status := FND_API.G_RET_STS_ERROR;
4663: FND_MSG_PUB.Count_And_Get(
4664: p_encoded => FND_API.g_false,
4665: p_count => x_msg_count,
4666: p_data => x_msg_data);
4667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4674: FND_MSG_PUB.Count_And_Get(

4670: p_module_name => g_module_name,
4671: p_procedure_name => l_api_name);
4672: ROLLBACK TO Check_POLcmSynch_GRP;
4673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4674: FND_MSG_PUB.Count_And_Get(
4675: p_encoded => FND_API.g_false,
4676: p_count => x_msg_count,
4677: p_data => x_msg_data);
4678: WHEN OTHERS THEN

Line 4685: IF FND_MSG_PUB.Check_Msg_Level(

4681: p_module_name => g_module_name,
4682: p_procedure_name => l_api_name);
4683: ROLLBACK TO Check_POLcmSynch_GRP;
4684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4685: IF FND_MSG_PUB.Check_Msg_Level(
4686: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4687: FND_MSG_PUB.Add_Exc_Msg(
4688: p_pkg_name => g_pkg_name,
4689: p_procedure_name => l_api_name);

Line 4686: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4682: p_procedure_name => l_api_name);
4683: ROLLBACK TO Check_POLcmSynch_GRP;
4684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4685: IF FND_MSG_PUB.Check_Msg_Level(
4686: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4687: FND_MSG_PUB.Add_Exc_Msg(
4688: p_pkg_name => g_pkg_name,
4689: p_procedure_name => l_api_name);
4690: END IF;

Line 4687: FND_MSG_PUB.Add_Exc_Msg(

4683: ROLLBACK TO Check_POLcmSynch_GRP;
4684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4685: IF FND_MSG_PUB.Check_Msg_Level(
4686: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4687: FND_MSG_PUB.Add_Exc_Msg(
4688: p_pkg_name => g_pkg_name,
4689: p_procedure_name => l_api_name);
4690: END IF;
4691: FND_MSG_PUB.Count_And_Get(

Line 4691: FND_MSG_PUB.Count_And_Get(

4687: FND_MSG_PUB.Add_Exc_Msg(
4688: p_pkg_name => g_pkg_name,
4689: p_procedure_name => l_api_name);
4690: END IF;
4691: FND_MSG_PUB.Count_And_Get(
4692: p_encoded => FND_API.g_false,
4693: p_count => x_msg_count,
4694: p_data => x_msg_data);
4695: END Check_POLcmSynch;

Line 4771: IF FND_MSG_PUB.Check_Msg_Level (p_message_level =>

4767: WHEN OTHERS THEN
4768: -- Standard Unexpected Error Logging
4769: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
4770: p_procedure_name => l_func_name) ;
4771: IF FND_MSG_PUB.Check_Msg_Level (p_message_level =>
4772: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4773: FND_MSG_PUB.Add_Exc_Msg (p_pkg_name => g_pkg_name,
4774: p_procedure_name => l_func_name) ;
4775: END IF;

Line 4772: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4768: -- Standard Unexpected Error Logging
4769: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
4770: p_procedure_name => l_func_name) ;
4771: IF FND_MSG_PUB.Check_Msg_Level (p_message_level =>
4772: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4773: FND_MSG_PUB.Add_Exc_Msg (p_pkg_name => g_pkg_name,
4774: p_procedure_name => l_func_name) ;
4775: END IF;
4776: RETURN l_is_po_eligible;

Line 4773: FND_MSG_PUB.Add_Exc_Msg (p_pkg_name => g_pkg_name,

4769: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
4770: p_procedure_name => l_func_name) ;
4771: IF FND_MSG_PUB.Check_Msg_Level (p_message_level =>
4772: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4773: FND_MSG_PUB.Add_Exc_Msg (p_pkg_name => g_pkg_name,
4774: p_procedure_name => l_func_name) ;
4775: END IF;
4776: RETURN l_is_po_eligible;
4777: END Check_POEligibility;