DBA Data[Home] [Help]

APPS.ZX_TDS_TAX_LINES_DETM_PKG dependencies on FND_API

Line 77: p_return_status := FND_API.G_RET_STS_SUCCESS;

73:
74: --
75: -- init error buffer and return status
76: --
77: p_return_status := FND_API.G_RET_STS_SUCCESS;
78: p_error_buffer := NULL;
79:
80: -- Bug 3971006: copy manual tax line from source document for trx lines
81: -- with line_level_action = 'COPY_AND_CREATE'

Line 91: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

87: p_event_class_rec => p_event_class_rec,
88: x_return_status => p_return_status,
89: x_error_buffer => p_error_buffer);
90:
91: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
92: IF g_level_unexpected >= g_current_runtime_level THEN
93: FND_LOG.STRING(g_level_unexpected,
94: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
95: 'Incorrect return_status after calling process_copy_and_create()');

Line 116: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

112: p_event_class_rec => p_event_class_rec,
113: x_return_status => p_return_status,
114: x_error_buffer => p_error_buffer);
115:
116: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
117: IF g_level_unexpected >= g_current_runtime_level THEN
118: FND_LOG.STRING(g_level_unexpected,
119: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
120: 'Incorrect return_status after calling '||

Line 142: -- IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

138: -- ZX_TDS_MRC_PROCESSING_PKG.create_mrc_det_tax_lines(
139: -- p_event_class_rec => p_event_class_rec,
140: -- x_return_status => p_return_status);
141: --
142: -- IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
143: -- IF g_level_unexpected >= g_current_runtime_level THEN
144: -- FND_LOG.STRING(g_level_unexpected,
145: -- 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
146: -- 'Incorrect return_status after calling '||

Line 167: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

163: p_event_class_rec,
164: p_return_status,
165: p_error_buffer);
166:
167: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
168: RETURN;
169: END IF;
170:
171: --

Line 189: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

185: -- p_event_class_rec => p_event_class_rec,
186: x_return_status => p_return_status,
187: x_error_buffer => p_error_buffer);
188:
189: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
190: IF g_level_unexpected >= g_current_runtime_level THEN
191: FND_LOG.STRING(g_level_unexpected,
192: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
193: 'Incorrect return_status after calling adjust_overapplication()');

Line 215: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

211: p_event_class_rec,
212: p_return_status,
213: p_error_buffer);
214:
215: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
216: RETURN;
217: END IF;
218: END IF;
219:

Line 232: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

228: p_event_class_rec,
229: p_return_status,
230: p_error_buffer);
231:
232: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
233: RETURN;
234: END IF;
235: END IF;
236:

Line 244: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

240: p_event_class_rec,
241: p_return_status,
242: p_error_buffer);
243:
244: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
245: RETURN;
246: END IF;
247:
248: --

Line 272: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

268: p_event_class_rec,
269: p_return_status,
270: p_error_buffer);
271:
272: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
273: RETURN;
274: END IF;
275: END IF;
276:

Line 282: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

278: p_event_class_rec,
279: p_return_status,
280: p_error_buffer);
281:
282: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
283: RETURN;
284: END IF;
285:
286: ZX_TDS_TAX_LINES_POPU_PKG.process_frozen_tax_lines(

Line 291: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

287: p_event_class_rec,
288: p_return_status,
289: p_error_buffer);
290:
291: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
292: RETURN;
293: END IF;
294:
295: -- bug 3770874: call process_discard_tax_lines conditionally

Line 307: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

303: p_event_class_rec,
304: p_return_status,
305: p_error_buffer);
306:
307: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
308: IF g_level_unexpected >= g_current_runtime_level THEN
309: FND_LOG.STRING(g_level_unexpected,
310: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
311: 'Incorrect return_status after calling '||

Line 341: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

337: x_return_status => p_return_status,
338: x_error_buffer => p_error_buffer
339: );
340: END IF;
341: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
342: IF g_level_unexpected >= g_current_runtime_level THEN
343: FND_LOG.STRING(g_level_unexpected,
344: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
345: 'Incorrect return_status after calling '||

Line 372: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

368: p_event_class_rec,
369: p_return_status,
370: p_error_buffer);
371:
372: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
373: RETURN;
374: END IF;
375:
376: END IF;

Line 387: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

383: END IF;
384:
385: EXCEPTION
386: WHEN OTHERS THEN
387: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
388: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
389: IF (g_level_unexpected >= g_current_runtime_level ) THEN
390: FND_LOG.STRING(g_level_unexpected,
391: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.determine_tax_lines',

Line 785: p_return_status := FND_API.G_RET_STS_SUCCESS;

781: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.create_offset_tax_lines.BEGIN',
782: 'ZX_TDS_TAX_LINES_DETM_PKG: create_offset_tax_lines(+)');
783: END IF;
784:
785: p_return_status := FND_API.G_RET_STS_SUCCESS;
786:
787: --
788: -- init index to offset tax lines structure
789: --

Line 1133: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1129: p_event_class_rec,
1130: p_return_status,
1131: p_error_buffer);
1132:
1133: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1134: EXIT;
1135: ELSE
1136: i := i + 1;
1137: l_offset_tax_line_tbl(i) := l_tax_line_rec;

Line 1161: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1157: EXIT;
1158: END IF; -- end of get_tax_line_csr%FOUND
1159: END LOOP;
1160:
1161: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1162: CLOSE get_tax_line_csr;
1163: RETURN;
1164: END IF;
1165:

Line 1184: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1180: END IF;
1181:
1182: EXCEPTION
1183: WHEN OTHERS THEN
1184: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1185: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1186: IF get_tax_line_csr%ISOPEN THEN
1187: CLOSE get_tax_line_csr;
1188: END IF;

Line 1268: x_return_status := FND_API.G_RET_STS_SUCCESS;

1264: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.populate_tax_line_numbers.BEGIN',
1265: 'ZX_TDS_TAX_LINES_DETM_PKG: populate_tax_line_numbers(+)');
1266: END IF;
1267:
1268: x_return_status := FND_API.G_RET_STS_SUCCESS;
1269:
1270: l_old_application_id := -1;
1271: l_old_event_class_code := '@@@###$$$***';
1272: l_old_entity_code := '@@@###$$$***';

Line 1361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1357: END IF;
1358:
1359: EXCEPTION
1360: WHEN OTHERS THEN
1361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1362: x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1363: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1364: FND_LOG.STRING(g_level_unexpected,
1365: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.populate_tax_line_numbers',

Line 1460: x_return_status := FND_API.G_RET_STS_SUCCESS;

1456: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.BEGIN',
1457: 'ZX_TDS_TAX_LINES_DETM_PKG: process_reference_tax_lines(+)');
1458: END IF;
1459:
1460: x_return_status := FND_API.G_RET_STS_SUCCESS;
1461:
1462: -- Bug#5417753- determine tax_class value
1463: IF p_event_class_rec.prod_family_grp_code = 'O2C' THEN
1464: l_tax_class := 'OUTPUT';

Line 2694: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2690: l_tax_regime_rec,
2691: x_return_status,
2692: x_error_buffer);
2693:
2694: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2695: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2696: FND_LOG.STRING(g_level_unexpected,
2697: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2698: 'Incorrect return_status after calling ' ||

Line 2722: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2718: l_tax_rec,
2719: x_return_status,
2720: x_error_buffer);
2721:
2722: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2723: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2724: FND_LOG.STRING(g_level_unexpected,
2725: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2726: 'Incorrect return_status after calling ' ||

Line 2750: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2746: l_tax_jurisdiction_rec,
2747: x_return_status,
2748: x_error_buffer);
2749:
2750: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2751: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2752: FND_LOG.STRING(g_level_unexpected,
2753: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2754: 'Incorrect return_status after calling ' ||

Line 2781: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2777: l_tax_status_rec,
2778: x_return_status,
2779: x_error_buffer);
2780:
2781: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2782: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2783: FND_LOG.STRING(g_level_unexpected,
2784: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2785: 'Incorrect return_status after calling ' ||

Line 2813: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2809: l_tax_rate_rec,
2810: x_return_status,
2811: x_error_buffer);
2812:
2813: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2814: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2815: FND_LOG.STRING(g_level_unexpected,
2816: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2817: 'Incorrect return_status after calling ' ||

Line 2857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2853: END IF;
2854:
2855: EXCEPTION
2856: WHEN OTHERS THEN
2857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2858: x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2859: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2860: FND_LOG.STRING(g_level_unexpected,
2861: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',

Line 2955: x_return_status := FND_API.G_RET_STS_SUCCESS;

2951: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.BEGIN',
2952: 'ZX_TDS_TAX_LINES_DETM_PKG: process_copy_and_create(+)');
2953: END IF;
2954:
2955: x_return_status := FND_API.G_RET_STS_SUCCESS;
2956:
2957:
2958: l_user_id := fnd_global.user_id;
2959: l_login_id := fnd_global.login_id;

Line 3992: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3988: l_tax_regime_rec,
3989: x_return_status,
3990: x_error_buffer);
3991:
3992: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3993: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3994: FND_LOG.STRING(g_level_unexpected,
3995: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3996: 'Incorrect return_status after calling ' ||

Line 4020: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4016: l_tax_rec,
4017: x_return_status,
4018: x_error_buffer);
4019:
4020: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4021: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4022: FND_LOG.STRING(g_level_unexpected,
4023: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4024: 'Incorrect return_status after calling ' ||

Line 4048: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4044: l_tax_jurisdiction_rec,
4045: x_return_status,
4046: x_error_buffer);
4047:
4048: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4049: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4050: FND_LOG.STRING(g_level_unexpected,
4051: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4052: 'Incorrect return_status after calling ' ||

Line 4082: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4078: l_tax_status_rec,
4079: x_return_status,
4080: x_error_buffer);
4081:
4082: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4083: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4084: FND_LOG.STRING(g_level_unexpected,
4085: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4086: 'Incorrect return_status after calling ' ||

Line 4114: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4110: l_tax_rate_rec,
4111: x_return_status,
4112: x_error_buffer);
4113:
4114: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4115: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4116: FND_LOG.STRING(g_level_unexpected,
4117: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4118: 'Incorrect return_status after calling ' ||

Line 4162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4158: END IF;
4159:
4160: EXCEPTION
4161: WHEN OTHERS THEN
4162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4163: x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4164: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4165: FND_LOG.STRING(g_level_unexpected,
4166: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

Line 4306: x_return_status := FND_API.G_RET_STS_SUCCESS;

4302: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.adjust_overapplication.BEGIN',
4303: 'ZX_TDS_TAX_LINES_DETM_PKG: adjust_overapplication(+)');
4304: END IF;
4305:
4306: x_return_status := FND_API.G_RET_STS_SUCCESS;
4307:
4308: -- if it is a historical trx, do nothing
4309: --IF p_event_class_rec.CTRL_TOTAL_HDR_TX_AMT IS NOT NULL
4310: -- OR p_event_class_rec.CTRL_TOTAL_LINE_TX_AMT_FLG = 'Y'

Line 4396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4392: END IF;
4393:
4394: EXCEPTION
4395: WHEN OTHERS THEN
4396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4397: x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4398:
4399: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4400: FND_LOG.STRING(g_level_unexpected,

Line 4489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4485: END IF;
4486:
4487: EXCEPTION
4488: WHEN OTHERS THEN
4489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4490: x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4491:
4492: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4493: FND_LOG.STRING(g_level_unexpected,

Line 4566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4562: END IF;
4563:
4564: EXCEPTION
4565: WHEN OTHERS THEN
4566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4567: x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4568:
4569: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4570: FND_LOG.STRING(g_level_unexpected,