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

Line 129: hr_utility.trace('1-LR');

125: Input_val_tbl(i).max_value := j.max_value;
126: Input_val_tbl(i).min_value := j.min_value;
127: Input_val_tbl(i).warning_or_error := j.warning_or_error;
128: Input_val_tbl(i).object_version_number := j.object_version_number;
129: hr_utility.trace('1-LR');
130: i:=i+1;
131: End loop;
132: IF Input_val_tbl(1).input_value_id IS NOT NULL AND
133: p_rec.value_1 IS NOT NULL THEN

Line 334: hr_utility.raise_error;

330: If (l_required_flag(i) = 'Y' and p_segment(l_segment_no(i)) is null) then
331: fnd_message.set_name('PER','PAY_33284_FLEX_VALUE_MISSING');
332: fnd_message.set_token('COLUMN',l_application_column(i));
333: fnd_message.set_token('PROMPT',l_application_segment(i));
334: hr_utility.raise_error;
335: end if;
336: END LOOP;
337: end if;
338:

Line 345: -- hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

341: -- for i in 1..30 loop
342: -- if l_required_segment(i) = 'N' then
343: -- if (p_segment(i) is not null or p_segment(i) = hr_api.g_varchar2) then
344: -- --
345: -- hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
346: -- hr_utility.set_message_token('PROCEDURE', l_proc);
347: -- hr_utility.set_message_token('STEP','20');
348: -- hr_utility.raise_error;
349: -- --

Line 346: -- hr_utility.set_message_token('PROCEDURE', l_proc);

342: -- if l_required_segment(i) = 'N' then
343: -- if (p_segment(i) is not null or p_segment(i) = hr_api.g_varchar2) then
344: -- --
345: -- hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
346: -- hr_utility.set_message_token('PROCEDURE', l_proc);
347: -- hr_utility.set_message_token('STEP','20');
348: -- hr_utility.raise_error;
349: -- --
350: -- end if;

Line 347: -- hr_utility.set_message_token('STEP','20');

343: -- if (p_segment(i) is not null or p_segment(i) = hr_api.g_varchar2) then
344: -- --
345: -- hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
346: -- hr_utility.set_message_token('PROCEDURE', l_proc);
347: -- hr_utility.set_message_token('STEP','20');
348: -- hr_utility.raise_error;
349: -- --
350: -- end if;
351: -- end if;

Line 348: -- hr_utility.raise_error;

344: -- --
345: -- hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
346: -- hr_utility.set_message_token('PROCEDURE', l_proc);
347: -- hr_utility.set_message_token('STEP','20');
348: -- hr_utility.raise_error;
349: -- --
350: -- end if;
351: -- end if;
352: -- end loop;

Line 386: hr_utility.set_location('Entering:'|| l_proc, 10);

382: l_proc varchar2(72) := g_package||'set_security_group_id';
383: --
384: begin
385: --
386: hr_utility.set_location('Entering:'|| l_proc, 10);
387: --
388: -- Ensure that all the mandatory parameter are not null
389: --
390: hr_api.mandatory_arg_error

Line 417: hr_utility.set_location(' Leaving:'|| l_proc, 20);

413: hr_api.set_security_group_id
414: (p_security_group_id => l_security_group_id
415: );
416: --
417: hr_utility.set_location(' Leaving:'|| l_proc, 20);
418: --
419: end set_security_group_id;
420: --
421: -- ---------------------------------------------------------------------------

Line 453: hr_utility.set_location('Entering:'|| l_proc, 10);

449: l_proc varchar2(72) := g_package||'return_legislation_code';
450: --
451: Begin
452: --
453: hr_utility.set_location('Entering:'|| l_proc, 10);
454: --
455: -- Ensure that all the mandatory parameter are not null
456: --
457: hr_api.mandatory_arg_error

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

467: -- call to this function. Just return the value in the global
468: -- variable.
469: --
470: l_legislation_code := pay_btl_bus.g_legislation_code;
471: hr_utility.set_location(l_proc, 20);
472: else
473: --
474: -- The ID is different to the last call to this function
475: -- or this is the first call to this function.

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

484: close csr_leg_code;
485: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
486: fnd_message.raise_error;
487: end if;
488: hr_utility.set_location(l_proc,30);
489: --
490: -- Set the global variables so the values are
491: -- available for the next call to this function.
492: --

Line 497: hr_utility.set_location(' Leaving:'|| l_proc, 40);

493: close csr_leg_code;
494: pay_btl_bus.g_batch_line_id := p_batch_line_id;
495: pay_btl_bus.g_legislation_code := l_legislation_code;
496: end if;
497: hr_utility.set_location(' Leaving:'|| l_proc, 40);
498: return l_legislation_code;
499: end return_legislation_code;
500: --
501: -- ----------------------------------------------------------------------------

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

547: fnd_message.set_token('STEP ', '5');
548: fnd_message.raise_error;
549: END IF;
550: --
551: hr_utility.set_location(l_proc, 10);
552: --
553: if nvl(p_rec.batch_id, hr_api.g_number) <>
554: pay_btl_shd.g_old_rec.batch_id then
555: l_argument := 'batch_id';

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

555: l_argument := 'batch_id';
556: raise l_error;
557: end if;
558: --
559: hr_utility.set_location(l_proc, 20);
560: --
561: EXCEPTION
562: WHEN l_error THEN
563: hr_api.argument_changed_error

Line 667: hr_utility.set_location('Entering:'||l_proc, 1);

663: from pay_batch_headers bth
664: where bth.batch_id = p_batch_id;
665: --
666: begin
667: hr_utility.set_location('Entering:'||l_proc, 1);
668: --
669: -- Check mandatory batch_id is set
670: --
671: hr_api.mandatory_arg_error

Line 677: hr_utility.set_location(l_proc, 5);

673: ,p_argument => 'BATCH_ID'
674: ,p_argument_value => p_batch_id
675: );
676: --
677: hr_utility.set_location(l_proc, 5);
678: --
679: --
680: --
681: -- Only proceed with validation if :

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

682: -- a) on insert (non-updateable param)
683: --
684: if (p_batch_line_id is null) then
685: --
686: hr_utility.set_location(l_proc, 10);
687: --
688: -- Check that the batch_id is in the pay_batch_headers.
689: --
690: open csr_batch_id_exists;

Line 699: hr_utility.set_location(' Leaving:'||l_proc, 15);

695: end if;
696: close csr_batch_id_exists;
697: end if;
698: --
699: hr_utility.set_location(' Leaving:'||l_proc, 15);
700: --
701: end chk_batch_id;
702: --
703: -- ---------------------------------------------------------------------------

Line 766: hr_utility.set_location('Entering:'||l_proc, 1);

762: --
763: l_batch_header_status pay_batch_headers.batch_status%TYPE;
764: l_dummy number;
765: begin
766: hr_utility.set_location('Entering:'||l_proc, 1);
767: --
768: -- Check mandatory batch_name exists
769: --
770: hr_api.mandatory_arg_error

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

780: ,p_argument => 'session_date'
781: ,p_argument_value => p_session_date
782: );
783: --
784: hr_utility.set_location(l_proc, 10);
785: --
786: l_api_updating := pay_btl_shd.api_updating
787: (p_batch_line_id => p_batch_line_id,
788: p_object_version_number => p_object_version_number

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

786: l_api_updating := pay_btl_shd.api_updating
787: (p_batch_line_id => p_batch_line_id,
788: p_object_version_number => p_object_version_number
789: );
790: hr_utility.set_location(l_proc,20);
791: --
792: -- Only proceed with SQL validation if absolutely necessary
793: --
794: if ((l_api_updating and

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

795: nvl(pay_btl_shd.g_old_rec.batch_line_status,hr_api.g_varchar2) <>
796: nvl(p_batch_line_status,hr_api.g_varchar2))
797: or (NOT l_api_updating)) then
798: --
799: hr_utility.set_location(l_proc,30);
800: --
801: -- Validate against the hr_lookup.
802: --
803: if hr_api.not_exists_in_hr_lookups

Line 870: hr_utility.set_location(' Leaving:'||l_proc, 40);

866: end if;
867: end if;
868: --
869: --
870: hr_utility.set_location(' Leaving:'||l_proc, 40);
871: --
872: end chk_batch_line_status;
873: --
874: -- ---------------------------------------------------------------------------

Line 917: hr_utility.set_location('Entering:'||l_proc, 1);

913: l_proc varchar2(72) := g_package||'chk_entry_type';
914: l_api_updating boolean;
915: --
916: begin
917: hr_utility.set_location('Entering:'||l_proc, 1);
918: --
919: -- Check mandatory session_date exists
920: --
921: hr_api.mandatory_arg_error

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

923: ,p_argument => 'session_date'
924: ,p_argument_value => p_session_date
925: );
926: --
927: hr_utility.set_location(l_proc, 10);
928: --
929: l_api_updating := pay_btl_shd.api_updating
930: (p_batch_line_id => p_batch_line_id,
931: p_object_version_number => p_object_version_number

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

929: l_api_updating := pay_btl_shd.api_updating
930: (p_batch_line_id => p_batch_line_id,
931: p_object_version_number => p_object_version_number
932: );
933: hr_utility.set_location(l_proc,20);
934: --
935: -- Only proceed with SQL validation if absolutely necessary
936: --
937: if ((l_api_updating and

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

938: nvl(pay_btl_shd.g_old_rec.entry_type,hr_api.g_varchar2) <>
939: nvl(p_entry_type,hr_api.g_varchar2))
940: or (NOT l_api_updating)) then
941: --
942: hr_utility.set_location(l_proc,30);
943: --
944: -- Validate against the hr_lookup.
945: --
946: if (p_entry_type is not null) then

Line 948: hr_utility.set_location(l_proc,35);

944: -- Validate against the hr_lookup.
945: --
946: if (p_entry_type is not null) then
947: --
948: hr_utility.set_location(l_proc,35);
949: --
950: -- Validate against the hr_lookup.
951: --
952: if hr_api.not_exists_in_hr_lookups

Line 963: hr_utility.set_location(' Leaving:'||l_proc, 40);

959: end if;
960: --
961: end if;
962: --
963: hr_utility.set_location(' Leaving:'||l_proc, 40);
964: --
965: end chk_entry_type;
966: --
967: -- ---------------------------------------------------------------------------

Line 1010: hr_utility.set_location('Entering:'||l_proc, 1);

1006: where pml.source_id = p_batch_line_id
1007: and pml.source_type = 'L';
1008: --
1009: begin
1010: hr_utility.set_location('Entering:'||l_proc, 1);
1011: --
1012: -- Check mandatory batch_line_id exists
1013: --
1014: hr_api.mandatory_arg_error

Line 1020: hr_utility.set_location('Entering:'||l_proc, 10);

1016: ,p_argument => 'batch_line_id'
1017: ,p_argument_value => p_batch_line_id
1018: );
1019: --
1020: hr_utility.set_location('Entering:'||l_proc, 10);
1021: --
1022: open csr_message_lines;
1023: --
1024: fetch csr_message_lines into l_exists;

Line 1037: hr_utility.set_location(' Leaving:'||l_proc, 20);

1033: End If;
1034: --
1035: close csr_message_lines;
1036: --
1037: hr_utility.set_location(' Leaving:'||l_proc, 20);
1038: --
1039: end chk_delete;
1040:
1041: --

Line 1079: hr_utility.set_message(801, 'HR_7460_PLK_NO_CST_ALLC_STRUCT');

1075: close csr_id_flex_num;
1076: --
1077: -- the flex structure has not been found therefore we must error
1078: --
1079: hr_utility.set_message(801, 'HR_7460_PLK_NO_CST_ALLC_STRUCT');
1080: hr_utility.set_message_token('BUSINESS_GROUP_ID',l_business_group_id);
1081: hr_utility.raise_error;
1082: end if;
1083: close csr_id_flex_num;

Line 1080: hr_utility.set_message_token('BUSINESS_GROUP_ID',l_business_group_id);

1076: --
1077: -- the flex structure has not been found therefore we must error
1078: --
1079: hr_utility.set_message(801, 'HR_7460_PLK_NO_CST_ALLC_STRUCT');
1080: hr_utility.set_message_token('BUSINESS_GROUP_ID',l_business_group_id);
1081: hr_utility.raise_error;
1082: end if;
1083: close csr_id_flex_num;
1084:

Line 1081: hr_utility.raise_error;

1077: -- the flex structure has not been found therefore we must error
1078: --
1079: hr_utility.set_message(801, 'HR_7460_PLK_NO_CST_ALLC_STRUCT');
1080: hr_utility.set_message_token('BUSINESS_GROUP_ID',l_business_group_id);
1081: hr_utility.raise_error;
1082: end if;
1083: close csr_id_flex_num;
1084:
1085:

Line 1124: hr_utility.set_location('Entering:'||l_proc, 5);

1120: l_proc varchar2(72) := g_package||'insert_validate';
1121:
1122: --
1123: Begin
1124: hr_utility.set_location('Entering:'||l_proc, 5);
1125: --
1126: -- Call all supporting business operations
1127: --
1128: chk_batch_id(p_batch_line_id => p_rec.batch_line_id

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

1127: --
1128: chk_batch_id(p_batch_line_id => p_rec.batch_line_id
1129: ,p_batch_id => p_rec.batch_id);
1130: --
1131: hr_utility.set_location(l_proc, 10);
1132: --
1133: pay_bth_bus.set_security_group_id(p_batch_id => p_rec.batch_id);
1134: --
1135: hr_utility.set_location(l_proc, 20);

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

1131: hr_utility.set_location(l_proc, 10);
1132: --
1133: pay_bth_bus.set_security_group_id(p_batch_id => p_rec.batch_id);
1134: --
1135: hr_utility.set_location(l_proc, 20);
1136: --
1137: chk_batch_line_status(p_batch_line_status => p_rec.batch_line_status
1138: ,p_session_date => p_session_date
1139: ,p_batch_id => p_rec.batch_id

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

1141: ,p_assignment_id => p_rec.assignment_id
1142: ,p_assignment_number => p_rec.assignment_number
1143: ,p_object_version_number => p_rec.object_version_number);
1144: --
1145: hr_utility.set_location(l_proc, 30);
1146: --
1147: chk_entry_type(p_entry_type => p_rec.entry_type
1148: ,p_session_date => p_session_date
1149: ,p_batch_line_id => p_rec.batch_line_id

Line 1152: hr_utility.set_location(' Leaving:'||l_proc, 40);

1148: ,p_session_date => p_session_date
1149: ,p_batch_line_id => p_rec.batch_line_id
1150: ,p_object_version_number => p_rec.object_version_number);
1151: --
1152: hr_utility.set_location(' Leaving:'||l_proc, 40);
1153: --Validating input values with Lookup and value sets
1154: -- Validate_Input_Values (p_session_date , p_rec );
1155:
1156: chk_flex_segments(

Line 1173: hr_utility.set_location('Entering:'||l_proc, 5);

1169: --
1170: l_proc varchar2(72) := g_package||'update_validate';
1171: --
1172: Begin
1173: hr_utility.set_location('Entering:'||l_proc, 5);
1174: --
1175: -- Call all supporting business operations
1176: --
1177: --

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

1176: --
1177: --
1178: pay_btl_bus.set_security_group_id(p_batch_line_id => p_rec.batch_line_id);
1179: --
1180: hr_utility.set_location(l_proc, 10);
1181: --
1182: chk_non_updateable_args
1183: (p_rec => p_rec
1184: );

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

1182: chk_non_updateable_args
1183: (p_rec => p_rec
1184: );
1185: --
1186: hr_utility.set_location(l_proc, 20);
1187: --
1188: --
1189: chk_transferred_status(p_batch_line_id => p_rec.batch_line_id);
1190: --

Line 1191: hr_utility.set_location(l_proc, 25);

1187: --
1188: --
1189: chk_transferred_status(p_batch_line_id => p_rec.batch_line_id);
1190: --
1191: hr_utility.set_location(l_proc, 25);
1192: --
1193: chk_batch_line_status(p_batch_line_status => p_rec.batch_line_status
1194: ,p_session_date => p_session_date
1195: ,p_batch_id => p_rec.batch_id

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

1197: ,p_assignment_id => p_rec.assignment_id
1198: ,p_assignment_number => p_rec.assignment_number
1199: ,p_object_version_number => p_rec.object_version_number);
1200: --
1201: hr_utility.set_location(l_proc, 30);
1202: --
1203: chk_entry_type(p_entry_type => p_rec.entry_type
1204: ,p_session_date => p_session_date
1205: ,p_batch_line_id => p_rec.batch_line_id

Line 1208: hr_utility.set_location(' Leaving:'||l_proc, 40);

1204: ,p_session_date => p_session_date
1205: ,p_batch_line_id => p_rec.batch_line_id
1206: ,p_object_version_number => p_rec.object_version_number);
1207: --
1208: hr_utility.set_location(' Leaving:'||l_proc, 40);
1209: --Validating input values with Lookup and value sets
1210: -- Validate_Input_Values (p_session_date , p_rec );
1211:
1212: chk_flex_segments(

Line 1228: hr_utility.set_location('Entering:'||l_proc, 5);

1224: --
1225: l_proc varchar2(72) := g_package||'delete_validate';
1226: --
1227: Begin
1228: hr_utility.set_location('Entering:'||l_proc, 5);
1229: --
1230: -- Call all supporting business operations
1231: --
1232: --

Line 1237: hr_utility.set_location(l_proc, 8);

1233: if payplnk.g_payplnk_call <> true then
1234: chk_transferred_status(p_batch_line_id => p_rec.batch_line_id);
1235: end if;
1236: --
1237: hr_utility.set_location(l_proc, 8);
1238: --
1239: chk_delete(p_batch_line_id => p_rec.batch_line_id);
1240: --
1241: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 1241: hr_utility.set_location(' Leaving:'||l_proc, 10);

1237: hr_utility.set_location(l_proc, 8);
1238: --
1239: chk_delete(p_batch_line_id => p_rec.batch_line_id);
1240: --
1241: hr_utility.set_location(' Leaving:'||l_proc, 10);
1242: End delete_validate;
1243: --
1244: end pay_btl_bus;
1245: