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.

[Home] [Help]

APPS.FV_SF224_TRANSACTIONS dependencies on AP_CHECKS_ALL

Line 31: g_payment_type_flag ap_checks_all.PAYMENT_TYPE_FLAG%TYPE;

27: g_enter VARCHAR2(10);
28: g_exit VARCHAR2(10);
29: g_sysdate DATE;
30:
31: g_payment_type_flag ap_checks_all.PAYMENT_TYPE_FLAG%TYPE;
32: g_check_void_date DATE;
33: g_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
34:
35: sob NUMBER;

Line 2880: l_void_check_number ap_checks_all.void_check_number%TYPE;

2876: l_gwa_reporter_category_code fv_alc_gwa_categories.gwa_reporter_category_code%TYPE;
2877: l_alc_addresses_id fv_alc_addresses_all.fv_alc_addresses_id%TYPE;
2878:
2879: --Added for reclassification changes
2880: l_void_check_number ap_checks_all.void_check_number%TYPE;
2881: l_voided_reclassified_payment VARCHAR2(1);
2882: l_reclass_receipt_number ar_cash_receipts_all.receipt_number%TYPE;
2883: l_receipt_reclassified VARCHAR2(1);
2884: l_ar_reclass_attribute VARCHAR2(15);

Line 3158: FROM ap_checks_all

3154: END IF;
3155: BEGIN
3156: SELECT checkrun_name
3157: INTO l_document_number
3158: FROM ap_checks_all
3159: WHERE check_id = TO_NUMBER(l_reference_3);
3160: EXCEPTION WHEN NO_DATA_FOUND THEN
3161:
3162: -- Added for bug 14160181

Line 3344: from ap_checks_all

3340: ELSE
3341: BEGIN
3342: select 'Y', payment_type_flag, void_date
3343: into l_exists, g_payment_type_flag, g_check_void_date
3344: from ap_checks_all
3345: Where check_id = to_number(l_REFERENCE_3) ;
3346: EXCEPTION
3347: when no_data_found then
3348: x_name := 'Invalid Check Id - ' || l_reference_3 ;

Line 3544: FROM ap_checks_all

3540: -- get the document number
3541: BEGIN
3542: SELECT checkrun_name
3543: INTO l_document_number
3544: FROM ap_checks_all
3545: WHERE check_id = to_number(l_reference_3);
3546: EXCEPTION
3547: WHEN NO_DATA_FOUND THEN
3548: SELECT SUBSTR(name,1,50)

Line 3560: from AP_CHECKS_ALL

3556: ELSE
3557: BEGIN
3558: select 'Y'
3559: into l_exists
3560: from AP_CHECKS_ALL
3561: Where check_id = to_number(l_reference_3);
3562: Exception
3563: when no_data_found then
3564: x_name := 'Invalid Check Id - ' || l_reference_3 ;

Line 3864: FROM Ap_Checks_All

3860: END IF;
3861: BEGIN
3862: SELECT ce_bank_acct_use_id
3863: INTO vg_bank_acct_id
3864: FROM Ap_Checks_All
3865: WHERE check_id = TO_NUMBER(l_reference_3);
3866: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3867: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FOUND THE BANK ACCOUNT ID');
3868: END IF;

Line 3880: 'bank_account_id from Ap_Checks_All table.';

3876: Set_Exception('D');
3877: GOTO end_label;
3878: WHEN OTHERS THEN
3879: error_buf := SQLERRM||'- Error while deriving the '||
3880: 'bank_account_id from Ap_Checks_All table.';
3881: error_code := 2;
3882: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error14', error_buf) ;
3883: RETURN;
3884: END;

Line 4005: FROM Ap_Checks_All

4001: END IF; -- ref6-2
4002: BEGIN
4003: SELECT ce_bank_acct_use_id
4004: INTO vg_bank_acct_id
4005: FROM Ap_Checks_All
4006: WHERE check_id = TO_NUMBER(l_reference_3);
4007: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4008: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FOUND THE BANK ACCOUNT ID');
4009: END IF;

Line 4017: 'bank_account_id from Ap_Checks_All table.';

4013: Set_Exception('D');
4014: GOTO end_label;
4015: WHEN OTHERS THEN
4016: error_buf := SQLERRM||'- Error while deriving the '||
4017: 'bank_account_id from Ap_Checks_All table.';
4018: error_code := 2;
4019: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error19', error_buf) ;
4020: RETURN;
4021: END;

Line 4089: FROM ap_checks_all apc,

4085: INTO l_invoice_id ,
4086: l_vendor_id,
4087: l_inv_amount,
4088: l_check_date
4089: FROM ap_checks_all apc,
4090: ap_invoices_all api
4091: WHERE api.invoice_id = NVL(l_reference, 0)
4092: AND apc.check_id = to_number(l_reference_3)
4093: AND l_payables_ia_paygroup = api.pay_group_lookup_code

Line 4119: FROM Ap_Checks_All

4115: l_error_stage := 1;
4116: BEGIN
4117: SELECT ce_bank_acct_use_id
4118: INTO vg_bank_acct_id
4119: FROM Ap_Checks_All
4120: WHERE check_id = TO_NUMBER(l_reference_3);
4121: EXCEPTION
4122: WHEN NO_DATA_FOUND THEN
4123: -- Unable to find the bank_account_id

Line 4127: 'bank_account_id from Ap_Checks_All table when '||

4123: -- Unable to find the bank_account_id
4124: Set_Exception('D');
4125: WHEN OTHERS THEN
4126: error_buf := SQLERRM||'- Error while deriving the '||
4127: 'bank_account_id from Ap_Checks_All table when '||
4128: 'category<>Trea Conf.';
4129: error_code := 2;
4130: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error24', error_buf) ;
4131: RETURN;

Line 4166: FROM ap_checks_all apc,

4162: SELECT nvl(apc.treasury_pay_date,apc.check_date),
4163: apc.void_date
4164: INTO l_accomplish_date,
4165: l_void_date
4166: FROM ap_checks_all apc,
4167: ap_invoices_all api
4168: WHERE api.invoice_id = Nvl(l_reference, 0)
4169: AND apc.check_id = nvl(l_reference_3,0);
4170: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4315: FROM ap_checks_all

4311: BEGIN
4312: -- check_id
4313: SELECT void_date
4314: INTO l_accomplish_date
4315: FROM ap_checks_all
4316: WHERE check_id = To_number (nvl(l_reference_3,'0')) ;
4317: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4318: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
4319: 'VOID DATE/ACCOMPLISH DATE IS '||

Line 4350: FROM Ap_Checks_All

4346: END ;
4347: BEGIN
4348: SELECT ce_bank_acct_use_id
4349: INTO vg_bank_acct_id
4350: FROM Ap_Checks_All
4351: WHERE check_id = TO_NUMBER(l_reference_3);
4352: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4353: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FOUND THE BANK ACCT ID');
4354: END IF;

Line 4365: 'bank_account_id from Ap_Checks_All table when name like VOID.';

4361: END IF;
4362: Set_Exception('D');
4363: WHEN OTHERS THEN
4364: error_buf := SQLERRM||'- Error while deriving the '||
4365: 'bank_account_id from Ap_Checks_All table when name like VOID.';
4366: error_code := 2;
4367: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error29', error_buf) ;
4368: RETURN;
4369: END;

Line 4525: FROM ap_checks_all apc

4521: AND l_reference_2 IS NOT NULL AND l_reference_3 IS NOT NULL AND l_reference_9 IS NOT NULL THEN
4522: BEGIN
4523: SELECT apc.void_check_number /* replace attribute1 with new field name */
4524: INTO l_void_check_number
4525: FROM ap_checks_all apc
4526: WHERE apc.check_id = to_number(l_reference_3);
4527: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4528: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Void Check Number : '|| l_void_check_number );
4529: END IF;

Line 5604: ap_checks_all apc,

5600: FROM po_distributions
5601: WHERE po_distribution_id = apid.po_distribution_id)))
5602: obligation_number
5603: FROM
5604: ap_checks_all apc,
5605: ap_invoice_payments_all apip,
5606: ap_invoices_all api,
5607: ap_invoice_distributions_all apid
5608: WHERE apip.set_of_books_id = l_set_of_books_id