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 709: hr_utility.set_location('Entering: Set_vehicle_mileage_claim',5);

705: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
706: BEGIN
707: hr_multi_message.enable_message_list;
708:
709: hr_utility.set_location('Entering: Set_vehicle_mileage_claim',5);
710:
711: l_count:=l_count+1;
712: l_trans_tbl(l_count).param_name := 'P_LOGIN_PERSON_ID';
713: l_trans_tbl(l_count).param_value := x_login_person_id;

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

993: --
994: -- Reset IN OUT parameters and set OUT parameters
995: x_return_status := hr_multi_message.get_return_status_disable;
996:
997: hr_utility.set_location(' Leaving:' ,40);
998: WHEN others then
999: --
1000: -- When Multiple Message Detection is enabled catch
1001: -- any Application specific or other unexpected

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

1009: END IF;
1010: -- Reset IN OUT parameters and set OUT parameters
1011:
1012: x_return_status := hr_multi_message.get_return_status_disable;
1013: hr_utility.set_location(' Leaving:' || 'l_proc',50);
1014:
1015: /* WHEN hr_utility.hr_error THEN
1016: hr_utility.raise_error;
1017: WHEN OTHERS THEN

Line 1015: /* WHEN hr_utility.hr_error THEN

1011:
1012: x_return_status := hr_multi_message.get_return_status_disable;
1013: hr_utility.set_location(' Leaving:' || 'l_proc',50);
1014:
1015: /* WHEN hr_utility.hr_error THEN
1016: hr_utility.raise_error;
1017: WHEN OTHERS THEN
1018: RAISE; -- Raise error here relevant to the new tech stack.
1019: */

Line 1016: hr_utility.raise_error;

1012: x_return_status := hr_multi_message.get_return_status_disable;
1013: hr_utility.set_location(' Leaving:' || 'l_proc',50);
1014:
1015: /* WHEN hr_utility.hr_error THEN
1016: hr_utility.raise_error;
1017: WHEN OTHERS THEN
1018: RAISE; -- Raise error here relevant to the new tech stack.
1019: */
1020: END;

Line 1073: WHEN hr_utility.hr_error THEN

1069: p_return_status =>l_error_status
1070: );
1071:
1072: EXCEPTION
1073: WHEN hr_utility.hr_error THEN
1074: hr_utility.raise_error;
1075: WHEN OTHERS THEN
1076: RAISE; -- Raise error here relevant to the new tech stack.
1077:

Line 1074: hr_utility.raise_error;

1070: );
1071:
1072: EXCEPTION
1073: WHEN hr_utility.hr_error THEN
1074: hr_utility.raise_error;
1075: WHEN OTHERS THEN
1076: RAISE; -- Raise error here relevant to the new tech stack.
1077:
1078: END;

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

1114: l_purpose VARCHAR2(80);
1115: l_element_entry_id NUMBER;
1116:
1117: BEGIN
1118: hr_utility.set_location('Entering:process_api',5);
1119: --
1120: savepoint process_veh_mileage;
1121: --
1122:

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

1246:
1247: --
1248: --
1249: --
1250: hr_utility.set_location('Leaving: process_api',10);
1251: EXCEPTION
1252: WHEN hr_utility.hr_error THEN
1253: ROLLBACK TO process_veh_mileage;
1254: hr_utility.raise_error;

Line 1252: WHEN hr_utility.hr_error THEN

1248: --
1249: --
1250: hr_utility.set_location('Leaving: process_api',10);
1251: EXCEPTION
1252: WHEN hr_utility.hr_error THEN
1253: ROLLBACK TO process_veh_mileage;
1254: hr_utility.raise_error;
1255: WHEN OTHERS THEN
1256: RAISE; -- Raise error here relevant to the new tech stack.

Line 1254: hr_utility.raise_error;

1250: hr_utility.set_location('Leaving: process_api',10);
1251: EXCEPTION
1252: WHEN hr_utility.hr_error THEN
1253: ROLLBACK TO process_veh_mileage;
1254: hr_utility.raise_error;
1255: WHEN OTHERS THEN
1256: RAISE; -- Raise error here relevant to the new tech stack.
1257: END process_api;
1258: