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_TABLE_MAPS_PVT dependencies on FND_API

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

12: -- Procedure : Create_Map
13: -----------------------------------------------------------------------------+
14: PROCEDURE Create_Map (
15: p_api_version IN NUMBER,
16: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
17: p_commit IN VARCHAR2 := FND_API.G_FALSE,
18: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: x_return_status OUT NOCOPY VARCHAR2,
20: x_msg_count OUT NOCOPY NUMBER,

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

13: -----------------------------------------------------------------------------+
14: PROCEDURE Create_Map (
15: p_api_version IN NUMBER,
16: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
17: p_commit IN VARCHAR2 := FND_API.G_FALSE,
18: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: x_return_status OUT NOCOPY VARCHAR2,
20: x_msg_count OUT NOCOPY NUMBER,
21: x_msg_data OUT NOCOPY VARCHAR2,

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

14: PROCEDURE Create_Map (
15: p_api_version IN NUMBER,
16: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
17: p_commit IN VARCHAR2 := FND_API.G_FALSE,
18: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: x_return_status OUT NOCOPY VARCHAR2,
20: x_msg_count OUT NOCOPY NUMBER,
21: x_msg_data OUT NOCOPY VARCHAR2,
22: p_source_name IN VARCHAR2 ,

Line 58: IF NOT FND_API.Compatible_API_Call (l_api_version,

54: BEGIN
55: -- Standard Start of API savepoint
56: SAVEPOINT Create_Map;
57: -- Standard call to check for call compatibility.
58: IF NOT FND_API.Compatible_API_Call (l_api_version,
59: p_api_version,
60: l_api_name,
61: G_PKG_NAME)
62: THEN

Line 63: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

59: p_api_version,
60: l_api_name,
61: G_PKG_NAME)
62: THEN
63: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
64: END IF;
65:
66: -- Standard Check For Create Operations to validate the
67: -- ORG_ID by calling the common validation utility.

Line 77: x_return_status := FND_API.G_RET_STS_ERROR;

73: l_org_append := cn_collection_gen.get_org_append;
74:
75:
76: IF l_org_id is NULL THEN
77: x_return_status := FND_API.G_RET_STS_ERROR;
78: RAISE FND_API.G_EXC_ERROR;
79: END IF;
80:
81: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 78: RAISE FND_API.G_EXC_ERROR;

74:
75:
76: IF l_org_id is NULL THEN
77: x_return_status := FND_API.G_RET_STS_ERROR;
78: RAISE FND_API.G_EXC_ERROR;
79: END IF;
80:
81: -- Initialize message list if p_init_msg_list is set to TRUE.
82: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 82: IF FND_API.to_Boolean(p_init_msg_list) THEN

78: RAISE FND_API.G_EXC_ERROR;
79: END IF;
80:
81: -- Initialize message list if p_init_msg_list is set to TRUE.
82: IF FND_API.to_Boolean(p_init_msg_list) THEN
83: FND_MSG_PUB.initialize;
84: END IF;
85: -- Initialize API return status to success
86: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 86: x_return_status := FND_API.G_RET_STS_SUCCESS;

82: IF FND_API.to_Boolean(p_init_msg_list) THEN
83: FND_MSG_PUB.initialize;
84: END IF;
85: -- Initialize API return status to success
86: x_return_status := FND_API.G_RET_STS_SUCCESS;
87: ------------------+
88: -- API body
89: ------------------+
90: --+

Line 112: RAISE FND_API.G_EXC_ERROR;

108: THEN
109: fnd_message.set_name('CN', 'CL_UNIQUE_MAPPING_TYPE');
110: fnd_msg_pub.add;
111: END IF;
112: RAISE FND_API.G_EXC_ERROR;
113: END IF;
114:
115: --+
116: --+ Get Repository_Id, Parent_Module_Id and Event_Id

Line 298: --IF FND_API.To_Boolean( p_commit ) THEN

294: ------------------+
295: -- End of API body.
296: ------------------+
297: -- Standard check of p_commit.
298: --IF FND_API.To_Boolean( p_commit ) THEN
299: -- COMMIT WORK;
300: --END IF;
301: -- Standard call to get message count and if count is 1, get message info.
302: FND_MSG_PUB.Count_And_Get

Line 305: p_encoded => FND_API.G_FALSE);

301: -- Standard call to get message count and if count is 1, get message info.
302: FND_MSG_PUB.Count_And_Get
303: (p_count => x_msg_count ,
304: p_data => x_msg_data ,
305: p_encoded => FND_API.G_FALSE);
306:
307: -- Creating notes for the new Transaction Source. Code written here because the
308: -- sequence is generated in the Pl/SQL call
309: FND_MESSAGE.SET_NAME('CN', 'CN_TRANS_SRC_ATTR_INSERT_NOTE');

Line 393: WHEN FND_API.G_EXC_ERROR THEN

389: x_jtf_note_id => x_note_id
390: );
391:
392: EXCEPTION
393: WHEN FND_API.G_EXC_ERROR THEN
394: ROLLBACK TO Create_Map;
395: x_return_status := FND_API.G_RET_STS_ERROR ;
396: FND_MSG_PUB.Count_And_Get
397: (p_count => x_msg_count,

Line 395: x_return_status := FND_API.G_RET_STS_ERROR ;

391:
392: EXCEPTION
393: WHEN FND_API.G_EXC_ERROR THEN
394: ROLLBACK TO Create_Map;
395: x_return_status := FND_API.G_RET_STS_ERROR ;
396: FND_MSG_PUB.Count_And_Get
397: (p_count => x_msg_count,
398: p_data => x_msg_data,
399: p_encoded => FND_API.G_FALSE);

Line 399: p_encoded => FND_API.G_FALSE);

395: x_return_status := FND_API.G_RET_STS_ERROR ;
396: FND_MSG_PUB.Count_And_Get
397: (p_count => x_msg_count,
398: p_data => x_msg_data,
399: p_encoded => FND_API.G_FALSE);
400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
401: ROLLBACK TO Create_Map;
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
403: FND_MSG_PUB.Count_And_Get

Line 400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

396: FND_MSG_PUB.Count_And_Get
397: (p_count => x_msg_count,
398: p_data => x_msg_data,
399: p_encoded => FND_API.G_FALSE);
400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
401: ROLLBACK TO Create_Map;
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
403: FND_MSG_PUB.Count_And_Get
404: (p_count => x_msg_count,

Line 402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

398: p_data => x_msg_data,
399: p_encoded => FND_API.G_FALSE);
400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
401: ROLLBACK TO Create_Map;
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
403: FND_MSG_PUB.Count_And_Get
404: (p_count => x_msg_count,
405: p_data => x_msg_data,
406: p_encoded => FND_API.G_FALSE);

Line 406: p_encoded => FND_API.G_FALSE);

402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
403: FND_MSG_PUB.Count_And_Get
404: (p_count => x_msg_count,
405: p_data => x_msg_data,
406: p_encoded => FND_API.G_FALSE);
407: WHEN OTHERS THEN
408: ROLLBACK TO Create_Map;
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
410: IF FND_MSG_PUB.Check_Msg_Level

Line 409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

405: p_data => x_msg_data,
406: p_encoded => FND_API.G_FALSE);
407: WHEN OTHERS THEN
408: ROLLBACK TO Create_Map;
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
410: IF FND_MSG_PUB.Check_Msg_Level
411: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
412: FND_MSG_PUB.Add_Exc_Msg
413: (G_PKG_NAME,

Line 419: p_encoded => FND_API.G_FALSE);

415: END IF;
416: FND_MSG_PUB.Count_And_Get
417: (p_count => x_msg_count,
418: p_data => x_msg_data,
419: p_encoded => FND_API.G_FALSE);
420: END Create_Map;
421:
422:
423: -----------------------------------------------------------------------------+

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

425: -- HITHANKI Modified For R12
426: -----------------------------------------------------------------------------+
427: PROCEDURE Delete_Map
428: ( p_api_version IN NUMBER,
429: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
430: p_commit IN VARCHAR2 := FND_API.G_FALSE,
431: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
432: x_return_status OUT NOCOPY VARCHAR2,
433: x_msg_count OUT NOCOPY NUMBER,

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

426: -----------------------------------------------------------------------------+
427: PROCEDURE Delete_Map
428: ( p_api_version IN NUMBER,
429: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
430: p_commit IN VARCHAR2 := FND_API.G_FALSE,
431: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
432: x_return_status OUT NOCOPY VARCHAR2,
433: x_msg_count OUT NOCOPY NUMBER,
434: x_msg_data OUT NOCOPY VARCHAR2,

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

427: PROCEDURE Delete_Map
428: ( p_api_version IN NUMBER,
429: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
430: p_commit IN VARCHAR2 := FND_API.G_FALSE,
431: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
432: x_return_status OUT NOCOPY VARCHAR2,
433: x_msg_count OUT NOCOPY NUMBER,
434: x_msg_data OUT NOCOPY VARCHAR2,
435: p_table_map_id IN NUMBER,

Line 474: IF NOT FND_API.Compatible_API_Call (l_api_version,

470: BEGIN
471: -- Standard Start of API savepoint
472: SAVEPOINT Delete_Map;
473: -- Standard call to check for call compatibility.
474: IF NOT FND_API.Compatible_API_Call (l_api_version,
475: p_api_version,
476: l_api_name,
477: G_PKG_NAME)
478: THEN

Line 479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

475: p_api_version,
476: l_api_name,
477: G_PKG_NAME)
478: THEN
479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
480: END IF;
481: -- Initialize message list if p_init_msg_list is set to TRUE.
482: IF FND_API.to_Boolean( p_init_msg_list ) THEN
483: FND_MSG_PUB.initialize;

Line 482: IF FND_API.to_Boolean( p_init_msg_list ) THEN

478: THEN
479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
480: END IF;
481: -- Initialize message list if p_init_msg_list is set to TRUE.
482: IF FND_API.to_Boolean( p_init_msg_list ) THEN
483: FND_MSG_PUB.initialize;
484: END IF;
485: -- Initialize API return status to success
486: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 486: x_return_status := FND_API.G_RET_STS_SUCCESS;

482: IF FND_API.to_Boolean( p_init_msg_list ) THEN
483: FND_MSG_PUB.initialize;
484: END IF;
485: -- Initialize API return status to success
486: x_return_status := FND_API.G_RET_STS_SUCCESS;
487:
488:
489: --Changed by Ashley as part of MOACing exercise
490: cn_collection_gen.set_org_id(p_org_id);

Line 500: RAISE FND_API.G_EXC_ERROR;

496: --+
497: --+ Cannot delete seeded table map
498: --+
499: IF p_table_map_id < 0 THEN
500: RAISE FND_API.G_EXC_ERROR;
501: END IF;
502: --+
503: --+ Get information about the map to be deleted
504: --+

Line 588: --IF FND_API.To_Boolean( p_commit ) THEN

584: -------------------+
585: -- End of API body.
586: -------------------+
587: -- Standard check of p_commit.
588: --IF FND_API.To_Boolean( p_commit ) THEN
589: -- COMMIT WORK;
590: --END IF;
591: -- Standard call to get message count and if count is 1, get message info.
592: FND_MSG_PUB.Count_And_Get

Line 595: p_encoded => FND_API.G_FALSE);

591: -- Standard call to get message count and if count is 1, get message info.
592: FND_MSG_PUB.Count_And_Get
593: (p_count => x_msg_count ,
594: p_data => x_msg_data ,
595: p_encoded => FND_API.G_FALSE);
596: EXCEPTION
597: WHEN FND_API.G_EXC_ERROR THEN
598: ROLLBACK TO Delete_Map;
599: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 597: WHEN FND_API.G_EXC_ERROR THEN

593: (p_count => x_msg_count ,
594: p_data => x_msg_data ,
595: p_encoded => FND_API.G_FALSE);
596: EXCEPTION
597: WHEN FND_API.G_EXC_ERROR THEN
598: ROLLBACK TO Delete_Map;
599: x_return_status := FND_API.G_RET_STS_ERROR ;
600: FND_MSG_PUB.Count_And_Get
601: (p_count => x_msg_count,

Line 599: x_return_status := FND_API.G_RET_STS_ERROR ;

595: p_encoded => FND_API.G_FALSE);
596: EXCEPTION
597: WHEN FND_API.G_EXC_ERROR THEN
598: ROLLBACK TO Delete_Map;
599: x_return_status := FND_API.G_RET_STS_ERROR ;
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);

Line 603: p_encoded => FND_API.G_FALSE);

599: x_return_status := FND_API.G_RET_STS_ERROR ;
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: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
605: ROLLBACK TO Delete_Map;
606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
607: FND_MSG_PUB.Count_And_Get

Line 604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
605: ROLLBACK TO Delete_Map;
606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
607: FND_MSG_PUB.Count_And_Get
608: (p_count => x_msg_count,

Line 606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

602: p_data => x_msg_data,
603: p_encoded => FND_API.G_FALSE);
604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
605: ROLLBACK TO Delete_Map;
606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
607: FND_MSG_PUB.Count_And_Get
608: (p_count => x_msg_count,
609: p_data => x_msg_data,
610: p_encoded => FND_API.G_FALSE);

Line 610: p_encoded => FND_API.G_FALSE);

606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
607: FND_MSG_PUB.Count_And_Get
608: (p_count => x_msg_count,
609: p_data => x_msg_data,
610: p_encoded => FND_API.G_FALSE);
611: WHEN OTHERS THEN
612: ROLLBACK TO Delete_Map;
613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
614: IF FND_MSG_PUB.Check_Msg_Level

Line 613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

609: p_data => x_msg_data,
610: p_encoded => FND_API.G_FALSE);
611: WHEN OTHERS THEN
612: ROLLBACK TO Delete_Map;
613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
614: IF FND_MSG_PUB.Check_Msg_Level
615: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
616: FND_MSG_PUB.Add_Exc_Msg
617: (G_PKG_NAME,

Line 623: p_encoded => FND_API.G_FALSE);

619: END IF;
620: FND_MSG_PUB.Count_And_Get
621: (p_count => x_msg_count,
622: p_data => x_msg_data,
623: p_encoded => FND_API.G_FALSE);
624: END Delete_Map;
625:
626:
627: -----------------------------------------------------------------------------+

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

630:
631: PROCEDURE Update_Table_Map_Objects
632: (
633: p_api_version IN NUMBER,
634: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
635: p_commit IN VARCHAR2 := FND_API.G_FALSE,
636: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
637: x_return_status OUT NOCOPY VARCHAR2,
638: x_msg_count OUT NOCOPY NUMBER,

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

631: PROCEDURE Update_Table_Map_Objects
632: (
633: p_api_version IN NUMBER,
634: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
635: p_commit IN VARCHAR2 := FND_API.G_FALSE,
636: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
637: x_return_status OUT NOCOPY VARCHAR2,
638: x_msg_count OUT NOCOPY NUMBER,
639: x_msg_data OUT NOCOPY VARCHAR2,

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

632: (
633: p_api_version IN NUMBER,
634: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
635: p_commit IN VARCHAR2 := FND_API.G_FALSE,
636: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
637: x_return_status OUT NOCOPY VARCHAR2,
638: x_msg_count OUT NOCOPY NUMBER,
639: x_msg_data OUT NOCOPY VARCHAR2,
640: p_table_map_id IN NUMBER,

Line 672: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

668: BEGIN
669: -- Standard Start of API savepoint
670: SAVEPOINT update_trx_source_sv;
671: -- Standard call to check for call compatibility.
672: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
673: p_api_version ,
674: l_api_name,
675: G_PKG_NAME ) THEN
676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

672: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
673: p_api_version ,
674: l_api_name,
675: G_PKG_NAME ) THEN
676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
677: END IF;
678:
679: -- Initialize message list if p_init_msg_list is set to TRUE.
680: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 680: IF FND_API.to_Boolean( p_init_msg_list ) THEN

676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
677: END IF;
678:
679: -- Initialize message list if p_init_msg_list is set to TRUE.
680: IF FND_API.to_Boolean( p_init_msg_list ) THEN
681: FND_MSG_PUB.initialize;
682: END IF;
683:
684: -- Initialize API return status to success

Line 685: x_return_status := FND_API.G_RET_STS_SUCCESS;

681: FND_MSG_PUB.initialize;
682: END IF;
683:
684: -- Initialize API return status to success
685: x_return_status := FND_API.G_RET_STS_SUCCESS;
686: -- API Body Begin
687:
688: -- check if the object version number is the same
689: OPEN l_ovn_obj;

Line 706: RAISE FND_API.G_EXC_ERROR;

702: fnd_message.set_name('CN', 'CL_INVALID_OVN');
703: fnd_msg_pub.add;
704: END IF;
705:
706: RAISE FND_API.G_EXC_ERROR;
707:
708: END IF;
709:
710: l_org_id := x_org_id;

Line 730: p_encoded => FND_API.G_FALSE );

726:
727: FND_MSG_PUB.Count_And_Get
728: (p_count => x_msg_count ,
729: p_data => x_msg_data ,
730: p_encoded => FND_API.G_FALSE );
731: EXCEPTION
732: WHEN FND_API.G_EXC_ERROR THEN
733: ROLLBACK TO update_trx_source_sv;
734: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 732: WHEN FND_API.G_EXC_ERROR THEN

728: (p_count => x_msg_count ,
729: p_data => x_msg_data ,
730: p_encoded => FND_API.G_FALSE );
731: EXCEPTION
732: WHEN FND_API.G_EXC_ERROR THEN
733: ROLLBACK TO update_trx_source_sv;
734: x_return_status := FND_API.G_RET_STS_ERROR ;
735: FND_MSG_PUB.Count_And_Get(
736: p_count => x_msg_count ,

Line 734: x_return_status := FND_API.G_RET_STS_ERROR ;

730: p_encoded => FND_API.G_FALSE );
731: EXCEPTION
732: WHEN FND_API.G_EXC_ERROR THEN
733: ROLLBACK TO update_trx_source_sv;
734: x_return_status := FND_API.G_RET_STS_ERROR ;
735: FND_MSG_PUB.Count_And_Get(
736: p_count => x_msg_count ,
737: p_data => x_msg_data ,
738: p_encoded => FND_API.G_FALSE);

Line 738: p_encoded => FND_API.G_FALSE);

734: x_return_status := FND_API.G_RET_STS_ERROR ;
735: FND_MSG_PUB.Count_And_Get(
736: p_count => x_msg_count ,
737: p_data => x_msg_data ,
738: p_encoded => FND_API.G_FALSE);
739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
740: ROLLBACK TO update_trx_source_sv;
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
742: FND_MSG_PUB.Count_And_Get(

Line 739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

735: FND_MSG_PUB.Count_And_Get(
736: p_count => x_msg_count ,
737: p_data => x_msg_data ,
738: p_encoded => FND_API.G_FALSE);
739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
740: ROLLBACK TO update_trx_source_sv;
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
742: FND_MSG_PUB.Count_And_Get(
743: p_count => x_msg_count ,

Line 741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

737: p_data => x_msg_data ,
738: p_encoded => FND_API.G_FALSE);
739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
740: ROLLBACK TO update_trx_source_sv;
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
742: FND_MSG_PUB.Count_And_Get(
743: p_count => x_msg_count ,
744: p_data => x_msg_data ,
745: p_encoded => FND_API.G_FALSE);

Line 745: p_encoded => FND_API.G_FALSE);

741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
742: FND_MSG_PUB.Count_And_Get(
743: p_count => x_msg_count ,
744: p_data => x_msg_data ,
745: p_encoded => FND_API.G_FALSE);
746: WHEN OTHERS THEN
747: ROLLBACK TO update_trx_source_sv;
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
749: IF FND_MSG_PUB.Check_Msg_Level(

Line 748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

744: p_data => x_msg_data ,
745: p_encoded => FND_API.G_FALSE);
746: WHEN OTHERS THEN
747: ROLLBACK TO update_trx_source_sv;
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
749: IF FND_MSG_PUB.Check_Msg_Level(
750: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
751: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
752: END IF;

Line 756: p_encoded => FND_API.G_FALSE);

752: END IF;
753: FND_MSG_PUB.Count_And_Get(
754: p_count => x_msg_count ,
755: p_data => x_msg_data ,
756: p_encoded => FND_API.G_FALSE);
757:
758: END Update_Table_Map_Objects;
759:
760: -----------------------------------------------------------------------------+

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

762: -----------------------------------------------------------------------------+
763: PROCEDURE Update_Map
764: (
765: p_api_version IN NUMBER,
766: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
767: p_commit IN VARCHAR2 := FND_API.G_FALSE,
768: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
769: x_return_status OUT NOCOPY VARCHAR2,
770: x_msg_count OUT NOCOPY NUMBER,

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

763: PROCEDURE Update_Map
764: (
765: p_api_version IN NUMBER,
766: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
767: p_commit IN VARCHAR2 := FND_API.G_FALSE,
768: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
769: x_return_status OUT NOCOPY VARCHAR2,
770: x_msg_count OUT NOCOPY NUMBER,
771: x_msg_data OUT NOCOPY VARCHAR2,

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

764: (
765: p_api_version IN NUMBER,
766: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
767: p_commit IN VARCHAR2 := FND_API.G_FALSE,
768: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
769: x_return_status OUT NOCOPY VARCHAR2,
770: x_msg_count OUT NOCOPY NUMBER,
771: x_msg_data OUT NOCOPY VARCHAR2,
772: p_table_map_id IN NUMBER,

Line 807: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

803: BEGIN
804: -- Standard Start of API savepoint
805: SAVEPOINT update_trx_source_sv;
806: -- Standard call to check for call compatibility.
807: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
808: p_api_version ,
809: l_api_name,
810: G_PKG_NAME ) THEN
811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

807: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
808: p_api_version ,
809: l_api_name,
810: G_PKG_NAME ) THEN
811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
812: END IF;
813: -- Initialize message list if p_init_msg_list is set to TRUE.
814: IF FND_API.to_Boolean( p_init_msg_list ) THEN
815: FND_MSG_PUB.initialize;

Line 814: IF FND_API.to_Boolean( p_init_msg_list ) THEN

810: G_PKG_NAME ) THEN
811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
812: END IF;
813: -- Initialize message list if p_init_msg_list is set to TRUE.
814: IF FND_API.to_Boolean( p_init_msg_list ) THEN
815: FND_MSG_PUB.initialize;
816: END IF;
817: -- Initialize API return status to success
818: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 818: x_return_status := FND_API.G_RET_STS_SUCCESS;

814: IF FND_API.to_Boolean( p_init_msg_list ) THEN
815: FND_MSG_PUB.initialize;
816: END IF;
817: -- Initialize API return status to success
818: x_return_status := FND_API.G_RET_STS_SUCCESS;
819: -- API Body Begin
820:
821: -- check if the object version number is the same
822: OPEN l_ovn_csr;

Line 835: RAISE FND_API.G_EXC_ERROR;

831: THEN
832: fnd_message.set_name('CN', 'CL_INVALID_OVN');
833: fnd_msg_pub.add;
834: END IF;
835: RAISE FND_API.G_EXC_ERROR;
836:
837: end if;
838:
839: l_org_id := x_org_id;

Line 878: --IF FND_API.To_Boolean( p_commit ) THEN

874: p_object_version_number := l_object_version_number + 1;
875:
876: -- End of API body.
877: -- Standard check of p_commit.
878: --IF FND_API.To_Boolean( p_commit ) THEN
879: -- COMMIT WORK;
880: --END IF;
881: -- Standard call to get message count and if count is 1, get message info.
882: FND_MSG_PUB.Count_And_Get

Line 885: p_encoded => FND_API.G_FALSE );

881: -- Standard call to get message count and if count is 1, get message info.
882: FND_MSG_PUB.Count_And_Get
883: (p_count => x_msg_count ,
884: p_data => x_msg_data ,
885: p_encoded => FND_API.G_FALSE );
886: EXCEPTION
887: WHEN FND_API.G_EXC_ERROR THEN
888: ROLLBACK TO update_trx_source_sv;
889: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 887: WHEN FND_API.G_EXC_ERROR THEN

883: (p_count => x_msg_count ,
884: p_data => x_msg_data ,
885: p_encoded => FND_API.G_FALSE );
886: EXCEPTION
887: WHEN FND_API.G_EXC_ERROR THEN
888: ROLLBACK TO update_trx_source_sv;
889: x_return_status := FND_API.G_RET_STS_ERROR ;
890: FND_MSG_PUB.Count_And_Get(
891: p_count => x_msg_count ,

Line 889: x_return_status := FND_API.G_RET_STS_ERROR ;

885: p_encoded => FND_API.G_FALSE );
886: EXCEPTION
887: WHEN FND_API.G_EXC_ERROR THEN
888: ROLLBACK TO update_trx_source_sv;
889: x_return_status := FND_API.G_RET_STS_ERROR ;
890: FND_MSG_PUB.Count_And_Get(
891: p_count => x_msg_count ,
892: p_data => x_msg_data ,
893: p_encoded => FND_API.G_FALSE);

Line 893: p_encoded => FND_API.G_FALSE);

889: x_return_status := FND_API.G_RET_STS_ERROR ;
890: FND_MSG_PUB.Count_And_Get(
891: p_count => x_msg_count ,
892: p_data => x_msg_data ,
893: p_encoded => FND_API.G_FALSE);
894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
895: ROLLBACK TO update_trx_source_sv;
896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
897: FND_MSG_PUB.Count_And_Get(

Line 894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

890: FND_MSG_PUB.Count_And_Get(
891: p_count => x_msg_count ,
892: p_data => x_msg_data ,
893: p_encoded => FND_API.G_FALSE);
894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
895: ROLLBACK TO update_trx_source_sv;
896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
897: FND_MSG_PUB.Count_And_Get(
898: p_count => x_msg_count ,

Line 896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

892: p_data => x_msg_data ,
893: p_encoded => FND_API.G_FALSE);
894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
895: ROLLBACK TO update_trx_source_sv;
896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
897: FND_MSG_PUB.Count_And_Get(
898: p_count => x_msg_count ,
899: p_data => x_msg_data ,
900: p_encoded => FND_API.G_FALSE);

Line 900: p_encoded => FND_API.G_FALSE);

896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
897: FND_MSG_PUB.Count_And_Get(
898: p_count => x_msg_count ,
899: p_data => x_msg_data ,
900: p_encoded => FND_API.G_FALSE);
901: WHEN OTHERS THEN
902: ROLLBACK TO update_trx_source_sv;
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
904: IF FND_MSG_PUB.Check_Msg_Level(

Line 903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

899: p_data => x_msg_data ,
900: p_encoded => FND_API.G_FALSE);
901: WHEN OTHERS THEN
902: ROLLBACK TO update_trx_source_sv;
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
904: IF FND_MSG_PUB.Check_Msg_Level(
905: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
906: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
907: END IF;

Line 911: p_encoded => FND_API.G_FALSE);

907: END IF;
908: FND_MSG_PUB.Count_And_Get(
909: p_count => x_msg_count ,
910: p_data => x_msg_data ,
911: p_encoded => FND_API.G_FALSE);
912: END Update_Map;
913:
914:
915:

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

922: -- example an Extra Collection Table) then just use the
923: -- cn_table_map_objects_pkg.insert_row procedure.
924: PROCEDURE Create_Table_Map_Object (
925: p_api_version IN NUMBER,
926: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
927: p_commit IN VARCHAR2 := FND_API.G_FALSE,
928: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
929: x_return_status OUT NOCOPY VARCHAR2,
930: x_msg_count OUT NOCOPY NUMBER,

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

923: -- cn_table_map_objects_pkg.insert_row procedure.
924: PROCEDURE Create_Table_Map_Object (
925: p_api_version IN NUMBER,
926: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
927: p_commit IN VARCHAR2 := FND_API.G_FALSE,
928: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
929: x_return_status OUT NOCOPY VARCHAR2,
930: x_msg_count OUT NOCOPY NUMBER,
931: x_msg_data OUT NOCOPY VARCHAR2,

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

924: PROCEDURE Create_Table_Map_Object (
925: p_api_version IN NUMBER,
926: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
927: p_commit IN VARCHAR2 := FND_API.G_FALSE,
928: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
929: x_return_status OUT NOCOPY VARCHAR2,
930: x_msg_count OUT NOCOPY NUMBER,
931: x_msg_data OUT NOCOPY VARCHAR2,
932: p_table_map_id IN NUMBER,

Line 951: IF NOT FND_API.Compatible_API_Call (l_api_version,

947: BEGIN
948: -- Standard Start of API savepoint
949: SAVEPOINT Create_Table_Map_Object;
950: -- Standard call to check for call compatibility.
951: IF NOT FND_API.Compatible_API_Call (l_api_version,
952: p_api_version,
953: l_api_name,
954: G_PKG_NAME)
955: THEN

Line 956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

952: p_api_version,
953: l_api_name,
954: G_PKG_NAME)
955: THEN
956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
957: END IF;
958: -- Initialize message list if p_init_msg_list is set to TRUE.
959: IF FND_API.to_Boolean( p_init_msg_list ) THEN
960: FND_MSG_PUB.initialize;

Line 959: IF FND_API.to_Boolean( p_init_msg_list ) THEN

955: THEN
956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
957: END IF;
958: -- Initialize message list if p_init_msg_list is set to TRUE.
959: IF FND_API.to_Boolean( p_init_msg_list ) THEN
960: FND_MSG_PUB.initialize;
961: END IF;
962: -- Initialize API return status to success
963: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 963: x_return_status := FND_API.G_RET_STS_SUCCESS;

959: IF FND_API.to_Boolean( p_init_msg_list ) THEN
960: FND_MSG_PUB.initialize;
961: END IF;
962: -- Initialize API return status to success
963: x_return_status := FND_API.G_RET_STS_SUCCESS;
964:
965: l_org_id := x_org_id;
966:
967: -------------------+

Line 1014: --IF FND_API.To_Boolean( p_commit ) THEN

1010: -------------------+
1011: -- End of API body.
1012: -------------------+
1013: -- Standard check of p_commit.
1014: --IF FND_API.To_Boolean( p_commit ) THEN
1015: -- COMMIT WORK;
1016: --END IF;
1017: -- Standard call to get message count and if count is 1, get message info.
1018: FND_MSG_PUB.Count_And_Get

Line 1021: p_encoded => FND_API.G_FALSE);

1017: -- Standard call to get message count and if count is 1, get message info.
1018: FND_MSG_PUB.Count_And_Get
1019: (p_count => x_msg_count ,
1020: p_data => x_msg_data ,
1021: p_encoded => FND_API.G_FALSE);
1022: EXCEPTION
1023: WHEN FND_API.G_EXC_ERROR THEN
1024: ROLLBACK TO Create_Table_Map_Object;
1025: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1023: WHEN FND_API.G_EXC_ERROR THEN

1019: (p_count => x_msg_count ,
1020: p_data => x_msg_data ,
1021: p_encoded => FND_API.G_FALSE);
1022: EXCEPTION
1023: WHEN FND_API.G_EXC_ERROR THEN
1024: ROLLBACK TO Create_Table_Map_Object;
1025: x_return_status := FND_API.G_RET_STS_ERROR ;
1026: FND_MSG_PUB.Count_And_Get
1027: (p_count => x_msg_count,

Line 1025: x_return_status := FND_API.G_RET_STS_ERROR ;

1021: p_encoded => FND_API.G_FALSE);
1022: EXCEPTION
1023: WHEN FND_API.G_EXC_ERROR THEN
1024: ROLLBACK TO Create_Table_Map_Object;
1025: x_return_status := FND_API.G_RET_STS_ERROR ;
1026: FND_MSG_PUB.Count_And_Get
1027: (p_count => x_msg_count,
1028: p_data => x_msg_data,
1029: p_encoded => FND_API.G_FALSE);

Line 1029: p_encoded => FND_API.G_FALSE);

1025: x_return_status := FND_API.G_RET_STS_ERROR ;
1026: FND_MSG_PUB.Count_And_Get
1027: (p_count => x_msg_count,
1028: p_data => x_msg_data,
1029: p_encoded => FND_API.G_FALSE);
1030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1031: ROLLBACK TO Create_Table_Map_Object;
1032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1033: FND_MSG_PUB.Count_And_Get

Line 1030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1026: FND_MSG_PUB.Count_And_Get
1027: (p_count => x_msg_count,
1028: p_data => x_msg_data,
1029: p_encoded => FND_API.G_FALSE);
1030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1031: ROLLBACK TO Create_Table_Map_Object;
1032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1033: FND_MSG_PUB.Count_And_Get
1034: (p_count => x_msg_count,

Line 1032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1028: p_data => x_msg_data,
1029: p_encoded => FND_API.G_FALSE);
1030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1031: ROLLBACK TO Create_Table_Map_Object;
1032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1033: FND_MSG_PUB.Count_And_Get
1034: (p_count => x_msg_count,
1035: p_data => x_msg_data,
1036: p_encoded => FND_API.G_FALSE);

Line 1036: p_encoded => FND_API.G_FALSE);

1032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1033: FND_MSG_PUB.Count_And_Get
1034: (p_count => x_msg_count,
1035: p_data => x_msg_data,
1036: p_encoded => FND_API.G_FALSE);
1037: WHEN OTHERS THEN
1038: ROLLBACK TO Create_Table_Map_Object;
1039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1040: IF FND_MSG_PUB.Check_Msg_Level

Line 1039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1035: p_data => x_msg_data,
1036: p_encoded => FND_API.G_FALSE);
1037: WHEN OTHERS THEN
1038: ROLLBACK TO Create_Table_Map_Object;
1039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1040: IF FND_MSG_PUB.Check_Msg_Level
1041: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1042: FND_MSG_PUB.Add_Exc_Msg
1043: (G_PKG_NAME,

Line 1049: p_encoded => FND_API.G_FALSE);

1045: END IF;
1046: FND_MSG_PUB.Count_And_Get
1047: (p_count => x_msg_count,
1048: p_data => x_msg_data,
1049: p_encoded => FND_API.G_FALSE);
1050: END Create_Table_Map_Object;
1051:
1052:
1053:

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

1059: -- references to an object (for example an Extra Collection Table)
1060: -- then just use the cn_table_map_objects_pkg.delete_row procedure.
1061: PROCEDURE Delete_Table_Map_Object (
1062: p_api_version IN NUMBER,
1063: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1064: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1065: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1066: x_return_status OUT NOCOPY VARCHAR2,
1067: x_msg_count OUT NOCOPY NUMBER,

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

1060: -- then just use the cn_table_map_objects_pkg.delete_row procedure.
1061: PROCEDURE Delete_Table_Map_Object (
1062: p_api_version IN NUMBER,
1063: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1064: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1065: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1066: x_return_status OUT NOCOPY VARCHAR2,
1067: x_msg_count OUT NOCOPY NUMBER,
1068: x_msg_data OUT NOCOPY VARCHAR2,

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

1061: PROCEDURE Delete_Table_Map_Object (
1062: p_api_version IN NUMBER,
1063: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1064: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1065: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1066: x_return_status OUT NOCOPY VARCHAR2,
1067: x_msg_count OUT NOCOPY NUMBER,
1068: x_msg_data OUT NOCOPY VARCHAR2,
1069: p_table_map_object_id IN NUMBER,

Line 1086: IF NOT FND_API.Compatible_API_Call (l_api_version,

1082: BEGIN
1083: -- Standard Start of API savepoint
1084: SAVEPOINT Delete_Table_Map_Object;
1085: -- Standard call to check for call compatibility.
1086: IF NOT FND_API.Compatible_API_Call (l_api_version,
1087: p_api_version,
1088: l_api_name,
1089: G_PKG_NAME)
1090: THEN

Line 1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1087: p_api_version,
1088: l_api_name,
1089: G_PKG_NAME)
1090: THEN
1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1092: END IF;
1093: -- Initialize message list if p_init_msg_list is set to TRUE.
1094: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1095: FND_MSG_PUB.initialize;

Line 1094: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1090: THEN
1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1092: END IF;
1093: -- Initialize message list if p_init_msg_list is set to TRUE.
1094: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1095: FND_MSG_PUB.initialize;
1096: END IF;
1097: -- Initialize API return status to success
1098: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1098: x_return_status := FND_API.G_RET_STS_SUCCESS;

1094: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1095: FND_MSG_PUB.initialize;
1096: END IF;
1097: -- Initialize API return status to success
1098: x_return_status := FND_API.G_RET_STS_SUCCESS;
1099: -------------------+
1100: -- API body
1101: -------------------+
1102: --+

Line 1119: --IF FND_API.To_Boolean( p_commit ) THEN

1115: -------------------+
1116: -- End of API body.
1117: -------------------+
1118: -- Standard check of p_commit.
1119: --IF FND_API.To_Boolean( p_commit ) THEN
1120: -- COMMIT WORK;
1121: --END IF;
1122: -- Standard call to get message count and if count is 1, get message info.
1123: FND_MSG_PUB.Count_And_Get

Line 1126: p_encoded => FND_API.G_FALSE);

1122: -- Standard call to get message count and if count is 1, get message info.
1123: FND_MSG_PUB.Count_And_Get
1124: (p_count => x_msg_count ,
1125: p_data => x_msg_data ,
1126: p_encoded => FND_API.G_FALSE);
1127: EXCEPTION
1128: WHEN FND_API.G_EXC_ERROR THEN
1129: ROLLBACK TO Delete_Table_Map_Object;
1130: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1128: WHEN FND_API.G_EXC_ERROR THEN

1124: (p_count => x_msg_count ,
1125: p_data => x_msg_data ,
1126: p_encoded => FND_API.G_FALSE);
1127: EXCEPTION
1128: WHEN FND_API.G_EXC_ERROR THEN
1129: ROLLBACK TO Delete_Table_Map_Object;
1130: x_return_status := FND_API.G_RET_STS_ERROR ;
1131: FND_MSG_PUB.Count_And_Get
1132: (p_count => x_msg_count,

Line 1130: x_return_status := FND_API.G_RET_STS_ERROR ;

1126: p_encoded => FND_API.G_FALSE);
1127: EXCEPTION
1128: WHEN FND_API.G_EXC_ERROR THEN
1129: ROLLBACK TO Delete_Table_Map_Object;
1130: x_return_status := FND_API.G_RET_STS_ERROR ;
1131: FND_MSG_PUB.Count_And_Get
1132: (p_count => x_msg_count,
1133: p_data => x_msg_data,
1134: p_encoded => FND_API.G_FALSE);

Line 1134: p_encoded => FND_API.G_FALSE);

1130: x_return_status := FND_API.G_RET_STS_ERROR ;
1131: FND_MSG_PUB.Count_And_Get
1132: (p_count => x_msg_count,
1133: p_data => x_msg_data,
1134: p_encoded => FND_API.G_FALSE);
1135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1136: ROLLBACK TO Delete_Table_Map_Object;
1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1138: FND_MSG_PUB.Count_And_Get

Line 1135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1131: FND_MSG_PUB.Count_And_Get
1132: (p_count => x_msg_count,
1133: p_data => x_msg_data,
1134: p_encoded => FND_API.G_FALSE);
1135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1136: ROLLBACK TO Delete_Table_Map_Object;
1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1138: FND_MSG_PUB.Count_And_Get
1139: (p_count => x_msg_count,

Line 1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1133: p_data => x_msg_data,
1134: p_encoded => FND_API.G_FALSE);
1135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1136: ROLLBACK TO Delete_Table_Map_Object;
1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1138: FND_MSG_PUB.Count_And_Get
1139: (p_count => x_msg_count,
1140: p_data => x_msg_data,
1141: p_encoded => FND_API.G_FALSE);

Line 1141: p_encoded => FND_API.G_FALSE);

1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1138: FND_MSG_PUB.Count_And_Get
1139: (p_count => x_msg_count,
1140: p_data => x_msg_data,
1141: p_encoded => FND_API.G_FALSE);
1142: WHEN OTHERS THEN
1143: ROLLBACK TO Delete_Table_Map_Object;
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1145: IF FND_MSG_PUB.Check_Msg_Level

Line 1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1140: p_data => x_msg_data,
1141: p_encoded => FND_API.G_FALSE);
1142: WHEN OTHERS THEN
1143: ROLLBACK TO Delete_Table_Map_Object;
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1145: IF FND_MSG_PUB.Check_Msg_Level
1146: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1147: FND_MSG_PUB.Add_Exc_Msg
1148: (G_PKG_NAME,

Line 1154: p_encoded => FND_API.G_FALSE);

1150: END IF;
1151: FND_MSG_PUB.Count_And_Get
1152: (p_count => x_msg_count,
1153: p_data => x_msg_data,
1154: p_encoded => FND_API.G_FALSE);
1155: END Delete_Table_Map_Object;
1156:
1157: ------------------------------------------------------------------------------+
1158: -- Procedure : Get_SQL_Clauses

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

1158: -- Procedure : Get_SQL_Clauses
1159: ------------------------------------------------------------------------------+
1160: PROCEDURE Get_SQL_Clauses
1161: ( p_api_version IN NUMBER,
1162: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1163: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1164: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1165: x_return_status OUT NOCOPY VARCHAR2,
1166: x_msg_count OUT NOCOPY NUMBER,

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

1159: ------------------------------------------------------------------------------+
1160: PROCEDURE Get_SQL_Clauses
1161: ( p_api_version IN NUMBER,
1162: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1163: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1164: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1165: x_return_status OUT NOCOPY VARCHAR2,
1166: x_msg_count OUT NOCOPY NUMBER,
1167: x_msg_data OUT NOCOPY VARCHAR2,

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

1160: PROCEDURE Get_SQL_Clauses
1161: ( p_api_version IN NUMBER,
1162: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1163: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1164: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1165: x_return_status OUT NOCOPY VARCHAR2,
1166: x_msg_count OUT NOCOPY NUMBER,
1167: x_msg_data OUT NOCOPY VARCHAR2,
1168: p_table_map_id IN NUMBER ,

Line 1199: IF NOT FND_API.Compatible_API_Call (l_api_version,

1195: BEGIN
1196: -- Standard Start of API savepoint
1197: SAVEPOINT Get_SQL_Clauses;
1198: -- Standard call to check for call compatibility.
1199: IF NOT FND_API.Compatible_API_Call (l_api_version,
1200: p_api_version,
1201: l_api_name,
1202: G_PKG_NAME)
1203: THEN

Line 1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1200: p_api_version,
1201: l_api_name,
1202: G_PKG_NAME)
1203: THEN
1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1205: END IF;
1206: -- Initialize message list if p_init_msg_list is set to TRUE.
1207: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1208: FND_MSG_PUB.initialize;

Line 1207: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1203: THEN
1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1205: END IF;
1206: -- Initialize message list if p_init_msg_list is set to TRUE.
1207: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1208: FND_MSG_PUB.initialize;
1209: END IF;
1210: -- Initialize API return status to success
1211: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1211: x_return_status := FND_API.G_RET_STS_SUCCESS;

1207: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1208: FND_MSG_PUB.initialize;
1209: END IF;
1210: -- Initialize API return status to success
1211: x_return_status := FND_API.G_RET_STS_SUCCESS;
1212: -------------------+
1213: -- API body
1214: -------------------+
1215: --+

Line 1286: IF FND_API.To_Boolean( p_commit ) THEN

1282: -------------------+
1283: -- End of API body.
1284: -------------------+
1285: -- Standard check of p_commit.
1286: IF FND_API.To_Boolean( p_commit ) THEN
1287: COMMIT WORK;
1288: END IF;
1289: -- Standard call to get message count and if count is 1, get message info.
1290: FND_MSG_PUB.Count_And_Get

Line 1293: p_encoded => FND_API.G_FALSE);

1289: -- Standard call to get message count and if count is 1, get message info.
1290: FND_MSG_PUB.Count_And_Get
1291: (p_count => x_msg_count ,
1292: p_data => x_msg_data ,
1293: p_encoded => FND_API.G_FALSE);
1294: EXCEPTION
1295: WHEN FND_API.G_EXC_ERROR THEN
1296: ROLLBACK TO Get_SQL_Clauses;
1297: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1295: WHEN FND_API.G_EXC_ERROR THEN

1291: (p_count => x_msg_count ,
1292: p_data => x_msg_data ,
1293: p_encoded => FND_API.G_FALSE);
1294: EXCEPTION
1295: WHEN FND_API.G_EXC_ERROR THEN
1296: ROLLBACK TO Get_SQL_Clauses;
1297: x_return_status := FND_API.G_RET_STS_ERROR ;
1298: FND_MSG_PUB.Count_And_Get
1299: (p_count => x_msg_count,

Line 1297: x_return_status := FND_API.G_RET_STS_ERROR ;

1293: p_encoded => FND_API.G_FALSE);
1294: EXCEPTION
1295: WHEN FND_API.G_EXC_ERROR THEN
1296: ROLLBACK TO Get_SQL_Clauses;
1297: x_return_status := FND_API.G_RET_STS_ERROR ;
1298: FND_MSG_PUB.Count_And_Get
1299: (p_count => x_msg_count,
1300: p_data => x_msg_data,
1301: p_encoded => FND_API.G_FALSE);

Line 1301: p_encoded => FND_API.G_FALSE);

1297: x_return_status := FND_API.G_RET_STS_ERROR ;
1298: FND_MSG_PUB.Count_And_Get
1299: (p_count => x_msg_count,
1300: p_data => x_msg_data,
1301: p_encoded => FND_API.G_FALSE);
1302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1303: ROLLBACK TO Get_SQL_Clauses;
1304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1305: FND_MSG_PUB.Count_And_Get

Line 1302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1298: FND_MSG_PUB.Count_And_Get
1299: (p_count => x_msg_count,
1300: p_data => x_msg_data,
1301: p_encoded => FND_API.G_FALSE);
1302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1303: ROLLBACK TO Get_SQL_Clauses;
1304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1305: FND_MSG_PUB.Count_And_Get
1306: (p_count => x_msg_count,

Line 1304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1300: p_data => x_msg_data,
1301: p_encoded => FND_API.G_FALSE);
1302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1303: ROLLBACK TO Get_SQL_Clauses;
1304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1305: FND_MSG_PUB.Count_And_Get
1306: (p_count => x_msg_count,
1307: p_data => x_msg_data,
1308: p_encoded => FND_API.G_FALSE);

Line 1308: p_encoded => FND_API.G_FALSE);

1304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1305: FND_MSG_PUB.Count_And_Get
1306: (p_count => x_msg_count,
1307: p_data => x_msg_data,
1308: p_encoded => FND_API.G_FALSE);
1309: WHEN OTHERS THEN
1310: ROLLBACK TO Get_SQL_Clauses;
1311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1312: IF FND_MSG_PUB.Check_Msg_Level

Line 1311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1307: p_data => x_msg_data,
1308: p_encoded => FND_API.G_FALSE);
1309: WHEN OTHERS THEN
1310: ROLLBACK TO Get_SQL_Clauses;
1311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1312: IF FND_MSG_PUB.Check_Msg_Level
1313: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1314: FND_MSG_PUB.Add_Exc_Msg
1315: (G_PKG_NAME,

Line 1321: p_encoded => FND_API.G_FALSE);

1317: END IF;
1318: FND_MSG_PUB.Count_And_Get
1319: (p_count => x_msg_count,
1320: p_data => x_msg_data,
1321: p_encoded => FND_API.G_FALSE);
1322: END Get_SQL_Clauses;
1323:
1324: END cn_table_maps_pvt;
1325: