1401: return;
1402:
1403: EXCEPTION
1404: when CUSTOM_EXCEPTION then
1405: pay_core_utils.push_message(801, 'PAY_US_GARN_UPG', 'A');
1406: pay_core_utils.push_token ('Element Type ID', p_elem_type_id);
1407: pay_core_utils.push_token ('Element Name ', l_old_ele_name);
1408: if gv_location = 1 then
1409: pay_core_utils.push_token ('Error Creating New Element ', gv_location);
1402:
1403: EXCEPTION
1404: when CUSTOM_EXCEPTION then
1405: pay_core_utils.push_message(801, 'PAY_US_GARN_UPG', 'A');
1406: pay_core_utils.push_token ('Element Type ID', p_elem_type_id);
1407: pay_core_utils.push_token ('Element Name ', l_old_ele_name);
1408: if gv_location = 1 then
1409: pay_core_utils.push_token ('Error Creating New Element ', gv_location);
1410: elsif gv_location = 2 then
1403: EXCEPTION
1404: when CUSTOM_EXCEPTION then
1405: pay_core_utils.push_message(801, 'PAY_US_GARN_UPG', 'A');
1406: pay_core_utils.push_token ('Element Type ID', p_elem_type_id);
1407: pay_core_utils.push_token ('Element Name ', l_old_ele_name);
1408: if gv_location = 1 then
1409: pay_core_utils.push_token ('Error Creating New Element ', gv_location);
1410: elsif gv_location = 2 then
1411: pay_core_utils.push_token ('Error Creating Balance Feed ', gv_location);
1405: pay_core_utils.push_message(801, 'PAY_US_GARN_UPG', 'A');
1406: pay_core_utils.push_token ('Element Type ID', p_elem_type_id);
1407: pay_core_utils.push_token ('Element Name ', l_old_ele_name);
1408: if gv_location = 1 then
1409: pay_core_utils.push_token ('Error Creating New Element ', gv_location);
1410: elsif gv_location = 2 then
1411: pay_core_utils.push_token ('Error Creating Balance Feed ', gv_location);
1412: end if;
1413: hr_utility.raise_error;
1407: pay_core_utils.push_token ('Element Name ', l_old_ele_name);
1408: if gv_location = 1 then
1409: pay_core_utils.push_token ('Error Creating New Element ', gv_location);
1410: elsif gv_location = 2 then
1411: pay_core_utils.push_token ('Error Creating Balance Feed ', gv_location);
1412: end if;
1413: hr_utility.raise_error;
1414: when others then
1415: pay_core_utils.push_message(801, 'PAY_US_GARN_UPG', 'A');
1411: pay_core_utils.push_token ('Error Creating Balance Feed ', gv_location);
1412: end if;
1413: hr_utility.raise_error;
1414: when others then
1415: pay_core_utils.push_message(801, 'PAY_US_GARN_UPG', 'A');
1416: pay_core_utils.push_token ('Element Type ID', p_elem_type_id);
1417: pay_core_utils.push_token ('Element Name ', l_old_ele_name);
1418: if gv_location = 1 then
1419: pay_core_utils.push_token ('Error Creating New Element ', gv_location);
1412: end if;
1413: hr_utility.raise_error;
1414: when others then
1415: pay_core_utils.push_message(801, 'PAY_US_GARN_UPG', 'A');
1416: pay_core_utils.push_token ('Element Type ID', p_elem_type_id);
1417: pay_core_utils.push_token ('Element Name ', l_old_ele_name);
1418: if gv_location = 1 then
1419: pay_core_utils.push_token ('Error Creating New Element ', gv_location);
1420: elsif gv_location = 2 then
1413: hr_utility.raise_error;
1414: when others then
1415: pay_core_utils.push_message(801, 'PAY_US_GARN_UPG', 'A');
1416: pay_core_utils.push_token ('Element Type ID', p_elem_type_id);
1417: pay_core_utils.push_token ('Element Name ', l_old_ele_name);
1418: if gv_location = 1 then
1419: pay_core_utils.push_token ('Error Creating New Element ', gv_location);
1420: elsif gv_location = 2 then
1421: pay_core_utils.push_token ('Error Creating Balance Feed ', gv_location);
1415: pay_core_utils.push_message(801, 'PAY_US_GARN_UPG', 'A');
1416: pay_core_utils.push_token ('Element Type ID', p_elem_type_id);
1417: pay_core_utils.push_token ('Element Name ', l_old_ele_name);
1418: if gv_location = 1 then
1419: pay_core_utils.push_token ('Error Creating New Element ', gv_location);
1420: elsif gv_location = 2 then
1421: pay_core_utils.push_token ('Error Creating Balance Feed ', gv_location);
1422: end if;
1423: hr_utility.raise_error;
1417: pay_core_utils.push_token ('Element Name ', l_old_ele_name);
1418: if gv_location = 1 then
1419: pay_core_utils.push_token ('Error Creating New Element ', gv_location);
1420: elsif gv_location = 2 then
1421: pay_core_utils.push_token ('Error Creating Balance Feed ', gv_location);
1422: end if;
1423: hr_utility.raise_error;
1424: end upgrade_garnishment;
1425: