265: );
266: END IF;
267: EXCEPTION
268: WHEN OTHERS THEN
269: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_INS_FAILED');
270: FND_MESSAGE.SET_TOKEN('ITEM', p_header_rec.item_id);
271: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY', p_header_rec.legal_entity_id);
272: FND_MESSAGE.SET_TOKEN('ORGANIZATION', p_header_rec.organization_id);
273: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_type_id);
266: END IF;
267: EXCEPTION
268: WHEN OTHERS THEN
269: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_INS_FAILED');
270: FND_MESSAGE.SET_TOKEN('ITEM', p_header_rec.item_id);
271: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY', p_header_rec.legal_entity_id);
272: FND_MESSAGE.SET_TOKEN('ORGANIZATION', p_header_rec.organization_id);
273: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_type_id);
274: FND_MESSAGE.SET_TOKEN('LOT', p_header_rec.lot_number);
267: EXCEPTION
268: WHEN OTHERS THEN
269: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_INS_FAILED');
270: FND_MESSAGE.SET_TOKEN('ITEM', p_header_rec.item_id);
271: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY', p_header_rec.legal_entity_id);
272: FND_MESSAGE.SET_TOKEN('ORGANIZATION', p_header_rec.organization_id);
273: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_type_id);
274: FND_MESSAGE.SET_TOKEN('LOT', p_header_rec.lot_number);
275: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_DATE', p_header_rec.adjustment_date);
268: WHEN OTHERS THEN
269: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_INS_FAILED');
270: FND_MESSAGE.SET_TOKEN('ITEM', p_header_rec.item_id);
271: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY', p_header_rec.legal_entity_id);
272: FND_MESSAGE.SET_TOKEN('ORGANIZATION', p_header_rec.organization_id);
273: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_type_id);
274: FND_MESSAGE.SET_TOKEN('LOT', p_header_rec.lot_number);
275: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_DATE', p_header_rec.adjustment_date);
276: FND_MSG_PUB.Add;
269: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_INS_FAILED');
270: FND_MESSAGE.SET_TOKEN('ITEM', p_header_rec.item_id);
271: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY', p_header_rec.legal_entity_id);
272: FND_MESSAGE.SET_TOKEN('ORGANIZATION', p_header_rec.organization_id);
273: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_type_id);
274: FND_MESSAGE.SET_TOKEN('LOT', p_header_rec.lot_number);
275: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_DATE', p_header_rec.adjustment_date);
276: FND_MSG_PUB.Add;
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
270: FND_MESSAGE.SET_TOKEN('ITEM', p_header_rec.item_id);
271: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY', p_header_rec.legal_entity_id);
272: FND_MESSAGE.SET_TOKEN('ORGANIZATION', p_header_rec.organization_id);
273: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_type_id);
274: FND_MESSAGE.SET_TOKEN('LOT', p_header_rec.lot_number);
275: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_DATE', p_header_rec.adjustment_date);
276: FND_MSG_PUB.Add;
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: RAISE ;
271: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY', p_header_rec.legal_entity_id);
272: FND_MESSAGE.SET_TOKEN('ORGANIZATION', p_header_rec.organization_id);
273: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_type_id);
274: FND_MESSAGE.SET_TOKEN('LOT', p_header_rec.lot_number);
275: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_DATE', p_header_rec.adjustment_date);
276: FND_MSG_PUB.Add;
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: RAISE ;
279: END;
345: );
346: END IF;
347: EXCEPTION
348: WHEN OTHERS THEN
349: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_DTL_INS_FAILED');
350: FND_MESSAGE.SET_TOKEN('COMPONENT_CLASS', p_dtl_tbl(i).cost_cmpntcls_id);
351: FND_MESSAGE.SET_TOKEN('ANALYSIS_CODE', p_dtl_tbl(i).cost_analysis_code);
352: FND_MSG_PUB.Add;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
346: END IF;
347: EXCEPTION
348: WHEN OTHERS THEN
349: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_DTL_INS_FAILED');
350: FND_MESSAGE.SET_TOKEN('COMPONENT_CLASS', p_dtl_tbl(i).cost_cmpntcls_id);
351: FND_MESSAGE.SET_TOKEN('ANALYSIS_CODE', p_dtl_tbl(i).cost_analysis_code);
352: FND_MSG_PUB.Add;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
354: RAISE ;
347: EXCEPTION
348: WHEN OTHERS THEN
349: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_DTL_INS_FAILED');
350: FND_MESSAGE.SET_TOKEN('COMPONENT_CLASS', p_dtl_tbl(i).cost_cmpntcls_id);
351: FND_MESSAGE.SET_TOKEN('ANALYSIS_CODE', p_dtl_tbl(i).cost_analysis_code);
352: FND_MSG_PUB.Add;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
354: RAISE ;
355: END ;
494: log_msg ( SQL%ROWCOUNT || 'Detail Record Updated for Adjustment Detail Id ' || p_dtl_tbl(i).adjustment_dtl_id );
495: END IF;
496: EXCEPTION
497: WHEN OTHERS THEN
498: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_DTL_ID_UPD_FAILED');
499: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_DTL_ID', p_dtl_tbl(i).adjustment_dtl_id);
500: FND_MSG_PUB.Add;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
502: RAISE ;
495: END IF;
496: EXCEPTION
497: WHEN OTHERS THEN
498: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_DTL_ID_UPD_FAILED');
499: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_DTL_ID', p_dtl_tbl(i).adjustment_dtl_id);
500: FND_MSG_PUB.Add;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
502: RAISE ;
503: END ;
643: log_msg ( SQL%ROWCOUNT || ' Detail Record(s) deleted for Adjustment Detail Id ' || p_dtl_tbl(i).adjustment_dtl_id);
644: END IF;
645: EXCEPTION
646: WHEN OTHERS THEN
647: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_DTL_ID_DEL_FAILED');
648: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_ID', p_dtl_tbl(i).adjustment_dtl_id);
649: FND_MSG_PUB.Add;
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
651: RAISE ;
644: END IF;
645: EXCEPTION
646: WHEN OTHERS THEN
647: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_DTL_ID_DEL_FAILED');
648: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_ID', p_dtl_tbl(i).adjustment_dtl_id);
649: FND_MSG_PUB.Add;
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
651: RAISE ;
652: END ;
686: DELETE gmf_lot_cost_adjustments
687: WHERE adjustment_id = p_header_Rec.adjustment_id
688: AND nvl(applied_ind,'N') <> 'Y';
689: IF SQL%NOTFOUND THEN
690: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_DEL_FAILED');
691: FND_MESSAGE.SET_TOKEN('ITEM', p_header_rec.item_id);
692: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY', p_header_rec.legal_entity_id);
693: FND_MESSAGE.SET_TOKEN('ORGANIZATION', p_header_rec.organization_id);
694: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_type_id);
687: WHERE adjustment_id = p_header_Rec.adjustment_id
688: AND nvl(applied_ind,'N') <> 'Y';
689: IF SQL%NOTFOUND THEN
690: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_DEL_FAILED');
691: FND_MESSAGE.SET_TOKEN('ITEM', p_header_rec.item_id);
692: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY', p_header_rec.legal_entity_id);
693: FND_MESSAGE.SET_TOKEN('ORGANIZATION', p_header_rec.organization_id);
694: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_type_id);
695: FND_MESSAGE.SET_TOKEN('LOT', p_header_rec.lot_number);
688: AND nvl(applied_ind,'N') <> 'Y';
689: IF SQL%NOTFOUND THEN
690: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_DEL_FAILED');
691: FND_MESSAGE.SET_TOKEN('ITEM', p_header_rec.item_id);
692: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY', p_header_rec.legal_entity_id);
693: FND_MESSAGE.SET_TOKEN('ORGANIZATION', p_header_rec.organization_id);
694: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_type_id);
695: FND_MESSAGE.SET_TOKEN('LOT', p_header_rec.lot_number);
696: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_DATE', p_header_rec.adjustment_date);
689: IF SQL%NOTFOUND THEN
690: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_DEL_FAILED');
691: FND_MESSAGE.SET_TOKEN('ITEM', p_header_rec.item_id);
692: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY', p_header_rec.legal_entity_id);
693: FND_MESSAGE.SET_TOKEN('ORGANIZATION', p_header_rec.organization_id);
694: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_type_id);
695: FND_MESSAGE.SET_TOKEN('LOT', p_header_rec.lot_number);
696: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_DATE', p_header_rec.adjustment_date);
697: FND_MSG_PUB.Add;
690: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_DEL_FAILED');
691: FND_MESSAGE.SET_TOKEN('ITEM', p_header_rec.item_id);
692: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY', p_header_rec.legal_entity_id);
693: FND_MESSAGE.SET_TOKEN('ORGANIZATION', p_header_rec.organization_id);
694: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_type_id);
695: FND_MESSAGE.SET_TOKEN('LOT', p_header_rec.lot_number);
696: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_DATE', p_header_rec.adjustment_date);
697: FND_MSG_PUB.Add;
698: x_return_status := FND_API.G_RET_STS_ERROR ;
691: FND_MESSAGE.SET_TOKEN('ITEM', p_header_rec.item_id);
692: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY', p_header_rec.legal_entity_id);
693: FND_MESSAGE.SET_TOKEN('ORGANIZATION', p_header_rec.organization_id);
694: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_type_id);
695: FND_MESSAGE.SET_TOKEN('LOT', p_header_rec.lot_number);
696: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_DATE', p_header_rec.adjustment_date);
697: FND_MSG_PUB.Add;
698: x_return_status := FND_API.G_RET_STS_ERROR ;
699: RAISE FND_API.G_EXC_ERROR;
692: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY', p_header_rec.legal_entity_id);
693: FND_MESSAGE.SET_TOKEN('ORGANIZATION', p_header_rec.organization_id);
694: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_type_id);
695: FND_MESSAGE.SET_TOKEN('LOT', p_header_rec.lot_number);
696: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_DATE', p_header_rec.adjustment_date);
697: FND_MSG_PUB.Add;
698: x_return_status := FND_API.G_RET_STS_ERROR ;
699: RAISE FND_API.G_EXC_ERROR;
700: ELSE
704: END IF ;
705: EXCEPTION
706: WHEN OTHERS THEN
707: IF (p_header_rec.adjustment_id IS NOT NULL) OR (p_header_rec.adjustment_id <> FND_API.G_MISS_NUM) THEN
708: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_DEL_FAILED');
709: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_ID', p_header_rec.adjustment_id);
710: FND_MSG_PUB.Add;
711: END IF ;
712: END;
705: EXCEPTION
706: WHEN OTHERS THEN
707: IF (p_header_rec.adjustment_id IS NOT NULL) OR (p_header_rec.adjustment_id <> FND_API.G_MISS_NUM) THEN
708: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_DEL_FAILED');
709: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_ID', p_header_rec.adjustment_id);
710: FND_MSG_PUB.Add;
711: END IF ;
712: END;
713: ELSE
710: FND_MSG_PUB.Add;
711: END IF ;
712: END;
713: ELSE
714: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_DEL_IGNORE');
715: FND_MESSAGE.SET_TOKEN('ITEM', p_header_rec.item_id);
716: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY', p_header_rec.legal_entity_id);
717: FND_MESSAGE.SET_TOKEN('ORGANIZATION', p_header_rec.organization_id);
718: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_type_id);
711: END IF ;
712: END;
713: ELSE
714: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_DEL_IGNORE');
715: FND_MESSAGE.SET_TOKEN('ITEM', p_header_rec.item_id);
716: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY', p_header_rec.legal_entity_id);
717: FND_MESSAGE.SET_TOKEN('ORGANIZATION', p_header_rec.organization_id);
718: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_type_id);
719: FND_MESSAGE.SET_TOKEN('LOT', p_header_rec.lot_number);
712: END;
713: ELSE
714: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_DEL_IGNORE');
715: FND_MESSAGE.SET_TOKEN('ITEM', p_header_rec.item_id);
716: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY', p_header_rec.legal_entity_id);
717: FND_MESSAGE.SET_TOKEN('ORGANIZATION', p_header_rec.organization_id);
718: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_type_id);
719: FND_MESSAGE.SET_TOKEN('LOT', p_header_rec.lot_number);
720: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_DATE', p_header_rec.adjustment_date);
713: ELSE
714: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_DEL_IGNORE');
715: FND_MESSAGE.SET_TOKEN('ITEM', p_header_rec.item_id);
716: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY', p_header_rec.legal_entity_id);
717: FND_MESSAGE.SET_TOKEN('ORGANIZATION', p_header_rec.organization_id);
718: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_type_id);
719: FND_MESSAGE.SET_TOKEN('LOT', p_header_rec.lot_number);
720: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_DATE', p_header_rec.adjustment_date);
721: FND_MSG_PUB.Add;
714: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_DEL_IGNORE');
715: FND_MESSAGE.SET_TOKEN('ITEM', p_header_rec.item_id);
716: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY', p_header_rec.legal_entity_id);
717: FND_MESSAGE.SET_TOKEN('ORGANIZATION', p_header_rec.organization_id);
718: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_type_id);
719: FND_MESSAGE.SET_TOKEN('LOT', p_header_rec.lot_number);
720: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_DATE', p_header_rec.adjustment_date);
721: FND_MSG_PUB.Add;
722: END IF;
715: FND_MESSAGE.SET_TOKEN('ITEM', p_header_rec.item_id);
716: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY', p_header_rec.legal_entity_id);
717: FND_MESSAGE.SET_TOKEN('ORGANIZATION', p_header_rec.organization_id);
718: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_type_id);
719: FND_MESSAGE.SET_TOKEN('LOT', p_header_rec.lot_number);
720: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_DATE', p_header_rec.adjustment_date);
721: FND_MSG_PUB.Add;
722: END IF;
723:
716: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY', p_header_rec.legal_entity_id);
717: FND_MESSAGE.SET_TOKEN('ORGANIZATION', p_header_rec.organization_id);
718: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_type_id);
719: FND_MESSAGE.SET_TOKEN('LOT', p_header_rec.lot_number);
720: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_DATE', p_header_rec.adjustment_date);
721: FND_MSG_PUB.Add;
722: END IF;
723:
724: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1030: p_msg_text IN VARCHAR2
1031: )
1032: IS
1033: BEGIN
1034: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');
1035: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
1036: FND_MSG_PUB.Add;
1037: END log_msg ;
1038:
1031: )
1032: IS
1033: BEGIN
1034: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');
1035: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
1036: FND_MSG_PUB.Add;
1037: END log_msg ;
1038:
1039: END GMF_LotCostAdjustment_PVT;