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_PMT_CALLOUT_PKG dependencies on FND_LOG

Line 13: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

9: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
10: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
11: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
12:
13: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

Line 14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

10: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
11: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
12:
13: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

11: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
12:
13: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

12:
13: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'AP.PLSQL.AP_PMT_CALLOUT_PKG.';

Line 17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

13: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'AP.PLSQL.AP_PMT_CALLOUT_PKG.';
21:

Line 18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'AP.PLSQL.AP_PMT_CALLOUT_PKG.';
21:
22: FUNCTION get_user_rate (p_base_currency_code in varchar2,

Line 19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'AP.PLSQL.AP_PMT_CALLOUT_PKG.';
21:
22: FUNCTION get_user_rate (p_base_currency_code in varchar2,
23: p_payment_currency_code in varchar2,

Line 43: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

39: and payment_currency_code = p_payment_currency_code;
40:
41: l_debug_info := 'User exchange rate returned : '||l_rate;
42: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
43: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
44: END IF;
45:
46: return l_rate;
47:

Line 334: -- Bug 5512197.Adding Fnd_Logging for this procedure

330: x_return_status := FND_API.G_RET_STS_SUCCESS;
331:
332: l_api_name := 'assign_sequences';
333:
334: -- Bug 5512197.Adding Fnd_Logging for this procedure
335: l_debug_info := 'opening check_sequences cursor ';
336: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
337: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
338: END IF;

Line 337: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

333:
334: -- Bug 5512197.Adding Fnd_Logging for this procedure
335: l_debug_info := 'opening check_sequences cursor ';
336: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
337: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
338: END IF;
339:
340: open check_sequences;
341: loop

Line 348: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

344: exit when check_sequences%notfound;
345:
346: l_debug_info := 'calling CE_BANK_AND_ACCOUNT_VALIDATION.get_pay_doc_cat ';
347: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
348: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
349: END IF;
350:
351: CE_BANK_AND_ACCOUNT_VALIDATION.get_pay_doc_cat(l_payment_document_id,
352: l_payment_method_code,

Line 360: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

356:
357:
358: l_debug_info := 'Value of doc category code from CE API: '|| l_doc_category_code;
359: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
360: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
361: END IF;
362:
363:
364: -- Bug 5555642. Added fnd-logging and messages for sequence numbering

Line 364: -- Bug 5555642. Added fnd-logging and messages for sequence numbering

360: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
361: END IF;
362:
363:
364: -- Bug 5555642. Added fnd-logging and messages for sequence numbering
365: --if p_seq_num_profile = 'A' and l_doc_category_code = '-1' then
366: -- Bug 5555642
367: if l_doc_category_code = '-1' then
368: -- x_return_status:= FND_API.G_RET_STS_ERROR; --Bug6258525

Line 381: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

377: 'always used';
378: x_return_status:= FND_API.G_RET_STS_ERROR; --Bug6258525
379: end if;
380: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
381: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
382: END IF;
383:
384: return;
385:

Line 394: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

390: if l_doc_category_code <> '-1' then
391:
392: l_debug_info := 'calling fnd_seqnum.get_seq_info ';
393: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
394: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
395: END IF;
396:
397: l_debug_info := 'set_of_books_id: '||p_set_of_books_id||' check_date: '||
398: to_char(p_check_date, 'DD-MON-YYYY');

Line 400: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

396:
397: l_debug_info := 'set_of_books_id: '||p_set_of_books_id||' check_date: '||
398: to_char(p_check_date, 'DD-MON-YYYY');
399: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
400: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
401: END IF;
402:
403:
404: l_return_code := fnd_seqnum.get_seq_info(

Line 445: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

441: END IF;
442:
443: l_debug_info := 'Return Code from fnd_seqnum.get_seq_info: '||l_return_code;
444: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
445: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
446: END IF;
447:
448: l_debug_info := 'docseq_id: '||l_docseq_id||', docseq_type: '||l_docseq_type
449: ||' ,docseq_name: '||l_docseq_name;

Line 451: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

447:
448: l_debug_info := 'docseq_id: '||l_docseq_id||', docseq_type: '||l_docseq_type
449: ||' ,docseq_name: '||l_docseq_name;
450: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
451: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
452: END IF;
453:
454: l_debug_info := 'db_seq_name: '||l_db_seq_name||', seq_ass_id: '||l_seq_ass_id;
455: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 456: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

452: END IF;
453:
454: l_debug_info := 'db_seq_name: '||l_db_seq_name||', seq_ass_id: '||l_seq_ass_id;
455: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
456: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
457: END IF;
458:
459:
460: l_debug_info := 'prd_tab_name: '||l_prd_tab_name||', aud_tab_name: '||l_aud_tab_name;

Line 462: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

458:
459:
460: l_debug_info := 'prd_tab_name: '||l_prd_tab_name||', aud_tab_name: '||l_aud_tab_name;
461: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
462: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
463: END IF;
464:
465:
466: if x_msg_data is not null then

Line 471: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

467: x_return_status:= FND_API.G_RET_STS_ERROR;
468: x_msg_count:= 1;
469: l_debug_info := x_msg_data;
470: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
471: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
472: END IF;
473: return;
474: else
475: l_debug_info := 'FND_SEQNUM.Get_Seq_Info returned succesfully';

Line 477: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

473: return;
474: else
475: l_debug_info := 'FND_SEQNUM.Get_Seq_Info returned succesfully';
476: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
477: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
478: END IF;
479:
480: end if;
481:

Line 497: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

493: 'N');
494:
495: l_debug_info := 'Return Code from fnd_seqnum.get_seq_val: '||l_return_code;
496: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
497: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
498: END IF;
499:
500: l_debug_info := 'seq_val: '||l_seqval||', docseq_d: '||l_dbseqid;
501: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 502: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

498: END IF;
499:
500: l_debug_info := 'seq_val: '||l_seqval||', docseq_d: '||l_dbseqid;
501: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
502: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
503: END IF;
504:
505: if l_return_code <> 0 or l_seqval is null then
506:

Line 1087: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1083:
1084: l_debug_info := 'get displayed Field';
1085: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1086: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1087: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1088: END IF;
1089:
1090: SELECT displayed_field
1091: INTO l_nls_int_inv_desc

Line 1123: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1119:
1120: l_debug_info := 'get_relevant_checkrun_ids';
1121: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1122: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1123: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1124: END IF;
1125:
1126: OPEN c_relevant_checkrun_ids;
1127: FETCH c_relevant_checkrun_ids

Line 1140: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1136:
1137: l_debug_info := 'l_checkrun_id: '||to_char(l_checkrun_id);
1138: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1139: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1140: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1141: END IF;
1142:
1143: l_debug_info := 'get_checkrun_info';
1144: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

Line 1146: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1142:
1143: l_debug_info := 'get_checkrun_info';
1144: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1145: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1146: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1147: END IF;
1148:
1149: SELECT exchange_rate_type,
1150: transfer_priority,

Line 1165: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1161:
1162: l_debug_info := 'get_terms';
1163: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1164: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1165: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1166: END IF;
1167:
1168: BEGIN
1169: --these are not multi-org table so should be fine

Line 1186: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1182:
1183: l_debug_info := 'get_profiles';
1184: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1185: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1186: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1187: END IF;
1188: fnd_profile.get('UNIQUE:SEQ_NUMBERS',l_seq_num_profile);
1189: fnd_profile.get('AP_USE_INV_BATCH_CONTROLS', l_batch_control_flag);
1190:

Line 1196: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1192:
1193: l_debug_info := 'c_relevant_orgs';
1194: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1195: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1196: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1197: END IF;
1198:
1199: LOOP
1200: FETCH c_relevant_orgs INTO l_current_org_id;

Line 1206: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1202:
1203: l_debug_info := 'l_current_org_id: '||to_char(l_current_org_id);
1204: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1205: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1206: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1207: END IF;
1208: l_debug_info := 'get_org_info';
1209: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1210: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1211: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1207: END IF;
1208: l_debug_info := 'get_org_info';
1209: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1210: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1211: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1212: END IF;
1213:
1214: /* Bug 5124784. dist_code_combination_id, proration across distribution will
1215: decided by parent invoice */

Line 1268: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1264:
1265: l_debug_info := 'do interest invoice insertions';
1266: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1267: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1268: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1269: END IF;
1270:
1271: INSERT INTO ap_invoices_all(
1272: invoice_id,

Line 1414: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1410:
1411: l_debug_info := 'do interest invoice line insertions';
1412: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1413: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1414: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1415: END IF;
1416:
1417:
1418: INSERT INTO ap_invoice_lines_all(

Line 1497: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1493:
1494: l_debug_info := 'do ap_create_batch_interest_dists';
1495: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1496: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1497: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1498: END IF;
1499:
1500: /* Bug 5124784. Distribution for interest invoice will be created via
1501: interest invoice package. */

Line 1520: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1516:
1517: l_debug_info := 'INSERT INTO ap_payment_schedules_all';
1518: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1519: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1520: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1521: END IF;
1522:
1523: INSERT INTO ap_payment_schedules_all(
1524: invoice_id,

Line 1602: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1598:
1599: l_debug_info := 'INSERT INTO ap_invoice_relationships';
1600: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1601: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1602: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1603: END IF;
1604:
1605: INSERT INTO ap_invoice_relationships(
1606: original_invoice_id,

Line 1644: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1640:
1641: l_debug_info := 'INSERT INTO ap_batches_all';
1642: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1643: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1644: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1645: END IF;
1646:
1647: INSERT INTO ap_batches_all(
1648: batch_id,

Line 1689: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1685:
1686: l_debug_info := 'insert into ap_checks_all';
1687: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1688: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1689: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1690: END IF;
1691:
1692: INSERT INTO ap_checks_all
1693: (CHECK_ID,

Line 1894: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1890: l_debug_info := 'l_check_count: '||to_char(l_check_count);
1891: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1892:
1893: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1894: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1895: END IF;
1896:
1897: l_debug_info := 'l_total_check_count: '||to_char(l_total_check_count);
1898: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

Line 1901: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1897: l_debug_info := 'l_total_check_count: '||to_char(l_total_check_count);
1898: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1899:
1900: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1901: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1902: END IF;
1903:
1904: l_debug_info := 'l_current_org_id: '||to_char(l_current_org_id);
1905: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

Line 1907: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1903:
1904: l_debug_info := 'l_current_org_id: '||to_char(l_current_org_id);
1905: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1906: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1907: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1908: END IF;
1909:
1910:
1911: l_debug_info := 'create accounting';

Line 1914: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1910:
1911: l_debug_info := 'create accounting';
1912: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1913: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1914: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1915: END IF;
1916:
1917: AP_ACCOUNTING_EVENTS_PKG.create_payment_batch_events(
1918: p_checkrun_name => l_checkrun_name,

Line 1931: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1927:
1928: l_debug_info := 'AP_ACCOUNTING_EVENTS_PKG.update_pmt_batch_event_status';
1929: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1930: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1931: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1932: END IF;
1933:
1934: AP_ACCOUNTING_EVENTS_PKG.update_pmt_batch_event_status(
1935: p_checkrun_name => l_checkrun_name,

Line 1947: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1943:
1944: l_debug_info := 'UPDATE ap_selected_invoices_all';
1945: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1946: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1947: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1948: END IF;
1949:
1950: UPDATE ap_selected_invoices_all ASI
1951: SET ASI.invoice_payment_id = ap_invoice_payments_s.nextval

Line 1969: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1965:
1966: l_debug_info := ' UPDATE ap_awt_temp_distributions_all';
1967: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1968: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1969: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1970: END IF;
1971:
1972: UPDATE ap_awt_temp_distributions_all AATD
1973: SET AATD.invoice_payment_id =

Line 1997: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1993:
1994: l_debug_info := 'AP_WITHHOLDING_PKG.AP_WITHHOLD_CONFIRM';
1995: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1996: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1997: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1998: END IF;
1999: AP_WITHHOLDING_PKG.AP_WITHHOLD_CONFIRM(l_checkrun_name,
2000: l_last_updated_by,
2001: --4863216

Line 2014: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2010:
2011: l_debug_info := 'DELETE FROM ap_awt_temp_distributions_all';
2012: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2013: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2014: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2015: END IF;
2016:
2017: /* Bug 5383066. Foloowing Delete is not requeired. As call to
2018: AP_WITHHOLDING_PKG.AP_WITHHOLD_CANCEL cleans up temporary withholding dists.

Line 2056: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2052:
2053: l_debug_info := 'UPDATE ap_payment_schedules_all';
2054: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2055: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2056: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2057: END IF;
2058:
2059:
2060: FORALL i IN 1..invoice_id_ps_l.COUNT

Line 2087: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2083: -- Bug 5658623. Cursor Processing for Performance
2084: l_debug_info := 'Opening Cursor for updating invoices via Forall';
2085: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2086: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2087: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2088: END IF;
2089:
2090: OPEN c_invoice_amounts(l_last_updated_by
2091: ,p_completed_pmts_group_id

Line 2110: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2106:
2107: l_debug_info := 'UPDATE ap_invoices_all';
2108: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2109: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2110: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2111: END IF;
2112:
2113: FORALL i IN 1..invoice_id_inv_l.COUNT
2114: UPDATE ap_invoices_all

Line 2132: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2128:
2129: l_debug_info := 'insert into ap_invoice_payments_all';
2130: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2131: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2132: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2133: END IF;
2134:
2135: INSERT INTO ap_invoice_payments_all(
2136: INVOICE_PAYMENT_ID,

Line 2376: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2372:
2373: l_debug_info := 'AP_CHECKS_PKG.Subscribe_To_Payment_Event';
2374: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2375: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2376: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2377: END IF;
2378:
2379: /* Bug 9868737 Wrapped call to subscribe_to_payment_event in
2380: a block and changed error handling so that errors in

Line 2413: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2409:
2410: l_debug_info := 'AP_DBI_PKG.Insert_Payment_Confirm_DBI';
2411: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2412: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2413: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2414: END IF;
2415: AP_DBI_PKG.Insert_Payment_Confirm_DBI(
2416: p_checkrun_name => l_checkrun_name,
2417: p_base_currency_code => l_base_currency_code,

Line 2424: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2420:
2421: l_debug_info := 'AP_Accounting_Events_Pkg.Batch_Update_Payment_Info';
2422: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2423: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2424: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2425: END IF;
2426: AP_Accounting_Events_Pkg.Batch_Update_Payment_Info(
2427: p_checkrun_name => l_checkrun_name,
2428: p_completed_pmts_group_id => p_completed_pmts_group_id,

Line 2436: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2432: -- Bug 5658623. Cursor Processing for Performance
2433: l_debug_info := 'Opening Cursor for updating payment schedules via Forall';
2434: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2435: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2436: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2437: END IF;
2438:
2439: /* OPEN c_schedule_amounts(l_last_updated_by --Bug5733731
2440: ,p_completed_pmts_group_id

Line 2459: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2455: LIMIT 1000;
2456:
2457: l_debug_info := 'UPDATE ap_payment_schedules_all';
2458: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2459: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2460: END IF;
2461:
2462: FORALL i IN 1..invoice_id_ps_l.COUNT
2463: UPDATE ap_payment_schedules_all

Line 2481: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2477:
2478: -- Bug 5658623. Cursor Processing for Performance
2479: l_debug_info := 'Opening Cursor for updating invoices via Forall';
2480: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2481: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2482: END IF;
2483:
2484: OPEN c_invoice_amounts(l_last_updated_by
2485: ,p_completed_pmts_group_id

Line 2503: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2499: LIMIT 1000;
2500:
2501: l_debug_info := 'UPDATE ap_invoices_all';
2502: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2503: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2504: END IF;
2505:
2506: FORALL i IN 1..invoice_id_inv_l.COUNT
2507: UPDATE ap_invoices_all

Line 2562: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2558:
2559:
2560: l_debug_info := 'UPDATE ap_invoices_all';
2561: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2562: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2563: END IF;
2564:
2565:
2566: --bug5020577

Line 2601: -- Bug 5512197. Adding the following for fnd logging

2597: and ibypmts.org_type = 'OPERATING_UNIT'
2598: AND ibypmts.org_id = l_current_org_id)
2599: AND invoice_type_lookup_code <> 'INTEREST';
2600: */
2601: -- Bug 5512197. Adding the following for fnd logging
2602: l_debug_info := 'Sequential Numbering Option: '||l_seq_num_profile;
2603: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2604: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2605: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 2605: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2601: -- Bug 5512197. Adding the following for fnd logging
2602: l_debug_info := 'Sequential Numbering Option: '||l_seq_num_profile;
2603: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2604: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2605: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2606: END IF;
2607:
2608: IF l_seq_num_profile IN ('A','P') then
2609:

Line 2613: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2609:
2610: l_debug_info := 'assign_sequences';
2611: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2612: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2613: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2614: END IF;
2615:
2616: --bug15924350 add checkrun_id to parameters in this call
2617: assign_sequences(l_checkrun_id,

Line 2640: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2636: IF l_seq_num_profile NOT IN ('A','P') and l_first_voucher_number is not null then
2637: l_debug_info := 'assign_vouchers';
2638: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2639: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2640: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2641: END IF;
2642: assign_vouchers(p_completed_pmts_group_id,
2643: l_checkrun_id,
2644: l_first_voucher_number,

Line 2654: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2650:
2651: l_debug_info := 'AP_WITHHOLDING_PKG.AP_WITHHOLD_CANCEL';
2652: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2653: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2654: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2655: END IF;
2656:
2657: AP_WITHHOLDING_PKG.AP_WITHHOLD_CANCEL(l_checkrun_name,
2658: l_last_updated_by,

Line 2674: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2670:
2671: l_debug_info := 'AP_PAYMENT_EVENT_PKG.raise_payment_batch_events';
2672: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2673: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2674: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2675: END IF;
2676:
2677: /* Added for Bug#9459810 Start */
2678: l_wf_event_exists :=0;

Line 2706: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2702:
2703: l_debug_info := 'DELETE FROM ap_selected_invoices_all';
2704: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2705: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2706: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2707: END IF;
2708:
2709: DELETE FROM ap_selected_invoices_all
2710: WHERE checkrun_id = l_checkrun_id

Line 2729: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2725:
2726: l_debug_info := 'DELETE FROM ap_unselected_invoices_all';
2727: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2728: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2729: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2730: END IF;
2731:
2732: DELETE FROM ap_unselected_invoices_all
2733: WHERE checkrun_id = l_checkrun_id;

Line 2757: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2753: fnd_file.put_line(FND_FILE.LOG,'AP DOCS COUNT: '||TO_CHAR(l_total_docs_count)||' - '||systimestamp);
2754:
2755:
2756: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2757: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2758: l_debug_info := 'IBY CHECK COUNT: '||TO_CHAR(l_iby_check_count);
2759: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2760: l_debug_info := 'IBY DOC COUNT: '||TO_CHAR(l_iby_docs_count);
2761: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 2759: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2755:
2756: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2757: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2758: l_debug_info := 'IBY CHECK COUNT: '||TO_CHAR(l_iby_check_count);
2759: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2760: l_debug_info := 'IBY DOC COUNT: '||TO_CHAR(l_iby_docs_count);
2761: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2762: l_debug_info := 'AP CHECK COUNT: '||TO_CHAR(l_total_check_count);
2763: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 2761: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2757: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2758: l_debug_info := 'IBY CHECK COUNT: '||TO_CHAR(l_iby_check_count);
2759: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2760: l_debug_info := 'IBY DOC COUNT: '||TO_CHAR(l_iby_docs_count);
2761: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2762: l_debug_info := 'AP CHECK COUNT: '||TO_CHAR(l_total_check_count);
2763: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2764: l_debug_info := 'AP DOCS COUNT: '||TO_CHAR(l_total_docs_count);
2765: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 2763: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2759: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2760: l_debug_info := 'IBY DOC COUNT: '||TO_CHAR(l_iby_docs_count);
2761: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2762: l_debug_info := 'AP CHECK COUNT: '||TO_CHAR(l_total_check_count);
2763: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2764: l_debug_info := 'AP DOCS COUNT: '||TO_CHAR(l_total_docs_count);
2765: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2766:
2767: END IF;

Line 2765: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2761: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2762: l_debug_info := 'AP CHECK COUNT: '||TO_CHAR(l_total_check_count);
2763: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2764: l_debug_info := 'AP DOCS COUNT: '||TO_CHAR(l_total_docs_count);
2765: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2766:
2767: END IF;
2768:
2769: --Bug 5115363

Line 2780: --regardless of the runtime fnd log level.

2776:
2777: --Bug 9074840 Add additional debug queries
2778:
2779: --As this is an error condition it will be written to the concurrent log
2780: --regardless of the runtime fnd log level.
2781: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME);
2782: l_debug_info := fnd_message.get;
2783: FND_FILE.PUT_LINE(FND_FILE.LOG, l_debug_info);
2784:

Line 2911: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2907: BEGIN
2908:
2909: l_debug_info := 'Creating Savepoint';
2910: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2911: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2912: END IF;
2913:
2914: -- Standard Start of API savepoint
2915: SAVEPOINT Payments_Voided_PUB;

Line 2919: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2915: SAVEPOINT Payments_Voided_PUB;
2916:
2917: l_debug_info := 'Checking API Compatibility';
2918: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2919: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2920: END IF;
2921:
2922: -- Standard call to check for call compatibility.
2923: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 2938: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2934: END IF;
2935:
2936: l_debug_info := 'Calling AP Void Pkg.Iby_Void_Check';
2937: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2938: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2939: END IF;
2940:
2941: -- Initialize API return status to success
2942: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2958: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2954: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2955:
2956: l_debug_info := 'AP Void Pkg.Iby_Void_Check returns error';
2957: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2958: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2959: END IF;
2960:
2961: ROLLBACK TO Payments_Voided_PUB; --4945922
2962: ELSE

Line 2965: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2961: ROLLBACK TO Payments_Voided_PUB; --4945922
2962: ELSE
2963: l_debug_info := 'AP Void Pkg.Iby_Void_Check returns success';
2964: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2965: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2966: END IF;
2967:
2968: --COMMIT WORK;
2969: END IF;

Line 3019: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3015: BEGIN
3016:
3017: l_debug_info := 'Creating Savepoint';
3018: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3019: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3020: END IF;
3021:
3022: l_debug_info := 'Checking API Compatibility';
3023: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3024: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3020: END IF;
3021:
3022: l_debug_info := 'Checking API Compatibility';
3023: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3024: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3025: END IF;
3026:
3027: -- Standard call to check for call compatibility.
3028: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 3043: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3039: END IF;
3040:
3041: l_debug_info := 'Calling ap_bank_charge_pkg.ap_JapanBankChargeHook';
3042: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3043: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3044: END IF;
3045:
3046: ap_bank_charge_pkg.ap_JapanBankChargeHook(
3047: p_api_version ,

Line 3102: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3098: BEGIN
3099:
3100: l_debug_info := 'In Payment_Stop_Initiated';
3101: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3102: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3103: END IF;
3104:
3105: l_debug_info := 'Payment_id from IBY API: '||p_payment_id;
3106: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3107: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3103: END IF;
3104:
3105: l_debug_info := 'Payment_id from IBY API: '||p_payment_id;
3106: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3107: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3108: END IF;
3109:
3110: update ap_checks_all
3111: set status_lookup_code = 'STOP INITIATED',

Line 3141: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3137: BEGIN
3138:
3139: l_debug_info := 'In Payment_Stop_Released';
3140: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3141: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3142: END IF;
3143:
3144: l_debug_info := 'Payment_id from IBY API: '||p_payment_id;
3145: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3146: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3142: END IF;
3143:
3144: l_debug_info := 'Payment_id from IBY API: '||p_payment_id;
3145: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3146: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3147: END IF;
3148:
3149: update ap_checks_all
3150: set status_lookup_code = 'NEGOTIABLE',