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.AMW_RISK_PVT dependencies on FND_API

Line 74: RAISE FND_API.G_EXC_ERROR;

70: IF p_risk_rec.approval_status ='P' THEN
71: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_INVALID_STATUS',
72: p_token_name => 'OBJ_TYPE',
73: p_token_value => G_OBJ_TYPE);
74: RAISE FND_API.G_EXC_ERROR;
75: ELSIF p_risk_rec.approval_status ='R' THEN
76: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_INVALID_STATUS',
77: p_token_name => 'OBJ_TYPE',
78: p_token_value => G_OBJ_TYPE);

Line 79: RAISE FND_API.G_EXC_ERROR;

75: ELSIF p_risk_rec.approval_status ='R' THEN
76: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_INVALID_STATUS',
77: p_token_name => 'OBJ_TYPE',
78: p_token_value => G_OBJ_TYPE);
79: RAISE FND_API.G_EXC_ERROR;
80: ELSIF p_risk_rec.approval_status IS NOT NULL AND p_risk_rec.approval_status <> 'A' AND p_risk_rec.approval_status <> 'D' THEN
81: -- if it's null, the default will be 'D' , other pass-in unwanted data will be Invalid
82: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_INVALID_STATUS',
83: p_token_name => 'OBJ_TYPE',

Line 85: RAISE FND_API.G_EXC_ERROR;

81: -- if it's null, the default will be 'D' , other pass-in unwanted data will be Invalid
82: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_INVALID_STATUS',
83: p_token_name => 'OBJ_TYPE',
84: p_token_value => G_OBJ_TYPE);
85: RAISE FND_API.G_EXC_ERROR;
86: END IF;
87:
88:
89: l_risk_id := NULL;

Line 112: RAISE FND_API.G_EXC_ERROR;

108: IF x_return_status<>G_RET_STS_SUCCESS THEN
109: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
110: p_token_name => 'OBJ_TYPE',
111: p_token_value => G_OBJ_TYPE);
112: RAISE FND_API.G_EXC_ERROR;
113: END IF;
114:
115: ELSE
116: l_dummy_risk_rec := p_risk_rec;

Line 128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

124: -- no corresponding risk_id in AMW_RISKS_B is wrong
125: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNEXPECT_ERROR',
126: p_token_name => 'OBJ_TYPE',
127: p_token_value => G_OBJ_TYPE);
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129: ELSIF l_dummy = 1 THEN
130: -- has only one record for risk_id in AMW_RISKS_B with pass-in name
131: OPEN c_approval_status(l_risk_id);
132: FETCH c_approval_status INTO l_approval_status;

Line 140: RAISE FND_API.G_EXC_ERROR;

136: -- this record is Pending Approval, cannot do G_OP_UPDATE or G_OP_REVISE
137: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_PENDING_CHANGE_ERROR',
138: p_token_name => 'OBJ_TYPE',
139: p_token_value => G_OBJ_TYPE);
140: RAISE FND_API.G_EXC_ERROR;
141: ELSIF l_approval_status.approval_status='D' THEN
142: Operate_Risk(
143: p_operate_mode => G_OP_UPDATE,
144: p_api_version_number => p_api_version_number,

Line 158: RAISE FND_API.G_EXC_ERROR;

154: IF x_return_status<>G_RET_STS_SUCCESS THEN
155: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
156: p_token_name => 'OBJ_TYPE',
157: p_token_value => G_OBJ_TYPE);
158: RAISE FND_API.G_EXC_ERROR;
159: END IF;
160:
161: ELSIF l_approval_status.approval_status='A' OR l_approval_status.approval_status='R' THEN
162: Operate_Risk(

Line 178: RAISE FND_API.G_EXC_ERROR;

174: IF x_return_status<>G_RET_STS_SUCCESS THEN
175: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
176: p_token_name => 'OBJ_TYPE',
177: p_token_value => G_OBJ_TYPE);
178: RAISE FND_API.G_EXC_ERROR;
179: END IF;
180:
181: END IF; -- end of if:l_approval_status.approval_status
182: ELSE

Line 200: RAISE FND_API.G_EXC_ERROR;

196: IF x_return_status<>G_RET_STS_SUCCESS THEN
197: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
198: p_token_name => 'OBJ_TYPE',
199: p_token_value => G_OBJ_TYPE);
200: RAISE FND_API.G_EXC_ERROR;
201: END IF;
202:
203: END IF; -- end of if:l_dummy
204:

Line 216: WHEN FND_API.G_EXC_ERROR THEN

212: p_data => x_msg_data);
213:
214: EXCEPTION
215:
216: WHEN FND_API.G_EXC_ERROR THEN
217:
218: x_return_status := G_RET_STS_ERROR;
219: -- Standard call to get message count and if count=1, get the message
220: FND_MSG_PUB.Count_And_Get (

Line 225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

221: p_encoded => G_FALSE,
222: p_count => x_msg_count,
223: p_data => x_msg_data);
224:
225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
226:
227: x_return_status := G_RET_STS_UNEXP_ERROR;
228: -- Standard call to get message count and if count=1, get the message
229: FND_MSG_PUB.Count_And_Get (

Line 291: IF FND_API.to_Boolean( p_init_msg_list )

287: WHERE risk_id = l_risk_id AND approval_status='D' AND latest_revision_flag='Y';
288:
289: BEGIN
290: -- Initialize message list if p_init_msg_list is set to TRUE.
291: IF FND_API.to_Boolean( p_init_msg_list )
292: THEN
293: FND_MSG_PUB.initialize;
294: END IF;
295:

Line 330: RAISE FND_API.G_EXC_ERROR;

326: IF x_return_status<>G_RET_STS_SUCCESS THEN
327: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
328: p_token_name => 'OBJ_TYPE',
329: p_token_value => G_OBJ_TYPE);
330: RAISE FND_API.G_EXC_ERROR;
331: END IF;
332:
333: ELSIF p_operate_mode = G_OP_UPDATE THEN
334: l_dummy_risk_rec := p_risk_rec;

Line 365: RAISE FND_API.G_EXC_ERROR;

361: IF x_return_status<>G_RET_STS_SUCCESS THEN
362: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
363: p_token_name => 'OBJ_TYPE',
364: p_token_value => G_OBJ_TYPE);
365: RAISE FND_API.G_EXC_ERROR;
366: END IF;
367:
368: ELSIF p_operate_mode = G_OP_REVISE THEN
369: l_risk_rev_id := NULL;

Line 406: RAISE FND_API.G_EXC_ERROR;

402: IF x_return_status<>G_RET_STS_SUCCESS THEN
403: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
404: p_token_name => 'OBJ_TYPE',
405: p_token_value => G_OBJ_TYPE);
406: RAISE FND_API.G_EXC_ERROR;
407: END IF;
408:
409: ELSE
410: l_dummy_risk_rec := p_risk_rec;

Line 430: RAISE FND_API.G_EXC_ERROR;

426: IF x_return_status<>G_RET_STS_SUCCESS THEN
427: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
428: p_token_name => 'OBJ_TYPE',
429: p_token_value => G_OBJ_TYPE);
430: RAISE FND_API.G_EXC_ERROR;
431: END IF;
432:
433: END IF;
434: ELSIF p_operate_mode = G_OP_DELETE THEN

Line 451: RAISE FND_API.G_EXC_ERROR;

447: IF x_return_status<>G_RET_STS_SUCCESS THEN
448: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
449: p_token_name => 'OBJ_TYPE',
450: p_token_value => G_OBJ_TYPE);
451: RAISE FND_API.G_EXC_ERROR;
452: END IF;
453:
454: ELSE
455: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNEXPECT_ERROR',

Line 458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

454: ELSE
455: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNEXPECT_ERROR',
456: p_token_name => 'OBJ_TYPE',
457: p_token_value => G_OBJ_TYPE);
458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
459: END IF;
460:
461: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
462:

Line 470: WHEN FND_API.G_EXC_ERROR THEN

466: p_data => x_msg_data);
467:
468: EXCEPTION
469:
470: WHEN FND_API.G_EXC_ERROR THEN
471: x_return_status := G_RET_STS_ERROR;
472: -- Standard call to get message count and if count=1, get the message
473: FND_MSG_PUB.Count_And_Get (
474: p_encoded => G_FALSE,

Line 479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

475: p_count => x_msg_count,
476: p_data => x_msg_data
477: );
478:
479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
480: x_return_status := G_RET_STS_UNEXP_ERROR;
481: -- Standard call to get message count and if count=1, get the message
482: FND_MSG_PUB.Count_And_Get (
483: p_encoded => G_FALSE,

Line 562: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

558: -- Standard Start of API savepoint
559: SAVEPOINT CREATE_Risk_PVT;
560:
561: -- Standard call to check for call compatibility.
562: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
563: p_api_version_number,
564: l_api_name,
565: G_PKG_NAME)
566: THEN

Line 567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

563: p_api_version_number,
564: l_api_name,
565: G_PKG_NAME)
566: THEN
567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
568: END IF;
569:
570: -- Initialize message list if p_init_msg_list is set to TRUE.
571: IF FND_API.to_Boolean( p_init_msg_list )

Line 571: IF FND_API.to_Boolean( p_init_msg_list )

567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
568: END IF;
569:
570: -- Initialize message list if p_init_msg_list is set to TRUE.
571: IF FND_API.to_Boolean( p_init_msg_list )
572: THEN
573: FND_MSG_PUB.initialize;
574: END IF;
575:

Line 582: IF p_risk_rec.RISK_REV_ID IS NULL OR p_risk_rec.RISK_REV_ID = FND_API.g_miss_num THEN

578: AMW_UTILITY_PVT.debug_message('p_operate_mode: ' || p_operate_mode);
579: -- Initialize API return status to SUCCESS
580: x_return_status := G_RET_STS_SUCCESS;
581:
582: IF p_risk_rec.RISK_REV_ID IS NULL OR p_risk_rec.RISK_REV_ID = FND_API.g_miss_num THEN
583: LOOP
584: l_dummy := NULL;
585: OPEN c_rev_id;
586: FETCH c_rev_id INTO l_RISK_REV_ID;

Line 598: IF p_risk_rec.RISK_ID IS NULL OR p_risk_rec.RISK_ID = FND_API.g_miss_num THEN

594: ELSE
595: l_risk_rev_id := p_risk_rec.risk_rev_id;
596: END IF;
597:
598: IF p_risk_rec.RISK_ID IS NULL OR p_risk_rec.RISK_ID = FND_API.g_miss_num THEN
599: LOOP
600: l_dummy := NULL;
601: OPEN c_id;
602: FETCH c_id INTO l_RISK_ID;

Line 624: RAISE FND_API.G_EXC_ERROR;

620:
621:
622: IF FND_GLOBAL.User_Id IS NULL THEN
623: AMW_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
624: RAISE FND_API.G_EXC_ERROR;
625: END IF;
626:
627: IF (P_validation_level >= G_VALID_LEVEL_FULL) THEN
628: AMW_UTILITY_PVT.debug_message('Private API: Validate_Risk');

Line 647: RAISE FND_API.G_EXC_ERROR;

643: IF x_return_status<>G_RET_STS_SUCCESS THEN
644: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
645: p_token_name => 'OBJ_TYPE',
646: p_token_value => G_OBJ_TYPE);
647: RAISE FND_API.G_EXC_ERROR;
648: END IF;
649:
650:
651: AMW_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');

Line 702: RAISE FND_API.G_EXC_ERROR;

698: IF x_return_status <> G_RET_STS_SUCCESS THEN
699: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
700: p_token_name => 'OBJ_TYPE',
701: p_token_value => G_OBJ_TYPE);
702: RAISE FND_API.G_EXC_ERROR;
703: END IF;
704:
705: -- Standard check for p_commit
706: IF FND_API.to_Boolean( p_commit )

Line 706: IF FND_API.to_Boolean( p_commit )

702: RAISE FND_API.G_EXC_ERROR;
703: END IF;
704:
705: -- Standard check for p_commit
706: IF FND_API.to_Boolean( p_commit )
707: THEN
708: COMMIT WORK;
709: END IF;
710:

Line 724: WHEN FND_API.G_EXC_ERROR THEN

720: WHEN AMW_UTILITY_PVT.resource_locked THEN
721: x_return_status := G_RET_STS_ERROR;
722: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
723:
724: WHEN FND_API.G_EXC_ERROR THEN
725: ROLLBACK TO CREATE_Risk_PVT;
726: x_return_status := G_RET_STS_ERROR;
727: -- Standard call to get message count and if count=1, get the message
728: FND_MSG_PUB.Count_And_Get (

Line 733: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

729: p_encoded => G_FALSE,
730: p_count => x_msg_count,
731: p_data => x_msg_data);
732:
733: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
734: ROLLBACK TO CREATE_Risk_PVT;
735: x_return_status := G_RET_STS_UNEXP_ERROR;
736: -- Standard call to get message count and if count=1, get the message
737: FND_MSG_PUB.Count_And_Get (

Line 803: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

799: -- Standard Start of API savepoint
800: SAVEPOINT UPDATE_Risk_PVT;
801:
802: -- Standard call to check for call compatibility.
803: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
804: p_api_version_number,
805: l_api_name,
806: G_PKG_NAME)
807: THEN

Line 808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

804: p_api_version_number,
805: l_api_name,
806: G_PKG_NAME)
807: THEN
808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809: END IF;
810:
811: -- Initialize message list if p_init_msg_list is set to TRUE.
812: IF FND_API.to_Boolean( p_init_msg_list )

Line 812: IF FND_API.to_Boolean( p_init_msg_list )

808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809: END IF;
810:
811: -- Initialize message list if p_init_msg_list is set to TRUE.
812: IF FND_API.to_Boolean( p_init_msg_list )
813: THEN
814: FND_MSG_PUB.initialize;
815: END IF;
816:

Line 826: IF p_risk_rec.risk_rev_id IS NULL OR p_risk_rec.risk_rev_id = FND_API.g_miss_num THEN

822:
823: AMW_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
824:
825: -- if no specified target risk_rev_id, find if from risk_id
826: IF p_risk_rec.risk_rev_id IS NULL OR p_risk_rec.risk_rev_id = FND_API.g_miss_num THEN
827: l_risk_rev_id := NULL;
828: OPEN c_target_revision(p_risk_rec.risk_id);
829: FETCH c_target_revision INTO l_risk_rev_id;
830: CLOSE c_target_revision;

Line 834: RAISE FND_API.G_EXC_ERROR;

830: CLOSE c_target_revision;
831: IF l_risk_rev_id IS NULL THEN
832: x_return_status := G_RET_STS_ERROR;
833: AMW_UTILITY_PVT.debug_message('l_risk_rev_id in Update_Risk is NULL');
834: RAISE FND_API.G_EXC_ERROR;
835: END IF;
836: ELSE
837: l_risk_rev_id := p_risk_rec.risk_rev_id;
838: END IF; -- end of if:p_risk_rec.risk_rev_id

Line 869: RAISE FND_API.G_EXC_ERROR;

865: IF x_return_status<>G_RET_STS_SUCCESS THEN
866: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
867: p_token_name => 'OBJ_TYPE',
868: p_token_value => G_OBJ_TYPE);
869: RAISE FND_API.G_EXC_ERROR;
870: END IF;
871:
872: -- Invoke table handler(AMW_RISKS_PKG.Update_Row)
873: AMW_RISKS_PKG.Update_Row(

Line 914: IF FND_API.to_Boolean( p_commit )

910: X_MATERIAL => l_dummy_risk_rec.material,
911: X_CLASSIFICATION => l_dummy_risk_rec.classification);
912:
913: -- Standard check for p_commit
914: IF FND_API.to_Boolean( p_commit )
915: THEN
916: COMMIT WORK;
917: END IF;
918:

Line 933: WHEN FND_API.G_EXC_ERROR THEN

929: WHEN AMW_UTILITY_PVT.resource_locked THEN
930: x_return_status := G_RET_STS_ERROR;
931: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
932:
933: WHEN FND_API.G_EXC_ERROR THEN
934: ROLLBACK TO UPDATE_Risk_PVT;
935: x_return_status := G_RET_STS_ERROR;
936: -- Standard call to get message count and if count=1, get the message
937: FND_MSG_PUB.Count_And_Get (

Line 942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

938: p_encoded => G_FALSE,
939: p_count => x_msg_count,
940: p_data => x_msg_data);
941:
942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
943: ROLLBACK TO UPDATE_Risk_PVT;
944: x_return_status := G_RET_STS_UNEXP_ERROR;
945: -- Standard call to get message count and if count=1, get the message
946: FND_MSG_PUB.Count_And_Get (

Line 996: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

992: -- Standard Start of API savepoint
993: SAVEPOINT DELETE_Risk_PVT;
994:
995: -- Standard call to check for call compatibility.
996: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
997: p_api_version_number,
998: l_api_name,
999: G_PKG_NAME)
1000: THEN

Line 1001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

997: p_api_version_number,
998: l_api_name,
999: G_PKG_NAME)
1000: THEN
1001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1002: END IF;
1003:
1004: -- Initialize message list if p_init_msg_list is set to TRUE.
1005: IF FND_API.to_Boolean( p_init_msg_list )

Line 1005: IF FND_API.to_Boolean( p_init_msg_list )

1001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1002: END IF;
1003:
1004: -- Initialize message list if p_init_msg_list is set to TRUE.
1005: IF FND_API.to_Boolean( p_init_msg_list )
1006: THEN
1007: FND_MSG_PUB.initialize;
1008: END IF;
1009:

Line 1024: IF FND_API.to_Boolean( p_commit )

1020: x_RISK_REV_ID => p_RISK_REV_ID);
1021:
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 1043: WHEN FND_API.G_EXC_ERROR THEN

1039: WHEN AMW_UTILITY_PVT.resource_locked THEN
1040: x_return_status := G_RET_STS_ERROR;
1041: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1042:
1043: WHEN FND_API.G_EXC_ERROR THEN
1044: ROLLBACK TO DELETE_Risk_PVT;
1045: x_return_status := G_RET_STS_ERROR;
1046: -- Standard call to get message count and if count=1, get the message
1047: FND_MSG_PUB.Count_And_Get (

Line 1052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1048: p_encoded => G_FALSE,
1049: p_count => x_msg_count,
1050: p_data => x_msg_data);
1051:
1052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1053: ROLLBACK TO DELETE_Risk_PVT;
1054: x_return_status := G_RET_STS_UNEXP_ERROR;
1055: -- Standard call to get message count and if count=1, get the message
1056: FND_MSG_PUB.Count_And_Get (

Line 1129: IF FND_API.to_Boolean( p_init_msg_list )

1125: -- Standard Start of API savepoint
1126: SAVEPOINT REVISE_Risk_PVT;
1127:
1128: -- Initialize message list if p_init_msg_list is set to TRUE.
1129: IF FND_API.to_Boolean( p_init_msg_list )
1130: THEN
1131: FND_MSG_PUB.initialize;
1132: END IF;
1133:

Line 1181: RAISE FND_API.G_EXC_ERROR;

1177: IF x_return_status <> G_RET_STS_SUCCESS THEN
1178: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
1179: p_token_name => 'OBJ_TYPE',
1180: p_token_value => G_OBJ_TYPE);
1181: RAISE FND_API.G_EXC_ERROR;
1182: END IF;
1183:
1184:
1185: x_risk_id := p_risk_rec.risk_id;

Line 1225: RAISE FND_API.G_EXC_ERROR;

1221: IF x_return_status <> G_RET_STS_SUCCESS THEN
1222: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
1223: p_token_name => 'OBJ_TYPE',
1224: p_token_value => G_OBJ_TYPE);
1225: RAISE FND_API.G_EXC_ERROR;
1226: END IF;
1227:
1228: -- Standard check for p_commit
1229: IF FND_API.to_Boolean( p_commit )

Line 1229: IF FND_API.to_Boolean( p_commit )

1225: RAISE FND_API.G_EXC_ERROR;
1226: END IF;
1227:
1228: -- Standard check for p_commit
1229: IF FND_API.to_Boolean( p_commit )
1230: THEN
1231: COMMIT WORK;
1232: END IF;
1233:

Line 1247: WHEN FND_API.G_EXC_ERROR THEN

1243: WHEN AMW_UTILITY_PVT.resource_locked THEN
1244: x_return_status := G_RET_STS_ERROR;
1245: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1246:
1247: WHEN FND_API.G_EXC_ERROR THEN
1248: ROLLBACK TO REVISE_Risk_PVT;
1249: x_return_status := G_RET_STS_ERROR;
1250: -- Standard call to get message count and if count=1, get the message
1251: FND_MSG_PUB.Count_And_Get (

Line 1256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1252: p_encoded => G_FALSE,
1253: p_count => x_msg_count,
1254: p_data => x_msg_data);
1255:
1256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1257: ROLLBACK TO REVISE_Risk_PVT;
1258: x_return_status := G_RET_STS_UNEXP_ERROR;
1259: -- Standard call to get message count and if count=1, get the message
1260: FND_MSG_PUB.Count_And_Get (

Line 1329: -- FND_API.G_MISS_XXX v.s. NULL has been changed to:

1325: -- check the requireness of the items which have been marked
1326: -- as NOT NULL in table
1327: -- Note
1328: -- since the standard default with
1329: -- FND_API.G_MISS_XXX v.s. NULL has been changed to:
1330: -- if user want to update to Null, pass in G_MISS_XXX
1331: -- else if user want to update to some value, pass in value
1332: -- else if user doesn't want to update, pass in NULL.
1333: -- Reference

Line 1353: RAISE FND_API.G_EXC_ERROR;

1349: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1350: p_token_name => 'ITEM',
1351: p_token_value => 'risk_impact');
1352: x_return_status := G_RET_STS_ERROR;
1353: RAISE FND_API.G_EXC_ERROR;
1354: END IF;
1355:
1356: IF p_risk_rec.likelihood IS NULL THEN
1357: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',

Line 1361: RAISE FND_API.G_EXC_ERROR;

1357: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1358: p_token_name => 'ITEM',
1359: p_token_value => 'likelihood');
1360: x_return_status := G_RET_STS_ERROR;
1361: RAISE FND_API.G_EXC_ERROR;
1362: END IF;
1363:
1364: IF p_risk_rec.risk_rev_num IS NULL THEN
1365: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',

Line 1369: RAISE FND_API.G_EXC_ERROR;

1365: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1366: p_token_name => 'ITEM',
1367: p_token_value => 'risk_rev_num');
1368: x_return_status := G_RET_STS_ERROR;
1369: RAISE FND_API.G_EXC_ERROR;
1370: END IF;
1371:
1372: IF p_risk_rec.latest_revision_flag IS NULL THEN
1373: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',

Line 1377: RAISE FND_API.G_EXC_ERROR;

1373: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1374: p_token_name => 'ITEM',
1375: p_token_value => 'latest_revision_flag');
1376: x_return_status := G_RET_STS_ERROR;
1377: RAISE FND_API.G_EXC_ERROR;
1378: END IF;
1379:
1380: IF p_risk_rec.curr_approved_flag IS NULL THEN
1381: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',

Line 1385: RAISE FND_API.G_EXC_ERROR;

1381: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1382: p_token_name => 'ITEM',
1383: p_token_value => 'curr_approved_flag');
1384: x_return_status := G_RET_STS_ERROR;
1385: RAISE FND_API.G_EXC_ERROR;
1386: END IF;
1387:
1388: ELSE
1389: IF p_risk_rec.risk_rev_id = FND_API.g_miss_num THEN

Line 1389: IF p_risk_rec.risk_rev_id = FND_API.g_miss_num THEN

1385: RAISE FND_API.G_EXC_ERROR;
1386: END IF;
1387:
1388: ELSE
1389: IF p_risk_rec.risk_rev_id = FND_API.g_miss_num THEN
1390: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1391: p_token_name => 'ITEM',
1392: p_token_value => 'risk_rev_id');
1393: x_return_status := G_RET_STS_ERROR;

Line 1394: RAISE FND_API.G_EXC_ERROR;

1390: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1391: p_token_name => 'ITEM',
1392: p_token_value => 'risk_rev_id');
1393: x_return_status := G_RET_STS_ERROR;
1394: RAISE FND_API.G_EXC_ERROR;
1395: END IF;
1396:
1397: IF p_risk_rec.risk_id = FND_API.g_miss_num THEN
1398: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',

Line 1397: IF p_risk_rec.risk_id = FND_API.g_miss_num THEN

1393: x_return_status := G_RET_STS_ERROR;
1394: RAISE FND_API.G_EXC_ERROR;
1395: END IF;
1396:
1397: IF p_risk_rec.risk_id = FND_API.g_miss_num THEN
1398: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1399: p_token_name => 'ITEM',
1400: p_token_value => 'risk_id');
1401: x_return_status := G_RET_STS_ERROR;

Line 1402: RAISE FND_API.G_EXC_ERROR;

1398: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1399: p_token_name => 'ITEM',
1400: p_token_value => 'risk_id');
1401: x_return_status := G_RET_STS_ERROR;
1402: RAISE FND_API.G_EXC_ERROR;
1403: END IF;
1404:
1405: IF p_risk_rec.risk_impact = FND_API.g_miss_char THEN
1406: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',

Line 1405: IF p_risk_rec.risk_impact = FND_API.g_miss_char THEN

1401: x_return_status := G_RET_STS_ERROR;
1402: RAISE FND_API.G_EXC_ERROR;
1403: END IF;
1404:
1405: IF p_risk_rec.risk_impact = FND_API.g_miss_char THEN
1406: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1407: p_token_name => 'ITEM',
1408: p_token_value => 'risk_impact');
1409: x_return_status := G_RET_STS_ERROR;

Line 1410: RAISE FND_API.G_EXC_ERROR;

1406: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1407: p_token_name => 'ITEM',
1408: p_token_value => 'risk_impact');
1409: x_return_status := G_RET_STS_ERROR;
1410: RAISE FND_API.G_EXC_ERROR;
1411: END IF;
1412:
1413: IF p_risk_rec.likelihood = FND_API.g_miss_char THEN
1414: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',

Line 1413: IF p_risk_rec.likelihood = FND_API.g_miss_char THEN

1409: x_return_status := G_RET_STS_ERROR;
1410: RAISE FND_API.G_EXC_ERROR;
1411: END IF;
1412:
1413: IF p_risk_rec.likelihood = FND_API.g_miss_char THEN
1414: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1415: p_token_name => 'ITEM',
1416: p_token_value => 'likelihood');
1417: x_return_status := G_RET_STS_ERROR;

Line 1418: RAISE FND_API.G_EXC_ERROR;

1414: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1415: p_token_name => 'ITEM',
1416: p_token_value => 'likelihood');
1417: x_return_status := G_RET_STS_ERROR;
1418: RAISE FND_API.G_EXC_ERROR;
1419: END IF;
1420:
1421: IF p_risk_rec.risk_rev_num = FND_API.g_miss_num THEN
1422: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',

Line 1421: IF p_risk_rec.risk_rev_num = FND_API.g_miss_num THEN

1417: x_return_status := G_RET_STS_ERROR;
1418: RAISE FND_API.G_EXC_ERROR;
1419: END IF;
1420:
1421: IF p_risk_rec.risk_rev_num = FND_API.g_miss_num THEN
1422: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1423: p_token_name => 'ITEM',
1424: p_token_value => 'risk_rev_num');
1425: x_return_status := G_RET_STS_ERROR;

Line 1426: RAISE FND_API.G_EXC_ERROR;

1422: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1423: p_token_name => 'ITEM',
1424: p_token_value => 'risk_rev_num');
1425: x_return_status := G_RET_STS_ERROR;
1426: RAISE FND_API.G_EXC_ERROR;
1427: END IF;
1428:
1429: IF p_risk_rec.latest_revision_flag = FND_API.g_miss_char THEN
1430: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',

Line 1429: IF p_risk_rec.latest_revision_flag = FND_API.g_miss_char THEN

1425: x_return_status := G_RET_STS_ERROR;
1426: RAISE FND_API.G_EXC_ERROR;
1427: END IF;
1428:
1429: IF p_risk_rec.latest_revision_flag = FND_API.g_miss_char THEN
1430: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1431: p_token_name => 'ITEM',
1432: p_token_value => 'latest_revision_flag');
1433: x_return_status := G_RET_STS_ERROR;

Line 1434: RAISE FND_API.G_EXC_ERROR;

1430: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1431: p_token_name => 'ITEM',
1432: p_token_value => 'latest_revision_flag');
1433: x_return_status := G_RET_STS_ERROR;
1434: RAISE FND_API.G_EXC_ERROR;
1435: END IF;
1436:
1437: IF p_risk_rec.curr_approved_flag = FND_API.g_miss_char THEN
1438: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',

Line 1437: IF p_risk_rec.curr_approved_flag = FND_API.g_miss_char THEN

1433: x_return_status := G_RET_STS_ERROR;
1434: RAISE FND_API.G_EXC_ERROR;
1435: END IF;
1436:
1437: IF p_risk_rec.curr_approved_flag = FND_API.g_miss_char THEN
1438: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1439: p_token_name => 'ITEM',
1440: p_token_value => 'curr_approved_flag');
1441: x_return_status := G_RET_STS_ERROR;

Line 1442: RAISE FND_API.G_EXC_ERROR;

1438: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1439: p_token_name => 'ITEM',
1440: p_token_value => 'curr_approved_flag');
1441: x_return_status := G_RET_STS_ERROR;
1442: RAISE FND_API.G_EXC_ERROR;
1443: END IF;
1444:
1445: END IF; -- end of if:p_operate_mode
1446:

Line 1514: RAISE FND_API.G_EXC_ERROR;

1510: IF x_return_status <> G_RET_STS_SUCCESS THEN
1511: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
1512: p_token_name => 'OBJ_TYPE',
1513: p_token_value => G_OBJ_TYPE);
1514: RAISE FND_API.G_EXC_ERROR;
1515: END IF;
1516:
1517: -- Check Items Required/NOT NULL API calls
1518: check_risk_req_items(

Line 1526: RAISE FND_API.G_EXC_ERROR;

1522: IF x_return_status <> G_RET_STS_SUCCESS THEN
1523: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
1524: p_token_name => 'OBJ_TYPE',
1525: p_token_value => G_OBJ_TYPE);
1526: RAISE FND_API.G_EXC_ERROR;
1527: END IF;
1528:
1529: -- Check Items Foreign Keys API calls
1530: check_risk_FK_items(

Line 1538: RAISE FND_API.G_EXC_ERROR;

1534: IF x_return_status <> G_RET_STS_SUCCESS THEN
1535: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
1536: p_token_name => 'OBJ_TYPE',
1537: p_token_value => G_OBJ_TYPE);
1538: RAISE FND_API.G_EXC_ERROR;
1539: END IF;
1540:
1541: -- Check Items Lookups
1542: check_risk_Lookup_items(

Line 1550: RAISE FND_API.G_EXC_ERROR;

1546: IF x_return_status <> G_RET_STS_SUCCESS THEN
1547: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
1548: p_token_name => 'OBJ_TYPE',
1549: p_token_value => G_OBJ_TYPE);
1550: RAISE FND_API.G_EXC_ERROR;
1551: END IF;
1552:
1553: END Check_risk_Items;
1554:

Line 1605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1601: IF p_risk_rec.risk_rev_id IS NULL THEN
1602: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNEXPECT_ERROR',
1603: p_token_name => 'OBJ_TYPE',
1604: p_token_value => G_OBJ_TYPE);
1605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1606: END IF;
1607:
1608: -- risk_id
1609: IF p_risk_rec.risk_id IS NULL THEN

Line 1845: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1841: -- Initialize API return status to SUCCESS
1842: x_return_status := G_RET_STS_SUCCESS;
1843:
1844: -- Standard call to check for call compatibility.
1845: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1846: p_api_version_number,
1847: l_api_name,
1848: G_PKG_NAME)
1849: THEN

Line 1850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1846: p_api_version_number,
1847: l_api_name,
1848: G_PKG_NAME)
1849: THEN
1850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1851: END IF;
1852:
1853: -- Initialize message list if p_init_msg_list is set to TRUE.
1854: IF FND_API.to_Boolean( p_init_msg_list )

Line 1854: IF FND_API.to_Boolean( p_init_msg_list )

1850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1851: END IF;
1852:
1853: -- Initialize message list if p_init_msg_list is set to TRUE.
1854: IF FND_API.to_Boolean( p_init_msg_list )
1855: THEN
1856: FND_MSG_PUB.initialize;
1857: END IF;
1858:

Line 1875: RAISE FND_API.G_EXC_ERROR;

1871: p_risk_rec => l_risk_rec,
1872: x_return_status => x_return_status);
1873:
1874: IF x_return_status = G_RET_STS_ERROR THEN
1875: RAISE FND_API.G_EXC_ERROR;
1876: ELSIF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1878: END IF;
1879: END IF;

Line 1877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1873:
1874: IF x_return_status = G_RET_STS_ERROR THEN
1875: RAISE FND_API.G_EXC_ERROR;
1876: ELSIF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1878: END IF;
1879: END IF;
1880:
1881:

Line 1893: RAISE FND_API.G_EXC_ERROR;

1889: x_msg_data => x_msg_data,
1890: p_risk_rec => l_risk_rec);
1891:
1892: IF x_return_status = G_RET_STS_ERROR THEN
1893: RAISE FND_API.G_EXC_ERROR;
1894: ELSIF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1896: END IF;
1897: END IF;

Line 1895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1891:
1892: IF x_return_status = G_RET_STS_ERROR THEN
1893: RAISE FND_API.G_EXC_ERROR;
1894: ELSIF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1896: END IF;
1897: END IF;
1898:
1899: x_risk_rec := l_risk_rec;

Line 1914: WHEN FND_API.G_EXC_ERROR THEN

1910: WHEN AMW_UTILITY_PVT.resource_locked THEN
1911: x_return_status := G_RET_STS_ERROR;
1912: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1913:
1914: WHEN FND_API.G_EXC_ERROR THEN
1915: ROLLBACK TO VALIDATE_Risk_;
1916: x_return_status := G_RET_STS_ERROR;
1917: -- Standard call to get message count and if count=1, get the message
1918: FND_MSG_PUB.Count_And_Get (

Line 1923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1919: p_encoded => G_FALSE,
1920: p_count => x_msg_count,
1921: p_data => x_msg_data);
1922:
1923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1924: ROLLBACK TO VALIDATE_Risk_;
1925: x_return_status := G_RET_STS_UNEXP_ERROR;
1926: -- Standard call to get message count and if count=1, get the message
1927: FND_MSG_PUB.Count_And_Get (

Line 1974: IF FND_API.to_Boolean( p_init_msg_list )

1970: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Risk_Rec';
1971:
1972: BEGIN
1973: -- Initialize message list if p_init_msg_list is set to TRUE.
1974: IF FND_API.to_Boolean( p_init_msg_list )
1975: THEN
1976: FND_MSG_PUB.initialize;
1977: END IF;
1978:

Line 1994: RAISE FND_API.G_EXC_ERROR;

1990: IF x_return_status<>G_RET_STS_SUCCESS THEN
1991: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
1992: p_token_name => 'OBJ_TYPE',
1993: p_token_value => G_OBJ_TYPE);
1994: RAISE FND_API.G_EXC_ERROR;
1995: END IF;
1996:
1997: ELSIF p_operate_mode = G_OP_UPDATE THEN
1998: Validate_update_risk_rec(

Line 2007: RAISE FND_API.G_EXC_ERROR;

2003: IF x_return_status<>G_RET_STS_SUCCESS THEN
2004: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
2005: p_token_name => 'OBJ_TYPE',
2006: p_token_value => G_OBJ_TYPE);
2007: RAISE FND_API.G_EXC_ERROR;
2008: END IF;
2009:
2010: ELSIF p_operate_mode = G_OP_REVISE THEN
2011: Validate_revise_risk_rec(

Line 2020: RAISE FND_API.G_EXC_ERROR;

2016: IF x_return_status<>G_RET_STS_SUCCESS THEN
2017: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
2018: p_token_name => 'OBJ_TYPE',
2019: p_token_value => G_OBJ_TYPE);
2020: RAISE FND_API.G_EXC_ERROR;
2021: END IF;
2022:
2023: ELSIF p_operate_mode = G_OP_DELETE THEN
2024: Validate_delete_risk_rec(

Line 2033: RAISE FND_API.G_EXC_ERROR;

2029: IF x_return_status<>G_RET_STS_SUCCESS THEN
2030: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
2031: p_token_name => 'OBJ_TYPE',
2032: p_token_value => G_OBJ_TYPE);
2033: RAISE FND_API.G_EXC_ERROR;
2034: END IF;
2035:
2036: ELSE
2037: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNEXPECT_ERROR',

Line 2040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2036: ELSE
2037: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNEXPECT_ERROR',
2038: p_token_name => 'OBJ_TYPE',
2039: p_token_value => G_OBJ_TYPE);
2040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2041: END IF;
2042:
2043:
2044: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

Line 2094: RAISE FND_API.G_EXC_ERROR;

2090: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNIQUE_ITEM_ERROR',
2091: p_token_name => 'ITEM',
2092: p_token_value => 'risk_name');
2093: x_return_status := G_RET_STS_ERROR;
2094: RAISE FND_API.G_EXC_ERROR;
2095: END IF;
2096:
2097: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2098:

Line 2105: WHEN FND_API.G_EXC_ERROR THEN

2101: (p_count => x_msg_count,
2102: p_data => x_msg_data);
2103:
2104: EXCEPTION
2105: WHEN FND_API.G_EXC_ERROR THEN
2106:
2107: x_return_status := G_RET_STS_ERROR;
2108: -- Standard call to get message count and if count=1, get the message
2109: FND_MSG_PUB.Count_And_Get (

Line 2114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2110: p_encoded => G_FALSE,
2111: p_count => x_msg_count,
2112: p_data => x_msg_data);
2113:
2114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2115:
2116: x_return_status := G_RET_STS_UNEXP_ERROR;
2117: -- Standard call to get message count and if count=1, get the message
2118: FND_MSG_PUB.Count_And_Get (

Line 2196: RAISE FND_API.G_EXC_ERROR;

2192: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNIQUE_ITEM_ERROR',
2193: p_token_name => 'ITEM',
2194: p_token_value => 'risk_name');
2195: x_return_status := G_RET_STS_ERROR;
2196: RAISE FND_API.G_EXC_ERROR;
2197: END IF;
2198:
2199: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2200:

Line 2208: WHEN FND_API.G_EXC_ERROR THEN

2204: p_data => x_msg_data);
2205:
2206: EXCEPTION
2207:
2208: WHEN FND_API.G_EXC_ERROR THEN
2209:
2210: x_return_status := G_RET_STS_ERROR;
2211: -- Standard call to get message count and if count=1, get the message
2212: FND_MSG_PUB.Count_And_Get (

Line 2217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2213: p_encoded => G_FALSE,
2214: p_count => x_msg_count,
2215: p_data => x_msg_data);
2216:
2217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2218:
2219: x_return_status := G_RET_STS_UNEXP_ERROR;
2220: -- Standard call to get message count and if count=1, get the message
2221: FND_MSG_PUB.Count_And_Get (

Line 2288: RAISE FND_API.G_EXC_ERROR;

2284: x_return_status := G_RET_STS_ERROR;
2285: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
2286: p_token_name => 'OBJ_TYPE',
2287: p_token_value => G_OBJ_TYPE);
2288: RAISE FND_API.G_EXC_ERROR;
2289: END IF;
2290:
2291: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2292:

Line 2300: WHEN FND_API.G_EXC_ERROR THEN

2296: p_data => x_msg_data);
2297:
2298: EXCEPTION
2299:
2300: WHEN FND_API.G_EXC_ERROR THEN
2301:
2302: x_return_status := G_RET_STS_ERROR;
2303: -- Standard call to get message count and if count=1, get the message
2304: FND_MSG_PUB.Count_And_Get (

Line 2309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2305: p_encoded => G_FALSE,
2306: p_count => x_msg_count,
2307: p_data => x_msg_data);
2308:
2309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2310:
2311: x_return_status := G_RET_STS_UNEXP_ERROR;
2312: -- Standard call to get message count and if count=1, get the message
2313: FND_MSG_PUB.Count_And_Get (

Line 2374: RAISE FND_API.G_EXC_ERROR;

2370: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
2371: p_token_name => 'OBJ_TYPE',
2372: p_token_value => G_OBJ_TYPE);
2373: x_return_status := G_RET_STS_ERROR;
2374: RAISE FND_API.G_EXC_ERROR;
2375: END IF;
2376:
2377: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2378:

Line 2386: WHEN FND_API.G_EXC_ERROR THEN

2382: p_data => x_msg_data);
2383:
2384: EXCEPTION
2385:
2386: WHEN FND_API.G_EXC_ERROR THEN
2387:
2388: x_return_status := G_RET_STS_ERROR;
2389: -- Standard call to get message count and if count=1, get the message
2390: FND_MSG_PUB.Count_And_Get (

Line 2395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2391: p_encoded => G_FALSE,
2392: p_count => x_msg_count,
2393: p_data => x_msg_data);
2394:
2395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2396:
2397: x_return_status := G_RET_STS_UNEXP_ERROR;
2398: -- Standard call to get message count and if count=1, get the message
2399: FND_MSG_PUB.Count_And_Get (

Line 2453: x_return_status := FND_API.G_RET_STS_SUCCESS;

2449: )
2450: AND curr_approved_flag='Y';
2451:
2452: BEGIN
2453: x_return_status := FND_API.G_RET_STS_SUCCESS;
2454:
2455: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2456: FND_MSG_PUB.initialize;
2457: END IF;

Line 2455: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2451:
2452: BEGIN
2453: x_return_status := FND_API.G_RET_STS_SUCCESS;
2454:
2455: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2456: FND_MSG_PUB.initialize;
2457: END IF;
2458:
2459: IF G_USER_ID IS NULL THEN

Line 2461: RAISE FND_API.G_EXC_ERROR;

2457: END IF;
2458:
2459: IF G_USER_ID IS NULL THEN
2460: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
2461: RAISE FND_API.G_EXC_ERROR;
2462: END IF;
2463:
2464: -- 01.05.2005 tsho: make the date consistent for approval_date, update_date....etc
2465: l_date := sysdate;

Line 2496: WHEN FND_API.G_EXC_ERROR THEN

2492: ,last_update_login=G_LOGIN_ID
2493: where risk_rev_id=p_risk_rev_id;
2494:
2495: EXCEPTION
2496: WHEN FND_API.G_EXC_ERROR THEN
2497: ROLLBACK;
2498: x_return_status := FND_API.G_RET_STS_ERROR;
2499: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2500:

Line 2498: x_return_status := FND_API.G_RET_STS_ERROR;

2494:
2495: EXCEPTION
2496: WHEN FND_API.G_EXC_ERROR THEN
2497: ROLLBACK;
2498: x_return_status := FND_API.G_RET_STS_ERROR;
2499: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2500:
2501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2502: ROLLBACK;

Line 2499: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2495: EXCEPTION
2496: WHEN FND_API.G_EXC_ERROR THEN
2497: ROLLBACK;
2498: x_return_status := FND_API.G_RET_STS_ERROR;
2499: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2500:
2501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2502: ROLLBACK;
2503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2497: ROLLBACK;
2498: x_return_status := FND_API.G_RET_STS_ERROR;
2499: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2500:
2501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2502: ROLLBACK;
2503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2504: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2505:

Line 2503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2499: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2500:
2501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2502: ROLLBACK;
2503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2504: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2505:
2506: WHEN OTHERS THEN
2507: ROLLBACK;

Line 2504: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2500:
2501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2502: ROLLBACK;
2503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2504: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2505:
2506: WHEN OTHERS THEN
2507: ROLLBACK;
2508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2504: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2505:
2506: WHEN OTHERS THEN
2507: ROLLBACK;
2508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2509: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2510: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2511: END IF;
2512: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 2512: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2509: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2510: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2511: END IF;
2512: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2513: END Approve_Risk;
2514:
2515:
2516: -- ----------------------------------------------------------------------