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 FND_LOG

Line 2768: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2764: END IF;
2765:
2766: x_return_status := FND_API.G_RET_STS_SUCCESS;
2767:
2768: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2769: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_full_name,'Start of the API');
2770: END IF;
2771:
2772: IF ( p_x_pc_header_rec.LINK_TO_PC_ID IS NULL OR p_x_pc_header_rec.LINK_TO_PC_ID = 0 )

Line 2769: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_full_name,'Start of the API');

2765:
2766: x_return_status := FND_API.G_RET_STS_SUCCESS;
2767:
2768: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2769: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_full_name,'Start of the API');
2770: END IF;
2771:
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

Line 2801: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2797: -- AJPRASAN:: Bug #9596384 : Added the following 'IF' condition and enable the commented code
2798: IF ( UPPER(p_x_pc_header_rec.bue_flag) = 'Y' ) THEN
2799: -- SATHAPLI::Bug# 6504069, 26-Mar-2008
2800: -- get all the applicable MRs for the linked (old) PC
2801: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2802: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
2803: ' p_x_pc_header_rec.LINK_TO_PC_ID => '||p_x_pc_header_rec.LINK_TO_PC_ID);
2804: END IF;
2805:

Line 2802: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,

2798: IF ( UPPER(p_x_pc_header_rec.bue_flag) = 'Y' ) THEN
2799: -- SATHAPLI::Bug# 6504069, 26-Mar-2008
2800: -- get all the applicable MRs for the linked (old) PC
2801: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2802: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
2803: ' p_x_pc_header_rec.LINK_TO_PC_ID => '||p_x_pc_header_rec.LINK_TO_PC_ID);
2804: END IF;
2805:
2806: OPEN get_mr_for_pc_csr(p_x_pc_header_rec.LINK_TO_PC_ID);

Line 2828: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2824: x_mr_item_inst_tbl => l_mr_item_inst_tbl);
2825:
2826: -- check for the return status
2827: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2828: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2829: FND_LOG.string(FND_LOG.level_statement,l_full_name,
2830: 'Raising exception with x_return_status => '||x_return_status);
2831: END IF;
2832: RAISE FND_API.G_EXC_ERROR;

Line 2829: FND_LOG.string(FND_LOG.level_statement,l_full_name,

2825:
2826: -- check for the return status
2827: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2828: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2829: FND_LOG.string(FND_LOG.level_statement,l_full_name,
2830: 'Raising exception with x_return_status => '||x_return_status);
2831: END IF;
2832: RAISE FND_API.G_EXC_ERROR;
2833: END IF;

Line 2847: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2843: CLOSE get_mr_for_pc_csr;
2844:
2845: -- put all the applicable instances for the linked PC in the debug logs
2846: indx := l_link_mr_item_inst_tbl.FIRST;
2847: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2848: WHILE indx IS NOT NULL LOOP
2849: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
2850: ' l_link_mr_item_inst_tbl indx, item_instance_id => '||indx||
2851: ' ,'||l_link_mr_item_inst_tbl(indx));

Line 2849: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,

2845: -- put all the applicable instances for the linked PC in the debug logs
2846: indx := l_link_mr_item_inst_tbl.FIRST;
2847: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2848: WHILE indx IS NOT NULL LOOP
2849: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
2850: ' l_link_mr_item_inst_tbl indx, item_instance_id => '||indx||
2851: ' ,'||l_link_mr_item_inst_tbl(indx));
2852: indx := l_link_mr_item_inst_tbl.NEXT(indx);
2853: END LOOP;

Line 2871: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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;
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:

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 2890: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2886: x_warning_msg_data => x_warning_msg_data
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:

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 2896: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2892: 'Returned from UPDATE_PC_HEADER with x_return_status = ' || x_return_status);
2893: END IF;
2894:
2895:
2896: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2897: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
2898: ' Updated linked-to PC');
2899: END IF;
2900:

Line 2897: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,

2893: END IF;
2894:
2895:
2896: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2897: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
2898: ' Updated linked-to PC');
2899: END IF;
2900:
2901: l_nodeCtr := 0;

Line 2904: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2900:
2901: l_nodeCtr := 0;
2902:
2903: -- Begin -- DELETE
2904: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2905: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
2906: ' Starting DELETE-'||l_pc_header_rec.PC_HEADER_ID);
2907: END IF;
2908:

Line 2905: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,

2901: l_nodeCtr := 0;
2902:
2903: -- Begin -- DELETE
2904: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2905: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
2906: ' Starting DELETE-'||l_pc_header_rec.PC_HEADER_ID);
2907: END IF;
2908:
2909: --delink before attach as the attached nodes also appear in the detach query due to id and no link id

Line 2916: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2912: LOOP
2913: FETCH detach_nodes INTO l_node_data_rec_det;
2914: EXIT WHEN detach_nodes%NOTFOUND;
2915:
2916: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2917: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
2918: ' Starting DELETEING record -- '||l_node_data_rec_det.PC_NODE_ID);
2919: END IF;
2920:

Line 2917: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,

2913: FETCH detach_nodes INTO l_node_data_rec_det;
2914: EXIT WHEN detach_nodes%NOTFOUND;
2915:
2916: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2917: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
2918: ' Starting DELETEING record -- '||l_node_data_rec_det.PC_NODE_ID);
2919: END IF;
2920:
2921: IF l_node_data_rec_det.node_type = G_NODE

Line 2965: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2961: END IF;
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:

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 3003: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2999:
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:

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 3009: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3005: 'Completed detach_associations loop');
3006: END IF;
3007:
3008:
3009: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3010: -- End -- DELETE
3011: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3012: ' Ending DELETE msg_count='||x_msg_count);
3013:

Line 3011: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,

3007:
3008:
3009: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3010: -- End -- DELETE
3011: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3012: ' Ending DELETE msg_count='||x_msg_count);
3013:
3014: -- Begin -- COPY
3015: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,

Line 3015: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,

3011: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3012: ' Ending DELETE msg_count='||x_msg_count);
3013:
3014: -- Begin -- COPY
3015: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3016: ' Starting COPY');
3017: END IF;
3018:
3019: --For bug # 9486654 Fetching Nodes

Line 3025: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3021: LOOP
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);

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 3075: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3071: SELECT OBJECT_VERSION_NUMBER INTO l_node_rec.OBJECT_VERSION_NUMBER
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:

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 3101: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3097: END IF;
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:

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 3122: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3118: l_nodeId_tbl(l_nodeCtr).NODE_ID := l_node_data_rec.PC_NODE_ID;
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:

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 3127: 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
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:

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 3143: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3139: LOOP
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);

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 3190: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3186:
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:

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 3211: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3207: END LOOP;
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:

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 3228: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3224: x_msg_count => x_msg_count,
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'

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 3253: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3249: END LOOP;
3250: CLOSE attach_nodes_units;
3251:
3252:
3253: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3254: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,' Ending COPY');
3255: END IF;
3256: -- End -- COPY
3257:

Line 3254: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,' Ending COPY');

3250: CLOSE attach_nodes_units;
3251:
3252:
3253: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3254: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,' Ending COPY');
3255: END IF;
3256: -- End -- COPY
3257:
3258: -- To associate documents to the Complete version from draft version for new nodes.

Line 3262: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3258: -- To associate documents to the Complete version from draft version for new nodes.
3259: -- Fixed by Senthil for Bug # 3558557 and 3558601
3260:
3261:
3262: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3263: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,' Start of merging Docs');
3264: END IF;
3265:
3266:

Line 3263: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,' Start of merging Docs');

3259: -- Fixed by Senthil for Bug # 3558557 and 3558601
3260:
3261:
3262: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3263: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,' Start of merging Docs');
3264: END IF;
3265:
3266:
3267: SELECT pc_node_id,

Line 3278: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3274: AND NVL(LINK_TO_NODE_ID,0) <> 0
3275: START WITH PARENT_NODE_ID = 0
3276: CONNECT BY PRIOR PC_NODE_ID = PARENT_NODE_ID;
3277:
3278: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3279: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,' Docs count'||l_draft_nodeId_tbl.count);
3280: END IF;
3281:
3282:

Line 3279: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,' Docs count'||l_draft_nodeId_tbl.count);

3275: START WITH PARENT_NODE_ID = 0
3276: CONNECT BY PRIOR PC_NODE_ID = PARENT_NODE_ID;
3277:
3278: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3279: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,' Docs count'||l_draft_nodeId_tbl.count);
3280: END IF;
3281:
3282:
3283: -- There is no need to associate documents for newly created nodes of Complete PC b'coz the same

Line 3315: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3311: AND ASO_OBJECT_TYPE_CODE = 'PC';
3312:
3313: END IF;
3314:
3315: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3316: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,' Docs Merge ends');
3317: END IF;
3318:
3319:

Line 3316: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,' Docs Merge ends');

3312:
3313: END IF;
3314:
3315: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
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;

Line 3324: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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
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;

Line 3325: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,' Deleted Header Record');

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
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:

Line 3374: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3370:
3371: -- AJPRASAN:: Bug #9596384 : Added the following 'IF' condition and enable the commented code
3372: IF ( UPPER(p_x_pc_header_rec.bue_flag) = 'Y' ) THEN
3373: -- get all the applicable MRs for the new PC
3374: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3375: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3376: ' p_x_pc_header_rec.PC_HEADER_ID => '||p_x_pc_header_rec.PC_HEADER_ID);
3377: END IF;
3378:

Line 3375: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,

3371: -- AJPRASAN:: Bug #9596384 : Added the following 'IF' condition and enable the commented code
3372: IF ( UPPER(p_x_pc_header_rec.bue_flag) = 'Y' ) THEN
3373: -- get all the applicable MRs for the new PC
3374: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3375: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3376: ' p_x_pc_header_rec.PC_HEADER_ID => '||p_x_pc_header_rec.PC_HEADER_ID);
3377: END IF;
3378:
3379: OPEN get_mr_for_pc_csr(p_x_pc_header_rec.PC_HEADER_ID);

Line 3401: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

3397: x_mr_item_inst_tbl => l_mr_item_inst_tbl);
3398:
3399: -- check for the return status
3400: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3401: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3402: FND_LOG.string(FND_LOG.level_statement,l_full_name,
3403: 'Raising exception with x_return_status => '||x_return_status);
3404: END IF;
3405: RAISE FND_API.G_EXC_ERROR;

Line 3402: FND_LOG.string(FND_LOG.level_statement,l_full_name,

3398:
3399: -- check for the return status
3400: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3401: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3402: FND_LOG.string(FND_LOG.level_statement,l_full_name,
3403: 'Raising exception with x_return_status => '||x_return_status);
3404: END IF;
3405: RAISE FND_API.G_EXC_ERROR;
3406: END IF;

Line 3420: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3416: CLOSE get_mr_for_pc_csr;
3417:
3418: -- put all the applicable instances for the new PC in the debug logs
3419: indx := l_new_mr_item_inst_tbl.FIRST;
3420: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3421: WHILE indx IS NOT NULL LOOP
3422: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3423: ' l_new_mr_item_inst_tbl indx, item_instance_id => '||indx||
3424: ' ,'||l_new_mr_item_inst_tbl(indx));

Line 3422: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,

3418: -- put all the applicable instances for the new PC in the debug logs
3419: indx := l_new_mr_item_inst_tbl.FIRST;
3420: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3421: WHILE indx IS NOT NULL LOOP
3422: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3423: ' l_new_mr_item_inst_tbl indx, item_instance_id => '||indx||
3424: ' ,'||l_new_mr_item_inst_tbl(indx));
3425: indx := l_new_mr_item_inst_tbl.NEXT(indx);
3426: END LOOP;

Line 3441: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3437:
3438: indx := l_link_mr_item_inst_tbl.NEXT(indx);
3439: END LOOP;
3440:
3441: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3442: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3443: ' l_diff_mr_item_inst_tbl.COUNT => '||l_diff_mr_item_inst_tbl.COUNT);
3444: END IF;
3445:

Line 3442: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,

3438: indx := l_link_mr_item_inst_tbl.NEXT(indx);
3439: END LOOP;
3440:
3441: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3442: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3443: ' l_diff_mr_item_inst_tbl.COUNT => '||l_diff_mr_item_inst_tbl.COUNT);
3444: END IF;
3445:
3446: -- put all the top instances of the removed units in the debug logs

Line 3448: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3444: END IF;
3445:
3446: -- put all the top instances of the removed units in the debug logs
3447: indx := l_diff_mr_item_inst_tbl.FIRST;
3448: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3449: WHILE indx IS NOT NULL LOOP
3450: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3451: ' l_diff_mr_item_inst_tbl indx, item_instance_id => '||indx||
3452: ' ,'||l_diff_mr_item_inst_tbl(indx));

Line 3450: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,

3446: -- put all the top instances of the removed units in the debug logs
3447: indx := l_diff_mr_item_inst_tbl.FIRST;
3448: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3449: WHILE indx IS NOT NULL LOOP
3450: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3451: ' l_diff_mr_item_inst_tbl indx, item_instance_id => '||indx||
3452: ' ,'||l_diff_mr_item_inst_tbl(indx));
3453: indx := l_diff_mr_item_inst_tbl.NEXT(indx);
3454: END LOOP;

Line 3461: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3457: -- for each of the top instance of removed units make a call to
3458: -- concurrent program AHLUEFF for recalculating unit effectivities
3459: indx := l_diff_mr_item_inst_tbl.FIRST;
3460: WHILE indx IS NOT NULL LOOP
3461: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3462: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3463: ' Submitting concurrent request to recalculate unit effectivities for instance => '||
3464: l_diff_mr_item_inst_tbl(indx));
3465: END IF;

Line 3462: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,

3458: -- concurrent program AHLUEFF for recalculating unit effectivities
3459: indx := l_diff_mr_item_inst_tbl.FIRST;
3460: WHILE indx IS NOT NULL LOOP
3461: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3462: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3463: ' Submitting concurrent request to recalculate unit effectivities for instance => '||
3464: l_diff_mr_item_inst_tbl(indx));
3465: END IF;
3466:

Line 3475: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3471: argument2 => NULL,
3472: argument3 => l_diff_mr_item_inst_tbl(indx));
3473:
3474: IF (l_req_id = 0) THEN
3475: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3477: ' Concurrent request failed.');
3478: END IF;
3479: ELSE

Line 3476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,

3472: argument3 => l_diff_mr_item_inst_tbl(indx));
3473:
3474: IF (l_req_id = 0) THEN
3475: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3477: ' Concurrent request failed.');
3478: END IF;
3479: ELSE
3480: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3480: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3477: ' Concurrent request failed.');
3478: END IF;
3479: ELSE
3480: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3481: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3482: ' Concurrent request successful.');
3483: END IF;
3484: END IF;

Line 3481: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,

3477: ' Concurrent request failed.');
3478: END IF;
3479: ELSE
3480: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3481: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3482: ' Concurrent request successful.');
3483: END IF;
3484: END IF;
3485:

Line 3492: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3488:
3489: --FND_MSG_PUB.Add;
3490: -- make a call to the concurrent program AHLPCUEFF to calculate unit
3491: -- effectivities for the new PC
3492: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3493: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3494: ' Submitting concurrent request to calculate unit effectivities for pc_header_id => '||
3495: p_x_pc_header_rec.PC_HEADER_ID);
3496: END IF;

Line 3493: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,

3489: --FND_MSG_PUB.Add;
3490: -- make a call to the concurrent program AHLPCUEFF to calculate unit
3491: -- effectivities for the new PC
3492: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3493: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3494: ' Submitting concurrent request to calculate unit effectivities for pc_header_id => '||
3495: p_x_pc_header_rec.PC_HEADER_ID);
3496: END IF;
3497:

Line 3505: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3501: argument1 => 1.0,
3502: argument2 => p_x_pc_header_rec.PC_HEADER_ID);
3503:
3504: IF (l_req_id = 0) THEN
3505: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3506: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3507: ' Concurrent request failed.');
3508: END IF;
3509: ELSE

Line 3506: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,

3502: argument2 => p_x_pc_header_rec.PC_HEADER_ID);
3503:
3504: IF (l_req_id = 0) THEN
3505: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3506: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3507: ' Concurrent request failed.');
3508: END IF;
3509: ELSE
3510: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3510: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3506: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3507: ' Concurrent request failed.');
3508: END IF;
3509: ELSE
3510: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3511: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3512: ' Concurrent request successful.');
3513: END IF;
3514: END IF;

Line 3511: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,

3507: ' Concurrent request failed.');
3508: END IF;
3509: ELSE
3510: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3511: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
3512: ' Concurrent request successful.');
3513: END IF;
3514: END IF;
3515:

Line 3518: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3514: END IF;
3515:
3516: END IF; -- Ending 'IF' for BUE_FLAG
3517:
3518: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3519: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_full_name,'End of the API');
3520: END IF;
3521:
3522: END REMOVE_LINK;

Line 3519: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_full_name,'End of the API');

3515:
3516: END IF; -- Ending 'IF' for BUE_FLAG
3517:
3518: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3519: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_full_name,'End of the API');
3520: END IF;
3521:
3522: END REMOVE_LINK;
3523: