eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_QUOTE_LINES_PVT dependencies on FND_MSG_PUB

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

1362: FETCH C_org_id into l_qte_line_rec.org_id;
1363:
1364: IF (C_org_id%NOTFOUND) THEN
1365:
1366: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1367: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1368: FND_MESSAGE.Set_Token('COLUMN', 'ORG_ID', FALSE);
1369: FND_MSG_PUB.ADD;
1370: END IF;

Line 1369: FND_MSG_PUB.ADD;

1365:
1366: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1367: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1368: FND_MESSAGE.Set_Token('COLUMN', 'ORG_ID', FALSE);
1369: FND_MSG_PUB.ADD;
1370: END IF;
1371:
1372: END IF;
1373:

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

1382: l_qte_line_rec.organization_id := oe_profile.value('OE_ORGANIZATION_ID',l_qte_line_rec.org_id);
1383:
1384: IF l_qte_line_rec.organization_id is NULL or l_qte_line_rec.organization_id = FND_API.G_MISS_NUM THEN
1385:
1386: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1387: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1388: FND_MESSAGE.Set_Token('COLUMN', 'ORGANIZATION_ID', FALSE);
1389: FND_MSG_PUB.ADD;
1390: END IF;

Line 1389: FND_MSG_PUB.ADD;

1385:
1386: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1387: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1388: FND_MESSAGE.Set_Token('COLUMN', 'ORGANIZATION_ID', FALSE);
1389: FND_MSG_PUB.ADD;
1390: END IF;
1391:
1392: END IF;
1393:

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

1409: AND organization_id = l_qte_line_rec.organization_id;
1410:
1411: IF (SQL%NOTFOUND) THEN
1412:
1413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1414: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
1415: FND_MESSAGE.Set_Token('COLUMN', 'ITEM TYPE CODE', FALSE);
1416: FND_MSG_PUB.ADD;
1417: END IF;

Line 1416: FND_MSG_PUB.ADD;

1412:
1413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1414: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
1415: FND_MESSAGE.Set_Token('COLUMN', 'ITEM TYPE CODE', FALSE);
1416: FND_MSG_PUB.ADD;
1417: END IF;
1418:
1419: END IF;
1420:

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

1469: IF l_shipment_rec_count > 0 THEN
1470:
1471: FOR i IN 1..l_shipment_tbl.count LOOP
1472: IF l_shipment_tbl(i).operation_code = 'CREATE' THEN
1473: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1474: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_SHIPMENTS');
1475: FND_MSG_PUB.ADD;
1476: END IF;
1477: raise FND_API.G_EXC_ERROR;

Line 1475: FND_MSG_PUB.ADD;

1471: FOR i IN 1..l_shipment_tbl.count LOOP
1472: IF l_shipment_tbl(i).operation_code = 'CREATE' THEN
1473: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1474: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_SHIPMENTS');
1475: FND_MSG_PUB.ADD;
1476: END IF;
1477: raise FND_API.G_EXC_ERROR;
1478: END IF;
1479: END LOOP;

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

1486:
1487:
1488: IF l_shipment_tbl.count > 1 THEN
1489:
1490: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1491: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_SHIPMENTS');
1492: FND_MSG_PUB.ADD;
1493: END IF;
1494: raise FND_API.G_EXC_ERROR;

Line 1492: FND_MSG_PUB.ADD;

1488: IF l_shipment_tbl.count > 1 THEN
1489:
1490: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1491: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_SHIPMENTS');
1492: FND_MSG_PUB.ADD;
1493: END IF;
1494: raise FND_API.G_EXC_ERROR;
1495:
1496: ELSIF l_shipment_tbl.count > 0 THEN

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

1506:
1507: If C_Item1%NOTFOUND Then
1508:
1509: CLOSE C_Item1;
1510: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1511: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');
1512: FND_MESSAGE.Set_Token('COLUMN','ITEM RELATED', FALSE);
1513: FND_MSG_PUB.Add;
1514: END IF;

Line 1513: FND_MSG_PUB.Add;

1509: CLOSE C_Item1;
1510: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1511: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');
1512: FND_MESSAGE.Set_Token('COLUMN','ITEM RELATED', FALSE);
1513: FND_MSG_PUB.Add;
1514: END IF;
1515: raise FND_API.G_EXC_ERROR;
1516:
1517: ELSE

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

1572: IF nvl(l_service_item_flag,'N') = 'Y' THEN
1573:
1574: IF P_Qte_Line_Rec.start_date_active is NULL OR P_Qte_Line_Rec.start_date_active = FND_API.G_MISS_DATE THEN
1575:
1576: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1577: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
1578: FND_MESSAGE.Set_Token('COLUMN', 'START_DATE_ACTIVE', FALSE);
1579: FND_MSG_PUB.ADD;
1580: END IF;

Line 1579: FND_MSG_PUB.ADD;

1575:
1576: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1577: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
1578: FND_MESSAGE.Set_Token('COLUMN', 'START_DATE_ACTIVE', FALSE);
1579: FND_MSG_PUB.ADD;
1580: END IF;
1581: RAISE FND_API.G_EXC_ERROR;
1582:
1583: END IF;

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

1588: Fetch C_customer into l_acct, l_party;
1589:
1590: IF C_customer%NOTFOUND THEN
1591:
1592: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1593: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
1594: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_INFO', FALSE);
1595: FND_MSG_PUB.ADD;
1596: END IF;

Line 1595: FND_MSG_PUB.ADD;

1591:
1592: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1593: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
1594: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_INFO', FALSE);
1595: FND_MSG_PUB.ADD;
1596: END IF;
1597: END IF;
1598:
1599: Close C_customer;

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

1643: IF l_qte_line_dtl_tbl.count > 0 THEN
1644: l_qte_line_rec.end_date_active := null;
1645: l_call_get_duration := FND_API.G_TRUE;
1646: ELSE
1647: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1648: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO5');
1649: FND_MSG_PUB.Add;
1650: END IF;
1651: RAISE FND_API.G_EXC_ERROR;

Line 1649: FND_MSG_PUB.Add;

1645: l_call_get_duration := FND_API.G_TRUE;
1646: ELSE
1647: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1648: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO5');
1649: FND_MSG_PUB.Add;
1650: END IF;
1651: RAISE FND_API.G_EXC_ERROR;
1652: END IF;
1653:

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

1721: if aso_debug_pub.g_debug_flag = 'Y' THEN
1722: aso_debug_pub.add('Populate_quote_lines: ELSEIF Cond end date IS NULL and l_qte_line_dtl_tbl.count = 0', 1, 'N');
1723: end if;
1724:
1725: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1726: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO5');
1727: FND_MSG_PUB.Add;
1728: END IF;
1729:

Line 1727: FND_MSG_PUB.Add;

1723: end if;
1724:
1725: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1726: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO5');
1727: FND_MSG_PUB.Add;
1728: END IF;
1729:
1730: RAISE FND_API.G_EXC_ERROR;
1731:

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

2002: FETCH C_header into l_qte_line_rec.quote_header_id, l_organization_id, l_inventory_item_id;
2003:
2004: IF (C_header%NOTFOUND) THEN
2005:
2006: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2007:
2008: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2009: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_ID', FALSE);
2010: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(l_qte_line_rec.quote_header_id), FALSE);

Line 2011: FND_MSG_PUB.ADD;

2007:
2008: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2009: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_ID', FALSE);
2010: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(l_qte_line_rec.quote_header_id), FALSE);
2011: FND_MSG_PUB.ADD;
2012: END IF;
2013:
2014: END IF;
2015: CLOSE C_header;

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

2036: fetch c_shipment into l_shipment_rec_count, l_total_shipment_quantity;
2037:
2038: IF (C_Shipment%NOTFOUND) THEN
2039:
2040: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2041: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SHIPMENT');
2042: FND_MESSAGE.Set_Token('LINE', to_char(p_qte_line_rec.quote_line_id), FALSE);
2043: END IF;
2044:

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

2062:
2063:
2064: IF l_shipment_tbl.count > 1 THEN
2065:
2066: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2067: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_SHIPMENTS');
2068: FND_MSG_PUB.ADD;
2069: END IF;
2070: raise FND_API.G_EXC_ERROR;

Line 2068: FND_MSG_PUB.ADD;

2064: IF l_shipment_tbl.count > 1 THEN
2065:
2066: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2067: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_SHIPMENTS');
2068: FND_MSG_PUB.ADD;
2069: END IF;
2070: raise FND_API.G_EXC_ERROR;
2071:
2072: ELSIF l_shipment_tbl.count > 0 THEN

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

2097:
2098: FOR i IN 1..l_shipment_tbl.count LOOP
2099:
2100: IF l_shipment_tbl(i).operation_code = 'CREATE' THEN
2101: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2102: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_SHIPMENT');
2103: FND_MSG_PUB.ADD;
2104: END IF;
2105: raise FND_API.G_EXC_ERROR;

Line 2103: FND_MSG_PUB.ADD;

2099:
2100: IF l_shipment_tbl(i).operation_code = 'CREATE' THEN
2101: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2102: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_SHIPMENT');
2103: FND_MSG_PUB.ADD;
2104: END IF;
2105: raise FND_API.G_EXC_ERROR;
2106: END IF;
2107:

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

2118: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2119: aso_debug_pub.add('Populate_Quote_lines: c_item1%NOTFOUND true, raising error', 1, 'N');
2120: END IF;
2121:
2122: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2123: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');
2124: FND_MESSAGE.Set_Token ('INFO', 'ITEM RELATED', FALSE);
2125: FND_MSG_PUB.Add;
2126: END IF;

Line 2125: FND_MSG_PUB.Add;

2121:
2122: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2123: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');
2124: FND_MESSAGE.Set_Token ('INFO', 'ITEM RELATED', FALSE);
2125: FND_MSG_PUB.Add;
2126: END IF;
2127:
2128: close c_item1;
2129: raise FND_API.G_EXC_ERROR;

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

2147: --if start_date_active is null then raise error
2148:
2149: if p_qte_line_rec.start_date_active is NULL then
2150:
2151: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2152: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
2153: FND_MESSAGE.Set_Token('COLUMN', 'START_DATE_ACTIVE', FALSE);
2154: FND_MSG_PUB.ADD;
2155: END IF;

Line 2154: FND_MSG_PUB.ADD;

2150:
2151: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2152: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
2153: FND_MESSAGE.Set_Token('COLUMN', 'START_DATE_ACTIVE', FALSE);
2154: FND_MSG_PUB.ADD;
2155: END IF;
2156:
2157: RAISE FND_API.G_EXC_ERROR;
2158:

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

2188: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2189: aso_debug_pub.add('Populate_Quote_lines: C_service_item%NOTFOUND true, raising error', 1, 'N');
2190: END IF;
2191:
2192: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2193: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');
2194: FND_MESSAGE.Set_Token('INFO', 'SERVICE RELATED', FALSE);
2195: FND_MSG_PUB.ADD;
2196: END IF;

Line 2195: FND_MSG_PUB.ADD;

2191:
2192: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2193: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');
2194: FND_MESSAGE.Set_Token('INFO', 'SERVICE RELATED', FALSE);
2195: FND_MSG_PUB.ADD;
2196: END IF;
2197:
2198: RAISE FND_API.G_EXC_ERROR;
2199:

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

2262: end if;
2263:
2264: if l_qte_line_dtl_tbl.count = 0 then
2265:
2266: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2267: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO5');
2268: FND_MSG_PUB.Add;
2269: END IF;
2270:

Line 2268: FND_MSG_PUB.Add;

2264: if l_qte_line_dtl_tbl.count = 0 then
2265:
2266: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2267: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO5');
2268: FND_MSG_PUB.Add;
2269: END IF;
2270:
2271: RAISE FND_API.G_EXC_ERROR;
2272:

Line 2763: FND_MSG_PUB.initialize;

2759: END IF;
2760:
2761: -- Initialize message list if p_init_msg_list is set to TRUE.
2762: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2763: FND_MSG_PUB.initialize;
2764: END IF;
2765:
2766: -- Initialize API return status to SUCCESS
2767: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2803: -- ******************************************************************
2804: -- Validate Environment
2805: -- ******************************************************************
2806: IF FND_GLOBAL.User_Id IS NULL THEN
2807: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2808: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
2809: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2810: FND_MSG_PUB.ADD;
2811: END IF;

Line 2810: FND_MSG_PUB.ADD;

2806: IF FND_GLOBAL.User_Id IS NULL THEN
2807: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2808: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
2809: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2810: FND_MSG_PUB.ADD;
2811: END IF;
2812: RAISE FND_API.G_EXC_ERROR;
2813: END IF;
2814:

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

2829:
2830:
2831: If ( C_Get_quote%NOTFOUND) Then
2832:
2833: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2834: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_UPDATE_TARGET');
2835: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
2836: FND_MSG_PUB.Add;
2837: END IF;

Line 2836: FND_MSG_PUB.Add;

2832:
2833: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2834: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_UPDATE_TARGET');
2835: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
2836: FND_MSG_PUB.Add;
2837: END IF;
2838: raise FND_API.G_EXC_ERROR;
2839: END IF;
2840: Close C_Get_quote;

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

2843: aso_debug_pub.add('After C_Get_quote Cursor call ',1,'N');
2844: end if;
2845:
2846: If (l_last_update_date is NULL or l_last_update_date = FND_API.G_MISS_Date ) Then
2847: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2848: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
2849: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
2850: FND_MSG_PUB.ADD;
2851: END IF;

Line 2850: FND_MSG_PUB.ADD;

2846: If (l_last_update_date is NULL or l_last_update_date = FND_API.G_MISS_Date ) Then
2847: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2848: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
2849: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
2850: FND_MSG_PUB.ADD;
2851: END IF;
2852: raise FND_API.G_EXC_ERROR;
2853: End if;
2854:

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

2854:
2855: -- Check Whether record has been changed by someone else
2856:
2857: If (trunc(l_last_update_date) <> trunc(p_control_rec.last_update_date)) Then
2858: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2859: FND_MESSAGE.Set_Name('ASO', 'API_RECORD_CHANGED');
2860: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
2861: FND_MSG_PUB.ADD;
2862: END IF;

Line 2861: FND_MSG_PUB.ADD;

2857: If (trunc(l_last_update_date) <> trunc(p_control_rec.last_update_date)) Then
2858: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2859: FND_MESSAGE.Set_Name('ASO', 'API_RECORD_CHANGED');
2860: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
2861: FND_MSG_PUB.ADD;
2862: END IF;
2863: raise FND_API.G_EXC_ERROR;
2864: End if;
2865:

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

2934: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2935:
2936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2937:
2938: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2939: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
2940: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
2941: FND_MSG_PUB.ADD;
2942: END IF;

Line 2941: FND_MSG_PUB.ADD;

2937:
2938: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2939: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
2940: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
2941: FND_MSG_PUB.ADD;
2942: END IF;
2943:
2944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2945:

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

3060: end if;
3061:
3062: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3063:
3064: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3065: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_DEFAULTING');
3066: FND_MSG_PUB.ADD;
3067: END IF;
3068:

Line 3066: FND_MSG_PUB.ADD;

3062: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3063:
3064: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3065: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_DEFAULTING');
3066: FND_MSG_PUB.ADD;
3067: END IF;
3068:
3069: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3213: x_msg_data => x_msg_data);
3214:
3215: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3216:
3217: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3218: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_SALES_REP_ID');
3219: FND_MSG_PUB.ADD;
3220: END IF;
3221: RAISE FND_API.G_EXC_ERROR;

Line 3219: FND_MSG_PUB.ADD;

3215: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3216:
3217: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3218: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_SALES_REP_ID');
3219: FND_MSG_PUB.ADD;
3220: END IF;
3221: RAISE FND_API.G_EXC_ERROR;
3222:
3223: END IF;

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

3336: OPEN C_org_id;
3337: FETCH C_org_id into l_org_id;
3338: IF C_org_id%NOTFOUND THEN
3339:
3340: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3341: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3342: FND_MESSAGE.Set_Token('COLUMN', 'ORG_ID', FALSE);
3343: FND_MSG_PUB.ADD;
3344: END IF;

Line 3343: FND_MSG_PUB.ADD;

3339:
3340: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3341: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3342: FND_MESSAGE.Set_Token('COLUMN', 'ORG_ID', FALSE);
3343: FND_MSG_PUB.ADD;
3344: END IF;
3345: END IF;
3346: CLOSE C_org_id;
3347: END IF;

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

3383: x_msg_data => x_msg_data);
3384:
3385: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3386:
3387: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3388: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_END_DATE');
3389: FND_MSG_PUB.ADD;
3390: END IF;
3391: RAISE FND_API.G_EXC_ERROR;

Line 3389: FND_MSG_PUB.ADD;

3385: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3386:
3387: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3388: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_END_DATE');
3389: FND_MSG_PUB.ADD;
3390: END IF;
3391: RAISE FND_API.G_EXC_ERROR;
3392: END IF;
3393:

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

3401: x_msg_count => x_msg_count,
3402: x_msg_data => x_msg_data);
3403:
3404: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3405: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3406: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
3407: FND_MESSAGE.Set_Token('INFO', 'RETURN', FALSE);
3408: FND_MSG_PUB.ADD;
3409: END IF;

Line 3408: FND_MSG_PUB.ADD;

3404: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3405: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3406: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
3407: FND_MESSAGE.Set_Token('INFO', 'RETURN', FALSE);
3408: FND_MSG_PUB.ADD;
3409: END IF;
3410: RAISE FND_API.G_EXC_ERROR;
3411: END IF;
3412: END LOOP;

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

3421: x_return_status => x_return_status,
3422: x_msg_count => x_msg_count,
3423: x_msg_data => x_msg_data);
3424: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3425: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3426: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
3427: FND_MESSAGE.Set_Token('INFO', 'TAX', FALSE);
3428: FND_MSG_PUB.ADD;
3429: END IF;

Line 3428: FND_MSG_PUB.ADD;

3424: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3425: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3426: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
3427: FND_MESSAGE.Set_Token('INFO', 'TAX', FALSE);
3428: FND_MSG_PUB.ADD;
3429: END IF;
3430: RAISE FND_API.G_EXC_ERROR;
3431: END IF;
3432: END LOOP;

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

3478: x_return_status => x_return_status,
3479: x_msg_count => x_msg_count,
3480: x_msg_data => x_msg_data);
3481: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3482: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3483: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
3484: FND_MESSAGE.Set_Token('INFO', 'DELAYED_SERVICE', FALSE);
3485: FND_MSG_PUB.ADD;
3486: END IF;

Line 3485: FND_MSG_PUB.ADD;

3481: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3482: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3483: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
3484: FND_MESSAGE.Set_Token('INFO', 'DELAYED_SERVICE', FALSE);
3485: FND_MSG_PUB.ADD;
3486: END IF;
3487: RAISE FND_API.G_EXC_ERROR;
3488: END IF;
3489: END LOOP;

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

3499: x_return_status => x_return_status,
3500: x_msg_count => x_msg_count,
3501: x_msg_data => x_msg_data);
3502: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3503: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3504: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
3505: FND_MESSAGE.Set_Token('INFO', 'PARTY OBJECT ID', FALSE);
3506: FND_MSG_PUB.ADD;
3507: END IF;

Line 3506: FND_MSG_PUB.ADD;

3502: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3503: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3504: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
3505: FND_MESSAGE.Set_Token('INFO', 'PARTY OBJECT ID', FALSE);
3506: FND_MSG_PUB.ADD;
3507: END IF;
3508: RAISE FND_API.G_EXC_ERROR;
3509: END IF;
3510: END LOOP;

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

3540: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3541: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: after Validate_ship_from_org_ID: <> SUCCESS', 1, 'Y');
3542: end if;
3543:
3544: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3545: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SHIP_FROM_ORG_ID');
3546: FND_MESSAGE.Set_Token('SHIP_FROM_ORG_ID', lx_ln_shipment_tbl(1).ship_from_org_id, FALSE);
3547: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', lx_qte_line_rec.inventory_item_id, FALSE);
3548: FND_MSG_PUB.ADD;

Line 3548: FND_MSG_PUB.ADD;

3544: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3545: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SHIP_FROM_ORG_ID');
3546: FND_MESSAGE.Set_Token('SHIP_FROM_ORG_ID', lx_ln_shipment_tbl(1).ship_from_org_id, FALSE);
3547: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', lx_qte_line_rec.inventory_item_id, FALSE);
3548: FND_MSG_PUB.ADD;
3549: END IF;
3550:
3551: RAISE FND_API.G_EXC_ERROR;
3552: END IF;

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

3588: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3589: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: after Validate_ship_from_org_ID: <> SUCCESS', 1, 'Y');
3590: end if;
3591:
3592: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3593: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SHIP_FROM_ORG_ID');
3594: FND_MESSAGE.Set_Token('SHIP_FROM_ORG_ID', l_hd_shipment_rec.ship_from_org_id, FALSE);
3595: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', lx_qte_line_rec.inventory_item_id, FALSE);
3596: FND_MSG_PUB.ADD;

Line 3596: FND_MSG_PUB.ADD;

3592: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3593: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SHIP_FROM_ORG_ID');
3594: FND_MESSAGE.Set_Token('SHIP_FROM_ORG_ID', l_hd_shipment_rec.ship_from_org_id, FALSE);
3595: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', lx_qte_line_rec.inventory_item_id, FALSE);
3596: FND_MSG_PUB.ADD;
3597: END IF;
3598:
3599: RAISE FND_API.G_EXC_ERROR;
3600: END IF;

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

3651: aso_debug_pub.add('Create_Quote_lines - after populate_quote_line '||x_return_status, 1, 'Y');
3652: end if;
3653:
3654: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3655: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3656: FND_MESSAGE.Set_Name('ASO', 'ASO_POPULATING_COLUMNS');
3657: FND_MESSAGE.Set_Token('LINE' , x_qte_line_rec.line_number, FALSE);
3658: FND_MSG_PUB.ADD;
3659: END IF;

Line 3658: FND_MSG_PUB.ADD;

3654: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3655: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3656: FND_MESSAGE.Set_Name('ASO', 'ASO_POPULATING_COLUMNS');
3657: FND_MESSAGE.Set_Token('LINE' , x_qte_line_rec.line_number, FALSE);
3658: FND_MSG_PUB.ADD;
3659: END IF;
3660:
3661: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3691:
3692: IF (l_is_model_published is null or l_is_model_published = 101 ) THEN
3693: --cz_cf_api.NATIVEBOM_UI_DEF
3694: -- this means the model is not published , raise error
3695: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3696: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_CFG_UI');
3697: FND_MSG_PUB.ADD;
3698: END IF;
3699:

Line 3697: FND_MSG_PUB.ADD;

3693: --cz_cf_api.NATIVEBOM_UI_DEF
3694: -- this means the model is not published , raise error
3695: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3696: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_CFG_UI');
3697: FND_MSG_PUB.ADD;
3698: END IF;
3699:
3700: RAISE FND_API.G_EXC_ERROR;
3701: END IF;

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

3773: x_msg_data => x_msg_data);
3774:
3775: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3776:
3777: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3778: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
3779: FND_MESSAGE.Set_Token('INFO','SERVICE', FALSE);
3780: FND_MSG_PUB.ADD;
3781: END IF;

Line 3780: FND_MSG_PUB.ADD;

3776:
3777: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3778: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
3779: FND_MESSAGE.Set_Token('INFO','SERVICE', FALSE);
3780: FND_MSG_PUB.ADD;
3781: END IF;
3782:
3783: RAISE FND_API.G_EXC_ERROR;
3784:

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

3813: IF C_line_category_code%FOUND AND l_line_category_code = 'RETURN' THEN
3814:
3815: CLOSE C_line_category_code;
3816:
3817: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3818: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SERVICE_REFERENCE');
3819: FND_MSG_PUB.ADD;
3820: END IF;
3821:

Line 3819: FND_MSG_PUB.ADD;

3815: CLOSE C_line_category_code;
3816:
3817: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3818: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SERVICE_REFERENCE');
3819: FND_MSG_PUB.ADD;
3820: END IF;
3821:
3822: RAISE FND_API.G_EXC_ERROR;
3823:

Line 3841: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3837: p_qte_line_dtl_tbl(i).service_ref_type_code = fnd_api.g_miss_char then
3838:
3839: x_return_status := fnd_api.g_ret_sts_error;
3840:
3841: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3842: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3843: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_REF_TYPE_CODE', FALSE);
3844: FND_MESSAGE.Set_Token('VALUE', p_qte_line_dtl_tbl(i).service_ref_type_code,FALSE);
3845: FND_MSG_PUB.ADD;

Line 3845: FND_MSG_PUB.ADD;

3841: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3842: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3843: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_REF_TYPE_CODE', FALSE);
3844: FND_MESSAGE.Set_Token('VALUE', p_qte_line_dtl_tbl(i).service_ref_type_code,FALSE);
3845: FND_MSG_PUB.ADD;
3846: END IF;
3847:
3848: raise fnd_api.g_exc_error;
3849:

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

3887:
3888:
3889: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3890:
3891: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3892: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
3893: FND_MSG_PUB.ADD;
3894: END IF;
3895:

Line 3893: FND_MSG_PUB.ADD;

3889: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3890:
3891: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3892: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
3893: FND_MSG_PUB.ADD;
3894: END IF;
3895:
3896: RAISE FND_API.G_EXC_ERROR;
3897:

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

4050: end if;
4051: IF l_qte_line_rec.UOM_Code = 'ENR' THEN
4052: IF l_qte_line_rec.Quantity <> 1 THEN
4053: x_return_status := FND_API.G_RET_STS_ERROR;
4054: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4055: FND_MESSAGE.Set_Name('ASO', 'ASO_EDU_INVALID_QTY');
4056: FND_MSG_PUB.ADD;
4057: END IF;
4058: RAISE FND_API.G_EXC_ERROR;

Line 4056: FND_MSG_PUB.ADD;

4052: IF l_qte_line_rec.Quantity <> 1 THEN
4053: x_return_status := FND_API.G_RET_STS_ERROR;
4054: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4055: FND_MESSAGE.Set_Name('ASO', 'ASO_EDU_INVALID_QTY');
4056: FND_MSG_PUB.ADD;
4057: END IF;
4058: RAISE FND_API.G_EXC_ERROR;
4059: END IF;
4060: END IF;

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

4137: X_Msg_Data => x_msg_data
4138: );
4139:
4140: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4141: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4142: FND_MESSAGE.Set_Name('ASO', 'ASO_INSERT_ERROR');
4143: FND_MSG_PUB.ADD;
4144: END IF;
4145: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4143: FND_MSG_PUB.ADD;

4139:
4140: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4141: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4142: FND_MESSAGE.Set_Name('ASO', 'ASO_INSERT_ERROR');
4143: FND_MSG_PUB.ADD;
4144: END IF;
4145: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4147: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 4325: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

4321: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4322: aso_debug_pub.add('Create_Quote_lines - after create_acct_site_uses- invoice_org_id: '||nvl(to_char(l_invoice_org_id),'null'), 1, 'N');
4323: end if;
4324: IF L_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
4325: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4326: THEN
4327: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
4328: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_TO_SITE_USE_ID',FALSE);
4329: FND_MSG_PUB.ADD;

Line 4329: FND_MSG_PUB.ADD;

4325: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4326: THEN
4327: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
4328: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_TO_SITE_USE_ID',FALSE);
4329: FND_MSG_PUB.ADD;
4330: END IF;
4331: -- raise FND_API.G_EXC_ERROR;
4332: END IF;
4333: END IF;

Line 4355: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

4351: ,x_site_use_id => l_ship_org_id
4352: );
4353:
4354: IF L_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
4355: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4356: THEN
4357: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
4358: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_TO_SITE_USE_ID',FALSE);
4359: FND_MSG_PUB.ADD;

Line 4359: FND_MSG_PUB.ADD;

4355: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4356: THEN
4357: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
4358: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_TO_SITE_USE_ID',FALSE);
4359: FND_MSG_PUB.ADD;
4360: END IF;
4361: -- raise FND_API.G_EXC_ERROR;
4362: END IF;
4363:

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

4382: x_tax_detail_tbl(i) := l_tax_detail_tbl(1);
4383: end if;
4384:
4385: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4386: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4387: FND_MESSAGE.Set_Name('ASO', 'ASO_TAX_CALCULATION');
4388: FND_MSG_PUB.ADD;
4389: END IF;
4390: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4388: FND_MSG_PUB.ADD;

4384:
4385: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4386: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4387: FND_MESSAGE.Set_Name('ASO', 'ASO_TAX_CALCULATION');
4388: FND_MSG_PUB.ADD;
4389: END IF;
4390: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4392: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

4433: last_update_login = fnd_global.conc_login_id
4434: WHERE shipment_id = l_shipment_tbl(i).shipment_id;
4435:
4436: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4437: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4438: FND_MESSAGE.Set_Name('ASO', 'ASO_CREATING_RESERVATION');
4439: FND_MESSAGE.Set_Token('LINE' , x_qte_line_rec.line_number, FALSE);
4440: FND_MSG_PUB.ADD;
4441: END IF;

Line 4440: FND_MSG_PUB.ADD;

4436: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4437: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4438: FND_MESSAGE.Set_Name('ASO', 'ASO_CREATING_RESERVATION');
4439: FND_MESSAGE.Set_Token('LINE' , x_qte_line_rec.line_number, FALSE);
4440: FND_MSG_PUB.ADD;
4441: END IF;
4442: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4444: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

4478: X_Msg_Count => x_msg_count,
4479: X_Msg_Data => x_msg_data);
4480:
4481: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4482: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4483: FND_MESSAGE.Set_Name('ASO', 'ASO_UPDATE_QUOTE_TOTAL');
4484: -- FND_MESSAGE.Set_Token('LINE' , x_qte_line_rec.line_number, FALSE);
4485: FND_MSG_PUB.ADD;
4486: END IF;

Line 4485: FND_MSG_PUB.ADD;

4481: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4482: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4483: FND_MESSAGE.Set_Name('ASO', 'ASO_UPDATE_QUOTE_TOTAL');
4484: -- FND_MESSAGE.Set_Token('LINE' , x_qte_line_rec.line_number, FALSE);
4485: FND_MSG_PUB.ADD;
4486: END IF;
4487: END IF;
4488:
4489:

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

4487: END IF;
4488:
4489:
4490: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4491: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4492: FND_MESSAGE.Set_Name('ASO', 'ASO_UPDATE_QUOTE_TOTAL');
4493: -- FND_MESSAGE.Set_Token('LINE' , x_qte_line_rec.line_number, FALSE);
4494: FND_MSG_PUB.ADD;
4495: END IF;

Line 4494: FND_MSG_PUB.ADD;

4490: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4491: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4492: FND_MESSAGE.Set_Name('ASO', 'ASO_UPDATE_QUOTE_TOTAL');
4493: -- FND_MESSAGE.Set_Token('LINE' , x_qte_line_rec.line_number, FALSE);
4494: FND_MSG_PUB.ADD;
4495: END IF;
4496: END IF;
4497:
4498: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4541: FND_MSG_PUB.Count_And_Get

4537:
4538:
4539:
4540: -- Standard call to get message count and if count is 1, get message info.
4541: FND_MSG_PUB.Count_And_Get
4542: ( p_count => x_msg_count,
4543: p_data => x_msg_data
4544: );
4545:

Line 4551: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4547: WHEN FND_API.G_EXC_ERROR THEN
4548: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4549: P_API_NAME => L_API_NAME
4550: ,P_PKG_NAME => G_PKG_NAME
4551: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4552: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
4553: ,P_SQLCODE => SQLCODE
4554: ,P_SQLERRM => SQLERRM
4555: ,X_MSG_COUNT => X_MSG_COUNT

Line 4563: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4560: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4561: P_API_NAME => L_API_NAME
4562: ,P_PKG_NAME => G_PKG_NAME
4563: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4564: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
4565: ,P_SQLCODE => SQLCODE
4566: ,P_SQLERRM => SQLERRM
4567: ,X_MSG_COUNT => X_MSG_COUNT

Line 4933: FND_MSG_PUB.initialize;

4929:
4930:
4931: -- Initialize message list if p_init_msg_list is set to TRUE.
4932: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4933: FND_MSG_PUB.initialize;
4934: END IF;
4935:
4936:
4937: -- Initialize API return status to SUCCESS

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

4975: -- ******************************************************************
4976: -- Validate Environment
4977: -- ******************************************************************
4978: IF FND_GLOBAL.User_Id IS NULL THEN
4979: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4980: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
4981: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
4982: FND_MSG_PUB.ADD;
4983: END IF;

Line 4982: FND_MSG_PUB.ADD;

4978: IF FND_GLOBAL.User_Id IS NULL THEN
4979: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4980: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
4981: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
4982: FND_MSG_PUB.ADD;
4983: END IF;
4984: RAISE FND_API.G_EXC_ERROR;
4985: END IF;
4986:

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

4989: FETCH C_qln_exist into l_qln_exist;
4990:
4991: IF c_qln_exist%NOTFOUND OR l_qln_exist = FND_API.G_MISS_NUM THEN
4992:
4993: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4994: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_LINE');
4995: FND_MESSAGE.Set_Token ('VALUE', p_qte_line_rec.quote_line_id, FALSE);
4996: FND_MSG_PUB.ADD;
4997: END IF;

Line 4996: FND_MSG_PUB.ADD;

4992:
4993: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4994: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_LINE');
4995: FND_MESSAGE.Set_Token ('VALUE', p_qte_line_rec.quote_line_id, FALSE);
4996: FND_MSG_PUB.ADD;
4997: END IF;
4998: CLOSE C_qln_exist;
4999: raise FND_API.G_EXC_ERROR;
5000:

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

5013: aso_debug_pub.add('l_hd_discount_percent: '||nvl(to_char(l_hd_discount_percent),'null'),1,'N');
5014: end if;
5015:
5016: If ( C_Get_quote%NOTFOUND) Then
5017: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5018: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_UPDATE_TARGET');
5019: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
5020: FND_MSG_PUB.Add;
5021: END IF;

Line 5020: FND_MSG_PUB.Add;

5016: If ( C_Get_quote%NOTFOUND) Then
5017: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5018: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_UPDATE_TARGET');
5019: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
5020: FND_MSG_PUB.Add;
5021: END IF;
5022: Close C_Get_quote;
5023: raise FND_API.G_EXC_ERROR;
5024: END IF;

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

5029: end if;
5030:
5031: If (l_last_update_date is NULL or l_last_update_date = FND_API.G_MISS_Date ) Then
5032:
5033: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5034: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
5035: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
5036: FND_MSG_PUB.ADD;
5037: END IF;

Line 5036: FND_MSG_PUB.ADD;

5032:
5033: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5034: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
5035: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
5036: FND_MSG_PUB.ADD;
5037: END IF;
5038: raise FND_API.G_EXC_ERROR;
5039: End if;
5040:

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

5040:
5041: -- Check Whether record has been changed by someone else
5042: If (trunc(l_last_update_date) <> trunc(p_control_rec.last_update_date)) Then
5043:
5044: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5045: FND_MESSAGE.Set_Name('ASO', 'API_RECORD_CHANGED');
5046: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
5047: FND_MSG_PUB.ADD;
5048: END IF;

Line 5047: FND_MSG_PUB.ADD;

5043:
5044: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5045: FND_MESSAGE.Set_Name('ASO', 'API_RECORD_CHANGED');
5046: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
5047: FND_MSG_PUB.ADD;
5048: END IF;
5049: raise FND_API.G_EXC_ERROR;
5050: End if;
5051:

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

5213: end if;
5214:
5215: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5216:
5217: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5218: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_DEFAULTING');
5219: FND_MSG_PUB.ADD;
5220: END IF;
5221:

Line 5219: FND_MSG_PUB.ADD;

5215: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5216:
5217: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5218: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_DEFAULTING');
5219: FND_MSG_PUB.ADD;
5220: END IF;
5221:
5222: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5320: x_msg_data => x_msg_data);
5321:
5322: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5323:
5324: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5325: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
5326: FND_MESSAGE.Set_Token('COLUMN', 'Price List Expires Before Quote', FALSE);
5327: FND_MSG_PUB.ADD;
5328: END IF;

Line 5327: FND_MSG_PUB.ADD;

5323:
5324: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5325: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
5326: FND_MESSAGE.Set_Token('COLUMN', 'Price List Expires Before Quote', FALSE);
5327: FND_MSG_PUB.ADD;
5328: END IF;
5329:
5330: RAISE FND_API.G_EXC_ERROR;
5331: END IF;

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

5434: x_msg_data => x_msg_data);
5435:
5436: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5437:
5438: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5439: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_SALES_REP_ID');
5440: FND_MSG_PUB.ADD;
5441: END IF;
5442: RAISE FND_API.G_EXC_ERROR;

Line 5440: FND_MSG_PUB.ADD;

5436: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5437:
5438: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5439: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_SALES_REP_ID');
5440: FND_MSG_PUB.ADD;
5441: END IF;
5442: RAISE FND_API.G_EXC_ERROR;
5443: END IF;
5444:

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

5560: FETCH C_org_id into l_org_id;
5561:
5562: IF C_org_id%NOTFOUND THEN
5563:
5564: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5565: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5566: FND_MESSAGE.Set_Token('COLUMN', 'ORG_ID', FALSE);
5567: FND_MSG_PUB.ADD;
5568: END IF;

Line 5567: FND_MSG_PUB.ADD;

5563:
5564: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5565: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5566: FND_MESSAGE.Set_Token('COLUMN', 'ORG_ID', FALSE);
5567: FND_MSG_PUB.ADD;
5568: END IF;
5569:
5570: END IF;
5571: CLOSE C_org_id;

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

5624: x_msg_data => x_msg_data);
5625:
5626: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5627:
5628: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5629: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
5630: FND_MESSAGE.Set_Token('INFO', 'END_DATE', FALSE);
5631: FND_MSG_PUB.ADD;
5632: END IF;

Line 5631: FND_MSG_PUB.ADD;

5627:
5628: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5629: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
5630: FND_MESSAGE.Set_Token('INFO', 'END_DATE', FALSE);
5631: FND_MSG_PUB.ADD;
5632: END IF;
5633: RAISE FND_API.G_EXC_ERROR;
5634: END IF;
5635:

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

5649: x_msg_data => x_msg_data);
5650:
5651: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5652:
5653: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5654: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
5655: FND_MESSAGE.Set_Token('INFO', 'RETURN', FALSE);
5656: FND_MSG_PUB.ADD;
5657: END IF;

Line 5656: FND_MSG_PUB.ADD;

5652:
5653: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5654: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
5655: FND_MESSAGE.Set_Token('INFO', 'RETURN', FALSE);
5656: FND_MSG_PUB.ADD;
5657: END IF;
5658: RAISE FND_API.G_EXC_ERROR;
5659: END IF;
5660:

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

5678: x_msg_data => x_msg_data);
5679:
5680: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5681:
5682: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5683: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
5684: FND_MESSAGE.Set_Token('INFO', 'TAX', FALSE);
5685: FND_MSG_PUB.ADD;
5686: END IF;

Line 5685: FND_MSG_PUB.ADD;

5681:
5682: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5683: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
5684: FND_MESSAGE.Set_Token('INFO', 'TAX', FALSE);
5685: FND_MSG_PUB.ADD;
5686: END IF;
5687: RAISE FND_API.G_EXC_ERROR;
5688: END IF;
5689:

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

5723: end if;
5724:
5725: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5726:
5727: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5728: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
5729: FND_MESSAGE.Set_Token('INFO', 'CONFIGURATION', FALSE);
5730: FND_MSG_PUB.ADD;
5731: END IF;

Line 5730: FND_MSG_PUB.ADD;

5726:
5727: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5728: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
5729: FND_MESSAGE.Set_Token('INFO', 'CONFIGURATION', FALSE);
5730: FND_MSG_PUB.ADD;
5731: END IF;
5732: RAISE FND_API.G_EXC_ERROR;
5733: END IF;
5734: END IF;

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

5752: x_msg_data => x_msg_data);
5753:
5754: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5755:
5756: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5757: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
5758: FND_MESSAGE.Set_Token('INFO', 'DELAYED SERVICE', FALSE);
5759: FND_MSG_PUB.ADD;
5760: END IF;

Line 5759: FND_MSG_PUB.ADD;

5755:
5756: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5757: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
5758: FND_MESSAGE.Set_Token('INFO', 'DELAYED SERVICE', FALSE);
5759: FND_MSG_PUB.ADD;
5760: END IF;
5761: RAISE FND_API.G_EXC_ERROR;
5762: END IF;
5763:

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

5779: x_return_status => x_return_status,
5780: x_msg_count => x_msg_count,
5781: x_msg_data => x_msg_data);
5782: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5783: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5784: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
5785: FND_MESSAGE.Set_Token('INFO', 'PARTY OBJECT ID', FALSE);
5786: FND_MSG_PUB.ADD;
5787: END IF;

Line 5786: FND_MSG_PUB.ADD;

5782: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5783: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5784: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
5785: FND_MESSAGE.Set_Token('INFO', 'PARTY OBJECT ID', FALSE);
5786: FND_MSG_PUB.ADD;
5787: END IF;
5788: RAISE FND_API.G_EXC_ERROR;
5789: END IF;
5790: END LOOP;

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

