eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_FPS_NI_AND_OTHERS_13 dependencies on FND_DATE

Line 2222: (select max(fnd_date.canonical_to_date(px.AEI_INFORMATION2)) from per_all_assignments_f paa1, per_all_assignments_f paa2,

2218: -1,-1,0)),'DD-MM-YYYY'))
2219:
2220: and PPTP.regular_payment_date >= /* Termination check for RTI NI Reporting assignment. */
2221: ( nvl(
2222: (select max(fnd_date.canonical_to_date(px.AEI_INFORMATION2)) from per_all_assignments_f paa1, per_all_assignments_f paa2,
2223: per_assignment_extra_info PX
2224: where paa1.assignment_id = BAL_ASSACT.assignment_id
2225: and paa1.person_id = paa2.person_id
2226: and PX.assignment_id = paa2.assignment_id

Line 2231: and fnd_date.canonical_to_date(PX.AEI_INFORMATION2) between ( to_date('06-04-' || to_char( to_number(

2227: and PX.AEI_INFORMATION1 = 'Y'
2228: and PX.AEI_INFORMATION_CATEGORY = 'GB_RTI_AGGREGATION'
2229: and paa2.ASSIGNMENT_STATUS_TYPE_ID = (select ASSIGNMENT_STATUS_TYPE_ID from per_assignment_status_types
2230: where USER_STATUS = 'Terminate Assignment')
2231: and fnd_date.canonical_to_date(PX.AEI_INFORMATION2) between ( to_date('06-04-' || to_char( to_number(
2232: to_char( BPTP.regular_payment_date,'YYYY'))
2233: + decode(sign( BPTP.regular_payment_date - to_date('06-04-'
2234: || to_char(BPTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
2235: -1,-1,0)),'DD-MM-YYYY')) and BPTP.regular_payment_date ), PPTP.regular_payment_date)

Line 2914: HR_UTILITY.TRACE('All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));

2910:
2911: if l_dummy > 0 then
2912: L_COUNT_CHECK := L_COUNT_CHECK +1;
2913: IF L_COUNT_CHECK < 200 THEN
2914: HR_UTILITY.TRACE('All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
2915: fnd_file.put_line(FND_FILE.LOG,'All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
2916: dbms_lock.sleep(3); --Sleep for three seconds
2917: Else
2918: HR_UTILITY.TRACE('Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));

Line 2915: fnd_file.put_line(FND_FILE.LOG,'All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));

2911: if l_dummy > 0 then
2912: L_COUNT_CHECK := L_COUNT_CHECK +1;
2913: IF L_COUNT_CHECK < 200 THEN
2914: HR_UTILITY.TRACE('All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
2915: fnd_file.put_line(FND_FILE.LOG,'All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
2916: dbms_lock.sleep(3); --Sleep for three seconds
2917: Else
2918: HR_UTILITY.TRACE('Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
2919: fnd_file.put_line(FND_FILE.LOG,'Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));

Line 2918: HR_UTILITY.TRACE('Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));

2914: HR_UTILITY.TRACE('All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
2915: fnd_file.put_line(FND_FILE.LOG,'All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
2916: dbms_lock.sleep(3); --Sleep for three seconds
2917: Else
2918: HR_UTILITY.TRACE('Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
2919: fnd_file.put_line(FND_FILE.LOG,'Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
2920: hr_utility.raise_error;
2921: End If;
2922: else

Line 2919: fnd_file.put_line(FND_FILE.LOG,'Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));

2915: fnd_file.put_line(FND_FILE.LOG,'All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
2916: dbms_lock.sleep(3); --Sleep for three seconds
2917: Else
2918: HR_UTILITY.TRACE('Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
2919: fnd_file.put_line(FND_FILE.LOG,'Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
2920: hr_utility.raise_error;
2921: End If;
2922: else
2923: exit;

Line 2978: L_MESSAGE := 'Timeout at '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);

2974: --Lock is succesful. p_retval = 0
2975: fnd_file.put_line(FND_FILE.LOG,' Lock granted at '||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));
2976: EXIT;
2977: elsif p_retval =1 THEN
2978: L_MESSAGE := 'Timeout at '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);
2979: HR_UTILITY.TRACE(L_MESSAGE);
2980: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);
2981: l_count_lock_failures := l_count_lock_failures +1;
2982: elsif p_retval =2 THEN

Line 2983: L_MESSAGE := 'Deadlock at '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);

2979: HR_UTILITY.TRACE(L_MESSAGE);
2980: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);
2981: l_count_lock_failures := l_count_lock_failures +1;
2982: elsif p_retval =2 THEN
2983: L_MESSAGE := 'Deadlock at '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);
2984: HR_UTILITY.TRACE(L_MESSAGE);
2985: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);
2986: l_count_lock_failures := l_count_lock_failures +1;
2987: elsif p_retval =3 THEN

Line 2988: L_MESSAGE := 'Parameter Error at '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);

2984: HR_UTILITY.TRACE(L_MESSAGE);
2985: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);
2986: l_count_lock_failures := l_count_lock_failures +1;
2987: elsif p_retval =3 THEN
2988: L_MESSAGE := 'Parameter Error at '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);
2989: HR_UTILITY.TRACE(L_MESSAGE);
2990: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);
2991: hr_utility.raise_error;
2992: elsif p_retval=4 THEN

Line 2993: L_MESSAGE := 'Already owned at '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);

2989: HR_UTILITY.TRACE(L_MESSAGE);
2990: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);
2991: hr_utility.raise_error;
2992: elsif p_retval=4 THEN
2993: L_MESSAGE := 'Already owned at '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);
2994: HR_UTILITY.TRACE(L_MESSAGE);
2995: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);
2996: hr_utility.raise_error;
2997: elsif p_retval=5 THEN

Line 2998: L_MESSAGE := 'Illegal Lock Handle at '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);

2994: HR_UTILITY.TRACE(L_MESSAGE);
2995: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);
2996: hr_utility.raise_error;
2997: elsif p_retval=5 THEN
2998: L_MESSAGE := 'Illegal Lock Handle at '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);
2999: HR_UTILITY.TRACE(L_MESSAGE);
3000: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);
3001: hr_utility.raise_error;
3002: END IF;

Line 3004: HR_UTILITY.TRACE('Sleeping for a second'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));

3000: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);
3001: hr_utility.raise_error;
3002: END IF;
3003: IF L_COUNT_LOCK_FAILURES < 50 THEN
3004: HR_UTILITY.TRACE('Sleeping for a second'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3005: fnd_file.put_line(FND_FILE.LOG,'Sleeping for a second'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3006: dbms_lock.sleep(1);
3007: ELSE
3008: L_MESSAGE := 'Lock cannot be obtained in 50 attempts hence error - '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);

Line 3005: fnd_file.put_line(FND_FILE.LOG,'Sleeping for a second'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));

3001: hr_utility.raise_error;
3002: END IF;
3003: IF L_COUNT_LOCK_FAILURES < 50 THEN
3004: HR_UTILITY.TRACE('Sleeping for a second'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3005: fnd_file.put_line(FND_FILE.LOG,'Sleeping for a second'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3006: dbms_lock.sleep(1);
3007: ELSE
3008: L_MESSAGE := 'Lock cannot be obtained in 50 attempts hence error - '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);
3009: HR_UTILITY.TRACE(L_MESSAGE);

Line 3008: L_MESSAGE := 'Lock cannot be obtained in 50 attempts hence error - '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);

3004: HR_UTILITY.TRACE('Sleeping for a second'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3005: fnd_file.put_line(FND_FILE.LOG,'Sleeping for a second'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3006: dbms_lock.sleep(1);
3007: ELSE
3008: L_MESSAGE := 'Lock cannot be obtained in 50 attempts hence error - '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);
3009: HR_UTILITY.TRACE(L_MESSAGE);
3010: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);
3011: hr_utility.raise_error;
3012: END IF;

Line 3045: L_MESSAGE := 'Parameter Error at '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);

3041: END;
3042: IF l_lockhandle IS NOT NULL THEN
3043: p_retval := dbms_lock.release(l_lockhandle);
3044: IF p_retval =3 THEN
3045: L_MESSAGE := 'Parameter Error at '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);
3046: HR_UTILITY.TRACE(L_MESSAGE);
3047: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);
3048: hr_utility.raise_error;
3049: elsif p_retval=4 THEN

Line 3050: L_MESSAGE := 'Do not own lock specified by id or lockhandle at '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);

3046: HR_UTILITY.TRACE(L_MESSAGE);
3047: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);
3048: hr_utility.raise_error;
3049: elsif p_retval=4 THEN
3050: L_MESSAGE := 'Do not own lock specified by id or lockhandle at '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);
3051: HR_UTILITY.TRACE(L_MESSAGE);
3052: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);
3053: hr_utility.raise_error;
3054: elsif p_retval=5 THEN

Line 3055: L_MESSAGE := 'Illegal Lock Handle at '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);

3051: HR_UTILITY.TRACE(L_MESSAGE);
3052: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);
3053: hr_utility.raise_error;
3054: elsif p_retval=5 THEN
3055: L_MESSAGE := 'Illegal Lock Handle at '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);
3056: HR_UTILITY.TRACE(L_MESSAGE);
3057: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);
3058: hr_utility.raise_error;
3059: END IF;

Line 3097: HR_UTILITY.TRACE(L_COUNT_CHECK||'- All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));

3093: Exception
3094: When no_data_found then
3095: L_COUNT_CHECK := L_COUNT_CHECK +1;
3096: IF L_COUNT_CHECK < 200 THEN
3097: HR_UTILITY.TRACE(L_COUNT_CHECK||'- All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3098: fnd_file.put_line(FND_FILE.LOG,L_COUNT_CHECK||'- All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3099: dbms_lock.sleep(3); --Sleep for three seconds
3100: Else
3101: HR_UTILITY.TRACE('Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));

Line 3098: fnd_file.put_line(FND_FILE.LOG,L_COUNT_CHECK||'- All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));

3094: When no_data_found then
3095: L_COUNT_CHECK := L_COUNT_CHECK +1;
3096: IF L_COUNT_CHECK < 200 THEN
3097: HR_UTILITY.TRACE(L_COUNT_CHECK||'- All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3098: fnd_file.put_line(FND_FILE.LOG,L_COUNT_CHECK||'- All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3099: dbms_lock.sleep(3); --Sleep for three seconds
3100: Else
3101: HR_UTILITY.TRACE('Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3102: fnd_file.put_line(FND_FILE.LOG,'Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));

Line 3101: HR_UTILITY.TRACE('Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));

3097: HR_UTILITY.TRACE(L_COUNT_CHECK||'- All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3098: fnd_file.put_line(FND_FILE.LOG,L_COUNT_CHECK||'- All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3099: dbms_lock.sleep(3); --Sleep for three seconds
3100: Else
3101: HR_UTILITY.TRACE('Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3102: fnd_file.put_line(FND_FILE.LOG,'Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3103: hr_utility.raise_error;
3104: End If;
3105: End;

Line 3102: fnd_file.put_line(FND_FILE.LOG,'Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));

3098: fnd_file.put_line(FND_FILE.LOG,L_COUNT_CHECK||'- All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3099: dbms_lock.sleep(3); --Sleep for three seconds
3100: Else
3101: HR_UTILITY.TRACE('Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3102: fnd_file.put_line(FND_FILE.LOG,'Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3103: hr_utility.raise_error;
3104: End If;
3105: End;
3106: END LOOP;

Line 3153: HR_UTILITY.TRACE(L_COUNT_CHECK||'- All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));

3149: Exception
3150: When no_data_found then
3151: L_COUNT_CHECK := L_COUNT_CHECK +1;
3152: IF L_COUNT_CHECK < 200 THEN
3153: HR_UTILITY.TRACE(L_COUNT_CHECK||'- All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3154: fnd_file.put_line(FND_FILE.LOG,L_COUNT_CHECK||'- All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3155: dbms_lock.sleep(3); --Sleep for three seconds
3156: Else
3157: HR_UTILITY.TRACE('Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));

Line 3154: fnd_file.put_line(FND_FILE.LOG,L_COUNT_CHECK||'- All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));

3150: When no_data_found then
3151: L_COUNT_CHECK := L_COUNT_CHECK +1;
3152: IF L_COUNT_CHECK < 200 THEN
3153: HR_UTILITY.TRACE(L_COUNT_CHECK||'- All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3154: fnd_file.put_line(FND_FILE.LOG,L_COUNT_CHECK||'- All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3155: dbms_lock.sleep(3); --Sleep for three seconds
3156: Else
3157: HR_UTILITY.TRACE('Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3158: fnd_file.put_line(FND_FILE.LOG,'Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));

Line 3157: HR_UTILITY.TRACE('Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));

3153: HR_UTILITY.TRACE(L_COUNT_CHECK||'- All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3154: fnd_file.put_line(FND_FILE.LOG,L_COUNT_CHECK||'- All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3155: dbms_lock.sleep(3); --Sleep for three seconds
3156: Else
3157: HR_UTILITY.TRACE('Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3158: fnd_file.put_line(FND_FILE.LOG,'Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3159: hr_utility.raise_error;
3160: End If;
3161: End;

Line 3158: fnd_file.put_line(FND_FILE.LOG,'Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));

3154: fnd_file.put_line(FND_FILE.LOG,L_COUNT_CHECK||'- All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3155: dbms_lock.sleep(3); --Sleep for three seconds
3156: Else
3157: HR_UTILITY.TRACE('Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3158: fnd_file.put_line(FND_FILE.LOG,'Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3159: hr_utility.raise_error;
3160: End If;
3161: End;
3162: END LOOP;

Line 3300: AND l_effective_date >= fnd_date.canonical_to_date(PCV_INFORMATION2);

3296: WHERE business_group_id = l_business_group_id
3297:
3298: AND pcv_information_category = 'PAY_GB_RTI_FPS_BACS'
3299: AND pcv_information1 = l_tax_ref
3300: AND l_effective_date >= fnd_date.canonical_to_date(PCV_INFORMATION2);
3301: EXCEPTION
3302: WHEN OTHERS THEN
3303:
3304: