218: p_msg_data => l_msg_data ,
219: p_attr_name => 'ERROR_MSG',
220: x_error_msg => l_error_msg
221: ) ;
222: wf_core.context('AHL_ROUTE_APROVAL_PVT','Set_Activity_Details',
223: itemtype,itemkey,actid,funcmode,l_error_msg);
224:
225: resultout := 'COMPLETE:ERROR';
226:
224:
225: resultout := 'COMPLETE:ERROR';
226:
227: WHEN OTHERS THEN
228: wf_core.context(
229: 'AHL_OPERATIONS_APPROVAL_PVT'
230: ,'Set_Activity_Details'
231: ,itemtype
232: ,itemkey
346: p_msg_data => l_msg_data ,
347: p_attr_name => 'ERROR_MSG',
348: x_error_msg => l_error_msg
349: ) ;
350: wf_core.context('AHL_OPERATIONS_APPROVAL_PVT','ntf_forward_fyi',
351: l_item_type,l_item_key,l_error_msg);
352: RAISE;
353: WHEN OTHERS THEN
354: wf_core.context( 'AHLGAPP'
350: wf_core.context('AHL_OPERATIONS_APPROVAL_PVT','ntf_forward_fyi',
351: l_item_type,l_item_key,l_error_msg);
352: RAISE;
353: WHEN OTHERS THEN
354: wf_core.context( 'AHLGAPP'
355: , 'Ntf_Forward_FYI'
356: , l_item_type
357: , l_item_key
358: );
466: p_msg_data => l_msg_data ,
467: p_attr_name => 'ERROR_MSG',
468: x_error_msg => l_error_msg
469: ) ;
470: wf_core.context('AHL_OPERATIONS_APPROVAL_PVT','Ntf_Approved_FYI',
471: l_item_type,l_item_key,l_error_msg);
472: RAISE;
473: WHEN OTHERS THEN
474: wf_core.context( 'AHLGAPP'
470: wf_core.context('AHL_OPERATIONS_APPROVAL_PVT','Ntf_Approved_FYI',
471: l_item_type,l_item_key,l_error_msg);
472: RAISE;
473: WHEN OTHERS THEN
474: wf_core.context( 'AHLGAPP'
475: , 'Ntf_Approved_FYI'
476: , l_item_type
477: , l_item_key
478: );
571: p_msg_data => l_msg_data ,
572: p_attr_name => 'ERROR_MSG',
573: x_error_msg => l_error_msg
574: ) ;
575: wf_core.context('AHL_OPERATIONS_APPROVAL_PVT','Ntf_Final_Approval_FYI',
576: l_item_type,l_item_key,l_error_msg);
577: RAISE;
578: WHEN OTHERS THEN
579: wf_core.context( 'AHLGAPP'
575: wf_core.context('AHL_OPERATIONS_APPROVAL_PVT','Ntf_Final_Approval_FYI',
576: l_item_type,l_item_key,l_error_msg);
577: RAISE;
578: WHEN OTHERS THEN
579: wf_core.context( 'AHLGAPP'
580: , 'Ntf_Final_Approval_FYI'
581: , l_item_type
582: , l_item_key
583: );
688: p_msg_data => l_msg_data ,
689: p_attr_name => 'ERROR_MSG',
690: x_error_msg => l_error_msg
691: ) ;
692: wf_core.context('AHL_OPERATIONS_APPROVAL_PVT','Ntf_Rejected_FYI',
693: l_item_type,l_item_key,l_error_msg);
694: RAISE;
695:
696: WHEN OTHERS THEN
693: l_item_type,l_item_key,l_error_msg);
694: RAISE;
695:
696: WHEN OTHERS THEN
697: wf_core.context( 'AHLGAPP'
698: , 'Ntf_Rejected_FYI'
699: , l_item_type
700: , l_item_key
701: );
816: p_msg_data => l_msg_data ,
817: p_attr_name => 'ERROR_MSG',
818: x_error_msg => l_error_msg
819: ) ;
820: wf_core.context('AHL_OPERATIONS_APPROVAL_PVT','Ntf_Approval',
821: l_item_type,l_item_key,l_error_msg);
822: RAISE;
823: WHEN OTHERS THEN
824: wf_core.context( 'AHLGAPP'
820: wf_core.context('AHL_OPERATIONS_APPROVAL_PVT','Ntf_Approval',
821: l_item_type,l_item_key,l_error_msg);
822: RAISE;
823: WHEN OTHERS THEN
824: wf_core.context( 'AHLGAPP'
825: , 'Ntf_Approval'
826: , l_item_type
827: , l_item_key
828: );
941: p_msg_data => l_msg_data ,
942: p_attr_name => 'ERROR_MSG',
943: x_error_msg => l_error_msg
944: ) ;
945: wf_core.context('AHL_OPERATIONS_APPROVAL_PVT','Ntf_Approval_Reminder',
946: l_item_type,l_item_key,l_error_msg);
947: RAISE;
948: WHEN OTHERS THEN
949: wf_core.context( 'AHLGAPP'
945: wf_core.context('AHL_OPERATIONS_APPROVAL_PVT','Ntf_Approval_Reminder',
946: l_item_type,l_item_key,l_error_msg);
947: RAISE;
948: WHEN OTHERS THEN
949: wf_core.context( 'AHLGAPP'
950: , 'Ntf_Approval_Reminder'
951: , l_item_type
952: , l_item_key
953: );
1061: p_msg_data => l_msg_data ,
1062: p_attr_name => 'ERROR_MSG',
1063: x_error_msg => l_error_msg
1064: ) ;
1065: wf_core.context('AHL_OPERATIONS_APPROVAL_PVT','Ntf_Error_Act',
1066: l_item_type,l_item_key,l_error_msg);
1067: RAISE;
1068: WHEN OTHERS THEN
1069: wf_core.context( 'AHL_OPERATIONS_APPROVAL_PVT'
1065: wf_core.context('AHL_OPERATIONS_APPROVAL_PVT','Ntf_Error_Act',
1066: l_item_type,l_item_key,l_error_msg);
1067: RAISE;
1068: WHEN OTHERS THEN
1069: wf_core.context( 'AHL_OPERATIONS_APPROVAL_PVT'
1070: , 'Ntf_Error_Act'
1071: , l_item_type
1072: , l_item_key
1073: );
1238: p_msg_data => l_msg_data ,
1239: p_attr_name => 'ERROR_MSG',
1240: x_error_msg => l_error_msg
1241: ) ;
1242: wf_core.context('AHL_RM_APPROVAL_PVT','UPDATE_STATUS',
1243: itemtype,itemkey,actid,funcmode,l_error_msg);
1244: RAISE;
1245:
1246: WHEN OTHERS THEN
1247: IF G_DEBUG='Y' THEN
1248: AHL_DEBUG_PUB.debug( 'When others Error:'||sqlerrm,'+DebugwfOper+');
1249: END IF;
1250:
1251: wf_core.context(
1252: 'AHL_OPERATIONS_APPROVAL_PVT'
1253: ,'Update_Status'
1254: ,itemtype
1255: ,itemkey
1354: p_msg_data => l_msg_data ,
1355: p_attr_name => 'ERROR_MSG',
1356: x_error_msg => l_error_msg
1357: ) ;
1358: wf_core.context('AHL_OPERATIONS_APPROVAL_PVT','revert_status',
1359: itemtype,itemkey,actid,funcmode,l_error_msg);
1360: RAISE;
1361: WHEN OTHERS THEN
1362: wf_core.context(
1358: wf_core.context('AHL_OPERATIONS_APPROVAL_PVT','revert_status',
1359: itemtype,itemkey,actid,funcmode,l_error_msg);
1360: RAISE;
1361: WHEN OTHERS THEN
1362: wf_core.context(
1363: 'AHL_OPERATIONS_APPROVAL_PVT'
1364: ,'REVERT_STATUS'
1365: ,itemtype
1366: ,itemkey