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);
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:
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
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;
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:
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:
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: );
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: );
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: );
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: );
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,
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: );
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:
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: );
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: );
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: );
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,
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: );
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:
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: );
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: );
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: );
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,
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: );
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;
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:
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: );
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: );
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: );
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,
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: );
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: );
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: );
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,
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: );
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:
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: );
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: );
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: );
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,
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: );
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:
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: );
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: );
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: );
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,
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: );
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;
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);
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
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: );
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: );
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: );
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,
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: );
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
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: );
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: );
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: );
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,
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: );
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:
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: );
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: );
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: );
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,
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: );
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;
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: );
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: );
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: );
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,
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: );
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: );
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: );
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: );
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,
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: );
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:
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: );
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: );
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: );
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,
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: );