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.GMF_LC_ADJ_TRANSACTIONS_PKG dependencies on FND_FILE

Line 217: fnd_file.put_line(fnd_file.log,'Entered Procedure: '||l_proc_name);

213:
214: BEGIN
215:
216: IF l_debug_level >= l_debug_level_medium THEN
217: fnd_file.put_line(fnd_file.log,'Entered Procedure: '||l_proc_name);
218: END IF;
219:
220: -- Initialize API return status to success
221: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 226: fnd_file.put_line(fnd_file.log,'Validating Rcv Ttransaction ID: ' ||p_adjustment_row.rcv_transaction_id ||

222:
223: p_validation_status:='S';
224:
225: IF l_debug_level >= l_debug_level_high THEN
226: fnd_file.put_line(fnd_file.log,'Validating Rcv Ttransaction ID: ' ||p_adjustment_row.rcv_transaction_id ||
227: ' Adjustment Num: '||p_adjustment_row.adjustment_num ||
228: ' Shipment Header ID: ' ||p_adjustment_row.ship_header_id ||
229: ' Shipment Line ID: ' ||p_adjustment_row.ship_line_id);
230: END IF;

Line 250: fnd_file.put_line(fnd_file.log,'Previous adj_num for the current line: ' || l_previous_adj_num);

246: AND ia.ship_line_id = p_adjustment_row.ship_line_id
247: AND ia.adjustment_num < p_adjustment_row.adjustment_num;
248:
249: IF l_debug_level >= l_debug_level_low THEN
250: fnd_file.put_line(fnd_file.log,'Previous adj_num for the current line: ' || l_previous_adj_num);
251: END IF;
252:
253: -- Get the prior landed cost for the current line
254: OPEN c_prior_landed_cost(

Line 270: fnd_file.put_line(fnd_file.log,'Prior landed cost for current line: ' || p_adjustment_row.prior_landed_cost);

266:
267: CLOSE c_prior_landed_cost;
268:
269: IF l_debug_level >= l_debug_level_low THEN
270: fnd_file.put_line(fnd_file.log,'Prior landed cost for current line: ' || p_adjustment_row.prior_landed_cost);
271: END IF;
272: END IF; */
273:
274: IF p_adjustment_row.component_type = 'CHARGE' THEN

Line 277: fnd_file.put_line(fnd_file.log,'Cost component class ID null for Charge type component');

273:
274: IF p_adjustment_row.component_type = 'CHARGE' THEN
275: -- populate cost component class id and analysis code
276: IF p_adjustment_row.cost_cmpntcls_id IS NULL THEN
277: fnd_file.put_line(fnd_file.log,'Cost component class ID null for Charge type component');
278: p_validation_status:='F';
279: /* exit from the loop --change pmarada */
280: ELSIF p_adjustment_row.cost_analysis_code IS NULL THEN
281: fnd_file.put_line(fnd_file.log,'Cost Analysis code is null for Charge type component');

Line 281: fnd_file.put_line(fnd_file.log,'Cost Analysis code is null for Charge type component');

277: fnd_file.put_line(fnd_file.log,'Cost component class ID null for Charge type component');
278: p_validation_status:='F';
279: /* exit from the loop --change pmarada */
280: ELSIF p_adjustment_row.cost_analysis_code IS NULL THEN
281: fnd_file.put_line(fnd_file.log,'Cost Analysis code is null for Charge type component');
282: p_validation_status:='F'; /* exit from the loop --change pmarada */
283: END IF;
284:
285: /* IF (p_adjustment_row.lc_adjustment_flag = 0 OR

Line 291: fnd_file.put_line(fnd_file.log,'Prior Landed Cost for Estimated Charge: ' || p_adjustment_row.prior_landed_cost);

287:
288: p_adjustment_row.prior_landed_cost := 0;
289:
290: IF l_debug_level >= l_debug_level_low THEN
291: fnd_file.put_line(fnd_file.log,'Prior Landed Cost for Estimated Charge: ' || p_adjustment_row.prior_landed_cost);
292: END IF;
293: END IF; */
294: ELSIF p_adjustment_row.component_type = 'ITEM PRICE' THEN
295: IF (p_adjustment_row.cost_cmpntcls_id IS NULL OR

Line 299: fnd_file.put_line(fnd_file.log,'Open cursor to get Componet Class Id and Analysis Code from item materials');

295: IF (p_adjustment_row.cost_cmpntcls_id IS NULL OR
296: p_adjustment_row.cost_analysis_code IS NULL) THEN
297:
298: IF l_debug_level >= l_debug_level_medium THEN
299: fnd_file.put_line(fnd_file.log,'Open cursor to get Componet Class Id and Analysis Code from item materials');
300: END IF;
301: -- get cost componet class id and analysis code
302: OPEN cur_get_costcptcls(p_le_id,
303: p_adjustment_row.inventory_item_id,

Line 310: fnd_file.put_line(fnd_file.log,'Open cursor to get Cost Componet Class Id and Analysis Code from default fiscal policies');

306: FETCH cur_get_costcptcls INTO l_cost_cmpntcls_id, l_analysis_code, l_dummy;
307: CLOSE cur_get_costcptcls;
308:
309: IF l_debug_level >= l_debug_level_medium THEN
310: fnd_file.put_line(fnd_file.log,'Open cursor to get Cost Componet Class Id and Analysis Code from default fiscal policies');
311: END IF;
312:
313: IF p_adjustment_row.cost_cmpntcls_id IS NULL THEN
314: p_adjustment_row.cost_cmpntcls_id := l_cost_cmpntcls_id;

Line 322: fnd_file.put_line(fnd_file.log,'Populate Cost component class ID for item Charge '||p_adjustment_row.cost_cmpntcls_id);

318: p_adjustment_row.cost_analysis_code := l_analysis_code;
319: END IF;
320:
321: IF l_debug_level >= l_debug_level_low THEN
322: fnd_file.put_line(fnd_file.log,'Populate Cost component class ID for item Charge '||p_adjustment_row.cost_cmpntcls_id);
323: fnd_file.put_line(fnd_file.log,'Populate Cost analysis code for item Charge '||p_adjustment_row.cost_analysis_code);
324: END IF;
325:
326: END IF; /* end for cost component class */

Line 323: fnd_file.put_line(fnd_file.log,'Populate Cost analysis code for item Charge '||p_adjustment_row.cost_analysis_code);

319: END IF;
320:
321: IF l_debug_level >= l_debug_level_low THEN
322: fnd_file.put_line(fnd_file.log,'Populate Cost component class ID for item Charge '||p_adjustment_row.cost_cmpntcls_id);
323: fnd_file.put_line(fnd_file.log,'Populate Cost analysis code for item Charge '||p_adjustment_row.cost_analysis_code);
324: END IF;
325:
326: END IF; /* end for cost component class */
327:

Line 344: fnd_file.put_line(fnd_file.log,'Prior Landed Cost for Estimated: ' || p_adjustment_row.prior_landed_cost);

340: FROM rcv_transactions rt
341: WHERE rt.transaction_id = p_adjustment_row.rcv_transaction_id;
342:
343: IF l_debug_level >= l_debug_level_low THEN
344: fnd_file.put_line(fnd_file.log,'Prior Landed Cost for Estimated: ' || p_adjustment_row.prior_landed_cost);
345: END IF;
346: END IF;
347: END IF; /* end for item price component type */
348:

Line 350: fnd_file.put_line(fnd_file.log,'Start validation');

346: END IF;
347: END IF; /* end for item price component type */
348:
349: IF l_debug_level >= l_debug_level_low THEN
350: fnd_file.put_line(fnd_file.log,'Start validation');
351: END IF;
352:
353: IF p_adjustment_row.new_landed_cost < 0 THEN
354: fnd_file.put_line(fnd_file.log,'New landed cost is less than zero. Then skipping to insert in transactions table');

Line 354: fnd_file.put_line(fnd_file.log,'New landed cost is less than zero. Then skipping to insert in transactions table');

350: fnd_file.put_line(fnd_file.log,'Start validation');
351: END IF;
352:
353: IF p_adjustment_row.new_landed_cost < 0 THEN
354: fnd_file.put_line(fnd_file.log,'New landed cost is less than zero. Then skipping to insert in transactions table');
355: p_validation_status:='F';
356: ELSIF p_adjustment_row.prior_landed_cost <0 THEN
357: fnd_file.put_line(fnd_file.log,'Prior landed cost amount is less than zero. Then skipping to insert in transactions table');
358: p_validation_status:='F';

Line 357: fnd_file.put_line(fnd_file.log,'Prior landed cost amount is less than zero. Then skipping to insert in transactions table');

353: IF p_adjustment_row.new_landed_cost < 0 THEN
354: fnd_file.put_line(fnd_file.log,'New landed cost is less than zero. Then skipping to insert in transactions table');
355: p_validation_status:='F';
356: ELSIF p_adjustment_row.prior_landed_cost <0 THEN
357: fnd_file.put_line(fnd_file.log,'Prior landed cost amount is less than zero. Then skipping to insert in transactions table');
358: p_validation_status:='F';
359: ELSIF ((p_adjustment_row.new_landed_cost - p_adjustment_row.prior_landed_cost) = 0) THEN
360: fnd_file.put_line(fnd_file.log,'Adjustment amount is zero. Then skipping to insert in transactions table');
361: p_validation_status:='F';

Line 360: fnd_file.put_line(fnd_file.log,'Adjustment amount is zero. Then skipping to insert in transactions table');

356: ELSIF p_adjustment_row.prior_landed_cost <0 THEN
357: fnd_file.put_line(fnd_file.log,'Prior landed cost amount is less than zero. Then skipping to insert in transactions table');
358: p_validation_status:='F';
359: ELSIF ((p_adjustment_row.new_landed_cost - p_adjustment_row.prior_landed_cost) = 0) THEN
360: fnd_file.put_line(fnd_file.log,'Adjustment amount is zero. Then skipping to insert in transactions table');
361: p_validation_status:='F';
362: ELSIF p_adjustment_row.rcv_transaction_id <=0 THEN
363: fnd_file.put_line(fnd_file.log,'Invalid Rcv Transaction. Then skipping to insert in transactions table');
364: p_validation_status:='F';

Line 363: fnd_file.put_line(fnd_file.log,'Invalid Rcv Transaction. Then skipping to insert in transactions table');

359: ELSIF ((p_adjustment_row.new_landed_cost - p_adjustment_row.prior_landed_cost) = 0) THEN
360: fnd_file.put_line(fnd_file.log,'Adjustment amount is zero. Then skipping to insert in transactions table');
361: p_validation_status:='F';
362: ELSIF p_adjustment_row.rcv_transaction_id <=0 THEN
363: fnd_file.put_line(fnd_file.log,'Invalid Rcv Transaction. Then skipping to insert in transactions table');
364: p_validation_status:='F';
365: ELSIF p_adjustment_row.rcv_transaction_id > 0 THEN
366:
367: IF l_debug_level >= l_debug_level_medium THEN

Line 368: fnd_file.put_line(fnd_file.log,'Checking lcm flag');

364: p_validation_status:='F';
365: ELSIF p_adjustment_row.rcv_transaction_id > 0 THEN
366:
367: IF l_debug_level >= l_debug_level_medium THEN
368: fnd_file.put_line(fnd_file.log,'Checking lcm flag');
369: END IF;
370:
371: OPEN check_lcm_flag ;
372: FETCH check_lcm_flag INTO l_lcm_flag, l_inventory_item_id;

Line 376: fnd_file.put_line(fnd_file.log,'LCM Flag: ' || l_lcm_flag || 'Inventory Item Id' ||l_inventory_item_id);

372: FETCH check_lcm_flag INTO l_lcm_flag, l_inventory_item_id;
373: CLOSE check_lcm_flag;
374:
375: IF l_debug_level >= l_debug_level_medium THEN
376: fnd_file.put_line(fnd_file.log,'LCM Flag: ' || l_lcm_flag || 'Inventory Item Id' ||l_inventory_item_id);
377: END IF;
378:
379: IF l_lcm_flag = 'N' THEN
380: fnd_file.put_line(fnd_file.log,'PO Shipment is not LCM Enabled. then skipping to insert in transactions table');

Line 380: fnd_file.put_line(fnd_file.log,'PO Shipment is not LCM Enabled. then skipping to insert in transactions table');

376: fnd_file.put_line(fnd_file.log,'LCM Flag: ' || l_lcm_flag || 'Inventory Item Id' ||l_inventory_item_id);
377: END IF;
378:
379: IF l_lcm_flag = 'N' THEN
380: fnd_file.put_line(fnd_file.log,'PO Shipment is not LCM Enabled. then skipping to insert in transactions table');
381: p_validation_status:='F';
382: ELSIF p_adjustment_row.inventory_item_id <> l_inventory_item_id THEN
383: fnd_file.put_line(fnd_file.log,'Not matched Item. then skipping to insert in transactions table');
384: p_validation_status:='F';

Line 383: fnd_file.put_line(fnd_file.log,'Not matched Item. then skipping to insert in transactions table');

379: IF l_lcm_flag = 'N' THEN
380: fnd_file.put_line(fnd_file.log,'PO Shipment is not LCM Enabled. then skipping to insert in transactions table');
381: p_validation_status:='F';
382: ELSIF p_adjustment_row.inventory_item_id <> l_inventory_item_id THEN
383: fnd_file.put_line(fnd_file.log,'Not matched Item. then skipping to insert in transactions table');
384: p_validation_status:='F';
385: END IF;
386: END IF;
387:

Line 389: fnd_file.put_line(fnd_file.log,'Component Type: ' || p_adjustment_row.component_type);

385: END IF;
386: END IF;
387:
388: IF l_debug_level >= l_debug_level_medium THEN
389: fnd_file.put_line(fnd_file.log,'Component Type: ' || p_adjustment_row.component_type);
390: END IF;
391:
392: IF (p_adjustment_row.cost_cmpntcls_id IS NOT NULL OR
393: p_adjustment_row.cost_analysis_code IS NOT NULL) THEN

Line 396: fnd_file.put_line(fnd_file.log,'Validate Cost Component Class');

392: IF (p_adjustment_row.cost_cmpntcls_id IS NOT NULL OR
393: p_adjustment_row.cost_analysis_code IS NOT NULL) THEN
394:
395: IF l_debug_level >= l_debug_level_medium THEN
396: fnd_file.put_line(fnd_file.log,'Validate Cost Component Class');
397: END IF;
398:
399: -- validate cost component class id, should exists in CM_CMPT_MST table
400: OPEN cur_costcptcls_exists(p_adjustment_row.cost_cmpntcls_id);

Line 403: fnd_file.put_line(fnd_file.log,'Cost component class ID is not valid, not exists in cost components table');

399: -- validate cost component class id, should exists in CM_CMPT_MST table
400: OPEN cur_costcptcls_exists(p_adjustment_row.cost_cmpntcls_id);
401: FETCH cur_costcptcls_exists INTO l_exists;
402: IF cur_costcptcls_exists%NOTFOUND THEN
403: fnd_file.put_line(fnd_file.log,'Cost component class ID is not valid, not exists in cost components table');
404: p_validation_status:='F';
405: END IF;
406: CLOSE cur_costcptcls_exists;
407:

Line 409: fnd_file.put_line(fnd_file.log,'Open cursor to validate Cost Analysis Code');

405: END IF;
406: CLOSE cur_costcptcls_exists;
407:
408: IF l_debug_level >= l_debug_level_medium THEN
409: fnd_file.put_line(fnd_file.log,'Open cursor to validate Cost Analysis Code');
410: END IF;
411:
412: -- Validate cost analysis code, cost analysis code should exists in CM_ALYS_MST table
413: OPEN cur_analysis_cd_exists (p_adjustment_row.cost_analysis_code);

Line 416: fnd_file.put_line(fnd_file.log,'Cost Analysis code is not valid, not exists in cost components table');

412: -- Validate cost analysis code, cost analysis code should exists in CM_ALYS_MST table
413: OPEN cur_analysis_cd_exists (p_adjustment_row.cost_analysis_code);
414: FETCH cur_analysis_cd_exists INTO l_exists;
415: IF cur_analysis_cd_exists%NOTFOUND THEN
416: fnd_file.put_line(fnd_file.log,'Cost Analysis code is not valid, not exists in cost components table');
417: p_validation_status:='F';
418: END IF;
419: CLOSE cur_analysis_cd_exists;
420: END IF;

Line 423: fnd_file.put_line(fnd_file.log,'Transaction Type: ' || p_adjustment_row.rcv_transaction_type);

419: CLOSE cur_analysis_cd_exists;
420: END IF;
421:
422: IF l_debug_level >= l_debug_level_low THEN
423: fnd_file.put_line(fnd_file.log,'Transaction Type: ' || p_adjustment_row.rcv_transaction_type);
424: END IF;
425:
426: -- populate Event columns
427: IF l_debug_level >= l_debug_level_low THEN

Line 428: fnd_file.put_line(fnd_file.log,'Define Event Types');

424: END IF;
425:
426: -- populate Event columns
427: IF l_debug_level >= l_debug_level_low THEN
428: fnd_file.put_line(fnd_file.log,'Define Event Types');
429: END IF;
430:
431: IF p_adjustment_row.rcv_transaction_type = 'DELIVER' THEN
432:

Line 438: fnd_file.put_line(fnd_file.log,'Asset Inventory:' || l_asset_inventory);

434: FETCH cur_asset_inventory INTO l_asset_inventory;
435: CLOSE cur_asset_inventory;
436:
437: IF l_debug_level >= l_debug_level_medium THEN
438: fnd_file.put_line(fnd_file.log,'Asset Inventory:' || l_asset_inventory);
439: END IF;
440: /* assest inventory is means assest sub inventory else expanse sub inventory */
441: IF l_asset_inventory = 1 THEN
442: p_adjustment_row.event_type := 16;

Line 468: fnd_file.put_line(fnd_file.log,'Prorated deliver transaction prorated new landed cost: '||l_new_landed_cost ||

464:
465: l_new_landed_cost := (p_adjustment_row.primary_quantity * p_adjustment_row.new_landed_cost)/nvl(l_rcv_primary_qty,1);
466:
467: IF l_debug_level >= l_debug_level_low THEN
468: fnd_file.put_line(fnd_file.log,'Prorated deliver transaction prorated new landed cost: '||l_new_landed_cost ||
469: 'new landed cost: '||p_adjustment_row.new_landed_cost||'deliver trans qty: '||p_adjustment_row.primary_quantity||
470: 'parent trans qty: '||l_rcv_primary_qty);
471: END IF;
472: p_adjustment_row.new_landed_cost := l_new_landed_cost;

Line 481: fnd_file.put_line(fnd_file.log,'Prorated deliver transaction prorated prior landed cost: '||l_prorated_prior_lc ||

477:
478: l_prorated_prior_lc := (p_adjustment_row.primary_quantity * p_adjustment_row.prior_landed_cost)/nvl(l_rcv_primary_qty,1);
479:
480: IF l_debug_level >= l_debug_level_low THEN
481: fnd_file.put_line(fnd_file.log,'Prorated deliver transaction prorated prior landed cost: '||l_prorated_prior_lc ||
482: 'prior landed cost: '||p_adjustment_row.prior_landed_cost||'deliver trans qty: '||p_adjustment_row.primary_quantity||
483: 'parent trans qty: '||l_rcv_primary_qty);
484: END IF;
485: p_adjustment_row.prior_landed_cost := l_prorated_prior_lc;

Line 495: fnd_file.put_line(fnd_file.log,'RCV Transaction type:' || p_adjustment_row.rcv_transaction_type);

491:
492: ELSIF (p_adjustment_row.rcv_transaction_type = 'RETURN TO VENDOR') THEN
493:
494: IF l_debug_level >= l_debug_level_medium THEN
495: fnd_file.put_line(fnd_file.log,'RCV Transaction type:' || p_adjustment_row.rcv_transaction_type);
496: END IF;
497: /* for Return to vendor transaction destination type is receiving */
498: p_adjustment_row.event_type := 15;
499: p_adjustment_row.event_source := 'LC_ADJUST_RECEIPT';

Line 522: fnd_file.put_line(fnd_file.log,'Prorated return to vendor transaction. prorated new landed cost: '||l_new_landed_cost ||

518:
519: l_new_landed_cost := (p_adjustment_row.primary_quantity * p_adjustment_row.new_landed_cost)/nvl(l_rcv_primary_qty,1);
520:
521: IF l_debug_level >= l_debug_level_low THEN
522: fnd_file.put_line(fnd_file.log,'Prorated return to vendor transaction. prorated new landed cost: '||l_new_landed_cost ||
523: 'new landed cost: '||p_adjustment_row.new_landed_cost||'return to vendor trans qty: '||p_adjustment_row.primary_quantity||
524: 'parent receive trans qty: '||l_rcv_primary_qty);
525: END IF;
526: p_adjustment_row.new_landed_cost := l_new_landed_cost;

Line 535: fnd_file.put_line(fnd_file.log,'Prorated return to vendor transaction. prorated prior landed cost: '||l_prorated_prior_lc ||

531:
532: l_prorated_prior_lc := (p_adjustment_row.primary_quantity * p_adjustment_row.prior_landed_cost)/nvl(l_rcv_primary_qty,1);
533:
534: IF l_debug_level >= l_debug_level_low THEN
535: fnd_file.put_line(fnd_file.log,'Prorated return to vendor transaction. prorated prior landed cost: '||l_prorated_prior_lc ||
536: 'prior landed cost: '||p_adjustment_row.prior_landed_cost||'return to vendor trans qty: '||p_adjustment_row.primary_quantity||
537: 'parent receive trans qty: '||l_rcv_primary_qty);
538: END IF;
539: p_adjustment_row.prior_landed_cost := l_prorated_prior_lc;

Line 547: fnd_file.put_line(fnd_file.log,'RCV Transaction type:' || p_adjustment_row.rcv_transaction_type);

543:
544: ELSIF p_adjustment_row.rcv_transaction_type = 'RETURN TO RECEIVING' THEN
545:
546: IF l_debug_level >= l_debug_level_medium THEN
547: fnd_file.put_line(fnd_file.log,'RCV Transaction type:' || p_adjustment_row.rcv_transaction_type);
548: END IF;
549: OPEN cur_asset_inventory (p_adjustment_row.rcv_transaction_id);
550: FETCH cur_asset_inventory INTO l_asset_inventory;
551: CLOSE cur_asset_inventory;

Line 554: fnd_file.put_line(fnd_file.log,'Asset Inventory:' || l_asset_inventory);

550: FETCH cur_asset_inventory INTO l_asset_inventory;
551: CLOSE cur_asset_inventory;
552:
553: IF l_debug_level >= l_debug_level_medium THEN
554: fnd_file.put_line(fnd_file.log,'Asset Inventory:' || l_asset_inventory);
555: END IF;
556: /* Return to receiving transaction destination type is deliver */
557: /* assest inventory is means assest sub inventory else expanse sub inventory */
558: IF l_asset_inventory = 1 THEN

Line 586: fnd_file.put_line(fnd_file.log,'Prorated return to receiving transaction. prorated new landed cost: '||l_new_landed_cost ||

582:
583: l_new_landed_cost := (p_adjustment_row.primary_quantity * p_adjustment_row.new_landed_cost)/nvl(l_rcv_primary_qty,1);
584:
585: IF l_debug_level >= l_debug_level_low THEN
586: fnd_file.put_line(fnd_file.log,'Prorated return to receiving transaction. prorated new landed cost: '||l_new_landed_cost ||
587: 'new landed cost: '||p_adjustment_row.new_landed_cost||'return to receiving trans qty: '||p_adjustment_row.primary_quantity||
588: 'parent deliver trans qty: '||l_rcv_primary_qty);
589: END IF;
590: p_adjustment_row.new_landed_cost := l_new_landed_cost;

Line 599: fnd_file.put_line(fnd_file.log,'Prorated return to receiving transaction. prorated prior landed cost: '||l_prorated_prior_lc ||

595:
596: l_prorated_prior_lc := (p_adjustment_row.primary_quantity * p_adjustment_row.prior_landed_cost)/nvl(l_rcv_primary_qty,1);
597:
598: IF l_debug_level >= l_debug_level_low THEN
599: fnd_file.put_line(fnd_file.log,'Prorated return to receiving transaction. prorated prior landed cost: '||l_prorated_prior_lc ||
600: 'prior landed cost: '||p_adjustment_row.prior_landed_cost||'return to receiving trans qty: '||p_adjustment_row.primary_quantity||
601: 'parent deliver trans qty: '||l_rcv_primary_qty);
602: END IF;
603: p_adjustment_row.prior_landed_cost := l_prorated_prior_lc;

Line 619: fnd_file.put_line(fnd_file.log,'RCV Transaction type:' || p_adjustment_row.rcv_transaction_type

615: CLOSE get_rcv_trans;
616: IF l_destination_type_code = 'INVENTORY' THEN
617:
618: IF l_debug_level >= l_debug_level_medium THEN
619: fnd_file.put_line(fnd_file.log,'RCV Transaction type:' || p_adjustment_row.rcv_transaction_type
620: ||'Destination type: '||l_destination_type_code);
621: END IF;
622: OPEN cur_asset_inventory (p_adjustment_row.rcv_transaction_id);
623: FETCH cur_asset_inventory INTO l_asset_inventory;

Line 627: fnd_file.put_line(fnd_file.log,'Asset Inventory:' || l_asset_inventory);

623: FETCH cur_asset_inventory INTO l_asset_inventory;
624: CLOSE cur_asset_inventory;
625:
626: IF l_debug_level >= l_debug_level_medium THEN
627: fnd_file.put_line(fnd_file.log,'Asset Inventory:' || l_asset_inventory);
628: END IF;
629: /* Correct transaction destination type is inventory */
630: /* assest inventory is means assest sub inventory else expanse sub inventory */
631: IF l_asset_inventory = 1 THEN

Line 640: fnd_file.put_line(fnd_file.log,'RCV Transaction type:' || p_adjustment_row.rcv_transaction_type

636: p_adjustment_row.event_source := 'LC_ADJUST_EXP_DELIVER';
637: END IF;
638: ELSE -- destination type receive
639: IF l_debug_level >= l_debug_level_medium THEN
640: fnd_file.put_line(fnd_file.log,'RCV Transaction type:' || p_adjustment_row.rcv_transaction_type
641: ||'Destination type: '||l_destination_type_code);
642: END IF;
643: p_adjustment_row.event_type := 15;
644: p_adjustment_row.event_source := 'LC_ADJUST_RECEIPT';

Line 662: fnd_file.put_line(fnd_file.log,'Prorated Correct transaction. prorated new landed cost: '||l_new_landed_cost ||

658:
659: l_new_landed_cost := (p_adjustment_row.primary_quantity * p_adjustment_row.new_landed_cost)/nvl(l_rcv_primary_qty,1);
660:
661: IF l_debug_level >= l_debug_level_low THEN
662: fnd_file.put_line(fnd_file.log,'Prorated Correct transaction. prorated new landed cost: '||l_new_landed_cost ||
663: 'new landed cost: '||p_adjustment_row.new_landed_cost||'correct trans qty: '||p_adjustment_row.primary_quantity||
664: 'parent trans qty: '||l_rcv_primary_qty);
665: END IF;
666: p_adjustment_row.new_landed_cost := l_new_landed_cost;

Line 675: fnd_file.put_line(fnd_file.log,'Prorated correct transaction. prorated prior landed cost: '||l_prorated_prior_lc ||

671:
672: l_prorated_prior_lc := (p_adjustment_row.primary_quantity * p_adjustment_row.prior_landed_cost)/nvl(l_rcv_primary_qty,1);
673:
674: IF l_debug_level >= l_debug_level_low THEN
675: fnd_file.put_line(fnd_file.log,'Prorated correct transaction. prorated prior landed cost: '||l_prorated_prior_lc ||
676: 'prior landed cost: '||p_adjustment_row.prior_landed_cost||'correct trans qty: '||p_adjustment_row.primary_quantity||
677: 'parent trans qty: '||l_rcv_primary_qty);
678: END IF;
679: p_adjustment_row.prior_landed_cost := l_prorated_prior_lc;

Line 688: fnd_file.put_line(fnd_file.log,'RCV Transaction Type:'|| p_adjustment_row.rcv_transaction_type);

684: p_adjustment_row.event_source_id := p_adjustment_row.rcv_transaction_id;
685:
686: ELSE
687: IF l_debug_level >= l_debug_level_low THEN
688: fnd_file.put_line(fnd_file.log,'RCV Transaction Type:'|| p_adjustment_row.rcv_transaction_type);
689: END IF;
690: p_adjustment_row.event_type := 15;
691: p_adjustment_row.event_source := 'LC_ADJUST_RECEIPT';
692: p_adjustment_row.event_source_id := p_adjustment_row.rcv_transaction_id;

Line 696: fnd_file.put_line(fnd_file.log,'Event Type:' || p_adjustment_row.event_type);

692: p_adjustment_row.event_source_id := p_adjustment_row.rcv_transaction_id;
693: END IF;
694:
695: IF l_debug_level >= l_debug_level_medium THEN
696: fnd_file.put_line(fnd_file.log,'Event Type:' || p_adjustment_row.event_type);
697: fnd_file.put_line(fnd_file.log,'Event Source:' || p_adjustment_row.event_source);
698: fnd_file.put_line(fnd_file.log,'Event Source Id:' || p_adjustment_row.event_source_id);
699: END IF;
700:

Line 697: fnd_file.put_line(fnd_file.log,'Event Source:' || p_adjustment_row.event_source);

693: END IF;
694:
695: IF l_debug_level >= l_debug_level_medium THEN
696: fnd_file.put_line(fnd_file.log,'Event Type:' || p_adjustment_row.event_type);
697: fnd_file.put_line(fnd_file.log,'Event Source:' || p_adjustment_row.event_source);
698: fnd_file.put_line(fnd_file.log,'Event Source Id:' || p_adjustment_row.event_source_id);
699: END IF;
700:
701: IF l_debug_level >= l_debug_level_medium THEN

Line 698: fnd_file.put_line(fnd_file.log,'Event Source Id:' || p_adjustment_row.event_source_id);

694:
695: IF l_debug_level >= l_debug_level_medium THEN
696: fnd_file.put_line(fnd_file.log,'Event Type:' || p_adjustment_row.event_type);
697: fnd_file.put_line(fnd_file.log,'Event Source:' || p_adjustment_row.event_source);
698: fnd_file.put_line(fnd_file.log,'Event Source Id:' || p_adjustment_row.event_source_id);
699: END IF;
700:
701: IF l_debug_level >= l_debug_level_medium THEN
702: fnd_file.put_line(fnd_file.log,'Leaving Procedure: '||l_proc_name);

Line 702: fnd_file.put_line(fnd_file.log,'Leaving Procedure: '||l_proc_name);

698: fnd_file.put_line(fnd_file.log,'Event Source Id:' || p_adjustment_row.event_source_id);
699: END IF;
700:
701: IF l_debug_level >= l_debug_level_medium THEN
702: fnd_file.put_line(fnd_file.log,'Leaving Procedure: '||l_proc_name);
703: END IF;
704:
705: EXCEPTION
706: WHEN OTHERS THEN

Line 708: fnd_file.put_line(fnd_file.log,'Error: '||SQLERRM);

704:
705: EXCEPTION
706: WHEN OTHERS THEN
707: IF l_debug_level >= l_debug_level_medium THEN
708: fnd_file.put_line(fnd_file.log,'Error: '||SQLERRM);
709: END IF;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: p_validation_status := 'F';
712:

Line 755: fnd_file.put_line(fnd_file.log,'Entered Procedure: '||l_proc_name);

751: -- Initialize API return status to success
752: x_return_status := FND_API.G_RET_STS_SUCCESS;
753:
754: IF l_debug_level >= l_debug_level_medium THEN
755: fnd_file.put_line(fnd_file.log,'Entered Procedure: '||l_proc_name);
756: END IF;
757:
758: INSERT INTO gmf_lc_adj_transactions
759: (adj_transaction_id, -- 01

Line 868: fnd_file.put_line(fnd_file.log,'Leaving Procedure: '||l_proc_name);

864: SYSDATE -- 51
865: );
866:
867: IF l_debug_level >= l_debug_level_medium THEN
868: fnd_file.put_line(fnd_file.log,'Leaving Procedure: '||l_proc_name);
869: END IF;
870: --
871: EXCEPTION
872: WHEN OTHERS THEN

Line 874: fnd_file.put_line(fnd_file.log,'Error: '||SQLERRM);

870: --
871: EXCEPTION
872: WHEN OTHERS THEN
873: IF l_debug_level >= l_debug_level_medium THEN
874: fnd_file.put_line(fnd_file.log,'Error: '||SQLERRM);
875: fnd_file.put_line(fnd_file.log,'Failed to insert into adjsutment transactions table in '||l_proc_name);
876: END IF;
877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
878: END Create_AdjTrxLines;

Line 875: fnd_file.put_line(fnd_file.log,'Failed to insert into adjsutment transactions table in '||l_proc_name);

871: EXCEPTION
872: WHEN OTHERS THEN
873: IF l_debug_level >= l_debug_level_medium THEN
874: fnd_file.put_line(fnd_file.log,'Error: '||SQLERRM);
875: fnd_file.put_line(fnd_file.log,'Failed to insert into adjsutment transactions table in '||l_proc_name);
876: END IF;
877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
878: END Create_AdjTrxLines;
879:

Line 1074: fnd_file.put_line(fnd_file.log,'GMF_CONC_DEBUG Profile value : '||l_debug_level);

1070: l_to_organization_id := p_to_organization_id;
1071: l_from_item_id := p_from_inventory_item_id;
1072: l_to_item_id := p_to_inventory_item_id;
1073:
1074: fnd_file.put_line(fnd_file.log,'GMF_CONC_DEBUG Profile value : '||l_debug_level);
1075: IF l_debug_level >= l_debug_level_medium THEN
1076: fnd_file.put_line(fnd_file.log,'Entered Procedure: '||l_proc_name);
1077: END IF;
1078:

Line 1076: fnd_file.put_line(fnd_file.log,'Entered Procedure: '||l_proc_name);

1072: l_to_item_id := p_to_inventory_item_id;
1073:
1074: fnd_file.put_line(fnd_file.log,'GMF_CONC_DEBUG Profile value : '||l_debug_level);
1075: IF l_debug_level >= l_debug_level_medium THEN
1076: fnd_file.put_line(fnd_file.log,'Entered Procedure: '||l_proc_name);
1077: END IF;
1078:
1079: fnd_file.put_line(fnd_File.LOG,'Landed Cost Adjustment Import Process started on '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
1080:

Line 1079: fnd_file.put_line(fnd_File.LOG,'Landed Cost Adjustment Import Process started on '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));

1075: IF l_debug_level >= l_debug_level_medium THEN
1076: fnd_file.put_line(fnd_file.log,'Entered Procedure: '||l_proc_name);
1077: END IF;
1078:
1079: fnd_file.put_line(fnd_File.LOG,'Landed Cost Adjustment Import Process started on '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
1080:
1081: -- B9917469, Removing OPM_LCM dependency
1082: OPEN cur_patch_level;
1083: FETCH cur_patch_level INTO l_patch_level;

Line 1089: fnd_file.put_line(fnd_File.LOG,'OPM-LCM Integration is NOT SUPPORTED for RELEASE 12.1.1 PATCH LEVEL' );

1085:
1086: IF l_patch_level = 1 THEN
1087: -- It means that this profile is set to 'Yes' and hence we will support LCM integration
1088: IF x_enable_opm_lcm_flag <> 'Y' THEN -- 11781472
1089: fnd_file.put_line(fnd_File.LOG,'OPM-LCM Integration is NOT SUPPORTED for RELEASE 12.1.1 PATCH LEVEL' );
1090: retcode := 1;
1091: RETURN ; /* exit from the process with warning */
1092: END IF;
1093:

Line 1098: fnd_file.put_line(fnd_file.log,'Verify Legal Entity');

1094: END IF;
1095: -- B9917469 Ends
1096:
1097: IF l_debug_level >= l_debug_level_high THEN
1098: fnd_file.put_line(fnd_file.log,'Verify Legal Entity');
1099: END IF;
1100:
1101: -- verify LE
1102: IF l_le_id IS NOT NULL THEN

Line 1107: fnd_file.put_line(fnd_File.LOG,'Insufficient Input parameters' );

1103: OPEN cur_get_le;
1104: FETCH cur_get_le INTO l_le_name;
1105: CLOSE cur_get_le;
1106: ELSE
1107: fnd_file.put_line(fnd_File.LOG,'Insufficient Input parameters' );
1108: retcode := 3;
1109: RETURN ; /* exit from the process */
1110: END IF;
1111: fnd_file.put_line(fnd_File.LOG,'Input parameters Legal entity / Id '|| l_le_name ||'/'||l_le_id);

Line 1111: fnd_file.put_line(fnd_File.LOG,'Input parameters Legal entity / Id '|| l_le_name ||'/'||l_le_id);

1107: fnd_file.put_line(fnd_File.LOG,'Insufficient Input parameters' );
1108: retcode := 3;
1109: RETURN ; /* exit from the process */
1110: END IF;
1111: fnd_file.put_line(fnd_File.LOG,'Input parameters Legal entity / Id '|| l_le_name ||'/'||l_le_id);
1112:
1113: IF l_debug_level >= l_debug_level_medium THEN
1114: fnd_file.put_line(fnd_file.log,'Get organization code');
1115: END IF;

Line 1114: fnd_file.put_line(fnd_file.log,'Get organization code');

1110: END IF;
1111: fnd_file.put_line(fnd_File.LOG,'Input parameters Legal entity / Id '|| l_le_name ||'/'||l_le_id);
1112:
1113: IF l_debug_level >= l_debug_level_medium THEN
1114: fnd_file.put_line(fnd_file.log,'Get organization code');
1115: END IF;
1116:
1117: -- Get from organization code
1118: IF l_from_organization_id IS NOT NULL THEN

Line 1131: fnd_file.put_line(fnd_File.LOG,'Input parameters From OrgId/Code '||l_from_organization_id ||'/'||l_from_org_code);

1127: CLOSE cur_get_org_cd;
1128: END IF;
1129:
1130: IF l_debug_level >= l_debug_level_low THEN
1131: fnd_file.put_line(fnd_File.LOG,'Input parameters From OrgId/Code '||l_from_organization_id ||'/'||l_from_org_code);
1132: fnd_file.put_line(fnd_File.LOG,'Input parameters To OrgId/Code '||l_to_organization_id ||'/'||l_to_org_code);
1133: END IF;
1134:
1135: IF l_debug_level >= l_debug_level_high THEN

Line 1132: fnd_file.put_line(fnd_File.LOG,'Input parameters To OrgId/Code '||l_to_organization_id ||'/'||l_to_org_code);

1128: END IF;
1129:
1130: IF l_debug_level >= l_debug_level_low THEN
1131: fnd_file.put_line(fnd_File.LOG,'Input parameters From OrgId/Code '||l_from_organization_id ||'/'||l_from_org_code);
1132: fnd_file.put_line(fnd_File.LOG,'Input parameters To OrgId/Code '||l_to_organization_id ||'/'||l_to_org_code);
1133: END IF;
1134:
1135: IF l_debug_level >= l_debug_level_high THEN
1136: fnd_file.put_line(fnd_file.log,'Get item number');

Line 1136: fnd_file.put_line(fnd_file.log,'Get item number');

1132: fnd_file.put_line(fnd_File.LOG,'Input parameters To OrgId/Code '||l_to_organization_id ||'/'||l_to_org_code);
1133: END IF;
1134:
1135: IF l_debug_level >= l_debug_level_high THEN
1136: fnd_file.put_line(fnd_file.log,'Get item number');
1137: END IF;
1138:
1139: -- Get from Item number
1140: IF l_from_item_id IS NOT NULL THEN

Line 1153: fnd_file.put_line(fnd_File.LOG,'Input parameters From ItemId/Item Number '||l_from_item_id ||'/'||l_from_item);

1149: CLOSE cur_get_item;
1150: END IF;
1151:
1152: IF l_debug_level >= l_debug_level_low THEN
1153: fnd_file.put_line(fnd_File.LOG,'Input parameters From ItemId/Item Number '||l_from_item_id ||'/'||l_from_item);
1154: fnd_file.put_line(fnd_File.LOG,'Input parameters To ItemId/Item Number '||l_to_item_id ||'/'||l_to_item);
1155: END IF;
1156:
1157: IF p_start_date IS NOT NULL THEN

Line 1154: fnd_file.put_line(fnd_File.LOG,'Input parameters To ItemId/Item Number '||l_to_item_id ||'/'||l_to_item);

1150: END IF;
1151:
1152: IF l_debug_level >= l_debug_level_low THEN
1153: fnd_file.put_line(fnd_File.LOG,'Input parameters From ItemId/Item Number '||l_from_item_id ||'/'||l_from_item);
1154: fnd_file.put_line(fnd_File.LOG,'Input parameters To ItemId/Item Number '||l_to_item_id ||'/'||l_to_item);
1155: END IF;
1156:
1157: IF p_start_date IS NOT NULL THEN
1158: l_start_date := fnd_date.canonical_to_date(p_start_date);

Line 1165: fnd_file.put_line(fnd_File.LOG,'Input parameters Start date '||l_start_date );

1161: IF p_end_date IS NOT NULL THEN
1162: l_end_date := fnd_date.canonical_to_date(p_end_date);
1163: END IF;
1164: IF l_debug_level >= l_debug_level_low THEN
1165: fnd_file.put_line(fnd_File.LOG,'Input parameters Start date '||l_start_date );
1166: fnd_file.put_line(fnd_File.LOG,'Input parameters End date '||l_end_date);
1167: END IF;
1168:
1169: IF l_debug_level >= l_debug_level_low THEN

Line 1166: fnd_file.put_line(fnd_File.LOG,'Input parameters End date '||l_end_date);

1162: l_end_date := fnd_date.canonical_to_date(p_end_date);
1163: END IF;
1164: IF l_debug_level >= l_debug_level_low THEN
1165: fnd_file.put_line(fnd_File.LOG,'Input parameters Start date '||l_start_date );
1166: fnd_file.put_line(fnd_File.LOG,'Input parameters End date '||l_end_date);
1167: END IF;
1168:
1169: IF l_debug_level >= l_debug_level_low THEN
1170: fnd_file.put_line(fnd_file.log,'Get ledger ID');

Line 1170: fnd_file.put_line(fnd_file.log,'Get ledger ID');

1166: fnd_file.put_line(fnd_File.LOG,'Input parameters End date '||l_end_date);
1167: END IF;
1168:
1169: IF l_debug_level >= l_debug_level_low THEN
1170: fnd_file.put_line(fnd_file.log,'Get ledger ID');
1171: END IF;
1172:
1173: -- Get the ledger_id for the legal entity parameter
1174: SELECT primary_ledger_id

Line 1180: fnd_file.put_line(fnd_file.log,'Open Cursor');

1176: FROM gmf_legal_entities
1177: WHERE legal_entity_id = p_le_id;
1178:
1179: IF l_debug_level >= l_debug_level_low THEN
1180: fnd_file.put_line(fnd_file.log,'Open Cursor');
1181: END IF;
1182:
1183: FOR adjustments_row IN lc_adjustments_cur (l_le_id,
1184: l_from_org_code,

Line 1192: fnd_file.put_line(fnd_file.log,'');

1188: l_start_date,
1189: l_end_date) LOOP
1190:
1191: IF l_debug_level >= l_debug_level_high THEN
1192: fnd_file.put_line(fnd_file.log,'');
1193: fnd_file.put_line(fnd_file.log,'Line to be processed:');
1194: fnd_file.put_line(fnd_file.log,'Rcv Ttransaction ID' ||adjustments_row.rcv_transaction_id ||
1195: ' Ship Num: '||adjustments_row.lc_ship_num ||
1196: ' Ship Line Num: '||adjustments_row.lc_ship_line_num ||

Line 1193: fnd_file.put_line(fnd_file.log,'Line to be processed:');

1189: l_end_date) LOOP
1190:
1191: IF l_debug_level >= l_debug_level_high THEN
1192: fnd_file.put_line(fnd_file.log,'');
1193: fnd_file.put_line(fnd_file.log,'Line to be processed:');
1194: fnd_file.put_line(fnd_file.log,'Rcv Ttransaction ID' ||adjustments_row.rcv_transaction_id ||
1195: ' Ship Num: '||adjustments_row.lc_ship_num ||
1196: ' Ship Line Num: '||adjustments_row.lc_ship_line_num ||
1197: ' Item ID: '||adjustments_row.inventory_item_id ||

Line 1194: fnd_file.put_line(fnd_file.log,'Rcv Ttransaction ID' ||adjustments_row.rcv_transaction_id ||

1190:
1191: IF l_debug_level >= l_debug_level_high THEN
1192: fnd_file.put_line(fnd_file.log,'');
1193: fnd_file.put_line(fnd_file.log,'Line to be processed:');
1194: fnd_file.put_line(fnd_file.log,'Rcv Ttransaction ID' ||adjustments_row.rcv_transaction_id ||
1195: ' Ship Num: '||adjustments_row.lc_ship_num ||
1196: ' Ship Line Num: '||adjustments_row.lc_ship_line_num ||
1197: ' Item ID: '||adjustments_row.inventory_item_id ||
1198: ' Organization ID: '||adjustments_row.organization_id ||

Line 1248: fnd_file.put_line(fnd_file.log,'Call Validate_Adjustments');

1244: l_adjustment_row.lc_var_account_id := adjustments_row.lc_var_account_id;
1245: l_adjustment_row.lc_absorption_account_id := adjustments_row.lc_absorption_account_id;
1246:
1247: IF l_debug_level >= l_debug_level_medium THEN
1248: fnd_file.put_line(fnd_file.log,'Call Validate_Adjustments');
1249: END IF;
1250:
1251: Validate_Adjustments(p_le_id => p_le_id,
1252: p_adjustment_row => l_adjustment_row,

Line 1264: fnd_file.put_line(fnd_file.log,'Validate Adjustments Return Status: ' || l_ret_status);

1260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1261: END IF;
1262:
1263: IF l_debug_level >= l_debug_level_medium THEN
1264: fnd_file.put_line(fnd_file.log,'Validate Adjustments Return Status: ' || l_ret_status);
1265: END IF;
1266:
1267: IF l_ret_status = 'S' THEN
1268: IF l_debug_level >= l_debug_level_medium THEN

Line 1269: fnd_file.put_line(fnd_file.log,'Call Create_AdjTrxLines');

1265: END IF;
1266:
1267: IF l_ret_status = 'S' THEN
1268: IF l_debug_level >= l_debug_level_medium THEN
1269: fnd_file.put_line(fnd_file.log,'Call Create_AdjTrxLines');
1270: END IF;
1271: -- Insert Into GMF_LC_ADJ_TRANSACTIONS
1272: Create_AdjTrxLines(p_le_id => p_le_id,
1273: p_ledger_id => l_ledger_id,

Line 1286: fnd_file.put_line(fnd_file.log,'The line was not processed');

1282: l_total_adj := l_total_adj + 1;
1283: ELSE
1284: l_total_ln_error := l_total_ln_error + 1;
1285: retcode := 1;
1286: fnd_file.put_line(fnd_file.log,'The line was not processed');
1287: fnd_file.put_line(fnd_file.log,'Rcv Ttransaction ID: ' ||l_adjustment_row.rcv_transaction_id ||
1288: ' Ship Num: '||l_adjustment_row.lc_ship_num ||
1289: ' Ship Line Num: '||l_adjustment_row.lc_ship_line_num ||
1290: ' Item ID: '||l_adjustment_row.inventory_item_id ||

Line 1287: fnd_file.put_line(fnd_file.log,'Rcv Ttransaction ID: ' ||l_adjustment_row.rcv_transaction_id ||

1283: ELSE
1284: l_total_ln_error := l_total_ln_error + 1;
1285: retcode := 1;
1286: fnd_file.put_line(fnd_file.log,'The line was not processed');
1287: fnd_file.put_line(fnd_file.log,'Rcv Ttransaction ID: ' ||l_adjustment_row.rcv_transaction_id ||
1288: ' Ship Num: '||l_adjustment_row.lc_ship_num ||
1289: ' Ship Line Num: '||l_adjustment_row.lc_ship_line_num ||
1290: ' Item ID: '||l_adjustment_row.inventory_item_id ||
1291: ' Organization ID: '||l_adjustment_row.organization_id ||

Line 1296: fnd_file.put_line(fnd_file.log, 'Landed Cost Adjustments Import Processor finished at '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));

1292: ' Adjustment Num: '||l_adjustment_row.adjustment_num);
1293: END IF;
1294: END LOOP;
1295:
1296: fnd_file.put_line(fnd_file.log, 'Landed Cost Adjustments Import Processor finished at '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
1297: fnd_file.put_line(fnd_file.log,' Total of LC Adjustment(s): ' || l_total_lines||
1298: ' LC Adjustment(s) created in gmf_lc_adj_transactions table : '|| l_total_adj ||
1299: ' LC Adjustment(s) with errors: '|| l_total_ln_error);
1300: COMMIT;

Line 1297: fnd_file.put_line(fnd_file.log,' Total of LC Adjustment(s): ' || l_total_lines||

1293: END IF;
1294: END LOOP;
1295:
1296: fnd_file.put_line(fnd_file.log, 'Landed Cost Adjustments Import Processor finished at '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
1297: fnd_file.put_line(fnd_file.log,' Total of LC Adjustment(s): ' || l_total_lines||
1298: ' LC Adjustment(s) created in gmf_lc_adj_transactions table : '|| l_total_adj ||
1299: ' LC Adjustment(s) with errors: '|| l_total_ln_error);
1300: COMMIT;
1301:

Line 1303: fnd_file.put_line(fnd_file.log,'Leaving Procedure: '||l_proc_name);

1299: ' LC Adjustment(s) with errors: '|| l_total_ln_error);
1300: COMMIT;
1301:
1302: IF l_debug_level >= l_debug_level_medium THEN
1303: fnd_file.put_line(fnd_file.log,'Leaving Procedure: '||l_proc_name);
1304: END IF;
1305:
1306: EXCEPTION
1307: ----