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

Line 10: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

6:
7: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
8: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
9:
10: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
11: --G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
12: OZF_UNEXP_ERROR_ON BOOLEAN :=FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error);
13: OZF_ERROR_ON BOOLEAN := FND_MSG_PUB.check_msg_level(fnd_msg_pub.g_msg_lvl_error);
14: G_DEBUG BOOLEAN := true ;--FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

Line 11: --G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);

7: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
8: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
9:
10: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
11: --G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
12: OZF_UNEXP_ERROR_ON BOOLEAN :=FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error);
13: OZF_ERROR_ON BOOLEAN := FND_MSG_PUB.check_msg_level(fnd_msg_pub.g_msg_lvl_error);
14: G_DEBUG BOOLEAN := true ;--FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
15:

Line 12: OZF_UNEXP_ERROR_ON BOOLEAN :=FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error);

8: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
9:
10: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
11: --G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
12: OZF_UNEXP_ERROR_ON BOOLEAN :=FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error);
13: OZF_ERROR_ON BOOLEAN := FND_MSG_PUB.check_msg_level(fnd_msg_pub.g_msg_lvl_error);
14: G_DEBUG BOOLEAN := true ;--FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
15:
16: --Defining Global Value as Update_user_status, parametes are already defined

Line 13: OZF_ERROR_ON BOOLEAN := FND_MSG_PUB.check_msg_level(fnd_msg_pub.g_msg_lvl_error);

9:
10: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
11: --G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
12: OZF_UNEXP_ERROR_ON BOOLEAN :=FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error);
13: OZF_ERROR_ON BOOLEAN := FND_MSG_PUB.check_msg_level(fnd_msg_pub.g_msg_lvl_error);
14: G_DEBUG BOOLEAN := true ;--FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
15:
16: --Defining Global Value as Update_user_status, parametes are already defined
17: G_FORWARD_USER NUMBER;

Line 14: G_DEBUG BOOLEAN := true ;--FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

10: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
11: --G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
12: OZF_UNEXP_ERROR_ON BOOLEAN :=FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error);
13: OZF_ERROR_ON BOOLEAN := FND_MSG_PUB.check_msg_level(fnd_msg_pub.g_msg_lvl_error);
14: G_DEBUG BOOLEAN := true ;--FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
15:
16: --Defining Global Value as Update_user_status, parametes are already defined
17: G_FORWARD_USER NUMBER;
18:

Line 165: FND_MSG_PUB.initialize;

161: ozf_utility_pvt.debug_message( l_api_name||': Start');
162: END IF;
163: --Initialize message list if p_init_msg_list is TRUE.
164: IF FND_API.To_Boolean (p_init_msg_list) THEN
165: FND_MSG_PUB.initialize;
166: END IF;
167: -- Initialize API return status to sucess
168: x_return_status := FND_API.G_RET_STS_SUCCESS;
169:

Line 197: FND_MSG_PUB.Count_And_Get (

193: OPEN csr_count_approvers(p_approval_rec.object_type, p_approval_rec.object_id);
194: FETCH csr_count_approvers INTO l_approver_rec_count ;
195: CLOSE csr_count_approvers;
196: if l_approver_rec_count = 0 then
197: FND_MSG_PUB.Count_And_Get (
198: p_encoded => FND_API.G_FALSE,
199: p_count => x_msg_count,
200: p_data => x_msg_data
201: );

Line 427: FND_MSG_PUB.Count_And_Get (

423: IF G_DEBUG THEN
424: ozf_utility_pvt.debug_message( l_api_name||': End');
425: END IF;
426: --Standard call to get message count and if count=1, get the message
427: FND_MSG_PUB.Count_And_Get (
428: p_encoded => FND_API.G_FALSE,
429: p_count => x_msg_count,
430: p_data => x_msg_data
431: );

Line 437: FND_MSG_PUB.Count_And_Get (

433: WHEN FND_API.G_EXC_ERROR THEN
434: ROLLBACK TO Update_User_Action_PVT;
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: -- Standard call to get message count and if count=1, get the message
437: FND_MSG_PUB.Count_And_Get (
438: p_encoded => FND_API.G_FALSE,
439: p_count => x_msg_count,
440: p_data => x_msg_data
441: );

Line 446: FND_MSG_PUB.Count_And_Get (

442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
443: ROLLBACK TO Update_User_Action_PVT;
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445: -- Standard call to get message count and if count=1, get the message
446: FND_MSG_PUB.Count_And_Get (
447: p_encoded => FND_API.G_FALSE,
448: p_count => x_msg_count,
449: p_data => x_msg_data
450: );

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

452: ROLLBACK TO Update_User_Action_PVT;
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
454: IF OZF_UNEXP_ERROR_ON
455: THEN
456: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
457: END IF;
458: -- Standard call to get message count and if count=1, get the message
459: FND_MSG_PUB.Count_And_Get (
460: p_encoded => FND_API.G_FALSE,

Line 459: FND_MSG_PUB.Count_And_Get (

455: THEN
456: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
457: END IF;
458: -- Standard call to get message count and if count=1, get the message
459: FND_MSG_PUB.Count_And_Get (
460: p_encoded => FND_API.G_FALSE,
461: p_count => x_msg_count,
462: p_data => x_msg_data
463: );

Line 526: FND_MSG_PUB.initialize;

522: ozf_utility_pvt.debug_message( l_api_name||': Start');
523: END IF;
524: --Initialize message list if p_init_msg_list is TRUE.
525: IF FND_API.To_Boolean (p_init_msg_list) THEN
526: FND_MSG_PUB.initialize;
527: END IF;
528: -- Initialize API return status to sucess
529: x_return_status := FND_API.G_RET_STS_SUCCESS;
530:

Line 638: FND_MSG_PUB.Count_And_Get (

634: ozf_utility_pvt.debug_message( l_api_name||': End' || x_approvers(1).approver_id);
635: END IF;
636: */
637: --Standard call to get message count and if count=1, get the message
638: FND_MSG_PUB.Count_And_Get (
639: p_encoded => FND_API.G_FALSE,
640: p_count => x_msg_count,
641: p_data => x_msg_data
642: );

Line 648: FND_MSG_PUB.Count_And_Get (

644: WHEN FND_API.G_EXC_ERROR THEN
645: ROLLBACK TO Get_Approvers_PVT;
646: x_return_status := FND_API.G_RET_STS_ERROR;
647: -- Standard call to get message count and if count=1, get the message
648: FND_MSG_PUB.Count_And_Get (
649: p_encoded => FND_API.G_FALSE,
650: p_count => x_msg_count,
651: p_data => x_msg_data
652: );

Line 657: FND_MSG_PUB.Count_And_Get (

653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
654: ROLLBACK TO Get_Approvers_PVT;
655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
656: -- Standard call to get message count and if count=1, get the message
657: FND_MSG_PUB.Count_And_Get (
658: p_encoded => FND_API.G_FALSE,
659: p_count => x_msg_count,
660: p_data => x_msg_data
661: );

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

663: ROLLBACK TO Get_Approvers_PVT;
664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
665: IF OZF_UNEXP_ERROR_ON
666: THEN
667: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
668: END IF;
669: -- Standard call to get message count and if count=1, get the message
670: FND_MSG_PUB.Count_And_Get (
671: p_encoded => FND_API.G_FALSE,

Line 670: FND_MSG_PUB.Count_And_Get (

666: THEN
667: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
668: END IF;
669: -- Standard call to get message count and if count=1, get the message
670: FND_MSG_PUB.Count_And_Get (
671: p_encoded => FND_API.G_FALSE,
672: p_count => x_msg_count,
673: p_data => x_msg_data
674: );

Line 728: FND_MSG_PUB.initialize;

724: ozf_utility_pvt.debug_message( l_api_name||': Start');
725: END IF;
726: --Initialize message list if p_init_msg_list is TRUE.
727: IF FND_API.To_Boolean (p_init_msg_list) THEN
728: FND_MSG_PUB.initialize;
729: END IF;
730: -- Initialize API return status to sucess
731: x_return_status := FND_API.G_RET_STS_SUCCESS;
732:

Line 836: FND_MSG_PUB.Count_And_Get (

832: IF G_DEBUG THEN
833: ozf_utility_pvt.debug_message( l_api_name||': End');
834: END IF;
835: --Standard call to get message count and if count=1, get the message
836: FND_MSG_PUB.Count_And_Get (
837: p_encoded => FND_API.G_FALSE,
838: p_count => x_msg_count,
839: p_data => x_msg_data
840: );

Line 846: FND_MSG_PUB.Count_And_Get (

842: WHEN FND_API.G_EXC_ERROR THEN
843: ROLLBACK TO Add_Access_PVT;
844: x_return_status := FND_API.G_RET_STS_ERROR;
845: -- Standard call to get message count and if count=1, get the message
846: FND_MSG_PUB.Count_And_Get (
847: p_encoded => FND_API.G_FALSE,
848: p_count => x_msg_count,
849: p_data => x_msg_data
850: );

Line 855: FND_MSG_PUB.Count_And_Get (

851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
852: ROLLBACK TO Add_Access_PVT;
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
854: -- Standard call to get message count and if count=1, get the message
855: FND_MSG_PUB.Count_And_Get (
856: p_encoded => FND_API.G_FALSE,
857: p_count => x_msg_count,
858: p_data => x_msg_data
859: );

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

861: ROLLBACK TO Add_Access_PVT;
862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
863: IF OZF_UNEXP_ERROR_ON
864: THEN
865: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
866: END IF;
867: -- Standard call to get message count and if count=1, get the message
868: FND_MSG_PUB.Count_And_Get (
869: p_encoded => FND_API.G_FALSE,

Line 868: FND_MSG_PUB.Count_And_Get (

864: THEN
865: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
866: END IF;
867: -- Standard call to get message count and if count=1, get the message
868: FND_MSG_PUB.Count_And_Get (
869: p_encoded => FND_API.G_FALSE,
870: p_count => x_msg_count,
871: p_data => x_msg_data
872: );

Line 927: FND_MSG_PUB.Add;

923: -- Debug Message
924: IF G_DEBUG THEN
925: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
926: FND_MESSAGE.Set_Token('TEXT',l_api_name||': Start');
927: FND_MSG_PUB.Add;
928: END IF;
929: --Initialize message list if p_init_msg_list is TRUE.
930: IF FND_API.To_Boolean (p_init_msg_list) THEN
931: FND_MSG_PUB.initialize;

Line 931: FND_MSG_PUB.initialize;

927: FND_MSG_PUB.Add;
928: END IF;
929: --Initialize message list if p_init_msg_list is TRUE.
930: IF FND_API.To_Boolean (p_init_msg_list) THEN
931: FND_MSG_PUB.initialize;
932: END IF;
933: -- Initialize API return status to sucess
934: x_return_status := FND_API.G_RET_STS_SUCCESS;
935:

Line 961: FND_MSG_PUB.Count_And_Get (

957: IF G_DEBUG THEN
958: ozf_utility_pvt.debug_message( l_api_name||': End');
959: END IF;
960: --Standard call to get message count and if count=1, get the message
961: FND_MSG_PUB.Count_And_Get (
962: p_encoded => FND_API.G_FALSE,
963: p_count => x_msg_count,
964: p_data => x_msg_data
965: );

Line 971: FND_MSG_PUB.Count_And_Get (

967: WHEN FND_API.G_EXC_ERROR THEN
968: ROLLBACK TO Revoke_Access_PVT;
969: x_return_status := FND_API.G_RET_STS_ERROR;
970: -- Standard call to get message count and if count=1, get the message
971: FND_MSG_PUB.Count_And_Get (
972: p_encoded => FND_API.G_FALSE,
973: p_count => x_msg_count,
974: p_data => x_msg_data
975: );

Line 980: FND_MSG_PUB.Count_And_Get (

976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
977: ROLLBACK TO Revoke_Access_PVT;
978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
979: -- Standard call to get message count and if count=1, get the message
980: FND_MSG_PUB.Count_And_Get (
981: p_encoded => FND_API.G_FALSE,
982: p_count => x_msg_count,
983: p_data => x_msg_data
984: );

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

986: ROLLBACK TO Revoke_Access_PVT;
987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
988: IF OZF_UNEXP_ERROR_ON
989: THEN
990: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
991: END IF;
992: -- Standard call to get message count and if count=1, get the message
993: FND_MSG_PUB.Count_And_Get (
994: p_encoded => FND_API.G_FALSE,

Line 993: FND_MSG_PUB.Count_And_Get (

989: THEN
990: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
991: END IF;
992: -- Standard call to get message count and if count=1, get the message
993: FND_MSG_PUB.Count_And_Get (
994: p_encoded => FND_API.G_FALSE,
995: p_count => x_msg_count,
996: p_data => x_msg_data
997: );

Line 1178: FND_MSG_PUB.Count_And_Get (

1174: WHEN FND_API.G_EXC_ERROR THEN
1175: ROLLBACK TO Raise_Event_PVT;
1176: x_return_status := FND_API.G_RET_STS_ERROR;
1177: -- Standard call to get message count and if count=1, get the message
1178: FND_MSG_PUB.Count_And_Get (
1179: p_encoded => FND_API.G_FALSE,
1180: p_count => x_msg_count,
1181: p_data => x_msg_data
1182: );

Line 1187: FND_MSG_PUB.Count_And_Get (

1183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1184: ROLLBACK TO Raise_Event_PVT;
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1186: -- Standard call to get message count and if count=1, get the message
1187: FND_MSG_PUB.Count_And_Get (
1188: p_encoded => FND_API.G_FALSE,
1189: p_count => x_msg_count,
1190: p_data => x_msg_data
1191: );

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

1193: ROLLBACK TO Raise_Event_PVT;
1194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1195: IF OZF_UNEXP_ERROR_ON
1196: THEN
1197: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1198: END IF;
1199: -- Standard call to get message count and if count=1, get the message
1200: FND_MSG_PUB.Count_And_Get (
1201: p_encoded => FND_API.G_FALSE,

Line 1200: FND_MSG_PUB.Count_And_Get (

1196: THEN
1197: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1198: END IF;
1199: -- Standard call to get message count and if count=1, get the message
1200: FND_MSG_PUB.Count_And_Get (
1201: p_encoded => FND_API.G_FALSE,
1202: p_count => x_msg_count,
1203: p_data => x_msg_data
1204: );

Line 1333: FND_MSG_PUB.initialize;

1329: ozf_utility_pvt.debug_message( l_api_name||': Start');
1330: END IF;
1331: --Initialize message list if p_init_msg_list is TRUE.
1332: IF FND_API.To_Boolean (p_init_msg_list) THEN
1333: FND_MSG_PUB.initialize;
1334: END IF;
1335: -- Initialize API return status to sucess
1336: x_return_status := FND_API.G_RET_STS_SUCCESS;
1337:

Line 1516: FND_MSG_PUB.Count_And_Get (

1512: IF G_DEBUG THEN
1513: ozf_utility_pvt.debug_message( l_api_name||': End');
1514: END IF;
1515: --Standard call to get message count and if count=1, get the message
1516: FND_MSG_PUB.Count_And_Get (
1517: p_encoded => FND_API.G_FALSE,
1518: p_count => x_msg_count,
1519: p_data => x_msg_data
1520: );

Line 1526: FND_MSG_PUB.Count_And_Get (

1522: WHEN FND_API.G_EXC_ERROR THEN
1523: ROLLBACK TO Send_Notification_PVT;
1524: x_return_status := FND_API.G_RET_STS_ERROR;
1525: -- Standard call to get message count and if count=1, get the message
1526: FND_MSG_PUB.Count_And_Get (
1527: p_encoded => FND_API.G_FALSE,
1528: p_count => x_msg_count,
1529: p_data => x_msg_data
1530: );

Line 1535: FND_MSG_PUB.Count_And_Get (

1531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1532: ROLLBACK TO Send_Notification_PVT;
1533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1534: -- Standard call to get message count and if count=1, get the message
1535: FND_MSG_PUB.Count_And_Get (
1536: p_encoded => FND_API.G_FALSE,
1537: p_count => x_msg_count,
1538: p_data => x_msg_data
1539: );

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

1542: ROLLBACK TO Send_Notification_PVT;
1543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1544: IF OZF_UNEXP_ERROR_ON
1545: THEN
1546: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1547: END IF;
1548: -- Standard call to get message count and if count=1, get the message
1549: FND_MSG_PUB.Count_And_Get (
1550: p_encoded => FND_API.G_FALSE,

Line 1549: FND_MSG_PUB.Count_And_Get (

1545: THEN
1546: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1547: END IF;
1548: -- Standard call to get message count and if count=1, get the message
1549: FND_MSG_PUB.Count_And_Get (
1550: p_encoded => FND_API.G_FALSE,
1551: p_count => x_msg_count,
1552: p_data => x_msg_data
1553: );

Line 1630: FND_MSG_PUB.initialize;

1626: ozf_utility_pvt.debug_message( l_api_name||': Start');
1627: END IF;
1628: --Initialize message list if p_init_msg_list is TRUE.
1629: IF FND_API.To_Boolean (p_init_msg_list) THEN
1630: FND_MSG_PUB.initialize;
1631: END IF;
1632: -- Initialize API return status to sucess
1633: x_return_status := FND_API.G_RET_STS_SUCCESS;
1634:

Line 1871: FND_MSG_PUB.Count_And_Get (

1867: IF G_DEBUG THEN
1868: ozf_utility_pvt.debug_message( l_api_name||': End');
1869: END IF;
1870: --Standard call to get message count and if count=1, get the message
1871: FND_MSG_PUB.Count_And_Get (
1872: p_encoded => FND_API.G_FALSE,
1873: p_count => x_msg_count,
1874: p_data => x_msg_data
1875: );

Line 1882: FND_MSG_PUB.Count_And_Get (

1878: WHEN FND_API.G_EXC_ERROR THEN
1879: ROLLBACK TO Process_User_Action_PVT;
1880: x_return_status := FND_API.G_RET_STS_ERROR;
1881: -- Standard call to get message count and if count=1, get the message
1882: FND_MSG_PUB.Count_And_Get (
1883: p_encoded => FND_API.G_FALSE,
1884: p_count => x_msg_count,
1885: p_data => x_msg_data
1886: );

Line 1891: FND_MSG_PUB.Count_And_Get (

1887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1888: ROLLBACK TO Process_User_Action_PVT;
1889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1890: -- Standard call to get message count and if count=1, get the message
1891: FND_MSG_PUB.Count_And_Get (
1892: p_encoded => FND_API.G_FALSE,
1893: p_count => x_msg_count,
1894: p_data => x_msg_data
1895: );

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

1897: ROLLBACK TO Process_User_Action_PVT;
1898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1899: IF OZF_UNEXP_ERROR_ON
1900: THEN
1901: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1902: END IF;
1903: -- Standard call to get message count and if count=1, get the message
1904: FND_MSG_PUB.Count_And_Get (
1905: p_encoded => FND_API.G_FALSE,

Line 1904: FND_MSG_PUB.Count_And_Get (

1900: THEN
1901: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1902: END IF;
1903: -- Standard call to get message count and if count=1, get the message
1904: FND_MSG_PUB.Count_And_Get (
1905: p_encoded => FND_API.G_FALSE,
1906: p_count => x_msg_count,
1907: p_data => x_msg_data
1908: );

Line 1927: fnd_msg_pub.initialize;

1923: l_final_approval varchar2(1);
1924: l_approver_id number;
1925:
1926: begin
1927: fnd_msg_pub.initialize;
1928:
1929: --l_approval_rec.object_type := 'SPECIAL_PRICE';
1930: l_approval_rec.object_type := 'SOFT_FUND';
1931: l_approval_rec.object_id := 159;

Line 1962: ozf_utility_pvt.debug_message(substr(fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F'), 1, 254));

1958: ozf_utility_pvt.debug_message(l_msg_count);
1959: ozf_utility_pvt.debug_message('approval: ' ||l_final_approval);
1960:
1961: for i in 1..l_msg_count loop
1962: ozf_utility_pvt.debug_message(substr(fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F'), 1, 254));
1963: end loop;
1964:
1965: -- FOR i in 1..l_approvers_tbl.count LOOP
1966: -- ozf_utility_pvt.debug_message('Approver Id ' || l_approvers_tbl(i).APPROVER_ID);

Line 2062: FND_MSG_PUB.initialize;

2058: ozf_utility_pvt.debug_message( l_api_name||': Start');
2059: END IF;
2060: --Initialize message list if p_init_msg_list is TRUE.
2061: IF FND_API.To_Boolean (p_init_msg_list) THEN
2062: FND_MSG_PUB.initialize;
2063: END IF;
2064: -- Initialize API return status to sucess
2065: x_return_status := FND_API.G_RET_STS_SUCCESS;
2066: -- If action code is SUBMIT get the approver list from AME setup

Line 2215: FND_MSG_PUB.Count_And_Get (

2211: IF G_DEBUG THEN
2212: ozf_utility_pvt.debug_message( l_api_name||': End');
2213: END IF;
2214: --Standard call to get message count and if count=1, get the message
2215: FND_MSG_PUB.Count_And_Get (
2216: p_encoded => FND_API.G_FALSE,
2217: p_count => x_msg_count,
2218: p_data => x_msg_data
2219: );

Line 2226: FND_MSG_PUB.Count_And_Get (

2222: WHEN FND_API.G_EXC_ERROR THEN
2223: ROLLBACK TO Process_SD_Approval;
2224: x_return_status := FND_API.G_RET_STS_ERROR;
2225: -- Standard call to get message count and if count=1, get the message
2226: FND_MSG_PUB.Count_And_Get (
2227: p_encoded => FND_API.G_FALSE,
2228: p_count => x_msg_count,
2229: p_data => x_msg_data
2230: );

Line 2235: FND_MSG_PUB.Count_And_Get (

2231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2232: ROLLBACK TO Process_SD_Approval;
2233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2234: -- Standard call to get message count and if count=1, get the message
2235: FND_MSG_PUB.Count_And_Get (
2236: p_encoded => FND_API.G_FALSE,
2237: p_count => x_msg_count,
2238: p_data => x_msg_data
2239: );

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

2241: ROLLBACK TO Process_SD_Approval;
2242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2243: IF OZF_UNEXP_ERROR_ON
2244: THEN
2245: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2246: END IF;
2247: -- Standard call to get message count and if count=1, get the message
2248: FND_MSG_PUB.Count_And_Get (
2249: p_encoded => FND_API.G_FALSE,

Line 2248: FND_MSG_PUB.Count_And_Get (

2244: THEN
2245: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2246: END IF;
2247: -- Standard call to get message count and if count=1, get the message
2248: FND_MSG_PUB.Count_And_Get (
2249: p_encoded => FND_API.G_FALSE,
2250: p_count => x_msg_count,
2251: p_data => x_msg_data
2252: );

Line 2306: FND_MSG_PUB.initialize;

2302: ozf_utility_pvt.debug_message( l_api_name||': Start');
2303: END IF;
2304: --Initialize message list if p_init_msg_list is TRUE.
2305: IF FND_API.To_Boolean (p_init_msg_list) THEN
2306: FND_MSG_PUB.initialize;
2307: END IF;
2308: -- Initialize API return status to sucess
2309: x_return_status := FND_API.G_RET_STS_SUCCESS;
2310: ame_api2.getAllApprovers7

Line 2319: FND_MSG_PUB.Count_And_Get (

2315: ,approversOut => x_approvers);
2316:
2317: -- Debug Message
2318: --Standard call to get message count and if count=1, get the message
2319: FND_MSG_PUB.Count_And_Get (
2320: p_encoded => FND_API.G_FALSE,
2321: p_count => x_msg_count,
2322: p_data => x_msg_data
2323: );

Line 2329: FND_MSG_PUB.Count_And_Get (

2325: WHEN FND_API.G_EXC_ERROR THEN
2326: ROLLBACK TO Get_All_Approvers;
2327: x_return_status := FND_API.G_RET_STS_ERROR;
2328: -- Standard call to get message count and if count=1, get the message
2329: FND_MSG_PUB.Count_And_Get (
2330: p_encoded => FND_API.G_FALSE,
2331: p_count => x_msg_count,
2332: p_data => x_msg_data
2333: );

Line 2338: FND_MSG_PUB.Count_And_Get (

2334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2335: ROLLBACK TO Get_All_Approvers;
2336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2337: -- Standard call to get message count and if count=1, get the message
2338: FND_MSG_PUB.Count_And_Get (
2339: p_encoded => FND_API.G_FALSE,
2340: p_count => x_msg_count,
2341: p_data => x_msg_data
2342: );

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

2344: ROLLBACK TO Get_All_Approvers;
2345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2346: IF OZF_UNEXP_ERROR_ON
2347: THEN
2348: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2349: END IF;
2350: -- Standard call to get message count and if count=1, get the message
2351: FND_MSG_PUB.Count_And_Get (
2352: p_encoded => FND_API.G_FALSE,

Line 2351: FND_MSG_PUB.Count_And_Get (

2347: THEN
2348: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2349: END IF;
2350: -- Standard call to get message count and if count=1, get the message
2351: FND_MSG_PUB.Count_And_Get (
2352: p_encoded => FND_API.G_FALSE,
2353: p_count => x_msg_count,
2354: p_data => x_msg_data
2355: );

Line 2430: FND_MSG_PUB.initialize;

2426: ozf_utility_pvt.debug_message( l_api_name||': Start');
2427: END IF;
2428: --Initialize message list if p_init_msg_list is TRUE.
2429: IF FND_API.To_Boolean (p_init_msg_list) THEN
2430: FND_MSG_PUB.initialize;
2431: END IF;
2432: -- Initialize API return status to sucess
2433: x_return_status := FND_API.G_RET_STS_SUCCESS;
2434:

Line 2534: FND_MSG_PUB.Count_And_Get (

2530: IF G_DEBUG THEN
2531: ozf_utility_pvt.debug_message( l_api_name||': End');
2532: END IF;
2533: --Standard call to get message count and if count=1, get the message
2534: FND_MSG_PUB.Count_And_Get (
2535: p_encoded => FND_API.G_FALSE,
2536: p_count => x_msg_count,
2537: p_data => x_msg_data
2538: );

Line 2544: FND_MSG_PUB.Count_And_Get (

2540: WHEN FND_API.G_EXC_ERROR THEN
2541: ROLLBACK TO Add_SD_Access1;
2542: x_return_status := FND_API.G_RET_STS_ERROR;
2543: -- Standard call to get message count and if count=1, get the message
2544: FND_MSG_PUB.Count_And_Get (
2545: p_encoded => FND_API.G_FALSE,
2546: p_count => x_msg_count,
2547: p_data => x_msg_data
2548: );

Line 2553: FND_MSG_PUB.Count_And_Get (

2549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2550: ROLLBACK TO Add_SD_Access1;
2551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2552: -- Standard call to get message count and if count=1, get the message
2553: FND_MSG_PUB.Count_And_Get (
2554: p_encoded => FND_API.G_FALSE,
2555: p_count => x_msg_count,
2556: p_data => x_msg_data
2557: );

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

2559: ROLLBACK TO Add_SD_Access1;
2560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2561: IF OZF_UNEXP_ERROR_ON
2562: THEN
2563: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2564: END IF;
2565: -- Standard call to get message count and if count=1, get the message
2566: FND_MSG_PUB.Count_And_Get (
2567: p_encoded => FND_API.G_FALSE,

Line 2566: FND_MSG_PUB.Count_And_Get (

2562: THEN
2563: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2564: END IF;
2565: -- Standard call to get message count and if count=1, get the message
2566: FND_MSG_PUB.Count_And_Get (
2567: p_encoded => FND_API.G_FALSE,
2568: p_count => x_msg_count,
2569: p_data => x_msg_data
2570: );

Line 2647: FND_MSG_PUB.initialize;

2643: ozf_utility_pvt.debug_message( l_api_name||': Start');
2644: END IF;
2645: --Initialize message list if p_init_msg_list is TRUE.
2646: IF FND_API.To_Boolean (p_init_msg_list) THEN
2647: FND_MSG_PUB.initialize;
2648: END IF;
2649:
2650: -- Initialize API return status to sucess
2651: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2796: FND_MSG_PUB.Count_And_Get (

2792: IF G_DEBUG THEN
2793: ozf_utility_pvt.debug_message( l_api_name||': End');
2794: END IF;
2795: --Standard call to get message count and if count=1, get the message
2796: FND_MSG_PUB.Count_And_Get (
2797: p_encoded => FND_API.G_FALSE,
2798: p_count => x_msg_count,
2799: p_data => x_msg_data
2800: );

Line 2806: FND_MSG_PUB.Count_And_Get (

2802: WHEN FND_API.G_EXC_ERROR THEN
2803: ROLLBACK TO Add_SD_Access2;
2804: x_return_status := FND_API.G_RET_STS_ERROR;
2805: -- Standard call to get message count and if count=1, get the message
2806: FND_MSG_PUB.Count_And_Get (
2807: p_encoded => FND_API.G_FALSE,
2808: p_count => x_msg_count,
2809: p_data => x_msg_data
2810: );

Line 2815: FND_MSG_PUB.Count_And_Get (

2811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2812: ROLLBACK TO Add_SD_Access2;
2813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2814: -- Standard call to get message count and if count=1, get the message
2815: FND_MSG_PUB.Count_And_Get (
2816: p_encoded => FND_API.G_FALSE,
2817: p_count => x_msg_count,
2818: p_data => x_msg_data
2819: );

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

2821: ROLLBACK TO Add_SD_Access2;
2822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2823: IF OZF_UNEXP_ERROR_ON
2824: THEN
2825: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2826: END IF;
2827: -- Standard call to get message count and if count=1, get the message
2828: FND_MSG_PUB.Count_And_Get (
2829: p_encoded => FND_API.G_FALSE,

Line 2828: FND_MSG_PUB.Count_And_Get (

2824: THEN
2825: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2826: END IF;
2827: -- Standard call to get message count and if count=1, get the message
2828: FND_MSG_PUB.Count_And_Get (
2829: p_encoded => FND_API.G_FALSE,
2830: p_count => x_msg_count,
2831: p_data => x_msg_data
2832: );

Line 2906: FND_MSG_PUB.Count_And_Get (

2902: IF G_DEBUG THEN
2903: ozf_utility_pvt.debug_message( l_api_name||': End');
2904: END IF;
2905: --Standard call to get message count and if count=1, get the message
2906: FND_MSG_PUB.Count_And_Get (
2907: p_encoded => FND_API.G_FALSE,
2908: p_count => x_msg_count,
2909: p_data => x_msg_data
2910: );

Line 2917: FND_MSG_PUB.Count_And_Get (

2913: WHEN FND_API.G_EXC_ERROR THEN
2914: ROLLBACK TO Raise_SD_Event;
2915: x_return_status := FND_API.G_RET_STS_ERROR;
2916: -- Standard call to get message count and if count=1, get the message
2917: FND_MSG_PUB.Count_And_Get (
2918: p_encoded => FND_API.G_FALSE,
2919: p_count => x_msg_count,
2920: p_data => x_msg_data
2921: );

Line 2926: FND_MSG_PUB.Count_And_Get (

2922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2923: ROLLBACK TO Raise_SD_Event;
2924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2925: -- Standard call to get message count and if count=1, get the message
2926: FND_MSG_PUB.Count_And_Get (
2927: p_encoded => FND_API.G_FALSE,
2928: p_count => x_msg_count,
2929: p_data => x_msg_data
2930: );

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

2932: ROLLBACK TO Raise_SD_Event;
2933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2934: IF OZF_UNEXP_ERROR_ON
2935: THEN
2936: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2937: END IF;
2938: -- Standard call to get message count and if count=1, get the message
2939: FND_MSG_PUB.Count_And_Get (
2940: p_encoded => FND_API.G_FALSE,

Line 2939: FND_MSG_PUB.Count_And_Get (

2935: THEN
2936: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2937: END IF;
2938: -- Standard call to get message count and if count=1, get the message
2939: FND_MSG_PUB.Count_And_Get (
2940: p_encoded => FND_API.G_FALSE,
2941: p_count => x_msg_count,
2942: p_data => x_msg_data
2943: );

Line 3104: FND_MSG_PUB.initialize;

3100: ozf_utility_pvt.debug_message( l_api_name||': Start');
3101: END IF;
3102: --Initialize message list if p_init_msg_list is TRUE.
3103: IF FND_API.To_Boolean (p_init_msg_list) THEN
3104: FND_MSG_PUB.initialize;
3105: END IF;
3106: -- Initialize API return status to sucess
3107: x_return_status := FND_API.G_RET_STS_SUCCESS;
3108:

Line 3319: FND_MSG_PUB.Count_And_Get (

3315: IF G_DEBUG THEN
3316: ozf_utility_pvt.debug_message( l_api_name||': End');
3317: END IF;
3318: --Standard call to get message count and if count=1, get the message
3319: FND_MSG_PUB.Count_And_Get (
3320: p_encoded => FND_API.G_FALSE,
3321: p_count => x_msg_count,
3322: p_data => x_msg_data
3323: );

Line 3329: FND_MSG_PUB.Count_And_Get (

3325: WHEN FND_API.G_EXC_ERROR THEN
3326: ROLLBACK TO Send_SD_Notification;
3327: x_return_status := FND_API.G_RET_STS_ERROR;
3328: -- Standard call to get message count and if count=1, get the message
3329: FND_MSG_PUB.Count_And_Get (
3330: p_encoded => FND_API.G_FALSE,
3331: p_count => x_msg_count,
3332: p_data => x_msg_data
3333: );

Line 3338: FND_MSG_PUB.Count_And_Get (

3334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3335: ROLLBACK TO Send_SD_Notification;
3336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3337: -- Standard call to get message count and if count=1, get the message
3338: FND_MSG_PUB.Count_And_Get (
3339: p_encoded => FND_API.G_FALSE,
3340: p_count => x_msg_count,
3341: p_data => x_msg_data
3342: );

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

3344: ROLLBACK TO Send_SD_Notification;
3345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3346: IF OZF_UNEXP_ERROR_ON
3347: THEN
3348: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3349: END IF;
3350: -- Standard call to get message count and if count=1, get the message
3351: FND_MSG_PUB.Count_And_Get (
3352: p_encoded => FND_API.G_FALSE,

Line 3351: FND_MSG_PUB.Count_And_Get (

3347: THEN
3348: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3349: END IF;
3350: -- Standard call to get message count and if count=1, get the message
3351: FND_MSG_PUB.Count_And_Get (
3352: p_encoded => FND_API.G_FALSE,
3353: p_count => x_msg_count,
3354: p_data => x_msg_data
3355: );