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

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

1: PACKAGE BODY AHL_PC_ASSOCIATION_PVT AS
2: /* $Header: AHLVPCAB.pls 120.2.12000000.2 2007/08/02 14:23:05 sathapli ship $ */
3:
4: G_DEBUG VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;
5:
6: --------------------------
7: -- SET_PC_HEADER_STATUS --
8: --------------------------

Line 58: AHL_DEBUG_PUB.ENABLE_DEBUG;

54: -- Initialize API return status to success
55: x_return_status := FND_API.G_RET_STS_SUCCESS;
56:
57: IF G_DEBUG='Y' THEN
58: AHL_DEBUG_PUB.ENABLE_DEBUG;
59: END IF;
60:
61: IF (p_x_assos_rec.operation_flag = G_DML_CREATE OR p_x_assos_rec.operation_flag = G_DML_ASSIGN)
62: THEN

Line 148: AHL_DEBUG_PUB.debug('PCA -- PVT -- ATTACH_UNIT for ID='||p_x_assos_rec.PC_ASSOCIATION_ID||' -- unit_id'||p_x_assos_rec.UNIT_ITEM_ID||' -- pc_node_id='||p_x_assos_rec.PC_NODE_ID);

144:
145: p_x_assos_rec.PC_ASSOCIATION_ID := l_assos_id;
146:
147: IF G_DEBUG='Y' THEN
148: AHL_DEBUG_PUB.debug('PCA -- PVT -- ATTACH_UNIT for ID='||p_x_assos_rec.PC_ASSOCIATION_ID||' -- unit_id'||p_x_assos_rec.UNIT_ITEM_ID||' -- pc_node_id='||p_x_assos_rec.PC_NODE_ID);
149: END IF;
150:
151: UPDATE ahl_pc_nodes_b
152: SET child_count = NVL(child_count, 0) + 1

Line 253: AHL_DEBUG_PUB.ENABLE_DEBUG;

249: -- Initialize API return status to success
250: x_return_status := FND_API.G_RET_STS_SUCCESS;
251:
252: IF G_DEBUG='Y' THEN
253: AHL_DEBUG_PUB.ENABLE_DEBUG;
254: END IF;
255:
256: VALIDATE_ASSOCIATION (p_x_assos_rec);
257:

Line 296: AHL_DEBUG_PUB.debug('PCA -- PVT -- DETACH_UNIT for ID='||p_x_assos_rec.PC_ASSOCIATION_ID);

292: DELETE FROM AHL_PC_ASSOCIATIONS
293: WHERE PC_ASSOCIATION_ID = p_x_assos_rec.PC_ASSOCIATION_ID;
294:
295: IF G_DEBUG='Y' THEN
296: AHL_DEBUG_PUB.debug('PCA -- PVT -- DETACH_UNIT for ID='||p_x_assos_rec.PC_ASSOCIATION_ID);
297: END IF;
298:
299: UPDATE ahl_pc_nodes_b
300: SET child_count = NVL(child_count, 1) - 1

Line 398: AHL_DEBUG_PUB.ENABLE_DEBUG;

394: -- Initialize API return status to success
395: x_return_status := FND_API.G_RET_STS_SUCCESS;
396:
397: IF G_DEBUG='Y' THEN
398: AHL_DEBUG_PUB.ENABLE_DEBUG;
399: END IF;
400:
401: IF (p_x_assos_rec.operation_flag = G_DML_CREATE OR p_x_assos_rec.operation_flag = G_DML_ASSIGN)
402: THEN

Line 489: AHL_DEBUG_PUB.debug('PCA -- PVT -- ATTACH_PART for ID='||p_x_assos_rec.PC_ASSOCIATION_ID||' -- part_id'||p_x_assos_rec.UNIT_ITEM_ID||' -- pc_node_id='||p_x_assos_rec.PC_NODE_ID);

485:
486: p_x_assos_rec.PC_ASSOCIATION_ID := l_assos_id;
487:
488: IF G_DEBUG='Y' THEN
489: AHL_DEBUG_PUB.debug('PCA -- PVT -- ATTACH_PART for ID='||p_x_assos_rec.PC_ASSOCIATION_ID||' -- part_id'||p_x_assos_rec.UNIT_ITEM_ID||' -- pc_node_id='||p_x_assos_rec.PC_NODE_ID);
490: END IF;
491:
492: UPDATE ahl_pc_nodes_b
493: SET child_count = NVL(child_count, 0) + 1

Line 594: AHL_DEBUG_PUB.ENABLE_DEBUG;

590: -- Initialize API return status to success
591: x_return_status := FND_API.G_RET_STS_SUCCESS;
592:
593: IF G_DEBUG='Y' THEN
594: AHL_DEBUG_PUB.ENABLE_DEBUG;
595: END IF;
596:
597: VALIDATE_ASSOCIATION (p_x_assos_rec);
598:

Line 642: AHL_DEBUG_PUB.debug('PCA -- PVT -- DETACH_PART for ID='||p_x_assos_rec.PC_ASSOCIATION_ID);

638: DELETE FROM AHL_PC_ASSOCIATIONS
639: WHERE PC_ASSOCIATION_ID = p_x_assos_rec.PC_ASSOCIATION_ID;
640:
641: IF G_DEBUG='Y' THEN
642: AHL_DEBUG_PUB.debug('PCA -- PVT -- DETACH_PART for ID='||p_x_assos_rec.PC_ASSOCIATION_ID);
643: END IF;
644:
645: UPDATE ahl_pc_nodes_b
646: SET child_count = NVL(child_count, 1) - 1

Line 766: AHL_DEBUG_PUB.ENABLE_DEBUG;

762: -- Initialize API return status to success
763: x_return_status := FND_API.G_RET_STS_SUCCESS;
764:
765: IF G_DEBUG='Y' THEN
766: AHL_DEBUG_PUB.ENABLE_DEBUG;
767: END IF;
768:
769: -- API BODY here...
770: IF (p_x_assos_tbl.COUNT > 0)

Line 775: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Association ID=' || p_x_assos_tbl(i).DOC_TITLE_ASSO_ID);

771: THEN
772: FOR i in p_x_assos_tbl.FIRST..p_x_assos_tbl.LAST
773: LOOP
774: IF G_DEBUG='Y' THEN
775: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Association ID=' || p_x_assos_tbl(i).DOC_TITLE_ASSO_ID);
776: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Node ID=' || p_x_assos_tbl(i).ASO_OBJECT_ID);
777: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Document No=' || p_x_assos_tbl(i).DOCUMENT_NO);
778: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Revision No='||p_x_assos_tbl(i).REVISION_NO);
779: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Object Type='||p_x_assos_tbl(i).ASO_OBJECT_TYPE_CODE);

Line 776: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Node ID=' || p_x_assos_tbl(i).ASO_OBJECT_ID);

772: FOR i in p_x_assos_tbl.FIRST..p_x_assos_tbl.LAST
773: LOOP
774: IF G_DEBUG='Y' THEN
775: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Association ID=' || p_x_assos_tbl(i).DOC_TITLE_ASSO_ID);
776: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Node ID=' || p_x_assos_tbl(i).ASO_OBJECT_ID);
777: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Document No=' || p_x_assos_tbl(i).DOCUMENT_NO);
778: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Revision No='||p_x_assos_tbl(i).REVISION_NO);
779: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Object Type='||p_x_assos_tbl(i).ASO_OBJECT_TYPE_CODE);
780: END IF;

Line 777: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Document No=' || p_x_assos_tbl(i).DOCUMENT_NO);

773: LOOP
774: IF G_DEBUG='Y' THEN
775: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Association ID=' || p_x_assos_tbl(i).DOC_TITLE_ASSO_ID);
776: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Node ID=' || p_x_assos_tbl(i).ASO_OBJECT_ID);
777: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Document No=' || p_x_assos_tbl(i).DOCUMENT_NO);
778: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Revision No='||p_x_assos_tbl(i).REVISION_NO);
779: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Object Type='||p_x_assos_tbl(i).ASO_OBJECT_TYPE_CODE);
780: END IF;
781:

Line 778: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Revision No='||p_x_assos_tbl(i).REVISION_NO);

774: IF G_DEBUG='Y' THEN
775: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Association ID=' || p_x_assos_tbl(i).DOC_TITLE_ASSO_ID);
776: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Node ID=' || p_x_assos_tbl(i).ASO_OBJECT_ID);
777: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Document No=' || p_x_assos_tbl(i).DOCUMENT_NO);
778: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Revision No='||p_x_assos_tbl(i).REVISION_NO);
779: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Object Type='||p_x_assos_tbl(i).ASO_OBJECT_TYPE_CODE);
780: END IF;
781:
782: -- Hardcode object type to PC

Line 779: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Object Type='||p_x_assos_tbl(i).ASO_OBJECT_TYPE_CODE);

775: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Association ID=' || p_x_assos_tbl(i).DOC_TITLE_ASSO_ID);
776: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Node ID=' || p_x_assos_tbl(i).ASO_OBJECT_ID);
777: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Document No=' || p_x_assos_tbl(i).DOCUMENT_NO);
778: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Revision No='||p_x_assos_tbl(i).REVISION_NO);
779: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Object Type='||p_x_assos_tbl(i).ASO_OBJECT_TYPE_CODE);
780: END IF;
781:
782: -- Hardcode object type to PC
783:

Line 800: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Status='||l_status);

796: OPEN get_pc_header_status (p_x_assos_tbl(i).ASO_OBJECT_ID);
797: FETCH get_pc_header_status INTO l_status;
798: CLOSE get_pc_header_status;
799: IF G_DEBUG='Y' THEN
800: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT for Status='||l_status);
801: END IF;
802:
803: -- If PC is pending for approval, throw error
804: IF (l_status = 'APPROVAL_PENDING')

Line 848: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT Calling AHL_DI_ASSO_DOC_GEN_PUB.PROCESS_ASSOCIATION');

844: END LOOP;
845: END IF;
846:
847: IF G_DEBUG='Y' THEN
848: AHL_DEBUG_PUB.debug('PCA -- PVT -- PROCESS_DOCUMENT Calling AHL_DI_ASSO_DOC_GEN_PUB.PROCESS_ASSOCIATION');
849: END IF;
850:
851: AHL_DI_ASSO_DOC_GEN_PUB.PROCESS_ASSOCIATION
852: (