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 2168: RAISE FND_API.G_EXC_ERROR;

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

Line 2178: RAISE FND_API.G_EXC_ERROR;

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

Line 2219: RAISE FND_API.G_EXC_ERROR;

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

Line 2235: p_init_msg_list => FND_API.G_FALSE,

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

Line 2236: p_commit => FND_API.G_FALSE,

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

Line 2237: p_validate_only => FND_API.G_FALSE,

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

Line 2238: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

Line 2261: RAISE FND_API.G_EXC_ERROR;

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

Line 2265: IF FND_API.TO_BOOLEAN (p_commit)

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

Line 2275: p_encoded => FND_API.G_FALSE

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

Line 2279: WHEN FND_API.G_EXC_ERROR THEN

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

Line 2280: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2286: p_encoded => FND_API.G_FALSE

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

Line 2289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2296: p_encoded => FND_API.G_FALSE

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

Line 2300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2315: p_encoded => FND_API.G_FALSE

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

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

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

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

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

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

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

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

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

Line 2372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2376: IF FND_API.TO_BOOLEAN(p_init_msg_list)

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

Line 2382: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2414: RAISE FND_API.G_EXC_ERROR;

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

Line 2505: RAISE FND_API.G_EXC_ERROR;

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

Line 2538: RAISE FND_API.G_EXC_ERROR;

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

Line 2542: IF FND_API.TO_BOOLEAN (p_commit)

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

Line 2552: p_encoded => FND_API.G_FALSE

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

Line 2556: WHEN FND_API.G_EXC_ERROR THEN

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

Line 2557: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2563: p_encoded => FND_API.G_FALSE

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

Line 2566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2573: p_encoded => FND_API.G_FALSE

2569: FND_MSG_PUB.count_and_get
2570: (
2571: p_count => x_msg_count,
2572: p_data => x_msg_data,
2573: p_encoded => FND_API.G_FALSE
2574: );
2575:
2576: WHEN OTHERS THEN
2577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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: END Associate_Item_Group;
2596:

Line 2631: RAISE FND_API.G_EXC_ERROR;

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

Line 2646: RAISE FND_API.G_EXC_ERROR;

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

Line 2770: RAISE FND_API.G_EXC_ERROR;

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

Line 2864: RAISE FND_API.G_EXC_ERROR;

2860: false
2861: );
2862: END IF;
2863: CLOSE check_topnode_exists;
2864: RAISE FND_API.G_EXC_ERROR;
2865: END IF;
2866: CLOSE check_topnode_exists;
2867: END IF;
2868:

Line 3309: RAISE FND_API.G_EXC_ERROR;

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

Line 3324: RAISE FND_API.G_EXC_ERROR;

3320: false
3321: );
3322: END IF;
3323: CLOSE check_counter_exists;
3324: RAISE FND_API.G_EXC_ERROR;
3325: END IF;
3326: CLOSE check_counter_exists;
3327:
3328: END Validate_Counter_Exists;

Line 3503: RAISE FND_API.G_EXC_ERROR;

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

Line 3518: RAISE FND_API.G_EXC_ERROR;

3514: false
3515: );
3516: END IF;
3517: CLOSE check_submc_exists;
3518: RAISE FND_API.G_EXC_ERROR;
3519: END IF;
3520: CLOSE check_submc_exists;
3521:
3522: END Validate_Subconfig_Exists;

Line 3559: RAISE FND_API.G_EXC_ERROR;

3555: true
3556: );
3557: END IF;
3558: CLOSE check_priority_dup_exists;
3559: RAISE FND_API.G_EXC_ERROR;
3560: END IF;
3561:
3562: END Validate_priority;
3563:

Line 3687: RAISE FND_API.G_EXC_ERROR;

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

Line 3708: RAISE FND_API.G_EXC_ERROR;

3704: false
3705: );
3706: END IF;
3707: CLOSE get_mc_status;
3708: RAISE FND_API.G_EXC_ERROR;
3709: END IF;
3710: CLOSE get_mc_status;
3711: END IF;
3712:

Line 3863: RAISE FND_API.G_EXC_ERROR;

3859:
3860: -- Check Error Message stack.
3861: l_msg_count := FND_MSG_PUB.count_msg;
3862: IF l_msg_count > 0 THEN
3863: RAISE FND_API.G_EXC_ERROR;
3864: END IF;
3865:
3866: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3867: THEN

Line 4002: RAISE FND_API.G_EXC_ERROR;

3998:
3999: -- Check Error Message stack.
4000: l_msg_count := FND_MSG_PUB.count_msg;
4001: IF l_msg_count > 0 THEN
4002: RAISE FND_API.G_EXC_ERROR;
4003: END IF;
4004:
4005: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
4006: THEN

Line 4184: RAISE FND_API.G_EXC_ERROR;

4180: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4181: false
4182: );
4183: END IF;
4184: RAISE FND_API.G_EXC_ERROR;
4185: END IF;
4186: CLOSE check_root_node;
4187:
4188: OPEN check_leaf_node;

Line 4203: RAISE FND_API.G_EXC_ERROR;

4199: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4200: false
4201: );
4202: END IF;
4203: RAISE FND_API.G_EXC_ERROR;
4204: END IF;
4205: CLOSE check_leaf_node;
4206:
4207: -- Validate the MC with mc_header_id = p_x_subconfig_rec.mc_header_id is complete/draft/approval_rejected

Line 4222: RAISE FND_API.G_EXC_ERROR;

4218: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4219: false
4220: );
4221: END IF;
4222: RAISE FND_API.G_EXC_ERROR;
4223: END IF;
4224:
4225: -- Validate whether the subconfiguration is not already associated with the MC node
4226: OPEN check_submc_exists;

Line 4244: RAISE FND_API.G_EXC_ERROR;

4240: );
4241: END IF;
4242:
4243: CLOSE check_submc_exists;
4244: RAISE FND_API.G_EXC_ERROR;
4245: END IF;
4246: CLOSE check_submc_exists;
4247:
4248: -- anraj changed for fixing the bug # 3696668

Line 4281: RAISE FND_API.G_EXC_ERROR;

4277:
4278: -- Check Error Message stack.
4279: l_msg_count := FND_MSG_PUB.count_msg;
4280: IF l_msg_count > 0 THEN
4281: RAISE FND_API.G_EXC_ERROR;
4282: END IF;
4283:
4284: -- Validate dates for the subconfig association
4285: IF (trunc(nvl(p_x_subconfig_rec.active_start_date, G_SYSDATE)) < G_TRUNC_DATE)

Line 4362: RAISE FND_API.G_EXC_ERROR;

4358:
4359: -- Check Error Message stack.
4360: l_msg_count := FND_MSG_PUB.count_msg;
4361: IF l_msg_count > 0 THEN
4362: RAISE FND_API.G_EXC_ERROR;
4363: END IF;
4364:
4365: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
4366: THEN

Line 4507: RAISE FND_API.G_EXC_ERROR;

4503: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4504: false
4505: );
4506: END IF;
4507: RAISE FND_API.G_EXC_ERROR;
4508: END IF;
4509:
4510: -- Validate dates for the subconfig association
4511: OPEN get_subconfig_dates(p_x_subconfig_rec.mc_config_relation_id);

Line 4612: RAISE FND_API.G_EXC_ERROR;

4608:
4609: -- Check Error Message stack.
4610: l_msg_count := FND_MSG_PUB.count_msg;
4611: IF l_msg_count > 0 THEN
4612: RAISE FND_API.G_EXC_ERROR;
4613: END IF;
4614:
4615: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
4616: THEN

Line 4779: RAISE FND_API.G_EXC_ERROR;

4775:
4776: -- Check Error Message stack.
4777: l_msg_count := FND_MSG_PUB.count_msg;
4778: IF l_msg_count > 0 THEN
4779: RAISE FND_API.G_EXC_ERROR;
4780: END IF;
4781:
4782: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
4783: THEN

Line 4814: RAISE FND_API.G_EXC_ERROR;

4810: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4811: false
4812: );
4813: END IF;
4814: RAISE FND_API.G_EXC_ERROR;
4815: END IF;
4816: CLOSE check_leaf_node;
4817:
4818: -- anraj changed for fixing the bug # 3696668

Line 4854: RAISE FND_API.G_EXC_ERROR;

4850: END IF;
4851: -- Check Error Message stack.
4852: l_msg_count := FND_MSG_PUB.count_msg;
4853: IF l_msg_count > 0 THEN
4854: RAISE FND_API.G_EXC_ERROR;
4855: END IF;
4856:
4857: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
4858: THEN