[Home] [Help]
1205: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name, SQLCODE||' ; '||SQLERRM);
1206: END IF;
1207:
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1209: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
1210: FND_MSG_PUB.Add;
1211:
1212: IF c_HEADERS%ISOPEN THEN
1213: close c_HEADERS;
1266: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name, SQLCODE||' ; '||SQLERRM);
1267: END IF;
1268:
1269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1270: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
1271: FND_MSG_PUB.Add;
1272:
1273: IF c_HEADERS%ISOPEN THEN
1274: close c_HEADERS;
1354: --Close all open cursors
1355: IF common_header_info%ISOPEN THEN CLOSE common_header_info; END IF;
1356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1357: DUMP_MSG;
1358: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
1359: FND_MSG_PUB.add;
1360: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1361: p_count => x_msg_count,
1362: p_data => x_msg_data
1370: --Close all open cursors
1371: IF common_header_info%ISOPEN THEN CLOSE common_header_info; END IF;
1372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1373: DUMP_MSG;
1374: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
1375: FND_MSG_PUB.add;
1376: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1377: p_count => x_msg_count,
1378: p_data => x_msg_data
2080:
2081: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2082: ROLLBACK TO Calculate_tax_PVT;
2083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2084: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
2085: FND_MSG_PUB.Add;
2086: /*---------------------------------------------------------+
2087: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
2088: | in the message stack. If there is only one message in |
2098:
2099: WHEN OTHERS THEN
2100: ROLLBACK TO Calculate_tax_PVT;
2101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2102: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
2103: FND_MSG_PUB.Add;
2104: /*---------------------------------------------------------+
2105: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
2106: | in the message stack. If there is only one message in |
2464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2465: ROLLBACK TO Import_Document_PVT;
2466: --Close all open cursors
2467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2468: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
2469: FND_MSG_PUB.Add;
2470: /*---------------------------------------------------------+
2471: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
2472: | in the message stack. If there is only one message in |
2483: WHEN OTHERS THEN
2484: ROLLBACK TO Import_Document_PVT;
2485: --Close all open cursors
2486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2487: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
2488: FND_MSG_PUB.Add;
2489: /*---------------------------------------------------------+
2490: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
2491: | in the message stack. If there is only one message in |
2848:
2849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2850: ROLLBACK TO Synchronize_tax_PVT;
2851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2852: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
2853: FND_MSG_PUB.Add;
2854: /*---------------------------------------------------------+
2855: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
2856: | in the message stack. If there is only one message in |
2866:
2867: WHEN OTHERS THEN
2868: ROLLBACK TO Synchronize_tax_PVT;
2869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2870: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
2871: FND_MSG_PUB.Add;
2872: /*---------------------------------------------------------+
2873: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
2874: | in the message stack. If there is only one message in |
3180:
3181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3182: ROLLBACK TO Override_Tax_PVT;
3183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3184: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
3185: FND_MSG_PUB.Add;
3186: /*---------------------------------------------------------+
3187: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3188: | in the message stack. If there is only one message in |
3198:
3199: WHEN OTHERS THEN
3200: ROLLBACK TO Override_Tax_PVT;
3201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3202: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
3203: FND_MSG_PUB.Add;
3204: /*---------------------------------------------------------+
3205: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3206: | in the message stack. If there is only one message in |
3334:
3335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3336: ROLLBACK TO global_document_update_PVT;
3337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3338: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
3339: FND_MSG_PUB.Add;
3340: /*---------------------------------------------------------+
3341: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3342: | in the message stack. If there is only one message in |
3352:
3353: WHEN OTHERS THEN
3354: ROLLBACK TO global_document_update_PVT;
3355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3356: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
3357: FND_MSG_PUB.Add;
3358: /*---------------------------------------------------------+
3359: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3360: | in the message stack. If there is only one message in |
3507: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3508: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3509: END IF;
3510: IF (SQLCODE = 54) THEN
3511: FND_MESSAGE.SET_NAME('ZX','ZX_RESOURCE_BUSY');
3512: l_context_info_rec.APPLICATION_ID := p_transaction_rec.APPLICATION_ID;
3513: l_context_info_rec.ENTITY_CODE := p_transaction_rec.ENTITY_CODE;
3514: l_context_info_rec.EVENT_CLASS_CODE := p_transaction_rec.EVENT_CLASS_CODE;
3515: l_context_info_rec.TRX_ID := p_transaction_rec.TRX_ID;
3618:
3619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3620: ROLLBACK TO global_document_update_PVT;
3621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3622: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
3623: FND_MSG_PUB.Add;
3624: /*---------------------------------------------------------+
3625: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3626: | in the message stack. If there is only one message in |
3637:
3638: WHEN OTHERS THEN
3639: ROLLBACK TO global_document_update_PVT;
3640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3641: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
3642: FND_MSG_PUB.Add;
3643: /*---------------------------------------------------------+
3644: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3645: | in the message stack. If there is only one message in |
3820:
3821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3822: ROLLBACK TO mark_tax_lines_del_PVT;
3823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3824: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
3825: FND_MSG_PUB.Add;
3826: /*---------------------------------------------------------+
3827: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3828: | in the message stack. If there is only one message in |
3839:
3840: WHEN OTHERS THEN
3841: ROLLBACK TO mark_tax_lines_del_PVT;
3842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3843: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
3844: FND_MSG_PUB.Add;
3845: /*---------------------------------------------------------+
3846: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3847: | in the message stack. If there is only one message in |
3997:
3998: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3999: ROLLBACK TO reverse_document_PVT;
4000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4001: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
4002: FND_MSG_PUB.Add;
4003: /*---------------------------------------------------------+
4004: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
4005: | in the message stack. If there is only one message in |
4016:
4017: WHEN OTHERS THEN
4018: ROLLBACK TO reverse_document_PVT;
4019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4020: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
4021: FND_MSG_PUB.Add;
4022: /*---------------------------------------------------------+
4023: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
4024: | in the message stack. If there is only one message in |
4155:
4156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4157: ROLLBACK TO reverse_distributions_PVT;
4158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4159: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
4160: FND_MSG_PUB.ADD;
4161: /*---------------------------------------------------------+
4162: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
4163: | in the message stack. If there is only one message in |
4173:
4174: WHEN OTHERS THEN
4175: ROLLBACK TO reverse_distributions_PVT;
4176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4177: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
4178: FND_MSG_PUB.ADD;
4179: /*---------------------------------------------------------+
4180: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
4181: | in the message stack. If there is only one message in |
4353:
4354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4355: ROLLBACK TO reverse_doc_distribution_PVT;
4356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4357: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
4358: FND_MSG_PUB.ADD;
4359: /*---------------------------------------------------------+
4360: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
4361: | in the message stack. If there is only one message in |
4371:
4372: WHEN OTHERS THEN
4373: ROLLBACK TO reverse_doc_distribution_PVT;
4374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4375: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
4376: FND_MSG_PUB.ADD;
4377: /*---------------------------------------------------------+
4378: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
4379: | in the message stack. If there is only one message in |
4705: FOR invalid_rec IN check_trx_line_dist_qty
4706: LOOP
4707:
4708: -- x_return_status := FND_API.G_RET_STS_ERROR;
4709: FND_MESSAGE.SET_NAME('ZX','ZX_TRX_LINE_DIST_QTY_REQD');
4710: l_context_info_rec.APPLICATION_ID := invalid_rec.APPLICATION_ID;
4711: l_context_info_rec.ENTITY_CODE := invalid_rec.ENTITY_CODE;
4712: l_context_info_rec.EVENT_CLASS_CODE := invalid_rec.EVENT_CLASS_CODE;
4713: l_context_info_rec.TRX_ID := invalid_rec.TRX_ID;
4722: FOR invalid_rec IN check_trx_line_dist_unit_price
4723: LOOP
4724:
4725: -- x_return_status := FND_API.G_RET_STS_ERROR;
4726: FND_MESSAGE.SET_NAME('ZX','ZX_UNIT_PRICE_REQD');
4727: l_context_info_rec.APPLICATION_ID := invalid_rec.APPLICATION_ID;
4728: l_context_info_rec.ENTITY_CODE := invalid_rec.ENTITY_CODE;
4729: l_context_info_rec.EVENT_CLASS_CODE := invalid_rec.EVENT_CLASS_CODE;
4730: l_context_info_rec.TRX_ID := invalid_rec.TRX_ID;
5040: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name, SQLCODE||' ; '||SQLERRM);
5041: END IF;
5042:
5043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5044: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
5045: FND_MSG_PUB.Add;
5046:
5047: IF c_HEADERS%ISOPEN THEN
5048: close c_HEADERS;
5070: ROLLBACK TO Determine_Recovery_PVT;
5071: --Close all open cursors
5072: IF headers%ISOPEN THEN CLOSE headers; END IF;
5073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5074: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
5075: FND_MSG_PUB.Add;
5076: /*---------------------------------------------------------+
5077: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
5078: | in the message stack. If there is only one message in |
5090: ROLLBACK TO Determine_Recovery_PVT;
5091: --Close all open cursors
5092: IF headers%ISOPEN THEN CLOSE headers; END IF;
5093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5094: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
5095: FND_MSG_PUB.Add;
5096: /*---------------------------------------------------------+
5097: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
5098: | in the message stack. If there is only one message in |
5271:
5272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5273: ROLLBACK TO override_recovery_PVT;
5274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5275: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
5276: FND_MSG_PUB.Add;
5277: /*---------------------------------------------------------+
5278: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
5279: | in the message stack. If there is only one message in |
5294: | been put on the error stack. |
5295: +-------------------------------------------------------*/
5296: ROLLBACK TO override_recovery_PVT;
5297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5298: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
5299: FND_MSG_PUB.Add;
5300: /*---------------------------------------------------------+
5301: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
5302: | in the message stack. If there is only one message in |
5527:
5528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5529: ROLLBACK TO FREEZE_TAX_DISTRIBUTIONS_PVT;
5530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5531: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
5532: FND_MSG_PUB.Add;
5533: /*---------------------------------------------------------+
5534: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
5535: | in the message stack. If there is only one message in |
5545:
5546: WHEN OTHERS THEN
5547: ROLLBACK TO FREEZE_TAX_DISTRIBUTIONS_PVT;
5548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5549: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
5550: FND_MSG_PUB.Add;
5551: /*---------------------------------------------------------+
5552: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
5553: | in the message stack. If there is only one message in |
5832: END IF;
5833:
5834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5835: ROLLBACK TO Get_Tax_Distribution_Ccids_PVT;
5836: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
5837: FND_MSG_PUB.Add;
5838: /*---------------------------------------------------------+
5839: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
5840: | in the message stack. If there is only one message in |
5850:
5851: WHEN OTHERS THEN
5852: ROLLBACK TO Get_Tax_Distribution_Ccids_PVT;
5853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5854: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
5855: FND_MSG_PUB.Add;
5856: /*---------------------------------------------------------+
5857: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
5858: | in the message stack. If there is only one message in |
5980:
5981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5982: ROLLBACK TO Update_Tax_Dist_GL_Date_PVT;
5983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5984: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
5985: FND_MSG_PUB.Add;
5986: /*---------------------------------------------------------+
5987: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
5988: | in the message stack. If there is only one message in |
5998:
5999: WHEN OTHERS THEN
6000: ROLLBACK TO Update_tax_dist_gl_date_PVT;
6001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6002: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
6003: FND_MSG_PUB.Add;
6004: /*---------------------------------------------------------+
6005: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
6006: | in the message stack. If there is only one message in |
6092: /*---------------------------------------------+
6093: | Missing Currency Conversion Rate |
6094: +---------------------------------------------*/
6095: IF p_curr_conv_rate is NULL THEN
6096: FND_MESSAGE.SET_NAME('ZX','ZX_CURRENCY_CONVERSION_RATE_REQD');
6097: FND_MSG_PUB.Add;
6098: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6099: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||
6100: 'Currency conversion rate is passed as null');
6105: /*---------------------------------------------+
6106: | Missing Currency Conversion Date |
6107: +---------------------------------------------*/
6108: IF p_curr_conv_date is NULL THEN
6109: FND_MESSAGE.SET_NAME('ZX','ZX_CURRENCY_CONVERSION_DATE_REQD');
6110: FND_MSG_PUB.Add;
6111: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6112: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||
6113: 'Currency conversion date is passed as null');
6118: /*---------------------------------------------+
6119: | Missing Currency Conversion Type |
6120: +---------------------------------------------*/
6121: IF p_curr_conv_type is NULL THEN
6122: FND_MESSAGE.SET_NAME('ZX','ZX_CURRENCY_CONVERSION_TYPE_REQD');
6123: FND_MSG_PUB.Add;
6124: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6125: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||
6126: 'Currency conversion type is passed as null');
6215:
6216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6217: ROLLBACK TO Update_Exchange_Rate_PVT;
6218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6219: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
6220: FND_MSG_PUB.Add;
6221: /*---------------------------------------------------------+
6222: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
6223: | in the message stack. If there is only one message in |
6233:
6234: WHEN OTHERS THEN
6235: ROLLBACK TO Update_Exchange_Rate_PVT;
6236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6237: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
6238: FND_MSG_PUB.Add;
6239: /*---------------------------------------------------------+
6240: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
6241: | in the message stack. If there is only one message in |
6426:
6427: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6428: ROLLBACK TO discard_tax_only_lines_PVT;
6429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6430: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
6431: FND_MSG_PUB.Add;
6432: /*---------------------------------------------------------+
6433: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
6434: | in the message stack. If there is only one message in |
6444:
6445: WHEN OTHERS THEN
6446: ROLLBACK TO discard_tax_only_lines_PVT;
6447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6448: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
6449: FND_MSG_PUB.Add;
6450: /*---------------------------------------------------------+
6451: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
6452: | in the message stack. If there is only one message in |
6606:
6607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6608: ROLLBACK TO Validate_Document_PVT;
6609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6610: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
6611: FND_MSG_PUB.Add;
6612: /*---------------------------------------------------------+
6613: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
6614: | in the message stack. If there is only one message in |
6625:
6626: WHEN OTHERS THEN
6627: ROLLBACK TO Validate_Document_PVT;
6628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6629: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
6630: FND_MSG_PUB.Add;
6631: /*---------------------------------------------------------+
6632: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
6633: | in the message stack. If there is only one message in |
6796:
6797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6798: ROLLBACK TO Validate_Document_PVT;
6799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6800: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
6801: FND_MSG_PUB.Add;
6802: /*---------------------------------------------------------+
6803: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
6804: | in the message stack. If there is only one message in |
6815:
6816: WHEN OTHERS THEN
6817: ROLLBACK TO Validate_Document_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 |
6954:
6955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6956: ROLLBACK TO Get_Default_Tax_Line_Attrs_PVT;
6957: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6958: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
6959: FND_MSG_PUB.Add;
6960: /*---------------------------------------------------------+
6961: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
6962: | in the message stack. If there is only one message in |
6972:
6973: WHEN OTHERS THEN
6974: ROLLBACK TO Get_Default_Tax_Line_Attrs_PVT;
6975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6976: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
6977: FND_MSG_PUB.Add;
6978: /*---------------------------------------------------------+
6979: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
6980: | in the message stack. If there is only one message in |
7410:
7411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7412: ROLLBACK TO Get_Default_Tax_Det_Attrs_PVT;
7413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7414: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
7415: FND_MSG_PUB.Add;
7416: /*---------------------------------------------------------+
7417: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
7418: | in the message stack. If there is only one message in |
7429:
7430: WHEN OTHERS THEN
7431: ROLLBACK TO Get_Default_Tax_Det_Attrs_PVT;
7432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7433: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
7434: FND_MSG_PUB.Add;
7435: /*---------------------------------------------------------+
7436: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
7437: | in the message stack. If there is only one message in |
7707:
7708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7709: ROLLBACK TO Get_Default_Tax_Det_Attrs_PVT;
7710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7711: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
7712: FND_MSG_PUB.Add;
7713: /*---------------------------------------------------------+
7714: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
7715: | in the message stack. If there is only one message in |
7726:
7727: WHEN OTHERS THEN
7728: ROLLBACK TO Get_Default_Tax_Det_Attrs_PVT;
7729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7730: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
7731: FND_MSG_PUB.Add;
7732: /*---------------------------------------------------------+
7733: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
7734: | in the message stack. If there is only one message in |
7870:
7871: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7872: ROLLBACK TO Set_Tax_Security_Context_PVT;
7873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7874: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
7875: FND_MSG_PUB.Add;
7876: /*---------------------------------------------------------+
7877: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
7878: | in the message stack. If there is only one message in |
7889:
7890: WHEN OTHERS THEN
7891: ROLLBACK TO set_tax_security_context_PVT;
7892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7893: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
7894: FND_MSG_PUB.Add;
7895: /*---------------------------------------------------------+
7896: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
7897: | in the message stack. If there is only one message in |
8032:
8033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8034: ROLLBACK TO Set_Tax_Security_Context_PVT;
8035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8036: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
8037: FND_MSG_PUB.Add;
8038: /*---------------------------------------------------------+
8039: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
8040: | in the message stack. If there is only one message in |
8051:
8052: WHEN OTHERS THEN
8053: ROLLBACK TO set_tax_security_context_PVT;
8054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8055: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
8056: FND_MSG_PUB.Add;
8057: /*---------------------------------------------------------+
8058: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
8059: | in the message stack. If there is only one message in |
8230:
8231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8232: ROLLBACK TO Validate_And_Default_Tax_Attr;
8233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8234: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
8235: FND_MSG_PUB.Add;
8236: /*---------------------------------------------------------+
8237: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
8238: | in the message stack. If there is only one message in |
8249:
8250: WHEN OTHERS THEN
8251: ROLLBACK TO Validate_And_Default_Tax_Attr;
8252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8253: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
8254: FND_MSG_PUB.Add;
8255: /*---------------------------------------------------------+
8256: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
8257: | in the message stack. If there is only one message in |
8311:
8312: END commit_for_tax;
8313:
8314: /* =======================================================================*
8315: | PROCEDURE add_msg : Adds the message to the fnd message stack or |
8316: | local plsql table to be dumped later into the |
8317: | errors GT. |
8318: * =======================================================================*/
8319:
8370: errors_tbl.trx_line_id(l_count+1) := p_context_info_rec.trx_line_id;
8371: errors_tbl.summary_tax_line_number(l_count+1) := p_context_info_rec.summary_tax_line_number;
8372: errors_tbl.tax_line_id(l_count+1) := p_context_info_rec.tax_line_id;
8373: errors_tbl.trx_line_dist_id(l_count+1) := p_context_info_rec.trx_line_dist_id;
8374: errors_tbl.message_text(l_count+1) := fnd_message.get();
8375: END IF; --G_EXTERNAL_API_CALL
8376: l_count:=errors_tbl.application_id.COUNT;
8377: END IF; --G_DATA_TRANSFER_MODE
8378:
8584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8585: -- Commented rollback as per bug 5395191
8586: -- ROLLBACK TO Get_Default_Tax_Reg_PVT;
8587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8588: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
8589: FND_MSG_PUB.Add;
8590: /*---------------------------------------------------------+
8591: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
8592: | in the message stack. If there is only one message in |
8603: WHEN OTHERS THEN
8604: -- Commented rollback as per bug 5395191
8605: -- ROLLBACK TO Get_Default_Tax_Reg_PVT;
8606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8607: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
8608: FND_MSG_PUB.Add;
8609: /*---------------------------------------------------------+
8610: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
8611: | in the message stack. If there is only one message in |
8952:
8953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8954: ROLLBACK TO Insert_Line_Det_Factors_PVT;
8955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8956: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
8957: FND_MSG_PUB.Add;
8958: /*---------------------------------------------------------+
8959: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
8960: | in the message stack. If there is only one message in |
8971: WHEN OTHERS THEN
8972: ROLLBACK TO Insert_Line_Det_Factors_PVT;
8973: IF (SQLCODE = 54) THEN
8974: x_return_status := FND_API.G_RET_STS_ERROR ;
8975: FND_MESSAGE.SET_NAME('ZX','ZX_RESOURCE_BUSY');
8976: ELSE
8977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8978: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
8979: END IF;
8974: x_return_status := FND_API.G_RET_STS_ERROR ;
8975: FND_MESSAGE.SET_NAME('ZX','ZX_RESOURCE_BUSY');
8976: ELSE
8977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8978: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
8979: END IF;
8980: FND_MSG_PUB.Add;
8981: /*---------------------------------------------------------+
8982: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
9241:
9242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9243: ROLLBACK TO Insert_Line_Det_Factors_PVT;
9244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9245: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
9246: FND_MSG_PUB.Add;
9247: /*---------------------------------------------------------+
9248: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
9249: | in the message stack. If there is only one message in |
9265: +-------------------------------------------------------*/
9266: ROLLBACK TO Insert_Line_Det_Factors_PVT;
9267: IF (SQLCODE = 54) THEN
9268: x_return_status := FND_API.G_RET_STS_ERROR ;
9269: FND_MESSAGE.SET_NAME('ZX','ZX_RESOURCE_BUSY');
9270: ELSE
9271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9272: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
9273: END IF;
9268: x_return_status := FND_API.G_RET_STS_ERROR ;
9269: FND_MESSAGE.SET_NAME('ZX','ZX_RESOURCE_BUSY');
9270: ELSE
9271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9272: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
9273: END IF;
9274: FND_MSG_PUB.Add;
9275: /*---------------------------------------------------------+
9276: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
10981:
10982: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10983: ROLLBACK TO Update_Det_Factors_Hdr_PVT;
10984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10985: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
10986: FND_MSG_PUB.Add;
10987: /*---------------------------------------------------------+
10988: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
10989: | in the message stack. If there is only one message in |
10998: END IF;
10999: WHEN OTHERS THEN
11000: ROLLBACK TO Update_Det_Factors_Hdr_PVT;
11001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11002: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
11003: FND_MSG_PUB.Add;
11004: /*---------------------------------------------------------+
11005: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
11006: | in the message stack. If there is only one message in |
11308:
11309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11310: ROLLBACK TO Update_Line_Det_Factors_PVT;
11311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11312: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
11313: FND_MSG_PUB.Add;
11314: /*---------------------------------------------------------+
11315: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
11316: | in the message stack. If there is only one message in |
11332: +-------------------------------------------------------*/
11333: ROLLBACK TO Update_Line_Det_Factors_PVT;
11334: IF (SQLCODE = 54) THEN
11335: x_return_status := FND_API.G_RET_STS_ERROR ;
11336: FND_MESSAGE.SET_NAME('ZX','ZX_RESOURCE_BUSY');
11337: ELSE
11338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11339: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
11340: END IF;
11335: x_return_status := FND_API.G_RET_STS_ERROR ;
11336: FND_MESSAGE.SET_NAME('ZX','ZX_RESOURCE_BUSY');
11337: ELSE
11338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11339: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
11340: END IF;
11341: FND_MSG_PUB.Add;
11342: /*---------------------------------------------------------+
11343: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
11620:
11621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11622: ROLLBACK TO Copy_Ins_Line_Det_Factors_PVT;
11623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11624: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
11625: FND_MSG_PUB.Add;
11626: /*---------------------------------------------------------+
11627: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
11628: | in the message stack. If there is only one message in |
11644: +-------------------------------------------------------*/
11645: ROLLBACK TO Copy_Ins_Line_Det_Factors_PVT;
11646: IF (SQLCODE = 54) THEN
11647: x_return_status := FND_API.G_RET_STS_ERROR ;
11648: FND_MESSAGE.SET_NAME('ZX','ZX_RESOURCE_BUSY');
11649: ELSE
11650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11651: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
11652: END IF;
11647: x_return_status := FND_API.G_RET_STS_ERROR ;
11648: FND_MESSAGE.SET_NAME('ZX','ZX_RESOURCE_BUSY');
11649: ELSE
11650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11651: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
11652: END IF;
11653: FND_MSG_PUB.Add;
11654: /*---------------------------------------------------------+
11655: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
11779:
11780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11781: ROLLBACK TO Is_Recoverability_Affected_PVT;
11782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11783: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
11784: FND_MSG_PUB.Add;
11785: /*---------------------------------------------------------+
11786: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
11787: | in the message stack. If there is only one message in |
11798:
11799: WHEN OTHERS THEN
11800: ROLLBACK TO Is_Recoverability_Affected_PVT;
11801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11802: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
11803: FND_MSG_PUB.Add;
11804: /*---------------------------------------------------------+
11805: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
11806: | in the message stack. If there is only one message in |
11941:
11942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11943: ROLLBACK TO Del_Tax_Line_And_Dists_PVT;
11944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11945: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
11946: FND_MSG_PUB.Add;
11947: /*---------------------------------------------------------+
11948: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
11949: | in the message stack. If there is only one message in |
11960:
11961: WHEN OTHERS THEN
11962: ROLLBACK TO Del_Tax_Line_And_Dists_PVT;
11963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11964: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
11965: FND_MSG_PUB.Add;
11966: /*---------------------------------------------------------+
11967: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
11968: | in the message stack. If there is only one message in |
12096:
12097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12098: ROLLBACK TO Del_Tax_Distributions_PVT;
12099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12100: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
12101: FND_MSG_PUB.Add;
12102: /*---------------------------------------------------------+
12103: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
12104: | in the message stack. If there is only one message in |
12115:
12116: WHEN OTHERS THEN
12117: ROLLBACK TO Del_Tax_Distributions_PVT;
12118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12119: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
12120: FND_MSG_PUB.Add;
12121: /*---------------------------------------------------------+
12122: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
12123: | in the message stack. If there is only one message in |
12427: ROLLBACK TO Get_Default_Tax_Det_Attrs_PVT;
12428: --Close all open cursors
12429: IF headers_doc%ISOPEN THEN CLOSE headers_doc; END IF;
12430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12431: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
12432: FND_MSG_PUB.Add;
12433: /*---------------------------------------------------------+
12434: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
12435: | in the message stack. If there is only one message in |
12447: ROLLBACK TO Get_Default_Tax_Det_Attrs_PVT;
12448: --Close all open cursors
12449: IF headers_doc%ISOPEN THEN CLOSE headers_doc; END IF;
12450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12451: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
12452: FND_MSG_PUB.Add;
12453: /*---------------------------------------------------------+
12454: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
12455: | in the message stack. If there is only one message in |
12594:
12595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12596: ROLLBACK TO Redefault_Intended_Use_PVT;
12597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12598: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
12599: FND_MSG_PUB.Add;
12600: /*---------------------------------------------------------+
12601: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
12602: | in the message stack. If there is only one message in |
12612:
12613: WHEN OTHERS THEN
12614: ROLLBACK TO Redefault_Intended_Use_PVT;
12615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12616: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
12617: FND_MSG_PUB.Add;
12618: /*---------------------------------------------------------+
12619: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
12620: | in the message stack. If there is only one message in |
12763:
12764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12765: ROLLBACK TO Redef_Prod_Fisc_Class_Code_PVT;
12766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12767: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
12768: FND_MSG_PUB.Add;
12769: /*---------------------------------------------------------+
12770: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
12771: | in the message stack. If there is only one message in |
12781:
12782: WHEN OTHERS THEN
12783: ROLLBACK TO Redef_Prod_Fisc_Class_Code_PVT;
12784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12785: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
12786: FND_MSG_PUB.Add;
12787: /*---------------------------------------------------------+
12788: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
12789: | in the message stack. If there is only one message in |
12942:
12943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12944: ROLLBACK TO Redefault_Assessable_Value_PVT;
12945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12946: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
12947: FND_MSG_PUB.Add;
12948: /*---------------------------------------------------------+
12949: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
12950: | in the message stack. If there is only one message in |
12960:
12961: WHEN OTHERS THEN
12962: ROLLBACK TO Redefault_Assessable_Value_PVT;
12963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12964: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
12965: FND_MSG_PUB.Add;
12966: /*---------------------------------------------------------+
12967: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
12968: | in the message stack. If there is only one message in |
13111:
13112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13113: ROLLBACK TO Redefault_Assessable_Value_PVT;
13114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13115: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
13116: FND_MSG_PUB.Add;
13117: /*---------------------------------------------------------+
13118: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
13119: | in the message stack. If there is only one message in |
13129:
13130: WHEN OTHERS THEN
13131: ROLLBACK TO Redefault_Assessable_Value_PVT;
13132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13133: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
13134: FND_MSG_PUB.Add;
13135: /*---------------------------------------------------------+
13136: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
13137: | in the message stack. If there is only one message in |
13304:
13305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13306: ROLLBACK TO Redef_Tax_Class_Code_PVT;
13307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13308: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
13309: FND_MSG_PUB.Add;
13310: /*---------------------------------------------------------+
13311: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
13312: | in the message stack. If there is only one message in |
13322:
13323: WHEN OTHERS THEN
13324: ROLLBACK TO Redef_Tax_Class_Code_PVT;
13325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13326: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
13327: FND_MSG_PUB.Add;
13328: /*---------------------------------------------------------+
13329: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
13330: | in the message stack. If there is only one message in |
13552:
13553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13554: ROLLBACK TO Purge_Tax_Repository_PVT;
13555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13556: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
13557: FND_MSG_PUB.Add;
13558: /*---------------------------------------------------------+
13559: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
13560: | in the message stack. If there is only one message in |
13570:
13571: WHEN OTHERS THEN
13572: ROLLBACK TO Purge_Tax_Repository_PVT;
13573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13574: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
13575: FND_MSG_PUB.Add;
13576: /*---------------------------------------------------------+
13577: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
13578: | in the message stack. If there is only one message in |
13714:
13715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13716: ROLLBACK TO GET_LE_FROM_TAX_REGISTRATN_PVT;
13717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13718: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
13719: FND_MSG_PUB.Add;
13720: /*---------------------------------------------------------+
13721: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
13722: | in the message stack. If there is only one message in |
13732:
13733: WHEN OTHERS THEN
13734: ROLLBACK TO GET_LE_FROM_TAX_REGISTRATN_PVT;
13735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13736: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
13737: FND_MSG_PUB.Add;
13738: /*---------------------------------------------------------+
13739: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
13740: | in the message stack. If there is only one message in |
13860:
13861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13862: ROLLBACK TO update_posting_flag_PVT;
13863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13864: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
13865: FND_MSG_PUB.Add;
13866: /*---------------------------------------------------------+
13867: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
13868: | in the message stack. If there is only one message in |
13879:
13880: WHEN OTHERS THEN
13881: ROLLBACK TO update_posting_flag_PVT;
13882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13883: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
13884: FND_MSG_PUB.Add;
13885: /*---------------------------------------------------------+
13886: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
13887: | in the message stack. If there is only one message in |