eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_SALES_LEADS_PUB dependencies on FND_MSG_PUB

Line 74: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

70: -- *******************
71: -- Sales Lead Header
72: -- *******************
73:
74: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
75: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
76: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
77: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
78:

Line 75: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

71: -- Sales Lead Header
72: -- *******************
73:
74: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
75: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
76: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
77: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
78:
79: PROCEDURE Create_sales_lead(

Line 76: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

72: -- *******************
73:
74: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
75: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
76: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
77: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
78:
79: PROCEDURE Create_sales_lead(
80: P_Api_Version_Number IN NUMBER,

Line 77: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);

73:
74: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
75: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
76: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
77: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
78:
79: PROCEDURE Create_sales_lead(
80: P_Api_Version_Number IN NUMBER,
81: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

Line 121: FND_MSG_PUB.initialize;

117:
118: -- Initialize message list if p_init_msg_list is set to TRUE.
119: IF FND_API.to_Boolean( p_init_msg_list )
120: THEN
121: FND_MSG_PUB.initialize;
122: END IF;
123:
124: -- Debug Message
125: IF (AS_DEBUG_LOW_ON) THEN

Line 127: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 135: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:

Line 150: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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(

Line 194: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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:

Line 208: FND_MSG_PUB.Count_And_Get

204:
205: END IF;
206:
207:
208: FND_MSG_PUB.Count_And_Get
209: ( p_count => x_msg_count,
210: p_data => x_msg_data
211: );
212:

Line 218: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
220: ,X_MSG_COUNT => X_MSG_COUNT
221: ,X_MSG_DATA => X_MSG_DATA
222: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 228: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
230: ,X_MSG_COUNT => X_MSG_COUNT
231: ,X_MSG_DATA => X_MSG_DATA
232: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 285: FND_MSG_PUB.initialize;

281:
282: -- Initialize message list if p_init_msg_list is set to TRUE.
283: IF FND_API.to_Boolean( p_init_msg_list )
284: THEN
285: FND_MSG_PUB.initialize;
286: END IF;
287:
288: -- Debug Message
289: IF (AS_DEBUG_LOW_ON) THEN

Line 291: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 299: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:

Line 315: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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(

Line 352: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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:

Line 365: FND_MSG_PUB.Count_And_Get

361: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
362:
363: END IF;
364:
365: FND_MSG_PUB.Count_And_Get
366: ( p_count => x_msg_count,
367: p_data => x_msg_data
368: );
369:

Line 375: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
377: ,X_MSG_COUNT => X_MSG_COUNT
378: ,X_MSG_DATA => X_MSG_DATA
379: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 384: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
386: ,X_MSG_COUNT => X_MSG_COUNT
387: ,X_MSG_DATA => X_MSG_DATA
388: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 447: FND_MSG_PUB.initialize;

443:
444: -- Initialize message list if p_init_msg_list is set to TRUE.
445: IF FND_API.to_Boolean( p_init_msg_list )
446: THEN
447: FND_MSG_PUB.initialize;
448: END IF;
449:
450: -- Debug Message
451: IF (AS_DEBUG_LOW_ON) THEN

Line 453: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 461: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:

Line 476: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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,

Line 514: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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:

Line 527: FND_MSG_PUB.Count_And_Get

523: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
524:
525: END IF;
526:
527: FND_MSG_PUB.Count_And_Get
528: ( p_count => x_msg_count,
529: p_data => x_msg_data
530: );
531:

Line 537: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
539: ,X_MSG_COUNT => X_MSG_COUNT
540: ,X_MSG_DATA => X_MSG_DATA
541: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 547: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
549: ,X_MSG_COUNT => X_MSG_COUNT
550: ,X_MSG_DATA => X_MSG_DATA
551: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 604: FND_MSG_PUB.initialize;

600:
601: -- Initialize message list if p_init_msg_list is set to TRUE.
602: IF FND_API.to_Boolean( p_init_msg_list )
603: THEN
604: FND_MSG_PUB.initialize;
605: END IF;
606:
607: -- Debug Message
608: IF (AS_DEBUG_LOW_ON) THEN

Line 610: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 618: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:

Line 634: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:

Line 674: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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:

Line 687: FND_MSG_PUB.Count_And_Get

683: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
684:
685: END IF;
686:
687: FND_MSG_PUB.Count_And_Get
688: ( p_count => x_msg_count,
689: p_data => x_msg_data
690: );
691:

Line 697: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
699: ,X_MSG_COUNT => X_MSG_COUNT
700: ,X_MSG_DATA => X_MSG_DATA
701: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 707: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
709: ,X_MSG_COUNT => X_MSG_COUNT
710: ,X_MSG_DATA => X_MSG_DATA
711: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 764: FND_MSG_PUB.initialize;

760:
761: -- Initialize message list if p_init_msg_list is set to TRUE.
762: IF FND_API.to_Boolean( p_init_msg_list )
763: THEN
764: FND_MSG_PUB.initialize;
765: END IF;
766:
767: -- Debug Message
768: IF (AS_DEBUG_LOW_ON) THEN

Line 770: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 778: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:

Line 794: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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(

Line 832: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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:

Line 846: FND_MSG_PUB.Count_And_Get

842:
843: END IF;
844:
845: -- Standard call to get message count and if count is 1, get message info.
846: FND_MSG_PUB.Count_And_Get
847: ( p_count => x_msg_count,
848: p_data => x_msg_data
849: );
850:

Line 856: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
858: ,X_MSG_COUNT => X_MSG_COUNT
859: ,X_MSG_DATA => X_MSG_DATA
860: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 866: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
868: ,X_MSG_COUNT => X_MSG_COUNT
869: ,X_MSG_DATA => X_MSG_DATA
870: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 928: FND_MSG_PUB.initialize;

924:
925: -- Initialize message list if p_init_msg_list is set to TRUE.
926: IF FND_API.to_Boolean( p_init_msg_list )
927: THEN
928: FND_MSG_PUB.initialize;
929: END IF;
930:
931: -- Debug Message
932: IF (AS_DEBUG_LOW_ON) THEN

Line 934: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 942: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:

Line 957: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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,

Line 995: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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:

Line 1008: FND_MSG_PUB.Count_And_Get

1004: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1005:
1006: END IF;
1007:
1008: FND_MSG_PUB.Count_And_Get
1009: ( p_count => x_msg_count,
1010: p_data => x_msg_data
1011: );
1012:

Line 1018: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
1020: ,X_MSG_COUNT => X_MSG_COUNT
1021: ,X_MSG_DATA => X_MSG_DATA
1022: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1028: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
1030: ,X_MSG_COUNT => X_MSG_COUNT
1031: ,X_MSG_DATA => X_MSG_DATA
1032: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1085: FND_MSG_PUB.initialize;

1081:
1082: -- Initialize message list if p_init_msg_list is set to TRUE.
1083: IF FND_API.to_Boolean( p_init_msg_list )
1084: THEN
1085: FND_MSG_PUB.initialize;
1086: END IF;
1087:
1088: -- Debug Message
1089: IF (AS_DEBUG_LOW_ON) THEN

Line 1091: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1099: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:

Line 1115: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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(

Line 1153: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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:

Line 1166: FND_MSG_PUB.Count_And_Get

1162: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1163:
1164: END IF;
1165:
1166: FND_MSG_PUB.Count_And_Get
1167: ( p_count => x_msg_count,
1168: p_data => x_msg_data
1169: );
1170:

Line 1176: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
1178: ,X_MSG_COUNT => X_MSG_COUNT
1179: ,X_MSG_DATA => X_MSG_DATA
1180: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1186: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
1188: ,X_MSG_COUNT => X_MSG_COUNT
1189: ,X_MSG_DATA => X_MSG_DATA
1190: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1245: FND_MSG_PUB.initialize;

1241:
1242: -- Initialize message list if p_init_msg_list is set to TRUE.
1243: IF FND_API.to_Boolean( p_init_msg_list )
1244: THEN
1245: FND_MSG_PUB.initialize;
1246: END IF;
1247:
1248: -- Debug Message
1249: IF (AS_DEBUG_LOW_ON) THEN

Line 1251: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1259: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:

Line 1275: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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(

Line 1313: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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:

Line 1327: FND_MSG_PUB.Count_And_Get

1323:
1324: END IF;
1325:
1326: -- Standard call to get message count and if count is 1, get message info.
1327: FND_MSG_PUB.Count_And_Get
1328: ( p_count => x_msg_count,
1329: p_data => x_msg_data
1330: );
1331:

Line 1337: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
1339: ,X_MSG_COUNT => X_MSG_COUNT
1340: ,X_MSG_DATA => X_MSG_DATA
1341: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1347: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
1349: ,X_MSG_COUNT => X_MSG_COUNT
1350: ,X_MSG_DATA => X_MSG_DATA
1351: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1409: FND_MSG_PUB.initialize;

1405:
1406: -- Initialize message list if p_init_msg_list is set to TRUE.
1407: IF FND_API.to_Boolean( p_init_msg_list )
1408: THEN
1409: FND_MSG_PUB.initialize;
1410: END IF;
1411:
1412: -- Debug Message
1413: IF (AS_DEBUG_LOW_ON) THEN

Line 1415: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1423: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:

Line 1438: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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,

Line 1477: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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:

Line 1491: FND_MSG_PUB.Count_And_Get

1487:
1488: END IF;
1489:
1490: -- Standard call to get message count and if count is 1, get message info.
1491: FND_MSG_PUB.Count_And_Get
1492: ( p_count => x_msg_count,
1493: p_data => x_msg_data
1494: );
1495:

Line 1501: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
1503: ,X_MSG_COUNT => X_MSG_COUNT
1504: ,X_MSG_DATA => X_MSG_DATA
1505: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1511: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
1513: ,X_MSG_COUNT => X_MSG_COUNT
1514: ,X_MSG_DATA => X_MSG_DATA
1515: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1577: FND_MSG_PUB.initialize;

1573:
1574: -- Initialize message list if p_init_msg_list is set to TRUE.
1575: IF FND_API.to_Boolean( p_init_msg_list )
1576: THEN
1577: FND_MSG_PUB.initialize;
1578: END IF;
1579:
1580: -- Debug Message
1581: IF (AS_DEBUG_LOW_ON) THEN

Line 1583: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1591: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:

Line 1605: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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,

Line 1644: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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:

Line 1658: FND_MSG_PUB.Count_And_Get

1654:
1655: END IF;
1656:
1657: -- Standard call to get message count and if count is 1, get message info.
1658: FND_MSG_PUB.Count_And_Get
1659: ( p_count => x_msg_count,
1660: p_data => x_msg_data
1661: );
1662:

Line 1668: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
1670: ,X_MSG_COUNT => X_MSG_COUNT
1671: ,X_MSG_DATA => X_MSG_DATA
1672: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1678: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
1680: ,X_MSG_COUNT => X_MSG_COUNT
1681: ,X_MSG_DATA => X_MSG_DATA
1682: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1843: FND_MSG_PUB.initialize;

1839:
1840: -- Initialize message list if p_init_msg_list is set to TRUE.
1841: IF FND_API.to_Boolean( p_init_msg_list )
1842: THEN
1843: FND_MSG_PUB.initialize;
1844: END IF;
1845:
1846: -- Debug Message
1847: IF (AS_DEBUG_LOW_ON) THEN

Line 1849: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1857: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:

Line 1871: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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,

Line 2035: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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:

Line 2049: FND_MSG_PUB.Count_And_Get

2045:
2046: END IF;
2047:
2048: -- Standard call to get message count and if count is 1, get message info.
2049: FND_MSG_PUB.Count_And_Get
2050: ( p_count => x_msg_count,
2051: p_data => x_msg_data
2052: );
2053:

Line 2059: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
2061: ,X_MSG_COUNT => X_MSG_COUNT
2062: ,X_MSG_DATA => X_MSG_DATA
2063: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2069: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
2071: ,X_MSG_COUNT => X_MSG_COUNT
2072: ,X_MSG_DATA => X_MSG_DATA
2073: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2142: FND_MSG_PUB.initialize;

2138:
2139: -- Initialize message list if p_init_msg_list is set to TRUE.
2140: IF FND_API.to_Boolean( p_init_msg_list )
2141: THEN
2142: FND_MSG_PUB.initialize;
2143: END IF;
2144:
2145: -- Debug Message
2146: IF (AS_DEBUG_LOW_ON) THEN

Line 2148: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2156: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:

Line 2170: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:

Line 2221: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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:

Line 2235: FND_MSG_PUB.Count_And_Get

2231:
2232: END IF;
2233:
2234: -- Standard call to get message count and if count is 1, get message info.
2235: FND_MSG_PUB.Count_And_Get
2236: ( p_count => x_msg_count,
2237: p_data => x_msg_data
2238: );
2239: EXCEPTION

Line 2244: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
2246: ,X_MSG_COUNT => X_MSG_COUNT
2247: ,X_MSG_DATA => X_MSG_DATA
2248: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2254: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
2256: ,X_MSG_COUNT => X_MSG_COUNT
2257: ,X_MSG_DATA => X_MSG_DATA
2258: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2335: FND_MSG_PUB.initialize;

2331:
2332: -- Initialize message list if p_init_msg_list is set to TRUE.
2333: IF FND_API.to_Boolean( p_init_msg_list )
2334: THEN
2335: FND_MSG_PUB.initialize;
2336: END IF;
2337:
2338: -- Debug Message
2339: IF (AS_DEBUG_LOW_ON) THEN

Line 2341: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2349: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:

Line 2363: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:

Line 2430: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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:

Line 2444: FND_MSG_PUB.Count_And_Get

2440:
2441: END IF;
2442:
2443: -- Standard call to get message count and if count is 1, get message info.
2444: FND_MSG_PUB.Count_And_Get
2445: ( p_count => x_msg_count,
2446: p_data => x_msg_data
2447: );
2448: EXCEPTION

Line 2453: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
2455: ,X_MSG_COUNT => X_MSG_COUNT
2456: ,X_MSG_DATA => X_MSG_DATA
2457: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2463: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
2465: ,X_MSG_COUNT => X_MSG_COUNT
2466: ,X_MSG_DATA => X_MSG_DATA
2467: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2626: FND_MSG_PUB.initialize;

2622:
2623: -- Initialize message list if p_init_msg_list is set to TRUE.
2624: IF FND_API.to_Boolean( p_init_msg_list )
2625: THEN
2626: FND_MSG_PUB.initialize;
2627: END IF;
2628:
2629: -- Debug Message
2630: IF (AS_DEBUG_LOW_ON) THEN

Line 2632: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2640: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:

Line 2654: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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(

Line 2850: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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:

Line 2864: FND_MSG_PUB.Count_And_Get

2860:
2861: END IF;
2862:
2863: -- Standard call to get message count and if count is 1, get message info.
2864: FND_MSG_PUB.Count_And_Get
2865: ( p_count => x_msg_count,
2866: p_data => x_msg_data
2867: );
2868: EXCEPTION

Line 2873: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
2875: ,X_MSG_COUNT => X_MSG_COUNT
2876: ,X_MSG_DATA => X_MSG_DATA
2877: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2883: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
2885: ,X_MSG_COUNT => X_MSG_COUNT
2886: ,X_MSG_DATA => X_MSG_DATA
2887: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2941: FND_MSG_PUB.initialize;

2937:
2938: -- Initialize message list if p_init_msg_list is set to TRUE.
2939: IF FND_API.to_Boolean( p_init_msg_list )
2940: THEN
2941: FND_MSG_PUB.initialize;
2942: END IF;
2943:
2944: -- Debug Message
2945: IF (AS_DEBUG_LOW_ON) THEN

Line 2947: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2955: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:

Line 2969: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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(

Line 3018: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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:

Line 3032: FND_MSG_PUB.Count_And_Get

3028:
3029: END IF;
3030:
3031: -- Standard call to get message count and if count is 1, get message info.
3032: FND_MSG_PUB.Count_And_Get
3033: ( p_count => x_msg_count,
3034: p_data => x_msg_data
3035: );
3036:

Line 3042: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
3044: ,X_MSG_COUNT => X_MSG_COUNT
3045: ,X_MSG_DATA => X_MSG_DATA
3046: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3052: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
3054: ,X_MSG_COUNT => X_MSG_COUNT
3055: ,X_MSG_DATA => X_MSG_DATA
3056: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3197: FND_MSG_PUB.initialize;

3193:
3194: -- Initialize message list if p_init_msg_list is set to TRUE.
3195: IF FND_API.to_Boolean( p_init_msg_list )
3196: THEN
3197: FND_MSG_PUB.initialize;
3198: END IF;
3199:
3200: -- Debug Message
3201: IF (AS_DEBUG_LOW_ON) THEN

Line 3203: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3211: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:

Line 3225: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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(

Line 3258: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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:

Line 3272: FND_MSG_PUB.Count_And_Get

3268:
3269: END IF;
3270:
3271: -- Standard call to get message count and if count is 1, get message info.
3272: FND_MSG_PUB.Count_And_Get
3273: ( p_count => x_msg_count,
3274: p_data => x_msg_data
3275: );
3276:

Line 3282: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
3284: ,X_MSG_COUNT => X_MSG_COUNT
3285: ,X_MSG_DATA => X_MSG_DATA
3286: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3292: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
3294: ,X_MSG_COUNT => X_MSG_COUNT
3295: ,X_MSG_DATA => X_MSG_DATA
3296: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3345: FND_MSG_PUB.initialize;

3341:
3342: -- Initialize message list if p_init_msg_list is set to TRUE.
3343: IF FND_API.to_Boolean( p_init_msg_list )
3344: THEN
3345: FND_MSG_PUB.initialize;
3346: END IF;
3347:
3348: -- Debug Message
3349: IF (AS_DEBUG_LOW_ON) THEN

Line 3351: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3359: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:

Line 3374: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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(

Line 3412: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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:

Line 3426: FND_MSG_PUB.Count_And_Get

3422:
3423: END IF;
3424:
3425:
3426: FND_MSG_PUB.Count_And_Get
3427: ( p_count => x_msg_count,
3428: p_data => x_msg_data
3429: );
3430:

Line 3436: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
3438: ,X_MSG_COUNT => X_MSG_COUNT
3439: ,X_MSG_DATA => X_MSG_DATA
3440: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3446: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
3448: ,X_MSG_COUNT => X_MSG_COUNT
3449: ,X_MSG_DATA => X_MSG_DATA
3450: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3499: FND_MSG_PUB.initialize;

3495:
3496: -- Initialize message list if p_init_msg_list is set to TRUE.
3497: IF FND_API.to_Boolean( p_init_msg_list )
3498: THEN
3499: FND_MSG_PUB.initialize;
3500: END IF;
3501:
3502: -- Debug Message
3503: IF (AS_DEBUG_LOW_ON) THEN

Line 3505: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3513: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:

Line 3528: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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(

Line 3566: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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:

Line 3580: FND_MSG_PUB.Count_And_Get

3576:
3577: END IF;
3578:
3579:
3580: FND_MSG_PUB.Count_And_Get
3581: ( p_count => x_msg_count,
3582: p_data => x_msg_data
3583: );
3584:

Line 3590: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
3592: ,X_MSG_COUNT => X_MSG_COUNT
3593: ,X_MSG_DATA => X_MSG_DATA
3594: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3600: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
3602: ,X_MSG_COUNT => X_MSG_COUNT
3603: ,X_MSG_DATA => X_MSG_DATA
3604: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3655: FND_MSG_PUB.initialize;

3651:
3652: -- Initialize message list if p_init_msg_list is set to TRUE.
3653: IF FND_API.to_Boolean( p_init_msg_list )
3654: THEN
3655: FND_MSG_PUB.initialize;
3656: END IF;
3657:
3658: -- Debug Message
3659: IF (AS_DEBUG_LOW_ON) THEN

Line 3661: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3669: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:

Line 3684: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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(

Line 3726: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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:

Line 3740: FND_MSG_PUB.Count_And_Get

3736:
3737: END IF;
3738:
3739:
3740: FND_MSG_PUB.Count_And_Get
3741: ( p_count => x_msg_count,
3742: p_data => x_msg_data
3743: );
3744:

Line 3750: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
3752: ,X_MSG_COUNT => X_MSG_COUNT
3753: ,X_MSG_DATA => X_MSG_DATA
3754: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3760: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
3762: ,X_MSG_COUNT => X_MSG_COUNT
3763: ,X_MSG_DATA => X_MSG_DATA
3764: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3814: FND_MSG_PUB.initialize;

3810:
3811: -- Initialize message list if p_init_msg_list is set to TRUE.
3812: IF FND_API.to_Boolean( p_init_msg_list )
3813: THEN
3814: FND_MSG_PUB.initialize;
3815: END IF;
3816:
3817: -- Debug Message
3818: IF (AS_DEBUG_LOW_ON) THEN

Line 3820: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3828: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:

Line 3843: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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(

Line 3884: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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:

Line 3898: FND_MSG_PUB.Count_And_Get

3894:
3895: END IF;
3896:
3897:
3898: FND_MSG_PUB.Count_And_Get
3899: ( p_count => x_msg_count,
3900: p_data => x_msg_data
3901: );
3902:

Line 3908: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
3910: ,X_MSG_COUNT => X_MSG_COUNT
3911: ,X_MSG_DATA => X_MSG_DATA
3912: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3918: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
3920: ,X_MSG_COUNT => X_MSG_COUNT
3921: ,X_MSG_DATA => X_MSG_DATA
3922: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3969: FND_MSG_PUB.initialize;

3965:
3966: -- Initialize message list if p_init_msg_list is set to TRUE.
3967: IF FND_API.to_Boolean( p_init_msg_list )
3968: THEN
3969: FND_MSG_PUB.initialize;
3970: END IF;
3971:
3972: -- Debug Message
3973: IF (AS_DEBUG_LOW_ON) THEN

Line 3975: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3983: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:

Line 3998: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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(

Line 4035: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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:

Line 4049: FND_MSG_PUB.Count_And_Get

4045:
4046: END IF;
4047:
4048:
4049: FND_MSG_PUB.Count_And_Get
4050: ( p_count => x_msg_count,
4051: p_data => x_msg_data
4052: );
4053:

Line 4059: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
4061: ,X_MSG_COUNT => X_MSG_COUNT
4062: ,X_MSG_DATA => X_MSG_DATA
4063: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4069: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
4071: ,X_MSG_COUNT => X_MSG_COUNT
4072: ,X_MSG_DATA => X_MSG_DATA
4073: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4223: FND_MSG_PUB.initialize;

4219:
4220: -- Initialize message list if p_init_msg_list is set to TRUE.
4221: IF FND_API.to_Boolean( p_init_msg_list )
4222: THEN
4223: FND_MSG_PUB.initialize;
4224: END IF;
4225:
4226: -- Debug Message
4227: IF (AS_DEBUG_LOW_ON) THEN

Line 4228: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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;

Line 4230: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 4248: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 4257: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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;

Line 4289: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 4319: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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,

Line 4321: 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;

Line 4323: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 4340: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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(

Line 4369: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 4385: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 4395: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 4460: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 4615: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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;

Line 4617: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 4621: FND_MSG_PUB.Count_And_Get

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
4622: ( p_count => x_msg_count,
4623: p_data => x_msg_data
4624: );
4625:

Line 4631: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
4633: ,X_MSG_COUNT => X_MSG_COUNT
4634: ,X_MSG_DATA => X_MSG_DATA
4635: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4641: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
4643: ,X_MSG_COUNT => X_MSG_COUNT
4644: ,X_MSG_DATA => X_MSG_DATA
4645: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4695: FND_MSG_PUB.initialize;

4691:
4692: -- Initialize message list if p_init_msg_list is set to TRUE.
4693: IF FND_API.to_Boolean( p_init_msg_list )
4694: THEN
4695: FND_MSG_PUB.initialize;
4696: END IF;
4697:
4698: -- Debug Message
4699: IF (AS_DEBUG_LOW_ON) THEN

Line 4700: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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;

Line 4702: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 4715: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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(

Line 4753: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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;

Line 4755: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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'

Line 4761: FND_MSG_PUB.Count_And_Get

4757: END IF;
4758:
4759: IF x_return_status = 'W'
4760: THEN
4761: FND_MSG_PUB.Count_And_Get
4762: ( p_encoded => FND_API.G_FALSE,
4763: p_count => x_msg_count,
4764: p_data => x_msg_data
4765: );

Line 4767: FND_MSG_PUB.Count_And_Get

4763: p_count => x_msg_count,
4764: p_data => x_msg_data
4765: );
4766: ELSE
4767: FND_MSG_PUB.Count_And_Get
4768: ( p_count => x_msg_count,
4769: p_data => x_msg_data
4770: );
4771: END IF;

Line 4782: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
4784: ,X_MSG_COUNT => X_MSG_COUNT
4785: ,X_MSG_DATA => X_MSG_DATA
4786: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4792: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
4794: ,X_MSG_COUNT => X_MSG_COUNT
4795: ,X_MSG_DATA => X_MSG_DATA
4796: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4847: FND_MSG_PUB.initialize;

4843:
4844: -- Initialize message list if p_init_msg_list is set to TRUE.
4845: IF FND_API.to_Boolean( p_init_msg_list )
4846: THEN
4847: FND_MSG_PUB.initialize;
4848: END IF;
4849:
4850: -- Debug Message
4851: IF (AS_DEBUG_LOW_ON) THEN

Line 4852: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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;

Line 4854: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:

Line 4868: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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(

Line 4906: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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;

Line 4908: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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'

Line 4914: FND_MSG_PUB.Count_And_Get

4910: END IF;
4911:
4912: IF x_return_status = 'W'
4913: THEN
4914: FND_MSG_PUB.Count_And_Get
4915: ( p_encoded => FND_API.G_FALSE,
4916: p_count => x_msg_count,
4917: p_data => x_msg_data
4918: );

Line 4920: FND_MSG_PUB.Count_And_Get

4916: p_count => x_msg_count,
4917: p_data => x_msg_data
4918: );
4919: ELSE
4920: FND_MSG_PUB.Count_And_Get
4921: ( p_count => x_msg_count,
4922: p_data => x_msg_data
4923: );
4924: END IF;

Line 4931: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
4933: ,X_MSG_COUNT => X_MSG_COUNT
4934: ,X_MSG_DATA => X_MSG_DATA
4935: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4941: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
4943: ,X_MSG_COUNT => X_MSG_COUNT
4944: ,X_MSG_DATA => X_MSG_DATA
4945: ,X_RETURN_STATUS => X_RETURN_STATUS);