82: END IF;
83:
84: -- Check p_init_msg_list
85: IF FND_API.to_Boolean( p_init_msg_list ) THEN
86: FND_MSG_PUB.initialize;
87: END IF;
88:
89: -- Initialize API return status to success
90: x_return_status := FND_API.G_RET_STS_SUCCESS;
122: WHEN GL_CURRENCY_API.NO_RATE THEN
123: ROLLBACK TO Get_Currency_Details_PVT;
124: x_return_status := FND_API.G_RET_STS_ERROR;
125: FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
126: FND_MSG_PUB.ADD;
127: FND_MSG_PUB.Count_And_Get(
128: p_encoded => FND_API.G_FALSE,
129: p_count => x_msg_count,
130: p_data => x_msg_data);
123: ROLLBACK TO Get_Currency_Details_PVT;
124: x_return_status := FND_API.G_RET_STS_ERROR;
125: FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
126: FND_MSG_PUB.ADD;
127: FND_MSG_PUB.Count_And_Get(
128: p_encoded => FND_API.G_FALSE,
129: p_count => x_msg_count,
130: p_data => x_msg_data);
131: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
131: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
132: ROLLBACK TO Get_Currency_Details_PVT;
133: x_return_status := FND_API.G_RET_STS_ERROR;
134: FND_MESSAGE.SET_NAME('SQLGL', 'GL INVALID CURRENCY CODE');
135: FND_MSG_PUB.ADD;
136: FND_MSG_PUB.Count_And_Get(
137: p_encoded => FND_API.G_FALSE,
138: p_count => x_msg_count,
139: p_data => x_msg_data);
132: ROLLBACK TO Get_Currency_Details_PVT;
133: x_return_status := FND_API.G_RET_STS_ERROR;
134: FND_MESSAGE.SET_NAME('SQLGL', 'GL INVALID CURRENCY CODE');
135: FND_MSG_PUB.ADD;
136: FND_MSG_PUB.Count_And_Get(
137: p_encoded => FND_API.G_FALSE,
138: p_count => x_msg_count,
139: p_data => x_msg_data);
140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
139: p_data => x_msg_data);
140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
141: ROLLBACK TO Get_Currency_Details_PVT;
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: FND_MSG_PUB.Count_And_Get(
144: p_encoded => FND_API.G_FALSE,
145: p_count => x_msg_count,
146: p_data => x_msg_data);
147: WHEN OTHERS THEN
146: p_data => x_msg_data);
147: WHEN OTHERS THEN
148: ROLLBACK TO Get_Currency_Details_PVT;
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150: FND_MSG_PUB.Count_And_Get(
151: p_encoded => FND_API.G_FALSE,
152: p_count => x_msg_count,
153: p_data => x_msg_data);
154: END;
212: END IF;
213:
214: -- Check p_init_msg_list
215: IF FND_API.to_Boolean( p_init_msg_list ) THEN
216: FND_MSG_PUB.initialize;
217: END IF;
218:
219:
220: -- Initialize API return status to success
242: WHEN GL_CURRENCY_API.NO_RATE THEN
243: ROLLBACK TO Curr_Round_Amount_PVT;
244: x_return_status := FND_API.G_RET_STS_ERROR;
245: FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
246: FND_MSG_PUB.ADD;
247: FND_MSG_PUB.Count_And_Get(
248: p_encoded => FND_API.G_FALSE,
249: p_count => x_msg_count,
250: p_data => x_msg_data);
243: ROLLBACK TO Curr_Round_Amount_PVT;
244: x_return_status := FND_API.G_RET_STS_ERROR;
245: FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
246: FND_MSG_PUB.ADD;
247: FND_MSG_PUB.Count_And_Get(
248: p_encoded => FND_API.G_FALSE,
249: p_count => x_msg_count,
250: p_data => x_msg_data);
251: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
251: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
252: ROLLBACK TO Curr_Round_Amount_PVT;
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: FND_MESSAGE.SET_NAME('SQLGL', 'GL INVALID CURRENCY CODE');
255: FND_MSG_PUB.ADD;
256: FND_MSG_PUB.Count_And_Get(
257: p_encoded => FND_API.G_FALSE,
258: p_count => x_msg_count,
259: p_data => x_msg_data);
252: ROLLBACK TO Curr_Round_Amount_PVT;
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: FND_MESSAGE.SET_NAME('SQLGL', 'GL INVALID CURRENCY CODE');
255: FND_MSG_PUB.ADD;
256: FND_MSG_PUB.Count_And_Get(
257: p_encoded => FND_API.G_FALSE,
258: p_count => x_msg_count,
259: p_data => x_msg_data);
260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
259: p_data => x_msg_data);
260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
261: ROLLBACK TO Curr_Round_Amount_PVT;
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
263: FND_MSG_PUB.Count_And_Get(
264: p_encoded => FND_API.G_FALSE,
265: p_count => x_msg_count,
266: p_data => x_msg_data);
267: WHEN OTHERS THEN
266: p_data => x_msg_data);
267: WHEN OTHERS THEN
268: ROLLBACK TO Curr_Round_Amount_PVT;
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: FND_MSG_PUB.Count_And_Get(
271: p_encoded => FND_API.G_FALSE,
272: p_count => x_msg_count,
273: p_data => x_msg_data);
274: END;
387: END IF;
388:
389: -- Check p_init_msg_list
390: IF FND_API.to_Boolean( p_init_msg_list ) THEN
391: FND_MSG_PUB.initialize;
392: END IF;
393:
394:
395: -- Initialize API return status to success
489: WHEN GL_CURRENCY_API.NO_RATE THEN
490: ROLLBACK TO Functional_Amount_PVT;
491: x_return_status := FND_API.G_RET_STS_ERROR;
492: FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
493: FND_MSG_PUB.ADD;
494: FND_MSG_PUB.Count_And_Get(
495: p_encoded => FND_API.G_FALSE,
496: p_count => x_msg_count,
497: p_data => x_msg_data);
490: ROLLBACK TO Functional_Amount_PVT;
491: x_return_status := FND_API.G_RET_STS_ERROR;
492: FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
493: FND_MSG_PUB.ADD;
494: FND_MSG_PUB.Count_And_Get(
495: p_encoded => FND_API.G_FALSE,
496: p_count => x_msg_count,
497: p_data => x_msg_data);
498: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
498: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
499: ROLLBACK TO Functional_Amount_PVT;
500: x_return_status := FND_API.G_RET_STS_ERROR;
501: FND_MESSAGE.SET_NAME('SQLGL', 'GL INVALID CURRENCY CODE');
502: FND_MSG_PUB.ADD;
503: FND_MSG_PUB.Count_And_Get(
504: p_encoded => FND_API.G_FALSE,
505: p_count => x_msg_count,
506: p_data => x_msg_data);
499: ROLLBACK TO Functional_Amount_PVT;
500: x_return_status := FND_API.G_RET_STS_ERROR;
501: FND_MESSAGE.SET_NAME('SQLGL', 'GL INVALID CURRENCY CODE');
502: FND_MSG_PUB.ADD;
503: FND_MSG_PUB.Count_And_Get(
504: p_encoded => FND_API.G_FALSE,
505: p_count => x_msg_count,
506: p_data => x_msg_data);
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
506: p_data => x_msg_data);
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
508: ROLLBACK TO Functional_Amount_PVT;
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510: FND_MSG_PUB.Count_And_Get(
511: p_encoded => FND_API.G_FALSE,
512: p_count => x_msg_count,
513: p_data => x_msg_data);
514: WHEN OTHERS THEN
513: p_data => x_msg_data);
514: WHEN OTHERS THEN
515: ROLLBACK TO Functional_Amount_PVT;
516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
517: FND_MSG_PUB.Count_And_Get(
518: p_encoded => FND_API.G_FALSE,
519: p_count => x_msg_count,
520: p_data => x_msg_data);
521: END Get_Functional_Amount;
599: END IF;
600:
601: -- Check p_init_msg_list
602: IF FND_API.to_Boolean( p_init_msg_list ) THEN
603: FND_MSG_PUB.initialize;
604: END IF;
605:
606: -- Initialize API return status to success
607: x_return_status := FND_API.G_RET_STS_SUCCESS;
656: WHEN GL_CURRENCY_API.NO_RATE THEN
657: ROLLBACK TO Func_Amt_Rate_PVT;
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
660: FND_MSG_PUB.ADD;
661: FND_MSG_PUB.Count_And_Get(
662: p_encoded => FND_API.G_FALSE,
663: p_count => x_msg_count,
664: p_data => x_msg_data);
657: ROLLBACK TO Func_Amt_Rate_PVT;
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
660: FND_MSG_PUB.ADD;
661: FND_MSG_PUB.Count_And_Get(
662: p_encoded => FND_API.G_FALSE,
663: p_count => x_msg_count,
664: p_data => x_msg_data);
665: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
665: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
666: ROLLBACK TO Func_Amt_Rate_PVT;
667: x_return_status := FND_API.G_RET_STS_ERROR;
668: FND_MESSAGE.SET_NAME('SQLGL', 'GL INVALID CURRENCY CODE');
669: FND_MSG_PUB.ADD;
670: FND_MSG_PUB.Count_And_Get(
671: p_encoded => FND_API.G_FALSE,
672: p_count => x_msg_count,
673: p_data => x_msg_data);
666: ROLLBACK TO Func_Amt_Rate_PVT;
667: x_return_status := FND_API.G_RET_STS_ERROR;
668: FND_MESSAGE.SET_NAME('SQLGL', 'GL INVALID CURRENCY CODE');
669: FND_MSG_PUB.ADD;
670: FND_MSG_PUB.Count_And_Get(
671: p_encoded => FND_API.G_FALSE,
672: p_count => x_msg_count,
673: p_data => x_msg_data);
674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
673: p_data => x_msg_data);
674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
675: ROLLBACK TO Func_Amt_Rate_PVT;
676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
677: FND_MSG_PUB.Count_And_Get(
678: p_encoded => FND_API.G_FALSE,
679: p_count => x_msg_count,
680: p_data => x_msg_data);
681: WHEN OTHERS THEN
680: p_data => x_msg_data);
681: WHEN OTHERS THEN
682: ROLLBACK TO Func_Amt_Rate_PVT;
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
684: FND_MSG_PUB.Count_And_Get(
685: p_encoded => FND_API.G_FALSE,
686: p_count => x_msg_count,
687: p_data => x_msg_data);
688: END Get_Func_Amt_Rate;
775: END IF;
776:
777: -- Check p_init_msg_list
778: IF FND_API.to_Boolean( p_init_msg_list ) THEN
779: FND_MSG_PUB.initialize;
780: END IF;
781:
782:
783: -- Initialize API return status to success
852: WHEN GL_CURRENCY_API.NO_RATE THEN
853: ROLLBACK TO Func_Amt_Curr_Pvt;
854: x_return_status := FND_API.G_RET_STS_ERROR;
855: FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
856: FND_MSG_PUB.ADD;
857: FND_MSG_PUB.Count_And_Get(
858: p_encoded => FND_API.G_FALSE,
859: p_count => x_msg_count,
860: p_data => x_msg_data);
853: ROLLBACK TO Func_Amt_Curr_Pvt;
854: x_return_status := FND_API.G_RET_STS_ERROR;
855: FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
856: FND_MSG_PUB.ADD;
857: FND_MSG_PUB.Count_And_Get(
858: p_encoded => FND_API.G_FALSE,
859: p_count => x_msg_count,
860: p_data => x_msg_data);
861: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
861: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
862: ROLLBACK TO Func_Amt_Curr_Pvt;
863: x_return_status := FND_API.G_RET_STS_ERROR;
864: FND_MESSAGE.SET_NAME('SQLGL', 'GL INVALID CURRENCY CODE');
865: FND_MSG_PUB.ADD;
866: FND_MSG_PUB.Count_And_Get(
867: p_encoded => FND_API.G_FALSE,
868: p_count => x_msg_count,
869: p_data => x_msg_data);
862: ROLLBACK TO Func_Amt_Curr_Pvt;
863: x_return_status := FND_API.G_RET_STS_ERROR;
864: FND_MESSAGE.SET_NAME('SQLGL', 'GL INVALID CURRENCY CODE');
865: FND_MSG_PUB.ADD;
866: FND_MSG_PUB.Count_And_Get(
867: p_encoded => FND_API.G_FALSE,
868: p_count => x_msg_count,
869: p_data => x_msg_data);
870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
869: p_data => x_msg_data);
870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
871: ROLLBACK TO Func_Amt_Curr_Pvt;
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
873: FND_MSG_PUB.Count_And_Get(
874: p_encoded => FND_API.G_FALSE,
875: p_count => x_msg_count,
876: p_data => x_msg_data);
877: WHEN OTHERS THEN
876: p_data => x_msg_data);
877: WHEN OTHERS THEN
878: ROLLBACK TO Func_Amt_Curr_Pvt;
879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
880: FND_MSG_PUB.Count_And_Get(
881: p_encoded => FND_API.G_FALSE,
882: p_count => x_msg_count,
883: p_data => x_msg_data);
884: END Get_Func_Amt_Curr;
955: END IF;
956:
957: -- Check p_init_msg_list
958: IF FND_API.to_Boolean( p_init_msg_list ) THEN
959: FND_MSG_PUB.initialize;
960: END IF;
961:
962: -- Initialize API return status to success
963: x_return_status := FND_API.G_RET_STS_SUCCESS;
973: WHEN GL_CURRENCY_API.NO_RATE THEN
974: ROLLBACK TO Convert_Amount_Curr_PVT;
975: x_return_status := FND_API.G_RET_STS_ERROR;
976: FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
977: FND_MSG_PUB.ADD;
978: FND_MSG_PUB.Count_And_Get(
979: p_encoded => FND_API.G_FALSE,
980: p_count => x_msg_count,
981: p_data => x_msg_data);
974: ROLLBACK TO Convert_Amount_Curr_PVT;
975: x_return_status := FND_API.G_RET_STS_ERROR;
976: FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
977: FND_MSG_PUB.ADD;
978: FND_MSG_PUB.Count_And_Get(
979: p_encoded => FND_API.G_FALSE,
980: p_count => x_msg_count,
981: p_data => x_msg_data);
982: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
982: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
983: ROLLBACK TO Convert_Amount_Curr_PVT;
984: x_return_status := FND_API.G_RET_STS_ERROR;
985: FND_MESSAGE.SET_NAME('SQLGL', 'GL INVALID CURRENCY CODE');
986: FND_MSG_PUB.ADD;
987: FND_MSG_PUB.Count_And_Get(
988: p_encoded => FND_API.G_FALSE,
989: p_count => x_msg_count,
990: p_data => x_msg_data);
983: ROLLBACK TO Convert_Amount_Curr_PVT;
984: x_return_status := FND_API.G_RET_STS_ERROR;
985: FND_MESSAGE.SET_NAME('SQLGL', 'GL INVALID CURRENCY CODE');
986: FND_MSG_PUB.ADD;
987: FND_MSG_PUB.Count_And_Get(
988: p_encoded => FND_API.G_FALSE,
989: p_count => x_msg_count,
990: p_data => x_msg_data);
991: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
990: p_data => x_msg_data);
991: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
992: ROLLBACK TO Convert_Amount_Curr_PVT;
993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
994: FND_MSG_PUB.Count_And_Get(
995: p_encoded => FND_API.G_FALSE,
996: p_count => x_msg_count,
997: p_data => x_msg_data);
998: WHEN OTHERS THEN
997: p_data => x_msg_data);
998: WHEN OTHERS THEN
999: ROLLBACK TO Convert_Amount_Curr_PVT;
1000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1001: FND_MSG_PUB.Count_And_Get(
1002: p_encoded => FND_API.G_FALSE,
1003: p_count => x_msg_count,
1004: p_data => x_msg_data);
1005: END;
1078: END IF;
1079:
1080: -- Check p_init_msg_list
1081: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1082: FND_MSG_PUB.initialize;
1083: END IF;
1084:
1085: -- Initialize API return status to success
1086: x_return_status := FND_API.G_RET_STS_SUCCESS;
1096: WHEN GL_CURRENCY_API.NO_RATE THEN
1097: ROLLBACK TO Convert_Amount_Sob_PVT;
1098: x_return_status := FND_API.G_RET_STS_ERROR;
1099: FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
1100: FND_MSG_PUB.ADD;
1101: FND_MSG_PUB.Count_And_Get(
1102: p_encoded => FND_API.G_FALSE,
1103: p_count => x_msg_count,
1104: p_data => x_msg_data);
1097: ROLLBACK TO Convert_Amount_Sob_PVT;
1098: x_return_status := FND_API.G_RET_STS_ERROR;
1099: FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
1100: FND_MSG_PUB.ADD;
1101: FND_MSG_PUB.Count_And_Get(
1102: p_encoded => FND_API.G_FALSE,
1103: p_count => x_msg_count,
1104: p_data => x_msg_data);
1105: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
1105: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
1106: ROLLBACK TO Convert_Amount_Sob_PVT;
1107: x_return_status := FND_API.G_RET_STS_ERROR;
1108: FND_MESSAGE.SET_NAME('SQLGL', 'GL INVALID CURRENCY CODE');
1109: FND_MSG_PUB.ADD;
1110: FND_MSG_PUB.Count_And_Get(
1111: p_encoded => FND_API.G_FALSE,
1112: p_count => x_msg_count,
1113: p_data => x_msg_data);
1106: ROLLBACK TO Convert_Amount_Sob_PVT;
1107: x_return_status := FND_API.G_RET_STS_ERROR;
1108: FND_MESSAGE.SET_NAME('SQLGL', 'GL INVALID CURRENCY CODE');
1109: FND_MSG_PUB.ADD;
1110: FND_MSG_PUB.Count_And_Get(
1111: p_encoded => FND_API.G_FALSE,
1112: p_count => x_msg_count,
1113: p_data => x_msg_data);
1114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1113: p_data => x_msg_data);
1114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1115: ROLLBACK TO Convert_Amount_Sob_PVT;
1116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1117: FND_MSG_PUB.Count_And_Get(
1118: p_encoded => FND_API.G_FALSE,
1119: p_count => x_msg_count,
1120: p_data => x_msg_data);
1121: WHEN OTHERS THEN
1120: p_data => x_msg_data);
1121: WHEN OTHERS THEN
1122: ROLLBACK TO Convert_Amount_Sob_PVT;
1123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1124: FND_MSG_PUB.Count_And_Get(
1125: p_encoded => FND_API.G_FALSE,
1126: p_count => x_msg_count,
1127: p_data => x_msg_data);
1128: END;
1181: END IF;
1182:
1183: -- Check p_init_msg_list
1184: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1185: FND_MSG_PUB.initialize;
1186: END IF;
1187:
1188: -- Initialize API return status to success
1189: x_return_status := FND_API.G_RET_STS_SUCCESS;
1209: -- WHEN GL_CURRENCY_API.NO_RATE THEN
1210: -- ROLLBACK TO Funct_Curr_PVT;
1211: -- x_return_status := FND_API.G_RET_STS_ERROR;
1212: -- FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
1213: -- FND_MSG_PUB.ADD;
1214: -- FND_MSG_PUB.Count_And_Get(
1215: -- p_encoded => FND_API.G_FALSE,
1216: -- p_count => x_msg_count,
1217: -- p_data => x_msg_data);
1210: -- ROLLBACK TO Funct_Curr_PVT;
1211: -- x_return_status := FND_API.G_RET_STS_ERROR;
1212: -- FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
1213: -- FND_MSG_PUB.ADD;
1214: -- FND_MSG_PUB.Count_And_Get(
1215: -- p_encoded => FND_API.G_FALSE,
1216: -- p_count => x_msg_count,
1217: -- p_data => x_msg_data);
1218: -- WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
1218: -- WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
1219: -- ROLLBACK TO Funct_Curr_PVT;
1220: -- x_return_status := FND_API.G_RET_STS_ERROR;
1221: -- FND_MESSAGE.SET_NAME('SQLGL', 'GL INVALID CURRENCY CODE');
1222: -- FND_MSG_PUB.ADD;
1223: -- FND_MSG_PUB.Count_And_Get(
1224: -- p_encoded => FND_API.G_FALSE,
1225: -- p_count => x_msg_count,
1226: -- p_data => x_msg_data);
1219: -- ROLLBACK TO Funct_Curr_PVT;
1220: -- x_return_status := FND_API.G_RET_STS_ERROR;
1221: -- FND_MESSAGE.SET_NAME('SQLGL', 'GL INVALID CURRENCY CODE');
1222: -- FND_MSG_PUB.ADD;
1223: -- FND_MSG_PUB.Count_And_Get(
1224: -- p_encoded => FND_API.G_FALSE,
1225: -- p_count => x_msg_count,
1226: -- p_data => x_msg_data);
1227: -- WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1226: -- p_data => x_msg_data);
1227: -- WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1228: -- ROLLBACK TO Funct_Curr_PVT;
1229: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1230: -- FND_MSG_PUB.Count_And_Get(
1231: -- p_encoded => FND_API.G_FALSE,
1232: -- p_count => x_msg_count,
1233: -- p_data => x_msg_data);
1234: -- WHEN OTHERS THEN
1233: -- p_data => x_msg_data);
1234: -- WHEN OTHERS THEN
1235: -- ROLLBACK TO Funct_Curr_PVT;
1236: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1237: -- FND_MSG_PUB.Count_And_Get(
1238: -- p_encoded => FND_API.G_FALSE,
1239: -- p_count => x_msg_count,
1240: -- p_data => x_msg_data);
1241: WHEN OTHERS THEN
1302: END IF;
1303:
1304: -- Check p_init_msg_list
1305: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1306: FND_MSG_PUB.initialize;
1307: END IF;
1308:
1309: -- Initialize API return status to success
1310: x_return_status := FND_API.G_RET_STS_SUCCESS;
1315: WHEN GL_CURRENCY_API.NO_RATE THEN
1316: ROLLBACK TO Get_Format_Mask_PVT;
1317: x_return_status := FND_API.G_RET_STS_ERROR;
1318: FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
1319: FND_MSG_PUB.ADD;
1320: FND_MSG_PUB.Count_And_Get(
1321: p_encoded => FND_API.G_FALSE,
1322: p_count => x_msg_count,
1323: p_data => x_msg_data);
1316: ROLLBACK TO Get_Format_Mask_PVT;
1317: x_return_status := FND_API.G_RET_STS_ERROR;
1318: FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
1319: FND_MSG_PUB.ADD;
1320: FND_MSG_PUB.Count_And_Get(
1321: p_encoded => FND_API.G_FALSE,
1322: p_count => x_msg_count,
1323: p_data => x_msg_data);
1324: WHEN OTHERS THEN
1323: p_data => x_msg_data);
1324: WHEN OTHERS THEN
1325: ROLLBACK TO Get_Format_Mask_PVT;
1326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1327: FND_MSG_PUB.Count_And_Get(
1328: p_encoded => FND_API.G_FALSE,
1329: p_count => x_msg_count,
1330: p_data => x_msg_data);
1331: END Get_Format_Mask;