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.69.12020000.2 2013/03/27 07:24:13 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.69.12020000.2 2013/03/27 07:24:13 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 1261: l_key := HZ_EVENT_PKG.item_key('oracle.apps.ar.hz.Party.merge');

1257: l_pre_merge_to_party_id := NULL;
1258: FETCH merge_to_parties INTO l_pre_merge_to_party_id;
1259: EXIT WHEN merge_to_parties%NOTFOUND;
1260: --4230396
1261: l_key := HZ_EVENT_PKG.item_key('oracle.apps.ar.hz.Party.merge');
1262: -- initialization of object variables
1263: l_list := WF_PARAMETER_LIST_T();
1264: -- add parameters to list
1265: wf_event.addParameterToList(p_name => 'batch_id',

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

1268: wf_event.addParameterToList(p_name => 'merge_to_party_id',
1269: p_value => l_pre_merge_to_party_id,
1270: p_parameterlist => l_list);
1271: wf_event.addParameterToList(p_name => 'Q_CORRELATION_ID',
1272: p_value => 'oracle.apps.ar.hz.Party.merge',
1273: p_parameterlist => l_list);
1274: -- Raise Event
1275: HZ_EVENT_PKG.raise_event(
1276: p_event_name => 'oracle.apps.ar.hz.Party.merge',

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

1272: p_value => 'oracle.apps.ar.hz.Party.merge',
1273: p_parameterlist => l_list);
1274: -- Raise Event
1275: HZ_EVENT_PKG.raise_event(
1276: p_event_name => 'oracle.apps.ar.hz.Party.merge',
1277: p_event_key => l_key,
1278: p_parameters => l_list );
1279: l_list.DELETE;
1280: --4230396

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

1644: END IF;
1645: ELSE
1646: log('', TRUE);
1647: log(' **** Error **** ',TRUE);
1648: log('Error: Merge failed in procedure HZ_PARTY_MERGE.GET_RECORD_DESC for entity '||p_entity_name); --4634891
1649: x_error_msg := logerror;
1650:
1651: -- Log the error in the table and return
1652: store_merge_log(p_batch_party_id, p_from_id,

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

1670: then
1671: l_pmerge_apps := G_TCA_APP_ID;
1672: else
1673:
1674: IF FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') IS NOT NULL THEN
1675: l_pmerge_apps := '(' || G_TCA_APP_ID || ', ' ||
1676: FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') || ')';
1677: END IF;
1678: END IF;

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

1672: else
1673:
1674: IF FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') IS NOT NULL THEN
1675: l_pmerge_apps := '(' || G_TCA_APP_ID || ', ' ||
1676: FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') || ')';
1677: END IF;
1678: END IF;
1679:
1680: IF l_pmerge_apps IS NOT NULL THEN

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

1909: END IF;
1910: ELSE
1911: log('', TRUE);
1912: log(' **** Error **** ', TRUE);
1913: log('Error: Merge failed in procedure HZ_PARTY_MERGE.GET_RECORD_DESC for entity '||l_sub_entity_name); --4634891
1914: x_error_msg := logerror;
1915:
1916: -- Log the error in the table and return
1917: store_merge_log(p_batch_party_id, -1,

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

2172: RETURN;
2173: END IF;
2174:
2175: IF lockstr IS NOT NULL THEN
2176: IF FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') IS NOT NULL THEN
2177: l_pmerge_apps := '(' || G_TCA_APP_ID || ', ' ||
2178: FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') || ')';
2179: OPEN c_dict_details FOR
2180: 'SELECT ENTITY_NAME, PK_COLUMN_NAME, FK_COLUMN_NAME, JOIN_CLAUSE, DICT_APPLICATION_ID'||

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

2174:
2175: IF lockstr IS NOT NULL THEN
2176: IF FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') IS NOT NULL THEN
2177: l_pmerge_apps := '(' || G_TCA_APP_ID || ', ' ||
2178: FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') || ')';
2179: OPEN c_dict_details FOR
2180: 'SELECT ENTITY_NAME, PK_COLUMN_NAME, FK_COLUMN_NAME, JOIN_CLAUSE, DICT_APPLICATION_ID'||
2181: 'FROM HZ_MERGE_DICTIONARY ' ||
2182: 'WHERE PARENT_ENTITY_NAME = :pentity' ||

Line 4410: END HZ_PARTY_MERGE;

4406: APP_EXCEPTION.RAISE_EXCEPTION;
4407: END check_int_ext_party_type;
4408:
4409:
4410: END HZ_PARTY_MERGE;