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

Line 45: FND_MSG_PUB.initialize;

41: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
42: END IF;
43: -- Initialize message list if p_init_msg_list is set to TRUE.
44: IF FND_API.to_Boolean( p_init_msg_list ) THEN
45: FND_MSG_PUB.initialize;
46: END IF;
47: -- Initialize API return status to success
48: x_return_status := FND_API.G_RET_STS_SUCCESS;
49:

Line 57: FND_MSG_PUB.ADD;

53: -- validate name is unique
54: select count(1) into l_count from cn_dimensions where name = p_name and org_id = p_org_id; --R12 MOAC change
55: if l_count > 0 then
56: FND_MESSAGE.SET_NAME('CN', 'CN_NAME_NOT_UNIQUE');
57: FND_MSG_PUB.ADD;
58: RAISE FND_API.G_EXC_ERROR;
59: end if;
60:
61: select count(1) into l_count_tl

Line 70: FND_MSG_PUB.ADD;

66: and L.INSTALLED_FLAG in ('I', 'B');
67:
68: if l_count_tl > 0 then
69: FND_MESSAGE.SET_NAME('CN', 'CN_NAME_NOT_UNIQUE');
70: FND_MSG_PUB.ADD;
71: RAISE FND_API.G_EXC_ERROR;
72: end if;
73:
74: -- get dimension ID

Line 108: FND_MSG_PUB.Count_And_Get

104: IF FND_API.To_Boolean( p_commit ) THEN
105: COMMIT WORK;
106: END IF;
107: -- Standard call to get message count and if count is 1, get message info.
108: FND_MSG_PUB.Count_And_Get
109: (p_count => x_msg_count ,
110: p_data => x_msg_data ,
111: p_encoded => FND_API.G_FALSE );
112: EXCEPTION

Line 116: FND_MSG_PUB.count_and_get

112: EXCEPTION
113: WHEN FND_API.G_EXC_ERROR THEN
114: ROLLBACK TO Create_Hierarchy_Type;
115: x_return_status := FND_API.G_RET_STS_ERROR ;
116: FND_MSG_PUB.count_and_get
117: (p_count => x_msg_count ,
118: p_data => x_msg_data ,
119: p_encoded => FND_API.G_FALSE );
120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 123: FND_MSG_PUB.count_and_get

119: p_encoded => FND_API.G_FALSE );
120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
121: ROLLBACK TO Create_Hierarchy_Type;
122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
123: FND_MSG_PUB.count_and_get
124: (p_count => x_msg_count ,
125: p_data => x_msg_data ,
126: p_encoded => FND_API.G_FALSE );
127: WHEN OTHERS THEN

Line 130: IF FND_MSG_PUB.check_msg_level

126: p_encoded => FND_API.G_FALSE );
127: WHEN OTHERS THEN
128: ROLLBACK TO Create_Hierarchy_Type;
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
130: IF FND_MSG_PUB.check_msg_level
131: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
132: THEN
133: FND_MSG_PUB.add_exc_msg
134: (G_PKG_NAME ,

Line 131: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

127: WHEN OTHERS THEN
128: ROLLBACK TO Create_Hierarchy_Type;
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
130: IF FND_MSG_PUB.check_msg_level
131: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
132: THEN
133: FND_MSG_PUB.add_exc_msg
134: (G_PKG_NAME ,
135: l_api_name );

Line 133: FND_MSG_PUB.add_exc_msg

129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
130: IF FND_MSG_PUB.check_msg_level
131: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
132: THEN
133: FND_MSG_PUB.add_exc_msg
134: (G_PKG_NAME ,
135: l_api_name );
136: END IF;
137: FND_MSG_PUB.count_and_get

Line 137: FND_MSG_PUB.count_and_get

133: FND_MSG_PUB.add_exc_msg
134: (G_PKG_NAME ,
135: l_api_name );
136: END IF;
137: FND_MSG_PUB.count_and_get
138: (p_count => x_msg_count ,
139: p_data => x_msg_data ,
140: p_encoded => FND_API.G_FALSE );
141: END Create_Hierarchy_Type;

Line 184: FND_MSG_PUB.initialize;

180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: END IF;
182: -- Initialize message list if p_init_msg_list is set to TRUE.
183: IF FND_API.to_Boolean( p_init_msg_list ) THEN
184: FND_MSG_PUB.initialize;
185: END IF;
186: -- Initialize API return status to success
187: x_return_status := FND_API.G_RET_STS_SUCCESS;
188:

Line 197: fnd_msg_pub.add;

193: fetch c into tlinfo;
194: if (c%notfound) then
195: close c;
196: fnd_message.set_name('CN', 'CN_RECORD_DELETED');
197: fnd_msg_pub.add;
198: raise fnd_api.g_exc_error;
199: end if;
200: close c;
201:

Line 207: FND_MSG_PUB.ADD;

203: select count(1) into l_count from cn_dimensions
204: where name = p_name and dimension_id <> p_dimension_id and org_id = p_org_id; --R12 MOAC changes
205: if l_count > 0 then
206: FND_MESSAGE.SET_NAME('CN', 'CN_NAME_NOT_UNIQUE');
207: FND_MSG_PUB.ADD;
208: RAISE FND_API.G_EXC_ERROR;
209: end if;
210:
211: -- we cannot update the base table... fetch existing source_table_id

Line 218: fnd_msg_pub.add;

214:
215:
216: if (tlinfo.object_version_number <> p_object_version_number) then
217: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
218: fnd_msg_pub.add;
219: raise fnd_api.g_exc_error;
220: end if;
221: -- END LOCK ROW --
222:

Line 245: FND_MSG_PUB.Count_And_Get

241: IF FND_API.To_Boolean( p_commit ) THEN
242: COMMIT WORK;
243: END IF;
244: -- Standard call to get message count and if count is 1, get message info.
245: FND_MSG_PUB.Count_And_Get
246: (p_count => x_msg_count ,
247: p_data => x_msg_data ,
248: p_encoded => FND_API.G_FALSE );
249: EXCEPTION

Line 253: FND_MSG_PUB.count_and_get

249: EXCEPTION
250: WHEN FND_API.G_EXC_ERROR THEN
251: ROLLBACK TO Update_Hierarchy_Type;
252: x_return_status := FND_API.G_RET_STS_ERROR ;
253: FND_MSG_PUB.count_and_get
254: (p_count => x_msg_count ,
255: p_data => x_msg_data ,
256: p_encoded => FND_API.G_FALSE );
257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 260: FND_MSG_PUB.count_and_get

256: p_encoded => FND_API.G_FALSE );
257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
258: ROLLBACK TO Update_Hierarchy_Type;
259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
260: FND_MSG_PUB.count_and_get
261: (p_count => x_msg_count ,
262: p_data => x_msg_data ,
263: p_encoded => FND_API.G_FALSE );
264: WHEN OTHERS THEN

Line 267: IF FND_MSG_PUB.check_msg_level

263: p_encoded => FND_API.G_FALSE );
264: WHEN OTHERS THEN
265: ROLLBACK TO Update_Hierarchy_Type;
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
267: IF FND_MSG_PUB.check_msg_level
268: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
269: THEN
270: FND_MSG_PUB.add_exc_msg
271: (G_PKG_NAME ,

Line 268: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

264: WHEN OTHERS THEN
265: ROLLBACK TO Update_Hierarchy_Type;
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
267: IF FND_MSG_PUB.check_msg_level
268: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
269: THEN
270: FND_MSG_PUB.add_exc_msg
271: (G_PKG_NAME ,
272: l_api_name );

Line 270: FND_MSG_PUB.add_exc_msg

266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
267: IF FND_MSG_PUB.check_msg_level
268: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
269: THEN
270: FND_MSG_PUB.add_exc_msg
271: (G_PKG_NAME ,
272: l_api_name );
273: END IF;
274: FND_MSG_PUB.count_and_get

Line 274: FND_MSG_PUB.count_and_get

270: FND_MSG_PUB.add_exc_msg
271: (G_PKG_NAME ,
272: l_api_name );
273: END IF;
274: FND_MSG_PUB.count_and_get
275: (p_count => x_msg_count ,
276: p_data => x_msg_data ,
277: p_encoded => FND_API.G_FALSE );
278: END Update_Hierarchy_Type;

Line 311: FND_MSG_PUB.initialize;

307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
308: END IF;
309: -- Initialize message list if p_init_msg_list is set to TRUE.
310: IF FND_API.to_Boolean( p_init_msg_list ) THEN
311: FND_MSG_PUB.initialize;
312: END IF;
313: -- Initialize API return status to success
314: x_return_status := FND_API.G_RET_STS_SUCCESS;
315:

Line 331: FND_MSG_PUB.Count_And_Get

327: IF FND_API.To_Boolean( p_commit ) THEN
328: COMMIT WORK;
329: END IF;
330: -- Standard call to get message count and if count is 1, get message info.
331: FND_MSG_PUB.Count_And_Get
332: (p_count => x_msg_count ,
333: p_data => x_msg_data ,
334: p_encoded => FND_API.G_FALSE );
335: EXCEPTION

Line 339: FND_MSG_PUB.count_and_get

335: EXCEPTION
336: WHEN FND_API.G_EXC_ERROR THEN
337: ROLLBACK TO Delete_Hierarchy_Type;
338: x_return_status := FND_API.G_RET_STS_ERROR ;
339: FND_MSG_PUB.count_and_get
340: (p_count => x_msg_count ,
341: p_data => x_msg_data ,
342: p_encoded => FND_API.G_FALSE );
343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 346: FND_MSG_PUB.count_and_get

342: p_encoded => FND_API.G_FALSE );
343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
344: ROLLBACK TO Delete_Hierarchy_Type;
345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
346: FND_MSG_PUB.count_and_get
347: (p_count => x_msg_count ,
348: p_data => x_msg_data ,
349: p_encoded => FND_API.G_FALSE );
350: WHEN OTHERS THEN

Line 353: IF FND_MSG_PUB.check_msg_level

349: p_encoded => FND_API.G_FALSE );
350: WHEN OTHERS THEN
351: ROLLBACK TO Delete_Hierarchy_Type;
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
353: IF FND_MSG_PUB.check_msg_level
354: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
355: THEN
356: FND_MSG_PUB.add_exc_msg
357: (G_PKG_NAME ,

Line 354: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

350: WHEN OTHERS THEN
351: ROLLBACK TO Delete_Hierarchy_Type;
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
353: IF FND_MSG_PUB.check_msg_level
354: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
355: THEN
356: FND_MSG_PUB.add_exc_msg
357: (G_PKG_NAME ,
358: l_api_name );

Line 356: FND_MSG_PUB.add_exc_msg

352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
353: IF FND_MSG_PUB.check_msg_level
354: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
355: THEN
356: FND_MSG_PUB.add_exc_msg
357: (G_PKG_NAME ,
358: l_api_name );
359: END IF;
360: FND_MSG_PUB.count_and_get

Line 360: FND_MSG_PUB.count_and_get

356: FND_MSG_PUB.add_exc_msg
357: (G_PKG_NAME ,
358: l_api_name );
359: END IF;
360: FND_MSG_PUB.count_and_get
361: (p_count => x_msg_count ,
362: p_data => x_msg_data ,
363: p_encoded => FND_API.G_FALSE );
364: END Delete_Hierarchy_Type;

Line 401: FND_MSG_PUB.initialize;

397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
398: END IF;
399: -- Initialize message list if p_init_msg_list is set to TRUE.
400: IF FND_API.to_Boolean( p_init_msg_list ) THEN
401: FND_MSG_PUB.initialize;
402: END IF;
403: -- Initialize API return status to success
404: x_return_status := FND_API.G_RET_STS_SUCCESS;
405:

Line 417: FND_MSG_PUB.ADD;

413: --R12 MOAC Changes--End
414:
415: if l_count > 0 then
416: FND_MESSAGE.SET_NAME('CN', 'CN_NAME_NOT_UNIQUE');
417: FND_MSG_PUB.ADD;
418: RAISE FND_API.G_EXC_ERROR;
419: end if;
420:
421: -- call the original forms API (CNDIHY.fmb -> CNDIHY2s/b.pls)

Line 445: FND_MSG_PUB.Count_And_Get

441: IF FND_API.To_Boolean( p_commit ) THEN
442: COMMIT WORK;
443: END IF;
444: -- Standard call to get message count and if count is 1, get message info.
445: FND_MSG_PUB.Count_And_Get
446: (p_count => x_msg_count ,
447: p_data => x_msg_data ,
448: p_encoded => FND_API.G_FALSE );
449: EXCEPTION

Line 453: FND_MSG_PUB.count_and_get

449: EXCEPTION
450: WHEN FND_API.G_EXC_ERROR THEN
451: ROLLBACK TO Create_Head_Hierarchy;
452: x_return_status := FND_API.G_RET_STS_ERROR ;
453: FND_MSG_PUB.count_and_get
454: (p_count => x_msg_count ,
455: p_data => x_msg_data ,
456: p_encoded => FND_API.G_FALSE );
457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 460: FND_MSG_PUB.count_and_get

456: p_encoded => FND_API.G_FALSE );
457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
458: ROLLBACK TO Create_Head_Hierarchy;
459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
460: FND_MSG_PUB.count_and_get
461: (p_count => x_msg_count ,
462: p_data => x_msg_data ,
463: p_encoded => FND_API.G_FALSE );
464: WHEN OTHERS THEN

Line 467: IF FND_MSG_PUB.check_msg_level

463: p_encoded => FND_API.G_FALSE );
464: WHEN OTHERS THEN
465: ROLLBACK TO Create_Head_Hierarchy;
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
467: IF FND_MSG_PUB.check_msg_level
468: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
469: THEN
470: FND_MSG_PUB.add_exc_msg
471: (G_PKG_NAME ,

Line 468: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

464: WHEN OTHERS THEN
465: ROLLBACK TO Create_Head_Hierarchy;
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
467: IF FND_MSG_PUB.check_msg_level
468: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
469: THEN
470: FND_MSG_PUB.add_exc_msg
471: (G_PKG_NAME ,
472: l_api_name );

Line 470: FND_MSG_PUB.add_exc_msg

466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
467: IF FND_MSG_PUB.check_msg_level
468: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
469: THEN
470: FND_MSG_PUB.add_exc_msg
471: (G_PKG_NAME ,
472: l_api_name );
473: END IF;
474: FND_MSG_PUB.count_and_get

Line 474: FND_MSG_PUB.count_and_get

470: FND_MSG_PUB.add_exc_msg
471: (G_PKG_NAME ,
472: l_api_name );
473: END IF;
474: FND_MSG_PUB.count_and_get
475: (p_count => x_msg_count ,
476: p_data => x_msg_data ,
477: p_encoded => FND_API.G_FALSE );
478: END Create_Head_Hierarchy;

Line 523: FND_MSG_PUB.initialize;

519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
520: END IF;
521: -- Initialize message list if p_init_msg_list is set to TRUE.
522: IF FND_API.to_Boolean( p_init_msg_list ) THEN
523: FND_MSG_PUB.initialize;
524: END IF;
525: -- Initialize API return status to success
526: x_return_status := FND_API.G_RET_STS_SUCCESS;
527:

Line 538: fnd_msg_pub.add;

534: fetch c into tlinfo;
535: if (c%notfound) then
536: close c;
537: fnd_message.set_name('CN', 'CN_RECORD_DELETED');
538: fnd_msg_pub.add;
539: raise fnd_api.g_exc_error;
540: end if;
541: close c;
542:

Line 545: fnd_msg_pub.add;

541: close c;
542:
543: if (tlinfo.object_version_number <> p_object_version_number) then
544: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
545: fnd_msg_pub.add;
546: raise fnd_api.g_exc_error;
547: end if;
548: -- END LOCK ROW --
549:

Line 559: FND_MSG_PUB.ADD;

555: --R12 MOAC Changes--End
556: and head_hierarchy_id <> p_head_hierarchy_id;
557: if l_count > 0 then
558: FND_MESSAGE.SET_NAME('CN', 'CN_NAME_NOT_UNIQUE');
559: FND_MSG_PUB.ADD;
560: RAISE FND_API.G_EXC_ERROR;
561: end if;
562:
563: cn_head_hierarchies_all_pkg.update_row

Line 584: FND_MSG_PUB.Count_And_Get

580: IF FND_API.To_Boolean( p_commit ) THEN
581: COMMIT WORK;
582: END IF;
583: -- Standard call to get message count and if count is 1, get message info.
584: FND_MSG_PUB.Count_And_Get
585: (p_count => x_msg_count ,
586: p_data => x_msg_data ,
587: p_encoded => FND_API.G_FALSE );
588: EXCEPTION

Line 592: FND_MSG_PUB.count_and_get

588: EXCEPTION
589: WHEN FND_API.G_EXC_ERROR THEN
590: ROLLBACK TO Update_Head_Hierarchy;
591: x_return_status := FND_API.G_RET_STS_ERROR ;
592: FND_MSG_PUB.count_and_get
593: (p_count => x_msg_count ,
594: p_data => x_msg_data ,
595: p_encoded => FND_API.G_FALSE );
596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 599: FND_MSG_PUB.count_and_get

595: p_encoded => FND_API.G_FALSE );
596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
597: ROLLBACK TO Update_Head_Hierarchy;
598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
599: FND_MSG_PUB.count_and_get
600: (p_count => x_msg_count ,
601: p_data => x_msg_data ,
602: p_encoded => FND_API.G_FALSE );
603: WHEN OTHERS THEN

Line 606: IF FND_MSG_PUB.check_msg_level

602: p_encoded => FND_API.G_FALSE );
603: WHEN OTHERS THEN
604: ROLLBACK TO Update_Head_Hierarchy;
605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
606: IF FND_MSG_PUB.check_msg_level
607: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
608: THEN
609: FND_MSG_PUB.add_exc_msg
610: (G_PKG_NAME ,

Line 607: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

603: WHEN OTHERS THEN
604: ROLLBACK TO Update_Head_Hierarchy;
605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
606: IF FND_MSG_PUB.check_msg_level
607: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
608: THEN
609: FND_MSG_PUB.add_exc_msg
610: (G_PKG_NAME ,
611: l_api_name );

Line 609: FND_MSG_PUB.add_exc_msg

605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
606: IF FND_MSG_PUB.check_msg_level
607: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
608: THEN
609: FND_MSG_PUB.add_exc_msg
610: (G_PKG_NAME ,
611: l_api_name );
612: END IF;
613: FND_MSG_PUB.count_and_get

Line 613: FND_MSG_PUB.count_and_get

609: FND_MSG_PUB.add_exc_msg
610: (G_PKG_NAME ,
611: l_api_name );
612: END IF;
613: FND_MSG_PUB.count_and_get
614: (p_count => x_msg_count ,
615: p_data => x_msg_data ,
616: p_encoded => FND_API.G_FALSE );
617: END Update_Head_Hierarchy;

Line 650: FND_MSG_PUB.initialize;

646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
647: END IF;
648: -- Initialize message list if p_init_msg_list is set to TRUE.
649: IF FND_API.to_Boolean( p_init_msg_list ) THEN
650: FND_MSG_PUB.initialize;
651: END IF;
652: -- Initialize API return status to success
653: x_return_status := FND_API.G_RET_STS_SUCCESS;
654:

Line 668: FND_MSG_PUB.Count_And_Get

664: IF FND_API.To_Boolean( p_commit ) THEN
665: COMMIT WORK;
666: END IF;
667: -- Standard call to get message count and if count is 1, get message info.
668: FND_MSG_PUB.Count_And_Get
669: (p_count => x_msg_count ,
670: p_data => x_msg_data ,
671: p_encoded => FND_API.G_FALSE );
672: EXCEPTION

Line 676: FND_MSG_PUB.count_and_get

672: EXCEPTION
673: WHEN FND_API.G_EXC_ERROR THEN
674: ROLLBACK TO Delete_Head_Hierarchy;
675: x_return_status := FND_API.G_RET_STS_ERROR ;
676: FND_MSG_PUB.count_and_get
677: (p_count => x_msg_count ,
678: p_data => x_msg_data ,
679: p_encoded => FND_API.G_FALSE );
680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 683: FND_MSG_PUB.count_and_get

679: p_encoded => FND_API.G_FALSE );
680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
681: ROLLBACK TO Delete_Head_Hierarchy;
682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
683: FND_MSG_PUB.count_and_get
684: (p_count => x_msg_count ,
685: p_data => x_msg_data ,
686: p_encoded => FND_API.G_FALSE );
687: WHEN OTHERS THEN

Line 690: IF FND_MSG_PUB.check_msg_level

686: p_encoded => FND_API.G_FALSE );
687: WHEN OTHERS THEN
688: ROLLBACK TO Delete_Head_Hierarchy;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
690: IF FND_MSG_PUB.check_msg_level
691: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
692: THEN
693: FND_MSG_PUB.add_exc_msg
694: (G_PKG_NAME ,

Line 691: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

687: WHEN OTHERS THEN
688: ROLLBACK TO Delete_Head_Hierarchy;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
690: IF FND_MSG_PUB.check_msg_level
691: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
692: THEN
693: FND_MSG_PUB.add_exc_msg
694: (G_PKG_NAME ,
695: l_api_name );

Line 693: FND_MSG_PUB.add_exc_msg

689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
690: IF FND_MSG_PUB.check_msg_level
691: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
692: THEN
693: FND_MSG_PUB.add_exc_msg
694: (G_PKG_NAME ,
695: l_api_name );
696: END IF;
697: FND_MSG_PUB.count_and_get

Line 697: FND_MSG_PUB.count_and_get

693: FND_MSG_PUB.add_exc_msg
694: (G_PKG_NAME ,
695: l_api_name );
696: END IF;
697: FND_MSG_PUB.count_and_get
698: (p_count => x_msg_count ,
699: p_data => x_msg_data ,
700: p_encoded => FND_API.G_FALSE );
701: END Delete_Head_Hierarchy;

Line 759: FND_MSG_PUB.initialize;

755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
756: END IF;
757: -- Initialize message list if p_init_msg_list is set to TRUE.
758: IF FND_API.to_Boolean( p_init_msg_list ) THEN
759: FND_MSG_PUB.initialize;
760: END IF;
761: -- Initialize API return status to success
762: x_return_status := FND_API.G_RET_STS_SUCCESS;
763:

Line 779: FND_MSG_PUB.ADD;

775: (start_date >= p_start_date and
776: start_date <= nvl(p_end_date, start_date)));
777: if l_count > 0 then
778: FND_MESSAGE.SET_NAME('CN', 'CN_DATE_OVERLAP');
779: FND_MSG_PUB.ADD;
780: RAISE FND_API.G_EXC_ERROR;
781: end if;
782:
783: if p_end_date is not null and

Line 786: FND_MSG_PUB.ADD;

782:
783: if p_end_date is not null and
784: p_end_date < p_start_date then
785: FND_MESSAGE.SET_NAME('CN', 'ALL_INVALID_PERIOD_RANGE');
786: FND_MSG_PUB.ADD;
787: RAISE FND_API.G_EXC_ERROR;
788: end if;
789:
790:

Line 824: FND_MSG_PUB.Count_And_Get

820: IF FND_API.To_Boolean( p_commit ) THEN
821: COMMIT WORK;
822: END IF;
823: -- Standard call to get message count and if count is 1, get message info.
824: FND_MSG_PUB.Count_And_Get
825: (p_count => x_msg_count ,
826: p_data => x_msg_data ,
827: p_encoded => FND_API.G_FALSE );
828: EXCEPTION

Line 832: FND_MSG_PUB.count_and_get

828: EXCEPTION
829: WHEN FND_API.G_EXC_ERROR THEN
830: ROLLBACK TO Create_Dim_Hierarchy;
831: x_return_status := FND_API.G_RET_STS_ERROR ;
832: FND_MSG_PUB.count_and_get
833: (p_count => x_msg_count ,
834: p_data => x_msg_data ,
835: p_encoded => FND_API.G_FALSE );
836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 839: FND_MSG_PUB.count_and_get

835: p_encoded => FND_API.G_FALSE );
836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
837: ROLLBACK TO Create_Dim_Hierarchy;
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
839: FND_MSG_PUB.count_and_get
840: (p_count => x_msg_count ,
841: p_data => x_msg_data ,
842: p_encoded => FND_API.G_FALSE );
843: WHEN OTHERS THEN

Line 846: IF FND_MSG_PUB.check_msg_level

842: p_encoded => FND_API.G_FALSE );
843: WHEN OTHERS THEN
844: ROLLBACK TO Create_Dim_Hierarchy;
845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
846: IF FND_MSG_PUB.check_msg_level
847: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
848: THEN
849: FND_MSG_PUB.add_exc_msg
850: (G_PKG_NAME ,

Line 847: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

843: WHEN OTHERS THEN
844: ROLLBACK TO Create_Dim_Hierarchy;
845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
846: IF FND_MSG_PUB.check_msg_level
847: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
848: THEN
849: FND_MSG_PUB.add_exc_msg
850: (G_PKG_NAME ,
851: l_api_name );

Line 849: FND_MSG_PUB.add_exc_msg

845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
846: IF FND_MSG_PUB.check_msg_level
847: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
848: THEN
849: FND_MSG_PUB.add_exc_msg
850: (G_PKG_NAME ,
851: l_api_name );
852: END IF;
853: FND_MSG_PUB.count_and_get

Line 853: FND_MSG_PUB.count_and_get

849: FND_MSG_PUB.add_exc_msg
850: (G_PKG_NAME ,
851: l_api_name );
852: END IF;
853: FND_MSG_PUB.count_and_get
854: (p_count => x_msg_count ,
855: p_data => x_msg_data ,
856: p_encoded => FND_API.G_FALSE );
857: END Create_Dim_Hierarchy;

Line 897: FND_MSG_PUB.initialize;

893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
894: END IF;
895: -- Initialize message list if p_init_msg_list is set to TRUE.
896: IF FND_API.to_Boolean( p_init_msg_list ) THEN
897: FND_MSG_PUB.initialize;
898: END IF;
899: -- Initialize API return status to success
900: x_return_status := FND_API.G_RET_STS_SUCCESS;
901:

Line 918: FND_MSG_PUB.ADD;

914:
915: if p_end_date is not null and
916: p_end_date < p_start_date then
917: FND_MESSAGE.SET_NAME('CN', 'ALL_INVALID_PERIOD_RANGE');
918: FND_MSG_PUB.ADD;
919: RAISE FND_API.G_EXC_ERROR;
920: end if;
921:
922: select count(1) into l_count

Line 935: FND_MSG_PUB.ADD;

931: (start_date >= p_start_date and
932: start_date <= nvl(p_end_date, start_date)));
933: if l_count > 0 then
934: FND_MESSAGE.SET_NAME('CN', 'CN_DATE_OVERLAP');
935: FND_MSG_PUB.ADD;
936: RAISE FND_API.G_EXC_ERROR;
937: end if;
938:
939:

Line 985: FND_MSG_PUB.Count_And_Get

981: IF FND_API.To_Boolean( p_commit ) THEN
982: COMMIT WORK;
983: END IF;
984: -- Standard call to get message count and if count is 1, get message info.
985: FND_MSG_PUB.Count_And_Get
986: (p_count => x_msg_count ,
987: p_data => x_msg_data ,
988: p_encoded => FND_API.G_FALSE );
989: EXCEPTION

Line 993: FND_MSG_PUB.count_and_get

989: EXCEPTION
990: WHEN FND_API.G_EXC_ERROR THEN
991: ROLLBACK TO Update_Dim_Hierarchy;
992: x_return_status := FND_API.G_RET_STS_ERROR ;
993: FND_MSG_PUB.count_and_get
994: (p_count => x_msg_count ,
995: p_data => x_msg_data ,
996: p_encoded => FND_API.G_FALSE );
997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1000: FND_MSG_PUB.count_and_get

996: p_encoded => FND_API.G_FALSE );
997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
998: ROLLBACK TO Update_Dim_Hierarchy;
999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1000: FND_MSG_PUB.count_and_get
1001: (p_count => x_msg_count ,
1002: p_data => x_msg_data ,
1003: p_encoded => FND_API.G_FALSE );
1004: WHEN OTHERS THEN

Line 1007: IF FND_MSG_PUB.check_msg_level

1003: p_encoded => FND_API.G_FALSE );
1004: WHEN OTHERS THEN
1005: ROLLBACK TO Update_Dim_Hierarchy;
1006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1007: IF FND_MSG_PUB.check_msg_level
1008: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1009: THEN
1010: FND_MSG_PUB.add_exc_msg
1011: (G_PKG_NAME ,

Line 1008: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1004: WHEN OTHERS THEN
1005: ROLLBACK TO Update_Dim_Hierarchy;
1006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1007: IF FND_MSG_PUB.check_msg_level
1008: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1009: THEN
1010: FND_MSG_PUB.add_exc_msg
1011: (G_PKG_NAME ,
1012: l_api_name );

Line 1010: FND_MSG_PUB.add_exc_msg

1006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1007: IF FND_MSG_PUB.check_msg_level
1008: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1009: THEN
1010: FND_MSG_PUB.add_exc_msg
1011: (G_PKG_NAME ,
1012: l_api_name );
1013: END IF;
1014: FND_MSG_PUB.count_and_get

Line 1014: FND_MSG_PUB.count_and_get

1010: FND_MSG_PUB.add_exc_msg
1011: (G_PKG_NAME ,
1012: l_api_name );
1013: END IF;
1014: FND_MSG_PUB.count_and_get
1015: (p_count => x_msg_count ,
1016: p_data => x_msg_data ,
1017: p_encoded => FND_API.G_FALSE );
1018: END Update_Dim_Hierarchy;

Line 1054: FND_MSG_PUB.initialize;

1050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1051: END IF;
1052: -- Initialize message list if p_init_msg_list is set to TRUE.
1053: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1054: FND_MSG_PUB.initialize;
1055: END IF;
1056: -- Initialize API return status to success
1057: x_return_status := FND_API.G_RET_STS_SUCCESS;
1058:

Line 1095: FND_MSG_PUB.Count_And_Get

1091: IF FND_API.To_Boolean( p_commit ) THEN
1092: COMMIT WORK;
1093: END IF;
1094: -- Standard call to get message count and if count is 1, get message info.
1095: FND_MSG_PUB.Count_And_Get
1096: (p_count => x_msg_count ,
1097: p_data => x_msg_data ,
1098: p_encoded => FND_API.G_FALSE );
1099: EXCEPTION

Line 1103: FND_MSG_PUB.count_and_get

1099: EXCEPTION
1100: WHEN FND_API.G_EXC_ERROR THEN
1101: ROLLBACK TO Delete_Dim_Hierarchy;
1102: x_return_status := FND_API.G_RET_STS_ERROR ;
1103: FND_MSG_PUB.count_and_get
1104: (p_count => x_msg_count ,
1105: p_data => x_msg_data ,
1106: p_encoded => FND_API.G_FALSE );
1107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1110: FND_MSG_PUB.count_and_get

1106: p_encoded => FND_API.G_FALSE );
1107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1108: ROLLBACK TO Delete_Dim_Hierarchy;
1109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1110: FND_MSG_PUB.count_and_get
1111: (p_count => x_msg_count ,
1112: p_data => x_msg_data ,
1113: p_encoded => FND_API.G_FALSE );
1114: WHEN OTHERS THEN

Line 1117: IF FND_MSG_PUB.check_msg_level

1113: p_encoded => FND_API.G_FALSE );
1114: WHEN OTHERS THEN
1115: ROLLBACK TO Delete_Dim_Hierarchy;
1116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1117: IF FND_MSG_PUB.check_msg_level
1118: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1119: THEN
1120: FND_MSG_PUB.add_exc_msg
1121: (G_PKG_NAME ,

Line 1118: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1114: WHEN OTHERS THEN
1115: ROLLBACK TO Delete_Dim_Hierarchy;
1116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1117: IF FND_MSG_PUB.check_msg_level
1118: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1119: THEN
1120: FND_MSG_PUB.add_exc_msg
1121: (G_PKG_NAME ,
1122: l_api_name );

Line 1120: FND_MSG_PUB.add_exc_msg

1116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1117: IF FND_MSG_PUB.check_msg_level
1118: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1119: THEN
1120: FND_MSG_PUB.add_exc_msg
1121: (G_PKG_NAME ,
1122: l_api_name );
1123: END IF;
1124: FND_MSG_PUB.count_and_get

Line 1124: FND_MSG_PUB.count_and_get

1120: FND_MSG_PUB.add_exc_msg
1121: (G_PKG_NAME ,
1122: l_api_name );
1123: END IF;
1124: FND_MSG_PUB.count_and_get
1125: (p_count => x_msg_count ,
1126: p_data => x_msg_data ,
1127: p_encoded => FND_API.G_FALSE );
1128: END Delete_Dim_Hierarchy;

Line 1194: FND_MSG_PUB.initialize;

1190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1191: END IF;
1192: -- Initialize message list if p_init_msg_list is set to TRUE.
1193: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1194: FND_MSG_PUB.initialize;
1195: END IF;
1196: -- Initialize API return status to success
1197: x_return_status := FND_API.G_RET_STS_SUCCESS;
1198:

Line 1220: FND_MSG_PUB.ADD;

1216: FND_MESSAGE.SET_NAME('CN', 'REV_CLASS_HIER_CHECK');
1217: fnd_message.set_token('REV_CLASS_NAME_PARENT', l_par_name);
1218: fnd_message.set_token('REV_CLASS_NAME_CHILD', p_name);
1219: fnd_message.set_token('PERIODS', l_start_date || ' - ' || l_end_date);
1220: FND_MSG_PUB.ADD;
1221: RAISE FND_API.G_EXC_ERROR;
1222: END IF;
1223: CLOSE dup_rev_classes;
1224: END IF;

Line 1239: FND_MSG_PUB.ADD;

1235: --R12 MOAC Changes--End
1236: EXCEPTION
1237: WHEN DUP_VAL_ON_INDEX THEN
1238: FND_MESSAGE.SET_NAME('CN', 'HIER_NO_DIAMONDS');
1239: FND_MSG_PUB.ADD;
1240: RAISE FND_API.G_EXC_ERROR;
1241: END;
1242:
1243: -- End of API body.

Line 1250: FND_MSG_PUB.Count_And_Get

1246: IF FND_API.To_Boolean( p_commit ) THEN
1247: COMMIT WORK;
1248: END IF;
1249: -- Standard call to get message count and if count is 1, get message info.
1250: FND_MSG_PUB.Count_And_Get
1251: (p_count => x_msg_count ,
1252: p_data => x_msg_data ,
1253: p_encoded => FND_API.G_FALSE );
1254: EXCEPTION

Line 1258: FND_MSG_PUB.count_and_get

1254: EXCEPTION
1255: WHEN FND_API.G_EXC_ERROR THEN
1256: ROLLBACK TO Create_Edge;
1257: x_return_status := FND_API.G_RET_STS_ERROR ;
1258: FND_MSG_PUB.count_and_get
1259: (p_count => x_msg_count ,
1260: p_data => x_msg_data ,
1261: p_encoded => FND_API.G_FALSE );
1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1265: FND_MSG_PUB.count_and_get

1261: p_encoded => FND_API.G_FALSE );
1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1263: ROLLBACK TO Create_Edge;
1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1265: FND_MSG_PUB.count_and_get
1266: (p_count => x_msg_count ,
1267: p_data => x_msg_data ,
1268: p_encoded => FND_API.G_FALSE );
1269: WHEN OTHERS THEN

Line 1272: IF FND_MSG_PUB.check_msg_level

1268: p_encoded => FND_API.G_FALSE );
1269: WHEN OTHERS THEN
1270: ROLLBACK TO Create_Edge;
1271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1272: IF FND_MSG_PUB.check_msg_level
1273: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1274: THEN
1275: FND_MSG_PUB.add_exc_msg
1276: (G_PKG_NAME ,

Line 1273: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1269: WHEN OTHERS THEN
1270: ROLLBACK TO Create_Edge;
1271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1272: IF FND_MSG_PUB.check_msg_level
1273: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1274: THEN
1275: FND_MSG_PUB.add_exc_msg
1276: (G_PKG_NAME ,
1277: l_api_name );

Line 1275: FND_MSG_PUB.add_exc_msg

1271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1272: IF FND_MSG_PUB.check_msg_level
1273: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1274: THEN
1275: FND_MSG_PUB.add_exc_msg
1276: (G_PKG_NAME ,
1277: l_api_name );
1278: END IF;
1279: FND_MSG_PUB.count_and_get

Line 1279: FND_MSG_PUB.count_and_get

1275: FND_MSG_PUB.add_exc_msg
1276: (G_PKG_NAME ,
1277: l_api_name );
1278: END IF;
1279: FND_MSG_PUB.count_and_get
1280: (p_count => x_msg_count ,
1281: p_data => x_msg_data ,
1282: p_encoded => FND_API.G_FALSE );
1283: END Create_Edge;

Line 1320: FND_MSG_PUB.initialize;

1316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1317: END IF;
1318: -- Initialize message list if p_init_msg_list is set to TRUE.
1319: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1320: FND_MSG_PUB.initialize;
1321: END IF;
1322: -- Initialize API return status to success
1323: x_return_status := FND_API.G_RET_STS_SUCCESS;
1324:

Line 1339: FND_MSG_PUB.ADD;

1335: --R12 MOAC Changes--End
1336:
1337: if l_ext_id is null then
1338: FND_MESSAGE.SET_NAME('CN', 'HIER_NO_DELETE_ROOT');
1339: FND_MSG_PUB.ADD;
1340: RAISE FND_API.G_EXC_ERROR;
1341: end if;
1342: end if;
1343:

Line 1356: fnd_msg_pub.add;

1352: --R12 MOAC Changes--End
1353:
1354: if l_count = 0 then
1355: fnd_message.set_name('CN', 'CN_RECORD_DELETED');
1356: fnd_msg_pub.add;
1357: raise fnd_api.g_exc_error;
1358: end if;
1359:
1360: CN_DIHY_TWO_API_PKG.Cascade_Delete

Line 1373: FND_MSG_PUB.Count_And_Get

1369: IF FND_API.To_Boolean( p_commit ) THEN
1370: COMMIT WORK;
1371: END IF;
1372: -- Standard call to get message count and if count is 1, get message info.
1373: FND_MSG_PUB.Count_And_Get
1374: (p_count => x_msg_count ,
1375: p_data => x_msg_data ,
1376: p_encoded => FND_API.G_FALSE );
1377: EXCEPTION

Line 1381: FND_MSG_PUB.count_and_get

1377: EXCEPTION
1378: WHEN FND_API.G_EXC_ERROR THEN
1379: ROLLBACK TO Delete_Edge;
1380: x_return_status := FND_API.G_RET_STS_ERROR ;
1381: FND_MSG_PUB.count_and_get
1382: (p_count => x_msg_count ,
1383: p_data => x_msg_data ,
1384: p_encoded => FND_API.G_FALSE );
1385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1388: FND_MSG_PUB.count_and_get

1384: p_encoded => FND_API.G_FALSE );
1385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1386: ROLLBACK TO Delete_Edge;
1387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1388: FND_MSG_PUB.count_and_get
1389: (p_count => x_msg_count ,
1390: p_data => x_msg_data ,
1391: p_encoded => FND_API.G_FALSE );
1392: WHEN OTHERS THEN

Line 1395: IF FND_MSG_PUB.check_msg_level

1391: p_encoded => FND_API.G_FALSE );
1392: WHEN OTHERS THEN
1393: ROLLBACK TO Delete_Edge;
1394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1395: IF FND_MSG_PUB.check_msg_level
1396: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1397: THEN
1398: FND_MSG_PUB.add_exc_msg
1399: (G_PKG_NAME ,

Line 1396: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1392: WHEN OTHERS THEN
1393: ROLLBACK TO Delete_Edge;
1394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1395: IF FND_MSG_PUB.check_msg_level
1396: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1397: THEN
1398: FND_MSG_PUB.add_exc_msg
1399: (G_PKG_NAME ,
1400: l_api_name );

Line 1398: FND_MSG_PUB.add_exc_msg

1394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1395: IF FND_MSG_PUB.check_msg_level
1396: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1397: THEN
1398: FND_MSG_PUB.add_exc_msg
1399: (G_PKG_NAME ,
1400: l_api_name );
1401: END IF;
1402: FND_MSG_PUB.count_and_get

Line 1402: FND_MSG_PUB.count_and_get

1398: FND_MSG_PUB.add_exc_msg
1399: (G_PKG_NAME ,
1400: l_api_name );
1401: END IF;
1402: FND_MSG_PUB.count_and_get
1403: (p_count => x_msg_count ,
1404: p_data => x_msg_data ,
1405: p_encoded => FND_API.G_FALSE );
1406: END Delete_Edge;

Line 1574: my_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);

1570: (p_message_text => 'Export threw exception : rts sts ' ||
1571: l_return_status,
1572: p_message_type => 'ERROR');
1573:
1574: my_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
1575: while (my_message is not null) loop
1576: l_message := l_message || my_message || '; ';
1577: my_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
1578: end loop;

Line 1577: my_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);

1573:
1574: my_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
1575: while (my_message is not null) loop
1576: l_message := l_message || my_message || '; ';
1577: my_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
1578: end loop;
1579:
1580: cn_message_pkg.write
1581: (p_message_text => l_message,

Line 1617: FND_MSG_PUB.count_and_get

1613: EXCEPTION
1614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1615: retcode := 2 ;
1616: cn_message_pkg.end_batch(l_process_audit_id);
1617: FND_MSG_PUB.count_and_get
1618: (p_count => l_msg_count ,
1619: p_data => errbuf ,
1620: p_encoded => FND_API.G_FALSE
1621: );

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

1626: retcode := 2 ;
1627: errbuf := fnd_program.message;
1628: ELSE
1629: retcode := 2 ;
1630: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1631: THEN
1632: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1633: END IF;
1634: FND_MSG_PUB.count_and_get

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

1628: ELSE
1629: retcode := 2 ;
1630: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1631: THEN
1632: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1633: END IF;
1634: FND_MSG_PUB.count_and_get
1635: (p_count => l_msg_count ,
1636: p_data => errbuf ,

Line 1634: FND_MSG_PUB.count_and_get

1630: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1631: THEN
1632: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1633: END IF;
1634: FND_MSG_PUB.count_and_get
1635: (p_count => l_msg_count ,
1636: p_data => errbuf ,
1637: p_encoded => FND_API.G_FALSE
1638: );