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.32.12010000.4 2008/11/12 12:42:04 spasala ship $ */
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:
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 395: FND_LOG.STRING(G_LEVEL_STATEMENT,

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

Line 417: FND_LOG.STRING(G_LEVEL_STATEMENT,

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

Line 433: FND_LOG.STRING(G_LEVEL_STATEMENT,

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

Line 475: FND_LOG.STRING(G_LEVEL_STATEMENT,

471: -- Logging Infra: YK: 3/10: Break point
472: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
473: l_log_msg := 'B: CUR: c_model_intended_use: fetched: l_owner_table=' || l_owner_table ||
474: ', l_owner_id_num=' || l_owner_id_num;
475: FND_LOG.STRING(G_LEVEL_STATEMENT,
476: G_MODULE_NAME || l_procedure_name,
477: l_log_msg);
478: END IF;
479:

Line 489: FND_LOG.STRING(G_LEVEL_STATEMENT,

485:
486: -- Logging Infra: YK: 3/10: Break point
487: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
488: l_log_msg := 'E: CUR: c_model_intended_use: notfound';
489: FND_LOG.STRING(G_LEVEL_STATEMENT,
490: G_MODULE_NAME || l_procedure_name,
491: l_log_msg);
492: END IF;
493: return;

Line 508: FND_LOG.STRING(G_LEVEL_STATEMENT,

504:
505: -- Logging Infra: YK: 3/10: Break point
506: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
507: l_log_msg := 'B: CUR: c_country_default: fetched: l_intended_use=' || l_intended_use;
508: FND_LOG.STRING(G_LEVEL_STATEMENT,
509: G_MODULE_NAME || l_procedure_name,
510: l_log_msg);
511: END IF;
512:

Line 540: FND_LOG.STRING(G_LEVEL_STATEMENT,

536:
537: -- Logging Infra: YK: 3/10: Break point: Assuming this is successful condition
538: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
539: l_log_msg := 'S: p_default_code=' || p_default_code;
540: FND_LOG.STRING(G_LEVEL_STATEMENT,
541: G_MODULE_NAME || l_procedure_name,
542: l_log_msg);
543: END IF;
544:

Line 553: FND_LOG.STRING(G_LEVEL_STATEMENT,

549:
550: -- Logging Infra: YK: 3/10: Break point
551: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
552: l_log_msg := 'B: CUR: c_item_category: fetched: l_category_id=' || l_category_id;
553: FND_LOG.STRING(G_LEVEL_STATEMENT,
554: G_MODULE_NAME || l_procedure_name,
555: l_log_msg);
556: END IF;
557:

Line 570: FND_LOG.STRING(G_LEVEL_STATEMENT,

566: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
567: l_log_msg := 'E: CUR: c_item_category: rowcount > 1: category_set_id=' || l_owner_id_num ||
568: ', organization_id=' || p_org_id ||
569: ', inventory_item_id='|| p_item_id;
570: FND_LOG.STRING(G_LEVEL_STATEMENT,
571: G_MODULE_NAME || l_procedure_name,
572: l_log_msg);
573: END IF;
574: RETURN;

Line 586: FND_LOG.STRING(G_LEVEL_STATEMENT,

582:
583: -- Logging Infra: YK: 3/11: Break point
584: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
585: l_log_msg := 'B: CUR: c_category_code: fetched: l_category_code=' || l_category_code;
586: FND_LOG.STRING(G_LEVEL_STATEMENT,
587: G_MODULE_NAME || l_procedure_name,
588: l_log_msg);
589: END IF;
590:

Line 602: FND_LOG.STRING(G_LEVEL_STATEMENT,

598: -- Logging Infra: YK: 3/10: Break point:
599: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
600: l_log_msg := 'E: CUR: c_category_code: notfound: category_set_id=' || l_owner_id_num ||
601: ', category_id=' || l_category_id;
602: FND_LOG.STRING(G_LEVEL_STATEMENT,
603: G_MODULE_NAME || l_procedure_name,
604: l_log_msg);
605: END IF;
606:

Line 649: FND_LOG.STRING(G_LEVEL_STATEMENT,

645:
646: -- Logging Infra: YK: 3/11: Break point
647: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
648: l_log_msg := 'B: CUR: c_country_default: fetched: l_product_category_code=' || l_product_category_code;
649: FND_LOG.STRING(G_LEVEL_STATEMENT,
650: G_MODULE_NAME || l_procedure_name,
651: l_log_msg);
652: END IF;
653:

Line 701: FND_LOG.STRING(G_LEVEL_STATEMENT,

697:
698: -- Logging Infra: Break point
699: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
700: l_log_msg := 'B: CUR: c_product_type: fetched: l_product_type=' || l_product_type;
701: FND_LOG.STRING(G_LEVEL_STATEMENT,
702: G_MODULE_NAME || l_procedure_name,
703: l_log_msg);
704: END IF;
705:

Line 748: FND_LOG.STRING(G_LEVEL_STATEMENT,

744:
745: -- Logging Infra: Break point
746: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
747: l_log_msg := 'B: CUR: c_user_defined: fetched: l_classif_code=' || l_classif_code;
748: FND_LOG.STRING(G_LEVEL_STATEMENT,
749: G_MODULE_NAME || l_procedure_name,
750: l_log_msg);
751: END IF;
752:

Line 799: FND_LOG.STRING(G_LEVEL_STATEMENT,

795:
796: -- Logging Infra: Break point
797: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
798: l_log_msg := 'B: CUR: c_document_subtype : fetched: l_classif_code =' || l_classif_code;
799: FND_LOG.STRING(G_LEVEL_STATEMENT,
800: G_MODULE_NAME || l_procedure_name,
801: l_log_msg);
802: END IF;
803:

Line 826: FND_LOG.STRING(G_LEVEL_STATEMENT,

822:
823: -- Logging Infra: YK: 3/11: Break point
824: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
825: l_log_msg := 'B: CUR: c_trx_biz_cat: fetched: l_tax_event_class_code=' || l_tax_event_class_code;
826: FND_LOG.STRING(G_LEVEL_STATEMENT,
827: G_MODULE_NAME || l_procedure_name,
828: l_log_msg);
829: END IF;
830:

Line 851: FND_LOG.STRING(G_LEVEL_STATEMENT,

847:
848: -- Logging Infra: YK: 3/11: Put output value here
849: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
850: l_log_msg := 'R: p_default_code=' || p_default_code;
851: FND_LOG.STRING(G_LEVEL_STATEMENT,
852: G_MODULE_NAME || l_procedure_name,
853: l_log_msg);
854: END IF;
855:

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

855:
856: -- Logging Infra: YK: 3/11: Procedure level
857: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
858: l_log_msg := l_procedure_name||'(-)';
859: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
860: END IF;
861:
862: EXCEPTION
863: WHEN INVALID_CURSOR THEN

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

871: IF c_category_code%isopen THEN CLOSE c_category_code; END IF;
872:
873: -- Logging Infra: YK: 3/12:
874: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
875: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
876: END IF;
877:
878: WHEN FND_API.G_EXC_ERROR THEN
879: p_return_status := FND_API.G_RET_STS_ERROR;

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

883: IF c_category_code%isopen THEN CLOSE c_category_code; END IF;
884:
885:
886: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
887: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
888: END IF;
889:
890:
891: WHEN OTHERS THEN

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

899: IF c_category_code%isopen THEN CLOSE c_category_code; END IF;
900:
901: -- Logging Infra: YK: 3/12:
902: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
903: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
904: END IF;
905:
906: END GET_DEFAULT_CLASSIF_CODE;
907:

Line 936: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

932: L_TBL_INDEX binary_integer;
933:
934: -- Logging Infra:
935: l_procedure_name CONSTANT VARCHAR2(30) := 'get_default_product_classif';
936: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
937:
938: -- Get default Product Fiscal Classification
939:
940: CURSOR c_country_default IS

Line 974: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

970:
971:
972: BEGIN
973: -- Logging Infra: Setting up runtime level
974: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
975:
976: -- Logging Infra: Procedure level
977: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
978: l_log_msg := l_procedure_name||'(+)';

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

975:
976: -- Logging Infra: Procedure level
977: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
978: l_log_msg := l_procedure_name||'(+)';
979: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
980: END IF;
981:
982: -- Logging Infra: YK: 3/12: Break point
983: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 987: FND_LOG.STRING(G_LEVEL_STATEMENT,

983: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
984: l_log_msg := 'B: input params: p_country_code=' || p_country_code ||
985: ', p_item_id =' || p_item_id ||
986: ', p_org_id=' || p_org_id;
987: FND_LOG.STRING(G_LEVEL_STATEMENT,
988: G_MODULE_NAME || l_procedure_name,
989: l_log_msg);
990: END IF;
991:

Line 1005: FND_LOG.STRING(G_LEVEL_STATEMENT,

1001: fnd_message.set_name('ZX','ZX_PARAM_NOT_SET');
1002:
1003: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1004: l_log_msg := 'E: p_country_code is null';
1005: FND_LOG.STRING(G_LEVEL_STATEMENT,
1006: G_MODULE_NAME || l_procedure_name,
1007: l_log_msg);
1008: END IF;
1009: RETURN;

Line 1020: FND_LOG.STRING(G_LEVEL_STATEMENT,

1016: fnd_message.set_name('ZX','ZX_COUNTRY_CODE_INVALID');
1017: -- Logging Infra: YK: 3/10: Break point
1018: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1019: l_log_msg := 'Invalid Country Code: '||p_country_code;
1020: FND_LOG.STRING(G_LEVEL_STATEMENT,
1021: G_MODULE_NAME || l_procedure_name,
1022: l_log_msg);
1023: END IF;
1024: RETURN;

Line 1032: FND_LOG.STRING(G_LEVEL_STATEMENT,

1028:
1029: -- Logging Infra: YK: 3/12: Break point
1030: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1031: l_log_msg := 'B: CUR: c_country_default: fetched: l_category_set=' || l_category_set;
1032: FND_LOG.STRING(G_LEVEL_STATEMENT,
1033: G_MODULE_NAME || l_procedure_name,
1034: l_log_msg);
1035: END IF;
1036:

Line 1046: FND_LOG.STRING(G_LEVEL_STATEMENT,

1042:
1043: -- Logging Infra: YK: 3/12: Break point
1044: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1045: l_log_msg := 'B: CUR: c_country_default: notfound: country_code=' || p_country_code;
1046: FND_LOG.STRING(G_LEVEL_STATEMENT,
1047: G_MODULE_NAME || l_procedure_name,
1048: l_log_msg);
1049: END IF;
1050: return;

Line 1082: FND_LOG.STRING(G_LEVEL_STATEMENT,

1078:
1079: -- Logging Infra: YK: 3/12: Break point
1080: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1081: l_log_msg := 'B: CUR: c_item_categoryt: fetched: l_category_id=' || l_category_id;
1082: FND_LOG.STRING(G_LEVEL_STATEMENT,
1083: G_MODULE_NAME || l_procedure_name,
1084: l_log_msg);
1085: END IF;
1086:

Line 1099: FND_LOG.STRING(G_LEVEL_STATEMENT,

1095: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1096: l_log_msg := 'E: CUR: c_item_category: rowcount > 1: category_set_id=' || l_category_set ||
1097: ', organization_id=' || p_org_id ||
1098: ', inventory_item_id='|| p_item_id;
1099: FND_LOG.STRING(G_LEVEL_STATEMENT,
1100: G_MODULE_NAME || l_procedure_name,
1101: l_log_msg);
1102: END IF;
1103:

Line 1117: FND_LOG.STRING(G_LEVEL_STATEMENT,

1113:
1114: -- Logging Infra: YK: 3/12: Break point
1115: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1116: l_log_msg := 'B: CUR: c_default_category: fetched: l_category_id=' || l_category_id;
1117: FND_LOG.STRING(G_LEVEL_STATEMENT,
1118: G_MODULE_NAME || l_procedure_name,
1119: l_log_msg);
1120: END IF;
1121:

Line 1132: FND_LOG.STRING(G_LEVEL_STATEMENT,

1128:
1129: -- Logging Infra: YK: 3/12: Break point:
1130: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1131: l_log_msg := 'E: CUR: c_default_category: notfound: category_set_id=' || l_category_set;
1132: FND_LOG.STRING(G_LEVEL_STATEMENT,
1133: G_MODULE_NAME || l_procedure_name,
1134: l_log_msg);
1135: END IF;
1136: return;

Line 1150: FND_LOG.STRING(G_LEVEL_STATEMENT,

1146:
1147: -- Logging Infra: YK: 3/12: Break point
1148: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1149: l_log_msg := 'B: CUR: c__category_code: fetched: l_category_code=' || l_category_code;
1150: FND_LOG.STRING(G_LEVEL_STATEMENT,
1151: G_MODULE_NAME || l_procedure_name,
1152: l_log_msg);
1153: END IF;
1154:

Line 1167: FND_LOG.STRING(G_LEVEL_STATEMENT,

1163: -- Logging Infra: YK: 3/12: Break point:
1164: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1165: l_log_msg := 'E: CUR: c_category_code: notfound: category_set_id=' || l_category_set ||
1166: ', category_id=' || l_category_id;
1167: FND_LOG.STRING(G_LEVEL_STATEMENT,
1168: G_MODULE_NAME || l_procedure_name,
1169: l_log_msg);
1170: END IF;
1171:

Line 1186: FND_LOG.STRING(G_LEVEL_STATEMENT,

1182:
1183: -- Logging Infra: YK: 3/12: Put output value here
1184: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1185: l_log_msg := 'R: p_default_code=' || p_default_code;
1186: FND_LOG.STRING(G_LEVEL_STATEMENT,
1187: G_MODULE_NAME || l_procedure_name,
1188: l_log_msg);
1189: END IF;
1190:

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

1190:
1191: -- Logging Infra: YK: 3/12: Procedure level
1192: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1193: l_log_msg := l_procedure_name||'(-)';
1194: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
1195: END IF;
1196:
1197: EXCEPTION
1198: WHEN INVALID_CURSOR THEN

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

1206: IF c_category_code%ISOPEN THEN CLOSE c_category_code; END IF;
1207:
1208: -- Logging Infra: YK: 3/12
1209: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1210: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
1211: END IF;
1212:
1213: WHEN FND_API.G_EXC_ERROR THEN
1214: p_return_status := FND_API.G_RET_STS_ERROR;

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

1218: IF c_category_code%ISOPEN THEN CLOSE c_category_code; END IF;
1219:
1220:
1221: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1222: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
1223: END IF;
1224:
1225:
1226: WHEN OTHERS THEN

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

1234: IF c_category_code%ISOPEN THEN CLOSE c_category_code; END IF;
1235:
1236: -- Logging Infra: YK: 3/12
1237: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1238: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
1239: END IF;
1240:
1241: END GET_DEFAULT_PRODUCT_CLASSIF;
1242:

Line 1359: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1355: RETURN Varchar2
1356: IS
1357: -- Logging Infra
1358: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Default_Tax_Reg';
1359: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1360: l_effective_date zx_registrations.effective_from%Type;
1361: --p_error_buffer varchar2(200);
1362:
1363: Cursor Default_Reg IS

Line 1382: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1378: AND ptp.party_type_code = p_party_type;
1379:
1380: Begin
1381: -- Logging Infra: Setting up runtime level
1382: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1383:
1384: -- Logging Infra: Procedure level
1385: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1386: l_log_msg := l_procedure_name||'(+)';

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

1383:
1384: -- Logging Infra: Procedure level
1385: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1386: l_log_msg := l_procedure_name||'(+)';
1387: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
1388: END IF;
1389:
1390: -- Logging Infra: Statement level
1391: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1391: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1392: l_log_msg := 'Parameters ';
1393: l_log_msg := l_log_msg||'P_Party_Id: '||to_char(p_party_id);
1394: l_log_msg := l_log_msg||'P_Party_Type: '||p_party_type;
1395: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1396: END IF;
1397: -- Logging Infra: Statement level
1398:
1399: -- Initialize Return Status and Error Buffer

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

1413:
1414: -- Logging Infra: Statement level
1415: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1416: l_log_msg := 'Parameter P_Party_ID and/or Party_Type are null ';
1417: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1418: END IF;
1419: -- Logging Infra: Statement level
1420:
1421: --x_return_status := FND_API.G_RET_STS_ERROR;

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

1437:
1438: -- Logging Infra: Procedure level
1439: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1440: l_log_msg := l_procedure_name||'(-)';
1441: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.END', l_log_msg);
1442: END IF;
1443: return(null);
1444: EXCEPTION
1445: WHEN NO_DATA_FOUND THEN

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

1451:
1452: -- Logging Infra: Statement level
1453: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1454: l_log_msg := 'NO DATA FOUND EXCEP - Error Message: '||SQLERRM;
1455: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1456: END IF;
1457: -- Logging Infra: Statement level
1458: */
1459: NULL;

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

1466: x_return_status := FND_API.G_RET_STS_ERROR;
1467: -- Logging Infra: Statement level
1468: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1469: l_log_msg := 'NO DATA FOUND EXCEP - Error Message: '||SQLERRM;
1470: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1471: END IF;
1472:
1473: WHEN OTHERS THEN
1474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1476: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1477: -- Logging Infra: Statement level
1478: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1479: l_log_msg := 'Error Message: '||SQLERRM;
1480: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1481: END IF;
1482: -- Logging Infra: Statement level
1483:
1484: End Get_Default_Tax_Reg;

Line 1532: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1528: l_index BINARY_INTEGER;
1529:
1530: BEGIN
1531:
1532: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1533: x_return_status := FND_API.G_RET_STS_SUCCESS;
1534: x_found_in_cache := FALSE;
1535:
1536: IF (g_level_statement >= g_current_runtime_level ) THEN

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

1533: x_return_status := FND_API.G_RET_STS_SUCCESS;
1534: x_found_in_cache := FALSE;
1535:
1536: IF (g_level_statement >= g_current_runtime_level ) THEN
1537: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info.BEGIN',
1538: 'ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info(+)');
1539: END IF;
1540:
1541:

Line 1553: FND_LOG.STRING(g_level_statement,

1549:
1550: IF ZX_GLOBAL_STRUCTURES_PKG.FC_COUNTRY_DEF_VAL_TBL.EXISTS(l_index)
1551: THEN
1552: IF (g_level_statement >= g_current_runtime_level ) THEN
1553: FND_LOG.STRING(g_level_statement,
1554: 'ZX.PLSQL.LSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info',
1555: 'Default Classification type '||p_classification_type||
1556: ' for country code '||p_country_code||' from cache, at index = ' || to_char(l_index));
1557: END IF;

Line 1563: FND_LOG.STRING(g_level_statement,

1559: x_classification_rec := ZX_GLOBAL_STRUCTURES_PKG.FC_COUNTRY_DEF_VAL_TBL(l_index);
1560:
1561: ELSE
1562: IF (g_level_statement >= g_current_runtime_level ) THEN
1563: FND_LOG.STRING(g_level_statement,
1564: 'ZX.PLSQL.LSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info',
1565: 'Default Classification type '||p_classification_type||
1566: ' for country code '||p_country_code||' not found in cache ');
1567: END IF;

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

1568:
1569: END IF;
1570:
1571: IF (g_level_statement >= g_current_runtime_level ) THEN
1572: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info.BEGIN',
1573: 'ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info(-)');
1574: END IF;
1575:
1576: END get_fc_country_def_cache_info;