176: p_cost_type_id => p_header_rec.cost_type_id,
177: p_cost_cmpntcls_id => p_dtl_tbl(i).cost_cmpntcls_id,
178: p_cost_analysis_code => p_dtl_tbl(i).cost_analysis_code
179: ) THEN
180: FND_MESSAGE.SET_NAME('GMF','GMF_API_DUPLICATE_BRDN_COST');
181: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
182: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
183: FND_MESSAGE.SET_TOKEN('RESOURCES',p_dtl_tbl(i).resources);
184: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
177: p_cost_cmpntcls_id => p_dtl_tbl(i).cost_cmpntcls_id,
178: p_cost_analysis_code => p_dtl_tbl(i).cost_analysis_code
179: ) THEN
180: FND_MESSAGE.SET_NAME('GMF','GMF_API_DUPLICATE_BRDN_COST');
181: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
182: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
183: FND_MESSAGE.SET_TOKEN('RESOURCES',p_dtl_tbl(i).resources);
184: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
185: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
178: p_cost_analysis_code => p_dtl_tbl(i).cost_analysis_code
179: ) THEN
180: FND_MESSAGE.SET_NAME('GMF','GMF_API_DUPLICATE_BRDN_COST');
181: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
182: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
183: FND_MESSAGE.SET_TOKEN('RESOURCES',p_dtl_tbl(i).resources);
184: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
185: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
186: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_dtl_tbl(i).cost_cmpntcls_id);
179: ) THEN
180: FND_MESSAGE.SET_NAME('GMF','GMF_API_DUPLICATE_BRDN_COST');
181: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
182: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
183: FND_MESSAGE.SET_TOKEN('RESOURCES',p_dtl_tbl(i).resources);
184: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
185: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
186: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_dtl_tbl(i).cost_cmpntcls_id);
187: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_dtl_tbl(i).cost_analysis_code);
180: FND_MESSAGE.SET_NAME('GMF','GMF_API_DUPLICATE_BRDN_COST');
181: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
182: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
183: FND_MESSAGE.SET_TOKEN('RESOURCES',p_dtl_tbl(i).resources);
184: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
185: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
186: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_dtl_tbl(i).cost_cmpntcls_id);
187: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_dtl_tbl(i).cost_analysis_code);
188: FND_MSG_PUB.Add;
181: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
182: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
183: FND_MESSAGE.SET_TOKEN('RESOURCES',p_dtl_tbl(i).resources);
184: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
185: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
186: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_dtl_tbl(i).cost_cmpntcls_id);
187: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_dtl_tbl(i).cost_analysis_code);
188: FND_MSG_PUB.Add;
189: RAISE FND_API.G_EXC_ERROR;
182: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header_rec.inventory_item_id);
183: FND_MESSAGE.SET_TOKEN('RESOURCES',p_dtl_tbl(i).resources);
184: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
185: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
186: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_dtl_tbl(i).cost_cmpntcls_id);
187: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_dtl_tbl(i).cost_analysis_code);
188: FND_MSG_PUB.Add;
189: RAISE FND_API.G_EXC_ERROR;
190: END IF;
183: FND_MESSAGE.SET_TOKEN('RESOURCES',p_dtl_tbl(i).resources);
184: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
185: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
186: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_dtl_tbl(i).cost_cmpntcls_id);
187: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_dtl_tbl(i).cost_analysis_code);
188: FND_MSG_PUB.Add;
189: RAISE FND_API.G_EXC_ERROR;
190: END IF;
191:
278:
279: EXCEPTION
280: WHEN OTHERS THEN
281: x_burdenline_ids.delete ;
282: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_INSERT_FAILED');
283: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
284: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
285: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
286: FND_MSG_PUB.Add;
279: EXCEPTION
280: WHEN OTHERS THEN
281: x_burdenline_ids.delete ;
282: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_INSERT_FAILED');
283: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
284: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
285: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
286: FND_MSG_PUB.Add;
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
280: WHEN OTHERS THEN
281: x_burdenline_ids.delete ;
282: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_INSERT_FAILED');
283: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
284: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
285: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
286: FND_MSG_PUB.Add;
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
288: RAISE ;
281: x_burdenline_ids.delete ;
282: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_INSERT_FAILED');
283: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
284: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
285: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
286: FND_MSG_PUB.Add;
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
288: RAISE ;
289: END ;
496: END IF ;
497:
498: IF SQL%NOTFOUND THEN -- burden details not found
499: IF p_dtl_tbl(i).delete_mark = 0 THEN
500: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_NOT_FOUND_FOR_ID');
501: FND_MESSAGE.SET_TOKEN('BURDENLINE_ID', p_dtl_tbl(i).burdenline_id);
502: FND_MSG_PUB.Add;
503: ELSE
504: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_BRDN_NOT_FOUND_ID');
497:
498: IF SQL%NOTFOUND THEN -- burden details not found
499: IF p_dtl_tbl(i).delete_mark = 0 THEN
500: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_NOT_FOUND_FOR_ID');
501: FND_MESSAGE.SET_TOKEN('BURDENLINE_ID', p_dtl_tbl(i).burdenline_id);
502: FND_MSG_PUB.Add;
503: ELSE
504: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_BRDN_NOT_FOUND_ID');
505: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID', p_dtl_tbl(i).burdenline_id);
500: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_NOT_FOUND_FOR_ID');
501: FND_MESSAGE.SET_TOKEN('BURDENLINE_ID', p_dtl_tbl(i).burdenline_id);
502: FND_MSG_PUB.Add;
503: ELSE
504: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_BRDN_NOT_FOUND_ID');
505: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID', p_dtl_tbl(i).burdenline_id);
506: FND_MSG_PUB.Add;
507: END IF ;
508: x_return_status := FND_API.G_RET_STS_ERROR ;
501: FND_MESSAGE.SET_TOKEN('BURDENLINE_ID', p_dtl_tbl(i).burdenline_id);
502: FND_MSG_PUB.Add;
503: ELSE
504: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_BRDN_NOT_FOUND_ID');
505: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID', p_dtl_tbl(i).burdenline_id);
506: FND_MSG_PUB.Add;
507: END IF ;
508: x_return_status := FND_API.G_RET_STS_ERROR ;
509: EXIT ;
600:
601:
602: IF SQL%NOTFOUND THEN -- burden details not found
603: IF p_dtl_tbl(i).delete_mark = 0 THEN
604: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_NOT_FOUND_FOR_DTL');
605: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
606: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
607: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
608: FND_MSG_PUB.Add;
601:
602: IF SQL%NOTFOUND THEN -- burden details not found
603: IF p_dtl_tbl(i).delete_mark = 0 THEN
604: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_NOT_FOUND_FOR_DTL');
605: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
606: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
607: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
608: FND_MSG_PUB.Add;
609: ELSE
602: IF SQL%NOTFOUND THEN -- burden details not found
603: IF p_dtl_tbl(i).delete_mark = 0 THEN
604: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_NOT_FOUND_FOR_DTL');
605: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
606: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
607: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
608: FND_MSG_PUB.Add;
609: ELSE
610: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_BRDN_NOT_FOUND_DTL');
603: IF p_dtl_tbl(i).delete_mark = 0 THEN
604: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_NOT_FOUND_FOR_DTL');
605: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
606: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
607: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
608: FND_MSG_PUB.Add;
609: ELSE
610: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_BRDN_NOT_FOUND_DTL');
611: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
606: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
607: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
608: FND_MSG_PUB.Add;
609: ELSE
610: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_BRDN_NOT_FOUND_DTL');
611: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
612: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
613: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
614: FND_MSG_PUB.Add;
607: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
608: FND_MSG_PUB.Add;
609: ELSE
610: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_BRDN_NOT_FOUND_DTL');
611: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
612: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
613: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
614: FND_MSG_PUB.Add;
615: END IF ;
608: FND_MSG_PUB.Add;
609: ELSE
610: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_BRDN_NOT_FOUND_DTL');
611: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
612: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
613: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
614: FND_MSG_PUB.Add;
615: END IF ;
616: x_return_status := FND_API.G_RET_STS_ERROR ;
609: ELSE
610: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_BRDN_NOT_FOUND_DTL');
611: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
612: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
613: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
614: FND_MSG_PUB.Add;
615: END IF ;
616: x_return_status := FND_API.G_RET_STS_ERROR ;
617: EXIT ;
637: WHEN OTHERS THEN
638: IF p_dtl_tbl(i).delete_mark = 0 THEN -- Update
639: IF (p_dtl_tbl(i).burdenline_id IS NOT NULL) OR -- burdenline_id is sent
640: (p_dtl_tbl(i).burdenline_id <> FND_API.G_MISS_NUM) THEN
641: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_UPD_FAILED_ID');
642: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID','Burdenline Id ' || p_dtl_tbl(i).burdenline_id);
643: FND_MSG_PUB.Add;
644: ELSE
645: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_UPD_FAILED_DTLS');
638: IF p_dtl_tbl(i).delete_mark = 0 THEN -- Update
639: IF (p_dtl_tbl(i).burdenline_id IS NOT NULL) OR -- burdenline_id is sent
640: (p_dtl_tbl(i).burdenline_id <> FND_API.G_MISS_NUM) THEN
641: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_UPD_FAILED_ID');
642: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID','Burdenline Id ' || p_dtl_tbl(i).burdenline_id);
643: FND_MSG_PUB.Add;
644: ELSE
645: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_UPD_FAILED_DTLS');
646: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
641: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_UPD_FAILED_ID');
642: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID','Burdenline Id ' || p_dtl_tbl(i).burdenline_id);
643: FND_MSG_PUB.Add;
644: ELSE
645: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_UPD_FAILED_DTLS');
646: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
647: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
648: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
649: FND_MSG_PUB.Add;
642: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID','Burdenline Id ' || p_dtl_tbl(i).burdenline_id);
643: FND_MSG_PUB.Add;
644: ELSE
645: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_UPD_FAILED_DTLS');
646: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
647: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
648: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
649: FND_MSG_PUB.Add;
650: END IF ;
643: FND_MSG_PUB.Add;
644: ELSE
645: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_UPD_FAILED_DTLS');
646: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
647: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
648: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
649: FND_MSG_PUB.Add;
650: END IF ;
651: ELSE -- delete
644: ELSE
645: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_UPD_FAILED_DTLS');
646: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
647: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
648: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
649: FND_MSG_PUB.Add;
650: END IF ;
651: ELSE -- delete
652: IF (p_dtl_tbl(i).burdenline_id IS NOT NULL) OR -- burdenline_id is sent
650: END IF ;
651: ELSE -- delete
652: IF (p_dtl_tbl(i).burdenline_id IS NOT NULL) OR -- burdenline_id is sent
653: (p_dtl_tbl(i).burdenline_id <> FND_API.G_MISS_NUM) THEN
654: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_DEL_FAILED_ID');
655: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID','Burdenline Id ' || p_dtl_tbl(i).burdenline_id);
656: FND_MSG_PUB.Add;
657: ELSE
658: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_DEL_FAILED_DTLS');
651: ELSE -- delete
652: IF (p_dtl_tbl(i).burdenline_id IS NOT NULL) OR -- burdenline_id is sent
653: (p_dtl_tbl(i).burdenline_id <> FND_API.G_MISS_NUM) THEN
654: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_DEL_FAILED_ID');
655: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID','Burdenline Id ' || p_dtl_tbl(i).burdenline_id);
656: FND_MSG_PUB.Add;
657: ELSE
658: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_DEL_FAILED_DTLS');
659: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
654: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_DEL_FAILED_ID');
655: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID','Burdenline Id ' || p_dtl_tbl(i).burdenline_id);
656: FND_MSG_PUB.Add;
657: ELSE
658: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_DEL_FAILED_DTLS');
659: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
660: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
661: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
662: FND_MSG_PUB.Add;
655: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID','Burdenline Id ' || p_dtl_tbl(i).burdenline_id);
656: FND_MSG_PUB.Add;
657: ELSE
658: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_DEL_FAILED_DTLS');
659: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
660: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
661: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
662: FND_MSG_PUB.Add;
663: END IF ;
656: FND_MSG_PUB.Add;
657: ELSE
658: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_DEL_FAILED_DTLS');
659: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
660: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
661: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
662: FND_MSG_PUB.Add;
663: END IF ;
664: END IF ;
657: ELSE
658: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_DEL_FAILED_DTLS');
659: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
660: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
661: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
662: FND_MSG_PUB.Add;
663: END IF ;
664: END IF ;
665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
991: IS
992: BEGIN
993:
994: -- IF FND_MSG_PUB.Check_Msg_Level (p_msg_lvl) THEN -- Bug 2659435
995: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');
996: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
997: FND_MSG_PUB.Add;
998: -- END IF;
999:
992: BEGIN
993:
994: -- IF FND_MSG_PUB.Check_Msg_Level (p_msg_lvl) THEN -- Bug 2659435
995: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');
996: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
997: FND_MSG_PUB.Add;
998: -- END IF;
999:
1000: END log_msg ;