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.INV_MGD_MVT_FIN_MDTR dependencies on FND_LOG

Line 86: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

82: l_currency_conversion_rate number;
83: l_currency_conversion_date date;
84:
85: BEGIN
86: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
87: THEN
88: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
89: , G_MODULE_NAME || l_procedure_name || '.begin'
90: ,'enter procedure'

Line 88: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

84:
85: BEGIN
86: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
87: THEN
88: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
89: , G_MODULE_NAME || l_procedure_name || '.begin'
90: ,'enter procedure'
91: );
92:

Line 93: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

89: , G_MODULE_NAME || l_procedure_name || '.begin'
90: ,'enter procedure'
91: );
92:
93: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
94: , G_MODULE_NAME || l_procedure_name || '.legal entiry id - '
95: ,p_movement_transaction.entity_org_id
96: );
97:

Line 98: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

94: , G_MODULE_NAME || l_procedure_name || '.legal entiry id - '
95: ,p_movement_transaction.entity_org_id
96: );
97:
98: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
99: , G_MODULE_NAME || l_procedure_name || '.stat type - '
100: ,p_movement_transaction.stat_type
101: );
102:

Line 103: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

99: , G_MODULE_NAME || l_procedure_name || '.stat type - '
100: ,p_movement_transaction.stat_type
101: );
102:
103: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
104: , G_MODULE_NAME || l_procedure_name || '.period name - '
105: ,p_movement_transaction.period_name
106: );
107:

Line 127: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

123: WHERE
124: legal_entity_id = p_movement_transaction.entity_org_id
125: AND stat_type = p_movement_transaction.stat_type;
126:
127: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
128: THEN
129: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
130: , G_MODULE_NAME || l_procedure_name || '.period set name'
131: ,l_period_set_name

Line 129: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

125: AND stat_type = p_movement_transaction.stat_type;
126:
127: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
128: THEN
129: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
130: , G_MODULE_NAME || l_procedure_name || '.period set name'
131: ,l_period_set_name
132: );
133:

Line 134: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

130: , G_MODULE_NAME || l_procedure_name || '.period set name'
131: ,l_period_set_name
132: );
133:
134: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
135: , G_MODULE_NAME || l_procedure_name || '.period type - '
136: ,l_period_type
137: );
138:

Line 139: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

135: , G_MODULE_NAME || l_procedure_name || '.period type - '
136: ,l_period_type
137: );
138:
139: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
140: , G_MODULE_NAME || l_procedure_name || '.conversion option - '
141: ,l_conversion_option
142: );
143:

Line 144: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

140: , G_MODULE_NAME || l_procedure_name || '.conversion option - '
141: ,l_conversion_option
142: );
143:
144: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
145: , G_MODULE_NAME || l_procedure_name || '.conversion type - '
146: ,l_conversion_type
147: );
148:

Line 163: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

159: AND period_set_name = l_period_set_name
160: AND period_type = l_period_type;
161:
162:
163: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
164: THEN
165: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
166: , G_MODULE_NAME || l_procedure_name || '.last day of period'
167: , l_last_dayofperiod

Line 165: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

161:
162:
163: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
164: THEN
165: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
166: , G_MODULE_NAME || l_procedure_name || '.last day of period'
167: , l_last_dayofperiod
168: );
169: END IF ;

Line 174: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

170:
171: IF UPPER(l_conversion_option) = 'CO_LAST_DAY'
172: THEN
173:
174: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
175: THEN
176: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
177: , G_MODULE_NAME || l_procedure_name || '.co last day'
178: , l_conversion_option

Line 176: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

172: THEN
173:
174: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
175: THEN
176: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
177: , G_MODULE_NAME || l_procedure_name || '.co last day'
178: , l_conversion_option
179: );
180: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 180: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

176: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
177: , G_MODULE_NAME || l_procedure_name || '.co last day'
178: , l_conversion_option
179: );
180: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
181: , G_MODULE_NAME || l_procedure_name || '.invoice currency code'
182: , p_invoice_currency_code
183: );
184: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 184: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

180: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
181: , G_MODULE_NAME || l_procedure_name || '.invoice currency code'
182: , p_invoice_currency_code
183: );
184: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
185: , G_MODULE_NAME || l_procedure_name || '.gl_currency_code'
186: , p_movement_transaction.gl_currency_code
187: );
188: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 188: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

184: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
185: , G_MODULE_NAME || l_procedure_name || '.gl_currency_code'
186: , p_movement_transaction.gl_currency_code
187: );
188: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
189: , G_MODULE_NAME || l_procedure_name || '.l_last_dayofperiod'
190: , l_last_dayofperiod
191: );
192: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 192: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

188: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
189: , G_MODULE_NAME || l_procedure_name || '.l_last_dayofperiod'
190: , l_last_dayofperiod
191: );
192: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
193: , G_MODULE_NAME || l_procedure_name || '.l_conversion_type'
194: , l_conversion_type
195: );
196: END IF ;

Line 205: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

201: , x_conversion_date => l_last_dayofperiod
202: , x_conversion_type => l_conversion_type
203: );
204:
205: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
206: THEN
207: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
208: , G_MODULE_NAME || l_procedure_name || '.conversion rate'
209: , l_currency_conversion_rate

Line 207: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

203: );
204:
205: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
206: THEN
207: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
208: , G_MODULE_NAME || l_procedure_name || '.conversion rate'
209: , l_currency_conversion_rate
210: );
211: END IF ;

Line 216: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

212:
213:
214: ELSE
215:
216: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
217: THEN
218: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
219: , G_MODULE_NAME || l_procedure_name || '.CO DAILY'
220: , 'in daily conversion routine'

Line 218: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

214: ELSE
215:
216: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
217: THEN
218: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
219: , G_MODULE_NAME || l_procedure_name || '.CO DAILY'
220: , 'in daily conversion routine'
221: );
222: END IF ;

Line 224: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

220: , 'in daily conversion routine'
221: );
222: END IF ;
223:
224: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
225: THEN
226: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
227: , G_MODULE_NAME || l_procedure_name || '.co last day'
228: , l_conversion_option

Line 226: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

222: END IF ;
223:
224: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
225: THEN
226: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
227: , G_MODULE_NAME || l_procedure_name || '.co last day'
228: , l_conversion_option
229: );
230: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 230: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

226: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
227: , G_MODULE_NAME || l_procedure_name || '.co last day'
228: , l_conversion_option
229: );
230: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
231: , G_MODULE_NAME || l_procedure_name || '.invoice currency code'
232: , p_invoice_currency_code
233: );
234: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 234: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

230: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
231: , G_MODULE_NAME || l_procedure_name || '.invoice currency code'
232: , p_invoice_currency_code
233: );
234: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
235: , G_MODULE_NAME || l_procedure_name || '.gl_currency_code'
236: , p_movement_transaction.gl_currency_code
237: );
238: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 238: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

234: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
235: , G_MODULE_NAME || l_procedure_name || '.gl_currency_code'
236: , p_movement_transaction.gl_currency_code
237: );
238: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
239: , G_MODULE_NAME || l_procedure_name || '.l_last_dayofperiod'
240: , l_last_dayofperiod
241: );
242: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 242: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

238: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
239: , G_MODULE_NAME || l_procedure_name || '.l_last_dayofperiod'
240: , l_last_dayofperiod
241: );
242: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
243: , G_MODULE_NAME || l_procedure_name || '.l_conversion_type'
244: , l_conversion_type
245: );
246: END IF ;

Line 264: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

260: THEN
261: l_currency_conversion_rate := 1;
262: END IF;
263:
264: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
265: THEN
266: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
267: , G_MODULE_NAME || l_procedure_name || '.end'
268: ,'exit procedure'

Line 266: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

262: END IF;
263:
264: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
265: THEN
266: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
267: , G_MODULE_NAME || l_procedure_name || '.end'
268: ,'exit procedure'
269: );
270: END IF;

Line 276: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

272: return l_currency_conversion_rate;
273: EXCEPTION
274: WHEN GL_CURRENCY_API.no_rate
275: THEN
276: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
277: THEN
278: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
279: , G_MODULE_NAME || l_procedure_name||'.No rate exception'
280: , 'Exception'

Line 278: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

274: WHEN GL_CURRENCY_API.no_rate
275: THEN
276: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
277: THEN
278: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
279: , G_MODULE_NAME || l_procedure_name||'.No rate exception'
280: , 'Exception'
281: );
282: END IF;

Line 287: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

283: l_currency_conversion_rate := 1;
284: return l_currency_conversion_rate;
285: WHEN NO_DATA_FOUND
286: THEN
287: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
288: THEN
289: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
290: , G_MODULE_NAME || l_procedure_name||'.No data found exception'
291: , 'Exception'

Line 289: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

285: WHEN NO_DATA_FOUND
286: THEN
287: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
288: THEN
289: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
290: , G_MODULE_NAME || l_procedure_name||'.No data found exception'
291: , 'Exception'
292: );
293: END IF;

Line 298: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

294: l_currency_conversion_rate := 1;
295: return l_currency_conversion_rate;
296: WHEN OTHERS
297: THEN
298: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
299: THEN
300: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
301: , G_MODULE_NAME || l_procedure_name||'.Others exception'
302: , 'Exception'

Line 300: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

296: WHEN OTHERS
297: THEN
298: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
299: THEN
300: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
301: , G_MODULE_NAME || l_procedure_name||'.Others exception'
302: , 'Exception'
303: );
304: END IF;

Line 381: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

377: AND ratl.interface_line_attribute6 = to_char(oola.line_id)
378: AND oola.top_model_line_id = p_order_line_id
379: AND ratl.interface_line_context <> 'INTERCOMPANY';
380: BEGIN
381: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
382: THEN
383: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
384: , G_MODULE_NAME || l_procedure_name || '.begin'
385: ,'enter procedure'

Line 383: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

379: AND ratl.interface_line_context <> 'INTERCOMPANY';
380: BEGIN
381: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
382: THEN
383: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
384: , G_MODULE_NAME || l_procedure_name || '.begin'
385: ,'enter procedure'
386: );
387: END IF;

Line 401: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

397: FETCH l_cto_cm_amt INTO
398: x_cm_extended_amount;
399: CLOSE l_cto_cm_amt;
400:
401: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
402: THEN
403: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
404: , G_MODULE_NAME || l_procedure_name || '.end'
405: ,'exit procedure'

Line 403: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

399: CLOSE l_cto_cm_amt;
400:
401: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
402: THEN
403: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
404: , G_MODULE_NAME || l_procedure_name || '.end'
405: ,'exit procedure'
406: );
407: END IF;

Line 411: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

407: END IF;
408:
409: EXCEPTION
410: WHEN OTHERS THEN
411: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
412: THEN
413: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
414: , G_MODULE_NAME || l_procedure_name||'.Others exception'
415: , 'Exception'

Line 413: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

409: EXCEPTION
410: WHEN OTHERS THEN
411: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
412: THEN
413: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
414: , G_MODULE_NAME || l_procedure_name||'.Others exception'
415: , 'Exception'
416: );
417: END IF;

Line 493: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

489: AND rat.complete_flag = 'Y'
490: AND ratl.interface_line_context <> 'INTERCOMPANY';
491:
492: BEGIN
493: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
494: THEN
495: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
496: , G_MODULE_NAME || l_procedure_name || '.begin'
497: ,'enter procedure'

Line 495: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

491:
492: BEGIN
493: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
494: THEN
495: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
496: , G_MODULE_NAME || l_procedure_name || '.begin'
497: ,'enter procedure'
498: );
499: END IF;

Line 513: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

509: FETCH l_cto_cm_amt_drp INTO
510: x_cm_extended_amount;
511: CLOSE l_cto_cm_amt_drp;
512:
513: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
514: THEN
515: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
516: , G_MODULE_NAME || l_procedure_name || '.end'
517: ,'exit procedure'

Line 515: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

511: CLOSE l_cto_cm_amt_drp;
512:
513: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
514: THEN
515: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
516: , G_MODULE_NAME || l_procedure_name || '.end'
517: ,'exit procedure'
518: );
519: END IF;

Line 523: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

519: END IF;
520:
521: EXCEPTION
522: WHEN OTHERS THEN
523: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
524: THEN
525: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
526: , G_MODULE_NAME || l_procedure_name||'. Others exception'
527: , 'Exception'

Line 525: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

521: EXCEPTION
522: WHEN OTHERS THEN
523: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
524: THEN
525: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
526: , G_MODULE_NAME || l_procedure_name||'. Others exception'
527: , 'Exception'
528: );
529: END IF;

Line 570: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

566: AND ratl.sales_order = p_order_number
567: AND oola.top_model_line_id = p_order_line_id
568: AND ratl.interface_line_context <> 'INTERCOMPANY';
569: BEGIN
570: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
571: THEN
572: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
573: , G_MODULE_NAME || l_procedure_name || '.begin'
574: ,'enter procedure'

Line 572: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

568: AND ratl.interface_line_context <> 'INTERCOMPANY';
569: BEGIN
570: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
571: THEN
572: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
573: , G_MODULE_NAME || l_procedure_name || '.begin'
574: ,'enter procedure'
575: );
576: END IF;

Line 585: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

581: FETCH l_cto_amt_rma INTO
582: x_extended_amount;
583: CLOSE l_cto_amt_rma;
584:
585: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
586: THEN
587: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
588: , G_MODULE_NAME || l_procedure_name || '.end'
589: ,'exit procedure'

Line 587: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

583: CLOSE l_cto_amt_rma;
584:
585: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
586: THEN
587: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
588: , G_MODULE_NAME || l_procedure_name || '.end'
589: ,'exit procedure'
590: );
591: END IF;

Line 595: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

591: END IF;
592:
593: EXCEPTION
594: WHEN OTHERS THEN
595: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
596: THEN
597: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
598: , G_MODULE_NAME || l_procedure_name||'. Others exception'
599: , 'Exception'

Line 597: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

593: EXCEPTION
594: WHEN OTHERS THEN
595: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
596: THEN
597: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
598: , G_MODULE_NAME || l_procedure_name||'. Others exception'
599: , 'Exception'
600: );
601: END IF;

Line 631: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

627: AND ratl.sales_order = p_order_number
628: AND oola.top_model_line_id = p_order_line_id
629: AND ratl.interface_line_context = 'INTERCOMPANY';
630: BEGIN
631: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
632: THEN
633: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
634: , G_MODULE_NAME || l_procedure_name || '.begin'
635: ,'enter procedure'

Line 633: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

629: AND ratl.interface_line_context = 'INTERCOMPANY';
630: BEGIN
631: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
632: THEN
633: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
634: , G_MODULE_NAME || l_procedure_name || '.begin'
635: ,'enter procedure'
636: );
637: END IF;

Line 646: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

642: FETCH l_cto_amt_ar INTO
643: x_extended_amount;
644: CLOSE l_cto_amt_ar;
645:
646: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
647: THEN
648: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
649: , G_MODULE_NAME || l_procedure_name || '.end'
650: ,'exit procedure'

Line 648: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

644: CLOSE l_cto_amt_ar;
645:
646: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
647: THEN
648: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
649: , G_MODULE_NAME || l_procedure_name || '.end'
650: ,'exit procedure'
651: );
652: END IF;

Line 656: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

652: END IF;
653:
654: EXCEPTION
655: WHEN OTHERS THEN
656: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
657: THEN
658: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
659: , G_MODULE_NAME || l_procedure_name||'. Others exception'
660: , 'Exception'

Line 658: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

654: EXCEPTION
655: WHEN OTHERS THEN
656: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
657: THEN
658: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
659: , G_MODULE_NAME || l_procedure_name||'. Others exception'
660: , 'Exception'
661: );
662: END IF;

Line 717: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

713: WHERE aida.invoice_id = aia.invoice_id
714: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
715:
716: BEGIN
717: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
718: THEN
719: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
720: , G_MODULE_NAME || l_procedure_name || '.begin'
721: ,'enter procedure'

Line 719: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

715:
716: BEGIN
717: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
718: THEN
719: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
720: , G_MODULE_NAME || l_procedure_name || '.begin'
721: ,'enter procedure'
722: );
723: END IF;

Line 732: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

728: FETCH l_cto_amt_ap INTO
729: x_extended_amount;
730: CLOSE l_cto_amt_ap;
731:
732: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
733: THEN
734: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
735: , G_MODULE_NAME || l_procedure_name || '.end'
736: ,'exit procedure'

Line 734: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

730: CLOSE l_cto_amt_ap;
731:
732: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
733: THEN
734: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
735: , G_MODULE_NAME || l_procedure_name || '.end'
736: ,'exit procedure'
737: );
738: END IF;

Line 742: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

738: END IF;
739:
740: EXCEPTION
741: WHEN OTHERS THEN
742: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
743: THEN
744: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
745: , G_MODULE_NAME || l_procedure_name||'. Others exception'
746: , 'Exception'

Line 744: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

740: EXCEPTION
741: WHEN OTHERS THEN
742: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
743: THEN
744: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
745: , G_MODULE_NAME || l_procedure_name||'. Others exception'
746: , 'Exception'
747: );
748: END IF;

Line 780: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

776: AND modifier_level_code = 'LINE'
777: AND list_line_type_code = 'FREIGHT_CHARGE';
778:
779: BEGIN
780: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
781: THEN
782: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
783: , G_MODULE_NAME || l_procedure_name || '.begin'
784: ,'enter procedure'

Line 782: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

778:
779: BEGIN
780: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
781: THEN
782: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
783: , G_MODULE_NAME || l_procedure_name || '.begin'
784: ,'enter procedure'
785: );
786: END IF;

Line 803: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

799: --Use invoiced quantity to calculate the line level charge, because the
800: --invoiced qty may be different from the ordered quantity
801: x_line_freight_charge := l_line_freight_unit_amt * nvl(p_invoiced_line_qty,0);
802:
803: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
804: THEN
805: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
806: , G_MODULE_NAME || l_procedure_name || '.end'
807: ,'exit procedure'

Line 805: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

801: x_line_freight_charge := l_line_freight_unit_amt * nvl(p_invoiced_line_qty,0);
802:
803: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
804: THEN
805: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
806: , G_MODULE_NAME || l_procedure_name || '.end'
807: ,'exit procedure'
808: );
809: END IF;

Line 813: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

809: END IF;
810:
811: EXCEPTION
812: WHEN OTHERS THEN
813: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
814: THEN
815: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
816: , G_MODULE_NAME || l_procedure_name||'. Others exception'
817: , 'Exception'

Line 815: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

811: EXCEPTION
812: WHEN OTHERS THEN
813: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
814: THEN
815: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
816: , G_MODULE_NAME || l_procedure_name||'. Others exception'
817: , 'Exception'
818: );
819: END IF;

Line 894: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

890: AND ratl.sales_order = to_char(p_movement_transaction.order_number)
891: AND ratl.interface_line_attribute6 = l_line_id
892: AND ratl.interface_line_context <> 'INTERCOMPANY';
893: BEGIN
894: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
895: THEN
896: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
897: , G_MODULE_NAME || l_procedure_name || '.begin'
898: ,'enter procedure'

Line 896: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

892: AND ratl.interface_line_context <> 'INTERCOMPANY';
893: BEGIN
894: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
895: THEN
896: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
897: , G_MODULE_NAME || l_procedure_name || '.begin'
898: ,'enter procedure'
899: );
900: END IF;

Line 954: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

950:
951: x_total_invoiced_qty := l_total_invoiced_qty;
952: x_total_line_charge := l_total_line_charge;
953:
954: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
955: THEN
956: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
957: , G_MODULE_NAME || l_procedure_name || '.end'
958: ,'exit procedure'

Line 956: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

952: x_total_line_charge := l_total_line_charge;
953:
954: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
955: THEN
956: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
957: , G_MODULE_NAME || l_procedure_name || '.end'
958: ,'exit procedure'
959: );
960: END IF;

Line 964: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

960: END IF;
961:
962: EXCEPTION
963: WHEN OTHERS THEN
964: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
965: THEN
966: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
967: , G_MODULE_NAME || l_procedure_name||'. Others exception'
968: , 'Exception'

Line 966: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

962: EXCEPTION
963: WHEN OTHERS THEN
964: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
965: THEN
966: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
967: , G_MODULE_NAME || l_procedure_name||'. Others exception'
968: , 'Exception'
969: );
970: END IF;

Line 1182: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1178: WHERE aida.invoice_id = aia.invoice_id
1179: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
1180:
1181: BEGIN
1182: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1183: THEN
1184: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1185: , G_MODULE_NAME || l_procedure_name || '.begin'
1186: ,'enter procedure'

Line 1184: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1180:
1181: BEGIN
1182: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1183: THEN
1184: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1185: , G_MODULE_NAME || l_procedure_name || '.begin'
1186: ,'enter procedure'
1187: );
1188: END IF;

Line 1266: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1262: END IF;
1263: END IF;
1264: END IF;
1265:
1266: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1267: THEN
1268: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1269: , G_MODULE_NAME || l_procedure_name || '.end'
1270: ,'exit procedure'

Line 1268: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1264: END IF;
1265:
1266: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1267: THEN
1268: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1269: , G_MODULE_NAME || l_procedure_name || '.end'
1270: ,'exit procedure'
1271: );
1272: END IF;

Line 1276: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1272: END IF;
1273:
1274: EXCEPTION
1275: WHEN OTHERS THEN
1276: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1277: THEN
1278: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1279: , G_MODULE_NAME || l_procedure_name||'. Others exception'
1280: , 'Exception'

Line 1278: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1274: EXCEPTION
1275: WHEN OTHERS THEN
1276: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1277: THEN
1278: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1279: , G_MODULE_NAME || l_procedure_name||'. Others exception'
1280: , 'Exception'
1281: );
1282: END IF;

Line 1312: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1308: l_last_dayofperiod DATE;
1309: l_procedure_name CONSTANT VARCHAR2(30) := 'Calc_Exchange_Rate';
1310:
1311: BEGIN
1312: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1313: THEN
1314: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1315: , G_MODULE_NAME || l_procedure_name || '.begin'
1316: ,'enter procedure'

Line 1314: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1310:
1311: BEGIN
1312: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1313: THEN
1314: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1315: , G_MODULE_NAME || l_procedure_name || '.begin'
1316: ,'enter procedure'
1317: );
1318: END IF;

Line 1359: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1355: x_movement_transaction.currency_conversion_type := null;
1356: x_movement_transaction.currency_conversion_date := null;
1357: END IF;
1358:
1359: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1360: THEN
1361: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1362: , G_MODULE_NAME || l_procedure_name || '.end'
1363: ,'exit procedure'

Line 1361: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1357: END IF;
1358:
1359: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1360: THEN
1361: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1362: , G_MODULE_NAME || l_procedure_name || '.end'
1363: ,'exit procedure'
1364: );
1365: END IF;

Line 1369: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1365: END IF;
1366: EXCEPTION
1367: WHEN GL_CURRENCY_API.no_rate
1368: THEN
1369: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1370: THEN
1371: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1372: , G_MODULE_NAME || l_procedure_name||'.No rate exception'
1373: , 'Exception'

Line 1371: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1367: WHEN GL_CURRENCY_API.no_rate
1368: THEN
1369: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1370: THEN
1371: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1372: , G_MODULE_NAME || l_procedure_name||'.No rate exception'
1373: , 'Exception'
1374: );
1375: END IF;

Line 1381: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1377: x_movement_transaction.currency_conversion_type := null;
1378: x_movement_transaction.currency_conversion_date := null;
1379: WHEN NO_DATA_FOUND
1380: THEN
1381: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1382: THEN
1383: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1384: , G_MODULE_NAME || l_procedure_name||'.No data found exception'
1385: , 'Exception'

Line 1383: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1379: WHEN NO_DATA_FOUND
1380: THEN
1381: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1382: THEN
1383: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1384: , G_MODULE_NAME || l_procedure_name||'.No data found exception'
1385: , 'Exception'
1386: );
1387: END IF;

Line 1393: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1389: x_movement_transaction.currency_conversion_type := null;
1390: x_movement_transaction.currency_conversion_date := null;
1391: WHEN OTHERS
1392: THEN
1393: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1394: THEN
1395: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1396: , G_MODULE_NAME || l_procedure_name||'.Others exception'
1397: , 'Exception'

Line 1395: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1391: WHEN OTHERS
1392: THEN
1393: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1394: THEN
1395: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1396: , G_MODULE_NAME || l_procedure_name||'.Others exception'
1397: , 'Exception'
1398: );
1399: END IF;

Line 1451: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1447:
1448: BEGIN
1449:
1450: l_currency_conversion_rate := 1; -- 6889669
1451: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1452: THEN
1453: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1454: , G_MODULE_NAME || l_procedure_name || '.begin'
1455: ,'enter procedure'

Line 1453: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1449:
1450: l_currency_conversion_rate := 1; -- 6889669
1451: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1452: THEN
1453: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1454: , G_MODULE_NAME || l_procedure_name || '.begin'
1455: ,'enter procedure'
1456: );
1457: END IF;

Line 1514: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1510:
1511: /* Special case for Internal Orders - 6889669 - BEGIN */
1512: IF (l_movement_transaction.document_source_type = 'IO')
1513: THEN
1514: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1515: THEN
1516: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1517: , G_MODULE_NAME || l_procedure_name || '.begin'
1518: ,'in Calc Movement Amount for IO'

Line 1516: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1512: IF (l_movement_transaction.document_source_type = 'IO')
1513: THEN
1514: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1515: THEN
1516: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1517: , G_MODULE_NAME || l_procedure_name || '.begin'
1518: ,'in Calc Movement Amount for IO'
1519: );
1520: END IF;

Line 1540: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1536: AP_INVOICES_ALL
1537: WHERE
1538: invoice_id = l_movement_transaction.invoice_id ;
1539:
1540: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1541: THEN
1542: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1543: , G_MODULE_NAME || l_procedure_name || '.begin'
1544: ,'The I/C AP invoice currency is '||l_invoice_currency

Line 1542: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1538: invoice_id = l_movement_transaction.invoice_id ;
1539:
1540: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1541: THEN
1542: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1543: , G_MODULE_NAME || l_procedure_name || '.begin'
1544: ,'The I/C AP invoice currency is '||l_invoice_currency
1545: );
1546: END IF;

Line 1548: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1544: ,'The I/C AP invoice currency is '||l_invoice_currency
1545: );
1546: END IF;
1547:
1548: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1549: THEN
1550: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1551: , G_MODULE_NAME || l_procedure_name || '.begin'
1552: ,'The GL currency code is '||l_movement_transaction.gl_currency_code

Line 1550: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1546: END IF;
1547:
1548: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1549: THEN
1550: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1551: , G_MODULE_NAME || l_procedure_name || '.begin'
1552: ,'The GL currency code is '||l_movement_transaction.gl_currency_code
1553: );
1554: END IF;

Line 1559: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1555:
1556: IF (l_invoice_currency <> l_movement_transaction.gl_currency_code) THEN
1557: l_currency_conversion_rate := Get_Conversion_Rate(l_invoice_currency,l_movement_transaction );
1558: END IF;
1559: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1560: THEN
1561: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1562: , G_MODULE_NAME || l_procedure_name || '.begin'
1563: ,'The currency conversion is '||l_currency_conversion_rate

Line 1561: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1557: l_currency_conversion_rate := Get_Conversion_Rate(l_invoice_currency,l_movement_transaction );
1558: END IF;
1559: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1560: THEN
1561: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1562: , G_MODULE_NAME || l_procedure_name || '.begin'
1563: ,'The currency conversion is '||l_currency_conversion_rate
1564: );
1565: END IF;

Line 1569: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1565: END IF;
1566:
1567: EXCEPTION
1568: WHEN NO_DATA_FOUND THEN
1569: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1570: THEN
1571: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1572: , G_MODULE_NAME || l_procedure_name || '.begin'
1573: ,'No data found for Internal Order I/C AP'

Line 1571: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1567: EXCEPTION
1568: WHEN NO_DATA_FOUND THEN
1569: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1570: THEN
1571: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1572: , G_MODULE_NAME || l_procedure_name || '.begin'
1573: ,'No data found for Internal Order I/C AP'
1574: );
1575: END IF;

Line 1577: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1573: ,'No data found for Internal Order I/C AP'
1574: );
1575: END IF;
1576: WHEN OTHERS THEN
1577: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1578: THEN
1579: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1580: , G_MODULE_NAME || l_procedure_name || '.begin'
1581: ,'Others exception for Internal Order I/C AP'

Line 1579: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1575: END IF;
1576: WHEN OTHERS THEN
1577: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1578: THEN
1579: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1580: , G_MODULE_NAME || l_procedure_name || '.begin'
1581: ,'Others exception for Internal Order I/C AP'
1582: );
1583: END IF;

Line 1692: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1688: /* Special case for 6889669 */
1689: IF (l_movement_transaction.document_source_type = 'IO') AND (l_movement_transaction.movement_type = 'A')
1690: AND (nvl(l_currency_conversion_rate, 1)<>1) THEN
1691: l_tr_value := round (l_tr_value * l_currency_conversion_rate, 2);
1692: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1693: THEN
1694: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1695: , G_MODULE_NAME || l_procedure_name || '.begin'
1696: ,'l_tr_value for IO arrival is '||l_tr_value

Line 1694: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1690: AND (nvl(l_currency_conversion_rate, 1)<>1) THEN
1691: l_tr_value := round (l_tr_value * l_currency_conversion_rate, 2);
1692: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1693: THEN
1694: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1695: , G_MODULE_NAME || l_procedure_name || '.begin'
1696: ,'l_tr_value for IO arrival is '||l_tr_value
1697: );
1698: END IF;

Line 1719: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1715: ELSE
1716: l_tr_value := abs(l_tr_value);
1717: END IF;
1718:
1719: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1720: THEN
1721: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1722: , G_MODULE_NAME || l_procedure_name || '.end'
1723: ,'exit procedure'

Line 1721: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1717: END IF;
1718:
1719: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1720: THEN
1721: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1722: , G_MODULE_NAME || l_procedure_name || '.end'
1723: ,'exit procedure'
1724: );
1725: END IF;

Line 1727: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1723: ,'exit procedure'
1724: );
1725: END IF;
1726:
1727: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1728: THEN
1729: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1730: , G_MODULE_NAME || l_procedure_name || '.begin'
1731: ,'in Calc Movement Amountis '||l_tr_value

Line 1729: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1725: END IF;
1726:
1727: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1728: THEN
1729: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1730: , G_MODULE_NAME || l_procedure_name || '.begin'
1731: ,'in Calc Movement Amountis '||l_tr_value
1732: );
1733: END IF;

Line 1740: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1736: RETURN(l_tr_value);
1737:
1738: EXCEPTION
1739: WHEN NO_DATA_FOUND THEN
1740: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1741: THEN
1742: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1743: , G_MODULE_NAME || l_procedure_name||'. No data found exception'
1744: , 'Exception'

Line 1742: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1738: EXCEPTION
1739: WHEN NO_DATA_FOUND THEN
1740: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1741: THEN
1742: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1743: , G_MODULE_NAME || l_procedure_name||'. No data found exception'
1744: , 'Exception'
1745: );
1746: END IF;

Line 1749: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1745: );
1746: END IF;
1747: RETURN(0);
1748: WHEN OTHERS THEN
1749: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1750: THEN
1751: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1752: , G_MODULE_NAME || l_procedure_name||'. Others exception'
1753: , 'Exception'

Line 1751: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1747: RETURN(0);
1748: WHEN OTHERS THEN
1749: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1750: THEN
1751: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1752: , G_MODULE_NAME || l_procedure_name||'. Others exception'
1753: , 'Exception'
1754: );
1755: END IF;

Line 1812: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1808: WHERE interface_line_attribute6 = to_char(p_movement_transaction.order_line_id)
1809: AND sales_order = to_char(p_movement_transaction.order_number));
1810:
1811: BEGIN
1812: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1813: THEN
1814: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1815: , G_MODULE_NAME || l_procedure_name || '.begin'
1816: ,'enter procedure'

Line 1814: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1810:
1811: BEGIN
1812: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1813: THEN
1814: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1815: , G_MODULE_NAME || l_procedure_name || '.begin'
1816: ,'enter procedure'
1817: );
1818: END IF;

Line 1841: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1837:
1838: --Only calculate freight charge for SO where invoice and freight charge is
1839: --existed
1840:
1841: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1842: THEN
1843: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1844: , G_MODULE_NAME || l_procedure_name || '.movement amt in stat value is '
1845: ,p_movement_transaction.movement_amount

Line 1843: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1839: --existed
1840:
1841: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1842: THEN
1843: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1844: , G_MODULE_NAME || l_procedure_name || '.movement amt in stat value is '
1845: ,p_movement_transaction.movement_amount
1846: );
1847: END IF;

Line 1863: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1859: --Check if freight amount on invoice is null, cursor with sum function
1860: --is always return row, so can not use cursor%notfound to check
1861: IF l_inv_total_freight_amt IS NULL
1862: THEN
1863: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1864: THEN
1865: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1866: , G_MODULE_NAME || l_procedure_name
1867: || '.end no freight amt'

Line 1865: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1861: IF l_inv_total_freight_amt IS NULL
1862: THEN
1863: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1864: THEN
1865: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1866: , G_MODULE_NAME || l_procedure_name
1867: || '.end no freight amt'
1868: ,'exit procedure'
1869: );

Line 1921: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1917: ELSE
1918: l_stat_ext_value := l_movement_amount + l_stat_adj_amount;
1919: END IF;
1920:
1921: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1922: THEN
1923: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1924: , G_MODULE_NAME || l_procedure_name || '.end'
1925: ,'exit procedure'

Line 1923: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1919: END IF;
1920:
1921: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1922: THEN
1923: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1924: , G_MODULE_NAME || l_procedure_name || '.end'
1925: ,'exit procedure'
1926: );
1927: END IF;

Line 1933: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1929: RETURN(l_stat_ext_value);
1930:
1931: EXCEPTION
1932: WHEN NO_DATA_FOUND THEN
1933: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1934: THEN
1935: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1936: , G_MODULE_NAME || l_procedure_name||'. No data found exception'
1937: , 'Exception'

Line 1935: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1931: EXCEPTION
1932: WHEN NO_DATA_FOUND THEN
1933: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1934: THEN
1935: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1936: , G_MODULE_NAME || l_procedure_name||'. No data found exception'
1937: , 'Exception'
1938: );
1939: END IF;

Line 1942: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1938: );
1939: END IF;
1940: RETURN(l_movement_amount + l_stat_adj_amount);
1941: WHEN OTHERS THEN
1942: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1943: THEN
1944: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1945: , G_MODULE_NAME || l_procedure_name||'. Others exception'
1946: , 'Exception'

Line 1944: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1940: RETURN(l_movement_amount + l_stat_adj_amount);
1941: WHEN OTHERS THEN
1942: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1943: THEN
1944: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1945: , G_MODULE_NAME || l_procedure_name||'. Others exception'
1946: , 'Exception'
1947: );
1948: END IF;

Line 2621: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2617: THEN
2618: RETURN;
2619:
2620: ELSE
2621: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2622: THEN
2623: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2624: , G_MODULE_NAME || l_procedure_name || '.begin'
2625: ,'enter procedure'

Line 2623: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2619:
2620: ELSE
2621: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2622: THEN
2623: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2624: , G_MODULE_NAME || l_procedure_name || '.begin'
2625: ,'enter procedure'
2626: );
2627: END IF;

Line 2880: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2876: , x_movement_transaction.distribution_line_number
2877: , l_extended_amount
2878: , x_movement_transaction.invoice_quantity;
2879:
2880: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2881: THEN
2882: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2883: , G_MODULE_NAME || l_procedure_name || 'AP INTERCOMPANY INVOICE ID ********************* '
2884: , x_movement_transaction.invoice_id

Line 2882: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2878: , x_movement_transaction.invoice_quantity;
2879:
2880: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2881: THEN
2882: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2883: , G_MODULE_NAME || l_procedure_name || 'AP INTERCOMPANY INVOICE ID ********************* '
2884: , x_movement_transaction.invoice_id
2885: );
2886: END IF ;

Line 2927: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2923: , x_movement_transaction.currency_conversion_date
2924: , x_movement_transaction.invoice_batch_id
2925: , x_movement_transaction.invoice_date_reference;
2926:
2927: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2928: THEN
2929: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2930: , G_MODULE_NAME || l_procedure_name || 'AP INTERCOMPANY CURRENCY CODE ********************* '
2931: , x_movement_transaction.currency_code

Line 2929: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2925: , x_movement_transaction.invoice_date_reference;
2926:
2927: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2928: THEN
2929: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2930: , G_MODULE_NAME || l_procedure_name || 'AP INTERCOMPANY CURRENCY CODE ********************* '
2931: , x_movement_transaction.currency_code
2932: );
2933: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 2933: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2929: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2930: , G_MODULE_NAME || l_procedure_name || 'AP INTERCOMPANY CURRENCY CODE ********************* '
2931: , x_movement_transaction.currency_code
2932: );
2933: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2934: , G_MODULE_NAME || l_procedure_name || 'AP INTERCOMPANY currency_conversion_type ********************* '
2935: , x_movement_transaction.currency_conversion_rate
2936: );
2937: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 2937: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2933: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2934: , G_MODULE_NAME || l_procedure_name || 'AP INTERCOMPANY currency_conversion_type ********************* '
2935: , x_movement_transaction.currency_conversion_rate
2936: );
2937: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2938: , G_MODULE_NAME || l_procedure_name || 'AP INTERCOMPANYcurrency_conversion_typeE ********************* '
2939: , x_movement_transaction.currency_conversion_type
2940: );
2941: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 2941: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2937: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2938: , G_MODULE_NAME || l_procedure_name || 'AP INTERCOMPANYcurrency_conversion_typeE ********************* '
2939: , x_movement_transaction.currency_conversion_type
2940: );
2941: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2942: , G_MODULE_NAME || l_procedure_name || 'AP INTERCOMPANY currency_conversion_date********************* '
2943: , x_movement_transaction.currency_conversion_date
2944: );
2945: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 2945: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2941: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2942: , G_MODULE_NAME || l_procedure_name || 'AP INTERCOMPANY currency_conversion_date********************* '
2943: , x_movement_transaction.currency_conversion_date
2944: );
2945: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2946: , G_MODULE_NAME || l_procedure_name || 'AP INTERCOMPANY invoice_batch_id ********************* '
2947: , x_movement_transaction.invoice_batch_id
2948: );
2949:

Line 2950: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2946: , G_MODULE_NAME || l_procedure_name || 'AP INTERCOMPANY invoice_batch_id ********************* '
2947: , x_movement_transaction.invoice_batch_id
2948: );
2949:
2950: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2951: , G_MODULE_NAME || l_procedure_name || 'AP INTERCOMPANY invoice_date_reference ********************* '
2952: , x_movement_transaction.invoice_date_reference
2953: );
2954: END IF ;

Line 2998: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2994: /*********************************** Special case for an IO - END**************************************/
2995:
2996: IF l_movement_transaction.document_source_type = 'RMA'
2997: THEN
2998: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2999: THEN
3000: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3001: , G_MODULE_NAME || l_procedure_name || '.begin'
3002: ,'************ 2 RMA ******************'

Line 3000: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2996: IF l_movement_transaction.document_source_type = 'RMA'
2997: THEN
2998: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2999: THEN
3000: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3001: , G_MODULE_NAME || l_procedure_name || '.begin'
3002: ,'************ 2 RMA ******************'
3003: );
3004: END IF;

Line 3274: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3270: ELSE
3271:
3272: l_extended_amount := l_extended_amount + NVL(l_cm_extended_amount,0);
3273: x_movement_transaction.invoice_line_ext_value := l_extended_amount;
3274: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3275: THEN
3276: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3277: , G_MODULE_NAME || l_procedure_name || 'EXTENDED AMOUNT IS ********************* '
3278: , l_extended_amount

Line 3276: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3272: l_extended_amount := l_extended_amount + NVL(l_cm_extended_amount,0);
3273: x_movement_transaction.invoice_line_ext_value := l_extended_amount;
3274: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3275: THEN
3276: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3277: , G_MODULE_NAME || l_procedure_name || 'EXTENDED AMOUNT IS ********************* '
3278: , l_extended_amount
3279: );
3280: END IF ;

Line 3291: -- IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3287: AND x_movement_transaction.invoice_quantity <> 0)
3288: THEN
3289: x_movement_transaction.invoice_unit_price :=
3290: l_extended_amount / x_movement_transaction.invoice_quantity;
3291: -- IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3292: -- THEN
3293: -- FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3294: -- , G_MODULE_NAME || l_procedure_name || 'unit_price IS ********************* '
3295: -- , x_movement_transaction.invoice_unit_price

Line 3293: -- FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3289: x_movement_transaction.invoice_unit_price :=
3290: l_extended_amount / x_movement_transaction.invoice_quantity;
3291: -- IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3292: -- THEN
3293: -- FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3294: -- , G_MODULE_NAME || l_procedure_name || 'unit_price IS ********************* '
3295: -- , x_movement_transaction.invoice_unit_price
3296: -- );
3297: -- END IF ;

Line 3600: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3596: END IF;
3597: END IF;
3598: END IF;
3599:
3600: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3601: THEN
3602: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3603: , G_MODULE_NAME || l_procedure_name || '.end'
3604: ,'exit procedure'

Line 3602: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3598: END IF;
3599:
3600: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3601: THEN
3602: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3603: , G_MODULE_NAME || l_procedure_name || '.end'
3604: ,'exit procedure'
3605: );
3606: END IF;

Line 3611: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3607:
3608: EXCEPTION
3609: WHEN NO_DATA_FOUND
3610: THEN
3611: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3612: THEN
3613: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3614: , G_MODULE_NAME || l_procedure_name||'.No data found exception'
3615: , 'Exception'

Line 3613: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

3609: WHEN NO_DATA_FOUND
3610: THEN
3611: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3612: THEN
3613: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3614: , G_MODULE_NAME || l_procedure_name||'.No data found exception'
3615: , 'Exception'
3616: );
3617: END IF;

Line 3627: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3623: x_movement_transaction.order_line_id := l_cto_line_id;
3624: END IF;
3625: WHEN TOO_MANY_ROWS
3626: THEN
3627: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3628: THEN
3629: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3630: , G_MODULE_NAME || l_procedure_name||'.too many rows exception'
3631: , 'Exception'

Line 3629: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

3625: WHEN TOO_MANY_ROWS
3626: THEN
3627: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3628: THEN
3629: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3630: , G_MODULE_NAME || l_procedure_name||'.too many rows exception'
3631: , 'Exception'
3632: );
3633: END IF;

Line 3643: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3639: x_movement_transaction.order_line_id := l_cto_line_id;
3640: END IF;
3641: WHEN OTHERS
3642: THEN
3643: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3644: THEN
3645: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3646: , G_MODULE_NAME || l_procedure_name||'.Others exception'
3647: , 'Exception'

Line 3645: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

3641: WHEN OTHERS
3642: THEN
3643: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3644: THEN
3645: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3646: , G_MODULE_NAME || l_procedure_name||'.Others exception'
3647: , 'Exception'
3648: );
3649: END IF;

Line 3695: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3691: AND NVL(glp.adjustment_period_flag,'N') = 'N'
3692: AND trunc(p_period_date) BETWEEN trunc(glp.start_date) AND trunc(glp.end_date);
3693:
3694: BEGIN
3695: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3696: THEN
3697: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3698: , G_MODULE_NAME || l_function_name || '.begin'
3699: ,'enter procedure'

Line 3697: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3693:
3694: BEGIN
3695: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3696: THEN
3697: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3698: , G_MODULE_NAME || l_function_name || '.begin'
3699: ,'enter procedure'
3700: );
3701: END IF;

Line 3713: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3709: END IF;
3710:
3711: CLOSE c_pname;
3712:
3713: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3714: THEN
3715: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3716: , G_MODULE_NAME || l_function_name || '.end'
3717: ,'exit procedure'

Line 3715: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3711: CLOSE c_pname;
3712:
3713: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3714: THEN
3715: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3716: , G_MODULE_NAME || l_function_name || '.end'
3717: ,'exit procedure'
3718: );
3719: END IF;

Line 3725: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3721: RETURN l_set_of_books_period;
3722:
3723: EXCEPTION
3724: WHEN NO_DATA_FOUND THEN
3725: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3726: THEN
3727: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3728: , G_MODULE_NAME || l_function_name||'.No data found exception'
3729: , 'Exception'

Line 3727: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

3723: EXCEPTION
3724: WHEN NO_DATA_FOUND THEN
3725: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3726: THEN
3727: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3728: , G_MODULE_NAME || l_function_name||'.No data found exception'
3729: , 'Exception'
3730: );
3731: END IF;

Line 3735: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3731: END IF;
3732: RETURN null;
3733: WHEN TOO_MANY_ROWS
3734: THEN
3735: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3736: THEN
3737: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3738: , G_MODULE_NAME || l_function_name||'.too many rows exception'
3739: , 'Exception'

Line 3737: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

3733: WHEN TOO_MANY_ROWS
3734: THEN
3735: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3736: THEN
3737: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3738: , G_MODULE_NAME || l_function_name||'.too many rows exception'
3739: , 'Exception'
3740: );
3741: END IF;

Line 3744: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3740: );
3741: END IF;
3742: RETURN null;
3743: WHEN OTHERS THEN
3744: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3745: THEN
3746: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3747: , G_MODULE_NAME || l_function_name||'.Others exception'
3748: , 'Exception'

Line 3746: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

3742: RETURN null;
3743: WHEN OTHERS THEN
3744: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3745: THEN
3746: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3747: , G_MODULE_NAME || l_function_name||'.Others exception'
3748: , 'Exception'
3749: );
3750: END IF;

Line 3800: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3796: AND start_date >= l_stat_typ_transaction.start_date
3797: AND NVL(adjustment_period_flag,'N') = 'N';
3798:
3799: BEGIN
3800: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3801: THEN
3802: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3803: , G_MODULE_NAME || l_function_name || '.begin'
3804: ,'enter procedure'

Line 3802: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3798:
3799: BEGIN
3800: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3801: THEN
3802: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3803: , G_MODULE_NAME || l_function_name || '.begin'
3804: ,'enter procedure'
3805: );
3806: END IF;

Line 3837: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3833: CLOSE c_period1;
3834: END IF;
3835: END IF;
3836:
3837: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3838: THEN
3839: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3840: , G_MODULE_NAME || l_function_name || '.end'
3841: ,'exit procedure'

Line 3839: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3835: END IF;
3836:
3837: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3838: THEN
3839: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3840: , G_MODULE_NAME || l_function_name || '.end'
3841: ,'exit procedure'
3842: );
3843: END IF;

Line 3849: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3845: RETURN l_movement_transaction.period_name;
3846:
3847: EXCEPTION
3848: WHEN OTHERS THEN
3849: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3850: THEN
3851: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3852: , G_MODULE_NAME || l_function_name||'. Others exception'
3853: , 'Exception'

Line 3851: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

3847: EXCEPTION
3848: WHEN OTHERS THEN
3849: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3850: THEN
3851: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3852: , G_MODULE_NAME || l_function_name||'. Others exception'
3853: , 'Exception'
3854: );
3855: END IF;

Line 3883: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3879: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
3880: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Reference_Date';
3881:
3882: BEGIN
3883: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3884: THEN
3885: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3886: , G_MODULE_NAME || l_procedure_name || '.begin'
3887: ,'enter procedure'

Line 3885: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3881:
3882: BEGIN
3883: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3884: THEN
3885: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3886: , G_MODULE_NAME || l_procedure_name || '.begin'
3887: ,'enter procedure'
3888: );
3889: END IF;

Line 4002: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3998:
3999: x_movement_transaction.movement_status :='O';
4000: END IF;
4001:
4002: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4003: THEN
4004: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4005: , G_MODULE_NAME || l_procedure_name || '.end'
4006: ,'exit procedure'

Line 4004: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

4000: END IF;
4001:
4002: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4003: THEN
4004: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4005: , G_MODULE_NAME || l_procedure_name || '.end'
4006: ,'exit procedure'
4007: );
4008: END IF;

Line 4012: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

4008: END IF;
4009:
4010: EXCEPTION
4011: WHEN OTHERS THEN
4012: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4013: THEN
4014: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
4015: , G_MODULE_NAME || l_procedure_name||'. Others exception'
4016: , 'Exception'

Line 4014: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

4010: EXCEPTION
4011: WHEN OTHERS THEN
4012: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4013: THEN
4014: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
4015: , G_MODULE_NAME || l_procedure_name||'. Others exception'
4016: , 'Exception'
4017: );
4018: END IF;