[Home] [Help]
144: and usr.user_id = pc_userid;
145:
146:
147: BEGIN
148: -- Standard begin of API savepoint
149: SAVEPOINT Update_User_Action_PVT;
150: -- Standard call to check for call compatibility.
151: IF NOT FND_API.Compatible_API_Call (
152: l_api_version,
146:
147: BEGIN
148: -- Standard begin of API savepoint
149: SAVEPOINT Update_User_Action_PVT;
150: -- Standard call to check for call compatibility.
151: IF NOT FND_API.Compatible_API_Call (
152: l_api_version,
153: p_api_version,
154: l_api_name,
422: -- Debug Message
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
432: EXCEPTION
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
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,
461: p_count => x_msg_count,
462: p_data => x_msg_data
505: AND object_id = p_object_id;
506:
507: BEGIN
508:
509: -- Standard begin of API savepoint
510: SAVEPOINT Get_Approvers_PVT;
511: -- Standard call to check for call compatibility.
512: IF NOT FND_API.Compatible_API_Call (
513: l_api_version,
507: BEGIN
508:
509: -- Standard begin of API savepoint
510: SAVEPOINT Get_Approvers_PVT;
511: -- Standard call to check for call compatibility.
512: IF NOT FND_API.Compatible_API_Call (
513: l_api_version,
514: p_api_version,
515: l_api_name,
633: IF G_DEBUG THEN
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
643: EXCEPTION
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
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,
672: p_count => x_msg_count,
673: p_data => x_msg_data
707: SELECT ozf_approval_access_s.NEXTVAL
708: FROM dual;
709:
710: BEGIN
711: -- Standard begin of API savepoint
712: SAVEPOINT Add_Access_PVT;
713: -- Standard call to check for call compatibility.
714: IF NOT FND_API.Compatible_API_Call (
715: l_api_version,
709:
710: BEGIN
711: -- Standard begin of API savepoint
712: SAVEPOINT Add_Access_PVT;
713: -- Standard call to check for call compatibility.
714: IF NOT FND_API.Compatible_API_Call (
715: l_api_version,
716: p_api_version,
717: l_api_name,
823: END IF;
824: END;
825: END LOOP;
826:
827: --Standard check of commit
828: IF FND_API.To_Boolean ( p_commit ) THEN
829: COMMIT WORK;
830: END IF;
831: -- Debug Message
831: -- Debug Message
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
841: EXCEPTION
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
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,
870: p_count => x_msg_count,
871: p_data => x_msg_data
908: AND object_type = p_object_type
909: AND object_id = p_object_id;
910:
911: BEGIN
912: -- Standard begin of API savepoint
913: SAVEPOINT Revoke_Access_PVT;
914: -- Standard call to check for call compatibility.
915: IF NOT FND_API.Compatible_API_Call (
916: l_api_version,
910:
911: BEGIN
912: -- Standard begin of API savepoint
913: SAVEPOINT Revoke_Access_PVT;
914: -- Standard call to check for call compatibility.
915: IF NOT FND_API.Compatible_API_Call (
916: l_api_version,
917: p_api_version,
918: l_api_name,
948: l_approval_access_id := null;
949: END LOOP;
950: CLOSE csr_curr_approvers;
951:
952: --Standard check of commit
953: IF FND_API.To_Boolean ( p_commit ) THEN
954: COMMIT WORK;
955: END IF;
956: -- Debug Message
956: -- Debug Message
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
966: EXCEPTION
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
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,
995: p_count => x_msg_count,
996: p_data => x_msg_data
1173: EXCEPTION
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
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,
1202: p_count => x_msg_count,
1203: p_data => x_msg_data
1312:
1313: l_execute_str varchar2(3000); -- bug 5058027
1314:
1315: BEGIN
1316: -- Standard begin of API savepoint
1317: SAVEPOINT Send_Notification_PVT;
1318: -- Standard call to check for call compatibility.
1319: IF NOT FND_API.Compatible_API_Call (
1320: l_api_version,
1314:
1315: BEGIN
1316: -- Standard begin of API savepoint
1317: SAVEPOINT Send_Notification_PVT;
1318: -- Standard call to check for call compatibility.
1319: IF NOT FND_API.Compatible_API_Call (
1320: l_api_version,
1321: p_api_version,
1322: l_api_name,
1502: from ozf_approval_access
1503: where object_type = l_object_type
1504: and object_id = l_object_id);
1505:
1506: --Standard check of commit
1507: IF FND_API.To_Boolean ( p_commit ) THEN
1508: COMMIT WORK;
1509: END IF;
1510:
1511: -- Debug Message
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
1521: EXCEPTION
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
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,
1551: p_count => x_msg_count,
1552: p_data => x_msg_data
1609: from ozf_request_headers_all_b
1610: where request_header_id = p_request_id;
1611:
1612: BEGIN
1613: -- Standard begin of API savepoint
1614: SAVEPOINT Process_User_Action_PVT;
1615: -- Standard call to check for call compatibility.
1616: IF NOT FND_API.Compatible_API_Call (
1617: l_api_version,
1611:
1612: BEGIN
1613: -- Standard begin of API savepoint
1614: SAVEPOINT Process_User_Action_PVT;
1615: -- Standard call to check for call compatibility.
1616: IF NOT FND_API.Compatible_API_Call (
1617: l_api_version,
1618: p_api_version,
1619: l_api_name,
1856: RAISE FND_API.g_exc_unexpected_error;
1857: END IF;
1858:
1859: */
1860: --Standard check of commit
1861: IF FND_API.To_Boolean ( p_commit ) THEN
1862: COMMIT WORK;
1863: END IF;
1864:
1866: -- Debug Message
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
1877: EXCEPTION
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
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,
1906: p_count => x_msg_count,
1907: p_data => x_msg_data
2041: AND approver_flag = 'Y'
2042: AND enabled_flag = 'Y';
2043:
2044: BEGIN
2045: -- Standard begin of API savepoint
2046: SAVEPOINT Process_SD_Approval;
2047: -- Standard call to check for call compatibility.
2048: IF NOT FND_API.Compatible_API_Call (
2049: l_api_version,
2043:
2044: BEGIN
2045: -- Standard begin of API savepoint
2046: SAVEPOINT Process_SD_Approval;
2047: -- Standard call to check for call compatibility.
2048: IF NOT FND_API.Compatible_API_Call (
2049: l_api_version,
2050: p_api_version,
2051: l_api_name,
2202: ,x_return_status => l_return_status
2203: ,x_msg_data => x_msg_data
2204: ,x_msg_count => x_msg_count);
2205:
2206: --Standard check of commit
2207: IF FND_API.To_Boolean ( p_commit ) THEN
2208: COMMIT WORK;
2209: END IF;
2210: -- Debug Message
2210: -- Debug Message
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
2221: EXCEPTION
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
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,
2250: p_count => x_msg_count,
2251: p_data => x_msg_data
2285: l_application_id number := 682;
2286:
2287: BEGIN
2288:
2289: -- Standard begin of API savepoint
2290: SAVEPOINT Get_All_Approvers;
2291: -- Standard call to check for call compatibility.
2292: IF NOT FND_API.Compatible_API_Call (
2293: l_api_version,
2287: BEGIN
2288:
2289: -- Standard begin of API savepoint
2290: SAVEPOINT Get_All_Approvers;
2291: -- Standard call to check for call compatibility.
2292: IF NOT FND_API.Compatible_API_Call (
2293: l_api_version,
2294: p_api_version,
2295: l_api_name,
2314: ,approvalProcessCompleteYNOut => x_approval_flag
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
2324: EXCEPTION
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
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,
2353: p_count => x_msg_count,
2354: p_data => x_msg_data
2409: and sysdate <= nvl(end_date_active, sysdate)
2410: and rownum < 2;
2411:
2412: BEGIN
2413: -- Standard begin of API savepoint
2414: SAVEPOINT Add_SD_Access1;
2415: -- Standard call to check for call compatibility.
2416: IF NOT FND_API.Compatible_API_Call (
2417: l_api_version,
2411:
2412: BEGIN
2413: -- Standard begin of API savepoint
2414: SAVEPOINT Add_SD_Access1;
2415: -- Standard call to check for call compatibility.
2416: IF NOT FND_API.Compatible_API_Call (
2417: l_api_version,
2418: p_api_version,
2419: l_api_name,
2529: -- Debug Message
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
2539: EXCEPTION
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
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,
2568: p_count => x_msg_count,
2569: p_data => x_msg_data
2626: AND enabled_flag = 'Y'
2627: AND resource_id = p_resource_id;
2628:
2629: BEGIN
2630: -- Standard begin of API savepoint
2631: SAVEPOINT Add_SD_Access2;
2632: -- Standard call to check for call compatibility.
2633: IF NOT FND_API.Compatible_API_Call (
2634: l_api_version,
2628:
2629: BEGIN
2630: -- Standard begin of API savepoint
2631: SAVEPOINT Add_SD_Access2;
2632: -- Standard call to check for call compatibility.
2633: IF NOT FND_API.Compatible_API_Call (
2634: l_api_version,
2635: p_api_version,
2636: l_api_name,
2783: RAISE FND_API.G_EXC_ERROR;
2784: END IF;
2785: END;
2786: END IF;
2787: --Standard check of commit
2788: IF FND_API.To_Boolean ( p_commit ) THEN
2789: COMMIT WORK;
2790: END IF;
2791: -- Debug Message
2791: -- Debug Message
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
2801: EXCEPTION
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
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,
2830: p_count => x_msg_count,
2831: p_data => x_msg_data
2901: -- Debug Message
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
2912: EXCEPTION
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
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,
2941: p_count => x_msg_count,
2942: p_data => x_msg_data
3083: l_function_id NUMBER;
3084: l_login_url VARCHAR2(1000);
3085:
3086: BEGIN
3087: -- Standard begin of API savepoint
3088: SAVEPOINT Send_SD_Notification;
3089: -- Standard call to check for call compatibility.
3090: IF NOT FND_API.Compatible_API_Call (
3091: l_api_version,
3085:
3086: BEGIN
3087: -- Standard begin of API savepoint
3088: SAVEPOINT Send_SD_Notification;
3089: -- Standard call to check for call compatibility.
3090: IF NOT FND_API.Compatible_API_Call (
3091: l_api_version,
3092: p_api_version,
3093: l_api_name,
3305: IF G_DEBUG THEN
3306: ozf_utility_pvt.debug_message('Sent notification to role: ' || l_adhoc_role);
3307: ozf_utility_pvt.debug_message('Using message: ' || l_item_name || '. Notify id: ' || l_group_notify_id );
3308: END IF;
3309: --Standard check of commit
3310: IF FND_API.To_Boolean ( p_commit ) THEN
3311: COMMIT WORK;
3312: END IF;
3313:
3314: -- Debug Message
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
3324: EXCEPTION
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
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,
3353: p_count => x_msg_count,
3354: p_data => x_msg_data