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 284: -- Bug 5512197.Adding Fnd_Logging for this procedure

280: x_return_status := FND_API.G_RET_STS_SUCCESS;
281:
282: l_api_name := 'assign_sequences';
283:
284: -- Bug 5512197.Adding Fnd_Logging for this procedure
285: l_debug_info := 'opening check_sequences cursor ';
286: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
287: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
288: END IF;

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

283:
284: -- Bug 5512197.Adding Fnd_Logging for this procedure
285: l_debug_info := 'opening check_sequences cursor ';
286: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
287: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
288: END IF;
289:
290: open check_sequences;
291: loop

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

294: exit when check_sequences%notfound;
295:
296: l_debug_info := 'calling CE_BANK_AND_ACCOUNT_VALIDATION.get_pay_doc_cat ';
297: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
298: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
299: END IF;
300:
301: CE_BANK_AND_ACCOUNT_VALIDATION.get_pay_doc_cat(l_payment_document_id,
302: l_payment_method_code,

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

306:
307:
308: l_debug_info := 'Value of doc category code from CE API: '|| l_doc_category_code;
309: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
310: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
311: END IF;
312:
313:
314: -- Bug 5555642. Added fnd-logging and messages for sequence numbering

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

310: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
311: END IF;
312:
313:
314: -- Bug 5555642. Added fnd-logging and messages for sequence numbering
315: --if p_seq_num_profile = 'A' and l_doc_category_code = '-1' then
316: -- Bug 5555642
317: if l_doc_category_code = '-1' then
318: -- x_return_status:= FND_API.G_RET_STS_ERROR; --Bug6258525

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

327: 'always used';
328: x_return_status:= FND_API.G_RET_STS_ERROR; --Bug6258525
329: end if;
330: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
331: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
332: END IF;
333:
334: return;
335:

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

340: if l_doc_category_code <> '-1' then
341:
342: l_debug_info := 'calling fnd_seqnum.get_seq_info ';
343: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
344: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
345: END IF;
346:
347: l_debug_info := 'set_of_books_id: '||p_set_of_books_id||' check_date: '||
348: to_char(p_check_date, 'DD-MON-YYYY');

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

346:
347: l_debug_info := 'set_of_books_id: '||p_set_of_books_id||' check_date: '||
348: to_char(p_check_date, 'DD-MON-YYYY');
349: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
350: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
351: END IF;
352:
353:
354: l_return_code := fnd_seqnum.get_seq_info(

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

391: END IF;
392:
393: l_debug_info := 'Return Code from fnd_seqnum.get_seq_info: '||l_return_code;
394: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
395: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
396: END IF;
397:
398: l_debug_info := 'docseq_id: '||l_docseq_id||', docseq_type: '||l_docseq_type
399: ||' ,docseq_name: '||l_docseq_name;

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

397:
398: l_debug_info := 'docseq_id: '||l_docseq_id||', docseq_type: '||l_docseq_type
399: ||' ,docseq_name: '||l_docseq_name;
400: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
401: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
402: END IF;
403:
404: l_debug_info := 'db_seq_name: '||l_db_seq_name||', seq_ass_id: '||l_seq_ass_id;
405: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

402: END IF;
403:
404: l_debug_info := 'db_seq_name: '||l_db_seq_name||', seq_ass_id: '||l_seq_ass_id;
405: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
406: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
407: END IF;
408:
409:
410: l_debug_info := 'prd_tab_name: '||l_prd_tab_name||', aud_tab_name: '||l_aud_tab_name;

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

408:
409:
410: l_debug_info := 'prd_tab_name: '||l_prd_tab_name||', aud_tab_name: '||l_aud_tab_name;
411: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
412: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
413: END IF;
414:
415:
416: if x_msg_data is not null then

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

417: x_return_status:= FND_API.G_RET_STS_ERROR;
418: x_msg_count:= 1;
419: l_debug_info := x_msg_data;
420: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
421: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
422: END IF;
423: return;
424: else
425: l_debug_info := 'FND_SEQNUM.Get_Seq_Info returned succesfully';

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

423: return;
424: else
425: l_debug_info := 'FND_SEQNUM.Get_Seq_Info returned succesfully';
426: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
427: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
428: END IF;
429:
430: end if;
431:

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

443: 'N');
444:
445: l_debug_info := 'Return Code from fnd_seqnum.get_seq_val: '||l_return_code;
446: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
447: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
448: END IF;
449:
450: l_debug_info := 'seq_val: '||l_seqval||', docseq_d: '||l_dbseqid;
451: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

448: END IF;
449:
450: l_debug_info := 'seq_val: '||l_seqval||', docseq_d: '||l_dbseqid;
451: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
452: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
453: END IF;
454:
455: if l_return_code <> 0 or l_seqval is null then
456:

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

886:
887:
888: l_debug_info := 'get displayed Field';
889: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
890: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
891: END IF;
892:
893: SELECT displayed_field
894: INTO l_nls_int_inv_desc

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

921: x_return_status := FND_API.G_RET_STS_SUCCESS;
922:
923: l_debug_info := 'get_relevant_checkrun_ids';
924: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
925: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
926: END IF;
927:
928: OPEN c_relevant_checkrun_ids;
929: FETCH c_relevant_checkrun_ids

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

937: l_checkrun_id := l_checkrun_id_list(i);
938:
939: l_debug_info := 'l_checkrun_id: '||to_char(l_checkrun_id);
940: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
941: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
942: END IF;
943:
944: l_debug_info := 'get_checkrun_info';
945: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

942: END IF;
943:
944: l_debug_info := 'get_checkrun_info';
945: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
946: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
947: END IF;
948:
949: SELECT exchange_rate_type,
950: transfer_priority,

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

960: WHERE checkrun_id = l_checkrun_id;
961:
962: l_debug_info := 'get_terms';
963: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
964: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
965: END IF;
966:
967: BEGIN
968: --these are not multi-org table so should be fine

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

980: l_last_updated_by := to_number(FND_GLOBAL.USER_ID);
981:
982: l_debug_info := 'get_profiles';
983: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
984: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
985: END IF;
986: fnd_profile.get('UNIQUE:SEQ_NUMBERS',l_seq_num_profile);
987: fnd_profile.get('AP_USE_INV_BATCH_CONTROLS', l_batch_control_flag);
988:

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

989: OPEN c_relevant_orgs(l_checkrun_id);
990:
991: l_debug_info := 'c_relevant_orgs';
992: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
993: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
994: END IF;
995:
996: LOOP
997: FETCH c_relevant_orgs INTO l_current_org_id;

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

998: EXIT WHEN c_relevant_orgs%NOTFOUND;
999:
1000: l_debug_info := 'l_current_org_id: '||to_char(l_current_org_id);
1001: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1002: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1003: END IF;
1004: l_debug_info := 'get_org_info';
1005: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1006: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

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

1002: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1003: END IF;
1004: l_debug_info := 'get_org_info';
1005: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1006: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1007: END IF;
1008:
1009: /* Bug 5124784. dist_code_combination_id, proration across distribution will
1010: decided by parent invoice */

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

1057: IF l_auto_calculate_interest_flag = 'Y' THEN
1058:
1059: l_debug_info := 'do interest invoice insertions';
1060: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1061: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1062: END IF;
1063:
1064: INSERT INTO ap_invoices_all(
1065: invoice_id,

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

1222: l_interest_invoice_count := sql%rowcount;
1223:
1224: l_debug_info := 'do interest invoice line insertions';
1225: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1226: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1227: END IF;
1228:
1229: INSERT INTO ap_invoice_lines_all(
1230: INVOICE_ID,

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

1322:
1323:
1324: l_debug_info := 'do ap_create_batch_interest_dists';
1325: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1326: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1327: END IF;
1328:
1329: /* Bug 5124784. Distribution for interest invoice will be created via
1330: interest invoice package. */

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

1344:
1345:
1346: l_debug_info := 'INSERT INTO ap_payment_schedules_all';
1347: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1348: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1349: END IF;
1350:
1351: INSERT INTO ap_payment_schedules_all(
1352: invoice_id,

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

1425:
1426:
1427: l_debug_info := 'INSERT INTO ap_invoice_relationships';
1428: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1429: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1430: END IF;
1431:
1432: INSERT INTO ap_invoice_relationships(
1433: original_invoice_id,

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

1466: IF l_batch_control_flag = 'Y' THEN
1467:
1468: l_debug_info := 'INSERT INTO ap_batches_all';
1469: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1470: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1471: END IF;
1472:
1473: INSERT INTO ap_batches_all(
1474: batch_id,

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

1510: into ap tables*/
1511:
1512: l_debug_info := 'insert into ap_checks_all';
1513: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1514: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1515: END IF;
1516:
1517:
1518: INSERT INTO ap_checks_all

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

1709: l_total_check_count := l_check_count + l_total_check_count;
1710:
1711: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1712: l_debug_info := 'l_check_count: '||to_char(l_check_count);
1713: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1714: l_debug_info := 'l_total_check_count: '||to_char(l_total_check_count);
1715: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1716: END IF;
1717:

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

1711: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1712: l_debug_info := 'l_check_count: '||to_char(l_check_count);
1713: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1714: l_debug_info := 'l_total_check_count: '||to_char(l_total_check_count);
1715: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1716: END IF;
1717:
1718: l_debug_info := 'l_current_org_id: '||to_char(l_current_org_id);
1719: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1716: END IF;
1717:
1718: l_debug_info := 'l_current_org_id: '||to_char(l_current_org_id);
1719: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1720: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1721: END IF;
1722:
1723:
1724: l_debug_info := 'create accounting';

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

1722:
1723:
1724: l_debug_info := 'create accounting';
1725: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1726: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1727: END IF;
1728:
1729: AP_ACCOUNTING_EVENTS_PKG.create_payment_batch_events(
1730: p_checkrun_name => l_checkrun_name,

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

1738: IF l_when_to_account_payment = 'CLEARING ONLY' THEN
1739:
1740: l_debug_info := 'AP_ACCOUNTING_EVENTS_PKG.update_pmt_batch_event_status';
1741: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1742: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1743: END IF;
1744:
1745: AP_ACCOUNTING_EVENTS_PKG.update_pmt_batch_event_status(
1746: p_checkrun_name => l_checkrun_name,

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

1753: --bug8224330
1754:
1755: l_debug_info := 'UPDATE ap_selected_invoices_all';
1756: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1757: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1758: END IF;
1759:
1760: UPDATE ap_selected_invoices_all ASI
1761: SET ASI.invoice_payment_id = ap_invoice_payments_s.nextval

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

1774: IF l_perform_awt_flag = 'Y' THEN
1775:
1776: l_debug_info := ' UPDATE ap_awt_temp_distributions_all';
1777: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1778: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1779: END IF;
1780:
1781: UPDATE ap_awt_temp_distributions_all AATD
1782: SET AATD.invoice_payment_id =

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

1801:
1802:
1803: l_debug_info := 'AP_WITHHOLDING_PKG.AP_WITHHOLD_CONFIRM';
1804: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1805: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1806: END IF;
1807: AP_WITHHOLDING_PKG.AP_WITHHOLD_CONFIRM(l_checkrun_name,
1808: l_last_updated_by,
1809: --4863216

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

1817: l_check_date);
1818:
1819: l_debug_info := 'DELETE FROM ap_awt_temp_distributions_all';
1820: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1821: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1822: END IF;
1823:
1824: /* Bug 5383066. Foloowing Delete is not requeired. As call to
1825: AP_WITHHOLDING_PKG.AP_WITHHOLD_CANCEL cleans up temporary withholding dists.

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

1857: LIMIT 1000;
1858:
1859: l_debug_info := 'UPDATE ap_payment_schedules_all';
1860: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1861: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1862: END IF;
1863:
1864: FORALL i IN 1..invoice_id_ps_l.COUNT
1865: UPDATE ap_payment_schedules_all

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

1882:
1883: -- Bug 5658623. Cursor Processing for Performance
1884: l_debug_info := 'Opening Cursor for updating invoices via Forall';
1885: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1886: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1887: END IF;
1888:
1889: OPEN c_invoice_amounts(l_last_updated_by
1890: ,p_completed_pmts_group_id

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

1904: LIMIT 1000;
1905:
1906: l_debug_info := 'UPDATE ap_invoices_all';
1907: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1908: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1909: END IF;
1910:
1911: FORALL i IN 1..invoice_id_inv_l.COUNT
1912: UPDATE ap_invoices_all

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

1925:
1926:
1927: l_debug_info := 'insert into ap_invoice_payments_all';
1928: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1929: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1930: END IF;
1931:
1932: INSERT INTO ap_invoice_payments_all(
1933: INVOICE_PAYMENT_ID,

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

2173: EXIT WHEN c_subscribed_payments%NOTFOUND;
2174:
2175: l_debug_info := 'AP_CHECKS_PKG.Subscribe_To_Payment_Event';
2176: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2177: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2178: END IF;
2179:
2180: AP_CHECKS_PKG.Subscribe_To_Payment_Event(
2181: P_Event_Type => 'PAYMENT_CREATED',

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

2197:
2198:
2199: l_debug_info := 'AP_DBI_PKG.Insert_Payment_Confirm_DBI';
2200: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2201: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2202: END IF;
2203: AP_DBI_PKG.Insert_Payment_Confirm_DBI(
2204: p_checkrun_name => l_checkrun_name,
2205: p_base_currency_code => l_base_currency_code,

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

2207: p_calling_sequence => l_current_calling_sequence );
2208:
2209: l_debug_info := 'AP_Accounting_Events_Pkg.Batch_Update_Payment_Info';
2210: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2211: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2212: END IF;
2213: AP_Accounting_Events_Pkg.Batch_Update_Payment_Info(
2214: p_checkrun_name => l_checkrun_name,
2215: p_completed_pmts_group_id => p_completed_pmts_group_id,

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

2218:
2219: -- Bug 5658623. Cursor Processing for Performance
2220: l_debug_info := 'Opening Cursor for updating payment schedules via Forall';
2221: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2222: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2223: END IF;
2224:
2225: /* OPEN c_schedule_amounts(l_last_updated_by --Bug5733731
2226: ,p_completed_pmts_group_id

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

2241: LIMIT 1000;
2242:
2243: l_debug_info := 'UPDATE ap_payment_schedules_all';
2244: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2245: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2246: END IF;
2247:
2248: FORALL i IN 1..invoice_id_ps_l.COUNT
2249: UPDATE ap_payment_schedules_all

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

2263:
2264: -- Bug 5658623. Cursor Processing for Performance
2265: l_debug_info := 'Opening Cursor for updating invoices via Forall';
2266: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2267: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2268: END IF;
2269:
2270: OPEN c_invoice_amounts(l_last_updated_by
2271: ,p_completed_pmts_group_id

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

2285: LIMIT 1000;
2286:
2287: l_debug_info := 'UPDATE ap_invoices_all';
2288: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2289: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2290: END IF;
2291:
2292: FORALL i IN 1..invoice_id_inv_l.COUNT
2293: UPDATE ap_invoices_all

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

2344:
2345:
2346: l_debug_info := 'UPDATE ap_invoices_all';
2347: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2348: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2349: END IF;
2350:
2351:
2352: --bug5020577

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

2383: and ibypmts.org_type = 'OPERATING_UNIT'
2384: AND ibypmts.org_id = l_current_org_id)
2385: AND invoice_type_lookup_code <> 'INTEREST';
2386: */
2387: -- Bug 5512197. Adding the following for fnd logging
2388: l_debug_info := 'Sequential Numbering Option: '||l_seq_num_profile;
2389: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2390: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2391: END IF;

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

2386: */
2387: -- Bug 5512197. Adding the following for fnd logging
2388: l_debug_info := 'Sequential Numbering Option: '||l_seq_num_profile;
2389: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2390: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2391: END IF;
2392:
2393: IF l_seq_num_profile IN ('A','P') then
2394:

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

2393: IF l_seq_num_profile IN ('A','P') then
2394:
2395: l_debug_info := 'assign_sequences';
2396: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2397: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2398: END IF;
2399: assign_sequences(p_completed_pmts_group_id,
2400: l_set_of_books_id,
2401: l_seq_num_profile,

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

2416:
2417: IF l_seq_num_profile NOT IN ('A','P') and l_first_voucher_number is not null then
2418: l_debug_info := 'assign_vouchers';
2419: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2420: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2421: END IF;
2422: assign_vouchers(p_completed_pmts_group_id,
2423: l_checkrun_id,
2424: l_first_voucher_number,

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

2429: if l_perform_awt_flag = 'Y' then
2430:
2431: l_debug_info := 'AP_WITHHOLDING_PKG.AP_WITHHOLD_CANCEL';
2432: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2433: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2434: END IF;
2435:
2436: AP_WITHHOLDING_PKG.AP_WITHHOLD_CANCEL(l_checkrun_name,
2437: l_last_updated_by,

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

2448: END if;
2449:
2450: l_debug_info := 'AP_PAYMENT_EVENT_PKG.raise_payment_batch_events';
2451: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2452: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2453: END IF;
2454: AP_PAYMENT_EVENT_PKG.raise_payment_batch_events(
2455: p_checkrun_name => l_checkrun_name,
2456: p_checkrun_id => l_checkrun_id,

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

2459:
2460:
2461: l_debug_info := 'DELETE FROM ap_selected_invoices_all';
2462: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2463: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2464: END IF;
2465:
2466: DELETE FROM ap_selected_invoices_all
2467: WHERE checkrun_id = l_checkrun_id

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

2481: close c_relevant_orgs;
2482:
2483: l_debug_info := 'DELETE FROM ap_unselected_invoices_all';
2484: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2485: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2486: END IF;
2487:
2488: DELETE FROM ap_unselected_invoices_all
2489: WHERE checkrun_id = l_checkrun_id;

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

2502: WHERE completed_pmts_group_id = p_completed_pmts_group_id;
2503:
2504: l_debug_info := '******AP-IBY COUNTS****************';
2505: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2506: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2507: l_debug_info := 'IBY CHECK COUNT: '||TO_CHAR(l_iby_check_count);
2508: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2509: l_debug_info := 'IBY DOC COUNT: '||TO_CHAR(l_iby_docs_count);
2510: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

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

2504: l_debug_info := '******AP-IBY COUNTS****************';
2505: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2506: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2507: l_debug_info := 'IBY CHECK COUNT: '||TO_CHAR(l_iby_check_count);
2508: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2509: l_debug_info := 'IBY DOC COUNT: '||TO_CHAR(l_iby_docs_count);
2510: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2511: l_debug_info := 'AP CHECK COUNT: '||TO_CHAR(l_total_check_count);
2512: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

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

2506: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2507: l_debug_info := 'IBY CHECK COUNT: '||TO_CHAR(l_iby_check_count);
2508: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2509: l_debug_info := 'IBY DOC COUNT: '||TO_CHAR(l_iby_docs_count);
2510: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2511: l_debug_info := 'AP CHECK COUNT: '||TO_CHAR(l_total_check_count);
2512: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2513: l_debug_info := 'AP DOCS COUNT: '||TO_CHAR(l_total_docs_count);
2514: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

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

2508: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2509: l_debug_info := 'IBY DOC COUNT: '||TO_CHAR(l_iby_docs_count);
2510: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2511: l_debug_info := 'AP CHECK COUNT: '||TO_CHAR(l_total_check_count);
2512: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2513: l_debug_info := 'AP DOCS COUNT: '||TO_CHAR(l_total_docs_count);
2514: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2515:
2516: END IF;

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

2510: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2511: l_debug_info := 'AP CHECK COUNT: '||TO_CHAR(l_total_check_count);
2512: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2513: l_debug_info := 'AP DOCS COUNT: '||TO_CHAR(l_total_docs_count);
2514: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2515:
2516: END IF;
2517:
2518: --Bug 5115363

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

2606: BEGIN
2607:
2608: l_debug_info := 'Creating Savepoint';
2609: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2610: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2611: END IF;
2612:
2613: -- Standard Start of API savepoint
2614: SAVEPOINT Payments_Voided_PUB;

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

2614: SAVEPOINT Payments_Voided_PUB;
2615:
2616: l_debug_info := 'Checking API Compatibility';
2617: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2618: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2619: END IF;
2620:
2621: -- Standard call to check for call compatibility.
2622: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

2633: END IF;
2634:
2635: l_debug_info := 'Calling AP Void Pkg.Iby_Void_Check';
2636: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2637: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2638: END IF;
2639:
2640: -- Initialize API return status to success
2641: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2653: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2654:
2655: l_debug_info := 'AP Void Pkg.Iby_Void_Check returns error';
2656: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2657: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2658: END IF;
2659:
2660: ROLLBACK TO Payments_Voided_PUB; --4945922
2661: ELSE

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

2660: ROLLBACK TO Payments_Voided_PUB; --4945922
2661: ELSE
2662: l_debug_info := 'AP Void Pkg.Iby_Void_Check returns success';
2663: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2664: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2665: END IF;
2666:
2667: COMMIT WORK;
2668: END IF;

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

2714: BEGIN
2715:
2716: l_debug_info := 'Creating Savepoint';
2717: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2718: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2719: END IF;
2720:
2721: l_debug_info := 'Checking API Compatibility';
2722: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2719: END IF;
2720:
2721: l_debug_info := 'Checking API Compatibility';
2722: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2723: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2724: END IF;
2725:
2726: -- Standard call to check for call compatibility.
2727: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

2738: END IF;
2739:
2740: l_debug_info := 'Calling ap_bank_charge_pkg.ap_JapanBankChargeHook';
2741: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2742: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2743: END IF;
2744:
2745: ap_bank_charge_pkg.ap_JapanBankChargeHook(
2746: p_api_version ,

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

2797: BEGIN
2798:
2799: l_debug_info := 'In Payment_Stop_Initiated';
2800: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2801: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2802: END IF;
2803:
2804: l_debug_info := 'Payment_id from IBY API: '||p_payment_id;
2805: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2802: END IF;
2803:
2804: l_debug_info := 'Payment_id from IBY API: '||p_payment_id;
2805: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2806: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2807: END IF;
2808:
2809: update ap_checks_all
2810: set status_lookup_code = 'STOP INITIATED',

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

2836: BEGIN
2837:
2838: l_debug_info := 'In Payment_Stop_Released';
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);
2841: END IF;
2842:
2843: l_debug_info := 'Payment_id from IBY API: '||p_payment_id;
2844: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2841: END IF;
2842:
2843: l_debug_info := 'Payment_id from IBY API: '||p_payment_id;
2844: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2845: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2846: END IF;
2847:
2848: update ap_checks_all
2849: set status_lookup_code = 'NEGOTIABLE',