DBA Data[Home] [Help]

APPS.AHL_GENERIC_APRV_PVT dependencies on AHL_GENERIC_APRV_PVT

Line 1: PACKAGE BODY AHL_GENERIC_APRV_PVT as

1: PACKAGE BODY AHL_GENERIC_APRV_PVT as
2: /* $Header: AHLVGWFB.pls 115.7 2003/12/30 06:27:55 rroy noship $ */
3:
4: /*****************************************************************
5: -- Private API Specifications

Line 358: wf_core.context('AHL_GENERIC_APRV_PVT','Set_Activity_Details',

354: p_msg_data => l_msg_data ,
355: p_attr_name => 'ERROR_MSG',
356: x_error_msg => l_error_msg
357: ) ;
358: wf_core.context('AHL_GENERIC_APRV_PVT','Set_Activity_Details',
359: itemtype,itemkey,actid,funcmode,l_error_msg);
360:
361: resultout := 'COMPLETE:ERROR';
362:

Line 365: wf_core.context('AHL_GENERIC_APRV_PVT','Set_Activity_Details',

361: resultout := 'COMPLETE:ERROR';
362:
363: WHEN OTHERS THEN
364:
365: wf_core.context('AHL_GENERIC_APRV_PVT','Set_Activity_Details',
366: itemtype,itemkey,actid,funcmode,'Unexpected Error!');
367:
368: RAISE;
369:

Line 525: wf_core.context('AHL_GENERIC_APRV_PVT',

521: x_error_msg => l_error_msg
522: ) ;
523:
524:
525: wf_core.context('AHL_GENERIC_APRV_PVT',
526: 'set_approver_Details',
527: itemtype, itemkey,to_char(actid),l_error_msg);
528:
529: RAISE;

Line 532: wf_core.context('AHL_GENERIC_APRV_PVT',

528:
529: RAISE;
530: WHEN OTHERS THEN
531:
532: wf_core.context('AHL_GENERIC_APRV_PVT',
533: 'set_approver_Details',
534: itemtype, itemkey,to_char(actid),'Unexpected Error!');
535:
536: RAISE;

Line 631: wf_core.context('AHL_GENERIC_APRV_PVT',

627: p_attr_name => 'ERROR_MSG',
628: x_error_msg => l_error_msg
629: ) ;
630:
631: wf_core.context('AHL_GENERIC_APRV_PVT',
632: 'set_further_approval',
633: itemtype, itemkey,to_char(actid),l_error_msg);
634: RAISE;
635: WHEN OTHERS THEN

Line 637: wf_core.context('AHL_GENERIC_APRV_PVT',

633: itemtype, itemkey,to_char(actid),l_error_msg);
634: RAISE;
635: WHEN OTHERS THEN
636:
637: wf_core.context('AHL_GENERIC_APRV_PVT',
638: 'set_further_approval',
639: itemtype, itemkey,to_char(actid),'Unexpected Error!');
640: RAISE;
641: --

Line 708: wf_core.context('AHL_GENERIC_APRV_PVT',

704: p_msg_data => l_msg_data ,
705: p_attr_name => 'ERROR_MSG',
706: x_error_msg => l_error_msg
707: ) ;
708: wf_core.context('AHL_GENERIC_APRV_PVT',
709: 'ntf_approval',
710: l_itemtype, l_itemkey,l_error_msg);
711: RAISE;
712: WHEN OTHERS THEN

Line 714: wf_core.context('AHL_GENERIC_APRV_PVT',

710: l_itemtype, l_itemkey,l_error_msg);
711: RAISE;
712: WHEN OTHERS THEN
713:
714: wf_core.context('AHL_GENERIC_APRV_PVT',
715: 'ntf_approval',
716: l_itemtype, l_itemkey,'Unexpected Error!');
717: RAISE;
718: --

Line 784: wf_core.context('AHL_GENERIC_APRV_PVT',

780: p_msg_data => l_msg_data ,
781: p_attr_name => 'ERROR_MSG',
782: x_error_msg => l_error_msg
783: ) ;
784: wf_core.context('AHL_GENERIC_APRV_PVT',
785: 'ntf_error_act',
786: l_itemtype, l_itemkey,l_error_msg);
787: RAISE;
788: WHEN OTHERS THEN

Line 790: wf_core.context('AHL_GENERIC_APRV_PVT',

786: l_itemtype, l_itemkey,l_error_msg);
787: RAISE;
788: WHEN OTHERS THEN
789:
790: wf_core.context('AHL_GENERIC_APRV_PVT',
791: 'ntf_error_act',
792: l_itemtype, l_itemkey,'Unexpected Error!');
793: RAISE;
794: --

Line 860: wf_core.context('AHL_GENERIC_APRV_PVT',

856: p_msg_data => l_msg_data ,
857: p_attr_name => 'ERROR_MSG',
858: x_error_msg => l_error_msg
859: ) ;
860: wf_core.context('AHL_GENERIC_APRV_PVT',
861: 'ntf_approval_reminder',
862: l_itemtype, l_itemkey,l_error_msg);
863: RAISE;
864: WHEN OTHERS THEN

Line 866: wf_core.context('AHL_GENERIC_APRV_PVT',

862: l_itemtype, l_itemkey,l_error_msg);
863: RAISE;
864: WHEN OTHERS THEN
865:
866: wf_core.context('AHL_GENERIC_APRV_PVT',
867: 'ntf_approval_reminder',
868: l_itemtype, l_itemkey,'Unexpected Error!');
869: RAISE;
870: --

Line 938: wf_core.context('AHL_GENERIC_APRV_PVT',

934: p_msg_data => l_msg_data ,
935: p_attr_name => 'ERROR_MSG',
936: x_error_msg => l_error_msg
937: ) ;
938: wf_core.context('AHL_GENERIC_APRV_PVT',
939: 'ntf_forward_fyi',
940: l_itemtype, l_itemkey,l_error_msg);
941: RAISE;
942: WHEN OTHERS THEN

Line 944: wf_core.context('AHL_GENERIC_APRV_PVT',

940: l_itemtype, l_itemkey,l_error_msg);
941: RAISE;
942: WHEN OTHERS THEN
943:
944: wf_core.context('AHL_GENERIC_APRV_PVT',
945: 'ntf_forward_fyi',
946: l_itemtype, l_itemkey,'Unexpected Error!');
947: RAISE;
948: --

Line 1014: wf_core.context('AHL_GENERIC_APRV_PVT',

1010: p_msg_data => l_msg_data ,
1011: p_attr_name => 'ERROR_MSG',
1012: x_error_msg => l_error_msg
1013: ) ;
1014: wf_core.context('AHL_GENERIC_APRV_PVT',
1015: 'ntf_approved_fyi',
1016: l_itemtype, l_itemkey,l_error_msg);
1017: RAISE;
1018: WHEN OTHERS THEN

Line 1020: wf_core.context('AHL_GENERIC_APRV_PVT',

1016: l_itemtype, l_itemkey,l_error_msg);
1017: RAISE;
1018: WHEN OTHERS THEN
1019:
1020: wf_core.context('AHL_GENERIC_APRV_PVT',
1021: 'ntf_approved_fyi',
1022: l_itemtype, l_itemkey,'Unexpected Error!');
1023: RAISE;
1024: --

Line 1090: wf_core.context('AHL_GENERIC_APRV_PVT',

1086: p_msg_data => l_msg_data ,
1087: p_attr_name => 'ERROR_MSG',
1088: x_error_msg => l_error_msg
1089: ) ;
1090: wf_core.context('AHL_GENERIC_APRV_PVT',
1091: 'ntf_rejected_fyi',
1092: l_itemtype, l_itemkey,l_error_msg);
1093: RAISE;
1094: WHEN OTHERS THEN

Line 1096: wf_core.context('AHL_GENERIC_APRV_PVT',

1092: l_itemtype, l_itemkey,l_error_msg);
1093: RAISE;
1094: WHEN OTHERS THEN
1095:
1096: wf_core.context('AHL_GENERIC_APRV_PVT',
1097: 'ntf_rejected_fyi',
1098: l_itemtype, l_itemkey,'Unexpected Error!');
1099: RAISE;
1100: --

Line 1165: wf_core.context('AHL_GENERIC_APRV_PVT',

1161: p_msg_data => l_msg_data ,
1162: p_attr_name => 'ERROR_MSG',
1163: x_error_msg => l_error_msg
1164: ) ;
1165: wf_core.context('AHL_GENERIC_APRV_PVT',
1166: 'ntf_final_approval_fyi',
1167: l_itemtype, l_itemkey,l_error_msg);
1168: RAISE;
1169: WHEN OTHERS THEN

Line 1171: wf_core.context('AHL_GENERIC_APRV_PVT',

1167: l_itemtype, l_itemkey,l_error_msg);
1168: RAISE;
1169: WHEN OTHERS THEN
1170:
1171: wf_core.context('AHL_GENERIC_APRV_PVT',
1172: 'ntf_final_approval_fyi',
1173: l_itemtype, l_itemkey,'Unexpected Error!');
1174: RAISE;
1175: --

Line 1239: wf_core.context('AHL_GENERIC_APRV_PVT',

1235: p_msg_data => l_msg_data ,
1236: p_attr_name => 'ERROR_MSG',
1237: x_error_msg => l_error_msg
1238: );
1239: wf_core.context('AHL_GENERIC_APRV_PVT',
1240: 'update_status',
1241: itemtype, itemkey,l_error_msg);
1242: RAISE;
1243: WHEN OTHERS THEN

Line 1245: wf_core.context('AHL_GENERIC_APRV_PVT',

1241: itemtype, itemkey,l_error_msg);
1242: RAISE;
1243: WHEN OTHERS THEN
1244:
1245: wf_core.context('AHL_GENERIC_APRV_PVT',
1246: 'update_status',
1247: itemtype, itemkey,'Unexpected Error!');
1248: RAISE;
1249: --

Line 1293: wf_core.context('AHL_GENERIC_APRV_PVT',

1289: EXCEPTION
1290:
1291: WHEN OTHERS THEN
1292:
1293: wf_core.context('AHL_GENERIC_APRV_PVT',
1294: 'Approved_Update_Status',
1295: itemtype, itemkey,to_char(actid),'Unexpected Error!');
1296: RAISE;
1297: --

Line 1342: wf_core.context('AHL_GENERIC_APRV_PVT',

1338: EXCEPTION
1339:
1340: WHEN OTHERS THEN
1341:
1342: wf_core.context('AHL_GENERIC_APRV_PVT',
1343: 'Rejected_Update_Status',
1344: itemtype, itemkey,to_char(actid),'Unexpected Error!');
1345: RAISE;
1346: --

Line 1409: wf_core.context('AHL_GENERIC_APRV_PVT',

1405: p_msg_data => l_msg_data ,
1406: p_attr_name => 'ERROR_MSG',
1407: x_error_msg => l_error_msg
1408: ) ;
1409: wf_core.context('AHL_GENERIC_APRV_PVT',
1410: 'Revert_Status',
1411: itemtype, itemkey,l_error_msg);
1412: RAISE;
1413: WHEN OTHERS THEN

Line 1415: wf_core.context('AHL_GENERIC_APRV_PVT',

1411: itemtype, itemkey,l_error_msg);
1412: RAISE;
1413: WHEN OTHERS THEN
1414:
1415: wf_core.context('AHL_GENERIC_APRV_PVT',
1416: 'REVERT_STATUS',
1417: itemtype, itemkey,'Unexpected Error!');
1418: RAISE;
1419: --

Line 1907: END ahl_generic_aprv_pvt;

1903: END IF;
1904: CLOSE c_check_app;
1905: END Check_Approval_Required;
1906:
1907: END ahl_generic_aprv_pvt;