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.PV_BG_PARTNER_MATCHING_PUB dependencies on FND_API

Line 60: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

56: -- Standard Start of API savepoint
57: SAVEPOINT START_PARTNER_MATCHING_PVT;
58:
59: -- Standard call to check for call compatibility.
60: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
61: p_api_version_number,
62: l_api_name,
63: G_PKG_NAME)
64: THEN

Line 65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

61: p_api_version_number,
62: l_api_name,
63: G_PKG_NAME)
64: THEN
65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
66: END IF;
67:
68: -- Initialize message list IF p_init_msg_list is set to TRUE.
69: IF FND_API.to_Boolean( p_init_msg_list )

Line 69: IF FND_API.to_Boolean( p_init_msg_list )

65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
66: END IF;
67:
68: -- Initialize message list IF p_init_msg_list is set to TRUE.
69: IF FND_API.to_Boolean( p_init_msg_list )
70: THEN
71: FND_MSG_PUB.initialize;
72: END IF;
73:

Line 81: x_return_status := FND_API.G_RET_STS_SUCCESS;

77: 'PVT:' || l_api_name || ' Start');
78: END IF;
79:
80: -- Initialize API return status to SUCCESS
81: x_return_status := FND_API.G_RET_STS_SUCCESS;
82:
83: --
84: -- Api body
85: --

Line 100: RAISE FND_API.G_EXC_ERROR;

96: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
97: p_token1 => 'PROFILE',
98: p_token1_value => 'USER_ID');
99: END IF;
100: RAISE FND_API.G_EXC_ERROR;
101: END IF;
102:
103: IF (p_validation_level = fnd_api.g_valid_level_full)
104: THEN

Line 103: IF (p_validation_level = fnd_api.g_valid_level_full)

99: END IF;
100: RAISE FND_API.G_EXC_ERROR;
101: END IF;
102:
103: IF (p_validation_level = fnd_api.g_valid_level_full)
104: THEN
105: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
106: p_api_version_number => 2.0
107: ,p_init_msg_list => p_init_msg_list

Line 115: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

111: ,x_msg_count => x_msg_count
112: ,x_msg_data => x_msg_data
113: ,x_sales_member_rec => l_identity_sales_member_rec);
114:
115: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;
118: END IF;
119:

Line 116: RAISE FND_API.G_EXC_ERROR;

112: ,x_msg_data => x_msg_data
113: ,x_sales_member_rec => l_identity_sales_member_rec);
114:
115: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;
118: END IF;
119:
120: -- Start Process :

Line 164: IF l_result <> FND_API.G_RET_STS_SUCCESS AND

160: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
161: 'l_result:' || l_result);
162: END IF;
163:
164: IF l_result <> FND_API.G_RET_STS_SUCCESS AND
165: l_result <> '#NULL'
166: THEN
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: END IF;

Line 167: x_return_status := FND_API.G_RET_STS_ERROR;

163:
164: IF l_result <> FND_API.G_RET_STS_SUCCESS AND
165: l_result <> '#NULL'
166: THEN
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: END IF;
169:
170: --
171: -- END of API body

Line 175: IF FND_API.to_Boolean( p_commit )

171: -- END of API body
172: --
173:
174: -- Standard check for p_commit
175: IF FND_API.to_Boolean( p_commit )
176: THEN
177: COMMIT WORK;
178: END IF;
179:

Line 192: WHEN FND_API.G_EXC_ERROR THEN

188: ( p_count => x_msg_count,
189: p_data => x_msg_data );
190:
191: EXCEPTION
192: WHEN FND_API.G_EXC_ERROR THEN
193: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
194: P_API_NAME => L_API_NAME
195: ,P_PKG_NAME => G_PKG_NAME
196: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

198: ,X_MSG_COUNT => X_MSG_COUNT
199: ,X_MSG_DATA => X_MSG_DATA
200: ,X_RETURN_STATUS => X_RETURN_STATUS);
201:
202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
203: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
204: P_API_NAME => L_API_NAME
205: ,P_PKG_NAME => G_PKG_NAME
206: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 319: result := FND_API.G_RET_STS_SUCCESS;

315: 'Partner_Matching: Start');
316: END IF;
317: IF funcmode = 'RUN'
318: THEN
319: result := FND_API.G_RET_STS_SUCCESS;
320: l_lead_id := wf_engine.GetItemAttrNumber(
321: itemtype => itemtype,
322: itemkey => itemkey,
323: aname => 'LEAD_ID');

Line 405: P_Init_Msg_List => FND_API.G_TRUE,

401:
402: pv_opp_match_pub.Clear_Rules_Cache;
403: pv_opp_match_pub.opportunity_selection(
404: P_Api_Version => 1.0,
405: P_Init_Msg_List => FND_API.G_TRUE,
406: P_Commit => FND_API.G_FALSE,
407: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
408: p_entity_id => l_lead_id,
409: p_entity => 'LEAD',

Line 406: P_Commit => FND_API.G_FALSE,

402: pv_opp_match_pub.Clear_Rules_Cache;
403: pv_opp_match_pub.opportunity_selection(
404: P_Api_Version => 1.0,
405: P_Init_Msg_List => FND_API.G_TRUE,
406: P_Commit => FND_API.G_FALSE,
407: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
408: p_entity_id => l_lead_id,
409: p_entity => 'LEAD',
410: p_user_name => l_user_name,

Line 407: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

403: pv_opp_match_pub.opportunity_selection(
404: P_Api_Version => 1.0,
405: P_Init_Msg_List => FND_API.G_TRUE,
406: P_Commit => FND_API.G_FALSE,
407: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
408: p_entity_id => l_lead_id,
409: p_entity => 'LEAD',
410: p_user_name => l_user_name,
411: p_resource_id => l_identity_salesforce_id,

Line 422: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

418:
419: -- Raise exception when returning from API
420: -- Exception handling will get the last message and set
421: -- it in workflow.
422: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
423: result := FND_API.G_RET_STS_ERROR;
424: RAISE FND_API.G_EXC_ERROR;
425: END IF;
426: IF (AS_DEBUG_LOW_ON) THEN

Line 423: result := FND_API.G_RET_STS_ERROR;

419: -- Raise exception when returning from API
420: -- Exception handling will get the last message and set
421: -- it in workflow.
422: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
423: result := FND_API.G_RET_STS_ERROR;
424: RAISE FND_API.G_EXC_ERROR;
425: END IF;
426: IF (AS_DEBUG_LOW_ON) THEN
427: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 424: RAISE FND_API.G_EXC_ERROR;

420: -- Exception handling will get the last message and set
421: -- it in workflow.
422: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
423: result := FND_API.G_RET_STS_ERROR;
424: RAISE FND_API.G_EXC_ERROR;
425: END IF;
426: IF (AS_DEBUG_LOW_ON) THEN
427: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
428: 'selected_rule_id=' || l_selected_rule_id);

Line 449: RAISE FND_API.G_EXC_ERROR;

445: FND_MSG_PUB.Add;
446: END IF;
447:
448: result := 'COMPLETE';
449: RAISE FND_API.G_EXC_ERROR;
450: END IF;
451:
452: IF l_matched_partner_count = 0
453: THEN

Line 468: RAISE FND_API.G_EXC_ERROR;

464: FND_MSG_PUB.Add;
465: END IF;
466:
467: result := 'COMPLETE';
468: RAISE FND_API.G_EXC_ERROR;
469: END IF;
470: END IF;
471:
472: END IF; -- function mode check

Line 479: WHEN FND_API.G_EXC_ERROR THEN

475: 'Partner_Matching: End');
476: END IF;
477:
478: EXCEPTION
479: WHEN FND_API.G_EXC_ERROR THEN
480:
481: fnd_msg_pub.Count_And_Get(
482: p_encoded => FND_API.G_TRUE
483: ,p_count => l_msg_count

Line 482: p_encoded => FND_API.G_TRUE

478: EXCEPTION
479: WHEN FND_API.G_EXC_ERROR THEN
480:
481: fnd_msg_pub.Count_And_Get(
482: p_encoded => FND_API.G_TRUE
483: ,p_count => l_msg_count
484: ,p_data => l_msg_data);
485:
486: l_msg_data := FND_MSG_PUB.Get(

Line 488: p_encoded => FND_API.G_FALSE);

484: ,p_data => l_msg_data);
485:
486: l_msg_data := FND_MSG_PUB.Get(
487: p_msg_index => FND_MSG_PUB.Count_Msg,
488: p_encoded => FND_API.G_FALSE);
489:
490: IF l_failure_code IS NOT NULL
491: THEN
492: ROLLBACK;

Line 516: ,p_init_msg_list => FND_API.G_FALSE

512: l_lead_workflow_rec.routing_status := 'FAILED_AUTO_ASSIGN';
513:
514: pv_assign_util_pvt.Create_lead_workflow_row
515: (p_api_version_number => 1.0
516: ,p_init_msg_list => FND_API.G_FALSE
517: ,p_commit => FND_API.G_FALSE
518: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
519: ,p_workflow_rec => l_lead_workflow_rec
520: ,x_ItemKey => l_itemKey

Line 517: ,p_commit => FND_API.G_FALSE

513:
514: pv_assign_util_pvt.Create_lead_workflow_row
515: (p_api_version_number => 1.0
516: ,p_init_msg_list => FND_API.G_FALSE
517: ,p_commit => FND_API.G_FALSE
518: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
519: ,p_workflow_rec => l_lead_workflow_rec
520: ,x_ItemKey => l_itemKey
521: ,x_return_status => l_return_status

Line 518: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

514: pv_assign_util_pvt.Create_lead_workflow_row
515: (p_api_version_number => 1.0
516: ,p_init_msg_list => FND_API.G_FALSE
517: ,p_commit => FND_API.G_FALSE
518: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
519: ,p_workflow_rec => l_lead_workflow_rec
520: ,x_ItemKey => l_itemKey
521: ,x_return_status => l_return_status
522: ,x_msg_count => l_msg_count

Line 525: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

521: ,x_return_status => l_return_status
522: ,x_msg_count => l_msg_count
523: ,x_msg_data => l_msg_data);
524:
525: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
526: l_msg_data := FND_MSG_PUB.Get(
527: p_msg_index => FND_MSG_PUB.Count_Msg,
528: p_encoded => FND_API.G_FALSE);
529: result := FND_API.G_RET_STS_ERROR;

Line 528: p_encoded => FND_API.G_FALSE);

524:
525: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
526: l_msg_data := FND_MSG_PUB.Get(
527: p_msg_index => FND_MSG_PUB.Count_Msg,
528: p_encoded => FND_API.G_FALSE);
529: result := FND_API.G_RET_STS_ERROR;
530: wf_core.token('STACK',l_msg_data);
531: wf_core.raise('WFNTF_ERROR_STACK');
532: wf_core.context(G_PKG_NAME, l_api_name, l_msg_data);

Line 529: result := FND_API.G_RET_STS_ERROR;

525: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
526: l_msg_data := FND_MSG_PUB.Get(
527: p_msg_index => FND_MSG_PUB.Count_Msg,
528: p_encoded => FND_API.G_FALSE);
529: result := FND_API.G_RET_STS_ERROR;
530: wf_core.token('STACK',l_msg_data);
531: wf_core.raise('WFNTF_ERROR_STACK');
532: wf_core.context(G_PKG_NAME, l_api_name, l_msg_data);
533: RAISE;

Line 572: IF l_sales_team_rec.sales_group_id = FND_API.G_MISS_NUM

568: OPEN c_get_group_id(l_Sales_Team_Rec.salesforce_id);
569: FETCH c_get_group_id INTO l_sales_team_rec.sales_group_id;
570: CLOSE c_get_group_id;
571:
572: IF l_sales_team_rec.sales_group_id = FND_API.G_MISS_NUM
573: THEN
574: l_sales_team_rec.sales_group_id := NULL;
575: END IF;
576:

Line 603: ,p_init_msg_list => FND_API.G_FALSE

599: 'Calling Create_SalesTeam');
600: END IF;
601: AS_ACCESS_PUB.Create_SalesTeam (
602: p_api_version_number => 2.0
603: ,p_init_msg_list => FND_API.G_FALSE
604: ,p_commit => FND_API.G_FALSE
605: ,p_validation_level => FND_API.G_VALID_LEVEL_NONE
606: ,p_access_profile_rec => l_access_profile_rec
607: ,p_check_access_flag => 'N' -- P_Check_Access_flag

Line 604: ,p_commit => FND_API.G_FALSE

600: END IF;
601: AS_ACCESS_PUB.Create_SalesTeam (
602: p_api_version_number => 2.0
603: ,p_init_msg_list => FND_API.G_FALSE
604: ,p_commit => FND_API.G_FALSE
605: ,p_validation_level => FND_API.G_VALID_LEVEL_NONE
606: ,p_access_profile_rec => l_access_profile_rec
607: ,p_check_access_flag => 'N' -- P_Check_Access_flag
608: ,p_admin_flag => 'N'

Line 605: ,p_validation_level => FND_API.G_VALID_LEVEL_NONE

601: AS_ACCESS_PUB.Create_SalesTeam (
602: p_api_version_number => 2.0
603: ,p_init_msg_list => FND_API.G_FALSE
604: ,p_commit => FND_API.G_FALSE
605: ,p_validation_level => FND_API.G_VALID_LEVEL_NONE
606: ,p_access_profile_rec => l_access_profile_rec
607: ,p_check_access_flag => 'N' -- P_Check_Access_flag
608: ,p_admin_flag => 'N'
609: ,p_admin_group_id => NULL

Line 618: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

614: ,X_Msg_Data => l_Msg_Data2
615: ,x_access_id => l_Access_Id
616: );
617:
618: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
619: l_msg_data := FND_MSG_PUB.Get(
620: p_msg_index => FND_MSG_PUB.Count_Msg,
621: p_encoded => FND_API.G_FALSE);
622: result := FND_API.G_RET_STS_ERROR;

Line 621: p_encoded => FND_API.G_FALSE);

617:
618: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
619: l_msg_data := FND_MSG_PUB.Get(
620: p_msg_index => FND_MSG_PUB.Count_Msg,
621: p_encoded => FND_API.G_FALSE);
622: result := FND_API.G_RET_STS_ERROR;
623: wf_core.token('STACK',l_msg_data);
624:
625: -- this is what makes the workflow result turn RED!

Line 622: result := FND_API.G_RET_STS_ERROR;

618: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
619: l_msg_data := FND_MSG_PUB.Get(
620: p_msg_index => FND_MSG_PUB.Count_Msg,
621: p_encoded => FND_API.G_FALSE);
622: result := FND_API.G_RET_STS_ERROR;
623: wf_core.token('STACK',l_msg_data);
624:
625: -- this is what makes the workflow result turn RED!
626: wf_core.raise('WFNTF_ERROR_STACK');

Line 639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

635: 'Create_SalesTeam:l_access_id = ' || l_access_id);
636: END IF;
637: END IF;
638:
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
640:
641: fnd_msg_pub.Count_And_Get(
642: p_encoded => FND_API.G_TRUE
643: ,p_count => l_msg_count

Line 642: p_encoded => FND_API.G_TRUE

638:
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
640:
641: fnd_msg_pub.Count_And_Get(
642: p_encoded => FND_API.G_TRUE
643: ,p_count => l_msg_count
644: ,p_data => l_msg_data);
645:
646: l_msg_data := FND_MSG_PUB.Get(

Line 648: p_encoded => FND_API.G_FALSE);

644: ,p_data => l_msg_data);
645:
646: l_msg_data := FND_MSG_PUB.Get(
647: p_msg_index => FND_MSG_PUB.Count_Msg,
648: p_encoded => FND_API.G_FALSE);
649: wf_core.token('STACK',l_msg_data);
650: wf_core.raise('WFNTF_ERROR_STACK');
651:
652: wf_core.context(G_PKG_NAME, l_api_name,l_msg_data);

Line 658: p_encoded => FND_API.G_TRUE

654:
655: WHEN OTHERS THEN
656:
657: fnd_msg_pub.Count_And_Get(
658: p_encoded => FND_API.G_TRUE
659: ,p_count => l_msg_count
660: ,p_data => l_msg_data);
661:
662: wf_core.token('STACK', SQLERRM);

Line 704: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

700: BEGIN
701: SAVEPOINT Start_Campaign_Assignment;
702:
703: -- Standard call to check for call compatibility.
704: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
705: p_api_version_number,
706: l_api_name,
707: G_PKG_NAME)
708: THEN

Line 709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

705: p_api_version_number,
706: l_api_name,
707: G_PKG_NAME)
708: THEN
709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
710: END IF;
711:
712: -- Initialize message list IF p_init_msg_list is set to TRUE.
713: IF FND_API.to_Boolean( p_init_msg_list )

Line 713: IF FND_API.to_Boolean( p_init_msg_list )

709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
710: END IF;
711:
712: -- Initialize message list IF p_init_msg_list is set to TRUE.
713: IF FND_API.to_Boolean( p_init_msg_list )
714: THEN
715: FND_MSG_PUB.initialize;
716: END IF;
717:

Line 725: x_return_status := FND_API.G_RET_STS_SUCCESS;

721: 'PVT:' || l_api_name || ' Start');
722: END IF;
723:
724: -- Initialize API return status to SUCCESS
725: x_return_status := FND_API.G_RET_STS_SUCCESS;
726:
727: --
728: -- Api body
729: --

Line 744: RAISE FND_API.G_EXC_ERROR;

740: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
741: p_token1 => 'PROFILE',
742: p_token1_value => 'USER_ID');
743: END IF;
744: RAISE FND_API.G_EXC_ERROR;
745: END IF;
746:
747: -- Start Process :
748: -- If workflowprocess is passed, it will be run.

Line 788: IF l_result <> FND_API.G_RET_STS_SUCCESS AND l_result <> '#NULL'

784: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_status:' || l_status);
785: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_result:' || l_result);
786: END IF;
787:
788: IF l_result <> FND_API.G_RET_STS_SUCCESS AND l_result <> '#NULL'
789: THEN
790: x_return_status := FND_API.G_RET_STS_ERROR;
791: END IF;
792:

Line 790: x_return_status := FND_API.G_RET_STS_ERROR;

786: END IF;
787:
788: IF l_result <> FND_API.G_RET_STS_SUCCESS AND l_result <> '#NULL'
789: THEN
790: x_return_status := FND_API.G_RET_STS_ERROR;
791: END IF;
792:
793: -- Standard check for p_commit
794: IF FND_API.to_Boolean( p_commit )

Line 794: IF FND_API.to_Boolean( p_commit )

790: x_return_status := FND_API.G_RET_STS_ERROR;
791: END IF;
792:
793: -- Standard check for p_commit
794: IF FND_API.to_Boolean( p_commit )
795: THEN
796: COMMIT WORK;
797: END IF;
798:

Line 811: WHEN FND_API.G_EXC_ERROR THEN

807: ( p_count => x_msg_count,
808: p_data => x_msg_data );
809:
810: EXCEPTION
811: WHEN FND_API.G_EXC_ERROR THEN
812: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
813: P_API_NAME => L_API_NAME
814: ,P_PKG_NAME => G_PKG_NAME
815: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

817: ,X_MSG_COUNT => X_MSG_COUNT
818: ,X_MSG_DATA => X_MSG_DATA
819: ,X_RETURN_STATUS => X_RETURN_STATUS);
820:
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
822: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
823: P_API_NAME => L_API_NAME
824: ,P_PKG_NAME => G_PKG_NAME
825: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 936: result := FND_API.G_RET_STS_SUCCESS;

932: IF (AS_DEBUG_LOW_ON) THEN
933: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Campaign_Routing: Start');
934: END IF;
935:
936: result := FND_API.G_RET_STS_SUCCESS;
937: l_lead_id := wf_engine.GetItemAttrNumber(
938: itemtype => itemtype,
939: itemkey => itemkey,
940: aname => 'LEAD_ID');

Line 1063: ,p_init_msg_list => FND_API.G_FALSE

1059: END IF;
1060:
1061: PV_ASSIGNMENT_PUB.CreateAssignment
1062: (p_api_version_number => 1.0
1063: ,p_init_msg_list => FND_API.G_FALSE
1064: ,p_commit => FND_API.G_FALSE
1065: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1066: ,p_entity => 'OPPORTUNITY'
1067: ,p_lead_id => l_lead_id

Line 1064: ,p_commit => FND_API.G_FALSE

1060:
1061: PV_ASSIGNMENT_PUB.CreateAssignment
1062: (p_api_version_number => 1.0
1063: ,p_init_msg_list => FND_API.G_FALSE
1064: ,p_commit => FND_API.G_FALSE
1065: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1066: ,p_entity => 'OPPORTUNITY'
1067: ,p_lead_id => l_lead_id
1068: ,p_creating_username => l_user_name

Line 1065: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1061: PV_ASSIGNMENT_PUB.CreateAssignment
1062: (p_api_version_number => 1.0
1063: ,p_init_msg_list => FND_API.G_FALSE
1064: ,p_commit => FND_API.G_FALSE
1065: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1066: ,p_entity => 'OPPORTUNITY'
1067: ,p_lead_id => l_lead_id
1068: ,p_creating_username => l_user_name
1069: ,p_assignment_type => l_assignment_type

Line 1079: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1075: ,x_return_status => l_return_status
1076: ,x_msg_count => l_msg_count
1077: ,x_msg_data => l_msg_data);
1078:
1079: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1080: l_failure_code := 'ROUTING_FAILED';
1081: RAISE FND_API.G_EXC_ERROR;
1082: END IF;
1083:

Line 1081: RAISE FND_API.G_EXC_ERROR;

1077: ,x_msg_data => l_msg_data);
1078:
1079: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1080: l_failure_code := 'ROUTING_FAILED';
1081: RAISE FND_API.G_EXC_ERROR;
1082: END IF;
1083:
1084: ELSE
1085:

Line 1109: ,p_init_msg_list => FND_API.G_FALSE

1105: l_access_profile_rec := null;
1106:
1107: as_access_pub.Create_SalesTeam
1108: (p_api_version_number => 2 -- API Version has been changed
1109: ,p_init_msg_list => FND_API.G_FALSE
1110: ,p_commit => FND_API.G_FALSE
1111: ,p_validation_level => FND_API.G_VALID_LEVEL_NONE
1112: ,p_access_profile_rec => l_access_profile_rec
1113: ,p_check_access_flag => 'N'

Line 1110: ,p_commit => FND_API.G_FALSE

1106:
1107: as_access_pub.Create_SalesTeam
1108: (p_api_version_number => 2 -- API Version has been changed
1109: ,p_init_msg_list => FND_API.G_FALSE
1110: ,p_commit => FND_API.G_FALSE
1111: ,p_validation_level => FND_API.G_VALID_LEVEL_NONE
1112: ,p_access_profile_rec => l_access_profile_rec
1113: ,p_check_access_flag => 'N'
1114: ,p_admin_flag => 'N'

Line 1111: ,p_validation_level => FND_API.G_VALID_LEVEL_NONE

1107: as_access_pub.Create_SalesTeam
1108: (p_api_version_number => 2 -- API Version has been changed
1109: ,p_init_msg_list => FND_API.G_FALSE
1110: ,p_commit => FND_API.G_FALSE
1111: ,p_validation_level => FND_API.G_VALID_LEVEL_NONE
1112: ,p_access_profile_rec => l_access_profile_rec
1113: ,p_check_access_flag => 'N'
1114: ,p_admin_flag => 'N'
1115: ,p_admin_group_id => null

Line 1123: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1119: ,x_msg_count => l_msg_count
1120: ,x_msg_data => l_msg_data
1121: ,x_access_id => l_access_id);
1122:
1123: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1124: l_failure_code := 'OTHER';
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1126: END IF;
1127:

Line 1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1121: ,x_access_id => l_access_id);
1122:
1123: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1124: l_failure_code := 'OTHER';
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1126: END IF;
1127:
1128: END LOOP;
1129:

Line 1136: WHEN FND_API.G_EXC_ERROR THEN

1132: result := 'COMPLETE';
1133: END IF; -- function mode check
1134:
1135: EXCEPTION
1136: WHEN FND_API.G_EXC_ERROR THEN
1137:
1138: fnd_msg_pub.Count_And_Get(
1139: p_encoded => FND_API.G_TRUE
1140: ,p_count => l_msg_count

Line 1139: p_encoded => FND_API.G_TRUE

1135: EXCEPTION
1136: WHEN FND_API.G_EXC_ERROR THEN
1137:
1138: fnd_msg_pub.Count_And_Get(
1139: p_encoded => FND_API.G_TRUE
1140: ,p_count => l_msg_count
1141: ,p_data => l_msg_data);
1142:
1143: l_msg_data := FND_MSG_PUB.Get(

Line 1145: p_encoded => FND_API.G_FALSE);

1141: ,p_data => l_msg_data);
1142:
1143: l_msg_data := FND_MSG_PUB.Get(
1144: p_msg_index => FND_MSG_PUB.Count_Msg,
1145: p_encoded => FND_API.G_FALSE);
1146:
1147: ROLLBACK;
1148:
1149: IF (FND_PROFILE.value('PV_AUTO_ROUTE_FOR_CAMPAIGN') = 'Y') THEN

Line 1168: ,p_init_msg_list => FND_API.G_FALSE

1164: l_lead_workflow_rec.routing_status := 'FAILED_AUTO_ASSIGN';
1165:
1166: pv_assign_util_pvt.Create_lead_workflow_row
1167: (p_api_version_number => 1.0
1168: ,p_init_msg_list => FND_API.G_FALSE
1169: ,p_commit => FND_API.G_FALSE
1170: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1171: ,p_workflow_rec => l_lead_workflow_rec
1172: ,x_ItemKey => l_itemKey

Line 1169: ,p_commit => FND_API.G_FALSE

1165:
1166: pv_assign_util_pvt.Create_lead_workflow_row
1167: (p_api_version_number => 1.0
1168: ,p_init_msg_list => FND_API.G_FALSE
1169: ,p_commit => FND_API.G_FALSE
1170: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1171: ,p_workflow_rec => l_lead_workflow_rec
1172: ,x_ItemKey => l_itemKey
1173: ,x_return_status => l_return_status

Line 1170: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1166: pv_assign_util_pvt.Create_lead_workflow_row
1167: (p_api_version_number => 1.0
1168: ,p_init_msg_list => FND_API.G_FALSE
1169: ,p_commit => FND_API.G_FALSE
1170: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1171: ,p_workflow_rec => l_lead_workflow_rec
1172: ,x_ItemKey => l_itemKey
1173: ,x_return_status => l_return_status
1174: ,x_msg_count => l_msg_count

Line 1177: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1173: ,x_return_status => l_return_status
1174: ,x_msg_count => l_msg_count
1175: ,x_msg_data => l_msg_data);
1176:
1177: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1178: l_msg_data := FND_MSG_PUB.Get(
1179: p_msg_index => FND_MSG_PUB.Count_Msg,
1180: p_encoded => FND_API.G_FALSE);
1181: result := FND_API.G_RET_STS_ERROR;

Line 1180: p_encoded => FND_API.G_FALSE);

1176:
1177: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1178: l_msg_data := FND_MSG_PUB.Get(
1179: p_msg_index => FND_MSG_PUB.Count_Msg,
1180: p_encoded => FND_API.G_FALSE);
1181: result := FND_API.G_RET_STS_ERROR;
1182: wf_core.token('STACK',l_msg_data);
1183: wf_core.raise('WFNTF_ERROR_STACK');
1184: wf_core.context(G_PKG_NAME, l_api_name, l_msg_data);

Line 1181: result := FND_API.G_RET_STS_ERROR;

1177: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1178: l_msg_data := FND_MSG_PUB.Get(
1179: p_msg_index => FND_MSG_PUB.Count_Msg,
1180: p_encoded => FND_API.G_FALSE);
1181: result := FND_API.G_RET_STS_ERROR;
1182: wf_core.token('STACK',l_msg_data);
1183: wf_core.raise('WFNTF_ERROR_STACK');
1184: wf_core.context(G_PKG_NAME, l_api_name, l_msg_data);
1185: RAISE;

Line 1217: IF l_sales_team_rec.sales_group_id = FND_API.G_MISS_NUM

1213: OPEN c_get_group_id(l_Sales_Team_Rec.salesforce_id);
1214: FETCH c_get_group_id INTO l_sales_team_rec.sales_group_id;
1215: CLOSE c_get_group_id;
1216:
1217: IF l_sales_team_rec.sales_group_id = FND_API.G_MISS_NUM
1218: THEN
1219: l_sales_team_rec.sales_group_id := NULL;
1220: END IF;
1221:

Line 1243: ,p_init_msg_list => FND_API.G_FALSE

1239: 'Calling Create_SalesTeam');
1240: END IF;
1241: AS_ACCESS_PUB.Create_SalesTeam (
1242: p_api_version_number => 2.0
1243: ,p_init_msg_list => FND_API.G_FALSE
1244: ,p_commit => FND_API.G_FALSE
1245: ,p_validation_level => FND_API.G_VALID_LEVEL_NONE
1246: ,p_access_profile_rec => l_access_profile_rec
1247: ,p_check_access_flag => 'N' -- P_Check_Access_flag

Line 1244: ,p_commit => FND_API.G_FALSE

1240: END IF;
1241: AS_ACCESS_PUB.Create_SalesTeam (
1242: p_api_version_number => 2.0
1243: ,p_init_msg_list => FND_API.G_FALSE
1244: ,p_commit => FND_API.G_FALSE
1245: ,p_validation_level => FND_API.G_VALID_LEVEL_NONE
1246: ,p_access_profile_rec => l_access_profile_rec
1247: ,p_check_access_flag => 'N' -- P_Check_Access_flag
1248: ,p_admin_flag => 'N'

Line 1245: ,p_validation_level => FND_API.G_VALID_LEVEL_NONE

1241: AS_ACCESS_PUB.Create_SalesTeam (
1242: p_api_version_number => 2.0
1243: ,p_init_msg_list => FND_API.G_FALSE
1244: ,p_commit => FND_API.G_FALSE
1245: ,p_validation_level => FND_API.G_VALID_LEVEL_NONE
1246: ,p_access_profile_rec => l_access_profile_rec
1247: ,p_check_access_flag => 'N' -- P_Check_Access_flag
1248: ,p_admin_flag => 'N'
1249: ,p_admin_group_id => NULL

Line 1258: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1254: ,X_Msg_Data => l_Msg_Data2
1255: ,x_access_id => l_Access_Id
1256: );
1257:
1258: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1259: l_msg_data := FND_MSG_PUB.Get(
1260: p_msg_index => FND_MSG_PUB.Count_Msg,
1261: p_encoded => FND_API.G_FALSE);
1262: result := FND_API.G_RET_STS_ERROR;

Line 1261: p_encoded => FND_API.G_FALSE);

1257:
1258: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1259: l_msg_data := FND_MSG_PUB.Get(
1260: p_msg_index => FND_MSG_PUB.Count_Msg,
1261: p_encoded => FND_API.G_FALSE);
1262: result := FND_API.G_RET_STS_ERROR;
1263: wf_core.token('STACK',l_msg_data);
1264:
1265: -- this is what makes the workflow result turn RED!

Line 1262: result := FND_API.G_RET_STS_ERROR;

1258: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1259: l_msg_data := FND_MSG_PUB.Get(
1260: p_msg_index => FND_MSG_PUB.Count_Msg,
1261: p_encoded => FND_API.G_FALSE);
1262: result := FND_API.G_RET_STS_ERROR;
1263: wf_core.token('STACK',l_msg_data);
1264:
1265: -- this is what makes the workflow result turn RED!
1266: wf_core.raise('WFNTF_ERROR_STACK');

Line 1280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1276: END IF;
1277: END IF;
1278: END IF;
1279:
1280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1281:
1282: fnd_msg_pub.Count_And_Get(
1283: p_encoded => FND_API.G_TRUE
1284: ,p_count => l_msg_count

Line 1283: p_encoded => FND_API.G_TRUE

1279:
1280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1281:
1282: fnd_msg_pub.Count_And_Get(
1283: p_encoded => FND_API.G_TRUE
1284: ,p_count => l_msg_count
1285: ,p_data => l_msg_data);
1286:
1287: l_msg_data := FND_MSG_PUB.Get(

Line 1289: p_encoded => FND_API.G_FALSE);

1285: ,p_data => l_msg_data);
1286:
1287: l_msg_data := FND_MSG_PUB.Get(
1288: p_msg_index => FND_MSG_PUB.Count_Msg,
1289: p_encoded => FND_API.G_FALSE);
1290: wf_core.token('STACK',l_msg_data);
1291: wf_core.raise('WFNTF_ERROR_STACK');
1292:
1293: wf_core.context(G_PKG_NAME, l_api_name,l_msg_data);

Line 1299: p_encoded => FND_API.G_TRUE

1295:
1296: WHEN OTHERS THEN
1297:
1298: fnd_msg_pub.Count_And_Get(
1299: p_encoded => FND_API.G_TRUE
1300: ,p_count => l_msg_count
1301: ,p_data => l_msg_data);
1302:
1303: wf_core.token('STACK', SQLERRM);