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 734: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

730: WHERE gt.trx_header_id = gt2.trx_header_id
731: AND gt2.trx_class = 'CM'
732: AND gt.line_type = 'LINE');
733:
734: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
735: THEN
736: ROLLBACK to Create_Invoice;
737: x_msg_data := x_errmsg;
738: return;

Line 754: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

750: ( p_trx_system_parameters_rec => l_trx_system_parameters_rec,
751: x_errmsg => x_errmsg,
752: x_return_status => x_return_status);
753:
754: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
755: THEN
756: ROLLBACK to Create_Invoice;
757: x_msg_data := x_errmsg;
758: return;

Line 775: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

771: p_trx_system_param_rec => l_trx_system_parameters_rec,
772: x_errmsg => x_errmsg,
773: x_return_status => x_return_status);
774:
775: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
776: THEN
777: ROLLBACK to Create_Invoice;
778: x_msg_data := x_errmsg;
779: return;

Line 794: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

790: p_request_id => AR_INVOICE_TABLE_HANDLER.g_request_id,
791: x_errmsg => x_errmsg,
792: x_return_status => x_return_status);
793:
794: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
795: THEN
796: ROLLBACK to Create_Invoice;
797: x_msg_data := x_errmsg;
798: return;

Line 813: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

809: p_batch_source_rec => p_batch_source_rec,
810: x_errmsg => x_errmsg,
811: x_return_status => x_return_status) ;
812:
813: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
814: THEN
815: ROLLBACK to Create_Invoice;
816: x_msg_data := x_errmsg;
817: return;

Line 836: x_return_status :=FND_API.G_RET_STS_ERROR;

832: ar_invoice_utils.debug('Creating the invoices in Complete Status ');
833: ar_invoice_utils.debug('Issue at the time of signature generation for localization');
834: ar_invoice_utils.debug('Message : '||p_return_message);
835: x_msg_data := p_return_message;
836: x_return_status :=FND_API.G_RET_STS_ERROR;
837: x_msg_count :=-99;
838: END IF;
839:
840: END;

Line 875: IF FND_API.To_Boolean( p_commit )

871: ar_invoice_utils.debug (' Exiting from JL Code Hook');
872: END IF;
873:
874: -- Standard check of p_commit.
875: IF FND_API.To_Boolean( p_commit )
876: THEN
877: COMMIT;
878: END IF;
879: END IF;

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

903: END CREATE_INVOICE;
904:
905: PROCEDURE CREATE_SINGLE_INVOICE(
906: p_api_version IN NUMBER,
907: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
908: p_commit IN VARCHAR2 := FND_API.G_FALSE,
909: p_batch_source_rec IN batch_source_rec_type DEFAULT NULL,
910: p_trx_header_tbl IN trx_header_tbl_type,
911: p_trx_lines_tbl IN trx_line_tbl_type,

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

904:
905: PROCEDURE CREATE_SINGLE_INVOICE(
906: p_api_version IN NUMBER,
907: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
908: p_commit IN VARCHAR2 := FND_API.G_FALSE,
909: p_batch_source_rec IN batch_source_rec_type DEFAULT NULL,
910: p_trx_header_tbl IN trx_header_tbl_type,
911: p_trx_lines_tbl IN trx_line_tbl_type,
912: p_trx_dist_tbl IN trx_dist_tbl_type,

Line 931: x_return_status := FND_API.G_RET_STS_SUCCESS;

927: THEN
928: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(2)(+)' );
929: END IF;
930:
931: x_return_status := FND_API.G_RET_STS_SUCCESS;
932:
933: l_no_of_records := p_trx_header_tbl.COUNT;
934:
935: /* 5921925 - global variable to track single invoice call */

Line 940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

936: g_single_invoice := TRUE;
937:
938: IF ( nvl(l_no_of_records,0) > 1 )
939: THEN
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
941: x_msg_data := arp_standard.fnd_message('AR_INAPI_MULTIPLE_HEADERS');
942: return;
943: END IF;
944:

Line 962: IF x_return_status = FND_API.G_RET_STS_SUCCESS

958: x_msg_count => x_msg_count,
959: x_msg_data => x_msg_data);
960:
961: -- added code nvl(x_msg_count,0)=-99 for bug10349867
962: IF x_return_status = FND_API.G_RET_STS_SUCCESS
963: THEN
964: -- get the value of cust_trx_id
965: x_customer_trx_id := AR_INVOICE_API_PUB.g_customer_trx_id;
966: END IF;

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

978: -- 11-OCT-2004
979:
980: PROCEDURE create_invoice(
981: p_api_version IN NUMBER,
982: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
983: p_commit IN VARCHAR2 := FND_API.G_FALSE,
984: p_batch_source_rec IN batch_source_rec_type DEFAULT NULL,
985: p_trx_header_tbl IN trx_header_tbl_type,
986: p_trx_lines_tbl IN trx_line_tbl_type,

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

979:
980: PROCEDURE create_invoice(
981: p_api_version IN NUMBER,
982: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
983: p_commit IN VARCHAR2 := FND_API.G_FALSE,
984: p_batch_source_rec IN batch_source_rec_type DEFAULT NULL,
985: p_trx_header_tbl IN trx_header_tbl_type,
986: p_trx_lines_tbl IN trx_line_tbl_type,
987: p_trx_dist_tbl IN trx_dist_tbl_type,

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

1022:
1023:
1024: PROCEDURE create_single_invoice (
1025: p_api_version IN NUMBER,
1026: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1027: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1028: p_batch_source_rec IN batch_source_rec_type DEFAULT NULL,
1029: p_trx_header_tbl IN trx_header_tbl_type,
1030: p_trx_lines_tbl IN trx_line_tbl_type,

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

1023:
1024: PROCEDURE create_single_invoice (
1025: p_api_version IN NUMBER,
1026: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1027: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1028: p_batch_source_rec IN batch_source_rec_type DEFAULT NULL,
1029: p_trx_header_tbl IN trx_header_tbl_type,
1030: p_trx_lines_tbl IN trx_line_tbl_type,
1031: p_trx_dist_tbl IN trx_dist_tbl_type,

Line 1348: p_return_status := FND_API.G_RET_STS_SUCCESS;

1344: BEGIN
1345:
1346: ar_invoice_utils.debug('Validate_Delete_Transaction()+');
1347:
1348: p_return_status := FND_API.G_RET_STS_SUCCESS;
1349:
1350: /*------------------------------------------------------------+
1351: | Get the header record for the transaction to be deleted. |
1352: +------------------------------------------------------------*/

Line 1362: p_return_status := FND_API.G_RET_STS_ERROR;

1358: );
1359:
1360: EXCEPTION
1361: WHEN NO_DATA_FOUND THEN
1362: p_return_status := FND_API.G_RET_STS_ERROR;
1363:
1364: arp_trx_validate.Add_To_Error_List(
1365: p_mode => 'PL/SQL',
1366: P_error_count => l_dummy,

Line 1390: p_return_status := FND_API.G_RET_STS_ERROR;

1386:
1387: IF ( arp_global.sysparam.invoice_deletion_flag <> 'Y' )
1388: THEN
1389:
1390: p_return_status := FND_API.G_RET_STS_ERROR;
1391:
1392: arp_trx_validate.Add_To_Error_List(
1393: p_mode => 'PL/SQL',
1394: P_error_count => l_dummy,

Line 1443: p_return_status := FND_API.G_RET_STS_ERROR;

1439: );
1440:
1441: IF ( l_dm_reversal_flag = 'Y' )
1442: THEN
1443: p_return_status := FND_API.G_RET_STS_ERROR;
1444:
1445: arp_trx_validate.Add_To_Error_List(
1446: p_mode => 'PL/SQL',
1447: p_error_count => l_dummy,

Line 1459: p_return_status := FND_API.G_RET_STS_ERROR;

1455: END IF;
1456:
1457: IF ( l_cb_flag = 'Y' )
1458: THEN
1459: p_return_status := FND_API.G_RET_STS_ERROR;
1460:
1461: arp_trx_validate.Add_To_Error_List(
1462: p_mode => 'PL/SQL',
1463: p_error_count => l_dummy,

Line 1474: p_return_status := FND_API.G_RET_STS_ERROR;

1470: END IF;
1471:
1472: IF ( l_posted_flag = 'Y' )
1473: THEN
1474: p_return_status := FND_API.G_RET_STS_ERROR;
1475:
1476: arp_trx_validate.Add_To_Error_List(
1477: p_mode => 'PL/SQL',
1478: p_error_count => l_dummy,

Line 1490: p_return_status := FND_API.G_RET_STS_ERROR;

1486: END IF;
1487:
1488: IF ( l_activity_flag = 'Y' )
1489: THEN
1490: p_return_status := FND_API.G_RET_STS_ERROR;
1491:
1492: arp_trx_validate.Add_To_Error_List(
1493: p_mode => 'PL/SQL',
1494: p_error_count => l_dummy,

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

1555: x_msg_count NUMBER;
1556: x_msg_data VARCHAR2(240);
1557: x_return_status VARCHAR2(240);
1558: l_payment_trxn_extn_id ra_customer_trx.PAYMENT_TRXN_EXTENSION_ID%TYPE;
1559: l_fnd_api_constants_rec ar_bills_main.fnd_api_constants_type := ar_bills_main.get_fnd_api_constants_rec;
1560: Begin
1561: ar_invoice_utils.debug('AR_INVOICE_API_PUB.Delete_Trxn_Extn_Details()+ ');
1562:
1563: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1563: p_return_status := FND_API.G_RET_STS_SUCCESS;

1559: l_fnd_api_constants_rec ar_bills_main.fnd_api_constants_type := ar_bills_main.get_fnd_api_constants_rec;
1560: Begin
1561: ar_invoice_utils.debug('AR_INVOICE_API_PUB.Delete_Trxn_Extn_Details()+ ');
1562:
1563: p_return_status := FND_API.G_RET_STS_SUCCESS;
1564:
1565:
1566: x_msg_count := NULL;
1567: x_msg_data := NULL;

Line 1568: x_return_status := l_fnd_api_constants_rec.G_RET_STS_SUCCESS;

1564:
1565:
1566: x_msg_count := NULL;
1567: x_msg_data := NULL;
1568: x_return_status := l_fnd_api_constants_rec.G_RET_STS_SUCCESS;
1569: l_payer_rec.party_id := arp_trx_defaults_3.get_party_Id(p_trx_rec.BILL_TO_CUSTOMER_ID);
1570: l_payer_rec.payment_function := 'CUSTOMER_PAYMENT';
1571: l_payer_rec.org_type := 'OPERATING_UNIT';
1572: l_payer_rec.cust_account_id := p_trx_rec.BILL_TO_CUSTOMER_ID;

Line 1597: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1593: x_response => l_response);
1594:
1595:
1596:
1597: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1598: THEN
1599: ar_invoice_utils.debug('Payment_Trxn_Extension_Id : ' || l_payment_trxn_extn_id);
1600: Else
1601: ar_invoice_utils.debug('Errors Reported by IBY API:Delete Transaction Extension ');

Line 1602: p_return_status := FND_API.G_RET_STS_ERROR;

1598: THEN
1599: ar_invoice_utils.debug('Payment_Trxn_Extension_Id : ' || l_payment_trxn_extn_id);
1600: Else
1601: ar_invoice_utils.debug('Errors Reported by IBY API:Delete Transaction Extension ');
1602: p_return_status := FND_API.G_RET_STS_ERROR;
1603: END IF;
1604: EXCEPTION
1605: WHEN OTHERS THEN
1606: ar_invoice_utils.debug('exception in AR_INVOICE_API_PUB.Delete_Trxn_Extn_Detail ');

Line 1607: p_return_status := FND_API.G_RET_STS_ERROR;

1603: END IF;
1604: EXCEPTION
1605: WHEN OTHERS THEN
1606: ar_invoice_utils.debug('exception in AR_INVOICE_API_PUB.Delete_Trxn_Extn_Detail ');
1607: p_return_status := FND_API.G_RET_STS_ERROR;
1608: END Delete_Trxn_Extn_Details;
1609:
1610:
1611: /*===========================================================================+

Line 1629: | fnd_api.compatible_api_call |

1625: | arp_trx_validate.Add_To_Error_List |
1626: | arp_process_header.delete_header |
1627: | arp_util.disable_debug |
1628: | arp_util.enable_debug |
1629: | fnd_api.compatible_api_call |
1630: | fnd_api.g_exc_unexpected_error |
1631: | fnd_api.g_ret_sts_error |
1632: | fnd_api.g_ret_sts_error |
1633: | fnd_api.g_ret_sts_success |

Line 1630: | fnd_api.g_exc_unexpected_error |

1626: | arp_process_header.delete_header |
1627: | arp_util.disable_debug |
1628: | arp_util.enable_debug |
1629: | fnd_api.compatible_api_call |
1630: | fnd_api.g_exc_unexpected_error |
1631: | fnd_api.g_ret_sts_error |
1632: | fnd_api.g_ret_sts_error |
1633: | fnd_api.g_ret_sts_success |
1634: | fnd_api.to_boolean |

Line 1631: | fnd_api.g_ret_sts_error |

1627: | arp_util.disable_debug |
1628: | arp_util.enable_debug |
1629: | fnd_api.compatible_api_call |
1630: | fnd_api.g_exc_unexpected_error |
1631: | fnd_api.g_ret_sts_error |
1632: | fnd_api.g_ret_sts_error |
1633: | fnd_api.g_ret_sts_success |
1634: | fnd_api.to_boolean |
1635: | fnd_msg_pub.check_msg_level |

Line 1632: | fnd_api.g_ret_sts_error |

1628: | arp_util.enable_debug |
1629: | fnd_api.compatible_api_call |
1630: | fnd_api.g_exc_unexpected_error |
1631: | fnd_api.g_ret_sts_error |
1632: | fnd_api.g_ret_sts_error |
1633: | fnd_api.g_ret_sts_success |
1634: | fnd_api.to_boolean |
1635: | fnd_msg_pub.check_msg_level |
1636: | fnd_msg_pub.count_and_get |

Line 1633: | fnd_api.g_ret_sts_success |

1629: | fnd_api.compatible_api_call |
1630: | fnd_api.g_exc_unexpected_error |
1631: | fnd_api.g_ret_sts_error |
1632: | fnd_api.g_ret_sts_error |
1633: | fnd_api.g_ret_sts_success |
1634: | fnd_api.to_boolean |
1635: | fnd_msg_pub.check_msg_level |
1636: | fnd_msg_pub.count_and_get |
1637: | fnd_msg_pub.initialize |

Line 1634: | fnd_api.to_boolean |

1630: | fnd_api.g_exc_unexpected_error |
1631: | fnd_api.g_ret_sts_error |
1632: | fnd_api.g_ret_sts_error |
1633: | fnd_api.g_ret_sts_success |
1634: | fnd_api.to_boolean |
1635: | fnd_msg_pub.check_msg_level |
1636: | fnd_msg_pub.count_and_get |
1637: | fnd_msg_pub.initialize |
1638: | |

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

1661:
1662: PROCEDURE Delete_Transaction(
1663: p_api_name IN varchar2,
1664: p_api_version IN number,
1665: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1666: p_commit IN varchar2 := FND_API.G_FALSE,
1667: p_validation_level IN varchar2 := FND_API.G_VALID_LEVEL_FULL,
1668: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1669: p_return_status OUT NOCOPY varchar2,

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

1662: PROCEDURE Delete_Transaction(
1663: p_api_name IN varchar2,
1664: p_api_version IN number,
1665: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1666: p_commit IN varchar2 := FND_API.G_FALSE,
1667: p_validation_level IN varchar2 := FND_API.G_VALID_LEVEL_FULL,
1668: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1669: p_return_status OUT NOCOPY varchar2,
1670: p_msg_count IN OUT NOCOPY NUMBER,

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

1663: p_api_name IN varchar2,
1664: p_api_version IN number,
1665: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1666: p_commit IN varchar2 := FND_API.G_FALSE,
1667: p_validation_level IN varchar2 := FND_API.G_VALID_LEVEL_FULL,
1668: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1669: p_return_status OUT NOCOPY varchar2,
1670: p_msg_count IN OUT NOCOPY NUMBER,
1671: p_msg_data IN OUT NOCOPY varchar2,

Line 1713: IF NOT FND_API.Compatible_API_Call(

1709: /*--------------------------------------------------+
1710: | Standard call to check for call compatibility |
1711: +--------------------------------------------------*/
1712:
1713: IF NOT FND_API.Compatible_API_Call(
1714: l_api_version,
1715: p_api_version,
1716: l_api_name,
1717: G_PKG_NAME

Line 1720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1716: l_api_name,
1717: G_PKG_NAME
1718: )
1719: THEN
1720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1721: END IF;
1722:
1723: /*--------------------------------------------------------------+
1724: | Initialize message list if p_init_msg_list is set to TRUE |

Line 1727: IF FND_API.to_Boolean( p_init_msg_list )

1723: /*--------------------------------------------------------------+
1724: | Initialize message list if p_init_msg_list is set to TRUE |
1725: +--------------------------------------------------------------*/
1726:
1727: IF FND_API.to_Boolean( p_init_msg_list )
1728: THEN
1729: FND_MSG_PUB.initialize;
1730: arp_trx_validate.pg_message_tbl.DELETE;
1731: END IF;

Line 1737: l_return_status := FND_API.G_RET_STS_SUCCESS;

1733: /*-----------------------------------------+
1734: | Initialize return status to SUCCESS |
1735: +-----------------------------------------*/
1736:
1737: l_return_status := FND_API.G_RET_STS_SUCCESS;
1738:
1739: /*---------------------------------------------+
1740: | ========== Start of API Body ========== |
1741: +---------------------------------------------*/

Line 1753: IF ( l_validation_status = FND_API.G_RET_STS_SUCCESS )

1749: l_type_rec,
1750: l_validation_status
1751: );
1752:
1753: IF ( l_validation_status = FND_API.G_RET_STS_SUCCESS )
1754: THEN
1755: IF ( l_trx_rec.complete_flag = 'Y' )
1756: THEN
1757:

Line 1850: l_return_status = FND_API.G_RET_STS_SUCCESS

1846: ar_invoice_utils.debug ('. update_status = ' || l_update_status);
1847: END IF;
1848:
1849: IF (
1850: l_return_status = FND_API.G_RET_STS_SUCCESS
1851: AND l_update_status = 'OK'
1852: )
1853: THEN
1854: IF pg_debug = 'Y'

Line 1864: l_delete_pmt_ext_status := FND_API.G_RET_STS_SUCCESS;

1860: IF l_trx_rec.payment_trxn_extension_id IS NOT NULL THEN
1861: Delete_Trxn_Extn_Details(l_trx_rec,
1862: l_delete_pmt_ext_status);
1863: ELSE
1864: l_delete_pmt_ext_status := FND_API.G_RET_STS_SUCCESS;
1865: END IF;
1866:
1867: IF l_delete_pmt_ext_status = FND_API.G_RET_STS_SUCCESS THEN
1868:

Line 1867: IF l_delete_pmt_ext_status = FND_API.G_RET_STS_SUCCESS THEN

1863: ELSE
1864: l_delete_pmt_ext_status := FND_API.G_RET_STS_SUCCESS;
1865: END IF;
1866:
1867: IF l_delete_pmt_ext_status = FND_API.G_RET_STS_SUCCESS THEN
1868:
1869: arp_process_header.delete_header(
1870: p_api_name,
1871: p_api_version,

Line 1931: OR l_delete_pmt_ext_status <> FND_API.G_RET_STS_SUCCESS

1927: IF (
1928: NVL( arp_trx_validate.pg_message_tbl.COUNT, 0) > 0
1929: OR l_update_status <> 'OK'
1930: OR l_delete_status <> 'OK'
1931: OR l_delete_pmt_ext_status <> FND_API.G_RET_STS_SUCCESS
1932: OR l_return_status <> FND_API.G_RET_STS_SUCCESS
1933: )
1934: THEN
1935:

Line 1932: OR l_return_status <> FND_API.G_RET_STS_SUCCESS

1928: NVL( arp_trx_validate.pg_message_tbl.COUNT, 0) > 0
1929: OR l_update_status <> 'OK'
1930: OR l_delete_status <> 'OK'
1931: OR l_delete_pmt_ext_status <> FND_API.G_RET_STS_SUCCESS
1932: OR l_return_status <> FND_API.G_RET_STS_SUCCESS
1933: )
1934: THEN
1935:
1936: p_errors := arp_trx_validate.pg_message_tbl;

Line 1940: p_return_status := FND_API.G_RET_STS_ERROR ;

1936: p_errors := arp_trx_validate.pg_message_tbl;
1937:
1938: ROLLBACK TO Delete_Transaction_PUB;
1939:
1940: p_return_status := FND_API.G_RET_STS_ERROR ;
1941:
1942: IF pg_debug = 'Y'
1943: THEN
1944: ar_invoice_utils.debug ('Error(s) occurred. Rolling back and setting status to ERROR');

Line 1956: IF FND_API.To_Boolean( p_commit )

1952: /*--------------------------------+
1953: | Standard check of p_commit |
1954: +--------------------------------*/
1955:
1956: IF FND_API.To_Boolean( p_commit )
1957: THEN ar_invoice_utils.debug('committing');
1958: Commit;
1959: END IF;
1960:

Line 1968: p_return_status := FND_API.G_RET_STS_ERROR;

1964: EXCEPTION
1965: WHEN NO_DATA_FOUND THEN
1966:
1967: ROLLBACK TO Delete_Transaction_PUB;
1968: p_return_status := FND_API.G_RET_STS_ERROR;
1969: Display_Parameters;
1970:
1971: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1972: p_data => p_msg_data

Line 1975: WHEN FND_API.G_EXC_ERROR THEN

1971: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1972: p_data => p_msg_data
1973: );
1974:
1975: WHEN FND_API.G_EXC_ERROR THEN
1976: ar_invoice_utils.debug(SQLCODE);
1977: ar_invoice_utils.debug(SQLERRM);
1978:
1979:

Line 1981: p_return_status := FND_API.G_RET_STS_ERROR ;

1977: ar_invoice_utils.debug(SQLERRM);
1978:
1979:
1980: ROLLBACK TO Delete_Transaction_PUB;
1981: p_return_status := FND_API.G_RET_STS_ERROR ;
1982: Display_Parameters;
1983:
1984: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1985: p_data => p_msg_data

Line 1988: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1984: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1985: p_data => p_msg_data
1986: );
1987:
1988: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1989:
1990: ar_invoice_utils.debug(SQLCODE);
1991: ar_invoice_utils.debug(SQLERRM);
1992: ROLLBACK TO Delete_Transaction_PUB;

Line 1993: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1989:
1990: ar_invoice_utils.debug(SQLCODE);
1991: ar_invoice_utils.debug(SQLERRM);
1992: ROLLBACK TO Delete_Transaction_PUB;
1993: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1994: Display_Parameters;
1995:
1996: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1997: p_data => p_msg_data

Line 2015: p_return_status := FND_API.G_RET_STS_ERROR ;

2011: p_errors := arp_trx_validate.pg_message_tbl;
2012:
2013: ROLLBACK TO Delete_Transaction_PUB;
2014:
2015: p_return_status := FND_API.G_RET_STS_ERROR ;
2016:
2017: ar_invoice_utils.debug('Completion validation error(s) occurred. ' ||
2018: 'Rolling back and setting status to ERROR');
2019:

Line 2027: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2023: END IF;
2024:
2025: ROLLBACK TO Delete_Transaction_PUB;
2026:
2027: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2028: Display_Parameters;
2029:
2030: IF FND_MSG_PUB.Check_Msg_Level
2031: THEN

Line 2067: x_return_status := FND_API.G_RET_STS_SUCCESS;

2063: ar_invoice_utils.debug ('Customer_trx_id: ' || p_customer_trx_id);
2064: ar_invoice_utils.debug ('interface_line_attribute6: ' || p_interface_line_attribute6);
2065: END IF;
2066:
2067: x_return_status := FND_API.G_RET_STS_SUCCESS;
2068:
2069: IF p_interface_line_attribute6 IS NULL THEN
2070: BEGIN
2071: SELECT count(1)

Line 2077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2073: FROM RA_CUSTOMER_TRX
2074: WHERE customer_trx_id = p_customer_trx_id;
2075:
2076: IF l_count = 0 THEN
2077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2078: x_msg_data := 'There is no record with this customer_trx_id.';
2079: return;
2080: END IF;
2081:

Line 2095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2091: AND ctt.ACCOUNTING_AFFECT_FLAG = 'Y'
2092: AND ct.customer_trx_id = p_customer_trx_id;
2093: EXCEPTION
2094: WHEN OTHERS THEN
2095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2096: x_msg_data := 'Error in AR_INVOICE_API_PUB.GET_TRXN_LINE_BALANCE: '||sqlerrm;
2097: return;
2098: END;
2099:

Line 2109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2105: WHERE customer_trx_id = p_customer_trx_id
2106: AND INTERFACE_LINE_ATTRIBUTE6 = p_interface_line_attribute6;
2107:
2108: IF l_count = 0 THEN
2109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2110: x_msg_data := 'There is no record with this customer_trx_id and interface_line_attribute6.';
2111: return;
2112: END IF;
2113:

Line 2129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2125: AND ct.customer_trx_id = p_customer_trx_id
2126: and ctl.INTERFACE_LINE_ATTRIBUTE6 = p_interface_line_attribute6;
2127: EXCEPTION
2128: WHEN OTHERS THEN
2129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2130: x_msg_data := 'Error in AR_INVOICE_API_PUB.GET_TRXN_LINE_BALANCE: '||sqlerrm;
2131: return;
2132: END;
2133: END IF;