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.OKL_BPD_ADV_MON_RPT_PVT dependencies on FND_MESSAGE

Line 162: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKLHOMENAVTITLE') ||

158: l_org_name := org_rec.name;
159: END LOOP;
160:
161:
162: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKLHOMENAVTITLE') ||
163: RPAD(' ', 53 , ' ' ));
164: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
165: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
166: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_TITLE') ||

Line 166: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_TITLE') ||

162: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKLHOMENAVTITLE') ||
163: RPAD(' ', 53 , ' ' ));
164: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
165: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
166: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_TITLE') ||
167: RPAD(' ', 53 , ' ' ));
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, ' ' ));

Line 173: ||' : '|| SUBSTR(l_org_name, 1, 30) || RPAD(' ', 50 , ' ' ) || fnd_message.get_string('OKL','OKL_REQUEST_ID')

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 , ' ' )
177: || Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_RUN_DATE') ||' : ' ||

Line 175: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY')

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 , ' ' )
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, ' ' ));

Line 182: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_RCPT_APP_STATUS') || ' : '

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 , '-' ));
182: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_RCPT_APP_STATUS') || ' : '
183: || fnd_message.get_string('OKL',p_rcpt_applic_stat));
184: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_FROM_DATE') || ' : ' || l_from_date);
185: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_TO_DATE') || ' : ' || l_to_date);
186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 100 , '-' ));

Line 183: || fnd_message.get_string('OKL',p_rcpt_applic_stat));

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 , '-' ));
182: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_RCPT_APP_STATUS') || ' : '
183: || fnd_message.get_string('OKL',p_rcpt_applic_stat));
184: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_FROM_DATE') || ' : ' || l_from_date);
185: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_TO_DATE') || ' : ' || l_to_date);
186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 100 , '-' ));
187:

Line 184: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_FROM_DATE') || ' : ' || l_from_date);

180: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
181: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 100 , '-' ));
182: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_RCPT_APP_STATUS') || ' : '
183: || fnd_message.get_string('OKL',p_rcpt_applic_stat));
184: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_FROM_DATE') || ' : ' || l_from_date);
185: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_TO_DATE') || ' : ' || l_to_date);
186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 100 , '-' ));
187:
188: --Report Header for Applied Receipts

Line 185: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_TO_DATE') || ' : ' || l_to_date);

181: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 100 , '-' ));
182: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_RCPT_APP_STATUS') || ' : '
183: || fnd_message.get_string('OKL',p_rcpt_applic_stat));
184: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_FROM_DATE') || ' : ' || l_from_date);
185: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_TO_DATE') || ' : ' || l_to_date);
186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 100 , '-' ));
187:
188: --Report Header for Applied Receipts
189: IF (p_rcpt_applic_stat = 'APPLIED') OR (p_rcpt_applic_stat = 'BOTH') THEN

Line 192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_APPLD_RCPT'));

188: --Report Header for Applied Receipts
189: IF (p_rcpt_applic_stat = 'APPLIED') OR (p_rcpt_applic_stat = 'BOTH') THEN
190:
191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_APPLD_RCPT'));
193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 20 , '-' ));
194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH(
196: fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_NO'),l_Receipt#_len,'TITLE')||' '||

Line 196: fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_NO'),l_Receipt#_len,'TITLE')||' '||

192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_APPLD_RCPT'));
193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 20 , '-' ));
194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH(
196: fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_NO'),l_Receipt#_len,'TITLE')||' '||
197: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_DT'),l_Receipt_Date_len,'TITLE')||' '||
198: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_AMNT'),l_Receipt_Amount_len,'TITLE')||' '||
199: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NAME'),l_Customer_Name_len,'TITLE')||' '||
200: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NO'),l_Customer#_len,'TITLE')||' '||

Line 197: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_DT'),l_Receipt_Date_len,'TITLE')||' '||

193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 20 , '-' ));
194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH(
196: fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_NO'),l_Receipt#_len,'TITLE')||' '||
197: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_DT'),l_Receipt_Date_len,'TITLE')||' '||
198: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_AMNT'),l_Receipt_Amount_len,'TITLE')||' '||
199: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NAME'),l_Customer_Name_len,'TITLE')||' '||
200: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NO'),l_Customer#_len,'TITLE')||' '||
201: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_ACCNT_BLNC'),l_Account_Balance_len,'TITLE')||' '||

Line 198: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_AMNT'),l_Receipt_Amount_len,'TITLE')||' '||

194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH(
196: fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_NO'),l_Receipt#_len,'TITLE')||' '||
197: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_DT'),l_Receipt_Date_len,'TITLE')||' '||
198: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_AMNT'),l_Receipt_Amount_len,'TITLE')||' '||
199: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NAME'),l_Customer_Name_len,'TITLE')||' '||
200: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NO'),l_Customer#_len,'TITLE')||' '||
201: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_ACCNT_BLNC'),l_Account_Balance_len,'TITLE')||' '||
202: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CNTRCT_NO'),l_Contract_Number_len,'TITLE')||' '||

Line 199: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NAME'),l_Customer_Name_len,'TITLE')||' '||

195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH(
196: fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_NO'),l_Receipt#_len,'TITLE')||' '||
197: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_DT'),l_Receipt_Date_len,'TITLE')||' '||
198: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_AMNT'),l_Receipt_Amount_len,'TITLE')||' '||
199: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NAME'),l_Customer_Name_len,'TITLE')||' '||
200: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NO'),l_Customer#_len,'TITLE')||' '||
201: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_ACCNT_BLNC'),l_Account_Balance_len,'TITLE')||' '||
202: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CNTRCT_NO'),l_Contract_Number_len,'TITLE')||' '||
203: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_INVC_NO'),l_Invoice#_len,'TITLE')||' '||

Line 200: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NO'),l_Customer#_len,'TITLE')||' '||

196: fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_NO'),l_Receipt#_len,'TITLE')||' '||
197: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_DT'),l_Receipt_Date_len,'TITLE')||' '||
198: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_AMNT'),l_Receipt_Amount_len,'TITLE')||' '||
199: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NAME'),l_Customer_Name_len,'TITLE')||' '||
200: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NO'),l_Customer#_len,'TITLE')||' '||
201: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_ACCNT_BLNC'),l_Account_Balance_len,'TITLE')||' '||
202: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CNTRCT_NO'),l_Contract_Number_len,'TITLE')||' '||
203: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_INVC_NO'),l_Invoice#_len,'TITLE')||' '||
204: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_INVC_DT'),l_Invoice_Date_len,'TITLE')||' '||

Line 201: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_ACCNT_BLNC'),l_Account_Balance_len,'TITLE')||' '||

197: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_DT'),l_Receipt_Date_len,'TITLE')||' '||
198: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_AMNT'),l_Receipt_Amount_len,'TITLE')||' '||
199: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NAME'),l_Customer_Name_len,'TITLE')||' '||
200: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NO'),l_Customer#_len,'TITLE')||' '||
201: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_ACCNT_BLNC'),l_Account_Balance_len,'TITLE')||' '||
202: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CNTRCT_NO'),l_Contract_Number_len,'TITLE')||' '||
203: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_INVC_NO'),l_Invoice#_len,'TITLE')||' '||
204: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_INVC_DT'),l_Invoice_Date_len,'TITLE')||' '||
205: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_AMNT_APPLD'),l_Amount_Applied_len,'TITLE'));

Line 202: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CNTRCT_NO'),l_Contract_Number_len,'TITLE')||' '||

198: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_AMNT'),l_Receipt_Amount_len,'TITLE')||' '||
199: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NAME'),l_Customer_Name_len,'TITLE')||' '||
200: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NO'),l_Customer#_len,'TITLE')||' '||
201: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_ACCNT_BLNC'),l_Account_Balance_len,'TITLE')||' '||
202: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CNTRCT_NO'),l_Contract_Number_len,'TITLE')||' '||
203: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_INVC_NO'),l_Invoice#_len,'TITLE')||' '||
204: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_INVC_DT'),l_Invoice_Date_len,'TITLE')||' '||
205: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_AMNT_APPLD'),l_Amount_Applied_len,'TITLE'));
206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_total_length+8 , '=' ));

Line 203: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_INVC_NO'),l_Invoice#_len,'TITLE')||' '||

199: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NAME'),l_Customer_Name_len,'TITLE')||' '||
200: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NO'),l_Customer#_len,'TITLE')||' '||
201: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_ACCNT_BLNC'),l_Account_Balance_len,'TITLE')||' '||
202: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CNTRCT_NO'),l_Contract_Number_len,'TITLE')||' '||
203: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_INVC_NO'),l_Invoice#_len,'TITLE')||' '||
204: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_INVC_DT'),l_Invoice_Date_len,'TITLE')||' '||
205: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_AMNT_APPLD'),l_Amount_Applied_len,'TITLE'));
206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_total_length+8 , '=' ));
207: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 204: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_INVC_DT'),l_Invoice_Date_len,'TITLE')||' '||

200: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NO'),l_Customer#_len,'TITLE')||' '||
201: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_ACCNT_BLNC'),l_Account_Balance_len,'TITLE')||' '||
202: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CNTRCT_NO'),l_Contract_Number_len,'TITLE')||' '||
203: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_INVC_NO'),l_Invoice#_len,'TITLE')||' '||
204: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_INVC_DT'),l_Invoice_Date_len,'TITLE')||' '||
205: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_AMNT_APPLD'),l_Amount_Applied_len,'TITLE'));
206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_total_length+8 , '=' ));
207: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
208: -- start report Applied Receipts

Line 205: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_AMNT_APPLD'),l_Amount_Applied_len,'TITLE'));

201: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_ACCNT_BLNC'),l_Account_Balance_len,'TITLE')||' '||
202: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CNTRCT_NO'),l_Contract_Number_len,'TITLE')||' '||
203: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_INVC_NO'),l_Invoice#_len,'TITLE')||' '||
204: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_INVC_DT'),l_Invoice_Date_len,'TITLE')||' '||
205: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_AMNT_APPLD'),l_Amount_Applied_len,'TITLE'));
206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_total_length+8 , '=' ));
207: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
208: -- start report Applied Receipts
209: FOR r_appld_rcpts IN C_appld_Rcpts(l_from_date,l_to_date) LOOP

Line 265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_UNAPPLD'));

