DBA Data[Home] [Help]

APPS.ENG_RELATED_ENTITY_PKG dependencies on FND_API

Line 114: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --

110: --added l_to_current _value as defination change from DOm side.
111: Procedure Implement_Relationship_Changes
112: (
113: p_api_version IN NUMBER --
114: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
115: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
116: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
117: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
118: ,p_output_dir IN VARCHAR2 := NULL --

Line 115: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --

111: Procedure Implement_Relationship_Changes
112: (
113: p_api_version IN NUMBER --
114: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
115: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
116: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
117: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
118: ,p_output_dir IN VARCHAR2 := NULL --
119: ,p_debug_filename IN VARCHAR2 := 'ENGRENTB.Implement_Relationship_Changes.log'

Line 116: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

112: (
113: p_api_version IN NUMBER --
114: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
115: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
116: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
117: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
118: ,p_output_dir IN VARCHAR2 := NULL --
119: ,p_debug_filename IN VARCHAR2 := 'ENGRENTB.Implement_Relationship_Changes.log'
120: ,x_return_status OUT NOCOPY VARCHAR2 --

Line 117: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --

113: p_api_version IN NUMBER --
114: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
115: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
116: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
117: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
118: ,p_output_dir IN VARCHAR2 := NULL --
119: ,p_debug_filename IN VARCHAR2 := 'ENGRENTB.Implement_Relationship_Changes.log'
120: ,x_return_status OUT NOCOPY VARCHAR2 --
121: ,x_msg_count OUT NOCOPY NUMBER --

Line 172: IF NOT FND_API.Compatible_API_Call ( l_api_version

168: --End if;
169:
170:
171: -- Standard call to check for call compatibility
172: IF NOT FND_API.Compatible_API_Call ( l_api_version
173: ,p_api_version
174: ,l_api_name
175: ,G_PKG_NAME )
176: THEN

Line 177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

173: ,p_api_version
174: ,l_api_name
175: ,G_PKG_NAME )
176: THEN
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: END IF;
179:
180: -- Initialize message list if p_init_msg_list is set to TRUE.
181: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 181: IF FND_API.to_Boolean( p_init_msg_list ) THEN

177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: END IF;
179:
180: -- Initialize message list if p_init_msg_list is set to TRUE.
181: IF FND_API.to_Boolean( p_init_msg_list ) THEN
182: FND_MSG_PUB.initialize;
183: END IF ;
184: -- For Test/Debug
185: IF FND_API.to_Boolean( p_debug ) THEN

Line 185: IF FND_API.to_Boolean( p_debug ) THEN

181: IF FND_API.to_Boolean( p_init_msg_list ) THEN
182: FND_MSG_PUB.initialize;
183: END IF ;
184: -- For Test/Debug
185: IF FND_API.to_Boolean( p_debug ) THEN
186: Open_Debug_Session(p_output_dir, p_debug_filename ) ;
187: END IF ;
188:
189: -- Write debug message if debug mode is on

Line 199: x_return_status := FND_API.G_RET_STS_SUCCESS;

195: Write_Debug('-----------------------------------------------------');
196: Write_Debug('Initializing return status... ' );
197: END IF ;
198: -- Initialize API return status to success
199: x_return_status := FND_API.G_RET_STS_SUCCESS;
200:
201:
202: -- Real code starts here -----------------------------------------------
203:

Line 256: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

252: X_MSG_COUNT => l_msg_count,
253: X_MSG_DATA => l_msg_data
254: );
255:
256: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
258: EXIT;
259: END IF;
260:

Line 257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

253: X_MSG_DATA => l_msg_data
254: );
255:
256: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
258: EXIT;
259: END IF;
260:
261: IF ( l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 261: IF ( l_return_status = FND_API.G_RET_STS_ERROR) THEN

257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
258: EXIT;
259: END IF;
260:
261: IF ( l_return_status = FND_API.G_RET_STS_ERROR) THEN
262: RAISE duplicate_related_doc;
263: EXIT;
264: END IF;
265: END LOOP;

Line 280: x_return_status := FND_API.G_RET_STS_ERROR;

276:
277: EXCEPTION
278: WHEN change_policy_defined THEN
279: ROLLBACK TO Implement_Relationship_Changes;
280: x_return_status := FND_API.G_RET_STS_ERROR;
281: x_msg_count := 1;
282: x_msg_data := 'Error: This Change Order has documents with floating revision that are under change required change policy. Such CO cannot be implemented';
283: -- BIS_COLLECTION_UTILITIES.log('In exception'|| x_msg_data);
284: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);

Line 287: x_return_status := FND_API.G_RET_STS_ERROR;

283: -- BIS_COLLECTION_UTILITIES.log('In exception'|| x_msg_data);
284: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);
285: WHEN duplicate_related_doc THEN
286: ROLLBACK TO Implement_Relationship_Changes;
287: x_return_status := FND_API.G_RET_STS_ERROR;
288: x_msg_count := 1;
289: x_msg_data := 'Error: Duplicate operation on same related document of item . ';
290: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);
291: WHEN FND_API.G_EXC_ERROR THEN

Line 291: WHEN FND_API.G_EXC_ERROR THEN

287: x_return_status := FND_API.G_RET_STS_ERROR;
288: x_msg_count := 1;
289: x_msg_data := 'Error: Duplicate operation on same related document of item . ';
290: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);
291: WHEN FND_API.G_EXC_ERROR THEN
292: ROLLBACK TO Implement_Relationship_Changes;
293: x_return_status := FND_API.G_RET_STS_ERROR;
294: FND_MSG_PUB.Count_And_Get
295: ( p_count => l_msg_count

Line 293: x_return_status := FND_API.G_RET_STS_ERROR;

289: x_msg_data := 'Error: Duplicate operation on same related document of item . ';
290: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);
291: WHEN FND_API.G_EXC_ERROR THEN
292: ROLLBACK TO Implement_Relationship_Changes;
293: x_return_status := FND_API.G_RET_STS_ERROR;
294: FND_MSG_PUB.Count_And_Get
295: ( p_count => l_msg_count
296: ,p_data => l_msg_data );
297: --BIS_COLLECTION_UTILITIES.log('In exception'|| l_msg_data);

Line 304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

300: Write_Debug('Error Msg ' || l_msg_data);
301: Write_Debug('Rollback and Finish with expected error.') ;
302: Close_Debug_Session ;
303: END IF ;
304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
305: ROLLBACK TO Implement_Relationship_Changes;
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307: FND_MSG_PUB.Count_And_Get
308: ( p_count => l_msg_count

Line 306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

302: Close_Debug_Session ;
303: END IF ;
304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
305: ROLLBACK TO Implement_Relationship_Changes;
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307: FND_MSG_PUB.Count_And_Get
308: ( p_count => l_msg_count
309: ,p_data => l_msg_data );
310: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);

Line 318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

314: Close_Debug_Session ;
315: END IF ;
316: WHEN OTHERS THEN
317: ROLLBACK TO Implement_Relationship_Changes;
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
319: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
320: THEN
321: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
322: END IF;

Line 371: x_return_status := FND_API.G_RET_STS_SUCCESS;

367: BEGIN
368: SAVEPOINT Implement_Relationship_Changes;
369:
370: -- Initialize API return status to success
371: x_return_status := FND_API.G_RET_STS_SUCCESS;
372:
373: l_change_id := p_change_id;
374: l_revised_item_seq_id := p_rev_item_seq_id;
375: