DBA Data[Home] [Help]

APPS.ASO_PA_APR_INT dependencies on FND_MSG_PUB

Line 188: fnd_msg_pub.initialize;

184: 1,
185: 'N'
186: );
187: END IF;
188: fnd_msg_pub.initialize;
189: END IF;
190:
191: -- Initialize API return status to success
192:

Line 665: p_exception_level => fnd_msg_pub.g_msg_lvl_error,

661: END IF;
662: aso_utility_pvt.handle_exceptions (
663: p_api_name => l_api_name,
664: p_pkg_name => g_pkg_name,
665: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
666: p_package_type => aso_utility_pvt.g_int,
667: p_sqlcode => SQLCODE,
668: p_sqlerrm => SQLERRM,
669: x_msg_count => x_msg_count,

Line 685: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,

681: END IF;
682: aso_utility_pvt.handle_exceptions (
683: p_api_name => l_api_name,
684: p_pkg_name => g_pkg_name,
685: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
686: p_package_type => aso_utility_pvt.g_int,
687: p_sqlcode => SQLCODE,
688: p_sqlerrm => SQLERRM,
689: x_msg_count => x_msg_count,

Line 843: fnd_msg_pub.initialize;

839: 1,
840: 'N'
841: );
842: END IF;
843: fnd_msg_pub.initialize;
844: END IF;
845:
846: -- Initialize API return status to success
847: x_return_status := fnd_api.g_ret_sts_success;

Line 1145: p_exception_level => fnd_msg_pub.g_msg_lvl_error,

1141: END IF;
1142: aso_utility_pvt.handle_exceptions (
1143: p_api_name => l_api_name,
1144: p_pkg_name => g_pkg_name,
1145: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
1146: p_package_type => aso_utility_pvt.g_int,
1147: p_sqlcode => SQLCODE,
1148: p_sqlerrm => SQLERRM,
1149: x_msg_count => x_msg_count,

Line 1165: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,

1161: END IF;
1162: aso_utility_pvt.handle_exceptions (
1163: p_api_name => l_api_name,
1164: p_pkg_name => g_pkg_name,
1165: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
1166: p_package_type => aso_utility_pvt.g_int,
1167: p_sqlcode => SQLCODE,
1168: p_sqlerrm => SQLERRM,
1169: x_msg_count => x_msg_count,

Line 1300: fnd_msg_pub.initialize;

1296: IF fnd_api.to_boolean (
1297: p_init_msg_list
1298: )
1299: THEN
1300: fnd_msg_pub.initialize;
1301: END IF;
1302:
1303: -- Initialize API return status to success
1304: x_return_status := fnd_api.g_ret_sts_success;

Line 1314: FND_MSG_PUB.ADD;

1310:
1311: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
1312: FND_MESSAGE.Set_Token ('COLUMN' , 'P_Object_approval_id', FALSE );
1313: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Object_approval_id ) , FALSE );
1314: FND_MSG_PUB.ADD;
1315: RAISE FND_API.G_EXC_ERROR;
1316: END IF;
1317:
1318: IF (p_object_approval_id IS NULL)

Line 1383: fnd_msg_pub.count_and_get(p_encoded => 'F',

1379: END IF;
1380: COMMIT WORK;
1381: END IF;
1382:
1383: fnd_msg_pub.count_and_get(p_encoded => 'F',
1384: p_count => x_msg_count,
1385: p_data => x_msg_data);
1386: for k in 1..x_msg_count loop
1387: x_msg_data := fnd_msg_pub.get(p_msg_index => k,

Line 1387: x_msg_data := fnd_msg_pub.get(p_msg_index => k,

1383: fnd_msg_pub.count_and_get(p_encoded => 'F',
1384: p_count => x_msg_count,
1385: p_data => x_msg_data);
1386: for k in 1..x_msg_count loop
1387: x_msg_data := fnd_msg_pub.get(p_msg_index => k,
1388: p_encoded => 'F');
1389: end loop;
1390:
1391: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1411: p_exception_level => fnd_msg_pub.g_msg_lvl_error,

1407: END IF;
1408: aso_utility_pvt.handle_exceptions (
1409: p_api_name => l_api_name,
1410: p_pkg_name => g_pkg_name,
1411: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
1412: p_package_type => aso_utility_pvt.g_int,
1413: p_sqlcode => SQLCODE,
1414: p_sqlerrm => SQLERRM,
1415: x_msg_count => x_msg_count,

Line 1431: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,

1427: END IF;
1428: aso_utility_pvt.handle_exceptions (
1429: p_api_name => l_api_name,
1430: p_pkg_name => g_pkg_name,
1431: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
1432: p_package_type => aso_utility_pvt.g_int,
1433: p_sqlcode => SQLCODE,
1434: p_sqlerrm => SQLERRM,
1435: x_msg_count => x_msg_count,

Line 1525: fnd_msg_pub.initialize;

1521: IF fnd_api.to_boolean (
1522: p_init_msg_list
1523: )
1524: THEN
1525: fnd_msg_pub.initialize;
1526: END IF;
1527:
1528: -- Initialize API return status to success
1529: x_return_status := fnd_api.g_ret_sts_success;

Line 1536: FND_MSG_PUB.ADD;

1532: IF ((P_Object_approval_id IS NULL) OR (P_Object_approval_id = FND_API.G_MISS_NUM)) THEN
1533: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
1534: FND_MESSAGE.Set_Token ('COLUMN' , 'P_Object_approval_id', FALSE );
1535: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Object_approval_id ) , FALSE );
1536: FND_MSG_PUB.ADD;
1537: RAISE FND_API.G_EXC_ERROR;
1538: ELSIF ((P_itemtype IS NULL) OR (P_itemtype = FND_API.G_MISS_CHAR)) THEN
1539: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
1540: FND_MESSAGE.Set_Token ('COLUMN' , 'P_Object_approval_id', FALSE );

Line 1542: FND_MSG_PUB.ADD;

1538: ELSIF ((P_itemtype IS NULL) OR (P_itemtype = FND_API.G_MISS_CHAR)) THEN
1539: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
1540: FND_MESSAGE.Set_Token ('COLUMN' , 'P_Object_approval_id', FALSE );
1541: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Object_approval_id ) , FALSE );
1542: FND_MSG_PUB.ADD;
1543: RAISE FND_API.G_EXC_ERROR;
1544: END IF;
1545:
1546: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1585: fnd_msg_pub.count_and_get(p_encoded => 'F',

1581: END IF;
1582: COMMIT WORK;
1583: END IF;
1584:
1585: fnd_msg_pub.count_and_get(p_encoded => 'F',
1586: p_count => x_msg_count,
1587: p_data => x_msg_data);
1588: for k in 1..x_msg_count loop
1589: x_msg_data := fnd_msg_pub.get(p_msg_index => k,

Line 1589: x_msg_data := fnd_msg_pub.get(p_msg_index => k,

1585: fnd_msg_pub.count_and_get(p_encoded => 'F',
1586: p_count => x_msg_count,
1587: p_data => x_msg_data);
1588: for k in 1..x_msg_count loop
1589: x_msg_data := fnd_msg_pub.get(p_msg_index => k,
1590: p_encoded => 'F');
1591: end loop;
1592:
1593:

Line 1610: p_exception_level => fnd_msg_pub.g_msg_lvl_error,

1606: THEN
1607: aso_utility_pvt.handle_exceptions (
1608: p_api_name => l_api_name,
1609: p_pkg_name => g_pkg_name,
1610: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
1611: p_package_type => aso_utility_pvt.g_int,
1612: p_sqlcode => SQLCODE,
1613: p_sqlerrm => SQLERRM,
1614: x_msg_count => x_msg_count,

Line 1623: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,

1619: THEN
1620: aso_utility_pvt.handle_exceptions (
1621: p_api_name => l_api_name,
1622: p_pkg_name => g_pkg_name,
1623: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
1624: p_package_type => aso_utility_pvt.g_int,
1625: p_sqlcode => SQLCODE,
1626: p_sqlerrm => SQLERRM,
1627: x_msg_count => x_msg_count,

Line 1707: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1703:
1704: Open c_get_qte_info(p_qte_hdr_id);
1705: Fetch c_get_qte_info into l_LAST_UPDATE_DATE,l_object_version_number;
1706: If ( c_get_qte_info%NOTFOUND) Then
1707: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1708: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_UPDATE_TARGET');
1709: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
1710: FND_MSG_PUB.Add;
1711: END IF;

Line 1710: FND_MSG_PUB.Add;

1706: If ( c_get_qte_info%NOTFOUND) Then
1707: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1708: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_UPDATE_TARGET');
1709: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
1710: FND_MSG_PUB.Add;
1711: END IF;
1712: raise FND_API.G_EXC_ERROR;
1713: END IF;
1714: Close c_get_qte_info;

Line 1722: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1718: aso_debug_pub.add('upd_status_self_appr: l_object_version_number: '|| l_object_version_number,1,'Y');
1719: END IF;
1720:
1721: If (l_last_update_date is NULL or l_last_update_date = FND_API.G_MISS_Date ) Then
1722: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1723: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
1724: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1725: FND_MSG_PUB.ADD;
1726: END IF;

Line 1725: FND_MSG_PUB.ADD;

1721: If (l_last_update_date is NULL or l_last_update_date = FND_API.G_MISS_Date ) Then
1722: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1723: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
1724: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1725: FND_MSG_PUB.ADD;
1726: END IF;
1727: raise FND_API.G_EXC_ERROR;
1728: End if;
1729:

Line 1732: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1728: End if;
1729:
1730: -- Check Whether record has been changed by someone else
1731: If ( (l_last_update_date <> p_last_update_date ) OR (l_object_version_number <> p_obj_ver_num ) ) Then
1732: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1733: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
1734: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
1735: FND_MSG_PUB.ADD;
1736: END IF;

Line 1735: FND_MSG_PUB.ADD;

1731: If ( (l_last_update_date <> p_last_update_date ) OR (l_object_version_number <> p_obj_ver_num ) ) Then
1732: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1733: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
1734: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
1735: FND_MSG_PUB.ADD;
1736: END IF;
1737: raise FND_API.G_EXC_ERROR;
1738: End if;
1739:

Line 1812: fnd_msg_pub.count_and_get(p_encoded => 'F',

1808: NULL;
1809: END;
1810:
1811:
1812: fnd_msg_pub.count_and_get(p_encoded => 'F',
1813: p_count => x_msg_count,
1814: p_data => x_msg_data);
1815: for k in 1..x_msg_count loop
1816: x_msg_data := fnd_msg_pub.get(p_msg_index => k,

Line 1816: x_msg_data := fnd_msg_pub.get(p_msg_index => k,

1812: fnd_msg_pub.count_and_get(p_encoded => 'F',
1813: p_count => x_msg_count,
1814: p_data => x_msg_data);
1815: for k in 1..x_msg_count loop
1816: x_msg_data := fnd_msg_pub.get(p_msg_index => k,
1817: p_encoded => 'F');
1818: end loop;
1819:
1820: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1830: p_exception_level => fnd_msg_pub.g_msg_lvl_error,

1826: THEN
1827: aso_utility_pvt.handle_exceptions (
1828: p_api_name => l_api_name,
1829: p_pkg_name => g_pkg_name,
1830: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
1831: p_package_type => aso_utility_pvt.g_int,
1832: p_sqlcode => SQLCODE,
1833: p_sqlerrm => SQLERRM,
1834: x_msg_count => x_msg_count,

Line 1843: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,

1839: THEN
1840: aso_utility_pvt.handle_exceptions (
1841: p_api_name => l_api_name,
1842: p_pkg_name => g_pkg_name,
1843: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
1844: p_package_type => aso_utility_pvt.g_int,
1845: p_sqlcode => SQLCODE,
1846: p_sqlerrm => SQLERRM,
1847: x_msg_count => x_msg_count,

Line 2114: p_exception_level => fnd_msg_pub.g_msg_lvl_error,

2110: THEN
2111: aso_utility_pvt.handle_exceptions (
2112: p_api_name => l_api_name,
2113: p_pkg_name => g_pkg_name,
2114: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
2115: p_package_type => aso_utility_pvt.g_int,
2116: p_sqlcode => SQLCODE,
2117: p_sqlerrm => SQLERRM,
2118: x_msg_count => x_msg_count,

Line 2127: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,

2123: THEN
2124: aso_utility_pvt.handle_exceptions (
2125: p_api_name => l_api_name,
2126: p_pkg_name => g_pkg_name,
2127: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
2128: p_package_type => aso_utility_pvt.g_int,
2129: p_sqlcode => SQLCODE,
2130: p_sqlerrm => SQLERRM,
2131: x_msg_count => x_msg_count,