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

Line 112: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

108:
109:
110: l_debug_info := 'Start of check_ccr_status';
111: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
112: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
113: END IF;
114:
115: OPEN selected_inv(p_checkrun_id);
116: LOOP

Line 127: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

123: LIMIT 1000;
124:
125: l_debug_info := 'CALLING AP_APPROVAL_PKG.CHECK_CCR_VENDOR ';
126: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
127: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
128: END IF;
129:
130: for i in 1 .. ccr_rec_info.invoice_id_tab.count loop
131:

Line 146: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

142: P_CALLING_SEQUENCE => l_calling_sequence);
143:
144: l_debug_info := 'vendor_id '||ccr_rec_info.vendor_id_tab(i)||' returned ccr reg status ' ||l_Vendor_Site_Reg_Expired ;
145: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
146: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
147: END IF;
148:
149: IF(l_Vendor_Site_Reg_Expired <>'N') then
150: ccr_rec_list.invoice_id_tab(l_ind) := ccr_rec_info.invoice_id_tab(i);

Line 168: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

164: if (ccr_rec_list.invoice_id_tab.count >0) then
165:
166: l_debug_info := 'rejecting the invoices of inactive ccr status sites';
167: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
168: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
169: END IF;
170:
171: FORALL i IN ccr_rec_list.invoice_id_tab.first .. ccr_rec_list.invoice_id_tab.LAST
172: UPDATE Ap_Selected_Invoices_All ASI

Line 188: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

184:
185:
186: l_debug_info := 'End of check_ccr_status';
187: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
188: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
189: END IF;
190:
191: EXCEPTION
192:

Line 366: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

362: BEGIN
363:
364: l_debug_info := 'Perform Interest calculations';
365: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
366: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
367: END IF;
368:
369: l_current_calling_sequence := p_calling_sequence || '<-calculate_interest';
370:

Line 442: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

438:
439:
440: l_debug_info := 'Calling ap_interest_invoice_pkg';
441: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
442: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
443: END IF;
444:
445:
446:

Line 465: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

461: P_CALLING_SEQUENCE =>l_current_calling_sequence);
462:
463: l_debug_info := 'interest invoice amount = '||to_char(l_int_invoice_amt);
464: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
465: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
466: END IF;
467:
468:
469: IF (l_int_invoice_amt <> 0) THEN

Line 714: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

710:
711:
712: l_debug_info := 'Start of remove_invoices';
713: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
714: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
715: END IF;
716:
717:
718:

Line 844: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

840: l_current_calling_sequence := p_current_calling_sequence||'<- insert unselected';
841:
842: l_debug_info := 'open unselected_invoices';
843: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
844: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
845: END IF;
846:
847: -- Setting the hint string, bug8637005
848: /* Commented for bug#12773508 Start

Line 1452: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

1448: BEGIN
1449: l_current_calling_sequence := p_current_calling_sequence||'<-group interest credits';
1450: l_debug_info := 'open c_documents';
1451: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1452: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1453: END IF;
1454:
1455: OPEN c_documents(p_checkrun_id);
1456: FETCH c_documents BULK COLLECT INTO l_documents;

Line 1485: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

1481: end if;
1482:
1483: l_debug_info := 'Group_by_due_date flag :'||l_group_by_due_date_flag;
1484: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1485: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1486: END IF;
1487:
1488: -- Bug 9089243 ends
1489:

Line 1492: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

1488: -- Bug 9089243 ends
1489:
1490: l_debug_info := 'group all documents';
1491: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1492: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1493: END IF;
1494:
1495: --initialize the previous variables
1496:

Line 1697: fnd_file.put_line(FND_FILE.LOG,'l_tmp_cm_total'||l_tmp_cm_total);

1693: l_prev_pay_proc_trxn_type_code := l_documents(i).pay_proc_trxn_type_code;
1694: l_prev_beneficiary_party_id := l_documents(i).beneficiary_party_id;
1695: l_prev_bills_payable_flag := l_documents(i).support_bills_payable_flag; -- Bug 5357689
1696: l_prev_due_date := l_documents(i).due_date; -- Bug 5357689
1697: fnd_file.put_line(FND_FILE.LOG,'l_tmp_cm_total'||l_tmp_cm_total);
1698: end loop;
1699:
1700: --5007819
1701: if l_maximize_credits_flag = 'Y' then

Line 1705: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

1701: if l_maximize_credits_flag = 'Y' then
1702:
1703: l_debug_info := 'reduce credit memo amounts';
1704: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1705: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1706: END IF;
1707:
1708: --now everything should be grouped, let's go through and determine which
1709: --credit memos need to be reduced or set to not pay

Line 1781: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

1777:
1778:
1779: l_debug_info := 'update grouping numbers, ok to pay flags, and amounts';
1780: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1781: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1782: END IF;
1783:
1784:
1785:

Line 1968: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

1964: l_current_calling_sequence := p_current_calling_sequence || '<-create_checkrun';
1965:
1966: l_debug_info := 'select checkrun_id';
1967: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1968: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1969: END IF;
1970:
1971:
1972: select ap_inv_selection_criteria_s.nextval

Line 1980: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

1976:
1977:
1978: l_debug_info := 'insert into ap_inv_selection_criteria_all';
1979: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1980: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1981: END IF;
1982:
1983: insert into ap_inv_selection_criteria_all(
1984: check_date,

Line 2104: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

2100:
2101:
2102: l_debug_info := 'insert into ap_le_group';
2103: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2104: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
2105: END IF;
2106:
2107: insert into ap_le_group (
2108: legal_entity_id,

Line 2131: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

2127:
2128:
2129: l_debug_info := 'insert into AP_OU_GROUP';
2130: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2131: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
2132: END IF;
2133:
2134: insert into AP_OU_GROUP (
2135: org_id,

Line 2157: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

2153: and appt.ou_group_option = 'SPECIFY';
2154:
2155: l_debug_info := 'insert into AP_CURRENCY_GROUP';
2156: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2157: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
2158: END IF;
2159:
2160:
2161: insert into AP_CURRENCY_GROUP (

Line 2184: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

2180: and appt.currency_group_option = 'SPECIFY';--Bug6926344
2181:
2182: l_debug_info := 'insert into AP_PAY_GROUP';
2183: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2184: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
2185: END IF;
2186:
2187: insert into AP_PAY_GROUP (
2188: vendor_pay_group,

Line 2545: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

2541: l_current_calling_sequence := 'select invoices';
2542:
2543: l_debug_info := 'Check to see if creating checkrun from template';
2544: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2545: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
2546: END IF;
2547:
2548: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2549: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 2587: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

2583:
2584:
2585: l_debug_info := 'Select data from ap_invoice_selection_criteria';
2586: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2587: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
2588: END IF;
2589:
2590: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2591: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 2742: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

2738:
2739:
2740: l_debug_info := 'l_checkrun_id = '|| to_char(l_checkrun_id);
2741: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2742: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
2743: END IF;
2744:
2745: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2746: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 2752: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

2748:
2749:
2750: l_debug_info := 'See if encumbrances are turned on';
2751: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2752: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
2753: END IF;
2754:
2755: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2756: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 2803: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

2799: if l_encumbrance_flag = 1 then
2800:
2801: l_debug_info := 'Open payment schedules cursor - encumbrances are on';
2802: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2803: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
2804: END IF;
2805:
2806: l_sql_stmt :=
2807: ' SELECT '||l_hint||

Line 3388: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

3384:
3385:
3386: l_debug_info := 'Update ap_payment_schedules_all: encumbrances are on';
3387: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3388: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
3389: END IF;
3390:
3391: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3392: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 3407: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

3403:
3404:
3405: l_debug_info := 'Insert into ap_selected_invoices_all: encumbrances are on';
3406: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3407: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
3408: END IF;
3409:
3410: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3411: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 3626: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

3622: else --no encumbrances used
3623:
3624: l_debug_info := 'Open payment schedules cursor- encumbrances are off';
3625: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3626: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
3627: END IF;
3628:
3629: l_sql_stmt :=
3630: ' SELECT '||l_hint||

Line 4205: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

4201: LIMIT 1000;
4202:
4203: l_debug_info := 'Update ap_payment_schedules_all: encumbrances are off';
4204: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4205: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
4206: END IF;
4207:
4208: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4209: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 4224: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

4220:
4221:
4222: l_debug_info := 'Insert into ap_selected_invoices_all: encumbrances are off';
4223: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4224: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
4225: END IF;
4226:
4227: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4228: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 4448: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

4444:
4445:
4446: l_debug_info := 'Done Inserting Into Ap_Selected_Invoices_AlL';
4447: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4448: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
4449: END IF;
4450:
4451: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4452: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 4551: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

4547: /*BUG :8691645 */
4548:
4549: l_debug_info := 'Calling check_ccr_status ';
4550: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4551: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
4552: END IF;
4553:
4554: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4555: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 4568: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

4564:
4565:
4566: l_debug_info := 'Calling Remove_Invoices';
4567: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4568: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
4569: END IF;
4570:
4571: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4572: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 4579: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

4575: remove_invoices(l_checkrun_id,l_current_calling_sequence);
4576:
4577: l_debug_info := 'Calling Insert_UnselectedL';
4578: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4579: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
4580: END IF;
4581:
4582: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4583: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 4619: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

4615:
4616:
4617: l_debug_info := 'Update amounts in ap_selected_invoices';
4618: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4619: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
4620: END IF;
4621:
4622: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4623: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 4734: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

4730:
4731:
4732: l_debug_info := 'Round amounts in ap_selected_invoices';
4733: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4734: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
4735: END IF;
4736:
4737: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4738: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 4763: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

4759: AND amount_remaining = 0;
4760:
4761: l_debug_info := 'Calling Calculate_Interest';
4762: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4763: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
4764: END IF;
4765:
4766: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4767: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 4778: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

4774: l_current_calling_sequence);
4775:
4776: l_debug_info := 'updating exchange rate info';
4777: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4778: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
4779: END IF;
4780:
4781: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4782: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 4902: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

4898: /* BUG 14498596 Start - Moved Withholding Tax logic before grouping of invoices */
4899:
4900: l_debug_info := 'Calling ap_withholding_pkg';
4901: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4902: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
4903: END IF;
4904:
4905: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4906: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 4922: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

4918:
4919: --Bug6459578
4920: l_debug_info := 'Calling ap_custom_withholding_pkg';
4921: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4922: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
4923: END IF;
4924:
4925: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4926: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 4935: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

4931: --Bug6459578
4932:
4933: l_debug_info := 'Grouping selected invoices';
4934: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4935: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
4936: END IF;
4937:
4938: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4939: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 5116: fnd_file.put_line(FND_FILE.LOG, 'No scheduled payments matched the invoice selection criteria');

5112: where checkrun_id = l_checkrun_id;
5113:
5114: commit;
5115:
5116: fnd_file.put_line(FND_FILE.LOG, 'No scheduled payments matched the invoice selection criteria');
5117:
5118: l_debug_info := 'No scheduled payments matched the invoice selection criteria';
5119: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5120: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 5159: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);

5155: FND_MSG_PUB.Get( p_msg_index => i,
5156: p_encoded => 'F',
5157: p_data => l_msg_data,
5158: p_msg_index_out => l_msg_index_out);
5159: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
5160: End LOOP;
5161: end if;
5162: end if;
5163: end;

Line 5234: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

5230: if l_batch_status = 'SELECTED' and l_payables_review_settings <> 'Y' then
5231:
5232: l_debug_info := 'Submitting Oracle Payments Build';
5233: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5234: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
5235: END IF;
5236:
5237: l_req_id := FND_REQUEST.SUBMIT_REQUEST(
5238: 'IBY',

Line 5277: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

5273: chr(0));
5274:
5275: l_debug_info := 'request_id ='||to_char(l_req_id);
5276: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5277: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
5278: END IF;
5279: /* Bug 11063950 : Populated Request_id in ap_inv_selection_criteria_all */
5280: update ap_inv_selection_criteria_all
5281: set request_id = l_req_id

Line 5407: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

5403: -- for original payment schedules from invoice header.
5404:
5405: l_debug_info := 'Recalculate: restoring exclusive_payment_flag.';
5406: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5407: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
5408: END IF;
5409:
5410: update ap_selected_invoices_all asi
5411: set exclusive_payment_flag = (select nvl(exclusive_payment_flag, 'N')

Line 5571: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

5567: -- Code flow should be same as mentioned in Procedure Select_Invoices
5568:
5569: l_debug_info := 'Recalculate: Updating Exchage rate info';
5570: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5571: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
5572: END IF;
5573:
5574: l_debug_info := 'Recalculate: Exchange Rate type is :'||l_batch_exchange_rate_type;
5575: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 5576: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

5572: END IF;
5573:
5574: l_debug_info := 'Recalculate: Exchange Rate type is :'||l_batch_exchange_rate_type;
5575: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5576: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
5577: END IF;
5578:
5579: if l_batch_exchange_rate_type = 'User' then
5580:

Line 5701: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

5697: -- Start Bug 6743242
5698:
5699: l_debug_info := 'Calling ap_custom_withholding_pkg';
5700: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5701: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
5702: END IF;
5703:
5704: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5705: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'.recalculate',l_debug_info);

Line 5800: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

5796: WHERE checkrun_id = p_checkrun_id;
5797:
5798: l_debug_info := 'Recalculate: restoring affects_rejection_level data';
5799: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5800: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
5801: END IF;
5802:
5803: IF NVL(l_inv_awt_exists_flag, 'N') = 'Y' THEN
5804: update ap_selected_invoices_All asi

Line 5986: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);

5982: FND_MSG_PUB.Get( p_msg_index => i,
5983: p_encoded => 'F',
5984: p_data => l_msg_data,
5985: p_msg_index_out => l_msg_index_out);
5986: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
5987: End LOOP;
5988: end if;
5989: end if;
5990: end;

Line 6255: FND_File.Put_Line(fnd_file.log,l_debug_info);

6251: to_char(p_checkrun_id));
6252:
6253: END IF;
6254: ROLLBACK;
6255: FND_File.Put_Line(fnd_file.log,l_debug_info);
6256: APP_EXCEPTION.RAISE_EXCEPTION;
6257: end cancel_batch;
6258:
6259:

Line 6276: fnd_file.put_line(fnd_file.output, '');

6272:
6273: l_current_calling_sequence := 'ap_autoselect_pkg.selection_criteria_report';
6274: l_debug_info:= 'select from ap_inv_selection_criteria_all';
6275:
6276: fnd_file.put_line(fnd_file.output, '');
6277:
6278: l_qryCtx := DBMS_XMLGEN.newContext(
6279: 'select aisc.checkrun_name, aisc.pay_from_date, aisc.pay_thru_date,
6280: aisc.hi_payment_priority, aisc.low_payment_priority,

Line 6366: fnd_file.put_line(fnd_file.output, '');

6362: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6363: DBMS_XMLGEN.closeContext(l_qryCtx);
6364: ap_utilities_pkg.clob_to_file(l_result_clob);
6365:
6366: fnd_file.put_line(fnd_file.output, '');
6367:
6368: EXCEPTION
6369:
6370: WHEN OTHERS then

Line 6445: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

6441:
6442: l_current_calling_sequence := p_calling_sequence || '<-mark_overpayments ';
6443: l_debug_info := 'Inside mark overpayments';
6444: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6445: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
6446: END IF;
6447:
6448: update ap_selected_invoices_all si
6449: set ok_to_pay_flag = 'N',

Line 6567: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

6563: BEGIN
6564:
6565: l_debug_info := 'fetching checkrun_id.';
6566: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6567: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
6568: END IF;
6569:
6570: select calling_app_doc_unique_ref1
6571: into l_checkrun_id

Line 6578: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

6574: and rownum = 1;
6575:
6576: l_debug_info := 'checkrun_id = ' || l_checkrun_id;
6577: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6578: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
6579: END IF;
6580:
6581: l_debug_info := 'open cursor c_sel_invs';
6582: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 6583: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

6579: END IF;
6580:
6581: l_debug_info := 'open cursor c_sel_invs';
6582: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6583: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
6584: END IF;
6585:
6586: OPEN c_sel_invs;
6587:

Line 6592: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

6588: LOOP
6589:
6590: l_debug_info := 'fetch c_sel_invs for selected schedules.';
6591: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6592: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
6593: END IF;
6594:
6595: FETCH c_sel_invs INTO rec_sel_invs;
6596: EXIT WHEN c_sel_invs%NOTFOUND;

Line 6608: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

6604: || ' ,original_invoice_id = ' || rec_sel_invs.original_invoice_id
6605: || ' ,original_payment_num = ' || rec_sel_invs.original_payment_num
6606: || ' ,payment_grouping_number = ' || rec_sel_invs.payment_grouping_number ;
6607: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6608: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
6609: END IF;
6610:
6611: -- Following select is almost exactly same as cursor c_sel_invs. This is to check whether
6612: -- the pair is present in the list of docs to be removed. original_invoice_id invoice_id

Line 6657: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

6653: -- retunred to IBY.
6654:
6655: l_debug_info := 'schedule/interest pair does not exist in the removal list.';
6656: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6657: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
6658: END IF;
6659:
6660: -- Following query checks against all the schedules selected as part of the batch.
6661: -- If pair is not present in this, then it is safe to remove the schedule in this

Line 6689: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

6685: l_debug_info := 'payables docs can not be removed. Returning status N.'
6686: || ' invoice_id = ' || rec_sel_invs.invoice_id
6687: || ' ,payment_num = ' || rec_sel_invs.payment_num;
6688: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6689: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
6690: END IF;
6691:
6692: l_status := false ;
6693: EXIT ;

Line 6712: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

6708: EXCEPTION
6709: WHEN OTHERS THEN
6710: l_debug_info := 'Caught in exception block.' ;
6711: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6712: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
6713: END IF;
6714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6715:
6716: END check_doc_payable_remove;