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_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 471: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

522: EXCEPTION
523: WHEN NO_DATA_FOUND THEN
524: null;
525: WHEN OTHERS THEN
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
527: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
528: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
529: 'No lines exist in zx_transaction_lines_gt/zx_lines_det_factors'||
530: ' which is incorrect or the event information in headers and lines is incorrect.'||

Line 564: x_return_status := FND_API.G_RET_STS_SUCCESS;

560: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
561: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
562: END IF;
563:
564: x_return_status := FND_API.G_RET_STS_SUCCESS;
565: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
566:
567: BEGIN
568: IF p_event_class_rec.event_class_code = 'SALES_TRANSACTION_TAX_QUOTE' THEN

Line 758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

754: EXCEPTION
755: WHEN NO_DATA_FOUND THEN
756: NULL;
757: WHEN OTHERS THEN
758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
759: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
760: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
761: END IF;
762: RETURN;

Line 792: x_return_status := FND_API.G_RET_STS_SUCCESS;

788: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
789: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
790: END IF;
791:
792: x_return_status := FND_API.G_RET_STS_SUCCESS;
793:
794: IF p_event_class_rec.event_class_code = 'SALES_TRANSACTION_TAX_QUOTE' THEN
795: l_application_id := 222;
796: ELSIF p_event_class_rec.event_class_code = 'PURCHASE_TRANSACTION_TAX_QUOTE' THEN

Line 837: IF x_return_status = FND_API.G_RET_STS_ERROR then

833: p_org_id => p_event_class_rec.internal_organization_id,
834: x_product_options_rec => l_zx_product_options_rec,
835: x_return_status => x_return_status);
836:
837: IF x_return_status = FND_API.G_RET_STS_ERROR then
838:
839: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
840: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Incorrect return status after calling '||
841: 'ZX_GLOBAL_STRUCTURES_PKG.get_product_options_info');

Line 866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

862: EXCEPTION
863: WHEN NO_DATA_FOUND THEN
864: NULL;
865: WHEN OTHERS THEN
866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
867: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
868: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
869: END IF;
870: END populate_appl_product_options;

Line 907: x_return_status := FND_API.G_RET_STS_SUCCESS;

903: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
904: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
905: END IF;
906:
907: x_return_status := FND_API.G_RET_STS_SUCCESS;
908:
909: /*
910: SELECT tax_event_class_code,
911: reference_application_id,

Line 939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

935: X_RETURN_STATUS => x_return_status);
936:
937: IF L_INDEX IS NULL THEN
938:
939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
940: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
941: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
942: 'The event class information passed is incorrect. Please CHECK! '||SQLERRM);
943: END IF;

Line 966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

962: END IF;
963:
964: EXCEPTION
965: WHEN OTHERS THEN
966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
967: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
968: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
969: 'The event class information passed is incorrect. Please CHECK! '||SQLERRM);
970: END IF;

Line 999: x_return_status := FND_API.G_RET_STS_SUCCESS;

995: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
996: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
997: END IF;
998:
999: x_return_status := FND_API.G_RET_STS_SUCCESS;
1000:
1001: IF p_event_class_rec.event_class_code = 'SALES_TRANSACTION_TAX_QUOTE' THEN
1002: SELECT 0,
1003: zxevntclsmap.tax_event_class_code,

Line 1236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1232: X_RETURN_STATUS => x_return_status);
1233:
1234: IF L_INDEX IS NULL THEN
1235:
1236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1237: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1238: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
1239: 'The event class information passed is incorrect. Please CHECK! '||SQLERRM);
1240: END IF;

Line 1529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1525: END IF;
1526:
1527: EXCEPTION
1528: WHEN OTHERS THEN
1529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1530: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1531: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
1532: 'The event class information passed is incorrect. Please CHECK! ' ||
1533: SQLERRM);

Line 1575: x_return_status := FND_API.G_RET_STS_SUCCESS;

1571: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1572: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1573: END IF;
1574:
1575: x_return_status := FND_API.G_RET_STS_SUCCESS;
1576:
1577:
1578: get_event_typ_mappings_info(
1579: P_ENTITY_CODE => p_entity_code,

Line 1591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1587:
1588: IF p_evnt_cls_code in ('SALES_TRANSACTION_TAX_QUOTE','PURCHASE_TRANSACTION_TAX_QUOTE') THEN
1589: x_tx_evnt_typ_code:='CREATE';
1590: ELSE
1591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1592: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1593: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1594: ' Incorrect event information passed in for event type :' ||p_evnt_typ_code ||' Please Check!');
1595: END IF;

Line 1635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1631: END IF;
1632:
1633: EXCEPTION
1634: WHEN OTHERS THEN
1635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1636: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1637: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
1638: END IF;
1639: END get_tax_event_type;

Line 1672: x_return_status := FND_API.G_RET_STS_SUCCESS;

1668: END IF;
1669:
1670: l_first_pty_org_id := ZX_SECURITY.G_FIRST_PARTY_ORG_ID ;
1671:
1672: x_return_status := FND_API.G_RET_STS_SUCCESS;
1673: ZX_SECURITY.set_security_context(p_event_class_rec.legal_entity_id,
1674: p_event_class_rec.internal_organization_id,
1675: p_effective_date,
1676: l_return_status

Line 1679: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1675: p_effective_date,
1676: l_return_status
1677: );
1678:
1679: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1680: x_return_status := l_return_status;
1681: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1682: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
1683: l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;

Line 1681: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1677: );
1678:
1679: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1680: x_return_status := l_return_status;
1681: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1682: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
1683: l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;
1684: l_context_info_rec.EVENT_CLASS_CODE := p_event_class_rec.EVENT_CLASS_CODE;
1685: l_context_info_rec.TRX_ID := p_event_class_rec.TRX_ID;

Line 1750: x_return_status := FND_API.G_RET_STS_SUCCESS;

1746: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1747: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1748: END IF;
1749:
1750: x_return_status := FND_API.G_RET_STS_SUCCESS;
1751:
1752: BEGIN
1753: SELECT first_pty_org_id ,
1754: related_doc_date,

Line 1786: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1782: l_upg_trx_info_rec.trx_id := p_event_class_rec.trx_id;
1783: ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly(p_upg_trx_info_rec => l_upg_trx_info_rec,
1784: x_return_status => l_return_status
1785: );
1786: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1787: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1788: 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');
1789: END IF;
1790: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1790: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1786: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1787: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1788: 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');
1789: END IF;
1790: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1791: RAISE FND_API.G_EXC_ERROR;
1792: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1794: END IF;

Line 1791: RAISE FND_API.G_EXC_ERROR;

1787: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1788: 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');
1789: END IF;
1790: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1791: RAISE FND_API.G_EXC_ERROR;
1792: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1794: END IF;
1795: END IF;

Line 1792: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1788: 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');
1789: END IF;
1790: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1791: RAISE FND_API.G_EXC_ERROR;
1792: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1794: END IF;
1795: END IF;
1796: SELECT first_pty_org_id ,

Line 1793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1789: END IF;
1790: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1791: RAISE FND_API.G_EXC_ERROR;
1792: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1794: END IF;
1795: END IF;
1796: SELECT first_pty_org_id ,
1797: related_doc_date,

Line 1845: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1841: l_return_status
1842: );
1843:
1844:
1845: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1846: x_return_status := l_return_status;
1847: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1848: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
1849: l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;

Line 1847: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1843:
1844:
1845: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1846: x_return_status := l_return_status;
1847: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1848: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
1849: l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;
1850: l_context_info_rec.EVENT_CLASS_CODE := p_event_class_rec.EVENT_CLASS_CODE;
1851: l_context_info_rec.TRX_ID := p_event_class_rec.TRX_ID;

Line 1865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1861: END IF;
1862:
1863: EXCEPTION
1864: WHEN OTHERS THEN
1865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1866: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1867: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
1868: 'Data is expected to be in eBTax repository for this call. Please CHECK your sequence of calls to eBTax' ||
1869: SQLERRM);

Line 1908: x_return_status := FND_API.G_RET_STS_SUCCESS;

1904: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1905: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1906: END IF;
1907:
1908: x_return_status := FND_API.G_RET_STS_SUCCESS;
1909: BEGIN
1910: SELECT first_pty_org_id ,
1911: related_doc_date,
1912: adjusted_doc_date,

Line 1941: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1937: l_upg_trx_info_rec.trx_id := p_trx_id;
1938: ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly(p_upg_trx_info_rec => l_upg_trx_info_rec,
1939: x_return_status => l_return_status
1940: );
1941: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1942: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1943: 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');
1944: END IF;
1945: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1945: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1941: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1942: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1943: 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');
1944: END IF;
1945: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1946: RAISE FND_API.G_EXC_ERROR;
1947: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1949: END IF;

Line 1946: RAISE FND_API.G_EXC_ERROR;

1942: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1943: 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');
1944: END IF;
1945: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1946: RAISE FND_API.G_EXC_ERROR;
1947: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1949: END IF;
1950: END IF;

Line 1947: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1943: 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');
1944: END IF;
1945: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1946: RAISE FND_API.G_EXC_ERROR;
1947: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1949: END IF;
1950: END IF;
1951: SELECT first_pty_org_id ,

Line 1948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1944: END IF;
1945: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1946: RAISE FND_API.G_EXC_ERROR;
1947: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1949: END IF;
1950: END IF;
1951: SELECT first_pty_org_id ,
1952: related_doc_date,

Line 1982: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1978: l_effective_date,
1979: l_return_status
1980: );
1981:
1982: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1983: x_return_status := l_return_status;
1984: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1985: l_context_info_rec.APPLICATION_ID := p_application_id;
1986: l_context_info_rec.ENTITY_CODE := p_entity_code;

Line 1984: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1980: );
1981:
1982: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1983: x_return_status := l_return_status;
1984: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1985: l_context_info_rec.APPLICATION_ID := p_application_id;
1986: l_context_info_rec.ENTITY_CODE := p_entity_code;
1987: l_context_info_rec.EVENT_CLASS_CODE := p_event_class_code;
1988: l_context_info_rec.TRX_ID := p_trx_id;

Line 2002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1998: END IF;
1999:
2000: EXCEPTION
2001: WHEN OTHERS THEN
2002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2003: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
2004: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
2005: 'Data is expected to be in eBTax repository for this call. Please CHECK your sequence of calls to eBTax '||
2006: SQLERRM);

Line 2045: x_return_status := FND_API.G_RET_STS_SUCCESS;

2041: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2042: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2043: END IF;
2044:
2045: x_return_status := FND_API.G_RET_STS_SUCCESS;
2046:
2047: BEGIN
2048: 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) */
2049: hdrgt.legal_entity_id ,

Line 2103: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2099: l_upg_trx_info_rec.trx_id := p_event_class_rec.trx_id;
2100: ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly(p_upg_trx_info_rec => l_upg_trx_info_rec,
2101: x_return_status => l_return_status
2102: );
2103: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2104: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2105: 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');
2106: END IF;
2107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2103: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2104: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2105: 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');
2106: END IF;
2107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2108: RAISE FND_API.G_EXC_ERROR;
2109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2111: END IF;

Line 2108: RAISE FND_API.G_EXC_ERROR;

2104: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2105: 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');
2106: END IF;
2107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2108: RAISE FND_API.G_EXC_ERROR;
2109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2111: END IF;
2112: END IF;

Line 2109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2105: 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');
2106: END IF;
2107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2108: RAISE FND_API.G_EXC_ERROR;
2109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2111: END IF;
2112: END IF;
2113: 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 2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2106: END IF;
2107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2108: RAISE FND_API.G_EXC_ERROR;
2109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2111: END IF;
2112: END IF;
2113: 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) */
2114: hdrgt.legal_entity_id ,

Line 2166: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2162: l_effective_date,
2163: l_return_status
2164: );
2165:
2166: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2167: x_return_status := l_return_status;
2168: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2169: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
2170: l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;

Line 2168: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2164: );
2165:
2166: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2167: x_return_status := l_return_status;
2168: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2169: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
2170: l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;
2171: l_context_info_rec.EVENT_CLASS_CODE := p_event_class_rec.EVENT_CLASS_CODE;
2172: l_context_info_rec.TRX_ID := p_event_class_rec.TRX_ID;

Line 2186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2182: END IF;
2183:
2184: EXCEPTION
2185: WHEN OTHERS THEN
2186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2187: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
2188: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
2189: 'Data is expected to be in eBTax repository for this call. Please CHECK your sequence of calls to eBTax '||
2190: SQLERRM);

Line 2223: x_return_status := FND_API.G_RET_STS_SUCCESS;

2219: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2220: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2221: END IF;
2222:
2223: x_return_status := FND_API.G_RET_STS_SUCCESS;
2224:
2225: SELECT record_flag
2226: INTO l_record_flag
2227: FROM ZX_EVNT_CLS_MAPPINGS

Line 2250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2246: RETURN l_record_flag;
2247:
2248: EXCEPTION
2249: WHEN OTHERS THEN
2250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2251: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
2252: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
2253: END IF;
2254: RETURN l_record_flag;

Line 2285: x_return_status := FND_API.G_RET_STS_SUCCESS;

2281: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2282: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2283: END IF;
2284:
2285: x_return_status := FND_API.G_RET_STS_SUCCESS;
2286: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
2287:
2288: /* ----------------------------------------------------------------------+
2289: | Initializing the tax regime dtl procedures |

Line 2302: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 2317: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2313: l_effective_date,
2314: l_return_status
2315: );
2316:
2317: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2318: x_return_status := l_return_status;
2319: RETURN;
2320: END IF;
2321:

Line 2330: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2326: l_effective_date,
2327: l_return_status
2328: );
2329:
2330: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2331: x_return_status := l_return_status;
2332: RETURN;
2333: END IF;
2334:

Line 2348: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2344: ,p_event_class_rec.tax_event_type_code
2345: ,p_event_class_rec.doc_status_code
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 2361: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2357: l_effective_date,
2358: p_event_class_rec
2359: );
2360:
2361: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2362: x_return_status := l_return_status;
2363: RETURN;
2364: END IF;
2365:

Line 2375: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2371: populate_appl_product_options(l_return_status,
2372: p_event_class_rec
2373: );
2374:
2375: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2376: x_return_status := l_return_status;
2377: RETURN;
2378: END IF;
2379:

Line 2398: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2394: p_trx_line_index => NULL,
2395: x_return_status => l_return_status
2396: );
2397:
2398: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2399: x_return_status := l_return_status;
2400: RETURN;
2401: END IF;
2402: END IF;

Line 2411: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2407: ZX_CHECK_REQUIRED_PARAMS_PKG.check_trx_headers_tbl(l_return_status,
2408: p_event_class_rec
2409: );
2410:
2411: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2412: x_return_status := l_return_status;
2413: RETURN;
2414: END IF;
2415:

Line 2419: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2415:
2416: ZX_CHECK_REQUIRED_PARAMS_PKG.check_trx_line_tbl(l_return_status,
2417: p_event_class_rec
2418: );
2419: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2420: x_return_status := l_return_status;
2421: RETURN;
2422: END IF;
2423: ELSIF ZX_API_PUB.G_DATA_TRANSFER_MODE = 'PLS' THEN

Line 2428: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2424: ZX_CHECK_REQUIRED_PARAMS_PKG.check_trx_lines(l_return_status,
2425: p_event_class_rec
2426: );
2427:
2428: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2429: x_return_status := l_return_status;
2430: RETURN;
2431: END IF;
2432: END IF;

Line 2558: x_return_status := FND_API.G_RET_STS_SUCCESS;

2554: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2555: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2556: END IF;
2557:
2558: x_return_status := FND_API.G_RET_STS_SUCCESS;
2559: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
2560:
2561: /* ----------------------------------------------------------------------+
2562: | Initializing the tax regime dtl procedures |

Line 2575: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2571: get_tax_event_class (l_return_status
2572: ,p_event_class_rec
2573: );
2574:
2575: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2576: x_return_status := l_return_status;
2577: RETURN;
2578: END IF;
2579:

Line 2592: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2588: populate_appl_product_options(l_return_status,
2589: p_event_class_rec
2590: );
2591:
2592: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2593: x_return_status := l_return_status;
2594: RETURN;
2595: END IF;
2596:

Line 2692: x_return_status := FND_API.G_RET_STS_SUCCESS;

2688: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2689: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2690: END IF;
2691:
2692: x_return_status := FND_API.G_RET_STS_SUCCESS;
2693: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
2694:
2695: /* ----------------------------------------------------------------------+
2696: | Get Tax Event Class |

Line 2702: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2698: get_tax_event_class (l_return_status
2699: ,p_event_class_rec
2700: );
2701:
2702: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2703: x_return_status := l_return_status;
2704: RETURN;
2705: END IF;
2706:

Line 2716: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2712: get_tax_subscriber(p_event_class_rec,
2713: l_return_status
2714: );
2715:
2716: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2717: x_return_status := l_return_status;
2718: RETURN;
2719: END IF;
2720:

Line 2737: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2733: ,p_event_class_rec.doc_status_code
2734: );
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 2750: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2746: ZX_CHECK_REQUIRED_PARAMS_PKG.check_trx_rec(l_return_status,
2747: p_trx_rec
2748: );
2749:
2750: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2751: x_return_status := l_return_status;
2752: RETURN;
2753: END IF;
2754:

Line 2764: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2760: l_effective_date,
2761: l_return_status
2762: );
2763:
2764: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2765: x_return_status := l_return_status;
2766: RETURN;
2767: END IF;
2768:

Line 2778: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2774: l_effective_date,
2775: p_event_class_rec
2776: );
2777:
2778: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2779: x_return_status := l_return_status;
2780: RETURN;
2781: END IF;
2782:

Line 2791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2787: /* ----------------------------------------------------------------------+
2788: | Override Flag |
2789: + ----------------------------------------------------------------------*/
2790: IF p_override is NULL THEN
2791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2792: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2793: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Override Level is required');
2794: END IF;
2795: RETURN;

Line 2901: x_return_status := FND_API.G_RET_STS_SUCCESS;

2897: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2898: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2899: END IF;
2900:
2901: x_return_status := FND_API.G_RET_STS_SUCCESS;
2902: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
2903:
2904: /*------------------------------------------------------+
2905: | Copy to Event Class Record |

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

2921: --get_tax_subscriber(p_event_class_rec,
2922: -- l_return_status
2923: -- );
2924:
2925: --IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2926: -- x_return_status := l_return_status;
2927: -- RETURN;
2928: --END IF;
2929:

Line 2946: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2942: p_event_class_rec.event_class_mapping_id, -- Bug 5200373
2943: p_event_class_rec.summarization_flag
2944: );
2945:
2946: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2947: x_return_status := l_return_status;
2948: RETURN;
2949: END IF;
2950:

Line 2964: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2960: p_event_class_rec.tax_event_type_code,
2961: p_event_class_rec.doc_status_code
2962: );
2963:
2964: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2965: x_return_status := l_return_status;
2966: RETURN;
2967: END IF;
2968:

Line 2976: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2972: ZX_CHECK_REQUIRED_PARAMS_PKG.check_trx_rec(l_return_status,
2973: p_trx_rec
2974: );
2975:
2976: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2977: x_return_status := l_return_status;
2978: RETURN;
2979: END IF;
2980:

Line 3019: x_return_status := FND_API.G_RET_STS_SUCCESS;

3015: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3016: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3017: END IF;
3018:
3019: x_return_status := FND_API.G_RET_STS_SUCCESS;
3020:
3021: /* ----------------------------------------------------------------------+
3022: | Bug 3129063 - Setting the Security Context for Subscription |
3023: + ----------------------------------------------------------------------*/

Line 3031: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3027: p_transaction_line_rec.trx_id,
3028: l_return_status
3029: );
3030:
3031: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3032: x_return_status := l_return_status;
3033: RETURN;
3034: END IF;
3035:

Line 3043: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3039: ZX_CHECK_REQUIRED_PARAMS_PKG.check_trx_line_rec(l_return_status
3040: ,p_transaction_line_rec
3041: );
3042:
3043: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3044: x_return_status := l_return_status;
3045: RETURN;
3046: END IF;
3047:

Line 3094: x_return_status := FND_API.G_RET_STS_SUCCESS;

3090: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3091: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3092: END IF;
3093:
3094: x_return_status := FND_API.G_RET_STS_SUCCESS;
3095: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
3096:
3097:
3098: /* ----------------------------------------------------------------------+

Line 3122: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3118: + ----------------------------------------------------------------------*/
3119:
3120: set_security_context(l_return_status,p_event_class_rec);
3121:
3122: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3123: x_return_status := l_return_status;
3124: RETURN;
3125: END IF;
3126:

Line 3140: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3136: p_event_class_rec.event_class_mapping_id, -- Bug 5200373
3137: p_event_class_rec.summarization_flag
3138: );
3139:
3140: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3141: x_return_status := l_return_status;
3142: RETURN;
3143: END IF;
3144:

Line 3197: x_return_status := FND_API.G_RET_STS_SUCCESS;

3193: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3194: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3195: END IF;
3196:
3197: x_return_status := FND_API.G_RET_STS_SUCCESS;
3198: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
3199:
3200: SELECT reversing_appln_id,
3201: reversing_entity_code,

Line 3221: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3217: l_trx_id,
3218: l_return_status
3219: );
3220:
3221: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3222: x_return_status := l_return_status;
3223: RETURN;
3224: END IF;
3225:

Line 3242: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3238: ,l_event_class_mapping_id -- Bug 5200373
3239: ,l_summarization_flag
3240: );
3241:
3242: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3243: x_return_status := l_return_status;
3244: RETURN;
3245: END IF;
3246:

Line 3285: x_return_status := FND_API.G_RET_STS_SUCCESS;

3281: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3282: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3283: END IF;
3284:
3285: x_return_status := FND_API.G_RET_STS_SUCCESS;
3286: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
3287:
3288: /* ----------------------------------------------------------------------+
3289: | Get Tax Event Class |

Line 3295: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3291: get_tax_event_class (l_return_status
3292: ,p_event_class_rec
3293: );
3294:
3295: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3296: x_return_status := l_return_status;
3297: RETURN;
3298: END IF;
3299:

Line 3347: x_return_status := FND_API.G_RET_STS_SUCCESS;

3343: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3344: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3345: END IF;
3346:
3347: x_return_status := FND_API.G_RET_STS_SUCCESS;
3348: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
3349:
3350: /*------------------------------------------------------+
3351: | Copy to Event Class Record |

Line 3367: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3363: get_tax_subscriber(p_event_class_rec,
3364: l_return_status
3365: );
3366:
3367: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3368: x_return_status := l_return_status;
3369: RETURN;
3370: END IF;
3371:

Line 3388: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3384: ,p_event_class_rec.event_class_mapping_id -- Bug 5200373
3385: ,p_event_class_rec.summarization_flag
3386: );
3387:
3388: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3389: x_return_status := l_return_status;
3390: RETURN;
3391: END IF;
3392:

Line 3406: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3402: ,p_trx_rec.tax_event_type_code
3403: ,p_trx_rec.doc_event_status
3404: );
3405:
3406: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3407: x_return_status := l_return_status;
3408: RETURN;
3409: END IF;
3410:

Line 3418: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3414: ZX_CHECK_REQUIRED_PARAMS_PKG.check_trx_rec(l_return_status,
3415: p_trx_rec
3416: );
3417:
3418: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3419: x_return_status := l_return_status;
3420: RETURN;
3421: END IF;
3422:

Line 3484: x_return_status := FND_API.G_RET_STS_SUCCESS;

3480: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3481: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3482: END IF;
3483:
3484: x_return_status := FND_API.G_RET_STS_SUCCESS;
3485: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
3486:
3487: /*------------------------------------------------------+
3488: | Copy to Event Class Record |

Line 3504: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3500: get_tax_subscriber(p_event_class_rec,
3501: l_return_status
3502: );
3503:
3504: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3505: x_return_status := l_return_status;
3506: RETURN;
3507: END IF;
3508:

Line 3516: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3512: get_tax_event_class (l_return_status
3513: ,p_event_class_rec
3514: );
3515:
3516: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3517: x_return_status := l_return_status;
3518: RETURN;
3519: END IF;
3520:

Line 3536: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3532: ,p_trx_rec.tax_event_type_code
3533: ,p_trx_rec.doc_event_status
3534: );
3535:
3536: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3537: x_return_status := l_return_status;
3538: RETURN;
3539: END IF;
3540:

Line 3548: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3544: ZX_CHECK_REQUIRED_PARAMS_PKG.check_trx_rec(l_return_status,
3545: p_trx_rec
3546: );
3547:
3548: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3549: x_return_status := l_return_status;
3550: RETURN;
3551: END IF;
3552:

Line 3598: x_return_status := FND_API.G_RET_STS_SUCCESS;

3594: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3595: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3596: END IF;
3597:
3598: x_return_status := FND_API.G_RET_STS_SUCCESS;
3599: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
3600:
3601: /*------------------------------------------------------+
3602: | Copy to Event Class Record |

Line 3639: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3635: get_tax_subscriber(p_event_class_rec,
3636: l_return_status
3637: );
3638:
3639: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3640: x_return_status := l_return_status;
3641: RETURN;
3642: END IF;
3643:

Line 3660: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3656: ,p_event_class_rec.event_class_mapping_id -- Bug 5200373
3657: ,p_event_class_rec.summarization_flag
3658: );
3659:
3660: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3661: x_return_status := l_return_status;
3662: RETURN;
3663: END IF;
3664:

Line 3679: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3675: ,p_trx_rec.tax_event_type_code
3676: ,p_trx_rec.doc_event_status
3677: );
3678:
3679: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3680: x_return_status := l_return_status;
3681: RETURN;
3682: END IF;
3683:

Line 3696: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3692: l_effective_date,
3693: l_return_status
3694: );
3695:
3696: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3697: x_return_status := l_return_status;
3698: RETURN;
3699: END IF;
3700:

Line 3709: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3705: l_effective_date,
3706: p_event_class_rec
3707: );
3708:
3709: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3710: x_return_status := l_return_status;
3711: RETURN;
3712: END IF;
3713:

Line 3721: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3717: ZX_CHECK_REQUIRED_PARAMS_PKG.check_trx_rec(l_return_status,
3718: p_trx_rec
3719: );
3720:
3721: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3722: x_return_status := l_return_status;
3723: RETURN;
3724: END IF;
3725:

Line 3846: x_return_status := FND_API.G_RET_STS_SUCCESS;

3842: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3843: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3844: END IF;
3845:
3846: x_return_status := FND_API.G_RET_STS_SUCCESS;
3847:
3848: /* ----------------------------------------------------------------------+
3849: | Bug 3129063 - Setting the Security Context for Subscription |
3850: + ----------------------------------------------------------------------*/

Line 3858: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3854: p_trx_rec.trx_id,
3855: l_return_status
3856: );
3857:
3858: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3859: x_return_status := l_return_status;
3860: RETURN;
3861: END IF;
3862:

Line 3871: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3867: ZX_CHECK_REQUIRED_PARAMS_PKG.check_trx_rec(l_return_status,
3868: p_trx_rec
3869: );
3870:
3871: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3872: x_return_status := l_return_status;
3873: RETURN;
3874: END IF;
3875:

Line 3922: x_return_status := FND_API.G_RET_STS_SUCCESS;

3918: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3919: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3920: END IF;
3921:
3922: x_return_status := FND_API.G_RET_STS_SUCCESS;
3923: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
3924:
3925: /* ----------------------------------------------------------------------+
3926: | Get Tax Event Class |

Line 3932: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 3945: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3941: l_effective_date,
3942: l_return_status
3943: );
3944:
3945: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3946: x_return_status := l_return_status;
3947: RETURN;
3948: END IF;
3949:

Line 3960: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3956: l_effective_date ,
3957: l_return_status
3958: );
3959:
3960: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3961: x_return_status := l_return_status;
3962: RETURN;
3963: END IF;
3964:

Line 3978: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3974: ,p_event_class_rec.tax_event_type_code
3975: ,p_event_class_rec.doc_status_code
3976: );
3977:
3978: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3979: x_return_status := l_return_status;
3980: RETURN;
3981: END IF;
3982:

Line 3993: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3989: p_trx_line_index => p_trx_line_index,
3990: x_return_status => l_return_status
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:

Line 4007: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 4020: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4016: ZX_CHECK_REQUIRED_PARAMS_PKG.check_trx_lines(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: END IF; --G_PUB_SRVC <> 'COPY_INSERT_LINE_DET_FACTORS'

Line 4035: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4031: l_effective_date,
4032: p_event_class_rec
4033: );
4034:
4035: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4036: x_return_status := l_return_status;
4037: RETURN;
4038: END IF;
4039:

Line 4047: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4043: populate_appl_product_options(l_return_status,
4044: p_event_class_rec
4045: );
4046:
4047: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4048: x_return_status := l_return_status;
4049: RETURN;
4050: END IF;
4051:

Line 4179: x_return_status := FND_API.G_RET_STS_SUCCESS;

4175: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4176: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
4177: END IF;
4178:
4179: x_return_status := FND_API.G_RET_STS_SUCCESS;
4180: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;
4181:
4182: /* ----------------------------------------------------------------------+
4183: | Get Tax Event Class |

Line 4189: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4185: get_tax_event_class (l_return_status
4186: ,p_event_class_rec
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 4202: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4198: l_effective_date,
4199: l_return_status
4200: );
4201:
4202: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4203: x_return_status := l_return_status;
4204: RETURN;
4205: END IF;
4206:

Line 4216: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4212: l_effective_date ,
4213: l_return_status
4214: );
4215:
4216: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4217: x_return_status := l_return_status;
4218: RETURN;
4219: END IF;
4220:

Line 4234: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4230: ,p_event_class_rec.tax_event_type_code
4231: ,p_event_class_rec.doc_status_code
4232: );
4233:
4234: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4235: x_return_status := l_return_status;
4236: RETURN;
4237: END IF;
4238:

Line 4247: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4243: l_effective_date,
4244: p_event_class_rec
4245: );
4246:
4247: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4248: x_return_status := l_return_status;
4249: RETURN;
4250: END IF;
4251:

Line 4262: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4258:
4259: -- populate global event class record structure
4260: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := p_event_class_rec;
4261:
4262: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4263: x_return_status := l_return_status;
4264: RETURN;
4265: END IF;
4266:

Line 4454: x_return_status := FND_API.G_RET_STS_SUCCESS;

4450: l_index binary_integer;
4451:
4452: BEGIN
4453:
4454: x_return_status := FND_API.G_RET_STS_SUCCESS;
4455:
4456: l_index := dbms_utility.get_hash_value(to_char(p_application_id)||p_entity_code||p_event_class_code,1,8192);
4457:
4458: IF ZX_GLOBAL_STRUCTURES_PKG.g_zx_event_class_rec_tbl.EXISTS(l_index) then

Line 4605: x_return_status := FND_API.G_RET_STS_SUCCESS;

4601: l_index binary_integer;
4602:
4603: BEGIN
4604:
4605: x_return_status := FND_API.G_RET_STS_SUCCESS;
4606:
4607: l_index := dbms_utility.get_hash_value(to_char(p_application_id)||p_entity_code||p_event_class_code
4608: ||p_event_type_Code,1,8192);
4609: