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

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

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

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

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

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

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

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

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

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

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

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

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

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

14: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
15: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
16: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
17: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
18: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
19: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_CREATE_PAY_SCHEDS_PKG.';
20:
21: Function Calc_Due_Date(
22: p_terms_date IN DATE,

Line 37: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

33:
34: l_api_name := 'Calc_Due_Date';
35:
36: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
37: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
38: 'AP_CREATE_PAY_SCHEDS_PKG.Calc_Due_Date(+)');
39: END IF;
40:
41: l_debug_info := 'Check if p_calendar is nulli p_calendar is '||p_calendar;

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

39: END IF;
40:
41: l_debug_info := 'Check if p_calendar is nulli p_calendar is '||p_calendar;
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:
47: IF (p_calendar IS NOT NULL) THEN

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

48: BEGIN
49: -- bug2639133 added truncate function
50: l_debug_info := 'Get due_date from ap_other_periods';
51: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
52: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
53: END IF;
54:
55: SELECT due_date
56: INTO l_due_date

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

68: l_due_date := TRUNC(P_Terms_Date);
69:
70: l_debug_info := 'in the exception handler l_due_date is '||l_due_date;
71: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
72: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
73: END IF;
74:
75: END;
76:

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

76:
77: ELSE
78: l_debug_info := 'There is no calendar associated with the term line';
79: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
80: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
81: END IF;
82:
83: -- bug2682782 deleted needless least function
84: SELECT NVL(fixed_date,

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

108: END IF;
109:
110: l_debug_info := 'In the else part , l_due_date is '||l_due_date;
111: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
112: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
113: END IF;
114:
115: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
116: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 116: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

112: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
113: END IF;
114:
115: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
116: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
117: 'AP_CREATE_PAY_SCHEDS_PKG.Calc_Due_Date(-)');
118: END IF;
119:
120:

Line 197: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

193: l_discount_amount NUMBER;
194: l_discount_amount_2 NUMBER;
195: l_discount_amount_3 NUMBER;
196: l_procedure_name CONSTANT VARCHAR2(30) := 'Create_Payment_Schedules';
197: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
198:
199:
200:
201: T_INVOICE_ID INVOICE_ID;

Line 275: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

271:
272: l_api_name := 'Create_Payment_Schedules'; --bug 8991699
273:
274: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
275: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
276: 'AP_CREATE_PAY_SCHEDS_PKG.Create_Payment_Schedules<-'||P_calling_sequence);
277: END IF; --bug 8991699
278:
279:

Line 317: FND_LOG.STRING(G_LEVEL_STATEMENT,

313:
314:
315: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
316: l_log_msg := 'Invoice Type is '|| l_invoice_type;
317: FND_LOG.STRING(G_LEVEL_STATEMENT,
318: G_MODULE_NAME||l_procedure_name,
319: l_log_msg);
320: END IF;
321:

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

330: END IF;
331:
332: l_debug_info := 'Before cursor c_terms_percent: P_Pay_Curr_Invoice_Amount->'||P_Pay_Curr_Invoice_Amount; --bug 8991699
333: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
334: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
335: END IF; --bug 8991699
336:
337: debug_info := 'Open cursor c_terms_percent';
338: OPEN c_terms_percent;

Line 354: FND_LOG.STRING(G_LEVEL_STATEMENT,

350: /* Terms type is Slab */
351:
352: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
353: l_log_msg := 'Terms type is Slab';
354: FND_LOG.STRING(G_LEVEL_STATEMENT,
355: G_MODULE_NAME||l_procedure_name,
356: l_log_msg);
357: END IF;
358: --

Line 485: FND_LOG.STRING(G_LEVEL_STATEMENT,

481: ' Disc3 by percent:' || l_disc_amt_by_percent_3 ||
482: ' Disc1 by amount:' || l_discount_amount ||
483: ' Disc2 by amount:' || l_discount_amount_2 ||
484: ' Disc3 by amount:' || l_discount_amount_3;
485: FND_LOG.STRING(G_LEVEL_STATEMENT,
486: G_MODULE_NAME||l_procedure_name,
487: l_log_msg);
488: END IF;
489:

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

677: t_gross_amount(l_payment_schedule_index);
678:
679: l_debug_info := 'l_pay_sched_total->'||l_pay_sched_total; --bug 8991699
680: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
681: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
682: END IF; --bug 8991699
683:
684: IF l_min_acc_unit_inv_curr IS NULL THEN
685:

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

700: END IF;
701:
702: l_debug_info := 't_inv_curr_gross_amount(l_payment_schedule_index)->'||t_inv_curr_gross_amount(l_payment_schedule_index); --bug 8991699
703: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
704: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
705: END IF; --bug 8991699
706:
707: t_payment_priority(l_payment_schedule_index)
708: := nvl(P_Payment_Priority,l_payment_priority);

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

727: END IF;
728:
729: l_debug_info := 'l_inv_curr_sched_total->'||l_inv_curr_sched_total; --bug 8991699
730: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
731: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
732: END IF; --bug 8991699
733:
734: END LOOP slab_loop;
735: --

Line 741: FND_LOG.STRING(G_LEVEL_STATEMENT,

737: -- /* Terms type is Percent */
738:
739: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
740: l_log_msg := 'Terms type is Percent';
741: FND_LOG.STRING(G_LEVEL_STATEMENT,
742: G_MODULE_NAME||l_procedure_name,
743: l_log_msg);
744: END IF;
745:

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

751: EXIT WHEN c_terms%NOTFOUND;
752:
753: l_debug_info := 'Calculate Due Date - terms type is percent'; --bug 8991699
754: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
755: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
756: END IF; --bug 8991699
757:
758: l_due_date := Calc_Due_Date ( p_terms_date,
759: p_terms_id,

Line 830: FND_LOG.STRING(G_LEVEL_STATEMENT,

826: ' Disc3 by percent:' || l_disc_amt_by_percent_3 ||
827: ' Disc1 by amount:' || l_discount_amount ||
828: ' Disc2 by amount:' || l_discount_amount_2 ||
829: ' Disc3 by amount:' || l_discount_amount_3;
830: FND_LOG.STRING(G_LEVEL_STATEMENT,
831: G_MODULE_NAME||l_procedure_name,
832: l_log_msg);
833: END IF;
834:

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

1022: t_gross_amount(l_payment_schedule_index);
1023:
1024: l_debug_info := 'l_pay_sched_total2->'||l_pay_sched_total; --bug 8991699
1025: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1026: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1027: END IF; --bug 8991699
1028:
1029: IF l_min_acc_unit_inv_curr IS NULL THEN
1030:

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

1045: END IF;
1046:
1047: l_debug_info := 't_inv_curr_gross_amount(l_payment_schedule_index)2->'||t_inv_curr_gross_amount(l_payment_schedule_index); --bug 8991699
1048: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1049: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1050: END IF; --bug 8991699
1051:
1052: t_payment_priority(l_payment_schedule_index)
1053: := nvl(P_Payment_Priority,l_payment_priority);

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

1068: END IF;
1069:
1070: l_debug_info := 'l_inv_curr_sched_total2->'||l_inv_curr_sched_total; --bug 8991699
1071: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1072: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1073: END IF; --bug 8991699
1074:
1075: END LOOP;
1076:

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

1104: END IF;
1105:
1106: l_debug_info := 'Insert the Payment Schedule Lines into the table'; --bug 8991699
1107: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1108: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1109: END IF; --bug 8991699
1110:
1111: -- Insert the Payment Schedule Lines into the table
1112: FORALL i IN 1..l_payment_schedule_index

Line 1302: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1298: l_discount_amount NUMBER;
1299: l_discount_amount_2 NUMBER;
1300: l_discount_amount_3 NUMBER;
1301: l_procedure_name CONSTANT VARCHAR2(30) := 'Ap_Create_From_Terms';
1302: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1303:
1304: l_api_name varchar(50); --bug 8991699
1305: l_debug_info varchar2(2000); --bug 8991699
1306: l_retained_amount number; --bug 8991699

Line 1394: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

1390:
1391: l_api_name := 'AP_Create_From_Terms';
1392:
1393: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1394: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1395: 'AP_CREATE_PAY_SCHEDS_PKG.AP_Create_From_Terms<-'||P_calling_sequence);
1396: END IF;
1397:
1398: -- Bug Fix:1952122

Line 1492: FND_LOG.STRING(G_LEVEL_STATEMENT,

1488:
1489:
1490: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1491: l_log_msg := 'Invoice Type is '|| l_invoice_type;
1492: FND_LOG.STRING(G_LEVEL_STATEMENT,
1493: G_MODULE_NAME||l_procedure_name,
1494: l_log_msg);
1495: END IF;
1496:

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

1513: P_Payment_Currency);
1514:
1515: l_debug_info := 'Convert discount amount to payment currency->'||l_amount_for_discount||'P_Pay_Curr_Invoice_Amount->'||P_Pay_Curr_Invoice_Amount; --bug 8991699
1516: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1517: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1518: END IF; --bug 8991699
1519:
1520: IF c_terms_percent%NOTFOUND THEN -- Terms type is Slab
1521: debug_info := 'c_terms_percent%NOTFOUND';

Line 1526: FND_LOG.STRING(G_LEVEL_STATEMENT,

1522:
1523:
1524: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1525: l_log_msg := 'Terms type is Slab';
1526: FND_LOG.STRING(G_LEVEL_STATEMENT,
1527: G_MODULE_NAME||l_procedure_name,
1528: l_log_msg);
1529: END IF;
1530:

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

1581: -- payment get the site's primary supplier bank account for MSB.
1582:
1583: l_debug_info := 'Calculate Due Date - terms slab type'; --bug 8991699
1584: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1585: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1586: END IF; --bug 8991699
1587:
1588: l_due_date := Calc_Due_Date (
1589: p_terms_date,

Line 1679: FND_LOG.STRING(G_LEVEL_STATEMENT,

1675: ' Disc3 by percent:' || l_disc_amt_by_percent_3 ||
1676: ' Disc1 by amount:' || l_discount_amount ||
1677: ' Disc2 by amount:' || l_discount_amount_2 ||
1678: ' Disc3 by amount:' || l_discount_amount_3;
1679: FND_LOG.STRING(G_LEVEL_STATEMENT,
1680: G_MODULE_NAME||l_procedure_name,
1681: l_log_msg);
1682: END IF;
1683:

Line 1879: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info); --bug 8991699

1875: AND ai.recurring_payment_id = arp.recurring_payment_id(+); --bug 5332569
1876:
1877: l_debug_info := 'After Insert into ap_payment_schedules- term type is not percent'; --bug 8991699
1878: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1879: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info); --bug 8991699
1880: END IF;
1881:
1882: --Bug 4539462 DBI logging
1883: AP_DBI_PKG.Maintain_DBI_Summary

Line 1902: FND_LOG.STRING(G_LEVEL_STATEMENT,

1898: -- /* Terms type is Percent */
1899:
1900: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1901: l_log_msg := 'Terms type is Percent';
1902: FND_LOG.STRING(G_LEVEL_STATEMENT,
1903: G_MODULE_NAME||l_procedure_name,
1904: l_log_msg);
1905: END IF;
1906:

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

1918: -- Terms type is Percent
1919:
1920: l_debug_info := 'Calculate Due Date - terms type is percent'; --bug 8991699
1921: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1922: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1923: END IF; --bug 8991699
1924:
1925: l_due_date := Calc_Due_Date (
1926: p_terms_date,

Line 2004: FND_LOG.STRING(G_LEVEL_STATEMENT,

2000: ' Disc3 by percent:' || l_disc_amt_by_percent_3 ||
2001: ' Disc1 by amount:' || l_discount_amount ||
2002: ' Disc2 by amount:' || l_discount_amount_2 ||
2003: ' Disc3 by amount:' || l_discount_amount_3;
2004: FND_LOG.STRING(G_LEVEL_STATEMENT,
2005: G_MODULE_NAME||l_procedure_name,
2006: l_log_msg);
2007: END IF;
2008:

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

2215: AND ai.recurring_payment_id = arp.recurring_payment_id(+);
2216:
2217: l_debug_info := 'l_due_date'||to_char(l_due_date,'dd-mm-yyyy')||'Insert into ap_payment_schedules : term type is percent';
2218: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2219: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2220: END IF;
2221:
2222: --Bug 4539462 DBI logginG
2223: AP_DBI_PKG.Maintain_DBI_Summary

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

2238: l_invoice_sign;
2239:
2240: l_debug_info := 'Fetch cursor c_shed_total'||l_pay_sched_total||'P_Pay_Curr_Invoice_Amount->'||P_Pay_Curr_Invoice_Amount; --bug 8991699
2241: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2242: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2243: END IF; --bug 8991699
2244:
2245: debug_info := 'Close cursor c_shed_total';
2246: CLOSE c_shed_total;

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

2251:
2252: l_debug_info := 'Update ap_payment_schedules - set gross_amount->P_Pay_Curr_Invoice_Amount:'||P_Pay_Curr_Invoice_Amount||
2253: 'l_pay_sched_total->'||l_pay_sched_total; --bug 8991699
2254: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2255: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2256: END IF; --bug 8991699
2257:
2258: UPDATE AP_PAYMENT_SCHEDULES
2259: SET gross_amount = gross_amount +

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

2298: -- Populate the inv_curr_gross_amount
2299:
2300: l_debug_info := 'Update ap_payment_schedules - set inv_curr_gross_amount'; --bug 8991699
2301: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2302: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2303: END IF; --bug 8991699
2304:
2305: IF l_min_acc_unit_inv_curr IS NULL THEN
2306: UPDATE ap_payment_schedules

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

2343:
2344: l_debug_info := 'Update ap_payment_schedules - set inv_curr_gross_amount:P_Invoice_Amount->'||P_Invoice_Amount||
2345: 'l_inv_curr_sched_total->'||l_inv_curr_sched_total; --bug 8991699
2346: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2347: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2348: END IF; --bug 8991699
2349:
2350: --bug 8991699 begins
2351: l_retained_amount := nvl(abs(ap_invoices_utility_pkg.get_retained_total