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 AMW_UTILITY_PVT

Line 66: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

62: l_approval_status c_approval_status%ROWTYPE;
63:
64:
65: BEGIN
66: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
67: x_return_status := G_RET_STS_SUCCESS;
68:
69:
70: IF p_risk_rec.approval_status ='P' THEN

Line 71: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_INVALID_STATUS',

67: x_return_status := G_RET_STS_SUCCESS;
68:
69:
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

Line 76: 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);
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

Line 82: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_INVALID_STATUS',

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',
84: p_token_value => G_OBJ_TYPE);
85: RAISE FND_API.G_EXC_ERROR;
86: END IF;

Line 109: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',

105: p_risk_rec => p_risk_rec,
106: x_risk_rev_id => x_risk_rev_id,
107: x_risk_id => x_risk_id);
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;

Line 125: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNEXPECT_ERROR',

121: CLOSE c_revision_exists;
122:
123: IF l_dummy IS NULL OR l_dummy < 1 THEN
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

Line 137: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_PENDING_CHANGE_ERROR',

133: CLOSE c_approval_status;
134:
135: IF l_approval_status.approval_status='P' THEN
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

Line 155: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',

151: p_risk_rec => l_dummy_risk_rec,
152: x_risk_rev_id => x_risk_rev_id,
153: x_risk_id => x_risk_id);
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;

Line 175: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',

171: p_risk_rec => l_dummy_risk_rec,
172: x_risk_rev_id => x_risk_rev_id,
173: x_risk_id => x_risk_id);
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;

Line 197: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',

193: p_risk_rec => l_dummy_risk_rec,
194: x_risk_rev_id => x_risk_rev_id,
195: x_risk_id => x_risk_id);
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;

Line 207: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

203: END IF; -- end of if:l_dummy
204:
205: END IF; -- end of if:l_risk_id
206:
207: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
208:
209: -- Standard call to get message count and if count is 1, get message info.
210: FND_MSG_PUB.Count_And_Get(
211: p_count => x_msg_count,

Line 296: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

292: THEN
293: FND_MSG_PUB.initialize;
294: END IF;
295:
296: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
297:
298: IF p_operate_mode = G_OP_CREATE THEN
299: l_dummy_risk_rec := p_risk_rec;
300: l_dummy_risk_rec.object_version_number := 1;

Line 327: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',

323: x_risk_rev_id => x_risk_rev_id,
324: x_risk_id => x_risk_id);
325:
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;

Line 362: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',

358: x_risk_rev_id => x_risk_rev_id,
359: x_risk_id => x_risk_id);
360:
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;

Line 403: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',

399: x_risk_rev_id => x_risk_rev_id,
400: x_risk_id => x_risk_id);
401:
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;

Line 427: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',

423: x_risk_rev_id => x_risk_rev_id,
424: x_risk_id => x_risk_id);
425:
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;

Line 448: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',

444: p_risk_rev_id => p_risk_rec.risk_rev_id,
445: x_risk_id => x_risk_id);
446:
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;

Line 455: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNEXPECT_ERROR',

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',
456: p_token_name => 'OBJ_TYPE',
457: p_token_value => G_OBJ_TYPE);
458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
459: END IF;

Line 461: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

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:
463: -- Standard call to get message count and if count is 1, get message info.
464: FND_MSG_PUB.Count_And_Get
465: (p_count => x_msg_count,

Line 576: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

572: THEN
573: FND_MSG_PUB.initialize;
574: END IF;
575:
576: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
577:
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;

Line 578: AMW_UTILITY_PVT.debug_message('p_operate_mode: ' || p_operate_mode);

574: END IF;
575:
576: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
577:
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

Line 623: AMW_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

619: l_risk_rec.risk_rev_id := l_risk_rev_id;
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

Line 628: AMW_UTILITY_PVT.debug_message('Private API: Validate_Risk');

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');
629:
630: -- Invoke validation procedures
631: Validate_risk(
632: p_operate_mode => p_operate_mode,

Line 644: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',

640: x_msg_data => x_msg_data);
641: END IF;
642:
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;

Line 651: AMW_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');

647: RAISE FND_API.G_EXC_ERROR;
648: END IF;
649:
650:
651: AMW_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
652:
653: -- Invoke table handler(AMW_RISKS_PKG.Insert_Row)
654: AMW_UTILITY_PVT.debug_message( 'Private API: Calling AMW_RISKS_PKG.Insert_Row');
655: AMW_RISKS_PKG.Insert_Row(

Line 654: AMW_UTILITY_PVT.debug_message( 'Private API: Calling AMW_RISKS_PKG.Insert_Row');

650:
651: AMW_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
652:
653: -- Invoke table handler(AMW_RISKS_PKG.Insert_Row)
654: AMW_UTILITY_PVT.debug_message( 'Private API: Calling AMW_RISKS_PKG.Insert_Row');
655: AMW_RISKS_PKG.Insert_Row(
656: x_rowid => l_row_id,
657: x_name => l_dummy_risk_rec.risk_name,
658: x_description => l_dummy_risk_rec.risk_description,

Line 699: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',

695: X_MATERIAL => l_dummy_risk_rec.material,
696: X_CLASSIFICATION => l_dummy_risk_rec.classification);
697:
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;

Line 712: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

708: COMMIT WORK;
709: END IF;
710:
711:
712: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
713:
714: -- Standard call to get message count and if count is 1, get message info.
715: FND_MSG_PUB.Count_And_Get
716: (p_count => x_msg_count,

Line 720: WHEN AMW_UTILITY_PVT.resource_locked THEN

716: (p_count => x_msg_count,
717: p_data => x_msg_data);
718:
719: EXCEPTION
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

Line 722: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');

718:
719: EXCEPTION
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;

Line 817: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

813: THEN
814: FND_MSG_PUB.initialize;
815: END IF;
816:
817: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
818:
819:
820: -- Initialize API return status to SUCCESS
821: x_return_status := G_RET_STS_SUCCESS;

Line 823: AMW_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

819:
820: -- Initialize API return status to SUCCESS
821: x_return_status := G_RET_STS_SUCCESS;
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;

Line 833: AMW_UTILITY_PVT.debug_message('l_risk_rev_id in Update_Risk is NULL');

829: FETCH c_target_revision INTO l_risk_rev_id;
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;

Line 840: AMW_UTILITY_PVT.debug_message('l_risk_rev_id:'||l_risk_rev_id);

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
839:
840: AMW_UTILITY_PVT.debug_message('l_risk_rev_id:'||l_risk_rev_id);
841:
842: x_risk_id := p_risk_rec.risk_id;
843: x_risk_rev_id := l_risk_rev_id;
844:

Line 850: AMW_UTILITY_PVT.debug_message('Private API: Validate_Risk');

846: l_risk_rec.risk_rev_id := l_risk_rev_id;
847:
848: IF ( P_validation_level >= G_VALID_LEVEL_FULL)
849: THEN
850: AMW_UTILITY_PVT.debug_message('Private API: Validate_Risk');
851:
852: -- Invoke validation procedures
853: Validate_risk(
854: p_operate_mode => p_operate_mode,

Line 866: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',

862: x_msg_data => x_msg_data);
863: END IF;
864:
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;

Line 920: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

916: COMMIT WORK;
917: END IF;
918:
919:
920: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
921:
922: -- Standard call to get message count and if count is 1, get message info.
923: FND_MSG_PUB.Count_And_Get
924: (p_count => x_msg_count,

Line 929: WHEN AMW_UTILITY_PVT.resource_locked THEN

925: p_data => x_msg_data);
926:
927: EXCEPTION
928:
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

Line 931: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');

927: EXCEPTION
928:
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;

Line 1010: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1006: THEN
1007: FND_MSG_PUB.initialize;
1008: END IF;
1009:
1010: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1011:
1012:
1013: -- Initialize API return status to SUCCESS
1014: x_return_status := G_RET_STS_SUCCESS;

Line 1016: AMW_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

1012:
1013: -- Initialize API return status to SUCCESS
1014: x_return_status := G_RET_STS_SUCCESS;
1015:
1016: AMW_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1017:
1018: -- Invoke table handler(AMW_RISKS_PKG.Delete_Row)
1019: AMW_RISKS_PKG.Delete_Row(
1020: x_RISK_REV_ID => p_RISK_REV_ID);

Line 1030: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1026: COMMIT WORK;
1027: END IF;
1028:
1029:
1030: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1031:
1032: -- Standard call to get message count and if count is 1, get message info.
1033: FND_MSG_PUB.Count_And_Get
1034: (p_count => x_msg_count,

Line 1039: WHEN AMW_UTILITY_PVT.resource_locked THEN

1035: p_data => x_msg_data);
1036:
1037: EXCEPTION
1038:
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

Line 1041: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');

1037: EXCEPTION
1038:
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;

Line 1134: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1130: THEN
1131: FND_MSG_PUB.initialize;
1132: END IF;
1133:
1134: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1135:
1136:
1137: -- Initialize API return status to SUCCESS
1138: x_return_status := G_RET_STS_SUCCESS;

Line 1178: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',

1174: x_risk_rev_id => x_risk_rev_id,
1175: x_risk_id => x_risk_id);
1176:
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;

Line 1222: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',

1218: x_risk_rev_id => x_risk_rev_id,
1219: x_risk_id => x_risk_id);
1220:
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;

Line 1234: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1230: THEN
1231: COMMIT WORK;
1232: END IF;
1233:
1234: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1235:
1236: -- Standard call to get message count and if count is 1, get message info.
1237: FND_MSG_PUB.Count_And_Get
1238: (p_count => x_msg_count,

Line 1243: WHEN AMW_UTILITY_PVT.resource_locked THEN

1239: p_data => x_msg_data);
1240:
1241: EXCEPTION
1242:
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

Line 1245: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');

1241: EXCEPTION
1242:
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;

Line 1305: l_valid_flag := AMW_UTILITY_PVT.check_uniqueness(

1301: -- comment out for performance: since the uniqueness of
1302: -- risk_rev_id and risk_id have been checked when creating
1303: /*
1304: IF p_operate_mode = G_OP_CREATE THEN
1305: l_valid_flag := AMW_UTILITY_PVT.check_uniqueness(
1306: 'AMW_RISKS_B',
1307: 'RISK_REV_ID = ''' || p_risk_rec.RISK_REV_ID ||''''
1308: );
1309: ELSE

Line 1310: l_valid_flag := AMW_UTILITY_PVT.check_uniqueness(

1306: 'AMW_RISKS_B',
1307: 'RISK_REV_ID = ''' || p_risk_rec.RISK_REV_ID ||''''
1308: );
1309: ELSE
1310: l_valid_flag := AMW_UTILITY_PVT.check_uniqueness(
1311: 'AMW_RISKS_B',
1312: 'RISK_REV_ID = ''' || p_risk_rec.RISK_REV_ID ||
1313: ''' AND RISK_REV_ID <> ' || p_risk_rec.RISK_REV_ID
1314: );

Line 1349: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',

1345: x_return_status := G_RET_STS_SUCCESS;
1346:
1347: IF p_operate_mode = G_OP_CREATE THEN
1348: IF p_risk_rec.risk_impact IS NULL THEN
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;

Line 1357: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_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',
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;

Line 1365: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_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',
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;

Line 1373: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_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',
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;

Line 1381: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_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',
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;

Line 1390: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_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;
1394: RAISE FND_API.G_EXC_ERROR;

Line 1398: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_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;
1402: RAISE FND_API.G_EXC_ERROR;

Line 1406: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_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;
1410: RAISE FND_API.G_EXC_ERROR;

Line 1414: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_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;
1418: RAISE FND_API.G_EXC_ERROR;

Line 1422: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_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;
1426: RAISE FND_API.G_EXC_ERROR;

Line 1430: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_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;
1434: RAISE FND_API.G_EXC_ERROR;

Line 1438: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_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;
1442: RAISE FND_API.G_EXC_ERROR;

Line 1511: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',

1507: p_operate_mode => p_operate_mode,
1508: p_risk_rec => p_risk_rec,
1509: x_return_status => x_return_status);
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;

Line 1523: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',

1519: p_operate_mode => p_operate_mode,
1520: p_risk_rec => p_risk_rec,
1521: x_return_status => x_return_status);
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;

Line 1535: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',

1531: p_operate_mode => p_operate_mode,
1532: p_risk_rec => p_risk_rec,
1533: x_return_status => x_return_status);
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;

Line 1547: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',

1543: p_operate_mode => p_operate_mode,
1544: p_risk_rec => p_risk_rec,
1545: x_return_status => x_return_status);
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;

Line 1589: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1585: l_risk_tl_rec c_tl_complete%ROWTYPE;
1586:
1587:
1588: BEGIN
1589: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1590: x_complete_rec := p_risk_rec;
1591:
1592: OPEN c_complete;
1593: FETCH c_complete INTO l_risk_rec;

Line 1602: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNEXPECT_ERROR',

1598: CLOSE c_tl_complete;
1599:
1600: -- risk_rev_id
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;

Line 1697: AMW_UTILITY_PVT.debug_message('risk_rev_num: ' || x_complete_rec.risk_rev_num);

1693: -- risk_rev_num
1694: IF p_risk_rec.risk_rev_num IS NULL THEN
1695: x_complete_rec.risk_rev_num := l_risk_rec.risk_rev_num;
1696: END IF;
1697: AMW_UTILITY_PVT.debug_message('risk_rev_num: ' || x_complete_rec.risk_rev_num);
1698:
1699: -- requestor_id
1700: IF p_risk_rec.requestor_id IS NULL THEN
1701: x_complete_rec.requestor_id := l_risk_rec.requestor_id;

Line 1804: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1800: IF p_risk_rec.attribute15 IS NULL THEN
1801: x_complete_rec.attribute15 := l_risk_rec.attribute15;
1802: END IF;
1803:
1804: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1805: END Complete_risk_Rec;
1806:
1807:
1808:

Line 1839: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1835:
1836: BEGIN
1837: -- Standard Start of API savepoint
1838: SAVEPOINT VALIDATE_Risk_;
1839: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1840:
1841: -- Initialize API return status to SUCCESS
1842: x_return_status := G_RET_STS_SUCCESS;
1843:

Line 1901: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1897: END IF;
1898:
1899: x_risk_rec := l_risk_rec;
1900:
1901: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1902:
1903: -- Standard call to get message count and if count is 1, get message info.
1904: FND_MSG_PUB.Count_And_Get
1905: (p_count => x_msg_count,

Line 1910: WHEN AMW_UTILITY_PVT.resource_locked THEN

1906: p_data => x_msg_data);
1907:
1908: EXCEPTION
1909:
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

Line 1912: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');

1908: EXCEPTION
1909:
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;

Line 1979: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1975: THEN
1976: FND_MSG_PUB.initialize;
1977: END IF;
1978:
1979: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1980:
1981: -- Initialize API return status to SUCCESS
1982: x_return_status := G_RET_STS_SUCCESS;
1983:

Line 1991: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',

1987: x_msg_count => x_msg_count,
1988: x_msg_data => x_msg_data,
1989: p_risk_rec => p_risk_rec);
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;

Line 2004: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',

2000: x_msg_count => x_msg_count,
2001: x_msg_data => x_msg_data,
2002: p_risk_rec => p_risk_rec);
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;

Line 2017: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',

2013: x_msg_count => x_msg_count,
2014: x_msg_data => x_msg_data,
2015: p_risk_rec => p_risk_rec);
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;

Line 2030: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',

2026: x_msg_count => x_msg_count,
2027: x_msg_data => x_msg_data,
2028: p_risk_rec => p_risk_rec);
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;

Line 2037: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNEXPECT_ERROR',

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',
2038: p_token_name => 'OBJ_TYPE',
2039: p_token_value => G_OBJ_TYPE);
2040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2041: END IF;

Line 2044: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

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');
2045:
2046: -- Standard call to get message count and if count is 1, get message info.
2047: FND_MSG_PUB.Count_And_Get
2048: (p_count => x_msg_count,

Line 2080: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

2076: FROM amw_risks_all_vl
2077: WHERE name = l_risk_name;
2078:
2079: BEGIN
2080: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
2081:
2082: x_return_status := G_RET_STS_SUCCESS;
2083:
2084: l_dummy := NULL;

Line 2090: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNIQUE_ITEM_ERROR',

2086: FETCH c_name_exists INTO l_dummy;
2087: CLOSE c_name_exists;
2088:
2089: IF l_dummy IS NOT NULL THEN
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;

Line 2097: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

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:
2099: -- Standard call to get message count and if count is 1, get message info.
2100: FND_MSG_PUB.Count_And_Get
2101: (p_count => x_msg_count,

Line 2172: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

2168: FROM amw_risks_all_vl
2169: WHERE name = l_risk_name AND risk_id <> l_risk_id;
2170:
2171: BEGIN
2172: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
2173:
2174: x_return_status := G_RET_STS_SUCCESS;
2175:
2176: -- only approval_status='D' can be updated

Line 2182: AMW_UTILITY_PVT.debug_message('approval_status <> D');

2178: FETCH c_target_risk INTO target_risk;
2179: CLOSE c_target_risk;
2180: IF target_risk.approval_status <> 'D' THEN
2181: x_return_status := G_RET_STS_ERROR;
2182: AMW_UTILITY_PVT.debug_message('approval_status <> D');
2183: END IF;
2184:
2185: -- name duplication is not allowed
2186: l_dummy := NULL;

Line 2191: AMW_UTILITY_PVT.debug_message('name exists');

2187: OPEN c_name_exists(p_risk_rec.risk_name,p_risk_rec.risk_id);
2188: FETCH c_name_exists INTO l_dummy;
2189: CLOSE c_name_exists;
2190: IF l_dummy IS NOT NULL THEN
2191: AMW_UTILITY_PVT.debug_message('name exists');
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;

Line 2192: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNIQUE_ITEM_ERROR',

2188: FETCH c_name_exists INTO l_dummy;
2189: CLOSE c_name_exists;
2190: IF l_dummy IS NOT NULL THEN
2191: AMW_UTILITY_PVT.debug_message('name exists');
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;

Line 2199: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

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:
2201: -- Standard call to get message count and if count is 1, get message info.
2202: FND_MSG_PUB.Count_And_Get
2203: (p_count => x_msg_count,

Line 2275: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

2271: WHERE risk_rev_id = l_risk_rev_id;
2272: original_risk_name amw_risks_all_vl.name%TYPE;
2273:
2274: BEGIN
2275: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
2276:
2277: x_return_status := G_RET_STS_SUCCESS;
2278:
2279: -- change the name when revise a risk is not allowed

Line 2285: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',

2281: FETCH c_get_name INTO original_risk_name;
2282: CLOSE c_get_name;
2283: IF original_risk_name <> p_risk_rec.risk_name THEN
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;

Line 2291: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

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:
2293: -- Standard call to get message count and if count is 1, get message info.
2294: FND_MSG_PUB.Count_And_Get
2295: (p_count => x_msg_count,

Line 2360: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

2356: FROM amw_risks_b
2357: WHERE risk_rev_id = l_risk_rev_id;
2358:
2359: BEGIN
2360: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
2361:
2362: x_return_status := G_RET_STS_SUCCESS;
2363:
2364: -- can only delete a risk which exists and has APPROVAL_STATUS='''

Line 2370: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',

2366: OPEN c_risk_exists(p_risk_rec.risk_rev_id);
2367: FETCH c_risk_exists INTO l_dummy;
2368: CLOSE c_risk_exists;
2369: IF l_dummy IS NULL THEN
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;

Line 2377: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

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:
2379: -- Standard call to get message count and if count is 1, get message info.
2380: FND_MSG_PUB.Count_And_Get
2381: (p_count => x_msg_count,

Line 2460: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

2456: FND_MSG_PUB.initialize;
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