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.

[Home] [Help]

APPS.PQP_SS_VEHICLE_TRANSACTIONS dependencies on HR_UTILITY

Line 121: hr_utility.set_message(801, 'HR_51751_WEB_TRA_STEP_EXISTS');

117: fetch csr_hats into l_transaction_id;
118: if csr_hats%notfound then
119: -- the transaction step doesn't exist
120: close csr_hats;
121: hr_utility.set_message(801, 'HR_51751_WEB_TRA_STEP_EXISTS');
122: hr_utility.raise_error;
123: end if;
124: close csr_hats;
125: return(l_transaction_id);

Line 122: hr_utility.raise_error;

118: if csr_hats%notfound then
119: -- the transaction step doesn't exist
120: close csr_hats;
121: hr_utility.set_message(801, 'HR_51751_WEB_TRA_STEP_EXISTS');
122: hr_utility.raise_error;
123: end if;
124: close csr_hats;
125: return(l_transaction_id);
126:

Line 128: hr_utility.set_location(' Leaving:'||l_proc, 10);

124: close csr_hats;
125: return(l_transaction_id);
126:
127:
128: hr_utility.set_location(' Leaving:'||l_proc, 10);
129:
130:
131: end get_transaction_id;
132: PROCEDURE delete_process (

Line 1341: WHEN hr_utility.hr_error THEN

1337:
1338: END LOOP;
1339: END IF; --shared vehicle;
1340: EXCEPTION
1341: WHEN hr_utility.hr_error THEN
1342: hr_utility.raise_error;
1343: WHEN OTHERS THEN
1344: RAISE; -- Raise error here relevant to the new tech stack.
1345: END;

Line 1342: hr_utility.raise_error;

1338: END LOOP;
1339: END IF; --shared vehicle;
1340: EXCEPTION
1341: WHEN hr_utility.hr_error THEN
1342: hr_utility.raise_error;
1343: WHEN OTHERS THEN
1344: RAISE; -- Raise error here relevant to the new tech stack.
1345: END;
1346: ---check if other users flag is set to yes, if set to yes

Line 1722: WHEN hr_utility.hr_error THEN

1718: END IF;
1719: END IF;
1720: END IF;
1721: EXCEPTION
1722: WHEN hr_utility.hr_error THEN
1723: hr_utility.raise_error;
1724: WHEN OTHERS THEN
1725: RAISE; -- Raise error here relevant to the new tech stack.
1726: END;

Line 1723: hr_utility.raise_error;

1719: END IF;
1720: END IF;
1721: EXCEPTION
1722: WHEN hr_utility.hr_error THEN
1723: hr_utility.raise_error;
1724: WHEN OTHERS THEN
1725: RAISE; -- Raise error here relevant to the new tech stack.
1726: END;
1727:

Line 2172: WHEN hr_utility.hr_error THEN

2168: END IF;
2169: END LOOP;
2170:
2171: EXCEPTION
2172: WHEN hr_utility.hr_error THEN
2173: hr_utility.raise_error;
2174: WHEN OTHERS THEN
2175: RAISE; -- Raise error here relevant to the new tech stack.
2176:

Line 2173: hr_utility.raise_error;

2169: END LOOP;
2170:
2171: EXCEPTION
2172: WHEN hr_utility.hr_error THEN
2173: hr_utility.raise_error;
2174: WHEN OTHERS THEN
2175: RAISE; -- Raise error here relevant to the new tech stack.
2176:
2177: END;

Line 2334: hr_utility.set_location('Enter:Set Vehicle Details' ,5);

2330: l_error_status VARCHAR2(10);
2331: u_count NUMBER;
2332: l_sec_result VARCHAR2(100);
2333: BEGIN
2334: hr_utility.set_location('Enter:Set Vehicle Details' ,5);
2335: SAVEPOINT pqp_vehicle_proc_start;
2336: BEGIN
2337: hr_utility.set_location('Enter:Set Paramaters' ,10);
2338: SAVEPOINT pqp_vehicle_validate;

Line 2337: hr_utility.set_location('Enter:Set Paramaters' ,10);

2333: BEGIN
2334: hr_utility.set_location('Enter:Set Vehicle Details' ,5);
2335: SAVEPOINT pqp_vehicle_proc_start;
2336: BEGIN
2337: hr_utility.set_location('Enter:Set Paramaters' ,10);
2338: SAVEPOINT pqp_vehicle_validate;
2339: hr_multi_message.enable_message_list;
2340: hr_utility.set_location('Entering: enter set vehicle details',5);
2341: l_count:=l_count+1;

Line 2340: hr_utility.set_location('Entering: enter set vehicle details',5);

2336: BEGIN
2337: hr_utility.set_location('Enter:Set Paramaters' ,10);
2338: SAVEPOINT pqp_vehicle_validate;
2339: hr_multi_message.enable_message_list;
2340: hr_utility.set_location('Entering: enter set vehicle details',5);
2341: l_count:=l_count+1;
2342: l_trans_tbl(l_count).param_name := 'P_LOGIN_PERSON_ID';
2343: l_trans_tbl(l_count).param_value := x_login_person_id;
2344: l_trans_tbl(l_count).param_data_type := 'NUMBER';

Line 3024: hr_utility.set_location('Entering: Second',5);

3020: l_trans_tbl(l_count).param_name := 'P_OBJECT_VERSION_NUMBER';
3021: l_trans_tbl(l_count).param_value := x_object_version_number;
3022: l_trans_tbl(l_count).param_data_type := 'VARCHAR2';
3023: --
3024: hr_utility.set_location('Entering: Second',5);
3025: l_count:=l_count+1;
3026: l_trans_tbl(l_count).param_name := 'P_REVIEW_PROC_CALL';
3027: l_trans_tbl(l_count).param_value := l_review_proc_call;
3028: l_trans_tbl(l_count).param_data_type := 'VARCHAR2';

Line 3040: hr_utility.set_location('Entering: Set p_vehicle_allocation_id',5);

3036: l_count:=l_count+1;
3037: l_trans_tbl(l_count).param_name := 'P_VEHICLE_REPOSITORY_ID';
3038: l_trans_tbl(l_count).param_value := x_vehicle_repository_id;
3039: l_trans_tbl(l_count).param_data_type := 'NUMBER';
3040: hr_utility.set_location('Entering: Set p_vehicle_allocation_id',5);
3041: l_count:=l_count+1;
3042: l_trans_tbl(l_count).param_name := 'P_VEHICLE_ALLOCATION_ID';
3043: l_trans_tbl(l_count).param_value := x_vehicle_allocation_id;
3044: l_trans_tbl(l_count).param_data_type := 'NUMBER';

Line 3045: hr_utility.set_location('Leaving:Set Paramaters' ,15);

3041: l_count:=l_count+1;
3042: l_trans_tbl(l_count).param_name := 'P_VEHICLE_ALLOCATION_ID';
3043: l_trans_tbl(l_count).param_value := x_vehicle_allocation_id;
3044: l_trans_tbl(l_count).param_data_type := 'NUMBER';
3045: hr_utility.set_location('Leaving:Set Paramaters' ,15);
3046:
3047: u_count:=x_user_info.count;
3048: FOR i in 1..x_user_info.count
3049: LOOP

Line 3050: hr_utility.set_location('Entering: userinfo',5);

3046:
3047: u_count:=x_user_info.count;
3048: FOR i in 1..x_user_info.count
3049: LOOP
3050: hr_utility.set_location('Entering: userinfo',5);
3051: l_count:=l_count+1;
3052: hr_utility.set_location('Entering: enter loop',10);
3053: l_trans_tbl(l_count).param_name := 'P_PERSON_USR_ID'||i;
3054: l_trans_tbl(l_count).param_value := x_user_info(i).person_id;

Line 3052: hr_utility.set_location('Entering: enter loop',10);

3048: FOR i in 1..x_user_info.count
3049: LOOP
3050: hr_utility.set_location('Entering: userinfo',5);
3051: l_count:=l_count+1;
3052: hr_utility.set_location('Entering: enter loop',10);
3053: l_trans_tbl(l_count).param_name := 'P_PERSON_USR_ID'||i;
3054: l_trans_tbl(l_count).param_value := x_user_info(i).person_id;
3055: l_trans_tbl(l_count).param_data_type := 'NUMBER';
3056: l_count:=l_count+1;

Line 3064: hr_utility.set_location('Leaving: userinfo',10);

3060: l_count:=l_count+1;
3061: l_trans_tbl(l_count).param_name := 'P_USER_TYPE'||i;
3062: l_trans_tbl(l_count).param_value := x_user_info(i).user_type;
3063: l_trans_tbl(l_count).param_data_type := 'VARCHAR2';
3064: hr_utility.set_location('Leaving: userinfo',10);
3065: END LOOP;
3066: ---Validate the incomming values against acual table.
3067: --The validation is done in false mode and then
3068: --rolled back using autonomous transaction.The resaon for going

Line 3075: hr_utility.set_location('Entering val_create_vehicle_details:',15);

3071: --first api could affect the validation of the second api. Validate True mode
3072: --would rollback once the transaction is completed and this would
3073: -- get the second api with the wrong info as the value is alredy rolled back
3074: --in the first Api.
3075: hr_utility.set_location('Entering val_create_vehicle_details:',15);
3076: val_create_vehicle_details
3077: (
3078: p_validate => false
3079: ,p_effective_date =>x_effective_date

Line 3200: hr_utility.set_location('Leaving val_create_vehicle_details:',20);

3196: ,p_object_version_number =>x_object_version_number
3197: ,p_error_message =>l_error_message
3198: ,p_error_status =>l_error_status
3199: );
3200: hr_utility.set_location('Leaving val_create_vehicle_details:',20);
3201: exception
3202: when hr_multi_message.error_message_exist then
3203: --
3204: -- Catch the Multiple Message List exception which

Line 3213: hr_utility.set_location(' Leaving:' ,40);

3209: --
3210: -- Reset IN OUT parameters and set OUT parameters
3211: x_error_status := hr_multi_message.get_return_status_disable;
3212:
3213: hr_utility.set_location(' Leaving:' ,40);
3214: when others then
3215: --
3216: -- When Multiple Message Detection is enabled catch
3217: -- any Application specific or other unexpected

Line 3230: hr_utility.set_location(' Leaving:' || 'l_proc',50);

3226: end if;
3227: -- Reset IN OUT parameters and set OUT parameters
3228:
3229: x_error_status := hr_multi_message.get_return_status_disable;
3230: hr_utility.set_location(' Leaving:' || 'l_proc',50);
3231: --raise;
3232: hr_utility.set_location('Leaving validation :',30);
3233: END;
3234: -- If there are no error messages then insert values into transaction table

Line 3232: hr_utility.set_location('Leaving validation :',30);

3228:
3229: x_error_status := hr_multi_message.get_return_status_disable;
3230: hr_utility.set_location(' Leaving:' || 'l_proc',50);
3231: --raise;
3232: hr_utility.set_location('Leaving validation :',30);
3233: END;
3234: -- If there are no error messages then insert values into transaction table
3235: SAVEPOINT pqp_create_transaction;
3236: IF x_transaction_id is NULl THEN

Line 3237: hr_utility.set_location('Entering create_transaction :',10);

3233: END;
3234: -- If there are no error messages then insert values into transaction table
3235: SAVEPOINT pqp_create_transaction;
3236: IF x_transaction_id is NULl THEN
3237: hr_utility.set_location('Entering create_transaction :',10);
3238: hr_transaction_api.create_transaction(
3239: p_validate => false
3240: ,p_creator_person_id => x_login_person_id
3241: ,p_transaction_privilege => 'PRIVATE'

Line 3262: hr_utility.set_location('Leaving create_transaction :',15);

3258: ,p_effective_date_option =>x_effective_date_option
3259: ,p_transaction_id =>l_transaction_id
3260: );
3261:
3262: hr_utility.set_location('Leaving create_transaction :',15);
3263: wf_engine.setitemattrnumber
3264: (itemtype => x_item_type
3265: ,itemkey => x_item_key
3266: ,aname => 'TRANSACTION_ID'

Line 3271: hr_utility.set_location('Leaving setitemattrnumber :',20);

3267: ,avalue => l_transaction_id
3268: );
3269:
3270: x_transaction_id := l_transaction_id;
3271: hr_utility.set_location('Leaving setitemattrnumber :',20);
3272: --Create transaction steps
3273: hr_transaction_api.create_transaction_step
3274: (p_validate =>false
3275: ,p_creator_person_id =>x_login_person_id

Line 3285: hr_utility.set_location('Leaving create_transaction_step :',25);

3281: ,p_activity_id =>x_activity_id
3282: ,p_transaction_step_id =>l_transaction_step_id
3283: ,p_object_version_number =>l_ovn
3284: );
3285: hr_utility.set_location('Leaving create_transaction_step :',25);
3286: ELSE
3287: hr_utility.set_location('Entering update transaction :',10);
3288: hr_transaction_api.update_transaction
3289: (p_transaction_id => x_transaction_id

Line 3287: hr_utility.set_location('Entering update transaction :',10);

3283: ,p_object_version_number =>l_ovn
3284: );
3285: hr_utility.set_location('Leaving create_transaction_step :',25);
3286: ELSE
3287: hr_utility.set_location('Entering update transaction :',10);
3288: hr_transaction_api.update_transaction
3289: (p_transaction_id => x_transaction_id
3290: ,p_status => x_status
3291: );

Line 3292: hr_utility.set_location('leaving update transaction :',15);

3288: hr_transaction_api.update_transaction
3289: (p_transaction_id => x_transaction_id
3290: ,p_status => x_status
3291: );
3292: hr_utility.set_location('leaving update transaction :',15);
3293: OPEN c_del_values;
3294: FETCH c_del_values INTO l_del_values;
3295: CLOSE c_del_values;
3296:

Line 3297: hr_utility.set_location('leaving c del value :',20);

3293: OPEN c_del_values;
3294: FETCH c_del_values INTO l_del_values;
3295: CLOSE c_del_values;
3296:
3297: hr_utility.set_location('leaving c del value :',20);
3298: DELETE from hr_api_transaction_values
3299: WHERE transaction_step_id = l_del_values.transaction_step_id;
3300: l_transaction_step_id := l_del_values.transaction_step_id;
3301: hr_utility.set_location('leaving delete :',25);

Line 3301: hr_utility.set_location('leaving delete :',25);

3297: hr_utility.set_location('leaving c del value :',20);
3298: DELETE from hr_api_transaction_values
3299: WHERE transaction_step_id = l_del_values.transaction_step_id;
3300: l_transaction_step_id := l_del_values.transaction_step_id;
3301: hr_utility.set_location('leaving delete :',25);
3302: END IF;
3303: FOR i in 1..l_trans_tbl.count
3304: LOOP
3305: IF l_trans_tbl(i).param_data_type ='VARCHAR2' THEN

Line 3306: hr_utility.set_location('Enter varchar param||l_trans_tbl (i).param_name :',10);

3302: END IF;
3303: FOR i in 1..l_trans_tbl.count
3304: LOOP
3305: IF l_trans_tbl(i).param_data_type ='VARCHAR2' THEN
3306: hr_utility.set_location('Enter varchar param||l_trans_tbl (i).param_name :',10);
3307: hr_utility.set_location('Enter varchar param value||l_trans_tbl (i).param_value :',10);
3308: hr_transaction_api.set_varchar2_value
3309: (p_transaction_step_id =>l_transaction_step_id
3310: ,p_person_id =>x_person_id

Line 3307: hr_utility.set_location('Enter varchar param value||l_trans_tbl (i).param_value :',10);

3303: FOR i in 1..l_trans_tbl.count
3304: LOOP
3305: IF l_trans_tbl(i).param_data_type ='VARCHAR2' THEN
3306: hr_utility.set_location('Enter varchar param||l_trans_tbl (i).param_name :',10);
3307: hr_utility.set_location('Enter varchar param value||l_trans_tbl (i).param_value :',10);
3308: hr_transaction_api.set_varchar2_value
3309: (p_transaction_step_id =>l_transaction_step_id
3310: ,p_person_id =>x_person_id
3311: ,p_name =>l_trans_tbl (i).param_name

Line 3314: hr_utility.set_location('Leaving param data type :',20);

3310: ,p_person_id =>x_person_id
3311: ,p_name =>l_trans_tbl (i).param_name
3312: ,p_value =>l_trans_tbl (i).param_value
3313: );
3314: hr_utility.set_location('Leaving param data type :',20);
3315:
3316: ELSIF l_trans_tbl(i).param_data_type ='DATE' THEN
3317: hr_utility.set_location('Enter date Param||l_trans_tbl (i).param_name :',10);
3318: hr_utility.set_location('Enter date Param Value||

Line 3317: hr_utility.set_location('Enter date Param||l_trans_tbl (i).param_name :',10);

3313: );
3314: hr_utility.set_location('Leaving param data type :',20);
3315:
3316: ELSIF l_trans_tbl(i).param_data_type ='DATE' THEN
3317: hr_utility.set_location('Enter date Param||l_trans_tbl (i).param_name :',10);
3318: hr_utility.set_location('Enter date Param Value||
3319: l_trans_tbl (i).param_value :',10);
3320: hr_transaction_api.set_date_value
3321: (

Line 3318: hr_utility.set_location('Enter date Param Value||

3314: hr_utility.set_location('Leaving param data type :',20);
3315:
3316: ELSIF l_trans_tbl(i).param_data_type ='DATE' THEN
3317: hr_utility.set_location('Enter date Param||l_trans_tbl (i).param_name :',10);
3318: hr_utility.set_location('Enter date Param Value||
3319: l_trans_tbl (i).param_value :',10);
3320: hr_transaction_api.set_date_value
3321: (
3322: p_transaction_step_id => l_transaction_step_id

Line 3327: hr_utility.set_location('Leaving param date :',20);

3323: ,p_person_id => x_person_id
3324: ,p_name => l_trans_tbl (i).param_name
3325: ,p_value => fnd_date.displaydate_to_date(l_trans_tbl (i)
3326: .param_value ) );
3327: hr_utility.set_location('Leaving param date :',20);
3328: ELSIF l_trans_tbl(i).param_data_type ='NUMBER' THEN
3329: hr_utility.set_location('Enter number param||l_trans_tbl (i).param_name :',10);
3330: hr_utility.set_location('Enter number param value||l_trans_tbl (i).param_value :',10);
3331: hr_transaction_api.set_number_value

Line 3329: hr_utility.set_location('Enter number param||l_trans_tbl (i).param_name :',10);

3325: ,p_value => fnd_date.displaydate_to_date(l_trans_tbl (i)
3326: .param_value ) );
3327: hr_utility.set_location('Leaving param date :',20);
3328: ELSIF l_trans_tbl(i).param_data_type ='NUMBER' THEN
3329: hr_utility.set_location('Enter number param||l_trans_tbl (i).param_name :',10);
3330: hr_utility.set_location('Enter number param value||l_trans_tbl (i).param_value :',10);
3331: hr_transaction_api.set_number_value
3332: (
3333: p_transaction_step_id => l_transaction_step_id

Line 3330: hr_utility.set_location('Enter number param value||l_trans_tbl (i).param_value :',10);

3326: .param_value ) );
3327: hr_utility.set_location('Leaving param date :',20);
3328: ELSIF l_trans_tbl(i).param_data_type ='NUMBER' THEN
3329: hr_utility.set_location('Enter number param||l_trans_tbl (i).param_name :',10);
3330: hr_utility.set_location('Enter number param value||l_trans_tbl (i).param_value :',10);
3331: hr_transaction_api.set_number_value
3332: (
3333: p_transaction_step_id => l_transaction_step_id
3334: ,p_person_id => x_person_id

Line 3337: hr_utility.set_location('Leaving param number :',20);

3333: p_transaction_step_id => l_transaction_step_id
3334: ,p_person_id => x_person_id
3335: ,p_name =>l_trans_tbl (i).param_name
3336: ,p_value =>TO_NUMBER(l_trans_tbl (i).param_value ));
3337: hr_utility.set_location('Leaving param number :',20);
3338: END IF;
3339: END LOOP;
3340:
3341:

Line 3359: hr_utility.set_location(' Leaving:' ,40);

3355: --
3356: -- Reset IN OUT parameters and set OUT parameters
3357: x_error_status := hr_multi_message.get_return_status_disable;
3358:
3359: hr_utility.set_location(' Leaving:' ,40);
3360: WHEN others then
3361: --
3362: -- When Multiple Message Detection is enabled catch
3363: -- any Application specific or other unexpected

Line 3376: hr_utility.set_location(' Leaving:' || 'l_proc',50);

3372: END IF;
3373: -- Reset IN OUT parameters and set OUT parameters
3374:
3375: x_error_status := hr_multi_message.get_return_status_disable;
3376: hr_utility.set_location(' Leaving:' || 'l_proc',50);
3377: --raise;
3378:
3379:
3380:

Line 3435: -- WHEN hr_utility.hr_error THEN

3431: ,p_error_status => l_error_status
3432: );
3433:
3434: -- EXCEPTION
3435: -- WHEN hr_utility.hr_error THEN
3436: --hr_utility.raise_error;
3437: -- WHEN OTHERS THEN
3438: -- RAISE; -- Raise error here relevant to the new tech stack.
3439:

Line 3436: --hr_utility.raise_error;

3432: );
3433:
3434: -- EXCEPTION
3435: -- WHEN hr_utility.hr_error THEN
3436: --hr_utility.raise_error;
3437: -- WHEN OTHERS THEN
3438: -- RAISE; -- Raise error here relevant to the new tech stack.
3439:
3440: END;

Line 3608: -- hr_utility.trace_on(NULL,'gattu');

3604: AND pva.effective_end_date
3605: AND pvr.registration_number=l_registration_number;
3606: l_get_details c_get_details%ROWTYPE;
3607: BEGIN
3608: -- hr_utility.trace_on(NULL,'gattu');
3609: hr_utility.set_location('Entering:process_api',5);
3610: hr_utility.set_location(' p_transaction_step_id'|| p_transaction_step_id,5);
3611:
3612: --

Line 3609: hr_utility.set_location('Entering:process_api',5);

3605: AND pvr.registration_number=l_registration_number;
3606: l_get_details c_get_details%ROWTYPE;
3607: BEGIN
3608: -- hr_utility.trace_on(NULL,'gattu');
3609: hr_utility.set_location('Entering:process_api',5);
3610: hr_utility.set_location(' p_transaction_step_id'|| p_transaction_step_id,5);
3611:
3612: --
3613: savepoint process_veh_details;

Line 3610: hr_utility.set_location(' p_transaction_step_id'|| p_transaction_step_id,5);

3606: l_get_details c_get_details%ROWTYPE;
3607: BEGIN
3608: -- hr_utility.trace_on(NULL,'gattu');
3609: hr_utility.set_location('Entering:process_api',5);
3610: hr_utility.set_location(' p_transaction_step_id'|| p_transaction_step_id,5);
3611:
3612: --
3613: savepoint process_veh_details;
3614: --

Line 4258: hr_utility.set_location('Leaving: process_api',10);

4254:
4255: --
4256: --
4257: --
4258: hr_utility.set_location('Leaving: process_api',10);
4259: --hr_utility.trace_off;
4260: EXCEPTION
4261: WHEN hr_utility.hr_error THEN
4262: ROLLBACK TO process_veh_details;

Line 4259: --hr_utility.trace_off;

4255: --
4256: --
4257: --
4258: hr_utility.set_location('Leaving: process_api',10);
4259: --hr_utility.trace_off;
4260: EXCEPTION
4261: WHEN hr_utility.hr_error THEN
4262: ROLLBACK TO process_veh_details;
4263:

Line 4261: WHEN hr_utility.hr_error THEN

4257: --
4258: hr_utility.set_location('Leaving: process_api',10);
4259: --hr_utility.trace_off;
4260: EXCEPTION
4261: WHEN hr_utility.hr_error THEN
4262: ROLLBACK TO process_veh_details;
4263:
4264: hr_utility.raise_error;
4265: WHEN OTHERS THEN

Line 4264: hr_utility.raise_error;

4260: EXCEPTION
4261: WHEN hr_utility.hr_error THEN
4262: ROLLBACK TO process_veh_details;
4263:
4264: hr_utility.raise_error;
4265: WHEN OTHERS THEN
4266: RAISE; -- Raise error here relevant to the new tech stack.
4267: END process_api;
4268:

Line 4331: hr_utility.set_location('Leaving: process_api',10);

4327: l_effective_end_date DATE;
4328:
4329: BEGIN
4330:
4331: hr_utility.set_location('Leaving: process_api',10);
4332:
4333:
4334: OPEN c_get_ovn (
4335: p_vehicle_allocation_id

Line 4387: WHEN hr_utility.hr_error THEN

4383:
4384: p_error_status := 'Y';
4385:
4386: EXCEPTION
4387: WHEN hr_utility.hr_error THEN
4388: p_error_status := 'N';
4389: hr_utility.raise_error;
4390: WHEN OTHERS THEN
4391: RAISE; -- Raise error here relevant to the new tech stack.

Line 4389: hr_utility.raise_error;

4385:
4386: EXCEPTION
4387: WHEN hr_utility.hr_error THEN
4388: p_error_status := 'N';
4389: hr_utility.raise_error;
4390: WHEN OTHERS THEN
4391: RAISE; -- Raise error here relevant to the new tech stack.
4392:
4393: END delete_allocation;