APPS.AHL_UMP_UF_PVT dependencies on FND_MSG_PUB

Line 141: FND_MSG_PUB.Initialize;

137:
138: -- Initialize message list if p_init_msg_list is set to TRUE
139: IF FND_API.To_Boolean( p_init_msg_list)
140: THEN
141: FND_MSG_PUB.Initialize;
142: END IF;
143:
144: -- Initialize API return status to success
145: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 161: x_msg_count := FND_MSG_PUB.count_msg;

157: p_validation_level => p_validation_level,
158: p_x_uf_header_rec => p_x_uf_header_rec
159: );
160: -- Check Error Message stack.
161: x_msg_count := FND_MSG_PUB.count_msg;
162: IF x_msg_count > 0 THEN
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165:

Line 176: x_msg_count := FND_MSG_PUB.count_msg;

172: );
173: END IF;
174:
175: -- Check Error Message stack.
176: x_msg_count := FND_MSG_PUB.count_msg;
177: IF x_msg_count > 0 THEN
178: RAISE FND_API.G_EXC_ERROR;
179: END IF;
180:

Line 186: x_msg_count := FND_MSG_PUB.count_msg;

182: -- post processing to delete header if use unit forecast is 'N' and there are no uf_details.
183: post_process_uf_header(p_uf_header_rec => p_x_uf_header_rec);
184:
185: -- Check Error Message stack.
186: x_msg_count := FND_MSG_PUB.count_msg;
187: IF x_msg_count > 0 THEN
188: RAISE FND_API.G_EXC_ERROR;
189: END IF;
190:

Line 197: FND_MSG_PUB.Count_And_Get

193: COMMIT WORK;
194: END IF;
195:
196: -- Standard call to get message count and if count is 1, get message info
197: FND_MSG_PUB.Count_And_Get
198: ( p_count => x_msg_count,
199: p_data => x_msg_data,
200: p_encoded => fnd_api.g_false
201: );

Line 216: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

212: EXCEPTION
213: WHEN FND_API.G_EXC_ERROR THEN
214: Rollback to process_uf_pvt;
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
217: p_data => x_msg_data,
218: p_encoded => fnd_api.g_false);
219: -- Disable debug
220: IF G_DEBUG = 'Y' THEN

Line 228: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

224:
225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
226: Rollback to process_uf_pvt;
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
229: p_data => x_msg_data,
230: p_encoded => fnd_api.g_false);
231: -- Disable debug
232: IF G_DEBUG = 'Y' THEN

Line 239: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

235:
236: WHEN OTHERS THEN
237: Rollback to process_uf_pvt;
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
240: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
241: p_procedure_name => l_api_name,
242: p_error_text => SUBSTR(SQLERRM,1,500));
243: END IF;

Line 240: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

236: WHEN OTHERS THEN
237: Rollback to process_uf_pvt;
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
240: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
241: p_procedure_name => l_api_name,
242: p_error_text => SUBSTR(SQLERRM,1,500));
243: END IF;
244: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 244: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

240: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
241: p_procedure_name => l_api_name,
242: p_error_text => SUBSTR(SQLERRM,1,500));
243: END IF;
244: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
245: p_data => x_msg_data,
246: p_encoded => fnd_api.g_false);
247: -- Disable debug
248: IF G_DEBUG = 'Y' THEN

Line 380: IF FND_MSG_PUB.count_msg > 0 THEN

376: ELSIF (p_x_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_PC_NODE)THEN
377: convert_node_header_val_to_id(p_x_uf_header_rec);
378: END IF;
379:
380: IF FND_MSG_PUB.count_msg > 0 THEN
381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
382: END IF;
383:
384: END convert_uf_header_val_to_id;

Line 411: FND_MSG_PUB.ADD;

407:
408: IF(p_x_uf_header_rec.uf_header_id IS NULL) THEN
409: IF(p_x_uf_header_rec.unit_config_header_id IS NULL AND p_x_uf_header_rec.unit_name IS NULL) THEN
410: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFHID_UCHID_NLL');
411: FND_MSG_PUB.ADD;
412: ELSIF (p_x_uf_header_rec.unit_config_header_id IS NULL AND p_x_uf_header_rec.unit_name IS NOT NULL) THEN
413: OPEN unit_config_header_id_csr(p_x_uf_header_rec.unit_name);
414: FETCH unit_config_header_id_csr INTO l_unit_config_header_id;
415: IF(unit_config_header_id_csr%NOTFOUND) THEN

Line 417: FND_MSG_PUB.ADD;

413: OPEN unit_config_header_id_csr(p_x_uf_header_rec.unit_name);
414: FETCH unit_config_header_id_csr INTO l_unit_config_header_id;
415: IF(unit_config_header_id_csr%NOTFOUND) THEN
416: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_INV');
417: FND_MSG_PUB.ADD;
418: ELSE
419: p_x_uf_header_rec.unit_config_header_id := l_unit_config_header_id;
420: END IF;
421: CLOSE unit_config_header_id_csr;

Line 430: FND_MSG_PUB.ADD;

426: OPEN uf_header_id_uid_csr(p_x_uf_header_rec.unit_config_header_id);
427: FETCH uf_header_id_uid_csr INTO l_uf_header_id;
428: IF(uf_header_id_uid_csr%NOTFOUND)THEN
429: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HREC_NOTINDB');
430: FND_MSG_PUB.ADD;
431: ELSE
432: p_x_uf_header_rec.uf_header_id := l_uf_header_id;
433: END IF;
434: CLOSE uf_header_id_uid_csr;

Line 466: FND_MSG_PUB.ADD;

462: BEGIN
463: IF(p_x_uf_header_rec.uf_header_id IS NULL) THEN
464: IF(p_x_uf_header_rec.inventory_item_id IS NULL AND p_x_uf_header_rec.inventory_item_name IS NULL) THEN
465: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_INVID_NLL');
466: FND_MSG_PUB.ADD;
467: ELSIF (p_x_uf_header_rec.inventory_item_id IS NULL AND p_x_uf_header_rec.inventory_item_name IS NOT NULL) THEN
468: OPEN inventory_item_id_csr(p_x_uf_header_rec.inventory_item_name);
469: FETCH inventory_item_id_csr INTO l_inventory_item_id;
470: IF(inventory_item_id_csr%NOTFOUND) THEN

Line 472: FND_MSG_PUB.ADD;

468: OPEN inventory_item_id_csr(p_x_uf_header_rec.inventory_item_name);
469: FETCH inventory_item_id_csr INTO l_inventory_item_id;
470: IF(inventory_item_id_csr%NOTFOUND) THEN
471: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_INV');
472: FND_MSG_PUB.ADD;
473: ELSE
474: p_x_uf_header_rec.inventory_item_id := l_inventory_item_id;
475: END IF;
476: CLOSE inventory_item_id_csr;

Line 485: FND_MSG_PUB.ADD;

481: OPEN uf_header_id_pid_csr(p_x_uf_header_rec.inventory_item_id);
482: FETCH uf_header_id_pid_csr INTO l_uf_header_id;
483: IF(uf_header_id_pid_csr%NOTFOUND)THEN
484: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HREC_NOTINDB');
485: FND_MSG_PUB.ADD;
486: ELSE
487: p_x_uf_header_rec.uf_header_id := l_uf_header_id;
488: END IF;
489: CLOSE uf_header_id_pid_csr;

Line 514: FND_MSG_PUB.ADD;

510: IF p_x_uf_header_rec.operation_flag <> AHL_UMP_UF_PVT.G_OP_CREATE THEN
511: IF(p_x_uf_header_rec.uf_header_id IS NULL) THEN
512: IF(p_x_uf_header_rec.pc_node_id IS NULL) THEN
513: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_NODEID_NLL');
514: FND_MSG_PUB.ADD;
515: ELSE
516: OPEN uf_header_id_nid_csr(p_x_uf_header_rec.pc_node_id);
517: FETCH uf_header_id_nid_csr INTO l_uf_header_id;
518: IF(uf_header_id_nid_csr%NOTFOUND)THEN

Line 520: FND_MSG_PUB.ADD;

516: OPEN uf_header_id_nid_csr(p_x_uf_header_rec.pc_node_id);
517: FETCH uf_header_id_nid_csr INTO l_uf_header_id;
518: IF(uf_header_id_nid_csr%NOTFOUND)THEN
519: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HREC_NOTINDB');
520: FND_MSG_PUB.ADD;
521: ELSE
522: p_x_uf_header_rec.uf_header_id := l_uf_header_id;
523: END IF;
524: CLOSE uf_header_id_nid_csr;

Line 604: FND_MSG_PUB.ADD;

600:
601: -- Operation Flag and Header ID validation.
602: IF (p_uf_header_rec.forecast_type NOT IN(AHL_UMP_UF_PVT.G_UF_TYPE_UNIT,AHL_UMP_UF_PVT.G_UF_TYPE_PART,AHL_UMP_UF_PVT.G_UF_TYPE_PC_NODE))THEN
603: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UF_TYPE');
604: FND_MSG_PUB.ADD;
605: ELSIF (p_uf_header_rec.operation_flag IS NOT NULL AND p_uf_header_rec.operation_flag NOT IN(AHL_UMP_UF_PVT.G_OP_CREATE,AHL_UMP_UF_PVT.G_OP_UPDATE,AHL_UMP_UF_PVT.G_OP_DELETE))THEN
606: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HEADER');
607: FND_MSG_PUB.ADD;
608: ELSIF ((p_uf_header_rec.uf_header_id IS NULL)

Line 607: FND_MSG_PUB.ADD;

603: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UF_TYPE');
604: FND_MSG_PUB.ADD;
605: ELSIF (p_uf_header_rec.operation_flag IS NOT NULL AND p_uf_header_rec.operation_flag NOT IN(AHL_UMP_UF_PVT.G_OP_CREATE,AHL_UMP_UF_PVT.G_OP_UPDATE,AHL_UMP_UF_PVT.G_OP_DELETE))THEN
606: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HEADER');
607: FND_MSG_PUB.ADD;
608: ELSIF ((p_uf_header_rec.uf_header_id IS NULL)
609: AND (p_uf_header_rec.operation_flag IS NULL OR p_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE)) THEN
610: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_UFHID_NLL');
611: FND_MSG_PUB.ADD;

Line 611: FND_MSG_PUB.ADD;

607: FND_MSG_PUB.ADD;
608: ELSIF ((p_uf_header_rec.uf_header_id IS NULL)
609: AND (p_uf_header_rec.operation_flag IS NULL OR p_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE)) THEN
610: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_UFHID_NLL');
611: FND_MSG_PUB.ADD;
612: ELSIF(p_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE AND
613: p_uf_header_rec.uf_header_id IS NOT NULL ) THEN
614: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_UFHID_N_NLL');
615: FND_MSG_PUB.ADD;

Line 615: FND_MSG_PUB.ADD;

611: FND_MSG_PUB.ADD;
612: ELSIF(p_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE AND
613: p_uf_header_rec.uf_header_id IS NOT NULL ) THEN
614: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_UFHID_N_NLL');
615: FND_MSG_PUB.ADD;
616: END IF;
617:
618:
619:

Line 620: IF(FND_MSG_PUB.count_msg > 0)THEN

616: END IF;
617:
618:
619:
620: IF(FND_MSG_PUB.count_msg > 0)THEN
621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
622: END IF;
623:
624: IF (( p_uf_header_rec.operation_flag IS NULL OR p_uf_header_rec.operation_flag <> AHL_UMP_UF_PVT.G_OP_CREATE) AND p_uf_header_rec.uf_header_id IS NOT NULL)THEN

Line 629: FND_MSG_PUB.ADD;

625: OPEN uf_header_csr(p_uf_header_rec.uf_header_id);
626: FETCH uf_header_csr INTO l_object_version_number, l_unit_config_header_id,l_pc_node_id,l_inventory_item_id,l_inventory_org_id,l_use_unit_flag;
627: IF (uf_header_csr%NOTFOUND) THEN
628: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HREC_NOTINDB');
629: FND_MSG_PUB.ADD;
630: ELSIF (l_object_version_number <> p_uf_header_rec.object_version_number)THEN
631: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_HREC_OBJV_MIS');
632: FND_MSG_PUB.ADD;
633: END IF;

Line 632: FND_MSG_PUB.ADD;

628: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HREC_NOTINDB');
629: FND_MSG_PUB.ADD;
630: ELSIF (l_object_version_number <> p_uf_header_rec.object_version_number)THEN
631: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_HREC_OBJV_MIS');
632: FND_MSG_PUB.ADD;
633: END IF;
634: CLOSE uf_header_csr;
635:
636: IF(FND_MSG_PUB.count_msg > 0)THEN

Line 636: IF(FND_MSG_PUB.count_msg > 0)THEN

632: FND_MSG_PUB.ADD;
633: END IF;
634: CLOSE uf_header_csr;
635:
636: IF(FND_MSG_PUB.count_msg > 0)THEN
637: RAISE FND_API.G_EXC_ERROR;
638: END IF;
639:
640: IF(p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_UNIT) THEN

Line 643: FND_MSG_PUB.ADD;

639:
640: IF(p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_UNIT) THEN
641: IF(p_uf_header_rec.unit_config_header_id = FND_API.G_MISS_NUM)THEN
642: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFHID_UCHID_NLL');
643: FND_MSG_PUB.ADD;
644: ELSIF (p_uf_header_rec.unit_config_header_id IS NOT NULL AND
645: p_uf_header_rec.unit_config_header_id <> l_unit_config_header_id )THEN FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UCHID_MIS');
646: FND_MSG_PUB.ADD;
647: ELSE

Line 646: FND_MSG_PUB.ADD;

642: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFHID_UCHID_NLL');
643: FND_MSG_PUB.ADD;
644: ELSIF (p_uf_header_rec.unit_config_header_id IS NOT NULL AND
645: p_uf_header_rec.unit_config_header_id <> l_unit_config_header_id )THEN FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UCHID_MIS');
646: FND_MSG_PUB.ADD;
647: ELSE
648: OPEN unit_status_check_csr(l_unit_config_header_id);
649: FETCH unit_status_check_csr INTO l_unit_config_status_code;
650: IF (unit_status_check_csr%NOTFOUND) THEN

Line 652: FND_MSG_PUB.ADD;

648: OPEN unit_status_check_csr(l_unit_config_header_id);
649: FETCH unit_status_check_csr INTO l_unit_config_status_code;
650: IF (unit_status_check_csr%NOTFOUND) THEN
651: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_INV');
652: FND_MSG_PUB.ADD;
653: ELSIF (l_unit_config_status_code = AHL_UMP_UF_PVT.G_DRAFT_STATUS)THEN
654: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UC_STATUS_DRAFT');
655: FND_MSG_PUB.ADD;
656: END IF;

Line 655: FND_MSG_PUB.ADD;

651: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_INV');
652: FND_MSG_PUB.ADD;
653: ELSIF (l_unit_config_status_code = AHL_UMP_UF_PVT.G_DRAFT_STATUS)THEN
654: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UC_STATUS_DRAFT');
655: FND_MSG_PUB.ADD;
656: END IF;
657: CLOSE unit_status_check_csr;
658:
659: OPEN pc_status_check_up_csr(l_unit_config_header_id,AHL_UMP_UF_PVT.G_PC_UNIT_ASSOCIATION);

Line 663: FND_MSG_PUB.ADD;

659: OPEN pc_status_check_up_csr(l_unit_config_header_id,AHL_UMP_UF_PVT.G_PC_UNIT_ASSOCIATION);
660: FETCH pc_status_check_up_csr INTO l_pc_primary_flag,l_pc_status;
661: IF (pc_status_check_up_csr%NOTFOUND) THEN
662: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_PC_INV');
663: FND_MSG_PUB.ADD;
664: ELSIF (l_pc_primary_flag <> AHL_UMP_UF_PVT.G_PC_PRIMARY_FLAG OR l_pc_status <> AHL_UMP_UF_PVT.G_COMPLETE_STATUS) THEN
665: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_PC_INV');
666: FND_MSG_PUB.ADD;
667: END IF;

Line 666: FND_MSG_PUB.ADD;

662: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_PC_INV');
663: FND_MSG_PUB.ADD;
664: ELSIF (l_pc_primary_flag <> AHL_UMP_UF_PVT.G_PC_PRIMARY_FLAG OR l_pc_status <> AHL_UMP_UF_PVT.G_COMPLETE_STATUS) THEN
665: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_PC_INV');
666: FND_MSG_PUB.ADD;
667: END IF;
668: CLOSE pc_status_check_up_csr;
669:
670:

Line 675: FND_MSG_PUB.ADD;

671: END IF;
672: ELSIF(p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_PART) THEN
673: IF(p_uf_header_rec.inventory_item_id = FND_API.G_MISS_NUM)THEN
674: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_INVID_NLL');
675: FND_MSG_PUB.ADD;
676: ELSIF (p_uf_header_rec.inventory_item_id IS NOT NULL AND
677: p_uf_header_rec.inventory_item_id <> l_inventory_item_id )THEN
678: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVID_MIS');
679: FND_MSG_PUB.ADD;

Line 679: FND_MSG_PUB.ADD;

675: FND_MSG_PUB.ADD;
676: ELSIF (p_uf_header_rec.inventory_item_id IS NOT NULL AND
677: p_uf_header_rec.inventory_item_id <> l_inventory_item_id )THEN
678: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVID_MIS');
679: FND_MSG_PUB.ADD;
680: ELSE
681: OPEN part_check_csr(l_inventory_item_id);
682: FETCH part_check_csr INTO l_exists;
683: IF (part_check_csr%NOTFOUND) THEN

Line 685: FND_MSG_PUB.ADD;

681: OPEN part_check_csr(l_inventory_item_id);
682: FETCH part_check_csr INTO l_exists;
683: IF (part_check_csr%NOTFOUND) THEN
684: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_INV');
685: FND_MSG_PUB.ADD;
686: END IF;
687: CLOSE part_check_csr;
688:
689: OPEN pc_status_check_up_csr(l_inventory_item_id,AHL_UMP_UF_PVT.G_PC_ITEM_ASSOCIATION);

Line 693: FND_MSG_PUB.ADD;

689: OPEN pc_status_check_up_csr(l_inventory_item_id,AHL_UMP_UF_PVT.G_PC_ITEM_ASSOCIATION);
690: FETCH pc_status_check_up_csr INTO l_pc_primary_flag,l_pc_status;
691: IF (pc_status_check_up_csr%NOTFOUND) THEN
692: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_PC_INV');
693: FND_MSG_PUB.ADD;
694: ELSIF (l_pc_primary_flag <> AHL_UMP_UF_PVT.G_PC_PRIMARY_FLAG OR l_pc_status <> AHL_UMP_UF_PVT.G_COMPLETE_STATUS) THEN
695: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_PC_INV');
696: FND_MSG_PUB.ADD;
697: END IF;

Line 696: FND_MSG_PUB.ADD;

692: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_PC_INV');
693: FND_MSG_PUB.ADD;
694: ELSIF (l_pc_primary_flag <> AHL_UMP_UF_PVT.G_PC_PRIMARY_FLAG OR l_pc_status <> AHL_UMP_UF_PVT.G_COMPLETE_STATUS) THEN
695: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_PC_INV');
696: FND_MSG_PUB.ADD;
697: END IF;
698: CLOSE pc_status_check_up_csr;
699:
700: END IF;

Line 704: FND_MSG_PUB.ADD;

700: END IF;
701: ELSIF(p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_PC_NODE) THEN
702: IF(p_uf_header_rec.pc_node_id = FND_API.G_MISS_NUM)THEN
703: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_NODEID_NLL');
704: FND_MSG_PUB.ADD;
705: ELSIF (p_uf_header_rec.pc_node_id IS NOT NULL AND
706: p_uf_header_rec.pc_node_id <> l_pc_node_id )THEN
707: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_NODEID_MIS');
708: FND_MSG_PUB.ADD;

Line 708: FND_MSG_PUB.ADD;

704: FND_MSG_PUB.ADD;
705: ELSIF (p_uf_header_rec.pc_node_id IS NOT NULL AND
706: p_uf_header_rec.pc_node_id <> l_pc_node_id )THEN
707: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_NODEID_MIS');
708: FND_MSG_PUB.ADD;
709: ELSE
710: OPEN pc_status_check_n_csr(l_pc_node_id);
711: FETCH pc_status_check_n_csr INTO l_pc_primary_flag,l_pc_status;
712: IF (pc_status_check_n_csr%NOTFOUND) THEN

Line 714: FND_MSG_PUB.ADD;

710: OPEN pc_status_check_n_csr(l_pc_node_id);
711: FETCH pc_status_check_n_csr INTO l_pc_primary_flag,l_pc_status;
712: IF (pc_status_check_n_csr%NOTFOUND) THEN
713: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_NODE_PC_INV');
714: FND_MSG_PUB.ADD;
715: ELSIF (l_pc_primary_flag <> AHL_UMP_UF_PVT.G_PC_PRIMARY_FLAG OR l_pc_status <> AHL_UMP_UF_PVT.G_COMPLETE_STATUS) THEN
716: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_NODE_PC_INV');
717: FND_MSG_PUB.ADD;
718: END IF;

Line 717: FND_MSG_PUB.ADD;

713: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_NODE_PC_INV');
714: FND_MSG_PUB.ADD;
715: ELSIF (l_pc_primary_flag <> AHL_UMP_UF_PVT.G_PC_PRIMARY_FLAG OR l_pc_status <> AHL_UMP_UF_PVT.G_COMPLETE_STATUS) THEN
716: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_NODE_PC_INV');
717: FND_MSG_PUB.ADD;
718: END IF;
719: CLOSE pc_status_check_n_csr;
720:
721: END IF;

Line 729: FND_MSG_PUB.ADD;

725: IF(p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_UNIT) THEN
726: IF(p_uf_header_rec.unit_config_header_id IS NULL OR
727: p_uf_header_rec.unit_config_header_id = FND_API.G_MISS_NUM) THEN
728: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFHID_UCHID_NLL');
729: FND_MSG_PUB.ADD;
730: ELSE
731: OPEN unit_status_check_csr(p_uf_header_rec.unit_config_header_id);
732: FETCH unit_status_check_csr INTO l_unit_config_status_code;
733: IF (unit_status_check_csr%NOTFOUND) THEN

Line 735: FND_MSG_PUB.ADD;

731: OPEN unit_status_check_csr(p_uf_header_rec.unit_config_header_id);
732: FETCH unit_status_check_csr INTO l_unit_config_status_code;
733: IF (unit_status_check_csr%NOTFOUND) THEN
734: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_INV');
735: FND_MSG_PUB.ADD;
736: ELSIF (l_unit_config_status_code = AHL_UMP_UF_PVT.G_DRAFT_STATUS)THEN
737: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UC_STATUS_DRAFT');
738: FND_MSG_PUB.ADD;
739: END IF;

Line 738: FND_MSG_PUB.ADD;

734: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_INV');
735: FND_MSG_PUB.ADD;
736: ELSIF (l_unit_config_status_code = AHL_UMP_UF_PVT.G_DRAFT_STATUS)THEN
737: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UC_STATUS_DRAFT');
738: FND_MSG_PUB.ADD;
739: END IF;
740: CLOSE unit_status_check_csr;
741:
742: OPEN pc_status_check_up_csr(p_uf_header_rec.unit_config_header_id, AHL_UMP_UF_PVT.G_PC_UNIT_ASSOCIATION);

Line 746: FND_MSG_PUB.ADD;

742: OPEN pc_status_check_up_csr(p_uf_header_rec.unit_config_header_id, AHL_UMP_UF_PVT.G_PC_UNIT_ASSOCIATION);
743: FETCH pc_status_check_up_csr INTO l_pc_primary_flag,l_pc_status;
744: IF (pc_status_check_up_csr%NOTFOUND) THEN
745: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_PC_INV');
746: FND_MSG_PUB.ADD;
747: ELSIF (l_pc_primary_flag <> AHL_UMP_UF_PVT.G_PC_PRIMARY_FLAG OR l_pc_status <> AHL_UMP_UF_PVT.G_COMPLETE_STATUS) THEN
748: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_PC_INV');
749: FND_MSG_PUB.ADD;
750: END IF;

Line 749: FND_MSG_PUB.ADD;

745: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_PC_INV');
746: FND_MSG_PUB.ADD;
747: ELSIF (l_pc_primary_flag <> AHL_UMP_UF_PVT.G_PC_PRIMARY_FLAG OR l_pc_status <> AHL_UMP_UF_PVT.G_COMPLETE_STATUS) THEN
748: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_PC_INV');
749: FND_MSG_PUB.ADD;
750: END IF;
751: CLOSE pc_status_check_up_csr;
752:
753: END IF;

Line 758: FND_MSG_PUB.ADD;

754: ELSIF (p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_PART) THEN
755: IF(p_uf_header_rec.inventory_item_id IS NULL OR
756: p_uf_header_rec.inventory_item_id = FND_API.G_MISS_NUM) THEN
757: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_INVID_NLL');
758: FND_MSG_PUB.ADD;
759: ELSE
760: OPEN part_check_csr(p_uf_header_rec.inventory_item_id);
761: FETCH part_check_csr INTO l_exists;
762: IF (part_check_csr%NOTFOUND) THEN

Line 764: FND_MSG_PUB.ADD;

760: OPEN part_check_csr(p_uf_header_rec.inventory_item_id);
761: FETCH part_check_csr INTO l_exists;
762: IF (part_check_csr%NOTFOUND) THEN
763: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_INV');
764: FND_MSG_PUB.ADD;
765: END IF;
766: CLOSE part_check_csr;
767:
768: OPEN pc_status_check_up_csr(p_uf_header_rec.inventory_item_id, AHL_UMP_UF_PVT.G_PC_ITEM_ASSOCIATION);

Line 772: FND_MSG_PUB.ADD;

768: OPEN pc_status_check_up_csr(p_uf_header_rec.inventory_item_id, AHL_UMP_UF_PVT.G_PC_ITEM_ASSOCIATION);
769: FETCH pc_status_check_up_csr INTO l_pc_primary_flag,l_pc_status;
770: IF (pc_status_check_up_csr%NOTFOUND) THEN
771: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_PC_INV');
772: FND_MSG_PUB.ADD;
773: ELSIF (l_pc_primary_flag <> AHL_UMP_UF_PVT.G_PC_PRIMARY_FLAG OR l_pc_status <> AHL_UMP_UF_PVT.G_COMPLETE_STATUS) THEN
774: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_PC_INV');
775: FND_MSG_PUB.ADD;
776: END IF;

Line 775: FND_MSG_PUB.ADD;

771: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_PC_INV');
772: FND_MSG_PUB.ADD;
773: ELSIF (l_pc_primary_flag <> AHL_UMP_UF_PVT.G_PC_PRIMARY_FLAG OR l_pc_status <> AHL_UMP_UF_PVT.G_COMPLETE_STATUS) THEN
774: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_PC_INV');
775: FND_MSG_PUB.ADD;
776: END IF;
777: CLOSE pc_status_check_up_csr;
778:
779: END IF;

Line 784: FND_MSG_PUB.ADD;

780: ELSIF (p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_PC_NODE) THEN
781: IF(p_uf_header_rec.pc_node_id IS NULL OR
782: p_uf_header_rec.pc_node_id = FND_API.G_MISS_NUM) THEN
783: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_NODEID_NLL');
784: FND_MSG_PUB.ADD;
785: ELSE
786: OPEN pc_status_check_n_csr(p_uf_header_rec.pc_node_id);
787: FETCH pc_status_check_n_csr INTO l_pc_primary_flag,l_pc_status;
788: IF (pc_status_check_n_csr%NOTFOUND) THEN

Line 790: FND_MSG_PUB.ADD;

786: OPEN pc_status_check_n_csr(p_uf_header_rec.pc_node_id);
787: FETCH pc_status_check_n_csr INTO l_pc_primary_flag,l_pc_status;
788: IF (pc_status_check_n_csr%NOTFOUND) THEN
789: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_NODE_PC_INV');
790: FND_MSG_PUB.ADD;
791: ELSIF (l_pc_primary_flag <> AHL_UMP_UF_PVT.G_PC_PRIMARY_FLAG OR l_pc_status <> AHL_UMP_UF_PVT.G_COMPLETE_STATUS) THEN
792: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_NODE_PC_INV');
793: FND_MSG_PUB.ADD;
794: END IF;

Line 793: FND_MSG_PUB.ADD;

789: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_NODE_PC_INV');
790: FND_MSG_PUB.ADD;
791: ELSIF (l_pc_primary_flag <> AHL_UMP_UF_PVT.G_PC_PRIMARY_FLAG OR l_pc_status <> AHL_UMP_UF_PVT.G_COMPLETE_STATUS) THEN
792: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_NODE_PC_INV');
793: FND_MSG_PUB.ADD;
794: END IF;
795: CLOSE pc_status_check_n_csr;
796: END IF;
797: END IF;

Line 800: FND_MSG_PUB.ADD;

796: END IF;
797: END IF;
798: ELSE
799: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_HEADER');
800: FND_MSG_PUB.ADD;
801: END IF;
802:
803: IF(FND_MSG_PUB.count_msg > 0)THEN
804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 803: IF(FND_MSG_PUB.count_msg > 0)THEN

799: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_HEADER');
800: FND_MSG_PUB.ADD;
801: END IF;
802:
803: IF(FND_MSG_PUB.count_msg > 0)THEN
804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
805: END IF;
806:
807: IF((p_uf_header_rec.use_unit_flag IS NOT NULL OR p_uf_header_rec.use_unit_flag <> FND_API.G_MISS_CHAR)

Line 810: FND_MSG_PUB.ADD;

806:
807: IF((p_uf_header_rec.use_unit_flag IS NOT NULL OR p_uf_header_rec.use_unit_flag <> FND_API.G_MISS_CHAR)
808: AND p_uf_header_rec.use_unit_flag NOT IN (AHL_UMP_UF_PVT.G_UF_USE_UNIT_DEFAULT,AHL_UMP_UF_PVT.G_UF_USE_UNIT_YES)) THEN
809: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UNT_FLG');
810: FND_MSG_PUB.ADD;
811: END IF;
812:
813: IF(FND_MSG_PUB.count_msg > 0)THEN
814: RAISE FND_API.G_EXC_ERROR;

Line 813: IF(FND_MSG_PUB.count_msg > 0)THEN

809: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UNT_FLG');
810: FND_MSG_PUB.ADD;
811: END IF;
812:
813: IF(FND_MSG_PUB.count_msg > 0)THEN
814: RAISE FND_API.G_EXC_ERROR;
815: END IF;
816:
817:

Line 867: FND_MSG_PUB.ADD;

863: BEGIN
864: -- Operation Flag and Header ID validation.
865: IF (p_uf_header_rec.forecast_type NOT IN(AHL_UMP_UF_PVT.G_UF_TYPE_PART,AHL_UMP_UF_PVT.G_UF_TYPE_INSTANCE))THEN
866: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UF_TYPE');
867: FND_MSG_PUB.ADD;
868: ELSIF (p_uf_header_rec.operation_flag IS NOT NULL AND p_uf_header_rec.operation_flag NOT IN(AHL_UMP_UF_PVT.G_OP_CREATE,AHL_UMP_UF_PVT.G_OP_UPDATE,AHL_UMP_UF_PVT.G_OP_DELETE))THEN
869: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HEADER');
870: FND_MSG_PUB.ADD;
871: ELSIF ((p_uf_header_rec.uf_header_id IS NULL)

Line 870: FND_MSG_PUB.ADD;

866: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UF_TYPE');
867: FND_MSG_PUB.ADD;
868: ELSIF (p_uf_header_rec.operation_flag IS NOT NULL AND p_uf_header_rec.operation_flag NOT IN(AHL_UMP_UF_PVT.G_OP_CREATE,AHL_UMP_UF_PVT.G_OP_UPDATE,AHL_UMP_UF_PVT.G_OP_DELETE))THEN
869: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HEADER');
870: FND_MSG_PUB.ADD;
871: ELSIF ((p_uf_header_rec.uf_header_id IS NULL)
872: AND (p_uf_header_rec.operation_flag IS NULL OR p_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE)) THEN
873: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_UFHID_NLL');
874: FND_MSG_PUB.ADD;

Line 874: FND_MSG_PUB.ADD;

870: FND_MSG_PUB.ADD;
871: ELSIF ((p_uf_header_rec.uf_header_id IS NULL)
872: AND (p_uf_header_rec.operation_flag IS NULL OR p_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE)) THEN
873: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_UFHID_NLL');
874: FND_MSG_PUB.ADD;
875: ELSIF(p_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE AND
876: p_uf_header_rec.uf_header_id IS NOT NULL ) THEN
877: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_UFHID_N_NLL');
878: FND_MSG_PUB.ADD;

Line 878: FND_MSG_PUB.ADD;

874: FND_MSG_PUB.ADD;
875: ELSIF(p_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE AND
876: p_uf_header_rec.uf_header_id IS NOT NULL ) THEN
877: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_UFHID_N_NLL');
878: FND_MSG_PUB.ADD;
879: END IF;
880:
881:
882:

Line 883: IF(FND_MSG_PUB.count_msg > 0)THEN

879: END IF;
880:
881:
882:
883: IF(FND_MSG_PUB.count_msg > 0)THEN
884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
885: END IF;
886:
887: IF (( p_uf_header_rec.operation_flag IS NULL OR p_uf_header_rec.operation_flag <> AHL_UMP_UF_PVT.G_OP_CREATE) AND p_uf_header_rec.uf_header_id IS NOT NULL)THEN

Line 892: FND_MSG_PUB.ADD;

888: OPEN uf_header_csr(p_uf_header_rec.uf_header_id);
889: FETCH uf_header_csr INTO l_object_version_number, l_inventory_item_id,l_csi_item_instance_id,l_use_unit_flag;
890: IF (uf_header_csr%NOTFOUND) THEN
891: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HREC_NOTINDB');
892: FND_MSG_PUB.ADD;
893: ELSIF (l_object_version_number <> p_uf_header_rec.object_version_number)THEN
894: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_HREC_OBJV_MIS');
895: FND_MSG_PUB.ADD;
896: END IF;

Line 895: FND_MSG_PUB.ADD;

891: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HREC_NOTINDB');
892: FND_MSG_PUB.ADD;
893: ELSIF (l_object_version_number <> p_uf_header_rec.object_version_number)THEN
894: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_HREC_OBJV_MIS');
895: FND_MSG_PUB.ADD;
896: END IF;
897: CLOSE uf_header_csr;
898:
899: IF(FND_MSG_PUB.count_msg > 0)THEN

Line 899: IF(FND_MSG_PUB.count_msg > 0)THEN

895: FND_MSG_PUB.ADD;
896: END IF;
897: CLOSE uf_header_csr;
898:
899: IF(FND_MSG_PUB.count_msg > 0)THEN
900: RAISE FND_API.G_EXC_ERROR;
901: END IF;
902:
903: IF(p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_PART) THEN

Line 906: FND_MSG_PUB.ADD;

902:
903: IF(p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_PART) THEN
904: IF(p_uf_header_rec.inventory_item_id = FND_API.G_MISS_NUM)THEN
905: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_INVID_NLL');
906: FND_MSG_PUB.ADD;
907: ELSIF (p_uf_header_rec.inventory_item_id IS NOT NULL AND
908: p_uf_header_rec.inventory_item_id <> l_inventory_item_id )THEN
909: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVID_MIS');
910: FND_MSG_PUB.ADD;

Line 910: FND_MSG_PUB.ADD;

906: FND_MSG_PUB.ADD;
907: ELSIF (p_uf_header_rec.inventory_item_id IS NOT NULL AND
908: p_uf_header_rec.inventory_item_id <> l_inventory_item_id )THEN
909: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVID_MIS');
910: FND_MSG_PUB.ADD;
911: ELSE
912: OPEN part_check_csr(l_inventory_item_id);
913: FETCH part_check_csr INTO l_exists;
914: IF (part_check_csr%NOTFOUND) THEN

Line 916: FND_MSG_PUB.ADD;

912: OPEN part_check_csr(l_inventory_item_id);
913: FETCH part_check_csr INTO l_exists;
914: IF (part_check_csr%NOTFOUND) THEN
915: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_INV');
916: FND_MSG_PUB.ADD;
917: END IF;
918: CLOSE part_check_csr;
919: END IF;
920: ELSIF(p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_INSTANCE) THEN

Line 923: FND_MSG_PUB.ADD;

919: END IF;
920: ELSIF(p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_INSTANCE) THEN
921: IF(p_uf_header_rec.csi_item_instance_id = FND_API.G_MISS_NUM)THEN
922: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_INSTID_NLL');
923: FND_MSG_PUB.ADD;
924: ELSIF (p_uf_header_rec.csi_item_instance_id IS NOT NULL AND
925: p_uf_header_rec.csi_item_instance_id <> l_csi_item_instance_id )THEN
926: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INSTID_MIS');
927: FND_MSG_PUB.ADD;

Line 927: FND_MSG_PUB.ADD;

923: FND_MSG_PUB.ADD;
924: ELSIF (p_uf_header_rec.csi_item_instance_id IS NOT NULL AND
925: p_uf_header_rec.csi_item_instance_id <> l_csi_item_instance_id )THEN
926: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INSTID_MIS');
927: FND_MSG_PUB.ADD;
928: ELSE
929: OPEN instance_check_csr(l_csi_item_instance_id);
930: FETCH instance_check_csr INTO l_exists;
931: IF (instance_check_csr%NOTFOUND) THEN

Line 933: FND_MSG_PUB.ADD;

929: OPEN instance_check_csr(l_csi_item_instance_id);
930: FETCH instance_check_csr INTO l_exists;
931: IF (instance_check_csr%NOTFOUND) THEN
932: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INST_INV');
933: FND_MSG_PUB.ADD;
934: END IF;
935: CLOSE instance_check_csr;
936: END IF;
937: END IF;

Line 944: FND_MSG_PUB.ADD;

940: IF (p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_PART) THEN
941: IF(p_uf_header_rec.inventory_item_id IS NULL OR
942: p_uf_header_rec.inventory_item_id = FND_API.G_MISS_NUM) THEN
943: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_INVID_NLL');
944: FND_MSG_PUB.ADD;
945: ELSE
946: OPEN part_check_csr(p_uf_header_rec.inventory_item_id);
947: FETCH part_check_csr INTO l_exists;
948: IF (part_check_csr%NOTFOUND) THEN

Line 950: FND_MSG_PUB.ADD;

946: OPEN part_check_csr(p_uf_header_rec.inventory_item_id);
947: FETCH part_check_csr INTO l_exists;
948: IF (part_check_csr%NOTFOUND) THEN
949: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_INV');
950: FND_MSG_PUB.ADD;
951: END IF;
952: CLOSE part_check_csr;
953: END IF;
954: ELSIF (p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_INSTANCE) THEN

Line 958: FND_MSG_PUB.ADD;

954: ELSIF (p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_INSTANCE) THEN
955: IF(p_uf_header_rec.csi_item_instance_id IS NULL OR
956: p_uf_header_rec.csi_item_instance_id = FND_API.G_MISS_NUM) THEN
957: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_INSTID_NLL');
958: FND_MSG_PUB.ADD;
959: ELSE
960: OPEN instance_check_csr(p_uf_header_rec.csi_item_instance_id);
961: FETCH instance_check_csr INTO l_exists;
962: IF (instance_check_csr%NOTFOUND) THEN

Line 964: FND_MSG_PUB.ADD;

960: OPEN instance_check_csr(p_uf_header_rec.csi_item_instance_id);
961: FETCH instance_check_csr INTO l_exists;
962: IF (instance_check_csr%NOTFOUND) THEN
963: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INST_INV');
964: FND_MSG_PUB.ADD;
965: END IF;
966: CLOSE instance_check_csr;
967: END IF;
968: END IF;

Line 971: FND_MSG_PUB.ADD;

967: END IF;
968: END IF;
969: ELSE
970: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_HEADER');
971: FND_MSG_PUB.ADD;
972: END IF;
973:
974: IF(FND_MSG_PUB.count_msg > 0)THEN
975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 974: IF(FND_MSG_PUB.count_msg > 0)THEN

970: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_HEADER');
971: FND_MSG_PUB.ADD;
972: END IF;
973:
974: IF(FND_MSG_PUB.count_msg > 0)THEN
975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
976: END IF;
977:
978: IF((p_uf_header_rec.use_unit_flag IS NOT NULL OR p_uf_header_rec.use_unit_flag <> FND_API.G_MISS_CHAR)

Line 981: FND_MSG_PUB.ADD;

977:
978: IF((p_uf_header_rec.use_unit_flag IS NOT NULL OR p_uf_header_rec.use_unit_flag <> FND_API.G_MISS_CHAR)
979: AND p_uf_header_rec.use_unit_flag NOT IN (AHL_UMP_UF_PVT.G_UF_USE_UNIT_DEFAULT,AHL_UMP_UF_PVT.G_UF_USE_UNIT_YES)) THEN
980: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UNT_FLG');
981: FND_MSG_PUB.ADD;
982: END IF;
983:
984: IF(FND_MSG_PUB.count_msg > 0)THEN
985: RAISE FND_API.G_EXC_ERROR;

Line 984: IF(FND_MSG_PUB.count_msg > 0)THEN

980: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UNT_FLG');
981: FND_MSG_PUB.ADD;
982: END IF;
983:
984: IF(FND_MSG_PUB.count_msg > 0)THEN
985: RAISE FND_API.G_EXC_ERROR;
986: END IF;
987:
988:

Line 1022: FND_MSG_PUB.ADD;

1018: l_uf_header_rec.attribute12, l_uf_header_rec.attribute13, l_uf_header_rec.attribute14,
1019: l_uf_header_rec.attribute15;
1020: IF (uf_header_csr%NOTFOUND) THEN
1021: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HREC_NOTINDB');
1022: FND_MSG_PUB.ADD;
1023: ELSE
1024: IF (p_x_uf_header_rec.unit_config_header_id is null) THEN
1025: p_x_uf_header_rec.unit_config_header_id := l_uf_header_rec.unit_config_header_id;
1026: ELSIF(p_x_uf_header_rec.unit_config_header_id = FND_API.G_MISS_NUM) THEN

Line 1353: IF(FND_MSG_PUB.count_msg > 0)THEN

1349: p_uf_header_rec => p_uf_header_rec,
1350: x_uf_details_tbl => p_x_uf_details_tbl
1351: );
1352:
1353: IF(FND_MSG_PUB.count_msg > 0)THEN
1354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1355: END IF;
1356:
1357: END process_uf_details;

Line 1418: FND_MSG_PUB.ADD;

1414: FOR i IN p_x_uf_details_tbl.FIRST..l_total LOOP
1415: --checking for unexpected errors
1416: IF ( p_x_uf_details_tbl(i).operation_flag IS NOT NULL AND p_x_uf_details_tbl(i).operation_flag NOT IN(AHL_UMP_UF_PVT.G_OP_CREATE,AHL_UMP_UF_PVT.G_OP_UPDATE,AHL_UMP_UF_PVT.G_OP_DELETE))THEN
1417: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_DETAIL');
1418: FND_MSG_PUB.ADD;
1419: ELSIF (p_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE AND p_x_uf_details_tbl(i).operation_flag <> AHL_UMP_UF_PVT.G_OP_CREATE) THEN
1420: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_OP_DET_HED');
1421: FND_MSG_PUB.ADD;
1422: ELSIF ((p_x_uf_details_tbl(i).operation_flag <> AHL_UMP_UF_PVT.G_OP_CREATE AND p_x_uf_details_tbl(i).uf_detail_id IS NULL) OR

Line 1421: FND_MSG_PUB.ADD;

1417: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_DETAIL');
1418: FND_MSG_PUB.ADD;
1419: ELSIF (p_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE AND p_x_uf_details_tbl(i).operation_flag <> AHL_UMP_UF_PVT.G_OP_CREATE) THEN
1420: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_OP_DET_HED');
1421: FND_MSG_PUB.ADD;
1422: ELSIF ((p_x_uf_details_tbl(i).operation_flag <> AHL_UMP_UF_PVT.G_OP_CREATE AND p_x_uf_details_tbl(i).uf_detail_id IS NULL) OR
1423: (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE AND p_x_uf_details_tbl(i).uf_detail_id IS NOT NULL)) THEN
1424: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_DETAIL');
1425: FND_MSG_PUB.ADD;

Line 1425: FND_MSG_PUB.ADD;

1421: FND_MSG_PUB.ADD;
1422: ELSIF ((p_x_uf_details_tbl(i).operation_flag <> AHL_UMP_UF_PVT.G_OP_CREATE AND p_x_uf_details_tbl(i).uf_detail_id IS NULL) OR
1423: (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE AND p_x_uf_details_tbl(i).uf_detail_id IS NOT NULL)) THEN
1424: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_DETAIL');
1425: FND_MSG_PUB.ADD;
1426: END IF;
1427: -- Raise if unexpected errors
1428: IF FND_MSG_PUB.count_msg > 0 THEN
1429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1428: IF FND_MSG_PUB.count_msg > 0 THEN

1424: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_DETAIL');
1425: FND_MSG_PUB.ADD;
1426: END IF;
1427: -- Raise if unexpected errors
1428: IF FND_MSG_PUB.count_msg > 0 THEN
1429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1430: END IF;
1431:
1432: IF (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE AND

Line 1442: FND_MSG_PUB.ADD;

1438: OPEN uf_details_csr(p_x_uf_details_tbl(i).uf_detail_id);
1439: FETCH uf_details_csr INTO l_object_version_number, l_uf_header_id,l_uom_code,l_start_date,l_end_date,l_usage_per_day;
1440: IF (uf_details_csr%NOTFOUND) THEN
1441: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DET_INV_NOTINDB');
1442: FND_MSG_PUB.ADD;
1443: ELSIF l_object_version_number <> p_x_uf_details_tbl(i).object_version_number THEN
1444: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DET_OBJV_MIS');
1445: FND_MSG_PUB.ADD;
1446: ELSE

Line 1445: FND_MSG_PUB.ADD;

1441: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DET_INV_NOTINDB');
1442: FND_MSG_PUB.ADD;
1443: ELSIF l_object_version_number <> p_x_uf_details_tbl(i).object_version_number THEN
1444: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DET_OBJV_MIS');
1445: FND_MSG_PUB.ADD;
1446: ELSE
1447: IF p_x_uf_details_tbl(i).end_date IS NULL THEN
1448: p_x_uf_details_tbl(i).end_date := l_end_date;
1449: ELSIF p_x_uf_details_tbl(i).end_date = FND_API.G_MISS_DATE THEN

Line 1456: FND_MSG_PUB.ADD;

1452: IF p_x_uf_details_tbl(i).uf_header_id IS NULL THEN
1453: p_x_uf_details_tbl(i).uf_header_id := l_uf_header_id;
1454: ELSIF p_x_uf_details_tbl(i).uf_header_id = FND_API.G_MISS_NUM THEN
1455: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_DET_UFHID');
1456: FND_MSG_PUB.ADD;
1457: ELSIF (p_x_uf_details_tbl(i).uf_header_id <> l_uf_header_id) THEN
1458: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_DET_UFHID');
1459: FND_MSG_PUB.ADD;
1460: END IF;

Line 1459: FND_MSG_PUB.ADD;

1455: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_DET_UFHID');
1456: FND_MSG_PUB.ADD;
1457: ELSIF (p_x_uf_details_tbl(i).uf_header_id <> l_uf_header_id) THEN
1458: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_DET_UFHID');
1459: FND_MSG_PUB.ADD;
1460: END IF;
1461: END IF;
1462: CLOSE uf_details_csr;
1463: END IF;

Line 1465: IF(FND_MSG_PUB.count_msg > 0)THEN

1461: END IF;
1462: CLOSE uf_details_csr;
1463: END IF;
1464:
1465: IF(FND_MSG_PUB.count_msg > 0)THEN
1466: RAISE FND_API.G_EXC_ERROR;
1467: END IF;
1468:
1469: -- checking for expected error if start date , end date,UOM are invalid

Line 1478: FND_MSG_PUB.ADD;

1474: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1475: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1476: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1477: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1478: FND_MSG_PUB.ADD;
1479: ELSIF (p_x_uf_details_tbl(i).end_date IS NOT NULL) THEN
1480: IF ((TRUNC(p_x_uf_details_tbl(i).end_date) < TRUNC(p_x_uf_details_tbl(i).start_date)) OR
1481: (TRUNC(p_x_uf_details_tbl(i).end_date) < TRUNC(SYSDATE)))THEN
1482: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_EDATE');

Line 1487: FND_MSG_PUB.ADD;

1483: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1484: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1485: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1486: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1487: FND_MSG_PUB.ADD;
1488: ELSIF (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE) THEN
1489: IF(TRUNC(p_x_uf_details_tbl(i).start_date) < TRUNC(SYSDATE))THEN
1490: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_SDATE');
1491: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);

Line 1495: FND_MSG_PUB.ADD;

1491: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1492: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1493: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1494: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1495: FND_MSG_PUB.ADD;
1496: END IF;
1497: ELSIF (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE) THEN
1498: IF ( TRUNC(p_x_uf_details_tbl(i).start_date) < TRUNC(SYSDATE) AND
1499: (TRUNC(p_x_uf_details_tbl(i).start_date) <> TRUNC(l_start_date) OR

Line 1506: FND_MSG_PUB.ADD;

1502: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1503: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1504: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1505: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1506: FND_MSG_PUB.ADD;
1507: END IF;
1508: END IF;
1509: ELSIF (p_x_uf_details_tbl(i).end_date IS NULL) THEN
1510: IF (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE) THEN

Line 1517: FND_MSG_PUB.ADD;

1513: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1514: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1515: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1516: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1517: FND_MSG_PUB.ADD;
1518: END IF;
1519: ELSIF (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE) THEN
1520: IF ( TRUNC(p_x_uf_details_tbl(i).start_date) < TRUNC(SYSDATE) AND
1521: (TRUNC(p_x_uf_details_tbl(i).start_date) <> TRUNC(l_start_date) OR

Line 1528: FND_MSG_PUB.ADD;

1524: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1525: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1526: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1527: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1528: FND_MSG_PUB.ADD;
1529: END IF;
1530: END IF;
1531: END IF;
1532:

Line 1540: FND_MSG_PUB.ADD;

1536: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1537: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1538: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1539: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1540: FND_MSG_PUB.ADD;
1541: ELSE
1542: IF (p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_OP_UPDATE)THEN
1543: OPEN unit_uom_code_ckeck_csr(p_x_uf_details_tbl(i).uom_code);
1544: FETCH unit_uom_code_ckeck_csr into l_exists;

Line 1551: FND_MSG_PUB.ADD;

1547: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1548: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1549: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1550: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1551: FND_MSG_PUB.ADD;
1552: END IF;
1553: CLOSE unit_uom_code_ckeck_csr;
1554: ELSIF (p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_PART)THEN
1555: OPEN part_uom_code_ckeck_csr(p_x_uf_details_tbl(i).uom_code);

Line 1563: FND_MSG_PUB.ADD;

1559: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1560: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1561: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1562: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1563: FND_MSG_PUB.ADD;
1564: END IF;
1565: CLOSE part_uom_code_ckeck_csr;
1566: ELSIF (p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_PC_NODE)THEN
1567: OPEN node_uom_code_ckeck_csr(p_x_uf_details_tbl(i).uom_code);

Line 1575: FND_MSG_PUB.ADD;

1571: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1572: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1573: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1574: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1575: FND_MSG_PUB.ADD;
1576: END IF;
1577: CLOSE node_uom_code_ckeck_csr;
1578: END IF;
1579: END IF;--UOM code check

Line 1583: IF (FND_MSG_PUB.count_msg = 0) THEN

1579: END IF;--UOM code check
1580: END IF;
1581:
1582: --spliting and end-dating
1583: IF (FND_MSG_PUB.count_msg = 0) THEN
1584: IF(p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE)THEN
1585: IF TRUNC(p_x_uf_details_tbl(i).start_date) < TRUNC(SYSDATE) THEN
1586: IF((TRUNC(p_x_uf_details_tbl(i).start_date) <> TRUNC(l_start_date))OR
1587: (p_x_uf_details_tbl(i).uom_code <> l_uom_code)) THEN

Line 1593: FND_MSG_PUB.ADD;

1589: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1590: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1591: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1592: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1593: FND_MSG_PUB.ADD;
1594: ELSIF ((TRUNC(p_x_uf_details_tbl(i).end_date) <> TRUNC(l_end_date))OR
1595: (p_x_uf_details_tbl(i).usage_per_day <> l_usage_per_day)) THEN
1596: -- adding new record
1597: l_last := p_x_uf_details_tbl.count + 1;

Line 1625: IF FND_MSG_PUB.count_msg > 0 THEN

1621: END IF; --end splitting and end dating
1622:
1623: END LOOP;
1624:
1625: IF FND_MSG_PUB.count_msg > 0 THEN
1626: RAISE FND_API.G_EXC_ERROR;
1627: END IF;
1628:
1629: END validate_uf_details;

Line 1684: FND_MSG_PUB.ADD;

1680: FND_MESSAGE.Set_Token('NSTART_DATE',x_uf_details_tbl(i+1).start_date);
1681: FND_MESSAGE.Set_Token('NEND_DATE',x_uf_details_tbl(i+1).end_date);
1682: FND_MESSAGE.Set_Token('NUOM_CODE',x_uf_details_tbl(i+1).uom_code);
1683: FND_MESSAGE.Set_Token('NUSAGE_PER_DAY',x_uf_details_tbl(i+1).usage_per_day);
1684: FND_MSG_PUB.ADD;
1685: ELSIF TRUNC(x_uf_details_tbl(i+1).start_date) <> TRUNC(x_uf_details_tbl(i).end_date + 1) THEN
1686: IF(TRUNC(x_uf_details_tbl(i+1).start_date) > TRUNC(x_uf_details_tbl(i).end_date + 1)) THEN
1687: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UF_GAPS_IN_UF');
1688: ELSE

Line 1699: FND_MSG_PUB.ADD;

1695: FND_MESSAGE.Set_Token('NSTART_DATE',x_uf_details_tbl(i+1).start_date);
1696: FND_MESSAGE.Set_Token('NEND_DATE',x_uf_details_tbl(i+1).end_date);
1697: FND_MESSAGE.Set_Token('NUOM_CODE',x_uf_details_tbl(i+1).uom_code);
1698: FND_MESSAGE.Set_Token('NUSAGE_PER_DAY',x_uf_details_tbl(i+1).usage_per_day);
1699: FND_MSG_PUB.ADD;
1700: END IF;
1701: END IF;
1702: END IF;
1703: END LOOP;

Line 1706: IF FND_MSG_PUB.count_msg > 0 THEN

1702: END IF;
1703: END LOOP;
1704: END IF;
1705:
1706: IF FND_MSG_PUB.count_msg > 0 THEN
1707: RAISE FND_API.G_EXC_ERROR;
1708: END IF;
1709:
1710: END validate_utilization_forecast;

Line 1739: FND_MSG_PUB.ADD;

1735: l_uf_details_rec.attribute8, l_uf_details_rec.attribute9, l_uf_details_rec.attribute10, l_uf_details_rec.attribute11, l_uf_details_rec.attribute12,
1736: l_uf_details_rec.attribute13, l_uf_details_rec.attribute14, l_uf_details_rec.attribute15;
1737: IF (uf_details_csr%NOTFOUND) THEN
1738: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DET_OBJV_MIS');
1739: FND_MSG_PUB.ADD;
1740: ELSE
1741: IF (p_x_uf_details_tbl(i).uf_header_id is null) THEN
1742: p_x_uf_details_tbl(i).uf_header_id := l_uf_details_rec.uf_header_id;
1743: ELSIF(p_x_uf_details_tbl(i).uf_header_id = FND_API.G_MISS_NUM) THEN

Line 2265: FND_MSG_PUB.Initialize;

2261: -- Initialize Procedure return status to success
2262: -- Initialize message list if p_init_msg_list is set to TRUE
2263: IF FND_API.To_Boolean( p_init_msg_list)
2264: THEN
2265: FND_MSG_PUB.Initialize;
2266: END IF;
2267:
2268: -- Initialize API return status to success
2269: x_return_status := FND_API.G_RET_STS_SUCCESS; j := 0;

Line 2298: FND_MSG_PUB.ADD;

2294: l_unit_config_header_id IS NOT NULL)
2295: OR (l_unit_config_header_id IS NOT NULL AND
2296: l_inventory_item_id IS NOT NULL) ) THEN
2297: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UTIL_ONLY_ONE_ID');
2298: FND_MSG_PUB.ADD;
2299: END IF;
2300:
2301: l_msg_count := FND_MSG_PUB.count_msg;
2302: IF l_msg_count > 0 THEN

Line 2301: l_msg_count := FND_MSG_PUB.count_msg;

2297: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UTIL_ONLY_ONE_ID');
2298: FND_MSG_PUB.ADD;
2299: END IF;
2300:
2301: l_msg_count := FND_MSG_PUB.count_msg;
2302: IF l_msg_count > 0 THEN
2303: x_return_status := FND_API.G_RET_STS_ERROR;
2304: RETURN;
2305: END IF;

Line 2317: -- FND_MSG_PUB.ADD;

2313: IF (ahl_check_pc_id_csr%NOTFOUND) THEN
2314: l_pc_node_id := NULL;
2315: -- FND_MESSAGE.Set_Name('AHL','AHL_UMP_UTIL_NO_PRIM_PC');
2316: -- FND_MESSAGE.Set_Token('UID',l_pc_node_id);
2317: -- FND_MSG_PUB.ADD;
2318: END IF;
2319: CLOSE ahl_check_pc_id_csr;
2320: END IF;
2321:

Line 2339: -- FND_MSG_PUB.ADD;

2335: CLOSE ahl_item_id_from_uc_header_csr;
2336:
2337: -- FND_MESSAGE.Set_Name('AHL','AHL_UMP_UTIL_NO_PRIM_PC');
2338: -- FND_MESSAGE.Set_Token('UID',l_unit_config_header_id);
2339: -- FND_MSG_PUB.ADD;
2340: END IF;
2341: CLOSE ahl_pc_id_from_assoc_csr;
2342:
2343: /*

Line 2445: -- FND_MSG_PUB.ADD;

2441: IF (ahl_pc_id_from_assoc_csr%NOTFOUND) THEN
2442: l_pc_node_id := NULL;
2443: -- FND_MESSAGE.Set_Name('AHL','AHL_UMP_UTIL_NO_PRIM_PC');
2444: -- FND_MESSAGE.Set_Token('UID',l_inventory_item_id);
2445: -- FND_MSG_PUB.ADD;
2446: END IF;
2447: CLOSE ahl_pc_id_from_assoc_csr;
2448:
2449: -- Added to fix bug# 6749351

Line 2748: FND_MSG_PUB.Initialize;

2744: BEGIN
2745:
2746: IF FND_API.To_Boolean( p_init_msg_list)
2747: THEN
2748: FND_MSG_PUB.Initialize;
2749: END IF;
2750:
2751: -- Initialize API return status to success
2752: x_return_status := FND_API.G_RET_STS_SUCCESS;