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

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

11:
12: -- Logging Infra
13: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_PARTY_MERGE_PKG';
14: G_CURRENT_RUNTIME_LEVEL NUMBER;
15: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
17: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
18: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
19: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

12: -- Logging Infra
13: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_PARTY_MERGE_PKG';
14: G_CURRENT_RUNTIME_LEVEL NUMBER;
15: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
17: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
18: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
19: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
20: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

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

13: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_PARTY_MERGE_PKG';
14: G_CURRENT_RUNTIME_LEVEL NUMBER;
15: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
17: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
18: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
19: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
20: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
21: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_PARTY_MERGE_PKG';

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

14: G_CURRENT_RUNTIME_LEVEL NUMBER;
15: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
17: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
18: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
19: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
20: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
21: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_PARTY_MERGE_PKG';
22:

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

15: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
17: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
18: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
19: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
20: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
21: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_PARTY_MERGE_PKG';
22:
23:

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

16: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
17: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
18: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
19: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
20: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
21: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_PARTY_MERGE_PKG';
22:
23:
24: PROCEDURE ZX_CUST_REG_MERGE (

Line 72: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

68: to_registration_rec registration_number%ROWTYPE;
69:
70: -- Logging Infra
71: l_procedure_name CONSTANT VARCHAR2(30) := '.ZX_CUST_REG_MERGE ';
72: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
73:
74: BEGIN
75: -- arp_message.set_line(g_api_name||'.'||l_proc_name);
76: --------------------------------------------------------------------------------

Line 78: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

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

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

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

207: ---------------------------------------------------------------------------------
208: -- Logging Infra: Procedure level
209: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
210: l_log_msg := l_procedure_name||' (-) ';
211: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.END ', l_log_msg);
212: END IF;
213: ---------------------------------------------------------------------------------
214: end ZX_CUST_REG_MERGE;
215:

Line 267: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

263: Class_Codes_To_Rec Class_Codes_To%ROWTYPE;
264:
265: -- Logging Infra
266: l_procedure_name CONSTANT VARCHAR2(30) := '.ZX_PTP_MERGE ';
267: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
268:
269: BEGIN
270: -- arp_message.set_line(g_api_name||'.'||l_proc_name);
271: --------------------------------------------------------------------------------------

Line 273: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

269: BEGIN
270: -- arp_message.set_line(g_api_name||'.'||l_proc_name);
271: --------------------------------------------------------------------------------------
272: -- Logging Infra: Setting up runtime level
273: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
274:
275: -- Logging Infra: Procedure level
276: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
277: l_log_msg := l_procedure_name||' (+) ';

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

274:
275: -- Logging Infra: Procedure level
276: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
277: l_log_msg := l_procedure_name||' (+) ';
278: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||' .begin ', l_log_msg);
279: END IF;
280: ---------------------------------------------------------------------------------
281:
282: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

353: ---------------------------------------------------------------------------------
354: -- Logging Infra: Procedure level
355: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
356: l_log_msg := l_procedure_name||' (-) ';
357: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.END ', l_log_msg);
358: END IF;
359: ---------------------------------------------------------------------------------
360: end ZX_PTP_MERGE;
361:

Line 377: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

373: l_count number(10) := 0;
374:
375: -- Logging Infra
376: l_procedure_name CONSTANT VARCHAR2(30) := '.ZX_TAX_AUTH_MERGE ';
377: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
378:
379: BEGIN
380: --arp_message.set_line(g_api_name||'.'||l_proc_name);
381: --------------------------------------------------------------------------------------

Line 383: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

379: BEGIN
380: --arp_message.set_line(g_api_name||'.'||l_proc_name);
381: --------------------------------------------------------------------------------------
382: -- Logging Infra: Setting up runtime level
383: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
384:
385: -- Logging Infra: Procedure level
386: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
387: l_log_msg := l_procedure_name||' (+) ';

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

384:
385: -- Logging Infra: Procedure level
386: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
387: l_log_msg := l_procedure_name||' (+) ';
388: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||' .begin ', l_log_msg);
389: END IF;
390: ---------------------------------------------------------------------------------
391:
392:

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

510: ---------------------------------------------------------------------------------
511: -- Logging Infra: Procedure level
512: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
513: l_log_msg := l_procedure_name||' (-) ';
514: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.END ', l_log_msg);
515: END IF;
516: ---------------------------------------------------------------------------------
517: end ZX_TAX_AUTH_MERGE;
518:

Line 567: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

563: l_count number(10) := 0;
564:
565: -- Logging Infra
566: l_procedure_name CONSTANT VARCHAR2(30) := '.ZX_EXEMPTIONS_P ';
567: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
568:
569: BEGIN
570: -- arp_message.set_line(g_api_name||'.'||l_proc_name);
571: --------------------------------------------------------------------------------------

Line 573: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

569: BEGIN
570: -- arp_message.set_line(g_api_name||'.'||l_proc_name);
571: --------------------------------------------------------------------------------------
572: -- Logging Infra: Setting up runtime level
573: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
574:
575: -- Logging Infra: Procedure level
576: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
577: l_log_msg := l_procedure_name||' (+) ';

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

574:
575: -- Logging Infra: Procedure level
576: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
577: l_log_msg := l_procedure_name||' (+) ';
578: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||' .begin ', l_log_msg);
579: END IF;
580: ---------------------------------------------------------------------------------
581:
582: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

629: ---------------------------------------------------------------------------------
630: -- Logging Infra: Procedure level
631: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
632: l_log_msg := l_procedure_name||' (-) ';
633: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.END ', l_log_msg);
634: END IF;
635: ---------------------------------------------------------------------------------
636: end ZX_EXEMPTIONS_P;
637:

Line 682: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

678: Reg_Attr_To_Rec Registration_Attributes%ROWTYPE;
679:
680: -- Logging Infra
681: l_procedure_name CONSTANT VARCHAR2(30) := '.ZX_CUSTOMER_VETO ';
682: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
683:
684:
685: BEGIN
686: --arp_message.set_line(g_api_name||'.'||l_proc_name);

Line 689: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

685: BEGIN
686: --arp_message.set_line(g_api_name||'.'||l_proc_name);
687: --------------------------------------------------------------------------------------
688: -- Logging Infra: Setting up runtime level
689: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
690:
691: -- Logging Infra: Procedure level
692: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
693: l_log_msg := l_procedure_name||' (+) ';

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

690:
691: -- Logging Infra: Procedure level
692: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
693: l_log_msg := l_procedure_name||' (+) ';
694: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||' .begin ', l_log_msg);
695: END IF;
696: ---------------------------------------------------------------------------------
697:
698: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

748: ---------------------------------------------------------------------------------
749: -- Logging Infra: Procedure level
750: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
751: l_log_msg := l_procedure_name||' (-) ';
752: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.END ', l_log_msg);
753: END IF;
754: ---------------------------------------------------------------------------------
755:
756: EXCEPTION

Line 799: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

795: to_ptp_rec Party_Tax_Profile%ROWTYPE;
796:
797: -- Logging Infra
798: l_procedure_name CONSTANT VARCHAR2(30) := '.ZX_MERGE ';
799: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
800:
801: BEGIN
802: -- arp_message.set_line(g_api_name||'.'||l_proc_name);
803: --------------------------------------------------------------------------------------

Line 805: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

801: BEGIN
802: -- arp_message.set_line(g_api_name||'.'||l_proc_name);
803: --------------------------------------------------------------------------------------
804: -- Logging Infra: Setting up runtime level
805: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
806:
807: -- Logging Infra: Procedure level
808: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
809: l_log_msg := l_procedure_name||' (+) ';

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: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

928: ---------------------------------------------------------------------------------
929: -- Logging Infra: Procedure level
930: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
931: l_log_msg := l_procedure_name||' (-) ';
932: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.END ', l_log_msg);
933: END IF;
934: ---------------------------------------------------------------------------------
935: end ZX_MERGE;
936: