APPS.AS_OPPORTUNITY_PUB dependencies on AS_UTILITY_PVT

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

69:
70: -- Debug Message
71: IF l_debug THEN
72: IF l_debug THEN
73: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
74: 'Public API: ' || l_api_name || ' start');
75:
76: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
77: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

72: IF l_debug THEN
73: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
74: 'Public API: ' || l_api_name || ' start');
75:
76: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
77: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
78: END IF;
79: END IF;
80:

Line 92: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

88: /*****
89:
90: -- Debug Message
91: IF l_debug THEN
92: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
93: 'AS: Public API: Convert_Header_Values_To_Ids');
94:
95: END IF;
96:

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

160:
161: -- Debug Message
162: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
163: IF l_debug THEN
164: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
165: 'Create_opp_header_Post fail');
166: END IF;
167:
168: END IF;

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

188:
189:
190: -- Debug Message
191: IF l_debug THEN
192: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
193: 'Public API: ' || l_api_name || ' end');
194:
195: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
196: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

191: IF l_debug THEN
192: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
193: 'Public API: ' || l_api_name || ' end');
194:
195: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
196: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
197: END IF;
198:
199:

Line 214: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

210: END IF;
211:
212: EXCEPTION
213: WHEN FND_API.G_EXC_ERROR THEN
214: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
215: P_MODULE => l_module
216: ,P_API_NAME => L_API_NAME
217: ,P_PKG_NAME => G_PKG_NAME
218: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 219: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

215: P_MODULE => l_module
216: ,P_API_NAME => L_API_NAME
217: ,P_PKG_NAME => G_PKG_NAME
218: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
219: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
220: ,X_MSG_COUNT => X_MSG_COUNT
221: ,X_MSG_DATA => X_MSG_DATA
222: ,X_RETURN_STATUS => X_RETURN_STATUS);
223:

Line 225: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

221: ,X_MSG_DATA => X_MSG_DATA
222: ,X_RETURN_STATUS => X_RETURN_STATUS);
223:
224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
226: P_MODULE => l_module
227: ,P_API_NAME => L_API_NAME
228: ,P_PKG_NAME => G_PKG_NAME
229: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 230: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

226: P_MODULE => l_module
227: ,P_API_NAME => L_API_NAME
228: ,P_PKG_NAME => G_PKG_NAME
229: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
230: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
231: ,X_MSG_COUNT => X_MSG_COUNT
232: ,X_MSG_DATA => X_MSG_DATA
233: ,X_RETURN_STATUS => X_RETURN_STATUS);
234:

Line 236: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

232: ,X_MSG_DATA => X_MSG_DATA
233: ,X_RETURN_STATUS => X_RETURN_STATUS);
234:
235: WHEN OTHERS THEN
236: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
237: P_MODULE => l_module
238: ,P_API_NAME => L_API_NAME
239: ,P_PKG_NAME => G_PKG_NAME
240: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 240: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

236: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
237: P_MODULE => l_module
238: ,P_API_NAME => L_API_NAME
239: ,P_PKG_NAME => G_PKG_NAME
240: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
241: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
242: ,X_MSG_COUNT => X_MSG_COUNT
243: ,X_MSG_DATA => X_MSG_DATA
244: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 241: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

237: P_MODULE => l_module
238: ,P_API_NAME => L_API_NAME
239: ,P_PKG_NAME => G_PKG_NAME
240: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
241: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
242: ,X_MSG_COUNT => X_MSG_COUNT
243: ,X_MSG_DATA => X_MSG_DATA
244: ,X_RETURN_STATUS => X_RETURN_STATUS);
245: End Create_opp_header;

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

299:
300:
301: -- Debug Message
302: IF l_debug THEN
303: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
304: 'Public API: ' || l_api_name || ' start');
305:
306: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
307: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

302: IF l_debug THEN
303: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
304: 'Public API: ' || l_api_name || ' start');
305:
306: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
307: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
308: END IF;
309:
310:

Line 321: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

317:
318: /*****
319: -- Debug Message
320: IF l_debug THEN
321: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
322: 'AS: Public API: Convert_Header_Values_To_Ids');
323: END IF;
324:
325: -- Convert the values to ids

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

351:
352: -- Debug Message
353: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
354: IF l_debug THEN
355: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
356: 'Update_opp_header_Pre fail');
357: END IF;
358:
359: END IF;

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

416:
417: -- Debug Message
418: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
419: IF l_debug THEN
420: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
421: 'Update_opp_header_Post fail');
422: END IF;
423: END IF;
424:

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

443:
444:
445: -- Debug Message
446: IF l_debug THEN
447: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
448: 'Public API: ' || l_api_name || ' end');
449:
450: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
451: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

446: IF l_debug THEN
447: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
448: 'Public API: ' || l_api_name || ' end');
449:
450: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
451: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
452: END IF;
453: -- Standard call to get message count and if count is 1, get message info.
454: FND_MSG_PUB.Count_And_Get

Line 465: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

461: END IF;
462:
463: EXCEPTION
464: WHEN FND_API.G_EXC_ERROR THEN
465: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
466: P_MODULE => l_module
467: ,P_API_NAME => L_API_NAME
468: ,P_PKG_NAME => G_PKG_NAME
469: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 470: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

466: P_MODULE => l_module
467: ,P_API_NAME => L_API_NAME
468: ,P_PKG_NAME => G_PKG_NAME
469: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
470: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
471: ,X_MSG_COUNT => X_MSG_COUNT
472: ,X_MSG_DATA => X_MSG_DATA
473: ,X_RETURN_STATUS => X_RETURN_STATUS);
474:

Line 476: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

472: ,X_MSG_DATA => X_MSG_DATA
473: ,X_RETURN_STATUS => X_RETURN_STATUS);
474:
475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
476: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
477: P_MODULE => l_module
478: ,P_API_NAME => L_API_NAME
479: ,P_PKG_NAME => G_PKG_NAME
480: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 481: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

477: P_MODULE => l_module
478: ,P_API_NAME => L_API_NAME
479: ,P_PKG_NAME => G_PKG_NAME
480: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
481: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
482: ,X_MSG_COUNT => X_MSG_COUNT
483: ,X_MSG_DATA => X_MSG_DATA
484: ,X_RETURN_STATUS => X_RETURN_STATUS);
485:

Line 487: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

483: ,X_MSG_DATA => X_MSG_DATA
484: ,X_RETURN_STATUS => X_RETURN_STATUS);
485:
486: WHEN OTHERS THEN
487: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
488: P_MODULE => l_module
489: ,P_API_NAME => L_API_NAME
490: ,P_PKG_NAME => G_PKG_NAME
491: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 491: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

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

Line 492: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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

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

548:
549:
550: -- Debug Message
551: IF l_debug THEN
552: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
553: 'Public API: ' || l_api_name || ' start');
554:
555: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
556: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

551: IF l_debug THEN
552: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
553: 'Public API: ' || l_api_name || ' start');
554:
555: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
556: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
557: END IF;
558: -- Initialize API return status to SUCCESS
559: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 568: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

564:
565: /*****
566:
567: IF l_debug THEN
568: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
569: 'AS: Public API: Convert_Header_Values_To_Ids');
570:
571: END IF;
572:

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

613:
614:
615: -- Debug Message
616: IF l_debug THEN
617: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
618: 'Public API: ' || l_api_name || ' end');
619:
620: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
621: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

616: IF l_debug THEN
617: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
618: 'Public API: ' || l_api_name || ' end');
619:
620: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
621: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
622: END IF;
623:
624:

Line 633: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

629: );
630:
631: EXCEPTION
632: WHEN FND_API.G_EXC_ERROR THEN
633: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
634: P_MODULE => l_module
635: ,P_API_NAME => L_API_NAME
636: ,P_PKG_NAME => G_PKG_NAME
637: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 638: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

634: P_MODULE => l_module
635: ,P_API_NAME => L_API_NAME
636: ,P_PKG_NAME => G_PKG_NAME
637: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
638: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
639: ,X_MSG_COUNT => X_MSG_COUNT
640: ,X_MSG_DATA => X_MSG_DATA
641: ,X_RETURN_STATUS => X_RETURN_STATUS);
642:

Line 644: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

640: ,X_MSG_DATA => X_MSG_DATA
641: ,X_RETURN_STATUS => X_RETURN_STATUS);
642:
643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
644: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
645: P_MODULE => l_module
646: ,P_API_NAME => L_API_NAME
647: ,P_PKG_NAME => G_PKG_NAME
648: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 649: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

645: P_MODULE => l_module
646: ,P_API_NAME => L_API_NAME
647: ,P_PKG_NAME => G_PKG_NAME
648: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
649: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
650: ,X_MSG_COUNT => X_MSG_COUNT
651: ,X_MSG_DATA => X_MSG_DATA
652: ,X_RETURN_STATUS => X_RETURN_STATUS);
653:

Line 655: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

651: ,X_MSG_DATA => X_MSG_DATA
652: ,X_RETURN_STATUS => X_RETURN_STATUS);
653:
654: WHEN OTHERS THEN
655: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
656: P_MODULE => l_module
657: ,P_API_NAME => L_API_NAME
658: ,P_PKG_NAME => G_PKG_NAME
659: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 659: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

655: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
656: P_MODULE => l_module
657: ,P_API_NAME => L_API_NAME
658: ,P_PKG_NAME => G_PKG_NAME
659: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
660: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
661: ,X_MSG_COUNT => X_MSG_COUNT
662: ,X_MSG_DATA => X_MSG_DATA
663: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 660: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

656: P_MODULE => l_module
657: ,P_API_NAME => L_API_NAME
658: ,P_PKG_NAME => G_PKG_NAME
659: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
660: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
661: ,X_MSG_COUNT => X_MSG_COUNT
662: ,X_MSG_DATA => X_MSG_DATA
663: ,X_RETURN_STATUS => X_RETURN_STATUS);
664:

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

724:
725:
726: -- Debug Message
727: IF l_debug THEN
728: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
729: 'Public API: ' || l_api_name || ' start');
730:
731: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
732: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

727: IF l_debug THEN
728: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
729: 'Public API: ' || l_api_name || ' start');
730:
731: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
732: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
733: END IF;
734:
735: -- Initialize API return status to SUCCESS

Line 746: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

742: /*****
743:
744: -- Debug Message
745: IF l_debug THEN
746: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
747: 'AS: Public API: Convert_Line_Values_To_Ids');
748: END IF;
749:
750: -- Convert the values to ids

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

795:
796:
797: -- Debug Message
798: IF l_debug THEN
799: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
800: 'Public API: ' || l_api_name || ' end');
801:
802: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
803: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

798: IF l_debug THEN
799: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
800: 'Public API: ' || l_api_name || ' end');
801:
802: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
803: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
804:
805: END IF;
806:

Line 815: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

811: );
812:
813: EXCEPTION
814: WHEN FND_API.G_EXC_ERROR THEN
815: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
816: P_MODULE => l_module
817: ,P_API_NAME => L_API_NAME
818: ,P_PKG_NAME => G_PKG_NAME
819: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 820: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

816: P_MODULE => l_module
817: ,P_API_NAME => L_API_NAME
818: ,P_PKG_NAME => G_PKG_NAME
819: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
820: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
821: ,X_MSG_COUNT => X_MSG_COUNT
822: ,X_MSG_DATA => X_MSG_DATA
823: ,X_RETURN_STATUS => X_RETURN_STATUS);
824:

Line 826: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

822: ,X_MSG_DATA => X_MSG_DATA
823: ,X_RETURN_STATUS => X_RETURN_STATUS);
824:
825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
826: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
827: P_MODULE => l_module
828: ,P_API_NAME => L_API_NAME
829: ,P_PKG_NAME => G_PKG_NAME
830: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 831: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

827: P_MODULE => l_module
828: ,P_API_NAME => L_API_NAME
829: ,P_PKG_NAME => G_PKG_NAME
830: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
831: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
832: ,X_MSG_COUNT => X_MSG_COUNT
833: ,X_MSG_DATA => X_MSG_DATA
834: ,X_RETURN_STATUS => X_RETURN_STATUS);
835:

Line 837: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

833: ,X_MSG_DATA => X_MSG_DATA
834: ,X_RETURN_STATUS => X_RETURN_STATUS);
835:
836: WHEN OTHERS THEN
837: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
838: P_MODULE => l_module
839: ,P_API_NAME => L_API_NAME
840: ,P_PKG_NAME => G_PKG_NAME
841: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 841: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

837: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
838: P_MODULE => l_module
839: ,P_API_NAME => L_API_NAME
840: ,P_PKG_NAME => G_PKG_NAME
841: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
842: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
843: ,X_MSG_COUNT => X_MSG_COUNT
844: ,X_MSG_DATA => X_MSG_DATA
845: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 842: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

838: P_MODULE => l_module
839: ,P_API_NAME => L_API_NAME
840: ,P_PKG_NAME => G_PKG_NAME
841: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
842: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
843: ,X_MSG_COUNT => X_MSG_COUNT
844: ,X_MSG_DATA => X_MSG_DATA
845: ,X_RETURN_STATUS => X_RETURN_STATUS);
846: End Create_opp_lines;

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

902:
903:
904: -- Debug Message
905: IF l_debug THEN
906: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
907: 'Public API: ' || l_api_name || ' start');
908:
909: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
910: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

905: IF l_debug THEN
906: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
907: 'Public API: ' || l_api_name || ' start');
908:
909: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
910: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
911:
912: END IF;
913:

Line 925: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

921: /*****
922:
923: -- Debug Message
924: IF l_debug THEN
925: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
926: 'AS: Public API: Convert_Line_Values_To_Ids');
927:
928: END IF;
929:

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

972:
973:
974: -- Debug Message
975: IF l_debug THEN
976: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
977: 'Public API: ' || l_api_name || ' end');
978:
979: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
980: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

975: IF l_debug THEN
976: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
977: 'Public API: ' || l_api_name || ' end');
978:
979: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
980: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
981:
982: END IF;
983:

Line 992: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

988: );
989:
990: EXCEPTION
991: WHEN FND_API.G_EXC_ERROR THEN
992: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
993: P_MODULE => l_module
994: ,P_API_NAME => L_API_NAME
995: ,P_PKG_NAME => G_PKG_NAME
996: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 997: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

993: P_MODULE => l_module
994: ,P_API_NAME => L_API_NAME
995: ,P_PKG_NAME => G_PKG_NAME
996: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
997: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
998: ,X_MSG_COUNT => X_MSG_COUNT
999: ,X_MSG_DATA => X_MSG_DATA
1000: ,X_RETURN_STATUS => X_RETURN_STATUS);
1001:

Line 1003: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

999: ,X_MSG_DATA => X_MSG_DATA
1000: ,X_RETURN_STATUS => X_RETURN_STATUS);
1001:
1002: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1003: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1004: P_MODULE => l_module
1005: ,P_API_NAME => L_API_NAME
1006: ,P_PKG_NAME => G_PKG_NAME
1007: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1008: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1004: P_MODULE => l_module
1005: ,P_API_NAME => L_API_NAME
1006: ,P_PKG_NAME => G_PKG_NAME
1007: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1008: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1009: ,X_MSG_COUNT => X_MSG_COUNT
1010: ,X_MSG_DATA => X_MSG_DATA
1011: ,X_RETURN_STATUS => X_RETURN_STATUS);
1012:

Line 1014: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1010: ,X_MSG_DATA => X_MSG_DATA
1011: ,X_RETURN_STATUS => X_RETURN_STATUS);
1012:
1013: WHEN OTHERS THEN
1014: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1015: P_MODULE => l_module
1016: ,P_API_NAME => L_API_NAME
1017: ,P_PKG_NAME => G_PKG_NAME
1018: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 1018: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1014: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1015: P_MODULE => l_module
1016: ,P_API_NAME => L_API_NAME
1017: ,P_PKG_NAME => G_PKG_NAME
1018: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1019: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1020: ,X_MSG_COUNT => X_MSG_COUNT
1021: ,X_MSG_DATA => X_MSG_DATA
1022: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1019: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1015: P_MODULE => l_module
1016: ,P_API_NAME => L_API_NAME
1017: ,P_PKG_NAME => G_PKG_NAME
1018: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1019: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1020: ,X_MSG_COUNT => X_MSG_COUNT
1021: ,X_MSG_DATA => X_MSG_DATA
1022: ,X_RETURN_STATUS => X_RETURN_STATUS);
1023: End Update_opp_lines;

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

1078:
1079:
1080: -- Debug Message
1081: IF l_debug THEN
1082: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1083: 'Public API: ' || l_api_name || ' start');
1084:
1085: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1086: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1081: IF l_debug THEN
1082: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1083: 'Public API: ' || l_api_name || ' start');
1084:
1085: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1086: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1087:
1088: END IF;
1089:

Line 1101: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1097: /*****
1098:
1099: -- Debug Message
1100: IF l_debug THEN
1101: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1102: 'AS: Public API: Convert_Line_Values_To_Ids');
1103: END IF;
1104:
1105: -- Convert the values to ids

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

1147:
1148:
1149: -- Debug Message
1150: IF l_debug THEN
1151: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1152: 'Public API: ' || l_api_name || ' end');
1153:
1154: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1155: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1150: IF l_debug THEN
1151: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1152: 'Public API: ' || l_api_name || ' end');
1153:
1154: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1155: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1156:
1157: END IF;
1158:

Line 1167: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1163: );
1164:
1165: EXCEPTION
1166: WHEN FND_API.G_EXC_ERROR THEN
1167: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1168: P_MODULE => l_module
1169: ,P_API_NAME => L_API_NAME
1170: ,P_PKG_NAME => G_PKG_NAME
1171: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1172: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1168: P_MODULE => l_module
1169: ,P_API_NAME => L_API_NAME
1170: ,P_PKG_NAME => G_PKG_NAME
1171: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1172: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1173: ,X_MSG_COUNT => X_MSG_COUNT
1174: ,X_MSG_DATA => X_MSG_DATA
1175: ,X_RETURN_STATUS => X_RETURN_STATUS);
1176:

Line 1178: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1174: ,X_MSG_DATA => X_MSG_DATA
1175: ,X_RETURN_STATUS => X_RETURN_STATUS);
1176:
1177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1178: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1179: P_MODULE => l_module
1180: ,P_API_NAME => L_API_NAME
1181: ,P_PKG_NAME => G_PKG_NAME
1182: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1183: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1179: P_MODULE => l_module
1180: ,P_API_NAME => L_API_NAME
1181: ,P_PKG_NAME => G_PKG_NAME
1182: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1183: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1184: ,X_MSG_COUNT => X_MSG_COUNT
1185: ,X_MSG_DATA => X_MSG_DATA
1186: ,X_RETURN_STATUS => X_RETURN_STATUS);
1187:

Line 1189: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1185: ,X_MSG_DATA => X_MSG_DATA
1186: ,X_RETURN_STATUS => X_RETURN_STATUS);
1187:
1188: WHEN OTHERS THEN
1189: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1190: P_MODULE => l_module
1191: ,P_API_NAME => L_API_NAME
1192: ,P_PKG_NAME => G_PKG_NAME
1193: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 1193: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1189: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1190: P_MODULE => l_module
1191: ,P_API_NAME => L_API_NAME
1192: ,P_PKG_NAME => G_PKG_NAME
1193: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1194: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1195: ,X_MSG_COUNT => X_MSG_COUNT
1196: ,X_MSG_DATA => X_MSG_DATA
1197: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1194: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1190: P_MODULE => l_module
1191: ,P_API_NAME => L_API_NAME
1192: ,P_PKG_NAME => G_PKG_NAME
1193: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1194: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1195: ,X_MSG_COUNT => X_MSG_COUNT
1196: ,X_MSG_DATA => X_MSG_DATA
1197: ,X_RETURN_STATUS => X_RETURN_STATUS);
1198: End Delete_opp_lines;

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

1244:
1245:
1246: -- Debug Message
1247: IF l_debug THEN
1248: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1249: 'Public API: ' || l_api_name || ' start');
1250:
1251: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1252: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1247: IF l_debug THEN
1248: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1249: 'Public API: ' || l_api_name || ' start');
1250:
1251: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1252: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1253:
1254: END IF;
1255:

Line 1267: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1263: /*****
1264:
1265: -- Debug Message
1266: IF l_debug THEN
1267: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1268: 'AS: Public API: Convert_SALES_CREDIT_Values_To_Ids');
1269:
1270: END IF;
1271:

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

1316:
1317:
1318: -- Debug Message
1319: IF l_debug THEN
1320: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1321: 'Public API: ' || l_api_name || ' end');
1322:
1323: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1324: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1319: IF l_debug THEN
1320: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1321: 'Public API: ' || l_api_name || ' end');
1322:
1323: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1324: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1325: END IF;
1326:
1327: -- Standard call to get message count and if count is 1, get message info.

Line 1335: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1331: );
1332:
1333: EXCEPTION
1334: WHEN FND_API.G_EXC_ERROR THEN
1335: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1336: P_MODULE => l_module
1337: ,P_API_NAME => L_API_NAME
1338: ,P_PKG_NAME => G_PKG_NAME
1339: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1340: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1336: P_MODULE => l_module
1337: ,P_API_NAME => L_API_NAME
1338: ,P_PKG_NAME => G_PKG_NAME
1339: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1340: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1341: ,X_MSG_COUNT => X_MSG_COUNT
1342: ,X_MSG_DATA => X_MSG_DATA
1343: ,X_RETURN_STATUS => X_RETURN_STATUS);
1344:

Line 1346: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1342: ,X_MSG_DATA => X_MSG_DATA
1343: ,X_RETURN_STATUS => X_RETURN_STATUS);
1344:
1345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1346: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1347: P_MODULE => l_module
1348: ,P_API_NAME => L_API_NAME
1349: ,P_PKG_NAME => G_PKG_NAME
1350: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1351: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1347: P_MODULE => l_module
1348: ,P_API_NAME => L_API_NAME
1349: ,P_PKG_NAME => G_PKG_NAME
1350: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1351: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1352: ,X_MSG_COUNT => X_MSG_COUNT
1353: ,X_MSG_DATA => X_MSG_DATA
1354: ,X_RETURN_STATUS => X_RETURN_STATUS);
1355:

Line 1357: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1353: ,X_MSG_DATA => X_MSG_DATA
1354: ,X_RETURN_STATUS => X_RETURN_STATUS);
1355:
1356: WHEN OTHERS THEN
1357: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1358: P_MODULE => l_module
1359: ,P_API_NAME => L_API_NAME
1360: ,P_PKG_NAME => G_PKG_NAME
1361: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 1361: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1357: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1358: P_MODULE => l_module
1359: ,P_API_NAME => L_API_NAME
1360: ,P_PKG_NAME => G_PKG_NAME
1361: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1362: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1363: ,X_MSG_COUNT => X_MSG_COUNT
1364: ,X_MSG_DATA => X_MSG_DATA
1365: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1362: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1358: P_MODULE => l_module
1359: ,P_API_NAME => L_API_NAME
1360: ,P_PKG_NAME => G_PKG_NAME
1361: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1362: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1363: ,X_MSG_COUNT => X_MSG_COUNT
1364: ,X_MSG_DATA => X_MSG_DATA
1365: ,X_RETURN_STATUS => X_RETURN_STATUS);
1366: End Create_sales_credits;

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

1412:
1413:
1414: -- Debug Message
1415: IF l_debug THEN
1416: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1417: 'Public API: ' || l_api_name || ' start');
1418:
1419: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1420: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1415: IF l_debug THEN
1416: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1417: 'Public API: ' || l_api_name || ' start');
1418:
1419: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1420: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1421:
1422: END IF;
1423:

Line 1434: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1430:
1431: /*****
1432: -- Debug Message
1433: IF l_debug THEN
1434: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1435: 'AS: Public API: Convert_SALES_CREDIT_Values_To_Ids');
1436:
1437: END IF;
1438:

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

1480:
1481:
1482: -- Debug Message
1483: IF l_debug THEN
1484: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1485: 'Public API: ' || l_api_name || ' end');
1486:
1487: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1488: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1483: IF l_debug THEN
1484: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1485: 'Public API: ' || l_api_name || ' end');
1486:
1487: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1488: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1489:
1490: END IF;
1491:

Line 1500: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1496: );
1497:
1498: EXCEPTION
1499: WHEN FND_API.G_EXC_ERROR THEN
1500: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1501: P_MODULE => l_module
1502: ,P_API_NAME => L_API_NAME
1503: ,P_PKG_NAME => G_PKG_NAME
1504: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1505: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1501: P_MODULE => l_module
1502: ,P_API_NAME => L_API_NAME
1503: ,P_PKG_NAME => G_PKG_NAME
1504: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1505: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1506: ,X_MSG_COUNT => X_MSG_COUNT
1507: ,X_MSG_DATA => X_MSG_DATA
1508: ,X_RETURN_STATUS => X_RETURN_STATUS);
1509:

Line 1511: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1507: ,X_MSG_DATA => X_MSG_DATA
1508: ,X_RETURN_STATUS => X_RETURN_STATUS);
1509:
1510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1511: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1512: P_MODULE => l_module
1513: ,P_API_NAME => L_API_NAME
1514: ,P_PKG_NAME => G_PKG_NAME
1515: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1516: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1512: P_MODULE => l_module
1513: ,P_API_NAME => L_API_NAME
1514: ,P_PKG_NAME => G_PKG_NAME
1515: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1516: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1517: ,X_MSG_COUNT => X_MSG_COUNT
1518: ,X_MSG_DATA => X_MSG_DATA
1519: ,X_RETURN_STATUS => X_RETURN_STATUS);
1520:

Line 1522: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1518: ,X_MSG_DATA => X_MSG_DATA
1519: ,X_RETURN_STATUS => X_RETURN_STATUS);
1520:
1521: WHEN OTHERS THEN
1522: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1523: P_MODULE => l_module
1524: ,P_API_NAME => L_API_NAME
1525: ,P_PKG_NAME => G_PKG_NAME
1526: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 1526: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1522: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1523: P_MODULE => l_module
1524: ,P_API_NAME => L_API_NAME
1525: ,P_PKG_NAME => G_PKG_NAME
1526: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1527: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1528: ,X_MSG_COUNT => X_MSG_COUNT
1529: ,X_MSG_DATA => X_MSG_DATA
1530: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1527: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1523: P_MODULE => l_module
1524: ,P_API_NAME => L_API_NAME
1525: ,P_PKG_NAME => G_PKG_NAME
1526: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1527: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1528: ,X_MSG_COUNT => X_MSG_COUNT
1529: ,X_MSG_DATA => X_MSG_DATA
1530: ,X_RETURN_STATUS => X_RETURN_STATUS);
1531: End Update_sales_credits;

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

1578:
1579:
1580: -- Debug Message
1581: IF l_debug THEN
1582: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1583: 'Public API: ' || l_api_name || ' start');
1584:
1585: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1586: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1581: IF l_debug THEN
1582: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1583: 'Public API: ' || l_api_name || ' start');
1584:
1585: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1586: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1587:
1588: END IF;
1589:

Line 1600: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1596:
1597: /*****
1598: -- Debug Message
1599: IF l_debug THEN
1600: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1601: 'AS: Public API: Convert_SALES_CREDIT_Values_To_Ids');
1602: END IF;
1603:
1604:

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

1646:
1647:
1648: -- Debug Message
1649: IF l_debug THEN
1650: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1651: 'Public API: ' || l_api_name || ' end');
1652:
1653: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1654: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1649: IF l_debug THEN
1650: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1651: 'Public API: ' || l_api_name || ' end');
1652:
1653: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1654: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1655: END IF;
1656: -- Standard call to get message count and if count is 1, get message info.
1657: FND_MSG_PUB.Count_And_Get

Line 1664: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1660: );
1661:
1662: EXCEPTION
1663: WHEN FND_API.G_EXC_ERROR THEN
1664: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1665: P_MODULE => l_module
1666: ,P_API_NAME => L_API_NAME
1667: ,P_PKG_NAME => G_PKG_NAME
1668: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1669: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1665: P_MODULE => l_module
1666: ,P_API_NAME => L_API_NAME
1667: ,P_PKG_NAME => G_PKG_NAME
1668: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1669: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1670: ,X_MSG_COUNT => X_MSG_COUNT
1671: ,X_MSG_DATA => X_MSG_DATA
1672: ,X_RETURN_STATUS => X_RETURN_STATUS);
1673:

Line 1675: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1671: ,X_MSG_DATA => X_MSG_DATA
1672: ,X_RETURN_STATUS => X_RETURN_STATUS);
1673:
1674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1675: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1676: P_MODULE => l_module
1677: ,P_API_NAME => L_API_NAME
1678: ,P_PKG_NAME => G_PKG_NAME
1679: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1680: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1676: P_MODULE => l_module
1677: ,P_API_NAME => L_API_NAME
1678: ,P_PKG_NAME => G_PKG_NAME
1679: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1680: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1681: ,X_MSG_COUNT => X_MSG_COUNT
1682: ,X_MSG_DATA => X_MSG_DATA
1683: ,X_RETURN_STATUS => X_RETURN_STATUS);
1684:

Line 1686: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1682: ,X_MSG_DATA => X_MSG_DATA
1683: ,X_RETURN_STATUS => X_RETURN_STATUS);
1684:
1685: WHEN OTHERS THEN
1686: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1687: P_MODULE => l_module
1688: ,P_API_NAME => L_API_NAME
1689: ,P_PKG_NAME => G_PKG_NAME
1690: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 1690: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1686: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1687: P_MODULE => l_module
1688: ,P_API_NAME => L_API_NAME
1689: ,P_PKG_NAME => G_PKG_NAME
1690: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1691: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1692: ,X_MSG_COUNT => X_MSG_COUNT
1693: ,X_MSG_DATA => X_MSG_DATA
1694: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1691: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1687: P_MODULE => l_module
1688: ,P_API_NAME => L_API_NAME
1689: ,P_PKG_NAME => G_PKG_NAME
1690: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1691: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1692: ,X_MSG_COUNT => X_MSG_COUNT
1693: ,X_MSG_DATA => X_MSG_DATA
1694: ,X_RETURN_STATUS => X_RETURN_STATUS);
1695: End Modify_Sales_Credits;

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

1741:
1742:
1743: -- Debug Message
1744: IF l_debug THEN
1745: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1746: 'Public API: ' || l_api_name || ' start');
1747:
1748: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1749: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1744: IF l_debug THEN
1745: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1746: 'Public API: ' || l_api_name || ' start');
1747:
1748: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1749: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1750:
1751: END IF;
1752:

Line 1764: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1760: /*****
1761:
1762: -- Debug Message
1763: IF l_debug THEN
1764: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1765: 'AS: Public API: Convert_SALES_CREDIT_Values_To_Ids');
1766: END IF;
1767:
1768: -- Convert the values to ids

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

1808:
1809:
1810: -- Debug Message
1811: IF l_debug THEN
1812: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1813: 'Public API: ' || l_api_name || ' end');
1814:
1815: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1816: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1811: IF l_debug THEN
1812: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1813: 'Public API: ' || l_api_name || ' end');
1814:
1815: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1816: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1817:
1818: END IF;
1819:

Line 1828: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1824: );
1825:
1826: EXCEPTION
1827: WHEN FND_API.G_EXC_ERROR THEN
1828: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1829: P_MODULE => l_module
1830: ,P_API_NAME => L_API_NAME
1831: ,P_PKG_NAME => G_PKG_NAME
1832: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1833: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1829: P_MODULE => l_module
1830: ,P_API_NAME => L_API_NAME
1831: ,P_PKG_NAME => G_PKG_NAME
1832: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1833: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1834: ,X_MSG_COUNT => X_MSG_COUNT
1835: ,X_MSG_DATA => X_MSG_DATA
1836: ,X_RETURN_STATUS => X_RETURN_STATUS);
1837:

Line 1839: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1835: ,X_MSG_DATA => X_MSG_DATA
1836: ,X_RETURN_STATUS => X_RETURN_STATUS);
1837:
1838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1839: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1840: P_MODULE => l_module
1841: ,P_API_NAME => L_API_NAME
1842: ,P_PKG_NAME => G_PKG_NAME
1843: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1844: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1840: P_MODULE => l_module
1841: ,P_API_NAME => L_API_NAME
1842: ,P_PKG_NAME => G_PKG_NAME
1843: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1844: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1845: ,X_MSG_COUNT => X_MSG_COUNT
1846: ,X_MSG_DATA => X_MSG_DATA
1847: ,X_RETURN_STATUS => X_RETURN_STATUS);
1848:

Line 1850: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1846: ,X_MSG_DATA => X_MSG_DATA
1847: ,X_RETURN_STATUS => X_RETURN_STATUS);
1848:
1849: WHEN OTHERS THEN
1850: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1851: P_MODULE => l_module
1852: ,P_API_NAME => L_API_NAME
1853: ,P_PKG_NAME => G_PKG_NAME
1854: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 1854: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1850: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1851: P_MODULE => l_module
1852: ,P_API_NAME => L_API_NAME
1853: ,P_PKG_NAME => G_PKG_NAME
1854: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1855: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1856: ,X_MSG_COUNT => X_MSG_COUNT
1857: ,X_MSG_DATA => X_MSG_DATA
1858: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1855: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1851: P_MODULE => l_module
1852: ,P_API_NAME => L_API_NAME
1853: ,P_PKG_NAME => G_PKG_NAME
1854: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1855: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1856: ,X_MSG_COUNT => X_MSG_COUNT
1857: ,X_MSG_DATA => X_MSG_DATA
1858: ,X_RETURN_STATUS => X_RETURN_STATUS);
1859: End Delete_sales_credits;

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

1905:
1906:
1907: -- Debug Message
1908: IF l_debug THEN
1909: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1910: 'Public API: ' || l_api_name || ' start');
1911:
1912: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1913: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1908: IF l_debug THEN
1909: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1910: 'Public API: ' || l_api_name || ' start');
1911:
1912: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1913: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1914: END IF;
1915:
1916: -- Initialize API return status to SUCCESS

Line 1927: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1923: /*****
1924:
1925: -- Debug Message
1926: IF l_debug THEN
1927: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1928: 'AS: Public API: Convert_Order_Values_To_Ids');
1929: END IF;
1930:
1931:

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

1976:
1977:
1978: -- Debug Message
1979: IF l_debug THEN
1980: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1981: 'Public API: ' || l_api_name || ' end');
1982:
1983: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1984: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1979: IF l_debug THEN
1980: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1981: 'Public API: ' || l_api_name || ' end');
1982:
1983: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1984: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1985:
1986: END IF;
1987:

Line 1996: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1992: );
1993:
1994: EXCEPTION
1995: WHEN FND_API.G_EXC_ERROR THEN
1996: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1997: P_MODULE => l_module
1998: ,P_API_NAME => L_API_NAME
1999: ,P_PKG_NAME => G_PKG_NAME
2000: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2001: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

1997: P_MODULE => l_module
1998: ,P_API_NAME => L_API_NAME
1999: ,P_PKG_NAME => G_PKG_NAME
2000: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2001: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2002: ,X_MSG_COUNT => X_MSG_COUNT
2003: ,X_MSG_DATA => X_MSG_DATA
2004: ,X_RETURN_STATUS => X_RETURN_STATUS);
2005:

Line 2007: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2003: ,X_MSG_DATA => X_MSG_DATA
2004: ,X_RETURN_STATUS => X_RETURN_STATUS);
2005:
2006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2007: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2008: P_MODULE => l_module
2009: ,P_API_NAME => L_API_NAME
2010: ,P_PKG_NAME => G_PKG_NAME
2011: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 2012: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2008: P_MODULE => l_module
2009: ,P_API_NAME => L_API_NAME
2010: ,P_PKG_NAME => G_PKG_NAME
2011: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2012: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2013: ,X_MSG_COUNT => X_MSG_COUNT
2014: ,X_MSG_DATA => X_MSG_DATA
2015: ,X_RETURN_STATUS => X_RETURN_STATUS);
2016:

Line 2018: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2014: ,X_MSG_DATA => X_MSG_DATA
2015: ,X_RETURN_STATUS => X_RETURN_STATUS);
2016:
2017: WHEN OTHERS THEN
2018: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2019: P_MODULE => l_module
2020: ,P_API_NAME => L_API_NAME
2021: ,P_PKG_NAME => G_PKG_NAME
2022: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 2022: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

2018: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2019: P_MODULE => l_module
2020: ,P_API_NAME => L_API_NAME
2021: ,P_PKG_NAME => G_PKG_NAME
2022: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2023: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2024: ,X_MSG_COUNT => X_MSG_COUNT
2025: ,X_MSG_DATA => X_MSG_DATA
2026: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2023: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2019: P_MODULE => l_module
2020: ,P_API_NAME => L_API_NAME
2021: ,P_PKG_NAME => G_PKG_NAME
2022: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2023: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2024: ,X_MSG_COUNT => X_MSG_COUNT
2025: ,X_MSG_DATA => X_MSG_DATA
2026: ,X_RETURN_STATUS => X_RETURN_STATUS);
2027: End Update_orders;

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

2073:
2074:
2075: -- Debug Message
2076: IF l_debug THEN
2077: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2078: 'Public API: ' || l_api_name || ' start');
2079:
2080: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2081: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2076: IF l_debug THEN
2077: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2078: 'Public API: ' || l_api_name || ' start');
2079:
2080: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2081: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2082: END IF;
2083:
2084: -- Initialize API return status to SUCCESS

Line 2095: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2091: /*****
2092:
2093: -- Debug Message
2094: IF l_debug THEN
2095: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2096: 'AS: Public API: Convert_Order_Values_To_Ids');
2097: END IF;
2098:
2099: -- Convert the values to ids

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

2140:
2141:
2142: -- Debug Message
2143: IF l_debug THEN
2144: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2145: 'Public API: ' || l_api_name || ' end');
2146:
2147: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2148: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2143: IF l_debug THEN
2144: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2145: 'Public API: ' || l_api_name || ' end');
2146:
2147: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2148: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2149: END IF;
2150:
2151:

Line 2160: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2156: );
2157:
2158: EXCEPTION
2159: WHEN FND_API.G_EXC_ERROR THEN
2160: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2161: P_MODULE => l_module
2162: ,P_API_NAME => L_API_NAME
2163: ,P_PKG_NAME => G_PKG_NAME
2164: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2165: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2161: P_MODULE => l_module
2162: ,P_API_NAME => L_API_NAME
2163: ,P_PKG_NAME => G_PKG_NAME
2164: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2165: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2166: ,X_MSG_COUNT => X_MSG_COUNT
2167: ,X_MSG_DATA => X_MSG_DATA
2168: ,X_RETURN_STATUS => X_RETURN_STATUS);
2169:

Line 2171: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2167: ,X_MSG_DATA => X_MSG_DATA
2168: ,X_RETURN_STATUS => X_RETURN_STATUS);
2169:
2170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2171: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2172: P_MODULE => l_module
2173: ,P_API_NAME => L_API_NAME
2174: ,P_PKG_NAME => G_PKG_NAME
2175: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 2176: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2172: P_MODULE => l_module
2173: ,P_API_NAME => L_API_NAME
2174: ,P_PKG_NAME => G_PKG_NAME
2175: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2176: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2177: ,X_MSG_COUNT => X_MSG_COUNT
2178: ,X_MSG_DATA => X_MSG_DATA
2179: ,X_RETURN_STATUS => X_RETURN_STATUS);
2180:

Line 2182: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2178: ,X_MSG_DATA => X_MSG_DATA
2179: ,X_RETURN_STATUS => X_RETURN_STATUS);
2180:
2181: WHEN OTHERS THEN
2182: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2183: P_MODULE => l_module
2184: ,P_API_NAME => L_API_NAME
2185: ,P_PKG_NAME => G_PKG_NAME
2186: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 2186: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

2182: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2183: P_MODULE => l_module
2184: ,P_API_NAME => L_API_NAME
2185: ,P_PKG_NAME => G_PKG_NAME
2186: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2187: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2188: ,X_MSG_COUNT => X_MSG_COUNT
2189: ,X_MSG_DATA => X_MSG_DATA
2190: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2187: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2183: P_MODULE => l_module
2184: ,P_API_NAME => L_API_NAME
2185: ,P_PKG_NAME => G_PKG_NAME
2186: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2187: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2188: ,X_MSG_COUNT => X_MSG_COUNT
2189: ,X_MSG_DATA => X_MSG_DATA
2190: ,X_RETURN_STATUS => X_RETURN_STATUS);
2191: End Delete_orders;

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

2238:
2239:
2240: -- Debug Message
2241: IF l_debug THEN
2242: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2243: 'Public API: ' || l_api_name || ' start');
2244:
2245: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2246: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2241: IF l_debug THEN
2242: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2243: 'Public API: ' || l_api_name || ' start');
2244:
2245: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2246: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2247:
2248: END IF;
2249: -- Initialize API return status to SUCCESS

Line 2260: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2256: /*****
2257:
2258: -- Debug Message
2259: IF l_debug THEN
2260: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2261: 'AS: Public API: Convert_Competitor_Values_To_Ids');
2262: END IF;
2263:
2264: -- Convert the values to ids

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

2307:
2308:
2309: -- Debug Message
2310: IF l_debug THEN
2311: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2312: 'Public API: ' || l_api_name || ' end');
2313:
2314: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2315: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2310: IF l_debug THEN
2311: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2312: 'Public API: ' || l_api_name || ' end');
2313:
2314: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2315: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2316:
2317: END IF;
2318:

Line 2327: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2323: );
2324:
2325: EXCEPTION
2326: WHEN FND_API.G_EXC_ERROR THEN
2327: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2328: P_MODULE => l_module
2329: ,P_API_NAME => L_API_NAME
2330: ,P_PKG_NAME => G_PKG_NAME
2331: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2332: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2328: P_MODULE => l_module
2329: ,P_API_NAME => L_API_NAME
2330: ,P_PKG_NAME => G_PKG_NAME
2331: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2332: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2333: ,X_MSG_COUNT => X_MSG_COUNT
2334: ,X_MSG_DATA => X_MSG_DATA
2335: ,X_RETURN_STATUS => X_RETURN_STATUS);
2336:

Line 2338: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2334: ,X_MSG_DATA => X_MSG_DATA
2335: ,X_RETURN_STATUS => X_RETURN_STATUS);
2336:
2337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2338: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2339: P_MODULE => l_module
2340: ,P_API_NAME => L_API_NAME
2341: ,P_PKG_NAME => G_PKG_NAME
2342: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 2343: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2339: P_MODULE => l_module
2340: ,P_API_NAME => L_API_NAME
2341: ,P_PKG_NAME => G_PKG_NAME
2342: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2343: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2344: ,X_MSG_COUNT => X_MSG_COUNT
2345: ,X_MSG_DATA => X_MSG_DATA
2346: ,X_RETURN_STATUS => X_RETURN_STATUS);
2347:

Line 2349: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2345: ,X_MSG_DATA => X_MSG_DATA
2346: ,X_RETURN_STATUS => X_RETURN_STATUS);
2347:
2348: WHEN OTHERS THEN
2349: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2350: P_MODULE => l_module
2351: ,P_API_NAME => L_API_NAME
2352: ,P_PKG_NAME => G_PKG_NAME
2353: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 2353: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

2349: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2350: P_MODULE => l_module
2351: ,P_API_NAME => L_API_NAME
2352: ,P_PKG_NAME => G_PKG_NAME
2353: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2354: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2355: ,X_MSG_COUNT => X_MSG_COUNT
2356: ,X_MSG_DATA => X_MSG_DATA
2357: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2354: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2350: P_MODULE => l_module
2351: ,P_API_NAME => L_API_NAME
2352: ,P_PKG_NAME => G_PKG_NAME
2353: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2354: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2355: ,X_MSG_COUNT => X_MSG_COUNT
2356: ,X_MSG_DATA => X_MSG_DATA
2357: ,X_RETURN_STATUS => X_RETURN_STATUS);
2358: End Create_competitors;

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

2404:
2405:
2406: -- Debug Message
2407: IF l_debug THEN
2408: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2409: 'Public API: ' || l_api_name || ' start');
2410:
2411: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2412: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2407: IF l_debug THEN
2408: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2409: 'Public API: ' || l_api_name || ' start');
2410:
2411: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2412: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2413:
2414: END IF;
2415:

Line 2426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2422:
2423: /*****
2424: -- Debug Message
2425: IF l_debug THEN
2426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2427: 'AS: Public API: Convert_Competitor_Values_To_Ids');
2428:
2429:
2430: END IF;

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

2473:
2474:
2475: -- Debug Message
2476: IF l_debug THEN
2477: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2478: 'Public API: ' || l_api_name || ' end');
2479:
2480: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2481: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2476: IF l_debug THEN
2477: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2478: 'Public API: ' || l_api_name || ' end');
2479:
2480: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2481: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2482:
2483: END IF;
2484: -- Standard call to get message count and if count is 1, get message info.

Line 2492: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2488: );
2489:
2490: EXCEPTION
2491: WHEN FND_API.G_EXC_ERROR THEN
2492: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2493: P_MODULE => l_module
2494: ,P_API_NAME => L_API_NAME
2495: ,P_PKG_NAME => G_PKG_NAME
2496: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2497: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2493: P_MODULE => l_module
2494: ,P_API_NAME => L_API_NAME
2495: ,P_PKG_NAME => G_PKG_NAME
2496: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2497: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2498: ,X_MSG_COUNT => X_MSG_COUNT
2499: ,X_MSG_DATA => X_MSG_DATA
2500: ,X_RETURN_STATUS => X_RETURN_STATUS);
2501:

Line 2503: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2499: ,X_MSG_DATA => X_MSG_DATA
2500: ,X_RETURN_STATUS => X_RETURN_STATUS);
2501:
2502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2503: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2504: P_MODULE => l_module
2505: ,P_API_NAME => L_API_NAME
2506: ,P_PKG_NAME => G_PKG_NAME
2507: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 2508: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2504: P_MODULE => l_module
2505: ,P_API_NAME => L_API_NAME
2506: ,P_PKG_NAME => G_PKG_NAME
2507: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2508: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2509: ,X_MSG_COUNT => X_MSG_COUNT
2510: ,X_MSG_DATA => X_MSG_DATA
2511: ,X_RETURN_STATUS => X_RETURN_STATUS);
2512:

Line 2514: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2510: ,X_MSG_DATA => X_MSG_DATA
2511: ,X_RETURN_STATUS => X_RETURN_STATUS);
2512:
2513: WHEN OTHERS THEN
2514: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2515: P_MODULE => l_module
2516: ,P_API_NAME => L_API_NAME
2517: ,P_PKG_NAME => G_PKG_NAME
2518: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 2518: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

2514: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2515: P_MODULE => l_module
2516: ,P_API_NAME => L_API_NAME
2517: ,P_PKG_NAME => G_PKG_NAME
2518: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2519: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2520: ,X_MSG_COUNT => X_MSG_COUNT
2521: ,X_MSG_DATA => X_MSG_DATA
2522: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2519: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2515: P_MODULE => l_module
2516: ,P_API_NAME => L_API_NAME
2517: ,P_PKG_NAME => G_PKG_NAME
2518: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2519: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2520: ,X_MSG_COUNT => X_MSG_COUNT
2521: ,X_MSG_DATA => X_MSG_DATA
2522: ,X_RETURN_STATUS => X_RETURN_STATUS);
2523: End Update_competitors;

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

2569:
2570:
2571: -- Debug Message
2572: IF l_debug THEN
2573: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2574: 'Public API: ' || l_api_name || ' start');
2575:
2576: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2577: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2572: IF l_debug THEN
2573: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2574: 'Public API: ' || l_api_name || ' start');
2575:
2576: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2577: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2578:
2579: END IF;
2580:

Line 2591: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2587:
2588: /*****
2589: -- Debug Message
2590: IF l_debug THEN
2591: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2592: 'AS: Public API: Convert_Competitor_Values_To_Ids');
2593:
2594: END IF;
2595:

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

2637:
2638:
2639: -- Debug Message
2640: IF l_debug THEN
2641: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2642: 'Public API: ' || l_api_name || ' end');
2643:
2644: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2645: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2640: IF l_debug THEN
2641: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2642: 'Public API: ' || l_api_name || ' end');
2643:
2644: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2645: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2646: END IF;
2647:
2648: -- Standard call to get message count and if count is 1, get message info.

Line 2656: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2652: );
2653:
2654: EXCEPTION
2655: WHEN FND_API.G_EXC_ERROR THEN
2656: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2657: P_MODULE => l_module
2658: ,P_API_NAME => L_API_NAME
2659: ,P_PKG_NAME => G_PKG_NAME
2660: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2661: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2657: P_MODULE => l_module
2658: ,P_API_NAME => L_API_NAME
2659: ,P_PKG_NAME => G_PKG_NAME
2660: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2661: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2662: ,X_MSG_COUNT => X_MSG_COUNT
2663: ,X_MSG_DATA => X_MSG_DATA
2664: ,X_RETURN_STATUS => X_RETURN_STATUS);
2665:

Line 2667: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2663: ,X_MSG_DATA => X_MSG_DATA
2664: ,X_RETURN_STATUS => X_RETURN_STATUS);
2665:
2666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2667: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2668: P_MODULE => l_module
2669: ,P_API_NAME => L_API_NAME
2670: ,P_PKG_NAME => G_PKG_NAME
2671: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 2672: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2668: P_MODULE => l_module
2669: ,P_API_NAME => L_API_NAME
2670: ,P_PKG_NAME => G_PKG_NAME
2671: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2672: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2673: ,X_MSG_COUNT => X_MSG_COUNT
2674: ,X_MSG_DATA => X_MSG_DATA
2675: ,X_RETURN_STATUS => X_RETURN_STATUS);
2676:

Line 2678: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2674: ,X_MSG_DATA => X_MSG_DATA
2675: ,X_RETURN_STATUS => X_RETURN_STATUS);
2676:
2677: WHEN OTHERS THEN
2678: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2679: P_MODULE => l_module
2680: ,P_API_NAME => L_API_NAME
2681: ,P_PKG_NAME => G_PKG_NAME
2682: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 2682: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

2678: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2679: P_MODULE => l_module
2680: ,P_API_NAME => L_API_NAME
2681: ,P_PKG_NAME => G_PKG_NAME
2682: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2683: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2684: ,X_MSG_COUNT => X_MSG_COUNT
2685: ,X_MSG_DATA => X_MSG_DATA
2686: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2683: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2679: P_MODULE => l_module
2680: ,P_API_NAME => L_API_NAME
2681: ,P_PKG_NAME => G_PKG_NAME
2682: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2683: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2684: ,X_MSG_COUNT => X_MSG_COUNT
2685: ,X_MSG_DATA => X_MSG_DATA
2686: ,X_RETURN_STATUS => X_RETURN_STATUS);
2687: End Delete_competitors;

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

2734:
2735:
2736: -- Debug Message
2737: IF l_debug THEN
2738: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2739: 'Public API: ' || l_api_name || ' start');
2740:
2741: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2742: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2737: IF l_debug THEN
2738: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2739: 'Public API: ' || l_api_name || ' start');
2740:
2741: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2742: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2743:
2744: END IF;
2745:

Line 2757: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2753: /*****
2754:
2755: -- Debug Message
2756: IF l_debug THEN
2757: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2758: 'AS: Public API: Convert_Competitor_Prod_Values_To_Ids');
2759: END IF;
2760:
2761: -- Convert the values to ids

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

2804:
2805:
2806: -- Debug Message
2807: IF l_debug THEN
2808: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2809: 'Public API: ' || l_api_name || ' end');
2810:
2811: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2812: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2807: IF l_debug THEN
2808: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2809: 'Public API: ' || l_api_name || ' end');
2810:
2811: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2812: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2813: END IF;
2814:
2815:

Line 2824: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2820: );
2821:
2822: EXCEPTION
2823: WHEN FND_API.G_EXC_ERROR THEN
2824: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2825: P_MODULE => l_module
2826: ,P_API_NAME => L_API_NAME
2827: ,P_PKG_NAME => G_PKG_NAME
2828: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2829: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2825: P_MODULE => l_module
2826: ,P_API_NAME => L_API_NAME
2827: ,P_PKG_NAME => G_PKG_NAME
2828: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2829: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2830: ,X_MSG_COUNT => X_MSG_COUNT
2831: ,X_MSG_DATA => X_MSG_DATA
2832: ,X_RETURN_STATUS => X_RETURN_STATUS);
2833:

Line 2835: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2831: ,X_MSG_DATA => X_MSG_DATA
2832: ,X_RETURN_STATUS => X_RETURN_STATUS);
2833:
2834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2835: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2836: P_MODULE => l_module
2837: ,P_API_NAME => L_API_NAME
2838: ,P_PKG_NAME => G_PKG_NAME
2839: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 2840: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2836: P_MODULE => l_module
2837: ,P_API_NAME => L_API_NAME
2838: ,P_PKG_NAME => G_PKG_NAME
2839: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2840: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2841: ,X_MSG_COUNT => X_MSG_COUNT
2842: ,X_MSG_DATA => X_MSG_DATA
2843: ,X_RETURN_STATUS => X_RETURN_STATUS);
2844:

Line 2846: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2842: ,X_MSG_DATA => X_MSG_DATA
2843: ,X_RETURN_STATUS => X_RETURN_STATUS);
2844:
2845: WHEN OTHERS THEN
2846: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2847: P_MODULE => l_module
2848: ,P_API_NAME => L_API_NAME
2849: ,P_PKG_NAME => G_PKG_NAME
2850: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 2850: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

2846: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2847: P_MODULE => l_module
2848: ,P_API_NAME => L_API_NAME
2849: ,P_PKG_NAME => G_PKG_NAME
2850: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2851: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2852: ,X_MSG_COUNT => X_MSG_COUNT
2853: ,X_MSG_DATA => X_MSG_DATA
2854: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2851: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2847: P_MODULE => l_module
2848: ,P_API_NAME => L_API_NAME
2849: ,P_PKG_NAME => G_PKG_NAME
2850: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2851: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2852: ,X_MSG_COUNT => X_MSG_COUNT
2853: ,X_MSG_DATA => X_MSG_DATA
2854: ,X_RETURN_STATUS => X_RETURN_STATUS);
2855: End Create_competitor_prods;

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

2901:
2902:
2903: -- Debug Message
2904: IF l_debug THEN
2905: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2906: 'Public API: ' || l_api_name || ' start');
2907:
2908: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2909: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2904: IF l_debug THEN
2905: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2906: 'Public API: ' || l_api_name || ' start');
2907:
2908: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2909: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2910:
2911: END IF;
2912:

Line 2923: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2919:
2920: /*****
2921: -- Debug Message
2922: IF l_debug THEN
2923: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2924: 'AS: Public API: Convert_Competitor_Prod_Values_To_Ids');
2925: END IF;
2926:
2927:

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

2969:
2970:
2971: -- Debug Message
2972: IF l_debug THEN
2973: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2974: 'Public API: ' || l_api_name || ' end');
2975:
2976: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2977: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2972: IF l_debug THEN
2973: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2974: 'Public API: ' || l_api_name || ' end');
2975:
2976: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2977: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2978: END IF;
2979:
2980: -- Standard call to get message count and if count is 1, get message info.

Line 2988: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2984: );
2985:
2986: EXCEPTION
2987: WHEN FND_API.G_EXC_ERROR THEN
2988: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2989: P_MODULE => l_module
2990: ,P_API_NAME => L_API_NAME
2991: ,P_PKG_NAME => G_PKG_NAME
2992: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2993: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

2989: P_MODULE => l_module
2990: ,P_API_NAME => L_API_NAME
2991: ,P_PKG_NAME => G_PKG_NAME
2992: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2993: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2994: ,X_MSG_COUNT => X_MSG_COUNT
2995: ,X_MSG_DATA => X_MSG_DATA
2996: ,X_RETURN_STATUS => X_RETURN_STATUS);
2997:

Line 2999: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2995: ,X_MSG_DATA => X_MSG_DATA
2996: ,X_RETURN_STATUS => X_RETURN_STATUS);
2997:
2998: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2999: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3000: P_MODULE => l_module
3001: ,P_API_NAME => L_API_NAME
3002: ,P_PKG_NAME => G_PKG_NAME
3003: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 3004: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

3000: P_MODULE => l_module
3001: ,P_API_NAME => L_API_NAME
3002: ,P_PKG_NAME => G_PKG_NAME
3003: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3004: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3005: ,X_MSG_COUNT => X_MSG_COUNT
3006: ,X_MSG_DATA => X_MSG_DATA
3007: ,X_RETURN_STATUS => X_RETURN_STATUS);
3008:

Line 3010: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3006: ,X_MSG_DATA => X_MSG_DATA
3007: ,X_RETURN_STATUS => X_RETURN_STATUS);
3008:
3009: WHEN OTHERS THEN
3010: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3011: P_MODULE => l_module
3012: ,P_API_NAME => L_API_NAME
3013: ,P_PKG_NAME => G_PKG_NAME
3014: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 3014: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

3010: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3011: P_MODULE => l_module
3012: ,P_API_NAME => L_API_NAME
3013: ,P_PKG_NAME => G_PKG_NAME
3014: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3015: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3016: ,X_MSG_COUNT => X_MSG_COUNT
3017: ,X_MSG_DATA => X_MSG_DATA
3018: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3015: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

3011: P_MODULE => l_module
3012: ,P_API_NAME => L_API_NAME
3013: ,P_PKG_NAME => G_PKG_NAME
3014: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3015: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3016: ,X_MSG_COUNT => X_MSG_COUNT
3017: ,X_MSG_DATA => X_MSG_DATA
3018: ,X_RETURN_STATUS => X_RETURN_STATUS);
3019: End Update_competitor_prods;

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

3065:
3066:
3067: -- Debug Message
3068: IF l_debug THEN
3069: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3070: 'Public API: ' || l_api_name || ' start');
3071:
3072: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3073: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

3068: IF l_debug THEN
3069: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3070: 'Public API: ' || l_api_name || ' start');
3071:
3072: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3073: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3074: END IF;
3075:
3076:

Line 3087: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3083:
3084: /*****
3085: -- Debug Message
3086: IF l_debug THEN
3087: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3088: 'AS: Public API: Convert_Competitor_Prod_Values_To_Ids');
3089: END IF;
3090:
3091:

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

3133:
3134:
3135: -- Debug Message
3136: IF l_debug THEN
3137: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3138: 'Public API: ' || l_api_name || ' end');
3139:
3140: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3141: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

3136: IF l_debug THEN
3137: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3138: 'Public API: ' || l_api_name || ' end');
3139:
3140: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3141: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3142: END IF;
3143:
3144:

Line 3153: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3149: );
3150:
3151: EXCEPTION
3152: WHEN FND_API.G_EXC_ERROR THEN
3153: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3154: P_MODULE => l_module
3155: ,P_API_NAME => L_API_NAME
3156: ,P_PKG_NAME => G_PKG_NAME
3157: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 3158: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

3154: P_MODULE => l_module
3155: ,P_API_NAME => L_API_NAME
3156: ,P_PKG_NAME => G_PKG_NAME
3157: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3158: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3159: ,X_MSG_COUNT => X_MSG_COUNT
3160: ,X_MSG_DATA => X_MSG_DATA
3161: ,X_RETURN_STATUS => X_RETURN_STATUS);
3162:

Line 3164: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3160: ,X_MSG_DATA => X_MSG_DATA
3161: ,X_RETURN_STATUS => X_RETURN_STATUS);
3162:
3163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3164: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3165: P_MODULE => l_module
3166: ,P_API_NAME => L_API_NAME
3167: ,P_PKG_NAME => G_PKG_NAME
3168: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 3169: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

3165: P_MODULE => l_module
3166: ,P_API_NAME => L_API_NAME
3167: ,P_PKG_NAME => G_PKG_NAME
3168: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3169: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3170: ,X_MSG_COUNT => X_MSG_COUNT
3171: ,X_MSG_DATA => X_MSG_DATA
3172: ,X_RETURN_STATUS => X_RETURN_STATUS);
3173:

Line 3175: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3171: ,X_MSG_DATA => X_MSG_DATA
3172: ,X_RETURN_STATUS => X_RETURN_STATUS);
3173:
3174: WHEN OTHERS THEN
3175: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3176: P_MODULE => l_module
3177: ,P_API_NAME => L_API_NAME
3178: ,P_PKG_NAME => G_PKG_NAME
3179: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 3179: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

3175: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3176: P_MODULE => l_module
3177: ,P_API_NAME => L_API_NAME
3178: ,P_PKG_NAME => G_PKG_NAME
3179: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3180: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3181: ,X_MSG_COUNT => X_MSG_COUNT
3182: ,X_MSG_DATA => X_MSG_DATA
3183: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3180: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

3176: P_MODULE => l_module
3177: ,P_API_NAME => L_API_NAME
3178: ,P_PKG_NAME => G_PKG_NAME
3179: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3180: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3181: ,X_MSG_COUNT => X_MSG_COUNT
3182: ,X_MSG_DATA => X_MSG_DATA
3183: ,X_RETURN_STATUS => X_RETURN_STATUS);
3184: End Delete_competitor_prods;

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

3230:
3231:
3232: -- Debug Message
3233: IF l_debug THEN
3234: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3235: 'Public API: ' || l_api_name || ' start');
3236:
3237: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3238: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

3233: IF l_debug THEN
3234: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3235: 'Public API: ' || l_api_name || ' start');
3236:
3237: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3238: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3239: END IF;
3240:
3241:

Line 3253: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3249: /*****
3250:
3251: -- Debug Message
3252: IF l_debug THEN
3253: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3254: 'AS: Public API: Convert_Decision_Factor_Values_To_Ids');
3255: END IF;
3256:
3257: -- Convert the values to ids

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

3300:
3301:
3302: -- Debug Message
3303: IF l_debug THEN
3304: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3305: 'Public API: ' || l_api_name || ' end');
3306:
3307: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3308: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

3303: IF l_debug THEN
3304: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3305: 'Public API: ' || l_api_name || ' end');
3306:
3307: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3308: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3309: END IF;
3310:
3311:

Line 3320: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3316: );
3317:
3318: EXCEPTION
3319: WHEN FND_API.G_EXC_ERROR THEN
3320: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3321: P_MODULE => l_module
3322: ,P_API_NAME => L_API_NAME
3323: ,P_PKG_NAME => G_PKG_NAME
3324: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 3325: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

3321: P_MODULE => l_module
3322: ,P_API_NAME => L_API_NAME
3323: ,P_PKG_NAME => G_PKG_NAME
3324: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3325: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3326: ,X_MSG_COUNT => X_MSG_COUNT
3327: ,X_MSG_DATA => X_MSG_DATA
3328: ,X_RETURN_STATUS => X_RETURN_STATUS);
3329:

Line 3331: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3327: ,X_MSG_DATA => X_MSG_DATA
3328: ,X_RETURN_STATUS => X_RETURN_STATUS);
3329:
3330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3331: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3332: P_MODULE => l_module
3333: ,P_API_NAME => L_API_NAME
3334: ,P_PKG_NAME => G_PKG_NAME
3335: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 3336: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

3332: P_MODULE => l_module
3333: ,P_API_NAME => L_API_NAME
3334: ,P_PKG_NAME => G_PKG_NAME
3335: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3336: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3337: ,X_MSG_COUNT => X_MSG_COUNT
3338: ,X_MSG_DATA => X_MSG_DATA
3339: ,X_RETURN_STATUS => X_RETURN_STATUS);
3340:

Line 3342: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3338: ,X_MSG_DATA => X_MSG_DATA
3339: ,X_RETURN_STATUS => X_RETURN_STATUS);
3340:
3341: WHEN OTHERS THEN
3342: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3343: P_MODULE => l_module
3344: ,P_API_NAME => L_API_NAME
3345: ,P_PKG_NAME => G_PKG_NAME
3346: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 3346: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

3342: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3343: P_MODULE => l_module
3344: ,P_API_NAME => L_API_NAME
3345: ,P_PKG_NAME => G_PKG_NAME
3346: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3347: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3348: ,X_MSG_COUNT => X_MSG_COUNT
3349: ,X_MSG_DATA => X_MSG_DATA
3350: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3347: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

3343: P_MODULE => l_module
3344: ,P_API_NAME => L_API_NAME
3345: ,P_PKG_NAME => G_PKG_NAME
3346: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3347: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3348: ,X_MSG_COUNT => X_MSG_COUNT
3349: ,X_MSG_DATA => X_MSG_DATA
3350: ,X_RETURN_STATUS => X_RETURN_STATUS);
3351: End Create_decision_factors;

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

3397:
3398:
3399: -- Debug Message
3400: IF l_debug THEN
3401: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3402: 'Public API: ' || l_api_name || ' start');
3403:
3404: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3405: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

3400: IF l_debug THEN
3401: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3402: 'Public API: ' || l_api_name || ' start');
3403:
3404: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3405: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3406: END IF;
3407:
3408: -- Initialize API return status to SUCCESS

Line 3418: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3414:
3415: /*****
3416: -- Debug Message
3417: IF l_debug THEN
3418: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3419: 'AS: Public API: Convert_Decision_Factor_Values_To_Ids');
3420: END IF;
3421:
3422:

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

3464:
3465:
3466: -- Debug Message
3467: IF l_debug THEN
3468: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3469: 'Public API: ' || l_api_name || ' end');
3470:
3471: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3472: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

3467: IF l_debug THEN
3468: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3469: 'Public API: ' || l_api_name || ' end');
3470:
3471: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3472: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3473: END IF;
3474:
3475:

Line 3484: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3480: );
3481:
3482: EXCEPTION
3483: WHEN FND_API.G_EXC_ERROR THEN
3484: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3485: P_MODULE => l_module
3486: ,P_API_NAME => L_API_NAME
3487: ,P_PKG_NAME => G_PKG_NAME
3488: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 3489: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

3485: P_MODULE => l_module
3486: ,P_API_NAME => L_API_NAME
3487: ,P_PKG_NAME => G_PKG_NAME
3488: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3489: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3490: ,X_MSG_COUNT => X_MSG_COUNT
3491: ,X_MSG_DATA => X_MSG_DATA
3492: ,X_RETURN_STATUS => X_RETURN_STATUS);
3493:

Line 3495: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3491: ,X_MSG_DATA => X_MSG_DATA
3492: ,X_RETURN_STATUS => X_RETURN_STATUS);
3493:
3494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3495: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3496: P_MODULE => l_module
3497: ,P_API_NAME => L_API_NAME
3498: ,P_PKG_NAME => G_PKG_NAME
3499: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 3500: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

3496: P_MODULE => l_module
3497: ,P_API_NAME => L_API_NAME
3498: ,P_PKG_NAME => G_PKG_NAME
3499: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3500: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3501: ,X_MSG_COUNT => X_MSG_COUNT
3502: ,X_MSG_DATA => X_MSG_DATA
3503: ,X_RETURN_STATUS => X_RETURN_STATUS);
3504:

Line 3506: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3502: ,X_MSG_DATA => X_MSG_DATA
3503: ,X_RETURN_STATUS => X_RETURN_STATUS);
3504:
3505: WHEN OTHERS THEN
3506: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3507: P_MODULE => l_module
3508: ,P_API_NAME => L_API_NAME
3509: ,P_PKG_NAME => G_PKG_NAME
3510: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 3510: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

3506: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3507: P_MODULE => l_module
3508: ,P_API_NAME => L_API_NAME
3509: ,P_PKG_NAME => G_PKG_NAME
3510: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3511: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3512: ,X_MSG_COUNT => X_MSG_COUNT
3513: ,X_MSG_DATA => X_MSG_DATA
3514: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3511: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

3507: P_MODULE => l_module
3508: ,P_API_NAME => L_API_NAME
3509: ,P_PKG_NAME => G_PKG_NAME
3510: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3511: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3512: ,X_MSG_COUNT => X_MSG_COUNT
3513: ,X_MSG_DATA => X_MSG_DATA
3514: ,X_RETURN_STATUS => X_RETURN_STATUS);
3515: End Update_decision_factors;

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

3561:
3562:
3563: -- Debug Message
3564: IF l_debug THEN
3565: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3566: 'Public API: ' || l_api_name || ' start');
3567:
3568: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3569: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

3564: IF l_debug THEN
3565: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3566: 'Public API: ' || l_api_name || ' start');
3567:
3568: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3569: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3570: END IF;
3571:
3572:

Line 3583: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3579:
3580: /*****
3581: -- Debug Message
3582: IF l_debug THEN
3583: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3584: 'AS: Public API: Convert_Decision_Factor_Values_To_Ids');
3585: END IF;
3586:
3587:

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

3629:
3630:
3631: -- Debug Message
3632: IF l_debug THEN
3633: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3634: 'Public API: ' || l_api_name || ' end');
3635:
3636: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3637: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

3632: IF l_debug THEN
3633: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3634: 'Public API: ' || l_api_name || ' end');
3635:
3636: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3637: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3638: END IF;
3639:
3640:

Line 3649: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3645: );
3646:
3647: EXCEPTION
3648: WHEN FND_API.G_EXC_ERROR THEN
3649: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3650: P_MODULE => l_module
3651: ,P_API_NAME => L_API_NAME
3652: ,P_PKG_NAME => G_PKG_NAME
3653: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 3654: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

3650: P_MODULE => l_module
3651: ,P_API_NAME => L_API_NAME
3652: ,P_PKG_NAME => G_PKG_NAME
3653: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3654: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3655: ,X_MSG_COUNT => X_MSG_COUNT
3656: ,X_MSG_DATA => X_MSG_DATA
3657: ,X_RETURN_STATUS => X_RETURN_STATUS);
3658:

Line 3660: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3656: ,X_MSG_DATA => X_MSG_DATA
3657: ,X_RETURN_STATUS => X_RETURN_STATUS);
3658:
3659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3660: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3661: P_MODULE => l_module
3662: ,P_API_NAME => L_API_NAME
3663: ,P_PKG_NAME => G_PKG_NAME
3664: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 3665: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

3661: P_MODULE => l_module
3662: ,P_API_NAME => L_API_NAME
3663: ,P_PKG_NAME => G_PKG_NAME
3664: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3665: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3666: ,X_MSG_COUNT => X_MSG_COUNT
3667: ,X_MSG_DATA => X_MSG_DATA
3668: ,X_RETURN_STATUS => X_RETURN_STATUS);
3669:

Line 3671: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3667: ,X_MSG_DATA => X_MSG_DATA
3668: ,X_RETURN_STATUS => X_RETURN_STATUS);
3669:
3670: WHEN OTHERS THEN
3671: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3672: P_MODULE => l_module
3673: ,P_API_NAME => L_API_NAME
3674: ,P_PKG_NAME => G_PKG_NAME
3675: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 3675: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

3671: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3672: P_MODULE => l_module
3673: ,P_API_NAME => L_API_NAME
3674: ,P_PKG_NAME => G_PKG_NAME
3675: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3676: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3677: ,X_MSG_COUNT => X_MSG_COUNT
3678: ,X_MSG_DATA => X_MSG_DATA
3679: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3676: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

3672: P_MODULE => l_module
3673: ,P_API_NAME => L_API_NAME
3674: ,P_PKG_NAME => G_PKG_NAME
3675: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3676: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3677: ,X_MSG_COUNT => X_MSG_COUNT
3678: ,X_MSG_DATA => X_MSG_DATA
3679: ,X_RETURN_STATUS => X_RETURN_STATUS);
3680: End Delete_decision_factors;

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

3728:
3729:
3730: -- Debug Message
3731: IF l_debug THEN
3732: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3733: 'Public API: ' || l_api_name || ' start');
3734:
3735: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3736: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

3731: IF l_debug THEN
3732: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3733: 'Public API: ' || l_api_name || ' start');
3734:
3735: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3736: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3737: END IF;
3738:
3739:

Line 3750: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3746:
3747: /*****
3748: -- Debug Message
3749: IF l_debug THEN
3750: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3751: 'AS: Public API: Convert_Contact_Values_To_Ids');
3752: END IF;
3753:
3754: -- Convert the values to ids

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

3797:
3798:
3799: -- Debug Message
3800: IF l_debug THEN
3801: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3802: 'Public API: ' || l_api_name || ' end');
3803:
3804: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3805: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

3800: IF l_debug THEN
3801: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3802: 'Public API: ' || l_api_name || ' end');
3803:
3804: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3805: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3806:
3807: END IF;
3808:

Line 3817: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3813: );
3814:
3815: EXCEPTION
3816: WHEN FND_API.G_EXC_ERROR THEN
3817: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3818: P_MODULE => l_module
3819: ,P_API_NAME => L_API_NAME
3820: ,P_PKG_NAME => G_PKG_NAME
3821: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 3822: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

3818: P_MODULE => l_module
3819: ,P_API_NAME => L_API_NAME
3820: ,P_PKG_NAME => G_PKG_NAME
3821: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3822: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3823: ,X_MSG_COUNT => X_MSG_COUNT
3824: ,X_MSG_DATA => X_MSG_DATA
3825: ,X_RETURN_STATUS => X_RETURN_STATUS);
3826:

Line 3828: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3824: ,X_MSG_DATA => X_MSG_DATA
3825: ,X_RETURN_STATUS => X_RETURN_STATUS);
3826:
3827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3828: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3829: P_MODULE => l_module
3830: ,P_API_NAME => L_API_NAME
3831: ,P_PKG_NAME => G_PKG_NAME
3832: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 3833: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

3829: P_MODULE => l_module
3830: ,P_API_NAME => L_API_NAME
3831: ,P_PKG_NAME => G_PKG_NAME
3832: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3833: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3834: ,X_MSG_COUNT => X_MSG_COUNT
3835: ,X_MSG_DATA => X_MSG_DATA
3836: ,X_RETURN_STATUS => X_RETURN_STATUS);
3837:

Line 3839: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3835: ,X_MSG_DATA => X_MSG_DATA
3836: ,X_RETURN_STATUS => X_RETURN_STATUS);
3837:
3838: WHEN OTHERS THEN
3839: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3840: P_MODULE => l_module
3841: ,P_API_NAME => L_API_NAME
3842: ,P_PKG_NAME => G_PKG_NAME
3843: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 3843: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

3839: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3840: P_MODULE => l_module
3841: ,P_API_NAME => L_API_NAME
3842: ,P_PKG_NAME => G_PKG_NAME
3843: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3844: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3845: ,X_MSG_COUNT => X_MSG_COUNT
3846: ,X_MSG_DATA => X_MSG_DATA
3847: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3844: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

3840: P_MODULE => l_module
3841: ,P_API_NAME => L_API_NAME
3842: ,P_PKG_NAME => G_PKG_NAME
3843: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3844: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3845: ,X_MSG_COUNT => X_MSG_COUNT
3846: ,X_MSG_DATA => X_MSG_DATA
3847: ,X_RETURN_STATUS => X_RETURN_STATUS);
3848: End Create_contacts;

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

3894:
3895:
3896: -- Debug Message
3897: IF l_debug THEN
3898: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3899: 'Public API: ' || l_api_name || ' start');
3900:
3901: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3902: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

3897: IF l_debug THEN
3898: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3899: 'Public API: ' || l_api_name || ' start');
3900:
3901: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3902: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3903:
3904: END IF;
3905:

Line 3916: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3912:
3913: /*****
3914: -- Debug Message
3915: IF l_debug THEN
3916: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3917: 'AS: Public API: Convert_Contact_Values_To_Ids');
3918: END IF;
3919:
3920:

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

3962:
3963:
3964: -- Debug Message
3965: IF l_debug THEN
3966: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3967: 'Public API: ' || l_api_name || ' end');
3968:
3969: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3970: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

3965: IF l_debug THEN
3966: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3967: 'Public API: ' || l_api_name || ' end');
3968:
3969: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3970: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3971: END IF;
3972:
3973:

Line 3982: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3978: );
3979:
3980: EXCEPTION
3981: WHEN FND_API.G_EXC_ERROR THEN
3982: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3983: P_MODULE => l_module
3984: ,P_API_NAME => L_API_NAME
3985: ,P_PKG_NAME => G_PKG_NAME
3986: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 3987: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

3983: P_MODULE => l_module
3984: ,P_API_NAME => L_API_NAME
3985: ,P_PKG_NAME => G_PKG_NAME
3986: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3987: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3988: ,X_MSG_COUNT => X_MSG_COUNT
3989: ,X_MSG_DATA => X_MSG_DATA
3990: ,X_RETURN_STATUS => X_RETURN_STATUS);
3991:

Line 3993: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3989: ,X_MSG_DATA => X_MSG_DATA
3990: ,X_RETURN_STATUS => X_RETURN_STATUS);
3991:
3992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3993: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3994: P_MODULE => l_module
3995: ,P_API_NAME => L_API_NAME
3996: ,P_PKG_NAME => G_PKG_NAME
3997: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 3998: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

3994: P_MODULE => l_module
3995: ,P_API_NAME => L_API_NAME
3996: ,P_PKG_NAME => G_PKG_NAME
3997: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3998: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3999: ,X_MSG_COUNT => X_MSG_COUNT
4000: ,X_MSG_DATA => X_MSG_DATA
4001: ,X_RETURN_STATUS => X_RETURN_STATUS);
4002:

Line 4004: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4000: ,X_MSG_DATA => X_MSG_DATA
4001: ,X_RETURN_STATUS => X_RETURN_STATUS);
4002:
4003: WHEN OTHERS THEN
4004: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4005: P_MODULE => l_module
4006: ,P_API_NAME => L_API_NAME
4007: ,P_PKG_NAME => G_PKG_NAME
4008: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 4008: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

4004: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4005: P_MODULE => l_module
4006: ,P_API_NAME => L_API_NAME
4007: ,P_PKG_NAME => G_PKG_NAME
4008: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4009: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4010: ,X_MSG_COUNT => X_MSG_COUNT
4011: ,X_MSG_DATA => X_MSG_DATA
4012: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4009: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

4005: P_MODULE => l_module
4006: ,P_API_NAME => L_API_NAME
4007: ,P_PKG_NAME => G_PKG_NAME
4008: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4009: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4010: ,X_MSG_COUNT => X_MSG_COUNT
4011: ,X_MSG_DATA => X_MSG_DATA
4012: ,X_RETURN_STATUS => X_RETURN_STATUS);
4013: End Update_contacts;

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

4060:
4061:
4062: -- Debug Message
4063: IF l_debug THEN
4064: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4065: 'Public API: ' || l_api_name || ' start');
4066:
4067: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4068: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

4063: IF l_debug THEN
4064: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4065: 'Public API: ' || l_api_name || ' start');
4066:
4067: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4068: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4069: END IF;
4070:
4071:

Line 4082: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4078:
4079: /*****
4080: -- Debug Message
4081: IF l_debug THEN
4082: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4083: 'AS: Public API: Convert_Contact_Values_To_Ids');
4084: END IF;
4085:
4086:

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

4128:
4129:
4130: -- Debug Message
4131: IF l_debug THEN
4132: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4133: 'Public API: ' || l_api_name || ' end');
4134:
4135: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4136: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

4131: IF l_debug THEN
4132: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4133: 'Public API: ' || l_api_name || ' end');
4134:
4135: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4136: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4137: END IF;
4138:
4139:

Line 4148: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4144: );
4145:
4146: EXCEPTION
4147: WHEN FND_API.G_EXC_ERROR THEN
4148: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4149: P_MODULE => l_module
4150: ,P_API_NAME => L_API_NAME
4151: ,P_PKG_NAME => G_PKG_NAME
4152: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 4153: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

4149: P_MODULE => l_module
4150: ,P_API_NAME => L_API_NAME
4151: ,P_PKG_NAME => G_PKG_NAME
4152: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4153: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4154: ,X_MSG_COUNT => X_MSG_COUNT
4155: ,X_MSG_DATA => X_MSG_DATA
4156: ,X_RETURN_STATUS => X_RETURN_STATUS);
4157:

Line 4159: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4155: ,X_MSG_DATA => X_MSG_DATA
4156: ,X_RETURN_STATUS => X_RETURN_STATUS);
4157:
4158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4159: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4160: P_MODULE => l_module
4161: ,P_API_NAME => L_API_NAME
4162: ,P_PKG_NAME => G_PKG_NAME
4163: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 4164: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

4160: P_MODULE => l_module
4161: ,P_API_NAME => L_API_NAME
4162: ,P_PKG_NAME => G_PKG_NAME
4163: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4164: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4165: ,X_MSG_COUNT => X_MSG_COUNT
4166: ,X_MSG_DATA => X_MSG_DATA
4167: ,X_RETURN_STATUS => X_RETURN_STATUS);
4168:

Line 4170: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4166: ,X_MSG_DATA => X_MSG_DATA
4167: ,X_RETURN_STATUS => X_RETURN_STATUS);
4168:
4169: WHEN OTHERS THEN
4170: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4171: P_MODULE => l_module
4172: ,P_API_NAME => L_API_NAME
4173: ,P_PKG_NAME => G_PKG_NAME
4174: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 4174: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

4170: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4171: P_MODULE => l_module
4172: ,P_API_NAME => L_API_NAME
4173: ,P_PKG_NAME => G_PKG_NAME
4174: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4175: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4176: ,X_MSG_COUNT => X_MSG_COUNT
4177: ,X_MSG_DATA => X_MSG_DATA
4178: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4175: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

4171: P_MODULE => l_module
4172: ,P_API_NAME => L_API_NAME
4173: ,P_PKG_NAME => G_PKG_NAME
4174: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4175: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4176: ,X_MSG_COUNT => X_MSG_COUNT
4177: ,X_MSG_DATA => X_MSG_DATA
4178: ,X_RETURN_STATUS => X_RETURN_STATUS);
4179: End Delete_contacts;

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

4225:
4226:
4227: -- Debug Message
4228: IF l_debug THEN
4229: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4230: 'Public API: ' || l_api_name || ' start');
4231:
4232: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4233: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

4228: IF l_debug THEN
4229: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4230: 'Public API: ' || l_api_name || ' start');
4231:
4232: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4233: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4234: END IF;
4235:
4236:

Line 4248: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4244: /*****
4245:
4246: -- Debug Message
4247: IF l_debug THEN
4248: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4249: 'AS: Public API: Convert_Obstacle_Values_To_Ids');
4250:
4251: END IF;
4252:

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

4296:
4297:
4298: -- Debug Message
4299: IF l_debug THEN
4300: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4301: 'Public API: ' || l_api_name || ' end');
4302:
4303: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4304: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

4299: IF l_debug THEN
4300: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4301: 'Public API: ' || l_api_name || ' end');
4302:
4303: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4304: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4305:
4306: END IF;
4307:

Line 4316: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4312: );
4313:
4314: EXCEPTION
4315: WHEN FND_API.G_EXC_ERROR THEN
4316: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4317: P_MODULE => l_module
4318: ,P_API_NAME => L_API_NAME
4319: ,P_PKG_NAME => G_PKG_NAME
4320: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 4321: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

4317: P_MODULE => l_module
4318: ,P_API_NAME => L_API_NAME
4319: ,P_PKG_NAME => G_PKG_NAME
4320: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4321: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4322: ,X_MSG_COUNT => X_MSG_COUNT
4323: ,X_MSG_DATA => X_MSG_DATA
4324: ,X_RETURN_STATUS => X_RETURN_STATUS);
4325:

Line 4327: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4323: ,X_MSG_DATA => X_MSG_DATA
4324: ,X_RETURN_STATUS => X_RETURN_STATUS);
4325:
4326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4327: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4328: P_MODULE => l_module
4329: ,P_API_NAME => L_API_NAME
4330: ,P_PKG_NAME => G_PKG_NAME
4331: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 4332: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

4328: P_MODULE => l_module
4329: ,P_API_NAME => L_API_NAME
4330: ,P_PKG_NAME => G_PKG_NAME
4331: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4332: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4333: ,X_MSG_COUNT => X_MSG_COUNT
4334: ,X_MSG_DATA => X_MSG_DATA
4335: ,X_RETURN_STATUS => X_RETURN_STATUS);
4336:

Line 4338: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4334: ,X_MSG_DATA => X_MSG_DATA
4335: ,X_RETURN_STATUS => X_RETURN_STATUS);
4336:
4337: WHEN OTHERS THEN
4338: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4339: P_MODULE => l_module
4340: ,P_API_NAME => L_API_NAME
4341: ,P_PKG_NAME => G_PKG_NAME
4342: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 4342: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

4338: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4339: P_MODULE => l_module
4340: ,P_API_NAME => L_API_NAME
4341: ,P_PKG_NAME => G_PKG_NAME
4342: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4343: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4344: ,X_MSG_COUNT => X_MSG_COUNT
4345: ,X_MSG_DATA => X_MSG_DATA
4346: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4343: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

4339: P_MODULE => l_module
4340: ,P_API_NAME => L_API_NAME
4341: ,P_PKG_NAME => G_PKG_NAME
4342: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4343: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4344: ,X_MSG_COUNT => X_MSG_COUNT
4345: ,X_MSG_DATA => X_MSG_DATA
4346: ,X_RETURN_STATUS => X_RETURN_STATUS);
4347: End Create_obstacles;

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

4394:
4395:
4396: -- Debug Message
4397: IF l_debug THEN
4398: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4399: 'Public API: ' || l_api_name || ' start');
4400:
4401: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4402: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

4397: IF l_debug THEN
4398: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4399: 'Public API: ' || l_api_name || ' start');
4400:
4401: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4402: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4403:
4404: END IF;
4405:

Line 4416: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4412:
4413: /*****
4414: -- Debug Message
4415: IF l_debug THEN
4416: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4417: 'AS: Public API: Convert_Obstacle_Values_To_Ids');
4418: END IF;
4419:
4420: -- Convert the values to ids

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

4462:
4463:
4464: -- Debug Message
4465: IF l_debug THEN
4466: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4467: 'Public API: ' || l_api_name || ' end');
4468:
4469: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4470: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

4465: IF l_debug THEN
4466: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4467: 'Public API: ' || l_api_name || ' end');
4468:
4469: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4470: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4471: END IF;
4472:
4473:

Line 4482: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4478: );
4479:
4480: EXCEPTION
4481: WHEN FND_API.G_EXC_ERROR THEN
4482: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4483: P_MODULE => l_module
4484: ,P_API_NAME => L_API_NAME
4485: ,P_PKG_NAME => G_PKG_NAME
4486: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 4487: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

4483: P_MODULE => l_module
4484: ,P_API_NAME => L_API_NAME
4485: ,P_PKG_NAME => G_PKG_NAME
4486: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4487: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4488: ,X_MSG_COUNT => X_MSG_COUNT
4489: ,X_MSG_DATA => X_MSG_DATA
4490: ,X_RETURN_STATUS => X_RETURN_STATUS);
4491:

Line 4493: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4489: ,X_MSG_DATA => X_MSG_DATA
4490: ,X_RETURN_STATUS => X_RETURN_STATUS);
4491:
4492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4493: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4494: P_MODULE => l_module
4495: ,P_API_NAME => L_API_NAME
4496: ,P_PKG_NAME => G_PKG_NAME
4497: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 4498: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

4494: P_MODULE => l_module
4495: ,P_API_NAME => L_API_NAME
4496: ,P_PKG_NAME => G_PKG_NAME
4497: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4498: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4499: ,X_MSG_COUNT => X_MSG_COUNT
4500: ,X_MSG_DATA => X_MSG_DATA
4501: ,X_RETURN_STATUS => X_RETURN_STATUS);
4502:

Line 4504: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4500: ,X_MSG_DATA => X_MSG_DATA
4501: ,X_RETURN_STATUS => X_RETURN_STATUS);
4502:
4503: WHEN OTHERS THEN
4504: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4505: P_MODULE => l_module
4506: ,P_API_NAME => L_API_NAME
4507: ,P_PKG_NAME => G_PKG_NAME
4508: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 4508: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

4504: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4505: P_MODULE => l_module
4506: ,P_API_NAME => L_API_NAME
4507: ,P_PKG_NAME => G_PKG_NAME
4508: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4509: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4510: ,X_MSG_COUNT => X_MSG_COUNT
4511: ,X_MSG_DATA => X_MSG_DATA
4512: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4509: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

4505: P_MODULE => l_module
4506: ,P_API_NAME => L_API_NAME
4507: ,P_PKG_NAME => G_PKG_NAME
4508: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4509: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4510: ,X_MSG_COUNT => X_MSG_COUNT
4511: ,X_MSG_DATA => X_MSG_DATA
4512: ,X_RETURN_STATUS => X_RETURN_STATUS);
4513: End Update_obstacles;

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

4559:
4560:
4561: -- Debug Message
4562: IF l_debug THEN
4563: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4564: 'Public API: ' || l_api_name || ' start');
4565:
4566: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4567: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

4562: IF l_debug THEN
4563: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4564: 'Public API: ' || l_api_name || ' start');
4565:
4566: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4567: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4568:
4569: END IF;
4570:

Line 4582: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4578: /*****
4579:
4580: -- Debug Message
4581: IF l_debug THEN
4582: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4583: 'AS: Public API: Convert_Obstacle_Values_To_Ids');
4584:
4585: END IF;
4586:

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

4628:
4629:
4630: -- Debug Message
4631: IF l_debug THEN
4632: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4633: 'Public API: ' || l_api_name || ' end');
4634:
4635: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4636: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

4631: IF l_debug THEN
4632: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4633: 'Public API: ' || l_api_name || ' end');
4634:
4635: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4636: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4637: END IF;
4638:
4639:

Line 4648: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4644: );
4645:
4646: EXCEPTION
4647: WHEN FND_API.G_EXC_ERROR THEN
4648: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4649: P_MODULE => l_module
4650: ,P_API_NAME => L_API_NAME
4651: ,P_PKG_NAME => G_PKG_NAME
4652: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 4653: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

4649: P_MODULE => l_module
4650: ,P_API_NAME => L_API_NAME
4651: ,P_PKG_NAME => G_PKG_NAME
4652: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4653: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4654: ,X_MSG_COUNT => X_MSG_COUNT
4655: ,X_MSG_DATA => X_MSG_DATA
4656: ,X_RETURN_STATUS => X_RETURN_STATUS);
4657:

Line 4659: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4655: ,X_MSG_DATA => X_MSG_DATA
4656: ,X_RETURN_STATUS => X_RETURN_STATUS);
4657:
4658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4659: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4660: P_MODULE => l_module
4661: ,P_API_NAME => L_API_NAME
4662: ,P_PKG_NAME => G_PKG_NAME
4663: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 4664: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

4660: P_MODULE => l_module
4661: ,P_API_NAME => L_API_NAME
4662: ,P_PKG_NAME => G_PKG_NAME
4663: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4664: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4665: ,X_MSG_COUNT => X_MSG_COUNT
4666: ,X_MSG_DATA => X_MSG_DATA
4667: ,X_RETURN_STATUS => X_RETURN_STATUS);
4668:

Line 4670: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4666: ,X_MSG_DATA => X_MSG_DATA
4667: ,X_RETURN_STATUS => X_RETURN_STATUS);
4668:
4669: WHEN OTHERS THEN
4670: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4671: P_MODULE => l_module
4672: ,P_API_NAME => L_API_NAME
4673: ,P_PKG_NAME => G_PKG_NAME
4674: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 4674: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

4670: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4671: P_MODULE => l_module
4672: ,P_API_NAME => L_API_NAME
4673: ,P_PKG_NAME => G_PKG_NAME
4674: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4675: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4676: ,X_MSG_COUNT => X_MSG_COUNT
4677: ,X_MSG_DATA => X_MSG_DATA
4678: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4675: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

4671: P_MODULE => l_module
4672: ,P_API_NAME => L_API_NAME
4673: ,P_PKG_NAME => G_PKG_NAME
4674: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4675: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4676: ,X_MSG_COUNT => X_MSG_COUNT
4677: ,X_MSG_DATA => X_MSG_DATA
4678: ,X_RETURN_STATUS => X_RETURN_STATUS);
4679: End Delete_obstacles;

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

4752:
4753:
4754: -- Debug Message
4755: IF l_debug THEN
4756: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4757: 'Public API: ' || l_api_name || ' start');
4758:
4759: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4760: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

4755: IF l_debug THEN
4756: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4757: 'Public API: ' || l_api_name || ' start');
4758:
4759: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4760: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4761:
4762: END IF;
4763:

Line 4798: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'sales group id: '||l_sales_group_id );

4794: l_lead_id := l_sales_team_rec.lead_id;
4795: l_sales_group_id := l_sales_team_rec.sales_group_id;
4796: END IF;
4797: IF l_debug THEN
4798: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'sales group id: '||l_sales_group_id );
4799: END IF;
4800:
4801:
4802: OPEN C_SalesCredit_Exist (l_salesforce_id,l_lead_id, l_sales_group_id);

Line 4837: AS_UTILITY_PVT.Set_Message(l_module,

4833: -- FND_MESSAGE.Set_Token ('salesrep', l_person_name, FALSE);
4834: -- FND_MSG_PUB.Add;
4835: -- END IF;
4836:
4837: AS_UTILITY_PVT.Set_Message(l_module,
4838: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
4839: p_msg_name => 'AS_DELETE_SALESTEAM_NOTALLOWED',
4840: p_token1 => 'SALESREP',
4841: p_token1_value => l_person_name );

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

4877:
4878:
4879: -- Debug Message
4880: IF l_debug THEN
4881: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4882: 'Public API: ' || l_api_name || ' end');
4883:
4884: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4885: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

4880: IF l_debug THEN
4881: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4882: 'Public API: ' || l_api_name || ' end');
4883:
4884: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4885: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4886:
4887: END IF;
4888:

Line 4898: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4894:
4895:
4896: EXCEPTION
4897: WHEN FND_API.G_EXC_ERROR THEN
4898: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4899: P_MODULE => l_module
4900: ,P_API_NAME => L_API_NAME
4901: ,P_PKG_NAME => G_PKG_NAME
4902: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 4903: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

4899: P_MODULE => l_module
4900: ,P_API_NAME => L_API_NAME
4901: ,P_PKG_NAME => G_PKG_NAME
4902: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4903: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4904: ,X_MSG_COUNT => X_MSG_COUNT
4905: ,X_MSG_DATA => X_MSG_DATA
4906: ,X_RETURN_STATUS => X_RETURN_STATUS);
4907:

Line 4909: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4905: ,X_MSG_DATA => X_MSG_DATA
4906: ,X_RETURN_STATUS => X_RETURN_STATUS);
4907:
4908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4909: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4910: P_MODULE => l_module
4911: ,P_API_NAME => L_API_NAME
4912: ,P_PKG_NAME => G_PKG_NAME
4913: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 4914: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

4910: P_MODULE => l_module
4911: ,P_API_NAME => L_API_NAME
4912: ,P_PKG_NAME => G_PKG_NAME
4913: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4914: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4915: ,X_MSG_COUNT => X_MSG_COUNT
4916: ,X_MSG_DATA => X_MSG_DATA
4917: ,X_RETURN_STATUS => X_RETURN_STATUS);
4918:

Line 4920: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

4916: ,X_MSG_DATA => X_MSG_DATA
4917: ,X_RETURN_STATUS => X_RETURN_STATUS);
4918:
4919: WHEN OTHERS THEN
4920: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4921: P_MODULE => l_module
4922: ,P_API_NAME => L_API_NAME
4923: ,P_PKG_NAME => G_PKG_NAME
4924: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 4924: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

4920: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4921: P_MODULE => l_module
4922: ,P_API_NAME => L_API_NAME
4923: ,P_PKG_NAME => G_PKG_NAME
4924: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4925: ,P_SQLCODE => SQLCODE
4926: ,P_SQLERRM => SQLERRM
4927: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4928: ,P_ROLLBACK_FLAG => 'Y'

Line 4927: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

4923: ,P_PKG_NAME => G_PKG_NAME
4924: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4925: ,P_SQLCODE => SQLCODE
4926: ,P_SQLERRM => SQLERRM
4927: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4928: ,P_ROLLBACK_FLAG => 'Y'
4929: ,X_MSG_COUNT => X_MSG_COUNT
4930: ,X_MSG_DATA => X_MSG_DATA
4931: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

4996:
4997: -- Debug Message
4998:
4999: IF l_debug THEN
5000: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5001: 'Public API: ' || l_api_name || ' start');
5002:
5003: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5004: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

4999: IF l_debug THEN
5000: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5001: 'Public API: ' || l_api_name || ' start');
5002:
5003: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5004: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
5005:
5006: END IF;
5007:

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

5060:
5061:
5062: -- Debug Message
5063: IF l_debug THEN
5064: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5065: 'Public API: ' || l_api_name || ' end');
5066:
5067: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5068: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

5063: IF l_debug THEN
5064: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5065: 'Public API: ' || l_api_name || ' end');
5066:
5067: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5068: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
5069: END IF;
5070:
5071: -- Standard call to get message count and if count is 1, get message info.

Line 5079: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

5075: );
5076:
5077: EXCEPTION
5078: WHEN FND_API.G_EXC_ERROR THEN
5079: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
5080: P_MODULE => l_module
5081: ,P_API_NAME => L_API_NAME
5082: ,P_PKG_NAME => G_PKG_NAME
5083: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 5084: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

5080: P_MODULE => l_module
5081: ,P_API_NAME => L_API_NAME
5082: ,P_PKG_NAME => G_PKG_NAME
5083: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5084: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
5085: ,X_MSG_COUNT => X_MSG_COUNT
5086: ,X_MSG_DATA => X_MSG_DATA
5087: ,X_RETURN_STATUS => X_RETURN_STATUS);
5088:

Line 5090: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

5086: ,X_MSG_DATA => X_MSG_DATA
5087: ,X_RETURN_STATUS => X_RETURN_STATUS);
5088:
5089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5090: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
5091: P_MODULE => l_module
5092: ,P_API_NAME => L_API_NAME
5093: ,P_PKG_NAME => G_PKG_NAME
5094: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 5095: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

5091: P_MODULE => l_module
5092: ,P_API_NAME => L_API_NAME
5093: ,P_PKG_NAME => G_PKG_NAME
5094: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5095: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
5096: ,X_MSG_COUNT => X_MSG_COUNT
5097: ,X_MSG_DATA => X_MSG_DATA
5098: ,X_RETURN_STATUS => X_RETURN_STATUS);
5099:

Line 5101: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

5097: ,X_MSG_DATA => X_MSG_DATA
5098: ,X_RETURN_STATUS => X_RETURN_STATUS);
5099:
5100: WHEN OTHERS THEN
5101: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
5102: P_MODULE => l_module
5103: ,P_API_NAME => L_API_NAME
5104: ,P_PKG_NAME => G_PKG_NAME
5105: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 5105: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

5101: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
5102: P_MODULE => l_module
5103: ,P_API_NAME => L_API_NAME
5104: ,P_PKG_NAME => G_PKG_NAME
5105: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
5106: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
5107: ,X_MSG_COUNT => X_MSG_COUNT
5108: ,X_MSG_DATA => X_MSG_DATA
5109: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 5106: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

5102: P_MODULE => l_module
5103: ,P_API_NAME => L_API_NAME
5104: ,P_PKG_NAME => G_PKG_NAME
5105: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
5106: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
5107: ,X_MSG_COUNT => X_MSG_COUNT
5108: ,X_MSG_DATA => X_MSG_DATA
5109: ,X_RETURN_STATUS => X_RETURN_STATUS);
5110: End Copy_Opportunity;