APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on FND_NUMBER

Line 44: debug(fnd_number.number_to_canonical(p_trace_number));

40: PROCEDURE debug
41: (p_trace_number IN NUMBER )
42: IS
43: BEGIN
44: debug(fnd_number.number_to_canonical(p_trace_number));
45: END debug;
46: --
47: --
48: --

Line 1692: debug(fnd_number.number_to_canonical(SQL%ROWCOUNT)||' PPE row(s) updated.');

1688: ; -- allow all events upto end of day (eff_dt - 1)
1689:
1690: COMMIT;
1691:
1692: debug(fnd_number.number_to_canonical(SQL%ROWCOUNT)||' PPE row(s) updated.');
1693:
1694: debug_exit(l_proc_name);
1695: END set_pay_proc_events_to_process;
1696: --

Line 1742: ||fnd_number.number_to_canonical(p_assignment_id),10);

1738:
1739: debug_enter(l_proc_name);
1740:
1741: debug('Checking Type 4 For Assignment: '
1742: ||fnd_number.number_to_canonical(p_assignment_id),10);
1743: debug('p_business_group_id:'||p_business_group_id);
1744: debug('p_effective_date:'||p_effective_date);
1745: debug('g_business_group_id:'||g_business_group_id);
1746:

Line 2043: fnd_number.number_to_canonical(g_ext_asg_details.COUNT),440);

2039: -- as now we are adding a few primary asgs also,
2040: -- even though these are not to be reported
2041:
2042: debug('Number of TP4 teachers :'||
2043: fnd_number.number_to_canonical(g_ext_asg_details.COUNT),440);
2044:
2045: l_asg_details := g_ext_asg_details(p_assignment_id) ;
2046:
2047: debug('--ASSIGNMENT_DETAILS - FINAL (Primary)--');

Line 2160: fnd_number.number_to_canonical(p_assignment_id));

2156:
2157: debug_enter(l_proc_name);
2158:
2159: debug('p_assignment_id :'||
2160: fnd_number.number_to_canonical(p_assignment_id));
2161:
2162: -- Bugfix 3820719 : Added to get the effective sec asg
2163: -- id if primary is not effective
2164: IF NVL(p_assignment_id, -1) = -1 THEN

Line 2195: fnd_number.number_to_canonical(l_assignment_id));

2191: l_assignment_id := p_assignment_id;
2192: END IF;
2193:
2194: debug('l_assignment_id :'||
2195: fnd_number.number_to_canonical(l_assignment_id));
2196:
2197: IF NVL(l_assignment_id,-1) = -1 THEN
2198: l_estb_number := pqp_gb_tp_pension_extracts.g_estb_number;
2199:

Line 3423: fnd_number.number_to_canonical(l_proration_dates.COUNT),30);

3419: -- that caused the asg to "become" a teacher
3420: -- ie search for a change from NULL/NONT to TCHR
3421:
3422: debug('Number of IS_TEACHER Events: '||
3423: fnd_number.number_to_canonical(l_proration_dates.COUNT),30);
3424: debug('Number of t_proration_change_type: '||
3425: fnd_number.number_to_canonical(l_proration_changes.COUNT),40);
3426:
3427: l_itr := l_proration_dates.FIRST;

Line 3425: fnd_number.number_to_canonical(l_proration_changes.COUNT),40);

3421:
3422: debug('Number of IS_TEACHER Events: '||
3423: fnd_number.number_to_canonical(l_proration_dates.COUNT),30);
3424: debug('Number of t_proration_change_type: '||
3425: fnd_number.number_to_canonical(l_proration_changes.COUNT),40);
3426:
3427: l_itr := l_proration_dates.FIRST;
3428: debug('l_itr: '||l_itr, 50);
3429: WHILE l_itr <= l_proration_dates.LAST

Line 3601: debug('Number of ASG_LOCATION Events: '||fnd_number.number_to_canonical(l_proration_dates.COUNT),220);

3597: ,t_proration_dates => l_proration_dates -- OUT
3598: ,t_proration_change_type => l_proration_changes -- OUT
3599: );
3600:
3601: debug('Number of ASG_LOCATION Events: '||fnd_number.number_to_canonical(l_proration_dates.COUNT),220);
3602: debug('Number of Prorotaion Changes: '||fnd_number.number_to_canonical(l_proration_changes.COUNT));
3603: debug('l_no_of_events: '||l_no_of_events);
3604:
3605: cntr := 0; --Loop Counter

Line 3602: debug('Number of Prorotaion Changes: '||fnd_number.number_to_canonical(l_proration_changes.COUNT));

3598: ,t_proration_change_type => l_proration_changes -- OUT
3599: );
3600:
3601: debug('Number of ASG_LOCATION Events: '||fnd_number.number_to_canonical(l_proration_dates.COUNT),220);
3602: debug('Number of Prorotaion Changes: '||fnd_number.number_to_canonical(l_proration_changes.COUNT));
3603: debug('l_no_of_events: '||l_no_of_events);
3604:
3605: cntr := 0; --Loop Counter
3606: l_itr := l_proration_dates.FIRST;

Line 3964: debug(fnd_number.number_to_canonical(p_assignment_id)||

3960: debug('This assignment has NOT had a change in establishment.', 360);
3961:
3962: END IF;--if l_incl = Y ie new teacher or existing teacher changed locations
3963:
3964: debug(fnd_number.number_to_canonical(p_assignment_id)||
3965: ' l_inclusion_flag: '||l_inclusion_flag, 370);
3966:
3967: -- set OUT variables....
3968: p_asg_details := l_asg_details;