DBA Data[Home] [Help]

APPS.AHL_MC_NODE_PUB dependencies on FND_MSG_PUB

Line 69: FND_MSG_PUB.Initialize;

65:
66: -- Initialize message list if p_init_msg_list is set to TRUE
67: IF FND_API.TO_BOOLEAN(p_init_msg_list)
68: THEN
69: FND_MSG_PUB.Initialize;
70: END IF;
71:
72: -- Initialize API return status to success
73: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 96: FND_MSG_PUB.ADD;

92: IF (p_x_node_rec.position_ref_meaning IS NULL)
93: THEN
94: -- This is a mandatory field, hence throw error
95: FND_MESSAGE.Set_Name('AHL','AHL_MC_POSREF_NULL');
96: FND_MSG_PUB.ADD;
97: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
98: THEN
99: fnd_log.message
100: (

Line 119: FND_MSG_PUB.ADD;

115: IF NOT (l_ret_val)
116: THEN
117: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_POSREF_INVALID');
118: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
119: FND_MSG_PUB.ADD;
120: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
121: THEN
122: fnd_log.message
123: (

Line 151: FND_MSG_PUB.ADD;

147: IF NOT (l_ret_val)
148: THEN
149: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ATASEQ_INVALID');
150: FND_MESSAGE.Set_Token('ATAMEANING', p_x_node_rec.ata_meaning);
151: FND_MSG_PUB.ADD;
152: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
153: THEN
154: fnd_log.message
155: (

Line 172: FND_MSG_PUB.ADD;

168: THEN
169: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ATASEQ_INVALID');
170: FND_MESSAGE.Set_Token('ATA', p_x_node_rec.ata_meaning);
171: FND_MESSAGE.Set_Token('CODE', p_x_node_rec.ata_code);
172: FND_MSG_PUB.ADD;
173: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
174: THEN
175: fnd_log.message
176: (

Line 191: FND_MSG_PUB.ADD;

187: IF (p_x_node_rec.position_necessity_code IS NULL)
188: THEN
189: -- This is a mandatory field, hence throw error
190: FND_MESSAGE.Set_Name('AHL','AHL_MC_NECESSITY_NULL');
191: FND_MSG_PUB.ADD;
192: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
193: THEN
194: fnd_log.message
195: (

Line 206: FND_MSG_PUB.ADD;

202: THEN
203: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NECESSITY_INVALID');
204: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
205: FND_MESSAGE.Set_Token('CODE', p_x_node_rec.position_necessity_code);
206: FND_MSG_PUB.ADD;
207: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
208: THEN
209: fnd_log.message
210: (

Line 231: FND_MSG_PUB.ADD;

227: IF (get_item_group_id%NOTFOUND)
228: THEN
229: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ITEMGRP_INVALID');
230: FND_MESSAGE.Set_Token('ITEM_GRP', p_x_node_rec.item_group_name);
231: FND_MSG_PUB.ADD;
232: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
233: THEN
234: fnd_log.message
235: (

Line 267: FND_MSG_PUB.ADD;

263: IF (get_subconfig_id%NOTFOUND)
264: THEN
265: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_MC_INVALID');
266: FND_MESSAGE.Set_Token('MC_NAME', p_x_subconfig_tbl(i).name);
267: FND_MSG_PUB.ADD;
268: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
269: THEN
270: fnd_log.message
271: (

Line 283: FND_MSG_PUB.ADD;

279: END IF;
280: CLOSE get_subconfig_id;
281: ELSE
282: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_NULL');
283: FND_MSG_PUB.ADD;
284: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
285: THEN
286: fnd_log.message
287: (

Line 310: FND_MSG_PUB.ADD;

306: IF (p_x_counter_rules_tbl(i).rule_code IS NULL)
307: THEN
308: -- This is a mandatory field, hence throw error
309: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_NULL');
310: FND_MSG_PUB.ADD;
311: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
312: THEN
313: fnd_log.message
314: (

Line 324: FND_MSG_PUB.ADD;

320: ELSIF NOT (AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_COUNTER_RULE_TYPE', p_x_counter_rules_tbl(i).rule_code))
321: THEN
322: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_INVALID');
323: FND_MESSAGE.Set_Token('RULE', p_x_counter_rules_tbl(i).rule_meaning);
324: FND_MSG_PUB.ADD;
325: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
326: THEN
327: fnd_log.message
328: (

Line 340: x_msg_count := FND_MSG_PUB.count_msg;

336: END LOOP;
337: END IF;
338:
339: -- Check Error Message stack.
340: x_msg_count := FND_MSG_PUB.count_msg;
341: IF ( x_msg_count > 0 ) THEN
342: RAISE FND_API.G_EXC_ERROR;
343: END IF;
344: END IF;

Line 404: x_msg_count := FND_MSG_PUB.count_msg;

400: END IF;
401: -- API body ends here
402:
403: -- Check Error Message stack.
404: x_msg_count := FND_MSG_PUB.count_msg;
405:
406: --priyan MEL_CDL
407: IF ( x_msg_count > 0 and l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
408: RAISE FND_API.G_EXC_ERROR;

Line 418: FND_MSG_PUB.count_and_get

414: COMMIT WORK;
415: END IF;
416:
417: -- Standard call to get message count and if count is 1, get message info
418: FND_MSG_PUB.count_and_get
419: (
420: p_count => x_msg_count,
421: p_data => x_msg_data,
422: p_encoded => FND_API.G_FALSE

Line 429: FND_MSG_PUB.count_and_get

425: EXCEPTION
426: WHEN FND_API.G_EXC_ERROR THEN
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: Rollback to Process_Node_SP;
429: FND_MSG_PUB.count_and_get
430: (
431: p_count => x_msg_count,
432: p_data => x_msg_data,
433: p_encoded => FND_API.G_FALSE

Line 439: FND_MSG_PUB.count_and_get

435:
436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
438: Rollback to Process_Node_SP;
439: FND_MSG_PUB.count_and_get
440: (
441: p_count => x_msg_count,
442: p_data => x_msg_data,
443: p_encoded => FND_API.G_FALSE

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

445:
446: WHEN OTHERS THEN
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448: Rollback to Process_Node_SP;
449: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
450: THEN
451: FND_MSG_PUB.add_exc_msg
452: (
453: p_pkg_name => G_PKG_NAME,

Line 451: FND_MSG_PUB.add_exc_msg

447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448: Rollback to Process_Node_SP;
449: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
450: THEN
451: FND_MSG_PUB.add_exc_msg
452: (
453: p_pkg_name => G_PKG_NAME,
454: p_procedure_name => 'Process_Node',
455: p_error_text => SUBSTR(SQLERRM,1,240)

Line 458: FND_MSG_PUB.count_and_get

454: p_procedure_name => 'Process_Node',
455: p_error_text => SUBSTR(SQLERRM,1,240)
456: );
457: END IF;
458: FND_MSG_PUB.count_and_get
459: (
460: p_count => x_msg_count,
461: p_data => x_msg_data,
462: p_encoded => FND_API.G_FALSE

Line 503: FND_MSG_PUB.Initialize;

499:
500: -- Initialize message list if p_init_msg_list is set to TRUE
501: IF FND_API.TO_BOOLEAN(p_init_msg_list)
502: THEN
503: FND_MSG_PUB.Initialize;
504: END IF;
505:
506: -- Initialize API return status to success
507: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 548: x_msg_count := FND_MSG_PUB.count_msg;

544: );
545: END IF;
546:
547: -- Check Error Message stack.
548: x_msg_count := FND_MSG_PUB.count_msg;
549: IF x_msg_count > 0 THEN
550: RAISE FND_API.G_EXC_ERROR;
551: END IF;
552: END LOOP;

Line 567: x_msg_count := FND_MSG_PUB.count_msg;

563: END IF;
564: -- API body ends here
565:
566: -- Check Error Message stack.
567: x_msg_count := FND_MSG_PUB.count_msg;
568: IF x_msg_count > 0 THEN
569: RAISE FND_API.G_EXC_ERROR;
570: END IF;
571:

Line 579: FND_MSG_PUB.count_and_get

575: COMMIT WORK;
576: END IF;
577:
578: -- Standard call to get message count and if count is 1, get message info
579: FND_MSG_PUB.count_and_get
580: (
581: p_count => x_msg_count,
582: p_data => x_msg_data,
583: p_encoded => FND_API.G_FALSE

Line 590: FND_MSG_PUB.count_and_get

586: EXCEPTION
587: WHEN FND_API.G_EXC_ERROR THEN
588: x_return_status := FND_API.G_RET_STS_ERROR;
589: Rollback to Delete_Nodes_SP;
590: FND_MSG_PUB.count_and_get
591: (
592: p_count => x_msg_count,
593: p_data => x_msg_data,
594: p_encoded => FND_API.G_FALSE

Line 600: FND_MSG_PUB.count_and_get

596:
597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
599: Rollback to Delete_Nodes_SP;
600: FND_MSG_PUB.count_and_get
601: (
602: p_count => x_msg_count,
603: p_data => x_msg_data,
604: p_encoded => FND_API.G_FALSE

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

606:
607: WHEN OTHERS THEN
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
609: Rollback to Delete_Nodes_SP;
610: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
611: THEN
612: FND_MSG_PUB.add_exc_msg
613: (
614: p_pkg_name => G_PKG_NAME,

Line 612: FND_MSG_PUB.add_exc_msg

608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
609: Rollback to Delete_Nodes_SP;
610: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
611: THEN
612: FND_MSG_PUB.add_exc_msg
613: (
614: p_pkg_name => G_PKG_NAME,
615: p_procedure_name => 'Delete_Nodes',
616: p_error_text => SUBSTR(SQLERRM,1,240)

Line 619: FND_MSG_PUB.count_and_get

615: p_procedure_name => 'Delete_Nodes',
616: p_error_text => SUBSTR(SQLERRM,1,240)
617: );
618: END IF;
619: FND_MSG_PUB.count_and_get
620: (
621: p_count => x_msg_count,
622: p_data => x_msg_data,
623: p_encoded => FND_API.G_FALSE