42:
43: PROCEDURE Get_ReplacedRebuilds (
44:
45: p_api_version IN NUMBER,
46: p_commit IN VARCHAR2 := FND_API.G_FALSE,
47: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49:
50: p_wip_entity_id IN number,
43: PROCEDURE Get_ReplacedRebuilds (
44:
45: p_api_version IN NUMBER,
46: p_commit IN VARCHAR2 := FND_API.G_FALSE,
47: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49:
50: p_wip_entity_id IN number,
51: p_organization_id IN number,
44:
45: p_api_version IN NUMBER,
46: p_commit IN VARCHAR2 := FND_API.G_FALSE,
47: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49:
50: p_wip_entity_id IN number,
51: p_organization_id IN number,
52:
91:
92: -------------------------------------------------------------------------
93: -- standard call to check for call compatibility
94: -------------------------------------------------------------------------
95: IF NOT fnd_api.compatible_api_call (
96: l_api_version,
97: p_api_version,
98: l_api_name,
99: G_PKG_NAME ) then
97: p_api_version,
98: l_api_name,
99: G_PKG_NAME ) then
100:
101: RAISE fnd_api.g_exc_unexpected_error;
102:
103: END IF;
104:
105: ---------------------------------------------------------------------------
105: ---------------------------------------------------------------------------
106: -- Initialize message list if p_init_msg_list is set to TRUE
107: ---------------------------------------------------------------------------
108:
109: IF FND_API.to_Boolean(p_init_msg_list) THEN
110: FND_MSG_PUB.initialize;
111: END IF;
112:
113:
115: -- initialize api return status to success
116: -------------------------------------------------------------------------
117:
118: l_stmt_num := 10;
119: x_return_status := fnd_api.g_ret_sts_success;
120:
121: -------------------------------------------------------------------------
122: -- Validate parameters passed to the API
123: -------------------------------------------------------------------------
137:
138: FND_MSG_PUB.ADD_EXC_MSG('EAM_UTILITY_GRP', 'Get_ReplacedRebuild('
139: ||TO_CHAR(l_stmt_num)
140: ||'): ', l_api_message);
141: RAISE FND_API.g_exc_error;
142: END IF;
143:
144: -------------------------------------------------------------------------
145: -- Initialize common variables
178: p_data => x_msg_data );
179:
180: EXCEPTION
181:
182: WHEN fnd_api.g_exc_error THEN
183: x_return_status := fnd_api.g_ret_sts_error;
184:
185: -- Get message count and data
186: fnd_msg_pub.count_and_get
179:
180: EXCEPTION
181:
182: WHEN fnd_api.g_exc_error THEN
183: x_return_status := fnd_api.g_ret_sts_error;
184:
185: -- Get message count and data
186: fnd_msg_pub.count_and_get
187: ( p_count => x_msg_count
187: ( p_count => x_msg_count
188: , p_data => x_msg_data
189: );
190: --
191: WHEN fnd_api.g_exc_unexpected_error THEN
192: x_return_status := fnd_api.g_ret_sts_unexp_error ;
193:
194: -- Get message count and data
195: fnd_msg_pub.count_and_get
188: , p_data => x_msg_data
189: );
190: --
191: WHEN fnd_api.g_exc_unexpected_error THEN
192: x_return_status := fnd_api.g_ret_sts_unexp_error ;
193:
194: -- Get message count and data
195: fnd_msg_pub.count_and_get
196: ( p_count => x_msg_count
197: , p_data => x_msg_data
198: );
199:
200: WHEN OTHERS THEN
201: x_return_status := fnd_api.g_ret_sts_unexp_error ;
202: --
203: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
204: THEN
205: fnd_msg_pub.add_exc_msg