[Home] [Help]
1224: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name, SQLCODE||' ; '||SQLERRM);
1225: END IF;
1226:
1227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1228: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
1229: FND_MSG_PUB.Add;
1230:
1231: IF c_HEADERS%ISOPEN THEN
1232: close c_HEADERS;
1285: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name, SQLCODE||' ; '||SQLERRM);
1286: END IF;
1287:
1288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1289: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
1290: FND_MSG_PUB.Add;
1291:
1292: IF c_HEADERS%ISOPEN THEN
1293: close c_HEADERS;
1446: --Close all open cursors
1447: IF common_header_info%ISOPEN THEN CLOSE common_header_info; END IF;
1448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1449: DUMP_MSG;
1450: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
1451: FND_MSG_PUB.add;
1452: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1453: p_count => x_msg_count,
1454: p_data => x_msg_data
1493: --Close all open cursors
1494: IF common_header_info%ISOPEN THEN CLOSE common_header_info; END IF;
1495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1496: DUMP_MSG;
1497: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
1498: FND_MSG_PUB.add;
1499: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1500: p_count => x_msg_count,
1501: p_data => x_msg_data
2292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2293: ROLLBACK TO Calculate_tax_PVT;
2294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2295: DUMP_MSG;
2296: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
2297: FND_MSG_PUB.Add;
2298: /*---------------------------------------------------------+
2299: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
2300: | in the message stack. If there is only one message in |
2334:
2335: WHEN OTHERS THEN
2336: ROLLBACK TO Calculate_tax_PVT;
2337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2338: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
2339: FND_MSG_PUB.Add;
2340: /*---------------------------------------------------------+
2341: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
2342: | in the message stack. If there is only one message in |
2854: ROLLBACK TO Import_Document_PVT;
2855: --Close all open cursors
2856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2857: DUMP_MSG;
2858: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
2859: FND_MSG_PUB.Add;
2860: /*---------------------------------------------------------+
2861: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
2862: | in the message stack. If there is only one message in |
2916: WHEN OTHERS THEN
2917: ROLLBACK TO Import_Document_PVT;
2918: --Close all open cursors
2919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2920: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
2921: FND_MSG_PUB.Add;
2922: /*---------------------------------------------------------+
2923: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
2924: | in the message stack. If there is only one message in |
3379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3380: ROLLBACK TO Synchronize_tax_PVT;
3381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3382: DUMP_MSG;
3383: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
3384: FND_MSG_PUB.Add;
3385: /*---------------------------------------------------------+
3386: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3387: | in the message stack. If there is only one message in |
3406:
3407: WHEN OTHERS THEN
3408: ROLLBACK TO Synchronize_tax_PVT;
3409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3410: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
3411: FND_MSG_PUB.Add;
3412: /*---------------------------------------------------------+
3413: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3414: | in the message stack. If there is only one message in |
3757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3758: ROLLBACK TO Override_Tax_PVT;
3759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3760: DUMP_MSG;
3761: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
3762: FND_MSG_PUB.Add;
3763: /*---------------------------------------------------------+
3764: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3765: | in the message stack. If there is only one message in |
3785:
3786: WHEN OTHERS THEN
3787: ROLLBACK TO Override_Tax_PVT;
3788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3789: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
3790: FND_MSG_PUB.Add;
3791: /*---------------------------------------------------------+
3792: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3793: | in the message stack. If there is only one message in |
3932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3933: ROLLBACK TO global_document_update_PVT;
3934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3935: DUMP_MSG;
3936: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
3937: FND_MSG_PUB.Add;
3938: /*---------------------------------------------------------+
3939: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3940: | in the message stack. If there is only one message in |
3950:
3951: WHEN OTHERS THEN
3952: ROLLBACK TO global_document_update_PVT;
3953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3954: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
3955: FND_MSG_PUB.Add;
3956: /*---------------------------------------------------------+
3957: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3958: | in the message stack. If there is only one message in |
4152: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
4153: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4154: END IF;
4155: IF (SQLCODE = 54) THEN
4156: FND_MESSAGE.SET_NAME('ZX','ZX_RESOURCE_BUSY');
4157: l_context_info_rec.APPLICATION_ID := p_transaction_rec.APPLICATION_ID;
4158: l_context_info_rec.ENTITY_CODE := p_transaction_rec.ENTITY_CODE;
4159: l_context_info_rec.EVENT_CLASS_CODE := p_transaction_rec.EVENT_CLASS_CODE;
4160: l_context_info_rec.TRX_ID := p_transaction_rec.TRX_ID;
4265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4266: ROLLBACK TO global_document_update_PVT;
4267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4268: DUMP_MSG;
4269: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
4270: FND_MSG_PUB.Add;
4271: /*---------------------------------------------------------+
4272: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
4273: | in the message stack. If there is only one message in |
4284:
4285: WHEN OTHERS THEN
4286: ROLLBACK TO global_document_update_PVT;
4287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4288: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
4289: FND_MSG_PUB.Add;
4290: /*---------------------------------------------------------+
4291: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
4292: | in the message stack. If there is only one message in |
4469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4470: ROLLBACK TO mark_tax_lines_del_PVT;
4471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4472: DUMP_MSG;
4473: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
4474: FND_MSG_PUB.Add;
4475: /*---------------------------------------------------------+
4476: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
4477: | in the message stack. If there is only one message in |
4488:
4489: WHEN OTHERS THEN
4490: ROLLBACK TO mark_tax_lines_del_PVT;
4491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4492: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
4493: FND_MSG_PUB.Add;
4494: /*---------------------------------------------------------+
4495: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
4496: | in the message stack. If there is only one message in |
4647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4648: ROLLBACK TO reverse_document_PVT;
4649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4650: DUMP_MSG;
4651: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
4652: FND_MSG_PUB.Add;
4653: /*---------------------------------------------------------+
4654: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
4655: | in the message stack. If there is only one message in |
4666:
4667: WHEN OTHERS THEN
4668: ROLLBACK TO reverse_document_PVT;
4669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4670: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
4671: FND_MSG_PUB.Add;
4672: /*---------------------------------------------------------+
4673: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
4674: | in the message stack. If there is only one message in |
4806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4807: ROLLBACK TO reverse_distributions_PVT;
4808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4809: DUMP_MSG;
4810: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
4811: FND_MSG_PUB.ADD;
4812: /*---------------------------------------------------------+
4813: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
4814: | in the message stack. If there is only one message in |
4824:
4825: WHEN OTHERS THEN
4826: ROLLBACK TO reverse_distributions_PVT;
4827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4828: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
4829: FND_MSG_PUB.ADD;
4830: /*---------------------------------------------------------+
4831: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
4832: | in the message stack. If there is only one message in |
5005: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5006: ROLLBACK TO reverse_doc_distribution_PVT;
5007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5008: DUMP_MSG;
5009: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
5010: FND_MSG_PUB.ADD;
5011: /*---------------------------------------------------------+
5012: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
5013: | in the message stack. If there is only one message in |
5023:
5024: WHEN OTHERS THEN
5025: ROLLBACK TO reverse_doc_distribution_PVT;
5026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5027: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
5028: FND_MSG_PUB.ADD;
5029: /*---------------------------------------------------------+
5030: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
5031: | in the message stack. If there is only one message in |
5436: FOR invalid_rec IN check_trx_line_dist_qty
5437: LOOP
5438:
5439: -- x_return_status := FND_API.G_RET_STS_ERROR;
5440: FND_MESSAGE.SET_NAME('ZX','ZX_TRX_LINE_DIST_QTY_REQD');
5441: l_context_info_rec.APPLICATION_ID := invalid_rec.APPLICATION_ID;
5442: l_context_info_rec.ENTITY_CODE := invalid_rec.ENTITY_CODE;
5443: l_context_info_rec.EVENT_CLASS_CODE := invalid_rec.EVENT_CLASS_CODE;
5444: l_context_info_rec.TRX_ID := invalid_rec.TRX_ID;
5453: FOR invalid_rec IN check_trx_line_dist_unit_price
5454: LOOP
5455:
5456: -- x_return_status := FND_API.G_RET_STS_ERROR;
5457: FND_MESSAGE.SET_NAME('ZX','ZX_UNIT_PRICE_REQD');
5458: l_context_info_rec.APPLICATION_ID := invalid_rec.APPLICATION_ID;
5459: l_context_info_rec.ENTITY_CODE := invalid_rec.ENTITY_CODE;
5460: l_context_info_rec.EVENT_CLASS_CODE := invalid_rec.EVENT_CLASS_CODE;
5461: l_context_info_rec.TRX_ID := invalid_rec.TRX_ID;
5844: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name, SQLCODE||' ; '||SQLERRM);
5845: END IF;
5846:
5847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5848: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
5849: FND_MSG_PUB.Add;
5850:
5851: IF c_HEADERS%ISOPEN THEN
5852: close c_HEADERS;
5957: --Close all open cursors
5958: IF headers%ISOPEN THEN CLOSE headers; END IF;
5959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5960: DUMP_MSG;
5961: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
5962: FND_MSG_PUB.Add;
5963: /*---------------------------------------------------------+
5964: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
5965: | in the message stack. If there is only one message in |
6014: ROLLBACK TO Determine_Recovery_PVT;
6015: --Close all open cursors
6016: IF headers%ISOPEN THEN CLOSE headers; END IF;
6017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6018: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
6019: FND_MSG_PUB.Add;
6020: /*---------------------------------------------------------+
6021: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
6022: | in the message stack. If there is only one message in |
6229: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6230: ROLLBACK TO override_recovery_PVT;
6231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6232: DUMP_MSG;
6233: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
6234: FND_MSG_PUB.Add;
6235: /*---------------------------------------------------------+
6236: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
6237: | in the message stack. If there is only one message in |
6252: | been put on the error stack. |
6253: +-------------------------------------------------------*/
6254: ROLLBACK TO override_recovery_PVT;
6255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6256: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
6257: FND_MSG_PUB.Add;
6258: /*---------------------------------------------------------+
6259: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
6260: | in the message stack. If there is only one message in |
6487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6488: ROLLBACK TO FREEZE_TAX_DISTRIBUTIONS_PVT;
6489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6490: DUMP_MSG;
6491: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
6492: FND_MSG_PUB.Add;
6493: /*---------------------------------------------------------+
6494: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
6495: | in the message stack. If there is only one message in |
6505:
6506: WHEN OTHERS THEN
6507: ROLLBACK TO FREEZE_TAX_DISTRIBUTIONS_PVT;
6508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6509: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
6510: FND_MSG_PUB.Add;
6511: /*---------------------------------------------------------+
6512: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
6513: | in the message stack. If there is only one message in |
6797: --Bug 8410923
6798: --Assigning the return status properly
6799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6800: DUMP_MSG;
6801: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
6802: FND_MSG_PUB.Add;
6803: /*---------------------------------------------------------+
6804: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
6805: | in the message stack. If there is only one message in |
6815:
6816: WHEN OTHERS THEN
6817: ROLLBACK TO Get_Tax_Distribution_Ccids_PVT;
6818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6819: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
6820: FND_MSG_PUB.Add;
6821: /*---------------------------------------------------------+
6822: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
6823: | in the message stack. If there is only one message in |
6947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6948: ROLLBACK TO Update_Tax_Dist_GL_Date_PVT;
6949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6950: DUMP_MSG;
6951: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
6952: FND_MSG_PUB.Add;
6953: /*---------------------------------------------------------+
6954: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
6955: | in the message stack. If there is only one message in |
6965:
6966: WHEN OTHERS THEN
6967: ROLLBACK TO Update_tax_dist_gl_date_PVT;
6968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6969: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
6970: FND_MSG_PUB.Add;
6971: /*---------------------------------------------------------+
6972: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
6973: | in the message stack. If there is only one message in |
7059: /*---------------------------------------------+
7060: | Missing Currency Conversion Rate |
7061: +---------------------------------------------*/
7062: IF p_curr_conv_rate is NULL THEN
7063: FND_MESSAGE.SET_NAME('ZX','ZX_CURRENCY_CONVERSION_RATE_REQD');
7064: FND_MSG_PUB.Add;
7065: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7066: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||
7067: 'Currency conversion rate is passed as null');
7072: /*---------------------------------------------+
7073: | Missing Currency Conversion Date |
7074: +---------------------------------------------*/
7075: IF p_curr_conv_date is NULL THEN
7076: FND_MESSAGE.SET_NAME('ZX','ZX_CURRENCY_CONVERSION_DATE_REQD');
7077: FND_MSG_PUB.Add;
7078: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7079: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||
7080: 'Currency conversion date is passed as null');
7085: /*---------------------------------------------+
7086: | Missing Currency Conversion Type |
7087: +---------------------------------------------*/
7088: IF p_curr_conv_type is NULL THEN
7089: FND_MESSAGE.SET_NAME('ZX','ZX_CURRENCY_CONVERSION_TYPE_REQD');
7090: FND_MSG_PUB.Add;
7091: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7092: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||
7093: 'Currency conversion type is passed as null');
7222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7223: ROLLBACK TO Update_Exchange_Rate_PVT;
7224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7225: DUMP_MSG;
7226: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
7227: FND_MSG_PUB.Add;
7228: /*---------------------------------------------------------+
7229: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
7230: | in the message stack. If there is only one message in |
7240:
7241: WHEN OTHERS THEN
7242: ROLLBACK TO Update_Exchange_Rate_PVT;
7243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7244: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
7245: FND_MSG_PUB.Add;
7246: /*---------------------------------------------------------+
7247: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
7248: | in the message stack. If there is only one message in |
7435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7436: ROLLBACK TO discard_tax_only_lines_PVT;
7437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7438: DUMP_MSG;
7439: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
7440: FND_MSG_PUB.Add;
7441: /*---------------------------------------------------------+
7442: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
7443: | in the message stack. If there is only one message in |
7453:
7454: WHEN OTHERS THEN
7455: ROLLBACK TO discard_tax_only_lines_PVT;
7456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7457: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
7458: FND_MSG_PUB.Add;
7459: /*---------------------------------------------------------+
7460: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
7461: | in the message stack. If there is only one message in |
7665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7666: ROLLBACK TO Validate_Document_PVT;
7667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7668: DUMP_MSG;
7669: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
7670: FND_MSG_PUB.Add;
7671: /*---------------------------------------------------------+
7672: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
7673: | in the message stack. If there is only one message in |
7684:
7685: WHEN OTHERS THEN
7686: ROLLBACK TO Validate_Document_PVT;
7687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7688: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
7689: FND_MSG_PUB.Add;
7690: /*---------------------------------------------------------+
7691: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
7692: | in the message stack. If there is only one message in |
7857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7858: ROLLBACK TO Validate_Document_PVT;
7859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7860: DUMP_MSG;
7861: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
7862: FND_MSG_PUB.Add;
7863: /*---------------------------------------------------------+
7864: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
7865: | in the message stack. If there is only one message in |
7876:
7877: WHEN OTHERS THEN
7878: ROLLBACK TO Validate_Document_PVT;
7879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7880: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
7881: FND_MSG_PUB.Add;
7882: /*---------------------------------------------------------+
7883: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
7884: | in the message stack. If there is only one message in |
8017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8018: ROLLBACK TO Get_Default_Tax_Line_Attrs_PVT;
8019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8020: DUMP_MSG;
8021: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
8022: FND_MSG_PUB.Add;
8023: /*---------------------------------------------------------+
8024: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
8025: | in the message stack. If there is only one message in |
8035:
8036: WHEN OTHERS THEN
8037: ROLLBACK TO Get_Default_Tax_Line_Attrs_PVT;
8038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8039: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
8040: FND_MSG_PUB.Add;
8041: /*---------------------------------------------------------+
8042: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
8043: | in the message stack. If there is only one message in |
8481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8482: ROLLBACK TO Get_Default_Tax_Det_Attrs_PVT;
8483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8484: DUMP_MSG;
8485: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
8486: FND_MSG_PUB.Add;
8487: /*---------------------------------------------------------+
8488: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
8489: | in the message stack. If there is only one message in |
8500:
8501: WHEN OTHERS THEN
8502: ROLLBACK TO Get_Default_Tax_Det_Attrs_PVT;
8503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8504: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
8505: FND_MSG_PUB.Add;
8506: /*---------------------------------------------------------+
8507: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
8508: | in the message stack. If there is only one message in |
8780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8781: ROLLBACK TO Get_Default_Tax_Det_Attrs_PVT;
8782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8783: DUMP_MSG;
8784: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
8785: FND_MSG_PUB.Add;
8786: /*---------------------------------------------------------+
8787: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
8788: | in the message stack. If there is only one message in |
8799:
8800: WHEN OTHERS THEN
8801: ROLLBACK TO Get_Default_Tax_Det_Attrs_PVT;
8802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8803: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
8804: FND_MSG_PUB.Add;
8805: /*---------------------------------------------------------+
8806: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
8807: | in the message stack. If there is only one message in |
8945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8946: ROLLBACK TO Set_Tax_Security_Context_PVT;
8947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8948: DUMP_MSG;
8949: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
8950: FND_MSG_PUB.Add;
8951: /*---------------------------------------------------------+
8952: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
8953: | in the message stack. If there is only one message in |
8964:
8965: WHEN OTHERS THEN
8966: ROLLBACK TO set_tax_security_context_PVT;
8967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8968: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
8969: FND_MSG_PUB.Add;
8970: /*---------------------------------------------------------+
8971: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
8972: | in the message stack. If there is only one message in |
9109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9110: ROLLBACK TO Set_Tax_Security_Context_PVT;
9111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9112: DUMP_MSG;
9113: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
9114: FND_MSG_PUB.Add;
9115: /*---------------------------------------------------------+
9116: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
9117: | in the message stack. If there is only one message in |
9128:
9129: WHEN OTHERS THEN
9130: ROLLBACK TO set_tax_security_context_PVT;
9131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9132: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
9133: FND_MSG_PUB.Add;
9134: /*---------------------------------------------------------+
9135: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
9136: | in the message stack. If there is only one message in |
9308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9309: ROLLBACK TO Validate_And_Default_Tax_Attr;
9310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9311: DUMP_MSG;
9312: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
9313: FND_MSG_PUB.Add;
9314: /*---------------------------------------------------------+
9315: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
9316: | in the message stack. If there is only one message in |
9327:
9328: WHEN OTHERS THEN
9329: ROLLBACK TO Validate_And_Default_Tax_Attr;
9330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9331: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
9332: FND_MSG_PUB.Add;
9333: /*---------------------------------------------------------+
9334: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
9335: | in the message stack. If there is only one message in |
9389:
9390: END commit_for_tax;
9391:
9392: /* =======================================================================*
9393: | PROCEDURE add_msg : Adds the message to the fnd message stack or |
9394: | local plsql table to be dumped later into the |
9395: | errors GT. |
9396: * =======================================================================*/
9397:
9448: errors_tbl.trx_line_id(l_count+1) := p_context_info_rec.trx_line_id;
9449: errors_tbl.summary_tax_line_number(l_count+1) := p_context_info_rec.summary_tax_line_number;
9450: errors_tbl.tax_line_id(l_count+1) := p_context_info_rec.tax_line_id;
9451: errors_tbl.trx_line_dist_id(l_count+1) := p_context_info_rec.trx_line_dist_id;
9452: errors_tbl.message_text(l_count+1) := fnd_message.get();
9453: END IF; --G_EXTERNAL_API_CALL
9454: l_count:=errors_tbl.application_id.COUNT;
9455: END IF; --G_DATA_TRANSFER_MODE
9456:
9669: -- Commented rollback as per bug 5395191
9670: -- ROLLBACK TO Get_Default_Tax_Reg_PVT;
9671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9672: DUMP_MSG;
9673: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
9674: FND_MSG_PUB.Add;
9675: /*---------------------------------------------------------+
9676: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
9677: | in the message stack. If there is only one message in |
9688: WHEN OTHERS THEN
9689: -- Commented rollback as per bug 5395191
9690: -- ROLLBACK TO Get_Default_Tax_Reg_PVT;
9691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9692: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
9693: FND_MSG_PUB.Add;
9694: /*---------------------------------------------------------+
9695: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
9696: | in the message stack. If there is only one message in |
10039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10040: ROLLBACK TO Insert_Line_Det_Factors_PVT;
10041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10042: DUMP_MSG;
10043: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
10044: FND_MSG_PUB.Add;
10045: /*---------------------------------------------------------+
10046: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
10047: | in the message stack. If there is only one message in |
10058: WHEN OTHERS THEN
10059: ROLLBACK TO Insert_Line_Det_Factors_PVT;
10060: IF (SQLCODE = 54) THEN
10061: x_return_status := FND_API.G_RET_STS_ERROR ;
10062: FND_MESSAGE.SET_NAME('ZX','ZX_RESOURCE_BUSY');
10063: ELSE
10064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10065: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
10066: END IF;
10061: x_return_status := FND_API.G_RET_STS_ERROR ;
10062: FND_MESSAGE.SET_NAME('ZX','ZX_RESOURCE_BUSY');
10063: ELSE
10064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10065: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
10066: END IF;
10067: FND_MSG_PUB.Add;
10068: /*---------------------------------------------------------+
10069: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
10330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10331: ROLLBACK TO Insert_Line_Det_Factors_PVT;
10332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10333: DUMP_MSG;
10334: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
10335: FND_MSG_PUB.Add;
10336: /*---------------------------------------------------------+
10337: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
10338: | in the message stack. If there is only one message in |
10354: +-------------------------------------------------------*/
10355: ROLLBACK TO Insert_Line_Det_Factors_PVT;
10356: IF (SQLCODE = 54) THEN
10357: x_return_status := FND_API.G_RET_STS_ERROR ;
10358: FND_MESSAGE.SET_NAME('ZX','ZX_RESOURCE_BUSY');
10359: ELSE
10360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10361: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
10362: END IF;
10357: x_return_status := FND_API.G_RET_STS_ERROR ;
10358: FND_MESSAGE.SET_NAME('ZX','ZX_RESOURCE_BUSY');
10359: ELSE
10360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10361: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
10362: END IF;
10363: FND_MSG_PUB.Add;
10364: /*---------------------------------------------------------+
10365: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
12081: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12082: ROLLBACK TO Update_Det_Factors_Hdr_PVT;
12083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12084: DUMP_MSG;
12085: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
12086: FND_MSG_PUB.Add;
12087: /*---------------------------------------------------------+
12088: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
12089: | in the message stack. If there is only one message in |
12098: END IF;
12099: WHEN OTHERS THEN
12100: ROLLBACK TO Update_Det_Factors_Hdr_PVT;
12101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12102: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
12103: FND_MSG_PUB.Add;
12104: /*---------------------------------------------------------+
12105: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
12106: | in the message stack. If there is only one message in |
12410: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12411: ROLLBACK TO Update_Line_Det_Factors_PVT;
12412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12413: DUMP_MSG;
12414: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
12415: FND_MSG_PUB.Add;
12416: /*---------------------------------------------------------+
12417: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
12418: | in the message stack. If there is only one message in |
12434: +-------------------------------------------------------*/
12435: ROLLBACK TO Update_Line_Det_Factors_PVT;
12436: IF (SQLCODE = 54) THEN
12437: x_return_status := FND_API.G_RET_STS_ERROR ;
12438: FND_MESSAGE.SET_NAME('ZX','ZX_RESOURCE_BUSY');
12439: ELSE
12440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12441: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
12442: END IF;
12437: x_return_status := FND_API.G_RET_STS_ERROR ;
12438: FND_MESSAGE.SET_NAME('ZX','ZX_RESOURCE_BUSY');
12439: ELSE
12440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12441: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
12442: END IF;
12443: FND_MSG_PUB.Add;
12444: /*---------------------------------------------------------+
12445: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
12726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12727: ROLLBACK TO Copy_Ins_Line_Det_Factors_PVT;
12728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12729: DUMP_MSG;
12730: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
12731: FND_MSG_PUB.Add;
12732: /*---------------------------------------------------------+
12733: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
12734: | in the message stack. If there is only one message in |
12750: +-------------------------------------------------------*/
12751: ROLLBACK TO Copy_Ins_Line_Det_Factors_PVT;
12752: IF (SQLCODE = 54) THEN
12753: x_return_status := FND_API.G_RET_STS_ERROR ;
12754: FND_MESSAGE.SET_NAME('ZX','ZX_RESOURCE_BUSY');
12755: ELSE
12756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12757: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
12758: END IF;
12753: x_return_status := FND_API.G_RET_STS_ERROR ;
12754: FND_MESSAGE.SET_NAME('ZX','ZX_RESOURCE_BUSY');
12755: ELSE
12756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12757: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
12758: END IF;
12759: FND_MSG_PUB.Add;
12760: /*---------------------------------------------------------+
12761: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
12887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12888: ROLLBACK TO Is_Recoverability_Affected_PVT;
12889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12890: DUMP_MSG;
12891: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
12892: FND_MSG_PUB.Add;
12893: /*---------------------------------------------------------+
12894: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
12895: | in the message stack. If there is only one message in |
12906:
12907: WHEN OTHERS THEN
12908: ROLLBACK TO Is_Recoverability_Affected_PVT;
12909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12910: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
12911: FND_MSG_PUB.Add;
12912: /*---------------------------------------------------------+
12913: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
12914: | in the message stack. If there is only one message in |
13103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13104: ROLLBACK TO Del_Tax_Line_And_Dists_PVT;
13105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13106: DUMP_MSG;
13107: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
13108: FND_MSG_PUB.Add;
13109: /*---------------------------------------------------------+
13110: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
13111: | in the message stack. If there is only one message in |
13122:
13123: WHEN OTHERS THEN
13124: ROLLBACK TO Del_Tax_Line_And_Dists_PVT;
13125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13126: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
13127: FND_MSG_PUB.Add;
13128: /*---------------------------------------------------------+
13129: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
13130: | in the message stack. If there is only one message in |
13260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13261: ROLLBACK TO Del_Tax_Distributions_PVT;
13262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13263: DUMP_MSG;
13264: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
13265: FND_MSG_PUB.Add;
13266: /*---------------------------------------------------------+
13267: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
13268: | in the message stack. If there is only one message in |
13279:
13280: WHEN OTHERS THEN
13281: ROLLBACK TO Del_Tax_Distributions_PVT;
13282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13283: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
13284: FND_MSG_PUB.Add;
13285: /*---------------------------------------------------------+
13286: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
13287: | in the message stack. If there is only one message in |
13592: --Close all open cursors
13593: IF headers_doc%ISOPEN THEN CLOSE headers_doc; END IF;
13594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13595: DUMP_MSG;
13596: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
13597: FND_MSG_PUB.Add;
13598: /*---------------------------------------------------------+
13599: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
13600: | in the message stack. If there is only one message in |
13612: ROLLBACK TO Get_Default_Tax_Det_Attrs_PVT;
13613: --Close all open cursors
13614: IF headers_doc%ISOPEN THEN CLOSE headers_doc; END IF;
13615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13616: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
13617: FND_MSG_PUB.Add;
13618: /*---------------------------------------------------------+
13619: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
13620: | in the message stack. If there is only one message in |
13761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13762: ROLLBACK TO Redefault_Intended_Use_PVT;
13763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13764: DUMP_MSG;
13765: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
13766: FND_MSG_PUB.Add;
13767: /*---------------------------------------------------------+
13768: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
13769: | in the message stack. If there is only one message in |
13779:
13780: WHEN OTHERS THEN
13781: ROLLBACK TO Redefault_Intended_Use_PVT;
13782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13783: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
13784: FND_MSG_PUB.Add;
13785: /*---------------------------------------------------------+
13786: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
13787: | in the message stack. If there is only one message in |
13932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13933: ROLLBACK TO Redef_Prod_Fisc_Class_Code_PVT;
13934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13935: DUMP_MSG;
13936: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
13937: FND_MSG_PUB.Add;
13938: /*---------------------------------------------------------+
13939: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
13940: | in the message stack. If there is only one message in |
13950:
13951: WHEN OTHERS THEN
13952: ROLLBACK TO Redef_Prod_Fisc_Class_Code_PVT;
13953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13954: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
13955: FND_MSG_PUB.Add;
13956: /*---------------------------------------------------------+
13957: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
13958: | in the message stack. If there is only one message in |
14113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
14114: ROLLBACK TO Redefault_Assessable_Value_PVT;
14115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
14116: DUMP_MSG;
14117: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
14118: FND_MSG_PUB.Add;
14119: /*---------------------------------------------------------+
14120: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
14121: | in the message stack. If there is only one message in |
14131:
14132: WHEN OTHERS THEN
14133: ROLLBACK TO Redefault_Assessable_Value_PVT;
14134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
14135: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
14136: FND_MSG_PUB.Add;
14137: /*---------------------------------------------------------+
14138: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
14139: | in the message stack. If there is only one message in |
14284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
14285: ROLLBACK TO Redefault_Assessable_Value_PVT;
14286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
14287: DUMP_MSG;
14288: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
14289: FND_MSG_PUB.Add;
14290: /*---------------------------------------------------------+
14291: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
14292: | in the message stack. If there is only one message in |
14302:
14303: WHEN OTHERS THEN
14304: ROLLBACK TO Redefault_Assessable_Value_PVT;
14305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
14306: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
14307: FND_MSG_PUB.Add;
14308: /*---------------------------------------------------------+
14309: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
14310: | in the message stack. If there is only one message in |
14479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
14480: ROLLBACK TO Redef_Tax_Class_Code_PVT;
14481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
14482: DUMP_MSG;
14483: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
14484: FND_MSG_PUB.Add;
14485: /*---------------------------------------------------------+
14486: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
14487: | in the message stack. If there is only one message in |
14497:
14498: WHEN OTHERS THEN
14499: ROLLBACK TO Redef_Tax_Class_Code_PVT;
14500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
14501: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
14502: FND_MSG_PUB.Add;
14503: /*---------------------------------------------------------+
14504: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
14505: | in the message stack. If there is only one message in |
14728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
14729: ROLLBACK TO Purge_Tax_Repository_PVT;
14730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
14731: DUMP_MSG;
14732: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
14733: FND_MSG_PUB.Add;
14734: /*---------------------------------------------------------+
14735: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
14736: | in the message stack. If there is only one message in |
14746:
14747: WHEN OTHERS THEN
14748: ROLLBACK TO Purge_Tax_Repository_PVT;
14749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
14750: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
14751: FND_MSG_PUB.Add;
14752: /*---------------------------------------------------------+
14753: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
14754: | in the message stack. If there is only one message in |
14892: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
14893: ROLLBACK TO GET_LE_FROM_TAX_REGISTRATN_PVT;
14894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
14895: DUMP_MSG;
14896: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
14897: FND_MSG_PUB.Add;
14898: /*---------------------------------------------------------+
14899: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
14900: | in the message stack. If there is only one message in |
14910:
14911: WHEN OTHERS THEN
14912: ROLLBACK TO GET_LE_FROM_TAX_REGISTRATN_PVT;
14913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
14914: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
14915: FND_MSG_PUB.Add;
14916: /*---------------------------------------------------------+
14917: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
14918: | in the message stack. If there is only one message in |
15040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
15041: ROLLBACK TO update_posting_flag_PVT;
15042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
15043: DUMP_MSG;
15044: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
15045: FND_MSG_PUB.Add;
15046: /*---------------------------------------------------------+
15047: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
15048: | in the message stack. If there is only one message in |
15059:
15060: WHEN OTHERS THEN
15061: ROLLBACK TO update_posting_flag_PVT;
15062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
15063: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
15064: FND_MSG_PUB.Add;
15065: /*---------------------------------------------------------+
15066: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
15067: | in the message stack. If there is only one message in |