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_PUB dependencies on AS_UTILITY_PVT

Line 183: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

179:
180:
181: EXCEPTION
182: WHEN FND_API.G_EXC_ERROR THEN
183: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
184: P_MODULE => l_module
185: ,P_API_NAME => L_API_NAME
186: ,P_PKG_NAME => G_PKG_NAME
187: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 188: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

184: P_MODULE => l_module
185: ,P_API_NAME => L_API_NAME
186: ,P_PKG_NAME => G_PKG_NAME
187: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
188: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
189: ,X_MSG_COUNT => X_MSG_COUNT
190: ,X_MSG_DATA => X_MSG_DATA
191: ,X_RETURN_STATUS => X_RETURN_STATUS);
192:

Line 194: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

190: ,X_MSG_DATA => X_MSG_DATA
191: ,X_RETURN_STATUS => X_RETURN_STATUS);
192:
193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
194: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
195: P_MODULE => l_module
196: ,P_API_NAME => L_API_NAME
197: ,P_PKG_NAME => G_PKG_NAME
198: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 199: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

195: P_MODULE => l_module
196: ,P_API_NAME => L_API_NAME
197: ,P_PKG_NAME => G_PKG_NAME
198: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
199: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
200: ,X_MSG_COUNT => X_MSG_COUNT
201: ,X_MSG_DATA => X_MSG_DATA
202: ,X_RETURN_STATUS => X_RETURN_STATUS);
203:

Line 205: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

201: ,X_MSG_DATA => X_MSG_DATA
202: ,X_RETURN_STATUS => X_RETURN_STATUS);
203:
204: WHEN OTHERS THEN
205: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
206: P_MODULE => l_module
207: ,P_API_NAME => L_API_NAME
208: ,P_PKG_NAME => G_PKG_NAME
209: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 209: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

205: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
206: P_MODULE => l_module
207: ,P_API_NAME => L_API_NAME
208: ,P_PKG_NAME => G_PKG_NAME
209: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
210: ,P_SQLCODE => SQLCODE
211: ,P_SQLERRM => SQLERRM
212: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
213: ,X_MSG_COUNT => X_MSG_COUNT

Line 212: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

208: ,P_PKG_NAME => G_PKG_NAME
209: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
210: ,P_SQLCODE => SQLCODE
211: ,P_SQLERRM => SQLERRM
212: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
213: ,X_MSG_COUNT => X_MSG_COUNT
214: ,X_MSG_DATA => X_MSG_DATA
215: ,X_RETURN_STATUS => X_RETURN_STATUS);
216:

Line 302: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

298:
299:
300: EXCEPTION
301: WHEN FND_API.G_EXC_ERROR THEN
302: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
303: P_MODULE => l_module
304: ,P_API_NAME => L_API_NAME
305: ,P_PKG_NAME => G_PKG_NAME
306: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 307: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

303: P_MODULE => l_module
304: ,P_API_NAME => L_API_NAME
305: ,P_PKG_NAME => G_PKG_NAME
306: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
307: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
308: ,X_MSG_COUNT => X_MSG_COUNT
309: ,X_MSG_DATA => X_MSG_DATA
310: ,X_RETURN_STATUS => X_RETURN_STATUS);
311:

Line 313: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

309: ,X_MSG_DATA => X_MSG_DATA
310: ,X_RETURN_STATUS => X_RETURN_STATUS);
311:
312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
313: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
314: P_MODULE => l_module
315: ,P_API_NAME => L_API_NAME
316: ,P_PKG_NAME => G_PKG_NAME
317: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 318: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

314: P_MODULE => l_module
315: ,P_API_NAME => L_API_NAME
316: ,P_PKG_NAME => G_PKG_NAME
317: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
318: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
319: ,X_MSG_COUNT => X_MSG_COUNT
320: ,X_MSG_DATA => X_MSG_DATA
321: ,X_RETURN_STATUS => X_RETURN_STATUS);
322:

Line 324: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

320: ,X_MSG_DATA => X_MSG_DATA
321: ,X_RETURN_STATUS => X_RETURN_STATUS);
322:
323: WHEN OTHERS THEN
324: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
325: P_MODULE => l_module
326: ,P_API_NAME => L_API_NAME
327: ,P_PKG_NAME => G_PKG_NAME
328: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 328: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

324: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
325: P_MODULE => l_module
326: ,P_API_NAME => L_API_NAME
327: ,P_PKG_NAME => G_PKG_NAME
328: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
329: ,P_SQLCODE => SQLCODE
330: ,P_SQLERRM => SQLERRM
331: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
332: ,X_MSG_COUNT => X_MSG_COUNT

Line 331: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

327: ,P_PKG_NAME => G_PKG_NAME
328: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
329: ,P_SQLCODE => SQLCODE
330: ,P_SQLERRM => SQLERRM
331: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
332: ,X_MSG_COUNT => X_MSG_COUNT
333: ,X_MSG_DATA => X_MSG_DATA
334: ,X_RETURN_STATUS => X_RETURN_STATUS);
335:

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

410: END IF;
411:
412: -- Debug Message
413: IF l_debug THEN
414: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
415: 'Public API: ' || l_api_name || 'start');
416:
417: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
418: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

413: IF l_debug THEN
414: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
415: 'Public API: ' || l_api_name || 'start');
416:
417: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
418: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
419: END IF;
420:
421: -- Initialize API return status to SUCCESS

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

425: -- API body
426: --
427:
428: IF l_debug THEN
429: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
430: 'Public API: Calling AS_ACCESS_PVT.delete_salesTeam');
431: END IF;
432: Convert_Pub_Sales_Team_To_Pvt(p_sales_team_rec, l_pvt_sales_team_rec);
433:

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

467:
468:
469: -- Debug Message
470: IF l_debug THEN
471: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
472: 'Public API: ' || l_api_name || 'end');
473:
474: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
475: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

470: IF l_debug THEN
471: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
472: 'Public API: ' || l_api_name || 'end');
473:
474: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
475: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
476: END IF;
477:
478:

Line 486: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

482: );
483:
484: EXCEPTION
485: WHEN FND_API.G_EXC_ERROR THEN
486: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
487: P_MODULE => l_module
488: ,P_API_NAME => L_API_NAME
489: ,P_PKG_NAME => G_PKG_NAME
490: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 491: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

487: P_MODULE => l_module
488: ,P_API_NAME => L_API_NAME
489: ,P_PKG_NAME => G_PKG_NAME
490: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
491: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
492: ,X_MSG_COUNT => X_MSG_COUNT
493: ,X_MSG_DATA => X_MSG_DATA
494: ,X_RETURN_STATUS => X_RETURN_STATUS);
495:

Line 497: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

493: ,X_MSG_DATA => X_MSG_DATA
494: ,X_RETURN_STATUS => X_RETURN_STATUS);
495:
496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
497: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
498: P_MODULE => l_module
499: ,P_API_NAME => L_API_NAME
500: ,P_PKG_NAME => G_PKG_NAME
501: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 502: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

498: P_MODULE => l_module
499: ,P_API_NAME => L_API_NAME
500: ,P_PKG_NAME => G_PKG_NAME
501: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
502: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
503: ,X_MSG_COUNT => X_MSG_COUNT
504: ,X_MSG_DATA => X_MSG_DATA
505: ,X_RETURN_STATUS => X_RETURN_STATUS);
506:

Line 508: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

504: ,X_MSG_DATA => X_MSG_DATA
505: ,X_RETURN_STATUS => X_RETURN_STATUS);
506:
507: WHEN OTHERS THEN
508: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
509: P_MODULE => l_module
510: ,P_API_NAME => L_API_NAME
511: ,P_PKG_NAME => G_PKG_NAME
512: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 512: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

508: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
509: P_MODULE => l_module
510: ,P_API_NAME => L_API_NAME
511: ,P_PKG_NAME => G_PKG_NAME
512: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
513: ,P_SQLCODE => SQLCODE
514: ,P_SQLERRM => SQLERRM
515: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
516: ,X_MSG_COUNT => X_MSG_COUNT

Line 515: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

511: ,P_PKG_NAME => G_PKG_NAME
512: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
513: ,P_SQLCODE => SQLCODE
514: ,P_SQLERRM => SQLERRM
515: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
516: ,X_MSG_COUNT => X_MSG_COUNT
517: ,X_MSG_DATA => X_MSG_DATA
518: ,X_RETURN_STATUS => X_RETURN_STATUS);
519:

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

531: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acpub.validate_accessProfiles';
532:
533: begin
534: IF l_debug THEN
535: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
536: 'Val Access Profile start');
537: END IF;
538: x_return_status := FND_API.G_RET_STS_SUCCESS;
539:

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

549: END IF;
550: end if;
551:
552: IF l_debug THEN
553: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
554: 'Val Access Profile end');
555: END IF;
556:
557: FND_MSG_PUB.Count_And_Get

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

601: END IF;
602:
603: -- Debug Message
604: IF l_debug THEN
605: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
606: 'Public API: ' || l_api_name || 'start');
607:
608: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
609: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

604: IF l_debug THEN
605: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
606: 'Public API: ' || l_api_name || 'start');
607:
608: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
609: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
610: END IF;
611:
612: -- Initialize API return status to SUCCESS

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

612: -- Initialize API return status to SUCCESS
613: x_return_status := FND_API.G_RET_STS_SUCCESS;
614:
615: IF l_debug THEN
616: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
617: 'Public API: Calling as_access_pvt.has_viewCustomerAccess');
618: END IF;
619:
620:

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

647: --
648:
649: -- Debug Message
650: IF l_debug THEN
651: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
652: 'Public API: ' || l_api_name || 'end');
653:
654: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
655: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

650: IF l_debug THEN
651: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
652: 'Public API: ' || l_api_name || 'end');
653:
654: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
655: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
656: END IF;
657:
658:

Line 666: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

662: );
663:
664: EXCEPTION
665: WHEN FND_API.G_EXC_ERROR THEN
666: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
667: P_MODULE => l_module
668: ,P_API_NAME => L_API_NAME
669: ,P_PKG_NAME => G_PKG_NAME
670: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 671: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

667: P_MODULE => l_module
668: ,P_API_NAME => L_API_NAME
669: ,P_PKG_NAME => G_PKG_NAME
670: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
671: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
672: , P_ROLLBACK_FLAG => 'N'
673: ,X_MSG_COUNT => X_MSG_COUNT
674: ,X_MSG_DATA => X_MSG_DATA
675: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 678: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

674: ,X_MSG_DATA => X_MSG_DATA
675: ,X_RETURN_STATUS => X_RETURN_STATUS);
676:
677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
678: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
679: P_MODULE => l_module
680: ,P_API_NAME => L_API_NAME
681: ,P_PKG_NAME => G_PKG_NAME
682: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 683: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

679: P_MODULE => l_module
680: ,P_API_NAME => L_API_NAME
681: ,P_PKG_NAME => G_PKG_NAME
682: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
683: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
684: , P_ROLLBACK_FLAG => 'N'
685: ,X_MSG_COUNT => X_MSG_COUNT
686: ,X_MSG_DATA => X_MSG_DATA
687: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 690: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

686: ,X_MSG_DATA => X_MSG_DATA
687: ,X_RETURN_STATUS => X_RETURN_STATUS);
688:
689: WHEN OTHERS THEN
690: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
691: P_MODULE => l_module
692: ,P_API_NAME => L_API_NAME
693: ,P_PKG_NAME => G_PKG_NAME
694: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 694: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

690: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
691: P_MODULE => l_module
692: ,P_API_NAME => L_API_NAME
693: ,P_PKG_NAME => G_PKG_NAME
694: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
695: ,P_SQLCODE => SQLCODE
696: ,P_SQLERRM => SQLERRM
697: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
698: , P_ROLLBACK_FLAG => 'N'

Line 697: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

693: ,P_PKG_NAME => G_PKG_NAME
694: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
695: ,P_SQLCODE => SQLCODE
696: ,P_SQLERRM => SQLERRM
697: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
698: , P_ROLLBACK_FLAG => 'N'
699: ,X_MSG_COUNT => X_MSG_COUNT
700: ,X_MSG_DATA => X_MSG_DATA
701: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

742: END IF;
743:
744: -- Debug Message
745: IF l_debug THEN
746: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
747: 'Public API: ' || l_api_name || 'start');
748:
749: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
750: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

745: IF l_debug THEN
746: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
747: 'Public API: ' || l_api_name || 'start');
748:
749: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
750: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
751: END IF;
752:
753: -- Initialize API return status to SUCCESS

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

754: x_return_status := FND_API.G_RET_STS_SUCCESS;
755:
756:
757: IF l_debug THEN
758: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
759: 'Public API: Calling as_access_pvt.has_updateCustomerAccess');
760: END IF;
761:
762:

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

789: --
790:
791: -- Debug Message
792: IF l_debug THEN
793: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
794: 'Public API: ' || l_api_name || 'end');
795:
796: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
797: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

792: IF l_debug THEN
793: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
794: 'Public API: ' || l_api_name || 'end');
795:
796: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
797: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
798: END IF;
799:
800:

Line 808: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

804: );
805:
806: EXCEPTION
807: WHEN FND_API.G_EXC_ERROR THEN
808: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
809: P_MODULE => l_module
810: ,P_API_NAME => L_API_NAME
811: ,P_PKG_NAME => G_PKG_NAME
812: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 813: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

809: P_MODULE => l_module
810: ,P_API_NAME => L_API_NAME
811: ,P_PKG_NAME => G_PKG_NAME
812: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
813: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
814: , P_ROLLBACK_FLAG => 'N'
815: ,X_MSG_COUNT => X_MSG_COUNT
816: ,X_MSG_DATA => X_MSG_DATA
817: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 820: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

816: ,X_MSG_DATA => X_MSG_DATA
817: ,X_RETURN_STATUS => X_RETURN_STATUS);
818:
819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
820: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
821: P_MODULE => l_module
822: ,P_API_NAME => L_API_NAME
823: ,P_PKG_NAME => G_PKG_NAME
824: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 825: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

821: P_MODULE => l_module
822: ,P_API_NAME => L_API_NAME
823: ,P_PKG_NAME => G_PKG_NAME
824: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
825: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
826: , P_ROLLBACK_FLAG => 'N'
827: ,X_MSG_COUNT => X_MSG_COUNT
828: ,X_MSG_DATA => X_MSG_DATA
829: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 832: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

828: ,X_MSG_DATA => X_MSG_DATA
829: ,X_RETURN_STATUS => X_RETURN_STATUS);
830:
831: WHEN OTHERS THEN
832: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
833: P_MODULE => l_module
834: ,P_API_NAME => L_API_NAME
835: ,P_PKG_NAME => G_PKG_NAME
836: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 836: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

832: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
833: P_MODULE => l_module
834: ,P_API_NAME => L_API_NAME
835: ,P_PKG_NAME => G_PKG_NAME
836: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
837: ,P_SQLCODE => SQLCODE
838: ,P_SQLERRM => SQLERRM
839: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
840: , P_ROLLBACK_FLAG => 'N'

Line 839: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

835: ,P_PKG_NAME => G_PKG_NAME
836: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
837: ,P_SQLCODE => SQLCODE
838: ,P_SQLERRM => SQLERRM
839: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
840: , P_ROLLBACK_FLAG => 'N'
841: ,X_MSG_COUNT => X_MSG_COUNT
842: ,X_MSG_DATA => X_MSG_DATA
843: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

884: END IF;
885:
886: -- Debug Message
887: IF l_debug THEN
888: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
889: 'Public API: ' || l_api_name || 'start');
890:
891: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
892: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

887: IF l_debug THEN
888: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
889: 'Public API: ' || l_api_name || 'start');
890:
891: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
892: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
893: END IF;
894:
895: -- Initialize API return status to SUCCESS

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

896: x_return_status := FND_API.G_RET_STS_SUCCESS;
897:
898:
899: IF l_debug THEN
900: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
901: 'Public API: Calling as_access_pvt.has_updateLeadAccess');
902: END IF;
903:
904:

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

931: --
932:
933: -- Debug Message
934: IF l_debug THEN
935: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
936: 'Public API: ' || l_api_name || 'end');
937:
938: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
939: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

934: IF l_debug THEN
935: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
936: 'Public API: ' || l_api_name || 'end');
937:
938: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
939: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
940: END IF;
941:
942: FND_MSG_PUB.Count_And_Get

Line 949: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

945: );
946:
947: EXCEPTION
948: WHEN FND_API.G_EXC_ERROR THEN
949: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
950: P_MODULE => l_module
951: ,P_API_NAME => L_API_NAME
952: ,P_PKG_NAME => G_PKG_NAME
953: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 954: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

950: P_MODULE => l_module
951: ,P_API_NAME => L_API_NAME
952: ,P_PKG_NAME => G_PKG_NAME
953: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
954: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
955: , P_ROLLBACK_FLAG => 'N'
956: ,X_MSG_COUNT => X_MSG_COUNT
957: ,X_MSG_DATA => X_MSG_DATA
958: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 961: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

957: ,X_MSG_DATA => X_MSG_DATA
958: ,X_RETURN_STATUS => X_RETURN_STATUS);
959:
960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
961: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
962: P_MODULE => l_module
963: ,P_API_NAME => L_API_NAME
964: ,P_PKG_NAME => G_PKG_NAME
965: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 966: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

962: P_MODULE => l_module
963: ,P_API_NAME => L_API_NAME
964: ,P_PKG_NAME => G_PKG_NAME
965: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
966: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
967: , P_ROLLBACK_FLAG => 'N'
968: ,X_MSG_COUNT => X_MSG_COUNT
969: ,X_MSG_DATA => X_MSG_DATA
970: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 973: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

969: ,X_MSG_DATA => X_MSG_DATA
970: ,X_RETURN_STATUS => X_RETURN_STATUS);
971:
972: WHEN OTHERS THEN
973: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
974: P_MODULE => l_module
975: ,P_API_NAME => L_API_NAME
976: ,P_PKG_NAME => G_PKG_NAME
977: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 977: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

973: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
974: P_MODULE => l_module
975: ,P_API_NAME => L_API_NAME
976: ,P_PKG_NAME => G_PKG_NAME
977: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
978: ,P_SQLCODE => SQLCODE
979: ,P_SQLERRM => SQLERRM
980: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
981: , P_ROLLBACK_FLAG => 'N'

Line 980: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

976: ,P_PKG_NAME => G_PKG_NAME
977: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
978: ,P_SQLCODE => SQLCODE
979: ,P_SQLERRM => SQLERRM
980: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
981: , P_ROLLBACK_FLAG => 'N'
982: ,X_MSG_COUNT => X_MSG_COUNT
983: ,X_MSG_DATA => X_MSG_DATA
984: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

1026: END IF;
1027:
1028: -- Debug Message
1029: IF l_debug THEN
1030: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1031: 'Public API: ' || l_api_name || 'start');
1032:
1033: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1034: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1029: IF l_debug THEN
1030: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1031: 'Public API: ' || l_api_name || 'start');
1032:
1033: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1034: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1035: END IF;
1036:
1037: -- Initialize API return status to SUCCESS

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

1038: x_return_status := FND_API.G_RET_STS_SUCCESS;
1039:
1040:
1041: IF l_debug THEN
1042: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1043: 'Public API: Calling as_access_pvt.has_updateOpportunityAccess');
1044: END IF;
1045:
1046:

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

1073: --
1074:
1075: -- Debug Message
1076: IF l_debug THEN
1077: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1078: 'Public API: ' || l_api_name || 'end');
1079:
1080: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1081: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1076: IF l_debug THEN
1077: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1078: 'Public API: ' || l_api_name || 'end');
1079:
1080: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1081: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1082: END IF;
1083:
1084:

Line 1092: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1088: );
1089:
1090: EXCEPTION
1091: WHEN FND_API.G_EXC_ERROR THEN
1092: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1093: P_MODULE => l_module
1094: ,P_API_NAME => L_API_NAME
1095: ,P_PKG_NAME => G_PKG_NAME
1096: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1097: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1093: P_MODULE => l_module
1094: ,P_API_NAME => L_API_NAME
1095: ,P_PKG_NAME => G_PKG_NAME
1096: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1097: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1098: , P_ROLLBACK_FLAG => 'N'
1099: ,X_MSG_COUNT => X_MSG_COUNT
1100: ,X_MSG_DATA => X_MSG_DATA
1101: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1104: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1100: ,X_MSG_DATA => X_MSG_DATA
1101: ,X_RETURN_STATUS => X_RETURN_STATUS);
1102:
1103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1104: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1105: P_MODULE => l_module
1106: ,P_API_NAME => L_API_NAME
1107: ,P_PKG_NAME => G_PKG_NAME
1108: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1109: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1105: P_MODULE => l_module
1106: ,P_API_NAME => L_API_NAME
1107: ,P_PKG_NAME => G_PKG_NAME
1108: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1109: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1110: , P_ROLLBACK_FLAG => 'N'
1111: ,X_MSG_COUNT => X_MSG_COUNT
1112: ,X_MSG_DATA => X_MSG_DATA
1113: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1116: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1112: ,X_MSG_DATA => X_MSG_DATA
1113: ,X_RETURN_STATUS => X_RETURN_STATUS);
1114:
1115: WHEN OTHERS THEN
1116: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1117: P_MODULE => l_module
1118: ,P_API_NAME => L_API_NAME
1119: ,P_PKG_NAME => G_PKG_NAME
1120: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 1120: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1116: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1117: P_MODULE => l_module
1118: ,P_API_NAME => L_API_NAME
1119: ,P_PKG_NAME => G_PKG_NAME
1120: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1121: ,P_SQLCODE => SQLCODE
1122: ,P_SQLERRM => SQLERRM
1123: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1124: , P_ROLLBACK_FLAG => 'N'

Line 1123: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1119: ,P_PKG_NAME => G_PKG_NAME
1120: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1121: ,P_SQLCODE => SQLCODE
1122: ,P_SQLERRM => SQLERRM
1123: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1124: , P_ROLLBACK_FLAG => 'N'
1125: ,X_MSG_COUNT => X_MSG_COUNT
1126: ,X_MSG_DATA => X_MSG_DATA
1127: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

1262: END IF;
1263:
1264: -- Debug Message
1265: IF l_debug THEN
1266: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1267: 'Public API: ' || l_api_name || 'start');
1268:
1269: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1270: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1265: IF l_debug THEN
1266: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1267: 'Public API: ' || l_api_name || 'start');
1268:
1269: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1270: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1271: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1272: 'p_security_id: ' || p_security_id);
1273: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

1267: 'Public API: ' || l_api_name || 'start');
1268:
1269: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1270: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1271: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1272: 'p_security_id: ' || p_security_id);
1273: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1274: 'p_security_type: ' || p_security_type);
1275: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

1269: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1270: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1271: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1272: 'p_security_id: ' || p_security_id);
1273: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1274: 'p_security_type: ' || p_security_type);
1275: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1276: 'p_person_party_id: ' || p_person_party_id);
1277: END IF;

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

1271: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1272: 'p_security_id: ' || p_security_id);
1273: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1274: 'p_security_type: ' || p_security_type);
1275: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1276: 'p_person_party_id: ' || p_person_party_id);
1277: END IF;
1278:
1279: -- Initialize API return status to SUCCESS

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

1283: ,p_security_type => p_security_type
1284: ,p_person_party_id => p_person_party_id
1285: ,x_valid_flag => l_valid_flag);
1286: IF l_debug THEN
1287: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1288: 'valid id flag: ' || l_valid_flag);
1289: END IF;
1290: if l_valid_flag = 'N'
1291: then

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

1395: --
1396:
1397: -- Debug Message
1398: IF l_debug THEN
1399: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1400: 'Public API: ' || l_api_name || 'end');
1401:
1402: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1403: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1398: IF l_debug THEN
1399: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1400: 'Public API: ' || l_api_name || 'end');
1401:
1402: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1403: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1404: END IF;
1405:
1406:

Line 1414: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1410: );
1411:
1412: EXCEPTION
1413: WHEN FND_API.G_EXC_ERROR THEN
1414: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1415: P_MODULE => l_module
1416: ,P_API_NAME => L_API_NAME
1417: ,P_PKG_NAME => G_PKG_NAME
1418: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1419: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1415: P_MODULE => l_module
1416: ,P_API_NAME => L_API_NAME
1417: ,P_PKG_NAME => G_PKG_NAME
1418: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1419: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1420: , P_ROLLBACK_FLAG => 'N'
1421: ,X_MSG_COUNT => X_MSG_COUNT
1422: ,X_MSG_DATA => X_MSG_DATA
1423: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1426: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1422: ,X_MSG_DATA => X_MSG_DATA
1423: ,X_RETURN_STATUS => X_RETURN_STATUS);
1424:
1425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1426: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1427: P_MODULE => l_module
1428: ,P_API_NAME => L_API_NAME
1429: ,P_PKG_NAME => G_PKG_NAME
1430: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1431: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1427: P_MODULE => l_module
1428: ,P_API_NAME => L_API_NAME
1429: ,P_PKG_NAME => G_PKG_NAME
1430: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1431: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1432: , P_ROLLBACK_FLAG => 'N'
1433: ,X_MSG_COUNT => X_MSG_COUNT
1434: ,X_MSG_DATA => X_MSG_DATA
1435: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1438: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1434: ,X_MSG_DATA => X_MSG_DATA
1435: ,X_RETURN_STATUS => X_RETURN_STATUS);
1436:
1437: WHEN OTHERS THEN
1438: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1439: P_MODULE => l_module
1440: ,P_API_NAME => L_API_NAME
1441: ,P_PKG_NAME => G_PKG_NAME
1442: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 1442: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1438: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1439: P_MODULE => l_module
1440: ,P_API_NAME => L_API_NAME
1441: ,P_PKG_NAME => G_PKG_NAME
1442: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1443: ,P_SQLCODE => SQLCODE
1444: ,P_SQLERRM => SQLERRM
1445: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1446: , P_ROLLBACK_FLAG => 'N'

Line 1445: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1441: ,P_PKG_NAME => G_PKG_NAME
1442: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1443: ,P_SQLCODE => SQLCODE
1444: ,P_SQLERRM => SQLERRM
1445: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1446: , P_ROLLBACK_FLAG => 'N'
1447: ,X_MSG_COUNT => X_MSG_COUNT
1448: ,X_MSG_DATA => X_MSG_DATA
1449: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

1493: END IF;
1494:
1495: -- Debug Message
1496: IF l_debug THEN
1497: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1498: 'Public API: ' || l_api_name || 'start');
1499:
1500: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1501: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1496: IF l_debug THEN
1497: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1498: 'Public API: ' || l_api_name || 'start');
1499:
1500: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1501: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1502: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1503: 'p_security_id: ' || p_security_id);
1504: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

1498: 'Public API: ' || l_api_name || 'start');
1499:
1500: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1501: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1502: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1503: 'p_security_id: ' || p_security_id);
1504: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1505: 'p_security_type: ' || p_security_type);
1506: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

1500: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1501: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1502: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1503: 'p_security_id: ' || p_security_id);
1504: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1505: 'p_security_type: ' || p_security_type);
1506: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1507: 'p_person_party_id: ' || p_person_party_id);
1508: END IF;

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

1502: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1503: 'p_security_id: ' || p_security_id);
1504: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1505: 'p_security_type: ' || p_security_type);
1506: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1507: 'p_person_party_id: ' || p_person_party_id);
1508: END IF;
1509:
1510: -- Initialize API return status to SUCCESS

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

1514: ,p_security_type => p_security_type
1515: ,p_person_party_id => p_person_party_id
1516: ,x_valid_flag => l_valid_flag);
1517: IF l_debug THEN
1518: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1519: 'valid id flag: ' || l_valid_flag);
1520: END IF;
1521:
1522: if l_valid_flag = 'N'

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

1627: --
1628:
1629: -- Debug Message
1630: IF l_debug THEN
1631: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1632: 'Public API: ' || l_api_name || 'end');
1633:
1634: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1635: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1630: IF l_debug THEN
1631: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1632: 'Public API: ' || l_api_name || 'end');
1633:
1634: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1635: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1636: END IF;
1637:
1638:

Line 1646: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1642: );
1643:
1644: EXCEPTION
1645: WHEN FND_API.G_EXC_ERROR THEN
1646: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1647: P_MODULE => l_module
1648: ,P_API_NAME => L_API_NAME
1649: ,P_PKG_NAME => G_PKG_NAME
1650: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1651: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1647: P_MODULE => l_module
1648: ,P_API_NAME => L_API_NAME
1649: ,P_PKG_NAME => G_PKG_NAME
1650: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1651: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1652: , P_ROLLBACK_FLAG => 'N'
1653: ,X_MSG_COUNT => X_MSG_COUNT
1654: ,X_MSG_DATA => X_MSG_DATA
1655: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1658: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1654: ,X_MSG_DATA => X_MSG_DATA
1655: ,X_RETURN_STATUS => X_RETURN_STATUS);
1656:
1657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1658: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1659: P_MODULE => l_module
1660: ,P_API_NAME => L_API_NAME
1661: ,P_PKG_NAME => G_PKG_NAME
1662: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1663: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1659: P_MODULE => l_module
1660: ,P_API_NAME => L_API_NAME
1661: ,P_PKG_NAME => G_PKG_NAME
1662: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1663: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1664: , P_ROLLBACK_FLAG => 'N'
1665: ,X_MSG_COUNT => X_MSG_COUNT
1666: ,X_MSG_DATA => X_MSG_DATA
1667: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1670: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1666: ,X_MSG_DATA => X_MSG_DATA
1667: ,X_RETURN_STATUS => X_RETURN_STATUS);
1668:
1669: WHEN OTHERS THEN
1670: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1671: P_MODULE => l_module
1672: ,P_API_NAME => L_API_NAME
1673: ,P_PKG_NAME => G_PKG_NAME
1674: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 1674: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1670: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1671: P_MODULE => l_module
1672: ,P_API_NAME => L_API_NAME
1673: ,P_PKG_NAME => G_PKG_NAME
1674: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1675: ,P_SQLCODE => SQLCODE
1676: ,P_SQLERRM => SQLERRM
1677: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1678: , P_ROLLBACK_FLAG => 'N'

Line 1677: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1673: ,P_PKG_NAME => G_PKG_NAME
1674: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1675: ,P_SQLCODE => SQLCODE
1676: ,P_SQLERRM => SQLERRM
1677: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1678: , P_ROLLBACK_FLAG => 'N'
1679: ,X_MSG_COUNT => X_MSG_COUNT
1680: ,X_MSG_DATA => X_MSG_DATA
1681: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

1722: END IF;
1723:
1724: -- Debug Message
1725: IF l_debug THEN
1726: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1727: 'Public API: ' || l_api_name || 'start');
1728:
1729: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1730: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1725: IF l_debug THEN
1726: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1727: 'Public API: ' || l_api_name || 'start');
1728:
1729: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1730: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1731: END IF;
1732:
1733: -- Initialize API return status to SUCCESS

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

1734: x_return_status := FND_API.G_RET_STS_SUCCESS;
1735:
1736:
1737: IF l_debug THEN
1738: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1739: 'Public API: Calling as_access_pvt.has_viewLeadAccess');
1740: END IF;
1741:
1742:

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

1769: --
1770:
1771: -- Debug Message
1772: IF l_debug THEN
1773: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1774: 'Public API: ' || l_api_name || 'end');
1775:
1776: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1777: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1772: IF l_debug THEN
1773: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1774: 'Public API: ' || l_api_name || 'end');
1775:
1776: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1777: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1778: END IF;
1779:
1780:

Line 1788: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1784: );
1785:
1786: EXCEPTION
1787: WHEN FND_API.G_EXC_ERROR THEN
1788: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1789: P_MODULE => l_module
1790: ,P_API_NAME => L_API_NAME
1791: ,P_PKG_NAME => G_PKG_NAME
1792: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1793: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1789: P_MODULE => l_module
1790: ,P_API_NAME => L_API_NAME
1791: ,P_PKG_NAME => G_PKG_NAME
1792: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1793: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1794: , P_ROLLBACK_FLAG => 'N'
1795: ,X_MSG_COUNT => X_MSG_COUNT
1796: ,X_MSG_DATA => X_MSG_DATA
1797: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1800: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1796: ,X_MSG_DATA => X_MSG_DATA
1797: ,X_RETURN_STATUS => X_RETURN_STATUS);
1798:
1799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1800: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1801: P_MODULE => l_module
1802: ,P_API_NAME => L_API_NAME
1803: ,P_PKG_NAME => G_PKG_NAME
1804: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1805: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1801: P_MODULE => l_module
1802: ,P_API_NAME => L_API_NAME
1803: ,P_PKG_NAME => G_PKG_NAME
1804: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1805: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1806: , P_ROLLBACK_FLAG => 'N'
1807: ,X_MSG_COUNT => X_MSG_COUNT
1808: ,X_MSG_DATA => X_MSG_DATA
1809: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1812: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1808: ,X_MSG_DATA => X_MSG_DATA
1809: ,X_RETURN_STATUS => X_RETURN_STATUS);
1810:
1811: WHEN OTHERS THEN
1812: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1813: P_MODULE => l_module
1814: ,P_API_NAME => L_API_NAME
1815: ,P_PKG_NAME => G_PKG_NAME
1816: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 1816: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1812: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1813: P_MODULE => l_module
1814: ,P_API_NAME => L_API_NAME
1815: ,P_PKG_NAME => G_PKG_NAME
1816: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1817: ,P_SQLCODE => SQLCODE
1818: ,P_SQLERRM => SQLERRM
1819: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1820: , P_ROLLBACK_FLAG => 'N'

Line 1819: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1815: ,P_PKG_NAME => G_PKG_NAME
1816: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1817: ,P_SQLCODE => SQLCODE
1818: ,P_SQLERRM => SQLERRM
1819: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1820: , P_ROLLBACK_FLAG => 'N'
1821: ,X_MSG_COUNT => X_MSG_COUNT
1822: ,X_MSG_DATA => X_MSG_DATA
1823: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

1865: END IF;
1866:
1867: -- Debug Message
1868: IF l_debug THEN
1869: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1870: 'Public API: ' || l_api_name || 'start');
1871:
1872: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1873: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1868: IF l_debug THEN
1869: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1870: 'Public API: ' || l_api_name || 'start');
1871:
1872: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1873: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1874: END IF;
1875:
1876: -- Initialize API return status to SUCCESS

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

1877: x_return_status := FND_API.G_RET_STS_SUCCESS;
1878:
1879:
1880: IF l_debug THEN
1881: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1882: 'Public API: Calling as_access_pvt.has_viewOpportunityAccess');
1883: END IF;
1884:
1885:

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

1912: --
1913:
1914: -- Debug Message
1915: IF l_debug THEN
1916: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1917: 'Public API: ' || l_api_name || 'end');
1918:
1919: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1920: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1915: IF l_debug THEN
1916: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1917: 'Public API: ' || l_api_name || 'end');
1918:
1919: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1920: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1921: END IF;
1922:
1923:

Line 1931: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1927: );
1928:
1929: EXCEPTION
1930: WHEN FND_API.G_EXC_ERROR THEN
1931: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1932: P_MODULE => l_module
1933: ,P_API_NAME => L_API_NAME
1934: ,P_PKG_NAME => G_PKG_NAME
1935: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1936: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1932: P_MODULE => l_module
1933: ,P_API_NAME => L_API_NAME
1934: ,P_PKG_NAME => G_PKG_NAME
1935: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1936: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1937: , P_ROLLBACK_FLAG => 'N'
1938: ,X_MSG_COUNT => X_MSG_COUNT
1939: ,X_MSG_DATA => X_MSG_DATA
1940: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1943: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1939: ,X_MSG_DATA => X_MSG_DATA
1940: ,X_RETURN_STATUS => X_RETURN_STATUS);
1941:
1942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1943: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1944: P_MODULE => l_module
1945: ,P_API_NAME => L_API_NAME
1946: ,P_PKG_NAME => G_PKG_NAME
1947: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1948: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1944: P_MODULE => l_module
1945: ,P_API_NAME => L_API_NAME
1946: ,P_PKG_NAME => G_PKG_NAME
1947: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1948: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1949: , P_ROLLBACK_FLAG => 'N'
1950: ,X_MSG_COUNT => X_MSG_COUNT
1951: ,X_MSG_DATA => X_MSG_DATA
1952: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1955: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1951: ,X_MSG_DATA => X_MSG_DATA
1952: ,X_RETURN_STATUS => X_RETURN_STATUS);
1953:
1954: WHEN OTHERS THEN
1955: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1956: P_MODULE => l_module
1957: ,P_API_NAME => L_API_NAME
1958: ,P_PKG_NAME => G_PKG_NAME
1959: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 1959: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1955: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1956: P_MODULE => l_module
1957: ,P_API_NAME => L_API_NAME
1958: ,P_PKG_NAME => G_PKG_NAME
1959: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1960: ,P_SQLCODE => SQLCODE
1961: ,P_SQLERRM => SQLERRM
1962: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1963: , P_ROLLBACK_FLAG => 'N'

Line 1962: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1958: ,P_PKG_NAME => G_PKG_NAME
1959: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1960: ,P_SQLCODE => SQLCODE
1961: ,P_SQLERRM => SQLERRM
1962: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1963: , P_ROLLBACK_FLAG => 'N'
1964: ,X_MSG_COUNT => X_MSG_COUNT
1965: ,X_MSG_DATA => X_MSG_DATA
1966: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

2014: END IF;
2015:
2016: -- Debug Message
2017: IF l_debug THEN
2018: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2019: 'Public API: ' || l_api_name || 'start');
2020:
2021: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2022: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2017: IF l_debug THEN
2018: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2019: 'Public API: ' || l_api_name || 'start');
2020:
2021: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2022: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2023: END IF;
2024:
2025: -- Initialize API return status to SUCCESS

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

2025: -- Initialize API return status to SUCCESS
2026: x_return_status := FND_API.G_RET_STS_SUCCESS;
2027:
2028: IF l_debug THEN
2029: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2030: 'Public API: Calling as_access_pvt.has_viewCustomerAccess');
2031: END IF;
2032:
2033: x_access_privilege := 'N';

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

2091: --
2092:
2093: -- Debug Message
2094: IF l_debug THEN
2095: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2096: 'Public API: ' || l_api_name || 'end');
2097:
2098: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
2099: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2094: IF l_debug THEN
2095: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2096: 'Public API: ' || l_api_name || 'end');
2097:
2098: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
2099: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2100: END IF;
2101:
2102:

Line 2110: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2106: );
2107:
2108: EXCEPTION
2109: WHEN FND_API.G_EXC_ERROR THEN
2110: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2111: P_MODULE => l_module
2112: ,P_API_NAME => L_API_NAME
2113: ,P_PKG_NAME => G_PKG_NAME
2114: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2115: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2111: P_MODULE => l_module
2112: ,P_API_NAME => L_API_NAME
2113: ,P_PKG_NAME => G_PKG_NAME
2114: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2115: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2116: , P_ROLLBACK_FLAG => 'N'
2117: ,X_MSG_COUNT => X_MSG_COUNT
2118: ,X_MSG_DATA => X_MSG_DATA
2119: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2122: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2118: ,X_MSG_DATA => X_MSG_DATA
2119: ,X_RETURN_STATUS => X_RETURN_STATUS);
2120:
2121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2122: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2123: P_MODULE => l_module
2124: ,P_API_NAME => L_API_NAME
2125: ,P_PKG_NAME => G_PKG_NAME
2126: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 2127: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2123: P_MODULE => l_module
2124: ,P_API_NAME => L_API_NAME
2125: ,P_PKG_NAME => G_PKG_NAME
2126: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2127: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2128: , P_ROLLBACK_FLAG => 'N'
2129: ,X_MSG_COUNT => X_MSG_COUNT
2130: ,X_MSG_DATA => X_MSG_DATA
2131: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2134: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2130: ,X_MSG_DATA => X_MSG_DATA
2131: ,X_RETURN_STATUS => X_RETURN_STATUS);
2132:
2133: WHEN OTHERS THEN
2134: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2135: P_MODULE => l_module
2136: ,P_API_NAME => L_API_NAME
2137: ,P_PKG_NAME => G_PKG_NAME
2138: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 2138: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

2134: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2135: P_MODULE => l_module
2136: ,P_API_NAME => L_API_NAME
2137: ,P_PKG_NAME => G_PKG_NAME
2138: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2139: ,P_SQLCODE => SQLCODE
2140: ,P_SQLERRM => SQLERRM
2141: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2142: , P_ROLLBACK_FLAG => 'N'

Line 2141: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2137: ,P_PKG_NAME => G_PKG_NAME
2138: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2139: ,P_SQLCODE => SQLCODE
2140: ,P_SQLERRM => SQLERRM
2141: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2142: , P_ROLLBACK_FLAG => 'N'
2143: ,X_MSG_COUNT => X_MSG_COUNT
2144: ,X_MSG_DATA => X_MSG_DATA
2145: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

2188: END IF;
2189:
2190: -- Debug Message
2191: IF l_debug THEN
2192: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2193: 'Public API: ' || l_api_name || 'start');
2194:
2195: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2196: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2191: IF l_debug THEN
2192: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2193: 'Public API: ' || l_api_name || 'start');
2194:
2195: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2196: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2197: END IF;
2198:
2199: -- Initialize API return status to SUCCESS

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

2199: -- Initialize API return status to SUCCESS
2200: x_return_status := FND_API.G_RET_STS_SUCCESS;
2201:
2202: IF l_debug THEN
2203: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2204: 'Public API: Calling as_access_pvt.has_viewCustomerAccess');
2205: END IF;
2206:
2207: x_access_privilege := 'N';

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

2265: --
2266:
2267: -- Debug Message
2268: IF l_debug THEN
2269: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2270: 'Public API: ' || l_api_name || 'end');
2271:
2272: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
2273: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2268: IF l_debug THEN
2269: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2270: 'Public API: ' || l_api_name || 'end');
2271:
2272: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
2273: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2274: END IF;
2275:
2276:

Line 2284: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2280: );
2281:
2282: EXCEPTION
2283: WHEN FND_API.G_EXC_ERROR THEN
2284: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2285: P_MODULE => l_module
2286: ,P_API_NAME => L_API_NAME
2287: ,P_PKG_NAME => G_PKG_NAME
2288: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2289: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2285: P_MODULE => l_module
2286: ,P_API_NAME => L_API_NAME
2287: ,P_PKG_NAME => G_PKG_NAME
2288: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2289: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2290: , P_ROLLBACK_FLAG => 'N'
2291: ,X_MSG_COUNT => X_MSG_COUNT
2292: ,X_MSG_DATA => X_MSG_DATA
2293: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2296: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2292: ,X_MSG_DATA => X_MSG_DATA
2293: ,X_RETURN_STATUS => X_RETURN_STATUS);
2294:
2295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2296: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2297: P_MODULE => l_module
2298: ,P_API_NAME => L_API_NAME
2299: ,P_PKG_NAME => G_PKG_NAME
2300: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 2301: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2297: P_MODULE => l_module
2298: ,P_API_NAME => L_API_NAME
2299: ,P_PKG_NAME => G_PKG_NAME
2300: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2301: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2302: , P_ROLLBACK_FLAG => 'N'
2303: ,X_MSG_COUNT => X_MSG_COUNT
2304: ,X_MSG_DATA => X_MSG_DATA
2305: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2308: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2304: ,X_MSG_DATA => X_MSG_DATA
2305: ,X_RETURN_STATUS => X_RETURN_STATUS);
2306:
2307: WHEN OTHERS THEN
2308: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2309: P_MODULE => l_module
2310: ,P_API_NAME => L_API_NAME
2311: ,P_PKG_NAME => G_PKG_NAME
2312: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 2312: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

2308: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2309: P_MODULE => l_module
2310: ,P_API_NAME => L_API_NAME
2311: ,P_PKG_NAME => G_PKG_NAME
2312: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2313: ,P_SQLCODE => SQLCODE
2314: ,P_SQLERRM => SQLERRM
2315: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2316: , P_ROLLBACK_FLAG => 'N'

Line 2315: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2311: ,P_PKG_NAME => G_PKG_NAME
2312: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2313: ,P_SQLCODE => SQLCODE
2314: ,P_SQLERRM => SQLERRM
2315: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2316: , P_ROLLBACK_FLAG => 'N'
2317: ,X_MSG_COUNT => X_MSG_COUNT
2318: ,X_MSG_DATA => X_MSG_DATA
2319: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

2362: END IF;
2363:
2364: -- Debug Message
2365: IF l_debug THEN
2366: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2367: 'Public API: ' || l_api_name || 'start');
2368:
2369: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2370: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2365: IF l_debug THEN
2366: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2367: 'Public API: ' || l_api_name || 'start');
2368:
2369: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2370: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2371: END IF;
2372:
2373: -- Initialize API return status to SUCCESS

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

2373: -- Initialize API return status to SUCCESS
2374: x_return_status := FND_API.G_RET_STS_SUCCESS;
2375:
2376: IF l_debug THEN
2377: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2378: 'Public API: Calling as_access_pvt.has_viewCustomerAccess');
2379: END IF;
2380:
2381: x_access_privilege := 'N';

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

2439: --
2440:
2441: -- Debug Message
2442: IF l_debug THEN
2443: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2444: 'Public API: ' || l_api_name || 'end');
2445:
2446: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
2447: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2442: IF l_debug THEN
2443: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2444: 'Public API: ' || l_api_name || 'end');
2445:
2446: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
2447: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2448: END IF;
2449:
2450:

Line 2458: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2454: );
2455:
2456: EXCEPTION
2457: WHEN FND_API.G_EXC_ERROR THEN
2458: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2459: P_MODULE => l_module
2460: ,P_API_NAME => L_API_NAME
2461: ,P_PKG_NAME => G_PKG_NAME
2462: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2463: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2459: P_MODULE => l_module
2460: ,P_API_NAME => L_API_NAME
2461: ,P_PKG_NAME => G_PKG_NAME
2462: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2463: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2464: , P_ROLLBACK_FLAG => 'N'
2465: ,X_MSG_COUNT => X_MSG_COUNT
2466: ,X_MSG_DATA => X_MSG_DATA
2467: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2470: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2466: ,X_MSG_DATA => X_MSG_DATA
2467: ,X_RETURN_STATUS => X_RETURN_STATUS);
2468:
2469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2470: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2471: P_MODULE => l_module
2472: ,P_API_NAME => L_API_NAME
2473: ,P_PKG_NAME => G_PKG_NAME
2474: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 2475: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2471: P_MODULE => l_module
2472: ,P_API_NAME => L_API_NAME
2473: ,P_PKG_NAME => G_PKG_NAME
2474: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2475: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2476: , P_ROLLBACK_FLAG => 'N'
2477: ,X_MSG_COUNT => X_MSG_COUNT
2478: ,X_MSG_DATA => X_MSG_DATA
2479: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2482: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2478: ,X_MSG_DATA => X_MSG_DATA
2479: ,X_RETURN_STATUS => X_RETURN_STATUS);
2480:
2481: WHEN OTHERS THEN
2482: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2483: P_MODULE => l_module
2484: ,P_API_NAME => L_API_NAME
2485: ,P_PKG_NAME => G_PKG_NAME
2486: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 2486: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

2482: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2483: P_MODULE => l_module
2484: ,P_API_NAME => L_API_NAME
2485: ,P_PKG_NAME => G_PKG_NAME
2486: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2487: ,P_SQLCODE => SQLCODE
2488: ,P_SQLERRM => SQLERRM
2489: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2490: , P_ROLLBACK_FLAG => 'N'

Line 2489: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2485: ,P_PKG_NAME => G_PKG_NAME
2486: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2487: ,P_SQLCODE => SQLCODE
2488: ,P_SQLERRM => SQLERRM
2489: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2490: , P_ROLLBACK_FLAG => 'N'
2491: ,X_MSG_COUNT => X_MSG_COUNT
2492: ,X_MSG_DATA => X_MSG_DATA
2493: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

2538: END IF;
2539:
2540: -- Debug Message
2541: IF l_debug THEN
2542: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2543: 'Public API: ' || l_api_name || 'start');
2544:
2545: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2546: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2541: IF l_debug THEN
2542: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2543: 'Public API: ' || l_api_name || 'start');
2544:
2545: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2546: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2547: END IF;
2548:
2549: -- Initialize API return status to SUCCESS

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

2614: --
2615:
2616: -- Debug Message
2617: IF l_debug THEN
2618: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2619: 'Public API: ' || l_api_name || 'end');
2620:
2621: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
2622: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2617: IF l_debug THEN
2618: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2619: 'Public API: ' || l_api_name || 'end');
2620:
2621: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
2622: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2623: END IF;
2624:
2625:

Line 2633: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2629: );
2630:
2631: EXCEPTION
2632: WHEN FND_API.G_EXC_ERROR THEN
2633: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2634: P_MODULE => l_module
2635: ,P_API_NAME => L_API_NAME
2636: ,P_PKG_NAME => G_PKG_NAME
2637: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2638: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2634: P_MODULE => l_module
2635: ,P_API_NAME => L_API_NAME
2636: ,P_PKG_NAME => G_PKG_NAME
2637: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2638: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2639: , P_ROLLBACK_FLAG => 'N'
2640: ,X_MSG_COUNT => X_MSG_COUNT
2641: ,X_MSG_DATA => X_MSG_DATA
2642: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2645: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2641: ,X_MSG_DATA => X_MSG_DATA
2642: ,X_RETURN_STATUS => X_RETURN_STATUS);
2643:
2644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2645: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2646: P_MODULE => l_module
2647: ,P_API_NAME => L_API_NAME
2648: ,P_PKG_NAME => G_PKG_NAME
2649: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 2650: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2646: P_MODULE => l_module
2647: ,P_API_NAME => L_API_NAME
2648: ,P_PKG_NAME => G_PKG_NAME
2649: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2650: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2651: , P_ROLLBACK_FLAG => 'N'
2652: ,X_MSG_COUNT => X_MSG_COUNT
2653: ,X_MSG_DATA => X_MSG_DATA
2654: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2657: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2653: ,X_MSG_DATA => X_MSG_DATA
2654: ,X_RETURN_STATUS => X_RETURN_STATUS);
2655:
2656: WHEN OTHERS THEN
2657: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2658: P_MODULE => l_module
2659: ,P_API_NAME => L_API_NAME
2660: ,P_PKG_NAME => G_PKG_NAME
2661: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 2661: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

2657: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2658: P_MODULE => l_module
2659: ,P_API_NAME => L_API_NAME
2660: ,P_PKG_NAME => G_PKG_NAME
2661: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2662: ,P_SQLCODE => SQLCODE
2663: ,P_SQLERRM => SQLERRM
2664: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2665: , P_ROLLBACK_FLAG => 'N'

Line 2664: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2660: ,P_PKG_NAME => G_PKG_NAME
2661: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2662: ,P_SQLCODE => SQLCODE
2663: ,P_SQLERRM => SQLERRM
2664: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2665: , P_ROLLBACK_FLAG => 'N'
2666: ,X_MSG_COUNT => X_MSG_COUNT
2667: ,X_MSG_DATA => X_MSG_DATA
2668: ,X_RETURN_STATUS => X_RETURN_STATUS);