[Home] [Help]
46: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
47: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Create_Opp_Header';
48:
49: BEGIN
50: -- Standard Start of API savepoint
51: SAVEPOINT CREATE_OPP_HEADER_PUB;
52:
53: -- Standard call to check for call compatibility.
54: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
49: BEGIN
50: -- Standard Start of API savepoint
51: SAVEPOINT CREATE_OPP_HEADER_PUB;
52:
53: -- Standard call to check for call compatibility.
54: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
55: p_api_version_number,
56: l_api_name,
57: G_PKG_NAME)
133: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
134: raise FND_API.G_EXC_UNEXPECTED_ERROR;
135: END IF;
136:
137: -- USER HOOK standard : vertical industry post-processing section
138: IF(JTF_USR_HKS.Ok_to_execute('AS_OPPORTUNITY_PUB', 'Create_Opp_Header','A','V'))
139: THEN
140: l_Header_Rec.lead_id := x_LEAD_ID;
141: l_lead_id := x_LEAD_ID;
179: --
180: -- End of API body.
181: --
182:
183: -- Standard check for p_commit
184: IF FND_API.to_Boolean( p_commit )
185: THEN
186: COMMIT WORK;
187: END IF;
197: END IF;
198:
199:
200:
201: -- Standard call to get message count and if count is 1, get message info.
202:
203: FND_MSG_PUB.Count_And_Get
204: ( p_count => x_msg_count,
205: p_data => x_msg_data
277: l_warning_msg VARCHAR2(2000) := '';
278: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
279: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Opp_header';
280: BEGIN
281: -- Standard Start of API savepoint
282: SAVEPOINT UPDATE_OPP_HEADER_PUB;
283:
284: -- Standard call to check for call compatibility.
285: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
280: BEGIN
281: -- Standard Start of API savepoint
282: SAVEPOINT UPDATE_OPP_HEADER_PUB;
283:
284: -- Standard call to check for call compatibility.
285: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
286: p_api_version_number,
287: l_api_name,
288: G_PKG_NAME)
329: x_pvt_Header_rec => l_pvt_Header_rec
330: );
331: *****/
332:
333: -- USER HOOK standard : vertical industry pre-processing section
334: IF(JTF_USR_HKS.Ok_to_execute('AS_OPPORTUNITY_PUB', 'Update_Opp_Header','B','V'))
335: THEN
336: AS_OPPORTUNITY_VUHK.Update_opp_header_Pre(
337: P_Api_Version_Number => 2.0,
394: raise FND_API.G_EXC_UNEXPECTED_ERROR;
395: END IF;
396:
397:
398: -- USER HOOK standard : vertical industry post-processing section
399: IF(JTF_USR_HKS.Ok_to_execute('AS_OPPORTUNITY_PUB', 'Update_Opp_Header','A','V'))
400: THEN
401: AS_OPPORTUNITY_VUHK.Update_opp_header_Post(
402: P_Api_Version_Number => 2.0,
434: --
435: -- End of API body
436: --
437:
438: -- Standard check for p_commit
439: IF FND_API.to_Boolean( p_commit )
440: THEN
441: COMMIT WORK;
442: END IF;
449:
450: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
451: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
452: END IF;
453: -- Standard call to get message count and if count is 1, get message info.
454: FND_MSG_PUB.Count_And_Get
455: ( p_count => x_msg_count,
456: p_data => x_msg_data
457: );
526: l_header_rec Header_Rec_Type := p_header_rec;
527: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
528: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Opp_Header';
529: BEGIN
530: -- Standard Start of API savepoint
531: SAVEPOINT DELETE_OPP_HEADER_PUB;
532:
533: -- Standard call to check for call compatibility.
534: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
529: BEGIN
530: -- Standard Start of API savepoint
531: SAVEPOINT DELETE_OPP_HEADER_PUB;
532:
533: -- Standard call to check for call compatibility.
534: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
535: p_api_version_number,
536: l_api_name,
537: G_PKG_NAME)
604: --
605: -- End of API body
606: --
607:
608: -- Standard check for p_commit
609: IF FND_API.to_Boolean( p_commit )
610: THEN
611: COMMIT WORK;
612: END IF;
621: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
622: END IF;
623:
624:
625: -- Standard call to get message count and if count is 1, get message info.
626: FND_MSG_PUB.Count_And_Get
627: ( p_count => x_msg_count,
628: p_data => x_msg_data
629: );
702: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
703: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Create_Opp_Lines';
704:
705: BEGIN
706: -- Standard Start of API savepoint
707: SAVEPOINT CREATE_OPP_LINES_PUB;
708:
709: -- Standard call to check for call compatibility.
710: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
705: BEGIN
706: -- Standard Start of API savepoint
707: SAVEPOINT CREATE_OPP_LINES_PUB;
708:
709: -- Standard call to check for call compatibility.
710: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
711: p_api_version_number,
712: l_api_name,
713: G_PKG_NAME)
786: --
787: -- End of API body.
788: --
789:
790: -- Standard check for p_commit
791: IF FND_API.to_Boolean( p_commit )
792: THEN
793: COMMIT WORK;
794: END IF;
803: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
804:
805: END IF;
806:
807: -- Standard call to get message count and if count is 1, get message info.
808: FND_MSG_PUB.Count_And_Get
809: ( p_count => x_msg_count,
810: p_data => x_msg_data
811: );
880: l_header_rec Header_Rec_Type := p_header_rec;
881: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
882: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Opp_Lines';
883: BEGIN
884: -- Standard Start of API savepoint
885: SAVEPOINT UPDATE_OPP_LINES_PUB;
886:
887: -- Standard call to check for call compatibility.
888: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
883: BEGIN
884: -- Standard Start of API savepoint
885: SAVEPOINT UPDATE_OPP_LINES_PUB;
886:
887: -- Standard call to check for call compatibility.
888: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
889: p_api_version_number,
890: l_api_name,
891: G_PKG_NAME)
963: --
964: -- End of API body
965: --
966:
967: -- Standard check for p_commit
968: IF FND_API.to_Boolean( p_commit )
969: THEN
970: COMMIT WORK;
971: END IF;
980: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
981:
982: END IF;
983:
984: -- Standard call to get message count and if count is 1, get message info.
985: FND_MSG_PUB.Count_And_Get
986: ( p_count => x_msg_count,
987: p_data => x_msg_data
988: );
1056: l_header_rec Header_Rec_Type := p_header_rec;
1057: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1058: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Opp_Lines';
1059: BEGIN
1060: -- Standard Start of API savepoint
1061: SAVEPOINT DELETE_OPP_LINES_PUB;
1062:
1063: -- Standard call to check for call compatibility.
1064: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1059: BEGIN
1060: -- Standard Start of API savepoint
1061: SAVEPOINT DELETE_OPP_LINES_PUB;
1062:
1063: -- Standard call to check for call compatibility.
1064: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1065: p_api_version_number,
1066: l_api_name,
1067: G_PKG_NAME)
1138: --
1139: -- End of API body
1140: --
1141:
1142: -- Standard check for p_commit
1143: IF FND_API.to_Boolean( p_commit )
1144: THEN
1145: COMMIT WORK;
1146: END IF;
1155: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1156:
1157: END IF;
1158:
1159: -- Standard call to get message count and if count is 1, get message info.
1160: FND_MSG_PUB.Count_And_Get
1161: ( p_count => x_msg_count,
1162: p_data => x_msg_data
1163: );
1222: l_sales_credit_tbl Sales_Credit_Tbl_type := p_sales_credit_tbl;
1223: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1224: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Create_Sales_Credits';
1225: BEGIN
1226: -- Standard Start of API savepoint
1227: SAVEPOINT CREATE_SALES_CREDITS_PUB;
1228:
1229: -- Standard call to check for call compatibility.
1230: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1225: BEGIN
1226: -- Standard Start of API savepoint
1227: SAVEPOINT CREATE_SALES_CREDITS_PUB;
1228:
1229: -- Standard call to check for call compatibility.
1230: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1231: p_api_version_number,
1232: l_api_name,
1233: G_PKG_NAME)
1307: --
1308: -- End of API body.
1309: --
1310:
1311: -- Standard check for p_commit
1312: IF FND_API.to_Boolean( p_commit )
1313: THEN
1314: COMMIT WORK;
1315: END IF;
1323: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1324: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1325: END IF;
1326:
1327: -- Standard call to get message count and if count is 1, get message info.
1328: FND_MSG_PUB.Count_And_Get
1329: ( p_count => x_msg_count,
1330: p_data => x_msg_data
1331: );
1390: l_sales_credit_tbl Sales_Credit_Tbl_type := p_sales_credit_tbl;
1391: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1392: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Sales_Credits';
1393: BEGIN
1394: -- Standard Start of API savepoint
1395: SAVEPOINT UPDATE_SALES_CREDITS_PUB;
1396:
1397: -- Standard call to check for call compatibility.
1398: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1393: BEGIN
1394: -- Standard Start of API savepoint
1395: SAVEPOINT UPDATE_SALES_CREDITS_PUB;
1396:
1397: -- Standard call to check for call compatibility.
1398: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1399: p_api_version_number,
1400: l_api_name,
1401: G_PKG_NAME)
1471: --
1472: -- End of API body
1473: --
1474:
1475: -- Standard check for p_commit
1476: IF FND_API.to_Boolean( p_commit )
1477: THEN
1478: COMMIT WORK;
1479: END IF;
1488: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1489:
1490: END IF;
1491:
1492: -- Standard call to get message count and if count is 1, get message info.
1493: FND_MSG_PUB.Count_And_Get
1494: ( p_count => x_msg_count,
1495: p_data => x_msg_data
1496: );
1556: l_sales_credit_tbl Sales_Credit_Tbl_type := p_sales_credit_tbl;
1557: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1558: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Modify_Sales_Credits';
1559: BEGIN
1560: -- Standard Start of API savepoint
1561: SAVEPOINT MODIFY_SALES_CREDITS_PUB;
1562:
1563: -- Standard call to check for call compatibility.
1564: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1559: BEGIN
1560: -- Standard Start of API savepoint
1561: SAVEPOINT MODIFY_SALES_CREDITS_PUB;
1562:
1563: -- Standard call to check for call compatibility.
1564: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1565: p_api_version_number,
1566: l_api_name,
1567: G_PKG_NAME)
1637: --
1638: -- End of API body
1639: --
1640:
1641: -- Standard check for p_commit
1642: IF FND_API.to_Boolean( p_commit )
1643: THEN
1644: COMMIT WORK;
1645: END IF;
1652:
1653: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1654: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1655: END IF;
1656: -- Standard call to get message count and if count is 1, get message info.
1657: FND_MSG_PUB.Count_And_Get
1658: ( p_count => x_msg_count,
1659: p_data => x_msg_data
1660: );
1719: l_sales_credit_tbl Sales_Credit_Tbl_type := p_sales_credit_tbl;
1720: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1721: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Sales_Credits';
1722: BEGIN
1723: -- Standard Start of API savepoint
1724: SAVEPOINT DELETE_SALES_CREDITS_PUB;
1725:
1726: -- Standard call to check for call compatibility.
1727: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1722: BEGIN
1723: -- Standard Start of API savepoint
1724: SAVEPOINT DELETE_SALES_CREDITS_PUB;
1725:
1726: -- Standard call to check for call compatibility.
1727: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1728: p_api_version_number,
1729: l_api_name,
1730: G_PKG_NAME)
1799: --
1800: -- End of API body
1801: --
1802:
1803: -- Standard check for p_commit
1804: IF FND_API.to_Boolean( p_commit )
1805: THEN
1806: COMMIT WORK;
1807: END IF;
1816: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1817:
1818: END IF;
1819:
1820: -- Standard call to get message count and if count is 1, get message info.
1821: FND_MSG_PUB.Count_And_Get
1822: ( p_count => x_msg_count,
1823: p_data => x_msg_data
1824: );
1883: l_order_tbl Order_Tbl_Type := p_lead_order_tbl;
1884: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1885: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Orders';
1886: BEGIN
1887: -- Standard Start of API savepoint
1888: SAVEPOINT UPDATE_ORDERS_PUB;
1889:
1890: -- Standard call to check for call compatibility.
1891: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1886: BEGIN
1887: -- Standard Start of API savepoint
1888: SAVEPOINT UPDATE_ORDERS_PUB;
1889:
1890: -- Standard call to check for call compatibility.
1891: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1892: p_api_version_number,
1893: l_api_name,
1894: G_PKG_NAME)
1967: --
1968: -- End of API body
1969: --
1970:
1971: -- Standard check for p_commit
1972: IF FND_API.to_Boolean( p_commit )
1973: THEN
1974: COMMIT WORK;
1975: END IF;
1984: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1985:
1986: END IF;
1987:
1988: -- Standard call to get message count and if count is 1, get message info.
1989: FND_MSG_PUB.Count_And_Get
1990: ( p_count => x_msg_count,
1991: p_data => x_msg_data
1992: );
2051: l_order_tbl Order_Tbl_Type := p_lead_order_tbl;
2052: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2053: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Orders';
2054: BEGIN
2055: -- Standard Start of API savepoint
2056: SAVEPOINT DELETE_ORDERS_PUB;
2057:
2058: -- Standard call to check for call compatibility.
2059: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2054: BEGIN
2055: -- Standard Start of API savepoint
2056: SAVEPOINT DELETE_ORDERS_PUB;
2057:
2058: -- Standard call to check for call compatibility.
2059: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2060: p_api_version_number,
2061: l_api_name,
2062: G_PKG_NAME)
2131: --
2132: -- End of API body
2133: --
2134:
2135: -- Standard check for p_commit
2136: IF FND_API.to_Boolean( p_commit )
2137: THEN
2138: COMMIT WORK;
2139: END IF;*/
2148: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2149: END IF;
2150:
2151:
2152: -- Standard call to get message count and if count is 1, get message info.
2153: FND_MSG_PUB.Count_And_Get
2154: ( p_count => x_msg_count,
2155: p_data => x_msg_data
2156: );
2216: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2217: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Create_Competitors';
2218:
2219: BEGIN
2220: -- Standard Start of API savepoint
2221: SAVEPOINT CREATE_COMPETITORS_PUB;
2222:
2223: -- Standard call to check for call compatibility.
2224: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2219: BEGIN
2220: -- Standard Start of API savepoint
2221: SAVEPOINT CREATE_COMPETITORS_PUB;
2222:
2223: -- Standard call to check for call compatibility.
2224: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2225: p_api_version_number,
2226: l_api_name,
2227: G_PKG_NAME)
2298: --
2299: -- End of API body.
2300: --
2301:
2302: -- Standard check for p_commit
2303: IF FND_API.to_Boolean( p_commit )
2304: THEN
2305: COMMIT WORK;
2306: END IF;
2315: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2316:
2317: END IF;
2318:
2319: -- Standard call to get message count and if count is 1, get message info.
2320: FND_MSG_PUB.Count_And_Get
2321: ( p_count => x_msg_count,
2322: p_data => x_msg_data
2323: );
2382: l_competitor_tbl Competitor_Tbl_Type := p_competitor_tbl;
2383: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2384: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Competitors';
2385: BEGIN
2386: -- Standard Start of API savepoint
2387: SAVEPOINT UPDATE_COMPETITORS_PUB;
2388:
2389: -- Standard call to check for call compatibility.
2390: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2385: BEGIN
2386: -- Standard Start of API savepoint
2387: SAVEPOINT UPDATE_COMPETITORS_PUB;
2388:
2389: -- Standard call to check for call compatibility.
2390: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2391: p_api_version_number,
2392: l_api_name,
2393: G_PKG_NAME)
2464: --
2465: -- End of API body
2466: --
2467:
2468: -- Standard check for p_commit
2469: IF FND_API.to_Boolean( p_commit )
2470: THEN
2471: COMMIT WORK;
2472: END IF;
2480: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2481: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2482:
2483: END IF;
2484: -- Standard call to get message count and if count is 1, get message info.
2485: FND_MSG_PUB.Count_And_Get
2486: ( p_count => x_msg_count,
2487: p_data => x_msg_data
2488: );
2547: l_competitor_tbl Competitor_Tbl_Type := p_competitor_tbl;
2548: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2549: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Competitors';
2550: BEGIN
2551: -- Standard Start of API savepoint
2552: SAVEPOINT DELETE_COMPETITORS_PUB;
2553:
2554: -- Standard call to check for call compatibility.
2555: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2550: BEGIN
2551: -- Standard Start of API savepoint
2552: SAVEPOINT DELETE_COMPETITORS_PUB;
2553:
2554: -- Standard call to check for call compatibility.
2555: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2556: p_api_version_number,
2557: l_api_name,
2558: G_PKG_NAME)
2628: --
2629: -- End of API body
2630: --
2631:
2632: -- Standard check for p_commit
2633: IF FND_API.to_Boolean( p_commit )
2634: THEN
2635: COMMIT WORK;
2636: END IF;
2644: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2645: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2646: END IF;
2647:
2648: -- Standard call to get message count and if count is 1, get message info.
2649: FND_MSG_PUB.Count_And_Get
2650: ( p_count => x_msg_count,
2651: p_data => x_msg_data
2652: );
2712: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2713: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Create_Competitor_Prods';
2714:
2715: BEGIN
2716: -- Standard Start of API savepoint
2717: SAVEPOINT CREATE_COMPETITOR_PRODS_PUB;
2718:
2719: -- Standard call to check for call compatibility.
2720: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2715: BEGIN
2716: -- Standard Start of API savepoint
2717: SAVEPOINT CREATE_COMPETITOR_PRODS_PUB;
2718:
2719: -- Standard call to check for call compatibility.
2720: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2721: p_api_version_number,
2722: l_api_name,
2723: G_PKG_NAME)
2795: --
2796: -- End of API body.
2797: --
2798:
2799: -- Standard check for p_commit
2800: IF FND_API.to_Boolean( p_commit )
2801: THEN
2802: COMMIT WORK;
2803: END IF;
2812: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2813: END IF;
2814:
2815:
2816: -- Standard call to get message count and if count is 1, get message info.
2817: FND_MSG_PUB.Count_And_Get
2818: ( p_count => x_msg_count,
2819: p_data => x_msg_data
2820: );
2879: l_competitor_prod_tbl Competitor_Prod_Tbl_Type := p_competitor_prod_tbl;
2880: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2881: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Competitor_Prods';
2882: BEGIN
2883: -- Standard Start of API savepoint
2884: SAVEPOINT UPDATE_COMPETITOR_PRODS_PUB;
2885:
2886: -- Standard call to check for call compatibility.
2887: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2882: BEGIN
2883: -- Standard Start of API savepoint
2884: SAVEPOINT UPDATE_COMPETITOR_PRODS_PUB;
2885:
2886: -- Standard call to check for call compatibility.
2887: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2888: p_api_version_number,
2889: l_api_name,
2890: G_PKG_NAME)
2960: --
2961: -- End of API body
2962: --
2963:
2964: -- Standard check for p_commit
2965: IF FND_API.to_Boolean( p_commit )
2966: THEN
2967: COMMIT WORK;
2968: END IF;
2976: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2977: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2978: END IF;
2979:
2980: -- Standard call to get message count and if count is 1, get message info.
2981: FND_MSG_PUB.Count_And_Get
2982: ( p_count => x_msg_count,
2983: p_data => x_msg_data
2984: );
3043: l_competitor_prod_tbl Competitor_Prod_Tbl_Type := p_competitor_prod_tbl;
3044: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3045: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Competitor_Prods';
3046: BEGIN
3047: -- Standard Start of API savepoint
3048: SAVEPOINT DELETE_COMPETITOR_PRODS_PUB;
3049:
3050: -- Standard call to check for call compatibility.
3051: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3046: BEGIN
3047: -- Standard Start of API savepoint
3048: SAVEPOINT DELETE_COMPETITOR_PRODS_PUB;
3049:
3050: -- Standard call to check for call compatibility.
3051: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3052: p_api_version_number,
3053: l_api_name,
3054: G_PKG_NAME)
3124: --
3125: -- End of API body
3126: --
3127:
3128: -- Standard check for p_commit
3129: IF FND_API.to_Boolean( p_commit )
3130: THEN
3131: COMMIT WORK;
3132: END IF;
3141: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3142: END IF;
3143:
3144:
3145: -- Standard call to get message count and if count is 1, get message info.
3146: FND_MSG_PUB.Count_And_Get
3147: ( p_count => x_msg_count,
3148: p_data => x_msg_data
3149: );
3208: l_decision_factor_tbl Decision_Factor_Tbl_Type := p_decision_factor_tbl;
3209: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3210: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Create_Decision_Factors';
3211: BEGIN
3212: -- Standard Start of API savepoint
3213: SAVEPOINT CREATE_DECISION_FACTORS_PUB;
3214:
3215: -- Standard call to check for call compatibility.
3216: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3211: BEGIN
3212: -- Standard Start of API savepoint
3213: SAVEPOINT CREATE_DECISION_FACTORS_PUB;
3214:
3215: -- Standard call to check for call compatibility.
3216: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3217: p_api_version_number,
3218: l_api_name,
3219: G_PKG_NAME)
3291: --
3292: -- End of API body.
3293: --
3294:
3295: -- Standard check for p_commit
3296: IF FND_API.to_Boolean( p_commit )
3297: THEN
3298: COMMIT WORK;
3299: END IF;
3308: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3309: END IF;
3310:
3311:
3312: -- Standard call to get message count and if count is 1, get message info.
3313: FND_MSG_PUB.Count_And_Get
3314: ( p_count => x_msg_count,
3315: p_data => x_msg_data
3316: );
3375: l_decision_factor_tbl Decision_Factor_Tbl_Type := p_decision_factor_tbl;
3376: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3377: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Decision_Factors';
3378: BEGIN
3379: -- Standard Start of API savepoint
3380: SAVEPOINT UPDATE_DECISION_FACTORS_PUB;
3381:
3382: -- Standard call to check for call compatibility.
3383: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3378: BEGIN
3379: -- Standard Start of API savepoint
3380: SAVEPOINT UPDATE_DECISION_FACTORS_PUB;
3381:
3382: -- Standard call to check for call compatibility.
3383: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3384: p_api_version_number,
3385: l_api_name,
3386: G_PKG_NAME)
3455: --
3456: -- End of API body
3457: --
3458:
3459: -- Standard check for p_commit
3460: IF FND_API.to_Boolean( p_commit )
3461: THEN
3462: COMMIT WORK;
3463: END IF;
3472: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3473: END IF;
3474:
3475:
3476: -- Standard call to get message count and if count is 1, get message info.
3477: FND_MSG_PUB.Count_And_Get
3478: ( p_count => x_msg_count,
3479: p_data => x_msg_data
3480: );
3539: l_decision_factor_tbl Decision_Factor_Tbl_Type := p_decision_factor_tbl;
3540: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3541: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Decision_Factors';
3542: BEGIN
3543: -- Standard Start of API savepoint
3544: SAVEPOINT DELETE_DECISION_FACTORS_PUB;
3545:
3546: -- Standard call to check for call compatibility.
3547: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3542: BEGIN
3543: -- Standard Start of API savepoint
3544: SAVEPOINT DELETE_DECISION_FACTORS_PUB;
3545:
3546: -- Standard call to check for call compatibility.
3547: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3548: p_api_version_number,
3549: l_api_name,
3550: G_PKG_NAME)
3620: --
3621: -- End of API body
3622: --
3623:
3624: -- Standard check for p_commit
3625: IF FND_API.to_Boolean( p_commit )
3626: THEN
3627: COMMIT WORK;
3628: END IF;
3637: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3638: END IF;
3639:
3640:
3641: -- Standard call to get message count and if count is 1, get message info.
3642: FND_MSG_PUB.Count_And_Get
3643: ( p_count => x_msg_count,
3644: p_data => x_msg_data
3645: );
3706: l_contact_tbl Contact_Tbl_type := p_contact_tbl;
3707: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3708: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Create_Contacts';
3709: BEGIN
3710: -- Standard Start of API savepoint
3711: SAVEPOINT CREATE_CONTACTS_PUB;
3712:
3713: -- Standard call to check for call compatibility.
3714: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3709: BEGIN
3710: -- Standard Start of API savepoint
3711: SAVEPOINT CREATE_CONTACTS_PUB;
3712:
3713: -- Standard call to check for call compatibility.
3714: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3715: p_api_version_number,
3716: l_api_name,
3717: G_PKG_NAME)
3788: --
3789: -- End of API body.
3790: --
3791:
3792: -- Standard check for p_commit
3793: IF FND_API.to_Boolean( p_commit )
3794: THEN
3795: COMMIT WORK;
3796: END IF;
3805: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3806:
3807: END IF;
3808:
3809: -- Standard call to get message count and if count is 1, get message info.
3810: FND_MSG_PUB.Count_And_Get
3811: ( p_count => x_msg_count,
3812: p_data => x_msg_data
3813: );
3872: l_contact_tbl Contact_Tbl_Type := p_contact_tbl;
3873: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3874: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Contacts';
3875: BEGIN
3876: -- Standard Start of API savepoint
3877: SAVEPOINT UPDATE_CONTACTS_PUB;
3878:
3879: -- Standard call to check for call compatibility.
3880: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3875: BEGIN
3876: -- Standard Start of API savepoint
3877: SAVEPOINT UPDATE_CONTACTS_PUB;
3878:
3879: -- Standard call to check for call compatibility.
3880: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3881: p_api_version_number,
3882: l_api_name,
3883: G_PKG_NAME)
3953: --
3954: -- End of API body
3955: --
3956:
3957: -- Standard check for p_commit
3958: IF FND_API.to_Boolean( p_commit )
3959: THEN
3960: COMMIT WORK;
3961: END IF;
3970: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3971: END IF;
3972:
3973:
3974: -- Standard call to get message count and if count is 1, get message info.
3975: FND_MSG_PUB.Count_And_Get
3976: ( p_count => x_msg_count,
3977: p_data => x_msg_data
3978: );
4038: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
4039: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Contacts';
4040:
4041: BEGIN
4042: -- Standard Start of API savepoint
4043: SAVEPOINT DELETE_CONTACTS_PUB;
4044:
4045: -- Standard call to check for call compatibility.
4046: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4041: BEGIN
4042: -- Standard Start of API savepoint
4043: SAVEPOINT DELETE_CONTACTS_PUB;
4044:
4045: -- Standard call to check for call compatibility.
4046: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4047: p_api_version_number,
4048: l_api_name,
4049: G_PKG_NAME)
4119: --
4120: -- End of API body
4121: --
4122:
4123: -- Standard check for p_commit
4124: IF FND_API.to_Boolean( p_commit )
4125: THEN
4126: COMMIT WORK;
4127: END IF;
4136: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4137: END IF;
4138:
4139:
4140: -- Standard call to get message count and if count is 1, get message info.
4141: FND_MSG_PUB.Count_And_Get
4142: ( p_count => x_msg_count,
4143: p_data => x_msg_data
4144: );
4203: l_obstacle_tbl Obstacle_Tbl_Type := p_obstacle_tbl;
4204: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
4205: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Create_Obstacles';
4206: BEGIN
4207: -- Standard Start of API savepoint
4208: SAVEPOINT CREATE_OBSTACLES_PUB;
4209:
4210: -- Standard call to check for call compatibility.
4211: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4206: BEGIN
4207: -- Standard Start of API savepoint
4208: SAVEPOINT CREATE_OBSTACLES_PUB;
4209:
4210: -- Standard call to check for call compatibility.
4211: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4212: p_api_version_number,
4213: l_api_name,
4214: G_PKG_NAME)
4287: --
4288: -- End of API body.
4289: --
4290:
4291: -- Standard check for p_commit
4292: IF FND_API.to_Boolean( p_commit )
4293: THEN
4294: COMMIT WORK;
4295: END IF;
4304: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4305:
4306: END IF;
4307:
4308: -- Standard call to get message count and if count is 1, get message info.
4309: FND_MSG_PUB.Count_And_Get
4310: ( p_count => x_msg_count,
4311: p_data => x_msg_data
4312: );
4372: l_obstacle_tbl Obstacle_Tbl_Type := p_obstacle_tbl;
4373: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
4374: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Obstacles';
4375: BEGIN
4376: -- Standard Start of API savepoint
4377: SAVEPOINT UPDATE_OBSTACLES_PUB;
4378:
4379: -- Standard call to check for call compatibility.
4380: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4375: BEGIN
4376: -- Standard Start of API savepoint
4377: SAVEPOINT UPDATE_OBSTACLES_PUB;
4378:
4379: -- Standard call to check for call compatibility.
4380: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4381: p_api_version_number,
4382: l_api_name,
4383: G_PKG_NAME)
4453: --
4454: -- End of API body
4455: --
4456:
4457: -- Standard check for p_commit
4458: IF FND_API.to_Boolean( p_commit )
4459: THEN
4460: COMMIT WORK;
4461: END IF;
4470: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4471: END IF;
4472:
4473:
4474: -- Standard call to get message count and if count is 1, get message info.
4475: FND_MSG_PUB.Count_And_Get
4476: ( p_count => x_msg_count,
4477: p_data => x_msg_data
4478: );
4537: l_obstacle_tbl Obstacle_Tbl_Type := p_obstacle_tbl;
4538: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
4539: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Obstacles';
4540: BEGIN
4541: -- Standard Start of API savepoint
4542: SAVEPOINT DELETE_OBSTACLES_PUB;
4543:
4544: -- Standard call to check for call compatibility.
4545: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4540: BEGIN
4541: -- Standard Start of API savepoint
4542: SAVEPOINT DELETE_OBSTACLES_PUB;
4543:
4544: -- Standard call to check for call compatibility.
4545: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4546: p_api_version_number,
4547: l_api_name,
4548: G_PKG_NAME)
4619: --
4620: -- End of API body
4621: --
4622:
4623: -- Standard check for p_commit
4624: IF FND_API.to_Boolean( p_commit )
4625: THEN
4626: COMMIT WORK;
4627: END IF;
4636: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4637: END IF;
4638:
4639:
4640: -- Standard call to get message count and if count is 1, get message info.
4641: FND_MSG_PUB.Count_And_Get
4642: ( p_count => x_msg_count,
4643: p_data => x_msg_data
4644: );
4730: l_line_count CONSTANT NUMBER := p_sales_team_tbl.count;
4731: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
4732: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_SalesTeams';
4733: BEGIN
4734: -- Standard Start of API savepoint
4735: SAVEPOINT DELETE_SALESTEAMS_PUB;
4736:
4737: -- Standard call to check for call compatibility.
4738: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4733: BEGIN
4734: -- Standard Start of API savepoint
4735: SAVEPOINT DELETE_SALESTEAMS_PUB;
4736:
4737: -- Standard call to check for call compatibility.
4738: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4739: p_api_version_number,
4740: l_api_name,
4741: G_PKG_NAME)
4868: --
4869: -- End of API body
4870: --
4871:
4872: -- Standard check for p_commit
4873: IF FND_API.to_Boolean( p_commit )
4874: THEN
4875: COMMIT WORK;
4876: END IF;
4885: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4886:
4887: END IF;
4888:
4889: -- Standard call to get message count and if count is 1, get message info.
4890: FND_MSG_PUB.Count_And_Get
4891: ( p_count => x_msg_count,
4892: p_data => x_msg_data
4893: );
4973: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
4974: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Copy_Opportunity';
4975:
4976: BEGIN
4977: -- Standard Start of API savepoint
4978: SAVEPOINT COPY_OPPORTUNITY_PUB;
4979:
4980: -- Standard call to check for call compatibility.
4981: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4976: BEGIN
4977: -- Standard Start of API savepoint
4978: SAVEPOINT COPY_OPPORTUNITY_PUB;
4979:
4980: -- Standard call to check for call compatibility.
4981: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4982: p_api_version_number,
4983: l_api_name,
4984: G_PKG_NAME)
5051: --
5052: -- End of API body.
5053: --
5054:
5055: -- Standard check for p_commit
5056: IF FND_API.to_Boolean( p_commit )
5057: THEN
5058: COMMIT WORK;
5059: END IF;
5067: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5068: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
5069: END IF;
5070:
5071: -- Standard call to get message count and if count is 1, get message info.
5072: FND_MSG_PUB.Count_And_Get
5073: ( p_count => x_msg_count,
5074: p_data => x_msg_data
5075: );