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 182: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

178: -- p_event_class_rec => p_event_class_rec,
179: x_return_status => p_return_status,
180: x_error_buffer => p_error_buffer);
181:
182: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
183: IF g_level_unexpected >= g_current_runtime_level THEN
184: FND_LOG.STRING(g_level_unexpected,
185: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
186: 'Incorrect return_status after calling adjust_overapplication()');

Line 208: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

204: p_event_class_rec,
205: p_return_status,
206: p_error_buffer);
207:
208: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
209: RETURN;
210: END IF;
211: END IF;
212:

Line 225: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

221: p_event_class_rec,
222: p_return_status,
223: p_error_buffer);
224:
225: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
226: RETURN;
227: END IF;
228: END IF;
229:

Line 237: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

233: p_event_class_rec,
234: p_return_status,
235: p_error_buffer);
236:
237: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
238: RETURN;
239: END IF;
240:
241: --

Line 261: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

257: p_event_class_rec,
258: p_return_status,
259: p_error_buffer);
260:
261: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
262: RETURN;
263: END IF;
264: END IF;
265:

Line 271: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 280: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

276: p_event_class_rec,
277: p_return_status,
278: p_error_buffer);
279:
280: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
281: RETURN;
282: END IF;
283:
284: -- bug 3770874: call process_discard_tax_lines conditionally

Line 296: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

292: p_event_class_rec,
293: p_return_status,
294: p_error_buffer);
295:
296: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
297: IF g_level_unexpected >= g_current_runtime_level THEN
298: FND_LOG.STRING(g_level_unexpected,
299: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
300: 'Incorrect return_status after calling '||

Line 330: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

326: x_return_status => p_return_status,
327: x_error_buffer => p_error_buffer
328: );
329: END IF;
330: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
331: IF g_level_unexpected >= g_current_runtime_level THEN
332: FND_LOG.STRING(g_level_unexpected,
333: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
334: 'Incorrect return_status after calling '||

Line 361: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

357: p_event_class_rec,
358: p_return_status,
359: p_error_buffer);
360:
361: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
362: RETURN;
363: END IF;
364:
365: END IF;

Line 376: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

372: END IF;
373:
374: EXCEPTION
375: WHEN OTHERS THEN
376: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
377: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
378: IF (g_level_unexpected >= g_current_runtime_level ) THEN
379: FND_LOG.STRING(g_level_unexpected,
380: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.determine_tax_lines',

Line 769: p_return_status := FND_API.G_RET_STS_SUCCESS;

765: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.create_offset_tax_lines.BEGIN',
766: 'ZX_TDS_TAX_LINES_DETM_PKG: create_offset_tax_lines(+)');
767: END IF;
768:
769: p_return_status := FND_API.G_RET_STS_SUCCESS;
770:
771: --
772: -- init index to offset tax lines structure
773: --

Line 1118: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1114: p_event_class_rec,
1115: p_return_status,
1116: p_error_buffer);
1117:
1118: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1119: EXIT;
1120: ELSE
1121: i := i + 1;
1122: l_offset_tax_line_tbl(i) := l_tax_line_rec;

Line 1133: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1129: EXIT;
1130: END IF; -- end of get_tax_line_csr%FOUND
1131: END LOOP;
1132:
1133: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1134: CLOSE get_tax_line_csr;
1135: RETURN;
1136: END IF;
1137:

Line 1156: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1152: END IF;
1153:
1154: EXCEPTION
1155: WHEN OTHERS THEN
1156: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1157: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1158: IF get_tax_line_csr%ISOPEN THEN
1159: CLOSE get_tax_line_csr;
1160: END IF;

Line 1240: x_return_status := FND_API.G_RET_STS_SUCCESS;

1236: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.populate_tax_line_numbers.BEGIN',
1237: 'ZX_TDS_TAX_LINES_DETM_PKG: populate_tax_line_numbers(+)');
1238: END IF;
1239:
1240: x_return_status := FND_API.G_RET_STS_SUCCESS;
1241:
1242: l_old_application_id := -1;
1243: l_old_event_class_code := '@@@###$$$***';
1244: l_old_entity_code := '@@@###$$$***';

Line 1333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1329: END IF;
1330:
1331: EXCEPTION
1332: WHEN OTHERS THEN
1333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1334: x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1335: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1336: FND_LOG.STRING(g_level_unexpected,
1337: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.populate_tax_line_numbers',

Line 1432: x_return_status := FND_API.G_RET_STS_SUCCESS;

1428: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.BEGIN',
1429: 'ZX_TDS_TAX_LINES_DETM_PKG: process_reference_tax_lines(+)');
1430: END IF;
1431:
1432: x_return_status := FND_API.G_RET_STS_SUCCESS;
1433:
1434: -- Bug#5417753- determine tax_class value
1435: IF p_event_class_rec.prod_family_grp_code = 'O2C' THEN
1436: l_tax_class := 'OUTPUT';

Line 2081: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2077: l_tax_regime_rec,
2078: x_return_status,
2079: x_error_buffer);
2080:
2081: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2082: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2083: FND_LOG.STRING(g_level_unexpected,
2084: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2085: 'Incorrect return_status after calling ' ||

Line 2109: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2105: l_tax_rec,
2106: x_return_status,
2107: x_error_buffer);
2108:
2109: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2110: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2111: FND_LOG.STRING(g_level_unexpected,
2112: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2113: 'Incorrect return_status after calling ' ||

Line 2137: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2133: l_tax_jurisdiction_rec,
2134: x_return_status,
2135: x_error_buffer);
2136:
2137: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2138: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2139: FND_LOG.STRING(g_level_unexpected,
2140: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2141: 'Incorrect return_status after calling ' ||

Line 2168: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2164: l_tax_status_rec,
2165: x_return_status,
2166: x_error_buffer);
2167:
2168: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2169: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2170: FND_LOG.STRING(g_level_unexpected,
2171: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2172: 'Incorrect return_status after calling ' ||

Line 2200: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2196: l_tax_rate_rec,
2197: x_return_status,
2198: x_error_buffer);
2199:
2200: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2201: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2202: FND_LOG.STRING(g_level_unexpected,
2203: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2204: 'Incorrect return_status after calling ' ||

Line 2244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2240: END IF;
2241:
2242: EXCEPTION
2243: WHEN OTHERS THEN
2244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2245: x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2246: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2247: FND_LOG.STRING(g_level_unexpected,
2248: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',

Line 2342: x_return_status := FND_API.G_RET_STS_SUCCESS;

2338: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.BEGIN',
2339: 'ZX_TDS_TAX_LINES_DETM_PKG: process_copy_and_create(+)');
2340: END IF;
2341:
2342: x_return_status := FND_API.G_RET_STS_SUCCESS;
2343:
2344:
2345: l_user_id := fnd_global.user_id;
2346: l_login_id := fnd_global.login_id;

Line 3377: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3373: l_tax_regime_rec,
3374: x_return_status,
3375: x_error_buffer);
3376:
3377: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3378: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3379: FND_LOG.STRING(g_level_unexpected,
3380: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3381: 'Incorrect return_status after calling ' ||

Line 3405: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3401: l_tax_rec,
3402: x_return_status,
3403: x_error_buffer);
3404:
3405: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3406: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3407: FND_LOG.STRING(g_level_unexpected,
3408: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3409: 'Incorrect return_status after calling ' ||

Line 3433: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3429: l_tax_jurisdiction_rec,
3430: x_return_status,
3431: x_error_buffer);
3432:
3433: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3434: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3435: FND_LOG.STRING(g_level_unexpected,
3436: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3437: 'Incorrect return_status after calling ' ||

Line 3467: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3463: l_tax_status_rec,
3464: x_return_status,
3465: x_error_buffer);
3466:
3467: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3468: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3469: FND_LOG.STRING(g_level_unexpected,
3470: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3471: 'Incorrect return_status after calling ' ||

Line 3499: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3495: l_tax_rate_rec,
3496: x_return_status,
3497: x_error_buffer);
3498:
3499: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3500: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3501: FND_LOG.STRING(g_level_unexpected,
3502: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3503: 'Incorrect return_status after calling ' ||

Line 3547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3543: END IF;
3544:
3545: EXCEPTION
3546: WHEN OTHERS THEN
3547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3548: x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3549: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3550: FND_LOG.STRING(g_level_unexpected,
3551: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

Line 3663: x_return_status := FND_API.G_RET_STS_SUCCESS;

3659: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.adjust_overapplication.BEGIN',
3660: 'ZX_TDS_TAX_LINES_DETM_PKG: adjust_overapplication(+)');
3661: END IF;
3662:
3663: x_return_status := FND_API.G_RET_STS_SUCCESS;
3664:
3665: -- if it is a historical trx, do nothing
3666: --IF p_event_class_rec.CTRL_TOTAL_HDR_TX_AMT IS NOT NULL
3667: -- OR p_event_class_rec.CTRL_TOTAL_LINE_TX_AMT_FLG = 'Y'

Line 3741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3737: END IF;
3738:
3739: EXCEPTION
3740: WHEN OTHERS THEN
3741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3742: x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3743:
3744: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3745: FND_LOG.STRING(g_level_unexpected,

Line 3834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3830: END IF;
3831:
3832: EXCEPTION
3833: WHEN OTHERS THEN
3834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3835: x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3836:
3837: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3838: FND_LOG.STRING(g_level_unexpected,

Line 3911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3907: END IF;
3908:
3909: EXCEPTION
3910: WHEN OTHERS THEN
3911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3912: x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3913:
3914: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3915: FND_LOG.STRING(g_level_unexpected,