eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_NEW_SERVICES_PKG dependencies on FND_API

Line 484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

480: END IF;
481:
482: EXCEPTION
483: WHEN OTHERS THEN
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
486: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
487: 'Error occurred in ' || l_api_name || ' : ' ||SQLERRM);
488: END IF;

Line 508: x_return_status := FND_API.G_RET_STS_SUCCESS;

504: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
505: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||':'||l_api_name||'()+');
506: END IF;
507:
508: x_return_status := FND_API.G_RET_STS_SUCCESS;
509: FORALL i IN NVL(p_trx_line_dist_tbl.application_id.FIRST,0) .. NVL(p_trx_line_dist_tbl.application_id.LAST,-99)
510: UPDATE ZX_LINES_DET_FACTORS SET
511: EVENT_ID = p_event_class_rec.event_id,
512: INTERNAL_ORGANIZATION_ID = p_trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(i),

Line 811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

807: END IF;
808:
809: EXCEPTION
810: WHEN OTHERS THEN
811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
812: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
813: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
814: END IF;
815: END db_update_line_det_factors;

Line 875: IF NOT FND_API.Compatible_API_Call( l_api_version,

871:
872: /*--------------------------------------------------+
873: | Standard call to check for call compatibility |
874: +--------------------------------------------------*/
875: IF NOT FND_API.Compatible_API_Call( l_api_version,
876: p_api_version,
877: l_api_name,
878: G_PKG_NAME
879: ) THEN

Line 880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

876: p_api_version,
877: l_api_name,
878: G_PKG_NAME
879: ) THEN
880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
881: END IF;
882:
883: /*--------------------------------------------------------------+
884: | Initialize message list if p_init_msg_list is set to TRUE |

Line 887: l_init_msg_list := FND_API.G_FALSE;

883: /*--------------------------------------------------------------+
884: | Initialize message list if p_init_msg_list is set to TRUE |
885: +--------------------------------------------------------------*/
886: IF p_init_msg_list is null THEN
887: l_init_msg_list := FND_API.G_FALSE;
888: ELSE
889: l_init_msg_list := p_init_msg_list;
890: END IF;
891:

Line 892: IF FND_API.to_Boolean(l_init_msg_list) THEN

888: ELSE
889: l_init_msg_list := p_init_msg_list;
890: END IF;
891:
892: IF FND_API.to_Boolean(l_init_msg_list) THEN
893: FND_MSG_PUB.initialize;
894: END IF;
895:
896: /*-----------------------------------------+

Line 899: x_return_status := FND_API.G_RET_STS_SUCCESS;

895:
896: /*-----------------------------------------+
897: | Initialize return status to SUCCESS |
898: +-----------------------------------------*/
899: x_return_status := FND_API.G_RET_STS_SUCCESS;
900:
901: /*-----------------------------------------+
902: | Populate Global Variable |
903: +-----------------------------------------*/

Line 1041: WHEN FND_API.G_EXC_ERROR THEN

1037: 'ZX_NEW_SERVICES_PKG: '||l_api_name||'()-');
1038: END IF;
1039:
1040: EXCEPTION
1041: WHEN FND_API.G_EXC_ERROR THEN
1042: ROLLBACK TO freeze_tax_dists_for_itms_PVT;
1043: x_return_status := FND_API.G_RET_STS_ERROR ;
1044: /*---------------------------------------------------------+
1045: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|

Line 1043: x_return_status := FND_API.G_RET_STS_ERROR ;

1039:
1040: EXCEPTION
1041: WHEN FND_API.G_EXC_ERROR THEN
1042: ROLLBACK TO freeze_tax_dists_for_itms_PVT;
1043: x_return_status := FND_API.G_RET_STS_ERROR ;
1044: /*---------------------------------------------------------+
1045: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
1046: | in the message stack. If there is only one message in |
1047: | the stack it retrieves this message |

Line 1049: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1045: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
1046: | in the message stack. If there is only one message in |
1047: | the stack it retrieves this message |
1048: +---------------------------------------------------------*/
1049: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1050: p_count => x_msg_count,
1051: p_data => x_msg_data
1052: );
1053:

Line 1058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1054: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
1055: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
1056: END IF;
1057:
1058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1059: ROLLBACK TO freeze_tax_dists_for_itms_PVT;
1060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1061: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
1062: FND_MSG_PUB.Add;

Line 1060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1056: END IF;
1057:
1058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1059: ROLLBACK TO freeze_tax_dists_for_itms_PVT;
1060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1061: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
1062: FND_MSG_PUB.Add;
1063: /*---------------------------------------------------------+
1064: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|

Line 1068: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1064: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
1065: | in the message stack. If there is only one message in |
1066: | the stack it retrieves this message |
1067: +---------------------------------------------------------*/
1068: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1069: p_count => x_msg_count,
1070: p_data => x_msg_data
1071: );
1072: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1074: END IF;
1075:
1076: WHEN OTHERS THEN
1077: ROLLBACK TO freeze_tax_dists_for_itms_PVT;
1078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1079: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
1080: FND_MSG_PUB.Add;
1081: /*---------------------------------------------------------+
1082: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|

Line 1086: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1082: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
1083: | in the message stack. If there is only one message in |
1084: | the stack it retrieves this message |
1085: +---------------------------------------------------------*/
1086: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1087: p_count => x_msg_count,
1088: p_data => x_msg_data
1089: );
1090: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1159: x_return_status := FND_API.G_RET_STS_SUCCESS;

1155: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_NEW_SERVICES_PKG: '||l_api_name||'()+');
1156: END IF;
1157:
1158: SAVEPOINT update_det_factors_PVT;
1159: x_return_status := FND_API.G_RET_STS_SUCCESS;
1160:
1161: ZX_TDS_CALC_SERVICES_PUB_PKG.initialize (p_event_class_rec => NULL,
1162: p_init_level => 'SESSION',
1163: x_return_status => l_return_status

Line 1182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1178: END LOOP;
1179: CLOSE event_classes;
1180:
1181: IF l_evnt_cls.internal_organization_id.COUNT > 1 THEN
1182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1183: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1184: FND_LOG.STRING(g_level_unexpected,
1185: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel',
1186: 'This API cannot handle Bulk calls');

Line 1191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1187: FND_LOG.STRING(g_level_unexpected,
1188: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1189: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1190: END IF;
1191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1192: END IF;
1193:
1194: IF l_evnt_cls.event_class_code.LAST is null THEN
1195: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1242: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1238: ZX_VALID_INIT_PARAMS_PKG.calculate_tax(p_event_class_rec => l_event_class_rec,
1239: x_return_status => l_return_status
1240: );
1241:
1242: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1243: x_return_status := l_return_status ;
1244: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1245: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1246: G_PKG_NAME||': '||l_api_name||':ZX_VALID_INIT_PARAMS_PKG.calculate_tax returned errors');

Line 1257: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1253: ZX_TCM_PTP_PKG.get_location_id(l_event_class_rec.internal_organization_id,
1254: l_internal_org_location_id,
1255: l_return_status
1256: );
1257: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1258: x_return_status := l_return_status;
1259: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1260: l_context_info_rec.APPLICATION_ID := l_event_class_rec.APPLICATION_ID;
1261: l_context_info_rec.ENTITY_CODE := l_event_class_rec.ENTITY_CODE;

Line 1259: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1255: l_return_status
1256: );
1257: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1258: x_return_status := l_return_status;
1259: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1260: l_context_info_rec.APPLICATION_ID := l_event_class_rec.APPLICATION_ID;
1261: l_context_info_rec.ENTITY_CODE := l_event_class_rec.ENTITY_CODE;
1262: l_context_info_rec.EVENT_CLASS_CODE := l_event_class_rec.EVENT_CLASS_CODE;
1263: l_context_info_rec.TRX_ID := l_event_class_rec.TRX_ID;

Line 1668: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1664: l_effective_date,
1665: l_return_status
1666: );
1667:
1668: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1669: x_return_status := l_return_status;
1670: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1671: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1672: G_PKG_NAME||': '||l_api_name||':zx_valid_init_params_pkg.determine_effective_date returned errors');

Line 1688: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1684: l_effective_date,
1685: l_return_status
1686: );
1687:
1688: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1689: x_return_status := l_return_status;
1690: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1691: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1692: G_PKG_NAME||': '||l_api_name||':zx_valid_init_params_pkg.determine_effective_date returned errors');

Line 1717: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1713: ,l_event_class_rec.tax_event_type_code
1714: ,l_event_class_rec.doc_status_code
1715: );
1716:
1717: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1718: x_return_status := l_return_status;
1719: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1720: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1721: G_PKG_NAME||': '||l_api_name||':zx_valid_init_params_pkg.get_tax_event_type returned errors');

Line 1742: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1738: l_effective_date,
1739: l_event_class_rec
1740: );
1741:
1742: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1743: x_return_status := l_return_status;
1744: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1745: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1746: G_PKG_NAME||': '||l_api_name||':zx_valid_init_params_pkg.populate_event_class_options returned errors');

Line 1764: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1760: 'HEADER',
1761: l_return_status
1762: );
1763:
1764: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1765: x_return_status := l_return_status;
1766: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1767: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1768: G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.initialize returned errors');

Line 1786: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1782: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TOTAL_INC_TAX_AMT(l_trx_line_index) := 0;
1783: ELSIF l_flag = FALSE THEN
1784: Pop_Index_Attrbs_To_Null ( p_index => l_trx_line_index,
1785: x_return_status => l_return_status);
1786: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1787: x_return_status := l_return_status;
1788: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1789: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1790: ' RETURN_STATUS = ' || x_return_status);

Line 1799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1795: END IF;
1796: IF c_lines%ISOPEN THEN
1797: CLOSE c_lines;
1798: END IF;
1799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1800: END IF;
1801: END IF;
1802: l_trx_id := zx_global_structures_pkg.trx_line_dist_tbl.trx_id(l_trx_line_index);
1803: l_legal_entity_id := zx_global_structures_pkg.trx_line_dist_tbl.legal_entity_id(l_trx_line_index);

Line 1820: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1816: p_event_class_rec => l_event_class_rec,
1817: p_line_level_action => p_line_level_action,
1818: x_return_status => l_return_status
1819: );
1820: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1821: x_return_status := l_return_status;
1822: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1823: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1824: ' RETURN_STATUS = ' || x_return_status);

Line 1834: WHEN FND_API.G_EXC_ERROR THEN

1830: RETURN;
1831: END IF;
1832:
1833: EXCEPTION
1834: WHEN FND_API.G_EXC_ERROR THEN
1835: ROLLBACK TO update_det_factors_PVT;
1836: x_return_status := FND_API.G_RET_STS_ERROR ;
1837: IF c_lines%ISOPEN THEN
1838: CLOSE c_lines;

Line 1836: x_return_status := FND_API.G_RET_STS_ERROR ;

1832:
1833: EXCEPTION
1834: WHEN FND_API.G_EXC_ERROR THEN
1835: ROLLBACK TO update_det_factors_PVT;
1836: x_return_status := FND_API.G_RET_STS_ERROR ;
1837: IF c_lines%ISOPEN THEN
1838: CLOSE c_lines;
1839: END IF;
1840: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1840: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1836: x_return_status := FND_API.G_RET_STS_ERROR ;
1837: IF c_lines%ISOPEN THEN
1838: CLOSE c_lines;
1839: END IF;
1840: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1841: p_count => x_msg_count,
1842: p_data => x_msg_data
1843: );
1844: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1844: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
1845: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
1846: END IF;
1847:
1848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1849: ROLLBACK TO update_det_factors_PVT;
1850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1851: IF c_lines%ISOPEN THEN
1852: CLOSE c_lines;

Line 1850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1846: END IF;
1847:
1848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1849: ROLLBACK TO update_det_factors_PVT;
1850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1851: IF c_lines%ISOPEN THEN
1852: CLOSE c_lines;
1853: END IF;
1854: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');

Line 1856: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1852: CLOSE c_lines;
1853: END IF;
1854: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
1855: FND_MSG_PUB.Add;
1856: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1857: p_count => x_msg_count,
1858: p_data => x_msg_data
1859: );
1860: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1861: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
1862: END IF;
1863: WHEN OTHERS THEN
1864: ROLLBACK TO update_det_factors_PVT;
1865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1866: IF c_lines%ISOPEN THEN
1867: CLOSE c_lines;
1868: END IF;
1869: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');

