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 3040: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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

Line 3043: FND_MSG_PUB.ADD;

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

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

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

Line 3057: FND_MSG_PUB.ADD;

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

Line 3171: FND_MSG_PUB.Count_And_Get

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

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

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

Line 3183: FND_MSG_PUB.ADD;

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

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

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

Line 3196: FND_MSG_PUB.Add;

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

Line 3204: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 3215: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3626: FND_MSG_PUB.initialize;

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

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

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

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

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

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

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

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

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

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

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

Line 3679: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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

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

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

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

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

Line 3737: FND_MSG_PUB.Count_And_Get

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

Line 3748: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 3760: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

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

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

Line 3885: FND_MSG_PUB.initialize;

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

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

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

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

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

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

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

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

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

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

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

Line 3938: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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

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

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

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

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

Line 4026: FND_MSG_PUB.Count_And_Get

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

Line 4037: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 4049: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

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

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

Line 4181: FND_MSG_PUB.initialize;

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

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

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

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

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

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

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

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

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

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

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

Line 4236: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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

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

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

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

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

Line 4327: FND_MSG_PUB.Count_And_Get

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

Line 4338: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 4350: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

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

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

Line 4456: FND_MSG_PUB.initialize;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4561: FND_MSG_PUB.Count_And_Get

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

Line 4572: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 4584: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

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

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

Line 4735: FND_MSG_PUB.initialize;

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

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

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

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

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

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

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

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

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

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

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

Line 4789: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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

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

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

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

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

Line 4913: FND_MSG_PUB.Count_And_Get

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

Line 4924: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 4936: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

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

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

Line 5058: FND_MSG_PUB.initialize;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 5197: FND_MSG_PUB.Count_And_Get

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

Line 5208: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 5220: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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