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_ACCESS_PVT dependencies on FND_MSG_PUB

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

29: if (AS_FOUNDATION_PVT.get_lookupMeaning('YES/NO',
30: p_sales_team_rec.freeze_flag, AS_FOUNDATION_PVT.G_AR_LOOKUPS )
31: is NULL)
32: then
33: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
34: THEN
35: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
36: FND_MESSAGE.Set_Token('COLUMN', 'FREEZE_FLAG', FALSE);
37: FND_MESSAGE.Set_Token('VALUE', p_sales_team_rec.freeze_flag, FALSE);

Line 38: FND_MSG_PUB.ADD;

34: THEN
35: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
36: FND_MESSAGE.Set_Token('COLUMN', 'FREEZE_FLAG', FALSE);
37: FND_MESSAGE.Set_Token('VALUE', p_sales_team_rec.freeze_flag, FALSE);
38: FND_MSG_PUB.ADD;
39: END IF;
40: return false;
41: end if;
42: end if;

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

47: if (AS_FOUNDATION_PVT.get_lookupMeaning('YES/NO',
48: p_sales_team_rec.reassign_flag, AS_FOUNDATION_PVT.G_AR_LOOKUPS )
49: is NULL)
50: then
51: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
52: THEN
53: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
54: FND_MESSAGE.Set_Token('COLUMN', 'REASSIGN_FLAG', FALSE);
55: FND_MESSAGE.Set_Token('VALUE', p_sales_team_rec.reassign_flag, FALSE);

Line 56: FND_MSG_PUB.ADD;

52: THEN
53: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
54: FND_MESSAGE.Set_Token('COLUMN', 'REASSIGN_FLAG', FALSE);
55: FND_MESSAGE.Set_Token('VALUE', p_sales_team_rec.reassign_flag, FALSE);
56: FND_MSG_PUB.ADD;
57: END IF;
58: return false;
59: end if;
60: end if;

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

65: if (AS_FOUNDATION_PVT.get_lookupMeaning('YES/NO',
66: p_sales_team_rec.team_leader_flag, AS_FOUNDATION_PVT.G_AR_LOOKUPS )
67: is NULL)
68: then
69: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
70: THEN
71: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
72: FND_MESSAGE.Set_Token('COLUMN', 'TEAM_LEADER_FLAG', FALSE);
73: FND_MESSAGE.Set_Token('VALUE', p_sales_team_rec.team_leader_flag, FALSE);

Line 74: FND_MSG_PUB.ADD;

70: THEN
71: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
72: FND_MESSAGE.Set_Token('COLUMN', 'TEAM_LEADER_FLAG', FALSE);
73: FND_MESSAGE.Set_Token('VALUE', p_sales_team_rec.team_leader_flag, FALSE);
74: FND_MSG_PUB.ADD;
75: END IF;
76: return false;
77: end if;
78: end if;

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

94: fetch get_person_id_csr into x_person_id;
95:
96: if (get_person_id_csr%NOTFOUND)
97: then
98: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
99: THEN
100: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
101: FND_MESSAGE.Set_Token('COLUMN', 'SALESFORCE_ID', FALSE);
102: fnd_message.set_token('VALUE', p_salesforce_id, FALSE);

Line 103: FND_MSG_PUB.ADD;

99: THEN
100: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
101: FND_MESSAGE.Set_Token('COLUMN', 'SALESFORCE_ID', FALSE);
102: fnd_message.set_token('VALUE', p_salesforce_id, FALSE);
103: FND_MSG_PUB.ADD;
104: END IF;
105: raise FND_API.G_EXC_ERROR;
106: end if;
107: close get_person_id_csr;

Line 114: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

110: procedure get_accessProfileValues(px_access_profile_rec in OUT NOCOPY
111: AS_ACCESS_PUB.Access_Profile_Rec_Type)
112:
113: is
114: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
115: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acspv.get_accessProfileValues';
116: begin
117: IF px_access_profile_rec.opp_access_profile_value IS NULL OR
118: px_access_profile_rec.opp_access_profile_value = FND_API.G_MISS_CHAR

Line 152: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

148: px_access_profile_rec.admin_update_profile_value
149: := FND_PROFILE.Value('AS_ADMIN_UPDATE');
150: END IF;
151: IF l_debug THEN
152: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
153: 'AS_CUST_ACCESS: ' ||
154: px_access_profile_rec.cust_access_profile_value);
155: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
156: 'AS_OPP_ACCESS: ' ||

Line 155: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

151: IF l_debug THEN
152: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
153: 'AS_CUST_ACCESS: ' ||
154: px_access_profile_rec.cust_access_profile_value);
155: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
156: 'AS_OPP_ACCESS: ' ||
157: px_access_profile_rec.opp_access_profile_value);
158: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
159: 'AS_LEAD_ACCESS: ' ||

Line 158: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

154: px_access_profile_rec.cust_access_profile_value);
155: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
156: 'AS_OPP_ACCESS: ' ||
157: px_access_profile_rec.opp_access_profile_value);
158: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
159: 'AS_LEAD_ACCESS: ' ||
160: px_access_profile_rec.lead_access_profile_value);
161: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
162: 'AS_MGR_UPDATE: ' ||

Line 161: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

157: px_access_profile_rec.opp_access_profile_value);
158: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
159: 'AS_LEAD_ACCESS: ' ||
160: px_access_profile_rec.lead_access_profile_value);
161: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
162: 'AS_MGR_UPDATE: ' ||
163: px_access_profile_rec.mgr_update_profile_value);
164: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
165: 'AS_ADMIN_UPDATE: ' ||

Line 164: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

160: px_access_profile_rec.lead_access_profile_value);
161: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
162: 'AS_MGR_UPDATE: ' ||
163: px_access_profile_rec.mgr_update_profile_value);
164: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
165: 'AS_ADMIN_UPDATE: ' ||
166: px_access_profile_rec.mgr_update_profile_value);
167: END IF;
168:

Line 266: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

262: and a.salesforce_role_code = 'AM'
263: and rm.parent_sales_group_id = p_admin_group_id
264: and lead.sales_lead_id = p_sales_lead_id;
265:
266: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
267: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acspv.has_leadOwnerAccess';
268: begin
269: -- Standard call to check for call compatibility.
270: /* IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 281: FND_MSG_PUB.initialize;

277:
278: -- Initialize message list if p_init_msg_list is set to TRUE.
279: IF FND_API.to_Boolean( p_init_msg_list )
280: THEN
281: FND_MSG_PUB.initialize;
282: END IF;
283: */
284: -- Debug Message
285: IF l_debug THEN

Line 286: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

282: END IF;
283: */
284: -- Debug Message
285: IF l_debug THEN
286: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
287: 'Private API: ' || l_api_name || 'start');
288:
289: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
290: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 289: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

285: IF l_debug THEN
286: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
287: 'Private API: ' || l_api_name || 'start');
288:
289: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
290: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
291: END IF;
292:
293: -- Initialize API return status to SUCCESS

Line 297: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

293: -- Initialize API return status to SUCCESS
294: x_return_status := FND_API.G_RET_STS_SUCCESS;
295:
296: IF l_debug THEN
297: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
298: 'p_sales_lead_id: ' || p_sales_lead_id);
299: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
300: 'ident salesforce_id: ' || p_identity_salesforce_id);
301: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 299: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

295:
296: IF l_debug THEN
297: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
298: 'p_sales_lead_id: ' || p_sales_lead_id);
299: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
300: 'ident salesforce_id: ' || p_identity_salesforce_id);
301: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
302: 'p_admin_group_id: ' || p_admin_group_id);
303: END IF;

Line 301: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

297: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
298: 'p_sales_lead_id: ' || p_sales_lead_id);
299: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
300: 'ident salesforce_id: ' || p_identity_salesforce_id);
301: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
302: 'p_admin_group_id: ' || p_admin_group_id);
303: END IF;
304:
305: --

Line 335: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

331: get_person_id(p_identity_salesforce_id, l_person_id);
332: else
333: l_person_id := p_person_id;
334: end if;
335: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
336: 'person id: ' || l_person_id);
337: */
338: l_access_profile_rec := p_access_profile_rec;
339: get_accessProfileValues(l_access_profile_rec);

Line 418: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

414: -- End of API body.
415: --
416:
417: IF l_debug THEN
418: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
419: 'x_update_access_flag: ' || x_update_access_flag);
420:
421: -- Debug Message
422: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 422: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

418: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
419: 'x_update_access_flag: ' || x_update_access_flag);
420:
421: -- Debug Message
422: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
423: 'Private API: ' || l_api_name || 'end');
424:
425: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
426: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 425: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

421: -- Debug Message
422: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
423: 'Private API: ' || l_api_name || 'end');
424:
425: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
426: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
427: END IF;
428:
429:

Line 430: FND_MSG_PUB.Count_And_Get

426: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
427: END IF;
428:
429:
430: FND_MSG_PUB.Count_And_Get
431: ( p_count => x_msg_count,
432: p_data => x_msg_data
433: );
434:

Line 441: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

437: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
438: P_MODULE => l_module
439: ,P_API_NAME => L_API_NAME
440: ,P_PKG_NAME => G_PKG_NAME
441: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
442: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
443: , P_ROLLBACK_FLAG => 'N'
444: ,X_MSG_COUNT => X_MSG_COUNT
445: ,X_MSG_DATA => X_MSG_DATA

Line 453: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

449: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
450: P_MODULE => l_module
451: ,P_API_NAME => L_API_NAME
452: ,P_PKG_NAME => G_PKG_NAME
453: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
454: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
455: , P_ROLLBACK_FLAG => 'N'
456: ,X_MSG_COUNT => X_MSG_COUNT
457: ,X_MSG_DATA => X_MSG_DATA

Line 570: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

566: and a.salesforce_role_code = 'AM'
567: and rm.parent_sales_group_id = p_admin_group_id
568: and lead.lead_id = p_lead_id;
569:
570: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
571: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acspv.has_oppOwnerAccess';
572:
573:
574: begin

Line 579: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

575: -- Standard call to check for call compatibility.
576:
577: -- Debug Message
578: IF l_debug THEN
579: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
580: 'Private API: ' || l_api_name || 'start');
581:
582: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
583: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 582: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

578: IF l_debug THEN
579: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
580: 'Private API: ' || l_api_name || 'start');
581:
582: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
583: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
584: END IF;
585:
586: -- Initialize API return status to SUCCESS

Line 590: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

586: -- Initialize API return status to SUCCESS
587: x_return_status := FND_API.G_RET_STS_SUCCESS;
588:
589: IF l_debug THEN
590: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
591: 'p_lead_id: ' || p_lead_id);
592: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
593: 'ident salesforce_id: ' || p_identity_salesforce_id);
594: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 592: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

588:
589: IF l_debug THEN
590: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
591: 'p_lead_id: ' || p_lead_id);
592: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
593: 'ident salesforce_id: ' || p_identity_salesforce_id);
594: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
595: 'allow change opp owner profile: ' || fnd_profile.value('AS_ALLOW_CHANGE_OPP_OWNER') );
596: END IF;

Line 594: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

590: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
591: 'p_lead_id: ' || p_lead_id);
592: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
593: 'ident salesforce_id: ' || p_identity_salesforce_id);
594: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
595: 'allow change opp owner profile: ' || fnd_profile.value('AS_ALLOW_CHANGE_OPP_OWNER') );
596: END IF;
597:
598:

Line 696: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

692: end if;
693: END IF;
694:
695: IF l_debug THEN
696: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
697: 'x_update_access_flag: ' || x_update_access_flag);
698:
699: -- Debug Message
700: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 700: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

696: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
697: 'x_update_access_flag: ' || x_update_access_flag);
698:
699: -- Debug Message
700: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
701: 'Private API: ' || l_api_name || 'end');
702:
703: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
704: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 703: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

699: -- Debug Message
700: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
701: 'Private API: ' || l_api_name || 'end');
702:
703: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
704: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
705: END IF;
706:
707:

Line 708: FND_MSG_PUB.Count_And_Get

704: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
705: END IF;
706:
707:
708: FND_MSG_PUB.Count_And_Get
709: ( p_count => x_msg_count,
710: p_data => x_msg_data
711: );
712:

Line 719: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

715: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
716: P_MODULE => l_module
717: ,P_API_NAME => L_API_NAME
718: ,P_PKG_NAME => G_PKG_NAME
719: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
720: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
721: , P_ROLLBACK_FLAG => 'N'
722: ,X_MSG_COUNT => X_MSG_COUNT
723: ,X_MSG_DATA => X_MSG_DATA

Line 731: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

727: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
728: P_MODULE => l_module
729: ,P_API_NAME => L_API_NAME
730: ,P_PKG_NAME => G_PKG_NAME
731: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
732: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
733: , P_ROLLBACK_FLAG => 'N'
734: ,X_MSG_COUNT => X_MSG_COUNT
735: ,X_MSG_DATA => X_MSG_DATA

Line 871: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

867: AND res.category = 'EMPLOYEE'
868: AND res.source_id = per.person_id;
869:
870: l_val VARCHAR2(1);
871: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
872: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acspv.Validate_PERSON_ID';
873: BEGIN
874: -- Initialize message list IF p_init_msg_list is set to TRUE.
875: IF FND_API.to_Boolean( p_init_msg_list )

Line 877: FND_MSG_PUB.initialize;

873: BEGIN
874: -- Initialize message list IF p_init_msg_list is set to TRUE.
875: IF FND_API.to_Boolean( p_init_msg_list )
876: THEN
877: FND_MSG_PUB.initialize;
878: END IF;
879:
880: -- Initialize API return status to SUCCESS
881: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 884: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

880: -- Initialize API return status to SUCCESS
881: x_return_status := FND_API.G_RET_STS_SUCCESS;
882:
883: -- Debug Message
884: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
885: -- 'Validate person id');
886:
887: -- Validate PERSON_ID
888: IF (p_person_id IS NOT NULL

Line 897: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

893: IF (C_Check_Assign_Person%NOTFOUND)
894: THEN
895: AS_UTILITY_PVT.Set_Message(
896: p_module => l_module,
897: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
898: p_msg_name => 'API_INVALID_ID',
899: p_token1 => 'COLUMN',
900: p_token1_value => 'PERSON_ID',
901: p_token2 => 'VALUE',

Line 909: FND_MSG_PUB.Count_And_Get

905: END IF;
906: CLOSE C_Check_Assign_Person;
907: END IF;
908:
909: FND_MSG_PUB.Count_And_Get
910: ( p_count => x_msg_count,
911: p_data => x_msg_data );
912: END;
913:

Line 947: FND_MSG_PUB.initialize;

943: BEGIN
944: -- Initialize message list IF p_init_msg_list is set to TRUE.
945: IF FND_API.to_Boolean( p_init_msg_list )
946: THEN
947: FND_MSG_PUB.initialize;
948: END IF;
949:
950: -- Initialize API return status to SUCCESS
951: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 954: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

950: -- Initialize API return status to SUCCESS
951: x_return_status := FND_API.G_RET_STS_SUCCESS;
952:
953: -- Debug Message
954: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
955: -- 'Validate salesforce id');
956:
957:
958: IF (p_salesforce_id IS NOT NULL

Line 967: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

963: IF (C_Check_Assign_Salesforce%NOTFOUND)
964: THEN
965: AS_UTILITY_PVT.Set_Message(
966: p_module => l_module,
967: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
968: p_msg_name => 'API_INVALID_ID',
969: p_token1 => 'COLUMN',
970: p_token1_value => 'SALESFORCE_ID',
971: p_token2 => 'VALUE',

Line 979: FND_MSG_PUB.Count_And_Get

975: END IF;
976: CLOSE C_Check_Assign_Salesforce;
977: END IF;
978:
979: FND_MSG_PUB.Count_And_Get
980: ( p_count => x_msg_count,
981: p_data => x_msg_data );
982: END;
983:

Line 995: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

991: ) IS
992:
993: l_val VARCHAR2(1);
994: l_return_status VARCHAR2(1);
995: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
996: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldhpv.Validate_salesrep_group';
997: CURSOR VALIDATE_SALESGROUP (p_SALESGROUP_ID NUMBER)
998: IS
999: SELECT 'X'

Line 1023: FND_MSG_PUB.initialize;

1019: begin
1020: -- initialize message list if p_init_msg_list is set to TRUE;
1021:
1022: IF FND_API.to_Boolean(p_init_msg_list) THEN
1023: FND_MSG_PUB.initialize;
1024: END IF;
1025: l_return_status := FND_API.G_RET_STS_SUCCESS;
1026: OPEN VALIDATE_SALESGROUP (p_sales_group_id);
1027: FETCH VALIDATE_SALESGROUP into l_val;

Line 1030: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1026: OPEN VALIDATE_SALESGROUP (p_sales_group_id);
1027: FETCH VALIDATE_SALESGROUP into l_val;
1028: IF VALIDATE_SALESGROUP%NOTFOUND THEN
1029: IF l_debug THEN
1030: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1031: 'Private API: SALES_GROUP_ID is not valid');
1032: END IF;
1033: IF FND_PROFILE.value('ASF_BYPASS_GRP_VALIDATION') = 'Y' THEN
1034: FND_MESSAGE.Set_Name('AS', 'AS_UNSET_BYP_GRP_VALIDN_PROF');

Line 1035: FND_MSG_PUB.ADD;

1031: 'Private API: SALES_GROUP_ID is not valid');
1032: END IF;
1033: IF FND_PROFILE.value('ASF_BYPASS_GRP_VALIDATION') = 'Y' THEN
1034: FND_MESSAGE.Set_Name('AS', 'AS_UNSET_BYP_GRP_VALIDN_PROF');
1035: FND_MSG_PUB.ADD;
1036: ELSE
1037: AS_UTILITY_PVT.Set_Message(
1038: p_module => l_module,
1039: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1039: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1035: FND_MSG_PUB.ADD;
1036: ELSE
1037: AS_UTILITY_PVT.Set_Message(
1038: p_module => l_module,
1039: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1040: p_msg_name => 'API_INVALID_ID',
1041: p_token1 => 'COLUMN',
1042: p_token1_value => 'SALESGROUP_ID',
1043: p_token2 => 'VALUE',

Line 1054: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1050: OPEN VALIDATE_COMBINATION (p_salesforce_id,p_sales_group_id);
1051: FETCH VALIDATE_COMBINATION into l_val;
1052: IF VALIDATE_COMBINATION%NOTFOUND THEN
1053: IF l_debug THEN
1054: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1055: 'Private API: SALES_GROUP_ID,SALESFORCE_ID is not valid');
1056: END IF;
1057: IF FND_PROFILE.value('ASF_BYPASS_GRP_VALIDATION') = 'Y' THEN
1058: FND_MESSAGE.Set_Name('AS', 'AS_UNSET_BYP_GRP_VALIDN_PROF');

Line 1059: FND_MSG_PUB.ADD;

1055: 'Private API: SALES_GROUP_ID,SALESFORCE_ID is not valid');
1056: END IF;
1057: IF FND_PROFILE.value('ASF_BYPASS_GRP_VALIDATION') = 'Y' THEN
1058: FND_MESSAGE.Set_Name('AS', 'AS_UNSET_BYP_GRP_VALIDN_PROF');
1059: FND_MSG_PUB.ADD;
1060: ELSE
1061: AS_UTILITY_PVT.Set_Message(
1062: p_module => l_module,
1063: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1063: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1059: FND_MSG_PUB.ADD;
1060: ELSE
1061: AS_UTILITY_PVT.Set_Message(
1062: p_module => l_module,
1063: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1064: p_msg_name => 'API_INVALID_ID',
1065: p_token1 => 'COLUMN',
1066: p_token1_value => 'SALESFORCE/SALESGROUP COMBINATION',
1067: p_token2 => 'VALUE',

Line 1073: FND_MSG_PUB.Count_And_Get

1069: END IF;
1070: x_return_status := FND_API.G_RET_STS_ERROR;
1071: END IF;
1072: CLOSE VALIDATE_COMBINATION;
1073: FND_MSG_PUB.Count_And_Get
1074: ( p_count => x_msg_count,
1075: p_data => x_msg_data
1076: );
1077:

Line 1095: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

1091: FROM as_sales_leads
1092: WHERE sales_lead_id = X_Sales_Lead_Id;
1093:
1094: l_val VARCHAR2(1);
1095: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1096: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acspv.Validate_SALES_LEAD_ID';
1097:
1098: BEGIN
1099: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1102: FND_MSG_PUB.initialize;

1098: BEGIN
1099: -- Initialize message list if p_init_msg_list is set to TRUE.
1100: IF FND_API.to_Boolean( p_init_msg_list )
1101: THEN
1102: FND_MSG_PUB.initialize;
1103: END IF;
1104:
1105: -- Initialize API return status to SUCCESS
1106: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1110: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1106: x_return_status := FND_API.G_RET_STS_SUCCESS;
1107:
1108: -- Debug Message
1109: IF l_debug THEN
1110: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1111: 'Validate Sales Lead Id');
1112: END IF;
1113:
1114: -- Validate Sales Lead Id

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

1116: FETCH C_Sales_Lead_Id_Exists into l_val;
1117:
1118: IF C_Sales_Lead_Id_Exists%NOTFOUND
1119: THEN
1120: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1121: THEN
1122: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
1123: FND_MESSAGE.Set_Token('COLUMN', 'SALES_LEAD_ID', FALSE);
1124: FND_MESSAGE.Set_Token('VALUE', p_Sales_Lead_Id, FALSE);

Line 1125: FND_MSG_PUB.ADD;

1121: THEN
1122: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
1123: FND_MESSAGE.Set_Token('COLUMN', 'SALES_LEAD_ID', FALSE);
1124: FND_MESSAGE.Set_Token('VALUE', p_Sales_Lead_Id, FALSE);
1125: FND_MSG_PUB.ADD;
1126: END IF;
1127:
1128: x_return_status := FND_API.G_RET_STS_ERROR;
1129: END IF;

Line 1133: FND_MSG_PUB.Count_And_Get

1129: END IF;
1130: CLOSE C_Sales_Lead_Id_Exists ;
1131:
1132: -- Standard call to get message count and if count is 1, get message info.
1133: FND_MSG_PUB.Count_And_Get
1134: ( p_count => x_msg_count,
1135: p_data => x_msg_data );
1136:
1137: END Validate_SALES_LEAD_ID;

Line 1153: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

1149: FROM as_leads_all
1150: WHERE lead_id = X_Lead_Id;
1151:
1152: l_val VARCHAR2(1);
1153: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1154: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acspv.Validate_Opportunity_ID';
1155:
1156: BEGIN
1157: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1160: FND_MSG_PUB.initialize;

1156: BEGIN
1157: -- Initialize message list if p_init_msg_list is set to TRUE.
1158: IF FND_API.to_Boolean( p_init_msg_list )
1159: THEN
1160: FND_MSG_PUB.initialize;
1161: END IF;
1162:
1163: -- Initialize API return status to SUCCESS
1164: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1168: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1164: x_return_status := FND_API.G_RET_STS_SUCCESS;
1165:
1166: -- Debug Message
1167: IF l_debug THEN
1168: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1169: 'Validate Sales Lead Id');
1170: END IF;
1171:
1172: -- Validate Lead Id

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

1174: FETCH C_Lead_Id_Exists into l_val;
1175:
1176: IF C_Lead_Id_Exists%NOTFOUND
1177: THEN
1178: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1179: THEN
1180: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
1181: FND_MESSAGE.Set_Token('COLUMN', 'LEAD_ID', FALSE);
1182: FND_MESSAGE.Set_Token('VALUE', p_Lead_Id, FALSE);

Line 1183: FND_MSG_PUB.ADD;

1179: THEN
1180: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
1181: FND_MESSAGE.Set_Token('COLUMN', 'LEAD_ID', FALSE);
1182: FND_MESSAGE.Set_Token('VALUE', p_Lead_Id, FALSE);
1183: FND_MSG_PUB.ADD;
1184: END IF;
1185:
1186: x_return_status := FND_API.G_RET_STS_ERROR;
1187: END IF;

Line 1191: FND_MSG_PUB.Count_And_Get

1187: END IF;
1188: CLOSE C_Lead_Id_Exists ;
1189:
1190: -- Standard call to get message count and if count is 1, get message info.
1191: FND_MSG_PUB.Count_And_Get
1192: ( p_count => x_msg_count,
1193: p_data => x_msg_data );
1194:
1195: END Validate_Opportunity_ID;

Line 1218: FND_MSG_PUB.initialize;

1214:
1215: -- initialize message list if p_init_msg_list is set to TRUE;
1216:
1217: IF FND_API.to_Boolean(p_init_msg_list) THEN
1218: FND_MSG_PUB.initialize;
1219: END IF;
1220:
1221: l_return_status := FND_API.G_RET_STS_SUCCESS;
1222: open C_Party_Exists(p_party_id);

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

1222: open C_Party_Exists(p_party_id);
1223: fetch C_Party_Exists into l_val;
1224: IF (C_Party_Exists%NOTFOUND) THEN
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1227: THEN
1228: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
1229: FND_MESSAGE.Set_Token('COLUMN', 'PARTNER_CUSTOMER_ID', FALSE);
1230: FND_MSG_PUB.ADD;

Line 1230: FND_MSG_PUB.ADD;

1226: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1227: THEN
1228: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
1229: FND_MESSAGE.Set_Token('COLUMN', 'PARTNER_CUSTOMER_ID', FALSE);
1230: FND_MSG_PUB.ADD;
1231: END IF;
1232: END IF;
1233: close C_Party_Exists;
1234:

Line 1235: FND_MSG_PUB.Count_And_Get

1231: END IF;
1232: END IF;
1233: close C_Party_Exists;
1234:
1235: FND_MSG_PUB.Count_And_Get
1236: ( p_count => x_msg_count,
1237: p_data => x_msg_data
1238: );
1239:

Line 1280: FND_MSG_PUB.initialize;

1276:
1277: -- initialize message list if p_init_msg_list is set to TRUE;
1278:
1279: IF FND_API.to_Boolean(p_init_msg_list) THEN
1280: FND_MSG_PUB.initialize;
1281: END IF;
1282:
1283: l_return_status := FND_API.G_RET_STS_SUCCESS;
1284: open C_Party_Site_Exists(p_party_id, p_party_site_id);

Line 1294: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1290: fetch C_Party_Site_Exists_Partner into l_val_2;
1291:
1292: IF (C_Party_Site_Exists_Partner%NOTFOUND) THEN
1293: x_return_status := FND_API.G_RET_STS_ERROR;
1294: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1295: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
1296: FND_MESSAGE.Set_Token('COLUMN', 'PARTNER_ADDRESS_ID', FALSE);
1297: FND_MSG_PUB.ADD;
1298: END IF;

Line 1297: FND_MSG_PUB.ADD;

1293: x_return_status := FND_API.G_RET_STS_ERROR;
1294: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1295: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
1296: FND_MESSAGE.Set_Token('COLUMN', 'PARTNER_ADDRESS_ID', FALSE);
1297: FND_MSG_PUB.ADD;
1298: END IF;
1299: END IF;
1300:
1301: close C_Party_Site_Exists_Partner;

Line 1306: FND_MSG_PUB.Count_And_Get

1302: END IF;
1303: close C_Party_Site_Exists;
1304:
1305:
1306: FND_MSG_PUB.Count_And_Get
1307: ( p_count => x_msg_count,
1308: p_data => x_msg_data
1309: );
1310:

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

1357: and (p_sales_team_rec.partner_cont_party_id is NULL
1358: or p_sales_team_rec. partner_cont_party_id = FND_API.G_MISS_NUM)
1359: then
1360: x_return_status := FND_API.G_RET_STS_ERROR;
1361: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1362: THEN
1363: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1364: FND_MESSAGE.Set_Token('COLUMN', 'PERSON_ID', FALSE);
1365: FND_MSG_PUB.ADD;

Line 1365: FND_MSG_PUB.ADD;

1361: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1362: THEN
1363: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1364: FND_MESSAGE.Set_Token('COLUMN', 'PERSON_ID', FALSE);
1365: FND_MSG_PUB.ADD;
1366: END IF;
1367: raise FND_API.G_EXC_ERROR;
1368: end if;
1369: IF (p_sales_team_rec.partner_customer_id IS NULL

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

1400: or (p_sales_team_rec.salesforce_id is NULL
1401: or p_sales_team_rec.salesforce_id = FND_API.G_MISS_NUM)
1402: then
1403: x_return_status := FND_API.G_RET_STS_ERROR;
1404: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1405: THEN
1406: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1407: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_ID, SALESFORCE_ID', FALSE);
1408: FND_MSG_PUB.ADD;

Line 1408: FND_MSG_PUB.ADD;

1404: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1405: THEN
1406: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1407: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_ID, SALESFORCE_ID', FALSE);
1408: FND_MSG_PUB.ADD;
1409: END IF;
1410: raise FND_API.G_EXC_ERROR;
1411: end if;
1412:

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

1416: and (p_sales_team_rec.partner_cont_party_id is NULL
1417: or p_sales_team_rec. partner_cont_party_id = FND_API.G_MISS_NUM)
1418: then
1419: x_return_status := FND_API.G_RET_STS_ERROR;
1420: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1421: THEN
1422: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1423: FND_MESSAGE.Set_Token('COLUMN', 'PARTNER_CUSTOMER_ID', FALSE);
1424: FND_MSG_PUB.ADD;

Line 1424: FND_MSG_PUB.ADD;

1420: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1421: THEN
1422: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1423: FND_MESSAGE.Set_Token('COLUMN', 'PARTNER_CUSTOMER_ID', FALSE);
1424: FND_MSG_PUB.ADD;
1425: END IF;
1426: raise FND_API.G_EXC_ERROR;
1427: end if;
1428:

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

1433: and (p_sales_team_rec.sales_group_id is NULL
1434: or p_sales_team_rec.sales_group_id = FND_API.G_MISS_NUM)
1435: then
1436: x_return_status := FND_API.G_RET_STS_ERROR;
1437: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1438: THEN
1439: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1440: FND_MESSAGE.Set_Token('COLUMN', 'SALES_GROUP_ID', FALSE);
1441: FND_MSG_PUB.ADD;

Line 1441: FND_MSG_PUB.ADD;

1437: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1438: THEN
1439: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1440: FND_MESSAGE.Set_Token('COLUMN', 'SALES_GROUP_ID', FALSE);
1441: FND_MSG_PUB.ADD;
1442: END IF;
1443: raise FND_API.G_EXC_ERROR;
1444: end if;
1445:

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

1450: and (p_sales_team_rec.partner_customer_id is NULL or
1451: p_sales_team_rec.partner_customer_id = FND_API.G_MISS_NUM)
1452: then
1453: x_return_status := FND_API.G_RET_STS_ERROR;
1454: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1455: THEN
1456: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1457: FND_MESSAGE.Set_Token('COLUMN', 'PARTNER_CUSTOMER_ID', FALSE);
1458: FND_MSG_PUB.ADD;

Line 1458: FND_MSG_PUB.ADD;

1454: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1455: THEN
1456: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1457: FND_MESSAGE.Set_Token('COLUMN', 'PARTNER_CUSTOMER_ID', FALSE);
1458: FND_MSG_PUB.ADD;
1459: END IF;
1460: end if;
1461: close partner_exist_csr;
1462: */

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

1572:
1573:
1574: if not salesTeam_flags_are_valid( l_sales_team_rec )
1575: then
1576: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1577: THEN
1578: x_return_status := fnd_api.g_ret_sts_error;
1579: FND_MESSAGE.Set_Name('AS', 'API_INVALID_INFO');
1580: FND_MESSAGE.Set_Token('ROW', 'AS_ACCESSES', TRUE);

Line 1581: FND_MSG_PUB.ADD;

1577: THEN
1578: x_return_status := fnd_api.g_ret_sts_error;
1579: FND_MESSAGE.Set_Name('AS', 'API_INVALID_INFO');
1580: FND_MESSAGE.Set_Token('ROW', 'AS_ACCESSES', TRUE);
1581: FND_MSG_PUB.ADD;
1582: END IF;
1583: end if;
1584:
1585: end Validate_SalesTeamItems;

Line 1610: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1606: open get_dup_salesTeam_csr;
1607: fetch get_dup_salesTeam_csr into l_val;
1608: if (get_dup_salesTeam_csr%FOUND)
1609: then
1610: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1611: THEN
1612: FND_MESSAGE.Set_Name('AS', 'API_DUP_SALESTEAM');
1613: FND_MSG_PUB.ADD;
1614: END IF;

Line 1613: FND_MSG_PUB.ADD;

1609: then
1610: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1611: THEN
1612: FND_MESSAGE.Set_Name('AS', 'API_DUP_SALESTEAM');
1613: FND_MSG_PUB.ADD;
1614: END IF;
1615: return TRUE;
1616: else
1617: return FALSE;

Line 1716: FND_MSG_PUB.initialize;

1712:
1713: -- Initialize message list if p_init_msg_list is set to TRUE.
1714: IF FND_API.to_Boolean( p_init_msg_list )
1715: THEN
1716: FND_MSG_PUB.initialize;
1717: END IF;
1718:
1719: -- Initialize API return status to success
1720: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1727: -- Validate Environment
1728: -- ******************************************************************
1729: IF FND_GLOBAL.User_Id IS NULL
1730: THEN
1731: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1732: THEN
1733: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
1734: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1735: FND_MSG_PUB.ADD;

Line 1735: FND_MSG_PUB.ADD;

1731: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1732: THEN
1733: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
1734: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1735: FND_MSG_PUB.ADD;
1736: END IF;
1737: RAISE FND_API.G_EXC_ERROR;
1738: END IF;
1739:

Line 1813: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1810: END IF;
1811:
1812: IF (l_update_access_flag <> 'Y') THEN
1813: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1814: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
1815: FND_MSG_PUB.ADD;
1816: END IF;
1817: RAISE FND_API.G_EXC_ERROR;

Line 1815: FND_MSG_PUB.ADD;

1811:
1812: IF (l_update_access_flag <> 'Y') THEN
1813: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1814: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
1815: FND_MSG_PUB.ADD;
1816: END IF;
1817: RAISE FND_API.G_EXC_ERROR;
1818: END IF;
1819: ELSIF (p_sales_team_rec.lead_id is not NULL and p_sales_team_rec.lead_id <> FND_API.G_MISS_NUM)

Line 1841: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1837: ,x_update_access_flag => l_update_access_flag
1838: );
1839:
1840: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1841: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1842: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateOpportunityAccess fail');
1843: END IF;
1844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1845: END IF;

Line 1842: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateOpportunityAccess fail');

1838: );
1839:
1840: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1841: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1842: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateOpportunityAccess fail');
1843: END IF;
1844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1845: END IF;
1846:

Line 1848: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1845: END IF;
1846:
1847: IF (l_update_access_flag <> 'Y') THEN
1848: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1849: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
1850: FND_MSG_PUB.ADD;
1851: END IF;
1852: RAISE FND_API.G_EXC_ERROR;

Line 1850: FND_MSG_PUB.ADD;

1846:
1847: IF (l_update_access_flag <> 'Y') THEN
1848: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1849: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
1850: FND_MSG_PUB.ADD;
1851: END IF;
1852: RAISE FND_API.G_EXC_ERROR;
1853: END IF;
1854: ELSIF (p_sales_team_rec.sales_lead_id is not NULL and p_sales_team_rec.sales_lead_id <> FND_API.G_MISS_NUM)

Line 1875: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1871: ,x_update_access_flag => l_update_access_flag
1872: );
1873:
1874: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1875: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1876: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateOpportunityAccess fail');
1877: END IF;
1878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1879: END IF;

Line 1876: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateOpportunityAccess fail');

1872: );
1873:
1874: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1875: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1876: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateOpportunityAccess fail');
1877: END IF;
1878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1879: END IF;
1880:

Line 1882: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1879: END IF;
1880:
1881: IF (l_update_access_flag <> 'Y') THEN
1882: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1883: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
1884: FND_MSG_PUB.ADD;
1885: END IF;
1886: RAISE FND_API.G_EXC_ERROR;

Line 1884: FND_MSG_PUB.ADD;

1880:
1881: IF (l_update_access_flag <> 'Y') THEN
1882: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1883: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
1884: FND_MSG_PUB.ADD;
1885: END IF;
1886: RAISE FND_API.G_EXC_ERROR;
1887: END IF;
1888: END IF;

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

1922:
1923: if l_sales_team_rec.reassign_flag = 'Y'
1924: and l_sales_team_rec.reassign_reason is null
1925: then
1926: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1927: THEN
1928: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1929: FND_MESSAGE.Set_Token('COLUMN', 'reassign_reason', FALSE);
1930: FND_MSG_PUB.ADD;

Line 1930: FND_MSG_PUB.ADD;

1926: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1927: THEN
1928: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1929: FND_MESSAGE.Set_Token('COLUMN', 'reassign_reason', FALSE);
1930: FND_MSG_PUB.ADD;
1931: END IF;
1932: raise fnd_api.g_exc_error;
1933: end if;
1934:

Line 1965: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1961: ,x_update_access_flag => l_update_access_flag
1962: );
1963:
1964: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1965: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1966: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateLeadAccess fail');
1967: END IF;
1968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1969: END IF;

Line 1966: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateLeadAccess fail');

1962: );
1963:
1964: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1965: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1966: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateLeadAccess fail');
1967: END IF;
1968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1969: END IF;
1970:

Line 1972: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1969: END IF;
1970:
1971: IF (l_update_access_flag <> 'Y') THEN
1972: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1973: FND_MESSAGE.Set_Name('AS', 'API_NO_OWNER_PRIVILEGE');
1974: FND_MSG_PUB.ADD;
1975: END IF;
1976: RAISE FND_API.G_EXC_ERROR;

Line 1974: FND_MSG_PUB.ADD;

1970:
1971: IF (l_update_access_flag <> 'Y') THEN
1972: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1973: FND_MESSAGE.Set_Name('AS', 'API_NO_OWNER_PRIVILEGE');
1974: FND_MSG_PUB.ADD;
1975: END IF;
1976: RAISE FND_API.G_EXC_ERROR;
1977: END IF;
1978: end if; -- check owner privilege

Line 2004: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2000: ,x_msg_count => x_msg_count
2001: ,x_msg_data => x_msg_data
2002: ,x_update_access_flag => l_update_access_flag );
2003: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2004: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2005: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateOppAccess fail');
2006: END IF;
2007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2008: END IF;

Line 2005: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateOppAccess fail');

2001: ,x_msg_data => x_msg_data
2002: ,x_update_access_flag => l_update_access_flag );
2003: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2004: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2005: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateOppAccess fail');
2006: END IF;
2007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2008: END IF;
2009:

Line 2011: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2008: END IF;
2009:
2010: IF (l_update_access_flag <> 'Y') THEN
2011: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2012: FND_MESSAGE.Set_Name('AS', 'API_NO_OPP_OWNER_PRIVILEGE');
2013: FND_MSG_PUB.ADD;
2014: END IF;
2015: RAISE FND_API.G_EXC_ERROR;

Line 2013: FND_MSG_PUB.ADD;

2009:
2010: IF (l_update_access_flag <> 'Y') THEN
2011: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2012: FND_MESSAGE.Set_Name('AS', 'API_NO_OPP_OWNER_PRIVILEGE');
2013: FND_MSG_PUB.ADD;
2014: END IF;
2015: RAISE FND_API.G_EXC_ERROR;
2016: END IF;
2017:

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

2031: -- if login person is not account manager and not full access,he can't make other
2032: -- people account manager
2033:
2034: then
2035: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2036: THEN
2037: FND_MESSAGE.Set_Name('AS','API_NO_ACC_MGR_PRIVILEGE');
2038: FND_MSG_PUB.ADD;
2039: END IF;

Line 2038: FND_MSG_PUB.ADD;

2034: then
2035: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2036: THEN
2037: FND_MESSAGE.Set_Name('AS','API_NO_ACC_MGR_PRIVILEGE');
2038: FND_MSG_PUB.ADD;
2039: END IF;
2040: RAISE FND_API.G_EXC_ERROR;
2041: end if;
2042: end if;

Line 2190: FND_MSG_PUB.Count_And_Get

2186: COMMIT WORK;
2187: END IF;
2188:
2189: -- Standard call to get message count and if count is 1, get message info.
2190: FND_MSG_PUB.Count_And_Get
2191: ( p_count => x_msg_count,
2192: p_data => x_msg_data
2193: );
2194:

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

2195:
2196: EXCEPTION
2197:
2198: WHEN DUP_VAL_ON_INDEX THEN
2199: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2200: THEN
2201: x_return_status := FND_API.G_RET_STS_SUCCESS;
2202: open get_dup_access_id_csr(l_sales_team_rec);
2203: fetch get_dup_access_id_csr into x_access_id;

Line 2206: FND_MSG_PUB.ADD;

2202: open get_dup_access_id_csr(l_sales_team_rec);
2203: fetch get_dup_access_id_csr into x_access_id;
2204: close get_dup_access_id_csr;
2205: FND_MESSAGE.Set_Name('AS', 'API_DUP_SALESTEAM');
2206: FND_MSG_PUB.ADD;
2207:
2208: END IF;
2209:
2210: WHEN FND_API.G_EXC_ERROR THEN

Line 2215: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2211: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2212: P_MODULE => l_module
2213: ,P_API_NAME => L_API_NAME
2214: ,P_PKG_NAME => G_PKG_NAME
2215: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2216: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2217: ,X_MSG_COUNT => X_MSG_COUNT
2218: ,X_MSG_DATA => X_MSG_DATA
2219: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2226: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2222: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2223: P_MODULE => l_module
2224: ,P_API_NAME => L_API_NAME
2225: ,P_PKG_NAME => G_PKG_NAME
2226: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2227: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2228: ,X_MSG_COUNT => X_MSG_COUNT
2229: ,X_MSG_DATA => X_MSG_DATA
2230: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2301: FND_MSG_PUB.initialize;

2297:
2298: -- Initialize message list if p_init_msg_list is set to TRUE.
2299: IF FND_API.to_Boolean( p_init_msg_list )
2300: THEN
2301: FND_MSG_PUB.initialize;
2302: END IF;
2303:
2304: -- Initialize API return status to success
2305: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2312: -- Validate Environment
2313: -- ******************************************************************
2314: IF FND_GLOBAL.User_Id IS NULL
2315: THEN
2316: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2317: THEN
2318: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
2319: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2320: FND_MSG_PUB.ADD;

Line 2320: FND_MSG_PUB.ADD;

2316: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2317: THEN
2318: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
2319: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2320: FND_MSG_PUB.ADD;
2321: END IF;
2322: RAISE FND_API.G_EXC_ERROR;
2323: END IF;
2324:

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

2343: -- ******************************************************************
2344:
2345: if (p_sales_team_rec.access_id is NULL)
2346: then
2347: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2348: THEN
2349: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
2350: FND_MESSAGE.Set_Token('COLUMN', 'ACCESS_ID', FALSE);
2351: FND_MSG_PUB.ADD;

Line 2351: FND_MSG_PUB.ADD;

2347: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2348: THEN
2349: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
2350: FND_MESSAGE.Set_Token('COLUMN', 'ACCESS_ID', FALSE);
2351: FND_MSG_PUB.ADD;
2352: END IF;
2353: end if;
2354:
2355: open get_access_info_csr(p_sales_team_rec.access_id);

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

2356: fetch get_access_info_csr into l_val;
2357:
2358: if (get_access_info_csr%NOTFOUND)
2359: then
2360: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2361: THEN
2362: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
2363: FND_MESSAGE.Set_Token('COLUMN', 'ACCESS_ID', FALSE);
2364: fnd_message.set_token('VALUE', p_sales_team_rec.access_id, FALSE);

Line 2365: FND_MSG_PUB.ADD;

2361: THEN
2362: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
2363: FND_MESSAGE.Set_Token('COLUMN', 'ACCESS_ID', FALSE);
2364: fnd_message.set_token('VALUE', p_sales_team_rec.access_id, FALSE);
2365: FND_MSG_PUB.ADD;
2366: END IF;
2367: close get_access_info_csr;
2368: raise FND_API.G_EXC_ERROR;
2369: End if;

Line 2399: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2396: END IF;
2397:
2398: IF (l_update_access_flag <> 'Y') THEN
2399: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2400: FND_MESSAGE.Set_Name('AS', 'API_NO_DELETE_PRIVILEGE');
2401: FND_MSG_PUB.ADD;
2402: END IF;
2403: RAISE FND_API.G_EXC_ERROR;

Line 2401: FND_MSG_PUB.ADD;

2397:
2398: IF (l_update_access_flag <> 'Y') THEN
2399: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2400: FND_MESSAGE.Set_Name('AS', 'API_NO_DELETE_PRIVILEGE');
2401: FND_MSG_PUB.ADD;
2402: END IF;
2403: RAISE FND_API.G_EXC_ERROR;
2404: END IF;
2405: ELSIF (p_sales_team_rec.lead_id is not NULL and p_sales_team_rec.lead_id <> FND_API.G_MISS_NUM)

Line 2427: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2423: ,x_update_access_flag => l_update_access_flag
2424: );
2425:
2426: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2427: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2428: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateOpportunityAccess fail');
2429: END IF;
2430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2431: END IF;

Line 2428: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateOpportunityAccess fail');

2424: );
2425:
2426: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2427: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2428: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateOpportunityAccess fail');
2429: END IF;
2430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2431: END IF;
2432:

Line 2434: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2431: END IF;
2432:
2433: IF (l_update_access_flag <> 'Y') THEN
2434: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2435: FND_MESSAGE.Set_Name('AS', 'API_NO_DELETE_PRIVILEGE');
2436: FND_MSG_PUB.ADD;
2437: END IF;
2438: RAISE FND_API.G_EXC_ERROR;

Line 2436: FND_MSG_PUB.ADD;

2432:
2433: IF (l_update_access_flag <> 'Y') THEN
2434: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2435: FND_MESSAGE.Set_Name('AS', 'API_NO_DELETE_PRIVILEGE');
2436: FND_MSG_PUB.ADD;
2437: END IF;
2438: RAISE FND_API.G_EXC_ERROR;
2439: END IF;
2440:

Line 2462: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2458: ,x_update_access_flag => l_update_access_flag
2459: );
2460:
2461: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2462: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2463: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateOpportunityAccess fail');
2464: END IF;
2465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2466: END IF;

Line 2463: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateOpportunityAccess fail');

2459: );
2460:
2461: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2462: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2463: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateOpportunityAccess fail');
2464: END IF;
2465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2466: END IF;
2467:

Line 2469: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2466: END IF;
2467:
2468: IF (l_update_access_flag <> 'Y') THEN
2469: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2470: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
2471: FND_MSG_PUB.ADD;
2472: END IF;
2473: RAISE FND_API.G_EXC_ERROR;

Line 2471: FND_MSG_PUB.ADD;

2467:
2468: IF (l_update_access_flag <> 'Y') THEN
2469: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2470: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
2471: FND_MSG_PUB.ADD;
2472: END IF;
2473: RAISE FND_API.G_EXC_ERROR;
2474: END IF;
2475: --end if; -- owner check

Line 2502: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2498: ,x_update_access_flag => l_update_access_flag
2499: );
2500:
2501: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2502: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2503: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateOppAccess fail');
2504: END IF;
2505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2506: END IF;

Line 2503: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateOppAccess fail');

2499: );
2500:
2501: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2502: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2503: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateOppAccess fail');
2504: END IF;
2505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2506: END IF;
2507:

Line 2509: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2506: END IF;
2507:
2508: IF (l_update_access_flag <> 'Y') THEN
2509: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2510: FND_MESSAGE.Set_Name('AS', 'API_NO_OPP_OWNER_PRIVILEGE');
2511: FND_MSG_PUB.ADD;
2512: END IF;
2513: RAISE FND_API.G_EXC_ERROR;

Line 2511: FND_MSG_PUB.ADD;

2507:
2508: IF (l_update_access_flag <> 'Y') THEN
2509: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2510: FND_MESSAGE.Set_Name('AS', 'API_NO_OPP_OWNER_PRIVILEGE');
2511: FND_MSG_PUB.ADD;
2512: END IF;
2513: RAISE FND_API.G_EXC_ERROR;
2514: END IF;
2515: end if; -- is_sales_lead_owner_row(p_sales_team_rec.access_id)

Line 2541: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2537: ,x_update_access_flag => l_update_access_flag
2538: );
2539:
2540: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2541: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2542: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateLeadAccess fail');
2543: END IF;
2544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2545: END IF;

Line 2542: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateLeadAccess fail');

2538: );
2539:
2540: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2541: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2542: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateLeadAccess fail');
2543: END IF;
2544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2545: END IF;
2546:

Line 2548: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2545: END IF;
2546:
2547: IF (l_update_access_flag <> 'Y') THEN
2548: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2549: FND_MESSAGE.Set_Name('AS', 'API_NO_OWNER_PRIVILEGE');
2550: FND_MSG_PUB.ADD;
2551: END IF;
2552: RAISE FND_API.G_EXC_ERROR;

Line 2550: FND_MSG_PUB.ADD;

2546:
2547: IF (l_update_access_flag <> 'Y') THEN
2548: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2549: FND_MESSAGE.Set_Name('AS', 'API_NO_OWNER_PRIVILEGE');
2550: FND_MSG_PUB.ADD;
2551: END IF;
2552: RAISE FND_API.G_EXC_ERROR;
2553: END IF;
2554: end if;

Line 2578: FND_MSG_PUB.Count_And_Get

2574: COMMIT WORK;
2575: END IF;
2576:
2577: -- Standard call to get message count and if count is 1, get message info.
2578: FND_MSG_PUB.Count_And_Get
2579: ( p_count => x_msg_count,
2580: p_data => x_msg_data
2581: );
2582:

Line 2589: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2585: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2586: P_MODULE => l_module
2587: ,P_API_NAME => L_API_NAME
2588: ,P_PKG_NAME => G_PKG_NAME
2589: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2590: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2591: ,X_MSG_COUNT => X_MSG_COUNT
2592: ,X_MSG_DATA => X_MSG_DATA
2593: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2600: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2596: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2597: P_MODULE => l_module
2598: ,P_API_NAME => L_API_NAME
2599: ,P_PKG_NAME => G_PKG_NAME
2600: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2601: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2602: ,X_MSG_COUNT => X_MSG_COUNT
2603: ,X_MSG_DATA => X_MSG_DATA
2604: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2672: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

2668: select salesforce_role_code
2669: from as_accesses_all
2670: where access_id = p_access_id;
2671:
2672: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2673: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acspv.Update_SalesTeam';
2674:
2675: begin
2676: -- Standard Start of API savepoint

Line 2692: FND_MSG_PUB.initialize;

2688:
2689: -- Initialize message list if p_init_msg_list is set to TRUE.
2690: IF FND_API.to_Boolean( p_init_msg_list )
2691: THEN
2692: FND_MSG_PUB.initialize;
2693: END IF;
2694:
2695: -- Initialize API return status to success
2696: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2703: -- Validate Environment
2704: -- ******************************************************************
2705: IF FND_GLOBAL.User_Id IS NULL
2706: THEN
2707: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2708: THEN
2709: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
2710: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2711: FND_MSG_PUB.ADD;

Line 2711: FND_MSG_PUB.ADD;

2707: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2708: THEN
2709: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
2710: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2711: FND_MSG_PUB.ADD;
2712: END IF;
2713: RAISE FND_API.G_EXC_ERROR;
2714: END IF;
2715:

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

2736: l_sales_team_rec := p_sales_team_rec;
2737:
2738: if (l_sales_team_rec.access_id is NULL)
2739: then
2740: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2741: THEN
2742: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
2743: FND_MESSAGE.Set_Token('COLUMN', 'ACCESS_ID', FALSE);
2744: FND_MSG_PUB.ADD;

Line 2744: FND_MSG_PUB.ADD;

2740: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2741: THEN
2742: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
2743: FND_MESSAGE.Set_Token('COLUMN', 'ACCESS_ID', FALSE);
2744: FND_MSG_PUB.ADD;
2745: END IF;
2746: end if;
2747:
2748:

Line 2794: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2791: END IF;
2792:
2793: IF (l_update_access_flag <> 'Y') THEN
2794: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2795: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
2796: FND_MSG_PUB.ADD;
2797: END IF;
2798: RAISE FND_API.G_EXC_ERROR;

Line 2796: FND_MSG_PUB.ADD;

2792:
2793: IF (l_update_access_flag <> 'Y') THEN
2794: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2795: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
2796: FND_MSG_PUB.ADD;
2797: END IF;
2798: RAISE FND_API.G_EXC_ERROR;
2799: END IF;
2800: ELSIF (p_sales_team_rec.lead_id is not NULL and p_sales_team_rec.lead_id <> FND_API.G_MISS_NUM)

Line 2821: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2817: ,x_update_access_flag => l_update_access_flag
2818: );
2819:
2820: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2821: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2822: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateOpportunityAccess fail');
2823: END IF;
2824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2825: END IF;

Line 2822: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateOpportunityAccess fail');

2818: );
2819:
2820: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2821: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2822: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateOpportunityAccess fail');
2823: END IF;
2824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2825: END IF;
2826:

Line 2828: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2825: END IF;
2826:
2827: IF (l_update_access_flag <> 'Y') THEN
2828: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2829: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
2830: FND_MSG_PUB.ADD;
2831: END IF;
2832: RAISE FND_API.G_EXC_ERROR;

Line 2830: FND_MSG_PUB.ADD;

2826:
2827: IF (l_update_access_flag <> 'Y') THEN
2828: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2829: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
2830: FND_MSG_PUB.ADD;
2831: END IF;
2832: RAISE FND_API.G_EXC_ERROR;
2833: END IF;
2834: ELSIF (p_sales_team_rec.sales_lead_id is not NULL and p_sales_team_rec.sales_lead_id <>FND_API.G_MISS_NUM)

Line 2855: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2851: ,x_update_access_flag => l_update_access_flag
2852: );
2853:
2854: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2855: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2856: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateLeadAccess fail');
2857: END IF;
2858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2859: END IF;

Line 2856: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateLeadAccess fail');

2852: );
2853:
2854: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2855: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2856: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateLeadAccess fail');
2857: END IF;
2858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2859: END IF;
2860:

Line 2862: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2859: END IF;
2860:
2861: IF (l_update_access_flag <> 'Y') THEN
2862: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2863: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
2864: FND_MSG_PUB.ADD;
2865: END IF;
2866: RAISE FND_API.G_EXC_ERROR;

Line 2864: FND_MSG_PUB.ADD;

2860:
2861: IF (l_update_access_flag <> 'Y') THEN
2862: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2863: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
2864: FND_MSG_PUB.ADD;
2865: END IF;
2866: RAISE FND_API.G_EXC_ERROR;
2867: END IF;
2868: END IF;

Line 2878: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2874: fetch get_owner_flag into l_owner_flag;
2875: close get_owner_flag;
2876:
2877: IF l_debug THEN
2878: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2879: 'l_owner_flag: ' || nvl(l_owner_flag, 'N') || '');
2880:
2881: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2882: 'l_sales_team_rec.owner_flag: ' || nvl(l_sales_team_rec.owner_flag, 'N') || '');

Line 2881: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2877: IF l_debug THEN
2878: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2879: 'l_owner_flag: ' || nvl(l_owner_flag, 'N') || '');
2880:
2881: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2882: 'l_sales_team_rec.owner_flag: ' || nvl(l_sales_team_rec.owner_flag, 'N') || '');
2883: END IF;
2884:
2885:

Line 2905: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2901: ,x_msg_count => x_msg_count
2902: ,x_msg_data => x_msg_data
2903: ,x_update_access_flag => l_update_access_flag );
2904: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2905: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2906: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateOppAccess fail');
2907: END IF;
2908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2909: END IF;

Line 2906: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateOppAccess fail');

2902: ,x_msg_data => x_msg_data
2903: ,x_update_access_flag => l_update_access_flag );
2904: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2905: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2906: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateOppAccess fail');
2907: END IF;
2908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2909: END IF;
2910:

Line 2912: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2909: END IF;
2910:
2911: IF (l_update_access_flag <> 'Y') THEN
2912: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2913: FND_MESSAGE.Set_Name('AS', 'API_NO_OPP_OWNER_PRIVILEGE');
2914: FND_MSG_PUB.ADD;
2915: END IF;
2916: RAISE FND_API.G_EXC_ERROR;

Line 2914: FND_MSG_PUB.ADD;

2910:
2911: IF (l_update_access_flag <> 'Y') THEN
2912: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2913: FND_MESSAGE.Set_Name('AS', 'API_NO_OPP_OWNER_PRIVILEGE');
2914: FND_MSG_PUB.ADD;
2915: END IF;
2916: RAISE FND_API.G_EXC_ERROR;
2917: END IF;
2918:

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

2927:
2928: if (l_sales_team_rec.last_update_date is NULL
2929: or l_sales_team_rec.last_update_date = FND_API.G_MISS_DATE)
2930: then
2931: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2932: THEN
2933: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
2934: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
2935: FND_MSG_PUB.ADD;

Line 2935: FND_MSG_PUB.ADD;

2931: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2932: THEN
2933: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
2934: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
2935: FND_MSG_PUB.ADD;
2936: END IF;
2937: RAISE FND_API.G_EXC_ERROR;
2938: end if;
2939: if (l_last_update_date <> l_sales_team_rec.last_update_date)

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

2937: RAISE FND_API.G_EXC_ERROR;
2938: end if;
2939: if (l_last_update_date <> l_sales_team_rec.last_update_date)
2940: then
2941: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2942: THEN
2943: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
2944: FND_MESSAGE.Set_Token('INFO', 'AS_ACCESSES', FALSE);
2945: FND_MSG_PUB.ADD;

Line 2945: FND_MSG_PUB.ADD;

2941: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2942: THEN
2943: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
2944: FND_MESSAGE.Set_Token('INFO', 'AS_ACCESSES', FALSE);
2945: FND_MSG_PUB.ADD;
2946: END IF;
2947: RAISE FND_API.G_EXC_ERROR;
2948: end if;
2949:

Line 2976: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2972: open get_owner_flag (l_sales_team_rec.access_id);
2973: fetch get_owner_flag into l_owner_flag;
2974: close get_owner_flag;
2975:
2976: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2977: 'l_owner_flag: ' || nvl(l_owner_flag, 'N') || '');
2978:
2979: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2980: 'l_sales_team_rec.owner_flag: ' || nvl(l_sales_team_rec.owner_flag, 'N') || '');

Line 2979: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2975:
2976: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2977: 'l_owner_flag: ' || nvl(l_owner_flag, 'N') || '');
2978:
2979: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2980: 'l_sales_team_rec.owner_flag: ' || nvl(l_sales_team_rec.owner_flag, 'N') || '');
2981:
2982: if(nvl(l_owner_flag, 'N') <> nvl(l_sales_team_rec.owner_flag, 'N'))
2983: then

Line 3004: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

3000: ,x_update_access_flag => l_update_access_flag
3001: );
3002:
3003: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3004: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3005: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateLeadAccess fail');
3006: END IF;
3007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3008: END IF;

Line 3005: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateLeadAccess fail');

3001: );
3002:
3003: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3004: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3005: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updateLeadAccess fail');
3006: END IF;
3007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3008: END IF;
3009:

Line 3011: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3008: END IF;
3009:
3010: IF (l_update_access_flag <> 'Y') THEN
3011: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3012: FND_MESSAGE.Set_Name('AS', 'API_NO_OWNER_PRIVILEGE');
3013: FND_MSG_PUB.ADD;
3014: END IF;
3015: RAISE FND_API.G_EXC_ERROR;

Line 3013: FND_MSG_PUB.ADD;

3009:
3010: IF (l_update_access_flag <> 'Y') THEN
3011: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3012: FND_MESSAGE.Set_Name('AS', 'API_NO_OWNER_PRIVILEGE');
3013: FND_MSG_PUB.ADD;
3014: END IF;
3015: RAISE FND_API.G_EXC_ERROR;
3016: END IF;
3017: end if;

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

3035: -- if login person is not account manager,he can't make other
3036: -- people account manager or not account manager
3037:
3038: then
3039: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3040: THEN
3041: FND_MESSAGE.Set_Name('AS','API_NO_ACC_MGR_PRIVILEGE');
3042: FND_MSG_PUB.ADD;
3043: END IF;

Line 3042: FND_MSG_PUB.ADD;

3038: then
3039: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3040: THEN
3041: FND_MESSAGE.Set_Name('AS','API_NO_ACC_MGR_PRIVILEGE');
3042: FND_MSG_PUB.ADD;
3043: END IF;
3044: RAISE FND_API.G_EXC_ERROR;
3045: end if;
3046: end if;

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

3048: if l_sales_team_rec.reassign_flag = 'Y'
3049: and (l_sales_team_rec.reassign_reason is null
3050: or l_sales_team_rec.reassign_reason = fnd_api.g_miss_char)
3051: then
3052: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3053: THEN
3054: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
3055: FND_MESSAGE.Set_Token('COLUMN', 'reassign_reason', FALSE);
3056: FND_MSG_PUB.ADD;

Line 3056: FND_MSG_PUB.ADD;

3052: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3053: THEN
3054: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
3055: FND_MESSAGE.Set_Token('COLUMN', 'reassign_reason', FALSE);
3056: FND_MSG_PUB.ADD;
3057: END IF;
3058: raise fnd_api.g_exc_error;
3059: end if;
3060: --if l_sales_team_rec.owner_flag = 'Y' and (l_sales_team_rec.sales_lead_id is NOT NULL

Line 3170: FND_MSG_PUB.Count_And_Get

3166: COMMIT WORK;
3167: END IF;
3168:
3169: -- Standard call to get message count and if count is 1, get message info.
3170: FND_MSG_PUB.Count_And_Get
3171: ( p_count => x_msg_count,
3172: p_data => x_msg_data
3173: );
3174:

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

3175:
3176: EXCEPTION
3177:
3178: WHEN DUP_VAL_ON_INDEX THEN
3179: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3180: THEN
3181: FND_MESSAGE.Set_Name('AS', 'API_DUP_SALESTEAM');
3182: FND_MSG_PUB.ADD;
3183: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 3182: FND_MSG_PUB.ADD;

3178: WHEN DUP_VAL_ON_INDEX THEN
3179: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3180: THEN
3181: FND_MESSAGE.Set_Name('AS', 'API_DUP_SALESTEAM');
3182: FND_MSG_PUB.ADD;
3183: x_return_status := FND_API.G_RET_STS_ERROR ;
3184: END IF;
3185:
3186:

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

3187: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
3188: ROLLBACK TO UPDATE_SALESTEAM_PVT;
3189: x_return_status := FND_API.G_RET_STS_ERROR ;
3190:
3191: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3192: THEN
3193: FND_MESSAGE.Set_Name('AS', 'API_CANNOT_RESERVE_RECORD');
3194: FND_MESSAGE.Set_Token('INFO', 'UPDATE_SALESTEAM', FALSE);
3195: FND_MSG_PUB.Add;

Line 3195: FND_MSG_PUB.Add;

3191: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3192: THEN
3193: FND_MESSAGE.Set_Name('AS', 'API_CANNOT_RESERVE_RECORD');
3194: FND_MESSAGE.Set_Token('INFO', 'UPDATE_SALESTEAM', FALSE);
3195: FND_MSG_PUB.Add;
3196: END IF;
3197:
3198: WHEN FND_API.G_EXC_ERROR THEN
3199: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

Line 3203: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3199: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3200: P_MODULE => l_module
3201: ,P_API_NAME => L_API_NAME
3202: ,P_PKG_NAME => G_PKG_NAME
3203: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3204: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3205: ,X_MSG_COUNT => X_MSG_COUNT
3206: ,X_MSG_DATA => X_MSG_DATA
3207: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3214: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3210: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3211: P_MODULE => l_module
3212: ,P_API_NAME => L_API_NAME
3213: ,P_PKG_NAME => G_PKG_NAME
3214: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3215: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3216: ,X_MSG_COUNT => X_MSG_COUNT
3217: ,X_MSG_DATA => X_MSG_DATA
3218: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3318: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

3314: and a.customer_id = rel.object_id
3315: and rm.parent_sales_group_id = p_admin_group_id)
3316: and rownum = 1;
3317:
3318: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3319: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acspv.has_viewPersonAccess';
3320:
3321: begin
3322:

Line 3326: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3322:
3323:
3324: -- Debug Message
3325: IF l_debug THEN
3326: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3327: 'has_viewPersonAccess: start ');
3328:
3329: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3330: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 3329: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3325: IF l_debug THEN
3326: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3327: 'has_viewPersonAccess: start ');
3328:
3329: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3330: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3331: END IF;
3332:
3333: l_person_id := p_person_id;

Line 3362: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3358: end if;
3359: close resource_access_csr;
3360:
3361: IF l_debug THEN
3362: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3363: 'x_view_access_flag: ' || x_view_access_flag);
3364: -- Debug Message
3365:
3366: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 3366: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3362: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3363: 'x_view_access_flag: ' || x_view_access_flag);
3364: -- Debug Message
3365:
3366: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3367: 'has_viewPersonAccess: end ');
3368:
3369:
3370: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

Line 3370: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

3366: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3367: 'has_viewPersonAccess: end ');
3368:
3369:
3370: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
3371: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3372: END IF;
3373:
3374: end has_viewPersonAccess;

Line 3481: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

3477: from as_rpt_admins_v rm
3478: where a.salesforce_id = rm.salesforce_id
3479: and rm.parent_sales_group_id = p_admin_group_id);
3480:
3481: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3482: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acspv.has_updatePersonAccess';
3483: begin
3484:
3485: -- Debug Message

Line 3487: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updatePersonAccess start');

3483: begin
3484:
3485: -- Debug Message
3486: IF l_debug THEN
3487: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updatePersonAccess start');
3488:
3489: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3490: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3491: END IF;

Line 3489: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3485: -- Debug Message
3486: IF l_debug THEN
3487: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'has_updatePersonAccess start');
3488:
3489: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3490: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3491: END IF;
3492:
3493: l_person_id := p_person_id;

Line 3550: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3546: close resource_access_csr;
3547:
3548: -- Debug Message
3549: IF l_debug THEN
3550: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3551: 'has_updatePersonAccess end');
3552:
3553: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
3554: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 3553: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

3549: IF l_debug THEN
3550: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3551: 'has_updatePersonAccess end');
3552:
3553: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
3554: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3555: END IF;
3556:
3557: end has_updatePersonAccess;

Line 3608: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

3604: and EXISTS (select 'x'
3605: from as_rpt_admins_v rm
3606: where a.salesforce_id = rm.salesforce_id
3607: and rm.parent_sales_group_id = p_admin_group_id);
3608: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3609: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acspv.has_viewCustomerAccess';
3610:
3611: begin
3612:

Line 3625: FND_MSG_PUB.initialize;

3621:
3622: -- Initialize message list if p_init_msg_list is set to TRUE.
3623: IF FND_API.to_Boolean( p_init_msg_list )
3624: THEN
3625: FND_MSG_PUB.initialize;
3626: END IF;
3627:
3628: -- Debug Message
3629: IF l_debug THEN

Line 3630: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3626: END IF;
3627:
3628: -- Debug Message
3629: IF l_debug THEN
3630: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3631: 'Private API: ' || l_api_name || 'start');
3632:
3633: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3634: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 3633: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3629: IF l_debug THEN
3630: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3631: 'Private API: ' || l_api_name || 'start');
3632:
3633: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3634: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3635: END IF;
3636:
3637: -- Initialize API return status to SUCCESS

Line 3641: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3637: -- Initialize API return status to SUCCESS
3638: x_return_status := FND_API.G_RET_STS_SUCCESS;
3639:
3640: IF l_debug THEN
3641: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3642: 'customer_id: ' || p_customer_id);
3643: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3644: 'ident salesforce_id: ' || p_identity_salesforce_id);
3645: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 3643: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3639:
3640: IF l_debug THEN
3641: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3642: 'customer_id: ' || p_customer_id);
3643: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3644: 'ident salesforce_id: ' || p_identity_salesforce_id);
3645: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3646: 'admin_group_id: ' || p_admin_group_id);
3647: END IF;

Line 3645: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3641: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3642: 'customer_id: ' || p_customer_id);
3643: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3644: 'ident salesforce_id: ' || p_identity_salesforce_id);
3645: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3646: 'admin_group_id: ' || p_admin_group_id);
3647: END IF;
3648:
3649: -- Initialize access flag to 'N'

Line 3678: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3674: get_person_id(p_identity_salesforce_id, l_person_id);
3675: else
3676: l_person_id := p_person_id;
3677: end if;
3678: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3679: 'person id: ' || l_person_id);
3680: */
3681: l_access_profile_rec := p_access_profile_rec;
3682: get_accessProfileValues(l_access_profile_rec);

Line 3726: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3722: end if;
3723: end if; -- if p_check_access_flag = 'N'
3724:
3725: IF l_debug THEN
3726: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3727: 'x_view_access_flag: ' || x_view_access_flag);
3728: -- Debug Message
3729: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3730: 'Private API: ' || l_api_name || 'end');

Line 3729: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3725: IF l_debug THEN
3726: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3727: 'x_view_access_flag: ' || x_view_access_flag);
3728: -- Debug Message
3729: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3730: 'Private API: ' || l_api_name || 'end');
3731:
3732: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
3733: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 3732: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

3728: -- Debug Message
3729: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3730: 'Private API: ' || l_api_name || 'end');
3731:
3732: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
3733: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3734: END IF;
3735:
3736: FND_MSG_PUB.Count_And_Get

Line 3736: FND_MSG_PUB.Count_And_Get

3732: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
3733: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3734: END IF;
3735:
3736: FND_MSG_PUB.Count_And_Get
3737: ( p_count => x_msg_count,
3738: p_data => x_msg_data
3739: );
3740:

Line 3747: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3743: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3744: P_MODULE => l_module
3745: ,P_API_NAME => L_API_NAME
3746: ,P_PKG_NAME => G_PKG_NAME
3747: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3748: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3749: , P_ROLLBACK_FLAG => 'N'
3750: ,X_MSG_COUNT => X_MSG_COUNT
3751: ,X_MSG_DATA => X_MSG_DATA

Line 3759: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3755: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3756: P_MODULE => l_module
3757: ,P_API_NAME => L_API_NAME
3758: ,P_PKG_NAME => G_PKG_NAME
3759: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3760: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3761: , P_ROLLBACK_FLAG => 'N'
3762: ,X_MSG_COUNT => X_MSG_COUNT
3763: ,X_MSG_DATA => X_MSG_DATA

Line 3868: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

3864: from as_rpt_admins_v rm
3865: where a.salesforce_id = rm.salesforce_id
3866: and rm.parent_sales_group_id = p_admin_group_id);
3867:
3868: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3869: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acspv.has_updateCustomerAccess';
3870:
3871: begin
3872: -- Standard call to check for call compatibility.

Line 3884: FND_MSG_PUB.initialize;

3880:
3881: -- Initialize message list if p_init_msg_list is set to TRUE.
3882: IF FND_API.to_Boolean( p_init_msg_list )
3883: THEN
3884: FND_MSG_PUB.initialize;
3885: END IF;
3886:
3887: -- Debug Message
3888: IF l_debug THEN

Line 3889: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3885: END IF;
3886:
3887: -- Debug Message
3888: IF l_debug THEN
3889: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3890: 'Private API: ' || l_api_name || 'start');
3891:
3892: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3893: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 3892: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3888: IF l_debug THEN
3889: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3890: 'Private API: ' || l_api_name || 'start');
3891:
3892: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3893: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3894: END IF;
3895:
3896: -- Initialize API return status to SUCCESS

Line 3900: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3896: -- Initialize API return status to SUCCESS
3897: x_return_status := FND_API.G_RET_STS_SUCCESS;
3898:
3899: IF l_debug THEN
3900: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3901: 'customer_id: ' || p_customer_id);
3902: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3903: 'ident salesforce_id: ' || p_identity_salesforce_id);
3904: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 3902: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3898:
3899: IF l_debug THEN
3900: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3901: 'customer_id: ' || p_customer_id);
3902: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3903: 'ident salesforce_id: ' || p_identity_salesforce_id);
3904: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3905: 'admin_group_id: ' || p_admin_group_id);
3906: END IF;

Line 3904: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3900: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3901: 'customer_id: ' || p_customer_id);
3902: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3903: 'ident salesforce_id: ' || p_identity_salesforce_id);
3904: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3905: 'admin_group_id: ' || p_admin_group_id);
3906: END IF;
3907:
3908: --

Line 3937: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3933: get_person_id(p_identity_salesforce_id, l_person_id);
3934: else
3935: l_person_id := p_person_id;
3936: end if;
3937: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3938: 'person id: ' || l_person_id);
3939: */
3940: l_access_profile_rec := p_access_profile_rec;
3941: get_accessProfileValues(l_access_profile_rec);

Line 4013: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4009: end if;
4010: end if; --if p_check_access_flag = 'N'
4011:
4012: IF l_debug THEN
4013: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4014: 'x_update_access_flag: ' || x_update_access_flag);
4015:
4016: -- Debug Message
4017: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 4017: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4013: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4014: 'x_update_access_flag: ' || x_update_access_flag);
4015:
4016: -- Debug Message
4017: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4018: 'Private API: ' || l_api_name || 'end');
4019:
4020: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
4021: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 4020: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

4016: -- Debug Message
4017: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4018: 'Private API: ' || l_api_name || 'end');
4019:
4020: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
4021: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4022: END IF;
4023:
4024:

Line 4025: FND_MSG_PUB.Count_And_Get

4021: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4022: END IF;
4023:
4024:
4025: FND_MSG_PUB.Count_And_Get
4026: ( p_count => x_msg_count,
4027: p_data => x_msg_data
4028: );
4029:

Line 4036: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4032: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4033: P_MODULE => l_module
4034: ,P_API_NAME => L_API_NAME
4035: ,P_PKG_NAME => G_PKG_NAME
4036: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4037: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
4038: , P_ROLLBACK_FLAG => 'N'
4039: ,X_MSG_COUNT => X_MSG_COUNT
4040: ,X_MSG_DATA => X_MSG_DATA

Line 4048: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4044: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4045: P_MODULE => l_module
4046: ,P_API_NAME => L_API_NAME
4047: ,P_PKG_NAME => G_PKG_NAME
4048: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4049: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
4050: , P_ROLLBACK_FLAG => 'N'
4051: ,X_MSG_COUNT => X_MSG_COUNT
4052: ,X_MSG_DATA => X_MSG_DATA

Line 4165: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

4161: and a.salesforce_role_code = 'AM'
4162: and rm.parent_sales_group_id = p_admin_group_id
4163: and lead.sales_lead_id = p_sales_lead_id;
4164:
4165: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
4166: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acspv.has_updateLeadAccess';
4167: begin
4168: -- Standard call to check for call compatibility.
4169: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 4180: FND_MSG_PUB.initialize;

4176:
4177: -- Initialize message list if p_init_msg_list is set to TRUE.
4178: IF FND_API.to_Boolean( p_init_msg_list )
4179: THEN
4180: FND_MSG_PUB.initialize;
4181: END IF;
4182:
4183: -- Debug Message
4184: IF l_debug THEN

Line 4185: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4181: END IF;
4182:
4183: -- Debug Message
4184: IF l_debug THEN
4185: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4186: 'Private API: ' || l_api_name || 'start');
4187:
4188: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4189: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 4188: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4184: IF l_debug THEN
4185: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4186: 'Private API: ' || l_api_name || 'start');
4187:
4188: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4189: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4190: END IF;
4191:
4192: -- Initialize API return status to SUCCESS

Line 4196: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4192: -- Initialize API return status to SUCCESS
4193: x_return_status := FND_API.G_RET_STS_SUCCESS;
4194:
4195: IF l_debug THEN
4196: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4197: 'p_sales_lead_id: ' || p_sales_lead_id);
4198: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4199: 'ident salesforce_id: ' || p_identity_salesforce_id);
4200: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 4198: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4194:
4195: IF l_debug THEN
4196: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4197: 'p_sales_lead_id: ' || p_sales_lead_id);
4198: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4199: 'ident salesforce_id: ' || p_identity_salesforce_id);
4200: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4201: 'p_admin_group_id: ' || p_admin_group_id);
4202: END IF;

Line 4200: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4196: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4197: 'p_sales_lead_id: ' || p_sales_lead_id);
4198: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4199: 'ident salesforce_id: ' || p_identity_salesforce_id);
4200: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4201: 'p_admin_group_id: ' || p_admin_group_id);
4202: END IF;
4203:
4204: --

Line 4235: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4231: get_person_id(p_identity_salesforce_id, l_person_id);
4232: else
4233: l_person_id := p_person_id;
4234: end if;
4235: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4236: 'person id: ' || l_person_id);
4237: */
4238: l_access_profile_rec := p_access_profile_rec;
4239: get_accessProfileValues(l_access_profile_rec);

Line 4314: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4310: -- End of API body.
4311: --
4312:
4313: IF l_debug THEN
4314: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4315: 'x_update_access_flag: ' || x_update_access_flag);
4316:
4317: -- Debug Message
4318: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 4318: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4314: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4315: 'x_update_access_flag: ' || x_update_access_flag);
4316:
4317: -- Debug Message
4318: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4319: 'Private API: ' || l_api_name || 'end');
4320:
4321: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
4322: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 4321: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

4317: -- Debug Message
4318: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4319: 'Private API: ' || l_api_name || 'end');
4320:
4321: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
4322: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4323: END IF;
4324:
4325:

Line 4326: FND_MSG_PUB.Count_And_Get

4322: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4323: END IF;
4324:
4325:
4326: FND_MSG_PUB.Count_And_Get
4327: ( p_count => x_msg_count,
4328: p_data => x_msg_data
4329: );
4330:

Line 4337: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4333: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4334: P_MODULE => l_module
4335: ,P_API_NAME => L_API_NAME
4336: ,P_PKG_NAME => G_PKG_NAME
4337: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4338: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
4339: , P_ROLLBACK_FLAG => 'N'
4340: ,X_MSG_COUNT => X_MSG_COUNT
4341: ,X_MSG_DATA => X_MSG_DATA

Line 4349: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4345: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4346: P_MODULE => l_module
4347: ,P_API_NAME => L_API_NAME
4348: ,P_PKG_NAME => G_PKG_NAME
4349: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4350: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
4351: , P_ROLLBACK_FLAG => 'N'
4352: ,X_MSG_COUNT => X_MSG_COUNT
4353: ,X_MSG_DATA => X_MSG_DATA

Line 4439: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

4435: and a.salesforce_role_code = 'AM'
4436: and rm.parent_sales_group_id = p_admin_group_id
4437: and lead.sales_lead_id = p_sales_lead_id;
4438:
4439: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
4440: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acspv.has_viewLeadAccess';
4441:
4442: begin
4443: -- Standard call to check for call compatibility.

Line 4455: FND_MSG_PUB.initialize;

4451:
4452: -- Initialize message list if p_init_msg_list is set to TRUE.
4453: IF FND_API.to_Boolean( p_init_msg_list )
4454: THEN
4455: FND_MSG_PUB.initialize;
4456: END IF;
4457:
4458: -- Debug Message
4459: IF l_debug THEN

Line 4460: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4456: END IF;
4457:
4458: -- Debug Message
4459: IF l_debug THEN
4460: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4461: 'Private API: ' || l_api_name || 'start');
4462:
4463: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4464: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 4463: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4459: IF l_debug THEN
4460: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4461: 'Private API: ' || l_api_name || 'start');
4462:
4463: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4464: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4465: END IF;
4466:
4467: -- Initialize API return status to SUCCESS

Line 4471: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4467: -- Initialize API return status to SUCCESS
4468: x_return_status := FND_API.G_RET_STS_SUCCESS;
4469:
4470: IF l_debug THEN
4471: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4472: 'p_sales_lead_id: ' || p_sales_lead_id);
4473: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4474: 'ident salesforce_id: ' || p_identity_salesforce_id);
4475: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 4473: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4469:
4470: IF l_debug THEN
4471: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4472: 'p_sales_lead_id: ' || p_sales_lead_id);
4473: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4474: 'ident salesforce_id: ' || p_identity_salesforce_id);
4475: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4476: 'p_admin_group_id: ' || p_admin_group_id);
4477: END IF;

Line 4475: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4471: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4472: 'p_sales_lead_id: ' || p_sales_lead_id);
4473: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4474: 'ident salesforce_id: ' || p_identity_salesforce_id);
4475: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4476: 'p_admin_group_id: ' || p_admin_group_id);
4477: END IF;
4478:
4479: --

Line 4549: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4545: -- End of API body.
4546: --
4547:
4548: IF l_debug THEN
4549: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4550: 'x_view_access_flag: ' || x_view_access_flag);
4551:
4552: -- Debug Message
4553: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 4553: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4549: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4550: 'x_view_access_flag: ' || x_view_access_flag);
4551:
4552: -- Debug Message
4553: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4554: 'Private API: ' || l_api_name || 'end');
4555:
4556: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
4557: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 4556: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

4552: -- Debug Message
4553: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4554: 'Private API: ' || l_api_name || 'end');
4555:
4556: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
4557: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4558: END IF;
4559:
4560: FND_MSG_PUB.Count_And_Get

Line 4560: FND_MSG_PUB.Count_And_Get

4556: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
4557: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4558: END IF;
4559:
4560: FND_MSG_PUB.Count_And_Get
4561: ( p_count => x_msg_count,
4562: p_data => x_msg_data
4563: );
4564:

Line 4571: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4567: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4568: P_MODULE => l_module
4569: ,P_API_NAME => L_API_NAME
4570: ,P_PKG_NAME => G_PKG_NAME
4571: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4572: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
4573: , P_ROLLBACK_FLAG => 'N'
4574: ,X_MSG_COUNT => X_MSG_COUNT
4575: ,X_MSG_DATA => X_MSG_DATA

Line 4583: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4579: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4580: P_MODULE => l_module
4581: ,P_API_NAME => L_API_NAME
4582: ,P_PKG_NAME => G_PKG_NAME
4583: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4584: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
4585: , P_ROLLBACK_FLAG => 'N'
4586: ,X_MSG_COUNT => X_MSG_COUNT
4587: ,X_MSG_DATA => X_MSG_DATA

Line 4718: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

4714: from hr_operating_units hr
4715: where hr.organization_id = p_org_id
4716: and mo_global.check_access(hr.organization_id) = 'Y';
4717:
4718: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
4719: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acspv.has_updateOpportunityAccess';
4720:
4721: begin
4722: -- Standard call to check for call compatibility.

Line 4734: FND_MSG_PUB.initialize;

4730:
4731: -- Initialize message list if p_init_msg_list is set to TRUE.
4732: IF FND_API.to_Boolean( p_init_msg_list )
4733: THEN
4734: FND_MSG_PUB.initialize;
4735: END IF;
4736:
4737: -- Debug Message
4738: IF l_debug THEN

Line 4739: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4735: END IF;
4736:
4737: -- Debug Message
4738: IF l_debug THEN
4739: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4740: 'Private API: ' || l_api_name || 'start');
4741:
4742: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4743: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 4742: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4738: IF l_debug THEN
4739: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4740: 'Private API: ' || l_api_name || 'start');
4741:
4742: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4743: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4744: END IF;
4745:
4746: -- Initialize API return status to SUCCESS

Line 4750: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4746: -- Initialize API return status to SUCCESS
4747: x_return_status := FND_API.G_RET_STS_SUCCESS;
4748:
4749: IF l_debug THEN
4750: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4751: 'p_opportunity_id: ' || p_opportunity_id);
4752: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4753: 'ident salesforce_id: ' || p_identity_salesforce_id);
4754: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 4752: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4748:
4749: IF l_debug THEN
4750: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4751: 'p_opportunity_id: ' || p_opportunity_id);
4752: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4753: 'ident salesforce_id: ' || p_identity_salesforce_id);
4754: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4755: 'p_admin_group_id: ' || p_admin_group_id);
4756: END IF;

Line 4754: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4750: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4751: 'p_opportunity_id: ' || p_opportunity_id);
4752: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4753: 'ident salesforce_id: ' || p_identity_salesforce_id);
4754: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4755: 'p_admin_group_id: ' || p_admin_group_id);
4756: END IF;
4757:
4758: --

Line 4788: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4784: get_person_id(p_identity_salesforce_id, l_person_id);
4785: else
4786: l_person_id := p_person_id;
4787: end if;
4788: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4789: 'person id: ' || l_person_id);
4790: */
4791: l_access_profile_rec := p_access_profile_rec;
4792: get_accessProfileValues(l_access_profile_rec);

Line 4900: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4896: -- End of API body.
4897: --
4898:
4899: IF l_debug THEN
4900: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4901: 'x_update_access_flag: ' || x_update_access_flag);
4902:
4903: -- Debug Message
4904: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 4904: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4900: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4901: 'x_update_access_flag: ' || x_update_access_flag);
4902:
4903: -- Debug Message
4904: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4905: 'Private API: ' || l_api_name || 'end');
4906:
4907: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
4908: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 4907: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

4903: -- Debug Message
4904: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4905: 'Private API: ' || l_api_name || 'end');
4906:
4907: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
4908: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4909: END IF;
4910:
4911:

Line 4912: FND_MSG_PUB.Count_And_Get

4908: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4909: END IF;
4910:
4911:
4912: FND_MSG_PUB.Count_And_Get
4913: ( p_count => x_msg_count,
4914: p_data => x_msg_data
4915: );
4916:

Line 4923: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4919: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4920: P_MODULE => l_module
4921: ,P_API_NAME => L_API_NAME
4922: ,P_PKG_NAME => G_PKG_NAME
4923: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4924: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
4925: , P_ROLLBACK_FLAG => 'N'
4926: ,X_MSG_COUNT => X_MSG_COUNT
4927: ,X_MSG_DATA => X_MSG_DATA

Line 4935: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4931: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4932: P_MODULE => l_module
4933: ,P_API_NAME => L_API_NAME
4934: ,P_PKG_NAME => G_PKG_NAME
4935: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4936: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
4937: , P_ROLLBACK_FLAG => 'N'
4938: ,X_MSG_COUNT => X_MSG_COUNT
4939: ,X_MSG_DATA => X_MSG_DATA

Line 5041: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

5037: from hr_operating_units hr
5038: where hr.organization_id = p_org_id
5039: and mo_global.check_access(hr.organization_id) = 'Y';
5040:
5041: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
5042: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acspv.has_viewOpportunityAccess';
5043:
5044: begin
5045: -- Standard call to check for call compatibility.

Line 5057: FND_MSG_PUB.initialize;

5053:
5054: -- Initialize message list if p_init_msg_list is set to TRUE.
5055: IF FND_API.to_Boolean( p_init_msg_list )
5056: THEN
5057: FND_MSG_PUB.initialize;
5058: END IF;
5059:
5060: -- Debug Message
5061: IF l_debug THEN

Line 5062: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5058: END IF;
5059:
5060: -- Debug Message
5061: IF l_debug THEN
5062: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5063: 'Private API: ' || l_api_name || 'start');
5064:
5065: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5066: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 5065: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5061: IF l_debug THEN
5062: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5063: 'Private API: ' || l_api_name || 'start');
5064:
5065: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5066: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
5067: END IF;
5068:
5069: -- Initialize API return status to SUCCESS

Line 5073: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5069: -- Initialize API return status to SUCCESS
5070: x_return_status := FND_API.G_RET_STS_SUCCESS;
5071:
5072: IF l_debug THEN
5073: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5074: 'p_opportunity_id: ' || p_opportunity_id);
5075: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5076: 'ident salesforce_id: ' || p_identity_salesforce_id);
5077: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 5075: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5071:
5072: IF l_debug THEN
5073: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5074: 'p_opportunity_id: ' || p_opportunity_id);
5075: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5076: 'ident salesforce_id: ' || p_identity_salesforce_id);
5077: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5078: 'p_admin_group_id: ' || p_admin_group_id);
5079: END IF;

Line 5077: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5073: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5074: 'p_opportunity_id: ' || p_opportunity_id);
5075: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5076: 'ident salesforce_id: ' || p_identity_salesforce_id);
5077: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5078: 'p_admin_group_id: ' || p_admin_group_id);
5079: END IF;
5080:
5081: --

Line 5184: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5180: -- End of API body.
5181: --
5182:
5183: IF l_debug THEN
5184: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5185: 'x_view_access_flag: ' || x_view_access_flag);
5186:
5187: -- Debug Message
5188: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 5188: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5184: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5185: 'x_view_access_flag: ' || x_view_access_flag);
5186:
5187: -- Debug Message
5188: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5189: 'Private API: ' || l_api_name || 'end');
5190:
5191: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
5192: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 5191: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

5187: -- Debug Message
5188: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5189: 'Private API: ' || l_api_name || 'end');
5190:
5191: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
5192: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
5193: END IF;
5194:
5195:

Line 5196: FND_MSG_PUB.Count_And_Get

5192: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
5193: END IF;
5194:
5195:
5196: FND_MSG_PUB.Count_And_Get
5197: ( p_count => x_msg_count,
5198: p_data => x_msg_data
5199: );
5200:

Line 5207: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

5203: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
5204: P_MODULE => l_module
5205: ,P_API_NAME => L_API_NAME
5206: ,P_PKG_NAME => G_PKG_NAME
5207: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5208: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
5209: , P_ROLLBACK_FLAG => 'N'
5210: ,X_MSG_COUNT => X_MSG_COUNT
5211: ,X_MSG_DATA => X_MSG_DATA

Line 5219: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

5215: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
5216: P_MODULE => l_module
5217: ,P_API_NAME => L_API_NAME
5218: ,P_PKG_NAME => G_PKG_NAME
5219: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5220: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
5221: , P_ROLLBACK_FLAG => 'N'
5222: ,X_MSG_COUNT => X_MSG_COUNT
5223: ,X_MSG_DATA => X_MSG_DATA