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_INV_RESERVATIONS_GRP dependencies on FND_API

Line 87: x_return_status := FND_API.G_RET_STS_SUCCESS;

83: -- Standard start of API savepoint
84: SAVEPOINT GET_AVAILABLE_SUPP_DMND_GRP;
85:
86: -- Initialize return status to success before any code logic/validation
87: x_return_status := FND_API.G_RET_STS_SUCCESS;
88:
89: -- Standard call to check for call compatibility
90: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)
91: THEN

Line 90: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)

86: -- Initialize return status to success before any code logic/validation
87: x_return_status := FND_API.G_RET_STS_SUCCESS;
88:
89: -- Standard call to check for call compatibility
90: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)
91: THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: END IF;
94:

Line 92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

88:
89: -- Standard call to check for call compatibility
90: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)
91: THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: END IF;
94:
95: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
96: IF FND_API.TO_BOOLEAN(p_init_msg_lst)

Line 95: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE

91: THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: END IF;
94:
95: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
96: IF FND_API.TO_BOOLEAN(p_init_msg_lst)
97: THEN
98: FND_MSG_PUB.INITIALIZE;
99: END IF;

Line 96: IF FND_API.TO_BOOLEAN(p_init_msg_lst)

92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: END IF;
94:
95: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
96: IF FND_API.TO_BOOLEAN(p_init_msg_lst)
97: THEN
98: FND_MSG_PUB.INITIALIZE;
99: END IF;
100:

Line 126: RAISE FND_API.G_EXC_ERROR;

122: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
123: 'The reservations should be against demand, not supply.'
124: );
125: END IF;
126: RAISE FND_API.G_EXC_ERROR;
127: END IF;
128:
129: -- Validate the Supply Demand line Detail
130: IF p_supply_demand_line_detail IS NULL OR p_supply_demand_line_detail = fnd_api.g_miss_num THEN

Line 130: IF p_supply_demand_line_detail IS NULL OR p_supply_demand_line_detail = fnd_api.g_miss_num THEN

126: RAISE FND_API.G_EXC_ERROR;
127: END IF;
128:
129: -- Validate the Supply Demand line Detail
130: IF p_supply_demand_line_detail IS NULL OR p_supply_demand_line_detail = fnd_api.g_miss_num THEN
131: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_DMND_LINE_DTL_MAND' );
132: FND_MSG_PUB.add;
133: -- Demand Line Detail is required for CMRO reservations
134: -- log the error

Line 143: RAISE FND_API.G_EXC_ERROR;

139: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
140: 'Demand Line Detail is required for CMRO reservations'
141: );
142: END IF;
143: RAISE FND_API.G_EXC_ERROR;
144: END IF;
145:
146: -- Get the Reserved Quantity
147: OPEN get_rsvd_qty_csr(p_supply_demand_line_detail);

Line 191: RAISE FND_API.G_EXC_ERROR;

187: -- Check Error Message stack.
188: x_msg_count := FND_MSG_PUB.count_msg;
189: IF x_msg_count > 0
190: THEN
191: RAISE FND_API.G_EXC_ERROR;
192: END IF;
193:
194: -- Standard call to get message count and if count is 1, get message info
195: FND_MSG_PUB.count_and_get

Line 199: p_encoded => FND_API.G_FALSE

195: FND_MSG_PUB.count_and_get
196: (
197: p_count => x_msg_count,
198: p_data => x_msg_data,
199: p_encoded => FND_API.G_FALSE
200: );
201:
202: EXCEPTION
203: WHEN FND_API.G_EXC_ERROR THEN

Line 203: WHEN FND_API.G_EXC_ERROR THEN

199: p_encoded => FND_API.G_FALSE
200: );
201:
202: EXCEPTION
203: WHEN FND_API.G_EXC_ERROR THEN
204: x_return_status := FND_API.G_RET_STS_ERROR;
205: FND_MSG_PUB.count_and_get
206: (
207: p_count => x_msg_count,

Line 204: x_return_status := FND_API.G_RET_STS_ERROR;

200: );
201:
202: EXCEPTION
203: WHEN FND_API.G_EXC_ERROR THEN
204: x_return_status := FND_API.G_RET_STS_ERROR;
205: FND_MSG_PUB.count_and_get
206: (
207: p_count => x_msg_count,
208: p_data => x_msg_data,

Line 209: p_encoded => FND_API.G_FALSE

205: FND_MSG_PUB.count_and_get
206: (
207: p_count => x_msg_count,
208: p_data => x_msg_data,
209: p_encoded => FND_API.G_FALSE
210: );
211:
212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

208: p_data => x_msg_data,
209: p_encoded => FND_API.G_FALSE
210: );
211:
212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
214: FND_MSG_PUB.count_and_get
215: (
216: p_count => x_msg_count,

Line 213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

209: p_encoded => FND_API.G_FALSE
210: );
211:
212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
214: FND_MSG_PUB.count_and_get
215: (
216: p_count => x_msg_count,
217: p_data => x_msg_data,

Line 218: p_encoded => FND_API.G_FALSE

214: FND_MSG_PUB.count_and_get
215: (
216: p_count => x_msg_count,
217: p_data => x_msg_data,
218: p_encoded => FND_API.G_FALSE
219: );
220:
221: WHEN OTHERS THEN
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

218: p_encoded => FND_API.G_FALSE
219: );
220:
221: WHEN OTHERS THEN
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
224: THEN
225: FND_MSG_PUB.add_exc_msg
226: (

Line 236: p_encoded => FND_API.G_FALSE

232: FND_MSG_PUB.count_and_get
233: (
234: p_count => x_msg_count,
235: p_data => x_msg_data,
236: p_encoded => FND_API.G_FALSE
237: );
238: END get_available_supply_demand;
239:
240: -- The purpose of this API is to validate whether a supply or a demand line for which the reservation is being

Line 318: x_return_status:= FND_API.G_RET_STS_SUCCESS;

314: -- Standard start of API savepoint
315: SAVEPOINT VALIDATE_SUPPLY_DEMAND_GRP;
316:
317: -- Initialize return status to success before any code logic/validation
318: x_return_status:= FND_API.G_RET_STS_SUCCESS;
319:
320: -- Standard call to check for call compatibility
321: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)
322: THEN

Line 321: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)

317: -- Initialize return status to success before any code logic/validation
318: x_return_status:= FND_API.G_RET_STS_SUCCESS;
319:
320: -- Standard call to check for call compatibility
321: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)
322: THEN
323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
324: END IF;
325:

Line 323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

319:
320: -- Standard call to check for call compatibility
321: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)
322: THEN
323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
324: END IF;
325:
326: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
327: IF FND_API.TO_BOOLEAN(p_init_msg_lst)

Line 326: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE

322: THEN
323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
324: END IF;
325:
326: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
327: IF FND_API.TO_BOOLEAN(p_init_msg_lst)
328: THEN
329: FND_MSG_PUB.INITIALIZE;
330: END IF;

Line 327: IF FND_API.TO_BOOLEAN(p_init_msg_lst)

323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
324: END IF;
325:
326: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
327: IF FND_API.TO_BOOLEAN(p_init_msg_lst)
328: THEN
329: FND_MSG_PUB.INITIALIZE;
330: END IF;
331: -- Log API entry point

Line 405: RAISE FND_API.G_EXC_ERROR;

401: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
402: 'The reservations should be against demand, not supply.'
403: );
404: END IF;
405: RAISE FND_API.G_EXC_ERROR;
406: END IF;
407:
408: -- p_supply_demand_header_id null check
409: IF p_supply_demand_header_id IS NULL OR p_supply_demand_header_id = fnd_api.g_miss_num THEN

Line 409: IF p_supply_demand_header_id IS NULL OR p_supply_demand_header_id = fnd_api.g_miss_num THEN

405: RAISE FND_API.G_EXC_ERROR;
406: END IF;
407:
408: -- p_supply_demand_header_id null check
409: IF p_supply_demand_header_id IS NULL OR p_supply_demand_header_id = fnd_api.g_miss_num THEN
410: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_DMND_HDR_MAND' );
411: FND_MSG_PUB.add;
412: -- Demand header is required for CMRO reservations
413: -- log the error

Line 422: RAISE FND_API.G_EXC_ERROR;

418: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
419: 'Demand header is required for CMRO reservations'
420: );
421: END IF;
422: RAISE FND_API.G_EXC_ERROR;
423: END IF;
424:
425: -- p_supply_demand_line_id null check
426: IF p_supply_demand_line_id IS NULL OR p_supply_demand_line_id = fnd_api.g_miss_num THEN

Line 426: IF p_supply_demand_line_id IS NULL OR p_supply_demand_line_id = fnd_api.g_miss_num THEN

422: RAISE FND_API.G_EXC_ERROR;
423: END IF;
424:
425: -- p_supply_demand_line_id null check
426: IF p_supply_demand_line_id IS NULL OR p_supply_demand_line_id = fnd_api.g_miss_num THEN
427: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_DMND_LINE_MAND' );
428: FND_MSG_PUB.add;
429: -- Demand Line is required for CMRO reservations
430: -- log the error

Line 439: RAISE FND_API.G_EXC_ERROR;

435: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
436: 'Demand Line is required for CMRO reservations'
437: );
438: END IF;
439: RAISE FND_API.G_EXC_ERROR;
440: END IF;
441:
442: -- p_supply_demand_line_detail null check
443: IF p_supply_demand_line_detail IS NULL OR p_supply_demand_line_detail = fnd_api.g_miss_num THEN

Line 443: IF p_supply_demand_line_detail IS NULL OR p_supply_demand_line_detail = fnd_api.g_miss_num THEN

439: RAISE FND_API.G_EXC_ERROR;
440: END IF;
441:
442: -- p_supply_demand_line_detail null check
443: IF p_supply_demand_line_detail IS NULL OR p_supply_demand_line_detail = fnd_api.g_miss_num THEN
444: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_DMND_LINE_DTL_MAND' );
445: FND_MSG_PUB.add;
446: -- Demand Line Detail is required for CMRO reservations
447: -- log the error

Line 456: RAISE FND_API.G_EXC_ERROR;

452: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
453: 'Demand Line Detail is required for CMRO reservations'
454: );
455: END IF;
456: RAISE FND_API.G_EXC_ERROR;
457: END IF;
458:
459: -- p_supply_demand_line_detail null check
460: IF p_organization_id IS NULL OR p_organization_id = fnd_api.g_miss_num THEN

Line 460: IF p_organization_id IS NULL OR p_organization_id = fnd_api.g_miss_num THEN

456: RAISE FND_API.G_EXC_ERROR;
457: END IF;
458:
459: -- p_supply_demand_line_detail null check
460: IF p_organization_id IS NULL OR p_organization_id = fnd_api.g_miss_num THEN
461: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_ORG_MAND_VLD_SUP_DMND' );
462: FND_MSG_PUB.add;
463: -- Organization is mandatory in validate_supply_demand.
464: -- log the error

Line 473: RAISE FND_API.G_EXC_ERROR;

469: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
470: 'Organization is mandatory in validate_supply_demand.'
471: );
472: END IF;
473: RAISE FND_API.G_EXC_ERROR;
474: END IF;
475:
476:
477: -- p_supply_demand_line_detail null check

Line 478: IF p_item_id IS NULL OR p_item_id = fnd_api.g_miss_num THEN

474: END IF;
475:
476:
477: -- p_supply_demand_line_detail null check
478: IF p_item_id IS NULL OR p_item_id = fnd_api.g_miss_num THEN
479: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_ITM_MAND_VLD_SUP_DMND' );
480: FND_MSG_PUB.add;
481: -- Item ID is mandatory in validate_supply_demand.
482: -- log the error

Line 491: RAISE FND_API.G_EXC_ERROR;

487: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
488: 'Item ID is mandatory in validate_supply_demand.'
489: );
490: END IF;
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493:
494: -- Validate the details by seeing whether they exist
495: IF p_supply_demand_type_id = inv_reservation_global.g_source_type_inv THEN

Line 522: RAISE FND_API.G_EXC_ERROR;

518: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
519: 'Wrong value for Supply Demand Type.'
520: );
521: END IF;
522: RAISE FND_API.G_EXC_ERROR;
523: END IF;
524:
525: -- set the return value.
526: IF l_scheduled_material_id is null THEN

Line 555: RAISE FND_API.G_EXC_ERROR;

551: -- Check Error Message stack.
552: x_msg_count := FND_MSG_PUB.count_msg;
553: IF x_msg_count > 0
554: THEN
555: RAISE FND_API.G_EXC_ERROR;
556: END IF;
557:
558: -- Standard call to get message count and if count is 1, get message info
559: FND_MSG_PUB.count_and_get

Line 563: p_encoded => FND_API.G_FALSE

559: FND_MSG_PUB.count_and_get
560: (
561: p_count => x_msg_count,
562: p_data => x_msg_data,
563: p_encoded => FND_API.G_FALSE
564: );
565:
566: EXCEPTION
567: WHEN FND_API.G_EXC_ERROR THEN

Line 567: WHEN FND_API.G_EXC_ERROR THEN

563: p_encoded => FND_API.G_FALSE
564: );
565:
566: EXCEPTION
567: WHEN FND_API.G_EXC_ERROR THEN
568: x_return_status := FND_API.G_RET_STS_ERROR;
569: FND_MSG_PUB.count_and_get
570: (
571: p_count => x_msg_count,

Line 568: x_return_status := FND_API.G_RET_STS_ERROR;

564: );
565:
566: EXCEPTION
567: WHEN FND_API.G_EXC_ERROR THEN
568: x_return_status := FND_API.G_RET_STS_ERROR;
569: FND_MSG_PUB.count_and_get
570: (
571: p_count => x_msg_count,
572: p_data => x_msg_data,

Line 573: p_encoded => FND_API.G_FALSE

569: FND_MSG_PUB.count_and_get
570: (
571: p_count => x_msg_count,
572: p_data => x_msg_data,
573: p_encoded => FND_API.G_FALSE
574: );
575:
576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

572: p_data => x_msg_data,
573: p_encoded => FND_API.G_FALSE
574: );
575:
576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
578: FND_MSG_PUB.count_and_get
579: (
580: p_count => x_msg_count,

Line 577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

573: p_encoded => FND_API.G_FALSE
574: );
575:
576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
578: FND_MSG_PUB.count_and_get
579: (
580: p_count => x_msg_count,
581: p_data => x_msg_data,

Line 582: p_encoded => FND_API.G_FALSE

578: FND_MSG_PUB.count_and_get
579: (
580: p_count => x_msg_count,
581: p_data => x_msg_data,
582: p_encoded => FND_API.G_FALSE
583: );
584:
585: WHEN OTHERS THEN
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

582: p_encoded => FND_API.G_FALSE
583: );
584:
585: WHEN OTHERS THEN
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
587: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
588: THEN
589: FND_MSG_PUB.add_exc_msg
590: (

Line 600: p_encoded => FND_API.G_FALSE

596: FND_MSG_PUB.count_and_get
597: (
598: p_count => x_msg_count,
599: p_data => x_msg_data,
600: p_encoded => FND_API.G_FALSE
601: );
602: END validate_supply_demand;
603:
604: END AHL_INV_RESERVATIONS_GRP;