329: p_msg_data => l_msg_data ,
330: p_attr_name => 'ERROR_MSG',
331: x_error_msg => l_error_msg
332: ) ;
333: wf_core.context(G_PKG_NAME,'Set_Activity_Details', itemtype,itemkey,actid,funcmode,l_error_msg);
334: resultout := 'COMPLETE:ERROR';
335: RAISE;
336: WHEN OTHERS THEN
337: wf_core.context(G_PKG_NAME,'Set_Activity_Details', itemtype,itemkey,actid,funcmode,'UNEXPECTED_ERROR');
333: wf_core.context(G_PKG_NAME,'Set_Activity_Details', itemtype,itemkey,actid,funcmode,l_error_msg);
334: resultout := 'COMPLETE:ERROR';
335: RAISE;
336: WHEN OTHERS THEN
337: wf_core.context(G_PKG_NAME,'Set_Activity_Details', itemtype,itemkey,actid,funcmode,'UNEXPECTED_ERROR');
338: resultout := 'COMPLETE:ERROR';
339: RAISE;
340: END Set_Activity_Details;
341: --------------------------------------------------------------------------------
446: p_msg_data => l_msg_data ,
447: p_attr_name => 'ERROR_MSG',
448: x_error_msg => l_error_msg
449: ) ;
450: wf_core.context(G_PKG_NAME,'Ntf_Forward_FYI',l_item_type,l_item_key,l_error_msg);
451: RAISE;
452: WHEN OTHERS THEN
453: wf_core.context( 'AHLGAPP', 'Ntf_Forward_FYI', l_item_type, l_item_key );
454: RAISE;
449: ) ;
450: wf_core.context(G_PKG_NAME,'Ntf_Forward_FYI',l_item_type,l_item_key,l_error_msg);
451: RAISE;
452: WHEN OTHERS THEN
453: wf_core.context( 'AHLGAPP', 'Ntf_Forward_FYI', l_item_type, l_item_key );
454: RAISE;
455: END Ntf_Forward_FYI;
456: --------------------------------------------------------------------------------
457: -- Procedure forwards the message to the requester that the approval
559: p_msg_data => l_msg_data ,
560: p_attr_name => 'ERROR_MSG',
561: x_error_msg => l_error_msg
562: ) ;
563: wf_core.context(G_PKG_NAME,'Ntf_Approved_FYI',l_item_type,l_item_key,l_error_msg);
564: RAISE;
565: WHEN OTHERS THEN
566: wf_core.context( 'AHLGAPP', 'Ntf_Approved_FYI', l_item_type, l_item_key );
567: RAISE;
562: ) ;
563: wf_core.context(G_PKG_NAME,'Ntf_Approved_FYI',l_item_type,l_item_key,l_error_msg);
564: RAISE;
565: WHEN OTHERS THEN
566: wf_core.context( 'AHLGAPP', 'Ntf_Approved_FYI', l_item_type, l_item_key );
567: RAISE;
568: END Ntf_Approved_FYI;
569:
570: --------------------------------------------------------------------------------
665: p_msg_data => l_msg_data ,
666: p_attr_name => 'ERROR_MSG',
667: x_error_msg => l_error_msg
668: ) ;
669: wf_core.context(G_PKG_NAME,'Ntf_Final_Approval_FYI',l_item_type,l_item_key,l_error_msg);
670: RAISE;
671: WHEN OTHERS THEN
672: wf_core.context( 'AHLGAPP', 'Ntf_Final_Approval_FYI', l_item_type, l_item_key );
673: RAISE;
668: ) ;
669: wf_core.context(G_PKG_NAME,'Ntf_Final_Approval_FYI',l_item_type,l_item_key,l_error_msg);
670: RAISE;
671: WHEN OTHERS THEN
672: wf_core.context( 'AHLGAPP', 'Ntf_Final_Approval_FYI', l_item_type, l_item_key );
673: RAISE;
674: END Ntf_Final_Approval_FYI;
675:
676: --------------------------------------------------------------------------------
779: p_msg_data => l_msg_data ,
780: p_attr_name => 'ERROR_MSG',
781: x_error_msg => l_error_msg
782: ) ;
783: wf_core.context(G_PKG_NAME,'Ntf_Rejected_FYI',l_item_type,l_item_key,l_error_msg);
784: RAISE;
785: WHEN OTHERS THEN
786: wf_core.context( 'AHLGAPP', 'Ntf_Rejected_FYI', l_item_type, l_item_key );
787: RAISE;
782: ) ;
783: wf_core.context(G_PKG_NAME,'Ntf_Rejected_FYI',l_item_type,l_item_key,l_error_msg);
784: RAISE;
785: WHEN OTHERS THEN
786: wf_core.context( 'AHLGAPP', 'Ntf_Rejected_FYI', l_item_type, l_item_key );
787: RAISE;
788: END Ntf_Rejected_FYI;
789:
790: --------------------------------------------------------------------------------
894: p_msg_data => l_msg_data ,
895: p_attr_name => 'ERROR_MSG',
896: x_error_msg => l_error_msg
897: ) ;
898: wf_core.context(G_PKG_NAME,'Ntf_Approval',l_item_type,l_item_key,l_error_msg);
899: RAISE;
900: WHEN OTHERS THEN
901: wf_core.context( 'AHLGAPP', 'Ntf_Approval', l_item_type, l_item_key );
902: RAISE;
897: ) ;
898: wf_core.context(G_PKG_NAME,'Ntf_Approval',l_item_type,l_item_key,l_error_msg);
899: RAISE;
900: WHEN OTHERS THEN
901: wf_core.context( 'AHLGAPP', 'Ntf_Approval', l_item_type, l_item_key );
902: RAISE;
903: END Ntf_Approval;
904:
905: --------------------------------------------------------------------------------
1011: p_msg_data => l_msg_data ,
1012: p_attr_name => 'ERROR_MSG',
1013: x_error_msg => l_error_msg
1014: ) ;
1015: wf_core.context(G_PKG_NAME,'Ntf_Approval_Reminder',l_item_type,l_item_key,l_error_msg);
1016: RAISE;
1017: WHEN OTHERS THEN
1018: wf_core.context( 'AHLGAPP', 'Ntf_Approval_Reminder', l_item_type, l_item_key );
1019: RAISE;
1014: ) ;
1015: wf_core.context(G_PKG_NAME,'Ntf_Approval_Reminder',l_item_type,l_item_key,l_error_msg);
1016: RAISE;
1017: WHEN OTHERS THEN
1018: wf_core.context( 'AHLGAPP', 'Ntf_Approval_Reminder', l_item_type, l_item_key );
1019: RAISE;
1020: END Ntf_Approval_Reminder;
1021:
1022: --------------------------------------------------------------------------------
1133: p_msg_data => l_msg_data ,
1134: p_attr_name => 'ERROR_MSG',
1135: x_error_msg => l_error_msg
1136: ) ;
1137: wf_core.context(G_PKG_NAME,'Ntf_Error_Act',l_item_type,l_item_key,l_error_msg);
1138: RAISE;
1139: WHEN OTHERS THEN
1140: wf_core.context( 'AHLGAPP', 'Ntf_Error_Act', l_item_type, l_item_key );
1141: RAISE;
1136: ) ;
1137: wf_core.context(G_PKG_NAME,'Ntf_Error_Act',l_item_type,l_item_key,l_error_msg);
1138: RAISE;
1139: WHEN OTHERS THEN
1140: wf_core.context( 'AHLGAPP', 'Ntf_Error_Act', l_item_type, l_item_key );
1141: RAISE;
1142: END Ntf_Error_Act;
1143:
1144: PROCEDURE Update_Status(
1383: p_msg_data => l_msg_data ,
1384: p_attr_name => 'ERROR_MSG',
1385: x_error_msg => l_error_msg
1386: ) ;
1387: wf_core.context(G_PKG_NAME,'Update_Status',itemtype,itemkey,l_error_msg);
1388:
1389: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1390: fnd_log.string
1391: (
1412:
1413: RAISE;
1414: WHEN OTHERS THEN
1415: ROLLBACK TO AHL_DEF_UPDATE_STATUS;
1416: wf_core.context( 'AHLGAPP', 'Update_Status', itemtype, itemkey );
1417:
1418: l_error_msg := SQLCODE || ': ' || SQLERRM;
1419: -- update validation errors.
1420: UPDATE AHL_UNIT_DEFERRALS_TL
1558: p_msg_data => l_msg_data ,
1559: p_attr_name => 'ERROR_MSG',
1560: x_error_msg => l_error_msg
1561: ) ;
1562: wf_core.context(G_PKG_NAME,'Revert_Status',itemtype,itemkey,l_error_msg);
1563:
1564: -- update validation errors.
1565: UPDATE AHL_UNIT_DEFERRALS_TL
1566: SET approver_notes = substrb(l_error_msg,1,4000)
1578:
1579: RAISE;
1580: WHEN OTHERS THEN
1581: ROLLBACK TO AHL_DEF_REVT_STATUS;
1582: wf_core.context( 'AHLGAPP', 'Revert_Status', itemtype, itemkey );
1583:
1584: l_error_msg := SQLCODE || ': ' || SQLERRM;
1585: -- update validation errors.
1586: UPDATE AHL_UNIT_DEFERRALS_TL