DBA Data[Home] [Help]

APPS.AS_TAP_MERGE_PKG dependencies on FND_FILE

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

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

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

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

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

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

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

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

Line 133: FND_FILE.PUT_LINE(FND_FILE.LOG,

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

Line 173: FND_FILE.PUT_LINE(FND_FILE.LOG,'At exception: '||sqlerrm);

169: program_update_date = sysdate
170: where partner_customer_id = p_from_fk_id;
171: Exception
172: when salesforce_id_null then
173: FND_FILE.PUT_LINE(FND_FILE.LOG,'At exception: '||sqlerrm);
174: UPDATE AS_ACCESSES_ALL
175: set partner_customer_id = p_to_fk_id,
176: last_update_date = hz_utility_pub.last_update_date,
177: last_updated_by = hz_utility_pub.user_id,

Line 201: FND_FILE.PUT_LINE(FND_FILE.LOG,

197: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site
198:
199: -- delete duplicate records (which will violate unique constraint)
200: FOR I in c_get_psm_access_id (p_from_fk_id, p_to_fk_id) LOOP
201: FND_FILE.PUT_LINE(FND_FILE.LOG,
202: 'Deleting PARTY SITE access_id: '||I.access_id);
203: DELETE FROM as_territory_accesses
204: WHERE access_id = I.access_id;
205:

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

245: raise;
246: END;
247: END IF;
248:
249: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AS_TAP_MERGE_PKG .ACCESS_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
250:
251: end;
252:
253: PROCEDURE TAP_MERGE

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

264: l_api_name CONSTANT VARCHAR2(30) := 'TAP_MERGE';
265: l_api_version_number CONSTANT NUMBER := 2.0;
266: l_merge_reason_code VARCHAR2(30);
267: begin
268: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_TAP_MERGE_PKG .TAP_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
269:
270: x_return_status := FND_API.G_RET_STS_SUCCESS;
271:
272: select merge_reason_code into l_merge_reason_code

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

370: raise;
371: END;
372: END IF;
373:
374: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_TAP_MERGE_PKG .TAP_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
375:
376: end;
377: END AS_TAP_MERGE_PKG;