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_VALIDATION_PKG dependencies on FTE_REGION_ZONE_LOADER

Line 3120: l_zone_id := FTE_REGION_ZONE_LOADER.GET_ZONE_ID(l_region_info.zone);

3116: l_region_info.zone := FTE_UTIL_PKG.GET_DATA('ORIGIN_ZONE', p_values);
3117:
3118: IF (l_region_info.country IS NULL) THEN
3119:
3120: l_zone_id := FTE_REGION_ZONE_LOADER.GET_ZONE_ID(l_region_info.zone);
3121:
3122: IF (l_zone_id IS NULL OR l_zone_id = -1) THEN
3123: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_LANE_ORIGIN_MISSING');
3124:

Line 3139: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => l_region_info);

3135: END IF;
3136:
3137: ELSE
3138:
3139: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => l_region_info);
3140:
3141: IF (l_region_id IS NULL OR l_region_id = -1) THEN
3142: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_REGION_UNKNOWN',
3143: p_tokens => STRINGARRAY('REGION_NAME'),

Line 3160: IF (FTE_REGION_ZONE_LOADER.INSERT_PARTY_REGION(p_region_id => l_region_id,

3156:
3157: --+
3158: -- Inserting the region in wsh_zone_regions
3159: --+
3160: IF (FTE_REGION_ZONE_LOADER.INSERT_PARTY_REGION(p_region_id => l_region_id,
3161: p_parent_region_id => l_region_id,
3162: p_supplier_id => -1,
3163: p_validate_flag => TRUE,
3164: p_postal_code_from => l_region_info.postal_code_from,

Line 3184: l_zone_id := FTE_REGION_ZONE_LOADER.GET_ZONE_ID(l_region_info.zone);

3180: l_region_info.zone := FTE_UTIL_PKG.GET_DATA('DESTINATION_ZONE', p_values);
3181:
3182: IF (l_region_info.country IS NULL) THEN
3183:
3184: l_zone_id := FTE_REGION_ZONE_LOADER.GET_ZONE_ID(l_region_info.zone);
3185:
3186: IF (l_zone_id IS NULL OR l_zone_id = -1 ) THEN
3187: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_LANE_DEST_MISSING');
3188:

Line 3202: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => l_region_info);

3198: p_lane_tbl(l_count).destination_id := l_zone_id;
3199: END IF;
3200:
3201: ELSE
3202: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => l_region_info);
3203:
3204: IF (l_region_id IS NULL OR l_region_id = -1) THEN
3205: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_REGION_UNKNOWN',
3206: p_tokens => STRINGARRAY('REGION_NAME'),

Line 3221: IF (FTE_REGION_ZONE_LOADER.INSERT_PARTY_REGION(p_region_id => l_region_id,

3217: RETURN;
3218: END IF;
3219:
3220: --inserting the region in wsh_zone_regions
3221: IF (FTE_REGION_ZONE_LOADER.INSERT_PARTY_REGION(p_region_id => l_region_id,
3222: p_parent_region_id => l_region_id,
3223: p_supplier_id => -1,
3224: p_validate_flag => TRUE,
3225: p_postal_code_from => l_region_info.postal_code_from,

Line 6277: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => FTE_RATE_CHART_PKG.G_region_info);

6273:
6274: IF (FTE_RATE_CHART_PKG.g_region_flag IS NULL) THEN
6275: FTE_RATE_CHART_PKG.Reset_Region_Info;
6276: ELSIF (FTE_RATE_CHART_PKG.g_region_flag = 'DESTINATION' OR FTE_RATE_CHART_PKG.g_region_linenum <> l_linenum) THEN
6277: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => FTE_RATE_CHART_PKG.G_region_info);
6278:
6279: IF (l_region_id IS NOT NULL OR l_region_id <> -1) THEN
6280: ADD_ATTRIBUTE(p_pricing_attribute => FTE_RATE_CHART_PKG.g_region_flag||'_ZONE',
6281: p_attr_value_from => l_region_id,

Line 6329: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => FTE_RATE_CHART_PKG.G_region_info);

6325: IF (FTE_RATE_CHART_PKG.g_region_flag IS NULL) THEN -- start of New DESTINATION
6326: FTE_RATE_CHART_PKG.Reset_Region_Info;
6327: ELSIF (FTE_RATE_CHART_PKG.g_region_flag = 'ORIGIN' OR FTE_RATE_CHART_PKG.g_region_linenum <> l_linenum) THEN
6328:
6329: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => FTE_RATE_CHART_PKG.G_region_info);
6330:
6331: IF (l_region_id IS NOT NULL OR l_region_id <> -1) THEN
6332: ADD_ATTRIBUTE(p_pricing_attribute => FTE_RATE_CHART_PKG.g_region_flag||'_ZONE',
6333: p_attr_value_from => l_region_id,

Line 6379: l_zone_id := FTE_REGION_ZONE_LOADER.GET_ZONE_ID(l_pricing_attr_value_from);

6375: ELSE --(1)
6376: IF (l_pricing_attribute IN ('ORIGIN_ZONE', 'DESTINATION_ZONE')) THEN --(2)
6377:
6378: -- get ZONE_ID from ZONE_NAME
6379: l_zone_id := FTE_REGION_ZONE_LOADER.GET_ZONE_ID(l_pricing_attr_value_from);
6380:
6381: IF (l_zone_id <> -1 OR l_zone_id IS NOT NULL) THEN
6382: l_pricing_attr_value_from := l_zone_id;
6383: ELSE

Line 6487: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => FTE_RATE_CHART_PKG.G_region_info);

6483: END IF; --end --(2)
6484:
6485: IF (FTE_RATE_CHART_PKG.g_region_flag IS NOT NULL) THEN
6486: -- Insert previous ORIGIN or DESTINATION Region Attribute
6487: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => FTE_RATE_CHART_PKG.G_region_info);
6488:
6489: IF (l_region_id IS NOT NULL OR l_region_id <> -1) THEN
6490: ADD_ATTRIBUTE(p_pricing_attribute => FTE_RATE_CHART_PKG.g_region_flag ||'_ZONE',
6491: p_attr_value_from => l_region_id,

Line 7093: l_zone_id := FTE_REGION_ZONE_LOADER.GET_ZONE_ID(l_region_info.zone);

7089: l_region_info.zone := FTE_UTIL_PKG.GET_DATA('ORIGIN_ZONE',p_values);
7090:
7091: IF (l_region_info.country IS NULL AND l_region_info.zone IS NOT NULL) THEN
7092:
7093: l_zone_id := FTE_REGION_ZONE_LOADER.GET_ZONE_ID(l_region_info.zone);
7094:
7095: IF (l_zone_id <> -1 OR l_zone_id IS NOT NULL) THEN
7096: p_lane_tbl(l_count).origin_id := l_zone_id;
7097: ELSE

Line 7112: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => l_region_info);

7108: END IF;
7109:
7110: ELSIF (l_region_info.country IS NOT NULL) THEN
7111:
7112: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => l_region_info);
7113:
7114: IF (l_region_id IS NULL OR l_region_id = -1) THEN
7115: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_REGION_UNKNOWN',
7116: p_tokens => STRINGARRAY('REGION_NAME'),

Line 7131: IF (FTE_REGION_ZONE_LOADER.INSERT_PARTY_REGION(p_region_id => l_region_id,

7127: RETURN;
7128: END IF;
7129:
7130: --inserting the region in wsh_zone_regions
7131: IF (FTE_REGION_ZONE_LOADER.INSERT_PARTY_REGION(p_region_id => l_region_id,
7132: p_parent_region_id => l_region_id,
7133: p_supplier_id => -1,
7134: p_validate_flag => TRUE,
7135: p_postal_code_from => l_region_info.postal_code_from,

Line 7164: l_zone_id := FTE_REGION_ZONE_LOADER.GET_ZONE_ID(l_region_info.zone);

7160: l_region_info.zone := FTE_UTIL_PKG.GET_DATA('DESTINATION_ZONE',p_values);
7161:
7162: IF (l_region_info.country IS NULL AND l_region_info.zone IS NOT NULL) THEN
7163:
7164: l_zone_id := FTE_REGION_ZONE_LOADER.GET_ZONE_ID(l_region_info.zone);
7165:
7166: IF (l_zone_id <> -1 OR l_zone_id IS NOT NULL) THEN
7167: p_lane_tbl(l_count).destination_id := l_zone_id;
7168: ELSE

Line 7183: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => l_region_info);

7179: END IF;
7180:
7181: ELSIF (l_region_info.country IS NOT NULL) THEN
7182:
7183: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => l_region_info);
7184:
7185: IF (l_region_id IS NULL OR l_region_id = -1) THEN
7186: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_REGION_UNKNOWN',
7187: p_tokens => STRINGARRAY('REGION_NAME'),

Line 7202: IF (FTE_REGION_ZONE_LOADER.INSERT_PARTY_REGION(p_region_id => l_region_id,

7198: RETURN;
7199: END IF;
7200:
7201: --inserting the region in wsh_zone_regions
7202: IF (FTE_REGION_ZONE_LOADER.INSERT_PARTY_REGION(p_region_id => l_region_id,
7203: p_parent_region_id => l_region_id,
7204: p_supplier_id => -1,
7205: p_validate_flag => TRUE,
7206: p_postal_code_from => l_region_info.postal_code_from,

Line 7443: p_zone_id := FTE_REGION_ZONE_LOADER.GET_ZONE_ID(p_zone_name);

7439: END IF;
7440:
7441: END IF;
7442:
7443: p_zone_id := FTE_REGION_ZONE_LOADER.GET_ZONE_ID(p_zone_name);
7444:
7445: --+
7446: -- Zone without any region is not allowed
7447: -- So, create the Zone only when the region is valid

Line 7457: p_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_rec, 'Y');

7453: p_region_rec.city := p_values('CITY');
7454: p_region_rec.postal_code_from := p_values('POSTAL_CODE_FROM');
7455: p_region_rec.postal_code_to := p_values('POSTAL_CODE_TO');
7456:
7457: p_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_rec, 'Y');
7458:
7459: --+
7460: -- No such region, cannot add zone
7461: --+