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.JA_CN_CFS_CLT_SLA_PKG dependencies on FND_FILE

Line 96: FND_FILE.Put_Line(FND_FILE.Output, p_str);

92: -- 23/04/2007 Shujuan Yan Created
93: --===========================================================================
94: PROCEDURE put_line(p_str IN VARCHAR2) AS
95: BEGIN
96: FND_FILE.Put_Line(FND_FILE.Output, p_str);
97: END put_line;
98: --==========================================================================
99: -- FUNCTION NAME:
100: -- get_period_name Public

Line 298: FND_FILE.Put_Line(FND_FILE.log, 'p_cash_ae_header_id = ' || p_cash_ae_header_id || '===p_ccid=' || p_ccid || '===l_status=' || l_status);

294: WHEN NO_DATA_FOUND THEN
295: l_status :='';
296: END;
297: END IF;
298: FND_FILE.Put_Line(FND_FILE.log, 'p_cash_ae_header_id = ' || p_cash_ae_header_id || '===p_ccid=' || p_ccid || '===l_status=' || l_status);
299:
300: -- For Uncleasing case
301: IF p_event_type_code = 'PAYMENT UNCLEARED'
302: or (p_event_type_code = 'RECP_UPDATE' and l_status = 'REMITTED')

Line 827: FND_FILE.Put_Line(FND_FILE.log, 'sql_stmt_cash 784 : --- : ' || sql_stmt_cash);

823: put_log(G_MODULE_PREFIX||l_procedure_name||'.chart of accounts id'
824: ,p_coa_id);
825: END IF; --( G_STATEMENT_LEVEL >= g_debug_devel)
826: -------------------------------
827: FND_FILE.Put_Line(FND_FILE.log, 'sql_stmt_cash 784 : --- : ' || sql_stmt_cash);
828: FND_FILE.Put_Line(FND_FILE.log, 'l_date_from = ' || l_date_from);
829: FND_FILE.Put_Line(FND_FILE.log, 'l_date_to = ' || l_date_to);
830: FND_FILE.Put_Line(FND_FILE.log, 'p_ledger_id = ' || p_ledger_id);
831: FND_FILE.Put_Line(FND_FILE.log, 'p_coa_id = ' || p_coa_id);

Line 828: FND_FILE.Put_Line(FND_FILE.log, 'l_date_from = ' || l_date_from);

824: ,p_coa_id);
825: END IF; --( G_STATEMENT_LEVEL >= g_debug_devel)
826: -------------------------------
827: FND_FILE.Put_Line(FND_FILE.log, 'sql_stmt_cash 784 : --- : ' || sql_stmt_cash);
828: FND_FILE.Put_Line(FND_FILE.log, 'l_date_from = ' || l_date_from);
829: FND_FILE.Put_Line(FND_FILE.log, 'l_date_to = ' || l_date_to);
830: FND_FILE.Put_Line(FND_FILE.log, 'p_ledger_id = ' || p_ledger_id);
831: FND_FILE.Put_Line(FND_FILE.log, 'p_coa_id = ' || p_coa_id);
832: FND_FILE.Put_Line(FND_FILE.log, 'p_le_id = ' || p_le_id);

Line 829: FND_FILE.Put_Line(FND_FILE.log, 'l_date_to = ' || l_date_to);

825: END IF; --( G_STATEMENT_LEVEL >= g_debug_devel)
826: -------------------------------
827: FND_FILE.Put_Line(FND_FILE.log, 'sql_stmt_cash 784 : --- : ' || sql_stmt_cash);
828: FND_FILE.Put_Line(FND_FILE.log, 'l_date_from = ' || l_date_from);
829: FND_FILE.Put_Line(FND_FILE.log, 'l_date_to = ' || l_date_to);
830: FND_FILE.Put_Line(FND_FILE.log, 'p_ledger_id = ' || p_ledger_id);
831: FND_FILE.Put_Line(FND_FILE.log, 'p_coa_id = ' || p_coa_id);
832: FND_FILE.Put_Line(FND_FILE.log, 'p_le_id = ' || p_le_id);
833: FND_FILE.Put_Line(FND_FILE.log, 'l_source_id = ' || l_source_id);

Line 830: FND_FILE.Put_Line(FND_FILE.log, 'p_ledger_id = ' || p_ledger_id);

826: -------------------------------
827: FND_FILE.Put_Line(FND_FILE.log, 'sql_stmt_cash 784 : --- : ' || sql_stmt_cash);
828: FND_FILE.Put_Line(FND_FILE.log, 'l_date_from = ' || l_date_from);
829: FND_FILE.Put_Line(FND_FILE.log, 'l_date_to = ' || l_date_to);
830: FND_FILE.Put_Line(FND_FILE.log, 'p_ledger_id = ' || p_ledger_id);
831: FND_FILE.Put_Line(FND_FILE.log, 'p_coa_id = ' || p_coa_id);
832: FND_FILE.Put_Line(FND_FILE.log, 'p_le_id = ' || p_le_id);
833: FND_FILE.Put_Line(FND_FILE.log, 'l_source_id = ' || l_source_id);
834: ------------------------------

Line 831: FND_FILE.Put_Line(FND_FILE.log, 'p_coa_id = ' || p_coa_id);

827: FND_FILE.Put_Line(FND_FILE.log, 'sql_stmt_cash 784 : --- : ' || sql_stmt_cash);
828: FND_FILE.Put_Line(FND_FILE.log, 'l_date_from = ' || l_date_from);
829: FND_FILE.Put_Line(FND_FILE.log, 'l_date_to = ' || l_date_to);
830: FND_FILE.Put_Line(FND_FILE.log, 'p_ledger_id = ' || p_ledger_id);
831: FND_FILE.Put_Line(FND_FILE.log, 'p_coa_id = ' || p_coa_id);
832: FND_FILE.Put_Line(FND_FILE.log, 'p_le_id = ' || p_le_id);
833: FND_FILE.Put_Line(FND_FILE.log, 'l_source_id = ' || l_source_id);
834: ------------------------------
835: OPEN c_cash_lines FOR sql_stmt_cash

Line 832: FND_FILE.Put_Line(FND_FILE.log, 'p_le_id = ' || p_le_id);

828: FND_FILE.Put_Line(FND_FILE.log, 'l_date_from = ' || l_date_from);
829: FND_FILE.Put_Line(FND_FILE.log, 'l_date_to = ' || l_date_to);
830: FND_FILE.Put_Line(FND_FILE.log, 'p_ledger_id = ' || p_ledger_id);
831: FND_FILE.Put_Line(FND_FILE.log, 'p_coa_id = ' || p_coa_id);
832: FND_FILE.Put_Line(FND_FILE.log, 'p_le_id = ' || p_le_id);
833: FND_FILE.Put_Line(FND_FILE.log, 'l_source_id = ' || l_source_id);
834: ------------------------------
835: OPEN c_cash_lines FOR sql_stmt_cash
836: using l_date_from, l_date_to, p_ledger_id, p_coa_id,

Line 833: FND_FILE.Put_Line(FND_FILE.log, 'l_source_id = ' || l_source_id);

829: FND_FILE.Put_Line(FND_FILE.log, 'l_date_to = ' || l_date_to);
830: FND_FILE.Put_Line(FND_FILE.log, 'p_ledger_id = ' || p_ledger_id);
831: FND_FILE.Put_Line(FND_FILE.log, 'p_coa_id = ' || p_coa_id);
832: FND_FILE.Put_Line(FND_FILE.log, 'p_le_id = ' || p_le_id);
833: FND_FILE.Put_Line(FND_FILE.log, 'l_source_id = ' || l_source_id);
834: ------------------------------
835: OPEN c_cash_lines FOR sql_stmt_cash
836: using l_date_from, l_date_to, p_ledger_id, p_coa_id,
837: p_coa_id,p_coa_id,p_ledger_id,p_le_id,p_coa_id,p_coa_id,l_source_id;

Line 867: FND_FILE.Put_Line(FND_FILE.log, 'sql_stmt_sla_temp 811 : --- : ' || sql_stmt_sla_temp);

863: goto a;
864: end if;
865: --Fixed bug 13498675 by shyan, End
866: -------------------------------
867: FND_FILE.Put_Line(FND_FILE.log, 'sql_stmt_sla_temp 811 : --- : ' || sql_stmt_sla_temp);
868: FND_FILE.Put_Line(FND_FILE.log, 'l_transaction_num = ' || l_transaction_num);
869: FND_FILE.Put_Line(FND_FILE.log, 'p_ledger_id = ' || p_ledger_id);
870: FND_FILE.Put_Line(FND_FILE.log, 'p_coa_id = ' || p_coa_id);
871: FND_FILE.Put_Line(FND_FILE.log, 'p_le_id = ' || p_le_id);

Line 868: FND_FILE.Put_Line(FND_FILE.log, 'l_transaction_num = ' || l_transaction_num);

864: end if;
865: --Fixed bug 13498675 by shyan, End
866: -------------------------------
867: FND_FILE.Put_Line(FND_FILE.log, 'sql_stmt_sla_temp 811 : --- : ' || sql_stmt_sla_temp);
868: FND_FILE.Put_Line(FND_FILE.log, 'l_transaction_num = ' || l_transaction_num);
869: FND_FILE.Put_Line(FND_FILE.log, 'p_ledger_id = ' || p_ledger_id);
870: FND_FILE.Put_Line(FND_FILE.log, 'p_coa_id = ' || p_coa_id);
871: FND_FILE.Put_Line(FND_FILE.log, 'p_le_id = ' || p_le_id);
872: FND_FILE.Put_Line(FND_FILE.log, 'l_source_id = ' || l_source_id);

Line 869: FND_FILE.Put_Line(FND_FILE.log, 'p_ledger_id = ' || p_ledger_id);

865: --Fixed bug 13498675 by shyan, End
866: -------------------------------
867: FND_FILE.Put_Line(FND_FILE.log, 'sql_stmt_sla_temp 811 : --- : ' || sql_stmt_sla_temp);
868: FND_FILE.Put_Line(FND_FILE.log, 'l_transaction_num = ' || l_transaction_num);
869: FND_FILE.Put_Line(FND_FILE.log, 'p_ledger_id = ' || p_ledger_id);
870: FND_FILE.Put_Line(FND_FILE.log, 'p_coa_id = ' || p_coa_id);
871: FND_FILE.Put_Line(FND_FILE.log, 'p_le_id = ' || p_le_id);
872: FND_FILE.Put_Line(FND_FILE.log, 'l_source_id = ' || l_source_id);
873: -------------------------------

Line 870: FND_FILE.Put_Line(FND_FILE.log, 'p_coa_id = ' || p_coa_id);

866: -------------------------------
867: FND_FILE.Put_Line(FND_FILE.log, 'sql_stmt_sla_temp 811 : --- : ' || sql_stmt_sla_temp);
868: FND_FILE.Put_Line(FND_FILE.log, 'l_transaction_num = ' || l_transaction_num);
869: FND_FILE.Put_Line(FND_FILE.log, 'p_ledger_id = ' || p_ledger_id);
870: FND_FILE.Put_Line(FND_FILE.log, 'p_coa_id = ' || p_coa_id);
871: FND_FILE.Put_Line(FND_FILE.log, 'p_le_id = ' || p_le_id);
872: FND_FILE.Put_Line(FND_FILE.log, 'l_source_id = ' || l_source_id);
873: -------------------------------
874:

Line 871: FND_FILE.Put_Line(FND_FILE.log, 'p_le_id = ' || p_le_id);

867: FND_FILE.Put_Line(FND_FILE.log, 'sql_stmt_sla_temp 811 : --- : ' || sql_stmt_sla_temp);
868: FND_FILE.Put_Line(FND_FILE.log, 'l_transaction_num = ' || l_transaction_num);
869: FND_FILE.Put_Line(FND_FILE.log, 'p_ledger_id = ' || p_ledger_id);
870: FND_FILE.Put_Line(FND_FILE.log, 'p_coa_id = ' || p_coa_id);
871: FND_FILE.Put_Line(FND_FILE.log, 'p_le_id = ' || p_le_id);
872: FND_FILE.Put_Line(FND_FILE.log, 'l_source_id = ' || l_source_id);
873: -------------------------------
874:
875: OPEN c_sla_lines FOR sql_stmt_sla_temp using l_transaction_num,p_ledger_id, p_coa_id,p_ledger_id,p_le_id,l_cash_app_id;

Line 872: FND_FILE.Put_Line(FND_FILE.log, 'l_source_id = ' || l_source_id);

868: FND_FILE.Put_Line(FND_FILE.log, 'l_transaction_num = ' || l_transaction_num);
869: FND_FILE.Put_Line(FND_FILE.log, 'p_ledger_id = ' || p_ledger_id);
870: FND_FILE.Put_Line(FND_FILE.log, 'p_coa_id = ' || p_coa_id);
871: FND_FILE.Put_Line(FND_FILE.log, 'p_le_id = ' || p_le_id);
872: FND_FILE.Put_Line(FND_FILE.log, 'l_source_id = ' || l_source_id);
873: -------------------------------
874:
875: OPEN c_sla_lines FOR sql_stmt_sla_temp using l_transaction_num,p_ledger_id, p_coa_id,p_ledger_id,p_le_id,l_cash_app_id;
876: LOOP