APPS.BEN_CWB_PERSON_GROUPS_API dependencies on HR_API

Line 115: when hr_api.cannot_find_prog_unit then

111: ,p_submit_date => p_submit_date
112: ,p_submit_comments => p_submit_comments
113: );
114: exception
115: when hr_api.cannot_find_prog_unit then
116: hr_api.cannot_find_prog_unit_error
117: (p_module_name => 'create_group_budget'
118: ,p_hook_type => 'BP'
119: );

Line 116: hr_api.cannot_find_prog_unit_error

112: ,p_submit_comments => p_submit_comments
113: );
114: exception
115: when hr_api.cannot_find_prog_unit then
116: hr_api.cannot_find_prog_unit_error
117: (p_module_name => 'create_group_budget'
118: ,p_hook_type => 'BP'
119: );
120: end;

Line 208: when hr_api.cannot_find_prog_unit then

204: ,p_submit_comments => p_submit_comments
205: ,p_object_version_number => l_object_version_number
206: );
207: exception
208: when hr_api.cannot_find_prog_unit then
209: hr_api.cannot_find_prog_unit_error
210: (p_module_name => 'create_group_budget'
211: ,p_hook_type => 'AP'
212: );

Line 209: hr_api.cannot_find_prog_unit_error

205: ,p_object_version_number => l_object_version_number
206: );
207: exception
208: when hr_api.cannot_find_prog_unit then
209: hr_api.cannot_find_prog_unit_error
210: (p_module_name => 'create_group_budget'
211: ,p_hook_type => 'AP'
212: );
213: end;

Line 218: raise hr_api.validate_enabled;

214: --
215: -- When in validation only mode raise the Validate_Enabled exception
216: --
217: if p_validate then
218: raise hr_api.validate_enabled;
219: end if;
220: --
221: -- Set all IN OUT and OUT parameters with out values
222: --

Line 229: when hr_api.validate_enabled then

225: if g_debug then
226: hr_utility.set_location(' Leaving:'||l_proc, 70);
227: end if;
228: exception
229: when hr_api.validate_enabled then
230: --
231: -- As the Validate_Enabled exception has been raised
232: -- we must rollback to the savepoint
233: --

Line 288: if (p_val is not null and p_val <> hr_api.g_number and

284: if g_debug then
285: hr_utility.set_location(l_proc, 20);
286: end if;
287: --
288: if (p_val is not null and p_val <> hr_api.g_number and
289: p_min_val is not null) then
290: if (p_val < p_min_val) then
291: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
292: fnd_message.set_token('VAL',p_val);

Line 304: if (p_iss_val is not null and p_iss_val <> hr_api.g_number and

300: if g_debug then
301: hr_utility.set_location(l_proc, 30);
302: end if;
303: --
304: if (p_iss_val is not null and p_iss_val <> hr_api.g_number and
305: p_min_val is not null) then
306: if (p_iss_val < p_min_val) then
307: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
308: fnd_message.set_token('VAL',p_iss_val);

Line 320: if (p_val is not null and p_val <> hr_api.g_number and

316: if g_debug then
317: hr_utility.set_location(l_proc, 40);
318: end if;
319: --
320: if (p_val is not null and p_val <> hr_api.g_number and
321: p_max_val is not null) then
322: if (p_val > p_max_val) then
323: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
324: fnd_message.set_token('VAL',p_val);

Line 336: if (p_iss_val is not null and p_iss_val <> hr_api.g_number and

332: if g_debug then
333: hr_utility.set_location(l_proc, 50);
334: end if;
335: --
336: if (p_iss_val is not null and p_iss_val <> hr_api.g_number and
337: p_max_val is not null) then
338: if (p_iss_val > p_max_val) then
339: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
340: fnd_message.set_token('VAL',p_iss_val);

Line 352: if (p_val is not null and p_val <> hr_api.g_number and

348: if g_debug then
349: hr_utility.set_location(l_proc, 60);
350: end if;
351: --
352: if (p_val is not null and p_val <> hr_api.g_number and
353: p_incr_val is not null) then
354: if (mod(p_val,p_incr_val) <> 0) then
355: fnd_message.set_name('BEN','BEN_92985_CWB_VAL_NOT_INCRMNT');
356: fnd_message.set_token('VAL',p_val);

Line 366: if (p_iss_val is not null and p_iss_val <> hr_api.g_number and

362: if g_debug then
363: hr_utility.set_location(l_proc, 70);
364: end if;
365: --
366: if (p_iss_val is not null and p_iss_val <> hr_api.g_number and
367: p_incr_val is not null) then
368: if (mod(p_iss_val,p_incr_val) <> 0) then
369: fnd_message.set_name('BEN','BEN_92985_CWB_VAL_NOT_INCRMNT');
370: fnd_message.set_token('VAL',p_iss_val);

Line 441: if p_dist_bdgt_val = hr_api.g_number then

437: return;
438: end if;
439: --
440: -- set the parameters to old values if they are default values.
441: if p_dist_bdgt_val = hr_api.g_number then
442: l_dist_bdgt_val := p_grp_bdgt_old.dist_bdgt_val;
443: else
444: l_dist_bdgt_val := p_dist_bdgt_val;
445: end if;

Line 446: if p_ws_bdgt_val = hr_api.g_number then

442: l_dist_bdgt_val := p_grp_bdgt_old.dist_bdgt_val;
443: else
444: l_dist_bdgt_val := p_dist_bdgt_val;
445: end if;
446: if p_ws_bdgt_val = hr_api.g_number then
447: l_ws_bdgt_val := p_grp_bdgt_old.ws_bdgt_val;
448: else
449: l_ws_bdgt_val := p_ws_bdgt_val;
450: end if;

Line 451: if p_dist_bdgt_iss_val = hr_api.g_number then

447: l_ws_bdgt_val := p_grp_bdgt_old.ws_bdgt_val;
448: else
449: l_ws_bdgt_val := p_ws_bdgt_val;
450: end if;
451: if p_dist_bdgt_iss_val = hr_api.g_number then
452: l_dist_bdgt_iss_val := p_grp_bdgt_old.dist_bdgt_iss_val;
453: else
454: l_dist_bdgt_iss_val := p_dist_bdgt_iss_val;
455: end if;

Line 456: if p_ws_bdgt_iss_val = hr_api.g_number then

452: l_dist_bdgt_iss_val := p_grp_bdgt_old.dist_bdgt_iss_val;
453: else
454: l_dist_bdgt_iss_val := p_dist_bdgt_iss_val;
455: end if;
456: if p_ws_bdgt_iss_val = hr_api.g_number then
457: l_ws_bdgt_iss_val := p_grp_bdgt_old.ws_bdgt_iss_val;
458: else
459: l_ws_bdgt_iss_val := p_ws_bdgt_iss_val;
460: end if;

Line 1006: ,p_lf_evt_ocrd_dt in date default hr_api.g_date

1002: (p_validate in boolean default false
1003: ,p_group_per_in_ler_id in number
1004: ,p_group_pl_id in number
1005: ,p_group_oipl_id in number
1006: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
1007: ,p_bdgt_pop_cd in varchar2 default hr_api.g_varchar2
1008: ,p_due_dt in date default hr_api.g_date
1009: ,p_access_cd in varchar2 default hr_api.g_varchar2
1010: ,p_approval_cd in varchar2 default hr_api.g_varchar2

Line 1007: ,p_bdgt_pop_cd in varchar2 default hr_api.g_varchar2

1003: ,p_group_per_in_ler_id in number
1004: ,p_group_pl_id in number
1005: ,p_group_oipl_id in number
1006: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
1007: ,p_bdgt_pop_cd in varchar2 default hr_api.g_varchar2
1008: ,p_due_dt in date default hr_api.g_date
1009: ,p_access_cd in varchar2 default hr_api.g_varchar2
1010: ,p_approval_cd in varchar2 default hr_api.g_varchar2
1011: ,p_approval_date in date default hr_api.g_date

Line 1008: ,p_due_dt in date default hr_api.g_date

1004: ,p_group_pl_id in number
1005: ,p_group_oipl_id in number
1006: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
1007: ,p_bdgt_pop_cd in varchar2 default hr_api.g_varchar2
1008: ,p_due_dt in date default hr_api.g_date
1009: ,p_access_cd in varchar2 default hr_api.g_varchar2
1010: ,p_approval_cd in varchar2 default hr_api.g_varchar2
1011: ,p_approval_date in date default hr_api.g_date
1012: ,p_approval_comments in varchar2 default hr_api.g_varchar2

Line 1009: ,p_access_cd in varchar2 default hr_api.g_varchar2

1005: ,p_group_oipl_id in number
1006: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
1007: ,p_bdgt_pop_cd in varchar2 default hr_api.g_varchar2
1008: ,p_due_dt in date default hr_api.g_date
1009: ,p_access_cd in varchar2 default hr_api.g_varchar2
1010: ,p_approval_cd in varchar2 default hr_api.g_varchar2
1011: ,p_approval_date in date default hr_api.g_date
1012: ,p_approval_comments in varchar2 default hr_api.g_varchar2
1013: ,p_dist_bdgt_val in number default hr_api.g_number

Line 1010: ,p_approval_cd in varchar2 default hr_api.g_varchar2

1006: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
1007: ,p_bdgt_pop_cd in varchar2 default hr_api.g_varchar2
1008: ,p_due_dt in date default hr_api.g_date
1009: ,p_access_cd in varchar2 default hr_api.g_varchar2
1010: ,p_approval_cd in varchar2 default hr_api.g_varchar2
1011: ,p_approval_date in date default hr_api.g_date
1012: ,p_approval_comments in varchar2 default hr_api.g_varchar2
1013: ,p_dist_bdgt_val in number default hr_api.g_number
1014: ,p_ws_bdgt_val in number default hr_api.g_number

Line 1011: ,p_approval_date in date default hr_api.g_date

1007: ,p_bdgt_pop_cd in varchar2 default hr_api.g_varchar2
1008: ,p_due_dt in date default hr_api.g_date
1009: ,p_access_cd in varchar2 default hr_api.g_varchar2
1010: ,p_approval_cd in varchar2 default hr_api.g_varchar2
1011: ,p_approval_date in date default hr_api.g_date
1012: ,p_approval_comments in varchar2 default hr_api.g_varchar2
1013: ,p_dist_bdgt_val in number default hr_api.g_number
1014: ,p_ws_bdgt_val in number default hr_api.g_number
1015: ,p_rsrv_val in number default hr_api.g_number

Line 1012: ,p_approval_comments in varchar2 default hr_api.g_varchar2

1008: ,p_due_dt in date default hr_api.g_date
1009: ,p_access_cd in varchar2 default hr_api.g_varchar2
1010: ,p_approval_cd in varchar2 default hr_api.g_varchar2
1011: ,p_approval_date in date default hr_api.g_date
1012: ,p_approval_comments in varchar2 default hr_api.g_varchar2
1013: ,p_dist_bdgt_val in number default hr_api.g_number
1014: ,p_ws_bdgt_val in number default hr_api.g_number
1015: ,p_rsrv_val in number default hr_api.g_number
1016: ,p_dist_bdgt_mn_val in number default hr_api.g_number

Line 1013: ,p_dist_bdgt_val in number default hr_api.g_number

1009: ,p_access_cd in varchar2 default hr_api.g_varchar2
1010: ,p_approval_cd in varchar2 default hr_api.g_varchar2
1011: ,p_approval_date in date default hr_api.g_date
1012: ,p_approval_comments in varchar2 default hr_api.g_varchar2
1013: ,p_dist_bdgt_val in number default hr_api.g_number
1014: ,p_ws_bdgt_val in number default hr_api.g_number
1015: ,p_rsrv_val in number default hr_api.g_number
1016: ,p_dist_bdgt_mn_val in number default hr_api.g_number
1017: ,p_dist_bdgt_mx_val in number default hr_api.g_number

Line 1014: ,p_ws_bdgt_val in number default hr_api.g_number

1010: ,p_approval_cd in varchar2 default hr_api.g_varchar2
1011: ,p_approval_date in date default hr_api.g_date
1012: ,p_approval_comments in varchar2 default hr_api.g_varchar2
1013: ,p_dist_bdgt_val in number default hr_api.g_number
1014: ,p_ws_bdgt_val in number default hr_api.g_number
1015: ,p_rsrv_val in number default hr_api.g_number
1016: ,p_dist_bdgt_mn_val in number default hr_api.g_number
1017: ,p_dist_bdgt_mx_val in number default hr_api.g_number
1018: ,p_dist_bdgt_incr_val in number default hr_api.g_number

Line 1015: ,p_rsrv_val in number default hr_api.g_number

1011: ,p_approval_date in date default hr_api.g_date
1012: ,p_approval_comments in varchar2 default hr_api.g_varchar2
1013: ,p_dist_bdgt_val in number default hr_api.g_number
1014: ,p_ws_bdgt_val in number default hr_api.g_number
1015: ,p_rsrv_val in number default hr_api.g_number
1016: ,p_dist_bdgt_mn_val in number default hr_api.g_number
1017: ,p_dist_bdgt_mx_val in number default hr_api.g_number
1018: ,p_dist_bdgt_incr_val in number default hr_api.g_number
1019: ,p_ws_bdgt_mn_val in number default hr_api.g_number

Line 1016: ,p_dist_bdgt_mn_val in number default hr_api.g_number

1012: ,p_approval_comments in varchar2 default hr_api.g_varchar2
1013: ,p_dist_bdgt_val in number default hr_api.g_number
1014: ,p_ws_bdgt_val in number default hr_api.g_number
1015: ,p_rsrv_val in number default hr_api.g_number
1016: ,p_dist_bdgt_mn_val in number default hr_api.g_number
1017: ,p_dist_bdgt_mx_val in number default hr_api.g_number
1018: ,p_dist_bdgt_incr_val in number default hr_api.g_number
1019: ,p_ws_bdgt_mn_val in number default hr_api.g_number
1020: ,p_ws_bdgt_mx_val in number default hr_api.g_number

Line 1017: ,p_dist_bdgt_mx_val in number default hr_api.g_number

1013: ,p_dist_bdgt_val in number default hr_api.g_number
1014: ,p_ws_bdgt_val in number default hr_api.g_number
1015: ,p_rsrv_val in number default hr_api.g_number
1016: ,p_dist_bdgt_mn_val in number default hr_api.g_number
1017: ,p_dist_bdgt_mx_val in number default hr_api.g_number
1018: ,p_dist_bdgt_incr_val in number default hr_api.g_number
1019: ,p_ws_bdgt_mn_val in number default hr_api.g_number
1020: ,p_ws_bdgt_mx_val in number default hr_api.g_number
1021: ,p_ws_bdgt_incr_val in number default hr_api.g_number

Line 1018: ,p_dist_bdgt_incr_val in number default hr_api.g_number

1014: ,p_ws_bdgt_val in number default hr_api.g_number
1015: ,p_rsrv_val in number default hr_api.g_number
1016: ,p_dist_bdgt_mn_val in number default hr_api.g_number
1017: ,p_dist_bdgt_mx_val in number default hr_api.g_number
1018: ,p_dist_bdgt_incr_val in number default hr_api.g_number
1019: ,p_ws_bdgt_mn_val in number default hr_api.g_number
1020: ,p_ws_bdgt_mx_val in number default hr_api.g_number
1021: ,p_ws_bdgt_incr_val in number default hr_api.g_number
1022: ,p_rsrv_mn_val in number default hr_api.g_number

Line 1019: ,p_ws_bdgt_mn_val in number default hr_api.g_number

1015: ,p_rsrv_val in number default hr_api.g_number
1016: ,p_dist_bdgt_mn_val in number default hr_api.g_number
1017: ,p_dist_bdgt_mx_val in number default hr_api.g_number
1018: ,p_dist_bdgt_incr_val in number default hr_api.g_number
1019: ,p_ws_bdgt_mn_val in number default hr_api.g_number
1020: ,p_ws_bdgt_mx_val in number default hr_api.g_number
1021: ,p_ws_bdgt_incr_val in number default hr_api.g_number
1022: ,p_rsrv_mn_val in number default hr_api.g_number
1023: ,p_rsrv_mx_val in number default hr_api.g_number

Line 1020: ,p_ws_bdgt_mx_val in number default hr_api.g_number

1016: ,p_dist_bdgt_mn_val in number default hr_api.g_number
1017: ,p_dist_bdgt_mx_val in number default hr_api.g_number
1018: ,p_dist_bdgt_incr_val in number default hr_api.g_number
1019: ,p_ws_bdgt_mn_val in number default hr_api.g_number
1020: ,p_ws_bdgt_mx_val in number default hr_api.g_number
1021: ,p_ws_bdgt_incr_val in number default hr_api.g_number
1022: ,p_rsrv_mn_val in number default hr_api.g_number
1023: ,p_rsrv_mx_val in number default hr_api.g_number
1024: ,p_rsrv_incr_val in number default hr_api.g_number

Line 1021: ,p_ws_bdgt_incr_val in number default hr_api.g_number

1017: ,p_dist_bdgt_mx_val in number default hr_api.g_number
1018: ,p_dist_bdgt_incr_val in number default hr_api.g_number
1019: ,p_ws_bdgt_mn_val in number default hr_api.g_number
1020: ,p_ws_bdgt_mx_val in number default hr_api.g_number
1021: ,p_ws_bdgt_incr_val in number default hr_api.g_number
1022: ,p_rsrv_mn_val in number default hr_api.g_number
1023: ,p_rsrv_mx_val in number default hr_api.g_number
1024: ,p_rsrv_incr_val in number default hr_api.g_number
1025: ,p_dist_bdgt_iss_val in number default hr_api.g_number

Line 1022: ,p_rsrv_mn_val in number default hr_api.g_number

1018: ,p_dist_bdgt_incr_val in number default hr_api.g_number
1019: ,p_ws_bdgt_mn_val in number default hr_api.g_number
1020: ,p_ws_bdgt_mx_val in number default hr_api.g_number
1021: ,p_ws_bdgt_incr_val in number default hr_api.g_number
1022: ,p_rsrv_mn_val in number default hr_api.g_number
1023: ,p_rsrv_mx_val in number default hr_api.g_number
1024: ,p_rsrv_incr_val in number default hr_api.g_number
1025: ,p_dist_bdgt_iss_val in number default hr_api.g_number
1026: ,p_ws_bdgt_iss_val in number default hr_api.g_number

Line 1023: ,p_rsrv_mx_val in number default hr_api.g_number

1019: ,p_ws_bdgt_mn_val in number default hr_api.g_number
1020: ,p_ws_bdgt_mx_val in number default hr_api.g_number
1021: ,p_ws_bdgt_incr_val in number default hr_api.g_number
1022: ,p_rsrv_mn_val in number default hr_api.g_number
1023: ,p_rsrv_mx_val in number default hr_api.g_number
1024: ,p_rsrv_incr_val in number default hr_api.g_number
1025: ,p_dist_bdgt_iss_val in number default hr_api.g_number
1026: ,p_ws_bdgt_iss_val in number default hr_api.g_number
1027: ,p_dist_bdgt_iss_date in date default hr_api.g_date

Line 1024: ,p_rsrv_incr_val in number default hr_api.g_number

1020: ,p_ws_bdgt_mx_val in number default hr_api.g_number
1021: ,p_ws_bdgt_incr_val in number default hr_api.g_number
1022: ,p_rsrv_mn_val in number default hr_api.g_number
1023: ,p_rsrv_mx_val in number default hr_api.g_number
1024: ,p_rsrv_incr_val in number default hr_api.g_number
1025: ,p_dist_bdgt_iss_val in number default hr_api.g_number
1026: ,p_ws_bdgt_iss_val in number default hr_api.g_number
1027: ,p_dist_bdgt_iss_date in date default hr_api.g_date
1028: ,p_ws_bdgt_iss_date in date default hr_api.g_date

Line 1025: ,p_dist_bdgt_iss_val in number default hr_api.g_number

1021: ,p_ws_bdgt_incr_val in number default hr_api.g_number
1022: ,p_rsrv_mn_val in number default hr_api.g_number
1023: ,p_rsrv_mx_val in number default hr_api.g_number
1024: ,p_rsrv_incr_val in number default hr_api.g_number
1025: ,p_dist_bdgt_iss_val in number default hr_api.g_number
1026: ,p_ws_bdgt_iss_val in number default hr_api.g_number
1027: ,p_dist_bdgt_iss_date in date default hr_api.g_date
1028: ,p_ws_bdgt_iss_date in date default hr_api.g_date
1029: ,p_ws_bdgt_val_last_upd_date in date default hr_api.g_date

Line 1026: ,p_ws_bdgt_iss_val in number default hr_api.g_number

1022: ,p_rsrv_mn_val in number default hr_api.g_number
1023: ,p_rsrv_mx_val in number default hr_api.g_number
1024: ,p_rsrv_incr_val in number default hr_api.g_number
1025: ,p_dist_bdgt_iss_val in number default hr_api.g_number
1026: ,p_ws_bdgt_iss_val in number default hr_api.g_number
1027: ,p_dist_bdgt_iss_date in date default hr_api.g_date
1028: ,p_ws_bdgt_iss_date in date default hr_api.g_date
1029: ,p_ws_bdgt_val_last_upd_date in date default hr_api.g_date
1030: ,p_dist_bdgt_val_last_upd_date in date default hr_api.g_date

Line 1027: ,p_dist_bdgt_iss_date in date default hr_api.g_date

1023: ,p_rsrv_mx_val in number default hr_api.g_number
1024: ,p_rsrv_incr_val in number default hr_api.g_number
1025: ,p_dist_bdgt_iss_val in number default hr_api.g_number
1026: ,p_ws_bdgt_iss_val in number default hr_api.g_number
1027: ,p_dist_bdgt_iss_date in date default hr_api.g_date
1028: ,p_ws_bdgt_iss_date in date default hr_api.g_date
1029: ,p_ws_bdgt_val_last_upd_date in date default hr_api.g_date
1030: ,p_dist_bdgt_val_last_upd_date in date default hr_api.g_date
1031: ,p_rsrv_val_last_upd_date in date default hr_api.g_date

Line 1028: ,p_ws_bdgt_iss_date in date default hr_api.g_date

1024: ,p_rsrv_incr_val in number default hr_api.g_number
1025: ,p_dist_bdgt_iss_val in number default hr_api.g_number
1026: ,p_ws_bdgt_iss_val in number default hr_api.g_number
1027: ,p_dist_bdgt_iss_date in date default hr_api.g_date
1028: ,p_ws_bdgt_iss_date in date default hr_api.g_date
1029: ,p_ws_bdgt_val_last_upd_date in date default hr_api.g_date
1030: ,p_dist_bdgt_val_last_upd_date in date default hr_api.g_date
1031: ,p_rsrv_val_last_upd_date in date default hr_api.g_date
1032: ,p_ws_bdgt_val_last_upd_by in number default hr_api.g_number

Line 1029: ,p_ws_bdgt_val_last_upd_date in date default hr_api.g_date

1025: ,p_dist_bdgt_iss_val in number default hr_api.g_number
1026: ,p_ws_bdgt_iss_val in number default hr_api.g_number
1027: ,p_dist_bdgt_iss_date in date default hr_api.g_date
1028: ,p_ws_bdgt_iss_date in date default hr_api.g_date
1029: ,p_ws_bdgt_val_last_upd_date in date default hr_api.g_date
1030: ,p_dist_bdgt_val_last_upd_date in date default hr_api.g_date
1031: ,p_rsrv_val_last_upd_date in date default hr_api.g_date
1032: ,p_ws_bdgt_val_last_upd_by in number default hr_api.g_number
1033: ,p_dist_bdgt_val_last_upd_by in number default hr_api.g_number

Line 1030: ,p_dist_bdgt_val_last_upd_date in date default hr_api.g_date

1026: ,p_ws_bdgt_iss_val in number default hr_api.g_number
1027: ,p_dist_bdgt_iss_date in date default hr_api.g_date
1028: ,p_ws_bdgt_iss_date in date default hr_api.g_date
1029: ,p_ws_bdgt_val_last_upd_date in date default hr_api.g_date
1030: ,p_dist_bdgt_val_last_upd_date in date default hr_api.g_date
1031: ,p_rsrv_val_last_upd_date in date default hr_api.g_date
1032: ,p_ws_bdgt_val_last_upd_by in number default hr_api.g_number
1033: ,p_dist_bdgt_val_last_upd_by in number default hr_api.g_number
1034: ,p_rsrv_val_last_upd_by in number default hr_api.g_number

Line 1031: ,p_rsrv_val_last_upd_date in date default hr_api.g_date

1027: ,p_dist_bdgt_iss_date in date default hr_api.g_date
1028: ,p_ws_bdgt_iss_date in date default hr_api.g_date
1029: ,p_ws_bdgt_val_last_upd_date in date default hr_api.g_date
1030: ,p_dist_bdgt_val_last_upd_date in date default hr_api.g_date
1031: ,p_rsrv_val_last_upd_date in date default hr_api.g_date
1032: ,p_ws_bdgt_val_last_upd_by in number default hr_api.g_number
1033: ,p_dist_bdgt_val_last_upd_by in number default hr_api.g_number
1034: ,p_rsrv_val_last_upd_by in number default hr_api.g_number
1035: ,p_submit_cd in varchar2 default hr_api.g_varchar2

Line 1032: ,p_ws_bdgt_val_last_upd_by in number default hr_api.g_number

1028: ,p_ws_bdgt_iss_date in date default hr_api.g_date
1029: ,p_ws_bdgt_val_last_upd_date in date default hr_api.g_date
1030: ,p_dist_bdgt_val_last_upd_date in date default hr_api.g_date
1031: ,p_rsrv_val_last_upd_date in date default hr_api.g_date
1032: ,p_ws_bdgt_val_last_upd_by in number default hr_api.g_number
1033: ,p_dist_bdgt_val_last_upd_by in number default hr_api.g_number
1034: ,p_rsrv_val_last_upd_by in number default hr_api.g_number
1035: ,p_submit_cd in varchar2 default hr_api.g_varchar2
1036: ,p_submit_date in date default hr_api.g_date

Line 1033: ,p_dist_bdgt_val_last_upd_by in number default hr_api.g_number

1029: ,p_ws_bdgt_val_last_upd_date in date default hr_api.g_date
1030: ,p_dist_bdgt_val_last_upd_date in date default hr_api.g_date
1031: ,p_rsrv_val_last_upd_date in date default hr_api.g_date
1032: ,p_ws_bdgt_val_last_upd_by in number default hr_api.g_number
1033: ,p_dist_bdgt_val_last_upd_by in number default hr_api.g_number
1034: ,p_rsrv_val_last_upd_by in number default hr_api.g_number
1035: ,p_submit_cd in varchar2 default hr_api.g_varchar2
1036: ,p_submit_date in date default hr_api.g_date
1037: ,p_submit_comments in varchar2 default hr_api.g_varchar2

Line 1034: ,p_rsrv_val_last_upd_by in number default hr_api.g_number

1030: ,p_dist_bdgt_val_last_upd_date in date default hr_api.g_date
1031: ,p_rsrv_val_last_upd_date in date default hr_api.g_date
1032: ,p_ws_bdgt_val_last_upd_by in number default hr_api.g_number
1033: ,p_dist_bdgt_val_last_upd_by in number default hr_api.g_number
1034: ,p_rsrv_val_last_upd_by in number default hr_api.g_number
1035: ,p_submit_cd in varchar2 default hr_api.g_varchar2
1036: ,p_submit_date in date default hr_api.g_date
1037: ,p_submit_comments in varchar2 default hr_api.g_varchar2
1038: ,p_perf_min_max_edit in varchar2 default 'Y'

Line 1035: ,p_submit_cd in varchar2 default hr_api.g_varchar2

1031: ,p_rsrv_val_last_upd_date in date default hr_api.g_date
1032: ,p_ws_bdgt_val_last_upd_by in number default hr_api.g_number
1033: ,p_dist_bdgt_val_last_upd_by in number default hr_api.g_number
1034: ,p_rsrv_val_last_upd_by in number default hr_api.g_number
1035: ,p_submit_cd in varchar2 default hr_api.g_varchar2
1036: ,p_submit_date in date default hr_api.g_date
1037: ,p_submit_comments in varchar2 default hr_api.g_varchar2
1038: ,p_perf_min_max_edit in varchar2 default 'Y'
1039: ,p_object_version_number in out nocopy number

Line 1036: ,p_submit_date in date default hr_api.g_date

1032: ,p_ws_bdgt_val_last_upd_by in number default hr_api.g_number
1033: ,p_dist_bdgt_val_last_upd_by in number default hr_api.g_number
1034: ,p_rsrv_val_last_upd_by in number default hr_api.g_number
1035: ,p_submit_cd in varchar2 default hr_api.g_varchar2
1036: ,p_submit_date in date default hr_api.g_date
1037: ,p_submit_comments in varchar2 default hr_api.g_varchar2
1038: ,p_perf_min_max_edit in varchar2 default 'Y'
1039: ,p_object_version_number in out nocopy number
1040: ) is

Line 1037: ,p_submit_comments in varchar2 default hr_api.g_varchar2

1033: ,p_dist_bdgt_val_last_upd_by in number default hr_api.g_number
1034: ,p_rsrv_val_last_upd_by in number default hr_api.g_number
1035: ,p_submit_cd in varchar2 default hr_api.g_varchar2
1036: ,p_submit_date in date default hr_api.g_date
1037: ,p_submit_comments in varchar2 default hr_api.g_varchar2
1038: ,p_perf_min_max_edit in varchar2 default 'Y'
1039: ,p_object_version_number in out nocopy number
1040: ) is
1041: --

Line 1128: when hr_api.cannot_find_prog_unit then

1124: ,p_submit_comments => p_submit_comments
1125: ,p_object_version_number => l_object_version_number
1126: );
1127: exception
1128: when hr_api.cannot_find_prog_unit then
1129: hr_api.cannot_find_prog_unit_error
1130: (p_module_name => 'update_group_budget'
1131: ,p_hook_type => 'BP'
1132: );

Line 1129: hr_api.cannot_find_prog_unit_error

1125: ,p_object_version_number => l_object_version_number
1126: );
1127: exception
1128: when hr_api.cannot_find_prog_unit then
1129: hr_api.cannot_find_prog_unit_error
1130: (p_module_name => 'update_group_budget'
1131: ,p_hook_type => 'BP'
1132: );
1133: end;

Line 1147: p_dist_bdgt_mx_val <> hr_api.g_number) then

1143: fetch csr_mn_mx_vals into l_mn_mx_vals;
1144: close csr_mn_mx_vals;
1145: --
1146: if (p_dist_bdgt_mx_val is null or
1147: p_dist_bdgt_mx_val <> hr_api.g_number) then
1148: l_mn_mx_vals.dist_bdgt_mx_val := p_dist_bdgt_mx_val;
1149: end if;
1150: --
1151: if (p_dist_bdgt_mn_val is null or

Line 1152: p_dist_bdgt_mn_val <> hr_api.g_number) then

1148: l_mn_mx_vals.dist_bdgt_mx_val := p_dist_bdgt_mx_val;
1149: end if;
1150: --
1151: if (p_dist_bdgt_mn_val is null or
1152: p_dist_bdgt_mn_val <> hr_api.g_number) then
1153: l_mn_mx_vals.dist_bdgt_mn_val := p_dist_bdgt_mn_val;
1154: end if;
1155: --
1156: if (p_dist_bdgt_incr_val is null or

Line 1157: p_dist_bdgt_incr_val <> hr_api.g_number) then

1153: l_mn_mx_vals.dist_bdgt_mn_val := p_dist_bdgt_mn_val;
1154: end if;
1155: --
1156: if (p_dist_bdgt_incr_val is null or
1157: p_dist_bdgt_incr_val <> hr_api.g_number) then
1158: l_mn_mx_vals.dist_bdgt_incr_val := p_dist_bdgt_incr_val;
1159: end if;
1160: --
1161: --

Line 1167: p_ws_bdgt_mx_val <> hr_api.g_number) then

1163: hr_utility.set_location(l_proc, 30);
1164: end if;
1165: --
1166: if (p_ws_bdgt_mx_val is null or
1167: p_ws_bdgt_mx_val <> hr_api.g_number) then
1168: l_mn_mx_vals.ws_bdgt_mx_val := p_ws_bdgt_mx_val;
1169: end if;
1170: --
1171: if (p_ws_bdgt_mn_val is null or

Line 1172: p_ws_bdgt_mn_val <> hr_api.g_number) then

1168: l_mn_mx_vals.ws_bdgt_mx_val := p_ws_bdgt_mx_val;
1169: end if;
1170: --
1171: if (p_ws_bdgt_mn_val is null or
1172: p_ws_bdgt_mn_val <> hr_api.g_number) then
1173: l_mn_mx_vals.ws_bdgt_mn_val := p_ws_bdgt_mn_val;
1174: end if;
1175: --
1176: if (p_ws_bdgt_incr_val is null or

Line 1177: p_ws_bdgt_incr_val <> hr_api.g_number) then

1173: l_mn_mx_vals.ws_bdgt_mn_val := p_ws_bdgt_mn_val;
1174: end if;
1175: --
1176: if (p_ws_bdgt_incr_val is null or
1177: p_ws_bdgt_incr_val <> hr_api.g_number) then
1178: l_mn_mx_vals.ws_bdgt_incr_val := p_ws_bdgt_incr_val;
1179: end if;
1180: --
1181: if g_debug then

Line 1215: p_rsrv_val <> hr_api.g_number and

1211: --
1212: end if; -- of p_perf_min_max_edit
1213: --
1214: if p_rsrv_val is not null and
1215: p_rsrv_val <> hr_api.g_number and
1216: p_rsrv_val <> nvl(l_grp_bdgt_old.rsrv_val, hr_api.g_number) then
1217: --
1218: if l_mn_mx_vals.group_per_in_ler_id is null then
1219: open csr_mn_mx_vals;

Line 1216: p_rsrv_val <> nvl(l_grp_bdgt_old.rsrv_val, hr_api.g_number) then

1212: end if; -- of p_perf_min_max_edit
1213: --
1214: if p_rsrv_val is not null and
1215: p_rsrv_val <> hr_api.g_number and
1216: p_rsrv_val <> nvl(l_grp_bdgt_old.rsrv_val, hr_api.g_number) then
1217: --
1218: if l_mn_mx_vals.group_per_in_ler_id is null then
1219: open csr_mn_mx_vals;
1220: fetch csr_mn_mx_vals into l_mn_mx_vals;

Line 1225: p_rsrv_mx_val <> hr_api.g_number) then

1221: close csr_mn_mx_vals;
1222: end if;
1223: --
1224: if (p_rsrv_mx_val is null or
1225: p_rsrv_mx_val <> hr_api.g_number) then
1226: l_mn_mx_vals.rsrv_mx_val := p_rsrv_mx_val;
1227: end if;
1228: --
1229: if (p_rsrv_mn_val is null or

Line 1230: p_rsrv_mn_val <> hr_api.g_number) then

1226: l_mn_mx_vals.rsrv_mx_val := p_rsrv_mx_val;
1227: end if;
1228: --
1229: if (p_rsrv_mn_val is null or
1230: p_rsrv_mn_val <> hr_api.g_number) then
1231: l_mn_mx_vals.rsrv_mn_val := p_rsrv_mn_val;
1232: end if;
1233: --
1234: if (p_rsrv_incr_val is null or

Line 1235: p_rsrv_incr_val <> hr_api.g_number) then

1231: l_mn_mx_vals.rsrv_mn_val := p_rsrv_mn_val;
1232: end if;
1233: --
1234: if (p_rsrv_incr_val is null or
1235: p_rsrv_incr_val <> hr_api.g_number) then
1236: l_mn_mx_vals.rsrv_incr_val := p_rsrv_incr_val;
1237: end if;
1238: --
1239: -- Check Min, Max and Inc for Rsrv Val

Line 1333: when hr_api.cannot_find_prog_unit then

1329: ,p_submit_comments => p_submit_comments
1330: ,p_object_version_number => l_object_version_number
1331: );
1332: exception
1333: when hr_api.cannot_find_prog_unit then
1334: hr_api.cannot_find_prog_unit_error
1335: (p_module_name => 'update_group_budget'
1336: ,p_hook_type => 'AP'
1337: );

Line 1334: hr_api.cannot_find_prog_unit_error

1330: ,p_object_version_number => l_object_version_number
1331: );
1332: exception
1333: when hr_api.cannot_find_prog_unit then
1334: hr_api.cannot_find_prog_unit_error
1335: (p_module_name => 'update_group_budget'
1336: ,p_hook_type => 'AP'
1337: );
1338: end;

Line 1343: raise hr_api.validate_enabled;

1339: --
1340: -- When in validation only mode raise the Validate_Enabled exception
1341: --
1342: if p_validate then
1343: raise hr_api.validate_enabled;
1344: end if;
1345: --
1346: -- Update is successful. So call the budget summary update.
1347: update_group_budget_summary

Line 1364: when hr_api.validate_enabled then

1360: if g_debug then
1361: hr_utility.set_location(' Leaving:'||l_proc, 80);
1362: end if;
1363: exception
1364: when hr_api.validate_enabled then
1365: --
1366: -- As the Validate_Enabled exception has been raised
1367: -- we must rollback to the savepoint
1368: --

Line 1442: when hr_api.cannot_find_prog_unit then

1438: ,p_group_oipl_id => p_group_oipl_id
1439: ,p_object_version_number => l_object_version_number
1440: );
1441: exception
1442: when hr_api.cannot_find_prog_unit then
1443: hr_api.cannot_find_prog_unit_error
1444: (p_module_name => 'delete_group_budget'
1445: ,p_hook_type => 'BP'
1446: );

Line 1443: hr_api.cannot_find_prog_unit_error

1439: ,p_object_version_number => l_object_version_number
1440: );
1441: exception
1442: when hr_api.cannot_find_prog_unit then
1443: hr_api.cannot_find_prog_unit_error
1444: (p_module_name => 'delete_group_budget'
1445: ,p_hook_type => 'BP'
1446: );
1447: end;

Line 1472: when hr_api.cannot_find_prog_unit then

1468: ,p_group_oipl_id => p_group_oipl_id
1469: ,p_object_version_number => l_object_version_number
1470: );
1471: exception
1472: when hr_api.cannot_find_prog_unit then
1473: hr_api.cannot_find_prog_unit_error
1474: (p_module_name => 'delete_group_budget'
1475: ,p_hook_type => 'AP'
1476: );

Line 1473: hr_api.cannot_find_prog_unit_error

1469: ,p_object_version_number => l_object_version_number
1470: );
1471: exception
1472: when hr_api.cannot_find_prog_unit then
1473: hr_api.cannot_find_prog_unit_error
1474: (p_module_name => 'delete_group_budget'
1475: ,p_hook_type => 'AP'
1476: );
1477: end;

Line 1482: raise hr_api.validate_enabled;

1478: --
1479: -- When in validation only mode raise the Validate_Enabled exception
1480: --
1481: if p_validate then
1482: raise hr_api.validate_enabled;
1483: end if;
1484: --
1485: -- Delete is successful. So call the budget summary update.
1486: --

Line 1500: when hr_api.validate_enabled then

1496: if g_debug then
1497: hr_utility.set_location(' Leaving:'||l_proc, 70);
1498: end if;
1499: exception
1500: when hr_api.validate_enabled then
1501: --
1502: -- As the Validate_Enabled exception has been raised
1503: -- we must rollback to the savepoint
1504: --