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.IEM_ROUTE_CLASS_PVT dependencies on FND_MSG_PUB

Line 77: FND_MSG_PUB.initialize;

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

Line 97: FND_MSG_PUB.Count_And_Get

93:
94: WHEN FND_API.G_EXC_ERROR THEN
95: ROLLBACK TO getRouteClassifications;
96: x_return_status := FND_API.G_RET_STS_ERROR ;
97: FND_MSG_PUB.Count_And_Get
98:
99: ( p_count => x_msg_count,p_data => x_msg_data);
100:
101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 106: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);

102: ROLLBACK TO getRouteClassifications;
103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
104:
105:
106: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
107:
108: WHEN OTHERS THEN
109: ROLLBACK TO getRouteClassifications;
110: x_return_status := FND_API.G_RET_STS_ERROR;

Line 111: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

107:
108: WHEN OTHERS THEN
109: ROLLBACK TO getRouteClassifications;
110: x_return_status := FND_API.G_RET_STS_ERROR;
111: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
112:
113: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
114: END IF;
115: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

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

109: ROLLBACK TO getRouteClassifications;
110: x_return_status := FND_API.G_RET_STS_ERROR;
111: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
112:
113: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
114: END IF;
115: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
116: END;
117:

Line 115: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

111: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
112:
113: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
114: END IF;
115: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
116: END;
117:
118:
119: PROCEDURE delete_item_batch

Line 171: FND_MSG_PUB.initialize;

167:
168: --Initialize the message list if p_init_msg_list is set to TRUE
169:
170: If FND_API.to_Boolean(p_init_msg_list) THEN
171: FND_MSG_PUB.initialize;
172: END IF;
173:
174: --Initialize API status return
175: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 258: FND_MSG_PUB.ADD;

254: l_undeleted_class_name := RTRIM(l_undeleted_class_name, ', ');
255: x_return_status := FND_API.G_RET_STS_ERROR;
256: FND_MESSAGE.SET_NAME('IEM', 'IEM_RT_CLASS_FAILED_DEL_CLASS');
257: FND_MESSAGE.SET_TOKEN('CLASSIFICATION', l_undeleted_class_name);
258: FND_MSG_PUB.ADD;
259: end if;
260:
261:
262: --Standard check of p_commit

Line 267: FND_MSG_PUB.Count_And_Get

263: IF FND_API.to_Boolean(p_commit) THEN
264: COMMIT WORK;
265: END IF;
266:
267: FND_MSG_PUB.Count_And_Get
268: ( p_count => x_msg_count,
269: p_data => x_msg_data
270: );
271:

Line 280: --FND_MSG_PUB.ADD;

276: --WHEN IEM_UNEXPT_ERR_DELETE_FOLDER THEN
277: -- ROLLBACK TO delete_item_batch;
278: -- x_return_status := FND_API.G_RET_STS_ERROR;
279: --FND_MESSAGE.SET_NAME('IEM', 'IEM_UNEXPT_ERR_DELETE_FOLDER');
280: --FND_MSG_PUB.ADD;
281: -- FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
282:
283:
284: WHEN FND_API.G_EXC_ERROR THEN

Line 281: -- FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

277: -- ROLLBACK TO delete_item_batch;
278: -- x_return_status := FND_API.G_RET_STS_ERROR;
279: --FND_MESSAGE.SET_NAME('IEM', 'IEM_UNEXPT_ERR_DELETE_FOLDER');
280: --FND_MSG_PUB.ADD;
281: -- FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
282:
283:
284: WHEN FND_API.G_EXC_ERROR THEN
285: ROLLBACK TO delete_item_batch;

Line 288: FND_MSG_PUB.Count_And_Get

284: WHEN FND_API.G_EXC_ERROR THEN
285: ROLLBACK TO delete_item_batch;
286: x_return_status := FND_API.G_RET_STS_ERROR ;
287:
288: FND_MSG_PUB.Count_And_Get
289: ( p_count => x_msg_count,p_data => x_msg_data);
290:
291:
292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 296: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);

292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
293:
294: ROLLBACK TO delete_item_batch;
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
296: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
297:
298: WHEN OTHERS THEN
299: ROLLBACK TO delete_item_batch;
300: x_return_status := FND_API.G_RET_STS_ERROR;

Line 302: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

298: WHEN OTHERS THEN
299: ROLLBACK TO delete_item_batch;
300: x_return_status := FND_API.G_RET_STS_ERROR;
301:
302: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
303: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
304: END IF;
305:
306: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

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

299: ROLLBACK TO delete_item_batch;
300: x_return_status := FND_API.G_RET_STS_ERROR;
301:
302: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
303: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
304: END IF;
305:
306: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
307:

Line 306: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

302: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
303: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
304: END IF;
305:
306: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
307:
308: END delete_item_batch;
309:
310:

Line 369: FND_MSG_PUB.initialize;

365: -- Initialize message list if p_init_msg_list is set to TRUE.
366:
367: IF FND_API.to_Boolean( p_init_msg_list )
368: THEN
369: FND_MSG_PUB.initialize;
370: END IF;
371:
372:
373: -- Initialize API return status to SUCCESS

Line 450: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

446: EXCEPTION
447: WHEN IEM_RT_CLASS_NOT_CREATED THEN
448: ROLLBACK TO create_item_wrap;
449: x_return_status := FND_API.G_RET_STS_ERROR ;
450: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
451:
452: WHEN IEM_RT_CLASS_RULE_NOT_CREATED THEN
453: ROLLBACK TO create_item_wrap;
454: FND_MESSAGE.SET_NAME('IEM','IEM_RT_CLASS_RULE_NOT_CREATED');

Line 455: FND_MSG_PUB.Add;

451:
452: WHEN IEM_RT_CLASS_RULE_NOT_CREATED THEN
453: ROLLBACK TO create_item_wrap;
454: FND_MESSAGE.SET_NAME('IEM','IEM_RT_CLASS_RULE_NOT_CREATED');
455: FND_MSG_PUB.Add;
456: x_return_status := FND_API.G_RET_STS_ERROR ;
457: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
458:
459:

Line 457: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

453: ROLLBACK TO create_item_wrap;
454: FND_MESSAGE.SET_NAME('IEM','IEM_RT_CLASS_RULE_NOT_CREATED');
455: FND_MSG_PUB.Add;
456: x_return_status := FND_API.G_RET_STS_ERROR ;
457: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
458:
459:
460: WHEN FND_API.G_EXC_ERROR THEN
461: ROLLBACK TO create_item_wrap;

Line 463: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);

459:
460: WHEN FND_API.G_EXC_ERROR THEN
461: ROLLBACK TO create_item_wrap;
462: x_return_status := FND_API.G_RET_STS_ERROR ;
463: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);
464:
465:
466:
467:

Line 471: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

467:
468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
469: ROLLBACK TO create_item_wrap;
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
471: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
472:
473: WHEN OTHERS THEN
474: ROLLBACK TO create_item_wrap;
475: x_return_status := FND_API.G_RET_STS_ERROR;

Line 476: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

472:
473: WHEN OTHERS THEN
474: ROLLBACK TO create_item_wrap;
475: x_return_status := FND_API.G_RET_STS_ERROR;
476: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
477: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
478: END IF;
479:
480: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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

473: WHEN OTHERS THEN
474: ROLLBACK TO create_item_wrap;
475: x_return_status := FND_API.G_RET_STS_ERROR;
476: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
477: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
478: END IF;
479:
480: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
481:

Line 480: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

476: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
477: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
478: END IF;
479:
480: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
481:
482:
483:
484: END create_item_wrap;

Line 532: FND_MSG_PUB.initialize;

528: -- Initialize message list if p_init_msg_list is set to TRUE.
529:
530: IF FND_API.to_Boolean( p_init_msg_list )
531: THEN
532: FND_MSG_PUB.initialize;
533:
534: END IF;
535:
536: -- Initialize API return status to SUCCESS

Line 670: FND_MSG_PUB.Count_And_Get

666: COMMIT WORK;
667: END IF;
668:
669: -- Standard callto get message count and if count is 1, get message info.
670: FND_MSG_PUB.Count_And_Get
671: ( p_count => x_msg_count,
672: p_data => x_msg_data
673: );
674:

Line 680: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

676: EXCEPTION
677: WHEN l_IEM_INVALID_PROCEDURE THEN
678: ROLLBACK TO create_item_class_PVT;
679: x_return_status := FND_API.G_RET_STS_ERROR ;
680: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
681:
682: WHEN IEM_RT_CLASS_DUP_NAME THEN
683: ROLLBACK TO create_item_class_PVT;
684: FND_MESSAGE.SET_NAME('IEM','IEM_RT_CLASS_DUP_NAME');

Line 685: FND_MSG_PUB.Add;

681:
682: WHEN IEM_RT_CLASS_DUP_NAME THEN
683: ROLLBACK TO create_item_class_PVT;
684: FND_MESSAGE.SET_NAME('IEM','IEM_RT_CLASS_DUP_NAME');
685: FND_MSG_PUB.Add;
686: x_return_status := FND_API.G_RET_STS_ERROR ;
687: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
688:
689: WHEN IEM_ADM_NO_PROCEDURE_NAME THEN

Line 687: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

683: ROLLBACK TO create_item_class_PVT;
684: FND_MESSAGE.SET_NAME('IEM','IEM_RT_CLASS_DUP_NAME');
685: FND_MSG_PUB.Add;
686: x_return_status := FND_API.G_RET_STS_ERROR ;
687: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
688:
689: WHEN IEM_ADM_NO_PROCEDURE_NAME THEN
690: ROLLBACK TO create_item_routes_PVT;
691: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_NO_PROCEDURE_NAME');

Line 692: FND_MSG_PUB.Add;

688:
689: WHEN IEM_ADM_NO_PROCEDURE_NAME THEN
690: ROLLBACK TO create_item_routes_PVT;
691: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_NO_PROCEDURE_NAME');
692: FND_MSG_PUB.Add;
693: x_return_status := FND_API.G_RET_STS_ERROR ;
694: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
695:
696: WHEN FND_API.G_EXC_ERROR THEN

Line 694: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

690: ROLLBACK TO create_item_routes_PVT;
691: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_NO_PROCEDURE_NAME');
692: FND_MSG_PUB.Add;
693: x_return_status := FND_API.G_RET_STS_ERROR ;
694: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
695:
696: WHEN FND_API.G_EXC_ERROR THEN
697: ROLLBACK TO create_item_class_PVT;
698: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 700: FND_MSG_PUB.Count_And_Get

696: WHEN FND_API.G_EXC_ERROR THEN
697: ROLLBACK TO create_item_class_PVT;
698: x_return_status := FND_API.G_RET_STS_ERROR ;
699:
700: FND_MSG_PUB.Count_And_Get
701:
702:
703: ( p_count => x_msg_count,
704: p_data => x_msg_data

Line 710: FND_MSG_PUB.Count_And_Get

706:
707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
708: ROLLBACK TO create_item_class_PVT;
709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
710: FND_MSG_PUB.Count_And_Get
711: ( p_count => x_msg_count,
712: p_data => x_msg_data
713: );
714:

Line 721: IF FND_MSG_PUB.Check_Msg_Level

717:
718: WHEN OTHERS THEN
719: ROLLBACK TO create_item_class_PVT;
720: x_return_status := FND_API.G_RET_STS_ERROR;
721: IF FND_MSG_PUB.Check_Msg_Level
722: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
723: THEN
724: FND_MSG_PUB.Add_Exc_Msg
725: ( G_PKG_NAME ,

Line 722: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

718: WHEN OTHERS THEN
719: ROLLBACK TO create_item_class_PVT;
720: x_return_status := FND_API.G_RET_STS_ERROR;
721: IF FND_MSG_PUB.Check_Msg_Level
722: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
723: THEN
724: FND_MSG_PUB.Add_Exc_Msg
725: ( G_PKG_NAME ,
726: l_api_name

Line 724: FND_MSG_PUB.Add_Exc_Msg

720: x_return_status := FND_API.G_RET_STS_ERROR;
721: IF FND_MSG_PUB.Check_Msg_Level
722: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
723: THEN
724: FND_MSG_PUB.Add_Exc_Msg
725: ( G_PKG_NAME ,
726: l_api_name
727: );
728: END IF;

Line 730: FND_MSG_PUB.Count_And_Get

726: l_api_name
727: );
728: END IF;
729:
730: FND_MSG_PUB.Count_And_Get
731: ( p_count => x_msg_count,
732:
733:
734: p_data => x_msg_data

Line 779: FND_MSG_PUB.initialize;

775: -- Initialize message list if p_init_msg_list is set to TRUE.
776:
777: IF FND_API.to_Boolean( p_init_msg_list )
778: THEN
779: FND_MSG_PUB.initialize;
780:
781: END IF;
782:
783: -- Initialize API return status to SUCCESS

Line 894: FND_MSG_PUB.Count_And_Get

890: END IF;
891:
892: -- Standard callto get message count and if count is 1, get message info.
893:
894: FND_MSG_PUB.Count_And_Get
895: ( p_count => x_msg_count,
896: p_data => x_msg_data
897: );
898:

Line 907: FND_MSG_PUB.Count_And_Get

903: ROLLBACK TO create_item_class_rules_PVT;
904: x_return_status := FND_API.G_RET_STS_ERROR ;
905:
906:
907: FND_MSG_PUB.Count_And_Get
908:
909: ( p_count => x_msg_count,
910: p_data => x_msg_data
911: );

Line 916: FND_MSG_PUB.Count_And_Get

912:
913: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
914: ROLLBACK TO create_item_class_rules_PVT;
915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
916: FND_MSG_PUB.Count_And_Get
917: ( p_count => x_msg_count,
918: p_data => x_msg_data
919: );
920:

Line 927: IF FND_MSG_PUB.Check_Msg_Level

923:
924: WHEN OTHERS THEN
925: ROLLBACK TO create_item_class_rules_PVT;
926: x_return_status := FND_API.G_RET_STS_ERROR;
927: IF FND_MSG_PUB.Check_Msg_Level
928: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
929: THEN
930: FND_MSG_PUB.Add_Exc_Msg
931: ( G_PKG_NAME ,

Line 928: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

924: WHEN OTHERS THEN
925: ROLLBACK TO create_item_class_rules_PVT;
926: x_return_status := FND_API.G_RET_STS_ERROR;
927: IF FND_MSG_PUB.Check_Msg_Level
928: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
929: THEN
930: FND_MSG_PUB.Add_Exc_Msg
931: ( G_PKG_NAME ,
932: l_api_name

Line 930: FND_MSG_PUB.Add_Exc_Msg

926: x_return_status := FND_API.G_RET_STS_ERROR;
927: IF FND_MSG_PUB.Check_Msg_Level
928: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
929: THEN
930: FND_MSG_PUB.Add_Exc_Msg
931: ( G_PKG_NAME ,
932: l_api_name
933: );
934:

Line 936: FND_MSG_PUB.Count_And_Get

932: l_api_name
933: );
934:
935: END IF;
936: FND_MSG_PUB.Count_And_Get
937: ( p_count => x_msg_count ,
938:
939:
940: p_data => x_msg_data

Line 1006: FND_MSG_PUB.initialize;

1002: -- Initialize message list if p_init_msg_list is set to TRUE.
1003: IF FND_API.to_Boolean( p_init_msg_list )
1004:
1005: THEN
1006: FND_MSG_PUB.initialize;
1007: END IF;
1008:
1009:
1010: -- Initialize API return status to SUCCESS

Line 1147: FND_MSG_PUB.Add;

1143: ROLLBACK TO update_item_wrap;
1144:
1145:
1146: FND_MESSAGE.SET_NAME('IEM','IEM_NO_RT_CLASS_UPDATE');
1147: FND_MSG_PUB.Add;
1148: x_return_status := FND_API.G_RET_STS_ERROR ;
1149: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1150:
1151: WHEN IEM_NO_RULE_UPDATE THEN

Line 1149: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1145:
1146: FND_MESSAGE.SET_NAME('IEM','IEM_NO_RT_CLASS_UPDATE');
1147: FND_MSG_PUB.Add;
1148: x_return_status := FND_API.G_RET_STS_ERROR ;
1149: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1150:
1151: WHEN IEM_NO_RULE_UPDATE THEN
1152: ROLLBACK TO update_item_wrap;
1153:

Line 1155: FND_MSG_PUB.Add;

1151: WHEN IEM_NO_RULE_UPDATE THEN
1152: ROLLBACK TO update_item_wrap;
1153:
1154: FND_MESSAGE.SET_NAME('IEM','IEM_NO_RULE_UPDATE');
1155: FND_MSG_PUB.Add;
1156: x_return_status := FND_API.G_RET_STS_ERROR ;
1157: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1158:
1159:

Line 1157: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1153:
1154: FND_MESSAGE.SET_NAME('IEM','IEM_NO_RULE_UPDATE');
1155: FND_MSG_PUB.Add;
1156: x_return_status := FND_API.G_RET_STS_ERROR ;
1157: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1158:
1159:
1160: WHEN IEM_RULE_NOT_DELETED THEN
1161:

Line 1164: FND_MSG_PUB.Add;

1160: WHEN IEM_RULE_NOT_DELETED THEN
1161:
1162: ROLLBACK TO update_item_wrap;
1163: FND_MESSAGE.SET_NAME('IEM','IEM_RULE_NOT_DELETED');
1164: FND_MSG_PUB.Add;
1165: x_return_status := FND_API.G_RET_STS_ERROR ;
1166: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1167:
1168:

Line 1166: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1162: ROLLBACK TO update_item_wrap;
1163: FND_MESSAGE.SET_NAME('IEM','IEM_RULE_NOT_DELETED');
1164: FND_MSG_PUB.Add;
1165: x_return_status := FND_API.G_RET_STS_ERROR ;
1166: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1167:
1168:
1169: WHEN IEM_RT_CLS_RULE_NOT_CREATED THEN
1170: ROLLBACK TO update_item_wrap;

Line 1172: FND_MSG_PUB.Add;

1168:
1169: WHEN IEM_RT_CLS_RULE_NOT_CREATED THEN
1170: ROLLBACK TO update_item_wrap;
1171: FND_MESSAGE.SET_NAME('IEM','IEM_RT_CLS_RULE_NOT_CREATED');
1172: FND_MSG_PUB.Add;
1173: x_return_status := FND_API.G_RET_STS_ERROR ;
1174:
1175: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1176:

Line 1175: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1171: FND_MESSAGE.SET_NAME('IEM','IEM_RT_CLS_RULE_NOT_CREATED');
1172: FND_MSG_PUB.Add;
1173: x_return_status := FND_API.G_RET_STS_ERROR ;
1174:
1175: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1176:
1177:
1178: WHEN IEM_RT_CLS_NO_RULE THEN
1179: ROLLBACK TO update_item_wrap;

Line 1182: FND_MSG_PUB.Add;

1178: WHEN IEM_RT_CLS_NO_RULE THEN
1179: ROLLBACK TO update_item_wrap;
1180: FND_MESSAGE.SET_NAME('IEM','IEM_RT_CLS_NO_RULE');
1181:
1182: FND_MSG_PUB.Add;
1183: x_return_status := FND_API.G_RET_STS_ERROR ;
1184: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1185:
1186: WHEN FND_API.G_EXC_ERROR THEN

Line 1184: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1180: FND_MESSAGE.SET_NAME('IEM','IEM_RT_CLS_NO_RULE');
1181:
1182: FND_MSG_PUB.Add;
1183: x_return_status := FND_API.G_RET_STS_ERROR ;
1184: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1185:
1186: WHEN FND_API.G_EXC_ERROR THEN
1187: ROLLBACK TO update_item_wrap;
1188: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1190: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);

1186: WHEN FND_API.G_EXC_ERROR THEN
1187: ROLLBACK TO update_item_wrap;
1188: x_return_status := FND_API.G_RET_STS_ERROR ;
1189:
1190: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);
1191:
1192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1193:
1194: ROLLBACK TO update_item_wrap;

Line 1197: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1193:
1194: ROLLBACK TO update_item_wrap;
1195:
1196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1197: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1198:
1199: WHEN OTHERS THEN
1200: ROLLBACK TO update_item_wrap;
1201: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1202: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1198:
1199: WHEN OTHERS THEN
1200: ROLLBACK TO update_item_wrap;
1201: x_return_status := FND_API.G_RET_STS_ERROR;
1202: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1203: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
1204:
1205: END IF;
1206:

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

1199: WHEN OTHERS THEN
1200: ROLLBACK TO update_item_wrap;
1201: x_return_status := FND_API.G_RET_STS_ERROR;
1202: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1203: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
1204:
1205: END IF;
1206:
1207: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 1207: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

1203: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
1204:
1205: END IF;
1206:
1207: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1208:
1209:
1210:
1211: END update_item_wrap;

Line 1259: FND_MSG_PUB.initialize;

1255:
1256: -- Initialize message list if p_init_msg_list is set to TRUE.
1257: IF FND_API.to_Boolean( p_init_msg_list )
1258: THEN
1259: FND_MSG_PUB.initialize;
1260: END IF;
1261:
1262:
1263: -- Initialize API return status to SUCCESS

Line 1339: FND_MSG_PUB.Count_And_Get

1335: END IF;
1336:
1337: -- Standard callto get message count and if count is 1, get message info.
1338:
1339: FND_MSG_PUB.Count_And_Get
1340: ( p_count => x_msg_count,
1341:
1342: p_data => x_msg_data
1343:

Line 1349: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1345: EXCEPTION
1346: WHEN l_IEM_INVALID_PROCEDURE THEN
1347: ROLLBACK TO update_item_class;
1348: x_return_status := FND_API.G_RET_STS_ERROR ;
1349: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1350:
1351: WHEN IEM_ADMIN_ROUTE_NO_PROC THEN
1352: ROLLBACK TO update_item_class;
1353: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NO_PROC');

Line 1354: FND_MSG_PUB.Add;

1350:
1351: WHEN IEM_ADMIN_ROUTE_NO_PROC THEN
1352: ROLLBACK TO update_item_class;
1353: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NO_PROC');
1354: FND_MSG_PUB.Add;
1355: x_return_status := FND_API.G_RET_STS_ERROR ;
1356: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1357:
1358: WHEN IEM_RT_CLASS_DUP_NAME THEN

Line 1356: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1352: ROLLBACK TO update_item_class;
1353: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NO_PROC');
1354: FND_MSG_PUB.Add;
1355: x_return_status := FND_API.G_RET_STS_ERROR ;
1356: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1357:
1358: WHEN IEM_RT_CLASS_DUP_NAME THEN
1359: ROLLBACK TO update_item_class;
1360: FND_MESSAGE.SET_NAME('IEM','IEM_RT_CLASS_DUP_NAME');

Line 1361: FND_MSG_PUB.Add;

1357:
1358: WHEN IEM_RT_CLASS_DUP_NAME THEN
1359: ROLLBACK TO update_item_class;
1360: FND_MESSAGE.SET_NAME('IEM','IEM_RT_CLASS_DUP_NAME');
1361: FND_MSG_PUB.Add;
1362: x_return_status := FND_API.G_RET_STS_ERROR ;
1363: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1364:
1365:

Line 1363: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1359: ROLLBACK TO update_item_class;
1360: FND_MESSAGE.SET_NAME('IEM','IEM_RT_CLASS_DUP_NAME');
1361: FND_MSG_PUB.Add;
1362: x_return_status := FND_API.G_RET_STS_ERROR ;
1363: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1364:
1365:
1366:
1367: WHEN FND_API.G_EXC_ERROR THEN

Line 1371: FND_MSG_PUB.Count_And_Get

1367: WHEN FND_API.G_EXC_ERROR THEN
1368: ROLLBACK TO update_item_class;
1369:
1370: x_return_status := FND_API.G_RET_STS_ERROR ;
1371: FND_MSG_PUB.Count_And_Get
1372: ( p_count => x_msg_count,
1373: p_data => x_msg_data
1374: );
1375:

Line 1379: FND_MSG_PUB.Count_And_Get

1375:
1376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1377: ROLLBACK TO update_item_class;
1378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1379: FND_MSG_PUB.Count_And_Get
1380:
1381: ( p_count => x_msg_count,
1382:
1383: p_data => x_msg_data

Line 1390: IF FND_MSG_PUB.Check_Msg_Level

1386:
1387: WHEN OTHERS THEN
1388: ROLLBACK TO update_item_class;
1389: x_return_status := FND_API.G_RET_STS_ERROR;
1390: IF FND_MSG_PUB.Check_Msg_Level
1391: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1392: THEN
1393: FND_MSG_PUB.Add_Exc_Msg
1394:

Line 1391: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1387: WHEN OTHERS THEN
1388: ROLLBACK TO update_item_class;
1389: x_return_status := FND_API.G_RET_STS_ERROR;
1390: IF FND_MSG_PUB.Check_Msg_Level
1391: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1392: THEN
1393: FND_MSG_PUB.Add_Exc_Msg
1394:
1395: ( G_PKG_NAME ,

Line 1393: FND_MSG_PUB.Add_Exc_Msg

1389: x_return_status := FND_API.G_RET_STS_ERROR;
1390: IF FND_MSG_PUB.Check_Msg_Level
1391: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1392: THEN
1393: FND_MSG_PUB.Add_Exc_Msg
1394:
1395: ( G_PKG_NAME ,
1396: l_api_name
1397: );

Line 1401: FND_MSG_PUB.Count_And_Get

1397: );
1398:
1399:
1400: END IF;
1401: FND_MSG_PUB.Count_And_Get
1402: ( p_count => x_msg_count ,
1403: p_data => x_msg_data
1404: );
1405:

Line 1450: FND_MSG_PUB.initialize;

1446: -- Initialize message list if p_init_msg_list is set to TRUE.
1447:
1448: IF FND_API.to_Boolean( p_init_msg_list )
1449: THEN
1450: FND_MSG_PUB.initialize;
1451: END IF;
1452: -- Initialize API return status to SUCCESS
1453: x_return_status := FND_API.G_RET_STS_SUCCESS;
1454:

Line 1511: FND_MSG_PUB.Count_And_Get

1507:
1508: END IF;
1509:
1510: -- Standard callto get message count and if count is 1, get message info.
1511: FND_MSG_PUB.Count_And_Get
1512: ( p_count => x_msg_count,
1513: p_data => x_msg_data
1514: );
1515:

Line 1520: FND_MSG_PUB.Add;

1516: EXCEPTION
1517: WHEN IEM_RULE_KEY_OP_VAL_NULL THEN
1518: ROLLBACK TO update_item_rule;
1519: FND_MESSAGE.SET_NAME('IEM','IEM_RULE_KEY_OP_VAL_NULL');
1520: FND_MSG_PUB.Add;
1521: x_return_status := FND_API.G_RET_STS_ERROR ;
1522: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1523:
1524: WHEN IEM_NO_RULE_UPDATE THEN

Line 1522: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1518: ROLLBACK TO update_item_rule;
1519: FND_MESSAGE.SET_NAME('IEM','IEM_RULE_KEY_OP_VAL_NULL');
1520: FND_MSG_PUB.Add;
1521: x_return_status := FND_API.G_RET_STS_ERROR ;
1522: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1523:
1524: WHEN IEM_NO_RULE_UPDATE THEN
1525: ROLLBACK TO update_item_rule;
1526: FND_MESSAGE.SET_NAME('IEM','IEM_NO_RULE_UPDATE');

Line 1527: FND_MSG_PUB.Add;

1523:
1524: WHEN IEM_NO_RULE_UPDATE THEN
1525: ROLLBACK TO update_item_rule;
1526: FND_MESSAGE.SET_NAME('IEM','IEM_NO_RULE_UPDATE');
1527: FND_MSG_PUB.Add;
1528: x_return_status := FND_API.G_RET_STS_ERROR ;
1529: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1530: /*
1531: WHEN IEM_INVALID_DATE_FORMAT THEN

Line 1529: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1525: ROLLBACK TO update_item_rule;
1526: FND_MESSAGE.SET_NAME('IEM','IEM_NO_RULE_UPDATE');
1527: FND_MSG_PUB.Add;
1528: x_return_status := FND_API.G_RET_STS_ERROR ;
1529: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1530: /*
1531: WHEN IEM_INVALID_DATE_FORMAT THEN
1532: ROLLBACK TO update_item_rule;
1533: FND_MESSAGE.SET_NAME('IEM','IEM_INVALID_DATE_FORMAT');

Line 1534: FND_MSG_PUB.Add;

1530: /*
1531: WHEN IEM_INVALID_DATE_FORMAT THEN
1532: ROLLBACK TO update_item_rule;
1533: FND_MESSAGE.SET_NAME('IEM','IEM_INVALID_DATE_FORMAT');
1534: FND_MSG_PUB.Add;
1535: x_return_status := FND_API.G_RET_STS_ERROR ;
1536:
1537: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1538: */

Line 1537: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1533: FND_MESSAGE.SET_NAME('IEM','IEM_INVALID_DATE_FORMAT');
1534: FND_MSG_PUB.Add;
1535: x_return_status := FND_API.G_RET_STS_ERROR ;
1536:
1537: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1538: */
1539: WHEN FND_API.G_EXC_ERROR THEN
1540: ROLLBACK TO update_item_rule;
1541: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1544: FND_MSG_PUB.Count_And_Get

1540: ROLLBACK TO update_item_rule;
1541: x_return_status := FND_API.G_RET_STS_ERROR ;
1542:
1543:
1544: FND_MSG_PUB.Count_And_Get
1545: ( p_count => x_msg_count,
1546: p_data => x_msg_data
1547: );
1548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1551: FND_MSG_PUB.Count_And_Get

1547: );
1548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1549: ROLLBACK TO update_item_rule;
1550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1551: FND_MSG_PUB.Count_And_Get
1552:
1553: ( p_count => x_msg_count,
1554: p_data => x_msg_data
1555: );

Line 1561: IF FND_MSG_PUB.Check_Msg_Level

1557: WHEN OTHERS THEN
1558:
1559: ROLLBACK TO update_item_rule;
1560: x_return_status := FND_API.G_RET_STS_ERROR;
1561: IF FND_MSG_PUB.Check_Msg_Level
1562: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1563: THEN
1564: FND_MSG_PUB.Add_Exc_Msg
1565: ( G_PKG_NAME ,

Line 1562: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1558:
1559: ROLLBACK TO update_item_rule;
1560: x_return_status := FND_API.G_RET_STS_ERROR;
1561: IF FND_MSG_PUB.Check_Msg_Level
1562: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1563: THEN
1564: FND_MSG_PUB.Add_Exc_Msg
1565: ( G_PKG_NAME ,
1566: l_api_name

Line 1564: FND_MSG_PUB.Add_Exc_Msg

1560: x_return_status := FND_API.G_RET_STS_ERROR;
1561: IF FND_MSG_PUB.Check_Msg_Level
1562: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1563: THEN
1564: FND_MSG_PUB.Add_Exc_Msg
1565: ( G_PKG_NAME ,
1566: l_api_name
1567: );
1568:

Line 1571: FND_MSG_PUB.Count_And_Get

1567: );
1568:
1569: END IF;
1570:
1571: FND_MSG_PUB.Count_And_Get
1572: ( p_count => x_msg_count ,
1573:
1574: p_data => x_msg_data
1575: );

Line 1635: FND_MSG_PUB.initialize;

1631:
1632: -- Initialize message list if p_init_msg_list is set to TRUE.
1633: IF FND_API.to_Boolean( p_init_msg_list )
1634: THEN
1635: FND_MSG_PUB.initialize;
1636:
1637: END IF;
1638:
1639:

Line 1718: FND_MSG_PUB.Count_And_Get

1714: IF FND_API.To_Boolean(p_commit) THEN
1715: COMMIT WORK;
1716: END IF;
1717: -- Standard callto get message count and if count is 1, get message info.
1718: FND_MSG_PUB.Count_And_Get
1719: ( p_count => x_msg_count,
1720: p_data => x_msg_data
1721: );
1722:

Line 1730: --FND_MSG_PUB.Add;

1726: EXCEPTION
1727: WHEN IEM_RT_ClASS_FAIL_CREAT_FOLDER THEN
1728: ROLLBACK TO create_wrap_acct_rt_class_PVT;
1729: --FND_MESSAGE.SET_NAME('IEM','IEM_RT_ClASS_FAIL_CREAT_FOLDER');
1730: --FND_MSG_PUB.Add;
1731: x_return_status := FND_API.G_RET_STS_ERROR ;
1732: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1733:
1734: WHEN IEM_RT_CLASS_NO_DATA THEN

Line 1732: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1728: ROLLBACK TO create_wrap_acct_rt_class_PVT;
1729: --FND_MESSAGE.SET_NAME('IEM','IEM_RT_ClASS_FAIL_CREAT_FOLDER');
1730: --FND_MSG_PUB.Add;
1731: x_return_status := FND_API.G_RET_STS_ERROR ;
1732: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1733:
1734: WHEN IEM_RT_CLASS_NO_DATA THEN
1735: ROLLBACK TO create_wrap_acct_rt_class_PVT;
1736: FND_MESSAGE.SET_NAME('IEM','IEM_RT_CLASS_NO_DATA');

Line 1739: FND_MSG_PUB.Add;

1735: ROLLBACK TO create_wrap_acct_rt_class_PVT;
1736: FND_MESSAGE.SET_NAME('IEM','IEM_RT_CLASS_NO_DATA');
1737:
1738:
1739: FND_MSG_PUB.Add;
1740: x_return_status := FND_API.G_RET_STS_ERROR ;
1741: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1742:
1743: WHEN IEM_ADMIN_ACCOUNT_NOT_EXIST THEN

Line 1741: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1737:
1738:
1739: FND_MSG_PUB.Add;
1740: x_return_status := FND_API.G_RET_STS_ERROR ;
1741: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1742:
1743: WHEN IEM_ADMIN_ACCOUNT_NOT_EXIST THEN
1744: ROLLBACK TO create_wrap_acct_rt_class_PVT;
1745: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ACCOUNT_NOT_EXIST');

Line 1746: FND_MSG_PUB.Add;

1742:
1743: WHEN IEM_ADMIN_ACCOUNT_NOT_EXIST THEN
1744: ROLLBACK TO create_wrap_acct_rt_class_PVT;
1745: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ACCOUNT_NOT_EXIST');
1746: FND_MSG_PUB.Add;
1747:
1748: x_return_status := FND_API.G_RET_STS_ERROR ;
1749: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1750:

Line 1749: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1745: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ACCOUNT_NOT_EXIST');
1746: FND_MSG_PUB.Add;
1747:
1748: x_return_status := FND_API.G_RET_STS_ERROR ;
1749: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1750:
1751:
1752: WHEN IEM_RT_ClASS_ACCT_NOT_UPDATED THEN
1753:

Line 1756: FND_MSG_PUB.Add;

1752: WHEN IEM_RT_ClASS_ACCT_NOT_UPDATED THEN
1753:
1754: ROLLBACK TO create_wrap_acct_rt_class_PVT;
1755: FND_MESSAGE.SET_NAME('IEM','IEM_RT_ClASS_ACCT_NOT_UPDATED');
1756: FND_MSG_PUB.Add;
1757: x_return_status := FND_API.G_RET_STS_ERROR ;
1758: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1759:
1760: WHEN FND_API.G_EXC_ERROR THEN

Line 1758: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1754: ROLLBACK TO create_wrap_acct_rt_class_PVT;
1755: FND_MESSAGE.SET_NAME('IEM','IEM_RT_ClASS_ACCT_NOT_UPDATED');
1756: FND_MSG_PUB.Add;
1757: x_return_status := FND_API.G_RET_STS_ERROR ;
1758: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1759:
1760: WHEN FND_API.G_EXC_ERROR THEN
1761: ROLLBACK TO create_wrap_acct_rt_class_PVT;
1762: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1764: FND_MSG_PUB.Count_And_Get

1760: WHEN FND_API.G_EXC_ERROR THEN
1761: ROLLBACK TO create_wrap_acct_rt_class_PVT;
1762: x_return_status := FND_API.G_RET_STS_ERROR ;
1763:
1764: FND_MSG_PUB.Count_And_Get
1765:
1766: ( p_count => x_msg_count,
1767: p_data => x_msg_data
1768:

Line 1774: FND_MSG_PUB.Count_And_Get

1770:
1771: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1772: ROLLBACK TO create_wrap_acct_rt_class_PVT;
1773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1774: FND_MSG_PUB.Count_And_Get
1775: ( p_count => x_msg_count,
1776: p_data => x_msg_data
1777: );
1778:

Line 1785: IF FND_MSG_PUB.Check_Msg_Level

1781: WHEN OTHERS THEN
1782: ROLLBACK TO create_wrap_acct_rt_class_PVT;
1783:
1784: x_return_status := FND_API.G_RET_STS_ERROR;
1785: IF FND_MSG_PUB.Check_Msg_Level
1786: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1787: THEN
1788: FND_MSG_PUB.Add_Exc_Msg
1789: ( G_PKG_NAME,

Line 1786: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1782: ROLLBACK TO create_wrap_acct_rt_class_PVT;
1783:
1784: x_return_status := FND_API.G_RET_STS_ERROR;
1785: IF FND_MSG_PUB.Check_Msg_Level
1786: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1787: THEN
1788: FND_MSG_PUB.Add_Exc_Msg
1789: ( G_PKG_NAME,
1790: l_api_name

Line 1788: FND_MSG_PUB.Add_Exc_Msg

1784: x_return_status := FND_API.G_RET_STS_ERROR;
1785: IF FND_MSG_PUB.Check_Msg_Level
1786: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1787: THEN
1788: FND_MSG_PUB.Add_Exc_Msg
1789: ( G_PKG_NAME,
1790: l_api_name
1791: );
1792: END IF;

Line 1794: FND_MSG_PUB.Count_And_Get

1790: l_api_name
1791: );
1792: END IF;
1793:
1794: FND_MSG_PUB.Count_And_Get
1795: ( p_count => x_msg_count,
1796:
1797: p_data => x_msg_data
1798:

Line 1844: FND_MSG_PUB.initialize;

1840:
1841: -- Initialize message list if p_init_msg_list is set to TRUE.
1842: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1843:
1844: FND_MSG_PUB.initialize;
1845:
1846: END IF;
1847:
1848: -- Initialize API return status to SUCCESS

Line 1939: FND_MSG_PUB.Count_And_Get

1935: COMMIT WORK;
1936: END IF;
1937:
1938: -- Standard callto get message count and if count is 1, get message info.
1939: FND_MSG_PUB.Count_And_Get
1940:
1941: ( p_count => x_msg_count,
1942: p_data => x_msg_data
1943: );

Line 1951: FND_MSG_PUB.Count_And_Get

1947:
1948: WHEN FND_API.G_EXC_ERROR THEN
1949: ROLLBACK TO create_item_acct_class_PVT;
1950: x_return_status := FND_API.G_RET_STS_ERROR ;
1951: FND_MSG_PUB.Count_And_Get
1952: ( p_count => x_msg_count,
1953: p_data => x_msg_data
1954: );
1955:

Line 1961: FND_MSG_PUB.Count_And_Get

1957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1958: ROLLBACK TO create_item_acct_class_PVT;
1959:
1960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1961: FND_MSG_PUB.Count_And_Get
1962:
1963: ( p_count => x_msg_count,
1964: p_data => x_msg_data
1965: );

Line 1970: IF FND_MSG_PUB.Check_Msg_Level

1966:
1967: WHEN OTHERS THEN
1968: ROLLBACK TO create_item_acct_class_PVT;
1969: x_return_status := FND_API.G_RET_STS_ERROR;
1970: IF FND_MSG_PUB.Check_Msg_Level
1971: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1972:
1973:
1974: THEN

Line 1971: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1967: WHEN OTHERS THEN
1968: ROLLBACK TO create_item_acct_class_PVT;
1969: x_return_status := FND_API.G_RET_STS_ERROR;
1970: IF FND_MSG_PUB.Check_Msg_Level
1971: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1972:
1973:
1974: THEN
1975: FND_MSG_PUB.Add_Exc_Msg

Line 1975: FND_MSG_PUB.Add_Exc_Msg

1971: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1972:
1973:
1974: THEN
1975: FND_MSG_PUB.Add_Exc_Msg
1976: ( G_PKG_NAME ,
1977:
1978: l_api_name
1979: );

Line 1981: FND_MSG_PUB.Count_And_Get

1977:
1978: l_api_name
1979: );
1980: END IF;
1981: FND_MSG_PUB.Count_And_Get
1982: ( p_count => x_msg_count ,
1983: p_data => x_msg_data
1984: );
1985:

Line 2039: FND_MSG_PUB.initialize;

2035: -- Initialize message list if p_init_msg_list is set to TRUE.
2036: IF FND_API.to_Boolean( p_init_msg_list )
2037: THEN
2038:
2039: FND_MSG_PUB.initialize;
2040: END IF;
2041: -- Initialize API return status to SUCCESS
2042: x_return_status := FND_API.G_RET_STS_SUCCESS;
2043:

Line 2094: FND_MSG_PUB.Count_And_Get

2090: COMMIT WORK;
2091:
2092: END IF;
2093: -- Standard callto get message count and if count is 1, get message info.
2094: FND_MSG_PUB.Count_And_Get
2095: ( p_count => x_msg_count,
2096: p_data => x_msg_data
2097: );
2098:

Line 2107: --FND_MSG_PUB.Add;

2103: END IF;
2104:
2105: --ROLLBACK TO update_wrap_acct_class_2_PVT;
2106: --FND_MESSAGE.SET_NAME('IEM','MY_EXCEPTION');
2107: --FND_MSG_PUB.Add;
2108: x_return_status := FND_API.G_RET_STS_ERROR ;
2109: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2110: WHEN IEM_RT_CLASS_ACCT_NOT_UPDATE THEN
2111: ROLLBACK TO update_wrap_acct_class_1_PVT;

Line 2109: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2105: --ROLLBACK TO update_wrap_acct_class_2_PVT;
2106: --FND_MESSAGE.SET_NAME('IEM','MY_EXCEPTION');
2107: --FND_MSG_PUB.Add;
2108: x_return_status := FND_API.G_RET_STS_ERROR ;
2109: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2110: WHEN IEM_RT_CLASS_ACCT_NOT_UPDATE THEN
2111: ROLLBACK TO update_wrap_acct_class_1_PVT;
2112: FND_MESSAGE.SET_NAME('IEM','IEM_RT_CLASS_ACCT_NOT_UPDATE');
2113: FND_MSG_PUB.Add;

Line 2113: FND_MSG_PUB.Add;

2109: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2110: WHEN IEM_RT_CLASS_ACCT_NOT_UPDATE THEN
2111: ROLLBACK TO update_wrap_acct_class_1_PVT;
2112: FND_MESSAGE.SET_NAME('IEM','IEM_RT_CLASS_ACCT_NOT_UPDATE');
2113: FND_MSG_PUB.Add;
2114: x_return_status := FND_API.G_RET_STS_ERROR ;
2115: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2116: WHEN IEM_ACCOUNT_CLASS_NOT_DELETED THEN
2117: ROLLBACK TO update_wrap_acct_class_2_PVT;

Line 2115: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2111: ROLLBACK TO update_wrap_acct_class_1_PVT;
2112: FND_MESSAGE.SET_NAME('IEM','IEM_RT_CLASS_ACCT_NOT_UPDATE');
2113: FND_MSG_PUB.Add;
2114: x_return_status := FND_API.G_RET_STS_ERROR ;
2115: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2116: WHEN IEM_ACCOUNT_CLASS_NOT_DELETED THEN
2117: ROLLBACK TO update_wrap_acct_class_2_PVT;
2118:
2119:

Line 2121: FND_MSG_PUB.Add;

2117: ROLLBACK TO update_wrap_acct_class_2_PVT;
2118:
2119:
2120: FND_MESSAGE.SET_NAME('IEM','IEM_ACCOUNT_CLASS_NOT_DELETED');
2121: FND_MSG_PUB.Add;
2122: x_return_status := FND_API.G_RET_STS_ERROR ;
2123: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2124: WHEN FND_API.G_EXC_ERROR THEN
2125: ROLLBACK TO update_wrap_acct_class_1_PVT;

Line 2123: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2119:
2120: FND_MESSAGE.SET_NAME('IEM','IEM_ACCOUNT_CLASS_NOT_DELETED');
2121: FND_MSG_PUB.Add;
2122: x_return_status := FND_API.G_RET_STS_ERROR ;
2123: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2124: WHEN FND_API.G_EXC_ERROR THEN
2125: ROLLBACK TO update_wrap_acct_class_1_PVT;
2126: x_return_status := FND_API.G_RET_STS_ERROR ;
2127:

Line 2128: FND_MSG_PUB.Count_And_Get

2124: WHEN FND_API.G_EXC_ERROR THEN
2125: ROLLBACK TO update_wrap_acct_class_1_PVT;
2126: x_return_status := FND_API.G_RET_STS_ERROR ;
2127:
2128: FND_MSG_PUB.Count_And_Get
2129: ( p_count => x_msg_count,
2130: p_data => x_msg_data
2131: );
2132:

Line 2138: FND_MSG_PUB.Count_And_Get

2134:
2135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2136: ROLLBACK TO update_wrap_acct_class_1_PVT;
2137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2138: FND_MSG_PUB.Count_And_Get
2139: ( p_count => x_msg_count,
2140: p_data => x_msg_data
2141: );
2142:

Line 2148: IF FND_MSG_PUB.Check_Msg_Level

2144: WHEN OTHERS THEN
2145: ROLLBACK TO update_wrap_acct_class_1_PVT;
2146:
2147: x_return_status := FND_API.G_RET_STS_ERROR;
2148: IF FND_MSG_PUB.Check_Msg_Level
2149:
2150: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2151: THEN
2152: FND_MSG_PUB.Add_Exc_Msg

Line 2150: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2146:
2147: x_return_status := FND_API.G_RET_STS_ERROR;
2148: IF FND_MSG_PUB.Check_Msg_Level
2149:
2150: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2151: THEN
2152: FND_MSG_PUB.Add_Exc_Msg
2153: ( G_PKG_NAME,
2154: l_api_name

Line 2152: FND_MSG_PUB.Add_Exc_Msg

2148: IF FND_MSG_PUB.Check_Msg_Level
2149:
2150: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2151: THEN
2152: FND_MSG_PUB.Add_Exc_Msg
2153: ( G_PKG_NAME,
2154: l_api_name
2155: );
2156: END IF;

Line 2157: FND_MSG_PUB.Count_And_Get

2153: ( G_PKG_NAME,
2154: l_api_name
2155: );
2156: END IF;
2157: FND_MSG_PUB.Count_And_Get
2158: ( p_count => x_msg_count,
2159:
2160:
2161: p_data => x_msg_data

Line 2209: FND_MSG_PUB.initialize;

2205:
2206: -- Initialize message list if p_init_msg_list is set to TRUE.
2207: IF FND_API.to_Boolean( p_init_msg_list )
2208: THEN
2209: FND_MSG_PUB.initialize;
2210: END IF;
2211:
2212: -- Initialize API return status to SUCCESS
2213: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2261: FND_MSG_PUB.Count_And_Get

2257: IF FND_API.To_Boolean(p_commit) THEN
2258: COMMIT WORK;
2259: END IF;
2260: -- Standard callto get message count and if count is 1, get message info.
2261: FND_MSG_PUB.Count_And_Get
2262: ( p_count => x_msg_count,
2263: p_data => x_msg_data
2264: );
2265:

Line 2273: FND_MSG_PUB.Add;

2269: WHEN IEM_RT_CLASS_NO_DATA THEN
2270: ROLLBACK TO update_account_class_PVT;
2271:
2272: FND_MESSAGE.SET_NAME('IEM','IEM_RT_CLASS_NO_DATA');
2273: FND_MSG_PUB.Add;
2274: x_return_status := FND_API.G_RET_STS_ERROR ;
2275: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2276: WHEN IEM_ADMIN_ACCOUNT_NOT_EXIST THEN
2277: ROLLBACK TO update_account_class_PVT;

Line 2275: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2271:
2272: FND_MESSAGE.SET_NAME('IEM','IEM_RT_CLASS_NO_DATA');
2273: FND_MSG_PUB.Add;
2274: x_return_status := FND_API.G_RET_STS_ERROR ;
2275: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2276: WHEN IEM_ADMIN_ACCOUNT_NOT_EXIST THEN
2277: ROLLBACK TO update_account_class_PVT;
2278: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ACCOUNT_NOT_EXIST');
2279: FND_MSG_PUB.Add;

Line 2279: FND_MSG_PUB.Add;

2275: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2276: WHEN IEM_ADMIN_ACCOUNT_NOT_EXIST THEN
2277: ROLLBACK TO update_account_class_PVT;
2278: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ACCOUNT_NOT_EXIST');
2279: FND_MSG_PUB.Add;
2280:
2281: x_return_status := FND_API.G_RET_STS_ERROR ;
2282:
2283: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 2283: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2279: FND_MSG_PUB.Add;
2280:
2281: x_return_status := FND_API.G_RET_STS_ERROR ;
2282:
2283: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2284:
2285: WHEN FND_API.G_EXC_ERROR THEN
2286: ROLLBACK TO update_account_class_PVT;
2287: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 2288: FND_MSG_PUB.Count_And_Get

2284:
2285: WHEN FND_API.G_EXC_ERROR THEN
2286: ROLLBACK TO update_account_class_PVT;
2287: x_return_status := FND_API.G_RET_STS_ERROR ;
2288: FND_MSG_PUB.Count_And_Get
2289: ( p_count => x_msg_count,
2290: p_data => x_msg_data
2291: );
2292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2297: FND_MSG_PUB.Count_And_Get

2293: ROLLBACK TO update_account_class_PVT;
2294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2295:
2296:
2297: FND_MSG_PUB.Count_And_Get
2298:
2299: ( p_count => x_msg_count,
2300: p_data => x_msg_data
2301: );

Line 2305: IF FND_MSG_PUB.Check_Msg_Level

2301: );
2302: WHEN OTHERS THEN
2303: ROLLBACK TO update_account_class_PVT;
2304: x_return_status := FND_API.G_RET_STS_ERROR;
2305: IF FND_MSG_PUB.Check_Msg_Level
2306: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2307: THEN
2308: FND_MSG_PUB.Add_Exc_Msg
2309: ( G_PKG_NAME ,

Line 2306: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2302: WHEN OTHERS THEN
2303: ROLLBACK TO update_account_class_PVT;
2304: x_return_status := FND_API.G_RET_STS_ERROR;
2305: IF FND_MSG_PUB.Check_Msg_Level
2306: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2307: THEN
2308: FND_MSG_PUB.Add_Exc_Msg
2309: ( G_PKG_NAME ,
2310:

Line 2308: FND_MSG_PUB.Add_Exc_Msg

2304: x_return_status := FND_API.G_RET_STS_ERROR;
2305: IF FND_MSG_PUB.Check_Msg_Level
2306: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2307: THEN
2308: FND_MSG_PUB.Add_Exc_Msg
2309: ( G_PKG_NAME ,
2310:
2311:
2312: l_api_name

Line 2316: FND_MSG_PUB.Count_And_Get

2312: l_api_name
2313: );
2314:
2315: END IF;
2316: FND_MSG_PUB.Count_And_Get
2317: ( p_count => x_msg_count,
2318: p_data => x_msg_data
2319: );
2320:

Line 2367: FND_MSG_PUB.initialize;

2363:
2364: --Initialize the message list if p_init_msg_list is set to TRUE
2365: If FND_API.to_Boolean(p_init_msg_list) THEN
2366:
2367: FND_MSG_PUB.initialize;
2368:
2369: END IF;
2370:
2371: --Initialize API status return

Line 2433: FND_MSG_PUB.ADD;

2429: x_return_status := FND_API.G_RET_STS_ERROR;
2430: FND_MESSAGE.SET_NAME('IEM', 'IEM_RT_CLASS_FAILED_DEL_FOLDER');
2431:
2432: FND_MESSAGE.SET_TOKEN('CLASSIFICATION', l_undeleted_class_name);
2433: FND_MSG_PUB.ADD;
2434: end if;
2435:
2436: --Standard check of p_commit
2437: IF FND_API.to_Boolean(p_commit) THEN

Line 2442: FND_MSG_PUB.Count_And_Get

2438: COMMIT WORK;
2439: END IF;
2440:
2441:
2442: FND_MSG_PUB.Count_And_Get
2443: ( p_count => x_msg_count,
2444: p_data => x_msg_data
2445:
2446: );

Line 2454: FND_MSG_PUB.ADD;

2450: WHEN IEM_ACCOUNT_CLASS_NOT_DELETED THEN
2451: ROLLBACK TO delete_acct_class_batch;
2452: x_return_status := FND_API.G_RET_STS_ERROR;
2453: FND_MESSAGE.SET_NAME('IEM', 'IEM_ACCOUNT_CLASS_NOT_DELETED');
2454: FND_MSG_PUB.ADD;
2455: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2456:
2457: WHEN FND_API.G_EXC_ERROR THEN
2458:

Line 2455: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2451: ROLLBACK TO delete_acct_class_batch;
2452: x_return_status := FND_API.G_RET_STS_ERROR;
2453: FND_MESSAGE.SET_NAME('IEM', 'IEM_ACCOUNT_CLASS_NOT_DELETED');
2454: FND_MSG_PUB.ADD;
2455: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2456:
2457: WHEN FND_API.G_EXC_ERROR THEN
2458:
2459: ROLLBACK TO delete_acct_class_batch;

Line 2461: FND_MSG_PUB.Count_And_Get

2457: WHEN FND_API.G_EXC_ERROR THEN
2458:
2459: ROLLBACK TO delete_acct_class_batch;
2460: x_return_status := FND_API.G_RET_STS_ERROR ;
2461: FND_MSG_PUB.Count_And_Get
2462: ( p_count => x_msg_count,p_data => x_msg_data);
2463:
2464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2465: ROLLBACK TO delete_acct_class_batch;

Line 2467: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);

2463:
2464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2465: ROLLBACK TO delete_acct_class_batch;
2466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2467: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
2468:
2469:
2470: WHEN OTHERS THEN
2471: ROLLBACK TO delete_acct_class_batch;

Line 2474: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2470: WHEN OTHERS THEN
2471: ROLLBACK TO delete_acct_class_batch;
2472:
2473: x_return_status := FND_API.G_RET_STS_ERROR;
2474: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2475: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
2476: END IF;
2477:
2478: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

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

2471: ROLLBACK TO delete_acct_class_batch;
2472:
2473: x_return_status := FND_API.G_RET_STS_ERROR;
2474: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2475: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
2476: END IF;
2477:
2478: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
2479:

Line 2478: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

2474: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2475: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
2476: END IF;
2477:
2478: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
2479:
2480: END delete_acct_class_batch;
2481:
2482: -- ***** Remove for 11i compliance *****

Line 2523: FND_MSG_PUB.initialize;

2519:
2520: --Initialize the message list if p_init_msg_list is set to TRUE
2521: If FND_API.to_Boolean(p_init_msg_list) THEN
2522:
2523: FND_MSG_PUB.initialize;
2524: END IF;
2525:
2526: --Initialize API status return
2527:

Line 2558: FND_MSG_PUB.Count_And_Get

2554: COMMIT WORK;
2555: END IF;
2556:
2557:
2558: FND_MSG_PUB.Count_And_Get
2559: ( p_count => x_msg_count,
2560:
2561: p_data => x_msg_data
2562: );

Line 2569: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2565: WHEN MY_EXCP_MSG_IN_FOLDER THEN
2566: ROLLBACK TO delete_folder_on_classId;
2567: x_return_status := FND_API.G_RET_STS_ERROR;
2568:
2569: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2570:
2571:
2572: WHEN IEM_UNEXPT_ERR_DELETE_FOLDER THEN
2573: ROLLBACK TO delete_folder_on_classId;

Line 2578: --FND_MSG_PUB.ADD;

2574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2575:
2576: --FND_MESSAGE.SET_NAME('IEM', 'IEM_UNEXPT_ERR_DELETE_FOLDER');
2577:
2578: --FND_MSG_PUB.ADD;
2579: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2580:
2581: WHEN FND_API.G_EXC_ERROR THEN
2582: ROLLBACK TO delete_folder_on_classId;

Line 2579: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2575:
2576: --FND_MESSAGE.SET_NAME('IEM', 'IEM_UNEXPT_ERR_DELETE_FOLDER');
2577:
2578: --FND_MSG_PUB.ADD;
2579: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2580:
2581: WHEN FND_API.G_EXC_ERROR THEN
2582: ROLLBACK TO delete_folder_on_classId;
2583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2584: FND_MSG_PUB.Count_And_Get

2580:
2581: WHEN FND_API.G_EXC_ERROR THEN
2582: ROLLBACK TO delete_folder_on_classId;
2583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2584: FND_MSG_PUB.Count_And_Get
2585: ( p_count => x_msg_count,p_data => x_msg_data);
2586:
2587:
2588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2591: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);

2587:
2588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2589: ROLLBACK TO delete_folder_on_classId;
2590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2591: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
2592:
2593:
2594: WHEN OTHERS THEN
2595: ROLLBACK TO delete_folder_on_classId;

Line 2597: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2593:
2594: WHEN OTHERS THEN
2595: ROLLBACK TO delete_folder_on_classId;
2596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2597: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2598: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
2599: END IF;
2600:
2601:

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

2594: WHEN OTHERS THEN
2595: ROLLBACK TO delete_folder_on_classId;
2596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2597: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2598: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
2599: END IF;
2600:
2601:
2602: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

Line 2602: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

2598: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
2599: END IF;
2600:
2601:
2602: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
2603:
2604: END delete_folder_on_classId;
2605:
2606: */

Line 2672: FND_MSG_PUB.initialize;

2668:
2669: -- Initialize message list if p_init_msg_list is set to TRUE.
2670: IF FND_API.to_Boolean( p_init_msg_list )
2671: THEN
2672: FND_MSG_PUB.initialize;
2673:
2674:
2675: END IF;
2676:

Line 2747: FND_MSG_PUB.Count_And_Get

2743: --Standard check of p_commit
2744: IF FND_API.to_Boolean(p_commit) THEN
2745: COMMIT WORK;
2746: END IF;
2747: FND_MSG_PUB.Count_And_Get
2748: ( p_count => x_msg_count,
2749: p_data => x_msg_data
2750: );
2751: EXCEPTION

Line 2757: --FND_MSG_PUB.ADD;

2753: ROLLBACK TO create_folder_PVT;
2754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2755:
2756: --FND_MESSAGE.SET_NAME('IEM', 'IEM_DB_LINK_NOT_AVAILABLE');
2757: --FND_MSG_PUB.ADD;
2758: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2759: WHEN IEM_ADMIN_ACCOUNT_NOT_EXIST THEN
2760: ROLLBACK TO create_folder_PVT;
2761:

Line 2758: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2755:
2756: --FND_MESSAGE.SET_NAME('IEM', 'IEM_DB_LINK_NOT_AVAILABLE');
2757: --FND_MSG_PUB.ADD;
2758: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2759: WHEN IEM_ADMIN_ACCOUNT_NOT_EXIST THEN
2760: ROLLBACK TO create_folder_PVT;
2761:
2762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2765: FND_MSG_PUB.ADD;

2761:
2762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2763: FND_MESSAGE.SET_NAME('IEM', 'IEM_ADMIN_ACCOUNT_NOT_EXIST');
2764:
2765: FND_MSG_PUB.ADD;
2766: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2767:
2768: WHEN tns_no_listener THEN
2769: ROLLBACK TO create_folder_PVT;

Line 2766: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2763: FND_MESSAGE.SET_NAME('IEM', 'IEM_ADMIN_ACCOUNT_NOT_EXIST');
2764:
2765: FND_MSG_PUB.ADD;
2766: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2767:
2768: WHEN tns_no_listener THEN
2769: ROLLBACK TO create_folder_PVT;
2770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2772: FND_MSG_PUB.ADD;

2768: WHEN tns_no_listener THEN
2769: ROLLBACK TO create_folder_PVT;
2770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2771: FND_MESSAGE.SET_NAME('IEM', 'IEM_ADMIN_TNS_NO_LISTENER');
2772: FND_MSG_PUB.ADD;
2773: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2774:
2775: WHEN looking_up_object THEN
2776: ROLLBACK TO create_folder_PVT;

Line 2773: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2769: ROLLBACK TO create_folder_PVT;
2770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2771: FND_MESSAGE.SET_NAME('IEM', 'IEM_ADMIN_TNS_NO_LISTENER');
2772: FND_MSG_PUB.ADD;
2773: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2774:
2775: WHEN looking_up_object THEN
2776: ROLLBACK TO create_folder_PVT;
2777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2779: FND_MSG_PUB.ADD;

2775: WHEN looking_up_object THEN
2776: ROLLBACK TO create_folder_PVT;
2777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2778: FND_MESSAGE.SET_NAME('IEM', 'IEM_ADMIN_LOOKING_UP_OBJECT');
2779: FND_MSG_PUB.ADD;
2780: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2781:
2782:
2783: WHEN FND_API.G_EXC_ERROR THEN

Line 2780: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2776: ROLLBACK TO create_folder_PVT;
2777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2778: FND_MESSAGE.SET_NAME('IEM', 'IEM_ADMIN_LOOKING_UP_OBJECT');
2779: FND_MSG_PUB.ADD;
2780: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2781:
2782:
2783: WHEN FND_API.G_EXC_ERROR THEN
2784: ROLLBACK TO create_folder_PVT;

Line 2787: FND_MSG_PUB.Count_And_Get

2783: WHEN FND_API.G_EXC_ERROR THEN
2784: ROLLBACK TO create_folder_PVT;
2785: x_return_status := FND_API.G_RET_STS_ERROR ;
2786:
2787: FND_MSG_PUB.Count_And_Get
2788: ( p_count => x_msg_count,
2789: p_data => x_msg_data
2790:
2791: );

Line 2797: FND_MSG_PUB.Count_And_Get

2793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2794:
2795: ROLLBACK TO create_folder_PVT;
2796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2797: FND_MSG_PUB.Count_And_Get
2798: ( p_count => x_msg_count,
2799: p_data => x_msg_data
2800: );
2801:

Line 2806: IF FND_MSG_PUB.Check_Msg_Level

2802: WHEN OTHERS THEN
2803: ROLLBACK TO create_folder_PVT;
2804:
2805: x_return_status := FND_API.G_RET_STS_ERROR;
2806: IF FND_MSG_PUB.Check_Msg_Level
2807: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2808: THEN
2809:
2810: FND_MSG_PUB.Add_Exc_Msg

Line 2807: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2803: ROLLBACK TO create_folder_PVT;
2804:
2805: x_return_status := FND_API.G_RET_STS_ERROR;
2806: IF FND_MSG_PUB.Check_Msg_Level
2807: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2808: THEN
2809:
2810: FND_MSG_PUB.Add_Exc_Msg
2811: ( G_PKG_NAME ,

Line 2810: FND_MSG_PUB.Add_Exc_Msg

2806: IF FND_MSG_PUB.Check_Msg_Level
2807: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2808: THEN
2809:
2810: FND_MSG_PUB.Add_Exc_Msg
2811: ( G_PKG_NAME ,
2812: l_api_name
2813: );
2814: END IF;

Line 2815: FND_MSG_PUB.Count_And_Get

2811: ( G_PKG_NAME ,
2812: l_api_name
2813: );
2814: END IF;
2815: FND_MSG_PUB.Count_And_Get
2816: ( p_count => x_msg_count,
2817:
2818:
2819: p_data => x_msg_data

Line 2889: FND_MSG_PUB.initialize;

2885: -- Initialize message list if p_init_msg_list is set to TRUE.
2886: IF FND_API.to_Boolean( p_init_msg_list )
2887: THEN
2888:
2889: FND_MSG_PUB.initialize;
2890:
2891: END IF;
2892:
2893:

Line 2992: FND_MSG_PUB.Count_And_Get

2988: IF FND_API.to_Boolean(p_commit) THEN
2989: COMMIT WORK;
2990: END IF;
2991:
2992: FND_MSG_PUB.Count_And_Get
2993: ( p_count => x_msg_count,
2994: p_data => x_msg_data
2995: );
2996: EXCEPTION

Line 3001: --FND_MSG_PUB.ADD;

2997: WHEN IEM_ADMIN_DB_CONNECTION_FAILED THEN
2998: ROLLBACK TO delete_folder_PVT;
2999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3000: --FND_MESSAGE.SET_NAME('IEM', 'IEM_ADMIN_DB_CONNECT');
3001: --FND_MSG_PUB.ADD;
3002: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3003:
3004: WHEN IEM_ACCT_ID_NOT_EXIST THEN
3005: ROLLBACK TO delete_folder_PVT;

Line 3002: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2998: ROLLBACK TO delete_folder_PVT;
2999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3000: --FND_MESSAGE.SET_NAME('IEM', 'IEM_ADMIN_DB_CONNECT');
3001: --FND_MSG_PUB.ADD;
3002: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3003:
3004: WHEN IEM_ACCT_ID_NOT_EXIST THEN
3005: ROLLBACK TO delete_folder_PVT;
3006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3008: FND_MSG_PUB.ADD;

3004: WHEN IEM_ACCT_ID_NOT_EXIST THEN
3005: ROLLBACK TO delete_folder_PVT;
3006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3007: FND_MESSAGE.SET_NAME('IEM', 'IEM_ACCT_ID_NOT_EXIST');
3008: FND_MSG_PUB.ADD;
3009: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3010:
3011: WHEN tns_no_listener THEN
3012: ROLLBACK TO delete_folder_PVT;

Line 3009: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

3005: ROLLBACK TO delete_folder_PVT;
3006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3007: FND_MESSAGE.SET_NAME('IEM', 'IEM_ACCT_ID_NOT_EXIST');
3008: FND_MSG_PUB.ADD;
3009: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3010:
3011: WHEN tns_no_listener THEN
3012: ROLLBACK TO delete_folder_PVT;
3013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3015: FND_MSG_PUB.ADD;

3011: WHEN tns_no_listener THEN
3012: ROLLBACK TO delete_folder_PVT;
3013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3014: FND_MESSAGE.SET_NAME('IEM', 'IEM_ADMIN_TNS_NO_LISTENER');
3015: FND_MSG_PUB.ADD;
3016: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3017:
3018:
3019: WHEN FND_API.G_EXC_ERROR THEN

Line 3016: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

3012: ROLLBACK TO delete_folder_PVT;
3013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3014: FND_MESSAGE.SET_NAME('IEM', 'IEM_ADMIN_TNS_NO_LISTENER');
3015: FND_MSG_PUB.ADD;
3016: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3017:
3018:
3019: WHEN FND_API.G_EXC_ERROR THEN
3020: ROLLBACK TO delete_folder_PVT;

Line 3024: FND_MSG_PUB.Count_And_Get

3020: ROLLBACK TO delete_folder_PVT;
3021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3022:
3023:
3024: FND_MSG_PUB.Count_And_Get
3025: ( p_count => x_msg_count,
3026: p_data => x_msg_data
3027:
3028: );

Line 3033: FND_MSG_PUB.Count_And_Get

3029:
3030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3031: ROLLBACK TO delete_folder_PVT;
3032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3033: FND_MSG_PUB.Count_And_Get
3034: ( p_count => x_msg_count,
3035: p_data => x_msg_data
3036:
3037: );

Line 3044: IF FND_MSG_PUB.Check_Msg_Level

3040: WHEN OTHERS THEN
3041: ROLLBACK TO delete_folder_PVT;
3042:
3043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3044: IF FND_MSG_PUB.Check_Msg_Level
3045: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3046: THEN
3047: FND_MSG_PUB.Add_Exc_Msg
3048: ( G_PKG_NAME ,

Line 3045: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3041: ROLLBACK TO delete_folder_PVT;
3042:
3043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3044: IF FND_MSG_PUB.Check_Msg_Level
3045: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3046: THEN
3047: FND_MSG_PUB.Add_Exc_Msg
3048: ( G_PKG_NAME ,
3049: l_api_name

Line 3047: FND_MSG_PUB.Add_Exc_Msg

3043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3044: IF FND_MSG_PUB.Check_Msg_Level
3045: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3046: THEN
3047: FND_MSG_PUB.Add_Exc_Msg
3048: ( G_PKG_NAME ,
3049: l_api_name
3050:
3051: );

Line 3053: FND_MSG_PUB.Count_And_Get

3049: l_api_name
3050:
3051: );
3052: END IF;
3053: FND_MSG_PUB.Count_And_Get
3054: ( p_count => x_msg_count,
3055:
3056: p_data => x_msg_data
3057:

Line 3107: FND_MSG_PUB.initialize;

3103: --Initialize the message list if p_init_msg_list is set to TRUE
3104: If FND_API.to_Boolean(p_init_msg_list) THEN
3105:
3106:
3107: FND_MSG_PUB.initialize;
3108: END IF;
3109:
3110:
3111: --Initialize API status return

Line 3149: FND_MSG_PUB.Count_And_Get

3145: IF FND_API.to_Boolean(p_commit) THEN
3146: COMMIT WORK;
3147: END IF;
3148:
3149: FND_MSG_PUB.Count_And_Get
3150: ( p_count => x_msg_count,
3151: p_data => x_msg_data
3152: );
3153:

Line 3160: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

3156:
3157: WHEN MY_EXCP_MSG_IN_FOLDER THEN
3158: ROLLBACK TO delete_association_on_acctId;
3159: x_return_status := FND_API.G_RET_STS_ERROR;
3160: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3161:
3162: WHEN IEM_UNEXPT_ERR_DELETE_FOLDER THEN
3163: ROLLBACK TO delete_association_on_acctId;
3164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3166: FND_MSG_PUB.ADD;

3162: WHEN IEM_UNEXPT_ERR_DELETE_FOLDER THEN
3163: ROLLBACK TO delete_association_on_acctId;
3164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3165: FND_MESSAGE.SET_NAME('IEM', 'IEM_UNEXPT_ERR_DELETE_FOLDER');
3166: FND_MSG_PUB.ADD;
3167: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3168:
3169: WHEN FND_API.G_EXC_ERROR THEN
3170:

Line 3167: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

3163: ROLLBACK TO delete_association_on_acctId;
3164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3165: FND_MESSAGE.SET_NAME('IEM', 'IEM_UNEXPT_ERR_DELETE_FOLDER');
3166: FND_MSG_PUB.ADD;
3167: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3168:
3169: WHEN FND_API.G_EXC_ERROR THEN
3170:
3171:

Line 3174: FND_MSG_PUB.Count_And_Get

3170:
3171:
3172: ROLLBACK TO delete_association_on_acctId;
3173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3174: FND_MSG_PUB.Count_And_Get
3175: ( p_count => x_msg_count,p_data => x_msg_data);
3176:
3177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3178: ROLLBACK TO delete_association_on_acctId;

Line 3180: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);

3176:
3177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3178: ROLLBACK TO delete_association_on_acctId;
3179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3180: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
3181:
3182: WHEN OTHERS THEN
3183: ROLLBACK TO delete_association_on_acctId;
3184:

Line 3187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3183: ROLLBACK TO delete_association_on_acctId;
3184:
3185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3186:
3187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3188: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
3189: END IF;
3190:
3191: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

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

3184:
3185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3186:
3187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3188: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
3189: END IF;
3190:
3191: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
3192:

Line 3191: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

3187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3188: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
3189: END IF;
3190:
3191: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
3192:
3193: END delete_association_on_acctId;
3194:
3195: END IEM_ROUTE_CLASS_PVT; -- Package Body IEM_ROUTE_CLASS_PVT