APPS.FTE_VALIDATION_PKG dependencies on FTE_VALIDATION_PKG

Line 1: PACKAGE BODY FTE_VALIDATION_PKG AS

1: PACKAGE BODY FTE_VALIDATION_PKG AS
2: /* $Header: FTEVALDB.pls 120.10.12000000.2 2007/01/20 11:06:41 htnguyen ship $ */
3: -- -------------------------------------------------------------------------- --
4: -- --
5: -- NAME: FTE_VALIDATION_PKG --

Line 5: -- NAME: FTE_VALIDATION_PKG --

1: PACKAGE BODY FTE_VALIDATION_PKG AS
2: /* $Header: FTEVALDB.pls 120.10.12000000.2 2007/01/20 11:06:41 htnguyen ship $ */
3: -- -------------------------------------------------------------------------- --
4: -- --
5: -- NAME: FTE_VALIDATION_PKG --
6: -- TYPE: PACKAGE BODY --
7: -- DESCRIPTION: Contains Rate Chart Validations for Bulk Loader purposes --
8: -- --
9: -- PROCEDURES AND FUNCTIONS: --

Line 46: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_VALIDATION_PKG';

42: -- VALIDATE_RATE_BREAK --
43: -- --
44: ----------------------------------------------------------------------------- --
45:
46: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_VALIDATION_PKG';
47: G_CURDATE DATE := sysdate;
48:
49:
50: -----------------------------------------------------------------------------

Line 2177: l_dest_country := p_origin_zone(FTE_VALIDATION_PKG.ZONE(3));

2173: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Line number', p_line_number);
2174: END IF;
2175:
2176: IF (l_dest_country IS NULL) THEN
2177: l_dest_country := p_origin_zone(FTE_VALIDATION_PKG.ZONE(3));
2178: END IF;
2179:
2180: IF (l_dest_state IS NULL) THEN
2181: l_dest_state := p_origin_zone(FTE_VALIDATION_PKG.ZONE(4));

Line 2181: l_dest_state := p_origin_zone(FTE_VALIDATION_PKG.ZONE(4));

2177: l_dest_country := p_origin_zone(FTE_VALIDATION_PKG.ZONE(3));
2178: END IF;
2179:
2180: IF (l_dest_state IS NULL) THEN
2181: l_dest_state := p_origin_zone(FTE_VALIDATION_PKG.ZONE(4));
2182: END IF;
2183:
2184: IF (l_dest_city IS NULL) THEN
2185: l_dest_city := p_origin_zone(FTE_VALIDATION_PKG.ZONE(5));

Line 2185: l_dest_city := p_origin_zone(FTE_VALIDATION_PKG.ZONE(5));

2181: l_dest_state := p_origin_zone(FTE_VALIDATION_PKG.ZONE(4));
2182: END IF;
2183:
2184: IF (l_dest_city IS NULL) THEN
2185: l_dest_city := p_origin_zone(FTE_VALIDATION_PKG.ZONE(5));
2186: END IF;
2187:
2188: IF (l_dest_postal IS NULL) THEN
2189: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_POSTAL_MISSING');

Line 7491: END FTE_VALIDATION_PKG;

7487: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
7488:
7489: END VALIDATE_ZONE;
7490:
7491: END FTE_VALIDATION_PKG;