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_OPP_COMPETITOR_PVT dependencies on FND_API

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

13:
14: -- Hint: Primary key needs to be returned.
15: PROCEDURE Create_competitors(
16: P_Api_Version_Number IN NUMBER,
17: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
18: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: P_Admin_Group_Id IN NUMBER,
21: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,

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

14: -- Hint: Primary key needs to be returned.
15: PROCEDURE Create_competitors(
16: P_Api_Version_Number IN NUMBER,
17: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
18: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: P_Admin_Group_Id IN NUMBER,
21: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
22: P_Competitor_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type :=

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

15: PROCEDURE Create_competitors(
16: P_Api_Version_Number IN NUMBER,
17: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
18: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: P_Admin_Group_Id IN NUMBER,
21: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
22: P_Competitor_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type :=
23: AS_OPPORTUNITY_PUB.G_MISS_Competitor_Tbl,

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

21: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
22: P_Competitor_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type :=
23: AS_OPPORTUNITY_PUB.G_MISS_Competitor_Tbl,
24: X_competitor_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_out_tbl_type,
25: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
26: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
27: P_Identity_Salesforce_Id IN NUMBER := NULL,
28: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
29: X_Return_Status OUT NOCOPY VARCHAR2,

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

22: P_Competitor_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type :=
23: AS_OPPORTUNITY_PUB.G_MISS_Competitor_Tbl,
24: X_competitor_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_out_tbl_type,
25: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
26: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
27: P_Identity_Salesforce_Id IN NUMBER := NULL,
28: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
29: X_Return_Status OUT NOCOPY VARCHAR2,
30: X_Msg_Count OUT NOCOPY NUMBER,

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

24: X_competitor_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_out_tbl_type,
25: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
26: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
27: P_Identity_Salesforce_Id IN NUMBER := NULL,
28: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
29: X_Return_Status OUT NOCOPY VARCHAR2,
30: X_Msg_Count OUT NOCOPY NUMBER,
31: X_Msg_Data OUT NOCOPY VARCHAR2
32: )

Line 54: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

50: -- Standard Start of API savepoint
51: SAVEPOINT CREATE_COMPETITORS_PVT;
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)
58: THEN

Line 59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

55: p_api_version_number,
56: l_api_name,
57: G_PKG_NAME)
58: THEN
59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END IF;
61:
62:
63: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 64: IF FND_API.to_Boolean( p_init_msg_list )

60: END IF;
61:
62:
63: -- Initialize message list if p_init_msg_list is set to TRUE.
64: IF FND_API.to_Boolean( p_init_msg_list )
65: THEN
66: FND_MSG_PUB.initialize;
67: END IF;
68:

Line 79: x_return_status := FND_API.G_RET_STS_SUCCESS;

75:
76:
77:
78: -- Initialize API return status to SUCCESS
79: x_return_status := FND_API.G_RET_STS_SUCCESS;
80:
81: --
82: -- API body
83: --

Line 93: p_init_msg_list => FND_API.G_FALSE,

89: IF(FND_PROFILE.VALUE('AS_PRE_CUSTOM_ENABLED')='Y')
90: THEN
91: AS_CALLOUT_PKG.Create_competitors_BC(
92: p_api_version_number => 2.0,
93: p_init_msg_list => FND_API.G_FALSE,
94: p_commit => FND_API.G_FALSE,
95: p_validation_level => p_validation_level,
96: P_Competitor_Rec => P_Competitor_Rec,
97: -- Hint: Add detail tables as parameter lists if it's master-detail

Line 94: p_commit => FND_API.G_FALSE,

90: THEN
91: AS_CALLOUT_PKG.Create_competitors_BC(
92: p_api_version_number => 2.0,
93: p_init_msg_list => FND_API.G_FALSE,
94: p_commit => FND_API.G_FALSE,
95: p_validation_level => p_validation_level,
96: P_Competitor_Rec => P_Competitor_Rec,
97: -- Hint: Add detail tables as parameter lists if it's master-detail
98: -- relationship.

Line 118: RAISE FND_API.G_EXC_ERROR;

114: 'UT_CANNOT_GET_PROFILE_VALUE');
115: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
116: FND_MSG_PUB.ADD;
117: END IF;
118: RAISE FND_API.G_EXC_ERROR;
119: END IF;
120:
121: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN
122: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(

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

117: END IF;
118: RAISE FND_API.G_EXC_ERROR;
119: END IF;
120:
121: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN
122: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
123: p_api_version_number => 2.0
124: ,p_init_msg_list => p_init_msg_list
125: ,p_salesforce_id => p_identity_salesforce_id

Line 133: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

129: ,x_msg_data => x_msg_data
130: ,x_sales_member_rec => l_identity_sales_member_rec);
131: END IF;
132:
133: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
134: RAISE FND_API.G_EXC_ERROR;
135: END IF;
136:
137: -- Call Get_Access_Profiles to get access_profile_rec

Line 134: RAISE FND_API.G_EXC_ERROR;

130: ,x_sales_member_rec => l_identity_sales_member_rec);
131: END IF;
132:
133: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
134: RAISE FND_API.G_EXC_ERROR;
135: END IF;
136:
137: -- Call Get_Access_Profiles to get access_profile_rec
138: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

Line 169: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

165: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
166: 'API_NO_UPDATE_PRIVILEGE');
167: END IF;
168:
169: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
170: RAISE FND_API.G_EXC_ERROR;
171: END IF;
172:
173: FOR l_curr_row IN 1..l_line_count LOOP

Line 170: RAISE FND_API.G_EXC_ERROR;

166: 'API_NO_UPDATE_PRIVILEGE');
167: END IF;
168:
169: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
170: RAISE FND_API.G_EXC_ERROR;
171: END IF;
172:
173: FOR l_curr_row IN 1..l_line_count LOOP
174: X_competitor_out_tbl(l_curr_row).return_status :=

Line 175: FND_API.G_RET_STS_SUCCESS ;

171: END IF;
172:
173: FOR l_curr_row IN 1..l_line_count LOOP
174: X_competitor_out_tbl(l_curr_row).return_status :=
175: FND_API.G_RET_STS_SUCCESS ;
176:
177: -- Progress Message
178: --
179: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

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

185: END IF;
186:
187: l_competitor_rec := P_Competitor_Tbl(l_curr_row);
188:
189: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL )
190: THEN
191: -- Debug message
192: IF l_debug THEN
193: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 200: P_Init_Msg_List => FND_API.G_FALSE,

196:
197:
198: -- Invoke validation procedures
199: Validate_competitor(
200: P_Init_Msg_List => FND_API.G_FALSE,
201: P_Validation_Level => p_validation_level,
202: P_Validation_Mode => AS_UTILITY_PVT.G_CREATE,
203: P_Competitor_Rec => l_Competitor_Rec,
204: x_return_status => x_return_status,

Line 210: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

206: x_msg_data => x_msg_data
207: );
208: END IF;
209:
210: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
211: RAISE FND_API.G_EXC_ERROR;
212: END IF;
213:
214: -- Debug Message

Line 211: RAISE FND_API.G_EXC_ERROR;

207: );
208: END IF;
209:
210: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
211: RAISE FND_API.G_EXC_ERROR;
212: END IF;
213:
214: -- Debug Message
215: IF l_debug THEN

Line 265: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

261: X_competitor_out_tbl(l_curr_row).LEAD_COMPETITOR_ID :=
262: l_LEAD_COMPETITOR_ID;
263: X_competitor_out_tbl(l_curr_row).return_status := x_return_status;
264:
265: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
266: RAISE FND_API.G_EXC_ERROR;
267: END IF;
268:
269: END LOOP;

Line 266: RAISE FND_API.G_EXC_ERROR;

262: l_LEAD_COMPETITOR_ID;
263: X_competitor_out_tbl(l_curr_row).return_status := x_return_status;
264:
265: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
266: RAISE FND_API.G_EXC_ERROR;
267: END IF;
268:
269: END LOOP;
270: --

Line 275: IF FND_API.to_Boolean( p_commit )

271: -- End of API body
272: --
273:
274: -- Standard check for p_commit
275: IF FND_API.to_Boolean( p_commit )
276: THEN
277: COMMIT WORK;
278: END IF;
279:

Line 303: p_init_msg_list => FND_API.G_FALSE,

299: IF(FND_PROFILE.VALUE('AS_POST_CUSTOM_ENABLED')='Y')
300: THEN
301: AS_CALLOUT_PKG.Create_competitors_AC(
302: p_api_version_number => 2.0,
303: p_init_msg_list => FND_API.G_FALSE,
304: p_commit => FND_API.G_FALSE,
305: p_validation_level => p_validation_level,
306: P_Competitor_Rec => P_Competitor_Rec,
307: -- Hint: Add detail tables as parameter lists if it's master-detail

Line 304: p_commit => FND_API.G_FALSE,

300: THEN
301: AS_CALLOUT_PKG.Create_competitors_AC(
302: p_api_version_number => 2.0,
303: p_init_msg_list => FND_API.G_FALSE,
304: p_commit => FND_API.G_FALSE,
305: p_validation_level => p_validation_level,
306: P_Competitor_Rec => P_Competitor_Rec,
307: -- Hint: Add detail tables as parameter lists if it's master-detail
308: -- relationship.

Line 315: WHEN FND_API.G_EXC_ERROR THEN

311: x_msg_data => x_msg_data);
312: END IF;
313: */
314: EXCEPTION
315: WHEN FND_API.G_EXC_ERROR THEN
316: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
317: P_MODULE => l_module
318: ,P_API_NAME => L_API_NAME
319: ,P_PKG_NAME => G_PKG_NAME

Line 326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

322: ,X_MSG_COUNT => X_MSG_COUNT
323: ,X_MSG_DATA => X_MSG_DATA
324: ,X_RETURN_STATUS => X_RETURN_STATUS);
325:
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
327: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
328: P_MODULE => l_module
329: ,P_API_NAME => L_API_NAME
330: ,P_PKG_NAME => G_PKG_NAME

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

348:
349:
350: PROCEDURE Update_competitors(
351: P_Api_Version_Number IN NUMBER,
352: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
353: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
354: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
355: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
356: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

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

349:
350: PROCEDURE Update_competitors(
351: P_Api_Version_Number IN NUMBER,
352: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
353: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
354: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
355: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
356: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
357: P_Admin_Group_Id IN NUMBER,

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

350: PROCEDURE Update_competitors(
351: P_Api_Version_Number IN NUMBER,
352: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
353: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
354: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
355: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
356: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
357: P_Admin_Group_Id IN NUMBER,
358: P_Identity_Salesforce_Id IN NUMBER,

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

351: P_Api_Version_Number IN NUMBER,
352: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
353: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
354: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
355: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
356: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
357: P_Admin_Group_Id IN NUMBER,
358: P_Identity_Salesforce_Id IN NUMBER,
359: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,

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

352: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
353: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
354: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
355: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
356: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
357: P_Admin_Group_Id IN NUMBER,
358: P_Identity_Salesforce_Id IN NUMBER,
359: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
360: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,

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

356: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
357: P_Admin_Group_Id IN NUMBER,
358: P_Identity_Salesforce_Id IN NUMBER,
359: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
360: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
361: P_Competitor_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type,
362: X_competitor_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_out_tbl_type,
363: X_Return_Status OUT NOCOPY VARCHAR2,
364: X_Msg_Count OUT NOCOPY NUMBER,

Line 393: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

389: -- Standard Start of API savepoint
390: SAVEPOINT UPDATE_COMPETITORS_PVT;
391:
392: -- Standard call to check for call compatibility.
393: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
394: p_api_version_number,
395: l_api_name,
396: G_PKG_NAME)
397: THEN

Line 398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

394: p_api_version_number,
395: l_api_name,
396: G_PKG_NAME)
397: THEN
398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
399: END IF;
400:
401:
402: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 403: IF FND_API.to_Boolean( p_init_msg_list )

399: END IF;
400:
401:
402: -- Initialize message list if p_init_msg_list is set to TRUE.
403: IF FND_API.to_Boolean( p_init_msg_list )
404: THEN
405: FND_MSG_PUB.initialize;
406: END IF;
407:

Line 418: x_return_status := FND_API.G_RET_STS_SUCCESS;

414:
415:
416:
417: -- Initialize API return status to SUCCESS
418: x_return_status := FND_API.G_RET_STS_SUCCESS;
419:
420: --
421: -- Api body
422: --

Line 431: p_init_msg_list => FND_API.G_FALSE,

427: IF(FND_PROFILE.VALUE('AS_PRE_CUSTOM_ENABLED')='Y')
428: THEN
429: AS_CALLOUT_PKG.Update_competitors_BU(
430: p_api_version_number => 2.0,
431: p_init_msg_list => FND_API.G_FALSE,
432: p_commit => FND_API.G_FALSE,
433: p_validation_level => p_validation_level,
434: p_identity_salesforce_id => p_identity_salesforce_id,
435: P_Competitor_Rec => P_Competitor_Rec,

Line 432: p_commit => FND_API.G_FALSE,

428: THEN
429: AS_CALLOUT_PKG.Update_competitors_BU(
430: p_api_version_number => 2.0,
431: p_init_msg_list => FND_API.G_FALSE,
432: p_commit => FND_API.G_FALSE,
433: p_validation_level => p_validation_level,
434: p_identity_salesforce_id => p_identity_salesforce_id,
435: P_Competitor_Rec => P_Competitor_Rec,
436: -- Hint: Add detail tables as parameter lists if it's master-detail

Line 446: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL )

442: */
443:
444:
445:
446: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL )
447: THEN
448: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
449: p_api_version_number => 2.0
450: ,p_init_msg_list => p_init_msg_list

Line 459: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

455: ,x_msg_data => x_msg_data
456: ,x_sales_member_rec => l_identity_sales_member_rec);
457: END IF;
458:
459: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
460: RAISE FND_API.G_EXC_ERROR;
461: END IF;
462:
463: -- Call Get_Access_Profiles to get access_profile_rec

Line 460: RAISE FND_API.G_EXC_ERROR;

456: ,x_sales_member_rec => l_identity_sales_member_rec);
457: END IF;
458:
459: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
460: RAISE FND_API.G_EXC_ERROR;
461: END IF;
462:
463: -- Call Get_Access_Profiles to get access_profile_rec
464: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

Line 495: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

491: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
492: 'API_NO_UPDATE_PRIVILEGE');
493: END IF;
494:
495: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
496: RAISE FND_API.G_EXC_ERROR;
497: END IF;
498:
499: FOR l_curr_row IN 1..l_line_count LOOP

Line 496: RAISE FND_API.G_EXC_ERROR;

492: 'API_NO_UPDATE_PRIVILEGE');
493: END IF;
494:
495: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
496: RAISE FND_API.G_EXC_ERROR;
497: END IF;
498:
499: FOR l_curr_row IN 1..l_line_count LOOP
500: X_competitor_out_tbl(l_curr_row).return_status :=

Line 501: FND_API.G_RET_STS_SUCCESS ;

497: END IF;
498:
499: FOR l_curr_row IN 1..l_line_count LOOP
500: X_competitor_out_tbl(l_curr_row).return_status :=
501: FND_API.G_RET_STS_SUCCESS ;
502:
503: -- Progress Message
504: --
505: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 533: raise FND_API.G_EXC_ERROR;

529: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
530: FND_MESSAGE.Set_Token ('INFO', 'competitor', FALSE);
531: FND_MSG_PUB.Add;
532: END IF;
533: raise FND_API.G_EXC_ERROR;
534: END IF;
535: -- Debug Message
536: IF l_debug THEN
537: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 544: l_Competitor_rec.last_update_date = FND_API.G_MISS_Date ) Then

540:
541: Close C_Get_competitor;
542:
543: If (l_Competitor_rec.last_update_date is NULL or
544: l_Competitor_rec.last_update_date = FND_API.G_MISS_Date ) Then
545: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
546: THEN
547: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
548: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

Line 551: raise FND_API.G_EXC_ERROR;

547: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
548: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
549: FND_MSG_PUB.ADD;
550: END IF;
551: raise FND_API.G_EXC_ERROR;
552: End if;
553: -- Check Whether record has been changed by someone else
554: If (l_Competitor_rec.last_update_date <> l_last_update_date) Then
555: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 561: raise FND_API.G_EXC_ERROR;

557: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
558: FND_MESSAGE.Set_Token('INFO', 'competitor', FALSE);
559: FND_MSG_PUB.ADD;
560: END IF;
561: raise FND_API.G_EXC_ERROR;
562: End if;
563:
564: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL )
565: THEN

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

560: END IF;
561: raise FND_API.G_EXC_ERROR;
562: End if;
563:
564: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL )
565: THEN
566: -- Debug message
567: IF l_debug THEN
568: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 575: p_init_msg_list => FND_API.G_FALSE,

571:
572:
573: -- Invoke validation procedures
574: Validate_competitor(
575: p_init_msg_list => FND_API.G_FALSE,
576: p_validation_level => p_validation_level,
577: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,
578: P_Competitor_Rec => l_Competitor_Rec,
579: x_return_status => x_return_status,

Line 584: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

580: x_msg_count => x_msg_count,
581: x_msg_data => x_msg_data);
582: END IF;
583:
584: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
585: RAISE FND_API.G_EXC_ERROR;
586: END IF;
587:
588: -- Debug Message

Line 585: RAISE FND_API.G_EXC_ERROR;

581: x_msg_data => x_msg_data);
582: END IF;
583:
584: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
585: RAISE FND_API.G_EXC_ERROR;
586: END IF;
587:
588: -- Debug Message
589: IF l_debug THEN

Line 637: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

633: X_competitor_out_tbl(l_curr_row).LEAD_COMPETITOR_ID :=
634: l_Competitor_rec.LEAD_COMPETITOR_ID;
635: X_competitor_out_tbl(l_curr_row).return_status := x_return_status;
636:
637: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
638: RAISE FND_API.G_EXC_ERROR;
639: END IF;
640:
641: END LOOP;

Line 638: RAISE FND_API.G_EXC_ERROR;

634: l_Competitor_rec.LEAD_COMPETITOR_ID;
635: X_competitor_out_tbl(l_curr_row).return_status := x_return_status;
636:
637: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
638: RAISE FND_API.G_EXC_ERROR;
639: END IF;
640:
641: END LOOP;
642:

Line 648: IF FND_API.to_Boolean( p_commit )

644: -- End of API body.
645: --
646:
647: -- Standard check for p_commit
648: IF FND_API.to_Boolean( p_commit )
649: THEN
650: COMMIT WORK;
651: END IF;
652:

Line 676: p_init_msg_list => FND_API.G_FALSE,

672: IF(FND_PROFILE.VALUE('AS_POST_CUSTOM_ENABLED')='Y')
673: THEN
674: AS_CALLOUT_PKG.Update_competitors_AU(
675: p_api_version_number => 2.0,
676: p_init_msg_list => FND_API.G_FALSE,
677: p_commit => FND_API.G_FALSE,
678: p_validation_level => p_validation_level,
679: p_identity_salesforce_id => p_identity_salesforce_id,
680: P_Competitor_Rec => P_Competitor_Rec,

Line 677: p_commit => FND_API.G_FALSE,

673: THEN
674: AS_CALLOUT_PKG.Update_competitors_AU(
675: p_api_version_number => 2.0,
676: p_init_msg_list => FND_API.G_FALSE,
677: p_commit => FND_API.G_FALSE,
678: p_validation_level => p_validation_level,
679: p_identity_salesforce_id => p_identity_salesforce_id,
680: P_Competitor_Rec => P_Competitor_Rec,
681: -- Hint: Add detail tables as parameter lists if it's master-detail

Line 689: WHEN FND_API.G_EXC_ERROR THEN

685: x_msg_data => x_msg_data);
686: END IF;
687: */
688: EXCEPTION
689: WHEN FND_API.G_EXC_ERROR THEN
690: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
691: P_MODULE => l_module
692: ,P_API_NAME => L_API_NAME
693: ,P_PKG_NAME => G_PKG_NAME

Line 700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

696: ,X_MSG_COUNT => X_MSG_COUNT
697: ,X_MSG_DATA => X_MSG_DATA
698: ,X_RETURN_STATUS => X_RETURN_STATUS);
699:
700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
701: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
702: P_MODULE => l_module
703: ,P_API_NAME => L_API_NAME
704: ,P_PKG_NAME => G_PKG_NAME

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

726: -- The Master delete procedure may not be needed depends on different
727: -- business requirements.
728: PROCEDURE Delete_competitors(
729: P_Api_Version_Number IN NUMBER,
730: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
731: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
732: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
733: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
734: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

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

727: -- business requirements.
728: PROCEDURE Delete_competitors(
729: P_Api_Version_Number IN NUMBER,
730: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
731: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
732: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
733: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
734: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
735: P_Admin_Group_Id IN NUMBER,

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

728: PROCEDURE Delete_competitors(
729: P_Api_Version_Number IN NUMBER,
730: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
731: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
732: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
733: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
734: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
735: P_Admin_Group_Id IN NUMBER,
736: P_Identity_Salesforce_Id IN NUMBER,

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

729: P_Api_Version_Number IN NUMBER,
730: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
731: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
732: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
733: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
734: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
735: P_Admin_Group_Id IN NUMBER,
736: P_Identity_Salesforce_Id IN NUMBER,
737: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,

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

730: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
731: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
732: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
733: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
734: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
735: P_Admin_Group_Id IN NUMBER,
736: P_Identity_Salesforce_Id IN NUMBER,
737: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
738: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,

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

734: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
735: P_Admin_Group_Id IN NUMBER,
736: P_Identity_Salesforce_Id IN NUMBER,
737: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
738: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
739: P_Competitor_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type,
740: X_competitor_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_out_tbl_type,
741: X_Return_Status OUT NOCOPY VARCHAR2,
742: X_Msg_Count OUT NOCOPY NUMBER,

Line 764: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

760: -- Standard Start of API savepoint
761: SAVEPOINT DELETE_COMPETITORS_PVT;
762:
763: -- Standard call to check for call compatibility.
764: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
765: p_api_version_number,
766: l_api_name,
767: G_PKG_NAME)
768: THEN

Line 769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

765: p_api_version_number,
766: l_api_name,
767: G_PKG_NAME)
768: THEN
769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
770: END IF;
771:
772:
773: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 774: IF FND_API.to_Boolean( p_init_msg_list )

770: END IF;
771:
772:
773: -- Initialize message list if p_init_msg_list is set to TRUE.
774: IF FND_API.to_Boolean( p_init_msg_list )
775: THEN
776: FND_MSG_PUB.initialize;
777: END IF;
778:

Line 789: x_return_status := FND_API.G_RET_STS_SUCCESS;

785:
786:
787:
788: -- Initialize API return status to SUCCESS
789: x_return_status := FND_API.G_RET_STS_SUCCESS;
790:
791: --
792: -- Api body
793: --

Line 801: p_init_msg_list => FND_API.G_FALSE,

797: IF(FND_PROFILE.VALUE('AS_PRE_CUSTOM_ENABLED')='Y')
798: THEN
799: AS_CALLOUT_PKG.Delete_competitors_BD(
800: p_api_version_number => 2.0,
801: p_init_msg_list => FND_API.G_FALSE,
802: p_commit => FND_API.G_FALSE,
803: p_validation_level => p_validation_level,
804: p_identity_salesforce_id => p_identity_salesforce_id,
805: P_Competitor_Rec => P_Competitor_Rec,

Line 802: p_commit => FND_API.G_FALSE,

798: THEN
799: AS_CALLOUT_PKG.Delete_competitors_BD(
800: p_api_version_number => 2.0,
801: p_init_msg_list => FND_API.G_FALSE,
802: p_commit => FND_API.G_FALSE,
803: p_validation_level => p_validation_level,
804: p_identity_salesforce_id => p_identity_salesforce_id,
805: P_Competitor_Rec => P_Competitor_Rec,
806: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.

Line 813: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL )

809: x_msg_data => x_msg_data);
810: END IF;
811: */
812:
813: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL )
814: THEN
815: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
816: p_api_version_number => 2.0
817: ,p_init_msg_list => p_init_msg_list

Line 826: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

822: ,x_msg_data => x_msg_data
823: ,x_sales_member_rec => l_identity_sales_member_rec);
824: END IF;
825:
826: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
827: RAISE FND_API.G_EXC_ERROR;
828: END IF;
829:
830: -- Call Get_Access_Profiles to get access_profile_rec

Line 827: RAISE FND_API.G_EXC_ERROR;

823: ,x_sales_member_rec => l_identity_sales_member_rec);
824: END IF;
825:
826: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
827: RAISE FND_API.G_EXC_ERROR;
828: END IF;
829:
830: -- Call Get_Access_Profiles to get access_profile_rec
831: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

Line 862: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

858: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
859: 'API_NO_UPDATE_PRIVILEGE');
860: END IF;
861:
862: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
863: RAISE FND_API.G_EXC_ERROR;
864: END IF;
865:
866: FOR l_curr_row IN 1..l_line_count LOOP

Line 863: RAISE FND_API.G_EXC_ERROR;

859: 'API_NO_UPDATE_PRIVILEGE');
860: END IF;
861:
862: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
863: RAISE FND_API.G_EXC_ERROR;
864: END IF;
865:
866: FOR l_curr_row IN 1..l_line_count LOOP
867: X_competitor_out_tbl(l_curr_row).return_status :=

Line 868: FND_API.G_RET_STS_SUCCESS ;

864: END IF;
865:
866: FOR l_curr_row IN 1..l_line_count LOOP
867: X_competitor_out_tbl(l_curr_row).return_status :=
868: FND_API.G_RET_STS_SUCCESS ;
869:
870: -- Progress Message
871: --
872: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 897: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

893: X_competitor_out_tbl(l_curr_row).LEAD_COMPETITOR_ID :=
894: l_LEAD_COMPETITOR_ID;
895: X_competitor_out_tbl(l_curr_row).return_status := x_return_status;
896:
897: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
898: RAISE FND_API.G_EXC_ERROR;
899: END IF;
900:
901: END LOOP;

Line 898: RAISE FND_API.G_EXC_ERROR;

894: l_LEAD_COMPETITOR_ID;
895: X_competitor_out_tbl(l_curr_row).return_status := x_return_status;
896:
897: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
898: RAISE FND_API.G_EXC_ERROR;
899: END IF;
900:
901: END LOOP;
902:

Line 908: IF FND_API.to_Boolean( p_commit )

904: -- End of API body
905: --
906:
907: -- Standard check for p_commit
908: IF FND_API.to_Boolean( p_commit )
909: THEN
910: COMMIT WORK;
911: END IF;
912:

Line 936: p_init_msg_list => FND_API.G_FALSE,

932: IF(FND_PROFILE.VALUE('AS_POST_CUSTOM_ENABLED')='Y')
933: THEN
934: AS_CALLOUT_PKG.Delete_competitors_AD(
935: p_api_version_number => 2.0,
936: p_init_msg_list => FND_API.G_FALSE,
937: p_commit => FND_API.G_FALSE,
938: p_validation_level => p_validation_level,
939: p_identity_salesforce_id => p_identity_salesforce_id,
940: P_Competitor_Rec => P_Competitor_Rec,

Line 937: p_commit => FND_API.G_FALSE,

933: THEN
934: AS_CALLOUT_PKG.Delete_competitors_AD(
935: p_api_version_number => 2.0,
936: p_init_msg_list => FND_API.G_FALSE,
937: p_commit => FND_API.G_FALSE,
938: p_validation_level => p_validation_level,
939: p_identity_salesforce_id => p_identity_salesforce_id,
940: P_Competitor_Rec => P_Competitor_Rec,
941: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.

Line 948: WHEN FND_API.G_EXC_ERROR THEN

944: x_msg_data => x_msg_data);
945: END IF;
946: */
947: EXCEPTION
948: WHEN FND_API.G_EXC_ERROR THEN
949: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
950: P_MODULE => l_module
951: ,P_API_NAME => L_API_NAME
952: ,P_PKG_NAME => G_PKG_NAME

Line 959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

955: ,X_MSG_COUNT => X_MSG_COUNT
956: ,X_MSG_DATA => X_MSG_DATA
957: ,X_RETURN_STATUS => X_RETURN_STATUS);
958:
959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
960: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
961: P_MODULE => l_module
962: ,P_API_NAME => L_API_NAME
963: ,P_PKG_NAME => G_PKG_NAME

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

981:
982:
983: -- Item-level validation procedures
984: PROCEDURE Validate_LEAD_COMPETITOR_ID (
985: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
986: P_Validation_mode IN VARCHAR2,
987: P_LEAD_COMPETITOR_ID IN NUMBER,
988: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
989: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1004: IF FND_API.to_Boolean( p_init_msg_list )

1000: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cmppv.Validate_LEAD_COMPETITOR_ID';
1001:
1002: BEGIN
1003: -- Initialize message list if p_init_msg_list is set to TRUE.
1004: IF FND_API.to_Boolean( p_init_msg_list )
1005: THEN
1006: FND_MSG_PUB.initialize;
1007: END IF;
1008:

Line 1011: x_return_status := FND_API.G_RET_STS_SUCCESS;

1007: END IF;
1008:
1009:
1010: -- Initialize API return status to SUCCESS
1011: x_return_status := FND_API.G_RET_STS_SUCCESS;
1012:
1013: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1014: THEN
1015:

Line 1016: IF (p_LEAD_COMPETITOR_ID is not NULL) and (p_LEAD_COMPETITOR_ID <> FND_API.G_MISS_NUM)

1012:
1013: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1014: THEN
1015:
1016: IF (p_LEAD_COMPETITOR_ID is not NULL) and (p_LEAD_COMPETITOR_ID <> FND_API.G_MISS_NUM)
1017: THEN
1018: OPEN C_Lead_Competitor_Id_Exists (p_Lead_Competitor_Id);
1019: FETCH C_Lead_Competitor_Id_Exists into l_val;
1020:

Line 1027: x_return_status := FND_API.G_RET_STS_ERROR;

1023: p_module => l_module,
1024: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1025: p_msg_name => 'API_DUPLICATE_LEAD_COMPETITOR_ID');
1026:
1027: x_return_status := FND_API.G_RET_STS_ERROR;
1028: END IF;
1029:
1030: CLOSE C_Lead_Competitor_Id_Exists;
1031: END IF;

Line 1036: IF (p_LEAD_COMPETITOR_ID is NULL) or (p_LEAD_COMPETITOR_ID = FND_API.G_MISS_NUM)

1032:
1033: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1034: THEN
1035:
1036: IF (p_LEAD_COMPETITOR_ID is NULL) or (p_LEAD_COMPETITOR_ID = FND_API.G_MISS_NUM)
1037: THEN
1038: AS_UTILITY_PVT.Set_Message(
1039: p_module => l_module,
1040: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1043: x_return_status := FND_API.G_RET_STS_ERROR;

1039: p_module => l_module,
1040: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1041: p_msg_name => 'API_MISSING_LEAD_COMPETITOR_ID');
1042:
1043: x_return_status := FND_API.G_RET_STS_ERROR;
1044: ELSE
1045: OPEN C_Lead_Competitor_Id_Exists (p_Lead_Competitor_Id);
1046: FETCH C_Lead_Competitor_Id_Exists into l_val;
1047:

Line 1057: x_return_status := FND_API.G_RET_STS_ERROR;

1053: p_msg_name => 'API_INVALID_LEAD_COMPETITOR_ID',
1054: p_token1 => 'VALUE',
1055: p_token1_value => p_LEAD_COMPETITOR_ID );
1056:
1057: x_return_status := FND_API.G_RET_STS_ERROR;
1058: END IF;
1059:
1060: CLOSE C_Lead_Competitor_Id_Exists;
1061: END IF;

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

1072:
1073:
1074:
1075: PROCEDURE Validate_LEAD_ID (
1076: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1077: P_Validation_mode IN VARCHAR2,
1078: P_LEAD_ID IN NUMBER,
1079: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
1080: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1097: IF FND_API.to_Boolean( p_init_msg_list )

1093:
1094: BEGIN
1095:
1096: -- Initialize message list if p_init_msg_list is set to TRUE.
1097: IF FND_API.to_Boolean( p_init_msg_list )
1098: THEN
1099: FND_MSG_PUB.initialize;
1100: END IF;
1101:

Line 1104: x_return_status := FND_API.G_RET_STS_SUCCESS;

1100: END IF;
1101:
1102:
1103: -- Initialize API return status to SUCCESS
1104: x_return_status := FND_API.G_RET_STS_SUCCESS;
1105:
1106: -- validate NOT NULL column
1107: IF(p_LEAD_ID is NULL)
1108: THEN

Line 1114: x_return_status := FND_API.G_RET_STS_ERROR;

1110: AS_UTILITY_PVT.Debug_Message(l_module, 'ERROR',
1111: 'Private API: Violate NOT NULL constraint(LEAD_ID)');
1112: END IF;
1113:
1114: x_return_status := FND_API.G_RET_STS_ERROR;
1115: END IF;
1116:
1117: IF (p_LEAD_ID is NULL) or (p_LEAD_ID = FND_API.G_MISS_NUM)
1118: THEN

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

1113:
1114: x_return_status := FND_API.G_RET_STS_ERROR;
1115: END IF;
1116:
1117: IF (p_LEAD_ID is NULL) or (p_LEAD_ID = FND_API.G_MISS_NUM)
1118: THEN
1119: AS_UTILITY_PVT.Set_Message(
1120: p_module => l_module,
1121: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1124: x_return_status := FND_API.G_RET_STS_ERROR;

1120: p_module => l_module,
1121: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1122: p_msg_name => 'API_MISSING_LEAD_ID');
1123:
1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125: ELSE
1126: OPEN C_Lead_Id_Exists (p_Lead_Id);
1127: FETCH C_Lead_Id_Exists into l_val;
1128:

Line 1138: x_return_status := FND_API.G_RET_STS_ERROR;

1134: p_msg_name => 'API_INVALID_LEAD_ID',
1135: p_token1 => 'VALUE',
1136: p_token1_value => p_LEAD_ID );
1137:
1138: x_return_status := FND_API.G_RET_STS_ERROR;
1139: END IF;
1140:
1141: CLOSE C_Lead_Id_Exists;
1142: END IF;

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

1151:
1152:
1153:
1154: PROCEDURE Validate_COMPETITOR_ID (
1155: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1156: P_Validation_mode IN VARCHAR2,
1157: P_COMPETITOR_ID IN NUMBER,
1158: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
1159: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1178: IF FND_API.to_Boolean( p_init_msg_list )

1174:
1175: BEGIN
1176:
1177: -- Initialize message list if p_init_msg_list is set to TRUE.
1178: IF FND_API.to_Boolean( p_init_msg_list )
1179: THEN
1180: FND_MSG_PUB.initialize;
1181: END IF;
1182:

Line 1185: x_return_status := FND_API.G_RET_STS_SUCCESS;

1181: END IF;
1182:
1183:
1184: -- Initialize API return status to SUCCESS
1185: x_return_status := FND_API.G_RET_STS_SUCCESS;
1186:
1187: IF(p_COMPETITOR_ID is NULL)
1188: THEN
1189: IF l_debug THEN

Line 1194: x_return_status := FND_API.G_RET_STS_ERROR;

1190: AS_UTILITY_PVT.Debug_Message(l_module, 'ERROR',
1191: 'Private API: Violate NOT NULL constraint(COMPETITOR_ID)');
1192: END IF;
1193:
1194: x_return_status := FND_API.G_RET_STS_ERROR;
1195: END IF;
1196:
1197: IF (p_COMPETITOR_ID is NOT NULL) and (p_COMPETITOR_ID <> FND_API.G_MISS_NUM)
1198: THEN

Line 1197: IF (p_COMPETITOR_ID is NOT NULL) and (p_COMPETITOR_ID <> FND_API.G_MISS_NUM)

1193:
1194: x_return_status := FND_API.G_RET_STS_ERROR;
1195: END IF;
1196:
1197: IF (p_COMPETITOR_ID is NOT NULL) and (p_COMPETITOR_ID <> FND_API.G_MISS_NUM)
1198: THEN
1199:
1200: OPEN C_COMPETITOR_Id_Exists (p_COMPETITOR_Id);
1201: FETCH C_COMPETITOR_Id_Exists into l_val;

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

1226: -- cursor to get old values for all fields used in inter-field validation
1227: -- and set all G_MISS_XXX fields to original value stored in database
1228: -- table.
1229: PROCEDURE Validate_Competitor_rec(
1230: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1231: P_Validation_mode IN VARCHAR2,
1232: P_Competitor_Rec IN AS_OPPORTUNITY_PUB.Competitor_Rec_Type,
1233: X_Return_Status OUT NOCOPY VARCHAR2,
1234: X_Msg_Count OUT NOCOPY NUMBER,

Line 1243: IF FND_API.to_Boolean( p_init_msg_list )

1239: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cmppv.Validate_Competitor_rec';
1240: BEGIN
1241:
1242: -- Initialize message list if p_init_msg_list is set to TRUE.
1243: IF FND_API.to_Boolean( p_init_msg_list )
1244: THEN
1245: FND_MSG_PUB.initialize;
1246: END IF;
1247:

Line 1250: x_return_status := FND_API.G_RET_STS_SUCCESS;

1246: END IF;
1247:
1248:
1249: -- Initialize API return status to SUCCESS
1250: x_return_status := FND_API.G_RET_STS_SUCCESS;
1251:
1252: -- Hint: Validate data
1253: -- If data not valid
1254: -- THEN

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

1251:
1252: -- Hint: Validate data
1253: -- If data not valid
1254: -- THEN
1255: -- x_return_status := FND_API.G_RET_STS_ERROR;
1256:
1257: -- Debug Message
1258: IF l_debug THEN
1259: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

1270: END Validate_Competitor_Rec;
1271:
1272:
1273: PROCEDURE Validate_competitor(
1274: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1275: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1276: P_Validation_mode IN VARCHAR2,
1277: P_Competitor_Rec IN AS_OPPORTUNITY_PUB.Competitor_Rec_Type,
1278: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1275: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1271:
1272:
1273: PROCEDURE Validate_competitor(
1274: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1275: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1276: P_Validation_mode IN VARCHAR2,
1277: P_Competitor_Rec IN AS_OPPORTUNITY_PUB.Competitor_Rec_Type,
1278: X_Return_Status OUT NOCOPY VARCHAR2,
1279: X_Msg_Count OUT NOCOPY NUMBER,

Line 1297: x_return_status := FND_API.G_RET_STS_SUCCESS;

1293: 'Private API: ' || l_api_name || ' start');
1294: END IF;
1295:
1296: -- Initialize API return status to SUCCESS
1297: x_return_status := FND_API.G_RET_STS_SUCCESS;
1298:
1299: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_ITEM) THEN
1300: -- Hint: We provide validation procedure for every column. Developer
1301: -- should delete unnecessary validation procedures.

Line 1304: p_init_msg_list => FND_API.G_FALSE,

1300: -- Hint: We provide validation procedure for every column. Developer
1301: -- should delete unnecessary validation procedures.
1302:
1303: Validate_LEAD_COMPETITOR_ID(
1304: p_init_msg_list => FND_API.G_FALSE,
1305: p_validation_mode => p_validation_mode,
1306: p_LEAD_COMPETITOR_ID => P_Competitor_Rec.LEAD_COMPETITOR_ID,
1307: x_item_property_rec => l_item_property_rec,
1308: x_return_status => x_return_status,

Line 1312: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1308: x_return_status => x_return_status,
1309: x_msg_count => x_msg_count,
1310: x_msg_data => x_msg_data);
1311:
1312: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1313: raise FND_API.G_EXC_ERROR;
1314: END IF;
1315:
1316:

Line 1313: raise FND_API.G_EXC_ERROR;

1309: x_msg_count => x_msg_count,
1310: x_msg_data => x_msg_data);
1311:
1312: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1313: raise FND_API.G_EXC_ERROR;
1314: END IF;
1315:
1316:
1317: Validate_LEAD_ID(

Line 1318: p_init_msg_list => FND_API.G_FALSE,

1314: END IF;
1315:
1316:
1317: Validate_LEAD_ID(
1318: p_init_msg_list => FND_API.G_FALSE,
1319: p_validation_mode => p_validation_mode,
1320: p_LEAD_ID => P_Competitor_Rec.LEAD_ID,
1321: x_item_property_rec => l_item_property_rec,
1322: x_return_status => x_return_status,

Line 1326: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1322: x_return_status => x_return_status,
1323: x_msg_count => x_msg_count,
1324: x_msg_data => x_msg_data);
1325:
1326: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1327: raise FND_API.G_EXC_ERROR;
1328: END IF;
1329:
1330:

Line 1327: raise FND_API.G_EXC_ERROR;

1323: x_msg_count => x_msg_count,
1324: x_msg_data => x_msg_data);
1325:
1326: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1327: raise FND_API.G_EXC_ERROR;
1328: END IF;
1329:
1330:
1331: Validate_COMPETITOR_ID(

Line 1332: p_init_msg_list => FND_API.G_FALSE,

1328: END IF;
1329:
1330:
1331: Validate_COMPETITOR_ID(
1332: p_init_msg_list => FND_API.G_FALSE,
1333: p_validation_mode => p_validation_mode,
1334: p_COMPETITOR_ID => P_Competitor_Rec.COMPETITOR_ID,
1335: x_item_property_rec => l_item_property_rec,
1336: x_return_status => x_return_status,

Line 1340: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1336: x_return_status => x_return_status,
1337: x_msg_count => x_msg_count,
1338: x_msg_data => x_msg_data);
1339:
1340: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1341: raise FND_API.G_EXC_ERROR;
1342: END IF;
1343:
1344: END IF;

Line 1341: raise FND_API.G_EXC_ERROR;

1337: x_msg_count => x_msg_count,
1338: x_msg_data => x_msg_data);
1339:
1340: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1341: raise FND_API.G_EXC_ERROR;
1342: END IF;
1343:
1344: END IF;
1345:

Line 1351: p_init_msg_list => FND_API.G_FALSE,

1347: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_RECORD) THEN
1348: -- Hint: Inter-field level validation can be added here
1349: -- invoke record level validation procedures
1350: Validate_Competitor_Rec(
1351: p_init_msg_list => FND_API.G_FALSE,
1352: p_validation_mode => p_validation_mode,
1353: P_Competitor_Rec => P_Competitor_Rec,
1354: x_return_status => x_return_status,
1355: x_msg_count => x_msg_count,

Line 1358: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1354: x_return_status => x_return_status,
1355: x_msg_count => x_msg_count,
1356: x_msg_data => x_msg_data);
1357:
1358: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1359: raise FND_API.G_EXC_ERROR;
1360: END IF;
1361: END IF;
1362: */

Line 1359: raise FND_API.G_EXC_ERROR;

1355: x_msg_count => x_msg_count,
1356: x_msg_data => x_msg_data);
1357:
1358: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1359: raise FND_API.G_EXC_ERROR;
1360: END IF;
1361: END IF;
1362: */
1363: