27: RETURN l_appl_id;
28: --
29: EXCEPTION
30: WHEN NO_DATA_FOUND THEN
31: FND_MESSAGE.SET_NAME('HXC','HXC_INVALID_APPL_NAME');
32: FND_MESSAGE.RAISE_ERROR;
33: END find_application_id;
34:
35: -- =================================================================
28: --
29: EXCEPTION
30: WHEN NO_DATA_FOUND THEN
31: FND_MESSAGE.SET_NAME('HXC','HXC_INVALID_APPL_NAME');
32: FND_MESSAGE.RAISE_ERROR;
33: END find_application_id;
34:
35: -- =================================================================
36: -- == get_region_row
50: AND region_application_id = p_application_id;
51:
52: -- check region is an LOV region
53: IF l_region_row.region_style <> 'LOV' THEN
54: fnd_message.set_name('HXC', 'HXC_NOT_LOV_REGION');
55: fnd_message.raise_error;
56: END IF;
57:
58: RETURN l_region_row;
51:
52: -- check region is an LOV region
53: IF l_region_row.region_style <> 'LOV' THEN
54: fnd_message.set_name('HXC', 'HXC_NOT_LOV_REGION');
55: fnd_message.raise_error;
56: END IF;
57:
58: RETURN l_region_row;
59:
58: RETURN l_region_row;
59:
60: EXCEPTION
61: WHEN NO_DATA_FOUND then
62: FND_MESSAGE.SET_NAME('HXC','HXC_AK_REGION_NOT_FOUND');
63: FND_MESSAGE.RAISE_ERROR;
64: END get_region_row;
65:
66: PROCEDURE migrate_region
59:
60: EXCEPTION
61: WHEN NO_DATA_FOUND then
62: FND_MESSAGE.SET_NAME('HXC','HXC_AK_REGION_NOT_FOUND');
63: FND_MESSAGE.RAISE_ERROR;
64: END get_region_row;
65:
66: PROCEDURE migrate_region
67: (p_region_code IN ak_regions_vl.region_code%TYPE
109: -- save the MDS document
110: result_code := jdr_docbuilder.save;
111:
112: IF result_code <> jdr_docbuilder.SUCCESS THEN
113: fnd_message.set_name('HXC', 'HXC_MDS_MAP_SAVE_FAILED');
114: fnd_message.raise_error;
115: END IF;
116:
117: -- create the mds document object
110: result_code := jdr_docbuilder.save;
111:
112: IF result_code <> jdr_docbuilder.SUCCESS THEN
113: fnd_message.set_name('HXC', 'HXC_MDS_MAP_SAVE_FAILED');
114: fnd_message.raise_error;
115: END IF;
116:
117: -- create the mds document object
118: region_obj := jdr_docbuilder.createDocument('/oracle/apps/hxc/selfservice/configui/webui/' || p_region_code);
181: -- save the MDS document
182: result_code := jdr_docbuilder.save;
183:
184: IF result_code <> jdr_docbuilder.SUCCESS THEN
185: fnd_message.set_name('HXC', 'HXC_MDS_SAVE_FAILED');
186: fnd_message.raise_error;
187: END IF;
188:
189: END migrate_region;
182: result_code := jdr_docbuilder.save;
183:
184: IF result_code <> jdr_docbuilder.SUCCESS THEN
185: fnd_message.set_name('HXC', 'HXC_MDS_SAVE_FAILED');
186: fnd_message.raise_error;
187: END IF;
188:
189: END migrate_region;
190: