APPS.AHL_FMP_MR_RELATION_PVT dependencies on AHL_DEBUG_PUB

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

3: G_PKG_NAME VARCHAR2(50):= 'AHL_FMP_MR_RELATION_PVT';
4: G_PM_INSTALL VARCHAR2(30):=ahl_util_pkg.is_pm_installed;
5:
6: --G_DEBUG VARCHAR2(1):=FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');
7: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
8:
9: -- pdoki added for SBE Project
10: PROCEDURE CHECK_LOOKUP_CODE
11: (

Line 193: AHL_DEBUG_PUB.enable_debug;

189: BEGIN
190: x_return_status:=FND_API.G_RET_STS_SUCCESS;
191:
192: IF G_DEBUG='Y' THEN
193: AHL_DEBUG_PUB.enable_debug;
194: AHL_DEBUG_PUB.debug( 'p_x_mr_relation_rec.related_mr_header_id'||p_x_mr_relation_rec.related_mr_header_id,'+DEBUG_RELATIONS+');
195: END IF;
196:
197: IF p_x_mr_relation_rec.MR_HEADER_ID IS NOT NULL OR p_x_mr_relation_rec.MR_HEADER_ID<>FND_API.G_MISS_NUM

Line 194: AHL_DEBUG_PUB.debug( 'p_x_mr_relation_rec.related_mr_header_id'||p_x_mr_relation_rec.related_mr_header_id,'+DEBUG_RELATIONS+');

190: x_return_status:=FND_API.G_RET_STS_SUCCESS;
191:
192: IF G_DEBUG='Y' THEN
193: AHL_DEBUG_PUB.enable_debug;
194: AHL_DEBUG_PUB.debug( 'p_x_mr_relation_rec.related_mr_header_id'||p_x_mr_relation_rec.related_mr_header_id,'+DEBUG_RELATIONS+');
195: END IF;
196:
197: IF p_x_mr_relation_rec.MR_HEADER_ID IS NOT NULL OR p_x_mr_relation_rec.MR_HEADER_ID<>FND_API.G_MISS_NUM
198: THEN

Line 245: AHL_DEBUG_PUB.debug( 'p_x_mr_relation_rec.related_mr_header_id::'||p_x_mr_relation_rec.related_mr_header_id);

241: END IF;
242: CLOSE title_to_relmr_header_id;
243: END IF;
244: END IF;
245: AHL_DEBUG_PUB.debug( 'p_x_mr_relation_rec.related_mr_header_id::'||p_x_mr_relation_rec.related_mr_header_id);
246:
247: END;
248:
249: PROCEDURE NON_CYCLIC_ENF

Line 413: AHL_DEBUG_PUB.enable_debug;

409: l_return_status VARCHAR2(1);
410: BEGIN
411: x_return_status:=FND_API.G_RET_STS_SUCCESS;
412: IF G_DEBUG='Y' THEN
413: AHL_DEBUG_PUB.enable_debug;
414: END IF;
415: IF p_mr_relation_rec.MR_HEADER_ID IS NULL or
416: p_mr_relation_rec.MR_HEADER_ID=FND_API.G_MISS_NUM
417: THEN

Line 429: AHL_DEBUG_PUB.debug( 'mr_Status_code'||l_head_rec.mr_status_code,'+DEBUG_RELATIONS+');

425: IF l_head_rec.mr_status_code='DRAFT' OR
426: l_head_rec.mr_status_code='APPROVAL_REJECTED'
427: THEN
428: IF G_DEBUG='Y' THEN
429: AHL_DEBUG_PUB.debug( 'mr_Status_code'||l_head_rec.mr_status_code,'+DEBUG_RELATIONS+');
430: END IF;
431: l_mr_check_flag:='Y';
432: ELSE
433: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INVALID_MR_STATUS');

Line 436: AHL_DEBUG_PUB.debug( 'mr_Status_code'||l_head_rec.mr_status_code,'+DEBUG_RELATIONS+');

432: ELSE
433: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INVALID_MR_STATUS');
434: FND_MSG_PUB.ADD;
435: IF G_DEBUG='Y' THEN
436: AHL_DEBUG_PUB.debug( 'mr_Status_code'||l_head_rec.mr_status_code,'+DEBUG_RELATIONS+');
437: END IF;
438: l_mr_check_flag:='N';
439: END IF;
440:

Line 601: AHL_DEBUG_PUB.debug( 'Check Uniq Record');

597: p_mr_relation_rec.relationship_code ='TERMINATEDBY' THEN
598:
599:
600: IF G_DEBUG='Y' THEN
601: AHL_DEBUG_PUB.debug( 'Check Uniq Record');
602: END IF;
603:
604: IF p_mr_relation_rec.relationship_code='CHILD' THEN
605: OPEN check_uniq(p_mr_relation_rec.mr_header_id,p_mr_relation_rec.related_mr_header_id,'PARENT');

Line 876: AHL_DEBUG_PUB.enable_debug;

872:
873: x_return_status:=FND_API.G_RET_STS_SUCCESS;
874:
875: IF G_DEBUG='Y' THEN
876: AHL_DEBUG_PUB.enable_debug;
877: END IF;
878: /*
879: IF FND_API.to_boolean(p_default)
880: THEN

Line 1163: AHL_DEBUG_PUB.disable_debug;

1159: COMMIT;
1160: END IF;
1161:
1162: IF G_DEBUG='Y' THEN
1163: AHL_DEBUG_PUB.disable_debug;
1164: END IF;
1165:
1166: EXCEPTION
1167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1184: AHL_DEBUG_PUB.debug( 'PROCESS-->'||sqlerrm,'DEBUG RELATIONS');

1180: WHEN OTHERS THEN
1181: ROLLBACK TO PROCESS_MR_RELATION;
1182: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1183: IF G_DEBUG='Y' THEN
1184: AHL_DEBUG_PUB.debug( 'PROCESS-->'||sqlerrm,'DEBUG RELATIONS');
1185: END IF;
1186: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1187: THEN
1188: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME,