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_LEADS_AUDIT_PKG dependencies on FND_MSG_PUB

Line 62: l_debug CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

58: p_trigger_mode IN VARCHAR2)
59: IS
60: l_LOG_ID NUMBER;
61: IsInsert NUMBER :=0;
62: l_debug CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
63: l_lead_count NUMBER :=0;
64: l_dummy_date CONSTANT DATE := to_date('31-12-9999', 'DD-MM-YYYY');
65: BEGIN
66: -- -- dbms_output.ENABLE(32000);

Line 119: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

115: p_ENDDAY_LOG_FLAG => 'Y',
116: p_ORG_ID => p_new_org_id,
117: p_TRIGGER_MODE => 'I');
118: IF l_debug THEN
119: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
120: 'asxopadb: Insert Log: '||l_LOG_ID );
121: END IF;
122:
123: ELSIF ( p_trigger_mode = 'ON-UPDATE' ) THEN

Line 170: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

166: p_ENDDAY_LOG_FLAG => 'Y',
167: p_ORG_ID => p_new_org_id,
168: p_TRIGGER_MODE => 'U');
169: IF l_debug THEN
170: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
171: 'asxopadb: Insert Log: '||l_LOG_ID );
172: END IF;
173: ELSE
174: --DBMS_OUTPUT.DISABLE;

Line 273: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

269: p_ENDDAY_LOG_FLAG => 'Y',
270: p_ORG_ID => p_new_org_id,
271: p_TRIGGER_MODE => 'U');
272: IF l_debug THEN
273: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
274: 'asxopadb: Update Log: '||p_old_lead_id || 'and '|| p_old_last_update_date );
275: END IF;
276: ELSE
277: -- dbms_output.put_line('AS_LEADS_LOG: not changed state i am in diff day'|| IsInsert);

Line 312: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

308: p_ENDDAY_LOG_FLAG => 'Y',
309: p_ORG_ID => p_new_org_id,
310: p_TRIGGER_MODE => 'U');
311: IF l_debug THEN
312: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
313: 'asxopadb: Insert Log: '||l_LOG_ID );
314: END IF;
315: END IF;
316: /*ELSE

Line 334: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

330: -- dbms_output.put_line('Error Number1:'||SQLCODE);
331: -- dbms_output.put_line('Error Message1:'|| SUBSTR(SQLERRM, 1, 200));
332:
333: IF l_debug THEN
334: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
335: 'Error in Leads Trg:' || sqlerrm);
336: END IF;
337:
338: FND_MSG_PUB.Add_Exc_Msg('AS_LEADS_AUDIT_PKG', 'Leads_Trigger_Handler');

Line 338: FND_MSG_PUB.Add_Exc_Msg('AS_LEADS_AUDIT_PKG', 'Leads_Trigger_Handler');

334: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
335: 'Error in Leads Trg:' || sqlerrm);
336: END IF;
337:
338: FND_MSG_PUB.Add_Exc_Msg('AS_LEADS_AUDIT_PKG', 'Leads_Trigger_Handler');
339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
340: WHEN OTHERS THEN
341: -- dbms_output.put_line('Error Number2:'||SQLCODE);
342: -- dbms_output.put_line('Error Message2:'|| SUBSTR(SQLERRM, 1, 200));

Line 344: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

340: WHEN OTHERS THEN
341: -- dbms_output.put_line('Error Number2:'||SQLCODE);
342: -- dbms_output.put_line('Error Message2:'|| SUBSTR(SQLERRM, 1, 200));
343: IF l_debug THEN
344: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
345: 'Error in Leads Trg:' || sqlerrm);
346: END IF;
347:
348: FND_MSG_PUB.Add_Exc_Msg('AS_LEADS_AUDIT_PKG', 'Leads_Trigger_Handler');

Line 348: FND_MSG_PUB.Add_Exc_Msg('AS_LEADS_AUDIT_PKG', 'Leads_Trigger_Handler');

344: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
345: 'Error in Leads Trg:' || sqlerrm);
346: END IF;
347:
348: FND_MSG_PUB.Add_Exc_Msg('AS_LEADS_AUDIT_PKG', 'Leads_Trigger_Handler');
349: END Leads_Trigger_Handler;
350: Procedure Lead_Lines_Trigger_Handler(
351: p_trigger_mode IN VARCHAR2,
352: p_new_lead_id IN as_lead_lines_all.lead_id%type,

Line 407: l_debug CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

403: IS
404: today_date Date;
405: lookUpTypeFlag BOOLEAN;
406: IsInsert NUMBER := 0;
407: l_debug CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
408: l_line_count NUMBER := 0;
409: l_new_last_update_date DATE := p_new_last_update_date;
410: l_dummy_date CONSTANT DATE := to_date('31-12-9999', 'DD-MM-YYYY');
411: BEGIN

Line 448: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

444: 'Y',
445: 'I');
446:
447: IF l_debug THEN
448: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
449: 'asxopadb: Insert Log: Lead_line_id '||p_new_lead_line_id || ' and Last Update Date '|| p_new_last_update_date);
450: END IF;
451:
452: ELSIF ( p_trigger_mode = 'ON-UPDATE' ) THEN

Line 484: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

480: p_new_rolling_forecast_flag ,
481: 'Y',
482: 'U');
483: IF l_debug THEN
484: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
485: 'asxopadb: Update Log: Lead_line_id '||p_old_lead_line_id || ' and Last Update Date '|| p_old_last_update_date);
486: END IF;
487: ELSE
488:

Line 533: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

529: p_new_rolling_forecast_flag ,
530: 'Y',
531: 'U');
532: IF l_debug THEN
533: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
534: 'asxopadb: Update Log: Lead_line_id '||p_old_lead_line_id || ' and Last Update Date '|| p_old_last_update_date);
535: END IF;
536: ELSE
537: -- dbms_output.put_line('Lead_Lines_Trigger_Handler I am in changes diff day state' || IsInsert);

Line 560: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

556: p_new_rolling_forecast_flag ,
557: 'Y',
558: 'U');
559: IF l_debug THEN
560: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
561: 'asxopadb: Update Log: Lead_line_id '||p_old_lead_line_id || ' and Last Update Date '|| p_old_last_update_date);
562: END IF;
563: END IF;
564: -- dbms_output.put_line('Lead_Lines_Trigger_Handler After completing the chages if block' || IsInsert);

Line 585: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

581:
582:
583:
584: IF l_debug THEN
585: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
586: 'asxopadb: Delete Log: Lead_line_id '||p_old_lead_line_id || ' and Last Update Date '|| p_old_last_update_date);
587: END IF;
588: END IF;
589: EXCEPTION

Line 592: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

588: END IF;
589: EXCEPTION
590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
591: IF l_debug THEN
592: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
593: 'Error in Lead Lines Trg:' || sqlerrm);
594: END IF;
595: FND_MSG_PUB.Add_Exc_Msg('AS_LEADS_AUDIT_PKG', 'Lead_Lines_Trigger_Handler');
596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 595: FND_MSG_PUB.Add_Exc_Msg('AS_LEADS_AUDIT_PKG', 'Lead_Lines_Trigger_Handler');

591: IF l_debug THEN
592: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
593: 'Error in Lead Lines Trg:' || sqlerrm);
594: END IF;
595: FND_MSG_PUB.Add_Exc_Msg('AS_LEADS_AUDIT_PKG', 'Lead_Lines_Trigger_Handler');
596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
597: WHEN OTHERS THEN
598: IF l_debug THEN
599: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

Line 599: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

595: FND_MSG_PUB.Add_Exc_Msg('AS_LEADS_AUDIT_PKG', 'Lead_Lines_Trigger_Handler');
596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
597: WHEN OTHERS THEN
598: IF l_debug THEN
599: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
600: 'Error in Lead Lines Trg:' || sqlerrm);
601: END IF;
602: FND_MSG_PUB.Add_Exc_Msg('AS_LEADS_AUDIT_PKG', 'Lead_Lines_Trigger_Handler');
603: END Lead_Lines_Trigger_Handler;

Line 602: FND_MSG_PUB.Add_Exc_Msg('AS_LEADS_AUDIT_PKG', 'Lead_Lines_Trigger_Handler');

598: IF l_debug THEN
599: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
600: 'Error in Lead Lines Trg:' || sqlerrm);
601: END IF;
602: FND_MSG_PUB.Add_Exc_Msg('AS_LEADS_AUDIT_PKG', 'Lead_Lines_Trigger_Handler');
603: END Lead_Lines_Trigger_Handler;
604: PROCEDURE Sales_Credits_Trigger_Handler(p_trigger_Mode IN VARCHAR2,
605: p_new_lead_id IN as_sales_credits.lead_id%type,
606: p_old_lead_id IN as_sales_credits.lead_id%type,

Line 648: l_debug CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

644: p_old_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type)
645: IS
646: today_date Date;
647: IsInsert NUMBER :=0;
648: l_debug CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
649: l_credit_count NUMBER :=0;
650: l_new_last_update_date DATE := p_new_last_update_date;
651: BEGIN
652:

Line 685: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

681: p_new_opp_best_frcst_amount,
682: 'Y',
683: 'I');
684: IF l_debug THEN
685: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
686: 'asxopadb: Sales credit Insert Log: Lead_line_id '||p_new_lead_line_id || ' and Last Update Date '|| p_new_last_update_date);
687: END IF;
688:
689: ELSIF ( p_trigger_mode = 'ON-UPDATE' ) THEN

Line 717: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

713: p_new_opp_best_frcst_amount,
714: 'Y',
715: 'U');
716: IF l_debug THEN
717: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
718: 'asxopadb: Sales credit Insert Log: Lead_line_id '||p_new_lead_line_id || ' and Last Update Date '|| p_new_last_update_date);
719: END IF;
720: ELSE
721: IF( ( ( p_new_last_updated_by <> p_old_last_updated_by ) OR

Line 752: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

748: p_new_opp_best_frcst_amount,
749: 'Y',
750: 'U');
751: IF l_debug THEN
752: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
753: 'asxopadb: Sales credit Update Log: Lead_line_id '||p_old_sales_credit_id || ' and Last Update Date '|| p_old_last_update_date);
754: END IF;
755: ELSE
756: AS_SALES_CREDITS_LOG_PKG.Insert_Row(p_new_lead_id ,

Line 775: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

771: p_new_opp_best_frcst_amount,
772: 'Y',
773: 'U');
774: IF l_debug THEN
775: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
776: 'asxopadb: Sales credit Insert Log: Lead_line_id '||p_new_lead_line_id || ' and Last Update Date '|| p_new_last_update_date);
777: END IF;
778: END IF;
779: END IF;

Line 796: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

792: p_old_created_by,
793: 'Y');
794:
795: IF l_debug THEN
796: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
797: 'asxopadb: Sales credit Update Log: Lead_line_id '||p_old_sales_credit_id || ' and Last Update Date '|| p_old_last_update_date);
798: END IF;
799:
800: END IF;

Line 804: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

800: END IF;
801: EXCEPTION
802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
803: IF l_debug THEN
804: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
805: 'Error in Sales credits Trg:' || sqlerrm);
806: END IF;
807: FND_MSG_PUB.Add_Exc_Msg('AS_LEADS_AUDIT_PKG', 'Sales_Credits_Trigger_Handler');
808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 807: FND_MSG_PUB.Add_Exc_Msg('AS_LEADS_AUDIT_PKG', 'Sales_Credits_Trigger_Handler');

803: IF l_debug THEN
804: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
805: 'Error in Sales credits Trg:' || sqlerrm);
806: END IF;
807: FND_MSG_PUB.Add_Exc_Msg('AS_LEADS_AUDIT_PKG', 'Sales_Credits_Trigger_Handler');
808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809: WHEN OTHERS THEN
810: IF l_debug THEN
811: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

Line 811: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

807: FND_MSG_PUB.Add_Exc_Msg('AS_LEADS_AUDIT_PKG', 'Sales_Credits_Trigger_Handler');
808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809: WHEN OTHERS THEN
810: IF l_debug THEN
811: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
812: 'Error in Sales Credits Trg:' || sqlerrm);
813: END IF;
814:
815: FND_MSG_PUB.Add_Exc_Msg('AS_LEADS_AUDIT_PKG', 'Lead_Lines_Trigger_Handler');

Line 815: FND_MSG_PUB.Add_Exc_Msg('AS_LEADS_AUDIT_PKG', 'Lead_Lines_Trigger_Handler');

811: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
812: 'Error in Sales Credits Trg:' || sqlerrm);
813: END IF;
814:
815: FND_MSG_PUB.Add_Exc_Msg('AS_LEADS_AUDIT_PKG', 'Lead_Lines_Trigger_Handler');
816: END Sales_Credits_Trigger_Handler;
817:
818:
819: PROCEDURE GET_VALUE(p_old_last_update_date IN DATE,