[Home] [Help]
2699: dbms_sql.close_cursor(l_cur);
2700:
2701: /* END for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL */
2702: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL ');
2703: /* Start for for je_source is Receivables , based on AR_MISC_CASH_DISTRIBUTIONS_ALL */
2704:
2705: l_string2 := ' SELECT glb.je_batch_id,
2706: ffp.fund_value,
2707: ffp.description,
2749: fv_report_definitions frd,
2750: fv_fund_parameters ffp,
2751: fv_treasury_symbols fts,
2752: ar_distributions_all ard,
2753: AR_MISC_CASH_DISTRIBUTIONS_ALL arm,
2754: gl_import_references glir,
2755: xla_ae_headers xah,
2756: xla_ae_lines xal,
2757: xla_events xet,
2810: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2811: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2812: l_row := dbms_sql.EXECUTE(l_cur);
2813: dbms_sql.close_cursor(l_cur);
2814: /* END for je_source is Receivables , based on AR_MISC_CASH_DISTRIBUTIONS_ALL */
2815: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is Receivables , based on AR_MISC_CASH_DISTRIBUTIONS_ALL ');
2816:
2817: EXCEPTION
2818: WHEN OTHERS THEN
2811: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2812: l_row := dbms_sql.EXECUTE(l_cur);
2813: dbms_sql.close_cursor(l_cur);
2814: /* END for je_source is Receivables , based on AR_MISC_CASH_DISTRIBUTIONS_ALL */
2815: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is Receivables , based on AR_MISC_CASH_DISTRIBUTIONS_ALL ');
2816:
2817: EXCEPTION
2818: WHEN OTHERS THEN
2819: p_error_code := sqlcode;
3438: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3439: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FOR MISC RECEIPT: '||
3440: 'Cash Receipt Hist Id does not '||
3441: 'exist in Ar_Cash_Receipt_History_All table.'||
3442: 'Checking in Ar_Misc_Cash_Distributions_All table.');
3443: END IF;
3444: l_exists := 'M';
3445: ELSE
3446: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3503: ELSIF ((l_je_category = 'Misc Receipts') AND (l_exists = 'M')) THEN
3504: BEGIN
3505: SELECT 'Y'
3506: INTO l_exists
3507: FROM Ar_Misc_Cash_Distributions_All
3508: WHERE misc_cash_distribution_id = TO_NUMBER(l_cash_receipt_hist_id)
3509: AND cash_receipt_id = TO_NUMBER(l_cash_receipt_id);
3510: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3511: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'MISC CASH DISTRIBUTION ID EXISTS IN '||
3508: WHERE misc_cash_distribution_id = TO_NUMBER(l_cash_receipt_hist_id)
3509: AND cash_receipt_id = TO_NUMBER(l_cash_receipt_id);
3510: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3511: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'MISC CASH DISTRIBUTION ID EXISTS IN '||
3512: 'Ar_Misc_Cash_Distributions_All table and is '|| TO_NUMBER(l_cash_receipt_hist_id));
3513: END IF;
3514: vl_misc_cd_flag := 'Y';
3515: EXCEPTION
3516: WHEN NO_DATA_FOUND THEN
3614: IF ((l_je_category = 'Misc Receipts') AND (vl_misc_cd_flag = 'Y')) THEN -- rev check
3615: BEGIN
3616: SELECT 'Y'
3617: INTO l_exists
3618: FROM Ar_Misc_Cash_Distributions_All
3619: WHERE misc_cash_distribution_id = l_cash_receipt_hist_id
3620: AND cash_receipt_id = l_cash_receipt_id
3621: AND created_from = 'ARP_REVERSE_RECEIPT.REVERSE';
3622: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4577: l_exists := 'M';
4578: END;
4579: IF(l_exists = 'M') AND (l_je_category = 'Misc Receipts') THEN
4580: BEGIN
4581: sql_stmt:='SELECT ''Y'' FROM AR_CASH_RECEIPTS_ALL ac, Ar_Misc_Cash_Distributions_All ah
4582: where ac.cash_receipt_id = ah.cash_receipt_id
4583: and ah.misc_cash_distribution_id = '|| l_cash_receipt_hist_id ||
4584: ' and ah.cash_receipt_id = '||l_cash_receipt_id||
4585: ' and ah.created_from= ''ARP_REVERSE_RECEIPT.REVERSE'' '||