eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_PURGE dependencies on FND_API

Line 4: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1: PACKAGE BODY HZ_PURGE AS
2: /* $Header: ARHPURGB.pls 120.48 2011/03/23 04:54:24 awu ship $ */
3: PROCEDURE GENERATE_BODY
4: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5: x_return_status OUT NOCOPY VARCHAR2,
6: x_msg_count OUT NOCOPY NUMBER,
7: x_msg_data OUT NOCOPY VARCHAR2)
8: IS

Line 61: IF FND_API.to_Boolean(p_init_msg_list) THEN

57:
58: SAVEPOINT generate_body;
59:
60: -- initialize message list if p_init_msg_list is set to TRUE.
61: IF FND_API.to_Boolean(p_init_msg_list) THEN
62: FND_MSG_PUB.initialize;
63: END IF;
64:
65: -- initialize API return status to success.

Line 66: x_return_status := FND_API.G_RET_STS_SUCCESS;

62: FND_MSG_PUB.initialize;
63: END IF;
64:
65: -- initialize API return status to success.
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67: /* Beginnig of the dynamic package generation*/
68: HZ_GEN_PLSQL.new('HZ_PURGE_GEN', 'PACKAGE BODY');
69: HZ_GEN_PLSQL.add_line('CREATE OR REPLACE PACKAGE BODY HZ_PURGE_GEN AS');
70: HZ_GEN_PLSQL.add_line('PROCEDURE IDENTIFY_CANDIDATES(p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 70: HZ_GEN_PLSQL.add_line('PROCEDURE IDENTIFY_CANDIDATES(p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67: /* Beginnig of the dynamic package generation*/
68: HZ_GEN_PLSQL.new('HZ_PURGE_GEN', 'PACKAGE BODY');
69: HZ_GEN_PLSQL.add_line('CREATE OR REPLACE PACKAGE BODY HZ_PURGE_GEN AS');
70: HZ_GEN_PLSQL.add_line('PROCEDURE IDENTIFY_CANDIDATES(p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71: x_return_status OUT NOCOPY VARCHAR2,
72: x_msg_count OUT NOCOPY NUMBER,
73: x_msg_data OUT NOCOPY VARCHAR2,
74: check_flag boolean, con_prg boolean, regid_proc boolean) IS');

Line 90: HZ_GEN_PLSQL.add_line('IF FND_API.to_Boolean(p_init_msg_list) THEN');

86: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));
87: HZ_GEN_PLSQL.add_line('SAVEPOINT identify_candidates;');
88:
89: -- initialize message list if p_init_msg_list is set to TRUE.
90: HZ_GEN_PLSQL.add_line('IF FND_API.to_Boolean(p_init_msg_list) THEN');
91: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.initialize;');
92: HZ_GEN_PLSQL.add_line('END IF;');
93:
94: -- initialize API return status to success.

Line 95: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_SUCCESS;');

91: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.initialize;');
92: HZ_GEN_PLSQL.add_line('END IF;');
93:
94: -- initialize API return status to success.
95: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_SUCCESS;');
96: HZ_GEN_PLSQL.add_line('delete from hz_application_trans_gt; ');
97: HZ_GEN_PLSQL.add_line('open repopulate;');
98: HZ_GEN_PLSQL.add_line('fetch repopulate into single_party;');
99: HZ_GEN_PLSQL.add_line('close repopulate;');

Line 211: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');

207: HZ_GEN_PLSQL.ADD_LINE(fnd_global.local_chr(10));
208: HZ_GEN_PLSQL.add_line('EXCEPTION');
209: HZ_GEN_PLSQL.add_line('WHEN OTHERS THEN');
210: HZ_GEN_PLSQL.add_line('ROLLBACK to identify_candidates;');
211: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
212: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_NAME( ''AR'', ''HZ_API_OTHERS_EXCEP'' );');
213: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_TOKEN( ''ERROR'' ,SQLERRM );');
214: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.ADD;');
215:

Line 217: p_encoded => FND_API.G_FALSE,

213: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_TOKEN( ''ERROR'' ,SQLERRM );');
214: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.ADD;');
215:
216: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.Count_And_Get(
217: p_encoded => FND_API.G_FALSE,
218: p_count => x_msg_count,
219: p_data => x_msg_data );');
220: HZ_GEN_PLSQL.add_line('RAISE FND_API.G_EXC_ERROR;');
221:

Line 220: HZ_GEN_PLSQL.add_line('RAISE FND_API.G_EXC_ERROR;');

216: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.Count_And_Get(
217: p_encoded => FND_API.G_FALSE,
218: p_count => x_msg_count,
219: p_data => x_msg_data );');
220: HZ_GEN_PLSQL.add_line('RAISE FND_API.G_EXC_ERROR;');
221:
222: HZ_GEN_PLSQL.add_line('END IDENTIFY_CANDIDATES;');
223:
224: HZ_GEN_PLSQL.add_line('END HZ_PURGE_GEN;');

Line 230: p_encoded => FND_API.G_FALSE,

226:
227:
228: -- standard call to get message count and if count is 1, get message info.
229: FND_MSG_PUB.Count_And_Get(
230: p_encoded => FND_API.G_FALSE,
231: p_count => x_msg_count,
232: p_data => x_msg_data);
233:
234: EXCEPTION

Line 235: WHEN FND_API.G_EXC_ERROR THEN

231: p_count => x_msg_count,
232: p_data => x_msg_data);
233:
234: EXCEPTION
235: WHEN FND_API.G_EXC_ERROR THEN
236: ROLLBACK ;
237: x_return_status := FND_API.G_RET_STS_ERROR;
238: FND_MSG_PUB.Count_And_Get(
239: p_encoded => FND_API.G_FALSE,

Line 237: x_return_status := FND_API.G_RET_STS_ERROR;

233:
234: EXCEPTION
235: WHEN FND_API.G_EXC_ERROR THEN
236: ROLLBACK ;
237: x_return_status := FND_API.G_RET_STS_ERROR;
238: FND_MSG_PUB.Count_And_Get(
239: p_encoded => FND_API.G_FALSE,
240: p_count => x_msg_count,
241: p_data => x_msg_data);

Line 239: p_encoded => FND_API.G_FALSE,

235: WHEN FND_API.G_EXC_ERROR THEN
236: ROLLBACK ;
237: x_return_status := FND_API.G_RET_STS_ERROR;
238: FND_MSG_PUB.Count_And_Get(
239: p_encoded => FND_API.G_FALSE,
240: p_count => x_msg_count,
241: p_data => x_msg_data);
242: RAISE FND_API.G_EXC_ERROR;
243:

Line 242: RAISE FND_API.G_EXC_ERROR;

238: FND_MSG_PUB.Count_And_Get(
239: p_encoded => FND_API.G_FALSE,
240: p_count => x_msg_count,
241: p_data => x_msg_data);
242: RAISE FND_API.G_EXC_ERROR;
243:
244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
245: ROLLBACK ;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

240: p_count => x_msg_count,
241: p_data => x_msg_data);
242: RAISE FND_API.G_EXC_ERROR;
243:
244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
245: ROLLBACK ;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: FND_MSG_PUB.Count_And_Get(
248: p_encoded => FND_API.G_FALSE,

Line 246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

242: RAISE FND_API.G_EXC_ERROR;
243:
244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
245: ROLLBACK ;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: FND_MSG_PUB.Count_And_Get(
248: p_encoded => FND_API.G_FALSE,
249: p_count => x_msg_count,
250: p_data => x_msg_data);

Line 248: p_encoded => FND_API.G_FALSE,

244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
245: ROLLBACK ;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: FND_MSG_PUB.Count_And_Get(
248: p_encoded => FND_API.G_FALSE,
249: p_count => x_msg_count,
250: p_data => x_msg_data);
251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
252: WHEN OTHERS THEN

Line 251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

247: FND_MSG_PUB.Count_And_Get(
248: p_encoded => FND_API.G_FALSE,
249: p_count => x_msg_count,
250: p_data => x_msg_data);
251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
252: WHEN OTHERS THEN
253: ROLLBACK;
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255:

Line 254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

250: p_data => x_msg_data);
251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
252: WHEN OTHERS THEN
253: ROLLBACK;
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255:
256: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
257: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
258: FND_MSG_PUB.ADD;

Line 261: p_encoded => FND_API.G_FALSE,

257: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
258: FND_MSG_PUB.ADD;
259:
260: FND_MSG_PUB.Count_And_Get(
261: p_encoded => FND_API.G_FALSE,
262: p_count => x_msg_count,
263: p_data => x_msg_data );
264: RAISE FND_API.G_EXC_ERROR;
265:

Line 264: RAISE FND_API.G_EXC_ERROR;

260: FND_MSG_PUB.Count_And_Get(
261: p_encoded => FND_API.G_FALSE,
262: p_count => x_msg_count,
263: p_data => x_msg_data );
264: RAISE FND_API.G_EXC_ERROR;
265:
266: END;
267:
268:

Line 441: WHEN FND_API.G_EXC_ERROR THEN

437: end loop;
438: close printparties;
439:
440: EXCEPTION
441: WHEN FND_API.G_EXC_ERROR THEN
442: retcode := 2;
443: errbuf := errbuf || logerror||SQLERRM;
444: FND_FILE.close;
445: update hz_purge_batches set status='IDENTIFICATION_ERROR' where batch_id=to_number(batchid);

Line 446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

442: retcode := 2;
443: errbuf := errbuf || logerror||SQLERRM;
444: FND_FILE.close;
445: update hz_purge_batches set status='IDENTIFICATION_ERROR' where batch_id=to_number(batchid);
446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
447: retcode := 2;
448: errbuf := errbuf || logerror||SQLERRM;
449: FND_FILE.close;
450: update hz_purge_batches set status='IDENTIFICATION_ERROR' where batch_id=to_number(batchid);

Line 461: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

457:
458: /* To check if a single party has any transactions */
459:
460: /*PROCEDURE check_single_party_trans
461: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
462: x_return_status OUT NOCOPY VARCHAR2,
463: x_msg_count OUT NOCOPY NUMBER,
464: x_msg_data OUT NOCOPY VARCHAR2,
465: partyid number,

Line 480: IF FND_API.to_Boolean(p_init_msg_list) THEN

476: /*
477: SAVEPOINT check_single_party_trans;
478:
479: -- initialize message list if p_init_msg_list is set to TRUE.
480: IF FND_API.to_Boolean(p_init_msg_list) THEN
481: FND_MSG_PUB.initialize;
482: END IF;
483:
484: -- initialize API return status to success.

Line 485: x_return_status := FND_API.G_RET_STS_SUCCESS;

481: FND_MSG_PUB.initialize;
482: END IF;
483:
484: -- initialize API return status to success.
485: x_return_status := FND_API.G_RET_STS_SUCCESS;
486:
487: delete from hz_purge_gt;
488: insert into hz_purge_gt(party_id) select party_id from hz_parties where party_id=partyid;
489: hz_purge_gen.identify_candidates(p_init_msg_list, x_return_status, x_msg_count, x_msg_data, true, false);

Line 501: p_encoded => FND_API.G_FALSE,

497: close party;
498:
499: -- standard call to get message count and if count is 1, get message info.
500: FND_MSG_PUB.Count_And_Get(
501: p_encoded => FND_API.G_FALSE,
502: p_count => x_msg_count,
503: p_data => x_msg_data);
504:
505: EXCEPTION

Line 506: WHEN FND_API.G_EXC_ERROR THEN

502: p_count => x_msg_count,
503: p_data => x_msg_data);
504:
505: EXCEPTION
506: WHEN FND_API.G_EXC_ERROR THEN
507: ROLLBACK TO check_single_party_trans;
508: x_return_status := FND_API.G_RET_STS_ERROR;
509: FND_MSG_PUB.Count_And_Get(
510: p_encoded => FND_API.G_FALSE,

Line 508: x_return_status := FND_API.G_RET_STS_ERROR;

504:
505: EXCEPTION
506: WHEN FND_API.G_EXC_ERROR THEN
507: ROLLBACK TO check_single_party_trans;
508: x_return_status := FND_API.G_RET_STS_ERROR;
509: FND_MSG_PUB.Count_And_Get(
510: p_encoded => FND_API.G_FALSE,
511: p_count => x_msg_count,
512: p_data => x_msg_data);

Line 510: p_encoded => FND_API.G_FALSE,

506: WHEN FND_API.G_EXC_ERROR THEN
507: ROLLBACK TO check_single_party_trans;
508: x_return_status := FND_API.G_RET_STS_ERROR;
509: FND_MSG_PUB.Count_And_Get(
510: p_encoded => FND_API.G_FALSE,
511: p_count => x_msg_count,
512: p_data => x_msg_data);
513: RAISE FND_API.G_EXC_ERROR;
514:

Line 513: RAISE FND_API.G_EXC_ERROR;

509: FND_MSG_PUB.Count_And_Get(
510: p_encoded => FND_API.G_FALSE,
511: p_count => x_msg_count,
512: p_data => x_msg_data);
513: RAISE FND_API.G_EXC_ERROR;
514:
515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
516: ROLLBACK TO check_single_party_trans;
517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

511: p_count => x_msg_count,
512: p_data => x_msg_data);
513: RAISE FND_API.G_EXC_ERROR;
514:
515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
516: ROLLBACK TO check_single_party_trans;
517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
518: FND_MSG_PUB.Count_And_Get(
519: p_encoded => FND_API.G_FALSE,

Line 517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

513: RAISE FND_API.G_EXC_ERROR;
514:
515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
516: ROLLBACK TO check_single_party_trans;
517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
518: FND_MSG_PUB.Count_And_Get(
519: p_encoded => FND_API.G_FALSE,
520: p_count => x_msg_count,
521: p_data => x_msg_data);

Line 519: p_encoded => FND_API.G_FALSE,

515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
516: ROLLBACK TO check_single_party_trans;
517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
518: FND_MSG_PUB.Count_And_Get(
519: p_encoded => FND_API.G_FALSE,
520: p_count => x_msg_count,
521: p_data => x_msg_data);
522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
523:

Line 522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

518: FND_MSG_PUB.Count_And_Get(
519: p_encoded => FND_API.G_FALSE,
520: p_count => x_msg_count,
521: p_data => x_msg_data);
522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
523:
524: WHEN OTHERS THEN
525: ROLLBACK to check_single_party_trans;
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
523:
524: WHEN OTHERS THEN
525: ROLLBACK to check_single_party_trans;
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
527:
528: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
529: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
530: FND_MSG_PUB.ADD;

Line 533: p_encoded => FND_API.G_FALSE,

529: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
530: FND_MSG_PUB.ADD;
531:
532: FND_MSG_PUB.Count_And_Get(
533: p_encoded => FND_API.G_FALSE,
534: p_count => x_msg_count,
535: p_data => x_msg_data );
536: RAISE FND_API.G_EXC_ERROR;
537:

Line 536: RAISE FND_API.G_EXC_ERROR;

532: FND_MSG_PUB.Count_And_Get(
533: p_encoded => FND_API.G_FALSE,
534: p_count => x_msg_count,
535: p_data => x_msg_data );
536: RAISE FND_API.G_EXC_ERROR;
537:
538: end;*/
539:
540: /* Procedure to purge parties. This is called by the concurrent program */

Line 878: WHEN FND_API.G_EXC_ERROR THEN

874: end;
875:
876: hz_common_pub.enable_cont_source_security;
877: EXCEPTION
878: WHEN FND_API.G_EXC_ERROR THEN
879: retcode := 2;
880: errbuf := errbuf || logerror||SQLERRM;
881: FND_FILE.close;
882: update hz_purge_batches set status='PURGE_ERROR' where batch_id=batchid;

Line 883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

879: retcode := 2;
880: errbuf := errbuf || logerror||SQLERRM;
881: FND_FILE.close;
882: update hz_purge_batches set status='PURGE_ERROR' where batch_id=batchid;
883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
884: retcode := 2;
885: errbuf := errbuf || logerror||SQLERRM;
886: FND_FILE.close;
887: update hz_purge_batches set status='PURGE_ERROR' where batch_id=batchid;

Line 899: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

895:
896: /* Purge Single Party */
897:
898: PROCEDURE PURGE_PARTY
899: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
900: x_return_status OUT NOCOPY VARCHAR2,
901: x_msg_count OUT NOCOPY NUMBER,
902: x_msg_data OUT NOCOPY VARCHAR2,
903: p_party_id NUMBER) IS

Line 914: IF FND_API.to_Boolean(p_init_msg_list) THEN

910:
911: SAVEPOINT PURGE_PARTY;
912:
913: -- initialize message list if p_init_msg_list is set to TRUE.
914: IF FND_API.to_Boolean(p_init_msg_list) THEN
915: FND_MSG_PUB.initialize;
916: END IF;
917:
918: -- initialize API return status to success.

Line 919: x_return_status := FND_API.G_RET_STS_SUCCESS;

915: FND_MSG_PUB.initialize;
916: END IF;
917:
918: -- initialize API return status to success.
919: x_return_status := FND_API.G_RET_STS_SUCCESS;
920: ---please enter the directory as the third parameter to which the file needs to be copied.
921: --fnd_file.put_names('delparty.log',null,'/sqlcom/outbound');
922:
923: insert into hz_purge_candidates(BATCH_ID,CANDIDATE_PARTY_ID,PARTY_NAME,PARTY_NUMBER,ADDRESSES,PHONE_NUMBERS,COUNTRY,STATUS,CREATION_DATE,

Line 1112: p_encoded => FND_API.G_FALSE,

1108: --fnd_file.close;
1109: hz_common_pub.enable_cont_source_security;
1110: -- standard call to get message count and if count is 1, get message info.
1111: FND_MSG_PUB.Count_And_Get(
1112: p_encoded => FND_API.G_FALSE,
1113: p_count => x_msg_count,
1114: p_data => x_msg_data);
1115:
1116:

Line 1118: WHEN FND_API.G_EXC_ERROR THEN

1114: p_data => x_msg_data);
1115:
1116:
1117: EXCEPTION
1118: WHEN FND_API.G_EXC_ERROR THEN
1119: ROLLBACK TO PURGE_PARTY;
1120: x_return_status := FND_API.G_RET_STS_ERROR;
1121: FND_MSG_PUB.Count_And_Get(
1122: p_encoded => FND_API.G_FALSE,

Line 1120: x_return_status := FND_API.G_RET_STS_ERROR;

1116:
1117: EXCEPTION
1118: WHEN FND_API.G_EXC_ERROR THEN
1119: ROLLBACK TO PURGE_PARTY;
1120: x_return_status := FND_API.G_RET_STS_ERROR;
1121: FND_MSG_PUB.Count_And_Get(
1122: p_encoded => FND_API.G_FALSE,
1123: p_count => x_msg_count,
1124: p_data => x_msg_data);

Line 1122: p_encoded => FND_API.G_FALSE,

1118: WHEN FND_API.G_EXC_ERROR THEN
1119: ROLLBACK TO PURGE_PARTY;
1120: x_return_status := FND_API.G_RET_STS_ERROR;
1121: FND_MSG_PUB.Count_And_Get(
1122: p_encoded => FND_API.G_FALSE,
1123: p_count => x_msg_count,
1124: p_data => x_msg_data);
1125: RAISE FND_API.G_EXC_ERROR;
1126:

Line 1125: RAISE FND_API.G_EXC_ERROR;

1121: FND_MSG_PUB.Count_And_Get(
1122: p_encoded => FND_API.G_FALSE,
1123: p_count => x_msg_count,
1124: p_data => x_msg_data);
1125: RAISE FND_API.G_EXC_ERROR;
1126:
1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1128: ROLLBACK TO PURGE_PARTY;
1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1123: p_count => x_msg_count,
1124: p_data => x_msg_data);
1125: RAISE FND_API.G_EXC_ERROR;
1126:
1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1128: ROLLBACK TO PURGE_PARTY;
1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1130: FND_MSG_PUB.Count_And_Get(
1131: p_encoded => FND_API.G_FALSE,

Line 1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1125: RAISE FND_API.G_EXC_ERROR;
1126:
1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1128: ROLLBACK TO PURGE_PARTY;
1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1130: FND_MSG_PUB.Count_And_Get(
1131: p_encoded => FND_API.G_FALSE,
1132: p_count => x_msg_count,
1133: p_data => x_msg_data);

Line 1131: p_encoded => FND_API.G_FALSE,

1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1128: ROLLBACK TO PURGE_PARTY;
1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1130: FND_MSG_PUB.Count_And_Get(
1131: p_encoded => FND_API.G_FALSE,
1132: p_count => x_msg_count,
1133: p_data => x_msg_data);
1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1135:

Line 1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1130: FND_MSG_PUB.Count_And_Get(
1131: p_encoded => FND_API.G_FALSE,
1132: p_count => x_msg_count,
1133: p_data => x_msg_data);
1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1135:
1136: WHEN OTHERS THEN
1137: ROLLBACK to PURGE_PARTY;
1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1135:
1136: WHEN OTHERS THEN
1137: ROLLBACK to PURGE_PARTY;
1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1139:
1140: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1141: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1142: FND_MSG_PUB.ADD;

Line 1145: p_encoded => FND_API.G_FALSE,

1141: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1142: FND_MSG_PUB.ADD;
1143:
1144: FND_MSG_PUB.Count_And_Get(
1145: p_encoded => FND_API.G_FALSE,
1146: p_count => x_msg_count,
1147: p_data => x_msg_data );
1148: RAISE FND_API.G_EXC_ERROR;
1149:

Line 1148: RAISE FND_API.G_EXC_ERROR;

1144: FND_MSG_PUB.Count_And_Get(
1145: p_encoded => FND_API.G_FALSE,
1146: p_count => x_msg_count,
1147: p_data => x_msg_data );
1148: RAISE FND_API.G_EXC_ERROR;
1149:
1150: END purge_party;
1151:
1152: PROCEDURE post_app_logic(appid NUMBER, single_party VARCHAR2, check_flag boolean) IS

Line 1183: l_msg_data := l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );

1179: BEGIN
1180: FND_MSG_PUB.Reset;
1181:
1182: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1183: l_msg_data := l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
1184: END LOOP;
1185: log(l_msg_data,true);
1186: RETURN l_msg_data;
1187: END logerror;

Line 1244: RAISE FND_API.G_EXC_ERROR;*/

1240: WHEN OTHERS THEN
1241: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1242: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1243: FND_MSG_PUB.ADD;
1244: RAISE FND_API.G_EXC_ERROR;*/
1245: null;
1246: END get_col_type;
1247:
1248: FUNCTION has_context(proc VARCHAR2) RETURN BOOLEAN IS