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.FTE_DIST_DWNLD_PKG dependencies on FTE_DIST_DWNLD_PKG

Line 1: PACKAGE BODY FTE_DIST_DWNLD_PKG AS

1: PACKAGE BODY FTE_DIST_DWNLD_PKG AS
2: /* $Header: FTEDISDB.pls 115.11 2004/03/18 20:20:07 ablundel noship $ */
3: -- -------------------------------------------------------------------------- --
4: -- --
5: -- NAME: FTE_DIST_DWNLD_PKG --

Line 5: -- NAME: FTE_DIST_DWNLD_PKG --

1: PACKAGE BODY FTE_DIST_DWNLD_PKG AS
2: /* $Header: FTEDISDB.pls 115.11 2004/03/18 20:20:07 ablundel noship $ */
3: -- -------------------------------------------------------------------------- --
4: -- --
5: -- NAME: FTE_DIST_DWNLD_PKG --
6: -- TYPE: PACKAGE BODY --
7: -- DESCRIPTION: Contains core procedures for creating an OD download file --
8: -- --
9: -- --

Line 258: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME');

254: --
255: l_file_extension := p_file_extension;
256:
257: IF l_debug_on THEN
258: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME');
259: END IF;
260:
261: FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME(p_user_debug_flag => l_user_debug,
262: x_file_extension => l_file_extension,

Line 261: FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME(p_user_debug_flag => l_user_debug,

257: IF l_debug_on THEN
258: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME');
259: END IF;
260:
261: FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME(p_user_debug_flag => l_user_debug,
262: x_file_extension => l_file_extension,
263: x_file_name => l_filename,
264: x_return_message => l_return_message,
265: x_return_status => l_return_status);

Line 270: WSH_DEBUG_SV.logmsg(l_module_name,'Error from FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME , l_return_status = '||l_return_status);

266:
267:
268: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
269: IF l_debug_on THEN
270: WSH_DEBUG_SV.logmsg(l_module_name,'Error from FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME , l_return_status = '||l_return_status);
271: WSH_DEBUG_SV.logmsg(l_module_name,'RAISE FTE_DIST_ERR_CREATE_FILENAME');
272: END IF;
273:
274: RAISE FTE_DIST_ERR_CREATE_FILENAME;

Line 362: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_ERR_CREATE_FILENAME FTE_DIST_DWNLD_PKG.BULK_DOWNLOAD_DTT: '||x_error_msg_text);

358: --
359: -- Debug Statements
360: --
361: IF l_debug_on THEN
362: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_ERR_CREATE_FILENAME FTE_DIST_DWNLD_PKG.BULK_DOWNLOAD_DTT: '||x_error_msg_text);
363: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_ERR_CREATE_FILENAME');
364: WSH_DEBUG_SV.pop(l_module_name);
365: END IF;
366: --

Line 378: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_NO_FILENAME FTE_DIST_DWNLD_PKG.BULK_DOWNLOAD_DTT: '||x_error_msg_text);

374: --
375: -- Debug Statements
376: --
377: IF l_debug_on THEN
378: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_NO_FILENAME FTE_DIST_DWNLD_PKG.BULK_DOWNLOAD_DTT: '||x_error_msg_text);
379: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_NO_FILENAME');
380: WSH_DEBUG_SV.pop(l_module_name);
381: END IF;
382: --

Line 393: WSH_DEBUG_SV.logmsg(l_module_name,'THE UNEXPECTED ERROR FROM FTE_DIST_DWNLD_PKG.BULK_DOWNLOAD_DTT IS: '||x_error_msg_text);

389: --
390: -- Debug Statements
391: --
392: IF l_debug_on THEN
393: WSH_DEBUG_SV.logmsg(l_module_name,'THE UNEXPECTED ERROR FROM FTE_DIST_DWNLD_PKG.BULK_DOWNLOAD_DTT IS: '||x_error_msg_text);
394: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||x_error_msg_text,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
395: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
396: END IF;
397: --

Line 536: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA');

532:
533: END IF;
534:
535: IF l_debug_on THEN
536: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA');
537: END IF;
538:
539: FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA(p_template_id => p_template_id,
540: p_origin_facility_id => p_origin_facility_id,

Line 539: FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA(p_template_id => p_template_id,

535: IF l_debug_on THEN
536: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA');
537: END IF;
538:
539: FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA(p_template_id => p_template_id,
540: p_origin_facility_id => p_origin_facility_id,
541: p_origin_region_id => p_origin_region_id,
542: p_origin_all_fac_flag => p_origin_all_fac_flag,
543: p_all_fac_no_data_flag => p_all_fac_no_data_flag,

Line 588: WSH_DEBUG_SV.logmsg(l_module_name,'THE UNEXPECTED ERROR FROM FTE_DIST_DWNLD_PKG.DOWNLOAD_DTT_FILE IS: '||p_errbuf);

584: --
585: -- Debug Statements
586: --
587: IF l_debug_on THEN
588: WSH_DEBUG_SV.logmsg(l_module_name,'THE UNEXPECTED ERROR FROM FTE_DIST_DWNLD_PKG.DOWNLOAD_DTT_FILE IS: '||p_errbuf);
589: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||p_errbuf,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
590: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
591: END IF;
592: --

Line 937: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME',WSH_DEBUG_SV.C_PROC_LEVEL);

933: END IF;
934:
935:
936: IF l_debug_on THEN
937: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME',WSH_DEBUG_SV.C_PROC_LEVEL);
938: WSH_DEBUG_SV.log(l_module_name,'p_user_debug_flag =',l_user_debug_flag);
939: WSH_DEBUG_SV.log(l_module_name,'l_file_extension= ',l_file_extension);
940: WSH_DEBUG_SV.log(l_module_name,'l_filename = ',l_filename);
941: WSH_DEBUG_SV.log(l_module_name,'l_return_message = ',l_return_message);

Line 946: FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME(p_user_debug_flag => l_user_debug_flag,

942: WSH_DEBUG_SV.log(l_module_name,'l_return_status = ',l_return_status);
943: END IF;
944: --
945:
946: FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME(p_user_debug_flag => l_user_debug_flag,
947: x_file_extension => l_file_extension,
948: x_file_name => l_filename,
949: x_return_message => l_return_message,
950: x_return_status => l_return_status);

Line 956: WSH_DEBUG_SV.log(l_module_name,'FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME failed, return status = ',l_return_status);

952:
953:
954: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
955: IF l_debug_on THEN
956: WSH_DEBUG_SV.log(l_module_name,'FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME failed, return status = ',l_return_status);
957: WSH_DEBUG_SV.log(l_module_name,'l_return_message = ',l_return_message);
958: WSH_DEBUG_SV.logmsg(l_module_name,'RAISE FTE_DIST_ERR_CREATE_FILENAME');
959: END IF;
960:

Line 1190: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILE',WSH_DEBUG_SV.C_PROC_LEVEL);

1186:
1187:
1188:
1189: IF l_debug_on THEN
1190: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILE',WSH_DEBUG_SV.C_PROC_LEVEL);
1191: WSH_DEBUG_SV.logmsg(l_module_name,'------------ INPUT PARAMETERS ------------');
1192: WSH_DEBUG_SV.log(l_module_name,'l_origin_route = ',l_origin_route);
1193: WSH_DEBUG_SV.log(l_module_name,'l_destination_route = ',l_destination_route);
1194: WSH_DEBUG_SV.log(l_module_name,'l_origin_id = ',l_origin_id);

Line 1208: FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILE(p_origin_route => l_origin_route,

1204: --
1205: --
1206: -- Create the download file
1207: --
1208: FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILE(p_origin_route => l_origin_route,
1209: p_destination_route => l_destination_route,
1210: p_origin_id => l_origin_id,
1211: p_destination_id => l_destination_id,
1212: p_template_id => p_template_id,

Line 1333: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_NULL_TEMPLATE_ID RAISED');

1329: --
1330: -- Debug Statements
1331: --
1332: IF l_debug_on THEN
1333: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_NULL_TEMPLATE_ID RAISED');
1334: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NULL_TEMPLATE_ID exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1335: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NULL_TEMPLATE_ID');
1336: END IF;
1337: --

Line 1361: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_NULL_ORIGIN_INPUT RAISED');

1357: --
1358: -- Debug Statements
1359: --
1360: IF l_debug_on THEN
1361: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_NULL_ORIGIN_INPUT RAISED');
1362: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NULL_ORIGIN_INPUT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1363: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NULL_ORIGIN_INPUT');
1364: END IF;
1365: --

Line 1388: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_NULL_DEST_INPUT RAISED');

1384: --
1385: -- Debug Statements
1386: --
1387: IF l_debug_on THEN
1388: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_NULL_DEST_INPUT RAISED');
1389: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NULL_DEST_INPUT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1390: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NULL_DEST_INPUT');
1391: END IF;
1392: --

Line 1415: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_MANY_ORIGIN_INPUT RAISED');

1411: --
1412: -- Debug Statements
1413: --
1414: IF l_debug_on THEN
1415: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_MANY_ORIGIN_INPUT RAISED');
1416: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_MANY_ORIGIN_INPUT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1417: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_MANY_ORIGIN_INPUT');
1418: END IF;
1419: --

Line 1442: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_MANY_DEST_INPUT RAISED');

1438: --
1439: -- Debug Statements
1440: --
1441: IF l_debug_on THEN
1442: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_MANY_DEST_INPUT RAISED');
1443: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_MANY_DEST_INPUT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1444: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_MANY_DEST_INPUT');
1445: END IF;
1446: --

Line 1470: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_NULL_REGION_TYPE RAISED');

1466: --
1467: -- Debug Statements
1468: --
1469: IF l_debug_on THEN
1470: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_NULL_REGION_TYPE RAISED');
1471: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NULL_REGION_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1472: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NULL_REGION_TYPE');
1473: END IF;
1474: --

Line 1498: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_NO_FILENAME RAISED');

1494: --
1495: -- Debug Statements
1496: --
1497: IF l_debug_on THEN
1498: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_NO_FILENAME RAISED');
1499: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_FILENAME exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1500: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_FILENAME');
1501: END IF;
1502: --

Line 1526: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_INVALID_FILE_LENGTH RAISED');

1522: --
1523: -- Debug Statements
1524: --
1525: IF l_debug_on THEN
1526: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_INVALID_FILE_LENGTH RAISED');
1527: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_INVALID_FILE_LENGTH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1528: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_INVALID_FILE_LENGTH');
1529: END IF;
1530: --

Line 1554: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_INVALID_FILE_EXT RAISED');

1550: --
1551: -- Debug Statements
1552: --
1553: IF l_debug_on THEN
1554: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_INVALID_FILE_EXT RAISED');
1555: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_INVALID_FILE_EXT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1556: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_INVALID_FILE_EXT');
1557: END IF;
1558: --

Line 1579: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_ERR_CREATE_FILENAME RAISED');

1575: --
1576: -- Debug Statements
1577: --
1578: IF l_debug_on THEN
1579: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_ERR_CREATE_FILENAME RAISED');
1580: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_ERR_CREATE_FILENAME exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1581: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_ERR_CREATE_FILENAME');
1582: END IF;
1583: --

Line 1603: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_DWNLD_FAILED RAISED');

1599: --
1600: -- Debug Statements
1601: --
1602: IF l_debug_on THEN
1603: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_DWNLD_FAILED RAISED');
1604: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_DWNLD_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1605: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_DWNLD_FAILED');
1606: END IF;
1607: --

Line 1627: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA IS ' ||L_ERROR_TEXT );

1623: --
1624: -- Debug Statements
1625: --
1626: IF l_debug_on THEN
1627: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA IS ' ||L_ERROR_TEXT );
1628: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1629: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1630: END IF;
1631: --

Line 1632: WSH_UTIL_CORE.default_handler('FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA');

1628: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1629: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1630: END IF;
1631: --
1632: WSH_UTIL_CORE.default_handler('FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA');
1633: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1634: x_return_message := l_error_text;
1635: --
1636: -- Debug Statements

Line 1793: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME FTE_DIST_NO_FILE_ID RAISED');

1789: --
1790: -- Debug Statements
1791: --
1792: IF l_debug_on THEN
1793: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME FTE_DIST_NO_FILE_ID RAISED');
1794: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_FILE_ID exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1795: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_FILE_ID');
1796: END IF;
1797: --

Line 1820: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME IS ' ||L_ERROR_TEXT );

1816: --
1817: -- Debug Statements
1818: --
1819: IF l_debug_on THEN
1820: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME IS ' ||L_ERROR_TEXT );
1821: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1822: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1823: END IF;
1824: --

Line 1825: WSH_UTIL_CORE.default_handler('FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME');

1821: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1822: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1823: END IF;
1824: --
1825: WSH_UTIL_CORE.default_handler('FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME');
1826: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1827: x_return_message := x_return_message||' - '||l_error_text;
1828: --
1829: -- Debug Statements

Line 1952: l_orig_denorm_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

1948: l_reg_ctr PLS_INTEGER;
1949: l_preg_ctr PLS_INTEGER;
1950: l_cont_ctr PLS_INTEGER;
1951:
1952: l_orig_denorm_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1953: l_dest_denorm_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1954: l_od_pair_tab FTE_DIST_DWNLD_PKG.fte_distd_od_pair_tab;
1955:
1956: l_col_tab FTE_DIST_DWNLD_PKG.fte_distd_col_tab;

Line 1953: l_dest_denorm_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

1949: l_preg_ctr PLS_INTEGER;
1950: l_cont_ctr PLS_INTEGER;
1951:
1952: l_orig_denorm_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1953: l_dest_denorm_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1954: l_od_pair_tab FTE_DIST_DWNLD_PKG.fte_distd_od_pair_tab;
1955:
1956: l_col_tab FTE_DIST_DWNLD_PKG.fte_distd_col_tab;
1957: l_tmplt_col_tab FTE_DIST_DWNLD_PKG.fte_distd_tmplt_col_tab;

Line 1954: l_od_pair_tab FTE_DIST_DWNLD_PKG.fte_distd_od_pair_tab;

1950: l_cont_ctr PLS_INTEGER;
1951:
1952: l_orig_denorm_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1953: l_dest_denorm_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1954: l_od_pair_tab FTE_DIST_DWNLD_PKG.fte_distd_od_pair_tab;
1955:
1956: l_col_tab FTE_DIST_DWNLD_PKG.fte_distd_col_tab;
1957: l_tmplt_col_tab FTE_DIST_DWNLD_PKG.fte_distd_tmplt_col_tab;
1958: l_attr_tab FTE_DIST_DWNLD_PKG.fte_distd_attr_tab;

Line 1956: l_col_tab FTE_DIST_DWNLD_PKG.fte_distd_col_tab;

1952: l_orig_denorm_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1953: l_dest_denorm_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1954: l_od_pair_tab FTE_DIST_DWNLD_PKG.fte_distd_od_pair_tab;
1955:
1956: l_col_tab FTE_DIST_DWNLD_PKG.fte_distd_col_tab;
1957: l_tmplt_col_tab FTE_DIST_DWNLD_PKG.fte_distd_tmplt_col_tab;
1958: l_attr_tab FTE_DIST_DWNLD_PKG.fte_distd_attr_tab;
1959:
1960: l_column_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 1957: l_tmplt_col_tab FTE_DIST_DWNLD_PKG.fte_distd_tmplt_col_tab;

1953: l_dest_denorm_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1954: l_od_pair_tab FTE_DIST_DWNLD_PKG.fte_distd_od_pair_tab;
1955:
1956: l_col_tab FTE_DIST_DWNLD_PKG.fte_distd_col_tab;
1957: l_tmplt_col_tab FTE_DIST_DWNLD_PKG.fte_distd_tmplt_col_tab;
1958: l_attr_tab FTE_DIST_DWNLD_PKG.fte_distd_attr_tab;
1959:
1960: l_column_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1961: l_column_type_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;

Line 1958: l_attr_tab FTE_DIST_DWNLD_PKG.fte_distd_attr_tab;

1954: l_od_pair_tab FTE_DIST_DWNLD_PKG.fte_distd_od_pair_tab;
1955:
1956: l_col_tab FTE_DIST_DWNLD_PKG.fte_distd_col_tab;
1957: l_tmplt_col_tab FTE_DIST_DWNLD_PKG.fte_distd_tmplt_col_tab;
1958: l_attr_tab FTE_DIST_DWNLD_PKG.fte_distd_attr_tab;
1959:
1960: l_column_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1961: l_column_type_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1962: l_column_start_position_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 1960: l_column_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

1956: l_col_tab FTE_DIST_DWNLD_PKG.fte_distd_col_tab;
1957: l_tmplt_col_tab FTE_DIST_DWNLD_PKG.fte_distd_tmplt_col_tab;
1958: l_attr_tab FTE_DIST_DWNLD_PKG.fte_distd_attr_tab;
1959:
1960: l_column_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1961: l_column_type_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1962: l_column_start_position_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1963: l_column_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1964: l_column_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;

Line 1961: l_column_type_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;

1957: l_tmplt_col_tab FTE_DIST_DWNLD_PKG.fte_distd_tmplt_col_tab;
1958: l_attr_tab FTE_DIST_DWNLD_PKG.fte_distd_attr_tab;
1959:
1960: l_column_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1961: l_column_type_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1962: l_column_start_position_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1963: l_column_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1964: l_column_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;
1965: l_column_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 1962: l_column_start_position_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

1958: l_attr_tab FTE_DIST_DWNLD_PKG.fte_distd_attr_tab;
1959:
1960: l_column_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1961: l_column_type_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1962: l_column_start_position_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1963: l_column_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1964: l_column_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;
1965: l_column_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1966:

Line 1963: l_column_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

1959:
1960: l_column_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1961: l_column_type_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1962: l_column_start_position_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1963: l_column_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1964: l_column_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;
1965: l_column_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1966:
1967: l_odattr_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 1964: l_column_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;

1960: l_column_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1961: l_column_type_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1962: l_column_start_position_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1963: l_column_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1964: l_column_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;
1965: l_column_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1966:
1967: l_odattr_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1968: l_odattr_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;

Line 1965: l_column_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

1961: l_column_type_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1962: l_column_start_position_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1963: l_column_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1964: l_column_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;
1965: l_column_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1966:
1967: l_odattr_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1968: l_odattr_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1969: l_odattr_attr_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;

Line 1967: l_odattr_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

1963: l_column_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1964: l_column_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;
1965: l_column_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1966:
1967: l_odattr_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1968: l_odattr_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1969: l_odattr_attr_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;
1970: l_odattr_space_padding_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1971: l_odattr_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 1968: l_odattr_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;

1964: l_column_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;
1965: l_column_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1966:
1967: l_odattr_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1968: l_odattr_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1969: l_odattr_attr_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;
1970: l_odattr_space_padding_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1971: l_odattr_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1972: l_odattr_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 1969: l_odattr_attr_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;

1965: l_column_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1966:
1967: l_odattr_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1968: l_odattr_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1969: l_odattr_attr_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;
1970: l_odattr_space_padding_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1971: l_odattr_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1972: l_odattr_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1973:

Line 1970: l_odattr_space_padding_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

1966:
1967: l_odattr_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1968: l_odattr_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1969: l_odattr_attr_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;
1970: l_odattr_space_padding_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1971: l_odattr_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1972: l_odattr_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1973:
1974: l_retdis_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 1971: l_odattr_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

1967: l_odattr_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1968: l_odattr_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1969: l_odattr_attr_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;
1970: l_odattr_space_padding_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1971: l_odattr_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1972: l_odattr_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1973:
1974: l_retdis_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1975: l_retdis_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;

Line 1972: l_odattr_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

1968: l_odattr_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1969: l_odattr_attr_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;
1970: l_odattr_space_padding_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1971: l_odattr_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1972: l_odattr_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1973:
1974: l_retdis_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1975: l_retdis_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1976: l_retdis_attr_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;

Line 1974: l_retdis_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

1970: l_odattr_space_padding_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1971: l_odattr_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1972: l_odattr_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1973:
1974: l_retdis_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1975: l_retdis_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1976: l_retdis_attr_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;
1977: l_retdis_space_padding_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1978: l_retdis_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 1975: l_retdis_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;

1971: l_odattr_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1972: l_odattr_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1973:
1974: l_retdis_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1975: l_retdis_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1976: l_retdis_attr_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;
1977: l_retdis_space_padding_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1978: l_retdis_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1979: l_retdis_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 1976: l_retdis_attr_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;

1972: l_odattr_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1973:
1974: l_retdis_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1975: l_retdis_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1976: l_retdis_attr_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;
1977: l_retdis_space_padding_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1978: l_retdis_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1979: l_retdis_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1980:

Line 1977: l_retdis_space_padding_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

1973:
1974: l_retdis_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1975: l_retdis_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1976: l_retdis_attr_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;
1977: l_retdis_space_padding_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1978: l_retdis_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1979: l_retdis_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1980:
1981: l_rettim_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 1978: l_retdis_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

1974: l_retdis_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1975: l_retdis_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1976: l_retdis_attr_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;
1977: l_retdis_space_padding_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1978: l_retdis_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1979: l_retdis_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1980:
1981: l_rettim_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1982: l_rettim_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;

Line 1979: l_retdis_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

1975: l_retdis_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1976: l_retdis_attr_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;
1977: l_retdis_space_padding_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1978: l_retdis_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1979: l_retdis_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1980:
1981: l_rettim_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1982: l_rettim_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1983: l_rettim_attr_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;

Line 1981: l_rettim_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

1977: l_retdis_space_padding_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1978: l_retdis_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1979: l_retdis_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1980:
1981: l_rettim_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1982: l_rettim_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1983: l_rettim_attr_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;
1984: l_rettim_space_padding_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1985: l_rettim_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 1982: l_rettim_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;

1978: l_retdis_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1979: l_retdis_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1980:
1981: l_rettim_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1982: l_rettim_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1983: l_rettim_attr_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;
1984: l_rettim_space_padding_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1985: l_rettim_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1986: l_rettim_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 1983: l_rettim_attr_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;

1979: l_retdis_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1980:
1981: l_rettim_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1982: l_rettim_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1983: l_rettim_attr_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;
1984: l_rettim_space_padding_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1985: l_rettim_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1986: l_rettim_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1987:

Line 1984: l_rettim_space_padding_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

1980:
1981: l_rettim_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1982: l_rettim_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1983: l_rettim_attr_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;
1984: l_rettim_space_padding_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1985: l_rettim_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1986: l_rettim_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1987:
1988: l_origin_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 1985: l_rettim_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

1981: l_rettim_column_attr_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1982: l_rettim_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1983: l_rettim_attr_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;
1984: l_rettim_space_padding_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1985: l_rettim_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1986: l_rettim_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1987:
1988: l_origin_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1989: l_origin_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 1986: l_rettim_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

1982: l_rettim_code_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1983: l_rettim_attr_delimiter_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_flag_table;
1984: l_rettim_space_padding_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1985: l_rettim_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1986: l_rettim_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1987:
1988: l_origin_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1989: l_origin_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1990: l_elig_locs_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 1988: l_origin_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

1984: l_rettim_space_padding_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1985: l_rettim_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1986: l_rettim_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1987:
1988: l_origin_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1989: l_origin_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1990: l_elig_locs_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1991: l_destination_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1992: l_destination_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 1989: l_origin_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

1985: l_rettim_sequence_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1986: l_rettim_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1987:
1988: l_origin_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1989: l_origin_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1990: l_elig_locs_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1991: l_destination_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1992: l_destination_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1993:

Line 1990: l_elig_locs_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

1986: l_rettim_length_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1987:
1988: l_origin_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1989: l_origin_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1990: l_elig_locs_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1991: l_destination_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1992: l_destination_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1993:
1994: l_reg_region_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 1991: l_destination_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

1987:
1988: l_origin_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1989: l_origin_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1990: l_elig_locs_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1991: l_destination_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1992: l_destination_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1993:
1994: l_reg_region_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1995: l_reg_postal_code_from_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;

Line 1992: l_destination_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

1988: l_origin_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1989: l_origin_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1990: l_elig_locs_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1991: l_destination_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1992: l_destination_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1993:
1994: l_reg_region_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1995: l_reg_postal_code_from_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1996: l_reg_city_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char60_table;

Line 1994: l_reg_region_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

1990: l_elig_locs_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1991: l_destination_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1992: l_destination_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1993:
1994: l_reg_region_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1995: l_reg_postal_code_from_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1996: l_reg_city_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char60_table;
1997: l_reg_state_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char60_table;
1998: l_reg_county_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char60_table;

Line 1995: l_reg_postal_code_from_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;

1991: l_destination_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1992: l_destination_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1993:
1994: l_reg_region_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1995: l_reg_postal_code_from_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1996: l_reg_city_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char60_table;
1997: l_reg_state_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char60_table;
1998: l_reg_county_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char60_table;
1999: l_reg_country_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char80_table;

Line 1996: l_reg_city_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char60_table;

1992: l_destination_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1993:
1994: l_reg_region_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1995: l_reg_postal_code_from_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1996: l_reg_city_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char60_table;
1997: l_reg_state_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char60_table;
1998: l_reg_county_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char60_table;
1999: l_reg_country_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char80_table;
2000:

Line 1997: l_reg_state_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char60_table;

1993:
1994: l_reg_region_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1995: l_reg_postal_code_from_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1996: l_reg_city_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char60_table;
1997: l_reg_state_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char60_table;
1998: l_reg_county_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char60_table;
1999: l_reg_country_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char80_table;
2000:
2001: l_reg_table FTE_DIST_DWNLD_PKG.fte_distd_region_tab;

Line 1998: l_reg_county_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char60_table;

1994: l_reg_region_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
1995: l_reg_postal_code_from_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1996: l_reg_city_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char60_table;
1997: l_reg_state_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char60_table;
1998: l_reg_county_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char60_table;
1999: l_reg_country_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char80_table;
2000:
2001: l_reg_table FTE_DIST_DWNLD_PKG.fte_distd_region_tab;
2002: l_reg_code_region_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 1999: l_reg_country_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char80_table;

1995: l_reg_postal_code_from_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_code_table;
1996: l_reg_city_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char60_table;
1997: l_reg_state_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char60_table;
1998: l_reg_county_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char60_table;
1999: l_reg_country_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char80_table;
2000:
2001: l_reg_table FTE_DIST_DWNLD_PKG.fte_distd_region_tab;
2002: l_reg_code_region_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2003: l_reg_code_state_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char10_table;

Line 2001: l_reg_table FTE_DIST_DWNLD_PKG.fte_distd_region_tab;

1997: l_reg_state_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char60_table;
1998: l_reg_county_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char60_table;
1999: l_reg_country_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char80_table;
2000:
2001: l_reg_table FTE_DIST_DWNLD_PKG.fte_distd_region_tab;
2002: l_reg_code_region_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2003: l_reg_code_state_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char10_table;
2004: l_reg_code_country_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char10_table;
2005:

Line 2002: l_reg_code_region_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

1998: l_reg_county_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char60_table;
1999: l_reg_country_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char80_table;
2000:
2001: l_reg_table FTE_DIST_DWNLD_PKG.fte_distd_region_tab;
2002: l_reg_code_region_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2003: l_reg_code_state_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char10_table;
2004: l_reg_code_country_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char10_table;
2005:
2006: l_reg_code_table FTE_DIST_DWNLD_PKG.fte_distd_reg_code_tab;

Line 2003: l_reg_code_state_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char10_table;

1999: l_reg_country_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char80_table;
2000:
2001: l_reg_table FTE_DIST_DWNLD_PKG.fte_distd_region_tab;
2002: l_reg_code_region_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2003: l_reg_code_state_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char10_table;
2004: l_reg_code_country_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char10_table;
2005:
2006: l_reg_code_table FTE_DIST_DWNLD_PKG.fte_distd_reg_code_tab;
2007:

Line 2004: l_reg_code_country_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char10_table;

2000:
2001: l_reg_table FTE_DIST_DWNLD_PKG.fte_distd_region_tab;
2002: l_reg_code_region_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2003: l_reg_code_state_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char10_table;
2004: l_reg_code_country_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char10_table;
2005:
2006: l_reg_code_table FTE_DIST_DWNLD_PKG.fte_distd_reg_code_tab;
2007:
2008: l_remove_idx_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 2006: l_reg_code_table FTE_DIST_DWNLD_PKG.fte_distd_reg_code_tab;

2002: l_reg_code_region_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2003: l_reg_code_state_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char10_table;
2004: l_reg_code_country_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char10_table;
2005:
2006: l_reg_code_table FTE_DIST_DWNLD_PKG.fte_distd_reg_code_tab;
2007:
2008: l_remove_idx_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2009: l_distance_tab_origin_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2010: l_distance_tab_distance_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 2008: l_remove_idx_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

2004: l_reg_code_country_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_char10_table;
2005:
2006: l_reg_code_table FTE_DIST_DWNLD_PKG.fte_distd_reg_code_tab;
2007:
2008: l_remove_idx_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2009: l_distance_tab_origin_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2010: l_distance_tab_distance_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2011: l_orig_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2012: l_orig_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 2009: l_distance_tab_origin_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

2005:
2006: l_reg_code_table FTE_DIST_DWNLD_PKG.fte_distd_reg_code_tab;
2007:
2008: l_remove_idx_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2009: l_distance_tab_origin_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2010: l_distance_tab_distance_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2011: l_orig_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2012: l_orig_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2013: l_dest_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 2010: l_distance_tab_distance_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

2006: l_reg_code_table FTE_DIST_DWNLD_PKG.fte_distd_reg_code_tab;
2007:
2008: l_remove_idx_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2009: l_distance_tab_origin_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2010: l_distance_tab_distance_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2011: l_orig_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2012: l_orig_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2013: l_dest_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2014: l_dest_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 2011: l_orig_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

2007:
2008: l_remove_idx_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2009: l_distance_tab_origin_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2010: l_distance_tab_distance_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2011: l_orig_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2012: l_orig_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2013: l_dest_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2014: l_dest_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2015:

Line 2012: l_orig_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

2008: l_remove_idx_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2009: l_distance_tab_origin_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2010: l_distance_tab_distance_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2011: l_orig_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2012: l_orig_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2013: l_dest_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2014: l_dest_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2015:
2016: l_match_locations_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 2013: l_dest_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

2009: l_distance_tab_origin_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2010: l_distance_tab_distance_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2011: l_orig_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2012: l_orig_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2013: l_dest_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2014: l_dest_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2015:
2016: l_match_locations_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2017: l_sub_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 2014: l_dest_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

2010: l_distance_tab_distance_id_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2011: l_orig_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2012: l_orig_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2013: l_dest_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2014: l_dest_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2015:
2016: l_match_locations_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2017: l_sub_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2018: l_sub_region_type_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 2016: l_match_locations_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

2012: l_orig_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2013: l_dest_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2014: l_dest_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2015:
2016: l_match_locations_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2017: l_sub_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2018: l_sub_region_type_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2019: l_match_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2020: l_parent_sub_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 2017: l_sub_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

2013: l_dest_location_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2014: l_dest_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2015:
2016: l_match_locations_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2017: l_sub_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2018: l_sub_region_type_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2019: l_match_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2020: l_parent_sub_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2021: l_parent_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 2018: l_sub_region_type_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

2014: l_dest_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2015:
2016: l_match_locations_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2017: l_sub_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2018: l_sub_region_type_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2019: l_match_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2020: l_parent_sub_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2021: l_parent_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2022: l_sub_par_cont_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 2019: l_match_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

2015:
2016: l_match_locations_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2017: l_sub_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2018: l_sub_region_type_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2019: l_match_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2020: l_parent_sub_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2021: l_parent_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2022: l_sub_par_cont_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2023: l_tmp_orig_reg FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 2020: l_parent_sub_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

2016: l_match_locations_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2017: l_sub_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2018: l_sub_region_type_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2019: l_match_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2020: l_parent_sub_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2021: l_parent_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2022: l_sub_par_cont_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2023: l_tmp_orig_reg FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2024: l_tmp_orig_loc FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 2021: l_parent_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

2017: l_sub_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2018: l_sub_region_type_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2019: l_match_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2020: l_parent_sub_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2021: l_parent_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2022: l_sub_par_cont_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2023: l_tmp_orig_reg FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2024: l_tmp_orig_loc FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2025: l_tmp_dest_reg FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 2022: l_sub_par_cont_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

2018: l_sub_region_type_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2019: l_match_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2020: l_parent_sub_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2021: l_parent_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2022: l_sub_par_cont_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2023: l_tmp_orig_reg FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2024: l_tmp_orig_loc FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2025: l_tmp_dest_reg FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2026: l_tmp_dest_loc FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 2023: l_tmp_orig_reg FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

2019: l_match_region_id FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2020: l_parent_sub_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2021: l_parent_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2022: l_sub_par_cont_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2023: l_tmp_orig_reg FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2024: l_tmp_orig_loc FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2025: l_tmp_dest_reg FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2026: l_tmp_dest_loc FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2027:

Line 2024: l_tmp_orig_loc FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

2020: l_parent_sub_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2021: l_parent_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2022: l_sub_par_cont_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2023: l_tmp_orig_reg FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2024: l_tmp_orig_loc FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2025: l_tmp_dest_reg FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2026: l_tmp_dest_loc FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2027:
2028: l_od_check_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

Line 2025: l_tmp_dest_reg FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

2021: l_parent_regions_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2022: l_sub_par_cont_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2023: l_tmp_orig_reg FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2024: l_tmp_orig_loc FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2025: l_tmp_dest_reg FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2026: l_tmp_dest_loc FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2027:
2028: l_od_check_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2029:

Line 2026: l_tmp_dest_loc FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

2022: l_sub_par_cont_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2023: l_tmp_orig_reg FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2024: l_tmp_orig_loc FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2025: l_tmp_dest_reg FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2026: l_tmp_dest_loc FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2027:
2028: l_od_check_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2029:
2030: cursor c_get_distance_tab_pairs IS

Line 2028: l_od_check_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;

2024: l_tmp_orig_loc FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2025: l_tmp_dest_reg FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2026: l_tmp_dest_loc FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2027:
2028: l_od_check_tab FTE_DIST_DWNLD_PKG.fte_distd_tmp_num_table;
2029:
2030: cursor c_get_distance_tab_pairs IS
2031: select flm.origin_id,
2032: flm.destination_id

Line 5442: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_LOC_REG_MAP');

5438: --
5439: -- Debug Statements
5440: --
5441: IF l_debug_on THEN
5442: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_LOC_REG_MAP');
5443: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_LOC_REG_MAP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5444: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_LOC_REG_MAP');
5445: WSH_DEBUG_SV.pop(l_module_name);
5446: END IF;

Line 5499: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_LOC_SPEC_R1');

5495: --
5496: -- Debug Statements
5497: --
5498: IF l_debug_on THEN
5499: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_LOC_SPEC_R1');
5500: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_LOC_SPEC_R1 exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5501: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_LOC_SPEC_R1');
5502: WSH_DEBUG_SV.pop(l_module_name);
5503: END IF;

Line 5554: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_REGION_SPEC_R2');

5550: --
5551: -- Debug Statements
5552: --
5553: IF l_debug_on THEN
5554: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_REGION_SPEC_R2');
5555: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_REGION_SPEC_R2 exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5556: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_REGION_SPEC_R2');
5557: WSH_DEBUG_SV.pop(l_module_name);
5558: END IF;

Line 5610: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_ELIG_FACILI_R3');

5606: --
5607: -- Debug Statements
5608: --
5609: IF l_debug_on THEN
5610: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_ELIG_FACILI_R3');
5611: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_ELIG_FACILI_R3 exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5612: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_ELIG_FACILI_R3');
5613: WSH_DEBUG_SV.pop(l_module_name);
5614: END IF;

Line 5665: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_DWNLD_DIR RAISED');

5661: --
5662: -- Debug Statements
5663: --
5664: IF l_debug_on THEN
5665: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_DWNLD_DIR RAISED');
5666: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_DWNLD_DIR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5667: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_DWNLD_DIR');
5668: WSH_DEBUG_SV.pop(l_module_name);
5669: END IF;

Line 5720: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_COL_ZERO_START RAISED');

5716: --
5717: -- Debug Statements
5718: --
5719: IF l_debug_on THEN
5720: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_COL_ZERO_START RAISED');
5721: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_COL_ZERO_START exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5722: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_COL_ZERO_START');
5723: WSH_DEBUG_SV.pop(l_module_name);
5724: END IF;

Line 5776: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_path RAISED');

5772: --
5773: -- Debug Statements
5774: --
5775: IF l_debug_on THEN
5776: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_path RAISED');
5777: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_path exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5778: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_path');
5779: WSH_DEBUG_SV.pop(l_module_name);
5780: END IF;

Line 5831: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_mode RAISED');

5827: --
5828: -- Debug Statements
5829: --
5830: IF l_debug_on THEN
5831: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_mode RAISED');
5832: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_mode exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5833: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_mode');
5834: WSH_DEBUG_SV.pop(l_module_name);
5835: END IF;

Line 5887: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_operation RAISED');

5883: --
5884: -- Debug Statements
5885: --
5886: IF l_debug_on THEN
5887: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_operation RAISED');
5888: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_operation exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5889: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_operation');
5890: WSH_DEBUG_SV.pop(l_module_name);
5891: END IF;

Line 5942: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_RET_LENGTH RAISED');

5938: --
5939: -- Debug Statements
5940: --
5941: IF l_debug_on THEN
5942: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_RET_LENGTH RAISED');
5943: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_RET_LENGTH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5944: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_RET_LENGTH');
5945: WSH_DEBUG_SV.pop(l_module_name);
5946: END IF;

Line 5998: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_RET_ATTR RAISED');

5994: --
5995: -- Debug Statements
5996: --
5997: IF l_debug_on THEN
5998: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_RET_ATTR RAISED');
5999: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_RET_ATTR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6000: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_RET_ATTR');
6001: WSH_DEBUG_SV.pop(l_module_name);
6002: END IF;

Line 6053: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_RET_DIST_INV_LENGTH RAISED');

6049: --
6050: -- Debug Statements
6051: --
6052: IF l_debug_on THEN
6053: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_RET_DIST_INV_LENGTH RAISED');
6054: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_RET_DIST_INV_LENGTH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6055: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_RET_DIST_INV_LENGTH');
6056: WSH_DEBUG_SV.pop(l_module_name);
6057: END IF;

Line 6109: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_RET_DIST_INV_START RAISED');

6105: --
6106: -- Debug Statements
6107: --
6108: IF l_debug_on THEN
6109: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_RET_DIST_INV_START RAISED');
6110: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_RET_DIST_INV_START exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6111: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_RET_DIST_INV_START');
6112: WSH_DEBUG_SV.pop(l_module_name);
6113: END IF;

Line 6164: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_RET_TIME_INV_LENGTH RAISED');

6160: --
6161: -- Debug Statements
6162: --
6163: IF l_debug_on THEN
6164: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_RET_TIME_INV_LENGTH RAISED');
6165: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_RET_TIME_INV_LENGTH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6166: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_RET_TIME_INV_LENGTH');
6167: WSH_DEBUG_SV.pop(l_module_name);
6168: END IF;

Line 6221: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_RET_TIME_INV_START RAISED');

6217: --
6218: -- Debug Statements
6219: --
6220: IF l_debug_on THEN
6221: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_RET_TIME_INV_START RAISED');
6222: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_RET_TIME_INV_START exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6223: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_RET_TIME_INV_START');
6224: WSH_DEBUG_SV.pop(l_module_name);
6225: END IF;

Line 6276: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_OD_PAIRS RAISED');

6272: --
6273: -- Debug Statements
6274: --
6275: IF l_debug_on THEN
6276: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_OD_PAIRS RAISED');
6277: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_OD_PAIRS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6278: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_OD_PAIRS');
6279: WSH_DEBUG_SV.pop(l_module_name);
6280: END IF;

Line 6330: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_MATCH_REGIONS_FND RAISED');

6326: --
6327: -- Debug Statements
6328: --
6329: IF l_debug_on THEN
6330: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_MATCH_REGIONS_FND RAISED');
6331: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_MATCH_REGIONS_FND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6332: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_MATCH_REGIONS_FND');
6333: WSH_DEBUG_SV.pop(l_module_name);
6334: END IF;

Line 6383: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_INV_REGION_LOW RAISED');

6379: --
6380: -- Debug Statements
6381: --
6382: IF l_debug_on THEN
6383: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_INV_REGION_LOW RAISED');
6384: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_INV_REGION_LOW exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6385: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_INV_REGION_LOW');
6386: WSH_DEBUG_SV.pop(l_module_name);
6387: END IF;

Line 6439: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILE IS ' ||l_error_text);

6435: --
6436: -- Debug Statements
6437: --
6438: IF l_debug_on THEN
6439: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILE IS ' ||l_error_text);
6440: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6441: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
6442: END IF;
6443: --

Line 6444: WSH_UTIL_CORE.default_handler('FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILE');

6440: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6441: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
6442: END IF;
6443: --
6444: WSH_UTIL_CORE.default_handler('FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILE');
6445: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6446: x_return_message := l_error_text;
6447:
6448: RETURN;

Line 6474: END FTE_DIST_DWNLD_PKG;

6470:
6471:
6472: END FIRST_TIME;
6473:
6474: END FTE_DIST_DWNLD_PKG;