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

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

1: PACKAGE BODY AHL_FMP_MR_ROUTE_SEQNCE_PVT AS
2: /* $Header: AHLVMRSB.pls 120.0 2005/05/26 00:59:55 appldev noship $ */
3:
4: G_PKG_NAME VARCHAR2(30):='AHL_FMP_MR_ROUTE_SEQNCE_PVT';
5: G_DEBUG VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
6: G_APPLN_USAGE VARCHAR2(30):=RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')));
7: -- TAMAL
8: -- Procedure to check for correct route sequence w.r.t stage information for given mr_route...
9: -- Pass p_route_stage_upd = true for calling from AHL_FMP_MR_ROUTE_PVT, and false otherwise...

Line 563: AHL_DEBUG_PUB.debug( 'Stage 13','+DEBUG+');

559: OPEN get_route_num_routeid(p_x_mr_route_seq_rec.mr_route_id);
560: fetch get_route_num_routeid into l_route_number_rec;
561: if get_route_num_routeid%found and l_route_number_rec.route_number=p_x_mr_route_seq_rec.route_number
562: then
563: AHL_DEBUG_PUB.debug( 'Stage 13','+DEBUG+');
564: return;
565: end if;
566: CLOSE get_route_num_routeid;
567:

Line 574: AHL_DEBUG_PUB.debug( 'Error 1','+DEBUG+');

570: FETCH get_route_frm INTO l_route_id;
571: IF get_route_frm%NOTFOUND
572: THEN
573: IF G_DEBUG='Y' THEN
574: AHL_DEBUG_PUB.debug( 'Error 1','+DEBUG+');
575: END IF;
576: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ROUTE_NUMBR_INVALID');
577: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_route_seq_rec.ROUTE_NUMBER ,false);
578: FND_MSG_PUB.ADD;

Line 609: AHL_DEBUG_PUB.enable_debug;

605: end if;
606: ELSIF l_counter=0
607: THEN
608: IF G_DEBUG='Y' THEN
609: AHL_DEBUG_PUB.enable_debug;
610: AHL_DEBUG_PUB.debug( 'Error 2','+DEBUG+');
611: END IF;
612: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ROUTE_NUMBR_INVALID');
613: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_route_seq_rec.ROUTE_NUMBER ,false);

Line 610: AHL_DEBUG_PUB.debug( 'Error 2','+DEBUG+');

606: ELSIF l_counter=0
607: THEN
608: IF G_DEBUG='Y' THEN
609: AHL_DEBUG_PUB.enable_debug;
610: AHL_DEBUG_PUB.debug( 'Error 2','+DEBUG+');
611: END IF;
612: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ROUTE_NUMBR_INVALID');
613: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_route_seq_rec.ROUTE_NUMBER ,false);
614: FND_MSG_PUB.ADD;

Line 622: AHL_DEBUG_PUB.enable_debug;

618: FETCH get_mr_route_id INTO p_x_mr_route_seq_rec.related_mr_route_id;
619: IF get_mr_route_id%rowcount=0
620: THEN
621: IF G_DEBUG='Y' THEN
622: AHL_DEBUG_PUB.enable_debug;
623: AHL_DEBUG_PUB.debug( 'Error 1','+DEBUG+');
624: END IF;
625: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ROUTE_NUMBR_INVALID');
626: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_route_seq_rec.ROUTE_NUMBER);

Line 623: AHL_DEBUG_PUB.debug( 'Error 1','+DEBUG+');

619: IF get_mr_route_id%rowcount=0
620: THEN
621: IF G_DEBUG='Y' THEN
622: AHL_DEBUG_PUB.enable_debug;
623: AHL_DEBUG_PUB.debug( 'Error 1','+DEBUG+');
624: END IF;
625: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ROUTE_NUMBR_INVALID');
626: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_route_seq_rec.ROUTE_NUMBER);
627: FND_MSG_PUB.ADD;

Line 762: AHL_DEBUG_PUB.enable_debug;

758:
759: -- Debug info.
760:
761: IF G_DEBUG='Y' THEN
762: AHL_DEBUG_PUB.enable_debug;
763: AHL_DEBUG_PUB.debug( 'enter PROCESS_MR_ROUTE_SEQ','+ROUTE_SEQ+');
764: END IF;
765:
766:

Line 763: AHL_DEBUG_PUB.debug( 'enter PROCESS_MR_ROUTE_SEQ','+ROUTE_SEQ+');

759: -- Debug info.
760:
761: IF G_DEBUG='Y' THEN
762: AHL_DEBUG_PUB.enable_debug;
763: AHL_DEBUG_PUB.debug( 'enter PROCESS_MR_ROUTE_SEQ','+ROUTE_SEQ+');
764: END IF;
765:
766:
767: -- Initialize API return status to success

Line 876: AHL_DEBUG_PUB.debug( '<---MR ROUTE_ID---> ',TO_CHAR(p_x_mr_route_seq_tbl(i).mr_route_id));

872:
873: x_return_status := FND_API.G_RET_STS_SUCCESS;
874:
875: IF G_DEBUG='Y' THEN
876: AHL_DEBUG_PUB.debug( '<---MR ROUTE_ID---> ',TO_CHAR(p_x_mr_route_seq_tbl(i).mr_route_id));
877: AHL_DEBUG_PUB.debug( '<---RELATED MR ROUTE_ID---> ',TO_CHAR(p_x_mr_route_seq_tbl(i).related_mr_route_id));
878: END IF;
879:
880: l_mr_route_seq_rec:=P_X_MR_ROUTE_SEQ_TBL(I);

Line 877: AHL_DEBUG_PUB.debug( '<---RELATED MR ROUTE_ID---> ',TO_CHAR(p_x_mr_route_seq_tbl(i).related_mr_route_id));

873: x_return_status := FND_API.G_RET_STS_SUCCESS;
874:
875: IF G_DEBUG='Y' THEN
876: AHL_DEBUG_PUB.debug( '<---MR ROUTE_ID---> ',TO_CHAR(p_x_mr_route_seq_tbl(i).mr_route_id));
877: AHL_DEBUG_PUB.debug( '<---RELATED MR ROUTE_ID---> ',TO_CHAR(p_x_mr_route_seq_tbl(i).related_mr_route_id));
878: END IF;
879:
880: l_mr_route_seq_rec:=P_X_MR_ROUTE_SEQ_TBL(I);
881:

Line 886: AHL_DEBUG_PUB.debug( 'Enter Validations level');

882: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )
883: THEN
884:
885: IF G_DEBUG='Y' THEN
886: AHL_DEBUG_PUB.debug( 'Enter Validations level');
887: END IF;
888:
889: VALIDATE_MR_ROUTESEQ
890: (

Line 1028: AHL_DEBUG_PUB.debug( 'End of Private api PROCESS_MR_ROUTE_SEQ','+MR_ROUTE_ID+');

1024: END IF;
1025: -- Debug info
1026:
1027: IF G_DEBUG='Y' THEN
1028: AHL_DEBUG_PUB.debug( 'End of Private api PROCESS_MR_ROUTE_SEQ','+MR_ROUTE_ID+');
1029: END IF;
1030:
1031: -- Check if API is called in debug mode. If yes, disable debug.
1032:

Line 1034: AHL_DEBUG_PUB.disable_debug;

1030:
1031: -- Check if API is called in debug mode. If yes, disable debug.
1032:
1033: IF G_DEBUG='Y' THEN
1034: AHL_DEBUG_PUB.disable_debug;
1035: END IF;
1036:
1037: EXCEPTION
1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN