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 160: FND_MSG_PUB.initialize;

156: END IF;
157:
158: -- Check p_init_msg_list
159: IF FND_API.to_Boolean( p_init_msg_list ) THEN
160: FND_MSG_PUB.initialize;
161: END IF;
162:
163: x_return_status := FND_API.G_RET_STS_SUCCESS;
164:

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

202: COMMIT WORK;
203: END IF;
204:
205: -- Standard call to get message count and if count is 1, get message info
206: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
207:
208: EXCEPTION
209: WHEN FND_API.G_EXC_ERROR THEN
210: ROLLBACK TO Acct_Balance_PVT;

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

208: EXCEPTION
209: WHEN FND_API.G_EXC_ERROR THEN
210: ROLLBACK TO Acct_Balance_PVT;
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
213:
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: ROLLBACK TO Acct_Balance_PVT;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

213:
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: ROLLBACK TO Acct_Balance_PVT;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
218:
219: WHEN OTHERS THEN
220: ROLLBACK TO Acct_Balance_PVT;
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

218:
219: WHEN OTHERS THEN
220: ROLLBACK TO Acct_Balance_PVT;
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
223: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
224: END IF;
225: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
226:

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

219: WHEN OTHERS THEN
220: ROLLBACK TO Acct_Balance_PVT;
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
223: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
224: END IF;
225: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
226:
227: END Acct_Balance;

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

221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
223: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
224: END IF;
225: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
226:
227: END Acct_Balance;
228:
229: PROCEDURE Validate_any_id(p_api_version IN NUMBER := 1.0,

Line 287: FND_MSG_PUB.initialize;

283:
284: -- Initialize message list if p_init_msg_list is set to TRUE.
285: IF FND_API.to_Boolean(p_init_msg_list)
286: THEN
287: FND_MSG_PUB.initialize;
288: END IF;
289:
290: -- API body
291: -- clchang updated for sql bind var 05/07/2003

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

330: EXCEPTION
331: WHEN FND_API.G_EXC_ERROR THEN
332: ROLLBACK TO Validate_any_id_PVT;
333: x_return_status := FND_API.G_RET_STS_ERROR;
334: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
335:
336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
337: ROLLBACK TO Validate_any_id_PVT;
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

335:
336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
337: ROLLBACK TO Validate_any_id_PVT;
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
340:
341: WHEN OTHERS THEN
342: ROLLBACK TO Validate_any_id_PVT;
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

340:
341: WHEN OTHERS THEN
342: ROLLBACK TO Validate_any_id_PVT;
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
345: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
346: END IF;
347: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
348:

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

341: WHEN OTHERS THEN
342: ROLLBACK TO Validate_any_id_PVT;
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
345: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
346: END IF;
347: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
348:
349: END Validate_any_id;

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

343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
345: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
346: END IF;
347: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
348:
349: END Validate_any_id;
350:
351: PROCEDURE Validate_any_varchar(p_api_version IN NUMBER := 1.0,

Line 411: FND_MSG_PUB.initialize;

407:
408: -- Initialize message list if p_init_msg_list is set to TRUE.
409: IF FND_API.to_Boolean(p_init_msg_list)
410: THEN
411: FND_MSG_PUB.initialize;
412: END IF;
413:
414: -- API body
415: --dbms_output.put_line('col is ' || p_col_value);

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

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

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

454:
455: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
456: ROLLBACK TO Validate_any_varchar_PVT;
457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
458: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
459:
460: WHEN OTHERS THEN
461: ROLLBACK TO Validate_any_varchar_PVT;
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

459:
460: WHEN OTHERS THEN
461: ROLLBACK TO Validate_any_varchar_PVT;
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
463: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
464: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
465: END IF;
466: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
467:

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

460: WHEN OTHERS THEN
461: ROLLBACK TO Validate_any_varchar_PVT;
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
463: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
464: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
465: END IF;
466: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
467:
468: END Validate_any_varchar;

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

462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
463: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
464: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
465: END IF;
466: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
467:
468: END Validate_any_varchar;
469:
470: PROCEDURE Validate_Lookup_CODE(p_api_version IN NUMBER := 1.0,

Line 526: FND_MSG_PUB.initialize;

522:
523: -- Initialize message list if p_init_msg_list is set to TRUE.
524: IF FND_API.to_Boolean(p_init_msg_list)
525: THEN
526: FND_MSG_PUB.initialize;
527: END IF;
528:
529: -- API body
530: l_lookup_code := '''' || p_lookup_code || '''';

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

586: EXCEPTION
587: WHEN FND_API.G_EXC_ERROR THEN
588: ROLLBACK TO Validate_any_varchar_PVT;
589: x_return_status := FND_API.G_RET_STS_ERROR;
590: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
591:
592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
593: ROLLBACK TO Validate_any_varchar_PVT;
594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

591:
592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
593: ROLLBACK TO Validate_any_varchar_PVT;
594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
595: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
596:
597: WHEN OTHERS THEN
598: ROLLBACK TO Validate_any_varchar_PVT;
599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

596:
597: WHEN OTHERS THEN
598: ROLLBACK TO Validate_any_varchar_PVT;
599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
600: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
601: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
602: END IF;
603: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
604:

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

597: WHEN OTHERS THEN
598: ROLLBACK TO Validate_any_varchar_PVT;
599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
600: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
601: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
602: END IF;
603: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
604:
605: END Validate_LOOKUP_CODE;

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

599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
600: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
601: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
602: END IF;
603: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
604:
605: END Validate_LOOKUP_CODE;
606:
607: -- added by jypark 03052002

Line 669: FND_MSG_PUB.initialize;

665: END IF;
666:
667: -- Check p_init_msg_list
668: IF FND_API.to_Boolean( p_init_msg_list ) THEN
669: FND_MSG_PUB.initialize;
670: END IF;
671:
672: x_return_status := FND_API.G_RET_STS_SUCCESS;
673:

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

699: COMMIT WORK;
700: END IF;
701:
702: -- Standard call to get message count and if count is 1, get message info
703: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
704:
705: IF PG_DEBUG < 10 THEN
706: iex_debug_pub.logmessage ('**** END get_access_resources ************');
707: END IF;

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

709: EXCEPTION
710: WHEN FND_API.G_EXC_ERROR THEN
711: ROLLBACK TO Access_Resources_Pvt;
712: x_return_status := FND_API.G_RET_STS_ERROR;
713: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
714:
715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
716: ROLLBACK TO Access_Resources_Pvt;
717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

714:
715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
716: ROLLBACK TO Access_Resources_Pvt;
717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
718: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
719:
720: WHEN OTHERS THEN
721: ROLLBACK TO Access_Resources_Pvt;
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

719:
720: WHEN OTHERS THEN
721: ROLLBACK TO Access_Resources_Pvt;
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
723: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
724: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
725: END IF;
726: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
727:

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

720: WHEN OTHERS THEN
721: ROLLBACK TO Access_Resources_Pvt;
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
723: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
724: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
725: END IF;
726: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
727:
728: END get_access_resources;

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

722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
723: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
724: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
725: END IF;
726: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
727:
728: END get_access_resources;
729:
730: PROCEDURE get_assign_resources(p_api_version IN NUMBER := 1.0,

Line 873: FND_MSG_PUB.initialize;

869: END IF;
870:
871: -- Check p_init_msg_list
872: IF FND_API.to_Boolean( p_init_msg_list ) THEN
873: FND_MSG_PUB.initialize;
874: END IF;
875:
876: x_return_status := FND_API.G_RET_STS_SUCCESS;
877:

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

897: COMMIT WORK;
898: END IF;
899:
900: -- Standard call to get message count and if count is 1, get message info
901: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
902:
903: iex_debug_pub.logmessage ('**** END get_access_resources ************');
904:
905: EXCEPTION

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

905: EXCEPTION
906: WHEN FND_API.G_EXC_ERROR THEN
907: ROLLBACK TO get_assign_resources;
908: x_return_status := FND_API.G_RET_STS_ERROR;
909: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
910:
911: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
912: ROLLBACK TO get_assign_resources;
913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

915:
916: WHEN OTHERS THEN
917: ROLLBACK TO get_assign_resources;
918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
919: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
920: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
921: END IF;
922: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
923:

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

916: WHEN OTHERS THEN
917: ROLLBACK TO get_assign_resources;
918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
919: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
920: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
921: END IF;
922: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
923:
924: END get_assign_resources;

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

918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
919: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
920: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
921: END IF;
922: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
923:
924: END get_assign_resources;
925:
926: PROCEDURE get_assign_account_resources(p_api_version IN NUMBER := 1.0,

Line 1046: FND_MSG_PUB.initialize;

1042: END IF;
1043:
1044: -- Check p_init_msg_list
1045: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1046: FND_MSG_PUB.initialize;
1047: END IF;
1048:
1049: x_return_status := FND_API.G_RET_STS_SUCCESS;
1050:

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

1070: COMMIT WORK;
1071: END IF;
1072:
1073: -- Standard call to get message count and if count is 1, get message info
1074: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1075:
1076: iex_debug_pub.logmessage ('**** END get_access_resources ************');
1077:
1078: EXCEPTION

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

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

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

1083:
1084: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1085: ROLLBACK TO get_assign_account_resources;
1086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1087: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1088:
1089: WHEN OTHERS THEN
1090: ROLLBACK TO get_assign_account_resources;
1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1088:
1089: WHEN OTHERS THEN
1090: ROLLBACK TO get_assign_account_resources;
1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1092: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1093: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1094: END IF;
1095: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1096:

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

1089: WHEN OTHERS THEN
1090: ROLLBACK TO get_assign_account_resources;
1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1092: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1093: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1094: END IF;
1095: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1096:
1097: END get_assign_account_resources;

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

1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1092: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1093: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1094: END IF;
1095: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1096:
1097: END get_assign_account_resources;
1098:
1099: PROCEDURE get_case_resources(p_api_version IN NUMBER := 1.0,

Line 1159: FND_MSG_PUB.initialize;

1155: END IF;
1156:
1157: -- Check p_init_msg_list
1158: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1159: FND_MSG_PUB.initialize;
1160: END IF;
1161:
1162: x_return_status := FND_API.G_RET_STS_SUCCESS;
1163:

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

1174: COMMIT WORK;
1175: END IF;
1176:
1177: -- Standard call to get message count and if count is 1, get message info
1178: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1179:
1180: iex_debug_pub.logmessage ('**** END get_case_resources ************');
1181:
1182: EXCEPTION

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

1182: EXCEPTION
1183: WHEN FND_API.G_EXC_ERROR THEN
1184: ROLLBACK TO get_case_resources;
1185: x_return_status := FND_API.G_RET_STS_ERROR;
1186: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1187:
1188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1189: ROLLBACK TO get_case_resources;
1190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1187:
1188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1189: ROLLBACK TO get_case_resources;
1190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1191: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1192:
1193: WHEN OTHERS THEN
1194: ROLLBACK TO get_case_resources;
1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1192:
1193: WHEN OTHERS THEN
1194: ROLLBACK TO get_case_resources;
1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1196: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1197: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1198: END IF;
1199: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1200:

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

1193: WHEN OTHERS THEN
1194: ROLLBACK TO get_case_resources;
1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1196: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1197: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1198: END IF;
1199: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1200:
1201: END get_case_resources;*/

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

1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1196: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1197: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1198: END IF;
1199: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1200:
1201: END get_case_resources;*/
1202: --End bug#5373412 schekuri 10-Jul-2006
1203:

Line 1371: FND_MSG_PUB.initialize;

1367: END IF;
1368:
1369: -- Check p_init_msg_list
1370: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1371: FND_MSG_PUB.initialize;
1372: END IF;
1373:
1374: x_return_status := FND_API.G_RET_STS_SUCCESS;
1375:

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

1386: COMMIT WORK;
1387: END IF;
1388:
1389: -- Standard call to get message count and if count is 1, get message info
1390: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1391:
1392: iex_debug_pub.logmessage ('**** END get_billto_resources ************');
1393:
1394: EXCEPTION

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

1394: EXCEPTION
1395: WHEN FND_API.G_EXC_ERROR THEN
1396: ROLLBACK TO get_assign_resources;
1397: x_return_status := FND_API.G_RET_STS_ERROR;
1398: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1399:
1400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1401: ROLLBACK TO get_assign_resources;
1402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1399:
1400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1401: ROLLBACK TO get_assign_resources;
1402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1403: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1404:
1405: WHEN OTHERS THEN
1406: ROLLBACK TO get_assign_resources;
1407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1404:
1405: WHEN OTHERS THEN
1406: ROLLBACK TO get_assign_resources;
1407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1408: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1409: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1410: END IF;
1411: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1412:

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

1405: WHEN OTHERS THEN
1406: ROLLBACK TO get_assign_resources;
1407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1408: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1409: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1410: END IF;
1411: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1412:
1413: END get_billto_resources;*/

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

1407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1408: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1409: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1410: END IF;
1411: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1412:
1413: END get_billto_resources;*/
1414: -- End- Andre 07/28/2004 - Add bill to assignmnet
1415: --End bug#5373412 schekuri 10-Jul-2006

Line 4938: FND_MSG_PUB.initialize;

4934: END IF;
4935:
4936: -- Check p_init_msg_list
4937: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4938: FND_MSG_PUB.initialize;
4939: END IF;
4940:
4941: x_return_status := FND_API.G_RET_STS_SUCCESS;
4942:

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

5177: COMMIT WORK;
5178: END IF;
5179:
5180: -- Standard call to get message count and if count is 1, get message info
5181: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5182:
5183: iex_debug_pub.logmessage ('**** END get_assigned_collector ************');
5184:
5185: EXCEPTION

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

5185: EXCEPTION
5186: WHEN FND_API.G_EXC_ERROR THEN
5187: ROLLBACK TO get_assigned_collector;
5188: x_return_status := FND_API.G_RET_STS_ERROR;
5189: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5190:
5191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5192: ROLLBACK TO get_assigned_collector;
5193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

5190:
5191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5192: ROLLBACK TO get_assigned_collector;
5193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5194: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5195:
5196: WHEN OTHERS THEN
5197: ROLLBACK TO get_assigned_collector;
5198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

5195:
5196: WHEN OTHERS THEN
5197: ROLLBACK TO get_assigned_collector;
5198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5199: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5200: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5201: END IF;
5202: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5203:

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

5196: WHEN OTHERS THEN
5197: ROLLBACK TO get_assigned_collector;
5198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5199: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5200: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5201: END IF;
5202: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5203:
5204: END get_assigned_collector;

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

5198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5199: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5200: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5201: END IF;
5202: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5203:
5204: END get_assigned_collector;
5205: --End bug#5373412 schekuri 10-Jul-2006
5206:

Line 5259: FND_MSG_PUB.initialize;

5255: END IF;
5256:
5257: -- Check p_init_msg_list
5258: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5259: FND_MSG_PUB.initialize;
5260: END IF;
5261:
5262: x_return_status := FND_API.G_RET_STS_SUCCESS;
5263:

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

5327: COMMIT WORK;
5328: END IF;
5329:
5330: -- Standard call to get message count and if count is 1, get message info
5331: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5332:
5333: iex_debug_pub.logmessage ('**** END get_dunning_resource ************');
5334:
5335: EXCEPTION

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

5335: EXCEPTION
5336: WHEN FND_API.G_EXC_ERROR THEN
5337: ROLLBACK TO get_dunning_resource;
5338: x_return_status := FND_API.G_RET_STS_ERROR;
5339: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5340:
5341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5342: ROLLBACK TO get_dunning_resource;
5343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

5340:
5341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5342: ROLLBACK TO get_dunning_resource;
5343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5344: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5345:
5346: WHEN OTHERS THEN
5347: ROLLBACK TO get_dunning_resource;
5348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

5345:
5346: WHEN OTHERS THEN
5347: ROLLBACK TO get_dunning_resource;
5348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5349: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5350: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5351: END IF;
5352: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5353:

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

5346: WHEN OTHERS THEN
5347: ROLLBACK TO get_dunning_resource;
5348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5349: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5350: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5351: END IF;
5352: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5353:
5354: END get_dunning_resource;

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

5348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5349: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5350: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5351: END IF;
5352: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5353:
5354: END get_dunning_resource;
5355: --End adding for bug 9162623 gnramasa 2nd Dec 09
5356:

Line 5418: FND_MSG_PUB.initialize;

5414: END IF;
5415:
5416: -- Check p_init_msg_list
5417: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5418: FND_MSG_PUB.initialize;
5419: END IF;
5420:
5421: x_return_status := FND_API.G_RET_STS_SUCCESS;
5422:

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

5450: COMMIT WORK;
5451: END IF;
5452:
5453: -- Standard call to get message count and if count is 1, get message info
5454: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5455:
5456: iex_debug_pub.logmessage ('**** END get_grace_days ************');
5457:
5458: EXCEPTION

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

5458: EXCEPTION
5459: WHEN FND_API.G_EXC_ERROR THEN
5460: ROLLBACK TO get_grace_days;
5461: x_return_status := FND_API.G_RET_STS_ERROR;
5462: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5463:
5464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5465: ROLLBACK TO get_grace_days;
5466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

5463:
5464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5465: ROLLBACK TO get_grace_days;
5466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5467: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5468:
5469: WHEN OTHERS THEN
5470: ROLLBACK TO get_grace_days;
5471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

5468:
5469: WHEN OTHERS THEN
5470: ROLLBACK TO get_grace_days;
5471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5472: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5473: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5474: END IF;
5475: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5476:

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

5469: WHEN OTHERS THEN
5470: ROLLBACK TO get_grace_days;
5471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5472: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5473: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5474: END IF;
5475: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5476:
5477: END get_grace_days;

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

5471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5472: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5473: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5474: END IF;
5475: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5476:
5477: END get_grace_days;
5478: --End adding for staged dunning gnramasa 7th Dec 09
5479: