DBA Data[Home] [Help]

APPS.AR_CMGT_PARTY_MERGE dependencies on FND_FILE

Line 18: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Party Merge for AR_CMGT_CREDIT_REQUEST(+)');

14:
15: l_merge_reason_code hz_merge_batch.merge_reason_code%type;
16:
17: Begin
18: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Party Merge for AR_CMGT_CREDIT_REQUEST(+)');
19: x_return_status := FND_API.G_RET_STS_SUCCESS;
20:
21: /* Check the Merge reason. If Merge Reason is 'Duplicate Record'
22: then no validation is performed. */

Line 29: FND_FILE.PUT_LINE(FND_FILE.LOG,'Merge Reason Code '||l_merge_reason_code);

25: into l_merge_reason_code
26: from hz_merge_batch
27: where batch_id = p_batch_id;
28:
29: FND_FILE.PUT_LINE(FND_FILE.LOG,'Merge Reason Code '||l_merge_reason_code);
30:
31: if l_merge_reason_code = 'DUPLICATE' then
32: null;
33: end if;

Line 61: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Party Merge for AR_CMGT_CREDIT_REQUEST(-)');

57: set party_id = p_To_FK_id
58: WHERE party_id = p_from_fk_id;
59: end if;
60: end if;
61: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Party Merge for AR_CMGT_CREDIT_REQUEST(-)');
62: Exception
63: when others then
64: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
65: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 84: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Contact Merge for AR_CMGT_CREDIT_REQUEST(+)');

80:
81: l_merge_reason_code hz_merge_batch.merge_reason_code%type;
82:
83: Begin
84: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Contact Merge for AR_CMGT_CREDIT_REQUEST(+)');
85:
86: x_return_status := FND_API.G_RET_STS_SUCCESS;
87:
88: /* Check the Merge reason. If Merge Reason is 'Duplicate Record'

Line 127: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Contact Merge for AR_CMGT_CREDIT_REQUEST(-)');

123: WHERE contact_party_id = p_from_fk_id
124: AND contact_party_id IS NOT NULL;
125: end if;
126: end if;
127: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Contact Merge for AR_CMGT_CREDIT_REQUEST(-)');
128: Exception
129: when others then
130: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
131: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 150: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Party Merge for AR_CMGT_CASE_FOLDERS(+)');

146:
147: l_merge_reason_code hz_merge_batch.merge_reason_code%type;
148:
149: Begin
150: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Party Merge for AR_CMGT_CASE_FOLDERS(+)');
151: x_return_status := FND_API.G_RET_STS_SUCCESS;
152:
153: /* Check the Merge reason. If Merge Reason is 'Duplicate Record'
154: then no validation is performed. */

Line 205: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Party Merge for AR_CMGT_CASE_FOLDERS(-)');

201: set party_id = p_To_FK_id
202: WHERE party_id = p_from_fk_id;
203: end if;
204: end if;
205: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Party Merge for AR_CMGT_CASE_FOLDERS(-)');
206: Exception
207: when others then
208: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
209: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 236: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Party Merge for AR_CUSTOMER_CALLS_ALL(+)');

232:
233:
234: BEGIN
235:
236: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Party Merge for AR_CUSTOMER_CALLS_ALL(+)');
237:
238:
239: x_return_status := FND_API.G_RET_STS_SUCCESS;
240:

Line 288: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Party Merge for AR_CUSTOMER_CALLS_ALL(-)');

284: phone_id = p_from_fk_id;
285:
286: end if;
287:
288: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Party Merge for AR_CUSTOMER_CALLS_ALL(-)');
289:
290: exception
291: when others then
292:

Line 323: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Party Merge for AR_CUSTOMER_CALL_TOPICS_ALL(+)');

319:
320:
321: BEGIN
322:
323: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Party Merge for AR_CUSTOMER_CALL_TOPICS_ALL(+)');
324:
325: x_return_status := FND_API.G_RET_STS_SUCCESS;
326:
327: open c_duplicate;

Line 372: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Party Merge for AR_CUSTOMER_CALL_TOPICS_ALL(-)');

368: phone_id = p_from_fk_id;
369:
370: end if;
371:
372: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Party Merge for AR_CUSTOMER_CALL_TOPICS_ALL(-)');
373:
374: exception
375: when others then
376:

Line 406: fnd_file.put_line(FND_FILE.LOG,'Start Party Merge for MERGE_CT_CALLS_INFO_FAX(+)');

402:
403:
404: BEGIN
405:
406: fnd_file.put_line(FND_FILE.LOG,'Start Party Merge for MERGE_CT_CALLS_INFO_FAX(+)');
407:
408:
409: x_return_status := FND_API.G_RET_STS_SUCCESS;
410:

Line 458: fnd_file.put_line(FND_FILE.LOG,'Start Party Merge for MERGE_CT_CALLS_INFO_FAX(-)');

454: fax_id = p_from_fk_id;
455:
456: end if;
457:
458: fnd_file.put_line(FND_FILE.LOG,'Start Party Merge for MERGE_CT_CALLS_INFO_FAX(-)');
459:
460: exception
461: when others then
462: