DBA Data[Home] [Help]

APPS.HXC_RETRIEVE_ABSENCES dependencies on HXC_TIMECARD

Line 160: hxc_timecard_message_helper.addErrorToCollection

156: IF g_pending_appr = TRUE
157: THEN
158: IF g_pending_delete = TRUE
159: THEN
160: hxc_timecard_message_helper.addErrorToCollection
161: ( g_messages
162: ,'HXC_ABS_PEND_APPR_DELETE'
163: ,hxc_timecard.c_error
164: ,NULL

Line 163: ,hxc_timecard.c_error

159: THEN
160: hxc_timecard_message_helper.addErrorToCollection
161: ( g_messages
162: ,'HXC_ABS_PEND_APPR_DELETE'
163: ,hxc_timecard.c_error
164: ,NULL
165: ,NULL
166: ,hxc_timecard.c_hxc
167: ,NULL

Line 166: ,hxc_timecard.c_hxc

162: ,'HXC_ABS_PEND_APPR_DELETE'
163: ,hxc_timecard.c_error
164: ,NULL
165: ,NULL
166: ,hxc_timecard.c_hxc
167: ,NULL
168: ,NULL
169: ,NULL
170: ,NULL

Line 180: hxc_timecard_message_helper.addErrorToCollection

176:
177: IF g_pref_table(i).attribute3 = 'ERROR'
178: THEN
179: hr_utility.trace('ABS : This is pending APPROVAL in SSHR -- ERROR');
180: hxc_timecard_message_helper.addErrorToCollection
181: (g_messages
182: ,'HXC_ABS_PEND_APPR_ERROR'
183: ,hxc_timecard.c_error
184: ,NULL

Line 183: ,hxc_timecard.c_error

179: hr_utility.trace('ABS : This is pending APPROVAL in SSHR -- ERROR');
180: hxc_timecard_message_helper.addErrorToCollection
181: (g_messages
182: ,'HXC_ABS_PEND_APPR_ERROR'
183: ,hxc_timecard.c_error
184: ,NULL
185: ,NULL
186: ,hxc_timecard.c_hxc
187: ,NULL

Line 186: ,hxc_timecard.c_hxc

182: ,'HXC_ABS_PEND_APPR_ERROR'
183: ,hxc_timecard.c_error
184: ,NULL
185: ,NULL
186: ,hxc_timecard.c_hxc
187: ,NULL
188: ,NULL
189: ,NULL
190: ,NULL

Line 208: hxc_timecard_message_helper.addErrorToCollection

204: THEN
205: IF g_pref_table(i).attribute7 = 'ERROR'
206: THEN
207: hr_utility.trace('ABS : This is pending Confirmation in SSHR -- ERROR');
208: hxc_timecard_message_helper.addErrorToCollection
209: (g_messages
210: ,'HXC_ABS_PEND_CONF_ERROR'
211: ,hxc_timecard.c_error
212: ,NULL

Line 211: ,hxc_timecard.c_error

207: hr_utility.trace('ABS : This is pending Confirmation in SSHR -- ERROR');
208: hxc_timecard_message_helper.addErrorToCollection
209: (g_messages
210: ,'HXC_ABS_PEND_CONF_ERROR'
211: ,hxc_timecard.c_error
212: ,NULL
213: ,NULL
214: ,hxc_timecard.c_hxc
215: ,NULL

Line 214: ,hxc_timecard.c_hxc

210: ,'HXC_ABS_PEND_CONF_ERROR'
211: ,hxc_timecard.c_error
212: ,NULL
213: ,NULL
214: ,hxc_timecard.c_hxc
215: ,NULL
216: ,NULL
217: ,NULL
218: ,NULL

Line 1611: FROM hxc_timecard_summary

1607: BEGIN
1608:
1609: SELECT 'Y'
1610: INTO l_timecard_exists
1611: FROM hxc_timecard_summary
1612: WHERE resource_id = p_person_id
1613: AND trunc(start_time) = trunc(p_start_date)
1614: AND trunc(stop_time) = trunc(p_end_date);
1615:

Line 1771: FROM hxc_timecard_summary

1767: BEGIN
1768:
1769: SELECT 'Y'
1770: INTO l_timecard_exists
1771: FROM hxc_timecard_summary
1772: WHERE resource_id = l_person_id
1773: AND trunc(start_time) = trunc(l_start_date)
1774: AND trunc(stop_time) = trunc(l_end_date);
1775:

Line 2778: p_error_level IN VARCHAR2 DEFAULT hxc_timecard.c_error,

2774:
2775: PROCEDURE add_error_to_tc( p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE,
2776: p_error_code IN VARCHAR2,
2777: p_bb_id IN NUMBER,
2778: p_error_level IN VARCHAR2 DEFAULT hxc_timecard.c_error,
2779: p_token IN VARCHAR2 DEFAULT NULL)
2780: IS
2781:
2782: BEGIN

Line 2783: hxc_timecard_message_helper.addErrorToCollection

2779: p_token IN VARCHAR2 DEFAULT NULL)
2780: IS
2781:
2782: BEGIN
2783: hxc_timecard_message_helper.addErrorToCollection
2784: (p_messages
2785: ,p_error_code
2786: ,p_error_level
2787: ,null

Line 2789: ,hxc_timecard.c_hxc

2785: ,p_error_code
2786: ,p_error_level
2787: ,null
2788: ,p_token
2789: ,hxc_timecard.c_hxc
2790: ,p_bb_id
2791: ,1
2792: ,null
2793: ,null

Line 2798: IF p_error_level = hxc_timecard.c_error

2794: );
2795: -- Bug 8945924
2796: -- Corrected the below condition to '='
2797: -- so that the flag is set only if there was an error.
2798: IF p_error_level = hxc_timecard.c_error
2799: THEN
2800: l_validation_error := TRUE;
2801: END IF;
2802: END add_error_to_tc;

Line 3556: hxc_timecard.c_warning);

3552: ELSE
3553: add_error_to_tc(p_messages,
3554: 'HXC_ABS_PEND_APPR_WARNING',
3555: NULL,
3556: hxc_timecard.c_warning);
3557: EXIT;
3558: END IF;
3559: END LOOP;
3560:

Line 3586: hxc_timecard.c_warning);

3582: ELSE
3583: add_error_to_tc(p_messages,
3584: 'HXC_ABS_PEND_CONF_WARNING',
3585: NULL,
3586: hxc_timecard.c_warning);
3587: EXIT;
3588: END IF;
3589: END LOOP;
3590:

Line 3947: l_val_level := hxc_timecard.c_error;

3943:
3944:
3945: IF l_hr_val_action = 'ERROR'
3946: THEN
3947: l_val_level := hxc_timecard.c_error;
3948: ELSIF l_hr_val_action = 'WARNING'
3949: THEN
3950: l_val_level := hxc_timecard.c_warning;
3951: END IF;

Line 3950: l_val_level := hxc_timecard.c_warning;

3946: THEN
3947: l_val_level := hxc_timecard.c_error;
3948: ELSIF l_hr_val_action = 'WARNING'
3949: THEN
3950: l_val_level := hxc_timecard.c_warning;
3951: END IF;
3952:
3953:
3954: IF l_usertab.COUNT > 0