76: p_msg_text IN VARCHAR2
77: )
78: IS
79: BEGIN
80: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');
81: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
82: FND_MSG_PUB.Add;
83: END log_msg ;
84: --
77: )
78: IS
79: BEGIN
80: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');
81: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
82: FND_MSG_PUB.Add;
83: END log_msg ;
84: --
85: -- Func start of comments
274: p_cost_cmpntcls_id => p_this_level_dtl_tbl(i).cost_cmpntcls_id,
275: p_cost_analysis_code => p_this_level_dtl_tbl(i).cost_analysis_code,
276: p_cost_level => 0
277: ) THEN
278: FND_MESSAGE.SET_NAME('GMF','GMF_API_DUPLICATE_ITEM_COST');
279: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
280: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
281: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
282: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
275: p_cost_analysis_code => p_this_level_dtl_tbl(i).cost_analysis_code,
276: p_cost_level => 0
277: ) THEN
278: FND_MESSAGE.SET_NAME('GMF','GMF_API_DUPLICATE_ITEM_COST');
279: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
280: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
281: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
282: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
283: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_this_level_dtl_tbl(i).cost_cmpntcls_id);
276: p_cost_level => 0
277: ) THEN
278: FND_MESSAGE.SET_NAME('GMF','GMF_API_DUPLICATE_ITEM_COST');
279: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
280: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
281: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
282: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
283: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_this_level_dtl_tbl(i).cost_cmpntcls_id);
284: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_this_level_dtl_tbl(i).cost_analysis_code);
277: ) THEN
278: FND_MESSAGE.SET_NAME('GMF','GMF_API_DUPLICATE_ITEM_COST');
279: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
280: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
281: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
282: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
283: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_this_level_dtl_tbl(i).cost_cmpntcls_id);
284: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_this_level_dtl_tbl(i).cost_analysis_code);
285: FND_MESSAGE.SET_TOKEN('COST_LEVEL',0);
278: FND_MESSAGE.SET_NAME('GMF','GMF_API_DUPLICATE_ITEM_COST');
279: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
280: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
281: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
282: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
283: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_this_level_dtl_tbl(i).cost_cmpntcls_id);
284: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_this_level_dtl_tbl(i).cost_analysis_code);
285: FND_MESSAGE.SET_TOKEN('COST_LEVEL',0);
286: FND_MSG_PUB.Add;
279: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
280: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
281: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
282: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
283: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_this_level_dtl_tbl(i).cost_cmpntcls_id);
284: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_this_level_dtl_tbl(i).cost_analysis_code);
285: FND_MESSAGE.SET_TOKEN('COST_LEVEL',0);
286: FND_MSG_PUB.Add;
287: RAISE FND_API.G_EXC_ERROR;
280: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
281: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
282: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
283: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_this_level_dtl_tbl(i).cost_cmpntcls_id);
284: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_this_level_dtl_tbl(i).cost_analysis_code);
285: FND_MESSAGE.SET_TOKEN('COST_LEVEL',0);
286: FND_MSG_PUB.Add;
287: RAISE FND_API.G_EXC_ERROR;
288: END IF;
281: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
282: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
283: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_this_level_dtl_tbl(i).cost_cmpntcls_id);
284: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_this_level_dtl_tbl(i).cost_analysis_code);
285: FND_MESSAGE.SET_TOKEN('COST_LEVEL',0);
286: FND_MSG_PUB.Add;
287: RAISE FND_API.G_EXC_ERROR;
288: END IF;
289: /* end duplicate record check */
442:
443: EXCEPTION
444: WHEN OTHERS THEN
445: x_costcmpnt_ids.delete ;
446: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_THISLVL_INS_FAILED');
447: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
448: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
449: FND_MSG_PUB.Add;
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
443: EXCEPTION
444: WHEN OTHERS THEN
445: x_costcmpnt_ids.delete ;
446: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_THISLVL_INS_FAILED');
447: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
448: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
449: FND_MSG_PUB.Add;
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
451: RAISE ;
444: WHEN OTHERS THEN
445: x_costcmpnt_ids.delete ;
446: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_THISLVL_INS_FAILED');
447: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
448: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
449: FND_MSG_PUB.Add;
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
451: RAISE ;
452: END ;
467: p_cost_cmpntcls_id => p_lower_level_dtl_tbl(i).cost_cmpntcls_id,
468: p_cost_analysis_code => p_lower_level_dtl_tbl(i).cost_analysis_code,
469: p_cost_level => 1
470: ) THEN
471: FND_MESSAGE.SET_NAME('GMF','GMF_API_DUPLICATE_ITEM_COST');
472: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
473: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
474: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
475: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
468: p_cost_analysis_code => p_lower_level_dtl_tbl(i).cost_analysis_code,
469: p_cost_level => 1
470: ) THEN
471: FND_MESSAGE.SET_NAME('GMF','GMF_API_DUPLICATE_ITEM_COST');
472: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
473: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
474: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
475: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
476: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
469: p_cost_level => 1
470: ) THEN
471: FND_MESSAGE.SET_NAME('GMF','GMF_API_DUPLICATE_ITEM_COST');
472: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
473: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
474: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
475: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
476: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
477: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_lower_level_dtl_tbl(i).cost_analysis_code);
470: ) THEN
471: FND_MESSAGE.SET_NAME('GMF','GMF_API_DUPLICATE_ITEM_COST');
472: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
473: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
474: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
475: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
476: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
477: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_lower_level_dtl_tbl(i).cost_analysis_code);
478: FND_MESSAGE.SET_TOKEN('COST_LEVEL',1);
471: FND_MESSAGE.SET_NAME('GMF','GMF_API_DUPLICATE_ITEM_COST');
472: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
473: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
474: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
475: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
476: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
477: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_lower_level_dtl_tbl(i).cost_analysis_code);
478: FND_MESSAGE.SET_TOKEN('COST_LEVEL',1);
479: FND_MSG_PUB.Add;
472: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
473: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
474: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
475: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
476: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
477: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_lower_level_dtl_tbl(i).cost_analysis_code);
478: FND_MESSAGE.SET_TOKEN('COST_LEVEL',1);
479: FND_MSG_PUB.Add;
480: RAISE FND_API.G_EXC_ERROR;
473: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
474: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
475: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
476: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
477: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_lower_level_dtl_tbl(i).cost_analysis_code);
478: FND_MESSAGE.SET_TOKEN('COST_LEVEL',1);
479: FND_MSG_PUB.Add;
480: RAISE FND_API.G_EXC_ERROR;
481: END IF;
474: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
475: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
476: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
477: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_lower_level_dtl_tbl(i).cost_analysis_code);
478: FND_MESSAGE.SET_TOKEN('COST_LEVEL',1);
479: FND_MSG_PUB.Add;
480: RAISE FND_API.G_EXC_ERROR;
481: END IF;
482: /* end duplicate record check */
634: x_costcmpnt_ids(l_idx).cmpntcost_id := l_cmpntcost_id ;
635: EXCEPTION
636: WHEN OTHERS THEN
637: x_costcmpnt_ids.delete ;
638: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_LWRLVL_INS_FAILED');
639: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_Tbl(i).cost_cmpntcls_id);
640: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_Tbl(i).cost_analysis_code);
641: FND_MSG_PUB.Add;
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
635: EXCEPTION
636: WHEN OTHERS THEN
637: x_costcmpnt_ids.delete ;
638: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_LWRLVL_INS_FAILED');
639: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_Tbl(i).cost_cmpntcls_id);
640: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_Tbl(i).cost_analysis_code);
641: FND_MSG_PUB.Add;
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
643: RAISE ;
636: WHEN OTHERS THEN
637: x_costcmpnt_ids.delete ;
638: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_LWRLVL_INS_FAILED');
639: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_Tbl(i).cost_cmpntcls_id);
640: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_Tbl(i).cost_analysis_code);
641: FND_MSG_PUB.Add;
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
643: RAISE ;
644: END ;
862: IF SQL%NOTFOUND
863: THEN
864: IF p_this_level_dtl_tbl(i).delete_mark = 0
865: THEN
866: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_ID');
867: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
868: FND_MSG_PUB.Add;
869: ELSE
870: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_ID');
863: THEN
864: IF p_this_level_dtl_tbl(i).delete_mark = 0
865: THEN
866: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_ID');
867: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
868: FND_MSG_PUB.Add;
869: ELSE
870: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_ID');
871: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
866: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_ID');
867: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
868: FND_MSG_PUB.Add;
869: ELSE
870: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_ID');
871: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
872: FND_MSG_PUB.Add;
873: END IF ;
874: x_return_status := FND_API.G_RET_STS_ERROR ;
867: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
868: FND_MSG_PUB.Add;
869: ELSE
870: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_ID');
871: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
872: FND_MSG_PUB.Add;
873: END IF ;
874: x_return_status := FND_API.G_RET_STS_ERROR ;
875: EXIT ;
954: END IF ;
955:
956: IF SQL%NOTFOUND THEN
957: IF p_this_level_dtl_tbl(i).delete_mark = 0 THEN
958: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_DTL');
959: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
960: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
961: FND_MSG_PUB.Add;
962: ELSE
955:
956: IF SQL%NOTFOUND THEN
957: IF p_this_level_dtl_tbl(i).delete_mark = 0 THEN
958: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_DTL');
959: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
960: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
961: FND_MSG_PUB.Add;
962: ELSE
963: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_DTL');
956: IF SQL%NOTFOUND THEN
957: IF p_this_level_dtl_tbl(i).delete_mark = 0 THEN
958: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_DTL');
959: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
960: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
961: FND_MSG_PUB.Add;
962: ELSE
963: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_DTL');
964: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
959: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
960: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
961: FND_MSG_PUB.Add;
962: ELSE
963: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_DTL');
964: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
965: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
966: FND_MSG_PUB.Add;
967: END IF ;
960: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
961: FND_MSG_PUB.Add;
962: ELSE
963: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_DTL');
964: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
965: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
966: FND_MSG_PUB.Add;
967: END IF ;
968: x_return_status := FND_API.G_RET_STS_ERROR ;
961: FND_MSG_PUB.Add;
962: ELSE
963: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_DTL');
964: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
965: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
966: FND_MSG_PUB.Add;
967: END IF ;
968: x_return_status := FND_API.G_RET_STS_ERROR ;
969: EXIT ;
989: IF p_this_level_dtl_tbl(i).delete_mark = 0
990: THEN
991: IF (p_this_level_dtl_tbl(i).cmpntcost_id IS NOT NULL) OR (p_this_level_dtl_tbl(i).cmpntcost_id <> FND_API.G_MISS_NUM)
992: THEN
993: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_ID');
994: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
995: FND_MSG_PUB.Add;
996: ELSE
997: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_DTLS');
990: THEN
991: IF (p_this_level_dtl_tbl(i).cmpntcost_id IS NOT NULL) OR (p_this_level_dtl_tbl(i).cmpntcost_id <> FND_API.G_MISS_NUM)
992: THEN
993: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_ID');
994: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
995: FND_MSG_PUB.Add;
996: ELSE
997: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_DTLS');
998: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
993: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_ID');
994: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
995: FND_MSG_PUB.Add;
996: ELSE
997: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_DTLS');
998: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
999: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
1000: FND_MSG_PUB.Add;
1001: END IF ;
994: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
995: FND_MSG_PUB.Add;
996: ELSE
997: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_DTLS');
998: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
999: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
1000: FND_MSG_PUB.Add;
1001: END IF ;
1002: ELSE
995: FND_MSG_PUB.Add;
996: ELSE
997: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_DTLS');
998: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
999: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
1000: FND_MSG_PUB.Add;
1001: END IF ;
1002: ELSE
1003: IF (p_this_level_dtl_tbl(i).cmpntcost_id IS NOT NULL) OR (p_this_level_dtl_tbl(i).cmpntcost_id <> FND_API.G_MISS_NUM)
1001: END IF ;
1002: ELSE
1003: IF (p_this_level_dtl_tbl(i).cmpntcost_id IS NOT NULL) OR (p_this_level_dtl_tbl(i).cmpntcost_id <> FND_API.G_MISS_NUM)
1004: THEN
1005: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_ID');
1006: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
1007: FND_MSG_PUB.Add;
1008: ELSE
1009: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_DTLS');
1002: ELSE
1003: IF (p_this_level_dtl_tbl(i).cmpntcost_id IS NOT NULL) OR (p_this_level_dtl_tbl(i).cmpntcost_id <> FND_API.G_MISS_NUM)
1004: THEN
1005: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_ID');
1006: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
1007: FND_MSG_PUB.Add;
1008: ELSE
1009: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_DTLS');
1010: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
1005: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_ID');
1006: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
1007: FND_MSG_PUB.Add;
1008: ELSE
1009: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_DTLS');
1010: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
1011: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
1012: FND_MSG_PUB.Add;
1013: END IF ;
1006: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
1007: FND_MSG_PUB.Add;
1008: ELSE
1009: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_DTLS');
1010: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
1011: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
1012: FND_MSG_PUB.Add;
1013: END IF ;
1014: END IF ;
1007: FND_MSG_PUB.Add;
1008: ELSE
1009: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_DTLS');
1010: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
1011: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
1012: FND_MSG_PUB.Add;
1013: END IF ;
1014: END IF ;
1015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1048: IF SQL%NOTFOUND
1049: THEN
1050: IF p_lower_level_dtl_tbl(i).delete_mark = 0
1051: THEN
1052: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_ID');
1053: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1054: FND_MSG_PUB.Add;
1055: ELSE
1056: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_ID');
1049: THEN
1050: IF p_lower_level_dtl_tbl(i).delete_mark = 0
1051: THEN
1052: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_ID');
1053: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1054: FND_MSG_PUB.Add;
1055: ELSE
1056: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_ID');
1057: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1052: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_ID');
1053: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1054: FND_MSG_PUB.Add;
1055: ELSE
1056: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_ID');
1057: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1058: FND_MSG_PUB.Add;
1059: END IF ;
1060: x_return_status := FND_API.G_RET_STS_ERROR ;
1053: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1054: FND_MSG_PUB.Add;
1055: ELSE
1056: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_ID');
1057: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1058: FND_MSG_PUB.Add;
1059: END IF ;
1060: x_return_status := FND_API.G_RET_STS_ERROR ;
1061: EXIT ;
1107: IF SQL%NOTFOUND
1108: THEN
1109: IF p_lower_level_dtl_tbl(i).delete_mark = 0
1110: THEN
1111: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_DTL');
1112: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1113: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1114: FND_MSG_PUB.Add;
1115: ELSE
1108: THEN
1109: IF p_lower_level_dtl_tbl(i).delete_mark = 0
1110: THEN
1111: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_DTL');
1112: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1113: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1114: FND_MSG_PUB.Add;
1115: ELSE
1116: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_DTL');
1109: IF p_lower_level_dtl_tbl(i).delete_mark = 0
1110: THEN
1111: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_DTL');
1112: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1113: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1114: FND_MSG_PUB.Add;
1115: ELSE
1116: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_DTL');
1117: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1112: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1113: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1114: FND_MSG_PUB.Add;
1115: ELSE
1116: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_DTL');
1117: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1118: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1119: FND_MSG_PUB.Add;
1120: END IF ;
1113: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1114: FND_MSG_PUB.Add;
1115: ELSE
1116: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_DTL');
1117: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1118: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1119: FND_MSG_PUB.Add;
1120: END IF ;
1121: x_return_status := FND_API.G_RET_STS_ERROR ;
1114: FND_MSG_PUB.Add;
1115: ELSE
1116: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_DTL');
1117: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1118: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1119: FND_MSG_PUB.Add;
1120: END IF ;
1121: x_return_status := FND_API.G_RET_STS_ERROR ;
1122: EXIT ;
1142: IF p_lower_level_dtl_tbl(i).delete_mark = 0
1143: THEN
1144: IF (p_lower_level_dtl_tbl(i).cmpntcost_id IS NOT NULL) OR (p_lower_level_dtl_tbl(i).cmpntcost_id <> FND_API.G_MISS_NUM)
1145: THEN
1146: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_ID');
1147: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1148: FND_MSG_PUB.Add;
1149: ELSE
1150: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_DTLS');
1143: THEN
1144: IF (p_lower_level_dtl_tbl(i).cmpntcost_id IS NOT NULL) OR (p_lower_level_dtl_tbl(i).cmpntcost_id <> FND_API.G_MISS_NUM)
1145: THEN
1146: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_ID');
1147: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1148: FND_MSG_PUB.Add;
1149: ELSE
1150: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_DTLS');
1151: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1146: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_ID');
1147: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1148: FND_MSG_PUB.Add;
1149: ELSE
1150: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_DTLS');
1151: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1152: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1153: FND_MSG_PUB.Add;
1154: END IF ;
1147: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1148: FND_MSG_PUB.Add;
1149: ELSE
1150: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_DTLS');
1151: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1152: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1153: FND_MSG_PUB.Add;
1154: END IF ;
1155: ELSE
1148: FND_MSG_PUB.Add;
1149: ELSE
1150: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_DTLS');
1151: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1152: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1153: FND_MSG_PUB.Add;
1154: END IF ;
1155: ELSE
1156: IF (p_lower_level_dtl_tbl(i).cmpntcost_id IS NOT NULL) OR (p_lower_level_dtl_tbl(i).cmpntcost_id <> FND_API.G_MISS_NUM)
1154: END IF ;
1155: ELSE
1156: IF (p_lower_level_dtl_tbl(i).cmpntcost_id IS NOT NULL) OR (p_lower_level_dtl_tbl(i).cmpntcost_id <> FND_API.G_MISS_NUM)
1157: THEN
1158: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_ID');
1159: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1160: FND_MSG_PUB.Add;
1161: ELSE
1162: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_DTLS');
1155: ELSE
1156: IF (p_lower_level_dtl_tbl(i).cmpntcost_id IS NOT NULL) OR (p_lower_level_dtl_tbl(i).cmpntcost_id <> FND_API.G_MISS_NUM)
1157: THEN
1158: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_ID');
1159: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1160: FND_MSG_PUB.Add;
1161: ELSE
1162: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_DTLS');
1163: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1158: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_ID');
1159: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1160: FND_MSG_PUB.Add;
1161: ELSE
1162: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_DTLS');
1163: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1164: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1165: FND_MSG_PUB.Add;
1166: END IF ;
1159: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1160: FND_MSG_PUB.Add;
1161: ELSE
1162: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_DTLS');
1163: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1164: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1165: FND_MSG_PUB.Add;
1166: END IF ;
1167: END IF ;
1160: FND_MSG_PUB.Add;
1161: ELSE
1162: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_DTLS');
1163: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1164: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1165: FND_MSG_PUB.Add;
1166: END IF ;
1167: END IF ;
1168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;