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.BEN_WHATIF_ELIG dependencies on FND_MESSAGE

Line 83: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');

79: If p_DATE_START is null and p_DATE_END is null and
80: p_ABSENCE_ATTENDANCE_TYPE_ID is null and
81: p_ABS_ATTENDANCE_REASON_ID is null then
82: --
83: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');
84: fnd_message.raise_error;
85: --
86: End If;
87: --

Line 84: fnd_message.raise_error;

80: p_ABSENCE_ATTENDANCE_TYPE_ID is null and
81: p_ABS_ATTENDANCE_REASON_ID is null then
82: --
83: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');
84: fnd_message.raise_error;
85: --
86: End If;
87: --
88: open c_abs_att;

Line 197: fnd_message.set_name('BEN','BEN_91440_NO_ABS_ATT');

193: X_ABS_INFORMATION29 => NULL,
194: X_ABS_INFORMATION30 => NULL
195: );
196: /*
197: fnd_message.set_name('BEN','BEN_91440_NO_ABS_ATT');
198: fnd_message.raise_error;
199: */
200: else
201: --

Line 198: fnd_message.raise_error;

194: X_ABS_INFORMATION30 => NULL
195: );
196: /*
197: fnd_message.set_name('BEN','BEN_91440_NO_ABS_ATT');
198: fnd_message.raise_error;
199: */
200: else
201: --
202: Close c_abs_att;

Line 356: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');

352: p_PERSONAL_FLAG is null and p_START_LIFE_REASON_ID is null and
353: p_END_LIFE_REASON_ID is null and p_RLTD_PER_RSDS_W_DSGNTR_FLAG is null
354: then
355: --
356: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');
357: fnd_message.raise_error;
358: --
359: End If;
360: --

Line 357: fnd_message.raise_error;

353: p_END_LIFE_REASON_ID is null and p_RLTD_PER_RSDS_W_DSGNTR_FLAG is null
354: then
355: --
356: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');
357: fnd_message.raise_error;
358: --
359: End If;
360: --
361: if p_contact_person_id is not null then

Line 370: fnd_message.set_name('BEN','BEN_91441_NO_CTR');

366: Close c_ctr;
367: --
368: -- Contact Relationship Record is Not found so error.
369: --
370: fnd_message.set_name('BEN','BEN_91441_NO_CTR');
371: fnd_message.raise_error;
372: --
373: End If;
374: Close c_ctr;

Line 371: fnd_message.raise_error;

367: --
368: -- Contact Relationship Record is Not found so error.
369: --
370: fnd_message.set_name('BEN','BEN_91441_NO_CTR');
371: fnd_message.raise_error;
372: --
373: End If;
374: Close c_ctr;
375: --

Line 777: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');

773: p_DATE_FROM is null and p_DATE_TO is null and
774: p_REGION_2 is null and p_ADDRESS_TYPE is null
775: then
776: --
777: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');
778: fnd_message.raise_error;
779: --
780: End If;
781: --

Line 778: fnd_message.raise_error;

774: p_REGION_2 is null and p_ADDRESS_TYPE is null
775: then
776: --
777: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');
778: fnd_message.raise_error;
779: --
780: End If;
781: --
782: open c_addr;

Line 789: fnd_message.set_name('BEN','BEN_91442_NO_ADDRESS');

785: Close c_addr;
786: --
787: -- Address Not found so error.
788: --
789: fnd_message.set_name('BEN','BEN_91442_NO_ADDRESS');
790: fnd_message.raise_error;
791: --
792: End If;
793: Close c_addr;

Line 790: fnd_message.raise_error;

786: --
787: -- Address Not found so error.
788: --
789: fnd_message.set_name('BEN','BEN_91442_NO_ADDRESS');
790: fnd_message.raise_error;
791: --
792: End If;
793: Close c_addr;
794:

Line 849: fnd_message.set_name('BEN', 'BEN_91448_NO_CT_ST_CNTY');

845: Close csr_valid_city_state;
846: --
847: -- City State Not Found.
848: --
849: fnd_message.set_name('BEN', 'BEN_91448_NO_CT_ST_CNTY');
850: fnd_message.raise_error;
851: End If;
852: Close csr_valid_city_state;
853: --

Line 850: fnd_message.raise_error;

846: --
847: -- City State Not Found.
848: --
849: fnd_message.set_name('BEN', 'BEN_91448_NO_CT_ST_CNTY');
850: fnd_message.raise_error;
851: End If;
852: Close csr_valid_city_state;
853: --
854: -- Assign the fetched values to the Record fields.

Line 1158: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');

1154: p_ASS_ATTRIBUTE8 is null and
1155: p_ASS_ATTRIBUTE9 is null
1156: then
1157: --
1158: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');
1159: fnd_message.raise_error;
1160: --
1161: End If;
1162: --

Line 1159: fnd_message.raise_error;

1155: p_ASS_ATTRIBUTE9 is null
1156: then
1157: --
1158: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');
1159: fnd_message.raise_error;
1160: --
1161: End If;
1162: --
1163: if p_LABOUR_UNION_MEMBER_FLAG is not null or

Line 1241: fnd_message.set_name('BEN','BEN_91443_NO_ASSGN');

1237: Close c_assign;
1238: --
1239: -- Assignment Record is Not found so error.
1240: --
1241: fnd_message.set_name('BEN','BEN_91443_NO_ASSGN');
1242: fnd_message.raise_error;
1243: --
1244: End If;
1245: Close c_assign;

Line 1242: fnd_message.raise_error;

1238: --
1239: -- Assignment Record is Not found so error.
1240: --
1241: fnd_message.set_name('BEN','BEN_91443_NO_ASSGN');
1242: fnd_message.raise_error;
1243: --
1244: End If;
1245: Close c_assign;
1246: --

Line 1337: fnd_message.set_name('BEN','BEN_91443_NO_ASSGN');

1333: Close c_assign;
1334: --
1335: -- Assignment Record is Not found so error.
1336: --
1337: fnd_message.set_name('BEN','BEN_91443_NO_ASSGN');
1338: fnd_message.raise_error;
1339: --
1340: End If;
1341: Close c_assign;

Line 1338: fnd_message.raise_error;

1334: --
1335: -- Assignment Record is Not found so error.
1336: --
1337: fnd_message.set_name('BEN','BEN_91443_NO_ASSGN');
1338: fnd_message.raise_error;
1339: --
1340: End If;
1341: Close c_assign;
1342: --

Line 1699: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');

1695: p_RECEIPT_OF_DEATH_CERT_DATE is null and
1696: p_sex is null
1697: then
1698: --
1699: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');
1700: fnd_message.raise_error;
1701: --
1702: End If;
1703: --

Line 1700: fnd_message.raise_error;

1696: p_sex is null
1697: then
1698: --
1699: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');
1700: fnd_message.raise_error;
1701: --
1702: End If;
1703: --
1704: open c_person;

Line 1711: fnd_message.set_name('BEN','BEN_91444_NO_PER');

1707: Close c_person;
1708: --
1709: -- Person Record is Not found so error.
1710: --
1711: fnd_message.set_name('BEN','BEN_91444_NO_PER');
1712: fnd_message.raise_error;
1713: --
1714: End If;
1715: Close c_person;

Line 1712: fnd_message.raise_error;

1708: --
1709: -- Person Record is Not found so error.
1710: --
1711: fnd_message.set_name('BEN','BEN_91444_NO_PER');
1712: fnd_message.raise_error;
1713: --
1714: End If;
1715: Close c_person;
1716: --

Line 2169: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');

2165: p_ATTRIBUTE20 is null and
2166: p_FINAL_PROCESS_DATE is null and
2167: p_ACTUAL_TERMINATION_DATE is null then
2168: --
2169: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');
2170: fnd_message.raise_error;
2171: --
2172: End If;
2173:

Line 2170: fnd_message.raise_error;

2166: p_FINAL_PROCESS_DATE is null and
2167: p_ACTUAL_TERMINATION_DATE is null then
2168: --
2169: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');
2170: fnd_message.raise_error;
2171: --
2172: End If;
2173:
2174:

Line 2211: fnd_message.set_name('BEN','BEN_91445_NO_PERIODS_SERVICE');

2207: Close c_service;
2208: --
2209: -- Periods of Service Record is Not found so error.
2210: --
2211: fnd_message.set_name('BEN','BEN_91445_NO_PERIODS_SERVICE');
2212: fnd_message.raise_error;
2213: --
2214: End If;
2215: Close c_service;

Line 2212: fnd_message.raise_error;

2208: --
2209: -- Periods of Service Record is Not found so error.
2210: --
2211: fnd_message.set_name('BEN','BEN_91445_NO_PERIODS_SERVICE');
2212: fnd_message.raise_error;
2213: --
2214: End If;
2215: Close c_service;
2216: --

Line 2345: fnd_message.set_name('BEN','BEN_91445_NO_PERIODS_SERVICE');

2341: Close c_service;
2342: --
2343: -- Periods of Service Record is Not found so error.
2344: --
2345: fnd_message.set_name('BEN','BEN_91445_NO_PERIODS_SERVICE');
2346: fnd_message.raise_error;
2347: --
2348: End If;
2349: Close c_service;

Line 2346: fnd_message.raise_error;

2342: --
2343: -- Periods of Service Record is Not found so error.
2344: --
2345: fnd_message.set_name('BEN','BEN_91445_NO_PERIODS_SERVICE');
2346: fnd_message.raise_error;
2347: --
2348: End If;
2349: Close c_service;
2350: --

Line 2616: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');

2612: hr_utility.set_location(' Entering: WATIF_PERSON_TYPE_USAGES_F_API' , 10);
2613: --
2614: If p_PERSON_TYPE_ID is null then
2615: --
2616: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');
2617: fnd_message.raise_error;
2618: --
2619: End If;
2620: --

Line 2617: fnd_message.raise_error;

2613: --
2614: If p_PERSON_TYPE_ID is null then
2615: --
2616: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');
2617: fnd_message.raise_error;
2618: --
2619: End If;
2620: --
2621: open c_per_usg;

Line 2628: fnd_message.set_name('BEN','BEN_91446_NO_PER_USG');

2624: Close c_per_usg;
2625: --
2626: -- Person Usage Type Record is Not found so error.
2627: --
2628: fnd_message.set_name('BEN','BEN_91446_NO_PER_USG');
2629: fnd_message.raise_error;
2630: --
2631: End If;
2632: Close c_per_usg;

Line 2629: fnd_message.raise_error;

2625: --
2626: -- Person Usage Type Record is Not found so error.
2627: --
2628: fnd_message.set_name('BEN','BEN_91446_NO_PER_USG');
2629: fnd_message.raise_error;
2630: --
2631: End If;
2632: Close c_per_usg;
2633: --

Line 2720: fnd_message.set_name('BEN','BEN_91445_NO_PERIODS_SERVICE');

2716: Close c_service;
2717: --
2718: -- Periods of Service Record is Not found so error.
2719: --
2720: fnd_message.set_name('BEN','BEN_91445_NO_PERIODS_SERVICE');
2721: fnd_message.raise_error;
2722: --
2723: End If;
2724: Close c_service;

Line 2721: fnd_message.raise_error;

2717: --
2718: -- Periods of Service Record is Not found so error.
2719: --
2720: fnd_message.set_name('BEN','BEN_91445_NO_PERIODS_SERVICE');
2721: fnd_message.raise_error;
2722: --
2723: End If;
2724: Close c_service;
2725: --

Line 2849: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');

2845: If p_CRT_ORDR_TYP_CD is null and p_APLS_PERD_STRTG_DT is null and
2846: p_APLS_PERD_ENDG_DT is null and p_pl_id is null
2847: then
2848: --
2849: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');
2850: fnd_message.raise_error;
2851: --
2852: End If;
2853: --

Line 2850: fnd_message.raise_error;

2846: p_APLS_PERD_ENDG_DT is null and p_pl_id is null
2847: then
2848: --
2849: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');
2850: fnd_message.raise_error;
2851: --
2852: End If;
2853: --
2854: open c_crt_ordr;

Line 3079: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');

3075: --
3076: If p_ASSIGNMENT_BUDGET_VALUE_ID is null and p_VALUE is null
3077: then
3078: --
3079: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');
3080: fnd_message.raise_error;
3081: --
3082: End If;
3083: --

Line 3080: fnd_message.raise_error;

3076: If p_ASSIGNMENT_BUDGET_VALUE_ID is null and p_VALUE is null
3077: then
3078: --
3079: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');
3080: fnd_message.raise_error;
3081: --
3082: End If;
3083: --
3084: open c_asg_bud;

Line 3153: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');

3149: If p_BNFTS_BAL_ID is null and p_VAL is null and
3150: p_EFFECTIVE_START_DATE is null and p_EFFECTIVE_END_DATE is null
3151: then
3152: --
3153: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');
3154: fnd_message.raise_error;
3155: --
3156: End If;
3157: --

Line 3154: fnd_message.raise_error;

3150: p_EFFECTIVE_START_DATE is null and p_EFFECTIVE_END_DATE is null
3151: then
3152: --
3153: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');
3154: fnd_message.raise_error;
3155: --
3156: End If;
3157: --
3158: open c_bnfts_bal;

Line 4451: fnd_message.set_name('BEN','BEN_91443_NO_ASSGN');

4447: null;
4448: fetch c_assign into l_assign;
4449: if c_assign%notfound then
4450: --
4451: fnd_message.set_name('BEN','BEN_91443_NO_ASSGN');
4452: fnd_message.raise_error;
4453: --
4454: else
4455: insert into per_assignment_budget_values_f

Line 4452: fnd_message.raise_error;

4448: fetch c_assign into l_assign;
4449: if c_assign%notfound then
4450: --
4451: fnd_message.set_name('BEN','BEN_91443_NO_ASSGN');
4452: fnd_message.raise_error;
4453: --
4454: else
4455: insert into per_assignment_budget_values_f
4456: (assignment_budget_value_id