Line 1871: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1867: CLOSE c_lines;
1868: END IF;
1869: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
1870: FND_MSG_PUB.Add;
1871: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1872: p_count => x_msg_count,
1873: p_data => x_msg_data
1874: );
1875: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2105: IF NOT FND_API.Compatible_API_Call( l_api_version,

2101:
2102: /*--------------------------------------------------+
2103: | Standard call to check for call compatibility |
2104: +--------------------------------------------------*/
2105: IF NOT FND_API.Compatible_API_Call( l_api_version,
2106: p_api_version,
2107: l_api_name,
2108: G_PKG_NAME
2109: ) THEN

Line 2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2106: p_api_version,
2107: l_api_name,
2108: G_PKG_NAME
2109: ) THEN
2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2111: END IF;
2112:
2113: /*--------------------------------------------------+
2114: | JAI AP prepay unapplication |

Line 2136: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2132: ,p_trx_line_id => p_trx_line_id
2133: ,x_return_status => l_return_status
2134: );
2135:
2136: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2137: x_return_status := l_return_status;
2138: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2139: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2140: 'JAI_TAX_PROCESSING_PKG.CALCULATE_TAX RETURN_STATUS = ' || x_return_status);

Line 2142: RAISE FND_API.G_EXC_ERROR;

2138: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2139: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2140: 'JAI_TAX_PROCESSING_PKG.CALCULATE_TAX RETURN_STATUS = ' || x_return_status);
2141: END IF;
2142: RAISE FND_API.G_EXC_ERROR;
2143: END IF;
2144:
2145: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2146: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':JAI processing end -');

Line 2162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2158: END IF;
2159: FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_TEXT');
2160: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Invalid Line_Level_Action passed by the calling product.');
2161: ZX_API_PUB.Add_Msg(l_msg_context_info_rec);
2162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2163: END IF;
2164:
2165: /*--------------------------------------------------------------+
2166: | Initialize message list if p_init_msg_list is set to TRUE |

Line 2169: l_init_msg_list := FND_API.G_FALSE;

2165: /*--------------------------------------------------------------+
2166: | Initialize message list if p_init_msg_list is set to TRUE |
2167: +--------------------------------------------------------------*/
2168: IF p_init_msg_list is null THEN
2169: l_init_msg_list := FND_API.G_FALSE;
2170: ELSE
2171: l_init_msg_list := p_init_msg_list;
2172: END IF;
2173:

Line 2174: IF FND_API.to_Boolean(l_init_msg_list) THEN

2170: ELSE
2171: l_init_msg_list := p_init_msg_list;
2172: END IF;
2173:
2174: IF FND_API.to_Boolean(l_init_msg_list) THEN
2175: FND_MSG_PUB.initialize;
2176: END IF;
2177:
2178: /*-----------------------------------------+

Line 2181: x_return_status := FND_API.G_RET_STS_SUCCESS;

2177:
2178: /*-----------------------------------------+
2179: | Initialize return status to SUCCESS |
2180: +-----------------------------------------*/
2181: x_return_status := FND_API.G_RET_STS_SUCCESS;
2182:
2183: /*-----------------------------------------+
2184: | Populate Global Variable |
2185: +-----------------------------------------*/

Line 2207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2203: l_summarization_flag,
2204: l_ret_summ_tax_line_id_flag;
2205:
2206: IF get_event_class_info%NOTFOUND THEN
2207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2208: IF get_event_class_info%ISOPEN THEN
2209: CLOSE get_event_class_info;
2210: END IF;
2211: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 2222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2218: FND_LOG.STRING(g_level_statement,
2219: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2220: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2221: END IF;
2222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2223: END IF;
2224:
2225: CLOSE get_event_class_info;
2226:

Line 2246: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2242: ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly(
2243: p_upg_trx_info_rec => l_upg_trx_info_rec,
2244: x_return_status => l_return_status );
2245:
2246: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2247: x_return_status := l_return_status;
2248: IF (g_level_statement >= g_current_runtime_level ) THEN
2249: FND_LOG.STRING(g_level_statement,
2250: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

Line 2260: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2256: FND_LOG.STRING(g_level_statement,
2257: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2258: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2259: END IF;
2260: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2261: RAISE FND_API.G_EXC_ERROR;
2262: ELSE
2263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2264: END IF;

Line 2261: RAISE FND_API.G_EXC_ERROR;

2257: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2258: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2259: END IF;
2260: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2261: RAISE FND_API.G_EXC_ERROR;
2262: ELSE
2263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2264: END IF;
2265: END IF;

Line 2263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2259: END IF;
2260: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2261: RAISE FND_API.G_EXC_ERROR;
2262: ELSE
2263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2264: END IF;
2265: END IF;
2266: END IF;
2267:

Line 2307: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

2303: -- Reverse the tax distributions, Payables needs to populate
2304: -- zx_reverse_dist_gt for this case.
2305: ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS(x_return_status => l_return_status);
2306:
2307: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2308: x_return_status := l_return_status;
2309: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2310: FND_LOG.STRING(g_level_unexpected,
2311: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

Line 2321: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2317: FND_LOG.STRING(g_level_unexpected,
2318: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2319: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2320: END IF;
2321: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2322: RAISE FND_API.G_EXC_ERROR;
2323: ELSE
2324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2325: END IF;

Line 2322: RAISE FND_API.G_EXC_ERROR;

2318: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2319: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2320: END IF;
2321: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2322: RAISE FND_API.G_EXC_ERROR;
2323: ELSE
2324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2325: END IF;
2326: END IF;

Line 2324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2320: END IF;
2321: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2322: RAISE FND_API.G_EXC_ERROR;
2323: ELSE
2324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2325: END IF;
2326: END IF;
2327:
2328: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2477: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

2473: -- Reverse the tax distributions, Payables needs to populate
2474: -- zx_reverse_dist_gt for this case.
2475: ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS(x_return_status => l_return_status);
2476:
2477: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2478: x_return_status := l_return_status;
2479: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2480: FND_LOG.STRING(g_level_unexpected,
2481: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

Line 2491: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2487: FND_LOG.STRING(g_level_unexpected,
2488: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2489: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2490: END IF;
2491: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2492: RAISE FND_API.G_EXC_ERROR;
2493: ELSE
2494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2495: END IF;

Line 2492: RAISE FND_API.G_EXC_ERROR;

2488: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2489: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2490: END IF;
2491: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2492: RAISE FND_API.G_EXC_ERROR;
2493: ELSE
2494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2495: END IF;
2496: END IF;

Line 2494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2490: END IF;
2491: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2492: RAISE FND_API.G_EXC_ERROR;
2493: ELSE
2494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2495: END IF;
2496: END IF;
2497:
2498: -- Update the freeze flag for the entire invoice

Line 2896: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

2892: x_msg_count => x_msg_count,
2893: x_msg_data => x_msg_data,
2894: p_transaction_rec => p_transaction_rec
2895: );
2896: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2897: x_return_status := l_return_status;
2898: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2899: FND_LOG.STRING(g_level_unexpected,
2900: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.CANCEL_TAX_LINES',

Line 2910: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2906: FND_LOG.STRING(g_level_unexpected,
2907: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2908: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2909: END IF;
2910: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2911: RAISE FND_API.G_EXC_ERROR;
2912: ELSE
2913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2914: END IF;

Line 2911: RAISE FND_API.G_EXC_ERROR;

2907: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2908: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2909: END IF;
2910: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2911: RAISE FND_API.G_EXC_ERROR;
2912: ELSE
2913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2914: END IF;
2915: END IF;

Line 2913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2909: END IF;
2910: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2911: RAISE FND_API.G_EXC_ERROR;
2912: ELSE
2913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2914: END IF;
2915: END IF;
2916: END IF;
2917:

Line 2941: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

2937: x_msg_count => x_msg_count,
2938: x_msg_data => x_msg_data,
2939: p_transaction_rec => p_transaction_rec
2940: );
2941: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2942: x_return_status := l_return_status;
2943: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2944: FND_LOG.STRING(g_level_unexpected,
2945: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.CANCEL_TAX_LINES',

Line 2955: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2951: FND_LOG.STRING(g_level_unexpected,
2952: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2953: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2954: END IF;
2955: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2956: RAISE FND_API.G_EXC_ERROR;
2957: ELSE
2958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2959: END IF;

Line 2956: RAISE FND_API.G_EXC_ERROR;

2952: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2953: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2954: END IF;
2955: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2956: RAISE FND_API.G_EXC_ERROR;
2957: ELSE
2958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2959: END IF;
2960: END IF;

Line 2958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2954: END IF;
2955: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2956: RAISE FND_API.G_EXC_ERROR;
2957: ELSE
2958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2959: END IF;
2960: END IF;
2961:
2962: --Preventice checks

Line 2983: l_return_status := FND_API.G_RET_STS_ERROR;

2979: l_chk_cancel_flg_tbl
2980: LIMIT G_LINES_PER_FETCH;
2981:
2982: IF check_canceled_tax_lines%FOUND AND l_chk_tax_line_id_tbl.COUNT > 0 THEN
2983: l_return_status := FND_API.G_RET_STS_ERROR;
2984: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2985: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2986: 'Following tax lines are not canceled properly:');
2987: FOR i IN NVL(l_chk_tax_line_id_tbl.FIRST,0)..NVL(l_chk_tax_line_id_tbl.LAST,-99) LOOP

Line 3024: l_return_status := FND_API.G_RET_STS_ERROR;

3020: l_chk_tot_dist_amt_tbl
3021: LIMIT G_LINES_PER_FETCH;
3022:
3023: IF check_tax_lines_dists_amt%FOUND AND l_chk_tax_line_id_tbl.COUNT > 0 THEN
3024: l_return_status := FND_API.G_RET_STS_ERROR;
3025:
3026: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3027: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3028: 'Following tax lines and its distributions are out of sync:');

Line 3046: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3042: EXIT WHEN check_tax_lines_dists_amt%NOTFOUND OR l_chk_tax_line_id_tbl.COUNT = 0;
3043: END LOOP;
3044: CLOSE check_tax_lines_dists_amt;
3045:
3046: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3047: FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_TEXT');
3048: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',
3049: 'E-Business Tax is unable to complete the Cancel/Discard/Unapply request.'||
3050: ' Generate FND Debug Log file and APLIST and log a Service Request.');

Line 3052: RAISE FND_API.G_EXC_ERROR;

3048: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',
3049: 'E-Business Tax is unable to complete the Cancel/Discard/Unapply request.'||
3050: ' Generate FND Debug Log file and APLIST and log a Service Request.');
3051: ZX_API_PUB.ADD_MSG(l_msg_context_info_rec);
3052: RAISE FND_API.G_EXC_ERROR;
3053: END IF;
3054:
3055: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3056: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END','ZX_NEW_SERVICES_PKG: '||l_api_name||'()-');

Line 3060: WHEN FND_API.G_EXC_ERROR THEN

3056: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END','ZX_NEW_SERVICES_PKG: '||l_api_name||'()-');
3057: END IF;
3058:
3059: EXCEPTION
3060: WHEN FND_API.G_EXC_ERROR THEN
3061: ROLLBACK TO cancel_tax_lines_PVT;
3062: x_return_status := FND_API.G_RET_STS_ERROR ;
3063: ZX_API_PUB.DUMP_MSG;
3064: /*---------------------------------------------------------+

Line 3062: x_return_status := FND_API.G_RET_STS_ERROR ;

3058:
3059: EXCEPTION
3060: WHEN FND_API.G_EXC_ERROR THEN
3061: ROLLBACK TO cancel_tax_lines_PVT;
3062: x_return_status := FND_API.G_RET_STS_ERROR ;
3063: ZX_API_PUB.DUMP_MSG;
3064: /*---------------------------------------------------------+
3065: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3066: | in the message stack. If there is only one message in |

Line 3069: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3065: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3066: | in the message stack. If there is only one message in |
3067: | the stack it retrieves this message |
3068: +---------------------------------------------------------*/
3069: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3070: p_count => x_msg_count,
3071: p_data => x_msg_data
3072: );
3073: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3077: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3073: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
3074: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
3075: END IF;
3076:
3077: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3078: ROLLBACK TO cancel_tax_lines_PVT;
3079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3080: ZX_API_PUB.DUMP_MSG;
3081: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');

Line 3079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3075: END IF;
3076:
3077: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3078: ROLLBACK TO cancel_tax_lines_PVT;
3079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3080: ZX_API_PUB.DUMP_MSG;
3081: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
3082: FND_MSG_PUB.Add;
3083: /*---------------------------------------------------------+

Line 3088: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3084: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3085: | in the message stack. If there is only one message in |
3086: | the stack it retrieves this message |
3087: +---------------------------------------------------------*/
3088: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3089: p_count => x_msg_count,
3090: p_data => x_msg_data
3091: );
3092: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3093: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
3094: END IF;
3095: WHEN OTHERS THEN
3096: ROLLBACK TO cancel_tax_lines_PVT;
3097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3098: ZX_API_PUB.DUMP_MSG;
3099: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
3100: FND_MSG_PUB.Add;
3101: /*---------------------------------------------------------+

Line 3106: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3102: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3103: | in the message stack. If there is only one message in |
3104: | the stack it retrieves this message |
3105: +---------------------------------------------------------*/
3106: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3107: p_count => x_msg_count,
3108: p_data => x_msg_data
3109: );
3110: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3182: IF NOT FND_API.Compatible_API_Call(l_api_version,

3178:
3179: /*--------------------------------------------------+
3180: | Standard call to check for call compatibility |
3181: +--------------------------------------------------*/
3182: IF NOT FND_API.Compatible_API_Call(l_api_version,
3183: p_api_version,
3184: l_api_name,
3185: G_PKG_NAME
3186: ) THEN

Line 3187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3183: p_api_version,
3184: l_api_name,
3185: G_PKG_NAME
3186: ) THEN
3187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3188: END IF;
3189:
3190: /*--------------------------------------------------------------+
3191: | Initialize message list if p_init_msg_list is set to TRUE |

Line 3194: l_init_msg_list := FND_API.G_FALSE;

3190: /*--------------------------------------------------------------+
3191: | Initialize message list if p_init_msg_list is set to TRUE |
3192: +--------------------------------------------------------------*/
3193: IF p_init_msg_list is null THEN
3194: l_init_msg_list := FND_API.G_FALSE;
3195: ELSE
3196: l_init_msg_list := p_init_msg_list;
3197: END IF;
3198:

Line 3199: IF FND_API.to_Boolean(l_init_msg_list) THEN

3195: ELSE
3196: l_init_msg_list := p_init_msg_list;
3197: END IF;
3198:
3199: IF FND_API.to_Boolean(l_init_msg_list) THEN
3200: FND_MSG_PUB.initialize;
3201: END IF;
3202:
3203: /*-----------------------------------------+

Line 3206: x_return_status := FND_API.G_RET_STS_SUCCESS;

3202:
3203: /*-----------------------------------------+
3204: | Initialize return status to SUCCESS |
3205: +-----------------------------------------*/
3206: x_return_status := FND_API.G_RET_STS_SUCCESS;
3207:
3208: /*-----------------------------------------+
3209: | Populate Global Variable |
3210: +-----------------------------------------*/

Line 3293: x_return_status := FND_API.G_RET_STS_ERROR;

3289: l_chk_tot_dist_amt_tbl
3290: LIMIT G_LINES_PER_FETCH;
3291:
3292: IF check_tax_lines_dists_amt%FOUND AND l_chk_tax_line_id_tbl.COUNT > 0 THEN
3293: x_return_status := FND_API.G_RET_STS_ERROR;
3294:
3295: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3296: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3297: 'Following tax lines and its distributions are out of sync:');

Line 3315: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3311: EXIT WHEN check_tax_lines_dists_amt%NOTFOUND OR l_chk_tax_line_id_tbl.COUNT = 0;
3312: END LOOP;
3313: CLOSE check_tax_lines_dists_amt;
3314:
3315: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3316: --Populate Message structures
3317: BEGIN
3318: SELECT application_id,
3319: entity_code,

Line 3349: RAISE FND_API.G_EXC_ERROR;

3345: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',
3346: 'E-Business Tax is unable to process the request.'||
3347: ' Generate FND Debug Log file and APLIST and log a Service Request.');
3348: ZX_API_PUB.ADD_MSG(l_msg_context_info_rec);
3349: RAISE FND_API.G_EXC_ERROR;
3350: END IF;
3351: -- End : Preventive check code --
3352:
3353: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3358: WHEN FND_API.G_EXC_ERROR THEN

3354: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END','ZX_NEW_SERVICES_PKG: '||l_api_name||'()-');
3355: END IF;
3356:
3357: EXCEPTION
3358: WHEN FND_API.G_EXC_ERROR THEN
3359: ROLLBACK TO Del_Cand_Tax_Distributions_PVT;
3360: x_return_status := FND_API.G_RET_STS_ERROR ;
3361: ZX_API_PUB.DUMP_MSG;
3362: /*---------------------------------------------------------+

Line 3360: x_return_status := FND_API.G_RET_STS_ERROR ;

3356:
3357: EXCEPTION
3358: WHEN FND_API.G_EXC_ERROR THEN
3359: ROLLBACK TO Del_Cand_Tax_Distributions_PVT;
3360: x_return_status := FND_API.G_RET_STS_ERROR ;
3361: ZX_API_PUB.DUMP_MSG;
3362: /*---------------------------------------------------------+
3363: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3364: | in the message stack. If there is only one message in |

Line 3367: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3363: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3364: | in the message stack. If there is only one message in |
3365: | the stack it retrieves this message |
3366: +---------------------------------------------------------*/
3367: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3368: p_count => x_msg_count,
3369: p_data => x_msg_data
3370: );
3371:

Line 3376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3372: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
3373: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
3374: END IF;
3375:
3376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3377: ROLLBACK TO Del_Cand_Tax_Distributions_PVT;
3378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3379: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
3380: FND_MSG_PUB.Add;

Line 3378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3374: END IF;
3375:
3376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3377: ROLLBACK TO Del_Cand_Tax_Distributions_PVT;
3378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3379: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
3380: FND_MSG_PUB.Add;
3381: /*---------------------------------------------------------+
3382: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|

Line 3386: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3382: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3383: | in the message stack. If there is only one message in |
3384: | the stack it retrieves this message |
3385: +---------------------------------------------------------*/
3386: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3387: p_count => x_msg_count,
3388: p_data => x_msg_data
3389: );
3390:

Line 3397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3393: END IF;
3394:
3395: WHEN OTHERS THEN
3396: ROLLBACK TO Del_Cand_Tax_Distributions_PVT;
3397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3398: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
3399: FND_MSG_PUB.Add;
3400: /*---------------------------------------------------------+
3401: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|

Line 3405: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3401: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3402: | in the message stack. If there is only one message in |
3403: | the stack it retrieves this message |
3404: +---------------------------------------------------------*/
3405: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3406: p_count => x_msg_count,
3407: p_data => x_msg_data
3408: );
3409: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3450: IF NOT FND_API.Compatible_API_Call( l_api_version,

3446:
3447: /*--------------------------------------------------+
3448: | Standard call to check for call compatibility |
3449: +--------------------------------------------------*/
3450: IF NOT FND_API.Compatible_API_Call( l_api_version,
3451: p_api_version,
3452: l_api_name,
3453: G_PKG_NAME
3454: ) THEN

Line 3455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3451: p_api_version,
3452: l_api_name,
3453: G_PKG_NAME
3454: ) THEN
3455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3456: END IF;
3457:
3458: /*--------------------------------------------------------------+
3459: | Initialize message list if p_init_msg_list is set to TRUE |

Line 3462: l_init_msg_list := FND_API.G_FALSE;

3458: /*--------------------------------------------------------------+
3459: | Initialize message list if p_init_msg_list is set to TRUE |
3460: +--------------------------------------------------------------*/
3461: IF p_init_msg_list is null THEN
3462: l_init_msg_list := FND_API.G_FALSE;
3463: ELSE
3464: l_init_msg_list := p_init_msg_list;
3465: END IF;
3466:

Line 3467: IF FND_API.to_Boolean(l_init_msg_list) THEN

3463: ELSE
3464: l_init_msg_list := p_init_msg_list;
3465: END IF;
3466:
3467: IF FND_API.to_Boolean(l_init_msg_list) THEN
3468: FND_MSG_PUB.initialize;
3469: END IF;
3470:
3471: /*-----------------------------------------+

Line 3474: x_return_status := FND_API.G_RET_STS_SUCCESS;

3470:
3471: /*-----------------------------------------+
3472: | Initialize return status to SUCCESS |
3473: +-----------------------------------------*/
3474: x_return_status := FND_API.G_RET_STS_SUCCESS;
3475:
3476: /*-----------------------------------------+
3477: | Populate Global Variable |
3478: +-----------------------------------------*/

Line 3515: WHEN FND_API.G_EXC_ERROR THEN

3511: 'ZX_NEW_SERVICES_PKG: '||l_api_name||'()-');
3512: END IF;
3513:
3514: EXCEPTION
3515: WHEN FND_API.G_EXC_ERROR THEN
3516: ROLLBACK TO sync_tax_dist_dff_pvt;
3517: x_return_status := FND_API.G_RET_STS_ERROR ;
3518: /*---------------------------------------------------------+
3519: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|

Line 3517: x_return_status := FND_API.G_RET_STS_ERROR ;

3513:
3514: EXCEPTION
3515: WHEN FND_API.G_EXC_ERROR THEN
3516: ROLLBACK TO sync_tax_dist_dff_pvt;
3517: x_return_status := FND_API.G_RET_STS_ERROR ;
3518: /*---------------------------------------------------------+
3519: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3520: | in the message stack. If there is only one message in |
3521: | the stack it retrieves this message |

Line 3523: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3519: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3520: | in the message stack. If there is only one message in |
3521: | the stack it retrieves this message |
3522: +---------------------------------------------------------*/
3523: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3524: p_count => x_msg_count,
3525: p_data => x_msg_data
3526: );
3527:

Line 3532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3528: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
3529: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
3530: END IF;
3531:
3532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3533: ROLLBACK TO sync_tax_dist_dff_pvt;
3534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3535: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
3536: FND_MSG_PUB.Add;

Line 3534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3530: END IF;
3531:
3532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3533: ROLLBACK TO sync_tax_dist_dff_pvt;
3534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3535: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
3536: FND_MSG_PUB.Add;
3537: /*---------------------------------------------------------+
3538: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|

Line 3542: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3538: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3539: | in the message stack. If there is only one message in |
3540: | the stack it retrieves this message |
3541: +---------------------------------------------------------*/
3542: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3543: p_count => x_msg_count,
3544: p_data => x_msg_data
3545: );
3546:

Line 3553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3549: END IF;
3550:
3551: WHEN OTHERS THEN
3552: ROLLBACK TO sync_tax_dist_dff_pvt;
3553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3554: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
3555: FND_MSG_PUB.Add;
3556: /*---------------------------------------------------------+
3557: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|

Line 3561: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3557: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
3558: | in the message stack. If there is only one message in |
3559: | the stack it retrieves this message |
3560: +---------------------------------------------------------*/
3561: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3562: p_count => x_msg_count,
3563: p_data => x_msg_data
3564: );
3565: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN