[Home] [Help]
58:
59: END LOOP;
60: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
61:
62: -- Standard call to get message count and if count is 1, get message info.
63: FND_MSG_PUB.Count_And_Get
64: (p_count => x_msg_count,
65: p_data => x_msg_data
66: );
72:
73: WHEN FND_API.G_EXC_ERROR THEN
74: ROLLBACK TO CREATE_Process;
75: x_return_status := FND_API.G_RET_STS_ERROR;
76: -- Standard call to get message count and if count=1, get the message
77: FND_MSG_PUB.Count_And_Get (
78: p_encoded => FND_API.G_FALSE,
79: p_count => x_msg_count,
80: p_data => x_msg_data
82:
83: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
84: ROLLBACK TO CREATE_Process;
85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
86: -- Standard call to get message count and if count=1, get the message
87: FND_MSG_PUB.Count_And_Get (
88: p_encoded => FND_API.G_FALSE,
89: p_count => x_msg_count,
90: p_data => x_msg_data
96: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
97: THEN
98: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
99: END IF;
100: -- Standard call to get message count and if count=1, get the message
101: FND_MSG_PUB.Count_And_Get (
102: p_encoded => FND_API.G_FALSE,
103: p_count => x_msg_count,
104: p_data => x_msg_data
143:
144: END LOOP;
145: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
146:
147: -- Standard call to get message count and if count is 1, get message info.
148: FND_MSG_PUB.Count_And_Get
149: (p_count => x_msg_count,
150: p_data => x_msg_data
151: );
157:
158: WHEN FND_API.G_EXC_ERROR THEN
159: ROLLBACK TO update_Process;
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: -- Standard call to get message count and if count=1, get the message
162: FND_MSG_PUB.Count_And_Get (
163: p_encoded => FND_API.G_FALSE,
164: p_count => x_msg_count,
165: p_data => x_msg_data
167:
168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
169: ROLLBACK TO update_Process;
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
171: -- Standard call to get message count and if count=1, get the message
172: FND_MSG_PUB.Count_And_Get (
173: p_encoded => FND_API.G_FALSE,
174: p_count => x_msg_count,
175: p_data => x_msg_data
181: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
182: THEN
183: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
184: END IF;
185: -- Standard call to get message count and if count=1, get the message
186: FND_MSG_PUB.Count_And_Get (
187: p_encoded => FND_API.G_FALSE,
188: p_count => x_msg_count,
189: p_data => x_msg_data
226: FROM AMW_PROCESS
227: WHERE PROCESS_ID = l_id;
228:
229: BEGIN
230: -- Standard Start of API savepoint
231: SAVEPOINT CREATE_Process_PVT;
232:
233: -- Standard call to check for call compatibility.
234: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
229: BEGIN
230: -- Standard Start of API savepoint
231: SAVEPOINT CREATE_Process_PVT;
232:
233: -- Standard call to check for call compatibility.
234: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
235: p_api_version_number,
236: l_api_name,
237: G_PKG_NAME)
304:
305: -- Invoke table handler(AMW_PROCESS_PKG.Insert_Row)
306: AMW_PROCESS_PKG.Insert_Row(
307: p_significant_process_flag => p_process_rec.significant_process_flag,
308: p_standard_process_flag => fnd_profile.value('AMW_SET_STD_PROCESS'),
309: p_approval_status => 'A',
310: p_certification_status => p_process_rec.certification_status,
311: p_process_owner_id => p_process_rec.process_owner_id,
312: p_last_update_date => SYSDATE,
352: --
353: -- End of API body
354: --
355:
356: -- Standard check for p_commit
357: IF FND_API.to_Boolean( p_commit )
358: THEN
359: COMMIT WORK;
360: END IF;
362:
363: -- Debug Message
364: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
365:
366: -- Standard call to get message count and if count is 1, get message info.
367: FND_MSG_PUB.Count_And_Get
368: (p_count => x_msg_count,
369: p_data => x_msg_data
370: );
376:
377: WHEN FND_API.G_EXC_ERROR THEN
378: ROLLBACK TO CREATE_Process_PVT;
379: x_return_status := FND_API.G_RET_STS_ERROR;
380: -- Standard call to get message count and if count=1, get the message
381: FND_MSG_PUB.Count_And_Get (
382: p_encoded => FND_API.G_FALSE,
383: p_count => x_msg_count,
384: p_data => x_msg_data
386:
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388: ROLLBACK TO CREATE_Process_PVT;
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
390: -- Standard call to get message count and if count=1, get the message
391: FND_MSG_PUB.Count_And_Get (
392: p_encoded => FND_API.G_FALSE,
393: p_count => x_msg_count,
394: p_data => x_msg_data
400: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
401: THEN
402: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
403: END IF;
404: -- Standard call to get message count and if count=1, get the message
405: FND_MSG_PUB.Count_And_Get (
406: p_encoded => FND_API.G_FALSE,
407: p_count => x_msg_count,
408: p_data => x_msg_data
440: l_tar_process_rec AMW_Process_PVT.process_rec_type := P_process_rec;
441: l_rowid ROWID;
442:
443: BEGIN
444: -- Standard Start of API savepoint
445: SAVEPOINT UPDATE_Process_PVT;
446:
447: -- Standard call to check for call compatibility.
448: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
443: BEGIN
444: -- Standard Start of API savepoint
445: SAVEPOINT UPDATE_Process_PVT;
446:
447: -- Standard call to check for call compatibility.
448: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
449: p_api_version_number,
450: l_api_name,
451: G_PKG_NAME)
526:
527: -- Invoke table handler(AMW_PROCESS_PKG.Update_Row)
528: AMW_PROCESS_PKG.Update_Row(
529: p_significant_process_flag => p_process_rec.significant_process_flag,
530: p_standard_process_flag => p_process_rec.standard_process_flag,
531: p_approval_status => p_process_rec.approval_status,
532: p_certification_status => p_process_rec.certification_status,
533: p_process_owner_id => p_process_rec.process_owner_id,
534: p_last_update_date => SYSDATE,
569: --
570: -- End of API body.
571: --
572:
573: -- Standard check for p_commit
574: IF FND_API.to_Boolean( p_commit )
575: THEN
576: COMMIT WORK;
577: END IF;
579:
580: -- Debug Message
581: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
582:
583: -- Standard call to get message count and if count is 1, get message info.
584: FND_MSG_PUB.Count_And_Get
585: (p_count => x_msg_count,
586: p_data => x_msg_data
587: );
593:
594: WHEN FND_API.G_EXC_ERROR THEN
595: ROLLBACK TO UPDATE_Process_PVT;
596: x_return_status := FND_API.G_RET_STS_ERROR;
597: -- Standard call to get message count and if count=1, get the message
598: FND_MSG_PUB.Count_And_Get (
599: p_encoded => FND_API.G_FALSE,
600: p_count => x_msg_count,
601: p_data => x_msg_data
603:
604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
605: ROLLBACK TO UPDATE_Process_PVT;
606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
607: -- Standard call to get message count and if count=1, get the message
608: FND_MSG_PUB.Count_And_Get (
609: p_encoded => FND_API.G_FALSE,
610: p_count => x_msg_count,
611: p_data => x_msg_data
617: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
618: THEN
619: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
620: END IF;
621: -- Standard call to get message count and if count=1, get the message
622: FND_MSG_PUB.Count_And_Get (
623: p_encoded => FND_API.G_FALSE,
624: p_count => x_msg_count,
625: p_data => x_msg_data
644: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
645: l_object_version_number NUMBER;
646:
647: BEGIN
648: -- Standard Start of API savepoint
649: SAVEPOINT DELETE_Process_PVT;
650:
651: -- Standard call to check for call compatibility.
652: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
647: BEGIN
648: -- Standard Start of API savepoint
649: SAVEPOINT DELETE_Process_PVT;
650:
651: -- Standard call to check for call compatibility.
652: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
653: p_api_version_number,
654: l_api_name,
655: G_PKG_NAME)
682: --
683: -- End of API body
684: --
685:
686: -- Standard check for p_commit
687: IF FND_API.to_Boolean( p_commit )
688: THEN
689: COMMIT WORK;
690: END IF;
692:
693: -- Debug Message
694: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
695:
696: -- Standard call to get message count and if count is 1, get message info.
697: FND_MSG_PUB.Count_And_Get
698: (p_count => x_msg_count,
699: p_data => x_msg_data
700: );
706:
707: WHEN FND_API.G_EXC_ERROR THEN
708: ROLLBACK TO DELETE_Process_PVT;
709: x_return_status := FND_API.G_RET_STS_ERROR;
710: -- Standard call to get message count and if count=1, get the message
711: FND_MSG_PUB.Count_And_Get (
712: p_encoded => FND_API.G_FALSE,
713: p_count => x_msg_count,
714: p_data => x_msg_data
716:
717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
718: ROLLBACK TO DELETE_Process_PVT;
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720: -- Standard call to get message count and if count=1, get the message
721: FND_MSG_PUB.Count_And_Get (
722: p_encoded => FND_API.G_FALSE,
723: p_count => x_msg_count,
724: p_data => x_msg_data
730: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
731: THEN
732: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
733: END IF;
734: -- Standard call to get message count and if count=1, get the message
735: FND_MSG_PUB.Count_And_Get (
736: p_encoded => FND_API.G_FALSE,
737: p_count => x_msg_count,
738: p_data => x_msg_data
777: THEN
778: FND_MSG_PUB.initialize;
779: END IF;
780:
781: -- Standard call to check for call compatibility.
782: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
783: p_api_version_number,
784: l_api_name,
785: G_PKG_NAME)
824:
825: WHEN FND_API.G_EXC_ERROR THEN
826: ROLLBACK TO LOCK_Process_PVT;
827: x_return_status := FND_API.G_RET_STS_ERROR;
828: -- Standard call to get message count and if count=1, get the message
829: FND_MSG_PUB.Count_And_Get (
830: p_encoded => FND_API.G_FALSE,
831: p_count => x_msg_count,
832: p_data => x_msg_data
834:
835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
836: ROLLBACK TO LOCK_Process_PVT;
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
838: -- Standard call to get message count and if count=1, get the message
839: FND_MSG_PUB.Count_And_Get (
840: p_encoded => FND_API.G_FALSE,
841: p_count => x_msg_count,
842: p_data => x_msg_data
848: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
849: THEN
850: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
851: END IF;
852: -- Standard call to get message count and if count=1, get the message
853: FND_MSG_PUB.Count_And_Get (
854: p_encoded => FND_API.G_FALSE,
855: p_count => x_msg_count,
856: p_data => x_msg_data
1268: l_object_version_number NUMBER;
1269: l_process_rec AMW_Process_PVT.process_rec_type;
1270:
1271: BEGIN
1272: -- Standard Start of API savepoint
1273: SAVEPOINT VALIDATE_Process_;
1274:
1275: -- Standard call to check for call compatibility.
1276: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1271: BEGIN
1272: -- Standard Start of API savepoint
1273: SAVEPOINT VALIDATE_Process_;
1274:
1275: -- Standard call to check for call compatibility.
1276: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1277: p_api_version_number,
1278: l_api_name,
1279: G_PKG_NAME)
1332:
1333: -- Debug Message
1334: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1335:
1336: -- Standard call to get message count and if count is 1, get message info.
1337: FND_MSG_PUB.Count_And_Get
1338: (p_count => x_msg_count,
1339: p_data => x_msg_data
1340: );
1346:
1347: WHEN FND_API.G_EXC_ERROR THEN
1348: ROLLBACK TO VALIDATE_Process_;
1349: x_return_status := FND_API.G_RET_STS_ERROR;
1350: -- Standard call to get message count and if count=1, get the message
1351: FND_MSG_PUB.Count_And_Get (
1352: p_encoded => FND_API.G_FALSE,
1353: p_count => x_msg_count,
1354: p_data => x_msg_data
1356:
1357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1358: ROLLBACK TO VALIDATE_Process_;
1359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1360: -- Standard call to get message count and if count=1, get the message
1361: FND_MSG_PUB.Count_And_Get (
1362: p_encoded => FND_API.G_FALSE,
1363: p_count => x_msg_count,
1364: p_data => x_msg_data
1370: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1371: THEN
1372: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1373: END IF;
1374: -- Standard call to get message count and if count=1, get the message
1375: FND_MSG_PUB.Count_And_Get (
1376: p_encoded => FND_API.G_FALSE,
1377: p_count => x_msg_count,
1378: p_data => x_msg_data
1405: -- x_return_status := FND_API.G_RET_STS_ERROR;
1406:
1407: -- Debug Message
1408: AMW_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1409: -- Standard call to get message count and if count is 1, get message info.
1410: FND_MSG_PUB.Count_And_Get
1411: (p_count => x_msg_count,
1412: p_data => x_msg_data
1413: );