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

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

3:
4: -- Logging Infra
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_TCM_PTP_PKG';
6: G_CURRENT_RUNTIME_LEVEL NUMBER;
7: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
9: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
11: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

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

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

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

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

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

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

7: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
9: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
11: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
13: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_TCM_PTP_PKG';
14:
15: TYPE l_ptp_id_rec_type IS RECORD(

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

8: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
9: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
11: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
13: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_TCM_PTP_PKG';
14:
15: TYPE l_ptp_id_rec_type IS RECORD(
16: le_id NUMBER,

Line 148: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

144: l_party_name VARCHAR2(240);
145:
146: -- Logging Infra
147: l_procedure_name CONSTANT VARCHAR2(30) := '.GET_PTP ';
148: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
149:
150: BEGIN
151: --------------------------------------------------------------------------------------
152: -- Logging Infra: Setting up runtime level

Line 153: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

149:
150: BEGIN
151: --------------------------------------------------------------------------------------
152: -- Logging Infra: Setting up runtime level
153: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
154:
155: -- Logging Infra: Statement level
156: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
157: l_log_msg := l_procedure_name||' (+) ';

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

160: ' p_party_id: '||to_char(p_party_id)||
161: ' p_Party_Type_Code: '||p_Party_Type_Code||
162: ' p_le_id: '||to_char(p_le_id)||
163: ' p_inventory_loc: '||to_char(p_inventory_loc)||' ';
164: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
165: END IF;
166: -- Logging Infra: Statement level
167: --------------------------------------------------------------------------------------
168:

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

172: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173:
174: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
175: l_log_msg := 'party type is null for party_id ' || to_char(p_party_id);
176: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_procedure_name, l_log_msg);
177: END IF;
178: --FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');
179: RETURN;
180: END IF; -- Null parameters

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

198: ----------------------------------------------------------------------------------
199: -- Logging Infra: Statement level
200: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
201: l_log_msg := 'Getting PTP from Location and LE.PTP_ID: '||to_char(p_ptp_id)||' ';
202: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
203: END IF;
204: -- Logging Infra: Statement level
205: ----------------------------------------------------------------------------------
206:

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

226: ---------------------------------------------------------------------------------
227: -- Logging Infra: Statement level
228: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
229: l_log_msg := 'Getting PTP from Location and LE.PTP_ID: '||to_char(p_ptp_id)||' ';
230: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
231: END IF;
232: -- Logging Infra: Statement level
233: ---------------------------------------------------------------------------------
234:

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

254: ---------------------------------------------------------------------------------
255: -- Logging Infra: Statement level
256: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
257: l_log_msg := 'Getting PTP from Inv Organization and LE.PTP_ID: '||to_char(p_ptp_id)||' ';
258: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
259: END IF;
260: -- Logging Infra: Statement level
261: ---------------------------------------------------------------------------------
262:

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

282: ---------------------------------------------------------------------------------
283: -- Logging Infra: Statement level
284: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
285: l_log_msg := 'Getting PTP from Operating Unit and LE.PTP_ID: '||to_char(p_ptp_id)||' ';
286: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
287: END IF;
288: -- Logging Infra: Statement level
289: ---------------------------------------------------------------------------------
290:

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

301: ---------------------------------------------------------------------------------
302: -- Logging Infra: Statement level
303: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
304: l_log_msg := 'There is not an establishment associated. Returning without error.';
305: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
306: END IF;
307: ---------------------------------------------------------------------------------
308: p_return_status := FND_API.G_RET_STS_SUCCESS;
309: END IF; -- If5

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

325: ---------------------------------------------------------------------------------
326: -- Logging Infra: Statement level
327: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
328: l_log_msg := 'Getting PTP First Party: '||to_char(p_ptp_id)||' ';
329: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
330: END IF;
331: -- Logging Infra: Statement level
332: ---------------------------------------------------------------------------------
333:

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

352: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
353: l_log_msg := 'Get PTP is not able to return a row for the given party and party type code.
354: Returning with success. Party_id: '
355: ||p_party_type_code||', '||to_char(p_party_id)||' ';
356: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_procedure_name, l_log_msg);
357: END IF;
358: ---------------------------------------------------------------------------------
359: p_ptp_id := NULL;
360: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

364: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
365: l_log_msg := 'Get PTP is not able to return a row for the given party and party type code.
366: Returning with error. Party_id: '
367: ||p_party_type_code||', '||to_char(p_party_id)||' ';
368: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_procedure_name, l_log_msg);
369: END IF;
370: ---------------------------------------------------------------------------------
371: -- Bug 4512462
372: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');

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

381: -- Logging Infra: Statement level
382: ---------------------------------------------------------------------------------
383: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
384: l_log_msg := 'Getting PTP For Other Party Types: '||p_party_type_code||', '||to_char(p_ptp_id)||' ';
385: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
386: END IF;
387: -- Logging Infra: Statement level
388: ---------------------------------------------------------------------------------
389: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

393: ---------------------------------------------------------------------------------
394: -- Logging Infra: Procedure level
395: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
396: l_log_msg := l_procedure_name||' (-) ';
397: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.END ', l_log_msg);
398: END IF;
399: ---------------------------------------------------------------------------------
400:
401: EXCEPTION

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

403: -- Logging Infra: Statement level
404: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
405: l_log_msg := 'Get PTP is not able to return a row for the given party. Returning with error. Party_id: '
406: ||p_party_type_code||', '||to_char(p_party_id)||' ';
407: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_procedure_name, l_log_msg);
408: END IF;
409:
410: -- Bug 4512462
411: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');

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

426: --FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
427: -- Logging Infra: Statement level
428: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
429: l_log_msg := 'Error Message: '||SQLERRM;
430: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
431: END IF;
432: WHEN OTHERS THEN
433: -- bug 8568734
434: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

437:
438: -- Logging Infra: Statement level
439: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
440: l_log_msg := 'Error Message: '||SQLERRM;
441: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
442: END IF;
443: -- Logging Infra: Statement level
444:
445: END GET_PTP;

Line 473: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

469: AND xlep.main_establishment_flag = 'Y';
470:
471: -- Logging Infra
472: l_procedure_name CONSTANT VARCHAR2(30) := '.GET_PTP_HQ';
473: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
474:
475: l_ptp_id_indx BINARY_INTEGER;
476:
477: -- bug8568734

Line 487: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

483:
484: BEGIN
485: ---------------------------------------------------------------------------------
486: -- Logging Infra: Setting up runtime level
487: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
488:
489: -- Logging Infra: Statement level
490: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
491: l_log_msg := l_procedure_name||'(+)';

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

491: l_log_msg := l_procedure_name||'(+)';
492: l_log_msg := l_log_msg||'
493: Parameters: ';
494: l_log_msg := l_log_msg||'p_le_id: '||to_char(p_le_id);
495: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
496: END IF;
497: -- Logging Infra: Statement level
498: ---------------------------------------------------------------------------------
499: l_ptp_id_indx := dbms_utility.get_hash_value('LEGAL_ESTABLISHMENT'||to_char(p_le_id), 1, 8192);

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

530: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
531: l_log_msg := 'PTP for HQ Establlishment: '||to_char(p_ptp_id);
532: l_log_msg := l_log_msg||'
533: '||l_procedure_name||'(-)';
534: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
535: END IF;
536: -- Logging Infra: Statement level
537: ---------------------------------------------------------------------------------
538: EXCEPTION

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

541: --FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
542: --FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
543: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
544: l_log_msg := 'Error Message: '||SQLERRM;
545: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
546: END IF;
547:
548: WHEN OTHERS THEN
549: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

552:
553: -- Logging Infra: Statement level
554: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
555: l_log_msg := 'Error Message: '||SQLERRM;
556: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
557: END IF;
558: -- Logging Infra: Statement level
559:
560: END GET_PTP_HQ;

Line 586: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

582: AND ptp.Party_Type_Code = 'FIRST_PARTY';
583:
584: -- Logging Infra
585: l_procedure_name CONSTANT VARCHAR2(30) := '.GET_TAX_SUBSCRIBER';
586: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
587: l_tbl_index BINARY_INTEGER;
588:
589: -- BUG 8568734
590: CURSOR get_ou_name_csr IS

Line 605: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

601:
602: BEGIN
603: ---------------------------------------------------------------------------------
604: -- Logging Infra: Setting up runtime level
605: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
606:
607: -- Logging Infra: Statement level
608: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
609: l_log_msg := l_procedure_name||'(+)';

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

610: l_log_msg := l_log_msg|| '
611: Parameters:
612: p_le_id: '||to_char(p_le_id)||' '
613: ||'p_org_id: '||to_char(p_org_id);
614: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
615: END IF;
616: -- Logging Infra: Statement level
617: ---------------------------------------------------------------------------------
618:

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

626: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627: -- Logging Infra: Statement level
628: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
629: l_log_msg := 'Legal Entity Id is NULL';
630: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
631: END IF;
632: -- FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
633:
634: --

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

740: -- Logging Infra: Statement level
741: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
742: l_log_msg := 'Getting PTP from LE_ID: '||to_char(p_ptp_id)||' ';
743: l_log_msg := l_log_msg||' l_chk_le_flg = Y';
744: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
745: END IF;
746: -- Logging Infra: Statement level
747: ---------------------------------------------------------------------------------
748:

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

752: ---------------------------------------------------------------------------------
753: -- Logging Infra: Statement level
754: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
755: l_log_msg := 'Invalid l_chk_le_flg';
756: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
757: END IF;
758: -- Logging Infra: Statement level
759: ---------------------------------------------------------------------------------
760: END IF;

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

782: ---------------------------------------------------------------------------------
783: -- Logging Infra: Statement level
784: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
785: l_log_msg := 'Getting PTP from LE_ID: '||to_char(p_ptp_id)||' ';
786: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
787: END IF;
788: -- Logging Infra: Statement level
789: ---------------------------------------------------------------------------------
790:

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

795: ---------------------------------------------------------------------------------
796: -- Logging Infra: Statement level
797: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
798: l_log_msg := 'Invalid p_le_id, p_org_id';
799: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
800: END IF;
801: -- Logging Infra: Statement level
802: ---------------------------------------------------------------------------------
803: --FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');

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

806: ---------------------------------------------------------------------------------
807: -- Logging Infra: Procedure level
808: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
809: l_log_msg := l_procedure_name||'(-)';
810: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
811: END IF;
812: ---------------------------------------------------------------------------------
813:
814: EXCEPTION

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

817: --FND_MESSAGE.SET_NAME ('ZX','ZX_GENERIC_MESSAGE');
818: --FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', SQLERRM);
819: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
820: l_log_msg := 'Error Message: '||SQLERRM;
821: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
822: END IF;
823: WHEN OTHERS THEN
824: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
825: --FND_MESSAGE.SET_NAME ('ZX','ZX_GENERIC_MESSAGE');

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

827:
828: -- Logging Infra: Statement level
829: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
830: l_log_msg := 'Error Message: '||SQLERRM;
831: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
832: END IF;
833: -- Logging Infra: Statement level
834:
835: END GET_TAX_SUBSCRIBER;

Line 858: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

854: WHERE organization_id = p_org_id;
855:
856: -- Logging Infra
857: l_procedure_name CONSTANT VARCHAR2(30) := '.GET_LOCATION_ID';
858: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
859:
860: l_party_name VARCHAR2(240);
861:
862: BEGIN

Line 868: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

864: -- Get the location_id of internal_organization_id
865: --
866: --------------------------------------------------------------------------------
867: -- Logging Infra: Setting up runtime level
868: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
869:
870: -- Logging Infra: Statement level
871: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
872: l_log_msg := l_procedure_name||'(+)';

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

872: l_log_msg := l_procedure_name||'(+)';
873: l_log_msg := l_log_msg||
874: 'Parameters: ';
875: l_log_msg := l_log_msg||'p_org_id: '||to_char(p_org_id);
876: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
877: END IF;
878: -- Logging Infra: Statement level
879: --------------------------------------------------------------------------------
880:

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

885: --------------------------------------------------------------------------------
886: -- Logging Infra: Statement level
887: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
888: l_log_msg := 'No data found - The organization has not been defined ';
889: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
890: END IF;
891: -- Logging Infra: Statement level
892: --------------------------------------------------------------------------------
893: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

897: --------------------------------------------------------------------------------
898: -- Logging Infra: Statement level
899: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
900: l_log_msg := 'There is not location associated to the Organization ID ';
901: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
902: END IF;
903: -- Logging Infra: Statement level
904: --------------------------------------------------------------------------------
905: p_return_status := FND_API.G_RET_STS_ERROR;

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

913: --------------------------------------------------------------------------------
914: -- Logging Infra: Statement level
915: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
916: l_log_msg := 'Getting Location Id for the OU: '||to_char(p_location_id);
917: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
918: END IF;
919: -- Logging Infra: Statement level
920: --------------------------------------------------------------------------------
921:

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

923: --------------------------------------------------------------------------------
924: -- Logging Infra: Procedure level
925: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
926: l_log_msg := l_procedure_name||'(-)';
927: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
928: END IF;
929: --------------------------------------------------------------------------------
930:
931: EXCEPTION

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

934: --FND_MESSAGE.SET_NAME ('ZX','ZX_GENERIC_MESSAGE');
935: --FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', SQLERRM);
936: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
937: l_log_msg := 'Error Message: '||SQLERRM;
938: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
939: END IF;
940:
941: WHEN OTHERS THEN
942: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

946: -----------------------------------------------------------------------------
947: -- Logging Infra: Statement level
948: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
949: l_log_msg := 'Error Message: '||SQLERRM;
950: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
951: END IF;
952: -- Logging Infra: Statement level
953: -----------------------------------------------------------------------------
954:

Line 978: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

974: l_tax_registration_id ZX_REGISTRATIONS.REGISTRATION_ID%TYPE;
975:
976: -- Logging Infra
977: l_procedure_name CONSTANT VARCHAR2(30) := '.CHECK_TAX_REGISTRATIONS';
978: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
979:
980: CURSOR c_get_reg_id
981: IS
982: SELECT registration_id

Line 989: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

985:
986: BEGIN
987:
988: -- Logging Infra: Setting up runtime level
989: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
990:
991: -- Logging Infra: Statement level
992: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
993: l_log_msg := l_procedure_name||'(+)';

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

993: l_log_msg := l_procedure_name||'(+)';
994: l_log_msg := l_log_msg||
995: 'Parameters: ';
996: l_log_msg := l_log_msg||'p_le_reg_id: '||to_char(p_le_reg_id);
997: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
998: END IF;
999: -- Logging Infra: Statement level
1000:
1001:

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

1034:
1035: -- Logging Infra: Statement level
1036: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1037: l_log_msg := 'There is no tax registrations which is from legal registrations.';
1038: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1039: END IF;
1040: -- Logging Infra: Statement level
1041:
1042: ELSE

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

1046:
1047: -- Logging Infra: Procedure level
1048: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1049: l_log_msg := l_procedure_name||'-)';
1050: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
1051: END IF;
1052:
1053: EXCEPTION
1054: WHEN FND_API.G_EXC_ERROR THEN

Line 1059: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');

1055: ROLLBACK TO Check_Tax_Registrations_PVT;
1056: x_return_status := FND_API.G_RET_STS_ERROR ;
1057:
1058: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
1059: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
1060: END IF;
1061:
1062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1063: ROLLBACK TO Check_Tax_Registrations_PVT;

Line 1067: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,'');

1063: ROLLBACK TO Check_Tax_Registrations_PVT;
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1065:
1066: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1067: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,'');
1068: END IF;
1069:
1070: WHEN INVALID_CURSOR THEN
1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1072: --FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');
1073: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1074: l_log_msg := 'Error Message: '||SQLERRM;
1075: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1076: END IF;
1077:
1078: WHEN OTHERS THEN
1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1081:
1082: -- Logging Infra: Statement level
1083: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1084: l_log_msg := 'Error Message: '||SQLERRM;
1085: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1086: END IF;
1087: -- Logging Infra: Statement level
1088:
1089: END CHECK_TAX_REGISTRATIONS;

Line 1186: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1182: WHERE legal_registration_id = p_le_old_reg_id;
1183:
1184: -- Logging Infra
1185: l_procedure_name CONSTANT VARCHAR2(30) := 'SYNC_TAX_REGISTRATIONS';
1186: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1187:
1188: BEGIN
1189:
1190: -- Logging Infra: Setting up runtime level

Line 1191: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1187:
1188: BEGIN
1189:
1190: -- Logging Infra: Setting up runtime level
1191: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1192:
1193: -- Logging Infra: Statement level
1194: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1195: l_log_msg := l_procedure_name||'(+)';

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

1197: ' Parameters '||
1198: 'p_le_old_reg_id: '||to_char(p_le_old_reg_id)||
1199: 'p_le_new_reg_id: '||to_char(p_le_new_reg_id)||
1200: 'p_le_new_reg_num: '||p_le_new_reg_num;
1201: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1202: END IF;
1203: -- Logging Infra: Statement level
1204:
1205: /*--------------------------------------------------+

Line 1295: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

1291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1292: -- FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');
1293: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1294: l_log_msg := 'c_find_reg_num%ROWCOUNT = 0';
1295: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
1296: END IF;
1297:
1298: EXIT;
1299: CLOSE c_find_reg_num;

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

1555:
1556: -- Logging Infra: Procedure level
1557: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1558: l_log_msg := l_procedure_name||'(-)';
1559: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
1560: END IF;
1561:
1562: EXCEPTION
1563:

Line 1569: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');

1565: ROLLBACK TO Sync_Tax_Registrations_PVT;
1566: x_return_status := FND_API.G_RET_STS_ERROR ;
1567:
1568: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
1569: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
1570: END IF;
1571:
1572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1573: ROLLBACK TO Sync_Tax_Registrations_PVT;

Line 1577: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,'');

1573: ROLLBACK TO Sync_Tax_Registrations_PVT;
1574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1575:
1576: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1577: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,'');
1578: END IF;
1579:
1580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1581: --FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');

Line 1585: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_api_name, l_log_msg);

1581: --FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');
1582: -- Logging Infra: Statement level
1583: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1584: l_log_msg := 'Error Message: '||SQLERRM;
1585: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_api_name, l_log_msg);
1586: END IF;
1587: WHEN OTHERS THEN
1588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1589: --FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');

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

1589: --FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');
1590: -- Logging Infra: Statement level
1591: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1592: l_log_msg := 'Error Message: '||SQLERRM;
1593: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_api_name, l_log_msg);
1594: END IF;
1595:
1596: END SYNC_TAX_REGISTRATIONS;
1597:

Line 1635: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1631: WHERE ptp.party_id = p_party_id
1632: AND ptp.party_type_code = p_party_type_code;
1633:
1634: l_tbl_index binary_integer;
1635: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1636:
1637: BEGIN
1638:
1639: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1651: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);

1647:
1648: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1649: l_log_msg := 'Party Tax Profile Id info for party_id: '||to_char(p_party_id)||' and party_type_code '
1650: ||p_party_type_code||' found in cache at index: '||to_char(l_tbl_index);
1651: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);
1652: END IF;
1653:
1654: X_TBL_INDEX := l_tbl_index;
1655: RETURN;

Line 1698: FND_LOG.STRING(G_LEVEL_PROCEDURE,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);

1694: EXCEPTION
1695: WHEN no_data_found then
1696: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1697: l_log_msg := 'No Data found in ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO. Still returning with success';
1698: FND_LOG.STRING(G_LEVEL_PROCEDURE,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);
1699: END IF;
1700: X_TBL_INDEX := NULL;
1701: WHEN others then
1702: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1704: FND_LOG.STRING(G_LEVEL_UNEXPECTED,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);

1700: X_TBL_INDEX := NULL;
1701: WHEN others then
1702: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1703: l_log_msg := 'Unexpected error in ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO: '||SQLCODE||' ; '||SQLERRM;
1704: FND_LOG.STRING(G_LEVEL_UNEXPECTED,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);
1705: END IF;
1706:
1707: END GET_PARTY_TAX_PROF_INFO;
1708:

Line 1744: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1740: ptp.rounding_rule_code
1741: FROM zx_party_tax_profile ptp
1742: WHERE party_tax_profile_id = p_party_tax_profile_id;
1743:
1744: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1745: l_tbl_index binary_integer;
1746:
1747: BEGIN
1748:

Line 1756: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);

1752: THEN
1753:
1754: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1755: l_log_msg := 'Party Tax Profile Id info found in cache ';
1756: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);
1757: END IF;
1758:
1759: X_TBL_INDEX := p_party_tax_profile_id;
1760: RETURN;

Line 1805: FND_LOG.STRING(G_LEVEL_PROCEDURE,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);

1801:
1802: WHEN no_data_found then
1803: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1804: l_log_msg := 'No Data found in ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO. Still returning with success';
1805: FND_LOG.STRING(G_LEVEL_PROCEDURE,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);
1806: END IF;
1807: X_TBL_INDEX := NULL;
1808:
1809: WHEN others then

Line 1812: FND_LOG.STRING(G_LEVEL_UNEXPECTED,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);

1808:
1809: WHEN others then
1810: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1811: l_log_msg := 'Unexpected error in ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO: '||SQLCODE||' ; '||SQLERRM;
1812: FND_LOG.STRING(G_LEVEL_UNEXPECTED,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);
1813: END IF;
1814:
1815: END GET_PARTY_TAX_PROF_INFO;
1816: