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

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

71: -- Global exception
72: G_abort_it EXCEPTION;
73:
74: -- debug variables
75: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
76: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
77: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
78: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
79: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

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

72: G_abort_it EXCEPTION;
73:
74: -- debug variables
75: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
76: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
77: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
78: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
79: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
80: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

73:
74: -- debug variables
75: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
76: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
77: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
78: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
79: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
80: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
81: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

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

74: -- debug variables
75: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
76: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
77: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
78: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
79: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
80: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
81: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
82: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_RECONCILIATION_PKG.';

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

75: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
76: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
77: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
78: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
79: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
80: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
81: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
82: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_RECONCILIATION_PKG.';
83:

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

76: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
77: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
78: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
79: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
80: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
81: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
82: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_RECONCILIATION_PKG.';
83:
84: /* *************************************************************************

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

77: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
78: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
79: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
80: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
81: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
82: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_RECONCILIATION_PKG.';
83:
84: /* *************************************************************************
85: * RECON_PAYMENT_HISTORY : Reconciliation API to clear or reconcile a *

Line 135: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

131: -- Check if all required data is passed
132: ----------------------------------------------------------------
133: l_debug_info := 'Check for required info';
134: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
135: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
136: END IF;
137: ---------------------------------------------------------------
138:
139: IF ( ( X_TRANSACTION_AMOUNT IS NULL ) or

Line 162: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

158: 'PAYMENT MATURITY REVERSAL' ) THEN
159: -----------------------------------------------------------------
160: l_debug_info := 'Payment Maturity';
161: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
162: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
163: END IF;
164: ---------------------------------------------------------------
165:
166: AP_RECONCILIATION_PKG.Recon_Payment_Maturity

Line 190: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

186: ELSIF X_TRANSACTION_TYPE IN ('PAYMENT CLEARING' ) THEN
187: -------------------------------------------------------------------
188: l_debug_info := 'Payment Clearing';
189: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
190: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
191: END IF;
192: ---------------------------------------------------------------
193: AP_RECONCILIATION_PKG.Recon_Payment_Clearing
194: ( X_CHECKRUN_ID,

Line 223: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

219: ELSIF X_TRANSACTION_TYPE IN ('PAYMENT UNCLEARING' ) THEN
220: --------------------------------------------------------------
221: l_debug_info := 'Payment Unclearing';
222: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
223: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
224: END IF;
225: ---------------------------------------------------------------
226: AP_RECONCILIATION_PKG.Recon_Payment_Unclearing
227: ( X_CHECKRUN_ID,

Line 327: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

323: -- bug 4578865
324: -------------------------------------------------------------------
325: l_debug_info := 'Inside Recon Payment Maturity, getting base curr';
326: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
327: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
328: END IF;
329: ---------------------------------------------------------------
330: SELECT asp.base_currency_code,
331: asp.org_id

Line 348: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

344: X_Exchange_Rate IS NULL) THEN
345: -------------------------------------------------------------------
346: l_debug_info := 'Defaulting Exchange Rate values from Check';
347: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
348: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
349: END IF;
350: ---------------------------------------------------------------
351: SELECT exchange_rate,
352: exchange_date,

Line 367: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

363:
364: ---------------------------------------------------------------
365: l_debug_info := 'Call rounding function';
366: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
367: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
368: END IF;
369: ---------------------------------------------------------------
370: /* Start bug 12555714 - trx_base_amount should be NULL if exchange rate is null
371: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (

Line 383: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

379: /* End bug 12555714 */
380: ------------------------------------------------------------
381: l_debug_info := 'Insert Payment History';
382: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
383: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
384: END IF;
385: ---------------------------------------------------------------
386:
387: AP_RECONCILIATION_PKG.Insert_Payment_History

Line 461: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

457: 'AP_RECONCILIATION_PKG.DELETE_PAYMENT_MATURITY' ;
458: ----------------------------------------------------------------
459: l_debug_info := 'Deleting from Payment History table';
460: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
461: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
462: END IF;
463: ---------------------------------------------------------------
464:
465: DELETE FROM AP_PAYMENT_HISTORY

Line 631: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

627:
628: ---------------------------------------------------------------
629: l_debug_info := ' Inside checkrun is not null';
630: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
631: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
632: END IF;
633: ---------------------------------------------------------------
634: -- Bug 5674397 Moving at the begining
635: SELECT count(check_id), sum(amount) , max(amount)

Line 654: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

650: FETCH distinct_org_cur INTO l_distinct_org;
651: ---------------------------------------------------------------
652: l_debug_info := 'Inside distinct_org_cur cursor';
653: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
654: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
655: END IF;
656: ---------------------------------------------------------------
657:
658: IF distinct_org_cur%NOTFOUND THEN

Line 687: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

683:
684: -----------------------------------------------------------------
685: l_debug_info := 'Inside pay_batch_cur cursor';
686: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
687: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
688: END IF;
689: ---------------------------------------------------------------
690: IF pay_batch_cur%NOTFOUND THEN
691: IF pay_batch_cur%ROWCOUNT < 1 THEN

Line 720: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

716: */
717: ---------------------------------------------------------------
718: l_debug_info := 'Got payment currency and other system options, calling case_type';
719: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
720: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
721: END IF;
722: ---------------------------------------------------------------
723:
724: l_currency_case := Case_Type(

Line 757: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

753: IF (l_currency_case = 'INTERNATIONAL') THEN
754: -----------------------------------------------------------------
755: l_debug_info := 'Inside International';
756: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
757: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
758: END IF;
759: ---------------------------------------------------------------
760: l_remainder_errors_pmt_amt := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
761: l_errors_bank_amount / nvl(l_pmt_to_base_xrate,1), --bug8628166

Line 777: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

773: ELSIF (l_currency_case = 'FOREIGN') THEN
774: ---------------------------------------------------------
775: l_debug_info := 'Inside Foreign';
776: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
777: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
778: END IF;
779: ---------------------------------------------------------
780: l_remainder_errors_pmt_amt := l_errors_bank_amount;
781: l_remainder_charges_pmt_amt := l_charges_bank_amount;

Line 790: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

786: ELSIF (l_currency_case = 'DOMESTIC') THEN
787: -------------------------------------------------------
788: l_debug_info := 'Inside Domestic';
789: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
790: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
791: END IF;
792: ---------------------------------------------------------------
793: l_remainder_errors_pmt_amt := l_errors_bank_amount;
794: l_remainder_charges_pmt_amt := l_charges_bank_amount;

Line 810: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

806: -- Check if batch contains a future pmt check which has not matured
807: -----------------------------------------------------------------------
808: l_debug_info := 'Check for future pmt checks, that are not matured';
809: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
810: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
811: END IF;
812: ------------------------------------------------------------------------
813:
814: -- We cannot clear an already cleared check

Line 825: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

821: IF (l_pay_sum_amt = 0) THEN
822: -----------------------------------------------------------------
823: l_debug_info := 'Inside l_pay_sum_amt is 0';
824: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
825: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
826: END IF;
827: ---------------------------------------------------------------
828:
829: l_ind_errors_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (

Line 840: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

836: ELSIF (l_running_total_payments = l_pay_sum_amt) THEN
837: ---------------------------------------------------------------
838: l_debug_info := 'Inside l_pay_sum_amt is running total';
839: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
840: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
841: END IF;
842: ---------------------------------------------------------------
843: l_ind_errors_pmt_amount := l_remainder_errors_pmt_amt;
844: l_ind_charges_pmt_amount := l_remainder_charges_pmt_amt;

Line 850: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

846: ELSE
847: --------------------------------------------------------------
848: l_debug_info := 'Inside l_pay_sum_amt is another value';
849: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
850: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
851: END IF;
852: ---------------------------------------------------------------
853: l_ind_errors_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
854: l_errors_pmt_amount*l_check_amount

Line 888: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

884: --Bug 8578716 Ends
885: -------------------------------------------------------------------------------
886:
887: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
888: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
889: 'Matched_flag ->'||X_MATCHED_FLAG);
890: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
891: 'status_lookup_code '||l_status_lookup_code);
892: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 890: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

886:
887: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
888: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
889: 'Matched_flag ->'||X_MATCHED_FLAG);
890: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
891: 'status_lookup_code '||l_status_lookup_code);
892: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
893: 'status_code'||l_status_code);
894: end if ;

Line 892: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

888: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
889: 'Matched_flag ->'||X_MATCHED_FLAG);
890: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
891: 'status_lookup_code '||l_status_lookup_code);
892: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
893: 'status_code'||l_status_code);
894: end if ;
895:
896: ------------------------------------------------------------------------------

Line 901: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

897: -- Only insert into payment history if reconciliation accounting is ON.
898: -----------------------------------------------------------------
899: l_debug_info := 'Set l_status_code';
900: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
901: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
902: END IF;
903: ---------------------------------------------------------------
904:
905: --bugfix:5623562

Line 915: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

911: IF (l_running_total_payments = l_pay_sum_amt) THEN
912: ----------------------------------------------------------------
913: l_debug_info := 'Inside Negotiable, International amounts equal';
914: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
915: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
916: END IF;
917: ---------------------------------------------------------------
918:
919: l_trx_base_amount := X_TRX_BANK_AMOUNT - l_runtotal_trx_bank_amount;

Line 928: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

924: ELSE
925: -------------------------------------------------------------------
926: l_debug_info := 'Inside Negotiable, International amounts not eq';
927: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
928: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
929: END IF;
930: ---------------------------------------------------------------
931:
932: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

Line 958: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

954: -- Commenting condition for bug 2626686 as accounting is now created correctly
955: --------------------------------------------------------------------
956: l_debug_info := 'Inside International, Negotiable, before insert';
957: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
958: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
959: END IF;
960: ---------------------------------------------------------------
961:
962: AP_RECONCILIATION_PKG.Insert_Payment_History

Line 1004: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1000: ELSIF (l_currency_case = 'FOREIGN') THEN
1001: -----------------------------------------------------------------
1002: l_debug_info := 'Inside Negotiable, Foreign';
1003: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1004: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1005: END IF;
1006: ---------------------------------------------------------------
1007:
1008: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

Line 1026: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1022: -- Commenting condition for bug 2626686 as accounting is now created correctly
1023: ------------------------------------------------------------------
1024: l_debug_info := 'Insert history for Negotiable, Foreign';
1025: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1026: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1027: END IF;
1028: ---------------------------------------------------------------
1029: AP_RECONCILIATION_PKG.Insert_Payment_History
1030: ( X_CHECK_ID => l_check_id,

Line 1083: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1079: -- Commenting condition for bug 2626686 as accounting is now created correctly
1080: ----------------------------------------------------------------
1081: l_debug_info := 'Inside Negotiable, Domestic, before Insert';
1082: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1083: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1084: END IF;
1085: ---------------------------------------------------------------
1086:
1087: AP_RECONCILIATION_PKG.Insert_Payment_History

Line 1140: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1136: ELSIF (l_recon_accounting_flag <> 'Y') THEN
1137: ----------------------------------------------------------------
1138: l_debug_info := 'Inside recon flag not Y';
1139: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1140: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1141: END IF;
1142: ---------------------------------------------------------------
1143: -- Bug 4538437 : Following IF condition is added so that base amounts
1144: -- are populated even if recon_accounting_flag = 'N'

Line 1222: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1218: -- of reconciliation accouting is on or OFF
1219: -----------------------------------------------------------------
1220: l_debug_info := 'Before recon_update_check call';
1221: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1222: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1223: END IF;
1224: ---------------------------------------------------------------
1225: -----------------------------------------------------------------
1226: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1227: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

1223: END IF;
1224: ---------------------------------------------------------------
1225: -----------------------------------------------------------------
1226: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1227: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1228: 'check_id ->'||l_check_id);
1229: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1230: 'cleared_date -> '||X_CLEARED_DATE);
1231: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 1229: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

1225: -----------------------------------------------------------------
1226: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1227: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1228: 'check_id ->'||l_check_id);
1229: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1230: 'cleared_date -> '||X_CLEARED_DATE);
1231: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1232: 'status_code ->'||l_status_code);
1233: end if ;

Line 1231: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

1227: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1228: 'check_id ->'||l_check_id);
1229: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1230: 'cleared_date -> '||X_CLEARED_DATE);
1231: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1232: 'status_code ->'||l_status_code);
1233: end if ;
1234: -----------------------------------------------------------------
1235: IF NOT (Recon_Update_Check(l_check_id,

Line 1267: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1263: ELSE /* checkrun_id is null....... */
1264: ---------------------------------------------------------------------
1265: l_debug_info := 'Inside checkrun is null';
1266: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1267: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1268: END IF;
1269: ---------------------------------------------------------------
1270: -- Single Payment
1271: -- Select to retrieve check information

Line 1312: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1308: END IF ;
1309: --------------------------------------------------------
1310: l_debug_info := 'checkrun is null, calling case_type';
1311: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1312: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1313: END IF;
1314: ---------------------------------------------------------------
1315: l_currency_case := Case_Type(
1316: X_BANK_CURRENCY_CODE,

Line 1362: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1358: ELSIF (l_currency_case = 'FOREIGN') THEN
1359: -----------------------------------------------------------
1360: l_debug_info := 'checkrun is null, inside Foreign';
1361: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1362: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1363: END IF;
1364: ---------------------------------------------------------------
1365:
1366: l_ind_errors_pmt_amount := l_errors_bank_amount;

Line 1376: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1372: ELSIF (l_currency_case = 'DOMESTIC') THEN
1373: --------------------------------------------------------------
1374: l_debug_info := 'checkrun is null, inside Domestic';
1375: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1376: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1377: END IF;
1378: ---------------------------------------------------------------
1379: l_ind_errors_pmt_amount := l_errors_bank_amount;
1380: l_ind_charges_pmt_amount := l_charges_bank_amount;

Line 1412: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

1408:
1409: -------------------------------------------------------------------------------
1410:
1411: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1412: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1413: 'Matched_flag ->'||X_MATCHED_FLAG);
1414: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1415: 'status_lookup_code '||l_status_lookup_code);
1416: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 1414: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

1410:
1411: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1412: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1413: 'Matched_flag ->'||X_MATCHED_FLAG);
1414: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1415: 'status_lookup_code '||l_status_lookup_code);
1416: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1417: 'status_code'||l_status_code);
1418: end if ;

Line 1416: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

1412: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1413: 'Matched_flag ->'||X_MATCHED_FLAG);
1414: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1415: 'status_lookup_code '||l_status_lookup_code);
1416: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1417: 'status_code'||l_status_code);
1418: end if ;
1419:
1420: ------------------------------------------------------------------------------

Line 1440: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1436: -- Commenting condition for bug 2626686 as accounting is now created correctly
1437: ---------------------------------------------------------------
1438: l_debug_info := 'Negotiable, International, before Insert';
1439: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1440: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1441: END IF;
1442: ---------------------------------------------------------------
1443: AP_RECONCILIATION_PKG.Insert_Payment_History
1444: ( X_CHECK_ID => X_check_id,

Line 1502: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1498: -- Commenting condition for bug 2626686 as accounting is now created correctly
1499: ---------------------------------------------------------------
1500: l_debug_info := 'Negotiable, Foreign, before Insert';
1501: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1502: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1503: END IF;
1504: ---------------------------------------------------------------
1505:
1506: AP_RECONCILIATION_PKG.Insert_Payment_History

Line 1560: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1556: -- Commenting condition for bug 2626686 as accounting is now created correctly
1557: -------------------------------------------------------------
1558: l_debug_info := 'Negotiable, Domestic, before Insert';
1559: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1560: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1561: END IF;
1562: ---------------------------------------------------------------
1563:
1564: AP_RECONCILIATION_PKG.Insert_Payment_History

Line 1663: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1659: -- of reconciliation accouting is on or OFF
1660: -------------------------------------------------------
1661: l_debug_info := 'Before recon_update_check call';
1662: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1663: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1664: END IF;
1665: ---------------------------------------------------------------
1666: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1667: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 1667: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

1663: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1664: END IF;
1665: ---------------------------------------------------------------
1666: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1667: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1668: 'check_id ->'||X_check_id);
1669: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1670: 'cleared_date -> '||X_CLEARED_DATE);
1671: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 1669: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

1665: ---------------------------------------------------------------
1666: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1667: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1668: 'check_id ->'||X_check_id);
1669: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1670: 'cleared_date -> '||X_CLEARED_DATE);
1671: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1672: 'status_code ->'||l_status_code);
1673: end if ;

Line 1671: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

1667: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1668: 'check_id ->'||X_check_id);
1669: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1670: 'cleared_date -> '||X_CLEARED_DATE);
1671: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1672: 'status_code ->'||l_status_code);
1673: end if ;
1674: ---------------------------------------------------------------
1675:

Line 1879: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1875: FETCH distinct_org_cur INTO l_distinct_org;
1876: ----------------------------------------------------------------
1877: l_debug_info := 'Inside distinct_org_cur cursor';
1878: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1879: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1880: END IF;
1881: ---------------------------------------------------------------
1882:
1883: IF distinct_org_cur%NOTFOUND THEN

Line 1935: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1931: END IF;
1932: -----------------------------------------------------------------------
1933: l_debug_info := 'Inside recon_payment_unclearing, before insert';
1934: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1935: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1936: END IF;
1937: ---------------------------------------------------------------
1938:
1939:

Line 2007: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2003: -- Select to retrieve check information
2004: ------------------------------------------------------------
2005: l_debug_info := 'checkrun is null, before select';
2006: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2007: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2008: END IF;
2009: ---------------------------------------------------------------
2010:
2011:

Line 2035: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2031: IF (l_dummy>0 ) THEN
2032: ---------------------------------------------------------------------
2033: l_debug_info := 'checkrun is null, recon flag is Y, before select';
2034: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2035: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2036: END IF;
2037: ---------------------------------------------------------------
2038:
2039:

Line 2238: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2234: IF x_accounting_event_id is null THEN
2235: ---------------------------------------------------------------------
2236: l_debug_info := 'Call AP_ACCOUNTING_EVENTS_PKG.CREATE_EVENTS';
2237: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2238: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2239: END IF;
2240: ---------------------------------------------------------------
2241:
2242: -- bug 4578865

Line 2334: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2330: -- Insert payment information into payment history table
2331: ----------------------------------------------------------------
2332: l_debug_info := 'Inserting into AP_Payment_History';
2333: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2334: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2335: END IF;
2336: ---------------------------------------------------------------
2337:
2338: INSERT INTO AP_PAYMENT_HISTORY_ALL

Line 2482: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2478: IF (CC_CHECKRUN_ID IS NOT NULL AND CC_CHECK_ID IS NULL) THEN
2479: ------------------------------------------------------------------------------
2480: l_debug_info := 'cc_checkrun_id not null and cc_check_id null, before Update';
2481: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2482: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2483: END IF;
2484: ---------------------------------------------------------------
2485:
2486: UPDATE ap_checks

Line 2512: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2508: ELSE
2509: ----------------------------------------------------------------------------------------
2510: l_debug_info := 'cc_checkrun_id null or cc_check_id not null, before Update ap_checks';
2511: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2512: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2513: END IF;
2514: ---------------------------------------------------------------
2515:
2516: UPDATE ap_checks

Line 2596: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2592: DUAL;
2593: --------------------------------------------------------------
2594: l_debug_info := ' inside Recon_Update_Check, Before Update';
2595: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2596: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2597: END IF;
2598: ---------------------------------------------------------------
2599: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2600: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 2600: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2596: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2597: END IF;
2598: ---------------------------------------------------------------
2599: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2600: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2601: 'check_id ->'||RU_CHECK_ID);
2602: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2603: 'cleared_date '||RU_CLEARED_DATE);
2604: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 2602: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2598: ---------------------------------------------------------------
2599: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2600: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2601: 'check_id ->'||RU_CHECK_ID);
2602: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2603: 'cleared_date '||RU_CLEARED_DATE);
2604: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2605: 'status_code'||RU_CHECK_STATUS);
2606: end if ;

Line 2604: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2600: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2601: 'check_id ->'||RU_CHECK_ID);
2602: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2603: 'cleared_date '||RU_CLEARED_DATE);
2604: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2605: 'status_code'||RU_CHECK_STATUS);
2606: end if ;
2607:
2608: ----------------------------------------------------------------