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.CN_PAYGROUP_PVT dependencies on FND_API

Line 39: x_return_status := FND_API.G_RET_STS_SUCCESS;

35:
36: BEGIN
37:
38: -- Initialize API return status to success
39: x_return_status := FND_API.G_RET_STS_SUCCESS;
40: x_loading_status := p_loading_status ;
41:
42: OPEN get_PayGroup_id;
43: FETCH get_PayGroup_id INTO l_get_PayGroup_id_rec;

Line 60: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

56: CLOSE get_PayGroup_id;
57:
58: EXCEPTION
59: WHEN OTHERS THEN
60: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
61: x_loading_status := 'UNEXPECTED_ERR';
62: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
63: THEN
64: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

Line 95: x_return_status := FND_API.G_RET_STS_SUCCESS;

91:
92: BEGIN
93:
94: -- Initialize API return status to success
95: x_return_status := FND_API.G_RET_STS_SUCCESS;
96: x_loading_status := p_loading_status ;
97:
98:
99: -- Check for missing and null parameters.

Line 106: x_loading_status => x_loading_status)) = FND_API.G_TRUE )

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 ;
109: END IF;
110:

Line 108: RAISE FND_API.G_EXC_ERROR ;

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 ;
109: END IF;
110:
111: IF ( (cn_api.chk_null_char_para
112: (p_char_para => p_PayGroup_rec.name,

Line 116: x_loading_status => x_loading_status)) = FND_API.G_TRUE )

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 ;
119: END IF;
120:

Line 118: RAISE FND_API.G_EXC_ERROR ;

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 ;
119: END IF;
120:
121:
122: IF ( (cn_api.chk_miss_date_para

Line 127: x_loading_status => x_loading_status)) = FND_API.G_TRUE )

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 ;
130: END IF;
131:

Line 129: RAISE FND_API.G_EXC_ERROR ;

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 ;
130: END IF;
131:
132: IF ( (cn_api.chk_null_date_para
133: (p_date_para => p_PayGroup_rec.start_date,

Line 137: x_loading_status => x_loading_status)) = FND_API.G_TRUE )

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 ;
140: END IF;
141:

Line 139: RAISE FND_API.G_EXC_ERROR ;

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 ;
140: END IF;
141:
142: IF ( (cn_api.chk_miss_date_para
143: (p_date_para => p_PayGroup_rec.end_date,

Line 147: x_loading_status => x_loading_status)) = FND_API.G_TRUE )

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 ;
150: END IF;
151:

Line 149: RAISE FND_API.G_EXC_ERROR ;

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 ;
150: END IF;
151:
152: IF ( (cn_api.chk_null_date_para
153: (p_date_para => p_PayGroup_rec.end_date,

Line 157: x_loading_status => x_loading_status)) = FND_API.G_TRUE )

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 ;
160: END IF;
161:

Line 159: RAISE FND_API.G_EXC_ERROR ;

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 ;
160: END IF;
161:
162: IF ( (cn_api.chk_miss_num_para
163: (p_num_para => p_PayGroup_rec.org_id,

Line 167: x_loading_status => x_loading_status)) = FND_API.G_TRUE )

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 ;
170: END IF;
171:

Line 169: RAISE FND_API.G_EXC_ERROR ;

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 ;
170: END IF;
171:
172: IF ( (cn_api.chk_null_num_para
173: (p_num_para => p_PayGroup_rec.org_id,

Line 177: x_loading_status => x_loading_status)) = FND_API.G_TRUE )

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 ;
180: END IF;
181:

Line 179: RAISE FND_API.G_EXC_ERROR ;

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 ;
180: END IF;
181:
182: IF ( (cn_api.chk_miss_char_para
183: (p_char_para => p_PayGroup_rec.period_set_name,

Line 187: x_loading_status => x_loading_status)) = FND_API.G_TRUE )

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 ;
190: END IF;
191:

Line 189: RAISE FND_API.G_EXC_ERROR ;

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 ;
190: END IF;
191:
192: IF ( (cn_api.chk_null_char_para
193: (p_char_para => p_PayGroup_rec.period_set_name,

Line 197: x_loading_status => x_loading_status)) = FND_API.G_TRUE )

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 ;
200: END IF;
201:

Line 199: RAISE FND_API.G_EXC_ERROR ;

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 ;
200: END IF;
201:
202: IF ( (cn_api.chk_miss_char_para
203: (p_char_para => p_PayGroup_rec.period_type,

Line 207: x_loading_status => x_loading_status)) = FND_API.G_TRUE )

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 ;
210: END IF;
211:

Line 209: RAISE FND_API.G_EXC_ERROR ;

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 ;
210: END IF;
211:
212: IF ( (cn_api.chk_null_char_para
213: (p_char_para => p_PayGroup_rec.period_type,

Line 217: x_loading_status => x_loading_status)) = FND_API.G_TRUE )

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 ;
220: END IF;
221:

Line 219: RAISE FND_API.G_EXC_ERROR ;

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 ;
220: END IF;
221:
222: -- End of Validate Pay Groups.
223: -- Standard call to get message count and if count is 1,

Line 230: p_encoded => FND_API.G_FALSE

226: FND_MSG_PUB.Count_And_Get
227: (
228: p_count => x_msg_count,
229: p_data => x_msg_data,
230: p_encoded => FND_API.G_FALSE
231: );
232:
233: EXCEPTION
234: WHEN FND_API.G_EXC_ERROR THEN

Line 234: WHEN FND_API.G_EXC_ERROR THEN

230: p_encoded => FND_API.G_FALSE
231: );
232:
233: EXCEPTION
234: WHEN FND_API.G_EXC_ERROR THEN
235: x_return_status := FND_API.G_RET_STS_ERROR ;
236:
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 235: x_return_status := FND_API.G_RET_STS_ERROR ;

231: );
232:
233: EXCEPTION
234: WHEN FND_API.G_EXC_ERROR THEN
235: x_return_status := FND_API.G_RET_STS_ERROR ;
236:
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
239: x_loading_status := 'UNEXPECTED_ERR';

Line 237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

233: EXCEPTION
234: WHEN FND_API.G_EXC_ERROR THEN
235: x_return_status := FND_API.G_RET_STS_ERROR ;
236:
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
239: x_loading_status := 'UNEXPECTED_ERR';
240:
241: WHEN OTHERS THEN

Line 238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

234: WHEN FND_API.G_EXC_ERROR THEN
235: x_return_status := FND_API.G_RET_STS_ERROR ;
236:
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
239: x_loading_status := 'UNEXPECTED_ERR';
240:
241: WHEN OTHERS THEN
242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
239: x_loading_status := 'UNEXPECTED_ERR';
240:
241: WHEN OTHERS THEN
242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
243: x_loading_status := 'UNEXPECTED_ERR';
244: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
245: THEN
246: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

Line 311: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

307:
308:
309: -- Standard call to check for call compatibility.
310:
311: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
312: p_api_version ,
313: l_api_name ,
314: L_PKG_NAME )
315: THEN

Line 316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

312: p_api_version ,
313: l_api_name ,
314: L_PKG_NAME )
315: THEN
316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
317: END IF;
318:
319:
320: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 322: IF FND_API.to_Boolean( p_init_msg_list ) THEN

318:
319:
320: -- Initialize message list if p_init_msg_list is set to TRUE.
321:
322: IF FND_API.to_Boolean( p_init_msg_list ) THEN
323: FND_MSG_PUB.initialize;
324: END IF;
325:
326:

Line 329: x_return_status := FND_API.G_RET_STS_SUCCESS;

325:
326:
327: -- Initialize API return status to success
328:
329: x_return_status := FND_API.G_RET_STS_SUCCESS;
330: x_loading_status := 'CN_INSERTED';
331:
332:
333:

Line 348: RAISE FND_API.G_EXC_ERROR;

344: fnd_msg_pub.add;
345: END IF;
346:
347: x_loading_status := 'CN_INVALID_DATE_RANGE';
348: RAISE FND_API.G_EXC_ERROR;
349: END IF;
350:
351: Validate_PayGroup
352: (

Line 364: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

360: );
361:
362: -- Added by Kumar Sivasankran on 26/JUL/01
363: --
364: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
365: RAISE FND_API.G_EXC_ERROR;
366: END IF;
367:
368: SELECT COUNT(*)

Line 365: RAISE FND_API.G_EXC_ERROR;

361:
362: -- Added by Kumar Sivasankran on 26/JUL/01
363: --
364: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
365: RAISE FND_API.G_EXC_ERROR;
366: END IF;
367:
368: SELECT COUNT(*)
369: INTO l_count

Line 386: RAISE FND_API.G_EXC_ERROR;

382: fnd_msg_pub.add;
383: END IF;
384:
385: x_loading_status := 'CN_PAY_GROUP_EXISTS';
386: RAISE FND_API.G_EXC_ERROR;
387: END IF ;
388:
389:
390: --***********************************************************************

Line 423: RAISE FND_API.G_EXC_ERROR ;

419: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYGROUP_OVERLAPS');
420: FND_MSG_PUB.Add;
421: END IF;
422: x_loading_status := 'CN_PAYGROUP_OVERLAPS';
423: RAISE FND_API.G_EXC_ERROR ;
424: END;
425:
426: l_pay_group_id := p_PayGroup_rec.pay_group_id;
427: IF(l_pay_group_id IS NULL) THEN

Line 453: RAISE FND_API.G_EXC_ERROR;

449: END IF;
450:
451: x_loading_status := 'CN_INVALID_PRD_SET';
452: CLOSE get_period_set_id;
453: RAISE FND_API.G_EXC_ERROR;
454: END IF;
455:
456: CLOSE get_period_set_id;
457:

Line 472: RAISE FND_API.G_EXC_ERROR;

468: END IF;
469:
470: x_loading_status := 'CN_INVALID_PERIOD_TYPE';
471: CLOSE get_period_type_id;
472: RAISE FND_API.G_EXC_ERROR;
473: END IF;
474:
475: CLOSE get_period_type_id;
476: CN_Pay_Groups_Pkg.Begin_Record

Line 522: IF FND_API.To_Boolean( p_commit ) THEN

518:
519: p_PayGroup_Rec.pay_group_id :=l_pay_group_id;
520: -- Standard check of p_commit.
521:
522: IF FND_API.To_Boolean( p_commit ) THEN
523: COMMIT WORK;
524: END IF;
525:
526: -- Standard call to get message count and if count is 1, get message info.

Line 532: p_encoded => FND_API.G_FALSE

528: FND_MSG_PUB.Count_And_Get
529: (
530: p_count => x_msg_count ,
531: p_data => x_msg_data ,
532: p_encoded => FND_API.G_FALSE
533: );
534:
535: EXCEPTION
536: WHEN FND_API.G_EXC_ERROR THEN

Line 536: WHEN FND_API.G_EXC_ERROR THEN

532: p_encoded => FND_API.G_FALSE
533: );
534:
535: EXCEPTION
536: WHEN FND_API.G_EXC_ERROR THEN
537: ROLLBACK TO Create_PayGroup;
538: x_return_status := FND_API.G_RET_STS_ERROR ;
539: FND_MSG_PUB.Count_And_Get
540: (

Line 538: x_return_status := FND_API.G_RET_STS_ERROR ;

534:
535: EXCEPTION
536: WHEN FND_API.G_EXC_ERROR THEN
537: ROLLBACK TO Create_PayGroup;
538: x_return_status := FND_API.G_RET_STS_ERROR ;
539: FND_MSG_PUB.Count_And_Get
540: (
541: p_count => x_msg_count ,
542: p_data => x_msg_data ,

Line 543: p_encoded => FND_API.G_FALSE

539: FND_MSG_PUB.Count_And_Get
540: (
541: p_count => x_msg_count ,
542: p_data => x_msg_data ,
543: p_encoded => FND_API.G_FALSE
544: );
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546: ROLLBACK TO Create_PayGroup;
547: x_loading_status := 'UNEXPECTED_ERR';

Line 545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

541: p_count => x_msg_count ,
542: p_data => x_msg_data ,
543: p_encoded => FND_API.G_FALSE
544: );
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546: ROLLBACK TO Create_PayGroup;
547: x_loading_status := 'UNEXPECTED_ERR';
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
549: FND_MSG_PUB.Count_And_Get

Line 548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

544: );
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546: ROLLBACK TO Create_PayGroup;
547: x_loading_status := 'UNEXPECTED_ERR';
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
549: FND_MSG_PUB.Count_And_Get
550: (
551: p_count => x_msg_count ,
552: p_data => x_msg_data ,

Line 553: p_encoded => FND_API.G_FALSE

549: FND_MSG_PUB.Count_And_Get
550: (
551: p_count => x_msg_count ,
552: p_data => x_msg_data ,
553: p_encoded => FND_API.G_FALSE
554: );
555: WHEN OTHERS THEN
556: ROLLBACK TO Create_PayGroup;
557: x_loading_status := 'UNEXPECTED_ERR';

Line 558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

554: );
555: WHEN OTHERS THEN
556: ROLLBACK TO Create_PayGroup;
557: x_loading_status := 'UNEXPECTED_ERR';
558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
559: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
560: THEN
561: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );
562: END IF;

Line 567: p_encoded => FND_API.G_FALSE

563: FND_MSG_PUB.Count_And_Get
564: (
565: p_count => x_msg_count ,
566: p_data => x_msg_data ,
567: p_encoded => FND_API.G_FALSE
568: );
569: END Create_PayGroup;
570:
571: ---------------------------------------------------------------------------+

Line 729: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

725: SAVEPOINT Update_PayGroup;
726:
727: -- Standard call to check for call compatibility.
728:
729: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
730: p_api_version ,
731: l_api_name ,
732: L_PKG_NAME )
733: THEN

Line 734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

730: p_api_version ,
731: l_api_name ,
732: L_PKG_NAME )
733: THEN
734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
735: END IF;
736:
737: -- Initialize message list if p_init_msg_list is set to TRUE.
738:

Line 739: IF FND_API.to_Boolean( p_init_msg_list ) THEN

735: END IF;
736:
737: -- Initialize message list if p_init_msg_list is set to TRUE.
738:
739: IF FND_API.to_Boolean( p_init_msg_list ) THEN
740: FND_MSG_PUB.initialize;
741: END IF;
742:
743: -- Initialize API return status to success

Line 745: x_return_status := FND_API.G_RET_STS_SUCCESS;

741: END IF;
742:
743: -- Initialize API return status to success
744:
745: x_return_status := FND_API.G_RET_STS_SUCCESS;
746: x_loading_status := 'CN_UPDATED';
747:
748: -- API body
749:

Line 761: raise fnd_api.g_exc_error;

757:
758: IF l_old_ovn <> p_PayGroup_rec.object_version_number THEN
759: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
760: fnd_msg_pub.add;
761: raise fnd_api.g_exc_error;
762: END IF;
763:
764: Validate_PayGroup
765: (

Line 778: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

774:
775:
776: -- Added by Kumar Sivasankran on 26/JUL/01
777: --Validate if start date is less than end date
778: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
779: RAISE FND_API.G_EXC_ERROR;
780: END IF;
781:
782: IF p_paygroup_rec.start_date IS NOT NULL --start date has been updated

Line 779: RAISE FND_API.G_EXC_ERROR;

775:
776: -- Added by Kumar Sivasankran on 26/JUL/01
777: --Validate if start date is less than end date
778: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
779: RAISE FND_API.G_EXC_ERROR;
780: END IF;
781:
782: IF p_paygroup_rec.start_date IS NOT NULL --start date has been updated
783: THEN

Line 795: RAISE FND_API.G_EXC_ERROR;

791: fnd_msg_pub.add;
792: END IF;
793:
794: x_loading_status := 'CN_INVALID_DATE_RANGE';
795: RAISE FND_API.G_EXC_ERROR;
796: END IF;
797: ELSE
798: IF p_old_paygroup_rec.end_date IS NOT NULL
799: AND (p_paygroup_rec.start_date > p_old_paygroup_rec.end_date)

Line 809: RAISE FND_API.G_EXC_ERROR;

805: fnd_msg_pub.add;
806: END IF;
807:
808: x_loading_status := 'CN_INVALID_DATE_RANGE';
809: RAISE FND_API.G_EXC_ERROR;
810: END IF;
811: END IF;
812:
813: get_PayGroup_id

Line 824: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS )

820: x_loading_status => x_loading_status,
821: x_status => x_status
822: );
823:
824: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS )
825: THEN
826:
827: RAISE fnd_api.g_exc_error;
828:

Line 827: RAISE fnd_api.g_exc_error;

823:
824: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS )
825: THEN
826:
827: RAISE fnd_api.g_exc_error;
828:
829: ELSIF x_status <> 'PAY GROUP EXISTS'
830: THEN
831: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 839: RAISE FND_API.G_EXC_ERROR ;

835: FND_MSG_PUB.Add;
836: END IF;
837:
838: x_loading_status := 'CN_INVALID_PAY_GROUP';
839: RAISE FND_API.G_EXC_ERROR ;
840:
841: END IF;
842:
843: -- duplicate check at the time of update

Line 865: RAISE FND_API.G_EXC_ERROR;

861: fnd_msg_pub.add;
862: END IF;
863:
864: x_loading_status := 'CN_PAY_GROUP_EXISTS';
865: RAISE FND_API.G_EXC_ERROR;
866: END IF ;
867:
868: --***********************************************************************
869: -- Check Overlap

Line 901: RAISE FND_API.G_EXC_ERROR ;

897: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYGROUP_OVERLAPS');
898: FND_MSG_PUB.Add;
899: END IF;
900: x_loading_status := 'CN_PAYGROUP_OVERLAPS';
901: RAISE FND_API.G_EXC_ERROR ;
902: END;
903:
904:
905: SELECT COUNT(1)

Line 936: RAISE FND_API.G_EXC_ERROR;

932: END IF;
933:
934: x_status := 'CN_PAY_GROUP_CHANGE_NA';
935: x_loading_status := 'CN_PAY_GROUP_CHANGE_NA';
936: RAISE FND_API.G_EXC_ERROR;
937:
938: END IF;
939:
940: END IF;

Line 979: RAISE FND_API.G_EXC_ERROR;

975: END IF;
976:
977: x_status := 'CN_PAY_GROUP_CHANGE_ROLE_NA';
978: x_loading_status := 'CN_PAY_GROUP_CHANGE_ROLE_NA';
979: RAISE FND_API.G_EXC_ERROR;
980:
981: END IF;
982: END IF;
983:

Line 984: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS)

980:
981: END IF;
982: END IF;
983:
984: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS)
985: THEN
986: RAISE FND_API.G_EXC_ERROR ;
987: ELSIF ( x_return_status = FND_API.G_RET_STS_SUCCESS )
988: THEN

Line 986: RAISE FND_API.G_EXC_ERROR ;

982: END IF;
983:
984: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS)
985: THEN
986: RAISE FND_API.G_EXC_ERROR ;
987: ELSIF ( x_return_status = FND_API.G_RET_STS_SUCCESS )
988: THEN
989:
990: IF p_PayGroup_rec.period_set_name IS NOT NULL

Line 987: ELSIF ( x_return_status = FND_API.G_RET_STS_SUCCESS )

983:
984: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS)
985: THEN
986: RAISE FND_API.G_EXC_ERROR ;
987: ELSIF ( x_return_status = FND_API.G_RET_STS_SUCCESS )
988: THEN
989:
990: IF p_PayGroup_rec.period_set_name IS NOT NULL
991: THEN

Line 1006: RAISE FND_API.G_EXC_ERROR;

1002: END IF;
1003:
1004: x_loading_status := 'CN_INVALID_PRD_SET';
1005: CLOSE get_period_set_id;
1006: RAISE FND_API.G_EXC_ERROR;
1007: END IF;
1008:
1009:
1010: CLOSE get_period_set_id;

Line 1031: RAISE FND_API.G_EXC_ERROR;

1027: END IF;
1028:
1029: x_loading_status := 'CN_INVALID_PERIOD_TYPE';
1030: CLOSE get_period_type_id;
1031: RAISE FND_API.G_EXC_ERROR;
1032: END IF;
1033:
1034: CLOSE get_period_type_id;
1035: ELSE

Line 1065: RAISE FND_API.G_EXC_ERROR ;

1061: FND_MESSAGE.SET_NAME ('CN' , 'CN_PG_CANNOT_SHORTEN_ED');
1062: FND_MSG_PUB.Add;
1063: END IF;
1064: x_loading_status := 'CN_PG_CANNOT_SHORTEN_ED';
1065: RAISE FND_API.G_EXC_ERROR ;
1066: end if;
1067: end;
1068: end if;
1069:

Line 1106: RAISE FND_API.G_EXC_ERROR ;

1102: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYGRP_PRD_TYPE_NOT_UPD');
1103: FND_MSG_PUB.Add;
1104: END IF;
1105: x_loading_status := 'CN_PAYGRP_PRD_TYPE_NOT_UPD';
1106: RAISE FND_API.G_EXC_ERROR ;
1107: END IF;
1108:
1109: IF p_old_PayGroup_rec.period_set_name <> p_PayGroup_rec.period_set_name THEN
1110: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1115: RAISE FND_API.G_EXC_ERROR ;

1111: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYGRP_PRD_SNAME_NOT_UPD');
1112: FND_MSG_PUB.Add;
1113: END IF;
1114: x_loading_status := 'CN_PAYGRP_PRD_SNAME_NOT_UPD';
1115: RAISE FND_API.G_EXC_ERROR ;
1116: END IF;
1117:
1118: END;
1119:

Line 1147: RAISE FND_API.G_EXC_ERROR ;

1143: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYGRP_PRD_TYPE_NOT_UPDP');
1144: FND_MSG_PUB.Add;
1145: END IF;
1146: x_loading_status := 'CN_PAYGRP_PRD_TYPE_NOT_UPDP';
1147: RAISE FND_API.G_EXC_ERROR ;
1148: END IF;
1149:
1150:
1151: IF p_old_PayGroup_rec.period_set_name <> p_PayGroup_rec.period_set_name THEN

Line 1157: RAISE FND_API.G_EXC_ERROR ;

1153: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYGRP_PRD_SNAME_NOT_UPD');
1154: FND_MSG_PUB.Add;
1155: END IF;
1156: x_loading_status := 'CN_PAYGRP_PRD_SNAME_NOT_UPDP';
1157: RAISE FND_API.G_EXC_ERROR ;
1158: END IF;
1159:
1160:
1161: END;

Line 1250: p_init_msg_list => fnd_api.g_false,

1246:
1247:
1248: cn_srp_periods_pvt.create_srp_periods
1249: ( p_api_version => p_api_version,
1250: p_init_msg_list => fnd_api.g_false,
1251: p_commit => fnd_api.g_false,
1252: p_validation_level => p_validation_level,
1253: x_return_status => x_return_status,
1254: x_msg_count => x_msg_count,

Line 1251: p_commit => fnd_api.g_false,

1247:
1248: cn_srp_periods_pvt.create_srp_periods
1249: ( p_api_version => p_api_version,
1250: p_init_msg_list => fnd_api.g_false,
1251: p_commit => fnd_api.g_false,
1252: p_validation_level => p_validation_level,
1253: x_return_status => x_return_status,
1254: x_msg_count => x_msg_count,
1255: x_msg_data => x_msg_data,

Line 1262: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

1258: p_comp_plan_id => plans.comp_plan_id,
1259: p_start_date => plans.start_date,
1260: p_end_date => plans.end_date,
1261: x_loading_status => x_loading_status);
1262: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1263: THEN
1264: RAISE FND_API.G_EXC_ERROR;
1265: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1266: THEN

Line 1264: RAISE FND_API.G_EXC_ERROR;

1260: p_end_date => plans.end_date,
1261: x_loading_status => x_loading_status);
1262: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1263: THEN
1264: RAISE FND_API.G_EXC_ERROR;
1265: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1266: THEN
1267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1268: END IF;

Line 1265: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1261: x_loading_status => x_loading_status);
1262: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1263: THEN
1264: RAISE FND_API.G_EXC_ERROR;
1265: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1266: THEN
1267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1268: END IF;
1269: END LOOP;

Line 1267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1263: THEN
1264: RAISE FND_API.G_EXC_ERROR;
1265: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1266: THEN
1267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1268: END IF;
1269: END LOOP;
1270: END LOOP;
1271:

Line 1280: IF FND_API.To_Boolean( p_commit ) THEN

1276:
1277: -- End of API body.
1278: -- Standard check of p_commit.
1279:
1280: IF FND_API.To_Boolean( p_commit ) THEN
1281: COMMIT WORK;
1282: END IF;
1283:
1284:

Line 1291: p_encoded => FND_API.G_FALSE

1287: FND_MSG_PUB.Count_And_Get
1288: (
1289: p_count => x_msg_count ,
1290: p_data => x_msg_data ,
1291: p_encoded => FND_API.G_FALSE
1292: );
1293: EXCEPTION
1294: WHEN FND_API.G_EXC_ERROR THEN
1295: ROLLBACK TO Update_PayGroup;

Line 1294: WHEN FND_API.G_EXC_ERROR THEN

1290: p_data => x_msg_data ,
1291: p_encoded => FND_API.G_FALSE
1292: );
1293: EXCEPTION
1294: WHEN FND_API.G_EXC_ERROR THEN
1295: ROLLBACK TO Update_PayGroup;
1296: x_return_status := FND_API.G_RET_STS_ERROR ;
1297: FND_MSG_PUB.Count_And_Get
1298: (

Line 1296: x_return_status := FND_API.G_RET_STS_ERROR ;

1292: );
1293: EXCEPTION
1294: WHEN FND_API.G_EXC_ERROR THEN
1295: ROLLBACK TO Update_PayGroup;
1296: x_return_status := FND_API.G_RET_STS_ERROR ;
1297: FND_MSG_PUB.Count_And_Get
1298: (
1299: p_count => x_msg_count ,
1300: p_data => x_msg_data ,

Line 1301: p_encoded => FND_API.G_FALSE

1297: FND_MSG_PUB.Count_And_Get
1298: (
1299: p_count => x_msg_count ,
1300: p_data => x_msg_data ,
1301: p_encoded => FND_API.G_FALSE
1302: );
1303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1304: ROLLBACK TO Update_PayGroup;
1305: x_loading_status := 'UNEXPECTED_ERR';

Line 1303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1299: p_count => x_msg_count ,
1300: p_data => x_msg_data ,
1301: p_encoded => FND_API.G_FALSE
1302: );
1303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1304: ROLLBACK TO Update_PayGroup;
1305: x_loading_status := 'UNEXPECTED_ERR';
1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1307: FND_MSG_PUB.Count_And_Get

Line 1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1302: );
1303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1304: ROLLBACK TO Update_PayGroup;
1305: x_loading_status := 'UNEXPECTED_ERR';
1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1307: FND_MSG_PUB.Count_And_Get
1308: (
1309: p_count => x_msg_count ,
1310: p_data => x_msg_data ,

Line 1311: p_encoded => FND_API.G_FALSE

1307: FND_MSG_PUB.Count_And_Get
1308: (
1309: p_count => x_msg_count ,
1310: p_data => x_msg_data ,
1311: p_encoded => FND_API.G_FALSE
1312: );
1313: WHEN OTHERS THEN
1314: ROLLBACK TO Update_PayGroup;
1315: x_loading_status := 'UNEXPECTED_ERR';

Line 1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1312: );
1313: WHEN OTHERS THEN
1314: ROLLBACK TO Update_PayGroup;
1315: x_loading_status := 'UNEXPECTED_ERR';
1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1317: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1318: THEN
1319: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );
1320: END IF;

Line 1325: p_encoded => FND_API.G_FALSE

1321: FND_MSG_PUB.Count_And_Get
1322: (
1323: p_count => x_msg_count ,
1324: p_data => x_msg_data ,
1325: p_encoded => FND_API.G_FALSE
1326: );
1327: END Update_PayGroup;
1328:
1329: ---------------------------------------------------------------------------+

Line 1370: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

1366: SAVEPOINT Delete_PayGroup ;
1367: --
1368: -- Standard call to check for call compatibility.
1369: --
1370: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1371: p_api_version ,
1372: l_api_name ,
1373: L_PKG_NAME )
1374: THEN

Line 1375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1371: p_api_version ,
1372: l_api_name ,
1373: L_PKG_NAME )
1374: THEN
1375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1376: END IF;
1377:
1378: -- Initialize message list if p_init_msg_list is set to TRUE.
1379:

Line 1380: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1376: END IF;
1377:
1378: -- Initialize message list if p_init_msg_list is set to TRUE.
1379:
1380: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1381: FND_MSG_PUB.initialize;
1382: END IF;
1383:
1384: -- Initialize API return status to success

Line 1386: x_return_status := FND_API.G_RET_STS_SUCCESS;

1382: END IF;
1383:
1384: -- Initialize API return status to success
1385:
1386: x_return_status := FND_API.G_RET_STS_SUCCESS;
1387: x_loading_status := 'CN_DELETED';
1388:
1389: -- API Body
1390: get_PayGroup_id(

Line 1402: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS )

1398: x_status => x_status
1399: );
1400:
1401:
1402: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS )
1403: THEN
1404:
1405: RAISE fnd_api.g_exc_error;
1406:

Line 1405: RAISE fnd_api.g_exc_error;

1401:
1402: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS )
1403: THEN
1404:
1405: RAISE fnd_api.g_exc_error;
1406:
1407: ELSIF x_status <> 'PAY GROUP EXISTS'
1408:
1409: THEN

Line 1421: RAISE FND_API.G_EXC_ERROR ;

1417: FND_MSG_PUB.Add;
1418: END IF;
1419:
1420: x_loading_status := 'CN_INVALID_PAY_GROUP';
1421: RAISE FND_API.G_EXC_ERROR ;
1422:
1423: END IF;
1424: SELECT COUNT(1)
1425: INTO l_count_role

Line 1439: RAISE FND_API.G_EXC_ERROR ;

1435: FND_MSG_PUB.Add;
1436: END IF;
1437:
1438: x_loading_status := 'CN_PAY_GROUP_ASSIGNED_TO_ROLE';
1439: RAISE FND_API.G_EXC_ERROR ;
1440: END IF;
1441:
1442:
1443: SELECT COUNT(1)

Line 1458: RAISE FND_API.G_EXC_ERROR ;

1454: FND_MSG_PUB.Add;
1455: END IF;
1456:
1457: x_loading_status := 'CN_PAY_GROUP_CHANGE_NA';
1458: RAISE FND_API.G_EXC_ERROR ;
1459:
1460: ELSE
1461: cn_pay_groups_pkg.begin_record
1462: (

Line 1503: IF FND_API.To_Boolean( p_commit ) THEN

1499: END IF;
1500: -- End of API body.
1501: -- Standard check of p_commit.
1502:
1503: IF FND_API.To_Boolean( p_commit ) THEN
1504: COMMIT WORK;
1505: END IF;
1506:
1507: -- Standard call to get message count and if count is 1, get message info.

Line 1513: p_encoded => FND_API.G_FALSE

1509: FND_MSG_PUB.Count_And_Get
1510: (
1511: p_count => x_msg_count ,
1512: p_data => x_msg_data ,
1513: p_encoded => FND_API.G_FALSE
1514: );
1515: EXCEPTION
1516: WHEN FND_API.G_EXC_ERROR THEN
1517: ROLLBACK TO Delete_PayGroup;

Line 1516: WHEN FND_API.G_EXC_ERROR THEN

1512: p_data => x_msg_data ,
1513: p_encoded => FND_API.G_FALSE
1514: );
1515: EXCEPTION
1516: WHEN FND_API.G_EXC_ERROR THEN
1517: ROLLBACK TO Delete_PayGroup;
1518: x_return_status := FND_API.G_RET_STS_ERROR ;
1519: FND_MSG_PUB.Count_And_Get
1520: (

Line 1518: x_return_status := FND_API.G_RET_STS_ERROR ;

1514: );
1515: EXCEPTION
1516: WHEN FND_API.G_EXC_ERROR THEN
1517: ROLLBACK TO Delete_PayGroup;
1518: x_return_status := FND_API.G_RET_STS_ERROR ;
1519: FND_MSG_PUB.Count_And_Get
1520: (
1521: p_count => x_msg_count ,
1522: p_data => x_msg_data ,

Line 1523: p_encoded => FND_API.G_FALSE

1519: FND_MSG_PUB.Count_And_Get
1520: (
1521: p_count => x_msg_count ,
1522: p_data => x_msg_data ,
1523: p_encoded => FND_API.G_FALSE
1524: );
1525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1526: ROLLBACK TO Delete_PayGroup;
1527: x_loading_status := 'UNEXPECTED_ERR';

Line 1525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1521: p_count => x_msg_count ,
1522: p_data => x_msg_data ,
1523: p_encoded => FND_API.G_FALSE
1524: );
1525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1526: ROLLBACK TO Delete_PayGroup;
1527: x_loading_status := 'UNEXPECTED_ERR';
1528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1529: FND_MSG_PUB.Count_And_Get

Line 1528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1524: );
1525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1526: ROLLBACK TO Delete_PayGroup;
1527: x_loading_status := 'UNEXPECTED_ERR';
1528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1529: FND_MSG_PUB.Count_And_Get
1530: (
1531: p_count => x_msg_count ,
1532: p_data => x_msg_data ,

Line 1533: p_encoded => FND_API.G_FALSE

1529: FND_MSG_PUB.Count_And_Get
1530: (
1531: p_count => x_msg_count ,
1532: p_data => x_msg_data ,
1533: p_encoded => FND_API.G_FALSE
1534: );
1535: WHEN OTHERS THEN
1536: ROLLBACK TO Delete_PayGroup;
1537: x_loading_status := 'UNEXPECTED_ERR';

Line 1538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1534: );
1535: WHEN OTHERS THEN
1536: ROLLBACK TO Delete_PayGroup;
1537: x_loading_status := 'UNEXPECTED_ERR';
1538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1539: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1540: THEN
1541: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );
1542: END IF;

Line 1547: p_encoded => FND_API.G_FALSE

1543: FND_MSG_PUB.Count_And_Get
1544: (
1545: p_count => x_msg_count ,
1546: p_data => x_msg_data ,
1547: p_encoded => FND_API.G_FALSE
1548: );
1549:
1550: END Delete_PayGroup;
1551: