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

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

1: PACKAGE BODY AHL_PC_HEADER_PVT AS
2: /* $Header: AHLVPCHB.pls 120.11.12020000.2 2012/12/07 01:39:56 sareepar ship $ */
3:
4: G_DEBUG VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;
5:
6: -----------------------------
7: -- GET_DUP_UNIT_ITEM_ASSOS --
8: -----------------------------

Line 142: AHL_DEBUG_PUB.ENABLE_DEBUG;

138:
139: x_return_status := FND_API.G_RET_STS_SUCCESS;
140:
141: IF G_DEBUG='Y' THEN
142: AHL_DEBUG_PUB.ENABLE_DEBUG;
143: END IF;
144:
145: IF p_x_pc_header_rec.OPERATION_FLAG = AHL_PC_HEADER_PVT.G_DML_CREATE
146: THEN

Line 208: AHL_DEBUG_PUB.debug('PCH -- PVT -- Created Header for ID='||p_x_pc_header_rec.PC_HEADER_ID);

204:
205: p_x_pc_header_rec.PC_HEADER_ID := l_header_id;
206:
207: IF G_DEBUG='Y' THEN
208: AHL_DEBUG_PUB.debug('PCH -- PVT -- Created Header for ID='||p_x_pc_header_rec.PC_HEADER_ID);
209: END IF;
210:
211: -- Check Error Message stack.
212: x_msg_count := FND_MSG_PUB.count_msg;

Line 312: AHL_DEBUG_PUB.ENABLE_DEBUG;

308:
309: x_return_status := FND_API.G_RET_STS_SUCCESS;
310:
311: IF G_DEBUG='Y' THEN
312: AHL_DEBUG_PUB.ENABLE_DEBUG;
313: END IF;
314:
315: -- If the to be PC was not primary and now changed to primary, and if it has duplicate...
316: -- unit/part associations, then abort Update...

Line 336: AHL_DEBUG_PUB.debug('PCH -- PVT -- UPDATE_PC_HEADER -- Can update PC, No duplicate unit/part associations');

332: END IF;
333: END IF;
334: END IF;
335: IF G_DEBUG='Y' THEN
336: AHL_DEBUG_PUB.debug('PCH -- PVT -- UPDATE_PC_HEADER -- Can update PC, No duplicate unit/part associations');
337: END IF;
338:
339: SELECT LINK_TO_PC_ID
340: INTO p_x_pc_header_rec.LINK_TO_PC_ID

Line 362: AHL_DEBUG_PUB.debug('PCH -- PVT -- UPDATE_PC_HEADER -- Operation Flag after VALIDATE_PC_HEADER_UPDATE = '||p_x_pc_header_rec.OPERATION_FLAG);

358: x_warning_msg_data => x_warning_msg_data
359: );
360:
361: IF G_DEBUG='Y' THEN
362: AHL_DEBUG_PUB.debug('PCH -- PVT -- UPDATE_PC_HEADER -- Operation Flag after VALIDATE_PC_HEADER_UPDATE = '||p_x_pc_header_rec.OPERATION_FLAG);
363: END IF;
364:
365: IF p_x_pc_header_rec.OPERATION_FLAG = AHL_PC_HEADER_PVT.G_DML_LINK
366: THEN

Line 433: AHL_DEBUG_PUB.debug('PCH -- PVT -- UPDATE_PC_HEADER -- After DB Update');

429: X_LAST_UPDATE_LOGIN => G_USER_ID
430: );
431:
432: IF G_DEBUG='Y' THEN
433: AHL_DEBUG_PUB.debug('PCH -- PVT -- UPDATE_PC_HEADER -- After DB Update');
434: END IF;
435:
436: -- Check Error Message stack.
437: x_msg_count := FND_MSG_PUB.count_msg;

Line 552: AHL_DEBUG_PUB.ENABLE_DEBUG;

548:
549: x_return_status := FND_API.G_RET_STS_SUCCESS;
550:
551: IF G_DEBUG='Y' THEN
552: AHL_DEBUG_PUB.ENABLE_DEBUG;
553: END IF;
554:
555: OPEN check_header_status(p_x_pc_header_rec.PC_HEADER_ID);
556: FETCH check_header_status INTO l_status;

Line 577: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_HEADER -- Retrieving linked PC ID='||l_link_to_header_id);

573: OPEN delete_linked_header(p_x_pc_header_rec.PC_HEADER_ID);
574: FETCH delete_linked_header INTO l_link_to_header_id;
575: CLOSE delete_linked_header;
576: IF G_DEBUG='Y' THEN
577: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_HEADER -- Retrieving linked PC ID='||l_link_to_header_id);
578: END IF;
579:
580: OPEN delete_node(p_x_pc_header_rec.PC_HEADER_ID);
581: FETCH delete_node INTO l_node_id;

Line 586: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_HEADER -- Deleting Node Tree from ID='||l_node_rec.PC_NODE_ID);

582: IF(delete_node%FOUND)
583: THEN
584: l_node_rec.PC_HEADER_ID := p_x_pc_header_rec.PC_HEADER_ID;
585: IF G_DEBUG='Y' THEN
586: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_HEADER -- Deleting Node Tree from ID='||l_node_rec.PC_NODE_ID);
587: END IF;
588: AHL_PC_NODE_PVT.DELETE_NODES
589: (
590: p_api_version => p_api_version,

Line 615: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_HEADER -- Deleting PC with ID='||p_x_pc_header_rec.PC_HEADER_ID);

611: END IF;
612:
613:
614: IF G_DEBUG='Y' THEN
615: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_HEADER -- Deleting PC with ID='||p_x_pc_header_rec.PC_HEADER_ID);
616: END IF;
617: AHL_PC_HEADERS_PKG.DELETE_ROW (p_x_pc_header_rec.PC_HEADER_ID);
618:
619: IF G_DEBUG='Y' THEN

Line 620: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_HEADER -- Changing DRAFT_FLAG=Y for linked-to PC with ID='||l_link_to_header_id);

616: END IF;
617: AHL_PC_HEADERS_PKG.DELETE_ROW (p_x_pc_header_rec.PC_HEADER_ID);
618:
619: IF G_DEBUG='Y' THEN
620: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_HEADER -- Changing DRAFT_FLAG=Y for linked-to PC with ID='||l_link_to_header_id);
621: END IF;
622:
623: IF (l_link_to_header_id <> 0)
624: THEN

Line 626: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_HEADER -- Done for Header ID='||l_link_to_header_id);

622:
623: IF (l_link_to_header_id <> 0)
624: THEN
625: IF G_DEBUG='Y' THEN
626: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_HEADER -- Done for Header ID='||l_link_to_header_id);
627: END IF;
628: UPDATE AHL_PC_HEADERS_B
629: SET DRAFT_FLAG='N'
630: WHERE PC_HEADER_ID = l_link_to_header_id;

Line 662: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_HEADER -- Done for Node ID='||l_node_tbl(i));

658: THEN
659: FOR i IN l_node_tbl.FIRST..l_node_tbl.LAST
660: LOOP
661: IF G_DEBUG='Y' THEN
662: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_HEADER -- Done for Node ID='||l_node_tbl(i));
663: END IF;
664: UPDATE AHL_PC_NODES_B
665: SET DRAFT_FLAG = 'N'
666: WHERE PC_NODE_ID = l_node_tbl(i);

Line 675: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_HEADER -- Done for Association ID='||l_assos_tbl(j));

671: THEN
672: FOR j IN l_assos_tbl.FIRST..l_assos_tbl.LAST
673: LOOP
674: IF G_DEBUG='Y' THEN
675: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_HEADER -- Done for Association ID='||l_assos_tbl(j));
676: END IF;
677: UPDATE AHL_PC_ASSOCIATIONS
678: SET DRAFT_FLAG = 'N'
679: WHERE PC_ASSOCIATION_ID = l_assos_tbl(j);

Line 688: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_HEADER -- After DB Delete');

684: END IF;
685: END IF;
686:
687: IF G_DEBUG='Y' THEN
688: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_HEADER -- After DB Delete');
689: END IF;
690:
691: -- Check Error Message stack.
692: x_msg_count := FND_MSG_PUB.count_msg;

Line 940: AHL_DEBUG_PUB.ENABLE_DEBUG;

936:
937: x_return_status := FND_API.G_RET_STS_SUCCESS;
938:
939: IF G_DEBUG='Y' THEN
940: AHL_DEBUG_PUB.ENABLE_DEBUG;
941: END IF;
942:
943: l_old_header_id := p_x_pc_header_rec.PC_HEADER_ID;
944: p_x_pc_header_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_CREATE;

Line 999: AHL_DEBUG_PUB.debug('PCH -- PVT -- COPY_PC_HEADER -- Copied into new PC with ID='||p_x_pc_header_rec.PC_HEADER_ID);

995: x_msg_count => x_msg_count,
996: x_msg_data => x_msg_data
997: );
998: IF G_DEBUG='Y' THEN
999: AHL_DEBUG_PUB.debug('PCH -- PVT -- COPY_PC_HEADER -- Copied into new PC with ID='||p_x_pc_header_rec.PC_HEADER_ID);
1000: END IF;
1001:
1002: x_msg_count := FND_MSG_PUB.count_msg;
1003: IF x_msg_count > 0

Line 1018: AHL_DEBUG_PUB.debug('PCH -- PVT -- COPY_PC_HEADER -- Creating node record for ID='||l_node_data_rec.PC_NODE_ID);

1014:
1015: IF l_node_data_rec.node_type = G_NODE
1016: THEN
1017: IF G_DEBUG='Y' THEN
1018: AHL_DEBUG_PUB.debug('PCH -- PVT -- COPY_PC_HEADER -- Creating node record for ID='||l_node_data_rec.PC_NODE_ID);
1019: END IF;
1020: l_node_rec.PC_HEADER_ID := p_x_pc_header_rec.PC_HEADER_ID;
1021: l_node_rec.PC_NODE_ID := l_node_data_rec.PC_NODE_ID;
1022: l_node_rec.PARENT_NODE_ID := l_node_data_rec.PARENT_NODE_ID;

Line 1069: AHL_DEBUG_PUB.debug('PCH -- PVT -- COPY_PC_HEADER -- Before AHL_PC_NODE_PVT.CREATE_NODE l_node_rec.PC_NODE_ID ='||l_node_rec.PC_NODE_ID);

1065:
1066: IF l_node_data_rec.node_type = G_NODE
1067: THEN
1068: IF G_DEBUG='Y' THEN
1069: AHL_DEBUG_PUB.debug('PCH -- PVT -- COPY_PC_HEADER -- Before AHL_PC_NODE_PVT.CREATE_NODE l_node_rec.PC_NODE_ID ='||l_node_rec.PC_NODE_ID);
1070: END IF;
1071:
1072: AHL_PC_NODE_PVT.CREATE_NODE
1073: (

Line 1085: AHL_DEBUG_PUB.debug('PCH -- PVT -- COPY_PC_HEADER -- After AHL_PC_NODE_PVT.CREATE_NODE l_node_rec.PC_NODE_ID ='||l_node_rec.PC_NODE_ID);

1081: x_msg_data => x_msg_data
1082: );
1083:
1084: IF G_DEBUG='Y' THEN
1085: AHL_DEBUG_PUB.debug('PCH -- PVT -- COPY_PC_HEADER -- After AHL_PC_NODE_PVT.CREATE_NODE l_node_rec.PC_NODE_ID ='||l_node_rec.PC_NODE_ID);
1086: END IF;
1087:
1088: l_nodeId_tbl(l_nodeCtr).NODE_ID := l_node_data_rec.PC_NODE_ID;
1089: l_nodeId_tbl(l_nodeCtr).NEW_NODE_ID := l_node_rec.PC_NODE_ID;

Line 1093: AHL_DEBUG_PUB.debug('PCH -- PVT -- COPY_PC_HEADER -- After AHL_PC_NODE_PVT.CREATE_NODE l_nodeCtr ='||l_nodeCtr);

1089: l_nodeId_tbl(l_nodeCtr).NEW_NODE_ID := l_node_rec.PC_NODE_ID;
1090: l_nodeCtr := l_nodeCtr + 1;
1091:
1092: IF G_DEBUG='Y' THEN
1093: AHL_DEBUG_PUB.debug('PCH -- PVT -- COPY_PC_HEADER -- After AHL_PC_NODE_PVT.CREATE_NODE l_nodeCtr ='||l_nodeCtr);
1094: END IF;
1095:
1096: END IF;
1097:

Line 1106: AHL_DEBUG_PUB.debug('PCH -- PVT -- COPY_PC_HEADER -- Creating doc record for ID='||l_assos_data_rec.DOCUMENT_ID);

1102: LOOP
1103: FETCH copy_document INTO l_assos_data_rec;
1104: EXIT WHEN copy_document%NOTFOUND;
1105: IF G_DEBUG='Y' THEN
1106: AHL_DEBUG_PUB.debug('PCH -- PVT -- COPY_PC_HEADER -- Creating doc record for ID='||l_assos_data_rec.DOCUMENT_ID);
1107: END IF;
1108: l_assos_doc_tbl(l_assosCtr).DOC_TITLE_ASSO_ID := null;
1109: l_assos_doc_tbl(l_assosCtr).DOCUMENT_ID := l_assos_data_rec.DOCUMENT_ID ;
1110: l_assos_doc_tbl(l_assosCtr).DOC_REVISION_ID := l_assos_data_rec.DOC_REVISION_ID ;

Line 1171: AHL_DEBUG_PUB.debug('PCH -- PVT -- COPY_PC_HEADER -- Creating unit/part record for ID='||l_node_units_data_rec.PC_NODE_ID);

1167:
1168: IF p_x_pc_header_rec.COPY_ASSOS_FLAG = 'Y' AND l_node_units_data_rec.node_type IN (G_PART, G_UNIT)
1169: THEN
1170: IF G_DEBUG='Y' THEN
1171: AHL_DEBUG_PUB.debug('PCH -- PVT -- COPY_PC_HEADER -- Creating unit/part record for ID='||l_node_units_data_rec.PC_NODE_ID);
1172: END IF;
1173: l_assos_rec.UNIT_ITEM_ID := l_node_units_data_rec.UNIT_ITEM_ID;
1174: l_assos_rec.INVENTORY_ORG_ID := l_node_units_data_rec.INVENTORY_ORG_ID;
1175: l_assos_rec.ASSOCIATION_TYPE_FLAG := l_node_units_data_rec.node_type;

Line 1215: AHL_DEBUG_PUB.debug('PCH -- PVT -- COPY_PC_HEADER -- Before AHL_PC_ASSOCIATION_PVT.ATTACH_UNIT: l_assos_rec.PC_NODE_ID ='||l_assos_rec.PC_NODE_ID);

1211:
1212: IF p_x_pc_header_rec.COPY_ASSOS_FLAG = 'Y' AND l_node_units_data_rec.node_type ='U'
1213: THEN
1214: IF G_DEBUG='Y' THEN
1215: AHL_DEBUG_PUB.debug('PCH -- PVT -- COPY_PC_HEADER -- Before AHL_PC_ASSOCIATION_PVT.ATTACH_UNIT: l_assos_rec.PC_NODE_ID ='||l_assos_rec.PC_NODE_ID);
1216: END IF;
1217:
1218: AHL_PC_ASSOCIATION_PVT.ATTACH_UNIT
1219: (

Line 1231: AHL_DEBUG_PUB.debug('PCH -- PVT -- COPY_PC_HEADER -- After AHL_PC_ASSOCIATION_PVT.ATTACH_UNIT: l_assos_rec.PC_NODE_ID ='||l_assos_rec.PC_NODE_ID);

1227: x_msg_data => x_msg_data
1228: );
1229:
1230: IF G_DEBUG='Y' THEN
1231: AHL_DEBUG_PUB.debug('PCH -- PVT -- COPY_PC_HEADER -- After AHL_PC_ASSOCIATION_PVT.ATTACH_UNIT: l_assos_rec.PC_NODE_ID ='||l_assos_rec.PC_NODE_ID);
1232: END IF;
1233:
1234: ELSIF p_x_pc_header_rec.COPY_ASSOS_FLAG = 'Y' AND l_node_units_data_rec.node_type ='I'
1235: THEN

Line 1252: AHL_DEBUG_PUB.debug('PCH -- PVT -- COPY_PC_HEADER -- After Copy PC');

1248:
1249: END LOOP;
1250:
1251: IF G_DEBUG='Y' THEN
1252: AHL_DEBUG_PUB.debug('PCH -- PVT -- COPY_PC_HEADER -- After Copy PC');
1253: END IF;
1254:
1255: -- Check Error Message stack.
1256: x_msg_count := FND_MSG_PUB.count_msg;

Line 1354: AHL_DEBUG_PUB.ENABLE_DEBUG;

1350:
1351: x_return_status := FND_API.G_RET_STS_SUCCESS;
1352:
1353: IF G_DEBUG='Y' THEN
1354: AHL_DEBUG_PUB.ENABLE_DEBUG;
1355: --END IF;
1356: --IF G_DEBUG='Y' THEN
1357: AHL_DEBUG_PUB.debug('PCH -- PVT -- Starting to call INITIATE_PC_APPROVAL');
1358: END IF;

Line 1357: AHL_DEBUG_PUB.debug('PCH -- PVT -- Starting to call INITIATE_PC_APPROVAL');

1353: IF G_DEBUG='Y' THEN
1354: AHL_DEBUG_PUB.ENABLE_DEBUG;
1355: --END IF;
1356: --IF G_DEBUG='Y' THEN
1357: AHL_DEBUG_PUB.debug('PCH -- PVT -- Starting to call INITIATE_PC_APPROVAL');
1358: END IF;
1359:
1360: -- Retrieve the workflow process name for object PCWF
1361: ahl_utility_pvt.get_wf_process_name

Line 1372: AHL_DEBUG_PUB.debug('PCH -- PVT -- get_wf_process_name returns l_object='||l_object);

1368: x_msg_count =>l_msg_count,
1369: x_msg_data =>l_msg_data
1370: );
1371: IF G_DEBUG='Y' THEN
1372: AHL_DEBUG_PUB.debug('PCH -- PVT -- get_wf_process_name returns l_object='||l_object);
1373: --END IF;
1374: --IF G_DEBUG='Y' THEN
1375: AHL_DEBUG_PUB.debug('PCH -- PVT -- get_wf_process_name returns l_active='||l_active);
1376: --END IF;

Line 1375: AHL_DEBUG_PUB.debug('PCH -- PVT -- get_wf_process_name returns l_active='||l_active);

1371: IF G_DEBUG='Y' THEN
1372: AHL_DEBUG_PUB.debug('PCH -- PVT -- get_wf_process_name returns l_object='||l_object);
1373: --END IF;
1374: --IF G_DEBUG='Y' THEN
1375: AHL_DEBUG_PUB.debug('PCH -- PVT -- get_wf_process_name returns l_active='||l_active);
1376: --END IF;
1377: --IF G_DEBUG='Y' THEN
1378: AHL_DEBUG_PUB.debug('PCH -- PVT -- get_wf_process_name returns l_process_name='||l_process_name);
1379: --END IF;

Line 1378: AHL_DEBUG_PUB.debug('PCH -- PVT -- get_wf_process_name returns l_process_name='||l_process_name);

1374: --IF G_DEBUG='Y' THEN
1375: AHL_DEBUG_PUB.debug('PCH -- PVT -- get_wf_process_name returns l_active='||l_active);
1376: --END IF;
1377: --IF G_DEBUG='Y' THEN
1378: AHL_DEBUG_PUB.debug('PCH -- PVT -- get_wf_process_name returns l_process_name='||l_process_name);
1379: --END IF;
1380: --IF G_DEBUG='Y' THEN
1381: AHL_DEBUG_PUB.debug('PCH -- PVT -- get_wf_process_name returns l_item_type='||l_item_type);
1382: --END IF;

Line 1381: AHL_DEBUG_PUB.debug('PCH -- PVT -- get_wf_process_name returns l_item_type='||l_item_type);

1377: --IF G_DEBUG='Y' THEN
1378: AHL_DEBUG_PUB.debug('PCH -- PVT -- get_wf_process_name returns l_process_name='||l_process_name);
1379: --END IF;
1380: --IF G_DEBUG='Y' THEN
1381: AHL_DEBUG_PUB.debug('PCH -- PVT -- get_wf_process_name returns l_item_type='||l_item_type);
1382: --END IF;
1383: --IF G_DEBUG='Y' THEN
1384: AHL_DEBUG_PUB.debug('PCH -- PVT -- get_wf_process_name returns l_return_status='||l_return_status);
1385: END IF;

Line 1384: AHL_DEBUG_PUB.debug('PCH -- PVT -- get_wf_process_name returns l_return_status='||l_return_status);

1380: --IF G_DEBUG='Y' THEN
1381: AHL_DEBUG_PUB.debug('PCH -- PVT -- get_wf_process_name returns l_item_type='||l_item_type);
1382: --END IF;
1383: --IF G_DEBUG='Y' THEN
1384: AHL_DEBUG_PUB.debug('PCH -- PVT -- get_wf_process_name returns l_return_status='||l_return_status);
1385: END IF;
1386:
1387: -- If the workflow process is active...
1388: IF l_active = 'Y'

Line 1406: AHL_DEBUG_PUB.debug('PCH -- PVT -- Before calling ahl_generic_aprv_pvt.start_wf_process');

1402: RAISE FND_API.G_EXC_ERROR;
1403: -- Else start PCWF workflow process for this PC
1404: ELSE
1405: IF G_DEBUG='Y' THEN
1406: AHL_DEBUG_PUB.debug('PCH -- PVT -- Before calling ahl_generic_aprv_pvt.start_wf_process');
1407: END IF;
1408:
1409: -- AJPRASAN:: Bug #9596384 :: We need to keep track of the BUE running option selected by the user - Automatic or Manual i.e., Yes or NO
1410: -- So that when Workflow is enabled and the Approver approves it, we need to choose on whether to run BUE or not

Line 1438: AHL_DEBUG_PUB.debug('PCH -- PVT -- After calling ahl_generic_aprv_pvt.start_wf_process');

1434: P_WORKFLOWPROCESS => l_process_name,
1435: P_ITEM_TYPE => l_item_type
1436: );
1437: IF G_DEBUG='Y' THEN
1438: AHL_DEBUG_PUB.debug('PCH -- PVT -- After calling ahl_generic_aprv_pvt.start_wf_process');
1439: END IF;
1440: END IF;
1441: ELSE
1442: -- If workflow process is inactive, then force complete the PC

Line 1447: AHL_DEBUG_PUB.debug('PCH -- PVT -- INITIATE_PC_APPROVAL -- This is not linked PC');

1443:
1444: IF ( p_x_pc_header_rec.LINK_TO_PC_ID IS NULL OR p_x_pc_header_rec.LINK_TO_PC_ID = 0 )
1445: THEN
1446: IF G_DEBUG='Y' THEN
1447: AHL_DEBUG_PUB.debug('PCH -- PVT -- INITIATE_PC_APPROVAL -- This is not linked PC');
1448: END IF;
1449:
1450: l_object_version_number := p_x_pc_header_rec.OBJECT_VERSION_NUMBER + 1;
1451:

Line 1464: AHL_DEBUG_PUB.debug('PCH -- PVT -- INITIATE_PC_APPROVAL -- This is linked PC');

1460:
1461: ELSE
1462:
1463: IF G_DEBUG='Y' THEN
1464: AHL_DEBUG_PUB.debug('PCH -- PVT -- INITIATE_PC_APPROVAL -- This is linked PC');
1465: END IF;
1466:
1467: p_x_pc_header_rec.STATUS := 'COMPLETE';
1468:

Line 1492: AHL_DEBUG_PUB.debug('PCH -- PVT -- INITIATE_PC_APPROVAL -- After PC Approval');

1488: x_warning_msg_data(0) := FND_MESSAGE.get;
1489: END IF;
1490:
1491: IF G_DEBUG='Y' THEN
1492: AHL_DEBUG_PUB.debug('PCH -- PVT -- INITIATE_PC_APPROVAL -- After PC Approval');
1493: END IF;
1494:
1495: END INITIATE_PC_APPROVAL;
1496:

Line 1626: AHL_DEBUG_PUB.ENABLE_DEBUG;

1622: l_node_tbl T_ID_TBL;
1623:
1624: BEGIN
1625: IF G_DEBUG='Y' THEN
1626: AHL_DEBUG_PUB.ENABLE_DEBUG;
1627: --END IF;
1628: --IF G_DEBUG='Y' THEN
1629: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_AND_TREE -- Reading PC Tree (Nodes)');
1630: END IF;

Line 1629: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_AND_TREE -- Reading PC Tree (Nodes)');

1625: IF G_DEBUG='Y' THEN
1626: AHL_DEBUG_PUB.ENABLE_DEBUG;
1627: --END IF;
1628: --IF G_DEBUG='Y' THEN
1629: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_AND_TREE -- Reading PC Tree (Nodes)');
1630: END IF;
1631:
1632: SELECT PC_NODE_ID
1633: BULK COLLECT INTO l_node_tbl

Line 1643: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_AND_TREE -- Handling force delete for Node ID='||l_node_tbl(i));

1639: THEN
1640: FOR i IN l_node_tbl.FIRST..l_node_tbl.LAST
1641: LOOP
1642: IF G_DEBUG='Y' THEN
1643: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_AND_TREE -- Handling force delete for Node ID='||l_node_tbl(i));
1644: END IF;
1645:
1646: -- Knocking off Doc Associations
1647: DELETE FROM AHL_DOC_TITLE_ASSOS_TL

Line 1670: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_AND_TREE -- Handling force delete for PC');

1666: END LOOP;
1667: END IF;
1668:
1669: IF G_DEBUG='Y' THEN
1670: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_AND_TREE -- Handling force delete for PC');
1671: END IF;
1672: -- Knocking off the PC
1673: AHL_PC_HEADERS_PKG.DELETE_ROW(p_pc_header_id);
1674:

Line 1847: AHL_DEBUG_PUB.ENABLE_DEBUG;

1843:
1844: x_return_status := FND_API.G_RET_STS_SUCCESS;
1845:
1846: IF G_DEBUG='Y' THEN
1847: AHL_DEBUG_PUB.ENABLE_DEBUG;
1848: END IF;
1849:
1850: l_old_header_id := p_x_pc_header_rec.PC_HEADER_ID;
1851: IF G_DEBUG='Y' THEN

Line 1852: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- Old Header ID='||l_old_header_id);

1848: END IF;
1849:
1850: l_old_header_id := p_x_pc_header_rec.PC_HEADER_ID;
1851: IF G_DEBUG='Y' THEN
1852: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- Old Header ID='||l_old_header_id);
1853: END IF;
1854:
1855: UPDATE AHL_PC_HEADERS_B
1856: SET DRAFT_FLAG = 'Y'

Line 1877: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- New Header ID='||p_x_pc_header_rec.PC_HEADER_ID);

1873: x_msg_data => x_msg_data
1874: );
1875:
1876: IF G_DEBUG='Y' THEN
1877: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- New Header ID='||p_x_pc_header_rec.PC_HEADER_ID);
1878: END IF;
1879:
1880: x_msg_count := FND_MSG_PUB.count_msg;
1881: IF x_msg_count > 0

Line 1895: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- Creating node record for PC_NODE_ID='||l_node_data_rec.PC_NODE_ID);

1891: EXIT WHEN copy_nodes_data%NOTFOUND;
1892: IF l_node_data_rec.node_type = G_NODE
1893: THEN
1894: IF G_DEBUG='Y' THEN
1895: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- Creating node record for PC_NODE_ID='||l_node_data_rec.PC_NODE_ID);
1896: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- Creating node record for PC_HEADER_ID ='||l_node_data_rec.PC_HEADER_ID);
1897: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- Creating node record for PARENT_NODE_ID ='||l_node_data_rec.PARENT_NODE_ID);
1898: END IF;
1899: l_node_rec.PC_NODE_ID := l_node_data_rec.PC_NODE_ID;

Line 1896: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- Creating node record for PC_HEADER_ID ='||l_node_data_rec.PC_HEADER_ID);

1892: IF l_node_data_rec.node_type = G_NODE
1893: THEN
1894: IF G_DEBUG='Y' THEN
1895: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- Creating node record for PC_NODE_ID='||l_node_data_rec.PC_NODE_ID);
1896: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- Creating node record for PC_HEADER_ID ='||l_node_data_rec.PC_HEADER_ID);
1897: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- Creating node record for PARENT_NODE_ID ='||l_node_data_rec.PARENT_NODE_ID);
1898: END IF;
1899: l_node_rec.PC_NODE_ID := l_node_data_rec.PC_NODE_ID;
1900: l_node_rec.PC_HEADER_ID := p_x_pc_header_rec.PC_HEADER_ID;

Line 1897: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- Creating node record for PARENT_NODE_ID ='||l_node_data_rec.PARENT_NODE_ID);

1893: THEN
1894: IF G_DEBUG='Y' THEN
1895: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- Creating node record for PC_NODE_ID='||l_node_data_rec.PC_NODE_ID);
1896: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- Creating node record for PC_HEADER_ID ='||l_node_data_rec.PC_HEADER_ID);
1897: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- Creating node record for PARENT_NODE_ID ='||l_node_data_rec.PARENT_NODE_ID);
1898: END IF;
1899: l_node_rec.PC_NODE_ID := l_node_data_rec.PC_NODE_ID;
1900: l_node_rec.PC_HEADER_ID := p_x_pc_header_rec.PC_HEADER_ID;
1901: l_node_rec.PARENT_NODE_ID := l_node_data_rec.PARENT_NODE_ID;

Line 1939: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- nodes:INDEXl_nc : '||l_nc);

1935: ELSE
1936: FOR l_nc IN 0..l_nodeCtr
1937: LOOP
1938: IF G_DEBUG='Y' THEN
1939: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- nodes:INDEXl_nc : '||l_nc);
1940: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK in the before first IF condition: l_nodeId_tbl(l_nc).NODE_ID '|| l_nodeId_tbl(l_nc).NODE_ID );
1941: END IF;
1942: IF l_nodeId_tbl(l_nc).NODE_ID = l_node_data_rec.PARENT_NODE_ID
1943: THEN

Line 1940: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK in the before first IF condition: l_nodeId_tbl(l_nc).NODE_ID '|| l_nodeId_tbl(l_nc).NODE_ID );

1936: FOR l_nc IN 0..l_nodeCtr
1937: LOOP
1938: IF G_DEBUG='Y' THEN
1939: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- nodes:INDEXl_nc : '||l_nc);
1940: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK in the before first IF condition: l_nodeId_tbl(l_nc).NODE_ID '|| l_nodeId_tbl(l_nc).NODE_ID );
1941: END IF;
1942: IF l_nodeId_tbl(l_nc).NODE_ID = l_node_data_rec.PARENT_NODE_ID
1943: THEN
1944: IF G_DEBUG='Y' THEN

Line 1945: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK in the first IF condition: l_nodeId_tbl(l_nc).NODE_ID ');

1941: END IF;
1942: IF l_nodeId_tbl(l_nc).NODE_ID = l_node_data_rec.PARENT_NODE_ID
1943: THEN
1944: IF G_DEBUG='Y' THEN
1945: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK in the first IF condition: l_nodeId_tbl(l_nc).NODE_ID ');
1946: END IF;
1947: IF l_node_data_rec.node_type = G_NODE
1948: THEN
1949: l_node_rec.PARENT_NODE_ID := l_nodeId_tbl(l_nc).NEW_NODE_ID;

Line 1951: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK in the Second IF condition:After copy l_nodeId_tbl(l_nc).NEW_NODE_ID '|| l_nodeId_tbl(l_nc).NEW_NODE_ID );

1947: IF l_node_data_rec.node_type = G_NODE
1948: THEN
1949: l_node_rec.PARENT_NODE_ID := l_nodeId_tbl(l_nc).NEW_NODE_ID;
1950: IF G_DEBUG='Y' THEN
1951: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK in the Second IF condition:After copy l_nodeId_tbl(l_nc).NEW_NODE_ID '|| l_nodeId_tbl(l_nc).NEW_NODE_ID );
1952: END IF;
1953: EXIT;
1954: END IF;
1955: END IF;

Line 1962: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- before call to AHL_PC_NODE_PVT.CREATE_NODE : l_node_data_rec.PC_NODE_ID'|| l_node_rec.PC_NODE_ID);

1958:
1959: IF l_node_data_rec.node_type = G_NODE
1960: THEN
1961: IF G_DEBUG='Y' THEN
1962: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- before call to AHL_PC_NODE_PVT.CREATE_NODE : l_node_data_rec.PC_NODE_ID'|| l_node_rec.PC_NODE_ID);
1963: END IF;
1964:
1965: AHL_PC_NODE_PVT.CREATE_NODE
1966: (

Line 1982: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- After call to AHL_PC_NODE_PVT.CREATE_NODE : l_nodeCtr'||l_nodeCtr);

1978: l_nodeId_tbl(l_nodeCtr).NEW_NODE_ID := l_node_rec.PC_NODE_ID;
1979: l_nodeCtr := l_nodeCtr + 1;
1980:
1981: IF G_DEBUG='Y' THEN
1982: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- After call to AHL_PC_NODE_PVT.CREATE_NODE : l_nodeCtr'||l_nodeCtr);
1983: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- After call to AHL_PC_NODE_PVT.CREATE_NODE : l_node_data_rec.PC_NODE_ID'|| l_node_rec.PC_NODE_ID);
1984: END IF;
1985:
1986: x_msg_count := FND_MSG_PUB.count_msg;

Line 1983: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- After call to AHL_PC_NODE_PVT.CREATE_NODE : l_node_data_rec.PC_NODE_ID'|| l_node_rec.PC_NODE_ID);

1979: l_nodeCtr := l_nodeCtr + 1;
1980:
1981: IF G_DEBUG='Y' THEN
1982: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- After call to AHL_PC_NODE_PVT.CREATE_NODE : l_nodeCtr'||l_nodeCtr);
1983: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- After call to AHL_PC_NODE_PVT.CREATE_NODE : l_node_data_rec.PC_NODE_ID'|| l_node_rec.PC_NODE_ID);
1984: END IF;
1985:
1986: x_msg_count := FND_MSG_PUB.count_msg;
1987: IF x_msg_count > 0

Line 1993: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- after raising exceptions: After Create Node');

1989: RAISE FND_API.G_EXC_ERROR;
1990: END IF;
1991:
1992: IF G_DEBUG='Y' THEN
1993: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- after raising exceptions: After Create Node');
1994: END IF;
1995:
1996: l_assosCtr:=0;
1997: OPEN copy_document(l_node_data_rec.PC_NODE_ID);

Line 2002: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- Creating doc record for ID='||l_assos_data_rec.DOCUMENT_ID);

1998: LOOP
1999: FETCH copy_document INTO l_assos_data_rec;
2000: EXIT WHEN copy_document%NOTFOUND;
2001: IF G_DEBUG='Y' THEN
2002: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- Creating doc record for ID='||l_assos_data_rec.DOCUMENT_ID);
2003: END IF;
2004: l_assosCtr := l_assosCtr + 1;
2005: l_assos_doc_tbl(l_assosCtr).DOC_TITLE_ASSO_ID := null;
2006: l_assos_doc_tbl(l_assosCtr).DOCUMENT_ID := l_assos_data_rec.DOCUMENT_ID ;

Line 2066: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- Creating unit/part record for ID='||l_node_asso_rec.PC_NODE_ID);

2062:
2063: IF l_node_asso_rec.node_type IN (G_PART,G_UNIT)
2064: THEN
2065: IF G_DEBUG='Y' THEN
2066: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- Creating unit/part record for ID='||l_node_asso_rec.PC_NODE_ID);
2067: END IF;
2068: l_assos_rec.PC_ASSOCIATION_ID := l_node_asso_rec.PC_NODE_ID;
2069: l_assos_rec.UNIT_ITEM_ID := l_node_asso_rec.UNIT_ITEM_ID;
2070: l_assos_rec.INVENTORY_ORG_ID := l_node_asso_rec.INVENTORY_ORG_ID;

Line 2102: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- units:INDEXl_nc : '||l_nc);

2098:
2099: FOR l_nc IN 0..l_nodeCtr
2100: LOOP
2101: IF G_DEBUG='Y' THEN
2102: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- units:INDEXl_nc : '||l_nc);
2103: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK in the before first IF condition: l_nodeId_tbl(l_nc).NODE_ID '|| l_nodeId_tbl(l_nc).NODE_ID );
2104: END IF;
2105: IF l_nodeId_tbl(l_nc).NODE_ID = l_node_asso_rec.PARENT_NODE_ID
2106: THEN

Line 2103: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK in the before first IF condition: l_nodeId_tbl(l_nc).NODE_ID '|| l_nodeId_tbl(l_nc).NODE_ID );

2099: FOR l_nc IN 0..l_nodeCtr
2100: LOOP
2101: IF G_DEBUG='Y' THEN
2102: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- units:INDEXl_nc : '||l_nc);
2103: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK in the before first IF condition: l_nodeId_tbl(l_nc).NODE_ID '|| l_nodeId_tbl(l_nc).NODE_ID );
2104: END IF;
2105: IF l_nodeId_tbl(l_nc).NODE_ID = l_node_asso_rec.PARENT_NODE_ID
2106: THEN
2107: IF l_node_asso_rec.node_type IN (G_PART, G_UNIT)

Line 2111: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK in the units case IF condition:After copy l_nodeId_tbl(l_nc).NEW_NODE_ID '|| l_nodeId_tbl(l_nc).NEW_NODE_ID );

2107: IF l_node_asso_rec.node_type IN (G_PART, G_UNIT)
2108: THEN
2109: l_assos_rec.PC_NODE_ID := l_nodeId_tbl(l_nc).NEW_NODE_ID;
2110: IF G_DEBUG='Y' THEN
2111: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK in the units case IF condition:After copy l_nodeId_tbl(l_nc).NEW_NODE_ID '|| l_nodeId_tbl(l_nc).NEW_NODE_ID );
2112: END IF;
2113: EXIT;
2114: END IF;
2115: END IF;

Line 2121: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- before call to AHL_PC_ASSOCIATION_PVT.ATTACH_UNIT : l_node_asso_rec.PC_NODE_ID'|| l_assos_rec.PC_NODE_ID);

2117:
2118: IF l_node_asso_rec.node_type = G_UNIT
2119: THEN
2120: IF G_DEBUG='Y' THEN
2121: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- before call to AHL_PC_ASSOCIATION_PVT.ATTACH_UNIT : l_node_asso_rec.PC_NODE_ID'|| l_assos_rec.PC_NODE_ID);
2122: END IF;
2123: AHL_PC_ASSOCIATION_PVT.ATTACH_UNIT(
2124: p_api_version => p_api_version,
2125: p_init_msg_list => FND_API.G_FALSE,

Line 2134: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- After call to AHL_PC_ASSOCIATION_PVT.ATTACH_UNIT : l_node_asso_rec.PC_NODE_ID'|| l_assos_rec.PC_NODE_ID);

2130: x_msg_count => x_msg_count,
2131: x_msg_data => x_msg_data
2132: );
2133: IF G_DEBUG='Y' THEN
2134: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- After call to AHL_PC_ASSOCIATION_PVT.ATTACH_UNIT : l_node_asso_rec.PC_NODE_ID'|| l_assos_rec.PC_NODE_ID);
2135: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- After call to AHL_PC_ASSOCIATION_PVT.ATTACH_UNIT : l_node_asso_rec.PC_ASSOCIATION_ID'|| l_assos_rec.PC_ASSOCIATION_ID);
2136:
2137: END IF;
2138:

Line 2135: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- After call to AHL_PC_ASSOCIATION_PVT.ATTACH_UNIT : l_node_asso_rec.PC_ASSOCIATION_ID'|| l_assos_rec.PC_ASSOCIATION_ID);

2131: x_msg_data => x_msg_data
2132: );
2133: IF G_DEBUG='Y' THEN
2134: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- After call to AHL_PC_ASSOCIATION_PVT.ATTACH_UNIT : l_node_asso_rec.PC_NODE_ID'|| l_assos_rec.PC_NODE_ID);
2135: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- After call to AHL_PC_ASSOCIATION_PVT.ATTACH_UNIT : l_node_asso_rec.PC_ASSOCIATION_ID'|| l_assos_rec.PC_ASSOCIATION_ID);
2136:
2137: END IF;
2138:
2139: ELSIF l_node_asso_rec.node_type = G_PART

Line 2142: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- before call to AHL_PC_ASSOCIATION_PVT.ATTACH_ITEM : l_node_asso_rec.PC_NODE_ID'|| l_assos_rec.PC_NODE_ID);

2138:
2139: ELSIF l_node_asso_rec.node_type = G_PART
2140: THEN
2141: IF G_DEBUG='Y' THEN
2142: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- before call to AHL_PC_ASSOCIATION_PVT.ATTACH_ITEM : l_node_asso_rec.PC_NODE_ID'|| l_assos_rec.PC_NODE_ID);
2143: END IF;
2144: AHL_PC_ASSOCIATION_PVT.ATTACH_ITEM(
2145: p_api_version => p_api_version,
2146: p_init_msg_list => FND_API.G_FALSE,

Line 2155: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- After call to AHL_PC_ASSOCIATION_PVT.ATTACH_ITEM: l_node_asso_rec.PC_NODE_ID'|| l_assos_rec.PC_NODE_ID);

2151: x_msg_count => x_msg_count,
2152: x_msg_data => x_msg_data
2153: );
2154: IF G_DEBUG='Y' THEN
2155: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- After call to AHL_PC_ASSOCIATION_PVT.ATTACH_ITEM: l_node_asso_rec.PC_NODE_ID'|| l_assos_rec.PC_NODE_ID);
2156: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- After call to AHL_PC_ASSOCIATION_PVT.ATTACH_ITEM : l_node_asso_rec.PC_ASSOCIATION_ID'|| l_assos_rec.PC_ASSOCIATION_ID);
2157:
2158: END IF;
2159:

Line 2156: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- After call to AHL_PC_ASSOCIATION_PVT.ATTACH_ITEM : l_node_asso_rec.PC_ASSOCIATION_ID'|| l_assos_rec.PC_ASSOCIATION_ID);

2152: x_msg_data => x_msg_data
2153: );
2154: IF G_DEBUG='Y' THEN
2155: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- After call to AHL_PC_ASSOCIATION_PVT.ATTACH_ITEM: l_node_asso_rec.PC_NODE_ID'|| l_assos_rec.PC_NODE_ID);
2156: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- After call to AHL_PC_ASSOCIATION_PVT.ATTACH_ITEM : l_node_asso_rec.PC_ASSOCIATION_ID'|| l_assos_rec.PC_ASSOCIATION_ID);
2157:
2158: END IF;
2159:
2160: END IF;

Line 2268: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_NODES_REMOVE_LINK reading child-node-tree');

2264: END IF;
2265: CLOSE get_pc_details;
2266:
2267: IF G_DEBUG='Y' THEN
2268: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_NODES_REMOVE_LINK reading child-node-tree');
2269: END IF;
2270:
2271: SELECT pc_node_id
2272: BULK COLLECT

Line 2281: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_NODES_REMOVE_LINK reading association-tree');

2277: START WITH pc_node_id = l_node_id
2278: ORDER BY pc_node_id DESC;
2279:
2280: IF G_DEBUG='Y' THEN
2281: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_NODES_REMOVE_LINK reading association-tree');
2282: END IF;
2283:
2284: SELECT pc_association_id
2285: BULK COLLECT INTO l_assos_tbl

Line 2296: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_NODES_REMOVE_LINK retrieving linked_node_id which will have FMP, UMP and Doc associations');

2292: START WITH pc_node_id = l_node_id
2293: );
2294:
2295: IF G_DEBUG='Y' THEN
2296: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_NODES_REMOVE_LINK retrieving linked_node_id which will have FMP, UMP and Doc associations');
2297: END IF;
2298:
2299: If(l_assos_tbl.COUNT > 0)
2300: THEN

Line 2304: AHL_DEBUG_PUB.debug('PCN -- PVT -- Knocking off unit/part associations for unit_item_id='||l_assos_tbl(i));

2300: THEN
2301: FOR i IN l_assos_tbl.FIRST..l_assos_tbl.LAST
2302: LOOP
2303: IF G_DEBUG='Y' THEN
2304: AHL_DEBUG_PUB.debug('PCN -- PVT -- Knocking off unit/part associations for unit_item_id='||l_assos_tbl(i));
2305: END IF;
2306:
2307: -- Knocking off unit/part associations...
2308: DELETE

Line 2319: AHL_DEBUG_PUB.debug('PCN -- PVT -- Knocking off doc associations from PC nodes for pc_node_id='||get_linked_node_id(l_node_tbl(j)));

2315: THEN
2316: FOR j IN l_node_tbl.FIRST..l_node_tbl.LAST
2317: LOOP
2318: IF G_DEBUG='Y' THEN
2319: AHL_DEBUG_PUB.debug('PCN -- PVT -- Knocking off doc associations from PC nodes for pc_node_id='||get_linked_node_id(l_node_tbl(j)));
2320: END IF;
2321:
2322: l_linked_node_id := GET_LINKED_NODE_ID(l_node_tbl(j));
2323:

Line 2345: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_NODES_REMOVE_LINK for pc_node_id='||p_x_node_rec.PC_NODE_ID);

2341: END LOOP;
2342: END IF;
2343:
2344: IF G_DEBUG='Y' THEN
2345: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_NODES_REMOVE_LINK for pc_node_id='||p_x_node_rec.PC_NODE_ID);
2346: END IF;
2347:
2348: IF ((l_node_tbl.COUNT > 0) AND (p_x_node_rec.pc_node_id IS NOT NULL))
2349: THEN

Line 2371: AHL_DEBUG_PUB.debug('PCH -- PVT -- DETACH_UNIT_REMOVE_LINK for ID='||p_x_assos_rec.PC_ASSOCIATION_ID);

2367: DELETE FROM AHL_PC_ASSOCIATIONS
2368: WHERE PC_ASSOCIATION_ID = p_x_assos_rec.PC_ASSOCIATION_ID;
2369:
2370: IF G_DEBUG='Y' THEN
2371: AHL_DEBUG_PUB.debug('PCH -- PVT -- DETACH_UNIT_REMOVE_LINK for ID='||p_x_assos_rec.PC_ASSOCIATION_ID);
2372: END IF;
2373:
2374: UPDATE ahl_pc_nodes_b
2375: SET child_count = NVL(child_count, 1) - 1

Line 2392: AHL_DEBUG_PUB.debug('PCH -- PVT -- DETACH_ITEM_REMOVE_LINK for ID='||p_x_assos_rec.PC_ASSOCIATION_ID);

2388: DELETE FROM AHL_PC_ASSOCIATIONS
2389: WHERE PC_ASSOCIATION_ID = p_x_assos_rec.PC_ASSOCIATION_ID;
2390:
2391: IF G_DEBUG='Y' THEN
2392: AHL_DEBUG_PUB.debug('PCH -- PVT -- DETACH_ITEM_REMOVE_LINK for ID='||p_x_assos_rec.PC_ASSOCIATION_ID);
2393: END IF;
2394:
2395: UPDATE ahl_pc_nodes_b
2396: SET child_count = NVL(child_count, 1) - 1

Line 2776: AHL_DEBUG_PUB.debug('PCH -- PVT -- REMOVE_LINK -- Aborting because not linked PC');

2772: IF ( p_x_pc_header_rec.LINK_TO_PC_ID IS NULL OR p_x_pc_header_rec.LINK_TO_PC_ID = 0 )
2773: THEN
2774:
2775: IF G_DEBUG='Y' THEN
2776: AHL_DEBUG_PUB.debug('PCH -- PVT -- REMOVE_LINK -- Aborting because not linked PC');
2777: END IF;
2778: RETURN;
2779: END IF;
2780:

Line 2787: AHL_DEBUG_PUB.debug('PCH -- PVT -- REMOVE_LINK -- Aborting because not found linked-to PC');

2783: FETCH delete_header INTO l_dummy;
2784: IF (delete_header%NOTFOUND)
2785: THEN
2786: IF G_DEBUG='Y' THEN
2787: AHL_DEBUG_PUB.debug('PCH -- PVT -- REMOVE_LINK -- Aborting because not found linked-to PC');
2788: END IF;
2789: CLOSE delete_header;
2790: RETURN;
2791: END IF;

Line 3044: AHL_DEBUG_PUB.debug('PCH -- PVT -- REMOVE_LINK -- Node record for ID='||l_node_rec.PC_NODE_ID);

3040: l_node_rec.PC_NODE_ID := l_node_data_rec.LINK_TO_NODE_ID;
3041: END IF;
3042:
3043: IF G_DEBUG='Y' THEN
3044: AHL_DEBUG_PUB.debug('PCH -- PVT -- REMOVE_LINK -- Node record for ID='||l_node_rec.PC_NODE_ID);
3045: END IF;
3046:
3047: l_node_rec.PARENT_NODE_ID := l_node_data_rec.PARENT_NODE_ID;
3048: l_node_rec.CHILD_COUNT := l_node_data_rec.CHILD_COUNT;

Line 3160: AHL_DEBUG_PUB.debug('PCH -- PVT -- REMOVE_LINK -- Unit/Part record for ID='||l_assos_rec.PC_ASSOCIATION_ID);

3156: l_assos_rec.PC_ASSOCIATION_ID := l_node_units_data_rec.LINK_TO_NODE_ID;
3157: END IF;
3158:
3159: IF G_DEBUG='Y' THEN
3160: AHL_DEBUG_PUB.debug('PCH -- PVT -- REMOVE_LINK -- Unit/Part record for ID='||l_assos_rec.PC_ASSOCIATION_ID);
3161: END IF;
3162:
3163: l_assos_rec.PC_NODE_ID := l_node_units_data_rec.PARENT_NODE_ID;
3164: l_assos_rec.UNIT_ITEM_ID := l_node_units_data_rec.UNIT_ITEM_ID;

Line 3648: AHL_DEBUG_PUB.ENABLE_DEBUG;

3644:
3645: x_return_status := FND_API.G_RET_STS_SUCCESS;
3646:
3647: IF G_DEBUG='Y' THEN
3648: AHL_DEBUG_PUB.ENABLE_DEBUG;
3649: END IF;
3650:
3651: OPEN check_header_data (p_x_pc_header_rec.PC_HEADER_ID);
3652: FETCH check_header_data INTO

Line 3684: AHL_DEBUG_PUB.debug('PCH -- PVT -- VALIDATE_PC_HEADER_UPDATE -- Old Status = '||l_old_status||' -- New Status = '||p_x_pc_header_rec.STATUS);

3680: RAISE FND_API.G_EXC_ERROR;
3681: END IF;
3682:
3683: IF G_DEBUG='Y' THEN
3684: AHL_DEBUG_PUB.debug('PCH -- PVT -- VALIDATE_PC_HEADER_UPDATE -- Old Status = '||l_old_status||' -- New Status = '||p_x_pc_header_rec.STATUS);
3685: END IF;
3686:
3687: -- PC is COMPLETE -- User submits without changing to DRAFT -- ERROR
3688: IF p_x_pc_header_rec.STATUS = 'COMPLETE' AND l_old_status = 'COMPLETE'