DBA Data[Home] [Help]

APPS.AS_OPP_HEADER_PVT dependencies on STANDARD

Line 702: -- Standard Start of API savepoint

698: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
699: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldhpv.Create_opp_header';
700:
701: BEGIN
702: -- Standard Start of API savepoint
703: SAVEPOINT CREATE_OPP_HEADER_PVT;
704:
705: -- Standard call to check for call compatibility.
706: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

701: BEGIN
702: -- Standard Start of API savepoint
703: SAVEPOINT CREATE_OPP_HEADER_PVT;
704:
705: -- Standard call to check for call compatibility.
706: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
707: p_api_version_number,
708: l_api_name,
709: G_PKG_NAME)

Line 1325: -- Standard check for p_commit

1321: --
1322: -- End of API body
1323: --
1324:
1325: -- Standard check for p_commit
1326: IF FND_API.to_Boolean( p_commit )
1327: THEN
1328: COMMIT WORK;
1329: END IF;

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

1335: END IF;
1336:
1337:
1338:
1339: -- Standard call to get message count and if count is 1, get message info.
1340: FND_MSG_PUB.Count_And_Get
1341: ( p_count => x_msg_count,
1342: p_data => x_msg_data
1343: );

Line 1533: -- Standard Start of API savepoint

1529: x_lead_id NUMBER;
1530: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldhpv.Update_opp_header';
1531:
1532: BEGIN
1533: -- Standard Start of API savepoint
1534: SAVEPOINT UPDATE_OPP_HEADER_PVT;
1535:
1536: -- Standard call to check for call compatibility.
1537: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1532: BEGIN
1533: -- Standard Start of API savepoint
1534: SAVEPOINT UPDATE_OPP_HEADER_PVT;
1535:
1536: -- Standard call to check for call compatibility.
1537: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1538: p_api_version_number,
1539: l_api_name,
1540: G_PKG_NAME)

Line 2405: -- Standard check for p_commit

2401: --
2402: -- End of API body.
2403: --
2404:
2405: -- Standard check for p_commit
2406: IF FND_API.to_Boolean( p_commit )
2407: THEN
2408: COMMIT WORK;
2409: END IF;

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

2415: 'Private API: ' || l_api_name || ' end');
2416: END IF;
2417:
2418:
2419: -- Standard call to get message count and if count is 1, get message info.
2420: FND_MSG_PUB.Count_And_Get
2421: ( p_count => x_msg_count,
2422: p_data => x_msg_data
2423: );

Line 2526: -- Standard Start of API savepoint

2522: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2523: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldhpv.Delete_opp_header';
2524:
2525: BEGIN
2526: -- Standard Start of API savepoint
2527: SAVEPOINT DELETE_OPP_HEADER_PVT;
2528:
2529: -- Standard call to check for call compatibility.
2530: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

2525: BEGIN
2526: -- Standard Start of API savepoint
2527: SAVEPOINT DELETE_OPP_HEADER_PVT;
2528:
2529: -- Standard call to check for call compatibility.
2530: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2531: p_api_version_number,
2532: l_api_name,
2533: G_PKG_NAME)

Line 2826: -- Standard check for p_commit

2822: --
2823: -- End of API body.
2824: --
2825:
2826: -- Standard check for p_commit
2827: IF FND_API.to_Boolean( p_commit )
2828: THEN
2829: COMMIT WORK;
2830: END IF;

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

2837: END IF;
2838:
2839:
2840:
2841: -- Standard call to get message count and if count is 1, get message info.
2842: FND_MSG_PUB.Count_And_Get
2843: ( p_count => x_msg_count,
2844: p_data => x_msg_data
2845: );

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

2997: CLOSE C_Lead_Id_Exists;
2998: END IF;
2999: END IF;
3000:
3001: -- Standard call to get message count and if count is 1, get message info.
3002: FND_MSG_PUB.Count_And_Get
3003: ( p_count => x_msg_count,
3004: p_data => x_msg_data
3005: );

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

3085: CLOSE C_LEAD_NUMBER_Exists;
3086: END IF;
3087: END IF;
3088:
3089: -- Standard call to get message count and if count is 1, get message info.
3090: FND_MSG_PUB.Count_And_Get
3091: ( p_count => x_msg_count,
3092: p_data => x_msg_data
3093: );

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

3179: CLOSE C_STATUS_Exists;
3180: END IF;
3181: END IF;
3182:
3183: -- Standard call to get message count and if count is 1, get message info.
3184: FND_MSG_PUB.Count_And_Get
3185: ( p_count => x_msg_count,
3186: p_data => x_msg_data
3187: );

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

3236:
3237: CLOSE C_ORG_ID_Exists;
3238: END IF;
3239:
3240: -- Standard call to get message count and if count is 1, get message info.
3241: FND_MSG_PUB.Count_And_Get
3242: ( p_count => x_msg_count,
3243: p_data => x_msg_data
3244: );

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

3305:
3306: CLOSE C_SALES_STAGE_ID_Exists;
3307: END IF;
3308:
3309: -- Standard call to get message count and if count is 1, get message info.
3310: FND_MSG_PUB.Count_And_Get
3311: ( p_count => x_msg_count,
3312: p_data => x_msg_data
3313: );

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

3373:
3374: CLOSE C_CHANNEL_CODE_Exists;
3375: END IF;
3376:
3377: -- Standard call to get message count and if count is 1, get message info.
3378: FND_MSG_PUB.Count_And_Get
3379: ( p_count => x_msg_count,
3380: p_data => x_msg_data
3381: );

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

3442:
3443: CLOSE C_Currency_Exists;
3444: END IF;
3445:
3446: -- Standard call to get message count and if count is 1, get message info.
3447: FND_MSG_PUB.Count_And_Get
3448: ( p_count => x_msg_count,
3449: p_data => x_msg_data
3450: );

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

3511:
3512: CLOSE C_Win_Prob_Exists;
3513: END IF;
3514:
3515: -- Standard call to get message count and if count is 1, get message info.
3516: FND_MSG_PUB.Count_And_Get
3517: ( p_count => x_msg_count,
3518: p_data => x_msg_data
3519: );

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

3577:
3578: CLOSE C_CLOSE_REASON_Exists;
3579: END IF;
3580:
3581: -- Standard call to get message count and if count is 1, get message info.
3582: FND_MSG_PUB.Count_And_Get
3583: ( p_count => x_msg_count,
3584: p_data => x_msg_data
3585: );

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

3658:
3659: CLOSE C_SOURCE_PROMOTION_ID_Exists;
3660: END IF;
3661:
3662: -- Standard call to get message count and if count is 1, get message info.
3663: FND_MSG_PUB.Count_And_Get
3664: ( p_count => x_msg_count,
3665: p_data => x_msg_data
3666: );

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

3712: x_return_status := FND_API.G_RET_STS_ERROR;
3713: END IF;
3714: END IF;
3715:
3716: -- Standard call to get message count and if count is 1, get message info.
3717: FND_MSG_PUB.Count_And_Get
3718: ( p_count => x_msg_count,
3719: p_data => x_msg_data
3720: );

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

3763: x_return_status := FND_API.G_RET_STS_ERROR;
3764: END IF;
3765: END IF;
3766:
3767: -- Standard call to get message count and if count is 1, get message info.
3768: FND_MSG_PUB.Count_And_Get
3769: ( p_count => x_msg_count,
3770: p_data => x_msg_data
3771: );

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

3827:
3828: CLOSE C_LEAD_SOURCE_CODE_Exists;
3829: END IF;
3830:
3831: -- Standard call to get message count and if count is 1, get message info.
3832: FND_MSG_PUB.Count_And_Get
3833: ( p_count => x_msg_count,
3834: p_data => x_msg_data
3835: );

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

3893:
3894: CLOSE C_Price_List_Exists;
3895: END IF;
3896:
3897: -- Standard call to get message count and if count is 1, get message info.
3898: FND_MSG_PUB.Count_And_Get
3899: ( p_count => x_msg_count,
3900: p_data => x_msg_data
3901: );

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

3946: x_return_status := FND_API.G_RET_STS_ERROR;
3947: END IF;
3948: END IF;
3949:
3950: -- Standard call to get message count and if count is 1, get message info.
3951: FND_MSG_PUB.Count_And_Get
3952: ( p_count => x_msg_count,
3953: p_data => x_msg_data
3954: );

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

4014:
4015: CLOSE C_METHODOLOGY_CODE_Exists;
4016: END IF;
4017:
4018: -- Standard call to get message count and if count is 1, get message info.
4019: FND_MSG_PUB.Count_And_Get
4020: ( p_count => x_msg_count,
4021: p_data => x_msg_data
4022: );

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

4078:
4079: CLOSE C_ORIGINAL_LEAD_ID_Exists;
4080: END IF;
4081:
4082: -- Standard call to get message count and if count is 1, get message info.
4083: FND_MSG_PUB.Count_And_Get
4084: ( p_count => x_msg_count,
4085: p_data => x_msg_data
4086: );

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

4145:
4146: CLOSE C_DECN_TIMEFRAME_Exists;
4147: END IF;
4148:
4149: -- Standard call to get message count and if count is 1, get message info.
4150: FND_MSG_PUB.Count_And_Get
4151: ( p_count => x_msg_count,
4152: p_data => x_msg_data
4153: );

Line 4230: -- Standard call to get message count and IF count is 1, get message info.

4226: END IF;
4227: CLOSE C_OFFER_ID_Exists;
4228: END IF;
4229:
4230: -- Standard call to get message count and IF count is 1, get message info.
4231: FND_MSG_PUB.Count_And_Get
4232: ( p_count => x_msg_count,
4233: p_data => x_msg_data
4234: );

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

4294:
4295: CLOSE C_VEHICLE_RESPONSE_Exists;
4296: END IF;
4297:
4298: -- Standard call to get message count and if count is 1, get message info.
4299: FND_MSG_PUB.Count_And_Get
4300: ( p_count => x_msg_count,
4301: p_data => x_msg_data
4302: );

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

4359:
4360: CLOSE C_BUDGET_STATUS_Exists;
4361: END IF;
4362:
4363: -- Standard call to get message count and if count is 1, get message info.
4364: FND_MSG_PUB.Count_And_Get
4365: ( p_count => x_msg_count,
4366: p_data => x_msg_data
4367: );

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

4423:
4424: CLOSE C_PRM_LEAD_TYPE_Exists;
4425: END IF;
4426:
4427: -- Standard call to get message count and if count is 1, get message info.
4428: FND_MSG_PUB.Count_And_Get
4429: ( p_count => x_msg_count,
4430: p_data => x_msg_data
4431: );

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

4534:
4535: END IF;
4536: END IF;
4537:
4538: -- Standard call to get message count and if count is 1, get message info.
4539: FND_MSG_PUB.Count_And_Get
4540: ( p_count => x_msg_count,
4541: p_data => x_msg_data
4542: );

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

4604:
4605: END IF;
4606: END IF;
4607:
4608: -- Standard call to get message count and if count is 1, get message info.
4609: FND_MSG_PUB.Count_And_Get
4610: ( p_count => x_msg_count,
4611: p_data => x_msg_data
4612: );

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

4660:
4661: END IF;
4662: END IF;
4663:
4664: -- Standard call to get message count and if count is 1, get message info.
4665: FND_MSG_PUB.Count_And_Get
4666: ( p_count => x_msg_count,
4667: p_data => x_msg_data
4668: );

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

4716:
4717: END IF;
4718: END IF;
4719:
4720: -- Standard call to get message count and if count is 1, get message info.
4721: FND_MSG_PUB.Count_And_Get
4722: ( p_count => x_msg_count,
4723: p_data => x_msg_data
4724: );

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

4812: x_return_status := FND_API.G_RET_STS_ERROR;
4813: END IF;
4814: END IF;
4815:
4816: -- Standard call to get message count and if count is 1, get message info.
4817: FND_MSG_PUB.Count_And_Get
4818: ( p_count => x_msg_count,
4819: p_data => x_msg_data
4820: );

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

4885: END IF;
4886: END IF;
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: );

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

5017: x_return_status := FND_API.G_RET_STS_ERROR;
5018: END IF;
5019: CLOSE VALIDATE_COMBINATION;
5020:
5021: -- Standard call to get message count and if count is 1, get message info.
5022: FND_MSG_PUB.Count_And_Get
5023: ( p_count => x_msg_count,
5024: p_data => x_msg_data
5025: );

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

5081:
5082: CLOSE C_AUTO_ASGN_TYPE_Exists;
5083: END IF;
5084:
5085: -- Standard call to get message count and if count is 1, get message info.
5086: FND_MSG_PUB.Count_And_Get
5087: ( p_count => x_msg_count,
5088: p_data => x_msg_data
5089: );

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

5144:
5145: CLOSE C_PRM_ASGN_TYPE_Exists;
5146: END IF;
5147:
5148: -- Standard call to get message count and if count is 1, get message info.
5149: FND_MSG_PUB.Count_And_Get
5150: ( p_count => x_msg_count,
5151: p_data => x_msg_data
5152: );

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

5206:
5207: CLOSE C_RESOURCE_ID_Exists;
5208: END IF;
5209:
5210: -- Standard call to get message count and if count is 1, get message info.
5211: FND_MSG_PUB.Count_And_Get
5212: ( p_count => x_msg_count,
5213: p_data => x_msg_data
5214: );

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

5271:
5272: CLOSE C_PRM_IND_CLS_CODE_Exists;
5273: END IF;
5274:
5275: -- Standard call to get message count and if count is 1, get message info.
5276: FND_MSG_PUB.Count_And_Get
5277: ( p_count => x_msg_count,
5278: p_data => x_msg_data
5279: );

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

5321: x_return_status := FND_API.G_RET_STS_ERROR;
5322: END IF;
5323: END IF;
5324:
5325: -- Standard call to get message count and if count is 1, get message info.
5326: FND_MSG_PUB.Count_And_Get
5327: ( p_count => x_msg_count,
5328: p_data => x_msg_data
5329: );

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

5371: x_return_status := FND_API.G_RET_STS_ERROR;
5372: END IF;
5373: END IF;
5374:
5375: -- Standard call to get message count and if count is 1, get message info.
5376: FND_MSG_PUB.Count_And_Get
5377: ( p_count => x_msg_count,
5378: p_data => x_msg_data
5379: );

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

5457: x_return_status := FND_API.G_RET_STS_ERROR;
5458: END IF;
5459: END IF;
5460:
5461: -- Standard call to get message count and if count is 1, get message info.
5462: FND_MSG_PUB.Count_And_Get
5463: ( p_count => x_msg_count,
5464: p_data => x_msg_data
5465: );

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

5652: END IF;
5653:
5654: END IF;
5655:
5656: -- Standard call to get message count and if count is 1, get message info.
5657: FND_MSG_PUB.Count_And_Get
5658: ( p_count => x_msg_count,
5659: p_data => x_msg_data
5660: );

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

5738: CLOSE C_Get_OppOpenStatusFlag;
5739: END IF;
5740: END IF;
5741:
5742: -- Standard call to get message count and if count is 1, get message info.
5743: FND_MSG_PUB.Count_And_Get
5744: ( p_count => x_msg_count,
5745: p_data => x_msg_data
5746: );

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

5791: END IF;
5792: END IF;
5793:
5794:
5795: -- Standard call to get message count and if count is 1, get message info.
5796: FND_MSG_PUB.Count_And_Get
5797: ( p_count => x_msg_count,
5798: p_data => x_msg_data
5799: );

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

5851: x_return_status := FND_API.G_RET_STS_ERROR;
5852: END IF;
5853: END IF;
5854:
5855: -- Standard call to get message count and if count is 1, get message info.
5856: FND_MSG_PUB.Count_And_Get
5857: ( p_count => x_msg_count,
5858: p_data => x_msg_data
5859: );

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

6619: 'Private API: ' || l_api_name || ' end');
6620:
6621: END IF;
6622:
6623: -- Standard call to get message count and if count is 1, get message info.
6624: FND_MSG_PUB.Count_And_Get
6625: ( p_count => x_msg_count,
6626: p_data => x_msg_data
6627: );