97:
98:
99: -- Check for missing and null parameters.
100:
101: IF ( (cn_api.chk_miss_char_para
102: (p_char_para => p_PayGroup_rec.name,
103: p_para_name =>
104: cn_api.get_lkup_meaning('PAY_GROUP_NAME', 'PAY_GROUP_VALIDATION_TYPE'),
105: p_loading_status => x_loading_status,
100:
101: IF ( (cn_api.chk_miss_char_para
102: (p_char_para => p_PayGroup_rec.name,
103: p_para_name =>
104: cn_api.get_lkup_meaning('PAY_GROUP_NAME', 'PAY_GROUP_VALIDATION_TYPE'),
105: p_loading_status => x_loading_status,
106: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
107: THEN
108: RAISE FND_API.G_EXC_ERROR ;
107: THEN
108: RAISE FND_API.G_EXC_ERROR ;
109: END IF;
110:
111: IF ( (cn_api.chk_null_char_para
112: (p_char_para => p_PayGroup_rec.name,
113: p_obj_name =>
114: cn_api.get_lkup_meaning('PAY_GROUP_NAME', 'PAY_GROUP_VALIDATION_TYPE'),
115: p_loading_status => x_loading_status,
110:
111: IF ( (cn_api.chk_null_char_para
112: (p_char_para => p_PayGroup_rec.name,
113: p_obj_name =>
114: cn_api.get_lkup_meaning('PAY_GROUP_NAME', 'PAY_GROUP_VALIDATION_TYPE'),
115: p_loading_status => x_loading_status,
116: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
117: THEN
118: RAISE FND_API.G_EXC_ERROR ;
118: RAISE FND_API.G_EXC_ERROR ;
119: END IF;
120:
121:
122: IF ( (cn_api.chk_miss_date_para
123: (p_date_para => p_PayGroup_rec.start_date,
124: p_para_name =>
125: cn_api.get_lkup_meaning('START_DATE', 'PAY_GROUP_VALIDATION_TYPE'),
126: p_loading_status => x_loading_status,
121:
122: IF ( (cn_api.chk_miss_date_para
123: (p_date_para => p_PayGroup_rec.start_date,
124: p_para_name =>
125: cn_api.get_lkup_meaning('START_DATE', 'PAY_GROUP_VALIDATION_TYPE'),
126: p_loading_status => x_loading_status,
127: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
128: THEN
129: RAISE FND_API.G_EXC_ERROR ;
128: THEN
129: RAISE FND_API.G_EXC_ERROR ;
130: END IF;
131:
132: IF ( (cn_api.chk_null_date_para
133: (p_date_para => p_PayGroup_rec.start_date,
134: p_obj_name =>
135: cn_api.get_lkup_meaning('START_DATE', 'PAY_GROUP_VALIDATION_TYPE'),
136: p_loading_status => x_loading_status,
131:
132: IF ( (cn_api.chk_null_date_para
133: (p_date_para => p_PayGroup_rec.start_date,
134: p_obj_name =>
135: cn_api.get_lkup_meaning('START_DATE', 'PAY_GROUP_VALIDATION_TYPE'),
136: p_loading_status => x_loading_status,
137: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
138: THEN
139: RAISE FND_API.G_EXC_ERROR ;
138: THEN
139: RAISE FND_API.G_EXC_ERROR ;
140: END IF;
141:
142: IF ( (cn_api.chk_miss_date_para
143: (p_date_para => p_PayGroup_rec.end_date,
144: p_para_name =>
145: cn_api.get_lkup_meaning('END_DATE', 'PAY_GROUP_VALIDATION_TYPE'),
146: p_loading_status => x_loading_status,
141:
142: IF ( (cn_api.chk_miss_date_para
143: (p_date_para => p_PayGroup_rec.end_date,
144: p_para_name =>
145: cn_api.get_lkup_meaning('END_DATE', 'PAY_GROUP_VALIDATION_TYPE'),
146: p_loading_status => x_loading_status,
147: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
148: THEN
149: RAISE FND_API.G_EXC_ERROR ;
148: THEN
149: RAISE FND_API.G_EXC_ERROR ;
150: END IF;
151:
152: IF ( (cn_api.chk_null_date_para
153: (p_date_para => p_PayGroup_rec.end_date,
154: p_obj_name =>
155: cn_api.get_lkup_meaning('END_DATE', 'PAY_GROUP_VALIDATION_TYPE'),
156: p_loading_status => x_loading_status,
151:
152: IF ( (cn_api.chk_null_date_para
153: (p_date_para => p_PayGroup_rec.end_date,
154: p_obj_name =>
155: cn_api.get_lkup_meaning('END_DATE', 'PAY_GROUP_VALIDATION_TYPE'),
156: p_loading_status => x_loading_status,
157: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
158: THEN
159: RAISE FND_API.G_EXC_ERROR ;
158: THEN
159: RAISE FND_API.G_EXC_ERROR ;
160: END IF;
161:
162: IF ( (cn_api.chk_miss_num_para
163: (p_num_para => p_PayGroup_rec.org_id,
164: p_para_name =>
165: cn_api.get_lkup_meaning('ORG_ID', 'PAY_GROUP_VALIDATION_TYPE'),
166: p_loading_status => x_loading_status,
161:
162: IF ( (cn_api.chk_miss_num_para
163: (p_num_para => p_PayGroup_rec.org_id,
164: p_para_name =>
165: cn_api.get_lkup_meaning('ORG_ID', 'PAY_GROUP_VALIDATION_TYPE'),
166: p_loading_status => x_loading_status,
167: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
168: THEN
169: RAISE FND_API.G_EXC_ERROR ;
168: THEN
169: RAISE FND_API.G_EXC_ERROR ;
170: END IF;
171:
172: IF ( (cn_api.chk_null_num_para
173: (p_num_para => p_PayGroup_rec.org_id,
174: p_obj_name =>
175: cn_api.get_lkup_meaning('ORG_ID', 'PAY_GROUP_VALIDATION_TYPE'),
176: p_loading_status => x_loading_status,
171:
172: IF ( (cn_api.chk_null_num_para
173: (p_num_para => p_PayGroup_rec.org_id,
174: p_obj_name =>
175: cn_api.get_lkup_meaning('ORG_ID', 'PAY_GROUP_VALIDATION_TYPE'),
176: p_loading_status => x_loading_status,
177: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
178: THEN
179: RAISE FND_API.G_EXC_ERROR ;
178: THEN
179: RAISE FND_API.G_EXC_ERROR ;
180: END IF;
181:
182: IF ( (cn_api.chk_miss_char_para
183: (p_char_para => p_PayGroup_rec.period_set_name,
184: p_para_name =>
185: cn_api.get_lkup_meaning('PERIOD_SET_NAME', 'PAY_GROUP_VALIDATION_TYPE'),
186: p_loading_status => x_loading_status,
181:
182: IF ( (cn_api.chk_miss_char_para
183: (p_char_para => p_PayGroup_rec.period_set_name,
184: p_para_name =>
185: cn_api.get_lkup_meaning('PERIOD_SET_NAME', 'PAY_GROUP_VALIDATION_TYPE'),
186: p_loading_status => x_loading_status,
187: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
188: THEN
189: RAISE FND_API.G_EXC_ERROR ;
188: THEN
189: RAISE FND_API.G_EXC_ERROR ;
190: END IF;
191:
192: IF ( (cn_api.chk_null_char_para
193: (p_char_para => p_PayGroup_rec.period_set_name,
194: p_obj_name =>
195: cn_api.get_lkup_meaning('PERIOD_SET_NAME', 'PAY_GROUP_VALIDATION_TYPE'),
196: p_loading_status => x_loading_status,
191:
192: IF ( (cn_api.chk_null_char_para
193: (p_char_para => p_PayGroup_rec.period_set_name,
194: p_obj_name =>
195: cn_api.get_lkup_meaning('PERIOD_SET_NAME', 'PAY_GROUP_VALIDATION_TYPE'),
196: p_loading_status => x_loading_status,
197: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
198: THEN
199: RAISE FND_API.G_EXC_ERROR ;
198: THEN
199: RAISE FND_API.G_EXC_ERROR ;
200: END IF;
201:
202: IF ( (cn_api.chk_miss_char_para
203: (p_char_para => p_PayGroup_rec.period_type,
204: p_para_name =>
205: cn_api.get_lkup_meaning('PERIOD_TYPE', 'PAY_GROUP_VALIDATION_TYPE'),
206: p_loading_status => x_loading_status,
201:
202: IF ( (cn_api.chk_miss_char_para
203: (p_char_para => p_PayGroup_rec.period_type,
204: p_para_name =>
205: cn_api.get_lkup_meaning('PERIOD_TYPE', 'PAY_GROUP_VALIDATION_TYPE'),
206: p_loading_status => x_loading_status,
207: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
208: THEN
209: RAISE FND_API.G_EXC_ERROR ;
208: THEN
209: RAISE FND_API.G_EXC_ERROR ;
210: END IF;
211:
212: IF ( (cn_api.chk_null_char_para
213: (p_char_para => p_PayGroup_rec.period_type,
214: p_obj_name =>
215: cn_api.get_lkup_meaning('PERIOD_TYPE', 'PAY_GROUP_VALIDATION_TYPE'),
216: p_loading_status => x_loading_status,
211:
212: IF ( (cn_api.chk_null_char_para
213: (p_char_para => p_PayGroup_rec.period_type,
214: p_obj_name =>
215: cn_api.get_lkup_meaning('PERIOD_TYPE', 'PAY_GROUP_VALIDATION_TYPE'),
216: p_loading_status => x_loading_status,
217: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
218: THEN
219: RAISE FND_API.G_EXC_ERROR ;
1008:
1009:
1010: CLOSE get_period_set_id;
1011: ELSE
1012: l_period_set_id := cn_api.g_miss_id;
1013: END IF;
1014:
1015: --Check if period_type is valid
1016: IF p_paygroup_rec.period_type IS NOT NULL
1032: END IF;
1033:
1034: CLOSE get_period_type_id;
1035: ELSE
1036: l_period_type_id := cn_api.g_miss_id;
1037: END IF;
1038:
1039: select 1 into l_valid_data from dual where exists
1040: (select count(cp.pay_date) from