DBA Data[Home] [Help]

APPS.AHL_INV_RESERVATIONS_GRP dependencies on FND_MSG_PUB

Line 98: FND_MSG_PUB.INITIALIZE;

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

Line 116: FND_MSG_PUB.add;

112: -- 1 is 'SUPPLY' and 2 is 'DEMAND' as per WMS TDD
113: IF p_supply_demand_code <> 2 THEN
114: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_AGAINST_DMND_ONLY' );
115: -- The reservations should be against demand, not supply.
116: FND_MSG_PUB.add;
117: -- log the error
118: IF (l_log_statement >= l_log_current_level)THEN
119: fnd_log.string
120: (

Line 132: FND_MSG_PUB.add;

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

Line 188: x_msg_count := FND_MSG_PUB.count_msg;

184: );
185: END IF;
186:
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;

Line 195: FND_MSG_PUB.count_and_get

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
196: (
197: p_count => x_msg_count,
198: p_data => x_msg_data,
199: p_encoded => FND_API.G_FALSE

Line 205: FND_MSG_PUB.count_and_get

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

Line 214: FND_MSG_PUB.count_and_get

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

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

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

Line 225: FND_MSG_PUB.add_exc_msg

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: (
227: p_pkg_name => G_PKG_NAME,
228: p_procedure_name => 'get_available_supply_demand',
229: p_error_text => SUBSTR(SQLERRM,1,240)

Line 232: FND_MSG_PUB.count_and_get

228: p_procedure_name => 'get_available_supply_demand',
229: p_error_text => SUBSTR(SQLERRM,1,240)
230: );
231: END IF;
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

Line 329: FND_MSG_PUB.INITIALIZE;

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
332: IF (l_log_procedure >= l_log_current_level)THEN
333: fnd_log.string

Line 394: FND_MSG_PUB.add;

390: -- Validate the Supply Demand Code
391: -- 1 : 'SUPPLY' 2 : 'DEMAND'.
392: IF p_supply_demand_code <> 2 THEN
393: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_AGAINST_DMND_ONLY' );
394: FND_MSG_PUB.add;
395: --The reservations should be against demand, not supply.
396: -- log the error
397: IF (l_log_statement >= l_log_current_level)THEN
398: fnd_log.string

Line 411: FND_MSG_PUB.add;

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

Line 428: FND_MSG_PUB.add;

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

Line 445: FND_MSG_PUB.add;

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

Line 462: FND_MSG_PUB.add;

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

Line 480: FND_MSG_PUB.add;

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

Line 513: FND_MSG_PUB.add;

509: FETCH get_mtl_dtls_wip_cur INTO l_scheduled_material_id;
510: CLOSE get_mtl_dtls_wip_cur;
511: ELSE
512: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_SUP_DEM_TYPE_INVLD' );
513: FND_MSG_PUB.add;
514: IF (l_log_statement >= l_log_current_level)THEN
515: fnd_log.string
516: (
517: fnd_log.level_statement,

Line 552: x_msg_count := FND_MSG_PUB.count_msg;

548: );
549: END IF;
550:
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;

Line 559: FND_MSG_PUB.count_and_get

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
560: (
561: p_count => x_msg_count,
562: p_data => x_msg_data,
563: p_encoded => FND_API.G_FALSE

Line 569: FND_MSG_PUB.count_and_get

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

Line 578: FND_MSG_PUB.count_and_get

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

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

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

Line 589: FND_MSG_PUB.add_exc_msg

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: (
591: p_pkg_name => G_PKG_NAME,
592: p_procedure_name => 'get_available_supply_demand',
593: p_error_text => SUBSTR(SQLERRM,1,240)

Line 596: FND_MSG_PUB.count_and_get

592: p_procedure_name => 'get_available_supply_demand',
593: p_error_text => SUBSTR(SQLERRM,1,240)
594: );
595: END IF;
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