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 108: x_return_status := FND_API.G_RET_STS_SUCCESS;

104: -- Standard start of API savepoint
105: SAVEPOINT GET_AVAILABLE_SUPP_DMND_GRP;
106:
107: -- Initialize return status to success before any code logic/validation
108: x_return_status := FND_API.G_RET_STS_SUCCESS;
109:
110: -- Standard call to check for call compatibility
111: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)
112: THEN

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

107: -- Initialize return status to success before any code logic/validation
108: x_return_status := FND_API.G_RET_STS_SUCCESS;
109:
110: -- Standard call to check for call compatibility
111: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)
112: THEN
113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
114: END IF;
115:

Line 113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

109:
110: -- Standard call to check for call compatibility
111: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)
112: THEN
113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
114: END IF;
115:
116: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
117: IF FND_API.TO_BOOLEAN(p_init_msg_lst)

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

112: THEN
113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
114: END IF;
115:
116: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
117: IF FND_API.TO_BOOLEAN(p_init_msg_lst)
118: THEN
119: FND_MSG_PUB.INITIALIZE;
120: END IF;

Line 117: IF FND_API.TO_BOOLEAN(p_init_msg_lst)

113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
114: END IF;
115:
116: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
117: IF FND_API.TO_BOOLEAN(p_init_msg_lst)
118: THEN
119: FND_MSG_PUB.INITIALIZE;
120: END IF;
121: l_msg_count := FND_MSG_PUB.count_msg;

Line 152: RAISE FND_API.G_EXC_ERROR;

148: --'The reservations should be against demand, not supply.'
149: 'Invalid value for supply demand code.'
150: );
151: END IF;
152: RAISE FND_API.G_EXC_ERROR;
153: END IF;
154:
155: IF (p_supply_demand_code = 2) THEN
156: --Check available quantity for demand

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

154:
155: IF (p_supply_demand_code = 2) THEN
156: --Check available quantity for demand
157: -- Validate the Supply Demand line Detail
158: IF p_supply_demand_line_detail IS NULL OR p_supply_demand_line_detail = fnd_api.g_miss_num THEN
159: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_DMND_LINE_DTL_MAND' );
160: FND_MSG_PUB.add;
161: -- Demand Line Detail is required for CMRO reservations
162: -- log the error

Line 171: RAISE FND_API.G_EXC_ERROR;

167: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
168: 'Demand Line Detail is required for CMRO reservations'
169: );
170: END IF;
171: RAISE FND_API.G_EXC_ERROR;
172: END IF;
173:
174: -- Get the Reserved Quantity
175: OPEN get_rsvd_qty_csr(p_supply_demand_line_detail);

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

204:
205: ELSIF (p_supply_demand_code = 1) THEN
206: --Check available quantity for supply
207: -- p_supply_demand_header_id null check
208: IF p_supply_demand_header_id IS NULL OR p_supply_demand_header_id = fnd_api.g_miss_num THEN
209: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_DMND_HDR_MAND' );
210: FND_MSG_PUB.add;
211: -- Demand header is required for CMRO reservations
212: -- log the error

Line 222: RAISE FND_API.G_EXC_ERROR;

218: 'Demand header is required for CMRO reservations'
219: );
220: END IF;
221: -- End logging
222: RAISE FND_API.G_EXC_ERROR;
223: END IF;
224:
225: IF (p_supply_demand_type_id = inv_reservation_global.g_source_type_wip) THEN
226: --Check job existance only if supply_demand_type_id is of WIP as we are checking for WO supply only.

Line 243: RAISE FND_API.G_EXC_ERROR;

239: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
240: 'Wrong value for Supply Demand Type.'
241: );
242: END IF;
243: RAISE FND_API.G_EXC_ERROR;
244: END IF;
245:
246: --Populate return variable
247: IF (l_wo_quantity IS NULL) THEN

Line 279: RAISE FND_API.G_EXC_ERROR;

275: -- Check Error Message stack.
276: x_msg_count := FND_MSG_PUB.count_msg;
277: IF x_msg_count > l_msg_count
278: THEN
279: RAISE FND_API.G_EXC_ERROR;
280: END IF;
281:
282: -- Standard call to get message count and if count is 1, get message info
283: FND_MSG_PUB.count_and_get

Line 287: p_encoded => FND_API.G_FALSE

283: FND_MSG_PUB.count_and_get
284: (
285: p_count => x_msg_count,
286: p_data => x_msg_data,
287: p_encoded => FND_API.G_FALSE
288: );
289:
290: EXCEPTION
291: WHEN FND_API.G_EXC_ERROR THEN

Line 291: WHEN FND_API.G_EXC_ERROR THEN

287: p_encoded => FND_API.G_FALSE
288: );
289:
290: EXCEPTION
291: WHEN FND_API.G_EXC_ERROR THEN
292: x_return_status := FND_API.G_RET_STS_ERROR;
293: FND_MSG_PUB.count_and_get
294: (
295: p_count => x_msg_count,

Line 292: x_return_status := FND_API.G_RET_STS_ERROR;

288: );
289:
290: EXCEPTION
291: WHEN FND_API.G_EXC_ERROR THEN
292: x_return_status := FND_API.G_RET_STS_ERROR;
293: FND_MSG_PUB.count_and_get
294: (
295: p_count => x_msg_count,
296: p_data => x_msg_data,

Line 297: p_encoded => FND_API.G_FALSE

293: FND_MSG_PUB.count_and_get
294: (
295: p_count => x_msg_count,
296: p_data => x_msg_data,
297: p_encoded => FND_API.G_FALSE
298: );
299:
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

296: p_data => x_msg_data,
297: p_encoded => FND_API.G_FALSE
298: );
299:
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: FND_MSG_PUB.count_and_get
303: (
304: p_count => x_msg_count,

Line 301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

297: p_encoded => FND_API.G_FALSE
298: );
299:
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: FND_MSG_PUB.count_and_get
303: (
304: p_count => x_msg_count,
305: p_data => x_msg_data,

Line 306: p_encoded => FND_API.G_FALSE

302: FND_MSG_PUB.count_and_get
303: (
304: p_count => x_msg_count,
305: p_data => x_msg_data,
306: p_encoded => FND_API.G_FALSE
307: );
308:
309: WHEN OTHERS THEN
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

306: p_encoded => FND_API.G_FALSE
307: );
308:
309: WHEN OTHERS THEN
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
312: THEN
313: FND_MSG_PUB.add_exc_msg
314: (

Line 324: p_encoded => FND_API.G_FALSE

320: FND_MSG_PUB.count_and_get
321: (
322: p_count => x_msg_count,
323: p_data => x_msg_data,
324: p_encoded => FND_API.G_FALSE
325: );
326: END get_available_supply_demand;
327:
328: -- The purpose of this API is to validate whether a supply or a demand line for which the reservation is being

Line 434: x_return_status:= FND_API.G_RET_STS_SUCCESS;

430: -- Standard start of API savepoint
431: SAVEPOINT VALIDATE_SUPPLY_DEMAND_GRP;
432:
433: -- Initialize return status to success before any code logic/validation
434: x_return_status:= FND_API.G_RET_STS_SUCCESS;
435:
436: -- Standard call to check for call compatibility
437: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)
438: THEN

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

433: -- Initialize return status to success before any code logic/validation
434: x_return_status:= FND_API.G_RET_STS_SUCCESS;
435:
436: -- Standard call to check for call compatibility
437: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)
438: THEN
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: END IF;
441:

Line 439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

435:
436: -- Standard call to check for call compatibility
437: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)
438: THEN
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: END IF;
441:
442: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
443: IF FND_API.TO_BOOLEAN(p_init_msg_lst)

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

438: THEN
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: END IF;
441:
442: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
443: IF FND_API.TO_BOOLEAN(p_init_msg_lst)
444: THEN
445: FND_MSG_PUB.INITIALIZE;
446: END IF;

Line 443: IF FND_API.TO_BOOLEAN(p_init_msg_lst)

439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: END IF;
441:
442: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
443: IF FND_API.TO_BOOLEAN(p_init_msg_lst)
444: THEN
445: FND_MSG_PUB.INITIALIZE;
446: END IF;
447: l_msg_count := FND_MSG_PUB.count_msg;

Line 526: RAISE FND_API.G_EXC_ERROR;

522: --'The reservations should be against demand, not supply.'
523: 'Invalid value for supply demand code.'
524: );
525: END IF;
526: RAISE FND_API.G_EXC_ERROR;
527: END IF;
528:
529: --sukhwsin::Marshling enhancements - moved validations for common parameters on above and specific validations inside particular branch.
530: --common mandatory parameters for supply and demand are p_supply_demand_header_id, p_organization_id, p_item_id

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

528:
529: --sukhwsin::Marshling enhancements - moved validations for common parameters on above and specific validations inside particular branch.
530: --common mandatory parameters for supply and demand are p_supply_demand_header_id, p_organization_id, p_item_id
531: -- p_supply_demand_header_id null check
532: IF p_supply_demand_header_id IS NULL OR p_supply_demand_header_id = fnd_api.g_miss_num THEN
533: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_DMND_HDR_MAND' );
534: FND_MSG_PUB.add;
535: -- Demand header is required for CMRO reservations
536: -- log the error

Line 545: RAISE FND_API.G_EXC_ERROR;

541: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
542: 'Demand header is required for CMRO reservations'
543: );
544: END IF;
545: RAISE FND_API.G_EXC_ERROR;
546: END IF;
547:
548: -- p_organization_id null check
549: IF p_organization_id IS NULL OR p_organization_id = fnd_api.g_miss_num THEN

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

545: RAISE FND_API.G_EXC_ERROR;
546: END IF;
547:
548: -- p_organization_id null check
549: IF p_organization_id IS NULL OR p_organization_id = fnd_api.g_miss_num THEN
550: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_ORG_MAND_VLD_SUP_DMND' );
551: FND_MSG_PUB.add;
552: -- Organization is mandatory in validate_supply_demand.
553: -- log the error

Line 562: RAISE FND_API.G_EXC_ERROR;

558: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
559: 'Organization is mandatory in validate_supply_demand.'
560: );
561: END IF;
562: RAISE FND_API.G_EXC_ERROR;
563: END IF;
564:
565:
566: -- p_item_id null check

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

563: END IF;
564:
565:
566: -- p_item_id null check
567: IF p_item_id IS NULL OR p_item_id = fnd_api.g_miss_num THEN
568: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_ITM_MAND_VLD_SUP_DMND' );
569: FND_MSG_PUB.add;
570: -- Item ID is mandatory in validate_supply_demand.
571: -- log the error

Line 580: RAISE FND_API.G_EXC_ERROR;

576: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
577: 'Item ID is mandatory in validate_supply_demand.'
578: );
579: END IF;
580: RAISE FND_API.G_EXC_ERROR;
581: END IF;
582:
583: IF (p_supply_demand_code = 2 ) THEN
584: --Validations for demand.

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

582:
583: IF (p_supply_demand_code = 2 ) THEN
584: --Validations for demand.
585: -- p_supply_demand_line_id null check
586: IF p_supply_demand_line_id IS NULL OR p_supply_demand_line_id = fnd_api.g_miss_num THEN
587: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_DMND_LINE_MAND' );
588: FND_MSG_PUB.add;
589: -- Demand Line is required for CMRO reservations
590: -- log the error

Line 599: RAISE FND_API.G_EXC_ERROR;

595: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
596: 'Demand Line is required for CMRO reservations'
597: );
598: END IF;
599: RAISE FND_API.G_EXC_ERROR;
600: END IF;
601:
602: -- p_supply_demand_line_detail null check
603: IF p_supply_demand_line_detail IS NULL OR p_supply_demand_line_detail = fnd_api.g_miss_num THEN

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

599: RAISE FND_API.G_EXC_ERROR;
600: END IF;
601:
602: -- p_supply_demand_line_detail null check
603: IF p_supply_demand_line_detail IS NULL OR p_supply_demand_line_detail = fnd_api.g_miss_num THEN
604: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_DMND_LINE_DTL_MAND' );
605: FND_MSG_PUB.add;
606: -- Demand Line Detail is required for CMRO reservations
607: -- log the error

Line 616: RAISE FND_API.G_EXC_ERROR;

612: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
613: 'Demand Line Detail is required for CMRO reservations'
614: );
615: END IF;
616: RAISE FND_API.G_EXC_ERROR;
617: END IF;
618:
619: -- Validate the details by seeing whether they exist
620: IF p_supply_demand_type_id = inv_reservation_global.g_source_type_inv THEN

Line 647: RAISE FND_API.G_EXC_ERROR;

643: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
644: 'Wrong value for Supply Demand Type.'
645: );
646: END IF;
647: RAISE FND_API.G_EXC_ERROR;
648: END IF;
649:
650: -- set the return value.
651: IF l_scheduled_material_id is null THEN

Line 679: RAISE FND_API.G_EXC_ERROR;

675: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
676: 'Wrong value for Supply Demand Type.'
677: );
678: END IF;
679: RAISE FND_API.G_EXC_ERROR;
680: END IF;
681:
682: IF (l_job_exists IS NULL) THEN
683: x_valid_status := 'N';

Line 714: RAISE FND_API.G_EXC_ERROR;

710: -- Check Error Message stack.
711: x_msg_count := FND_MSG_PUB.count_msg;
712: IF x_msg_count > l_msg_count
713: THEN
714: RAISE FND_API.G_EXC_ERROR;
715: END IF;
716:
717: -- Standard call to get message count and if count is 1, get message info
718: FND_MSG_PUB.count_and_get

Line 722: p_encoded => FND_API.G_FALSE

718: FND_MSG_PUB.count_and_get
719: (
720: p_count => x_msg_count,
721: p_data => x_msg_data,
722: p_encoded => FND_API.G_FALSE
723: );
724: IF (l_log_procedure >= l_log_current_level)THEN
725: fnd_log.string
726: (

Line 734: WHEN FND_API.G_EXC_ERROR THEN

730: ' and x_valid_status = ' || x_valid_status
731: );
732: END IF;
733: EXCEPTION
734: WHEN FND_API.G_EXC_ERROR THEN
735: x_return_status := FND_API.G_RET_STS_ERROR;
736: FND_MSG_PUB.count_and_get
737: (
738: p_count => x_msg_count,

Line 735: x_return_status := FND_API.G_RET_STS_ERROR;

731: );
732: END IF;
733: EXCEPTION
734: WHEN FND_API.G_EXC_ERROR THEN
735: x_return_status := FND_API.G_RET_STS_ERROR;
736: FND_MSG_PUB.count_and_get
737: (
738: p_count => x_msg_count,
739: p_data => x_msg_data,

Line 740: p_encoded => FND_API.G_FALSE

736: FND_MSG_PUB.count_and_get
737: (
738: p_count => x_msg_count,
739: p_data => x_msg_data,
740: p_encoded => FND_API.G_FALSE
741: );
742:
743: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 743: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

739: p_data => x_msg_data,
740: p_encoded => FND_API.G_FALSE
741: );
742:
743: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
745: FND_MSG_PUB.count_and_get
746: (
747: p_count => x_msg_count,

Line 744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

740: p_encoded => FND_API.G_FALSE
741: );
742:
743: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
745: FND_MSG_PUB.count_and_get
746: (
747: p_count => x_msg_count,
748: p_data => x_msg_data,

Line 749: p_encoded => FND_API.G_FALSE

745: FND_MSG_PUB.count_and_get
746: (
747: p_count => x_msg_count,
748: p_data => x_msg_data,
749: p_encoded => FND_API.G_FALSE
750: );
751:
752: WHEN OTHERS THEN
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

749: p_encoded => FND_API.G_FALSE
750: );
751:
752: WHEN OTHERS THEN
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
754: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
755: THEN
756: FND_MSG_PUB.add_exc_msg
757: (

Line 767: p_encoded => FND_API.G_FALSE

763: FND_MSG_PUB.count_and_get
764: (
765: p_count => x_msg_count,
766: p_data => x_msg_data,
767: p_encoded => FND_API.G_FALSE
768: );
769: END validate_supply_demand;
770:
771: END AHL_INV_RESERVATIONS_GRP;