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 AS_UTILITY_PVT

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 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 437: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

433: );
434:
435: EXCEPTION
436: WHEN FND_API.G_EXC_ERROR THEN
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

Line 442: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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
446: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 449: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

445: ,X_MSG_DATA => X_MSG_DATA
446: ,X_RETURN_STATUS => X_RETURN_STATUS);
447:
448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 454: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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
458: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 461: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

457: ,X_MSG_DATA => X_MSG_DATA
458: ,X_RETURN_STATUS => X_RETURN_STATUS);
459:
460: WHEN OTHERS THEN
461: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
462: P_MODULE => l_module
463: ,P_API_NAME => L_API_NAME
464: ,P_PKG_NAME => G_PKG_NAME
465: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 465: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

461: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
462: P_MODULE => l_module
463: ,P_API_NAME => L_API_NAME
464: ,P_PKG_NAME => G_PKG_NAME
465: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
466: ,P_SQLCODE => SQLCODE
467: ,P_SQLERRM => SQLERRM
468: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
469: , P_ROLLBACK_FLAG => 'N'

Line 468: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

464: ,P_PKG_NAME => G_PKG_NAME
465: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
466: ,P_SQLCODE => SQLCODE
467: ,P_SQLERRM => SQLERRM
468: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
469: , P_ROLLBACK_FLAG => 'N'
470: ,X_MSG_COUNT => X_MSG_COUNT
471: ,X_MSG_DATA => X_MSG_DATA
472: ,X_RETURN_STATUS => X_RETURN_STATUS);

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 715: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

711: );
712:
713: EXCEPTION
714: WHEN FND_API.G_EXC_ERROR THEN
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

Line 720: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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
724: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 727: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

723: ,X_MSG_DATA => X_MSG_DATA
724: ,X_RETURN_STATUS => X_RETURN_STATUS);
725:
726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 732: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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
736: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 739: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

735: ,X_MSG_DATA => X_MSG_DATA
736: ,X_RETURN_STATUS => X_RETURN_STATUS);
737:
738: WHEN OTHERS THEN
739: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
740: P_MODULE => l_module
741: ,P_API_NAME => L_API_NAME
742: ,P_PKG_NAME => G_PKG_NAME
743: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 743: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

739: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
740: P_MODULE => l_module
741: ,P_API_NAME => L_API_NAME
742: ,P_PKG_NAME => G_PKG_NAME
743: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
744: ,P_SQLCODE => SQLCODE
745: ,P_SQLERRM => SQLERRM
746: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
747: , P_ROLLBACK_FLAG => 'N'

Line 746: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

742: ,P_PKG_NAME => G_PKG_NAME
743: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
744: ,P_SQLCODE => SQLCODE
745: ,P_SQLERRM => SQLERRM
746: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
747: , P_ROLLBACK_FLAG => 'N'
748: ,X_MSG_COUNT => X_MSG_COUNT
749: ,X_MSG_DATA => X_MSG_DATA
750: ,X_RETURN_STATUS => X_RETURN_STATUS);

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 895: AS_UTILITY_PVT.Set_Message(

891: OPEN C_Check_Assign_Person (p_person_id);
892: FETCH C_Check_Assign_Person INTO l_val;
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',

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 965: AS_UTILITY_PVT.Set_Message(

961: OPEN C_Check_Assign_Salesforce (p_salesforce_id);
962: FETCH C_Check_Assign_Salesforce INTO l_val;
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',

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 1037: AS_UTILITY_PVT.Set_Message(

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,
1040: p_msg_name => 'API_INVALID_ID',
1041: p_token1 => 'COLUMN',

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 1061: AS_UTILITY_PVT.Set_Message(

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,
1064: p_msg_name => 'API_INVALID_ID',
1065: p_token1 => 'COLUMN',

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 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 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 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 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 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 2211: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2207:
2208: END IF;
2209:
2210: WHEN FND_API.G_EXC_ERROR THEN
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

Line 2216: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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);
2220:

Line 2222: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2218: ,X_MSG_DATA => X_MSG_DATA
2219: ,X_RETURN_STATUS => X_RETURN_STATUS);
2220:
2221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 2227: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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);
2231:

Line 2233: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2229: ,X_MSG_DATA => X_MSG_DATA
2230: ,X_RETURN_STATUS => X_RETURN_STATUS);
2231:
2232: WHEN OTHERS THEN
2233: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2234: P_MODULE => l_module
2235: ,P_API_NAME => L_API_NAME
2236: ,P_PKG_NAME => G_PKG_NAME
2237: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 2237: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

2233: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2234: P_MODULE => l_module
2235: ,P_API_NAME => L_API_NAME
2236: ,P_PKG_NAME => G_PKG_NAME
2237: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2238: ,P_SQLCODE => SQLCODE
2239: ,P_SQLERRM => SQLERRM
2240: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2241: ,X_MSG_COUNT => X_MSG_COUNT

Line 2240: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

2236: ,P_PKG_NAME => G_PKG_NAME
2237: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2238: ,P_SQLCODE => SQLCODE
2239: ,P_SQLERRM => SQLERRM
2240: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2241: ,X_MSG_COUNT => X_MSG_COUNT
2242: ,X_MSG_DATA => X_MSG_DATA
2243: ,X_RETURN_STATUS => X_RETURN_STATUS);
2244:

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 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 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 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 2585: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2581: );
2582:
2583: EXCEPTION
2584: WHEN FND_API.G_EXC_ERROR THEN
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

Line 2590: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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);
2594:

Line 2596: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2592: ,X_MSG_DATA => X_MSG_DATA
2593: ,X_RETURN_STATUS => X_RETURN_STATUS);
2594:
2595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 2601: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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);
2605:

Line 2607: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2603: ,X_MSG_DATA => X_MSG_DATA
2604: ,X_RETURN_STATUS => X_RETURN_STATUS);
2605:
2606: WHEN OTHERS THEN
2607: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2608: P_MODULE => l_module
2609: ,P_API_NAME => L_API_NAME
2610: ,P_PKG_NAME => G_PKG_NAME
2611: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 2611: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

2607: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2608: P_MODULE => l_module
2609: ,P_API_NAME => L_API_NAME
2610: ,P_PKG_NAME => G_PKG_NAME
2611: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2612: ,P_SQLCODE => SQLCODE
2613: ,P_SQLERRM => SQLERRM
2614: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2615: ,X_MSG_COUNT => X_MSG_COUNT

Line 2614: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

2610: ,P_PKG_NAME => G_PKG_NAME
2611: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2612: ,P_SQLCODE => SQLCODE
2613: ,P_SQLERRM => SQLERRM
2614: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2615: ,X_MSG_COUNT => X_MSG_COUNT
2616: ,X_MSG_DATA => X_MSG_DATA
2617: ,X_RETURN_STATUS => X_RETURN_STATUS);
2618:

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 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 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 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 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 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 3200: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3196: FND_MSG_PUB.Add;
3197: END IF;
3198:
3199: WHEN FND_API.G_EXC_ERROR THEN
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

Line 3205: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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);
3209:

Line 3211: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3207: ,X_MSG_DATA => X_MSG_DATA
3208: ,X_RETURN_STATUS => X_RETURN_STATUS);
3209:
3210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 3216: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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);
3220:

Line 3222: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3218: ,X_MSG_DATA => X_MSG_DATA
3219: ,X_RETURN_STATUS => X_RETURN_STATUS);
3220:
3221: WHEN OTHERS THEN
3222: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3223: P_MODULE => l_module
3224: ,P_API_NAME => L_API_NAME
3225: ,P_PKG_NAME => G_PKG_NAME
3226: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 3226: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

3222: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3223: P_MODULE => l_module
3224: ,P_API_NAME => L_API_NAME
3225: ,P_PKG_NAME => G_PKG_NAME
3226: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3227: ,P_SQLCODE => SQLCODE
3228: ,P_SQLERRM => SQLERRM
3229: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3230: ,X_MSG_COUNT => X_MSG_COUNT

Line 3229: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

3225: ,P_PKG_NAME => G_PKG_NAME
3226: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3227: ,P_SQLCODE => SQLCODE
3228: ,P_SQLERRM => SQLERRM
3229: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3230: ,X_MSG_COUNT => X_MSG_COUNT
3231: ,X_MSG_DATA => X_MSG_DATA
3232: ,X_RETURN_STATUS => X_RETURN_STATUS);
3233:

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 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 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 3744: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3740: );
3741:
3742: EXCEPTION
3743: WHEN FND_API.G_EXC_ERROR THEN
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

Line 3749: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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
3753: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3756: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3752: ,X_MSG_DATA => X_MSG_DATA
3753: ,X_RETURN_STATUS => X_RETURN_STATUS);
3754:
3755: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 3761: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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
3765: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3768: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3764: ,X_MSG_DATA => X_MSG_DATA
3765: ,X_RETURN_STATUS => X_RETURN_STATUS);
3766:
3767: WHEN OTHERS THEN
3768: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3769: P_MODULE => l_module
3770: ,P_API_NAME => L_API_NAME
3771: ,P_PKG_NAME => G_PKG_NAME
3772: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 3772: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

3768: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3769: P_MODULE => l_module
3770: ,P_API_NAME => L_API_NAME
3771: ,P_PKG_NAME => G_PKG_NAME
3772: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3773: ,P_SQLCODE => SQLCODE
3774: ,P_SQLERRM => SQLERRM
3775: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3776: , P_ROLLBACK_FLAG => 'N'

Line 3775: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

3771: ,P_PKG_NAME => G_PKG_NAME
3772: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3773: ,P_SQLCODE => SQLCODE
3774: ,P_SQLERRM => SQLERRM
3775: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3776: , P_ROLLBACK_FLAG => 'N'
3777: ,X_MSG_COUNT => X_MSG_COUNT
3778: ,X_MSG_DATA => X_MSG_DATA
3779: ,X_RETURN_STATUS => X_RETURN_STATUS);

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 4033: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4029: );
4030:
4031: EXCEPTION
4032: WHEN FND_API.G_EXC_ERROR THEN
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

Line 4038: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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
4042: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4045: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4041: ,X_MSG_DATA => X_MSG_DATA
4042: ,X_RETURN_STATUS => X_RETURN_STATUS);
4043:
4044: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 4050: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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
4054: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4057: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4053: ,X_MSG_DATA => X_MSG_DATA
4054: ,X_RETURN_STATUS => X_RETURN_STATUS);
4055:
4056: WHEN OTHERS THEN
4057: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4058: P_MODULE => l_module
4059: ,P_API_NAME => L_API_NAME
4060: ,P_PKG_NAME => G_PKG_NAME
4061: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 4061: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

4057: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4058: P_MODULE => l_module
4059: ,P_API_NAME => L_API_NAME
4060: ,P_PKG_NAME => G_PKG_NAME
4061: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4062: ,P_SQLCODE => SQLCODE
4063: ,P_SQLERRM => SQLERRM
4064: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
4065: , P_ROLLBACK_FLAG => 'N'

Line 4064: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

4060: ,P_PKG_NAME => G_PKG_NAME
4061: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4062: ,P_SQLCODE => SQLCODE
4063: ,P_SQLERRM => SQLERRM
4064: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
4065: , P_ROLLBACK_FLAG => 'N'
4066: ,X_MSG_COUNT => X_MSG_COUNT
4067: ,X_MSG_DATA => X_MSG_DATA
4068: ,X_RETURN_STATUS => X_RETURN_STATUS);

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 4334: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4330: );
4331:
4332: EXCEPTION
4333: WHEN FND_API.G_EXC_ERROR THEN
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

Line 4339: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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
4343: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4346: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4342: ,X_MSG_DATA => X_MSG_DATA
4343: ,X_RETURN_STATUS => X_RETURN_STATUS);
4344:
4345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 4351: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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
4355: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4358: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4354: ,X_MSG_DATA => X_MSG_DATA
4355: ,X_RETURN_STATUS => X_RETURN_STATUS);
4356:
4357: WHEN OTHERS THEN
4358: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4359: P_MODULE => l_module
4360: ,P_API_NAME => L_API_NAME
4361: ,P_PKG_NAME => G_PKG_NAME
4362: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 4362: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

4358: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4359: P_MODULE => l_module
4360: ,P_API_NAME => L_API_NAME
4361: ,P_PKG_NAME => G_PKG_NAME
4362: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4363: ,P_SQLCODE => SQLCODE
4364: ,P_SQLERRM => SQLERRM
4365: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
4366: , P_ROLLBACK_FLAG => 'N'

Line 4365: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

4361: ,P_PKG_NAME => G_PKG_NAME
4362: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4363: ,P_SQLCODE => SQLCODE
4364: ,P_SQLERRM => SQLERRM
4365: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
4366: , P_ROLLBACK_FLAG => 'N'
4367: ,X_MSG_COUNT => X_MSG_COUNT
4368: ,X_MSG_DATA => X_MSG_DATA
4369: ,X_RETURN_STATUS => X_RETURN_STATUS);

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 4568: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4564: );
4565:
4566: EXCEPTION
4567: WHEN FND_API.G_EXC_ERROR THEN
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

Line 4573: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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
4577: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4580: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4576: ,X_MSG_DATA => X_MSG_DATA
4577: ,X_RETURN_STATUS => X_RETURN_STATUS);
4578:
4579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 4585: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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
4589: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4592: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4588: ,X_MSG_DATA => X_MSG_DATA
4589: ,X_RETURN_STATUS => X_RETURN_STATUS);
4590:
4591: WHEN OTHERS THEN
4592: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4593: P_MODULE => l_module
4594: ,P_API_NAME => L_API_NAME
4595: ,P_PKG_NAME => G_PKG_NAME
4596: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 4596: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

4592: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4593: P_MODULE => l_module
4594: ,P_API_NAME => L_API_NAME
4595: ,P_PKG_NAME => G_PKG_NAME
4596: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4597: ,P_SQLCODE => SQLCODE
4598: ,P_SQLERRM => SQLERRM
4599: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
4600: , P_ROLLBACK_FLAG => 'N'

Line 4599: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

4595: ,P_PKG_NAME => G_PKG_NAME
4596: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4597: ,P_SQLCODE => SQLCODE
4598: ,P_SQLERRM => SQLERRM
4599: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
4600: , P_ROLLBACK_FLAG => 'N'
4601: ,X_MSG_COUNT => X_MSG_COUNT
4602: ,X_MSG_DATA => X_MSG_DATA
4603: ,X_RETURN_STATUS => X_RETURN_STATUS);

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 4920: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4916: );
4917:
4918: EXCEPTION
4919: WHEN FND_API.G_EXC_ERROR THEN
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

Line 4925: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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
4929: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4932: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4928: ,X_MSG_DATA => X_MSG_DATA
4929: ,X_RETURN_STATUS => X_RETURN_STATUS);
4930:
4931: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 4937: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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
4941: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4944: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4940: ,X_MSG_DATA => X_MSG_DATA
4941: ,X_RETURN_STATUS => X_RETURN_STATUS);
4942:
4943: WHEN OTHERS THEN
4944: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4945: P_MODULE => l_module
4946: ,P_API_NAME => L_API_NAME
4947: ,P_PKG_NAME => G_PKG_NAME
4948: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 4948: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

4944: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4945: P_MODULE => l_module
4946: ,P_API_NAME => L_API_NAME
4947: ,P_PKG_NAME => G_PKG_NAME
4948: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4949: ,P_SQLCODE => SQLCODE
4950: ,P_SQLERRM => SQLERRM
4951: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
4952: , P_ROLLBACK_FLAG => 'N'

Line 4951: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

4947: ,P_PKG_NAME => G_PKG_NAME
4948: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4949: ,P_SQLCODE => SQLCODE
4950: ,P_SQLERRM => SQLERRM
4951: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
4952: , P_ROLLBACK_FLAG => 'N'
4953: ,X_MSG_COUNT => X_MSG_COUNT
4954: ,X_MSG_DATA => X_MSG_DATA
4955: ,X_RETURN_STATUS => X_RETURN_STATUS);

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 5204: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

5200: );
5201:
5202: EXCEPTION
5203: WHEN FND_API.G_EXC_ERROR THEN
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

Line 5209: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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
5213: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 5216: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

5212: ,X_MSG_DATA => X_MSG_DATA
5213: ,X_RETURN_STATUS => X_RETURN_STATUS);
5214:
5215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 5221: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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
5225: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 5228: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

5224: ,X_MSG_DATA => X_MSG_DATA
5225: ,X_RETURN_STATUS => X_RETURN_STATUS);
5226:
5227: WHEN OTHERS THEN
5228: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
5229: P_MODULE => l_module
5230: ,P_API_NAME => L_API_NAME
5231: ,P_PKG_NAME => G_PKG_NAME
5232: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 5232: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

5228: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
5229: P_MODULE => l_module
5230: ,P_API_NAME => L_API_NAME
5231: ,P_PKG_NAME => G_PKG_NAME
5232: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
5233: ,P_SQLCODE => SQLCODE
5234: ,P_SQLERRM => SQLERRM
5235: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
5236: , P_ROLLBACK_FLAG => 'N'

Line 5235: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

5231: ,P_PKG_NAME => G_PKG_NAME
5232: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
5233: ,P_SQLCODE => SQLCODE
5234: ,P_SQLERRM => SQLERRM
5235: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
5236: , P_ROLLBACK_FLAG => 'N'
5237: ,X_MSG_COUNT => X_MSG_COUNT
5238: ,X_MSG_DATA => X_MSG_DATA
5239: ,X_RETURN_STATUS => X_RETURN_STATUS);