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 dependencies on DBMS_LOCK

Line 2921: dbms_lock.sleep(3); --Sleep for three seconds

2917: L_COUNT_CHECK := L_COUNT_CHECK +1;
2918: IF L_COUNT_CHECK < 200 THEN
2919: HR_UTILITY.TRACE('All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
2920: fnd_file.put_line(FND_FILE.LOG,'All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
2921: dbms_lock.sleep(3); --Sleep for three seconds
2922: Else
2923: HR_UTILITY.TRACE('Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
2924: fnd_file.put_line(FND_FILE.LOG,'Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
2925: hr_utility.raise_error;

Line 2976: dbms_lock.allocate_unique(l_lockname, l_lockhandle);

2972: fnd_file.put_line(FND_FILE.LOG,' Master Insert start at '||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));
2973: --15903040 Begin
2974: IF l_lockhandle IS NULL THEN
2975: LOOP
2976: dbms_lock.allocate_unique(l_lockname, l_lockhandle);
2977: p_retval := dbms_lock.request(l_lockhandle, p_ltype);
2978: IF p_retval = 0 THEN
2979: --Lock is succesful. p_retval = 0
2980: fnd_file.put_line(FND_FILE.LOG,' Lock granted at '||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));

Line 2977: p_retval := dbms_lock.request(l_lockhandle, p_ltype);

2973: --15903040 Begin
2974: IF l_lockhandle IS NULL THEN
2975: LOOP
2976: dbms_lock.allocate_unique(l_lockname, l_lockhandle);
2977: p_retval := dbms_lock.request(l_lockhandle, p_ltype);
2978: IF p_retval = 0 THEN
2979: --Lock is succesful. p_retval = 0
2980: fnd_file.put_line(FND_FILE.LOG,' Lock granted at '||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));
2981: EXIT;

Line 3011: dbms_lock.sleep(1);

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

Line 3048: p_retval := dbms_lock.release(l_lockhandle);

3044: --for P_PAYROLL_ACTION_ID is inprogress or completed.
3045: l_insert_status := 5; --This means insert of master record happened.
3046: END;
3047: IF l_lockhandle IS NOT NULL THEN
3048: p_retval := dbms_lock.release(l_lockhandle);
3049: IF p_retval =3 THEN
3050: L_MESSAGE := 'Parameter Error at '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);
3051: HR_UTILITY.TRACE(L_MESSAGE);
3052: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);

Line 3104: dbms_lock.sleep(3); --Sleep for three seconds

3100: L_COUNT_CHECK := L_COUNT_CHECK +1;
3101: IF L_COUNT_CHECK < 200 THEN
3102: HR_UTILITY.TRACE(L_COUNT_CHECK||'- All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3103: 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));
3104: dbms_lock.sleep(3); --Sleep for three seconds
3105: Else
3106: HR_UTILITY.TRACE('Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3107: fnd_file.put_line(FND_FILE.LOG,'Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3108: hr_utility.raise_error;

Line 3160: dbms_lock.sleep(3); --Sleep for three seconds

3156: L_COUNT_CHECK := L_COUNT_CHECK +1;
3157: IF L_COUNT_CHECK < 200 THEN
3158: HR_UTILITY.TRACE(L_COUNT_CHECK||'- All insert not completed hence sleeping for 3 seconds'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3159: 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));
3160: dbms_lock.sleep(3); --Sleep for three seconds
3161: Else
3162: HR_UTILITY.TRACE('Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3163: fnd_file.put_line(FND_FILE.LOG,'Insert is running for long time !!!!!!!!!!!! Hence quiting'||FND_DATE.DATE_TO_CANONICAL(SYSDATE));
3164: hr_utility.raise_error;