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 141: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

137: l_tbl_index binary_integer;
138:
139: -- Logging Infra
140: l_procedure_name CONSTANT VARCHAR2(30) := '.GET_PTP ';
141: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
142:
143: BEGIN
144: --------------------------------------------------------------------------------------
145: -- Logging Infra: Setting up runtime level

Line 146: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

142:
143: BEGIN
144: --------------------------------------------------------------------------------------
145: -- Logging Infra: Setting up runtime level
146: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
147:
148: -- Logging Infra: Statement level
149: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
150: l_log_msg := l_procedure_name||' (+) ';

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

153: ' p_party_id: '||to_char(p_party_id)||
154: ' p_Party_Type_Code: '||p_Party_Type_Code||
155: ' p_le_id: '||to_char(p_le_id)||
156: ' p_inventory_loc: '||to_char(p_inventory_loc)||' ';
157: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
158: END IF;
159: -- Logging Infra: Statement level
160: --------------------------------------------------------------------------------------
161:

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

185: ----------------------------------------------------------------------------------
186: -- Logging Infra: Statement level
187: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
188: l_log_msg := 'Getting PTP from Location and LE.PTP_ID: '||to_char(p_ptp_id)||' ';
189: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
190: END IF;
191: -- Logging Infra: Statement level
192: ----------------------------------------------------------------------------------
193:

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

213: ---------------------------------------------------------------------------------
214: -- Logging Infra: Statement level
215: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
216: l_log_msg := 'Getting PTP from Location and LE.PTP_ID: '||to_char(p_ptp_id)||' ';
217: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
218: END IF;
219: -- Logging Infra: Statement level
220: ---------------------------------------------------------------------------------
221:

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

241: ---------------------------------------------------------------------------------
242: -- Logging Infra: Statement level
243: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
244: l_log_msg := 'Getting PTP from Inv Organization and LE.PTP_ID: '||to_char(p_ptp_id)||' ';
245: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
246: END IF;
247: -- Logging Infra: Statement level
248: ---------------------------------------------------------------------------------
249:

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

269: ---------------------------------------------------------------------------------
270: -- Logging Infra: Statement level
271: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
272: l_log_msg := 'Getting PTP from Operating Unit and LE.PTP_ID: '||to_char(p_ptp_id)||' ';
273: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
274: END IF;
275: -- Logging Infra: Statement level
276: ---------------------------------------------------------------------------------
277:

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

288: ---------------------------------------------------------------------------------
289: -- Logging Infra: Statement level
290: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
291: l_log_msg := 'There is not an establishment associated. Returning without error.';
292: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
293: END IF;
294: ---------------------------------------------------------------------------------
295: p_return_status := FND_API.G_RET_STS_SUCCESS;
296: END IF; -- If5

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

312: ---------------------------------------------------------------------------------
313: -- Logging Infra: Statement level
314: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
315: l_log_msg := 'Getting PTP First Party: '||to_char(p_ptp_id)||' ';
316: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
317: END IF;
318: -- Logging Infra: Statement level
319: ---------------------------------------------------------------------------------
320:

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

339: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
340: l_log_msg := 'Get PTP is not able to return a row for the given party and party type code.
341: Returning with success. Party_id: '
342: ||p_party_type_code||', '||to_char(p_party_id)||' ';
343: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_procedure_name, l_log_msg);
344: END IF;
345: ---------------------------------------------------------------------------------
346: p_ptp_id := NULL;
347: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

351: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
352: l_log_msg := 'Get PTP is not able to return a row for the given party and party type code.
353: Returning with error. Party_id: '
354: ||p_party_type_code||', '||to_char(p_party_id)||' ';
355: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_procedure_name, l_log_msg);
356: END IF;
357: ---------------------------------------------------------------------------------
358: -- Bug 4512462
359: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');

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

367: -- Logging Infra: Statement level
368: ---------------------------------------------------------------------------------
369: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
370: l_log_msg := 'Getting PTP For Other Party Types: '||p_party_type_code||', '||to_char(p_ptp_id)||' ';
371: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
372: END IF;
373: -- Logging Infra: Statement level
374: ---------------------------------------------------------------------------------
375: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 383: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.END ', 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||'.END ', l_log_msg);
384: END IF;
385: ---------------------------------------------------------------------------------
386:
387: EXCEPTION

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

389: -- Logging Infra: Statement level
390: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
391: l_log_msg := 'Get PTP is not able to return a row for the given party. Returning with error. Party_id: '
392: ||p_party_type_code||', '||to_char(p_party_id)||' ';
393: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_procedure_name, l_log_msg);
394: END IF;
395: -- Bug 4512462
396: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
397: p_return_status := FND_API.G_RET_STS_ERROR;

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

406:
407: -- Logging Infra: Statement level
408: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
409: l_log_msg := 'Error Message: '||SQLERRM;
410: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
411: END IF;
412: -- Logging Infra: Statement level
413:
414: END GET_PTP;

Line 442: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

438: AND xlep.main_establishment_flag = 'Y';
439:
440: -- Logging Infra
441: l_procedure_name CONSTANT VARCHAR2(30) := '.GET_PTP_HQ';
442: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
443:
444: l_ptp_id_indx BINARY_INTEGER;
445:
446: BEGIN

Line 449: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

445:
446: BEGIN
447: ---------------------------------------------------------------------------------
448: -- Logging Infra: Setting up runtime level
449: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
450:
451: -- Logging Infra: Statement level
452: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
453: l_log_msg := l_procedure_name||'(+)';

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

453: l_log_msg := l_procedure_name||'(+)';
454: l_log_msg := l_log_msg||'
455: Parameters: ';
456: l_log_msg := l_log_msg||'p_le_id: '||to_char(p_le_id);
457: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
458: END IF;
459: -- Logging Infra: Statement level
460: ---------------------------------------------------------------------------------
461: l_ptp_id_indx := dbms_utility.get_hash_value('LEGAL_ESTABLISHMENT'||to_char(p_le_id), 1, 8192);

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

485: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
486: l_log_msg := 'PTP for HQ Establlishment: '||to_char(p_ptp_id);
487: l_log_msg := l_log_msg||'
488: '||l_procedure_name||'(-)';
489: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
490: END IF;
491: -- Logging Infra: Statement level
492: ---------------------------------------------------------------------------------
493: EXCEPTION

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

502:
503: -- Logging Infra: Statement level
504: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
505: l_log_msg := 'Error Message: '||SQLERRM;
506: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
507: END IF;
508: -- Logging Infra: Statement level
509:
510: END GET_PTP_HQ;

Line 538: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

534: AND ptp.Party_Type_Code = 'FIRST_PARTY';
535:
536: -- Logging Infra
537: l_procedure_name CONSTANT VARCHAR2(30) := '.GET_TAX_SUBSCRIBER';
538: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
539: l_tbl_index BINARY_INTEGER;
540:
541: BEGIN
542: ---------------------------------------------------------------------------------

Line 544: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

540:
541: BEGIN
542: ---------------------------------------------------------------------------------
543: -- Logging Infra: Setting up runtime level
544: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
545:
546: -- Logging Infra: Statement level
547: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
548: l_log_msg := l_procedure_name||'(+)';

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

549: l_log_msg := l_log_msg|| '
550: Parameters:
551: p_le_id: '||to_char(p_le_id)||' '
552: ||'p_org_id: '||to_char(p_org_id);
553: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
554: END IF;
555: -- Logging Infra: Statement level
556: ---------------------------------------------------------------------------------
557:

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

650: -- Logging Infra: Statement level
651: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
652: l_log_msg := 'Getting PTP from LE_ID: '||to_char(p_ptp_id)||' ';
653: l_log_msg := l_log_msg||' l_chk_le_flg = Y';
654: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
655: END IF;
656: -- Logging Infra: Statement level
657: ---------------------------------------------------------------------------------
658:

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

678: ---------------------------------------------------------------------------------
679: -- Logging Infra: Statement level
680: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
681: l_log_msg := 'Getting PTP from LE_ID: '||to_char(p_ptp_id)||' ';
682: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
683: END IF;
684: -- Logging Infra: Statement level
685: ---------------------------------------------------------------------------------
686:

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

693: ---------------------------------------------------------------------------------
694: -- Logging Infra: Procedure level
695: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
696: l_log_msg := l_procedure_name||'(-)';
697: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
698: END IF;
699: ---------------------------------------------------------------------------------
700:
701: EXCEPTION

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

710:
711: -- Logging Infra: Statement level
712: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
713: l_log_msg := 'Error Message: '||SQLERRM;
714: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
715: END IF;
716: -- Logging Infra: Statement level
717:
718: END GET_TAX_SUBSCRIBER;

Line 741: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

737: WHERE organization_id = p_org_id;
738:
739: -- Logging Infra
740: l_procedure_name CONSTANT VARCHAR2(30) := '.GET_LOCATION_ID';
741: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
742:
743: BEGIN
744: --
745: -- Get the location_id of internal_organization_id

Line 749: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

745: -- Get the location_id of internal_organization_id
746: --
747: --------------------------------------------------------------------------------
748: -- Logging Infra: Setting up runtime level
749: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
750:
751: -- Logging Infra: Statement level
752: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
753: l_log_msg := l_procedure_name||'(+)';

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

753: l_log_msg := l_procedure_name||'(+)';
754: l_log_msg := l_log_msg||
755: 'Parameters: ';
756: l_log_msg := l_log_msg||'p_org_id: '||to_char(p_org_id);
757: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
758: END IF;
759: -- Logging Infra: Statement level
760: --------------------------------------------------------------------------------
761:

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

766: --------------------------------------------------------------------------------
767: -- Logging Infra: Statement level
768: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
769: l_log_msg := 'No data found - The organization has not been defined ';
770: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
771: END IF;
772: -- Logging Infra: Statement level
773: --------------------------------------------------------------------------------
774: p_return_status := FND_API.G_RET_STS_ERROR;

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

778: --------------------------------------------------------------------------------
779: -- Logging Infra: Statement level
780: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
781: l_log_msg := 'There is not location associated to the Organization ID ';
782: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
783: END IF;
784: -- Logging Infra: Statement level
785: --------------------------------------------------------------------------------
786: p_return_status := FND_API.G_RET_STS_ERROR;

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

793: --------------------------------------------------------------------------------
794: -- Logging Infra: Statement level
795: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
796: l_log_msg := 'Getting Location Id for the OU: '||to_char(p_location_id);
797: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
798: END IF;
799: -- Logging Infra: Statement level
800: --------------------------------------------------------------------------------
801:

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

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

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

821: -----------------------------------------------------------------------------
822: -- Logging Infra: Statement level
823: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
824: l_log_msg := 'Error Message: '||SQLERRM;
825: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
826: END IF;
827: -- Logging Infra: Statement level
828: -----------------------------------------------------------------------------
829:

Line 853: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

849: l_tax_registration_id ZX_REGISTRATIONS.REGISTRATION_ID%TYPE;
850:
851: -- Logging Infra
852: l_procedure_name CONSTANT VARCHAR2(30) := '.CHECK_TAX_REGISTRATIONS';
853: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
854:
855: CURSOR c_get_reg_id
856: IS
857: SELECT registration_id

Line 864: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

860:
861: BEGIN
862:
863: -- Logging Infra: Setting up runtime level
864: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
865:
866: -- Logging Infra: Statement level
867: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
868: l_log_msg := l_procedure_name||'(+)';

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

868: l_log_msg := l_procedure_name||'(+)';
869: l_log_msg := l_log_msg||
870: 'Parameters: ';
871: l_log_msg := l_log_msg||'p_le_reg_id: '||to_char(p_le_reg_id);
872: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
873: END IF;
874: -- Logging Infra: Statement level
875:
876:

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

909:
910: -- Logging Infra: Statement level
911: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
912: l_log_msg := 'There is no tax registrations which is from legal registrations.';
913: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
914: END IF;
915: -- Logging Infra: Statement level
916:
917: ELSE

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

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

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

930: ROLLBACK TO Check_Tax_Registrations_PVT;
931: x_return_status := FND_API.G_RET_STS_ERROR ;
932:
933: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
934: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
935: END IF;
936:
937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
938: ROLLBACK TO Check_Tax_Registrations_PVT;

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

938: ROLLBACK TO Check_Tax_Registrations_PVT;
939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
940:
941: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
942: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,'');
943: END IF;
944:
945: WHEN INVALID_CURSOR THEN
946: x_return_status := FND_API.G_RET_STS_ERROR;

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

952:
953: -- Logging Infra: Statement level
954: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
955: l_log_msg := 'Error Message: '||SQLERRM;
956: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
957: END IF;
958: -- Logging Infra: Statement level
959:
960: END CHECK_TAX_REGISTRATIONS;

Line 1057: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1053: WHERE legal_registration_id = p_le_old_reg_id;
1054:
1055: -- Logging Infra
1056: l_procedure_name CONSTANT VARCHAR2(30) := 'SYNC_TAX_REGISTRATIONS';
1057: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1058:
1059: BEGIN
1060:
1061: -- Logging Infra: Setting up runtime level

Line 1062: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1058:
1059: BEGIN
1060:
1061: -- Logging Infra: Setting up runtime level
1062: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1063:
1064: -- Logging Infra: Statement level
1065: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1066: l_log_msg := l_procedure_name||'(+)';

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

1068: ' Parameters '||
1069: 'p_le_old_reg_id: '||to_char(p_le_old_reg_id)||
1070: 'p_le_new_reg_id: '||to_char(p_le_new_reg_id)||
1071: 'p_le_new_reg_num: '||p_le_new_reg_num;
1072: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1073: END IF;
1074: -- Logging Infra: Statement level
1075:
1076: /*--------------------------------------------------+

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

1422:
1423: -- Logging Infra: Procedure level
1424: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1425: l_log_msg := l_procedure_name||'(-)';
1426: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
1427: END IF;
1428:
1429: EXCEPTION
1430:

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

1432: ROLLBACK TO Sync_Tax_Registrations_PVT;
1433: x_return_status := FND_API.G_RET_STS_ERROR ;
1434:
1435: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
1436: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
1437: END IF;
1438:
1439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1440: ROLLBACK TO Sync_Tax_Registrations_PVT;

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

1440: ROLLBACK TO Sync_Tax_Registrations_PVT;
1441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1442:
1443: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1444: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,'');
1445: END IF;
1446:
1447: WHEN INVALID_CURSOR THEN
1448: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1494: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1490: WHERE ptp.party_id = p_party_id
1491: AND ptp.party_type_code = p_party_type_code;
1492:
1493: l_tbl_index binary_integer;
1494: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1495:
1496: BEGIN
1497:
1498: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1506:
1507: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1508: l_log_msg := 'Party Tax Profile Id info for party_id: '||to_char(p_party_id)||' and party_type_code '
1509: ||p_party_type_code||' found in cache at index: '||to_char(l_tbl_index);
1510: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);
1511: END IF;
1512:
1513: X_TBL_INDEX := l_tbl_index;
1514: RETURN;

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

1553: EXCEPTION
1554: WHEN no_data_found then
1555: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1556: l_log_msg := 'No Data found in ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO. Still returning with success';
1557: FND_LOG.STRING(G_LEVEL_PROCEDURE,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);
1558: END IF;
1559: X_TBL_INDEX := NULL;
1560: WHEN others then
1561: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1559: X_TBL_INDEX := NULL;
1560: WHEN others then
1561: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1562: l_log_msg := 'Unexpected error in ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO: '||SQLCODE||' ; '||SQLERRM;
1563: FND_LOG.STRING(G_LEVEL_UNEXPECTED,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);
1564: END IF;
1565:
1566: END GET_PARTY_TAX_PROF_INFO;
1567:

Line 1603: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1599: ptp.rounding_rule_code
1600: FROM zx_party_tax_profile ptp
1601: WHERE party_tax_profile_id = p_party_tax_profile_id;
1602:
1603: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1604: l_tbl_index binary_integer;
1605:
1606: BEGIN
1607:

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

1611: THEN
1612:
1613: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1614: l_log_msg := 'Party Tax Profile Id info found in cache ';
1615: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);
1616: END IF;
1617:
1618: X_TBL_INDEX := p_party_tax_profile_id;
1619: RETURN;

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

1660:
1661: WHEN no_data_found then
1662: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1663: l_log_msg := 'No Data found in ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO. Still returning with success';
1664: FND_LOG.STRING(G_LEVEL_PROCEDURE,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);
1665: END IF;
1666: X_TBL_INDEX := NULL;
1667:
1668: WHEN others then

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

1667:
1668: WHEN others then
1669: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1670: l_log_msg := 'Unexpected error in ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO: '||SQLCODE||' ; '||SQLERRM;
1671: FND_LOG.STRING(G_LEVEL_UNEXPECTED,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);
1672: END IF;
1673:
1674: END GET_PARTY_TAX_PROF_INFO;
1675: