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

Line 10: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

6: ---------------------
7: PROCEDURE Process_Node
8: (
9: p_api_version IN NUMBER,
10: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
11: p_commit IN VARCHAR2 := FND_API.G_FALSE,
12: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
13: p_module_type IN VARCHAR2 := 'JSP',
14: x_return_status OUT NOCOPY VARCHAR2,

Line 11: p_commit IN VARCHAR2 := FND_API.G_FALSE,

7: PROCEDURE Process_Node
8: (
9: p_api_version IN NUMBER,
10: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
11: p_commit IN VARCHAR2 := FND_API.G_FALSE,
12: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
13: p_module_type IN VARCHAR2 := 'JSP',
14: x_return_status OUT NOCOPY VARCHAR2,
15: x_msg_count OUT NOCOPY NUMBER,

Line 12: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

8: (
9: p_api_version IN NUMBER,
10: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
11: p_commit IN VARCHAR2 := FND_API.G_FALSE,
12: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
13: p_module_type IN VARCHAR2 := 'JSP',
14: x_return_status OUT NOCOPY VARCHAR2,
15: x_msg_count OUT NOCOPY NUMBER,
16: x_msg_data OUT NOCOPY VARCHAR2,

Line 61: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

57: -- Standard start of API savepoint
58: SAVEPOINT Process_Node_SP;
59:
60: -- Standard call to check for call compatibility
61: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
62: THEN
63: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
64: END IF;
65:

Line 63: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

59:
60: -- Standard call to check for call compatibility
61: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
62: THEN
63: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
64: END IF;
65:
66: -- Initialize message list if p_init_msg_list is set to TRUE
67: IF FND_API.TO_BOOLEAN(p_init_msg_list)

Line 67: IF FND_API.TO_BOOLEAN(p_init_msg_list)

63: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
64: END IF;
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:

Line 73: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
74:
75: -- API body starts here
76: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
77: THEN

Line 137: IF (p_x_node_rec.ata_meaning IS NOT NULL AND p_x_node_rec.ata_meaning <> FND_API.G_MISS_CHAR)

133: ---- Validate and Convert node ata meaning to code
134: p_x_node_rec.ata_meaning := RTRIM(p_x_node_rec.ata_meaning);
135:
136: ---- This field is represented in UI with an LOV, hence need to check for validity of the meaning only
137: IF (p_x_node_rec.ata_meaning IS NOT NULL AND p_x_node_rec.ata_meaning <> FND_API.G_MISS_CHAR)
138: THEN
139: AHL_UTIL_MC_PKG.Convert_To_LookupCode
140: (
141: 'AHL_ATA_CODE',

Line 167: /*(p_x_node_rec.ata_code IS NOT NULL AND p_x_node_rec.ata_code <> FND_API.G_MISS_CHAR AND NOT (AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_ATA_CODE', p_x_node_rec.ata_code)))

163: -- Not a mandatory field, hence ensure no ID is passed to PVT if there is no name
164: p_x_node_rec.ata_code := null;
165: END IF;
166:
167: /*(p_x_node_rec.ata_code IS NOT NULL AND p_x_node_rec.ata_code <> FND_API.G_MISS_CHAR AND NOT (AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_ATA_CODE', p_x_node_rec.ata_code)))
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);

Line 342: RAISE FND_API.G_EXC_ERROR;

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;
345:
346: -- Call PVT APIs accordingly

Line 352: p_init_msg_list => FND_API.G_FALSE,

348: THEN
349: AHL_MC_Node_PVT.Create_Node
350: (
351: p_api_version => 1.0,
352: p_init_msg_list => FND_API.G_FALSE,
353: p_commit => FND_API.G_FALSE,
354: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
355: x_return_status => l_return_status,
356: x_msg_count => l_msg_count,

Line 353: p_commit => FND_API.G_FALSE,

349: AHL_MC_Node_PVT.Create_Node
350: (
351: p_api_version => 1.0,
352: p_init_msg_list => FND_API.G_FALSE,
353: p_commit => FND_API.G_FALSE,
354: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
355: x_return_status => l_return_status,
356: x_msg_count => l_msg_count,
357: x_msg_data => l_msg_data,

Line 354: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

350: (
351: p_api_version => 1.0,
352: p_init_msg_list => FND_API.G_FALSE,
353: p_commit => FND_API.G_FALSE,
354: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
355: x_return_status => l_return_status,
356: x_msg_count => l_msg_count,
357: x_msg_data => l_msg_data,
358: p_x_node_rec => p_x_node_rec,

Line 367: p_init_msg_list => FND_API.G_FALSE,

363: THEN
364: AHL_MC_Node_PVT.Delete_Node
365: (
366: p_api_version => 1.0,
367: p_init_msg_list => FND_API.G_FALSE,
368: p_commit => FND_API.G_FALSE,
369: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
370: x_return_status => l_return_status,
371: x_msg_count => l_msg_count,

Line 368: p_commit => FND_API.G_FALSE,

364: AHL_MC_Node_PVT.Delete_Node
365: (
366: p_api_version => 1.0,
367: p_init_msg_list => FND_API.G_FALSE,
368: p_commit => FND_API.G_FALSE,
369: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
370: x_return_status => l_return_status,
371: x_msg_count => l_msg_count,
372: x_msg_data => l_msg_data,

Line 369: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

365: (
366: p_api_version => 1.0,
367: p_init_msg_list => FND_API.G_FALSE,
368: p_commit => FND_API.G_FALSE,
369: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
370: x_return_status => l_return_status,
371: x_msg_count => l_msg_count,
372: x_msg_data => l_msg_data,
373: p_node_id => p_x_node_rec.relationship_id,

Line 380: p_init_msg_list => FND_API.G_FALSE,

376: ELSE
377: AHL_MC_Node_PVT.Modify_Node
378: (
379: p_api_version => 1.0,
380: p_init_msg_list => FND_API.G_FALSE,
381: p_commit => FND_API.G_FALSE,
382: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
383: x_return_status => l_return_status,
384: x_msg_count => l_msg_count,

Line 381: p_commit => FND_API.G_FALSE,

377: AHL_MC_Node_PVT.Modify_Node
378: (
379: p_api_version => 1.0,
380: p_init_msg_list => FND_API.G_FALSE,
381: p_commit => FND_API.G_FALSE,
382: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
383: x_return_status => l_return_status,
384: x_msg_count => l_msg_count,
385: x_msg_data => l_msg_data,

Line 382: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

378: (
379: p_api_version => 1.0,
380: p_init_msg_list => FND_API.G_FALSE,
381: p_commit => FND_API.G_FALSE,
382: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
383: x_return_status => l_return_status,
384: x_msg_count => l_msg_count,
385: x_msg_data => l_msg_data,
386: p_x_node_rec => p_x_node_rec,

Line 407: IF ( x_msg_count > 0 and l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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;
409: END IF;
410:
411: -- Standard check for p_commit

Line 408: RAISE FND_API.G_EXC_ERROR;

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;
409: END IF;
410:
411: -- Standard check for p_commit
412: IF FND_API.TO_BOOLEAN (p_commit)

Line 412: IF FND_API.TO_BOOLEAN (p_commit)

408: RAISE FND_API.G_EXC_ERROR;
409: END IF;
410:
411: -- Standard check for p_commit
412: IF FND_API.TO_BOOLEAN (p_commit)
413: THEN
414: COMMIT WORK;
415: END IF;
416:

Line 422: p_encoded => FND_API.G_FALSE

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
423: );
424:
425: EXCEPTION
426: WHEN FND_API.G_EXC_ERROR THEN

Line 426: WHEN FND_API.G_EXC_ERROR THEN

422: p_encoded => FND_API.G_FALSE
423: );
424:
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: (

Line 427: x_return_status := FND_API.G_RET_STS_ERROR;

423: );
424:
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,

Line 433: p_encoded => FND_API.G_FALSE

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
434: );
435:
436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

432: p_data => x_msg_data,
433: p_encoded => FND_API.G_FALSE
434: );
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: (

Line 437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

433: p_encoded => FND_API.G_FALSE
434: );
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,

Line 443: p_encoded => FND_API.G_FALSE

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
444: );
445:
446: WHEN OTHERS THEN
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

443: p_encoded => FND_API.G_FALSE
444: );
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

Line 462: p_encoded => FND_API.G_FALSE

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
463: );
464:
465: END Process_Node;
466:

Line 472: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

468:
469: PROCEDURE Delete_Nodes
470: (
471: p_api_version IN NUMBER,
472: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
473: p_commit IN VARCHAR2 := FND_API.G_FALSE,
474: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
475: x_return_status OUT NOCOPY VARCHAR2,
476: x_msg_count OUT NOCOPY NUMBER,

Line 473: p_commit IN VARCHAR2 := FND_API.G_FALSE,

469: PROCEDURE Delete_Nodes
470: (
471: p_api_version IN NUMBER,
472: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
473: p_commit IN VARCHAR2 := FND_API.G_FALSE,
474: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
475: x_return_status OUT NOCOPY VARCHAR2,
476: x_msg_count OUT NOCOPY NUMBER,
477: x_msg_data OUT NOCOPY VARCHAR2,

Line 474: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

470: (
471: p_api_version IN NUMBER,
472: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
473: p_commit IN VARCHAR2 := FND_API.G_FALSE,
474: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
475: x_return_status OUT NOCOPY VARCHAR2,
476: x_msg_count OUT NOCOPY NUMBER,
477: x_msg_data OUT NOCOPY VARCHAR2,
478: p_nodes_tbl IN AHL_MC_Node_PVT.Node_Tbl_Type

Line 495: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

491: -- Standard start of API savepoint
492: SAVEPOINT Delete_Nodes_SP;
493:
494: -- Standard call to check for call compatibility
495: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
496: THEN
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;
499:

Line 497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

493:
494: -- Standard call to check for call compatibility
495: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
496: THEN
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;
499:
500: -- Initialize message list if p_init_msg_list is set to TRUE
501: IF FND_API.TO_BOOLEAN(p_init_msg_list)

Line 501: IF FND_API.TO_BOOLEAN(p_init_msg_list)

497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;
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:

Line 507: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
508:
509: -- API body starts here
510: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
511: THEN

Line 527: p_init_msg_list => FND_API.G_FALSE,

523: LOOP
524: AHL_MC_Node_PVT.Delete_Node
525: (
526: p_api_version => 1.0,
527: p_init_msg_list => FND_API.G_FALSE,
528: p_commit => FND_API.G_FALSE,
529: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
530: x_return_status => l_return_status,
531: x_msg_count => l_msg_count,

Line 528: p_commit => FND_API.G_FALSE,

524: AHL_MC_Node_PVT.Delete_Node
525: (
526: p_api_version => 1.0,
527: p_init_msg_list => FND_API.G_FALSE,
528: p_commit => FND_API.G_FALSE,
529: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
530: x_return_status => l_return_status,
531: x_msg_count => l_msg_count,
532: x_msg_data => l_msg_data,

Line 529: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

525: (
526: p_api_version => 1.0,
527: p_init_msg_list => FND_API.G_FALSE,
528: p_commit => FND_API.G_FALSE,
529: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
530: x_return_status => l_return_status,
531: x_msg_count => l_msg_count,
532: x_msg_data => l_msg_data,
533: p_node_id => p_nodes_tbl(i).relationship_id,

Line 550: RAISE FND_API.G_EXC_ERROR;

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;
553: END IF;
554:

Line 569: RAISE FND_API.G_EXC_ERROR;

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:
572: -- Standard check for p_commit
573: IF FND_API.TO_BOOLEAN (p_commit)

Line 573: IF FND_API.TO_BOOLEAN (p_commit)

569: RAISE FND_API.G_EXC_ERROR;
570: END IF;
571:
572: -- Standard check for p_commit
573: IF FND_API.TO_BOOLEAN (p_commit)
574: THEN
575: COMMIT WORK;
576: END IF;
577:

Line 583: p_encoded => FND_API.G_FALSE

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
584: );
585:
586: EXCEPTION
587: WHEN FND_API.G_EXC_ERROR THEN

Line 587: WHEN FND_API.G_EXC_ERROR THEN

583: p_encoded => FND_API.G_FALSE
584: );
585:
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: (

Line 588: x_return_status := FND_API.G_RET_STS_ERROR;

584: );
585:
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,

Line 594: p_encoded => FND_API.G_FALSE

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
595: );
596:
597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

593: p_data => x_msg_data,
594: p_encoded => FND_API.G_FALSE
595: );
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: (

Line 598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

594: p_encoded => FND_API.G_FALSE
595: );
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,

Line 604: p_encoded => FND_API.G_FALSE

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
605: );
606:
607: WHEN OTHERS THEN
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

604: p_encoded => FND_API.G_FALSE
605: );
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

Line 623: p_encoded => FND_API.G_FALSE

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
624: );
625:
626: END Delete_Nodes;
627: