DBA Data[Home] [Help]

APPS.FTE_LANE_PKG dependencies on FTE_UTIL_PKG

Line 221: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);

217:
218: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.CHECK_LANES';
219:
220: BEGIN
221: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
222:
223: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
224: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List Header ID', p_pricelist_id);
225: END IF;

Line 224: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List Header ID', p_pricelist_id);

220: BEGIN
221: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
222:
223: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
224: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List Header ID', p_pricelist_id);
225: END IF;
226:
227: x_status := -1;
228:

Line 235: x_error_msg := FTE_UTIL_PKG.GET_MSG('FTE_RC_ASSIGNED_TO_LN');

231: i := lane_number%ROWCOUNT;
232: CLOSE lane_number;
233:
234: IF ( i > 0 ) THEN
235: x_error_msg := FTE_UTIL_PKG.GET_MSG('FTE_RC_ASSIGNED_TO_LN');
236: FOR j IN 1..l_lanes.COUNT LOOP
237: x_error_msg := x_error_msg ||' '|| FTE_UTIL_PKG.GET_MSG('FTE_LANE_NUMBER') || ' '|| l_lanes(j);
238: END LOOP;
239: x_status := 2;

Line 237: x_error_msg := x_error_msg ||' '|| FTE_UTIL_PKG.GET_MSG('FTE_LANE_NUMBER') || ' '|| l_lanes(j);

233:
234: IF ( i > 0 ) THEN
235: x_error_msg := FTE_UTIL_PKG.GET_MSG('FTE_RC_ASSIGNED_TO_LN');
236: FOR j IN 1..l_lanes.COUNT LOOP
237: x_error_msg := x_error_msg ||' '|| FTE_UTIL_PKG.GET_MSG('FTE_LANE_NUMBER') || ' '|| l_lanes(j);
238: END LOOP;
239: x_status := 2;
240: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
241: p_msg => x_error_msg,

Line 240: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

236: FOR j IN 1..l_lanes.COUNT LOOP
237: x_error_msg := x_error_msg ||' '|| FTE_UTIL_PKG.GET_MSG('FTE_LANE_NUMBER') || ' '|| l_lanes(j);
238: END LOOP;
239: x_status := 2;
240: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
241: p_msg => x_error_msg,
242: p_category => 'F');
243:
244: END IF;

Line 246: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

242: p_category => 'F');
243:
244: END IF;
245:
246: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
247:
248: EXCEPTION WHEN OTHERS THEN
249: IF (lane_number%ISOPEN) THEN
250: CLOSE lane_number;

Line 253: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

249: IF (lane_number%ISOPEN) THEN
250: CLOSE lane_number;
251: END IF;
252: x_error_msg := sqlerrm;
253: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
254: p_msg => x_error_msg,
255: p_category => 'O');
256: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
257: x_status := 2;

Line 256: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

252: x_error_msg := sqlerrm;
253: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
254: p_msg => x_error_msg,
255: p_category => 'O');
256: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
257: x_status := 2;
258: END Check_Lanes;
259:
260: ---------------------------------------------------------------------------

Line 349: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);

345: l_start_date_active DATE;
346: l_end_date_active DATE;
347:
348: BEGIN
349: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
350:
351: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
352: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate Chart Name', p_name);
353: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Lane ID', p_lane_id);

Line 352: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate Chart Name', p_name);

348: BEGIN
349: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
350:
351: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
352: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate Chart Name', p_name);
353: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Lane ID', p_lane_id);
354: END IF;
355:
356: x_status := -1;

Line 353: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Lane ID', p_lane_id);

349: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
350:
351: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
352: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate Chart Name', p_name);
353: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Lane ID', p_lane_id);
354: END IF;
355:
356: x_status := -1;
357:

Line 372: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

368: INTO l_number_of_chart
369: FROM fte_lane_rate_charts
370: WHERE lane_id = p_lane_id;
371:
372: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
373:
374: IF (l_number_of_chart = 0) THEN
375: RETURN false;
376: ELSE

Line 404: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

400: OR (nvl(end_date_active, l_start_date_active) >= l_start_date_active AND nvl(start_date_active, l_end_date_active) <= l_end_date_active));
401: END IF;
402: EXCEPTION
403: WHEN NO_DATA_FOUND THEN
404: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
405: RETURN false;
406: WHEN OTHERS THEN
407: x_error_msg := sqlerrm;
408: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 408: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

404: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
405: RETURN false;
406: WHEN OTHERS THEN
407: x_error_msg := sqlerrm;
408: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
409: p_msg => x_error_msg,
410: p_category => '0');
411: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
412: x_status := 1;

Line 411: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

407: x_error_msg := sqlerrm;
408: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
409: p_msg => x_error_msg,
410: p_category => '0');
411: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
412: x_status := 1;
413: RETURN FALSE;
414: END;
415:

Line 417: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Query result', l_number_of_chart);

413: RETURN FALSE;
414: END;
415:
416: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
417: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Query result', l_number_of_chart);
418: END IF;
419:
420: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
421:

Line 420: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

416: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
417: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Query result', l_number_of_chart);
418: END IF;
419:
420: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
421:
422: IF (l_number_of_chart = 0) THEN
423: RETURN false;
424: ELSE

Line 429: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

425: RETURN true;
426: END IF;
427: EXCEPTION
428: WHEN NO_DATA_FOUND THEN
429: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
430: RETURN FALSE;
431: WHEN OTHERS THEN
432: x_error_msg := sqlerrm;
433: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 433: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

429: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
430: RETURN FALSE;
431: WHEN OTHERS THEN
432: x_error_msg := sqlerrm;
433: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
434: p_msg => x_error_msg,
435: p_category => '0');
436: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
437: x_status := 1;

Line 436: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

432: x_error_msg := sqlerrm;
433: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
434: p_msg => x_error_msg,
435: p_category => '0');
436: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
437: x_status := 1;
438: RETURN FALSE;
439: END VERIFY_OVERLAPPING_DATE;
440:

Line 480: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);

476: WHERE commodity_catg_id = TO_NUMBER(p_value)
477: AND lane_id = p_lane_id;
478:
479: BEGIN
480: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
481:
482: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
483: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Type', p_type);
484: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Value', p_value);

Line 483: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Type', p_type);

479: BEGIN
480: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
481:
482: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
483: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Type', p_type);
484: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Value', p_value);
485: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Lane ID', p_lane_id);
486: END IF;
487:

Line 484: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Value', p_value);

480: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
481:
482: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
483: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Type', p_type);
484: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Value', p_value);
485: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Lane ID', p_lane_id);
486: END IF;
487:
488: x_status := -1;

Line 485: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Lane ID', p_lane_id);

481:
482: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
483: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Type', p_type);
484: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Value', p_value);
485: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Lane ID', p_lane_id);
486: END IF;
487:
488: x_status := -1;
489:

Line 502: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

498: l_numfetch := SQL%ROWCOUNT;
499: CLOSE GET_COMMODITY;
500: END IF;
501:
502: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
503:
504: IF (l_numfetch = 0) THEN
505: RETURN false;
506: ELSE

Line 519: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

515: CLOSE GET_COMMODITY;
516: END IF;
517:
518: x_error_msg := sqlerrm;
519: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
520: p_msg => x_error_msg,
521: p_category => '0',
522: p_line_number => p_line_number);
523: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

Line 523: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

519: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
520: p_msg => x_error_msg,
521: p_category => '0',
522: p_line_number => p_line_number);
523: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
524: x_status := 1;
525: RETURN FALSE;
526: END FIND_TYPE;
527:

Line 552: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);

548: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.CHECK_EXISTING_LOAD';
549: l_result NUMBER;
550: BEGIN
551:
552: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
553:
554: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
555: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'ID', p_id);
556: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Table', p_table);

Line 555: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'ID', p_id);

551:
552: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
553:
554: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
555: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'ID', p_id);
556: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Table', p_table);
557: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Code', p_code);
558: END IF;
559:

Line 556: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Table', p_table);

552: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
553:
554: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
555: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'ID', p_id);
556: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Table', p_table);
557: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Code', p_code);
558: END IF;
559:
560: x_status := -1;

Line 557: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Code', p_code);

553:
554: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
555: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'ID', p_id);
556: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Table', p_table);
557: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Code', p_code);
558: END IF;
559:
560: x_status := -1;
561:

Line 582: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

578: WHERE lane_id = p_id
579: AND service_code = p_code;
580: END IF;
581:
582: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
583: IF (l_result > 0) THEN
584: RETURN TRUE;
585: ELSE
586: RETURN FALSE;

Line 591: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

587: END IF;
588:
589: EXCEPTION
590: WHEN NO_DATA_FOUND THEN
591: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
592: RETURN FALSE;
593: WHEN OTHERS THEN
594: x_error_msg := sqlerrm;
595: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 595: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

591: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
592: RETURN FALSE;
593: WHEN OTHERS THEN
594: x_error_msg := sqlerrm;
595: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
596: p_msg => x_error_msg,
597: p_category => '0',
598: p_line_number => p_line_number);
599: x_status := 2;

Line 600: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

596: p_msg => x_error_msg,
597: p_category => '0',
598: p_line_number => p_line_number);
599: x_status := 2;
600: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
601: RETURN TRUE;
602: END CHECK_EXISTING_LOAD;
603:
604: ------------------------------------------------------------------------

Line 627: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);

623: x_error_msg OUT NOCOPY VARCHAR2) IS
624: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.DELETE_ROW';
625: BEGIN
626:
627: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
628:
629: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
630: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'ID', p_id);
631: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Table', p_table);

Line 630: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'ID', p_id);

626:
627: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
628:
629: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
630: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'ID', p_id);
631: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Table', p_table);
632: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Code', p_code);
633: END IF;
634:

Line 631: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Table', p_table);

627: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
628:
629: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
630: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'ID', p_id);
631: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Table', p_table);
632: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Code', p_code);
633: END IF;
634:
635: x_status := -1;

Line 632: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Code', p_code);

628:
629: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
630: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'ID', p_id);
631: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Table', p_table);
632: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Code', p_code);
633: END IF;
634:
635: x_status := -1;
636:

Line 676: x_error_msg := FTE_UTIL_PKG.GET_MSG('FTE_INVALID_TABLE');

672: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
673: WHERE SCHEDULES_ID = p_id
674: AND NVL(EDITABLE_FLAG,'Y') = 'Y';
675: ELSE
676: x_error_msg := FTE_UTIL_PKG.GET_MSG('FTE_INVALID_TABLE');
677: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
678: p_msg => x_error_msg,
679: p_category => 'O',
680: p_line_number => p_line_number);

Line 677: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

673: WHERE SCHEDULES_ID = p_id
674: AND NVL(EDITABLE_FLAG,'Y') = 'Y';
675: ELSE
676: x_error_msg := FTE_UTIL_PKG.GET_MSG('FTE_INVALID_TABLE');
677: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
678: p_msg => x_error_msg,
679: p_category => 'O',
680: p_line_number => p_line_number);
681:

Line 683: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

679: p_category => 'O',
680: p_line_number => p_line_number);
681:
682: x_status := 1;
683: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
684: RETURN;
685: END IF;
686:
687: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

Line 687: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

683: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
684: RETURN;
685: END IF;
686:
687: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
688: RETURN;
689: EXCEPTION
690: WHEN OTHERS THEN
691: x_error_msg := sqlerrm;

Line 692: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

688: RETURN;
689: EXCEPTION
690: WHEN OTHERS THEN
691: x_error_msg := sqlerrm;
692: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
693: p_msg => x_error_msg,
694: p_category => '0',
695: p_line_number => p_line_number);
696: x_status := 2;

Line 697: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

693: p_msg => x_error_msg,
694: p_category => '0',
695: p_line_number => p_line_number);
696: x_status := 2;
697: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
698: RETURN;
699: END DELETE_ROW;
700:
701: -------------------------------------------------------------------------

Line 740: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);

736: WHERE lane_id = p_lane_id;
737:
738: BEGIN
739:
740: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
741:
742: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
743: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Type', p_type);
744: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Lane ID', p_lane_id);

Line 743: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Type', p_type);

739:
740: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
741:
742: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
743: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Type', p_type);
744: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Lane ID', p_lane_id);
745: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Value', p_value);
746: END IF;
747:

Line 744: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Lane ID', p_lane_id);

740: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
741:
742: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
743: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Type', p_type);
744: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Lane ID', p_lane_id);
745: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Value', p_value);
746: END IF;
747:
748: x_status := -1;

Line 745: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Value', p_value);

741:
742: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
743: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Type', p_type);
744: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Lane ID', p_lane_id);
745: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Value', p_value);
746: END IF;
747:
748: x_status := -1;
749:

Line 761: x_error_msg := FTE_UTIL_PKG.GET_MSG('FTE_INVALID_TYPE');

757: FETCH Get_Commodity_Type
758: BULK COLLECT INTO l_return;
759: CLOSE Get_Commodity_Type;
760: ELSIF (p_type <> 'SCHEDULE') THEN
761: x_error_msg := FTE_UTIL_PKG.GET_MSG('FTE_INVALID_TYPE');
762: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
763: p_msg => x_error_msg,
764: p_category => 'O');
765:

Line 762: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

758: BULK COLLECT INTO l_return;
759: CLOSE Get_Commodity_Type;
760: ELSIF (p_type <> 'SCHEDULE') THEN
761: x_error_msg := FTE_UTIL_PKG.GET_MSG('FTE_INVALID_TYPE');
762: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
763: p_msg => x_error_msg,
764: p_category => 'O');
765:
766: x_status := 1;

Line 767: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

763: p_msg => x_error_msg,
764: p_category => 'O');
765:
766: x_status := 1;
767: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
768: RETURN;
769: END IF;
770:
771: IF (l_return.COUNT = 1) THEN

Line 803: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

799: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
800: WHERE lane_id = p_lane_id;
801: END IF;
802:
803: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
804: EXCEPTION
805: WHEN OTHERS THEN
806: IF (GET_SERVICE_CODE%ISOPEN) THEN
807: CLOSE GET_SERVICE_CODE;

Line 813: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

809: IF (GET_COMMODITY_TYPE%ISOPEN) THEN
810: CLOSE GET_COMMODITY_TYPE;
811: END IF;
812: x_error_msg := sqlerrm;
813: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
814: p_msg => x_error_msg,
815: p_category => 'O');
816: x_status := 1;
817: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

Line 817: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

813: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
814: p_msg => x_error_msg,
815: p_category => 'O');
816: x_status := 1;
817: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
818: RETURN;
819: END UPDATE_LANE_FLAGS;
820:
821: -------------------------------------------------------------------------

Line 862: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);

858: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.INSERT_SCHEDULES';
859:
860: BEGIN
861:
862: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
863:
864: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
865: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Schedules', p_schedule_tbl.COUNT);
866: END IF;

Line 865: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Schedules', p_schedule_tbl.COUNT);

861:
862: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
863:
864: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
865: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Schedules', p_schedule_tbl.COUNT);
866: END IF;
867:
868: x_status := -1;
869:

Line 953: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

949: --+
950:
951: FOR i in l_voyage_number.FIRST..l_voyage_number.LAST LOOP
952:
953: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
954: p_msg => l_voyage_number(i),
955: p_category => NULL);
956: END LOOP;
957:

Line 960: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

956: END LOOP;
957:
958: END;
959: END IF;
960: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
961:
962: EXCEPTION
963: WHEN OTHERS THEN
964: x_error_msg := sqlerrm;

Line 965: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

961:
962: EXCEPTION
963: WHEN OTHERS THEN
964: x_error_msg := sqlerrm;
965: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
966: p_msg => x_error_msg,
967: p_category => 'O');
968: x_status := 1;
969: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

Line 969: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

965: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
966: p_msg => x_error_msg,
967: p_category => 'O');
968: x_status := 1;
969: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
970: RETURN;
971: END INSERT_SCHEDULES;
972:
973:

Line 1041: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);

1037: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.INSERT_LANE_TABLES';
1038:
1039: BEGIN
1040:
1041: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1042:
1043: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1044: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Lanes', p_lane_tbl.COUNT);
1045: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Lane rate charts', p_lane_rate_chart_tbl.COUNT);

Line 1044: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Lanes', p_lane_tbl.COUNT);

1040:
1041: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1042:
1043: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1044: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Lanes', p_lane_tbl.COUNT);
1045: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Lane rate charts', p_lane_rate_chart_tbl.COUNT);
1046: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Lane commodities', p_lane_commodity_tbl.COUNT);
1047: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Lane services', p_lane_service_tbl.COUNT);
1048: END IF;

Line 1045: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Lane rate charts', p_lane_rate_chart_tbl.COUNT);

1041: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1042:
1043: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1044: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Lanes', p_lane_tbl.COUNT);
1045: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Lane rate charts', p_lane_rate_chart_tbl.COUNT);
1046: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Lane commodities', p_lane_commodity_tbl.COUNT);
1047: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Lane services', p_lane_service_tbl.COUNT);
1048: END IF;
1049:

Line 1046: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Lane commodities', p_lane_commodity_tbl.COUNT);

1042:
1043: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1044: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Lanes', p_lane_tbl.COUNT);
1045: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Lane rate charts', p_lane_rate_chart_tbl.COUNT);
1046: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Lane commodities', p_lane_commodity_tbl.COUNT);
1047: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Lane services', p_lane_service_tbl.COUNT);
1048: END IF;
1049:
1050: x_status := -1;

Line 1047: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Lane services', p_lane_service_tbl.COUNT);

1043: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1044: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Lanes', p_lane_tbl.COUNT);
1045: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Lane rate charts', p_lane_rate_chart_tbl.COUNT);
1046: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Lane commodities', p_lane_commodity_tbl.COUNT);
1047: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Lane services', p_lane_service_tbl.COUNT);
1048: END IF;
1049:
1050: x_status := -1;
1051:

Line 1172: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting lanes]');

1168: l_tariff_name(i));
1169: EXCEPTION
1170: WHEN OTHERS THEN
1171: x_error_msg := sqlerrm;
1172: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting lanes]');
1173: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1174: p_msg => x_error_msg,
1175: p_category => 'O');
1176: x_status := 1;

Line 1173: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

1169: EXCEPTION
1170: WHEN OTHERS THEN
1171: x_error_msg := sqlerrm;
1172: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting lanes]');
1173: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1174: p_msg => x_error_msg,
1175: p_category => 'O');
1176: x_status := 1;
1177: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

Line 1177: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

1173: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1174: p_msg => x_error_msg,
1175: p_category => 'O');
1176: x_status := 1;
1177: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1178: p_lane_tbl.DELETE;
1179: p_lane_rate_chart_tbl.DELETE;
1180: p_lane_commodity_tbl.DELETE;
1181: p_lane_service_tbl.DELETE;

Line 1188: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

1184:
1185: --+
1186: -- For Generating Output file
1187: --+
1188: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1189: p_msg_name => 'FTE_LANES_LOADED',
1190: p_category => NULL);
1191:
1192: FOR i in l_lane_number.FIRST..l_lane_number.LAST LOOP

Line 1194: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

1190: p_category => NULL);
1191:
1192: FOR i in l_lane_number.FIRST..l_lane_number.LAST LOOP
1193:
1194: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1195: p_msg => l_lane_number(i),
1196: p_category => NULL);
1197:
1198: END LOOP;

Line 1236: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Updating lane_type of fte_lanes... ');

1232: -- Remove the hold from fte_lanes
1233: -- for these rate charts.
1234: --+
1235: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1236: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Updating lane_type of fte_lanes... ');
1237: END IF;
1238: FORALL i in l_lrc_lane_id.FIRST..l_lrc_lane_id.LAST
1239: UPDATE fte_lanes
1240: SET lane_type = NULL,

Line 1251: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting lane rate charts]');

1247: WHEN DUP_VAL_ON_INDEX THEN
1248: x_status := -1;
1249: WHEN OTHERS THEN
1250: x_error_msg := sqlerrm;
1251: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting lane rate charts]');
1252: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1253: p_msg => x_error_msg,
1254: p_category => 'O');
1255: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

Line 1252: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

1248: x_status := -1;
1249: WHEN OTHERS THEN
1250: x_error_msg := sqlerrm;
1251: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting lane rate charts]');
1252: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1253: p_msg => x_error_msg,
1254: p_category => 'O');
1255: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1256: p_lane_tbl.DELETE;

Line 1255: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

1251: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting lane rate charts]');
1252: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1253: p_msg => x_error_msg,
1254: p_category => 'O');
1255: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1256: p_lane_tbl.DELETE;
1257: p_lane_rate_chart_tbl.DELETE;
1258: p_lane_commodity_tbl.DELETE;
1259: p_lane_service_tbl.DELETE;

Line 1298: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting lane commodities]');

1294: WHEN DUP_VAL_ON_INDEX THEN
1295: x_status := -1;
1296: WHEN OTHERS THEN
1297: x_error_msg := sqlerrm;
1298: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting lane commodities]');
1299: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1300: p_msg => x_error_msg,
1301: p_category => 'O');
1302: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

Line 1299: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

1295: x_status := -1;
1296: WHEN OTHERS THEN
1297: x_error_msg := sqlerrm;
1298: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting lane commodities]');
1299: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1300: p_msg => x_error_msg,
1301: p_category => 'O');
1302: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1303: p_lane_tbl.DELETE;

Line 1302: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

1298: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting lane commodities]');
1299: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1300: p_msg => x_error_msg,
1301: p_category => 'O');
1302: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1303: p_lane_tbl.DELETE;
1304: p_lane_rate_chart_tbl.DELETE;
1305: p_lane_commodity_tbl.DELETE;
1306: p_lane_service_tbl.DELETE;

Line 1342: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting lane services]');

1338: WHEN DUP_VAL_ON_INDEX THEN
1339: x_status := -1;
1340: WHEN OTHERS THEN
1341: x_error_msg := sqlerrm;
1342: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting lane services]');
1343: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1344: p_msg => x_error_msg,
1345: p_category => 'O');
1346: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

Line 1343: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

1339: x_status := -1;
1340: WHEN OTHERS THEN
1341: x_error_msg := sqlerrm;
1342: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting lane services]');
1343: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1344: p_msg => x_error_msg,
1345: p_category => 'O');
1346: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1347: p_lane_tbl.DELETE;

Line 1346: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

1342: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting lane services]');
1343: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1344: p_msg => x_error_msg,
1345: p_category => 'O');
1346: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1347: p_lane_tbl.DELETE;
1348: p_lane_rate_chart_tbl.DELETE;
1349: p_lane_commodity_tbl.DELETE;
1350: p_lane_service_tbl.DELETE;

Line 1376: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

1372: p_lane_rate_chart_tbl.DELETE;
1373: p_lane_commodity_tbl.DELETE;
1374: p_lane_service_tbl.DELETE;
1375:
1376: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1377: EXCEPTION
1378: WHEN OTHERS THEN
1379: x_error_msg := sqlerrm;
1380: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 1380: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

1376: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1377: EXCEPTION
1378: WHEN OTHERS THEN
1379: x_error_msg := sqlerrm;
1380: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1381: p_msg => x_error_msg,
1382: p_category => 'O');
1383: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1384: x_status := 1;

Line 1383: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

1379: x_error_msg := sqlerrm;
1380: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1381: p_msg => x_error_msg,
1382: p_category => 'O');
1383: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1384: x_status := 1;
1385: p_lane_tbl.DELETE;
1386: p_lane_rate_chart_tbl.DELETE;
1387: p_lane_commodity_tbl.DELETE;

Line 1422: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);

1418: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.INSERT_PRC_PARAMETERS';
1419:
1420: BEGIN
1421:
1422: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1423:
1424: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1425: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of pricing parameters', p_prc_parameter_tbl.COUNT);
1426: END IF;

Line 1425: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of pricing parameters', p_prc_parameter_tbl.COUNT);

1421:
1422: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1423:
1424: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1425: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of pricing parameters', p_prc_parameter_tbl.COUNT);
1426: END IF;
1427:
1428: x_status := -1;
1429:

Line 1470: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

1466: FND_GLOBAL.USER_ID);
1467:
1468: END;
1469: END IF;
1470: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1471: EXCEPTION
1472: WHEN OTHERS THEN
1473: x_error_msg := sqlerrm;
1474: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 1474: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

1470: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1471: EXCEPTION
1472: WHEN OTHERS THEN
1473: x_error_msg := sqlerrm;
1474: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1475: p_msg => x_error_msg,
1476: p_category => 'O');
1477: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1478: x_status := 1;

Line 1477: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

1473: x_error_msg := sqlerrm;
1474: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1475: p_msg => x_error_msg,
1476: p_category => 'O');
1477: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1478: x_status := 1;
1479: RETURN;
1480: END INSERT_PRC_PARAMETERS;
1481:

Line 1504: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);

1500: x_status OUT NOCOPY NUMBER,
1501: x_error_msg OUT NOCOPY VARCHAR2)IS
1502: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.UPDATE_LANE_RATE_CHART';
1503: BEGIN
1504: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1505:
1506: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1507: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List Header ID', p_list_header_id);
1508: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Start Date', p_start_date);

Line 1507: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List Header ID', p_list_header_id);

1503: BEGIN
1504: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1505:
1506: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1507: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List Header ID', p_list_header_id);
1508: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Start Date', p_start_date);
1509: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'End Date', p_end_date);
1510: END IF;
1511:

Line 1508: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Start Date', p_start_date);

1504: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1505:
1506: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1507: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List Header ID', p_list_header_id);
1508: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Start Date', p_start_date);
1509: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'End Date', p_end_date);
1510: END IF;
1511:
1512: x_status := -1;

Line 1509: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'End Date', p_end_date);

1505:
1506: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1507: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List Header ID', p_list_header_id);
1508: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Start Date', p_start_date);
1509: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'End Date', p_end_date);
1510: END IF;
1511:
1512: x_status := -1;
1513:

Line 1522: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

1518: LAST_UPDATE_DATE = sysdate,
1519: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
1520: WHERE LIST_HEADER_ID = p_list_header_id;
1521:
1522: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1523: EXCEPTION
1524: WHEN OTHERS THEN
1525: x_error_msg := sqlerrm;
1526: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 1526: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

1522: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1523: EXCEPTION
1524: WHEN OTHERS THEN
1525: x_error_msg := sqlerrm;
1526: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1527: p_msg => x_error_msg,
1528: p_category => 'O');
1529: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1530: x_status := 1;

Line 1529: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

1525: x_error_msg := sqlerrm;
1526: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1527: p_msg => x_error_msg,
1528: p_category => 'O');
1529: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1530: x_status := 1;
1531: RETURN;
1532: END UPDATE_LANE_RATE_CHART;
1533:

Line 1560: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);

1556: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.UPDATE_PRC_PARAMETERS';
1557:
1558: BEGIN
1559:
1560: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1561:
1562: l_value_from := p_prc_parameter_tbl(p_prc_parameter_tbl.COUNT).value_from;
1563: l_value_to := p_prc_parameter_tbl(p_prc_parameter_tbl.COUNT).value_to;
1564: l_uom_code := p_prc_parameter_tbl(p_prc_parameter_tbl.COUNT).uom_code;

Line 1569: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Value from', l_value_from);

1565: l_currency_code := p_prc_parameter_tbl(p_prc_parameter_tbl.COUNT).currency_code;
1566: l_parameter_instance_id := p_prc_parameter_tbl(p_prc_parameter_tbl.COUNT).parameter_instance_id;
1567:
1568: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1569: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Value from', l_value_from);
1570: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Value to', l_value_to);
1571: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Uom code', l_uom_code);
1572: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Currecy code', l_currency_code);
1573: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Parameter code', l_parameter_instance_id);

Line 1570: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Value to', l_value_to);

1566: l_parameter_instance_id := p_prc_parameter_tbl(p_prc_parameter_tbl.COUNT).parameter_instance_id;
1567:
1568: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1569: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Value from', l_value_from);
1570: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Value to', l_value_to);
1571: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Uom code', l_uom_code);
1572: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Currecy code', l_currency_code);
1573: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Parameter code', l_parameter_instance_id);
1574: END IF;

Line 1571: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Uom code', l_uom_code);

1567:
1568: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1569: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Value from', l_value_from);
1570: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Value to', l_value_to);
1571: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Uom code', l_uom_code);
1572: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Currecy code', l_currency_code);
1573: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Parameter code', l_parameter_instance_id);
1574: END IF;
1575:

Line 1572: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Currecy code', l_currency_code);

1568: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1569: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Value from', l_value_from);
1570: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Value to', l_value_to);
1571: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Uom code', l_uom_code);
1572: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Currecy code', l_currency_code);
1573: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Parameter code', l_parameter_instance_id);
1574: END IF;
1575:
1576: x_status := -1;

Line 1573: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Parameter code', l_parameter_instance_id);

1569: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Value from', l_value_from);
1570: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Value to', l_value_to);
1571: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Uom code', l_uom_code);
1572: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Currecy code', l_currency_code);
1573: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Parameter code', l_parameter_instance_id);
1574: END IF;
1575:
1576: x_status := -1;
1577:

Line 1588: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

1584: LAST_UPDATE_DATE = sysdate,
1585: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
1586: WHERE parameter_instance_id = l_parameter_instance_id;
1587:
1588: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1589:
1590: EXCEPTION
1591: WHEN OTHERS THEN
1592: x_error_msg := sqlerrm;

Line 1593: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

1589:
1590: EXCEPTION
1591: WHEN OTHERS THEN
1592: x_error_msg := sqlerrm;
1593: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1594: p_msg => x_error_msg,
1595: p_category => 'O');
1596: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1597: x_status := 1;

Line 1596: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

1592: x_error_msg := sqlerrm;
1593: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1594: p_msg => x_error_msg,
1595: p_category => 'O');
1596: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1597: x_status := 1;
1598: RETURN;
1599: END UPDATE_PRC_PARAMETER;
1600: