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.CN_IMP_MAPS_PVT dependencies on FND_API

Line 15: -- Default = FND_API.G_FALSE

11: -- Pre-reqs : None.
12: -- Parameters :
13: -- IN : p_api_version IN NUMBER Required
14: -- p_init_msg_list IN VARCHAR2 Optional
15: -- Default = FND_API.G_FALSE
16: -- p_commit IN VARCHAR2 Optional
17: -- Default = FND_API.G_FALSE
18: -- p_validation_level IN NUMBER Optional
19: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 17: -- Default = FND_API.G_FALSE

13: -- IN : p_api_version IN NUMBER Required
14: -- p_init_msg_list IN VARCHAR2 Optional
15: -- Default = FND_API.G_FALSE
16: -- p_commit IN VARCHAR2 Optional
17: -- Default = FND_API.G_FALSE
18: -- p_validation_level IN NUMBER Optional
19: -- Default = FND_API.G_VALID_LEVEL_FULL
20: -- p_imp_header_id IN NUMBER,
21: -- p_src_column_num IN NUMBER,

Line 19: -- Default = FND_API.G_VALID_LEVEL_FULL

15: -- Default = FND_API.G_FALSE
16: -- p_commit IN VARCHAR2 Optional
17: -- Default = FND_API.G_FALSE
18: -- p_validation_level IN NUMBER Optional
19: -- Default = FND_API.G_VALID_LEVEL_FULL
20: -- p_imp_header_id IN NUMBER,
21: -- p_src_column_num IN NUMBER,
22: -- p_imp_map IN imp_maps_rec_type
23: -- p_source_fields IN v_Tbl_Type ,

Line 38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

34: --
35: -- End of comments
36: PROCEDURE Create_Mapping
37: ( p_api_version IN NUMBER ,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: x_return_status OUT NOCOPY VARCHAR2 ,
42: x_msg_count OUT NOCOPY NUMBER ,

Line 39: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

35: -- End of comments
36: PROCEDURE Create_Mapping
37: ( p_api_version IN NUMBER ,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: x_return_status OUT NOCOPY VARCHAR2 ,
42: x_msg_count OUT NOCOPY NUMBER ,
43: x_msg_data OUT NOCOPY VARCHAR2 ,

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

36: PROCEDURE Create_Mapping
37: ( p_api_version IN NUMBER ,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: x_return_status OUT NOCOPY VARCHAR2 ,
42: x_msg_count OUT NOCOPY NUMBER ,
43: x_msg_data OUT NOCOPY VARCHAR2 ,
44: p_imp_header_id IN NUMBER,

Line 68: IF NOT FND_API.compatible_api_call

64: BEGIN
65: -- Standard Start of API savepoint
66: SAVEPOINT Create_Mapping;
67: -- Standard call to check for call compatibility.
68: IF NOT FND_API.compatible_api_call
69: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
70: THEN
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;

Line 71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

67: -- Standard call to check for call compatibility.
68: IF NOT FND_API.compatible_api_call
69: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
70: THEN
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;
73: -- Initialize message list if p_init_msg_list is set to TRUE.
74: IF FND_API.to_Boolean( p_init_msg_list ) THEN
75: FND_MSG_PUB.initialize;

Line 74: IF FND_API.to_Boolean( p_init_msg_list ) THEN

70: THEN
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;
73: -- Initialize message list if p_init_msg_list is set to TRUE.
74: IF FND_API.to_Boolean( p_init_msg_list ) THEN
75: FND_MSG_PUB.initialize;
76: END IF;
77: -- Initialize API return status to success
78: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 78: x_return_status := FND_API.G_RET_STS_SUCCESS;

74: IF FND_API.to_Boolean( p_init_msg_list ) THEN
75: FND_MSG_PUB.initialize;
76: END IF;
77: -- Initialize API return status to success
78: x_return_status := FND_API.G_RET_STS_SUCCESS;
79: -- API body
80: -- ----------------------
81: -- CREATE IMP_MAP
82: -- ----------------------

Line 94: IF x_return_status <> FND_API.g_ret_sts_success THEN

90: x_msg_data => x_msg_data ,
91: p_imp_map => p_imp_map,
92: x_imp_map_id => x_imp_map_id);
93: l_imp_map.imp_map_id := x_imp_map_id;
94: IF x_return_status <> FND_API.g_ret_sts_success THEN
95: RAISE FND_API.G_EXC_ERROR;
96: END IF;
97: ELSE
98: -- check locking mechanism

Line 95: RAISE FND_API.G_EXC_ERROR;

91: p_imp_map => p_imp_map,
92: x_imp_map_id => x_imp_map_id);
93: l_imp_map.imp_map_id := x_imp_map_id;
94: IF x_return_status <> FND_API.g_ret_sts_success THEN
95: RAISE FND_API.G_EXC_ERROR;
96: END IF;
97: ELSE
98: -- check locking mechanism
99: BEGIN

Line 113: RAISE FND_API.G_EXC_ERROR ;

109: THEN
110: FND_MESSAGE.SET_NAME ('CN','CN_REC_NOT_EXISTS');
111: FND_MSG_PUB.Add;
112: END IF;
113: RAISE FND_API.G_EXC_ERROR ;
114: END;
115: IF l_imp_map.object_version_number >
116: p_imp_map.object_version_number THEN
117: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 122: RAISE FND_API.G_EXC_ERROR ;

118: THEN
119: FND_MESSAGE.SET_NAME ('CN' , 'CN_RECORD_CHANGED');
120: FND_MSG_PUB.Add;
121: END IF;
122: RAISE FND_API.G_EXC_ERROR ;
123: END IF;
124: -- update cn_imp_maps object_version_number for new mapping
125: UPDATE cn_imp_maps
126: SET object_version_number = l_imp_map.object_version_number + 1

Line 171: RAISE FND_API.G_EXC_ERROR ;

167: FND_MESSAGE.SET_NAME ('CN' , 'CN_IMP_MAP_HEADER_TOO_LARGE');
168: FND_MESSAGE.SET_TOKEN('COLUMN_HEADER',p_source_fields(i).text);
169: FND_MSG_PUB.Add;
170: END IF;
171: RAISE FND_API.G_EXC_ERROR ;
172: END IF;
173:
174: l_imp_map_field.source_user_column := p_source_fields(i).text;
175:

Line 205: RAISE FND_API.G_EXC_ERROR ;

201: THEN
202: FND_MESSAGE.SET_NAME ('CN','CN_IMP_REQFLD_NOT_MAP');
203: FND_MSG_PUB.Add;
204: END IF;
205: RAISE FND_API.G_EXC_ERROR ;
206: END IF;
207: EXCEPTION
208: WHEN no_data_found THEN
209: NULL;

Line 222: IF FND_API.To_Boolean( p_commit ) THEN

218:
219: -- End of API body.
220:
221: -- Standard check of p_commit.
222: IF FND_API.To_Boolean( p_commit ) THEN
223: COMMIT WORK;
224: END IF;
225: -- Standard call to get message count and if count is 1, get message info.
226: FND_MSG_PUB.Count_And_Get(

Line 229: p_encoded => FND_API.G_FALSE

225: -- Standard call to get message count and if count is 1, get message info.
226: FND_MSG_PUB.Count_And_Get(
227: p_count => x_msg_count ,
228: p_data => x_msg_data ,
229: p_encoded => FND_API.G_FALSE
230: );
231:
232: EXCEPTION
233: WHEN FND_API.G_EXC_ERROR THEN

Line 233: WHEN FND_API.G_EXC_ERROR THEN

229: p_encoded => FND_API.G_FALSE
230: );
231:
232: EXCEPTION
233: WHEN FND_API.G_EXC_ERROR THEN
234: ROLLBACK TO Create_Mapping ;
235: x_return_status := FND_API.G_RET_STS_ERROR ;
236: FND_MSG_PUB.Count_And_Get(
237: p_count => x_msg_count ,

Line 235: x_return_status := FND_API.G_RET_STS_ERROR ;

231:
232: EXCEPTION
233: WHEN FND_API.G_EXC_ERROR THEN
234: ROLLBACK TO Create_Mapping ;
235: x_return_status := FND_API.G_RET_STS_ERROR ;
236: FND_MSG_PUB.Count_And_Get(
237: p_count => x_msg_count ,
238: p_data => x_msg_data ,
239: p_encoded => FND_API.G_FALSE

Line 239: p_encoded => FND_API.G_FALSE

235: x_return_status := FND_API.G_RET_STS_ERROR ;
236: FND_MSG_PUB.Count_And_Get(
237: p_count => x_msg_count ,
238: p_data => x_msg_data ,
239: p_encoded => FND_API.G_FALSE
240: );
241:
242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
243: ROLLBACK TO Create_Mapping ;

Line 242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

238: p_data => x_msg_data ,
239: p_encoded => FND_API.G_FALSE
240: );
241:
242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
243: ROLLBACK TO Create_Mapping ;
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
245: FND_MSG_PUB.Count_And_Get(
246: p_count => x_msg_count ,

Line 244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

240: );
241:
242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
243: ROLLBACK TO Create_Mapping ;
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
245: FND_MSG_PUB.Count_And_Get(
246: p_count => x_msg_count ,
247: p_data => x_msg_data ,
248: p_encoded => FND_API.G_FALSE

Line 248: p_encoded => FND_API.G_FALSE

244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
245: FND_MSG_PUB.Count_And_Get(
246: p_count => x_msg_count ,
247: p_data => x_msg_data ,
248: p_encoded => FND_API.G_FALSE
249: );
250:
251: WHEN OTHERS THEN
252: ROLLBACK TO Create_Mapping ;

Line 253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

249: );
250:
251: WHEN OTHERS THEN
252: ROLLBACK TO Create_Mapping ;
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
254: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
255: THEN
256: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
257: END IF;

Line 262: p_encoded => FND_API.G_FALSE

258: FND_MSG_PUB.Count_And_Get
259: (
260: p_count => x_msg_count ,
261: p_data => x_msg_data ,
262: p_encoded => FND_API.G_FALSE
263: );
264: END Create_Mapping;
265:
266:

Line 274: -- Default = FND_API.G_FALSE

270: -- Function :
271: -- Pre-reqs : None.
272: -- Parameters :
273: -- IN : p_api_version IN NUMBER Required-- p_init_msg_list IN VARCHAR2 Optional
274: -- Default = FND_API.G_FALSE
275: -- p_commit IN VARCHAR2 Optional
276: -- Default = FND_API.G_FALSE
277: -- p_validation_level IN NUMBER Optional
278: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 276: -- Default = FND_API.G_FALSE

272: -- Parameters :
273: -- IN : p_api_version IN NUMBER Required-- p_init_msg_list IN VARCHAR2 Optional
274: -- Default = FND_API.G_FALSE
275: -- p_commit IN VARCHAR2 Optional
276: -- Default = FND_API.G_FALSE
277: -- p_validation_level IN NUMBER Optional
278: -- Default = FND_API.G_VALID_LEVEL_FULL
279: -- p_imp_header_id IN NUMBER,
280: -- p_imp_map IN imp_maps_rec_type

Line 278: -- Default = FND_API.G_VALID_LEVEL_FULL

274: -- Default = FND_API.G_FALSE
275: -- p_commit IN VARCHAR2 Optional
276: -- Default = FND_API.G_FALSE
277: -- p_validation_level IN NUMBER Optional
278: -- Default = FND_API.G_VALID_LEVEL_FULL
279: -- p_imp_header_id IN NUMBER,
280: -- p_imp_map IN imp_maps_rec_type
281: -- p_source_fields IN MAP_FIELD_TBL_TYPE
282: -- p_target_fields IN MAP_FIELD_TBL_TYPE

Line 297: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

293: --
294: -- End of comments
295: PROCEDURE retrieve_Fields
296: ( p_api_version IN NUMBER ,
297: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
298: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
299: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
300: x_return_status OUT NOCOPY VARCHAR2 ,
301: x_msg_count OUT NOCOPY NUMBER ,

Line 298: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

294: -- End of comments
295: PROCEDURE retrieve_Fields
296: ( p_api_version IN NUMBER ,
297: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
298: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
299: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
300: x_return_status OUT NOCOPY VARCHAR2 ,
301: x_msg_count OUT NOCOPY NUMBER ,
302: x_msg_data OUT NOCOPY VARCHAR2 ,

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

295: PROCEDURE retrieve_Fields
296: ( p_api_version IN NUMBER ,
297: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
298: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
299: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
300: x_return_status OUT NOCOPY VARCHAR2 ,
301: x_msg_count OUT NOCOPY NUMBER ,
302: x_msg_data OUT NOCOPY VARCHAR2 ,
303: p_imp_map_id IN NUMBER ,

Line 364: IF NOT FND_API.compatible_api_call

360: BEGIN
361: -- Standard Start of API savepoint
362: SAVEPOINT retrieve_Fields;
363: -- Standard call to check for call compatibility.
364: IF NOT FND_API.compatible_api_call
365: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
366: THEN
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
368: END IF;

Line 367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

363: -- Standard call to check for call compatibility.
364: IF NOT FND_API.compatible_api_call
365: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
366: THEN
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
368: END IF;
369: -- Initialize message list if p_init_msg_list is set to TRUE.
370: IF FND_API.to_Boolean( p_init_msg_list ) THEN
371: FND_MSG_PUB.initialize;

Line 370: IF FND_API.to_Boolean( p_init_msg_list ) THEN

366: THEN
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
368: END IF;
369: -- Initialize message list if p_init_msg_list is set to TRUE.
370: IF FND_API.to_Boolean( p_init_msg_list ) THEN
371: FND_MSG_PUB.initialize;
372: END IF;
373: -- Initialize API return status to success
374: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 374: x_return_status := FND_API.G_RET_STS_SUCCESS;

370: IF FND_API.to_Boolean( p_init_msg_list ) THEN
371: FND_MSG_PUB.initialize;
372: END IF;
373: -- Initialize API return status to success
374: x_return_status := FND_API.G_RET_STS_SUCCESS;
375: -- API body
376: x_source_fields := G_MISS_MAP_FIELD_TBL;
377: x_target_fields := G_MISS_MAP_FIELD_TBL;
378: x_mapped_fields := G_MISS_MAP_FIELD_TBL;

Line 458: IF FND_API.To_Boolean( p_commit ) THEN

454: END IF;
455: -- End of API body.
456:
457: -- Standard check of p_commit.
458: IF FND_API.To_Boolean( p_commit ) THEN
459: COMMIT WORK;
460: END IF;
461: -- Standard call to get message count and if count is 1, get message info.
462: FND_MSG_PUB.Count_And_Get(

Line 465: p_encoded => FND_API.G_FALSE

461: -- Standard call to get message count and if count is 1, get message info.
462: FND_MSG_PUB.Count_And_Get(
463: p_count => x_msg_count ,
464: p_data => x_msg_data ,
465: p_encoded => FND_API.G_FALSE
466: );
467:
468: EXCEPTION
469: WHEN FND_API.G_EXC_ERROR THEN

Line 469: WHEN FND_API.G_EXC_ERROR THEN

465: p_encoded => FND_API.G_FALSE
466: );
467:
468: EXCEPTION
469: WHEN FND_API.G_EXC_ERROR THEN
470: ROLLBACK TO retrieve_Fields ;
471: x_return_status := FND_API.G_RET_STS_ERROR ;
472: FND_MSG_PUB.Count_And_Get(
473: p_count => x_msg_count ,

Line 471: x_return_status := FND_API.G_RET_STS_ERROR ;

467:
468: EXCEPTION
469: WHEN FND_API.G_EXC_ERROR THEN
470: ROLLBACK TO retrieve_Fields ;
471: x_return_status := FND_API.G_RET_STS_ERROR ;
472: FND_MSG_PUB.Count_And_Get(
473: p_count => x_msg_count ,
474: p_data => x_msg_data ,
475: p_encoded => FND_API.G_FALSE

Line 475: p_encoded => FND_API.G_FALSE

471: x_return_status := FND_API.G_RET_STS_ERROR ;
472: FND_MSG_PUB.Count_And_Get(
473: p_count => x_msg_count ,
474: p_data => x_msg_data ,
475: p_encoded => FND_API.G_FALSE
476: );
477:
478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
479: ROLLBACK TO retrieve_Fields ;

Line 478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

474: p_data => x_msg_data ,
475: p_encoded => FND_API.G_FALSE
476: );
477:
478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
479: ROLLBACK TO retrieve_Fields ;
480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
481: FND_MSG_PUB.Count_And_Get(
482: p_count => x_msg_count ,

Line 480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

476: );
477:
478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
479: ROLLBACK TO retrieve_Fields ;
480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
481: FND_MSG_PUB.Count_And_Get(
482: p_count => x_msg_count ,
483: p_data => x_msg_data ,
484: p_encoded => FND_API.G_FALSE

Line 484: p_encoded => FND_API.G_FALSE

480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
481: FND_MSG_PUB.Count_And_Get(
482: p_count => x_msg_count ,
483: p_data => x_msg_data ,
484: p_encoded => FND_API.G_FALSE
485: );
486:
487: WHEN OTHERS THEN
488: ROLLBACK TO retrieve_Fields ;

Line 489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

485: );
486:
487: WHEN OTHERS THEN
488: ROLLBACK TO retrieve_Fields ;
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
490: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
491: THEN
492: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
493: END IF;

Line 498: p_encoded => FND_API.G_FALSE

494: FND_MSG_PUB.Count_And_Get
495: (
496: p_count => x_msg_count ,
497: p_data => x_msg_data ,
498: p_encoded => FND_API.G_FALSE
499: );
500: END retrieve_Fields;
501:
502:

Line 511: -- Default = FND_API.G_FALSE

507: -- Pre-reqs : None.
508: -- Parameters :
509: -- IN : p_api_version IN NUMBER Required
510: -- p_init_msg_list IN VARCHAR2 Optional
511: -- Default = FND_API.G_FALSE
512: -- p_commit IN VARCHAR2 Optional
513: -- Default = FND_API.G_FALSE
514: -- p_validation_level IN NUMBER Optional
515: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 513: -- Default = FND_API.G_FALSE

509: -- IN : p_api_version IN NUMBER Required
510: -- p_init_msg_list IN VARCHAR2 Optional
511: -- Default = FND_API.G_FALSE
512: -- p_commit IN VARCHAR2 Optional
513: -- Default = FND_API.G_FALSE
514: -- p_validation_level IN NUMBER Optional
515: -- Default = FND_API.G_VALID_LEVEL_FULL
516: -- p_imp_map IN imp_maps_rec_type
517: -- OUT : x_return_status OUT VARCHAR2(1)

Line 515: -- Default = FND_API.G_VALID_LEVEL_FULL

511: -- Default = FND_API.G_FALSE
512: -- p_commit IN VARCHAR2 Optional
513: -- Default = FND_API.G_FALSE
514: -- p_validation_level IN NUMBER Optional
515: -- Default = FND_API.G_VALID_LEVEL_FULL
516: -- p_imp_map IN imp_maps_rec_type
517: -- OUT : x_return_status OUT VARCHAR2(1)
518: -- x_msg_count OUT NUMBER
519: -- x_msg_data OUT VARCHAR2(2000)

Line 530: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

526: --
527: -- End of comments
528: PROCEDURE Create_Imp_Map
529: ( p_api_version IN NUMBER ,
530: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
531: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
532: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
533: x_return_status OUT NOCOPY VARCHAR2 ,
534: x_msg_count OUT NOCOPY NUMBER ,

Line 531: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

527: -- End of comments
528: PROCEDURE Create_Imp_Map
529: ( p_api_version IN NUMBER ,
530: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
531: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
532: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
533: x_return_status OUT NOCOPY VARCHAR2 ,
534: x_msg_count OUT NOCOPY NUMBER ,
535: x_msg_data OUT NOCOPY VARCHAR2 ,

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

528: PROCEDURE Create_Imp_Map
529: ( p_api_version IN NUMBER ,
530: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
531: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
532: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
533: x_return_status OUT NOCOPY VARCHAR2 ,
534: x_msg_count OUT NOCOPY NUMBER ,
535: x_msg_data OUT NOCOPY VARCHAR2 ,
536: p_imp_map IN imp_maps_rec_type,

Line 550: IF NOT FND_API.compatible_api_call

546: BEGIN
547: -- Standard Start of API savepoint
548: SAVEPOINT Create_Imp_map;
549: -- Standard call to check for call compatibility.
550: IF NOT FND_API.compatible_api_call
551: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
552: THEN
553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
554: END IF;

Line 553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

549: -- Standard call to check for call compatibility.
550: IF NOT FND_API.compatible_api_call
551: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
552: THEN
553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
554: END IF;
555: -- Initialize message list if p_init_msg_list is set to TRUE.
556: IF FND_API.to_Boolean( p_init_msg_list ) THEN
557: FND_MSG_PUB.initialize;

Line 556: IF FND_API.to_Boolean( p_init_msg_list ) THEN

552: THEN
553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
554: END IF;
555: -- Initialize message list if p_init_msg_list is set to TRUE.
556: IF FND_API.to_Boolean( p_init_msg_list ) THEN
557: FND_MSG_PUB.initialize;
558: END IF;
559: -- Initialize API return status to success
560: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 560: x_return_status := FND_API.G_RET_STS_SUCCESS;

556: IF FND_API.to_Boolean( p_init_msg_list ) THEN
557: FND_MSG_PUB.initialize;
558: END IF;
559: -- Initialize API return status to success
560: x_return_status := FND_API.G_RET_STS_SUCCESS;
561: -- API body
562: -- Check Name uniqueness
563: BEGIN
564: SELECT 1

Line 579: RAISE FND_API.G_EXC_ERROR ;

575: THEN
576: FND_MESSAGE.SET_NAME ('CN','CN_ALREADY_EXISTS');
577: FND_MSG_PUB.Add;
578: END IF;
579: RAISE FND_API.G_EXC_ERROR ;
580: END IF;
581:
582: -- Call API to create cn_imp_maps
583: l_imp_map := p_imp_map ;

Line 596: IF FND_API.To_Boolean( p_commit ) THEN

592:
593: -- End of API body.
594:
595: -- Standard check of p_commit.
596: IF FND_API.To_Boolean( p_commit ) THEN
597: COMMIT WORK;
598: END IF;
599: -- Standard call to get message count and if count is 1, get message info.
600: FND_MSG_PUB.Count_And_Get(

Line 603: p_encoded => FND_API.G_FALSE

599: -- Standard call to get message count and if count is 1, get message info.
600: FND_MSG_PUB.Count_And_Get(
601: p_count => x_msg_count ,
602: p_data => x_msg_data ,
603: p_encoded => FND_API.G_FALSE
604: );
605:
606: EXCEPTION
607: WHEN FND_API.G_EXC_ERROR THEN

Line 607: WHEN FND_API.G_EXC_ERROR THEN

603: p_encoded => FND_API.G_FALSE
604: );
605:
606: EXCEPTION
607: WHEN FND_API.G_EXC_ERROR THEN
608: ROLLBACK TO Create_Imp_map ;
609: x_return_status := FND_API.G_RET_STS_ERROR ;
610: FND_MSG_PUB.Count_And_Get(
611: p_count => x_msg_count ,

Line 609: x_return_status := FND_API.G_RET_STS_ERROR ;

605:
606: EXCEPTION
607: WHEN FND_API.G_EXC_ERROR THEN
608: ROLLBACK TO Create_Imp_map ;
609: x_return_status := FND_API.G_RET_STS_ERROR ;
610: FND_MSG_PUB.Count_And_Get(
611: p_count => x_msg_count ,
612: p_data => x_msg_data ,
613: p_encoded => FND_API.G_FALSE

Line 613: p_encoded => FND_API.G_FALSE

609: x_return_status := FND_API.G_RET_STS_ERROR ;
610: FND_MSG_PUB.Count_And_Get(
611: p_count => x_msg_count ,
612: p_data => x_msg_data ,
613: p_encoded => FND_API.G_FALSE
614: );
615:
616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
617: ROLLBACK TO Create_Imp_map ;

Line 616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

612: p_data => x_msg_data ,
613: p_encoded => FND_API.G_FALSE
614: );
615:
616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
617: ROLLBACK TO Create_Imp_map ;
618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
619: FND_MSG_PUB.Count_And_Get(
620: p_count => x_msg_count ,

Line 618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

614: );
615:
616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
617: ROLLBACK TO Create_Imp_map ;
618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
619: FND_MSG_PUB.Count_And_Get(
620: p_count => x_msg_count ,
621: p_data => x_msg_data ,
622: p_encoded => FND_API.G_FALSE

Line 622: p_encoded => FND_API.G_FALSE

618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
619: FND_MSG_PUB.Count_And_Get(
620: p_count => x_msg_count ,
621: p_data => x_msg_data ,
622: p_encoded => FND_API.G_FALSE
623: );
624:
625: WHEN OTHERS THEN
626: ROLLBACK TO Create_Imp_map ;

Line 627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

623: );
624:
625: WHEN OTHERS THEN
626: ROLLBACK TO Create_Imp_map ;
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
628: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
629: THEN
630: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
631: END IF;

Line 636: p_encoded => FND_API.G_FALSE

632: FND_MSG_PUB.Count_And_Get
633: (
634: p_count => x_msg_count ,
635: p_data => x_msg_data ,
636: p_encoded => FND_API.G_FALSE
637: );
638: END Create_Imp_map;
639:
640:

Line 649: -- Default = FND_API.G_FALSE

645: -- Pre-reqs : None.
646: -- Parameters :
647: -- IN : p_api_version IN NUMBER Required
648: -- p_init_msg_list IN VARCHAR2 Optional
649: -- Default = FND_API.G_FALSE
650: -- p_commit IN VARCHAR2 Optional
651: -- Default = FND_API.G_FALSE
652: -- p_validation_level IN NUMBER Optional
653: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 651: -- Default = FND_API.G_FALSE

647: -- IN : p_api_version IN NUMBER Required
648: -- p_init_msg_list IN VARCHAR2 Optional
649: -- Default = FND_API.G_FALSE
650: -- p_commit IN VARCHAR2 Optional
651: -- Default = FND_API.G_FALSE
652: -- p_validation_level IN NUMBER Optional
653: -- Default = FND_API.G_VALID_LEVEL_FULL
654: -- p_imp_map IN imp_maps_rec_type
655: -- OUT : x_return_status OUT VARCHAR2(1)

Line 653: -- Default = FND_API.G_VALID_LEVEL_FULL

649: -- Default = FND_API.G_FALSE
650: -- p_commit IN VARCHAR2 Optional
651: -- Default = FND_API.G_FALSE
652: -- p_validation_level IN NUMBER Optional
653: -- Default = FND_API.G_VALID_LEVEL_FULL
654: -- p_imp_map IN imp_maps_rec_type
655: -- OUT : x_return_status OUT VARCHAR2(1)
656: -- x_msg_count OUT NUMBER
657: -- x_msg_data OUT VARCHAR2(2000)

Line 668: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

664: -- End of comments
665:
666: PROCEDURE Delete_Imp_Map
667: ( p_api_version IN NUMBER ,
668: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
669: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
670: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
671: x_return_status OUT NOCOPY VARCHAR2 ,
672: x_msg_count OUT NOCOPY NUMBER ,

Line 669: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

665:
666: PROCEDURE Delete_Imp_Map
667: ( p_api_version IN NUMBER ,
668: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
669: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
670: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
671: x_return_status OUT NOCOPY VARCHAR2 ,
672: x_msg_count OUT NOCOPY NUMBER ,
673: x_msg_data OUT NOCOPY VARCHAR2 ,

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

666: PROCEDURE Delete_Imp_Map
667: ( p_api_version IN NUMBER ,
668: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
669: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
670: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
671: x_return_status OUT NOCOPY VARCHAR2 ,
672: x_msg_count OUT NOCOPY NUMBER ,
673: x_msg_data OUT NOCOPY VARCHAR2 ,
674: p_imp_map IN imp_maps_rec_type

Line 687: IF NOT FND_API.compatible_api_call

683: BEGIN
684: -- Standard Start of API savepoint
685: SAVEPOINT Delete_Imp_map;
686: -- Standard call to check for call compatibility.
687: IF NOT FND_API.compatible_api_call
688: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
689: THEN
690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
691: END IF;

Line 690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

686: -- Standard call to check for call compatibility.
687: IF NOT FND_API.compatible_api_call
688: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
689: THEN
690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
691: END IF;
692: -- Initialize message list if p_init_msg_list is set to TRUE.
693: IF FND_API.to_Boolean( p_init_msg_list ) THEN
694: FND_MSG_PUB.initialize;

Line 693: IF FND_API.to_Boolean( p_init_msg_list ) THEN

689: THEN
690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
691: END IF;
692: -- Initialize message list if p_init_msg_list is set to TRUE.
693: IF FND_API.to_Boolean( p_init_msg_list ) THEN
694: FND_MSG_PUB.initialize;
695: END IF;
696: -- Initialize API return status to success
697: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 697: x_return_status := FND_API.G_RET_STS_SUCCESS;

693: IF FND_API.to_Boolean( p_init_msg_list ) THEN
694: FND_MSG_PUB.initialize;
695: END IF;
696: -- Initialize API return status to success
697: x_return_status := FND_API.G_RET_STS_SUCCESS;
698: -- API body
699: l_imp_map := p_imp_map ;
700: -- Check if record exist
701: BEGIN

Line 715: RAISE FND_API.G_EXC_ERROR ;

711: THEN
712: FND_MESSAGE.SET_NAME ('CN','CN_REC_NOT_EXISTS');
713: FND_MSG_PUB.Add;
714: END IF;
715: RAISE FND_API.G_EXC_ERROR ;
716: END;
717: -- check locking mechanism
718: IF l_imp_map.object_version_number >
719: p_imp_map.object_version_number THEN

Line 725: RAISE FND_API.G_EXC_ERROR ;

721: THEN
722: FND_MESSAGE.SET_NAME ('CN' , 'CN_RECORD_CHANGED');
723: FND_MSG_PUB.Add;
724: END IF;
725: RAISE FND_API.G_EXC_ERROR ;
726: END IF;
727:
728: -- delete imp_map_fields
729: DELETE FROM cn_imp_map_fields

Line 732: IF x_return_status <> FND_API.g_ret_sts_success THEN

728: -- delete imp_map_fields
729: DELETE FROM cn_imp_map_fields
730: WHERE imp_map_id = l_imp_map.imp_map_id;
731:
732: IF x_return_status <> FND_API.g_ret_sts_success THEN
733: RAISE FND_API.G_EXC_ERROR;
734: END IF;
735:
736: -- Call API to delete cn_imp_maps

Line 733: RAISE FND_API.G_EXC_ERROR;

729: DELETE FROM cn_imp_map_fields
730: WHERE imp_map_id = l_imp_map.imp_map_id;
731:
732: IF x_return_status <> FND_API.g_ret_sts_success THEN
733: RAISE FND_API.G_EXC_ERROR;
734: END IF;
735:
736: -- Call API to delete cn_imp_maps
737: cn_imp_maps_pkg.delete_row

Line 742: IF FND_API.To_Boolean( p_commit ) THEN

738: (p_imp_map_id => l_imp_map.imp_map_id);
739: -- End of API body.
740:
741: -- Standard check of p_commit.
742: IF FND_API.To_Boolean( p_commit ) THEN
743: COMMIT WORK;
744: END IF;
745: -- Standard call to get message count and if count is 1, get message info.
746: FND_MSG_PUB.Count_And_Get(

Line 749: p_encoded => FND_API.G_FALSE

745: -- Standard call to get message count and if count is 1, get message info.
746: FND_MSG_PUB.Count_And_Get(
747: p_count => x_msg_count ,
748: p_data => x_msg_data ,
749: p_encoded => FND_API.G_FALSE
750: );
751:
752: EXCEPTION
753: WHEN FND_API.G_EXC_ERROR THEN

Line 753: WHEN FND_API.G_EXC_ERROR THEN

749: p_encoded => FND_API.G_FALSE
750: );
751:
752: EXCEPTION
753: WHEN FND_API.G_EXC_ERROR THEN
754: ROLLBACK TO Delete_Imp_map ;
755: x_return_status := FND_API.G_RET_STS_ERROR ;
756: FND_MSG_PUB.Count_And_Get(
757: p_count => x_msg_count ,

Line 755: x_return_status := FND_API.G_RET_STS_ERROR ;

751:
752: EXCEPTION
753: WHEN FND_API.G_EXC_ERROR THEN
754: ROLLBACK TO Delete_Imp_map ;
755: x_return_status := FND_API.G_RET_STS_ERROR ;
756: FND_MSG_PUB.Count_And_Get(
757: p_count => x_msg_count ,
758: p_data => x_msg_data ,
759: p_encoded => FND_API.G_FALSE

Line 759: p_encoded => FND_API.G_FALSE

755: x_return_status := FND_API.G_RET_STS_ERROR ;
756: FND_MSG_PUB.Count_And_Get(
757: p_count => x_msg_count ,
758: p_data => x_msg_data ,
759: p_encoded => FND_API.G_FALSE
760: );
761:
762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
763: ROLLBACK TO Delete_Imp_map ;

Line 762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

758: p_data => x_msg_data ,
759: p_encoded => FND_API.G_FALSE
760: );
761:
762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
763: ROLLBACK TO Delete_Imp_map ;
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
765: FND_MSG_PUB.Count_And_Get(
766: p_count => x_msg_count ,

Line 764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

760: );
761:
762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
763: ROLLBACK TO Delete_Imp_map ;
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
765: FND_MSG_PUB.Count_And_Get(
766: p_count => x_msg_count ,
767: p_data => x_msg_data ,
768: p_encoded => FND_API.G_FALSE

Line 768: p_encoded => FND_API.G_FALSE

764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
765: FND_MSG_PUB.Count_And_Get(
766: p_count => x_msg_count ,
767: p_data => x_msg_data ,
768: p_encoded => FND_API.G_FALSE
769: );
770:
771: WHEN OTHERS THEN
772: ROLLBACK TO Delete_Imp_map ;

Line 773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

769: );
770:
771: WHEN OTHERS THEN
772: ROLLBACK TO Delete_Imp_map ;
773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
774: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
775: THEN
776: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
777: END IF;

Line 782: p_encoded => FND_API.G_FALSE

778: FND_MSG_PUB.Count_And_Get
779: (
780: p_count => x_msg_count ,
781: p_data => x_msg_data ,
782: p_encoded => FND_API.G_FALSE
783: );
784: END Delete_Imp_map;
785:
786: