DBA Data[Home] [Help]

APPS.GMF_BURDENDETAILS_PUB dependencies on FND_MESSAGE

Line 235: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');

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

Line 240: 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
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;

Line 272: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');

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

Line 278: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');

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:

Line 284: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_INS');

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

Line 285: FND_MESSAGE.SET_TOKEN('NUM_ROWS',x_burdenline_ids.count);

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');

Line 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.

Line 451: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');

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

Line 456: 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
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;

Line 485: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');

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

Line 490: 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
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:

Line 496: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_UPD');

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

Line 497: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_dtl_tbl.count);

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');

Line 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.');

Line 668: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');

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

Line 673: 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
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;

Line 703: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');

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

Line 708: 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
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:

Line 714: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_DEL');

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

Line 715: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_dtl_tbl.count);

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

Line 720: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');

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.');

Line 873: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_ID');

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;

Line 874: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);

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

Line 883: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ORGN_CODE');

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;

Line 884: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header_rec.organization_code);

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

Line 898: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_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

Line 899: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header_rec.organization_code);

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

Line 909: FND_MESSAGE.SET_NAME('GMF','GMF_API_ORGANIZATION_ID_REQ');

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

Line 932: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_ID');

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;

Line 933: FND_MESSAGE.SET_TOKEN('ITEM_ID',p_header_rec.inventory_item_id);

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

Line 942: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ITEM_NO');

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;

Line 943: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);

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

Line 960: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_NO');

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;

Line 961: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);

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

Line 962: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_header_rec.organization_id);

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

Line 972: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_ID_REQ');

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

Line 994: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE_ID');

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;

Line 995: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);

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

Line 1002: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_COST_TYPE');

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;

Line 1003: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_mthd_code);

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

Line 1024: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE');

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

Line 1025: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_header_rec.cost_mthd_code);

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

Line 1035: FND_MESSAGE.SET_NAME('GMF','GMF_API_COST_TYPE_ID_REQ');

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;

Line 1054: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_PERIOD_ID');

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;

Line 1055: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);

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

Line 1063: FND_MESSAGE.SET_NAME('GMF','GMF_API_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;

Line 1064: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_header_rec.calendar_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;
1068: END IF;

Line 1065: FND_MESSAGE.SET_TOKEN('PERIOD_CODE', p_header_rec.period_code);

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

Line 1087: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CLDR_PERIOD');

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;

Line 1088: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE',p_header_rec.calendar_code);

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

Line 1089: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header_rec.period_code);

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

Line 1099: FND_MESSAGE.SET_NAME('GMF','GMF_API_PERIOD_ID_REQ');

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;

Line 1123: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_USER_NAME');

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;

Line 1124: FND_MESSAGE.SET_TOKEN('USER_NAME',p_header_rec.user_name);

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:

Line 1131: FND_MESSAGE.SET_NAME('GMF','GMF_API_USER_NAME_REQ');

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

Line 1338: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_ID');

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;

Line 1339: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);

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:

Line 1349: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ORGN_CODE');

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;

Line 1350: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header_rec.organization_code);

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

Line 1364: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_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

Line 1365: FND_MESSAGE.SET_TOKEN('ORG_CODE',p_header_rec.organization_code);

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

Line 1375: FND_MESSAGE.SET_NAME('GMF','GMF_API_ORGANIZATION_ID_REQ');

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

Line 1397: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_ID');

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;

Line 1398: FND_MESSAGE.SET_TOKEN('ITEM_ID',p_header_rec.inventory_item_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;
1402: -- Log message if item_number is also passed

Line 1407: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ITEM_NO');

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;

Line 1408: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);

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

Line 1424: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_NO');

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;

Line 1425: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);

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

Line 1426: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',x_header_rec.organization_id);

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

Line 1436: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_ID_REQ');

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

Line 1465: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE_ID');

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;

Line 1466: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);

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

Line 1473: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_COST_TYPE');

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;

Line 1474: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_mthd_code);

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

Line 1495: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE');

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

Line 1496: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_header_rec.cost_mthd_code);

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

Line 1506: FND_MESSAGE.SET_NAME('GMF','GMF_API_COST_TYPE_ID_REQ');

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;

Line 1525: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_PERIOD_ID');

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;

Line 1526: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.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;
1530: -- If period code also passed then ignore period code

Line 1534: FND_MESSAGE.SET_NAME('GMF','GMF_API_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;

Line 1535: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_header_rec.calendar_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;
1539: END IF;

Line 1536: FND_MESSAGE.SET_TOKEN('PERIOD_CODE', p_header_rec.period_code);

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

Line 1557: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CLDR_PERIOD');

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;

Line 1558: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE',p_header_rec.calendar_code);

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

Line 1559: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header_rec.period_code);

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

Line 1569: FND_MESSAGE.SET_NAME('GMF','GMF_API_PERIOD_ID_REQ');

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;

Line 1592: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_USER_NAME');

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;

Line 1593: FND_MESSAGE.SET_TOKEN('USER_NAME',p_header_rec.user_name);

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:

Line 1600: FND_MESSAGE.SET_NAME('GMF','GMF_API_USER_NAME_REQ');

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

Line 1675: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_BRDN_UNIQUE_KEY');

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

Line 1676: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID', p_dtl_tbl(i).burdenline_id);

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:

Line 1711: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_BRDN_LINE_ID');

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;

Line 1712: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID',p_dtl_tbl(i).burdenline_id);

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:

Line 1721: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_RESOURCES');

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;

Line 1722: FND_MESSAGE.SET_TOKEN('RESOURCES',p_dtl_tbl(i).resources);

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:

Line 1745: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_RESOURCES');

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;

Line 1746: FND_MESSAGE.SET_TOKEN('RESOURCES',p_dtl_tbl(i).resources);

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

Line 1752: FND_MESSAGE.SET_NAME('GMF','GMF_API_RESOURCES_REQ');

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:

Line 1775: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CMPNTCLS_ID');

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

Line 1776: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',p_dtl_tbl(i).cost_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
1780: add_header_to_error_stack(p_header_rec); -- Bug 2659435

Line 1781: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_USG_NOT_BRDN');

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;

Line 1782: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',p_dtl_tbl(i).cost_cmpntcls_id);

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:

Line 1794: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_CMPNTCLS_CODE');

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;

Line 1795: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_dtl_tbl(i).cost_cmpntcls_code);

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

Line 1821: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CMPNTCLS_CODE');

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

Line 1822: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_dtl_tbl(i).cost_cmpntcls_code);

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

Line 1827: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_USG_NOT_BRDN');

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;

Line 1828: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',l_cost_cmpntcls_id);

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

Line 1834: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_ID_REQ');

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

Line 1852: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ANALYSIS_CODE');

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;

Line 1853: FND_MESSAGE.SET_TOKEN('ANALYSIS_CODE',p_dtl_tbl(i).cost_analysis_code);

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

Line 1859: FND_MESSAGE.SET_NAME('GMF','GMF_API_ANALYSIS_CODE_REQ');

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

Line 1888: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_DTL_NOT_FOUND');

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);

Line 1889: FND_MESSAGE.SET_TOKEN('RESOURCE',l_resources);

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;

Line 1890: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_dtl_tbl(i).cost_cmpntcls_code);

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;

Line 1891: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',l_cost_cmpntcls_id);

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;

Line 1892: FND_MESSAGE.SET_TOKEN('ALYS_CODE',p_dtl_tbl(i).cost_analysis_code);

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;

Line 1929: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_BURDEN_USAGE');

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;

Line 1930: FND_MESSAGE.SET_TOKEN('BURDEN_USAGE',p_dtl_tbl(i).burden_usage);

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: */

Line 1940: FND_MESSAGE.SET_NAME('GMF','GMF_API_BURDEN_USAGE_REQ');

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

Line 1965: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_QTY');

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;

Line 1966: FND_MESSAGE.SET_TOKEN('ITEM_QTY',p_dtl_tbl(i).item_qty);

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

Line 1974: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_QTY_REQ');

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

Line 1993: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_UM');

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;

Line 1994: FND_MESSAGE.SET_TOKEN('ITEM_UOM',p_dtl_tbl(i).item_uom);

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:

Line 2003: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_UM_REQ');

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:

Line 2051: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_UM_CONV_ERR');

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;

Line 2052: FND_MESSAGE.SET_TOKEN('ITEM_ID', x_header_rec.inventory_item_id); --p_header_rec.item_id); Bug# 1935297

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;

Line 2053: FND_MESSAGE.SET_TOKEN('ITEM_UM',l_item_uom);

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 ;

Line 2054: FND_MESSAGE.SET_TOKEN('ITEM_ACT_UM',l_act_item_uom);

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 ;

Line 2079: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_BURDEN_QTY');

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;

Line 2080: FND_MESSAGE.SET_TOKEN('OVERHEAD_QTY',p_dtl_tbl(i).burden_qty);

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

Line 2088: FND_MESSAGE.SET_NAME('GMF','GMF_API_BURDEN_QTY_REQ');

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

Line 2108: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_BURDEN_UM');

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;

Line 2109: FND_MESSAGE.SET_TOKEN('OVERHEAD_UM',p_dtl_tbl(i).burden_uom);

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:

Line 2121: FND_MESSAGE.SET_NAME('GMF','GMF_API_UOM_SAMETYPE_REQ');

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;

Line 2122: FND_MESSAGE.SET_TOKEN('OVERHEAD_UM',p_dtl_tbl(i).burden_uom);

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;

Line 2123: FND_MESSAGE.SET_TOKEN('RESOURCE_UM',l_resource_uom_class);

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

Line 2131: FND_MESSAGE.SET_NAME('GMF','GMF_API_BURDEN_UM_REQ');

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

Line 2176: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_UM_CONV_ERR');

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;

Line 2177: FND_MESSAGE.SET_TOKEN('RESOURCES',l_resources); -- Bug 2681243: use local variable.

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;

Line 2178: FND_MESSAGE.SET_TOKEN('OVERHEAD_UM',l_burden_uom);

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 ;

Line 2179: FND_MESSAGE.SET_TOKEN('RESOURCE_UM',l_resource_uom);

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;

Line 2197: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_DELETE_MARK');

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;

Line 2198: FND_MESSAGE.SET_TOKEN('DELETE_MARK',p_dtl_tbl(i).delete_mark);

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

Line 2206: FND_MESSAGE.SET_NAME('GMF','GMF_API_DELETE_MARK_REQ');

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

Line 2212: FND_MESSAGE.SET_NAME('GMF','GMF_API_CANT_MARK_FOR_PURGE');

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

Line 2231: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_BRDN_UNIQUE_KEY');

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 ;

Line 2232: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID', p_dtl_tbl(i).burdenline_id);

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:

Line 2315: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');

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:

Line 2316: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);

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 ;

Line 2350: FND_MESSAGE.SET_NAME('GMF','GMF_API_BURDEN_HEADER');

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);

Line 2351: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header.organization_id);

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);

Line 2352: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header.organization_code);

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);

Line 2353: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header.inventory_item_id);

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);

Line 2354: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER',p_header.item_number);

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);

Line 2355: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header.period_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);

Line 2356: FND_MESSAGE.SET_TOKEN('CALENDAR',p_header.calendar_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;

Line 2357: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header.period_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;
2361: END IF;

Line 2358: FND_MESSAGE.SET_TOKEN('COSTTYPE_ID',p_header.cost_type_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;
2362:

Line 2359: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_header.cost_mthd_code);

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;