APPS.HZ_AUTOMERGE_PKG dependencies on FND_LOG

Line 76: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

72: IS
73: l_count NUMBER;
74: l_procedure_name VARCHAR2(255) := 'CHK_FOR_REM_BATCH';
75: BEGIN
76: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
77: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
78: END IF;
79: select count(*) into l_count
80: from hz_dup_set_parties

Line 77: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

73: l_count NUMBER;
74: l_procedure_name VARCHAR2(255) := 'CHK_FOR_REM_BATCH';
75: BEGIN
76: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
77: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
78: END IF;
79: select count(*) into l_count
80: from hz_dup_set_parties
81: where dup_set_id = P_DUP_SET_ID

Line 93: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

89: IS
90: l_count NUMBER;
91: l_procedure_name VARCHAR2(255) := 'CHK_COUNT';
92: BEGIN
93: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
94: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
95: END IF;
96: select count(*) into l_count
97: from hz_dup_set_parties

Line 94: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

90: l_count NUMBER;
91: l_procedure_name VARCHAR2(255) := 'CHK_COUNT';
92: BEGIN
93: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
94: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
95: END IF;
96: select count(*) into l_count
97: from hz_dup_set_parties
98: where dup_set_id = P_DUP_SET_ID

Line 138: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

134: and decode(p_state, 'S', merge_flag, 'E', 'N') = 'N'
135: and dup_party_id <> l_winner_party_id;
136:
137: BEGIN
138: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
139: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
140: END IF;
141: SAVEPOINT create_rem_batch;
142: select hz_merge_batch_s.nextval into l_new_dup_set_id from dual;

Line 139: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

135: and dup_party_id <> l_winner_party_id;
136:
137: BEGIN
138: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
139: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
140: END IF;
141: SAVEPOINT create_rem_batch;
142: select hz_merge_batch_s.nextval into l_new_dup_set_id from dual;
143: log (' Creating remainder batch....');

Line 274: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

270:
271: BEGIN
272: SAVEPOINT automerge;
273: -- Diagnositics
274: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
275: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
276: END IF;
277: -- log(' p_dup_batch_id = ' || p_dup_batch_id);
278: select a.dup_batch_name, a.match_rule_id,

Line 275: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

271: BEGIN
272: SAVEPOINT automerge;
273: -- Diagnositics
274: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
275: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
276: END IF;
277: -- log(' p_dup_batch_id = ' || p_dup_batch_id);
278: select a.dup_batch_name, a.match_rule_id,
279: decode(a.request_type, 'SYSTEM_GENERATED', 'SYSTEM_AUTOMERGE', 'IMPORT', 'IMPORT_AUTOMERGE'), a.request_type, b.automerge_flag