DBA Data[Home] [Help]

APPS.HR_LOA_SS dependencies on HR_LOA_SS

Line 1: PACKAGE BODY HR_LOA_SS

1: PACKAGE BODY HR_LOA_SS
2: /* $Header: hrloawrs.pkb 120.7.12010000.3 2008/08/06 08:43:31 ubhat ship $*/
3: AS
4: g_package constant varchar2(75):='HR_LOA_SS.';
5: g_data_error exception;

Line 4: g_package constant varchar2(75):='HR_LOA_SS.';

1: PACKAGE BODY HR_LOA_SS
2: /* $Header: hrloawrs.pkb 120.7.12010000.3 2008/08/06 08:43:31 ubhat ship $*/
3: AS
4: g_package constant varchar2(75):='HR_LOA_SS.';
5: g_data_error exception;
6: g_date_format constant varchar2(10):='RRRR-MM-DD';
7: g_confirm constant varchar2(9):='CONFIRMED';
8: g_planned constant varchar2(7):='PLANNED';

Line 326: hr_utility.trace(' Exception in HR_LOA_SS.create_person_absence: ' || SQLERRM );

322: hr_utility.set_location(' Leaving:' || l_proc,15);
323:
324: EXCEPTION
325: WHEN OTHERS THEN
326: hr_utility.trace(' Exception in HR_LOA_SS.create_person_absence: ' || SQLERRM );
327: hr_utility.set_location(' Leaving:' || l_proc,555);
328:
329: RAISE; -- Raise error here relevant to the new tech stack.
330:

Line 1349: hr_utility.trace(' Exception in HR_LOA_SS.update_person_absence: ' || SQLERRM );

1345: hr_utility.set_location(' Leaving:' || l_proc,10);
1346:
1347: EXCEPTION
1348: WHEN OTHERS THEN
1349: hr_utility.trace(' Exception in HR_LOA_SS.update_person_absence: ' || SQLERRM );
1350: hr_utility.set_location(' Leaving:' || l_proc,555);
1351:
1352: RAISE; -- Raise error here relevant to the new tech stack.
1353:

Line 1461: ,p_api_name => 'HR_LOA_SS.PROCESS_API'

1457: hr_transaction_api.create_transaction_step(
1458: p_validate => false
1459: ,p_creator_person_id => p_login_person_id
1460: ,p_transaction_id => ln_transaction_id
1461: ,p_api_name => 'HR_LOA_SS.PROCESS_API'
1462: ,p_Item_Type => p_item_type
1463: ,p_Item_Key => p_item_key
1464: ,p_activity_id => p_act_id
1465: ,p_transaction_step_id => ln_transaction_step_id

Line 1510: hr_utility.trace(' Exception in HR_LOA_SS.create_transaction:' || SQLERRM );

1506: hr_utility.set_location(' Leaving:' || l_proc,35);
1507:
1508: EXCEPTION
1509: WHEN OTHERS THEN
1510: hr_utility.trace(' Exception in HR_LOA_SS.create_transaction:' || SQLERRM );
1511: hr_utility.set_location(' Leaving:' || l_proc,555);
1512:
1513: raise ;
1514: END create_transaction ;

Line 2062: hr_utility.trace(' HR_LOA_SS.write_transaction:' || SQLERRM );

2058: hr_utility.set_location(' Leaving:' || l_proc,10);
2059:
2060: EXCEPTION
2061: WHEN OTHERS THEN
2062: hr_utility.trace(' HR_LOA_SS.write_transaction:' || SQLERRM );
2063: hr_utility.set_location(' Leaving:' || l_proc,555);
2064:
2065: raise ;
2066:

Line 3424: hr_utility.trace(' HR_LOA_SS.get_update_transaction ' || SQLERRM );

3420: hr_utility.set_location(' Leaving:' || l_proc,10);
3421:
3422: EXCEPTION
3423: WHEN OTHERS THEN
3424: hr_utility.trace(' HR_LOA_SS.get_update_transaction ' || SQLERRM );
3425: hr_utility.set_location(' Leaving:' || l_proc,555);
3426:
3427: RAISE; -- Raise error here relevant to the new tech stack.
3428: END get_update_transaction;

Line 3657: hr_utility.trace('Exception in g_data_error in HR_LOA_SS..validate_api ' || SQLERRM );

3653: hr_utility.set_location(' Leaving:' || l_proc,10);
3654:
3655: EXCEPTION
3656: WHEN g_data_error THEN
3657: hr_utility.trace('Exception in g_data_error in HR_LOA_SS..validate_api ' || SQLERRM );
3658: hr_utility.set_location(' Leaving:' || l_proc,555);
3659:
3660: raise;
3661:

Line 3663: hr_utility.trace('When others exception in HR_LOA_SS..validate_api ' || SQLERRM );

3659:
3660: raise;
3661:
3662: WHEN OTHERS THEN
3663: hr_utility.trace('When others exception in HR_LOA_SS..validate_api ' || SQLERRM );
3664: hr_utility.set_location(' Leaving:' || l_proc,560);
3665: raise ;
3666:
3667: END validate_api;

Line 4475: hr_utility.trace('Exception HR_LOA_SS..process_save:: ' || SQLERRM );

4471: p_page_error_msg := hr_message.get_message_text;
4472: p_page_error_num := hr_message.last_message_number;
4473: hr_utility.set_location('Leaving..:' || l_proc, 555);
4474: WHEN OTHERS THEN
4475: hr_utility.trace('Exception HR_LOA_SS..process_save:: ' || SQLERRM );
4476: hr_utility.set_location('Leaving..:' || l_proc, 560);
4477: raise ;
4478:
4479: END process_save;

Line 5676: ts.api_name = 'HR_LOA_SS.PROCESS_API'

5672: ,hr_api_transaction_values tv5
5673: ,hr_api_transaction_values tv6
5674: ,hr_api_transactions hat -- Fix 3191531
5675: WHERE
5676: ts.api_name = 'HR_LOA_SS.PROCESS_API'
5677: and ts.UPDATE_PERSON_ID = p_person_id
5678: and p_date_start IS NOT NULL
5679: and p_date_end IS NOT NULL
5680: and ts.transaction_step_id = tv.transaction_step_id

Line 6503: ts.api_name = 'HR_LOA_SS.PROCESS_API'

6499: ,hr_api_transaction_values tv6
6500: ,hr_api_transactions hat -- Fix 3191531
6501:
6502: WHERE
6503: ts.api_name = 'HR_LOA_SS.PROCESS_API'
6504: and ts.UPDATE_PERSON_ID = p_person_id
6505: and p_date_start IS NOT NULL
6506: and p_date_end IS NOT NULL
6507: and ts.transaction_step_id = tv.transaction_step_id

Line 7217: hr_utility.trace( ' HR_LOA_SS.process_save ' || SQLERRM );

7213: p_page_error_msg := hr_message.get_message_text;
7214: p_page_error_num := hr_message.last_message_number;
7215: hr_utility.set_location('Leaving..:' || l_proc, 555);
7216: WHEN OTHERS THEN
7217: hr_utility.trace( ' HR_LOA_SS.process_save ' || SQLERRM );
7218: hr_utility.set_location('Leaving..:' || l_proc, 560);
7219: raise ;
7220:
7221:

Line 9841: ts.api_name = 'HR_LOA_SS.PROCESS_API'

9837: ,hr_api_transaction_values tv5
9838: ,hr_api_transaction_values tv6
9839: ,hr_api_transactions hat -- Fix 3191531
9840: WHERE
9841: ts.api_name = 'HR_LOA_SS.PROCESS_API'
9842: and ts.UPDATE_PERSON_ID = p_person_id
9843: and p_date_start IS NOT NULL
9844: and p_date_end IS NOT NULL
9845: and ts.transaction_step_id = tv.transaction_step_id

Line 9926: END HR_LOA_SS;

9922: hr_utility.set_location('Leaving:'|| l_proc, 555);
9923: raise ;
9924: end chk_overlap;
9925:
9926: END HR_LOA_SS;