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

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

14: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxvlcpb.pls';
15:
16: PROCEDURE Copy_Opportunity
17: ( p_api_version_number IN NUMBER,
18: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
19: p_commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21: p_lead_id IN NUMBER,
22: p_description IN VARCHAR2,

Line 19: p_commit IN VARCHAR2 := FND_API.G_FALSE,

15:
16: PROCEDURE Copy_Opportunity
17: ( p_api_version_number IN NUMBER,
18: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
19: p_commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21: p_lead_id IN NUMBER,
22: p_description IN VARCHAR2,
23: p_copy_salesteam IN VARCHAR2 :=FND_API.G_FALSE,

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

16: PROCEDURE Copy_Opportunity
17: ( p_api_version_number IN NUMBER,
18: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
19: p_commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21: p_lead_id IN NUMBER,
22: p_description IN VARCHAR2,
23: p_copy_salesteam IN VARCHAR2 :=FND_API.G_FALSE,
24: p_copy_opp_lines IN VARCHAR2 :=FND_API.G_FALSE,

Line 23: p_copy_salesteam IN VARCHAR2 :=FND_API.G_FALSE,

19: p_commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21: p_lead_id IN NUMBER,
22: p_description IN VARCHAR2,
23: p_copy_salesteam IN VARCHAR2 :=FND_API.G_FALSE,
24: p_copy_opp_lines IN VARCHAR2 :=FND_API.G_FALSE,
25: p_copy_lead_contacts IN VARCHAR2 :=FND_API.G_FALSE,
26: p_copy_lead_competitors IN VARCHAR2 :=FND_API.G_FALSE,
27: p_copy_sales_credits IN VARCHAR2 :=FND_API.G_FALSE,

Line 24: p_copy_opp_lines IN VARCHAR2 :=FND_API.G_FALSE,

20: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21: p_lead_id IN NUMBER,
22: p_description IN VARCHAR2,
23: p_copy_salesteam IN VARCHAR2 :=FND_API.G_FALSE,
24: p_copy_opp_lines IN VARCHAR2 :=FND_API.G_FALSE,
25: p_copy_lead_contacts IN VARCHAR2 :=FND_API.G_FALSE,
26: p_copy_lead_competitors IN VARCHAR2 :=FND_API.G_FALSE,
27: p_copy_sales_credits IN VARCHAR2 :=FND_API.G_FALSE,
28: p_copy_methodology IN VARCHAR2 :=FND_API.G_FALSE,

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

21: p_lead_id IN NUMBER,
22: p_description IN VARCHAR2,
23: p_copy_salesteam IN VARCHAR2 :=FND_API.G_FALSE,
24: p_copy_opp_lines IN VARCHAR2 :=FND_API.G_FALSE,
25: p_copy_lead_contacts IN VARCHAR2 :=FND_API.G_FALSE,
26: p_copy_lead_competitors IN VARCHAR2 :=FND_API.G_FALSE,
27: p_copy_sales_credits IN VARCHAR2 :=FND_API.G_FALSE,
28: p_copy_methodology IN VARCHAR2 :=FND_API.G_FALSE,
29: p_new_customer_id IN NUMBER,

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

22: p_description IN VARCHAR2,
23: p_copy_salesteam IN VARCHAR2 :=FND_API.G_FALSE,
24: p_copy_opp_lines IN VARCHAR2 :=FND_API.G_FALSE,
25: p_copy_lead_contacts IN VARCHAR2 :=FND_API.G_FALSE,
26: p_copy_lead_competitors IN VARCHAR2 :=FND_API.G_FALSE,
27: p_copy_sales_credits IN VARCHAR2 :=FND_API.G_FALSE,
28: p_copy_methodology IN VARCHAR2 :=FND_API.G_FALSE,
29: p_new_customer_id IN NUMBER,
30: p_new_address_id IN NUMBER,

Line 27: p_copy_sales_credits IN VARCHAR2 :=FND_API.G_FALSE,

23: p_copy_salesteam IN VARCHAR2 :=FND_API.G_FALSE,
24: p_copy_opp_lines IN VARCHAR2 :=FND_API.G_FALSE,
25: p_copy_lead_contacts IN VARCHAR2 :=FND_API.G_FALSE,
26: p_copy_lead_competitors IN VARCHAR2 :=FND_API.G_FALSE,
27: p_copy_sales_credits IN VARCHAR2 :=FND_API.G_FALSE,
28: p_copy_methodology IN VARCHAR2 :=FND_API.G_FALSE,
29: p_new_customer_id IN NUMBER,
30: p_new_address_id IN NUMBER,
31: p_check_access_flag IN VARCHAR2,

Line 28: p_copy_methodology IN VARCHAR2 :=FND_API.G_FALSE,

24: p_copy_opp_lines IN VARCHAR2 :=FND_API.G_FALSE,
25: p_copy_lead_contacts IN VARCHAR2 :=FND_API.G_FALSE,
26: p_copy_lead_competitors IN VARCHAR2 :=FND_API.G_FALSE,
27: p_copy_sales_credits IN VARCHAR2 :=FND_API.G_FALSE,
28: p_copy_methodology IN VARCHAR2 :=FND_API.G_FALSE,
29: p_new_customer_id IN NUMBER,
30: p_new_address_id IN NUMBER,
31: p_check_access_flag IN VARCHAR2,
32: p_admin_flag IN VARCHAR2,

Line 177: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

173: -- Standard Start of API savepoint
174: SAVEPOINT COPY_OPPORTUNITY_PVT;
175:
176: -- Standard call to check for call compatibility.
177: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
178: p_api_version_number,
179: l_api_name,
180: G_PKG_NAME)
181: THEN

Line 182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

178: p_api_version_number,
179: l_api_name,
180: G_PKG_NAME)
181: THEN
182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
183: END IF;
184:
185:
186: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 187: IF FND_API.to_Boolean( p_init_msg_list )

183: END IF;
184:
185:
186: -- Initialize message list if p_init_msg_list is set to TRUE.
187: IF FND_API.to_Boolean( p_init_msg_list )
188: THEN
189: FND_MSG_PUB.initialize;
190: END IF;
191:

Line 201: x_return_status := FND_API.G_RET_STS_SUCCESS;

197: END IF;
198:
199:
200: -- Initialize API return status to SUCCESS
201: x_return_status := FND_API.G_RET_STS_SUCCESS;
202:
203: --
204: -- API body
205: --

Line 206: IF (p_validation_level = fnd_api.g_valid_level_full) THEN --fix for bug#3756261

202:
203: --
204: -- API body
205: --
206: IF (p_validation_level = fnd_api.g_valid_level_full) THEN --fix for bug#3756261
207: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
208: p_api_version_number => 2.0
209: ,p_init_msg_list => p_init_msg_list
210: ,p_salesforce_id => p_identity_salesforce_id

Line 217: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

213: ,x_msg_count => x_msg_count
214: ,x_msg_data => x_msg_data
215: ,x_sales_member_rec => l_identity_sales_member_rec);
216:
217: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
218: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
219: IF l_debug THEN
220: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
221: 'Private API: Get_CurrentUser fail');

Line 224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

220: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
221: 'Private API: Get_CurrentUser fail');
222: END IF;
223: END IF;
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;
226: END IF;
227:
228: IF(P_Check_Access_Flag = 'Y') THEN

Line 255: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

251: ,x_msg_count => x_msg_count
252: ,x_msg_data => x_msg_data
253: ,x_view_access_flag => l_view_access_flag );
254:
255: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
256: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
257: IF l_debug THEN
258: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
259: 'has_viewCustomerAccess fail');

Line 263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

259: 'has_viewCustomerAccess fail');
260: END IF;
261:
262: END IF;
263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
264: END IF;
265:
266: IF (l_view_access_flag <> 'Y') THEN
267: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 272: RAISE FND_API.G_EXC_ERROR;

268: FND_MESSAGE.Set_Name('AS', 'API_NO_VIEW_PRIVILEGE');
269: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
270: FND_MSG_PUB.ADD;
271: END IF;
272: RAISE FND_API.G_EXC_ERROR;
273: END IF;
274: END IF;
275:
276: --

Line 280: IF p_lead_id is null or p_lead_id = fnd_api.g_miss_num

276: --
277: -- Copy the opportunity header
278: --
279:
280: IF p_lead_id is null or p_lead_id = fnd_api.g_miss_num
281: THEN
282: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
283: IF l_debug THEN
284: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

285: 'Private API: p_lead_id is null');
286: END IF;
287:
288: END IF;
289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
290: END IF;
291:
292: FOR hdr IN c_header(p_lead_id) LOOP
293:

Line 407: P_Init_Msg_List => FND_API.G_FALSE,

403: -- Calling Private package: Create_OPP_HEADER
404: -- Hint: Primary key needs to be returned
405: AS_OPPORTUNITY_PUB.Create_opp_header(
406: P_Api_Version_Number => 2.0,
407: P_Init_Msg_List => FND_API.G_FALSE,
408: P_Commit => FND_API.G_FALSE,
409: P_Validation_Level => P_Validation_Level,
410: P_Check_Access_Flag => 'N',
411: P_Admin_Flag => P_Admin_Flag ,

Line 408: P_Commit => FND_API.G_FALSE,

404: -- Hint: Primary key needs to be returned
405: AS_OPPORTUNITY_PUB.Create_opp_header(
406: P_Api_Version_Number => 2.0,
407: P_Init_Msg_List => FND_API.G_FALSE,
408: P_Commit => FND_API.G_FALSE,
409: P_Validation_Level => P_Validation_Level,
410: P_Check_Access_Flag => 'N',
411: P_Admin_Flag => P_Admin_Flag ,
412: P_Admin_Group_Id => P_Admin_Group_Id,

Line 424: IF x_return_status = FND_API.G_RET_STS_ERROR then

420: X_Msg_Count => x_msg_count,
421: X_Msg_Data => x_msg_data);
422:
423: -- Check return status from the above procedure call
424: IF x_return_status = FND_API.G_RET_STS_ERROR then
425: raise FND_API.G_EXC_ERROR;
426: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
427: raise FND_API.G_EXC_UNEXPECTED_ERROR;
428: END IF;

Line 425: raise FND_API.G_EXC_ERROR;

421: X_Msg_Data => x_msg_data);
422:
423: -- Check return status from the above procedure call
424: IF x_return_status = FND_API.G_RET_STS_ERROR then
425: raise FND_API.G_EXC_ERROR;
426: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
427: raise FND_API.G_EXC_UNEXPECTED_ERROR;
428: END IF;
429:

Line 426: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

422:
423: -- Check return status from the above procedure call
424: IF x_return_status = FND_API.G_RET_STS_ERROR then
425: raise FND_API.G_EXC_ERROR;
426: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
427: raise FND_API.G_EXC_UNEXPECTED_ERROR;
428: END IF;
429:
430: IF l_debug THEN

Line 427: raise FND_API.G_EXC_UNEXPECTED_ERROR;

423: -- Check return status from the above procedure call
424: IF x_return_status = FND_API.G_RET_STS_ERROR then
425: raise FND_API.G_EXC_ERROR;
426: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
427: raise FND_API.G_EXC_UNEXPECTED_ERROR;
428: END IF;
429:
430: IF l_debug THEN
431: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 431: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

427: raise FND_API.G_EXC_UNEXPECTED_ERROR;
428: END IF;
429:
430: IF l_debug THEN
431: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
432:
433: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
434: 'Private API: Create_opp_header fail');
435: ELSE

Line 533: ,p_init_msg_list => FND_API.G_FALSE

529: END IF;
530:
531: AS_ACCESS_PUB.Create_SalesTeam (
532: p_api_version_number => 2.0
533: ,p_init_msg_list => FND_API.G_FALSE
534: ,p_commit => FND_API.G_FALSE
535: ,p_validation_level => p_Validation_Level
536: ,p_access_profile_rec => l_access_profile_rec
537: ,p_check_access_flag => 'N' -- P_Check_Access_flag

Line 534: ,p_commit => FND_API.G_FALSE

530:
531: AS_ACCESS_PUB.Create_SalesTeam (
532: p_api_version_number => 2.0
533: ,p_init_msg_list => FND_API.G_FALSE
534: ,p_commit => FND_API.G_FALSE
535: ,p_validation_level => p_Validation_Level
536: ,p_access_profile_rec => l_access_profile_rec
537: ,p_check_access_flag => 'N' -- P_Check_Access_flag
538: ,p_admin_flag => P_Admin_Flag

Line 555: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

551: 'Create_SalesTeam:l_access_id > ' || l_access_id);
552:
553: END IF;
554:
555: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
556: RAISE FND_API.G_EXC_ERROR;
557: END IF;
558: -- Begin Added for ASNB
559: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y' AND

Line 556: RAISE FND_API.G_EXC_ERROR;

552:
553: END IF;
554:
555: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
556: RAISE FND_API.G_EXC_ERROR;
557: END IF;
558: -- Begin Added for ASNB
559: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y' AND
560: P_Identity_Salesforce_Id = l_Sales_Team_Rec.salesforce_id AND

Line 571: ,p_init_msg_list => FND_API.G_FALSE

567: l_Sales_Team_Rec.access_id := l_val;
568: l_Sales_Team_Rec.Freeze_Flag := 'Y';
569: AS_ACCESS_PUB.Update_SalesTeam (
570: p_api_version_number => 2.0
571: ,p_init_msg_list => FND_API.G_FALSE
572: ,p_commit => FND_API.G_FALSE
573: ,p_validation_level => p_Validation_Level
574: ,p_access_profile_rec => l_access_profile_rec
575: ,p_check_access_flag => 'N' -- P_Check_Access_flag

Line 572: ,p_commit => FND_API.G_FALSE

568: l_Sales_Team_Rec.Freeze_Flag := 'Y';
569: AS_ACCESS_PUB.Update_SalesTeam (
570: p_api_version_number => 2.0
571: ,p_init_msg_list => FND_API.G_FALSE
572: ,p_commit => FND_API.G_FALSE
573: ,p_validation_level => p_Validation_Level
574: ,p_access_profile_rec => l_access_profile_rec
575: ,p_check_access_flag => 'N' -- P_Check_Access_flag
576: ,p_admin_flag => P_Admin_Flag

Line 599: ,p_init_msg_list => FND_API.G_FALSE

595: --dbms_output.put_line('access_id ' || l_Sales_Team_Rec.access_id);
596: --dbms_output.put_line('date from db ' || to_char(l_date,'MM:DD:YYYY HH24:MI:SS'));
597: AS_ACCESS_PUB.Update_SalesTeam (
598: p_api_version_number => 2.0
599: ,p_init_msg_list => FND_API.G_FALSE
600: ,p_commit => FND_API.G_FALSE
601: ,p_validation_level => p_Validation_Level
602: ,p_access_profile_rec => l_access_profile_rec
603: ,p_check_access_flag => 'N' -- P_Check_Access_flag

Line 600: ,p_commit => FND_API.G_FALSE

596: --dbms_output.put_line('date from db ' || to_char(l_date,'MM:DD:YYYY HH24:MI:SS'));
597: AS_ACCESS_PUB.Update_SalesTeam (
598: p_api_version_number => 2.0
599: ,p_init_msg_list => FND_API.G_FALSE
600: ,p_commit => FND_API.G_FALSE
601: ,p_validation_level => p_Validation_Level
602: ,p_access_profile_rec => l_access_profile_rec
603: ,p_check_access_flag => 'N' -- P_Check_Access_flag
604: ,p_admin_flag => P_Admin_Flag

Line 620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

616: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
617: 'Update_SalesTeam: Done');
618: END IF;
619:
620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
621: RAISE FND_API.G_EXC_ERROR;
622: END IF;
623: END IF;
624: END LOOP;

Line 621: RAISE FND_API.G_EXC_ERROR;

617: 'Update_SalesTeam: Done');
618: END IF;
619:
620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
621: RAISE FND_API.G_EXC_ERROR;
622: END IF;
623: END IF;
624: END LOOP;
625: END IF;

Line 698: RAISE FND_API.G_EXC_ERROR;

694: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
695: 'Private API: as_lead_lines_pkg.insert_row fail');
696: END IF;
697:
698: RAISE FND_API.G_EXC_ERROR;
699: ELSE
700: IF l_debug THEN
701: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
702: 'Private API: as_lead_lines_pkg.insert_row '|| l_lead_line_id);

Line 768: RAISE FND_API.G_EXC_ERROR;

764: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
765: 'Private API: as_sales_credits_pkg.insert_row fail');
766: END IF;
767:
768: RAISE FND_API.G_EXC_ERROR;
769: ELSE
770: IF l_debug THEN
771: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
772: 'Private API: as_sales_credits_pkg.insert_row '|| l_sales_credit_id);

Line 788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

784: 'The profile AS_FORECAST_CREDIT_TYPE_ID is null');
785: END IF;
786:
787: END IF;
788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
789: END IF;
790:
791: l_sales_credit_rec.last_update_date := SYSDATE;
792: l_sales_credit_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line 803: (l_identity_sales_member_rec.partner_customer_id <>FND_API.G_MISS_NUM)

799: l_sales_credit_rec.person_id := l_identity_sales_member_rec.employee_person_id;
800: l_sales_credit_rec.salesgroup_id := p_salesgroup_id;
801:
802: IF (l_identity_sales_member_rec.partner_customer_id is NOT NULL) and
803: (l_identity_sales_member_rec.partner_customer_id <>FND_API.G_MISS_NUM)
804: THEN
805: l_sales_credit_rec.partner_customer_id := l_identity_sales_member_rec.partner_customer_id;
806: l_sales_credit_rec.partner_address_id := l_identity_sales_member_rec.partner_address_id;
807: ELSE

Line 819: P_Init_Msg_List => FND_API.G_FALSE,

815: l_sales_credit_tbl(1) := l_sales_credit_rec;
816:
817: AS_OPP_sales_credit_PVT.Create_sales_credits(
818: P_Api_Version_Number => 2.0,
819: P_Init_Msg_List => FND_API.G_FALSE,
820: P_Commit => FND_API.G_FALSE,
821: P_Validation_Level => P_Validation_Level,
822: P_Check_Access_Flag => FND_API.G_FALSE,
823: P_Admin_Flag => FND_API.G_FALSE,

Line 820: P_Commit => FND_API.G_FALSE,

816:
817: AS_OPP_sales_credit_PVT.Create_sales_credits(
818: P_Api_Version_Number => 2.0,
819: P_Init_Msg_List => FND_API.G_FALSE,
820: P_Commit => FND_API.G_FALSE,
821: P_Validation_Level => P_Validation_Level,
822: P_Check_Access_Flag => FND_API.G_FALSE,
823: P_Admin_Flag => FND_API.G_FALSE,
824: P_Admin_Group_Id => P_Admin_Group_Id,

Line 822: P_Check_Access_Flag => FND_API.G_FALSE,

818: P_Api_Version_Number => 2.0,
819: P_Init_Msg_List => FND_API.G_FALSE,
820: P_Commit => FND_API.G_FALSE,
821: P_Validation_Level => P_Validation_Level,
822: P_Check_Access_Flag => FND_API.G_FALSE,
823: P_Admin_Flag => FND_API.G_FALSE,
824: P_Admin_Group_Id => P_Admin_Group_Id,
825: P_Identity_Salesforce_Id => P_Identity_Salesforce_Id,
826: P_Partner_Cont_Party_Id => p_partner_cont_party_id,

Line 823: P_Admin_Flag => FND_API.G_FALSE,

819: P_Init_Msg_List => FND_API.G_FALSE,
820: P_Commit => FND_API.G_FALSE,
821: P_Validation_Level => P_Validation_Level,
822: P_Check_Access_Flag => FND_API.G_FALSE,
823: P_Admin_Flag => FND_API.G_FALSE,
824: P_Admin_Group_Id => P_Admin_Group_Id,
825: P_Identity_Salesforce_Id => P_Identity_Salesforce_Id,
826: P_Partner_Cont_Party_Id => p_partner_cont_party_id,
827: P_Profile_Tbl => P_Profile_tbl,

Line 835: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

831: X_Msg_Count => x_msg_count,
832: X_Msg_Data => x_msg_data);
833:
834: -- Check return status from the above procedure call
835: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
836: THEN
837: IF l_debug THEN
838: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
839: 'Copy Line: Create_Sales_credit fail' );

Line 842: raise FND_API.G_EXC_ERROR;

838: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
839: 'Copy Line: Create_Sales_credit fail' );
840: END IF;
841:
842: raise FND_API.G_EXC_ERROR;
843: END IF;
844:
845: SELECT sum(OPP_FORECAST_AMOUNT) INTO l_TOT_REVENUE_OPP_FORECAST_AMT
846: FROM AS_SALES_CREDITS

Line 903: RAISE FND_API.G_EXC_ERROR;

899: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
900: 'Private API: as_lead_comp_products_pkg.insert_row fail');
901: END IF;
902:
903: RAISE FND_API.G_EXC_ERROR;
904: ELSE
905: IF l_debug THEN
906: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
907: 'Private API: as_lead_comp_products_pkg.insert_row '|| l_lead_competitor_prod_id);

Line 954: RAISE FND_API.G_EXC_ERROR;

950: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
951: 'Private API: as_lead_decision_factors_pkg.insert_row fail');
952: END IF;
953:
954: RAISE FND_API.G_EXC_ERROR;
955: ELSE
956: IF l_debug THEN
957: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
958: 'Private API: as_lead_decision_factors_pkg.insert_row '|| l_lead_decision_factor_id );

Line 1019: RAISE FND_API.G_EXC_ERROR;

1015: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1016: 'Private API: as_lead_lines_pkg.insert_row fail');
1017: END IF;
1018:
1019: RAISE FND_API.G_EXC_ERROR;
1020: ELSE
1021: IF l_debug THEN
1022: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1023: 'Private API: as_lead_contacts_pkg.insert_row '|| l_lead_contact_id);

Line 1080: RAISE FND_API.G_EXC_ERROR;

1076: IF l_debug THEN
1077: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1078: 'Private API: as_lead_competitors_pkg.insert_row fail');
1079: END IF;
1080: RAISE FND_API.G_EXC_ERROR;
1081: ELSE
1082: IF l_debug THEN
1083: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1084: 'Private API: as_lead_competitors_pkg.insert_row '|| l_lead_competitor_id);

Line 1095: P_Init_Msg_List => FND_API.G_FALSE,

1091:
1092: -- Run TAP to reassign salesteam
1093: AS_RTTAP_OPPTY.RTTAP_WRAPPER(
1094: P_Api_Version_Number => 1.0,
1095: P_Init_Msg_List => FND_API.G_FALSE,
1096: P_Commit => FND_API.G_FALSE,
1097: p_lead_id => x_LEAD_ID,
1098: X_Return_Status => x_return_status,
1099: X_Msg_Count => x_msg_count,

Line 1096: P_Commit => FND_API.G_FALSE,

1092: -- Run TAP to reassign salesteam
1093: AS_RTTAP_OPPTY.RTTAP_WRAPPER(
1094: P_Api_Version_Number => 1.0,
1095: P_Init_Msg_List => FND_API.G_FALSE,
1096: P_Commit => FND_API.G_FALSE,
1097: p_lead_id => x_LEAD_ID,
1098: X_Return_Status => x_return_status,
1099: X_Msg_Count => x_msg_count,
1100: X_Msg_Data => x_msg_data

Line 1104: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1100: X_Msg_Data => x_msg_data
1101: );
1102:
1103: -- Check return status from the above procedure call
1104: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1105: THEN
1106: IF l_debug THEN
1107: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1108: 'Territory Assignment Call Failed' );

Line 1110: raise FND_API.G_EXC_ERROR;

1106: IF l_debug THEN
1107: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1108: 'Territory Assignment Call Failed' );
1109: END IF;
1110: raise FND_API.G_EXC_ERROR;
1111: END IF;
1112:
1113: EXCEPTION
1114: WHEN FND_API.G_EXC_ERROR THEN

Line 1114: WHEN FND_API.G_EXC_ERROR THEN

1110: raise FND_API.G_EXC_ERROR;
1111: END IF;
1112:
1113: EXCEPTION
1114: WHEN FND_API.G_EXC_ERROR THEN
1115: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1116: P_MODULE => l_module
1117: ,P_API_NAME => L_API_NAME
1118: ,P_PKG_NAME => G_PKG_NAME

Line 1125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1121: ,X_MSG_COUNT => X_MSG_COUNT
1122: ,X_MSG_DATA => X_MSG_DATA
1123: ,X_RETURN_STATUS => X_RETURN_STATUS);
1124:
1125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1126: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1127: P_MODULE => l_module
1128: ,P_API_NAME => L_API_NAME
1129: ,P_PKG_NAME => G_PKG_NAME