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_RM_APPROVAL_PVT dependencies on AHL_DEBUG_PUB

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

4: G_OBJECT_TYPE VARCHAR2(30):='RM_NTF';
5: G_PM_INSTALL VARCHAR2(30):=ahl_util_pkg.is_pm_installed;
6:
7: -- Local Api
8: G_DEBUG VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;
9: PROCEDURE NOTIFY_TERMINATION
10: (
11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,

Line 95: AHL_DEBUG_PUB.enable_debug;

91: BEGIN
92: SAVEPOINT NOTIFY_TERMINATION;
93:
94: IF G_DEBUG='Y' THEN
95: AHL_DEBUG_PUB.enable_debug;
96: AHL_DEBUG_PUB.debug( 'Enter Notifications','+RM_NOTIFY+');
97: END IF;
98:
99: IF p_prim_object_type='RM'

Line 96: AHL_DEBUG_PUB.debug( 'Enter Notifications','+RM_NOTIFY+');

92: SAVEPOINT NOTIFY_TERMINATION;
93:
94: IF G_DEBUG='Y' THEN
95: AHL_DEBUG_PUB.enable_debug;
96: AHL_DEBUG_PUB.debug( 'Enter Notifications','+RM_NOTIFY+');
97: END IF;
98:
99: IF p_prim_object_type='RM'
100: THEN

Line 346: AHL_DEBUG_PUB.enable_debug;

342:
343: -- Check if API is called in debug mode. If yes, enable debug.
344:
345: IF G_DEBUG='Y' THEN
346: AHL_DEBUG_PUB.enable_debug;
347: AHL_DEBUG_PUB.debug( 'Enter Initiate OPERATION Approval..','+HEADERS+');
348: END IF;
349:
350: -- Standard call to check for call compatibility.

Line 347: AHL_DEBUG_PUB.debug( 'Enter Initiate OPERATION Approval..','+HEADERS+');

343: -- Check if API is called in debug mode. If yes, enable debug.
344:
345: IF G_DEBUG='Y' THEN
346: AHL_DEBUG_PUB.enable_debug;
347: AHL_DEBUG_PUB.debug( 'Enter Initiate OPERATION Approval..','+HEADERS+');
348: END IF;
349:
350: -- Standard call to check for call compatibility.
351:

Line 439: AHL_DEBUG_PUB.debug( 'AHL_rm_util.Validate_rt_oper_start_date','+OPER+');

435: FND_MESSAGE.SET_NAME('AHL',l_msg);
436: FND_MESSAGE.set_token('FIELD',l_start_Date);
437: FND_MSG_PUB.ADD;
438: IF G_DEBUG='Y' THEN
439: AHL_DEBUG_PUB.debug( 'AHL_rm_util.Validate_rt_oper_start_date','+OPER+');
440: END IF;
441: ELSIF TRUNC(l_oper_rec.START_DATE_ACTIVE) 442: THEN
443: FND_MESSAGE.SET_NAME('AHL','AHL_RM_INVALID_ST_DATE');

Line 587: AHL_DEBUG_PUB.debug( 'After CompleteOperRevision');

583: );
584:
585: IF G_DEBUG='Y'
586: THEN
587: AHL_DEBUG_PUB.debug( 'After CompleteOperRevision');
588: END IF;
589: END IF ;
590:
591:

Line 686: AHL_DEBUG_PUB.enable_debug;

682:
683: -- Check if API is called in debug mode. If yes, enable debug.
684:
685: IF G_DEBUG='Y' THEN
686: AHL_DEBUG_PUB.enable_debug;
687: AHL_DEBUG_PUB.debug( 'Enter Initiate Route Approval','+ROUTES+');
688: AHL_DEBUG_PUB.debug( 'p_approval_type'||p_apprvl_type,'+ROUTES+');
689: END IF;
690:

Line 687: AHL_DEBUG_PUB.debug( 'Enter Initiate Route Approval','+ROUTES+');

683: -- Check if API is called in debug mode. If yes, enable debug.
684:
685: IF G_DEBUG='Y' THEN
686: AHL_DEBUG_PUB.enable_debug;
687: AHL_DEBUG_PUB.debug( 'Enter Initiate Route Approval','+ROUTES+');
688: AHL_DEBUG_PUB.debug( 'p_approval_type'||p_apprvl_type,'+ROUTES+');
689: END IF;
690:
691: -- Standard call to check for call compatibility.

Line 688: AHL_DEBUG_PUB.debug( 'p_approval_type'||p_apprvl_type,'+ROUTES+');

684:
685: IF G_DEBUG='Y' THEN
686: AHL_DEBUG_PUB.enable_debug;
687: AHL_DEBUG_PUB.debug( 'Enter Initiate Route Approval','+ROUTES+');
688: AHL_DEBUG_PUB.debug( 'p_approval_type'||p_apprvl_type,'+ROUTES+');
689: END IF;
690:
691: -- Standard call to check for call compatibility.
692:

Line 776: AHL_DEBUG_PUB.debug('AHL_rm_util.Validate_rt_oper_start_date','+ROUTE+');

772: FND_MESSAGE.SET_NAME('AHL',l_msg);
773: FND_MESSAGE.set_token('FIELD',l_start_Date);
774: FND_MSG_PUB.ADD;
775: IF G_DEBUG='Y' THEN
776: AHL_DEBUG_PUB.debug('AHL_rm_util.Validate_rt_oper_start_date','+ROUTE+');
777: END IF;
778: ELSIF TRUNC(l_route_rec.START_DATE_ACTIVE) 779: THEN
780: FND_MESSAGE.SET_NAME('AHL','AHL_RM_INVALID_ST_DATE');

Line 973: AHL_DEBUG_PUB.debug( 'After CompleteRouteRevision');

969: p_approver_note =>null
970: );
971: IF G_DEBUG='Y'
972: THEN
973: AHL_DEBUG_PUB.debug( 'After CompleteRouteRevision');
974: END IF;
975: END IF ;
976:
977: l_msg_count := FND_MSG_PUB.count_msg;

Line 1101: AHL_DEBUG_PUB.enable_debug;

1097:
1098: SAVEPOINT COMPLETE_ROUTE_REVISION;
1099:
1100: IF G_DEBUG='Y' THEN
1101: AHL_DEBUG_PUB.enable_debug;
1102: END IF;
1103:
1104: SELECT REVISION_STATUS_CODE INTO l_curr_status
1105: FROM AHL_ROUTES_APP_V WHERE ROUTE_ID=p_route_id;

Line 1125: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:p_route_id'||p_route_id);

1121: IF p_route_id is not null or p_route_id<>fnd_api.g_miss_num
1122: THEN
1123: IF G_DEBUG='Y'
1124: THEN
1125: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:p_route_id'||p_route_id);
1126: END IF;
1127: OPEN GetRouteDet(p_route_id);
1128:
1129: FETCH GetRouteDet INTO l_route_rec;

Line 1203: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:p_route_id'||p_route_id);

1199:
1200: l_check_flag2:='Y';
1201: IF G_DEBUG='Y'
1202: THEN
1203: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:p_route_id'||p_route_id);
1204: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:l_status'||l_status);
1205: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:l_route_rec.revision_number'||l_route_rec.revision_number);
1206: END IF;
1207: Elsif l_check_flag='Y' and l_route_rec.revision_number>1 and

Line 1204: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:l_status'||l_status);

1200: l_check_flag2:='Y';
1201: IF G_DEBUG='Y'
1202: THEN
1203: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:p_route_id'||p_route_id);
1204: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:l_status'||l_status);
1205: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:l_route_rec.revision_number'||l_route_rec.revision_number);
1206: END IF;
1207: Elsif l_check_flag='Y' and l_route_rec.revision_number>1 and
1208: l_curr_status='APPROVAL_PENDING' AND p_appr_status='APPROVED'

Line 1205: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:l_route_rec.revision_number'||l_route_rec.revision_number);

1201: IF G_DEBUG='Y'
1202: THEN
1203: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:p_route_id'||p_route_id);
1204: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:l_status'||l_status);
1205: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:l_route_rec.revision_number'||l_route_rec.revision_number);
1206: END IF;
1207: Elsif l_check_flag='Y' and l_route_rec.revision_number>1 and
1208: l_curr_status='APPROVAL_PENDING' AND p_appr_status='APPROVED'
1209: THEN

Line 1212: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:p_route_id'||p_route_id);

1208: l_curr_status='APPROVAL_PENDING' AND p_appr_status='APPROVED'
1209: THEN
1210: IF G_DEBUG='Y'
1211: THEN
1212: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:p_route_id'||p_route_id);
1213: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:l_status'||l_status);
1214: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:l_route_rec.revision_number'||l_route_rec.revision_number);
1215: END IF;
1216: OPEN GetPrevRouteDet(l_route_rec.revision_number,l_route_rec.route_no);

Line 1213: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:l_status'||l_status);

1209: THEN
1210: IF G_DEBUG='Y'
1211: THEN
1212: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:p_route_id'||p_route_id);
1213: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:l_status'||l_status);
1214: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:l_route_rec.revision_number'||l_route_rec.revision_number);
1215: END IF;
1216: OPEN GetPrevRouteDet(l_route_rec.revision_number,l_route_rec.route_no);
1217:

Line 1214: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:l_route_rec.revision_number'||l_route_rec.revision_number);

1210: IF G_DEBUG='Y'
1211: THEN
1212: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:p_route_id'||p_route_id);
1213: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:l_status'||l_status);
1214: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:l_route_rec.revision_number'||l_route_rec.revision_number);
1215: END IF;
1216: OPEN GetPrevRouteDet(l_route_rec.revision_number,l_route_rec.route_no);
1217:
1218: FETCH GetPrevRouteDet INTO l_prev_route_rec;

Line 1396: AHL_DEBUG_PUB.debug( 'Before commit Complete_route_revision Status----->'||p_appr_status,'+DEBUG_RELATIONS+');

1392: RAISE FND_API.G_EXC_ERROR;
1393: END IF;
1394:
1395: IF G_DEBUG='Y' THEN
1396: AHL_DEBUG_PUB.debug( 'Before commit Complete_route_revision Status----->'||p_appr_status,'+DEBUG_RELATIONS+');
1397: END IF;
1398:
1399: IF FND_API.TO_BOOLEAN(p_commit) THEN
1400: COMMIT;

Line 1495: AHL_DEBUG_PUB.enable_debug;

1491: BEGIN
1492: SAVEPOINT COMPLETE_OPER_REVISION;
1493:
1494: IF G_DEBUG='Y' THEN
1495: AHL_DEBUG_PUB.enable_debug;
1496: AHL_DEBUG_PUB.debug( 'Complete_mr_revision Status----->'||p_appr_status,'+DEBUG_RELATIONS+');
1497: END IF;
1498:
1499: SELECT REVISION_STATUS_CODE INTO l_curr_status

Line 1496: AHL_DEBUG_PUB.debug( 'Complete_mr_revision Status----->'||p_appr_status,'+DEBUG_RELATIONS+');

1492: SAVEPOINT COMPLETE_OPER_REVISION;
1493:
1494: IF G_DEBUG='Y' THEN
1495: AHL_DEBUG_PUB.enable_debug;
1496: AHL_DEBUG_PUB.debug( 'Complete_mr_revision Status----->'||p_appr_status,'+DEBUG_RELATIONS+');
1497: END IF;
1498:
1499: SELECT REVISION_STATUS_CODE INTO l_curr_status
1500: FROM AHL_OPERATIONS_B_KFV WHERE OPERATION_ID=p_operation_id;

Line 1516: AHL_DEBUG_PUB.debug( 'Complete_operation_revision Status2----->'||L_status,'+DEBUG_REVISION+');

1512: l_check_flag3:='N';
1513: END IF;
1514:
1515: IF G_DEBUG='Y' THEN
1516: AHL_DEBUG_PUB.debug( 'Complete_operation_revision Status2----->'||L_status,'+DEBUG_REVISION+');
1517: AHL_DEBUG_PUB.debug( 'Complete_mr_revision Status2----->'||L_status,'+DEBUG_REVISION+');
1518: END IF;
1519:
1520: IF p_operation_id is not null or p_operation_id<>fnd_api.g_miss_num

Line 1517: AHL_DEBUG_PUB.debug( 'Complete_mr_revision Status2----->'||L_status,'+DEBUG_REVISION+');

1513: END IF;
1514:
1515: IF G_DEBUG='Y' THEN
1516: AHL_DEBUG_PUB.debug( 'Complete_operation_revision Status2----->'||L_status,'+DEBUG_REVISION+');
1517: AHL_DEBUG_PUB.debug( 'Complete_mr_revision Status2----->'||L_status,'+DEBUG_REVISION+');
1518: END IF;
1519:
1520: IF p_operation_id is not null or p_operation_id<>fnd_api.g_miss_num
1521: THEN

Line 1654: AHL_DEBUG_PUB.debug( 'INVALID P_MR_HEADER_ID','+COMPLETE_OPERATION_REVISION+');

1650: END IF;
1651: END IF;
1652: ELSE
1653: IF G_DEBUG='Y' THEN
1654: AHL_DEBUG_PUB.debug( 'INVALID P_MR_HEADER_ID','+COMPLETE_OPERATION_REVISION+');
1655: ROLLBACK;
1656: END IF;
1657: END IF;
1658:

Line 1667: AHL_DEBUG_PUB.debug( 'Before commit Complete_mr_revision Status----->'||p_appr_status,'+DEBUG_RELATIONS+');

1663: RAISE FND_API.G_EXC_ERROR;
1664: END IF;
1665:
1666: IF G_DEBUG='Y' THEN
1667: AHL_DEBUG_PUB.debug( 'Before commit Complete_mr_revision Status----->'||p_appr_status,'+DEBUG_RELATIONS+');
1668: END IF;
1669:
1670: IF FND_API.TO_BOOLEAN(p_commit) THEN
1671: COMMIT;