eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_FMP_MR_APPROVAL_PVT dependencies on AHL_DEBUG_PUB

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

1: PACKAGE BODY AHL_FMP_MR_APPROVAL_PVT AS
2: /* $Header: AHLVMWKB.pls 120.1.12020000.2 2012/12/07 00:51:05 sareepar ship $ */
3: --G_DEBUG VARCHAR2(1):=FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');
4: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
5:
6:
7: PROCEDURE Set_Activity_Details(
8: itemtype IN VARCHAR2

Line 40: AHL_DEBUG_PUB.enable_debug;

36: where mr_header_id=c_mr_header_id;
37: l_mr_rec GetMrHeaderDet%rowtype;
38: BEGIN
39: IF G_DEBUG='Y' THEN
40: AHL_DEBUG_PUB.enable_debug;
41: AHL_DEBUG_PUB.debug( 'Start Set Actvity Details');
42: END IF;
43:
44: fnd_msg_pub.initialize;

Line 41: AHL_DEBUG_PUB.debug( 'Start Set Actvity Details');

37: l_mr_rec GetMrHeaderDet%rowtype;
38: BEGIN
39: IF G_DEBUG='Y' THEN
40: AHL_DEBUG_PUB.enable_debug;
41: AHL_DEBUG_PUB.debug( 'Start Set Actvity Details');
42: END IF;
43:
44: fnd_msg_pub.initialize;
45: l_return_status := fnd_api.g_ret_sts_success;

Line 195: AHL_DEBUG_PUB.debug( 'Set Activity l_approval_RULE_ID-->'||l_approval_rule_id);

191: ------------------------------------------------------------------------------
192: -- Get Approval Rule and First Approver Sequence
193: ------------------------------------------------------------------------------
194: IF G_DEBUG='Y' THEN
195: AHL_DEBUG_PUB.debug( 'Set Activity l_approval_RULE_ID-->'||l_approval_rule_id);
196: END IF;
197:
198: ahl_generic_aprv_pvt.get_approval_details(
199: p_object => l_object,

Line 209: AHL_DEBUG_PUB.debug('Get approval details-->'||l_APPROVAL_RULE_ID);

205: );
206:
207:
208: IF G_DEBUG='Y' THEN
209: AHL_DEBUG_PUB.debug('Get approval details-->'||l_APPROVAL_RULE_ID);
210: END IF;
211:
212: IF l_return_status = fnd_api.g_ret_sts_success THEN
213:

Line 259: AHL_DEBUG_PUB.disable_debug;

255: RETURN;
256: END IF;
257: --
258: IF G_DEBUG='Y' THEN
259: AHL_DEBUG_PUB.disable_debug;
260: END IF;
261:
262: EXCEPTION
263: WHEN fnd_api.G_EXC_ERROR THEN

Line 288: AHL_DEBUG_PUB.disable_debug;

284: l_error_msg);
285:
286: resultout := 'COMPLETE:ERROR';
287: IF G_DEBUG='Y' THEN
288: AHL_DEBUG_PUB.disable_debug;
289: END IF;
290:
291: WHEN OTHERS THEN
292: wf_core.context(

Line 301: AHL_DEBUG_PUB.disable_debug;

297: ,actid
298: ,'Unexpected Error!'
299: );
300: IF G_DEBUG='Y' THEN
301: AHL_DEBUG_PUB.disable_debug;
302: END IF;
303: RAISE;
304:
305: END Set_Activity_Details;

Line 340: AHL_DEBUG_PUB.enable_debug;

336: where mr_header_id=c_mr_header_id;
337: l_mr_header_rec GetMrHeaderDet%rowtype;
338: BEGIN
339: IF G_DEBUG='Y' THEN
340: AHL_DEBUG_PUB.enable_debug;
341: AHL_DEBUG_PUB.debug( 'Start Notify Forward');
342: END IF;
343:
344: -- Debug info.

Line 341: AHL_DEBUG_PUB.debug( 'Start Notify Forward');

337: l_mr_header_rec GetMrHeaderDet%rowtype;
338: BEGIN
339: IF G_DEBUG='Y' THEN
340: AHL_DEBUG_PUB.enable_debug;
341: AHL_DEBUG_PUB.debug( 'Start Notify Forward');
342: END IF;
343:
344: -- Debug info.
345: document_type := 'text/plain';

Line 404: AHL_DEBUG_PUB.disable_debug;

400: l_subject:= fnd_message.get||'-'||l_body;
401: document := document || l_body;
402:
403: IF G_DEBUG='Y' THEN
404: AHL_DEBUG_PUB.disable_debug;
405: END IF;
406: RETURN;
407:
408: EXCEPTION

Line 426: AHL_DEBUG_PUB.disable_debug;

422: ) ;
423: wf_core.context('AHL_FMP_MR_APPROVAL_PVT','NTF_FORWARD_FYI',
424: l_item_type,l_item_key,l_error_msg);
425: IF G_DEBUG='Y' THEN
426: AHL_DEBUG_PUB.disable_debug;
427: END IF;
428: RAISE;
429: WHEN OTHERS THEN
430: wf_core.context( 'AHLGAPP'

Line 436: AHL_DEBUG_PUB.disable_debug;

432: , l_item_type
433: , l_item_key
434: );
435: IF G_DEBUG='Y' THEN
436: AHL_DEBUG_PUB.disable_debug;
437: END IF;
438: RAISE;
439: END Ntf_Forward_FYI;
440:

Line 470: AHL_DEBUG_PUB.enable_debug;

466: l_mr_header_rec GetMrHeaderDet%rowtype;
467:
468: BEGIN
469: IF G_DEBUG='Y' THEN
470: AHL_DEBUG_PUB.enable_debug;
471: AHL_DEBUG_PUB.debug( 'Start Notify Approved FYI');
472: END IF;
473: document_type := 'text/plain';
474:

Line 471: AHL_DEBUG_PUB.debug( 'Start Notify Approved FYI');

467:
468: BEGIN
469: IF G_DEBUG='Y' THEN
470: AHL_DEBUG_PUB.enable_debug;
471: AHL_DEBUG_PUB.debug( 'Start Notify Approved FYI');
472: END IF;
473: document_type := 'text/plain';
474:
475: l_hyphen_pos1 := INSTR(document_id, ':');

Line 525: AHL_DEBUG_PUB.disable_debug;

521: l_body :=l_body||'.'||fnd_message.get;
522: l_subject :=l_body||fnd_message.get;
523: document := document || l_body;
524: IF G_DEBUG='Y' THEN
525: AHL_DEBUG_PUB.disable_debug;
526: END IF;
527:
528: RETURN;
529:

Line 548: AHL_DEBUG_PUB.disable_debug;

544: ) ;
545: wf_core.context('AHL_FMP_MR_APPROVAL_PVT','Ntf_Approved_FYI',
546: l_item_type,l_item_key,l_error_msg);
547: IF G_DEBUG='Y' THEN
548: AHL_DEBUG_PUB.disable_debug;
549: END IF;
550: RAISE;
551: WHEN OTHERS THEN
552: wf_core.context( 'AHLGAPP'

Line 558: AHL_DEBUG_PUB.disable_debug;

554: , l_item_type
555: , l_item_key
556: );
557: IF G_DEBUG='Y' THEN
558: AHL_DEBUG_PUB.disable_debug;
559: END IF;
560: RAISE;
561: END Ntf_Approved_FYI;
562:

Line 590: AHL_DEBUG_PUB.enable_debug;

586: l_mr_header_rec GetMrHeaderDet%rowtype;
587:
588: BEGIN
589: IF G_DEBUG='Y' THEN
590: AHL_DEBUG_PUB.enable_debug;
591: AHL_DEBUG_PUB.debug( 'Start NTF Final approval');
592: END IF;
593:
594: document_type := 'text/plain';

Line 591: AHL_DEBUG_PUB.debug( 'Start NTF Final approval');

587:
588: BEGIN
589: IF G_DEBUG='Y' THEN
590: AHL_DEBUG_PUB.enable_debug;
591: AHL_DEBUG_PUB.debug( 'Start NTF Final approval');
592: END IF;
593:
594: document_type := 'text/plain';
595:

Line 650: AHL_DEBUG_PUB.disable_debug;

646: l_body :=l_body||'.'|| fnd_message.get;
647:
648: document := document || l_body;
649: IF G_DEBUG='Y' THEN
650: AHL_DEBUG_PUB.disable_debug;
651: END IF;
652:
653: RETURN;
654:

Line 673: AHL_DEBUG_PUB.disable_debug;

669: ) ;
670: wf_core.context('AHL_FMP_MR_APPROVAL_PVT','Ntf_Final_Approval_FYI',
671: l_item_type,l_item_key,l_error_msg);
672: IF G_DEBUG='Y' THEN
673: AHL_DEBUG_PUB.disable_debug;
674: END IF;
675: RAISE;
676: WHEN OTHERS THEN
677: wf_core.context( 'AHLGAPP'

Line 683: AHL_DEBUG_PUB.disable_debug;

679: , l_item_type
680: , l_item_key
681: );
682: IF G_DEBUG='Y' THEN
683: AHL_DEBUG_PUB.disable_debug;
684: END IF;
685: RAISE;
686: END Ntf_Final_Approval_FYI;
687:

Line 714: AHL_DEBUG_PUB.enable_debug;

710: where mr_header_id=c_mr_header_id;
711: l_mr_header_rec GetMrHeaderDet%rowtype;
712: BEGIN
713: IF G_DEBUG='Y' THEN
714: AHL_DEBUG_PUB.enable_debug;
715: AHL_DEBUG_PUB.debug( 'Start Notify Rejected');
716: END IF;
717: document_type := 'text/plain';
718:

Line 715: AHL_DEBUG_PUB.debug( 'Start Notify Rejected');

711: l_mr_header_rec GetMrHeaderDet%rowtype;
712: BEGIN
713: IF G_DEBUG='Y' THEN
714: AHL_DEBUG_PUB.enable_debug;
715: AHL_DEBUG_PUB.debug( 'Start Notify Rejected');
716: END IF;
717: document_type := 'text/plain';
718:
719: -- parse document_id for the ':' dividing item type name from item key value

Line 773: AHL_DEBUG_PUB.disable_debug;

769: l_subject:= l_body||fnd_message.get;
770:
771: document := document || l_body;
772: IF G_DEBUG='Y' THEN
773: AHL_DEBUG_PUB.disable_debug;
774: END IF;
775: RETURN;
776:
777: EXCEPTION

Line 795: AHL_DEBUG_PUB.disable_debug;

791: ) ;
792: wf_core.context('AHL_FMP_MR_APPROVAL_PVT','Ntf_Rejected_FYI',
793: l_item_type,l_item_key,l_error_msg);
794: IF G_DEBUG='Y' THEN
795: AHL_DEBUG_PUB.disable_debug;
796: END IF;
797: RAISE;
798:
799: WHEN OTHERS THEN

Line 806: AHL_DEBUG_PUB.disable_debug;

802: , l_item_type
803: , l_item_key
804: );
805: IF G_DEBUG='Y' THEN
806: AHL_DEBUG_PUB.disable_debug;
807: END IF;
808: RAISE;
809: END Ntf_Rejected_FYI;
810:

Line 840: AHL_DEBUG_PUB.enable_debug;

836: l_mr_header_rec GetMrHeaderDet%rowtype;
837: BEGIN
838:
839: IF G_DEBUG='Y' THEN
840: AHL_DEBUG_PUB.enable_debug;
841: AHL_DEBUG_PUB.debug( 'Start Nty_approval');
842: END IF;
843:
844: document_type := 'text/plain';

Line 841: AHL_DEBUG_PUB.debug( 'Start Nty_approval');

837: BEGIN
838:
839: IF G_DEBUG='Y' THEN
840: AHL_DEBUG_PUB.enable_debug;
841: AHL_DEBUG_PUB.debug( 'Start Nty_approval');
842: END IF;
843:
844: document_type := 'text/plain';
845:

Line 901: AHL_DEBUG_PUB.disable_debug;

897: l_body :=l_body||fnd_message.get;
898: document := document || l_body;
899:
900: IF G_DEBUG='Y' THEN
901: AHL_DEBUG_PUB.disable_debug;
902: END IF;
903: RETURN;
904: EXCEPTION
905: WHEN FND_API.G_EXC_ERROR THEN

Line 922: AHL_DEBUG_PUB.disable_debug;

918: ) ;
919: wf_core.context('AHL_FMP_MR_APPROVAL_PVT','Ntf_Approval',
920: l_item_type,l_item_key,l_error_msg);
921: IF G_DEBUG='Y' THEN
922: AHL_DEBUG_PUB.disable_debug;
923: END IF;
924: RAISE;
925: WHEN OTHERS THEN
926: wf_core.context( 'AHLGAPP'

Line 932: AHL_DEBUG_PUB.disable_debug;

928: , l_item_type
929: , l_item_key
930: );
931: IF G_DEBUG='Y' THEN
932: AHL_DEBUG_PUB.disable_debug;
933: END IF;
934: RAISE;
935: END Ntf_Approval;
936:

Line 965: AHL_DEBUG_PUB.enable_debug;

961: where mr_header_id=c_mr_header_id;
962: l_mr_header_rec GetMrHeaderDet%rowtype;
963: BEGIN
964: IF G_DEBUG='Y' THEN
965: AHL_DEBUG_PUB.enable_debug;
966: AHL_DEBUG_PUB.debug( 'Start ntfy Apprvl remainder');
967: END IF;
968: document_type := 'text/plain';
969:

Line 966: AHL_DEBUG_PUB.debug( 'Start ntfy Apprvl remainder');

962: l_mr_header_rec GetMrHeaderDet%rowtype;
963: BEGIN
964: IF G_DEBUG='Y' THEN
965: AHL_DEBUG_PUB.enable_debug;
966: AHL_DEBUG_PUB.debug( 'Start ntfy Apprvl remainder');
967: END IF;
968: document_type := 'text/plain';
969:
970: l_hyphen_pos1 := INSTR(document_id, ':');

Line 1021: AHL_DEBUG_PUB.disable_debug;

1017: --l_body :=l_body||'.'|| 'Reminder: You just received a request from '||l_requester;
1018: --l_body := l_body ||'. The note from him/her is as following: '||l_requester_note;
1019: document := document || l_body;
1020: IF G_DEBUG='Y' THEN
1021: AHL_DEBUG_PUB.disable_debug;
1022: END IF;
1023:
1024: RETURN;
1025:

Line 1044: AHL_DEBUG_PUB.disable_debug;

1040: ) ;
1041: wf_core.context('AHL_FMP_MR_APPROVAL_PVT','Ntf_Approval_Reminder',
1042: l_item_type,l_item_key,l_error_msg);
1043: IF G_DEBUG='Y' THEN
1044: AHL_DEBUG_PUB.disable_debug;
1045: END IF;
1046: RAISE;
1047: WHEN OTHERS THEN
1048: wf_core.context( 'AHLGAPP'

Line 1054: AHL_DEBUG_PUB.disable_debug;

1050: , l_item_type
1051: , l_item_key
1052: );
1053: IF G_DEBUG='Y' THEN
1054: AHL_DEBUG_PUB.disable_debug;
1055: END IF;
1056: RAISE;
1057: END Ntf_Approval_Reminder;
1058:

Line 1087: AHL_DEBUG_PUB.enable_debug;

1083: where mr_header_id=c_mr_header_id;
1084: l_mr_header_rec GetMrHeaderDet%rowtype;
1085: BEGIN
1086: IF G_DEBUG='Y' THEN
1087: AHL_DEBUG_PUB.enable_debug;
1088: AHL_DEBUG_PUB.debug( 'Start Ntfy error','+NOTIFY ERROR ACT+');
1089: END IF;
1090:
1091:

Line 1088: AHL_DEBUG_PUB.debug( 'Start Ntfy error','+NOTIFY ERROR ACT+');

1084: l_mr_header_rec GetMrHeaderDet%rowtype;
1085: BEGIN
1086: IF G_DEBUG='Y' THEN
1087: AHL_DEBUG_PUB.enable_debug;
1088: AHL_DEBUG_PUB.debug( 'Start Ntfy error','+NOTIFY ERROR ACT+');
1089: END IF;
1090:
1091:
1092: document_type := 'text/plain';

Line 1142: AHL_DEBUG_PUB.disable_debug;

1138: l_body := l_body || 'Error Message'||l_error_msg;
1139:
1140: document := document || l_body;
1141: IF G_DEBUG='Y' THEN
1142: AHL_DEBUG_PUB.disable_debug;
1143: END IF;
1144:
1145: RETURN;
1146:

Line 1165: AHL_DEBUG_PUB.disable_debug;

1161: ) ;
1162: wf_core.context('AHL_FMP_MR_APPROVAL_PVT','Ntf_Error_Act',
1163: l_item_type,l_item_key,l_error_msg);
1164: IF G_DEBUG='Y' THEN
1165: AHL_DEBUG_PUB.disable_debug;
1166: END IF;
1167: RAISE;
1168: WHEN OTHERS THEN
1169: wf_core.context( 'AHL_FMP_MR_APPROVAL_PVT'

Line 1175: AHL_DEBUG_PUB.disable_debug;

1171: , l_item_type
1172: , l_item_key
1173: );
1174: IF G_DEBUG='Y' THEN
1175: AHL_DEBUG_PUB.disable_debug;
1176: END IF;
1177: RAISE;
1178: END Ntf_Error_Act;
1179:

Line 1214: AHL_DEBUG_PUB.enable_debug;

1210: l_default VARCHAR2(1):= FND_API.G_FALSE;
1211:
1212: BEGIN
1213: IF G_DEBUG='Y' THEN
1214: AHL_DEBUG_PUB.enable_debug;
1215: AHL_DEBUG_PUB.debug( 'Start Update Status API','+UPDATE_STATUS+');
1216: END IF;
1217:
1218: IF funcmode = 'RUN' THEN

Line 1215: AHL_DEBUG_PUB.debug( 'Start Update Status API','+UPDATE_STATUS+');

1211:
1212: BEGIN
1213: IF G_DEBUG='Y' THEN
1214: AHL_DEBUG_PUB.enable_debug;
1215: AHL_DEBUG_PUB.debug( 'Start Update Status API','+UPDATE_STATUS+');
1216: END IF;
1217:
1218: IF funcmode = 'RUN' THEN
1219: l_approval_status := wf_engine.getitemattrtext(

Line 1252: AHL_DEBUG_PUB.debug( 'l_object_id mr_header_id'||l_object_id);

1248: ,aname => 'OBJECT_ID'
1249: );
1250:
1251: IF G_DEBUG='Y' THEN
1252: AHL_DEBUG_PUB.debug( 'l_object_id mr_header_id'||l_object_id);
1253: AHL_DEBUG_PUB.debug( 'Approval Status--->'||l_approval_status);
1254: AHL_DEBUG_PUB.debug( 'Before complete complete_mr_revision api');
1255: END IF;
1256: AHL_FMP_MR_REVISION_PVT.COMPLETE_MR_REVISION

Line 1253: AHL_DEBUG_PUB.debug( 'Approval Status--->'||l_approval_status);

1249: );
1250:
1251: IF G_DEBUG='Y' THEN
1252: AHL_DEBUG_PUB.debug( 'l_object_id mr_header_id'||l_object_id);
1253: AHL_DEBUG_PUB.debug( 'Approval Status--->'||l_approval_status);
1254: AHL_DEBUG_PUB.debug( 'Before complete complete_mr_revision api');
1255: END IF;
1256: AHL_FMP_MR_REVISION_PVT.COMPLETE_MR_REVISION
1257: (

Line 1254: AHL_DEBUG_PUB.debug( 'Before complete complete_mr_revision api');

1250:
1251: IF G_DEBUG='Y' THEN
1252: AHL_DEBUG_PUB.debug( 'l_object_id mr_header_id'||l_object_id);
1253: AHL_DEBUG_PUB.debug( 'Approval Status--->'||l_approval_status);
1254: AHL_DEBUG_PUB.debug( 'Before complete complete_mr_revision api');
1255: END IF;
1256: AHL_FMP_MR_REVISION_PVT.COMPLETE_MR_REVISION
1257: (
1258: p_api_version =>l_api_version,

Line 1272: AHL_DEBUG_PUB.debug( 'After complete Update Status');

1268: p_mr_header_id =>l_object_id,
1269: p_object_version_number =>l_object_version_number
1270: );
1271: IF G_DEBUG='Y' THEN
1272: AHL_DEBUG_PUB.debug( 'After complete Update Status');
1273: END IF;
1274: COMMIT;
1275: resultout := 'COMPLETE:';
1276: IF G_DEBUG='Y' THEN

Line 1277: AHL_DEBUG_PUB.disable_debug;

1273: END IF;
1274: COMMIT;
1275: resultout := 'COMPLETE:';
1276: IF G_DEBUG='Y' THEN
1277: AHL_DEBUG_PUB.disable_debug;
1278: END IF;
1279: RETURN;
1280: END IF;
1281:

Line 1287: AHL_DEBUG_PUB.disable_debug;

1283: --
1284: IF (funcmode = 'CANCEL') THEN
1285: resultout := 'COMPLETE:';
1286: IF G_DEBUG='Y' THEN
1287: AHL_DEBUG_PUB.disable_debug;
1288: END IF;
1289: RETURN;
1290: END IF;
1291:

Line 1298: AHL_DEBUG_PUB.disable_debug;

1294: --
1295: IF (funcmode = 'TIMEOUT') THEN
1296: resultout := 'COMPLETE:';
1297: IF G_DEBUG='Y' THEN
1298: AHL_DEBUG_PUB.disable_debug;
1299: END IF;
1300: RETURN;
1301: END IF;
1302:

Line 1307: AHL_DEBUG_PUB.debug( ' Error in workflow:'||sqlerrm||'Update_status');

1303:
1304: EXCEPTION
1305: WHEN fnd_api.g_exc_error THEN
1306: IF G_DEBUG='Y' THEN
1307: AHL_DEBUG_PUB.debug( ' Error in workflow:'||sqlerrm||'Update_status');
1308: END IF;
1309:
1310: FND_MSG_PUB.Count_And_Get (
1311: p_encoded => FND_API.G_FALSE,

Line 1326: AHL_DEBUG_PUB.disable_debug;

1322: ) ;
1323: wf_core.context('AHL_FMP_APRV_PVT','UPDATE_STATUS',
1324: itemtype,itemkey,actid,funcmode,l_error_msg);
1325: IF G_DEBUG='Y' THEN
1326: AHL_DEBUG_PUB.disable_debug;
1327: END IF;
1328: RAISE;
1329:
1330: WHEN OTHERS THEN

Line 1332: AHL_DEBUG_PUB.debug( ' Error ...2..'||sqlerrm||'<--From-->UPDATE_STATUS');

1328: RAISE;
1329:
1330: WHEN OTHERS THEN
1331: IF G_DEBUG='Y' THEN
1332: AHL_DEBUG_PUB.debug( ' Error ...2..'||sqlerrm||'<--From-->UPDATE_STATUS');
1333: END IF;
1334:
1335: wf_core.context(
1336: 'AHL_FMP_MR_APPROVAL_PVT'

Line 1345: AHL_DEBUG_PUB.disable_debug;

1341: ,funcmode
1342: ,'Unexpected Error!'
1343: );
1344: IF G_DEBUG='Y' THEN
1345: AHL_DEBUG_PUB.disable_debug;
1346: END IF;
1347: RAISE;
1348:
1349: END Update_Status;

Line 1378: AHL_DEBUG_PUB.enable_debug;

1374: l_return_status VARCHAR2(1);
1375:
1376: BEGIN
1377: IF G_DEBUG='Y' THEN
1378: AHL_DEBUG_PUB.enable_debug;
1379: AHL_DEBUG_PUB.debug( '10010','+REVERT STATUS+');
1380: END IF;
1381:
1382: l_return_Status:='S';

Line 1379: AHL_DEBUG_PUB.debug( '10010','+REVERT STATUS+');

1375:
1376: BEGIN
1377: IF G_DEBUG='Y' THEN
1378: AHL_DEBUG_PUB.enable_debug;
1379: AHL_DEBUG_PUB.debug( '10010','+REVERT STATUS+');
1380: END IF;
1381:
1382: l_return_Status:='S';
1383: IF funcmode = 'RUN' THEN

Line 1421: AHL_DEBUG_PUB.disable_debug;

1417: return;
1418:
1419: end if;
1420: IF G_DEBUG='Y' THEN
1421: AHL_DEBUG_PUB.disable_debug;
1422: END IF;
1423:
1424: COMMIT;
1425: resultout := 'COMPLETE:';

Line 1463: AHL_DEBUG_PUB.disable_debug;

1459: ) ;
1460: wf_core.context('AHL_FMP_MR_APPROVAL_PVT','revert_status',
1461: itemtype,itemkey,actid,funcmode,l_error_msg);
1462: IF G_DEBUG='Y' THEN
1463: AHL_DEBUG_PUB.disable_debug;
1464: END IF;
1465: RAISE;
1466: WHEN OTHERS THEN
1467: wf_core.context(

Line 1477: AHL_DEBUG_PUB.disable_debug;

1473: ,funcmode
1474: ,'Unexpected Error!'
1475: );
1476: IF G_DEBUG='Y' THEN
1477: AHL_DEBUG_PUB.disable_debug;
1478: END IF;
1479: RAISE;
1480:
1481: END Revert_Status;