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_TCM_EXT_SERVICES_PUB dependencies on FND_LOG

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

2: /* $Header: zxpservb.pls 120.44.12020000.2 2012/07/23 13:01:46 srajapar noship $ */
3:
4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

3:
4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

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

4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.';

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

5: G_CURRENT_RUNTIME_LEVEL NUMBER;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.';
13:

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

6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.';
13:
14: PROCEDURE get_fc_country_def_cache_info (

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

7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.';
13:
14: PROCEDURE get_fc_country_def_cache_info (
15: p_country_code IN fnd_territories.territory_code%TYPE,

Line 47: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

43: */
44:
45: -- Logging Infra:
46: l_procedure_name CONSTANT VARCHAR2(30) := 'get_default_status_rates';
47: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
48:
49: -- get default status code
50: CURSOR c_default_status IS
51: SELECT tax_status_code

Line 76: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

72:
73:
74: BEGIN
75: -- Logging Infra: Setting up runtime level
76: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
77:
78: -- Logging Infra: Procedure level
79: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
80: l_log_msg := l_procedure_name||'(+)';

Line 81: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

77:
78: -- Logging Infra: Procedure level
79: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
80: l_log_msg := l_procedure_name||'(+)';
81: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
82: END IF;
83:
84:
85: --

Line 97: FND_LOG.STRING(G_LEVEL_STATEMENT,

93: l_log_msg := 'B: input params: p_tax_regime_code=' || p_tax_regime_code ||
94: ', p_tax=' || p_tax ||
95: ', p_date=' || p_date;
96:
97: FND_LOG.STRING(G_LEVEL_STATEMENT,
98: G_MODULE_NAME || l_procedure_name,
99: l_log_msg);
100: END IF;
101:

Line 109: FND_LOG.STRING(G_LEVEL_STATEMENT,

105: --fnd_message.set_name('ZX','ZX_PARAM_NOT_SET');
106: -- Logging Infra: YK: 3/10:
107: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
108: l_log_msg := 'E: wrong input params: p_tax_regime_code is null or p_tax is null';
109: FND_LOG.STRING(G_LEVEL_STATEMENT,
110: G_MODULE_NAME || l_procedure_name,
111: l_log_msg);
112: END IF;
113: RETURN;

Line 123: FND_LOG.STRING(G_LEVEL_STATEMENT,

119: -- Logging Infra: YK: 3/10: Break point
120: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
121: l_log_msg := 'B: CUR: c_default_status: fetched: p_tax_status_code=' || p_tax_status_code;
122:
123: FND_LOG.STRING(G_LEVEL_STATEMENT,
124: G_MODULE_NAME || l_procedure_name,
125: l_log_msg);
126: END IF;
127:

Line 135: FND_LOG.STRING(G_LEVEL_STATEMENT,

131:
132: -- Logging Infra: YK: 3/10: Break point
133: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
134: l_log_msg := 'B: CUR: c_default_rate: fetched: p_tax_rate_code=' || p_tax_rate_code;
135: FND_LOG.STRING(G_LEVEL_STATEMENT,
136: G_MODULE_NAME || l_procedure_name,
137: l_log_msg);
138: END IF;
139:

Line 150: FND_LOG.STRING(G_LEVEL_STATEMENT,

146:
147: -- Logging Infra: YK: 3/10: Break point
148: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
149: l_log_msg := 'B: CUR: c_default_rate: found';
150: FND_LOG.STRING(G_LEVEL_STATEMENT,
151: G_MODULE_NAME || l_procedure_name,
152: l_log_msg);
153: END IF;
154: ELSE

Line 158: FND_LOG.STRING(G_LEVEL_STATEMENT,

154: ELSE
155: -- Logging Infra: YK: 3/10: Break point
156: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
157: l_log_msg := 'B: CUR: c_default_rate: notfound';
158: FND_LOG.STRING(G_LEVEL_STATEMENT,
159: G_MODULE_NAME || l_procedure_name,
160: l_log_msg);
161: END IF;
162: END IF;

Line 174: FND_LOG.STRING(G_LEVEL_STATEMENT,

170:
171: -- Logging Infra: YK: 3/10: Break point
172: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
173: l_log_msg := 'B: CUR: c_default_status: notfound';
174: FND_LOG.STRING(G_LEVEL_STATEMENT,
175: G_MODULE_NAME || l_procedure_name,
176: l_log_msg);
177: END IF;
178: --RAISE FND_API.G_EXC_ERROR;

Line 189: FND_LOG.STRING(G_LEVEL_STATEMENT,

185: -- Logging Infra: YK: 3/10: Put output value here
186: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
187: l_log_msg := 'R: p_tax_status_code=' || p_tax_status_code ||
188: ', p_tax_rate_code=' || p_tax_rate_code;
189: FND_LOG.STRING(G_LEVEL_STATEMENT,
190: G_MODULE_NAME || l_procedure_name,
191: l_log_msg);
192: END IF;
193:

Line 197: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);

193:
194: -- Logging Infra: Procedure level
195: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
196: l_log_msg := l_procedure_name||'(-)';
197: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
198: END IF;
199:
200: EXCEPTION
201: WHEN INVALID_CURSOR THEN

Line 210: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);

206: IF c_default_status%ISOPEN THEN CLOSE c_default_status; end if;
207:
208: -- Logging Infra: YK: 3/10:
209: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
210: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
211: END IF;
212:
213: WHEN FND_API.G_EXC_ERROR THEN
214: p_return_status := FND_API.G_RET_STS_ERROR;

Line 218: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);

214: p_return_status := FND_API.G_RET_STS_ERROR;
215: IF c_default_rate%ISOPEN THEN CLOSE c_default_rate; end if;
216: IF c_default_status%ISOPEN THEN CLOSE c_default_status; end if;
217: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
218: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
219: END IF;
220:
221:
222: WHEN OTHERS THEN

Line 232: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);

228: IF c_default_status%ISOPEN THEN CLOSE c_default_status; end if;
229:
230: -- Logging Infra: YK: 3/10:
231: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
232: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
233: END IF;
234:
235: END GET_DEFAULT_STATUS_RATES;
236:

Line 276: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

272: l_category_set ZX_FC_COUNTRY_DEFAULTS.PRIMARY_INVENTORY_CATEGORY_SET%TYPE;
273:
274: -- Logging Infra:
275: l_procedure_name CONSTANT VARCHAR2(30) := 'get_default_classif_code';
276: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
277:
278: -- get country defaults
279: CURSOR c_country_default IS
280: SELECT intended_use_default, product_categ_default, primary_inventory_category_set

Line 378: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

374: l_index BINARY_INTEGER;
375:
376: BEGIN
377: -- Logging Infra: Setting up runtime level
378: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
379:
380: -- Logging Infra: Procedure level
381: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
382: l_log_msg := l_procedure_name||'(+)';

Line 383: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

379:
380: -- Logging Infra: Procedure level
381: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
382: l_log_msg := l_procedure_name||'(+)';
383: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
384: END IF;
385:
386: -- Logging Infra: YK: 3/10: Break point
387: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 396: FND_LOG.STRING(G_LEVEL_STATEMENT,

392: ', p_event_class_code=' || p_event_class_code ||
393: ', p_source_event_class_code=' || p_source_event_class_code ||
394: ', p_item_id=' || p_item_id ||
395: ', p_org_id=' || p_org_id;
396: FND_LOG.STRING(G_LEVEL_STATEMENT,
397: G_MODULE_NAME || l_procedure_name,
398: l_log_msg);
399: END IF;
400:

Line 420: FND_LOG.STRING(G_LEVEL_STATEMENT,

416: --p_error_buffer:='One or more of the parameters are not entered';
417: --fnd_message.set_name('ZX','ZX_PARAM_NOT_SET');
418: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
419: l_log_msg := 'E: p_country_code is null';
420: FND_LOG.STRING(G_LEVEL_STATEMENT,
421: G_MODULE_NAME || l_procedure_name,
422: l_log_msg);
423: END IF;
424:

Line 436: FND_LOG.STRING(G_LEVEL_STATEMENT,

432: --fnd_message.set_name('ZX','ZX_COUNTRY_CODE_INVALID');
433: -- Logging Infra: YK: 3/10: Break point
434: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
435: l_log_msg := 'Invalid Country Code: '||p_country_code;
436: FND_LOG.STRING(G_LEVEL_STATEMENT,
437: G_MODULE_NAME || l_procedure_name,
438: l_log_msg);
439: END IF;
440: RETURN;

Line 491: FND_LOG.STRING(G_LEVEL_STATEMENT,

487: -- Logging Infra: YK: 3/10: Break point
488: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
489: l_log_msg := 'B: CUR: c_model_intended_use: fetched: l_owner_table=' || l_owner_table ||
490: ', l_owner_id_num=' || l_owner_id_num;
491: FND_LOG.STRING(G_LEVEL_STATEMENT,
492: G_MODULE_NAME || l_procedure_name,
493: l_log_msg);
494: END IF;
495:

Line 505: FND_LOG.STRING(G_LEVEL_STATEMENT,

501:
502: -- Logging Infra: YK: 3/10: Break point
503: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
504: l_log_msg := 'E: CUR: c_model_intended_use: notfound';
505: FND_LOG.STRING(G_LEVEL_STATEMENT,
506: G_MODULE_NAME || l_procedure_name,
507: l_log_msg);
508: END IF;
509: RETURN;

Line 524: FND_LOG.STRING(G_LEVEL_STATEMENT,

520:
521: -- Logging Infra: YK: 3/10: Break point
522: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
523: l_log_msg := 'B: CUR: c_country_default: fetched: l_intended_use=' || l_intended_use;
524: FND_LOG.STRING(G_LEVEL_STATEMENT,
525: G_MODULE_NAME || l_procedure_name,
526: l_log_msg);
527: END IF;
528:

Line 562: FND_LOG.STRING(G_LEVEL_STATEMENT,

558:
559: -- Logging Infra: YK: 3/10: Break point: Assuming this is successful condition
560: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
561: l_log_msg := 'S: p_default_code=' || p_default_code;
562: FND_LOG.STRING(G_LEVEL_STATEMENT,
563: G_MODULE_NAME || l_procedure_name,
564: l_log_msg);
565: END IF;
566:

Line 575: FND_LOG.STRING(G_LEVEL_STATEMENT,

571:
572: -- Logging Infra: YK: 3/10: Break point
573: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
574: l_log_msg := 'B: CUR: c_item_category: fetched: l_category_id=' || l_category_id;
575: FND_LOG.STRING(G_LEVEL_STATEMENT,
576: G_MODULE_NAME || l_procedure_name,
577: l_log_msg);
578: END IF;
579:

Line 593: FND_LOG.STRING(G_LEVEL_STATEMENT,

589: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
590: l_log_msg := 'E: CUR: c_item_category: rowcount > 1: category_set_id=' || l_owner_id_num ||
591: ', organization_id=' || p_org_id ||
592: ', inventory_item_id='|| p_item_id;
593: FND_LOG.STRING(G_LEVEL_STATEMENT,
594: G_MODULE_NAME || l_procedure_name,
595: l_log_msg);
596: END IF;
597: RETURN;

Line 609: FND_LOG.STRING(G_LEVEL_STATEMENT,

605:
606: -- Logging Infra: YK: 3/11: Break point
607: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
608: l_log_msg := 'B: CUR: c_category_code: fetched: l_category_code=' || l_category_code;
609: FND_LOG.STRING(G_LEVEL_STATEMENT,
610: G_MODULE_NAME || l_procedure_name,
611: l_log_msg);
612: END IF;
613:

Line 626: FND_LOG.STRING(G_LEVEL_STATEMENT,

622: -- Logging Infra: YK: 3/10: Break point:
623: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
624: l_log_msg := 'E: CUR: c_category_code: notfound: category_set_id=' || l_owner_id_num ||
625: ', category_id=' || l_category_id;
626: FND_LOG.STRING(G_LEVEL_STATEMENT,
627: G_MODULE_NAME || l_procedure_name,
628: l_log_msg);
629: END IF;
630:

Line 678: FND_LOG.STRING(G_LEVEL_STATEMENT,

674:
675: -- Logging Infra: YK: 3/11: Break point
676: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
677: l_log_msg := 'B: CUR: c_country_default: fetched: l_product_category_code=' || l_product_category_code;
678: FND_LOG.STRING(G_LEVEL_STATEMENT,
679: G_MODULE_NAME || l_procedure_name,
680: l_log_msg);
681: END IF;
682:

Line 725: FND_LOG.STRING(G_LEVEL_STATEMENT,

721:
722: -- Logging Infra: Break point
723: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
724: l_log_msg := 'B: CUR: c_product_type: fetched: l_product_type=' || l_product_type;
725: FND_LOG.STRING(G_LEVEL_STATEMENT,
726: G_MODULE_NAME || l_procedure_name,
727: l_log_msg);
728: END IF;
729:

Line 771: FND_LOG.STRING(G_LEVEL_STATEMENT,

767:
768: -- Logging Infra: Break point
769: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
770: l_log_msg := 'B: CUR: c_user_defined: fetched: l_classif_code=' || l_classif_code;
771: FND_LOG.STRING(G_LEVEL_STATEMENT,
772: G_MODULE_NAME || l_procedure_name,
773: l_log_msg);
774: END IF;
775:

Line 822: FND_LOG.STRING(G_LEVEL_STATEMENT,

818:
819: -- Logging Infra: Break point
820: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
821: l_log_msg := 'B: CUR: c_document_subtype : fetched: l_classif_code =' || l_classif_code;
822: FND_LOG.STRING(G_LEVEL_STATEMENT,
823: G_MODULE_NAME || l_procedure_name,
824: l_log_msg);
825: END IF;
826:

Line 849: FND_LOG.STRING(G_LEVEL_STATEMENT,

845:
846: -- Logging Infra: YK: 3/11: Break point
847: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
848: l_log_msg := 'B: CUR: c_trx_biz_cat: fetched: l_tax_event_class_code=' || l_tax_event_class_code;
849: FND_LOG.STRING(G_LEVEL_STATEMENT,
850: G_MODULE_NAME || l_procedure_name,
851: l_log_msg);
852: END IF;
853:

Line 889: FND_LOG.STRING(G_LEVEL_STATEMENT,

885:
886: -- Logging Infra: YK: 3/11: Put output value here
887: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
888: l_log_msg := 'R: p_default_code=' || p_default_code;
889: FND_LOG.STRING(G_LEVEL_STATEMENT,
890: G_MODULE_NAME || l_procedure_name,
891: l_log_msg);
892: END IF;
893:

Line 897: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);

893:
894: -- Logging Infra: YK: 3/11: Procedure level
895: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
896: l_log_msg := l_procedure_name||'(-)';
897: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
898: END IF;
899:
900: EXCEPTION
901: WHEN INVALID_CURSOR THEN

Line 913: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);

909: IF c_category_code%isopen THEN CLOSE c_category_code; END IF;
910:
911: -- Logging Infra: YK: 3/12:
912: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
913: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
914: END IF;
915:
916: WHEN FND_API.G_EXC_ERROR THEN
917: p_return_status := FND_API.G_RET_STS_ERROR;

Line 925: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);

921: IF c_category_code%isopen THEN CLOSE c_category_code; END IF;
922:
923:
924: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
925: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
926: END IF;
927:
928:
929: WHEN OTHERS THEN

Line 941: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);

937: IF c_category_code%isopen THEN CLOSE c_category_code; END IF;
938:
939: -- Logging Infra: YK: 3/12:
940: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
941: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
942: END IF;
943:
944: END GET_DEFAULT_CLASSIF_CODE;
945:

Line 974: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

970: L_TBL_INDEX binary_integer;
971:
972: -- Logging Infra:
973: l_procedure_name CONSTANT VARCHAR2(30) := 'get_default_product_classif';
974: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
975:
976: -- Get default Product Fiscal Classification
977:
978: CURSOR c_country_default IS

Line 1012: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1008:
1009:
1010: BEGIN
1011: -- Logging Infra: Setting up runtime level
1012: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1013:
1014: -- Logging Infra: Procedure level
1015: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1016: l_log_msg := l_procedure_name||'(+)';

Line 1017: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

1013:
1014: -- Logging Infra: Procedure level
1015: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1016: l_log_msg := l_procedure_name||'(+)';
1017: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
1018: END IF;
1019:
1020: -- Logging Infra: YK: 3/12: Break point
1021: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1025: FND_LOG.STRING(G_LEVEL_STATEMENT,

1021: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1022: l_log_msg := 'B: input params: p_country_code=' || p_country_code ||
1023: ', p_item_id =' || p_item_id ||
1024: ', p_org_id=' || p_org_id;
1025: FND_LOG.STRING(G_LEVEL_STATEMENT,
1026: G_MODULE_NAME || l_procedure_name,
1027: l_log_msg);
1028: END IF;
1029:

Line 1043: FND_LOG.STRING(G_LEVEL_STATEMENT,

1039: --fnd_message.set_name('ZX','ZX_PARAM_NOT_SET');
1040:
1041: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1042: l_log_msg := 'E: p_country_code is null';
1043: FND_LOG.STRING(G_LEVEL_STATEMENT,
1044: G_MODULE_NAME || l_procedure_name,
1045: l_log_msg);
1046: END IF;
1047: RETURN;

Line 1058: FND_LOG.STRING(G_LEVEL_STATEMENT,

1054: --fnd_message.set_name('ZX','ZX_COUNTRY_CODE_INVALID');
1055: -- Logging Infra: YK: 3/10: Break point
1056: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1057: l_log_msg := 'Invalid Country Code: '||p_country_code;
1058: FND_LOG.STRING(G_LEVEL_STATEMENT,
1059: G_MODULE_NAME || l_procedure_name,
1060: l_log_msg);
1061: END IF;
1062: RETURN;

Line 1070: FND_LOG.STRING(G_LEVEL_STATEMENT,

1066:
1067: -- Logging Infra: YK: 3/12: Break point
1068: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1069: l_log_msg := 'B: CUR: c_country_default: fetched: l_category_set=' || l_category_set;
1070: FND_LOG.STRING(G_LEVEL_STATEMENT,
1071: G_MODULE_NAME || l_procedure_name,
1072: l_log_msg);
1073: END IF;
1074:

Line 1085: FND_LOG.STRING(G_LEVEL_STATEMENT,

1081:
1082: -- Logging Infra: YK: 3/12: Break point
1083: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1084: l_log_msg := 'B: CUR: c_country_default: notfound: country_code=' || p_country_code;
1085: FND_LOG.STRING(G_LEVEL_STATEMENT,
1086: G_MODULE_NAME || l_procedure_name,
1087: l_log_msg);
1088: END IF;
1089: return;

Line 1121: FND_LOG.STRING(G_LEVEL_STATEMENT,

1117:
1118: -- Logging Infra: YK: 3/12: Break point
1119: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1120: l_log_msg := 'B: CUR: c_item_categoryt: fetched: l_category_id=' || l_category_id;
1121: FND_LOG.STRING(G_LEVEL_STATEMENT,
1122: G_MODULE_NAME || l_procedure_name,
1123: l_log_msg);
1124: END IF;
1125:

Line 1139: FND_LOG.STRING(G_LEVEL_STATEMENT,

1135: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1136: l_log_msg := 'E: CUR: c_item_category: rowcount > 1: category_set_id=' || l_category_set ||
1137: ', organization_id=' || p_org_id ||
1138: ', inventory_item_id='|| p_item_id;
1139: FND_LOG.STRING(G_LEVEL_STATEMENT,
1140: G_MODULE_NAME || l_procedure_name,
1141: l_log_msg);
1142: END IF;
1143:

Line 1157: FND_LOG.STRING(G_LEVEL_STATEMENT,

1153:
1154: -- Logging Infra: YK: 3/12: Break point
1155: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1156: l_log_msg := 'B: CUR: c_default_category: fetched: l_category_id=' || l_category_id;
1157: FND_LOG.STRING(G_LEVEL_STATEMENT,
1158: G_MODULE_NAME || l_procedure_name,
1159: l_log_msg);
1160: END IF;
1161:

Line 1174: FND_LOG.STRING(G_LEVEL_STATEMENT,

1170:
1171: -- Logging Infra: YK: 3/12: Break point:
1172: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1173: l_log_msg := 'E: CUR: c_default_category: notfound: category_set_id=' || l_category_set;
1174: FND_LOG.STRING(G_LEVEL_STATEMENT,
1175: G_MODULE_NAME || l_procedure_name,
1176: l_log_msg);
1177: END IF;
1178: return;

Line 1192: FND_LOG.STRING(G_LEVEL_STATEMENT,

1188:
1189: -- Logging Infra: YK: 3/12: Break point
1190: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1191: l_log_msg := 'B: CUR: c__category_code: fetched: l_category_code=' || l_category_code;
1192: FND_LOG.STRING(G_LEVEL_STATEMENT,
1193: G_MODULE_NAME || l_procedure_name,
1194: l_log_msg);
1195: END IF;
1196:

Line 1210: FND_LOG.STRING(G_LEVEL_STATEMENT,

1206: -- Logging Infra: YK: 3/12: Break point:
1207: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1208: l_log_msg := 'E: CUR: c_category_code: notfound: category_set_id=' || l_category_set ||
1209: ', category_id=' || l_category_id;
1210: FND_LOG.STRING(G_LEVEL_STATEMENT,
1211: G_MODULE_NAME || l_procedure_name,
1212: l_log_msg);
1213: END IF;
1214:

Line 1229: FND_LOG.STRING(G_LEVEL_STATEMENT,

1225:
1226: -- Logging Infra: YK: 3/12: Put output value here
1227: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1228: l_log_msg := 'R: p_default_code=' || p_default_code;
1229: FND_LOG.STRING(G_LEVEL_STATEMENT,
1230: G_MODULE_NAME || l_procedure_name,
1231: l_log_msg);
1232: END IF;
1233:

Line 1237: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);

1233:
1234: -- Logging Infra: YK: 3/12: Procedure level
1235: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1236: l_log_msg := l_procedure_name||'(-)';
1237: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
1238: END IF;
1239:
1240: EXCEPTION
1241: WHEN INVALID_CURSOR THEN

Line 1253: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);

1249: IF c_category_code%ISOPEN THEN CLOSE c_category_code; END IF;
1250:
1251: -- Logging Infra: YK: 3/12
1252: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1253: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
1254: END IF;
1255:
1256: WHEN FND_API.G_EXC_ERROR THEN
1257: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1265: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);

1261: IF c_category_code%ISOPEN THEN CLOSE c_category_code; END IF;
1262:
1263:
1264: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1265: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
1266: END IF;
1267:
1268:
1269: WHEN OTHERS THEN

Line 1281: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);

1277: IF c_category_code%ISOPEN THEN CLOSE c_category_code; END IF;
1278:
1279: -- Logging Infra: YK: 3/12
1280: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1281: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
1282: END IF;
1283:
1284: END GET_DEFAULT_PRODUCT_CLASSIF;
1285:

Line 1402: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1398: RETURN Varchar2
1399: IS
1400: -- Logging Infra
1401: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Default_Tax_Reg';
1402: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1403: l_effective_date zx_registrations.effective_from%Type;
1404: --p_error_buffer varchar2(200);
1405:
1406: Cursor Default_Reg IS

Line 1425: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1421: AND ptp.party_type_code = p_party_type;
1422:
1423: Begin
1424: -- Logging Infra: Setting up runtime level
1425: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1426:
1427: -- Logging Infra: Procedure level
1428: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1429: l_log_msg := l_procedure_name||'(+)';

Line 1430: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

1426:
1427: -- Logging Infra: Procedure level
1428: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1429: l_log_msg := l_procedure_name||'(+)';
1430: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
1431: END IF;
1432:
1433: -- Logging Infra: Statement level
1434: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1438: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1434: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1435: l_log_msg := 'Parameters ';
1436: l_log_msg := l_log_msg||'P_Party_Id: '||to_char(p_party_id);
1437: l_log_msg := l_log_msg||'P_Party_Type: '||p_party_type;
1438: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1439: END IF;
1440: -- Logging Infra: Statement level
1441:
1442: -- Initialize Return Status and Error Buffer

Line 1460: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1456:
1457: -- Logging Infra: Statement level
1458: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1459: l_log_msg := 'Parameter P_Party_ID and/or Party_Type are null ';
1460: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1461: END IF;
1462: -- Logging Infra: Statement level
1463:
1464: --x_return_status := FND_API.G_RET_STS_ERROR;

Line 1484: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.END', l_log_msg);

1480:
1481: -- Logging Infra: Procedure level
1482: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1483: l_log_msg := l_procedure_name||'(-)';
1484: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.END', l_log_msg);
1485: END IF;
1486: return(null);
1487: EXCEPTION
1488: WHEN NO_DATA_FOUND THEN

Line 1498: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1494:
1495: -- Logging Infra: Statement level
1496: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1497: l_log_msg := 'NO DATA FOUND EXCEP - Error Message: '||SQLERRM;
1498: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1499: END IF;
1500: -- Logging Infra: Statement level
1501: */
1502: NULL;

Line 1513: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1509: x_return_status := FND_API.G_RET_STS_ERROR;
1510: -- Logging Infra: Statement level
1511: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1512: l_log_msg := 'NO DATA FOUND EXCEP - Error Message: '||SQLERRM;
1513: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1514: END IF;
1515:
1516: WHEN OTHERS THEN
1517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1523: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1519: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1520: -- Logging Infra: Statement level
1521: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1522: l_log_msg := 'Error Message: '||SQLERRM;
1523: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1524: END IF;
1525: -- Logging Infra: Statement level
1526:
1527: End Get_Default_Tax_Reg;

Line 1540: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1536: p_country IN ZX_PARTY_TAX_PROFILE.Country_code%type
1537: ) RETURN Number IS
1538: l_legal_entity_id NUMBER;
1539: BEGIN
1540: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1541: IF p_registration_num IS NOT NULL THEN
1542: SELECT distinct xle.legal_entity_id
1543: INTO l_legal_entity_id
1544: from zx_registrations tr, zx_party_tax_profile ptp, xle_etb_profiles xle

Line 1553: FND_LOG.STRING(G_LEVEL_STATEMENT,

1549: ELSE
1550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1551: --FND_MESSAGE.Set_Name ('ZX','ZX_REG_NUM_MANDATORY');
1552: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1553: FND_LOG.STRING(G_LEVEL_STATEMENT,
1554: G_MODULE_NAME || 'get_le_from_tax_registration',
1555: 'Registration Number is mandatory but it is null.');
1556: END IF;
1557: END IF;

Line 1581: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1577: l_index BINARY_INTEGER;
1578:
1579: BEGIN
1580:
1581: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1582: x_return_status := FND_API.G_RET_STS_SUCCESS;
1583: x_found_in_cache := FALSE;
1584:
1585: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 1586: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info.BEGIN',

1582: x_return_status := FND_API.G_RET_STS_SUCCESS;
1583: x_found_in_cache := FALSE;
1584:
1585: IF (g_level_statement >= g_current_runtime_level ) THEN
1586: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info.BEGIN',
1587: 'ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info(+)');
1588: END IF;
1589:
1590:

Line 1602: FND_LOG.STRING(g_level_statement,

1598:
1599: IF ZX_GLOBAL_STRUCTURES_PKG.FC_COUNTRY_DEF_VAL_TBL.EXISTS(l_index)
1600: THEN
1601: IF (g_level_statement >= g_current_runtime_level ) THEN
1602: FND_LOG.STRING(g_level_statement,
1603: 'ZX.PLSQL.LSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info',
1604: 'Default Classification type '||p_classification_type||
1605: ' for country code '||p_country_code||' from cache, at index = ' || to_char(l_index));
1606: END IF;

Line 1612: FND_LOG.STRING(g_level_statement,

1608: x_classification_rec := ZX_GLOBAL_STRUCTURES_PKG.FC_COUNTRY_DEF_VAL_TBL(l_index);
1609:
1610: ELSE
1611: IF (g_level_statement >= g_current_runtime_level ) THEN
1612: FND_LOG.STRING(g_level_statement,
1613: 'ZX.PLSQL.LSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info',
1614: 'Default Classification type '||p_classification_type||
1615: ' for country code '||p_country_code||' not found in cache ');
1616: END IF;

Line 1621: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info.BEGIN',

1617:
1618: END IF;
1619:
1620: IF (g_level_statement >= g_current_runtime_level ) THEN
1621: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info.BEGIN',
1622: 'ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info(-)');
1623: END IF;
1624:
1625: END get_fc_country_def_cache_info;