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_1099R_DATA dependencies on HR_UTILITY

Line 65: hr_utility

61: include NM, AR. Also changed the script to first
62: delete all the report formats and then insert.
63: --
64: 08-MAR-99 MREID 110.8 845184 Changed dbms_output calls to use
65: hr_utility
66: /*
*/
67: ----------------------------------------------------------------------------------------
68: -- Name
69: -- setup

Line 1252: hr_utility.trace('BEGIN 1099R REPORT DEFINITION PROCESS------------------------');

1248: lt_F_validate(li_ftab) := false;
1249:
1250: ----------------------------------------------------------------------------------------
1251: --
1252: hr_utility.trace('BEGIN 1099R REPORT DEFINITION PROCESS------------------------');
1253: li_btab := 1;
1254: li_ftab := 1;
1255: --
1256: FOR l_ccount IN 1..l_case_count LOOP

Line 1260: hr_utility.trace('Insert definition for ' ||

1256: FOR l_ccount IN 1..l_case_count LOOP
1257: ------------------------------------------------------
1258: --Clear existing format definitions and mappings
1259: ------------------------------------------------------
1260: hr_utility.trace('Insert definition for ' ||
1261: lt_report_format(l_ccount));
1262: hr_utility.trace(lt_desc(l_ccount));
1263: hr_utility.trace(' Deleting magnetic records...');
1264: DELETE FROM pay_magnetic_records

Line 1262: hr_utility.trace(lt_desc(l_ccount));

1258: --Clear existing format definitions and mappings
1259: ------------------------------------------------------
1260: hr_utility.trace('Insert definition for ' ||
1261: lt_report_format(l_ccount));
1262: hr_utility.trace(lt_desc(l_ccount));
1263: hr_utility.trace(' Deleting magnetic records...');
1264: DELETE FROM pay_magnetic_records
1265: WHERE magnetic_block_id IN
1266: (SELECT pmb.magnetic_block_id

Line 1263: hr_utility.trace(' Deleting magnetic records...');

1259: ------------------------------------------------------
1260: hr_utility.trace('Insert definition for ' ||
1261: lt_report_format(l_ccount));
1262: hr_utility.trace(lt_desc(l_ccount));
1263: hr_utility.trace(' Deleting magnetic records...');
1264: DELETE FROM pay_magnetic_records
1265: WHERE magnetic_block_id IN
1266: (SELECT pmb.magnetic_block_id
1267: FROM pay_magnetic_blocks pmb,

Line 1273: hr_utility.trace(' Deleting blocks...');

1269: WHERE pmb.report_format = pfm.report_format
1270: AND pmb.report_format = lt_report_format(l_ccount)
1271: AND pfm.report_category = 'RT');
1272: --
1273: hr_utility.trace(' Deleting blocks...');
1274: DELETE FROM pay_magnetic_blocks pmb
1275: WHERE pmb.report_format in
1276: (SELECT pfm.report_format
1277: FROM pay_report_format_mappings_f pfm

Line 1281: hr_utility.trace(' Deleting report format mappings...');

1277: FROM pay_report_format_mappings_f pfm
1278: WHERE pfm.report_format = lt_report_format(l_ccount)
1279: AND pfm.report_category = 'RT');
1280: --
1281: hr_utility.trace(' Deleting report format mappings...');
1282: DELETE FROM pay_report_format_mappings_f rfm
1283: WHERE rfm.report_format = lt_report_format(l_ccount)
1284: AND report_category = 'RT';
1285:

Line 1295: hr_utility.trace(' --Inserting '|| lt_report_qualifier(l_st_count)

1291: --Insert report format mappings
1292: -------------------------------------------------------
1293: --
1294: FOR l_st_count IN lt_rptq_first(l_ccount)..lt_rptq_last(l_ccount) LOOP
1295: hr_utility.trace(' --Inserting '|| lt_report_qualifier(l_st_count)
1296: || ' report qualifier...');
1297: INSERT INTO pay_report_format_mappings_f
1298: ( report_type,
1299: report_qualifier,

Line 1326: hr_utility.trace(' ');

1322: -------------------------------------------------------
1323: --Insert Blocks
1324: -------------------------------------------------------
1325: FOR l_bcount IN 1..lt_B_total(l_ccount) LOOP
1326: hr_utility.trace(' ');
1327: hr_utility.trace('Inserting block ' || lt_B_block_name(li_btab));
1328: l_message := 'Error inserting block ' || lt_B_block_name(li_btab);
1329: --
1330: IF l_bcount = 1 THEN -- only the first block should be starting block

Line 1327: hr_utility.trace('Inserting block ' || lt_B_block_name(li_btab));

1323: --Insert Blocks
1324: -------------------------------------------------------
1325: FOR l_bcount IN 1..lt_B_total(l_ccount) LOOP
1326: hr_utility.trace(' ');
1327: hr_utility.trace('Inserting block ' || lt_B_block_name(li_btab));
1328: l_message := 'Error inserting block ' || lt_B_block_name(li_btab);
1329: --
1330: IF l_bcount = 1 THEN -- only the first block should be starting block
1331: l_main_block_flag := 'Y';

Line 1349: hr_utility.trace('-------------');

1345: ----------------------------------------------------------
1346: --Insert Formulas
1347: ----------------------------------------------------------
1348: FOR l_fcount IN 1..lt_F_total(l_ccount) LOOP
1349: hr_utility.trace('-------------');
1350: hr_utility.trace('Inserting record def with formula '
1351: || lt_F_formula_name(li_ftab));
1352: --
1353: l_message:='Error inserting record def with formula '

Line 1350: hr_utility.trace('Inserting record def with formula '

1346: --Insert Formulas
1347: ----------------------------------------------------------
1348: FOR l_fcount IN 1..lt_F_total(l_ccount) LOOP
1349: hr_utility.trace('-------------');
1350: hr_utility.trace('Inserting record def with formula '
1351: || lt_F_formula_name(li_ftab));
1352: --
1353: l_message:='Error inserting record def with formula '
1354: || lt_F_formula_name(li_ftab);

Line 1363: hr_utility.trace('Could not find formula id');

1359: p_legislation_code =>'US',
1360: p_formula_name => lt_F_formula_name(li_ftab));
1361: --
1362: IF l_f_id IS NULL THEN
1363: hr_utility.trace('Could not find formula id');
1364: ELSE hr_utility.trace('Successfully found formula id');
1365: END IF;
1366: --
1367: -- Since lt_F_mag_block_id is used to index into lt_B_mag_block_id,

Line 1364: ELSE hr_utility.trace('Successfully found formula id');

1360: p_formula_name => lt_F_formula_name(li_ftab));
1361: --
1362: IF l_f_id IS NULL THEN
1363: hr_utility.trace('Could not find formula id');
1364: ELSE hr_utility.trace('Successfully found formula id');
1365: END IF;
1366: --
1367: -- Since lt_F_mag_block_id is used to index into lt_B_mag_block_id,
1368: -- take care of NULL values

Line 1371: hr_utility.trace( '--ERROR:NULL block id not allowed');

1367: -- Since lt_F_mag_block_id is used to index into lt_B_mag_block_id,
1368: -- take care of NULL values
1369: --
1370: IF lt_F_mag_block_id(li_ftab) IS NULL THEN
1371: hr_utility.trace( '--ERROR:NULL block id not allowed');
1372: ELSE l_mag_block_id := lt_B_mag_block_id(lt_F_mag_block_id(li_ftab));
1373: END IF;
1374: --
1375: IF lt_F_next_block_id(li_ftab) IS NULL THEN

Line 1380: hr_utility.trace( ' formula_id = '|| l_f_id);

1376: l_next_block_id := NULL;
1377: ELSE l_next_block_id := lt_B_mag_block_id(lt_F_next_block_id(li_ftab));
1378: END IF;
1379: --
1380: hr_utility.trace( ' formula_id = '|| l_f_id);
1381: hr_utility.trace( ' magnetic_block_id = '|| l_mag_block_id);
1382: hr_utility.trace( ' next_block_id = '|| l_next_block_id);
1383: hr_utility.trace( ' last_run_exec_mode = '|| lt_F_last_run_exec_mode(li_ftab));
1384: hr_utility.trace( ' overflow_mode = '|| lt_F_overflow_mode(li_ftab));

Line 1381: hr_utility.trace( ' magnetic_block_id = '|| l_mag_block_id);

1377: ELSE l_next_block_id := lt_B_mag_block_id(lt_F_next_block_id(li_ftab));
1378: END IF;
1379: --
1380: hr_utility.trace( ' formula_id = '|| l_f_id);
1381: hr_utility.trace( ' magnetic_block_id = '|| l_mag_block_id);
1382: hr_utility.trace( ' next_block_id = '|| l_next_block_id);
1383: hr_utility.trace( ' last_run_exec_mode = '|| lt_F_last_run_exec_mode(li_ftab));
1384: hr_utility.trace( ' overflow_mode = '|| lt_F_overflow_mode(li_ftab));
1385: hr_utility.trace( ' sequence = '|| lt_F_sequence(li_ftab));

Line 1382: hr_utility.trace( ' next_block_id = '|| l_next_block_id);

1378: END IF;
1379: --
1380: hr_utility.trace( ' formula_id = '|| l_f_id);
1381: hr_utility.trace( ' magnetic_block_id = '|| l_mag_block_id);
1382: hr_utility.trace( ' next_block_id = '|| l_next_block_id);
1383: hr_utility.trace( ' last_run_exec_mode = '|| lt_F_last_run_exec_mode(li_ftab));
1384: hr_utility.trace( ' overflow_mode = '|| lt_F_overflow_mode(li_ftab));
1385: hr_utility.trace( ' sequence = '|| lt_F_sequence(li_ftab));
1386: hr_utility.trace( ' frequency = '|| lt_F_frequency(li_ftab));

Line 1383: hr_utility.trace( ' last_run_exec_mode = '|| lt_F_last_run_exec_mode(li_ftab));

1379: --
1380: hr_utility.trace( ' formula_id = '|| l_f_id);
1381: hr_utility.trace( ' magnetic_block_id = '|| l_mag_block_id);
1382: hr_utility.trace( ' next_block_id = '|| l_next_block_id);
1383: hr_utility.trace( ' last_run_exec_mode = '|| lt_F_last_run_exec_mode(li_ftab));
1384: hr_utility.trace( ' overflow_mode = '|| lt_F_overflow_mode(li_ftab));
1385: hr_utility.trace( ' sequence = '|| lt_F_sequence(li_ftab));
1386: hr_utility.trace( ' frequency = '|| lt_F_frequency(li_ftab));
1387: --

Line 1384: hr_utility.trace( ' overflow_mode = '|| lt_F_overflow_mode(li_ftab));

1380: hr_utility.trace( ' formula_id = '|| l_f_id);
1381: hr_utility.trace( ' magnetic_block_id = '|| l_mag_block_id);
1382: hr_utility.trace( ' next_block_id = '|| l_next_block_id);
1383: hr_utility.trace( ' last_run_exec_mode = '|| lt_F_last_run_exec_mode(li_ftab));
1384: hr_utility.trace( ' overflow_mode = '|| lt_F_overflow_mode(li_ftab));
1385: hr_utility.trace( ' sequence = '|| lt_F_sequence(li_ftab));
1386: hr_utility.trace( ' frequency = '|| lt_F_frequency(li_ftab));
1387: --
1388: --

Line 1385: hr_utility.trace( ' sequence = '|| lt_F_sequence(li_ftab));

1381: hr_utility.trace( ' magnetic_block_id = '|| l_mag_block_id);
1382: hr_utility.trace( ' next_block_id = '|| l_next_block_id);
1383: hr_utility.trace( ' last_run_exec_mode = '|| lt_F_last_run_exec_mode(li_ftab));
1384: hr_utility.trace( ' overflow_mode = '|| lt_F_overflow_mode(li_ftab));
1385: hr_utility.trace( ' sequence = '|| lt_F_sequence(li_ftab));
1386: hr_utility.trace( ' frequency = '|| lt_F_frequency(li_ftab));
1387: --
1388: --
1389: Pay_Mgr_Ins.Ins

Line 1386: hr_utility.trace( ' frequency = '|| lt_F_frequency(li_ftab));

1382: hr_utility.trace( ' next_block_id = '|| l_next_block_id);
1383: hr_utility.trace( ' last_run_exec_mode = '|| lt_F_last_run_exec_mode(li_ftab));
1384: hr_utility.trace( ' overflow_mode = '|| lt_F_overflow_mode(li_ftab));
1385: hr_utility.trace( ' sequence = '|| lt_F_sequence(li_ftab));
1386: hr_utility.trace( ' frequency = '|| lt_F_frequency(li_ftab));
1387: --
1388: --
1389: Pay_Mgr_Ins.Ins
1390: ( p_formula_id => l_f_id,

Line 1402: hr_utility.trace('Successfully created '|| lt_report_format(l_ccount)

1398: --
1399: li_ftab := li_ftab + 1;
1400: END LOOP;
1401: --
1402: hr_utility.trace('Successfully created '|| lt_report_format(l_ccount)
1403: || ' format mapping..');
1404: --
1405: END LOOP; --for each case
1406: --

Line 1411: hr_utility.trace('Commiting structures...');

1407: ------------------------------------------------------------------------------
1408: --
1409: -- If no exceptions raised during formatting, commit new structures.
1410: --
1411: hr_utility.trace('Commiting structures...');
1412: COMMIT;
1413: --
1414: EXCEPTION --Andy Taylor's Generic Exception Handler
1415: WHEN OTHERS THEN

Line 1417: hr_utility.trace( l_message||' - ORA '||to_char(SQLCODE));

1413: --
1414: EXCEPTION --Andy Taylor's Generic Exception Handler
1415: WHEN OTHERS THEN
1416: --
1417: hr_utility.trace( l_message||' - ORA '||to_char(SQLCODE));
1418: hr_utility.trace(fnd_flex_val_api.message);
1419: --
1420: --
1421: --

Line 1418: hr_utility.trace(fnd_flex_val_api.message);

1414: EXCEPTION --Andy Taylor's Generic Exception Handler
1415: WHEN OTHERS THEN
1416: --
1417: hr_utility.trace( l_message||' - ORA '||to_char(SQLCODE));
1418: hr_utility.trace(fnd_flex_val_api.message);
1419: --
1420: --
1421: --
1422: hr_utility.trace('END REPORT DEFINITION PROCESS----------------------------------');

Line 1422: hr_utility.trace('END REPORT DEFINITION PROCESS----------------------------------');

1418: hr_utility.trace(fnd_flex_val_api.message);
1419: --
1420: --
1421: --
1422: hr_utility.trace('END REPORT DEFINITION PROCESS----------------------------------');
1423: end setup;
1424: --
1425: end pay_1099R_data;