DBA Data[Home] [Help]

APPS.JG_ZZ_AERL_DT_PKG dependencies on FND_FILE

Line 56: fnd_file.put_line(fnd_file.log, '**Input Params:** ');

52: lv_fin_doc_type varchar2(20);
53: lv_sl_trx_type ce_statement_lines.trx_type%type;
54: lv_cr_reversal_category ar_cash_receipts_all.reversal_category%type;
55: begin
56: fnd_file.put_line(fnd_file.log, '**Input Params:** ');
57: fnd_file.put_line(fnd_file.log, '1. Trx_id: '||pn_trx_id);
58: fnd_file.put_line(fnd_file.log, '2. Trx_type_id: '||pn_trx_type_id);
59: fnd_file.put_line(fnd_file.log, '3. Source: '||pv_source);
60: fnd_file.put_line(fnd_file.log, '4. Entity Code '||pv_entity_code);

Line 57: fnd_file.put_line(fnd_file.log, '1. Trx_id: '||pn_trx_id);

53: lv_sl_trx_type ce_statement_lines.trx_type%type;
54: lv_cr_reversal_category ar_cash_receipts_all.reversal_category%type;
55: begin
56: fnd_file.put_line(fnd_file.log, '**Input Params:** ');
57: fnd_file.put_line(fnd_file.log, '1. Trx_id: '||pn_trx_id);
58: fnd_file.put_line(fnd_file.log, '2. Trx_type_id: '||pn_trx_type_id);
59: fnd_file.put_line(fnd_file.log, '3. Source: '||pv_source);
60: fnd_file.put_line(fnd_file.log, '4. Entity Code '||pv_entity_code);
61: begin

Line 58: fnd_file.put_line(fnd_file.log, '2. Trx_type_id: '||pn_trx_type_id);

54: lv_cr_reversal_category ar_cash_receipts_all.reversal_category%type;
55: begin
56: fnd_file.put_line(fnd_file.log, '**Input Params:** ');
57: fnd_file.put_line(fnd_file.log, '1. Trx_id: '||pn_trx_id);
58: fnd_file.put_line(fnd_file.log, '2. Trx_type_id: '||pn_trx_type_id);
59: fnd_file.put_line(fnd_file.log, '3. Source: '||pv_source);
60: fnd_file.put_line(fnd_file.log, '4. Entity Code '||pv_entity_code);
61: begin
62: if pv_source = 'AP' then

Line 59: fnd_file.put_line(fnd_file.log, '3. Source: '||pv_source);

55: begin
56: fnd_file.put_line(fnd_file.log, '**Input Params:** ');
57: fnd_file.put_line(fnd_file.log, '1. Trx_id: '||pn_trx_id);
58: fnd_file.put_line(fnd_file.log, '2. Trx_type_id: '||pn_trx_type_id);
59: fnd_file.put_line(fnd_file.log, '3. Source: '||pv_source);
60: fnd_file.put_line(fnd_file.log, '4. Entity Code '||pv_entity_code);
61: begin
62: if pv_source = 'AP' then
63: select invoice_type_lookup_code

Line 60: fnd_file.put_line(fnd_file.log, '4. Entity Code '||pv_entity_code);

56: fnd_file.put_line(fnd_file.log, '**Input Params:** ');
57: fnd_file.put_line(fnd_file.log, '1. Trx_id: '||pn_trx_id);
58: fnd_file.put_line(fnd_file.log, '2. Trx_type_id: '||pn_trx_type_id);
59: fnd_file.put_line(fnd_file.log, '3. Source: '||pv_source);
60: fnd_file.put_line(fnd_file.log, '4. Entity Code '||pv_entity_code);
61: begin
62: if pv_source = 'AP' then
63: select invoice_type_lookup_code
64: into lv_fin_doc_type

Line 105: fnd_file.put_line(fnd_file.log,'Logging the Error Message encountered: '||sqlerrm);

101: exception
102: when others then
103: -- Don't Error Out (Possible excp are Too_many_rows or No_data_Found)
104: lv_fin_doc_type := null;
105: fnd_file.put_line(fnd_file.log,'Logging the Error Message encountered: '||sqlerrm);
106: end;
107: fnd_file.put_line(fnd_file.log,'Document Type Returned: '||lv_fin_doc_type);
108: return (lv_fin_doc_type);
109: end get_financial_document_type;

Line 107: fnd_file.put_line(fnd_file.log,'Document Type Returned: '||lv_fin_doc_type);

103: -- Don't Error Out (Possible excp are Too_many_rows or No_data_Found)
104: lv_fin_doc_type := null;
105: fnd_file.put_line(fnd_file.log,'Logging the Error Message encountered: '||sqlerrm);
106: end;
107: fnd_file.put_line(fnd_file.log,'Document Type Returned: '||lv_fin_doc_type);
108: return (lv_fin_doc_type);
109: end get_financial_document_type;
110: END JG_ZZ_AERL_DT_PKG ;