DBA Data[Home] [Help]

APPS.ZX_VALID_INIT_PARAMS_PKG dependencies on FND_API

Line 70: x_return_status := FND_API.G_RET_STS_SUCCESS;

66: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
67: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
68: END IF;
69:
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71:
72: IF ZX_API_PUB.G_DATA_TRANSFER_MODE IN ('TAB','WIN') THEN
73:
74: l_index := p_trx_line_index;

Line 104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

100: END IF;
101:
102: EXCEPTION
103: WHEN OTHERS THEN
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
106: FND_LOG.STRING(
107: G_LEVEL_UNEXPECTED,
108: G_MODULE_NAME||l_api_name,

Line 145: x_return_status := FND_API.G_RET_STS_SUCCESS;

141: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
142: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
143: END IF;
144:
145: x_return_status := FND_API.G_RET_STS_SUCCESS;
146:
147: get_locations (p_event_class_rec,
148: nvl(p_trx_line_index,0),
149: l_ship_from_location_id,

Line 156: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

152: l_bill_to_location_id,
153: l_return_status
154: );
155:
156: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
157: x_return_status := l_return_status;
158: RETURN;
159: END IF;
160:

Line 169: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

165: ,l_ship_to_location_id
166: ,p_event_class_rec.rdng_ship_to_pty_tx_prof_id
167: ,l_return_status
168: );
169: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
170: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
171: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
172: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
173: 'Error: Unable to return rdng_ship_to_pty_tx_prof_id for rounding_ship_to_party_id : ' || to_char(p_event_class_rec.rounding_ship_to_party_id));

Line 170: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

166: ,p_event_class_rec.rdng_ship_to_pty_tx_prof_id
167: ,l_return_status
168: );
169: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
170: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
171: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
172: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
173: 'Error: Unable to return rdng_ship_to_pty_tx_prof_id for rounding_ship_to_party_id : ' || to_char(p_event_class_rec.rounding_ship_to_party_id));
174: END IF;

Line 195: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

191: ,p_event_class_rec.rdng_ship_from_pty_tx_prof_id
192: ,l_return_status
193: );
194:
195: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
196: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
197: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
198: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
199: 'Error: Unable to return rdng_ship_from_pty_tx_prof_id for rounding_ship_from_party_id : ' || to_char(p_event_class_rec.rounding_ship_from_party_id));

Line 196: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

192: ,l_return_status
193: );
194:
195: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
196: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
197: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
198: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
199: 'Error: Unable to return rdng_ship_from_pty_tx_prof_id for rounding_ship_from_party_id : ' || to_char(p_event_class_rec.rounding_ship_from_party_id));
200: END IF;

Line 221: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

217: ,p_event_class_rec.rdng_ship_to_pty_tx_p_st_id
218: ,l_return_status
219: );
220:
221: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
222: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
223: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
224: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
225: 'Error: Unable to return rdng_ship_to_pty_tx_p_st_id for rndg_ship_to_party_site_id : ' || to_char(p_event_class_rec.rndg_ship_to_party_site_id));

Line 222: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

218: ,l_return_status
219: );
220:
221: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
222: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
223: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
224: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
225: 'Error: Unable to return rdng_ship_to_pty_tx_p_st_id for rndg_ship_to_party_site_id : ' || to_char(p_event_class_rec.rndg_ship_to_party_site_id));
226: END IF;

Line 246: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

242: ,null
243: ,p_event_class_rec.rdng_ship_from_pty_tx_p_st_id
244: ,l_return_status
245: );
246: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
247: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
248: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
249: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
250: 'Error: Unable to return rdng_ship_from_pty_tx_p_st_id for rndg_ship_from_party_site_id : ' || to_char(p_event_class_rec.rndg_ship_from_party_site_id));

Line 247: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

243: ,p_event_class_rec.rdng_ship_from_pty_tx_p_st_id
244: ,l_return_status
245: );
246: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
247: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
248: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
249: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
250: 'Error: Unable to return rdng_ship_from_pty_tx_p_st_id for rndg_ship_from_party_site_id : ' || to_char(p_event_class_rec.rndg_ship_from_party_site_id));
251: END IF;

Line 275: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

271: ,p_event_class_rec.rdng_bill_to_pty_tx_prof_id
272: ,l_return_status
273: );
274:
275: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
276: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
277: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
278: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
279: 'Error: Unable to return rdng_bill_to_pty_tx_prof_id for rounding_bill_to_party_id : ' || to_char(p_event_class_rec.rounding_bill_to_party_id));

Line 276: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

272: ,l_return_status
273: );
274:
275: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
276: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
277: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
278: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
279: 'Error: Unable to return rdng_bill_to_pty_tx_prof_id for rounding_bill_to_party_id : ' || to_char(p_event_class_rec.rounding_bill_to_party_id));
280: END IF;

Line 307: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

303: ,p_event_class_rec.rdng_bill_from_pty_tx_prof_id
304: ,l_return_status
305: );
306:
307: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
308: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
309: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
310: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
311: 'Error: Unable to return rdng_bill_from_pty_tx_prof_id for rounding_bill_from_party_id : ' || to_char(p_event_class_rec.rounding_bill_from_party_id));

Line 308: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

304: ,l_return_status
305: );
306:
307: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
308: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
309: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
310: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
311: 'Error: Unable to return rdng_bill_from_pty_tx_prof_id for rounding_bill_from_party_id : ' || to_char(p_event_class_rec.rounding_bill_from_party_id));
312: END IF;

Line 339: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

335: ,p_event_class_rec.rdng_bill_to_pty_tx_p_st_id
336: ,l_return_status
337: );
338:
339: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
340: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
341: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
342: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
343: 'Error: Unable to return rdng_bill_to_pty_tx_p_st_id for rndg_bill_to_party_site_id : ' || to_char(p_event_class_rec.rndg_bill_to_party_site_id));

Line 340: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

336: ,l_return_status
337: );
338:
339: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
340: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
341: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
342: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
343: 'Error: Unable to return rdng_bill_to_pty_tx_p_st_id for rndg_bill_to_party_site_id : ' || to_char(p_event_class_rec.rndg_bill_to_party_site_id));
344: END IF;

Line 371: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

367: ,p_event_class_rec.rdng_bill_from_pty_tx_p_st_id
368: ,l_return_status
369: );
370:
371: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
372: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
373: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
374: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
375: 'Error: Unable to return rdng_bill_from_pty_tx_p_st_id for rndg_bill_from_party_site_id : ' || to_char(p_event_class_rec.rndg_bill_from_party_site_id));

Line 372: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

368: ,l_return_status
369: );
370:
371: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
372: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
373: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
374: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
375: 'Error: Unable to return rdng_bill_from_pty_tx_p_st_id for rndg_bill_from_party_site_id : ' || to_char(p_event_class_rec.rndg_bill_from_party_site_id));
376: END IF;

Line 470: x_return_status := FND_API.G_RET_STS_SUCCESS;

466: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
467: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
468: END IF;
469:
470: x_return_status := FND_API.G_RET_STS_SUCCESS;
471:
472: IF ZX_API_PUB.G_PUB_SRVC in ('CALCULATE_TAX','IMPORT_DOCUMENT_WITH_TAX','OVERRIDE_TAX',
473: 'GET_DEFAULT_TAX_DET_ATTRS','VALIDATE_DOCUMENT_FOR_TAX') THEN
474: IF ZX_API_PUB.G_DATA_TRANSFER_MODE = 'TAB' THEN

Line 519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

515: EXCEPTION
516: WHEN NO_DATA_FOUND THEN
517: null;
518: WHEN OTHERS THEN
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
520: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
521: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
522: 'No lines exist in zx_transaction_lines_gt/zx_lines_det_factors'||
523: ' which is incorrect or the event information in headers and lines is incorrect.'||

Line 557: x_return_status := FND_API.G_RET_STS_SUCCESS;

553: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
554: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
555: END IF;
556:
557: x_return_status := FND_API.G_RET_STS_SUCCESS;
558: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
559:
560: BEGIN
561: IF p_event_class_rec.event_class_code = 'SALES_TRANSACTION_TAX_QUOTE' THEN

Line 750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

746: EXCEPTION
747: WHEN NO_DATA_FOUND THEN
748: NULL;
749: WHEN OTHERS THEN
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
751: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
752: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
753: END IF;
754: RETURN;

Line 784: x_return_status := FND_API.G_RET_STS_SUCCESS;

780: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
781: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
782: END IF;
783:
784: x_return_status := FND_API.G_RET_STS_SUCCESS;
785:
786: IF p_event_class_rec.event_class_code = 'SALES_TRANSACTION_TAX_QUOTE' THEN
787: l_application_id := 222;
788: ELSIF p_event_class_rec.event_class_code = 'PURCHASE_TRANSACTION_TAX_QUOTE' THEN

Line 829: IF x_return_status = FND_API.G_RET_STS_ERROR then

825: p_org_id => p_event_class_rec.internal_organization_id,
826: x_product_options_rec => l_zx_product_options_rec,
827: x_return_status => x_return_status);
828:
829: IF x_return_status = FND_API.G_RET_STS_ERROR then
830:
831: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
832: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Incorrect return status after calling '||
833: 'ZX_GLOBAL_STRUCTURES_PKG.get_product_options_info');

Line 858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

854: EXCEPTION
855: WHEN NO_DATA_FOUND THEN
856: NULL;
857: WHEN OTHERS THEN
858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
859: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
860: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
861: END IF;
862: END populate_appl_product_options;

Line 899: x_return_status := FND_API.G_RET_STS_SUCCESS;

895: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
896: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
897: END IF;
898:
899: x_return_status := FND_API.G_RET_STS_SUCCESS;
900:
901: /*
902: SELECT tax_event_class_code,
903: reference_application_id,

Line 931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

927: X_RETURN_STATUS => x_return_status);
928:
929: IF L_INDEX IS NULL THEN
930:
931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
932: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
933: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
934: 'The event class information passed is incorrect. Please CHECK! '||SQLERRM);
935: END IF;

Line 958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

954: END IF;
955:
956: EXCEPTION
957: WHEN OTHERS THEN
958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
959: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
960: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
961: 'The event class information passed is incorrect. Please CHECK! '||SQLERRM);
962: END IF;

Line 991: x_return_status := FND_API.G_RET_STS_SUCCESS;

987: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
988: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
989: END IF;
990:
991: x_return_status := FND_API.G_RET_STS_SUCCESS;
992:
993: IF p_event_class_rec.event_class_code = 'SALES_TRANSACTION_TAX_QUOTE' THEN
994: SELECT 0,
995: zxevntclsmap.tax_event_class_code,

Line 1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1210: X_RETURN_STATUS => x_return_status);
1211:
1212: IF L_INDEX IS NULL THEN
1213:
1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1215: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1216: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
1217: 'The event class information passed is incorrect. Please CHECK! '||SQLERRM);
1218: END IF;

Line 1507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1503: END IF;
1504:
1505: EXCEPTION
1506: WHEN OTHERS THEN
1507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1508: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1509: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
1510: 'The event class information passed is incorrect. Please CHECK! ' ||
1511: SQLERRM);

Line 1553: x_return_status := FND_API.G_RET_STS_SUCCESS;

1549: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1550: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1551: END IF;
1552:
1553: x_return_status := FND_API.G_RET_STS_SUCCESS;
1554:
1555:
1556: get_event_typ_mappings_info(
1557: P_ENTITY_CODE => p_entity_code,

Line 1569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1565:
1566: IF p_evnt_cls_code in ('SALES_TRANSACTION_TAX_QUOTE','PURCHASE_TRANSACTION_TAX_QUOTE') THEN
1567: x_tx_evnt_typ_code:='CREATE';
1568: ELSE
1569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1570: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1571: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1572: ' Incorrect event information passed in for event type :' ||p_evnt_typ_code ||' Please Check!');
1573: END IF;

Line 1613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1609: END IF;
1610:
1611: EXCEPTION
1612: WHEN OTHERS THEN
1613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1614: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1615: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
1616: END IF;
1617: END get_tax_event_type;

Line 1650: x_return_status := FND_API.G_RET_STS_SUCCESS;

1646: END IF;
1647:
1648: l_first_pty_org_id := ZX_SECURITY.G_FIRST_PARTY_ORG_ID ;
1649:
1650: x_return_status := FND_API.G_RET_STS_SUCCESS;
1651: ZX_SECURITY.set_security_context(p_event_class_rec.legal_entity_id,
1652: p_event_class_rec.internal_organization_id,
1653: p_effective_date,
1654: l_return_status

Line 1657: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1653: p_effective_date,
1654: l_return_status
1655: );
1656:
1657: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1658: x_return_status := l_return_status;
1659: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1660: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
1661: l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;

Line 1659: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1655: );
1656:
1657: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1658: x_return_status := l_return_status;
1659: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1660: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
1661: l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;
1662: l_context_info_rec.EVENT_CLASS_CODE := p_event_class_rec.EVENT_CLASS_CODE;
1663: l_context_info_rec.TRX_ID := p_event_class_rec.TRX_ID;

Line 1727: x_return_status := FND_API.G_RET_STS_SUCCESS;

1723: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1724: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1725: END IF;
1726:
1727: x_return_status := FND_API.G_RET_STS_SUCCESS;
1728:
1729: BEGIN
1730: SELECT first_pty_org_id ,
1731: related_doc_date,

Line 1761: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1757: l_upg_trx_info_rec.trx_id := p_event_class_rec.trx_id;
1758: ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly(p_upg_trx_info_rec => l_upg_trx_info_rec,
1759: x_return_status => l_return_status
1760: );
1761: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1762: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1763: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly returned errors');
1764: END IF;
1765: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1765: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1761: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1762: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1763: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly returned errors');
1764: END IF;
1765: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1766: RAISE FND_API.G_EXC_ERROR;
1767: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1769: END IF;

Line 1766: RAISE FND_API.G_EXC_ERROR;

1762: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1763: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly returned errors');
1764: END IF;
1765: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1766: RAISE FND_API.G_EXC_ERROR;
1767: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1769: END IF;
1770: END IF;

Line 1767: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1763: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly returned errors');
1764: END IF;
1765: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1766: RAISE FND_API.G_EXC_ERROR;
1767: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1769: END IF;
1770: END IF;
1771: SELECT first_pty_org_id ,

Line 1768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1764: END IF;
1765: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1766: RAISE FND_API.G_EXC_ERROR;
1767: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1769: END IF;
1770: END IF;
1771: SELECT first_pty_org_id ,
1772: related_doc_date,

Line 1818: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1814: l_return_status
1815: );
1816:
1817:
1818: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1819: x_return_status := l_return_status;
1820: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1821: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
1822: l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;

Line 1820: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1816:
1817:
1818: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1819: x_return_status := l_return_status;
1820: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1821: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
1822: l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;
1823: l_context_info_rec.EVENT_CLASS_CODE := p_event_class_rec.EVENT_CLASS_CODE;
1824: l_context_info_rec.TRX_ID := p_event_class_rec.TRX_ID;

Line 1838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1834: END IF;
1835:
1836: EXCEPTION
1837: WHEN OTHERS THEN
1838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1839: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1840: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
1841: 'Data is expected to be in eBTax repository for this call. Please CHECK your sequence of calls to eBTax' ||
1842: SQLERRM);

Line 1881: x_return_status := FND_API.G_RET_STS_SUCCESS;

1877: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1878: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1879: END IF;
1880:
1881: x_return_status := FND_API.G_RET_STS_SUCCESS;
1882: BEGIN
1883: SELECT first_pty_org_id ,
1884: related_doc_date,
1885: adjusted_doc_date,

Line 1914: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1910: l_upg_trx_info_rec.trx_id := p_trx_id;
1911: ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly(p_upg_trx_info_rec => l_upg_trx_info_rec,
1912: x_return_status => l_return_status
1913: );
1914: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1915: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1916: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly returned errors');
1917: END IF;
1918: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1918: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1914: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1915: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1916: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly returned errors');
1917: END IF;
1918: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1919: RAISE FND_API.G_EXC_ERROR;
1920: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1922: END IF;

Line 1919: RAISE FND_API.G_EXC_ERROR;

1915: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1916: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly returned errors');
1917: END IF;
1918: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1919: RAISE FND_API.G_EXC_ERROR;
1920: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1922: END IF;
1923: END IF;

Line 1920: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1916: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly returned errors');
1917: END IF;
1918: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1919: RAISE FND_API.G_EXC_ERROR;
1920: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1922: END IF;
1923: END IF;
1924: SELECT first_pty_org_id ,

Line 1921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1917: END IF;
1918: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1919: RAISE FND_API.G_EXC_ERROR;
1920: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1922: END IF;
1923: END IF;
1924: SELECT first_pty_org_id ,
1925: related_doc_date,

Line 1955: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1951: l_effective_date,
1952: l_return_status
1953: );
1954:
1955: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1956: x_return_status := l_return_status;
1957: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1958: l_context_info_rec.APPLICATION_ID := p_application_id;
1959: l_context_info_rec.ENTITY_CODE := p_entity_code;

Line 1957: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1953: );
1954:
1955: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1956: x_return_status := l_return_status;
1957: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1958: l_context_info_rec.APPLICATION_ID := p_application_id;
1959: l_context_info_rec.ENTITY_CODE := p_entity_code;
1960: l_context_info_rec.EVENT_CLASS_CODE := p_event_class_code;
1961: l_context_info_rec.TRX_ID := p_trx_id;

Line 1975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1971: END IF;
1972:
1973: EXCEPTION
1974: WHEN OTHERS THEN
1975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1976: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1977: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
1978: 'Data is expected to be in eBTax repository for this call. Please CHECK your sequence of calls to eBTax '||
1979: SQLERRM);

Line 2018: x_return_status := FND_API.G_RET_STS_SUCCESS;

2014: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2015: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2016: END IF;
2017:
2018: x_return_status := FND_API.G_RET_STS_SUCCESS;
2019:
2020: BEGIN
2021: SELECT /*+ INDEX(ZX_REV_TRX_HEADERS_GT ZX_REV_TRX_HEADERS_GT_U1) INDEX(ZX_REVERSE_TRX_LINES_GT ZX_REVERSE_TRX_LINES_GT_U1) */
2022: hdrgt.legal_entity_id ,

Line 2076: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2072: l_upg_trx_info_rec.trx_id := p_event_class_rec.trx_id;
2073: ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly(p_upg_trx_info_rec => l_upg_trx_info_rec,
2074: x_return_status => l_return_status
2075: );
2076: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2077: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2078: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly returned errors');
2079: END IF;
2080: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2080: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2076: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2077: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2078: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly returned errors');
2079: END IF;
2080: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2081: RAISE FND_API.G_EXC_ERROR;
2082: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2084: END IF;

Line 2081: RAISE FND_API.G_EXC_ERROR;

2077: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2078: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly returned errors');
2079: END IF;
2080: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2081: RAISE FND_API.G_EXC_ERROR;
2082: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2084: END IF;
2085: END IF;

Line 2082: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2078: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly returned errors');
2079: END IF;
2080: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2081: RAISE FND_API.G_EXC_ERROR;
2082: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2084: END IF;
2085: END IF;
2086: SELECT /*+ INDEX(ZX_REV_TRX_HEADERS_GT ZX_REV_TRX_HEADERS_GT_U1) INDEX(ZX_REVERSE_TRX_LINES_GT ZX_REVERSE_TRX_LINES_GT_U1) */

Line 2083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2079: END IF;
2080: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2081: RAISE FND_API.G_EXC_ERROR;
2082: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2084: END IF;
2085: END IF;
2086: SELECT /*+ INDEX(ZX_REV_TRX_HEADERS_GT ZX_REV_TRX_HEADERS_GT_U1) INDEX(ZX_REVERSE_TRX_LINES_GT ZX_REVERSE_TRX_LINES_GT_U1) */
2087: hdrgt.legal_entity_id ,

Line 2139: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2135: l_effective_date,
2136: l_return_status
2137: );
2138:
2139: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2140: x_return_status := l_return_status;
2141: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2142: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
2143: l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;

Line 2141: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2137: );
2138:
2139: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2140: x_return_status := l_return_status;
2141: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2142: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
2143: l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;
2144: l_context_info_rec.EVENT_CLASS_CODE := p_event_class_rec.EVENT_CLASS_CODE;
2145: l_context_info_rec.TRX_ID := p_event_class_rec.TRX_ID;

Line 2159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2155: END IF;
2156:
2157: EXCEPTION
2158: WHEN OTHERS THEN
2159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2160: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
2161: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
2162: 'Data is expected to be in eBTax repository for this call. Please CHECK your sequence of calls to eBTax '||
2163: SQLERRM);

Line 2196: x_return_status := FND_API.G_RET_STS_SUCCESS;

2192: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2193: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2194: END IF;
2195:
2196: x_return_status := FND_API.G_RET_STS_SUCCESS;
2197:
2198: SELECT record_flag
2199: INTO l_record_flag
2200: FROM ZX_EVNT_CLS_MAPPINGS

Line 2223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2219: RETURN l_record_flag;
2220:
2221: EXCEPTION
2222: WHEN OTHERS THEN
2223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2224: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
2225: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
2226: END IF;
2227: RETURN l_record_flag;

Line 2258: x_return_status := FND_API.G_RET_STS_SUCCESS;

2254: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2255: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2256: END IF;
2257:
2258: x_return_status := FND_API.G_RET_STS_SUCCESS;
2259: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
2260:
2261: /* ----------------------------------------------------------------------+
2262: | Initializing the tax regime dtl procedures |

Line 2275: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2271: get_tax_event_class (l_return_status
2272: ,p_event_class_rec
2273: );
2274:
2275: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2276: x_return_status := l_return_status;
2277: RETURN;
2278: END IF;
2279:

Line 2290: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2286: l_effective_date,
2287: l_return_status
2288: );
2289:
2290: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2291: x_return_status := l_return_status;
2292: RETURN;
2293: END IF;
2294:

Line 2303: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2299: l_effective_date,
2300: l_return_status
2301: );
2302:
2303: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2304: x_return_status := l_return_status;
2305: RETURN;
2306: END IF;
2307:

Line 2321: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2317: ,p_event_class_rec.tax_event_type_code
2318: ,p_event_class_rec.doc_status_code
2319: );
2320:
2321: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2322: x_return_status := l_return_status;
2323: RETURN;
2324: END IF;
2325:

Line 2334: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2330: l_effective_date,
2331: p_event_class_rec
2332: );
2333:
2334: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2335: x_return_status := l_return_status;
2336: RETURN;
2337: END IF;
2338:

Line 2348: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2344: populate_appl_product_options(l_return_status,
2345: p_event_class_rec
2346: );
2347:
2348: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2349: x_return_status := l_return_status;
2350: RETURN;
2351: END IF;
2352:

Line 2371: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2367: p_trx_line_index => NULL,
2368: x_return_status => l_return_status
2369: );
2370:
2371: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2372: x_return_status := l_return_status;
2373: RETURN;
2374: END IF;
2375: END IF;

Line 2384: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2380: ZX_CHECK_REQUIRED_PARAMS_PKG.check_trx_headers_tbl(l_return_status,
2381: p_event_class_rec
2382: );
2383:
2384: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2385: x_return_status := l_return_status;
2386: RETURN;
2387: END IF;
2388:

Line 2392: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2388:
2389: ZX_CHECK_REQUIRED_PARAMS_PKG.check_trx_line_tbl(l_return_status,
2390: p_event_class_rec
2391: );
2392: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2393: x_return_status := l_return_status;
2394: RETURN;
2395: END IF;
2396: ELSIF ZX_API_PUB.G_DATA_TRANSFER_MODE = 'PLS' THEN

Line 2401: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2397: ZX_CHECK_REQUIRED_PARAMS_PKG.check_trx_lines(l_return_status,
2398: p_event_class_rec
2399: );
2400:
2401: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2402: x_return_status := l_return_status;
2403: RETURN;
2404: END IF;
2405: END IF;

Line 2531: x_return_status := FND_API.G_RET_STS_SUCCESS;

2527: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2528: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2529: END IF;
2530:
2531: x_return_status := FND_API.G_RET_STS_SUCCESS;
2532: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
2533:
2534: /* ----------------------------------------------------------------------+
2535: | Initializing the tax regime dtl procedures |

Line 2548: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2544: get_tax_event_class (l_return_status
2545: ,p_event_class_rec
2546: );
2547:
2548: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2549: x_return_status := l_return_status;
2550: RETURN;
2551: END IF;
2552:

Line 2565: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2561: populate_appl_product_options(l_return_status,
2562: p_event_class_rec
2563: );
2564:
2565: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2566: x_return_status := l_return_status;
2567: RETURN;
2568: END IF;
2569:

Line 2665: x_return_status := FND_API.G_RET_STS_SUCCESS;

2661: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2662: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2663: END IF;
2664:
2665: x_return_status := FND_API.G_RET_STS_SUCCESS;
2666: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
2667:
2668: /* ----------------------------------------------------------------------+
2669: | Get Tax Event Class |

Line 2675: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2671: get_tax_event_class (l_return_status
2672: ,p_event_class_rec
2673: );
2674:
2675: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2676: x_return_status := l_return_status;
2677: RETURN;
2678: END IF;
2679:

Line 2689: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2685: get_tax_subscriber(p_event_class_rec,
2686: l_return_status
2687: );
2688:
2689: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2690: x_return_status := l_return_status;
2691: RETURN;
2692: END IF;
2693:

Line 2710: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2706: ,p_event_class_rec.doc_status_code
2707: );
2708:
2709:
2710: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2711: x_return_status := l_return_status;
2712: RETURN;
2713: END IF;
2714:

Line 2723: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2719: ZX_CHECK_REQUIRED_PARAMS_PKG.check_trx_rec(l_return_status,
2720: p_trx_rec
2721: );
2722:
2723: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2724: x_return_status := l_return_status;
2725: RETURN;
2726: END IF;
2727:

Line 2737: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2733: l_effective_date,
2734: l_return_status
2735: );
2736:
2737: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2738: x_return_status := l_return_status;
2739: RETURN;
2740: END IF;
2741:

Line 2751: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2747: l_effective_date,
2748: p_event_class_rec
2749: );
2750:
2751: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2752: x_return_status := l_return_status;
2753: RETURN;
2754: END IF;
2755:

Line 2764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2760: /* ----------------------------------------------------------------------+
2761: | Override Flag |
2762: + ----------------------------------------------------------------------*/
2763: IF p_override is NULL THEN
2764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2765: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2766: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Override Level is required');
2767: END IF;
2768: RETURN;

Line 2874: x_return_status := FND_API.G_RET_STS_SUCCESS;

2870: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2871: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2872: END IF;
2873:
2874: x_return_status := FND_API.G_RET_STS_SUCCESS;
2875: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
2876:
2877: /*------------------------------------------------------+
2878: | Copy to Event Class Record |

Line 2898: --IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2894: --get_tax_subscriber(p_event_class_rec,
2895: -- l_return_status
2896: -- );
2897:
2898: --IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2899: -- x_return_status := l_return_status;
2900: -- RETURN;
2901: --END IF;
2902:

Line 2919: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2915: p_event_class_rec.event_class_mapping_id, -- Bug 5200373
2916: p_event_class_rec.summarization_flag
2917: );
2918:
2919: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2920: x_return_status := l_return_status;
2921: RETURN;
2922: END IF;
2923:

Line 2937: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2933: p_event_class_rec.tax_event_type_code,
2934: p_event_class_rec.doc_status_code
2935: );
2936:
2937: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2938: x_return_status := l_return_status;
2939: RETURN;
2940: END IF;
2941:

Line 2949: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2945: ZX_CHECK_REQUIRED_PARAMS_PKG.check_trx_rec(l_return_status,
2946: p_trx_rec
2947: );
2948:
2949: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2950: x_return_status := l_return_status;
2951: RETURN;
2952: END IF;
2953:

Line 2992: x_return_status := FND_API.G_RET_STS_SUCCESS;

2988: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2989: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2990: END IF;
2991:
2992: x_return_status := FND_API.G_RET_STS_SUCCESS;
2993:
2994: /* ----------------------------------------------------------------------+
2995: | Bug 3129063 - Setting the Security Context for Subscription |
2996: + ----------------------------------------------------------------------*/

Line 3004: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3000: p_transaction_line_rec.trx_id,
3001: l_return_status
3002: );
3003:
3004: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3005: x_return_status := l_return_status;
3006: RETURN;
3007: END IF;
3008:

Line 3016: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3012: ZX_CHECK_REQUIRED_PARAMS_PKG.check_trx_line_rec(l_return_status
3013: ,p_transaction_line_rec
3014: );
3015:
3016: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3017: x_return_status := l_return_status;
3018: RETURN;
3019: END IF;
3020:

Line 3067: x_return_status := FND_API.G_RET_STS_SUCCESS;

3063: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3064: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3065: END IF;
3066:
3067: x_return_status := FND_API.G_RET_STS_SUCCESS;
3068: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
3069:
3070:
3071: /* ----------------------------------------------------------------------+

Line 3095: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3091: + ----------------------------------------------------------------------*/
3092:
3093: set_security_context(l_return_status,p_event_class_rec);
3094:
3095: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3096: x_return_status := l_return_status;
3097: RETURN;
3098: END IF;
3099:

Line 3113: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3109: p_event_class_rec.event_class_mapping_id, -- Bug 5200373
3110: p_event_class_rec.summarization_flag
3111: );
3112:
3113: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3114: x_return_status := l_return_status;
3115: RETURN;
3116: END IF;
3117:

Line 3170: x_return_status := FND_API.G_RET_STS_SUCCESS;

3166: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3167: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3168: END IF;
3169:
3170: x_return_status := FND_API.G_RET_STS_SUCCESS;
3171: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
3172:
3173: SELECT reversing_appln_id,
3174: reversing_entity_code,

Line 3194: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3190: l_trx_id,
3191: l_return_status
3192: );
3193:
3194: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3195: x_return_status := l_return_status;
3196: RETURN;
3197: END IF;
3198:

Line 3215: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3211: ,l_event_class_mapping_id -- Bug 5200373
3212: ,l_summarization_flag
3213: );
3214:
3215: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3216: x_return_status := l_return_status;
3217: RETURN;
3218: END IF;
3219:

Line 3258: x_return_status := FND_API.G_RET_STS_SUCCESS;

3254: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3255: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3256: END IF;
3257:
3258: x_return_status := FND_API.G_RET_STS_SUCCESS;
3259: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
3260:
3261: /* ----------------------------------------------------------------------+
3262: | Get Tax Event Class |

Line 3268: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3264: get_tax_event_class (l_return_status
3265: ,p_event_class_rec
3266: );
3267:
3268: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3269: x_return_status := l_return_status;
3270: RETURN;
3271: END IF;
3272:

Line 3320: x_return_status := FND_API.G_RET_STS_SUCCESS;

3316: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3317: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3318: END IF;
3319:
3320: x_return_status := FND_API.G_RET_STS_SUCCESS;
3321: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
3322:
3323: /*------------------------------------------------------+
3324: | Copy to Event Class Record |

Line 3340: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3336: get_tax_subscriber(p_event_class_rec,
3337: l_return_status
3338: );
3339:
3340: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3341: x_return_status := l_return_status;
3342: RETURN;
3343: END IF;
3344:

Line 3361: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3357: ,p_event_class_rec.event_class_mapping_id -- Bug 5200373
3358: ,p_event_class_rec.summarization_flag
3359: );
3360:
3361: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3362: x_return_status := l_return_status;
3363: RETURN;
3364: END IF;
3365:

Line 3379: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3375: ,p_trx_rec.tax_event_type_code
3376: ,p_trx_rec.doc_event_status
3377: );
3378:
3379: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3380: x_return_status := l_return_status;
3381: RETURN;
3382: END IF;
3383:

Line 3391: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3387: ZX_CHECK_REQUIRED_PARAMS_PKG.check_trx_rec(l_return_status,
3388: p_trx_rec
3389: );
3390:
3391: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3392: x_return_status := l_return_status;
3393: RETURN;
3394: END IF;
3395:

Line 3457: x_return_status := FND_API.G_RET_STS_SUCCESS;

3453: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3454: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3455: END IF;
3456:
3457: x_return_status := FND_API.G_RET_STS_SUCCESS;
3458: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
3459:
3460: /*------------------------------------------------------+
3461: | Copy to Event Class Record |

Line 3477: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3473: get_tax_subscriber(p_event_class_rec,
3474: l_return_status
3475: );
3476:
3477: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3478: x_return_status := l_return_status;
3479: RETURN;
3480: END IF;
3481:

Line 3489: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3485: get_tax_event_class (l_return_status
3486: ,p_event_class_rec
3487: );
3488:
3489: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3490: x_return_status := l_return_status;
3491: RETURN;
3492: END IF;
3493:

Line 3509: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3505: ,p_trx_rec.tax_event_type_code
3506: ,p_trx_rec.doc_event_status
3507: );
3508:
3509: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3510: x_return_status := l_return_status;
3511: RETURN;
3512: END IF;
3513:

Line 3521: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3517: ZX_CHECK_REQUIRED_PARAMS_PKG.check_trx_rec(l_return_status,
3518: p_trx_rec
3519: );
3520:
3521: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3522: x_return_status := l_return_status;
3523: RETURN;
3524: END IF;
3525:

Line 3571: x_return_status := FND_API.G_RET_STS_SUCCESS;

3567: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3568: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3569: END IF;
3570:
3571: x_return_status := FND_API.G_RET_STS_SUCCESS;
3572: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
3573:
3574: /*------------------------------------------------------+
3575: | Copy to Event Class Record |

Line 3612: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3608: get_tax_subscriber(p_event_class_rec,
3609: l_return_status
3610: );
3611:
3612: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3613: x_return_status := l_return_status;
3614: RETURN;
3615: END IF;
3616:

Line 3633: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3629: ,p_event_class_rec.event_class_mapping_id -- Bug 5200373
3630: ,p_event_class_rec.summarization_flag
3631: );
3632:
3633: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3634: x_return_status := l_return_status;
3635: RETURN;
3636: END IF;
3637:

Line 3652: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3648: ,p_trx_rec.tax_event_type_code
3649: ,p_trx_rec.doc_event_status
3650: );
3651:
3652: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3653: x_return_status := l_return_status;
3654: RETURN;
3655: END IF;
3656:

Line 3669: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3665: l_effective_date,
3666: l_return_status
3667: );
3668:
3669: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3670: x_return_status := l_return_status;
3671: RETURN;
3672: END IF;
3673:

Line 3682: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3678: l_effective_date,
3679: p_event_class_rec
3680: );
3681:
3682: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3683: x_return_status := l_return_status;
3684: RETURN;
3685: END IF;
3686:

Line 3694: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3690: ZX_CHECK_REQUIRED_PARAMS_PKG.check_trx_rec(l_return_status,
3691: p_trx_rec
3692: );
3693:
3694: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3695: x_return_status := l_return_status;
3696: RETURN;
3697: END IF;
3698:

Line 3819: x_return_status := FND_API.G_RET_STS_SUCCESS;

3815: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3816: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3817: END IF;
3818:
3819: x_return_status := FND_API.G_RET_STS_SUCCESS;
3820:
3821: /* ----------------------------------------------------------------------+
3822: | Bug 3129063 - Setting the Security Context for Subscription |
3823: + ----------------------------------------------------------------------*/

Line 3831: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3827: p_trx_rec.trx_id,
3828: l_return_status
3829: );
3830:
3831: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3832: x_return_status := l_return_status;
3833: RETURN;
3834: END IF;
3835:

Line 3844: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3840: ZX_CHECK_REQUIRED_PARAMS_PKG.check_trx_rec(l_return_status,
3841: p_trx_rec
3842: );
3843:
3844: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3845: x_return_status := l_return_status;
3846: RETURN;
3847: END IF;
3848:

Line 3895: x_return_status := FND_API.G_RET_STS_SUCCESS;

3891: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3892: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3893: END IF;
3894:
3895: x_return_status := FND_API.G_RET_STS_SUCCESS;
3896: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
3897:
3898: /* ----------------------------------------------------------------------+
3899: | Get Tax Event Class |

Line 3905: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3901: get_tax_event_class (l_return_status
3902: ,p_event_class_rec
3903: );
3904:
3905: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3906: x_return_status := l_return_status;
3907: RETURN;
3908: END IF;
3909:

Line 3918: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3914: l_effective_date,
3915: l_return_status
3916: );
3917:
3918: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3919: x_return_status := l_return_status;
3920: RETURN;
3921: END IF;
3922:

Line 3933: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3929: l_effective_date ,
3930: l_return_status
3931: );
3932:
3933: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3934: x_return_status := l_return_status;
3935: RETURN;
3936: END IF;
3937:

Line 3951: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3947: ,p_event_class_rec.tax_event_type_code
3948: ,p_event_class_rec.doc_status_code
3949: );
3950:
3951: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3952: x_return_status := l_return_status;
3953: RETURN;
3954: END IF;
3955:

Line 3966: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3962: p_trx_line_index => p_trx_line_index,
3963: x_return_status => l_return_status
3964: );
3965:
3966: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3967: x_return_status := l_return_status;
3968: RETURN;
3969: END IF;
3970:

Line 3980: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3976: ZX_CHECK_REQUIRED_PARAMS_PKG.check_trx_headers_tbl(l_return_status,
3977: p_event_class_rec
3978: );
3979:
3980: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3981: x_return_status := l_return_status;
3982: RETURN;
3983: END IF;
3984:

Line 3993: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3989: ZX_CHECK_REQUIRED_PARAMS_PKG.check_trx_lines(l_return_status,
3990: p_event_class_rec
3991: );
3992:
3993: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3994: x_return_status := l_return_status;
3995: RETURN;
3996: END IF;
3997: END IF; --G_PUB_SRVC <> 'COPY_INSERT_LINE_DET_FACTORS'

Line 4008: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4004: l_effective_date,
4005: p_event_class_rec
4006: );
4007:
4008: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4009: x_return_status := l_return_status;
4010: RETURN;
4011: END IF;
4012:

Line 4020: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4016: populate_appl_product_options(l_return_status,
4017: p_event_class_rec
4018: );
4019:
4020: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4021: x_return_status := l_return_status;
4022: RETURN;
4023: END IF;
4024:

Line 4152: x_return_status := FND_API.G_RET_STS_SUCCESS;

4148: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4149: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
4150: END IF;
4151:
4152: x_return_status := FND_API.G_RET_STS_SUCCESS;
4153: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
4154:
4155: /* ----------------------------------------------------------------------+
4156: | Get Tax Event Class |

Line 4162: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4158: get_tax_event_class (l_return_status
4159: ,p_event_class_rec
4160: );
4161:
4162: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4163: x_return_status := l_return_status;
4164: RETURN;
4165: END IF;
4166:

Line 4175: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4171: l_effective_date,
4172: l_return_status
4173: );
4174:
4175: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4176: x_return_status := l_return_status;
4177: RETURN;
4178: END IF;
4179:

Line 4189: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4185: l_effective_date ,
4186: l_return_status
4187: );
4188:
4189: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4190: x_return_status := l_return_status;
4191: RETURN;
4192: END IF;
4193:

Line 4207: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4203: ,p_event_class_rec.tax_event_type_code
4204: ,p_event_class_rec.doc_status_code
4205: );
4206:
4207: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4208: x_return_status := l_return_status;
4209: RETURN;
4210: END IF;
4211:

Line 4220: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4216: l_effective_date,
4217: p_event_class_rec
4218: );
4219:
4220: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4221: x_return_status := l_return_status;
4222: RETURN;
4223: END IF;
4224:

Line 4235: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4231:
4232: -- populate global event class record structure
4233: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := p_event_class_rec;
4234:
4235: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4236: x_return_status := l_return_status;
4237: RETURN;
4238: END IF;
4239:

Line 4427: x_return_status := FND_API.G_RET_STS_SUCCESS;

4423: l_index binary_integer;
4424:
4425: BEGIN
4426:
4427: x_return_status := FND_API.G_RET_STS_SUCCESS;
4428:
4429: l_index := dbms_utility.get_hash_value(to_char(p_application_id)||p_entity_code||p_event_class_code,1,8192);
4430:
4431: IF ZX_GLOBAL_STRUCTURES_PKG.g_zx_event_class_rec_tbl.EXISTS(l_index) then

Line 4578: x_return_status := FND_API.G_RET_STS_SUCCESS;

4574: l_index binary_integer;
4575:
4576: BEGIN
4577:
4578: x_return_status := FND_API.G_RET_STS_SUCCESS;
4579:
4580: l_index := dbms_utility.get_hash_value(to_char(p_application_id)||p_entity_code||p_event_class_code
4581: ||p_event_type_Code,1,8192);
4582: