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 10: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

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

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

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

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

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

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

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

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

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

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

11: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
12: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
14: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
15: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
16: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_PARTY_MERGE_PKG';
17:
18:
19: PROCEDURE ZX_CUST_REG_MERGE_PVT (

Line 116: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

112: registration_rec registration_number%ROWTYPE;
113:
114: -- Logging Infra
115: l_procedure_name CONSTANT VARCHAR2(30) := '.ZX_CUST_REG_MERGE_PVT ';
116: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
117:
118: BEGIN
119:
120: -- Logging Infra: Setting up runtime level

Line 121: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

117:
118: BEGIN
119:
120: -- Logging Infra: Setting up runtime level
121: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
122:
123: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
124: l_log_msg := l_procedure_name||' (+) ';
125: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

Line 125: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

121: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
122:
123: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
124: l_log_msg := l_procedure_name||' (+) ';
125: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
126: END IF;
127:
128: x_return_status := FND_API.G_RET_STS_SUCCESS;
129:

Line 187: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

183: END IF; -- p_from_fk_id <> p_to_fk_id
184:
185: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
186: l_log_msg := l_procedure_name||' (-) ';
187: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
188: END IF;
189:
190: END ZX_CUST_REG_MERGE_PVT;
191:

Line 244: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

240: Class_Codes_To_Rec Class_Codes_To%ROWTYPE;
241:
242: -- Logging Infra
243: l_procedure_name CONSTANT VARCHAR2(30) := '.ZX_PTP_MERGE_PVT ';
244: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
245:
246: BEGIN
247:
248: -- Logging Infra: Setting up runtime level

Line 249: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

245:
246: BEGIN
247:
248: -- Logging Infra: Setting up runtime level
249: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
250:
251: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
252: l_log_msg := l_procedure_name||' (+) ';
253: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

Line 253: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

249: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
250:
251: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
252: l_log_msg := l_procedure_name||' (+) ';
253: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
254: END IF;
255:
256: x_return_status := FND_API.G_RET_STS_SUCCESS;
257:

Line 330: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

326: END IF;
327:
328: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
329: l_log_msg := l_procedure_name||' (-) ';
330: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
331: END IF;
332:
333: end ZX_PTP_MERGE_PVT;
334:

Line 351: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

347: l_count number(10) := 0;
348:
349: -- Logging Infra
350: l_procedure_name CONSTANT VARCHAR2(30) := '.ZX_TAX_AUTH_MERGE_PVT ';
351: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
352:
353: BEGIN
354:
355: -- Logging Infra: Setting up runtime level

Line 356: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

352:
353: BEGIN
354:
355: -- Logging Infra: Setting up runtime level
356: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
357:
358: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
359: l_log_msg := l_procedure_name||' (+) ';
360: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

Line 360: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

356: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
357:
358: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
359: l_log_msg := l_procedure_name||' (+) ';
360: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
361: END IF;
362:
363: x_return_status := FND_API.G_RET_STS_SUCCESS;
364:

Line 481: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

477: END IF;
478:
479: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
480: l_log_msg := l_procedure_name||' (-) ';
481: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
482: END IF;
483:
484: end ZX_TAX_AUTH_MERGE_PVT;
485:

Line 564: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

560: l_count number(10) := 0;
561:
562: -- Logging Infra
563: l_procedure_name CONSTANT VARCHAR2(30) := '.ZX_EXEMPTIONS_PVT ';
564: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
565:
566: BEGIN
567:
568: -- Logging Infra: Setting up runtime level

Line 569: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

565:
566: BEGIN
567:
568: -- Logging Infra: Setting up runtime level
569: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
570:
571: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
572: l_log_msg := l_procedure_name||' (+) ';
573: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

Line 573: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

569: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
570:
571: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
572: l_log_msg := l_procedure_name||' (+) ';
573: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
574: END IF;
575:
576: x_return_status := FND_API.G_RET_STS_SUCCESS;
577:

Line 641: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

637: END IF;
638:
639: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
640: l_log_msg := l_procedure_name||' (-) ';
641: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
642: END IF;
643: end ZX_EXEMPTIONS_PVT;
644:
645: PROCEDURE ZX_CUSTOMER_VETO_PVT (

Line 725: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

721: Reg_Attr_Rec_From Registration_Attributes%ROWTYPE;
722:
723: -- Logging Infra
724: l_procedure_name CONSTANT VARCHAR2(30) := '.ZX_CUSTOMER_VETO_PVT ';
725: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
726: l_dummy_number NUMBER;
727:
728: BEGIN
729:

Line 732: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

728: BEGIN
729:
730: -- Logging Infra: Procedure level
731: -- Logging Infra: Setting up runtime level
732: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
733:
734: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
735: l_log_msg := l_procedure_name||' (+) ';
736: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

Line 736: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

732: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
733:
734: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
735: l_log_msg := l_procedure_name||' (+) ';
736: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
737: END IF;
738:
739: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
740: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name,

Line 740: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name,

736: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
737: END IF;
738:
739: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
740: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name,
741: 'Parameters to the procedure are as follows :- '||
742: 'p_ptp_id_from : '||p_ptp_id_from||' , p_ptp_id_to : '||p_ptp_id_to||
743: 'p_from_fk_id : '||p_from_fk_id||' , p_to_fk_id : '||p_to_fk_id
744: );

Line 796: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name,

792: FETCH Registration_Attributes into Reg_Attr_Rec;
793:
794: IF Registration_Attributes%FOUND THEN
795: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
796: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name,
797: 'Parties '||p_ptp_id_from||' and '||p_ptp_id_to||
798: ' cannot be merged as Registration Attributes have different Values (A-B)'
799: );
800: END IF;

Line 818: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name,

814: OPEN Registration_Attributes_Exist (p_ptp_id_from);
815: FETCH Registration_Attributes_Exist into l_dummy_number;
816: IF Registration_Attributes_Exist%FOUND THEN
817: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
818: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name,
819: 'Parties '||p_ptp_id_to||' and '||p_ptp_id_from||
820: ' cannot be merged as Registration Attributes have different Values (B-A)'
821: );
822: END IF;

Line 838: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

834: x_merge_yn := 'Y';
835:
836: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
837: l_log_msg := l_procedure_name||' (-) ';
838: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
839: END IF;
840:
841: EXCEPTION
842: WHEN NO_DATA_FOUND THEN

Line 883: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

879: to_ptp_rec Party_Tax_Profile%ROWTYPE;
880:
881: -- Logging Infra
882: l_procedure_name CONSTANT VARCHAR2(30) := '.ZX_MERGE ';
883: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
884:
885: BEGIN
886:
887: -- Logging Infra: Setting up runtime level

Line 888: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

884:
885: BEGIN
886:
887: -- Logging Infra: Setting up runtime level
888: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
889:
890: -- Logging Infra: Procedure level
891: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
892: l_log_msg := l_procedure_name||' (+) ';

Line 893: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

889:
890: -- Logging Infra: Procedure level
891: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
892: l_log_msg := l_procedure_name||' (+) ';
893: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
894: END IF;
895:
896: x_return_status := FND_API.G_RET_STS_SUCCESS;
897:

Line 1012: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

1008: END IF;
1009:
1010: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1011: l_log_msg := l_procedure_name||' (-) ';
1012: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
1013: END IF;
1014:
1015: end ZX_MERGE;
1016:

Line 1042: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1038:
1039:
1040: BEGIN
1041: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'Begin with param request id: '||request_id);
1042: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1043: -- Logging Infra: Procedure level
1044: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1045: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
1046: 'Begin with param request id: '||request_id);

Line 1045: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

1041: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'Begin with param request id: '||request_id);
1042: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1043: -- Logging Infra: Procedure level
1044: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1045: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
1046: 'Begin with param request id: '||request_id);
1047: END IF;
1048: l_request_id := request_id;
1049: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;

Line 1091: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name,'from party id - to party id - ptp id');

1087: WHERE party_site_num = 1;
1088:
1089: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'from party id - to party id - ptp id');
1090: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1091: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name,'from party id - to party id - ptp id');
1092: END IF;
1093:
1094: for i in 1..l_tbl_to_ptp_id.count LOOP
1095: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1096: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name,

1092: END IF;
1093:
1094: for i in 1..l_tbl_to_ptp_id.count LOOP
1095: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1096: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name,
1097: l_tbl_from_party_site_id(i)||' - '|| l_tbl_to_party_site_id(i)||' - '||l_tbl_to_ptp_id(i));
1098: END IF;
1099: arp_message.set_line(G_MODULE_NAME||l_procedure_name||l_tbl_from_party_site_id(i)||' - '|| l_tbl_to_party_site_id(i)||' - '||l_tbl_to_ptp_id(i));
1100: END LOOP;

Line 1107: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name,

1103: --
1104: -- inserting PTP records for the new site
1105: --
1106: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1107: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name,
1108: 'Inserting party tax profile records');
1109: END IF;
1110: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'Inserting party tax profile records');
1111: FORALL i IN 1..l_tbl_to_ptp_id.count

Line 1235: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name,

1231: -----------------------------------------------------------------
1232: -- Processing for Registration records start
1233: --
1234: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1235: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name,
1236: 'Inserting registration records');
1237: END IF;
1238: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'Inserting registration records');
1239: -- fix for bug 14477937 check to avoid if insertion is creating ZX_REGISTRATIONS_U2

Line 1383: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name,

1379: -----------------------------------------------------------------
1380: -- Processing for Exemption records start
1381: --
1382: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1383: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name,
1384: 'Inserting exemption records');
1385: END IF;
1386: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'Inserting exemption records');
1387: FORALL i in 1..l_tbl_from_ptp_id.count

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

1495: -----------------------------------------------------------------
1496: END IF;
1497:
1498: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1499: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'end');
1500: END IF;
1501: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'end');
1502:
1503: EXCEPTION

Line 1506: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,'Exception - '||SQLERRM);

1502:
1503: EXCEPTION
1504: WHEN OTHERS THEN
1505: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1506: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,'Exception - '||SQLERRM);
1507: END IF;
1508: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'Exception - '||SQLERRM);
1509: END MERGE_PTP_BULK;
1510:

Line 1529: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1525: l_reg_count NUMBER;
1526: l_procedure_name CONSTANT VARCHAR2(30) := '.MERGE_SITE_REGISTRATIONS_PVT';
1527:
1528: BEGIN
1529: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1530: x_return_status := FND_API.G_RET_STS_SUCCESS;
1531:
1532: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1533: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

Line 1533: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

1529: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1530: x_return_status := FND_API.G_RET_STS_SUCCESS;
1531:
1532: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1533: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
1534: 'Merge_Site_Registrations_Pvt(+)');
1535: END IF;
1536:
1537: l_reg_count := 0;

Line 1689: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

1685:
1686: END LOOP;
1687:
1688: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1689: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
1690: l_reg_count||' record(s) created in ZX_Registrations');
1691: END IF;
1692:
1693: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1694: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

1690: l_reg_count||' record(s) created in ZX_Registrations');
1691: END IF;
1692:
1693: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1694: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
1695: 'Merge_Site_Registrations_Pvt(+)');
1696: END IF;
1697:
1698: EXCEPTION

Line 1701: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,

1697:
1698: EXCEPTION
1699: WHEN OTHERS THEN
1700: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1701: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
1702: 'Merge_Site_Registrations_Pvt(Exception)');
1703: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
1704: 'Error : '||SQLERRM);
1705: END IF;

Line 1703: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,

1699: WHEN OTHERS THEN
1700: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1701: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
1702: 'Merge_Site_Registrations_Pvt(Exception)');
1703: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
1704: 'Error : '||SQLERRM);
1705: END IF;
1706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1707:

Line 1722: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1718:
1719: l_procedure_name CONSTANT VARCHAR2(30) := '.MERGE_SITE_EXEMPTIONS_PVT';
1720:
1721: BEGIN
1722: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1723: x_return_status := FND_API.G_RET_STS_SUCCESS;
1724:
1725: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1726: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

Line 1726: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

1722: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1723: x_return_status := FND_API.G_RET_STS_SUCCESS;
1724:
1725: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1726: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
1727: 'Merge_Site_Exemptions_Pvt(+)');
1728: END IF;
1729:
1730: INSERT INTO zx_exemptions

Line 1829: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

1825: FROM zx_exemptions
1826: WHERE party_tax_profile_id = p_from_ptp_id;
1827:
1828: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1829: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
1830: SQL%ROWCOUNT||' record(s) created in ZX_Exemptions');
1831: END IF;
1832:
1833: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1834: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

1830: SQL%ROWCOUNT||' record(s) created in ZX_Exemptions');
1831: END IF;
1832:
1833: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1834: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
1835: 'Merge_Site_Exemptions_Pvt(-)');
1836: END IF;
1837:
1838: EXCEPTION

Line 1841: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,

1837:
1838: EXCEPTION
1839: WHEN OTHERS THEN
1840: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1841: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
1842: 'Merge_Site_Exemptions_Pvt(Exception)');
1843: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
1844: 'Error : '||SQLERRM);
1845: END IF;

Line 1843: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,

1839: WHEN OTHERS THEN
1840: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1841: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
1842: 'Merge_Site_Exemptions_Pvt(Exception)');
1843: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
1844: 'Error : '||SQLERRM);
1845: END IF;
1846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1847:

Line 1894: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1890: l_procedure_name CONSTANT VARCHAR2(30) := '.MERGE_PARTY_SITES_PTP_PVT';
1891:
1892: BEGIN
1893:
1894: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1895: x_return_status := FND_API.G_RET_STS_SUCCESS;
1896:
1897: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1898: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

Line 1898: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

1894: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1895: x_return_status := FND_API.G_RET_STS_SUCCESS;
1896:
1897: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1898: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
1899: 'Merge_Party_Sites_PTP_Pvt(+)');
1900: END IF;
1901:
1902: ---------------------------

Line 1911: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,

1907: IF c_party_type%NOTFOUND THEN
1908: x_return_status := FND_API.G_RET_STS_ERROR;
1909: CLOSE c_party_type;
1910: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1911: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
1912: 'Error : From Party Type '||p_from_party_type||' is not valid');
1913: END IF;
1914: RETURN;
1915: END IF;

Line 1924: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,

1920: IF c_party_type%NOTFOUND THEN
1921: x_return_status := FND_API.G_RET_STS_ERROR;
1922: CLOSE c_party_type;
1923: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1924: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
1925: 'Error : To Party Type '||p_to_party_type||' is not valid');
1926: END IF;
1927: RETURN;
1928: END IF;

Line 1939: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,

1935: IF get_ptp_info%NOTFOUND THEN
1936: CLOSE get_ptp_info;
1937: x_return_status := FND_API.G_RET_STS_ERROR;
1938: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1939: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
1940: 'Error : From Party Info not available for Party-Id '||
1941: p_from_fk_id||' and Party-Type '||p_from_party_type);
1942: END IF;
1943: RETURN;

Line 1956: -- FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,

1952: IF get_ptp_info%FOUND THEN
1953: l_insert_ptp := FALSE;
1954: -- x_return_status := FND_API.G_RET_STS_ERROR;
1955: -- IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1956: -- FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
1957: -- 'Error : To Party Info already available for Party-Id '||
1958: -- p_to_fk_id||' and Party-Type '||p_to_party_type);
1959: -- END IF;
1960: -- RETURN;

Line 2075: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

2071: END IF;
2072:
2073: IF NVL(x_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
2074: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2075: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2076: 'Incorrect status retuned by ZX_Party_Tax_Profile_Pkg.Insert_Row()');
2077: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2078: 'Return Status = '||x_return_status);
2079: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

Line 2077: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

2073: IF NVL(x_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
2074: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2075: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2076: 'Incorrect status retuned by ZX_Party_Tax_Profile_Pkg.Insert_Row()');
2077: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2078: 'Return Status = '||x_return_status);
2079: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2080: 'Merge_Party_Sites_PTP_Pvt(-)');
2081: END IF;

Line 2079: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

2075: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2076: 'Incorrect status retuned by ZX_Party_Tax_Profile_Pkg.Insert_Row()');
2077: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2078: 'Return Status = '||x_return_status);
2079: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2080: 'Merge_Party_Sites_PTP_Pvt(-)');
2081: END IF;
2082: RETURN;
2083: END IF;

Line 2091: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

2087: CLOSE get_ptp_id;
2088:
2089: IF l_to_ptp_rec.party_tax_profile_id IS NULL THEN
2090: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2091: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2092: 'Error : Party_Tax_Profile_Id of To-Site is NULL');
2093: END IF;
2094: x_return_status := FND_API.G_RET_STS_ERROR ;
2095: RETURN;

Line 2098: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

2094: x_return_status := FND_API.G_RET_STS_ERROR ;
2095: RETURN;
2096: ELSE
2097: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2098: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2099: 'Party_Tax_Profile_Id of To-Site : '||l_to_ptp_rec.party_tax_profile_id);
2100: END IF;
2101: END IF;
2102:

Line 2122: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

2118: ,x_return_status => x_return_status);
2119:
2120: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2121: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2122: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2123: 'Incorrect status retuned by Merge_Site_Registrations_Pvt()');
2124: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2125: 'Return Status = '||x_return_status);
2126: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

Line 2124: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

2120: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2121: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2122: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2123: 'Incorrect status retuned by Merge_Site_Registrations_Pvt()');
2124: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2125: 'Return Status = '||x_return_status);
2126: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2127: 'Merge_Party_Sites_PTP_Pvt(-)');
2128: END IF;

Line 2126: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

2122: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2123: 'Incorrect status retuned by Merge_Site_Registrations_Pvt()');
2124: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2125: 'Return Status = '||x_return_status);
2126: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2127: 'Merge_Party_Sites_PTP_Pvt(-)');
2128: END IF;
2129: RETURN;
2130: END IF;

Line 2142: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

2138: ,x_return_status => x_return_status);
2139:
2140: IF NVL(x_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
2141: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2142: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2143: 'Incorrect status retuned by Merge_Site_Exemptions_Pvt()');
2144: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2145: 'Return Status = '||x_return_status);
2146: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

Line 2144: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

2140: IF NVL(x_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
2141: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2142: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2143: 'Incorrect status retuned by Merge_Site_Exemptions_Pvt()');
2144: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2145: 'Return Status = '||x_return_status);
2146: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2147: 'Merge_Party_Sites_PTP_Pvt(-)');
2148: END IF;

Line 2146: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

2142: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2143: 'Incorrect status retuned by Merge_Site_Exemptions_Pvt()');
2144: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2145: 'Return Status = '||x_return_status);
2146: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2147: 'Merge_Party_Sites_PTP_Pvt(-)');
2148: END IF;
2149: RETURN;
2150: END IF;

Line 2153: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

2149: RETURN;
2150: END IF;
2151:
2152: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2153: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2154: 'Merge_Party_Sites_PTP_Pvt(-)');
2155: END IF;
2156:
2157: EXCEPTION

Line 2164: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,

2160: IF get_ptp_info%ISOPEN THEN CLOSE get_ptp_info; END IF;
2161: IF get_ptp_id%ISOPEN THEN CLOSE get_ptp_id; END IF;
2162:
2163: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2164: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
2165: 'Merge_Party_Sites_PTP_Pvt(Exception)');
2166: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
2167: 'Error : '||SQLERRM);
2168: END IF;

Line 2166: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,

2162:
2163: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2164: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
2165: 'Merge_Party_Sites_PTP_Pvt(Exception)');
2166: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
2167: 'Error : '||SQLERRM);
2168: END IF;
2169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2170:

Line 2192: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2188: l_procedure_name CONSTANT VARCHAR2(30) := '.MERGE_PTP_SITES ';
2189:
2190: BEGIN
2191:
2192: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2193: x_return_status := FND_API.G_RET_STS_SUCCESS;
2194:
2195: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2196: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

Line 2196: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

2192: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2193: x_return_status := FND_API.G_RET_STS_SUCCESS;
2194:
2195: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2196: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2197: 'Merge_PTP_Sites(+)');
2198: END IF;
2199:
2200: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 2201: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Input Parameters :-');

2197: 'Merge_PTP_Sites(+)');
2198: END IF;
2199:
2200: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2201: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Input Parameters :-');
2202: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Entity_Name : ' ||p_entity_name);
2203: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'From_Id : ' ||p_from_id);
2204: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'From_Fk_Id : ' ||p_from_fk_id);
2205: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'To_Id : '||p_to_id);

Line 2202: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Entity_Name : ' ||p_entity_name);

2198: END IF;
2199:
2200: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2201: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Input Parameters :-');
2202: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Entity_Name : ' ||p_entity_name);
2203: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'From_Id : ' ||p_from_id);
2204: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'From_Fk_Id : ' ||p_from_fk_id);
2205: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'To_Id : '||p_to_id);
2206: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'To_Fk_id : '||p_to_fk_id);

Line 2203: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'From_Id : ' ||p_from_id);

2199:
2200: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2201: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Input Parameters :-');
2202: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Entity_Name : ' ||p_entity_name);
2203: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'From_Id : ' ||p_from_id);
2204: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'From_Fk_Id : ' ||p_from_fk_id);
2205: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'To_Id : '||p_to_id);
2206: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'To_Fk_id : '||p_to_fk_id);
2207: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Parent_Entity_Name : '||p_parent_entity_name);

Line 2204: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'From_Fk_Id : ' ||p_from_fk_id);

2200: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2201: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Input Parameters :-');
2202: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Entity_Name : ' ||p_entity_name);
2203: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'From_Id : ' ||p_from_id);
2204: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'From_Fk_Id : ' ||p_from_fk_id);
2205: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'To_Id : '||p_to_id);
2206: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'To_Fk_id : '||p_to_fk_id);
2207: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Parent_Entity_Name : '||p_parent_entity_name);
2208: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Batch_Id : ' ||p_batch_id);

Line 2205: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'To_Id : '||p_to_id);

2201: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Input Parameters :-');
2202: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Entity_Name : ' ||p_entity_name);
2203: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'From_Id : ' ||p_from_id);
2204: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'From_Fk_Id : ' ||p_from_fk_id);
2205: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'To_Id : '||p_to_id);
2206: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'To_Fk_id : '||p_to_fk_id);
2207: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Parent_Entity_Name : '||p_parent_entity_name);
2208: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Batch_Id : ' ||p_batch_id);
2209: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Batch_Party_Id : '||p_batch_party_id);

Line 2206: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'To_Fk_id : '||p_to_fk_id);

2202: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Entity_Name : ' ||p_entity_name);
2203: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'From_Id : ' ||p_from_id);
2204: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'From_Fk_Id : ' ||p_from_fk_id);
2205: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'To_Id : '||p_to_id);
2206: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'To_Fk_id : '||p_to_fk_id);
2207: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Parent_Entity_Name : '||p_parent_entity_name);
2208: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Batch_Id : ' ||p_batch_id);
2209: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Batch_Party_Id : '||p_batch_party_id);
2210: END IF;

Line 2207: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Parent_Entity_Name : '||p_parent_entity_name);

2203: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'From_Id : ' ||p_from_id);
2204: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'From_Fk_Id : ' ||p_from_fk_id);
2205: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'To_Id : '||p_to_id);
2206: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'To_Fk_id : '||p_to_fk_id);
2207: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Parent_Entity_Name : '||p_parent_entity_name);
2208: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Batch_Id : ' ||p_batch_id);
2209: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Batch_Party_Id : '||p_batch_party_id);
2210: END IF;
2211:

Line 2208: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Batch_Id : ' ||p_batch_id);

2204: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'From_Fk_Id : ' ||p_from_fk_id);
2205: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'To_Id : '||p_to_id);
2206: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'To_Fk_id : '||p_to_fk_id);
2207: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Parent_Entity_Name : '||p_parent_entity_name);
2208: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Batch_Id : ' ||p_batch_id);
2209: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Batch_Party_Id : '||p_batch_party_id);
2210: END IF;
2211:
2212: IF p_from_fk_id IS NULL THEN

Line 2209: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Batch_Party_Id : '||p_batch_party_id);

2205: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'To_Id : '||p_to_id);
2206: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'To_Fk_id : '||p_to_fk_id);
2207: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Parent_Entity_Name : '||p_parent_entity_name);
2208: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Batch_Id : ' ||p_batch_id);
2209: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Batch_Party_Id : '||p_batch_party_id);
2210: END IF;
2211:
2212: IF p_from_fk_id IS NULL THEN
2213: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2215: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

2211:
2212: IF p_from_fk_id IS NULL THEN
2213: x_return_status := FND_API.G_RET_STS_ERROR;
2214: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2215: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2216: 'Error : From-Party-Id is NULL');
2217: END IF;
2218: RETURN;
2219: END IF;

Line 2224: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

2220:
2221: IF p_to_fk_id IS NULL THEN
2222: x_return_status := FND_API.G_RET_STS_ERROR;
2223: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2224: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2225: 'Error : To-Party-Id is NULL');
2226: END IF;
2227: RETURN;
2228: END IF;

Line 2234: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

2230: IF p_from_fk_id = p_to_fk_id THEN
2231: p_to_id := p_from_id;
2232: x_return_status := FND_API.G_RET_STS_ERROR;
2233: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2234: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2235: 'Error : From-Party-Id and To-Party-Id are same');
2236: END IF;
2237: RETURN;
2238: END IF;

Line 2250: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

2246: );
2247:
2248: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2249: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2250: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2251: 'Incorrect status retuned by Merge_Party_Sites_PTP_Pvt()');
2252: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2253: 'Return Status = '||x_return_status);
2254: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

Line 2252: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

2248: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2249: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2250: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2251: 'Incorrect status retuned by Merge_Party_Sites_PTP_Pvt()');
2252: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2253: 'Return Status = '||x_return_status);
2254: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2255: 'Merge_PTP_Sites(-)');
2256: END IF;

Line 2254: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

2250: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2251: 'Incorrect status retuned by Merge_Party_Sites_PTP_Pvt()');
2252: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2253: 'Return Status = '||x_return_status);
2254: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2255: 'Merge_PTP_Sites(-)');
2256: END IF;
2257: RETURN;
2258: END IF;

Line 2261: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

2257: RETURN;
2258: END IF;
2259:
2260: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2261: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2262: 'Merge_PTP_Sites(-)');
2263: END IF;
2264:
2265: EXCEPTION

Line 2268: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,

2264:
2265: EXCEPTION
2266: WHEN OTHERS THEN
2267: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2268: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
2269: 'Merge_PTP_Sites(Exception)');
2270: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
2271: 'Error : '||SQLERRM);
2272: END IF;

Line 2270: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,

2266: WHEN OTHERS THEN
2267: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2268: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
2269: 'Merge_PTP_Sites(Exception)');
2270: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
2271: 'Error : '||SQLERRM);
2272: END IF;
2273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2274: RAISE;