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 DBMS_LOCK

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

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));
2920: hr_utility.raise_error;

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

2967: fnd_file.put_line(FND_FILE.LOG,' Master Insert start at '||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));
2968: --15903040 Begin
2969: IF l_lockhandle IS NULL THEN
2970: LOOP
2971: dbms_lock.allocate_unique(l_lockname, l_lockhandle);
2972: p_retval := dbms_lock.request(l_lockhandle, p_ltype);
2973: IF p_retval = 0 THEN
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'));

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

2968: --15903040 Begin
2969: IF l_lockhandle IS NULL THEN
2970: LOOP
2971: dbms_lock.allocate_unique(l_lockname, l_lockhandle);
2972: p_retval := dbms_lock.request(l_lockhandle, p_ltype);
2973: IF p_retval = 0 THEN
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;

Line 3006: dbms_lock.sleep(1);

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);
3010: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);

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

3039: --for P_PAYROLL_ACTION_ID is inprogress or completed.
3040: l_insert_status := 5; --This means insert of master record happened.
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);

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

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));
3103: hr_utility.raise_error;

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

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));
3159: hr_utility.raise_error;