1280: Commit;
1281: Exception
1282: When Trx_Num_Not_Numeric_Excpt Then
1283: Rollback;
1284: Fnd_Message.Set_Name('FUN','FUN_TRX_NUM_NOT_NUMERIC');
1285: Fnd_Message.Raise_Error;
1286:
1287: When Initiator_Excpt Then
1288: Rollback;
1281: Exception
1282: When Trx_Num_Not_Numeric_Excpt Then
1283: Rollback;
1284: Fnd_Message.Set_Name('FUN','FUN_TRX_NUM_NOT_NUMERIC');
1285: Fnd_Message.Raise_Error;
1286:
1287: When Initiator_Excpt Then
1288: Rollback;
1289: Fnd_Message.Set_Name('FUN','FUN_API_INVALID_INITIATOR');
1285: Fnd_Message.Raise_Error;
1286:
1287: When Initiator_Excpt Then
1288: Rollback;
1289: Fnd_Message.Set_Name('FUN','FUN_API_INVALID_INITIATOR');
1290: Fnd_Message.Raise_Error;
1291: When Trx_Type_Excpt Then
1292: Rollback;
1293: Fnd_Message.Set_Name('FUN','FUN_TRX_TYPE_NOT_FOUND');
1286:
1287: When Initiator_Excpt Then
1288: Rollback;
1289: Fnd_Message.Set_Name('FUN','FUN_API_INVALID_INITIATOR');
1290: Fnd_Message.Raise_Error;
1291: When Trx_Type_Excpt Then
1292: Rollback;
1293: Fnd_Message.Set_Name('FUN','FUN_TRX_TYPE_NOT_FOUND');
1294: Fnd_Message.Raise_Error;
1289: Fnd_Message.Set_Name('FUN','FUN_API_INVALID_INITIATOR');
1290: Fnd_Message.Raise_Error;
1291: When Trx_Type_Excpt Then
1292: Rollback;
1293: Fnd_Message.Set_Name('FUN','FUN_TRX_TYPE_NOT_FOUND');
1294: Fnd_Message.Raise_Error;
1295: When Tran_Reci_Diff_Excpt Then
1296: Rollback;
1297: Fnd_Message.Set_Name('FUN','FUN_ADI_TRAN_RECI_DIFF');
1290: Fnd_Message.Raise_Error;
1291: When Trx_Type_Excpt Then
1292: Rollback;
1293: Fnd_Message.Set_Name('FUN','FUN_TRX_TYPE_NOT_FOUND');
1294: Fnd_Message.Raise_Error;
1295: When Tran_Reci_Diff_Excpt Then
1296: Rollback;
1297: Fnd_Message.Set_Name('FUN','FUN_ADI_TRAN_RECI_DIFF');
1298: Fnd_Message.Set_Token('RECI_NAME', l_reci_name);
1293: Fnd_Message.Set_Name('FUN','FUN_TRX_TYPE_NOT_FOUND');
1294: Fnd_Message.Raise_Error;
1295: When Tran_Reci_Diff_Excpt Then
1296: Rollback;
1297: Fnd_Message.Set_Name('FUN','FUN_ADI_TRAN_RECI_DIFF');
1298: Fnd_Message.Set_Token('RECI_NAME', l_reci_name);
1299: Fnd_Message.Raise_Error;
1300: When Tran_Dupl_Row_Excpt Then
1301: Rollback;
1294: Fnd_Message.Raise_Error;
1295: When Tran_Reci_Diff_Excpt Then
1296: Rollback;
1297: Fnd_Message.Set_Name('FUN','FUN_ADI_TRAN_RECI_DIFF');
1298: Fnd_Message.Set_Token('RECI_NAME', l_reci_name);
1299: Fnd_Message.Raise_Error;
1300: When Tran_Dupl_Row_Excpt Then
1301: Rollback;
1302: Fnd_Message.Set_Name('FUN','FUN_ADI_TRAN_DUP_ERROR');
1295: When Tran_Reci_Diff_Excpt Then
1296: Rollback;
1297: Fnd_Message.Set_Name('FUN','FUN_ADI_TRAN_RECI_DIFF');
1298: Fnd_Message.Set_Token('RECI_NAME', l_reci_name);
1299: Fnd_Message.Raise_Error;
1300: When Tran_Dupl_Row_Excpt Then
1301: Rollback;
1302: Fnd_Message.Set_Name('FUN','FUN_ADI_TRAN_DUP_ERROR');
1303: Fnd_Message.Set_Token('TRX_NUMBER', l_trx_tbl(l_count).trx_number);
1298: Fnd_Message.Set_Token('RECI_NAME', l_reci_name);
1299: Fnd_Message.Raise_Error;
1300: When Tran_Dupl_Row_Excpt Then
1301: Rollback;
1302: Fnd_Message.Set_Name('FUN','FUN_ADI_TRAN_DUP_ERROR');
1303: Fnd_Message.Set_Token('TRX_NUMBER', l_trx_tbl(l_count).trx_number);
1304: Fnd_Message.Set_Token('DEBIT', l_trx_tbl(l_count).init_amount_dr);
1305: Fnd_Message.Set_Token('CREDIT', l_trx_tbl(l_count).init_amount_cr);
1306: Fnd_Message.Raise_Error;
1299: Fnd_Message.Raise_Error;
1300: When Tran_Dupl_Row_Excpt Then
1301: Rollback;
1302: Fnd_Message.Set_Name('FUN','FUN_ADI_TRAN_DUP_ERROR');
1303: Fnd_Message.Set_Token('TRX_NUMBER', l_trx_tbl(l_count).trx_number);
1304: Fnd_Message.Set_Token('DEBIT', l_trx_tbl(l_count).init_amount_dr);
1305: Fnd_Message.Set_Token('CREDIT', l_trx_tbl(l_count).init_amount_cr);
1306: Fnd_Message.Raise_Error;
1307: When Recipient_Excpt Then
1300: When Tran_Dupl_Row_Excpt Then
1301: Rollback;
1302: Fnd_Message.Set_Name('FUN','FUN_ADI_TRAN_DUP_ERROR');
1303: Fnd_Message.Set_Token('TRX_NUMBER', l_trx_tbl(l_count).trx_number);
1304: Fnd_Message.Set_Token('DEBIT', l_trx_tbl(l_count).init_amount_dr);
1305: Fnd_Message.Set_Token('CREDIT', l_trx_tbl(l_count).init_amount_cr);
1306: Fnd_Message.Raise_Error;
1307: When Recipient_Excpt Then
1308: Rollback;
1301: Rollback;
1302: Fnd_Message.Set_Name('FUN','FUN_ADI_TRAN_DUP_ERROR');
1303: Fnd_Message.Set_Token('TRX_NUMBER', l_trx_tbl(l_count).trx_number);
1304: Fnd_Message.Set_Token('DEBIT', l_trx_tbl(l_count).init_amount_dr);
1305: Fnd_Message.Set_Token('CREDIT', l_trx_tbl(l_count).init_amount_cr);
1306: Fnd_Message.Raise_Error;
1307: When Recipient_Excpt Then
1308: Rollback;
1309: Fnd_Message.Set_Name('FUN','FUN_API_INVALID_RECIPIENT');
1302: Fnd_Message.Set_Name('FUN','FUN_ADI_TRAN_DUP_ERROR');
1303: Fnd_Message.Set_Token('TRX_NUMBER', l_trx_tbl(l_count).trx_number);
1304: Fnd_Message.Set_Token('DEBIT', l_trx_tbl(l_count).init_amount_dr);
1305: Fnd_Message.Set_Token('CREDIT', l_trx_tbl(l_count).init_amount_cr);
1306: Fnd_Message.Raise_Error;
1307: When Recipient_Excpt Then
1308: Rollback;
1309: Fnd_Message.Set_Name('FUN','FUN_API_INVALID_RECIPIENT');
1310: Fnd_Message.Raise_Error;
1305: Fnd_Message.Set_Token('CREDIT', l_trx_tbl(l_count).init_amount_cr);
1306: Fnd_Message.Raise_Error;
1307: When Recipient_Excpt Then
1308: Rollback;
1309: Fnd_Message.Set_Name('FUN','FUN_API_INVALID_RECIPIENT');
1310: Fnd_Message.Raise_Error;
1311: When Dupl_Reci_In_Batch Then
1312: Rollback;
1313: Fnd_Message.Set_Name('FUN', 'FUN_API_DUPLICATE_RECP');
1306: Fnd_Message.Raise_Error;
1307: When Recipient_Excpt Then
1308: Rollback;
1309: Fnd_Message.Set_Name('FUN','FUN_API_INVALID_RECIPIENT');
1310: Fnd_Message.Raise_Error;
1311: When Dupl_Reci_In_Batch Then
1312: Rollback;
1313: Fnd_Message.Set_Name('FUN', 'FUN_API_DUPLICATE_RECP');
1314: Fnd_Message.Raise_Error;
1309: Fnd_Message.Set_Name('FUN','FUN_API_INVALID_RECIPIENT');
1310: Fnd_Message.Raise_Error;
1311: When Dupl_Reci_In_Batch Then
1312: Rollback;
1313: Fnd_Message.Set_Name('FUN', 'FUN_API_DUPLICATE_RECP');
1314: Fnd_Message.Raise_Error;
1315: When Amount_Req_Excpt Then
1316: Rollback;
1317: Fnd_Message.Set_Name('FUN','FUN_TRX_DR_CR_AMT');
1310: Fnd_Message.Raise_Error;
1311: When Dupl_Reci_In_Batch Then
1312: Rollback;
1313: Fnd_Message.Set_Name('FUN', 'FUN_API_DUPLICATE_RECP');
1314: Fnd_Message.Raise_Error;
1315: When Amount_Req_Excpt Then
1316: Rollback;
1317: Fnd_Message.Set_Name('FUN','FUN_TRX_DR_CR_AMT');
1318: Fnd_Message.Raise_Error;
1313: Fnd_Message.Set_Name('FUN', 'FUN_API_DUPLICATE_RECP');
1314: Fnd_Message.Raise_Error;
1315: When Amount_Req_Excpt Then
1316: Rollback;
1317: Fnd_Message.Set_Name('FUN','FUN_TRX_DR_CR_AMT');
1318: Fnd_Message.Raise_Error;
1319: When Init_Dupl_Row_Excpt Then
1320: Rollback;
1321: Fnd_Message.Set_Name('FUN','FUN_ADI_INIT_DUP_ERROR');
1314: Fnd_Message.Raise_Error;
1315: When Amount_Req_Excpt Then
1316: Rollback;
1317: Fnd_Message.Set_Name('FUN','FUN_TRX_DR_CR_AMT');
1318: Fnd_Message.Raise_Error;
1319: When Init_Dupl_Row_Excpt Then
1320: Rollback;
1321: Fnd_Message.Set_Name('FUN','FUN_ADI_INIT_DUP_ERROR');
1322: Fnd_Message.Set_Token('TRX_NUMBER', l_trx_tbl(l_count).trx_number);
1317: Fnd_Message.Set_Name('FUN','FUN_TRX_DR_CR_AMT');
1318: Fnd_Message.Raise_Error;
1319: When Init_Dupl_Row_Excpt Then
1320: Rollback;
1321: Fnd_Message.Set_Name('FUN','FUN_ADI_INIT_DUP_ERROR');
1322: Fnd_Message.Set_Token('TRX_NUMBER', l_trx_tbl(l_count).trx_number);
1323: Fnd_Message.Set_Token('DEBIT', l_dist_lines_tbl(l_count).amount_dr);
1324: Fnd_Message.Set_Token('CREDIT', l_dist_lines_tbl(l_count).amount_cr);
1325: Fnd_Message.Set_Token('DESCRIPTION', l_dist_lines_tbl(l_count).description);
1318: Fnd_Message.Raise_Error;
1319: When Init_Dupl_Row_Excpt Then
1320: Rollback;
1321: Fnd_Message.Set_Name('FUN','FUN_ADI_INIT_DUP_ERROR');
1322: Fnd_Message.Set_Token('TRX_NUMBER', l_trx_tbl(l_count).trx_number);
1323: Fnd_Message.Set_Token('DEBIT', l_dist_lines_tbl(l_count).amount_dr);
1324: Fnd_Message.Set_Token('CREDIT', l_dist_lines_tbl(l_count).amount_cr);
1325: Fnd_Message.Set_Token('DESCRIPTION', l_dist_lines_tbl(l_count).description);
1326: Fnd_Message.Raise_Error;
1319: When Init_Dupl_Row_Excpt Then
1320: Rollback;
1321: Fnd_Message.Set_Name('FUN','FUN_ADI_INIT_DUP_ERROR');
1322: Fnd_Message.Set_Token('TRX_NUMBER', l_trx_tbl(l_count).trx_number);
1323: Fnd_Message.Set_Token('DEBIT', l_dist_lines_tbl(l_count).amount_dr);
1324: Fnd_Message.Set_Token('CREDIT', l_dist_lines_tbl(l_count).amount_cr);
1325: Fnd_Message.Set_Token('DESCRIPTION', l_dist_lines_tbl(l_count).description);
1326: Fnd_Message.Raise_Error;
1327: When Init_Dist_Sum_Excpt Then
1320: Rollback;
1321: Fnd_Message.Set_Name('FUN','FUN_ADI_INIT_DUP_ERROR');
1322: Fnd_Message.Set_Token('TRX_NUMBER', l_trx_tbl(l_count).trx_number);
1323: Fnd_Message.Set_Token('DEBIT', l_dist_lines_tbl(l_count).amount_dr);
1324: Fnd_Message.Set_Token('CREDIT', l_dist_lines_tbl(l_count).amount_cr);
1325: Fnd_Message.Set_Token('DESCRIPTION', l_dist_lines_tbl(l_count).description);
1326: Fnd_Message.Raise_Error;
1327: When Init_Dist_Sum_Excpt Then
1328: Rollback;
1321: Fnd_Message.Set_Name('FUN','FUN_ADI_INIT_DUP_ERROR');
1322: Fnd_Message.Set_Token('TRX_NUMBER', l_trx_tbl(l_count).trx_number);
1323: Fnd_Message.Set_Token('DEBIT', l_dist_lines_tbl(l_count).amount_dr);
1324: Fnd_Message.Set_Token('CREDIT', l_dist_lines_tbl(l_count).amount_cr);
1325: Fnd_Message.Set_Token('DESCRIPTION', l_dist_lines_tbl(l_count).description);
1326: Fnd_Message.Raise_Error;
1327: When Init_Dist_Sum_Excpt Then
1328: Rollback;
1329: Fnd_Message.Set_Name('FUN','FUN_ADI_INIT_SUM_ERROR');
1322: Fnd_Message.Set_Token('TRX_NUMBER', l_trx_tbl(l_count).trx_number);
1323: Fnd_Message.Set_Token('DEBIT', l_dist_lines_tbl(l_count).amount_dr);
1324: Fnd_Message.Set_Token('CREDIT', l_dist_lines_tbl(l_count).amount_cr);
1325: Fnd_Message.Set_Token('DESCRIPTION', l_dist_lines_tbl(l_count).description);
1326: Fnd_Message.Raise_Error;
1327: When Init_Dist_Sum_Excpt Then
1328: Rollback;
1329: Fnd_Message.Set_Name('FUN','FUN_ADI_INIT_SUM_ERROR');
1330: Fnd_Message.Raise_Error;
1325: Fnd_Message.Set_Token('DESCRIPTION', l_dist_lines_tbl(l_count).description);
1326: Fnd_Message.Raise_Error;
1327: When Init_Dist_Sum_Excpt Then
1328: Rollback;
1329: Fnd_Message.Set_Name('FUN','FUN_ADI_INIT_SUM_ERROR');
1330: Fnd_Message.Raise_Error;
1331: When Init_Amount_Excpt Then
1332: Rollback;
1333: Fnd_Message.Set_Name('FUN','FUN_IC_INVALID_DRCR_DIST');
1326: Fnd_Message.Raise_Error;
1327: When Init_Dist_Sum_Excpt Then
1328: Rollback;
1329: Fnd_Message.Set_Name('FUN','FUN_ADI_INIT_SUM_ERROR');
1330: Fnd_Message.Raise_Error;
1331: When Init_Amount_Excpt Then
1332: Rollback;
1333: Fnd_Message.Set_Name('FUN','FUN_IC_INVALID_DRCR_DIST');
1334: Fnd_Message.Set_Token('TRX_NUMBER', p_trx_number);
1329: Fnd_Message.Set_Name('FUN','FUN_ADI_INIT_SUM_ERROR');
1330: Fnd_Message.Raise_Error;
1331: When Init_Amount_Excpt Then
1332: Rollback;
1333: Fnd_Message.Set_Name('FUN','FUN_IC_INVALID_DRCR_DIST');
1334: Fnd_Message.Set_Token('TRX_NUMBER', p_trx_number);
1335: Fnd_Message.Raise_Error;
1336: When Con_Seg_Not_Req_Excpt Then
1337: Rollback;
1330: Fnd_Message.Raise_Error;
1331: When Init_Amount_Excpt Then
1332: Rollback;
1333: Fnd_Message.Set_Name('FUN','FUN_IC_INVALID_DRCR_DIST');
1334: Fnd_Message.Set_Token('TRX_NUMBER', p_trx_number);
1335: Fnd_Message.Raise_Error;
1336: When Con_Seg_Not_Req_Excpt Then
1337: Rollback;
1338: Fnd_Message.Set_Name('FUN','FUN_ADI_CON_SEGS_NOT_REQ');
1331: When Init_Amount_Excpt Then
1332: Rollback;
1333: Fnd_Message.Set_Name('FUN','FUN_IC_INVALID_DRCR_DIST');
1334: Fnd_Message.Set_Token('TRX_NUMBER', p_trx_number);
1335: Fnd_Message.Raise_Error;
1336: When Con_Seg_Not_Req_Excpt Then
1337: Rollback;
1338: Fnd_Message.Set_Name('FUN','FUN_ADI_CON_SEGS_NOT_REQ');
1339: Fnd_Message.Raise_Error;
1334: Fnd_Message.Set_Token('TRX_NUMBER', p_trx_number);
1335: Fnd_Message.Raise_Error;
1336: When Con_Seg_Not_Req_Excpt Then
1337: Rollback;
1338: Fnd_Message.Set_Name('FUN','FUN_ADI_CON_SEGS_NOT_REQ');
1339: Fnd_Message.Raise_Error;
1340: When Con_Seg_Req_Excpt Then
1341: Rollback;
1342: Fnd_Message.Set_Name('FUN','FUN_ADI_CON_SEGS_REQ');
1335: Fnd_Message.Raise_Error;
1336: When Con_Seg_Not_Req_Excpt Then
1337: Rollback;
1338: Fnd_Message.Set_Name('FUN','FUN_ADI_CON_SEGS_NOT_REQ');
1339: Fnd_Message.Raise_Error;
1340: When Con_Seg_Req_Excpt Then
1341: Rollback;
1342: Fnd_Message.Set_Name('FUN','FUN_ADI_CON_SEGS_REQ');
1343: Fnd_Message.Raise_Error;
1338: Fnd_Message.Set_Name('FUN','FUN_ADI_CON_SEGS_NOT_REQ');
1339: Fnd_Message.Raise_Error;
1340: When Con_Seg_Req_Excpt Then
1341: Rollback;
1342: Fnd_Message.Set_Name('FUN','FUN_ADI_CON_SEGS_REQ');
1343: Fnd_Message.Raise_Error;
1344: When Ccid_Gen_Excpt Then
1345: Rollback;
1346: Fnd_Message.Set_Name('FUN','FUN_ADI_CCID_ERROR');
1339: Fnd_Message.Raise_Error;
1340: When Con_Seg_Req_Excpt Then
1341: Rollback;
1342: Fnd_Message.Set_Name('FUN','FUN_ADI_CON_SEGS_REQ');
1343: Fnd_Message.Raise_Error;
1344: When Ccid_Gen_Excpt Then
1345: Rollback;
1346: Fnd_Message.Set_Name('FUN','FUN_ADI_CCID_ERROR');
1347: Fnd_Message.Set_Token('CON_SEGS', p_rd_ccid_segments);
1342: Fnd_Message.Set_Name('FUN','FUN_ADI_CON_SEGS_REQ');
1343: Fnd_Message.Raise_Error;
1344: When Ccid_Gen_Excpt Then
1345: Rollback;
1346: Fnd_Message.Set_Name('FUN','FUN_ADI_CCID_ERROR');
1347: Fnd_Message.Set_Token('CON_SEGS', p_rd_ccid_segments);
1348: Fnd_Message.Raise_Error;
1349: When Reci_Dupl_Row_Excpt Then
1350: Rollback;
1343: Fnd_Message.Raise_Error;
1344: When Ccid_Gen_Excpt Then
1345: Rollback;
1346: Fnd_Message.Set_Name('FUN','FUN_ADI_CCID_ERROR');
1347: Fnd_Message.Set_Token('CON_SEGS', p_rd_ccid_segments);
1348: Fnd_Message.Raise_Error;
1349: When Reci_Dupl_Row_Excpt Then
1350: Rollback;
1351: Fnd_Message.Set_Name('FUN','FUN_ADI_RECI_DUP_ERROR');
1344: When Ccid_Gen_Excpt Then
1345: Rollback;
1346: Fnd_Message.Set_Name('FUN','FUN_ADI_CCID_ERROR');
1347: Fnd_Message.Set_Token('CON_SEGS', p_rd_ccid_segments);
1348: Fnd_Message.Raise_Error;
1349: When Reci_Dupl_Row_Excpt Then
1350: Rollback;
1351: Fnd_Message.Set_Name('FUN','FUN_ADI_RECI_DUP_ERROR');
1352: Fnd_Message.Set_Token('TRX_NUMBER', l_trx_number);
1347: Fnd_Message.Set_Token('CON_SEGS', p_rd_ccid_segments);
1348: Fnd_Message.Raise_Error;
1349: When Reci_Dupl_Row_Excpt Then
1350: Rollback;
1351: Fnd_Message.Set_Name('FUN','FUN_ADI_RECI_DUP_ERROR');
1352: Fnd_Message.Set_Token('TRX_NUMBER', l_trx_number);
1353: Fnd_Message.Set_Token('DEBIT', l_dist_lines_tbl(l_count + 1).amount_dr);
1354: Fnd_Message.Set_Token('CREDIT', l_dist_lines_tbl(l_count + 1 ).amount_cr);
1355: Fnd_Message.Set_Token('DESCRIPTION', l_dist_lines_tbl(l_count + 1 ).description);
1348: Fnd_Message.Raise_Error;
1349: When Reci_Dupl_Row_Excpt Then
1350: Rollback;
1351: Fnd_Message.Set_Name('FUN','FUN_ADI_RECI_DUP_ERROR');
1352: Fnd_Message.Set_Token('TRX_NUMBER', l_trx_number);
1353: Fnd_Message.Set_Token('DEBIT', l_dist_lines_tbl(l_count + 1).amount_dr);
1354: Fnd_Message.Set_Token('CREDIT', l_dist_lines_tbl(l_count + 1 ).amount_cr);
1355: Fnd_Message.Set_Token('DESCRIPTION', l_dist_lines_tbl(l_count + 1 ).description);
1356: Fnd_Message.Raise_Error;
1349: When Reci_Dupl_Row_Excpt Then
1350: Rollback;
1351: Fnd_Message.Set_Name('FUN','FUN_ADI_RECI_DUP_ERROR');
1352: Fnd_Message.Set_Token('TRX_NUMBER', l_trx_number);
1353: Fnd_Message.Set_Token('DEBIT', l_dist_lines_tbl(l_count + 1).amount_dr);
1354: Fnd_Message.Set_Token('CREDIT', l_dist_lines_tbl(l_count + 1 ).amount_cr);
1355: Fnd_Message.Set_Token('DESCRIPTION', l_dist_lines_tbl(l_count + 1 ).description);
1356: Fnd_Message.Raise_Error;
1357: When Reci_Dist_Sum_Excpt Then
1350: Rollback;
1351: Fnd_Message.Set_Name('FUN','FUN_ADI_RECI_DUP_ERROR');
1352: Fnd_Message.Set_Token('TRX_NUMBER', l_trx_number);
1353: Fnd_Message.Set_Token('DEBIT', l_dist_lines_tbl(l_count + 1).amount_dr);
1354: Fnd_Message.Set_Token('CREDIT', l_dist_lines_tbl(l_count + 1 ).amount_cr);
1355: Fnd_Message.Set_Token('DESCRIPTION', l_dist_lines_tbl(l_count + 1 ).description);
1356: Fnd_Message.Raise_Error;
1357: When Reci_Dist_Sum_Excpt Then
1358: Rollback;
1351: Fnd_Message.Set_Name('FUN','FUN_ADI_RECI_DUP_ERROR');
1352: Fnd_Message.Set_Token('TRX_NUMBER', l_trx_number);
1353: Fnd_Message.Set_Token('DEBIT', l_dist_lines_tbl(l_count + 1).amount_dr);
1354: Fnd_Message.Set_Token('CREDIT', l_dist_lines_tbl(l_count + 1 ).amount_cr);
1355: Fnd_Message.Set_Token('DESCRIPTION', l_dist_lines_tbl(l_count + 1 ).description);
1356: Fnd_Message.Raise_Error;
1357: When Reci_Dist_Sum_Excpt Then
1358: Rollback;
1359: Fnd_Message.Set_Name('FUN','FUN_ADI_RECI_SUM_ERROR');
1352: Fnd_Message.Set_Token('TRX_NUMBER', l_trx_number);
1353: Fnd_Message.Set_Token('DEBIT', l_dist_lines_tbl(l_count + 1).amount_dr);
1354: Fnd_Message.Set_Token('CREDIT', l_dist_lines_tbl(l_count + 1 ).amount_cr);
1355: Fnd_Message.Set_Token('DESCRIPTION', l_dist_lines_tbl(l_count + 1 ).description);
1356: Fnd_Message.Raise_Error;
1357: When Reci_Dist_Sum_Excpt Then
1358: Rollback;
1359: Fnd_Message.Set_Name('FUN','FUN_ADI_RECI_SUM_ERROR');
1360: Fnd_Message.Raise_Error;
1355: Fnd_Message.Set_Token('DESCRIPTION', l_dist_lines_tbl(l_count + 1 ).description);
1356: Fnd_Message.Raise_Error;
1357: When Reci_Dist_Sum_Excpt Then
1358: Rollback;
1359: Fnd_Message.Set_Name('FUN','FUN_ADI_RECI_SUM_ERROR');
1360: Fnd_Message.Raise_Error;
1361: When Reci_Amount_Excpt Then
1362: Rollback;
1363: Fnd_Message.Set_Name('FUN','FUN_ADI_INVALID_DRCR_DIST');
1356: Fnd_Message.Raise_Error;
1357: When Reci_Dist_Sum_Excpt Then
1358: Rollback;
1359: Fnd_Message.Set_Name('FUN','FUN_ADI_RECI_SUM_ERROR');
1360: Fnd_Message.Raise_Error;
1361: When Reci_Amount_Excpt Then
1362: Rollback;
1363: Fnd_Message.Set_Name('FUN','FUN_ADI_INVALID_DRCR_DIST');
1364: Fnd_Message.Set_Token('TRX_NUMBER', p_trx_number);
1359: Fnd_Message.Set_Name('FUN','FUN_ADI_RECI_SUM_ERROR');
1360: Fnd_Message.Raise_Error;
1361: When Reci_Amount_Excpt Then
1362: Rollback;
1363: Fnd_Message.Set_Name('FUN','FUN_ADI_INVALID_DRCR_DIST');
1364: Fnd_Message.Set_Token('TRX_NUMBER', p_trx_number);
1365: Fnd_Message.Raise_Error;
1366: When Fnd_Api.G_EXC_UNEXPECTED_ERROR Then
1367: Rollback;
1360: Fnd_Message.Raise_Error;
1361: When Reci_Amount_Excpt Then
1362: Rollback;
1363: Fnd_Message.Set_Name('FUN','FUN_ADI_INVALID_DRCR_DIST');
1364: Fnd_Message.Set_Token('TRX_NUMBER', p_trx_number);
1365: Fnd_Message.Raise_Error;
1366: When Fnd_Api.G_EXC_UNEXPECTED_ERROR Then
1367: Rollback;
1368: Get_Message_Text(l_data);
1361: When Reci_Amount_Excpt Then
1362: Rollback;
1363: Fnd_Message.Set_Name('FUN','FUN_ADI_INVALID_DRCR_DIST');
1364: Fnd_Message.Set_Token('TRX_NUMBER', p_trx_number);
1365: Fnd_Message.Raise_Error;
1366: When Fnd_Api.G_EXC_UNEXPECTED_ERROR Then
1367: Rollback;
1368: Get_Message_Text(l_data);
1369: Fnd_Message.Set_Name('FUN', 'FUN_ADI_ERROR');
1365: Fnd_Message.Raise_Error;
1366: When Fnd_Api.G_EXC_UNEXPECTED_ERROR Then
1367: Rollback;
1368: Get_Message_Text(l_data);
1369: Fnd_Message.Set_Name('FUN', 'FUN_ADI_ERROR');
1370: Fnd_Message.Set_Token('ERROR', l_data);
1371: Fnd_Message.Raise_Error;
1372: When Fnd_Api.G_EXC_ERROR Then
1373: Rollback;
1366: When Fnd_Api.G_EXC_UNEXPECTED_ERROR Then
1367: Rollback;
1368: Get_Message_Text(l_data);
1369: Fnd_Message.Set_Name('FUN', 'FUN_ADI_ERROR');
1370: Fnd_Message.Set_Token('ERROR', l_data);
1371: Fnd_Message.Raise_Error;
1372: When Fnd_Api.G_EXC_ERROR Then
1373: Rollback;
1374: Get_Message_Text(l_data);
1367: Rollback;
1368: Get_Message_Text(l_data);
1369: Fnd_Message.Set_Name('FUN', 'FUN_ADI_ERROR');
1370: Fnd_Message.Set_Token('ERROR', l_data);
1371: Fnd_Message.Raise_Error;
1372: When Fnd_Api.G_EXC_ERROR Then
1373: Rollback;
1374: Get_Message_Text(l_data);
1375: Fnd_Message.Set_Name('FUN', 'FUN_ADI_ERROR');
1371: Fnd_Message.Raise_Error;
1372: When Fnd_Api.G_EXC_ERROR Then
1373: Rollback;
1374: Get_Message_Text(l_data);
1375: Fnd_Message.Set_Name('FUN', 'FUN_ADI_ERROR');
1376: Fnd_Message.Set_Token('ERROR', l_data);
1377: When Others Then
1378: Rollback;
1379: Fnd_Message.Set_Name('FUN', 'FUN_ADI_ERROR');
1372: When Fnd_Api.G_EXC_ERROR Then
1373: Rollback;
1374: Get_Message_Text(l_data);
1375: Fnd_Message.Set_Name('FUN', 'FUN_ADI_ERROR');
1376: Fnd_Message.Set_Token('ERROR', l_data);
1377: When Others Then
1378: Rollback;
1379: Fnd_Message.Set_Name('FUN', 'FUN_ADI_ERROR');
1380: Fnd_Message.Set_Token('ERROR', sqlerrm);
1375: Fnd_Message.Set_Name('FUN', 'FUN_ADI_ERROR');
1376: Fnd_Message.Set_Token('ERROR', l_data);
1377: When Others Then
1378: Rollback;
1379: Fnd_Message.Set_Name('FUN', 'FUN_ADI_ERROR');
1380: Fnd_Message.Set_Token('ERROR', sqlerrm);
1381: Fnd_Message.Raise_Error;
1382: End Upload_Batch;
1383: End FUN_WEBADI_PKG;
1376: Fnd_Message.Set_Token('ERROR', l_data);
1377: When Others Then
1378: Rollback;
1379: Fnd_Message.Set_Name('FUN', 'FUN_ADI_ERROR');
1380: Fnd_Message.Set_Token('ERROR', sqlerrm);
1381: Fnd_Message.Raise_Error;
1382: End Upload_Batch;
1383: End FUN_WEBADI_PKG;
1384:
1377: When Others Then
1378: Rollback;
1379: Fnd_Message.Set_Name('FUN', 'FUN_ADI_ERROR');
1380: Fnd_Message.Set_Token('ERROR', sqlerrm);
1381: Fnd_Message.Raise_Error;
1382: End Upload_Batch;
1383: End FUN_WEBADI_PKG;
1384: