231:
232: -- Return if validation failures detected
233: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
234: add_header_to_error_stack(p_header_rec); -- Bug 2659435
235: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
236: FND_MSG_PUB.Add;
237: RAISE FND_API.G_EXC_ERROR;
238: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
239: add_header_to_error_stack(p_header_rec); -- Bug 2659435
236: FND_MSG_PUB.Add;
237: RAISE FND_API.G_EXC_ERROR;
238: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
239: add_header_to_error_stack(p_header_rec); -- Bug 2659435
240: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
241: FND_MSG_PUB.Add;
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;
244: END IF;
268: -- Return if insert fails for any reason
269: IF l_return_status = FND_API.G_RET_STS_ERROR
270: THEN
271: add_header_to_error_stack(l_header_rec); -- Bug 2659435
272: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
273: FND_MSG_PUB.Add;
274: RAISE FND_API.G_EXC_ERROR;
275: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
276: THEN
274: RAISE FND_API.G_EXC_ERROR;
275: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
276: THEN
277: add_header_to_error_stack(l_header_rec); -- Bug 2659435
278: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
279: FND_MSG_PUB.Add;
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281: END IF;
282:
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281: END IF;
282:
283: add_header_to_error_stack(l_header_rec); -- Bug 2659435
284: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_INS');
285: FND_MESSAGE.SET_TOKEN('NUM_ROWS',x_burdenline_ids.count);
286: FND_MSG_PUB.Add;
287: ELSE
288: add_header_to_error_stack(p_header_rec); -- Bug 2659435
281: END IF;
282:
283: add_header_to_error_stack(l_header_rec); -- Bug 2659435
284: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_INS');
285: FND_MESSAGE.SET_TOKEN('NUM_ROWS',x_burdenline_ids.count);
286: FND_MSG_PUB.Add;
287: ELSE
288: add_header_to_error_stack(p_header_rec); -- Bug 2659435
289: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
285: FND_MESSAGE.SET_TOKEN('NUM_ROWS',x_burdenline_ids.count);
286: FND_MSG_PUB.Add;
287: ELSE
288: add_header_to_error_stack(p_header_rec); -- Bug 2659435
289: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
290: FND_MSG_PUB.Add;
291: END IF ;
292:
293: -- Standard check of p_commit.
447:
448: -- Return if validation failures detected
449: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
450: add_header_to_error_stack(p_header_rec); -- Bug 2659435
451: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
452: FND_MSG_PUB.Add;
453: RAISE FND_API.G_EXC_ERROR;
454: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
455: add_header_to_error_stack(p_header_rec); -- Bug 2659435
452: FND_MSG_PUB.Add;
453: RAISE FND_API.G_EXC_ERROR;
454: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
455: add_header_to_error_stack(p_header_rec); -- Bug 2659435
456: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
457: FND_MSG_PUB.Add;
458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
459: END IF;
460: END IF;
481:
482: -- Return if update fails for any reason
483: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
484: add_header_to_error_stack(l_header_rec); -- Bug 2659435
485: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
486: FND_MSG_PUB.Add;
487: RAISE FND_API.G_EXC_ERROR;
488: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
489: add_header_to_error_stack(l_header_rec); -- Bug 2659435
486: FND_MSG_PUB.Add;
487: RAISE FND_API.G_EXC_ERROR;
488: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
489: add_header_to_error_stack(l_header_rec); -- Bug 2659435
490: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
491: FND_MSG_PUB.Add;
492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
493: END IF;
494:
492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
493: END IF;
494:
495: add_header_to_error_stack(l_header_rec); -- Bug 2659435
496: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_UPD');
497: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_dtl_tbl.count);
498: FND_MSG_PUB.Add;
499:
500: ELSE
493: END IF;
494:
495: add_header_to_error_stack(l_header_rec); -- Bug 2659435
496: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_UPD');
497: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_dtl_tbl.count);
498: FND_MSG_PUB.Add;
499:
500: ELSE
501: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
497: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_dtl_tbl.count);
498: FND_MSG_PUB.Add;
499:
500: ELSE
501: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
502: add_header_to_error_stack(p_header_rec); -- Bug 2659435
503: FND_MSG_PUB.Add;
504: END IF ;
505: --log_msg( l_no_rows_upd || ' rows updated.');
664:
665: -- Return if validation failures detected
666: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
667: add_header_to_error_stack(p_header_rec); -- Bug 2659435
668: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
669: FND_MSG_PUB.Add;
670: RAISE FND_API.G_EXC_ERROR;
671: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
672: add_header_to_error_stack(p_header_rec); -- Bug 2659435
669: FND_MSG_PUB.Add;
670: RAISE FND_API.G_EXC_ERROR;
671: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
672: add_header_to_error_stack(p_header_rec); -- Bug 2659435
673: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
674: FND_MSG_PUB.Add;
675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
676: END IF;
677: END IF;
699:
700: -- Return if update fails for any reason
701: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
702: add_header_to_error_stack(l_header_rec); -- Bug 2659435
703: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
704: FND_MSG_PUB.Add;
705: RAISE FND_API.G_EXC_ERROR;
706: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
707: add_header_to_error_stack(l_header_rec); -- Bug 2659435
704: FND_MSG_PUB.Add;
705: RAISE FND_API.G_EXC_ERROR;
706: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
707: add_header_to_error_stack(l_header_rec); -- Bug 2659435
708: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
709: FND_MSG_PUB.Add;
710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
711: END IF;
712:
710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
711: END IF;
712:
713: add_header_to_error_stack(l_header_rec); -- Bug 2659435
714: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_DEL');
715: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_dtl_tbl.count);
716: FND_MSG_PUB.Add;
717:
718: ELSE
711: END IF;
712:
713: add_header_to_error_stack(l_header_rec); -- Bug 2659435
714: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_DEL');
715: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_dtl_tbl.count);
716: FND_MSG_PUB.Add;
717:
718: ELSE
719: add_header_to_error_stack(l_header_rec); -- Bug 2659435
716: FND_MSG_PUB.Add;
717:
718: ELSE
719: add_header_to_error_stack(l_header_rec); -- Bug 2659435
720: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
721: FND_MSG_PUB.Add;
722: END IF ;
723:
724: --log_msg(l_no_rows_del || ' rows deleted.');
869: END IF;
870: IF NOT GMF_VALIDATIONS_PVT.Validate_organization_id(p_header_rec.organization_id)
871: THEN
872: add_header_to_error_stack(p_header_rec); -- Bug 2659435
873: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_ID');
874: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
875: FND_MSG_PUB.Add;
876: RAISE FND_API.G_EXC_ERROR;
877: END IF;
870: IF NOT GMF_VALIDATIONS_PVT.Validate_organization_id(p_header_rec.organization_id)
871: THEN
872: add_header_to_error_stack(p_header_rec); -- Bug 2659435
873: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_ID');
874: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
875: FND_MSG_PUB.Add;
876: RAISE FND_API.G_EXC_ERROR;
877: END IF;
878: -- Log message to ignore if organization_Code is also passed
879: IF (p_header_rec.organization_code <> FND_API.G_MISS_CHAR) AND
880: (p_header_rec.organization_code IS NOT NULL) THEN
881: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
882: add_header_to_error_stack(p_header_rec); -- Bug 2659435
883: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ORGN_CODE');
884: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header_rec.organization_code);
885: FND_MSG_PUB.Add;
886: END IF;
887: END IF;
880: (p_header_rec.organization_code IS NOT NULL) THEN
881: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
882: add_header_to_error_stack(p_header_rec); -- Bug 2659435
883: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ORGN_CODE');
884: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header_rec.organization_code);
885: FND_MSG_PUB.Add;
886: END IF;
887: END IF;
888: -- organization code
894:
895: l_header_rec.organization_id := GMF_VALIDATIONS_PVT.Validate_organization_Code(p_header_rec.organization_code);
896: IF l_header_rec.organization_id IS NULL THEN
897: add_header_to_error_stack(p_header_rec); -- Bug 2659435
898: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_CODE');
899: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header_rec.organization_code);
900: FND_MSG_PUB.Add;
901: RAISE FND_API.G_EXC_ERROR;
902: ELSE
895: l_header_rec.organization_id := GMF_VALIDATIONS_PVT.Validate_organization_Code(p_header_rec.organization_code);
896: IF l_header_rec.organization_id IS NULL THEN
897: add_header_to_error_stack(p_header_rec); -- Bug 2659435
898: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_CODE');
899: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header_rec.organization_code);
900: FND_MSG_PUB.Add;
901: RAISE FND_API.G_EXC_ERROR;
902: ELSE
903: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 5589409, pmarada
905: END IF;
906: END IF;
907: ELSE
908: add_header_to_error_stack(p_header_rec);
909: FND_MESSAGE.SET_NAME('GMF','GMF_API_ORGANIZATION_ID_REQ');
910: FND_MSG_PUB.Add;
911: RAISE FND_API.G_EXC_ERROR;
912: END IF;
913: -- End organization validation
928:
929: IF NOT (GMF_VALIDATIONS_PVT.Validate_inventory_item_Id(p_header_rec.inventory_item_id, p_header_rec.organization_id))
930: THEN
931: add_header_to_error_stack(p_header_rec); -- Bug 2659435
932: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_ID');
933: FND_MESSAGE.SET_TOKEN('ITEM_ID',p_header_rec.inventory_item_id);
934: FND_MSG_PUB.Add;
935: RAISE FND_API.G_EXC_ERROR;
936: END IF;
929: IF NOT (GMF_VALIDATIONS_PVT.Validate_inventory_item_Id(p_header_rec.inventory_item_id, p_header_rec.organization_id))
930: THEN
931: add_header_to_error_stack(p_header_rec); -- Bug 2659435
932: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_ID');
933: FND_MESSAGE.SET_TOKEN('ITEM_ID',p_header_rec.inventory_item_id);
934: FND_MSG_PUB.Add;
935: RAISE FND_API.G_EXC_ERROR;
936: END IF;
937: -- Log message if item_number is also passed
938: IF (p_header_rec.item_number <> FND_API.G_MISS_CHAR) AND
939: (p_header_rec.item_number IS NOT NULL) THEN
940: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
941: add_header_to_error_stack(p_header_rec); -- Bug 2659435
942: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ITEM_NO');
943: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);
944: FND_MSG_PUB.Add;
945: END IF;
946: END IF;
939: (p_header_rec.item_number IS NOT NULL) THEN
940: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
941: add_header_to_error_stack(p_header_rec); -- Bug 2659435
942: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ITEM_NO');
943: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);
944: FND_MSG_PUB.Add;
945: END IF;
946: END IF;
947: ELSIF (p_header_rec.item_number <> FND_API.G_MISS_CHAR) AND
956:
957: IF l_header_rec.inventory_item_id IS NULL THEN -- item_Id fetch was not successful
958: -- Conversion failed.
959: add_header_to_error_stack(p_header_rec); -- Bug 2659435
960: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_NO');
961: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);
962: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_header_rec.organization_id);
963: FND_MSG_PUB.Add;
964: RAISE FND_API.G_EXC_ERROR;
957: IF l_header_rec.inventory_item_id IS NULL THEN -- item_Id fetch was not successful
958: -- Conversion failed.
959: add_header_to_error_stack(p_header_rec); -- Bug 2659435
960: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_NO');
961: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);
962: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_header_rec.organization_id);
963: FND_MSG_PUB.Add;
964: RAISE FND_API.G_EXC_ERROR;
965: ELSE
958: -- Conversion failed.
959: add_header_to_error_stack(p_header_rec); -- Bug 2659435
960: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_NO');
961: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);
962: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_header_rec.organization_id);
963: FND_MSG_PUB.Add;
964: RAISE FND_API.G_EXC_ERROR;
965: ELSE
966: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
968: END IF;
969: END IF;
970: ELSE
971: add_header_to_error_stack(p_header_rec); -- Bug 2659435
972: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_ID_REQ');
973: FND_MSG_PUB.Add;
974: RAISE FND_API.G_EXC_ERROR;
975: END IF;
976: -- End Item validation
990: -- overheads only. So Call Validate_Lot_Cost_type_id to verify the cost type is lot cost type or not.
991: -- If it is lot cost type id then log error message as invalid cost type
992: IF GMF_VALIDATIONS_PVT.Validate_Lot_Cost_type_id(p_header_rec.cost_type_id) THEN
993: add_header_to_error_stack(p_header_rec);
994: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE_ID');
995: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
996: FND_MSG_PUB.Add;
997: RAISE FND_API.G_EXC_ERROR;
998: END IF;
991: -- If it is lot cost type id then log error message as invalid cost type
992: IF GMF_VALIDATIONS_PVT.Validate_Lot_Cost_type_id(p_header_rec.cost_type_id) THEN
993: add_header_to_error_stack(p_header_rec);
994: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE_ID');
995: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
996: FND_MSG_PUB.Add;
997: RAISE FND_API.G_EXC_ERROR;
998: END IF;
999: -- log a message to ignore if cost method code also passed
998: END IF;
999: -- log a message to ignore if cost method code also passed
1000: IF (p_header_rec.cost_mthd_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.cost_mthd_code IS NOT NULL) THEN
1001: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1002: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_COST_TYPE');
1003: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_mthd_code);
1004: FND_MSG_PUB.Add;
1005: END IF;
1006: END IF;
999: -- log a message to ignore if cost method code also passed
1000: IF (p_header_rec.cost_mthd_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.cost_mthd_code IS NOT NULL) THEN
1001: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1002: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_COST_TYPE');
1003: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_mthd_code);
1004: FND_MSG_PUB.Add;
1005: END IF;
1006: END IF;
1007: -- if cost type method code passed
1020: --If cost type id is null or cost type is lot cost type then log invalid cost type message
1021: IF (l_header_rec.cost_Type_id IS NULL)
1022: OR (l_lc_cost_type_id IS NOT NULL ) THEN
1023: add_header_to_error_stack(p_header_rec);
1024: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE');
1025: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_header_rec.cost_mthd_code);
1026: FND_MSG_PUB.Add;
1027: RAISE FND_API.G_EXC_ERROR;
1028: ELSE
1021: IF (l_header_rec.cost_Type_id IS NULL)
1022: OR (l_lc_cost_type_id IS NOT NULL ) THEN
1023: add_header_to_error_stack(p_header_rec);
1024: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE');
1025: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_header_rec.cost_mthd_code);
1026: FND_MSG_PUB.Add;
1027: RAISE FND_API.G_EXC_ERROR;
1028: ELSE
1029: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1031: END IF;
1032: END IF;
1033: ELSE
1034: add_header_to_error_stack(p_header_rec);
1035: FND_MESSAGE.SET_NAME('GMF','GMF_API_COST_TYPE_ID_REQ');
1036: FND_MSG_PUB.Add;
1037: RAISE FND_API.G_EXC_ERROR;
1038: END IF;
1039: END IF;
1050: END IF;
1051: IF NOT GMF_VALIDATIONS_PVT.Validate_period_id(p_header_rec.period_id)
1052: THEN
1053: add_header_to_error_stack(p_header_rec);
1054: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_PERIOD_ID');
1055: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
1056: FND_MSG_PUB.Add;
1057: RAISE FND_API.G_EXC_ERROR;
1058: END IF;
1051: IF NOT GMF_VALIDATIONS_PVT.Validate_period_id(p_header_rec.period_id)
1052: THEN
1053: add_header_to_error_stack(p_header_rec);
1054: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_PERIOD_ID');
1055: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
1056: FND_MSG_PUB.Add;
1057: RAISE FND_API.G_EXC_ERROR;
1058: END IF;
1059: -- If period code also passed then ignore period code
1059: -- If period code also passed then ignore period code
1060: IF ((p_header_rec.calendar_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.calendar_code IS NOT NULL))
1061: AND ((p_header_rec.period_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.period_code IS NOT NULL)) THEN
1062: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1063: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_PERIOD_CODE');
1064: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_header_rec.calendar_code);
1065: FND_MESSAGE.SET_TOKEN('PERIOD_CODE', p_header_rec.period_code);
1066: FND_MSG_PUB.Add;
1067: END IF;
1060: IF ((p_header_rec.calendar_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.calendar_code IS NOT NULL))
1061: AND ((p_header_rec.period_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.period_code IS NOT NULL)) THEN
1062: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1063: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_PERIOD_CODE');
1064: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_header_rec.calendar_code);
1065: FND_MESSAGE.SET_TOKEN('PERIOD_CODE', p_header_rec.period_code);
1066: FND_MSG_PUB.Add;
1067: END IF;
1068: END IF;
1061: AND ((p_header_rec.period_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.period_code IS NOT NULL)) THEN
1062: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1063: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_PERIOD_CODE');
1064: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_header_rec.calendar_code);
1065: FND_MESSAGE.SET_TOKEN('PERIOD_CODE', p_header_rec.period_code);
1066: FND_MSG_PUB.Add;
1067: END IF;
1068: END IF;
1069: -- period code and calendar code are passed instead of period id
1083: l_header_rec.period_id := GMF_VALIDATIONS_PVT.Validate_period_code(l_header_rec.organization_id, p_header_rec.calendar_code,p_header_rec.period_code,l_header_rec.cost_type_id );
1084: -- if derived period id is null then log a message
1085: IF l_header_rec.period_id IS NULL THEN
1086: add_header_to_error_stack(p_header_rec);
1087: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CLDR_PERIOD');
1088: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE',p_header_rec.calendar_code);
1089: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header_rec.period_code);
1090: FND_MSG_PUB.Add;
1091: RAISE FND_API.G_EXC_ERROR;
1084: -- if derived period id is null then log a message
1085: IF l_header_rec.period_id IS NULL THEN
1086: add_header_to_error_stack(p_header_rec);
1087: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CLDR_PERIOD');
1088: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE',p_header_rec.calendar_code);
1089: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header_rec.period_code);
1090: FND_MSG_PUB.Add;
1091: RAISE FND_API.G_EXC_ERROR;
1092: ELSE
1085: IF l_header_rec.period_id IS NULL THEN
1086: add_header_to_error_stack(p_header_rec);
1087: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CLDR_PERIOD');
1088: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE',p_header_rec.calendar_code);
1089: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header_rec.period_code);
1090: FND_MSG_PUB.Add;
1091: RAISE FND_API.G_EXC_ERROR;
1092: ELSE
1093: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1095: END IF;
1096: END IF;
1097: ELSE
1098: add_header_to_error_stack(p_header_rec);
1099: FND_MESSAGE.SET_NAME('GMF','GMF_API_PERIOD_ID_REQ');
1100: FND_MSG_PUB.Add;
1101: RAISE FND_API.G_EXC_ERROR;
1102: END IF;
1103: END IF;
1119: );
1120:
1121: IF l_user_id = -1 THEN -- Bug 2681243: GMA changed return status value to -1.
1122: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1123: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_USER_NAME');
1124: FND_MESSAGE.SET_TOKEN('USER_NAME',p_header_rec.user_name);
1125: FND_MSG_PUB.Add;
1126: RAISE FND_API.G_EXC_ERROR;
1127: END IF;
1120:
1121: IF l_user_id = -1 THEN -- Bug 2681243: GMA changed return status value to -1.
1122: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1123: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_USER_NAME');
1124: FND_MESSAGE.SET_TOKEN('USER_NAME',p_header_rec.user_name);
1125: FND_MSG_PUB.Add;
1126: RAISE FND_API.G_EXC_ERROR;
1127: END IF;
1128:
1127: END IF;
1128:
1129: ELSE
1130: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1131: FND_MESSAGE.SET_NAME('GMF','GMF_API_USER_NAME_REQ');
1132: FND_MSG_PUB.Add;
1133: RAISE FND_API.G_EXC_ERROR;
1134: END IF;
1135: -- End User Name
1334:
1335: IF NOT GMF_VALIDATIONS_PVT.Validate_organization_id(p_header_rec.organization_id)
1336: THEN
1337: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1338: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_ID');
1339: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
1340: FND_MSG_PUB.Add;
1341: RAISE FND_API.G_EXC_ERROR;
1342: END IF;
1335: IF NOT GMF_VALIDATIONS_PVT.Validate_organization_id(p_header_rec.organization_id)
1336: THEN
1337: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1338: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_ID');
1339: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
1340: FND_MSG_PUB.Add;
1341: RAISE FND_API.G_EXC_ERROR;
1342: END IF;
1343:
1345: IF (p_header_rec.organization_code <> FND_API.G_MISS_CHAR) AND
1346: (p_header_rec.organization_code IS NOT NULL) THEN
1347: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1348: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1349: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ORGN_CODE');
1350: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header_rec.organization_code);
1351: FND_MSG_PUB.Add;
1352: END IF;
1353: END IF;
1346: (p_header_rec.organization_code IS NOT NULL) THEN
1347: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1348: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1349: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ORGN_CODE');
1350: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header_rec.organization_code);
1351: FND_MSG_PUB.Add;
1352: END IF;
1353: END IF;
1354: -- organization code
1360: END IF;
1361: x_header_rec.organization_id := GMF_VALIDATIONS_PVT.Validate_organization_Code(p_header_rec.organization_code);
1362: IF x_header_rec.organization_id IS NULL THEN
1363: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1364: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_CODE');
1365: FND_MESSAGE.SET_TOKEN('ORG_CODE',p_header_rec.organization_code);
1366: FND_MSG_PUB.Add;
1367: RAISE FND_API.G_EXC_ERROR;
1368: ELSE
1361: x_header_rec.organization_id := GMF_VALIDATIONS_PVT.Validate_organization_Code(p_header_rec.organization_code);
1362: IF x_header_rec.organization_id IS NULL THEN
1363: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1364: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_CODE');
1365: FND_MESSAGE.SET_TOKEN('ORG_CODE',p_header_rec.organization_code);
1366: FND_MSG_PUB.Add;
1367: RAISE FND_API.G_EXC_ERROR;
1368: ELSE
1369: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 5589409, pmarada
1371: END IF;
1372: END IF;
1373: ELSE
1374: add_header_to_error_stack(p_header_rec);
1375: FND_MESSAGE.SET_NAME('GMF','GMF_API_ORGANIZATION_ID_REQ');
1376: FND_MSG_PUB.Add;
1377: RAISE FND_API.G_EXC_ERROR;
1378: END IF;
1379: -- End organization validation
1393: x_header_rec.organization_id := nvl(p_header_rec.organization_id,x_header_rec.organization_id) ;
1394: IF NOT GMF_VALIDATIONS_PVT.Validate_inventory_item_Id(p_header_rec.inventory_item_id, x_header_rec.organization_id)
1395: THEN
1396: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1397: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_ID');
1398: FND_MESSAGE.SET_TOKEN('ITEM_ID',p_header_rec.inventory_item_id);
1399: FND_MSG_PUB.Add;
1400: RAISE FND_API.G_EXC_ERROR;
1401: END IF;
1394: IF NOT GMF_VALIDATIONS_PVT.Validate_inventory_item_Id(p_header_rec.inventory_item_id, x_header_rec.organization_id)
1395: THEN
1396: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1397: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_ID');
1398: FND_MESSAGE.SET_TOKEN('ITEM_ID',p_header_rec.inventory_item_id);
1399: FND_MSG_PUB.Add;
1400: RAISE FND_API.G_EXC_ERROR;
1401: END IF;
1402: -- Log message if item_number is also passed
1403: IF (p_header_rec.item_number <> FND_API.G_MISS_CHAR) AND
1404: (p_header_rec.item_number IS NOT NULL) THEN
1405: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1406: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1407: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ITEM_NO');
1408: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);
1409: FND_MSG_PUB.Add;
1410: END IF;
1411: END IF;
1404: (p_header_rec.item_number IS NOT NULL) THEN
1405: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1406: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1407: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ITEM_NO');
1408: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);
1409: FND_MSG_PUB.Add;
1410: END IF;
1411: END IF;
1412: ELSIF (p_header_rec.item_number <> FND_API.G_MISS_CHAR) AND
1420: x_header_rec.inventory_item_id :=GMF_VALIDATIONS_PVT.Validate_Item_Number(p_header_rec.item_number, x_header_rec.organization_id);
1421: IF x_header_rec.inventory_item_id IS NULL THEN -- item_Id fetch was not successful
1422: -- Conversion failed.
1423: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1424: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_NO');
1425: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);
1426: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',x_header_rec.organization_id);
1427: FND_MSG_PUB.Add;
1428: RAISE FND_API.G_EXC_ERROR;
1421: IF x_header_rec.inventory_item_id IS NULL THEN -- item_Id fetch was not successful
1422: -- Conversion failed.
1423: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1424: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_NO');
1425: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);
1426: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',x_header_rec.organization_id);
1427: FND_MSG_PUB.Add;
1428: RAISE FND_API.G_EXC_ERROR;
1429: ELSE
1422: -- Conversion failed.
1423: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1424: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_NO');
1425: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);
1426: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',x_header_rec.organization_id);
1427: FND_MSG_PUB.Add;
1428: RAISE FND_API.G_EXC_ERROR;
1429: ELSE
1430: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1432: END IF;
1433: END IF;
1434: ELSE
1435: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1436: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_ID_REQ');
1437: FND_MSG_PUB.Add;
1438: RAISE FND_API.G_EXC_ERROR;
1439: END IF;
1440: -- End Item validation
1461: -- overheads only. So Call Validate_Lot_Cost_type_id to verify the cost type is lot cost type or not.
1462: -- If it is lot cost type id then log error message as invalid cost type
1463: IF GMF_VALIDATIONS_PVT.Validate_Lot_Cost_type_id(p_header_rec.cost_type_id) THEN
1464: add_header_to_error_stack(p_header_rec);
1465: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE_ID');
1466: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
1467: FND_MSG_PUB.Add;
1468: RAISE FND_API.G_EXC_ERROR;
1469: END IF;
1462: -- If it is lot cost type id then log error message as invalid cost type
1463: IF GMF_VALIDATIONS_PVT.Validate_Lot_Cost_type_id(p_header_rec.cost_type_id) THEN
1464: add_header_to_error_stack(p_header_rec);
1465: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE_ID');
1466: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
1467: FND_MSG_PUB.Add;
1468: RAISE FND_API.G_EXC_ERROR;
1469: END IF;
1470: -- log a message to ignore if cost method code also passed
1469: END IF;
1470: -- log a message to ignore if cost method code also passed
1471: IF (p_header_rec.cost_mthd_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.cost_mthd_code IS NOT NULL) THEN
1472: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1473: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_COST_TYPE');
1474: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_mthd_code);
1475: FND_MSG_PUB.Add;
1476: END IF;
1477: END IF;
1470: -- log a message to ignore if cost method code also passed
1471: IF (p_header_rec.cost_mthd_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.cost_mthd_code IS NOT NULL) THEN
1472: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1473: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_COST_TYPE');
1474: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_mthd_code);
1475: FND_MSG_PUB.Add;
1476: END IF;
1477: END IF;
1478: -- If cost type code is passed then derive the cost type id
1491: --If cost type id is null or cost type is lot cost type then log invalid cost type message
1492: IF (x_header_rec.cost_Type_id IS NULL)
1493: OR (l_lc_cost_type_id IS NOT NULL ) THEN
1494: add_header_to_error_stack(p_header_rec);
1495: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE');
1496: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_header_rec.cost_mthd_code);
1497: FND_MSG_PUB.Add;
1498: RAISE FND_API.G_EXC_ERROR;
1499: ELSE
1492: IF (x_header_rec.cost_Type_id IS NULL)
1493: OR (l_lc_cost_type_id IS NOT NULL ) THEN
1494: add_header_to_error_stack(p_header_rec);
1495: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE');
1496: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_header_rec.cost_mthd_code);
1497: FND_MSG_PUB.Add;
1498: RAISE FND_API.G_EXC_ERROR;
1499: ELSE
1500: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 5589409, pmarada
1502: END IF;
1503: END IF;
1504: ELSE
1505: add_header_to_error_stack(p_header_rec);
1506: FND_MESSAGE.SET_NAME('GMF','GMF_API_COST_TYPE_ID_REQ');
1507: FND_MSG_PUB.Add;
1508: RAISE FND_API.G_EXC_ERROR;
1509: END IF;
1510: END IF;
1521: -- validate period id
1522: IF NOT GMF_VALIDATIONS_PVT.Validate_period_id(p_header_rec.period_id)
1523: THEN
1524: add_header_to_error_stack(p_header_rec);
1525: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_PERIOD_ID');
1526: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
1527: FND_MSG_PUB.Add;
1528: RAISE FND_API.G_EXC_ERROR;
1529: END IF;
1522: IF NOT GMF_VALIDATIONS_PVT.Validate_period_id(p_header_rec.period_id)
1523: THEN
1524: add_header_to_error_stack(p_header_rec);
1525: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_PERIOD_ID');
1526: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
1527: FND_MSG_PUB.Add;
1528: RAISE FND_API.G_EXC_ERROR;
1529: END IF;
1530: -- If period code also passed then ignore period code
1530: -- If period code also passed then ignore period code
1531: IF ((p_header_rec.calendar_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.calendar_code IS NOT NULL))
1532: AND ((p_header_rec.period_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.period_code IS NOT NULL)) THEN
1533: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1534: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_PERIOD_CODE');
1535: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_header_rec.calendar_code);
1536: FND_MESSAGE.SET_TOKEN('PERIOD_CODE', p_header_rec.period_code);
1537: FND_MSG_PUB.Add;
1538: END IF;
1531: IF ((p_header_rec.calendar_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.calendar_code IS NOT NULL))
1532: AND ((p_header_rec.period_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.period_code IS NOT NULL)) THEN
1533: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1534: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_PERIOD_CODE');
1535: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_header_rec.calendar_code);
1536: FND_MESSAGE.SET_TOKEN('PERIOD_CODE', p_header_rec.period_code);
1537: FND_MSG_PUB.Add;
1538: END IF;
1539: END IF;
1532: AND ((p_header_rec.period_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.period_code IS NOT NULL)) THEN
1533: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1534: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_PERIOD_CODE');
1535: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_header_rec.calendar_code);
1536: FND_MESSAGE.SET_TOKEN('PERIOD_CODE', p_header_rec.period_code);
1537: FND_MSG_PUB.Add;
1538: END IF;
1539: END IF;
1540: ELSE
1553:
1554: x_header_rec.period_id := GMF_VALIDATIONS_PVT.Validate_period_code(x_header_rec.organization_id, p_header_rec.calendar_code,p_header_rec.period_code,x_header_rec.cost_Type_id);
1555: IF x_header_rec.period_id IS NULL THEN
1556: add_header_to_error_stack(p_header_rec);
1557: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CLDR_PERIOD');
1558: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE',p_header_rec.calendar_code);
1559: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header_rec.period_code);
1560: FND_MSG_PUB.Add;
1561: RAISE FND_API.G_EXC_ERROR;
1554: x_header_rec.period_id := GMF_VALIDATIONS_PVT.Validate_period_code(x_header_rec.organization_id, p_header_rec.calendar_code,p_header_rec.period_code,x_header_rec.cost_Type_id);
1555: IF x_header_rec.period_id IS NULL THEN
1556: add_header_to_error_stack(p_header_rec);
1557: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CLDR_PERIOD');
1558: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE',p_header_rec.calendar_code);
1559: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header_rec.period_code);
1560: FND_MSG_PUB.Add;
1561: RAISE FND_API.G_EXC_ERROR;
1562: ELSE
1555: IF x_header_rec.period_id IS NULL THEN
1556: add_header_to_error_stack(p_header_rec);
1557: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CLDR_PERIOD');
1558: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE',p_header_rec.calendar_code);
1559: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header_rec.period_code);
1560: FND_MSG_PUB.Add;
1561: RAISE FND_API.G_EXC_ERROR;
1562: ELSE
1563: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 5589409, pmarada
1565: END IF;
1566: END IF;
1567: ELSE
1568: add_header_to_error_stack(p_header_rec);
1569: FND_MESSAGE.SET_NAME('GMF','GMF_API_PERIOD_ID_REQ');
1570: FND_MSG_PUB.Add;
1571: RAISE FND_API.G_EXC_ERROR;
1572: END IF;
1573: END IF;
1588: );
1589:
1590: IF x_user_id = -1 THEN -- Bug 2681243: GMA changed return status value to -1.
1591: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1592: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_USER_NAME');
1593: FND_MESSAGE.SET_TOKEN('USER_NAME',p_header_rec.user_name);
1594: FND_MSG_PUB.Add;
1595: RAISE FND_API.G_EXC_ERROR;
1596: END IF;
1589:
1590: IF x_user_id = -1 THEN -- Bug 2681243: GMA changed return status value to -1.
1591: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1592: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_USER_NAME');
1593: FND_MESSAGE.SET_TOKEN('USER_NAME',p_header_rec.user_name);
1594: FND_MSG_PUB.Add;
1595: RAISE FND_API.G_EXC_ERROR;
1596: END IF;
1597:
1596: END IF;
1597:
1598: ELSE
1599: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1600: FND_MESSAGE.SET_NAME('GMF','GMF_API_USER_NAME_REQ');
1601: FND_MSG_PUB.Add;
1602: RAISE FND_API.G_EXC_ERROR;
1603: END IF;
1604: -- End User Name
1671: IF ((p_operation = 'DELETE') AND
1672: ((p_dtl_tbl(i).burdenline_id <> FND_API.G_MISS_NUM) OR (p_dtl_tbl(i).burdenline_id IS NOT NULL))
1673: ) THEN
1674: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1675: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_BRDN_UNIQUE_KEY');
1676: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID', p_dtl_tbl(i).burdenline_id);
1677: FND_MSG_PUB.Add;
1678: l_burdenline_id := p_dtl_tbl(i).burdenline_id;
1679: ELSE
1672: ((p_dtl_tbl(i).burdenline_id <> FND_API.G_MISS_NUM) OR (p_dtl_tbl(i).burdenline_id IS NOT NULL))
1673: ) THEN
1674: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1675: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_BRDN_UNIQUE_KEY');
1676: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID', p_dtl_tbl(i).burdenline_id);
1677: FND_MSG_PUB.Add;
1678: l_burdenline_id := p_dtl_tbl(i).burdenline_id;
1679: ELSE
1680:
1707:
1708: EXCEPTION
1709: WHEN NO_DATA_FOUND THEN
1710: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1711: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_BRDN_LINE_ID');
1712: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID',p_dtl_tbl(i).burdenline_id);
1713: FND_MSG_PUB.Add;
1714: RAISE e_brdn_dtl;
1715: END;
1708: EXCEPTION
1709: WHEN NO_DATA_FOUND THEN
1710: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1711: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_BRDN_LINE_ID');
1712: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID',p_dtl_tbl(i).burdenline_id);
1713: FND_MSG_PUB.Add;
1714: RAISE e_brdn_dtl;
1715: END;
1716:
1717: GMF_VALIDATIONS_PVT.Validate_Resource(l_resources, l_resource_uom, l_resource_uom_class) ;
1718:
1719: IF (l_resource_uom IS NULL) OR (l_resource_uom_class IS NULL) THEN
1720: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1721: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_RESOURCES');
1722: FND_MESSAGE.SET_TOKEN('RESOURCES',p_dtl_tbl(i).resources);
1723: FND_MSG_PUB.Add;
1724: RAISE e_brdn_dtl;
1725: END IF;
1718:
1719: IF (l_resource_uom IS NULL) OR (l_resource_uom_class IS NULL) THEN
1720: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1721: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_RESOURCES');
1722: FND_MESSAGE.SET_TOKEN('RESOURCES',p_dtl_tbl(i).resources);
1723: FND_MSG_PUB.Add;
1724: RAISE e_brdn_dtl;
1725: END IF;
1726:
1741:
1742: GMF_VALIDATIONS_PVT.Validate_Resource(l_resources, l_resource_uom, l_resource_uom_class) ;
1743: IF (l_resource_uom IS NULL) OR (l_resource_uom_class IS NULL) THEN
1744: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1745: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_RESOURCES');
1746: FND_MESSAGE.SET_TOKEN('RESOURCES',p_dtl_tbl(i).resources);
1747: FND_MSG_PUB.Add;
1748: RAISE e_brdn_dtl;
1749: END IF;
1742: GMF_VALIDATIONS_PVT.Validate_Resource(l_resources, l_resource_uom, l_resource_uom_class) ;
1743: IF (l_resource_uom IS NULL) OR (l_resource_uom_class IS NULL) THEN
1744: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1745: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_RESOURCES');
1746: FND_MESSAGE.SET_TOKEN('RESOURCES',p_dtl_tbl(i).resources);
1747: FND_MSG_PUB.Add;
1748: RAISE e_brdn_dtl;
1749: END IF;
1750: ELSE
1748: RAISE e_brdn_dtl;
1749: END IF;
1750: ELSE
1751: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1752: FND_MESSAGE.SET_NAME('GMF','GMF_API_RESOURCES_REQ');
1753: FND_MSG_PUB.Add;
1754: RAISE e_brdn_dtl;
1755: END IF;
1756:
1771: -- validate CmpntCls Id
1772: GMF_VALIDATIONS_PVT.Validate_Cost_Cmpntcls_Id (p_dtl_tbl(i).cost_cmpntcls_id,l_cost_cmpntcls_code,l_usage_ind);
1773: IF l_usage_ind IS NULL THEN
1774: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1775: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CMPNTCLS_ID');
1776: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',p_dtl_tbl(i).cost_cmpntcls_id);
1777: FND_MSG_PUB.Add;
1778: RAISE e_brdn_dtl;
1779: ELSIF l_usage_ind <> 2 THEN
1772: GMF_VALIDATIONS_PVT.Validate_Cost_Cmpntcls_Id (p_dtl_tbl(i).cost_cmpntcls_id,l_cost_cmpntcls_code,l_usage_ind);
1773: IF l_usage_ind IS NULL THEN
1774: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1775: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CMPNTCLS_ID');
1776: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',p_dtl_tbl(i).cost_cmpntcls_id);
1777: FND_MSG_PUB.Add;
1778: RAISE e_brdn_dtl;
1779: ELSIF l_usage_ind <> 2 THEN
1780: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1777: FND_MSG_PUB.Add;
1778: RAISE e_brdn_dtl;
1779: ELSIF l_usage_ind <> 2 THEN
1780: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1781: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_USG_NOT_BRDN');
1782: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',p_dtl_tbl(i).cost_cmpntcls_id);
1783: FND_MSG_PUB.Add;
1784: RAISE e_brdn_dtl;
1785: END IF;
1778: RAISE e_brdn_dtl;
1779: ELSIF l_usage_ind <> 2 THEN
1780: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1781: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_USG_NOT_BRDN');
1782: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',p_dtl_tbl(i).cost_cmpntcls_id);
1783: FND_MSG_PUB.Add;
1784: RAISE e_brdn_dtl;
1785: END IF;
1786:
1790: IF (p_dtl_tbl(i).cost_cmpntcls_code <> FND_API.G_MISS_CHAR) AND
1791: (p_dtl_tbl(i).cost_cmpntcls_code IS NOT NULL) THEN
1792: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1793: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1794: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_CMPNTCLS_CODE');
1795: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_dtl_tbl(i).cost_cmpntcls_code);
1796: FND_MSG_PUB.Add;
1797: END IF;
1798: END IF;
1791: (p_dtl_tbl(i).cost_cmpntcls_code IS NOT NULL) THEN
1792: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1793: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1794: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_CMPNTCLS_CODE');
1795: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_dtl_tbl(i).cost_cmpntcls_code);
1796: FND_MSG_PUB.Add;
1797: END IF;
1798: END IF;
1799: ELSIF (p_dtl_tbl(i).cost_cmpntcls_code <> FND_API.G_MISS_CHAR) AND
1817:
1818: IF (l_cost_cmpntcls_id IS NULL) OR (l_usage_ind IS NULL) THEN
1819: -- Conversion failed.
1820: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1821: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CMPNTCLS_CODE');
1822: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_dtl_tbl(i).cost_cmpntcls_code);
1823: FND_MSG_PUB.Add;
1824: RAISE e_brdn_dtl;
1825: ELSIF l_usage_ind <> 2 THEN
1818: IF (l_cost_cmpntcls_id IS NULL) OR (l_usage_ind IS NULL) THEN
1819: -- Conversion failed.
1820: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1821: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CMPNTCLS_CODE');
1822: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_dtl_tbl(i).cost_cmpntcls_code);
1823: FND_MSG_PUB.Add;
1824: RAISE e_brdn_dtl;
1825: ELSIF l_usage_ind <> 2 THEN
1826: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1823: FND_MSG_PUB.Add;
1824: RAISE e_brdn_dtl;
1825: ELSIF l_usage_ind <> 2 THEN
1826: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1827: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_USG_NOT_BRDN');
1828: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',l_cost_cmpntcls_id);
1829: FND_MSG_PUB.Add;
1830: RAISE e_brdn_dtl;
1831: END IF;
1824: RAISE e_brdn_dtl;
1825: ELSIF l_usage_ind <> 2 THEN
1826: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1827: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_USG_NOT_BRDN');
1828: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',l_cost_cmpntcls_id);
1829: FND_MSG_PUB.Add;
1830: RAISE e_brdn_dtl;
1831: END IF;
1832: ELSE
1830: RAISE e_brdn_dtl;
1831: END IF;
1832: ELSE
1833: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1834: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_ID_REQ');
1835: FND_MSG_PUB.Add;
1836: RAISE e_brdn_dtl;
1837: END IF;
1838: -- End CmpntCls Id
1848: END IF;
1849: IF NOT GMF_VALIDATIONS_PVT.Validate_Analysis_Code(p_dtl_tbl(i).cost_analysis_code)
1850: THEN
1851: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1852: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ANALYSIS_CODE');
1853: FND_MESSAGE.SET_TOKEN('ANALYSIS_CODE',p_dtl_tbl(i).cost_analysis_code);
1854: FND_MSG_PUB.Add;
1855: RAISE e_brdn_dtl;
1856: END IF;
1849: IF NOT GMF_VALIDATIONS_PVT.Validate_Analysis_Code(p_dtl_tbl(i).cost_analysis_code)
1850: THEN
1851: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1852: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ANALYSIS_CODE');
1853: FND_MESSAGE.SET_TOKEN('ANALYSIS_CODE',p_dtl_tbl(i).cost_analysis_code);
1854: FND_MSG_PUB.Add;
1855: RAISE e_brdn_dtl;
1856: END IF;
1857: ELSE
1855: RAISE e_brdn_dtl;
1856: END IF;
1857: ELSE
1858: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1859: FND_MESSAGE.SET_NAME('GMF','GMF_API_ANALYSIS_CODE_REQ');
1860: FND_MSG_PUB.Add;
1861: RAISE e_brdn_dtl;
1862: END IF;
1863: -- End Analysis Code
1884:
1885: EXCEPTION
1886: WHEN NO_DATA_FOUND THEN
1887: add_header_to_error_stack(p_header_rec);
1888: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_DTL_NOT_FOUND');
1889: FND_MESSAGE.SET_TOKEN('RESOURCE',l_resources);
1890: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_dtl_tbl(i).cost_cmpntcls_code);
1891: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',l_cost_cmpntcls_id);
1892: FND_MESSAGE.SET_TOKEN('ALYS_CODE',p_dtl_tbl(i).cost_analysis_code);
1885: EXCEPTION
1886: WHEN NO_DATA_FOUND THEN
1887: add_header_to_error_stack(p_header_rec);
1888: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_DTL_NOT_FOUND');
1889: FND_MESSAGE.SET_TOKEN('RESOURCE',l_resources);
1890: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_dtl_tbl(i).cost_cmpntcls_code);
1891: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',l_cost_cmpntcls_id);
1892: FND_MESSAGE.SET_TOKEN('ALYS_CODE',p_dtl_tbl(i).cost_analysis_code);
1893: FND_MSG_PUB.Add;
1886: WHEN NO_DATA_FOUND THEN
1887: add_header_to_error_stack(p_header_rec);
1888: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_DTL_NOT_FOUND');
1889: FND_MESSAGE.SET_TOKEN('RESOURCE',l_resources);
1890: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_dtl_tbl(i).cost_cmpntcls_code);
1891: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',l_cost_cmpntcls_id);
1892: FND_MESSAGE.SET_TOKEN('ALYS_CODE',p_dtl_tbl(i).cost_analysis_code);
1893: FND_MSG_PUB.Add;
1894: RAISE e_brdn_dtl;
1887: add_header_to_error_stack(p_header_rec);
1888: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_DTL_NOT_FOUND');
1889: FND_MESSAGE.SET_TOKEN('RESOURCE',l_resources);
1890: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_dtl_tbl(i).cost_cmpntcls_code);
1891: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',l_cost_cmpntcls_id);
1892: FND_MESSAGE.SET_TOKEN('ALYS_CODE',p_dtl_tbl(i).cost_analysis_code);
1893: FND_MSG_PUB.Add;
1894: RAISE e_brdn_dtl;
1895: END;
1888: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_DTL_NOT_FOUND');
1889: FND_MESSAGE.SET_TOKEN('RESOURCE',l_resources);
1890: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_dtl_tbl(i).cost_cmpntcls_code);
1891: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',l_cost_cmpntcls_id);
1892: FND_MESSAGE.SET_TOKEN('ALYS_CODE',p_dtl_tbl(i).cost_analysis_code);
1893: FND_MSG_PUB.Add;
1894: RAISE e_brdn_dtl;
1895: END;
1896: END IF;
1925: /*
1926: IF ((nvl(p_dtl_tbl(i).burden_usage,0) <= 0.000000001) OR
1927: (nvl(p_dtl_tbl(i).burden_usage,0) >= 1000000000)) THEN
1928: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1929: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_BURDEN_USAGE');
1930: FND_MESSAGE.SET_TOKEN('BURDEN_USAGE',p_dtl_tbl(i).burden_usage);
1931: FND_MSG_PUB.Add;
1932: RAISE e_brdn_dtl;
1933: END IF;
1926: IF ((nvl(p_dtl_tbl(i).burden_usage,0) <= 0.000000001) OR
1927: (nvl(p_dtl_tbl(i).burden_usage,0) >= 1000000000)) THEN
1928: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1929: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_BURDEN_USAGE');
1930: FND_MESSAGE.SET_TOKEN('BURDEN_USAGE',p_dtl_tbl(i).burden_usage);
1931: FND_MSG_PUB.Add;
1932: RAISE e_brdn_dtl;
1933: END IF;
1934: */
1936: ELSIF (p_dtl_tbl(i).burden_usage = FND_API.G_MISS_NUM AND -- Bug 2659435
1937: p_operation = 'UPDATE') OR
1938: (p_operation = 'INSERT') THEN
1939: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1940: FND_MESSAGE.SET_NAME('GMF','GMF_API_BURDEN_USAGE_REQ');
1941: FND_MSG_PUB.Add;
1942: RAISE e_brdn_dtl;
1943: END IF;
1944: -- End Burden Usage
1961:
1962: IF ((nvl(p_dtl_tbl(i).item_qty,0) <= 0.000000001) OR
1963: (nvl(p_dtl_tbl(i).item_qty,0) >= 1000000000)) THEN
1964: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1965: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_QTY');
1966: FND_MESSAGE.SET_TOKEN('ITEM_QTY',p_dtl_tbl(i).item_qty);
1967: FND_MSG_PUB.Add;
1968: RAISE e_brdn_dtl;
1969: END IF;
1962: IF ((nvl(p_dtl_tbl(i).item_qty,0) <= 0.000000001) OR
1963: (nvl(p_dtl_tbl(i).item_qty,0) >= 1000000000)) THEN
1964: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1965: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_QTY');
1966: FND_MESSAGE.SET_TOKEN('ITEM_QTY',p_dtl_tbl(i).item_qty);
1967: FND_MSG_PUB.Add;
1968: RAISE e_brdn_dtl;
1969: END IF;
1970: ELSIF (p_dtl_tbl(i).item_qty = FND_API.G_MISS_NUM AND -- Bug 2659435
1970: ELSIF (p_dtl_tbl(i).item_qty = FND_API.G_MISS_NUM AND -- Bug 2659435
1971: p_operation = 'UPDATE') OR
1972: (p_operation = 'INSERT') THEN
1973: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1974: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_QTY_REQ');
1975: FND_MSG_PUB.Add;
1976: RAISE e_brdn_dtl;
1977: END IF;
1978: -- End Item Quantity
1989:
1990: l_item_uom := p_dtl_tbl(i).item_uom; -- Bug 2681243
1991: IF NOT GMF_VALIDATIONS_PVT.Validate_Usage_Uom(p_dtl_tbl(i).item_uom) THEN
1992: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1993: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_UM');
1994: FND_MESSAGE.SET_TOKEN('ITEM_UOM',p_dtl_tbl(i).item_uom);
1995: FND_MSG_PUB.Add;
1996: RAISE e_brdn_dtl;
1997: END IF;
1990: l_item_uom := p_dtl_tbl(i).item_uom; -- Bug 2681243
1991: IF NOT GMF_VALIDATIONS_PVT.Validate_Usage_Uom(p_dtl_tbl(i).item_uom) THEN
1992: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1993: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_UM');
1994: FND_MESSAGE.SET_TOKEN('ITEM_UOM',p_dtl_tbl(i).item_uom);
1995: FND_MSG_PUB.Add;
1996: RAISE e_brdn_dtl;
1997: END IF;
1998:
1999: ELSIF (p_dtl_tbl(i).item_uom = FND_API.G_MISS_CHAR AND -- Bug 2659435
2000: p_operation = 'UPDATE') OR
2001: (p_operation = 'INSERT') THEN
2002: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2003: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_UM_REQ');
2004: FND_MSG_PUB.Add;
2005: RAISE e_brdn_dtl;
2006: END IF;
2007:
2047:
2048: EXCEPTION
2049: WHEN OTHERS THEN
2050: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2051: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_UM_CONV_ERR');
2052: FND_MESSAGE.SET_TOKEN('ITEM_ID', x_header_rec.inventory_item_id); --p_header_rec.item_id); Bug# 1935297
2053: FND_MESSAGE.SET_TOKEN('ITEM_UM',l_item_uom);
2054: FND_MESSAGE.SET_TOKEN('ITEM_ACT_UM',l_act_item_uom);
2055: FND_MSG_PUB.Add;
2048: EXCEPTION
2049: WHEN OTHERS THEN
2050: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2051: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_UM_CONV_ERR');
2052: FND_MESSAGE.SET_TOKEN('ITEM_ID', x_header_rec.inventory_item_id); --p_header_rec.item_id); Bug# 1935297
2053: FND_MESSAGE.SET_TOKEN('ITEM_UM',l_item_uom);
2054: FND_MESSAGE.SET_TOKEN('ITEM_ACT_UM',l_act_item_uom);
2055: FND_MSG_PUB.Add;
2056: RAISE e_brdn_dtl;
2049: WHEN OTHERS THEN
2050: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2051: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_UM_CONV_ERR');
2052: FND_MESSAGE.SET_TOKEN('ITEM_ID', x_header_rec.inventory_item_id); --p_header_rec.item_id); Bug# 1935297
2053: FND_MESSAGE.SET_TOKEN('ITEM_UM',l_item_uom);
2054: FND_MESSAGE.SET_TOKEN('ITEM_ACT_UM',l_act_item_uom);
2055: FND_MSG_PUB.Add;
2056: RAISE e_brdn_dtl;
2057: END ;
2050: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2051: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_UM_CONV_ERR');
2052: FND_MESSAGE.SET_TOKEN('ITEM_ID', x_header_rec.inventory_item_id); --p_header_rec.item_id); Bug# 1935297
2053: FND_MESSAGE.SET_TOKEN('ITEM_UM',l_item_uom);
2054: FND_MESSAGE.SET_TOKEN('ITEM_ACT_UM',l_act_item_uom);
2055: FND_MSG_PUB.Add;
2056: RAISE e_brdn_dtl;
2057: END ;
2058: END IF ;
2075: l_burden_qty := p_dtl_tbl(i).burden_qty; -- Bug 2681243
2076: IF ((nvl(p_dtl_tbl(i).burden_qty,0) <= 0.000000001) OR
2077: (nvl(p_dtl_tbl(i).burden_qty,0) >= 1000000000)) THEN
2078: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2079: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_BURDEN_QTY');
2080: FND_MESSAGE.SET_TOKEN('OVERHEAD_QTY',p_dtl_tbl(i).burden_qty);
2081: FND_MSG_PUB.Add;
2082: RAISE e_brdn_dtl;
2083: END IF;
2076: IF ((nvl(p_dtl_tbl(i).burden_qty,0) <= 0.000000001) OR
2077: (nvl(p_dtl_tbl(i).burden_qty,0) >= 1000000000)) THEN
2078: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2079: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_BURDEN_QTY');
2080: FND_MESSAGE.SET_TOKEN('OVERHEAD_QTY',p_dtl_tbl(i).burden_qty);
2081: FND_MSG_PUB.Add;
2082: RAISE e_brdn_dtl;
2083: END IF;
2084: ELSIF (p_dtl_tbl(i).burden_qty = FND_API.G_MISS_NUM AND -- Bug 2659435
2084: ELSIF (p_dtl_tbl(i).burden_qty = FND_API.G_MISS_NUM AND -- Bug 2659435
2085: p_operation = 'UPDATE') OR
2086: (p_operation = 'INSERT') THEN
2087: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2088: FND_MESSAGE.SET_NAME('GMF','GMF_API_BURDEN_QTY_REQ');
2089: FND_MSG_PUB.Add;
2090: RAISE e_brdn_dtl;
2091: END IF;
2092: -- End Burden Quantity
2104: l_burden_uom := p_dtl_tbl(i).burden_uom; -- Bug 2681243
2105: GMF_VALIDATIONS_PVT.Validate_Usage_Uom(p_dtl_tbl(i).burden_uom, l_burden_uom_class) ;
2106: IF l_burden_uom_class IS NULL THEN
2107: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2108: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_BURDEN_UM');
2109: FND_MESSAGE.SET_TOKEN('OVERHEAD_UM',p_dtl_tbl(i).burden_uom);
2110: FND_MSG_PUB.Add;
2111: RAISE e_brdn_dtl;
2112: END IF;
2105: GMF_VALIDATIONS_PVT.Validate_Usage_Uom(p_dtl_tbl(i).burden_uom, l_burden_uom_class) ;
2106: IF l_burden_uom_class IS NULL THEN
2107: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2108: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_BURDEN_UM');
2109: FND_MESSAGE.SET_TOKEN('OVERHEAD_UM',p_dtl_tbl(i).burden_uom);
2110: FND_MSG_PUB.Add;
2111: RAISE e_brdn_dtl;
2112: END IF;
2113:
2117:
2118: -- Burden UOM must be of the same type as the resource UOM
2119: IF (l_resource_uom_class <> l_burden_uom_class) THEN
2120: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2121: FND_MESSAGE.SET_NAME('GMF','GMF_API_UOM_SAMETYPE_REQ');
2122: FND_MESSAGE.SET_TOKEN('OVERHEAD_UM',p_dtl_tbl(i).burden_uom);
2123: FND_MESSAGE.SET_TOKEN('RESOURCE_UM',l_resource_uom_class);
2124: FND_MSG_PUB.Add;
2125: RAISE e_brdn_dtl;
2118: -- Burden UOM must be of the same type as the resource UOM
2119: IF (l_resource_uom_class <> l_burden_uom_class) THEN
2120: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2121: FND_MESSAGE.SET_NAME('GMF','GMF_API_UOM_SAMETYPE_REQ');
2122: FND_MESSAGE.SET_TOKEN('OVERHEAD_UM',p_dtl_tbl(i).burden_uom);
2123: FND_MESSAGE.SET_TOKEN('RESOURCE_UM',l_resource_uom_class);
2124: FND_MSG_PUB.Add;
2125: RAISE e_brdn_dtl;
2126: END IF;
2119: IF (l_resource_uom_class <> l_burden_uom_class) THEN
2120: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2121: FND_MESSAGE.SET_NAME('GMF','GMF_API_UOM_SAMETYPE_REQ');
2122: FND_MESSAGE.SET_TOKEN('OVERHEAD_UM',p_dtl_tbl(i).burden_uom);
2123: FND_MESSAGE.SET_TOKEN('RESOURCE_UM',l_resource_uom_class);
2124: FND_MSG_PUB.Add;
2125: RAISE e_brdn_dtl;
2126: END IF;
2127: ELSIF (p_dtl_tbl(i).burden_uom = FND_API.G_MISS_CHAR AND -- Bug 2659435
2127: ELSIF (p_dtl_tbl(i).burden_uom = FND_API.G_MISS_CHAR AND -- Bug 2659435
2128: p_operation = 'UPDATE') OR
2129: (p_operation = 'INSERT') THEN
2130: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2131: FND_MESSAGE.SET_NAME('GMF','GMF_API_BURDEN_UM_REQ');
2132: FND_MSG_PUB.Add;
2133: RAISE e_brdn_dtl;
2134: END IF;
2135: -- End Burden Unit of Measure
2172:
2173: EXCEPTION
2174: WHEN OTHERS THEN
2175: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2176: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_UM_CONV_ERR');
2177: FND_MESSAGE.SET_TOKEN('RESOURCES',l_resources); -- Bug 2681243: use local variable.
2178: FND_MESSAGE.SET_TOKEN('OVERHEAD_UM',l_burden_uom);
2179: FND_MESSAGE.SET_TOKEN('RESOURCE_UM',l_resource_uom);
2180: FND_MSG_PUB.Add;
2173: EXCEPTION
2174: WHEN OTHERS THEN
2175: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2176: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_UM_CONV_ERR');
2177: FND_MESSAGE.SET_TOKEN('RESOURCES',l_resources); -- Bug 2681243: use local variable.
2178: FND_MESSAGE.SET_TOKEN('OVERHEAD_UM',l_burden_uom);
2179: FND_MESSAGE.SET_TOKEN('RESOURCE_UM',l_resource_uom);
2180: FND_MSG_PUB.Add;
2181: RAISE e_brdn_dtl;
2174: WHEN OTHERS THEN
2175: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2176: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_UM_CONV_ERR');
2177: FND_MESSAGE.SET_TOKEN('RESOURCES',l_resources); -- Bug 2681243: use local variable.
2178: FND_MESSAGE.SET_TOKEN('OVERHEAD_UM',l_burden_uom);
2179: FND_MESSAGE.SET_TOKEN('RESOURCE_UM',l_resource_uom);
2180: FND_MSG_PUB.Add;
2181: RAISE e_brdn_dtl;
2182: END ;
2175: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2176: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_UM_CONV_ERR');
2177: FND_MESSAGE.SET_TOKEN('RESOURCES',l_resources); -- Bug 2681243: use local variable.
2178: FND_MESSAGE.SET_TOKEN('OVERHEAD_UM',l_burden_uom);
2179: FND_MESSAGE.SET_TOKEN('RESOURCE_UM',l_resource_uom);
2180: FND_MSG_PUB.Add;
2181: RAISE e_brdn_dtl;
2182: END ;
2183: END IF;
2193: IF (p_dtl_tbl(i).delete_mark <> FND_API.G_MISS_NUM) AND
2194: (p_dtl_tbl(i).delete_mark IS NOT NULL) THEN
2195: IF p_dtl_tbl(i).delete_mark NOT IN (0,1) THEN
2196: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2197: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_DELETE_MARK');
2198: FND_MESSAGE.SET_TOKEN('DELETE_MARK',p_dtl_tbl(i).delete_mark);
2199: FND_MSG_PUB.Add;
2200: RAISE e_brdn_dtl;
2201: END IF;
2194: (p_dtl_tbl(i).delete_mark IS NOT NULL) THEN
2195: IF p_dtl_tbl(i).delete_mark NOT IN (0,1) THEN
2196: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2197: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_DELETE_MARK');
2198: FND_MESSAGE.SET_TOKEN('DELETE_MARK',p_dtl_tbl(i).delete_mark);
2199: FND_MSG_PUB.Add;
2200: RAISE e_brdn_dtl;
2201: END IF;
2202: ELSIF (p_dtl_tbl(i).delete_mark = FND_API.G_MISS_NUM AND -- Bug 2659435
2202: ELSIF (p_dtl_tbl(i).delete_mark = FND_API.G_MISS_NUM AND -- Bug 2659435
2203: p_operation = 'UPDATE') OR
2204: (p_operation = 'INSERT') THEN
2205: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2206: FND_MESSAGE.SET_NAME('GMF','GMF_API_DELETE_MARK_REQ');
2207: FND_MSG_PUB.Add;
2208: RAISE e_brdn_dtl;
2209: END IF;
2210: IF ((p_operation = 'UPDATE') AND (p_dtl_tbl(i).delete_mark = 1)) THEN
2208: RAISE e_brdn_dtl;
2209: END IF;
2210: IF ((p_operation = 'UPDATE') AND (p_dtl_tbl(i).delete_mark = 1)) THEN
2211: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2212: FND_MESSAGE.SET_NAME('GMF','GMF_API_CANT_MARK_FOR_PURGE');
2213: FND_MSG_PUB.Add;
2214: RAISE e_brdn_dtl;
2215: END IF;
2216: -- End Delete Mark
2227: IF ((p_operation = 'UPDATE') AND
2228: ((p_dtl_tbl(i).burdenline_id <> FND_API.G_MISS_NUM) OR (p_dtl_tbl(i).burdenline_id IS NOT NULL))
2229: ) THEN
2230: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2231: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_BRDN_UNIQUE_KEY');
2232: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID', p_dtl_tbl(i).burdenline_id);
2233: FND_MSG_PUB.Add;
2234: l_burdenline_id := p_dtl_tbl(i).burdenline_id;
2235: END IF ;
2228: ((p_dtl_tbl(i).burdenline_id <> FND_API.G_MISS_NUM) OR (p_dtl_tbl(i).burdenline_id IS NOT NULL))
2229: ) THEN
2230: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2231: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_BRDN_UNIQUE_KEY');
2232: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID', p_dtl_tbl(i).burdenline_id);
2233: FND_MSG_PUB.Add;
2234: l_burdenline_id := p_dtl_tbl(i).burdenline_id;
2235: END IF ;
2236:
2311: IS
2312: BEGIN
2313:
2314: -- IF FND_MSG_PUB.Check_Msg_Level (p_msg_lvl) THEN -- Bug 2659435
2315: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');
2316: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
2317: FND_MSG_PUB.Add;
2318: -- END IF;
2319:
2312: BEGIN
2313:
2314: -- IF FND_MSG_PUB.Check_Msg_Level (p_msg_lvl) THEN -- Bug 2659435
2315: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');
2316: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
2317: FND_MSG_PUB.Add;
2318: -- END IF;
2319:
2320: END log_msg ;
2346: BEGIN
2347:
2348: IF G_header_logged = 'N' THEN
2349: G_header_logged := 'Y';
2350: FND_MESSAGE.SET_NAME('GMF','GMF_API_BURDEN_HEADER');
2351: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header.organization_id);
2352: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header.organization_code);
2353: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header.inventory_item_id);
2354: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER',p_header.item_number);
2347:
2348: IF G_header_logged = 'N' THEN
2349: G_header_logged := 'Y';
2350: FND_MESSAGE.SET_NAME('GMF','GMF_API_BURDEN_HEADER');
2351: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header.organization_id);
2352: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header.organization_code);
2353: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header.inventory_item_id);
2354: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER',p_header.item_number);
2355: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header.period_id);
2348: IF G_header_logged = 'N' THEN
2349: G_header_logged := 'Y';
2350: FND_MESSAGE.SET_NAME('GMF','GMF_API_BURDEN_HEADER');
2351: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header.organization_id);
2352: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header.organization_code);
2353: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header.inventory_item_id);
2354: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER',p_header.item_number);
2355: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header.period_id);
2356: FND_MESSAGE.SET_TOKEN('CALENDAR',p_header.calendar_code);
2349: G_header_logged := 'Y';
2350: FND_MESSAGE.SET_NAME('GMF','GMF_API_BURDEN_HEADER');
2351: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header.organization_id);
2352: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header.organization_code);
2353: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header.inventory_item_id);
2354: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER',p_header.item_number);
2355: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header.period_id);
2356: FND_MESSAGE.SET_TOKEN('CALENDAR',p_header.calendar_code);
2357: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header.period_code);
2350: FND_MESSAGE.SET_NAME('GMF','GMF_API_BURDEN_HEADER');
2351: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header.organization_id);
2352: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header.organization_code);
2353: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header.inventory_item_id);
2354: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER',p_header.item_number);
2355: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header.period_id);
2356: FND_MESSAGE.SET_TOKEN('CALENDAR',p_header.calendar_code);
2357: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header.period_code);
2358: FND_MESSAGE.SET_TOKEN('COSTTYPE_ID',p_header.cost_type_id);
2351: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header.organization_id);
2352: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header.organization_code);
2353: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header.inventory_item_id);
2354: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER',p_header.item_number);
2355: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header.period_id);
2356: FND_MESSAGE.SET_TOKEN('CALENDAR',p_header.calendar_code);
2357: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header.period_code);
2358: FND_MESSAGE.SET_TOKEN('COSTTYPE_ID',p_header.cost_type_id);
2359: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_header.cost_mthd_code);
2352: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header.organization_code);
2353: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header.inventory_item_id);
2354: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER',p_header.item_number);
2355: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header.period_id);
2356: FND_MESSAGE.SET_TOKEN('CALENDAR',p_header.calendar_code);
2357: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header.period_code);
2358: FND_MESSAGE.SET_TOKEN('COSTTYPE_ID',p_header.cost_type_id);
2359: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_header.cost_mthd_code);
2360: FND_MSG_PUB.Add;
2353: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header.inventory_item_id);
2354: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER',p_header.item_number);
2355: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header.period_id);
2356: FND_MESSAGE.SET_TOKEN('CALENDAR',p_header.calendar_code);
2357: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header.period_code);
2358: FND_MESSAGE.SET_TOKEN('COSTTYPE_ID',p_header.cost_type_id);
2359: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_header.cost_mthd_code);
2360: FND_MSG_PUB.Add;
2361: END IF;
2354: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER',p_header.item_number);
2355: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header.period_id);
2356: FND_MESSAGE.SET_TOKEN('CALENDAR',p_header.calendar_code);
2357: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header.period_code);
2358: FND_MESSAGE.SET_TOKEN('COSTTYPE_ID',p_header.cost_type_id);
2359: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_header.cost_mthd_code);
2360: FND_MSG_PUB.Add;
2361: END IF;
2362:
2355: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header.period_id);
2356: FND_MESSAGE.SET_TOKEN('CALENDAR',p_header.calendar_code);
2357: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header.period_code);
2358: FND_MESSAGE.SET_TOKEN('COSTTYPE_ID',p_header.cost_type_id);
2359: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_header.cost_mthd_code);
2360: FND_MSG_PUB.Add;
2361: END IF;
2362:
2363: END add_header_to_error_stack;