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

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

25: -- API Name: Get_Potential_Opportunity
26:
27: PROCEDURE Get_Potential_Opportunity(
28: P_Api_Version_Number IN NUMBER,
29: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
30: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
31: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

26:
27: PROCEDURE Get_Potential_Opportunity(
28: P_Api_Version_Number IN NUMBER,
29: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
30: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
31: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 31: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

27: PROCEDURE Get_Potential_Opportunity(
28: P_Api_Version_Number IN NUMBER,
29: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
30: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
31: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
35: P_identity_salesforce_id IN NUMBER := NULL,

Line 32: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

28: P_Api_Version_Number IN NUMBER,
29: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
30: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
31: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
35: P_identity_salesforce_id IN NUMBER := NULL,
36: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

Line 33: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

29: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
30: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
31: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
35: P_identity_salesforce_id IN NUMBER := NULL,
36: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
37: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 34: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

30: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
31: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
35: P_identity_salesforce_id IN NUMBER := NULL,
36: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
37: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
38: P_SALES_LEAD_rec IN AS_SALES_LEADS_PUB.SALES_LEAD_rec_type,

Line 269: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

265: -- Standard Start of API savepoint
266: SAVEPOINT GET_POTENTIAL_OPPORTUNITY_PVT;
267:
268: -- Standard call to check for call compatibility.
269: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
270: p_api_version_number,
271: l_api_name,
272: G_PKG_NAME)
273: THEN

Line 274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

270: p_api_version_number,
271: l_api_name,
272: G_PKG_NAME)
273: THEN
274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
275: END IF;
276: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
277: -- Initialize message list IF p_init_msg_list is set to TRUE.
278: IF FND_API.to_Boolean( p_init_msg_list )

Line 278: IF FND_API.to_Boolean( p_init_msg_list )

274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
275: END IF;
276: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
277: -- Initialize message list IF p_init_msg_list is set to TRUE.
278: IF FND_API.to_Boolean( p_init_msg_list )
279: THEN
280: FND_MSG_PUB.initialize;
281: END IF;
282:

Line 290: x_return_status := FND_API.G_RET_STS_SUCCESS;

286: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PVT:' || l_api_name || 'start');
287: END IF;
288:
289: -- Initialize API return status to SUCCESS
290: x_return_status := FND_API.G_RET_STS_SUCCESS;
291:
292: --
293: -- Api body
294: --

Line 310: RAISE FND_API.G_EXC_ERROR;

306: p_token1 => 'PROFILE',
307: p_token1_value => 'USER_ID');
308: END IF;
309:
310: RAISE FND_API.G_EXC_ERROR;
311: END IF;
312:
313: IF (p_validation_level = fnd_api.g_valid_level_full)
314: THEN

Line 313: IF (p_validation_level = fnd_api.g_valid_level_full)

309:
310: RAISE FND_API.G_EXC_ERROR;
311: END IF;
312:
313: IF (p_validation_level = fnd_api.g_valid_level_full)
314: THEN
315: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
316: p_api_version_number => 2.0
317: ,p_init_msg_list => p_init_msg_list

Line 326: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

322: ,x_msg_data => x_msg_data
323: ,x_sales_member_rec => l_identity_sales_member_rec);
324: END IF;
325:
326: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
327: RAISE FND_API.G_EXC_ERROR;
328: END IF;
329:
330: For C_Get_Opp_Rec IN C_Get_Opportunity (P_SALES_LEAD_rec.Customer_Id)

Line 327: RAISE FND_API.G_EXC_ERROR;

323: ,x_sales_member_rec => l_identity_sales_member_rec);
324: END IF;
325:
326: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
327: RAISE FND_API.G_EXC_ERROR;
328: END IF;
329:
330: For C_Get_Opp_Rec IN C_Get_Opportunity (P_SALES_LEAD_rec.Customer_Id)
331: Loop

Line 404: -- l_header_rec.member_access := FND_API.G_MISS_CHAR;

400: l_header_rec.attribute14 := C_Get_Opp_Rec.attribute14;
401: l_header_rec.attribute15 := C_Get_Opp_Rec.attribute15;
402: l_header_rec.parent_project := C_Get_Opp_Rec.parent_project;
403: l_header_rec.updateable_flag := 'N';
404: -- l_header_rec.member_access := FND_API.G_MISS_CHAR;
405: -- l_header_rec.member_role := FND_API.G_MISS_CHAR;
406:
407: X_Opportunity_tbl(l_cnt) := l_header_rec;
408:

Line 405: -- l_header_rec.member_role := FND_API.G_MISS_CHAR;

401: l_header_rec.attribute15 := C_Get_Opp_Rec.attribute15;
402: l_header_rec.parent_project := C_Get_Opp_Rec.parent_project;
403: l_header_rec.updateable_flag := 'N';
404: -- l_header_rec.member_access := FND_API.G_MISS_CHAR;
405: -- l_header_rec.member_role := FND_API.G_MISS_CHAR;
406:
407: X_Opportunity_tbl(l_cnt) := l_header_rec;
408:
409:

Line 492: IF FND_API.to_Boolean( p_commit )

488: -- END of API body
489: --
490:
491: -- Standard check for p_commit
492: IF FND_API.to_Boolean( p_commit )
493: THEN
494: COMMIT WORK;
495: END IF;
496:

Line 509: WHEN FND_API.G_EXC_ERROR THEN

505: ( p_count => x_msg_count,
506: p_data => x_msg_data );
507:
508: EXCEPTION
509: WHEN FND_API.G_EXC_ERROR THEN
510: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
511: P_MODULE => l_module
512: ,P_API_NAME => L_API_NAME
513: ,P_PKG_NAME => G_PKG_NAME

Line 520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

516: ,X_MSG_COUNT => X_MSG_COUNT
517: ,X_MSG_DATA => X_MSG_DATA
518: ,X_RETURN_STATUS => X_RETURN_STATUS);
519:
520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
521: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
522: P_MODULE => l_module
523: ,P_API_NAME => L_API_NAME
524: ,P_PKG_NAME => G_PKG_NAME

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

547: /* API renamed by Francis on 06/26/2001 from Link_Lead_To_Opportunity to Copy_Lead_To_Opportunity */
548:
549: PROCEDURE Copy_Lead_To_Opportunity(
550: P_Api_Version_Number IN NUMBER,
551: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
552: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
553: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
554: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
555: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

548:
549: PROCEDURE Copy_Lead_To_Opportunity(
550: P_Api_Version_Number IN NUMBER,
551: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
552: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
553: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
554: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
555: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
556: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

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

549: PROCEDURE Copy_Lead_To_Opportunity(
550: P_Api_Version_Number IN NUMBER,
551: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
552: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
553: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
554: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
555: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
556: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
557: P_identity_salesforce_id IN NUMBER, --:= NULL,

Line 554: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

550: P_Api_Version_Number IN NUMBER,
551: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
552: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
553: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
554: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
555: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
556: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
557: P_identity_salesforce_id IN NUMBER, --:= NULL,
558: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

Line 555: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

551: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
552: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
553: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
554: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
555: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
556: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
557: P_identity_salesforce_id IN NUMBER, --:= NULL,
558: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
559: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

Line 556: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

552: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
553: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
554: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
555: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
556: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
557: P_identity_salesforce_id IN NUMBER, --:= NULL,
558: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
559: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
560: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 558: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

554: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
555: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
556: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
557: P_identity_salesforce_id IN NUMBER, --:= NULL,
558: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
559: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
560: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
561: P_SALES_LEAD_ID IN NUMBER,
562: P_SALES_LEAD_LINE_TBL IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_TBL_TYPE

Line 713: -- ,FND_API.G_MISS_NUM -- ,security_group_id

709: ,attribute13
710: ,attribute14
711: ,attribute15
712: ,parent_project
713: -- ,FND_API.G_MISS_NUM -- ,security_group_id
714: From AS_LEADS_ALL
715: Where lead_id = X_Opportunity_Id;
716:
717: CURSOR C_Get_Sales_lead_lines (X_Sales_Lead_Id NUMBER) IS

Line 818: l_last_update_date DATE := FND_API.G_MISS_DATE;

814: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
815: l_val VARCHAR2(1) default null;
816: --axavier l_val_id NUMBER;
817: l_lead_line_id NUMBER;
818: l_last_update_date DATE := FND_API.G_MISS_DATE;
819: l_channel_code VARCHAR2(30);
820: l_Lead_Opportunity_Id NUMBER;
821: l_Lead_Opp_Line_Id NUMBER;
822: l_sales_lead_line_id NUMBER default null;

Line 823: -- l_line_security_group_id NUMBER := FND_API.G_MISS_NUM;

819: l_channel_code VARCHAR2(30);
820: l_Lead_Opportunity_Id NUMBER;
821: l_Lead_Opp_Line_Id NUMBER;
822: l_sales_lead_line_id NUMBER default null;
823: -- l_line_security_group_id NUMBER := FND_API.G_MISS_NUM;
824: -- l_opp_security_group_id NUMBER := FND_API.G_MISS_NUM;
825: l_update_access_flag VARCHAR2(1);
826: l_member_role VARCHAR2(5);
827: l_member_access VARCHAR2(5);

Line 824: -- l_opp_security_group_id NUMBER := FND_API.G_MISS_NUM;

820: l_Lead_Opportunity_Id NUMBER;
821: l_Lead_Opp_Line_Id NUMBER;
822: l_sales_lead_line_id NUMBER default null;
823: -- l_line_security_group_id NUMBER := FND_API.G_MISS_NUM;
824: -- l_opp_security_group_id NUMBER := FND_API.G_MISS_NUM;
825: l_update_access_flag VARCHAR2(1);
826: l_member_role VARCHAR2(5);
827: l_member_access VARCHAR2(5);
828: l_cnt NUMBER := 0;

Line 837: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

833: -- Standard Start of API savepoint
834: SAVEPOINT COPY_LEAD_TO_OPPORTUNITY_PVT;
835:
836: -- Standard call to check for call compatibility.
837: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
838: p_api_version_number,
839: l_api_name,
840: G_PKG_NAME)
841: THEN

Line 842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

838: p_api_version_number,
839: l_api_name,
840: G_PKG_NAME)
841: THEN
842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
843: END IF;
844: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
845:
846: -- Initialize message list IF p_init_msg_list is set to TRUE.

Line 847: IF FND_API.to_Boolean( p_init_msg_list )

843: END IF;
844: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
845:
846: -- Initialize message list IF p_init_msg_list is set to TRUE.
847: IF FND_API.to_Boolean( p_init_msg_list )
848: THEN
849: FND_MSG_PUB.initialize;
850: END IF;
851:

Line 858: x_return_status := FND_API.G_RET_STS_SUCCESS;

854: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PVT:' || l_api_name || ' Start');
855: END IF;
856:
857: -- Initialize API return status to SUCCESS
858: x_return_status := FND_API.G_RET_STS_SUCCESS;
859:
860: --
861: -- Api body
862: --

Line 878: RAISE FND_API.G_EXC_ERROR;

874: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
875: p_token1 => 'PROFILE',
876: p_token1_value => 'USER_ID');
877: END IF;
878: RAISE FND_API.G_EXC_ERROR;
879: END IF;
880:
881: IF (p_validation_level = fnd_api.g_valid_level_full)
882: THEN

Line 881: IF (p_validation_level = fnd_api.g_valid_level_full)

877: END IF;
878: RAISE FND_API.G_EXC_ERROR;
879: END IF;
880:
881: IF (p_validation_level = fnd_api.g_valid_level_full)
882: THEN
883: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
884: p_api_version_number => 2.0
885: ,p_init_msg_list => p_init_msg_list

Line 894: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

890: ,x_msg_data => x_msg_data
891: ,x_sales_member_rec => l_identity_sales_member_rec);
892: END IF;
893:
894: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
895: RAISE FND_API.G_EXC_ERROR;
896: END IF;
897:
898: -- Get sales lead header based on parameter P_Sales_Lead_Id

Line 895: RAISE FND_API.G_EXC_ERROR;

891: ,x_sales_member_rec => l_identity_sales_member_rec);
892: END IF;
893:
894: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
895: RAISE FND_API.G_EXC_ERROR;
896: END IF;
897:
898: -- Get sales lead header based on parameter P_Sales_Lead_Id
899: OPEN C_Get_Sales_Lead (P_Sales_Lead_Id);

Line 977: x_return_status := FND_API.G_RET_STS_ERROR;

973: p_token1_value => 'SALES_LEAD_ID',
974: p_token2 => 'VALUE',
975: p_token2_value => P_Sales_Lead_Id );
976:
977: x_return_status := FND_API.G_RET_STS_ERROR;
978:
979: END IF;
980:
981: CLOSE C_Get_Sales_Lead;

Line 983: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

979: END IF;
980:
981: CLOSE C_Get_Sales_Lead;
982:
983: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
984: RAISE FND_API.G_EXC_ERROR;
985: END IF;
986:
987:

Line 984: RAISE FND_API.G_EXC_ERROR;

980:
981: CLOSE C_Get_Sales_Lead;
982:
983: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
984: RAISE FND_API.G_EXC_ERROR;
985: END IF;
986:
987:
988:

Line 1050: --commented for bug 2013040 raise FND_API.G_EXC_ERROR;

1046: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
1047: FND_MESSAGE.Set_Token ('INFO', 'Opportunity', FALSE);
1048: FND_MSG_PUB.Add;
1049: END IF;
1050: --commented for bug 2013040 raise FND_API.G_EXC_ERROR;
1051: x_return_status := FND_API.G_RET_STS_ERROR;
1052:
1053: END IF;
1054: -- Debug Message

Line 1051: x_return_status := FND_API.G_RET_STS_ERROR;

1047: FND_MESSAGE.Set_Token ('INFO', 'Opportunity', FALSE);
1048: FND_MSG_PUB.Add;
1049: END IF;
1050: --commented for bug 2013040 raise FND_API.G_EXC_ERROR;
1051: x_return_status := FND_API.G_RET_STS_ERROR;
1052:
1053: END IF;
1054: -- Debug Message
1055: IF l_debug THEN

Line 1060: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1056: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Close Cursor C_Get_Opportunity');
1057: END IF;
1058: Close C_Get_Opportunity;
1059:
1060: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1061: RAISE FND_API.G_EXC_ERROR;
1062: END IF;
1063:
1064: -- Invoke validation procedures

Line 1061: RAISE FND_API.G_EXC_ERROR;

1057: END IF;
1058: Close C_Get_Opportunity;
1059:
1060: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1061: RAISE FND_API.G_EXC_ERROR;
1062: END IF;
1063:
1064: -- Invoke validation procedures
1065: -- Debug message

Line 1072: P_Init_Msg_List => FND_API.G_FALSE

1068: END IF;
1069:
1070: -- Validate sales lead id whther it is a valid ID.
1071: AS_SALES_LEADS_PVT.Validate_Sales_Lead_Id (
1072: P_Init_Msg_List => FND_API.G_FALSE
1073: ,P_Validation_mode => FND_API.G_MISS_CHAR
1074: ,P_Sales_Lead_Id => P_Sales_Lead_Id
1075: ,X_Return_Status => X_Return_Status
1076: ,X_Msg_Count => X_Msg_Count

Line 1073: ,P_Validation_mode => FND_API.G_MISS_CHAR

1069:
1070: -- Validate sales lead id whther it is a valid ID.
1071: AS_SALES_LEADS_PVT.Validate_Sales_Lead_Id (
1072: P_Init_Msg_List => FND_API.G_FALSE
1073: ,P_Validation_mode => FND_API.G_MISS_CHAR
1074: ,P_Sales_Lead_Id => P_Sales_Lead_Id
1075: ,X_Return_Status => X_Return_Status
1076: ,X_Msg_Count => X_Msg_Count
1077: ,X_Msg_Data => X_Msg_Data

Line 1080: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1076: ,X_Msg_Count => X_Msg_Count
1077: ,X_Msg_Data => X_Msg_Data
1078: );
1079:
1080: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1081: raise FND_API.G_EXC_ERROR;
1082: END IF;
1083:
1084: -- Validate one sales lead can only be link to one opportunity

Line 1081: raise FND_API.G_EXC_ERROR;

1077: ,X_Msg_Data => X_Msg_Data
1078: );
1079:
1080: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1081: raise FND_API.G_EXC_ERROR;
1082: END IF;
1083:
1084: -- Validate one sales lead can only be link to one opportunity
1085: -- Debug message

Line 1107: x_return_status := FND_API.G_RET_STS_ERROR;

1103: FND_MESSAGE.Set_Token('SLD_ID', p_sales_lead_id, FALSE);
1104: -- end ffang 100900
1105: FND_MSG_PUB.ADD;
1106: -- END IF;
1107: x_return_status := FND_API.G_RET_STS_ERROR;
1108: END IF;
1109:
1110: CLOSE C_Lead_Link_Exists;
1111:

Line 1112: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1108: END IF;
1109:
1110: CLOSE C_Lead_Link_Exists;
1111:
1112: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1113: raise FND_API.G_EXC_ERROR;
1114: END IF;
1115: */
1116:

Line 1113: raise FND_API.G_EXC_ERROR;

1109:
1110: CLOSE C_Lead_Link_Exists;
1111:
1112: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1113: raise FND_API.G_EXC_ERROR;
1114: END IF;
1115: */
1116:
1117: l_Sales_Lead_Rec.Status_Code := nvl(FND_PROFILE.Value('AS_LEAD_LINK_STATUS'),'CONVERTED_TO_OPPORTUNITY');

Line 1151: x_return_status := FND_API.G_RET_STS_ERROR;

1147: -- end ffang 100900
1148: FND_MSG_PUB.ADD;
1149: END IF;
1150:
1151: x_return_status := FND_API.G_RET_STS_ERROR;
1152: END IF;
1153:
1154: CLOSE C_Get_Sales_Owner;
1155:

Line 1163: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1159: END IF;
1160:
1161: CLOSE C_Sales_Owner_Check;
1162:
1163: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1164: raise FND_API.G_EXC_ERROR;
1165: END IF;
1166: */
1167: l_header_rec.updateable_flag := 'N';

Line 1164: raise FND_API.G_EXC_ERROR;

1160:
1161: CLOSE C_Sales_Owner_Check;
1162:
1163: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1164: raise FND_API.G_EXC_ERROR;
1165: END IF;
1166: */
1167: l_header_rec.updateable_flag := 'N';
1168: l_header_rec.member_access := FND_API.G_MISS_CHAR;

Line 1168: l_header_rec.member_access := FND_API.G_MISS_CHAR;

1164: raise FND_API.G_EXC_ERROR;
1165: END IF;
1166: */
1167: l_header_rec.updateable_flag := 'N';
1168: l_header_rec.member_access := FND_API.G_MISS_CHAR;
1169: l_header_rec.member_role := FND_API.G_MISS_CHAR;
1170:
1171: l_cnt := 0;
1172: -- For C_Sales_Lead_lines_Rec In C_Get_Sales_lead_lines(P_Sales_Lead_Id)

Line 1169: l_header_rec.member_role := FND_API.G_MISS_CHAR;

1165: END IF;
1166: */
1167: l_header_rec.updateable_flag := 'N';
1168: l_header_rec.member_access := FND_API.G_MISS_CHAR;
1169: l_header_rec.member_role := FND_API.G_MISS_CHAR;
1170:
1171: l_cnt := 0;
1172: -- For C_Sales_Lead_lines_Rec In C_Get_Sales_lead_lines(P_Sales_Lead_Id)
1173: for i in 1 .. P_SALES_LEAD_LINE_TBL.count

Line 1256: l_line_tbl(l_cnt).member_access := FND_API.G_MISS_CHAR;

1252: l_line_tbl(l_cnt).attribute12 := P_SALES_LEAD_LINE_TBL(i).attribute12;
1253: l_line_tbl(l_cnt).attribute13 := P_SALES_LEAD_LINE_TBL(i).attribute13;
1254: l_line_tbl(l_cnt).attribute14 := P_SALES_LEAD_LINE_TBL(i).attribute14;
1255: l_line_tbl(l_cnt).attribute15 := P_SALES_LEAD_LINE_TBL(i).attribute15;
1256: l_line_tbl(l_cnt).member_access := FND_API.G_MISS_CHAR;
1257: l_line_tbl(l_cnt).member_role := FND_API.G_MISS_CHAR;
1258: l_line_tbl(l_cnt).owner_scredit_percent := FND_API.G_MISS_NUM;
1259: -- l_line_security_group_id
1260: -- := P_SALES_LEAD_LINE_TBL(i).security_group_id;

Line 1257: l_line_tbl(l_cnt).member_role := FND_API.G_MISS_CHAR;

1253: l_line_tbl(l_cnt).attribute13 := P_SALES_LEAD_LINE_TBL(i).attribute13;
1254: l_line_tbl(l_cnt).attribute14 := P_SALES_LEAD_LINE_TBL(i).attribute14;
1255: l_line_tbl(l_cnt).attribute15 := P_SALES_LEAD_LINE_TBL(i).attribute15;
1256: l_line_tbl(l_cnt).member_access := FND_API.G_MISS_CHAR;
1257: l_line_tbl(l_cnt).member_role := FND_API.G_MISS_CHAR;
1258: l_line_tbl(l_cnt).owner_scredit_percent := FND_API.G_MISS_NUM;
1259: -- l_line_security_group_id
1260: -- := P_SALES_LEAD_LINE_TBL(i).security_group_id;
1261: -- 103000 FFANG for bug 1479671

Line 1258: l_line_tbl(l_cnt).owner_scredit_percent := FND_API.G_MISS_NUM;

1254: l_line_tbl(l_cnt).attribute14 := P_SALES_LEAD_LINE_TBL(i).attribute14;
1255: l_line_tbl(l_cnt).attribute15 := P_SALES_LEAD_LINE_TBL(i).attribute15;
1256: l_line_tbl(l_cnt).member_access := FND_API.G_MISS_CHAR;
1257: l_line_tbl(l_cnt).member_role := FND_API.G_MISS_CHAR;
1258: l_line_tbl(l_cnt).owner_scredit_percent := FND_API.G_MISS_NUM;
1259: -- l_line_security_group_id
1260: -- := P_SALES_LEAD_LINE_TBL(i).security_group_id;
1261: -- 103000 FFANG for bug 1479671
1262: l_line_tbl(l_cnt).offer_id := P_SALES_LEAD_LINE_TBL(i).offer_id;

Line 1275: p_init_msg_list => FND_API.G_FALSE,

1271: -- ffang 030503, bug 2826512, call PUB instead of PVT
1272: -- AS_OPP_line_PVT.Create_opp_lines (
1273: AS_OPPORTUNITY_PUB.Create_Opp_Lines (
1274: p_api_version_number => 2.0,
1275: p_init_msg_list => FND_API.G_FALSE,
1276: p_commit => FND_API.G_FALSE, -- ffang020100
1277: -- p_commit => FND_API.G_TRUE,
1278: p_validation_level => p_validation_level,
1279: -- ffang 012501, When adding a opportunity line, enforce security

Line 1276: p_commit => FND_API.G_FALSE, -- ffang020100

1272: -- AS_OPP_line_PVT.Create_opp_lines (
1273: AS_OPPORTUNITY_PUB.Create_Opp_Lines (
1274: p_api_version_number => 2.0,
1275: p_init_msg_list => FND_API.G_FALSE,
1276: p_commit => FND_API.G_FALSE, -- ffang020100
1277: -- p_commit => FND_API.G_TRUE,
1278: p_validation_level => p_validation_level,
1279: -- ffang 012501, When adding a opportunity line, enforce security
1280: -- checking

Line 1277: -- p_commit => FND_API.G_TRUE,

1273: AS_OPPORTUNITY_PUB.Create_Opp_Lines (
1274: p_api_version_number => 2.0,
1275: p_init_msg_list => FND_API.G_FALSE,
1276: p_commit => FND_API.G_FALSE, -- ffang020100
1277: -- p_commit => FND_API.G_TRUE,
1278: p_validation_level => p_validation_level,
1279: -- ffang 012501, When adding a opportunity line, enforce security
1280: -- checking
1281: P_Check_Access_Flag => 'Y', -- P_Check_Access_Flag,

Line 1282: -- P_Check_Access_Flag => FND_API.G_FALSE,

1278: p_validation_level => p_validation_level,
1279: -- ffang 012501, When adding a opportunity line, enforce security
1280: -- checking
1281: P_Check_Access_Flag => 'Y', -- P_Check_Access_Flag,
1282: -- P_Check_Access_Flag => FND_API.G_FALSE,
1283: P_Admin_Flag => P_Admin_Flag, -- FND_API.G_FALSE,
1284: P_Admin_Group_Id => P_Admin_Group_Id, -- NULL,
1285: P_Identity_Salesforce_Id => p_identity_salesforce_id,
1286: -- l_Sales_Lead_Rec.assign_to_salesforce_id,

Line 1283: P_Admin_Flag => P_Admin_Flag, -- FND_API.G_FALSE,

1279: -- ffang 012501, When adding a opportunity line, enforce security
1280: -- checking
1281: P_Check_Access_Flag => 'Y', -- P_Check_Access_Flag,
1282: -- P_Check_Access_Flag => FND_API.G_FALSE,
1283: P_Admin_Flag => P_Admin_Flag, -- FND_API.G_FALSE,
1284: P_Admin_Group_Id => P_Admin_Group_Id, -- NULL,
1285: P_Identity_Salesforce_Id => p_identity_salesforce_id,
1286: -- l_Sales_Lead_Rec.assign_to_salesforce_id,
1287: P_salesgroup_id => P_identity_salesgroup_id,

Line 1297: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1293: x_return_status => x_return_status,
1294: x_msg_count => x_msg_count,
1295: x_msg_data => x_msg_data);
1296:
1297: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1298: raise FND_API.G_EXC_ERROR;
1299: END IF;
1300:
1301: For l_index In 1..l_line_out_tbl.count Loop

Line 1298: raise FND_API.G_EXC_ERROR;

1294: x_msg_count => x_msg_count,
1295: x_msg_data => x_msg_data);
1296:
1297: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1298: raise FND_API.G_EXC_ERROR;
1299: END IF;
1300:
1301: For l_index In 1..l_line_out_tbl.count Loop
1302: -- ffang 101200 for bug 1449308

Line 1341: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1342: raise FND_API.G_EXC_ERROR;

1338: );
1339: END Loop;
1340:
1341: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1342: raise FND_API.G_EXC_ERROR;
1343: END IF;
1344: END IF;
1345:
1346: -- 102700 FFANG for bug 1478517, copy sales lead contacts information to

Line 1418: p_init_msg_list => FND_API.G_FALSE,

1414: -- ffang 030503, bug 2826512, call PUB instead of PVT
1415: -- AS_OPP_CONTACT_PVT.Create_opp_contacts (
1416: AS_OPPORTUNITY_PUB.Create_Contacts (
1417: p_api_version_number => 2.0,
1418: p_init_msg_list => FND_API.G_FALSE,
1419: p_commit => FND_API.G_FALSE,
1420: p_validation_level => p_validation_level,
1421: -- ffang 012501, When adding a opportunity contact, enforce
1422: -- security checking

Line 1419: p_commit => FND_API.G_FALSE,

1415: -- AS_OPP_CONTACT_PVT.Create_opp_contacts (
1416: AS_OPPORTUNITY_PUB.Create_Contacts (
1417: p_api_version_number => 2.0,
1418: p_init_msg_list => FND_API.G_FALSE,
1419: p_commit => FND_API.G_FALSE,
1420: p_validation_level => p_validation_level,
1421: -- ffang 012501, When adding a opportunity contact, enforce
1422: -- security checking
1423: P_Check_Access_Flag => 'Y', -- p_check_access_flag,

Line 1424: -- P_Check_Access_Flag => FND_API.G_FALSE,

1420: p_validation_level => p_validation_level,
1421: -- ffang 012501, When adding a opportunity contact, enforce
1422: -- security checking
1423: P_Check_Access_Flag => 'Y', -- p_check_access_flag,
1424: -- P_Check_Access_Flag => FND_API.G_FALSE,
1425: P_Admin_Flag => p_admin_flag,
1426: -- P_Admin_Flag => FND_API.G_FALSE, -- p_admin_flag,
1427: P_Admin_Group_Id => P_Admin_Group_Id,
1428: P_Identity_Salesforce_Id => p_identity_salesforce_id,

Line 1426: -- P_Admin_Flag => FND_API.G_FALSE, -- p_admin_flag,

1422: -- security checking
1423: P_Check_Access_Flag => 'Y', -- p_check_access_flag,
1424: -- P_Check_Access_Flag => FND_API.G_FALSE,
1425: P_Admin_Flag => p_admin_flag,
1426: -- P_Admin_Flag => FND_API.G_FALSE, -- p_admin_flag,
1427: P_Admin_Group_Id => P_Admin_Group_Id,
1428: P_Identity_Salesforce_Id => p_identity_salesforce_id,
1429: P_profile_tbl => AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1430: P_Partner_Cont_Party_id => null,

Line 1437: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1433: x_return_status => x_return_status,
1434: x_msg_count => x_msg_count,
1435: x_msg_data => x_msg_data);
1436:
1437: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1438: raise FND_API.G_EXC_ERROR;
1439: END IF;
1440: -- end 102700 FFANG
1441: END IF;

Line 1438: raise FND_API.G_EXC_ERROR;

1434: x_msg_count => x_msg_count,
1435: x_msg_data => x_msg_data);
1436:
1437: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1438: raise FND_API.G_EXC_ERROR;
1439: END IF;
1440: -- end 102700 FFANG
1441: END IF;
1442: */

Line 1448: P_Init_Msg_List => FND_API.G_FALSE,

1444: -- ffang 030503, bug 2826512, call PUB instead of PVT
1445: -- AS_SALES_LEADS_PVT.Update_sales_lead(
1446: AS_SALES_LEADS_PUB.Update_sales_lead(
1447: P_Api_Version_Number => l_api_version_number,
1448: P_Init_Msg_List => FND_API.G_FALSE,
1449: P_Commit => FND_API.G_FALSE,
1450: P_Validation_Level => P_Validation_Level,
1451: P_Check_Access_Flag => 'Y', -- P_Check_Access_Flag,
1452: P_Admin_Flag => P_Admin_Flag,

Line 1449: P_Commit => FND_API.G_FALSE,

1445: -- AS_SALES_LEADS_PVT.Update_sales_lead(
1446: AS_SALES_LEADS_PUB.Update_sales_lead(
1447: P_Api_Version_Number => l_api_version_number,
1448: P_Init_Msg_List => FND_API.G_FALSE,
1449: P_Commit => FND_API.G_FALSE,
1450: P_Validation_Level => P_Validation_Level,
1451: P_Check_Access_Flag => 'Y', -- P_Check_Access_Flag,
1452: P_Admin_Flag => P_Admin_Flag,
1453: P_Admin_Group_Id => P_Admin_Group_Id,

Line 1462: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1458: X_Msg_Count => X_Msg_Count,
1459: X_Msg_Data => X_Msg_Data
1460: );
1461:
1462: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1463: raise FND_API.G_EXC_ERROR;
1464: END IF;
1465:
1466:

Line 1463: raise FND_API.G_EXC_ERROR;

1459: X_Msg_Data => X_Msg_Data
1460: );
1461:
1462: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1463: raise FND_API.G_EXC_ERROR;
1464: END IF;
1465:
1466:
1467: OPEN C_Lead_Link_Exists (P_SALES_LEAD_ID, P_OPPORTUNITY_ID);

Line 1526: IF FND_API.to_Boolean( p_commit )

1522: -- END of API body
1523: --
1524:
1525: -- Standard check for p_commit
1526: IF FND_API.to_Boolean( p_commit )
1527: THEN
1528: COMMIT WORK;
1529: END IF;
1530:

Line 1543: WHEN FND_API.G_EXC_ERROR THEN

1539: ( p_count => x_msg_count,
1540: p_data => x_msg_data );
1541:
1542: EXCEPTION
1543: WHEN FND_API.G_EXC_ERROR THEN
1544: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1545: P_MODULE => l_module
1546: ,P_API_NAME => L_API_NAME
1547: ,P_PKG_NAME => G_PKG_NAME

Line 1554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1550: ,X_MSG_COUNT => X_MSG_COUNT
1551: ,X_MSG_DATA => X_MSG_DATA
1552: ,X_RETURN_STATUS => X_RETURN_STATUS);
1553:
1554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1555: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1556: P_MODULE => l_module
1557: ,P_API_NAME => L_API_NAME
1558: ,P_PKG_NAME => G_PKG_NAME

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

1580: /* API added by Francis on 06/26/2001 */
1581:
1582: PROCEDURE Link_Lead_To_Opportunity(
1583: P_Api_Version_Number IN NUMBER,
1584: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1585: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1586: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1587: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1588: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

1581:
1582: PROCEDURE Link_Lead_To_Opportunity(
1583: P_Api_Version_Number IN NUMBER,
1584: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1585: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1586: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1587: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1588: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1589: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

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

1582: PROCEDURE Link_Lead_To_Opportunity(
1583: P_Api_Version_Number IN NUMBER,
1584: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1585: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1586: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1587: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1588: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1589: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
1590: P_identity_salesforce_id IN NUMBER, --:= NULL,

Line 1587: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

1583: P_Api_Version_Number IN NUMBER,
1584: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1585: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1586: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1587: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1588: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1589: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
1590: P_identity_salesforce_id IN NUMBER, --:= NULL,
1591: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

Line 1588: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

1584: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1585: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1586: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1587: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1588: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1589: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
1590: P_identity_salesforce_id IN NUMBER, --:= NULL,
1591: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
1592: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

Line 1589: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

1585: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1586: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1587: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1588: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1589: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
1590: P_identity_salesforce_id IN NUMBER, --:= NULL,
1591: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
1592: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1593: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 1591: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

1587: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1588: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1589: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
1590: P_identity_salesforce_id IN NUMBER, --:= NULL,
1591: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
1592: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1593: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1594: P_SALES_LEAD_ID IN NUMBER,
1595: P_OPPORTUNITY_ID IN NUMBER,

Line 1741: -- ,FND_API.G_MISS_NUM -- ,security_group_id

1737: ,attribute13
1738: ,attribute14
1739: ,attribute15
1740: ,parent_project
1741: -- ,FND_API.G_MISS_NUM -- ,security_group_id
1742: From AS_LEADS_ALL
1743: Where lead_id = X_Opportunity_Id;
1744:
1745: l_api_name CONSTANT VARCHAR2(30) := 'Link_Lead_To_Opportunity';

Line 1759: l_last_update_date DATE := FND_API.G_MISS_DATE;

1755: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
1756: l_val VARCHAR2(1) default null;
1757: --axavier l_val_id NUMBER;
1758: -- l_lead_line_id NUMBER;
1759: l_last_update_date DATE := FND_API.G_MISS_DATE;
1760: l_channel_code VARCHAR2(30);
1761: l_Lead_Opportunity_Id NUMBER;
1762: -- l_Lead_Opp_Line_Id NUMBER;
1763: -- l_sales_lead_line_id NUMBER default null;

Line 1775: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1771: BEGIN
1772: -- Standard Start of API savepoint
1773: SAVEPOINT LINK_LEAD_TO_OPPORTUNITY_PVT;
1774: -- Standard call to check for call compatibility.
1775: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1776: p_api_version_number,
1777: l_api_name,
1778: G_PKG_NAME)
1779: THEN

Line 1780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1776: p_api_version_number,
1777: l_api_name,
1778: G_PKG_NAME)
1779: THEN
1780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1781: END IF;
1782: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1783:
1784: -- Initialize message list IF p_init_msg_list is set to TRUE.

Line 1785: IF FND_API.to_Boolean( p_init_msg_list )

1781: END IF;
1782: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1783:
1784: -- Initialize message list IF p_init_msg_list is set to TRUE.
1785: IF FND_API.to_Boolean( p_init_msg_list )
1786: THEN
1787: FND_MSG_PUB.initialize;
1788: END IF;
1789:

Line 1796: x_return_status := FND_API.G_RET_STS_SUCCESS;

1792: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PVT:' || l_api_name || ' Start');
1793: END IF;
1794:
1795: -- Initialize API return status to SUCCESS
1796: x_return_status := FND_API.G_RET_STS_SUCCESS;
1797: --
1798: -- Api body
1799: --
1800:

Line 1817: RAISE FND_API.G_EXC_ERROR;

1813: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
1814: p_token1 => 'PROFILE',
1815: p_token1_value => 'USER_ID');
1816: END IF;
1817: RAISE FND_API.G_EXC_ERROR;
1818: END IF;
1819:
1820: IF (p_validation_level = fnd_api.g_valid_level_full)
1821: THEN

Line 1820: IF (p_validation_level = fnd_api.g_valid_level_full)

1816: END IF;
1817: RAISE FND_API.G_EXC_ERROR;
1818: END IF;
1819:
1820: IF (p_validation_level = fnd_api.g_valid_level_full)
1821: THEN
1822: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
1823: p_api_version_number => 2.0
1824: ,p_init_msg_list => p_init_msg_list

Line 1833: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1829: ,x_msg_data => x_msg_data
1830: ,x_sales_member_rec => l_identity_sales_member_rec);
1831: END IF;
1832:
1833: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1834: RAISE FND_API.G_EXC_ERROR;
1835: END IF;
1836:
1837: -- Get sales lead header based on parameter P_Sales_Lead_Id

Line 1834: RAISE FND_API.G_EXC_ERROR;

1830: ,x_sales_member_rec => l_identity_sales_member_rec);
1831: END IF;
1832:
1833: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1834: RAISE FND_API.G_EXC_ERROR;
1835: END IF;
1836:
1837: -- Get sales lead header based on parameter P_Sales_Lead_Id
1838: OPEN C_Get_Sales_Lead (P_Sales_Lead_Id);

Line 1916: x_return_status := FND_API.G_RET_STS_ERROR;

1912: p_token1_value => 'SALES_LEAD_ID',
1913: p_token2 => 'VALUE',
1914: p_token2_value => P_Sales_Lead_Id );
1915:
1916: x_return_status := FND_API.G_RET_STS_ERROR;
1917:
1918: END IF;
1919:
1920: CLOSE C_Get_Sales_Lead;

Line 1922: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1918: END IF;
1919:
1920: CLOSE C_Get_Sales_Lead;
1921:
1922: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1923: RAISE FND_API.G_EXC_ERROR;
1924: END IF;
1925:
1926:

Line 1923: RAISE FND_API.G_EXC_ERROR;

1919:
1920: CLOSE C_Get_Sales_Lead;
1921:
1922: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1923: RAISE FND_API.G_EXC_ERROR;
1924: END IF;
1925:
1926:
1927:

Line 1988: -- commented by axavier for bug 2013040 raise FND_API.G_EXC_ERROR;

1984: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
1985: FND_MESSAGE.Set_Token ('INFO', 'Opportunity', FALSE);
1986: FND_MSG_PUB.Add;
1987: END IF;
1988: -- commented by axavier for bug 2013040 raise FND_API.G_EXC_ERROR;
1989: x_return_status := FND_API.G_RET_STS_ERROR;
1990:
1991: END IF;
1992: -- Debug Message

Line 1989: x_return_status := FND_API.G_RET_STS_ERROR;

1985: FND_MESSAGE.Set_Token ('INFO', 'Opportunity', FALSE);
1986: FND_MSG_PUB.Add;
1987: END IF;
1988: -- commented by axavier for bug 2013040 raise FND_API.G_EXC_ERROR;
1989: x_return_status := FND_API.G_RET_STS_ERROR;
1990:
1991: END IF;
1992: -- Debug Message
1993: IF l_debug THEN

Line 1998: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1994: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Close Cursor C_Get_Opportunity');
1995: END IF;
1996: Close C_Get_Opportunity;
1997:
1998: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1999: RAISE FND_API.G_EXC_ERROR;
2000: END IF;
2001:
2002: -- Invoke validation procedures

Line 1999: RAISE FND_API.G_EXC_ERROR;

1995: END IF;
1996: Close C_Get_Opportunity;
1997:
1998: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1999: RAISE FND_API.G_EXC_ERROR;
2000: END IF;
2001:
2002: -- Invoke validation procedures
2003: -- Debug message

Line 2010: P_Init_Msg_List => FND_API.G_FALSE

2006: END IF;
2007:
2008: -- Validate sales lead id whther it is a valid ID.
2009: AS_SALES_LEADS_PVT.Validate_Sales_Lead_Id (
2010: P_Init_Msg_List => FND_API.G_FALSE
2011: ,P_Validation_mode => FND_API.G_MISS_CHAR
2012: ,P_Sales_Lead_Id => P_Sales_Lead_Id
2013: ,X_Return_Status => X_Return_Status
2014: ,X_Msg_Count => X_Msg_Count

Line 2011: ,P_Validation_mode => FND_API.G_MISS_CHAR

2007:
2008: -- Validate sales lead id whther it is a valid ID.
2009: AS_SALES_LEADS_PVT.Validate_Sales_Lead_Id (
2010: P_Init_Msg_List => FND_API.G_FALSE
2011: ,P_Validation_mode => FND_API.G_MISS_CHAR
2012: ,P_Sales_Lead_Id => P_Sales_Lead_Id
2013: ,X_Return_Status => X_Return_Status
2014: ,X_Msg_Count => X_Msg_Count
2015: ,X_Msg_Data => X_Msg_Data

Line 2018: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2014: ,X_Msg_Count => X_Msg_Count
2015: ,X_Msg_Data => X_Msg_Data
2016: );
2017:
2018: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2019: raise FND_API.G_EXC_ERROR;
2020: END IF;
2021:
2022: -- Validate one sales lead can only be link to one opportunity

Line 2019: raise FND_API.G_EXC_ERROR;

2015: ,X_Msg_Data => X_Msg_Data
2016: );
2017:
2018: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2019: raise FND_API.G_EXC_ERROR;
2020: END IF;
2021:
2022: -- Validate one sales lead can only be link to one opportunity
2023: -- Debug message

Line 2045: x_return_status := FND_API.G_RET_STS_ERROR;

2041: FND_MESSAGE.Set_Token('OPP_ID', p_opportunity_id, FALSE);
2042: -- end ffang 100900
2043: FND_MSG_PUB.ADD;
2044: -- END IF;
2045: x_return_status := FND_API.G_RET_STS_ERROR;
2046: END IF;
2047:
2048: CLOSE C_Lead_Link_Exists;
2049:

Line 2050: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2046: END IF;
2047:
2048: CLOSE C_Lead_Link_Exists;
2049:
2050: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2051: raise FND_API.G_EXC_ERROR;
2052: END IF;
2053:
2054: l_Sales_Lead_Rec.Status_Code := nvl(FND_PROFILE.Value('AS_LEAD_LINK_STATUS'),'CONVERTED_TO_OPPORTUNITY');

Line 2051: raise FND_API.G_EXC_ERROR;

2047:
2048: CLOSE C_Lead_Link_Exists;
2049:
2050: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2051: raise FND_API.G_EXC_ERROR;
2052: END IF;
2053:
2054: l_Sales_Lead_Rec.Status_Code := nvl(FND_PROFILE.Value('AS_LEAD_LINK_STATUS'),'CONVERTED_TO_OPPORTUNITY');
2055: -- has to be changed once the profile problem is solved

Line 2087: x_return_status := FND_API.G_RET_STS_ERROR;

2083: -- end ffang 100900
2084: FND_MSG_PUB.ADD;
2085: END IF;
2086:
2087: x_return_status := FND_API.G_RET_STS_ERROR;
2088: END IF;
2089:
2090: CLOSE C_Get_Sales_Owner;
2091:

Line 2099: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2095: END IF;
2096:
2097: CLOSE C_Sales_Owner_Check;
2098:
2099: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2100: raise FND_API.G_EXC_ERROR;
2101: END IF;
2102: */
2103: l_header_rec.updateable_flag := 'N';

Line 2100: raise FND_API.G_EXC_ERROR;

2096:
2097: CLOSE C_Sales_Owner_Check;
2098:
2099: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2100: raise FND_API.G_EXC_ERROR;
2101: END IF;
2102: */
2103: l_header_rec.updateable_flag := 'N';
2104: l_header_rec.member_access := FND_API.G_MISS_CHAR;

Line 2104: l_header_rec.member_access := FND_API.G_MISS_CHAR;

2100: raise FND_API.G_EXC_ERROR;
2101: END IF;
2102: */
2103: l_header_rec.updateable_flag := 'N';
2104: l_header_rec.member_access := FND_API.G_MISS_CHAR;
2105: l_header_rec.member_role := FND_API.G_MISS_CHAR;
2106:
2107: -- Update Sales Leads for Status Code and Sales lead owner IF needed
2108: -- ffang 030503, bug 2826512, call PUB instead of PVT

Line 2105: l_header_rec.member_role := FND_API.G_MISS_CHAR;

2101: END IF;
2102: */
2103: l_header_rec.updateable_flag := 'N';
2104: l_header_rec.member_access := FND_API.G_MISS_CHAR;
2105: l_header_rec.member_role := FND_API.G_MISS_CHAR;
2106:
2107: -- Update Sales Leads for Status Code and Sales lead owner IF needed
2108: -- ffang 030503, bug 2826512, call PUB instead of PVT
2109: -- AS_SALES_LEADS_PVT.Update_sales_lead(

Line 2112: P_Init_Msg_List => FND_API.G_FALSE,

2108: -- ffang 030503, bug 2826512, call PUB instead of PVT
2109: -- AS_SALES_LEADS_PVT.Update_sales_lead(
2110: AS_SALES_LEADS_PUB.Update_sales_lead(
2111: P_Api_Version_Number => l_api_version_number,
2112: P_Init_Msg_List => FND_API.G_FALSE,
2113: P_Commit => FND_API.G_FALSE,
2114: P_Validation_Level => P_Validation_Level,
2115: -- P_Check_Access_Flag => 'Y', -- P_Check_Access_Flag, commented by axavier for oppty
2116: P_Check_Access_Flag => P_Check_Access_Flag,

Line 2113: P_Commit => FND_API.G_FALSE,

2109: -- AS_SALES_LEADS_PVT.Update_sales_lead(
2110: AS_SALES_LEADS_PUB.Update_sales_lead(
2111: P_Api_Version_Number => l_api_version_number,
2112: P_Init_Msg_List => FND_API.G_FALSE,
2113: P_Commit => FND_API.G_FALSE,
2114: P_Validation_Level => P_Validation_Level,
2115: -- P_Check_Access_Flag => 'Y', -- P_Check_Access_Flag, commented by axavier for oppty
2116: P_Check_Access_Flag => P_Check_Access_Flag,
2117: P_Admin_Flag => P_Admin_Flag,

Line 2127: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2123: X_Msg_Count => X_Msg_Count,
2124: X_Msg_Data => X_Msg_Data
2125: );
2126:
2127: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2128: raise FND_API.G_EXC_ERROR;
2129: END IF;
2130:
2131: -- ffang 062802, bug 2422212, LEAD_OPPORTUNITY_ID need to be initialized

Line 2128: raise FND_API.G_EXC_ERROR;

2124: X_Msg_Data => X_Msg_Data
2125: );
2126:
2127: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2128: raise FND_API.G_EXC_ERROR;
2129: END IF;
2130:
2131: -- ffang 062802, bug 2422212, LEAD_OPPORTUNITY_ID need to be initialized
2132: l_Lead_Opportunity_Id := NULL;

Line 2181: IF FND_API.to_Boolean( p_commit )

2177: -- END of API body
2178: --
2179:
2180: -- Standard check for p_commit
2181: IF FND_API.to_Boolean( p_commit )
2182: THEN
2183: COMMIT WORK;
2184: END IF;
2185:

Line 2198: WHEN FND_API.G_EXC_ERROR THEN

2194: ( p_count => x_msg_count,
2195: p_data => x_msg_data );
2196:
2197: EXCEPTION
2198: WHEN FND_API.G_EXC_ERROR THEN
2199: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2200: P_MODULE => l_module
2201: ,P_API_NAME => L_API_NAME
2202: ,P_PKG_NAME => G_PKG_NAME

Line 2209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2205: ,X_MSG_COUNT => X_MSG_COUNT
2206: ,X_MSG_DATA => X_MSG_DATA
2207: ,X_RETURN_STATUS => X_RETURN_STATUS);
2208:
2209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2210: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2211: P_MODULE => l_module
2212: ,P_API_NAME => L_API_NAME
2213: ,P_PKG_NAME => G_PKG_NAME

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

2236: -- API Name: Create_Opportunity_For_Lead
2237:
2238: PROCEDURE Create_Opportunity_For_Lead(
2239: P_Api_Version_Number IN NUMBER,
2240: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2241: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2243: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
2244: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

2237:
2238: PROCEDURE Create_Opportunity_For_Lead(
2239: P_Api_Version_Number IN NUMBER,
2240: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2241: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2243: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
2244: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
2245: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

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

2238: PROCEDURE Create_Opportunity_For_Lead(
2239: P_Api_Version_Number IN NUMBER,
2240: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2241: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2243: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
2244: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
2245: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
2246: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 2243: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

2239: P_Api_Version_Number IN NUMBER,
2240: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2241: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2243: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
2244: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
2245: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
2246: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
2247: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

Line 2244: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

2240: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2241: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2243: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
2244: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
2245: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
2246: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
2247: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
2248: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

Line 2245: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

2241: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2243: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
2244: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
2245: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
2246: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
2247: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
2248: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
2249: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 2246: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

2242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2243: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
2244: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
2245: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
2246: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
2247: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
2248: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
2249: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
2250: P_SALES_LEAD_ID IN NUMBER,

Line 2247: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

2243: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
2244: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
2245: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
2246: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
2247: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
2248: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
2249: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
2250: P_SALES_LEAD_ID IN NUMBER,
2251: P_OPP_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 2251: P_OPP_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,

2247: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
2248: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
2249: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
2250: P_SALES_LEAD_ID IN NUMBER,
2251: P_OPP_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
2252: X_Return_Status OUT NOCOPY VARCHAR2,
2253: X_Msg_Count OUT NOCOPY NUMBER,
2254: X_Msg_Data OUT NOCOPY VARCHAR2,
2255: X_OPPORTUNITY_ID OUT NOCOPY NUMBER

Line 2524: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

2520: -- Standard Start of API savepoint
2521: SAVEPOINT CREATE_OPP_FOR_LEAD_PVT;
2522:
2523: -- Standard call to check for call compatibility.
2524: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2525: p_api_version_number,
2526: l_api_name,
2527: G_PKG_NAME)
2528: THEN

Line 2529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2525: p_api_version_number,
2526: l_api_name,
2527: G_PKG_NAME)
2528: THEN
2529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2530: END IF;
2531: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2532: l_debug_high := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
2533: l_debug_err := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR);

Line 2536: IF FND_API.to_Boolean( p_init_msg_list )

2532: l_debug_high := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
2533: l_debug_err := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR);
2534:
2535: -- Initialize message list IF p_init_msg_list is set to TRUE.
2536: IF FND_API.to_Boolean( p_init_msg_list )
2537: THEN
2538: FND_MSG_PUB.initialize;
2539: END IF;
2540:

Line 2549: x_return_status := FND_API.G_RET_STS_SUCCESS;

2545:
2546:
2547:
2548: -- Initialize API return status to SUCCESS
2549: x_return_status := FND_API.G_RET_STS_SUCCESS;
2550:
2551: --
2552: -- Api body
2553: --

Line 2568: RAISE FND_API.G_EXC_ERROR;

2564: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
2565: p_token1 => 'PROFILE',
2566: p_token1_value => 'USER_ID');
2567: END IF;
2568: RAISE FND_API.G_EXC_ERROR;
2569: END IF;
2570:
2571: IF (p_validation_level = fnd_api.g_valid_level_full)
2572: THEN

Line 2571: IF (p_validation_level = fnd_api.g_valid_level_full)

2567: END IF;
2568: RAISE FND_API.G_EXC_ERROR;
2569: END IF;
2570:
2571: IF (p_validation_level = fnd_api.g_valid_level_full)
2572: THEN
2573: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
2574: p_api_version_number => 2.0
2575: ,p_init_msg_list => p_init_msg_list

Line 2584: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2580: ,x_msg_data => x_msg_data
2581: ,x_sales_member_rec => l_identity_sales_member_rec);
2582: END IF;
2583:
2584: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2585: RAISE FND_API.G_EXC_ERROR;
2586: END IF;
2587:
2588: IF(P_Check_Access_Flag = 'Y') THEN

Line 2585: RAISE FND_API.G_EXC_ERROR;

2581: ,x_sales_member_rec => l_identity_sales_member_rec);
2582: END IF;
2583:
2584: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2585: RAISE FND_API.G_EXC_ERROR;
2586: END IF;
2587:
2588: IF(P_Check_Access_Flag = 'Y') THEN
2589: -- Call Get_Access_Profiles to get access_profile_rec

Line 2604: ,p_init_msg_list => FND_API.G_FALSE

2600: END IF;
2601:
2602: AS_ACCESS_PUB.Has_updateLeadAccess(
2603: p_api_version_number => 2.0
2604: ,p_init_msg_list => FND_API.G_FALSE
2605: ,p_validation_level => p_validation_level
2606: ,p_access_profile_rec => l_access_profile_rec
2607: ,p_admin_flag => p_admin_flag
2608: ,p_admin_group_id => p_admin_group_id

Line 2623: RAISE FND_API.G_EXC_ERROR;

2619: IF l_update_access_flag <> 'Y' THEN
2620: IF l_debug_err THEN
2621: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'API_NO_CREATE_PRIVILEGE');
2622: END IF;
2623: RAISE FND_API.G_EXC_ERROR;
2624: END IF;
2625:
2626: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2627: RAISE FND_API.G_EXC_ERROR;

Line 2626: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2622: END IF;
2623: RAISE FND_API.G_EXC_ERROR;
2624: END IF;
2625:
2626: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2627: RAISE FND_API.G_EXC_ERROR;
2628: END IF;
2629:
2630: END IF;

Line 2627: RAISE FND_API.G_EXC_ERROR;

2623: RAISE FND_API.G_EXC_ERROR;
2624: END IF;
2625:
2626: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2627: RAISE FND_API.G_EXC_ERROR;
2628: END IF;
2629:
2630: END IF;
2631:

Line 2647: x_return_status := FND_API.G_RET_STS_ERROR;

2643: THEN
2644: FND_MESSAGE.Set_Name('AS', 'API_DUPLICATE_LINK');
2645: FND_MESSAGE.Set_Token('SLD_ID', p_sales_lead_id, FALSE);
2646: FND_MSG_PUB.ADD;
2647: x_return_status := FND_API.G_RET_STS_ERROR;
2648: END IF;
2649:
2650: CLOSE C_Lead_Link_Exists;
2651: */

Line 2652: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2648: END IF;
2649:
2650: CLOSE C_Lead_Link_Exists;
2651: */
2652: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2653: RAISE FND_API.G_EXC_ERROR;
2654: END IF;
2655: -- Get sales lead header based on parameter P_Sales_Lead_Id
2656: OPEN C_Get_Sales_Lead (P_Sales_Lead_Id);

Line 2653: RAISE FND_API.G_EXC_ERROR;

2649:
2650: CLOSE C_Lead_Link_Exists;
2651: */
2652: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2653: RAISE FND_API.G_EXC_ERROR;
2654: END IF;
2655: -- Get sales lead header based on parameter P_Sales_Lead_Id
2656: OPEN C_Get_Sales_Lead (P_Sales_Lead_Id);
2657: FETCH C_Get_Sales_Lead INTO

Line 2742: x_return_status := FND_API.G_RET_STS_ERROR;

2738: p_token1_value => 'SALES_LEAD_ID',
2739: p_token2 => 'VALUE',
2740: p_token2_value => P_Sales_Lead_Id );
2741:
2742: x_return_status := FND_API.G_RET_STS_ERROR;
2743:
2744: END IF;
2745:
2746: CLOSE C_Get_Sales_Lead;

Line 2748: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2744: END IF;
2745:
2746: CLOSE C_Get_Sales_Lead;
2747:
2748: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2749: RAISE FND_API.G_EXC_ERROR;
2750: END IF;
2751:
2752: -- Begin Added for Bug#3613374

Line 2749: RAISE FND_API.G_EXC_ERROR;

2745:
2746: CLOSE C_Get_Sales_Lead;
2747:
2748: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2749: RAISE FND_API.G_EXC_ERROR;
2750: END IF;
2751:
2752: -- Begin Added for Bug#3613374
2753: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y' THEN

Line 2756: ,p_init_msg_list => FND_API.G_FALSE

2752: -- Begin Added for Bug#3613374
2753: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y' THEN
2754: CHECK_SALES_STAGE(
2755: p_api_version_number => 2.0
2756: ,p_init_msg_list => FND_API.G_FALSE
2757: ,p_validation_level => p_validation_level
2758: ,p_sales_lead_id =>P_Sales_Lead_Id
2759: ,P_sales_lead_stage_id =>l_sales_lead_stage_id
2760: ,P_sales_lead_methodology_id =>l_sales_lead_methodology_id

Line 2766: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2762: ,X_sales_methodology_id =>l_sales_methodology_id
2763: ,X_Return_Status =>x_return_status
2764: ,X_Msg_Count =>x_msg_count
2765: ,X_Msg_Data =>x_msg_data);
2766: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2767: RAISE FND_API.G_EXC_ERROR;
2768: ELSE
2769: l_header_rec.Sales_Methodology_Id := l_sales_methodology_id;
2770: l_header_rec.sales_stage_id := l_sales_stage_id;

Line 2767: RAISE FND_API.G_EXC_ERROR;

2763: ,X_Return_Status =>x_return_status
2764: ,X_Msg_Count =>x_msg_count
2765: ,X_Msg_Data =>x_msg_data);
2766: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2767: RAISE FND_API.G_EXC_ERROR;
2768: ELSE
2769: l_header_rec.Sales_Methodology_Id := l_sales_methodology_id;
2770: l_header_rec.sales_stage_id := l_sales_stage_id;
2771: null;

Line 2889: p_init_msg_list => FND_API.G_FALSE,

2885: -- ffang 030503, bug 2826512, call PUB instead of PVT
2886: -- AS_OPP_HEADER_PVT.Create_opp_header (
2887: AS_OPPORTUNITY_PUB.Create_Opp_Header (
2888: p_api_version_number => 2.0,
2889: p_init_msg_list => FND_API.G_FALSE,
2890: p_commit => FND_API.G_FALSE,
2891: p_validation_level => p_validation_level,
2892: P_Check_Access_Flag => 'N', -- 'Y',
2893: -- P_Check_Access_Flag => P_Check_Access_Flag,

Line 2890: p_commit => FND_API.G_FALSE,

2886: -- AS_OPP_HEADER_PVT.Create_opp_header (
2887: AS_OPPORTUNITY_PUB.Create_Opp_Header (
2888: p_api_version_number => 2.0,
2889: p_init_msg_list => FND_API.G_FALSE,
2890: p_commit => FND_API.G_FALSE,
2891: p_validation_level => p_validation_level,
2892: P_Check_Access_Flag => 'N', -- 'Y',
2893: -- P_Check_Access_Flag => P_Check_Access_Flag,
2894: P_Admin_Flag => P_Admin_Flag,

Line 2899: P_Partner_Cont_Party_id => FND_API.G_MISS_NUM,

2895: P_Admin_Group_Id => P_Admin_Group_Id,
2896: P_Identity_Salesforce_Id => P_identity_Salesforce_id,
2897: P_salesgroup_id => P_identity_salesgroup_id,
2898: P_profile_tbl => AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
2899: P_Partner_Cont_Party_id => FND_API.G_MISS_NUM,
2900: P_Header_Rec => l_header_rec,
2901: X_LEAD_ID => l_lead_id,
2902: x_return_status => x_return_status,
2903: x_msg_count => x_msg_count,

Line 2906: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2902: x_return_status => x_return_status,
2903: x_msg_count => x_msg_count,
2904: x_msg_data => x_msg_data);
2905:
2906: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2907: raise FND_API.G_EXC_ERROR;
2908: END IF;
2909:
2910:

Line 2907: raise FND_API.G_EXC_ERROR;

2903: x_msg_count => x_msg_count,
2904: x_msg_data => x_msg_data);
2905:
2906: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2907: raise FND_API.G_EXC_ERROR;
2908: END IF;
2909:
2910:
2911: IF l_debug THEN

Line 2994: l_line_tbl(l_cnt).member_access := FND_API.G_MISS_CHAR;

2990: l_line_tbl(l_cnt).attribute12 := C_Sales_Lead_lines_Rec.attribute12;
2991: l_line_tbl(l_cnt).attribute13 := C_Sales_Lead_lines_Rec.attribute13;
2992: l_line_tbl(l_cnt).attribute14 := C_Sales_Lead_lines_Rec.attribute14;
2993: l_line_tbl(l_cnt).attribute15 := C_Sales_Lead_lines_Rec.attribute15;
2994: l_line_tbl(l_cnt).member_access := FND_API.G_MISS_CHAR;
2995: l_line_tbl(l_cnt).member_role := FND_API.G_MISS_CHAR;
2996: l_line_tbl(l_cnt).owner_scredit_percent := FND_API.G_MISS_NUM;
2997: -- l_line_tbl(l_cnt).security_group_id
2998: -- := C_Sales_Lead_lines_Rec.security_group_id;

Line 2995: l_line_tbl(l_cnt).member_role := FND_API.G_MISS_CHAR;

2991: l_line_tbl(l_cnt).attribute13 := C_Sales_Lead_lines_Rec.attribute13;
2992: l_line_tbl(l_cnt).attribute14 := C_Sales_Lead_lines_Rec.attribute14;
2993: l_line_tbl(l_cnt).attribute15 := C_Sales_Lead_lines_Rec.attribute15;
2994: l_line_tbl(l_cnt).member_access := FND_API.G_MISS_CHAR;
2995: l_line_tbl(l_cnt).member_role := FND_API.G_MISS_CHAR;
2996: l_line_tbl(l_cnt).owner_scredit_percent := FND_API.G_MISS_NUM;
2997: -- l_line_tbl(l_cnt).security_group_id
2998: -- := C_Sales_Lead_lines_Rec.security_group_id;
2999: -- 103000 FFANG for bug 1479671

Line 2996: l_line_tbl(l_cnt).owner_scredit_percent := FND_API.G_MISS_NUM;

2992: l_line_tbl(l_cnt).attribute14 := C_Sales_Lead_lines_Rec.attribute14;
2993: l_line_tbl(l_cnt).attribute15 := C_Sales_Lead_lines_Rec.attribute15;
2994: l_line_tbl(l_cnt).member_access := FND_API.G_MISS_CHAR;
2995: l_line_tbl(l_cnt).member_role := FND_API.G_MISS_CHAR;
2996: l_line_tbl(l_cnt).owner_scredit_percent := FND_API.G_MISS_NUM;
2997: -- l_line_tbl(l_cnt).security_group_id
2998: -- := C_Sales_Lead_lines_Rec.security_group_id;
2999: -- 103000 FFANG for bug 1479671
3000: l_line_tbl(l_cnt).offer_id := C_Sales_Lead_lines_Rec.offer_id;

Line 3017: p_init_msg_list => FND_API.G_FALSE,

3013: -- ffang 030503, bug 2826512, call PUB instead of PVT
3014: -- AS_OPP_line_PVT.Create_opp_lines (
3015: AS_OPPORTUNITY_PUB.Create_Opp_Lines (
3016: p_api_version_number => 2.0,
3017: p_init_msg_list => FND_API.G_FALSE,
3018: p_commit => FND_API.G_FALSE,
3019: p_validation_level => p_validation_level,
3020: P_Check_Access_Flag => 'N', -- p_check_access_flag,
3021: -- P_Check_Access_Flag => FND_API.G_FALSE,

Line 3018: p_commit => FND_API.G_FALSE,

3014: -- AS_OPP_line_PVT.Create_opp_lines (
3015: AS_OPPORTUNITY_PUB.Create_Opp_Lines (
3016: p_api_version_number => 2.0,
3017: p_init_msg_list => FND_API.G_FALSE,
3018: p_commit => FND_API.G_FALSE,
3019: p_validation_level => p_validation_level,
3020: P_Check_Access_Flag => 'N', -- p_check_access_flag,
3021: -- P_Check_Access_Flag => FND_API.G_FALSE,
3022: P_Admin_Flag => p_admin_flag,

Line 3021: -- P_Check_Access_Flag => FND_API.G_FALSE,

3017: p_init_msg_list => FND_API.G_FALSE,
3018: p_commit => FND_API.G_FALSE,
3019: p_validation_level => p_validation_level,
3020: P_Check_Access_Flag => 'N', -- p_check_access_flag,
3021: -- P_Check_Access_Flag => FND_API.G_FALSE,
3022: P_Admin_Flag => p_admin_flag,
3023: P_Admin_Group_Id => P_Admin_Group_Id,
3024: P_Identity_Salesforce_Id => p_identity_salesforce_id,
3025: P_salesgroup_id => P_identity_salesgroup_id,

Line 3035: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3031: x_return_status => x_return_status,
3032: x_msg_count => x_msg_count,
3033: x_msg_data => x_msg_data);
3034:
3035: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3036: raise FND_API.G_EXC_ERROR;
3037: END IF;
3038:
3039: For l_index In 1..l_line_out_tbl.count Loop

Line 3036: raise FND_API.G_EXC_ERROR;

3032: x_msg_count => x_msg_count,
3033: x_msg_data => x_msg_data);
3034:
3035: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3036: raise FND_API.G_EXC_ERROR;
3037: END IF;
3038:
3039: For l_index In 1..l_line_out_tbl.count Loop
3040: IF l_debug THEN

Line 3145: p_init_msg_list => FND_API.G_FALSE,

3141: -- ffang 030503, bug 2826512, call PUB instead of PVT
3142: -- AS_OPP_CONTACT_PVT.Create_opp_contacts (
3143: AS_OPPORTUNITY_PUB.Create_Contacts (
3144: p_api_version_number => 2.0,
3145: p_init_msg_list => FND_API.G_FALSE,
3146: p_commit => FND_API.G_FALSE,
3147: p_validation_level => p_validation_level,
3148: P_Check_Access_Flag => 'N', -- P_Check_Access_Flag,
3149: -- P_Check_Access_Flag => FND_API.G_FALSE,

Line 3146: p_commit => FND_API.G_FALSE,

3142: -- AS_OPP_CONTACT_PVT.Create_opp_contacts (
3143: AS_OPPORTUNITY_PUB.Create_Contacts (
3144: p_api_version_number => 2.0,
3145: p_init_msg_list => FND_API.G_FALSE,
3146: p_commit => FND_API.G_FALSE,
3147: p_validation_level => p_validation_level,
3148: P_Check_Access_Flag => 'N', -- P_Check_Access_Flag,
3149: -- P_Check_Access_Flag => FND_API.G_FALSE,
3150: P_Admin_Flag => P_Admin_Flag,

Line 3149: -- P_Check_Access_Flag => FND_API.G_FALSE,

3145: p_init_msg_list => FND_API.G_FALSE,
3146: p_commit => FND_API.G_FALSE,
3147: p_validation_level => p_validation_level,
3148: P_Check_Access_Flag => 'N', -- P_Check_Access_Flag,
3149: -- P_Check_Access_Flag => FND_API.G_FALSE,
3150: P_Admin_Flag => P_Admin_Flag,
3151: P_Admin_Group_Id => P_Admin_Group_Id,
3152: P_Identity_Salesforce_Id => p_identity_salesforce_id,
3153: P_profile_tbl => AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 3161: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3157: x_return_status => x_return_status,
3158: x_msg_count => x_msg_count,
3159: x_msg_data => x_msg_data);
3160:
3161: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3162: raise FND_API.G_EXC_ERROR;
3163: END IF;
3164: -- end 102700 FFANG
3165: END IF;

Line 3162: raise FND_API.G_EXC_ERROR;

3158: x_msg_count => x_msg_count,
3159: x_msg_data => x_msg_data);
3160:
3161: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3162: raise FND_API.G_EXC_ERROR;
3163: END IF;
3164: -- end 102700 FFANG
3165: END IF;
3166:

Line 3204: P_Init_Msg_List => FND_API.G_FALSE,

3200: -- ffang 030503, bug 2826512, call PUB instead of PVT
3201: -- AS_SALES_LEADS_PVT.Update_sales_lead(
3202: AS_SALES_LEADS_PUB.Update_sales_lead(
3203: P_Api_Version_Number => l_api_version_number,
3204: P_Init_Msg_List => FND_API.G_FALSE,
3205: P_Commit => FND_API.G_FALSE,
3206: P_Validation_Level => P_Validation_Level,
3207: P_Check_Access_Flag => 'Y', -- P_Check_Access_Flag,
3208: P_Admin_Flag => P_Admin_Flag,

Line 3205: P_Commit => FND_API.G_FALSE,

3201: -- AS_SALES_LEADS_PVT.Update_sales_lead(
3202: AS_SALES_LEADS_PUB.Update_sales_lead(
3203: P_Api_Version_Number => l_api_version_number,
3204: P_Init_Msg_List => FND_API.G_FALSE,
3205: P_Commit => FND_API.G_FALSE,
3206: P_Validation_Level => P_Validation_Level,
3207: P_Check_Access_Flag => 'Y', -- P_Check_Access_Flag,
3208: P_Admin_Flag => P_Admin_Flag,
3209: P_Admin_Group_Id => P_Admin_Group_Id,

Line 3219: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3215: X_Msg_Count => X_Msg_Count,
3216: X_Msg_Data => X_Msg_Data
3217: );
3218:
3219: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3220: raise FND_API.G_EXC_ERROR;
3221: END IF;
3222:
3223: -- ffang 071202, bug 2451983

Line 3220: raise FND_API.G_EXC_ERROR;

3216: X_Msg_Data => X_Msg_Data
3217: );
3218:
3219: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3220: raise FND_API.G_EXC_ERROR;
3221: END IF;
3222:
3223: -- ffang 071202, bug 2451983
3224: l_Lead_Opportunity_Id := NULL;

Line 3271: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3267: l_lead_id,
3268: X_Return_Status
3269: );
3270:
3271: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3272: raise FND_API.G_EXC_ERROR;
3273: END IF;
3274:
3275: -- ffang 051602, bug 2278318, copy lead's sales team to oppty

Line 3272: raise FND_API.G_EXC_ERROR;

3268: X_Return_Status
3269: );
3270:
3271: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3272: raise FND_API.G_EXC_ERROR;
3273: END IF;
3274:
3275: -- ffang 051602, bug 2278318, copy lead's sales team to oppty
3276: IF nvl(FND_PROFILE.Value('AS_LEADLINK_MOVE_ST'), 'N') = 'Y' THEN

Line 3334: ,p_init_msg_list => FND_API.G_FALSE

3330: END IF;
3331:
3332: AS_ACCESS_PUB.Create_SalesTeam (
3333: p_api_version_number => 2.0
3334: ,p_init_msg_list => FND_API.G_FALSE
3335: ,p_commit => FND_API.G_FALSE
3336: ,p_validation_level => p_Validation_Level
3337: ,p_access_profile_rec => l_access_profile_rec
3338: ,p_check_access_flag => 'N'

Line 3335: ,p_commit => FND_API.G_FALSE

3331:
3332: AS_ACCESS_PUB.Create_SalesTeam (
3333: p_api_version_number => 2.0
3334: ,p_init_msg_list => FND_API.G_FALSE
3335: ,p_commit => FND_API.G_FALSE
3336: ,p_validation_level => p_Validation_Level
3337: ,p_access_profile_rec => l_access_profile_rec
3338: ,p_check_access_flag => 'N'
3339: ,p_admin_flag => P_Admin_Flag

Line 3352: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3348:
3349: IF l_debug THEN
3350: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'access_id : ' || l_Access_Id);
3351: END IF;
3352: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3353: RAISE FND_API.G_EXC_ERROR;
3354: END IF;
3355: END LOOP;
3356: END IF;

Line 3353: RAISE FND_API.G_EXC_ERROR;

3349: IF l_debug THEN
3350: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'access_id : ' || l_Access_Id);
3351: END IF;
3352: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3353: RAISE FND_API.G_EXC_ERROR;
3354: END IF;
3355: END LOOP;
3356: END IF;
3357: -- end ffang 051602, bug 2278318

Line 3395: p_init_msg_list => FND_API.G_FALSE,

3391: l_psalesteam_rec.salesforce_id:=l_Sales_Lead_Rec.incumbent_partner_resource_id;
3392:
3393: AS_ACCESS_PUB.Create_SalesTeam(
3394: p_api_version_number => 2.0,
3395: p_init_msg_list => FND_API.G_FALSE,
3396: p_commit => FND_API.G_FALSE,
3397: p_validation_level => p_Validation_Level,
3398: p_access_profile_rec => l_access_profile_rec,
3399: p_check_access_flag => 'N',

Line 3396: p_commit => FND_API.G_FALSE,

3392:
3393: AS_ACCESS_PUB.Create_SalesTeam(
3394: p_api_version_number => 2.0,
3395: p_init_msg_list => FND_API.G_FALSE,
3396: p_commit => FND_API.G_FALSE,
3397: p_validation_level => p_Validation_Level,
3398: p_access_profile_rec => l_access_profile_rec,
3399: p_check_access_flag => 'N',
3400: p_admin_flag => P_Admin_Flag,

Line 3411: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3407: x_access_id => l_Access_Id);
3408: IF l_debug THEN
3409: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'access_id of preferred partner: ' || l_Access_Id);
3410: END IF;
3411: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3412: RAISE FND_API.G_EXC_ERROR;
3413: END IF;
3414: END IF;
3415: -- End Bug#3966128

Line 3412: RAISE FND_API.G_EXC_ERROR;

3408: IF l_debug THEN
3409: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'access_id of preferred partner: ' || l_Access_Id);
3410: END IF;
3411: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3412: RAISE FND_API.G_EXC_ERROR;
3413: END IF;
3414: END IF;
3415: -- End Bug#3966128
3416:

Line 3422: IF FND_API.to_Boolean( p_commit )

3418: -- END of API body
3419: --
3420:
3421: -- Standard check for p_commit
3422: IF FND_API.to_Boolean( p_commit )
3423: THEN
3424: COMMIT WORK;
3425: END IF;
3426:

Line 3439: WHEN FND_API.G_EXC_ERROR THEN

3435: ( p_count => x_msg_count,
3436: p_data => x_msg_data );
3437:
3438: EXCEPTION
3439: WHEN FND_API.G_EXC_ERROR THEN
3440: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3441: P_MODULE => l_module
3442: ,P_API_NAME => L_API_NAME
3443: ,P_PKG_NAME => G_PKG_NAME

Line 3450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3446: ,X_MSG_COUNT => X_MSG_COUNT
3447: ,X_MSG_DATA => X_MSG_DATA
3448: ,X_RETURN_STATUS => X_RETURN_STATUS);
3449:
3450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3451: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3452: P_MODULE => l_module
3453: ,P_API_NAME => L_API_NAME
3454: ,P_PKG_NAME => G_PKG_NAME

Line 3513: x_return_status := fnd_api.g_ret_sts_success;

3509: -- commented for now may be break in a trigger
3510: -- SAVEPOINT Create_Lead_Ctx;
3511:
3512: -- Initialize return status to SUCCESS
3513: x_return_status := fnd_api.g_ret_sts_success;
3514:
3515: For notes_rec In c_get_notes (p_sales_lead_id, p_opportunity_id)
3516: Loop
3517: SELECT JTF_NOTES_S.NEXTVAL INTO l_jtf_notes_context_id FROM DUAL;

Line 3548: x_return_status := fnd_api.g_ret_sts_error;

3544: WHEN NO_DATA_FOUND THEN
3545: NULL;
3546: WHEN OTHERS THEN
3547: -- ROLLBACK TO Create_Lead_Ctx;
3548: x_return_status := fnd_api.g_ret_sts_error;
3549:
3550:
3551: END Create_Lead_Ctx;
3552:

Line 3556: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

3552:
3553: -- This procedure Added for Bug#3613374
3554: PROCEDURE CHECK_SALES_STAGE(
3555: p_api_version_number IN NUMBER,
3556: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3557: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
3558: p_sales_lead_id IN NUMBER,
3559: P_sales_lead_stage_id IN NUMBER,
3560: P_sales_lead_methodology_id IN NUMBER,

Line 3557: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

3553: -- This procedure Added for Bug#3613374
3554: PROCEDURE CHECK_SALES_STAGE(
3555: p_api_version_number IN NUMBER,
3556: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3557: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
3558: p_sales_lead_id IN NUMBER,
3559: P_sales_lead_stage_id IN NUMBER,
3560: P_sales_lead_methodology_id IN NUMBER,
3561: X_sales_stage_id OUT NOCOPY NUMBER,

Line 3595: x_return_status := FND_API.G_RET_STS_SUCCESS;

3591: BEGIN
3592: -- Standard Start of API savepoint
3593: SAVEPOINT CHECK_SALES_STAGE_PVT;
3594: -- Initialize API return status to SUCCESS
3595: x_return_status := FND_API.G_RET_STS_SUCCESS;
3596: -- Initialize message list if p_init_msg_list is set to TRUE.
3597: IF FND_API.to_Boolean( p_init_msg_list )
3598: THEN
3599: FND_MSG_PUB.initialize;

Line 3597: IF FND_API.to_Boolean( p_init_msg_list )

3593: SAVEPOINT CHECK_SALES_STAGE_PVT;
3594: -- Initialize API return status to SUCCESS
3595: x_return_status := FND_API.G_RET_STS_SUCCESS;
3596: -- Initialize message list if p_init_msg_list is set to TRUE.
3597: IF FND_API.to_Boolean( p_init_msg_list )
3598: THEN
3599: FND_MSG_PUB.initialize;
3600: END IF;
3601:

Line 3627: x_return_status :=FND_API.G_RET_STS_ERROR;

3623: AS_UTILITY_PVT.Set_Message(
3624: p_module => l_module,
3625: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
3626: p_msg_name => 'AS_STAGE_NOT_SETUP_FOR_METH');
3627: x_return_status :=FND_API.G_RET_STS_ERROR;
3628: END IF;
3629: CLOSE c_first_sales_stage;
3630: END IF;
3631: END IF;

Line 3635: WHEN FND_API.G_EXC_ERROR THEN

3631: END IF;
3632: X_sales_stage_id := l_sales_stage_id;
3633: X_sales_methodology_id := l_sales_methodology_id;
3634: EXCEPTION
3635: WHEN FND_API.G_EXC_ERROR THEN
3636: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3637: P_MODULE => l_module
3638: ,P_API_NAME => L_API_NAME
3639: ,P_PKG_NAME => G_PKG_NAME

Line 3646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3642: ,X_MSG_COUNT => X_MSG_COUNT
3643: ,X_MSG_DATA => X_MSG_DATA
3644: ,X_RETURN_STATUS => X_RETURN_STATUS);
3645:
3646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3647: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3648: P_MODULE => l_module
3649: ,P_API_NAME => L_API_NAME
3650: ,P_PKG_NAME => G_PKG_NAME