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 FND_FILE

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

2916: if l_dummy > 0 then
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));

Line 2924: fnd_file.put_line(FND_FILE.LOG,'Insert is running for long time !!!!!!!!!!!! Hence quiting'||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;
2926: End If;
2927: else
2928: exit;

Line 2972: fnd_file.put_line(FND_FILE.LOG,' Master Insert start at '||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));

2968: l_message VARCHAR2(150);
2969: L_PAY_GB_BACS_FPS PAY_GB_BACS_FPS.PRE_PAYMENT_PAYROLL_ACTION_ID%type;
2970: BEGIN
2971: hr_utility.trace(' Inserting Master Record in PAY_GB_BACS_FPS ');
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);

Line 2980: fnd_file.put_line(FND_FILE.LOG,' Lock granted at '||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));

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;
2982: elsif p_retval =1 THEN
2983: L_MESSAGE := 'Timeout at '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);
2984: HR_UTILITY.TRACE(L_MESSAGE);

Line 2985: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);

2981: EXIT;
2982: elsif p_retval =1 THEN
2983: L_MESSAGE := 'Timeout 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 =2 THEN
2988: L_MESSAGE := 'Deadlock at '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);
2989: HR_UTILITY.TRACE(L_MESSAGE);

Line 2990: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);

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

Line 2995: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);

2991: l_count_lock_failures := l_count_lock_failures +1;
2992: elsif p_retval =3 THEN
2993: L_MESSAGE := 'Parameter Error 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=4 THEN
2998: L_MESSAGE := 'Already owned at '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);
2999: HR_UTILITY.TRACE(L_MESSAGE);

Line 3000: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);

2996: hr_utility.raise_error;
2997: elsif p_retval=4 THEN
2998: L_MESSAGE := 'Already owned 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: elsif p_retval=5 THEN
3003: L_MESSAGE := 'Illegal Lock Handle at '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);
3004: HR_UTILITY.TRACE(L_MESSAGE);

Line 3005: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);

3001: hr_utility.raise_error;
3002: elsif p_retval=5 THEN
3003: L_MESSAGE := 'Illegal Lock Handle at '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);
3004: HR_UTILITY.TRACE(L_MESSAGE);
3005: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);
3006: hr_utility.raise_error;
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));

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

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

Line 3015: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);

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);
3016: hr_utility.raise_error;
3017: END IF;
3018: END LOOP;
3019: END IF;

Line 3027: fnd_file.put_line(FND_FILE.LOG,' Second check - Data present in PAY_GB_BACS_FPS - No insert happened at '||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));

3023: INTO L_PAY_GB_BACS_FPS
3024: FROM PAY_GB_BACS_FPS
3025: WHERE PRE_PAYMENT_PAYROLL_ACTION_ID = P_PAYROLL_ACTION_ID;
3026: hr_utility.trace(' Second check - Data present in PAY_GB_BACS_FPS - No insert happened');
3027: fnd_file.put_line(FND_FILE.LOG,' Second check - Data present in PAY_GB_BACS_FPS - No insert happened at '||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));
3028: EXCEPTION
3029: WHEN no_data_found THEN
3030: INSERT
3031: INTO PAY_GB_BACS_FPS

Line 3052: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);

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);
3053: hr_utility.raise_error;
3054: elsif p_retval=4 THEN
3055: L_MESSAGE := 'Do not own lock specified by id or lockhandle at '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);
3056: HR_UTILITY.TRACE(L_MESSAGE);

Line 3057: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);

3053: hr_utility.raise_error;
3054: elsif p_retval=4 THEN
3055: L_MESSAGE := 'Do not own lock specified by id or lockhandle 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: elsif p_retval=5 THEN
3060: L_MESSAGE := 'Illegal Lock Handle at '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);
3061: HR_UTILITY.TRACE(L_MESSAGE);

Line 3062: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);

3058: hr_utility.raise_error;
3059: elsif p_retval=5 THEN
3060: L_MESSAGE := 'Illegal Lock Handle at '||FND_DATE.DATE_TO_CANONICAL(SYSDATE);
3061: HR_UTILITY.TRACE(L_MESSAGE);
3062: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);
3063: hr_utility.raise_error;
3064: END IF;
3065: END IF;
3066: --15903040 End

Line 3068: fnd_file.put_line(FND_FILE.LOG,' Master Insert completed at '||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));

3064: END IF;
3065: END IF;
3066: --15903040 End
3067: hr_utility.trace(' Master Record insert completed ');
3068: fnd_file.put_line(FND_FILE.LOG,' Master Insert completed at '||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));
3069: RETURN L_DUMMY;
3070: END INSERT_MASTER;
3071: FUNCTION fetch_HASH_FPS_ASG
3072: (

Line 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));

3099: When no_data_found then
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));

Line 3107: fnd_file.put_line(FND_FILE.LOG,'Insert is running for long time !!!!!!!!!!!! Hence quiting'||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;
3109: End If;
3110: End;
3111: END LOOP;

Line 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));

3155: When no_data_found then
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));

Line 3163: fnd_file.put_line(FND_FILE.LOG,'Insert is running for long time !!!!!!!!!!!! Hence quiting'||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;
3165: End If;
3166: End;
3167: END LOOP;

Line 3227: fnd_file.put_line(FND_FILE.LOG,' Entered FPS_BACS_PREPROCESS at'||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));

3223: CURSOR;
3224: C_PREPAY_PAYROLL_ACTN_ID r_cursor;
3225: BEGIN
3226: hr_utility.trace(' Entered FPS_BACS_PREPROCESS at'||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));
3227: fnd_file.put_line(FND_FILE.LOG,' Entered FPS_BACS_PREPROCESS at'||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));
3228: -- Get the profile value
3229: fnd_profile.get('GB RTI Uptake', l_uptake_value);
3230: fnd_file.put_line(FND_FILE.LOG,' l_uptake_value : '||l_uptake_value);
3231:

Line 3230: fnd_file.put_line(FND_FILE.LOG,' l_uptake_value : '||l_uptake_value);

3226: hr_utility.trace(' Entered FPS_BACS_PREPROCESS at'||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));
3227: fnd_file.put_line(FND_FILE.LOG,' Entered FPS_BACS_PREPROCESS at'||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));
3228: -- Get the profile value
3229: fnd_profile.get('GB RTI Uptake', l_uptake_value);
3230: fnd_file.put_line(FND_FILE.LOG,' l_uptake_value : '||l_uptake_value);
3231:
3232: -- When RTI Profile is set to None return without doing any processing.
3233: IF l_uptake_value IS NULL OR l_uptake_value = 'NONE' THEN
3234: RETURN l_return;

Line 3239: fnd_file.put_line(FND_FILE.LOG,' Called from BACS');

3235: END IF;
3236:
3237:
3238: IF P_PROGRAM = 'BACS' THEN
3239: fnd_file.put_line(FND_FILE.LOG,' Called from BACS');
3240: B_PAYROLL_ACTION_ID := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
3241: fnd_file.put_line(FND_FILE.LOG,' BACS Payroll Action ID :'|| B_PAYROLL_ACTION_ID);
3242: OPEN C_PREPAY_PAYROLL_ACTN_ID FOR
3243: SELECT DISTINCT payroll_action_id

Line 3241: fnd_file.put_line(FND_FILE.LOG,' BACS Payroll Action ID :'|| B_PAYROLL_ACTION_ID);

3237:
3238: IF P_PROGRAM = 'BACS' THEN
3239: fnd_file.put_line(FND_FILE.LOG,' Called from BACS');
3240: B_PAYROLL_ACTION_ID := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
3241: fnd_file.put_line(FND_FILE.LOG,' BACS Payroll Action ID :'|| B_PAYROLL_ACTION_ID);
3242: OPEN C_PREPAY_PAYROLL_ACTN_ID FOR
3243: SELECT DISTINCT payroll_action_id
3244: FROM pay_payroll_actions
3245: WHERE payroll_action_id IN

Line 3270: fnd_file.put_line(FND_FILE.LOG,' Operation started for '||L_PAYROLL_ACTION_ID);

3266: END IF;
3267: LOOP
3268: FETCH C_PREPAY_PAYROLL_ACTN_ID INTO L_PAYROLL_ACTION_ID;
3269: hr_utility.trace(' Operation started for '||L_PAYROLL_ACTION_ID);
3270: fnd_file.put_line(FND_FILE.LOG,' Operation started for '||L_PAYROLL_ACTION_ID);
3271:
3272: --14797457 - If no BACS payment then exit the loop
3273: IF L_PAYROLL_ACTION_ID IS NULL THEN
3274: EXIT;

Line 3292: fnd_file.put_line(FND_FILE.LOG,' l_business_group_id: ' || l_business_group_id);

3288: WHERE payroll_action_id = L_PAYROLL_ACTION_ID;
3289: OPEN get_paye_ref(l_effective_date);
3290: FETCH get_paye_ref INTO l_business_group_id, l_tax_ref;
3291: CLOSE get_paye_ref;
3292: fnd_file.put_line(FND_FILE.LOG,' l_business_group_id: ' || l_business_group_id);
3293: fnd_file.put_line(FND_FILE.LOG,' l_tax_ref: ' || l_tax_ref);
3294:
3295: -- get the tax reference and effective date from configurations defined for this business group.
3296: BEGIN

Line 3293: fnd_file.put_line(FND_FILE.LOG,' l_tax_ref: ' || l_tax_ref);

3289: OPEN get_paye_ref(l_effective_date);
3290: FETCH get_paye_ref INTO l_business_group_id, l_tax_ref;
3291: CLOSE get_paye_ref;
3292: fnd_file.put_line(FND_FILE.LOG,' l_business_group_id: ' || l_business_group_id);
3293: fnd_file.put_line(FND_FILE.LOG,' l_tax_ref: ' || l_tax_ref);
3294:
3295: -- get the tax reference and effective date from configurations defined for this business group.
3296: BEGIN
3297: SELECT 1

Line 3311: fnd_file.put_line(FND_FILE.LOG,' No Config found for the paye reference:' || l_tax_ref);

3307: WHEN OTHERS THEN
3308:
3309:
3310: hr_utility.trace(' No Config found for the paye reference:' || l_tax_ref);
3311: fnd_file.put_line(FND_FILE.LOG,' No Config found for the paye reference:' || l_tax_ref);
3312: RETURN l_return;
3313: END;
3314:
3315: END IF; -- if l_uptake_value = 'PARTIAL'

Line 3320: fnd_file.put_line(FND_FILE.LOG,' Check for PAYROLL_ACTION_ID '||L_PAYROLL_ACTION_ID);

3316: -- Follow the normal behaviour when the profile value is either set to ALL or
3317: -- for the current PAYE ref the RTI is enabled through config values.
3318: IF l_insert_bacs IS NOT NULL OR l_uptake_value = 'ALL' THEN
3319: BEGIN
3320: fnd_file.put_line(FND_FILE.LOG,' Check for PAYROLL_ACTION_ID '||L_PAYROLL_ACTION_ID);
3321: SELECT DISTINCT PRE_PAYMENT_PAYROLL_ACTION_ID
3322: INTO L_PAY_GB_BACS_FPS
3323: FROM PAY_GB_BACS_FPS
3324: WHERE PRE_PAYMENT_PAYROLL_ACTION_ID = L_PAYROLL_ACTION_ID;

Line 3326: fnd_file.put_line(FND_FILE.LOG,' Data present in PAY_GB_BACS_FPS - No insert happened');

3322: INTO L_PAY_GB_BACS_FPS
3323: FROM PAY_GB_BACS_FPS
3324: WHERE PRE_PAYMENT_PAYROLL_ACTION_ID = L_PAYROLL_ACTION_ID;
3325: hr_utility.trace(' Data present in PAY_GB_BACS_FPS - No insert happened');
3326: fnd_file.put_line(FND_FILE.LOG,' Data present in PAY_GB_BACS_FPS - No insert happened');
3327: RETURN l_return;
3328: EXCEPTION
3329: WHEN no_data_found THEN
3330: l_insert_status := 0;

Line 3332: fnd_file.put_line(FND_FILE.LOG,' Data not present in PAY_GB_BACS_FPS- Calling Master insert');

3328: EXCEPTION
3329: WHEN no_data_found THEN
3330: l_insert_status := 0;
3331: --Insert the master row.
3332: fnd_file.put_line(FND_FILE.LOG,' Data not present in PAY_GB_BACS_FPS- Calling Master insert');
3333: l_return := Insert_master(L_PAYROLL_ACTION_ID,P_PROGRAM,l_insert_status);
3334: fnd_file.put_line(FND_FILE.LOG,' Master insert completed - Moving to other inserts');
3335: --Insert the computed rows with random digits and hash value
3336: BEGIN --14807372

Line 3334: fnd_file.put_line(FND_FILE.LOG,' Master insert completed - Moving to other inserts');

3330: l_insert_status := 0;
3331: --Insert the master row.
3332: fnd_file.put_line(FND_FILE.LOG,' Data not present in PAY_GB_BACS_FPS- Calling Master insert');
3333: l_return := Insert_master(L_PAYROLL_ACTION_ID,P_PROGRAM,l_insert_status);
3334: fnd_file.put_line(FND_FILE.LOG,' Master insert completed - Moving to other inserts');
3335: --Insert the computed rows with random digits and hash value
3336: BEGIN --14807372
3337: IF l_insert_status = 5 THEN --15903040
3338: --l_insert_status = 5 means Insert_master inserted the master row in this thread/session

Line 3340: fnd_file.put_line(FND_FILE.LOG,' Main insert started at '||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));

3336: BEGIN --14807372
3337: IF l_insert_status = 5 THEN --15903040
3338: --l_insert_status = 5 means Insert_master inserted the master row in this thread/session
3339: --so below insert should be executed.
3340: fnd_file.put_line(FND_FILE.LOG,' Main insert started at '||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));
3341: INSERT
3342: INTO PAY_GB_BACS_FPS
3343: (
3344: PRE_PAYMENT_PAYROLL_ACTION_ID,

Line 3414: fnd_file.put_line(FND_FILE.LOG,' Main insert completed at '||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));

3410: FROM PAY_GB_BACS_FPS
3411: WHERE PRE_PAYMENT_PAYROLL_ACTION_ID = L_PAYROLL_ACTION_ID
3412: );
3413: hr_utility.trace(' All insert completed for '||L_PAYROLL_ACTION_ID);
3414: fnd_file.put_line(FND_FILE.LOG,' Main insert completed at '||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));
3415: --15903040 Begin
3416: --This update statement will be fired once.
3417: --This will indicate all inserts for the payroll action id is completed.
3418: update PAY_GB_BACS_FPS

Line 3425: fnd_file.put_line(FND_FILE.LOG,' Sanity check start at '||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));

3421: and RANDOM_STRING is null
3422: and PRE_PAYMENT_ID is null;
3423: --15903040 End
3424: END IF;-- check for l_insert_status = 5
3425: fnd_file.put_line(FND_FILE.LOG,' Sanity check start at '||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));
3426:
3427: DELETE
3428: FROM PAY_GB_BACS_FPS
3429: WHERE rowid NOT IN

Line 3477: fnd_file.put_line(FND_FILE.LOG,' Sanity check completed at '||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));

3473: PERSON_ID,
3474: AMOUNT
3475: HAVING COUNT(*) > 1
3476: );
3477: fnd_file.put_line(FND_FILE.LOG,' Sanity check completed at '||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));
3478: hr_utility.trace(' Deleted aggregated duplicate rows for '||L_PAYROLL_ACTION_ID);
3479: L_PAYROLL_ACTION_ID := NULL;
3480: --14807372
3481: EXCEPTION

Line 3497: fnd_file.put_line(FND_FILE.LOG,' leaving FPS_BACS_PREPROCESS'||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));

3493: COMMIT;
3494: END IF; -- end for if l_insert_bacs = true OR l_uptake_value = 'ALL'
3495: END LOOP;
3496: CLOSE C_PREPAY_PAYROLL_ACTN_ID;
3497: fnd_file.put_line(FND_FILE.LOG,' leaving FPS_BACS_PREPROCESS'||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));
3498: RETURN l_return;
3499: END FPS_BACS_PREPROCESS;
3500: --
3501: --FPS RollBack Start