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 5004: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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;
5964: END IF;
5965:
5966: RAISE FND_API.G_EXC_ERROR;

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

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

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

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

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

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;
6011: END IF;
6012:
6013: RAISE FND_API.G_EXC_ERROR;

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

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

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

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

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

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;
6059: END IF;
6060:
6061: RAISE FND_API.G_EXC_ERROR;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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;
6441: END IF;
6442:
6443: raise fnd_api.g_exc_error;

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

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

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

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

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

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

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

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

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;
8941: END IF;
8942: -- raise FND_API.G_EXC_ERROR;
8943: END IF;

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

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

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

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;
8972: END IF;
8973: -- raise FND_API.G_EXC_ERROR;
8974: END IF;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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;
10303: END IF;
10304: ELSE

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

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;
10303: END IF;
10304: ELSE
10305: l_update_flag := FND_API.G_TRUE;

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

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

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

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;
10324: END IF;
10325: ELSE

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

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;
10324: END IF;
10325: ELSE
10326: l_update_flag := FND_API.G_TRUE;

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

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

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

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;
10346: END IF;
10347: ELSE

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

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;
10346: END IF;
10347: ELSE
10348: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

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

Line 10368: FND_MESSAGE.Set_Token('CODE', 'PRODUCT_CATALOG', FALSE);

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;
10371: END IF;
10372: ELSE

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

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;
10371: END IF;
10372: ELSE
10373: l_update_flag := FND_API.G_TRUE;