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_SEAS_SCHEDULES_PVT dependencies on FND_MSG_PUB

Line 76: FND_MSG_PUB.initialize;

72: END IF;
73:
74: -- Initialize message list if p_init_msg_list is set to TRUE.
75: IF FND_API.to_Boolean( p_init_msg_list ) THEN
76: FND_MSG_PUB.initialize;
77: END IF;
78:
79: -- Initialize API return status to success
80: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 93: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

89: -- Check the SEASONALITY SCHEDULE NAME
90: IF ( p_seas_schedules_rec_type.name is NULL ) OR
91: ( p_seas_schedules_rec_type.name = fnd_api.g_miss_char )
92: THEN
93: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
94: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQ_PAR_MISSING');
95: FND_MSG_PUB.Add;
96: END IF;
97: RAISE FND_API.G_EXC_ERROR ;

Line 95: FND_MSG_PUB.Add;

91: ( p_seas_schedules_rec_type.name = fnd_api.g_miss_char )
92: THEN
93: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
94: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQ_PAR_MISSING');
95: FND_MSG_PUB.Add;
96: END IF;
97: RAISE FND_API.G_EXC_ERROR ;
98: END IF;
99:

Line 104: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

100: -- Check the SEASONALITY SCHEDULE DESCRIPTION
101: IF ( p_seas_schedules_rec_type.DESCRIPTION is NULL ) OR
102: ( p_seas_schedules_rec_type.DESCRIPTION = fnd_api.g_miss_char )
103: THEN
104: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
105: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQ_PAR_MISSING');
106: FND_MSG_PUB.Add;
107: END IF;
108: RAISE FND_API.G_EXC_ERROR ;

Line 106: FND_MSG_PUB.Add;

102: ( p_seas_schedules_rec_type.DESCRIPTION = fnd_api.g_miss_char )
103: THEN
104: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
105: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQ_PAR_MISSING');
106: FND_MSG_PUB.Add;
107: END IF;
108: RAISE FND_API.G_EXC_ERROR ;
109: END IF;
110:

Line 115: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

111: -- Check already if this seas_schedule_name exists
112: SELECT COUNT(*) INTO l_count FROM CN_SEAS_SCHEDULES WHERE UPPER(NAME) LIKE UPPER(p_seas_schedules_rec_type.name);
113: -- Insert
114: IF l_count > 0 THEN
115: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
116: FND_MESSAGE.SET_NAME ('CN' , 'CN_SEAS_NAME_EXISTS');
117: FND_MSG_PUB.Add;
118: END IF;
119: RAISE FND_API.G_EXC_ERROR ;

Line 117: FND_MSG_PUB.Add;

113: -- Insert
114: IF l_count > 0 THEN
115: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
116: FND_MESSAGE.SET_NAME ('CN' , 'CN_SEAS_NAME_EXISTS');
117: FND_MSG_PUB.Add;
118: END IF;
119: RAISE FND_API.G_EXC_ERROR ;
120: END IF;
121:

Line 156: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

152: FROM cn_period_statuses cp,cn_cal_per_int_types ccpit
153: WHERE period_year = p_seas_schedules_rec_type.period_year and cp.period_id = ccpit.cal_period_id and interval_type_id = -1002;
154:
155: IF (l_cal_int_types = 0) THEN
156: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
157: FND_MESSAGE.SET_NAME ('CN' , 'CN_SEAS_INTTYPE_NOTEXIST');
158: FND_MSG_PUB.Add;
159: END IF;
160: RAISE FND_API.G_EXC_ERROR ;

Line 158: FND_MSG_PUB.Add;

154:
155: IF (l_cal_int_types = 0) THEN
156: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
157: FND_MESSAGE.SET_NAME ('CN' , 'CN_SEAS_INTTYPE_NOTEXIST');
158: FND_MSG_PUB.Add;
159: END IF;
160: RAISE FND_API.G_EXC_ERROR ;
161: END IF;
162:

Line 187: FND_MSG_PUB.Count_And_Get

183: IF FND_API.To_Boolean( p_commit ) THEN
184: COMMIT WORK;
185: END IF;
186: -- Standard call to get message count and if count is 1, get message info.
187: FND_MSG_PUB.Count_And_Get
188: (
189: p_count => x_msg_count ,
190: p_data => x_msg_data ,
191: p_encoded => FND_API.G_FALSE

Line 198: FND_MSG_PUB.Count_And_Get

194: EXCEPTION
195: WHEN FND_API.G_EXC_ERROR THEN
196: ROLLBACK TO Create_Seas_Schedule ;
197: x_return_status := FND_API.G_RET_STS_ERROR ;
198: FND_MSG_PUB.Count_And_Get
199: (
200: p_count => x_msg_count ,
201: p_data => x_msg_data ,
202: p_encoded => FND_API.G_FALSE

Line 208: FND_MSG_PUB.Count_And_Get

204:
205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
206: ROLLBACK TO Create_Seas_Schedule ;
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
208: FND_MSG_PUB.Count_And_Get
209: (
210: p_count => x_msg_count ,
211: p_data => x_msg_data ,
212: p_encoded => FND_API.G_FALSE

Line 220: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
217: l_error_code := SQLCODE;
218: IF l_error_code = -54 THEN
219: x_return_status := FND_API.G_RET_STS_ERROR ;
220: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
221: THEN
222: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
223: FND_MSG_PUB.Add;
224: END IF;

Line 223: FND_MSG_PUB.Add;

219: x_return_status := FND_API.G_RET_STS_ERROR ;
220: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
221: THEN
222: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
223: FND_MSG_PUB.Add;
224: END IF;
225: ELSE
226: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
227: THEN

Line 226: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

222: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
223: FND_MSG_PUB.Add;
224: END IF;
225: ELSE
226: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
227: THEN
228: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
229: END IF;
230: END IF;

Line 228: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

224: END IF;
225: ELSE
226: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
227: THEN
228: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
229: END IF;
230: END IF;
231: FND_MSG_PUB.Count_And_Get
232: (

Line 231: FND_MSG_PUB.Count_And_Get

227: THEN
228: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
229: END IF;
230: END IF;
231: FND_MSG_PUB.Count_And_Get
232: (
233: p_count => x_msg_count ,
234: p_data => x_msg_data ,
235: p_encoded => FND_API.G_FALSE

Line 299: FND_MSG_PUB.initialize;

295: END IF;
296:
297: -- Initialize message list if p_init_msg_list is set to TRUE.
298: IF FND_API.to_Boolean( p_init_msg_list ) THEN
299: FND_MSG_PUB.initialize;
300: END IF;
301: -- Initialize API return status to success
302: x_return_status := FND_API.G_RET_STS_SUCCESS;
303: -- API body

Line 313: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

309: and t2.seas_schedule_id = p_seas_schedules_rec_type.seas_schedule_id;
310:
311:
312: IF (l_srp_count > 0) THEN
313: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
314: FND_MESSAGE.SET_NAME ('CN' , 'CN_SEASONALITY_IN_USE');
315: FND_MSG_PUB.Add;
316: END IF;
317: RAISE FND_API.G_EXC_ERROR ;

Line 315: FND_MSG_PUB.Add;

311:
312: IF (l_srp_count > 0) THEN
313: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
314: FND_MESSAGE.SET_NAME ('CN' , 'CN_SEASONALITY_IN_USE');
315: FND_MSG_PUB.Add;
316: END IF;
317: RAISE FND_API.G_EXC_ERROR ;
318: END IF;
319:

Line 327: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

323: -- Check the SEASONALITY SCHEDULE NAME
324: IF ( p_seas_schedules_rec_type.name is NULL ) OR
325: ( p_seas_schedules_rec_type.name = fnd_api.g_miss_char )
326: THEN
327: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
328: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQ_PAR_MISSING');
329: FND_MSG_PUB.Add;
330: END IF;
331: RAISE FND_API.G_EXC_ERROR ;

Line 329: FND_MSG_PUB.Add;

325: ( p_seas_schedules_rec_type.name = fnd_api.g_miss_char )
326: THEN
327: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
328: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQ_PAR_MISSING');
329: FND_MSG_PUB.Add;
330: END IF;
331: RAISE FND_API.G_EXC_ERROR ;
332: END IF;
333:

Line 338: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

334: -- Check the SEASONALITY SCHEDULE DESCRIPTION
335: IF ( p_seas_schedules_rec_type.DESCRIPTION is NULL ) OR
336: ( p_seas_schedules_rec_type.DESCRIPTION = fnd_api.g_miss_char )
337: THEN
338: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
339: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQ_PAR_MISSING');
340: FND_MSG_PUB.Add;
341: END IF;
342: RAISE FND_API.G_EXC_ERROR ;

Line 340: FND_MSG_PUB.Add;

336: ( p_seas_schedules_rec_type.DESCRIPTION = fnd_api.g_miss_char )
337: THEN
338: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
339: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQ_PAR_MISSING');
340: FND_MSG_PUB.Add;
341: END IF;
342: RAISE FND_API.G_EXC_ERROR ;
343: END IF;
344:

Line 349: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

345: -- Check already if this seas_schedule_name exists
346: SELECT COUNT(*) INTO l_count FROM CN_SEAS_SCHEDULES WHERE UPPER(NAME) LIKE UPPER(p_seas_schedules_rec_type.name) AND SEAS_SCHEDULE_ID <> p_seas_schedules_rec_type.seas_schedule_id;
347: -- Insert
348: IF l_count > 0 THEN
349: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
350: FND_MESSAGE.SET_NAME ('CN' , 'CN_SEAS_NAME_EXISTS');
351: FND_MSG_PUB.Add;
352: END IF;
353: RAISE FND_API.G_EXC_ERROR ;

Line 351: FND_MSG_PUB.Add;

347: -- Insert
348: IF l_count > 0 THEN
349: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
350: FND_MESSAGE.SET_NAME ('CN' , 'CN_SEAS_NAME_EXISTS');
351: FND_MSG_PUB.Add;
352: END IF;
353: RAISE FND_API.G_EXC_ERROR ;
354: END IF;
355: --DBMS_OUTPUT.PUT_LINE('Update Validations done.');

Line 397: FND_MSG_PUB.Count_And_Get

393: IF FND_API.To_Boolean( p_commit ) THEN
394: COMMIT WORK;
395: END IF;
396: -- Standard call to get message count and if count is 1, get message info.
397: FND_MSG_PUB.Count_And_Get
398: (
399: p_count => x_msg_count ,
400: p_data => x_msg_data ,
401: p_encoded => FND_API.G_FALSE

Line 408: FND_MSG_PUB.Count_And_Get

404: EXCEPTION
405: WHEN FND_API.G_EXC_ERROR THEN
406: ROLLBACK TO Update_Seas_Schedule ;
407: x_return_status := FND_API.G_RET_STS_ERROR ;
408: FND_MSG_PUB.Count_And_Get
409: (
410: p_count => x_msg_count ,
411: p_data => x_msg_data ,
412: p_encoded => FND_API.G_FALSE

Line 418: FND_MSG_PUB.Count_And_Get

414:
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: ROLLBACK TO Update_Seas_Schedule ;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
418: FND_MSG_PUB.Count_And_Get
419: (
420: p_count => x_msg_count ,
421: p_data => x_msg_data ,
422: p_encoded => FND_API.G_FALSE

Line 430: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
427: l_error_code := SQLCODE;
428: IF l_error_code = -54 THEN
429: x_return_status := FND_API.G_RET_STS_ERROR ;
430: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
431: THEN
432: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
433: FND_MSG_PUB.Add;
434: END IF;

Line 433: FND_MSG_PUB.Add;

429: x_return_status := FND_API.G_RET_STS_ERROR ;
430: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
431: THEN
432: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
433: FND_MSG_PUB.Add;
434: END IF;
435: ELSE
436: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
437: THEN

Line 436: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

432: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
433: FND_MSG_PUB.Add;
434: END IF;
435: ELSE
436: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
437: THEN
438: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
439: END IF;
440: END IF;

Line 438: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

434: END IF;
435: ELSE
436: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
437: THEN
438: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
439: END IF;
440: END IF;
441: FND_MSG_PUB.Count_And_Get
442: (

Line 441: FND_MSG_PUB.Count_And_Get

437: THEN
438: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
439: END IF;
440: END IF;
441: FND_MSG_PUB.Count_And_Get
442: (
443: p_count => x_msg_count ,
444: p_data => x_msg_data ,
445: p_encoded => FND_API.G_FALSE

Line 508: FND_MSG_PUB.initialize;

504: END IF;
505:
506: -- Initialize message list if p_init_msg_list is set to TRUE.
507: IF FND_API.to_Boolean( p_init_msg_list ) THEN
508: FND_MSG_PUB.initialize;
509: END IF;
510: -- Initialize API return status to success
511: x_return_status := FND_API.G_RET_STS_SUCCESS;
512:

Line 523: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

519: -- from CN_SEAS_SCHEDULES and CN_SEASONALITIES.
520: SELECT COUNT(role_id) INTO l_role_quota_cate_count FROM CN_ROLE_QUOTA_CATES WHERE seas_schedule_id = P_SEAS_SCHEDULE_ID;
521:
522: IF (l_role_quota_cate_count > 0) THEN
523: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
524: FND_MESSAGE.SET_NAME ('CN' , 'CN_SEAS_DEL_FAILED');
525: FND_MSG_PUB.Add;
526: END IF;
527: RAISE FND_API.G_EXC_ERROR ;

Line 525: FND_MSG_PUB.Add;

521:
522: IF (l_role_quota_cate_count > 0) THEN
523: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
524: FND_MESSAGE.SET_NAME ('CN' , 'CN_SEAS_DEL_FAILED');
525: FND_MSG_PUB.Add;
526: END IF;
527: RAISE FND_API.G_EXC_ERROR ;
528: END IF;
529:

Line 545: FND_MSG_PUB.Count_And_Get

541: IF FND_API.To_Boolean( p_commit ) THEN
542: COMMIT WORK;
543: END IF;
544: -- Standard call to get message count and if count is 1, get message info.
545: FND_MSG_PUB.Count_And_Get
546: (
547: p_count => x_msg_count ,
548: p_data => x_msg_data ,
549: p_encoded => FND_API.G_FALSE

Line 556: FND_MSG_PUB.Count_And_Get

552: EXCEPTION
553: WHEN FND_API.G_EXC_ERROR THEN
554: ROLLBACK TO Delete_Seas_Schedule ;
555: x_return_status := FND_API.G_RET_STS_ERROR ;
556: FND_MSG_PUB.Count_And_Get
557: (
558: p_count => x_msg_count ,
559: p_data => x_msg_data ,
560: p_encoded => FND_API.G_FALSE

Line 566: FND_MSG_PUB.Count_And_Get

562:
563: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
564: ROLLBACK TO Delete_Seas_Schedule ;
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
566: FND_MSG_PUB.Count_And_Get
567: (
568: p_count => x_msg_count ,
569: p_data => x_msg_data ,
570: p_encoded => FND_API.G_FALSE

Line 578: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
575: l_error_code := SQLCODE;
576: IF l_error_code = -54 THEN
577: x_return_status := FND_API.G_RET_STS_ERROR ;
578: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
579: THEN
580: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
581: FND_MSG_PUB.Add;
582: END IF;

Line 581: FND_MSG_PUB.Add;

577: x_return_status := FND_API.G_RET_STS_ERROR ;
578: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
579: THEN
580: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
581: FND_MSG_PUB.Add;
582: END IF;
583: ELSE
584: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
585: THEN

Line 584: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

580: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
581: FND_MSG_PUB.Add;
582: END IF;
583: ELSE
584: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
585: THEN
586: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
587: END IF;
588: END IF;

Line 586: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

582: END IF;
583: ELSE
584: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
585: THEN
586: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
587: END IF;
588: END IF;
589: FND_MSG_PUB.Count_And_Get
590: (

Line 589: FND_MSG_PUB.Count_And_Get

585: THEN
586: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
587: END IF;
588: END IF;
589: FND_MSG_PUB.Count_And_Get
590: (
591: p_count => x_msg_count ,
592: p_data => x_msg_data ,
593: p_encoded => FND_API.G_FALSE

Line 654: FND_MSG_PUB.initialize;

650: END IF;
651:
652: -- Initialize message list if p_init_msg_list is set to TRUE.
653: IF FND_API.to_Boolean( p_init_msg_list ) THEN
654: FND_MSG_PUB.initialize;
655: END IF;
656: -- Initialize API return status to success
657: x_return_status := FND_API.G_RET_STS_SUCCESS;
658:

Line 675: FND_MSG_PUB.Count_And_Get

671: IF FND_API.To_Boolean( p_commit ) THEN
672: COMMIT WORK;
673: END IF;
674: -- Standard call to get message count and if count is 1, get message info.
675: FND_MSG_PUB.Count_And_Get
676: (
677: p_count => x_msg_count ,
678: p_data => x_msg_data ,
679: p_encoded => FND_API.G_FALSE

Line 686: FND_MSG_PUB.Count_And_Get

682: EXCEPTION
683: WHEN FND_API.G_EXC_ERROR THEN
684: ROLLBACK TO Sum_Seas_Schedule ;
685: x_return_status := FND_API.G_RET_STS_ERROR ;
686: FND_MSG_PUB.Count_And_Get
687: (
688: p_count => x_msg_count ,
689: p_data => x_msg_data ,
690: p_encoded => FND_API.G_FALSE

Line 696: FND_MSG_PUB.Count_And_Get

692:
693: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
694: ROLLBACK TO Sum_Seas_Schedule ;
695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
696: FND_MSG_PUB.Count_And_Get
697: (
698: p_count => x_msg_count ,
699: p_data => x_msg_data ,
700: p_encoded => FND_API.G_FALSE

Line 708: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
705: l_error_code := SQLCODE;
706: IF l_error_code = -54 THEN
707: x_return_status := FND_API.G_RET_STS_ERROR ;
708: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
709: THEN
710: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
711: FND_MSG_PUB.Add;
712: END IF;

Line 711: FND_MSG_PUB.Add;

707: x_return_status := FND_API.G_RET_STS_ERROR ;
708: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
709: THEN
710: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
711: FND_MSG_PUB.Add;
712: END IF;
713: ELSE
714: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
715: THEN

Line 714: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

710: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
711: FND_MSG_PUB.Add;
712: END IF;
713: ELSE
714: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
715: THEN
716: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
717: END IF;
718: END IF;

Line 716: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

712: END IF;
713: ELSE
714: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
715: THEN
716: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
717: END IF;
718: END IF;
719: FND_MSG_PUB.Count_And_Get
720: (

Line 719: FND_MSG_PUB.Count_And_Get

715: THEN
716: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
717: END IF;
718: END IF;
719: FND_MSG_PUB.Count_And_Get
720: (
721: p_count => x_msg_count ,
722: p_data => x_msg_data ,
723: p_encoded => FND_API.G_FALSE