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_MSG_PUB

Line 27: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

23: |
24: | PRIVATE VARIABLES
25: |
26: *-------------------------------------------------------------------------*/
27: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
28: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
29: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
30: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
31:

Line 28: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

24: | PRIVATE VARIABLES
25: |
26: *-------------------------------------------------------------------------*/
27: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
28: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
29: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
30: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
31:
32:

Line 29: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

25: |
26: *-------------------------------------------------------------------------*/
27: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
28: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
29: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
30: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
31:
32:
33: PROCEDURE Start_Partner_Matching(

Line 30: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);

26: *-------------------------------------------------------------------------*/
27: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
28: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
29: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
30: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
31:
32:
33: PROCEDURE Start_Partner_Matching(
34: P_Api_Version_Number IN NUMBER,

Line 71: FND_MSG_PUB.initialize;

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:
74: -- Debug Message
75: IF (AS_DEBUG_LOW_ON) THEN

Line 76: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

72: END IF;
73:
74: -- Debug Message
75: IF (AS_DEBUG_LOW_ON) THEN
76: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
77: 'PVT:' || l_api_name || ' Start');
78: END IF;
79:
80: -- Initialize API return status to SUCCESS

Line 92: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

88: -- ******************************************************************
89:
90: IF FND_GLOBAL.User_Id IS NULL
91: THEN
92: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
93: THEN
94: AS_UTILITY_PVT.Set_Message(
95: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
96: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',

Line 95: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

91: THEN
92: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
93: THEN
94: AS_UTILITY_PVT.Set_Message(
95: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
96: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
97: p_token1 => 'PROFILE',
98: p_token1_value => 'USER_ID');
99: END IF;

Line 158: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

154: status => l_status,
155: result => l_result);
156:
157: IF (AS_DEBUG_LOW_ON) THEN
158: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
159: 'l_status:' || l_status);
160: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
161: 'l_result:' || l_result);
162: END IF;

Line 160: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

156:
157: IF (AS_DEBUG_LOW_ON) THEN
158: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
159: 'l_status:' || l_status);
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

Line 182: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

178: END IF;
179:
180: -- Debug Message
181: IF (AS_DEBUG_LOW_ON) THEN
182: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
183: 'PVT: ' || l_api_name || ' End');
184: END IF;
185:
186: -- Standard call to get message count and IF count is 1, get message info.

Line 187: FND_MSG_PUB.Count_And_Get

183: 'PVT: ' || l_api_name || ' End');
184: END IF;
185:
186: -- Standard call to get message count and IF count is 1, get message info.
187: FND_MSG_PUB.Count_And_Get
188: ( p_count => x_msg_count,
189: p_data => x_msg_data );
190:
191: EXCEPTION

Line 196: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
197: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
198: ,X_MSG_COUNT => X_MSG_COUNT
199: ,X_MSG_DATA => X_MSG_DATA
200: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 206: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
207: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
208: ,X_MSG_COUNT => X_MSG_COUNT
209: ,X_MSG_DATA => X_MSG_DATA
210: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 314: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

310: WHERE salesforce_id = c_salesforce_id;
311:
312: BEGIN
313: IF (AS_DEBUG_LOW_ON) THEN
314: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
315: 'Partner_Matching: Start');
316: END IF;
317: IF funcmode = 'RUN'
318: THEN

Line 337: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

333: aname => 'SALESGROUP_ID');
334:
335:
336: IF (AS_DEBUG_LOW_ON) THEN
337: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
338: 'lead_id?' || l_lead_id);
339: END IF;
340:
341: -- ==========================================================================

Line 371: fnd_msg_pub.ADD;

367: FOR x IN (SELECT description FROM as_leads_all WHERE lead_id = l_lead_id) LOOP
368: fnd_message.SET_NAME('PV', 'PV_OPP_ROUTING_CLOSED_OPP');
369: fnd_message.SET_TOKEN('OPPORTUNITY_NAME', x.description);
370: fnd_message.SET_TOKEN('LEAD_ID' , l_lead_id);
371: fnd_msg_pub.ADD;
372: END LOOP;
373: END IF;
374:
375: -- -----------------------------------------------------------------------

Line 383: fnd_msg_pub.ADD;

379: FOR x IN (SELECT description FROM as_leads_all WHERE lead_id = l_lead_id) LOOP
380: fnd_message.SET_NAME('PV', 'PV_OPP_ROUTING_ALREADY_EXISTS');
381: fnd_message.SET_TOKEN('OPPORTUNITY_NAME', x.description);
382: fnd_message.SET_TOKEN('LEAD_ID' , l_lead_id);
383: fnd_msg_pub.ADD;
384: END LOOP;
385:
386: l_routing_exist_flag := TRUE;
387: END IF;

Line 427: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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);
429: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
430: 'matched_partner_count=' || l_matched_partner_count);
431: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 429: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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);
429: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
430: 'matched_partner_count=' || l_matched_partner_count);
431: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
432: 'failure_code=' || l_failure_code);
433: END IF;

Line 431: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

427: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
428: 'selected_rule_id=' || l_selected_rule_id);
429: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
430: 'matched_partner_count=' || l_matched_partner_count);
431: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
432: 'failure_code=' || l_failure_code);
433: END IF;
434:
435: IF l_selected_rule_id IS NULL

Line 441: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

437: OPEN c_get_lead_name(l_lead_id);
438: FETCH c_get_lead_name INTO l_lead_name;
439: CLOSE c_get_lead_name;
440:
441: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
442: THEN
443: FND_MESSAGE.Set_Name('PV', 'PV_OPP_NOT_MATCH_RULE');
444: FND_MESSAGE.Set_Token('LEAD_NAME', l_lead_name);
445: FND_MSG_PUB.Add;

Line 445: FND_MSG_PUB.Add;

441: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
442: THEN
443: FND_MESSAGE.Set_Name('PV', 'PV_OPP_NOT_MATCH_RULE');
444: FND_MESSAGE.Set_Token('LEAD_NAME', l_lead_name);
445: FND_MSG_PUB.Add;
446: END IF;
447:
448: result := 'COMPLETE';
449: RAISE FND_API.G_EXC_ERROR;

Line 459: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

455: FETCH c_get_lead_rule_name INTO l_lead_name,
456: l_process_rule_name;
457: CLOSE c_get_lead_rule_name;
458:
459: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
460: THEN
461: FND_MESSAGE.Set_Name('PV', 'PV_OPP_NOT_MATCH_PARTNER');
462: FND_MESSAGE.Set_Token('LEAD_NAME', l_lead_name);
463: FND_MESSAGE.Set_Token('RULE_NAME', l_process_rule_name);

Line 464: FND_MSG_PUB.Add;

460: THEN
461: FND_MESSAGE.Set_Name('PV', 'PV_OPP_NOT_MATCH_PARTNER');
462: FND_MESSAGE.Set_Token('LEAD_NAME', l_lead_name);
463: FND_MESSAGE.Set_Token('RULE_NAME', l_process_rule_name);
464: FND_MSG_PUB.Add;
465: END IF;
466:
467: result := 'COMPLETE';
468: RAISE FND_API.G_EXC_ERROR;

Line 474: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

470: END IF;
471:
472: END IF; -- function mode check
473: IF (AS_DEBUG_LOW_ON) THEN
474: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
475: 'Partner_Matching: End');
476: END IF;
477:
478: EXCEPTION

Line 481: fnd_msg_pub.Count_And_Get(

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
484: ,p_data => l_msg_data);
485:

Line 486: l_msg_data := FND_MSG_PUB.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(
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

Line 487: p_msg_index => FND_MSG_PUB.Count_Msg,

483: ,p_count => l_msg_count
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

Line 526: l_msg_data := FND_MSG_PUB.Get(

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;
530: wf_core.token('STACK',l_msg_data);

Line 527: p_msg_index => FND_MSG_PUB.Count_Msg,

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;
530: wf_core.token('STACK',l_msg_data);
531: wf_core.raise('WFNTF_ERROR_STACK');

Line 537: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

533: RAISE;
534: END IF;
535:
536: IF (AS_DEBUG_LOW_ON) THEN
537: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
538: 'lwf rt status = ' || l_Return_Status);
539: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
540: 'itemKey = ' || l_itemKey);
541: END IF;

Line 539: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

535:
536: IF (AS_DEBUG_LOW_ON) THEN
537: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
538: 'lwf rt status = ' || l_Return_Status);
539: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
540: 'itemKey = ' || l_itemKey);
541: END IF;
542: OPEN c_get_lead_info(l_lead_id);
543: FETCH c_get_lead_info INTO l_Sales_Team_Rec.customer_id,

Line 594: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

590: l_Sales_Team_Rec.created_by_TAP_flag := 'N';
591: l_sales_team_rec.owner_flag := 'N';
592:
593: IF (AS_DEBUG_LOW_ON) THEN
594: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
595: 'sf_id=' || l_Sales_Team_Rec.salesforce_id);
596: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
597: 'sg_id=' || l_Sales_Team_Rec.sales_group_id);
598: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 596: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

592:
593: IF (AS_DEBUG_LOW_ON) THEN
594: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
595: 'sf_id=' || l_Sales_Team_Rec.salesforce_id);
596: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
597: 'sg_id=' || l_Sales_Team_Rec.sales_group_id);
598: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
599: 'Calling Create_SalesTeam');
600: END IF;

Line 598: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

594: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
595: 'sf_id=' || l_Sales_Team_Rec.salesforce_id);
596: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
597: 'sg_id=' || l_Sales_Team_Rec.sales_group_id);
598: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
599: 'Calling Create_SalesTeam');
600: END IF;
601: AS_ACCESS_PUB.Create_SalesTeam (
602: p_api_version_number => 2.0

Line 619: l_msg_data := FND_MSG_PUB.Get(

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;
623: wf_core.token('STACK',l_msg_data);

Line 620: p_msg_index => FND_MSG_PUB.Count_Msg,

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;
623: wf_core.token('STACK',l_msg_data);
624:

Line 632: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

628: RAISE;
629: END IF;
630:
631: IF (AS_DEBUG_LOW_ON) THEN
632: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
633: 'acc rt status = ' || l_Return_Status);
634: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
635: 'Create_SalesTeam:l_access_id = ' || l_access_id);
636: END IF;

Line 634: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

630:
631: IF (AS_DEBUG_LOW_ON) THEN
632: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
633: 'acc rt status = ' || l_Return_Status);
634: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
635: 'Create_SalesTeam:l_access_id = ' || l_access_id);
636: END IF;
637: END IF;
638:

Line 641: fnd_msg_pub.Count_And_Get(

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
644: ,p_data => l_msg_data);
645:

Line 646: l_msg_data := FND_MSG_PUB.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(
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');

Line 647: p_msg_index => FND_MSG_PUB.Count_Msg,

643: ,p_count => l_msg_count
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:

Line 657: fnd_msg_pub.Count_And_Get(

653: raise;
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:

Line 715: FND_MSG_PUB.initialize;

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:
718: -- Debug Message
719: IF (AS_DEBUG_LOW_ON) THEN

Line 720: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

716: END IF;
717:
718: -- Debug Message
719: IF (AS_DEBUG_LOW_ON) THEN
720: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
721: 'PVT:' || l_api_name || ' Start');
722: END IF;
723:
724: -- Initialize API return status to SUCCESS

Line 736: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

732: -- ******************************************************************
733:
734: IF FND_GLOBAL.User_Id IS NULL
735: THEN
736: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
737: THEN
738: AS_UTILITY_PVT.Set_Message(
739: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
740: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',

Line 739: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

735: THEN
736: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
737: THEN
738: AS_UTILITY_PVT.Set_Message(
739: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
740: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
741: p_token1 => 'PROFILE',
742: p_token1_value => 'USER_ID');
743: END IF;

Line 784: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_status:' || l_status);

780: status => l_status,
781: result => l_result);
782: END IF;
783: IF (AS_DEBUG_LOW_ON) THEN
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'

Line 785: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_result:' || l_result);

781: result => l_result);
782: END IF;
783: IF (AS_DEBUG_LOW_ON) THEN
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

Line 801: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

797: END IF;
798:
799: -- Debug Message
800: IF (AS_DEBUG_LOW_ON) THEN
801: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
802: 'PVT: ' || l_api_name || ' End');
803: END IF;
804:
805: -- Standard call to get message count and IF count is 1, get message info.

Line 806: FND_MSG_PUB.Count_And_Get

802: 'PVT: ' || l_api_name || ' End');
803: END IF;
804:
805: -- Standard call to get message count and IF count is 1, get message info.
806: FND_MSG_PUB.Count_And_Get
807: ( p_count => x_msg_count,
808: p_data => x_msg_data );
809:
810: EXCEPTION

Line 815: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
816: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
817: ,X_MSG_COUNT => X_MSG_COUNT
818: ,X_MSG_DATA => X_MSG_DATA
819: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 825: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
826: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
827: ,X_MSG_COUNT => X_MSG_COUNT
828: ,X_MSG_DATA => X_MSG_DATA
829: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 933: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Campaign_Routing: Start');

929: BEGIN
930: IF funcmode = 'RUN' THEN
931:
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(

Line 974: fnd_msg_pub.ADD;

970: FOR x IN (SELECT description FROM as_leads_all WHERE lead_id = l_lead_id) LOOP
971: fnd_message.SET_NAME('PV', 'PV_OPP_ROUTING_CLOSED_OPP');
972: fnd_message.SET_TOKEN('OPPORTUNITY_NAME', x.description);
973: fnd_message.SET_TOKEN('LEAD_ID' , l_lead_id);
974: fnd_msg_pub.ADD;
975: END LOOP;
976: END IF;
977:
978: -- -----------------------------------------------------------------------

Line 986: fnd_msg_pub.ADD;

982: FOR x IN (SELECT description FROM as_leads_all WHERE lead_id = l_lead_id) LOOP
983: fnd_message.SET_NAME('PV', 'PV_OPP_ROUTING_ALREADY_EXISTS');
984: fnd_message.SET_TOKEN('OPPORTUNITY_NAME', x.description);
985: fnd_message.SET_TOKEN('LEAD_ID' , l_lead_id);
986: fnd_msg_pub.ADD;
987: END LOOP;
988:
989: l_routing_exist_flag := TRUE;
990: END IF;

Line 1002: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

998: -- --------------------------------------------------------------------
999: IF (l_open_opportunity_flag AND (NOT l_routing_exist_flag)) THEN
1000:
1001: IF (AS_DEBUG_LOW_ON) THEN
1002: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1003: 'This is an open oppty and is not being routed');
1004: END IF;
1005:
1006: OPEN c_get_user_name(l_identity_salesforce_id);

Line 1037: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1033:
1034: end if;
1035:
1036: IF (AS_DEBUG_LOW_ON) THEN
1037: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1038: 'Number of partners attach to campaign: ' || l_partner_id_tbl.count);
1039: end if;
1040:
1041: if l_partner_id_tbl.count = 0 then

Line 1056: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1052:
1053: IF (FND_PROFILE.value('PV_AUTO_ROUTE_FOR_CAMPAIGN') = 'Y') THEN
1054:
1055: IF (AS_DEBUG_LOW_ON) THEN
1056: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1057: 'Before calling Create Assignment' || l_lead_id || 'user name ' ||
1058: l_user_name || 'assn type ' || l_assignment_type );
1059: END IF;
1060:

Line 1087: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1083:
1084: ELSE
1085:
1086: IF (AS_DEBUG_LOW_ON) THEN
1087: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1088: 'Adding partners to external salesteam');
1089: END IF;
1090:
1091: FOR i in 1 .. l_partner_id_tbl.count LOOP

Line 1138: fnd_msg_pub.Count_And_Get(

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
1141: ,p_data => l_msg_data);
1142:

Line 1143: l_msg_data := FND_MSG_PUB.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(
1144: p_msg_index => FND_MSG_PUB.Count_Msg,
1145: p_encoded => FND_API.G_FALSE);
1146:
1147: ROLLBACK;

Line 1144: p_msg_index => FND_MSG_PUB.Count_Msg,

1140: ,p_count => l_msg_count
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:

Line 1178: l_msg_data := FND_MSG_PUB.Get(

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;
1182: wf_core.token('STACK',l_msg_data);

Line 1179: p_msg_index => FND_MSG_PUB.Count_Msg,

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;
1182: wf_core.token('STACK',l_msg_data);
1183: wf_core.raise('WFNTF_ERROR_STACK');

Line 1189: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1185: RAISE;
1186: END IF;
1187:
1188: IF (AS_DEBUG_LOW_ON) THEN
1189: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1190: 'lwf rt status = ' || l_Return_Status);
1191: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'itemKey = ' || l_itemKey);
1192: END IF;
1193:

Line 1191: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'itemKey = ' || l_itemKey);

1187:
1188: IF (AS_DEBUG_LOW_ON) THEN
1189: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1190: 'lwf rt status = ' || l_Return_Status);
1191: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'itemKey = ' || l_itemKey);
1192: END IF;
1193:
1194: -- Create a sales team member for the opportunity
1195: l_Sales_Team_Rec.customer_id := l_customer_id;

Line 1234: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1230: l_Sales_Team_Rec.created_by_TAP_flag := 'N';
1231: l_sales_team_rec.owner_flag := 'N';
1232:
1233: IF (AS_DEBUG_LOW_ON) THEN
1234: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1235: 'sf_id=' || l_Sales_Team_Rec.salesforce_id);
1236: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1237: 'sg_id=' || l_Sales_Team_Rec.sales_group_id);
1238: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1236: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1232:
1233: IF (AS_DEBUG_LOW_ON) THEN
1234: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1235: 'sf_id=' || l_Sales_Team_Rec.salesforce_id);
1236: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1237: 'sg_id=' || l_Sales_Team_Rec.sales_group_id);
1238: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1239: 'Calling Create_SalesTeam');
1240: END IF;

Line 1238: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1234: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1235: 'sf_id=' || l_Sales_Team_Rec.salesforce_id);
1236: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1237: 'sg_id=' || l_Sales_Team_Rec.sales_group_id);
1238: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1239: 'Calling Create_SalesTeam');
1240: END IF;
1241: AS_ACCESS_PUB.Create_SalesTeam (
1242: p_api_version_number => 2.0

Line 1259: l_msg_data := FND_MSG_PUB.Get(

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;
1263: wf_core.token('STACK',l_msg_data);

Line 1260: p_msg_index => FND_MSG_PUB.Count_Msg,

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;
1263: wf_core.token('STACK',l_msg_data);
1264:

Line 1272: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1268: RAISE;
1269: END IF;
1270:
1271: IF (AS_DEBUG_LOW_ON) THEN
1272: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1273: 'acc rt status = ' || l_Return_Status);
1274: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1275: 'Create_SalesTeam:l_access_id = ' || l_access_id);
1276: END IF;

Line 1274: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1270:
1271: IF (AS_DEBUG_LOW_ON) THEN
1272: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1273: 'acc rt status = ' || l_Return_Status);
1274: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1275: 'Create_SalesTeam:l_access_id = ' || l_access_id);
1276: END IF;
1277: END IF;
1278: END IF;

Line 1282: fnd_msg_pub.Count_And_Get(

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
1285: ,p_data => l_msg_data);
1286:

Line 1287: l_msg_data := FND_MSG_PUB.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(
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');

Line 1288: p_msg_index => FND_MSG_PUB.Count_Msg,

1284: ,p_count => l_msg_count
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:

Line 1298: fnd_msg_pub.Count_And_Get(

1294: raise;
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: