[Home] [Help]
47: PROCEDURE debug
48: (p_trace_number IN NUMBER )
49: IS
50: BEGIN
51: debug(fnd_number.number_to_canonical(p_trace_number));
52: END debug;
53: --
54: --
55: --
3022: ; -- allow all events upto end of day (eff_dt - 1)
3023:
3024: COMMIT;
3025: --
3026: debug(fnd_number.number_to_canonical(SQL%ROWCOUNT)||' PPE row(s) updated.');
3027: --
3028: debug_exit(l_proc_name);
3029: --
3030: EXCEPTION
3084: AND peu.event_update_id = ppe.event_update_id
3085: )
3086: ;
3087:
3088: debug(fnd_number.number_to_canonical(SQL%ROWCOUNT)||' PPE row(s) updated.');
3089:
3090: -- Now update for PAY_ELEMENT_ENTRY_VALUES_F
3091: UPDATE pay_process_events ppe
3092: SET ppe.retroactive_status = p_status
3115:
3116:
3117: COMMIT;
3118: --
3119: debug(fnd_number.number_to_canonical(SQL%ROWCOUNT)||' PPE row(s) updated.');
3120: --
3121: debug_exit(l_proc_name);
3122: --
3123: EXCEPTION
3595: ,t_proration_changes => l_proration_changes -- OUT
3596: );
3597:
3598: debug('Number of ASG_STATUS Events: '||
3599: fnd_number.number_to_canonical(l_no_of_events));
3600:
3601: l_itr := l_proration_dates.FIRST;
3602:
3603: WHILE l_itr <= l_proration_dates.LAST
3730: );
3731:
3732:
3733: debug('Number of ASG_LOCATION Events: '||
3734: fnd_number.number_to_canonical(l_no_of_events));
3735:
3736: l_itr := l_proration_dates.FIRST;
3737: WHILE l_itr <= l_proration_dates.LAST
3738: LOOP -- through location change proration dates
3907: ,t_proration_changes => l_proration_changes -- OUT
3908: );
3909:
3910: debug('Number of '||'PQP_GB_TP_ELECTED_PENSION'||' Events: '||
3911: fnd_number.number_to_canonical(l_no_of_events), 150);
3912:
3913: -- b) Loop through the events and check if any have changed.
3914: l_itr := l_proration_dates.FIRST;
3915: WHILE l_itr <= l_proration_dates.LAST
4016: ,t_proration_changes => l_proration_changes -- OUT
4017: );
4018:
4019: debug('Number of '||'PQP_GB_TP_IS_TEACHER'||' Events: '||
4020: fnd_number.number_to_canonical(l_no_of_events),210);
4021:
4022: -- b) Loop through the events and check if any have changed.
4023: l_itr := l_proration_dates.FIRST;
4024: WHILE l_itr <= l_proration_dates.LAST
4177: ,t_proration_changes => l_proration_changes -- OUT
4178: );
4179:
4180: debug('Number of ASG_STATUS Events: '||
4181: fnd_number.number_to_canonical(l_proration_dates.COUNT));
4182:
4183: l_itr := l_proration_dates.FIRST;
4184:
4185: WHILE l_itr <= l_proration_dates.LAST
4293: ,t_proration_changes => l_proration_changes -- OUT
4294: );
4295:
4296: debug('Number of ASG_LOCATION Events: '||
4297: fnd_number.number_to_canonical(l_proration_dates.COUNT));
4298:
4299: l_itr := l_proration_dates.FIRST;
4300: WHILE l_itr <= l_proration_dates.LAST
4301: LOOP -- through location change proration dates
4418: ,t_proration_changes => l_proration_changes -- OUT
4419: );
4420:
4421: debug('Number of '||'PQP_GB_TP_ELECTED_PENSION'||' Events: '||
4422: fnd_number.number_to_canonical(l_no_of_events));
4423:
4424: -- b) Loop through the events and check if any have changed.
4425: l_itr := l_proration_dates.FIRST;
4426: WHILE l_itr <= l_proration_dates.LAST
4519: ,t_proration_changes => l_proration_changes -- OUT
4520: );
4521:
4522: debug('Number of '||'PQP_GB_TP_IS_TEACHER'||' Events: '||
4523: fnd_number.number_to_canonical(l_no_of_events));
4524:
4525: -- b) Loop through the events and check if any have changed.
4526: l_itr := l_proration_dates.FIRST;
4527: WHILE l_itr <= l_proration_dates.LAST
11502: debug('Primary Asg '|| to_char(p_assignment_id)||' is not terminated', 84) ;
11503: END IF; -- l_inclusion_flag = 'Y' Bug 5408932
11504: debug('g_asg_count: '|| to_char(g_asg_count), 85) ;
11505: debug('Number of TP1 teachers on periodic report :'||
11506: fnd_number.number_to_canonical(pqp_gb_tp_pension_extracts.g_ext_asg_details.COUNT));
11507:
11508: ELSE
11509: -- Bugfix 3073562:GAP6
11510: -- Continue looking for secondary asgs
11970: ,p_must_be_a_leaver => FALSE
11971: );
11972: debug('g_asg_count: '|| to_char(g_asg_count), 65) ;
11973: debug('Number of TP1 teachers on annual report :'||
11974: fnd_number.number_to_canonical(pqp_gb_tp_pension_extracts.g_ext_asg_details.COUNT),70);
11975: --
11976: END IF; -- 2) l_inclusion_flag = 'Y' THEN
11977: --
11978: ELSE -- 1) inclusion flag is 'N'
12883: ,t_proration_changes => l_proration_changes
12884: );
12885:
12886: debug('Number of '||l_event_group||' Events: '||
12887: fnd_number.number_to_canonical(l_no_of_events), 10);
12888:
12889: -- b) Loop through the events and check if any have changed.
12890: l_itr := l_proration_dates.FIRST;
12891: WHILE l_itr <= l_proration_dates.LAST
13026: ,t_proration_changes => l_proration_changes
13027: );
13028:
13029: debug('Number of '||p_event_group||' Events: '||
13030: fnd_number.number_to_canonical(l_no_of_events), 10);
13031:
13032: -- b) Loop through the events and check if any have changed.
13033: l_itr := l_proration_dates.FIRST;
13034: WHILE l_itr <= l_proration_dates.LAST
13155: );
13156:
13157: debug('Number of '||l_event_group||' Events for Element Entry Id'||
13158: l_element_entries.element_entry_id||' : '||
13159: fnd_number.number_to_canonical(l_no_of_events), 30);
13160:
13161: -- b) Loop through the events and check if any have changed.
13162: l_itr := l_proration_dates.FIRST;
13163: WHILE l_itr <= l_proration_dates.LAST
13226: ,t_proration_changes => l_proration_changes
13227: );
13228:
13229: debug('Number of '||l_event_group||' Events : '||
13230: fnd_number.number_to_canonical(l_no_of_events), 90);
13231:
13232: -- b) Loop through the events and check if any have changed.
13233: l_itr := l_proration_dates.FIRST;
13234: WHILE l_itr <= l_proration_dates.LAST
13768: /*
13769: l_current := l_indexes_to_skip.FIRST;
13770: WHILE l_current <= l_indexes_to_skip.LAST
13771: LOOP
13772: dbms_output.put_line('Skip Index: '||fnd_number.number_to_canonical(l_current));
13773: l_current := l_indexes_to_skip.NEXT(l_current);
13774: END LOOP;
13775: */
13776: