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 1326: -- Standard check for p_commit

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

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

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

Line 1534: -- Standard Start of API savepoint

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

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

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

Line 2406: -- Standard check for p_commit

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

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

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

Line 2527: -- Standard Start of API savepoint

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

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

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

Line 2827: -- Standard check for p_commit

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

4886: END IF;
4887: END IF;
4888: END IF;
4889:
4890: -- Standard call to get message count and if count is 1, get message info.
4891: FND_MSG_PUB.Count_And_Get
4892: ( p_count => x_msg_count,
4893: p_data => x_msg_data
4894: );

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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