79: p_msg_text IN VARCHAR2
80: )
81: IS
82: BEGIN
83: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');
84: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
85: FND_MSG_PUB.Add;
86: END log_msg ;
87: --
80: )
81: IS
82: BEGIN
83: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');
84: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
85: FND_MSG_PUB.Add;
86: END log_msg ;
87: --
88: -- Func start of comments
277: p_cost_cmpntcls_id => p_this_level_dtl_tbl(i).cost_cmpntcls_id,
278: p_cost_analysis_code => p_this_level_dtl_tbl(i).cost_analysis_code,
279: p_cost_level => 0
280: ) THEN
281: FND_MESSAGE.SET_NAME('GMF','GMF_API_DUPLICATE_ITEM_COST');
282: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
283: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
284: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
285: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
278: p_cost_analysis_code => p_this_level_dtl_tbl(i).cost_analysis_code,
279: p_cost_level => 0
280: ) THEN
281: FND_MESSAGE.SET_NAME('GMF','GMF_API_DUPLICATE_ITEM_COST');
282: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
283: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
284: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
285: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
286: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_this_level_dtl_tbl(i).cost_cmpntcls_id);
279: p_cost_level => 0
280: ) THEN
281: FND_MESSAGE.SET_NAME('GMF','GMF_API_DUPLICATE_ITEM_COST');
282: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
283: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
284: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
285: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
286: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_this_level_dtl_tbl(i).cost_cmpntcls_id);
287: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_this_level_dtl_tbl(i).cost_analysis_code);
280: ) THEN
281: FND_MESSAGE.SET_NAME('GMF','GMF_API_DUPLICATE_ITEM_COST');
282: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
283: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
284: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
285: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
286: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_this_level_dtl_tbl(i).cost_cmpntcls_id);
287: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_this_level_dtl_tbl(i).cost_analysis_code);
288: FND_MESSAGE.SET_TOKEN('COST_LEVEL',0);
281: FND_MESSAGE.SET_NAME('GMF','GMF_API_DUPLICATE_ITEM_COST');
282: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
283: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
284: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
285: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
286: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_this_level_dtl_tbl(i).cost_cmpntcls_id);
287: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_this_level_dtl_tbl(i).cost_analysis_code);
288: FND_MESSAGE.SET_TOKEN('COST_LEVEL',0);
289: FND_MSG_PUB.Add;
282: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
283: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
284: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
285: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
286: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_this_level_dtl_tbl(i).cost_cmpntcls_id);
287: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_this_level_dtl_tbl(i).cost_analysis_code);
288: FND_MESSAGE.SET_TOKEN('COST_LEVEL',0);
289: FND_MSG_PUB.Add;
290: RAISE FND_API.G_EXC_ERROR;
283: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
284: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
285: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
286: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_this_level_dtl_tbl(i).cost_cmpntcls_id);
287: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_this_level_dtl_tbl(i).cost_analysis_code);
288: FND_MESSAGE.SET_TOKEN('COST_LEVEL',0);
289: FND_MSG_PUB.Add;
290: RAISE FND_API.G_EXC_ERROR;
291: END IF;
284: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
285: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
286: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_this_level_dtl_tbl(i).cost_cmpntcls_id);
287: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_this_level_dtl_tbl(i).cost_analysis_code);
288: FND_MESSAGE.SET_TOKEN('COST_LEVEL',0);
289: FND_MSG_PUB.Add;
290: RAISE FND_API.G_EXC_ERROR;
291: END IF;
292: /* end duplicate record check */
445:
446: EXCEPTION
447: WHEN OTHERS THEN
448: x_costcmpnt_ids.delete ;
449: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_THISLVL_INS_FAILED');
450: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
451: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
452: FND_MSG_PUB.Add;
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
446: EXCEPTION
447: WHEN OTHERS THEN
448: x_costcmpnt_ids.delete ;
449: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_THISLVL_INS_FAILED');
450: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
451: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
452: FND_MSG_PUB.Add;
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
454: RAISE ;
447: WHEN OTHERS THEN
448: x_costcmpnt_ids.delete ;
449: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_THISLVL_INS_FAILED');
450: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
451: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
452: FND_MSG_PUB.Add;
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
454: RAISE ;
455: END ;
470: p_cost_cmpntcls_id => p_lower_level_dtl_tbl(i).cost_cmpntcls_id,
471: p_cost_analysis_code => p_lower_level_dtl_tbl(i).cost_analysis_code,
472: p_cost_level => 1
473: ) THEN
474: FND_MESSAGE.SET_NAME('GMF','GMF_API_DUPLICATE_ITEM_COST');
475: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
476: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
477: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
478: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
471: p_cost_analysis_code => p_lower_level_dtl_tbl(i).cost_analysis_code,
472: p_cost_level => 1
473: ) THEN
474: FND_MESSAGE.SET_NAME('GMF','GMF_API_DUPLICATE_ITEM_COST');
475: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
476: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
477: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
478: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
479: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
472: p_cost_level => 1
473: ) THEN
474: FND_MESSAGE.SET_NAME('GMF','GMF_API_DUPLICATE_ITEM_COST');
475: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
476: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
477: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
478: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
479: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
480: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_lower_level_dtl_tbl(i).cost_analysis_code);
473: ) THEN
474: FND_MESSAGE.SET_NAME('GMF','GMF_API_DUPLICATE_ITEM_COST');
475: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
476: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
477: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
478: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
479: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
480: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_lower_level_dtl_tbl(i).cost_analysis_code);
481: FND_MESSAGE.SET_TOKEN('COST_LEVEL',1);
474: FND_MESSAGE.SET_NAME('GMF','GMF_API_DUPLICATE_ITEM_COST');
475: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
476: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
477: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
478: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
479: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
480: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_lower_level_dtl_tbl(i).cost_analysis_code);
481: FND_MESSAGE.SET_TOKEN('COST_LEVEL',1);
482: FND_MSG_PUB.Add;
475: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
476: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
477: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
478: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
479: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
480: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_lower_level_dtl_tbl(i).cost_analysis_code);
481: FND_MESSAGE.SET_TOKEN('COST_LEVEL',1);
482: FND_MSG_PUB.Add;
483: RAISE FND_API.G_EXC_ERROR;
476: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
477: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
478: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
479: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
480: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_lower_level_dtl_tbl(i).cost_analysis_code);
481: FND_MESSAGE.SET_TOKEN('COST_LEVEL',1);
482: FND_MSG_PUB.Add;
483: RAISE FND_API.G_EXC_ERROR;
484: END IF;
477: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
478: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
479: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
480: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_lower_level_dtl_tbl(i).cost_analysis_code);
481: FND_MESSAGE.SET_TOKEN('COST_LEVEL',1);
482: FND_MSG_PUB.Add;
483: RAISE FND_API.G_EXC_ERROR;
484: END IF;
485: /* end duplicate record check */
637: x_costcmpnt_ids(l_idx).cmpntcost_id := l_cmpntcost_id ;
638: EXCEPTION
639: WHEN OTHERS THEN
640: x_costcmpnt_ids.delete ;
641: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_LWRLVL_INS_FAILED');
642: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_Tbl(i).cost_cmpntcls_id);
643: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_Tbl(i).cost_analysis_code);
644: FND_MSG_PUB.Add;
645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
638: EXCEPTION
639: WHEN OTHERS THEN
640: x_costcmpnt_ids.delete ;
641: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_LWRLVL_INS_FAILED');
642: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_Tbl(i).cost_cmpntcls_id);
643: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_Tbl(i).cost_analysis_code);
644: FND_MSG_PUB.Add;
645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
646: RAISE ;
639: WHEN OTHERS THEN
640: x_costcmpnt_ids.delete ;
641: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_LWRLVL_INS_FAILED');
642: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_Tbl(i).cost_cmpntcls_id);
643: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_Tbl(i).cost_analysis_code);
644: FND_MSG_PUB.Add;
645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
646: RAISE ;
647: END ;
865: IF SQL%NOTFOUND
866: THEN
867: IF p_this_level_dtl_tbl(i).delete_mark = 0
868: THEN
869: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_ID');
870: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
871: FND_MSG_PUB.Add;
872: ELSE
873: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_ID');
866: THEN
867: IF p_this_level_dtl_tbl(i).delete_mark = 0
868: THEN
869: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_ID');
870: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
871: FND_MSG_PUB.Add;
872: ELSE
873: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_ID');
874: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
869: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_ID');
870: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
871: FND_MSG_PUB.Add;
872: ELSE
873: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_ID');
874: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
875: FND_MSG_PUB.Add;
876: END IF ;
877: x_return_status := FND_API.G_RET_STS_ERROR ;
870: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
871: FND_MSG_PUB.Add;
872: ELSE
873: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_ID');
874: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
875: FND_MSG_PUB.Add;
876: END IF ;
877: x_return_status := FND_API.G_RET_STS_ERROR ;
878: EXIT ;
957: END IF ;
958:
959: IF SQL%NOTFOUND THEN
960: IF p_this_level_dtl_tbl(i).delete_mark = 0 THEN
961: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_DTL');
962: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
963: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
964: FND_MSG_PUB.Add;
965: ELSE
958:
959: IF SQL%NOTFOUND THEN
960: IF p_this_level_dtl_tbl(i).delete_mark = 0 THEN
961: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_DTL');
962: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
963: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
964: FND_MSG_PUB.Add;
965: ELSE
966: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_DTL');
959: IF SQL%NOTFOUND THEN
960: IF p_this_level_dtl_tbl(i).delete_mark = 0 THEN
961: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_DTL');
962: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
963: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
964: FND_MSG_PUB.Add;
965: ELSE
966: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_DTL');
967: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
962: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
963: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
964: FND_MSG_PUB.Add;
965: ELSE
966: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_DTL');
967: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
968: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
969: FND_MSG_PUB.Add;
970: END IF ;
963: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
964: FND_MSG_PUB.Add;
965: ELSE
966: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_DTL');
967: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
968: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
969: FND_MSG_PUB.Add;
970: END IF ;
971: x_return_status := FND_API.G_RET_STS_ERROR ;
964: FND_MSG_PUB.Add;
965: ELSE
966: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_DTL');
967: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
968: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
969: FND_MSG_PUB.Add;
970: END IF ;
971: x_return_status := FND_API.G_RET_STS_ERROR ;
972: EXIT ;
992: IF p_this_level_dtl_tbl(i).delete_mark = 0
993: THEN
994: 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)
995: THEN
996: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_ID');
997: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
998: FND_MSG_PUB.Add;
999: ELSE
1000: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_DTLS');
993: THEN
994: 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)
995: THEN
996: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_ID');
997: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
998: FND_MSG_PUB.Add;
999: ELSE
1000: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_DTLS');
1001: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
996: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_ID');
997: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
998: FND_MSG_PUB.Add;
999: ELSE
1000: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_DTLS');
1001: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
1002: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
1003: FND_MSG_PUB.Add;
1004: END IF ;
997: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
998: FND_MSG_PUB.Add;
999: ELSE
1000: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_DTLS');
1001: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
1002: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
1003: FND_MSG_PUB.Add;
1004: END IF ;
1005: ELSE
998: FND_MSG_PUB.Add;
999: ELSE
1000: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_DTLS');
1001: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
1002: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
1003: FND_MSG_PUB.Add;
1004: END IF ;
1005: ELSE
1006: 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: END IF ;
1005: ELSE
1006: 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)
1007: THEN
1008: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_ID');
1009: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
1010: FND_MSG_PUB.Add;
1011: ELSE
1012: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_DTLS');
1005: ELSE
1006: 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)
1007: THEN
1008: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_ID');
1009: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
1010: FND_MSG_PUB.Add;
1011: ELSE
1012: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_DTLS');
1013: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
1008: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_ID');
1009: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
1010: FND_MSG_PUB.Add;
1011: ELSE
1012: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_DTLS');
1013: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
1014: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
1015: FND_MSG_PUB.Add;
1016: END IF ;
1009: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
1010: FND_MSG_PUB.Add;
1011: ELSE
1012: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_DTLS');
1013: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
1014: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
1015: FND_MSG_PUB.Add;
1016: END IF ;
1017: END IF ;
1010: FND_MSG_PUB.Add;
1011: ELSE
1012: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_DTLS');
1013: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
1014: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
1015: FND_MSG_PUB.Add;
1016: END IF ;
1017: END IF ;
1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1051: IF SQL%NOTFOUND
1052: THEN
1053: IF p_lower_level_dtl_tbl(i).delete_mark = 0
1054: THEN
1055: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_ID');
1056: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1057: FND_MSG_PUB.Add;
1058: ELSE
1059: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_ID');
1052: THEN
1053: IF p_lower_level_dtl_tbl(i).delete_mark = 0
1054: THEN
1055: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_ID');
1056: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1057: FND_MSG_PUB.Add;
1058: ELSE
1059: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_ID');
1060: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1055: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_ID');
1056: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1057: FND_MSG_PUB.Add;
1058: ELSE
1059: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_ID');
1060: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1061: FND_MSG_PUB.Add;
1062: END IF ;
1063: x_return_status := FND_API.G_RET_STS_ERROR ;
1056: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1057: FND_MSG_PUB.Add;
1058: ELSE
1059: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_ID');
1060: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1061: FND_MSG_PUB.Add;
1062: END IF ;
1063: x_return_status := FND_API.G_RET_STS_ERROR ;
1064: EXIT ;
1110: IF SQL%NOTFOUND
1111: THEN
1112: IF p_lower_level_dtl_tbl(i).delete_mark = 0
1113: THEN
1114: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_DTL');
1115: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1116: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1117: FND_MSG_PUB.Add;
1118: ELSE
1111: THEN
1112: IF p_lower_level_dtl_tbl(i).delete_mark = 0
1113: THEN
1114: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_DTL');
1115: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1116: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1117: FND_MSG_PUB.Add;
1118: ELSE
1119: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_DTL');
1112: IF p_lower_level_dtl_tbl(i).delete_mark = 0
1113: THEN
1114: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_DTL');
1115: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1116: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1117: FND_MSG_PUB.Add;
1118: ELSE
1119: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_DTL');
1120: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1115: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1116: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1117: FND_MSG_PUB.Add;
1118: ELSE
1119: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_DTL');
1120: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1121: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1122: FND_MSG_PUB.Add;
1123: END IF ;
1116: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1117: FND_MSG_PUB.Add;
1118: ELSE
1119: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_DTL');
1120: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1121: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1122: FND_MSG_PUB.Add;
1123: END IF ;
1124: x_return_status := FND_API.G_RET_STS_ERROR ;
1117: FND_MSG_PUB.Add;
1118: ELSE
1119: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_DTL');
1120: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1121: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1122: FND_MSG_PUB.Add;
1123: END IF ;
1124: x_return_status := FND_API.G_RET_STS_ERROR ;
1125: EXIT ;
1145: IF p_lower_level_dtl_tbl(i).delete_mark = 0
1146: THEN
1147: 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)
1148: THEN
1149: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_ID');
1150: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1151: FND_MSG_PUB.Add;
1152: ELSE
1153: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_DTLS');
1146: THEN
1147: 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)
1148: THEN
1149: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_ID');
1150: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1151: FND_MSG_PUB.Add;
1152: ELSE
1153: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_DTLS');
1154: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1149: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_ID');
1150: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1151: FND_MSG_PUB.Add;
1152: ELSE
1153: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_DTLS');
1154: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1155: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1156: FND_MSG_PUB.Add;
1157: END IF ;
1150: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1151: FND_MSG_PUB.Add;
1152: ELSE
1153: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_DTLS');
1154: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1155: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1156: FND_MSG_PUB.Add;
1157: END IF ;
1158: ELSE
1151: FND_MSG_PUB.Add;
1152: ELSE
1153: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_DTLS');
1154: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1155: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1156: FND_MSG_PUB.Add;
1157: END IF ;
1158: ELSE
1159: 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: END IF ;
1158: ELSE
1159: 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)
1160: THEN
1161: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_ID');
1162: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1163: FND_MSG_PUB.Add;
1164: ELSE
1165: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_DTLS');
1158: ELSE
1159: 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)
1160: THEN
1161: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_ID');
1162: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1163: FND_MSG_PUB.Add;
1164: ELSE
1165: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_DTLS');
1166: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1161: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_ID');
1162: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1163: FND_MSG_PUB.Add;
1164: ELSE
1165: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_DTLS');
1166: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1167: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1168: FND_MSG_PUB.Add;
1169: END IF ;
1162: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1163: FND_MSG_PUB.Add;
1164: ELSE
1165: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_DTLS');
1166: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1167: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1168: FND_MSG_PUB.Add;
1169: END IF ;
1170: END IF ;
1163: FND_MSG_PUB.Add;
1164: ELSE
1165: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_DTLS');
1166: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1167: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1168: FND_MSG_PUB.Add;
1169: END IF ;
1170: END IF ;
1171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;