DBA Data[Home] [Help]

APPS.AHL_INV_RESERVATIONS_GRP dependencies on FND_MSG_PUB

Line 119: FND_MSG_PUB.INITIALIZE;

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;
122: -- Log API entry point
123: IF (l_log_procedure >= l_log_current_level)THEN

Line 121: l_msg_count := FND_MSG_PUB.count_msg;

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;
122: -- Log API entry point
123: IF (l_log_procedure >= l_log_current_level)THEN
124: fnd_log.string
125: (

Line 141: FND_MSG_PUB.add;

137: IF (p_supply_demand_code NOT IN (1, 2)) THEN
138: --FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_AGAINST_DMND_ONLY' );
139: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_SUP_DMD' );
140: -- Invalid value for supply demand code.
141: FND_MSG_PUB.add;
142: -- log the error
143: IF (l_log_statement >= l_log_current_level)THEN
144: fnd_log.string
145: (

Line 160: FND_MSG_PUB.add;

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
163: IF (l_log_statement >= l_log_current_level)THEN
164: fnd_log.string

Line 210: FND_MSG_PUB.add;

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
213: IF (l_log_statement >= l_log_current_level)THEN
214: fnd_log.string

Line 234: FND_MSG_PUB.add;

230: CLOSE get_workorder_quantity;
231: ELSE
232: --If Supply demand type is not equal to WIP then raise error, as this supply check is only applicable on WIP supply.
233: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_SUP_DEM_TYPE_INVLD' );
234: FND_MSG_PUB.add;
235: IF (l_log_statement >= l_log_current_level)THEN
236: fnd_log.string
237: (
238: fnd_log.level_statement,

Line 276: x_msg_count := FND_MSG_PUB.count_msg;

272: );
273: END IF;
274:
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;

Line 283: FND_MSG_PUB.count_and_get

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
284: (
285: p_count => x_msg_count,
286: p_data => x_msg_data,
287: p_encoded => FND_API.G_FALSE

Line 293: FND_MSG_PUB.count_and_get

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,
297: p_encoded => FND_API.G_FALSE

Line 302: FND_MSG_PUB.count_and_get

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,
306: p_encoded => FND_API.G_FALSE

Line 311: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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: (
315: p_pkg_name => G_PKG_NAME,

Line 313: FND_MSG_PUB.add_exc_msg

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: (
315: p_pkg_name => G_PKG_NAME,
316: p_procedure_name => 'get_available_supply_demand',
317: p_error_text => SUBSTR(SQLERRM,1,240)

Line 320: FND_MSG_PUB.count_and_get

316: p_procedure_name => 'get_available_supply_demand',
317: p_error_text => SUBSTR(SQLERRM,1,240)
318: );
319: END IF;
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

Line 445: FND_MSG_PUB.INITIALIZE;

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;
448: -- Log API entry point
449: IF (l_log_procedure >= l_log_current_level)THEN

Line 447: l_msg_count := FND_MSG_PUB.count_msg;

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;
448: -- Log API entry point
449: IF (l_log_procedure >= l_log_current_level)THEN
450: fnd_log.string
451: (

Line 514: FND_MSG_PUB.add;

510: -- 1 : 'SUPPLY' 2 : 'DEMAND'.
511: --IF p_supply_demand_code <> 2 THEN
512: IF (p_supply_demand_code NOT IN (1, 2)) THEN
513: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_SUP_DMD' );
514: FND_MSG_PUB.add;
515: --Invalid value for supply demand code.
516: -- log the error
517: IF (l_log_statement >= l_log_current_level)THEN
518: fnd_log.string

Line 534: FND_MSG_PUB.add;

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
537: IF (l_log_statement >= l_log_current_level)THEN
538: fnd_log.string

Line 551: FND_MSG_PUB.add;

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
554: IF (l_log_statement >= l_log_current_level)THEN
555: fnd_log.string

Line 569: FND_MSG_PUB.add;

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
572: IF (l_log_statement >= l_log_current_level)THEN
573: fnd_log.string

Line 588: FND_MSG_PUB.add;

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
591: IF (l_log_statement >= l_log_current_level)THEN
592: fnd_log.string

Line 605: FND_MSG_PUB.add;

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
608: IF (l_log_statement >= l_log_current_level)THEN
609: fnd_log.string

Line 638: FND_MSG_PUB.add;

634: FETCH get_mtl_dtls_wip_cur INTO l_scheduled_material_id;
635: CLOSE get_mtl_dtls_wip_cur;
636: ELSE
637: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_SUP_DEM_TYPE_INVLD' );
638: FND_MSG_PUB.add;
639: IF (l_log_statement >= l_log_current_level)THEN
640: fnd_log.string
641: (
642: fnd_log.level_statement,

Line 670: FND_MSG_PUB.add;

666: CLOSE validate_wip_supply;
667: ELSE
668: --If Supply demand type is not equal to WIP then raise error, as this supply check is only applicable on WIP supply.
669: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_SUP_DEM_TYPE_INVLD' );
670: FND_MSG_PUB.add;
671: IF (l_log_statement >= l_log_current_level)THEN
672: fnd_log.string
673: (
674: fnd_log.level_statement,

Line 711: x_msg_count := FND_MSG_PUB.count_msg;

707: );
708: END IF;
709:
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;

Line 718: FND_MSG_PUB.count_and_get

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
719: (
720: p_count => x_msg_count,
721: p_data => x_msg_data,
722: p_encoded => FND_API.G_FALSE

Line 736: FND_MSG_PUB.count_and_get

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,
740: p_encoded => FND_API.G_FALSE

Line 745: FND_MSG_PUB.count_and_get

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,
749: p_encoded => FND_API.G_FALSE

Line 754: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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: (
758: p_pkg_name => G_PKG_NAME,

Line 756: FND_MSG_PUB.add_exc_msg

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: (
758: p_pkg_name => G_PKG_NAME,
759: p_procedure_name => 'get_available_supply_demand',
760: p_error_text => SUBSTR(SQLERRM,1,240)

Line 763: FND_MSG_PUB.count_and_get

759: p_procedure_name => 'get_available_supply_demand',
760: p_error_text => SUBSTR(SQLERRM,1,240)
761: );
762: END IF;
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