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

Line 27: fnd_msg_pub.ADD;

23: FETCH validate_role_state INTO l_dummy;
24: IF (validate_role_state%found) THEN
25: CLOSE validate_role_state;
26: fnd_message.set_name('CN', 'CN_ROLE_DETAIL_ASGNED');
27: fnd_msg_pub.ADD;
28: RAISE fnd_api.g_exc_error;
29: END IF;
30: CLOSE validate_role_state;
31:

Line 92: FND_MSG_PUB.initialize;

88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90: -- Initialize message list if p_init_msg_list is set to TRUE.
91: IF FND_API.to_Boolean( p_init_msg_list ) THEN
92: FND_MSG_PUB.initialize;
93: END IF;
94: -- Initialize API return status to success
95: x_return_status := FND_API.G_RET_STS_SUCCESS;
96: -- API body

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

97:
98: IF ( p_plan_text.role_id is NULL ) OR
99: ( p_plan_text.text_type is NULL )
100: THEN
101: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
102: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
103: FND_MESSAGE.SET_TOKEN('INPUT_NAME', 'Role or Text Type');
104: FND_MSG_PUB.Add;
105: END IF;

Line 104: FND_MSG_PUB.Add;

100: THEN
101: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
102: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
103: FND_MESSAGE.SET_TOKEN('INPUT_NAME', 'Role or Text Type');
104: FND_MSG_PUB.Add;
105: END IF;
106: RAISE FND_API.G_EXC_ERROR ;
107: END IF;
108:

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

128: sequence_id = nvl(p_plan_text.sequence_id, sequence_id)
129: );
130:
131: IF l_temp_count > 0 THEN
132: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
133: FND_MESSAGE.SET_NAME ('CN' , 'CN_ASSIGN_CANT_SAME');
134: FND_MSG_PUB.Add;
135: END IF;
136: RAISE FND_API.G_EXC_ERROR ;

Line 134: FND_MSG_PUB.Add;

130:
131: IF l_temp_count > 0 THEN
132: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
133: FND_MESSAGE.SET_NAME ('CN' , 'CN_ASSIGN_CANT_SAME');
134: FND_MSG_PUB.Add;
135: END IF;
136: RAISE FND_API.G_EXC_ERROR ;
137: END IF;
138:

Line 165: FND_MSG_PUB.Count_And_Get

161: IF FND_API.To_Boolean( p_commit ) THEN
162: COMMIT WORK;
163: END IF;
164: -- Standard call to get message count and if count is 1, get message info.
165: FND_MSG_PUB.Count_And_Get
166: (p_count => x_msg_count ,
167: p_data => x_msg_data ,
168: p_encoded => FND_API.G_FALSE );
169: EXCEPTION

Line 173: FND_MSG_PUB.Count_And_Get

169: EXCEPTION
170: WHEN FND_API.G_EXC_ERROR THEN
171: ROLLBACK TO Create_Plan_Text;
172: x_return_status := FND_API.G_RET_STS_ERROR ;
173: FND_MSG_PUB.Count_And_Get
174: (p_count => x_msg_count ,
175: p_data => x_msg_data ,
176: p_encoded => FND_API.G_FALSE );
177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 180: FND_MSG_PUB.Count_And_Get

176: p_encoded => FND_API.G_FALSE );
177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
178: ROLLBACK TO Create_Plan_Text;
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
180: FND_MSG_PUB.Count_And_Get
181: (p_count => x_msg_count ,
182: p_data => x_msg_data ,
183: p_encoded => FND_API.G_FALSE );
184: WHEN OTHERS THEN

Line 187: IF FND_MSG_PUB.Check_Msg_Level

183: p_encoded => FND_API.G_FALSE );
184: WHEN OTHERS THEN
185: ROLLBACK TO Create_Plan_Text;
186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
187: IF FND_MSG_PUB.Check_Msg_Level
188: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
189: THEN
190: FND_MSG_PUB.Add_Exc_Msg
191: (G_PKG_NAME ,

Line 188: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

184: WHEN OTHERS THEN
185: ROLLBACK TO Create_Plan_Text;
186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
187: IF FND_MSG_PUB.Check_Msg_Level
188: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
189: THEN
190: FND_MSG_PUB.Add_Exc_Msg
191: (G_PKG_NAME ,
192: l_api_name );

Line 190: FND_MSG_PUB.Add_Exc_Msg

186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
187: IF FND_MSG_PUB.Check_Msg_Level
188: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
189: THEN
190: FND_MSG_PUB.Add_Exc_Msg
191: (G_PKG_NAME ,
192: l_api_name );
193: END IF;
194: FND_MSG_PUB.Count_And_Get

Line 194: FND_MSG_PUB.Count_And_Get

190: FND_MSG_PUB.Add_Exc_Msg
191: (G_PKG_NAME ,
192: l_api_name );
193: END IF;
194: FND_MSG_PUB.Count_And_Get
195: (p_count => x_msg_count ,
196: p_data => x_msg_data ,
197: p_encoded => FND_API.G_FALSE );
198: END Create_Plan_Text;

Line 282: FND_MSG_PUB.initialize;

278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: END IF;
280: -- Initialize message list if p_init_msg_list is set to TRUE.
281: IF FND_API.to_Boolean( p_init_msg_list ) THEN
282: FND_MSG_PUB.initialize;
283: END IF;
284: -- Initialize API return status to success
285: x_return_status := FND_API.G_RET_STS_SUCCESS;
286: -- API body

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

287:
288: IF ( p_plan_text.role_id is NULL ) OR
289: ( p_plan_text.text_type is NULL )
290: THEN
291: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
292: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
293: FND_MESSAGE.SET_TOKEN('INPUT_NAME', 'Role or Text Type');
294: FND_MSG_PUB.Add;
295: END IF;

Line 294: FND_MSG_PUB.Add;

290: THEN
291: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
292: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
293: FND_MESSAGE.SET_TOKEN('INPUT_NAME', 'Role or Text Type');
294: FND_MSG_PUB.Add;
295: END IF;
296: RAISE FND_API.G_EXC_ERROR ;
297: END IF;
298:

Line 305: fnd_msg_pub.ADD;

301: FETCH validate_role_state INTO l_dummy;
302: IF (validate_role_state%found) THEN
303: CLOSE validate_role_state;
304: fnd_message.set_name('CN', 'CN_ROLE_DETAIL_ASGNED');
305: fnd_msg_pub.ADD;
306: RAISE fnd_api.g_exc_error;
307: END IF;
308: CLOSE validate_role_state;
309: */

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

328: AND plan_text_id <> p_plan_text.plan_text_id
329: ;
330:
331: IF l_temp_count > 0 THEN
332: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
333: FND_MESSAGE.SET_NAME ('CN' , 'CN_ASSIGN_CANT_SAME');
334: FND_MSG_PUB.Add;
335: END IF;
336: RAISE FND_API.G_EXC_ERROR ;

Line 334: FND_MSG_PUB.Add;

330:
331: IF l_temp_count > 0 THEN
332: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
333: FND_MESSAGE.SET_NAME ('CN' , 'CN_ASSIGN_CANT_SAME');
334: FND_MSG_PUB.Add;
335: END IF;
336: RAISE FND_API.G_EXC_ERROR ;
337: END IF;
338:

Line 347: fnd_msg_pub.add;

343: -- check object version number
344: IF l_plan_text.object_version_number <>
345: p_plan_text.object_version_number THEN
346: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
347: fnd_msg_pub.add;
348: raise fnd_api.g_exc_error;
349: END IF;
350:
351: CN_PLAN_TEXTS_PKG.Update_Row

Line 389: FND_MSG_PUB.Count_And_Get

385: IF FND_API.To_Boolean( p_commit ) THEN
386: COMMIT WORK;
387: END IF;
388: -- Standard call to get message count and if count is 1, get message info.
389: FND_MSG_PUB.Count_And_Get
390: (p_count => x_msg_count ,
391: p_data => x_msg_data ,
392: p_encoded => FND_API.G_FALSE );
393: EXCEPTION

Line 397: FND_MSG_PUB.Count_And_Get

393: EXCEPTION
394: WHEN FND_API.G_EXC_ERROR THEN
395: ROLLBACK TO Update_Plan_Text;
396: x_return_status := FND_API.G_RET_STS_ERROR ;
397: FND_MSG_PUB.Count_And_Get
398: (p_count => x_msg_count ,
399: p_data => x_msg_data ,
400: p_encoded => FND_API.G_FALSE );
401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 404: FND_MSG_PUB.Count_And_Get

400: p_encoded => FND_API.G_FALSE );
401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
402: ROLLBACK TO Update_Plan_Text;
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
404: FND_MSG_PUB.Count_And_Get
405: (p_count => x_msg_count ,
406: p_data => x_msg_data ,
407: p_encoded => FND_API.G_FALSE );
408: WHEN OTHERS THEN

Line 411: IF FND_MSG_PUB.Check_Msg_Level

407: p_encoded => FND_API.G_FALSE );
408: WHEN OTHERS THEN
409: ROLLBACK TO Update_Plan_Text;
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
411: IF FND_MSG_PUB.Check_Msg_Level
412: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
413: THEN
414: FND_MSG_PUB.Add_Exc_Msg
415: (G_PKG_NAME ,

Line 412: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

408: WHEN OTHERS THEN
409: ROLLBACK TO Update_Plan_Text;
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
411: IF FND_MSG_PUB.Check_Msg_Level
412: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
413: THEN
414: FND_MSG_PUB.Add_Exc_Msg
415: (G_PKG_NAME ,
416: l_api_name );

Line 414: FND_MSG_PUB.Add_Exc_Msg

410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
411: IF FND_MSG_PUB.Check_Msg_Level
412: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
413: THEN
414: FND_MSG_PUB.Add_Exc_Msg
415: (G_PKG_NAME ,
416: l_api_name );
417: END IF;
418: FND_MSG_PUB.Count_And_Get

Line 418: FND_MSG_PUB.Count_And_Get

414: FND_MSG_PUB.Add_Exc_Msg
415: (G_PKG_NAME ,
416: l_api_name );
417: END IF;
418: FND_MSG_PUB.Count_And_Get
419: (p_count => x_msg_count ,
420: p_data => x_msg_data ,
421: p_encoded => FND_API.G_FALSE );
422: END Update_Plan_Text;

Line 476: FND_MSG_PUB.initialize;

472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
473: END IF;
474: -- Initialize message list if p_init_msg_list is set to TRUE.
475: IF FND_API.to_Boolean( p_init_msg_list ) THEN
476: FND_MSG_PUB.initialize;
477: END IF;
478: -- Initialize API return status to success
479: x_return_status := FND_API.G_RET_STS_SUCCESS;
480: -- API body

Line 490: FND_MSG_PUB.Count_And_Get

486: IF FND_API.To_Boolean( p_commit ) THEN
487: COMMIT WORK;
488: END IF;
489: -- Standard call to get message count and if count is 1, get message info.
490: FND_MSG_PUB.Count_And_Get
491: (p_count => x_msg_count ,
492: p_data => x_msg_data ,
493: p_encoded => FND_API.G_FALSE );
494: EXCEPTION

Line 498: FND_MSG_PUB.Count_And_Get

494: EXCEPTION
495: WHEN FND_API.G_EXC_ERROR THEN
496: ROLLBACK TO Delete_Plan_Text;
497: x_return_status := FND_API.G_RET_STS_ERROR ;
498: FND_MSG_PUB.Count_And_Get
499: (p_count => x_msg_count ,
500: p_data => x_msg_data ,
501: p_encoded => FND_API.G_FALSE );
502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 505: FND_MSG_PUB.Count_And_Get

501: p_encoded => FND_API.G_FALSE );
502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
503: ROLLBACK TO Delete_Plan_Text;
504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
505: FND_MSG_PUB.Count_And_Get
506: (p_count => x_msg_count ,
507: p_data => x_msg_data ,
508: p_encoded => FND_API.G_FALSE );
509: WHEN OTHERS THEN

Line 512: IF FND_MSG_PUB.Check_Msg_Level

508: p_encoded => FND_API.G_FALSE );
509: WHEN OTHERS THEN
510: ROLLBACK TO Delete_Plan_Text;
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
512: IF FND_MSG_PUB.Check_Msg_Level
513: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
514: THEN
515: FND_MSG_PUB.Add_Exc_Msg
516: (G_PKG_NAME ,

Line 513: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

509: WHEN OTHERS THEN
510: ROLLBACK TO Delete_Plan_Text;
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
512: IF FND_MSG_PUB.Check_Msg_Level
513: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
514: THEN
515: FND_MSG_PUB.Add_Exc_Msg
516: (G_PKG_NAME ,
517: l_api_name );

Line 515: FND_MSG_PUB.Add_Exc_Msg

511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
512: IF FND_MSG_PUB.Check_Msg_Level
513: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
514: THEN
515: FND_MSG_PUB.Add_Exc_Msg
516: (G_PKG_NAME ,
517: l_api_name );
518: END IF;
519: FND_MSG_PUB.Count_And_Get

Line 519: FND_MSG_PUB.Count_And_Get

515: FND_MSG_PUB.Add_Exc_Msg
516: (G_PKG_NAME ,
517: l_api_name );
518: END IF;
519: FND_MSG_PUB.Count_And_Get
520: (p_count => x_msg_count ,
521: p_data => x_msg_data ,
522: p_encoded => FND_API.G_FALSE );
523: END Delete_Plan_Text;

Line 617: FND_MSG_PUB.initialize;

613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
614: END IF;
615: -- Initialize message list if p_init_msg_list is set to TRUE.
616: IF FND_API.to_Boolean( p_init_msg_list ) THEN
617: FND_MSG_PUB.initialize;
618: END IF;
619: -- Initialize API return status to success
620: x_return_status := FND_API.G_RET_STS_SUCCESS;
621: -- API body

Line 713: FND_MSG_PUB.Count_And_Get

709: IF FND_API.To_Boolean( p_commit ) THEN
710: COMMIT WORK;
711: END IF;
712: -- Standard call to get message count and if count is 1, get message info.
713: FND_MSG_PUB.Count_And_Get
714: (p_count => x_msg_count ,
715: p_data => x_msg_data ,
716: p_encoded => FND_API.G_FALSE );
717: EXCEPTION

Line 721: FND_MSG_PUB.Count_And_Get

717: EXCEPTION
718: WHEN FND_API.G_EXC_ERROR THEN
719: ROLLBACK TO Get_Plan_Texts;
720: x_return_status := FND_API.G_RET_STS_ERROR ;
721: FND_MSG_PUB.Count_And_Get
722: (p_count => x_msg_count ,
723: p_data => x_msg_data ,
724: p_encoded => FND_API.G_FALSE );
725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 728: FND_MSG_PUB.Count_And_Get

724: p_encoded => FND_API.G_FALSE );
725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
726: ROLLBACK TO Get_Plan_Texts;
727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
728: FND_MSG_PUB.Count_And_Get
729: (p_count => x_msg_count ,
730: p_data => x_msg_data ,
731: p_encoded => FND_API.G_FALSE );
732: WHEN OTHERS THEN

Line 735: IF FND_MSG_PUB.Check_Msg_Level

731: p_encoded => FND_API.G_FALSE );
732: WHEN OTHERS THEN
733: ROLLBACK TO Get_Plan_Texts;
734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
735: IF FND_MSG_PUB.Check_Msg_Level
736: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
737: THEN
738: FND_MSG_PUB.Add_Exc_Msg
739: (G_PKG_NAME ,

Line 736: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

732: WHEN OTHERS THEN
733: ROLLBACK TO Get_Plan_Texts;
734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
735: IF FND_MSG_PUB.Check_Msg_Level
736: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
737: THEN
738: FND_MSG_PUB.Add_Exc_Msg
739: (G_PKG_NAME ,
740: l_api_name );

Line 738: FND_MSG_PUB.Add_Exc_Msg

734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
735: IF FND_MSG_PUB.Check_Msg_Level
736: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
737: THEN
738: FND_MSG_PUB.Add_Exc_Msg
739: (G_PKG_NAME ,
740: l_api_name );
741: END IF;
742: FND_MSG_PUB.Count_And_Get

Line 742: FND_MSG_PUB.Count_And_Get

738: FND_MSG_PUB.Add_Exc_Msg
739: (G_PKG_NAME ,
740: l_api_name );
741: END IF;
742: FND_MSG_PUB.Count_And_Get
743: (p_count => x_msg_count ,
744: p_data => x_msg_data ,
745: p_encoded => FND_API.G_FALSE );
746: END Get_Plan_Texts;

Line 818: FND_MSG_PUB.initialize;

814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
815: END IF;
816: -- Initialize message list if p_init_msg_list is set to TRUE.
817: IF FND_API.to_Boolean( p_init_msg_list ) THEN
818: FND_MSG_PUB.initialize;
819: END IF;
820: -- Initialize API return status to success
821: x_return_status := FND_API.G_RET_STS_SUCCESS;
822: -- API body

Line 849: FND_MSG_PUB.Count_And_Get

845: IF FND_API.To_Boolean( p_commit ) THEN
846: COMMIT WORK;
847: END IF;
848: -- Standard call to get message count and if count is 1, get message info.
849: FND_MSG_PUB.Count_And_Get
850: (p_count => x_msg_count ,
851: p_data => x_msg_data ,
852: p_encoded => FND_API.G_FALSE );
853: EXCEPTION

Line 857: FND_MSG_PUB.Count_And_Get

853: EXCEPTION
854: WHEN FND_API.G_EXC_ERROR THEN
855: ROLLBACK TO Get_Fixed_Quota_Cates;
856: x_return_status := FND_API.G_RET_STS_ERROR ;
857: FND_MSG_PUB.Count_And_Get
858: (p_count => x_msg_count ,
859: p_data => x_msg_data ,
860: p_encoded => FND_API.G_FALSE );
861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 864: FND_MSG_PUB.Count_And_Get

860: p_encoded => FND_API.G_FALSE );
861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
862: ROLLBACK TO Get_Fixed_Quota_Cates;
863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
864: FND_MSG_PUB.Count_And_Get
865: (p_count => x_msg_count ,
866: p_data => x_msg_data ,
867: p_encoded => FND_API.G_FALSE );
868: WHEN OTHERS THEN

Line 871: IF FND_MSG_PUB.Check_Msg_Level

867: p_encoded => FND_API.G_FALSE );
868: WHEN OTHERS THEN
869: ROLLBACK TO Get_Fixed_Quota_Cates;
870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
871: IF FND_MSG_PUB.Check_Msg_Level
872: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
873: THEN
874: FND_MSG_PUB.Add_Exc_Msg
875: (G_PKG_NAME ,

Line 872: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

868: WHEN OTHERS THEN
869: ROLLBACK TO Get_Fixed_Quota_Cates;
870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
871: IF FND_MSG_PUB.Check_Msg_Level
872: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
873: THEN
874: FND_MSG_PUB.Add_Exc_Msg
875: (G_PKG_NAME ,
876: l_api_name );

Line 874: FND_MSG_PUB.Add_Exc_Msg

870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
871: IF FND_MSG_PUB.Check_Msg_Level
872: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
873: THEN
874: FND_MSG_PUB.Add_Exc_Msg
875: (G_PKG_NAME ,
876: l_api_name );
877: END IF;
878: FND_MSG_PUB.Count_And_Get

Line 878: FND_MSG_PUB.Count_And_Get

874: FND_MSG_PUB.Add_Exc_Msg
875: (G_PKG_NAME ,
876: l_api_name );
877: END IF;
878: FND_MSG_PUB.Count_And_Get
879: (p_count => x_msg_count ,
880: p_data => x_msg_data ,
881: p_encoded => FND_API.G_FALSE );
882: END Get_Fixed_Quota_Cates;

Line 954: FND_MSG_PUB.initialize;

950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
951: END IF;
952: -- Initialize message list if p_init_msg_list is set to TRUE.
953: IF FND_API.to_Boolean( p_init_msg_list ) THEN
954: FND_MSG_PUB.initialize;
955: END IF;
956: -- Initialize API return status to success
957: x_return_status := FND_API.G_RET_STS_SUCCESS;
958: -- API body

Line 994: FND_MSG_PUB.Count_And_Get

990: IF FND_API.To_Boolean( p_commit ) THEN
991: COMMIT WORK;
992: END IF;
993: -- Standard call to get message count and if count is 1, get message info.
994: FND_MSG_PUB.Count_And_Get
995: (p_count => x_msg_count ,
996: p_data => x_msg_data ,
997: p_encoded => FND_API.G_FALSE );
998: EXCEPTION

Line 1002: FND_MSG_PUB.Count_And_Get

998: EXCEPTION
999: WHEN FND_API.G_EXC_ERROR THEN
1000: ROLLBACK TO Get_Var_Quota_Cates;
1001: x_return_status := FND_API.G_RET_STS_ERROR ;
1002: FND_MSG_PUB.Count_And_Get
1003: (p_count => x_msg_count ,
1004: p_data => x_msg_data ,
1005: p_encoded => FND_API.G_FALSE );
1006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1009: FND_MSG_PUB.Count_And_Get

1005: p_encoded => FND_API.G_FALSE );
1006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1007: ROLLBACK TO Get_Var_Quota_Cates;
1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1009: FND_MSG_PUB.Count_And_Get
1010: (p_count => x_msg_count ,
1011: p_data => x_msg_data ,
1012: p_encoded => FND_API.G_FALSE );
1013: WHEN OTHERS THEN

Line 1016: IF FND_MSG_PUB.Check_Msg_Level

1012: p_encoded => FND_API.G_FALSE );
1013: WHEN OTHERS THEN
1014: ROLLBACK TO Get_Var_Quota_Cates;
1015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1016: IF FND_MSG_PUB.Check_Msg_Level
1017: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1018: THEN
1019: FND_MSG_PUB.Add_Exc_Msg
1020: (G_PKG_NAME ,

Line 1017: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1013: WHEN OTHERS THEN
1014: ROLLBACK TO Get_Var_Quota_Cates;
1015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1016: IF FND_MSG_PUB.Check_Msg_Level
1017: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1018: THEN
1019: FND_MSG_PUB.Add_Exc_Msg
1020: (G_PKG_NAME ,
1021: l_api_name );

Line 1019: FND_MSG_PUB.Add_Exc_Msg

1015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1016: IF FND_MSG_PUB.Check_Msg_Level
1017: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1018: THEN
1019: FND_MSG_PUB.Add_Exc_Msg
1020: (G_PKG_NAME ,
1021: l_api_name );
1022: END IF;
1023: FND_MSG_PUB.Count_And_Get

Line 1023: FND_MSG_PUB.Count_And_Get

1019: FND_MSG_PUB.Add_Exc_Msg
1020: (G_PKG_NAME ,
1021: l_api_name );
1022: END IF;
1023: FND_MSG_PUB.Count_And_Get
1024: (p_count => x_msg_count ,
1025: p_data => x_msg_data ,
1026: p_encoded => FND_API.G_FALSE );
1027: END Get_Var_Quota_Cates;

Line 1103: FND_MSG_PUB.initialize;

1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1100: END IF;
1101: -- Initialize message list if p_init_msg_list is set to TRUE.
1102: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1103: FND_MSG_PUB.initialize;
1104: END IF;
1105: -- Initialize API return status to success
1106: x_return_status := FND_API.G_RET_STS_SUCCESS;
1107: -- API body

Line 1145: FND_MSG_PUB.Count_And_Get

1141: IF FND_API.To_Boolean( p_commit ) THEN
1142: COMMIT WORK;
1143: END IF;
1144: -- Standard call to get message count and if count is 1, get message info.
1145: FND_MSG_PUB.Count_And_Get
1146: (p_count => x_msg_count ,
1147: p_data => x_msg_data ,
1148: p_encoded => FND_API.G_FALSE );
1149: EXCEPTION

Line 1153: FND_MSG_PUB.Count_And_Get

1149: EXCEPTION
1150: WHEN FND_API.G_EXC_ERROR THEN
1151: ROLLBACK TO Get_Quota_Cates;
1152: x_return_status := FND_API.G_RET_STS_ERROR ;
1153: FND_MSG_PUB.Count_And_Get
1154: (p_count => x_msg_count ,
1155: p_data => x_msg_data ,
1156: p_encoded => FND_API.G_FALSE );
1157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1160: FND_MSG_PUB.Count_And_Get

1156: p_encoded => FND_API.G_FALSE );
1157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1158: ROLLBACK TO Get_Quota_Cates;
1159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1160: FND_MSG_PUB.Count_And_Get
1161: (p_count => x_msg_count ,
1162: p_data => x_msg_data ,
1163: p_encoded => FND_API.G_FALSE );
1164: WHEN OTHERS THEN

Line 1167: IF FND_MSG_PUB.Check_Msg_Level

1163: p_encoded => FND_API.G_FALSE );
1164: WHEN OTHERS THEN
1165: ROLLBACK TO Get_Quota_Cates;
1166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1167: IF FND_MSG_PUB.Check_Msg_Level
1168: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1169: THEN
1170: FND_MSG_PUB.Add_Exc_Msg
1171: (G_PKG_NAME ,

Line 1168: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1164: WHEN OTHERS THEN
1165: ROLLBACK TO Get_Quota_Cates;
1166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1167: IF FND_MSG_PUB.Check_Msg_Level
1168: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1169: THEN
1170: FND_MSG_PUB.Add_Exc_Msg
1171: (G_PKG_NAME ,
1172: l_api_name );

Line 1170: FND_MSG_PUB.Add_Exc_Msg

1166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1167: IF FND_MSG_PUB.Check_Msg_Level
1168: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1169: THEN
1170: FND_MSG_PUB.Add_Exc_Msg
1171: (G_PKG_NAME ,
1172: l_api_name );
1173: END IF;
1174: FND_MSG_PUB.Count_And_Get

Line 1174: FND_MSG_PUB.Count_And_Get

1170: FND_MSG_PUB.Add_Exc_Msg
1171: (G_PKG_NAME ,
1172: l_api_name );
1173: END IF;
1174: FND_MSG_PUB.Count_And_Get
1175: (p_count => x_msg_count ,
1176: p_data => x_msg_data ,
1177: p_encoded => FND_API.G_FALSE );
1178: END Get_Quota_Cates;

Line 1234: FND_MSG_PUB.initialize;

1230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1231: END IF;
1232: -- Initialize message list if p_init_msg_list is set to TRUE.
1233: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1234: FND_MSG_PUB.initialize;
1235: END IF;
1236: -- Initialize API return status to success
1237: x_return_status := FND_API.G_RET_STS_SUCCESS;
1238: -- API body

Line 1256: FND_MSG_PUB.Count_And_Get

1252: IF FND_API.To_Boolean( p_commit ) THEN
1253: COMMIT WORK;
1254: END IF;
1255: -- Standard call to get message count and if count is 1, get message info.
1256: FND_MSG_PUB.Count_And_Get
1257: (p_count => x_msg_count ,
1258: p_data => x_msg_data ,
1259: p_encoded => FND_API.G_FALSE );
1260: EXCEPTION

Line 1264: FND_MSG_PUB.Count_And_Get

1260: EXCEPTION
1261: WHEN FND_API.G_EXC_ERROR THEN
1262: ROLLBACK TO Get_Role_Name;
1263: x_return_status := FND_API.G_RET_STS_ERROR ;
1264: FND_MSG_PUB.Count_And_Get
1265: (p_count => x_msg_count ,
1266: p_data => x_msg_data ,
1267: p_encoded => FND_API.G_FALSE );
1268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1271: FND_MSG_PUB.Count_And_Get

1267: p_encoded => FND_API.G_FALSE );
1268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1269: ROLLBACK TO Get_Role_Name;
1270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1271: FND_MSG_PUB.Count_And_Get
1272: (p_count => x_msg_count ,
1273: p_data => x_msg_data ,
1274: p_encoded => FND_API.G_FALSE );
1275: WHEN OTHERS THEN

Line 1278: IF FND_MSG_PUB.Check_Msg_Level

1274: p_encoded => FND_API.G_FALSE );
1275: WHEN OTHERS THEN
1276: ROLLBACK TO Get_Role_Name;
1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1278: IF FND_MSG_PUB.Check_Msg_Level
1279: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1280: THEN
1281: FND_MSG_PUB.Add_Exc_Msg
1282: (G_PKG_NAME ,

Line 1279: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1275: WHEN OTHERS THEN
1276: ROLLBACK TO Get_Role_Name;
1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1278: IF FND_MSG_PUB.Check_Msg_Level
1279: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1280: THEN
1281: FND_MSG_PUB.Add_Exc_Msg
1282: (G_PKG_NAME ,
1283: l_api_name );

Line 1281: FND_MSG_PUB.Add_Exc_Msg

1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1278: IF FND_MSG_PUB.Check_Msg_Level
1279: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1280: THEN
1281: FND_MSG_PUB.Add_Exc_Msg
1282: (G_PKG_NAME ,
1283: l_api_name );
1284: END IF;
1285: FND_MSG_PUB.Count_And_Get

Line 1285: FND_MSG_PUB.Count_And_Get

1281: FND_MSG_PUB.Add_Exc_Msg
1282: (G_PKG_NAME ,
1283: l_api_name );
1284: END IF;
1285: FND_MSG_PUB.Count_And_Get
1286: (p_count => x_msg_count ,
1287: p_data => x_msg_data ,
1288: p_encoded => FND_API.G_FALSE );
1289: END Get_Role_Name;