DBA Data[Home] [Help]

APPS.AS_SALES_LEADS_PUB dependencies on STANDARD

Line 11: -- coding standard

7: -- History :
8: -- 06/05/2000 FFANG Created.
9: -- 06/06/2000 FFANG Modified according data schema changes.
10: -- 09/21/2000 FFANG Add two lines to others exception handling to meet
11: -- coding standard
12: -- 12/12/2000 FFANG For bug 1529886, add one parameter P_OPP_STATUS in
13: -- create_opportunity_for_lead to get opportunity status
14: -- when creating opportunity
15: -- 06/05/2001 SOLIN Add API Build_Lead_Sales_Team and

Line 109: -- Standard call to check for call compatibility.

105:
106: BEGIN
107: SAVEPOINT CREATE_SALES_LEAD_PUB;
108:
109: -- Standard call to check for call compatibility.
110: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
111: p_api_version_number,
112: l_api_name,
113: G_PKG_NAME)

Line 270: -- Standard Start of API savepoint

266: l_api_name CONSTANT VARCHAR2(30) := 'Update_sales_lead';
267: l_api_version_number CONSTANT NUMBER := 2.0;
268:
269: BEGIN
270: -- Standard Start of API savepoint
271: SAVEPOINT UPDATE_SALES_LEAD_PUB;
272:
273: -- Standard call to check for call compatibility.
274: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 273: -- Standard call to check for call compatibility.

269: BEGIN
270: -- Standard Start of API savepoint
271: SAVEPOINT UPDATE_SALES_LEAD_PUB;
272:
273: -- Standard call to check for call compatibility.
274: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
275: p_api_version_number,
276: l_api_name,
277: G_PKG_NAME)

Line 432: -- Standard Start of API savepoint

428: l_api_name CONSTANT VARCHAR2(30) := 'Create_sales_lead_lines';
429: l_api_version_number CONSTANT NUMBER := 2.0;
430:
431: BEGIN
432: -- Standard Start of API savepoint
433: SAVEPOINT CREATE_SALES_LEAD_LINES_PUB;
434:
435: -- Standard call to check for call compatibility.
436: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 435: -- Standard call to check for call compatibility.

431: BEGIN
432: -- Standard Start of API savepoint
433: SAVEPOINT CREATE_SALES_LEAD_LINES_PUB;
434:
435: -- Standard call to check for call compatibility.
436: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
437: p_api_version_number,
438: l_api_name,
439: G_PKG_NAME)

Line 589: -- Standard Start of API savepoint

585: l_api_name CONSTANT VARCHAR2(30) := 'Update_sales_lead_lines';
586: l_api_version_number CONSTANT NUMBER := 2.0;
587:
588: BEGIN
589: -- Standard Start of API savepoint
590: SAVEPOINT UPDATE_SALES_LEAD_LINES_PUB;
591:
592: -- Standard call to check for call compatibility.
593: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 592: -- Standard call to check for call compatibility.

588: BEGIN
589: -- Standard Start of API savepoint
590: SAVEPOINT UPDATE_SALES_LEAD_LINES_PUB;
591:
592: -- Standard call to check for call compatibility.
593: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
594: p_api_version_number,
595: l_api_name,
596: G_PKG_NAME)

Line 748: -- Standard Start of API savepoint

744: IS
745: l_api_name CONSTANT VARCHAR2(30) := 'Delete_sales_lead_lines';
746: l_api_version_number CONSTANT NUMBER := 2.0;
747: BEGIN
748: -- Standard Start of API savepoint
749: SAVEPOINT DELETE_SALES_LEAD_LINES_PUB;
750:
751: -- Standard call to check for call compatibility.
752: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 751: -- Standard call to check for call compatibility.

747: BEGIN
748: -- Standard Start of API savepoint
749: SAVEPOINT DELETE_SALES_LEAD_LINES_PUB;
750:
751: -- Standard call to check for call compatibility.
752: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
753: p_api_version_number,
754: l_api_name,
755: G_PKG_NAME)

Line 845: -- Standard call to get message count and if count is 1, get message info.

841: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
842:
843: END IF;
844:
845: -- Standard call to get message count and if count is 1, get message info.
846: FND_MSG_PUB.Count_And_Get
847: ( p_count => x_msg_count,
848: p_data => x_msg_data
849: );

Line 913: -- Standard Start of API savepoint

909: IS
910: l_api_name CONSTANT VARCHAR2(30) := 'Create_sales_lead_contacts';
911: l_api_version_number CONSTANT NUMBER := 2.0;
912: BEGIN
913: -- Standard Start of API savepoint
914: SAVEPOINT CREATE_SALES_LEAD_CONTACTS_PUB;
915:
916: -- Standard call to check for call compatibility.
917: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 916: -- Standard call to check for call compatibility.

912: BEGIN
913: -- Standard Start of API savepoint
914: SAVEPOINT CREATE_SALES_LEAD_CONTACTS_PUB;
915:
916: -- Standard call to check for call compatibility.
917: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
918: p_api_version_number,
919: l_api_name,
920: G_PKG_NAME)

Line 1070: -- Standard Start of API savepoint

1066: IS
1067: l_api_name CONSTANT VARCHAR2(30) := 'Update_sales_lead_contacts';
1068: l_api_version_number CONSTANT NUMBER := 2.0;
1069: BEGIN
1070: -- Standard Start of API savepoint
1071: SAVEPOINT UPDATE_SALES_LEAD_CONTACTS_PUB;
1072:
1073: -- Standard call to check for call compatibility.
1074: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1073: -- Standard call to check for call compatibility.

1069: BEGIN
1070: -- Standard Start of API savepoint
1071: SAVEPOINT UPDATE_SALES_LEAD_CONTACTS_PUB;
1072:
1073: -- Standard call to check for call compatibility.
1074: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1075: p_api_version_number,
1076: l_api_name,
1077: G_PKG_NAME)

Line 1229: -- Standard Start of API savepoint

1225: IS
1226: l_api_name CONSTANT VARCHAR2(30) := 'Delete_sales_lead_contacts';
1227: l_api_version_number CONSTANT NUMBER := 2.0;
1228: BEGIN
1229: -- Standard Start of API savepoint
1230: SAVEPOINT DELETE_SALES_LEAD_CONTACTS_PUB;
1231:
1232: -- Standard call to check for call compatibility.
1233: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1232: -- Standard call to check for call compatibility.

1228: BEGIN
1229: -- Standard Start of API savepoint
1230: SAVEPOINT DELETE_SALES_LEAD_CONTACTS_PUB;
1231:
1232: -- Standard call to check for call compatibility.
1233: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1234: p_api_version_number,
1235: l_api_name,
1236: G_PKG_NAME)

Line 1326: -- Standard call to get message count and if count is 1, get message info.

1322: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1323:
1324: END IF;
1325:
1326: -- Standard call to get message count and if count is 1, get message info.
1327: FND_MSG_PUB.Count_And_Get
1328: ( p_count => x_msg_count,
1329: p_data => x_msg_data
1330: );

Line 1393: -- Standard Start of API savepoint

1389: IS
1390: l_api_name CONSTANT VARCHAR2(30) := 'Get_Potential_Opportunity';
1391: l_api_version_number CONSTANT NUMBER := 2.0;
1392: BEGIN
1393: -- Standard Start of API savepoint
1394: SAVEPOINT GET_POTENTIAL_OPPORTUNITY_PUB;
1395:
1396: -- Standard call to check for call compatibility.
1397: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1396: -- Standard call to check for call compatibility.

1392: BEGIN
1393: -- Standard Start of API savepoint
1394: SAVEPOINT GET_POTENTIAL_OPPORTUNITY_PUB;
1395:
1396: -- Standard call to check for call compatibility.
1397: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1398: p_api_version_number,
1399: l_api_name,
1400: G_PKG_NAME)

Line 1490: -- Standard call to get message count and if count is 1, get message info.

1486: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1487:
1488: END IF;
1489:
1490: -- Standard call to get message count and if count is 1, get message info.
1491: FND_MSG_PUB.Count_And_Get
1492: ( p_count => x_msg_count,
1493: p_data => x_msg_data
1494: );

Line 1561: -- Standard Start of API savepoint

1557: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Lead_To_Opportunity';
1558: l_api_version_number CONSTANT NUMBER := 2.0;
1559:
1560: BEGIN
1561: -- Standard Start of API savepoint
1562: SAVEPOINT COPY_LEAD_TO_OPPORTUNITY_PUB;
1563:
1564: -- Standard call to check for call compatibility.
1565: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1564: -- Standard call to check for call compatibility.

1560: BEGIN
1561: -- Standard Start of API savepoint
1562: SAVEPOINT COPY_LEAD_TO_OPPORTUNITY_PUB;
1563:
1564: -- Standard call to check for call compatibility.
1565: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1566: p_api_version_number,
1567: l_api_name,
1568: G_PKG_NAME)

Line 1657: -- Standard call to get message count and if count is 1, get message info.

1653: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1654:
1655: END IF;
1656:
1657: -- Standard call to get message count and if count is 1, get message info.
1658: FND_MSG_PUB.Count_And_Get
1659: ( p_count => x_msg_count,
1660: p_data => x_msg_data
1661: );

Line 1827: -- Standard Start of API savepoint

1823: FROM as_sales_leads
1824: WHERE sales_lead_id = X_Sales_Lead_Id;
1825:
1826: BEGIN
1827: -- Standard Start of API savepoint
1828: SAVEPOINT LINK_LEAD_TO_OPPORTUNITY_PUB;
1829:
1830: -- Standard call to check for call compatibility.
1831: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1830: -- Standard call to check for call compatibility.

1826: BEGIN
1827: -- Standard Start of API savepoint
1828: SAVEPOINT LINK_LEAD_TO_OPPORTUNITY_PUB;
1829:
1830: -- Standard call to check for call compatibility.
1831: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1832: p_api_version_number,
1833: l_api_name,
1834: G_PKG_NAME)

Line 2048: -- Standard call to get message count and if count is 1, get message info.

2044: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2045:
2046: END IF;
2047:
2048: -- Standard call to get message count and if count is 1, get message info.
2049: FND_MSG_PUB.Count_And_Get
2050: ( p_count => x_msg_count,
2051: p_data => x_msg_data
2052: );

Line 2126: -- Standard Start of API savepoint

2122: and pva.ATTRIBUTE_ID = pvav.attribute_id
2123: and enabled_flag = 'Y'
2124: );
2125: BEGIN
2126: -- Standard Start of API savepoint
2127: SAVEPOINT CREATE_OPP_ENTITY_ATTRIBUTE;
2128:
2129: -- Standard call to check for call compatibility.
2130: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 2129: -- Standard call to check for call compatibility.

2125: BEGIN
2126: -- Standard Start of API savepoint
2127: SAVEPOINT CREATE_OPP_ENTITY_ATTRIBUTE;
2128:
2129: -- Standard call to check for call compatibility.
2130: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2131: p_api_version_number,
2132: l_api_name,
2133: G_PKG_NAME)

Line 2234: -- Standard call to get message count and if count is 1, get message info.

2230: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2231:
2232: END IF;
2233:
2234: -- Standard call to get message count and if count is 1, get message info.
2235: FND_MSG_PUB.Count_And_Get
2236: ( p_count => x_msg_count,
2237: p_data => x_msg_data
2238: );

Line 2319: -- Standard Start of API savepoint

2315: FROM PV_LEAD_PSS_LINES
2316: WHERE object_id = X_Sales_Lead_Id
2317: AND object_name = 'SALES_LEAD';
2318: BEGIN
2319: -- Standard Start of API savepoint
2320: SAVEPOINT CREATE_OPP_PSS_LEAD_LINE;
2321:
2322: -- Standard call to check for call compatibility.
2323: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 2322: -- Standard call to check for call compatibility.

2318: BEGIN
2319: -- Standard Start of API savepoint
2320: SAVEPOINT CREATE_OPP_PSS_LEAD_LINE;
2321:
2322: -- Standard call to check for call compatibility.
2323: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2324: p_api_version_number,
2325: l_api_name,
2326: G_PKG_NAME)

Line 2443: -- Standard call to get message count and if count is 1, get message info.

2439: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2440:
2441: END IF;
2442:
2443: -- Standard call to get message count and if count is 1, get message info.
2444: FND_MSG_PUB.Count_And_Get
2445: ( p_count => x_msg_count,
2446: p_data => x_msg_data
2447: );

Line 2610: -- Standard Start of API savepoint

2606:
2607: FROM as_sales_leads
2608: WHERE sales_lead_id = X_Sales_Lead_Id;
2609: BEGIN
2610: -- Standard Start of API savepoint
2611: SAVEPOINT CREATE_OPP_FOR_LEAD_PUB;
2612:
2613: -- Standard call to check for call compatibility.
2614: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 2613: -- Standard call to check for call compatibility.

2609: BEGIN
2610: -- Standard Start of API savepoint
2611: SAVEPOINT CREATE_OPP_FOR_LEAD_PUB;
2612:
2613: -- Standard call to check for call compatibility.
2614: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2615: p_api_version_number,
2616: l_api_name,
2617: G_PKG_NAME)

Line 2863: -- Standard call to get message count and if count is 1, get message info.

2859: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2860:
2861: END IF;
2862:
2863: -- Standard call to get message count and if count is 1, get message info.
2864: FND_MSG_PUB.Count_And_Get
2865: ( p_count => x_msg_count,
2866: p_data => x_msg_data
2867: );

Line 2925: -- Standard Start of API savepoint

2921: l_api_name CONSTANT VARCHAR2(30) := 'Assign_Sales_Lead';
2922: l_api_version_number CONSTANT NUMBER := 2.0;
2923:
2924: BEGIN
2925: -- Standard Start of API savepoint
2926: SAVEPOINT ASSIGN_SALES_LEAD_PUB;
2927:
2928: -- Standard call to check for call compatibility.
2929: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 2928: -- Standard call to check for call compatibility.

2924: BEGIN
2925: -- Standard Start of API savepoint
2926: SAVEPOINT ASSIGN_SALES_LEAD_PUB;
2927:
2928: -- Standard call to check for call compatibility.
2929: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2930: p_api_version_number,
2931: l_api_name,
2932: G_PKG_NAME)

Line 3031: -- Standard call to get message count and if count is 1, get message info.

3027: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3028:
3029: END IF;
3030:
3031: -- Standard call to get message count and if count is 1, get message info.
3032: FND_MSG_PUB.Count_And_Get
3033: ( p_count => x_msg_count,
3034: p_data => x_msg_data
3035: );

Line 3181: -- Standard Start of API savepoint

3177: l_api_name CONSTANT VARCHAR2(30) := 'CALL_WF_TO_ASSIGN';
3178: l_api_version_number CONSTANT NUMBER := 2.0;
3179:
3180: BEGIN
3181: -- Standard Start of API savepoint
3182: SAVEPOINT CALL_WF_TO_ASSIGN_PUB;
3183:
3184: -- Standard call to check for call compatibility.
3185: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 3184: -- Standard call to check for call compatibility.

3180: BEGIN
3181: -- Standard Start of API savepoint
3182: SAVEPOINT CALL_WF_TO_ASSIGN_PUB;
3183:
3184: -- Standard call to check for call compatibility.
3185: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3186: p_api_version_number,
3187: l_api_name,
3188: G_PKG_NAME)

Line 3271: -- Standard call to get message count and if count is 1, get message info.

3267: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3268:
3269: END IF;
3270:
3271: -- Standard call to get message count and if count is 1, get message info.
3272: FND_MSG_PUB.Count_And_Get
3273: ( p_count => x_msg_count,
3274: p_data => x_msg_data
3275: );

Line 3333: -- Standard call to check for call compatibility.

3329:
3330: BEGIN
3331: SAVEPOINT BUILD_LEAD_SALES_TEAM_PUB;
3332:
3333: -- Standard call to check for call compatibility.
3334: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3335: p_api_version_number,
3336: l_api_name,
3337: G_PKG_NAME)

Line 3487: -- Standard call to check for call compatibility.

3483:
3484: BEGIN
3485: SAVEPOINT REBUILD_LEAD_SALES_TEAM_PUB;
3486:
3487: -- Standard call to check for call compatibility.
3488: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3489: p_api_version_number,
3490: l_api_name,
3491: G_PKG_NAME)

Line 3643: -- Standard call to check for call compatibility.

3639:
3640: BEGIN
3641: SAVEPOINT RUN_LEAD_ENGINES_PUB;
3642:
3643: -- Standard call to check for call compatibility.
3644: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3645: p_api_version_number,
3646: l_api_name,
3647: G_PKG_NAME)

Line 3802: -- Standard call to check for call compatibility.

3798:
3799: BEGIN
3800: SAVEPOINT RUN_LEAD_ENGINES_PUB;
3801:
3802: -- Standard call to check for call compatibility.
3803: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3804: p_api_version_number,
3805: l_api_name,
3806: G_PKG_NAME)

Line 3957: -- Standard call to check for call compatibility.

3953:
3954: BEGIN
3955: SAVEPOINT START_PARTNER_MATCHING_PUB;
3956:
3957: -- Standard call to check for call compatibility.
3958: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3959: p_api_version_number,
3960: l_api_name,
3961: G_PKG_NAME)

Line 4211: -- Standard call to check for call compatibility.

4207: AND acc.sales_lead_id = c_sales_lead_id;
4208: BEGIN
4209: SAVEPOINT ROUTE_LEAD_TO_MARKETING_PUB;
4210:
4211: -- Standard call to check for call compatibility.
4212: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4213: p_api_version_number,
4214: l_api_name,
4215: G_PKG_NAME)

Line 4683: -- Standard call to check for call compatibility.

4679:
4680: BEGIN
4681: SAVEPOINT LEAD_PROCESS_AFTER_CREATE_PUB;
4682:
4683: -- Standard call to check for call compatibility.
4684: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4685: p_api_version_number,
4686: l_api_name,
4687: G_PKG_NAME)

Line 4835: -- Standard call to check for call compatibility.

4831:
4832: BEGIN
4833: SAVEPOINT LEAD_PROCESS_AFTER_UPDATE_PUB;
4834:
4835: -- Standard call to check for call compatibility.
4836: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4837: p_api_version_number,
4838: l_api_name,
4839: G_PKG_NAME)