261: IF (p_rcpt_applic_stat = 'UNAPPLIED') OR (p_rcpt_applic_stat = 'BOTH') THEN
262: --Report Header for Unapplied Receipts
263:
264: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_UNAPPLD'));
266: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 20 , '-' ));
267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_length_till_invc , '-' ));
268: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH(
269: fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_NO'),l_Receipt#_len,'TITLE')||' '||

Line 269: fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_NO'),l_Receipt#_len,'TITLE')||' '||

265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_UNAPPLD'));
266: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 20 , '-' ));
267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_length_till_invc , '-' ));
268: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH(
269: fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_NO'),l_Receipt#_len,'TITLE')||' '||
270: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_DT'),l_Receipt_Date_len,'TITLE')||' '||
271: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_AMNT'),l_Receipt_Amount_len,'TITLE')||' '||
272: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NAME'),l_Customer_Name_len,'TITLE')||' '||
273: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NO'),l_Customer#_len,'TITLE')||' '||

Line 270: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_DT'),l_Receipt_Date_len,'TITLE')||' '||

266: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 20 , '-' ));
267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_length_till_invc , '-' ));
268: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH(
269: fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_NO'),l_Receipt#_len,'TITLE')||' '||
270: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_DT'),l_Receipt_Date_len,'TITLE')||' '||
271: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_AMNT'),l_Receipt_Amount_len,'TITLE')||' '||
272: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NAME'),l_Customer_Name_len,'TITLE')||' '||
273: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NO'),l_Customer#_len,'TITLE')||' '||
274: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_ACCNT_BLNC'),l_Account_Balance_len,'TITLE')||' '||

Line 271: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_AMNT'),l_Receipt_Amount_len,'TITLE')||' '||

267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_length_till_invc , '-' ));
268: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH(
269: fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_NO'),l_Receipt#_len,'TITLE')||' '||
270: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_DT'),l_Receipt_Date_len,'TITLE')||' '||
271: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_AMNT'),l_Receipt_Amount_len,'TITLE')||' '||
272: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NAME'),l_Customer_Name_len,'TITLE')||' '||
273: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NO'),l_Customer#_len,'TITLE')||' '||
274: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_ACCNT_BLNC'),l_Account_Balance_len,'TITLE')||' '||
275: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CNTRCT_NO'),l_Contract_Number_len,'TITLE'));

Line 272: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NAME'),l_Customer_Name_len,'TITLE')||' '||

268: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH(
269: fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_NO'),l_Receipt#_len,'TITLE')||' '||
270: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_DT'),l_Receipt_Date_len,'TITLE')||' '||
271: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_AMNT'),l_Receipt_Amount_len,'TITLE')||' '||
272: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NAME'),l_Customer_Name_len,'TITLE')||' '||
273: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NO'),l_Customer#_len,'TITLE')||' '||
274: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_ACCNT_BLNC'),l_Account_Balance_len,'TITLE')||' '||
275: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CNTRCT_NO'),l_Contract_Number_len,'TITLE'));
276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_length_till_invc , '=' ));

Line 273: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NO'),l_Customer#_len,'TITLE')||' '||

269: fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_NO'),l_Receipt#_len,'TITLE')||' '||
270: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_DT'),l_Receipt_Date_len,'TITLE')||' '||
271: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_AMNT'),l_Receipt_Amount_len,'TITLE')||' '||
272: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NAME'),l_Customer_Name_len,'TITLE')||' '||
273: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NO'),l_Customer#_len,'TITLE')||' '||
274: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_ACCNT_BLNC'),l_Account_Balance_len,'TITLE')||' '||
275: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CNTRCT_NO'),l_Contract_Number_len,'TITLE'));
276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_length_till_invc , '=' ));
277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 274: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_ACCNT_BLNC'),l_Account_Balance_len,'TITLE')||' '||

270: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_DT'),l_Receipt_Date_len,'TITLE')||' '||
271: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_AMNT'),l_Receipt_Amount_len,'TITLE')||' '||
272: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NAME'),l_Customer_Name_len,'TITLE')||' '||
273: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NO'),l_Customer#_len,'TITLE')||' '||
274: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_ACCNT_BLNC'),l_Account_Balance_len,'TITLE')||' '||
275: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CNTRCT_NO'),l_Contract_Number_len,'TITLE'));
276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_length_till_invc , '=' ));
277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
278:

Line 275: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CNTRCT_NO'),l_Contract_Number_len,'TITLE'));

271: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_RCPT_AMNT'),l_Receipt_Amount_len,'TITLE')||' '||
272: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NAME'),l_Customer_Name_len,'TITLE')||' '||
273: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CUST_NO'),l_Customer#_len,'TITLE')||' '||
274: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_ACCNT_BLNC'),l_Account_Balance_len,'TITLE')||' '||
275: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_BPD_ADV_MNY_RPT_CNTRCT_NO'),l_Contract_Number_len,'TITLE'));
276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_length_till_invc , '=' ));
277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
278:
279: -- start report Unapplied Receipts