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: --
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;
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: --
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;
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: --
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
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;
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: --
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: --
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;
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;
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:
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: --
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.
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: --
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
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;
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: --
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;
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: --
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: --
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;
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;
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: --
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:
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:
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;
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: --
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;
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: --
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: --
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;
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;
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: --
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;
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: --
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: --
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;
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: --
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;
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: --
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;
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
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