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.JL_AR_AP_AWT_REPORTS_PKG dependencies on FND_LOG

Line 5: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY JL_AR_AP_AWT_REPORTS_PKG AS
2: /* $Header: jlarpwrb.pls 120.27.12020000.2 2012/11/01 22:20:43 abuissa ship $ */
3:
4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

Line 6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

2: /* $Header: jlarpwrb.pls 120.27.12020000.2 2012/11/01 22:20:43 abuissa ship $ */
3:
4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

3:
4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'JL.PLSQL.JL_AR_AP_AWT_REPORTS_PKG.';

Line 9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

5: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'JL.PLSQL.JL_AR_AP_AWT_REPORTS_PKG.';
13: x_org_id NUMBER; --bug 14798548

Line 10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'JL.PLSQL.JL_AR_AP_AWT_REPORTS_PKG.';
13: x_org_id NUMBER; --bug 14798548
14: -- Logging Infra

Line 11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'JL.PLSQL.JL_AR_AP_AWT_REPORTS_PKG.';
13: x_org_id NUMBER; --bug 14798548
14: -- Logging Infra
15:

Line 57: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

53:
54:
55: -- Logging Infra
56: l_procedure_name CONSTANT VARCHAR2(30) := 'JL_AR_AP_VOID_CERTIFICATES';
57: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
58: -- Logging Infra
59:
60:
61:

Line 82: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

78:
79: -- Logging Infra: Procedure level
80: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
81: l_log_msg := l_procedure_name||'(+)';
82: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
83: END IF;
84: -- Logging Infra: Procedure level
85:
86: -------------------------------

Line 95: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

91: -- Logging Infra: Statement level
92: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
93: l_log_msg := 'Parameter ';
94: l_log_msg := l_log_msg||'P_Payment_Id: '||p_payment_id;
95: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
96: END IF;
97: -- Logging Infra: Statement level
98:
99: OPEN c_void_certificates(P_PAYMENT_ID);

Line 106: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

102: -- Logging Infra: Statement level
103: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
104: l_log_msg := 'l_checkrun_id: '||l_checkrun_id;
105: l_log_msg := l_log_msg||'l_check_number: '||l_check_number;
106: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
107: END IF;
108: -- Logging Infra: Statement level
109: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Checkrun_id:'||l_checkrun_id);
110: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Check_number:'||l_check_number);

Line 122: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

118:
119: -- Logging Infra: Procedure level
120: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
121: l_log_msg := l_procedure_name||'(-)';
122: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
123: END IF;
124: -- Logging Infra: Procedure level
125:
126:

Line 135: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

131:
132: -- Logging Infra: Statement level
133: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
134: l_log_msg := 'EXCEPTION: No Data Found';
135: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
136: END IF;
137: -- Logging Infra: Statement level
138:
139:

Line 151: FND_LOG.STRING(G_LEVEL_STATEMENT,

147: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
148: END IF;
149:
150: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
151: FND_LOG.STRING(G_LEVEL_STATEMENT,
152: G_MODULE_NAME || l_procedure_name,
153: SQLCODE || ': ' || SQLERRM);
154: END IF;
155:

Line 218: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

214: DEBUG_Var varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
215: l_debug_info Varchar2(300);
216: --Logging infra
217: l_procedure_name CONSTANT VARCHAR2(30) := 'JL_AR_AP_GEN_CERTIFICATES';
218: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
219: --Logging infra
220: -----------CURSOR-----------
221:
222:

Line 366: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

362: v_org_id NUMBER(15); */
363:
364: -- Logging Infra
365: l_procedure_name CONSTANT VARCHAR2(30) := 'INS_INTO_JL_AR_AP_AWT_CERTIF';
366: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
367: -- Logging Infra
368:
369: BEGIN
370:

Line 374: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

370:
371: -- Logging Infra: Procedure level
372: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
373: l_log_msg := l_procedure_name||'(+)';
374: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
375: END IF;
376: -- Logging Infra: Procedure level
377:
378:

Line 448: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

444:
445: -- Logging Infra: Statement level
446: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
447: l_log_msg := 'Getting next sequence from jl_ar_ap_awt_certif_s';
448: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
449: END IF;
450: -- Logging Infra: Statement level
451:
452:

Line 466: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

462: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
463: l_log_msg := 'Parameters ';
464: l_log_msg := l_log_msg||'x_org_id: '||x_org_id; --bug 14798548
465: l_log_msg := l_log_msg||'v_table_id: '||v_table_id;
466: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
467: END IF;
468: -- Logging Infra: Statement level
469:
470:

Line 474: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

470:
471: -- Logging Infra: Statement level
472: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
473: l_log_msg := 'Inserting into jl_ar_ap_awt_certif_all table ';
474: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
475: END IF;
476: -- Logging Infra: Statement level
477:
478:

Line 543: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

539:
540: -- Logging Infra: Procedure level
541: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
542: l_log_msg := l_procedure_name||'(-)';
543: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
544: END IF;
545: -- Logging Infra: Procedure level
546:
547: RETURN (TRUE);

Line 556: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

552: ||v_column_required||' - Error in INS_INTO_JL_AR_AP_AWT_CERTIF';
553:
554: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
555: l_log_msg := 'EXCEPTION: '||p_errmsg;
556: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
557: END IF;
558:
559: RETURN(FALSE);
560:

Line 566: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

562: p_errmsg := SUBSTR(SQLERRM, 1, 100);
563: p_errmsg := p_errmsg||' - Error in INS_INTO_JL_AR_AP_AWT_CERTIF';
564: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
565: l_log_msg := 'EXCEPTION: '||p_errmsg;
566: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
567: END IF;
568:
569: RETURN(FALSE);
570: END;

Line 592: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

588: IS
589:
590: -- Logging Infra
591: l_procedure_name CONSTANT VARCHAR2(30) := 'SAME_PAYMENT_TAX_NAME_VENDOR';
592: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
593: -- Logging Infra
594:
595: BEGIN
596: -- RG

Line 609: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

605:
606: -- Logging Infra: Procedure level
607: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
608: l_log_msg := l_procedure_name||'(+)';
609: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
610: END IF;
611: -- Logging Infra: Procedure level
612:
613: -- Logging Infra: Statement level

Line 626: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

622: l_log_msg := l_log_msg||'v_prev_vendor_id: '||v_prev_vendor_id;
623: l_log_msg := l_log_msg||'v_prev_bank_account_num: '||v_prev_bank_account_num;
624: l_log_msg := l_log_msg||'v_prev_pay_document_name: '||v_prev_pay_document_name;
625: l_log_msg := l_log_msg||'v_prev_check_number: '||v_prev_check_number;
626: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
627: END IF;
628: -- Logging Infra: Statement level
629:
630:

Line 641: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

637:
638: -- Logging Infra: Procedure level
639: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
640: l_log_msg := l_procedure_name||'+TRUE+(-)';
641: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
642: END IF;
643: -- Logging Infra: Procedure level
644:
645: RETURN(TRUE) ;

Line 651: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

647:
648: -- Logging Infra: Procedure level
649: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
650: l_log_msg := l_procedure_name||'+FALSE+(-)';
651: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
652: END IF;
653: -- Logging Infra: Procedure level
654:
655: RETURN(FALSE) ;

Line 674: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

670: v_org_id NUMBER; -- bug11792095 */
671:
672: -- Logging Infra
673: l_procedure_name CONSTANT VARCHAR2(30) := 'GEN_CERTIFICATE_NUMBER';
674: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
675: -- Logging Infra
676:
677: BEGIN
678:

Line 683: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

679:
680: -- Logging Infra: Procedure level
681: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
682: l_log_msg := l_procedure_name||'(+)';
683: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
684: END IF;
685: -- Logging Infra: Procedure level
686:
687:

Line 693: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

689: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
690: l_log_msg := 'Parameters ';
691: l_log_msg := l_log_msg||'P_awt_type_code: '||p_awt_type_code;
692: l_log_msg := l_log_msg||'IN p_next_certificate_number: '||p_next_certificate_number;
693: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
694: END IF;
695: -- Logging Infra: Statement level
696:
697: -- bug11792095:Added variable v_org_id and it is used in query below

Line 701: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'x_org_id = '||x_org_id); --bug 14798548

697: -- bug11792095:Added variable v_org_id and it is used in query below
698: --bug 14798548 v_org_id := MO_GLOBAL.get_current_org_id;
699:
700: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
701: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'x_org_id = '||x_org_id); --bug 14798548
702: END IF;
703:
704:
705:

Line 728: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

724:
725: -- Logging Infra: Statement level
726: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
727: l_log_msg := 'OUT P_next_certificate_number = '||p_next_certificate_number;
728: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
729: END IF;
730: -- Logging Infra: Statement level
731:
732:

Line 736: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

732:
733: -- Logging Infra: Procedure level
734: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
735: l_log_msg := l_procedure_name||'(-)';
736: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
737: END IF;
738: -- Logging Infra: Procedure level
739:
740:

Line 751: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

747: p_next_certificate_number := 1;
748:
749: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
750: l_log_msg := 'EXCEPTION: P_next_certificate_number = 1';
751: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
752: END IF;
753:
754: RETURN (TRUE);
755:

Line 762: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

758: p_errmsg := p_errmsg||' - Error in GEN_CERTIFICATE_NUMBER';
759:
760: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
761: l_log_msg := 'EXCEPTION: '||p_errmsg;
762: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
763: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, ':EXOUT P_next_certificate_number = '||p_next_certificate_number);
764: END IF;
765:
766:

Line 763: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, ':EXOUT P_next_certificate_number = '||p_next_certificate_number);

759:
760: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
761: l_log_msg := 'EXCEPTION: '||p_errmsg;
762: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
763: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, ':EXOUT P_next_certificate_number = '||p_next_certificate_number);
764: END IF;
765:
766:
767: RETURN(FALSE);

Line 786: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

782: v_amount NUMBER;
783:
784: -- Logging Infra
785: l_procedure_name CONSTANT VARCHAR2(30) := 'CALCULATE_CREDIT_AMOUNT';
786: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
787: -- Logging Infra
788:
789: BEGIN
790:

Line 794: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

790:
791: -- Logging Infra: Procedure level
792: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
793: l_log_msg := l_procedure_name||'(+)';
794: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
795: END IF;
796: -- Logging Infra: Procedure level
797:
798:

Line 809: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

805: l_log_msg := 'Parameters ';
806: l_log_msg := l_log_msg||'v_vendor_id: '||v_vendor_id;
807: l_log_msg := l_log_msg||'v_awt_type_code: '||v_awt_type_code;
808: l_log_msg := l_log_msg||'v_tax_name: '||v_tax_name;
809: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
810: END IF;
811: -- Logging Infra: Statement level
812:
813:

Line 835: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

831:
832: -- Logging Infra: Statement level
833: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
834: l_log_msg := 'v_credit_amount = '||v_credit_amount;
835: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
836: END IF;
837: -- Logging Infra: Statement level
838:
839: -- Logging Infra: Procedure level

Line 842: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

838:
839: -- Logging Infra: Procedure level
840: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
841: l_log_msg := l_procedure_name||'(-)';
842: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
843: END IF;
844: -- Logging Infra: Procedure level
845:
846: RETURN (TRUE);

Line 855: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

851: WHEN NO_DATA_FOUND THEN
852:
853: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
854: l_log_msg := 'EXCEPTION: No data found - returning TRUE ';
855: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
856: END IF;
857:
858: RETURN (TRUE);
859:

Line 866: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

862: p_errmsg := p_errmsg||' - Error in GEN_CERTIFICATE_NUMBER';
863:
864: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
865: l_log_msg := 'EXCEPTION: '||p_errmsg;
866: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
867: END IF;
868:
869: RETURN(FALSE);
870: END;

Line 910: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

906:
907: -- Logging Infra: Procedure level
908: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
909: l_log_msg := l_procedure_name||'(+)';
910: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
911: END IF;
912: -- Logging Infra: Procedure level
913:
914:

Line 919: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

915: -- Logging Infra: Statement level
916: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
917: l_log_msg := 'Parameters ';
918: l_log_msg := l_log_msg||'P_payment_instruction_id:'||p_payment_instruction_id;
919: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
920: END IF;
921: -- Logging Infra: Statement level
922:
923:

Line 937: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

933:
934: -- Logging Infra: Statement level
935: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
936: l_log_msg := 'v_location_id:'||v_location_id;
937: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
938: END IF;
939: -- Logging Infra: Statement level
940:
941: -- l_debug_info := 'Selecting Certificates ...';

Line 949: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

945:
946: -- Logging Infra: Statement level
947: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
948: l_log_msg := 'Selecting Certificates...';
949: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
950: END IF;
951: -- Logging Infra: Statement level
952:
953:

Line 966: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

962: -- Logging Infra: Statement level
963: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
964: l_log_msg := 'Selected Certificate Check: '||rec_batch.check_number;
965: l_log_msg := l_log_msg||' Type: '||rec_batch.awt_type_code;
966: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
967: END IF;
968: -- Logging Infra: Statement level
969:
970: -- l_debug_info := 'Selected Certificate Check:' ||

Line 1004: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1000: -- Logging Infra: Statement level
1001: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1002: l_log_msg := 'Parameters ';
1003: l_log_msg := l_log_msg||'v_total_tba: '||v_total_tba;
1004: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1005: END IF;
1006: -- Logging Infra: Statement level
1007:
1008:

Line 1016: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1012: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1013: l_log_msg := 'Parameters ';
1014: l_log_msg := l_log_msg||'v_prev_tax_name: '||v_prev_tax_name;
1015: l_log_msg := l_log_msg||'v_prev_vendor_id: '||v_prev_vendor_id;
1016: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1017: END IF;
1018: -- Logging Infra: Statement level
1019:
1020: IF (v_prev_tax_name IS NOT NULL)

Line 1087: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1083: -- Logging Infra: Statement level
1084: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1085: l_log_msg := 'Parameters ';
1086: l_log_msg := l_log_msg||'rec_batch.base_withholding_amount: '||rec_batch.base_withholding_amount;
1087: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1088: END IF;
1089: -- Logging Infra: Statement level
1090:
1091: IF rec_batch.base_withholding_amount is null

Line 1101: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1097:
1098: -- Logging Infra: Statement level
1099: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1100: l_log_msg := 'v_total_wh_amount = '||v_total_wh_amount;
1101: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1102: END IF;
1103: -- Logging Infra: Statement level
1104:
1105: END IF;

Line 1118: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1114:
1115: -- Logging Infra: Statement level
1116: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1117: l_log_msg := 'Inserting last line... ';
1118: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1119: END IF;
1120: -- Logging Infra: Statement level
1121:
1122: IF (v_prev_tax_name IS NOT NULL)

Line 1169: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

1165:
1166: -- Logging Infra: Procedure level
1167: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1168: l_log_msg := l_procedure_name||'+Certificates generated+(-)';
1169: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
1170: END IF;
1171: -- Logging Infra: Procedure level
1172:
1173: RETURN(TRUE);

Line 1180: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

1176:
1177: -- Logging Infra: Procedure level
1178: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1179: l_log_msg := l_procedure_name||'+Certificates NOT generated+(-)';
1180: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
1181: END IF;
1182: -- Logging Infra: Procedure level
1183:
1184: RETURN(TRUE);

Line 1193: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

1189:
1190: -- Logging Infra: Procedure level
1191: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1192: l_log_msg := l_procedure_name||'+Parameter is NULL+Return FALSE+(-)';
1193: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
1194: END IF;
1195: -- Logging Infra: Procedure level
1196:
1197: RETURN(FALSE);

Line 1206: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1202: WHEN NO_DATA_FOUND THEN
1203:
1204: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1205: l_log_msg := 'EXCEPTION: No data found - returning TRUE.';
1206: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1207: END IF;
1208:
1209: RETURN(TRUE);
1210: WHEN OTHERS THEN

Line 1223: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1219: -- end debug
1220:
1221: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1222: l_log_msg := 'EXCEPTION: '||p_errmsg;
1223: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1224: END IF;
1225:
1226: RETURN(FALSE);
1227: