DBA Data[Home] [Help]

APPS.GHR_PER_ASSIGN_EI_AFIUD dependencies on HR_UTILITY

Line 74: hr_utility.set_location('Entering:'|| l_proc , 1);

70:
71: END get_old_assignment_ei_data;
72:
73: BEGIN
74: hr_utility.set_location('Entering:'|| l_proc , 1);
75: ghr_history_api.get_g_session_var( l_session_var);
76:
77: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);
78: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);

Line 77: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);

73: BEGIN
74: hr_utility.set_location('Entering:'|| l_proc , 1);
75: ghr_history_api.get_g_session_var( l_session_var);
76:
77: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);
78: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);
79:
80: IF l_session_var.fire_trigger = 'Y' THEN
81: hr_utility.set_location('Fire Trigger Y :'|| l_proc , 10);

Line 78: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);

74: hr_utility.set_location('Entering:'|| l_proc , 1);
75: ghr_history_api.get_g_session_var( l_session_var);
76:
77: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);
78: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);
79:
80: IF l_session_var.fire_trigger = 'Y' THEN
81: hr_utility.set_location('Fire Trigger Y :'|| l_proc , 10);
82: -- if session variable assignment_id id null assign it the value

Line 81: hr_utility.set_location('Fire Trigger Y :'|| l_proc , 10);

77: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);
78: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);
79:
80: IF l_session_var.fire_trigger = 'Y' THEN
81: hr_utility.set_location('Fire Trigger Y :'|| l_proc , 10);
82: -- if session variable assignment_id id null assign it the value
83: if l_session_var.assignment_id is null then
84: l_session_var.assignment_id := :new.assignment_id;
85: ghr_history_api.set_g_session_var( l_session_var);

Line 94: hr_utility.set_location( l_proc , 170);

90: ghr_history_api.set_g_session_var (l_session_var);
91: END IF;
92: IF (lower(l_session_var.program_name) = 'sf50' or lower(l_session_var.program_name) = 'core') then
93: IF inserting THEN
94: hr_utility.set_location( l_proc , 170);
95: ghr_history_api.get_g_session_var( l_session_var);
96: hr_utility.set_location( l_proc , 160);
97: ghr_history_api.set_operation_info(
98: p_table_name => ghr_history_api.g_asgnei_table,

Line 96: hr_utility.set_location( l_proc , 160);

92: IF (lower(l_session_var.program_name) = 'sf50' or lower(l_session_var.program_name) = 'core') then
93: IF inserting THEN
94: hr_utility.set_location( l_proc , 170);
95: ghr_history_api.get_g_session_var( l_session_var);
96: hr_utility.set_location( l_proc , 160);
97: ghr_history_api.set_operation_info(
98: p_table_name => ghr_history_api.g_asgnei_table,
99: p_program_name => l_session_var.program_name,
100: p_date_effective => l_session_var.date_effective,

Line 108: hr_utility.set_location( l_proc , 140);

104: p_row_id => :new.rowid
105: );
106: ELSIF updating THEN
107: ghr_history_api.get_g_session_var( l_session_var);
108: hr_utility.set_location( l_proc , 140);
109: get_old_assignment_ei_data( l_old_assignment_ei_data);
110: ghr_history_conv_rg.conv_asgnei_rg_to_hist_rg( p_asgnei_data => l_old_assignment_ei_data,
111: p_history_data => l_old_assignment_ei_hist_data);
112:

Line 123: hr_utility.set_location( l_proc , 120);

119: p_old_record_data => l_old_assignment_ei_hist_data,
120: p_row_id => :new.rowid
121: );
122: ELSE /* ie deleting */
123: hr_utility.set_location( l_proc , 120);
124: ghr_history_api.get_g_session_var( l_session_var);
125: /* Should we allow deletes from core. How should it be handled?? */
126: NULL;
127: END IF;

Line 129: hr_utility.set_location('Unknown Program Name - ' || l_session_var.program_name ||' :' || l_proc , 10);

125: /* Should we allow deletes from core. How should it be handled?? */
126: NULL;
127: END IF;
128: ELSE /* Not a known type */
129: hr_utility.set_location('Unknown Program Name - ' || l_session_var.program_name ||' :' || l_proc , 10);
130: hr_utility.set_message( 8301, 'GHR_UNKNOWN_PGM_TYPE');
131: fnd_message.set_token('PROGRAM_TYPE', l_session_var.program_name);
132: hr_utility.raise_error;
133: /* History not maintained */

Line 130: hr_utility.set_message( 8301, 'GHR_UNKNOWN_PGM_TYPE');

126: NULL;
127: END IF;
128: ELSE /* Not a known type */
129: hr_utility.set_location('Unknown Program Name - ' || l_session_var.program_name ||' :' || l_proc , 10);
130: hr_utility.set_message( 8301, 'GHR_UNKNOWN_PGM_TYPE');
131: fnd_message.set_token('PROGRAM_TYPE', l_session_var.program_name);
132: hr_utility.raise_error;
133: /* History not maintained */
134: END IF;

Line 132: hr_utility.raise_error;

128: ELSE /* Not a known type */
129: hr_utility.set_location('Unknown Program Name - ' || l_session_var.program_name ||' :' || l_proc , 10);
130: hr_utility.set_message( 8301, 'GHR_UNKNOWN_PGM_TYPE');
131: fnd_message.set_token('PROGRAM_TYPE', l_session_var.program_name);
132: hr_utility.raise_error;
133: /* History not maintained */
134: END IF;
135: END IF;
136: hr_utility.set_location('Leaving:'|| l_proc , 1);

Line 136: hr_utility.set_location('Leaving:'|| l_proc , 1);

132: hr_utility.raise_error;
133: /* History not maintained */
134: END IF;
135: END IF;
136: hr_utility.set_location('Leaving:'|| l_proc , 1);
137: END GHR_PER_ASSIGN_EI_AFIUD;
138: