eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_COMPETITOR_PROD_PVT dependencies on FND_API

Line 82: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

78:
79: -- Hint: Primary key needs to be returned.
80: PROCEDURE Create_competitor_prods(
81: P_Api_Version_Number IN NUMBER,
82: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
83: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
84: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
85: P_Admin_Group_Id IN NUMBER,
86: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,

Line 83: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

79: -- Hint: Primary key needs to be returned.
80: PROCEDURE Create_competitor_prods(
81: P_Api_Version_Number IN NUMBER,
82: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
83: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
84: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
85: P_Admin_Group_Id IN NUMBER,
86: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
87: P_Competitor_Prod_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_Tbl_Type :=

Line 84: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

80: PROCEDURE Create_competitor_prods(
81: P_Api_Version_Number IN NUMBER,
82: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
83: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
84: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
85: P_Admin_Group_Id IN NUMBER,
86: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
87: P_Competitor_Prod_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_Tbl_Type :=
88: AS_OPPORTUNITY_PUB.G_MISS_Competitor_Prod_Tbl,

Line 90: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,

86: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
87: P_Competitor_Prod_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_Tbl_Type :=
88: AS_OPPORTUNITY_PUB.G_MISS_Competitor_Prod_Tbl,
89: X_competitor_prod_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_prod_out_tbl_type,
90: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
91: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
92: P_Identity_Salesforce_Id IN NUMBER := NULL,
93: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
94: X_Return_Status OUT NOCOPY VARCHAR2,

Line 91: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

87: P_Competitor_Prod_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_Tbl_Type :=
88: AS_OPPORTUNITY_PUB.G_MISS_Competitor_Prod_Tbl,
89: X_competitor_prod_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_prod_out_tbl_type,
90: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
91: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
92: P_Identity_Salesforce_Id IN NUMBER := NULL,
93: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
94: X_Return_Status OUT NOCOPY VARCHAR2,
95: X_Msg_Count OUT NOCOPY NUMBER,

Line 93: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,

89: X_competitor_prod_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_prod_out_tbl_type,
90: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
91: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
92: P_Identity_Salesforce_Id IN NUMBER := NULL,
93: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
94: X_Return_Status OUT NOCOPY VARCHAR2,
95: X_Msg_Count OUT NOCOPY NUMBER,
96: X_Msg_Data OUT NOCOPY VARCHAR2
97: )

Line 123: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

119: -- Standard Start of API savepoint
120: SAVEPOINT CREATE_COMPETITOR_PRODS_PVT;
121:
122: -- Standard call to check for call compatibility.
123: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
124: p_api_version_number,
125: l_api_name,
126: G_PKG_NAME)
127: THEN

Line 128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

124: p_api_version_number,
125: l_api_name,
126: G_PKG_NAME)
127: THEN
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129: END IF;
130:
131:
132: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 133: IF FND_API.to_Boolean( p_init_msg_list )

129: END IF;
130:
131:
132: -- Initialize message list if p_init_msg_list is set to TRUE.
133: IF FND_API.to_Boolean( p_init_msg_list )
134: THEN
135: FND_MSG_PUB.initialize;
136: END IF;
137:

Line 146: x_return_status := FND_API.G_RET_STS_SUCCESS;

142: 'Private API: ' || l_api_name || ' start');
143: END IF;
144:
145: -- Initialize API return status to SUCCESS
146: x_return_status := FND_API.G_RET_STS_SUCCESS;
147:
148: --
149: -- API body
150: --

Line 160: p_init_msg_list => FND_API.G_FALSE,

156: IF(FND_PROFILE.VALUE('AS_PRE_CUSTOM_ENABLED')='Y')
157: THEN
158: AS_CALLOUT_PKG.Create_competitor_prods_BC(
159: p_api_version_number => 2.0,
160: p_init_msg_list => FND_API.G_FALSE,
161: p_commit => FND_API.G_FALSE,
162: p_validation_level => p_validation_level,
163: P_Competitor_Prod_Rec => P_Competitor_Prod_Rec,
164: -- Hint: Add detail tables as parameter lists if it's master-detail

Line 161: p_commit => FND_API.G_FALSE,

157: THEN
158: AS_CALLOUT_PKG.Create_competitor_prods_BC(
159: p_api_version_number => 2.0,
160: p_init_msg_list => FND_API.G_FALSE,
161: p_commit => FND_API.G_FALSE,
162: p_validation_level => p_validation_level,
163: P_Competitor_Prod_Rec => P_Competitor_Prod_Rec,
164: -- Hint: Add detail tables as parameter lists if it's master-detail
165: -- relationship.

Line 185: RAISE FND_API.G_EXC_ERROR;

181: 'UT_CANNOT_GET_PROFILE_VALUE');
182: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
183: FND_MSG_PUB.ADD;
184: END IF;
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187:
188: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN
189: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(

Line 188: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN

184: END IF;
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187:
188: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN
189: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
190: p_api_version_number => 2.0
191: ,p_init_msg_list => p_init_msg_list
192: ,p_salesforce_id => p_identity_salesforce_id

Line 200: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

196: ,x_msg_data => x_msg_data
197: ,x_sales_member_rec => l_identity_sales_member_rec);
198: END IF;
199:
200: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
201: RAISE FND_API.G_EXC_ERROR;
202: END IF;
203:
204: -- Call Get_Access_Profiles to get access_profile_rec

Line 201: RAISE FND_API.G_EXC_ERROR;

197: ,x_sales_member_rec => l_identity_sales_member_rec);
198: END IF;
199:
200: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
201: RAISE FND_API.G_EXC_ERROR;
202: END IF;
203:
204: -- Call Get_Access_Profiles to get access_profile_rec
205: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

Line 235: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

231: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
232: 'API_NO_UPDATE_PRIVILEGE');
233: END IF;
234:
235: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
236: RAISE FND_API.G_EXC_ERROR;
237: END IF;
238: END IF;
239:

Line 236: RAISE FND_API.G_EXC_ERROR;

232: 'API_NO_UPDATE_PRIVILEGE');
233: END IF;
234:
235: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
236: RAISE FND_API.G_EXC_ERROR;
237: END IF;
238: END IF;
239:
240: FOR l_curr_row IN 1..l_line_count LOOP

Line 242: FND_API.G_RET_STS_SUCCESS ;

238: END IF;
239:
240: FOR l_curr_row IN 1..l_line_count LOOP
241: X_competitor_prod_out_tbl(l_curr_row).return_status :=
242: FND_API.G_RET_STS_SUCCESS ;
243:
244: -- Progress Message
245: --
246: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 267: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL )

263: IF (l_opp_won) THEN
264: l_competitor_prod_rec.WIN_LOSS_STATUS := 'LOST';
265: END IF;
266:
267: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL )
268: THEN
269: -- Debug message
270: IF l_debug THEN
271: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 278: P_Init_Msg_List => FND_API.G_FALSE,

274: END IF;
275:
276: -- Invoke validation procedures
277: Validate_competitor_prod(
278: P_Init_Msg_List => FND_API.G_FALSE,
279: P_Validation_Level => p_validation_level,
280: P_Validation_Mode => AS_UTILITY_PVT.G_CREATE,
281: P_Competitor_Prod_Rec => l_Competitor_Prod_Rec,
282: x_return_status => x_return_status,

Line 288: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

284: x_msg_data => x_msg_data
285: );
286: END IF;
287:
288: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
289: RAISE FND_API.G_EXC_ERROR;
290: END IF;
291: /*
292: IF check_dup( p_Competitor_Prod_rec => l_Competitor_Prod_rec ) THEN

Line 289: RAISE FND_API.G_EXC_ERROR;

285: );
286: END IF;
287:
288: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
289: RAISE FND_API.G_EXC_ERROR;
290: END IF;
291: /*
292: IF check_dup( p_Competitor_Prod_rec => l_Competitor_Prod_rec ) THEN
293: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 298: RAISE FND_API.G_EXC_ERROR;

294: THEN
295: FND_MESSAGE.Set_Name('AS', 'API_DUP_COMPETITOR_PRODUCTS');
296: FND_MSG_PUB.ADD;
297: END IF;
298: RAISE FND_API.G_EXC_ERROR;
299: END IF;
300: */
301: -- Debug Message
302: IF l_debug THEN

Line 348: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

344: X_competitor_prod_out_tbl(l_curr_row).LEAD_COMPETITOR_PROD_ID :=
345: l_LEAD_COMPETITOR_PROD_ID;
346: X_competitor_prod_out_tbl(l_curr_row).return_status := x_return_status;
347:
348: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
349: RAISE FND_API.G_EXC_ERROR;
350: END IF;
351:
352: -- rolloup the competitor to the opp header

Line 349: RAISE FND_API.G_EXC_ERROR;

345: l_LEAD_COMPETITOR_PROD_ID;
346: X_competitor_prod_out_tbl(l_curr_row).return_status := x_return_status;
347:
348: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
349: RAISE FND_API.G_EXC_ERROR;
350: END IF;
351:
352: -- rolloup the competitor to the opp header
353: IF l_loop_count = 1 THEN

Line 371: IF FND_API.to_Boolean( p_commit )

367: -- End of API body
368: --
369:
370: -- Standard check for p_commit
371: IF FND_API.to_Boolean( p_commit )
372: THEN
373: COMMIT WORK;
374: END IF;
375:

Line 398: p_init_msg_list => FND_API.G_FALSE,

394: IF(FND_PROFILE.VALUE('AS_POST_CUSTOM_ENABLED')='Y')
395: THEN
396: AS_CALLOUT_PKG.Create_competitor_prods_AC(
397: p_api_version_number => 2.0,
398: p_init_msg_list => FND_API.G_FALSE,
399: p_commit => FND_API.G_FALSE,
400: p_validation_level => p_validation_level,
401: P_Competitor_Prod_Prod_Rec => P_Competitor_Prod_Prod_Rec,
402: -- Hint: Add detail tables as parameter lists if it's master-detail

Line 399: p_commit => FND_API.G_FALSE,

395: THEN
396: AS_CALLOUT_PKG.Create_competitor_prods_AC(
397: p_api_version_number => 2.0,
398: p_init_msg_list => FND_API.G_FALSE,
399: p_commit => FND_API.G_FALSE,
400: p_validation_level => p_validation_level,
401: P_Competitor_Prod_Prod_Rec => P_Competitor_Prod_Prod_Rec,
402: -- Hint: Add detail tables as parameter lists if it's master-detail
403: -- relationship.

Line 428: WHEN FND_API.G_EXC_ERROR THEN

424: ,X_MSG_COUNT => X_MSG_COUNT
425: ,X_MSG_DATA => X_MSG_DATA
426: ,X_RETURN_STATUS => X_RETURN_STATUS);
427:
428: WHEN FND_API.G_EXC_ERROR THEN
429: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
430: P_MODULE => l_module
431: ,P_API_NAME => L_API_NAME
432: ,P_PKG_NAME => G_PKG_NAME

Line 439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

435: ,X_MSG_COUNT => X_MSG_COUNT
436: ,X_MSG_DATA => X_MSG_DATA
437: ,X_RETURN_STATUS => X_RETURN_STATUS);
438:
439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
440: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
441: P_MODULE => l_module
442: ,P_API_NAME => L_API_NAME
443: ,P_PKG_NAME => G_PKG_NAME

Line 465: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

461:
462:
463: PROCEDURE Update_competitor_prods(
464: P_Api_Version_Number IN NUMBER,
465: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
466: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
467: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
468: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
469: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

Line 466: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

462:
463: PROCEDURE Update_competitor_prods(
464: P_Api_Version_Number IN NUMBER,
465: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
466: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
467: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
468: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
469: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
470: P_Admin_Group_Id IN NUMBER,

Line 467: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

463: PROCEDURE Update_competitor_prods(
464: P_Api_Version_Number IN NUMBER,
465: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
466: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
467: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
468: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
469: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
470: P_Admin_Group_Id IN NUMBER,
471: P_Identity_Salesforce_Id IN NUMBER,

Line 468: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,

464: P_Api_Version_Number IN NUMBER,
465: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
466: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
467: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
468: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
469: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
470: P_Admin_Group_Id IN NUMBER,
471: P_Identity_Salesforce_Id IN NUMBER,
472: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,

Line 469: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

465: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
466: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
467: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
468: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
469: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
470: P_Admin_Group_Id IN NUMBER,
471: P_Identity_Salesforce_Id IN NUMBER,
472: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
473: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,

Line 473: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,

469: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
470: P_Admin_Group_Id IN NUMBER,
471: P_Identity_Salesforce_Id IN NUMBER,
472: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
473: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
474: P_Competitor_Prod_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_Tbl_Type,
475: X_competitor_prod_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_prod_out_tbl_type,
476: X_Return_Status OUT NOCOPY VARCHAR2,
477: X_Msg_Count OUT NOCOPY NUMBER,

Line 508: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

504: -- Standard Start of API savepoint
505: SAVEPOINT UPDATE_COMPETITOR_PRODS_PVT;
506:
507: -- Standard call to check for call compatibility.
508: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
509: p_api_version_number,
510: l_api_name,
511: G_PKG_NAME)
512: THEN

Line 513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

509: p_api_version_number,
510: l_api_name,
511: G_PKG_NAME)
512: THEN
513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
514: END IF;
515:
516:
517: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 518: IF FND_API.to_Boolean( p_init_msg_list )

514: END IF;
515:
516:
517: -- Initialize message list if p_init_msg_list is set to TRUE.
518: IF FND_API.to_Boolean( p_init_msg_list )
519: THEN
520: FND_MSG_PUB.initialize;
521: END IF;
522:

Line 532: x_return_status := FND_API.G_RET_STS_SUCCESS;

528: END IF;
529:
530:
531: -- Initialize API return status to SUCCESS
532: x_return_status := FND_API.G_RET_STS_SUCCESS;
533:
534: --
535: -- Api body
536: --

Line 545: p_init_msg_list => FND_API.G_FALSE,

541: IF(FND_PROFILE.VALUE('AS_PRE_CUSTOM_ENABLED')='Y')
542: THEN
543: AS_CALLOUT_PKG.Update_competitor_prods_BU(
544: p_api_version_number => 2.0,
545: p_init_msg_list => FND_API.G_FALSE,
546: p_commit => FND_API.G_FALSE,
547: p_validation_level => p_validation_level,
548: p_identity_salesforce_id => p_identity_salesforce_id,
549: P_Competitor_Prod_Rec => P_Competitor_Prod_Rec,

Line 546: p_commit => FND_API.G_FALSE,

542: THEN
543: AS_CALLOUT_PKG.Update_competitor_prods_BU(
544: p_api_version_number => 2.0,
545: p_init_msg_list => FND_API.G_FALSE,
546: p_commit => FND_API.G_FALSE,
547: p_validation_level => p_validation_level,
548: p_identity_salesforce_id => p_identity_salesforce_id,
549: P_Competitor_Prod_Rec => P_Competitor_Prod_Rec,
550: -- Hint: Add detail tables as parameter lists if it's master-detail

Line 560: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL )

556: */
557:
558:
559:
560: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL )
561: THEN
562: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
563: p_api_version_number => 2.0
564: ,p_init_msg_list => p_init_msg_list

Line 573: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

569: ,x_msg_data => x_msg_data
570: ,x_sales_member_rec => l_identity_sales_member_rec);
571: END IF;
572:
573: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
574: RAISE FND_API.G_EXC_ERROR;
575: END IF;
576:
577: -- Call Get_Access_Profiles to get access_profile_rec

Line 574: RAISE FND_API.G_EXC_ERROR;

570: ,x_sales_member_rec => l_identity_sales_member_rec);
571: END IF;
572:
573: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
574: RAISE FND_API.G_EXC_ERROR;
575: END IF;
576:
577: -- Call Get_Access_Profiles to get access_profile_rec
578: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

Line 608: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

604: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
605: 'API_NO_UPDATE_PRIVILEGE');
606: END IF;
607:
608: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
609: RAISE FND_API.G_EXC_ERROR;
610: END IF;
611: END IF;
612:

Line 609: RAISE FND_API.G_EXC_ERROR;

605: 'API_NO_UPDATE_PRIVILEGE');
606: END IF;
607:
608: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
609: RAISE FND_API.G_EXC_ERROR;
610: END IF;
611: END IF;
612:
613: FOR l_curr_row IN 1..l_line_count LOOP

Line 615: FND_API.G_RET_STS_SUCCESS ;

611: END IF;
612:
613: FOR l_curr_row IN 1..l_line_count LOOP
614: X_competitor_prod_out_tbl(l_curr_row).return_status :=
615: FND_API.G_RET_STS_SUCCESS ;
616: -- Progress Message
617: --
618: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
619: THEN

Line 646: raise FND_API.G_EXC_ERROR;

642: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
643: FND_MESSAGE.Set_Token ('INFO', 'competitor_prod', FALSE);
644: FND_MSG_PUB.Add;
645: END IF;
646: raise FND_API.G_EXC_ERROR;
647: END IF;
648: -- Debug Message
649: IF l_debug THEN
650: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 657: l_Competitor_Prod_rec.last_update_date = FND_API.G_MISS_Date ) Then

653:
654: Close C_Get_competitor_prod;
655:
656: If (l_Competitor_Prod_rec.last_update_date is NULL or
657: l_Competitor_Prod_rec.last_update_date = FND_API.G_MISS_Date ) Then
658: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
659: THEN
660: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
661: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

Line 664: raise FND_API.G_EXC_ERROR;

660: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
661: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
662: FND_MSG_PUB.ADD;
663: END IF;
664: raise FND_API.G_EXC_ERROR;
665: End if;
666: -- Check Whether record has been changed by someone else
667: If (l_Competitor_Prod_rec.last_update_date <> l_last_update_date) Then
668: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 674: raise FND_API.G_EXC_ERROR;

670: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
671: FND_MESSAGE.Set_Token('INFO', 'competitor_prod', FALSE);
672: FND_MSG_PUB.ADD;
673: END IF;
674: raise FND_API.G_EXC_ERROR;
675: End if;
676:
677: -- Reset the win/loss status
678: IF (l_opp_won) THEN

Line 682: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL )

678: IF (l_opp_won) THEN
679: l_competitor_prod_rec.WIN_LOSS_STATUS := 'LOST';
680: END IF;
681:
682: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL )
683: THEN
684: -- Debug message
685: IF l_debug THEN
686: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 692: p_init_msg_list => FND_API.G_FALSE,

688: END IF;
689:
690: -- Invoke validation procedures
691: Validate_competitor_prod(
692: p_init_msg_list => FND_API.G_FALSE,
693: p_validation_level => p_validation_level,
694: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,
695: P_Competitor_Prod_Rec => l_Competitor_Prod_Rec,
696: x_return_status => x_return_status,

Line 701: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

697: x_msg_count => x_msg_count,
698: x_msg_data => x_msg_data);
699: END IF;
700:
701: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
702: RAISE FND_API.G_EXC_ERROR;
703: END IF;
704: /*
705: IF check_dup( p_Competitor_Prod_rec => l_Competitor_Prod_rec ) THEN

Line 702: RAISE FND_API.G_EXC_ERROR;

698: x_msg_data => x_msg_data);
699: END IF;
700:
701: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
702: RAISE FND_API.G_EXC_ERROR;
703: END IF;
704: /*
705: IF check_dup( p_Competitor_Prod_rec => l_Competitor_Prod_rec ) THEN
706: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 711: RAISE FND_API.G_EXC_ERROR;

707: THEN
708: FND_MESSAGE.Set_Name('AS', 'API_DUP_COMPETITOR_PRODUCTS');
709: FND_MSG_PUB.ADD;
710: END IF;
711: RAISE FND_API.G_EXC_ERROR;
712: END IF;
713: */
714: -- Debug Message
715: IF l_debug THEN

Line 751: p_CREATED_BY => FND_API.G_MISS_NUM,

747: p_LEAD_COMPETITOR_PROD_ID => l_competitor_prod_rec.LEAD_COMPETITOR_PROD_ID,
748: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
749: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
750: p_LAST_UPDATE_DATE => SYSDATE,
751: p_CREATED_BY => FND_API.G_MISS_NUM,
752: p_CREATION_DATE => l_competitor_prod_rec.CREATION_DATE);
753:
754: X_competitor_prod_out_tbl(l_curr_row).LEAD_COMPETITOR_PROD_ID :=
755: l_Competitor_Prod_rec.LEAD_COMPETITOR_PROD_ID;

Line 758: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

754: X_competitor_prod_out_tbl(l_curr_row).LEAD_COMPETITOR_PROD_ID :=
755: l_Competitor_Prod_rec.LEAD_COMPETITOR_PROD_ID;
756: X_competitor_prod_out_tbl(l_curr_row).return_status := x_return_status;
757:
758: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
759: RAISE FND_API.G_EXC_ERROR;
760: END IF;
761:
762: END LOOP;

Line 759: RAISE FND_API.G_EXC_ERROR;

755: l_Competitor_Prod_rec.LEAD_COMPETITOR_PROD_ID;
756: X_competitor_prod_out_tbl(l_curr_row).return_status := x_return_status;
757:
758: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
759: RAISE FND_API.G_EXC_ERROR;
760: END IF;
761:
762: END LOOP;
763:

Line 770: IF FND_API.to_Boolean( p_commit )

766: -- End of API body.
767: --
768:
769: -- Standard check for p_commit
770: IF FND_API.to_Boolean( p_commit )
771: THEN
772: COMMIT WORK;
773: END IF;
774:

Line 798: p_init_msg_list => FND_API.G_FALSE,

794: IF(FND_PROFILE.VALUE('AS_POST_CUSTOM_ENABLED')='Y')
795: THEN
796: AS_CALLOUT_PKG.Update_competitor_prods_AU(
797: p_api_version_number => 2.0,
798: p_init_msg_list => FND_API.G_FALSE,
799: p_commit => FND_API.G_FALSE,
800: p_validation_level => p_validation_level,
801: p_identity_salesforce_id => p_identity_salesforce_id,
802: P_Competitor_Prod_Prod_Rec => P_Competitor_Prod_Rec,

Line 799: p_commit => FND_API.G_FALSE,

795: THEN
796: AS_CALLOUT_PKG.Update_competitor_prods_AU(
797: p_api_version_number => 2.0,
798: p_init_msg_list => FND_API.G_FALSE,
799: p_commit => FND_API.G_FALSE,
800: p_validation_level => p_validation_level,
801: p_identity_salesforce_id => p_identity_salesforce_id,
802: P_Competitor_Prod_Prod_Rec => P_Competitor_Prod_Rec,
803: -- Hint: Add detail tables as parameter lists if it's master-detail

Line 829: WHEN FND_API.G_EXC_ERROR THEN

825: ,X_MSG_COUNT => X_MSG_COUNT
826: ,X_MSG_DATA => X_MSG_DATA
827: ,X_RETURN_STATUS => X_RETURN_STATUS);
828:
829: WHEN FND_API.G_EXC_ERROR THEN
830: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
831: P_MODULE => l_module
832: ,P_API_NAME => L_API_NAME
833: ,P_PKG_NAME => G_PKG_NAME

Line 840: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

836: ,X_MSG_COUNT => X_MSG_COUNT
837: ,X_MSG_DATA => X_MSG_DATA
838: ,X_RETURN_STATUS => X_RETURN_STATUS);
839:
840: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
841: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
842: P_MODULE => l_module
843: ,P_API_NAME => L_API_NAME
844: ,P_PKG_NAME => G_PKG_NAME

Line 870: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

866: -- The Master delete procedure may not be needed depends on different
867: -- business requirements.
868: PROCEDURE Delete_competitor_prods(
869: P_Api_Version_Number IN NUMBER,
870: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
871: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
872: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
873: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
874: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

Line 871: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

867: -- business requirements.
868: PROCEDURE Delete_competitor_prods(
869: P_Api_Version_Number IN NUMBER,
870: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
871: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
872: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
873: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
874: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
875: P_Admin_Group_Id IN NUMBER,

Line 872: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

868: PROCEDURE Delete_competitor_prods(
869: P_Api_Version_Number IN NUMBER,
870: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
871: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
872: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
873: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
874: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
875: P_Admin_Group_Id IN NUMBER,
876: P_Identity_Salesforce_Id IN NUMBER,

Line 873: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,

869: P_Api_Version_Number IN NUMBER,
870: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
871: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
872: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
873: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
874: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
875: P_Admin_Group_Id IN NUMBER,
876: P_Identity_Salesforce_Id IN NUMBER,
877: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,

Line 874: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

870: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
871: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
872: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
873: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
874: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
875: P_Admin_Group_Id IN NUMBER,
876: P_Identity_Salesforce_Id IN NUMBER,
877: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
878: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,

Line 878: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,

874: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
875: P_Admin_Group_Id IN NUMBER,
876: P_Identity_Salesforce_Id IN NUMBER,
877: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
878: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
879: P_Competitor_Prod_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_Tbl_Type,
880: X_competitor_prod_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_prod_out_tbl_type,
881: X_Return_Status OUT NOCOPY VARCHAR2,
882: X_Msg_Count OUT NOCOPY NUMBER,

Line 903: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

899: -- Standard Start of API savepoint
900: SAVEPOINT DELETE_COMPETITOR_PRODS_PVT;
901:
902: -- Standard call to check for call compatibility.
903: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
904: p_api_version_number,
905: l_api_name,
906: G_PKG_NAME)
907: THEN

Line 908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

904: p_api_version_number,
905: l_api_name,
906: G_PKG_NAME)
907: THEN
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END IF;
910:
911:
912: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 913: IF FND_API.to_Boolean( p_init_msg_list )

909: END IF;
910:
911:
912: -- Initialize message list if p_init_msg_list is set to TRUE.
913: IF FND_API.to_Boolean( p_init_msg_list )
914: THEN
915: FND_MSG_PUB.initialize;
916: END IF;
917:

Line 927: x_return_status := FND_API.G_RET_STS_SUCCESS;

923: END IF;
924:
925:
926: -- Initialize API return status to SUCCESS
927: x_return_status := FND_API.G_RET_STS_SUCCESS;
928:
929: --
930: -- Api body
931: --

Line 939: p_init_msg_list => FND_API.G_FALSE,

935: IF(FND_PROFILE.VALUE('AS_PRE_CUSTOM_ENABLED')='Y')
936: THEN
937: AS_CALLOUT_PKG.Delete_competitor_prods_BD(
938: p_api_version_number => 2.0,
939: p_init_msg_list => FND_API.G_FALSE,
940: p_commit => FND_API.G_FALSE,
941: p_validation_level => p_validation_level,
942: p_identity_salesforce_id => p_identity_salesforce_id,
943: P_Competitor_Prod_Rec => P_Competitor_Prod_Rec,

Line 940: p_commit => FND_API.G_FALSE,

936: THEN
937: AS_CALLOUT_PKG.Delete_competitor_prods_BD(
938: p_api_version_number => 2.0,
939: p_init_msg_list => FND_API.G_FALSE,
940: p_commit => FND_API.G_FALSE,
941: p_validation_level => p_validation_level,
942: p_identity_salesforce_id => p_identity_salesforce_id,
943: P_Competitor_Prod_Rec => P_Competitor_Prod_Rec,
944: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.

Line 951: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL )

947: x_msg_data => x_msg_data);
948: END IF;
949: */
950:
951: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL )
952: THEN
953: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
954: p_api_version_number => 2.0
955: ,p_init_msg_list => p_init_msg_list

Line 964: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

960: ,x_msg_data => x_msg_data
961: ,x_sales_member_rec => l_identity_sales_member_rec);
962: END IF;
963:
964: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
965: RAISE FND_API.G_EXC_ERROR;
966: END IF;
967:
968: -- Call Get_Access_Profiles to get access_profile_rec

Line 965: RAISE FND_API.G_EXC_ERROR;

961: ,x_sales_member_rec => l_identity_sales_member_rec);
962: END IF;
963:
964: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
965: RAISE FND_API.G_EXC_ERROR;
966: END IF;
967:
968: -- Call Get_Access_Profiles to get access_profile_rec
969: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

Line 1000: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

996: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
997: 'API_NO_UPDATE_PRIVILEGE');
998: END IF;
999:
1000: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1001: RAISE FND_API.G_EXC_ERROR;
1002: END IF;
1003:
1004: FOR l_curr_row IN 1..l_line_count LOOP

Line 1001: RAISE FND_API.G_EXC_ERROR;

997: 'API_NO_UPDATE_PRIVILEGE');
998: END IF;
999:
1000: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1001: RAISE FND_API.G_EXC_ERROR;
1002: END IF;
1003:
1004: FOR l_curr_row IN 1..l_line_count LOOP
1005: X_competitor_prod_out_tbl(l_curr_row).return_status :=

Line 1006: FND_API.G_RET_STS_SUCCESS ;

1002: END IF;
1003:
1004: FOR l_curr_row IN 1..l_line_count LOOP
1005: X_competitor_prod_out_tbl(l_curr_row).return_status :=
1006: FND_API.G_RET_STS_SUCCESS ;
1007:
1008: -- Progress Message
1009: --
1010: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1035: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1031: X_competitor_prod_out_tbl(l_curr_row).LEAD_COMPETITOR_PROD_ID :=
1032: l_LEAD_COMPETITOR_PROD_ID;
1033: X_competitor_prod_out_tbl(l_curr_row).return_status := x_return_status;
1034:
1035: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1036: RAISE FND_API.G_EXC_ERROR;
1037: END IF;
1038:
1039: END LOOP;

Line 1036: RAISE FND_API.G_EXC_ERROR;

1032: l_LEAD_COMPETITOR_PROD_ID;
1033: X_competitor_prod_out_tbl(l_curr_row).return_status := x_return_status;
1034:
1035: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1036: RAISE FND_API.G_EXC_ERROR;
1037: END IF;
1038:
1039: END LOOP;
1040:

Line 1046: IF FND_API.to_Boolean( p_commit )

1042: -- End of API body
1043: --
1044:
1045: -- Standard check for p_commit
1046: IF FND_API.to_Boolean( p_commit )
1047: THEN
1048: COMMIT WORK;
1049: END IF;
1050:

Line 1073: p_init_msg_list => FND_API.G_FALSE,

1069: IF(FND_PROFILE.VALUE('AS_POST_CUSTOM_ENABLED')='Y')
1070: THEN
1071: AS_CALLOUT_PKG.Delete_competitor_prods_AD(
1072: p_api_version_number => 2.0,
1073: p_init_msg_list => FND_API.G_FALSE,
1074: p_commit => FND_API.G_FALSE,
1075: p_validation_level => p_validation_level,
1076: p_identity_salesforce_id => p_identity_salesforce_id,
1077: P_Competitor_Prod_Prod_Rec => P_Competitor_Prod_Rec,

Line 1074: p_commit => FND_API.G_FALSE,

1070: THEN
1071: AS_CALLOUT_PKG.Delete_competitor_prods_AD(
1072: p_api_version_number => 2.0,
1073: p_init_msg_list => FND_API.G_FALSE,
1074: p_commit => FND_API.G_FALSE,
1075: p_validation_level => p_validation_level,
1076: p_identity_salesforce_id => p_identity_salesforce_id,
1077: P_Competitor_Prod_Prod_Rec => P_Competitor_Prod_Rec,
1078: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.

Line 1085: WHEN FND_API.G_EXC_ERROR THEN

1081: x_msg_data => x_msg_data);
1082: END IF;
1083: */
1084: EXCEPTION
1085: WHEN FND_API.G_EXC_ERROR THEN
1086: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1087: P_MODULE => l_module
1088: ,P_API_NAME => L_API_NAME
1089: ,P_PKG_NAME => G_PKG_NAME

Line 1096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1092: ,X_MSG_COUNT => X_MSG_COUNT
1093: ,X_MSG_DATA => X_MSG_DATA
1094: ,X_RETURN_STATUS => X_RETURN_STATUS);
1095:
1096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1097: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1098: P_MODULE => l_module
1099: ,P_API_NAME => L_API_NAME
1100: ,P_PKG_NAME => G_PKG_NAME

Line 1122: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1118:
1119:
1120: -- Item-level validation procedures
1121: PROCEDURE Validate_REQUEST_ID (
1122: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1123: P_Validation_mode IN VARCHAR2,
1124: P_REQUEST_ID IN NUMBER,
1125: X_Return_Status OUT NOCOPY VARCHAR2,
1126: X_Msg_Count OUT NOCOPY NUMBER,

Line 1133: IF FND_API.to_Boolean( p_init_msg_list )

1129: IS
1130: BEGIN
1131:
1132: -- Initialize message list if p_init_msg_list is set to TRUE.
1133: IF FND_API.to_Boolean( p_init_msg_list )
1134: THEN
1135: FND_MSG_PUB.initialize;
1136: END IF;
1137:

Line 1140: x_return_status := FND_API.G_RET_STS_SUCCESS;

1136: END IF;
1137:
1138:
1139: -- Initialize API return status to SUCCESS
1140: x_return_status := FND_API.G_RET_STS_SUCCESS;
1141:
1142: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1143: THEN
1144: -- Hint: Validate data

Line 1147: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

1143: THEN
1144: -- Hint: Validate data
1145: -- IF p_REQUEST_ID is not NULL and p_REQUEST_ID <> G_MISS_CHAR
1146: -- verify if data is valid
1147: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1148: NULL;
1149: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1150: THEN
1151: -- Hint: Validate data

Line 1154: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

1150: THEN
1151: -- Hint: Validate data
1152: -- IF p_REQUEST_ID <> G_MISS_CHAR
1153: -- verify if data is valid
1154: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1155: NULL;
1156: END IF;
1157:
1158: -- Standard call to get message count and if count is 1, get message info.

Line 1168: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1164: END Validate_REQUEST_ID;
1165:
1166:
1167: PROCEDURE Validate_WIN_LOSS_STATUS (
1168: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1169: P_Validation_mode IN VARCHAR2,
1170: P_WIN_LOSS_STATUS IN VARCHAR2,
1171: X_Return_Status OUT NOCOPY VARCHAR2,
1172: X_Msg_Count OUT NOCOPY NUMBER,

Line 1190: IF FND_API.to_Boolean( p_init_msg_list )

1186:
1187: BEGIN
1188:
1189: -- Initialize message list if p_init_msg_list is set to TRUE.
1190: IF FND_API.to_Boolean( p_init_msg_list )
1191: THEN
1192: FND_MSG_PUB.initialize;
1193: END IF;
1194:

Line 1197: x_return_status := FND_API.G_RET_STS_SUCCESS;

1193: END IF;
1194:
1195:
1196: -- Initialize API return status to SUCCESS
1197: x_return_status := FND_API.G_RET_STS_SUCCESS;
1198:
1199: IF (p_WIN_LOSS_STATUS is NOT NULL) and
1200: (p_WIN_LOSS_STATUS <> FND_API.G_MISS_CHAR)
1201: THEN

Line 1200: (p_WIN_LOSS_STATUS <> FND_API.G_MISS_CHAR)

1196: -- Initialize API return status to SUCCESS
1197: x_return_status := FND_API.G_RET_STS_SUCCESS;
1198:
1199: IF (p_WIN_LOSS_STATUS is NOT NULL) and
1200: (p_WIN_LOSS_STATUS <> FND_API.G_MISS_CHAR)
1201: THEN
1202: -- WIN_LOSS_STATUS should exist in as_lookups
1203: OPEN C_WIN_LOSS_STATUS_Exists ('WIN_LOSS_STATUS',
1204: p_WIN_LOSS_STATUS);

Line 1218: x_return_status := FND_API.G_RET_STS_ERROR;

1214: p_msg_name => 'API_INVALID_WIN_LOSS_STATUS',
1215: p_token1 => 'VALUE',
1216: p_token1_value => p_WIN_LOSS_STATUS );
1217:
1218: x_return_status := FND_API.G_RET_STS_ERROR;
1219: END IF;
1220:
1221: CLOSE C_WIN_LOSS_STATUS_Exists;
1222: END IF;

Line 1234: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1230: END Validate_WIN_LOSS_STATUS;
1231:
1232:
1233: PROCEDURE Validate_COMPETITOR_PRODUCT_ID (
1234: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1235: P_Validation_mode IN VARCHAR2,
1236: P_COMPETITOR_PRODUCT_ID IN NUMBER,
1237: X_Return_Status OUT NOCOPY VARCHAR2,
1238: X_Msg_Count OUT NOCOPY NUMBER,

Line 1255: IF FND_API.to_Boolean( p_init_msg_list )

1251: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cpdpv.Validate_COMPETITOR_PRODUCT_ID';
1252:
1253: BEGIN
1254: -- Initialize message list if p_init_msg_list is set to TRUE.
1255: IF FND_API.to_Boolean( p_init_msg_list )
1256: THEN
1257: FND_MSG_PUB.initialize;
1258: END IF;
1259:

Line 1262: x_return_status := FND_API.G_RET_STS_SUCCESS;

1258: END IF;
1259:
1260:
1261: -- Initialize API return status to SUCCESS
1262: x_return_status := FND_API.G_RET_STS_SUCCESS;
1263:
1264: IF (p_COMPETITOR_PRODUCT_ID is NULL) or
1265: (p_COMPETITOR_PRODUCT_ID = FND_API.G_MISS_NUM)
1266: THEN

Line 1265: (p_COMPETITOR_PRODUCT_ID = FND_API.G_MISS_NUM)

1261: -- Initialize API return status to SUCCESS
1262: x_return_status := FND_API.G_RET_STS_SUCCESS;
1263:
1264: IF (p_COMPETITOR_PRODUCT_ID is NULL) or
1265: (p_COMPETITOR_PRODUCT_ID = FND_API.G_MISS_NUM)
1266: THEN
1267: AS_UTILITY_PVT.Set_Message(
1268: p_module => l_module,
1269: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1272: x_return_status := FND_API.G_RET_STS_ERROR;

1268: p_module => l_module,
1269: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1270: p_msg_name => 'API_MISSING_COMPETITOR_PRODUCT_ID');
1271:
1272: x_return_status := FND_API.G_RET_STS_ERROR;
1273: ELSE
1274: NULL;
1275: /*
1276: OPEN c_competitor_product_exists(p_COMPETITOR_PRODUCT_ID);

Line 1284: x_return_status := FND_API.G_RET_STS_ERROR;

1280: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1281: 'Private API: COMPETITOR_PRODUCT_ID is invalid');
1282: END IF;
1283:
1284: x_return_status := FND_API.G_RET_STS_ERROR;
1285: END IF;
1286: CLOSE c_competitor_product_exists;
1287: */
1288: END IF;

Line 1300: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1296: END Validate_COMPETITOR_PRODUCT_ID;
1297:
1298:
1299: PROCEDURE Validate_LEAD_LINE_ID (
1300: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1301: P_Validation_mode IN VARCHAR2,
1302: P_LEAD_LINE_ID IN NUMBER,
1303: X_Return_Status OUT NOCOPY VARCHAR2,
1304: X_Msg_Count OUT NOCOPY NUMBER,

Line 1323: IF FND_API.to_Boolean( p_init_msg_list )

1319:
1320: BEGIN
1321:
1322: -- Initialize message list if p_init_msg_list is set to TRUE.
1323: IF FND_API.to_Boolean( p_init_msg_list )
1324: THEN
1325: FND_MSG_PUB.initialize;
1326: END IF;
1327:

Line 1330: x_return_status := FND_API.G_RET_STS_SUCCESS;

1326: END IF;
1327:
1328:
1329: -- Initialize API return status to SUCCESS
1330: x_return_status := FND_API.G_RET_STS_SUCCESS;
1331:
1332:
1333: IF (p_LEAD_LINE_ID is NULL) or (p_LEAD_LINE_ID = FND_API.G_MISS_NUM)
1334: THEN

Line 1333: IF (p_LEAD_LINE_ID is NULL) or (p_LEAD_LINE_ID = FND_API.G_MISS_NUM)

1329: -- Initialize API return status to SUCCESS
1330: x_return_status := FND_API.G_RET_STS_SUCCESS;
1331:
1332:
1333: IF (p_LEAD_LINE_ID is NULL) or (p_LEAD_LINE_ID = FND_API.G_MISS_NUM)
1334: THEN
1335: IF l_debug THEN
1336: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1337: 'Private API 38: Violate NOT NULL constraint(LEAD_LINE_ID)');

Line 1340: x_return_status := FND_API.G_RET_STS_ERROR;

1336: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1337: 'Private API 38: Violate NOT NULL constraint(LEAD_LINE_ID)');
1338: END IF;
1339:
1340: x_return_status := FND_API.G_RET_STS_ERROR;
1341: ELSE
1342: OPEN C_Lead_Line_Id_Exists (p_Lead_Line_Id);
1343: FETCH C_Lead_Line_Id_Exists into l_val;
1344: IF C_Lead_Line_Id_Exists%NOTFOUND

Line 1350: x_return_status := FND_API.G_RET_STS_ERROR;

1346: IF l_debug THEN
1347: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1348: 'Private API 39: LEAD_LINE_ID is not valid');
1349: END IF;
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351: END IF;
1352: CLOSE C_Lead_Line_Id_Exists;
1353: END IF;
1354:

Line 1365: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1361: END Validate_LEAD_LINE_ID;
1362:
1363:
1364: PROCEDURE Validate_LEAD_ID (
1365: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1366: P_Validation_mode IN VARCHAR2,
1367: P_LEAD_ID IN NUMBER,
1368: X_Return_Status OUT NOCOPY VARCHAR2,
1369: X_Msg_Count OUT NOCOPY NUMBER,

Line 1387: IF FND_API.to_Boolean( p_init_msg_list )

1383:
1384: BEGIN
1385:
1386: -- Initialize message list if p_init_msg_list is set to TRUE.
1387: IF FND_API.to_Boolean( p_init_msg_list )
1388: THEN
1389: FND_MSG_PUB.initialize;
1390: END IF;
1391:

Line 1394: x_return_status := FND_API.G_RET_STS_SUCCESS;

1390: END IF;
1391:
1392:
1393: -- Initialize API return status to SUCCESS
1394: x_return_status := FND_API.G_RET_STS_SUCCESS;
1395:
1396:
1397: IF (p_LEAD_ID is NULL) or (p_LEAD_ID = FND_API.G_MISS_NUM)
1398: THEN

Line 1397: IF (p_LEAD_ID is NULL) or (p_LEAD_ID = FND_API.G_MISS_NUM)

1393: -- Initialize API return status to SUCCESS
1394: x_return_status := FND_API.G_RET_STS_SUCCESS;
1395:
1396:
1397: IF (p_LEAD_ID is NULL) or (p_LEAD_ID = FND_API.G_MISS_NUM)
1398: THEN
1399: IF l_debug THEN
1400: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1401: 'Private API 36: Violate NOT NULL constraint(LEAD_ID)');

Line 1404: x_return_status := FND_API.G_RET_STS_ERROR;

1400: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1401: 'Private API 36: Violate NOT NULL constraint(LEAD_ID)');
1402: END IF;
1403:
1404: x_return_status := FND_API.G_RET_STS_ERROR;
1405: ELSE
1406: OPEN C_Lead_Id_Exists (p_Lead_Id);
1407: FETCH C_Lead_Id_Exists into l_val;
1408: IF C_Lead_Id_Exists%NOTFOUND

Line 1415: x_return_status := FND_API.G_RET_STS_ERROR;

1411: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1412: 'Private API 37: LEAD_ID is not valid');
1413: END IF;
1414:
1415: x_return_status := FND_API.G_RET_STS_ERROR;
1416: END IF;
1417: CLOSE C_Lead_Id_Exists;
1418: END IF;
1419:

Line 1430: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1426: END Validate_LEAD_ID;
1427:
1428:
1429: PROCEDURE Validate_L_COMPETITOR_PROD_ID (
1430: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1431: P_Validation_mode IN VARCHAR2,
1432: P_LEAD_COMPETITOR_PROD_ID IN NUMBER,
1433: X_Return_Status OUT NOCOPY VARCHAR2,
1434: X_Msg_Count OUT NOCOPY NUMBER,

Line 1449: IF FND_API.to_Boolean( p_init_msg_list )

1445: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cpdpv.Validate_L_COMPETITOR_PROD_ID';
1446:
1447: BEGIN
1448: -- Initialize message list if p_init_msg_list is set to TRUE.
1449: IF FND_API.to_Boolean( p_init_msg_list )
1450: THEN
1451: FND_MSG_PUB.initialize;
1452: END IF;
1453:

Line 1455: x_return_status := FND_API.G_RET_STS_SUCCESS;

1451: FND_MSG_PUB.initialize;
1452: END IF;
1453:
1454: -- Initialize API return status to SUCCESS
1455: x_return_status := FND_API.G_RET_STS_SUCCESS;
1456:
1457: -- Calling from Create API
1458: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1459: THEN

Line 1460: IF (p_LEAD_COMPETITOR_PROD_ID is NOT NULL) and (p_LEAD_COMPETITOR_PROD_ID <> FND_API.G_MISS_NUM)

1456:
1457: -- Calling from Create API
1458: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1459: THEN
1460: IF (p_LEAD_COMPETITOR_PROD_ID is NOT NULL) and (p_LEAD_COMPETITOR_PROD_ID <> FND_API.G_MISS_NUM)
1461: THEN
1462: OPEN C_Lead_CProd_Id_Exists (p_Lead_Competitor_Prod_Id);
1463: FETCH C_Lead_CProd_Id_Exists into l_val;
1464:

Line 1476: x_return_status := FND_API.G_RET_STS_ERROR;

1472: p_msg_name => 'API_DUPLICATE_LEAD_CPROD_ID',
1473: p_token1 => 'VALUE',
1474: p_token1_value => p_LEAD_COMPETITOR_PROD_ID );
1475:
1476: x_return_status := FND_API.G_RET_STS_ERROR;
1477: END IF;
1478:
1479: CLOSE C_Lead_CProd_Id_Exists;
1480: END IF;

Line 1486: IF (p_LEAD_COMPETITOR_PROD_ID is NULL) or (p_LEAD_COMPETITOR_PROD_ID = FND_API.G_MISS_NUM)

1482: -- Calling from Update API
1483: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1484: THEN
1485: -- validate NOT NULL column
1486: IF (p_LEAD_COMPETITOR_PROD_ID is NULL) or (p_LEAD_COMPETITOR_PROD_ID = FND_API.G_MISS_NUM)
1487: THEN
1488: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1489: -- 'Private API: Violate NOT NULL constraint(LEAD_COMPETITOR_PROD_ID)');
1490:

Line 1496: x_return_status := FND_API.G_RET_STS_ERROR;

1492: p_module => l_module,
1493: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1494: p_msg_name => 'API_MISSING_LEAD_CPROD_ID');
1495:
1496: x_return_status := FND_API.G_RET_STS_ERROR;
1497: ELSE
1498: OPEN C_Lead_CProd_Id_Exists (p_Lead_Competitor_Prod_Id);
1499: FETCH C_Lead_CProd_Id_Exists into l_val;
1500:

Line 1513: x_return_status := FND_API.G_RET_STS_ERROR;

1509: p_msg_name => 'API_INVALID_LEAD_CPROD_ID',
1510: p_token1 => 'VALUE',
1511: p_token1_value => p_LEAD_COMPETITOR_PROD_ID );
1512:
1513: x_return_status := FND_API.G_RET_STS_ERROR;
1514: END IF;
1515:
1516: CLOSE C_Lead_CProd_Id_Exists;
1517: END IF;

Line 1537: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1533:
1534:
1535:
1536: PROCEDURE Validate_Competitor_Prod_rec(
1537: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1538: P_Validation_mode IN VARCHAR2,
1539: P_Competitor_Prod_Rec IN as_opportunity_pub.Competitor_Prod_Rec_Type,
1540: X_Return_Status OUT NOCOPY VARCHAR2,
1541: X_Msg_Count OUT NOCOPY NUMBER,

Line 1548: IF FND_API.to_Boolean( p_init_msg_list )

1544: IS
1545: BEGIN
1546:
1547: -- Initialize message list if p_init_msg_list is set to TRUE.
1548: IF FND_API.to_Boolean( p_init_msg_list )
1549: THEN
1550: FND_MSG_PUB.initialize;
1551: END IF;
1552:

Line 1555: x_return_status := FND_API.G_RET_STS_SUCCESS;

1551: END IF;
1552:
1553:
1554: -- Initialize API return status to SUCCESS
1555: x_return_status := FND_API.G_RET_STS_SUCCESS;
1556:
1557: -- Hint: Validate data
1558: -- If data not valid
1559: -- THEN

Line 1560: -- x_return_status := FND_API.G_RET_STS_ERROR;

1556:
1557: -- Hint: Validate data
1558: -- If data not valid
1559: -- THEN
1560: -- x_return_status := FND_API.G_RET_STS_ERROR;
1561:
1562: -- Debug Message
1563:
1564: -- Standard call to get message count and if count is 1, get message info.

Line 1573: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1569:
1570: END Validate_Competitor_Prod_Rec;
1571:
1572: PROCEDURE Validate_competitor_prod(
1573: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1574: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1575: P_Validation_mode IN VARCHAR2,
1576: P_Competitor_Prod_Rec IN as_opportunity_pub.Competitor_Prod_Rec_Type,
1577: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1574: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1570: END Validate_Competitor_Prod_Rec;
1571:
1572: PROCEDURE Validate_competitor_prod(
1573: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1574: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1575: P_Validation_mode IN VARCHAR2,
1576: P_Competitor_Prod_Rec IN as_opportunity_pub.Competitor_Prod_Rec_Type,
1577: X_Return_Status OUT NOCOPY VARCHAR2,
1578: X_Msg_Count OUT NOCOPY NUMBER,

Line 1596: x_return_status := FND_API.G_RET_STS_SUCCESS;

1592:
1593:
1594:
1595: -- Initialize API return status to SUCCESS
1596: x_return_status := FND_API.G_RET_STS_SUCCESS;
1597:
1598: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_ITEM) THEN
1599:
1600: IF l_debug THEN

Line 1606: p_init_msg_list => FND_API.G_FALSE,

1602: 'Private API validate: REQUEST_ID');
1603: END IF;
1604:
1605: Validate_REQUEST_ID(
1606: p_init_msg_list => FND_API.G_FALSE,
1607: p_validation_mode => p_validation_mode,
1608: p_REQUEST_ID => P_Competitor_Prod_Rec.REQUEST_ID,
1609: x_return_status => x_return_status,
1610: x_msg_count => x_msg_count,

Line 1619: p_init_msg_list => FND_API.G_FALSE,

1615: 'Private API validate: WIN_LOSS_STATUS ');
1616: END IF;
1617:
1618: Validate_WIN_LOSS_STATUS(
1619: p_init_msg_list => FND_API.G_FALSE,
1620: p_validation_mode => p_validation_mode,
1621: p_WIN_LOSS_STATUS => P_Competitor_Prod_Rec.WIN_LOSS_STATUS,
1622: x_return_status => x_return_status,
1623: x_msg_count => x_msg_count,

Line 1628: p_init_msg_list => FND_API.G_FALSE,

1624: x_msg_data => x_msg_data);
1625:
1626:
1627: Validate_COMPETITOR_PRODUCT_ID(
1628: p_init_msg_list => FND_API.G_FALSE,
1629: p_validation_mode => p_validation_mode,
1630: p_COMPETITOR_PRODUCT_ID => P_Competitor_Prod_Rec.COMPETITOR_PRODUCT_ID,
1631: x_return_status => x_return_status,
1632: x_msg_count => x_msg_count,

Line 1641: p_init_msg_list => FND_API.G_FALSE,

1637: 'Private API validate: LEAD_LINE_ID');
1638: END IF;
1639:
1640: Validate_LEAD_LINE_ID(
1641: p_init_msg_list => FND_API.G_FALSE,
1642: p_validation_mode => p_validation_mode,
1643: p_LEAD_LINE_ID => P_Competitor_Prod_Rec.LEAD_LINE_ID,
1644: x_return_status => x_return_status,
1645: x_msg_count => x_msg_count,

Line 1654: p_init_msg_list => FND_API.G_FALSE,

1650: 'Private API validate: LEAD_ID');
1651: END IF;
1652:
1653: Validate_LEAD_ID(
1654: p_init_msg_list => FND_API.G_FALSE,
1655: p_validation_mode => p_validation_mode,
1656: p_LEAD_ID => P_Competitor_Prod_Rec.LEAD_ID,
1657: x_return_status => x_return_status,
1658: x_msg_count => x_msg_count,

Line 1668: p_init_msg_list => FND_API.G_FALSE,

1664: END IF;
1665:
1666:
1667: Validate_L_COMPETITOR_PROD_ID(
1668: p_init_msg_list => FND_API.G_FALSE,
1669: p_validation_mode => p_validation_mode,
1670: p_LEAD_COMPETITOR_PROD_ID => P_Competitor_Prod_Rec.LEAD_COMPETITOR_PROD_ID,
1671: x_return_status => x_return_status,
1672: x_msg_count => x_msg_count,

Line 1688: p_init_msg_list => FND_API.G_FALSE,

1684: END IF;
1685:
1686:
1687: Validate_Competitor_Prod_Rec(
1688: p_init_msg_list => FND_API.G_FALSE,
1689: p_validation_mode => p_validation_mode,
1690: P_Competitor_Prod_Rec => P_Competitor_Prod_Rec,
1691: x_return_status => x_return_status,
1692: x_msg_count => x_msg_count,

Line 1695: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1691: x_return_status => x_return_status,
1692: x_msg_count => x_msg_count,
1693: x_msg_data => x_msg_data);
1694:
1695: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1696: raise FND_API.G_EXC_ERROR;
1697: END IF;
1698: END IF;
1699:

Line 1696: raise FND_API.G_EXC_ERROR;

1692: x_msg_count => x_msg_count,
1693: x_msg_data => x_msg_data);
1694:
1695: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1696: raise FND_API.G_EXC_ERROR;
1697: END IF;
1698: END IF;
1699:
1700: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_INTER_RECORD) THEN