DBA Data[Home] [Help]

APPS.AHL_OPERATIONS_APPROVAL_PVT dependencies on AHL_DEBUG_PUB

Line 4: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

1: PACKAGE BODY AHL_OPERATIONS_APPROVAL_PVT AS
2: /* $Header: AHLVOWKB.pls 120.1 2005/09/29 04:26:44 tamdas noship $ */
3:
4: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
5:
6: PROCEDURE GET_FULLNAME
7: (
8: p_username IN VARCHAR2,

Line 63: AHL_DEBUG_PUB.enable_debug;

59:
60:
61: BEGIN
62: IF G_DEBUG='Y' THEN
63: AHL_DEBUG_PUB.enable_debug;
64: AHL_DEBUG_PUB.debug( 'Set_Activity_Details Route','+DebugWfOper+');
65: END IF;
66: fnd_msg_pub.initialize;
67:

Line 64: AHL_DEBUG_PUB.debug( 'Set_Activity_Details Route','+DebugWfOper+');

60:
61: BEGIN
62: IF G_DEBUG='Y' THEN
63: AHL_DEBUG_PUB.enable_debug;
64: AHL_DEBUG_PUB.debug( 'Set_Activity_Details Route','+DebugWfOper+');
65: END IF;
66: fnd_msg_pub.initialize;
67:
68: l_return_status :=fnd_api.g_ret_sts_success;

Line 273: AHL_DEBUG_PUB.enable_debug;

269: l_fullname VARCHAR2(100);
270:
271: BEGIN
272: IF G_DEBUG='Y' THEN
273: AHL_DEBUG_PUB.enable_debug;
274: AHL_DEBUG_PUB.debug( 'Ntf_Forward_FYI','+DebugWfOper+');
275: END IF;
276:
277: document_type := 'text/plain';

Line 274: AHL_DEBUG_PUB.debug( 'Ntf_Forward_FYI','+DebugWfOper+');

270:
271: BEGIN
272: IF G_DEBUG='Y' THEN
273: AHL_DEBUG_PUB.enable_debug;
274: AHL_DEBUG_PUB.debug( 'Ntf_Forward_FYI','+DebugWfOper+');
275: END IF;
276:
277: document_type := 'text/plain';
278:

Line 393: AHL_DEBUG_PUB.enable_debug;

389:
390: BEGIN
391:
392: IF G_DEBUG='Y' THEN
393: AHL_DEBUG_PUB.enable_debug;
394: AHL_DEBUG_PUB.debug( 'Ntf_Approved_FYI ROUTE ','+DebugWfOper+');
395: END IF;
396:
397:

Line 394: AHL_DEBUG_PUB.debug( 'Ntf_Approved_FYI ROUTE ','+DebugWfOper+');

390: BEGIN
391:
392: IF G_DEBUG='Y' THEN
393: AHL_DEBUG_PUB.enable_debug;
394: AHL_DEBUG_PUB.debug( 'Ntf_Approved_FYI ROUTE ','+DebugWfOper+');
395: END IF;
396:
397:
398: document_type := 'text/plain';

Line 509: AHL_DEBUG_PUB.enable_debug;

505: l_operation_rec GetOperationDet%rowtype;
506: BEGIN
507:
508: IF G_DEBUG='Y' THEN
509: AHL_DEBUG_PUB.enable_debug;
510: AHL_DEBUG_PUB.debug( 'Start NtfyFinalApproval','+DebugWfOper+');
511: END IF;
512:
513: document_type := 'text/plain';

Line 510: AHL_DEBUG_PUB.debug( 'Start NtfyFinalApproval','+DebugWfOper+');

506: BEGIN
507:
508: IF G_DEBUG='Y' THEN
509: AHL_DEBUG_PUB.enable_debug;
510: AHL_DEBUG_PUB.debug( 'Start NtfyFinalApproval','+DebugWfOper+');
511: END IF;
512:
513: document_type := 'text/plain';
514:

Line 616: AHL_DEBUG_PUB.enable_debug;

612: l_operation_rec GetOperationDet%rowtype;
613: BEGIN
614:
615: IF G_DEBUG='Y' THEN
616: AHL_DEBUG_PUB.enable_debug;
617: AHL_DEBUG_PUB.debug( 'NtfRejectedFyi','+DebugWfOper+');
618: END IF;
619:
620: document_type := 'text/plain';

Line 617: AHL_DEBUG_PUB.debug( 'NtfRejectedFyi','+DebugWfOper+');

613: BEGIN
614:
615: IF G_DEBUG='Y' THEN
616: AHL_DEBUG_PUB.enable_debug;
617: AHL_DEBUG_PUB.debug( 'NtfRejectedFyi','+DebugWfOper+');
618: END IF;
619:
620: document_type := 'text/plain';
621:

Line 735: AHL_DEBUG_PUB.enable_debug;

731: l_fullname VARCHAR2(100);
732: BEGIN
733:
734: IF G_DEBUG='Y' THEN
735: AHL_DEBUG_PUB.enable_debug;
736: AHL_DEBUG_PUB.debug( 'Start Notify Approval','+DebugWfOper+');
737: END IF;
738:
739: document_type := 'text/plain';

Line 736: AHL_DEBUG_PUB.debug( 'Start Notify Approval','+DebugWfOper+');

732: BEGIN
733:
734: IF G_DEBUG='Y' THEN
735: AHL_DEBUG_PUB.enable_debug;
736: AHL_DEBUG_PUB.debug( 'Start Notify Approval','+DebugWfOper+');
737: END IF;
738:
739: document_type := 'text/plain';
740:

Line 861: AHL_DEBUG_PUB.enable_debug;

857: l_operation_rec GetOperationDet%rowtype;
858: BEGIN
859:
860: IF G_DEBUG='Y' THEN
861: AHL_DEBUG_PUB.enable_debug;
862: AHL_DEBUG_PUB.debug( 'Start NtfAprRemainder','+DebugWfOper+');
863: END IF;
864:
865: document_type := 'text/plain';

Line 862: AHL_DEBUG_PUB.debug( 'Start NtfAprRemainder','+DebugWfOper+');

858: BEGIN
859:
860: IF G_DEBUG='Y' THEN
861: AHL_DEBUG_PUB.enable_debug;
862: AHL_DEBUG_PUB.debug( 'Start NtfAprRemainder','+DebugWfOper+');
863: END IF;
864:
865: document_type := 'text/plain';
866:

Line 986: AHL_DEBUG_PUB.enable_debug;

982:
983: l_operation_rec GetOperationDet%rowtype;
984: BEGIN
985: IF G_DEBUG='Y' THEN
986: AHL_DEBUG_PUB.enable_debug;
987: AHL_DEBUG_PUB.debug( 'Start NtfErrorAct','+DebugWfOper+');
988: END IF;
989:
990:

Line 987: AHL_DEBUG_PUB.debug( 'Start NtfErrorAct','+DebugWfOper+');

983: l_operation_rec GetOperationDet%rowtype;
984: BEGIN
985: IF G_DEBUG='Y' THEN
986: AHL_DEBUG_PUB.enable_debug;
987: AHL_DEBUG_PUB.debug( 'Start NtfErrorAct','+DebugWfOper+');
988: END IF;
989:
990:
991: document_type := 'text/plain';

Line 1122: AHL_DEBUG_PUB.enable_debug;

1118:
1119: l_operation_rec GetOperationDet%rowtype;
1120: BEGIN
1121: IF G_DEBUG='Y' THEN
1122: AHL_DEBUG_PUB.enable_debug;
1123: AHL_DEBUG_PUB.debug( 'Start UpdateStatus','+DebugWfOper+');
1124: END IF;
1125:
1126: IF funcmode = 'RUN' THEN

Line 1123: AHL_DEBUG_PUB.debug( 'Start UpdateStatus','+DebugWfOper+');

1119: l_operation_rec GetOperationDet%rowtype;
1120: BEGIN
1121: IF G_DEBUG='Y' THEN
1122: AHL_DEBUG_PUB.enable_debug;
1123: AHL_DEBUG_PUB.debug( 'Start UpdateStatus','+DebugWfOper+');
1124: END IF;
1125:
1126: IF funcmode = 'RUN' THEN
1127: l_approval_status := wf_engine.getitemattrtext(

Line 1133: AHL_DEBUG_PUB.debug( 'Update Status After Getitemattrtext','+DebugWfOper+');

1129: ,itemkey => itemkey
1130: ,aname => 'UPDATE_GEN_STATUS'
1131: );
1132: IF G_DEBUG='Y' THEN
1133: AHL_DEBUG_PUB.debug( 'Update Status After Getitemattrtext','+DebugWfOper+');
1134: END IF;
1135:
1136: IF l_approval_status = 'APPROVED' THEN
1137: l_next_status := wf_engine.getitemattrText(

Line 1180: AHL_DEBUG_PUB.debug( 'Before CompleteOperRev'||l_approval_status,'+DebugWfOper+');

1176: end if;
1177:
1178: CLOSE GetOperationDet;
1179: IF G_DEBUG='Y' THEN
1180: AHL_DEBUG_PUB.debug( 'Before CompleteOperRev'||l_approval_status,'+DebugWfOper+');
1181: END IF;
1182:
1183: AHL_RM_APPROVAL_PVT.COMPLETE_OPER_REVISION
1184: (

Line 1200: AHL_DEBUG_PUB.debug( 'After CompleteOperRev'||l_approval_status,'+DebugWfOper+');

1196: p_object_version_number =>l_object_version_number,
1197: p_approver_note =>l_approver_note
1198: );
1199: IF G_DEBUG='Y' THEN
1200: AHL_DEBUG_PUB.debug( 'After CompleteOperRev'||l_approval_status,'+DebugWfOper+');
1201: END IF;
1202:
1203: COMMIT;
1204: resultout := 'COMPLETE:';

Line 1227: AHL_DEBUG_PUB.debug( 'GExec Error:'||sqlerrm,'+DebugWfOper+');

1223:
1224: EXCEPTION
1225: WHEN fnd_api.g_exc_error THEN
1226: IF G_DEBUG='Y' THEN
1227: AHL_DEBUG_PUB.debug( 'GExec Error:'||sqlerrm,'+DebugWfOper+');
1228: END IF;
1229: FND_MSG_PUB.Count_And_Get (
1230: p_encoded => FND_API.G_FALSE,
1231: p_count => l_msg_count,

Line 1248: AHL_DEBUG_PUB.debug( 'When others Error:'||sqlerrm,'+DebugwfOper+');

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'

Line 1291: AHL_DEBUG_PUB.enable_debug;

1287: l_return_status VARCHAR2(1);
1288:
1289: BEGIN
1290: IF G_DEBUG='Y' THEN
1291: AHL_DEBUG_PUB.enable_debug;
1292: AHL_DEBUG_PUB.debug( 'Start Revert Status','+WfforOper+');
1293: END IF;
1294:
1295: l_return_Status:='S';

Line 1292: AHL_DEBUG_PUB.debug( 'Start Revert Status','+WfforOper+');

1288:
1289: BEGIN
1290: IF G_DEBUG='Y' THEN
1291: AHL_DEBUG_PUB.enable_debug;
1292: AHL_DEBUG_PUB.debug( 'Start Revert Status','+WfforOper+');
1293: END IF;
1294:
1295: l_return_Status:='S';
1296: IF funcmode = 'RUN' THEN