DBA Data[Home] [Help]

APPS.HR_PROCESS_CONTACT_SS dependencies on HR_PROCESS_CONTACT_SS

Line 1: PACKAGE BODY HR_PROCESS_CONTACT_SS AS

1: PACKAGE BODY HR_PROCESS_CONTACT_SS AS
2: /* $Header: hrconwrs.pkb 120.13.12020000.3 2012/11/06 09:14:08 aammoham ship $*/
3: --
4: -- Package scope global variables.
5: --

Line 6: g_package varchar2(30) := 'HR_PROCESS_CONTACT_SS';

2: /* $Header: hrconwrs.pkb 120.13.12020000.3 2012/11/06 09:14:08 aammoham ship $*/
3: --
4: -- Package scope global variables.
5: --
6: g_package varchar2(30) := 'HR_PROCESS_CONTACT_SS';
7: g_data_error exception;
8: g_no_changes exception;
9: -- g_date_format constant varchar2(10):='RRRR/MM/DD';
10:

Line 1857: l_basic_details_changed := hr_process_contact_ss.is_rec_changed(

1853: --
1854: -- Bug 3469145 : Not passing p_primary_contact_flag value as it contains data respective to
1855: -- the Emergency relationship and here all the data belong to the other relationship.
1856:
1857: l_basic_details_changed := hr_process_contact_ss.is_rec_changed(
1858: p_effective_date => p_cont_effective_date
1859: ,p_contact_relationship_id => l_contact_relationship_id
1860: ,p_contact_type => p_contact_type
1861: ,p_comments => p_ctr_comments

Line 3937: hr_utility.set_location('Leaving hr_process_contact_ss.update_contact_relationship', 80);

3933: ,p_transaction_step_id => l_transaction_step_id
3934: ,p_api_name => g_package || '.PROCESS_API'
3935: ,p_transaction_data => l_transaction_table);
3936: --
3937: hr_utility.set_location('Leaving hr_process_contact_ss.update_contact_relationship', 80);
3938:
3939: END IF;
3940: --
3941: -- 9999 set out variables here. Do we need to set anyway.

Line 6799: and hats.api_name = 'HR_PROCESS_CONTACT_SS.PROCESS_CREATE_CONTACT_API'

6795: from hr_api_transaction_steps hats,
6796: hr_api_transaction_values hatv
6797: where hats.item_type = p_item_type
6798: and hats.item_key = p_item_key
6799: and hats.api_name = 'HR_PROCESS_CONTACT_SS.PROCESS_CREATE_CONTACT_API'
6800: and hats.transaction_step_id = hatv.transaction_step_id
6801: and hatv.varchar2_value = 'Y'
6802: and hatv.name = upper('p_primary_contact_flag');
6803:

Line 6805: 'HR_PROCESS_CONTACT_SS.create_contact_tt : Check if primary contact already added in previous step : '||l_primary_contact_added, 2146328);

6801: and hatv.varchar2_value = 'Y'
6802: and hatv.name = upper('p_primary_contact_flag');
6803:
6804: hr_utility.set_location(
6805: 'HR_PROCESS_CONTACT_SS.create_contact_tt : Check if primary contact already added in previous step : '||l_primary_contact_added, 2146328);
6806:
6807: EXCEPTION
6808: WHEN others THEN
6809: null;

Line 11737: -- hr_utility.set_location('Entering hr_process_contact_ss.process_api', 100);

11733: --- bug 5894873
11734:
11735: BEGIN
11736: --
11737: -- hr_utility.set_location('Entering hr_process_contact_ss.process_api', 100);
11738: hr_utility.set_location('Entering:'||l_proc, 5);
11739: --
11740: SAVEPOINT update_cont_relationship;
11741:

Line 11759: hr_utility.set_location('Leaving hr_process_contact_ss.process_api', 100);

11755: -- SFL changes
11756: ,p_effective_date => p_effective_date
11757: );
11758: --
11759: hr_utility.set_location('Leaving hr_process_contact_ss.process_api', 100);
11760: return;
11761: --
11762: -- end if;
11763: else -- l_process_section is not 'DELETE_CONTACTS'

Line 14868: hr_utility.set_location('Rollback hr_process_contact_ss.process_api', 100);

14864: END IF;
14865:
14866: --
14867: IF p_validate THEN
14868: hr_utility.set_location('Rollback hr_process_contact_ss.process_api', 100);
14869: ROLLBACK TO update_cont_relationship;
14870: END IF;
14871: --
14872: -- bug# 2080032

Line 14875: hr_utility.set_location('Leaving hr_process_contact_ss.process_api', 100);

14871: --
14872: -- bug# 2080032
14873: end if; -- l_process_section = 'DELETE_CONTACTS'
14874:
14875: hr_utility.set_location('Leaving hr_process_contact_ss.process_api', 100);
14876: --
14877: EXCEPTION
14878: WHEN hr_utility.hr_error THEN
14879: hr_utility.set_location('Exception: WHEN hr_utility.hr_error THEN'||l_proc,555);

Line 14943: hr_process_contact_ss.g_is_address_updated := true;

14939: if (l_cov_date_start < l_cont_start_date) then
14940: open csr_address(p_contact_person_id,l_cont_start_date);
14941: fetch csr_address into l_dummy;
14942: if csr_address%found then
14943: hr_process_contact_ss.g_is_address_updated := true;
14944: end if;
14945: close csr_address;
14946: end if;
14947: end if;

Line 17094: END HR_PROCESS_CONTACT_SS;

17090: end validate_primary_cont_flag;
17091:
17092: --
17093:
17094: END HR_PROCESS_CONTACT_SS;