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: PROCEDURE DEFAULT_MISSING_ATTRIBS
10: (p_x_mr_relation_tbl IN OUT NOCOPY AHL_FMP_MR_relation_PVT.MR_relation_TBL)
11: AS

Line 165: AHL_DEBUG_PUB.enable_debug;

161: BEGIN
162: x_return_status:=FND_API.G_RET_STS_SUCCESS;
163:
164: IF G_DEBUG='Y' THEN
165: AHL_DEBUG_PUB.enable_debug;
166: AHL_DEBUG_PUB.debug( 'p_x_mr_relation_rec.related_mr_header_id'||p_x_mr_relation_rec.related_mr_header_id,'+DEBUG_RELATIONS+');
167: END IF;
168:
169: 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 166: AHL_DEBUG_PUB.debug( 'p_x_mr_relation_rec.related_mr_header_id'||p_x_mr_relation_rec.related_mr_header_id,'+DEBUG_RELATIONS+');

162: x_return_status:=FND_API.G_RET_STS_SUCCESS;
163:
164: IF G_DEBUG='Y' THEN
165: AHL_DEBUG_PUB.enable_debug;
166: AHL_DEBUG_PUB.debug( 'p_x_mr_relation_rec.related_mr_header_id'||p_x_mr_relation_rec.related_mr_header_id,'+DEBUG_RELATIONS+');
167: END IF;
168:
169: 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
170: THEN

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

213: END IF;
214: CLOSE title_to_relmr_header_id;
215: END IF;
216: END IF;
217: AHL_DEBUG_PUB.debug( 'p_x_mr_relation_rec.related_mr_header_id'||p_x_mr_relation_rec.related_mr_header_id,'+DEBUG_RELATIONS+');
218:
219: END;
220:
221: PROCEDURE NON_CYCLIC_ENF

Line 320: AHL_DEBUG_PUB.enable_debug;

316: l_mr_check_flag VARCHAR2(1):='N';
317: BEGIN
318: x_return_status:=FND_API.G_RET_STS_SUCCESS;
319: IF G_DEBUG='Y' THEN
320: AHL_DEBUG_PUB.enable_debug;
321: END IF;
322: IF p_mr_relation_rec.MR_HEADER_ID IS NULL or
323: p_mr_relation_rec.MR_HEADER_ID=FND_API.G_MISS_NUM
324: THEN

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

332: IF l_head_rec.mr_status_code='DRAFT' OR
333: l_head_rec.mr_status_code='APPROVAL_REJECTED'
334: THEN
335: IF G_DEBUG='Y' THEN
336: AHL_DEBUG_PUB.debug( 'mr_Status_code'||l_head_rec.mr_status_code,'+DEBUG_RELATIONS+');
337: END IF;
338: l_mr_check_flag:='Y';
339: ELSE
340: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INVALID_MR_STATUS');

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

339: ELSE
340: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INVALID_MR_STATUS');
341: FND_MSG_PUB.ADD;
342: IF G_DEBUG='Y' THEN
343: AHL_DEBUG_PUB.debug( 'mr_Status_code'||l_head_rec.mr_status_code,'+DEBUG_RELATIONS+');
344: END IF;
345: l_mr_check_flag:='N';
346: END IF;
347:

Line 434: AHL_DEBUG_PUB.debug( 'Check Uniq Record','+DEBUG_RELATIONS+');

430:
431: IF p_mr_relation_rec.dml_operation<>'D'
432: THEN
433: IF G_DEBUG='Y' THEN
434: AHL_DEBUG_PUB.debug( 'Check Uniq Record','+DEBUG_RELATIONS+');
435: END IF;
436: IF p_mr_relation_rec.relationship_code='CHILD'
437: THEN
438: OPEN check_uniq(p_mr_relation_rec.mr_header_id,p_mr_relation_rec.related_mr_header_id,'PARENT');

Line 519: AHL_DEBUG_PUB.enable_debug;

515:
516: x_return_status:=FND_API.G_RET_STS_SUCCESS;
517:
518: IF G_DEBUG='Y' THEN
519: AHL_DEBUG_PUB.enable_debug;
520: END IF;
521: /*
522: IF FND_API.to_boolean(p_default)
523: THEN

Line 780: AHL_DEBUG_PUB.disable_debug;

776: COMMIT;
777: END IF;
778:
779: IF G_DEBUG='Y' THEN
780: AHL_DEBUG_PUB.disable_debug;
781: END IF;
782:
783: EXCEPTION
784: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

797: WHEN OTHERS THEN
798: ROLLBACK TO PROCESS_MR_RELATION;
799: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
800: IF G_DEBUG='Y' THEN
801: AHL_DEBUG_PUB.debug( 'PROCESS-->'||sqlerrm,'DEBUG RELATIONS');
802: END IF;
803: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
804: THEN
805: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME,