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 4956: FND_MSG_PUB.initialize;

4952:
4953:
4954: -- Initialize message list if p_init_msg_list is set to TRUE.
4955: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4956: FND_MSG_PUB.initialize;
4957: END IF;
4958:
4959:
4960: -- Initialize API return status to SUCCESS

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

4999: -- ******************************************************************
5000: -- Validate Environment
5001: -- ******************************************************************
5002: IF FND_GLOBAL.User_Id IS NULL THEN
5003: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5004: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
5005: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
5006: FND_MSG_PUB.ADD;
5007: END IF;

Line 5006: FND_MSG_PUB.ADD;

5002: IF FND_GLOBAL.User_Id IS NULL THEN
5003: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5004: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
5005: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
5006: FND_MSG_PUB.ADD;
5007: END IF;
5008: RAISE FND_API.G_EXC_ERROR;
5009: END IF;
5010:

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

5013: FETCH C_qln_exist into l_qln_exist;
5014:
5015: IF c_qln_exist%NOTFOUND OR l_qln_exist = FND_API.G_MISS_NUM THEN
5016:
5017: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5018: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_LINE');
5019: FND_MESSAGE.Set_Token ('VALUE', p_qte_line_rec.quote_line_id, FALSE);
5020: FND_MSG_PUB.ADD;
5021: END IF;

Line 5020: FND_MSG_PUB.ADD;

5016:
5017: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5018: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_LINE');
5019: FND_MESSAGE.Set_Token ('VALUE', p_qte_line_rec.quote_line_id, FALSE);
5020: FND_MSG_PUB.ADD;
5021: END IF;
5022: CLOSE C_qln_exist;
5023: raise FND_API.G_EXC_ERROR;
5024:

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

5037: aso_debug_pub.add('l_hd_discount_percent: '||nvl(to_char(l_hd_discount_percent),'null'),1,'N');
5038: end if;
5039:
5040: If ( C_Get_quote%NOTFOUND) Then
5041: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5042: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_UPDATE_TARGET');
5043: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
5044: FND_MSG_PUB.Add;
5045: END IF;

Line 5044: FND_MSG_PUB.Add;

5040: If ( C_Get_quote%NOTFOUND) Then
5041: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5042: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_UPDATE_TARGET');
5043: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
5044: FND_MSG_PUB.Add;
5045: END IF;
5046: Close C_Get_quote;
5047: raise FND_API.G_EXC_ERROR;
5048: END IF;

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

5053: end if;
5054:
5055: If (l_last_update_date is NULL or l_last_update_date = FND_API.G_MISS_Date ) Then
5056:
5057: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5058: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
5059: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
5060: FND_MSG_PUB.ADD;
5061: END IF;

Line 5060: FND_MSG_PUB.ADD;

5056:
5057: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5058: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
5059: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
5060: FND_MSG_PUB.ADD;
5061: END IF;
5062: raise FND_API.G_EXC_ERROR;
5063: End if;
5064:

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

5064:
5065: -- Check Whether record has been changed by someone else
5066: If (trunc(l_last_update_date) <> trunc(p_control_rec.last_update_date)) Then
5067:
5068: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5069: FND_MESSAGE.Set_Name('ASO', 'API_RECORD_CHANGED');
5070: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
5071: FND_MSG_PUB.ADD;
5072: END IF;

Line 5071: FND_MSG_PUB.ADD;

5067:
5068: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5069: FND_MESSAGE.Set_Name('ASO', 'API_RECORD_CHANGED');
5070: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
5071: FND_MSG_PUB.ADD;
5072: END IF;
5073: raise FND_API.G_EXC_ERROR;
5074: End if;
5075:

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

5319: End If;
5320:
5321: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5322:
5323: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5324: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_DEFAULTING');
5325: FND_MSG_PUB.ADD;
5326: END IF;
5327:

Line 5325: FND_MSG_PUB.ADD;

5321: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5322:
5323: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5324: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_DEFAULTING');
5325: FND_MSG_PUB.ADD;
5326: END IF;
5327:
5328: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5438: x_msg_data => x_msg_data);
5439:
5440: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5441:
5442: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5443: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
5444: FND_MESSAGE.Set_Token('COLUMN', 'Price List Expires Before Quote', FALSE);
5445: FND_MSG_PUB.ADD;
5446: END IF;

Line 5445: FND_MSG_PUB.ADD;

5441:
5442: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5443: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
5444: FND_MESSAGE.Set_Token('COLUMN', 'Price List Expires Before Quote', FALSE);
5445: FND_MSG_PUB.ADD;
5446: END IF;
5447:
5448: RAISE FND_API.G_EXC_ERROR;
5449: END IF;

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

5552: x_msg_data => x_msg_data);
5553:
5554: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5555:
5556: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5557: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_SALES_REP_ID');
5558: FND_MSG_PUB.ADD;
5559: END IF;
5560: RAISE FND_API.G_EXC_ERROR;

Line 5558: FND_MSG_PUB.ADD;

5554: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5555:
5556: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5557: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_SALES_REP_ID');
5558: FND_MSG_PUB.ADD;
5559: END IF;
5560: RAISE FND_API.G_EXC_ERROR;
5561: END IF;
5562:

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

5678: FETCH C_org_id into l_org_id;
5679:
5680: IF C_org_id%NOTFOUND 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_API_INVALID_ID');
5684: FND_MESSAGE.Set_Token('COLUMN', 'ORG_ID', 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_API_INVALID_ID');
5684: FND_MESSAGE.Set_Token('COLUMN', 'ORG_ID', FALSE);
5685: FND_MSG_PUB.ADD;
5686: END IF;
5687:
5688: END IF;
5689: CLOSE C_org_id;

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

5742: x_msg_data => x_msg_data);
5743:
5744: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5745:
5746: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5747: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
5748: FND_MESSAGE.Set_Token('INFO', 'END_DATE', FALSE);
5749: FND_MSG_PUB.ADD;
5750: END IF;

Line 5749: FND_MSG_PUB.ADD;

5745:
5746: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5747: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
5748: FND_MESSAGE.Set_Token('INFO', 'END_DATE', FALSE);
5749: FND_MSG_PUB.ADD;
5750: END IF;
5751: RAISE FND_API.G_EXC_ERROR;
5752: END IF;
5753:

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

5767: x_msg_data => x_msg_data);
5768:
5769: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5770:
5771: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5772: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
5773: FND_MESSAGE.Set_Token('INFO', 'RETURN', FALSE);
5774: FND_MSG_PUB.ADD;
5775: END IF;

Line 5774: FND_MSG_PUB.ADD;

5770:
5771: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5772: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
5773: FND_MESSAGE.Set_Token('INFO', 'RETURN', FALSE);
5774: FND_MSG_PUB.ADD;
5775: END IF;
5776: RAISE FND_API.G_EXC_ERROR;
5777: END IF;
5778:

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

5796: x_msg_data => x_msg_data);
5797:
5798: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5799:
5800: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5801: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
5802: FND_MESSAGE.Set_Token('INFO', 'TAX', FALSE);
5803: FND_MSG_PUB.ADD;
5804: END IF;

Line 5803: FND_MSG_PUB.ADD;

5799:
5800: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5801: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
5802: FND_MESSAGE.Set_Token('INFO', 'TAX', FALSE);
5803: FND_MSG_PUB.ADD;
5804: END IF;
5805: RAISE FND_API.G_EXC_ERROR;
5806: END IF;
5807:

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

5841: end if;
5842:
5843: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5844:
5845: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5846: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
5847: FND_MESSAGE.Set_Token('INFO', 'CONFIGURATION', FALSE);
5848: FND_MSG_PUB.ADD;
5849: END IF;

Line 5848: FND_MSG_PUB.ADD;

5844:
5845: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5846: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
5847: FND_MESSAGE.Set_Token('INFO', 'CONFIGURATION', FALSE);
5848: FND_MSG_PUB.ADD;
5849: END IF;
5850: RAISE FND_API.G_EXC_ERROR;
5851: END IF;
5852: END IF;

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

5870: x_msg_data => x_msg_data);
5871:
5872: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5873:
5874: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5875: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
5876: FND_MESSAGE.Set_Token('INFO', 'DELAYED SERVICE', FALSE);
5877: FND_MSG_PUB.ADD;
5878: END IF;

Line 5877: FND_MSG_PUB.ADD;

5873:
5874: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5875: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
5876: FND_MESSAGE.Set_Token('INFO', 'DELAYED SERVICE', FALSE);
5877: FND_MSG_PUB.ADD;
5878: END IF;
5879: RAISE FND_API.G_EXC_ERROR;
5880: END IF;
5881:

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

5897: x_return_status => x_return_status,
5898: x_msg_count => x_msg_count,
5899: x_msg_data => x_msg_data);
5900: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5901: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5902: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
5903: FND_MESSAGE.Set_Token('INFO', 'PARTY OBJECT ID', FALSE);
5904: FND_MSG_PUB.ADD;
5905: END IF;

Line 5904: FND_MSG_PUB.ADD;

5900: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5901: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5902: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
5903: FND_MESSAGE.Set_Token('INFO', 'PARTY OBJECT ID', FALSE);
5904: FND_MSG_PUB.ADD;
5905: END IF;
5906: RAISE FND_API.G_EXC_ERROR;
5907: END IF;
5908: END LOOP;

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

5955: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5956: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_Line: after Validate_ship_from_org_ID: <> SUCCESS', 1, 'Y');
5957: end if;
5958:
5959: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5960: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SHIP_FROM_ORG_ID');
5961: FND_MESSAGE.Set_Token('SHIP_FROM_ORG_ID', lx_ln_shipment_tbl(1).ship_from_org_id, FALSE);
5962: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', lx_qte_line_rec.inventory_item_id, FALSE);
5963: FND_MSG_PUB.ADD;

Line 5963: FND_MSG_PUB.ADD;

5959: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5960: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SHIP_FROM_ORG_ID');
5961: FND_MESSAGE.Set_Token('SHIP_FROM_ORG_ID', lx_ln_shipment_tbl(1).ship_from_org_id, FALSE);
5962: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', lx_qte_line_rec.inventory_item_id, FALSE);
5963: FND_MSG_PUB.ADD;
5964: END IF;
5965:
5966: RAISE FND_API.G_EXC_ERROR;
5967:

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

6002: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6003: aso_debug_pub.add('Update_Quote_Line: after Validate_ship_from_org_ID: <> SUCCESS (no lx_ln_shipment_tbl)', 1, 'Y');
6004: end if;
6005:
6006: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6007: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SHIP_FROM_ORG_ID');
6008: FND_MESSAGE.Set_Token('SHIP_FROM_ORG_ID', l_db_shipment_rec.ship_from_org_id, FALSE);
6009: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', lx_qte_line_rec.inventory_item_id, FALSE);
6010: FND_MSG_PUB.ADD;

Line 6010: FND_MSG_PUB.ADD;

6006: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6007: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SHIP_FROM_ORG_ID');
6008: FND_MESSAGE.Set_Token('SHIP_FROM_ORG_ID', l_db_shipment_rec.ship_from_org_id, FALSE);
6009: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', lx_qte_line_rec.inventory_item_id, FALSE);
6010: FND_MSG_PUB.ADD;
6011: END IF;
6012:
6013: RAISE FND_API.G_EXC_ERROR;
6014: END IF;

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

6050: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6051: aso_debug_pub.add('after Validate_ship_from_org_ID: <> SUCCESS (no db_shipment_tbl)', 1, 'Y');
6052: end if;
6053:
6054: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6055: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SHIP_FROM_ORG_ID');
6056: FND_MESSAGE.Set_Token('SHIP_FROM_ORG_ID', l_hd_shipment_rec.ship_from_org_id, FALSE);
6057: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', lx_qte_line_rec.inventory_item_id, FALSE);
6058: FND_MSG_PUB.ADD;

Line 6058: FND_MSG_PUB.ADD;

6054: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6055: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SHIP_FROM_ORG_ID');
6056: FND_MESSAGE.Set_Token('SHIP_FROM_ORG_ID', l_hd_shipment_rec.ship_from_org_id, FALSE);
6057: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', lx_qte_line_rec.inventory_item_id, FALSE);
6058: FND_MSG_PUB.ADD;
6059: END IF;
6060:
6061: RAISE FND_API.G_EXC_ERROR;
6062: END IF;

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

6093: IF ( C_inst_details%FOUND) AND l_quantity > lx_ln_shipment_tbl(i).quantity Then
6094:
6095: Close C_inst_details;
6096:
6097: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6098: FND_MESSAGE.Set_Name('ASO', 'INST_DETAILS_EXIST');
6099: FND_MSG_PUB.ADD;
6100: END IF;
6101: raise FND_API.G_EXC_ERROR;

Line 6099: FND_MSG_PUB.ADD;

6095: Close C_inst_details;
6096:
6097: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6098: FND_MESSAGE.Set_Name('ASO', 'INST_DETAILS_EXIST');
6099: FND_MSG_PUB.ADD;
6100: END IF;
6101: raise FND_API.G_EXC_ERROR;
6102:
6103: ELSE

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

6113: if (c_csi_details%found) and (l_quantity > lx_ln_shipment_tbl(i).quantity) then
6114:
6115: close c_csi_details;
6116:
6117: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6118: FND_MESSAGE.Set_Name('ASO', 'INST_DETAILS_EXIST');
6119: FND_MSG_PUB.ADD;
6120: END IF;
6121: raise FND_API.G_EXC_ERROR;

Line 6119: FND_MSG_PUB.ADD;

6115: close c_csi_details;
6116:
6117: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6118: FND_MESSAGE.Set_Name('ASO', 'INST_DETAILS_EXIST');
6119: FND_MSG_PUB.ADD;
6120: END IF;
6121: raise FND_API.G_EXC_ERROR;
6122:
6123: else

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

6144: aso_debug_pub.add('Update_Quote_Line - Invalid Quantity for EDU: ',1, 'N');
6145: end if;
6146:
6147: x_return_status := FND_API.G_RET_STS_ERROR;
6148: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6149: FND_MESSAGE.Set_Name('ASO', 'ASO_EDU_INVALID_QTY');
6150: FND_MSG_PUB.ADD;
6151: END IF;
6152: RAISE FND_API.G_EXC_ERROR;

Line 6150: FND_MSG_PUB.ADD;

6146:
6147: x_return_status := FND_API.G_RET_STS_ERROR;
6148: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6149: FND_MESSAGE.Set_Name('ASO', 'ASO_EDU_INVALID_QTY');
6150: FND_MSG_PUB.ADD;
6151: END IF;
6152: RAISE FND_API.G_EXC_ERROR;
6153:
6154: END IF;

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

6194: end if;
6195:
6196: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6197:
6198: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6199: FND_MESSAGE.Set_Name('ASO', 'ASO_POPULATING_COLUMNS');
6200: FND_MESSAGE.Set_Token('LINE' , x_qte_line_rec.line_number, FALSE);
6201: FND_MSG_PUB.ADD;
6202: END IF;

Line 6201: FND_MSG_PUB.ADD;

6197:
6198: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6199: FND_MESSAGE.Set_Name('ASO', 'ASO_POPULATING_COLUMNS');
6200: FND_MESSAGE.Set_Token('LINE' , x_qte_line_rec.line_number, FALSE);
6201: FND_MSG_PUB.ADD;
6202: END IF;
6203:
6204: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6349: end if;
6350:
6351: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
6352:
6353: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6354: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
6355: FND_MESSAGE.Set_Token('INFO','SERVICE', FALSE);
6356: FND_MSG_PUB.ADD;
6357: END IF;

Line 6356: FND_MSG_PUB.ADD;

6352:
6353: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6354: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
6355: FND_MESSAGE.Set_Token('INFO','SERVICE', FALSE);
6356: FND_MSG_PUB.ADD;
6357: END IF;
6358:
6359: RAISE FND_API.G_EXC_ERROR;
6360:

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

6391: IF C_line_category_code%FOUND AND l_line_category_code = 'RETURN' THEN
6392:
6393: CLOSE C_line_category_code;
6394:
6395: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6396: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SERVICE_REFERENCE');
6397: FND_MSG_PUB.ADD;
6398: END IF;
6399:

Line 6397: FND_MSG_PUB.ADD;

6393: CLOSE C_line_category_code;
6394:
6395: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6396: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SERVICE_REFERENCE');
6397: FND_MSG_PUB.ADD;
6398: END IF;
6399:
6400: RAISE FND_API.G_EXC_ERROR;
6401:

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

6432: if l_service_ref_type_code is null then
6433:
6434: x_return_status := fnd_api.g_ret_sts_error;
6435:
6436: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6437: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
6438: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_REF_TYPE_CODE', FALSE);
6439: FND_MESSAGE.Set_Token('VALUE', l_qte_line_dtl_tbl(i).service_ref_type_code,FALSE);
6440: FND_MSG_PUB.ADD;

Line 6440: FND_MSG_PUB.ADD;

6436: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6437: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
6438: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_REF_TYPE_CODE', FALSE);
6439: FND_MESSAGE.Set_Token('VALUE', l_qte_line_dtl_tbl(i).service_ref_type_code,FALSE);
6440: FND_MSG_PUB.ADD;
6441: END IF;
6442:
6443: raise fnd_api.g_exc_error;
6444:

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

6490: IF c_service_exist%FOUND THEN
6491:
6492: CLOSE c_service_exist;
6493:
6494: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6495: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_LINE_CATEGORY');
6496: FND_MSG_PUB.ADD;
6497: END IF;
6498:

Line 6496: FND_MSG_PUB.ADD;

6492: CLOSE c_service_exist;
6493:
6494: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6495: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_LINE_CATEGORY');
6496: FND_MSG_PUB.ADD;
6497: END IF;
6498:
6499: RAISE FND_API.G_EXC_ERROR;
6500:

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

7911: CLOSE C_ship_partial;
7912:
7913: IF l_ship_count = 1 THEN
7914: x_return_status := FND_API.G_RET_STS_ERROR;
7915: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7916: FND_MESSAGE.Set_Name('ASO', 'DELETE_SHIPMENT');
7917: FND_MESSAGE.Set_Token('COLUMN', 'SHIPMENT_ID', FALSE);
7918: FND_MSG_PUB.ADD;
7919: END IF;

Line 7918: FND_MSG_PUB.ADD;

7914: x_return_status := FND_API.G_RET_STS_ERROR;
7915: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7916: FND_MESSAGE.Set_Name('ASO', 'DELETE_SHIPMENT');
7917: FND_MESSAGE.Set_Token('COLUMN', 'SHIPMENT_ID', FALSE);
7918: FND_MSG_PUB.ADD;
7919: END IF;
7920: END IF;
7921:
7922:

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

8932: ,x_msg_data => l_msg_data
8933: ,x_site_use_id => l_invoice_org_id
8934: );
8935: IF L_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
8936: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
8937: THEN
8938: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
8939: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_TO_SITE_USE_ID',FALSE);
8940: FND_MSG_PUB.ADD;

Line 8940: FND_MSG_PUB.ADD;

8936: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
8937: THEN
8938: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
8939: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_TO_SITE_USE_ID',FALSE);
8940: FND_MSG_PUB.ADD;
8941: END IF;
8942: -- raise FND_API.G_EXC_ERROR;
8943: END IF;
8944: END IF;

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

8963: ,x_site_use_id => l_ship_org_id
8964: );
8965:
8966: IF L_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
8967: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
8968: THEN
8969: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
8970: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_TO_SITE_USE_ID',FALSE);
8971: FND_MSG_PUB.ADD;

Line 8971: FND_MSG_PUB.ADD;

8967: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
8968: THEN
8969: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
8970: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_TO_SITE_USE_ID',FALSE);
8971: FND_MSG_PUB.ADD;
8972: END IF;
8973: -- raise FND_API.G_EXC_ERROR;
8974: END IF;
8975:

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

8988: x_tax_detail_tbl(i) := l_tax_detail_tbl(1);
8989: end if;
8990:
8991: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8992: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8993: FND_MESSAGE.Set_Name('ASO', 'ASO_TAX_CALCULATION');
8994: FND_MSG_PUB.ADD;
8995: END IF;
8996: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 8994: FND_MSG_PUB.ADD;

8990:
8991: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8992: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8993: FND_MESSAGE.Set_Name('ASO', 'ASO_TAX_CALCULATION');
8994: FND_MSG_PUB.ADD;
8995: END IF;
8996: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
8997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8998: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

9037: last_update_login = fnd_global.conc_login_id
9038: WHERE shipment_id = l_shipment_tbl(i).shipment_id;
9039:
9040: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9041: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9042: FND_MESSAGE.Set_Name('ASO', 'ASO_CREATING_RESERVATION');
9043: FND_MSG_PUB.ADD;
9044: END IF;
9045: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 9043: FND_MSG_PUB.ADD;

9039:
9040: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9041: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9042: FND_MESSAGE.Set_Name('ASO', 'ASO_CREATING_RESERVATION');
9043: FND_MSG_PUB.ADD;
9044: END IF;
9045: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
9046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9047: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

9077: X_Msg_Count => x_msg_count,
9078: X_Msg_Data => x_msg_data);
9079:
9080: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9081: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9082: FND_MESSAGE.Set_Name('ASO', 'ASO_UPDATE_QUOTE_TOTAL');
9083: -- FND_MESSAGE.Set_Token('LINE' , x_qte_line_rec.line_number, FALSE);
9084: FND_MSG_PUB.ADD;
9085: END IF;

Line 9084: FND_MSG_PUB.ADD;

9080: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9081: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9082: FND_MESSAGE.Set_Name('ASO', 'ASO_UPDATE_QUOTE_TOTAL');
9083: -- FND_MESSAGE.Set_Token('LINE' , x_qte_line_rec.line_number, FALSE);
9084: FND_MSG_PUB.ADD;
9085: END IF;
9086: END IF;
9087:
9088: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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

9086: END IF;
9087:
9088: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
9089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9090: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Private API: '|| l_api_name || 'error in updating header');
9091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9092: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
9093: x_return_status := FND_API.G_RET_STS_ERROR;
9094: END IF;

Line 9127: FND_MSG_PUB.Count_And_Get

9123:
9124:
9125:
9126: -- Standard call to get message count and if count is 1, get message info.
9127: FND_MSG_PUB.Count_And_Get
9128: ( p_count => x_msg_count,
9129: p_data => x_msg_data
9130: );
9131:

Line 9137: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

9133: WHEN FND_API.G_EXC_ERROR THEN
9134: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9135: P_API_NAME => L_API_NAME
9136: ,P_PKG_NAME => G_PKG_NAME
9137: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
9138: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
9139: ,P_SQLCODE => SQLCODE
9140: ,P_SQLERRM => SQLERRM
9141: ,X_MSG_COUNT => X_MSG_COUNT

Line 9149: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

9145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9146: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9147: P_API_NAME => L_API_NAME
9148: ,P_PKG_NAME => G_PKG_NAME
9149: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9150: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
9151: ,P_SQLCODE => SQLCODE
9152: ,P_SQLERRM => SQLERRM
9153: ,X_MSG_COUNT => X_MSG_COUNT

Line 9346: FND_MSG_PUB.initialize;

9342:
9343:
9344: -- Initialize message list if p_init_msg_list is set to TRUE.
9345: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9346: FND_MSG_PUB.initialize;
9347: END IF;
9348:
9349:
9350: -- Initialize API return status to SUCCESS

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

9356: -- ******************************************************************
9357: -- Validate Environment
9358: -- ******************************************************************
9359: IF FND_GLOBAL.User_Id IS NULL THEN
9360: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9361: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
9362: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
9363: FND_MSG_PUB.ADD;
9364: END IF;

Line 9363: FND_MSG_PUB.ADD;

9359: IF FND_GLOBAL.User_Id IS NULL THEN
9360: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9361: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
9362: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
9363: FND_MSG_PUB.ADD;
9364: END IF;
9365: RAISE FND_API.G_EXC_ERROR;
9366: END IF;
9367:

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

9379: Fetch C_Get_quote into l_LAST_UPDATE_DATE, l_qte_status_id,
9380: l_quote_number, l_hd_discount_percent,
9381: l_quote_header_id;
9382: If ( C_Get_quote%NOTFOUND) Then
9383: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9384: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_UPDATE_TARGET');
9385: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
9386: FND_MSG_PUB.Add;
9387: END IF;

Line 9386: FND_MSG_PUB.Add;

9382: If ( C_Get_quote%NOTFOUND) Then
9383: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9384: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_UPDATE_TARGET');
9385: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
9386: FND_MSG_PUB.Add;
9387: END IF;
9388: raise FND_API.G_EXC_ERROR;
9389: END IF; -- update header flag
9390: Close C_Get_quote;

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

9391:
9392:
9393: If (l_last_update_date is NULL or
9394: l_last_update_date = FND_API.G_MISS_Date ) Then
9395: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9396: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
9397: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
9398: FND_MSG_PUB.ADD;
9399: END IF;

Line 9398: FND_MSG_PUB.ADD;

9394: l_last_update_date = FND_API.G_MISS_Date ) Then
9395: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9396: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
9397: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
9398: FND_MSG_PUB.ADD;
9399: END IF;
9400: raise FND_API.G_EXC_ERROR;
9401: End if;
9402:

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

9402:
9403:
9404: -- Check Whether record has been changed by someone else
9405: If l_last_update_date <> p_control_rec.last_update_date Then
9406: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9407: FND_MESSAGE.Set_Name('ASO', 'API_RECORD_CHANGED');
9408: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
9409: FND_MSG_PUB.ADD;
9410: END IF;

Line 9409: FND_MSG_PUB.ADD;

9405: If l_last_update_date <> p_control_rec.last_update_date Then
9406: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9407: FND_MESSAGE.Set_Name('ASO', 'API_RECORD_CHANGED');
9408: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
9409: FND_MSG_PUB.ADD;
9410: END IF;
9411: raise FND_API.G_EXC_ERROR;
9412: End if;
9413:

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

9683: X_Msg_Count => x_msg_count,
9684: X_Msg_Data => x_msg_data);
9685:
9686: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9687: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9688: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
9689: FND_MESSAGE.Set_Token('OBJECT','LINE_RLTSHIP',FALSE);
9690: FND_MSG_PUB.ADD;
9691: END IF;

Line 9690: FND_MSG_PUB.ADD;

9686: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9687: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9688: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
9689: FND_MESSAGE.Set_Token('OBJECT','LINE_RLTSHIP',FALSE);
9690: FND_MSG_PUB.ADD;
9691: END IF;
9692: RAISE FND_API.G_EXC_ERROR;
9693: END IF;
9694:

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

9703: X_Msg_Count => x_msg_count,
9704: X_Msg_Data => x_msg_data);
9705:
9706: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9707: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9708: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
9709: FND_MESSAGE.Set_Token('OBJECT','PRICE_ADJ_RLTSHIP',FALSE);
9710: FND_MSG_PUB.ADD;
9711: END IF;

Line 9710: FND_MSG_PUB.ADD;

9706: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9707: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9708: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
9709: FND_MESSAGE.Set_Token('OBJECT','PRICE_ADJ_RLTSHIP',FALSE);
9710: FND_MSG_PUB.ADD;
9711: END IF;
9712: RAISE FND_API.G_EXC_ERROR;
9713: END IF;
9714:

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

9848: X_MSG_COUNT => x_msg_count,
9849: X_MSG_DATA => x_msg_data);
9850:
9851: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9852: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9853: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
9854: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);
9855: FND_MSG_PUB.ADD;
9856: END IF;

Line 9855: FND_MSG_PUB.ADD;

9851: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9852: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9853: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
9854: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);
9855: FND_MSG_PUB.ADD;
9856: END IF;
9857: RAISE FND_API.G_EXC_ERROR;
9858: END IF;
9859:

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

9934: p_line_inst_dtl_id => l_line_inst_dtl_id
9935: );
9936:
9937: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9938: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9939: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
9940: FND_MESSAGE.Set_Token('OBJECT', 'INSTALLATION DETAILS');
9941: FND_MSG_PUB.ADD;
9942: END IF;

Line 9941: FND_MSG_PUB.ADD;

9937: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9938: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9939: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
9940: FND_MESSAGE.Set_Token('OBJECT', 'INSTALLATION DETAILS');
9941: FND_MSG_PUB.ADD;
9942: END IF;
9943: RAISE FND_API.G_EXC_ERROR;
9944: END IF;
9945: END LOOP;

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

9953: X_Msg_Count => x_msg_count,
9954: X_Msg_Data => x_msg_data);
9955:
9956: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9957: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9958: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
9959: FND_MESSAGE.Set_Token('OBJECT', 'LINE_SHIPMENTS', FALSE);
9960: FND_MSG_PUB.ADD;
9961: END IF;

Line 9960: FND_MSG_PUB.ADD;

9956: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9957: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9958: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
9959: FND_MESSAGE.Set_Token('OBJECT', 'LINE_SHIPMENTS', FALSE);
9960: FND_MSG_PUB.ADD;
9961: END IF;
9962: RAISE FND_API.G_EXC_ERROR;
9963: END IF;
9964:

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

10004: X_Msg_Data => x_msg_data);
10005:
10006: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
10007:
10008: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10009: FND_MESSAGE.Set_Name('ASO', 'ASO_UPDATE_QUOTE_TOTAL');
10010: FND_MSG_PUB.ADD;
10011: END IF;
10012:

Line 10010: FND_MSG_PUB.ADD;

10006: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
10007:
10008: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10009: FND_MESSAGE.Set_Name('ASO', 'ASO_UPDATE_QUOTE_TOTAL');
10010: FND_MSG_PUB.ADD;
10011: END IF;
10012:
10013: END IF;
10014:

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

10085: COMMIT WORK;
10086: END IF;
10087:
10088: -- Standard call to get message count and if count is 1, get message info.
10089: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
10090: p_data => x_msg_data );
10091:
10092:
10093: EXCEPTION

Line 10099: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

10095: WHEN FND_API.G_EXC_ERROR THEN
10096: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10097: P_API_NAME => L_API_NAME
10098: ,P_PKG_NAME => G_PKG_NAME
10099: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
10100: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
10101: ,P_SQLCODE => SQLCODE
10102: ,P_SQLERRM => SQLERRM
10103: ,X_MSG_COUNT => X_MSG_COUNT

Line 10111: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

10107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10108: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10109: P_API_NAME => L_API_NAME
10110: ,P_PKG_NAME => G_PKG_NAME
10111: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10112: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
10113: ,P_SQLCODE => SQLCODE
10114: ,P_SQLERRM => SQLERRM
10115: ,X_MSG_COUNT => X_MSG_COUNT

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

10294: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10295: aso_debug_pub.add('Service_item_qty_update: Inside cursor C_quantity%NOTFOUND ', 1, 'N');
10296: end if;
10297: x_return_status := FND_API.G_RET_STS_ERROR;
10298: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10299: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SERVICE_REF_LINE');
10300: FND_MESSAGE.Set_Token('CODE', 'QUOTE', FALSE);
10301: FND_MESSAGE.Set_Token('VALUE', l_qte_line_detail_tbl(i).service_ref_line_id, FALSE);
10302: FND_MSG_PUB.ADD;

Line 10302: FND_MSG_PUB.ADD;

10298: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10299: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SERVICE_REF_LINE');
10300: FND_MESSAGE.Set_Token('CODE', 'QUOTE', FALSE);
10301: FND_MESSAGE.Set_Token('VALUE', l_qte_line_detail_tbl(i).service_ref_line_id, FALSE);
10302: FND_MSG_PUB.ADD;
10303: END IF;
10304: ELSE
10305: l_update_flag := FND_API.G_TRUE;
10306: END IF;

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

10315: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10316: aso_debug_pub.add('Service_item_qty_update: Inside cursor C_ord_qty%NOTFOUND condition.', 1, 'N');
10317: end if;
10318: x_return_status := FND_API.G_RET_STS_ERROR;
10319: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10320: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SERVICE_REF_LINE');
10321: FND_MESSAGE.Set_Token('CODE', 'ORDER', FALSE);
10322: FND_MESSAGE.Set_Token('VALUE', l_qte_line_detail_tbl(i).service_ref_line_id, FALSE);
10323: FND_MSG_PUB.ADD;

Line 10323: FND_MSG_PUB.ADD;

10319: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10320: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SERVICE_REF_LINE');
10321: FND_MESSAGE.Set_Token('CODE', 'ORDER', FALSE);
10322: FND_MESSAGE.Set_Token('VALUE', l_qte_line_detail_tbl(i).service_ref_line_id, FALSE);
10323: FND_MSG_PUB.ADD;
10324: END IF;
10325: ELSE
10326: l_update_flag := FND_API.G_TRUE;
10327: END IF;

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

10337: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10338: aso_debug_pub.add('Service_item_qty_update: Inside cursor C_cs_qty%NOTFOUND condition. ', 1, 'N');
10339: end if;
10340: x_return_status := FND_API.G_RET_STS_ERROR;
10341: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10342: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SERVICE_REF_LINE');
10343: FND_MESSAGE.Set_Token('CODE', 'CUSTOMER_PRODUCT', FALSE);
10344: FND_MESSAGE.Set_Token('VALUE', l_qte_line_detail_tbl(i).service_ref_line_id, FALSE);
10345: FND_MSG_PUB.ADD;

Line 10345: FND_MSG_PUB.ADD;

10341: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10342: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SERVICE_REF_LINE');
10343: FND_MESSAGE.Set_Token('CODE', 'CUSTOMER_PRODUCT', FALSE);
10344: FND_MESSAGE.Set_Token('VALUE', l_qte_line_detail_tbl(i).service_ref_line_id, FALSE);
10345: FND_MSG_PUB.ADD;
10346: END IF;
10347: ELSE
10348: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10349: aso_debug_pub.add('Service_item_qty_update: cursor C_cs_qty%FOUND ', 1, 'N ');

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

10362: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10363: aso_debug_pub.add('Service_item_qty_update: Inside cursor C_quantity%NOTFOUND ', 1, 'N');
10364: end if;
10365: x_return_status := FND_API.G_RET_STS_ERROR;
10366: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10367: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SERVICE_REF_LINE');
10368: FND_MESSAGE.Set_Token('CODE', 'PRODUCT_CATALOG', FALSE);
10369: FND_MESSAGE.Set_Token('VALUE', l_qte_line_detail_tbl(i).service_ref_line_id, FALSE);
10370: FND_MSG_PUB.ADD;

Line 10370: FND_MSG_PUB.ADD;

10366: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10367: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SERVICE_REF_LINE');
10368: FND_MESSAGE.Set_Token('CODE', 'PRODUCT_CATALOG', FALSE);
10369: FND_MESSAGE.Set_Token('VALUE', l_qte_line_detail_tbl(i).service_ref_line_id, FALSE);
10370: FND_MSG_PUB.ADD;
10371: END IF;
10372: ELSE
10373: l_update_flag := FND_API.G_TRUE;
10374: END IF;