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_AUDIT_PROCEDURES_PVT dependencies on AMW_UTILITY_PVT

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

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

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

66: x_return_status := G_RET_STS_SUCCESS;
67:
68:
69: IF p_audit_procedure_rec.approval_status ='P' THEN
70: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_INVALID_STATUS',
71: p_token_name => 'OBJ_TYPE',
72: p_token_value => G_OBJ_TYPE);
73: RAISE FND_API.G_EXC_ERROR;
74: ELSIF p_audit_procedure_rec.approval_status ='R' THEN

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

71: p_token_name => 'OBJ_TYPE',
72: p_token_value => G_OBJ_TYPE);
73: RAISE FND_API.G_EXC_ERROR;
74: ELSIF p_audit_procedure_rec.approval_status ='R' THEN
75: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_INVALID_STATUS',
76: p_token_name => 'OBJ_TYPE',
77: p_token_value => G_OBJ_TYPE);
78: RAISE FND_API.G_EXC_ERROR;
79: ELSIF p_audit_procedure_rec.approval_status IS NOT NULL AND p_audit_procedure_rec.approval_status <> 'A' AND p_audit_procedure_rec.approval_status <> 'D' THEN

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

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

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

110: x_audit_procedure_rev_id => x_audit_procedure_rev_id,
111: x_audit_procedure_id => x_audit_procedure_id,
112: p_approval_date => l_approval_date);
113: IF x_return_status<>G_RET_STS_SUCCESS THEN
114: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
115: p_token_name => 'OBJ_TYPE',
116: p_token_value => G_OBJ_TYPE);
117: RAISE FND_API.G_EXC_ERROR;
118: END IF;

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

126: CLOSE c_revision_exists;
127:
128: IF l_dummy IS NULL OR l_dummy < 1 THEN
129: -- no corresponding audit_procedure_id in AMW_AUDIT_PROCEDURES_B is wrong
130: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNEXPECT_ERROR',
131: p_token_name => 'OBJ_TYPE',
132: p_token_value => G_OBJ_TYPE);
133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134: ELSIF l_dummy = 1 THEN

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

138: CLOSE c_approval_status;
139:
140: IF l_approval_status.approval_status='P' THEN
141: -- this record is Pending Approval, cannot do G_OP_UPDATE or G_OP_REVISE
142: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_PENDING_CHANGE_ERROR',
143: p_token_name => 'OBJ_TYPE',
144: p_token_value => G_OBJ_TYPE);
145: RAISE FND_API.G_EXC_ERROR;
146: ELSIF l_approval_status.approval_status='D' THEN

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

157: x_audit_procedure_rev_id => x_audit_procedure_rev_id,
158: x_audit_procedure_id => x_audit_procedure_id,
159: p_approval_date => l_approval_date);
160: IF x_return_status<>G_RET_STS_SUCCESS THEN
161: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
162: p_token_name => 'OBJ_TYPE',
163: p_token_value => G_OBJ_TYPE);
164: RAISE FND_API.G_EXC_ERROR;
165: END IF;

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

178: x_audit_procedure_rev_id => x_audit_procedure_rev_id,
179: x_audit_procedure_id => x_audit_procedure_id,
180: p_approval_date => l_approval_date);
181: IF x_return_status<>G_RET_STS_SUCCESS THEN
182: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
183: p_token_name => 'OBJ_TYPE',
184: p_token_value => G_OBJ_TYPE);
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;

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

201: x_audit_procedure_rev_id => x_audit_procedure_rev_id,
202: x_audit_procedure_id => x_audit_procedure_id,
203: p_approval_date => l_approval_date);
204: IF x_return_status<>G_RET_STS_SUCCESS THEN
205: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
206: p_token_name => 'OBJ_TYPE',
207: p_token_value => G_OBJ_TYPE);
208: RAISE FND_API.G_EXC_ERROR;
209: END IF;

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

211: END IF; -- end of if:l_dummy
212:
213: END IF; -- end of if:l_audit_procedure_id
214:
215: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
216:
217: -- Standard call to get message count and if count is 1, get message info.
218: FND_MSG_PUB.Count_And_Get(
219: p_count => x_msg_count,

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

301: THEN
302: FND_MSG_PUB.initialize;
303: END IF;
304:
305: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
306:
307:
308: IF p_operate_mode = G_OP_CREATE THEN
309: l_dummy_audit_procedure_rec := p_audit_procedure_rec;

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

333: x_audit_procedure_rev_id => x_audit_procedure_rev_id,
334: x_audit_procedure_id => x_audit_procedure_id);
335:
336: IF x_return_status<>G_RET_STS_SUCCESS THEN
337: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
338: p_token_name => 'OBJ_TYPE',
339: p_token_value => G_OBJ_TYPE);
340: RAISE FND_API.G_EXC_ERROR;
341: END IF;

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

370: x_audit_procedure_id => x_audit_procedure_id);
371:
372: fnd_file.put_line (fnd_file.LOG, '&&&&&&&&&&&&&&& Came out of Update &&&&&&&&&&&&&&&');
373: IF x_return_status<>G_RET_STS_SUCCESS THEN
374: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
375: p_token_name => 'OBJ_TYPE',
376: p_token_value => G_OBJ_TYPE);
377: RAISE FND_API.G_EXC_ERROR;
378: END IF;

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

412: x_audit_procedure_id => x_audit_procedure_id);
413:
414:
415: IF x_return_status<>G_RET_STS_SUCCESS THEN
416: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
417: p_token_name => 'OBJ_TYPE',
418: p_token_value => G_OBJ_TYPE);
419: RAISE FND_API.G_EXC_ERROR;
420: END IF;

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

437: x_audit_procedure_rev_id => x_audit_procedure_rev_id,
438: x_audit_procedure_id => x_audit_procedure_id);
439:
440: IF x_return_status<>G_RET_STS_SUCCESS THEN
441: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
442: p_token_name => 'OBJ_TYPE',
443: p_token_value => G_OBJ_TYPE);
444: RAISE FND_API.G_EXC_ERROR;
445: END IF;

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

459: p_audit_procedure_rev_id => p_audit_procedure_rec.audit_procedure_rev_id,
460: x_audit_procedure_id => x_audit_procedure_id);
461:
462: IF x_return_status<>G_RET_STS_SUCCESS THEN
463: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
464: p_token_name => 'OBJ_TYPE',
465: p_token_value => G_OBJ_TYPE);
466: RAISE FND_API.G_EXC_ERROR;
467: END IF;

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

466: RAISE FND_API.G_EXC_ERROR;
467: END IF;
468:
469: ELSE
470: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNEXPECT_ERROR',
471: p_token_name => 'OBJ_TYPE',
472: p_token_value => G_OBJ_TYPE);
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: END IF;

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

473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: END IF;
475:
476:
477: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
478:
479: -- Standard call to get message count and if count is 1, get message info.
480: FND_MSG_PUB.Count_And_Get
481: (p_count => x_msg_count,

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

589: THEN
590: FND_MSG_PUB.initialize;
591: END IF;
592:
593: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
594:
595: AMW_UTILITY_PVT.debug_message('p_operate_mode: ' || p_operate_mode);
596: -- Initialize API return status to SUCCESS
597: x_return_status := G_RET_STS_SUCCESS;

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

591: END IF;
592:
593: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
594:
595: AMW_UTILITY_PVT.debug_message('p_operate_mode: ' || p_operate_mode);
596: -- Initialize API return status to SUCCESS
597: x_return_status := G_RET_STS_SUCCESS;
598:
599: IF p_audit_procedure_rec.audit_procedure_rev_id IS NULL OR p_audit_procedure_rec.audit_procedure_rev_id = FND_API.g_miss_num THEN

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

636: l_audit_procedure_rec.audit_procedure_rev_id := l_audit_procedure_rev_id;
637:
638:
639: IF FND_GLOBAL.User_Id IS NULL THEN
640: AMW_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
641: RAISE FND_API.G_EXC_ERROR;
642: END IF;
643:
644: IF (P_validation_level >= G_VALID_LEVEL_FULL) THEN

Line 645: AMW_UTILITY_PVT.debug_message('Private API: Validate_AP');

641: RAISE FND_API.G_EXC_ERROR;
642: END IF;
643:
644: IF (P_validation_level >= G_VALID_LEVEL_FULL) THEN
645: AMW_UTILITY_PVT.debug_message('Private API: Validate_AP');
646:
647: -- Invoke validation procedures
648: Validate_AP(
649: p_operate_mode => p_operate_mode,

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

657: x_msg_data => x_msg_data);
658: END IF;
659:
660: IF x_return_status<>G_RET_STS_SUCCESS THEN
661: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
662: p_token_name => 'OBJ_TYPE',
663: p_token_value => G_OBJ_TYPE);
664: RAISE FND_API.G_EXC_ERROR;
665: END IF;

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

664: RAISE FND_API.G_EXC_ERROR;
665: END IF;
666:
667:
668: AMW_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
669:
670: -- Invoke table handler(AMW_AUDIT_PROCEDURES_PKG.Insert_Row)
671: AMW_UTILITY_PVT.debug_message( 'Private API: Calling AMW_AUDIT_PROCEDURES_PKG.Insert_Row');
672: AMW_AUDIT_PROCEDURES_PKG.Insert_Row(

Line 671: AMW_UTILITY_PVT.debug_message( 'Private API: Calling AMW_AUDIT_PROCEDURES_PKG.Insert_Row');

667:
668: AMW_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
669:
670: -- Invoke table handler(AMW_AUDIT_PROCEDURES_PKG.Insert_Row)
671: AMW_UTILITY_PVT.debug_message( 'Private API: Calling AMW_AUDIT_PROCEDURES_PKG.Insert_Row');
672: AMW_AUDIT_PROCEDURES_PKG.Insert_Row(
673: x_rowid => l_row_id,
674: x_audit_procedure_rev_id => l_dummy_audit_procedure_rec.audit_procedure_rev_id,
675: x_project_id => l_dummy_audit_procedure_rec.project_id,

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

709: x_last_updated_by => G_USER_ID,
710: x_last_update_login => G_LOGIN_ID);
711:
712: IF x_return_status <> G_RET_STS_SUCCESS THEN
713: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
714: p_token_name => 'OBJ_TYPE',
715: p_token_value => G_OBJ_TYPE);
716: RAISE FND_API.G_EXC_ERROR;
717: END IF;

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

722: COMMIT WORK;
723: END IF;
724:
725:
726: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
727:
728: -- Standard call to get message count and if count is 1, get message info.
729: FND_MSG_PUB.Count_And_Get
730: (p_count => x_msg_count,

Line 734: WHEN AMW_UTILITY_PVT.resource_locked THEN

730: (p_count => x_msg_count,
731: p_data => x_msg_data);
732:
733: EXCEPTION
734: WHEN AMW_UTILITY_PVT.resource_locked THEN
735: x_return_status := G_RET_STS_ERROR;
736: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
737:
738: WHEN FND_API.G_EXC_ERROR THEN

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

732:
733: EXCEPTION
734: WHEN AMW_UTILITY_PVT.resource_locked THEN
735: x_return_status := G_RET_STS_ERROR;
736: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
737:
738: WHEN FND_API.G_EXC_ERROR THEN
739: ROLLBACK TO CREATE_AP_PVT;
740: x_return_status := G_RET_STS_ERROR;

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

829: THEN
830: FND_MSG_PUB.initialize;
831: END IF;
832:
833: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
834:
835:
836: -- Initialize API return status to SUCCESS
837: x_return_status := G_RET_STS_SUCCESS;

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

835:
836: -- Initialize API return status to SUCCESS
837: x_return_status := G_RET_STS_SUCCESS;
838:
839: AMW_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
840:
841:
842: -- if no specified target audit_procedure_rev_id, find if from audit_procedure_id
843: IF p_audit_procedure_rec.audit_procedure_rev_id IS NULL OR p_audit_procedure_rec.audit_procedure_rev_id = FND_API.g_miss_num THEN

Line 850: AMW_UTILITY_PVT.debug_message('l_audit_procedure_rev_id in Update_AP is NULL');

846: FETCH c_target_revision INTO l_audit_procedure_rev_id;
847: CLOSE c_target_revision;
848: IF l_audit_procedure_rev_id IS NULL THEN
849: x_return_status := G_RET_STS_ERROR;
850: AMW_UTILITY_PVT.debug_message('l_audit_procedure_rev_id in Update_AP is NULL');
851: RAISE FND_API.G_EXC_ERROR;
852: END IF;
853: ELSE
854: l_audit_procedure_rev_id := p_audit_procedure_rec.audit_procedure_rev_id;

Line 858: AMW_UTILITY_PVT.debug_message('l_audit_procedure_rev_id:'||l_audit_procedure_rev_id);

854: l_audit_procedure_rev_id := p_audit_procedure_rec.audit_procedure_rev_id;
855: END IF; -- end of if:p_audit_procedure_rec.audit_procedure_rev_id
856:
857:
858: AMW_UTILITY_PVT.debug_message('l_audit_procedure_rev_id:'||l_audit_procedure_rev_id);
859:
860: x_audit_procedure_id := p_audit_procedure_rec.audit_procedure_id;
861: x_audit_procedure_rev_id := l_audit_procedure_rev_id;
862:

Line 869: AMW_UTILITY_PVT.debug_message('Private API: Validate_AP');

865:
866:
867: IF ( P_validation_level >= G_VALID_LEVEL_FULL)
868: THEN
869: AMW_UTILITY_PVT.debug_message('Private API: Validate_AP');
870:
871: -- Invoke validation procedures
872: Validate_AP(
873: p_operate_mode => p_operate_mode,

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

882: END IF;
883:
884:
885: IF x_return_status<>G_RET_STS_SUCCESS THEN
886: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
887: p_token_name => 'OBJ_TYPE',
888: p_token_value => G_OBJ_TYPE);
889: RAISE FND_API.G_EXC_ERROR;
890: END IF;

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

968: COMMIT WORK;
969: END IF;
970:
971:
972: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
973:
974: -- Standard call to get message count and if count is 1, get message info.
975: FND_MSG_PUB.Count_And_Get
976: (p_count => x_msg_count,

Line 982: WHEN AMW_UTILITY_PVT.resource_locked THEN

978:
979:
980: EXCEPTION
981:
982: WHEN AMW_UTILITY_PVT.resource_locked THEN
983: x_return_status := G_RET_STS_ERROR;
984: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
985:
986: WHEN FND_API.G_EXC_ERROR THEN

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

980: EXCEPTION
981:
982: WHEN AMW_UTILITY_PVT.resource_locked THEN
983: x_return_status := G_RET_STS_ERROR;
984: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
985:
986: WHEN FND_API.G_EXC_ERROR THEN
987: ROLLBACK TO UPDATE_AP_PVT;
988: x_return_status := G_RET_STS_ERROR;

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

1059: THEN
1060: FND_MSG_PUB.initialize;
1061: END IF;
1062:
1063: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1064:
1065:
1066: -- Initialize API return status to SUCCESS
1067: x_return_status := G_RET_STS_SUCCESS;

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

1065:
1066: -- Initialize API return status to SUCCESS
1067: x_return_status := G_RET_STS_SUCCESS;
1068:
1069: AMW_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1070:
1071: -- Invoke table handler(AMW_AUDIT_PROCEDURES_PKG.Delete_Row)
1072: AMW_AUDIT_PROCEDURES_PKG.Delete_Row(
1073: x_audit_procedure_rev_id => p_audit_procedure_rev_id);

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

1079: COMMIT WORK;
1080: END IF;
1081:
1082:
1083: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1084:
1085: -- Standard call to get message count and if count is 1, get message info.
1086: FND_MSG_PUB.Count_And_Get
1087: (p_count => x_msg_count,

Line 1092: WHEN AMW_UTILITY_PVT.resource_locked THEN

1088: p_data => x_msg_data);
1089:
1090: EXCEPTION
1091:
1092: WHEN AMW_UTILITY_PVT.resource_locked THEN
1093: x_return_status := G_RET_STS_ERROR;
1094: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1095:
1096: WHEN FND_API.G_EXC_ERROR THEN

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

1090: EXCEPTION
1091:
1092: WHEN AMW_UTILITY_PVT.resource_locked THEN
1093: x_return_status := G_RET_STS_ERROR;
1094: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1095:
1096: WHEN FND_API.G_EXC_ERROR THEN
1097: ROLLBACK TO DELETE_AP_PVT;
1098: x_return_status := G_RET_STS_ERROR;

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

1186: THEN
1187: FND_MSG_PUB.initialize;
1188: END IF;
1189:
1190: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1191:
1192:
1193: -- Initialize API return status to SUCCESS
1194: x_return_status := G_RET_STS_SUCCESS;

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

1237:
1238:
1239: IF x_return_status <> G_RET_STS_SUCCESS THEN
1240:
1241: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
1242: p_token_name => 'OBJ_TYPE',
1243: p_token_value => G_OBJ_TYPE);
1244: RAISE FND_API.G_EXC_ERROR;
1245: END IF;

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

1305: x_audit_procedure_rev_id => x_audit_procedure_rev_id,
1306: x_audit_procedure_id => x_audit_procedure_id);
1307:
1308: IF x_return_status <> G_RET_STS_SUCCESS THEN
1309: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
1310: p_token_name => 'OBJ_TYPE',
1311: p_token_value => G_OBJ_TYPE);
1312: RAISE FND_API.G_EXC_ERROR;
1313: END IF;

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

1317: THEN
1318: COMMIT WORK;
1319: END IF;
1320:
1321: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1322:
1323: -- Standard call to get message count and if count is 1, get message info.
1324: FND_MSG_PUB.Count_And_Get
1325: (p_count => x_msg_count,

Line 1330: WHEN AMW_UTILITY_PVT.resource_locked THEN

1326: p_data => x_msg_data);
1327:
1328: EXCEPTION
1329:
1330: WHEN AMW_UTILITY_PVT.resource_locked THEN
1331: x_return_status := G_RET_STS_ERROR;
1332: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1333:
1334: WHEN FND_API.G_EXC_ERROR THEN

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

1328: EXCEPTION
1329:
1330: WHEN AMW_UTILITY_PVT.resource_locked THEN
1331: x_return_status := G_RET_STS_ERROR;
1332: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1333:
1334: WHEN FND_API.G_EXC_ERROR THEN
1335: ROLLBACK TO REVISE_AP_PVT;
1336: x_return_status := G_RET_STS_ERROR;

Line 1392: l_valid_flag := AMW_UTILITY_PVT.check_uniqueness(

1388: -- comment out for performance: since the uniqueness of
1389: -- audit_procedure_rev_id and audit_procedure_id have been checked when creating
1390: /*
1391: IF p_operate_mode = G_OP_CREATE THEN
1392: l_valid_flag := AMW_UTILITY_PVT.check_uniqueness(
1393: 'amw_audit_procedures_b',
1394: 'audit_procedure_rev_id = ''' || p_audit_procedure_rec.audit_procedure_rev_id ||''''
1395: );
1396: ELSE

Line 1397: l_valid_flag := AMW_UTILITY_PVT.check_uniqueness(

1393: 'amw_audit_procedures_b',
1394: 'audit_procedure_rev_id = ''' || p_audit_procedure_rec.audit_procedure_rev_id ||''''
1395: );
1396: ELSE
1397: l_valid_flag := AMW_UTILITY_PVT.check_uniqueness(
1398: 'amw_audit_procedures_b',
1399: 'audit_procedure_rev_id = ''' || p_audit_procedure_rec.audit_procedure_rev_id ||
1400: ''' AND audit_procedure_rev_id <> ' || p_audit_procedure_rec.audit_procedure_rev_id
1401: );

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

1433:
1434: IF p_operate_mode = G_OP_CREATE THEN
1435:
1436: IF p_audit_procedure_rec.audit_procedure_rev_num IS NULL THEN
1437: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1438: p_token_name => 'ITEM',
1439: p_token_value => 'audit_procedure_rev_num');
1440: x_return_status := G_RET_STS_ERROR;
1441: RAISE FND_API.G_EXC_ERROR;

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

1441: RAISE FND_API.G_EXC_ERROR;
1442: END IF;
1443:
1444: IF p_audit_procedure_rec.latest_revision_flag IS NULL THEN
1445: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1446: p_token_name => 'ITEM',
1447: p_token_value => 'latest_revision_flag');
1448: x_return_status := G_RET_STS_ERROR;
1449: RAISE FND_API.G_EXC_ERROR;

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

1449: RAISE FND_API.G_EXC_ERROR;
1450: END IF;
1451:
1452: IF p_audit_procedure_rec.curr_approved_flag IS NULL THEN
1453: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1454: p_token_name => 'ITEM',
1455: p_token_value => 'curr_approved_flag');
1456: x_return_status := G_RET_STS_ERROR;
1457: RAISE FND_API.G_EXC_ERROR;

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

1458: END IF;
1459:
1460: ELSE
1461: IF p_audit_procedure_rec.audit_procedure_rev_id = FND_API.g_miss_num THEN
1462: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1463: p_token_name => 'ITEM',
1464: p_token_value => 'audit_procedure_rev_id');
1465: x_return_status := G_RET_STS_ERROR;
1466: RAISE FND_API.G_EXC_ERROR;

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

1466: RAISE FND_API.G_EXC_ERROR;
1467: END IF;
1468:
1469: IF p_audit_procedure_rec.audit_procedure_id = FND_API.g_miss_num THEN
1470: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1471: p_token_name => 'ITEM',
1472: p_token_value => 'audit_procedure_id');
1473: x_return_status := G_RET_STS_ERROR;
1474: RAISE FND_API.G_EXC_ERROR;

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

1474: RAISE FND_API.G_EXC_ERROR;
1475: END IF;
1476:
1477: IF p_audit_procedure_rec.audit_procedure_rev_num = FND_API.g_miss_num THEN
1478: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1479: p_token_name => 'ITEM',
1480: p_token_value => 'audit_procedure_rev_num');
1481: x_return_status := G_RET_STS_ERROR;
1482: RAISE FND_API.G_EXC_ERROR;

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

1482: RAISE FND_API.G_EXC_ERROR;
1483: END IF;
1484:
1485: IF p_audit_procedure_rec.latest_revision_flag = FND_API.g_miss_char THEN
1486: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1487: p_token_name => 'ITEM',
1488: p_token_value => 'latest_revision_flag');
1489: x_return_status := G_RET_STS_ERROR;
1490: RAISE FND_API.G_EXC_ERROR;

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

1490: RAISE FND_API.G_EXC_ERROR;
1491: END IF;
1492:
1493: IF p_audit_procedure_rec.curr_approved_flag = FND_API.g_miss_char THEN
1494: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1495: p_token_name => 'ITEM',
1496: p_token_value => 'curr_approved_flag');
1497: x_return_status := G_RET_STS_ERROR;
1498: RAISE FND_API.G_EXC_ERROR;

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

1563: p_operate_mode => p_operate_mode,
1564: p_audit_procedure_rec => p_audit_procedure_rec,
1565: x_return_status => x_return_status);
1566: IF x_return_status <> G_RET_STS_SUCCESS THEN
1567: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
1568: p_token_name => 'OBJ_TYPE',
1569: p_token_value => G_OBJ_TYPE);
1570: RAISE FND_API.G_EXC_ERROR;
1571: END IF;

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

1575: p_operate_mode => p_operate_mode,
1576: p_audit_procedure_rec => p_audit_procedure_rec,
1577: x_return_status => x_return_status);
1578: IF x_return_status <> G_RET_STS_SUCCESS THEN
1579: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
1580: p_token_name => 'OBJ_TYPE',
1581: p_token_value => G_OBJ_TYPE);
1582: RAISE FND_API.G_EXC_ERROR;
1583: END IF;

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

1587: p_operate_mode => p_operate_mode,
1588: p_audit_procedure_rec => p_audit_procedure_rec,
1589: x_return_status => x_return_status);
1590: IF x_return_status <> G_RET_STS_SUCCESS THEN
1591: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
1592: p_token_name => 'OBJ_TYPE',
1593: p_token_value => G_OBJ_TYPE);
1594: RAISE FND_API.G_EXC_ERROR;
1595: END IF;

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

1599: p_operate_mode => p_operate_mode,
1600: p_audit_procedure_rec => p_audit_procedure_rec,
1601: x_return_status => x_return_status);
1602: IF x_return_status <> G_RET_STS_SUCCESS THEN
1603: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
1604: p_token_name => 'OBJ_TYPE',
1605: p_token_value => G_OBJ_TYPE);
1606: RAISE FND_API.G_EXC_ERROR;
1607: END IF;

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

1641: l_audit_procedure_tl_rec c_tl_complete%ROWTYPE;
1642:
1643:
1644: BEGIN
1645: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1646: x_complete_rec := p_audit_procedure_rec;
1647:
1648: OPEN c_complete;
1649: FETCH c_complete INTO l_audit_procedure_rec;

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

1654: CLOSE c_tl_complete;
1655:
1656: -- audit_procedure_rev_id
1657: IF p_audit_procedure_rec.audit_procedure_rev_id IS NULL THEN
1658: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNEXPECT_ERROR',
1659: p_token_name => 'OBJ_TYPE',
1660: p_token_value => G_OBJ_TYPE);
1661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1662: END IF;

Line 1728: AMW_UTILITY_PVT.debug_message('audit_procedure_rev_num: ' || x_complete_rec.audit_procedure_rev_num);

1724: -- audit_procedure_rev_num
1725: IF p_audit_procedure_rec.audit_procedure_rev_num IS NULL THEN
1726: x_complete_rec.audit_procedure_rev_num := l_audit_procedure_rec.audit_procedure_rev_num;
1727: END IF;
1728: AMW_UTILITY_PVT.debug_message('audit_procedure_rev_num: ' || x_complete_rec.audit_procedure_rev_num);
1729:
1730: -- requestor_id
1731: IF p_audit_procedure_rec.requestor_id IS NULL THEN
1732: x_complete_rec.requestor_id := l_audit_procedure_rec.requestor_id;

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

1831: IF p_audit_procedure_rec.attribute15 IS NULL THEN
1832: x_complete_rec.attribute15 := l_audit_procedure_rec.attribute15;
1833: END IF;
1834:
1835: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1836: END Complete_AP_Rec;
1837:
1838:
1839:

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

1866:
1867: BEGIN
1868: -- Standard Start of API savepoint
1869: SAVEPOINT VALIDATE_AP_;
1870: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1871:
1872: -- Initialize API return status to SUCCESS
1873: x_return_status := G_RET_STS_SUCCESS;
1874:

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

1928: END IF;
1929:
1930: x_audit_procedure_rec := l_audit_procedure_rec;
1931:
1932: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1933:
1934: -- Standard call to get message count and if count is 1, get message info.
1935: FND_MSG_PUB.Count_And_Get
1936: (p_count => x_msg_count,

Line 1941: WHEN AMW_UTILITY_PVT.resource_locked THEN

1937: p_data => x_msg_data);
1938:
1939: EXCEPTION
1940:
1941: WHEN AMW_UTILITY_PVT.resource_locked THEN
1942: x_return_status := G_RET_STS_ERROR;
1943: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1944:
1945: WHEN FND_API.G_EXC_ERROR THEN

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

1939: EXCEPTION
1940:
1941: WHEN AMW_UTILITY_PVT.resource_locked THEN
1942: x_return_status := G_RET_STS_ERROR;
1943: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1944:
1945: WHEN FND_API.G_EXC_ERROR THEN
1946: ROLLBACK TO VALIDATE_AP_;
1947: x_return_status := G_RET_STS_ERROR;

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

2006: THEN
2007: FND_MSG_PUB.initialize;
2008: END IF;
2009:
2010: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
2011:
2012: -- Initialize API return status to SUCCESS
2013: x_return_status := G_RET_STS_SUCCESS;
2014:

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

2018: x_msg_count => x_msg_count,
2019: x_msg_data => x_msg_data,
2020: p_audit_procedure_rec => p_audit_procedure_rec);
2021: IF x_return_status<>G_RET_STS_SUCCESS THEN
2022: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
2023: p_token_name => 'OBJ_TYPE',
2024: p_token_value => G_OBJ_TYPE);
2025: RAISE FND_API.G_EXC_ERROR;
2026: END IF;

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

2031: x_msg_count => x_msg_count,
2032: x_msg_data => x_msg_data,
2033: p_audit_procedure_rec => p_audit_procedure_rec);
2034: IF x_return_status<>G_RET_STS_SUCCESS THEN
2035: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
2036: p_token_name => 'OBJ_TYPE',
2037: p_token_value => G_OBJ_TYPE);
2038: RAISE FND_API.G_EXC_ERROR;
2039: END IF;

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

2044: x_msg_count => x_msg_count,
2045: x_msg_data => x_msg_data,
2046: p_audit_procedure_rec => p_audit_procedure_rec);
2047: IF x_return_status<>G_RET_STS_SUCCESS THEN
2048: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
2049: p_token_name => 'OBJ_TYPE',
2050: p_token_value => G_OBJ_TYPE);
2051: RAISE FND_API.G_EXC_ERROR;
2052: END IF;

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

2057: x_msg_count => x_msg_count,
2058: x_msg_data => x_msg_data,
2059: p_audit_procedure_rec => p_audit_procedure_rec);
2060: IF x_return_status<>G_RET_STS_SUCCESS THEN
2061: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
2062: p_token_name => 'OBJ_TYPE',
2063: p_token_value => G_OBJ_TYPE);
2064: RAISE FND_API.G_EXC_ERROR;
2065: END IF;

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

2064: RAISE FND_API.G_EXC_ERROR;
2065: END IF;
2066:
2067: ELSE
2068: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNEXPECT_ERROR',
2069: p_token_name => 'OBJ_TYPE',
2070: p_token_value => G_OBJ_TYPE);
2071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2072: END IF;

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

2071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2072: END IF;
2073:
2074:
2075: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2076:
2077: -- Standard call to get message count and if count is 1, get message info.
2078: FND_MSG_PUB.Count_And_Get
2079: (p_count => x_msg_count,

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

2107: FROM amw_audit_procedures_vl
2108: WHERE name = l_audit_procedure_name;
2109:
2110: BEGIN
2111: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
2112:
2113: x_return_status := G_RET_STS_SUCCESS;
2114:
2115: l_dummy := NULL;

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

2117: FETCH c_name_exists INTO l_dummy;
2118: CLOSE c_name_exists;
2119:
2120: IF l_dummy IS NOT NULL THEN
2121: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNIQUE_ITEM_ERROR',
2122: p_token_name => 'ITEM',
2123: p_token_value => 'audit_procedure_name');
2124: x_return_status := G_RET_STS_ERROR;
2125: RAISE FND_API.G_EXC_ERROR;

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

2124: x_return_status := G_RET_STS_ERROR;
2125: RAISE FND_API.G_EXC_ERROR;
2126: END IF;
2127:
2128: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2129:
2130: -- Standard call to get message count and if count is 1, get message info.
2131: FND_MSG_PUB.Count_And_Get
2132: (p_count => x_msg_count,

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

2199: FROM amw_audit_procedures_vl
2200: WHERE name = l_audit_procedure_name AND audit_procedure_id <> l_audit_procedure_id;
2201:
2202: BEGIN
2203: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
2204:
2205: x_return_status := G_RET_STS_SUCCESS;
2206:
2207: -- only approval_status='D' can be updated

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

2209: FETCH c_target_audit_procedure INTO target_audit_procedure;
2210: CLOSE c_target_audit_procedure;
2211: IF target_audit_procedure.approval_status <> 'D' THEN
2212: x_return_status := G_RET_STS_ERROR;
2213: AMW_UTILITY_PVT.debug_message('approval_status <> D');
2214: END IF;
2215:
2216: -- name duplication is not allowed
2217: l_dummy := NULL;

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

2218: OPEN c_name_exists(p_audit_procedure_rec.audit_procedure_name,p_audit_procedure_rec.audit_procedure_id);
2219: FETCH c_name_exists INTO l_dummy;
2220: CLOSE c_name_exists;
2221: IF l_dummy IS NOT NULL THEN
2222: AMW_UTILITY_PVT.debug_message('name exists');
2223: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNIQUE_ITEM_ERROR',
2224: p_token_name => 'ITEM',
2225: p_token_value => 'audit_procedure_name');
2226: x_return_status := G_RET_STS_ERROR;

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

2219: FETCH c_name_exists INTO l_dummy;
2220: CLOSE c_name_exists;
2221: IF l_dummy IS NOT NULL THEN
2222: AMW_UTILITY_PVT.debug_message('name exists');
2223: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNIQUE_ITEM_ERROR',
2224: p_token_name => 'ITEM',
2225: p_token_value => 'audit_procedure_name');
2226: x_return_status := G_RET_STS_ERROR;
2227: RAISE FND_API.G_EXC_ERROR;

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

2226: x_return_status := G_RET_STS_ERROR;
2227: RAISE FND_API.G_EXC_ERROR;
2228: END IF;
2229:
2230: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2231:
2232: -- Standard call to get message count and if count is 1, get message info.
2233: FND_MSG_PUB.Count_And_Get
2234: (p_count => x_msg_count,

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

2302: WHERE audit_procedure_rev_id = l_audit_procedure_rev_id;
2303: original_audit_procedure_name amw_audit_procedures_vl.name%TYPE;
2304:
2305: BEGIN
2306: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
2307:
2308: x_return_status := G_RET_STS_SUCCESS;
2309:
2310: -- change the name when revise an audit procedure is not allowed

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

2312: FETCH c_get_name INTO original_audit_procedure_name;
2313: CLOSE c_get_name;
2314: IF original_audit_procedure_name <> p_audit_procedure_rec.audit_procedure_name THEN
2315: x_return_status := G_RET_STS_ERROR;
2316: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
2317: p_token_name => 'OBJ_TYPE',
2318: p_token_value => G_OBJ_TYPE);
2319: RAISE FND_API.G_EXC_ERROR;
2320: END IF;

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

2318: p_token_value => G_OBJ_TYPE);
2319: RAISE FND_API.G_EXC_ERROR;
2320: END IF;
2321:
2322: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2323:
2324: -- Standard call to get message count and if count is 1, get message info.
2325: FND_MSG_PUB.Count_And_Get
2326: (p_count => x_msg_count,

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

2387: FROM amw_audit_procedures_b
2388: WHERE audit_procedure_rev_id = l_audit_procedure_rev_id;
2389:
2390: BEGIN
2391: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
2392:
2393: x_return_status := G_RET_STS_SUCCESS;
2394:
2395: -- can only delete an audit procedure which exists and has APPROVAL_STATUS='''

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

2397: OPEN c_audit_procedure_exists(p_audit_procedure_rec.audit_procedure_rev_id);
2398: FETCH c_audit_procedure_exists INTO l_dummy;
2399: CLOSE c_audit_procedure_exists;
2400: IF l_dummy IS NULL THEN
2401: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
2402: p_token_name => 'OBJ_TYPE',
2403: p_token_value => G_OBJ_TYPE);
2404: x_return_status := G_RET_STS_ERROR;
2405: RAISE FND_API.G_EXC_ERROR;

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

2404: x_return_status := G_RET_STS_ERROR;
2405: RAISE FND_API.G_EXC_ERROR;
2406: END IF;
2407:
2408: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2409:
2410: -- Standard call to get message count and if count is 1, get message info.
2411: FND_MSG_PUB.Count_And_Get
2412: (p_count => x_msg_count,

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

3047: close c_get_rev_num;
3048:
3049: if(l_ap_rev_num is null)
3050: then
3051: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNEXPECT_ERROR',
3052: p_token_name => 'OBJ_TYPE',
3053: p_token_value => G_OBJ_TYPE);
3054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3055: end if;

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

3309: fnd_file.put_line(fnd_file.LOG,'Inside insert_ap_control_assoc --> x_return_status: '||x_return_status);
3310:
3311: if(p_control_id is null OR p_audit_procedure_id is null)
3312: then
3313: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNEXPECT_ERROR',
3314: p_token_name => 'OBJ_TYPE',
3315: p_token_value => G_OBJ_TYPE);
3316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3317: end if;

Line 3319: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_ASSOC_AP_EFF_WEBADI_MSG');

3315: p_token_value => G_OBJ_TYPE);
3316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3317: end if;
3318: if(p_des_eff = 'N' AND p_op_eff = 'N') then
3319: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_ASSOC_AP_EFF_WEBADI_MSG');
3320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3321: end if;
3322:
3323: if(p_approval_date is null)

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

3498: fnd_file.put_line(fnd_file.LOG,'Inside copy_ext_attr --> x_return_status: '||x_return_status);
3499:
3500: if(p_from_audit_procedure_id is null OR p_to_audit_procedure_id is null)
3501: then
3502: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNEXPECT_ERROR',
3503: p_token_name => 'OBJ_TYPE',
3504: p_token_value => G_OBJ_TYPE);
3505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3506: end if;

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

3634:
3635: IF l_dummy IS NULL OR l_dummy < 1
3636: THEN
3637: -- no corresponding audit_procedure_id in AMW_AUDIT_PROCEDURES_B is wrong
3638: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNEXPECT_ERROR',
3639: p_token_name => 'OBJ_TYPE',
3640: p_token_value => G_OBJ_TYPE);
3641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3642: ELSIF l_dummy >= 1

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

3648:
3649: IF l_approval_status.approval_status='P'
3650: THEN
3651: -- this record is Pending Approval, cannot do G_OP_UPDATE or G_OP_REVISE
3652: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_PENDING_CHANGE_ERROR',
3653: p_token_name => 'OBJ_TYPE',
3654: p_token_value => G_OBJ_TYPE);
3655: RAISE FND_API.G_EXC_ERROR;
3656: ELSIF l_approval_status.approval_status='A' OR l_approval_status.approval_status='R'