eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_UMP_UF_PVT dependencies on FND_API

Line 14: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

10: ------------------------------
11: -- Declare Local Procedures --
12: ------------------------------
13: PROCEDURE process_uf_header(
14: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
15: p_x_uf_header_rec IN OUT NOCOPY AHL_UMP_UF_PVT.uf_header_Rec_type
16: );
17:
18: PROCEDURE convert_uf_header_val_to_id(

Line 46: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

42: p_x_uf_header_rec IN OUT NOCOPY AHL_UMP_UF_PVT.uf_header_Rec_type
43: );
44:
45: PROCEDURE process_uf_details(
46: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
47: p_uf_header_rec IN AHL_UMP_UF_PVT.uf_header_Rec_type,
48: p_x_uf_details_tbl IN OUT NOCOPY AHL_UMP_UF_PVT.uf_details_tbl_type
49: );
50:

Line 84: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE

80: -- Parameters :
81: --
82: -- Standard IN Parameters :
83: -- p_api_version IN NUMBER Default 1.0
84: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
85: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
86: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
87: -- Standard OUT Parameters :
88: -- x_return_status OUT VARCHAR2 Required

Line 85: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

81: --
82: -- Standard IN Parameters :
83: -- p_api_version IN NUMBER Default 1.0
84: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
85: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
86: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
87: -- Standard OUT Parameters :
88: -- x_return_status OUT VARCHAR2 Required
89: -- x_msg_count OUT NUMBER Required

Line 86: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

82: -- Standard IN Parameters :
83: -- p_api_version IN NUMBER Default 1.0
84: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
85: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
86: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
87: -- Standard OUT Parameters :
88: -- x_return_status OUT VARCHAR2 Required
89: -- x_msg_count OUT NUMBER Required
90: -- x_msg_data OUT VARCHAR2 Required

Line 113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

109: -- End of Comments.
110:
111: PROCEDURE process_utilization_forecast (
112: p_api_version IN NUMBER := 1.0,
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114: p_commit IN VARCHAR2 := FND_API.G_FALSE,
115: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
116: p_module_type IN VARCHAR2 := NULL,
117: p_x_uf_header_rec IN OUT NOCOPY AHL_UMP_UF_PVT.uf_header_rec_type,

Line 114: p_commit IN VARCHAR2 := FND_API.G_FALSE,

110:
111: PROCEDURE process_utilization_forecast (
112: p_api_version IN NUMBER := 1.0,
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114: p_commit IN VARCHAR2 := FND_API.G_FALSE,
115: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
116: p_module_type IN VARCHAR2 := NULL,
117: p_x_uf_header_rec IN OUT NOCOPY AHL_UMP_UF_PVT.uf_header_rec_type,
118: p_x_uf_details_tbl IN OUT NOCOPY AHL_UMP_UF_PVT.uf_details_tbl_type,

Line 115: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

111: PROCEDURE process_utilization_forecast (
112: p_api_version IN NUMBER := 1.0,
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114: p_commit IN VARCHAR2 := FND_API.G_FALSE,
115: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
116: p_module_type IN VARCHAR2 := NULL,
117: p_x_uf_header_rec IN OUT NOCOPY AHL_UMP_UF_PVT.uf_header_rec_type,
118: p_x_uf_details_tbl IN OUT NOCOPY AHL_UMP_UF_PVT.uf_details_tbl_type,
119: x_return_status OUT NOCOPY VARCHAR2,

Line 125: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

121: x_msg_data OUT NOCOPY VARCHAR2) IS
122:
123: l_api_version CONSTANT NUMBER := 1.0;
124: l_api_name CONSTANT VARCHAR2(30) := 'process_utilization_forecast';
125: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
126:
127: BEGIN
128:
129: -- Standard start of API savepoint

Line 133: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME )

129: -- Standard start of API savepoint
130: SAVEPOINT process_uf_pvt;
131:
132: -- Standard call to check for call compatibility
133: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME )
134: THEN
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: END IF;
137:

Line 135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

131:
132: -- Standard call to check for call compatibility
133: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME )
134: THEN
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: END IF;
137:
138: -- Initialize message list if p_init_msg_list is set to TRUE
139: IF FND_API.To_Boolean( p_init_msg_list)

Line 139: IF FND_API.To_Boolean( p_init_msg_list)

135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: END IF;
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:

Line 145: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
146:
147: -- Enable Debug.
148: IF G_DEBUG = 'Y' THEN
149: AHL_DEBUG_PUB.enable_debug;

Line 163: RAISE FND_API.G_EXC_ERROR;

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:
166: -- PROCESS UF details
167: IF (p_x_uf_details_tbl.count > 0) THEN

Line 178: RAISE FND_API.G_EXC_ERROR;

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:
181:
182: -- post processing to delete header if use unit forecast is 'N' and there are no uf_details.

Line 188: RAISE FND_API.G_EXC_ERROR;

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:
191: -- Standard check of p_commit
192: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 192: IF FND_API.TO_BOOLEAN(p_commit) THEN

188: RAISE FND_API.G_EXC_ERROR;
189: END IF;
190:
191: -- Standard check of p_commit
192: IF FND_API.TO_BOOLEAN(p_commit) THEN
193: COMMIT WORK;
194: END IF;
195:
196: -- Standard call to get message count and if count is 1, get message info

Line 200: p_encoded => fnd_api.g_false

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: );
202:
203: IF G_DEBUG = 'Y' THEN
204: AHL_DEBUG_PUB.debug('Successfully ending processing UF');

Line 213: WHEN FND_API.G_EXC_ERROR THEN

209: AHL_DEBUG_PUB.disable_debug;
210: END IF;
211:
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,

Line 215: x_return_status := FND_API.G_RET_STS_ERROR;

211:
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

Line 218: p_encoded => fnd_api.g_false);

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
221: AHL_DEBUG_PUB.disable_debug;
222: END IF;

Line 225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

221: AHL_DEBUG_PUB.disable_debug;
222: END IF;
223:
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,

Line 227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

223:
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

Line 230: p_encoded => fnd_api.g_false);

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
233: AHL_DEBUG_PUB.disable_debug;
234: END IF;

Line 238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

234: END IF;
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));

Line 246: p_encoded => fnd_api.g_false);

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
249: AHL_DEBUG_PUB.disable_debug;
250: END IF;

Line 259: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

255: ----------------------------------------------------------
256: -- This procedure processes uf_header_rec
257: ----------------------------------------------------------
258: PROCEDURE process_uf_header(
259: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
260: p_x_uf_header_rec IN OUT NOCOPY AHL_UMP_UF_PVT.uf_header_Rec_type
261: ) IS
262: BEGIN
263: -- Convert values to ID's for header rec

Line 264: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )

260: p_x_uf_header_rec IN OUT NOCOPY AHL_UMP_UF_PVT.uf_header_Rec_type
261: ) IS
262: BEGIN
263: -- Convert values to ID's for header rec
264: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )
265: THEN
266: convert_uf_header_val_to_id(p_x_uf_header_rec => p_x_uf_header_rec);
267: END IF;
268:

Line 381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
385:

Line 621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
625: OPEN uf_header_csr(p_uf_header_rec.uf_header_id);

Line 637: RAISE FND_API.G_EXC_ERROR;

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
641: IF(p_uf_header_rec.unit_config_header_id = FND_API.G_MISS_NUM)THEN

Line 641: IF(p_uf_header_rec.unit_config_header_id = FND_API.G_MISS_NUM)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
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');

Line 673: IF(p_uf_header_rec.inventory_item_id = FND_API.G_MISS_NUM)THEN

669:
670:
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

Line 702: IF(p_uf_header_rec.pc_node_id = FND_API.G_MISS_NUM)THEN

698: CLOSE pc_status_check_up_csr;
699:
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

Line 727: p_uf_header_rec.unit_config_header_id = FND_API.G_MISS_NUM) THEN

723: ELSIF (p_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE AND
724: p_uf_header_rec.uf_header_id IS NULL)THEN
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);

Line 756: p_uf_header_rec.inventory_item_id = FND_API.G_MISS_NUM) THEN

752:
753: END IF;
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);

Line 782: p_uf_header_rec.pc_node_id = FND_API.G_MISS_NUM) THEN

778:
779: END IF;
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);

Line 804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 814: RAISE FND_API.G_EXC_ERROR;

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:
818: END validate_uf_header;

Line 884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
888: OPEN uf_header_csr(p_uf_header_rec.uf_header_id);

Line 900: RAISE FND_API.G_EXC_ERROR;

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
904: IF(p_uf_header_rec.inventory_item_id = FND_API.G_MISS_NUM)THEN

Line 904: IF(p_uf_header_rec.inventory_item_id = FND_API.G_MISS_NUM)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
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

Line 921: IF(p_uf_header_rec.csi_item_instance_id = FND_API.G_MISS_NUM)THEN

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

Line 942: p_uf_header_rec.inventory_item_id = FND_API.G_MISS_NUM) THEN

938: ELSIF (p_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE AND
939: p_uf_header_rec.uf_header_id IS NULL)THEN
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);

Line 956: p_uf_header_rec.csi_item_instance_id = FND_API.G_MISS_NUM) THEN

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

Line 975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 985: RAISE FND_API.G_EXC_ERROR;

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:
989: END validate_uf_header_pm;

Line 1026: ELSIF(p_x_uf_header_rec.unit_config_header_id = FND_API.G_MISS_NUM) THEN

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
1027: p_x_uf_header_rec.unit_config_header_id := null;
1028: END IF;
1029:
1030: IF (p_x_uf_header_rec.inventory_item_id is null) THEN

Line 1032: ELSIF(p_x_uf_header_rec.inventory_item_id = FND_API.G_MISS_NUM) THEN

1028: END IF;
1029:
1030: IF (p_x_uf_header_rec.inventory_item_id is null) THEN
1031: p_x_uf_header_rec.inventory_item_id := l_uf_header_rec.inventory_item_id;
1032: ELSIF(p_x_uf_header_rec.inventory_item_id = FND_API.G_MISS_NUM) THEN
1033: p_x_uf_header_rec.inventory_item_id := null;
1034: END IF;
1035:
1036: IF (p_x_uf_header_rec.pc_node_id is null) THEN

Line 1038: ELSIF(p_x_uf_header_rec.pc_node_id = FND_API.G_MISS_NUM) THEN

1034: END IF;
1035:
1036: IF (p_x_uf_header_rec.pc_node_id is null) THEN
1037: p_x_uf_header_rec.pc_node_id := l_uf_header_rec.pc_node_id;
1038: ELSIF(p_x_uf_header_rec.pc_node_id = FND_API.G_MISS_NUM) THEN
1039: p_x_uf_header_rec.pc_node_id := null; END IF;
1040:
1041: IF (p_x_uf_header_rec.inventory_org_id is null) THEN
1042: p_x_uf_header_rec.inventory_org_id := l_uf_header_rec.inventory_org_id;

Line 1043: ELSIF(p_x_uf_header_rec.inventory_org_id = FND_API.G_MISS_NUM) THEN

1039: p_x_uf_header_rec.pc_node_id := null; END IF;
1040:
1041: IF (p_x_uf_header_rec.inventory_org_id is null) THEN
1042: p_x_uf_header_rec.inventory_org_id := l_uf_header_rec.inventory_org_id;
1043: ELSIF(p_x_uf_header_rec.inventory_org_id = FND_API.G_MISS_NUM) THEN
1044: p_x_uf_header_rec.inventory_org_id := null;
1045: END IF;
1046:
1047: IF (p_x_uf_header_rec.csi_item_instance_id is null) THEN

Line 1049: ELSIF(p_x_uf_header_rec.csi_item_instance_id = FND_API.G_MISS_NUM) THEN

1045: END IF;
1046:
1047: IF (p_x_uf_header_rec.csi_item_instance_id is null) THEN
1048: p_x_uf_header_rec.csi_item_instance_id := l_uf_header_rec.csi_item_instance_id;
1049: ELSIF(p_x_uf_header_rec.csi_item_instance_id = FND_API.G_MISS_NUM) THEN
1050: p_x_uf_header_rec.csi_item_instance_id := null;
1051: END IF;
1052:
1053: IF (p_x_uf_header_rec.use_unit_flag is null) THEN

Line 1055: ELSIF(p_x_uf_header_rec.use_unit_flag = FND_API.G_MISS_CHAR) THEN

1051: END IF;
1052:
1053: IF (p_x_uf_header_rec.use_unit_flag is null) THEN
1054: p_x_uf_header_rec.use_unit_flag := l_uf_header_rec.use_unit_flag;
1055: ELSIF(p_x_uf_header_rec.use_unit_flag = FND_API.G_MISS_CHAR) THEN
1056: p_x_uf_header_rec.use_unit_flag := AHL_UMP_UF_PVT.G_UF_USE_UNIT_DEFAULT;
1057: END IF;
1058:
1059: IF (p_x_uf_header_rec.attribute_category is null) THEN

Line 1061: ELSIF(p_x_uf_header_rec.attribute_category = FND_API.G_MISS_CHAR) THEN

1057: END IF;
1058:
1059: IF (p_x_uf_header_rec.attribute_category is null) THEN
1060: p_x_uf_header_rec.attribute_category := l_uf_header_rec.attribute_category;
1061: ELSIF(p_x_uf_header_rec.attribute_category = FND_API.G_MISS_CHAR) THEN
1062: p_x_uf_header_rec.attribute_category := null;
1063: END IF;
1064:
1065: IF (p_x_uf_header_rec.attribute1 is null) THEN

Line 1067: ELSIF(p_x_uf_header_rec.attribute1 = FND_API.G_MISS_CHAR) THEN

1063: END IF;
1064:
1065: IF (p_x_uf_header_rec.attribute1 is null) THEN
1066: p_x_uf_header_rec.attribute1 := l_uf_header_rec.attribute1;
1067: ELSIF(p_x_uf_header_rec.attribute1 = FND_API.G_MISS_CHAR) THEN
1068: p_x_uf_header_rec.attribute1 := null;
1069: END IF;
1070:
1071: IF (p_x_uf_header_rec.attribute2 is null) THEN

Line 1073: ELSIF(p_x_uf_header_rec.attribute2 = FND_API.G_MISS_CHAR) THEN

1069: END IF;
1070:
1071: IF (p_x_uf_header_rec.attribute2 is null) THEN
1072: p_x_uf_header_rec.attribute2 := l_uf_header_rec.attribute2;
1073: ELSIF(p_x_uf_header_rec.attribute2 = FND_API.G_MISS_CHAR) THEN
1074: p_x_uf_header_rec.attribute2 := null;
1075: END IF;
1076:
1077: IF (p_x_uf_header_rec.attribute3 is null) THEN

Line 1079: ELSIF(p_x_uf_header_rec.attribute3 = FND_API.G_MISS_CHAR) THEN

1075: END IF;
1076:
1077: IF (p_x_uf_header_rec.attribute3 is null) THEN
1078: p_x_uf_header_rec.attribute3 := l_uf_header_rec.attribute3;
1079: ELSIF(p_x_uf_header_rec.attribute3 = FND_API.G_MISS_CHAR) THEN
1080: p_x_uf_header_rec.attribute3 := null;
1081: END IF;
1082:
1083: IF (p_x_uf_header_rec.attribute4 is null) THEN

Line 1085: ELSIF(p_x_uf_header_rec.attribute4 = FND_API.G_MISS_CHAR) THEN

1081: END IF;
1082:
1083: IF (p_x_uf_header_rec.attribute4 is null) THEN
1084: p_x_uf_header_rec.attribute4 := l_uf_header_rec.attribute4;
1085: ELSIF(p_x_uf_header_rec.attribute4 = FND_API.G_MISS_CHAR) THEN
1086: p_x_uf_header_rec.attribute4 := null;
1087: END IF;
1088:
1089: IF (p_x_uf_header_rec.attribute5 is null) THEN

Line 1091: ELSIF(p_x_uf_header_rec.attribute5 = FND_API.G_MISS_CHAR) THEN

1087: END IF;
1088:
1089: IF (p_x_uf_header_rec.attribute5 is null) THEN
1090: p_x_uf_header_rec.attribute5 := l_uf_header_rec.attribute5;
1091: ELSIF(p_x_uf_header_rec.attribute5 = FND_API.G_MISS_CHAR) THEN
1092: p_x_uf_header_rec.attribute5 := null;
1093: END IF;
1094:
1095: IF (p_x_uf_header_rec.attribute6 is null) THEN

Line 1097: ELSIF(p_x_uf_header_rec.attribute6 = FND_API.G_MISS_CHAR) THEN

1093: END IF;
1094:
1095: IF (p_x_uf_header_rec.attribute6 is null) THEN
1096: p_x_uf_header_rec.attribute6 := l_uf_header_rec.attribute6;
1097: ELSIF(p_x_uf_header_rec.attribute6 = FND_API.G_MISS_CHAR) THEN
1098: p_x_uf_header_rec.attribute6 := null;
1099: END IF;
1100:
1101: IF (p_x_uf_header_rec.attribute7 is null) THEN

Line 1103: ELSIF(p_x_uf_header_rec.attribute7 = FND_API.G_MISS_CHAR) THEN

1099: END IF;
1100:
1101: IF (p_x_uf_header_rec.attribute7 is null) THEN
1102: p_x_uf_header_rec.attribute7 := l_uf_header_rec.attribute7;
1103: ELSIF(p_x_uf_header_rec.attribute7 = FND_API.G_MISS_CHAR) THEN
1104: p_x_uf_header_rec.attribute7 := null;
1105: END IF;
1106:
1107: IF (p_x_uf_header_rec.attribute8 is null) THEN

Line 1109: ELSIF(p_x_uf_header_rec.attribute8 = FND_API.G_MISS_CHAR) THEN

1105: END IF;
1106:
1107: IF (p_x_uf_header_rec.attribute8 is null) THEN
1108: p_x_uf_header_rec.attribute8 := l_uf_header_rec.attribute8;
1109: ELSIF(p_x_uf_header_rec.attribute8 = FND_API.G_MISS_CHAR) THEN
1110: p_x_uf_header_rec.attribute8 := null;
1111: END IF;
1112:
1113: IF (p_x_uf_header_rec.attribute9 is null) THEN

Line 1115: ELSIF(p_x_uf_header_rec.attribute9 = FND_API.G_MISS_CHAR) THEN

1111: END IF;
1112:
1113: IF (p_x_uf_header_rec.attribute9 is null) THEN
1114: p_x_uf_header_rec.attribute9 := l_uf_header_rec.attribute9;
1115: ELSIF(p_x_uf_header_rec.attribute9 = FND_API.G_MISS_CHAR) THEN
1116: p_x_uf_header_rec.attribute9 := null;
1117: END IF;
1118:
1119: IF (p_x_uf_header_rec.attribute10 is null) THEN

Line 1121: ELSIF(p_x_uf_header_rec.attribute10 = FND_API.G_MISS_CHAR) THEN

1117: END IF;
1118:
1119: IF (p_x_uf_header_rec.attribute10 is null) THEN
1120: p_x_uf_header_rec.attribute10 := l_uf_header_rec.attribute10;
1121: ELSIF(p_x_uf_header_rec.attribute10 = FND_API.G_MISS_CHAR) THEN
1122: p_x_uf_header_rec.attribute10 := null;
1123: END IF;
1124:
1125: IF (p_x_uf_header_rec.attribute11 is null) THEN

Line 1127: ELSIF(p_x_uf_header_rec.attribute11 = FND_API.G_MISS_CHAR) THEN

1123: END IF;
1124:
1125: IF (p_x_uf_header_rec.attribute11 is null) THEN
1126: p_x_uf_header_rec.attribute11 := l_uf_header_rec.attribute11;
1127: ELSIF(p_x_uf_header_rec.attribute11 = FND_API.G_MISS_CHAR) THEN
1128: p_x_uf_header_rec.attribute11 := null;
1129: END IF;
1130:
1131: IF (p_x_uf_header_rec.attribute12 is null) THEN

Line 1133: ELSIF(p_x_uf_header_rec.attribute12 = FND_API.G_MISS_CHAR) THEN

1129: END IF;
1130:
1131: IF (p_x_uf_header_rec.attribute12 is null) THEN
1132: p_x_uf_header_rec.attribute12 := l_uf_header_rec.attribute12;
1133: ELSIF(p_x_uf_header_rec.attribute12 = FND_API.G_MISS_CHAR) THEN
1134: p_x_uf_header_rec.attribute12 := null;
1135: END IF;
1136:
1137: IF (p_x_uf_header_rec.attribute13 is null) THEN

Line 1139: ELSIF(p_x_uf_header_rec.attribute13 = FND_API.G_MISS_CHAR) THEN

1135: END IF;
1136:
1137: IF (p_x_uf_header_rec.attribute13 is null) THEN
1138: p_x_uf_header_rec.attribute13 := l_uf_header_rec.attribute13;
1139: ELSIF(p_x_uf_header_rec.attribute13 = FND_API.G_MISS_CHAR) THEN
1140: p_x_uf_header_rec.attribute13 := null;
1141: END IF;
1142:
1143: IF (p_x_uf_header_rec.attribute14 is null) THEN

Line 1145: ELSIF(p_x_uf_header_rec.attribute14 = FND_API.G_MISS_CHAR) THEN

1141: END IF;
1142:
1143: IF (p_x_uf_header_rec.attribute14 is null) THEN
1144: p_x_uf_header_rec.attribute14 := l_uf_header_rec.attribute14;
1145: ELSIF(p_x_uf_header_rec.attribute14 = FND_API.G_MISS_CHAR) THEN
1146: p_x_uf_header_rec.attribute14 := null;
1147: END IF;
1148:
1149: IF (p_x_uf_header_rec.attribute15 is null) THEN

Line 1151: ELSIF(p_x_uf_header_rec.attribute15 = FND_API.G_MISS_CHAR) THEN

1147: END IF;
1148:
1149: IF (p_x_uf_header_rec.attribute15 is null) THEN
1150: p_x_uf_header_rec.attribute15 := l_uf_header_rec.attribute15;
1151: ELSIF(p_x_uf_header_rec.attribute15 = FND_API.G_MISS_CHAR) THEN
1152: p_x_uf_header_rec.attribute15 := null;
1153: END IF;
1154:
1155: END IF;

Line 1159: IF (p_x_uf_header_rec.unit_config_header_id = FND_API.G_MISS_NUM) THEN

1155: END IF;
1156: CLOSE uf_header_csr;
1157: ELSIF (p_x_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE) THEN
1158:
1159: IF (p_x_uf_header_rec.unit_config_header_id = FND_API.G_MISS_NUM) THEN
1160: p_x_uf_header_rec.unit_config_header_id := null;
1161: END IF;
1162:
1163: IF (p_x_uf_header_rec.inventory_item_id = FND_API.G_MISS_NUM) THEN

Line 1163: IF (p_x_uf_header_rec.inventory_item_id = FND_API.G_MISS_NUM) THEN

1159: IF (p_x_uf_header_rec.unit_config_header_id = FND_API.G_MISS_NUM) THEN
1160: p_x_uf_header_rec.unit_config_header_id := null;
1161: END IF;
1162:
1163: IF (p_x_uf_header_rec.inventory_item_id = FND_API.G_MISS_NUM) THEN
1164: p_x_uf_header_rec.inventory_item_id := null;
1165: END IF;
1166:
1167: IF (p_x_uf_header_rec.csi_item_instance_id = FND_API.G_MISS_NUM) THEN

Line 1167: IF (p_x_uf_header_rec.csi_item_instance_id = FND_API.G_MISS_NUM) THEN

1163: IF (p_x_uf_header_rec.inventory_item_id = FND_API.G_MISS_NUM) THEN
1164: p_x_uf_header_rec.inventory_item_id := null;
1165: END IF;
1166:
1167: IF (p_x_uf_header_rec.csi_item_instance_id = FND_API.G_MISS_NUM) THEN
1168: p_x_uf_header_rec.csi_item_instance_id := null;
1169: END IF;
1170:
1171: IF (p_x_uf_header_rec.pc_node_id = FND_API.G_MISS_NUM) THEN

Line 1171: IF (p_x_uf_header_rec.pc_node_id = FND_API.G_MISS_NUM) THEN

1167: IF (p_x_uf_header_rec.csi_item_instance_id = FND_API.G_MISS_NUM) THEN
1168: p_x_uf_header_rec.csi_item_instance_id := null;
1169: END IF;
1170:
1171: IF (p_x_uf_header_rec.pc_node_id = FND_API.G_MISS_NUM) THEN
1172: p_x_uf_header_rec.pc_node_id := null;
1173: END IF;
1174:
1175: IF (p_x_uf_header_rec.inventory_org_id = FND_API.G_MISS_NUM) THEN

Line 1175: IF (p_x_uf_header_rec.inventory_org_id = FND_API.G_MISS_NUM) THEN

1171: IF (p_x_uf_header_rec.pc_node_id = FND_API.G_MISS_NUM) THEN
1172: p_x_uf_header_rec.pc_node_id := null;
1173: END IF;
1174:
1175: IF (p_x_uf_header_rec.inventory_org_id = FND_API.G_MISS_NUM) THEN
1176: p_x_uf_header_rec.inventory_org_id := null;
1177: END IF;
1178:
1179: IF (p_x_uf_header_rec.use_unit_flag is null) THEN

Line 1181: ELSIF(p_x_uf_header_rec.use_unit_flag = FND_API.G_MISS_CHAR) THEN

1177: END IF;
1178:
1179: IF (p_x_uf_header_rec.use_unit_flag is null) THEN
1180: p_x_uf_header_rec.use_unit_flag := AHL_UMP_UF_PVT.G_UF_USE_UNIT_DEFAULT;
1181: ELSIF(p_x_uf_header_rec.use_unit_flag = FND_API.G_MISS_CHAR) THEN
1182: p_x_uf_header_rec.use_unit_flag := AHL_UMP_UF_PVT.G_UF_USE_UNIT_DEFAULT;
1183: END IF;
1184:
1185: IF (p_x_uf_header_rec.attribute_category = FND_API.G_MISS_CHAR) THEN

Line 1185: IF (p_x_uf_header_rec.attribute_category = FND_API.G_MISS_CHAR) THEN

1181: ELSIF(p_x_uf_header_rec.use_unit_flag = FND_API.G_MISS_CHAR) THEN
1182: p_x_uf_header_rec.use_unit_flag := AHL_UMP_UF_PVT.G_UF_USE_UNIT_DEFAULT;
1183: END IF;
1184:
1185: IF (p_x_uf_header_rec.attribute_category = FND_API.G_MISS_CHAR) THEN
1186: p_x_uf_header_rec.attribute_category := null;
1187: END IF;
1188: IF (p_x_uf_header_rec.attribute1 = FND_API.G_MISS_CHAR) THEN
1189: p_x_uf_header_rec.attribute1 := null;

Line 1188: IF (p_x_uf_header_rec.attribute1 = FND_API.G_MISS_CHAR) THEN

1184:
1185: IF (p_x_uf_header_rec.attribute_category = FND_API.G_MISS_CHAR) THEN
1186: p_x_uf_header_rec.attribute_category := null;
1187: END IF;
1188: IF (p_x_uf_header_rec.attribute1 = FND_API.G_MISS_CHAR) THEN
1189: p_x_uf_header_rec.attribute1 := null;
1190: END IF;
1191: IF (p_x_uf_header_rec.attribute2 = FND_API.G_MISS_CHAR) THEN
1192: p_x_uf_header_rec.attribute2 := null;

Line 1191: IF (p_x_uf_header_rec.attribute2 = FND_API.G_MISS_CHAR) THEN

1187: END IF;
1188: IF (p_x_uf_header_rec.attribute1 = FND_API.G_MISS_CHAR) THEN
1189: p_x_uf_header_rec.attribute1 := null;
1190: END IF;
1191: IF (p_x_uf_header_rec.attribute2 = FND_API.G_MISS_CHAR) THEN
1192: p_x_uf_header_rec.attribute2 := null;
1193: END IF;
1194: IF (p_x_uf_header_rec.attribute3 = FND_API.G_MISS_CHAR) THEN
1195: p_x_uf_header_rec.attribute3 := null;

Line 1194: IF (p_x_uf_header_rec.attribute3 = FND_API.G_MISS_CHAR) THEN

1190: END IF;
1191: IF (p_x_uf_header_rec.attribute2 = FND_API.G_MISS_CHAR) THEN
1192: p_x_uf_header_rec.attribute2 := null;
1193: END IF;
1194: IF (p_x_uf_header_rec.attribute3 = FND_API.G_MISS_CHAR) THEN
1195: p_x_uf_header_rec.attribute3 := null;
1196: END IF;
1197: IF (p_x_uf_header_rec.attribute4 = FND_API.G_MISS_CHAR) THEN
1198: p_x_uf_header_rec.attribute4 := null;

Line 1197: IF (p_x_uf_header_rec.attribute4 = FND_API.G_MISS_CHAR) THEN

1193: END IF;
1194: IF (p_x_uf_header_rec.attribute3 = FND_API.G_MISS_CHAR) THEN
1195: p_x_uf_header_rec.attribute3 := null;
1196: END IF;
1197: IF (p_x_uf_header_rec.attribute4 = FND_API.G_MISS_CHAR) THEN
1198: p_x_uf_header_rec.attribute4 := null;
1199: END IF;
1200: IF (p_x_uf_header_rec.attribute5 = FND_API.G_MISS_CHAR) THEN
1201: p_x_uf_header_rec.attribute5 := null;

Line 1200: IF (p_x_uf_header_rec.attribute5 = FND_API.G_MISS_CHAR) THEN

1196: END IF;
1197: IF (p_x_uf_header_rec.attribute4 = FND_API.G_MISS_CHAR) THEN
1198: p_x_uf_header_rec.attribute4 := null;
1199: END IF;
1200: IF (p_x_uf_header_rec.attribute5 = FND_API.G_MISS_CHAR) THEN
1201: p_x_uf_header_rec.attribute5 := null;
1202: END IF;
1203: IF (p_x_uf_header_rec.attribute6 = FND_API.G_MISS_CHAR) THEN
1204: p_x_uf_header_rec.attribute6 := null;

Line 1203: IF (p_x_uf_header_rec.attribute6 = FND_API.G_MISS_CHAR) THEN

1199: END IF;
1200: IF (p_x_uf_header_rec.attribute5 = FND_API.G_MISS_CHAR) THEN
1201: p_x_uf_header_rec.attribute5 := null;
1202: END IF;
1203: IF (p_x_uf_header_rec.attribute6 = FND_API.G_MISS_CHAR) THEN
1204: p_x_uf_header_rec.attribute6 := null;
1205: END IF;
1206: IF (p_x_uf_header_rec.attribute7 = FND_API.G_MISS_CHAR) THEN p_x_uf_header_rec.attribute7 := null;
1207: END IF;

Line 1206: IF (p_x_uf_header_rec.attribute7 = FND_API.G_MISS_CHAR) THEN p_x_uf_header_rec.attribute7 := null;

1202: END IF;
1203: IF (p_x_uf_header_rec.attribute6 = FND_API.G_MISS_CHAR) THEN
1204: p_x_uf_header_rec.attribute6 := null;
1205: END IF;
1206: IF (p_x_uf_header_rec.attribute7 = FND_API.G_MISS_CHAR) THEN p_x_uf_header_rec.attribute7 := null;
1207: END IF;
1208: IF (p_x_uf_header_rec.attribute8 = FND_API.G_MISS_CHAR) THEN
1209: p_x_uf_header_rec.attribute8 := null;
1210: END IF;

Line 1208: IF (p_x_uf_header_rec.attribute8 = FND_API.G_MISS_CHAR) THEN

1204: p_x_uf_header_rec.attribute6 := null;
1205: END IF;
1206: IF (p_x_uf_header_rec.attribute7 = FND_API.G_MISS_CHAR) THEN p_x_uf_header_rec.attribute7 := null;
1207: END IF;
1208: IF (p_x_uf_header_rec.attribute8 = FND_API.G_MISS_CHAR) THEN
1209: p_x_uf_header_rec.attribute8 := null;
1210: END IF;
1211: IF (p_x_uf_header_rec.attribute9 = FND_API.G_MISS_CHAR) THEN
1212: p_x_uf_header_rec.attribute9 := null;

Line 1211: IF (p_x_uf_header_rec.attribute9 = FND_API.G_MISS_CHAR) THEN

1207: END IF;
1208: IF (p_x_uf_header_rec.attribute8 = FND_API.G_MISS_CHAR) THEN
1209: p_x_uf_header_rec.attribute8 := null;
1210: END IF;
1211: IF (p_x_uf_header_rec.attribute9 = FND_API.G_MISS_CHAR) THEN
1212: p_x_uf_header_rec.attribute9 := null;
1213: END IF;
1214: IF (p_x_uf_header_rec.attribute10 = FND_API.G_MISS_CHAR) THEN
1215: p_x_uf_header_rec.attribute10 := null;

Line 1214: IF (p_x_uf_header_rec.attribute10 = FND_API.G_MISS_CHAR) THEN

1210: END IF;
1211: IF (p_x_uf_header_rec.attribute9 = FND_API.G_MISS_CHAR) THEN
1212: p_x_uf_header_rec.attribute9 := null;
1213: END IF;
1214: IF (p_x_uf_header_rec.attribute10 = FND_API.G_MISS_CHAR) THEN
1215: p_x_uf_header_rec.attribute10 := null;
1216: END IF;
1217: IF (p_x_uf_header_rec.attribute11 = FND_API.G_MISS_CHAR) THEN
1218: p_x_uf_header_rec.attribute11 := null;

Line 1217: IF (p_x_uf_header_rec.attribute11 = FND_API.G_MISS_CHAR) THEN

1213: END IF;
1214: IF (p_x_uf_header_rec.attribute10 = FND_API.G_MISS_CHAR) THEN
1215: p_x_uf_header_rec.attribute10 := null;
1216: END IF;
1217: IF (p_x_uf_header_rec.attribute11 = FND_API.G_MISS_CHAR) THEN
1218: p_x_uf_header_rec.attribute11 := null;
1219: END IF;
1220: IF (p_x_uf_header_rec.attribute12 = FND_API.G_MISS_CHAR) THEN
1221: p_x_uf_header_rec.attribute12 := null;

Line 1220: IF (p_x_uf_header_rec.attribute12 = FND_API.G_MISS_CHAR) THEN

1216: END IF;
1217: IF (p_x_uf_header_rec.attribute11 = FND_API.G_MISS_CHAR) THEN
1218: p_x_uf_header_rec.attribute11 := null;
1219: END IF;
1220: IF (p_x_uf_header_rec.attribute12 = FND_API.G_MISS_CHAR) THEN
1221: p_x_uf_header_rec.attribute12 := null;
1222: END IF;
1223: IF (p_x_uf_header_rec.attribute13 = FND_API.G_MISS_CHAR) THEN
1224: p_x_uf_header_rec.attribute13 := null;

Line 1223: IF (p_x_uf_header_rec.attribute13 = FND_API.G_MISS_CHAR) THEN

1219: END IF;
1220: IF (p_x_uf_header_rec.attribute12 = FND_API.G_MISS_CHAR) THEN
1221: p_x_uf_header_rec.attribute12 := null;
1222: END IF;
1223: IF (p_x_uf_header_rec.attribute13 = FND_API.G_MISS_CHAR) THEN
1224: p_x_uf_header_rec.attribute13 := null;
1225: END IF;
1226: IF (p_x_uf_header_rec.attribute14 = FND_API.G_MISS_CHAR) THEN
1227: p_x_uf_header_rec.attribute14 := null;

Line 1226: IF (p_x_uf_header_rec.attribute14 = FND_API.G_MISS_CHAR) THEN

1222: END IF;
1223: IF (p_x_uf_header_rec.attribute13 = FND_API.G_MISS_CHAR) THEN
1224: p_x_uf_header_rec.attribute13 := null;
1225: END IF;
1226: IF (p_x_uf_header_rec.attribute14 = FND_API.G_MISS_CHAR) THEN
1227: p_x_uf_header_rec.attribute14 := null;
1228: END IF;
1229: IF (p_x_uf_header_rec.attribute15 = FND_API.G_MISS_CHAR) THEN
1230: p_x_uf_header_rec.attribute15 := null;

Line 1229: IF (p_x_uf_header_rec.attribute15 = FND_API.G_MISS_CHAR) THEN

1225: END IF;
1226: IF (p_x_uf_header_rec.attribute14 = FND_API.G_MISS_CHAR) THEN
1227: p_x_uf_header_rec.attribute14 := null;
1228: END IF;
1229: IF (p_x_uf_header_rec.attribute15 = FND_API.G_MISS_CHAR) THEN
1230: p_x_uf_header_rec.attribute15 := null;
1231: END IF;
1232: END IF;
1233: END default_unchanged_uf_header;

Line 1240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1236: ----------------------------------------------------------
1237: -- This procedure processes uf_detail_rec
1238: ----------------------------------------------------------
1239: PROCEDURE process_uf_details(
1240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1241: p_uf_header_rec IN AHL_UMP_UF_PVT.uf_header_Rec_type,
1242: p_x_uf_details_tbl IN OUT NOCOPY AHL_UMP_UF_PVT.uf_details_tbl_type
1243: ) IS
1244:

Line 1354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
1358:

Line 1429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
1433: p_x_uf_details_tbl(i).end_date = FND_API.G_MISS_DATE) THEN

Line 1433: p_x_uf_details_tbl(i).end_date = FND_API.G_MISS_DATE) 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
1433: p_x_uf_details_tbl(i).end_date = FND_API.G_MISS_DATE) THEN
1434: p_x_uf_details_tbl(i).end_date := NULL;
1435:
1436: -- checking for expected error if record is modified
1437: 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 NOT NULL)THEN

Line 1449: ELSIF p_x_uf_details_tbl(i).end_date = FND_API.G_MISS_DATE THEN

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
1450: p_x_uf_details_tbl(i).end_date := NULL;
1451: END IF;
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;

Line 1454: ELSIF p_x_uf_details_tbl(i).uf_header_id = FND_API.G_MISS_NUM THEN

1450: p_x_uf_details_tbl(i).end_date := NULL;
1451: END IF;
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');

Line 1466: RAISE FND_API.G_EXC_ERROR;

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
1470: IF(p_x_uf_details_tbl(i).operation_flag IN (AHL_UMP_UF_PVT.G_OP_CREATE,AHL_UMP_UF_PVT.G_OP_UPDATE))THEN

Line 1626: RAISE FND_API.G_EXC_ERROR;

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;
1630:

Line 1707: RAISE FND_API.G_EXC_ERROR;

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;
1711:

Line 1743: ELSIF(p_x_uf_details_tbl(i).uf_header_id = FND_API.G_MISS_NUM) THEN

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
1744: p_x_uf_details_tbl(i).uf_header_id := null;
1745: END IF;
1746:
1747: IF (p_x_uf_details_tbl(i).end_date is null) THEN

Line 1749: ELSIF(p_x_uf_details_tbl(i).end_date = FND_API.G_MISS_DATE) THEN

1745: END IF;
1746:
1747: IF (p_x_uf_details_tbl(i).end_date is null) THEN
1748: p_x_uf_details_tbl(i).end_date := l_uf_details_rec.end_date;
1749: ELSIF(p_x_uf_details_tbl(i).end_date = FND_API.G_MISS_DATE) THEN
1750: p_x_uf_details_tbl(i).end_date := null;
1751: END IF;
1752:
1753: IF (p_x_uf_details_tbl(i).attribute_category is null) THEN

Line 1755: ELSIF(p_x_uf_details_tbl(i).attribute_category = FND_API.G_MISS_CHAR) THEN

1751: END IF;
1752:
1753: IF (p_x_uf_details_tbl(i).attribute_category is null) THEN
1754: p_x_uf_details_tbl(i).attribute_category := l_uf_details_rec.attribute_category;
1755: ELSIF(p_x_uf_details_tbl(i).attribute_category = FND_API.G_MISS_CHAR) THEN
1756: p_x_uf_details_tbl(i).attribute_category := null;
1757: END IF;
1758:
1759: IF (p_x_uf_details_tbl(i).attribute1 is null) THEN

Line 1761: ELSIF(p_x_uf_details_tbl(i).attribute1 = FND_API.G_MISS_CHAR) THEN

1757: END IF;
1758:
1759: IF (p_x_uf_details_tbl(i).attribute1 is null) THEN
1760: p_x_uf_details_tbl(i).attribute1 := l_uf_details_rec.attribute1;
1761: ELSIF(p_x_uf_details_tbl(i).attribute1 = FND_API.G_MISS_CHAR) THEN
1762: p_x_uf_details_tbl(i).attribute1 := null;
1763: END IF;
1764:
1765: IF (p_x_uf_details_tbl(i).attribute2 is null) THEN

Line 1767: ELSIF(p_x_uf_details_tbl(i).attribute2 = FND_API.G_MISS_CHAR) THEN

1763: END IF;
1764:
1765: IF (p_x_uf_details_tbl(i).attribute2 is null) THEN
1766: p_x_uf_details_tbl(i).attribute2 := l_uf_details_rec.attribute2;
1767: ELSIF(p_x_uf_details_tbl(i).attribute2 = FND_API.G_MISS_CHAR) THEN
1768: p_x_uf_details_tbl(i).attribute2 := null;
1769: END IF;
1770:
1771: IF (p_x_uf_details_tbl(i).attribute3 is null) THEN

Line 1773: ELSIF(p_x_uf_details_tbl(i).attribute3 = FND_API.G_MISS_CHAR) THEN

1769: END IF;
1770:
1771: IF (p_x_uf_details_tbl(i).attribute3 is null) THEN
1772: p_x_uf_details_tbl(i).attribute3 := l_uf_details_rec.attribute3;
1773: ELSIF(p_x_uf_details_tbl(i).attribute3 = FND_API.G_MISS_CHAR) THEN
1774: p_x_uf_details_tbl(i).attribute3 := null;
1775: END IF;
1776:
1777: IF (p_x_uf_details_tbl(i).attribute4 is null) THEN

Line 1779: ELSIF(p_x_uf_details_tbl(i).attribute4 = FND_API.G_MISS_CHAR) THEN

1775: END IF;
1776:
1777: IF (p_x_uf_details_tbl(i).attribute4 is null) THEN
1778: p_x_uf_details_tbl(i).attribute4 := l_uf_details_rec.attribute4;
1779: ELSIF(p_x_uf_details_tbl(i).attribute4 = FND_API.G_MISS_CHAR) THEN
1780: p_x_uf_details_tbl(i).attribute4 := null;
1781: END IF;
1782:
1783: IF (p_x_uf_details_tbl(i).attribute5 is null) THEN

Line 1785: ELSIF(p_x_uf_details_tbl(i).attribute5 = FND_API.G_MISS_CHAR) THEN

1781: END IF;
1782:
1783: IF (p_x_uf_details_tbl(i).attribute5 is null) THEN
1784: p_x_uf_details_tbl(i).attribute5 := l_uf_details_rec.attribute5;
1785: ELSIF(p_x_uf_details_tbl(i).attribute5 = FND_API.G_MISS_CHAR) THEN
1786: p_x_uf_details_tbl(i).attribute5 := null;
1787: END IF;
1788:
1789: IF (p_x_uf_details_tbl(i).attribute6 is null) THEN

Line 1791: ELSIF(p_x_uf_details_tbl(i).attribute6 = FND_API.G_MISS_CHAR) THEN

1787: END IF;
1788:
1789: IF (p_x_uf_details_tbl(i).attribute6 is null) THEN
1790: p_x_uf_details_tbl(i).attribute6 := l_uf_details_rec.attribute6;
1791: ELSIF(p_x_uf_details_tbl(i).attribute6 = FND_API.G_MISS_CHAR) THEN
1792: p_x_uf_details_tbl(i).attribute6 := null;
1793: END IF;
1794:
1795: IF (p_x_uf_details_tbl(i).attribute7 is null) THEN

Line 1797: ELSIF(p_x_uf_details_tbl(i).attribute7 = FND_API.G_MISS_CHAR) THEN

1793: END IF;
1794:
1795: IF (p_x_uf_details_tbl(i).attribute7 is null) THEN
1796: p_x_uf_details_tbl(i).attribute7 := l_uf_details_rec.attribute7;
1797: ELSIF(p_x_uf_details_tbl(i).attribute7 = FND_API.G_MISS_CHAR) THEN
1798: p_x_uf_details_tbl(i).attribute7 := null;
1799: END IF;
1800:
1801: IF (p_x_uf_details_tbl(i).attribute8 is null) THEN

Line 1803: ELSIF(p_x_uf_details_tbl(i).attribute8 = FND_API.G_MISS_CHAR) THEN

1799: END IF;
1800:
1801: IF (p_x_uf_details_tbl(i).attribute8 is null) THEN
1802: p_x_uf_details_tbl(i).attribute8 := l_uf_details_rec.attribute8;
1803: ELSIF(p_x_uf_details_tbl(i).attribute8 = FND_API.G_MISS_CHAR) THEN
1804: p_x_uf_details_tbl(i).attribute8 := null;
1805: END IF;
1806:
1807: IF (p_x_uf_details_tbl(i).attribute9 is null) THEN

Line 1809: ELSIF(p_x_uf_details_tbl(i).attribute9 = FND_API.G_MISS_CHAR) THEN

1805: END IF;
1806:
1807: IF (p_x_uf_details_tbl(i).attribute9 is null) THEN
1808: p_x_uf_details_tbl(i).attribute9 := l_uf_details_rec.attribute9;
1809: ELSIF(p_x_uf_details_tbl(i).attribute9 = FND_API.G_MISS_CHAR) THEN
1810: p_x_uf_details_tbl(i).attribute9 := null;
1811: END IF;
1812:
1813: IF (p_x_uf_details_tbl(i).attribute10 is null) THEN

Line 1815: ELSIF(p_x_uf_details_tbl(i).attribute10 = FND_API.G_MISS_CHAR) THEN

1811: END IF;
1812:
1813: IF (p_x_uf_details_tbl(i).attribute10 is null) THEN
1814: p_x_uf_details_tbl(i).attribute10 := l_uf_details_rec.attribute10;
1815: ELSIF(p_x_uf_details_tbl(i).attribute10 = FND_API.G_MISS_CHAR) THEN
1816: p_x_uf_details_tbl(i).attribute10 := null;
1817: END IF;
1818:
1819: IF (p_x_uf_details_tbl(i).attribute11 is null) THEN

Line 1821: ELSIF(p_x_uf_details_tbl(i).attribute11 = FND_API.G_MISS_CHAR) THEN

1817: END IF;
1818:
1819: IF (p_x_uf_details_tbl(i).attribute11 is null) THEN
1820: p_x_uf_details_tbl(i).attribute11 := l_uf_details_rec.attribute11;
1821: ELSIF(p_x_uf_details_tbl(i).attribute11 = FND_API.G_MISS_CHAR) THEN
1822: p_x_uf_details_tbl(i).attribute11 := null;
1823: END IF;
1824:
1825: IF (p_x_uf_details_tbl(i).attribute12 is null) THEN

Line 1827: ELSIF(p_x_uf_details_tbl(i).attribute12 = FND_API.G_MISS_CHAR) THEN

1823: END IF;
1824:
1825: IF (p_x_uf_details_tbl(i).attribute12 is null) THEN
1826: p_x_uf_details_tbl(i).attribute12 := l_uf_details_rec.attribute12;
1827: ELSIF(p_x_uf_details_tbl(i).attribute12 = FND_API.G_MISS_CHAR) THEN
1828: p_x_uf_details_tbl(i).attribute12 := null;
1829: END IF;
1830:
1831: IF (p_x_uf_details_tbl(i).attribute13 is null) THEN

Line 1833: ELSIF(p_x_uf_details_tbl(i).attribute13 = FND_API.G_MISS_CHAR) THEN

1829: END IF;
1830:
1831: IF (p_x_uf_details_tbl(i).attribute13 is null) THEN
1832: p_x_uf_details_tbl(i).attribute13 := l_uf_details_rec.attribute13;
1833: ELSIF(p_x_uf_details_tbl(i).attribute13 = FND_API.G_MISS_CHAR) THEN
1834: p_x_uf_details_tbl(i).attribute13 := null;
1835: END IF;
1836:
1837: IF (p_x_uf_details_tbl(i).attribute14 is null) THEN

Line 1839: ELSIF(p_x_uf_details_tbl(i).attribute14 = FND_API.G_MISS_CHAR) THEN

1835: END IF;
1836:
1837: IF (p_x_uf_details_tbl(i).attribute14 is null) THEN
1838: p_x_uf_details_tbl(i).attribute14 := l_uf_details_rec.attribute14;
1839: ELSIF(p_x_uf_details_tbl(i).attribute14 = FND_API.G_MISS_CHAR) THEN
1840: p_x_uf_details_tbl(i).attribute14 := null;
1841: END IF;
1842:
1843: IF (p_x_uf_details_tbl(i).attribute15 is null) THEN

Line 1845: ELSIF(p_x_uf_details_tbl(i).attribute15 = FND_API.G_MISS_CHAR) THEN

1841: END IF;
1842:
1843: IF (p_x_uf_details_tbl(i).attribute15 is null) THEN
1844: p_x_uf_details_tbl(i).attribute15 := l_uf_details_rec.attribute15;
1845: ELSIF(p_x_uf_details_tbl(i).attribute15 = FND_API.G_MISS_CHAR) THEN
1846: p_x_uf_details_tbl(i).attribute15 := null;
1847: END IF;
1848:
1849: END IF;

Line 1853: IF(p_x_uf_details_tbl(i).uf_header_id = FND_API.G_MISS_NUM) THEN

1849: END IF;
1850: CLOSE uf_details_csr;
1851: ELSIF (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE) THEN
1852:
1853: IF(p_x_uf_details_tbl(i).uf_header_id = FND_API.G_MISS_NUM) THEN
1854: p_x_uf_details_tbl(i).uf_header_id := null;
1855: END IF;
1856:
1857: IF(p_x_uf_details_tbl(i).end_date = FND_API.G_MISS_DATE) THEN

Line 1857: IF(p_x_uf_details_tbl(i).end_date = FND_API.G_MISS_DATE) THEN

1853: IF(p_x_uf_details_tbl(i).uf_header_id = FND_API.G_MISS_NUM) THEN
1854: p_x_uf_details_tbl(i).uf_header_id := null;
1855: END IF;
1856:
1857: IF(p_x_uf_details_tbl(i).end_date = FND_API.G_MISS_DATE) THEN
1858: p_x_uf_details_tbl(i).end_date := null;
1859: END IF;
1860: IF (p_x_uf_details_tbl(i).attribute_category = FND_API.G_MISS_CHAR) THEN
1861: p_x_uf_details_tbl(i).attribute_category := null;

Line 1860: IF (p_x_uf_details_tbl(i).attribute_category = FND_API.G_MISS_CHAR) THEN

1856:
1857: IF(p_x_uf_details_tbl(i).end_date = FND_API.G_MISS_DATE) THEN
1858: p_x_uf_details_tbl(i).end_date := null;
1859: END IF;
1860: IF (p_x_uf_details_tbl(i).attribute_category = FND_API.G_MISS_CHAR) THEN
1861: p_x_uf_details_tbl(i).attribute_category := null;
1862: END IF;
1863: IF (p_x_uf_details_tbl(i).attribute1 = FND_API.G_MISS_CHAR) THEN
1864: p_x_uf_details_tbl(i).attribute1 := null;

Line 1863: IF (p_x_uf_details_tbl(i).attribute1 = FND_API.G_MISS_CHAR) THEN

1859: END IF;
1860: IF (p_x_uf_details_tbl(i).attribute_category = FND_API.G_MISS_CHAR) THEN
1861: p_x_uf_details_tbl(i).attribute_category := null;
1862: END IF;
1863: IF (p_x_uf_details_tbl(i).attribute1 = FND_API.G_MISS_CHAR) THEN
1864: p_x_uf_details_tbl(i).attribute1 := null;
1865: END IF;
1866: IF (p_x_uf_details_tbl(i).attribute2 = FND_API.G_MISS_CHAR) THEN
1867: p_x_uf_details_tbl(i).attribute2 := null;

Line 1866: IF (p_x_uf_details_tbl(i).attribute2 = FND_API.G_MISS_CHAR) THEN

1862: END IF;
1863: IF (p_x_uf_details_tbl(i).attribute1 = FND_API.G_MISS_CHAR) THEN
1864: p_x_uf_details_tbl(i).attribute1 := null;
1865: END IF;
1866: IF (p_x_uf_details_tbl(i).attribute2 = FND_API.G_MISS_CHAR) THEN
1867: p_x_uf_details_tbl(i).attribute2 := null;
1868: END IF;
1869: IF (p_x_uf_details_tbl(i).attribute3 = FND_API.G_MISS_CHAR) THEN
1870: p_x_uf_details_tbl(i).attribute3 := null;

Line 1869: IF (p_x_uf_details_tbl(i).attribute3 = FND_API.G_MISS_CHAR) THEN

1865: END IF;
1866: IF (p_x_uf_details_tbl(i).attribute2 = FND_API.G_MISS_CHAR) THEN
1867: p_x_uf_details_tbl(i).attribute2 := null;
1868: END IF;
1869: IF (p_x_uf_details_tbl(i).attribute3 = FND_API.G_MISS_CHAR) THEN
1870: p_x_uf_details_tbl(i).attribute3 := null;
1871: END IF;
1872: IF (p_x_uf_details_tbl(i).attribute4 = FND_API.G_MISS_CHAR) THEN
1873: p_x_uf_details_tbl(i).attribute4 := null;

Line 1872: IF (p_x_uf_details_tbl(i).attribute4 = FND_API.G_MISS_CHAR) THEN

1868: END IF;
1869: IF (p_x_uf_details_tbl(i).attribute3 = FND_API.G_MISS_CHAR) THEN
1870: p_x_uf_details_tbl(i).attribute3 := null;
1871: END IF;
1872: IF (p_x_uf_details_tbl(i).attribute4 = FND_API.G_MISS_CHAR) THEN
1873: p_x_uf_details_tbl(i).attribute4 := null;
1874: END IF;
1875: IF (p_x_uf_details_tbl(i).attribute5 = FND_API.G_MISS_CHAR) THEN
1876: p_x_uf_details_tbl(i).attribute5 := null;

Line 1875: IF (p_x_uf_details_tbl(i).attribute5 = FND_API.G_MISS_CHAR) THEN

1871: END IF;
1872: IF (p_x_uf_details_tbl(i).attribute4 = FND_API.G_MISS_CHAR) THEN
1873: p_x_uf_details_tbl(i).attribute4 := null;
1874: END IF;
1875: IF (p_x_uf_details_tbl(i).attribute5 = FND_API.G_MISS_CHAR) THEN
1876: p_x_uf_details_tbl(i).attribute5 := null;
1877: END IF;
1878: IF (p_x_uf_details_tbl(i).attribute6 = FND_API.G_MISS_CHAR) THEN
1879: p_x_uf_details_tbl(i).attribute6 := null;

Line 1878: IF (p_x_uf_details_tbl(i).attribute6 = FND_API.G_MISS_CHAR) THEN

1874: END IF;
1875: IF (p_x_uf_details_tbl(i).attribute5 = FND_API.G_MISS_CHAR) THEN
1876: p_x_uf_details_tbl(i).attribute5 := null;
1877: END IF;
1878: IF (p_x_uf_details_tbl(i).attribute6 = FND_API.G_MISS_CHAR) THEN
1879: p_x_uf_details_tbl(i).attribute6 := null;
1880: END IF;
1881: IF (p_x_uf_details_tbl(i).attribute7 = FND_API.G_MISS_CHAR) THEN
1882: p_x_uf_details_tbl(i).attribute7 := null;

Line 1881: IF (p_x_uf_details_tbl(i).attribute7 = FND_API.G_MISS_CHAR) THEN

1877: END IF;
1878: IF (p_x_uf_details_tbl(i).attribute6 = FND_API.G_MISS_CHAR) THEN
1879: p_x_uf_details_tbl(i).attribute6 := null;
1880: END IF;
1881: IF (p_x_uf_details_tbl(i).attribute7 = FND_API.G_MISS_CHAR) THEN
1882: p_x_uf_details_tbl(i).attribute7 := null;
1883: END IF;
1884: IF (p_x_uf_details_tbl(i).attribute8 = FND_API.G_MISS_CHAR) THEN
1885: p_x_uf_details_tbl(i).attribute8 := null;

Line 1884: IF (p_x_uf_details_tbl(i).attribute8 = FND_API.G_MISS_CHAR) THEN

1880: END IF;
1881: IF (p_x_uf_details_tbl(i).attribute7 = FND_API.G_MISS_CHAR) THEN
1882: p_x_uf_details_tbl(i).attribute7 := null;
1883: END IF;
1884: IF (p_x_uf_details_tbl(i).attribute8 = FND_API.G_MISS_CHAR) THEN
1885: p_x_uf_details_tbl(i).attribute8 := null;
1886: END IF;
1887: IF (p_x_uf_details_tbl(i).attribute9 = FND_API.G_MISS_CHAR) THEN
1888: p_x_uf_details_tbl(i).attribute9 := null;

Line 1887: IF (p_x_uf_details_tbl(i).attribute9 = FND_API.G_MISS_CHAR) THEN

1883: END IF;
1884: IF (p_x_uf_details_tbl(i).attribute8 = FND_API.G_MISS_CHAR) THEN
1885: p_x_uf_details_tbl(i).attribute8 := null;
1886: END IF;
1887: IF (p_x_uf_details_tbl(i).attribute9 = FND_API.G_MISS_CHAR) THEN
1888: p_x_uf_details_tbl(i).attribute9 := null;
1889: END IF;
1890: IF (p_x_uf_details_tbl(i).attribute10 = FND_API.G_MISS_CHAR) THEN
1891: p_x_uf_details_tbl(i).attribute10 := null;

Line 1890: IF (p_x_uf_details_tbl(i).attribute10 = FND_API.G_MISS_CHAR) THEN

1886: END IF;
1887: IF (p_x_uf_details_tbl(i).attribute9 = FND_API.G_MISS_CHAR) THEN
1888: p_x_uf_details_tbl(i).attribute9 := null;
1889: END IF;
1890: IF (p_x_uf_details_tbl(i).attribute10 = FND_API.G_MISS_CHAR) THEN
1891: p_x_uf_details_tbl(i).attribute10 := null;
1892: END IF;
1893: IF (p_x_uf_details_tbl(i).attribute11 = FND_API.G_MISS_CHAR) THEN
1894: p_x_uf_details_tbl(i).attribute11 := null;

Line 1893: IF (p_x_uf_details_tbl(i).attribute11 = FND_API.G_MISS_CHAR) THEN

1889: END IF;
1890: IF (p_x_uf_details_tbl(i).attribute10 = FND_API.G_MISS_CHAR) THEN
1891: p_x_uf_details_tbl(i).attribute10 := null;
1892: END IF;
1893: IF (p_x_uf_details_tbl(i).attribute11 = FND_API.G_MISS_CHAR) THEN
1894: p_x_uf_details_tbl(i).attribute11 := null;
1895: END IF;
1896: IF (p_x_uf_details_tbl(i).attribute12 = FND_API.G_MISS_CHAR) THEN
1897: p_x_uf_details_tbl(i).attribute12 := null;

Line 1896: IF (p_x_uf_details_tbl(i).attribute12 = FND_API.G_MISS_CHAR) THEN

1892: END IF;
1893: IF (p_x_uf_details_tbl(i).attribute11 = FND_API.G_MISS_CHAR) THEN
1894: p_x_uf_details_tbl(i).attribute11 := null;
1895: END IF;
1896: IF (p_x_uf_details_tbl(i).attribute12 = FND_API.G_MISS_CHAR) THEN
1897: p_x_uf_details_tbl(i).attribute12 := null;
1898: END IF;
1899: IF (p_x_uf_details_tbl(i).attribute13 = FND_API.G_MISS_CHAR) THEN
1900: p_x_uf_details_tbl(i).attribute13 := null;

Line 1899: IF (p_x_uf_details_tbl(i).attribute13 = FND_API.G_MISS_CHAR) THEN

1895: END IF;
1896: IF (p_x_uf_details_tbl(i).attribute12 = FND_API.G_MISS_CHAR) THEN
1897: p_x_uf_details_tbl(i).attribute12 := null;
1898: END IF;
1899: IF (p_x_uf_details_tbl(i).attribute13 = FND_API.G_MISS_CHAR) THEN
1900: p_x_uf_details_tbl(i).attribute13 := null;
1901: END IF;
1902: IF (p_x_uf_details_tbl(i).attribute14 = FND_API.G_MISS_CHAR) THEN
1903: p_x_uf_details_tbl(i).attribute14 := null;

Line 1902: IF (p_x_uf_details_tbl(i).attribute14 = FND_API.G_MISS_CHAR) THEN

1898: END IF;
1899: IF (p_x_uf_details_tbl(i).attribute13 = FND_API.G_MISS_CHAR) THEN
1900: p_x_uf_details_tbl(i).attribute13 := null;
1901: END IF;
1902: IF (p_x_uf_details_tbl(i).attribute14 = FND_API.G_MISS_CHAR) THEN
1903: p_x_uf_details_tbl(i).attribute14 := null;
1904: END IF;
1905: IF (p_x_uf_details_tbl(i).attribute15 = FND_API.G_MISS_CHAR) THEN
1906: p_x_uf_details_tbl(i).attribute15 := null;

Line 1905: IF (p_x_uf_details_tbl(i).attribute15 = FND_API.G_MISS_CHAR) THEN

1901: END IF;
1902: IF (p_x_uf_details_tbl(i).attribute14 = FND_API.G_MISS_CHAR) THEN
1903: p_x_uf_details_tbl(i).attribute14 := null;
1904: END IF;
1905: IF (p_x_uf_details_tbl(i).attribute15 = FND_API.G_MISS_CHAR) THEN
1906: p_x_uf_details_tbl(i).attribute15 := null;
1907: END IF;
1908:
1909: END IF;

Line 1946: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1942: ----------------------------------------------------------------------
1943: -- added parameter p_add_unit_item_forecast to fix bug# 6749351.
1944: -- This flag is currently being applied to only item based forecasts.
1945: PROCEDURE get_uf_from_pc (
1946: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1947: p_pc_node_id IN NUMBER := NULL,
1948: p_inventory_item_id IN NUMBER := NULL,
1949: p_inventory_org_id IN NUMBER := NULL,
1950: p_unit_config_header_id IN NUMBER := NULL,

Line 2263: IF FND_API.To_Boolean( p_init_msg_list)

2259: BEGIN
2260:
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:

Line 2269: x_return_status := FND_API.G_RET_STS_SUCCESS; j := 0;

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;
2270:
2271: --Part 1. Resolve all possible inputs to l_pc_node_id
2272:
2273: --Resolve unit name into unit config header id

Line 2303: x_return_status := FND_API.G_RET_STS_ERROR;

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;
2306:
2307: --Now verify pc node id is in 'COMPLETE' and 'PRIMARY' PC tree

Line 2660: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2656: END get_uf_from_pc;
2657:
2658: PROCEDURE get_uf_from_part (
2659:
2660: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2661: p_csi_item_instance_id IN NUMBER,
2662: p_onward_end_date IN DATE := NULL,
2663: x_UF_details_tbl OUT NOCOPY AHL_UMP_UF_PVT.uf_details_tbl_type,
2664: x_return_status OUT NOCOPY VARCHAR2)

Line 2746: IF FND_API.To_Boolean( p_init_msg_list)

2742:
2743:
2744: BEGIN
2745:
2746: IF FND_API.To_Boolean( p_init_msg_list)
2747: THEN
2748: FND_MSG_PUB.Initialize;
2749: END IF;
2750:

Line 2752: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
2753: j := 0;
2754: IF(p_onward_end_date IS NULL) THEN
2755: OPEN ahl_uf_details_csr(p_csi_item_instance_id);
2756: LOOP