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

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

133: ---------------------
134: PROCEDURE Create_Node
135: (
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,

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

134: PROCEDURE Create_Node
135: (
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,

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

135: (
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_x_node_rec IN OUT NOCOPY Node_Rec_Type,

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

170: -- Standard start of API savepoint
171: SAVEPOINT Create_Node_SP;
172:
173: -- Standard call to check for call compatibility
174: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
175: THEN
176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
177: END IF;
178:

Line 176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

172:
173: -- Standard call to check for call compatibility
174: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
175: THEN
176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
177: END IF;
178:
179: -- Initialize message list if p_init_msg_list is set to TRUE
180: IF FND_API.TO_BOOLEAN(p_init_msg_list)

Line 180: IF FND_API.TO_BOOLEAN(p_init_msg_list)

176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
177: END IF;
178:
179: -- Initialize message list if p_init_msg_list is set to TRUE
180: IF FND_API.TO_BOOLEAN(p_init_msg_list)
181: THEN
182: FND_MSG_PUB.Initialize;
183: END IF;
184:

Line 186: x_return_status := FND_API.G_RET_STS_SUCCESS;

182: FND_MSG_PUB.Initialize;
183: END IF;
184:
185: -- Initialize API return status to success
186: x_return_status := FND_API.G_RET_STS_SUCCESS;
187:
188: -- API body starts here
189: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
190: THEN

Line 216: RAISE FND_API.G_EXC_ERROR;

212: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
213: false
214: );
215: END IF;
216: RAISE FND_API.G_EXC_ERROR;
217: ELSIF (l_header_status = 'APPROVAL_REJECTED')
218: THEN
219: -- 1b. Set status of MC to DRAFT if APPROVAL_REJECTED
220: Set_Header_Status(p_x_node_rec.relationship_id);

Line 263: RAISE FND_API.G_EXC_ERROR;

259:
260: -- Check Error Message stack.
261: x_msg_count := FND_MSG_PUB.count_msg;
262: IF x_msg_count > 0 THEN
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265:
266: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
267: THEN

Line 391: RAISE FND_API.G_EXC_ERROR;

387:
388: -- Check Error Message stack.
389: x_msg_count := FND_MSG_PUB.count_msg;
390: IF x_msg_count > 0 THEN
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393:
394: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
395: THEN

Line 427: RAISE FND_API.G_EXC_ERROR;

423:
424: -- Check Error Message stack.
425: x_msg_count := FND_MSG_PUB.count_msg;
426: IF x_msg_count > 0 THEN
427: RAISE FND_API.G_EXC_ERROR;
428: END IF;
429:
430: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
431: THEN

Line 460: RAISE FND_API.G_EXC_ERROR;

456: -- Check Error Message stack.
457: x_msg_count := FND_MSG_PUB.count_msg;
458:
459: IF x_msg_count > 0 THEN
460: RAISE FND_API.G_EXC_ERROR;
461: END IF;
462:
463: -- Standard check for p_commit
464: IF FND_API.TO_BOOLEAN (p_commit)

Line 464: IF FND_API.TO_BOOLEAN (p_commit)

460: RAISE FND_API.G_EXC_ERROR;
461: END IF;
462:
463: -- Standard check for p_commit
464: IF FND_API.TO_BOOLEAN (p_commit)
465: THEN
466: COMMIT WORK;
467: END IF;
468:

Line 474: p_encoded => FND_API.G_FALSE

470: FND_MSG_PUB.count_and_get
471: (
472: p_count => x_msg_count,
473: p_data => x_msg_data,
474: p_encoded => FND_API.G_FALSE
475: );
476:
477: EXCEPTION
478: WHEN FND_API.G_EXC_ERROR THEN

Line 478: WHEN FND_API.G_EXC_ERROR THEN

474: p_encoded => FND_API.G_FALSE
475: );
476:
477: EXCEPTION
478: WHEN FND_API.G_EXC_ERROR THEN
479: x_return_status := FND_API.G_RET_STS_ERROR;
480: Rollback to Create_Node_SP;
481: FND_MSG_PUB.count_and_get
482: (

Line 479: x_return_status := FND_API.G_RET_STS_ERROR;

475: );
476:
477: EXCEPTION
478: WHEN FND_API.G_EXC_ERROR THEN
479: x_return_status := FND_API.G_RET_STS_ERROR;
480: Rollback to Create_Node_SP;
481: FND_MSG_PUB.count_and_get
482: (
483: p_count => x_msg_count,

Line 485: p_encoded => FND_API.G_FALSE

481: FND_MSG_PUB.count_and_get
482: (
483: p_count => x_msg_count,
484: p_data => x_msg_data,
485: p_encoded => FND_API.G_FALSE
486: );
487:
488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

484: p_data => x_msg_data,
485: p_encoded => FND_API.G_FALSE
486: );
487:
488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490: Rollback to Create_Node_SP;
491: FND_MSG_PUB.count_and_get
492: (

Line 489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

485: p_encoded => FND_API.G_FALSE
486: );
487:
488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490: Rollback to Create_Node_SP;
491: FND_MSG_PUB.count_and_get
492: (
493: p_count => x_msg_count,

Line 495: p_encoded => FND_API.G_FALSE

491: FND_MSG_PUB.count_and_get
492: (
493: p_count => x_msg_count,
494: p_data => x_msg_data,
495: p_encoded => FND_API.G_FALSE
496: );
497:
498: WHEN OTHERS THEN
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

495: p_encoded => FND_API.G_FALSE
496: );
497:
498: WHEN OTHERS THEN
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
500: Rollback to Create_Node_SP;
501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
502: THEN
503: FND_MSG_PUB.add_exc_msg

Line 514: p_encoded => FND_API.G_FALSE

510: FND_MSG_PUB.count_and_get
511: (
512: p_count => x_msg_count,
513: p_data => x_msg_data,
514: p_encoded => FND_API.G_FALSE
515: );
516:
517: END Create_Node;
518:

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

518:
519: PROCEDURE Modify_Node
520: (
521: p_api_version IN NUMBER,
522: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
523: p_commit IN VARCHAR2 := FND_API.G_FALSE,
524: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
525: x_return_status OUT NOCOPY VARCHAR2,
526: x_msg_count OUT NOCOPY NUMBER,

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

519: PROCEDURE Modify_Node
520: (
521: p_api_version IN NUMBER,
522: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
523: p_commit IN VARCHAR2 := FND_API.G_FALSE,
524: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
525: x_return_status OUT NOCOPY VARCHAR2,
526: x_msg_count OUT NOCOPY NUMBER,
527: x_msg_data OUT NOCOPY VARCHAR2,

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

520: (
521: p_api_version IN NUMBER,
522: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
523: p_commit IN VARCHAR2 := FND_API.G_FALSE,
524: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
525: x_return_status OUT NOCOPY VARCHAR2,
526: x_msg_count OUT NOCOPY NUMBER,
527: x_msg_data OUT NOCOPY VARCHAR2,
528: p_x_node_rec IN OUT NOCOPY Node_Rec_Type,

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

624: -- Standard start of API savepoint
625: SAVEPOINT Modify_Node_SP;
626:
627: -- Standard call to check for call compatibility
628: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
629: THEN
630: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
631: END IF;
632:

Line 630: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

626:
627: -- Standard call to check for call compatibility
628: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
629: THEN
630: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
631: END IF;
632:
633: -- Initialize message list if p_init_msg_list is set to TRUE
634: IF FND_API.TO_BOOLEAN(p_init_msg_list)

Line 634: IF FND_API.TO_BOOLEAN(p_init_msg_list)

630: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
631: END IF;
632:
633: -- Initialize message list if p_init_msg_list is set to TRUE
634: IF FND_API.TO_BOOLEAN(p_init_msg_list)
635: THEN
636: FND_MSG_PUB.Initialize;
637: END IF;
638:

Line 640: x_return_status := FND_API.G_RET_STS_SUCCESS;

636: FND_MSG_PUB.Initialize;
637: END IF;
638:
639: -- Initialize API return status to success
640: x_return_status := FND_API.G_RET_STS_SUCCESS;
641:
642: -- API body starts here
643: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
644: THEN

Line 672: RAISE FND_API.G_EXC_ERROR;

668: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
669: false
670: );
671: END IF;
672: RAISE FND_API.G_EXC_ERROR;
673:
674: ELSIF (l_header_status = 'APPROVAL_REJECTED')
675: THEN
676: -- 1a.ii. Set status of MC to DRAFT if APPROVAL_REJECTED

Line 723: RAISE FND_API.G_EXC_ERROR;

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

Line 809: RAISE FND_API.G_EXC_ERROR;

805: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
806: false
807: );
808: END IF;
809: RAISE FND_API.G_EXC_ERROR;
810: ELSIF (l_header_status = 'APPROVAL_REJECTED')
811: THEN
812: -- 1a.ii. Set status of MC to DRAFT if APPROVAL_REJECTED
813: Set_Header_Status(p_x_node_rec.relationship_id);

Line 839: RAISE FND_API.G_EXC_ERROR;

835:
836: -- Check Error Message stack.
837: x_msg_count := FND_MSG_PUB.count_msg;
838: IF x_msg_count > 0 THEN
839: RAISE FND_API.G_EXC_ERROR;
840: END IF;
841:
842: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
843: THEN

Line 894: RAISE FND_API.G_EXC_ERROR;

890:
891: -- Check Error Message stack.
892: x_msg_count := FND_MSG_PUB.count_msg;
893: IF x_msg_count > 0 THEN
894: RAISE FND_API.G_EXC_ERROR;
895: END IF;
896: END LOOP;
897: END IF;
898:

Line 930: RAISE FND_API.G_EXC_ERROR;

926:
927: -- Check Error Message stack.
928: x_msg_count := FND_MSG_PUB.count_msg;
929: IF x_msg_count > 0 THEN
930: RAISE FND_API.G_EXC_ERROR;
931: END IF;
932: END LOOP;
933:
934: validate_priority(p_x_subconfig_tbl);

Line 951: RAISE FND_API.G_EXC_ERROR;

947:
948: -- Check Error Message stack.
949: x_msg_count := FND_MSG_PUB.count_msg;
950: IF x_msg_count > 0 THEN
951: RAISE FND_API.G_EXC_ERROR;
952: END IF;
953:
954: --R12
955: --Priyan MEL-CDL

Line 1024: IF FND_API.TO_BOOLEAN (p_commit)

1020: CLOSE check_leaf_node;
1021: END IF; -- condition for DML Update
1022:
1023: -- Standard check for p_commit
1024: IF FND_API.TO_BOOLEAN (p_commit)
1025: THEN
1026: COMMIT WORK;
1027: END IF;
1028:

Line 1032: IF ( x_msg_count > 0 and x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1028:
1029: -- Check Error Message stack.
1030: x_msg_count := FND_MSG_PUB.count_msg;
1031:
1032: IF ( x_msg_count > 0 and x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1033: RAISE FND_API.G_EXC_ERROR;
1034: END IF;
1035:
1036: -- Standard call to get message count and if count is 1, get message info

Line 1033: RAISE FND_API.G_EXC_ERROR;

1029: -- Check Error Message stack.
1030: x_msg_count := FND_MSG_PUB.count_msg;
1031:
1032: IF ( x_msg_count > 0 and x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1033: RAISE FND_API.G_EXC_ERROR;
1034: END IF;
1035:
1036: -- Standard call to get message count and if count is 1, get message info
1037: FND_MSG_PUB.count_and_get

Line 1041: p_encoded => FND_API.G_FALSE

1037: FND_MSG_PUB.count_and_get
1038: (
1039: p_count => x_msg_count,
1040: p_data => x_msg_data,
1041: p_encoded => FND_API.G_FALSE
1042: );
1043:
1044: EXCEPTION
1045: WHEN FND_API.G_EXC_ERROR THEN

Line 1045: WHEN FND_API.G_EXC_ERROR THEN

1041: p_encoded => FND_API.G_FALSE
1042: );
1043:
1044: EXCEPTION
1045: WHEN FND_API.G_EXC_ERROR THEN
1046: x_return_status := FND_API.G_RET_STS_ERROR;
1047: Rollback to Modify_Node_SP;
1048: FND_MSG_PUB.count_and_get
1049: (

Line 1046: x_return_status := FND_API.G_RET_STS_ERROR;

1042: );
1043:
1044: EXCEPTION
1045: WHEN FND_API.G_EXC_ERROR THEN
1046: x_return_status := FND_API.G_RET_STS_ERROR;
1047: Rollback to Modify_Node_SP;
1048: FND_MSG_PUB.count_and_get
1049: (
1050: p_count => x_msg_count,

Line 1052: p_encoded => FND_API.G_FALSE

1048: FND_MSG_PUB.count_and_get
1049: (
1050: p_count => x_msg_count,
1051: p_data => x_msg_data,
1052: p_encoded => FND_API.G_FALSE
1053: );
1054:
1055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1051: p_data => x_msg_data,
1052: p_encoded => FND_API.G_FALSE
1053: );
1054:
1055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1057: Rollback to Modify_Node_SP;
1058: FND_MSG_PUB.count_and_get
1059: (

Line 1056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1052: p_encoded => FND_API.G_FALSE
1053: );
1054:
1055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1057: Rollback to Modify_Node_SP;
1058: FND_MSG_PUB.count_and_get
1059: (
1060: p_count => x_msg_count,

Line 1062: p_encoded => FND_API.G_FALSE

1058: FND_MSG_PUB.count_and_get
1059: (
1060: p_count => x_msg_count,
1061: p_data => x_msg_data,
1062: p_encoded => FND_API.G_FALSE
1063: );
1064:
1065: WHEN OTHERS THEN
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1062: p_encoded => FND_API.G_FALSE
1063: );
1064:
1065: WHEN OTHERS THEN
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1067: Rollback to Modify_Node_SP;
1068: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1069: THEN
1070: FND_MSG_PUB.add_exc_msg

Line 1081: p_encoded => FND_API.G_FALSE

1077: FND_MSG_PUB.count_and_get
1078: (
1079: p_count => x_msg_count,
1080: p_data => x_msg_data,
1081: p_encoded => FND_API.G_FALSE
1082: );
1083:
1084: END Modify_Node;
1085:

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

1085:
1086: PROCEDURE Delete_Node
1087: (
1088: p_api_version IN NUMBER,
1089: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1090: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1091: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1092: x_return_status OUT NOCOPY VARCHAR2,
1093: x_msg_count OUT NOCOPY NUMBER,

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

1086: PROCEDURE Delete_Node
1087: (
1088: p_api_version IN NUMBER,
1089: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1090: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1091: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1092: x_return_status OUT NOCOPY VARCHAR2,
1093: x_msg_count OUT NOCOPY NUMBER,
1094: x_msg_data OUT NOCOPY VARCHAR2,

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

1087: (
1088: p_api_version IN NUMBER,
1089: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1090: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1091: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1092: x_return_status OUT NOCOPY VARCHAR2,
1093: x_msg_count OUT NOCOPY NUMBER,
1094: x_msg_data OUT NOCOPY VARCHAR2,
1095: p_node_id IN NUMBER,

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

1124: -- Standard start of API savepoint
1125: SAVEPOINT Delete_Node_SP;
1126:
1127: -- Standard call to check for call compatibility
1128: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1129: THEN
1130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1131: END IF;
1132:

Line 1130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1126:
1127: -- Standard call to check for call compatibility
1128: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1129: THEN
1130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1131: END IF;
1132:
1133: -- Initialize message list if p_init_msg_list is set to TRUE
1134: IF FND_API.TO_BOOLEAN(p_init_msg_list)

Line 1134: IF FND_API.TO_BOOLEAN(p_init_msg_list)

1130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1131: END IF;
1132:
1133: -- Initialize message list if p_init_msg_list is set to TRUE
1134: IF FND_API.TO_BOOLEAN(p_init_msg_list)
1135: THEN
1136: FND_MSG_PUB.Initialize;
1137: END IF;
1138:

Line 1140: x_return_status := FND_API.G_RET_STS_SUCCESS;

1136: FND_MSG_PUB.Initialize;
1137: END IF;
1138:
1139: -- Initialize API return status to success
1140: x_return_status := FND_API.G_RET_STS_SUCCESS;
1141:
1142: -- API body starts here
1143: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1144: THEN

Line 1171: RAISE FND_API.G_EXC_ERROR;

1167: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1168: false
1169: );
1170: END IF;
1171: RAISE FND_API.G_EXC_ERROR;
1172: ELSIF (l_header_status = 'APPROVAL_REJECTED')
1173: THEN
1174: -- 6ii. Set status of MC to DRAFT if APPROVAL_REJECTED
1175: Set_Header_Status(p_node_id);

Line 1217: p_init_msg_list => FND_API.G_FALSE,

1213: -- 9h. Delete all document associations to this particular node
1214: AHL_DI_ASSO_DOC_GEN_PVT.DELETE_ALL_ASSOCIATIONS
1215: (
1216: p_api_version => 1.0,
1217: p_init_msg_list => FND_API.G_FALSE,
1218: p_commit => FND_API.G_FALSE,
1219: p_validate_only => FND_API.G_FALSE,
1220: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1221: p_aso_object_type_code => 'MC',

Line 1218: p_commit => FND_API.G_FALSE,

1214: AHL_DI_ASSO_DOC_GEN_PVT.DELETE_ALL_ASSOCIATIONS
1215: (
1216: p_api_version => 1.0,
1217: p_init_msg_list => FND_API.G_FALSE,
1218: p_commit => FND_API.G_FALSE,
1219: p_validate_only => FND_API.G_FALSE,
1220: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1221: p_aso_object_type_code => 'MC',
1222: p_aso_object_id => l_node_csr_rec.relationship_id,

Line 1219: p_validate_only => FND_API.G_FALSE,

1215: (
1216: p_api_version => 1.0,
1217: p_init_msg_list => FND_API.G_FALSE,
1218: p_commit => FND_API.G_FALSE,
1219: p_validate_only => FND_API.G_FALSE,
1220: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1221: p_aso_object_type_code => 'MC',
1222: p_aso_object_id => l_node_csr_rec.relationship_id,
1223: x_return_status => l_return_status,

Line 1220: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1216: p_api_version => 1.0,
1217: p_init_msg_list => FND_API.G_FALSE,
1218: p_commit => FND_API.G_FALSE,
1219: p_validate_only => FND_API.G_FALSE,
1220: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1221: p_aso_object_type_code => 'MC',
1222: p_aso_object_id => l_node_csr_rec.relationship_id,
1223: x_return_status => l_return_status,
1224: x_msg_count => l_msg_count,

Line 1258: RAISE FND_API.G_EXC_ERROR;

1254:
1255: -- Check Error Message stack.
1256: x_msg_count := FND_MSG_PUB.count_msg;
1257: IF x_msg_count > 0 THEN
1258: RAISE FND_API.G_EXC_ERROR;
1259: END IF;
1260:
1261: -- Standard check for p_commit
1262: IF FND_API.TO_BOOLEAN (p_commit)

Line 1262: IF FND_API.TO_BOOLEAN (p_commit)

1258: RAISE FND_API.G_EXC_ERROR;
1259: END IF;
1260:
1261: -- Standard check for p_commit
1262: IF FND_API.TO_BOOLEAN (p_commit)
1263: THEN
1264: COMMIT WORK;
1265: END IF;
1266:

Line 1272: p_encoded => FND_API.G_FALSE

1268: FND_MSG_PUB.count_and_get
1269: (
1270: p_count => x_msg_count,
1271: p_data => x_msg_data,
1272: p_encoded => FND_API.G_FALSE
1273: );
1274:
1275: EXCEPTION
1276: WHEN FND_API.G_EXC_ERROR THEN

Line 1276: WHEN FND_API.G_EXC_ERROR THEN

1272: p_encoded => FND_API.G_FALSE
1273: );
1274:
1275: EXCEPTION
1276: WHEN FND_API.G_EXC_ERROR THEN
1277: x_return_status := FND_API.G_RET_STS_ERROR;
1278: Rollback to Delete_Node_SP;
1279: FND_MSG_PUB.count_and_get
1280: (

Line 1277: x_return_status := FND_API.G_RET_STS_ERROR;

1273: );
1274:
1275: EXCEPTION
1276: WHEN FND_API.G_EXC_ERROR THEN
1277: x_return_status := FND_API.G_RET_STS_ERROR;
1278: Rollback to Delete_Node_SP;
1279: FND_MSG_PUB.count_and_get
1280: (
1281: p_count => x_msg_count,

Line 1283: p_encoded => FND_API.G_FALSE

1279: FND_MSG_PUB.count_and_get
1280: (
1281: p_count => x_msg_count,
1282: p_data => x_msg_data,
1283: p_encoded => FND_API.G_FALSE
1284: );
1285:
1286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1282: p_data => x_msg_data,
1283: p_encoded => FND_API.G_FALSE
1284: );
1285:
1286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1288: Rollback to Delete_Node_SP;
1289: FND_MSG_PUB.count_and_get
1290: (

Line 1287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1283: p_encoded => FND_API.G_FALSE
1284: );
1285:
1286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1288: Rollback to Delete_Node_SP;
1289: FND_MSG_PUB.count_and_get
1290: (
1291: p_count => x_msg_count,

Line 1293: p_encoded => FND_API.G_FALSE

1289: FND_MSG_PUB.count_and_get
1290: (
1291: p_count => x_msg_count,
1292: p_data => x_msg_data,
1293: p_encoded => FND_API.G_FALSE
1294: );
1295: WHEN OTHERS THEN
1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1297: Rollback to Delete_Node_SP;

Line 1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1292: p_data => x_msg_data,
1293: p_encoded => FND_API.G_FALSE
1294: );
1295: WHEN OTHERS THEN
1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1297: Rollback to Delete_Node_SP;
1298: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1299: THEN
1300: FND_MSG_PUB.add_exc_msg

Line 1311: p_encoded => FND_API.G_FALSE

1307: FND_MSG_PUB.count_and_get
1308: (
1309: p_count => x_msg_count,
1310: p_data => x_msg_data,
1311: p_encoded => FND_API.G_FALSE
1312: );
1313:
1314: END Delete_Node;
1315:

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

1315:
1316: PROCEDURE Copy_Node
1317: (
1318: p_api_version IN NUMBER,
1319: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1320: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1321: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1322: x_return_status OUT NOCOPY VARCHAR2,
1323: x_msg_count OUT NOCOPY NUMBER,

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

1316: PROCEDURE Copy_Node
1317: (
1318: p_api_version IN NUMBER,
1319: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1320: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1321: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1322: x_return_status OUT NOCOPY VARCHAR2,
1323: x_msg_count OUT NOCOPY NUMBER,
1324: x_msg_data OUT NOCOPY VARCHAR2,

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

1317: (
1318: p_api_version IN NUMBER,
1319: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1320: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1321: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1322: x_return_status OUT NOCOPY VARCHAR2,
1323: x_msg_count OUT NOCOPY NUMBER,
1324: x_msg_data OUT NOCOPY VARCHAR2,
1325: p_parent_rel_id IN NUMBER,

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

1343: -- Standard start of API savepoint
1344: SAVEPOINT Copy_Node_SP;
1345:
1346: -- Standard call to check for call compatibility
1347: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1348: THEN
1349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1350: END IF;
1351:

Line 1349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1345:
1346: -- Standard call to check for call compatibility
1347: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1348: THEN
1349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1350: END IF;
1351:
1352: -- Initialize message list if p_init_msg_list is set to TRUE
1353: IF FND_API.TO_BOOLEAN(p_init_msg_list)

Line 1353: IF FND_API.TO_BOOLEAN(p_init_msg_list)

1349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1350: END IF;
1351:
1352: -- Initialize message list if p_init_msg_list is set to TRUE
1353: IF FND_API.TO_BOOLEAN(p_init_msg_list)
1354: THEN
1355: FND_MSG_PUB.Initialize;
1356: END IF;
1357:

Line 1359: x_return_status := FND_API.G_RET_STS_SUCCESS;

1355: FND_MSG_PUB.Initialize;
1356: END IF;
1357:
1358: -- Initialize API return status to success
1359: x_return_status := FND_API.G_RET_STS_SUCCESS;
1360:
1361: -- API body starts here
1362: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1363: THEN

Line 1391: RAISE FND_API.G_EXC_ERROR;

1387: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1388: false
1389: );
1390: END IF;
1391: RAISE FND_API.G_EXC_ERROR;
1392: ELSIF (l_header_status = 'APPROVAL_REJECTED')
1393: THEN
1394: Set_Header_Status(p_parent_rel_id);
1395: END IF;

Line 1404: RAISE FND_API.G_EXC_ERROR;

1400:
1401: -- Check Error Message stack.
1402: x_msg_count := FND_MSG_PUB.count_msg;
1403: IF x_msg_count > 0 THEN
1404: RAISE FND_API.G_EXC_ERROR;
1405: END IF;
1406:
1407: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1408: THEN

Line 1421: p_init_msg_list => FND_API.G_FALSE,

1417: -- 6. Call AHL_MC_Node_PVT.Copy_MC_Nodes
1418: Copy_MC_Nodes
1419: (
1420: p_api_version => 1.0,
1421: p_init_msg_list => FND_API.G_FALSE,
1422: p_commit => FND_API.G_FALSE,
1423: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1424: x_return_status => l_return_status,
1425: x_msg_count => l_msg_count,

Line 1422: p_commit => FND_API.G_FALSE,

1418: Copy_MC_Nodes
1419: (
1420: p_api_version => 1.0,
1421: p_init_msg_list => FND_API.G_FALSE,
1422: p_commit => FND_API.G_FALSE,
1423: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1424: x_return_status => l_return_status,
1425: x_msg_count => l_msg_count,
1426: x_msg_data => l_msg_data,

Line 1423: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1419: (
1420: p_api_version => 1.0,
1421: p_init_msg_list => FND_API.G_FALSE,
1422: p_commit => FND_API.G_FALSE,
1423: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1424: x_return_status => l_return_status,
1425: x_msg_count => l_msg_count,
1426: x_msg_data => l_msg_data,
1427: p_source_rel_id => p_x_node_id,

Line 1460: RAISE FND_API.G_EXC_ERROR;

1456:
1457: -- Check Error Message stack.
1458: x_msg_count := FND_MSG_PUB.count_msg;
1459: IF x_msg_count > 0 THEN
1460: RAISE FND_API.G_EXC_ERROR;
1461: END IF;
1462:
1463: -- Standard check for p_commit
1464: IF FND_API.TO_BOOLEAN (p_commit)

Line 1464: IF FND_API.TO_BOOLEAN (p_commit)

1460: RAISE FND_API.G_EXC_ERROR;
1461: END IF;
1462:
1463: -- Standard check for p_commit
1464: IF FND_API.TO_BOOLEAN (p_commit)
1465: THEN
1466: COMMIT WORK;
1467: END IF;
1468:

Line 1474: p_encoded => FND_API.G_FALSE

1470: FND_MSG_PUB.count_and_get
1471: (
1472: p_count => x_msg_count,
1473: p_data => x_msg_data,
1474: p_encoded => FND_API.G_FALSE
1475: );
1476:
1477: EXCEPTION
1478: WHEN FND_API.G_EXC_ERROR THEN

Line 1478: WHEN FND_API.G_EXC_ERROR THEN

1474: p_encoded => FND_API.G_FALSE
1475: );
1476:
1477: EXCEPTION
1478: WHEN FND_API.G_EXC_ERROR THEN
1479: x_return_status := FND_API.G_RET_STS_ERROR;
1480: Rollback to Copy_Node_SP;
1481: FND_MSG_PUB.count_and_get
1482: (

Line 1479: x_return_status := FND_API.G_RET_STS_ERROR;

1475: );
1476:
1477: EXCEPTION
1478: WHEN FND_API.G_EXC_ERROR THEN
1479: x_return_status := FND_API.G_RET_STS_ERROR;
1480: Rollback to Copy_Node_SP;
1481: FND_MSG_PUB.count_and_get
1482: (
1483: p_count => x_msg_count,

Line 1485: p_encoded => FND_API.G_FALSE

1481: FND_MSG_PUB.count_and_get
1482: (
1483: p_count => x_msg_count,
1484: p_data => x_msg_data,
1485: p_encoded => FND_API.G_FALSE
1486: );
1487:
1488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1484: p_data => x_msg_data,
1485: p_encoded => FND_API.G_FALSE
1486: );
1487:
1488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1490: Rollback to Copy_Node_SP;
1491: FND_MSG_PUB.count_and_get
1492: (

Line 1489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1485: p_encoded => FND_API.G_FALSE
1486: );
1487:
1488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1490: Rollback to Copy_Node_SP;
1491: FND_MSG_PUB.count_and_get
1492: (
1493: p_count => x_msg_count,

Line 1495: p_encoded => FND_API.G_FALSE

1491: FND_MSG_PUB.count_and_get
1492: (
1493: p_count => x_msg_count,
1494: p_data => x_msg_data,
1495: p_encoded => FND_API.G_FALSE
1496: );
1497:
1498: WHEN OTHERS THEN
1499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1495: p_encoded => FND_API.G_FALSE
1496: );
1497:
1498: WHEN OTHERS THEN
1499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1500: Rollback to Copy_Node_SP;
1501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1502: THEN
1503: FND_MSG_PUB.add_exc_msg

Line 1514: p_encoded => FND_API.G_FALSE

1510: FND_MSG_PUB.count_and_get
1511: (
1512: p_count => x_msg_count,
1513: p_data => x_msg_data,
1514: p_encoded => FND_API.G_FALSE
1515: );
1516:
1517: END Copy_Node;
1518:

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

1518:
1519: PROCEDURE Copy_MC_Nodes
1520: (
1521: p_api_version IN NUMBER,
1522: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1523: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1524: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1525: x_return_status OUT NOCOPY VARCHAR2,
1526: x_msg_count OUT NOCOPY NUMBER,

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

1519: PROCEDURE Copy_MC_Nodes
1520: (
1521: p_api_version IN NUMBER,
1522: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1523: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1524: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1525: x_return_status OUT NOCOPY VARCHAR2,
1526: x_msg_count OUT NOCOPY NUMBER,
1527: x_msg_data OUT NOCOPY VARCHAR2,

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

1520: (
1521: p_api_version IN NUMBER,
1522: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1523: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1524: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1525: x_return_status OUT NOCOPY VARCHAR2,
1526: x_msg_count OUT NOCOPY NUMBER,
1527: x_msg_data OUT NOCOPY VARCHAR2,
1528: p_source_rel_id IN NUMBER,

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

1632: -- Standard start of API savepoint
1633: SAVEPOINT Copy_MC_Nodes_SP;
1634:
1635: -- Standard call to check for call compatibility
1636: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1637: THEN
1638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1639: END IF;
1640:

Line 1638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1634:
1635: -- Standard call to check for call compatibility
1636: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1637: THEN
1638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1639: END IF;
1640:
1641: -- Initialize message list if p_init_msg_list is set to TRUE
1642: IF FND_API.TO_BOOLEAN(p_init_msg_list)

Line 1642: IF FND_API.TO_BOOLEAN(p_init_msg_list)

1638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1639: END IF;
1640:
1641: -- Initialize message list if p_init_msg_list is set to TRUE
1642: IF FND_API.TO_BOOLEAN(p_init_msg_list)
1643: THEN
1644: FND_MSG_PUB.Initialize;
1645: END IF;
1646:

Line 1648: x_return_status := FND_API.G_RET_STS_SUCCESS;

1644: FND_MSG_PUB.Initialize;
1645: END IF;
1646:
1647: -- Initialize API return status to success
1648: x_return_status := FND_API.G_RET_STS_SUCCESS;
1649:
1650: -- API body starts here
1651: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1652: THEN

Line 1916: p_init_msg_list => FND_API.G_FALSE,

1912: -- 7l.iv. Call AHL_MC_Node_PVT.Create_Node
1913: Create_Node
1914: (
1915: p_api_version => 1.0,
1916: p_init_msg_list => FND_API.G_FALSE,
1917: p_commit => FND_API.G_FALSE,
1918: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1919: x_return_status => l_return_status,
1920: x_msg_count => l_msg_count,

Line 1917: p_commit => FND_API.G_FALSE,

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

Line 1918: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1914: (
1915: p_api_version => 1.0,
1916: p_init_msg_list => FND_API.G_FALSE,
1917: p_commit => FND_API.G_FALSE,
1918: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1919: x_return_status => l_return_status,
1920: x_msg_count => l_msg_count,
1921: x_msg_data => l_msg_data,
1922: p_x_node_rec => l_nodes_tbl(i),

Line 1930: RAISE FND_API.G_EXC_ERROR;

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

Line 1980: p_commit => FND_API.G_FALSE,

1976: -- 7m.i. Call AHL_DI_ASSO_DOC_GEN_PVT.COPY_ASSOCIATION
1977: AHL_DI_ASSO_DOC_GEN_PVT.COPY_ASSOCIATION
1978: (
1979: p_api_version => 1.0,
1980: p_commit => FND_API.G_FALSE,
1981: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1982: p_from_object_id => l_old_node_id_tbl(i),
1983: p_from_object_type => 'MC',
1984: p_to_object_id => l_nodes_tbl(i).relationship_id,

Line 1981: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1977: AHL_DI_ASSO_DOC_GEN_PVT.COPY_ASSOCIATION
1978: (
1979: p_api_version => 1.0,
1980: p_commit => FND_API.G_FALSE,
1981: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1982: p_from_object_id => l_old_node_id_tbl(i),
1983: p_from_object_type => 'MC',
1984: p_to_object_id => l_nodes_tbl(i).relationship_id,
1985: p_to_object_type => 'MC',

Line 1994: RAISE FND_API.G_EXC_ERROR;

1990:
1991: -- Check Error Message stack.
1992: x_msg_count := FND_MSG_PUB.count_msg;
1993: IF x_msg_count > 0 THEN
1994: RAISE FND_API.G_EXC_ERROR;
1995: END IF;
1996:
1997: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1998: THEN

Line 2017: RAISE FND_API.G_EXC_ERROR;

2013:
2014: -- Check Error Message stack.
2015: x_msg_count := FND_MSG_PUB.count_msg;
2016: IF x_msg_count > 0 THEN
2017: RAISE FND_API.G_EXC_ERROR;
2018: END IF;
2019: END LOOP;
2020: END IF;
2021:

Line 2036: RAISE FND_API.G_EXC_ERROR;

2032:
2033: -- Check Error Message stack.
2034: x_msg_count := FND_MSG_PUB.count_msg;
2035: IF x_msg_count > 0 THEN
2036: RAISE FND_API.G_EXC_ERROR;
2037: END IF;
2038:
2039: -- Standard check for p_commit
2040: IF FND_API.TO_BOOLEAN (p_commit)

Line 2040: IF FND_API.TO_BOOLEAN (p_commit)

2036: RAISE FND_API.G_EXC_ERROR;
2037: END IF;
2038:
2039: -- Standard check for p_commit
2040: IF FND_API.TO_BOOLEAN (p_commit)
2041: THEN
2042: COMMIT WORK;
2043: END IF;
2044:

Line 2050: p_encoded => FND_API.G_FALSE

2046: FND_MSG_PUB.count_and_get
2047: (
2048: p_count => x_msg_count,
2049: p_data => x_msg_data,
2050: p_encoded => FND_API.G_FALSE
2051: );
2052:
2053: EXCEPTION
2054: WHEN FND_API.G_EXC_ERROR THEN

Line 2054: WHEN FND_API.G_EXC_ERROR THEN

2050: p_encoded => FND_API.G_FALSE
2051: );
2052:
2053: EXCEPTION
2054: WHEN FND_API.G_EXC_ERROR THEN
2055: x_return_status := FND_API.G_RET_STS_ERROR;
2056: Rollback to Copy_MC_Nodes_SP;
2057: FND_MSG_PUB.count_and_get
2058: (

Line 2055: x_return_status := FND_API.G_RET_STS_ERROR;

2051: );
2052:
2053: EXCEPTION
2054: WHEN FND_API.G_EXC_ERROR THEN
2055: x_return_status := FND_API.G_RET_STS_ERROR;
2056: Rollback to Copy_MC_Nodes_SP;
2057: FND_MSG_PUB.count_and_get
2058: (
2059: p_count => x_msg_count,

Line 2061: p_encoded => FND_API.G_FALSE

2057: FND_MSG_PUB.count_and_get
2058: (
2059: p_count => x_msg_count,
2060: p_data => x_msg_data,
2061: p_encoded => FND_API.G_FALSE
2062: );
2063:
2064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2060: p_data => x_msg_data,
2061: p_encoded => FND_API.G_FALSE
2062: );
2063:
2064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2066: Rollback to Copy_MC_Nodes_SP;
2067: FND_MSG_PUB.count_and_get
2068: (

Line 2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2061: p_encoded => FND_API.G_FALSE
2062: );
2063:
2064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2066: Rollback to Copy_MC_Nodes_SP;
2067: FND_MSG_PUB.count_and_get
2068: (
2069: p_count => x_msg_count,

Line 2071: p_encoded => FND_API.G_FALSE

2067: FND_MSG_PUB.count_and_get
2068: (
2069: p_count => x_msg_count,
2070: p_data => x_msg_data,
2071: p_encoded => FND_API.G_FALSE
2072: );
2073:
2074: WHEN OTHERS THEN
2075: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2075: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2071: p_encoded => FND_API.G_FALSE
2072: );
2073:
2074: WHEN OTHERS THEN
2075: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2076: Rollback to Copy_MC_Nodes_SP;
2077: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2078: THEN
2079: FND_MSG_PUB.add_exc_msg

Line 2090: p_encoded => FND_API.G_FALSE

2086: FND_MSG_PUB.count_and_get
2087: (
2088: p_count => x_msg_count,
2089: p_data => x_msg_data,
2090: p_encoded => FND_API.G_FALSE
2091: );
2092:
2093: END Copy_MC_Nodes;
2094:

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

2094:
2095: PROCEDURE Process_Documents
2096: (
2097: p_api_version IN NUMBER,
2098: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2099: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2100: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2101: x_return_status OUT NOCOPY VARCHAR2,
2102: x_msg_count OUT NOCOPY NUMBER,

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

2095: PROCEDURE Process_Documents
2096: (
2097: p_api_version IN NUMBER,
2098: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2099: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2100: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2101: x_return_status OUT NOCOPY VARCHAR2,
2102: x_msg_count OUT NOCOPY NUMBER,
2103: x_msg_data OUT NOCOPY VARCHAR2,

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

2096: (
2097: p_api_version IN NUMBER,
2098: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2099: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2100: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2101: x_return_status OUT NOCOPY VARCHAR2,
2102: x_msg_count OUT NOCOPY NUMBER,
2103: x_msg_data OUT NOCOPY VARCHAR2,
2104: p_node_id IN NUMBER,

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

2120: -- Standard start of API savepoint
2121: SAVEPOINT Process_Documents_SP;
2122:
2123: -- Standard call to check for call compatibility
2124: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2125: THEN
2126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2127: END IF;
2128:

Line 2126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2122:
2123: -- Standard call to check for call compatibility
2124: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2125: THEN
2126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2127: END IF;
2128:
2129: -- Initialize message list if p_init_msg_list is set to TRUE
2130: IF FND_API.TO_BOOLEAN(p_init_msg_list)

Line 2130: IF FND_API.TO_BOOLEAN(p_init_msg_list)

2126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2127: END IF;
2128:
2129: -- Initialize message list if p_init_msg_list is set to TRUE
2130: IF FND_API.TO_BOOLEAN(p_init_msg_list)
2131: THEN
2132: FND_MSG_PUB.Initialize;
2133: END IF;
2134:

Line 2136: x_return_status := FND_API.G_RET_STS_SUCCESS;

2132: FND_MSG_PUB.Initialize;
2133: END IF;
2134:
2135: -- Initialize API return status to success
2136: x_return_status := FND_API.G_RET_STS_SUCCESS;
2137:
2138: -- API body starts here
2139: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2140: THEN

Line 2167: RAISE FND_API.G_EXC_ERROR;

2163: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2164: false
2165: );
2166: END IF;
2167: RAISE FND_API.G_EXC_ERROR;
2168: ELSIF (l_header_status = 'APPROVAL_REJECTED')
2169: THEN
2170: -- 6ii. Set status of MC to DRAFT if APPROVAL_REJECTED
2171: Set_Header_Status(p_node_id);

Line 2177: RAISE FND_API.G_EXC_ERROR;

2173:
2174: -- Check Error Message stack.
2175: x_msg_count := FND_MSG_PUB.count_msg;
2176: IF x_msg_count > 0 THEN
2177: RAISE FND_API.G_EXC_ERROR;
2178: END IF;
2179:
2180: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2181: THEN

Line 2218: RAISE FND_API.G_EXC_ERROR;

2214:
2215: -- Check Error Message stack.
2216: x_msg_count := FND_MSG_PUB.count_msg;
2217: IF x_msg_count > 0 THEN
2218: RAISE FND_API.G_EXC_ERROR;
2219: END IF;
2220:
2221: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2222: THEN

Line 2234: p_init_msg_list => FND_API.G_FALSE,

2230:
2231: AHL_DI_ASSO_DOC_GEN_PUB.PROCESS_ASSOCIATION
2232: (
2233: p_api_version => 1.0,
2234: p_init_msg_list => FND_API.G_FALSE,
2235: p_commit => FND_API.G_FALSE,
2236: p_validate_only => FND_API.G_FALSE,
2237: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2238: p_x_association_tbl => p_x_documents_tbl,

Line 2235: p_commit => FND_API.G_FALSE,

2231: AHL_DI_ASSO_DOC_GEN_PUB.PROCESS_ASSOCIATION
2232: (
2233: p_api_version => 1.0,
2234: p_init_msg_list => FND_API.G_FALSE,
2235: p_commit => FND_API.G_FALSE,
2236: p_validate_only => FND_API.G_FALSE,
2237: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2238: p_x_association_tbl => p_x_documents_tbl,
2239: p_module_type => 'JSP',

Line 2236: p_validate_only => FND_API.G_FALSE,

2232: (
2233: p_api_version => 1.0,
2234: p_init_msg_list => FND_API.G_FALSE,
2235: p_commit => FND_API.G_FALSE,
2236: p_validate_only => FND_API.G_FALSE,
2237: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2238: p_x_association_tbl => p_x_documents_tbl,
2239: p_module_type => 'JSP',
2240: x_return_status => l_return_status,

Line 2237: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2233: p_api_version => 1.0,
2234: p_init_msg_list => FND_API.G_FALSE,
2235: p_commit => FND_API.G_FALSE,
2236: p_validate_only => FND_API.G_FALSE,
2237: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2238: p_x_association_tbl => p_x_documents_tbl,
2239: p_module_type => 'JSP',
2240: x_return_status => l_return_status,
2241: x_msg_count => l_msg_count,

Line 2260: RAISE FND_API.G_EXC_ERROR;

2256:
2257: -- Check Error Message stack.
2258: x_msg_count := FND_MSG_PUB.count_msg;
2259: IF x_msg_count > 0 THEN
2260: RAISE FND_API.G_EXC_ERROR;
2261: END IF;
2262:
2263: -- Standard check for p_commit
2264: IF FND_API.TO_BOOLEAN (p_commit)

Line 2264: IF FND_API.TO_BOOLEAN (p_commit)

2260: RAISE FND_API.G_EXC_ERROR;
2261: END IF;
2262:
2263: -- Standard check for p_commit
2264: IF FND_API.TO_BOOLEAN (p_commit)
2265: THEN
2266: COMMIT WORK;
2267: END IF;
2268:

Line 2274: p_encoded => FND_API.G_FALSE

2270: FND_MSG_PUB.count_and_get
2271: (
2272: p_count => x_msg_count,
2273: p_data => x_msg_data,
2274: p_encoded => FND_API.G_FALSE
2275: );
2276:
2277: EXCEPTION
2278: WHEN FND_API.G_EXC_ERROR THEN

Line 2278: WHEN FND_API.G_EXC_ERROR THEN

2274: p_encoded => FND_API.G_FALSE
2275: );
2276:
2277: EXCEPTION
2278: WHEN FND_API.G_EXC_ERROR THEN
2279: x_return_status := FND_API.G_RET_STS_ERROR;
2280: Rollback to Process_Documents_SP;
2281: FND_MSG_PUB.count_and_get
2282: (

Line 2279: x_return_status := FND_API.G_RET_STS_ERROR;

2275: );
2276:
2277: EXCEPTION
2278: WHEN FND_API.G_EXC_ERROR THEN
2279: x_return_status := FND_API.G_RET_STS_ERROR;
2280: Rollback to Process_Documents_SP;
2281: FND_MSG_PUB.count_and_get
2282: (
2283: p_count => x_msg_count,

Line 2285: p_encoded => FND_API.G_FALSE

2281: FND_MSG_PUB.count_and_get
2282: (
2283: p_count => x_msg_count,
2284: p_data => x_msg_data,
2285: p_encoded => FND_API.G_FALSE
2286: );
2287:
2288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2284: p_data => x_msg_data,
2285: p_encoded => FND_API.G_FALSE
2286: );
2287:
2288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2290: Rollback to Process_Documents_SP;
2291: FND_MSG_PUB.count_and_get
2292: (

Line 2289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2285: p_encoded => FND_API.G_FALSE
2286: );
2287:
2288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2290: Rollback to Process_Documents_SP;
2291: FND_MSG_PUB.count_and_get
2292: (
2293: p_count => x_msg_count,

Line 2295: p_encoded => FND_API.G_FALSE

2291: FND_MSG_PUB.count_and_get
2292: (
2293: p_count => x_msg_count,
2294: p_data => x_msg_data,
2295: p_encoded => FND_API.G_FALSE
2296: );
2297:
2298: WHEN OTHERS THEN
2299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2295: p_encoded => FND_API.G_FALSE
2296: );
2297:
2298: WHEN OTHERS THEN
2299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2300: Rollback to Process_Documents_SP;
2301: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2302: THEN
2303: FND_MSG_PUB.add_exc_msg

Line 2314: p_encoded => FND_API.G_FALSE

2310: FND_MSG_PUB.count_and_get
2311: (
2312: p_count => x_msg_count,
2313: p_data => x_msg_data,
2314: p_encoded => FND_API.G_FALSE
2315: );
2316:
2317: END Process_Documents;
2318:

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

2318:
2319: PROCEDURE Associate_Item_Group
2320: (
2321: p_api_version IN NUMBER,
2322: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2323: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2324: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2325: x_return_status OUT NOCOPY VARCHAR2,
2326: x_msg_count OUT NOCOPY NUMBER,

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

2319: PROCEDURE Associate_Item_Group
2320: (
2321: p_api_version IN NUMBER,
2322: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2323: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2324: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2325: x_return_status OUT NOCOPY VARCHAR2,
2326: x_msg_count OUT NOCOPY NUMBER,
2327: x_msg_data OUT NOCOPY VARCHAR2,

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

2320: (
2321: p_api_version IN NUMBER,
2322: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2323: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2324: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2325: x_return_status OUT NOCOPY VARCHAR2,
2326: x_msg_count OUT NOCOPY NUMBER,
2327: x_msg_data OUT NOCOPY VARCHAR2,
2328: p_nodes_tbl IN Node_Tbl_Type

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

2364: -- Standard start of API savepoint
2365: SAVEPOINT Associate_Item_Group_SP;
2366:
2367: -- Standard call to check for call compatibility
2368: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2369: THEN
2370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2371: END IF;
2372:

Line 2370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2366:
2367: -- Standard call to check for call compatibility
2368: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2369: THEN
2370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2371: END IF;
2372:
2373: -- Initialize message list if p_init_msg_list is set to TRUE
2374: IF FND_API.TO_BOOLEAN(p_init_msg_list)

Line 2374: IF FND_API.TO_BOOLEAN(p_init_msg_list)

2370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2371: END IF;
2372:
2373: -- Initialize message list if p_init_msg_list is set to TRUE
2374: IF FND_API.TO_BOOLEAN(p_init_msg_list)
2375: THEN
2376: FND_MSG_PUB.Initialize;
2377: END IF;
2378:

Line 2380: x_return_status := FND_API.G_RET_STS_SUCCESS;

2376: FND_MSG_PUB.Initialize;
2377: END IF;
2378:
2379: -- Initialize API return status to success
2380: x_return_status := FND_API.G_RET_STS_SUCCESS;
2381:
2382: -- API body starts here
2383: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2384: THEN

Line 2412: RAISE FND_API.G_EXC_ERROR;

2408: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2409: false
2410: );
2411: END IF;
2412: RAISE FND_API.G_EXC_ERROR;
2413: ELSIF (l_header_status = 'APPROVAL_REJECTED')
2414: THEN
2415: -- Set status of MC to DRAFT if APPROVAL_REJECTED
2416: Set_Header_Status(p_nodes_tbl(i).relationship_id);

Line 2503: RAISE FND_API.G_EXC_ERROR;

2499:
2500: -- Check Error Message stack.
2501: x_msg_count := FND_MSG_PUB.count_msg;
2502: IF x_msg_count > 0 THEN
2503: RAISE FND_API.G_EXC_ERROR;
2504: END IF;
2505:
2506: UPDATE ahl_mc_relationships
2507: SET item_group_id = l_item_group_id

Line 2536: RAISE FND_API.G_EXC_ERROR;

2532:
2533: -- Check Error Message stack.
2534: x_msg_count := FND_MSG_PUB.count_msg;
2535: IF x_msg_count > 0 THEN
2536: RAISE FND_API.G_EXC_ERROR;
2537: END IF;
2538:
2539: -- Standard check for p_commit
2540: IF FND_API.TO_BOOLEAN (p_commit)

Line 2540: IF FND_API.TO_BOOLEAN (p_commit)

2536: RAISE FND_API.G_EXC_ERROR;
2537: END IF;
2538:
2539: -- Standard check for p_commit
2540: IF FND_API.TO_BOOLEAN (p_commit)
2541: THEN
2542: COMMIT WORK;
2543: END IF;
2544:

Line 2550: p_encoded => FND_API.G_FALSE

2546: FND_MSG_PUB.count_and_get
2547: (
2548: p_count => x_msg_count,
2549: p_data => x_msg_data,
2550: p_encoded => FND_API.G_FALSE
2551: );
2552:
2553: EXCEPTION
2554: WHEN FND_API.G_EXC_ERROR THEN

Line 2554: WHEN FND_API.G_EXC_ERROR THEN

2550: p_encoded => FND_API.G_FALSE
2551: );
2552:
2553: EXCEPTION
2554: WHEN FND_API.G_EXC_ERROR THEN
2555: x_return_status := FND_API.G_RET_STS_ERROR;
2556: Rollback to Associate_Item_Group_SP;
2557: FND_MSG_PUB.count_and_get
2558: (

Line 2555: x_return_status := FND_API.G_RET_STS_ERROR;

2551: );
2552:
2553: EXCEPTION
2554: WHEN FND_API.G_EXC_ERROR THEN
2555: x_return_status := FND_API.G_RET_STS_ERROR;
2556: Rollback to Associate_Item_Group_SP;
2557: FND_MSG_PUB.count_and_get
2558: (
2559: p_count => x_msg_count,

Line 2561: p_encoded => FND_API.G_FALSE

2557: FND_MSG_PUB.count_and_get
2558: (
2559: p_count => x_msg_count,
2560: p_data => x_msg_data,
2561: p_encoded => FND_API.G_FALSE
2562: );
2563:
2564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2560: p_data => x_msg_data,
2561: p_encoded => FND_API.G_FALSE
2562: );
2563:
2564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2566: Rollback to Associate_Item_Group_SP;
2567: FND_MSG_PUB.count_and_get
2568: (

Line 2565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2561: p_encoded => FND_API.G_FALSE
2562: );
2563:
2564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2566: Rollback to Associate_Item_Group_SP;
2567: FND_MSG_PUB.count_and_get
2568: (
2569: p_count => x_msg_count,

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: WHEN OTHERS THEN
2575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2571: p_encoded => FND_API.G_FALSE
2572: );
2573:
2574: WHEN OTHERS THEN
2575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2576: Rollback to Associate_Item_Group_SP;
2577: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2578: THEN
2579: FND_MSG_PUB.add_exc_msg

Line 2590: p_encoded => FND_API.G_FALSE

2586: FND_MSG_PUB.count_and_get
2587: (
2588: p_count => x_msg_count,
2589: p_data => x_msg_data,
2590: p_encoded => FND_API.G_FALSE
2591: );
2592:
2593: END Associate_Item_Group;
2594:

Line 2629: RAISE FND_API.G_EXC_ERROR;

2625: false
2626: );
2627: END IF;
2628: CLOSE check_node_exists;
2629: RAISE FND_API.G_EXC_ERROR;
2630: ELSIF (NVL(p_object_ver_num, l_dummy_number) <> l_dummy_number)
2631: THEN
2632: FND_MESSAGE.Set_Name('AHL', 'AHL_COM_RECORD_CHANGED');
2633: FND_MSG_PUB.ADD;

Line 2644: RAISE FND_API.G_EXC_ERROR;

2640: false
2641: );
2642: END IF;
2643: CLOSE check_node_exists;
2644: RAISE FND_API.G_EXC_ERROR;
2645: END IF;
2646: CLOSE check_node_exists;
2647:
2648: END Validate_Node_Exists;

Line 2767: RAISE FND_API.G_EXC_ERROR;

2763: );
2764: END IF;
2765:
2766: CLOSE get_node_details;
2767: RAISE FND_API.G_EXC_ERROR;
2768: ELSE
2769: CLOSE get_node_details;
2770:
2771: -- 2c. Validate that the parent node has quantity = 1 [only in this can a child node be added to the parent position]

Line 2861: RAISE FND_API.G_EXC_ERROR;

2857: false
2858: );
2859: END IF;
2860: CLOSE check_topnode_exists;
2861: RAISE FND_API.G_EXC_ERROR;
2862: END IF;
2863: CLOSE check_topnode_exists;
2864: END IF;
2865:

Line 3306: RAISE FND_API.G_EXC_ERROR;

3302: false
3303: );
3304: END IF;
3305: CLOSE check_counter_exists;
3306: RAISE FND_API.G_EXC_ERROR;
3307: ELSIF (NVL(p_object_ver_num, l_dummy_number) <> l_dummy_number)
3308: THEN
3309: FND_MESSAGE.Set_Name('AHL', 'AHL_COM_RECORD_CHANGED');
3310: FND_MSG_PUB.ADD;

Line 3321: RAISE FND_API.G_EXC_ERROR;

3317: false
3318: );
3319: END IF;
3320: CLOSE check_counter_exists;
3321: RAISE FND_API.G_EXC_ERROR;
3322: END IF;
3323: CLOSE check_counter_exists;
3324:
3325: END Validate_Counter_Exists;

Line 3500: RAISE FND_API.G_EXC_ERROR;

3496: false
3497: );
3498: END IF;
3499: CLOSE check_submc_exists;
3500: RAISE FND_API.G_EXC_ERROR;
3501: ELSIF (NVL(p_object_ver_num, l_dummy_number) <> l_dummy_number)
3502: THEN
3503: FND_MESSAGE.Set_Name('AHL', 'AHL_COM_RECORD_CHANGED');
3504: FND_MSG_PUB.ADD;

Line 3515: RAISE FND_API.G_EXC_ERROR;

3511: false
3512: );
3513: END IF;
3514: CLOSE check_submc_exists;
3515: RAISE FND_API.G_EXC_ERROR;
3516: END IF;
3517: CLOSE check_submc_exists;
3518:
3519: END Validate_Subconfig_Exists;

Line 3556: RAISE FND_API.G_EXC_ERROR;

3552: true
3553: );
3554: END IF;
3555: CLOSE check_priority_dup_exists;
3556: RAISE FND_API.G_EXC_ERROR;
3557: END IF;
3558:
3559: END Validate_priority;
3560:

Line 3684: RAISE FND_API.G_EXC_ERROR;

3680: false
3681: );
3682: END IF;
3683: CLOSE get_node_mc_status;
3684: RAISE FND_API.G_EXC_ERROR;
3685: END IF;
3686: CLOSE get_node_mc_status;
3687: ELSIF (p_mc_header_id IS NOT NULL)
3688: THEN

Line 3705: RAISE FND_API.G_EXC_ERROR;

3701: false
3702: );
3703: END IF;
3704: CLOSE get_mc_status;
3705: RAISE FND_API.G_EXC_ERROR;
3706: END IF;
3707: CLOSE get_mc_status;
3708: END IF;
3709:

Line 3837: RAISE FND_API.G_EXC_ERROR;

3833:
3834: -- Check Error Message stack.
3835: l_msg_count := FND_MSG_PUB.count_msg;
3836: IF l_msg_count > 0 THEN
3837: RAISE FND_API.G_EXC_ERROR;
3838: END IF;
3839:
3840: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3841: THEN

Line 3976: RAISE FND_API.G_EXC_ERROR;

3972:
3973: -- Check Error Message stack.
3974: l_msg_count := FND_MSG_PUB.count_msg;
3975: IF l_msg_count > 0 THEN
3976: RAISE FND_API.G_EXC_ERROR;
3977: END IF;
3978:
3979: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3980: THEN

Line 4158: RAISE FND_API.G_EXC_ERROR;

4154: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4155: false
4156: );
4157: END IF;
4158: RAISE FND_API.G_EXC_ERROR;
4159: END IF;
4160: CLOSE check_root_node;
4161:
4162: OPEN check_leaf_node;

Line 4177: RAISE FND_API.G_EXC_ERROR;

4173: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4174: false
4175: );
4176: END IF;
4177: RAISE FND_API.G_EXC_ERROR;
4178: END IF;
4179: CLOSE check_leaf_node;
4180:
4181: -- Validate the MC with mc_header_id = p_x_subconfig_rec.mc_header_id is complete/draft/approval_rejected

Line 4196: RAISE FND_API.G_EXC_ERROR;

4192: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4193: false
4194: );
4195: END IF;
4196: RAISE FND_API.G_EXC_ERROR;
4197: END IF;
4198:
4199: -- Validate whether the subconfiguration is not already associated with the MC node
4200: OPEN check_submc_exists;

Line 4218: RAISE FND_API.G_EXC_ERROR;

4214: );
4215: END IF;
4216:
4217: CLOSE check_submc_exists;
4218: RAISE FND_API.G_EXC_ERROR;
4219: END IF;
4220: CLOSE check_submc_exists;
4221:
4222: -- anraj changed for fixing the bug # 3696668

Line 4255: RAISE FND_API.G_EXC_ERROR;

4251:
4252: -- Check Error Message stack.
4253: l_msg_count := FND_MSG_PUB.count_msg;
4254: IF l_msg_count > 0 THEN
4255: RAISE FND_API.G_EXC_ERROR;
4256: END IF;
4257:
4258: -- Validate dates for the subconfig association
4259: IF (trunc(nvl(p_x_subconfig_rec.active_start_date, G_SYSDATE)) < G_TRUNC_DATE)

Line 4336: RAISE FND_API.G_EXC_ERROR;

4332:
4333: -- Check Error Message stack.
4334: l_msg_count := FND_MSG_PUB.count_msg;
4335: IF l_msg_count > 0 THEN
4336: RAISE FND_API.G_EXC_ERROR;
4337: END IF;
4338:
4339: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
4340: THEN

Line 4481: RAISE FND_API.G_EXC_ERROR;

4477: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4478: false
4479: );
4480: END IF;
4481: RAISE FND_API.G_EXC_ERROR;
4482: END IF;
4483:
4484: -- Validate dates for the subconfig association
4485: OPEN get_subconfig_dates(p_x_subconfig_rec.mc_config_relation_id);

Line 4586: RAISE FND_API.G_EXC_ERROR;

4582:
4583: -- Check Error Message stack.
4584: l_msg_count := FND_MSG_PUB.count_msg;
4585: IF l_msg_count > 0 THEN
4586: RAISE FND_API.G_EXC_ERROR;
4587: END IF;
4588:
4589: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
4590: THEN

Line 4753: RAISE FND_API.G_EXC_ERROR;

4749:
4750: -- Check Error Message stack.
4751: l_msg_count := FND_MSG_PUB.count_msg;
4752: IF l_msg_count > 0 THEN
4753: RAISE FND_API.G_EXC_ERROR;
4754: END IF;
4755:
4756: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
4757: THEN

Line 4788: RAISE FND_API.G_EXC_ERROR;

4784: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4785: false
4786: );
4787: END IF;
4788: RAISE FND_API.G_EXC_ERROR;
4789: END IF;
4790: CLOSE check_leaf_node;
4791:
4792: -- anraj changed for fixing the bug # 3696668

Line 4828: RAISE FND_API.G_EXC_ERROR;

4824: END IF;
4825: -- Check Error Message stack.
4826: l_msg_count := FND_MSG_PUB.count_msg;
4827: IF l_msg_count > 0 THEN
4828: RAISE FND_API.G_EXC_ERROR;
4829: END IF;
4830:
4831: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
4832: THEN