eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_VALID_INIT_PARAMS_PKG dependencies on FND_LOG

Line 10: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

6: | Global Data Types |
7: * ======================================================================*/
8:
9: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_VALID_INIT_PARAMS_PKG';
10: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
11: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
13: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
14: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

Line 11: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

7: * ======================================================================*/
8:
9: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_VALID_INIT_PARAMS_PKG';
10: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
11: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
13: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
14: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
15: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 12: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

8:
9: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_VALID_INIT_PARAMS_PKG';
10: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
11: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
13: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
14: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
15: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
16: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 13: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

9: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_VALID_INIT_PARAMS_PKG';
10: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
11: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
13: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
14: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
15: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
16: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
17: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_VALID_INIT_PARAMS_PKG.';

Line 14: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

10: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
11: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
13: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
14: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
15: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
16: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
17: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_VALID_INIT_PARAMS_PKG.';
18: NULL_EVENT_CLASS_REC ZX_API_PUB.event_class_rec_type;

Line 15: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

11: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
13: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
14: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
15: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
16: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
17: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_VALID_INIT_PARAMS_PKG.';
18: NULL_EVENT_CLASS_REC ZX_API_PUB.event_class_rec_type;
19:

Line 16: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

12: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
13: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
14: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
15: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
16: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
17: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_VALID_INIT_PARAMS_PKG.';
18: NULL_EVENT_CLASS_REC ZX_API_PUB.event_class_rec_type;
19:
20: /*----------------------------------------------------------------------------*

Line 67: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

63: l_index NUMBER;
64:
65: BEGIN
66: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
67: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
68: END IF;
69:
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71:

Line 91: FND_LOG.STRING(

87: END IF;
88:
89:
90: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
91: FND_LOG.STRING(
92: G_LEVEL_STATEMENT,
93: G_MODULE_NAME||l_api_name||'.END',
94: G_PKG_NAME||': '||l_api_name||'()-'||
95: ' Ship from Location = ' || to_char(x_ship_from_location_id)||

Line 106: FND_LOG.STRING(

102: EXCEPTION
103: WHEN OTHERS THEN
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
106: FND_LOG.STRING(
107: G_LEVEL_UNEXPECTED,
108: G_MODULE_NAME||l_api_name,
109: 'No lines exist in zx_transaction_lines_gt which '||
110: 'is incorrect or the event information in headers and lines is incorrect.' ||

Line 142: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

138: l_context_info_rec ZX_API_PUB.context_info_rec_type;
139:
140: BEGIN
141: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
142: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
143: END IF;
144:
145: x_return_status := FND_API.G_RET_STS_SUCCESS;
146:

Line 172: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

168: );
169: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
170: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
171: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
172: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
173: 'Error: Unable to return rdng_ship_to_pty_tx_prof_id for rounding_ship_to_party_id : ' || to_char(p_event_class_rec.rounding_ship_to_party_id));
174: END IF;
175: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
176: l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;

Line 198: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

194:
195: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
196: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
197: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
198: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
199: 'Error: Unable to return rdng_ship_from_pty_tx_prof_id for rounding_ship_from_party_id : ' || to_char(p_event_class_rec.rounding_ship_from_party_id));
200: END IF;
201: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
202: l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;

Line 224: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

220:
221: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
222: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
223: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
224: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
225: 'Error: Unable to return rdng_ship_to_pty_tx_p_st_id for rndg_ship_to_party_site_id : ' || to_char(p_event_class_rec.rndg_ship_to_party_site_id));
226: END IF;
227: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
228: l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;

Line 249: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

245: );
246: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
247: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
248: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
249: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
250: 'Error: Unable to return rdng_ship_from_pty_tx_p_st_id for rndg_ship_from_party_site_id : ' || to_char(p_event_class_rec.rndg_ship_from_party_site_id));
251: END IF;
252: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
253: l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;

Line 278: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

274:
275: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
276: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
277: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
278: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
279: 'Error: Unable to return rdng_bill_to_pty_tx_prof_id for rounding_bill_to_party_id : ' || to_char(p_event_class_rec.rounding_bill_to_party_id));
280: END IF;
281: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
282: l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;

Line 310: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

306:
307: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
308: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
309: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
310: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
311: 'Error: Unable to return rdng_bill_from_pty_tx_prof_id for rounding_bill_from_party_id : ' || to_char(p_event_class_rec.rounding_bill_from_party_id));
312: END IF;
313: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
314: l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;

Line 342: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

338:
339: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
340: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
341: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
342: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
343: 'Error: Unable to return rdng_bill_to_pty_tx_p_st_id for rndg_bill_to_party_site_id : ' || to_char(p_event_class_rec.rndg_bill_to_party_site_id));
344: END IF;
345: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
346: l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;

Line 374: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

370:
371: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
372: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
373: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
374: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
375: 'Error: Unable to return rdng_bill_from_pty_tx_p_st_id for rndg_bill_from_party_site_id : ' || to_char(p_event_class_rec.rndg_bill_from_party_site_id));
376: END IF;
377: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
378: l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;

Line 392: FND_LOG.STRING(G_LEVEL_STATEMENT,

388: END IF;
389: END IF;
390:
391: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
392: FND_LOG.STRING(G_LEVEL_STATEMENT,
393: G_MODULE_NAME||l_api_name||'.END',
394: G_PKG_NAME||': '||l_api_name||'()-' ||
395: ', RETURN_STATUS = ' || x_return_status);
396: END IF;

Line 422: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

418: l_effective_date DATE;
419:
420: BEGIN
421: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
422: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
423: END IF;
424:
425: IF p_related_doc_date is NOT NULL THEN
426: l_effective_date := p_related_doc_date;

Line 436: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');

432: l_effective_date := p_trx_date;
433: END IF;
434:
435: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
436: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
437: END IF;
438:
439: RETURN l_effective_date;
440: END get_effective_date;

Line 468: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

464: l_trx_line_date DATE;
465:
466: BEGIN
467: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
468: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
469: END IF;
470:
471: x_return_status := FND_API.G_RET_STS_SUCCESS;
472:

Line 514: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||

510: NVL(l_trx_line_date,p_event_class_rec.trx_date)
511: );
512:
513: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
514: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||
515: '.END',G_PKG_NAME||': '||l_api_name||'()-'||
516: ', Adjusted doc date = ' || l_adj_doc_date||
517: ', Trx Line date = ' || l_trx_line_date||
518: ', x_effective_date = ' || x_effective_date||

Line 528: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,

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

Line 561: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

557: l_api_name CONSTANT VARCHAR2(30) := 'POPULATE_EVENT_CLASS_OPTIONS';
558:
559: BEGIN
560: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
561: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
562: END IF;
563:
564: x_return_status := FND_API.G_RET_STS_SUCCESS;
565: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

Line 749: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.END',

745: null;
746: END;
747:
748: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
749: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.END',
750: G_PKG_NAME||': '||l_api_name||'()-'||
751: ' RETURN_STATUS = ' || x_return_status);
752: END IF;
753:

Line 760: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);

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

Line 789: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

785: l_application_id NUMBER;
786:
787: BEGIN
788: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
789: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
790: END IF;
791:
792: x_return_status := FND_API.G_RET_STS_SUCCESS;
793:

Line 840: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Incorrect return status after calling '||

836:
837: IF x_return_status = FND_API.G_RET_STS_ERROR then
838:
839: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
840: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Incorrect return status after calling '||
841: 'ZX_GLOBAL_STRUCTURES_PKG.get_product_options_info');
842: END IF;
843:
844: ELSE

Line 857: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.END',

853: p_event_class_rec.HOME_COUNTRY_DEFAULT_FLAG := l_zx_product_options_rec.home_country_default_flag;
854: END IF;
855:
856: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
857: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.END',
858: G_PKG_NAME||': '||l_api_name||'()-'||
859: ', RETURN_STATUS = ' || x_return_status);
860: END IF;
861:

Line 868: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);

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

Line 904: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

900: l_index binary_integer;
901:
902: BEGIN
903: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
904: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
905: END IF;
906:
907: x_return_status := FND_API.G_RET_STS_SUCCESS;
908:

Line 941: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,

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

Line 959: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||

955: END IF;
956:
957:
958: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
959: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||
960: '.END',G_PKG_NAME||': '||l_api_name||'()-' ||
961: ', RETURN_STATUS = ' || x_return_status);
962: END IF;
963:

Line 968: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,

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

Line 996: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

992: l_index BINARY_INTEGER;
993:
994: BEGIN
995: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
996: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
997: END IF;
998:
999: x_return_status := FND_API.G_RET_STS_SUCCESS;
1000:

Line 1238: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,

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

Line 1522: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||

1518: null;
1519: END;
1520:
1521: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1522: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||
1523: '.END',G_PKG_NAME||': '||l_api_name||'()-'||
1524: ', RETURN_STATUS = ' || x_return_status);
1525: END IF;
1526:

Line 1531: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,

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

Line 1572: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

1568: l_tax_event_type_code ZX_EVNT_TYP_MAPPINGS.TAX_EVENT_CLASS_CODE%TYPE;
1569:
1570: BEGIN
1571: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1572: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1573: END IF;
1574:
1575: x_return_status := FND_API.G_RET_STS_SUCCESS;
1576:

Line 1593: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

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

Line 1616: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,

1612: IF ZX_GLOBAL_STRUCTURES_PKG.g_zx_evnt_cls_typs_tbl.exists(l_index2) THEN
1613: x_doc_status := ZX_GLOBAL_STRUCTURES_PKG.g_zx_evnt_cls_typs_tbl(l_index2);
1614: ELSE
1615: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1616: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,
1617: ' Unable to derive doc_event_status. Please Check!');
1618: END IF;
1619: END IF;
1620: END IF;

Line 1625: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||

1621:
1622: END IF;
1623:
1624: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1625: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||
1626: '.END',G_PKG_NAME||': '||l_api_name||'()-'||
1627: ', Tax Event Type = ' || x_tx_evnt_typ_code ||
1628: ', Doc Event Status = ' || x_doc_status ||
1629: ', RETURN_STATUS = ' || x_return_status);

Line 1637: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);

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

Line 1667: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

1663: l_first_pty_org_id NUMBER;
1664:
1665: BEGIN
1666: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1667: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1668: END IF;
1669:
1670: l_first_pty_org_id := ZX_SECURITY.G_FIRST_PARTY_ORG_ID ;
1671:

Line 1693: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1689: END IF;
1690:
1691: IF nvl(l_first_pty_org_id,-1087) <> nvl(ZX_SECURITY.G_FIRST_PARTY_ORG_ID,-1087) THEN
1692: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1693: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1694: 'First Party org_id has changed. Old first_pty_org_id = '||to_char(l_first_pty_org_id)||
1695: ', New first_pty_org_id = '||to_char(ZX_SECURITY.G_FIRST_PARTY_ORG_ID)||
1696: '. Initializing Tax, Status and Rate cache..');
1697: END IF;

Line 1708: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||

1704:
1705: p_event_class_rec.first_pty_org_id := ZX_SECURITY.G_FIRST_PARTY_ORG_ID ;
1706:
1707: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1708: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||
1709: '.END',G_PKG_NAME||': '||l_api_name||'()-'||
1710: ', RETURN_STATUS = ' || l_return_status);
1711: END IF;
1712: END get_tax_subscriber;

Line 1747: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

1743: l_context_info_rec ZX_API_PUB.context_info_rec_type;
1744:
1745: BEGIN
1746: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1747: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1748: END IF;
1749:
1750: x_return_status := FND_API.G_RET_STS_SUCCESS;
1751:

Line 1776: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1772: --Bugfix 4486946 -Call on the fly upgrade if the transaction if not found
1773: EXCEPTION
1774: WHEN NO_DATA_FOUND THEN
1775: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1776: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1777: 'Call on-the-fly upgrade since transaction does not exist in repository for trx id: '||to_char(p_event_class_rec.trx_id));
1778: END IF;
1779: l_upg_trx_info_rec.application_id := p_event_class_rec.application_id;
1780: l_upg_trx_info_rec.entity_code := p_event_class_rec.entity_code;

Line 1788: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly returned errors');

1784: x_return_status => l_return_status
1785: );
1786: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1787: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1788: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly returned errors');
1789: END IF;
1790: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1791: RAISE FND_API.G_EXC_ERROR;
1792: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1825: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1821: );
1822:
1823: IF nvl(p_event_class_rec.first_pty_org_id,-1087) <> nvl(ZX_SECURITY.G_FIRST_PARTY_ORG_ID,-1087) THEN
1824: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1825: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1826: 'First Party org_id has changed. Old first_pty_org_id = '||to_char(ZX_SECURITY.G_FIRST_PARTY_ORG_ID)||
1827: ', New first_pty_org_id = '||to_char(p_event_class_rec.first_pty_org_id)||
1828: '. Initializing Tax, Status and Rate cache..');
1829: END IF;

Line 1858: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||

1854: RETURN;
1855: END IF;
1856:
1857: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1858: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||
1859: '.END',G_PKG_NAME||': '||l_api_name||'()-' ||
1860: ', RETURN_STATUS = ' || l_return_status);
1861: END IF;
1862:

Line 1867: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,

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

Line 1905: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

1901: l_context_info_rec ZX_API_PUB.context_info_rec_type;
1902:
1903: BEGIN
1904: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1905: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1906: END IF;
1907:
1908: x_return_status := FND_API.G_RET_STS_SUCCESS;
1909: BEGIN

Line 1931: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1927: --Bugfix 4486946 -Call on the fly upgrade if the transaction if not found
1928: EXCEPTION
1929: WHEN NO_DATA_FOUND THEN
1930: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1931: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1932: 'Call on-the-fly upgrade since transaction does not exist in repository for trx id: '||to_char(p_trx_id));
1933: END IF;
1934: l_upg_trx_info_rec.application_id := p_application_id;
1935: l_upg_trx_info_rec.entity_code := p_entity_code;

Line 1943: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly returned errors');

1939: x_return_status => l_return_status
1940: );
1941: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1942: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1943: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly returned errors');
1944: END IF;
1945: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1946: RAISE FND_API.G_EXC_ERROR;
1947: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1995: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||

1991: RETURN;
1992: END IF;
1993:
1994: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1995: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||
1996: '.END',G_PKG_NAME||': '||l_api_name||'()-'||
1997: ', RETURN_STATUS = ' || l_return_status);
1998: END IF;
1999:

Line 2004: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,

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

Line 2042: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

2038: l_context_info_rec ZX_API_PUB.context_info_rec_type;
2039:
2040: BEGIN
2041: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2042: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2043: END IF;
2044:
2045: x_return_status := FND_API.G_RET_STS_SUCCESS;
2046:

Line 2093: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2089: --Bugfix 4486946 -Call on the fly upgrade if the transaction if not found
2090: EXCEPTION
2091: WHEN NO_DATA_FOUND THEN
2092: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2093: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2094: 'Call on-the-fly upgrade since transaction does not exist in repository for trx id: '||to_char(p_event_class_rec.trx_id));
2095: END IF;
2096: l_upg_trx_info_rec.application_id := p_event_class_rec.application_id;
2097: l_upg_trx_info_rec.entity_code := p_event_class_rec.entity_code;

Line 2105: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly returned errors');

2101: x_return_status => l_return_status
2102: );
2103: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2104: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2105: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly returned errors');
2106: END IF;
2107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2108: RAISE FND_API.G_EXC_ERROR;
2109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2179: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||

2175: RETURN;
2176: END IF;
2177:
2178: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2179: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||
2180: '.END',G_PKG_NAME||': '||l_api_name||'()-' ||
2181: ', RETURN_STATUS = ' || l_return_status);
2182: END IF;
2183:

Line 2188: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,

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

Line 2220: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

2216: l_record_flag VARCHAR2(1);
2217:
2218: BEGIN
2219: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2220: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2221: END IF;
2222:
2223: x_return_status := FND_API.G_RET_STS_SUCCESS;
2224:

Line 2239: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||

2235: END IF;
2236: END IF;
2237:
2238: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2239: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||
2240: '.END',G_PKG_NAME||': '||l_api_name||'()-' ||
2241: ', Record Flag = ' || l_record_flag ||
2242: ', RETURN_STATUS = ' || x_return_status);
2243:

Line 2252: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);

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

Line 2282: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

2278: l_bill_to_location_id NUMBER;
2279:
2280: BEGIN
2281: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2282: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2283: END IF;
2284:
2285: x_return_status := FND_API.G_RET_STS_SUCCESS;
2286: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

Line 2435: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2431: END IF;
2432: END IF;
2433:
2434: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2435: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2436: ' application_id: '||p_event_class_rec.application_id||
2437: ', entity_code: '||p_event_class_rec.entity_code||
2438: ', event_class_code: '||p_event_class_rec.event_class_code||
2439: ', internal_organization_id: '||p_event_class_rec.internal_organization_id||

Line 2527: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');

2523: ', RETURN_STATUS = ' || x_return_status);
2524: END IF;
2525:
2526: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2527: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
2528: END IF;
2529: END calculate_tax;
2530:
2531: -----------------------------------------------------------------------

Line 2555: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

2551: l_bill_to_location_id NUMBER;
2552:
2553: BEGIN
2554: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2555: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2556: END IF;
2557:
2558: x_return_status := FND_API.G_RET_STS_SUCCESS;
2559: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

Line 2585: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' Populate Application product options');

2581: /* ----------------------------------------------------------------------+
2582: | Populate Application Product Options |
2583: + ----------------------------------------------------------------------*/
2584: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2585: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' Populate Application product options');
2586: END IF;
2587:
2588: populate_appl_product_options(l_return_status,
2589: p_event_class_rec

Line 2601: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2597: -- populate global event class record structure
2598: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := p_event_class_rec;
2599:
2600: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2601: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2602: 'application_id: '||p_event_class_rec.application_id||
2603: ', entity_code: '||p_event_class_rec.entity_code||
2604: ', event_class_code: '||p_event_class_rec.event_class_code||
2605: ', internal_organization_id: '||p_event_class_rec.internal_organization_id||

Line 2659: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');

2655: ', header_level_currency_flag: '||p_event_class_rec.header_level_currency_flag||
2656: ', RETURN_STATUS = ' || x_return_status);
2657: END IF;
2658: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2659: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
2660: END IF;
2661: END import_document_with_tax;
2662:
2663: -----------------------------------------------------------------------

Line 2689: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

2685: l_bill_to_location_id NUMBER;
2686:
2687: BEGIN
2688: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2689: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2690: END IF;
2691:
2692: x_return_status := FND_API.G_RET_STS_SUCCESS;
2693: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

Line 2793: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Override Level is required');

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

Line 2803: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2799:
2800: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := p_event_class_rec;
2801:
2802: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2803: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2804: 'application_id: '||p_event_class_rec.application_id||
2805: ', entity_code: '||p_event_class_rec.entity_code||
2806: ', event_class_code: '||p_event_class_rec.event_class_code||
2807: ', internal_organization_id: '||p_event_class_rec.internal_organization_id||

Line 2873: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');

2869: ', exmptn_pty_basis_hier_2_code: '||p_event_class_rec.exmptn_pty_basis_hier_2_code||
2870: ', RETURN_STATUS = ' || x_return_status);
2871: END IF;
2872: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2873: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
2874: END IF;
2875: END override_tax;
2876:
2877: -----------------------------------------------------------------------

Line 2898: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

2894: l_ref_appln_id NUMBER;
2895:
2896: BEGIN
2897: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2898: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2899: END IF;
2900:
2901: x_return_status := FND_API.G_RET_STS_SUCCESS;
2902: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

Line 2918: -- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' Call GET_TAX_SUBSCRIBER');

2914: /* ----------------------------------------------------------------------+
2915: | Bug 3129063 - Setting the Security Context for Subscription |
2916: + ----------------------------------------------------------------------*/
2917: --IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2918: -- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' Call GET_TAX_SUBSCRIBER');
2919: -- END IF;
2920:
2921: --get_tax_subscriber(p_event_class_rec,
2922: -- l_return_status

Line 2985: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2981: -- populate global event class record structure
2982: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := p_event_class_rec;
2983:
2984: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2985: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2986: 'application_id: '||p_event_class_rec.application_id||
2987: ', entity_code: '||p_event_class_rec.entity_code||
2988: ', event_class_code: '||p_event_class_rec.event_class_code||
2989: ', event_type_code: '||p_event_class_rec.event_type_code||

Line 2997: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');

2993: ', doc_event_status: '||p_event_class_rec.doc_status_code||
2994: ', RETURN_STATUS = ' || x_return_status);
2995: END IF;
2996: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2997: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
2998: END IF;
2999: END global_document_update;
3000:
3001:

Line 3016: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

3012: l_return_status VARCHAR2(30);
3013:
3014: BEGIN
3015: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3016: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3017: END IF;
3018:
3019: x_return_status := FND_API.G_RET_STS_SUCCESS;
3020:

Line 3049: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

3045: RETURN;
3046: END IF;
3047:
3048: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3049: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3050: 'application_id: '||p_transaction_line_rec.application_id||
3051: ', entity_code: '||p_transaction_line_rec.entity_code||
3052: ', event_class_code: '||p_transaction_line_rec.event_class_code||
3053: ', event_type_code: '||p_transaction_line_rec.event_type_code||

Line 3063: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');

3059: ', doc_trx_line_id: '||p_transaction_line_rec.trx_line_id||
3060: ', RETURN_STATUS = ' || x_return_status);
3061: END IF;
3062: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3063: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
3064: END IF;
3065: END mark_tax_lines_deleted;
3066:
3067: -----------------------------------------------------------------------

Line 3091: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

3087: l_ref_appln_id NUMBER;
3088:
3089: BEGIN
3090: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3091: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3092: END IF;
3093:
3094: x_return_status := FND_API.G_RET_STS_SUCCESS;
3095: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

Line 3113: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' Get tax event class');

3109: FROM ZX_REV_TRX_HEADERS_GT
3110: WHERE rownum = 1;
3111:
3112: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3113: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' Get tax event class');
3114: END IF;
3115:
3116: /* -----------------------------------------------------------------------+
3117: | Bug 3129063 Setting the Security Context for Subscription |

Line 3149: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

3145: -- populate global event class record structure
3146: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := p_event_class_rec;
3147:
3148: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3149: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3150: 'application_id: '||l_appln_id||
3151: ', entity_code: '||l_entity_code||
3152: ', event_class_code: '||l_evnt_cls_code||
3153: ', tax_event_class_code: '||l_tx_evnt_cls_code||

Line 3158: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');

3154: ', reference_application_id: '||l_ref_appln_id||
3155: ', RETURN_STATUS = ' || x_return_status);
3156: END IF;
3157: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3158: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
3159: END IF;
3160:
3161: END reverse_document;
3162:

Line 3194: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

3190:
3191: BEGIN
3192:
3193: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3194: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3195: END IF;
3196:
3197: x_return_status := FND_API.G_RET_STS_SUCCESS;
3198: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

Line 3249: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

3245: END IF;
3246:
3247:
3248: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3249: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3250: 'application_id: '||l_appln_id||
3251: ', entity_code: '||l_entity_code||
3252: ', event_class_code: '||l_evnt_cls_code||
3253: ', tax_event_class_code: '||l_tx_evnt_cls_code||

Line 3259: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');

3255: ', RETURN_STATUS = ' || x_return_status);
3256: END IF;
3257:
3258: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3259: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
3260: END IF;
3261: END reverse_distributions;
3262:
3263: -----------------------------------------------------------------------

Line 3282: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

3278: l_return_status VARCHAR2(30);
3279:
3280: BEGIN
3281: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3282: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3283: END IF;
3284:
3285: x_return_status := FND_API.G_RET_STS_SUCCESS;
3286: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

Line 3305: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

3301: -- populate global event class record structure
3302: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := p_event_class_rec;
3303:
3304: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3305: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3306: 'application_id: '||p_event_class_rec.application_id||
3307: ', entity_code: '||p_event_class_rec.entity_code||
3308: ', event_class_code: '||p_event_class_rec.event_class_code||
3309: ', internal_organization_id: '||p_event_class_rec.internal_organization_id||

Line 3320: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');

3316: ', doc_status_code: '||p_event_class_rec.doc_status_code||
3317: ', RETURN_STATUS = ' || x_return_status);
3318: END IF;
3319: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3320: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
3321: END IF;
3322: END determine_recovery;
3323:
3324: -----------------------------------------------------------------------

Line 3344: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

3340: l_return_status VARCHAR2(30);
3341:
3342: BEGIN
3343: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3344: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3345: END IF;
3346:
3347: x_return_status := FND_API.G_RET_STS_SUCCESS;
3348: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

Line 3441: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

3437: -- populate global event class record structure
3438: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := p_event_class_rec;
3439:
3440: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3441: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3442: 'application_id: '||p_event_class_rec.application_id||
3443: ', entity_code: '||p_event_class_rec.entity_code||
3444: ', event_class_code: '||p_event_class_rec.event_class_code||
3445: ', legal_entity_id: '||p_event_class_rec.legal_entity_id||

Line 3456: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');

3452: ', quote_flag: '||p_event_class_rec.quote_flag||
3453: ', RETURN_STATUS = ' || x_return_status);
3454: END IF;
3455: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3456: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
3457: END IF;
3458: END override_recovery;
3459:
3460: -----------------------------------------------------------------------

Line 3481: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

3477: l_ref_appln_id NUMBER;
3478:
3479: BEGIN
3480: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3481: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3482: END IF;
3483:
3484: x_return_status := FND_API.G_RET_STS_SUCCESS;
3485: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

Line 3557: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

3553: -- populate global event class record structure
3554: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := p_event_class_rec;
3555:
3556: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3557: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3558: 'application_id: '||p_trx_rec.application_id||
3559: ', entity_code: '||p_trx_rec.entity_code||
3560: ', event_class_code: '||p_trx_rec.event_class_code||
3561: ', event_type_code: '||p_trx_rec.event_type_code||

Line 3569: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');

3565: ', doc_event_status: '||p_trx_rec.doc_event_status||
3566: ', RETURN_STATUS = ' || x_return_status);
3567: END IF;
3568: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3569: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
3570: END IF;
3571: END freeze_distribution_lines;
3572:
3573: -----------------------------------------------------------------------

Line 3595: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

3591: l_effective_date DATE;
3592:
3593: BEGIN
3594: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3595: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3596: END IF;
3597:
3598: x_return_status := FND_API.G_RET_STS_SUCCESS;
3599: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

Line 3730: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

3726: -- populate global event class record structure
3727: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := p_event_class_rec;
3728:
3729: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3730: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3731: 'application_id: '||p_event_class_rec.application_id||
3732: ', entity_code: '||p_event_class_rec.entity_code||
3733: ', event_class_code: '||p_event_class_rec.event_class_code||
3734: ', internal_organization_id: '||p_event_class_rec.internal_organization_id||

Line 3819: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');

3815: ', home_country_default_flag: '||p_event_class_rec.home_country_default_flag||
3816: ', RETURN_STATUS = ' || x_return_status);
3817: END IF;
3818: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3819: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
3820: END IF;
3821: END validate_document_for_tax;
3822:
3823:

Line 3843: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

3839: l_return_status VARCHAR2(30);
3840:
3841: BEGIN
3842: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3843: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3844: END IF;
3845:
3846: x_return_status := FND_API.G_RET_STS_SUCCESS;
3847:

Line 3877: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

3873: RETURN;
3874: END IF;
3875:
3876: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3877: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3878: 'application_id: '||p_trx_rec.application_id||
3879: ', entity_code: '||p_trx_rec.entity_code||
3880: ', event_class_code: '||p_trx_rec.event_class_code||
3881: ', event_type_code: '||p_trx_rec.event_type_code||

Line 3886: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');

3882: ', trx_id: '||p_trx_rec.trx_id||
3883: ', RETURN_STATUS = ' || x_return_status);
3884: END IF;
3885: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3886: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
3887: END IF;
3888: END discard_tax_only_lines;
3889:
3890:

Line 3919: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

3915: l_bill_to_location_id NUMBER;
3916:
3917: BEGIN
3918: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3919: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3920: END IF;
3921:
3922: x_return_status := FND_API.G_RET_STS_SUCCESS;
3923: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

Line 4056: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

4052: -- populate global event class record structure
4053: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := p_event_class_rec;
4054:
4055: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4056: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
4057: 'application_id: '||p_event_class_rec.application_id||
4058: ', entity_code: '||p_event_class_rec.entity_code||
4059: ', event_class_code: '||p_event_class_rec.event_class_code||
4060: ', internal_organization_id: '||p_event_class_rec.internal_organization_id||

Line 4146: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');

4142: ', RETURN_STATUS = ' || l_return_status);
4143: END IF;
4144:
4145: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4146: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
4147: END IF;
4148: END insupd_line_det_factors;
4149:
4150:

Line 4176: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

4172: l_bill_to_location_id NUMBER;
4173:
4174: BEGIN
4175: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4176: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
4177: END IF;
4178:
4179: x_return_status := FND_API.G_RET_STS_SUCCESS;
4180: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

Line 4268: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

4264: RETURN;
4265: END IF;
4266:
4267: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4268: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
4269: 'application_id: '||p_event_class_rec.application_id||
4270: ', entity_code: '||p_event_class_rec.entity_code||
4271: ', event_class_code: '||p_event_class_rec.event_class_code||
4272: ', internal_organization_id: '||p_event_class_rec.internal_organization_id||

Line 4358: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');

4354: ', RETURN_STATUS = ' || l_return_status);
4355: END IF;
4356:
4357: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4358: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
4359: END IF;
4360: END get_default_tax_det_attrs;
4361:
4362: PROCEDURE get_event_class_info(

Line 4461: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_VALID_INIT_PKG.get_evnt_cls_info',

4457:
4458: IF ZX_GLOBAL_STRUCTURES_PKG.g_zx_event_class_rec_tbl.EXISTS(l_index) then
4459:
4460: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4461: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_VALID_INIT_PKG.get_evnt_cls_info',
4462: 'Event class record found in cache ');
4463: END IF;
4464:
4465: X_TBL_INDEX := l_index;

Line 4546: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_VALID_INIT_PKG.get_evnt_cls_info',

4542: ZX_GLOBAL_STRUCTURES_PKG.g_zx_event_class_rec_tbl(l_index).ALLOW_EXEMPTIONS_FLAG := L_EVENT_CLASS_REC.ALLOW_EXEMPTIONS_FLAG ;
4543: ZX_GLOBAL_STRUCTURES_PKG.g_zx_event_class_rec_tbl(l_index).ENABLE_MRC_FLAG := L_EVENT_CLASS_REC.ENABLE_MRC_FLAG ;
4544:
4545: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4546: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_VALID_INIT_PKG.get_evnt_cls_info',
4547: 'Event class record not found in cache. Populating from database ');
4548: END IF;
4549:
4550: X_TBL_INDEX := l_index;

Line 4561: FND_LOG.STRING(g_level_unexpected,

4557: EXCEPTION
4558: WHEN OTHERS THEN
4559:
4560: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4561: FND_LOG.STRING(g_level_unexpected,
4562: 'ZX.PLSQL.ZX_VALID_INIT_PKG.get_evnt_cls_info',
4563: 'Exception in ZZX_VALID_INIT_PKG.get_evnt_cls_info. '||SQLCODE||SQLERRM);
4564: END IF;
4565:

Line 4613: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_VALID_INIT_PKG.get_evnt_cls_info',

4609:
4610: IF ZX_GLOBAL_STRUCTURES_PKG.g_zx_evnt_typ_map_tbl.EXISTS(l_index) then
4611:
4612: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4613: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_VALID_INIT_PKG.get_evnt_cls_info',
4614: 'Event type record found in cache ');
4615: END IF;
4616:
4617: X_TBL_INDEX := l_index;

Line 4635: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_VALID_INIT_PKG.get_evnt_typ_mappings_info',

4631: ZX_GLOBAL_STRUCTURES_PKG.g_zx_evnt_typ_map_tbl(l_index).TAX_EVENT_TYPE_CODE := l_event_type_rec.TAX_EVENT_TYPE_CODE;
4632: ZX_GLOBAL_STRUCTURES_PKG.g_zx_evnt_typ_map_tbl(l_index).ENABLED_FLAG := l_event_type_rec.ENABLED_FLAG;
4633:
4634: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4635: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_VALID_INIT_PKG.get_evnt_typ_mappings_info',
4636: 'Event type record not found in cache. Populating from database ');
4637: END IF;
4638:
4639: X_TBL_INDEX := l_index;

Line 4650: FND_LOG.STRING(g_level_unexpected,

4646: EXCEPTION
4647: WHEN OTHERS THEN
4648:
4649: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4650: FND_LOG.STRING(g_level_unexpected,
4651: 'ZX.PLSQL.ZX_VALID_INIT_PKG.get_evnt_typ_mappings_info',
4652: 'Exception in ZX_VALID_INIT_PKG.get_evnt_typ_mappings_info. '||SQLCODE||SQLERRM);
4653: END IF;
4654:

Line 4686: FND_LOG.STRING(g_level_unexpected,

4682:
4683: EXCEPTION
4684: WHEN OTHERS THEN
4685: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4686: FND_LOG.STRING(g_level_unexpected,
4687: 'ZX.PLSQL.ZX_VALID_INIT_PKG.populate_event_cls_typs',
4688: 'Exception in ZX_VALID_INIT_PKG.populate_event_cls_typs. '||SQLCODE||SQLERRM);
4689: END IF;
4690:

Line 4718: FND_LOG.STRING(g_level_unexpected,

4714:
4715: EXCEPTION
4716: WHEN OTHERS THEN
4717: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4718: FND_LOG.STRING(g_level_unexpected,
4719: 'ZX.PLSQL.ZX_VALID_INIT_PKG.populate_tax_event_class_info',
4720: 'Exception in ZX_VALID_INIT_PKG.populate_tax_event_class_info. '||SQLCODE||SQLERRM);
4721: END IF;
4722: