DBA Data[Home] [Help]

APPS.AS_OPP_LINE_PVT dependencies on FND_MESSAGE

Line 323: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');

319: IF (C_Int_Type_Exists%NOTFOUND)
320: THEN
321: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
322: THEN
323: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
324: FND_MESSAGE.Set_Token('COLUMN', 'INTEREST_TYPE', FALSE);
325: FND_MESSAGE.Set_Token('VALUE', p_interest_type_id, FALSE);
326: FND_MSG_PUB.Add;
327: END IF;

Line 324: FND_MESSAGE.Set_Token('COLUMN', 'INTEREST_TYPE', FALSE);

320: THEN
321: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
322: THEN
323: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
324: FND_MESSAGE.Set_Token('COLUMN', 'INTEREST_TYPE', FALSE);
325: FND_MESSAGE.Set_Token('VALUE', p_interest_type_id, FALSE);
326: FND_MSG_PUB.Add;
327: END IF;
328:

Line 325: FND_MESSAGE.Set_Token('VALUE', p_interest_type_id, FALSE);

321: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
322: THEN
323: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
324: FND_MESSAGE.Set_Token('COLUMN', 'INTEREST_TYPE', FALSE);
325: FND_MESSAGE.Set_Token('VALUE', p_interest_type_id, FALSE);
326: FND_MSG_PUB.Add;
327: END IF;
328:
329: l_return_status := FND_API.G_RET_STS_ERROR;

Line 345: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');

341: IF (C_Prim_Int_Code_Exists%NOTFOUND)
342: THEN
343: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_Msg_Lvl_Error)
344: THEN
345: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
346: FND_MESSAGE.Set_Token('COLUMN', 'PRIMARY_INTEREST_CODE', FALSE);
347: FND_MESSAGE.Set_Token('VALUE', p_primary_interest_code_id, FALSE);
348: FND_MSG_PUB.Add;
349: END IF;

Line 346: FND_MESSAGE.Set_Token('COLUMN', 'PRIMARY_INTEREST_CODE', FALSE);

342: THEN
343: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_Msg_Lvl_Error)
344: THEN
345: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
346: FND_MESSAGE.Set_Token('COLUMN', 'PRIMARY_INTEREST_CODE', FALSE);
347: FND_MESSAGE.Set_Token('VALUE', p_primary_interest_code_id, FALSE);
348: FND_MSG_PUB.Add;
349: END IF;
350:

Line 347: FND_MESSAGE.Set_Token('VALUE', p_primary_interest_code_id, FALSE);

343: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_Msg_Lvl_Error)
344: THEN
345: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
346: FND_MESSAGE.Set_Token('COLUMN', 'PRIMARY_INTEREST_CODE', FALSE);
347: FND_MESSAGE.Set_Token('VALUE', p_primary_interest_code_id, FALSE);
348: FND_MSG_PUB.Add;
349: END IF;
350:
351: l_return_status := FND_API.G_RET_STS_ERROR;

Line 368: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');

364: IF (C_Sec_Int_Code_Exists%NOTFOUND)
365: THEN
366: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
367: THEN
368: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
369: FND_MESSAGE.Set_Token('COLUMN', 'SECONDARY_INTEREST_CODE', FALSE);
370: FND_MESSAGE.Set_Token('VALUE', p_secondary_interest_code_id, FALSE);
371: FND_MSG_PUB.ADD;
372: END IF;

Line 369: FND_MESSAGE.Set_Token('COLUMN', 'SECONDARY_INTEREST_CODE', FALSE);

365: THEN
366: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
367: THEN
368: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
369: FND_MESSAGE.Set_Token('COLUMN', 'SECONDARY_INTEREST_CODE', FALSE);
370: FND_MESSAGE.Set_Token('VALUE', p_secondary_interest_code_id, FALSE);
371: FND_MSG_PUB.ADD;
372: END IF;
373:

Line 370: FND_MESSAGE.Set_Token('VALUE', p_secondary_interest_code_id, FALSE);

366: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
367: THEN
368: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
369: FND_MESSAGE.Set_Token('COLUMN', 'SECONDARY_INTEREST_CODE', FALSE);
370: FND_MESSAGE.Set_Token('VALUE', p_secondary_interest_code_id, FALSE);
371: FND_MSG_PUB.ADD;
372: END IF;
373:
374: l_return_status := FND_API.G_RET_STS_ERROR;

Line 476: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ITEM_CATEGORY');

472: END IF;
473:
474: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
475: THEN
476: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ITEM_CATEGORY');
477: FND_MSG_PUB.ADD;
478: END IF;
479: p_return_status := FND_API.G_RET_STS_ERROR;
480: END IF;

Line 503: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');

499: END IF;
500:
501: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
502: THEN
503: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
504: FND_MESSAGE.Set_Token('COLUMN', 'ORGANIZATION_ID', FALSE);
505: FND_MSG_PUB.ADD;
506: END IF;
507:

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

500:
501: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
502: THEN
503: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
504: FND_MESSAGE.Set_Token('COLUMN', 'ORGANIZATION_ID', FALSE);
505: FND_MSG_PUB.ADD;
506: END IF;
507:
508: p_return_status := FND_API.G_RET_STS_ERROR;

Line 524: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');

520: END IF;
521:
522: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
523: THEN
524: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
525: FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID', FALSE);
526: FND_MESSAGE.Set_Token('VALUE', p_inventory_item_id, FALSE);
527: FND_MSG_PUB.ADD;
528: END IF;

Line 525: FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID', FALSE);

521:
522: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
523: THEN
524: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
525: FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID', FALSE);
526: FND_MESSAGE.Set_Token('VALUE', p_inventory_item_id, FALSE);
527: FND_MSG_PUB.ADD;
528: END IF;
529:

Line 526: FND_MESSAGE.Set_Token('VALUE', p_inventory_item_id, FALSE);

522: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
523: THEN
524: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
525: FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID', FALSE);
526: FND_MESSAGE.Set_Token('VALUE', p_inventory_item_id, FALSE);
527: FND_MSG_PUB.ADD;
528: END IF;
529:
530: p_return_status := FND_API.G_RET_STS_ERROR;

Line 616: FND_MESSAGE.Set_Name('AS', 'API_DERIVE_PC_ERROR');

612: 'Private API: Unable to derive product category from item');
613: END IF;
614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
615: THEN
616: FND_MESSAGE.Set_Name('AS', 'API_DERIVE_PC_ERROR');
617: FND_MSG_PUB.ADD;
618: END IF;
619: l_return_status := FND_API.G_RET_STS_ERROR;
620: END IF;

Line 637: FND_MESSAGE.Set_Name('AS', 'API_DERIVE_PC_ERROR');

633: 'Private API: Unable to derive product category from secondary interest code');
634: END IF;
635: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
636: THEN
637: FND_MESSAGE.Set_Name('AS', 'API_DERIVE_PC_ERROR');
638: FND_MSG_PUB.ADD;
639: END IF;
640: l_return_status := FND_API.G_RET_STS_ERROR;
641: END IF;

Line 658: FND_MESSAGE.Set_Name('AS', 'API_DERIVE_PC_ERROR');

654: 'Private API: Unable to derive product category from primary interest code');
655: END IF;
656: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
657: THEN
658: FND_MESSAGE.Set_Name('AS', 'API_DERIVE_PC_ERROR');
659: FND_MSG_PUB.ADD;
660: END IF;
661: l_return_status := FND_API.G_RET_STS_ERROR;
662: END IF;

Line 679: FND_MESSAGE.Set_Name('AS', 'API_DERIVE_PC_ERROR');

675: 'Private API: Unable to derive product category from interest type');
676: END IF;
677: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
678: THEN
679: FND_MESSAGE.Set_Name('AS', 'API_DERIVE_PC_ERROR');
680: FND_MSG_PUB.ADD;
681: END IF;
682: l_return_status := FND_API.G_RET_STS_ERROR;
683: END IF;

Line 861: FND_MESSAGE.Set_Name(' + appShortName +',

857: IF FND_GLOBAL.User_Id IS NULL
858: THEN
859: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
860: THEN
861: FND_MESSAGE.Set_Name(' + appShortName +',
862: 'UT_CANNOT_GET_PROFILE_VALUE');
863: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
864: FND_MSG_PUB.ADD;
865: END IF;

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

859: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
860: THEN
861: FND_MESSAGE.Set_Name(' + appShortName +',
862: 'UT_CANNOT_GET_PROFILE_VALUE');
863: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
864: FND_MSG_PUB.ADD;
865: END IF;
866: RAISE FND_API.G_EXC_ERROR;
867: END IF;

Line 896: FND_MESSAGE.Set_Name('AS', 'AS_CREDIT_TYPE_MISSING');

892: 'The profile AS_FORECAST_CREDIT_TYPE_ID is null');
893: END IF;
894:
895: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
896: FND_MESSAGE.Set_Name('AS', 'AS_CREDIT_TYPE_MISSING');
897: FND_MSG_PUB.ADD;
898: END IF;
899:
900: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 939: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');

935: END IF;
936:
937: IF (l_update_access_flag <> 'Y') THEN
938: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
939: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
940: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
941: FND_MSG_PUB.ADD;
942: END IF;
943: RAISE FND_API.G_EXC_ERROR;

Line 940: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);

936:
937: IF (l_update_access_flag <> 'Y') THEN
938: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
939: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
940: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
941: FND_MSG_PUB.ADD;
942: END IF;
943: RAISE FND_API.G_EXC_ERROR;
944: ELSE

Line 975: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');

971: -- Progress Message
972: --
973: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
974: THEN
975: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
976: --FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_LINE', TRUE);
977: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
978: --FND_MSG_PUB.Add;
979: IF l_debug THEN

Line 976: --FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_LINE', TRUE);

972: --
973: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
974: THEN
975: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
976: --FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_LINE', TRUE);
977: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
978: --FND_MSG_PUB.Add;
979: IF l_debug THEN
980: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 977: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);

973: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
974: THEN
975: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
976: --FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_LINE', TRUE);
977: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
978: --FND_MSG_PUB.Add;
979: IF l_debug THEN
980: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
981: 'Processing AS_LEAD_LINE row number '||l_curr_row );

Line 1618: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');

1614: END IF;
1615:
1616: IF (l_update_access_flag <> 'Y') THEN
1617: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1618: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
1619: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
1620: FND_MSG_PUB.ADD;
1621: END IF;
1622: RAISE FND_API.G_EXC_ERROR;

Line 1619: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);

1615:
1616: IF (l_update_access_flag <> 'Y') THEN
1617: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1618: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
1619: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
1620: FND_MSG_PUB.ADD;
1621: END IF;
1622: RAISE FND_API.G_EXC_ERROR;
1623: END IF;

Line 1649: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');

1645: -- Progress Message
1646: --
1647: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1648: THEN
1649: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
1650: --FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_LINE', TRUE);
1651: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
1652: --FND_MSG_PUB.Add;
1653: IF l_debug THEN

Line 1650: --FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_LINE', TRUE);

1646: --
1647: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1648: THEN
1649: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
1650: --FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_LINE', TRUE);
1651: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
1652: --FND_MSG_PUB.Add;
1653: IF l_debug THEN
1654: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1651: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);

1647: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1648: THEN
1649: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
1650: --FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_LINE', TRUE);
1651: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
1652: --FND_MSG_PUB.Add;
1653: IF l_debug THEN
1654: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1655: 'Processing AS_LEAD_LINE row number '||l_curr_row );

Line 1676: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');

1672:
1673: If ( C_Get_opp_line%NOTFOUND) Then
1674: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1675: THEN
1676: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
1677: FND_MESSAGE.Set_Token ('INFO', 'opp_line', FALSE);
1678: FND_MSG_PUB.Add;
1679: END IF;
1680: raise FND_API.G_EXC_ERROR;

Line 1677: FND_MESSAGE.Set_Token ('INFO', 'opp_line', FALSE);

1673: If ( C_Get_opp_line%NOTFOUND) Then
1674: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1675: THEN
1676: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
1677: FND_MESSAGE.Set_Token ('INFO', 'opp_line', FALSE);
1678: FND_MSG_PUB.Add;
1679: END IF;
1680: raise FND_API.G_EXC_ERROR;
1681: END IF;

Line 1694: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');

1690: If (l_Line_rec.last_update_date is NULL or
1691: l_Line_rec.last_update_date = FND_API.G_MISS_Date ) Then
1692: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1693: THEN
1694: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1695: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1696: FND_MSG_PUB.ADD;
1697: END IF;
1698: raise FND_API.G_EXC_ERROR;

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

1691: l_Line_rec.last_update_date = FND_API.G_MISS_Date ) Then
1692: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1693: THEN
1694: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1695: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1696: FND_MSG_PUB.ADD;
1697: END IF;
1698: raise FND_API.G_EXC_ERROR;
1699: End if;

Line 1705: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');

1701: If (l_Line_rec.last_update_date <> l_last_update_date)
1702: Then
1703: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1704: THEN
1705: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
1706: FND_MESSAGE.Set_Token('INFO', 'opp_line', FALSE);
1707: FND_MSG_PUB.ADD;
1708: END IF;
1709: raise FND_API.G_EXC_ERROR;

Line 1706: FND_MESSAGE.Set_Token('INFO', 'opp_line', FALSE);

1702: Then
1703: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1704: THEN
1705: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
1706: FND_MESSAGE.Set_Token('INFO', 'opp_line', FALSE);
1707: FND_MSG_PUB.ADD;
1708: END IF;
1709: raise FND_API.G_EXC_ERROR;
1710: End if;

Line 2139: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');

2135: END IF;
2136:
2137: IF (l_update_access_flag <> 'Y') THEN
2138: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2139: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
2140: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
2141: FND_MSG_PUB.ADD;
2142: END IF;
2143: RAISE FND_API.G_EXC_ERROR;

Line 2140: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);

2136:
2137: IF (l_update_access_flag <> 'Y') THEN
2138: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2139: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
2140: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
2141: FND_MSG_PUB.ADD;
2142: END IF;
2143: RAISE FND_API.G_EXC_ERROR;
2144: END IF;

Line 2171: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');

2167: -- Progress Message
2168: --
2169: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2170: THEN
2171: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
2172: --FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_LINE', TRUE);
2173: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
2174: --FND_MSG_PUB.Add;
2175: IF l_debug THEN

Line 2172: --FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_LINE', TRUE);

2168: --
2169: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2170: THEN
2171: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
2172: --FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_LINE', TRUE);
2173: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
2174: --FND_MSG_PUB.Add;
2175: IF l_debug THEN
2176: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2173: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);

2169: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2170: THEN
2171: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
2172: --FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_LINE', TRUE);
2173: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
2174: --FND_MSG_PUB.Add;
2175: IF l_debug THEN
2176: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2177: 'Processing AS_LEAD_LINE row number '||l_curr_row );

Line 2748: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');

2744: l_return_status := FND_API.G_RET_STS_ERROR;
2745:
2746: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2747: THEN
2748: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
2749: FND_MESSAGE.Set_Token('COLUMN', 'PRODUCT_CATEGORY_ID', FALSE);
2750: FND_MSG_PUB.ADD;
2751: END IF;
2752: ELSIF ((P_CATEGORY_SET_ID is NULL)

Line 2749: FND_MESSAGE.Set_Token('COLUMN', 'PRODUCT_CATEGORY_ID', FALSE);

2745:
2746: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2747: THEN
2748: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
2749: FND_MESSAGE.Set_Token('COLUMN', 'PRODUCT_CATEGORY_ID', FALSE);
2750: FND_MSG_PUB.ADD;
2751: END IF;
2752: ELSIF ((P_CATEGORY_SET_ID is NULL)
2753: or (P_CATEGORY_SET_ID = FND_API.G_MISS_NUM))

Line 2759: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');

2755: l_return_status := FND_API.G_RET_STS_ERROR;
2756:
2757: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2758: THEN
2759: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
2760: FND_MESSAGE.Set_Token('COLUMN', 'PRODUCT_CAT_SET_ID', FALSE);
2761: FND_MSG_PUB.ADD;
2762: END IF;
2763: ELSE

Line 2760: FND_MESSAGE.Set_Token('COLUMN', 'PRODUCT_CAT_SET_ID', FALSE);

2756:
2757: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2758: THEN
2759: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
2760: FND_MESSAGE.Set_Token('COLUMN', 'PRODUCT_CAT_SET_ID', FALSE);
2761: FND_MSG_PUB.ADD;
2762: END IF;
2763: ELSE
2764: -- Insure that all ids are valid

Line 2846: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');

2842: IF (C_Prod_Cat_Exists_And_Valid%NOTFOUND)
2843: THEN
2844: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
2845: THEN
2846: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
2847: FND_MESSAGE.Set_Token('COLUMN', 'PRODUCT_CATEGORY', FALSE);
2848: FND_MESSAGE.Set_Token('VALUE', p_product_category_id, FALSE);
2849: FND_MSG_PUB.Add;
2850: END IF;

Line 2847: FND_MESSAGE.Set_Token('COLUMN', 'PRODUCT_CATEGORY', FALSE);

2843: THEN
2844: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
2845: THEN
2846: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
2847: FND_MESSAGE.Set_Token('COLUMN', 'PRODUCT_CATEGORY', FALSE);
2848: FND_MESSAGE.Set_Token('VALUE', p_product_category_id, FALSE);
2849: FND_MSG_PUB.Add;
2850: END IF;
2851:

Line 2848: FND_MESSAGE.Set_Token('VALUE', p_product_category_id, FALSE);

2844: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
2845: THEN
2846: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
2847: FND_MESSAGE.Set_Token('COLUMN', 'PRODUCT_CATEGORY', FALSE);
2848: FND_MESSAGE.Set_Token('VALUE', p_product_category_id, FALSE);
2849: FND_MSG_PUB.Add;
2850: END IF;
2851:
2852: l_return_status := FND_API.G_RET_STS_ERROR;

Line 2863: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');

2859: IF (C_Prod_Cat_Exists%NOTFOUND)
2860: THEN
2861: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
2862: THEN
2863: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
2864: FND_MESSAGE.Set_Token('COLUMN', 'PRODUCT_CATEGORY', FALSE);
2865: FND_MESSAGE.Set_Token('VALUE', p_product_category_id, FALSE);
2866: FND_MSG_PUB.Add;
2867: END IF;

Line 2864: FND_MESSAGE.Set_Token('COLUMN', 'PRODUCT_CATEGORY', FALSE);

2860: THEN
2861: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
2862: THEN
2863: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
2864: FND_MESSAGE.Set_Token('COLUMN', 'PRODUCT_CATEGORY', FALSE);
2865: FND_MESSAGE.Set_Token('VALUE', p_product_category_id, FALSE);
2866: FND_MSG_PUB.Add;
2867: END IF;
2868:

Line 2865: FND_MESSAGE.Set_Token('VALUE', p_product_category_id, FALSE);

2861: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
2862: THEN
2863: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
2864: FND_MESSAGE.Set_Token('COLUMN', 'PRODUCT_CATEGORY', FALSE);
2865: FND_MESSAGE.Set_Token('VALUE', p_product_category_id, FALSE);
2866: FND_MSG_PUB.Add;
2867: END IF;
2868:
2869: l_return_status := FND_API.G_RET_STS_ERROR;

Line 3607: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');

3603: END IF;
3604:
3605: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3606: THEN
3607: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
3608: FND_MESSAGE.Set_Token('COLUMN', 'ORGANIZATION_ID', FALSE);
3609: FND_MSG_PUB.ADD;
3610: END IF;
3611:

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

3604:
3605: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3606: THEN
3607: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
3608: FND_MESSAGE.Set_Token('COLUMN', 'ORGANIZATION_ID', FALSE);
3609: FND_MSG_PUB.ADD;
3610: END IF;
3611:
3612: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3629: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');

3625: END IF;
3626:
3627: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3628: THEN
3629: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
3630: FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID', FALSE);
3631: FND_MESSAGE.Set_Token('VALUE', p_line_rec.inventory_item_id, FALSE);
3632: FND_MSG_PUB.ADD;
3633: END IF;

Line 3630: FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID', FALSE);

3626:
3627: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3628: THEN
3629: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
3630: FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID', FALSE);
3631: FND_MESSAGE.Set_Token('VALUE', p_line_rec.inventory_item_id, FALSE);
3632: FND_MSG_PUB.ADD;
3633: END IF;
3634:

Line 3631: FND_MESSAGE.Set_Token('VALUE', p_line_rec.inventory_item_id, FALSE);

3627: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3628: THEN
3629: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
3630: FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID', FALSE);
3631: FND_MESSAGE.Set_Token('VALUE', p_line_rec.inventory_item_id, FALSE);
3632: FND_MSG_PUB.ADD;
3633: END IF;
3634:
3635: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3657: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ITEM_CATEGORY');

3653: END IF;
3654:
3655: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3656: THEN
3657: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ITEM_CATEGORY');
3658: FND_MSG_PUB.ADD;
3659: END IF;
3660: x_return_status := FND_API.G_RET_STS_ERROR;
3661: END IF;

Line 3725: FND_MESSAGE.Set_Name('AS', 'AS_INV_ORG_NULL');

3721: END IF;
3722:
3723: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3724: THEN
3725: FND_MESSAGE.Set_Name('AS', 'AS_INV_ORG_NULL');
3726: FND_MSG_PUB.ADD;
3727: END IF;
3728:
3729: x_return_status := FND_API.G_RET_STS_ERROR;