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

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

1: PACKAGE BODY AHL_RM_RT_OP_DEP_PVT AS
2: /* $Header: AHLVOPDB.pls 120.0.12020000.2 2012/12/07 01:15:32 sareepar noship $ */
3:
4: G_PKG_NAME VARCHAR2(30):='AHL_RM_RT_OP_DEP_PVT';
5: G_DEBUG VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
6:
7:
8: --Default missing Attributes
9:

Line 29: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );

25:
26: BEGIN
27:
28: IF G_DEBUG = 'Y' THEN
29: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
30: END IF;
31:
32: IF p_x_rt_oper_dep_tbl.COUNT >0
33: THEN

Line 303: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : End API' );

299: END LOOP;
300: END IF;
301:
302: IF G_DEBUG = 'Y' THEN
303: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : End API' );
304: END IF;
305: END default_missing_attributes;
306:
307: -- Function to get the Record Identifier for Error Messages

Line 374: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );

370: BEGIN
371: x_return_status := FND_API.G_RET_STS_SUCCESS;
372:
373: IF G_DEBUG = 'Y' THEN
374: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
375: END IF;
376:
377:
378: -- Check if a valid value is passed in p_route_id

Line 455: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : End API' );

451:
452: END LOOP;
453:
454: IF G_DEBUG = 'Y' THEN
455: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : End API' );
456: END IF;
457:
458: END validate_api_inputs;
459:

Line 492: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );

488:
489: x_return_status := FND_API.G_RET_STS_SUCCESS;
490:
491: IF (G_DEBUG = 'Y') THEN
492: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
493: END IF;
494:
495: OPEN get_route_oper_id(p_operation_step,p_operation_number,p_operation_status, p_route_id);
496: FETCH get_route_oper_id INTO l_rt_operation_id;

Line 509: AHL_DEBUG_PUB.debug(G_PKG_NAME||'.'||l_api_name||': INVALID Operation Name , Operation Step and Status' );

505: FND_MESSAGE.SET_TOKEN('STATUS', p_operation_status);
506: FND_MSG_PUB.ADD;
507:
508: IF (G_DEBUG = 'Y') THEN
509: AHL_DEBUG_PUB.debug(G_PKG_NAME||'.'||l_api_name||': INVALID Operation Name , Operation Step and Status' );
510: END IF;
511: ELSE
512: x_operation_step_id := l_rt_operation_id;
513: END IF;

Line 516: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : End API' );

512: x_operation_step_id := l_rt_operation_id;
513: END IF;
514:
515: IF G_DEBUG = 'Y' THEN
516: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : End API' );
517: END IF;
518:
519: END Op_Step_To_Assocoation_id;
520:

Line 543: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );

539: BEGIN
540: x_return_status := FND_API.G_RET_STS_SUCCESS;
541:
542: IF G_DEBUG = 'Y' THEN
543: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
544: END IF;
545:
546: IF G_DEBUG = 'Y' THEN
547: AHL_DEBUG_PUB.DEBUG( G_PKG_NAME || '.' || L_API_NAME || ' : p_route_id - ' || P_ROUTE_ID );

Line 547: AHL_DEBUG_PUB.DEBUG( G_PKG_NAME || '.' || L_API_NAME || ' : p_route_id - ' || P_ROUTE_ID );

543: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
544: END IF;
545:
546: IF G_DEBUG = 'Y' THEN
547: AHL_DEBUG_PUB.DEBUG( G_PKG_NAME || '.' || L_API_NAME || ' : p_route_id - ' || P_ROUTE_ID );
548: AHL_DEBUG_PUB.DEBUG( G_PKG_NAME || '.' || L_API_NAME || ' : p_from_rt_op_id - ' || p_from_rt_op_id );
549: AHL_DEBUG_PUB.DEBUG( G_PKG_NAME || '.' || L_API_NAME || ' : p_from_op_step - ' || p_from_op_step );
550: AHL_DEBUG_PUB.DEBUG( G_PKG_NAME || '.' || L_API_NAME || ' : p_dependency_code - ' || p_dependency_code );
551: END IF;

Line 548: AHL_DEBUG_PUB.DEBUG( G_PKG_NAME || '.' || L_API_NAME || ' : p_from_rt_op_id - ' || p_from_rt_op_id );

544: END IF;
545:
546: IF G_DEBUG = 'Y' THEN
547: AHL_DEBUG_PUB.DEBUG( G_PKG_NAME || '.' || L_API_NAME || ' : p_route_id - ' || P_ROUTE_ID );
548: AHL_DEBUG_PUB.DEBUG( G_PKG_NAME || '.' || L_API_NAME || ' : p_from_rt_op_id - ' || p_from_rt_op_id );
549: AHL_DEBUG_PUB.DEBUG( G_PKG_NAME || '.' || L_API_NAME || ' : p_from_op_step - ' || p_from_op_step );
550: AHL_DEBUG_PUB.DEBUG( G_PKG_NAME || '.' || L_API_NAME || ' : p_dependency_code - ' || p_dependency_code );
551: END IF;
552:

Line 549: AHL_DEBUG_PUB.DEBUG( G_PKG_NAME || '.' || L_API_NAME || ' : p_from_op_step - ' || p_from_op_step );

545:
546: IF G_DEBUG = 'Y' THEN
547: AHL_DEBUG_PUB.DEBUG( G_PKG_NAME || '.' || L_API_NAME || ' : p_route_id - ' || P_ROUTE_ID );
548: AHL_DEBUG_PUB.DEBUG( G_PKG_NAME || '.' || L_API_NAME || ' : p_from_rt_op_id - ' || p_from_rt_op_id );
549: AHL_DEBUG_PUB.DEBUG( G_PKG_NAME || '.' || L_API_NAME || ' : p_from_op_step - ' || p_from_op_step );
550: AHL_DEBUG_PUB.DEBUG( G_PKG_NAME || '.' || L_API_NAME || ' : p_dependency_code - ' || p_dependency_code );
551: END IF;
552:
553: SELECT COUNT(*) INTO l_counter

Line 550: AHL_DEBUG_PUB.DEBUG( G_PKG_NAME || '.' || L_API_NAME || ' : p_dependency_code - ' || p_dependency_code );

546: IF G_DEBUG = 'Y' THEN
547: AHL_DEBUG_PUB.DEBUG( G_PKG_NAME || '.' || L_API_NAME || ' : p_route_id - ' || P_ROUTE_ID );
548: AHL_DEBUG_PUB.DEBUG( G_PKG_NAME || '.' || L_API_NAME || ' : p_from_rt_op_id - ' || p_from_rt_op_id );
549: AHL_DEBUG_PUB.DEBUG( G_PKG_NAME || '.' || L_API_NAME || ' : p_from_op_step - ' || p_from_op_step );
550: AHL_DEBUG_PUB.DEBUG( G_PKG_NAME || '.' || L_API_NAME || ' : p_dependency_code - ' || p_dependency_code );
551: END IF;
552:
553: SELECT COUNT(*) INTO l_counter
554: FROM ahl_rt_oper_dependencies od

Line 566: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : End API' );

562: START WITH to_rt_op_id = p_from_rt_op_id
563: CONNECT BY PRIOR from_rt_op_id = to_rt_op_id;
564:
565: IF G_DEBUG = 'Y' THEN
566: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : End API' );
567: END IF;
568:
569: EXCEPTION
570: WHEN l_cyclic_loop THEN

Line 704: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );

700: FND_MSG_PUB.initialize;
701: END IF;
702:
703: IF G_DEBUG = 'Y' THEN
704: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
705: END IF;
706:
707: -- This is to be added before calling validate_api_inputs()
708: -- Validate Application Usage

Line 756: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : From_rt_op_id' || p_x_rt_oper_dep_tbl(i).from_rt_op_id );

752: x_return_status => l_return_status
753: );
754:
755: IF G_DEBUG = 'Y' THEN
756: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : From_rt_op_id' || p_x_rt_oper_dep_tbl(i).from_rt_op_id );
757: END IF;
758:
759: IF l_return_status = FND_API.G_RET_STS_ERROR
760: THEN

Line 793: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : To_rt_op_id' || p_x_rt_oper_dep_tbl(i).to_rt_op_id );

789: x_return_status => l_return_status
790: );
791:
792: IF G_DEBUG = 'Y' THEN
793: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : To_rt_op_id' || p_x_rt_oper_dep_tbl(i).to_rt_op_id );
794: END IF;
795:
796: IF l_return_status = FND_API.G_RET_STS_ERROR
797: THEN

Line 1100: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : End API' );

1096: COMMIT;
1097: END IF;
1098:
1099: IF G_DEBUG='Y' THEN
1100: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : End API' );
1101: END IF;
1102:
1103:
1104: EXCEPTION