[Home] [Help]
46: PROCEDURE debug
47: (p_trace_number IN NUMBER )
48: IS
49: BEGIN
50: debug(fnd_number.number_to_canonical(p_trace_number));
51: END debug;
52: --
53: --
54: --
3050: ; -- allow all events upto end of day (eff_dt - 1)
3051:
3052: COMMIT;
3053: --
3054: debug(fnd_number.number_to_canonical(SQL%ROWCOUNT)||' PPE row(s) updated.');
3055: --
3056: debug_exit(l_proc_name);
3057: --
3058: EXCEPTION
3112: AND peu.event_update_id = ppe.event_update_id
3113: )
3114: ;
3115:
3116: debug(fnd_number.number_to_canonical(SQL%ROWCOUNT)||' PPE row(s) updated.');
3117:
3118: -- Now update for PAY_ELEMENT_ENTRY_VALUES_F
3119: UPDATE pay_process_events ppe
3120: SET ppe.retroactive_status = p_status
3143:
3144:
3145: COMMIT;
3146: --
3147: debug(fnd_number.number_to_canonical(SQL%ROWCOUNT)||' PPE row(s) updated.');
3148: --
3149: debug_exit(l_proc_name);
3150: --
3151: EXCEPTION
3623: ,t_proration_changes => l_proration_changes -- OUT
3624: );
3625:
3626: debug('Number of ASG_STATUS Events: '||
3627: fnd_number.number_to_canonical(l_no_of_events));
3628:
3629: l_itr := l_proration_dates.FIRST;
3630:
3631: WHILE l_itr <= l_proration_dates.LAST
3758: );
3759:
3760:
3761: debug('Number of ASG_LOCATION Events: '||
3762: fnd_number.number_to_canonical(l_no_of_events));
3763:
3764: l_itr := l_proration_dates.FIRST;
3765: WHILE l_itr <= l_proration_dates.LAST
3766: LOOP -- through location change proration dates
3935: ,t_proration_changes => l_proration_changes -- OUT
3936: );
3937:
3938: debug('Number of '||'PQP_GB_TP_ELECTED_PENSION'||' Events: '||
3939: fnd_number.number_to_canonical(l_no_of_events), 150);
3940:
3941: -- b) Loop through the events and check if any have changed.
3942: l_itr := l_proration_dates.FIRST;
3943: WHILE l_itr <= l_proration_dates.LAST
4044: ,t_proration_changes => l_proration_changes -- OUT
4045: );
4046:
4047: debug('Number of '||'PQP_GB_TP_IS_TEACHER'||' Events: '||
4048: fnd_number.number_to_canonical(l_no_of_events),210);
4049:
4050: -- b) Loop through the events and check if any have changed.
4051: l_itr := l_proration_dates.FIRST;
4052: WHILE l_itr <= l_proration_dates.LAST
4205: ,t_proration_changes => l_proration_changes -- OUT
4206: );
4207:
4208: debug('Number of ASG_STATUS Events: '||
4209: fnd_number.number_to_canonical(l_proration_dates.COUNT));
4210:
4211: l_itr := l_proration_dates.FIRST;
4212:
4213: WHILE l_itr <= l_proration_dates.LAST
4321: ,t_proration_changes => l_proration_changes -- OUT
4322: );
4323:
4324: debug('Number of ASG_LOCATION Events: '||
4325: fnd_number.number_to_canonical(l_proration_dates.COUNT));
4326:
4327: l_itr := l_proration_dates.FIRST;
4328: WHILE l_itr <= l_proration_dates.LAST
4329: LOOP -- through location change proration dates
4446: ,t_proration_changes => l_proration_changes -- OUT
4447: );
4448:
4449: debug('Number of '||'PQP_GB_TP_ELECTED_PENSION'||' Events: '||
4450: fnd_number.number_to_canonical(l_no_of_events));
4451:
4452: -- b) Loop through the events and check if any have changed.
4453: l_itr := l_proration_dates.FIRST;
4454: WHILE l_itr <= l_proration_dates.LAST
4547: ,t_proration_changes => l_proration_changes -- OUT
4548: );
4549:
4550: debug('Number of '||'PQP_GB_TP_IS_TEACHER'||' Events: '||
4551: fnd_number.number_to_canonical(l_no_of_events));
4552:
4553: -- b) Loop through the events and check if any have changed.
4554: l_itr := l_proration_dates.FIRST;
4555: WHILE l_itr <= l_proration_dates.LAST
11699: debug('Primary Asg '|| to_char(p_assignment_id)||' is not terminated', 84) ;
11700: END IF; -- l_inclusion_flag = 'Y' Bug 5408932
11701: debug('g_asg_count: '|| to_char(g_asg_count), 85) ;
11702: debug('Number of TP1 teachers on periodic report :'||
11703: fnd_number.number_to_canonical(pqp_gb_tp_pension_extracts.g_ext_asg_details.COUNT));
11704:
11705: ELSE
11706: -- Bugfix 3073562:GAP6
11707: -- Continue looking for secondary asgs
12168: ,p_must_be_a_leaver => FALSE
12169: );
12170: debug('g_asg_count: '|| to_char(g_asg_count), 65) ;
12171: debug('Number of TP1 teachers on annual report :'||
12172: fnd_number.number_to_canonical(pqp_gb_tp_pension_extracts.g_ext_asg_details.COUNT),70);
12173: --
12174: END IF; -- 2) l_inclusion_flag = 'Y' THEN
12175: --
12176: ELSE -- 1) inclusion flag is 'N'
13082: ,t_proration_changes => l_proration_changes
13083: );
13084:
13085: debug('Number of '||l_event_group||' Events: '||
13086: fnd_number.number_to_canonical(l_no_of_events), 10);
13087:
13088: -- b) Loop through the events and check if any have changed.
13089: l_itr := l_proration_dates.FIRST;
13090: WHILE l_itr <= l_proration_dates.LAST
13225: ,t_proration_changes => l_proration_changes
13226: );
13227:
13228: debug('Number of '||p_event_group||' Events: '||
13229: fnd_number.number_to_canonical(l_no_of_events), 10);
13230:
13231: -- b) Loop through the events and check if any have changed.
13232: l_itr := l_proration_dates.FIRST;
13233: WHILE l_itr <= l_proration_dates.LAST
13354: );
13355:
13356: debug('Number of '||l_event_group||' Events for Element Entry Id'||
13357: l_element_entries.element_entry_id||' : '||
13358: fnd_number.number_to_canonical(l_no_of_events), 30);
13359:
13360: -- b) Loop through the events and check if any have changed.
13361: l_itr := l_proration_dates.FIRST;
13362: WHILE l_itr <= l_proration_dates.LAST
13425: ,t_proration_changes => l_proration_changes
13426: );
13427:
13428: debug('Number of '||l_event_group||' Events : '||
13429: fnd_number.number_to_canonical(l_no_of_events), 90);
13430:
13431: -- b) Loop through the events and check if any have changed.
13432: l_itr := l_proration_dates.FIRST;
13433: WHILE l_itr <= l_proration_dates.LAST
13967: /*
13968: l_current := l_indexes_to_skip.FIRST;
13969: WHILE l_current <= l_indexes_to_skip.LAST
13970: LOOP
13971: dbms_output.put_line('Skip Index: '||fnd_number.number_to_canonical(l_current));
13972: l_current := l_indexes_to_skip.NEXT(l_current);
13973: END LOOP;
13974: */
13975: