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

Line 80: Purpose : Log a message, either using fnd_file, or hr_utility.trace

76:
77:
78: /******************************************************************************
79: Name : msg
80: Purpose : Log a message, either using fnd_file, or hr_utility.trace
81: ******************************************************************************/
82:
83: PROCEDURE msg(p_text VARCHAR2)
84: IS

Line 94: Purpose : Log a message, either using fnd_file, or hr_utility.trace

90: END msg;
91:
92: /******************************************************************************
93: Name : dbg
94: Purpose : Log a message, either using fnd_file, or hr_utility.trace
95: if debuggging is enabled
96: ******************************************************************************/
97: PROCEDURE dbg(p_text VARCHAR2) IS
98:

Line 107: hr_utility.trace(p_text);

103: -- Write to the concurrent request log
104: fnd_file.put_line(fnd_file.log, p_text);
105: ELSE
106: -- Use HR trace
107: hr_utility.trace(p_text);
108: END IF;
109: END IF;
110:
111: END dbg;

Line 332: hr_utility.set_location(gv_package || lv_procedure_name, 10);

328: BEGIN
329:
330: lv_procedure_name := '.get_payroll_action_info';
331:
332: hr_utility.set_location(gv_package || lv_procedure_name, 10);
333: ln_step := 1;
334: dbg('Entering get_payroll_action_info .......');
335:
336: -- open the cursor to get all the parameters from pay_payroll_actions table

Line 354: hr_utility.set_location(gv_package || lv_procedure_name, 20);

350: ln_tran_gre_id ) ;
351:
352: -- get the report Implementation Date from ln_legal_emp_id and set it to the
353: -- global variable g_report_imp_date
354: hr_utility.set_location(gv_package || lv_procedure_name, 20);
355: ln_step := 2;
356: dbg('Get report Impl date for Legal employer id ' ||to_char(ln_legal_emp_id) );
357:
358: open c_get_imp_date(ln_legal_emp_id) ;

Line 369: hr_utility.set_location(gv_package || lv_procedure_name, 30);

365: close c_get_imp_date;
366: dbg('report impl date is '||to_char(ld_report_imp_date) );
367: g_report_imp_date := ld_report_imp_date;
368:
369: hr_utility.set_location(gv_package || lv_procedure_name, 30);
370: ln_step := 3;
371: dbg('Get Event Group Id ' );
372:
373: open c_get_event_group(gv_event_group) ;

Line 400: hr_utility.set_location(gv_package || lv_procedure_name, 40);

396: dbg('trans gre id : ' || to_char(p_tran_gre_id)) ;
397: dbg('gre id : ' || to_char(p_gre_id)) ;
398: dbg('event group id : ' || to_char(p_event_group_id) );
399:
400: hr_utility.set_location(gv_package || lv_procedure_name, 40);
401: ln_step := 4;
402:
403: dbg('Exiting get_payroll_action_info .......');
404:

Line 411: hr_utility.raise_error;

407: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
408: gv_package || lv_procedure_name;
409:
410: dbg(lv_error_message || '-' || sqlerrm);
411: hr_utility.raise_error;
412:
413: END get_payroll_action_info;
414:
415:

Line 466: hr_utility.set_location(gv_package || lv_procedure_name, 10);

462: g_debug_flag := 'Y' ;
463: -- g_concurrent_flag := 'Y' ;
464:
465: lv_procedure_name := '.range_cursor';
466: hr_utility.set_location(gv_package || lv_procedure_name, 10);
467:
468: lv_func_area := 'SS Affiliation Salary Events' ;
469:
470: -- Get all the parameter information from pay_payroll_actions table

Line 484: hr_utility.set_location(gv_package || lv_procedure_name, 20);

480: ,p_tran_gre_id => ln_tran_gre_id
481: ,p_gre_id => ln_gre_id
482: ,p_event_group_id => ln_event_group_id);
483:
484: hr_utility.set_location(gv_package || lv_procedure_name, 20);
485:
486: -- Check the dynamic triggers are enable for functional area
487: dbg('Check dynamic triggers enabled' ) ;
488:

Line 498: hr_utility.raise_error;

494:
495: dbg('Error : Dynamic triggers NOT enabled' ) ;
496: lv_sql_string := null;
497:
498: hr_utility.raise_error;
499:
500: else
501:
502: dbg('Dynamic triggers Enabled' ) ;

Line 614: hr_utility.set_location(gv_package || lv_procedure_name, 30);

610:
611:
612: end if;
613: end if;
614: hr_utility.set_location(gv_package || lv_procedure_name, 30);
615: p_sqlstr := lv_sql_string;
616: hr_utility.set_location(gv_package || lv_procedure_name, 40);
617:
618: dbg('Exiting range_cursor .......') ;

Line 616: hr_utility.set_location(gv_package || lv_procedure_name, 40);

612: end if;
613: end if;
614: hr_utility.set_location(gv_package || lv_procedure_name, 30);
615: p_sqlstr := lv_sql_string;
616: hr_utility.set_location(gv_package || lv_procedure_name, 40);
617:
618: dbg('Exiting range_cursor .......') ;
619:
620: END range_cursor;

Line 781: hr_utility.set_location(gv_package || lv_procedure_name, 10);

777: -- g_concurrent_flag := 'Y' ;
778:
779: lv_procedure_name := '.action_creation';
780:
781: hr_utility.set_location(gv_package || lv_procedure_name, 10);
782: ln_step := 1;
783: dbg('Get parameter information from pay_payroll_actions table' ) ;
784:
785: get_payroll_action_info( p_payroll_action_id => p_payroll_action_id

Line 796: hr_utility.set_location(gv_package || lv_procedure_name, 20);

792: ,p_tran_gre_id => ln_tran_gre_id
793: ,p_gre_id => ln_gre_id
794: ,p_event_group_id => ln_event_group_id);
795:
796: hr_utility.set_location(gv_package || lv_procedure_name, 20);
797: ln_step := 2;
798: dbg('Action creation Query parameters') ;
799: dbg('Start person id : ' || to_char(p_start_person_id));
800: dbg('End person id : ' || to_char(p_end_person_id));

Line 836: hr_utility.set_location(gv_package || lv_procedure_name, 30);

832: end if ;
833:
834:
835: -- Loop for all rows returned for SQL statement.
836: hr_utility.set_location(gv_package || lv_procedure_name, 30);
837: ln_step := 3;
838:
839: loop
840:

Line 856: hr_utility.set_location(gv_package || lv_procedure_name, 40);

852: end if;
853: -- if gre_id is not null then tax_unit_id= gre_id
854: -- if tran_gre_id is not null then tax_unit_id = tran_gre_id
855:
856: hr_utility.set_location(gv_package || lv_procedure_name, 40);
857: ln_step := 4;
858: dbg('creating aaid for assignment_id = ' || to_char(ln_assignment_id) ||
859: ' Tax Unit Id = ' || to_char(nvl(ln_gre_id,ln_tran_gre_id)) ) ;
860:

Line 890: hr_utility.set_location(gv_package || lv_procedure_name, 50);

886: close c_get_all_sal_asg ;
887:
888: end if;
889:
890: hr_utility.set_location(gv_package || lv_procedure_name, 50);
891: ln_step := 5;
892:
893: dbg('Exiting Action creation ..............') ;
894:

Line 901: hr_utility.raise_error;

897: when others then
898: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
899: gv_package || lv_procedure_name;
900: dbg(lv_error_message || '-' || sqlerrm);
901: hr_utility.raise_error;
902:
903: END action_creation;
904:
905: /******************************************************************************

Line 930: hr_utility.set_location(gv_package || lv_procedure_name, 10);

926: -- g_concurrent_flag := 'Y' ;
927:
928: lv_procedure_name := '.archinit';
929:
930: hr_utility.set_location(gv_package || lv_procedure_name, 10);
931: ln_step := 1;
932:
933: dbg('Exiting archinit .............');
934:

Line 1086: hr_utility.set_location(gv_package || lv_procedure_name, 10);

1082: lv_layout_identifier := '9' ;
1083:
1084:
1085: ln_step := 1;
1086: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1087:
1088: dbg('Get employer ssid ');
1089: -- get employer ss id for p_tax_unit_id
1090: open c_get_er_ss_number(p_tax_unit_id) ;

Line 1095: hr_utility.set_location(gv_package || lv_procedure_name, 20);

1091: fetch c_get_er_ss_number into lv_er_ss_number ;
1092: close c_get_er_ss_number ;
1093:
1094: ln_step := 2;
1095: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1096:
1097: dbg('Get IMSS waybill for gre '|| to_char(p_tax_unit_id) );
1098:
1099: -- get IMSS Waybill for p_tax_unit_id

Line 1124: hr_utility.set_location(gv_package || lv_procedure_name, 30);

1120:
1121: dbg('way bill number is ' || lv_imss_way_bill );
1122:
1123: ln_step := 3;
1124: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1125:
1126: dbg('Get salary details from assignment ' );
1127: dbg('Assignment Id : ' || to_char(p_assignment_id) );
1128: dbg('Effective Date : ' || to_char(p_effective_date,'DD-MON-YYYY'));

Line 1148: hr_utility.set_location(gv_package || lv_procedure_name, 40);

1144:
1145: close c_get_salary_details ;
1146:
1147: ln_step := 4;
1148: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1149:
1150: dbg('Get reduced working week indicator from workschedule ' );
1151:
1152: -- derive Reduced Working-week indicator from workschedule

Line 1161: hr_utility.set_location(gv_package || lv_procedure_name, 50);

1157: end if;
1158:
1159:
1160: ln_step := 5;
1161: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1162:
1163: dbg('Get IDW' );
1164:
1165: if p_report_mode = 'F' then -- Fixed Salary

Line 1217: hr_utility.set_location(gv_package || lv_procedure_name, 60);

1213:
1214: dbg('IDW with 2 decimal '||to_char(ln_idw) );
1215:
1216: ln_step := 6;
1217: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1218:
1219: dbg('call api to insert the record in pay action information with parameters' );
1220: msg('Action_information_category : ' || 'MX SS SALARY DETAILS' );
1221: msg('Action Context Id : ' || to_char(p_assignment_action_id) );

Line 1277: hr_utility.set_location(gv_package || lv_procedure_name, 70);

1273:
1274: msg('Successfully Archived. Action Information Id is : ' || to_char(ln_action_information_id) );
1275:
1276: ln_step := 7;
1277: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1278:
1279: dbg('Exiting archive_salary_details .........');
1280:
1281: EXCEPTION

Line 1288: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

1284: gv_package || lv_procedure_name;
1285:
1286: dbg(lv_error_message || '-' || sqlerrm);
1287:
1288: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1289: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1290: hr_utility.raise_error;
1291:
1292: END archive_salary_details ;

Line 1289: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);

1285:
1286: dbg(lv_error_message || '-' || sqlerrm);
1287:
1288: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1289: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1290: hr_utility.raise_error;
1291:
1292: END archive_salary_details ;
1293:

Line 1290: hr_utility.raise_error;

1286: dbg(lv_error_message || '-' || sqlerrm);
1287:
1288: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1289: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1290: hr_utility.raise_error;
1291:
1292: END archive_salary_details ;
1293:
1294:

Line 1383: hr_utility.set_location(gv_package || lv_procedure_name, 10);

1379: dbg('Entering archive data ...........');
1380: dbg('assignment action id is ' || to_char(p_assignment_action_id) );
1381:
1382: lv_procedure_name := '.archive_data';
1383: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1384: ln_step := 1;
1385:
1386: dbg('Get Payroll Action Id ');
1387: open c_asg_action_info (p_assignment_action_id);

Line 1394: hr_utility.set_location(gv_package || lv_procedure_name, 20);

1390: ln_tax_unit_id ;
1391: close c_asg_action_info;
1392: dbg('Payroll action id' || to_char(ln_payroll_action_id) );
1393:
1394: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1395: ln_step := 2;
1396: dbg('Get parameter information from pay_payroll_actions table' ) ;
1397: get_payroll_action_info( p_payroll_action_id => ln_payroll_action_id
1398: ,p_report_mode => lv_report_mode

Line 1408: hr_utility.set_location(gv_package || lv_procedure_name, 30);

1404: ,p_tran_gre_id => ln_tran_gre_id
1405: ,p_gre_id => ln_gre_id
1406: ,p_event_group_id => ln_event_group_id);
1407:
1408: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1409: ln_step := 3;
1410:
1411:
1412: if lv_report_mode = 'F' then -- Fixed Salary

Line 1474: hr_utility.set_location(gv_package || lv_procedure_name, 40);

1470: ) ;
1471:
1472: end if;
1473:
1474: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1475:
1476: dbg('Exiting archive data ...........');
1477:
1478: EXCEPTION

Line 1483: hr_utility.raise_error;

1479: when others then
1480: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
1481: gv_package || lv_procedure_name;
1482: dbg(lv_error_message || '-' || sqlerrm);
1483: hr_utility.raise_error;
1484:
1485: end archive_data;
1486:
1487:

Line 1489: --hr_utility.trace_on (null, 'SSAFFLSAL');

1485: end archive_data;
1486:
1487:
1488: --begin
1489: --hr_utility.trace_on (null, 'SSAFFLSAL');
1490:
1491: end pay_mx_ssaffl_salary;