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.AR_INVOICE_API_PUB dependencies on FND_API

Line 19: x_return_status := FND_API.G_RET_STS_SUCCESS;

15: x_return_status OUT NOCOPY VARCHAR2) IS
16:
17: BEGIN
18:
19: x_return_status := FND_API.G_RET_STS_SUCCESS;
20: IF pg_debug = 'Y' THEN
21: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_header(+)' );
22: ar_invoice_utils.debug ('All Default Values ' );
23: ar_invoice_utils.debug ('Set of Books Id '||

Line 41: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

37: p_batch_source_rec => p_batch_source_rec,
38: x_errmsg => x_errmsg,
39: x_return_status => x_return_status);
40:
41: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
42: RETURN;
43: END IF;
44:
45: /* 5921925 - Removed defaulting UPDATE statement and integrated it

Line 55: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

51:
52: EXCEPTION
53: WHEN OTHERS THEN
54: x_errmsg := 'Error in AR_INVOICE_API_PUB.populate_header '||sqlerrm;
55: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
56: RETURN;
57:
58: END;
59:

Line 86: x_return_status := FND_API.G_RET_STS_SUCCESS;

82: IF pg_debug = 'Y' THEN
83: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_lines(+)' );
84: END IF;
85:
86: x_return_status := FND_API.G_RET_STS_SUCCESS;
87:
88: AR_TRX_GLOBAL_PROCESS_LINES.INSERT_ROW(
89: p_trx_lines_tbl => p_trx_lines_tbl,
90: x_errmsg => x_errmsg,

Line 93: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

89: p_trx_lines_tbl => p_trx_lines_tbl,
90: x_errmsg => x_errmsg,
91: x_return_status => x_return_status);
92:
93: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
94: THEN
95: return;
96: END IF;
97:

Line 143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

139:
140: EXCEPTION
141: WHEN OTHERS THEN
142: x_errmsg := 'Error in AR_INVOICE_API_PUB.populate_lines '||sqlerrm;
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: return;
145: END;
146:
147:

Line 168: x_return_status := FND_API.G_RET_STS_SUCCESS;

164: IF pg_debug = 'Y' THEN
165: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_distributions(+)' );
166: END IF;
167:
168: x_return_status := FND_API.G_RET_STS_SUCCESS;
169:
170: --populate global dist. table
171: ar_trx_global_process_dist.insert_row(
172: p_trx_dist_tbl => p_trx_dist_tbl,

Line 176: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

172: p_trx_dist_tbl => p_trx_dist_tbl,
173: x_errmsg => x_errmsg,
174: x_return_status => x_return_status);
175:
176: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
177: return;
178: END IF;
179:
180: /* 5921925 - Should remove this but it would require us to rewrite

Line 214: x_return_status := fnd_api.g_ret_sts_unexp_error;

210: EXCEPTION
211: WHEN OTHERS THEN
212: x_errmsg := 'Error in AR_INVOICE_API_PUB.populate distributions'
213: || sqlerrm;
214: x_return_status := fnd_api.g_ret_sts_unexp_error;
215: RETURN;
216:
217: END populate_distributions;
218:

Line 231: x_return_status := FND_API.G_RET_STS_SUCCESS;

227: IF pg_debug = 'Y'
228: THEN
229: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_salescredits(+)' );
230: END IF;
231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232: --populate global dist. table
233: AR_TRX_GLOBAL_PROCESS_SALESCR.INSERT_ROW(
234: p_trx_salescredits_tbl => p_trx_salescredits_tbl,
235: x_errmsg => x_errmsg,

Line 239: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

235: x_errmsg => x_errmsg,
236: x_return_status => x_return_status
237: );
238:
239: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
240: THEN
241: return;
242: END IF;
243:

Line 264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

260: END IF;
261: EXCEPTION
262: WHEN OTHERS THEN
263: x_errmsg := 'Error in AR_INVOICE_API_PUB.populate sales credits '||sqlerrm;
264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
265: return;
266:
267: END populate_salescredits;
268:

Line 284: x_return_status := FND_API.G_RET_STS_SUCCESS;

280: IF pg_debug = 'Y' THEN
281: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_contingencies(+)' );
282: END IF;
283:
284: x_return_status := FND_API.G_RET_STS_SUCCESS;
285: -- populate global contingencies table
286:
287: ar_trx_global_process_cont.insert_row
288: (

Line 294: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

290: x_errmsg => x_errmsg,
291: x_return_status => x_return_status
292: );
293:
294: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
295: RETURN;
296: END IF;
297:
298: /* 5921925 - Should remove this.. Have to rewrite

Line 315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

311:
312: EXCEPTION
313: WHEN OTHERS THEN
314: x_errmsg := 'error ar_invoice_api_pub.populate_contingencies: '||sqlerrm;
315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
316: RETURN;
317:
318: END populate_contingencies;
319:

Line 345: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

341: END;
342:
343: PROCEDURE CREATE_INVOICE(
344: p_api_version IN NUMBER,
345: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
346: p_commit IN VARCHAR2 := FND_API.G_FALSE,
347: p_batch_source_rec IN batch_source_rec_type DEFAULT NULL,
348: p_trx_header_tbl IN trx_header_tbl_type,
349: p_trx_lines_tbl IN trx_line_tbl_type,

Line 346: p_commit IN VARCHAR2 := FND_API.G_FALSE,

342:
343: PROCEDURE CREATE_INVOICE(
344: p_api_version IN NUMBER,
345: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
346: p_commit IN VARCHAR2 := FND_API.G_FALSE,
347: p_batch_source_rec IN batch_source_rec_type DEFAULT NULL,
348: p_trx_header_tbl IN trx_header_tbl_type,
349: p_trx_lines_tbl IN trx_line_tbl_type,
350: p_trx_dist_tbl IN trx_dist_tbl_type,

Line 390: IF NOT FND_API.Compatible_API_Call(

386: /*--------------------------------------------------+
387: | Standard call to check for call compatibility |
388: +--------------------------------------------------*/
389:
390: IF NOT FND_API.Compatible_API_Call(
391: l_api_version,
392: p_api_version,
393: l_api_name,
394: G_PKG_NAME

Line 397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

393: l_api_name,
394: G_PKG_NAME
395: )
396: THEN
397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
398: END IF;
399:
400: /*--------------------------------------------------------------+
401: | Initialize message list if p_init_msg_list is set to TRUE |

Line 404: IF FND_API.to_Boolean( p_init_msg_list )

400: /*--------------------------------------------------------------+
401: | Initialize message list if p_init_msg_list is set to TRUE |
402: +--------------------------------------------------------------*/
403:
404: IF FND_API.to_Boolean( p_init_msg_list )
405: THEN
406: FND_MSG_PUB.initialize;
407: END IF;
408:

Line 442: l_org_return_status := FND_API.G_RET_STS_SUCCESS;

438: ar_invoice_utils.debug ('x_return_status = '|| x_return_status);
439: ar_invoice_utils.debug ('x_errmsg = '|| x_errmsg);
440:
441: l_org_id := org_rec.org_id;
442: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
443: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
444: p_return_status =>l_org_return_status);
445: ar_invoice_utils.debug ('l_org_id = '|| l_org_id);
446: ar_invoice_utils.debug ('l_org_return_status = '|| l_org_return_status);

Line 458: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

454: p_trx_system_parameters_rec => l_trx_system_parameters_rec,
455: x_errmsg => x_errmsg,
456: x_return_status => x_return_status);
457:
458: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
459: THEN
460: ROLLBACK to Create_Invoice;
461: x_msg_data := x_errmsg;
462: return;

Line 471: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

467: p_trx_profile_rec => l_trx_profile_rec,
468: x_errmsg => x_errmsg,
469: x_return_status => x_return_status) ;
470:
471: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
472: THEN
473: ROLLBACK to Create_Invoice;
474: x_msg_data := x_errmsg;
475: return;

Line 479: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN

475: return;
476: END IF;
477: END IF;
478:
479: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
480: x_return_status := FND_API.G_RET_STS_ERROR;
481: ELSE
482:
483: -- first clean all global temporary tables to start with

Line 480: x_return_status := FND_API.G_RET_STS_ERROR;

476: END IF;
477: END IF;
478:
479: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
480: x_return_status := FND_API.G_RET_STS_ERROR;
481: ELSE
482:
483: -- first clean all global temporary tables to start with
484: clean_gt;

Line 488: x_return_status := fnd_api.g_ret_sts_unexp_error;

484: clean_gt;
485:
486: IF (l_trx_header_tbl.COUNT = 0) OR (l_trx_lines_tbl.COUNT = 0) THEN
487: ROLLBACK to Create_Invoice;
488: x_return_status := fnd_api.g_ret_sts_unexp_error;
489: x_msg_data := arp_standard.fnd_message('AR_INAPI_TABLES_EMPTY');
490: RETURN;
491: END IF;
492:

Line 512: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

508: p_batch_id => l_batch_id,
509: x_errmsg => x_errmsg,
510: x_return_status => x_return_status);
511:
512: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
513: THEN
514: ROLLBACK to Create_Invoice;
515: x_msg_data := x_errmsg;
516: return;

Line 539: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

535: p_trx_profile_rec => l_trx_profile_rec,
536: p_batch_source_rec => p_batch_source_rec,
537: x_errmsg => x_errmsg,
538: x_return_status => x_return_status);
539: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
540: THEN
541: ROLLBACK to Create_Invoice;
542: x_msg_data := x_errmsg;
543: return;

Line 556: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

552: p_trx_system_param_rec => l_trx_system_parameters_rec,
553: x_errmsg => x_errmsg,
554: x_return_status => x_return_status);
555:
556: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
557: ROLLBACK to Create_Invoice;
558: x_msg_data := x_errmsg;
559: RETURN;
560: END IF;

Line 572: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

568: ar_invoice_utils.validate_master_detail
569: ( x_errmsg => x_errmsg,
570: x_return_status => x_return_status);
571:
572: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
573: ROLLBACK to Create_Invoice;
574: x_msg_data := x_errmsg;
575: RETURN;
576: END IF;

Line 594: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

590: p_trx_system_param_rec => l_trx_system_parameters_rec,
591: x_errmsg => x_errmsg,
592: x_return_status => x_return_status );
593:
594: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
595: THEN
596: ROLLBACK to Create_Invoice;
597: x_msg_data := x_errmsg;
598: return;

Line 619: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

615: p_trx_system_param_rec => l_trx_system_parameters_rec,
616: x_errmsg => x_errmsg,
617: x_return_status => x_return_status );
618:
619: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
620: THEN
621: ROLLBACK to Create_Invoice;
622: x_msg_data := x_errmsg;
623: return;

Line 644: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

640: p_trx_system_param_rec => l_trx_system_parameters_rec,
641: x_errmsg => x_errmsg,
642: x_return_status => x_return_status);
643:
644: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
645: THEN
646: ROLLBACK to Create_Invoice;
647: x_msg_data := x_errmsg;
648: return;

Line 654: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

650: ELSE
651: g_cont_exist := FALSE;
652: END IF;
653:
654: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
655: ROLLBACK TO Create_Invoice;
656: x_msg_data := x_errmsg;
657: RETURN;
658: END IF;

Line 667: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

663: IF pg_debug = 'Y' THEN
664: ar_invoice_utils.debug ('populate contingencies(-)' );
665: END IF;
666:
667: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
668: ROLLBACK to Create_Invoice;
669: x_msg_data := x_errmsg;
670: RETURN;
671: END IF;

Line 683: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

679: ( p_trx_system_param_rec => l_trx_system_parameters_rec,
680: x_errmsg => x_errmsg,
681: x_return_status => x_return_status);
682:
683: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
684: THEN
685: ROLLBACK to Create_Invoice;
686: x_msg_data := x_errmsg;
687: return;

Line 703: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

699: p_trx_profile_rec => l_trx_profile_rec,
700: x_errmsg => x_errmsg,
701: x_return_status => x_return_status);
702:
703: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
704: THEN
705: ROLLBACK to Create_Invoice;
706: x_msg_data := x_errmsg;
707: return;

Line 721: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

717: ar_invoice_utils.validate_lines
718: ( x_errmsg => x_errmsg,
719: x_return_status => x_return_status);
720:
721: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
722: THEN
723: ROLLBACK to Create_Invoice;
724: x_msg_data := x_errmsg;
725: return;

Line 741: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

737: ( p_trx_system_parameters_rec => l_trx_system_parameters_rec,
738: x_errmsg => x_errmsg,
739: x_return_status => x_return_status);
740:
741: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
742: THEN
743: ROLLBACK to Create_Invoice;
744: x_msg_data := x_errmsg;
745: return;

Line 762: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

758: p_trx_system_param_rec => l_trx_system_parameters_rec,
759: x_errmsg => x_errmsg,
760: x_return_status => x_return_status);
761:
762: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
763: THEN
764: ROLLBACK to Create_Invoice;
765: x_msg_data := x_errmsg;
766: return;

Line 781: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

777: p_request_id => AR_INVOICE_TABLE_HANDLER.g_request_id,
778: x_errmsg => x_errmsg,
779: x_return_status => x_return_status);
780:
781: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
782: THEN
783: ROLLBACK to Create_Invoice;
784: x_msg_data := x_errmsg;
785: return;

Line 800: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

796: p_batch_source_rec => p_batch_source_rec,
797: x_errmsg => x_errmsg,
798: x_return_status => x_return_status) ;
799:
800: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
801: THEN
802: ROLLBACK to Create_Invoice;
803: x_msg_data := x_errmsg;
804: return;

Line 808: IF FND_API.To_Boolean( p_commit )

804: return;
805: END IF;
806:
807: -- Standard check of p_commit.
808: IF FND_API.To_Boolean( p_commit )
809: THEN
810: COMMIT;
811: END IF;
812: END IF;

Line 841: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

837: END CREATE_INVOICE;
838:
839: PROCEDURE CREATE_SINGLE_INVOICE(
840: p_api_version IN NUMBER,
841: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
842: p_commit IN VARCHAR2 := FND_API.G_FALSE,
843: p_batch_source_rec IN batch_source_rec_type DEFAULT NULL,
844: p_trx_header_tbl IN trx_header_tbl_type,
845: p_trx_lines_tbl IN trx_line_tbl_type,

Line 842: p_commit IN VARCHAR2 := FND_API.G_FALSE,

838:
839: PROCEDURE CREATE_SINGLE_INVOICE(
840: p_api_version IN NUMBER,
841: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
842: p_commit IN VARCHAR2 := FND_API.G_FALSE,
843: p_batch_source_rec IN batch_source_rec_type DEFAULT NULL,
844: p_trx_header_tbl IN trx_header_tbl_type,
845: p_trx_lines_tbl IN trx_line_tbl_type,
846: p_trx_dist_tbl IN trx_dist_tbl_type,

Line 865: x_return_status := FND_API.G_RET_STS_SUCCESS;

861: THEN
862: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(2)(+)' );
863: END IF;
864:
865: x_return_status := FND_API.G_RET_STS_SUCCESS;
866:
867: l_no_of_records := p_trx_header_tbl.COUNT;
868:
869: /* 5921925 - global variable to track single invoice call */

Line 874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

870: g_single_invoice := TRUE;
871:
872: IF ( nvl(l_no_of_records,0) > 1 )
873: THEN
874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
875: x_msg_data := arp_standard.fnd_message('AR_INAPI_MULTIPLE_HEADERS');
876: return;
877: END IF;
878:

Line 895: IF x_return_status = FND_API.G_RET_STS_SUCCESS

891: x_msg_count => x_msg_count,
892: x_msg_data => x_msg_data);
893:
894:
895: IF x_return_status = FND_API.G_RET_STS_SUCCESS
896: THEN
897: -- get the value of cust_trx_id
898: x_customer_trx_id := AR_INVOICE_API_PUB.g_customer_trx_id;
899: END IF;

Line 915: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

911: -- 11-OCT-2004
912:
913: PROCEDURE create_invoice(
914: p_api_version IN NUMBER,
915: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
916: p_commit IN VARCHAR2 := FND_API.G_FALSE,
917: p_batch_source_rec IN batch_source_rec_type DEFAULT NULL,
918: p_trx_header_tbl IN trx_header_tbl_type,
919: p_trx_lines_tbl IN trx_line_tbl_type,

Line 916: p_commit IN VARCHAR2 := FND_API.G_FALSE,

912:
913: PROCEDURE create_invoice(
914: p_api_version IN NUMBER,
915: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
916: p_commit IN VARCHAR2 := FND_API.G_FALSE,
917: p_batch_source_rec IN batch_source_rec_type DEFAULT NULL,
918: p_trx_header_tbl IN trx_header_tbl_type,
919: p_trx_lines_tbl IN trx_line_tbl_type,
920: p_trx_dist_tbl IN trx_dist_tbl_type,

Line 959: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

955:
956:
957: PROCEDURE create_single_invoice (
958: p_api_version IN NUMBER,
959: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
960: p_commit IN VARCHAR2 := FND_API.G_FALSE,
961: p_batch_source_rec IN batch_source_rec_type DEFAULT NULL,
962: p_trx_header_tbl IN trx_header_tbl_type,
963: p_trx_lines_tbl IN trx_line_tbl_type,

Line 960: p_commit IN VARCHAR2 := FND_API.G_FALSE,

956:
957: PROCEDURE create_single_invoice (
958: p_api_version IN NUMBER,
959: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
960: p_commit IN VARCHAR2 := FND_API.G_FALSE,
961: p_batch_source_rec IN batch_source_rec_type DEFAULT NULL,
962: p_trx_header_tbl IN trx_header_tbl_type,
963: p_trx_lines_tbl IN trx_line_tbl_type,
964: p_trx_dist_tbl IN trx_dist_tbl_type,

Line 1281: p_return_status := FND_API.G_RET_STS_SUCCESS;

1277: BEGIN
1278:
1279: ar_invoice_utils.debug('Validate_Delete_Transaction()+');
1280:
1281: p_return_status := FND_API.G_RET_STS_SUCCESS;
1282:
1283: /*------------------------------------------------------------+
1284: | Get the header record for the transaction to be deleted. |
1285: +------------------------------------------------------------*/

Line 1295: p_return_status := FND_API.G_RET_STS_ERROR;

1291: );
1292:
1293: EXCEPTION
1294: WHEN NO_DATA_FOUND THEN
1295: p_return_status := FND_API.G_RET_STS_ERROR;
1296:
1297: arp_trx_validate.Add_To_Error_List(
1298: p_mode => 'PL/SQL',
1299: P_error_count => l_dummy,

Line 1323: p_return_status := FND_API.G_RET_STS_ERROR;

1319:
1320: IF ( arp_global.sysparam.invoice_deletion_flag <> 'Y' )
1321: THEN
1322:
1323: p_return_status := FND_API.G_RET_STS_ERROR;
1324:
1325: arp_trx_validate.Add_To_Error_List(
1326: p_mode => 'PL/SQL',
1327: P_error_count => l_dummy,

Line 1376: p_return_status := FND_API.G_RET_STS_ERROR;

1372: );
1373:
1374: IF ( l_dm_reversal_flag = 'Y' )
1375: THEN
1376: p_return_status := FND_API.G_RET_STS_ERROR;
1377:
1378: arp_trx_validate.Add_To_Error_List(
1379: p_mode => 'PL/SQL',
1380: p_error_count => l_dummy,

Line 1392: p_return_status := FND_API.G_RET_STS_ERROR;

1388: END IF;
1389:
1390: IF ( l_cb_flag = 'Y' )
1391: THEN
1392: p_return_status := FND_API.G_RET_STS_ERROR;
1393:
1394: arp_trx_validate.Add_To_Error_List(
1395: p_mode => 'PL/SQL',
1396: p_error_count => l_dummy,

Line 1407: p_return_status := FND_API.G_RET_STS_ERROR;

1403: END IF;
1404:
1405: IF ( l_posted_flag = 'Y' )
1406: THEN
1407: p_return_status := FND_API.G_RET_STS_ERROR;
1408:
1409: arp_trx_validate.Add_To_Error_List(
1410: p_mode => 'PL/SQL',
1411: p_error_count => l_dummy,

Line 1423: p_return_status := FND_API.G_RET_STS_ERROR;

1419: END IF;
1420:
1421: IF ( l_activity_flag = 'Y' )
1422: THEN
1423: p_return_status := FND_API.G_RET_STS_ERROR;
1424:
1425: arp_trx_validate.Add_To_Error_List(
1426: p_mode => 'PL/SQL',
1427: p_error_count => l_dummy,

Line 1492: l_fnd_api_constants_rec ar_bills_main.fnd_api_constants_type := ar_bills_main.get_fnd_api_constants_rec;

1488: x_msg_count NUMBER;
1489: x_msg_data VARCHAR2(240);
1490: x_return_status VARCHAR2(240);
1491: l_payment_trxn_extn_id ra_customer_trx.PAYMENT_TRXN_EXTENSION_ID%TYPE;
1492: l_fnd_api_constants_rec ar_bills_main.fnd_api_constants_type := ar_bills_main.get_fnd_api_constants_rec;
1493: Begin
1494: ar_invoice_utils.debug('AR_INVOICE_API_PUB.Delete_Trxn_Extn_Details()+ ');
1495:
1496: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1496: p_return_status := FND_API.G_RET_STS_SUCCESS;

1492: l_fnd_api_constants_rec ar_bills_main.fnd_api_constants_type := ar_bills_main.get_fnd_api_constants_rec;
1493: Begin
1494: ar_invoice_utils.debug('AR_INVOICE_API_PUB.Delete_Trxn_Extn_Details()+ ');
1495:
1496: p_return_status := FND_API.G_RET_STS_SUCCESS;
1497:
1498:
1499: x_msg_count := NULL;
1500: x_msg_data := NULL;

Line 1501: x_return_status := l_fnd_api_constants_rec.G_RET_STS_SUCCESS;

1497:
1498:
1499: x_msg_count := NULL;
1500: x_msg_data := NULL;
1501: x_return_status := l_fnd_api_constants_rec.G_RET_STS_SUCCESS;
1502: l_payer_rec.party_id := arp_trx_defaults_3.get_party_Id(p_trx_rec.BILL_TO_CUSTOMER_ID);
1503: l_payer_rec.payment_function := 'CUSTOMER_PAYMENT';
1504: l_payer_rec.org_type := 'OPERATING_UNIT';
1505: l_payer_rec.cust_account_id := p_trx_rec.BILL_TO_CUSTOMER_ID;

Line 1530: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1526: x_response => l_response);
1527:
1528:
1529:
1530: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1531: THEN
1532: ar_invoice_utils.debug('Payment_Trxn_Extension_Id : ' || l_payment_trxn_extn_id);
1533: Else
1534: ar_invoice_utils.debug('Errors Reported by IBY API:Delete Transaction Extension ');

Line 1535: p_return_status := FND_API.G_RET_STS_ERROR;

1531: THEN
1532: ar_invoice_utils.debug('Payment_Trxn_Extension_Id : ' || l_payment_trxn_extn_id);
1533: Else
1534: ar_invoice_utils.debug('Errors Reported by IBY API:Delete Transaction Extension ');
1535: p_return_status := FND_API.G_RET_STS_ERROR;
1536: END IF;
1537: EXCEPTION
1538: WHEN OTHERS THEN
1539: ar_invoice_utils.debug('exception in AR_INVOICE_API_PUB.Delete_Trxn_Extn_Detail ');

Line 1540: p_return_status := FND_API.G_RET_STS_ERROR;

1536: END IF;
1537: EXCEPTION
1538: WHEN OTHERS THEN
1539: ar_invoice_utils.debug('exception in AR_INVOICE_API_PUB.Delete_Trxn_Extn_Detail ');
1540: p_return_status := FND_API.G_RET_STS_ERROR;
1541: END Delete_Trxn_Extn_Details;
1542:
1543:
1544: /*===========================================================================+

Line 1562: | fnd_api.compatible_api_call |

1558: | arp_trx_validate.Add_To_Error_List |
1559: | arp_process_header.delete_header |
1560: | arp_util.disable_debug |
1561: | arp_util.enable_debug |
1562: | fnd_api.compatible_api_call |
1563: | fnd_api.g_exc_unexpected_error |
1564: | fnd_api.g_ret_sts_error |
1565: | fnd_api.g_ret_sts_error |
1566: | fnd_api.g_ret_sts_success |

Line 1563: | fnd_api.g_exc_unexpected_error |

1559: | arp_process_header.delete_header |
1560: | arp_util.disable_debug |
1561: | arp_util.enable_debug |
1562: | fnd_api.compatible_api_call |
1563: | fnd_api.g_exc_unexpected_error |
1564: | fnd_api.g_ret_sts_error |
1565: | fnd_api.g_ret_sts_error |
1566: | fnd_api.g_ret_sts_success |
1567: | fnd_api.to_boolean |

Line 1564: | fnd_api.g_ret_sts_error |

1560: | arp_util.disable_debug |
1561: | arp_util.enable_debug |
1562: | fnd_api.compatible_api_call |
1563: | fnd_api.g_exc_unexpected_error |
1564: | fnd_api.g_ret_sts_error |
1565: | fnd_api.g_ret_sts_error |
1566: | fnd_api.g_ret_sts_success |
1567: | fnd_api.to_boolean |
1568: | fnd_msg_pub.check_msg_level |

Line 1565: | fnd_api.g_ret_sts_error |

1561: | arp_util.enable_debug |
1562: | fnd_api.compatible_api_call |
1563: | fnd_api.g_exc_unexpected_error |
1564: | fnd_api.g_ret_sts_error |
1565: | fnd_api.g_ret_sts_error |
1566: | fnd_api.g_ret_sts_success |
1567: | fnd_api.to_boolean |
1568: | fnd_msg_pub.check_msg_level |
1569: | fnd_msg_pub.count_and_get |

Line 1566: | fnd_api.g_ret_sts_success |

1562: | fnd_api.compatible_api_call |
1563: | fnd_api.g_exc_unexpected_error |
1564: | fnd_api.g_ret_sts_error |
1565: | fnd_api.g_ret_sts_error |
1566: | fnd_api.g_ret_sts_success |
1567: | fnd_api.to_boolean |
1568: | fnd_msg_pub.check_msg_level |
1569: | fnd_msg_pub.count_and_get |
1570: | fnd_msg_pub.initialize |

Line 1567: | fnd_api.to_boolean |

1563: | fnd_api.g_exc_unexpected_error |
1564: | fnd_api.g_ret_sts_error |
1565: | fnd_api.g_ret_sts_error |
1566: | fnd_api.g_ret_sts_success |
1567: | fnd_api.to_boolean |
1568: | fnd_msg_pub.check_msg_level |
1569: | fnd_msg_pub.count_and_get |
1570: | fnd_msg_pub.initialize |
1571: | |

Line 1598: p_init_msg_list IN varchar2 := FND_API.G_FALSE,

1594:
1595: PROCEDURE Delete_Transaction(
1596: p_api_name IN varchar2,
1597: p_api_version IN number,
1598: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1599: p_commit IN varchar2 := FND_API.G_FALSE,
1600: p_validation_level IN varchar2 := FND_API.G_VALID_LEVEL_FULL,
1601: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1602: p_return_status OUT NOCOPY varchar2,

Line 1599: p_commit IN varchar2 := FND_API.G_FALSE,

1595: PROCEDURE Delete_Transaction(
1596: p_api_name IN varchar2,
1597: p_api_version IN number,
1598: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1599: p_commit IN varchar2 := FND_API.G_FALSE,
1600: p_validation_level IN varchar2 := FND_API.G_VALID_LEVEL_FULL,
1601: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1602: p_return_status OUT NOCOPY varchar2,
1603: p_msg_count IN OUT NOCOPY NUMBER,

Line 1600: p_validation_level IN varchar2 := FND_API.G_VALID_LEVEL_FULL,

1596: p_api_name IN varchar2,
1597: p_api_version IN number,
1598: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1599: p_commit IN varchar2 := FND_API.G_FALSE,
1600: p_validation_level IN varchar2 := FND_API.G_VALID_LEVEL_FULL,
1601: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1602: p_return_status OUT NOCOPY varchar2,
1603: p_msg_count IN OUT NOCOPY NUMBER,
1604: p_msg_data IN OUT NOCOPY varchar2,

Line 1646: IF NOT FND_API.Compatible_API_Call(

1642: /*--------------------------------------------------+
1643: | Standard call to check for call compatibility |
1644: +--------------------------------------------------*/
1645:
1646: IF NOT FND_API.Compatible_API_Call(
1647: l_api_version,
1648: p_api_version,
1649: l_api_name,
1650: G_PKG_NAME

Line 1653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1649: l_api_name,
1650: G_PKG_NAME
1651: )
1652: THEN
1653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1654: END IF;
1655:
1656: /*--------------------------------------------------------------+
1657: | Initialize message list if p_init_msg_list is set to TRUE |

Line 1660: IF FND_API.to_Boolean( p_init_msg_list )

1656: /*--------------------------------------------------------------+
1657: | Initialize message list if p_init_msg_list is set to TRUE |
1658: +--------------------------------------------------------------*/
1659:
1660: IF FND_API.to_Boolean( p_init_msg_list )
1661: THEN
1662: FND_MSG_PUB.initialize;
1663: arp_trx_validate.pg_message_tbl.DELETE;
1664: END IF;

Line 1670: l_return_status := FND_API.G_RET_STS_SUCCESS;

1666: /*-----------------------------------------+
1667: | Initialize return status to SUCCESS |
1668: +-----------------------------------------*/
1669:
1670: l_return_status := FND_API.G_RET_STS_SUCCESS;
1671:
1672: /*---------------------------------------------+
1673: | ========== Start of API Body ========== |
1674: +---------------------------------------------*/

Line 1686: IF ( l_validation_status = FND_API.G_RET_STS_SUCCESS )

1682: l_type_rec,
1683: l_validation_status
1684: );
1685:
1686: IF ( l_validation_status = FND_API.G_RET_STS_SUCCESS )
1687: THEN
1688: IF ( l_trx_rec.complete_flag = 'Y' )
1689: THEN
1690:

Line 1783: l_return_status = FND_API.G_RET_STS_SUCCESS

1779: ar_invoice_utils.debug ('. update_status = ' || l_update_status);
1780: END IF;
1781:
1782: IF (
1783: l_return_status = FND_API.G_RET_STS_SUCCESS
1784: AND l_update_status = 'OK'
1785: )
1786: THEN
1787: IF pg_debug = 'Y'

Line 1797: l_delete_pmt_ext_status := FND_API.G_RET_STS_SUCCESS;

1793: IF l_trx_rec.payment_trxn_extension_id IS NOT NULL THEN
1794: Delete_Trxn_Extn_Details(l_trx_rec,
1795: l_delete_pmt_ext_status);
1796: ELSE
1797: l_delete_pmt_ext_status := FND_API.G_RET_STS_SUCCESS;
1798: END IF;
1799:
1800: IF l_delete_pmt_ext_status = FND_API.G_RET_STS_SUCCESS THEN
1801:

Line 1800: IF l_delete_pmt_ext_status = FND_API.G_RET_STS_SUCCESS THEN

1796: ELSE
1797: l_delete_pmt_ext_status := FND_API.G_RET_STS_SUCCESS;
1798: END IF;
1799:
1800: IF l_delete_pmt_ext_status = FND_API.G_RET_STS_SUCCESS THEN
1801:
1802: arp_process_header.delete_header(
1803: p_api_name,
1804: p_api_version,

Line 1864: OR l_delete_pmt_ext_status <> FND_API.G_RET_STS_SUCCESS

1860: IF (
1861: NVL( arp_trx_validate.pg_message_tbl.COUNT, 0) > 0
1862: OR l_update_status <> 'OK'
1863: OR l_delete_status <> 'OK'
1864: OR l_delete_pmt_ext_status <> FND_API.G_RET_STS_SUCCESS
1865: OR l_return_status <> FND_API.G_RET_STS_SUCCESS
1866: )
1867: THEN
1868:

Line 1865: OR l_return_status <> FND_API.G_RET_STS_SUCCESS

1861: NVL( arp_trx_validate.pg_message_tbl.COUNT, 0) > 0
1862: OR l_update_status <> 'OK'
1863: OR l_delete_status <> 'OK'
1864: OR l_delete_pmt_ext_status <> FND_API.G_RET_STS_SUCCESS
1865: OR l_return_status <> FND_API.G_RET_STS_SUCCESS
1866: )
1867: THEN
1868:
1869: p_errors := arp_trx_validate.pg_message_tbl;

Line 1873: p_return_status := FND_API.G_RET_STS_ERROR ;

1869: p_errors := arp_trx_validate.pg_message_tbl;
1870:
1871: ROLLBACK TO Delete_Transaction_PUB;
1872:
1873: p_return_status := FND_API.G_RET_STS_ERROR ;
1874:
1875: IF pg_debug = 'Y'
1876: THEN
1877: ar_invoice_utils.debug ('Error(s) occurred. Rolling back and setting status to ERROR');

Line 1889: IF FND_API.To_Boolean( p_commit )

1885: /*--------------------------------+
1886: | Standard check of p_commit |
1887: +--------------------------------*/
1888:
1889: IF FND_API.To_Boolean( p_commit )
1890: THEN ar_invoice_utils.debug('committing');
1891: Commit;
1892: END IF;
1893:

Line 1901: p_return_status := FND_API.G_RET_STS_ERROR;

1897: EXCEPTION
1898: WHEN NO_DATA_FOUND THEN
1899:
1900: ROLLBACK TO Delete_Transaction_PUB;
1901: p_return_status := FND_API.G_RET_STS_ERROR;
1902: Display_Parameters;
1903:
1904: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1905: p_data => p_msg_data

Line 1908: WHEN FND_API.G_EXC_ERROR THEN

1904: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1905: p_data => p_msg_data
1906: );
1907:
1908: WHEN FND_API.G_EXC_ERROR THEN
1909: ar_invoice_utils.debug(SQLCODE);
1910: ar_invoice_utils.debug(SQLERRM);
1911:
1912:

Line 1914: p_return_status := FND_API.G_RET_STS_ERROR ;

1910: ar_invoice_utils.debug(SQLERRM);
1911:
1912:
1913: ROLLBACK TO Delete_Transaction_PUB;
1914: p_return_status := FND_API.G_RET_STS_ERROR ;
1915: Display_Parameters;
1916:
1917: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1918: p_data => p_msg_data

Line 1921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1917: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1918: p_data => p_msg_data
1919: );
1920:
1921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1922:
1923: ar_invoice_utils.debug(SQLCODE);
1924: ar_invoice_utils.debug(SQLERRM);
1925: ROLLBACK TO Delete_Transaction_PUB;

Line 1926: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1922:
1923: ar_invoice_utils.debug(SQLCODE);
1924: ar_invoice_utils.debug(SQLERRM);
1925: ROLLBACK TO Delete_Transaction_PUB;
1926: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1927: Display_Parameters;
1928:
1929: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1930: p_data => p_msg_data

Line 1948: p_return_status := FND_API.G_RET_STS_ERROR ;

1944: p_errors := arp_trx_validate.pg_message_tbl;
1945:
1946: ROLLBACK TO Delete_Transaction_PUB;
1947:
1948: p_return_status := FND_API.G_RET_STS_ERROR ;
1949:
1950: ar_invoice_utils.debug('Completion validation error(s) occurred. ' ||
1951: 'Rolling back and setting status to ERROR');
1952:

Line 1960: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1956: END IF;
1957:
1958: ROLLBACK TO Delete_Transaction_PUB;
1959:
1960: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1961: Display_Parameters;
1962:
1963: IF FND_MSG_PUB.Check_Msg_Level
1964: THEN