5837: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5838: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_Line: after Validate_ship_from_org_ID: <> SUCCESS', 1, 'Y');
5839: end if;
5840:
5841: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5842: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SHIP_FROM_ORG_ID');
5843: FND_MESSAGE.Set_Token('SHIP_FROM_ORG_ID', lx_ln_shipment_tbl(1).ship_from_org_id, FALSE);
5844: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', lx_qte_line_rec.inventory_item_id, FALSE);
5845: FND_MSG_PUB.ADD;

Line 5845: FND_MSG_PUB.ADD;

5841: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5842: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SHIP_FROM_ORG_ID');
5843: FND_MESSAGE.Set_Token('SHIP_FROM_ORG_ID', lx_ln_shipment_tbl(1).ship_from_org_id, FALSE);
5844: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', lx_qte_line_rec.inventory_item_id, FALSE);
5845: FND_MSG_PUB.ADD;
5846: END IF;
5847:
5848: RAISE FND_API.G_EXC_ERROR;
5849:

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

5884: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5885: aso_debug_pub.add('Update_Quote_Line: after Validate_ship_from_org_ID: <> SUCCESS (no lx_ln_shipment_tbl)', 1, 'Y');
5886: end if;
5887:
5888: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5889: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SHIP_FROM_ORG_ID');
5890: FND_MESSAGE.Set_Token('SHIP_FROM_ORG_ID', l_db_shipment_rec.ship_from_org_id, FALSE);
5891: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', lx_qte_line_rec.inventory_item_id, FALSE);
5892: FND_MSG_PUB.ADD;

Line 5892: FND_MSG_PUB.ADD;

5888: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5889: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SHIP_FROM_ORG_ID');
5890: FND_MESSAGE.Set_Token('SHIP_FROM_ORG_ID', l_db_shipment_rec.ship_from_org_id, FALSE);
5891: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', lx_qte_line_rec.inventory_item_id, FALSE);
5892: FND_MSG_PUB.ADD;
5893: END IF;
5894:
5895: RAISE FND_API.G_EXC_ERROR;
5896: END IF;

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

5932: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5933: aso_debug_pub.add('after Validate_ship_from_org_ID: <> SUCCESS (no db_shipment_tbl)', 1, 'Y');
5934: end if;
5935:
5936: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5937: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SHIP_FROM_ORG_ID');
5938: FND_MESSAGE.Set_Token('SHIP_FROM_ORG_ID', l_hd_shipment_rec.ship_from_org_id, FALSE);
5939: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', lx_qte_line_rec.inventory_item_id, FALSE);
5940: FND_MSG_PUB.ADD;

Line 5940: FND_MSG_PUB.ADD;

5936: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5937: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SHIP_FROM_ORG_ID');
5938: FND_MESSAGE.Set_Token('SHIP_FROM_ORG_ID', l_hd_shipment_rec.ship_from_org_id, FALSE);
5939: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', lx_qte_line_rec.inventory_item_id, FALSE);
5940: FND_MSG_PUB.ADD;
5941: END IF;
5942:
5943: RAISE FND_API.G_EXC_ERROR;
5944: END IF;

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

5975: IF ( C_inst_details%FOUND) AND l_quantity > lx_ln_shipment_tbl(i).quantity Then
5976:
5977: Close C_inst_details;
5978:
5979: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5980: FND_MESSAGE.Set_Name('ASO', 'INST_DETAILS_EXIST');
5981: FND_MSG_PUB.ADD;
5982: END IF;
5983: raise FND_API.G_EXC_ERROR;

Line 5981: FND_MSG_PUB.ADD;

5977: Close C_inst_details;
5978:
5979: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5980: FND_MESSAGE.Set_Name('ASO', 'INST_DETAILS_EXIST');
5981: FND_MSG_PUB.ADD;
5982: END IF;
5983: raise FND_API.G_EXC_ERROR;
5984:
5985: ELSE

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

5995: if (c_csi_details%found) and (l_quantity > lx_ln_shipment_tbl(i).quantity) then
5996:
5997: close c_csi_details;
5998:
5999: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6000: FND_MESSAGE.Set_Name('ASO', 'INST_DETAILS_EXIST');
6001: FND_MSG_PUB.ADD;
6002: END IF;
6003: raise FND_API.G_EXC_ERROR;

Line 6001: FND_MSG_PUB.ADD;

5997: close c_csi_details;
5998:
5999: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6000: FND_MESSAGE.Set_Name('ASO', 'INST_DETAILS_EXIST');
6001: FND_MSG_PUB.ADD;
6002: END IF;
6003: raise FND_API.G_EXC_ERROR;
6004:
6005: else

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

6026: aso_debug_pub.add('Update_Quote_Line - Invalid Quantity for EDU: ',1, 'N');
6027: end if;
6028:
6029: x_return_status := FND_API.G_RET_STS_ERROR;
6030: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6031: FND_MESSAGE.Set_Name('ASO', 'ASO_EDU_INVALID_QTY');
6032: FND_MSG_PUB.ADD;
6033: END IF;
6034: RAISE FND_API.G_EXC_ERROR;

Line 6032: FND_MSG_PUB.ADD;

6028:
6029: x_return_status := FND_API.G_RET_STS_ERROR;
6030: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6031: FND_MESSAGE.Set_Name('ASO', 'ASO_EDU_INVALID_QTY');
6032: FND_MSG_PUB.ADD;
6033: END IF;
6034: RAISE FND_API.G_EXC_ERROR;
6035:
6036: END IF;

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

6076: end if;
6077:
6078: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6079:
6080: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6081: FND_MESSAGE.Set_Name('ASO', 'ASO_POPULATING_COLUMNS');
6082: FND_MESSAGE.Set_Token('LINE' , x_qte_line_rec.line_number, FALSE);
6083: FND_MSG_PUB.ADD;
6084: END IF;

Line 6083: FND_MSG_PUB.ADD;

6079:
6080: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6081: FND_MESSAGE.Set_Name('ASO', 'ASO_POPULATING_COLUMNS');
6082: FND_MESSAGE.Set_Token('LINE' , x_qte_line_rec.line_number, FALSE);
6083: FND_MSG_PUB.ADD;
6084: END IF;
6085:
6086: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6231: end if;
6232:
6233: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
6234:
6235: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6236: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
6237: FND_MESSAGE.Set_Token('INFO','SERVICE', FALSE);
6238: FND_MSG_PUB.ADD;
6239: END IF;

Line 6238: FND_MSG_PUB.ADD;

6234:
6235: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6236: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
6237: FND_MESSAGE.Set_Token('INFO','SERVICE', FALSE);
6238: FND_MSG_PUB.ADD;
6239: END IF;
6240:
6241: RAISE FND_API.G_EXC_ERROR;
6242:

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

6273: IF C_line_category_code%FOUND AND l_line_category_code = 'RETURN' THEN
6274:
6275: CLOSE C_line_category_code;
6276:
6277: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6278: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SERVICE_REFERENCE');
6279: FND_MSG_PUB.ADD;
6280: END IF;
6281:

Line 6279: FND_MSG_PUB.ADD;

6275: CLOSE C_line_category_code;
6276:
6277: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6278: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SERVICE_REFERENCE');
6279: FND_MSG_PUB.ADD;
6280: END IF;
6281:
6282: RAISE FND_API.G_EXC_ERROR;
6283:

Line 6318: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

6314: if l_service_ref_type_code is null then
6315:
6316: x_return_status := fnd_api.g_ret_sts_error;
6317:
6318: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6319: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
6320: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_REF_TYPE_CODE', FALSE);
6321: FND_MESSAGE.Set_Token('VALUE', l_qte_line_dtl_tbl(i).service_ref_type_code,FALSE);
6322: FND_MSG_PUB.ADD;

Line 6322: FND_MSG_PUB.ADD;

6318: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6319: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
6320: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_REF_TYPE_CODE', FALSE);
6321: FND_MESSAGE.Set_Token('VALUE', l_qte_line_dtl_tbl(i).service_ref_type_code,FALSE);
6322: FND_MSG_PUB.ADD;
6323: END IF;
6324:
6325: raise fnd_api.g_exc_error;
6326:

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

6372: IF c_service_exist%FOUND THEN
6373:
6374: CLOSE c_service_exist;
6375:
6376: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6377: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_LINE_CATEGORY');
6378: FND_MSG_PUB.ADD;
6379: END IF;
6380:

Line 6378: FND_MSG_PUB.ADD;

6374: CLOSE c_service_exist;
6375:
6376: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6377: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_LINE_CATEGORY');
6378: FND_MSG_PUB.ADD;
6379: END IF;
6380:
6381: RAISE FND_API.G_EXC_ERROR;
6382:

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

7793: CLOSE C_ship_partial;
7794:
7795: IF l_ship_count = 1 THEN
7796: x_return_status := FND_API.G_RET_STS_ERROR;
7797: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7798: FND_MESSAGE.Set_Name('ASO', 'DELETE_SHIPMENT');
7799: FND_MESSAGE.Set_Token('COLUMN', 'SHIPMENT_ID', FALSE);
7800: FND_MSG_PUB.ADD;
7801: END IF;

Line 7800: FND_MSG_PUB.ADD;

7796: x_return_status := FND_API.G_RET_STS_ERROR;
7797: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7798: FND_MESSAGE.Set_Name('ASO', 'DELETE_SHIPMENT');
7799: FND_MESSAGE.Set_Token('COLUMN', 'SHIPMENT_ID', FALSE);
7800: FND_MSG_PUB.ADD;
7801: END IF;
7802: END IF;
7803:
7804:

Line 8818: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

8814: ,x_msg_data => l_msg_data
8815: ,x_site_use_id => l_invoice_org_id
8816: );
8817: IF L_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
8818: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
8819: THEN
8820: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
8821: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_TO_SITE_USE_ID',FALSE);
8822: FND_MSG_PUB.ADD;

Line 8822: FND_MSG_PUB.ADD;

8818: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
8819: THEN
8820: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
8821: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_TO_SITE_USE_ID',FALSE);
8822: FND_MSG_PUB.ADD;
8823: END IF;
8824: -- raise FND_API.G_EXC_ERROR;
8825: END IF;
8826: END IF;

Line 8849: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

8845: ,x_site_use_id => l_ship_org_id
8846: );
8847:
8848: IF L_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
8849: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
8850: THEN
8851: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
8852: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_TO_SITE_USE_ID',FALSE);
8853: FND_MSG_PUB.ADD;

Line 8853: FND_MSG_PUB.ADD;

8849: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
8850: THEN
8851: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
8852: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_TO_SITE_USE_ID',FALSE);
8853: FND_MSG_PUB.ADD;
8854: END IF;
8855: -- raise FND_API.G_EXC_ERROR;
8856: END IF;
8857:

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

8870: x_tax_detail_tbl(i) := l_tax_detail_tbl(1);
8871: end if;
8872:
8873: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8874: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8875: FND_MESSAGE.Set_Name('ASO', 'ASO_TAX_CALCULATION');
8876: FND_MSG_PUB.ADD;
8877: END IF;
8878: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 8876: FND_MSG_PUB.ADD;

8872:
8873: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8874: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8875: FND_MESSAGE.Set_Name('ASO', 'ASO_TAX_CALCULATION');
8876: FND_MSG_PUB.ADD;
8877: END IF;
8878: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
8879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8880: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

8919: last_update_login = fnd_global.conc_login_id
8920: WHERE shipment_id = l_shipment_tbl(i).shipment_id;
8921:
8922: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8923: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8924: FND_MESSAGE.Set_Name('ASO', 'ASO_CREATING_RESERVATION');
8925: FND_MSG_PUB.ADD;
8926: END IF;
8927: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 8925: FND_MSG_PUB.ADD;

8921:
8922: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8923: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8924: FND_MESSAGE.Set_Name('ASO', 'ASO_CREATING_RESERVATION');
8925: FND_MSG_PUB.ADD;
8926: END IF;
8927: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
8928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8929: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

8959: X_Msg_Count => x_msg_count,
8960: X_Msg_Data => x_msg_data);
8961:
8962: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8963: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8964: FND_MESSAGE.Set_Name('ASO', 'ASO_UPDATE_QUOTE_TOTAL');
8965: -- FND_MESSAGE.Set_Token('LINE' , x_qte_line_rec.line_number, FALSE);
8966: FND_MSG_PUB.ADD;
8967: END IF;

Line 8966: FND_MSG_PUB.ADD;

8962: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8963: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8964: FND_MESSAGE.Set_Name('ASO', 'ASO_UPDATE_QUOTE_TOTAL');
8965: -- FND_MESSAGE.Set_Token('LINE' , x_qte_line_rec.line_number, FALSE);
8966: FND_MSG_PUB.ADD;
8967: END IF;
8968: END IF;
8969:
8970: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 8972: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Private API: '|| l_api_name || 'error in updating header');

8968: END IF;
8969:
8970: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
8971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8972: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Private API: '|| l_api_name || 'error in updating header');
8973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8974: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
8975: x_return_status := FND_API.G_RET_STS_ERROR;
8976: END IF;

Line 9009: FND_MSG_PUB.Count_And_Get

9005:
9006:
9007:
9008: -- Standard call to get message count and if count is 1, get message info.
9009: FND_MSG_PUB.Count_And_Get
9010: ( p_count => x_msg_count,
9011: p_data => x_msg_data
9012: );
9013:

Line 9019: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

9015: WHEN FND_API.G_EXC_ERROR THEN
9016: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9017: P_API_NAME => L_API_NAME
9018: ,P_PKG_NAME => G_PKG_NAME
9019: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
9020: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
9021: ,P_SQLCODE => SQLCODE
9022: ,P_SQLERRM => SQLERRM
9023: ,X_MSG_COUNT => X_MSG_COUNT

Line 9031: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

9027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9028: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9029: P_API_NAME => L_API_NAME
9030: ,P_PKG_NAME => G_PKG_NAME
9031: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9032: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
9033: ,P_SQLCODE => SQLCODE
9034: ,P_SQLERRM => SQLERRM
9035: ,X_MSG_COUNT => X_MSG_COUNT

Line 9228: FND_MSG_PUB.initialize;

9224:
9225:
9226: -- Initialize message list if p_init_msg_list is set to TRUE.
9227: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9228: FND_MSG_PUB.initialize;
9229: END IF;
9230:
9231:
9232: -- Initialize API return status to SUCCESS

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

9238: -- ******************************************************************
9239: -- Validate Environment
9240: -- ******************************************************************
9241: IF FND_GLOBAL.User_Id IS NULL THEN
9242: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9243: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
9244: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
9245: FND_MSG_PUB.ADD;
9246: END IF;

Line 9245: FND_MSG_PUB.ADD;

9241: IF FND_GLOBAL.User_Id IS NULL THEN
9242: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9243: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
9244: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
9245: FND_MSG_PUB.ADD;
9246: END IF;
9247: RAISE FND_API.G_EXC_ERROR;
9248: END IF;
9249:

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

9261: Fetch C_Get_quote into l_LAST_UPDATE_DATE, l_qte_status_id,
9262: l_quote_number, l_hd_discount_percent,
9263: l_quote_header_id;
9264: If ( C_Get_quote%NOTFOUND) Then
9265: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9266: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_UPDATE_TARGET');
9267: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
9268: FND_MSG_PUB.Add;
9269: END IF;

Line 9268: FND_MSG_PUB.Add;

9264: If ( C_Get_quote%NOTFOUND) Then
9265: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9266: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_UPDATE_TARGET');
9267: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
9268: FND_MSG_PUB.Add;
9269: END IF;
9270: raise FND_API.G_EXC_ERROR;
9271: END IF; -- update header flag
9272: Close C_Get_quote;

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

9273:
9274:
9275: If (l_last_update_date is NULL or
9276: l_last_update_date = FND_API.G_MISS_Date ) Then
9277: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9278: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
9279: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
9280: FND_MSG_PUB.ADD;
9281: END IF;

Line 9280: FND_MSG_PUB.ADD;

9276: l_last_update_date = FND_API.G_MISS_Date ) Then
9277: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9278: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
9279: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
9280: FND_MSG_PUB.ADD;
9281: END IF;
9282: raise FND_API.G_EXC_ERROR;
9283: End if;
9284:

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

9284:
9285:
9286: -- Check Whether record has been changed by someone else
9287: If l_last_update_date <> p_control_rec.last_update_date Then
9288: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9289: FND_MESSAGE.Set_Name('ASO', 'API_RECORD_CHANGED');
9290: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
9291: FND_MSG_PUB.ADD;
9292: END IF;

Line 9291: FND_MSG_PUB.ADD;

9287: If l_last_update_date <> p_control_rec.last_update_date Then
9288: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9289: FND_MESSAGE.Set_Name('ASO', 'API_RECORD_CHANGED');
9290: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
9291: FND_MSG_PUB.ADD;
9292: END IF;
9293: raise FND_API.G_EXC_ERROR;
9294: End if;
9295:

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

9565: X_Msg_Count => x_msg_count,
9566: X_Msg_Data => x_msg_data);
9567:
9568: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9569: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9570: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
9571: FND_MESSAGE.Set_Token('OBJECT','LINE_RLTSHIP',FALSE);
9572: FND_MSG_PUB.ADD;
9573: END IF;

Line 9572: FND_MSG_PUB.ADD;

9568: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9569: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9570: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
9571: FND_MESSAGE.Set_Token('OBJECT','LINE_RLTSHIP',FALSE);
9572: FND_MSG_PUB.ADD;
9573: END IF;
9574: RAISE FND_API.G_EXC_ERROR;
9575: END IF;
9576:

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

9585: X_Msg_Count => x_msg_count,
9586: X_Msg_Data => x_msg_data);
9587:
9588: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9589: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9590: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
9591: FND_MESSAGE.Set_Token('OBJECT','PRICE_ADJ_RLTSHIP',FALSE);
9592: FND_MSG_PUB.ADD;
9593: END IF;

Line 9592: FND_MSG_PUB.ADD;

9588: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9589: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9590: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
9591: FND_MESSAGE.Set_Token('OBJECT','PRICE_ADJ_RLTSHIP',FALSE);
9592: FND_MSG_PUB.ADD;
9593: END IF;
9594: RAISE FND_API.G_EXC_ERROR;
9595: END IF;
9596:

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

9730: X_MSG_COUNT => x_msg_count,
9731: X_MSG_DATA => x_msg_data);
9732:
9733: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9734: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9735: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
9736: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);
9737: FND_MSG_PUB.ADD;
9738: END IF;

Line 9737: FND_MSG_PUB.ADD;

9733: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9734: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9735: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
9736: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);
9737: FND_MSG_PUB.ADD;
9738: END IF;
9739: RAISE FND_API.G_EXC_ERROR;
9740: END IF;
9741:

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

9816: p_line_inst_dtl_id => l_line_inst_dtl_id
9817: );
9818:
9819: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9820: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9821: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
9822: FND_MESSAGE.Set_Token('OBJECT', 'INSTALLATION DETAILS');
9823: FND_MSG_PUB.ADD;
9824: END IF;

Line 9823: FND_MSG_PUB.ADD;

9819: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9820: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9821: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
9822: FND_MESSAGE.Set_Token('OBJECT', 'INSTALLATION DETAILS');
9823: FND_MSG_PUB.ADD;
9824: END IF;
9825: RAISE FND_API.G_EXC_ERROR;
9826: END IF;
9827: END LOOP;

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

9835: X_Msg_Count => x_msg_count,
9836: X_Msg_Data => x_msg_data);
9837:
9838: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9839: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9840: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
9841: FND_MESSAGE.Set_Token('OBJECT', 'LINE_SHIPMENTS', FALSE);
9842: FND_MSG_PUB.ADD;
9843: END IF;

Line 9842: FND_MSG_PUB.ADD;

9838: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9839: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9840: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
9841: FND_MESSAGE.Set_Token('OBJECT', 'LINE_SHIPMENTS', FALSE);
9842: FND_MSG_PUB.ADD;
9843: END IF;
9844: RAISE FND_API.G_EXC_ERROR;
9845: END IF;
9846:

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

9886: X_Msg_Data => x_msg_data);
9887:
9888: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9889:
9890: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9891: FND_MESSAGE.Set_Name('ASO', 'ASO_UPDATE_QUOTE_TOTAL');
9892: FND_MSG_PUB.ADD;
9893: END IF;
9894:

Line 9892: FND_MSG_PUB.ADD;

9888: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9889:
9890: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9891: FND_MESSAGE.Set_Name('ASO', 'ASO_UPDATE_QUOTE_TOTAL');
9892: FND_MSG_PUB.ADD;
9893: END IF;
9894:
9895: END IF;
9896:

Line 9971: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

9967: COMMIT WORK;
9968: END IF;
9969:
9970: -- Standard call to get message count and if count is 1, get message info.
9971: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
9972: p_data => x_msg_data );
9973:
9974:
9975: EXCEPTION

Line 9981: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

9977: WHEN FND_API.G_EXC_ERROR THEN
9978: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9979: P_API_NAME => L_API_NAME
9980: ,P_PKG_NAME => G_PKG_NAME
9981: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
9982: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
9983: ,P_SQLCODE => SQLCODE
9984: ,P_SQLERRM => SQLERRM
9985: ,X_MSG_COUNT => X_MSG_COUNT

Line 9993: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

9989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9990: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9991: P_API_NAME => L_API_NAME
9992: ,P_PKG_NAME => G_PKG_NAME
9993: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9994: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
9995: ,P_SQLCODE => SQLCODE
9996: ,P_SQLERRM => SQLERRM
9997: ,X_MSG_COUNT => X_MSG_COUNT

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

10176: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10177: aso_debug_pub.add('Service_item_qty_update: Inside cursor C_quantity%NOTFOUND ', 1, 'N');
10178: end if;
10179: x_return_status := FND_API.G_RET_STS_ERROR;
10180: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10181: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SERVICE_REF_LINE');
10182: FND_MESSAGE.Set_Token('CODE', 'QUOTE', FALSE);
10183: FND_MESSAGE.Set_Token('VALUE', l_qte_line_detail_tbl(i).service_ref_line_id, FALSE);
10184: FND_MSG_PUB.ADD;

Line 10184: FND_MSG_PUB.ADD;

10180: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10181: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SERVICE_REF_LINE');
10182: FND_MESSAGE.Set_Token('CODE', 'QUOTE', FALSE);
10183: FND_MESSAGE.Set_Token('VALUE', l_qte_line_detail_tbl(i).service_ref_line_id, FALSE);
10184: FND_MSG_PUB.ADD;
10185: END IF;
10186: ELSE
10187: l_update_flag := FND_API.G_TRUE;
10188: END IF;

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

10197: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10198: aso_debug_pub.add('Service_item_qty_update: Inside cursor C_ord_qty%NOTFOUND condition.', 1, 'N');
10199: end if;
10200: x_return_status := FND_API.G_RET_STS_ERROR;
10201: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10202: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SERVICE_REF_LINE');
10203: FND_MESSAGE.Set_Token('CODE', 'ORDER', FALSE);
10204: FND_MESSAGE.Set_Token('VALUE', l_qte_line_detail_tbl(i).service_ref_line_id, FALSE);
10205: FND_MSG_PUB.ADD;

Line 10205: FND_MSG_PUB.ADD;

10201: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10202: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SERVICE_REF_LINE');
10203: FND_MESSAGE.Set_Token('CODE', 'ORDER', FALSE);
10204: FND_MESSAGE.Set_Token('VALUE', l_qte_line_detail_tbl(i).service_ref_line_id, FALSE);
10205: FND_MSG_PUB.ADD;
10206: END IF;
10207: ELSE
10208: l_update_flag := FND_API.G_TRUE;
10209: END IF;

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

10219: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10220: aso_debug_pub.add('Service_item_qty_update: Inside cursor C_cs_qty%NOTFOUND condition. ', 1, 'N');
10221: end if;
10222: x_return_status := FND_API.G_RET_STS_ERROR;
10223: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10224: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SERVICE_REF_LINE');
10225: FND_MESSAGE.Set_Token('CODE', 'CUSTOMER_PRODUCT', FALSE);
10226: FND_MESSAGE.Set_Token('VALUE', l_qte_line_detail_tbl(i).service_ref_line_id, FALSE);
10227: FND_MSG_PUB.ADD;

Line 10227: FND_MSG_PUB.ADD;

10223: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10224: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SERVICE_REF_LINE');
10225: FND_MESSAGE.Set_Token('CODE', 'CUSTOMER_PRODUCT', FALSE);
10226: FND_MESSAGE.Set_Token('VALUE', l_qte_line_detail_tbl(i).service_ref_line_id, FALSE);
10227: FND_MSG_PUB.ADD;
10228: END IF;
10229: ELSE
10230: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10231: aso_debug_pub.add('Service_item_qty_update: cursor C_cs_qty%FOUND ', 1, 'N ');