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.PER_RO_AEI_INFO dependencies on HR_UTILITY

Line 36: hr_utility.set_location('Entering '||l_proc,10);

32: begin
33: l_proc:=g_package||'check_contract_signed_date';
34:
35:
36: hr_utility.set_location('Entering '||l_proc,10);
37:
38: if p_aei_information1 is not null then
39: open csr_assgt_start_date(P_ASSIGNMENT_ID);
40: fetch csr_assgt_start_date into l_assignment_start_date,l_assignment_end_date;

Line 50: hr_utility.set_location('Contract Signed date=> ' || fnd_date.canonical_to_date(p_aei_information1), 20);

46: end if;
47:
48: close csr_get_contract_id;
49:
50: hr_utility.set_location('Contract Signed date=> ' || fnd_date.canonical_to_date(p_aei_information1), 20);
51: hr_utility.set_location('Assignment Start Date=> ' || l_assignment_start_date , 30);
52: hr_utility.set_location('Contract_id=> ' || l_contract_id, 40);
53: -- date of signing the contract should be atleast 1 day less than the assignment start date
54: if fnd_date.canonical_to_date(p_aei_information1) >= l_assignment_start_date then

Line 51: hr_utility.set_location('Assignment Start Date=> ' || l_assignment_start_date , 30);

47:
48: close csr_get_contract_id;
49:
50: hr_utility.set_location('Contract Signed date=> ' || fnd_date.canonical_to_date(p_aei_information1), 20);
51: hr_utility.set_location('Assignment Start Date=> ' || l_assignment_start_date , 30);
52: hr_utility.set_location('Contract_id=> ' || l_contract_id, 40);
53: -- date of signing the contract should be atleast 1 day less than the assignment start date
54: if fnd_date.canonical_to_date(p_aei_information1) >= l_assignment_start_date then
55: hr_utility.set_message('800','HR_520042_INV_CONRACT_SIGND_DT');

Line 52: hr_utility.set_location('Contract_id=> ' || l_contract_id, 40);

48: close csr_get_contract_id;
49:
50: hr_utility.set_location('Contract Signed date=> ' || fnd_date.canonical_to_date(p_aei_information1), 20);
51: hr_utility.set_location('Assignment Start Date=> ' || l_assignment_start_date , 30);
52: hr_utility.set_location('Contract_id=> ' || l_contract_id, 40);
53: -- date of signing the contract should be atleast 1 day less than the assignment start date
54: if fnd_date.canonical_to_date(p_aei_information1) >= l_assignment_start_date then
55: hr_utility.set_message('800','HR_520042_INV_CONRACT_SIGND_DT');
56: hr_utility.raise_error;

Line 55: hr_utility.set_message('800','HR_520042_INV_CONRACT_SIGND_DT');

51: hr_utility.set_location('Assignment Start Date=> ' || l_assignment_start_date , 30);
52: hr_utility.set_location('Contract_id=> ' || l_contract_id, 40);
53: -- date of signing the contract should be atleast 1 day less than the assignment start date
54: if fnd_date.canonical_to_date(p_aei_information1) >= l_assignment_start_date then
55: hr_utility.set_message('800','HR_520042_INV_CONRACT_SIGND_DT');
56: hr_utility.raise_error;
57: end if;
58:
59:

Line 56: hr_utility.raise_error;

52: hr_utility.set_location('Contract_id=> ' || l_contract_id, 40);
53: -- date of signing the contract should be atleast 1 day less than the assignment start date
54: if fnd_date.canonical_to_date(p_aei_information1) >= l_assignment_start_date then
55: hr_utility.set_message('800','HR_520042_INV_CONRACT_SIGND_DT');
56: hr_utility.raise_error;
57: end if;
58:
59:
60: if (l_contract_id is not null) then

Line 64: hr_utility.set_location('Contract Start Date=> ' || l_contract_start_date, 30);

60: if (l_contract_id is not null) then
61: open csr_contract_start_date(l_contract_id);
62: fetch csr_contract_start_date into l_contract_start_date;
63: close csr_contract_start_date;
64: hr_utility.set_location('Contract Start Date=> ' || l_contract_start_date, 30);
65:
66: --contarct start date should not be less than the contract signing date
67: if fnd_date.canonical_to_date(P_AEI_INFORMATION1) > l_contract_start_date then
68: hr_utility.set_message('800','HR_520043_INV_CONRACT_SIGND_DT');

Line 68: hr_utility.set_message('800','HR_520043_INV_CONRACT_SIGND_DT');

64: hr_utility.set_location('Contract Start Date=> ' || l_contract_start_date, 30);
65:
66: --contarct start date should not be less than the contract signing date
67: if fnd_date.canonical_to_date(P_AEI_INFORMATION1) > l_contract_start_date then
68: hr_utility.set_message('800','HR_520043_INV_CONRACT_SIGND_DT');
69: hr_utility.raise_error;
70: end if;
71: end if;
72: end if;

Line 69: hr_utility.raise_error;

65:
66: --contarct start date should not be less than the contract signing date
67: if fnd_date.canonical_to_date(P_AEI_INFORMATION1) > l_contract_start_date then
68: hr_utility.set_message('800','HR_520043_INV_CONRACT_SIGND_DT');
69: hr_utility.raise_error;
70: end if;
71: end if;
72: end if;
73:

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

70: end if;
71: end if;
72: end if;
73:
74: hr_utility.set_location('Leaving'||g_package||l_proc,50);
75:
76:
77:
78: end check_contract_signed_date;

Line 95: --hr_utility.trace_on(null,'Extra');

91: l_proc VARCHAR2(60);
92: l_exist varchar2(1);
93:
94: Begin
95: --hr_utility.trace_on(null,'Extra');
96: l_proc:=g_package||'CREATE_RO_ASSGT_EXTRA_INFO';
97:
98: hr_utility.set_location('Entering '||l_proc,10);
99: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN

Line 98: hr_utility.set_location('Entering '||l_proc,10);

94: Begin
95: --hr_utility.trace_on(null,'Extra');
96: l_proc:=g_package||'CREATE_RO_ASSGT_EXTRA_INFO';
97:
98: hr_utility.set_location('Entering '||l_proc,10);
99: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
100: hr_utility.set_location('Leaving : '||l_proc,10);
101: return;
102: END IF;

Line 99: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN

95: --hr_utility.trace_on(null,'Extra');
96: l_proc:=g_package||'CREATE_RO_ASSGT_EXTRA_INFO';
97:
98: hr_utility.set_location('Entering '||l_proc,10);
99: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
100: hr_utility.set_location('Leaving : '||l_proc,10);
101: return;
102: END IF;
103:

Line 100: hr_utility.set_location('Leaving : '||l_proc,10);

96: l_proc:=g_package||'CREATE_RO_ASSGT_EXTRA_INFO';
97:
98: hr_utility.set_location('Entering '||l_proc,10);
99: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
100: hr_utility.set_location('Leaving : '||l_proc,10);
101: return;
102: END IF;
103:
104: -- EIT already exist

Line 108: hr_utility.set_message('800','HR_520044_ASG_EIT_EXIST');

104: -- EIT already exist
105: open csr_contract_details_exist;
106: fetch csr_contract_details_exist into l_exist;
107: if csr_contract_details_exist%found then
108: hr_utility.set_message('800','HR_520044_ASG_EIT_EXIST');
109: hr_utility.raise_error;
110: END IF;
111: CLOSE csr_contract_details_exist;
112:

Line 109: hr_utility.raise_error;

105: open csr_contract_details_exist;
106: fetch csr_contract_details_exist into l_exist;
107: if csr_contract_details_exist%found then
108: hr_utility.set_message('800','HR_520044_ASG_EIT_EXIST');
109: hr_utility.raise_error;
110: END IF;
111: CLOSE csr_contract_details_exist;
112:
113: hr_utility.set_location('P_ASSIGNMENT_ID=> ' || P_ASSIGNMENT_ID, 30);

Line 113: hr_utility.set_location('P_ASSIGNMENT_ID=> ' || P_ASSIGNMENT_ID, 30);

109: hr_utility.raise_error;
110: END IF;
111: CLOSE csr_contract_details_exist;
112:
113: hr_utility.set_location('P_ASSIGNMENT_ID=> ' || P_ASSIGNMENT_ID, 30);
114: hr_utility.set_location('P_AEI_INFORMATION1e => ' || P_AEI_INFORMATION1, 30);
115: check_contract_signed_date(P_ASSIGNMENT_ID,
116: P_AEI_INFORMATION1);
117: hr_utility.set_location('Leaving : '||l_proc,20);

Line 114: hr_utility.set_location('P_AEI_INFORMATION1e => ' || P_AEI_INFORMATION1, 30);

110: END IF;
111: CLOSE csr_contract_details_exist;
112:
113: hr_utility.set_location('P_ASSIGNMENT_ID=> ' || P_ASSIGNMENT_ID, 30);
114: hr_utility.set_location('P_AEI_INFORMATION1e => ' || P_AEI_INFORMATION1, 30);
115: check_contract_signed_date(P_ASSIGNMENT_ID,
116: P_AEI_INFORMATION1);
117: hr_utility.set_location('Leaving : '||l_proc,20);
118: --hr_utility.trace_off;

Line 117: hr_utility.set_location('Leaving : '||l_proc,20);

113: hr_utility.set_location('P_ASSIGNMENT_ID=> ' || P_ASSIGNMENT_ID, 30);
114: hr_utility.set_location('P_AEI_INFORMATION1e => ' || P_AEI_INFORMATION1, 30);
115: check_contract_signed_date(P_ASSIGNMENT_ID,
116: P_AEI_INFORMATION1);
117: hr_utility.set_location('Leaving : '||l_proc,20);
118: --hr_utility.trace_off;
119: Exception
120: When others then
121: hr_utility.raise_error;

Line 118: --hr_utility.trace_off;

114: hr_utility.set_location('P_AEI_INFORMATION1e => ' || P_AEI_INFORMATION1, 30);
115: check_contract_signed_date(P_ASSIGNMENT_ID,
116: P_AEI_INFORMATION1);
117: hr_utility.set_location('Leaving : '||l_proc,20);
118: --hr_utility.trace_off;
119: Exception
120: When others then
121: hr_utility.raise_error;
122: end; --end procedure

Line 121: hr_utility.raise_error;

117: hr_utility.set_location('Leaving : '||l_proc,20);
118: --hr_utility.trace_off;
119: Exception
120: When others then
121: hr_utility.raise_error;
122: end; --end procedure
123:
124:
125: procedure UPDATE_RO_ASSGT_EXTRA_INFO(

Line 141: hr_utility.set_location('Entering : '||l_proc,10);

137: l_proc varchar2(60);
138:
139: begin
140: l_proc:= g_package||'UPDATE_RO_ASSGT_EXTRA_INFO';
141: hr_utility.set_location('Entering : '||l_proc,10);
142: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
143: hr_utility.set_location('Leaving : '||l_proc,10);
144: return;
145: END IF;

Line 142: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN

138:
139: begin
140: l_proc:= g_package||'UPDATE_RO_ASSGT_EXTRA_INFO';
141: hr_utility.set_location('Entering : '||l_proc,10);
142: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
143: hr_utility.set_location('Leaving : '||l_proc,10);
144: return;
145: END IF;
146:

Line 143: hr_utility.set_location('Leaving : '||l_proc,10);

139: begin
140: l_proc:= g_package||'UPDATE_RO_ASSGT_EXTRA_INFO';
141: hr_utility.set_location('Entering : '||l_proc,10);
142: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
143: hr_utility.set_location('Leaving : '||l_proc,10);
144: return;
145: END IF;
146:
147: open csr_get_assignment_id;

Line 154: hr_utility.set_location('Leaving'||g_package||l_proc,40);

150:
151: check_contract_signed_date(l_assignment_id,
152: P_AEI_INFORMATION1);
153:
154: hr_utility.set_location('Leaving'||g_package||l_proc,40);
155:
156: Exception
157: When others then
158: hr_utility.set_location('Leaving : '||Sqlerrm,10);

Line 158: hr_utility.set_location('Leaving : '||Sqlerrm,10);

154: hr_utility.set_location('Leaving'||g_package||l_proc,40);
155:
156: Exception
157: When others then
158: hr_utility.set_location('Leaving : '||Sqlerrm,10);
159: hr_utility.raise_error;
160:
161: END UPDATE_RO_ASSGT_EXTRA_INFO; --end procedure update
162:

Line 159: hr_utility.raise_error;

155:
156: Exception
157: When others then
158: hr_utility.set_location('Leaving : '||Sqlerrm,10);
159: hr_utility.raise_error;
160:
161: END UPDATE_RO_ASSGT_EXTRA_INFO; --end procedure update
162:
163: END PER_RO_AEI_INFO ; --end package