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.AP_PARTYMERGE_GRP dependencies on FND_LOG

Line 4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY AP_PartyMerge_GRP AS
2: /* $Header: apgsmrgb.pls 120.3 2006/10/17 19:36:18 schitlap noship $ */
3:
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_PartyMerge_PKG';
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_PartyMerge_GRP';
8:

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

1: PACKAGE BODY AP_PartyMerge_GRP AS
2: /* $Header: apgsmrgb.pls 120.3 2006/10/17 19:36:18 schitlap noship $ */
3:
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_PartyMerge_PKG';
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_PartyMerge_GRP';
8:
9: --

Line 37: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

33:
34: x_return_status := FND_API.G_RET_STS_SUCCESS;
35:
36: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
37: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
38: 'p_Entity_name: '|| p_Entity_name);
39: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
40: 'p_from_id: '|| p_from_id);
41: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 39: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

35:
36: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
37: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
38: 'p_Entity_name: '|| p_Entity_name);
39: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
40: 'p_from_id: '|| p_from_id);
41: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
42: 'p_to_id: '|| p_to_id);
43: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 41: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

37: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
38: 'p_Entity_name: '|| p_Entity_name);
39: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
40: 'p_from_id: '|| p_from_id);
41: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
42: 'p_to_id: '|| p_to_id);
43: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
44: 'p_From_FK_id: '|| p_From_FK_id);
45: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 43: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

39: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
40: 'p_from_id: '|| p_from_id);
41: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
42: 'p_to_id: '|| p_to_id);
43: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
44: 'p_From_FK_id: '|| p_From_FK_id);
45: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
46: 'p_To_FK_id: '|| p_To_FK_id);
47: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 45: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

41: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
42: 'p_to_id: '|| p_to_id);
43: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
44: 'p_From_FK_id: '|| p_From_FK_id);
45: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
46: 'p_To_FK_id: '|| p_To_FK_id);
47: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
48: 'p_Parent_Entity_name: '|| p_Parent_Entity_name);
49: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 47: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

43: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
44: 'p_From_FK_id: '|| p_From_FK_id);
45: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
46: 'p_To_FK_id: '|| p_To_FK_id);
47: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
48: 'p_Parent_Entity_name: '|| p_Parent_Entity_name);
49: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
50: 'p_batch_id: '|| p_batch_id);
51: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 49: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

45: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
46: 'p_To_FK_id: '|| p_To_FK_id);
47: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
48: 'p_Parent_Entity_name: '|| p_Parent_Entity_name);
49: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
50: 'p_batch_id: '|| p_batch_id);
51: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
52: 'p_Batch_Party_id: '|| p_Batch_Party_id);
53: END IF;

Line 51: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

47: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
48: 'p_Parent_Entity_name: '|| p_Parent_Entity_name);
49: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
50: 'p_batch_id: '|| p_batch_id);
51: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
52: 'p_Batch_Party_id: '|| p_Batch_Party_id);
53: END IF;
54:
55: ------------------------------------------------------------------------

Line 59: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

55: ------------------------------------------------------------------------
56: l_debug_info := 'Validating Veto Rule One';
57: ------------------------------------------------------------------------
58: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
59: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
60: END IF;
61:
62: -- Veto Rule 1
63: -- there could be three cases

Line 92: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

88: ------------------------------------------------------------------------
89: l_debug_info := 'Validating Veto Rule Two';
90: ------------------------------------------------------------------------
91: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
92: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
93: END IF;
94:
95: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
96:

Line 125: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

121: ------------------------------------------------------------------------
122: l_debug_info := 'Validating Veto Rule Three';
123: ------------------------------------------------------------------------
124: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
125: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
126: END IF;
127:
128: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
129:

Line 172: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

168: ------------------------------------------------------------------------
169: l_debug_info := 'Validating Veto Rule Four';
170: ------------------------------------------------------------------------
171: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
172: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
173: END IF;
174:
175: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
176:

Line 205: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

201: ------------------------------------------------------------------------
202: l_debug_info := 'Validating Veto Rule Five';
203: ------------------------------------------------------------------------
204: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
205: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
206: END IF;
207:
208: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
209:

Line 293: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

289:
290: x_return_status := FND_API.G_RET_STS_SUCCESS;
291:
292: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
293: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
294: 'p_Entity_name: '|| p_Entity_name);
295: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
296: 'p_from_id: '|| p_from_id);
297: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 295: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

291:
292: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
293: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
294: 'p_Entity_name: '|| p_Entity_name);
295: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
296: 'p_from_id: '|| p_from_id);
297: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
298: 'p_to_id: '|| p_to_id);
299: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 297: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

293: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
294: 'p_Entity_name: '|| p_Entity_name);
295: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
296: 'p_from_id: '|| p_from_id);
297: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
298: 'p_to_id: '|| p_to_id);
299: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
300: 'p_From_FK_id: '|| p_From_FK_id);
301: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 299: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

295: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
296: 'p_from_id: '|| p_from_id);
297: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
298: 'p_to_id: '|| p_to_id);
299: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
300: 'p_From_FK_id: '|| p_From_FK_id);
301: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
302: 'p_To_FK_id: '|| p_To_FK_id);
303: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 301: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

297: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
298: 'p_to_id: '|| p_to_id);
299: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
300: 'p_From_FK_id: '|| p_From_FK_id);
301: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
302: 'p_To_FK_id: '|| p_To_FK_id);
303: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
304: 'p_Parent_Entity_name: '|| p_Parent_Entity_name);
305: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 303: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

299: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
300: 'p_From_FK_id: '|| p_From_FK_id);
301: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
302: 'p_To_FK_id: '|| p_To_FK_id);
303: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
304: 'p_Parent_Entity_name: '|| p_Parent_Entity_name);
305: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
306: 'p_batch_id: '|| p_batch_id);
307: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 305: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

301: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
302: 'p_To_FK_id: '|| p_To_FK_id);
303: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
304: 'p_Parent_Entity_name: '|| p_Parent_Entity_name);
305: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
306: 'p_batch_id: '|| p_batch_id);
307: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
308: 'p_Batch_Party_id: '|| p_Batch_Party_id);
309: END IF;

Line 307: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

303: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
304: 'p_Parent_Entity_name: '|| p_Parent_Entity_name);
305: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
306: 'p_batch_id: '|| p_batch_id);
307: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
308: 'p_Batch_Party_id: '|| p_Batch_Party_id);
309: END IF;
310:
311: ------------------------------------------------------------------------

Line 315: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

311: ------------------------------------------------------------------------
312: l_debug_info := 'Validating Veto Rule One';
313: ------------------------------------------------------------------------
314: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
315: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
316: END IF;
317:
318: -- Veto Rule 1
319: -- there could be four cases

Line 362: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

358: ------------------------------------------------------------------------
359: l_debug_info := 'Validating Veto Rule Two';
360: ------------------------------------------------------------------------
361: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
362: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
363: END IF;
364:
365: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
366:

Line 399: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

395: ------------------------------------------------------------------------
396: l_debug_info := 'Validating Veto Rule Three';
397: ------------------------------------------------------------------------
398: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
399: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
400: END IF;
401:
402: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
403:

Line 448: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

444: ------------------------------------------------------------------------
445: l_debug_info := 'Validating Veto Rule Four';
446: ------------------------------------------------------------------------
447: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
448: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
449: END IF;
450:
451: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
452:

Line 488: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

484: ------------------------------------------------------------------------
485: l_debug_info := 'Validating Veto Rule Five';
486: ------------------------------------------------------------------------
487: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
488: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
489: END IF;
490:
491: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
492:

Line 581: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

577: ------------------------------------------------------------------------
578: l_debug_info := 'Updating po_vendor_contacts';
579: ------------------------------------------------------------------------
580: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
581: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
582: END IF;
583:
584: UPDATE ap_supplier_contacts
585: --po_vendor_contacts

Line 639: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

635: ------------------------------------------------------------------------
636: l_debug_info := 'Updating po_vendor_contacts';
637: ------------------------------------------------------------------------
638: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
639: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
640: END IF;
641:
642: UPDATE ap_supplier_contacts
643: --po_vendor_contacts

Line 697: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

693: ------------------------------------------------------------------------
694: l_debug_info := 'Updating po_vendor_contacts';
695: ------------------------------------------------------------------------
696: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
697: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
698: END IF;
699:
700: UPDATE ap_supplier_contacts
701: -- po_vendor_contacts