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.PQP_GB_MILEAGE_CLAIM_PKG dependencies on HR_UTILITY

Line 262: hr_utility.set_location('Enter get payroll id',10);

258: l_get_asg_det c_get_asg_det%ROWTYPE;
259: l_proc varchar2(72) := g_package ||'get_payroll_id';
260: BEGIN
261:
262: hr_utility.set_location('Enter get payroll id',10);
263: OPEN c_get_asg_det ( p_assignment_id
264: ,p_business_group_id
265: ,p_effective_date
266: );

Line 268: hr_utility.set_location('Inside the Loop',15);

264: ,p_business_group_id
265: ,p_effective_date
266: );
267: FETCH c_get_asg_det INTO l_get_asg_det;
268: hr_utility.set_location('Inside the Loop',15);
269: IF c_get_asg_det%NOTFOUND THEN
270: RETURN(-1);
271: ELSE
272: p_payroll_id:=l_get_asg_det.payroll_id;

Line 279: hr_utility.set_location(' Leaving get payroll id',20);

275: END IF;
276: CLOSE c_get_asg_det;
277:
278:
279: hr_utility.set_location(' Leaving get payroll id',20);
280:
281: END;
282: --Decides effective date to create an element entry
283: FUNCTION get_effective_date (p_assignment_id IN NUMBER

Line 334: hr_utility.set_location(l_proc,10);

330: l_get_alt_payroll_det c_get_alt_payroll_det%ROWTYPE;
331: l_effective_date DATE;
332: l_proc varchar2(72) := g_package ||'get_effective_date';
333: BEGIN
334: hr_utility.set_location(l_proc,10);
335: OPEN c_get_payroll_det ( p_assignment_id
336: ,p_business_group_id
337: ,p_payroll_id
338: ,p_effective_date

Line 349: hr_utility.set_location(l_proc,20);

345: FETCH c_get_alt_payroll_det INTO l_get_payroll_det;
346:
347: CLOSE c_get_alt_payroll_det;
348: END IF;
349: hr_utility.set_location(l_proc,20);
350: CLOSE c_get_payroll_det;
351: IF p_effective_date BETWEEN l_get_payroll_det.start_date
352: AND l_get_payroll_det.end_date
353: OR p_effective_date > l_get_payroll_det.end_date THEN

Line 360: hr_utility.set_location(l_proc,30);

356: l_effective_date :=l_get_payroll_det.start_date;
357: END IF;
358:
359: RETURN(l_effective_date);
360: hr_utility.set_location(l_proc,30);
361: END;
362:
363: FUNCTION get_asg_element (p_assignment_id IN NUMBER,
364: p_business_group_id IN NUMBER,

Line 412: hr_utility.set_location('Inside get asg element'||l_proc,10);

408: l_proc varchar2(72) := g_package ||'get_asg_element';
409: l_get_asg_element c_get_asg_element%ROWTYPE;
410: l_ele_type c_ele_type%ROWTYPE;
411: BEGIN
412: hr_utility.set_location('Inside get asg element'||l_proc,10);
413: OPEN c_get_asg_element (
414: p_assignment_id
415: ,p_business_group_id
416: ,p_effective_date

Line 426: hr_utility.set_location(l_proc,20);

422:
423: OPEN c_ele_type (l_get_asg_element.element_type_id);
424: FETCH c_ele_type INTO l_ele_type;
425: CLOSE c_ele_type;
426: hr_utility.set_location(l_proc,20);
427:
428: IF p_check_type='E' AND (l_ele_type.ele_type=p_sl_rates_type) THEN
429: RETURN(NVL(l_get_asg_element.element_type_id,-1));
430: ELSE

Line 440: hr_utility.set_location('leaving get asg element'||l_proc,30);

436: ELSIF p_check_type='R' AND p_sl_rates_type ='Y' THEN
437:
438: RETURN(NVL(l_get_asg_element.sliding_rates,-1));
439: END IF;
440: hr_utility.set_location('leaving get asg element'||l_proc,30);
441: END;
442:
443: --Get default rates if entered
444: FUNCTION get_default_value(p_business_group_id IN NUMBER

Line 472: hr_utility.set_location(l_proc,10);

468: l_get_rate_id c_get_rate_id%ROWTYPE;
469: l_proc varchar2(72) := g_package ||'get_default_value';
470:
471: BEGIN
472: hr_utility.set_location(l_proc,10);
473: OPEN c_get_default_value;
474: FETCH c_get_default_value INTO l_get_default_value;
475: IF c_get_default_value%FOUND THEN
476: OPEN c_get_rate_id(l_get_default_value.default_value);

Line 486: hr_utility.set_location(l_proc,20);

482: RETURN(-1);
483: END IF;
484: CLOSE c_get_default_value;
485:
486: hr_utility.set_location(l_proc,20);
487: END;
488:
489:
490: --Validate Mileage Element.

Line 580: hr_utility.set_location(l_proc,10);

576: l_proc varchar2(72) := g_package ||'validate_mileage_element';
577: l_validate_mileage_element c_validate_mileage_element%ROWTYPE;
578: BEGIN
579:
580: hr_utility.set_location(l_proc,10);
581:
582: OPEN c_validate_mileage_element( p_assignment_id
583: ,p_business_group_id
584: ,p_effective_date

Line 594: hr_utility.set_location(l_proc,20);

590: LOOP
591: FETCH c_validate_mileage_element INTO
592: l_validate_mileage_element;
593: EXIT WHEN c_validate_mileage_element%NOTFOUND;
594: hr_utility.set_location(l_proc,20);
595: IF l_validate_mileage_element.element_type_id IS NOT NULL THEN
596: p_element_link_id := l_validate_mileage_element.element_link_id;
597: RETURN(l_validate_mileage_element.element_type_id);
598: EXIT;

Line 607: hr_utility.set_location(l_proc,30);

603: p_element_link_id :=-1;
604: RETURN(-1);
605: END IF;
606:
607: hr_utility.set_location(l_proc,30);
608: EXCEPTION
609: --------
610: WHEN OTHERS THEN
611: RETURN(-1);

Line 612: hr_utility.set_location(l_proc,40);

608: EXCEPTION
609: --------
610: WHEN OTHERS THEN
611: RETURN(-1);
612: hr_utility.set_location(l_proc,40);
613: END;
614:
615: --Get eligible mileage element if no element is entered at
616: --all levels.

Line 709: hr_utility.set_location(l_proc,10);

705: l_get_elig_mileage_element c_get_elig_mileage_element%ROWTYPE;
706: l_validate_mileage_element pay_element_types_f.element_type_id%TYPE;
707: BEGIN
708:
709: hr_utility.set_location(l_proc,10);
710: OPEN c_get_elig_mileage_element( p_assignment_id
711: ,p_business_group_id
712: ,p_effective_date
713: ,p_vehicle_type

Line 721: hr_utility.set_location(' Enter validate element:' || l_proc,100);

717: LOOP
718: FETCH c_get_elig_mileage_element INTO
719: l_get_elig_mileage_element;
720: EXIT WHEN c_get_elig_mileage_element%NOTFOUND;
721: hr_utility.set_location(' Enter validate element:' || l_proc,100);
722: l_validate_mileage_element:= validate_mileage_element(
723: p_assignment_id =>p_assignment_id
724: ,p_business_group_id =>p_business_group_id
725: ,p_effective_date =>p_effective_date

Line 733: hr_utility.set_location(l_proc,20);

729: =>l_get_elig_mileage_element.element_type_id
730: ,p_sl_rate_type =>p_sl_rate_type
731: ,p_element_link_id =>p_element_link_id
732: );
733: hr_utility.set_location(l_proc,20);
734: IF l_validate_mileage_element <> -1 THEN
735: RETURN(l_get_elig_mileage_element.element_type_id);
736: EXIT;
737: END IF;

Line 741: hr_utility.set_location(l_proc,30);

737: END IF;
738: END LOOP;
739: CLOSE c_get_elig_mileage_element;
740:
741: hr_utility.set_location(l_proc,30);
742: IF l_get_elig_mileage_element.element_type_id IS NULL
743: OR l_validate_mileage_element =-1 THEN
744: RETURN(-1);
745: END IF;

Line 747: hr_utility.set_location(l_proc,40);

743: OR l_validate_mileage_element =-1 THEN
744: RETURN(-1);
745: END IF;
746:
747: hr_utility.set_location(l_proc,40);
748: EXCEPTION
749: --------
750: WHEN OTHERS THEN
751: RETURN(-1);

Line 752: hr_utility.set_location(l_proc,50);

748: EXCEPTION
749: --------
750: WHEN OTHERS THEN
751: RETURN(-1);
752: hr_utility.set_location(l_proc,50);
753: END;
754:
755: --Check if CC is available in the repository
756: FUNCTION get_cc (p_effective_date IN DATE,

Line 776: hr_utility.set_location(l_proc,10);

772: l_get_cc c_get_cc%ROWTYPE;
773: l_proc varchar2(72) := g_package ||'get_cc';
774: BEGIN
775:
776: hr_utility.set_location(l_proc,10);
777: OPEN c_get_cc;
778: FETCH c_get_cc INTO l_get_cc;
779: IF c_get_cc%FOUND THEN
780: p_engine_capacity :=l_get_cc.engine_capacity;

Line 782: hr_utility.set_location(l_proc,20);

778: FETCH c_get_cc INTO l_get_cc;
779: IF c_get_cc%FOUND THEN
780: p_engine_capacity :=l_get_cc.engine_capacity;
781: RETURN ('Y');
782: hr_utility.set_location(l_proc,20);
783: ELSE
784: RETURN ('N');
785: hr_utility.set_location(l_proc,30);
786: END IF;

Line 785: hr_utility.set_location(l_proc,30);

781: RETURN ('Y');
782: hr_utility.set_location(l_proc,20);
783: ELSE
784: RETURN ('N');
785: hr_utility.set_location(l_proc,30);
786: END IF;
787: CLOSE c_get_cc;
788:
789: hr_utility.set_location(l_proc,40);

Line 789: hr_utility.set_location(l_proc,40);

785: hr_utility.set_location(l_proc,30);
786: END IF;
787: CLOSE c_get_cc;
788:
789: hr_utility.set_location(l_proc,40);
790: EXCEPTION
791: --------
792: WHEN OTHERS THEN
793: hr_utility.set_location(l_proc,50);

Line 793: hr_utility.set_location(l_proc,50);

789: hr_utility.set_location(l_proc,40);
790: EXCEPTION
791: --------
792: WHEN OTHERS THEN
793: hr_utility.set_location(l_proc,50);
794: RETURN ('N');
795:
796: END;
797:

Line 908: hr_utility.set_location(' Enter:' || l_proc,10);

904: l_sliding_rates VARCHAR2(1);
905: l_paye_taxable VARCHAR2(3);
906: BEGIN
907: l_paye_taxable :=p_paye_taxable;
908: hr_utility.set_location(' Enter:' || l_proc,10);
909:
910: IF p_user_type='PUI' THEN
911: l_user_type := pqp_car_mileage_functions.get_config_info
912: (p_business_group_id => p_business_group_id

Line 947: hr_utility.set_location(' Enter payroll check cursor:' || l_proc,20);

943:
944: l_engine_capacity:='0';
945: END IF;
946:
947: hr_utility.set_location(' Enter payroll check cursor:' || l_proc,20);
948:
949: ---Get assignemnt payroll info.
950: l_ret_mesg:=get_payroll_id
951: (p_assignment_id =>p_assignment_id

Line 962: hr_utility.set_location(' Enter payroll details cursor:' || l_proc,30);

958: fnd_message.raise_error;
959: hr_multi_message.end_validation_set;
960: END IF;
961:
962: hr_utility.set_location(' Enter payroll details cursor:' || l_proc,30);
963: --get next unprocessed payroll date for that asg.
964: --If the effective date is in between or less then
965: --payroll run date then the date the element
966: --entry created will be effective date or the start date

Line 977: hr_utility.set_location(' Enter check eligibility:' || l_proc,40);

973: ,p_payroll_id =>l_get_pay_det
974: ,p_effective_date =>p_effective_date
975: );
976:
977: hr_utility.set_location(' Enter check eligibility:' || l_proc,40);
978: --Check for claim eligibility
979: l_chk_eligibility:=pqp_gb_mileage_claim_pkg.
980: chk_eligibility (
981: p_effective_date =>l_effective_date

Line 1000: hr_utility.set_location(' Enter Assignment level Element search:' || l_proc,50);

996: IF l_chk_eligibility = 'N' THEN
997: fnd_message.raise_error;
998: hr_multi_message.end_validation_set;
999: END IF;
1000: hr_utility.set_location(' Enter Assignment level Element search:' || l_proc,50);
1001: --Find if element is present at the assignment level
1002:
1003: IF p_mileage_claim_element IS NULL THEN
1004: IF p_user_type='SS' OR ( p_user_type='PUI' AND l_user_type='Y') THEN

Line 1033: hr_utility.set_location(' Enter config level Element search:' || l_proc,60);

1029: ,p_sl_rates_type =>l_sliding_rates
1030: );
1031:
1032: END IF;
1033: hr_utility.set_location(' Enter config level Element search:' || l_proc,60);
1034: --if element is not present at assignment level then fetch from conf table
1035: IF (l_get_asg_element_id IS NULL OR l_get_asg_element_id=-1 )
1036: AND l_get_purp_element_id IS NULL THEN
1037: pqp_gb_mileage_claim_pkg.get_config_info (

Line 1057: hr_utility.set_location(' Enter db level element search:' || l_proc,90);

1053: l_element_type_id :=to_number(p_mileage_claim_element);
1054: END IF;
1055:
1056:
1057: hr_utility.set_location(' Enter db level element search:' || l_proc,90);
1058: --If no element is entered in all levels then
1059: --it must be searched in the database and validated.
1060: IF l_element_type_id IS NULL THEN
1061: l_elig_mileage_element_id:=get_elig_mileage_element

Line 1110: hr_utility.set_location(' Enter element link search:' || l_proc,110);

1106: fnd_message.raise_error;
1107: hr_multi_message.end_validation_set;
1108: END IF;
1109:
1110: hr_utility.set_location(' Enter element link search:' || l_proc,110);
1111: /* OPEN c_get_ele_link (l_element_type_id
1112: ,l_effective_date
1113: ,p_business_group_id
1114: );

Line 1122: hr_utility.set_location(' Enter Assignment level rates search:' || l_proc,70);

1118: l_element_link_id:=l_get_ele_link.element_link_id;
1119: END LOOP;
1120: CLOSE c_get_ele_link;*/
1121:
1122: hr_utility.set_location(' Enter Assignment level rates search:' || l_proc,70);
1123: --If Rates is Null ,then fetch from assignment level
1124: IF p_user_rates_table IS NULL THEN
1125: IF p_user_type='SS' OR ( p_user_type='PUI' AND l_user_type='Y') THEN
1126: hr_utility.set_location(' Enter Assignment If condition:' || l_proc,80);

Line 1126: hr_utility.set_location(' Enter Assignment If condition:' || l_proc,80);

1122: hr_utility.set_location(' Enter Assignment level rates search:' || l_proc,70);
1123: --If Rates is Null ,then fetch from assignment level
1124: IF p_user_rates_table IS NULL THEN
1125: IF p_user_type='SS' OR ( p_user_type='PUI' AND l_user_type='Y') THEN
1126: hr_utility.set_location(' Enter Assignment If condition:' || l_proc,80);
1127: l_rates_table_id:=l_purp_rates_table;
1128: END IF;
1129: IF l_rates_table_id IS NULL THEN
1130: hr_utility.set_location(' Enter Assignment Second If condition:' || l_proc,80);

Line 1130: hr_utility.set_location(' Enter Assignment Second If condition:' || l_proc,80);

1126: hr_utility.set_location(' Enter Assignment If condition:' || l_proc,80);
1127: l_rates_table_id:=l_purp_rates_table;
1128: END IF;
1129: IF l_rates_table_id IS NULL THEN
1130: hr_utility.set_location(' Enter Assignment Second If condition:' || l_proc,80);
1131: l_get_asg_rate_id:= get_asg_element
1132: (p_assignment_id =>p_assignment_id
1133: ,p_business_group_id =>p_business_group_id
1134: ,p_effective_date =>p_effective_date

Line 1144: hr_utility.set_location(' Enter conf level rates search:' || l_proc,80);

1140: );
1141: END IF;
1142: --if rates table is not present at assignment level
1143: --then fetch from conf table
1144: hr_utility.set_location(' Enter conf level rates search:' || l_proc,80);
1145: IF (l_get_asg_rate_id IS NULL OR l_get_asg_rate_id=-1 ) AND
1146: l_rates_table_id IS NULL THEN
1147: l_get_element_type_id := l_element_type_id;
1148: pqp_gb_mileage_claim_pkg.get_config_info (

Line 1182: hr_utility.set_location(' Enter mndtry field chk:' || l_proc,120);

1178: l_rates_table_id :=(p_user_rates_table);
1179: END IF;
1180:
1181:
1182: hr_utility.set_location(' Enter mndtry field chk:' || l_proc,120);
1183: --All mandatory field validations
1184: l_chk_mndtry:= chk_mndtry_fields (
1185: p_effective_date =>p_effective_date
1186: ,p_assignment_id =>p_assignment_id

Line 1212: hr_utility.set_location(' Enter company mileage:' || l_proc,130);

1208:
1209: --Input values are vary from Private to Company vehicles
1210: --So inserting the values besed on ownership
1211: IF p_ownership='C' THEN
1212: hr_utility.set_location(' Enter company mileage:' || l_proc,130);
1213: insert_company_mileage_claim
1214: ( p_effective_date =>l_effective_date
1215: ,p_assignment_id =>p_assignment_id
1216: ,p_business_group_id =>p_business_group_id

Line 1241: hr_utility.set_location(' Enter private mileage:' || l_proc,140);

1237: ,p_element_link_id =>l_element_link_id
1238: );
1239:
1240: ELSIF p_ownership='P' THEN
1241: hr_utility.set_location(' Enter private mileage:' || l_proc,140);
1242: insert_private_mileage_claim
1243: ( p_effective_date =>l_effective_date
1244: ,p_assignment_id =>p_assignment_id
1245: ,p_business_group_id =>p_business_group_id

Line 1271: hr_utility.set_location(' Enter WEBADI:' || l_proc,150);

1267: );
1268: END IF;
1269: --This call is for webADI related stuff
1270: ELSIF p_info_id IS NOT NULL THEN
1271: hr_utility.set_location(' Enter WEBADI:' || l_proc,150);
1272: l_assignment_id := substr(p_info_id,1,instr(p_info_id,l_string)-1);
1273: -- l_businesss_group_id:=substr(p_info_id,instr(p_info_id,l_string)+LENGTH(l_string),
1274: -- instr(p_info_id,l_string,1,2)-instr(p_info_id,l_string)-LENGTH(l_string));
1275: -- l_session_id :=substr(p_info_id,instr(p_info_id,l_string,1,2)+LENGTH(l_string)) ;

Line 1338: hr_utility.set_location(' Enter delete claim import:' || l_proc,160);

1334: ,p_return_status OUT NOCOPY VARCHAR2
1335: ) AS
1336: l_proc varchar2(72) := g_package ||'delete_claim_import';
1337: BEGIN
1338: hr_utility.set_location(' Enter delete claim import:' || l_proc,160);
1339: DELETE
1340: FROM pay_us_rpt_totals
1341: WHERE GRE_NAME = p_info_id
1342: AND business_group_id = p_business_group_id

Line 1353: hr_utility.set_location('Leaving delete mileage:' || l_proc,170);

1349: AND (p_effective_date-fnd_date.canonical_to_date(state_name))>1;
1350:
1351: COMMIT;
1352: p_return_status := 'S';
1353: hr_utility.set_location('Leaving delete mileage:' || l_proc,170);
1354: exception
1355: when others then
1356: p_return_status := 'E';
1357: END;

Line 1447: hr_utility.set_location('Enter update Claim:' || l_proc,10);

1443: l_get_end_date c_get_end_date%ROWTYPE;
1444: l_proc varchar2(72) := g_package ||'update_mileage_claim';
1445: BEGIN
1446:
1447: hr_utility.set_location('Enter update Claim:' || l_proc,10);
1448: OPEN c_get_end_date;
1449: LOOP
1450: FETCH c_get_end_date INTO l_get_end_date;
1451: EXIT WHEN c_get_end_date%NOTFOUND;

Line 1455: hr_utility.set_location(l_proc,20);

1451: EXIT WHEN c_get_end_date%NOTFOUND;
1452:
1453: END LOOP;
1454: CLOSE c_get_end_date;
1455: hr_utility.set_location(l_proc,20);
1456: OPEN c_get_input_value;
1457: LOOP
1458: FETCH c_get_input_value INTO l_get_input_value;
1459: EXIT WHEN c_get_input_value%NOTFOUND;

Line 1460: hr_utility.set_location('Enter set input values:' || l_proc,30);

1456: OPEN c_get_input_value;
1457: LOOP
1458: FETCH c_get_input_value INTO l_get_input_value;
1459: EXIT WHEN c_get_input_value%NOTFOUND;
1460: hr_utility.set_location('Enter set input values:' || l_proc,30);
1461: IF l_get_input_value.name='Vehicle Type'OR
1462: l_get_input_value.name='Rate Type' THEN
1463: l_input_value_id_tbl(l_input_value_id_tbl.count +1)
1464: :=l_get_input_value.input_value_id;

Line 1469: hr_utility.set_location(l_proc,40);

1465: l_entry_value_tbl(l_entry_value_tbl.count+1)
1466: :=get_lkp_meaning(p_usage_type
1467: ,l_get_input_value.lookup_type);
1468: ELSIF l_get_input_value.name='Claimed Mileage' THEN
1469: hr_utility.set_location(l_proc,40);
1470: l_input_value_id_tbl(l_input_value_id_tbl.count +1)
1471: :=l_get_input_value.input_value_id;
1472: l_entry_value_tbl(l_entry_value_tbl.count+1)
1473: :=p_claimed_mileage;

Line 1475: hr_utility.set_location(l_proc,50);

1471: :=l_get_input_value.input_value_id;
1472: l_entry_value_tbl(l_entry_value_tbl.count+1)
1473: :=p_claimed_mileage;
1474: ELSIF l_get_input_value.name='Actual Mileage' THEN
1475: hr_utility.set_location(l_proc,50);
1476: l_input_value_id_tbl(l_input_value_id_tbl.count +1)
1477: :=l_get_input_value.input_value_id;
1478:
1479: l_entry_value_tbl(l_entry_value_tbl.count+1)

Line 1482: hr_utility.set_location(l_proc,60);

1478:
1479: l_entry_value_tbl(l_entry_value_tbl.count+1)
1480: :=p_actual_mileage;
1481: ELSIF l_get_input_value.name='Claim Start Date' THEN
1482: hr_utility.set_location(l_proc,60);
1483: l_input_value_id_tbl(l_input_value_id_tbl.count +1)
1484: :=l_get_input_value.input_value_id;
1485:
1486: l_entry_value_tbl(l_entry_value_tbl.count+1)

Line 1489: hr_utility.set_location(l_proc,70);

1485:
1486: l_entry_value_tbl(l_entry_value_tbl.count+1)
1487: :=p_start_date;
1488: ELSIF l_get_input_value.name='Claim End Date' THEN
1489: hr_utility.set_location(l_proc,70);
1490: l_input_value_id_tbl(l_input_value_id_tbl.count +1)
1491: :=l_get_input_value.input_value_id;
1492:
1493: l_entry_value_tbl(l_entry_value_tbl.count+1)

Line 1496: hr_utility.set_location(l_proc,80);

1492:
1493: l_entry_value_tbl(l_entry_value_tbl.count+1)
1494: :=p_end_date;
1495: ELSIF l_get_input_value.name='User Rates Table' THEN
1496: hr_utility.set_location(l_proc,80);
1497: l_input_value_id_tbl(l_input_value_id_tbl.count +1)
1498: :=l_get_input_value.input_value_id;
1499:
1500:

Line 1511: hr_utility.set_location(l_proc,90);

1507: CLOSE c_get_table_name;
1508:
1509: IF l_get_table_name.user_table_name IS NULL THEN
1510:
1511: hr_utility.set_location(l_proc,90);
1512: l_entry_value_tbl(l_entry_value_tbl.count+1)
1513: :=l_get_input_value.default_value;
1514: ELSE
1515:

Line 1516: hr_utility.set_location(l_proc,100);

1512: l_entry_value_tbl(l_entry_value_tbl.count+1)
1513: :=l_get_input_value.default_value;
1514: ELSE
1515:
1516: hr_utility.set_location(l_proc,100);
1517: l_entry_value_tbl(l_entry_value_tbl.count+1)
1518: :=l_get_table_name.user_table_name;
1519:
1520: END IF;

Line 1522: hr_utility.set_location(l_proc,110);

1518: :=l_get_table_name.user_table_name;
1519:
1520: END IF;
1521: ELSIF l_get_input_value.name='No of Passengers' THEN
1522: hr_utility.set_location(l_proc,110);
1523: l_input_value_id_tbl(l_input_value_id_tbl.count +1)
1524: :=l_get_input_value.input_value_id;
1525:
1526: l_entry_value_tbl(l_entry_value_tbl.count+1)

Line 1529: hr_utility.set_location(l_proc,120);

1525:
1526: l_entry_value_tbl(l_entry_value_tbl.count+1)
1527: :=p_no_of_passengers;
1528: ELSIF l_get_input_value.name='CO2 Emissions' THEN
1529: hr_utility.set_location(l_proc,120);
1530: l_input_value_id_tbl(l_input_value_id_tbl.count +1)
1531: :=l_get_input_value.input_value_id;
1532:
1533: l_entry_value_tbl(l_entry_value_tbl.count+1)

Line 1536: hr_utility.set_location(l_proc,130);

1532:
1533: l_entry_value_tbl(l_entry_value_tbl.count+1)
1534: :=p_fiscal_ratings;
1535: ELSIF l_get_input_value.name='Calculation Method' THEN
1536: hr_utility.set_location(l_proc,130);
1537: l_input_value_id_tbl(l_input_value_id_tbl.count +1)
1538: :=l_get_input_value.input_value_id;
1539:
1540: /*IF p_calculation_method IS NULL THEN

Line 1560: hr_utility.set_location(l_proc,140);

1556: :=NVL(p_calculation_method,
1557: l_get_input_value.default_value);
1558: END IF;
1559: ELSIF l_get_input_value.name='PAYE Taxable' THEN
1560: hr_utility.set_location(l_proc,140);
1561: l_input_value_id_tbl(l_input_value_id_tbl.count +1)
1562: :=l_get_input_value.input_value_id;
1563:
1564: IF l_get_input_value.lookup_type IS NOT NULL THEN

Line 1573: hr_utility.set_location(l_proc,70);

1569: l_entry_value_tbl(l_entry_value_tbl.count+1):= p_PAYE_Taxable;
1570: END IF;
1571:
1572: ELSIF l_get_input_value.name='Purpose' THEN
1573: hr_utility.set_location(l_proc,70);
1574: l_input_value_id_tbl(l_input_value_id_tbl.count +1)
1575: :=l_get_input_value.input_value_id;
1576:
1577: l_entry_value_tbl(l_entry_value_tbl.count+1)

Line 1589: hr_utility.set_location(l_proc,150);

1585: CLOSE c_get_input_value;
1586:
1587: IF l_get_end_date.effective_end_date <> hr_api.g_eot
1588: THEN
1589: hr_utility.set_location(l_proc,150);
1590: IF p_claimed_mileage_o <> p_claimed_mileage OR
1591: p_actual_mileage_o <> p_actual_mileage THEN
1592: hr_utility.set_location(l_proc,160);
1593: hr_utility.set_location('Enter delete api:' || l_proc,200);

Line 1592: hr_utility.set_location(l_proc,160);

1588: THEN
1589: hr_utility.set_location(l_proc,150);
1590: IF p_claimed_mileage_o <> p_claimed_mileage OR
1591: p_actual_mileage_o <> p_actual_mileage THEN
1592: hr_utility.set_location(l_proc,160);
1593: hr_utility.set_location('Enter delete api:' || l_proc,200);
1594: hr_entry_api.delete_element_entry
1595: (
1596: p_dt_delete_mode =>l_delete_mode,

Line 1593: hr_utility.set_location('Enter delete api:' || l_proc,200);

1589: hr_utility.set_location(l_proc,150);
1590: IF p_claimed_mileage_o <> p_claimed_mileage OR
1591: p_actual_mileage_o <> p_actual_mileage THEN
1592: hr_utility.set_location(l_proc,160);
1593: hr_utility.set_location('Enter delete api:' || l_proc,200);
1594: hr_entry_api.delete_element_entry
1595: (
1596: p_dt_delete_mode =>l_delete_mode,
1597: p_session_date =>p_effective_date,

Line 1604: hr_utility.set_location(l_proc,170);

1600: END IF;
1601:
1602: END IF;
1603:
1604: hr_utility.set_location(l_proc,170);
1605: hr_utility.set_location('Enter correction:' || l_proc,210);
1606: hr_entry_api.update_element_entry
1607: (
1608: p_dt_update_mode =>l_update_mode,

Line 1605: hr_utility.set_location('Enter correction:' || l_proc,210);

1601:
1602: END IF;
1603:
1604: hr_utility.set_location(l_proc,170);
1605: hr_utility.set_location('Enter correction:' || l_proc,210);
1606: hr_entry_api.update_element_entry
1607: (
1608: p_dt_update_mode =>l_update_mode,
1609: p_session_date =>p_effective_date,

Line 1619: hr_utility.set_location(l_proc,180);

1615:
1616: exception
1617: --------
1618: When others then
1619: hr_utility.set_location(l_proc,180);
1620: fnd_message.raise_error;
1621: hr_multi_message.end_validation_set;
1622:
1623: END;

Line 1661: hr_utility.set_location(l_proc,10);

1657:
1658: l_proc varchar2(72) := g_package ||'delete_mileage_claim';
1659: BEGIN
1660:
1661: hr_utility.set_location(l_proc,10);
1662: OPEN c_get_end_date (p_element_entry_id
1663: ,p_assignment_id
1664: );
1665: LOOP

Line 1668: hr_utility.set_location(l_proc,20);

1664: );
1665: LOOP
1666: FETCH c_get_end_date INTO l_get_end_date;
1667: EXIT WHEN c_get_end_date%NOTFOUND;
1668: hr_utility.set_location(l_proc,20);
1669: IF l_get_end_date.effective_end_date =hr_api.g_eot THEN
1670:
1671: OPEN c_get_process_status ( p_assignment_id
1672: ,p_mileage_claim_element

Line 1683: hr_utility.set_location(l_proc,30);

1679: CLOSE c_get_process_status;
1680:
1681: IF l_get_process_status.assignment_action_id IS NULL THEN
1682:
1683: hr_utility.set_location(l_proc,30);
1684: hr_entry_api.delete_element_entry
1685: (
1686: p_dt_delete_mode =>'ZAP'
1687: ,p_session_date =>p_effective_date

Line 1691: hr_utility.set_location(l_proc,40);

1687: ,p_session_date =>p_effective_date
1688: ,p_element_entry_id =>p_element_entry_id
1689: );
1690: ELSE
1691: hr_utility.set_location(l_proc,40);
1692: fnd_message.set_name('PQP','PQP_230718_CLM_PROC_DEL');
1693: fnd_message.raise_error;
1694: hr_multi_message.end_validation_set;
1695: END IF;

Line 1699: hr_utility.set_location(l_proc,50);

1695: END IF;
1696:
1697: ELSE
1698:
1699: hr_utility.set_location(l_proc,50);
1700: fnd_message.set_name('PQP','PQP_230718_CLM_PROC_DEL');
1701: fnd_message.raise_error;
1702: hr_multi_message.end_validation_set;
1703: END IF;

Line 1708: hr_utility.set_location(l_proc,60);

1704: END LOOP;
1705: exception
1706: --------
1707: When others then
1708: hr_utility.set_location(l_proc,60);
1709: fnd_message.raise_error;
1710: hr_multi_message.end_validation_set;
1711: END;
1712:

Line 2015: hr_utility.set_location('Enter ' || l_proc,10);

2011: l_retvalue VARCHAR2(1) :='Y';
2012: l_proc varchar2(72) := g_package ||'chk_mndtry_fields';
2013: BEGIN
2014:
2015: hr_utility.set_location('Enter ' || l_proc,10);
2016: IF p_registration_number IS NOT NULL THEN
2017: OPEN c_get_veh_det;
2018: FETCH c_get_veh_det INTO l_get_veh_det;
2019: IF c_get_veh_det%FOUND THEN

Line 2020: hr_utility.set_location( l_proc,20);

2016: IF p_registration_number IS NOT NULL THEN
2017: OPEN c_get_veh_det;
2018: FETCH c_get_veh_det INTO l_get_veh_det;
2019: IF c_get_veh_det%FOUND THEN
2020: hr_utility.set_location( l_proc,20);
2021: IF l_get_veh_det.vehicle_type<>p_vehicle_type THEN
2022: hr_utility.set_location( l_proc,30);
2023: fnd_message.set_name('PQP', 'PQP_230859_VEHICLE_TYP_VALIDAT');
2024: l_retvalue :='N';

Line 2022: hr_utility.set_location( l_proc,30);

2018: FETCH c_get_veh_det INTO l_get_veh_det;
2019: IF c_get_veh_det%FOUND THEN
2020: hr_utility.set_location( l_proc,20);
2021: IF l_get_veh_det.vehicle_type<>p_vehicle_type THEN
2022: hr_utility.set_location( l_proc,30);
2023: fnd_message.set_name('PQP', 'PQP_230859_VEHICLE_TYP_VALIDAT');
2024: l_retvalue :='N';
2025: END IF;
2026: IF l_get_veh_det.engine_capacity_in_cc

Line 2028: hr_utility.set_location( l_proc,40);

2024: l_retvalue :='N';
2025: END IF;
2026: IF l_get_veh_det.engine_capacity_in_cc
2027: <>p_engine_capacity THEN
2028: hr_utility.set_location( l_proc,40);
2029: fnd_message.set_name('PQP', 'PQP_230860_ENGINE_CAP_VALIDAT');
2030: l_retvalue :='N';
2031:
2032: END IF;

Line 2034: hr_utility.set_location( l_proc,50);

2030: l_retvalue :='N';
2031:
2032: END IF;
2033: IF l_get_veh_det.fuel_type <>p_fuel_type THEN
2034: hr_utility.set_location( l_proc,50);
2035: fnd_message.set_name('PQP', 'PQP_230861_FUEL_TYP_VALIDAT');
2036: l_retvalue :='N';
2037: END IF;
2038:

Line 2047: hr_utility.set_location( l_proc,60);

2043: --Check if the an assignemnt has company vehicle
2044: --allocated
2045: IF p_ownership='C' THEN
2046:
2047: hr_utility.set_location( l_proc,60);
2048: OPEN c_validate_comp_veh;
2049: FETCH c_validate_comp_veh INTO l_validate_comp_veh;
2050: IF c_validate_comp_veh%NOTFOUND THEN
2051:

Line 2052: hr_utility.set_location( l_proc,70);

2048: OPEN c_validate_comp_veh;
2049: FETCH c_validate_comp_veh INTO l_validate_comp_veh;
2050: IF c_validate_comp_veh%NOTFOUND THEN
2051:
2052: hr_utility.set_location( l_proc,70);
2053: fnd_message.set_name('PQP', 'PQP_230866_COMP_VEH_NOT_ALLOC');
2054: l_retvalue :='N';
2055: END IF;
2056:

Line 2061: hr_utility.set_location( l_proc,80);

2057: CLOSE c_validate_comp_veh;
2058:
2059: END IF;
2060: IF p_ownership IS NULL THEN
2061: hr_utility.set_location( l_proc,80);
2062: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2063: fnd_message.set_token('TOKEN','Ownership');
2064: l_retvalue :='N';
2065: END IF;

Line 2070: hr_utility.set_location( l_proc,90);

2066:
2067: --Commented out this now because this condition is no longer
2068: --required as the code handles this during element entry.
2069: /*IF p_usage_type IS NULL THEN
2070: hr_utility.set_location( l_proc,90);
2071: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2072: fnd_message.set_token('TOKEN','Usage Type');
2073: l_retvalue :='N';
2074:

Line 2078: hr_utility.set_location( l_proc,100);

2074:
2075: END IF;*/
2076:
2077: IF p_vehicle_type IS NULL THEN
2078: hr_utility.set_location( l_proc,100);
2079: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2080: fnd_message.set_token('TOKEN','Vehicle Type');
2081: l_retvalue :='N';
2082:

Line 2087: hr_utility.set_location( l_proc,110);

2083: END IF;
2084:
2085:
2086: IF p_start_date IS NULL THEN
2087: hr_utility.set_location( l_proc,110);
2088: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2089: fnd_message.set_token('TOKEN','Start Date');
2090: l_retvalue :='N';
2091:

Line 2095: hr_utility.set_location( l_proc,120);

2091:
2092: END IF;
2093:
2094: IF p_end_date IS NULL THEN
2095: hr_utility.set_location( l_proc,120);
2096: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2097: fnd_message.set_token('TOKEN','End Date');
2098:
2099: l_retvalue :='N';

Line 2102: hr_utility.set_location( l_proc,130);

2098:
2099: l_retvalue :='N';
2100: END IF;
2101: IF p_claimed_mileage IS NULL THEN
2102: hr_utility.set_location( l_proc,130);
2103: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2104: fnd_message.set_token('TOKEN','Claimed Mileage');
2105: l_retvalue :='N';
2106:

Line 2111: hr_utility.set_location( l_proc,140);

2107: END IF;
2108:
2109:
2110: IF p_engine_capacity IS NULL THEN
2111: hr_utility.set_location( l_proc,140);
2112: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2113: fnd_message.set_token('TOKEN','Engine Capacity');
2114: l_retvalue :='N';
2115: END IF;

Line 2118: hr_utility.set_location( l_proc,150);

2114: l_retvalue :='N';
2115: END IF;
2116:
2117: IF p_element_type_id IS NULL THEN
2118: hr_utility.set_location( l_proc,150);
2119:
2120: fnd_message.set_name('PQP', 'PQP_230732_VLD_MLG_ELE_FAIL');
2121: l_retvalue :='N';
2122: END IF;

Line 2126: hr_utility.set_location( l_proc,160);

2122: END IF;
2123:
2124: IF FND_DATE.CHARDT_TO_DATE(p_end_date) <
2125: FND_DATE.CHARDT_TO_DATE(p_start_date) THEN
2126: hr_utility.set_location( l_proc,160);
2127: fnd_message.set_name('PER','HR_289262_ST_DATE_BEFORE_EDATE');
2128: l_retvalue :='N';
2129: END IF;
2130:

Line 2133: hr_utility.set_location( 'Leaving :'||l_proc,170);

2129: END IF;
2130:
2131: --RETURN('Y');
2132: RETURN (l_retvalue);
2133: hr_utility.set_location( 'Leaving :'||l_proc,170);
2134: END;
2135:
2136: --Check for eligibility
2137: FUNCTION chk_eligibility ( p_effective_date IN DATE

Line 2209: hr_utility.set_location('Enter chk eligibility:' || l_proc,220);

2205: l_get_config_info c_get_config_info%ROWTYPE;
2206:
2207: l_proc varchar2(72) := g_package ||'check_eligibility';
2208: BEGIN
2209: hr_utility.set_location('Enter chk eligibility:' || l_proc,220);
2210: OPEN c_get_config_info('GB'
2211: );
2212: LOOP
2213: FETCH c_get_config_info INTO l_get_config_info;

Line 2241: hr_utility.set_location('leave chk eligibility:' || l_proc,230);

2237: END IF;
2238: END IF;
2239: END IF;
2240:
2241: hr_utility.set_location('leave chk eligibility:' || l_proc,230);
2242:
2243: --Check if pvt vehicle need to be validated against
2244: --repository.
2245: IF l_get_config_info.validate_pvt_veh ='Y' THEN

Line 2630: hr_utility.set_location('enter get meaning:' || l_proc,240);

2626:
2627: l_proc varchar2(72) := g_package ||'get_meaning';
2628: BEGIN
2629:
2630: hr_utility.set_location('enter get meaning:' || l_proc,240);
2631: IF p_inp_type = 'EI' THEN
2632: OPEN c_get_meaning_o;
2633: LOOP
2634: FETCH c_get_meaning_o INTO l_get_meaning_o;

Line 2690: hr_utility.set_location('Leaving get meaning:' || l_proc,250);

2686: FETCH c_get_purpose_name INTO l_meaning;
2687: CLOSE c_get_purpose_name;
2688: RETURN(l_meaning);
2689: END IF;
2690: hr_utility.set_location('Leaving get meaning:' || l_proc,250);
2691: exception
2692: when others then
2693: return(p_code);
2694: END;

Line 3001: hr_utility.set_location('Insert_company_mileage_claim:' || l_proc,260);

2997: l_element_entry_id number;
2998: l_proc varchar2(72) := g_package ||'get_meaning';
2999: l_temp_var NUMBER;
3000: BEGIN
3001: hr_utility.set_location('Insert_company_mileage_claim:' || l_proc,260);
3002: l_effective_start_date :=p_effective_date;
3003: l_effective_end_date :=hr_api.g_eot;
3004:
3005:

Line 3163: hr_utility.set_location('Entering hr_entry_apiinsert_element_entry',270);

3159:
3160:
3161: END LOOP;
3162: CLOSE c_get_input_details;
3163: hr_utility.set_location('Entering hr_entry_apiinsert_element_entry',270);
3164: hr_entry_api.insert_element_entry
3165: (
3166: p_effective_start_date =>l_effective_start_date,
3167: p_effective_end_date =>l_effective_end_date,

Line 3304: hr_utility.set_location('Enter private element entry process',280);

3300: l_entry_value15 pay_element_entry_values_f.screen_entry_value%TYPE:=NULL;
3301: l_entry_value16 pay_element_entry_values_f.screen_entry_value%TYPE:=NULL;
3302: l_temp_var NUMBER;
3303: BEGIN
3304: hr_utility.set_location('Enter private element entry process',280);
3305: l_effective_start_date :=p_effective_date;
3306: l_effective_end_date :=hr_api.g_eot;
3307:
3308: BEGIN

Line 3497: hr_utility.set_location('Enter hr_entry_apiinsert_element_entr',290);

3493: l_input_value_id3 :=l_input_value_id16;
3494:
3495:
3496: END IF;
3497: hr_utility.set_location('Enter hr_entry_apiinsert_element_entr',290);
3498: hr_entry_api.insert_element_entry
3499: (
3500: --
3501: -- Common Parameters

Line 3543: hr_utility.set_location('leaving hr_entry_apiinsert_element_entr',300);

3539: p_entry_value13 =>l_entry_value13,
3540: p_entry_value14 =>l_entry_value14,
3541: p_entry_value15 =>l_entry_value15
3542: );
3543: hr_utility.set_location('leaving hr_entry_apiinsert_element_entr',300);
3544: END;
3545: END;