APPS.HZ_PARTY_MERGE dependencies on HZ_PARTY_MERGE

Line 1: PACKAGE BODY HZ_PARTY_MERGE AS

1: PACKAGE BODY HZ_PARTY_MERGE AS
2: /* $Header: ARHPMERB.pls 120.66.12010000.2 2008/10/29 12:41:28 vsegu ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'HZ_PARTY_MERGE';
5: G_TCA_APP_ID CONSTANT VARCHAR2(30) := '222';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'HZ_PARTY_MERGE';

1: PACKAGE BODY HZ_PARTY_MERGE AS
2: /* $Header: ARHPMERB.pls 120.66.12010000.2 2008/10/29 12:41:28 vsegu ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'HZ_PARTY_MERGE';
5: G_TCA_APP_ID CONSTANT VARCHAR2(30) := '222';
6: G_REQUEST_TYPE VARCHAR2(30);
7:
8: /*******************Private Procedures forward declarations ********/

Line 1224: l_key := HZ_EVENT_PKG.item_key('oracle.apps.ar.hz.Party.merge');

1220: l_pre_merge_to_party_id := NULL;
1221: FETCH merge_to_parties INTO l_pre_merge_to_party_id;
1222: EXIT WHEN merge_to_parties%NOTFOUND;
1223: --4230396
1224: l_key := HZ_EVENT_PKG.item_key('oracle.apps.ar.hz.Party.merge');
1225: -- initialization of object variables
1226: l_list := WF_PARAMETER_LIST_T();
1227: -- add parameters to list
1228: wf_event.addParameterToList(p_name => 'batch_id',

Line 1235: p_value => 'oracle.apps.ar.hz.Party.merge',

1231: wf_event.addParameterToList(p_name => 'merge_to_party_id',
1232: p_value => l_pre_merge_to_party_id,
1233: p_parameterlist => l_list);
1234: wf_event.addParameterToList(p_name => 'Q_CORRELATION_ID',
1235: p_value => 'oracle.apps.ar.hz.Party.merge',
1236: p_parameterlist => l_list);
1237: -- Raise Event
1238: HZ_EVENT_PKG.raise_event(
1239: p_event_name => 'oracle.apps.ar.hz.Party.merge',

Line 1239: p_event_name => 'oracle.apps.ar.hz.Party.merge',

1235: p_value => 'oracle.apps.ar.hz.Party.merge',
1236: p_parameterlist => l_list);
1237: -- Raise Event
1238: HZ_EVENT_PKG.raise_event(
1239: p_event_name => 'oracle.apps.ar.hz.Party.merge',
1240: p_event_key => l_key,
1241: p_parameters => l_list );
1242: l_list.DELETE;
1243: --4230396

Line 1608: log('Error: Merge failed in procedure HZ_PARTY_MERGE.GET_RECORD_DESC for entity '||p_entity_name); --4634891

1604: END IF;
1605: ELSE
1606: log('', TRUE);
1607: log(' **** Error **** ',TRUE);
1608: log('Error: Merge failed in procedure HZ_PARTY_MERGE.GET_RECORD_DESC for entity '||p_entity_name); --4634891
1609: x_error_msg := logerror;
1610:
1611: -- Log the error in the table and return
1612: store_merge_log(p_batch_party_id, p_from_id,

Line 1634: IF FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') IS NOT NULL THEN

1630: then
1631: l_pmerge_apps := G_TCA_APP_ID;
1632: else
1633:
1634: IF FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') IS NOT NULL THEN
1635: l_pmerge_apps := '(' || G_TCA_APP_ID || ', ' ||
1636: FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') || ')';
1637: END IF;
1638: END IF;

Line 1636: FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') || ')';

1632: else
1633:
1634: IF FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') IS NOT NULL THEN
1635: l_pmerge_apps := '(' || G_TCA_APP_ID || ', ' ||
1636: FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') || ')';
1637: END IF;
1638: END IF;
1639:
1640: IF l_pmerge_apps IS NOT NULL THEN

Line 1873: log('Error: Merge failed in procedure HZ_PARTY_MERGE.GET_RECORD_DESC for entity '||l_sub_entity_name); --4634891

1869: END IF;
1870: ELSE
1871: log('', TRUE);
1872: log(' **** Error **** ', TRUE);
1873: log('Error: Merge failed in procedure HZ_PARTY_MERGE.GET_RECORD_DESC for entity '||l_sub_entity_name); --4634891
1874: x_error_msg := logerror;
1875:
1876: -- Log the error in the table and return
1877: store_merge_log(p_batch_party_id, -1,

Line 2136: IF FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') IS NOT NULL THEN

2132: RETURN;
2133: END IF;
2134:
2135: IF lockstr IS NOT NULL THEN
2136: IF FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') IS NOT NULL THEN
2137: l_pmerge_apps := '(' || G_TCA_APP_ID || ', ' ||
2138: FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') || ')';
2139: OPEN c_dict_details FOR
2140: 'SELECT ENTITY_NAME, PK_COLUMN_NAME, FK_COLUMN_NAME, JOIN_CLAUSE, DICT_APPLICATION_ID'||

Line 2138: FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') || ')';

2134:
2135: IF lockstr IS NOT NULL THEN
2136: IF FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') IS NOT NULL THEN
2137: l_pmerge_apps := '(' || G_TCA_APP_ID || ', ' ||
2138: FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') || ')';
2139: OPEN c_dict_details FOR
2140: 'SELECT ENTITY_NAME, PK_COLUMN_NAME, FK_COLUMN_NAME, JOIN_CLAUSE, DICT_APPLICATION_ID'||
2141: 'FROM HZ_MERGE_DICTIONARY ' ||
2142: 'WHERE PARENT_ENTITY_NAME = :pentity' ||

Line 4812: END HZ_PARTY_MERGE;

4808: APP_EXCEPTION.RAISE_EXCEPTION;
4809: END check_int_ext_party_type;
4810:
4811:
4812: END HZ_PARTY_MERGE;