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.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 1342: WHEN hr_utility.hr_error THEN

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

Line 1343: hr_utility.raise_error;

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

Line 1735: WHEN hr_utility.hr_error THEN

1731: END IF;
1732: END IF;
1733: END IF;
1734: EXCEPTION
1735: WHEN hr_utility.hr_error THEN
1736: hr_utility.raise_error;
1737: WHEN OTHERS THEN
1738: RAISE; -- Raise error here relevant to the new tech stack.
1739: END;

Line 1736: hr_utility.raise_error;

1732: END IF;
1733: END IF;
1734: EXCEPTION
1735: WHEN hr_utility.hr_error THEN
1736: hr_utility.raise_error;
1737: WHEN OTHERS THEN
1738: RAISE; -- Raise error here relevant to the new tech stack.
1739: END;
1740:

Line 2185: WHEN hr_utility.hr_error THEN

2181: END IF;
2182: END LOOP;
2183:
2184: EXCEPTION
2185: WHEN hr_utility.hr_error THEN
2186: hr_utility.raise_error;
2187: WHEN OTHERS THEN
2188: RAISE; -- Raise error here relevant to the new tech stack.
2189:

Line 2186: hr_utility.raise_error;

2182: END LOOP;
2183:
2184: EXCEPTION
2185: WHEN hr_utility.hr_error THEN
2186: hr_utility.raise_error;
2187: WHEN OTHERS THEN
2188: RAISE; -- Raise error here relevant to the new tech stack.
2189:
2190: END;

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

2352: end if;
2353:
2354: /* Bug Fix 13870983 Ends here */
2355:
2356: hr_utility.set_location('Enter:Set Vehicle Details' ,5);
2357: SAVEPOINT pqp_vehicle_proc_start;
2358: BEGIN
2359: hr_utility.set_location('Enter:Set Paramaters' ,10);
2360: SAVEPOINT pqp_vehicle_validate;

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

2355:
2356: hr_utility.set_location('Enter:Set Vehicle Details' ,5);
2357: SAVEPOINT pqp_vehicle_proc_start;
2358: BEGIN
2359: hr_utility.set_location('Enter:Set Paramaters' ,10);
2360: SAVEPOINT pqp_vehicle_validate;
2361: hr_multi_message.enable_message_list;
2362: hr_utility.set_location('Entering: enter set vehicle details',5);
2363: l_count:=l_count+1;

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

2358: BEGIN
2359: hr_utility.set_location('Enter:Set Paramaters' ,10);
2360: SAVEPOINT pqp_vehicle_validate;
2361: hr_multi_message.enable_message_list;
2362: hr_utility.set_location('Entering: enter set vehicle details',5);
2363: l_count:=l_count+1;
2364: l_trans_tbl(l_count).param_name := 'P_LOGIN_PERSON_ID';
2365: l_trans_tbl(l_count).param_value := x_login_person_id;
2366: l_trans_tbl(l_count).param_data_type := 'NUMBER';

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

3042: l_trans_tbl(l_count).param_name := 'P_OBJECT_VERSION_NUMBER';
3043: l_trans_tbl(l_count).param_value := x_object_version_number;
3044: l_trans_tbl(l_count).param_data_type := 'VARCHAR2';
3045: --
3046: hr_utility.set_location('Entering: Second',5);
3047: l_count:=l_count+1;
3048: l_trans_tbl(l_count).param_name := 'P_REVIEW_PROC_CALL';
3049: l_trans_tbl(l_count).param_value := l_review_proc_call;
3050: l_trans_tbl(l_count).param_data_type := 'VARCHAR2';

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

3058: l_count:=l_count+1;
3059: l_trans_tbl(l_count).param_name := 'P_VEHICLE_REPOSITORY_ID';
3060: l_trans_tbl(l_count).param_value := x_vehicle_repository_id;
3061: l_trans_tbl(l_count).param_data_type := 'NUMBER';
3062: hr_utility.set_location('Entering: Set p_vehicle_allocation_id',5);
3063: l_count:=l_count+1;
3064: l_trans_tbl(l_count).param_name := 'P_VEHICLE_ALLOCATION_ID';
3065: l_trans_tbl(l_count).param_value := x_vehicle_allocation_id;
3066: l_trans_tbl(l_count).param_data_type := 'NUMBER';

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

3063: l_count:=l_count+1;
3064: l_trans_tbl(l_count).param_name := 'P_VEHICLE_ALLOCATION_ID';
3065: l_trans_tbl(l_count).param_value := x_vehicle_allocation_id;
3066: l_trans_tbl(l_count).param_data_type := 'NUMBER';
3067: hr_utility.set_location('Leaving:Set Paramaters' ,15);
3068:
3069: u_count:=x_user_info.count;
3070: FOR i in 1..x_user_info.count
3071: LOOP

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

3068:
3069: u_count:=x_user_info.count;
3070: FOR i in 1..x_user_info.count
3071: LOOP
3072: hr_utility.set_location('Entering: userinfo',5);
3073: l_count:=l_count+1;
3074: hr_utility.set_location('Entering: enter loop',10);
3075: l_trans_tbl(l_count).param_name := 'P_PERSON_USR_ID'||i;
3076: l_trans_tbl(l_count).param_value := x_user_info(i).person_id;

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

3070: FOR i in 1..x_user_info.count
3071: LOOP
3072: hr_utility.set_location('Entering: userinfo',5);
3073: l_count:=l_count+1;
3074: hr_utility.set_location('Entering: enter loop',10);
3075: l_trans_tbl(l_count).param_name := 'P_PERSON_USR_ID'||i;
3076: l_trans_tbl(l_count).param_value := x_user_info(i).person_id;
3077: l_trans_tbl(l_count).param_data_type := 'NUMBER';
3078: l_count:=l_count+1;

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

3082: l_count:=l_count+1;
3083: l_trans_tbl(l_count).param_name := 'P_USER_TYPE'||i;
3084: l_trans_tbl(l_count).param_value := x_user_info(i).user_type;
3085: l_trans_tbl(l_count).param_data_type := 'VARCHAR2';
3086: hr_utility.set_location('Leaving: userinfo',10);
3087: END LOOP;
3088: ---Validate the incomming values against acual table.
3089: --The validation is done in false mode and then
3090: --rolled back using autonomous transaction.The resaon for going

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

3093: --first api could affect the validation of the second api. Validate True mode
3094: --would rollback once the transaction is completed and this would
3095: -- get the second api with the wrong info as the value is alredy rolled back
3096: --in the first Api.
3097: hr_utility.set_location('Entering val_create_vehicle_details:',15);
3098: IF x_status <> 'S' -- Added the condition to solve SFL issue in bug#12966484
3099: THEN
3100: val_create_vehicle_details
3101: (

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

3221: ,p_error_message =>l_error_message
3222: ,p_error_status =>l_error_status
3223: );
3224: END IF;
3225: hr_utility.set_location('Leaving val_create_vehicle_details:',20);
3226: exception
3227: when hr_multi_message.error_message_exist then
3228: --
3229: -- Catch the Multiple Message List exception which

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

3234: --
3235: -- Reset IN OUT parameters and set OUT parameters
3236: x_error_status := hr_multi_message.get_return_status_disable;
3237:
3238: hr_utility.set_location(' Leaving:' ,40);
3239: when others then
3240: --
3241: -- When Multiple Message Detection is enabled catch
3242: -- any Application specific or other unexpected

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

3251: end if;
3252: -- Reset IN OUT parameters and set OUT parameters
3253:
3254: x_error_status := hr_multi_message.get_return_status_disable;
3255: hr_utility.set_location(' Leaving:' || 'l_proc',50);
3256: --raise;
3257: hr_utility.set_location('Leaving validation :',30);
3258: END;
3259: -- If there are no error messages then insert values into transaction table

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

3253:
3254: x_error_status := hr_multi_message.get_return_status_disable;
3255: hr_utility.set_location(' Leaving:' || 'l_proc',50);
3256: --raise;
3257: hr_utility.set_location('Leaving validation :',30);
3258: END;
3259: -- If there are no error messages then insert values into transaction table
3260: SAVEPOINT pqp_create_transaction;
3261: IF x_transaction_id is NULl THEN

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

3258: END;
3259: -- If there are no error messages then insert values into transaction table
3260: SAVEPOINT pqp_create_transaction;
3261: IF x_transaction_id is NULl THEN
3262: hr_utility.set_location('Entering create_transaction :',10);
3263: hr_transaction_api.create_transaction(
3264: p_validate => false
3265: ,p_creator_person_id => x_login_person_id
3266: ,p_transaction_privilege => 'PRIVATE'

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

3283: ,p_effective_date_option =>x_effective_date_option
3284: ,p_transaction_id =>l_transaction_id
3285: );
3286:
3287: hr_utility.set_location('Leaving create_transaction :',15);
3288: wf_engine.setitemattrnumber
3289: (itemtype => x_item_type
3290: ,itemkey => x_item_key
3291: ,aname => 'TRANSACTION_ID'

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

3292: ,avalue => l_transaction_id
3293: );
3294:
3295: x_transaction_id := l_transaction_id;
3296: hr_utility.set_location('Leaving setitemattrnumber :',20);
3297: --Create transaction steps
3298: hr_transaction_api.create_transaction_step
3299: (p_validate =>false
3300: ,p_creator_person_id =>x_login_person_id

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

3306: ,p_activity_id =>x_activity_id
3307: ,p_transaction_step_id =>l_transaction_step_id
3308: ,p_object_version_number =>l_ovn
3309: );
3310: hr_utility.set_location('Leaving create_transaction_step :',25);
3311: ELSE
3312: hr_utility.set_location('Entering update transaction :',10);
3313: hr_transaction_api.update_transaction
3314: (p_transaction_id => x_transaction_id

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

3308: ,p_object_version_number =>l_ovn
3309: );
3310: hr_utility.set_location('Leaving create_transaction_step :',25);
3311: ELSE
3312: hr_utility.set_location('Entering update transaction :',10);
3313: hr_transaction_api.update_transaction
3314: (p_transaction_id => x_transaction_id
3315: ,p_status => x_status
3316: );

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

3313: hr_transaction_api.update_transaction
3314: (p_transaction_id => x_transaction_id
3315: ,p_status => x_status
3316: );
3317: hr_utility.set_location('leaving update transaction :',15);
3318: OPEN c_del_values;
3319: FETCH c_del_values INTO l_del_values;
3320: CLOSE c_del_values;
3321:

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

3318: OPEN c_del_values;
3319: FETCH c_del_values INTO l_del_values;
3320: CLOSE c_del_values;
3321:
3322: hr_utility.set_location('leaving c del value :',20);
3323: DELETE from hr_api_transaction_values
3324: WHERE transaction_step_id = l_del_values.transaction_step_id;
3325: l_transaction_step_id := l_del_values.transaction_step_id;
3326: hr_utility.set_location('leaving delete :',25);

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

3322: hr_utility.set_location('leaving c del value :',20);
3323: DELETE from hr_api_transaction_values
3324: WHERE transaction_step_id = l_del_values.transaction_step_id;
3325: l_transaction_step_id := l_del_values.transaction_step_id;
3326: hr_utility.set_location('leaving delete :',25);
3327: END IF;
3328: FOR i in 1..l_trans_tbl.count
3329: LOOP
3330: IF l_trans_tbl(i).param_data_type ='VARCHAR2' THEN

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

3327: END IF;
3328: FOR i in 1..l_trans_tbl.count
3329: LOOP
3330: IF l_trans_tbl(i).param_data_type ='VARCHAR2' THEN
3331: hr_utility.set_location('Enter varchar param||l_trans_tbl (i).param_name :',10);
3332: hr_utility.set_location('Enter varchar param value||l_trans_tbl (i).param_value :',10);
3333: hr_transaction_api.set_varchar2_value
3334: (p_transaction_step_id =>l_transaction_step_id
3335: ,p_person_id =>x_person_id

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

3328: FOR i in 1..l_trans_tbl.count
3329: LOOP
3330: IF l_trans_tbl(i).param_data_type ='VARCHAR2' THEN
3331: hr_utility.set_location('Enter varchar param||l_trans_tbl (i).param_name :',10);
3332: hr_utility.set_location('Enter varchar param value||l_trans_tbl (i).param_value :',10);
3333: hr_transaction_api.set_varchar2_value
3334: (p_transaction_step_id =>l_transaction_step_id
3335: ,p_person_id =>x_person_id
3336: ,p_name =>l_trans_tbl (i).param_name

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

3335: ,p_person_id =>x_person_id
3336: ,p_name =>l_trans_tbl (i).param_name
3337: ,p_value =>l_trans_tbl (i).param_value
3338: );
3339: hr_utility.set_location('Leaving param data type :',20);
3340:
3341: ELSIF l_trans_tbl(i).param_data_type ='DATE' THEN
3342: hr_utility.set_location('Enter date Param||l_trans_tbl (i).param_name :',10);
3343: hr_utility.set_location('Enter date Param Value||

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

3338: );
3339: hr_utility.set_location('Leaving param data type :',20);
3340:
3341: ELSIF l_trans_tbl(i).param_data_type ='DATE' THEN
3342: hr_utility.set_location('Enter date Param||l_trans_tbl (i).param_name :',10);
3343: hr_utility.set_location('Enter date Param Value||
3344: l_trans_tbl (i).param_value :',10);
3345: hr_transaction_api.set_date_value
3346: (

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

3339: hr_utility.set_location('Leaving param data type :',20);
3340:
3341: ELSIF l_trans_tbl(i).param_data_type ='DATE' THEN
3342: hr_utility.set_location('Enter date Param||l_trans_tbl (i).param_name :',10);
3343: hr_utility.set_location('Enter date Param Value||
3344: l_trans_tbl (i).param_value :',10);
3345: hr_transaction_api.set_date_value
3346: (
3347: p_transaction_step_id => l_transaction_step_id

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

3348: ,p_person_id => x_person_id
3349: ,p_name => l_trans_tbl (i).param_name
3350: ,p_value => fnd_date.displaydate_to_date(l_trans_tbl (i)
3351: .param_value ) );
3352: hr_utility.set_location('Leaving param date :',20);
3353: ELSIF l_trans_tbl(i).param_data_type ='NUMBER' THEN
3354: hr_utility.set_location('Enter number param||l_trans_tbl (i).param_name :',10);
3355: hr_utility.set_location('Enter number param value||l_trans_tbl (i).param_value :',10);
3356: hr_transaction_api.set_number_value

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

3350: ,p_value => fnd_date.displaydate_to_date(l_trans_tbl (i)
3351: .param_value ) );
3352: hr_utility.set_location('Leaving param date :',20);
3353: ELSIF l_trans_tbl(i).param_data_type ='NUMBER' THEN
3354: hr_utility.set_location('Enter number param||l_trans_tbl (i).param_name :',10);
3355: hr_utility.set_location('Enter number param value||l_trans_tbl (i).param_value :',10);
3356: hr_transaction_api.set_number_value
3357: (
3358: p_transaction_step_id => l_transaction_step_id

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

3351: .param_value ) );
3352: hr_utility.set_location('Leaving param date :',20);
3353: ELSIF l_trans_tbl(i).param_data_type ='NUMBER' THEN
3354: hr_utility.set_location('Enter number param||l_trans_tbl (i).param_name :',10);
3355: hr_utility.set_location('Enter number param value||l_trans_tbl (i).param_value :',10);
3356: hr_transaction_api.set_number_value
3357: (
3358: p_transaction_step_id => l_transaction_step_id
3359: ,p_person_id => x_person_id

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

3358: p_transaction_step_id => l_transaction_step_id
3359: ,p_person_id => x_person_id
3360: ,p_name =>l_trans_tbl (i).param_name
3361: ,p_value =>TO_NUMBER(l_trans_tbl (i).param_value ));
3362: hr_utility.set_location('Leaving param number :',20);
3363: END IF;
3364: END LOOP;
3365:
3366:

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

3380: --
3381: -- Reset IN OUT parameters and set OUT parameters
3382: x_error_status := hr_multi_message.get_return_status_disable;
3383:
3384: hr_utility.set_location(' Leaving:' ,40);
3385: WHEN others then
3386: --
3387: -- When Multiple Message Detection is enabled catch
3388: -- any Application specific or other unexpected

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

3397: END IF;
3398: -- Reset IN OUT parameters and set OUT parameters
3399:
3400: x_error_status := hr_multi_message.get_return_status_disable;
3401: hr_utility.set_location(' Leaving:' || 'l_proc',50);
3402: --raise;
3403:
3404:
3405:

Line 3460: -- WHEN hr_utility.hr_error THEN

3456: ,p_error_status => l_error_status
3457: );
3458:
3459: -- EXCEPTION
3460: -- WHEN hr_utility.hr_error THEN
3461: --hr_utility.raise_error;
3462: -- WHEN OTHERS THEN
3463: -- RAISE; -- Raise error here relevant to the new tech stack.
3464:

Line 3461: --hr_utility.raise_error;

3457: );
3458:
3459: -- EXCEPTION
3460: -- WHEN hr_utility.hr_error THEN
3461: --hr_utility.raise_error;
3462: -- WHEN OTHERS THEN
3463: -- RAISE; -- Raise error here relevant to the new tech stack.
3464:
3465: END;

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

3629: AND pva.effective_end_date
3630: AND pvr.registration_number=l_registration_number;
3631: l_get_details c_get_details%ROWTYPE;
3632: BEGIN
3633: -- hr_utility.trace_on(NULL,'gattu');
3634: hr_utility.set_location('Entering:process_api',5);
3635: hr_utility.set_location(' p_transaction_step_id'|| p_transaction_step_id,5);
3636:
3637: --

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

3630: AND pvr.registration_number=l_registration_number;
3631: l_get_details c_get_details%ROWTYPE;
3632: BEGIN
3633: -- hr_utility.trace_on(NULL,'gattu');
3634: hr_utility.set_location('Entering:process_api',5);
3635: hr_utility.set_location(' p_transaction_step_id'|| p_transaction_step_id,5);
3636:
3637: --
3638: savepoint process_veh_details;

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

3631: l_get_details c_get_details%ROWTYPE;
3632: BEGIN
3633: -- hr_utility.trace_on(NULL,'gattu');
3634: hr_utility.set_location('Entering:process_api',5);
3635: hr_utility.set_location(' p_transaction_step_id'|| p_transaction_step_id,5);
3636:
3637: --
3638: savepoint process_veh_details;
3639: --

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

4279:
4280: --
4281: --
4282: --
4283: hr_utility.set_location('Leaving: process_api',10);
4284: --hr_utility.trace_off;
4285: EXCEPTION
4286: WHEN hr_utility.hr_error THEN
4287: ROLLBACK TO process_veh_details;

Line 4284: --hr_utility.trace_off;

4280: --
4281: --
4282: --
4283: hr_utility.set_location('Leaving: process_api',10);
4284: --hr_utility.trace_off;
4285: EXCEPTION
4286: WHEN hr_utility.hr_error THEN
4287: ROLLBACK TO process_veh_details;
4288:

Line 4286: WHEN hr_utility.hr_error THEN

4282: --
4283: hr_utility.set_location('Leaving: process_api',10);
4284: --hr_utility.trace_off;
4285: EXCEPTION
4286: WHEN hr_utility.hr_error THEN
4287: ROLLBACK TO process_veh_details;
4288:
4289: hr_utility.raise_error;
4290: WHEN OTHERS THEN

Line 4289: hr_utility.raise_error;

4285: EXCEPTION
4286: WHEN hr_utility.hr_error THEN
4287: ROLLBACK TO process_veh_details;
4288:
4289: hr_utility.raise_error;
4290: WHEN OTHERS THEN
4291: RAISE; -- Raise error here relevant to the new tech stack.
4292: END process_api;
4293:

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

4352: l_effective_end_date DATE;
4353:
4354: BEGIN
4355:
4356: hr_utility.set_location('Leaving: process_api',10);
4357:
4358:
4359: OPEN c_get_ovn (
4360: p_vehicle_allocation_id

Line 4412: WHEN hr_utility.hr_error THEN

4408:
4409: p_error_status := 'Y';
4410:
4411: EXCEPTION
4412: WHEN hr_utility.hr_error THEN
4413: p_error_status := 'N';
4414: hr_utility.raise_error;
4415: WHEN OTHERS THEN
4416: RAISE; -- Raise error here relevant to the new tech stack.

Line 4414: hr_utility.raise_error;

4410:
4411: EXCEPTION
4412: WHEN hr_utility.hr_error THEN
4413: p_error_status := 'N';
4414: hr_utility.raise_error;
4415: WHEN OTHERS THEN
4416: RAISE; -- Raise error here relevant to the new tech stack.
4417:
4418: END delete_allocation;