DBA Data[Home] [Help]

APPS.OKL_BPD_ADV_MON_RPT_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 172: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_OPERUNIT')

168: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',50, ' ' ) || '-------------------------------' || RPAD(' ', 51, ' ' ));
169: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
170: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
171: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
172: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_OPERUNIT')
173: ||' : '|| SUBSTR(l_org_name, 1, 30) || RPAD(' ', 50 , ' ' ) || fnd_message.get_string('OKL','OKL_REQUEST_ID')
174: ||' : ' || Fnd_Global.CONC_REQUEST_ID);
175: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY')
176: ||' : '|| okl_accounting_util.get_func_curr_code || RPAD(' ', 70 , ' ' )

Line 176: ||' : '|| okl_accounting_util.get_func_curr_code || RPAD(' ', 70 , ' ' )

172: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_OPERUNIT')
173: ||' : '|| SUBSTR(l_org_name, 1, 30) || RPAD(' ', 50 , ' ' ) || fnd_message.get_string('OKL','OKL_REQUEST_ID')
174: ||' : ' || Fnd_Global.CONC_REQUEST_ID);
175: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY')
176: ||' : '|| okl_accounting_util.get_func_curr_code || RPAD(' ', 70 , ' ' )
177: || Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_RUN_DATE') ||' : ' ||
178: SUBSTR(TO_CHAR(SYSDATE, 'DD-MON-YYYY'), 1, 27));
179: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
180: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));

Line 177: || Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_RUN_DATE') ||' : ' ||

173: ||' : '|| SUBSTR(l_org_name, 1, 30) || RPAD(' ', 50 , ' ' ) || fnd_message.get_string('OKL','OKL_REQUEST_ID')
174: ||' : ' || Fnd_Global.CONC_REQUEST_ID);
175: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY')
176: ||' : '|| okl_accounting_util.get_func_curr_code || RPAD(' ', 70 , ' ' )
177: || Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_RUN_DATE') ||' : ' ||
178: SUBSTR(TO_CHAR(SYSDATE, 'DD-MON-YYYY'), 1, 27));
179: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
180: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
181: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 100 , '-' ));

Line 225: GET_PROPER_LENGTH(okl_accounting_util.format_amount(r_appld_rcpts.remittance_amount,r_appld_rcpts.currency_code)

221:
222: IF i = 1 AND j = 1 THEN
223: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH(r_appld_rcpts.check_number,l_Receipt#_len,'DATA')||' '||
224: GET_PROPER_LENGTH(r_appld_rcpts.receipt_date,l_Receipt_Date_len,'DATA')||' '||
225: GET_PROPER_LENGTH(okl_accounting_util.format_amount(r_appld_rcpts.remittance_amount,r_appld_rcpts.currency_code)
226: ,l_Receipt_Amount_len,'DATA')||' '||
227: GET_PROPER_LENGTH(r_appld_rcpts.NAME,l_Customer_Name_len,'DATA')||' '||
228: GET_PROPER_LENGTH(r_appld_rcpts.customer_number,l_Customer#_len,'DATA')||' '||
229: GET_PROPER_LENGTH(okl_accounting_util.format_amount(r_appld_rcpts.amount,r_appld_rcpts.currency_code)

Line 229: GET_PROPER_LENGTH(okl_accounting_util.format_amount(r_appld_rcpts.amount,r_appld_rcpts.currency_code)

225: GET_PROPER_LENGTH(okl_accounting_util.format_amount(r_appld_rcpts.remittance_amount,r_appld_rcpts.currency_code)
226: ,l_Receipt_Amount_len,'DATA')||' '||
227: GET_PROPER_LENGTH(r_appld_rcpts.NAME,l_Customer_Name_len,'DATA')||' '||
228: GET_PROPER_LENGTH(r_appld_rcpts.customer_number,l_Customer#_len,'DATA')||' '||
229: GET_PROPER_LENGTH(okl_accounting_util.format_amount(r_appld_rcpts.amount,r_appld_rcpts.currency_code)
230: ,l_Receipt_Amount_len,'DATA')||' '||
231: GET_PROPER_LENGTH(r_appld_rcpts.contract_number,l_Contract_Number_len,'DATA')||' '||
232: GET_PROPER_LENGTH(r_appld_rcpts.invoice_number,l_Invoice#_len,'DATA')||' '||
233: GET_PROPER_LENGTH(r_appld_rcpts.Trx_Date,l_Invoice_Date_len,'DATA')||' '||

Line 234: GET_PROPER_LENGTH(okl_accounting_util.format_amount(r_appld_rcpts.amount_applied,r_appld_rcpts.currency_code),l_Amount_Applied_len,'DATA'));

230: ,l_Receipt_Amount_len,'DATA')||' '||
231: GET_PROPER_LENGTH(r_appld_rcpts.contract_number,l_Contract_Number_len,'DATA')||' '||
232: GET_PROPER_LENGTH(r_appld_rcpts.invoice_number,l_Invoice#_len,'DATA')||' '||
233: GET_PROPER_LENGTH(r_appld_rcpts.Trx_Date,l_Invoice_Date_len,'DATA')||' '||
234: GET_PROPER_LENGTH(okl_accounting_util.format_amount(r_appld_rcpts.amount_applied,r_appld_rcpts.currency_code),l_Amount_Applied_len,'DATA'));
235: ELSE
236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH(' ',l_length_till_invc1,'DATA')|| ' '||
237: GET_PROPER_LENGTH(r_appld_rcpts.invoice_number,l_Invoice#_len,'DATA')||' '||
238: GET_PROPER_LENGTH(r_appld_rcpts.Trx_Date,l_Invoice_Date_len,'DATA')||' '||

Line 239: GET_PROPER_LENGTH(okl_accounting_util.format_amount(r_appld_rcpts.amount_applied,r_appld_rcpts.currency_code),l_Amount_Applied_len,'DATA'));

235: ELSE
236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH(' ',l_length_till_invc1,'DATA')|| ' '||
237: GET_PROPER_LENGTH(r_appld_rcpts.invoice_number,l_Invoice#_len,'DATA')||' '||
238: GET_PROPER_LENGTH(r_appld_rcpts.Trx_Date,l_Invoice_Date_len,'DATA')||' '||
239: GET_PROPER_LENGTH(okl_accounting_util.format_amount(r_appld_rcpts.amount_applied,r_appld_rcpts.currency_code),l_Amount_Applied_len,'DATA'));
240: END IF;
241: ELSE
242: i := 0;
243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH(r_appld_rcpts.check_number,l_Receipt#_len,'DATA')||' '||

Line 245: GET_PROPER_LENGTH(okl_accounting_util.format_amount(r_appld_rcpts.remittance_amount,r_appld_rcpts.currency_code)

241: ELSE
242: i := 0;
243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH(r_appld_rcpts.check_number,l_Receipt#_len,'DATA')||' '||
244: GET_PROPER_LENGTH(r_appld_rcpts.receipt_date,l_Receipt_Date_len,'DATA')||' '||
245: GET_PROPER_LENGTH(okl_accounting_util.format_amount(r_appld_rcpts.remittance_amount,r_appld_rcpts.currency_code)
246: ,l_Receipt_Amount_len,'DATA')||' '||
247: GET_PROPER_LENGTH(r_appld_rcpts.NAME,l_Customer_Name_len,'DATA')||' '||
248: GET_PROPER_LENGTH(r_appld_rcpts.customer_number,l_Customer#_len,'DATA')||' '||
249: GET_PROPER_LENGTH(okl_accounting_util.format_amount(r_appld_rcpts.amount,r_appld_rcpts.currency_code)

Line 249: GET_PROPER_LENGTH(okl_accounting_util.format_amount(r_appld_rcpts.amount,r_appld_rcpts.currency_code)

245: GET_PROPER_LENGTH(okl_accounting_util.format_amount(r_appld_rcpts.remittance_amount,r_appld_rcpts.currency_code)
246: ,l_Receipt_Amount_len,'DATA')||' '||
247: GET_PROPER_LENGTH(r_appld_rcpts.NAME,l_Customer_Name_len,'DATA')||' '||
248: GET_PROPER_LENGTH(r_appld_rcpts.customer_number,l_Customer#_len,'DATA')||' '||
249: GET_PROPER_LENGTH(okl_accounting_util.format_amount(r_appld_rcpts.amount,r_appld_rcpts.currency_code)
250: ,l_Receipt_Amount_len,'DATA')||' '||
251: GET_PROPER_LENGTH(r_appld_rcpts.contract_number,l_Contract_Number_len,'DATA')||' '||
252: GET_PROPER_LENGTH(r_appld_rcpts.invoice_number,l_Invoice#_len,'DATA')||' '||
253: GET_PROPER_LENGTH(r_appld_rcpts.Trx_Date,l_Invoice_Date_len,'DATA')||' '||

Line 254: GET_PROPER_LENGTH(okl_accounting_util.format_amount(r_appld_rcpts.amount_applied,r_appld_rcpts.currency_code),l_Amount_Applied_len,'DATA'));

250: ,l_Receipt_Amount_len,'DATA')||' '||
251: GET_PROPER_LENGTH(r_appld_rcpts.contract_number,l_Contract_Number_len,'DATA')||' '||
252: GET_PROPER_LENGTH(r_appld_rcpts.invoice_number,l_Invoice#_len,'DATA')||' '||
253: GET_PROPER_LENGTH(r_appld_rcpts.Trx_Date,l_Invoice_Date_len,'DATA')||' '||
254: GET_PROPER_LENGTH(okl_accounting_util.format_amount(r_appld_rcpts.amount_applied,r_appld_rcpts.currency_code),l_Amount_Applied_len,'DATA'));
255: END IF;
256: END LOOP;
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ', l_total_length , ' ' ));
258: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));

Line 283: GET_PROPER_LENGTH(okl_accounting_util.format_amount(r_unappld_rcpts.remittance_amount,r_unappld_rcpts.currency_code)

279: -- start report Unapplied Receipts
280: FOR r_unappld_rcpts IN C_unappld_Rcpts(l_from_date,l_to_date) LOOP
281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH(r_unappld_rcpts.check_number,l_Receipt#_len,'DATA')||' '||
282: GET_PROPER_LENGTH(r_unappld_rcpts.receipt_date,l_Receipt_Date_len,'DATA')||' '||
283: GET_PROPER_LENGTH(okl_accounting_util.format_amount(r_unappld_rcpts.remittance_amount,r_unappld_rcpts.currency_code)
284: ,l_Receipt_Amount_len,'DATA')||' '||
285: GET_PROPER_LENGTH(r_unappld_rcpts.NAME,l_Customer_Name_len,'DATA')||' '||
286: GET_PROPER_LENGTH(r_unappld_rcpts.customer_number,l_Customer#_len,'DATA')||' '||
287: GET_PROPER_LENGTH(okl_accounting_util.format_amount(r_unappld_rcpts.amount,r_unappld_rcpts.currency_code)

Line 287: GET_PROPER_LENGTH(okl_accounting_util.format_amount(r_unappld_rcpts.amount,r_unappld_rcpts.currency_code)

283: GET_PROPER_LENGTH(okl_accounting_util.format_amount(r_unappld_rcpts.remittance_amount,r_unappld_rcpts.currency_code)
284: ,l_Receipt_Amount_len,'DATA')||' '||
285: GET_PROPER_LENGTH(r_unappld_rcpts.NAME,l_Customer_Name_len,'DATA')||' '||
286: GET_PROPER_LENGTH(r_unappld_rcpts.customer_number,l_Customer#_len,'DATA')||' '||
287: GET_PROPER_LENGTH(okl_accounting_util.format_amount(r_unappld_rcpts.amount,r_unappld_rcpts.currency_code)
288: ,l_Receipt_Amount_len,'DATA')||' '||
289: GET_PROPER_LENGTH(r_unappld_rcpts.contract_number,l_Contract_Number_len,'DATA'));
290: END LOOP;
291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ', l_total_length , ' ' ));