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 467: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

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

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

504: p_event_class_rec.trx_date
505: );
506:
507: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
508: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||
509: '.END',G_PKG_NAME||': '||l_api_name||'()-'||
510: ', Adjusted doc date = ' || l_adj_doc_date||
511: ', x_effective_date = ' || x_effective_date||
512: ', RETURN_STATUS = ' || x_return_status);

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

517: null;
518: WHEN OTHERS THEN
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
520: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
521: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
522: 'No lines exist in zx_transaction_lines_gt/zx_lines_det_factors'||
523: ' which is incorrect or the event information in headers and lines is incorrect.'||
524: SQLERRM);
525: END IF;

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

550: l_api_name CONSTANT VARCHAR2(30) := 'POPULATE_EVENT_CLASS_OPTIONS';
551:
552: BEGIN
553: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
554: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
555: END IF;
556:
557: x_return_status := FND_API.G_RET_STS_SUCCESS;
558: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

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

737: null;
738: END;
739:
740: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
741: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.END',
742: G_PKG_NAME||': '||l_api_name||'()-'||
743: ' RETURN_STATUS = ' || x_return_status);
744: END IF;
745:

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

748: NULL;
749: WHEN OTHERS THEN
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
751: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
752: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
753: END IF;
754: RETURN;
755: END populate_event_class_options;
756:

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

777: l_application_id NUMBER;
778:
779: BEGIN
780: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
781: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
782: END IF;
783:
784: x_return_status := FND_API.G_RET_STS_SUCCESS;
785:

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

828:
829: IF x_return_status = FND_API.G_RET_STS_ERROR then
830:
831: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
832: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Incorrect return status after calling '||
833: 'ZX_GLOBAL_STRUCTURES_PKG.get_product_options_info');
834: END IF;
835:
836: ELSE

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

845: p_event_class_rec.HOME_COUNTRY_DEFAULT_FLAG := l_zx_product_options_rec.home_country_default_flag;
846: END IF;
847:
848: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
849: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.END',
850: G_PKG_NAME||': '||l_api_name||'()-'||
851: ', RETURN_STATUS = ' || x_return_status);
852: END IF;
853:

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

856: NULL;
857: WHEN OTHERS THEN
858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
859: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
860: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
861: END IF;
862: END populate_appl_product_options;
863:
864: ----------------------------------------------------------------------

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

892: l_index binary_integer;
893:
894: BEGIN
895: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
896: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
897: END IF;
898:
899: x_return_status := FND_API.G_RET_STS_SUCCESS;
900:

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

929: IF L_INDEX IS NULL THEN
930:
931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
932: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
933: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
934: 'The event class information passed is incorrect. Please CHECK! '||SQLERRM);
935: END IF;
936:
937: ELSE

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

947: END IF;
948:
949:
950: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
951: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||
952: '.END',G_PKG_NAME||': '||l_api_name||'()-' ||
953: ', RETURN_STATUS = ' || x_return_status);
954: END IF;
955:

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

956: EXCEPTION
957: WHEN OTHERS THEN
958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
959: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
960: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
961: 'The event class information passed is incorrect. Please CHECK! '||SQLERRM);
962: END IF;
963: END get_tax_event_class;
964:

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

984: l_index BINARY_INTEGER;
985:
986: BEGIN
987: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
988: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
989: END IF;
990:
991: x_return_status := FND_API.G_RET_STS_SUCCESS;
992:

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

1212: IF L_INDEX IS NULL THEN
1213:
1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1215: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1216: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
1217: 'The event class information passed is incorrect. Please CHECK! '||SQLERRM);
1218: END IF;
1219:
1220: ELSE

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

1496: null;
1497: END;
1498:
1499: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1500: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||
1501: '.END',G_PKG_NAME||': '||l_api_name||'()-'||
1502: ', RETURN_STATUS = ' || x_return_status);
1503: END IF;
1504:

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

1505: EXCEPTION
1506: WHEN OTHERS THEN
1507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1508: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1509: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
1510: 'The event class information passed is incorrect. Please CHECK! ' ||
1511: SQLERRM);
1512: END IF;
1513: END get_tax_event_class;

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

1546: l_tax_event_type_code ZX_EVNT_TYP_MAPPINGS.TAX_EVENT_CLASS_CODE%TYPE;
1547:
1548: BEGIN
1549: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1550: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1551: END IF;
1552:
1553: x_return_status := FND_API.G_RET_STS_SUCCESS;
1554:

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

1567: x_tx_evnt_typ_code:='CREATE';
1568: ELSE
1569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1570: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1571: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1572: ' Incorrect event information passed in for event type :' ||p_evnt_typ_code ||' Please Check!');
1573: END IF;
1574: END IF;
1575:

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

1590: IF ZX_GLOBAL_STRUCTURES_PKG.g_zx_evnt_cls_typs_tbl.exists(l_index2) THEN
1591: x_doc_status := ZX_GLOBAL_STRUCTURES_PKG.g_zx_evnt_cls_typs_tbl(l_index2);
1592: ELSE
1593: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1594: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,
1595: ' Unable to derive doc_event_status. Please Check!');
1596: END IF;
1597: END IF;
1598: END IF;

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

1599:
1600: END IF;
1601:
1602: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1603: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||
1604: '.END',G_PKG_NAME||': '||l_api_name||'()-'||
1605: ', Tax Event Type = ' || x_tx_evnt_typ_code ||
1606: ', Doc Event Status = ' || x_doc_status ||
1607: ', RETURN_STATUS = ' || x_return_status);

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

1611: EXCEPTION
1612: WHEN OTHERS THEN
1613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1614: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1615: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
1616: END IF;
1617: END get_tax_event_type;
1618:
1619:

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

1641: l_first_pty_org_id NUMBER;
1642:
1643: BEGIN
1644: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1645: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1646: END IF;
1647:
1648: l_first_pty_org_id := ZX_SECURITY.G_FIRST_PARTY_ORG_ID ;
1649:

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

1667: END IF;
1668:
1669: IF nvl(l_first_pty_org_id,-1087) <> nvl(ZX_SECURITY.G_FIRST_PARTY_ORG_ID,-1087) THEN
1670: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1671: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1672: 'First Party org_id has changed. Old first_pty_org_id = '||to_char(l_first_pty_org_id)||
1673: ', New first_pty_org_id = '||to_char(ZX_SECURITY.G_FIRST_PARTY_ORG_ID)||
1674: '. Initializing Tax, Status and Rate cache..');
1675: END IF;

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

1682:
1683: p_event_class_rec.first_pty_org_id := ZX_SECURITY.G_FIRST_PARTY_ORG_ID ;
1684:
1685: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1686: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||
1687: '.END',G_PKG_NAME||': '||l_api_name||'()-'||
1688: ', RETURN_STATUS = ' || l_return_status);
1689: END IF;
1690: END get_tax_subscriber;

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

1720: l_context_info_rec ZX_API_PUB.context_info_rec_type;
1721:
1722: BEGIN
1723: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1724: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1725: END IF;
1726:
1727: x_return_status := FND_API.G_RET_STS_SUCCESS;
1728:

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

1747: --Bugfix 4486946 -Call on the fly upgrade if the transaction if not found
1748: EXCEPTION
1749: WHEN NO_DATA_FOUND THEN
1750: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1751: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1752: 'Call on-the-fly upgrade since transaction does not exist in repository for trx id: '||to_char(p_event_class_rec.trx_id));
1753: END IF;
1754: l_upg_trx_info_rec.application_id := p_event_class_rec.application_id;
1755: l_upg_trx_info_rec.entity_code := p_event_class_rec.entity_code;

Line 1763: 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');

1759: x_return_status => l_return_status
1760: );
1761: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1762: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1763: 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');
1764: END IF;
1765: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1766: RAISE FND_API.G_EXC_ERROR;
1767: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

1794: );
1795:
1796: IF nvl(p_event_class_rec.first_pty_org_id,-1087) <> nvl(ZX_SECURITY.G_FIRST_PARTY_ORG_ID,-1087) THEN
1797: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1798: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1799: 'First Party org_id has changed. Old first_pty_org_id = '||to_char(ZX_SECURITY.G_FIRST_PARTY_ORG_ID)||
1800: ', New first_pty_org_id = '||to_char(p_event_class_rec.first_pty_org_id)||
1801: '. Initializing Tax, Status and Rate cache..');
1802: END IF;

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

1827: RETURN;
1828: END IF;
1829:
1830: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1831: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||
1832: '.END',G_PKG_NAME||': '||l_api_name||'()-' ||
1833: ', RETURN_STATUS = ' || l_return_status);
1834: END IF;
1835:

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

1836: EXCEPTION
1837: WHEN OTHERS THEN
1838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1839: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1840: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
1841: 'Data is expected to be in eBTax repository for this call. Please CHECK your sequence of calls to eBTax' ||
1842: SQLERRM);
1843: END IF;
1844: END get_tax_subscriber;

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

1874: l_context_info_rec ZX_API_PUB.context_info_rec_type;
1875:
1876: BEGIN
1877: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1878: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1879: END IF;
1880:
1881: x_return_status := FND_API.G_RET_STS_SUCCESS;
1882: BEGIN

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

1900: --Bugfix 4486946 -Call on the fly upgrade if the transaction if not found
1901: EXCEPTION
1902: WHEN NO_DATA_FOUND THEN
1903: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1904: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1905: 'Call on-the-fly upgrade since transaction does not exist in repository for trx id: '||to_char(p_trx_id));
1906: END IF;
1907: l_upg_trx_info_rec.application_id := p_application_id;
1908: l_upg_trx_info_rec.entity_code := p_entity_code;

Line 1916: 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');

1912: x_return_status => l_return_status
1913: );
1914: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1915: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1916: 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');
1917: END IF;
1918: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1919: RAISE FND_API.G_EXC_ERROR;
1920: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

1964: RETURN;
1965: END IF;
1966:
1967: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1968: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||
1969: '.END',G_PKG_NAME||': '||l_api_name||'()-'||
1970: ', RETURN_STATUS = ' || l_return_status);
1971: END IF;
1972:

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

1973: EXCEPTION
1974: WHEN OTHERS THEN
1975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1976: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1977: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
1978: 'Data is expected to be in eBTax repository for this call. Please CHECK your sequence of calls to eBTax '||
1979: SQLERRM);
1980: END IF;
1981: END set_security_context;

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

2011: l_context_info_rec ZX_API_PUB.context_info_rec_type;
2012:
2013: BEGIN
2014: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2015: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2016: END IF;
2017:
2018: x_return_status := FND_API.G_RET_STS_SUCCESS;
2019:

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

2062: --Bugfix 4486946 -Call on the fly upgrade if the transaction if not found
2063: EXCEPTION
2064: WHEN NO_DATA_FOUND THEN
2065: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2066: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2067: 'Call on-the-fly upgrade since transaction does not exist in repository for trx id: '||to_char(p_event_class_rec.trx_id));
2068: END IF;
2069: l_upg_trx_info_rec.application_id := p_event_class_rec.application_id;
2070: l_upg_trx_info_rec.entity_code := p_event_class_rec.entity_code;

Line 2078: 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');

2074: x_return_status => l_return_status
2075: );
2076: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2077: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2078: 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');
2079: END IF;
2080: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2081: RAISE FND_API.G_EXC_ERROR;
2082: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

2148: RETURN;
2149: END IF;
2150:
2151: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2152: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||
2153: '.END',G_PKG_NAME||': '||l_api_name||'()-' ||
2154: ', RETURN_STATUS = ' || l_return_status);
2155: END IF;
2156:

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

2157: EXCEPTION
2158: WHEN OTHERS THEN
2159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2160: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
2161: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
2162: 'Data is expected to be in eBTax repository for this call. Please CHECK your sequence of calls to eBTax '||
2163: SQLERRM);
2164: END IF;
2165: END set_security_context;

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

2189: l_record_flag VARCHAR2(1);
2190:
2191: BEGIN
2192: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2193: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2194: END IF;
2195:
2196: x_return_status := FND_API.G_RET_STS_SUCCESS;
2197:

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

2208: END IF;
2209: END IF;
2210:
2211: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2212: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||
2213: '.END',G_PKG_NAME||': '||l_api_name||'()-' ||
2214: ', Record Flag = ' || l_record_flag ||
2215: ', RETURN_STATUS = ' || x_return_status);
2216:

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

2221: EXCEPTION
2222: WHEN OTHERS THEN
2223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2224: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
2225: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
2226: END IF;
2227: RETURN l_record_flag;
2228: END is_doc_to_be_recorded;
2229:

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

2251: l_bill_to_location_id NUMBER;
2252:
2253: BEGIN
2254: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2255: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2256: END IF;
2257:
2258: x_return_status := FND_API.G_RET_STS_SUCCESS;
2259: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

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

2404: END IF;
2405: END IF;
2406:
2407: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2408: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2409: ' application_id: '||p_event_class_rec.application_id||
2410: ', entity_code: '||p_event_class_rec.entity_code||
2411: ', event_class_code: '||p_event_class_rec.event_class_code||
2412: ', internal_organization_id: '||p_event_class_rec.internal_organization_id||

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

2496: ', RETURN_STATUS = ' || x_return_status);
2497: END IF;
2498:
2499: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2500: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
2501: END IF;
2502: END calculate_tax;
2503:
2504: -----------------------------------------------------------------------

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

2524: l_bill_to_location_id NUMBER;
2525:
2526: BEGIN
2527: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2528: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2529: END IF;
2530:
2531: x_return_status := FND_API.G_RET_STS_SUCCESS;
2532: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

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

2554: /* ----------------------------------------------------------------------+
2555: | Populate Application Product Options |
2556: + ----------------------------------------------------------------------*/
2557: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2558: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' Populate Application product options');
2559: END IF;
2560:
2561: populate_appl_product_options(l_return_status,
2562: p_event_class_rec

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

2570: -- populate global event class record structure
2571: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := p_event_class_rec;
2572:
2573: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2574: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2575: 'application_id: '||p_event_class_rec.application_id||
2576: ', entity_code: '||p_event_class_rec.entity_code||
2577: ', event_class_code: '||p_event_class_rec.event_class_code||
2578: ', internal_organization_id: '||p_event_class_rec.internal_organization_id||

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

2628: ', header_level_currency_flag: '||p_event_class_rec.header_level_currency_flag||
2629: ', RETURN_STATUS = ' || x_return_status);
2630: END IF;
2631: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2632: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
2633: END IF;
2634: END import_document_with_tax;
2635:
2636: -----------------------------------------------------------------------

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

2658: l_bill_to_location_id NUMBER;
2659:
2660: BEGIN
2661: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2662: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2663: END IF;
2664:
2665: x_return_status := FND_API.G_RET_STS_SUCCESS;
2666: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

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

2762: + ----------------------------------------------------------------------*/
2763: IF p_override is NULL THEN
2764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2765: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2766: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Override Level is required');
2767: END IF;
2768: RETURN;
2769: ELSE
2770: p_event_class_rec.override_level := p_override;

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

2772:
2773: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := p_event_class_rec;
2774:
2775: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2776: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2777: 'application_id: '||p_event_class_rec.application_id||
2778: ', entity_code: '||p_event_class_rec.entity_code||
2779: ', event_class_code: '||p_event_class_rec.event_class_code||
2780: ', internal_organization_id: '||p_event_class_rec.internal_organization_id||

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

2842: ', exmptn_pty_basis_hier_2_code: '||p_event_class_rec.exmptn_pty_basis_hier_2_code||
2843: ', RETURN_STATUS = ' || x_return_status);
2844: END IF;
2845: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2846: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
2847: END IF;
2848: END override_tax;
2849:
2850: -----------------------------------------------------------------------

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

2867: l_ref_appln_id NUMBER;
2868:
2869: BEGIN
2870: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2871: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2872: END IF;
2873:
2874: x_return_status := FND_API.G_RET_STS_SUCCESS;
2875: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

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

2887: /* ----------------------------------------------------------------------+
2888: | Bug 3129063 - Setting the Security Context for Subscription |
2889: + ----------------------------------------------------------------------*/
2890: --IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2891: -- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' Call GET_TAX_SUBSCRIBER');
2892: -- END IF;
2893:
2894: --get_tax_subscriber(p_event_class_rec,
2895: -- l_return_status

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

2954: -- populate global event class record structure
2955: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := p_event_class_rec;
2956:
2957: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2958: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2959: 'application_id: '||p_event_class_rec.application_id||
2960: ', entity_code: '||p_event_class_rec.entity_code||
2961: ', event_class_code: '||p_event_class_rec.event_class_code||
2962: ', event_type_code: '||p_event_class_rec.event_type_code||

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

2966: ', doc_event_status: '||p_event_class_rec.doc_status_code||
2967: ', RETURN_STATUS = ' || x_return_status);
2968: END IF;
2969: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2970: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
2971: END IF;
2972: END global_document_update;
2973:
2974:

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

2985: l_return_status VARCHAR2(30);
2986:
2987: BEGIN
2988: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2989: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2990: END IF;
2991:
2992: x_return_status := FND_API.G_RET_STS_SUCCESS;
2993:

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

3018: RETURN;
3019: END IF;
3020:
3021: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3022: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3023: 'application_id: '||p_transaction_line_rec.application_id||
3024: ', entity_code: '||p_transaction_line_rec.entity_code||
3025: ', event_class_code: '||p_transaction_line_rec.event_class_code||
3026: ', event_type_code: '||p_transaction_line_rec.event_type_code||

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

3032: ', doc_trx_line_id: '||p_transaction_line_rec.trx_line_id||
3033: ', RETURN_STATUS = ' || x_return_status);
3034: END IF;
3035: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3036: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
3037: END IF;
3038: END mark_tax_lines_deleted;
3039:
3040: -----------------------------------------------------------------------

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

3060: l_ref_appln_id NUMBER;
3061:
3062: BEGIN
3063: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3064: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3065: END IF;
3066:
3067: x_return_status := FND_API.G_RET_STS_SUCCESS;
3068: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

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

3082: FROM ZX_REV_TRX_HEADERS_GT
3083: WHERE rownum = 1;
3084:
3085: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3086: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' Get tax event class');
3087: END IF;
3088:
3089: /* -----------------------------------------------------------------------+
3090: | Bug 3129063 Setting the Security Context for Subscription |

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

3118: -- populate global event class record structure
3119: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := p_event_class_rec;
3120:
3121: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3122: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3123: 'application_id: '||l_appln_id||
3124: ', entity_code: '||l_entity_code||
3125: ', event_class_code: '||l_evnt_cls_code||
3126: ', tax_event_class_code: '||l_tx_evnt_cls_code||

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

3127: ', reference_application_id: '||l_ref_appln_id||
3128: ', RETURN_STATUS = ' || x_return_status);
3129: END IF;
3130: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3131: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
3132: END IF;
3133:
3134: END reverse_document;
3135:

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

3163:
3164: BEGIN
3165:
3166: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3167: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3168: END IF;
3169:
3170: x_return_status := FND_API.G_RET_STS_SUCCESS;
3171: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

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

3218: END IF;
3219:
3220:
3221: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3222: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3223: 'application_id: '||l_appln_id||
3224: ', entity_code: '||l_entity_code||
3225: ', event_class_code: '||l_evnt_cls_code||
3226: ', tax_event_class_code: '||l_tx_evnt_cls_code||

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

3228: ', RETURN_STATUS = ' || x_return_status);
3229: END IF;
3230:
3231: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3232: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
3233: END IF;
3234: END reverse_distributions;
3235:
3236: -----------------------------------------------------------------------

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

3251: l_return_status VARCHAR2(30);
3252:
3253: BEGIN
3254: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3255: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3256: END IF;
3257:
3258: x_return_status := FND_API.G_RET_STS_SUCCESS;
3259: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

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

3274: -- populate global event class record structure
3275: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := p_event_class_rec;
3276:
3277: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3278: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3279: 'application_id: '||p_event_class_rec.application_id||
3280: ', entity_code: '||p_event_class_rec.entity_code||
3281: ', event_class_code: '||p_event_class_rec.event_class_code||
3282: ', internal_organization_id: '||p_event_class_rec.internal_organization_id||

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

3289: ', doc_status_code: '||p_event_class_rec.doc_status_code||
3290: ', RETURN_STATUS = ' || x_return_status);
3291: END IF;
3292: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3293: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
3294: END IF;
3295: END determine_recovery;
3296:
3297: -----------------------------------------------------------------------

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

3313: l_return_status VARCHAR2(30);
3314:
3315: BEGIN
3316: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3317: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3318: END IF;
3319:
3320: x_return_status := FND_API.G_RET_STS_SUCCESS;
3321: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

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

3410: -- populate global event class record structure
3411: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := p_event_class_rec;
3412:
3413: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3414: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3415: 'application_id: '||p_event_class_rec.application_id||
3416: ', entity_code: '||p_event_class_rec.entity_code||
3417: ', event_class_code: '||p_event_class_rec.event_class_code||
3418: ', legal_entity_id: '||p_event_class_rec.legal_entity_id||

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

3425: ', quote_flag: '||p_event_class_rec.quote_flag||
3426: ', RETURN_STATUS = ' || x_return_status);
3427: END IF;
3428: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3429: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
3430: END IF;
3431: END override_recovery;
3432:
3433: -----------------------------------------------------------------------

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

3450: l_ref_appln_id NUMBER;
3451:
3452: BEGIN
3453: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3454: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3455: END IF;
3456:
3457: x_return_status := FND_API.G_RET_STS_SUCCESS;
3458: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

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

3526: -- populate global event class record structure
3527: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := p_event_class_rec;
3528:
3529: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3530: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3531: 'application_id: '||p_trx_rec.application_id||
3532: ', entity_code: '||p_trx_rec.entity_code||
3533: ', event_class_code: '||p_trx_rec.event_class_code||
3534: ', event_type_code: '||p_trx_rec.event_type_code||

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

3538: ', doc_event_status: '||p_trx_rec.doc_event_status||
3539: ', RETURN_STATUS = ' || x_return_status);
3540: END IF;
3541: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3542: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
3543: END IF;
3544: END freeze_distribution_lines;
3545:
3546: -----------------------------------------------------------------------

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

3564: l_effective_date DATE;
3565:
3566: BEGIN
3567: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3568: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3569: END IF;
3570:
3571: x_return_status := FND_API.G_RET_STS_SUCCESS;
3572: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

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

3699: -- populate global event class record structure
3700: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := p_event_class_rec;
3701:
3702: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3703: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3704: 'application_id: '||p_event_class_rec.application_id||
3705: ', entity_code: '||p_event_class_rec.entity_code||
3706: ', event_class_code: '||p_event_class_rec.event_class_code||
3707: ', internal_organization_id: '||p_event_class_rec.internal_organization_id||

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

3788: ', home_country_default_flag: '||p_event_class_rec.home_country_default_flag||
3789: ', RETURN_STATUS = ' || x_return_status);
3790: END IF;
3791: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3792: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
3793: END IF;
3794: END validate_document_for_tax;
3795:
3796:

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

3812: l_return_status VARCHAR2(30);
3813:
3814: BEGIN
3815: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3816: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3817: END IF;
3818:
3819: x_return_status := FND_API.G_RET_STS_SUCCESS;
3820:

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

3846: RETURN;
3847: END IF;
3848:
3849: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3850: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3851: 'application_id: '||p_trx_rec.application_id||
3852: ', entity_code: '||p_trx_rec.entity_code||
3853: ', event_class_code: '||p_trx_rec.event_class_code||
3854: ', event_type_code: '||p_trx_rec.event_type_code||

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

3855: ', trx_id: '||p_trx_rec.trx_id||
3856: ', RETURN_STATUS = ' || x_return_status);
3857: END IF;
3858: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3859: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
3860: END IF;
3861: END discard_tax_only_lines;
3862:
3863:

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

3888: l_bill_to_location_id NUMBER;
3889:
3890: BEGIN
3891: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3892: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3893: END IF;
3894:
3895: x_return_status := FND_API.G_RET_STS_SUCCESS;
3896: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

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

4025: -- populate global event class record structure
4026: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := p_event_class_rec;
4027:
4028: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4029: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
4030: 'application_id: '||p_event_class_rec.application_id||
4031: ', entity_code: '||p_event_class_rec.entity_code||
4032: ', event_class_code: '||p_event_class_rec.event_class_code||
4033: ', internal_organization_id: '||p_event_class_rec.internal_organization_id||

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

4115: ', RETURN_STATUS = ' || l_return_status);
4116: END IF;
4117:
4118: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4119: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
4120: END IF;
4121: END insupd_line_det_factors;
4122:
4123:

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

4145: l_bill_to_location_id NUMBER;
4146:
4147: BEGIN
4148: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4149: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
4150: END IF;
4151:
4152: x_return_status := FND_API.G_RET_STS_SUCCESS;
4153: ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec := null_event_class_rec;

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

4237: RETURN;
4238: END IF;
4239:
4240: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4241: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
4242: 'application_id: '||p_event_class_rec.application_id||
4243: ', entity_code: '||p_event_class_rec.entity_code||
4244: ', event_class_code: '||p_event_class_rec.event_class_code||
4245: ', internal_organization_id: '||p_event_class_rec.internal_organization_id||

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

4327: ', RETURN_STATUS = ' || l_return_status);
4328: END IF;
4329:
4330: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4331: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
4332: END IF;
4333: END get_default_tax_det_attrs;
4334:
4335: PROCEDURE get_event_class_info(

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

4430:
4431: IF ZX_GLOBAL_STRUCTURES_PKG.g_zx_event_class_rec_tbl.EXISTS(l_index) then
4432:
4433: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4434: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_VALID_INIT_PKG.get_evnt_cls_info',
4435: 'Event class record found in cache ');
4436: END IF;
4437:
4438: X_TBL_INDEX := l_index;

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

4515: ZX_GLOBAL_STRUCTURES_PKG.g_zx_event_class_rec_tbl(l_index).ALLOW_EXEMPTIONS_FLAG := L_EVENT_CLASS_REC.ALLOW_EXEMPTIONS_FLAG ;
4516: ZX_GLOBAL_STRUCTURES_PKG.g_zx_event_class_rec_tbl(l_index).ENABLE_MRC_FLAG := L_EVENT_CLASS_REC.ENABLE_MRC_FLAG ;
4517:
4518: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4519: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_VALID_INIT_PKG.get_evnt_cls_info',
4520: 'Event class record not found in cache. Populating from database ');
4521: END IF;
4522:
4523: X_TBL_INDEX := l_index;

Line 4534: FND_LOG.STRING(g_level_unexpected,

4530: EXCEPTION
4531: WHEN OTHERS THEN
4532:
4533: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4534: FND_LOG.STRING(g_level_unexpected,
4535: 'ZX.PLSQL.ZX_VALID_INIT_PKG.get_evnt_cls_info',
4536: 'Exception in ZZX_VALID_INIT_PKG.get_evnt_cls_info. '||SQLCODE||SQLERRM);
4537: END IF;
4538:

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

4582:
4583: IF ZX_GLOBAL_STRUCTURES_PKG.g_zx_evnt_typ_map_tbl.EXISTS(l_index) then
4584:
4585: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4586: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_VALID_INIT_PKG.get_evnt_cls_info',
4587: 'Event type record found in cache ');
4588: END IF;
4589:
4590: X_TBL_INDEX := l_index;

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

4604: ZX_GLOBAL_STRUCTURES_PKG.g_zx_evnt_typ_map_tbl(l_index).TAX_EVENT_TYPE_CODE := l_event_type_rec.TAX_EVENT_TYPE_CODE;
4605: ZX_GLOBAL_STRUCTURES_PKG.g_zx_evnt_typ_map_tbl(l_index).ENABLED_FLAG := l_event_type_rec.ENABLED_FLAG;
4606:
4607: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4608: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_VALID_INIT_PKG.get_evnt_typ_mappings_info',
4609: 'Event type record not found in cache. Populating from database ');
4610: END IF;
4611:
4612: X_TBL_INDEX := l_index;

Line 4623: FND_LOG.STRING(g_level_unexpected,

4619: EXCEPTION
4620: WHEN OTHERS THEN
4621:
4622: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4623: FND_LOG.STRING(g_level_unexpected,
4624: 'ZX.PLSQL.ZX_VALID_INIT_PKG.get_evnt_typ_mappings_info',
4625: 'Exception in ZX_VALID_INIT_PKG.get_evnt_typ_mappings_info. '||SQLCODE||SQLERRM);
4626: END IF;
4627:

Line 4659: FND_LOG.STRING(g_level_unexpected,

4655:
4656: EXCEPTION
4657: WHEN OTHERS THEN
4658: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4659: FND_LOG.STRING(g_level_unexpected,
4660: 'ZX.PLSQL.ZX_VALID_INIT_PKG.populate_event_cls_typs',
4661: 'Exception in ZX_VALID_INIT_PKG.populate_event_cls_typs. '||SQLCODE||SQLERRM);
4662: END IF;
4663:

Line 4691: FND_LOG.STRING(g_level_unexpected,

4687:
4688: EXCEPTION
4689: WHEN OTHERS THEN
4690: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4691: FND_LOG.STRING(g_level_unexpected,
4692: 'ZX.PLSQL.ZX_VALID_INIT_PKG.populate_tax_event_class_info',
4693: 'Exception in ZX_VALID_INIT_PKG.populate_tax_event_class_info. '||SQLCODE||SQLERRM);
4694: END IF;
4695: