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_PC_HEADER_PVT

Line 1: PACKAGE BODY AHL_PC_HEADER_PVT AS

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:

Line 145: IF p_x_pc_header_rec.OPERATION_FLAG = AHL_PC_HEADER_PVT.G_DML_CREATE

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
147: p_x_pc_header_rec.PC_HEADER_ID :=0;
148: END IF;
149:

Line 163: IF p_x_pc_header_rec.OPERATION_FLAG = AHL_PC_HEADER_PVT.G_DML_LINK

159: -- Insert Record into ahl_pc_header_headers,
160: -- call table handler insert record
161: SELECT AHL_PC_HEADERS_B_S.NEXTVAL INTO l_header_id FROM DUAL;
162:
163: IF p_x_pc_header_rec.OPERATION_FLAG = AHL_PC_HEADER_PVT.G_DML_LINK
164: THEN
165: l_link_id := p_x_pc_header_rec.LINK_TO_PC_ID;
166: END IF;
167:

Line 344: IF p_x_pc_header_rec.OPERATION_FLAG <> AHL_PC_HEADER_PVT.G_DML_LINK

340: INTO p_x_pc_header_rec.LINK_TO_PC_ID
341: FROM AHL_PC_HEADERS_VL
342: WHERE PC_HEADER_ID = p_x_pc_header_rec.PC_HEADER_ID;
343:
344: IF p_x_pc_header_rec.OPERATION_FLAG <> AHL_PC_HEADER_PVT.G_DML_LINK
345: THEN
346: VALIDATE_PC_HEADER (p_x_pc_header_rec => p_x_pc_header_rec);
347:
348: VALIDATE_PC_HEADER_UPDATE

Line 365: IF p_x_pc_header_rec.OPERATION_FLAG = AHL_PC_HEADER_PVT.G_DML_LINK

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
367: -- Check Error Message stack.
368: x_msg_count := FND_MSG_PUB.count_msg;
369: IF x_msg_count > 0

Line 944: p_x_pc_header_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_CREATE;

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;
945:
946: -- Check whether another PC with the same name exists, throw error in that case
947: OPEN check_name_unique( p_x_pc_header_rec.name );
948: FETCH check_name_unique INTO l_dummy_2;

Line 1029: l_node_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_COPY;

1025: l_node_rec.DESCRIPTION := l_node_data_rec.DESCRIPTION;
1026: l_node_rec.DRAFT_FLAG := 'N';
1027: l_node_rec.LINK_TO_NODE_ID := 0;
1028: l_node_rec.OBJECT_VERSION_NUMBER := 1;
1029: l_node_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_COPY;
1030: l_node_rec.ATTRIBUTE_CATEGORY := l_node_data_rec.ATTRIBUTE_CATEGORY;
1031: l_node_rec.ATTRIBUTE1 := l_node_data_rec.ATTRIBUTE1;
1032: l_node_rec.ATTRIBUTE2 := l_node_data_rec.ATTRIBUTE2;
1033: l_node_rec.ATTRIBUTE3 := l_node_data_rec.ATTRIBUTE3;

Line 1178: l_assos_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_COPY;

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;
1176: l_assos_rec.DRAFT_FLAG := 'N';
1177: l_assos_rec.LINK_TO_ASSOCIATION_ID := 0;
1178: l_assos_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_COPY;
1179: l_assos_rec.OBJECT_VERSION_NUMBER := 1;
1180: l_assos_rec.ATTRIBUTE_CATEGORY := l_node_units_data_rec.ATTRIBUTE_CATEGORY;
1181: l_assos_rec.ATTRIBUTE1 := l_node_units_data_rec.ATTRIBUTE1;
1182: l_assos_rec.ATTRIBUTE2 := l_node_units_data_rec.ATTRIBUTE2;

Line 1544: IF p_x_pc_header_rec.OPERATION_FLAG NOT IN (AHL_PC_HEADER_PVT.G_DML_DELETE) THEN

1540:
1541:
1542: BEGIN
1543:
1544: IF p_x_pc_header_rec.OPERATION_FLAG NOT IN (AHL_PC_HEADER_PVT.G_DML_DELETE) THEN
1545:
1546: -- CHECK NAME UNIQUE
1547: OPEN check_name(p_pc_header_id => p_x_pc_header_rec.PC_HEADER_ID,
1548: p_name => p_x_pc_header_rec.NAME,

Line 1862: p_x_pc_header_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;

1858:
1859: p_x_pc_header_rec.LINK_TO_PC_ID := l_old_header_id;
1860: p_x_pc_header_rec.DRAFT_FLAG := 'N';
1861: p_x_pc_header_rec.STATUS := 'DRAFT';
1862: p_x_pc_header_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;
1863:
1864: CREATE_PC_HEADER
1865: (
1866: p_api_version => p_api_version,

Line 1905: l_node_rec.OPERATION_STATUS_FLAG := AHL_PC_HEADER_PVT.G_DML_CREATE;

1901: l_node_rec.PARENT_NODE_ID := l_node_data_rec.PARENT_NODE_ID;
1902: l_node_rec.CHILD_COUNT := l_node_data_rec.CHILD_COUNT;
1903: l_node_rec.NAME := l_node_data_rec.NAME;
1904: l_node_rec.DESCRIPTION := l_node_data_rec.DESCRIPTION;
1905: l_node_rec.OPERATION_STATUS_FLAG := AHL_PC_HEADER_PVT.G_DML_CREATE;
1906: l_node_rec.OBJECT_VERSION_NUMBER := l_node_data_rec.OBJECT_VERSION_NUMBER;
1907: l_node_rec.DRAFT_FLAG := 'N';
1908: l_node_rec.LINK_TO_NODE_ID := l_node_data_rec.PC_NODE_ID;
1909: l_node_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;

Line 1909: l_node_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;

1905: l_node_rec.OPERATION_STATUS_FLAG := AHL_PC_HEADER_PVT.G_DML_CREATE;
1906: l_node_rec.OBJECT_VERSION_NUMBER := l_node_data_rec.OBJECT_VERSION_NUMBER;
1907: l_node_rec.DRAFT_FLAG := 'N';
1908: l_node_rec.LINK_TO_NODE_ID := l_node_data_rec.PC_NODE_ID;
1909: l_node_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;
1910: l_node_rec.ATTRIBUTE_CATEGORY := l_node_data_rec.ATTRIBUTE_CATEGORY;
1911: l_node_rec.ATTRIBUTE1 := l_node_data_rec.ATTRIBUTE1;
1912: l_node_rec.ATTRIBUTE2 := l_node_data_rec.ATTRIBUTE2;
1913: l_node_rec.ATTRIBUTE3 := l_node_data_rec.ATTRIBUTE3;

Line 2072: l_assos_rec.OPERATION_STATUS_FLAG := AHL_PC_HEADER_PVT.G_DML_CREATE;

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;
2071: l_assos_rec.ASSOCIATION_TYPE_FLAG := l_node_asso_rec.NODE_TYPE;
2072: l_assos_rec.OPERATION_STATUS_FLAG := AHL_PC_HEADER_PVT.G_DML_CREATE;
2073: l_assos_rec.DRAFT_FLAG := 'N';
2074: l_assos_rec.LINK_TO_ASSOCIATION_ID := l_node_asso_rec.PC_NODE_ID;
2075: l_assos_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;
2076: l_assos_rec.ATTRIBUTE_CATEGORY := l_node_asso_rec.ATTRIBUTE_CATEGORY;

Line 2075: l_assos_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;

2071: l_assos_rec.ASSOCIATION_TYPE_FLAG := l_node_asso_rec.NODE_TYPE;
2072: l_assos_rec.OPERATION_STATUS_FLAG := AHL_PC_HEADER_PVT.G_DML_CREATE;
2073: l_assos_rec.DRAFT_FLAG := 'N';
2074: l_assos_rec.LINK_TO_ASSOCIATION_ID := l_node_asso_rec.PC_NODE_ID;
2075: l_assos_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;
2076: l_assos_rec.ATTRIBUTE_CATEGORY := l_node_asso_rec.ATTRIBUTE_CATEGORY;
2077: l_assos_rec.ATTRIBUTE1 := l_node_asso_rec.ATTRIBUTE1;
2078: l_assos_rec.ATTRIBUTE2 := l_node_asso_rec.ATTRIBUTE2;
2079: l_assos_rec.ATTRIBUTE3 := l_node_asso_rec.ATTRIBUTE3;

Line 2865: p_x_pc_header_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;

2861:
2862: p_x_pc_header_rec.PC_HEADER_ID := l_pc_header_rec.LINK_TO_PC_ID;
2863: p_x_pc_header_rec.LINK_TO_PC_ID := 0;
2864: p_x_pc_header_rec.DRAFT_FLAG := 'N';
2865: p_x_pc_header_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;
2866:
2867: SELECT OBJECT_VERSION_NUMBER INTO p_x_pc_header_rec.OBJECT_VERSION_NUMBER
2868: FROM AHL_PC_HEADERS_B
2869: WHERE PC_HEADER_ID = l_pc_header_rec.LINK_TO_PC_ID;

Line 2872: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',

2868: FROM AHL_PC_HEADERS_B
2869: WHERE PC_HEADER_ID = l_pc_header_rec.LINK_TO_PC_ID;
2870:
2871: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2872: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',
2873: 'About to call UPDATE_PC_HEADER with p_x_pc_header_rec.PC_HEADER_ID = ' || p_x_pc_header_rec.PC_HEADER_ID);
2874: END IF;
2875:
2876: UPDATE_PC_HEADER

Line 2891: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',

2887: );
2888:
2889:
2890: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2891: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',
2892: 'Returned from UPDATE_PC_HEADER with x_return_status = ' || x_return_status);
2893: END IF;
2894:
2895:

Line 2931: l_node_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_DELETE;

2927: l_node_rec.NAME := l_node_data_rec_det.NAME;
2928: l_node_rec.DESCRIPTION := l_node_data_rec_det.DESCRIPTION;
2929: l_node_rec.DRAFT_FLAG := 'N';
2930: l_node_rec.LINK_TO_NODE_ID := 0;
2931: l_node_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_DELETE;
2932: l_node_rec.OBJECT_VERSION_NUMBER := l_node_data_rec_det.OBJECT_VERSION_NUMBER;
2933:
2934: ELSIF l_node_data_rec_det.node_type IN (G_PART, G_UNIT)
2935: THEN

Line 2944: l_assos_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_DELETE;

2940: l_assos_rec.INVENTORY_ORG_ID := l_node_data_rec_det.INVENTORY_ORG_ID;
2941: l_assos_rec.ASSOCIATION_TYPE_FLAG := l_node_data_rec_det.node_type;
2942: l_assos_rec.DRAFT_FLAG := 'N';
2943: l_assos_rec.LINK_TO_ASSOCIATION_ID := 0;
2944: l_assos_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_DELETE;
2945: l_assos_rec.OBJECT_VERSION_NUMBER := l_node_data_rec_det.OBJECT_VERSION_NUMBER;
2946:
2947: END IF;
2948:

Line 2966: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',

2962: END LOOP;
2963: CLOSE detach_nodes;
2964:
2965: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2966: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',
2967: 'Completed detach_nodes loop');
2968: END IF;
2969:
2970: -- Added to delete those associations which has association id, node id and header id the same

Line 2986: l_assos_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_DELETE;

2982: l_assos_rec.INVENTORY_ORG_ID := l_asso_data_rec_det.INVENTORY_ORG_ID;
2983: l_assos_rec.ASSOCIATION_TYPE_FLAG := l_asso_data_rec_det.ASSOCIATION_TYPE_FLAG;
2984: l_assos_rec.DRAFT_FLAG := 'N';
2985: l_assos_rec.LINK_TO_ASSOCIATION_ID := 0;
2986: l_assos_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_DELETE;
2987: l_assos_rec.OBJECT_VERSION_NUMBER := l_asso_data_rec_det.OBJECT_VERSION_NUMBER;
2988:
2989: END IF;
2990:

Line 3004: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',

3000: END LOOP;
3001: CLOSE detach_associations;
3002:
3003: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3004: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',
3005: 'Completed detach_associations loop');
3006: END IF;
3007:
3008:

Line 3026: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',

3022: FETCH attach_nodes INTO l_node_data_rec;
3023: EXIT WHEN attach_nodes%NOTFOUND;
3024:
3025: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3026: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',
3027: 'In attach_nodes loop. l_node_data_rec.node_type = ' || l_node_data_rec.node_type ||
3028: ', l_node_data_rec.PC_NODE_ID = ' || l_node_data_rec.PC_NODE_ID ||
3029: ', l_node_data_rec.LINK_TO_NODE_ID = ' || l_node_data_rec.LINK_TO_NODE_ID);
3030: END IF;

Line 3053: l_node_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;

3049: l_node_rec.NAME := l_node_data_rec.NAME;
3050: l_node_rec.DESCRIPTION := l_node_data_rec.DESCRIPTION;
3051: l_node_rec.DRAFT_FLAG := 'N';
3052: l_node_rec.LINK_TO_NODE_ID := 0;
3053: l_node_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;
3054: l_node_rec.ATTRIBUTE_CATEGORY := l_node_data_rec.ATTRIBUTE_CATEGORY;
3055: l_node_rec.ATTRIBUTE1 := l_node_data_rec.ATTRIBUTE1;
3056: l_node_rec.ATTRIBUTE2 := l_node_data_rec.ATTRIBUTE2;
3057: l_node_rec.ATTRIBUTE3 := l_node_data_rec.ATTRIBUTE3;

Line 3076: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',

3072: FROM AHL_PC_NODES_B
3073: WHERE PC_NODE_ID = l_node_rec.PC_NODE_ID;
3074:
3075: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3076: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',
3077: 'Got l_node_rec.OBJECT_VERSION_NUMBER as ' || l_node_rec.OBJECT_VERSION_NUMBER);
3078: END IF;
3079:
3080: END IF;

Line 3102: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',

3098:
3099: IF l_node_data_rec.node_type = G_NODE
3100: THEN
3101: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3102: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',
3103: 'Before AHL_PC_NODE_PVT.UPDATE_NODE :l_node_rec.PC_NODE_ID ' || l_node_rec.PC_NODE_ID);
3104: END IF;
3105:
3106: AHL_PC_NODE_PVT.UPDATE_NODE

Line 3123: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',

3119: l_nodeId_tbl(l_nodeCtr).NEW_NODE_ID := l_node_rec.PC_NODE_ID;
3120: l_nodeCtr := l_nodeCtr + 1;
3121:
3122: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3123: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',
3124: 'After AHL_PC_NODE_PVT.UPDATE_NODE :l_node_rec.PC_NODE_ID ' || l_node_rec.PC_NODE_ID);
3125: END IF;
3126:
3127: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3128: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',

3124: 'After AHL_PC_NODE_PVT.UPDATE_NODE :l_node_rec.PC_NODE_ID ' || l_node_rec.PC_NODE_ID);
3125: END IF;
3126:
3127: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3128: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',
3129: 'After AHL_PC_NODE_PVT.UPDATE_NODE :l_nodeCtr ' || l_nodeCtr);
3130: END IF;
3131:
3132: END IF;

Line 3144: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',

3140: FETCH attach_nodes_units INTO l_node_units_data_rec;
3141: EXIT WHEN attach_nodes_units%NOTFOUND;
3142:
3143: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3144: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',
3145: 'In attach_nodes_units loop. l_node_units_data_rec.node_type = ' || l_node_units_data_rec.node_type ||
3146: ', l_node_units_data_rec.PC_NODE_ID = ' || l_node_units_data_rec.PC_NODE_ID ||
3147: ', l_node_units_data_rec.LINK_TO_NODE_ID = ' || l_node_units_data_rec.LINK_TO_NODE_ID);
3148: END IF;

Line 3169: l_assos_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;

3165: l_assos_rec.INVENTORY_ORG_ID := l_node_units_data_rec.INVENTORY_ORG_ID;
3166: l_assos_rec.ASSOCIATION_TYPE_FLAG := l_node_units_data_rec.NODE_TYPE;
3167: l_assos_rec.DRAFT_FLAG := 'N';
3168: l_assos_rec.LINK_TO_ASSOCIATION_ID := 0;
3169: l_assos_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;
3170: l_assos_rec.ATTRIBUTE_CATEGORY := l_node_units_data_rec.ATTRIBUTE_CATEGORY;
3171: l_assos_rec.ATTRIBUTE1 := l_node_units_data_rec.ATTRIBUTE1;
3172: l_assos_rec.ATTRIBUTE2 := l_node_units_data_rec.ATTRIBUTE2;
3173: l_assos_rec.ATTRIBUTE3 := l_node_units_data_rec.ATTRIBUTE3;

Line 3191: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',

3187: SELECT OBJECT_VERSION_NUMBER INTO l_assos_rec.OBJECT_VERSION_NUMBER
3188: FROM AHL_PC_ASSOCIATIONS
3189: WHERE PC_ASSOCIATION_ID = l_assos_rec.PC_ASSOCIATION_ID;
3190: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3191: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',
3192: 'Got l_node_rec.OBJECT_VERSION_NUMBER as ' || l_node_rec.OBJECT_VERSION_NUMBER);
3193: END IF;
3194:
3195: END IF;

Line 3212: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',

3208:
3209: IF l_node_units_data_rec.node_type ='U'
3210: THEN
3211: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3212: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',
3213: 'Before AHL_PC_ASSOCIATION_PVT.ATTACH_UNIT :l_assos_rec.PC_NODE_ID ' || l_node_rec.PC_NODE_ID);
3214: END IF;
3215:
3216: AHL_PC_ASSOCIATION_PVT.ATTACH_UNIT

Line 3229: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',

3225: x_msg_data => x_msg_data
3226: );
3227:
3228: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3229: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',
3230: 'After AHL_PC_ASSOCIATION_PVT.ATTACH_UNIT :l_assos_rec.PC_NODE_ID ' || l_node_rec.PC_NODE_ID);
3231: END IF;
3232: ELSIF l_node_units_data_rec.node_type ='I'
3233: THEN

Line 3320: l_pc_header_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_DELETE;

3316: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,' Docs Merge ends');
3317: END IF;
3318:
3319:
3320: l_pc_header_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_DELETE;
3321:
3322: DELETE_PC_AND_TREE(l_pc_header_rec.pc_header_id);
3323:
3324: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3328: p_x_pc_header_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;

3324: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3325: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,' Deleted Header Record');
3326: END IF;
3327:
3328: p_x_pc_header_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;
3329:
3330: -- SATHAPLI::Bug# 6504069, 26-Mar-2008
3331: -- The call to API AHL_UMP_UNITMAINT_PVT.PROCESS_UNITEFFECTIVITY for building
3332: -- unit effectivities has been commented out for performance reasons.

Line 3759: END AHL_PC_HEADER_PVT;

3755: END IF;
3756:
3757: END VALIDATE_PC_HEADER_UPDATE;
3758:
3759: END AHL_PC_HEADER_PVT;