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_FILE

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 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 2967: fnd_file.put_line(FND_FILE.LOG,' Master Insert start at '||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));

2963: l_message VARCHAR2(150);
2964: L_PAY_GB_BACS_FPS PAY_GB_BACS_FPS.PRE_PAYMENT_PAYROLL_ACTION_ID%type;
2965: BEGIN
2966: hr_utility.trace(' Inserting Master Record in PAY_GB_BACS_FPS ');
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);

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

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

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

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
2983: L_MESSAGE := 'Deadlock 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: 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
2988: L_MESSAGE := 'Parameter Error 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 =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
2993: L_MESSAGE := 'Already owned 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: 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
2998: L_MESSAGE := 'Illegal Lock Handle 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=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;
3003: IF L_COUNT_LOCK_FAILURES < 50 THEN
3004: HR_UTILITY.TRACE('Sleeping for a second'||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 3010: fnd_file.put_line(FND_FILE.LOG,L_MESSAGE);

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;
3013: END LOOP;
3014: END IF;

Line 3022: 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'));

3018: INTO L_PAY_GB_BACS_FPS
3019: FROM PAY_GB_BACS_FPS
3020: WHERE PRE_PAYMENT_PAYROLL_ACTION_ID = P_PAYROLL_ACTION_ID;
3021: hr_utility.trace(' Second check - Data present in PAY_GB_BACS_FPS - No insert happened');
3022: 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: EXCEPTION
3024: WHEN no_data_found THEN
3025: INSERT
3026: INTO PAY_GB_BACS_FPS

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

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

Line 3052: 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
3055: L_MESSAGE := 'Illegal Lock Handle 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=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;
3060: END IF;
3061: --15903040 End

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

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

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 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 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 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 3222: fnd_file.put_line(FND_FILE.LOG,' Entered FPS_BACS_PREPROCESS at'||TO_CHAR(sysdate,'ddmmyyyy hh24:mi:ss'));

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

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

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

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

3230: END IF;
3231:
3232:
3233: IF P_PROGRAM = 'BACS' THEN
3234: fnd_file.put_line(FND_FILE.LOG,' Called from BACS');
3235: B_PAYROLL_ACTION_ID := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
3236: fnd_file.put_line(FND_FILE.LOG,' BACS Payroll Action ID :'|| B_PAYROLL_ACTION_ID);
3237: OPEN C_PREPAY_PAYROLL_ACTN_ID FOR
3238: SELECT DISTINCT payroll_action_id

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

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

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

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

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

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

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

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

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

3302: WHEN OTHERS THEN
3303:
3304:
3305: hr_utility.trace(' No Config found for the paye reference:' || l_tax_ref);
3306: fnd_file.put_line(FND_FILE.LOG,' No Config found for the paye reference:' || l_tax_ref);
3307: RETURN l_return;
3308: END;
3309:
3310: END IF; -- if l_uptake_value = 'PARTIAL'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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