[Home] [Help]
1: PACKAGE BODY AHL_PC_APPROVAL_PVT AS
2: /* $Header: AHLVPWKB.pls 120.2.12020000.2 2012/12/07 13:30:22 sareepar ship $ */
3:
4: --G_DEBUG VARCHAR2(1):=FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
275: x_error_msg => l_error_msg
276: );
277: wf_core.context
278: (
279: 'AHL_PC_APPROVAL_PVT',
280: 'SET_ACTIVITY_DETAILS',
281: itemtype,
282: itemkey,
283: actid,
288:
289: WHEN OTHERS THEN
290: wf_core.context
291: (
292: 'AHL_PC_APPROVAL_PVT',
293: 'SET_ACTIVITY_DETAILS',
294: itemtype,
295: itemkey,
296: actid,
410: x_error_msg => l_error_msg
411: ) ;
412: wf_core.context
413: (
414: 'AHL_PC_APPROVAL_PVT',
415: 'NTF_FORWARD_FYI',
416: l_item_type,
417: l_item_key,
418: l_error_msg
420: RAISE;
421:
422: WHEN OTHERS THEN
423: wf_core.context(
424: 'AHL_PC_APPROVAL_PVT',
425: 'NTF_FORWARD_FYI',
426: l_item_type,
427: l_item_key
428: );
539: x_error_msg => l_error_msg
540: ) ;
541: wf_core.context
542: (
543: 'AHL_PC_APPROVAL_PVT',
544: 'NTF_APPROVED_API',
545: l_item_type,
546: l_item_key,
547: l_error_msg
549: RAISE;
550: WHEN OTHERS THEN
551: wf_core.context
552: (
553: 'AHL_PC_APPROVAL_PVT',
554: 'NTF_APPROVED_API',
555: l_item_type,
556: l_item_key
557: );
658: x_error_msg => l_error_msg
659: ) ;
660: wf_core.context
661: (
662: 'AHL_PC_APPROVAL_PVT',
663: 'NTF_FINAL_APPROVAL_FYI',
664: l_item_type,
665: l_item_key,
666: l_error_msg
668: RAISE;
669: WHEN OTHERS THEN
670: wf_core.context
671: (
672: 'AHL_PC_APPROVAL_PVT',
673: 'NTF_FINAL_APPROVAL_FYI',
674: l_item_type,
675: l_item_key
676: );
788: x_error_msg => l_error_msg
789: ) ;
790: wf_core.context
791: (
792: 'AHL_PC_APPROVAL_PVT',
793: 'NTF_REJECTED_FYI',
794: l_item_type,
795: l_item_key,
796: l_error_msg
797: );
798: RAISE;
799: WHEN OTHERS THEN
800: wf_core.context(
801: 'AHL_PC_APPROVAL_PVT',
802: 'NTF_REJECTED_FYI',
803: l_item_type,
804: l_item_key
805: );
927: x_error_msg => l_error_msg
928: ) ;
929: wf_core.context
930: (
931: 'AHL_PC_APPROVAL_PVT',
932: 'NTF_APPROVAL',
933: l_item_type,
934: l_item_key,
935: l_error_msg
936: );
937: RAISE;
938: WHEN OTHERS THEN
939: wf_core.context(
940: 'AHL_PC_APPROVAL_PVT',
941: 'NTF_APPROVAL',
942: l_item_type,
943: l_item_key
944: );
1065: x_error_msg => l_error_msg
1066: ) ;
1067: wf_core.context
1068: (
1069: 'AHL_PC_APPROVAL_PVT',
1070: 'NTF_APPROVAL_REMINDER',
1071: l_item_type,
1072: l_item_key,
1073: l_error_msg
1074: );
1075: RAISE;
1076: WHEN OTHERS THEN
1077: wf_core.context(
1078: 'AHL_PC_APPROVAL_PVT',
1079: 'NTF_APPROVAL_REMINDER',
1080: l_item_type,
1081: l_item_key
1082: );
1199: x_error_msg => l_error_msg
1200: ) ;
1201: wf_core.context
1202: (
1203: 'AHL_PC_APPROVAL_PVT',
1204: 'NTF_ERROR_ACT',
1205: l_item_type,
1206: l_item_key,
1207: l_error_msg
1209: RAISE;
1210: WHEN OTHERS THEN
1211: wf_core.context
1212: (
1213: 'AHL_PC_APPROVAL_PVT',
1214: 'NTF_ERROR_ACT',
1215: l_item_type,
1216: l_item_key
1217: );
1457: x_error_msg => l_error_msg
1458: );
1459: wf_core.context
1460: (
1461: 'AHL_PC_APPROVAL_PVT',
1462: 'UPDATE_STATUS',
1463: itemtype,
1464: itemkey,
1465: actid,
1469: RAISE;
1470:
1471: WHEN OTHERS THEN
1472: wf_core.context(
1473: 'AHL_PC_APPROVAL_PVT',
1474: 'UPDATE_STATUS',
1475: itemtype,
1476: itemkey,
1477: actid,
1607: x_error_msg => l_error_msg
1608: ) ;
1609: wf_core.context
1610: (
1611: 'AHL_PC_APPROVAL_PVT',
1612: 'REVERT_STATUS',
1613: itemtype,
1614: itemkey,
1615: actid,
1619: RAISE;
1620: WHEN OTHERS THEN
1621: wf_core.context
1622: (
1623: 'AHL_PC_APPROVAL_PVT'
1624: ,'REVERT_STATUS'
1625: ,itemtype
1626: ,itemkey
1627: ,actid
1631: RAISE;
1632:
1633: END REVERT_STATUS;
1634:
1635: END AHL_PC_APPROVAL_PVT;