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 172: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

168: BEGIN
169:
170: l_debug_info := 'Perform Interest calculations';
171: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
172: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
173: END IF;
174:
175: l_current_calling_sequence := p_calling_sequence || '<-calculate_interest';
176:

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

244:
245:
246: l_debug_info := 'Calling ap_interest_invoice_pkg';
247: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
248: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
249: END IF;
250:
251:
252:

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

267: P_CALLING_SEQUENCE =>l_current_calling_sequence);
268:
269: l_debug_info := 'interest invoice amount = '||to_char(l_int_invoice_amt);
270: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
271: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
272: END IF;
273:
274:
275: IF (l_int_invoice_amt <> 0) THEN

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

513:
514:
515: l_debug_info := 'Start of remove_invoices';
516: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
517: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
518: END IF;
519:
520:
521:

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

693: l_current_calling_sequence := p_current_calling_sequence||'<- insert unselected';
694:
695: l_debug_info := 'open unselected_invoices';
696: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
697: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
698: END IF;
699:
700:
701: open unselected_invoices;

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

1052: BEGIN
1053: l_current_calling_sequence := p_current_calling_sequence||'<-group interest credits';
1054: l_debug_info := 'open c_documents';
1055: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1056: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1057: END IF;
1058:
1059: OPEN c_documents(p_checkrun_id);
1060: FETCH c_documents BULK COLLECT INTO l_documents;

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

1074: where checkrun_id = p_checkrun_id;
1075:
1076: l_debug_info := 'group all documents';
1077: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1078: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1079: END IF;
1080:
1081: --initialize the previous variables
1082:

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

1145: if l_maximize_credits_flag = 'Y' then
1146:
1147: l_debug_info := 'reduce credit memo amounts';
1148: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1149: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1150: END IF;
1151:
1152: --now everything should be grouped, let's go through and determine which
1153: --credit memos need to be reduced or set to not pay

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

1206:
1207:
1208: l_debug_info := 'update grouping numbers, ok to pay flags, and amounts';
1209: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1210: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1211: END IF;
1212:
1213:
1214:

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

1367: l_current_calling_sequence := p_current_calling_sequence || '<-create_checkrun';
1368:
1369: l_debug_info := 'select checkrun_id';
1370: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1371: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1372: END IF;
1373:
1374:
1375: select ap_inv_selection_criteria_s.nextval

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

1379:
1380:
1381: l_debug_info := 'insert into ap_inv_selection_criteria_all';
1382: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1383: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1384: END IF;
1385:
1386: insert into ap_inv_selection_criteria_all(
1387: check_date,

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

1466:
1467:
1468: l_debug_info := 'insert into ap_le_group';
1469: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1470: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1471: END IF;
1472:
1473: insert into ap_le_group (
1474: legal_entity_id,

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

1493:
1494:
1495: l_debug_info := 'insert into AP_OU_GROUP';
1496: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1497: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1498: END IF;
1499:
1500: insert into AP_OU_GROUP (
1501: org_id,

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

1519: and appt.ou_group_option = 'SPECIFY';
1520:
1521: l_debug_info := 'insert into AP_CURRENCY_GROUP';
1522: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1523: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1524: END IF;
1525:
1526:
1527: insert into AP_CURRENCY_GROUP (

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

1546: and appt.currency_group_option = 'SPECIFY';--Bug6926344
1547:
1548: l_debug_info := 'insert into AP_PAY_GROUP';
1549: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1550: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1551: END IF;
1552:
1553: insert into AP_PAY_GROUP (
1554: vendor_pay_group,

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

2460: l_current_calling_sequence := 'select invoices';
2461:
2462: l_debug_info := 'Check to see if creating checkrun from template';
2463: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2464: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
2465: END IF;
2466:
2467: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2468: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

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

2502:
2503:
2504: l_debug_info := 'Select data from ap_invoice_selection_criteria';
2505: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2506: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
2507: END IF;
2508:
2509: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2510: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

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

2631:
2632:
2633: l_debug_info := 'l_checkrun_id = '|| to_char(l_checkrun_id);
2634: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2635: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
2636: END IF;
2637:
2638: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2639: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

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

2641:
2642:
2643: l_debug_info := 'See if encumbrances are turned on';
2644: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2645: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
2646: END IF;
2647:
2648: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2649: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

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

2669: if l_encumbrance_flag = 1 then
2670:
2671: l_debug_info := 'Open payment schedules cursor - encumbrances are on';
2672: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2673: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
2674: END IF;
2675:
2676: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2677: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

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

2813:
2814:
2815: l_debug_info := 'Update ap_payment_schedules_all: encumbrances are on';
2816: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2817: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
2818: END IF;
2819:
2820: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2821: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

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

2832:
2833:
2834: l_debug_info := 'Insert into ap_selected_invoices_all: encumbrances are on';
2835: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2836: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
2837: END IF;
2838:
2839: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2840: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

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

3031: else --no encumbrances used
3032:
3033: l_debug_info := 'Open payment schedules cursor- encumbrances are off';
3034: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3035: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
3036: END IF;
3037:
3038: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3039: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

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

3177: LIMIT 1000;
3178:
3179: l_debug_info := 'Update ap_payment_schedules_all: encumbrances are off';
3180: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3181: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
3182: END IF;
3183:
3184: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3185: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

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

3196:
3197:
3198: l_debug_info := 'Insert into ap_selected_invoices_all: encumbrances are off';
3199: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3200: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
3201: END IF;
3202:
3203: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3204: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

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

3400:
3401:
3402: l_debug_info := 'Done Inserting Into Ap_Selected_Invoices_AlL';
3403: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3404: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
3405: END IF;
3406:
3407: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3408: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

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

3459:
3460:
3461: l_debug_info := 'Calling Remove_Invoices';
3462: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3463: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
3464: END IF;
3465:
3466: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3467: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

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

3470: remove_invoices(l_checkrun_id,l_current_calling_sequence);
3471:
3472: l_debug_info := 'Calling Insert_UnselectedL';
3473: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3474: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
3475: END IF;
3476:
3477: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3478: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

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

3499:
3500:
3501: l_debug_info := 'Update amounts in ap_selected_invoices';
3502: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3503: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
3504: END IF;
3505:
3506: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3507: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

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

3616:
3617:
3618: l_debug_info := 'Round amounts in ap_selected_invoices';
3619: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3620: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
3621: END IF;
3622:
3623: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3624: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

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

3645: AND amount_remaining = 0;
3646:
3647: l_debug_info := 'Calling Calculate_Interest';
3648: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3649: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
3650: END IF;
3651:
3652: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3653: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

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

3662:
3663:
3664: l_debug_info := 'Calling ap_withholding_pkg';
3665: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3666: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
3667: END IF;
3668:
3669: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3670: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

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

3682:
3683: --Bug6459578
3684: l_debug_info := 'Calling ap_custom_withholding_pkg';
3685: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3686: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
3687: END IF;
3688:
3689: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3690: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

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

3722:
3723:
3724: l_debug_info := 'updating exchange rate info';
3725: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3726: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
3727: END IF;
3728:
3729: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3730: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

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

3833:
3834:
3835: l_debug_info := 'Grouping selected invoices';
3836: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3837: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
3838: END IF;
3839:
3840: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3841: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

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

3866: where checkrun_id = l_checkrun_id;
3867:
3868: commit;
3869:
3870: fnd_file.put_line(FND_FILE.LOG, 'No scheduled payments matched the invoice selection criteria');
3871:
3872: l_debug_info := 'No scheduled payments matched the invoice selection criteria';
3873: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3874: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

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

3909: FND_MSG_PUB.Get( p_msg_index => i,
3910: p_encoded => 'F',
3911: p_data => l_msg_data,
3912: p_msg_index_out => l_msg_index_out);
3913: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
3914: End LOOP;
3915: end if;
3916: end if;
3917: end;

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

3969: if l_batch_status = 'SELECTED' and l_payables_review_settings <> 'Y' then
3970:
3971: l_debug_info := 'Submitting Oracle Payments Build';
3972: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3973: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
3974: END IF;
3975:
3976: l_req_id := FND_REQUEST.SUBMIT_REQUEST(
3977: 'IBY',

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

4012: chr(0));
4013:
4014: l_debug_info := 'request_id ='||to_char(l_req_id);
4015: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4016: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
4017: END IF;
4018:
4019: end if;
4020:

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

4426: FND_MSG_PUB.Get( p_msg_index => i,
4427: p_encoded => 'F',
4428: p_data => l_msg_data,
4429: p_msg_index_out => l_msg_index_out);
4430: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
4431: End LOOP;
4432: end if;
4433: end if;
4434: end;

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

4672:
4673: l_current_calling_sequence := 'ap_autoselect_pkg.selection_criteria_report';
4674: l_debug_info:= 'select from ap_inv_selection_criteria_all';
4675:
4676: fnd_file.put_line(fnd_file.output, '');
4677:
4678: l_qryCtx := DBMS_XMLGEN.newContext(
4679: 'select aisc.checkrun_name, aisc.pay_from_date, aisc.pay_thru_date,
4680: aisc.hi_payment_priority, aisc.low_payment_priority,

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

4762: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4763: DBMS_XMLGEN.closeContext(l_qryCtx);
4764: ap_utilities_pkg.clob_to_file(l_result_clob);
4765:
4766: fnd_file.put_line(fnd_file.output, '');
4767:
4768: EXCEPTION
4769:
4770: WHEN OTHERS then