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

3195: FND_MSG_PUB.Add;
3196: END IF;
3197:
3198: WHEN FND_API.G_EXC_ERROR THEN
3199: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3200: P_MODULE => l_module
3201: ,P_API_NAME => L_API_NAME
3202: ,P_PKG_NAME => G_PKG_NAME
3203: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 3204: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 3210: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3206: ,X_MSG_DATA => X_MSG_DATA
3207: ,X_RETURN_STATUS => X_RETURN_STATUS);
3208:
3209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3210: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3211: P_MODULE => l_module
3212: ,P_API_NAME => L_API_NAME
3213: ,P_PKG_NAME => G_PKG_NAME
3214: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 3215: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 3221: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 3225: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

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

Line 3228: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3678: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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

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

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

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

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

Line 3743: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3739: );
3740:
3741: EXCEPTION
3742: WHEN FND_API.G_EXC_ERROR THEN
3743: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3744: P_MODULE => l_module
3745: ,P_API_NAME => L_API_NAME
3746: ,P_PKG_NAME => G_PKG_NAME
3747: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 3748: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 3755: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3751: ,X_MSG_DATA => X_MSG_DATA
3752: ,X_RETURN_STATUS => X_RETURN_STATUS);
3753:
3754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3755: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3756: P_MODULE => l_module
3757: ,P_API_NAME => L_API_NAME
3758: ,P_PKG_NAME => G_PKG_NAME
3759: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 3760: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 3767: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 3771: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

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

Line 3774: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

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

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

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

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

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

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

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

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

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

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

Line 3937: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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

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

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

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

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

Line 4032: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4028: );
4029:
4030: EXCEPTION
4031: WHEN FND_API.G_EXC_ERROR THEN
4032: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4033: P_MODULE => l_module
4034: ,P_API_NAME => L_API_NAME
4035: ,P_PKG_NAME => G_PKG_NAME
4036: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 4037: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 4044: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4040: ,X_MSG_DATA => X_MSG_DATA
4041: ,X_RETURN_STATUS => X_RETURN_STATUS);
4042:
4043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4044: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4045: P_MODULE => l_module
4046: ,P_API_NAME => L_API_NAME
4047: ,P_PKG_NAME => G_PKG_NAME
4048: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 4049: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 4056: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 4060: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

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

Line 4063: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

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

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

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

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

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

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

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

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

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

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

Line 4235: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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

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

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

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

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

Line 4333: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4329: );
4330:
4331: EXCEPTION
4332: WHEN FND_API.G_EXC_ERROR THEN
4333: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4334: P_MODULE => l_module
4335: ,P_API_NAME => L_API_NAME
4336: ,P_PKG_NAME => G_PKG_NAME
4337: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 4338: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 4345: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4341: ,X_MSG_DATA => X_MSG_DATA
4342: ,X_RETURN_STATUS => X_RETURN_STATUS);
4343:
4344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4345: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4346: P_MODULE => l_module
4347: ,P_API_NAME => L_API_NAME
4348: ,P_PKG_NAME => G_PKG_NAME
4349: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 4350: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 4357: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 4361: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

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

Line 4364: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4567: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4563: );
4564:
4565: EXCEPTION
4566: WHEN FND_API.G_EXC_ERROR THEN
4567: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4568: P_MODULE => l_module
4569: ,P_API_NAME => L_API_NAME
4570: ,P_PKG_NAME => G_PKG_NAME
4571: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 4572: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 4579: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4575: ,X_MSG_DATA => X_MSG_DATA
4576: ,X_RETURN_STATUS => X_RETURN_STATUS);
4577:
4578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4579: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4580: P_MODULE => l_module
4581: ,P_API_NAME => L_API_NAME
4582: ,P_PKG_NAME => G_PKG_NAME
4583: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 4584: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 4591: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 4595: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

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

Line 4598: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

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

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

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

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

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

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

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

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

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

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

Line 4788: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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

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

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

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

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

Line 4919: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4915: );
4916:
4917: EXCEPTION
4918: WHEN FND_API.G_EXC_ERROR THEN
4919: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4920: P_MODULE => l_module
4921: ,P_API_NAME => L_API_NAME
4922: ,P_PKG_NAME => G_PKG_NAME
4923: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 4924: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 4931: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4927: ,X_MSG_DATA => X_MSG_DATA
4928: ,X_RETURN_STATUS => X_RETURN_STATUS);
4929:
4930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4931: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4932: P_MODULE => l_module
4933: ,P_API_NAME => L_API_NAME
4934: ,P_PKG_NAME => G_PKG_NAME
4935: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 4936: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 4943: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 4947: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

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

Line 4950: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 5203: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

5199: );
5200:
5201: EXCEPTION
5202: WHEN FND_API.G_EXC_ERROR THEN
5203: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
5204: P_MODULE => l_module
5205: ,P_API_NAME => L_API_NAME
5206: ,P_PKG_NAME => G_PKG_NAME
5207: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 5208: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 5215: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

5211: ,X_MSG_DATA => X_MSG_DATA
5212: ,X_RETURN_STATUS => X_RETURN_STATUS);
5213:
5214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5215: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
5216: P_MODULE => l_module
5217: ,P_API_NAME => L_API_NAME
5218: ,P_PKG_NAME => G_PKG_NAME
5219: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 5220: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 5227: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 5231: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

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

Line 5234: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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