DBA Data[Home] [Help]

APPS.ASO_QUOTE_LINES_PVT dependencies on FND_MESSAGE

Line 1367: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_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;
1371:

Line 1368: FND_MESSAGE.Set_Token('COLUMN', 'ORG_ID', FALSE);

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;
1371:
1372: END IF;

Line 1387: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_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;
1391:

Line 1388: FND_MESSAGE.Set_Token('COLUMN', 'ORGANIZATION_ID', FALSE);

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;
1391:
1392: END IF;

Line 1414: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');

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;
1418:

Line 1415: FND_MESSAGE.Set_Token('COLUMN', 'ITEM TYPE CODE', FALSE);

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;
1418:
1419: END IF;

Line 1474: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_SHIPMENTS');

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;
1478: END IF;

Line 1491: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_SHIPMENTS');

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;
1495:

Line 1511: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');

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;
1515: raise FND_API.G_EXC_ERROR;

Line 1512: FND_MESSAGE.Set_Token('COLUMN','ITEM RELATED', FALSE);

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;
1515: raise FND_API.G_EXC_ERROR;
1516:

Line 1577: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');

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;
1581: RAISE FND_API.G_EXC_ERROR;

Line 1578: FND_MESSAGE.Set_Token('COLUMN', 'START_DATE_ACTIVE', FALSE);

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;
1581: RAISE FND_API.G_EXC_ERROR;
1582:

Line 1593: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');

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;
1597: END IF;

Line 1594: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_INFO', FALSE);

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;
1597: END IF;
1598:

Line 1648: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO5');

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;
1652: END IF;

Line 1726: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO5');

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:
1730: RAISE FND_API.G_EXC_ERROR;

Line 2008: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');

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);
2011: FND_MSG_PUB.ADD;
2012: END IF;

Line 2009: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_ID', FALSE);

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);
2011: FND_MSG_PUB.ADD;
2012: END IF;
2013:

Line 2010: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(l_qte_line_rec.quote_header_id), FALSE);

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);
2011: FND_MSG_PUB.ADD;
2012: END IF;
2013:
2014: END IF;

Line 2041: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SHIPMENT');

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:
2045: END IF;

Line 2042: FND_MESSAGE.Set_Token('LINE', to_char(p_qte_line_rec.quote_line_id), FALSE);

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:
2045: END IF;
2046:

Line 2067: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_SHIPMENTS');

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;
2071:

Line 2102: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_SHIPMENT');

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;
2106: END IF;

Line 2123: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');

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;
2127:

Line 2124: FND_MESSAGE.Set_Token ('INFO', 'ITEM RELATED', FALSE);

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;
2127:
2128: close c_item1;

Line 2152: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');

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;
2156:

Line 2153: FND_MESSAGE.Set_Token('COLUMN', 'START_DATE_ACTIVE', FALSE);

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;
2156:
2157: RAISE FND_API.G_EXC_ERROR;

Line 2193: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');

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;
2197:

Line 2194: FND_MESSAGE.Set_Token('INFO', 'SERVICE RELATED', FALSE);

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;
2197:
2198: RAISE FND_API.G_EXC_ERROR;

Line 2267: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO5');

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:
2271: RAISE FND_API.G_EXC_ERROR;

Line 2808: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');

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;
2812: RAISE FND_API.G_EXC_ERROR;

Line 2809: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

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;
2812: RAISE FND_API.G_EXC_ERROR;
2813: END IF;

Line 2834: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_UPDATE_TARGET');

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;
2838: raise FND_API.G_EXC_ERROR;

Line 2835: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);

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;
2838: raise FND_API.G_EXC_ERROR;
2839: END IF;

Line 2848: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');

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;
2852: raise FND_API.G_EXC_ERROR;

Line 2849: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

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;
2852: raise FND_API.G_EXC_ERROR;
2853: End if;

Line 2859: FND_MESSAGE.Set_Name('ASO', 'API_RECORD_CHANGED');

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;
2863: raise FND_API.G_EXC_ERROR;

Line 2860: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);

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;
2863: raise FND_API.G_EXC_ERROR;
2864: End if;

Line 2939: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');

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;
2943:

Line 2940: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);

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;
2943:
2944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3065: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_DEFAULTING');

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:
3069: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3218: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_SALES_REP_ID');

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;
3222:

Line 3341: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_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;
3345: END IF;

Line 3342: FND_MESSAGE.Set_Token('COLUMN', 'ORG_ID', FALSE);

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;
3345: END IF;
3346: CLOSE C_org_id;

Line 3388: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_END_DATE');

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;
3392: END IF;

Line 3406: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');

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;
3410: RAISE FND_API.G_EXC_ERROR;

Line 3407: FND_MESSAGE.Set_Token('INFO', 'RETURN', FALSE);

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;
3410: RAISE FND_API.G_EXC_ERROR;
3411: END IF;

Line 3426: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');

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;
3430: RAISE FND_API.G_EXC_ERROR;

Line 3427: FND_MESSAGE.Set_Token('INFO', 'TAX', FALSE);

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;
3430: RAISE FND_API.G_EXC_ERROR;
3431: END IF;

Line 3483: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');

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;
3487: RAISE FND_API.G_EXC_ERROR;

Line 3484: FND_MESSAGE.Set_Token('INFO', 'DELAYED_SERVICE', FALSE);

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;
3487: RAISE FND_API.G_EXC_ERROR;
3488: END IF;

Line 3504: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');

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;
3508: RAISE FND_API.G_EXC_ERROR;

Line 3505: FND_MESSAGE.Set_Token('INFO', 'PARTY OBJECT ID', FALSE);

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;
3508: RAISE FND_API.G_EXC_ERROR;
3509: END IF;

Line 3545: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SHIP_FROM_ORG_ID');

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;
3549: END IF;

Line 3546: FND_MESSAGE.Set_Token('SHIP_FROM_ORG_ID', lx_ln_shipment_tbl(1).ship_from_org_id, FALSE);

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;
3549: END IF;
3550:

Line 3547: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', lx_qte_line_rec.inventory_item_id, FALSE);

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;
3549: END IF;
3550:
3551: RAISE FND_API.G_EXC_ERROR;

Line 3593: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SHIP_FROM_ORG_ID');

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;
3597: END IF;

Line 3594: FND_MESSAGE.Set_Token('SHIP_FROM_ORG_ID', l_hd_shipment_rec.ship_from_org_id, FALSE);

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;
3597: END IF;
3598:

Line 3595: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', lx_qte_line_rec.inventory_item_id, FALSE);

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;
3597: END IF;
3598:
3599: RAISE FND_API.G_EXC_ERROR;

Line 3656: FND_MESSAGE.Set_Name('ASO', 'ASO_POPULATING_COLUMNS');

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;
3660:

Line 3657: FND_MESSAGE.Set_Token('LINE' , x_qte_line_rec.line_number, FALSE);

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;
3660:
3661: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3696: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_CFG_UI');

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:
3700: RAISE FND_API.G_EXC_ERROR;

Line 3778: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');

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;
3782:

Line 3779: FND_MESSAGE.Set_Token('INFO','SERVICE', FALSE);

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;
3782:
3783: RAISE FND_API.G_EXC_ERROR;

Line 3818: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SERVICE_REFERENCE');

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:
3822: RAISE FND_API.G_EXC_ERROR;

Line 3842: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');

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;
3846: END IF;

Line 3843: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_REF_TYPE_CODE', FALSE);

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;
3846: END IF;
3847:

Line 3844: FND_MESSAGE.Set_Token('VALUE', p_qte_line_dtl_tbl(i).service_ref_type_code,FALSE);

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;
3846: END IF;
3847:
3848: raise fnd_api.g_exc_error;

Line 3892: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');

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:
3896: RAISE FND_API.G_EXC_ERROR;

Line 4055: FND_MESSAGE.Set_Name('ASO', 'ASO_EDU_INVALID_QTY');

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;
4059: END IF;

Line 4142: FND_MESSAGE.Set_Name('ASO', 'ASO_INSERT_ERROR');

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
4146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4327: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');

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;
4330: END IF;
4331: -- raise FND_API.G_EXC_ERROR;

Line 4328: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_TO_SITE_USE_ID',FALSE);

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;
4330: END IF;
4331: -- raise FND_API.G_EXC_ERROR;
4332: END IF;

Line 4357: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');

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;
4360: END IF;
4361: -- raise FND_API.G_EXC_ERROR;

Line 4358: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_TO_SITE_USE_ID',FALSE);

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;
4360: END IF;
4361: -- raise FND_API.G_EXC_ERROR;
4362: END IF;

Line 4387: FND_MESSAGE.Set_Name('ASO', 'ASO_TAX_CALCULATION');

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
4391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4438: FND_MESSAGE.Set_Name('ASO', 'ASO_CREATING_RESERVATION');

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;
4442: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4439: FND_MESSAGE.Set_Token('LINE' , x_qte_line_rec.line_number, FALSE);

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;
4442: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4483: FND_MESSAGE.Set_Name('ASO', 'ASO_UPDATE_QUOTE_TOTAL');

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;
4487: END IF;

Line 4484: -- FND_MESSAGE.Set_Token('LINE' , x_qte_line_rec.line_number, FALSE);

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;
4487: END IF;
4488:

Line 4492: FND_MESSAGE.Set_Name('ASO', 'ASO_UPDATE_QUOTE_TOTAL');

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;
4496: END IF;

Line 4493: -- FND_MESSAGE.Set_Token('LINE' , x_qte_line_rec.line_number, FALSE);

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;
4496: END IF;
4497:

Line 4980: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');

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;
4984: RAISE FND_API.G_EXC_ERROR;

Line 4981: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

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;
4984: RAISE FND_API.G_EXC_ERROR;
4985: END IF;

Line 4994: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_LINE');

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;
4998: CLOSE C_qln_exist;

Line 4995: FND_MESSAGE.Set_Token ('VALUE', p_qte_line_rec.quote_line_id, FALSE);

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;
4998: CLOSE C_qln_exist;
4999: raise FND_API.G_EXC_ERROR;

Line 5018: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_UPDATE_TARGET');

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;
5022: Close C_Get_quote;

Line 5019: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);

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;
5022: Close C_Get_quote;
5023: raise FND_API.G_EXC_ERROR;

Line 5034: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');

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;
5038: raise FND_API.G_EXC_ERROR;

Line 5035: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

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;
5038: raise FND_API.G_EXC_ERROR;
5039: End if;

Line 5045: FND_MESSAGE.Set_Name('ASO', 'API_RECORD_CHANGED');

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;
5049: raise FND_API.G_EXC_ERROR;

Line 5046: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);

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;
5049: raise FND_API.G_EXC_ERROR;
5050: End if;

Line 5218: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_DEFAULTING');

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:
5222: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 5325: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');

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;
5329:

Line 5326: FND_MESSAGE.Set_Token('COLUMN', 'Price List Expires Before Quote', FALSE);

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;
5329:
5330: RAISE FND_API.G_EXC_ERROR;

Line 5439: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_SALES_REP_ID');

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;
5443: END IF;

Line 5565: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_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;
5569:

Line 5566: FND_MESSAGE.Set_Token('COLUMN', 'ORG_ID', FALSE);

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;
5569:
5570: END IF;

Line 5629: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');

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;
5633: RAISE FND_API.G_EXC_ERROR;

Line 5630: FND_MESSAGE.Set_Token('INFO', 'END_DATE', FALSE);

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;
5633: RAISE FND_API.G_EXC_ERROR;
5634: END IF;

Line 5654: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');

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;
5658: RAISE FND_API.G_EXC_ERROR;

Line 5655: FND_MESSAGE.Set_Token('INFO', 'RETURN', FALSE);

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;
5658: RAISE FND_API.G_EXC_ERROR;
5659: END IF;

Line 5683: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');

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;
5687: RAISE FND_API.G_EXC_ERROR;

Line 5684: FND_MESSAGE.Set_Token('INFO', 'TAX', FALSE);

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;
5687: RAISE FND_API.G_EXC_ERROR;
5688: END IF;

Line 5728: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');

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;
5732: RAISE FND_API.G_EXC_ERROR;

Line 5729: FND_MESSAGE.Set_Token('INFO', 'CONFIGURATION', FALSE);

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;
5732: RAISE FND_API.G_EXC_ERROR;
5733: END IF;

Line 5757: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');

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;
5761: RAISE FND_API.G_EXC_ERROR;

Line 5758: FND_MESSAGE.Set_Token('INFO', 'DELAYED SERVICE', FALSE);

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;
5761: RAISE FND_API.G_EXC_ERROR;
5762: END IF;

Line 5784: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');

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;
5788: RAISE FND_API.G_EXC_ERROR;

Line 5785: FND_MESSAGE.Set_Token('INFO', 'PARTY OBJECT ID', FALSE);

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;
5788: RAISE FND_API.G_EXC_ERROR;
5789: END IF;

Line 5842: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SHIP_FROM_ORG_ID');

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;
5846: END IF;

Line 5843: FND_MESSAGE.Set_Token('SHIP_FROM_ORG_ID', lx_ln_shipment_tbl(1).ship_from_org_id, FALSE);

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;
5846: END IF;
5847:

Line 5844: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', lx_qte_line_rec.inventory_item_id, FALSE);

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;
5846: END IF;
5847:
5848: RAISE FND_API.G_EXC_ERROR;

Line 5889: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SHIP_FROM_ORG_ID');

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;
5893: END IF;

Line 5890: FND_MESSAGE.Set_Token('SHIP_FROM_ORG_ID', l_db_shipment_rec.ship_from_org_id, FALSE);

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;
5893: END IF;
5894:

Line 5891: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', lx_qte_line_rec.inventory_item_id, FALSE);

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;
5893: END IF;
5894:
5895: RAISE FND_API.G_EXC_ERROR;

Line 5937: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SHIP_FROM_ORG_ID');

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;
5941: END IF;

Line 5938: FND_MESSAGE.Set_Token('SHIP_FROM_ORG_ID', l_hd_shipment_rec.ship_from_org_id, FALSE);

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;
5941: END IF;
5942:

Line 5939: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', lx_qte_line_rec.inventory_item_id, FALSE);

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;
5941: END IF;
5942:
5943: RAISE FND_API.G_EXC_ERROR;

Line 5980: FND_MESSAGE.Set_Name('ASO', 'INST_DETAILS_EXIST');

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;
5984:

Line 6000: FND_MESSAGE.Set_Name('ASO', 'INST_DETAILS_EXIST');

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;
6004:

Line 6031: FND_MESSAGE.Set_Name('ASO', 'ASO_EDU_INVALID_QTY');

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;
6035:

Line 6081: FND_MESSAGE.Set_Name('ASO', 'ASO_POPULATING_COLUMNS');

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;
6085:

Line 6082: FND_MESSAGE.Set_Token('LINE' , x_qte_line_rec.line_number, FALSE);

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;
6085:
6086: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 6236: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');

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;
6240:

Line 6237: FND_MESSAGE.Set_Token('INFO','SERVICE', FALSE);

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;
6240:
6241: RAISE FND_API.G_EXC_ERROR;

Line 6278: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SERVICE_REFERENCE');

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:
6282: RAISE FND_API.G_EXC_ERROR;

Line 6319: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');

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;
6323: END IF;

Line 6320: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_REF_TYPE_CODE', FALSE);

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;
6323: END IF;
6324:

Line 6321: FND_MESSAGE.Set_Token('VALUE', l_qte_line_dtl_tbl(i).service_ref_type_code,FALSE);

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;
6323: END IF;
6324:
6325: raise fnd_api.g_exc_error;

Line 6377: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_LINE_CATEGORY');

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:
6381: RAISE FND_API.G_EXC_ERROR;

Line 7798: FND_MESSAGE.Set_Name('ASO', 'DELETE_SHIPMENT');

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;
7802: END IF;

Line 7799: FND_MESSAGE.Set_Token('COLUMN', 'SHIPMENT_ID', FALSE);

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;
7802: END IF;
7803:

Line 8820: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_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;
8823: END IF;
8824: -- raise FND_API.G_EXC_ERROR;

Line 8821: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_TO_SITE_USE_ID',FALSE);

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;
8823: END IF;
8824: -- raise FND_API.G_EXC_ERROR;
8825: END IF;

Line 8851: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');

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;
8854: END IF;
8855: -- raise FND_API.G_EXC_ERROR;

Line 8852: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_TO_SITE_USE_ID',FALSE);

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;
8854: END IF;
8855: -- raise FND_API.G_EXC_ERROR;
8856: END IF;

Line 8875: FND_MESSAGE.Set_Name('ASO', 'ASO_TAX_CALCULATION');

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
8879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8924: FND_MESSAGE.Set_Name('ASO', 'ASO_CREATING_RESERVATION');

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
8928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8964: FND_MESSAGE.Set_Name('ASO', 'ASO_UPDATE_QUOTE_TOTAL');

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;
8968: END IF;

Line 8965: -- FND_MESSAGE.Set_Token('LINE' , x_qte_line_rec.line_number, FALSE);

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;
8968: END IF;
8969:

Line 9243: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');

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;
9247: RAISE FND_API.G_EXC_ERROR;

Line 9244: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

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;
9247: RAISE FND_API.G_EXC_ERROR;
9248: END IF;

Line 9266: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_UPDATE_TARGET');

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;
9270: raise FND_API.G_EXC_ERROR;

Line 9267: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);

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;
9270: raise FND_API.G_EXC_ERROR;
9271: END IF; -- update header flag

Line 9278: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');

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;
9282: raise FND_API.G_EXC_ERROR;

Line 9279: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

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;
9282: raise FND_API.G_EXC_ERROR;
9283: End if;

Line 9289: FND_MESSAGE.Set_Name('ASO', 'API_RECORD_CHANGED');

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;
9293: raise FND_API.G_EXC_ERROR;

Line 9290: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);

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;
9293: raise FND_API.G_EXC_ERROR;
9294: End if;

Line 9570: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');

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;
9574: RAISE FND_API.G_EXC_ERROR;

Line 9571: FND_MESSAGE.Set_Token('OBJECT','LINE_RLTSHIP',FALSE);

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;
9574: RAISE FND_API.G_EXC_ERROR;
9575: END IF;

Line 9590: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');

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;
9594: RAISE FND_API.G_EXC_ERROR;

Line 9591: FND_MESSAGE.Set_Token('OBJECT','PRICE_ADJ_RLTSHIP',FALSE);

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;
9594: RAISE FND_API.G_EXC_ERROR;
9595: END IF;

Line 9735: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');

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;
9739: RAISE FND_API.G_EXC_ERROR;

Line 9736: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);

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;
9739: RAISE FND_API.G_EXC_ERROR;
9740: END IF;

Line 9821: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');

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;
9825: RAISE FND_API.G_EXC_ERROR;

Line 9822: FND_MESSAGE.Set_Token('OBJECT', 'INSTALLATION DETAILS');

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;
9825: RAISE FND_API.G_EXC_ERROR;
9826: END IF;

Line 9840: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');

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;
9844: RAISE FND_API.G_EXC_ERROR;

Line 9841: FND_MESSAGE.Set_Token('OBJECT', 'LINE_SHIPMENTS', FALSE);

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;
9844: RAISE FND_API.G_EXC_ERROR;
9845: END IF;

Line 9891: FND_MESSAGE.Set_Name('ASO', 'ASO_UPDATE_QUOTE_TOTAL');

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:
9895: END IF;

Line 10181: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SERVICE_REF_LINE');

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;
10185: END IF;

Line 10182: FND_MESSAGE.Set_Token('CODE', 'QUOTE', FALSE);

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;
10185: END IF;
10186: ELSE

Line 10183: FND_MESSAGE.Set_Token('VALUE', l_qte_line_detail_tbl(i).service_ref_line_id, FALSE);

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;
10185: END IF;
10186: ELSE
10187: l_update_flag := FND_API.G_TRUE;

Line 10202: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SERVICE_REF_LINE');

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;
10206: END IF;

Line 10203: FND_MESSAGE.Set_Token('CODE', 'ORDER', FALSE);

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;
10206: END IF;
10207: ELSE

Line 10204: FND_MESSAGE.Set_Token('VALUE', l_qte_line_detail_tbl(i).service_ref_line_id, FALSE);

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;
10206: END IF;
10207: ELSE
10208: l_update_flag := FND_API.G_TRUE;

Line 10224: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SERVICE_REF_LINE');

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;
10228: END IF;

Line 10225: FND_MESSAGE.Set_Token('CODE', 'CUSTOMER_PRODUCT', FALSE);

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;
10228: END IF;
10229: ELSE

Line 10226: FND_MESSAGE.Set_Token('VALUE', l_qte_line_detail_tbl(i).service_ref_line_id, FALSE);

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;
10228: END IF;
10229: ELSE
10230: IF aso_debug_pub.g_debug_flag = 'Y' THEN