DBA Data[Home] [Help]

APPS.AS_TAP_MERGE_PKG dependencies on FND_FILE

Line 65: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_TAP_MERGE_PKG.ACCESS_MERGE start : '

61: and (b.sales_group_id = c.sales_group_id or
62: (b.sales_group_id is null and c.sales_group_id is null)));
63:
64: BEGIN
65: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_TAP_MERGE_PKG.ACCESS_MERGE start : '
66: ||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
67: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity: '||p_parent_entity_name);
68: FND_FILE.PUT_LINE(FND_FILE.LOG,'from_fk: '||p_from_fk_id);
69: FND_FILE.PUT_LINE(FND_FILE.LOG,'to_fk: '||p_to_fk_id);

Line 67: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity: '||p_parent_entity_name);

63:
64: BEGIN
65: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_TAP_MERGE_PKG.ACCESS_MERGE start : '
66: ||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
67: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity: '||p_parent_entity_name);
68: FND_FILE.PUT_LINE(FND_FILE.LOG,'from_fk: '||p_from_fk_id);
69: FND_FILE.PUT_LINE(FND_FILE.LOG,'to_fk: '||p_to_fk_id);
70:
71: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 68: FND_FILE.PUT_LINE(FND_FILE.LOG,'from_fk: '||p_from_fk_id);

64: BEGIN
65: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_TAP_MERGE_PKG.ACCESS_MERGE start : '
66: ||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
67: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity: '||p_parent_entity_name);
68: FND_FILE.PUT_LINE(FND_FILE.LOG,'from_fk: '||p_from_fk_id);
69: FND_FILE.PUT_LINE(FND_FILE.LOG,'to_fk: '||p_to_fk_id);
70:
71: x_return_status := FND_API.G_RET_STS_SUCCESS;
72:

Line 69: FND_FILE.PUT_LINE(FND_FILE.LOG,'to_fk: '||p_to_fk_id);

65: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_TAP_MERGE_PKG.ACCESS_MERGE start : '
66: ||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
67: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity: '||p_parent_entity_name);
68: FND_FILE.PUT_LINE(FND_FILE.LOG,'from_fk: '||p_from_fk_id);
69: FND_FILE.PUT_LINE(FND_FILE.LOG,'to_fk: '||p_to_fk_id);
70:
71: x_return_status := FND_API.G_RET_STS_SUCCESS;
72:
73: select merge_reason_code into l_merge_reason_code

Line 131: FND_FILE.PUT_LINE(FND_FILE.LOG,

127: IF p_from_fk_id <> p_to_fk_id THEN
128: BEGIN
129: IF p_parent_entity_name = 'HZ_PARTIES' THEN
130: FOR I in c_get_pm_access_id (p_from_fk_id, p_to_fk_id) LOOP
131: FND_FILE.PUT_LINE(FND_FILE.LOG,
132: 'Deleting PARTY access_id: '||I.access_id);
133: DELETE FROM as_territory_accesses
134: WHERE access_id = I.access_id;
135:

Line 184: FND_FILE.PUT_LINE(FND_FILE.LOG,

180: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site
181:
182: -- delete duplicate records (which will violate unique constraint)
183: FOR I in c_get_psm_access_id (p_from_fk_id, p_to_fk_id) LOOP
184: FND_FILE.PUT_LINE(FND_FILE.LOG,
185: 'Deleting PARTY SITE access_id: '||I.access_id);
186: DELETE FROM as_territory_accesses
187: WHERE access_id = I.access_id;
188:

Line 232: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AS_TAP_MERGE_PKG .ACCESS_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

228: raise;
229: END;
230: END IF;
231:
232: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AS_TAP_MERGE_PKG .ACCESS_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
233:
234: end;
235:
236: PROCEDURE TAP_MERGE

Line 251: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_TAP_MERGE_PKG .TAP_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

247: l_api_name CONSTANT VARCHAR2(30) := 'TAP_MERGE';
248: l_api_version_number CONSTANT NUMBER := 2.0;
249: l_merge_reason_code VARCHAR2(30);
250: begin
251: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_TAP_MERGE_PKG .TAP_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
252:
253: x_return_status := FND_API.G_RET_STS_SUCCESS;
254:
255: select merge_reason_code into l_merge_reason_code

Line 357: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_TAP_MERGE_PKG .TAP_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

353: raise;
354: END;
355: END IF;
356:
357: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_TAP_MERGE_PKG .TAP_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
358:
359: end;
360: END AS_TAP_MERGE_PKG;