DBA Data[Home] [Help]

APPS.AP_ACCOUNTING_PAY_PKG dependencies on FND_LOG

Line 5: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY AP_ACCOUNTING_PAY_PKG AS
2: /* $Header: apacpayb.pls 120.12.12010000.4 2008/09/04 14:06:27 imandal ship $ */
3:
4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

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

2: /* $Header: apacpayb.pls 120.12.12010000.4 2008/09/04 14:06:27 imandal ship $ */
3:
4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

3:
4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

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

4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'AP.PLSQL.AP_ACCOUNTING_PAY_PKG.';

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

5: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'AP.PLSQL.AP_ACCOUNTING_PAY_PKG.';
13: -- Logging Infra

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

6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'AP.PLSQL.AP_ACCOUNTING_PAY_PKG.';
13: -- Logging Infra
14:

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

7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'AP.PLSQL.AP_ACCOUNTING_PAY_PKG.';
13: -- Logging Infra
14:
15: -------------------------------------------------------------------------------

Line 47: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

43: ORDER BY Event_ID;
44:
45: -- Logging Infra:
46: l_procedure_name CONSTANT VARCHAR2(30) := 'Do_Pay_Accounting';
47: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
48:
49: BEGIN
50:
51: l_curr_calling_sequence := 'AP_Accounting_Pay_Pkg.Do_Pay_Accounting<- ' ||

Line 55: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

51: l_curr_calling_sequence := 'AP_Accounting_Pay_Pkg.Do_Pay_Accounting<- ' ||
52: p_calling_sequence;
53:
54: -- Logging Infra: Setting up runtime level
55: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
56:
57: -- Logging Infra: Procedure level
58: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
59: l_log_msg := 'Begin of procedure '|| l_procedure_name;

Line 60: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

56:
57: -- Logging Infra: Procedure level
58: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
59: l_log_msg := 'Begin of procedure '|| l_procedure_name;
60: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
61: END IF;
62:
63:
64: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 66: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

62:
63:
64: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
65: l_log_msg := 'Calling procedure AP_Acctg_Pay_Dist_Pkg.Primary_Pay_Events';
66: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
67: END IF;
68:
69:
70: -- We need to delete the payment hist distributions and prepay appl hist distributions

Line 79: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

75:
76:
77: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
78: l_log_msg := 'Procedure AP_Acctg_Pay_Dist_Pkg.Primary_Pay_Events executed';
79: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
80: END IF;
81:
82: OPEN xla_events_cur;
83: LOOP

Line 93: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

89:
90: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
91: l_log_msg := 'CUR: xla_events_cur: entity_code = '|| l_xla_event_rec.entity_code
92: || ' document_id = ' || l_xla_event_rec.source_id_int_1;
93: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
94: END IF;
95:
96: -- Get the base currency code into global variable
97: IF (l_xla_event_rec.entity_code = 'AP_PAYMENTS') THEN

Line 127: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

123: 'REFUND RECORDED')) THEN
124:
125: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
126: l_log_msg := 'Calling procedure AP_Acctg_Pay_Dist_Pkg.Primary_Pay_Events';
127: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
128: END IF;
129:
130:
131: AP_Acctg_Pay_Dist_Pkg.Primary_Pay_Events

Line 138: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

134:
135:
136: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
137: l_log_msg := 'Procedure AP_Acctg_Pay_Dist_Pkg.Primary_Pay_Events executed';
138: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
139: END IF;
140:
141: ELSIF l_xla_event_rec.event_type_code IN ('MANUAL PAYMENT ADJUSTED',
142: 'UPGRADED MANUAL PMT ADJUSTED') THEN

Line 146: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

142: 'UPGRADED MANUAL PMT ADJUSTED') THEN
143:
144: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
145: l_log_msg := 'Calling procedure AP_Acctg_Pay_Dist_Pkg.Manual_Pay_Adj_Events';
146: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
147: END IF;
148:
149: AP_Acctg_Pay_Dist_Pkg.Manual_Pay_Adj_Events
150: (l_xla_event_rec,

Line 155: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

151: l_curr_calling_sequence);
152:
153: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
154: l_log_msg := 'Procedure AP_Acctg_Pay_Dist_Pkg.Manual_Pay_Adj_Events executed';
155: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
156: END IF;
157:
158: ELSIF l_xla_event_rec.event_type_code IN ('PAYMENT ADJUSTED',
159: 'PAYMENT MATURITY ADJUSTED',

Line 165: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

161: 'REFUND ADJUSTED') THEN
162:
163: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
164: l_log_msg := 'Calling procedure AP_Acctg_Pay_Dist_Pkg.Pay_Dist_Cascade_Adj_Events';
165: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
166: END IF;
167:
168: AP_Acctg_Pay_Dist_Pkg.Pay_Dist_Cascade_Adj_Events
169: (l_xla_event_rec,

Line 174: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

170: l_curr_calling_sequence);
171:
172: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
173: l_log_msg := 'Procedure AP_Acctg_Pay_Dist_Pkg.Pay_Dist_Cascade_Adj_Events executed';
174: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
175: END IF;
176:
177: ELSIF l_xla_event_rec.event_type_code IN ('PAYMENT CANCELLED',
178: 'PAYMENT MATURITY REVERSED',

Line 184: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

180: 'REFUND CANCELLED') THEN
181:
182: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
183: l_log_msg := 'Calling procedure AP_Acctg_Pay_Dist_Pkg.Cancel_Primary_Pay_Events';
184: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
185: END IF;
186:
187: AP_Acctg_Pay_Dist_Pkg.Cancel_Primary_Pay_Events
188: (l_xla_event_rec,

Line 194: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

190:
191:
192: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
193: l_log_msg := 'Procedure AP_Acctg_Pay_Dist_Pkg.Cancel_Primary_Pay_Events executed';
194: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
195: END IF;
196:
197: ELSIF l_xla_event_rec.event_type_code IN ('PREPAYMENT APPLICATION ADJ') THEN
198:

Line 201: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

197: ELSIF l_xla_event_rec.event_type_code IN ('PREPAYMENT APPLICATION ADJ') THEN
198:
199: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
200: l_log_msg := 'Calling procedure AP_Acctg_Prepay_Dist_Pkg.Prepay_Dist_Cascade_Adj';
201: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
202: END IF;
203:
204: AP_Acctg_Prepay_Dist_Pkg.Prepay_Dist_Cascade_Adj
205: (l_xla_event_rec,

Line 210: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

206: l_curr_calling_sequence);
207:
208: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
209: l_log_msg := 'Procedure AP_Acctg_Prepay_Dist_Pkg.Prepay_Dist_Cascade_Adj executed';
210: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
211: END IF;
212:
213: ELSIF l_xla_event_rec.event_type_code IN ('PREPAYMENT APPLIED',
214: 'PREPAYMENT UNAPPLIED') THEN

Line 218: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

214: 'PREPAYMENT UNAPPLIED') THEN
215:
216: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
217: l_log_msg := 'Calling procedure AP_Acctg_Prepay_Dist_Pkg.Update_Gain_Loss_Ind';
218: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
219: END IF;
220:
221: AP_Acctg_Prepay_Dist_Pkg.Update_Gain_Loss_Ind
222: (l_xla_event_rec,

Line 227: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

223: l_curr_calling_sequence);
224:
225: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
226: l_log_msg := 'Procedure AP_Acctg_Prepay_Dist_Pkg.Updated_Gain_Loss_Ind executed';
227: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
228: END IF;
229:
230: END IF;
231:

Line 238: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);

234:
235: -- Logging Infra: Procedure level
236: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
237: l_log_msg := 'End of procedure '|| l_procedure_name;
238: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
239: END IF;
240:
241: -- Commenting out the commit since the commit is issued during the post processing of the
242: -- accounting process

Line 272: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

268: l_curr_calling_sequence VARCHAR2(2000);
269:
270: -- Logging Infra:
271: l_procedure_name CONSTANT VARCHAR2(30) := 'Do_Pay_Accounting';
272: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
273:
274: BEGIN
275:
276: l_curr_calling_sequence := 'AP_Accounting_Pay_Pkg.Do_Pay_Accounting<- ' ||

Line 282: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

278:
279: -- Logging Infra: Procedure level
280: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
281: l_log_msg := 'Begin of procedure '|| l_procedure_name;
282: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
283: END IF;
284:
285:
286: -- Bug 5098657. Added the where condition for both the delete statements

Line 783: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

779: l_final_payment BOOLEAN := FALSE;
780: l_curr_calling_sequence VARCHAR2(2000);
781:
782: l_procedure_name CONSTANT VARCHAR2(30) := 'is_final_payment';
783: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
784:
785:
786: BEGIN
787:

Line 805: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

801: 'P_Payment_Amount=' || P_Payment_Amount ||
802: 'P_Discount_Amount=' ||P_Discount_Amount ||
803: 'P_Prepay_Amount =' || P_Prepay_Amount ||
804: 'P_Transaction_Type =' || P_Transaction_Type;
805: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
806: END IF;
807:
808:
809: IF (P_Transaction_Type IN ('PAYMENT CLEARED')) THEN

Line 841: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

837:
838: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
839: l_log_msg := 'transaction type is payment clearing and ' ||
840: 'l_paid_acctd_amt=' || l_paid_acctd_amt;
841: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
842: END IF;
843:
844: ELSIF (P_Transaction_Type IN ('PAYMENT MATURED')) THEN
845:

Line 866: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

862:
863: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
864: l_log_msg := 'transaction type is payment matruity and ' ||
865: 'l_paid_acctd_amt=' || l_paid_acctd_amt;
866: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
867: END IF;
868:
869:
870: ELSE

Line 892: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

888: 'REFUND RECORDED', 'REFUND ADJUSTED', 'REFUND CANCELLED');
889: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
890: l_log_msg := 'transaction type is payment created or others ' ||
891: 'l_paid_acctd_amt=' || l_paid_acctd_amt;
892: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
893: END IF;
894:
895: END IF;
896:

Line 912: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

908:
909: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
910: l_log_msg := 'there is a prepay application and ' ||
911: 'l_prepaid_acctd_amt =' || l_prepaid_acctd_amt;
912: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
913: END IF;
914:
915:
916: IF (p_inv_rec.invoice_currency_code <> p_inv_rec.payment_currency_code) THEN

Line 943: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

939: 'compare invoice amount either with ' ||
940: 'p_inv_rec.pay_curr_invoice_amount' || p_inv_rec.pay_curr_invoice_amount ||
941: 'p_inv_rec.invoice_amount' || p_inv_rec.invoice_amount;
942:
943: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
944: END IF;
945:
946:
947: IF (NVL(p_inv_rec.pay_curr_invoice_amount, p_inv_rec.invoice_amount)

Line 954: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

950: l_final_payment := TRUE;
951:
952: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
953: l_log_msg := 'This is a final payment after comparison';
954: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
955: END IF;
956:
957: END IF;
958:

Line 992: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

988: l_base_amount NUMBER := 0 ;
989: l_curr_calling_sequence VARCHAR2(2000);
990:
991: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Base_Amount';
992: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
993:
994: BEGIN
995:
996: l_curr_calling_sequence := 'AP_ACCOUNTING_PAY_PKG.Get_Base_Amount<-'

Line 1009: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

1005: 'P_base_currency_code =' || P_base_currency_code ||
1006: 'P_exchange_rate_type =' || P_exchange_rate_type ||
1007: 'P_exchange_rate_date =' || P_exchange_rate_date ||
1008: 'P_exchange_rate =' || P_exchange_rate ;
1009: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
1010: END IF;
1011:
1012: IF ( P_currency_code = P_base_currency_code ) THEN
1013:

Line 1016: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

1012: IF ( P_currency_code = P_base_currency_code ) THEN
1013:
1014: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1015: l_log_msg := 'base currency code = transaction currency code';
1016: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
1017:
1018: END IF;
1019:
1020: l_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(P_amount,

Line 1031: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

1027:
1028: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1029:
1030: l_log_msg := 'exchange rate type is not user and it is a fixed rate';
1031: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
1032:
1033: END IF;
1034:
1035: l_base_amount := GL_Currency_API.Convert_Amount(P_currency_code,

Line 1045: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

1041:
1042: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1043:
1044: l_log_msg := 'not a fix rate, and not a same currency code';
1045: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
1046:
1047: END IF;
1048:
1049: