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 FND_LOG

Line 8: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

4: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
5: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
6:
7: g_current_runtime_level NUMBER;
8: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
9: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
11: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 9: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

5: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
6:
7: g_current_runtime_level NUMBER;
8: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
9: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
11: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
13: g_first_pty_org_id NUMBER;

Line 10: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

6:
7: g_current_runtime_level NUMBER;
8: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
9: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
11: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
13: g_first_pty_org_id NUMBER;
14: l_le_id NUMBER;

Line 11: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

7: g_current_runtime_level NUMBER;
8: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
9: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
11: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
13: g_first_pty_org_id NUMBER;
14: l_le_id NUMBER;
15: l_ou_id NUMBER;

Line 12: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

8: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
9: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
11: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
13: g_first_pty_org_id NUMBER;
14: l_le_id NUMBER;
15: l_ou_id NUMBER;
16: l_regime_not_exists VARCHAR2(2000);

Line 163: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

159:
160: BEGIN
161:
162: x_return_status := FND_API.G_RET_STS_SUCCESS;
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',

Line 166: FND_LOG.STRING(g_level_procedure,

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

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 228: FND_LOG.STRING(g_level_exception,

224: WHERE rownum = 1;
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;

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 257: FND_LOG.STRING(g_level_exception,

253: -- all transactions and do not proceed further => Changes yet to be implemented
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;

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 430: FND_LOG.STRING(g_level_statement,

426: l_error_rec.interface_line_entity_code,
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',

Line 433: FND_LOG.STRING(g_level_statement,

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);
436: FND_LOG.STRING(g_level_statement,
437: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 436: FND_LOG.STRING(g_level_statement,

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);
439: FND_LOG.STRING(g_level_statement,
440: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 439: FND_LOG.STRING(g_level_statement,

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);
442: FND_LOG.STRING(g_level_statement,
443: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 442: FND_LOG.STRING(g_level_statement,

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);
445: FND_LOG.STRING(g_level_statement,
446: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 445: FND_LOG.STRING(g_level_statement,

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);
448: FND_LOG.STRING(g_level_statement,
449: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 448: FND_LOG.STRING(g_level_statement,

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);
451: FND_LOG.STRING(g_level_statement,
452: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 451: FND_LOG.STRING(g_level_statement,

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);
454: FND_LOG.STRING(g_level_statement,
455: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 454: FND_LOG.STRING(g_level_statement,

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);
457: FND_LOG.STRING(g_level_statement,
458: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 457: FND_LOG.STRING(g_level_statement,

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);
460: FND_LOG.STRING(g_level_statement,
461: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 460: FND_LOG.STRING(g_level_statement,

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);
463: END LOOP;
464: CLOSE check_error;

Line 470: FND_LOG.STRING(g_level_statement,

466:
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:

Line 476: FND_LOG.STRING(g_level_procedure,

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
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:

Line 485: FND_LOG.STRING(g_level_unexpected,

481: EXCEPTION
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;

Line 543: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

539:
540: BEGIN
541:
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(+)');

Line 545: FND_LOG.STRING(g_level_procedure,

541:
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:

Line 552: FND_LOG.STRING(g_level_statement,

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
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:

Line 588: FND_LOG.STRING(g_level_statement,

584: AND trx_line_id = l_trx_line_id_tbl(i)
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;

Line 606: FND_LOG.STRING(g_level_statement,

602: -- Defaulting Tax Date and Subscription Date
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:

Line 652: FND_LOG.STRING(g_level_statement,

648: AND ROWNUM = 1 -- To Prevent more than one row being fetched for a single row update
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:

Line 658: FND_LOG.STRING(g_level_statement,

654: 'Records updated : '||SQL%ROWCOUNT);
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:

Line 719: FND_LOG.STRING(g_level_statement,

715: )
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:

Line 725: FND_LOG.STRING(g_level_statement,

721: 'Records updated : '||SQL%ROWCOUNT);
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:

Line 785: FND_LOG.STRING(g_level_statement,

781: )
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:

Line 792: FND_LOG.STRING(g_level_statement,

788: END IF;
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:

Line 806: FND_LOG.STRING(g_level_statement,

802: )
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:

Line 823: FND_LOG.STRING(g_level_statement,

819: -- If customer has populated this column in interface tables need not default it again.
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:

Line 945: FND_LOG.STRING(g_level_statement,

941: WHERE TaxLines.tax_rate_code IS NOT NULL
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:

Line 954: FND_LOG.STRING(g_level_statement,

950: -- This Update is to Ensure that the regime and tax get defaulted in case rate code is null and rate id being passed
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:

Line 1079: FND_LOG.STRING(g_level_statement,

1075: AND TaxLines.tax_rate_id IS NOT NULL
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

Line 1090: FND_LOG.STRING(g_level_statement,

1086: -- Execute this query only if tax_status_code is null
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:

Line 1223: FND_LOG.STRING(g_level_statement,

1219: WHERE tax_status_code is NULL AND
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;

Line 1234: FND_LOG.STRING(g_level_statement,

1230: -- If customer has populated the same in interface tables need not default again.
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:

Line 1319: FND_LOG.STRING(g_level_statement,

1315: WHERE tax_provider_id is NULL AND
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;

Line 1336: FND_LOG.STRING(g_level_statement,

1332: --IF l_count_jur_null = 0 THEN
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:

Line 1447: FND_LOG.STRING(g_level_statement,

1443: WHERE tax_jurisdiction_code is NULL AND
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;

Line 1458: FND_LOG.STRING(g_level_statement,

1454: --Bug 4703541 : Seperated Logic to Default Rates and the Jurisdiction Code.
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:

Line 1592: FND_LOG.STRING(g_level_statement,

1588: AND ROWNUM =1 -- To Prevent more than one row being fetched for a single row update
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:

Line 1601: FND_LOG.STRING(g_level_statement,

1597: -- Execute this query only when tax_rate_id is not null
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:

Line 1710: FND_LOG.STRING(g_level_statement,

1706: TaxLines.tax_rate_id IS NULL OR
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;

Line 1719: FND_LOG.STRING(g_level_statement,

1715:
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;

Line 1731: FND_LOG.STRING(g_level_statement,

1727: -- CR 3275391 Default tax amount if it is NULL and tax rate is specified --
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;

Line 1910: FND_LOG.STRING(g_level_statement,

1906:
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:

Line 1918: FND_LOG.STRING(g_level_procedure,

1914:
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:

Line 1926: FND_LOG.STRING(g_level_unexpected,

1922:
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;

Line 2218: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2214: FROM zx_trx_tax_link_gt;
2215:
2216: 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(+)');

Line 2220: FND_LOG.STRING(g_level_procedure,

2216: 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:

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 2231: -- Select the key columns and write into fnd log for debug purpose

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
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:

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 2251: FND_LOG.STRING(g_level_statement,

2247:
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',

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 2671: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2667: and header.event_class_code = evntmap.event_class_code(+)
2668: and fnd_terr.territory_code(+) = header.default_taxation_country;
2669:
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) );

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 2679: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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 **/
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;

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 4694: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4690: --Commented for Bug#7504455--
4691: --and rates.tax_rate_code(+) = NVL(lines_gt.output_tax_classification_code,
4692: -- lines_gt.input_tax_classification_code);
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) );

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 4704: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4700:
4701: /******************** End of Logic for Header/Line Validations *************************/
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;

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 4710: -- Select the key columns and write into fnd log for debug purpose

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
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;

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 4729: FND_LOG.STRING(g_level_statement,

4725:
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',

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 5632: FND_LOG.STRING(g_level_statement,

5628:
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',

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 7300: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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;
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');

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 8020: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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;
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');

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 8275: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

8271: AND rate.tax_rate_code = off_rate.offset_tax_rate_code(+)
8272: AND off_rate.tax_rate_code = temp_gt.tax_rate_code(+)
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;

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 8282: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

8278: 'No. of Rows inserted : '|| to_char(sql%ROWCOUNT) );
8279: END IF;
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;

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 8288: -- Select the key columns and write into fnd log for debug purpose

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
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;

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 8307: FND_LOG.STRING(g_level_statement,

8303:
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',

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 8433: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

8429: ELSE NULL
8430: END ZX_INVALID_SUMMARY_TAX_LINE_ID
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;

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 8446: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

8442: SET validation_check_flag = 'N'
8443: WHERE trx_id IN (SELECT trx_id FROM zx_validation_errors_gt);
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;

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 8454: FND_LOG.STRING(g_level_procedure,

8450: END IF;
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:

Line 8475: FND_LOG.STRING(g_level_unexpected,

8471: CLOSE get_tax_link_gt_info_csr;
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;

Line 8515: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

8511: AND lines_gt.trx_id = header.trx_id;
8512:
8513: BEGIN
8514:
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',

Line 8518: FND_LOG.STRING(g_level_event,

8514:
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:

Line 8523: -- Select the key columns and write into fnd log for debug purpose

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
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');

Line 8525: FND_LOG.STRING(g_level_statement,

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
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

Line 8542: FND_LOG.STRING(g_level_statement,

8538:
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',

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 8570: FND_LOG.STRING(g_level_statement,

8566: l_trx_level_type_tbl.delete;
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:

Line 9004: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

9000: AND lines_gt.entity_code = header.entity_code
9001: AND lines_gt.event_class_code = header.event_class_code
9002: AND lines_gt.trx_id = header.trx_id;
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) );

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 9012: FND_LOG.STRING(g_level_event,

9008: 'No. of Rows inserted : '|| to_char(sql%ROWCOUNT) );
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:

Line 9023: FND_LOG.STRING(g_level_unexpected,

9019: IF get_other_doc_info_csr%ISOPEN THEN
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:

Line 9176: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

9172: AND L.output_tax_classification_code IS NULL ;
9173:
9174: BEGIN
9175:
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',

Line 9179: FND_LOG.STRING(g_level_statement,

9175:
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:

Line 9191: FND_LOG.STRING(g_level_statement,

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

Line 9247: FND_LOG.STRING(g_level_procedure,

9243:
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:

Line 9324: FND_LOG.STRING(g_level_statement,

9320: --
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

Line 9361: FND_LOG.STRING(g_level_statement,

9357: -- update zx_transaction_lines_gt with the default
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:

Line 9378: FND_LOG.STRING(g_level_procedure,

9374: AND trx_line_id = l_trx_line_id_tbl(i)
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

Line 9397: FND_LOG.STRING(g_level_procedure,

9393: RETURN;
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',

Line 9400: FND_LOG.STRING(g_level_procedure,

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);
9403: FND_LOG.STRING(g_level_procedure,
9404: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.POP_DEF_TAX_CLASSIF_CODE.END',

Line 9403: FND_LOG.STRING(g_level_procedure,

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(-)');
9406: END IF;
9407:

Line 9420: FND_LOG.STRING(g_level_unexpected,

9416: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','POP_DEF_TAX_CLASSIF_CODE - '|| l_error_buffer);
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:

Line 9868: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

9864:
9865:
9866: BEGIN
9867:
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',

Line 9871: FND_LOG.STRING(g_level_event,

9867:
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:

Line 9880: FND_LOG.STRING(g_level_statement,

9876: /** Bug 4703541 :
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:

Line 9889: FND_LOG.STRING(g_level_statement,

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

Line 10292: FND_LOG.STRING(G_LEVEL_EVENT,

10288: l_event_class_rec.RNDG_BILL_FROM_PARTY_SITE_ID := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RNDG_BILL_FROM_PARTY_SITE_ID(i) ;
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: '||

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 10322: FND_LOG.STRING(g_level_statement,

10318: END IF;
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:

Line 10337: FND_LOG.STRING(g_level_statement,

10333: x_return_status
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:

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 10366: FND_LOG.STRING(g_level_statement,

10362:
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:

Line 10436: FND_LOG.STRING(g_level_event,

10432: END LOOP;
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:

Line 10454: FND_LOG.STRING(g_level_unexpected,

10450: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','def_additional_tax_attribs- '|| l_error_buffer);
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: