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_PUR_BUS dependencies on FND_MESSAGE

Line 60: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

56: close csr_sec_grp;
57: --
58: -- The primary key is invalid therefore we must error
59: --
60: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
61: hr_multi_message.add
62: (p_associated_column1
63: => nvl(p_associated_column1,'USER_ROW_ID')
64: );

Line 137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

133: --
134: -- The primary key is invalid therefore we must error
135: --
136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --

Line 138: fnd_message.raise_error;

134: -- The primary key is invalid therefore we must error
135: --
136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --
142: -- Set the global variables so the values are

Line 200: fnd_message.set_name('PAY', 'PAY_33177_LEG_CODE_INVALID');

196: fetch csr_legislation_code into l_exists ;
197:
198: if csr_legislation_code%notfound then
199: close csr_legislation_code;
200: fnd_message.set_name('PAY', 'PAY_33177_LEG_CODE_INVALID');
201: fnd_message.raise_error;
202: end if;
203: close csr_legislation_code;
204:

Line 201: fnd_message.raise_error;

197:
198: if csr_legislation_code%notfound then
199: close csr_legislation_code;
200: fnd_message.set_name('PAY', 'PAY_33177_LEG_CODE_INVALID');
201: fnd_message.raise_error;
202: end if;
203: close csr_legislation_code;
204:
205: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 258: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

254: fetch csr_user_key_units into g_user_key_units;
255:
256: If csr_user_key_units%notfound then
257: close csr_user_key_units;
258: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
259: fnd_message.set_token('PROCEDURE', l_proc);
260: fnd_message.set_token('STEP','5');
261: fnd_message.raise_error;
262: end if;

Line 259: fnd_message.set_token('PROCEDURE', l_proc);

255:
256: If csr_user_key_units%notfound then
257: close csr_user_key_units;
258: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
259: fnd_message.set_token('PROCEDURE', l_proc);
260: fnd_message.set_token('STEP','5');
261: fnd_message.raise_error;
262: end if;
263:

Line 260: fnd_message.set_token('STEP','5');

256: If csr_user_key_units%notfound then
257: close csr_user_key_units;
258: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
259: fnd_message.set_token('PROCEDURE', l_proc);
260: fnd_message.set_token('STEP','5');
261: fnd_message.raise_error;
262: end if;
263:
264: close csr_user_key_units;

Line 261: fnd_message.raise_error;

257: close csr_user_key_units;
258: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
259: fnd_message.set_token('PROCEDURE', l_proc);
260: fnd_message.set_token('STEP','5');
261: fnd_message.raise_error;
262: end if;
263:
264: close csr_user_key_units;
265:

Line 311: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

307: fetch csr_range_or_match into g_range_or_match;
308:
309: If csr_range_or_match%notfound then
310: close csr_range_or_match;
311: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
312: fnd_message.set_token('PROCEDURE', l_proc);
313: fnd_message.set_token('STEP','5');
314: fnd_message.raise_error;
315: end if;

Line 312: fnd_message.set_token('PROCEDURE', l_proc);

308:
309: If csr_range_or_match%notfound then
310: close csr_range_or_match;
311: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
312: fnd_message.set_token('PROCEDURE', l_proc);
313: fnd_message.set_token('STEP','5');
314: fnd_message.raise_error;
315: end if;
316:

Line 313: fnd_message.set_token('STEP','5');

309: If csr_range_or_match%notfound then
310: close csr_range_or_match;
311: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
312: fnd_message.set_token('PROCEDURE', l_proc);
313: fnd_message.set_token('STEP','5');
314: fnd_message.raise_error;
315: end if;
316:
317: close csr_range_or_match;

Line 314: fnd_message.raise_error;

310: close csr_range_or_match;
311: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
312: fnd_message.set_token('PROCEDURE', l_proc);
313: fnd_message.set_token('STEP','5');
314: fnd_message.raise_error;
315: end if;
316:
317: close csr_range_or_match;
318:

Line 386: fnd_message.set_name('PAY', 'PAY_33174_PARENT_ID_INVALID');

382: fetch csr_user_table_id into l_legcode, l_busgrpid ;
383:
384: if csr_user_table_id%notfound then
385: close csr_user_table_id;
386: fnd_message.set_name('PAY', 'PAY_33174_PARENT_ID_INVALID');
387: fnd_message.set_token('PARENT' , 'User Table Id' );
388: fnd_message.raise_error;
389: end if;
390: close csr_user_table_id;

Line 387: fnd_message.set_token('PARENT' , 'User Table Id' );

383:
384: if csr_user_table_id%notfound then
385: close csr_user_table_id;
386: fnd_message.set_name('PAY', 'PAY_33174_PARENT_ID_INVALID');
387: fnd_message.set_token('PARENT' , 'User Table Id' );
388: fnd_message.raise_error;
389: end if;
390: close csr_user_table_id;
391: --

Line 388: fnd_message.raise_error;

384: if csr_user_table_id%notfound then
385: close csr_user_table_id;
386: fnd_message.set_name('PAY', 'PAY_33174_PARENT_ID_INVALID');
387: fnd_message.set_token('PARENT' , 'User Table Id' );
388: fnd_message.raise_error;
389: end if;
390: close csr_user_table_id;
391: --
392: -- Confirm that the parent USER_TABLE's startup mode is compatible

Line 401: fnd_message.set_name('PAY', 'PAY_33175_BGLEG_MISMATCH');

397: ,p_parent_legcode => l_legcode
398: ,p_child_bgid => p_business_group_id
399: ,p_child_legcode => p_legislation_code
400: ) then
401: fnd_message.set_name('PAY', 'PAY_33175_BGLEG_MISMATCH');
402: fnd_message.set_token('CHILD', 'User Row');
403: fnd_message.set_token('PARENT' , 'User Table');
404: fnd_message.raise_error;
405: end if;

Line 402: fnd_message.set_token('CHILD', 'User Row');

398: ,p_child_bgid => p_business_group_id
399: ,p_child_legcode => p_legislation_code
400: ) then
401: fnd_message.set_name('PAY', 'PAY_33175_BGLEG_MISMATCH');
402: fnd_message.set_token('CHILD', 'User Row');
403: fnd_message.set_token('PARENT' , 'User Table');
404: fnd_message.raise_error;
405: end if;
406:

Line 403: fnd_message.set_token('PARENT' , 'User Table');

399: ,p_child_legcode => p_legislation_code
400: ) then
401: fnd_message.set_name('PAY', 'PAY_33175_BGLEG_MISMATCH');
402: fnd_message.set_token('CHILD', 'User Row');
403: fnd_message.set_token('PARENT' , 'User Table');
404: fnd_message.raise_error;
405: end if;
406:
407: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 404: fnd_message.raise_error;

400: ) then
401: fnd_message.set_name('PAY', 'PAY_33175_BGLEG_MISMATCH');
402: fnd_message.set_token('CHILD', 'User Row');
403: fnd_message.set_token('PARENT' , 'User Table');
404: fnd_message.raise_error;
405: end if;
406:
407: hr_utility.set_location(' Leaving:'|| l_proc, 20);
408:

Line 617: fnd_message.set_name('PAY', 'HR_7207_API_MANDATORY_ARG');

613: ,p_argument_value => p_row_low_range_or_name
614: );
615:
616: if p_disable_units_check is null then
617: fnd_message.set_name('PAY', 'HR_7207_API_MANDATORY_ARG');
618: fnd_message.set_token('API_NAME', l_proc);
619: fnd_message.set_token('ARGUMENT','DISABLE_UNITS_CHECK');
620: fnd_message.raise_error;
621: end if;

Line 618: fnd_message.set_token('API_NAME', l_proc);

614: );
615:
616: if p_disable_units_check is null then
617: fnd_message.set_name('PAY', 'HR_7207_API_MANDATORY_ARG');
618: fnd_message.set_token('API_NAME', l_proc);
619: fnd_message.set_token('ARGUMENT','DISABLE_UNITS_CHECK');
620: fnd_message.raise_error;
621: end if;
622:

Line 619: fnd_message.set_token('ARGUMENT','DISABLE_UNITS_CHECK');

615:
616: if p_disable_units_check is null then
617: fnd_message.set_name('PAY', 'HR_7207_API_MANDATORY_ARG');
618: fnd_message.set_token('API_NAME', l_proc);
619: fnd_message.set_token('ARGUMENT','DISABLE_UNITS_CHECK');
620: fnd_message.raise_error;
621: end if;
622:
623: if p_disable_range_overlap_check is null then

Line 620: fnd_message.raise_error;

616: if p_disable_units_check is null then
617: fnd_message.set_name('PAY', 'HR_7207_API_MANDATORY_ARG');
618: fnd_message.set_token('API_NAME', l_proc);
619: fnd_message.set_token('ARGUMENT','DISABLE_UNITS_CHECK');
620: fnd_message.raise_error;
621: end if;
622:
623: if p_disable_range_overlap_check is null then
624: fnd_message.set_name('PAY', 'HR_7207_API_MANDATORY_ARG');

Line 624: fnd_message.set_name('PAY', 'HR_7207_API_MANDATORY_ARG');

620: fnd_message.raise_error;
621: end if;
622:
623: if p_disable_range_overlap_check is null then
624: fnd_message.set_name('PAY', 'HR_7207_API_MANDATORY_ARG');
625: fnd_message.set_token('API_NAME', l_proc);
626: fnd_message.set_token('ARGUMENT','DISABLE_RANGE_OVERLAP_CHECK');
627: fnd_message.raise_error;
628: end if;

Line 625: fnd_message.set_token('API_NAME', l_proc);

621: end if;
622:
623: if p_disable_range_overlap_check is null then
624: fnd_message.set_name('PAY', 'HR_7207_API_MANDATORY_ARG');
625: fnd_message.set_token('API_NAME', l_proc);
626: fnd_message.set_token('ARGUMENT','DISABLE_RANGE_OVERLAP_CHECK');
627: fnd_message.raise_error;
628: end if;
629:

Line 626: fnd_message.set_token('ARGUMENT','DISABLE_RANGE_OVERLAP_CHECK');

622:
623: if p_disable_range_overlap_check is null then
624: fnd_message.set_name('PAY', 'HR_7207_API_MANDATORY_ARG');
625: fnd_message.set_token('API_NAME', l_proc);
626: fnd_message.set_token('ARGUMENT','DISABLE_RANGE_OVERLAP_CHECK');
627: fnd_message.raise_error;
628: end if;
629:
630: l_user_key_units := return_user_key_units(p_user_table_id);

Line 627: fnd_message.raise_error;

623: if p_disable_range_overlap_check is null then
624: fnd_message.set_name('PAY', 'HR_7207_API_MANDATORY_ARG');
625: fnd_message.set_token('API_NAME', l_proc);
626: fnd_message.set_token('ARGUMENT','DISABLE_RANGE_OVERLAP_CHECK');
627: fnd_message.raise_error;
628: end if;
629:
630: l_user_key_units := return_user_key_units(p_user_table_id);
631: l_range_or_match := return_range_or_match(p_user_table_id);

Line 641: fnd_message.set_name ( 'PAY', 'PAY_33131_UT_INVALID_ROW' );

637: l_user_key_units ) ;
638:
639: if ( l_result = FALSE ) then
640: if ( l_range_or_match = 'M' ) then
641: fnd_message.set_name ( 'PAY', 'PAY_33131_UT_INVALID_ROW' );
642: fnd_message.raise_error;
643: elsif (l_range_or_match = 'R' ) then
644: fnd_message.set_name ( 'PAY', 'PAY_34025_UT_RANGE_NOT_NUMERIC' );
645: fnd_message.raise_error;

Line 642: fnd_message.raise_error;

638:
639: if ( l_result = FALSE ) then
640: if ( l_range_or_match = 'M' ) then
641: fnd_message.set_name ( 'PAY', 'PAY_33131_UT_INVALID_ROW' );
642: fnd_message.raise_error;
643: elsif (l_range_or_match = 'R' ) then
644: fnd_message.set_name ( 'PAY', 'PAY_34025_UT_RANGE_NOT_NUMERIC' );
645: fnd_message.raise_error;
646: end if;

Line 644: fnd_message.set_name ( 'PAY', 'PAY_34025_UT_RANGE_NOT_NUMERIC' );

640: if ( l_range_or_match = 'M' ) then
641: fnd_message.set_name ( 'PAY', 'PAY_33131_UT_INVALID_ROW' );
642: fnd_message.raise_error;
643: elsif (l_range_or_match = 'R' ) then
644: fnd_message.set_name ( 'PAY', 'PAY_34025_UT_RANGE_NOT_NUMERIC' );
645: fnd_message.raise_error;
646: end if;
647: end if;
648: end if;

Line 645: fnd_message.raise_error;

641: fnd_message.set_name ( 'PAY', 'PAY_33131_UT_INVALID_ROW' );
642: fnd_message.raise_error;
643: elsif (l_range_or_match = 'R' ) then
644: fnd_message.set_name ( 'PAY', 'PAY_34025_UT_RANGE_NOT_NUMERIC' );
645: fnd_message.raise_error;
646: end if;
647: end if;
648: end if;
649:

Line 671: fnd_message.set_name( 'PAY' , 'PAY_7884_USER_TABLE_UNIQUE' );

667: fetch csr_unique_name into l_exists;
668:
669: if csr_unique_name%found then
670: close csr_unique_name;
671: fnd_message.set_name( 'PAY' , 'PAY_7884_USER_TABLE_UNIQUE' );
672: fnd_message.raise_error ;
673: end if ;
674:
675: close csr_unique_name;

Line 672: fnd_message.raise_error ;

668:
669: if csr_unique_name%found then
670: close csr_unique_name;
671: fnd_message.set_name( 'PAY' , 'PAY_7884_USER_TABLE_UNIQUE' );
672: fnd_message.raise_error ;
673: end if ;
674:
675: close csr_unique_name;
676: end if;

Line 783: fnd_message.set_name ( 'PAY', 'PAY_34025_UT_RANGE_NOT_NUMERIC' );

779: l_result := chk_format( p_row_high_range,
780: l_user_key_units ) ;
781:
782: if ( l_result = FALSE ) then
783: fnd_message.set_name ( 'PAY', 'PAY_34025_UT_RANGE_NOT_NUMERIC' );
784: fnd_message.raise_error;
785: end if;
786: end if;
787: end if;

Line 784: fnd_message.raise_error;

780: l_user_key_units ) ;
781:
782: if ( l_result = FALSE ) then
783: fnd_message.set_name ( 'PAY', 'PAY_34025_UT_RANGE_NOT_NUMERIC' );
784: fnd_message.raise_error;
785: end if;
786: end if;
787: end if;
788:

Line 921: fnd_message.set_name('PAY', 'HR_7207_API_MANDATORY_ARG');

917: nvl(pay_pur_shd.g_old_rec.row_high_range, hr_api.g_varchar2))
918: ) then
919:
920: if p_disable_range_overlap_check is null then
921: fnd_message.set_name('PAY', 'HR_7207_API_MANDATORY_ARG');
922: fnd_message.set_token('API_NAME', l_proc);
923: fnd_message.set_token('ARGUMENT','DISABLE_RANGE_OVERLAP_CHECK');
924: fnd_message.raise_error;
925: end if;

Line 922: fnd_message.set_token('API_NAME', l_proc);

918: ) then
919:
920: if p_disable_range_overlap_check is null then
921: fnd_message.set_name('PAY', 'HR_7207_API_MANDATORY_ARG');
922: fnd_message.set_token('API_NAME', l_proc);
923: fnd_message.set_token('ARGUMENT','DISABLE_RANGE_OVERLAP_CHECK');
924: fnd_message.raise_error;
925: end if;
926:

Line 923: fnd_message.set_token('ARGUMENT','DISABLE_RANGE_OVERLAP_CHECK');

919:
920: if p_disable_range_overlap_check is null then
921: fnd_message.set_name('PAY', 'HR_7207_API_MANDATORY_ARG');
922: fnd_message.set_token('API_NAME', l_proc);
923: fnd_message.set_token('ARGUMENT','DISABLE_RANGE_OVERLAP_CHECK');
924: fnd_message.raise_error;
925: end if;
926:
927: -- Validation required only for Range Match

Line 924: fnd_message.raise_error;

920: if p_disable_range_overlap_check is null then
921: fnd_message.set_name('PAY', 'HR_7207_API_MANDATORY_ARG');
922: fnd_message.set_token('API_NAME', l_proc);
923: fnd_message.set_token('ARGUMENT','DISABLE_RANGE_OVERLAP_CHECK');
924: fnd_message.raise_error;
925: end if;
926:
927: -- Validation required only for Range Match
928:

Line 938: fnd_message.set_name('PAY','PAY_33178_RANGE_INVALID');

934: -- from canonical to number before compare.
935:
936: if fnd_number.canonical_to_number(p_row_high_range) <
937: fnd_number.canonical_to_number(p_row_low_range_or_name) then
938: fnd_message.set_name('PAY','PAY_33178_RANGE_INVALID');
939: fnd_message.raise_error ;
940: end if;
941:
942:

Line 939: fnd_message.raise_error ;

935:
936: if fnd_number.canonical_to_number(p_row_high_range) <
937: fnd_number.canonical_to_number(p_row_low_range_or_name) then
938: fnd_message.set_name('PAY','PAY_33178_RANGE_INVALID');
939: fnd_message.raise_error ;
940: end if;
941:
942:
943: l_result := fnd_installation.get_app_info ( 'GHR',

Line 962: fnd_message.set_name('PER','PER_34003_USER_ROW_OVERLAP');

958: fetch csr_row_overlap into l_exists;
959:
960: if csr_row_overlap%found then
961: close csr_row_overlap;
962: fnd_message.set_name('PER','PER_34003_USER_ROW_OVERLAP');
963: fnd_message.raise_error ;
964: end if ;
965:
966: close csr_row_overlap;

Line 963: fnd_message.raise_error ;

959:
960: if csr_row_overlap%found then
961: close csr_row_overlap;
962: fnd_message.set_name('PER','PER_34003_USER_ROW_OVERLAP');
963: fnd_message.raise_error ;
964: end if ;
965:
966: close csr_row_overlap;
967: end if;

Line 1177: fnd_message.set_name('PAY', 'HR_7207_API_MANDATORY_ARG');

1173:
1174: hr_utility.set_location('Entering:'|| l_proc, 10);
1175:
1176: if p_disable_range_overlap_check is null then
1177: fnd_message.set_name('PAY', 'HR_7207_API_MANDATORY_ARG');
1178: fnd_message.set_token('API_NAME', l_proc);
1179: fnd_message.set_token('ARGUMENT','DISABLE_RANGE_OVERLAP_CHECK');
1180: fnd_message.raise_error;
1181: end if;

Line 1178: fnd_message.set_token('API_NAME', l_proc);

1174: hr_utility.set_location('Entering:'|| l_proc, 10);
1175:
1176: if p_disable_range_overlap_check is null then
1177: fnd_message.set_name('PAY', 'HR_7207_API_MANDATORY_ARG');
1178: fnd_message.set_token('API_NAME', l_proc);
1179: fnd_message.set_token('ARGUMENT','DISABLE_RANGE_OVERLAP_CHECK');
1180: fnd_message.raise_error;
1181: end if;
1182:

Line 1179: fnd_message.set_token('ARGUMENT','DISABLE_RANGE_OVERLAP_CHECK');

1175:
1176: if p_disable_range_overlap_check is null then
1177: fnd_message.set_name('PAY', 'HR_7207_API_MANDATORY_ARG');
1178: fnd_message.set_token('API_NAME', l_proc);
1179: fnd_message.set_token('ARGUMENT','DISABLE_RANGE_OVERLAP_CHECK');
1180: fnd_message.raise_error;
1181: end if;
1182:
1183: if p_datetrack_mode = hr_api.g_delete then

Line 1180: fnd_message.raise_error;

1176: if p_disable_range_overlap_check is null then
1177: fnd_message.set_name('PAY', 'HR_7207_API_MANDATORY_ARG');
1178: fnd_message.set_token('API_NAME', l_proc);
1179: fnd_message.set_token('ARGUMENT','DISABLE_RANGE_OVERLAP_CHECK');
1180: fnd_message.raise_error;
1181: end if;
1182:
1183: if p_datetrack_mode = hr_api.g_delete then
1184:

Line 1189: fnd_message.set_name( 'PAY', 'PAY_6982_USERTAB_END_VALUES' );

1185: open csr_delete_mode;
1186: fetch csr_delete_mode into l_exists;
1187: if csr_delete_mode%found then
1188: close csr_delete_mode;
1189: fnd_message.set_name( 'PAY', 'PAY_6982_USERTAB_END_VALUES' );
1190: fnd_message.raise_error;
1191: end if;
1192: close csr_delete_mode;
1193:

Line 1190: fnd_message.raise_error;

1186: fetch csr_delete_mode into l_exists;
1187: if csr_delete_mode%found then
1188: close csr_delete_mode;
1189: fnd_message.set_name( 'PAY', 'PAY_6982_USERTAB_END_VALUES' );
1190: fnd_message.raise_error;
1191: end if;
1192: close csr_delete_mode;
1193:
1194: elsif p_datetrack_mode = hr_api.g_zap then

Line 1200: fnd_message.set_name( 'PAY', 'HR_6980_USERTAB_VALUES_FIRST' ) ;

1196: open csr_zap_mode;
1197: fetch csr_zap_mode into l_exists ;
1198: if csr_zap_mode%found then
1199: close csr_zap_mode;
1200: fnd_message.set_name( 'PAY', 'HR_6980_USERTAB_VALUES_FIRST' ) ;
1201: fnd_message.set_token( 'ROWCOL' , 'row' ) ;
1202: fnd_message.raise_error ;
1203: end if ;
1204: close csr_zap_mode;

Line 1201: fnd_message.set_token( 'ROWCOL' , 'row' ) ;

1197: fetch csr_zap_mode into l_exists ;
1198: if csr_zap_mode%found then
1199: close csr_zap_mode;
1200: fnd_message.set_name( 'PAY', 'HR_6980_USERTAB_VALUES_FIRST' ) ;
1201: fnd_message.set_token( 'ROWCOL' , 'row' ) ;
1202: fnd_message.raise_error ;
1203: end if ;
1204: close csr_zap_mode;
1205:

Line 1202: fnd_message.raise_error ;

1198: if csr_zap_mode%found then
1199: close csr_zap_mode;
1200: fnd_message.set_name( 'PAY', 'HR_6980_USERTAB_VALUES_FIRST' ) ;
1201: fnd_message.set_token( 'ROWCOL' , 'row' ) ;
1202: fnd_message.raise_error ;
1203: end if ;
1204: close csr_zap_mode;
1205:
1206: elsif p_datetrack_mode in (hr_api.g_future_change,hr_api.g_delete_next_change) then

Line 1231: fnd_message.set_name ('PAY','HR_72033_CANNOT_DNC_RECORD');

1227: fetch csr_unique_name into l_exists;
1228:
1229: if csr_unique_name%found then
1230: close csr_unique_name;
1231: fnd_message.set_name ('PAY','HR_72033_CANNOT_DNC_RECORD');
1232: fnd_message.raise_error ;
1233: end if;
1234: close csr_unique_name;
1235: end if;

Line 1232: fnd_message.raise_error ;

1228:
1229: if csr_unique_name%found then
1230: close csr_unique_name;
1231: fnd_message.set_name ('PAY','HR_72033_CANNOT_DNC_RECORD');
1232: fnd_message.raise_error ;
1233: end if;
1234: close csr_unique_name;
1235: end if;
1236:

Line 1246: fnd_message.set_name ('PAY','HR_72033_CANNOT_DNC_RECORD');

1242: fetch csr_row_overlap into l_exists;
1243:
1244: if csr_row_overlap%found then
1245: close csr_row_overlap;
1246: fnd_message.set_name ('PAY','HR_72033_CANNOT_DNC_RECORD');
1247: fnd_message.raise_error ;
1248: end if ;
1249:
1250: close csr_row_overlap;

Line 1247: fnd_message.raise_error ;

1243:
1244: if csr_row_overlap%found then
1245: close csr_row_overlap;
1246: fnd_message.set_name ('PAY','HR_72033_CANNOT_DNC_RECORD');
1247: fnd_message.raise_error ;
1248: end if ;
1249:
1250: close csr_row_overlap;
1251: end if;

Line 1330: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

1326: (p_user_row_id => p_rec.user_row_id
1327: ,p_effective_date => p_effective_date
1328: ,p_object_version_number => p_rec.object_version_number
1329: ) THEN
1330: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1331: fnd_message.set_token('PROCEDURE ', l_proc);
1332: fnd_message.set_token('STEP ', '5');
1333: fnd_message.raise_error;
1334: END IF;

Line 1331: fnd_message.set_token('PROCEDURE ', l_proc);

1327: ,p_effective_date => p_effective_date
1328: ,p_object_version_number => p_rec.object_version_number
1329: ) THEN
1330: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1331: fnd_message.set_token('PROCEDURE ', l_proc);
1332: fnd_message.set_token('STEP ', '5');
1333: fnd_message.raise_error;
1334: END IF;
1335: --

Line 1332: fnd_message.set_token('STEP ', '5');

1328: ,p_object_version_number => p_rec.object_version_number
1329: ) THEN
1330: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1331: fnd_message.set_token('PROCEDURE ', l_proc);
1332: fnd_message.set_token('STEP ', '5');
1333: fnd_message.raise_error;
1334: END IF;
1335: --
1336: --

Line 1333: fnd_message.raise_error;

1329: ) THEN
1330: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1331: fnd_message.set_token('PROCEDURE ', l_proc);
1332: fnd_message.set_token('STEP ', '5');
1333: fnd_message.raise_error;
1334: END IF;
1335: --
1336: --
1337: if nvl(p_rec.user_table_id, hr_api.g_number) <>

Line 1439: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

1435: --
1436: -- An unhandled or unexpected error has occurred which
1437: -- we must report
1438: --
1439: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1440: fnd_message.set_token('PROCEDURE', l_proc);
1441: fnd_message.set_token('STEP','15');
1442: fnd_message.raise_error;
1443: End dt_update_validate;

Line 1440: fnd_message.set_token('PROCEDURE', l_proc);

1436: -- An unhandled or unexpected error has occurred which
1437: -- we must report
1438: --
1439: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1440: fnd_message.set_token('PROCEDURE', l_proc);
1441: fnd_message.set_token('STEP','15');
1442: fnd_message.raise_error;
1443: End dt_update_validate;
1444: --

Line 1441: fnd_message.set_token('STEP','15');

1437: -- we must report
1438: --
1439: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1440: fnd_message.set_token('PROCEDURE', l_proc);
1441: fnd_message.set_token('STEP','15');
1442: fnd_message.raise_error;
1443: End dt_update_validate;
1444: --
1445: -- ----------------------------------------------------------------------------

Line 1442: fnd_message.raise_error;

1438: --
1439: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1440: fnd_message.set_token('PROCEDURE', l_proc);
1441: fnd_message.set_token('STEP','15');
1442: fnd_message.raise_error;
1443: End dt_update_validate;
1444: --
1445: -- ----------------------------------------------------------------------------
1446: -- |--------------------------< dt_delete_validate >--------------------------|

Line 1536: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

1532: --
1533: -- An unhandled or unexpected error has occurred which
1534: -- we must report
1535: --
1536: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1537: fnd_message.set_token('PROCEDURE', l_proc);
1538: fnd_message.set_token('STEP','15');
1539: fnd_message.raise_error;
1540: --

Line 1537: fnd_message.set_token('PROCEDURE', l_proc);

1533: -- An unhandled or unexpected error has occurred which
1534: -- we must report
1535: --
1536: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1537: fnd_message.set_token('PROCEDURE', l_proc);
1538: fnd_message.set_token('STEP','15');
1539: fnd_message.raise_error;
1540: --
1541: End dt_delete_validate;

Line 1538: fnd_message.set_token('STEP','15');

1534: -- we must report
1535: --
1536: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1537: fnd_message.set_token('PROCEDURE', l_proc);
1538: fnd_message.set_token('STEP','15');
1539: fnd_message.raise_error;
1540: --
1541: End dt_delete_validate;
1542: --

Line 1539: fnd_message.raise_error;

1535: --
1536: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1537: fnd_message.set_token('PROCEDURE', l_proc);
1538: fnd_message.set_token('STEP','15');
1539: fnd_message.raise_error;
1540: --
1541: End dt_delete_validate;
1542: --
1543: -- ----------------------------------------------------------------------------

Line 1565: fnd_message.set_name('PAY', 'PAY_33179_BGLEG_INVALID');

1561:
1562: IF (p_insert) THEN
1563:
1564: if p_business_group_id is not null and p_legislation_code is not null then
1565: fnd_message.set_name('PAY', 'PAY_33179_BGLEG_INVALID');
1566: fnd_message.raise_error;
1567: end if;
1568:
1569: hr_startup_data_api_support.chk_startup_action

Line 1566: fnd_message.raise_error;

1562: IF (p_insert) THEN
1563:
1564: if p_business_group_id is not null and p_legislation_code is not null then
1565: fnd_message.set_name('PAY', 'PAY_33179_BGLEG_INVALID');
1566: fnd_message.raise_error;
1567: end if;
1568:
1569: hr_startup_data_api_support.chk_startup_action
1570: (p_generic_allowed => TRUE