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

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

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

Line 199: fnd_message.set_name( 'PAY' , 'PAY_33257_INV_UKEY2' );

195: if csr_unique_key%found then
196:
197: close csr_unique_key;
198:
199: fnd_message.set_name( 'PAY' , 'PAY_33257_INV_UKEY2' );
200: fnd_message.set_token( 'COL1' , 'REPORT_TYPE');
201: fnd_message.set_token( 'COL2' , 'REPORT_QUALIFIER');
202: fnd_message.set_token( 'COL3' , 'REPORT_CATEGORY');
203: fnd_message.set_token( 'COL1_VAL', p_report_type);

Line 200: fnd_message.set_token( 'COL1' , 'REPORT_TYPE');

196:
197: close csr_unique_key;
198:
199: fnd_message.set_name( 'PAY' , 'PAY_33257_INV_UKEY2' );
200: fnd_message.set_token( 'COL1' , 'REPORT_TYPE');
201: fnd_message.set_token( 'COL2' , 'REPORT_QUALIFIER');
202: fnd_message.set_token( 'COL3' , 'REPORT_CATEGORY');
203: fnd_message.set_token( 'COL1_VAL', p_report_type);
204: fnd_message.set_token( 'COL2_VAL', p_report_qualifier);

Line 201: fnd_message.set_token( 'COL2' , 'REPORT_QUALIFIER');

197: close csr_unique_key;
198:
199: fnd_message.set_name( 'PAY' , 'PAY_33257_INV_UKEY2' );
200: fnd_message.set_token( 'COL1' , 'REPORT_TYPE');
201: fnd_message.set_token( 'COL2' , 'REPORT_QUALIFIER');
202: fnd_message.set_token( 'COL3' , 'REPORT_CATEGORY');
203: fnd_message.set_token( 'COL1_VAL', p_report_type);
204: fnd_message.set_token( 'COL2_VAL', p_report_qualifier);
205: fnd_message.set_token( 'COL3_VAL', p_report_category);

Line 202: fnd_message.set_token( 'COL3' , 'REPORT_CATEGORY');

198:
199: fnd_message.set_name( 'PAY' , 'PAY_33257_INV_UKEY2' );
200: fnd_message.set_token( 'COL1' , 'REPORT_TYPE');
201: fnd_message.set_token( 'COL2' , 'REPORT_QUALIFIER');
202: fnd_message.set_token( 'COL3' , 'REPORT_CATEGORY');
203: fnd_message.set_token( 'COL1_VAL', p_report_type);
204: fnd_message.set_token( 'COL2_VAL', p_report_qualifier);
205: fnd_message.set_token( 'COL3_VAL', p_report_category);
206: fnd_message.raise_error ;

Line 203: fnd_message.set_token( 'COL1_VAL', p_report_type);

199: fnd_message.set_name( 'PAY' , 'PAY_33257_INV_UKEY2' );
200: fnd_message.set_token( 'COL1' , 'REPORT_TYPE');
201: fnd_message.set_token( 'COL2' , 'REPORT_QUALIFIER');
202: fnd_message.set_token( 'COL3' , 'REPORT_CATEGORY');
203: fnd_message.set_token( 'COL1_VAL', p_report_type);
204: fnd_message.set_token( 'COL2_VAL', p_report_qualifier);
205: fnd_message.set_token( 'COL3_VAL', p_report_category);
206: fnd_message.raise_error ;
207:

Line 204: fnd_message.set_token( 'COL2_VAL', p_report_qualifier);

200: fnd_message.set_token( 'COL1' , 'REPORT_TYPE');
201: fnd_message.set_token( 'COL2' , 'REPORT_QUALIFIER');
202: fnd_message.set_token( 'COL3' , 'REPORT_CATEGORY');
203: fnd_message.set_token( 'COL1_VAL', p_report_type);
204: fnd_message.set_token( 'COL2_VAL', p_report_qualifier);
205: fnd_message.set_token( 'COL3_VAL', p_report_category);
206: fnd_message.raise_error ;
207:
208: end if ;

Line 205: fnd_message.set_token( 'COL3_VAL', p_report_category);

201: fnd_message.set_token( 'COL2' , 'REPORT_QUALIFIER');
202: fnd_message.set_token( 'COL3' , 'REPORT_CATEGORY');
203: fnd_message.set_token( 'COL1_VAL', p_report_type);
204: fnd_message.set_token( 'COL2_VAL', p_report_qualifier);
205: fnd_message.set_token( 'COL3_VAL', p_report_category);
206: fnd_message.raise_error ;
207:
208: end if ;
209:

Line 206: fnd_message.raise_error ;

202: fnd_message.set_token( 'COL3' , 'REPORT_CATEGORY');
203: fnd_message.set_token( 'COL1_VAL', p_report_type);
204: fnd_message.set_token( 'COL2_VAL', p_report_qualifier);
205: fnd_message.set_token( 'COL3_VAL', p_report_category);
206: fnd_message.raise_error ;
207:
208: end if ;
209:
210: close csr_unique_key;

Line 303: fnd_message.set_name( 'PAY' , 'PAY_33259_INVALID_UFLAG' );

299:
300: if p_updatable_flag is not null and
301: p_updatable_flag not in ('Y', 'N') then
302:
303: fnd_message.set_name( 'PAY' , 'PAY_33259_INVALID_UFLAG' );
304: fnd_message.raise_error ;
305:
306: end if;
307:

Line 304: fnd_message.raise_error ;

300: if p_updatable_flag is not null and
301: p_updatable_flag not in ('Y', 'N') then
302:
303: fnd_message.set_name( 'PAY' , 'PAY_33259_INVALID_UFLAG' );
304: fnd_message.raise_error ;
305:
306: end if;
307:
308: --

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

354: fetch csr_legislation_code into l_exists ;
355:
356: if csr_legislation_code%notfound then
357: close csr_legislation_code;
358: fnd_message.set_name('PAY', 'PAY_33177_LEG_CODE_INVALID');
359: fnd_message.raise_error;
360: end if;
361: close csr_legislation_code;
362:

Line 359: fnd_message.raise_error;

355:
356: if csr_legislation_code%notfound then
357: close csr_legislation_code;
358: fnd_message.set_name('PAY', 'PAY_33177_LEG_CODE_INVALID');
359: fnd_message.raise_error;
360: end if;
361: close csr_legislation_code;
362:
363: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 454: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');

450: if csr_dt_rfi_exists%found then
451:
452: close csr_dt_rfi_exists;
453:
454: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
455: fnd_message.set_token('TABLE_NAME', 'PAY_REPORT_FORMAT_ITEMS_F');
456: fnd_message.raise_error;
457:
458: end if;

Line 455: fnd_message.set_token('TABLE_NAME', 'PAY_REPORT_FORMAT_ITEMS_F');

451:
452: close csr_dt_rfi_exists;
453:
454: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
455: fnd_message.set_token('TABLE_NAME', 'PAY_REPORT_FORMAT_ITEMS_F');
456: fnd_message.raise_error;
457:
458: end if;
459: close csr_dt_rfi_exists;

Line 456: fnd_message.raise_error;

452: close csr_dt_rfi_exists;
453:
454: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
455: fnd_message.set_token('TABLE_NAME', 'PAY_REPORT_FORMAT_ITEMS_F');
456: fnd_message.raise_error;
457:
458: end if;
459: close csr_dt_rfi_exists;
460:

Line 471: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');

467: if csr_rfi_exists%found then
468:
469: close csr_rfi_exists;
470:
471: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
472: fnd_message.set_token('TABLE_NAME', 'PAY_REPORT_FORMAT_ITEMS_F');
473: fnd_message.raise_error;
474:
475: end if;

Line 472: fnd_message.set_token('TABLE_NAME', 'PAY_REPORT_FORMAT_ITEMS_F');

468:
469: close csr_rfi_exists;
470:
471: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
472: fnd_message.set_token('TABLE_NAME', 'PAY_REPORT_FORMAT_ITEMS_F');
473: fnd_message.raise_error;
474:
475: end if;
476: close csr_rfi_exists;

Line 473: fnd_message.raise_error;

469: close csr_rfi_exists;
470:
471: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
472: fnd_message.set_token('TABLE_NAME', 'PAY_REPORT_FORMAT_ITEMS_F');
473: fnd_message.raise_error;
474:
475: end if;
476: close csr_rfi_exists;
477:

Line 484: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');

480: if csr_rfp_exists%found then
481:
482: close csr_rfp_exists;
483:
484: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
485: fnd_message.set_token('TABLE_NAME', 'PAY_REPORT_FORMAT_PARAMETERS');
486: fnd_message.raise_error;
487:
488: end if;

Line 485: fnd_message.set_token('TABLE_NAME', 'PAY_REPORT_FORMAT_PARAMETERS');

481:
482: close csr_rfp_exists;
483:
484: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
485: fnd_message.set_token('TABLE_NAME', 'PAY_REPORT_FORMAT_PARAMETERS');
486: fnd_message.raise_error;
487:
488: end if;
489: close csr_rfp_exists;

Line 486: fnd_message.raise_error;

482: close csr_rfp_exists;
483:
484: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
485: fnd_message.set_token('TABLE_NAME', 'PAY_REPORT_FORMAT_PARAMETERS');
486: fnd_message.raise_error;
487:
488: end if;
489: close csr_rfp_exists;
490:

Line 497: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');

493: if csr_rftl_exists%found then
494:
495: close csr_rftl_exists;
496:
497: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
498: fnd_message.set_token('TABLE_NAME', 'PAY_REPORT_FORMAT_MAPPINGS_TL');
499: fnd_message.raise_error;
500:
501: end if;

Line 498: fnd_message.set_token('TABLE_NAME', 'PAY_REPORT_FORMAT_MAPPINGS_TL');

494:
495: close csr_rftl_exists;
496:
497: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
498: fnd_message.set_token('TABLE_NAME', 'PAY_REPORT_FORMAT_MAPPINGS_TL');
499: fnd_message.raise_error;
500:
501: end if;
502: close csr_rftl_exists;

Line 499: fnd_message.raise_error;

495: close csr_rftl_exists;
496:
497: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
498: fnd_message.set_token('TABLE_NAME', 'PAY_REPORT_FORMAT_MAPPINGS_TL');
499: fnd_message.raise_error;
500:
501: end if;
502: close csr_rftl_exists;
503:

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

550: (p_report_format_mapping_id => p_rec.report_format_mapping_id
551: ,p_effective_date => p_effective_date
552: ,p_object_version_number => p_rec.object_version_number
553: ) THEN
554: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
555: fnd_message.set_token('PROCEDURE ', l_proc);
556: fnd_message.set_token('STEP ', '5');
557: fnd_message.raise_error;
558: END IF;

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

551: ,p_effective_date => p_effective_date
552: ,p_object_version_number => p_rec.object_version_number
553: ) THEN
554: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
555: fnd_message.set_token('PROCEDURE ', l_proc);
556: fnd_message.set_token('STEP ', '5');
557: fnd_message.raise_error;
558: END IF;
559: --

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

552: ,p_object_version_number => p_rec.object_version_number
553: ) THEN
554: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
555: fnd_message.set_token('PROCEDURE ', l_proc);
556: fnd_message.set_token('STEP ', '5');
557: fnd_message.raise_error;
558: END IF;
559: --
560: --

Line 557: fnd_message.raise_error;

553: ) THEN
554: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
555: fnd_message.set_token('PROCEDURE ', l_proc);
556: fnd_message.set_token('STEP ', '5');
557: fnd_message.raise_error;
558: END IF;
559: --
560: --
561: if nvl(p_rec.business_group_id, hr_api.g_number) <>

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

675: --
676: -- An unhandled or unexpected error has occurred which
677: -- we must report
678: --
679: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
680: fnd_message.set_token('PROCEDURE', l_proc);
681: fnd_message.set_token('STEP','15');
682: fnd_message.raise_error;
683: End dt_update_validate;

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

676: -- An unhandled or unexpected error has occurred which
677: -- we must report
678: --
679: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
680: fnd_message.set_token('PROCEDURE', l_proc);
681: fnd_message.set_token('STEP','15');
682: fnd_message.raise_error;
683: End dt_update_validate;
684: --

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

677: -- we must report
678: --
679: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
680: fnd_message.set_token('PROCEDURE', l_proc);
681: fnd_message.set_token('STEP','15');
682: fnd_message.raise_error;
683: End dt_update_validate;
684: --
685: -- ----------------------------------------------------------------------------

Line 682: fnd_message.raise_error;

678: --
679: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
680: fnd_message.set_token('PROCEDURE', l_proc);
681: fnd_message.set_token('STEP','15');
682: fnd_message.raise_error;
683: End dt_update_validate;
684: --
685: -- ----------------------------------------------------------------------------
686: -- |--------------------------< dt_delete_validate >--------------------------|

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

770: --
771: -- An unhandled or unexpected error has occurred which
772: -- we must report
773: --
774: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
775: fnd_message.set_token('PROCEDURE', l_proc);
776: fnd_message.set_token('STEP','15');
777: fnd_message.raise_error;
778: --

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

771: -- An unhandled or unexpected error has occurred which
772: -- we must report
773: --
774: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
775: fnd_message.set_token('PROCEDURE', l_proc);
776: fnd_message.set_token('STEP','15');
777: fnd_message.raise_error;
778: --
779: End dt_delete_validate;

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

772: -- we must report
773: --
774: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
775: fnd_message.set_token('PROCEDURE', l_proc);
776: fnd_message.set_token('STEP','15');
777: fnd_message.raise_error;
778: --
779: End dt_delete_validate;
780: --

Line 777: fnd_message.raise_error;

773: --
774: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
775: fnd_message.set_token('PROCEDURE', l_proc);
776: fnd_message.set_token('STEP','15');
777: fnd_message.raise_error;
778: --
779: End dt_delete_validate;
780: --
781: -- ----------------------------------------------------------------------------

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

797: --
798: -- Call the supporting procedure to check startup mode
799:
800: if p_business_group_id is not null and p_legislation_code is not null then
801: fnd_message.set_name('PAY', 'PAY_33179_BGLEG_INVALID');
802: fnd_message.raise_error;
803: end if;
804:
805: IF (p_insert) THEN

Line 802: fnd_message.raise_error;

798: -- Call the supporting procedure to check startup mode
799:
800: if p_business_group_id is not null and p_legislation_code is not null then
801: fnd_message.set_name('PAY', 'PAY_33179_BGLEG_INVALID');
802: fnd_message.raise_error;
803: end if;
804:
805: IF (p_insert) THEN
806: hr_startup_data_api_support.chk_startup_action