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

Line 51: FND_MSG_PUB.initialize;

47: END IF;
48:
49: -- Check p_init_msg_list
50: IF FND_API.to_Boolean( p_init_msg_list ) THEN
51: FND_MSG_PUB.initialize;
52: END IF;
53:
54: x_return_status := FND_API.G_RET_STS_SUCCESS;
55:

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

93: COMMIT WORK;
94: END IF;
95:
96: -- Standard call to get message count and if count is 1, get message info
97: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
98:
99: EXCEPTION
100: WHEN FND_API.G_EXC_ERROR THEN
101: ROLLBACK TO Acct_Balance_PVT;

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

99: EXCEPTION
100: WHEN FND_API.G_EXC_ERROR THEN
101: ROLLBACK TO Acct_Balance_PVT;
102: x_return_status := FND_API.G_RET_STS_ERROR;
103: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
104:
105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
106: ROLLBACK TO Acct_Balance_PVT;
107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

104:
105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
106: ROLLBACK TO Acct_Balance_PVT;
107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
108: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
109:
110: WHEN OTHERS THEN
111: ROLLBACK TO Acct_Balance_PVT;
112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

110: WHEN OTHERS THEN
111: ROLLBACK TO Acct_Balance_PVT;
112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
113: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
114: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
115: END IF;
116: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
117:
118: END Acct_Balance;

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

112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
113: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
114: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
115: END IF;
116: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
117:
118: END Acct_Balance;
119:
120: PROCEDURE Validate_any_id(p_api_version IN NUMBER := 1.0,

Line 178: FND_MSG_PUB.initialize;

174:
175: -- Initialize message list if p_init_msg_list is set to TRUE.
176: IF FND_API.to_Boolean(p_init_msg_list)
177: THEN
178: FND_MSG_PUB.initialize;
179: END IF;
180:
181: -- API body
182: -- clchang updated for sql bind var 05/07/2003

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

221: EXCEPTION
222: WHEN FND_API.G_EXC_ERROR THEN
223: ROLLBACK TO Validate_any_id_PVT;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
226:
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228: ROLLBACK TO Validate_any_id_PVT;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

226:
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228: ROLLBACK TO Validate_any_id_PVT;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
231:
232: WHEN OTHERS THEN
233: ROLLBACK TO Validate_any_id_PVT;
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

231:
232: WHEN OTHERS THEN
233: ROLLBACK TO Validate_any_id_PVT;
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
236: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
237: END IF;
238: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
239:

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

232: WHEN OTHERS THEN
233: ROLLBACK TO Validate_any_id_PVT;
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
236: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
237: END IF;
238: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
239:
240: END Validate_any_id;

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

234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
236: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
237: END IF;
238: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
239:
240: END Validate_any_id;
241:
242: PROCEDURE Validate_any_varchar(p_api_version IN NUMBER := 1.0,

Line 302: FND_MSG_PUB.initialize;

298:
299: -- Initialize message list if p_init_msg_list is set to TRUE.
300: IF FND_API.to_Boolean(p_init_msg_list)
301: THEN
302: FND_MSG_PUB.initialize;
303: END IF;
304:
305: -- API body
306: --dbms_output.put_line('col is ' || p_col_value);

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

340: EXCEPTION
341: WHEN FND_API.G_EXC_ERROR THEN
342: ROLLBACK TO Validate_any_varchar_PVT;
343: x_return_status := FND_API.G_RET_STS_ERROR;
344: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
345:
346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
347: ROLLBACK TO Validate_any_varchar_PVT;
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

345:
346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
347: ROLLBACK TO Validate_any_varchar_PVT;
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
349: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
350:
351: WHEN OTHERS THEN
352: ROLLBACK TO Validate_any_varchar_PVT;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

350:
351: WHEN OTHERS THEN
352: ROLLBACK TO Validate_any_varchar_PVT;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
355: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
356: END IF;
357: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
358:

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

351: WHEN OTHERS THEN
352: ROLLBACK TO Validate_any_varchar_PVT;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
355: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
356: END IF;
357: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
358:
359: END Validate_any_varchar;

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

353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
355: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
356: END IF;
357: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
358:
359: END Validate_any_varchar;
360:
361: PROCEDURE Validate_Lookup_CODE(p_api_version IN NUMBER := 1.0,

Line 417: FND_MSG_PUB.initialize;

413:
414: -- Initialize message list if p_init_msg_list is set to TRUE.
415: IF FND_API.to_Boolean(p_init_msg_list)
416: THEN
417: FND_MSG_PUB.initialize;
418: END IF;
419:
420: -- API body
421: l_lookup_code := '''' || p_lookup_code || '''';

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

477: EXCEPTION
478: WHEN FND_API.G_EXC_ERROR THEN
479: ROLLBACK TO Validate_any_varchar_PVT;
480: x_return_status := FND_API.G_RET_STS_ERROR;
481: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
482:
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: ROLLBACK TO Validate_any_varchar_PVT;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

482:
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: ROLLBACK TO Validate_any_varchar_PVT;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
487:
488: WHEN OTHERS THEN
489: ROLLBACK TO Validate_any_varchar_PVT;
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

487:
488: WHEN OTHERS THEN
489: ROLLBACK TO Validate_any_varchar_PVT;
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
491: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
492: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
493: END IF;
494: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
495:

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

488: WHEN OTHERS THEN
489: ROLLBACK TO Validate_any_varchar_PVT;
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
491: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
492: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
493: END IF;
494: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
495:
496: END Validate_LOOKUP_CODE;

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

490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
491: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
492: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
493: END IF;
494: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
495:
496: END Validate_LOOKUP_CODE;
497:
498: -- added by jypark 03052002

Line 560: FND_MSG_PUB.initialize;

556: END IF;
557:
558: -- Check p_init_msg_list
559: IF FND_API.to_Boolean( p_init_msg_list ) THEN
560: FND_MSG_PUB.initialize;
561: END IF;
562:
563: x_return_status := FND_API.G_RET_STS_SUCCESS;
564:

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

590: COMMIT WORK;
591: END IF;
592:
593: -- Standard call to get message count and if count is 1, get message info
594: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
595:
596: IF PG_DEBUG < 10 THEN
597: iex_debug_pub.logmessage ('**** END get_access_resources ************');
598: END IF;

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

600: EXCEPTION
601: WHEN FND_API.G_EXC_ERROR THEN
602: ROLLBACK TO Access_Resources_Pvt;
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
605:
606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
607: ROLLBACK TO Access_Resources_Pvt;
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

605:
606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
607: ROLLBACK TO Access_Resources_Pvt;
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
609: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
610:
611: WHEN OTHERS THEN
612: ROLLBACK TO Access_Resources_Pvt;
613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

610:
611: WHEN OTHERS THEN
612: ROLLBACK TO Access_Resources_Pvt;
613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
614: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
615: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
616: END IF;
617: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
618:

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

611: WHEN OTHERS THEN
612: ROLLBACK TO Access_Resources_Pvt;
613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
614: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
615: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
616: END IF;
617: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
618:
619: END get_access_resources;

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

613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
614: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
615: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
616: END IF;
617: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
618:
619: END get_access_resources;
620:
621: PROCEDURE get_assign_resources(p_api_version IN NUMBER := 1.0,

Line 764: FND_MSG_PUB.initialize;

760: END IF;
761:
762: -- Check p_init_msg_list
763: IF FND_API.to_Boolean( p_init_msg_list ) THEN
764: FND_MSG_PUB.initialize;
765: END IF;
766:
767: x_return_status := FND_API.G_RET_STS_SUCCESS;
768:

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

788: COMMIT WORK;
789: END IF;
790:
791: -- Standard call to get message count and if count is 1, get message info
792: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
793:
794: iex_debug_pub.logmessage ('**** END get_access_resources ************');
795:
796: EXCEPTION

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

796: EXCEPTION
797: WHEN FND_API.G_EXC_ERROR THEN
798: ROLLBACK TO get_assign_resources;
799: x_return_status := FND_API.G_RET_STS_ERROR;
800: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
801:
802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
803: ROLLBACK TO get_assign_resources;
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

801:
802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
803: ROLLBACK TO get_assign_resources;
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
806:
807: WHEN OTHERS THEN
808: ROLLBACK TO get_assign_resources;
809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

806:
807: WHEN OTHERS THEN
808: ROLLBACK TO get_assign_resources;
809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
810: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
811: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
812: END IF;
813: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
814:

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

807: WHEN OTHERS THEN
808: ROLLBACK TO get_assign_resources;
809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
810: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
811: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
812: END IF;
813: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
814:
815: END get_assign_resources;

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

809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
810: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
811: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
812: END IF;
813: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
814:
815: END get_assign_resources;
816:
817: PROCEDURE get_assign_account_resources(p_api_version IN NUMBER := 1.0,

Line 937: FND_MSG_PUB.initialize;

933: END IF;
934:
935: -- Check p_init_msg_list
936: IF FND_API.to_Boolean( p_init_msg_list ) THEN
937: FND_MSG_PUB.initialize;
938: END IF;
939:
940: x_return_status := FND_API.G_RET_STS_SUCCESS;
941:

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

961: COMMIT WORK;
962: END IF;
963:
964: -- Standard call to get message count and if count is 1, get message info
965: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
966:
967: iex_debug_pub.logmessage ('**** END get_access_resources ************');
968:
969: EXCEPTION

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

969: EXCEPTION
970: WHEN FND_API.G_EXC_ERROR THEN
971: ROLLBACK TO get_assign_account_resources;
972: x_return_status := FND_API.G_RET_STS_ERROR;
973: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
974:
975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
976: ROLLBACK TO get_assign_account_resources;
977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

974:
975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
976: ROLLBACK TO get_assign_account_resources;
977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
978: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
979:
980: WHEN OTHERS THEN
981: ROLLBACK TO get_assign_account_resources;
982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

979:
980: WHEN OTHERS THEN
981: ROLLBACK TO get_assign_account_resources;
982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
983: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
984: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
985: END IF;
986: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
987:

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

980: WHEN OTHERS THEN
981: ROLLBACK TO get_assign_account_resources;
982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
983: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
984: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
985: END IF;
986: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
987:
988: END get_assign_account_resources;

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

982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
983: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
984: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
985: END IF;
986: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
987:
988: END get_assign_account_resources;
989:
990: PROCEDURE get_case_resources(p_api_version IN NUMBER := 1.0,

Line 1050: FND_MSG_PUB.initialize;

1046: END IF;
1047:
1048: -- Check p_init_msg_list
1049: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1050: FND_MSG_PUB.initialize;
1051: END IF;
1052:
1053: x_return_status := FND_API.G_RET_STS_SUCCESS;
1054:

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

1065: COMMIT WORK;
1066: END IF;
1067:
1068: -- Standard call to get message count and if count is 1, get message info
1069: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1070:
1071: iex_debug_pub.logmessage ('**** END get_case_resources ************');
1072:
1073: EXCEPTION

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

1073: EXCEPTION
1074: WHEN FND_API.G_EXC_ERROR THEN
1075: ROLLBACK TO get_case_resources;
1076: x_return_status := FND_API.G_RET_STS_ERROR;
1077: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1078:
1079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1080: ROLLBACK TO get_case_resources;
1081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1078:
1079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1080: ROLLBACK TO get_case_resources;
1081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1082: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1083:
1084: WHEN OTHERS THEN
1085: ROLLBACK TO get_case_resources;
1086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1083:
1084: WHEN OTHERS THEN
1085: ROLLBACK TO get_case_resources;
1086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1087: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1088: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1089: END IF;
1090: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1091:

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

1084: WHEN OTHERS THEN
1085: ROLLBACK TO get_case_resources;
1086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1087: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1088: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1089: END IF;
1090: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1091:
1092: END get_case_resources;*/

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

1086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1087: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1088: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1089: END IF;
1090: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1091:
1092: END get_case_resources;*/
1093: --End bug#5373412 schekuri 10-Jul-2006
1094:

Line 1262: FND_MSG_PUB.initialize;

1258: END IF;
1259:
1260: -- Check p_init_msg_list
1261: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1262: FND_MSG_PUB.initialize;
1263: END IF;
1264:
1265: x_return_status := FND_API.G_RET_STS_SUCCESS;
1266:

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

1277: COMMIT WORK;
1278: END IF;
1279:
1280: -- Standard call to get message count and if count is 1, get message info
1281: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1282:
1283: iex_debug_pub.logmessage ('**** END get_billto_resources ************');
1284:
1285: EXCEPTION

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

1285: EXCEPTION
1286: WHEN FND_API.G_EXC_ERROR THEN
1287: ROLLBACK TO get_assign_resources;
1288: x_return_status := FND_API.G_RET_STS_ERROR;
1289: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1290:
1291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1292: ROLLBACK TO get_assign_resources;
1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1290:
1291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1292: ROLLBACK TO get_assign_resources;
1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1294: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1295:
1296: WHEN OTHERS THEN
1297: ROLLBACK TO get_assign_resources;
1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1295:
1296: WHEN OTHERS THEN
1297: ROLLBACK TO get_assign_resources;
1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1299: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1300: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1301: END IF;
1302: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1303:

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

1296: WHEN OTHERS THEN
1297: ROLLBACK TO get_assign_resources;
1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1299: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1300: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1301: END IF;
1302: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1303:
1304: END get_billto_resources;*/

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

1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1299: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1300: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1301: END IF;
1302: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1303:
1304: END get_billto_resources;*/
1305: -- End- Andre 07/28/2004 - Add bill to assignmnet
1306: --End bug#5373412 schekuri 10-Jul-2006

Line 2173: FND_MSG_PUB.initialize;

2169: END IF;
2170:
2171: -- Check p_init_msg_list
2172: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2173: FND_MSG_PUB.initialize;
2174: END IF;
2175:
2176: x_return_status := FND_API.G_RET_STS_SUCCESS;
2177:

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

2389: COMMIT WORK;
2390: END IF;
2391:
2392: -- Standard call to get message count and if count is 1, get message info
2393: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2394:
2395: iex_debug_pub.logmessage ('**** END get_assigned_collector ************');
2396:
2397: EXCEPTION

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

2397: EXCEPTION
2398: WHEN FND_API.G_EXC_ERROR THEN
2399: ROLLBACK TO get_assigned_collector;
2400: x_return_status := FND_API.G_RET_STS_ERROR;
2401: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2402:
2403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2404: ROLLBACK TO get_assigned_collector;
2405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2402:
2403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2404: ROLLBACK TO get_assigned_collector;
2405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2406: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2407:
2408: WHEN OTHERS THEN
2409: ROLLBACK TO get_assigned_collector;
2410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2407:
2408: WHEN OTHERS THEN
2409: ROLLBACK TO get_assigned_collector;
2410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2411: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2412: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2413: END IF;
2414: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2415:

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

2408: WHEN OTHERS THEN
2409: ROLLBACK TO get_assigned_collector;
2410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2411: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2412: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2413: END IF;
2414: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2415:
2416: END get_assigned_collector;

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

2410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2411: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2412: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2413: END IF;
2414: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2415:
2416: END get_assigned_collector;
2417: --End bug#5373412 schekuri 10-Jul-2006
2418: