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_FI_ARCHIVE_UMFR dependencies on FND_FILE

Line 312: fnd_file.put_line (fnd_file.LOG, 'Entering Procedure RANGE_CODE 7');

308: THEN
309: hr_utility.set_location (' Entering Procedure RANGE_CODE', 40);
310: END IF;
311:
312: fnd_file.put_line (fnd_file.LOG, 'Entering Procedure RANGE_CODE 7');
313: p_sql :=
314: 'SELECT DISTINCT person_id
315: FROM per_people_f ppf
316: ,pay_payroll_actions ppa

Line 342: fnd_file.put_line (fnd_file.LOG, '1');

338: l_accounting_id := lr_trade_union_details.org_information5;
339: -- Pick up the details belonging to Legal Employer Details
340:
341: OPEN csr_legal_employer_details (g_legal_employer_id);
342: fnd_file.put_line (fnd_file.LOG, '1');
343: FETCH csr_legal_employer_details INTO lr_legal_employer_details;
344: fnd_file.put_line (fnd_file.LOG, '2');
345: CLOSE csr_legal_employer_details;
346: fnd_file.put_line (fnd_file.LOG, '3');

Line 344: fnd_file.put_line (fnd_file.LOG, '2');

340:
341: OPEN csr_legal_employer_details (g_legal_employer_id);
342: fnd_file.put_line (fnd_file.LOG, '1');
343: FETCH csr_legal_employer_details INTO lr_legal_employer_details;
344: fnd_file.put_line (fnd_file.LOG, '2');
345: CLOSE csr_legal_employer_details;
346: fnd_file.put_line (fnd_file.LOG, '3');
347: l_y_number := lr_legal_employer_details.org_information1;
348:

Line 346: fnd_file.put_line (fnd_file.LOG, '3');

342: fnd_file.put_line (fnd_file.LOG, '1');
343: FETCH csr_legal_employer_details INTO lr_legal_employer_details;
344: fnd_file.put_line (fnd_file.LOG, '2');
345: CLOSE csr_legal_employer_details;
346: fnd_file.put_line (fnd_file.LOG, '3');
347: l_y_number := lr_legal_employer_details.org_information1;
348:
349: IF g_local_unit_id IS NOT NULL
350: THEN

Line 866: fnd_file.put_line ( fnd_file.LOG, g_legal_employer_id ||'g_legal_employer_id');

862: g_period_end_date,
863: g_archive
864: );
865:
866: fnd_file.put_line ( fnd_file.LOG, g_legal_employer_id ||'g_legal_employer_id');
867: fnd_file.put_line ( fnd_file.LOG, p_start_person ||'p_start_person');
868: fnd_file.put_line ( fnd_file.LOG, p_end_person ||'p_end_person');
869: fnd_file.put_line ( fnd_file.LOG, g_local_unit_id ||'g_local_unit_id');
870: fnd_file.put_line ( fnd_file.LOG, g_trade_union_id ||'g_trade_union_id');

Line 867: fnd_file.put_line ( fnd_file.LOG, p_start_person ||'p_start_person');

863: g_archive
864: );
865:
866: fnd_file.put_line ( fnd_file.LOG, g_legal_employer_id ||'g_legal_employer_id');
867: fnd_file.put_line ( fnd_file.LOG, p_start_person ||'p_start_person');
868: fnd_file.put_line ( fnd_file.LOG, p_end_person ||'p_end_person');
869: fnd_file.put_line ( fnd_file.LOG, g_local_unit_id ||'g_local_unit_id');
870: fnd_file.put_line ( fnd_file.LOG, g_trade_union_id ||'g_trade_union_id');
871: fnd_file.put_line ( fnd_file.LOG, g_period_start_date ||'g_period_start_date');

Line 868: fnd_file.put_line ( fnd_file.LOG, p_end_person ||'p_end_person');

864: );
865:
866: fnd_file.put_line ( fnd_file.LOG, g_legal_employer_id ||'g_legal_employer_id');
867: fnd_file.put_line ( fnd_file.LOG, p_start_person ||'p_start_person');
868: fnd_file.put_line ( fnd_file.LOG, p_end_person ||'p_end_person');
869: fnd_file.put_line ( fnd_file.LOG, g_local_unit_id ||'g_local_unit_id');
870: fnd_file.put_line ( fnd_file.LOG, g_trade_union_id ||'g_trade_union_id');
871: fnd_file.put_line ( fnd_file.LOG, g_period_start_date ||'g_period_start_date');
872: fnd_file.put_line ( fnd_file.LOG, g_period_start_date ||'g_period_start_date');

Line 869: fnd_file.put_line ( fnd_file.LOG, g_local_unit_id ||'g_local_unit_id');

865:
866: fnd_file.put_line ( fnd_file.LOG, g_legal_employer_id ||'g_legal_employer_id');
867: fnd_file.put_line ( fnd_file.LOG, p_start_person ||'p_start_person');
868: fnd_file.put_line ( fnd_file.LOG, p_end_person ||'p_end_person');
869: fnd_file.put_line ( fnd_file.LOG, g_local_unit_id ||'g_local_unit_id');
870: fnd_file.put_line ( fnd_file.LOG, g_trade_union_id ||'g_trade_union_id');
871: fnd_file.put_line ( fnd_file.LOG, g_period_start_date ||'g_period_start_date');
872: fnd_file.put_line ( fnd_file.LOG, g_period_start_date ||'g_period_start_date');
873: fnd_file.put_line ( fnd_file.LOG, g_period_start_date ||'g_period_start_date');

Line 870: fnd_file.put_line ( fnd_file.LOG, g_trade_union_id ||'g_trade_union_id');

866: fnd_file.put_line ( fnd_file.LOG, g_legal_employer_id ||'g_legal_employer_id');
867: fnd_file.put_line ( fnd_file.LOG, p_start_person ||'p_start_person');
868: fnd_file.put_line ( fnd_file.LOG, p_end_person ||'p_end_person');
869: fnd_file.put_line ( fnd_file.LOG, g_local_unit_id ||'g_local_unit_id');
870: fnd_file.put_line ( fnd_file.LOG, g_trade_union_id ||'g_trade_union_id');
871: fnd_file.put_line ( fnd_file.LOG, g_period_start_date ||'g_period_start_date');
872: fnd_file.put_line ( fnd_file.LOG, g_period_start_date ||'g_period_start_date');
873: fnd_file.put_line ( fnd_file.LOG, g_period_start_date ||'g_period_start_date');
874:

Line 871: fnd_file.put_line ( fnd_file.LOG, g_period_start_date ||'g_period_start_date');

867: fnd_file.put_line ( fnd_file.LOG, p_start_person ||'p_start_person');
868: fnd_file.put_line ( fnd_file.LOG, p_end_person ||'p_end_person');
869: fnd_file.put_line ( fnd_file.LOG, g_local_unit_id ||'g_local_unit_id');
870: fnd_file.put_line ( fnd_file.LOG, g_trade_union_id ||'g_trade_union_id');
871: fnd_file.put_line ( fnd_file.LOG, g_period_start_date ||'g_period_start_date');
872: fnd_file.put_line ( fnd_file.LOG, g_period_start_date ||'g_period_start_date');
873: fnd_file.put_line ( fnd_file.LOG, g_period_start_date ||'g_period_start_date');
874:
875: IF g_archive = 'Y'

Line 872: fnd_file.put_line ( fnd_file.LOG, g_period_start_date ||'g_period_start_date');

868: fnd_file.put_line ( fnd_file.LOG, p_end_person ||'p_end_person');
869: fnd_file.put_line ( fnd_file.LOG, g_local_unit_id ||'g_local_unit_id');
870: fnd_file.put_line ( fnd_file.LOG, g_trade_union_id ||'g_trade_union_id');
871: fnd_file.put_line ( fnd_file.LOG, g_period_start_date ||'g_period_start_date');
872: fnd_file.put_line ( fnd_file.LOG, g_period_start_date ||'g_period_start_date');
873: fnd_file.put_line ( fnd_file.LOG, g_period_start_date ||'g_period_start_date');
874:
875: IF g_archive = 'Y'
876: THEN

Line 873: fnd_file.put_line ( fnd_file.LOG, g_period_start_date ||'g_period_start_date');

869: fnd_file.put_line ( fnd_file.LOG, g_local_unit_id ||'g_local_unit_id');
870: fnd_file.put_line ( fnd_file.LOG, g_trade_union_id ||'g_trade_union_id');
871: fnd_file.put_line ( fnd_file.LOG, g_period_start_date ||'g_period_start_date');
872: fnd_file.put_line ( fnd_file.LOG, g_period_start_date ||'g_period_start_date');
873: fnd_file.put_line ( fnd_file.LOG, g_period_start_date ||'g_period_start_date');
874:
875: IF g_archive = 'Y'
876: THEN
877: l_prepay_action_id := 0;

Line 879: fnd_file.put_line (fnd_file.LOG, ' Before the Locking Cursor ');

875: IF g_archive = 'Y'
876: THEN
877: l_prepay_action_id := 0;
878: l_assignment:=0;
879: fnd_file.put_line (fnd_file.LOG, ' Before the Locking Cursor ');
880:
881: SELECT DECODE (
882: g_period,
883: 'MONTH', TRUNC (g_period_end_date, 'MM'),

Line 903: fnd_file.put_line (

899: )
900: INTO g_period_start_date
901: FROM DUAL;
902:
903: fnd_file.put_line (
904: fnd_file.LOG,
905: 'G_PERIOD_start_DATE '
906: || g_period_start_date
907: );

Line 904: fnd_file.LOG,

900: INTO g_period_start_date
901: FROM DUAL;
902:
903: fnd_file.put_line (
904: fnd_file.LOG,
905: 'G_PERIOD_start_DATE '
906: || g_period_start_date
907: );
908:

Line 939: fnd_file.put_line (

935: + 1;
936: g_lock_table (g_index_assact).archive_assact_id := l_actid;
937:
938: -- Create the archive assignment action
939: fnd_file.put_line (
940: fnd_file.LOG,
941: 'l_actid'
942: || l_actid
943: || ' rec_prepaid_assignments.assignment_id'

Line 940: fnd_file.LOG,

936: g_lock_table (g_index_assact).archive_assact_id := l_actid;
937:
938: -- Create the archive assignment action
939: fnd_file.put_line (
940: fnd_file.LOG,
941: 'l_actid'
942: || l_actid
943: || ' rec_prepaid_assignments.assignment_id'
944: || rec_prepaid_assignments.assignment_id

Line 967: fnd_file.put_line (

963: l_assignment:= rec_prepaid_assignments.assignment_id;
964: END LOOP;
965: END IF; --ARCHIVE
966:
967: fnd_file.put_line (
968: fnd_file.LOG,
969: ' After Ending Assignment Act Code the Locking Cursor '
970: );
971:

Line 968: fnd_file.LOG,

964: END LOOP;
965: END IF; --ARCHIVE
966:
967: fnd_file.put_line (
968: fnd_file.LOG,
969: ' After Ending Assignment Act Code the Locking Cursor '
970: );
971:
972: IF g_debug

Line 1065: fnd_file.put_line (fnd_file.LOG, 'In INIT_CODE 0');

1061: 80
1062: );
1063: END IF;
1064:
1065: fnd_file.put_line (fnd_file.LOG, 'In INIT_CODE 0');
1066:
1067:
1068: IF g_debug
1069: THEN

Line 1353: fnd_file.put_line (fnd_file.LOG, 'Entering ARCHIVE_CODE ');

1349:
1350: --
1351: --
1352: --
1353: fnd_file.put_line (fnd_file.LOG, 'Entering ARCHIVE_CODE ');
1354:
1355: --Insert your logic to select the data for report over here.
1356:
1357: --Pick up the details belonging to Trade Union

Line 1367: fnd_file.put_line (

1363: OPEN csr_get_segment2 ();
1364: FETCH csr_get_segment2 INTO lr_get_segment2;
1365: CLOSE csr_get_segment2;
1366: l_local_unit_id_fetched := lr_get_segment2.segment2;
1367: fnd_file.put_line (
1368: fnd_file.LOG,
1369: ' After the Legal g_local_unit_id '
1370: || g_local_unit_id
1371: );

Line 1368: fnd_file.LOG,

1364: FETCH csr_get_segment2 INTO lr_get_segment2;
1365: CLOSE csr_get_segment2;
1366: l_local_unit_id_fetched := lr_get_segment2.segment2;
1367: fnd_file.put_line (
1368: fnd_file.LOG,
1369: ' After the Legal g_local_unit_id '
1370: || g_local_unit_id
1371: );
1372: fnd_file.put_line (

Line 1372: fnd_file.put_line (

1368: fnd_file.LOG,
1369: ' After the Legal g_local_unit_id '
1370: || g_local_unit_id
1371: );
1372: fnd_file.put_line (
1373: fnd_file.LOG,
1374: ' l_Y_number_spare '
1375: || l_y_number_spare
1376: );

Line 1373: fnd_file.LOG,

1369: ' After the Legal g_local_unit_id '
1370: || g_local_unit_id
1371: );
1372: fnd_file.put_line (
1373: fnd_file.LOG,
1374: ' l_Y_number_spare '
1375: || l_y_number_spare
1376: );
1377: fnd_file.put_line (

Line 1377: fnd_file.put_line (

1373: fnd_file.LOG,
1374: ' l_Y_number_spare '
1375: || l_y_number_spare
1376: );
1377: fnd_file.put_line (
1378: fnd_file.LOG,
1379: ' l_Local_unit_number '
1380: || l_local_unit_number
1381: );

Line 1378: fnd_file.LOG,

1374: ' l_Y_number_spare '
1375: || l_y_number_spare
1376: );
1377: fnd_file.put_line (
1378: fnd_file.LOG,
1379: ' l_Local_unit_number '
1380: || l_local_unit_number
1381: );
1382: hr_utility.TRACE ('After Local Unit');

Line 1384: fnd_file.put_line (

1380: || l_local_unit_number
1381: );
1382: hr_utility.TRACE ('After Local Unit');
1383: hr_utility.TRACE ('Before Person Record');
1384: fnd_file.put_line (
1385: fnd_file.LOG,
1386: ' g_business_group_id '
1387: || g_business_group_id
1388: );

Line 1385: fnd_file.LOG,

1381: );
1382: hr_utility.TRACE ('After Local Unit');
1383: hr_utility.TRACE ('Before Person Record');
1384: fnd_file.put_line (
1385: fnd_file.LOG,
1386: ' g_business_group_id '
1387: || g_business_group_id
1388: );
1389: fnd_file.put_line (

Line 1389: fnd_file.put_line (

1385: fnd_file.LOG,
1386: ' g_business_group_id '
1387: || g_business_group_id
1388: );
1389: fnd_file.put_line (
1390: fnd_file.LOG,
1391: ' l_local_unit_id_fetched '
1392: || l_local_unit_id_fetched
1393: );

Line 1390: fnd_file.LOG,

1386: ' g_business_group_id '
1387: || g_business_group_id
1388: );
1389: fnd_file.put_line (
1390: fnd_file.LOG,
1391: ' l_local_unit_id_fetched '
1392: || l_local_unit_id_fetched
1393: );
1394: fnd_file.put_line (

Line 1394: fnd_file.put_line (

1390: fnd_file.LOG,
1391: ' l_local_unit_id_fetched '
1392: || l_local_unit_id_fetched
1393: );
1394: fnd_file.put_line (
1395: fnd_file.LOG,
1396: ' p_assignment_action_id '
1397: || p_assignment_action_id
1398: );

Line 1395: fnd_file.LOG,

1391: ' l_local_unit_id_fetched '
1392: || l_local_unit_id_fetched
1393: );
1394: fnd_file.put_line (
1395: fnd_file.LOG,
1396: ' p_assignment_action_id '
1397: || p_assignment_action_id
1398: );
1399: fnd_file.put_line (

Line 1399: fnd_file.put_line (

1395: fnd_file.LOG,
1396: ' p_assignment_action_id '
1397: || p_assignment_action_id
1398: );
1399: fnd_file.put_line (
1400: fnd_file.LOG,
1401: ' p_effective_date '
1402: || p_effective_date
1403: );

Line 1400: fnd_file.LOG,

1396: ' p_assignment_action_id '
1397: || p_assignment_action_id
1398: );
1399: fnd_file.put_line (
1400: fnd_file.LOG,
1401: ' p_effective_date '
1402: || p_effective_date
1403: );
1404: OPEN csr_person_details (