APPS.HZ_MERGE_ENTITY_ATTRI_PVT dependencies on FND_FILE

Line 15: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

11: newline IN BOOLEAN DEFAULT TRUE) IS
12: BEGIN
13:
14: IF message = 'NEWLINE' THEN
15: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
16: ELSIF (newline) THEN
17: FND_FILE.put_line(fnd_file.log,message);
18: ELSE
19: FND_FILE.put(fnd_file.log,message);

Line 17: FND_FILE.put_line(fnd_file.log,message);

13:
14: IF message = 'NEWLINE' THEN
15: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
16: ELSIF (newline) THEN
17: FND_FILE.put_line(fnd_file.log,message);
18: ELSE
19: FND_FILE.put(fnd_file.log,message);
20: END IF;
21: END log;

Line 19: FND_FILE.put(fnd_file.log,message);

15: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
16: ELSIF (newline) THEN
17: FND_FILE.put_line(fnd_file.log,message);
18: ELSE
19: FND_FILE.put(fnd_file.log,message);
20: END IF;
21: END log;
22:
23: function get_healthCarePartyId(p_merge_batch_id in number) return number is

Line 973: -- fnd_file.put_line(fnd_file.log, l_str);

969: l_str := 'select to_char('||p_attribute_name||','||'''YYYY/MM/DD'')'||
970: ' from '||p_entity_name||
971: ' where party_id = :party_id'||
972: ' and sysdate between effective_start_date and nvl(effective_end_date,sysdate)';
973: -- fnd_file.put_line(fnd_file.log, l_str);
974: execute immediate l_str into l_value using p_party_id;
975:
976: else
977: l_str := 'select to_char('||p_attribute_name||')'||

Line 981: --fnd_file.put_line(fnd_file.log, l_str);

977: l_str := 'select to_char('||p_attribute_name||')'||
978: ' from '||p_entity_name||
979: ' where party_id = :party_id'||
980: ' and sysdate between effective_start_date and nvl(effective_end_date,sysdate)';
981: --fnd_file.put_line(fnd_file.log, l_str);
982: execute immediate l_str into l_value using p_party_id;
983: end if;
984: return l_value;
985: end;

Line 1475: -- fnd_file.put_line(fnd_file.log, l_str);

1471: 'AND OP.'||l_col_name||' is not null '||
1472: 'AND nvl(merge_flag, ''Y'') <> ''N'' AND DSP.DUP_SET_ID= '||':p_merge_batch_id'||')' || l_order_by_clause||')'
1473: ||' where rank = 1 and rownum=1' ; --added rownum=1, in case same create/update date for rank = 1
1474:
1475: -- fnd_file.put_line(fnd_file.log, l_str);
1476: end if; -- <> 'BUSINESS_REPORT'
1477: else -- PERSON CASE
1478: l_str := 'select party_id, decode('''||l_col_type||''',''D'',to_char(attri_value,''YYYY/MM/DD''),attri_value) from '||
1479: '(SELECT party_id, attri_value, rank() over (order by cntAttri desc) rank, '||l_date_clause || ' from '||

Line 1489: --fnd_file.put_line(fnd_file.log, l_str);

1485: 'AND OP.'||l_col_name||' is not null '||
1486: 'AND nvl(merge_flag, ''Y'') <> ''N'' AND DSP.DUP_SET_ID= '||':p_merge_batch_id'||')' || l_order_by_clause||')'
1487: ||' where rank = 1 and rownum=1' ; --added rownum=1, in case same create/update date for rank = 1
1488:
1489: --fnd_file.put_line(fnd_file.log, l_str);
1490: end if;
1491: BEGIN
1492: execute immediate l_str into l_attri_party_id, l_attri_value using p_merge_batch_id;
1493: -- fnd_file.put_line(fnd_file.log, l_attri_value || l_col_name);

Line 1493: -- fnd_file.put_line(fnd_file.log, l_attri_value || l_col_name);

1489: --fnd_file.put_line(fnd_file.log, l_str);
1490: end if;
1491: BEGIN
1492: execute immediate l_str into l_attri_party_id, l_attri_value using p_merge_batch_id;
1493: -- fnd_file.put_line(fnd_file.log, l_attri_value || l_col_name);
1494: EXCEPTION
1495: WHEN NO_DATA_FOUND THEN
1496: l_attri_party_id := p_merge_to_party_id;
1497: l_attri_value := null;

Line 1747: --fnd_file.put_line(fnd_file.log, str);

1743: ' from '|| p_entity_name ||
1744: ' where party_id = '||':selected_party_id'||
1745: ' and sysdate between effective_start_date and nvl(effective_end_date,sysdate)';
1746:
1747: --fnd_file.put_line(fnd_file.log, str);
1748: EXECUTE IMMEDIATE str using l_selected_party_id;
1749: end if;
1750: end loop;
1751: close get_entity_attri_csr;