[Home] [Help]
121: EXCEPTION
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);
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,
241: EXCEPTION
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);
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,
435: (l_min_acc_unit IS NULL)) OR
436: (l_amount IS NULL) ) THEN
437: BEGIN
438:
439: /* fnd_message('STD-FUNCT-AMT-INV-PAR'); */
440:
441: RAISE l_invalid_params_exp;
442:
443: END;
455: CLOSE curr_info;
456:
457: IF (l_curr_rec.currency_code IS NULL) THEN
458:
459: /* fnd_message('STD-FUNCT-AMT-CURR-NF',
460: 'CURR',
461: currency_code); */
462:
463: RAISE l_invalid_params_exp;
488: EXCEPTION
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);
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,
632: (l_precision IS NULL) AND
633: (l_min_acc_unit IS NULL)) OR
634: (l_amount_original IS NULL) ) THEN
635: BEGIN
636: /* fnd_message('STD-FUNCT-AMT-INV-PAR'); */
637: RAISE l_invalid_params_exp;
638: END;
639: END IF;
640:
655: EXCEPTION
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);
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,
812: (l_min_acc_unit IS NULL)) OR
813: (l_amount_original IS NULL) ) THEN
814: BEGIN
815:
816: /* fnd_message('STD-FUNCT-AMT-INV-PAR'); */
817:
818: RAISE l_invalid_params_exp;
819:
820: END;
851: EXCEPTION
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);
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,
972: EXCEPTION
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);
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,
1095: EXCEPTION
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);
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,
1208: EXCEPTION
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);
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,
1314: EXCEPTION
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,