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

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

95: -- Standard start of API savepoint
96: SAVEPOINT Create_Master_Config_SP;
97:
98: -- Standard call to check for call compatibility
99: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
100: THEN
101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
102: END IF;
103:

Line 101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

97:
98: -- Standard call to check for call compatibility
99: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
100: THEN
101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
102: END IF;
103:
104: -- Initialize message list if p_init_msg_list is set to TRUE
105: IF FND_API.TO_BOOLEAN(p_init_msg_list)

Line 105: IF FND_API.TO_BOOLEAN(p_init_msg_list)

101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
102: END IF;
103:
104: -- Initialize message list if p_init_msg_list is set to TRUE
105: IF FND_API.TO_BOOLEAN(p_init_msg_list)
106: THEN
107: FND_MSG_PUB.Initialize;
108: END IF;
109:

Line 111: x_return_status := FND_API.G_RET_STS_SUCCESS;

107: FND_MSG_PUB.Initialize;
108: END IF;
109:
110: -- Initialize API return status to success
111: x_return_status := FND_API.G_RET_STS_SUCCESS;
112:
113: -- API body starts here
114: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
115: THEN

Line 196: RAISE FND_API.G_EXC_ERROR;

192: -- Check Error Message stack.
193: x_msg_count := FND_MSG_PUB.count_msg;
194: IF x_msg_count > 0
195: THEN
196: RAISE FND_API.G_EXC_ERROR;
197: END IF;
198:
199: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
200: THEN

Line 362: RAISE FND_API.G_EXC_ERROR;

358: -- Check Error Message stack.
359: x_msg_count := FND_MSG_PUB.count_msg;
360: IF x_msg_count > 0
361: THEN
362: RAISE FND_API.G_EXC_ERROR;
363: END IF;
364:
365: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
366: THEN

Line 379: p_init_msg_list => FND_API.G_FALSE,

375: -- 11. Call AHL_MC_NODE_PVT.Create_Node to create MC topnode
376: AHL_MC_Node_PVT.Create_Node
377: (
378: p_api_version => 1.0,
379: p_init_msg_list => FND_API.G_FALSE,
380: p_commit => FND_API.G_FALSE,
381: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
382: x_return_status => l_return_status,
383: x_msg_count => l_msg_count,

Line 380: p_commit => FND_API.G_FALSE,

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

Line 381: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

Line 405: RAISE FND_API.G_EXC_ERROR;

401: -- Check Error Message stack.
402: x_msg_count := FND_MSG_PUB.count_msg;
403: IF x_msg_count > 0
404: THEN
405: RAISE FND_API.G_EXC_ERROR;
406: END IF;
407:
408: -- Standard check for p_commit
409: IF FND_API.TO_BOOLEAN (p_commit)

Line 409: IF FND_API.TO_BOOLEAN (p_commit)

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

Line 419: p_encoded => FND_API.G_FALSE

415: FND_MSG_PUB.count_and_get
416: (
417: p_count => x_msg_count,
418: p_data => x_msg_data,
419: p_encoded => FND_API.G_FALSE
420: );
421:
422: EXCEPTION
423: WHEN FND_API.G_EXC_ERROR THEN

Line 423: WHEN FND_API.G_EXC_ERROR THEN

419: p_encoded => FND_API.G_FALSE
420: );
421:
422: EXCEPTION
423: WHEN FND_API.G_EXC_ERROR THEN
424: x_return_status := FND_API.G_RET_STS_ERROR;
425: Rollback to Create_Master_Config_SP;
426: FND_MSG_PUB.count_and_get
427: (

Line 424: x_return_status := FND_API.G_RET_STS_ERROR;

420: );
421:
422: EXCEPTION
423: WHEN FND_API.G_EXC_ERROR THEN
424: x_return_status := FND_API.G_RET_STS_ERROR;
425: Rollback to Create_Master_Config_SP;
426: FND_MSG_PUB.count_and_get
427: (
428: p_count => x_msg_count,

Line 430: p_encoded => FND_API.G_FALSE

426: FND_MSG_PUB.count_and_get
427: (
428: p_count => x_msg_count,
429: p_data => x_msg_data,
430: p_encoded => FND_API.G_FALSE
431: );
432:
433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

429: p_data => x_msg_data,
430: p_encoded => FND_API.G_FALSE
431: );
432:
433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: Rollback to Create_Master_Config_SP;
436: FND_MSG_PUB.count_and_get
437: (

Line 434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

430: p_encoded => FND_API.G_FALSE
431: );
432:
433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: Rollback to Create_Master_Config_SP;
436: FND_MSG_PUB.count_and_get
437: (
438: p_count => x_msg_count,

Line 440: p_encoded => FND_API.G_FALSE

436: FND_MSG_PUB.count_and_get
437: (
438: p_count => x_msg_count,
439: p_data => x_msg_data,
440: p_encoded => FND_API.G_FALSE
441: );
442:
443: WHEN OTHERS THEN
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

440: p_encoded => FND_API.G_FALSE
441: );
442:
443: WHEN OTHERS THEN
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445: Rollback to Create_Master_Config_SP;
446: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
447: THEN
448: FND_MSG_PUB.add_exc_msg

Line 459: p_encoded => FND_API.G_FALSE

455: FND_MSG_PUB.count_and_get
456: (
457: p_count => x_msg_count,
458: p_data => x_msg_data,
459: p_encoded => FND_API.G_FALSE
460: );
461:
462: END Create_Master_Config;
463:

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

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

Line 496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 500: IF FND_API.TO_BOOLEAN(p_init_msg_list)

496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
497: END IF;
498:
499: -- Initialize message list if p_init_msg_list is set to TRUE
500: IF FND_API.TO_BOOLEAN(p_init_msg_list)
501: THEN
502: FND_MSG_PUB.Initialize;
503: END IF;
504:

Line 506: x_return_status := FND_API.G_RET_STS_SUCCESS;

502: FND_MSG_PUB.Initialize;
503: END IF;
504:
505: -- Initialize API return status to success
506: x_return_status := FND_API.G_RET_STS_SUCCESS;
507:
508: -- API body starts here
509: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
510: THEN

Line 533: RAISE FND_API.G_EXC_ERROR;

529: THEN
530: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_INIT_APPR_COMP');
531: FND_MESSAGE.Set_Token('MC_NAME', p_x_mc_header_rec.name);
532: FND_MSG_PUB.ADD;
533: RAISE FND_API.G_EXC_ERROR;
534: END IF;
535: -- Fix for Bug #3523435
536:
537: IF (l_header_status = 'APPROVAL_REJECTED')

Line 553: RAISE FND_API.G_EXC_ERROR;

549: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
550: false
551: );
552: END IF;
553: RAISE FND_API.G_EXC_ERROR;
554: END IF;
555:
556: -- Confirm name of the MC has not changed, since it is the user-enterable unique name
557: Validate_MC_Name(p_x_mc_header_rec);

Line 572: RAISE FND_API.G_EXC_ERROR;

568: -- Check Error Message stack.
569: x_msg_count := FND_MSG_PUB.count_msg;
570: IF x_msg_count > 0
571: THEN
572: RAISE FND_API.G_EXC_ERROR;
573: END IF;
574:
575: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
576: THEN

Line 651: RAISE FND_API.G_EXC_ERROR;

647: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
648: false
649: );
650: END IF;
651: RAISE FND_API.G_EXC_ERROR;
652: END IF;
653:
654: IF (p_x_node_rec.position_necessity_code <> 'MANDATORY')
655: THEN

Line 720: RAISE FND_API.G_EXC_ERROR;

716: -- Check Error Message stack.
717: x_msg_count := FND_MSG_PUB.count_msg;
718: IF x_msg_count > 0
719: THEN
720: RAISE FND_API.G_EXC_ERROR;
721: END IF;
722:
723: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
724: THEN

Line 741: p_init_msg_list => FND_API.G_FALSE,

737: -- 2g. Call AHL_MC_NODE_PVT.Modify_Node to modify MC topnode
738: AHL_MC_Node_PVT.Modify_Node
739: (
740: p_api_version => 1.0,
741: p_init_msg_list => FND_API.G_FALSE,
742: p_commit => FND_API.G_FALSE,
743: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
744: x_return_status => l_return_status,
745: x_msg_count => l_msg_count,

Line 742: p_commit => FND_API.G_FALSE,

738: AHL_MC_Node_PVT.Modify_Node
739: (
740: p_api_version => 1.0,
741: p_init_msg_list => FND_API.G_FALSE,
742: p_commit => FND_API.G_FALSE,
743: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
744: x_return_status => l_return_status,
745: x_msg_count => l_msg_count,
746: x_msg_data => l_msg_data,

Line 743: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

739: (
740: p_api_version => 1.0,
741: p_init_msg_list => FND_API.G_FALSE,
742: p_commit => FND_API.G_FALSE,
743: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
744: x_return_status => l_return_status,
745: x_msg_count => l_msg_count,
746: x_msg_data => l_msg_data,
747: p_x_node_rec => p_x_node_rec,

Line 768: IF ( x_msg_count > 0 AND l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

764: x_msg_count := FND_MSG_PUB.count_msg;
765:
766: --Priyan
767: --R12 MEL/CDL
768: IF ( x_msg_count > 0 AND l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
769: RAISE FND_API.G_EXC_ERROR;
770: END IF;
771:
772: -- Standard check for p_commit

Line 769: RAISE FND_API.G_EXC_ERROR;

765:
766: --Priyan
767: --R12 MEL/CDL
768: IF ( x_msg_count > 0 AND l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
769: RAISE FND_API.G_EXC_ERROR;
770: END IF;
771:
772: -- Standard check for p_commit
773: IF FND_API.TO_BOOLEAN (p_commit)

Line 773: IF FND_API.TO_BOOLEAN (p_commit)

769: RAISE FND_API.G_EXC_ERROR;
770: END IF;
771:
772: -- Standard check for p_commit
773: IF FND_API.TO_BOOLEAN (p_commit)
774: THEN
775: COMMIT WORK;
776: END IF;
777:

Line 783: p_encoded => FND_API.G_FALSE

779: FND_MSG_PUB.count_and_get
780: (
781: p_count => x_msg_count,
782: p_data => x_msg_data,
783: p_encoded => FND_API.G_FALSE
784: );
785:
786: EXCEPTION
787: WHEN FND_API.G_EXC_ERROR THEN

Line 787: WHEN FND_API.G_EXC_ERROR THEN

783: p_encoded => FND_API.G_FALSE
784: );
785:
786: EXCEPTION
787: WHEN FND_API.G_EXC_ERROR THEN
788: x_return_status := FND_API.G_RET_STS_ERROR;
789: Rollback to Modify_Master_Config_SP;
790: FND_MSG_PUB.count_and_get
791: (

Line 788: x_return_status := FND_API.G_RET_STS_ERROR;

784: );
785:
786: EXCEPTION
787: WHEN FND_API.G_EXC_ERROR THEN
788: x_return_status := FND_API.G_RET_STS_ERROR;
789: Rollback to Modify_Master_Config_SP;
790: FND_MSG_PUB.count_and_get
791: (
792: p_count => x_msg_count,

Line 794: p_encoded => FND_API.G_FALSE

790: FND_MSG_PUB.count_and_get
791: (
792: p_count => x_msg_count,
793: p_data => x_msg_data,
794: p_encoded => FND_API.G_FALSE
795: );
796:
797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

793: p_data => x_msg_data,
794: p_encoded => FND_API.G_FALSE
795: );
796:
797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
799: Rollback to Modify_Master_Config_SP;
800: FND_MSG_PUB.count_and_get
801: (

Line 798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

794: p_encoded => FND_API.G_FALSE
795: );
796:
797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
799: Rollback to Modify_Master_Config_SP;
800: FND_MSG_PUB.count_and_get
801: (
802: p_count => x_msg_count,

Line 804: p_encoded => FND_API.G_FALSE

800: FND_MSG_PUB.count_and_get
801: (
802: p_count => x_msg_count,
803: p_data => x_msg_data,
804: p_encoded => FND_API.G_FALSE
805: );
806:
807: WHEN OTHERS THEN
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

804: p_encoded => FND_API.G_FALSE
805: );
806:
807: WHEN OTHERS THEN
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
809: Rollback to Modify_Master_Config_SP;
810: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
811: THEN
812: FND_MSG_PUB.add_exc_msg

Line 823: p_encoded => FND_API.G_FALSE

819: FND_MSG_PUB.count_and_get
820: (
821: p_count => x_msg_count,
822: p_data => x_msg_data,
823: p_encoded => FND_API.G_FALSE
824: );
825:
826: END Modify_Master_Config;
827:

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

827:
828: PROCEDURE Delete_Master_Config
829: (
830: p_api_version IN NUMBER,
831: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
832: p_commit IN VARCHAR2 := FND_API.G_FALSE,
833: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
834: x_return_status OUT NOCOPY VARCHAR2,
835: x_msg_count OUT NOCOPY NUMBER,

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

828: PROCEDURE Delete_Master_Config
829: (
830: p_api_version IN NUMBER,
831: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
832: p_commit IN VARCHAR2 := FND_API.G_FALSE,
833: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
834: x_return_status OUT NOCOPY VARCHAR2,
835: x_msg_count OUT NOCOPY NUMBER,
836: x_msg_data OUT NOCOPY VARCHAR2,

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

829: (
830: p_api_version IN NUMBER,
831: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
832: p_commit IN VARCHAR2 := FND_API.G_FALSE,
833: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
834: x_return_status OUT NOCOPY VARCHAR2,
835: x_msg_count OUT NOCOPY NUMBER,
836: x_msg_data OUT NOCOPY VARCHAR2,
837: p_mc_header_id IN NUMBER,

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

902: -- Standard start of API savepoint
903: SAVEPOINT Delete_Master_Config_SP;
904:
905: -- Standard call to check for call compatibility
906: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
907: THEN
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END IF;
910:

Line 908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

904:
905: -- Standard call to check for call compatibility
906: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
907: THEN
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END IF;
910:
911: -- Initialize message list if p_init_msg_list is set to TRUE
912: IF FND_API.TO_BOOLEAN(p_init_msg_list)

Line 912: IF FND_API.TO_BOOLEAN(p_init_msg_list)

908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END IF;
910:
911: -- Initialize message list if p_init_msg_list is set to TRUE
912: IF FND_API.TO_BOOLEAN(p_init_msg_list)
913: THEN
914: FND_MSG_PUB.Initialize;
915: END IF;
916:

Line 918: x_return_status := FND_API.G_RET_STS_SUCCESS;

914: FND_MSG_PUB.Initialize;
915: END IF;
916:
917: -- Initialize API return status to success
918: x_return_status := FND_API.G_RET_STS_SUCCESS;
919:
920: -- API body starts here
921: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
922: THEN

Line 951: RAISE FND_API.G_EXC_ERROR;

947: false
948: );
949: END IF;
950: CLOSE check_mc_not_subconfig;
951: RAISE FND_API.G_EXC_ERROR;
952: END IF;
953: CLOSE check_mc_not_subconfig;
954:
955: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 988: p_init_msg_list => FND_API.G_FALSE,

984: -- 6a. Call AHL_MC_RULE_PVT.Delete_Rules_For_MC to delete all the rules associated with this MC
985: AHL_MC_RULE_PVT.Delete_Rules_For_MC
986: (
987: p_api_version => 1.0,
988: p_init_msg_list => FND_API.G_FALSE,
989: p_commit => FND_API.G_FALSE,
990: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
991: x_return_status => l_return_status,
992: x_msg_count => l_msg_count,

Line 989: p_commit => FND_API.G_FALSE,

985: AHL_MC_RULE_PVT.Delete_Rules_For_MC
986: (
987: p_api_version => 1.0,
988: p_init_msg_list => FND_API.G_FALSE,
989: p_commit => FND_API.G_FALSE,
990: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
991: x_return_status => l_return_status,
992: x_msg_count => l_msg_count,
993: x_msg_data => l_msg_data,

Line 990: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

986: (
987: p_api_version => 1.0,
988: p_init_msg_list => FND_API.G_FALSE,
989: p_commit => FND_API.G_FALSE,
990: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
991: x_return_status => l_return_status,
992: x_msg_count => l_msg_count,
993: x_msg_data => l_msg_data,
994: p_mc_header_id => p_mc_header_id

Line 1000: RAISE FND_API.G_EXC_ERROR;

996:
997: -- Check Error Message stack.
998: x_msg_count := FND_MSG_PUB.count_msg;
999: IF x_msg_count > 0 THEN
1000: RAISE FND_API.G_EXC_ERROR;
1001: END IF;
1002:
1003: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1004: THEN

Line 1017: p_init_msg_list => FND_API.G_FALSE,

1013: -- 6b. Call AHL_MC_PATH_POSITION_PVT.Delete_Positions_For_MC to delete all the position path records for this MC
1014: AHL_MC_PATH_POSITION_PVT.Delete_Positions_For_MC
1015: (
1016: p_api_version => 1.0,
1017: p_init_msg_list => FND_API.G_FALSE,
1018: p_commit => FND_API.G_FALSE,
1019: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1020: x_return_status => l_return_status,
1021: x_msg_count => l_msg_count,

Line 1018: p_commit => FND_API.G_FALSE,

1014: AHL_MC_PATH_POSITION_PVT.Delete_Positions_For_MC
1015: (
1016: p_api_version => 1.0,
1017: p_init_msg_list => FND_API.G_FALSE,
1018: p_commit => FND_API.G_FALSE,
1019: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1020: x_return_status => l_return_status,
1021: x_msg_count => l_msg_count,
1022: x_msg_data => l_msg_data,

Line 1019: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1015: (
1016: p_api_version => 1.0,
1017: p_init_msg_list => FND_API.G_FALSE,
1018: p_commit => FND_API.G_FALSE,
1019: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1020: x_return_status => l_return_status,
1021: x_msg_count => l_msg_count,
1022: x_msg_data => l_msg_data,
1023: p_mc_header_id => p_mc_header_id

Line 1029: RAISE FND_API.G_EXC_ERROR;

1025:
1026: -- Check Error Message stack.
1027: x_msg_count := FND_MSG_PUB.count_msg;
1028: IF x_msg_count > 0 THEN
1029: RAISE FND_API.G_EXC_ERROR;
1030: END IF;
1031:
1032: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1033: THEN

Line 1051: p_init_msg_list => FND_API.G_FALSE,

1047: -- 6c. Call AHL_MC_NODE_PVT.Delete_Node to delete the MC tree starting from the topnode
1048: AHL_MC_NODE_PVT.Delete_Node
1049: (
1050: p_api_version => 1.0,
1051: p_init_msg_list => FND_API.G_FALSE,
1052: p_commit => FND_API.G_FALSE,
1053: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1054: x_return_status => l_return_status,
1055: x_msg_count => l_msg_count,

Line 1052: p_commit => FND_API.G_FALSE,

1048: AHL_MC_NODE_PVT.Delete_Node
1049: (
1050: p_api_version => 1.0,
1051: p_init_msg_list => FND_API.G_FALSE,
1052: p_commit => FND_API.G_FALSE,
1053: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1054: x_return_status => l_return_status,
1055: x_msg_count => l_msg_count,
1056: x_msg_data => l_msg_data,

Line 1053: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1049: (
1050: p_api_version => 1.0,
1051: p_init_msg_list => FND_API.G_FALSE,
1052: p_commit => FND_API.G_FALSE,
1053: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1054: x_return_status => l_return_status,
1055: x_msg_count => l_msg_count,
1056: x_msg_data => l_msg_data,
1057: p_node_id => l_topnode_rel_id,

Line 1064: RAISE FND_API.G_EXC_ERROR;

1060:
1061: -- Check Error Message stack.
1062: x_msg_count := FND_MSG_PUB.count_msg;
1063: IF x_msg_count > 0 THEN
1064: RAISE FND_API.G_EXC_ERROR;
1065: END IF;
1066:
1067: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1068: THEN

Line 1111: RAISE FND_API.G_EXC_ERROR;

1107: false
1108: );
1109: END IF;
1110: CLOSE check_unit_assigned;
1111: RAISE FND_API.G_EXC_ERROR;
1112: END IF;
1113: CLOSE check_unit_assigned;
1114:
1115: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 1191: RAISE FND_API.G_EXC_ERROR;

1187:
1188: -- Check Error Message stack.
1189: x_msg_count := FND_MSG_PUB.count_msg;
1190: IF x_msg_count > 0 THEN
1191: RAISE FND_API.G_EXC_ERROR;
1192: END IF;
1193:
1194: -- Standard check for p_commit
1195: IF FND_API.TO_BOOLEAN (p_commit)

Line 1195: IF FND_API.TO_BOOLEAN (p_commit)

1191: RAISE FND_API.G_EXC_ERROR;
1192: END IF;
1193:
1194: -- Standard check for p_commit
1195: IF FND_API.TO_BOOLEAN (p_commit)
1196: THEN
1197: COMMIT WORK;
1198: END IF;
1199:

Line 1205: p_encoded => FND_API.G_FALSE

1201: FND_MSG_PUB.count_and_get
1202: (
1203: p_count => x_msg_count,
1204: p_data => x_msg_data,
1205: p_encoded => FND_API.G_FALSE
1206: );
1207:
1208: EXCEPTION
1209: WHEN FND_API.G_EXC_ERROR THEN

Line 1209: WHEN FND_API.G_EXC_ERROR THEN

1205: p_encoded => FND_API.G_FALSE
1206: );
1207:
1208: EXCEPTION
1209: WHEN FND_API.G_EXC_ERROR THEN
1210: x_return_status := FND_API.G_RET_STS_ERROR;
1211: Rollback to Delete_Master_Config_SP;
1212: FND_MSG_PUB.count_and_get
1213: (

Line 1210: x_return_status := FND_API.G_RET_STS_ERROR;

1206: );
1207:
1208: EXCEPTION
1209: WHEN FND_API.G_EXC_ERROR THEN
1210: x_return_status := FND_API.G_RET_STS_ERROR;
1211: Rollback to Delete_Master_Config_SP;
1212: FND_MSG_PUB.count_and_get
1213: (
1214: p_count => x_msg_count,

Line 1216: p_encoded => FND_API.G_FALSE

1212: FND_MSG_PUB.count_and_get
1213: (
1214: p_count => x_msg_count,
1215: p_data => x_msg_data,
1216: p_encoded => FND_API.G_FALSE
1217: );
1218:
1219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1215: p_data => x_msg_data,
1216: p_encoded => FND_API.G_FALSE
1217: );
1218:
1219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1221: Rollback to Delete_Master_Config_SP;
1222: FND_MSG_PUB.count_and_get
1223: (

Line 1220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1216: p_encoded => FND_API.G_FALSE
1217: );
1218:
1219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1221: Rollback to Delete_Master_Config_SP;
1222: FND_MSG_PUB.count_and_get
1223: (
1224: p_count => x_msg_count,

Line 1226: p_encoded => FND_API.G_FALSE

1222: FND_MSG_PUB.count_and_get
1223: (
1224: p_count => x_msg_count,
1225: p_data => x_msg_data,
1226: p_encoded => FND_API.G_FALSE
1227: );
1228:
1229: WHEN OTHERS THEN
1230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1226: p_encoded => FND_API.G_FALSE
1227: );
1228:
1229: WHEN OTHERS THEN
1230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1231: Rollback to Delete_Master_Config_SP;
1232: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1233: THEN
1234: FND_MSG_PUB.add_exc_msg

Line 1245: p_encoded => FND_API.G_FALSE

1241: FND_MSG_PUB.count_and_get
1242: (
1243: p_count => x_msg_count,
1244: p_data => x_msg_data,
1245: p_encoded => FND_API.G_FALSE
1246: );
1247:
1248: END Delete_Master_Config;
1249:

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

1249:
1250: PROCEDURE Copy_Master_Config
1251: (
1252: p_api_version IN NUMBER,
1253: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1254: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1255: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1256: x_return_status OUT NOCOPY VARCHAR2,
1257: x_msg_count OUT NOCOPY NUMBER,

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

1250: PROCEDURE Copy_Master_Config
1251: (
1252: p_api_version IN NUMBER,
1253: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1254: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1255: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1256: x_return_status OUT NOCOPY VARCHAR2,
1257: x_msg_count OUT NOCOPY NUMBER,
1258: x_msg_data OUT NOCOPY VARCHAR2,

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

1251: (
1252: p_api_version IN NUMBER,
1253: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1254: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1255: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1256: x_return_status OUT NOCOPY VARCHAR2,
1257: x_msg_count OUT NOCOPY NUMBER,
1258: x_msg_data OUT NOCOPY VARCHAR2,
1259: p_x_mc_header_rec IN OUT NOCOPY Header_Rec_Type,

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

1276: -- Standard start of API savepoint
1277: SAVEPOINT Copy_Master_Config_SP;
1278:
1279: -- Standard call to check for call compatibility
1280: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1281: THEN
1282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1283: END IF;
1284:

Line 1282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1278:
1279: -- Standard call to check for call compatibility
1280: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1281: THEN
1282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1283: END IF;
1284:
1285: -- Initialize message list if p_init_msg_list is set to TRUE
1286: IF FND_API.TO_BOOLEAN(p_init_msg_list)

Line 1286: IF FND_API.TO_BOOLEAN(p_init_msg_list)

1282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1283: END IF;
1284:
1285: -- Initialize message list if p_init_msg_list is set to TRUE
1286: IF FND_API.TO_BOOLEAN(p_init_msg_list)
1287: THEN
1288: FND_MSG_PUB.Initialize;
1289: END IF;
1290:

Line 1292: x_return_status := FND_API.G_RET_STS_SUCCESS;

1288: FND_MSG_PUB.Initialize;
1289: END IF;
1290:
1291: -- Initialize API return status to success
1292: x_return_status := FND_API.G_RET_STS_SUCCESS;
1293:
1294: -- API body starts here
1295: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1296: THEN

Line 1336: p_init_msg_list => FND_API.G_FALSE,

1332: -- 7. Call AHL_MC_MasterConfig_PVT.Create_Master_Config
1333: AHL_MC_MasterConfig_PVT.Create_Master_Config
1334: (
1335: p_api_version => 1.0,
1336: p_init_msg_list => FND_API.G_FALSE,
1337: p_commit => FND_API.G_FALSE,
1338: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1339: x_return_status => l_return_status,
1340: x_msg_count => l_msg_count,

Line 1337: p_commit => FND_API.G_FALSE,

1333: AHL_MC_MasterConfig_PVT.Create_Master_Config
1334: (
1335: p_api_version => 1.0,
1336: p_init_msg_list => FND_API.G_FALSE,
1337: p_commit => FND_API.G_FALSE,
1338: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1339: x_return_status => l_return_status,
1340: x_msg_count => l_msg_count,
1341: x_msg_data => l_msg_data,

Line 1338: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1334: (
1335: p_api_version => 1.0,
1336: p_init_msg_list => FND_API.G_FALSE,
1337: p_commit => FND_API.G_FALSE,
1338: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1339: x_return_status => l_return_status,
1340: x_msg_count => l_msg_count,
1341: x_msg_data => l_msg_data,
1342: p_x_mc_header_rec => p_x_mc_header_rec,

Line 1349: RAISE FND_API.G_EXC_ERROR;

1345:
1346: -- Check Error Message stack.
1347: x_msg_count := FND_MSG_PUB.count_msg;
1348: IF x_msg_count > 0 THEN
1349: RAISE FND_API.G_EXC_ERROR;
1350: END IF;
1351:
1352: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1353: THEN

Line 1373: p_commit => FND_API.G_FALSE,

1369: -- 8. Copy all documents associated with the topnode
1370: AHL_DI_ASSO_DOC_GEN_PVT.COPY_ASSOCIATION
1371: (
1372: p_api_version => 1.0,
1373: p_commit => FND_API.G_FALSE,
1374: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1375: p_from_object_id => l_old_node_id,
1376: p_from_object_type => 'MC',
1377: p_to_object_id => p_x_node_rec.relationship_id,

Line 1374: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1370: AHL_DI_ASSO_DOC_GEN_PVT.COPY_ASSOCIATION
1371: (
1372: p_api_version => 1.0,
1373: p_commit => FND_API.G_FALSE,
1374: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1375: p_from_object_id => l_old_node_id,
1376: p_from_object_type => 'MC',
1377: p_to_object_id => p_x_node_rec.relationship_id,
1378: p_to_object_type => 'MC',

Line 1387: RAISE FND_API.G_EXC_ERROR;

1383:
1384: -- Check Error Message stack.
1385: x_msg_count := FND_MSG_PUB.count_msg;
1386: IF x_msg_count > 0 THEN
1387: RAISE FND_API.G_EXC_ERROR;
1388: END IF;
1389:
1390: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1391: THEN

Line 1404: p_init_msg_list => FND_API.G_FALSE,

1400: -- 9. Copy all other child nodes to the topnode of the source MC
1401: AHL_MC_Node_PVT.Copy_MC_Nodes
1402: (
1403: p_api_version => 1.0,
1404: p_init_msg_list => FND_API.G_FALSE,
1405: p_commit => FND_API.G_FALSE,
1406: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1407: x_return_status => l_return_status,
1408: x_msg_count => l_msg_count,

Line 1405: p_commit => FND_API.G_FALSE,

1401: AHL_MC_Node_PVT.Copy_MC_Nodes
1402: (
1403: p_api_version => 1.0,
1404: p_init_msg_list => FND_API.G_FALSE,
1405: p_commit => FND_API.G_FALSE,
1406: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1407: x_return_status => l_return_status,
1408: x_msg_count => l_msg_count,
1409: x_msg_data => l_msg_data,

Line 1406: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1402: (
1403: p_api_version => 1.0,
1404: p_init_msg_list => FND_API.G_FALSE,
1405: p_commit => FND_API.G_FALSE,
1406: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1407: x_return_status => l_return_status,
1408: x_msg_count => l_msg_count,
1409: x_msg_data => l_msg_data,
1410: p_source_rel_id => l_old_node_id,

Line 1419: RAISE FND_API.G_EXC_ERROR;

1415:
1416: -- Check Error Message stack.
1417: x_msg_count := FND_MSG_PUB.count_msg;
1418: IF x_msg_count > 0 THEN
1419: RAISE FND_API.G_EXC_ERROR;
1420: END IF;
1421:
1422: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1423: THEN

Line 1436: p_init_msg_list => FND_API.G_FALSE,

1432: -- 10. Copy position paths from the old MC to the new MC
1433: AHL_MC_PATH_POSITION_PVT.Copy_Positions_For_MC
1434: (
1435: p_api_version => 1.0,
1436: p_init_msg_list => FND_API.G_FALSE,
1437: p_commit => FND_API.G_FALSE,
1438: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1439: x_return_status => l_return_status,
1440: x_msg_count => l_msg_count,

Line 1437: p_commit => FND_API.G_FALSE,

1433: AHL_MC_PATH_POSITION_PVT.Copy_Positions_For_MC
1434: (
1435: p_api_version => 1.0,
1436: p_init_msg_list => FND_API.G_FALSE,
1437: p_commit => FND_API.G_FALSE,
1438: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1439: x_return_status => l_return_status,
1440: x_msg_count => l_msg_count,
1441: x_msg_data => l_msg_data,

Line 1438: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1434: (
1435: p_api_version => 1.0,
1436: p_init_msg_list => FND_API.G_FALSE,
1437: p_commit => FND_API.G_FALSE,
1438: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1439: x_return_status => l_return_status,
1440: x_msg_count => l_msg_count,
1441: x_msg_data => l_msg_data,
1442: p_from_mc_header_id => l_old_mc_header_id,

Line 1449: RAISE FND_API.G_EXC_ERROR;

1445:
1446: -- Check Error Message stack.
1447: x_msg_count := FND_MSG_PUB.count_msg;
1448: IF x_msg_count > 0 THEN
1449: RAISE FND_API.G_EXC_ERROR;
1450: END IF;
1451:
1452: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1453: THEN

Line 1466: p_init_msg_list => FND_API.G_FALSE,

1462: -- 11. Copy rules from the old MC to the new MC
1463: AHL_MC_RULE_PVT.Copy_Rules_For_MC
1464: (
1465: p_api_version => 1.0,
1466: p_init_msg_list => FND_API.G_FALSE,
1467: p_commit => FND_API.G_FALSE,
1468: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1469: x_return_status => l_return_status,
1470: x_msg_count => l_msg_count,

Line 1467: p_commit => FND_API.G_FALSE,

1463: AHL_MC_RULE_PVT.Copy_Rules_For_MC
1464: (
1465: p_api_version => 1.0,
1466: p_init_msg_list => FND_API.G_FALSE,
1467: p_commit => FND_API.G_FALSE,
1468: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1469: x_return_status => l_return_status,
1470: x_msg_count => l_msg_count,
1471: x_msg_data => l_msg_data,

Line 1468: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1464: (
1465: p_api_version => 1.0,
1466: p_init_msg_list => FND_API.G_FALSE,
1467: p_commit => FND_API.G_FALSE,
1468: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1469: x_return_status => l_return_status,
1470: x_msg_count => l_msg_count,
1471: x_msg_data => l_msg_data,
1472: p_from_mc_header_id => l_old_mc_header_id,

Line 1479: RAISE FND_API.G_EXC_ERROR;

1475:
1476: -- Check Error Message stack.
1477: x_msg_count := FND_MSG_PUB.count_msg;
1478: IF x_msg_count > 0 THEN
1479: RAISE FND_API.G_EXC_ERROR;
1480: END IF;
1481:
1482: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1483: THEN

Line 1496: RAISE FND_API.G_EXC_ERROR;

1492:
1493: -- Check Error Message stack.
1494: x_msg_count := FND_MSG_PUB.count_msg;
1495: IF x_msg_count > 0 THEN
1496: RAISE FND_API.G_EXC_ERROR;
1497: END IF;
1498:
1499: -- Standard check for p_commit
1500: IF FND_API.TO_BOOLEAN (p_commit)

Line 1500: IF FND_API.TO_BOOLEAN (p_commit)

1496: RAISE FND_API.G_EXC_ERROR;
1497: END IF;
1498:
1499: -- Standard check for p_commit
1500: IF FND_API.TO_BOOLEAN (p_commit)
1501: THEN
1502: COMMIT WORK;
1503: END IF;
1504:

Line 1510: p_encoded => FND_API.G_FALSE

1506: FND_MSG_PUB.count_and_get
1507: (
1508: p_count => x_msg_count,
1509: p_data => x_msg_data,
1510: p_encoded => FND_API.G_FALSE
1511: );
1512:
1513: EXCEPTION
1514: WHEN FND_API.G_EXC_ERROR THEN

Line 1514: WHEN FND_API.G_EXC_ERROR THEN

1510: p_encoded => FND_API.G_FALSE
1511: );
1512:
1513: EXCEPTION
1514: WHEN FND_API.G_EXC_ERROR THEN
1515: x_return_status := FND_API.G_RET_STS_ERROR;
1516: Rollback to Copy_Master_Config_SP;
1517: FND_MSG_PUB.count_and_get
1518: (

Line 1515: x_return_status := FND_API.G_RET_STS_ERROR;

1511: );
1512:
1513: EXCEPTION
1514: WHEN FND_API.G_EXC_ERROR THEN
1515: x_return_status := FND_API.G_RET_STS_ERROR;
1516: Rollback to Copy_Master_Config_SP;
1517: FND_MSG_PUB.count_and_get
1518: (
1519: p_count => x_msg_count,

Line 1521: p_encoded => FND_API.G_FALSE

1517: FND_MSG_PUB.count_and_get
1518: (
1519: p_count => x_msg_count,
1520: p_data => x_msg_data,
1521: p_encoded => FND_API.G_FALSE
1522: );
1523:
1524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1520: p_data => x_msg_data,
1521: p_encoded => FND_API.G_FALSE
1522: );
1523:
1524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1526: Rollback to Copy_Master_Config_SP;
1527: FND_MSG_PUB.count_and_get
1528: (

Line 1525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1521: p_encoded => FND_API.G_FALSE
1522: );
1523:
1524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1526: Rollback to Copy_Master_Config_SP;
1527: FND_MSG_PUB.count_and_get
1528: (
1529: p_count => x_msg_count,

Line 1531: p_encoded => FND_API.G_FALSE

1527: FND_MSG_PUB.count_and_get
1528: (
1529: p_count => x_msg_count,
1530: p_data => x_msg_data,
1531: p_encoded => FND_API.G_FALSE
1532: );
1533:
1534: WHEN OTHERS THEN
1535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1531: p_encoded => FND_API.G_FALSE
1532: );
1533:
1534: WHEN OTHERS THEN
1535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1536: Rollback to Copy_Master_Config_SP;
1537: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1538: THEN
1539: FND_MSG_PUB.add_exc_msg

Line 1550: p_encoded => FND_API.G_FALSE

1546: FND_MSG_PUB.count_and_get
1547: (
1548: p_count => x_msg_count,
1549: p_data => x_msg_data,
1550: p_encoded => FND_API.G_FALSE
1551: );
1552:
1553: END Copy_Master_Config;
1554:

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

1554:
1555: PROCEDURE Create_MC_Revision
1556: (
1557: p_api_version IN NUMBER,
1558: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1559: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1560: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1561: x_return_status OUT NOCOPY VARCHAR2,
1562: x_msg_count OUT NOCOPY NUMBER,

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

1555: PROCEDURE Create_MC_Revision
1556: (
1557: p_api_version IN NUMBER,
1558: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1559: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1560: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1561: x_return_status OUT NOCOPY VARCHAR2,
1562: x_msg_count OUT NOCOPY NUMBER,
1563: x_msg_data OUT NOCOPY VARCHAR2,

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

1556: (
1557: p_api_version IN NUMBER,
1558: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1559: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1560: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1561: x_return_status OUT NOCOPY VARCHAR2,
1562: x_msg_count OUT NOCOPY NUMBER,
1563: x_msg_data OUT NOCOPY VARCHAR2,
1564: p_x_mc_header_id IN OUT NOCOPY NUMBER,

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

1674: -- Standard start of API savepoint
1675: SAVEPOINT Create_MC_Revision_SP;
1676:
1677: -- Standard call to check for call compatibility
1678: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1679: THEN
1680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1681: END IF;
1682:

Line 1680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1676:
1677: -- Standard call to check for call compatibility
1678: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1679: THEN
1680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1681: END IF;
1682:
1683: -- Initialize message list if p_init_msg_list is set to TRUE
1684: IF FND_API.TO_BOOLEAN(p_init_msg_list)

Line 1684: IF FND_API.TO_BOOLEAN(p_init_msg_list)

1680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1681: END IF;
1682:
1683: -- Initialize message list if p_init_msg_list is set to TRUE
1684: IF FND_API.TO_BOOLEAN(p_init_msg_list)
1685: THEN
1686: FND_MSG_PUB.Initialize;
1687: END IF;
1688:

Line 1690: x_return_status := FND_API.G_RET_STS_SUCCESS;

1686: FND_MSG_PUB.Initialize;
1687: END IF;
1688:
1689: -- Initialize API return status to success
1690: x_return_status := FND_API.G_RET_STS_SUCCESS;
1691:
1692: -- API body starts here
1693: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1694: THEN

Line 1748: RAISE FND_API.G_EXC_ERROR;

1744:
1745: -- Check Error Message stack.
1746: x_msg_count := FND_MSG_PUB.count_msg;
1747: IF x_msg_count > 0 THEN
1748: RAISE FND_API.G_EXC_ERROR;
1749: END IF;
1750:
1751: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1752: THEN

Line 1840: p_init_msg_list => FND_API.G_FALSE,

1836: -- 14. Call AHL_MC_MasterConfig_PVT.Create_Master_Config
1837: AHL_MC_MasterConfig_PVT.Create_Master_Config
1838: (
1839: p_api_version => 1.0,
1840: p_init_msg_list => FND_API.G_FALSE,
1841: p_commit => FND_API.G_FALSE,
1842: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1843: x_return_status => l_return_status,
1844: x_msg_count => l_msg_count,

Line 1841: p_commit => FND_API.G_FALSE,

1837: AHL_MC_MasterConfig_PVT.Create_Master_Config
1838: (
1839: p_api_version => 1.0,
1840: p_init_msg_list => FND_API.G_FALSE,
1841: p_commit => FND_API.G_FALSE,
1842: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1843: x_return_status => l_return_status,
1844: x_msg_count => l_msg_count,
1845: x_msg_data => l_msg_data,

Line 1842: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1838: (
1839: p_api_version => 1.0,
1840: p_init_msg_list => FND_API.G_FALSE,
1841: p_commit => FND_API.G_FALSE,
1842: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1843: x_return_status => l_return_status,
1844: x_msg_count => l_msg_count,
1845: x_msg_data => l_msg_data,
1846: p_x_mc_header_rec => l_mc_header_rec,

Line 1853: RAISE FND_API.G_EXC_ERROR;

1849:
1850: -- Check Error Message stack.
1851: x_msg_count := FND_MSG_PUB.count_msg;
1852: IF x_msg_count > 0 THEN
1853: RAISE FND_API.G_EXC_ERROR;
1854: END IF;
1855:
1856: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1857: THEN

Line 1883: p_commit => FND_API.G_FALSE,

1879: -- 16. Copy all documents associated with the topnode
1880: AHL_DI_ASSO_DOC_GEN_PVT.COPY_ASSOCIATION
1881: (
1882: p_api_version => 1.0,
1883: p_commit => FND_API.G_FALSE,
1884: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1885: p_from_object_id => l_old_node_id,
1886: p_from_object_type => 'MC',
1887: p_to_object_id => l_node_rec.relationship_id,

Line 1884: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1880: AHL_DI_ASSO_DOC_GEN_PVT.COPY_ASSOCIATION
1881: (
1882: p_api_version => 1.0,
1883: p_commit => FND_API.G_FALSE,
1884: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1885: p_from_object_id => l_old_node_id,
1886: p_from_object_type => 'MC',
1887: p_to_object_id => l_node_rec.relationship_id,
1888: p_to_object_type => 'MC',

Line 1897: RAISE FND_API.G_EXC_ERROR;

1893:
1894: -- Check Error Message stack.
1895: x_msg_count := FND_MSG_PUB.count_msg;
1896: IF x_msg_count > 0 THEN
1897: RAISE FND_API.G_EXC_ERROR;
1898: END IF;
1899:
1900: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1901: THEN

Line 1914: p_init_msg_list => FND_API.G_FALSE,

1910: -- 17. Copy all other child nodes to the topnode of the source MC
1911: AHL_MC_Node_PVT.Copy_MC_Nodes
1912: (
1913: p_api_version => 1.0,
1914: p_init_msg_list => FND_API.G_FALSE,
1915: p_commit => FND_API.G_FALSE,
1916: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1917: x_return_status => l_return_status,
1918: x_msg_count => l_msg_count,

Line 1915: p_commit => FND_API.G_FALSE,

1911: AHL_MC_Node_PVT.Copy_MC_Nodes
1912: (
1913: p_api_version => 1.0,
1914: p_init_msg_list => FND_API.G_FALSE,
1915: p_commit => FND_API.G_FALSE,
1916: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1917: x_return_status => l_return_status,
1918: x_msg_count => l_msg_count,
1919: x_msg_data => l_msg_data,

Line 1916: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1912: (
1913: p_api_version => 1.0,
1914: p_init_msg_list => FND_API.G_FALSE,
1915: p_commit => FND_API.G_FALSE,
1916: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1917: x_return_status => l_return_status,
1918: x_msg_count => l_msg_count,
1919: x_msg_data => l_msg_data,
1920: p_source_rel_id => l_old_node_id,

Line 1929: RAISE FND_API.G_EXC_ERROR;

1925:
1926: -- Check Error Message stack.
1927: x_msg_count := FND_MSG_PUB.count_msg;
1928: IF x_msg_count > 0 THEN
1929: RAISE FND_API.G_EXC_ERROR;
1930: END IF;
1931:
1932: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1933: THEN

Line 1946: p_init_msg_list => FND_API.G_FALSE,

1942: -- 18. Copy position paths from the old MC to the new MC
1943: AHL_MC_PATH_POSITION_PVT.Copy_Positions_For_MC
1944: (
1945: p_api_version => 1.0,
1946: p_init_msg_list => FND_API.G_FALSE,
1947: p_commit => FND_API.G_FALSE,
1948: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1949: x_return_status => l_return_status,
1950: x_msg_count => l_msg_count,

Line 1947: p_commit => FND_API.G_FALSE,

1943: AHL_MC_PATH_POSITION_PVT.Copy_Positions_For_MC
1944: (
1945: p_api_version => 1.0,
1946: p_init_msg_list => FND_API.G_FALSE,
1947: p_commit => FND_API.G_FALSE,
1948: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1949: x_return_status => l_return_status,
1950: x_msg_count => l_msg_count,
1951: x_msg_data => l_msg_data,

Line 1948: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1944: (
1945: p_api_version => 1.0,
1946: p_init_msg_list => FND_API.G_FALSE,
1947: p_commit => FND_API.G_FALSE,
1948: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1949: x_return_status => l_return_status,
1950: x_msg_count => l_msg_count,
1951: x_msg_data => l_msg_data,
1952: p_from_mc_header_id => l_old_mc_header_id,

Line 1959: RAISE FND_API.G_EXC_ERROR;

1955:
1956: -- Check Error Message stack.
1957: x_msg_count := FND_MSG_PUB.count_msg;
1958: IF x_msg_count > 0 THEN
1959: RAISE FND_API.G_EXC_ERROR;
1960: END IF;
1961:
1962: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1963: THEN

Line 1976: p_init_msg_list => FND_API.G_FALSE,

1972: -- 12. Copy rules from the old MC to the new MC
1973: AHL_MC_RULE_PVT.Copy_Rules_For_MC
1974: (
1975: p_api_version => 1.0,
1976: p_init_msg_list => FND_API.G_FALSE,
1977: p_commit => FND_API.G_FALSE,
1978: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1979: x_return_status => l_return_status,
1980: x_msg_count => l_msg_count,

Line 1977: p_commit => FND_API.G_FALSE,

1973: AHL_MC_RULE_PVT.Copy_Rules_For_MC
1974: (
1975: p_api_version => 1.0,
1976: p_init_msg_list => FND_API.G_FALSE,
1977: p_commit => FND_API.G_FALSE,
1978: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1979: x_return_status => l_return_status,
1980: x_msg_count => l_msg_count,
1981: x_msg_data => l_msg_data,

Line 1978: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1974: (
1975: p_api_version => 1.0,
1976: p_init_msg_list => FND_API.G_FALSE,
1977: p_commit => FND_API.G_FALSE,
1978: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1979: x_return_status => l_return_status,
1980: x_msg_count => l_msg_count,
1981: x_msg_data => l_msg_data,
1982: p_from_mc_header_id => l_old_mc_header_id,

Line 1989: RAISE FND_API.G_EXC_ERROR;

1985:
1986: -- Check Error Message stack.
1987: x_msg_count := FND_MSG_PUB.count_msg;
1988: IF x_msg_count > 0 THEN
1989: RAISE FND_API.G_EXC_ERROR;
1990: END IF;
1991:
1992: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1993: THEN

Line 2006: RAISE FND_API.G_EXC_ERROR;

2002:
2003: -- Check Error Message stack.
2004: x_msg_count := FND_MSG_PUB.count_msg;
2005: IF x_msg_count > 0 THEN
2006: RAISE FND_API.G_EXC_ERROR;
2007: END IF;
2008:
2009: -- Standard check for p_commit
2010: IF FND_API.TO_BOOLEAN (p_commit)

Line 2010: IF FND_API.TO_BOOLEAN (p_commit)

2006: RAISE FND_API.G_EXC_ERROR;
2007: END IF;
2008:
2009: -- Standard check for p_commit
2010: IF FND_API.TO_BOOLEAN (p_commit)
2011: THEN
2012: COMMIT WORK;
2013: END IF;
2014:

Line 2020: p_encoded => FND_API.G_FALSE

2016: FND_MSG_PUB.count_and_get
2017: (
2018: p_count => x_msg_count,
2019: p_data => x_msg_data,
2020: p_encoded => FND_API.G_FALSE
2021: );
2022:
2023: EXCEPTION
2024: WHEN FND_API.G_EXC_ERROR THEN

Line 2024: WHEN FND_API.G_EXC_ERROR THEN

2020: p_encoded => FND_API.G_FALSE
2021: );
2022:
2023: EXCEPTION
2024: WHEN FND_API.G_EXC_ERROR THEN
2025: x_return_status := FND_API.G_RET_STS_ERROR;
2026: Rollback to Create_MC_Revision_SP;
2027: FND_MSG_PUB.count_and_get
2028: (

Line 2025: x_return_status := FND_API.G_RET_STS_ERROR;

2021: );
2022:
2023: EXCEPTION
2024: WHEN FND_API.G_EXC_ERROR THEN
2025: x_return_status := FND_API.G_RET_STS_ERROR;
2026: Rollback to Create_MC_Revision_SP;
2027: FND_MSG_PUB.count_and_get
2028: (
2029: p_count => x_msg_count,

Line 2031: p_encoded => FND_API.G_FALSE

2027: FND_MSG_PUB.count_and_get
2028: (
2029: p_count => x_msg_count,
2030: p_data => x_msg_data,
2031: p_encoded => FND_API.G_FALSE
2032: );
2033:
2034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2030: p_data => x_msg_data,
2031: p_encoded => FND_API.G_FALSE
2032: );
2033:
2034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2036: Rollback to Create_MC_Revision_SP;
2037: FND_MSG_PUB.count_and_get
2038: (

Line 2035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2031: p_encoded => FND_API.G_FALSE
2032: );
2033:
2034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2036: Rollback to Create_MC_Revision_SP;
2037: FND_MSG_PUB.count_and_get
2038: (
2039: p_count => x_msg_count,

Line 2041: p_encoded => FND_API.G_FALSE

2037: FND_MSG_PUB.count_and_get
2038: (
2039: p_count => x_msg_count,
2040: p_data => x_msg_data,
2041: p_encoded => FND_API.G_FALSE
2042: );
2043:
2044: WHEN OTHERS THEN
2045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2041: p_encoded => FND_API.G_FALSE
2042: );
2043:
2044: WHEN OTHERS THEN
2045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2046: Rollback to Create_MC_Revision_SP;
2047: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2048: THEN
2049: FND_MSG_PUB.add_exc_msg

Line 2060: p_encoded => FND_API.G_FALSE

2056: FND_MSG_PUB.count_and_get
2057: (
2058: p_count => x_msg_count,
2059: p_data => x_msg_data,
2060: p_encoded => FND_API.G_FALSE
2061: );
2062:
2063: END Create_MC_Revision;
2064:

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

2064:
2065: PROCEDURE Reopen_Master_Config
2066: (
2067: p_api_version IN NUMBER,
2068: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2069: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2070: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2071: x_return_status OUT NOCOPY VARCHAR2,
2072: x_msg_count OUT NOCOPY NUMBER,

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

2065: PROCEDURE Reopen_Master_Config
2066: (
2067: p_api_version IN NUMBER,
2068: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2069: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2070: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2071: x_return_status OUT NOCOPY VARCHAR2,
2072: x_msg_count OUT NOCOPY NUMBER,
2073: x_msg_data OUT NOCOPY VARCHAR2,

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

2066: (
2067: p_api_version IN NUMBER,
2068: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2069: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2070: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2071: x_return_status OUT NOCOPY VARCHAR2,
2072: x_msg_count OUT NOCOPY NUMBER,
2073: x_msg_data OUT NOCOPY VARCHAR2,
2074: p_mc_header_id IN NUMBER,

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

2143: -- Standard start of API savepoint
2144: SAVEPOINT Reopen_Master_Config_SP;
2145:
2146: -- Standard call to check for call compatibility
2147: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2148: THEN
2149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2150: END IF;
2151:

Line 2149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2145:
2146: -- Standard call to check for call compatibility
2147: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2148: THEN
2149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2150: END IF;
2151:
2152: -- Initialize message list if p_init_msg_list is set to TRUE
2153: IF FND_API.TO_BOOLEAN(p_init_msg_list)

Line 2153: IF FND_API.TO_BOOLEAN(p_init_msg_list)

2149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2150: END IF;
2151:
2152: -- Initialize message list if p_init_msg_list is set to TRUE
2153: IF FND_API.TO_BOOLEAN(p_init_msg_list)
2154: THEN
2155: FND_MSG_PUB.Initialize;
2156: END IF;
2157:

Line 2159: x_return_status := FND_API.G_RET_STS_SUCCESS;

2155: FND_MSG_PUB.Initialize;
2156: END IF;
2157:
2158: -- Initialize API return status to success
2159: x_return_status := FND_API.G_RET_STS_SUCCESS;
2160:
2161: -- API body starts here
2162: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2163: THEN

Line 2194: RAISE FND_API.G_EXC_ERROR;

2190: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2191: false
2192: );
2193: END IF;
2194: RAISE FND_API.G_EXC_ERROR;
2195: ELSIF (l_config_status_code = 'CLOSED')
2196: THEN
2197: l_config_status_code := 'COMPLETE';
2198: ELSE

Line 2232: RAISE FND_API.G_EXC_ERROR;

2228: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2229: false
2230: );
2231: END IF;
2232: RAISE FND_API.G_EXC_ERROR;
2233: ELSE
2234: IF(l_item_group_status = 'REMOVED') THEN
2235: UPDATE ahl_item_groups_b
2236: SET status_code ='COMPLETE',

Line 2286: RAISE FND_API.G_EXC_ERROR;

2282:
2283: -- Check Error Message stack.
2284: x_msg_count := FND_MSG_PUB.count_msg;
2285: IF x_msg_count > 0 THEN
2286: RAISE FND_API.G_EXC_ERROR;
2287: END IF;
2288:
2289: -- Standard check for p_commit
2290: IF FND_API.TO_BOOLEAN (p_commit)

Line 2290: IF FND_API.TO_BOOLEAN (p_commit)

2286: RAISE FND_API.G_EXC_ERROR;
2287: END IF;
2288:
2289: -- Standard check for p_commit
2290: IF FND_API.TO_BOOLEAN (p_commit)
2291: THEN
2292: COMMIT WORK;
2293: END IF;
2294:

Line 2300: p_encoded => FND_API.G_FALSE

2296: FND_MSG_PUB.count_and_get
2297: (
2298: p_count => x_msg_count,
2299: p_data => x_msg_data,
2300: p_encoded => FND_API.G_FALSE
2301: );
2302:
2303: EXCEPTION
2304: WHEN FND_API.G_EXC_ERROR THEN

Line 2304: WHEN FND_API.G_EXC_ERROR THEN

2300: p_encoded => FND_API.G_FALSE
2301: );
2302:
2303: EXCEPTION
2304: WHEN FND_API.G_EXC_ERROR THEN
2305: x_return_status := FND_API.G_RET_STS_ERROR;
2306: Rollback to Reopen_Master_Config_SP;
2307: FND_MSG_PUB.count_and_get
2308: (

Line 2305: x_return_status := FND_API.G_RET_STS_ERROR;

2301: );
2302:
2303: EXCEPTION
2304: WHEN FND_API.G_EXC_ERROR THEN
2305: x_return_status := FND_API.G_RET_STS_ERROR;
2306: Rollback to Reopen_Master_Config_SP;
2307: FND_MSG_PUB.count_and_get
2308: (
2309: p_count => x_msg_count,

Line 2311: p_encoded => FND_API.G_FALSE

2307: FND_MSG_PUB.count_and_get
2308: (
2309: p_count => x_msg_count,
2310: p_data => x_msg_data,
2311: p_encoded => FND_API.G_FALSE
2312: );
2313:
2314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2310: p_data => x_msg_data,
2311: p_encoded => FND_API.G_FALSE
2312: );
2313:
2314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2316: Rollback to Reopen_Master_Config_SP;
2317: FND_MSG_PUB.count_and_get
2318: (

Line 2315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2311: p_encoded => FND_API.G_FALSE
2312: );
2313:
2314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2316: Rollback to Reopen_Master_Config_SP;
2317: FND_MSG_PUB.count_and_get
2318: (
2319: p_count => x_msg_count,

Line 2321: p_encoded => FND_API.G_FALSE

2317: FND_MSG_PUB.count_and_get
2318: (
2319: p_count => x_msg_count,
2320: p_data => x_msg_data,
2321: p_encoded => FND_API.G_FALSE
2322: );
2323:
2324: WHEN OTHERS THEN
2325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2321: p_encoded => FND_API.G_FALSE
2322: );
2323:
2324: WHEN OTHERS THEN
2325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2326: Rollback to Reopen_Master_Config_SP;
2327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2328: THEN
2329: FND_MSG_PUB.add_exc_msg

Line 2340: p_encoded => FND_API.G_FALSE

2336: FND_MSG_PUB.count_and_get
2337: (
2338: p_count => x_msg_count,
2339: p_data => x_msg_data,
2340: p_encoded => FND_API.G_FALSE
2341: );
2342:
2343: END Reopen_Master_Config;
2344:

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

2344:
2345: PROCEDURE Initiate_MC_Approval
2346: (
2347: p_api_version IN NUMBER,
2348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2349: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2350: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2351: x_return_status OUT NOCOPY VARCHAR2,
2352: x_msg_count OUT NOCOPY NUMBER,

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

2345: PROCEDURE Initiate_MC_Approval
2346: (
2347: p_api_version IN NUMBER,
2348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2349: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2350: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2351: x_return_status OUT NOCOPY VARCHAR2,
2352: x_msg_count OUT NOCOPY NUMBER,
2353: x_msg_data OUT NOCOPY VARCHAR2,

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

2346: (
2347: p_api_version IN NUMBER,
2348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2349: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2350: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2351: x_return_status OUT NOCOPY VARCHAR2,
2352: x_msg_count OUT NOCOPY NUMBER,
2353: x_msg_data OUT NOCOPY VARCHAR2,
2354: p_mc_header_id IN NUMBER,

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

2374: -- Standard start of API savepoint
2375: SAVEPOINT Initiate_MC_Approval_SP;
2376:
2377: -- Standard call to check for call compatibility
2378: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2379: THEN
2380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2381: END IF;
2382:

Line 2380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2376:
2377: -- Standard call to check for call compatibility
2378: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2379: THEN
2380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2381: END IF;
2382:
2383: -- Initialize message list if p_init_msg_list is set to TRUE
2384: IF FND_API.TO_BOOLEAN(p_init_msg_list)

Line 2384: IF FND_API.TO_BOOLEAN(p_init_msg_list)

2380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2381: END IF;
2382:
2383: -- Initialize message list if p_init_msg_list is set to TRUE
2384: IF FND_API.TO_BOOLEAN(p_init_msg_list)
2385: THEN
2386: FND_MSG_PUB.Initialize;
2387: END IF;
2388:

Line 2390: x_return_status := FND_API.G_RET_STS_SUCCESS;

2386: FND_MSG_PUB.Initialize;
2387: END IF;
2388:
2389: -- Initialize API return status to success
2390: x_return_status := FND_API.G_RET_STS_SUCCESS;
2391:
2392: -- API body starts here
2393: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2394: THEN

Line 2420: RAISE FND_API.G_EXC_ERROR;

2416: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2417: false
2418: );
2419: END IF;
2420: RAISE FND_API.G_EXC_ERROR;
2421: END IF;
2422:
2423: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2424: THEN

Line 2450: RAISE FND_API.G_EXC_ERROR;

2446: -- Check Error Message stack.
2447: x_msg_count := FND_MSG_PUB.count_msg;
2448: IF x_msg_count > 0
2449: THEN
2450: RAISE FND_API.G_EXC_ERROR;
2451: END IF;
2452:
2453: -- No need to check for any profile option for enabled/disabled workflow
2454:

Line 2470: RAISE FND_API.G_EXC_ERROR;

2466:
2467: -- Check Error Message stack.
2468: x_msg_count := FND_MSG_PUB.count_msg;
2469: IF x_msg_count > 0 THEN
2470: RAISE FND_API.G_EXC_ERROR;
2471: END IF;
2472:
2473: IF (l_active = 'Y')
2474: THEN

Line 2557: RAISE FND_API.G_EXC_ERROR;

2553:
2554: -- Check Error Message stack.
2555: x_msg_count := FND_MSG_PUB.count_msg;
2556: IF x_msg_count > 0 THEN
2557: RAISE FND_API.G_EXC_ERROR;
2558: END IF;
2559:
2560: -- Standard check for p_commit
2561: IF FND_API.TO_BOOLEAN (p_commit)

Line 2561: IF FND_API.TO_BOOLEAN (p_commit)

2557: RAISE FND_API.G_EXC_ERROR;
2558: END IF;
2559:
2560: -- Standard check for p_commit
2561: IF FND_API.TO_BOOLEAN (p_commit)
2562: THEN
2563: COMMIT WORK;
2564: END IF;
2565:

Line 2571: p_encoded => FND_API.G_FALSE

2567: FND_MSG_PUB.count_and_get
2568: (
2569: p_count => x_msg_count,
2570: p_data => x_msg_data,
2571: p_encoded => FND_API.G_FALSE
2572: );
2573:
2574: EXCEPTION
2575: WHEN FND_API.G_EXC_ERROR THEN

Line 2575: WHEN FND_API.G_EXC_ERROR THEN

2571: p_encoded => FND_API.G_FALSE
2572: );
2573:
2574: EXCEPTION
2575: WHEN FND_API.G_EXC_ERROR THEN
2576: x_return_status := FND_API.G_RET_STS_ERROR;
2577: Rollback to Initiate_MC_Approval_SP;
2578: FND_MSG_PUB.count_and_get
2579: (

Line 2576: x_return_status := FND_API.G_RET_STS_ERROR;

2572: );
2573:
2574: EXCEPTION
2575: WHEN FND_API.G_EXC_ERROR THEN
2576: x_return_status := FND_API.G_RET_STS_ERROR;
2577: Rollback to Initiate_MC_Approval_SP;
2578: FND_MSG_PUB.count_and_get
2579: (
2580: p_count => x_msg_count,

Line 2582: p_encoded => FND_API.G_FALSE

2578: FND_MSG_PUB.count_and_get
2579: (
2580: p_count => x_msg_count,
2581: p_data => x_msg_data,
2582: p_encoded => FND_API.G_FALSE
2583: );
2584:
2585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2581: p_data => x_msg_data,
2582: p_encoded => FND_API.G_FALSE
2583: );
2584:
2585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2587: Rollback to Initiate_MC_Approval_SP;
2588: FND_MSG_PUB.count_and_get
2589: (

Line 2586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2582: p_encoded => FND_API.G_FALSE
2583: );
2584:
2585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2587: Rollback to Initiate_MC_Approval_SP;
2588: FND_MSG_PUB.count_and_get
2589: (
2590: p_count => x_msg_count,

Line 2592: p_encoded => FND_API.G_FALSE

2588: FND_MSG_PUB.count_and_get
2589: (
2590: p_count => x_msg_count,
2591: p_data => x_msg_data,
2592: p_encoded => FND_API.G_FALSE
2593: );
2594:
2595: WHEN OTHERS THEN
2596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2592: p_encoded => FND_API.G_FALSE
2593: );
2594:
2595: WHEN OTHERS THEN
2596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2597: Rollback to Initiate_MC_Approval_SP;
2598: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2599: THEN
2600: FND_MSG_PUB.add_exc_msg

Line 2611: p_encoded => FND_API.G_FALSE

2607: FND_MSG_PUB.count_and_get
2608: (
2609: p_count => x_msg_count,
2610: p_data => x_msg_data,
2611: p_encoded => FND_API.G_FALSE
2612: );
2613:
2614: END Initiate_MC_Approval;
2615:

Line 2653: RAISE FND_API.G_EXC_ERROR;

2649: false
2650: );
2651: END IF;
2652: CLOSE check_mc_exists;
2653: RAISE FND_API.G_EXC_ERROR;
2654: ELSIF (NVL(p_object_ver_num, l_dummy_number) <> l_dummy_number)
2655: THEN
2656: FND_MESSAGE.Set_Name('AHL', 'AHL_COM_RECORD_CHANGED');
2657: FND_MSG_PUB.ADD;

Line 2668: RAISE FND_API.G_EXC_ERROR;

2664: false
2665: );
2666: END IF;
2667: CLOSE check_mc_exists;
2668: RAISE FND_API.G_EXC_ERROR;
2669: END IF;
2670: CLOSE check_mc_exists;
2671:
2672: END Validate_MC_Exists;

Line 2898: RAISE FND_API.G_EXC_ERROR;

2894: false
2895: );
2896: END IF;
2897: CLOSE get_mc_status;
2898: RAISE FND_API.G_EXC_ERROR;
2899: END IF;
2900: CLOSE get_mc_status;
2901: END IF;
2902:

Line 3135: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3131: -- Do not need to check for the status after API call, as we need only FND_MSG stack's validation errors.
3132: AHL_MC_RULE_STMT_PVT.validate_quantity_rules_for_mc
3133: (
3134: p_api_version => 1.0,
3135: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3136: p_mc_header_id => p_mc_header_id,
3137: x_return_status => l_return_status,
3138: x_msg_count => l_msg_count,
3139: x_msg_data => l_msg_data