APPS.FTE_LTL_LOADER dependencies on FTE_LTL_LOADER

Line 1: PACKAGE BODY FTE_LTL_LOADER AS

1: PACKAGE BODY FTE_LTL_LOADER AS
2: /* $Header: FTELTLRB.pls 120.7.12000000.3 2007/01/20 11:04:07 htnguyen ship $ */
3:
4: /*----------------------------------------------------------------------------------------
5: -- --

Line 6: -- NAME: FTE_LTL_LOADER --

2: /* $Header: FTELTLRB.pls 120.7.12000000.3 2007/01/20 11:04:07 htnguyen ship $ */
3:
4: /*----------------------------------------------------------------------------------------
5: -- --
6: -- NAME: FTE_LTL_LOADER --
7: -- TYPE: BODY --
8: -- DESCRIPTION: Gets a block of data from FTE_BULKLOAD_PKG --
9: -- and creates RATE-CHARTS, ZONES, LANES and more !! --
10: -- --

Line 23: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_LTL_LOADER';

19: -- --
20: -- 05/02/2005 R12 PRABHAKHAR Refactored. --
21: ------------------------------------------------------------------------------------------*/
22:
23: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_LTL_LOADER';
24:
25: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
26: G_ACTION VARCHAR2(10);
27: G_LTL_UOM VARCHAR2(5) := 'Lbs';

Line 143: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'UNEXPECTED ERROR FTE_LTL_LOADER.GET_PHASE', SQLERRM);

139: END IF;
140:
141: EXCEPTION
142: WHEN OTHERS THEN
143: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'UNEXPECTED ERROR FTE_LTL_LOADER.GET_PHASE', SQLERRM);
144: FTE_UTIL_PKG.Exit_Debug(l_module_name);
145: RAISE;
146: END GET_PHASE;
147:

Line 181: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'UNEXPECTED ERROR IN FTE_LTL_LOADER.ROW_NUM_MAX', sqlerrm);

177: RETURN l_max + 1;
178:
179: EXCEPTION
180: WHEN OTHERS THEN
181: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'UNEXPECTED ERROR IN FTE_LTL_LOADER.ROW_NUM_MAX', sqlerrm);
182: FTE_UTIL_PKG.Exit_Debug(l_module_name);
183: RAISE;
184: END ROW_NUM_MAX;
185:

Line 450: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'UNEXPECTED ERROR IN FTE_LTL_LOADER.BULK_INSERT_LANES', sqlerrm);

446: FTE_UTIL_PKG.Exit_Debug(l_module_name);
447:
448: EXCEPTION
449: WHEN OTHERS THEN
450: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'UNEXPECTED ERROR IN FTE_LTL_LOADER.BULK_INSERT_LANES', sqlerrm);
451: FTE_UTIL_PKG.Exit_Debug(l_module_name);
452: RAISE;
453: END BULK_INSERT_LANES;
454:

Line 501: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'UNEXPECTED ERROR IN FTE_LTL_LOADER.BULK_INSERT_LANE_RATE_CHARTS', sqlerrm);

497: FTE_UTIL_PKG.Exit_Debug(l_module_name);
498:
499: EXCEPTION
500: WHEN OTHERS THEN
501: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'UNEXPECTED ERROR IN FTE_LTL_LOADER.BULK_INSERT_LANE_RATE_CHARTS', sqlerrm);
502: FTE_UTIL_PKG.Exit_Debug(l_module_name);
503: RAISE;
504: END BULK_INSERT_LANE_RATE_CHARTS;
505:

Line 555: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'UNEXPECTED ERROR IN FTE_LTL_LOADER_PKG.BULK_INSERT_LANE_PARAMETERS', sqlerrm);

551: FTE_UTIL_PKG.Exit_Debug(l_module_name);
552:
553: EXCEPTION
554: WHEN OTHERS THEN
555: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'UNEXPECTED ERROR IN FTE_LTL_LOADER_PKG.BULK_INSERT_LANE_PARAMETERS', sqlerrm);
556: FTE_UTIL_PKG.Exit_Debug(l_module_name);
557: RAISE;
558: END BULK_INSERT_LANE_PARAMETERS;
559:

Line 600: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'UNEXPECTED ERROR IN FTE_LTL_LOADER.BULK_INSERT_LANE_PARAMETERS', sqlerrm);

596:
597: FTE_UTIL_PKG.Exit_Debug(l_module_name);
598: EXCEPTION
599: WHEN OTHERS THEN
600: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'UNEXPECTED ERROR IN FTE_LTL_LOADER.BULK_INSERT_LANE_PARAMETERS', sqlerrm);
601: FTE_UTIL_PKG.Exit_Debug(l_module_name);
602: RAISE;
603: END BULK_INSERT_LANE_COMMODITIES;
604:

Line 5572: END FTE_LTL_LOADER;

5568: FTE_UTIL_PKG.Exit_Debug(l_module_name);
5569:
5570: END QP_PROCESS;
5571:
5572: END FTE_LTL_LOADER;