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.

[Home] [Help]

APPS.PSB_BUDGET_ACCOUNT_PVT dependencies on FND_API

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

97:
98: PROCEDURE Populate_Budget_Accounts
99: (
100: p_api_version IN NUMBER ,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
104: p_return_status OUT NOCOPY VARCHAR2 ,
105: p_msg_count OUT NOCOPY NUMBER ,

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

98: PROCEDURE Populate_Budget_Accounts
99: (
100: p_api_version IN NUMBER ,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
104: p_return_status OUT NOCOPY VARCHAR2 ,
105: p_msg_count OUT NOCOPY NUMBER ,
106: p_msg_data OUT NOCOPY VARCHAR2 ,

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

99: (
100: p_api_version IN NUMBER ,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
104: p_return_status OUT NOCOPY VARCHAR2 ,
105: p_msg_count OUT NOCOPY NUMBER ,
106: p_msg_data OUT NOCOPY VARCHAR2 ,
107: --

Line 108: p_set_of_books_id IN NUMBER := FND_API.G_MISS_NUM ,

104: p_return_status OUT NOCOPY VARCHAR2 ,
105: p_msg_count OUT NOCOPY NUMBER ,
106: p_msg_data OUT NOCOPY VARCHAR2 ,
107: --
108: p_set_of_books_id IN NUMBER := FND_API.G_MISS_NUM ,
109: p_account_set_id IN NUMBER := FND_API.G_MISS_NUM ,
110: -- bug no 3573740
111: p_full_maintainence_flag IN VARCHAR2 := 'N'
112: )

Line 109: p_account_set_id IN NUMBER := FND_API.G_MISS_NUM ,

105: p_msg_count OUT NOCOPY NUMBER ,
106: p_msg_data OUT NOCOPY VARCHAR2 ,
107: --
108: p_set_of_books_id IN NUMBER := FND_API.G_MISS_NUM ,
109: p_account_set_id IN NUMBER := FND_API.G_MISS_NUM ,
110: -- bug no 3573740
111: p_full_maintainence_flag IN VARCHAR2 := 'N'
112: )
113: IS

Line 125: IF NOT FND_API.Compatible_API_Call ( l_api_version,

121: BEGIN
122: --
123: SAVEPOINT Populate_Budget_Accounts_Pvt ;
124: --
125: IF NOT FND_API.Compatible_API_Call ( l_api_version,
126: p_api_version,
127: l_api_name,
128: G_PKG_NAME )
129: THEN

Line 130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

126: p_api_version,
127: l_api_name,
128: G_PKG_NAME )
129: THEN
130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
131: END IF;
132: --
133:
134: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 134: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
131: END IF;
132: --
133:
134: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
135: FND_MSG_PUB.initialize ;
136: END IF;
137: --
138: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 138: p_return_status := FND_API.G_RET_STS_SUCCESS ;

134: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
135: FND_MSG_PUB.initialize ;
136: END IF;
137: --
138: p_return_status := FND_API.G_RET_STS_SUCCESS ;
139: --
140:
141: --
142: -- As FND_API.G_MISS_NUM is bigger than NUMBERR(15), Using a local variable.

Line 142: -- As FND_API.G_MISS_NUM is bigger than NUMBERR(15), Using a local variable.

138: p_return_status := FND_API.G_RET_STS_SUCCESS ;
139: --
140:
141: --
142: -- As FND_API.G_MISS_NUM is bigger than NUMBERR(15), Using a local variable.
143: --
144: IF p_set_of_books_id = FND_API.G_MISS_NUM THEN
145: l_set_of_books_id := NULL;
146: ELSE

Line 144: IF p_set_of_books_id = FND_API.G_MISS_NUM THEN

140:
141: --
142: -- As FND_API.G_MISS_NUM is bigger than NUMBERR(15), Using a local variable.
143: --
144: IF p_set_of_books_id = FND_API.G_MISS_NUM THEN
145: l_set_of_books_id := NULL;
146: ELSE
147: l_set_of_books_id := p_set_of_books_id ;
148: END IF;

Line 151: IF ( p_account_set_id = FND_API.G_MISS_NUM ) OR ( p_account_set_id IS NULL)

147: l_set_of_books_id := p_set_of_books_id ;
148: END IF;
149:
150:
151: IF ( p_account_set_id = FND_API.G_MISS_NUM ) OR ( p_account_set_id IS NULL)
152: THEN
153: --
154: -- As no parameter is supplied, we have to populate all the account
155: -- sets in psb_account_position_sets table.

Line 191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

187: SAVEPOINT Populate_Budget_Accounts_Pvt ;
188: --
189: ELSE
190: --
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
192: --
193: END IF;
194: END LOOP;
195: --

Line 209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

205: --
206: -- bug no 3573740 (added parameter p_full_maintainence_flag)
207: IF NOT ( Populate_Budget_Account_Set( p_account_set_id ,
208: p_full_maintainence_flag) ) THEN
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
210: END IF;
211: END IF;
212:
213:

Line 215: IF FND_API.To_Boolean ( p_commit ) THEN

211: END IF;
212:
213:
214: --
215: IF FND_API.To_Boolean ( p_commit ) THEN
216: pd('Final Commiting');
217: COMMIT WORK;
218: END IF;
219: --

Line 226: WHEN FND_API.G_EXC_ERROR THEN

222: --
223:
224: EXCEPTION
225: --
226: WHEN FND_API.G_EXC_ERROR THEN
227: --
228: ROLLBACK TO Populate_Budget_Accounts_Pvt ;
229: p_return_status := FND_API.G_RET_STS_ERROR;
230: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 229: p_return_status := FND_API.G_RET_STS_ERROR;

225: --
226: WHEN FND_API.G_EXC_ERROR THEN
227: --
228: ROLLBACK TO Populate_Budget_Accounts_Pvt ;
229: p_return_status := FND_API.G_RET_STS_ERROR;
230: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
231: p_data => p_msg_data );
232: --
233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

229: p_return_status := FND_API.G_RET_STS_ERROR;
230: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
231: p_data => p_msg_data );
232: --
233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
234: --
235: ROLLBACK TO Populate_Budget_Accounts_Pvt ;
236: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 236: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

232: --
233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
234: --
235: ROLLBACK TO Populate_Budget_Accounts_Pvt ;
236: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
238: p_data => p_msg_data );
239: --
240: WHEN OTHERS THEN

Line 243: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

239: --
240: WHEN OTHERS THEN
241: --
242: ROLLBACK TO Populate_Budget_Accounts_Pvt ;
243: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
244: --
245: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
246: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
247: l_api_name);

Line 698: p_set_of_books_id IN NUMBER := FND_API.G_MISS_NUM ,

694: (
695: errbuf OUT NOCOPY VARCHAR2 ,
696: retcode OUT NOCOPY VARCHAR2 ,
697: --
698: p_set_of_books_id IN NUMBER := FND_API.G_MISS_NUM ,
699: p_account_set_id IN NUMBER := FND_API.G_MISS_NUM ,
700: -- bug no 3573740
701: p_full_maintainence_flag IN VARCHAR2 := 'N'
702: )

Line 699: p_account_set_id IN NUMBER := FND_API.G_MISS_NUM ,

695: errbuf OUT NOCOPY VARCHAR2 ,
696: retcode OUT NOCOPY VARCHAR2 ,
697: --
698: p_set_of_books_id IN NUMBER := FND_API.G_MISS_NUM ,
699: p_account_set_id IN NUMBER := FND_API.G_MISS_NUM ,
700: -- bug no 3573740
701: p_full_maintainence_flag IN VARCHAR2 := 'N'
702: )
703: IS

Line 721: IF ( p_set_of_books_id = FND_API.G_MISS_NUM ) OR ( p_set_of_books_id IS NULL)

717: BEGIN
718: --
719: -- SAVEPOINT Populate_Budget_Acct_CP_Pvt ;
720: --
721: IF ( p_set_of_books_id = FND_API.G_MISS_NUM ) OR ( p_set_of_books_id IS NULL)
722: THEN
723: FND_FILE.Put_Line( FND_FILE.OUTPUT,
724: 'Set of books Name : ALL');
725: ELSE

Line 738: IF ( p_account_set_id = FND_API.G_MISS_NUM ) OR ( p_account_set_id IS NULL)

734: END IF;
735: --
736:
737: --
738: IF ( p_account_set_id = FND_API.G_MISS_NUM ) OR ( p_account_set_id IS NULL)
739: THEN
740: FND_FILE.Put_Line( FND_FILE.OUTPUT, 'Account set name : ALL');
741: ELSE
742: --

Line 756: p_init_msg_list => FND_API.G_TRUE ,

752:
753: PSB_Budget_Account_PVT.Populate_Budget_Accounts
754: (
755: p_api_version => 1.0 ,
756: p_init_msg_list => FND_API.G_TRUE ,
757: p_commit => FND_API.G_FALSE ,
758: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
759: p_return_status => l_return_status ,
760: p_msg_count => l_msg_count ,

Line 757: p_commit => FND_API.G_FALSE ,

753: PSB_Budget_Account_PVT.Populate_Budget_Accounts
754: (
755: p_api_version => 1.0 ,
756: p_init_msg_list => FND_API.G_TRUE ,
757: p_commit => FND_API.G_FALSE ,
758: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
759: p_return_status => l_return_status ,
760: p_msg_count => l_msg_count ,
761: p_msg_data => l_msg_data ,

Line 758: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

754: (
755: p_api_version => 1.0 ,
756: p_init_msg_list => FND_API.G_TRUE ,
757: p_commit => FND_API.G_FALSE ,
758: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
759: p_return_status => l_return_status ,
760: p_msg_count => l_msg_count ,
761: p_msg_data => l_msg_data ,
762: p_set_of_books_id => p_set_of_books_id ,

Line 768: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

764: -- bug no 3573740
765: p_full_maintainence_flag => p_full_maintainence_flag
766: );
767: --
768: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
769: RAISE FND_API.G_EXC_ERROR;
770: END IF;
771: --
772:

Line 769: RAISE FND_API.G_EXC_ERROR;

765: p_full_maintainence_flag => p_full_maintainence_flag
766: );
767: --
768: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
769: RAISE FND_API.G_EXC_ERROR;
770: END IF;
771: --
772:
773: PSB_MESSAGE_S.Print_Success ;

Line 780: WHEN FND_API.G_EXC_ERROR THEN

776: COMMIT WORK;
777: --
778: EXCEPTION
779: --
780: WHEN FND_API.G_EXC_ERROR THEN
781: --
782: -- ROLLBACK TO Populate_Budget_Acct_CP_Pvt ;
783: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
784: p_print_header => FND_API.G_TRUE ) ;

Line 784: p_print_header => FND_API.G_TRUE ) ;

780: WHEN FND_API.G_EXC_ERROR THEN
781: --
782: -- ROLLBACK TO Populate_Budget_Acct_CP_Pvt ;
783: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
784: p_print_header => FND_API.G_TRUE ) ;
785: retcode := 2 ;
786: --
787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
788: --

Line 787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

783: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
784: p_print_header => FND_API.G_TRUE ) ;
785: retcode := 2 ;
786: --
787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
788: --
789: -- ROLLBACK TO Populate_Budget_Acct_CP_Pvt ;
790: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
791: p_print_header => FND_API.G_TRUE ) ;

Line 791: p_print_header => FND_API.G_TRUE ) ;

787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
788: --
789: -- ROLLBACK TO Populate_Budget_Acct_CP_Pvt ;
790: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
791: p_print_header => FND_API.G_TRUE ) ;
792: retcode := 2 ;
793: --
794: WHEN OTHERS THEN
795: --

Line 804: p_print_header => FND_API.G_TRUE ) ;

800: l_api_name ) ;
801: END IF ;
802: --
803: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
804: p_print_header => FND_API.G_TRUE ) ;
805: retcode := 2 ;
806: --
807: END Populate_Budget_Accounts_CP ;
808: /*---------------------------------------------------------------------------*/

Line 861: p_init_msg_list => FND_API.G_TRUE,

857: BEGIN
858:
859: PSB_Budget_Account_PVT.Validate_Worksheet
860: (p_api_version => 1.0,
861: p_init_msg_list => FND_API.G_TRUE,
862: p_commit => FND_API.G_FALSE,
863: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
864: p_return_status => l_return_status,
865: p_msg_count => l_msg_count,

Line 862: p_commit => FND_API.G_FALSE,

858:
859: PSB_Budget_Account_PVT.Validate_Worksheet
860: (p_api_version => 1.0,
861: p_init_msg_list => FND_API.G_TRUE,
862: p_commit => FND_API.G_FALSE,
863: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
864: p_return_status => l_return_status,
865: p_msg_count => l_msg_count,
866: p_msg_data => l_msg_data,

Line 863: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

859: PSB_Budget_Account_PVT.Validate_Worksheet
860: (p_api_version => 1.0,
861: p_init_msg_list => FND_API.G_TRUE,
862: p_commit => FND_API.G_FALSE,
863: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
864: p_return_status => l_return_status,
865: p_msg_count => l_msg_count,
866: p_msg_data => l_msg_data,
867: p_worksheet_id => p_worksheet_id,

Line 870: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

866: p_msg_data => l_msg_data,
867: p_worksheet_id => p_worksheet_id,
868: p_msg_wrt_mode => 'OUT');
869:
870: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
871: RAISE FND_API.G_EXC_ERROR;
872: END IF;
873:
874: PSB_MESSAGE_S.Print_Success;

Line 871: RAISE FND_API.G_EXC_ERROR;

867: p_worksheet_id => p_worksheet_id,
868: p_msg_wrt_mode => 'OUT');
869:
870: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
871: RAISE FND_API.G_EXC_ERROR;
872: END IF;
873:
874: PSB_MESSAGE_S.Print_Success;
875: retcode := 0 ;

Line 880: WHEN FND_API.G_EXC_ERROR THEN

876: COMMIT WORK;
877:
878: EXCEPTION
879:
880: WHEN FND_API.G_EXC_ERROR THEN
881:
882: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
883: p_print_header => FND_API.G_TRUE );
884: retcode := 2 ;

Line 883: p_print_header => FND_API.G_TRUE );

879:
880: WHEN FND_API.G_EXC_ERROR THEN
881:
882: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
883: p_print_header => FND_API.G_TRUE );
884: retcode := 2 ;
885: COMMIT WORK ;
886:
887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

883: p_print_header => FND_API.G_TRUE );
884: retcode := 2 ;
885: COMMIT WORK ;
886:
887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
888:
889: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
890: p_print_header => FND_API.G_TRUE );
891: retcode := 2 ;

Line 890: p_print_header => FND_API.G_TRUE );

886:
887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
888:
889: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
890: p_print_header => FND_API.G_TRUE );
891: retcode := 2 ;
892: COMMIT WORK ;
893:
894: WHEN OTHERS THEN

Line 903: p_print_header => FND_API.G_TRUE );

899: l_api_name ) ;
900: END IF ;
901: --
902: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
903: p_print_header => FND_API.G_TRUE );
904: --
905: retcode := 2 ;
906: COMMIT WORK ;
907: --

Line 924: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

920:
921:
922: Procedure Validate_Worksheet (
923: p_api_version IN NUMBER,
924: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
925: p_commit IN VARCHAR2 := fnd_api.g_false,
926: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
927: p_return_status OUT NOCOPY VARCHAR2,
928: p_msg_count OUT NOCOPY NUMBER,

Line 925: p_commit IN VARCHAR2 := fnd_api.g_false,

921:
922: Procedure Validate_Worksheet (
923: p_api_version IN NUMBER,
924: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
925: p_commit IN VARCHAR2 := fnd_api.g_false,
926: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
927: p_return_status OUT NOCOPY VARCHAR2,
928: p_msg_count OUT NOCOPY NUMBER,
929: p_msg_data OUT NOCOPY VARCHAR2,

Line 926: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

922: Procedure Validate_Worksheet (
923: p_api_version IN NUMBER,
924: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
925: p_commit IN VARCHAR2 := fnd_api.g_false,
926: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
927: p_return_status OUT NOCOPY VARCHAR2,
928: p_msg_count OUT NOCOPY NUMBER,
929: p_msg_data OUT NOCOPY VARCHAR2,
930: p_worksheet_id IN NUMBER,

Line 954: IF NOT FND_API.Compatible_API_Call (l_api_version,

950: SAVEPOINT Validate_Worksheet_Pvt;
951:
952:
953: -- Standard call to check for call compatibility.
954: IF NOT FND_API.Compatible_API_Call (l_api_version,
955: p_api_version,
956: l_api_name,
957: G_PKG_NAME)
958: THEN

Line 959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 963: IF FND_API.to_Boolean (p_init_msg_list) THEN

959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
960: END IF;
961:
962: -- Initialize message list if p_init_msg_list is set to TRUE
963: IF FND_API.to_Boolean (p_init_msg_list) THEN
964: FND_MSG_PUB.initialize;
965: END IF;
966:
967: FOR c_ws_rec in(SELECT NVL(budget_by_position,'N') budget_by_position,

Line 980: p_init_msg_list => FND_API.G_TRUE ,

976:
977: PSB_Budget_Position_Pvt.Populate_Budget_Positions
978: (
979: p_api_version => 1.0 ,
980: p_init_msg_list => FND_API.G_TRUE ,
981: p_commit => FND_API.G_FALSE ,
982: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
983: p_return_status => l_return_status ,
984: p_msg_count => l_msg_count ,

Line 981: p_commit => FND_API.G_FALSE ,

977: PSB_Budget_Position_Pvt.Populate_Budget_Positions
978: (
979: p_api_version => 1.0 ,
980: p_init_msg_list => FND_API.G_TRUE ,
981: p_commit => FND_API.G_FALSE ,
982: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
983: p_return_status => l_return_status ,
984: p_msg_count => l_msg_count ,
985: p_msg_data => l_msg_data ,

Line 982: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

978: (
979: p_api_version => 1.0 ,
980: p_init_msg_list => FND_API.G_TRUE ,
981: p_commit => FND_API.G_FALSE ,
982: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
983: p_return_status => l_return_status ,
984: p_msg_count => l_msg_count ,
985: p_msg_data => l_msg_data ,
986: p_data_extract_id => l_data_extract_id

Line 1029: RAISE FND_API.G_EXC_ERROR;

1025: IF l_rep_req_id = 0 THEN
1026:
1027: FND_MESSAGE.SET_NAME('PSB', 'PSB_FAIL_TO_SUBMIT_REQUEST');
1028: FND_MSG_PUB.ADD;
1029: RAISE FND_API.G_EXC_ERROR;
1030:
1031: END IF;
1032:
1033: EXCEPTION

Line 1035: WHEN FND_API.G_EXC_ERROR THEN

1031: END IF;
1032:
1033: EXCEPTION
1034:
1035: WHEN FND_API.G_EXC_ERROR THEN
1036: ROLLBACK TO Validate_Worksheet_Pvt;
1037: p_return_status := FND_API.G_RET_STS_ERROR ;
1038: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1039: p_data => p_msg_data);

Line 1037: p_return_status := FND_API.G_RET_STS_ERROR ;

1033: EXCEPTION
1034:
1035: WHEN FND_API.G_EXC_ERROR THEN
1036: ROLLBACK TO Validate_Worksheet_Pvt;
1037: p_return_status := FND_API.G_RET_STS_ERROR ;
1038: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1039: p_data => p_msg_data);
1040:
1041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1037: p_return_status := FND_API.G_RET_STS_ERROR ;
1038: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1039: p_data => p_msg_data);
1040:
1041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1042: ROLLBACK TO Validate_Worksheet_Pvt;
1043: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1044: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1045: p_data => p_msg_data);

Line 1043: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1039: p_data => p_msg_data);
1040:
1041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1042: ROLLBACK TO Validate_Worksheet_Pvt;
1043: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1044: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1045: p_data => p_msg_data);
1046:
1047: WHEN OTHERS THEN

Line 1049: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1045: p_data => p_msg_data);
1046:
1047: WHEN OTHERS THEN
1048: ROLLBACK TO Validate_Worksheet_Pvt;
1049: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1050:
1051: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1052: p_data => p_msg_data);
1053: