[Home] [Help]
37: flag boolean :=false;
38:
39:
40: BEGIN
41: -- Standard Start of API savepoint
42: SAVEPOINT create_process_setup_pvt;
43:
44: -- Standard call to check for call compatibility.
45: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
40: BEGIN
41: -- Standard Start of API savepoint
42: SAVEPOINT create_process_setup_pvt;
43:
44: -- Standard call to check for call compatibility.
45: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
46: p_api_version_number,
47: l_api_name,
48: G_PKG_NAME)
287: OZF_UTILITY_PVT.debug_message('flag was false');
288: end if ;
289: END LOOP;
290: -- RAISE FND_API.G_EXC_ERROR;
291: -- Standard check for p_commit
292: IF FND_API.to_Boolean( p_commit )
293: THEN
294: COMMIT WORK;
295: END IF;
298: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
299: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
300: END IF;
301:
302: -- Standard call to get message count and if count is 1, get message info.
303: FND_MSG_PUB.Count_And_Get
304: (p_count => x_msg_count,
305: p_data => x_msg_data
306: );
316: END IF;
317: WHEN FND_API.G_EXC_ERROR THEN
318: ROLLBACK TO create_process_setup_pvt;
319: x_return_status := FND_API.G_RET_STS_ERROR;
320: -- Standard call to get message count and if count=1, get the message
321: FND_MSG_PUB.Count_And_Get (
322: p_encoded => FND_API.G_FALSE,
323: p_count => x_msg_count,
324: p_data => x_msg_data
325: );
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
327: ROLLBACK TO create_process_setup_pvt;
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
329: -- Standard call to get message count and if count=1, get the message
330: FND_MSG_PUB.Count_And_Get (
331: p_encoded => FND_API.G_FALSE,
332: p_count => x_msg_count,
333: p_data => x_msg_data
338: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
339: THEN
340: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
341: END IF;
342: -- Standard call to get message count and if count=1, get the message
343: FND_MSG_PUB.Count_And_Get (
344: p_encoded => FND_API.G_FALSE,
345: p_count => x_msg_count,
346: p_data => x_msg_data
412: p_process_setup_rec process_setup_rec_type;
413:
414:
415: BEGIN
416: -- Standard Start of API savepoint
417: SAVEPOINT update_process_setup_pvt;
418:
419: -- Standard call to check for call compatibility.
420: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
415: BEGIN
416: -- Standard Start of API savepoint
417: SAVEPOINT update_process_setup_pvt;
418:
419: -- Standard call to check for call compatibility.
420: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
421: p_api_version_number,
422: l_api_name,
423: G_PKG_NAME)
607:
608: END LOOP;
609: --END IF;
610:
611: -- Standard check for p_commit
612: IF FND_API.to_Boolean( p_commit )
613: THEN
614: COMMIT WORK;
615: END IF;
618: -- Debug Message
619: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
620: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
621: END IF;
622: -- Standard call to get message count and if count is 1, get message info.
623: FND_MSG_PUB.Count_And_Get
624: (p_count => x_msg_count,
625: p_data => x_msg_data
626: );
627: EXCEPTION
628: WHEN FND_API.G_EXC_ERROR THEN
629: ROLLBACK TO update_process_setup_pvt;
630: x_return_status := FND_API.G_RET_STS_ERROR;
631: -- Standard call to get message count and if count=1, get the message
632: FND_MSG_PUB.Count_And_Get (
633: p_encoded => FND_API.G_FALSE,
634: p_count => x_msg_count,
635: p_data => x_msg_data
636: );
637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
638: ROLLBACK TO update_process_setup_pvt;
639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
640: -- Standard call to get message count and if count=1, get the message
641: FND_MSG_PUB.Count_And_Get (
642: p_encoded => FND_API.G_FALSE,
643: p_count => x_msg_count,
644: p_data => x_msg_data
649: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
650: THEN
651: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
652: END IF;
653: -- Standard call to get message count and if count=1, get the message
654: FND_MSG_PUB.Count_And_Get (
655: p_encoded => FND_API.G_FALSE,
656: p_count => x_msg_count,
657: p_data => x_msg_data
689: l_cc_cnt NUMBER := 0;
690: l_up_cnt NUMBER := 0;
691:
692: BEGIN
693: -- Standard Start of API savepoint
694: SAVEPOINT update_process_setup_tbl_pvt;
695:
696: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
697: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
696: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
697: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
698: END IF;
699:
700: -- Standard call to check for call compatibility.
701: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
702: p_api_version_number,
703: l_api_name,
704: G_PKG_NAME)
813: RAISE FND_API.G_EXC_ERROR;
814: END IF;
815: END IF;
816:
817: -- Standard check for p_commit
818: IF FND_API.to_Boolean( p_commit )
819: THEN
820: COMMIT WORK;
821: END IF;
823: -- Debug Message
824: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
825: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
826: END IF;
827: -- Standard call to get message count and if count is 1, get message info.
828: FND_MSG_PUB.Count_And_Get
829: (p_count => x_msg_count,
830: p_data => x_msg_data
831: );
832: EXCEPTION
833: WHEN FND_API.G_EXC_ERROR THEN
834: ROLLBACK TO update_process_setup_tbl_pvt;
835: x_return_status := FND_API.G_RET_STS_ERROR;
836: -- Standard call to get message count and if count=1, get the message
837: FND_MSG_PUB.Count_And_Get (
838: p_encoded => FND_API.G_FALSE,
839: p_count => x_msg_count,
840: p_data => x_msg_data
841: );
842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
843: ROLLBACK TO update_process_setup_tbl_pvt;
844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
845: -- Standard call to get message count and if count=1, get the message
846: FND_MSG_PUB.Count_And_Get (
847: p_encoded => FND_API.G_FALSE,
848: p_count => x_msg_count,
849: p_data => x_msg_data
854: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
855: THEN
856: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
857: END IF;
858: -- Standard call to get message count and if count=1, get the message
859: FND_MSG_PUB.Count_And_Get (
860: p_encoded => FND_API.G_FALSE,
861: p_count => x_msg_count,
862: p_data => x_msg_data
1053: l_process_setup_rec process_setup_rec_type ;
1054:
1055:
1056: BEGIN
1057: -- Standard Start of API savepoint
1058: SAVEPOINT validate_process_setup_pvt;
1059:
1060: -- Standard call to check for call compatibility.
1061: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1056: BEGIN
1057: -- Standard Start of API savepoint
1058: SAVEPOINT validate_process_setup_pvt;
1059:
1060: -- Standard call to check for call compatibility.
1061: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1062: p_api_version_number,
1063: l_api_name,
1064: G_PKG_NAME)
1107:
1108: END IF;
1109: -- Initialize API return status to SUCCESS
1110: x_return_status := FND_API.G_RET_STS_SUCCESS;
1111: -- Standard call to get message count and if count is 1, get message info.
1112: FND_MSG_PUB.Count_And_Get
1113: (p_count => x_msg_count,
1114: p_data => x_msg_data
1115: );
1122: END IF;
1123: WHEN FND_API.G_EXC_ERROR THEN
1124: ROLLBACK TO validate_process_setup_pvt;
1125: x_return_status := FND_API.G_RET_STS_ERROR;
1126: -- Standard call to get message count and if count=1, get the message
1127: FND_MSG_PUB.Count_And_Get (
1128: p_encoded => FND_API.G_FALSE,
1129: p_count => x_msg_count,
1130: p_data => x_msg_data
1131: );
1132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1133: ROLLBACK TO validate_process_setup_pvt;
1134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1135: -- Standard call to get message count and if count=1, get the message
1136: FND_MSG_PUB.Count_And_Get (
1137: p_encoded => FND_API.G_FALSE,
1138: p_count => x_msg_count,
1139: p_data => x_msg_data
1144: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1145: THEN
1146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1147: END IF;
1148: -- Standard call to get message count and if count=1, get the message
1149: FND_MSG_PUB.Count_And_Get (
1150: p_encoded => FND_API.G_FALSE,
1151: p_count => x_msg_count,
1152: p_data => x_msg_data