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_VALIDATE_API_PKG dependencies on ZX_VALIDATE_API_PKG

Line 1: PACKAGE BODY ZX_VALIDATE_API_PKG AS

1: PACKAGE BODY ZX_VALIDATE_API_PKG AS
2: /* $Header: zxapdefvalpkgb.pls 120.110.12020000.4 2013/01/22 06:43:09 satprasa ship $ */
3:
4: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
5: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;

Line 167: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

163: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
164:
165: IF (g_level_procedure >= g_current_runtime_level ) THEN
166: FND_LOG.STRING(g_level_procedure,
167: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
168: 'ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR(+)');
169: END IF;
170:
171: SELECT count(1),

Line 168: 'ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR(+)');

164:
165: IF (g_level_procedure >= g_current_runtime_level ) THEN
166: FND_LOG.STRING(g_level_procedure,
167: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
168: 'ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR(+)');
169: END IF;
170:
171: SELECT count(1),
172: Sum(Decode(tax_regime_code||tax, NULL, 0, 1)),

Line 192: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

188:
189: SELECT count(1) INTO l_count_header FROM zx_trx_headers_gt;
190: SELECT count(1) INTO l_count_lines FROM zx_transaction_lines_gt;
191:
192: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
193: 'Count of ZX_TRX_HEADERS_GT : '||to_char(l_count_header));
194: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
195: 'Count of ZX_TRANSACTION_LINES_GT : '||to_char(l_count_lines));
196: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 194: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

190: SELECT count(1) INTO l_count_lines FROM zx_transaction_lines_gt;
191:
192: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
193: 'Count of ZX_TRX_HEADERS_GT : '||to_char(l_count_header));
194: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
195: 'Count of ZX_TRANSACTION_LINES_GT : '||to_char(l_count_lines));
196: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
197: 'Count of ZX_IMPORT_TAX_LINES_GT - Total Tax Lines : '||to_char(l_count_tax_lines));
198: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 196: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

192: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
193: 'Count of ZX_TRX_HEADERS_GT : '||to_char(l_count_header));
194: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
195: 'Count of ZX_TRANSACTION_LINES_GT : '||to_char(l_count_lines));
196: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
197: 'Count of ZX_IMPORT_TAX_LINES_GT - Total Tax Lines : '||to_char(l_count_tax_lines));
198: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
199: 'Count of ZX_IMPORT_TAX_LINES_GT - Tax Lines with Regime and Tax : '||to_char(l_count_reg_null));
200: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 198: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

194: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
195: 'Count of ZX_TRANSACTION_LINES_GT : '||to_char(l_count_lines));
196: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
197: 'Count of ZX_IMPORT_TAX_LINES_GT - Total Tax Lines : '||to_char(l_count_tax_lines));
198: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
199: 'Count of ZX_IMPORT_TAX_LINES_GT - Tax Lines with Regime and Tax : '||to_char(l_count_reg_null));
200: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
201: 'Count of ZX_IMPORT_TAX_LINES_GT - Tax Lines with Tax Status Code : '||to_char(l_count_status_null));
202: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 200: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

196: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
197: 'Count of ZX_IMPORT_TAX_LINES_GT - Total Tax Lines : '||to_char(l_count_tax_lines));
198: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
199: 'Count of ZX_IMPORT_TAX_LINES_GT - Tax Lines with Regime and Tax : '||to_char(l_count_reg_null));
200: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
201: 'Count of ZX_IMPORT_TAX_LINES_GT - Tax Lines with Tax Status Code : '||to_char(l_count_status_null));
202: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
203: 'Count of ZX_IMPORT_TAX_LINES_GT - Tax Lines with Tax Jurisdiction : '||to_char(l_count_jur_null));
204: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 202: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

198: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
199: 'Count of ZX_IMPORT_TAX_LINES_GT - Tax Lines with Regime and Tax : '||to_char(l_count_reg_null));
200: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
201: 'Count of ZX_IMPORT_TAX_LINES_GT - Tax Lines with Tax Status Code : '||to_char(l_count_status_null));
202: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
203: 'Count of ZX_IMPORT_TAX_LINES_GT - Tax Lines with Tax Jurisdiction : '||to_char(l_count_jur_null));
204: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
205: 'Count of ZX_IMPORT_TAX_LINES_GT - Tax Lines with Tax Provider ID : '||to_char(l_count_pvr_null));
206: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 204: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

200: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
201: 'Count of ZX_IMPORT_TAX_LINES_GT - Tax Lines with Tax Status Code : '||to_char(l_count_status_null));
202: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
203: 'Count of ZX_IMPORT_TAX_LINES_GT - Tax Lines with Tax Jurisdiction : '||to_char(l_count_jur_null));
204: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
205: 'Count of ZX_IMPORT_TAX_LINES_GT - Tax Lines with Tax Provider ID : '||to_char(l_count_pvr_null));
206: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
207: 'Count of ZX_IMPORT_TAX_LINES_GT - Tax Lines with Tax Rate ID : '||to_char(l_count_rate_id_null));
208: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 206: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

202: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
203: 'Count of ZX_IMPORT_TAX_LINES_GT - Tax Lines with Tax Jurisdiction : '||to_char(l_count_jur_null));
204: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
205: 'Count of ZX_IMPORT_TAX_LINES_GT - Tax Lines with Tax Provider ID : '||to_char(l_count_pvr_null));
206: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
207: 'Count of ZX_IMPORT_TAX_LINES_GT - Tax Lines with Tax Rate ID : '||to_char(l_count_rate_id_null));
208: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
209: 'Count of ZX_TRX_TAX_LINK_GT : '||to_char(l_count_link_gt));
210: END IF;

Line 208: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

204: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
205: 'Count of ZX_IMPORT_TAX_LINES_GT - Tax Lines with Tax Provider ID : '||to_char(l_count_pvr_null));
206: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
207: 'Count of ZX_IMPORT_TAX_LINES_GT - Tax Lines with Tax Rate ID : '||to_char(l_count_rate_id_null));
208: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
209: 'Count of ZX_TRX_TAX_LINK_GT : '||to_char(l_count_link_gt));
210: END IF;
211:
212: ---------------------------------------------------------------------------------

Line 229: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

225: EXCEPTION
226: WHEN NO_DATA_FOUND THEN
227: IF (g_level_exception >= g_current_runtime_level ) THEN
228: FND_LOG.STRING(g_level_exception,
229: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
230: 'First Party Org Id : Not able to fetch OU and LE, Error : '||
231: sqlerrm);
232: END IF;
233: app_exception.raise_exception;

Line 237: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

233: app_exception.raise_exception;
234: END;
235:
236: IF ( g_level_statement >= g_current_runtime_level) THEN
237: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
238: 'Call ZX_TCM_PTP_PKG.GET_TAX_SUBSCRIBER() with OU: '||to_char(l_ou_id)||' and LE: '||to_char(l_le_id));
239: END IF;
240:
241: ZX_TCM_PTP_PKG.GET_TAX_SUBSCRIBER(l_le_id,

Line 247: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

243: g_first_pty_org_id,
244: l_return_status);
245:
246: IF ( g_level_statement >= g_current_runtime_level) THEN
247: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
248: 'G_FIRST_PTY_ORG_ID: '||to_char(g_first_pty_org_id));
249: END IF;
250:
251: -- Need to verify if we need to raise a UNEXPECTED error if we fail to set first party

Line 258: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR:

254:
255: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
256: IF (g_level_exception >= g_current_runtime_level ) THEN
257: FND_LOG.STRING(g_level_exception,
258: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR:
259: Get Tax Subscriber : Returned Error Status',
260: sqlerrm);
261: END IF;
262: -- RETURN;

Line 270: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

266: -- End logic for getting the first party org id
267: ------------------------------------------------------------------------------------
268:
269: IF ( g_level_event >= g_current_runtime_level) THEN
270: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
271: 'Validating Other Documents');
272: END IF;
273:
274: Validate_Other_Documents(x_return_status);

Line 277: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

273:
274: Validate_Other_Documents(x_return_status);
275:
276: IF ( g_level_event >= g_current_runtime_level) THEN
277: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
278: 'Executing On the Fly Migration If Needed');
279: END IF;
280:
281: zx_on_fly_trx_upgrade_pkg.upgrade_trx_on_fly_blk(x_return_status);

Line 297: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

293: );
294:
295: --Bug # 4917256
296: IF ( g_level_event >= g_current_runtime_level) THEN
297: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
298: 'Before Defaulting, Validate either tax_rate_id or tax_rate_code is passed');
299: END IF;
300:
301: INSERT INTO ZX_VALIDATION_ERRORS_GT

Line 343: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

339: AND exists_check.message_name = 'ZX_TAX_RATE_ID_CODE_MISSING'
340: );
341:
342: IF ( g_level_event >= g_current_runtime_level) THEN
343: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
344: 'No. of Rows Inserted : '||SQL%ROWCOUNT);
345: END IF;
346:
347: IF ( g_level_event >= g_current_runtime_level) THEN

Line 348: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

344: 'No. of Rows Inserted : '||SQL%ROWCOUNT);
345: END IF;
346:
347: IF ( g_level_event >= g_current_runtime_level) THEN
348: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
349: 'Defaulting Additional Tax Det Attrs and Tax Line Attrs');
350: END IF;
351:
352: Default_Tax_Attr(x_return_status);

Line 355: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

351:
352: Default_Tax_Attr(x_return_status);
353:
354: IF ( g_level_event >= g_current_runtime_level) THEN
355: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
356: 'After Defaulting, Validate either tax_rate_id or tax_rate_code is present');
357: END IF;
358:
359: INSERT INTO ZX_VALIDATION_ERRORS_GT(

Line 400: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

396: AND exists_check.message_name = 'ZX_TAX_RATE_ID_CODE_MISSING'
397: );
398:
399: IF ( g_level_event >= g_current_runtime_level) THEN
400: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
401: 'No. of Rows Inserted : '||SQL%ROWCOUNT);
402: END IF;
403:
404: IF ( g_level_event >= g_current_runtime_level) THEN

Line 405: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

401: 'No. of Rows Inserted : '||SQL%ROWCOUNT);
402: END IF;
403:
404: IF ( g_level_event >= g_current_runtime_level) THEN
405: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
406: 'Validating Transaction and Imported tax line info');
407: END IF;
408:
409: Validate_Tax_Attr(x_return_status);

Line 431: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

427: l_error_rec.interface_line_id;
428: EXIT WHEN check_error%NOTFOUND ; -- Added exit conditon .
429:
430: FND_LOG.STRING(g_level_statement,
431: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
432: '***ERROR*** Application_id : '||l_error_rec.application_id);
433: FND_LOG.STRING(g_level_statement,
434: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
435: '***ERROR*** Entity_code : '||l_error_rec.entity_code);

Line 434: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

430: FND_LOG.STRING(g_level_statement,
431: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
432: '***ERROR*** Application_id : '||l_error_rec.application_id);
433: FND_LOG.STRING(g_level_statement,
434: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
435: '***ERROR*** Entity_code : '||l_error_rec.entity_code);
436: FND_LOG.STRING(g_level_statement,
437: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
438: '***ERROR*** Event_class_code : '||l_error_rec.event_class_code);

Line 437: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

433: FND_LOG.STRING(g_level_statement,
434: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
435: '***ERROR*** Entity_code : '||l_error_rec.entity_code);
436: FND_LOG.STRING(g_level_statement,
437: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
438: '***ERROR*** Event_class_code : '||l_error_rec.event_class_code);
439: FND_LOG.STRING(g_level_statement,
440: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
441: '***ERROR*** Trx_id : '||l_error_rec.trx_id);

Line 440: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

436: FND_LOG.STRING(g_level_statement,
437: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
438: '***ERROR*** Event_class_code : '||l_error_rec.event_class_code);
439: FND_LOG.STRING(g_level_statement,
440: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
441: '***ERROR*** Trx_id : '||l_error_rec.trx_id);
442: FND_LOG.STRING(g_level_statement,
443: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
444: '***ERROR*** Trx_line_id : '||l_error_rec.trx_line_id);

Line 443: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

439: FND_LOG.STRING(g_level_statement,
440: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
441: '***ERROR*** Trx_id : '||l_error_rec.trx_id);
442: FND_LOG.STRING(g_level_statement,
443: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
444: '***ERROR*** Trx_line_id : '||l_error_rec.trx_line_id);
445: FND_LOG.STRING(g_level_statement,
446: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
447: '***ERROR*** Trx_level_type : '||l_error_rec.trx_level_type);

Line 446: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

442: FND_LOG.STRING(g_level_statement,
443: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
444: '***ERROR*** Trx_line_id : '||l_error_rec.trx_line_id);
445: FND_LOG.STRING(g_level_statement,
446: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
447: '***ERROR*** Trx_level_type : '||l_error_rec.trx_level_type);
448: FND_LOG.STRING(g_level_statement,
449: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
450: '***ERROR*** Message_name : '||l_error_rec.message_name);

Line 449: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

445: FND_LOG.STRING(g_level_statement,
446: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
447: '***ERROR*** Trx_level_type : '||l_error_rec.trx_level_type);
448: FND_LOG.STRING(g_level_statement,
449: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
450: '***ERROR*** Message_name : '||l_error_rec.message_name);
451: FND_LOG.STRING(g_level_statement,
452: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
453: '***ERROR*** Other_doc_application_id : '||l_error_rec.other_doc_application_id);

Line 452: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

448: FND_LOG.STRING(g_level_statement,
449: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
450: '***ERROR*** Message_name : '||l_error_rec.message_name);
451: FND_LOG.STRING(g_level_statement,
452: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
453: '***ERROR*** Other_doc_application_id : '||l_error_rec.other_doc_application_id);
454: FND_LOG.STRING(g_level_statement,
455: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
456: '***ERROR*** Other_doc_entity_code : '||l_error_rec.other_doc_entity_code);

Line 455: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

451: FND_LOG.STRING(g_level_statement,
452: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
453: '***ERROR*** Other_doc_application_id : '||l_error_rec.other_doc_application_id);
454: FND_LOG.STRING(g_level_statement,
455: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
456: '***ERROR*** Other_doc_entity_code : '||l_error_rec.other_doc_entity_code);
457: FND_LOG.STRING(g_level_statement,
458: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
459: '***ERROR*** Other_doc_event_class_code : '||l_error_rec.other_doc_event_class_code);

Line 458: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

454: FND_LOG.STRING(g_level_statement,
455: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
456: '***ERROR*** Other_doc_entity_code : '||l_error_rec.other_doc_entity_code);
457: FND_LOG.STRING(g_level_statement,
458: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
459: '***ERROR*** Other_doc_event_class_code : '||l_error_rec.other_doc_event_class_code);
460: FND_LOG.STRING(g_level_statement,
461: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
462: '***ERROR*** Other_doc_trx_id : '||l_error_rec.other_doc_trx_id);

Line 461: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

457: FND_LOG.STRING(g_level_statement,
458: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
459: '***ERROR*** Other_doc_event_class_code : '||l_error_rec.other_doc_event_class_code);
460: FND_LOG.STRING(g_level_statement,
461: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
462: '***ERROR*** Other_doc_trx_id : '||l_error_rec.other_doc_trx_id);
463: END LOOP;
464: CLOSE check_error;
465: END IF;

Line 471: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

467: ZX_GLOBAL_STRUCTURES_PKG.delete_trx_line_dist_tbl;
468:
469: IF (g_level_statement >= g_current_runtime_level ) THEN
470: FND_LOG.STRING(g_level_statement,
471: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
472: 'x_return_status from Validate_Tax_Attr : '||x_return_status);
473: END IF;
474:
475: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 477: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

473: END IF;
474:
475: IF (g_level_procedure >= g_current_runtime_level ) THEN
476: FND_LOG.STRING(g_level_procedure,
477: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
478: 'ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR(-)');
479: END IF;
480:
481: EXCEPTION

Line 478: 'ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR(-)');

474:
475: IF (g_level_procedure >= g_current_runtime_level ) THEN
476: FND_LOG.STRING(g_level_procedure,
477: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
478: 'ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR(-)');
479: END IF;
480:
481: EXCEPTION
482: WHEN OTHERS THEN

Line 486: 'ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

482: WHEN OTHERS THEN
483: IF check_error%ISOPEN THEN CLOSE check_error; END IF;
484: IF (g_level_unexpected >= g_current_runtime_level ) THEN
485: FND_LOG.STRING(g_level_unexpected,
486: 'ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
487: sqlerrm);
488: END IF;
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490: app_exception.raise_exception;

Line 546: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

542: x_return_status := FND_API.G_RET_STS_SUCCESS;
543: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
544: IF (g_level_procedure >= g_current_runtime_level ) THEN
545: FND_LOG.STRING(g_level_procedure,
546: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
547: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR(+)');
548: END IF;
549:
550: --Bug 5018766 : Default the tax_date , tax_determine_date and tax_point_date for all the trx_lines

Line 547: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR(+)');

543: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
544: IF (g_level_procedure >= g_current_runtime_level ) THEN
545: FND_LOG.STRING(g_level_procedure,
546: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
547: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR(+)');
548: END IF;
549:
550: --Bug 5018766 : Default the tax_date , tax_determine_date and tax_point_date for all the trx_lines
551: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 553: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

549:
550: --Bug 5018766 : Default the tax_date , tax_determine_date and tax_point_date for all the trx_lines
551: IF (g_level_statement >= g_current_runtime_level ) THEN
552: FND_LOG.STRING(g_level_statement,
553: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
554: 'Stamping the Dates onto ZX_TRANSACTION_LINES_GT');
555: END IF;
556:
557: OPEN c_lines;

Line 589: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

585: AND trx_level_type = l_trx_level_type_tbl(i);
586:
587: IF (g_level_statement >= g_current_runtime_level ) THEN
588: FND_LOG.STRING(g_level_statement,
589: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
590: 'Records Updated : '||SQL%ROWCOUNT);
591: END IF;
592: l_count := 0;
593: ELSE

Line 607: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

603: -- This query is split into 3 queries as suggested by Jinsoo,
604: -- to avoid the complex OR Conditions.
605: IF (g_level_statement >= g_current_runtime_level ) THEN
606: FND_LOG.STRING(g_level_statement,
607: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
608: 'Stamping the Dates onto ZX_IMPORT_TAX_LINES_GT (One-2-One Alloc)');
609: END IF;
610:
611: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines

Line 653: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

649: );
650:
651: IF (g_level_statement >= g_current_runtime_level ) THEN
652: FND_LOG.STRING(g_level_statement,
653: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
654: 'Records updated : '||SQL%ROWCOUNT);
655: END IF;
656:
657: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 659: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

655: END IF;
656:
657: IF (g_level_statement >= g_current_runtime_level ) THEN
658: FND_LOG.STRING(g_level_statement,
659: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
660: 'Stamping the Dates onto ZX_IMPORT_TAX_LINES_GT (Multi Alloc)');
661: END IF;
662:
663: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines

Line 720: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

716: WHERE (tax_date IS NULL OR subscription_date IS NULL);
717:
718: IF (g_level_statement >= g_current_runtime_level ) THEN
719: FND_LOG.STRING(g_level_statement,
720: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
721: 'Records updated : '||SQL%ROWCOUNT);
722: END IF;
723:
724: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 726: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

722: END IF;
723:
724: IF (g_level_statement >= g_current_runtime_level ) THEN
725: FND_LOG.STRING(g_level_statement,
726: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
727: 'Stamping the Dates onto ZX_IMPORT_TAX_LINES_GT (All Alloc)');
728: END IF;
729:
730: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines

Line 786: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

782: WHERE (tax_date IS NULL OR subscription_date IS NULL);
783:
784: IF (g_level_statement >= g_current_runtime_level ) THEN
785: FND_LOG.STRING(g_level_statement,
786: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
787: 'Records updated : '||SQL%ROWCOUNT);
788: END IF;
789:
790: --Defaulting for Taxation Country

Line 793: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

789:
790: --Defaulting for Taxation Country
791: IF (g_level_statement >= g_current_runtime_level ) THEN
792: FND_LOG.STRING(g_level_statement,
793: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
794: 'Defaulting for Taxation Country in ZX_TRX_HEADERS_GT');
795: END IF;
796:
797: UPDATE ZX_TRX_HEADERS_GT Header

Line 807: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

803: WHERE default_taxation_country IS NULL;
804:
805: IF (g_level_statement >= g_current_runtime_level ) THEN
806: FND_LOG.STRING(g_level_statement,
807: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
808: 'Records updated : '||SQL%ROWCOUNT);
809: END IF;
810:
811: --Defaulting for Tax Regime Code and Tax Code

Line 824: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

820: IF l_count_reg_null <> l_count_tax_lines THEN
821:
822: IF (g_level_statement >= g_current_runtime_level ) THEN
823: FND_LOG.STRING(g_level_statement,
824: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
825: 'Defaulting for Tax_Regime_Code and Tax from Tax_Rate_Code');
826: END IF;
827:
828: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines

Line 946: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

942: AND (TaxLines.tax_regime_code IS NULL OR TaxLines.tax IS NULL);
943:
944: IF (g_level_statement >= g_current_runtime_level ) THEN
945: FND_LOG.STRING(g_level_statement,
946: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
947: 'Records updated : '||SQL%ROWCOUNT);
948: END IF;
949:
950: -- This Update is to Ensure that the regime and tax get defaulted in case rate code is null and rate id being passed

Line 955: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

951: -- If tax_rate_id is not null then execute this query
952: IF l_count_rate_id_null <> 0 THEN
953: IF (g_level_statement >= g_current_runtime_level ) THEN
954: FND_LOG.STRING(g_level_statement,
955: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
956: 'Defaulting for Tax_Regime_Code and Tax from Tax_Rate_Id');
957: END IF;
958:
959: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines

Line 1080: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

1076: AND (TaxLines.tax_regime_code IS NULL OR TaxLines.tax IS NULL);
1077:
1078: IF (g_level_statement >= g_current_runtime_level ) THEN
1079: FND_LOG.STRING(g_level_statement,
1080: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
1081: 'Records updated : '||SQL%ROWCOUNT);
1082: END IF;
1083: END IF; -- IF l_count_rate_id_null <> 0
1084: END IF; -- IF l_count_reg_null = 0

Line 1091: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

1087: -- If customer has populated the same in interface tables need not default again.
1088: IF l_count_status_null <> l_count_tax_lines THEN
1089: IF (g_level_statement >= g_current_runtime_level ) THEN
1090: FND_LOG.STRING(g_level_statement,
1091: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
1092: 'Defaulting for Tax Status Code');
1093: END IF;
1094:
1095: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines

Line 1224: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

1220: (tax_rate_code IS NOT NULL OR tax_rate_id IS NOT NULL);
1221:
1222: IF (g_level_statement >= g_current_runtime_level ) THEN
1223: FND_LOG.STRING(g_level_statement,
1224: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
1225: 'Records updated : '||SQL%ROWCOUNT);
1226: END IF;
1227: END IF;
1228:

Line 1235: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

1231:
1232: IF l_count_pvr_null <> l_count_tax_lines THEN
1233: IF (g_level_statement >= g_current_runtime_level ) THEN
1234: FND_LOG.STRING(g_level_statement,
1235: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
1236: 'Defaulting for tax_provider_id');
1237: END IF;
1238:
1239: --Defaulting for tax Provider Id

Line 1320: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

1316: (tax_rate_code IS NOT NULL OR tax_rate_id IS NOT NULL);
1317:
1318: IF (g_level_statement >= g_current_runtime_level ) THEN
1319: FND_LOG.STRING(g_level_statement,
1320: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
1321: 'Records updated : '||SQL%ROWCOUNT);
1322: END IF;
1323: END IF;
1324:

Line 1337: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

1333: -- Commented the above line and added the following condition for Bug10178724
1334: IF l_count_jur_null <> l_count_tax_lines THEN
1335: IF (g_level_statement >= g_current_runtime_level ) THEN
1336: FND_LOG.STRING(g_level_statement,
1337: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
1338: 'Defaulting for Tax Jurisdiction Code');
1339: END IF;
1340:
1341: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines

Line 1448: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

1444: (tax_rate_code IS NOT NULL OR tax_rate_id IS NOT NULL);
1445:
1446: IF (g_level_statement >= g_current_runtime_level ) THEN
1447: FND_LOG.STRING(g_level_statement,
1448: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
1449: 'Records updated : '||SQL%ROWCOUNT);
1450: END IF;
1451: END IF;
1452:

Line 1459: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

1455: -- bug 7414628 split the query using UNION ALL based on tax_rate_code and tax_rate_id
1456:
1457: IF (g_level_statement >= g_current_runtime_level ) THEN
1458: FND_LOG.STRING(g_level_statement,
1459: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
1460: 'Defaulting for Tax Rate Code, Tax Rate Id, Percentage Rate (1)');
1461: END IF;
1462:
1463: UPDATE zx_import_tax_lines_gt TaxLines

Line 1593: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

1589: );
1590:
1591: IF (g_level_statement >= g_current_runtime_level ) THEN
1592: FND_LOG.STRING(g_level_statement,
1593: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
1594: 'Records updated : '||SQL%ROWCOUNT);
1595: END IF;
1596:
1597: -- Execute this query only when tax_rate_id is not null

Line 1602: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

1598:
1599: IF l_count_rate_id_null <> 0 THEN
1600: IF (g_level_statement >= g_current_runtime_level ) THEN
1601: FND_LOG.STRING(g_level_statement,
1602: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
1603: 'Defaulting for Tax Rate Code, Tax Rate Id, Percentage Rate (2)');
1604: END IF;
1605:
1606: UPDATE zx_import_tax_lines_gt TaxLines

Line 1711: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

1707: TaxLines.tax_rate IS NULL);
1708:
1709: IF (g_level_statement >= g_current_runtime_level ) THEN
1710: FND_LOG.STRING(g_level_statement,
1711: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
1712: 'Records updated : '||SQL%ROWCOUNT);
1713: END IF;
1714: END IF;
1715:

Line 1720: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

1716: -- Defaulting for Transaction Business Category and Product Category
1717: -- Product Fiscal Classification and Assessable Value
1718: IF (g_level_statement >= g_current_runtime_level ) THEN
1719: FND_LOG.STRING(g_level_statement,
1720: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
1721: 'Defaulting for Transaction Business Category and Product Category, '||
1722: 'Product Fiscal Classification and Assessable Value');
1723: END IF;
1724: -- Call the private procedure to default the tax attributes.

Line 1732: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

1728: /* Commented for the Bug 4902521
1729:
1730: IF (g_level_statement >= g_current_runtime_level ) THEN
1731: FND_LOG.STRING(g_level_statement,
1732: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
1733: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:Defaulting tax amount if it is NULL
1734: and tax rate is specified ');
1735: END IF;
1736:

Line 1733: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:Defaulting tax amount if it is NULL

1729:
1730: IF (g_level_statement >= g_current_runtime_level ) THEN
1731: FND_LOG.STRING(g_level_statement,
1732: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
1733: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:Defaulting tax amount if it is NULL
1734: and tax rate is specified ');
1735: END IF;
1736:
1737: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines

Line 1911: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

1907: -- Bug#3910168
1908: -- Defaulting for tax classification code
1909: IF (g_level_statement >= g_current_runtime_level ) THEN
1910: FND_LOG.STRING(g_level_statement,
1911: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
1912: 'Defaulting for tax classification code - Call to pop_def_tax_classif_code');
1913: END IF;
1914:
1915: pop_def_tax_classif_code(x_return_status);

Line 1919: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR.END',

1915: pop_def_tax_classif_code(x_return_status);
1916:
1917: IF (g_level_procedure >= g_current_runtime_level ) THEN
1918: FND_LOG.STRING(g_level_procedure,
1919: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR.END',
1920: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR(-)');
1921: END IF;
1922:
1923: EXCEPTION

Line 1920: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR(-)');

1916:
1917: IF (g_level_procedure >= g_current_runtime_level ) THEN
1918: FND_LOG.STRING(g_level_procedure,
1919: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR.END',
1920: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR(-)');
1921: END IF;
1922:
1923: EXCEPTION
1924: WHEN OTHERS THEN

Line 1927: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

1923: EXCEPTION
1924: WHEN OTHERS THEN
1925: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1926: FND_LOG.STRING(g_level_unexpected,
1927: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
1928: sqlerrm);
1929: END IF;
1930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1931: app_exception.raise_exception;

Line 2221: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR.BEGIN',

2217: x_return_status := FND_API.G_RET_STS_SUCCESS;
2218: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2219: IF (g_level_procedure >= g_current_runtime_level ) THEN
2220: FND_LOG.STRING(g_level_procedure,
2221: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR.BEGIN',
2222: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR(+)');
2223: END IF;
2224:
2225: --Validations for ZX_TRX_HEADERS_GT, ZX_TRANSACTION_LINES_GT

Line 2222: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR(+)');

2218: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2219: IF (g_level_procedure >= g_current_runtime_level ) THEN
2220: FND_LOG.STRING(g_level_procedure,
2221: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR.BEGIN',
2222: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR(+)');
2223: END IF;
2224:
2225: --Validations for ZX_TRX_HEADERS_GT, ZX_TRANSACTION_LINES_GT
2226: IF (g_level_statement >= g_current_runtime_level) THEN

Line 2227: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

2223: END IF;
2224:
2225: --Validations for ZX_TRX_HEADERS_GT, ZX_TRANSACTION_LINES_GT
2226: IF (g_level_statement >= g_current_runtime_level) THEN
2227: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
2228: 'Validations for ZX_TRX_HEADERS_GT and ZX_TRANSACTION_LINES_GT');
2229: END IF;
2230:
2231: -- Select the key columns and write into fnd log for debug purpose

Line 2233: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

2229: END IF;
2230:
2231: -- Select the key columns and write into fnd log for debug purpose
2232: IF ( g_level_statement >= g_current_runtime_level) THEN
2233: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
2234: 'Opening the cursor - get_header_and_line_info_csr');
2235:
2236: OPEN get_header_and_line_info_csr;
2237: LOOP

Line 2252: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

2248: l_count := nvl(l_trx_line_id_tbl.COUNT,0);
2249:
2250: IF l_count > 0 THEN
2251: FND_LOG.STRING(g_level_statement,
2252: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
2253: 'Number of rows fetched = ' || to_char(l_count));
2254: FOR i IN 1.. l_count LOOP
2255: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
2256: 'Row : '|| to_char(i) ||

Line 2255: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

2251: FND_LOG.STRING(g_level_statement,
2252: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
2253: 'Number of rows fetched = ' || to_char(l_count));
2254: FOR i IN 1.. l_count LOOP
2255: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
2256: 'Row : '|| to_char(i) ||
2257: ', Application_id = ' || to_char(l_application_id_tbl(i)) ||
2258: ', Entity_code = ' || l_entity_code_tbl(i) ||
2259: ', Event_class_code = ' || l_event_class_code_tbl(i) ||

Line 2282: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

2278:
2279: /******************** Split the Header and Line Level Validations : Bug 4703541******/
2280: /** 1. Validations for the zx_trx_headers_gt related **/
2281: IF ( g_level_statement >= g_current_runtime_level) THEN
2282: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
2283: 'Running Header Related Validations : ZX_TRX_HEADERS_GT');
2284: END IF;
2285:
2286: INSERT ALL

Line 2674: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

2670: -- Bug 4902521 : Added Message to check no. of rows inserted .
2671: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2672:
2673: IF ( g_level_statement >= g_current_runtime_level) THEN
2674: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
2675: 'No. of Rows inserted : '|| to_char(sql%ROWCOUNT) );
2676: END IF;
2677:
2678: /** 2. Validating for the Line Related Validations : zx_transaction_lines_gt **/

Line 2681: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

2677:
2678: /** 2. Validating for the Line Related Validations : zx_transaction_lines_gt **/
2679: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2680: IF ( g_level_statement >= g_current_runtime_level) THEN
2681: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
2682: 'Running Trx Line Related Validations : ZX_TRANSACTION_LINES_GT');
2683: END IF;
2684:
2685: INSERT ALL

Line 4697: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

4693:
4694: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4695:
4696: IF ( g_level_statement >= g_current_runtime_level) THEN
4697: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4698: 'No. of Rows inserted : '|| to_char(sql%ROWCOUNT) );
4699: END IF;
4700:
4701: /******************** End of Logic for Header/Line Validations *************************/

Line 4706: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

4702:
4703: -- Validations for Imported tax Lines.
4704: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4705: IF ( g_level_event >= g_current_runtime_level) THEN
4706: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4707: 'Validations for ZX_IMPORT_TAX_LINES_GT');
4708: END IF;
4709:
4710: -- Select the key columns and write into fnd log for debug purpose

Line 4712: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

4708: END IF;
4709:
4710: -- Select the key columns and write into fnd log for debug purpose
4711: IF ( g_level_statement >= g_current_runtime_level) THEN
4712: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4713: 'Opening the cursor - get_import_tax_line_info_csr');
4714: OPEN get_import_tax_line_info_csr;
4715: LOOP
4716: FETCH get_import_tax_line_info_csr BULK COLLECT INTO

Line 4730: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

4726: l_count := nvl(l_trx_line_id_tbl.COUNT,0);
4727:
4728: IF l_count > 0 THEN
4729: FND_LOG.STRING(g_level_statement,
4730: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4731: 'Number of rows fetched = ' || to_char(l_count));
4732: FOR i IN 1.. l_count LOOP
4733: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4734: 'Row : '|| to_char(i) ||

Line 4733: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

4729: FND_LOG.STRING(g_level_statement,
4730: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4731: 'Number of rows fetched = ' || to_char(l_count));
4732: FOR i IN 1.. l_count LOOP
4733: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4734: 'Row : '|| to_char(i) ||
4735: ', Application_id = ' || to_char(l_application_id_tbl(i)) ||
4736: ', Entity_code = ' || l_entity_code_tbl(i) ||
4737: ', Event_class_code = ' || l_event_class_code_tbl(i) ||

Line 4759: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

4755: l_summary_tax_line_number_tbl.delete;
4756: END IF; -- End of debug checking
4757:
4758: IF ( g_level_statement >= g_current_runtime_level) THEN
4759: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4760: 'Running Regime, Tax, Status and Jurisdiction related Validations');
4761: END IF;
4762:
4763: -- Have moved the validations that are specific to an Item line to a separate query.

Line 5608: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

5604: )
5605: ) ;
5606:
5607: IF ( g_level_statement >= g_current_runtime_level) THEN
5608: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
5609: 'No. of Rows inserted : '|| to_char(sql%ROWCOUNT) );
5610: END IF;
5611:
5612: -- Added debug code to print the lines in ZX_IMPORT_TAX_LINES_GT --

Line 5614: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

5610: END IF;
5611:
5612: -- Added debug code to print the lines in ZX_IMPORT_TAX_LINES_GT --
5613: IF ( g_level_statement >= g_current_runtime_level) THEN
5614: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
5615: 'Opening cursor - get_import_tax_lines_gt_csr');
5616: OPEN get_import_tax_lines_gt_csr;
5617: LOOP
5618: FETCH get_import_tax_lines_gt_csr BULK COLLECT INTO

Line 5633: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

5629: l_count := nvl(l_trx_line_id_tbl.COUNT,0);
5630:
5631: IF l_count > 0 THEN
5632: FND_LOG.STRING(g_level_statement,
5633: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
5634: 'Number of rows fetched = ' || to_char(l_count));
5635: FOR i IN 1.. l_count LOOP
5636: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
5637: to_char(i) ||'. Trx_id = ' || to_char(l_trx_id_tbl(i)) ||

Line 5636: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

5632: FND_LOG.STRING(g_level_statement,
5633: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
5634: 'Number of rows fetched = ' || to_char(l_count));
5635: FOR i IN 1.. l_count LOOP
5636: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
5637: to_char(i) ||'. Trx_id = ' || to_char(l_trx_id_tbl(i)) ||
5638: ', Trx_line_id = ' || to_char(l_trx_line_id_tbl(i)) ||
5639: ', Summary_tax_line_number = ' || to_char(l_summary_tax_line_number_tbl(i)) ||
5640: ', Regime = ' || l_regime_tbl(i) ||

Line 5665: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

5661:
5662: -- added 3 new quries to handle the following validations.
5663: -- spilt the complex OR condition into 3
5664: IF ( g_level_statement >= g_current_runtime_level) THEN
5665: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
5666: 'Running Tax line allocations related Validations (One-2-One Alloc)');
5667: END IF;
5668:
5669: INSERT ALL

Line 6742: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

6738: )
6739: );
6740:
6741: IF ( g_level_statement >= g_current_runtime_level) THEN
6742: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6743: 'No. of Rows inserted : '|| to_char(sql%ROWCOUNT) );
6744: END IF;
6745:
6746: IF ( g_level_statement >= g_current_runtime_level) THEN

Line 6747: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

6743: 'No. of Rows inserted : '|| to_char(sql%ROWCOUNT) );
6744: END IF;
6745:
6746: IF ( g_level_statement >= g_current_runtime_level) THEN
6747: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6748: 'Running Tax line allocations related Validations (All Alloc)');
6749: END IF;
6750:
6751: INSERT ALL

Line 7296: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

7292: )
7293: );
7294:
7295: IF ( g_level_statement >= g_current_runtime_level) THEN
7296: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
7297: 'No. of Rows inserted : '|| to_char(sql%ROWCOUNT) );
7298: END IF;
7299:
7300: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 7303: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

7299:
7300: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7301:
7302: IF ( g_level_statement >= g_current_runtime_level) THEN
7303: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
7304: 'Running Regime, Tax and Status Subscription related Validations');
7305: END IF;
7306:
7307: -- Bug 5018766

Line 7605: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

7601: )
7602: );
7603:
7604: IF ( g_level_statement >= g_current_runtime_level) THEN
7605: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
7606: 'No. of Rows inserted : '|| to_char(sql%ROWCOUNT) );
7607: END IF;
7608:
7609: --Bug 5018766 : Delete any duplicate rows that might get inserted for that trx_id , trx_line_id from the above insert stmt.

Line 7629: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

7625: WHERE row_rank <> 1
7626: );
7627:
7628: IF ( g_level_statement >= g_current_runtime_level) THEN
7629: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
7630: 'Running Tax Rate Code related Validations');
7631: END IF;
7632:
7633: INSERT ALL

Line 8016: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

8012: -- Bug 12385195
8013: );
8014:
8015: IF ( g_level_statement >= g_current_runtime_level) THEN
8016: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
8017: 'No. of Rows inserted : '|| to_char(sql%ROWCOUNT) );
8018: END IF;
8019:
8020: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 8023: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

8019:
8020: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8021:
8022: IF ( g_level_statement >= g_current_runtime_level) THEN
8023: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
8024: 'Running Tax Rate Code related Validations based on Tax_Rate_id');
8025: END IF;
8026:
8027: INSERT ALL

Line 8277: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

8273: );
8274:
8275: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8276: IF ( g_level_statement >= g_current_runtime_level) THEN
8277: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
8278: 'No. of Rows inserted : '|| to_char(sql%ROWCOUNT) );
8279: END IF;
8280:
8281: -- Validations for zx_trx_tax_link_gt link_gt

Line 8284: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

8280:
8281: -- Validations for zx_trx_tax_link_gt link_gt
8282: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8283: IF ( g_level_event >= g_current_runtime_level) THEN
8284: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
8285: 'Validations for ZX_TRX_TAX_LINK_GT');
8286: END IF;
8287:
8288: -- Select the key columns and write into fnd log for debug purpose

Line 8290: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

8286: END IF;
8287:
8288: -- Select the key columns and write into fnd log for debug purpose
8289: IF ( g_level_statement >= g_current_runtime_level) THEN
8290: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
8291: 'Opening the cursor - get_tax_link_gt_info_csr');
8292: OPEN get_tax_link_gt_info_csr;
8293: LOOP
8294: FETCH get_tax_link_gt_info_csr BULK COLLECT INTO

Line 8308: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

8304: l_count := nvl(l_trx_line_id_tbl.COUNT,0);
8305:
8306: IF l_count > 0 THEN
8307: FND_LOG.STRING(g_level_statement,
8308: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
8309: 'Number of rows fetched = ' || to_char(l_count));
8310: FOR i IN 1.. l_count LOOP
8311: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
8312: 'Row : '|| to_char(i) ||

Line 8311: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

8307: FND_LOG.STRING(g_level_statement,
8308: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
8309: 'Number of rows fetched = ' || to_char(l_count));
8310: FOR i IN 1.. l_count LOOP
8311: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
8312: 'Row : '|| to_char(i) ||
8313: ', Application_id = ' || to_char(l_application_id_tbl(i)) ||
8314: ', Entity_code = ' || l_entity_code_tbl(i) ||
8315: ', Event_class_code = ' || l_event_class_code_tbl(i) ||

Line 8337: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

8333: l_summary_tax_line_number_tbl.delete;
8334: END IF; -- End of debug checking
8335:
8336: IF ( g_level_event >= g_current_runtime_level) THEN
8337: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
8338: 'Running Line-Tax Link related Validations : ZX_TRX_TAX_LINK_GT');
8339: END IF;
8340:
8341: INSERT ALL

Line 8435: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

8431: FROM zx_trx_tax_link_gt link_gt;
8432:
8433: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8434: IF ( g_level_statement >= g_current_runtime_level) THEN
8435: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
8436: 'No. of Rows inserted : '|| to_char(sql%ROWCOUNT) );
8437: END IF;
8438:
8439: -- Bug Fix # 4184091

Line 8448: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

8444:
8445: IF ( SQL%ROWCOUNT > 0 ) THEN
8446: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8447: IF ( g_level_statement >= g_current_runtime_level) THEN
8448: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
8449: 'Updated the validation_check_flag to N in zx_trx_headers_gt for '||to_char(SQL%ROWCOUNT)||' trx_ids ');
8450: END IF;
8451: END IF ;
8452:

Line 8455: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR.END',

8451: END IF ;
8452:
8453: IF (g_level_procedure >= g_current_runtime_level ) THEN
8454: FND_LOG.STRING(g_level_procedure,
8455: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR.END',
8456: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR(-)');
8457: END IF;
8458:
8459: EXCEPTION

Line 8456: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR(-)');

8452:
8453: IF (g_level_procedure >= g_current_runtime_level ) THEN
8454: FND_LOG.STRING(g_level_procedure,
8455: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR.END',
8456: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR(-)');
8457: END IF;
8458:
8459: EXCEPTION
8460: WHEN OTHERS THEN

Line 8476: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

8472: END IF;
8473:
8474: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8475: FND_LOG.STRING(g_level_unexpected,
8476: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
8477: SQLERRM);
8478: END IF;
8479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8480: app_exception.raise_exception;

Line 8519: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents.BEGIN',

8515: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8516:
8517: IF (g_level_event >= g_current_runtime_level ) THEN
8518: FND_LOG.STRING(g_level_event,
8519: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents.BEGIN',
8520: 'ZX_VALIDATE_API_PKG: Validate_Other_Documents(+)');
8521: END IF;
8522:
8523: -- Select the key columns and write into fnd log for debug purpose

Line 8520: 'ZX_VALIDATE_API_PKG: Validate_Other_Documents(+)');

8516:
8517: IF (g_level_event >= g_current_runtime_level ) THEN
8518: FND_LOG.STRING(g_level_event,
8519: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents.BEGIN',
8520: 'ZX_VALIDATE_API_PKG: Validate_Other_Documents(+)');
8521: END IF;
8522:
8523: -- Select the key columns and write into fnd log for debug purpose
8524: IF ( g_level_statement >= g_current_runtime_level) THEN

Line 8526: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents',

8522:
8523: -- Select the key columns and write into fnd log for debug purpose
8524: IF ( g_level_statement >= g_current_runtime_level) THEN
8525: FND_LOG.STRING(g_level_statement,
8526: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents',
8527: 'Opening the cursor - get_other_doc_info_csr');
8528: OPEN get_other_doc_info_csr;
8529: LOOP
8530: FETCH get_other_doc_info_csr BULK COLLECT INTO

Line 8543: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents',

8539: l_count := nvl(l_trx_line_id_tbl.COUNT,0);
8540:
8541: IF l_count > 0 THEN
8542: FND_LOG.STRING(g_level_statement,
8543: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents',
8544: 'Number of rows fetched = ' || to_char(l_count));
8545: FOR i IN 1.. l_count LOOP
8546: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',
8547: 'Row : ' || to_char(i) ||

Line 8546: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',

8542: FND_LOG.STRING(g_level_statement,
8543: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents',
8544: 'Number of rows fetched = ' || to_char(l_count));
8545: FOR i IN 1.. l_count LOOP
8546: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',
8547: 'Row : ' || to_char(i) ||
8548: ', Application_id = ' || to_char(l_application_id_tbl(i)) ||
8549: ', Entity_code = ' || l_entity_code_tbl(i) ||
8550: ', Event_class_code = ' || l_event_class_code_tbl(i) ||

Line 8571: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents',

8567: END IF; -- End of debug checking
8568:
8569: IF (g_level_statement >= g_current_runtime_level ) THEN
8570: FND_LOG.STRING(g_level_statement,
8571: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents',
8572: 'Running Other Document related Validations');
8573: END IF;
8574:
8575: INSERT ALL

Line 9007: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents',

9003:
9004: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9005:
9006: IF ( g_level_statement >= g_current_runtime_level) THEN
9007: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents',
9008: 'No. of Rows inserted : '|| to_char(sql%ROWCOUNT) );
9009: END IF;
9010:
9011: IF ( g_level_event >= g_current_runtime_level) THEN

Line 9013: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents.END',

9009: END IF;
9010:
9011: IF ( g_level_event >= g_current_runtime_level) THEN
9012: FND_LOG.STRING(g_level_event,
9013: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents.END',
9014: 'ZX_VALIDATE_API_PKG: Validate_Other_Documents(-)');
9015: END IF;
9016:
9017: EXCEPTION

Line 9014: 'ZX_VALIDATE_API_PKG: Validate_Other_Documents(-)');

9010:
9011: IF ( g_level_event >= g_current_runtime_level) THEN
9012: FND_LOG.STRING(g_level_event,
9013: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents.END',
9014: 'ZX_VALIDATE_API_PKG: Validate_Other_Documents(-)');
9015: END IF;
9016:
9017: EXCEPTION
9018: WHEN OTHERS THEN

Line 9024: 'ZX_VALIDATE_API_PKG.Validate_Other_Documents',

9020: CLOSE get_other_doc_info_csr;
9021: END IF;
9022: IF (g_level_unexpected >= g_current_runtime_level ) THEN
9023: FND_LOG.STRING(g_level_unexpected,
9024: 'ZX_VALIDATE_API_PKG.Validate_Other_Documents',
9025: sqlerrm);
9026: END IF;
9027:
9028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9180: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE.BEGIN',

9176: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9177:
9178: IF (g_level_statement >= g_current_runtime_level ) THEN
9179: FND_LOG.STRING(g_level_statement,
9180: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE.BEGIN',
9181: 'ZX_VALIDATE_API_PKG: pop_def_tax_classif_code(+)');
9182: END IF;
9183:
9184: --

Line 9181: 'ZX_VALIDATE_API_PKG: pop_def_tax_classif_code(+)');

9177:
9178: IF (g_level_statement >= g_current_runtime_level ) THEN
9179: FND_LOG.STRING(g_level_statement,
9180: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE.BEGIN',
9181: 'ZX_VALIDATE_API_PKG: pop_def_tax_classif_code(+)');
9182: END IF;
9183:
9184: --
9185: -- init error buffer and return status

Line 9192: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE',

9188: l_error_buffer := NULL;
9189:
9190: IF (g_level_statement >= g_current_runtime_level ) THEN
9191: FND_LOG.STRING(g_level_statement,
9192: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE',
9193: 'Opening the cursor - get_parm_info_for_def_tax_csr');
9194: END IF;
9195:
9196: OPEN get_parm_info_for_def_tax_csr;

Line 9248: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE',

9244: l_count := l_trx_line_id_tbl.COUNT;
9245:
9246: IF (g_level_procedure >= g_current_runtime_level ) THEN
9247: FND_LOG.STRING(g_level_procedure,
9248: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE',
9249: 'number of rows fetched = ' || to_char(l_count));
9250: END IF;
9251:
9252: IF l_count > 0 THEN

Line 9325: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE',

9321: -- get default tax classification code
9322: --
9323: IF (g_level_statement >= g_current_runtime_level ) THEN
9324: FND_LOG.STRING(g_level_statement,
9325: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE',
9326: 'Calling ZX_TAX_DEFAULT_PKG.get_default_tax_classification for record '||to_char(i));
9327: END IF;
9328: /* Bug 4919842 : Conditionally Call ZX_TAX_DEFAULT_PKG.get_default_tax_classification if both input
9329: AND output tax classification codes are passed as null */

Line 9362: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE',

9358: -- tax classification code found
9359: --
9360: IF (g_level_statement >= g_current_runtime_level ) THEN
9361: FND_LOG.STRING(g_level_statement,
9362: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE',
9363: 'update zx_transaction_lines_gt with the default tax classification code found ');
9364: END IF;
9365:
9366: FORALL i IN 1 .. l_count

Line 9379: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE',

9375: AND trx_level_type = l_trx_level_type_tbl(i);
9376:
9377: IF (g_level_procedure >= g_current_runtime_level ) THEN
9378: FND_LOG.STRING(g_level_procedure,
9379: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE',
9380: 'fetch next set of records for defaulting ....');
9381: END IF;
9382: ELSE
9383: --

Line 9398: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE',

9394: END IF;
9395:
9396: IF (g_level_procedure >= g_current_runtime_level ) THEN
9397: FND_LOG.STRING(g_level_procedure,
9398: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE',
9399: 'x_return_status = ' || x_return_status);
9400: FND_LOG.STRING(g_level_procedure,
9401: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE',
9402: 'l_error_buffer = ' || l_error_buffer);

Line 9401: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE',

9397: FND_LOG.STRING(g_level_procedure,
9398: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE',
9399: 'x_return_status = ' || x_return_status);
9400: FND_LOG.STRING(g_level_procedure,
9401: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE',
9402: 'l_error_buffer = ' || l_error_buffer);
9403: FND_LOG.STRING(g_level_procedure,
9404: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE.END',
9405: 'ZX_VALIDATE_API_PKG: pop_def_tax_classif_code(-)');

Line 9404: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE.END',

9400: FND_LOG.STRING(g_level_procedure,
9401: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE',
9402: 'l_error_buffer = ' || l_error_buffer);
9403: FND_LOG.STRING(g_level_procedure,
9404: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE.END',
9405: 'ZX_VALIDATE_API_PKG: pop_def_tax_classif_code(-)');
9406: END IF;
9407:
9408: EXCEPTION

Line 9405: 'ZX_VALIDATE_API_PKG: pop_def_tax_classif_code(-)');

9401: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE',
9402: 'l_error_buffer = ' || l_error_buffer);
9403: FND_LOG.STRING(g_level_procedure,
9404: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE.END',
9405: 'ZX_VALIDATE_API_PKG: pop_def_tax_classif_code(-)');
9406: END IF;
9407:
9408: EXCEPTION
9409: WHEN OTHERS THEN

Line 9421: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE',

9417: FND_MSG_PUB.Add;
9418:
9419: IF (g_level_unexpected >= g_current_runtime_level ) THEN
9420: FND_LOG.STRING(g_level_unexpected,
9421: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE',
9422: l_error_buffer);
9423: END IF;
9424:
9425: END pop_def_tax_classif_code;

Line 9872: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.BEGIN',

9868: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9869:
9870: IF (g_level_event >= g_current_runtime_level ) THEN
9871: FND_LOG.STRING(g_level_event,
9872: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.BEGIN',
9873: 'ZX_VALIDATE_API_PKG: def_additional_tax_attribs(+)');
9874: END IF;
9875:
9876: /** Bug 4703541 :

Line 9873: 'ZX_VALIDATE_API_PKG: def_additional_tax_attribs(+)');

9869:
9870: IF (g_level_event >= g_current_runtime_level ) THEN
9871: FND_LOG.STRING(g_level_event,
9872: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.BEGIN',
9873: 'ZX_VALIDATE_API_PKG: def_additional_tax_attribs(+)');
9874: END IF;
9875:
9876: /** Bug 4703541 :
9877: Change Made : Replace global_structure_rec with ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl

Line 9881: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',

9877: Change Made : Replace global_structure_rec with ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl
9878: as this is being directly referred in ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS **/
9879: IF (g_level_statement >= g_current_runtime_level ) THEN
9880: FND_LOG.STRING(g_level_statement,
9881: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
9882: 'Before opening the cursor - gtt_to_glb_strctr_csr');
9883: END IF;
9884:
9885: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 9890: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',

9886: OPEN gtt_to_glb_strctr_csr;
9887:
9888: IF (g_level_statement >= g_current_runtime_level ) THEN
9889: FND_LOG.STRING(g_level_statement,
9890: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
9891: 'After opening the cursor - gtt_to_glb_strctr_csr');
9892: END IF;
9893:
9894: LOOP

Line 10293: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',

10289:
10290:
10291: IF ( G_LEVEL_EVENT >= G_CURRENT_RUNTIME_LEVEL) THEN
10292: FND_LOG.STRING(G_LEVEL_EVENT,
10293: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
10294: 'Validating Transaction: '||
10295: to_char(l_event_class_rec.trx_id)||
10296: ' of Application: '||
10297: to_char(l_event_class_rec.application_id) ||

Line 10310: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',

10306: );
10307:
10308: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10309: IF (g_level_procedure >= g_current_runtime_level ) THEN
10310: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
10311: 'x_return_status = ' || x_return_status);
10312: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
10313: 'l_error_buffer = ' || l_error_buffer);
10314: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.END',

Line 10312: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',

10308: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10309: IF (g_level_procedure >= g_current_runtime_level ) THEN
10310: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
10311: 'x_return_status = ' || x_return_status);
10312: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
10313: 'l_error_buffer = ' || l_error_buffer);
10314: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.END',
10315: 'ZX_VALIDATE_API_PKG: def_additional_tax_attribs(-)');
10316: END IF;

Line 10314: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.END',

10310: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
10311: 'x_return_status = ' || x_return_status);
10312: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
10313: 'l_error_buffer = ' || l_error_buffer);
10314: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.END',
10315: 'ZX_VALIDATE_API_PKG: def_additional_tax_attribs(-)');
10316: END IF;
10317: RETURN;
10318: END IF;

Line 10315: 'ZX_VALIDATE_API_PKG: def_additional_tax_attribs(-)');

10311: 'x_return_status = ' || x_return_status);
10312: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
10313: 'l_error_buffer = ' || l_error_buffer);
10314: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.END',
10315: 'ZX_VALIDATE_API_PKG: def_additional_tax_attribs(-)');
10316: END IF;
10317: RETURN;
10318: END IF;
10319: END IF;

Line 10323: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',

10319: END IF;
10320:
10321: IF (g_level_statement >= g_current_runtime_level ) THEN
10322: FND_LOG.STRING(g_level_statement,
10323: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
10324: 'Calling ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS for record '||to_char(i));
10325: END IF;
10326:
10327: ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS

Line 10338: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',

10334: );
10335:
10336: IF (g_level_statement >= g_current_runtime_level ) THEN
10337: FND_LOG.STRING(g_level_statement,
10338: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
10339: 'Before Calling ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS for record '||to_char(i));
10340: END IF;
10341:
10342: ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS

Line 10352: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',

10348: );
10349:
10350: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10351: IF (g_level_procedure >= g_current_runtime_level ) THEN
10352: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
10353: 'x_return_status = ' || x_return_status);
10354: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
10355: 'l_error_buffer = ' || l_error_buffer);
10356: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.END',

Line 10354: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',

10350: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10351: IF (g_level_procedure >= g_current_runtime_level ) THEN
10352: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
10353: 'x_return_status = ' || x_return_status);
10354: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
10355: 'l_error_buffer = ' || l_error_buffer);
10356: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.END',
10357: 'ZX_VALIDATE_API_PKG: def_additional_tax_attribs(-)');
10358: END IF;

Line 10356: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.END',

10352: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
10353: 'x_return_status = ' || x_return_status);
10354: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
10355: 'l_error_buffer = ' || l_error_buffer);
10356: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.END',
10357: 'ZX_VALIDATE_API_PKG: def_additional_tax_attribs(-)');
10358: END IF;
10359: RETURN;
10360: END IF;

Line 10357: 'ZX_VALIDATE_API_PKG: def_additional_tax_attribs(-)');

10353: 'x_return_status = ' || x_return_status);
10354: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
10355: 'l_error_buffer = ' || l_error_buffer);
10356: FND_LOG.STRING(g_level_procedure,'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.END',
10357: 'ZX_VALIDATE_API_PKG: def_additional_tax_attribs(-)');
10358: END IF;
10359: RETURN;
10360: END IF;
10361: END LOOP;

Line 10367: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',

10363: -- update zx_transaction_lines_gt with the default
10364: -- tax attributes found
10365: IF (g_level_statement >= g_current_runtime_level ) THEN
10366: FND_LOG.STRING(g_level_statement,
10367: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
10368: 'updating zx_transaction_lines_gt with tax attributes found');
10369: END IF;
10370:
10371: FORALL i IN 1..nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID.last,0)

Line 10437: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.END',

10433: CLOSE gtt_to_glb_strctr_csr;
10434:
10435: IF (g_level_event >= g_current_runtime_level ) THEN
10436: FND_LOG.STRING(g_level_event,
10437: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.END',
10438: 'ZX_VALIDATE_API_PKG: def_additional_tax_attribs(-)');
10439: END IF;
10440:
10441: EXCEPTION

Line 10438: 'ZX_VALIDATE_API_PKG: def_additional_tax_attribs(-)');

10434:
10435: IF (g_level_event >= g_current_runtime_level ) THEN
10436: FND_LOG.STRING(g_level_event,
10437: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.END',
10438: 'ZX_VALIDATE_API_PKG: def_additional_tax_attribs(-)');
10439: END IF;
10440:
10441: EXCEPTION
10442:

Line 10455: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',

10451: FND_MSG_PUB.Add;
10452:
10453: IF (g_level_unexpected >= g_current_runtime_level ) THEN
10454: FND_LOG.STRING(g_level_unexpected,
10455: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
10456: l_error_buffer);
10457: END IF;
10458:
10459: END def_additional_tax_attribs;

Line 10555: END ZX_VALIDATE_API_PKG;

10551: l_tax_rate_code_not_exists :=fnd_message.get_string('ZX','ZX_TAX_RATE_CODE_NOT_EXIST' ); -- 4703541
10552: l_tax_rate_id_code_missing :=fnd_message.get_string('ZX','ZX_TAX_RATE_ID_CODE_MISSING' ); -- 4917256
10553: l_imp_tax_rate_amt_mismatch :=fnd_message.get_string('ZX','ZX_IMP_TAX_RATE_AMT_MISMATCH');
10554:
10555: END ZX_VALIDATE_API_PKG;