DBA Data[Home] [Help]

APPS.PQP_SS_VEHICLE_MILEAGE_CLAIMS dependencies on HR_UTILITY

Line 286: WHEN hr_utility.hr_error THEN

282: p_return_status => p_return_status
283: );
284: ROLLBACK;
285: EXCEPTION
286: WHEN hr_utility.hr_error THEN
287: hr_utility.raise_error;
288: WHEN OTHERS THEN
289: RAISE; -- Raise error here relevant to the new tech stack.
290: END;

Line 287: hr_utility.raise_error;

283: );
284: ROLLBACK;
285: EXCEPTION
286: WHEN hr_utility.hr_error THEN
287: hr_utility.raise_error;
288: WHEN OTHERS THEN
289: RAISE; -- Raise error here relevant to the new tech stack.
290: END;
291:

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

314: fetch csr_hats into l_transaction_id;
315: if csr_hats%notfound then
316: -- the transaction step doesn't exist
317: close csr_hats;
318: hr_utility.set_message(801, 'HR_51751_WEB_TRA_STEP_EXISTS');
319: hr_utility.raise_error;
320: end if;
321: close csr_hats;
322: p_transaction := l_transaction_id;

Line 319: hr_utility.raise_error;

315: if csr_hats%notfound then
316: -- the transaction step doesn't exist
317: close csr_hats;
318: hr_utility.set_message(801, 'HR_51751_WEB_TRA_STEP_EXISTS');
319: hr_utility.raise_error;
320: end if;
321: close csr_hats;
322: p_transaction := l_transaction_id;
323:

Line 427: WHEN hr_utility.hr_error THEN

423: p_mode:='U';
424: END IF;
425:
426: EXCEPTION
427: WHEN hr_utility.hr_error THEN
428: hr_utility.raise_error;
429: WHEN OTHERS THEN
430: RAISE; -- Raise error here relevant to the new tech stack.
431: END;

Line 428: hr_utility.raise_error;

424: END IF;
425:
426: EXCEPTION
427: WHEN hr_utility.hr_error THEN
428: hr_utility.raise_error;
429: WHEN OTHERS THEN
430: RAISE; -- Raise error here relevant to the new tech stack.
431: END;
432:

Line 456: WHEN hr_utility.hr_error THEN

452: p_return_status =>p_error_status
453: );
454: ROLLBACK;
455: EXCEPTION
456: WHEN hr_utility.hr_error THEN
457: hr_utility.raise_error;
458: WHEN OTHERS THEN
459: RAISE; -- Raise error here relevant to the new tech stack.
460:

Line 457: hr_utility.raise_error;

453: );
454: ROLLBACK;
455: EXCEPTION
456: WHEN hr_utility.hr_error THEN
457: hr_utility.raise_error;
458: WHEN OTHERS THEN
459: RAISE; -- Raise error here relevant to the new tech stack.
460:
461:

Line 628: WHEN hr_utility.hr_error THEN

624: END IF;
625: END LOOP;
626:
627: EXCEPTION
628: WHEN hr_utility.hr_error THEN
629: hr_utility.raise_error;
630: WHEN OTHERS THEN
631: RAISE; -- Raise error here relevant to the new tech stack.
632:

Line 629: hr_utility.raise_error;

625: END LOOP;
626:
627: EXCEPTION
628: WHEN hr_utility.hr_error THEN
629: hr_utility.raise_error;
630: WHEN OTHERS THEN
631: RAISE; -- Raise error here relevant to the new tech stack.
632:
633:

Line 723: hr_utility.set_location('Entering: Set_vehicle_mileage_claim',5);

719: /* Bug Fix 13107787 Ends here */
720:
721: hr_multi_message.enable_message_list;
722:
723: hr_utility.set_location('Entering: Set_vehicle_mileage_claim',5);
724:
725: l_count:=l_count+1;
726: l_trans_tbl(l_count).param_name := 'P_LOGIN_PERSON_ID';
727: l_trans_tbl(l_count).param_value := x_login_person_id;

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

1007: --
1008: -- Reset IN OUT parameters and set OUT parameters
1009: x_return_status := hr_multi_message.get_return_status_disable;
1010:
1011: hr_utility.set_location(' Leaving:' ,40);
1012: WHEN others then
1013: --
1014: -- When Multiple Message Detection is enabled catch
1015: -- any Application specific or other unexpected

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

1023: END IF;
1024: -- Reset IN OUT parameters and set OUT parameters
1025:
1026: x_return_status := hr_multi_message.get_return_status_disable;
1027: hr_utility.set_location(' Leaving:' || 'l_proc',50);
1028:
1029: /* WHEN hr_utility.hr_error THEN
1030: hr_utility.raise_error;
1031: WHEN OTHERS THEN

Line 1029: /* WHEN hr_utility.hr_error THEN

1025:
1026: x_return_status := hr_multi_message.get_return_status_disable;
1027: hr_utility.set_location(' Leaving:' || 'l_proc',50);
1028:
1029: /* WHEN hr_utility.hr_error THEN
1030: hr_utility.raise_error;
1031: WHEN OTHERS THEN
1032: RAISE; -- Raise error here relevant to the new tech stack.
1033: */

Line 1030: hr_utility.raise_error;

1026: x_return_status := hr_multi_message.get_return_status_disable;
1027: hr_utility.set_location(' Leaving:' || 'l_proc',50);
1028:
1029: /* WHEN hr_utility.hr_error THEN
1030: hr_utility.raise_error;
1031: WHEN OTHERS THEN
1032: RAISE; -- Raise error here relevant to the new tech stack.
1033: */
1034: END;

Line 1087: WHEN hr_utility.hr_error THEN

1083: p_return_status =>l_error_status
1084: );
1085:
1086: EXCEPTION
1087: WHEN hr_utility.hr_error THEN
1088: hr_utility.raise_error;
1089: WHEN OTHERS THEN
1090: RAISE; -- Raise error here relevant to the new tech stack.
1091:

Line 1088: hr_utility.raise_error;

1084: );
1085:
1086: EXCEPTION
1087: WHEN hr_utility.hr_error THEN
1088: hr_utility.raise_error;
1089: WHEN OTHERS THEN
1090: RAISE; -- Raise error here relevant to the new tech stack.
1091:
1092: END;

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

1128: l_purpose VARCHAR2(80);
1129: l_element_entry_id NUMBER;
1130:
1131: BEGIN
1132: hr_utility.set_location('Entering:process_api',5);
1133: --
1134: savepoint process_veh_mileage;
1135: --
1136:

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

1260:
1261: --
1262: --
1263: --
1264: hr_utility.set_location('Leaving: process_api',10);
1265: EXCEPTION
1266: WHEN hr_utility.hr_error THEN
1267: ROLLBACK TO process_veh_mileage;
1268: hr_utility.raise_error;

Line 1266: WHEN hr_utility.hr_error THEN

1262: --
1263: --
1264: hr_utility.set_location('Leaving: process_api',10);
1265: EXCEPTION
1266: WHEN hr_utility.hr_error THEN
1267: ROLLBACK TO process_veh_mileage;
1268: hr_utility.raise_error;
1269: WHEN OTHERS THEN
1270: RAISE; -- Raise error here relevant to the new tech stack.

Line 1268: hr_utility.raise_error;

1264: hr_utility.set_location('Leaving: process_api',10);
1265: EXCEPTION
1266: WHEN hr_utility.hr_error THEN
1267: ROLLBACK TO process_veh_mileage;
1268: hr_utility.raise_error;
1269: WHEN OTHERS THEN
1270: RAISE; -- Raise error here relevant to the new tech stack.
1271: END process_api;
1272: