123:
124: -- Debug Message
125: IF (AS_DEBUG_LOW_ON) THEN
126:
127: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
128: 'Pub: ' || l_api_name || ' Start');
129: END IF;
130:
131: IF (AS_DEBUG_LOW_ON) THEN
131: IF (AS_DEBUG_LOW_ON) THEN
132:
133:
134:
135: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
136: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
137:
138: END IF;
139:
146:
147: -- Calling Private package: Create_SALES_LEADS
148: IF (AS_DEBUG_LOW_ON) THEN
149:
150: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
151: 'PUB: Call PVT.Create_sales_lead');
152: END IF;
153:
154: AS_SALES_LEADS_PVT.Create_sales_lead(
190:
191: -- Debug Message
192: IF (AS_DEBUG_LOW_ON) THEN
193:
194: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
195: 'Pub: ' || l_api_name || ' End');
196: END IF;
197:
198: IF (AS_DEBUG_LOW_ON) THEN
198: IF (AS_DEBUG_LOW_ON) THEN
199:
200:
201:
202: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
203: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
204:
205: END IF;
206:
211: );
212:
213: EXCEPTION
214: WHEN FND_API.G_EXC_ERROR THEN
215: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
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
215: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
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:
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_API_NAME => L_API_NAME
227: ,P_PKG_NAME => G_PKG_NAME
228: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
229: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
225: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
226: P_API_NAME => L_API_NAME
227: ,P_PKG_NAME => G_PKG_NAME
228: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
229: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
230: ,X_MSG_COUNT => X_MSG_COUNT
231: ,X_MSG_DATA => X_MSG_DATA
232: ,X_RETURN_STATUS => X_RETURN_STATUS);
233:
231: ,X_MSG_DATA => X_MSG_DATA
232: ,X_RETURN_STATUS => X_RETURN_STATUS);
233:
234: WHEN OTHERS THEN
235: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
236: P_API_NAME => L_API_NAME
237: ,P_PKG_NAME => G_PKG_NAME
238: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
239: ,P_SQLCODE => SQLCODE
234: WHEN OTHERS THEN
235: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
236: P_API_NAME => L_API_NAME
237: ,P_PKG_NAME => G_PKG_NAME
238: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
239: ,P_SQLCODE => SQLCODE
240: ,P_SQLERRM => SQLERRM
241: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
242: ,X_MSG_COUNT => X_MSG_COUNT
237: ,P_PKG_NAME => G_PKG_NAME
238: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
239: ,P_SQLCODE => SQLCODE
240: ,P_SQLERRM => SQLERRM
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:
287:
288: -- Debug Message
289: IF (AS_DEBUG_LOW_ON) THEN
290:
291: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
292: 'Pub: ' || l_api_name || ' Start');
293: END IF;
294:
295: IF (AS_DEBUG_LOW_ON) THEN
295: IF (AS_DEBUG_LOW_ON) THEN
296:
297:
298:
299: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
300: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
301:
302: END IF;
303:
311: IF (AS_DEBUG_LOW_ON) THEN
312:
313:
314:
315: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
316: 'PUB: Calling PVT.Update_sales_lead');
317:
318: END IF;
319: AS_SALES_LEADS_PVT.Update_sales_lead(
348:
349: -- Debug Message
350: IF (AS_DEBUG_LOW_ON) THEN
351:
352: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
353: 'Pub: ' || l_api_name || ' End');
354: END IF;
355:
356: IF (AS_DEBUG_LOW_ON) THEN
356: IF (AS_DEBUG_LOW_ON) THEN
357:
358:
359:
360: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
361: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
362:
363: END IF;
364:
368: );
369:
370: EXCEPTION
371: WHEN FND_API.G_EXC_ERROR THEN
372: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
373: P_API_NAME => L_API_NAME
374: ,P_PKG_NAME => G_PKG_NAME
375: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
376: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
372: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
373: P_API_NAME => L_API_NAME
374: ,P_PKG_NAME => G_PKG_NAME
375: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
376: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
377: ,X_MSG_COUNT => X_MSG_COUNT
378: ,X_MSG_DATA => X_MSG_DATA
379: ,X_RETURN_STATUS => X_RETURN_STATUS);
380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
377: ,X_MSG_COUNT => X_MSG_COUNT
378: ,X_MSG_DATA => X_MSG_DATA
379: ,X_RETURN_STATUS => X_RETURN_STATUS);
380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
381: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
382: P_API_NAME => L_API_NAME
383: ,P_PKG_NAME => G_PKG_NAME
384: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
385: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
381: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
382: P_API_NAME => L_API_NAME
383: ,P_PKG_NAME => G_PKG_NAME
384: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
385: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
386: ,X_MSG_COUNT => X_MSG_COUNT
387: ,X_MSG_DATA => X_MSG_DATA
388: ,X_RETURN_STATUS => X_RETURN_STATUS);
389:
387: ,X_MSG_DATA => X_MSG_DATA
388: ,X_RETURN_STATUS => X_RETURN_STATUS);
389:
390: WHEN OTHERS THEN
391: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
392: P_API_NAME => L_API_NAME
393: ,P_PKG_NAME => G_PKG_NAME
394: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
395: ,P_SQLCODE => SQLCODE
390: WHEN OTHERS THEN
391: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
392: P_API_NAME => L_API_NAME
393: ,P_PKG_NAME => G_PKG_NAME
394: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
395: ,P_SQLCODE => SQLCODE
396: ,P_SQLERRM => SQLERRM
397: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
398: ,X_MSG_COUNT => X_MSG_COUNT
393: ,P_PKG_NAME => G_PKG_NAME
394: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
395: ,P_SQLCODE => SQLCODE
396: ,P_SQLERRM => SQLERRM
397: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
398: ,X_MSG_COUNT => X_MSG_COUNT
399: ,X_MSG_DATA => X_MSG_DATA
400: ,X_RETURN_STATUS => X_RETURN_STATUS);
401: End Update_sales_lead;
449:
450: -- Debug Message
451: IF (AS_DEBUG_LOW_ON) THEN
452:
453: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
454: 'Pub: ' || l_api_name || ' Start');
455: END IF;
456:
457: IF (AS_DEBUG_LOW_ON) THEN
457: IF (AS_DEBUG_LOW_ON) THEN
458:
459:
460:
461: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
462: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
463:
464: END IF;
465:
472:
473: -- Calling Private package: Create_SALES_LEAD_LINE
474: IF (AS_DEBUG_LOW_ON) THEN
475:
476: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
477: 'PUB: Calling PVT.Create_lines');
478: END IF;
479: AS_SALES_LEAD_LINES_PVT.Create_sales_lead_lines(
480: P_Api_Version_Number => 2.0,
510:
511: -- Debug Message
512: IF (AS_DEBUG_LOW_ON) THEN
513:
514: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
515: 'Pub: ' || l_api_name || ' End');
516: END IF;
517:
518: IF (AS_DEBUG_LOW_ON) THEN
518: IF (AS_DEBUG_LOW_ON) THEN
519:
520:
521:
522: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
523: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
524:
525: END IF;
526:
530: );
531:
532: EXCEPTION
533: WHEN FND_API.G_EXC_ERROR THEN
534: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
535: P_API_NAME => L_API_NAME
536: ,P_PKG_NAME => G_PKG_NAME
537: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
538: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
534: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
535: P_API_NAME => L_API_NAME
536: ,P_PKG_NAME => G_PKG_NAME
537: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
538: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
539: ,X_MSG_COUNT => X_MSG_COUNT
540: ,X_MSG_DATA => X_MSG_DATA
541: ,X_RETURN_STATUS => X_RETURN_STATUS);
542:
540: ,X_MSG_DATA => X_MSG_DATA
541: ,X_RETURN_STATUS => X_RETURN_STATUS);
542:
543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
544: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
545: P_API_NAME => L_API_NAME
546: ,P_PKG_NAME => G_PKG_NAME
547: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
548: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
544: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
545: P_API_NAME => L_API_NAME
546: ,P_PKG_NAME => G_PKG_NAME
547: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
548: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
549: ,X_MSG_COUNT => X_MSG_COUNT
550: ,X_MSG_DATA => X_MSG_DATA
551: ,X_RETURN_STATUS => X_RETURN_STATUS);
552:
550: ,X_MSG_DATA => X_MSG_DATA
551: ,X_RETURN_STATUS => X_RETURN_STATUS);
552:
553: WHEN OTHERS THEN
554: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
555: P_API_NAME => L_API_NAME
556: ,P_PKG_NAME => G_PKG_NAME
557: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
558: ,P_SQLCODE => SQLCODE
553: WHEN OTHERS THEN
554: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
555: P_API_NAME => L_API_NAME
556: ,P_PKG_NAME => G_PKG_NAME
557: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
558: ,P_SQLCODE => SQLCODE
559: ,P_SQLERRM => SQLERRM
560: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
561: ,X_MSG_COUNT => X_MSG_COUNT
556: ,P_PKG_NAME => G_PKG_NAME
557: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
558: ,P_SQLCODE => SQLCODE
559: ,P_SQLERRM => SQLERRM
560: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
561: ,X_MSG_COUNT => X_MSG_COUNT
562: ,X_MSG_DATA => X_MSG_DATA
563: ,X_RETURN_STATUS => X_RETURN_STATUS);
564:
606:
607: -- Debug Message
608: IF (AS_DEBUG_LOW_ON) THEN
609:
610: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
611: 'Pub: ' || l_api_name || ' Start');
612: END IF;
613:
614: IF (AS_DEBUG_LOW_ON) THEN
614: IF (AS_DEBUG_LOW_ON) THEN
615:
616:
617:
618: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
619: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
620:
621: END IF;
622:
630: IF (AS_DEBUG_LOW_ON) THEN
631:
632:
633:
634: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
635: 'PUB: Calling PVT.Update_lines');
636:
637: END IF;
638:
670:
671: -- Debug Message
672: IF (AS_DEBUG_LOW_ON) THEN
673:
674: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
675: 'Pub: ' || l_api_name || ' End');
676: END IF;
677:
678: IF (AS_DEBUG_LOW_ON) THEN
678: IF (AS_DEBUG_LOW_ON) THEN
679:
680:
681:
682: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
683: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
684:
685: END IF;
686:
690: );
691:
692: EXCEPTION
693: WHEN FND_API.G_EXC_ERROR THEN
694: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
695: P_API_NAME => L_API_NAME
696: ,P_PKG_NAME => G_PKG_NAME
697: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
698: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
694: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
695: P_API_NAME => L_API_NAME
696: ,P_PKG_NAME => G_PKG_NAME
697: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
698: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
699: ,X_MSG_COUNT => X_MSG_COUNT
700: ,X_MSG_DATA => X_MSG_DATA
701: ,X_RETURN_STATUS => X_RETURN_STATUS);
702:
700: ,X_MSG_DATA => X_MSG_DATA
701: ,X_RETURN_STATUS => X_RETURN_STATUS);
702:
703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
704: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
705: P_API_NAME => L_API_NAME
706: ,P_PKG_NAME => G_PKG_NAME
707: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
708: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
704: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
705: P_API_NAME => L_API_NAME
706: ,P_PKG_NAME => G_PKG_NAME
707: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
708: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
709: ,X_MSG_COUNT => X_MSG_COUNT
710: ,X_MSG_DATA => X_MSG_DATA
711: ,X_RETURN_STATUS => X_RETURN_STATUS);
712:
710: ,X_MSG_DATA => X_MSG_DATA
711: ,X_RETURN_STATUS => X_RETURN_STATUS);
712:
713: WHEN OTHERS THEN
714: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
715: P_API_NAME => L_API_NAME
716: ,P_PKG_NAME => G_PKG_NAME
717: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
718: ,P_SQLCODE => SQLCODE
713: WHEN OTHERS THEN
714: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
715: P_API_NAME => L_API_NAME
716: ,P_PKG_NAME => G_PKG_NAME
717: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
718: ,P_SQLCODE => SQLCODE
719: ,P_SQLERRM => SQLERRM
720: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
721: ,X_MSG_COUNT => X_MSG_COUNT
716: ,P_PKG_NAME => G_PKG_NAME
717: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
718: ,P_SQLCODE => SQLCODE
719: ,P_SQLERRM => SQLERRM
720: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
721: ,X_MSG_COUNT => X_MSG_COUNT
722: ,X_MSG_DATA => X_MSG_DATA
723: ,X_RETURN_STATUS => X_RETURN_STATUS);
724:
766:
767: -- Debug Message
768: IF (AS_DEBUG_LOW_ON) THEN
769:
770: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
771: 'Pub: ' || l_api_name || ' Start');
772: END IF;
773:
774: IF (AS_DEBUG_LOW_ON) THEN
774: IF (AS_DEBUG_LOW_ON) THEN
775:
776:
777:
778: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
779: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
780:
781: END IF;
782:
790: IF (AS_DEBUG_LOW_ON) THEN
791:
792:
793:
794: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
795: 'PUB: Calling PVT.Delete_lines');
796:
797: END IF;
798: AS_SALES_LEAD_LINES_PVT.Delete_sales_lead_lines(
828:
829: -- Debug Message
830: IF (AS_DEBUG_LOW_ON) THEN
831:
832: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
833: 'Pub: ' || l_api_name || ' End');
834: END IF;
835:
836: IF (AS_DEBUG_LOW_ON) THEN
836: IF (AS_DEBUG_LOW_ON) THEN
837:
838:
839:
840: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
841: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
842:
843: END IF;
844:
849: );
850:
851: EXCEPTION
852: WHEN FND_API.G_EXC_ERROR THEN
853: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
854: P_API_NAME => L_API_NAME
855: ,P_PKG_NAME => G_PKG_NAME
856: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
857: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
853: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
854: P_API_NAME => L_API_NAME
855: ,P_PKG_NAME => G_PKG_NAME
856: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
857: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
858: ,X_MSG_COUNT => X_MSG_COUNT
859: ,X_MSG_DATA => X_MSG_DATA
860: ,X_RETURN_STATUS => X_RETURN_STATUS);
861:
859: ,X_MSG_DATA => X_MSG_DATA
860: ,X_RETURN_STATUS => X_RETURN_STATUS);
861:
862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
863: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
864: P_API_NAME => L_API_NAME
865: ,P_PKG_NAME => G_PKG_NAME
866: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
867: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
863: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
864: P_API_NAME => L_API_NAME
865: ,P_PKG_NAME => G_PKG_NAME
866: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
867: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
868: ,X_MSG_COUNT => X_MSG_COUNT
869: ,X_MSG_DATA => X_MSG_DATA
870: ,X_RETURN_STATUS => X_RETURN_STATUS);
871:
869: ,X_MSG_DATA => X_MSG_DATA
870: ,X_RETURN_STATUS => X_RETURN_STATUS);
871:
872: WHEN OTHERS THEN
873: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
874: P_API_NAME => L_API_NAME
875: ,P_PKG_NAME => G_PKG_NAME
876: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
877: ,P_SQLCODE => SQLCODE
872: WHEN OTHERS THEN
873: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
874: P_API_NAME => L_API_NAME
875: ,P_PKG_NAME => G_PKG_NAME
876: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
877: ,P_SQLCODE => SQLCODE
878: ,P_SQLERRM => SQLERRM
879: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
880: ,X_MSG_COUNT => X_MSG_COUNT
875: ,P_PKG_NAME => G_PKG_NAME
876: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
877: ,P_SQLCODE => SQLCODE
878: ,P_SQLERRM => SQLERRM
879: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
880: ,X_MSG_COUNT => X_MSG_COUNT
881: ,X_MSG_DATA => X_MSG_DATA
882: ,X_RETURN_STATUS => X_RETURN_STATUS);
883:
930:
931: -- Debug Message
932: IF (AS_DEBUG_LOW_ON) THEN
933:
934: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
935: 'Pub: ' || l_api_name || ' Start');
936: END IF;
937:
938: IF (AS_DEBUG_LOW_ON) THEN
938: IF (AS_DEBUG_LOW_ON) THEN
939:
940:
941:
942: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
943: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
944:
945: END IF;
946:
953:
954: -- Calling Private package: Create_SALES_LEAD_LINE
955: IF (AS_DEBUG_LOW_ON) THEN
956:
957: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
958: 'PUB: Calling PVT.Create_contacts');
959: END IF;
960: AS_SALES_LEAD_CONTACTS_PVT.Create_sales_lead_contacts(
961: P_Api_Version_Number => 2.0,
991:
992: -- Debug Message
993: IF (AS_DEBUG_LOW_ON) THEN
994:
995: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
996: 'Pub: ' || l_api_name || ' End');
997: END IF;
998:
999: IF (AS_DEBUG_LOW_ON) THEN
999: IF (AS_DEBUG_LOW_ON) THEN
1000:
1001:
1002:
1003: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1004: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1005:
1006: END IF;
1007:
1011: );
1012:
1013: EXCEPTION
1014: WHEN FND_API.G_EXC_ERROR THEN
1015: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1016: P_API_NAME => L_API_NAME
1017: ,P_PKG_NAME => G_PKG_NAME
1018: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1019: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1015: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1016: P_API_NAME => L_API_NAME
1017: ,P_PKG_NAME => G_PKG_NAME
1018: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
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:
1021: ,X_MSG_DATA => X_MSG_DATA
1022: ,X_RETURN_STATUS => X_RETURN_STATUS);
1023:
1024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1025: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1026: P_API_NAME => L_API_NAME
1027: ,P_PKG_NAME => G_PKG_NAME
1028: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1029: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1025: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1026: P_API_NAME => L_API_NAME
1027: ,P_PKG_NAME => G_PKG_NAME
1028: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1029: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1030: ,X_MSG_COUNT => X_MSG_COUNT
1031: ,X_MSG_DATA => X_MSG_DATA
1032: ,X_RETURN_STATUS => X_RETURN_STATUS);
1033:
1031: ,X_MSG_DATA => X_MSG_DATA
1032: ,X_RETURN_STATUS => X_RETURN_STATUS);
1033:
1034: WHEN OTHERS THEN
1035: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1036: P_API_NAME => L_API_NAME
1037: ,P_PKG_NAME => G_PKG_NAME
1038: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1039: ,P_SQLCODE => SQLCODE
1034: WHEN OTHERS THEN
1035: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1036: P_API_NAME => L_API_NAME
1037: ,P_PKG_NAME => G_PKG_NAME
1038: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1039: ,P_SQLCODE => SQLCODE
1040: ,P_SQLERRM => SQLERRM
1041: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1042: ,X_MSG_COUNT => X_MSG_COUNT
1037: ,P_PKG_NAME => G_PKG_NAME
1038: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1039: ,P_SQLCODE => SQLCODE
1040: ,P_SQLERRM => SQLERRM
1041: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1042: ,X_MSG_COUNT => X_MSG_COUNT
1043: ,X_MSG_DATA => X_MSG_DATA
1044: ,X_RETURN_STATUS => X_RETURN_STATUS);
1045: End Create_sales_lead_contacts;
1087:
1088: -- Debug Message
1089: IF (AS_DEBUG_LOW_ON) THEN
1090:
1091: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1092: 'Pub: ' || l_api_name || ' Start');
1093: END IF;
1094:
1095: IF (AS_DEBUG_LOW_ON) THEN
1095: IF (AS_DEBUG_LOW_ON) THEN
1096:
1097:
1098:
1099: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1100: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1101:
1102: END IF;
1103:
1111: IF (AS_DEBUG_LOW_ON) THEN
1112:
1113:
1114:
1115: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1116: 'PUB: Calling PVT.Update_contacts');
1117:
1118: END IF;
1119: AS_SALES_LEAD_CONTACTS_PVT.Update_sales_lead_contacts(
1149:
1150: -- Debug Message
1151: IF (AS_DEBUG_LOW_ON) THEN
1152:
1153: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1154: 'Pub: ' || l_api_name || ' End');
1155: END IF;
1156:
1157: IF (AS_DEBUG_LOW_ON) THEN
1157: IF (AS_DEBUG_LOW_ON) THEN
1158:
1159:
1160:
1161: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1162: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1163:
1164: END IF;
1165:
1169: );
1170:
1171: EXCEPTION
1172: WHEN FND_API.G_EXC_ERROR THEN
1173: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1174: P_API_NAME => L_API_NAME
1175: ,P_PKG_NAME => G_PKG_NAME
1176: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1177: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1173: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1174: P_API_NAME => L_API_NAME
1175: ,P_PKG_NAME => G_PKG_NAME
1176: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1177: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1178: ,X_MSG_COUNT => X_MSG_COUNT
1179: ,X_MSG_DATA => X_MSG_DATA
1180: ,X_RETURN_STATUS => X_RETURN_STATUS);
1181:
1179: ,X_MSG_DATA => X_MSG_DATA
1180: ,X_RETURN_STATUS => X_RETURN_STATUS);
1181:
1182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1183: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1184: P_API_NAME => L_API_NAME
1185: ,P_PKG_NAME => G_PKG_NAME
1186: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1187: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1183: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1184: P_API_NAME => L_API_NAME
1185: ,P_PKG_NAME => G_PKG_NAME
1186: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1187: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1188: ,X_MSG_COUNT => X_MSG_COUNT
1189: ,X_MSG_DATA => X_MSG_DATA
1190: ,X_RETURN_STATUS => X_RETURN_STATUS);
1191:
1189: ,X_MSG_DATA => X_MSG_DATA
1190: ,X_RETURN_STATUS => X_RETURN_STATUS);
1191:
1192: WHEN OTHERS THEN
1193: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1194: P_API_NAME => L_API_NAME
1195: ,P_PKG_NAME => G_PKG_NAME
1196: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1197: ,P_SQLCODE => SQLCODE
1192: WHEN OTHERS THEN
1193: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1194: P_API_NAME => L_API_NAME
1195: ,P_PKG_NAME => G_PKG_NAME
1196: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1197: ,P_SQLCODE => SQLCODE
1198: ,P_SQLERRM => SQLERRM
1199: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1200: ,X_MSG_COUNT => X_MSG_COUNT
1195: ,P_PKG_NAME => G_PKG_NAME
1196: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1197: ,P_SQLCODE => SQLCODE
1198: ,P_SQLERRM => SQLERRM
1199: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1200: ,X_MSG_COUNT => X_MSG_COUNT
1201: ,X_MSG_DATA => X_MSG_DATA
1202: ,X_RETURN_STATUS => X_RETURN_STATUS);
1203:
1247:
1248: -- Debug Message
1249: IF (AS_DEBUG_LOW_ON) THEN
1250:
1251: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1252: 'Pub: ' || l_api_name || ' Start');
1253: END IF;
1254:
1255: IF (AS_DEBUG_LOW_ON) THEN
1255: IF (AS_DEBUG_LOW_ON) THEN
1256:
1257:
1258:
1259: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1260: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1261:
1262: END IF;
1263:
1271: IF (AS_DEBUG_LOW_ON) THEN
1272:
1273:
1274:
1275: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1276: 'PUB: Calling PVT.Delete_contacts');
1277:
1278: END IF;
1279: AS_SALES_LEAD_CONTACTS_PVT.Delete_sales_lead_contacts(
1309:
1310: -- Debug Message
1311: IF (AS_DEBUG_LOW_ON) THEN
1312:
1313: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1314: 'Pub: ' || l_api_name || ' End');
1315: END IF;
1316:
1317: IF (AS_DEBUG_LOW_ON) THEN
1317: IF (AS_DEBUG_LOW_ON) THEN
1318:
1319:
1320:
1321: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1322: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1323:
1324: END IF;
1325:
1330: );
1331:
1332: EXCEPTION
1333: WHEN FND_API.G_EXC_ERROR THEN
1334: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1335: P_API_NAME => L_API_NAME
1336: ,P_PKG_NAME => G_PKG_NAME
1337: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1338: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1334: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1335: P_API_NAME => L_API_NAME
1336: ,P_PKG_NAME => G_PKG_NAME
1337: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1338: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1339: ,X_MSG_COUNT => X_MSG_COUNT
1340: ,X_MSG_DATA => X_MSG_DATA
1341: ,X_RETURN_STATUS => X_RETURN_STATUS);
1342:
1340: ,X_MSG_DATA => X_MSG_DATA
1341: ,X_RETURN_STATUS => X_RETURN_STATUS);
1342:
1343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1344: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1345: P_API_NAME => L_API_NAME
1346: ,P_PKG_NAME => G_PKG_NAME
1347: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1348: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1344: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1345: P_API_NAME => L_API_NAME
1346: ,P_PKG_NAME => G_PKG_NAME
1347: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1348: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1349: ,X_MSG_COUNT => X_MSG_COUNT
1350: ,X_MSG_DATA => X_MSG_DATA
1351: ,X_RETURN_STATUS => X_RETURN_STATUS);
1352:
1350: ,X_MSG_DATA => X_MSG_DATA
1351: ,X_RETURN_STATUS => X_RETURN_STATUS);
1352:
1353: WHEN OTHERS THEN
1354: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1355: P_API_NAME => L_API_NAME
1356: ,P_PKG_NAME => G_PKG_NAME
1357: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1358: ,P_SQLCODE => SQLCODE
1353: WHEN OTHERS THEN
1354: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1355: P_API_NAME => L_API_NAME
1356: ,P_PKG_NAME => G_PKG_NAME
1357: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1358: ,P_SQLCODE => SQLCODE
1359: ,P_SQLERRM => SQLERRM
1360: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1361: ,X_MSG_COUNT => X_MSG_COUNT
1356: ,P_PKG_NAME => G_PKG_NAME
1357: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1358: ,P_SQLCODE => SQLCODE
1359: ,P_SQLERRM => SQLERRM
1360: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1361: ,X_MSG_COUNT => X_MSG_COUNT
1362: ,X_MSG_DATA => X_MSG_DATA
1363: ,X_RETURN_STATUS => X_RETURN_STATUS);
1364:
1411:
1412: -- Debug Message
1413: IF (AS_DEBUG_LOW_ON) THEN
1414:
1415: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1416: 'Pub: ' || l_api_name || ' Start');
1417: END IF;
1418:
1419: IF (AS_DEBUG_LOW_ON) THEN
1419: IF (AS_DEBUG_LOW_ON) THEN
1420:
1421:
1422:
1423: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1424: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1425:
1426: END IF;
1427:
1434:
1435: -- Calling private API
1436: IF (AS_DEBUG_LOW_ON) THEN
1437:
1438: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1439: 'PUB: Call PVT.Get_Potential_Opportunity');
1440: END IF;
1441: AS_SALES_LEAD_OPP_PVT.Get_Potential_Opportunity(
1442: P_Api_Version_Number => 2.0,
1473:
1474: -- Debug Message
1475: IF (AS_DEBUG_LOW_ON) THEN
1476:
1477: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1478: 'Pub: ' || l_api_name || ' End');
1479: END IF;
1480:
1481: IF (AS_DEBUG_LOW_ON) THEN
1481: IF (AS_DEBUG_LOW_ON) THEN
1482:
1483:
1484:
1485: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1486: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1487:
1488: END IF;
1489:
1494: );
1495:
1496: EXCEPTION
1497: WHEN FND_API.G_EXC_ERROR THEN
1498: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1499: P_API_NAME => L_API_NAME
1500: ,P_PKG_NAME => G_PKG_NAME
1501: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1502: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1498: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1499: P_API_NAME => L_API_NAME
1500: ,P_PKG_NAME => G_PKG_NAME
1501: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1502: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1503: ,X_MSG_COUNT => X_MSG_COUNT
1504: ,X_MSG_DATA => X_MSG_DATA
1505: ,X_RETURN_STATUS => X_RETURN_STATUS);
1506:
1504: ,X_MSG_DATA => X_MSG_DATA
1505: ,X_RETURN_STATUS => X_RETURN_STATUS);
1506:
1507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1508: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1509: P_API_NAME => L_API_NAME
1510: ,P_PKG_NAME => G_PKG_NAME
1511: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1512: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1508: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1509: P_API_NAME => L_API_NAME
1510: ,P_PKG_NAME => G_PKG_NAME
1511: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1512: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1513: ,X_MSG_COUNT => X_MSG_COUNT
1514: ,X_MSG_DATA => X_MSG_DATA
1515: ,X_RETURN_STATUS => X_RETURN_STATUS);
1516:
1514: ,X_MSG_DATA => X_MSG_DATA
1515: ,X_RETURN_STATUS => X_RETURN_STATUS);
1516:
1517: WHEN OTHERS THEN
1518: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1519: P_API_NAME => L_API_NAME
1520: ,P_PKG_NAME => G_PKG_NAME
1521: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1522: ,P_SQLCODE => SQLCODE
1517: WHEN OTHERS THEN
1518: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1519: P_API_NAME => L_API_NAME
1520: ,P_PKG_NAME => G_PKG_NAME
1521: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1522: ,P_SQLCODE => SQLCODE
1523: ,P_SQLERRM => SQLERRM
1524: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1525: ,X_MSG_COUNT => X_MSG_COUNT
1520: ,P_PKG_NAME => G_PKG_NAME
1521: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1522: ,P_SQLCODE => SQLCODE
1523: ,P_SQLERRM => SQLERRM
1524: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1525: ,X_MSG_COUNT => X_MSG_COUNT
1526: ,X_MSG_DATA => X_MSG_DATA
1527: ,X_RETURN_STATUS => X_RETURN_STATUS);
1528:
1579:
1580: -- Debug Message
1581: IF (AS_DEBUG_LOW_ON) THEN
1582:
1583: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1584: 'Pub: ' || l_api_name || ' Start');
1585: END IF;
1586:
1587: IF (AS_DEBUG_LOW_ON) THEN
1587: IF (AS_DEBUG_LOW_ON) THEN
1588:
1589:
1590:
1591: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1592: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1593:
1594: END IF;
1595:
1601: --
1602: -- Calling private API
1603: IF (AS_DEBUG_LOW_ON) THEN
1604:
1605: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1606: 'PUB: Call PVT.Copy_Lead_To_Opportunity');
1607: END IF;
1608: AS_SALES_LEAD_OPP_PVT.Copy_Lead_To_Opportunity(
1609: P_Api_Version_Number => 2.0,
1640:
1641: -- Debug Message
1642: IF (AS_DEBUG_LOW_ON) THEN
1643:
1644: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1645: 'Pub: ' || l_api_name || ' End');
1646: END IF;
1647:
1648: IF (AS_DEBUG_LOW_ON) THEN
1648: IF (AS_DEBUG_LOW_ON) THEN
1649:
1650:
1651:
1652: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1653: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1654:
1655: END IF;
1656:
1661: );
1662:
1663: EXCEPTION
1664: WHEN FND_API.G_EXC_ERROR THEN
1665: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
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
1665: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
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:
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_API_NAME => L_API_NAME
1677: ,P_PKG_NAME => G_PKG_NAME
1678: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1679: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1675: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1676: P_API_NAME => L_API_NAME
1677: ,P_PKG_NAME => G_PKG_NAME
1678: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1679: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1680: ,X_MSG_COUNT => X_MSG_COUNT
1681: ,X_MSG_DATA => X_MSG_DATA
1682: ,X_RETURN_STATUS => X_RETURN_STATUS);
1683:
1681: ,X_MSG_DATA => X_MSG_DATA
1682: ,X_RETURN_STATUS => X_RETURN_STATUS);
1683:
1684: WHEN OTHERS THEN
1685: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1686: P_API_NAME => L_API_NAME
1687: ,P_PKG_NAME => G_PKG_NAME
1688: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1689: ,P_SQLCODE => SQLCODE
1684: WHEN OTHERS THEN
1685: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1686: P_API_NAME => L_API_NAME
1687: ,P_PKG_NAME => G_PKG_NAME
1688: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1689: ,P_SQLCODE => SQLCODE
1690: ,P_SQLERRM => SQLERRM
1691: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1692: ,X_MSG_COUNT => X_MSG_COUNT
1687: ,P_PKG_NAME => G_PKG_NAME
1688: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1689: ,P_SQLCODE => SQLCODE
1690: ,P_SQLERRM => SQLERRM
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 Copy_Lead_To_Opportunity;
1845:
1846: -- Debug Message
1847: IF (AS_DEBUG_LOW_ON) THEN
1848:
1849: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1850: 'Pub: ' || l_api_name || ' Start');
1851: END IF;
1852:
1853: IF (AS_DEBUG_LOW_ON) THEN
1853: IF (AS_DEBUG_LOW_ON) THEN
1854:
1855:
1856:
1857: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1858: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1859:
1860: END IF;
1861:
1867: --
1868: -- Calling private API
1869: IF (AS_DEBUG_LOW_ON) THEN
1870:
1871: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1872: 'PUB: Call PVT.Link_Lead_To_Opportunity');
1873: END IF;
1874: AS_SALES_LEAD_OPP_PVT.Link_Lead_To_Opportunity(
1875: P_Api_Version_Number => 2.0,
2031:
2032: -- Debug Message
2033: IF (AS_DEBUG_LOW_ON) THEN
2034:
2035: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2036: 'Pub: ' || l_api_name || ' End');
2037: END IF;
2038:
2039: IF (AS_DEBUG_LOW_ON) THEN
2039: IF (AS_DEBUG_LOW_ON) THEN
2040:
2041:
2042:
2043: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
2044: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2045:
2046: END IF;
2047:
2052: );
2053:
2054: EXCEPTION
2055: WHEN FND_API.G_EXC_ERROR THEN
2056: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2057: P_API_NAME => L_API_NAME
2058: ,P_PKG_NAME => G_PKG_NAME
2059: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2060: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2056: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2057: P_API_NAME => L_API_NAME
2058: ,P_PKG_NAME => G_PKG_NAME
2059: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2060: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2061: ,X_MSG_COUNT => X_MSG_COUNT
2062: ,X_MSG_DATA => X_MSG_DATA
2063: ,X_RETURN_STATUS => X_RETURN_STATUS);
2064:
2062: ,X_MSG_DATA => X_MSG_DATA
2063: ,X_RETURN_STATUS => X_RETURN_STATUS);
2064:
2065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2066: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2067: P_API_NAME => L_API_NAME
2068: ,P_PKG_NAME => G_PKG_NAME
2069: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2070: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2066: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2067: P_API_NAME => L_API_NAME
2068: ,P_PKG_NAME => G_PKG_NAME
2069: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2070: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2071: ,X_MSG_COUNT => X_MSG_COUNT
2072: ,X_MSG_DATA => X_MSG_DATA
2073: ,X_RETURN_STATUS => X_RETURN_STATUS);
2074:
2072: ,X_MSG_DATA => X_MSG_DATA
2073: ,X_RETURN_STATUS => X_RETURN_STATUS);
2074:
2075: WHEN OTHERS THEN
2076: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2077: P_API_NAME => L_API_NAME
2078: ,P_PKG_NAME => G_PKG_NAME
2079: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2080: ,P_SQLCODE => SQLCODE
2075: WHEN OTHERS THEN
2076: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2077: P_API_NAME => L_API_NAME
2078: ,P_PKG_NAME => G_PKG_NAME
2079: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2080: ,P_SQLCODE => SQLCODE
2081: ,P_SQLERRM => SQLERRM
2082: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2083: ,X_MSG_COUNT => X_MSG_COUNT
2078: ,P_PKG_NAME => G_PKG_NAME
2079: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2080: ,P_SQLCODE => SQLCODE
2081: ,P_SQLERRM => SQLERRM
2082: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2083: ,X_MSG_COUNT => X_MSG_COUNT
2084: ,X_MSG_DATA => X_MSG_DATA
2085: ,X_RETURN_STATUS => X_RETURN_STATUS);
2086: End Link_Lead_To_Opportunity;
2144:
2145: -- Debug Message
2146: IF (AS_DEBUG_LOW_ON) THEN
2147:
2148: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2149: 'Pub: ' || l_api_name || ' Start');
2150: END IF;
2151:
2152: IF (AS_DEBUG_LOW_ON) THEN
2152: IF (AS_DEBUG_LOW_ON) THEN
2153:
2154:
2155:
2156: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2157: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2158:
2159: END IF;
2160:
2166: --
2167: -- Calling private API
2168: IF (AS_DEBUG_LOW_ON) THEN
2169:
2170: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2171: 'PUB: Calling PVT.PV_Enty_Attr_Values_PVT.Create_Attr_Value');
2172: END IF;
2173:
2174:
2217:
2218: -- Debug Message
2219: IF (AS_DEBUG_LOW_ON) THEN
2220:
2221: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2222: 'Pub: ' || l_api_name || ' End');
2223: END IF;
2224:
2225: IF (AS_DEBUG_LOW_ON) THEN
2225: IF (AS_DEBUG_LOW_ON) THEN
2226:
2227:
2228:
2229: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
2230: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2231:
2232: END IF;
2233:
2237: p_data => x_msg_data
2238: );
2239: EXCEPTION
2240: WHEN FND_API.G_EXC_ERROR THEN
2241: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2242: P_API_NAME => L_API_NAME
2243: ,P_PKG_NAME => G_PKG_NAME
2244: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2245: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2241: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2242: P_API_NAME => L_API_NAME
2243: ,P_PKG_NAME => G_PKG_NAME
2244: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2245: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2246: ,X_MSG_COUNT => X_MSG_COUNT
2247: ,X_MSG_DATA => X_MSG_DATA
2248: ,X_RETURN_STATUS => X_RETURN_STATUS);
2249:
2247: ,X_MSG_DATA => X_MSG_DATA
2248: ,X_RETURN_STATUS => X_RETURN_STATUS);
2249:
2250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2251: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2252: P_API_NAME => L_API_NAME
2253: ,P_PKG_NAME => G_PKG_NAME
2254: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2255: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2251: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2252: P_API_NAME => L_API_NAME
2253: ,P_PKG_NAME => G_PKG_NAME
2254: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2255: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2256: ,X_MSG_COUNT => X_MSG_COUNT
2257: ,X_MSG_DATA => X_MSG_DATA
2258: ,X_RETURN_STATUS => X_RETURN_STATUS);
2259:
2257: ,X_MSG_DATA => X_MSG_DATA
2258: ,X_RETURN_STATUS => X_RETURN_STATUS);
2259:
2260: WHEN OTHERS THEN
2261: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2262: P_API_NAME => L_API_NAME
2263: ,P_PKG_NAME => G_PKG_NAME
2264: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2265: ,P_SQLCODE => SQLCODE
2260: WHEN OTHERS THEN
2261: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2262: P_API_NAME => L_API_NAME
2263: ,P_PKG_NAME => G_PKG_NAME
2264: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2265: ,P_SQLCODE => SQLCODE
2266: ,P_SQLERRM => SQLERRM
2267: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2268: ,X_MSG_COUNT => X_MSG_COUNT
2263: ,P_PKG_NAME => G_PKG_NAME
2264: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2265: ,P_SQLCODE => SQLCODE
2266: ,P_SQLERRM => SQLERRM
2267: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2268: ,X_MSG_COUNT => X_MSG_COUNT
2269: ,X_MSG_DATA => X_MSG_DATA
2270: ,X_RETURN_STATUS => X_RETURN_STATUS);
2271: End Create_Opp_Entity_Attributes;
2337:
2338: -- Debug Message
2339: IF (AS_DEBUG_LOW_ON) THEN
2340:
2341: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2342: 'Pub: ' || l_api_name || ' Start');
2343: END IF;
2344:
2345: IF (AS_DEBUG_LOW_ON) THEN
2345: IF (AS_DEBUG_LOW_ON) THEN
2346:
2347:
2348:
2349: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2350: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2351:
2352: END IF;
2353:
2359: --
2360: -- Calling private API
2361: IF (AS_DEBUG_LOW_ON) THEN
2362:
2363: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2364: 'PUB: Calling PVT.PV_PSS_LEAD_LINES.Create_Lead_PSS_Line');
2365: END IF;
2366:
2367:
2426:
2427: -- Debug Message
2428: IF (AS_DEBUG_LOW_ON) THEN
2429:
2430: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2431: 'Pub: ' || l_api_name || ' End');
2432: END IF;
2433:
2434: IF (AS_DEBUG_LOW_ON) THEN
2434: IF (AS_DEBUG_LOW_ON) THEN
2435:
2436:
2437:
2438: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
2439: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2440:
2441: END IF;
2442:
2446: p_data => x_msg_data
2447: );
2448: EXCEPTION
2449: WHEN FND_API.G_EXC_ERROR THEN
2450: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2451: P_API_NAME => L_API_NAME
2452: ,P_PKG_NAME => G_PKG_NAME
2453: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2454: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2450: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2451: P_API_NAME => L_API_NAME
2452: ,P_PKG_NAME => G_PKG_NAME
2453: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2454: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2455: ,X_MSG_COUNT => X_MSG_COUNT
2456: ,X_MSG_DATA => X_MSG_DATA
2457: ,X_RETURN_STATUS => X_RETURN_STATUS);
2458:
2456: ,X_MSG_DATA => X_MSG_DATA
2457: ,X_RETURN_STATUS => X_RETURN_STATUS);
2458:
2459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2460: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2461: P_API_NAME => L_API_NAME
2462: ,P_PKG_NAME => G_PKG_NAME
2463: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2464: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2460: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2461: P_API_NAME => L_API_NAME
2462: ,P_PKG_NAME => G_PKG_NAME
2463: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2464: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2465: ,X_MSG_COUNT => X_MSG_COUNT
2466: ,X_MSG_DATA => X_MSG_DATA
2467: ,X_RETURN_STATUS => X_RETURN_STATUS);
2468:
2466: ,X_MSG_DATA => X_MSG_DATA
2467: ,X_RETURN_STATUS => X_RETURN_STATUS);
2468:
2469: WHEN OTHERS THEN
2470: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2471: P_API_NAME => L_API_NAME
2472: ,P_PKG_NAME => G_PKG_NAME
2473: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2474: ,P_SQLCODE => SQLCODE
2469: WHEN OTHERS THEN
2470: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2471: P_API_NAME => L_API_NAME
2472: ,P_PKG_NAME => G_PKG_NAME
2473: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2474: ,P_SQLCODE => SQLCODE
2475: ,P_SQLERRM => SQLERRM
2476: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2477: ,X_MSG_COUNT => X_MSG_COUNT
2472: ,P_PKG_NAME => G_PKG_NAME
2473: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2474: ,P_SQLCODE => SQLCODE
2475: ,P_SQLERRM => SQLERRM
2476: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2477: ,X_MSG_COUNT => X_MSG_COUNT
2478: ,X_MSG_DATA => X_MSG_DATA
2479: ,X_RETURN_STATUS => X_RETURN_STATUS);
2480: End Create_Opp_Lead_PSS_Lines;
2628:
2629: -- Debug Message
2630: IF (AS_DEBUG_LOW_ON) THEN
2631:
2632: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2633: 'Pub: ' || l_api_name || ' Start');
2634: END IF;
2635:
2636: IF (AS_DEBUG_LOW_ON) THEN
2636: IF (AS_DEBUG_LOW_ON) THEN
2637:
2638:
2639:
2640: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2641: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2642:
2643: END IF;
2644:
2650: --
2651: -- Calling private API
2652: IF (AS_DEBUG_LOW_ON) THEN
2653:
2654: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2655: 'PUB: Calling PVT.Create_Opportunity_For_Lead');
2656: END IF;
2657:
2658: AS_SALES_LEAD_OPP_PVT.Create_Opportunity_For_Lead(
2846:
2847: -- Debug Message
2848: IF (AS_DEBUG_LOW_ON) THEN
2849:
2850: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2851: 'Pub: ' || l_api_name || ' End');
2852: END IF;
2853:
2854: IF (AS_DEBUG_LOW_ON) THEN
2854: IF (AS_DEBUG_LOW_ON) THEN
2855:
2856:
2857:
2858: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
2859: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2860:
2861: END IF;
2862:
2866: p_data => x_msg_data
2867: );
2868: EXCEPTION
2869: WHEN FND_API.G_EXC_ERROR THEN
2870: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2871: P_API_NAME => L_API_NAME
2872: ,P_PKG_NAME => G_PKG_NAME
2873: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2874: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2870: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2871: P_API_NAME => L_API_NAME
2872: ,P_PKG_NAME => G_PKG_NAME
2873: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2874: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2875: ,X_MSG_COUNT => X_MSG_COUNT
2876: ,X_MSG_DATA => X_MSG_DATA
2877: ,X_RETURN_STATUS => X_RETURN_STATUS);
2878:
2876: ,X_MSG_DATA => X_MSG_DATA
2877: ,X_RETURN_STATUS => X_RETURN_STATUS);
2878:
2879: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2880: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2881: P_API_NAME => L_API_NAME
2882: ,P_PKG_NAME => G_PKG_NAME
2883: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2884: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2880: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2881: P_API_NAME => L_API_NAME
2882: ,P_PKG_NAME => G_PKG_NAME
2883: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2884: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2885: ,X_MSG_COUNT => X_MSG_COUNT
2886: ,X_MSG_DATA => X_MSG_DATA
2887: ,X_RETURN_STATUS => X_RETURN_STATUS);
2888:
2886: ,X_MSG_DATA => X_MSG_DATA
2887: ,X_RETURN_STATUS => X_RETURN_STATUS);
2888:
2889: WHEN OTHERS THEN
2890: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2891: P_API_NAME => L_API_NAME
2892: ,P_PKG_NAME => G_PKG_NAME
2893: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2894: ,P_SQLCODE => SQLCODE
2889: WHEN OTHERS THEN
2890: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2891: P_API_NAME => L_API_NAME
2892: ,P_PKG_NAME => G_PKG_NAME
2893: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2894: ,P_SQLCODE => SQLCODE
2895: ,P_SQLERRM => SQLERRM
2896: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2897: ,X_MSG_COUNT => X_MSG_COUNT
2892: ,P_PKG_NAME => G_PKG_NAME
2893: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2894: ,P_SQLCODE => SQLCODE
2895: ,P_SQLERRM => SQLERRM
2896: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2897: ,X_MSG_COUNT => X_MSG_COUNT
2898: ,X_MSG_DATA => X_MSG_DATA
2899: ,X_RETURN_STATUS => X_RETURN_STATUS);
2900: End Create_Opportunity_For_Lead;
2943:
2944: -- Debug Message
2945: IF (AS_DEBUG_LOW_ON) THEN
2946:
2947: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2948: 'Pub: ' || l_api_name || ' Start');
2949: END IF;
2950:
2951: IF (AS_DEBUG_LOW_ON) THEN
2951: IF (AS_DEBUG_LOW_ON) THEN
2952:
2953:
2954:
2955: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2956: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2957:
2958: END IF;
2959:
2965: --
2966: -- Calling private API
2967: IF (AS_DEBUG_LOW_ON) THEN
2968:
2969: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2970: 'PUB: Call PVT.Assign_Sales_Lead');
2971: END IF;
2972:
2973: AS_SALES_LEAD_ASSIGN_PVT.Assign_Sales_Lead(
3014:
3015: -- Debug Message
3016: IF (AS_DEBUG_LOW_ON) THEN
3017:
3018: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3019: 'Pub: ' || l_api_name || ' End');
3020: END IF;
3021:
3022: IF (AS_DEBUG_LOW_ON) THEN
3022: IF (AS_DEBUG_LOW_ON) THEN
3023:
3024:
3025:
3026: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
3027: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3028:
3029: END IF;
3030:
3035: );
3036:
3037: EXCEPTION
3038: WHEN FND_API.G_EXC_ERROR THEN
3039: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3040: P_API_NAME => L_API_NAME
3041: ,P_PKG_NAME => G_PKG_NAME
3042: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3043: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3039: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3040: P_API_NAME => L_API_NAME
3041: ,P_PKG_NAME => G_PKG_NAME
3042: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3043: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3044: ,X_MSG_COUNT => X_MSG_COUNT
3045: ,X_MSG_DATA => X_MSG_DATA
3046: ,X_RETURN_STATUS => X_RETURN_STATUS);
3047:
3045: ,X_MSG_DATA => X_MSG_DATA
3046: ,X_RETURN_STATUS => X_RETURN_STATUS);
3047:
3048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3049: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3050: P_API_NAME => L_API_NAME
3051: ,P_PKG_NAME => G_PKG_NAME
3052: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3053: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3049: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3050: P_API_NAME => L_API_NAME
3051: ,P_PKG_NAME => G_PKG_NAME
3052: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3053: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3054: ,X_MSG_COUNT => X_MSG_COUNT
3055: ,X_MSG_DATA => X_MSG_DATA
3056: ,X_RETURN_STATUS => X_RETURN_STATUS);
3057:
3055: ,X_MSG_DATA => X_MSG_DATA
3056: ,X_RETURN_STATUS => X_RETURN_STATUS);
3057:
3058: WHEN OTHERS THEN
3059: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3060: P_API_NAME => L_API_NAME
3061: ,P_PKG_NAME => G_PKG_NAME
3062: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3063: ,P_SQLCODE => SQLCODE
3058: WHEN OTHERS THEN
3059: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3060: P_API_NAME => L_API_NAME
3061: ,P_PKG_NAME => G_PKG_NAME
3062: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3063: ,P_SQLCODE => SQLCODE
3064: ,P_SQLERRM => SQLERRM
3065: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3066: ,X_MSG_COUNT => X_MSG_COUNT
3061: ,P_PKG_NAME => G_PKG_NAME
3062: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3063: ,P_SQLCODE => SQLCODE
3064: ,P_SQLERRM => SQLERRM
3065: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3066: ,X_MSG_COUNT => X_MSG_COUNT
3067: ,X_MSG_DATA => X_MSG_DATA
3068: ,X_RETURN_STATUS => X_RETURN_STATUS);
3069: End Assign_Sales_Lead;
3199:
3200: -- Debug Message
3201: IF (AS_DEBUG_LOW_ON) THEN
3202:
3203: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3204: 'Pub: ' || l_api_name || ' Start');
3205: END IF;
3206:
3207: IF (AS_DEBUG_LOW_ON) THEN
3207: IF (AS_DEBUG_LOW_ON) THEN
3208:
3209:
3210:
3211: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3212: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3213:
3214: END IF;
3215:
3221: --
3222: -- Calling private API
3223: IF (AS_DEBUG_LOW_ON) THEN
3224:
3225: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3226: 'PUB: Call PVT.CALL_WF_TO_ASSIGN');
3227: END IF;
3228:
3229: AS_SALES_LEAD_ASSIGN_PVT.CALL_WF_TO_ASSIGN(
3254:
3255: -- Debug Message
3256: IF (AS_DEBUG_LOW_ON) THEN
3257:
3258: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3259: 'Pub: ' || l_api_name || ' End');
3260: END IF;
3261:
3262: IF (AS_DEBUG_LOW_ON) THEN
3262: IF (AS_DEBUG_LOW_ON) THEN
3263:
3264:
3265:
3266: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
3267: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3268:
3269: END IF;
3270:
3275: );
3276:
3277: EXCEPTION
3278: WHEN FND_API.G_EXC_ERROR THEN
3279: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3280: P_API_NAME => L_API_NAME
3281: ,P_PKG_NAME => G_PKG_NAME
3282: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3283: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3279: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3280: P_API_NAME => L_API_NAME
3281: ,P_PKG_NAME => G_PKG_NAME
3282: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3283: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3284: ,X_MSG_COUNT => X_MSG_COUNT
3285: ,X_MSG_DATA => X_MSG_DATA
3286: ,X_RETURN_STATUS => X_RETURN_STATUS);
3287:
3285: ,X_MSG_DATA => X_MSG_DATA
3286: ,X_RETURN_STATUS => X_RETURN_STATUS);
3287:
3288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3289: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3290: P_API_NAME => L_API_NAME
3291: ,P_PKG_NAME => G_PKG_NAME
3292: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3293: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3289: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3290: P_API_NAME => L_API_NAME
3291: ,P_PKG_NAME => G_PKG_NAME
3292: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3293: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3294: ,X_MSG_COUNT => X_MSG_COUNT
3295: ,X_MSG_DATA => X_MSG_DATA
3296: ,X_RETURN_STATUS => X_RETURN_STATUS);
3297:
3295: ,X_MSG_DATA => X_MSG_DATA
3296: ,X_RETURN_STATUS => X_RETURN_STATUS);
3297:
3298: WHEN OTHERS THEN
3299: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3300: P_API_NAME => L_API_NAME
3301: ,P_PKG_NAME => G_PKG_NAME
3302: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3303: ,P_SQLCODE => SQLCODE
3298: WHEN OTHERS THEN
3299: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3300: P_API_NAME => L_API_NAME
3301: ,P_PKG_NAME => G_PKG_NAME
3302: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3303: ,P_SQLCODE => SQLCODE
3304: ,P_SQLERRM => SQLERRM
3305: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3306: ,X_MSG_COUNT => X_MSG_COUNT
3301: ,P_PKG_NAME => G_PKG_NAME
3302: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3303: ,P_SQLCODE => SQLCODE
3304: ,P_SQLERRM => SQLERRM
3305: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3306: ,X_MSG_COUNT => X_MSG_COUNT
3307: ,X_MSG_DATA => X_MSG_DATA
3308: ,X_RETURN_STATUS => X_RETURN_STATUS);
3309: END CALL_WF_TO_ASSIGN;
3347:
3348: -- Debug Message
3349: IF (AS_DEBUG_LOW_ON) THEN
3350:
3351: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3352: 'Pub: ' || l_api_name || ' Start');
3353: END IF;
3354:
3355: IF (AS_DEBUG_LOW_ON) THEN
3355: IF (AS_DEBUG_LOW_ON) THEN
3356:
3357:
3358:
3359: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3360: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3361:
3362: END IF;
3363:
3370:
3371: -- Calling Private package: Build_Lead_Sales_Team
3372: IF (AS_DEBUG_LOW_ON) THEN
3373:
3374: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3375: 'PUB: Call PVT.Build_Lead_Sales_Team');
3376: END IF;
3377:
3378: AS_SALES_LEAD_ASSIGN_PVT.Build_Lead_Sales_Team(
3408:
3409: -- Debug Message
3410: IF (AS_DEBUG_LOW_ON) THEN
3411:
3412: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3413: 'Pub: ' || l_api_name || ' End');
3414: END IF;
3415:
3416: IF (AS_DEBUG_LOW_ON) THEN
3416: IF (AS_DEBUG_LOW_ON) THEN
3417:
3418:
3419:
3420: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
3421: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3422:
3423: END IF;
3424:
3429: );
3430:
3431: EXCEPTION
3432: WHEN FND_API.G_EXC_ERROR THEN
3433: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3434: P_API_NAME => L_API_NAME
3435: ,P_PKG_NAME => G_PKG_NAME
3436: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3437: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3433: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3434: P_API_NAME => L_API_NAME
3435: ,P_PKG_NAME => G_PKG_NAME
3436: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3437: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3438: ,X_MSG_COUNT => X_MSG_COUNT
3439: ,X_MSG_DATA => X_MSG_DATA
3440: ,X_RETURN_STATUS => X_RETURN_STATUS);
3441:
3439: ,X_MSG_DATA => X_MSG_DATA
3440: ,X_RETURN_STATUS => X_RETURN_STATUS);
3441:
3442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3443: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3444: P_API_NAME => L_API_NAME
3445: ,P_PKG_NAME => G_PKG_NAME
3446: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3447: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3443: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3444: P_API_NAME => L_API_NAME
3445: ,P_PKG_NAME => G_PKG_NAME
3446: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3447: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3448: ,X_MSG_COUNT => X_MSG_COUNT
3449: ,X_MSG_DATA => X_MSG_DATA
3450: ,X_RETURN_STATUS => X_RETURN_STATUS);
3451:
3449: ,X_MSG_DATA => X_MSG_DATA
3450: ,X_RETURN_STATUS => X_RETURN_STATUS);
3451:
3452: WHEN OTHERS THEN
3453: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3454: P_API_NAME => L_API_NAME
3455: ,P_PKG_NAME => G_PKG_NAME
3456: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3457: ,P_SQLCODE => SQLCODE
3452: WHEN OTHERS THEN
3453: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3454: P_API_NAME => L_API_NAME
3455: ,P_PKG_NAME => G_PKG_NAME
3456: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3457: ,P_SQLCODE => SQLCODE
3458: ,P_SQLERRM => SQLERRM
3459: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3460: ,X_MSG_COUNT => X_MSG_COUNT
3455: ,P_PKG_NAME => G_PKG_NAME
3456: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3457: ,P_SQLCODE => SQLCODE
3458: ,P_SQLERRM => SQLERRM
3459: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3460: ,X_MSG_COUNT => X_MSG_COUNT
3461: ,X_MSG_DATA => X_MSG_DATA
3462: ,X_RETURN_STATUS => X_RETURN_STATUS);
3463:
3501:
3502: -- Debug Message
3503: IF (AS_DEBUG_LOW_ON) THEN
3504:
3505: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3506: 'Pub: ' || l_api_name || ' Start');
3507: END IF;
3508:
3509: IF (AS_DEBUG_LOW_ON) THEN
3509: IF (AS_DEBUG_LOW_ON) THEN
3510:
3511:
3512:
3513: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3514: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3515:
3516: END IF;
3517:
3524:
3525: -- Calling Private package: Rebuild_Lead_Sales_Team
3526: IF (AS_DEBUG_LOW_ON) THEN
3527:
3528: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3529: 'PUB: Call PVT.Rebuild_Lead_Sales_Team');
3530: END IF;
3531:
3532: AS_SALES_LEAD_ASSIGN_PVT.Rebuild_Lead_Sales_Team(
3562:
3563: -- Debug Message
3564: IF (AS_DEBUG_LOW_ON) THEN
3565:
3566: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3567: 'Pub: ' || l_api_name || ' End');
3568: END IF;
3569:
3570: IF (AS_DEBUG_LOW_ON) THEN
3570: IF (AS_DEBUG_LOW_ON) THEN
3571:
3572:
3573:
3574: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
3575: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3576:
3577: END IF;
3578:
3583: );
3584:
3585: EXCEPTION
3586: WHEN FND_API.G_EXC_ERROR THEN
3587: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3588: P_API_NAME => L_API_NAME
3589: ,P_PKG_NAME => G_PKG_NAME
3590: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3591: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3587: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3588: P_API_NAME => L_API_NAME
3589: ,P_PKG_NAME => G_PKG_NAME
3590: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3591: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3592: ,X_MSG_COUNT => X_MSG_COUNT
3593: ,X_MSG_DATA => X_MSG_DATA
3594: ,X_RETURN_STATUS => X_RETURN_STATUS);
3595:
3593: ,X_MSG_DATA => X_MSG_DATA
3594: ,X_RETURN_STATUS => X_RETURN_STATUS);
3595:
3596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3597: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3598: P_API_NAME => L_API_NAME
3599: ,P_PKG_NAME => G_PKG_NAME
3600: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3601: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3597: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3598: P_API_NAME => L_API_NAME
3599: ,P_PKG_NAME => G_PKG_NAME
3600: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3601: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3602: ,X_MSG_COUNT => X_MSG_COUNT
3603: ,X_MSG_DATA => X_MSG_DATA
3604: ,X_RETURN_STATUS => X_RETURN_STATUS);
3605:
3603: ,X_MSG_DATA => X_MSG_DATA
3604: ,X_RETURN_STATUS => X_RETURN_STATUS);
3605:
3606: WHEN OTHERS THEN
3607: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3608: P_API_NAME => L_API_NAME
3609: ,P_PKG_NAME => G_PKG_NAME
3610: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3611: ,P_SQLCODE => SQLCODE
3606: WHEN OTHERS THEN
3607: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3608: P_API_NAME => L_API_NAME
3609: ,P_PKG_NAME => G_PKG_NAME
3610: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3611: ,P_SQLCODE => SQLCODE
3612: ,P_SQLERRM => SQLERRM
3613: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3614: ,X_MSG_COUNT => X_MSG_COUNT
3609: ,P_PKG_NAME => G_PKG_NAME
3610: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3611: ,P_SQLCODE => SQLCODE
3612: ,P_SQLERRM => SQLERRM
3613: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3614: ,X_MSG_COUNT => X_MSG_COUNT
3615: ,X_MSG_DATA => X_MSG_DATA
3616: ,X_RETURN_STATUS => X_RETURN_STATUS);
3617:
3657:
3658: -- Debug Message
3659: IF (AS_DEBUG_LOW_ON) THEN
3660:
3661: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3662: 'Pub: ' || l_api_name || ' Start');
3663: END IF;
3664:
3665: IF (AS_DEBUG_LOW_ON) THEN
3665: IF (AS_DEBUG_LOW_ON) THEN
3666:
3667:
3668:
3669: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3670: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3671:
3672: END IF;
3673:
3680:
3681: -- Calling Private package: Run_Lead_Engines
3682: IF (AS_DEBUG_LOW_ON) THEN
3683:
3684: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3685: 'PUB: Call PVT.Run_Lead_Engines');
3686: END IF;
3687:
3688: AS_SALES_LEAD_ENGINE_PVT.Run_Lead_Engines(
3722:
3723: -- Debug Message
3724: IF (AS_DEBUG_LOW_ON) THEN
3725:
3726: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3727: 'Pub: ' || l_api_name || ' End');
3728: END IF;
3729:
3730: IF (AS_DEBUG_LOW_ON) THEN
3730: IF (AS_DEBUG_LOW_ON) THEN
3731:
3732:
3733:
3734: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
3735: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3736:
3737: END IF;
3738:
3743: );
3744:
3745: EXCEPTION
3746: WHEN FND_API.G_EXC_ERROR THEN
3747: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3748: P_API_NAME => L_API_NAME
3749: ,P_PKG_NAME => G_PKG_NAME
3750: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3751: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3747: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3748: P_API_NAME => L_API_NAME
3749: ,P_PKG_NAME => G_PKG_NAME
3750: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3751: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3752: ,X_MSG_COUNT => X_MSG_COUNT
3753: ,X_MSG_DATA => X_MSG_DATA
3754: ,X_RETURN_STATUS => X_RETURN_STATUS);
3755:
3753: ,X_MSG_DATA => X_MSG_DATA
3754: ,X_RETURN_STATUS => X_RETURN_STATUS);
3755:
3756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3757: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3758: P_API_NAME => L_API_NAME
3759: ,P_PKG_NAME => G_PKG_NAME
3760: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3761: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3757: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3758: P_API_NAME => L_API_NAME
3759: ,P_PKG_NAME => G_PKG_NAME
3760: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3761: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3762: ,X_MSG_COUNT => X_MSG_COUNT
3763: ,X_MSG_DATA => X_MSG_DATA
3764: ,X_RETURN_STATUS => X_RETURN_STATUS);
3765:
3763: ,X_MSG_DATA => X_MSG_DATA
3764: ,X_RETURN_STATUS => X_RETURN_STATUS);
3765:
3766: WHEN OTHERS THEN
3767: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3768: P_API_NAME => L_API_NAME
3769: ,P_PKG_NAME => G_PKG_NAME
3770: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3771: ,P_SQLCODE => SQLCODE
3766: WHEN OTHERS THEN
3767: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3768: P_API_NAME => L_API_NAME
3769: ,P_PKG_NAME => G_PKG_NAME
3770: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3771: ,P_SQLCODE => SQLCODE
3772: ,P_SQLERRM => SQLERRM
3773: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3774: ,X_MSG_COUNT => X_MSG_COUNT
3769: ,P_PKG_NAME => G_PKG_NAME
3770: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3771: ,P_SQLCODE => SQLCODE
3772: ,P_SQLERRM => SQLERRM
3773: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3774: ,X_MSG_COUNT => X_MSG_COUNT
3775: ,X_MSG_DATA => X_MSG_DATA
3776: ,X_RETURN_STATUS => X_RETURN_STATUS);
3777:
3816:
3817: -- Debug Message
3818: IF (AS_DEBUG_LOW_ON) THEN
3819:
3820: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3821: 'Pub: ' || l_api_name || ' Start');
3822: END IF;
3823:
3824: IF (AS_DEBUG_LOW_ON) THEN
3824: IF (AS_DEBUG_LOW_ON) THEN
3825:
3826:
3827:
3828: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3829: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3830:
3831: END IF;
3832:
3839:
3840: -- Calling Private package: Run_Lead_Engines
3841: IF (AS_DEBUG_LOW_ON) THEN
3842:
3843: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3844: 'PUB: Call PVT.Run_Lead_Engines');
3845: END IF;
3846:
3847: AS_SALES_LEAD_ENGINE_PVT.Run_Lead_Engines(
3880:
3881: -- Debug Message
3882: IF (AS_DEBUG_LOW_ON) THEN
3883:
3884: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3885: 'Pub: ' || l_api_name || ' End');
3886: END IF;
3887:
3888: IF (AS_DEBUG_LOW_ON) THEN
3888: IF (AS_DEBUG_LOW_ON) THEN
3889:
3890:
3891:
3892: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
3893: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3894:
3895: END IF;
3896:
3901: );
3902:
3903: EXCEPTION
3904: WHEN FND_API.G_EXC_ERROR THEN
3905: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3906: P_API_NAME => L_API_NAME
3907: ,P_PKG_NAME => G_PKG_NAME
3908: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3909: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3905: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3906: P_API_NAME => L_API_NAME
3907: ,P_PKG_NAME => G_PKG_NAME
3908: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3909: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3910: ,X_MSG_COUNT => X_MSG_COUNT
3911: ,X_MSG_DATA => X_MSG_DATA
3912: ,X_RETURN_STATUS => X_RETURN_STATUS);
3913:
3911: ,X_MSG_DATA => X_MSG_DATA
3912: ,X_RETURN_STATUS => X_RETURN_STATUS);
3913:
3914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3915: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3916: P_API_NAME => L_API_NAME
3917: ,P_PKG_NAME => G_PKG_NAME
3918: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3919: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3915: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3916: P_API_NAME => L_API_NAME
3917: ,P_PKG_NAME => G_PKG_NAME
3918: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3919: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3920: ,X_MSG_COUNT => X_MSG_COUNT
3921: ,X_MSG_DATA => X_MSG_DATA
3922: ,X_RETURN_STATUS => X_RETURN_STATUS);
3923:
3921: ,X_MSG_DATA => X_MSG_DATA
3922: ,X_RETURN_STATUS => X_RETURN_STATUS);
3923:
3924: WHEN OTHERS THEN
3925: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3926: P_API_NAME => L_API_NAME
3927: ,P_PKG_NAME => G_PKG_NAME
3928: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3929: ,P_SQLCODE => SQLCODE
3924: WHEN OTHERS THEN
3925: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3926: P_API_NAME => L_API_NAME
3927: ,P_PKG_NAME => G_PKG_NAME
3928: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3929: ,P_SQLCODE => SQLCODE
3930: ,P_SQLERRM => SQLERRM
3931: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3932: ,X_MSG_COUNT => X_MSG_COUNT
3927: ,P_PKG_NAME => G_PKG_NAME
3928: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3929: ,P_SQLCODE => SQLCODE
3930: ,P_SQLERRM => SQLERRM
3931: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3932: ,X_MSG_COUNT => X_MSG_COUNT
3933: ,X_MSG_DATA => X_MSG_DATA
3934: ,X_RETURN_STATUS => X_RETURN_STATUS);
3935:
3971:
3972: -- Debug Message
3973: IF (AS_DEBUG_LOW_ON) THEN
3974:
3975: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3976: 'Pub: ' || l_api_name || ' Start');
3977: END IF;
3978:
3979: IF (AS_DEBUG_LOW_ON) THEN
3979: IF (AS_DEBUG_LOW_ON) THEN
3980:
3981:
3982:
3983: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3984: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3985:
3986: END IF;
3987:
3994:
3995: -- Calling Private package: Run_Lead_Engines
3996: IF (AS_DEBUG_LOW_ON) THEN
3997:
3998: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3999: 'PUB: Call PVT.Run_Lead_Engines');
4000: END IF;
4001:
4002: PV_BG_PARTNER_MATCHING_PUB.Start_Partner_Matching(
4031:
4032: -- Debug Message
4033: IF (AS_DEBUG_LOW_ON) THEN
4034:
4035: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4036: 'Pub: ' || l_api_name || ' End');
4037: END IF;
4038:
4039: IF (AS_DEBUG_LOW_ON) THEN
4039: IF (AS_DEBUG_LOW_ON) THEN
4040:
4041:
4042:
4043: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
4044: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4045:
4046: END IF;
4047:
4052: );
4053:
4054: EXCEPTION
4055: WHEN FND_API.G_EXC_ERROR THEN
4056: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4057: P_API_NAME => L_API_NAME
4058: ,P_PKG_NAME => G_PKG_NAME
4059: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4060: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4056: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4057: P_API_NAME => L_API_NAME
4058: ,P_PKG_NAME => G_PKG_NAME
4059: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4060: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4061: ,X_MSG_COUNT => X_MSG_COUNT
4062: ,X_MSG_DATA => X_MSG_DATA
4063: ,X_RETURN_STATUS => X_RETURN_STATUS);
4064:
4062: ,X_MSG_DATA => X_MSG_DATA
4063: ,X_RETURN_STATUS => X_RETURN_STATUS);
4064:
4065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4066: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4067: P_API_NAME => L_API_NAME
4068: ,P_PKG_NAME => G_PKG_NAME
4069: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4070: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4066: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4067: P_API_NAME => L_API_NAME
4068: ,P_PKG_NAME => G_PKG_NAME
4069: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4070: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4071: ,X_MSG_COUNT => X_MSG_COUNT
4072: ,X_MSG_DATA => X_MSG_DATA
4073: ,X_RETURN_STATUS => X_RETURN_STATUS);
4074:
4072: ,X_MSG_DATA => X_MSG_DATA
4073: ,X_RETURN_STATUS => X_RETURN_STATUS);
4074:
4075: WHEN OTHERS THEN
4076: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4077: P_API_NAME => L_API_NAME
4078: ,P_PKG_NAME => G_PKG_NAME
4079: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4080: ,P_SQLCODE => SQLCODE
4075: WHEN OTHERS THEN
4076: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4077: P_API_NAME => L_API_NAME
4078: ,P_PKG_NAME => G_PKG_NAME
4079: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4080: ,P_SQLCODE => SQLCODE
4081: ,P_SQLERRM => SQLERRM
4082: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4083: ,X_MSG_COUNT => X_MSG_COUNT
4078: ,P_PKG_NAME => G_PKG_NAME
4079: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4080: ,P_SQLCODE => SQLCODE
4081: ,P_SQLERRM => SQLERRM
4082: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4083: ,X_MSG_COUNT => X_MSG_COUNT
4084: ,X_MSG_DATA => X_MSG_DATA
4085: ,X_RETURN_STATUS => X_RETURN_STATUS);
4086:
4224: END IF;
4225:
4226: -- Debug Message
4227: IF (AS_DEBUG_LOW_ON) THEN
4228: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4229: 'Pub: ' || l_api_name || ' Start');
4230: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4231: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4232: END IF;
4226: -- Debug Message
4227: IF (AS_DEBUG_LOW_ON) THEN
4228: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4229: 'Pub: ' || l_api_name || ' Start');
4230: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4231: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4232: END IF;
4233:
4234: -- Initialize API return status to SUCCESS
4244: l_ta_access_id_tbl, l_ta_terr_id_tbl;
4245: CLOSE C_Get_Acc_Terr;
4246:
4247: IF (AS_DEBUG_LOW_ON) THEN
4248: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4249: 'l_ta_access_id_tbl.count:' || l_ta_access_id_tbl.count);
4250: END IF;
4251:
4252: IF l_ta_access_id_tbl.count > 0
4253: THEN
4254: IF (AS_DEBUG_LOW_ON) THEN
4255: FOR l_i IN 1..l_ta_access_id_tbl.count
4256: LOOP
4257: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4258: 'Delete acc_id:' || l_ta_access_id_tbl(l_i)
4259: || ' terr_id:' || l_ta_terr_id_tbl(l_i));
4260: END LOOP;
4261: END IF;
4285: -- bugfix# 2770000, do not look for owner in the lead record. Validation is done before that.
4286: /*
4287: -- Checking if the owner is provided from UI
4288: IF (AS_DEBUG_LOW_ON) THEN
4289: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4290: 'Opening cursor get_sales_lead_owner');
4291: END IF;
4292:
4293: OPEN get_sales_lead_owner(P_Sales_Lead_id);
4315: FETCH c_check_owner_exists INTO l_owner_exists_flag;
4316: CLOSE c_check_owner_exists;
4317:
4318: IF (AS_DEBUG_LOW_ON) THEN
4319: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4320: 'assign to=' || l_salesforce_id);
4321: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4322: 'reject reason=' || l_reject_reason_code);
4323: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4317:
4318: IF (AS_DEBUG_LOW_ON) THEN
4319: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4320: 'assign to=' || l_salesforce_id);
4321: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4322: 'reject reason=' || l_reject_reason_code);
4323: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4324: 'owner exist?' || l_owner_exists_flag);
4325: END IF;
4319: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4320: 'assign to=' || l_salesforce_id);
4321: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4322: 'reject reason=' || l_reject_reason_code);
4323: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4324: 'owner exist?' || l_owner_exists_flag);
4325: END IF;
4326:
4327: -- Bug 2858785
4336: l_owner_exists_flag = 'N'
4337: THEN
4338: -- Calling Private package to get immature lead owner
4339: IF (AS_DEBUG_LOW_ON) THEN
4340: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4341: 'PUB: Call AS_SALES_LEAD_OWNER.Get_Immatured_Lead_Owner');
4342: END IF;
4343:
4344: AS_SALES_LEAD_OWNER.Get_Immatured_Lead_Owner(
4365:
4366: IF (l_salesforce_id IS NOT NULL)
4367: THEN
4368: IF (AS_DEBUG_LOW_ON) THEN
4369: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4370: 'Marketing Owner id=' || l_salesforce_id);
4371: END IF;
4372:
4373: OPEN c_check_sales_team (l_salesforce_id, p_sales_lead_id);
4381: FETCH c_get_group_id INTO l_group_id;
4382: CLOSE c_get_group_id;
4383:
4384: IF (AS_DEBUG_LOW_ON) THEN
4385: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4386: 'group_id=' || l_group_id);
4387: END IF;
4388:
4389: OPEN get_person_id_csr(l_salesforce_id);
4391: INTO l_person_id;
4392: CLOSE get_person_id_csr;
4393:
4394: IF (AS_DEBUG_LOW_ON) THEN
4395: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4396: 'person_id=' || l_person_id);
4397: END IF;
4398:
4399: IF l_access_id IS NULL
4456: -- Call Update sales lead
4457: --
4458:
4459: IF (AS_DEBUG_LOW_ON) THEN
4460: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4461: 'Before calling Update Saleslead');
4462: END IF;
4463:
4464: -- Call API to create log entry
4611: END IF;
4612:
4613: -- Debug Message
4614: IF (AS_DEBUG_LOW_ON) THEN
4615: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4616: 'Pub: ' || l_api_name || ' End');
4617: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4618: 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4619: END IF;
4613: -- Debug Message
4614: IF (AS_DEBUG_LOW_ON) THEN
4615: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4616: 'Pub: ' || l_api_name || ' End');
4617: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4618: 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4619: END IF;
4620:
4621: FND_MSG_PUB.Count_And_Get
4624: );
4625:
4626: EXCEPTION
4627: WHEN FND_API.G_EXC_ERROR THEN
4628: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4629: P_API_NAME => L_API_NAME
4630: ,P_PKG_NAME => G_PKG_NAME
4631: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4632: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4628: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4629: P_API_NAME => L_API_NAME
4630: ,P_PKG_NAME => G_PKG_NAME
4631: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4632: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4633: ,X_MSG_COUNT => X_MSG_COUNT
4634: ,X_MSG_DATA => X_MSG_DATA
4635: ,X_RETURN_STATUS => X_RETURN_STATUS);
4636:
4634: ,X_MSG_DATA => X_MSG_DATA
4635: ,X_RETURN_STATUS => X_RETURN_STATUS);
4636:
4637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4638: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4639: P_API_NAME => L_API_NAME
4640: ,P_PKG_NAME => G_PKG_NAME
4641: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4642: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4638: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4639: P_API_NAME => L_API_NAME
4640: ,P_PKG_NAME => G_PKG_NAME
4641: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4642: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4643: ,X_MSG_COUNT => X_MSG_COUNT
4644: ,X_MSG_DATA => X_MSG_DATA
4645: ,X_RETURN_STATUS => X_RETURN_STATUS);
4646:
4644: ,X_MSG_DATA => X_MSG_DATA
4645: ,X_RETURN_STATUS => X_RETURN_STATUS);
4646:
4647: WHEN OTHERS THEN
4648: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4649: P_API_NAME => L_API_NAME
4650: ,P_PKG_NAME => G_PKG_NAME
4651: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4652: ,P_SQLCODE => SQLCODE
4647: WHEN OTHERS THEN
4648: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4649: P_API_NAME => L_API_NAME
4650: ,P_PKG_NAME => G_PKG_NAME
4651: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4652: ,P_SQLCODE => SQLCODE
4653: ,P_SQLERRM => SQLERRM
4654: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4655: ,X_MSG_COUNT => X_MSG_COUNT
4650: ,P_PKG_NAME => G_PKG_NAME
4651: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4652: ,P_SQLCODE => SQLCODE
4653: ,P_SQLERRM => SQLERRM
4654: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4655: ,X_MSG_COUNT => X_MSG_COUNT
4656: ,X_MSG_DATA => X_MSG_DATA
4657: ,X_RETURN_STATUS => X_RETURN_STATUS);
4658:
4696: END IF;
4697:
4698: -- Debug Message
4699: IF (AS_DEBUG_LOW_ON) THEN
4700: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4701: 'Pub: ' || l_api_name || ' Start');
4702: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4703: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4704: END IF;
4698: -- Debug Message
4699: IF (AS_DEBUG_LOW_ON) THEN
4700: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4701: 'Pub: ' || l_api_name || ' Start');
4702: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4703: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4704: END IF;
4705:
4706: -- Initialize API return status to SUCCESS
4711: --
4712:
4713: -- Calling Private package: Run_Lead_Engines
4714: IF (AS_DEBUG_LOW_ON) THEN
4715: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4716: 'PUB: Call PVT.Lead_Process_After_Create');
4717: END IF;
4718:
4719: AS_SALES_LEAD_ENGINE_PVT.Lead_Process_After_Create(
4749:
4750:
4751: -- Debug Message
4752: IF (AS_DEBUG_LOW_ON) THEN
4753: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4754: 'Pub: ' || l_api_name || ' End');
4755: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4756: 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4757: END IF;
4751: -- Debug Message
4752: IF (AS_DEBUG_LOW_ON) THEN
4753: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4754: 'Pub: ' || l_api_name || ' End');
4755: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4756: 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4757: END IF;
4758:
4759: IF x_return_status = 'W'
4775: WHEN AS_SALES_LEADS_PUB.Filter_Exception THEN
4776: RAISE AS_SALES_LEADS_PUB.Filter_Exception;
4777:
4778: WHEN FND_API.G_EXC_ERROR THEN
4779: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4780: P_API_NAME => L_API_NAME
4781: ,P_PKG_NAME => G_PKG_NAME
4782: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4783: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4779: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4780: P_API_NAME => L_API_NAME
4781: ,P_PKG_NAME => G_PKG_NAME
4782: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4783: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4784: ,X_MSG_COUNT => X_MSG_COUNT
4785: ,X_MSG_DATA => X_MSG_DATA
4786: ,X_RETURN_STATUS => X_RETURN_STATUS);
4787:
4785: ,X_MSG_DATA => X_MSG_DATA
4786: ,X_RETURN_STATUS => X_RETURN_STATUS);
4787:
4788: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4789: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4790: P_API_NAME => L_API_NAME
4791: ,P_PKG_NAME => G_PKG_NAME
4792: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4793: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4789: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4790: P_API_NAME => L_API_NAME
4791: ,P_PKG_NAME => G_PKG_NAME
4792: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4793: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4794: ,X_MSG_COUNT => X_MSG_COUNT
4795: ,X_MSG_DATA => X_MSG_DATA
4796: ,X_RETURN_STATUS => X_RETURN_STATUS);
4797:
4795: ,X_MSG_DATA => X_MSG_DATA
4796: ,X_RETURN_STATUS => X_RETURN_STATUS);
4797:
4798: WHEN OTHERS THEN
4799: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4800: P_API_NAME => L_API_NAME
4801: ,P_PKG_NAME => G_PKG_NAME
4802: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4803: ,P_SQLCODE => SQLCODE
4798: WHEN OTHERS THEN
4799: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4800: P_API_NAME => L_API_NAME
4801: ,P_PKG_NAME => G_PKG_NAME
4802: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4803: ,P_SQLCODE => SQLCODE
4804: ,P_SQLERRM => SQLERRM
4805: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4806: ,X_MSG_COUNT => X_MSG_COUNT
4801: ,P_PKG_NAME => G_PKG_NAME
4802: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4803: ,P_SQLCODE => SQLCODE
4804: ,P_SQLERRM => SQLERRM
4805: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4806: ,X_MSG_COUNT => X_MSG_COUNT
4807: ,X_MSG_DATA => X_MSG_DATA
4808: ,X_RETURN_STATUS => X_RETURN_STATUS);
4809:
4848: END IF;
4849:
4850: -- Debug Message
4851: IF (AS_DEBUG_LOW_ON) THEN
4852: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4853: 'Pub: ' || l_api_name || ' Start');
4854: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4855: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4856: END IF;
4850: -- Debug Message
4851: IF (AS_DEBUG_LOW_ON) THEN
4852: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4853: 'Pub: ' || l_api_name || ' Start');
4854: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4855: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4856: END IF;
4857:
4858:
4864: --
4865:
4866: -- Calling Private package: Run_Lead_Engines
4867: IF (AS_DEBUG_LOW_ON) THEN
4868: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4869: 'PUB: Call PVT.Lead_Process_After_Update');
4870: END IF;
4871:
4872: AS_SALES_LEAD_ENGINE_PVT.Lead_Process_After_Update(
4902:
4903:
4904: -- Debug Message
4905: IF (AS_DEBUG_LOW_ON) THEN
4906: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4907: 'Pub: ' || l_api_name || ' End');
4908: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4909: 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4910: END IF;
4904: -- Debug Message
4905: IF (AS_DEBUG_LOW_ON) THEN
4906: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4907: 'Pub: ' || l_api_name || ' End');
4908: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4909: 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4910: END IF;
4911:
4912: IF x_return_status = 'W'
4924: END IF;
4925:
4926: EXCEPTION
4927: WHEN FND_API.G_EXC_ERROR THEN
4928: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4929: P_API_NAME => L_API_NAME
4930: ,P_PKG_NAME => G_PKG_NAME
4931: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4932: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4928: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4929: P_API_NAME => L_API_NAME
4930: ,P_PKG_NAME => G_PKG_NAME
4931: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4932: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4933: ,X_MSG_COUNT => X_MSG_COUNT
4934: ,X_MSG_DATA => X_MSG_DATA
4935: ,X_RETURN_STATUS => X_RETURN_STATUS);
4936:
4934: ,X_MSG_DATA => X_MSG_DATA
4935: ,X_RETURN_STATUS => X_RETURN_STATUS);
4936:
4937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4938: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4939: P_API_NAME => L_API_NAME
4940: ,P_PKG_NAME => G_PKG_NAME
4941: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4942: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4938: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4939: P_API_NAME => L_API_NAME
4940: ,P_PKG_NAME => G_PKG_NAME
4941: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4942: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4943: ,X_MSG_COUNT => X_MSG_COUNT
4944: ,X_MSG_DATA => X_MSG_DATA
4945: ,X_RETURN_STATUS => X_RETURN_STATUS);
4946:
4944: ,X_MSG_DATA => X_MSG_DATA
4945: ,X_RETURN_STATUS => X_RETURN_STATUS);
4946:
4947: WHEN OTHERS THEN
4948: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4949: P_API_NAME => L_API_NAME
4950: ,P_PKG_NAME => G_PKG_NAME
4951: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4952: ,P_SQLCODE => SQLCODE
4947: WHEN OTHERS THEN
4948: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4949: P_API_NAME => L_API_NAME
4950: ,P_PKG_NAME => G_PKG_NAME
4951: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4952: ,P_SQLCODE => SQLCODE
4953: ,P_SQLERRM => SQLERRM
4954: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4955: ,X_MSG_COUNT => X_MSG_COUNT
4950: ,P_PKG_NAME => G_PKG_NAME
4951: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
4952: ,P_SQLCODE => SQLCODE
4953: ,P_SQLERRM => SQLERRM
4954: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4955: ,X_MSG_COUNT => X_MSG_COUNT
4956: ,X_MSG_DATA => X_MSG_DATA
4957: ,X_RETURN_STATUS => X_RETURN_STATUS);
4958: