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_PAY_ELEMENT_INPUTS_PVT dependencies on FND_MSG_PUB

Line 88: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

84: -- Only One column is allowed from posting detail
85: --
86: IF p_table_name = 'CN_POSTING_DETAILS' and
87: p_column_name <> 'PAYMENT_AMOUNT' THEN
88: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
89: FND_MESSAGE.Set_Name('CN', 'CN_CANNOT_USE_OTHER_COL');
90: FND_MSG_PUB.Add;
91: END IF;
92: x_loading_status := 'CN_CANNOT_USE_OTHER_COL';

Line 90: FND_MSG_PUB.Add;

86: IF p_table_name = 'CN_POSTING_DETAILS' and
87: p_column_name <> 'PAYMENT_AMOUNT' THEN
88: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
89: FND_MESSAGE.Set_Name('CN', 'CN_CANNOT_USE_OTHER_COL');
90: FND_MSG_PUB.Add;
91: END IF;
92: x_loading_status := 'CN_CANNOT_USE_OTHER_COL';
93: RAISE FND_API.G_EXC_ERROR ;
94: END IF;

Line 100: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

96: --
97: -- check table name is not null
98: --
99: IF p_pay_element_input_rec.table_name IS NULL THEN
100: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
101: FND_MESSAGE.Set_Name('CN', 'CN_TABLE_NAME_NOT_NULL');
102: FND_MSG_PUB.Add;
103: END IF;
104: x_loading_status := 'CN_TABLE_NAME_NOT_NULL';

Line 102: FND_MSG_PUB.Add;

98: --
99: IF p_pay_element_input_rec.table_name IS NULL THEN
100: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
101: FND_MESSAGE.Set_Name('CN', 'CN_TABLE_NAME_NOT_NULL');
102: FND_MSG_PUB.Add;
103: END IF;
104: x_loading_status := 'CN_TABLE_NAME_NOT_NULL';
105: RAISE FND_API.G_EXC_ERROR ;
106: END IF;

Line 112: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

108: --
109: -- check col name is not null
110: --
111: IF p_pay_element_input_rec.column_name IS NULL THEN
112: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
113: FND_MESSAGE.Set_Name('CN', 'CN_COL_NAME_NOT_NULL');
114: FND_MSG_PUB.Add;
115: END IF;
116: x_loading_status := 'CN_COLUMN_NAME_NOT_NULL';

Line 114: FND_MSG_PUB.Add;

110: --
111: IF p_pay_element_input_rec.column_name IS NULL THEN
112: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
113: FND_MESSAGE.Set_Name('CN', 'CN_COL_NAME_NOT_NULL');
114: FND_MSG_PUB.Add;
115: END IF;
116: x_loading_status := 'CN_COLUMN_NAME_NOT_NULL';
117: RAISE FND_API.G_EXC_ERROR ;
118: END IF;

Line 125: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

121: -- check input exists and line number exists
122: --
123: IF p_pay_element_input_rec.quota_pay_element_id IS NULL
124: THEN
125: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
126: FND_MESSAGE.Set_Name('CN', 'CN_PAY_ELEMENT_MAP_NOT_EXISTS');
127: FND_MSG_PUB.Add;
128: END IF;
129: x_loading_status := 'CN_PAY_ELEMENT_MAP_NOT_EXISTS';

Line 127: FND_MSG_PUB.Add;

123: IF p_pay_element_input_rec.quota_pay_element_id IS NULL
124: THEN
125: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
126: FND_MESSAGE.Set_Name('CN', 'CN_PAY_ELEMENT_MAP_NOT_EXISTS');
127: FND_MSG_PUB.Add;
128: END IF;
129: x_loading_status := 'CN_PAY_ELEMENT_MAP_NOT_EXISTS';
130: RAISE FND_API.G_EXC_ERROR ;
131: END IF;

Line 139: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

135: -- check element input_id and line number is not null
136: --
137: IF p_pay_element_input_rec.element_input_id IS NULL or
138: p_pay_element_input_rec.line_number IS NULL THEN
139: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
140: FND_MESSAGE.Set_Name('CN', 'CN_ELEMENT_INPUT_NOT_EXISTS');
141: FND_MSG_PUB.Add;
142: END IF;
143: x_loading_status := 'CN_ELEMENT_INPUT_NOT_EXISTS';

Line 141: FND_MSG_PUB.Add;

137: IF p_pay_element_input_rec.element_input_id IS NULL or
138: p_pay_element_input_rec.line_number IS NULL THEN
139: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
140: FND_MESSAGE.Set_Name('CN', 'CN_ELEMENT_INPUT_NOT_EXISTS');
141: FND_MSG_PUB.Add;
142: END IF;
143: x_loading_status := 'CN_ELEMENT_INPUT_NOT_EXISTS';
144: RAISE FND_API.G_EXC_ERROR ;
145: END IF;

Line 150: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

146:
147: -- check table id exists
148: IF p_pay_element_input_rec.table_name IS NOT NULL and
149: p_pay_element_input_rec.tab_object_id IS NULL THEN
150: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
151: FND_MESSAGE.Set_Name('CN', 'CN_TABLE_NAME_NOT_EXISTS');
152: FND_MSG_PUB.Add;
153: END IF;
154: x_loading_status := 'CN_TABLE_NAME_NOT_EXISTS';

Line 152: FND_MSG_PUB.Add;

148: IF p_pay_element_input_rec.table_name IS NOT NULL and
149: p_pay_element_input_rec.tab_object_id IS NULL THEN
150: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
151: FND_MESSAGE.Set_Name('CN', 'CN_TABLE_NAME_NOT_EXISTS');
152: FND_MSG_PUB.Add;
153: END IF;
154: x_loading_status := 'CN_TABLE_NAME_NOT_EXISTS';
155: RAISE FND_API.G_EXC_ERROR ;
156: END IF;

Line 161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

157:
158: -- check column id is exists
159: IF p_pay_element_input_rec.column_name IS NOT NULL and
160: p_pay_element_input_rec.col_object_id IS NULL THEN
161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
162: FND_MESSAGE.Set_Name('CN', 'CN_COL_NAME_NOT_EXISTS');
163: FND_MSG_PUB.Add;
164: END IF;
165: x_loading_status := 'CN_COL_NAME_NOT_EXISTS';

Line 163: FND_MSG_PUB.Add;

159: IF p_pay_element_input_rec.column_name IS NOT NULL and
160: p_pay_element_input_rec.col_object_id IS NULL THEN
161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
162: FND_MESSAGE.Set_Name('CN', 'CN_COL_NAME_NOT_EXISTS');
163: FND_MSG_PUB.Add;
164: END IF;
165: x_loading_status := 'CN_COL_NAME_NOT_EXISTS';
166: RAISE FND_API.G_EXC_ERROR ;
167: END IF;

Line 192: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

188: (p_pay_element_input_rec.pay_element_input_id IS NULL))
189: );
190: EXCEPTION
191: WHEN NO_DATA_FOUND THEN
192: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
193: FND_MESSAGE.Set_Name('CN', 'CN_DUPLICATE_AMOUNT_INPUT');
194: FND_MSG_PUB.Add;
195: END IF;
196: x_loading_status := 'CN_DUPLICATE_AMOUNT_INPUT';

Line 194: FND_MSG_PUB.Add;

190: EXCEPTION
191: WHEN NO_DATA_FOUND THEN
192: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
193: FND_MESSAGE.Set_Name('CN', 'CN_DUPLICATE_AMOUNT_INPUT');
194: FND_MSG_PUB.Add;
195: END IF;
196: x_loading_status := 'CN_DUPLICATE_AMOUNT_INPUT';
197: RAISE FND_API.G_EXC_ERROR ;
198: END;

Line 230: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

226:
227: -- If zero then input value not found
228: IF l_count = 0 THEN
229:
230: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
231: FND_MESSAGE.Set_Name('CN', 'CN_INPUT_VALUES_NOT_FOUND');
232: FND_MSG_PUB.Add;
233: END IF;
234: x_loading_status := 'CN_INPUT_VALUES_NOT_FOUND';

Line 232: FND_MSG_PUB.Add;

228: IF l_count = 0 THEN
229:
230: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
231: FND_MESSAGE.Set_Name('CN', 'CN_INPUT_VALUES_NOT_FOUND');
232: FND_MSG_PUB.Add;
233: END IF;
234: x_loading_status := 'CN_INPUT_VALUES_NOT_FOUND';
235: RAISE FND_API.G_EXC_ERROR ;
236:

Line 250: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

246: x_loading_status := 'UNEXPECTED_ERR';
247: WHEN OTHERS THEN
248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
249: x_loading_status := 'UNEXPECTED_ERR';
250: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
251: THEN
252: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
253: END IF;
254:

Line 252: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
249: x_loading_status := 'UNEXPECTED_ERR';
250: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
251: THEN
252: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
253: END IF;
254:
255: END valid_pei_mapping;
256: --|========================================================================

Line 300: FND_MSG_PUB.initialize;

296: END IF;
297:
298: -- Initialize message list if p_init_msg_list is set to TRUE.
299: IF FND_API.to_Boolean( p_init_msg_list ) THEN
300: FND_MSG_PUB.initialize;
301: END IF;
302:
303: -- Initialize API return status to success
304: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 392: FND_MSG_PUB.Count_And_Get

388: IF FND_API.To_Boolean( p_commit ) THEN
389: COMMIT WORK;
390: END IF;
391: -- Standard call to get message count and if count is 1, get message info.
392: FND_MSG_PUB.Count_And_Get
393: (
394: p_count => x_msg_count ,
395: p_data => x_msg_data ,
396: p_encoded => FND_API.G_FALSE

Line 403: FND_MSG_PUB.Count_And_Get

399: EXCEPTION
400: WHEN FND_API.G_EXC_ERROR THEN
401: ROLLBACK TO Create_pay_element_input;
402: x_return_status := FND_API.G_RET_STS_ERROR ;
403: FND_MSG_PUB.Count_And_Get
404: (
405: p_count => x_msg_count ,
406: p_data => x_msg_data ,
407: p_encoded => FND_API.G_FALSE

Line 414: FND_MSG_PUB.Count_And_Get

410: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
411: ROLLBACK TO Create_pay_element_input;
412: x_loading_status := 'UNEXPECTED_ERR';
413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
414: FND_MSG_PUB.Count_And_Get
415: (
416: p_count => x_msg_count ,
417: p_data => x_msg_data ,
418: p_encoded => FND_API.G_FALSE

Line 424: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

420: WHEN OTHERS THEN
421: ROLLBACK TO Create_pay_element_input;
422: x_loading_status := 'UNEXPECTED_ERR';
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
424: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
425: THEN
426: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
427: END IF;
428: FND_MSG_PUB.Count_And_Get

Line 426: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

422: x_loading_status := 'UNEXPECTED_ERR';
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
424: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
425: THEN
426: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
427: END IF;
428: FND_MSG_PUB.Count_And_Get
429: (
430: p_count => x_msg_count ,

Line 428: FND_MSG_PUB.Count_And_Get

424: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
425: THEN
426: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
427: END IF;
428: FND_MSG_PUB.Count_And_Get
429: (
430: p_count => x_msg_count ,
431: p_data => x_msg_data ,
432: p_encoded => FND_API.G_FALSE

Line 479: FND_MSG_PUB.initialize;

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

Line 602: FND_MSG_PUB.Count_And_Get

598: IF FND_API.To_Boolean( p_commit ) THEN
599: COMMIT WORK;
600: END IF;
601: -- Standard call to get message count and if count is 1, get message info.
602: FND_MSG_PUB.Count_And_Get
603: (
604: p_count => x_msg_count ,
605: p_data => x_msg_data ,
606: p_encoded => FND_API.G_FALSE

Line 613: FND_MSG_PUB.Count_And_Get

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

Line 623: FND_MSG_PUB.Count_And_Get

619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
620: ROLLBACK TO Update_pay_element_input;
621: x_loading_status := 'UNEXPECTED_ERR';
622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
623: FND_MSG_PUB.Count_And_Get
624: (
625: p_count => x_msg_count ,
626: p_data => x_msg_data ,
627: p_encoded => FND_API.G_FALSE

Line 633: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

629: WHEN OTHERS THEN
630: ROLLBACK TO Update_pay_element_input;
631: x_loading_status := 'UNEXPECTED_ERR';
632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
633: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
634: THEN
635: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
636: END IF;
637: FND_MSG_PUB.Count_And_Get

Line 635: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

631: x_loading_status := 'UNEXPECTED_ERR';
632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
633: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
634: THEN
635: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
636: END IF;
637: FND_MSG_PUB.Count_And_Get
638: (
639: p_count => x_msg_count ,

Line 637: FND_MSG_PUB.Count_And_Get

633: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
634: THEN
635: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
636: END IF;
637: FND_MSG_PUB.Count_And_Get
638: (
639: p_count => x_msg_count ,
640: p_data => x_msg_data ,
641: p_encoded => FND_API.G_FALSE

Line 680: FND_MSG_PUB.initialize;

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

Line 698: FND_MSG_PUB.Count_And_Get

694: IF FND_API.To_Boolean( p_commit ) THEN
695: COMMIT WORK;
696: END IF;
697: -- Standard call to get message count and if count is 1, get message info.
698: FND_MSG_PUB.Count_And_Get
699: (
700: p_count => x_msg_count ,
701: p_data => x_msg_data ,
702: p_encoded => FND_API.G_FALSE

Line 709: FND_MSG_PUB.Count_And_Get

705: EXCEPTION
706: WHEN FND_API.G_EXC_ERROR THEN
707: ROLLBACK TO Delete_pay_element_input;
708: x_return_status := FND_API.G_RET_STS_ERROR ;
709: FND_MSG_PUB.Count_And_Get
710: (
711: p_count => x_msg_count ,
712: p_data => x_msg_data ,
713: p_encoded => FND_API.G_FALSE

Line 719: FND_MSG_PUB.Count_And_Get

715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
716: ROLLBACK TO Delete_Pay_Element_Input;
717: x_loading_status := 'UNEXPECTED_ERR';
718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
719: FND_MSG_PUB.Count_And_Get
720: (
721: p_count => x_msg_count ,
722: p_data => x_msg_data ,
723: p_encoded => FND_API.G_FALSE

Line 729: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

725: WHEN OTHERS THEN
726: ROLLBACK TO Delete_pay_element_input;
727: x_loading_status := 'UNEXPECTED_ERR';
728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
729: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
730: THEN
731: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
732: END IF;
733: FND_MSG_PUB.Count_And_Get

Line 731: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

727: x_loading_status := 'UNEXPECTED_ERR';
728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
729: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
730: THEN
731: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
732: END IF;
733: FND_MSG_PUB.Count_And_Get
734: (
735: p_count => x_msg_count ,

Line 733: FND_MSG_PUB.Count_And_Get

729: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
730: THEN
731: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
732: END IF;
733: FND_MSG_PUB.Count_And_Get
734: (
735: p_count => x_msg_count ,
736: p_data => x_msg_data ,
737: p_encoded => FND_API.G_FALSE

Line 863: FND_MSG_PUB.initialize;

859: --
860: -- Initialize message list if p_init_msg_list is set to TRUE.
861: --
862: IF FND_API.to_Boolean( p_init_msg_list ) THEN
863: FND_MSG_PUB.initialize;
864: END IF;
865: --
866: -- Initialize API return status to success
867: --

Line 936: FND_MSG_PUB.Count_And_Get

932: x_loading_status := 'SELECTED';
933:
934: -- End of API body.
935:
936: FND_MSG_PUB.Count_And_Get
937: (
938: p_count => x_msg_count ,
939: p_data => x_msg_data ,
940: p_encoded => FND_API.G_FALSE

Line 947: FND_MSG_PUB.Count_And_Get

943: EXCEPTION
944: WHEN FND_API.G_EXC_ERROR THEN
945:
946: x_return_status := FND_API.G_RET_STS_ERROR ;
947: FND_MSG_PUB.Count_And_Get
948: (
949: p_count => x_msg_count ,
950: p_data => x_msg_data ,
951: p_encoded => FND_API.G_FALSE

Line 957: FND_MSG_PUB.Count_And_Get

953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
954:
955: x_loading_status := 'UNEXPECTED_ERR';
956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
957: FND_MSG_PUB.Count_And_Get
958: (
959: p_count => x_msg_count ,
960: p_data => x_msg_data ,
961: p_encoded => FND_API.G_FALSE

Line 967: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

963: WHEN OTHERS THEN
964:
965: x_loading_status := 'UNEXPECTED_ERR';
966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
967: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
968: THEN
969: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
970: END IF;
971: FND_MSG_PUB.Count_And_Get (

Line 969: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

965: x_loading_status := 'UNEXPECTED_ERR';
966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
967: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
968: THEN
969: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
970: END IF;
971: FND_MSG_PUB.Count_And_Get (
972: p_count => x_msg_count ,
973: p_data => x_msg_data ,

Line 971: FND_MSG_PUB.Count_And_Get (

967: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
968: THEN
969: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
970: END IF;
971: FND_MSG_PUB.Count_And_Get (
972: p_count => x_msg_count ,
973: p_data => x_msg_data ,
974: p_encoded => FND_API.G_FALSE
975: );