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_EBI_INVOICE_PUB dependencies on FND_API

Line 25: x_return_status := FND_API.G_RET_STS_SUCCESS;

21: WHERE name = p_cust_trx_type_name
22: AND org_id = p_org_id;
23:
24: BEGIN
25: x_return_status := FND_API.G_RET_STS_SUCCESS;
26: IF c_cust_trx_types%ISOPEN THEN
27: CLOSE c_cust_trx_types;
28: END IF;
29:

Line 42: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

38: IF c_cust_trx_types%ISOPEN THEN
39: CLOSE c_cust_trx_types;
40: END IF;
41: x_trx_type := NULL;
42: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
43: x_err_msg := SQLERRM ||' at EBI_AR_PKG.ar_get_trx_type ';
44: END ar_get_trx_type;
45:
46: /************************************************************************************

Line 57: , p_run_autoinvoice_cp IN VARCHAR2 := FND_API.g_true

53: PROCEDURE ar_invoice_submission
54: ( p_lines_all IN AR_EBI_RA_INT_LINES_ALL_LIST
55: , p_distributions IN AR_EBI_RA_INT_DIST_LIST
56: , p_salescredits IN AR_EBI_RA_INT_SALESCREDIT_LIST
57: , p_run_autoinvoice_cp IN VARCHAR2 := FND_API.g_true
58: , p_commit IN VARCHAR2 := FND_API.g_false
59: , x_conc_req_ids OUT NOCOPY FND_TABLE_OF_NUMBER
60: , x_err_msg OUT NOCOPY VARCHAR2
61: , x_return_status OUT NOCOPY VARCHAR2

Line 58: , p_commit IN VARCHAR2 := FND_API.g_false

54: ( p_lines_all IN AR_EBI_RA_INT_LINES_ALL_LIST
55: , p_distributions IN AR_EBI_RA_INT_DIST_LIST
56: , p_salescredits IN AR_EBI_RA_INT_SALESCREDIT_LIST
57: , p_run_autoinvoice_cp IN VARCHAR2 := FND_API.g_true
58: , p_commit IN VARCHAR2 := FND_API.g_false
59: , x_conc_req_ids OUT NOCOPY FND_TABLE_OF_NUMBER
60: , x_err_msg OUT NOCOPY VARCHAR2
61: , x_return_status OUT NOCOPY VARCHAR2
62: ) AS

Line 85: x_return_status := FND_API.G_RET_STS_SUCCESS;

81: l_batch_source_id NUMBER(15);
82:
83: l_trx_type VARCHAR2(20);
84: BEGIN
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86:
87: SAVEPOINT ar_ebi_invoice_sub_save_pnt;
88: FND_MSG_PUB.initialize;
89:

Line 447: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

443: x_return_status => x_return_status,
444: x_msg_data => x_err_msg
445: );
446:
447: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
449: END IF;
450:
451: IF(l_bill_to_address_id IS NULL OR l_bill_to_address_id = FND_API.G_MISS_NUM) THEN

Line 448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

444: x_msg_data => x_err_msg
445: );
446:
447: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
449: END IF;
450:
451: IF(l_bill_to_address_id IS NULL OR l_bill_to_address_id = FND_API.G_MISS_NUM) THEN
452: l_bill_to_address_id := l_default_bill_to_address_id;

Line 451: IF(l_bill_to_address_id IS NULL OR l_bill_to_address_id = FND_API.G_MISS_NUM) THEN

447: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
449: END IF;
450:
451: IF(l_bill_to_address_id IS NULL OR l_bill_to_address_id = FND_API.G_MISS_NUM) THEN
452: l_bill_to_address_id := l_default_bill_to_address_id;
453: END IF;
454:
455: IF(l_ship_to_address_id IS NULL OR l_ship_to_address_id = FND_API.G_MISS_NUM) THEN

Line 455: IF(l_ship_to_address_id IS NULL OR l_ship_to_address_id = FND_API.G_MISS_NUM) THEN

451: IF(l_bill_to_address_id IS NULL OR l_bill_to_address_id = FND_API.G_MISS_NUM) THEN
452: l_bill_to_address_id := l_default_bill_to_address_id;
453: END IF;
454:
455: IF(l_ship_to_address_id IS NULL OR l_ship_to_address_id = FND_API.G_MISS_NUM) THEN
456: l_ship_to_address_id := l_default_ship_to_address_id;
457: END IF;
458:
459: IF(l_payment_term_id IS NULL OR l_payment_term_id = FND_API.G_MISS_NUM) THEN

Line 459: IF(l_payment_term_id IS NULL OR l_payment_term_id = FND_API.G_MISS_NUM) THEN

455: IF(l_ship_to_address_id IS NULL OR l_ship_to_address_id = FND_API.G_MISS_NUM) THEN
456: l_ship_to_address_id := l_default_ship_to_address_id;
457: END IF;
458:
459: IF(l_payment_term_id IS NULL OR l_payment_term_id = FND_API.G_MISS_NUM) THEN
460:
461: /* If the Trx name is null no need to default the l_payment_term_id value*/
462: IF(r_lines_all.CUST_TRX_TYPE_NAME IS NOT NULL) THEN
463:

Line 472: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

468: ,x_return_status => x_return_status
469: ,x_err_msg => x_err_msg
470: );
471:
472: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: END IF;
475:
476: /* Trx type is Credit Memo We should not default the values*/

Line 473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

469: ,x_err_msg => x_err_msg
470: );
471:
472: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: END IF;
475:
476: /* Trx type is Credit Memo We should not default the values*/
477: IF(l_trx_type IS NOT NULL AND l_trx_type <> 'CM') THEN

Line 483: IF(l_conversion_type IS NULL OR l_conversion_type = FND_API.G_MISS_CHAR) THEN

479: END IF;
480: END IF;
481: END IF;
482:
483: IF(l_conversion_type IS NULL OR l_conversion_type = FND_API.G_MISS_CHAR) THEN
484: l_conversion_type := l_default_conversion_type;
485: END IF;
486:
487: IF(l_conversion_date IS NULL OR l_conversion_date = FND_API.G_MISS_DATE) THEN

Line 487: IF(l_conversion_date IS NULL OR l_conversion_date = FND_API.G_MISS_DATE) THEN

483: IF(l_conversion_type IS NULL OR l_conversion_type = FND_API.G_MISS_CHAR) THEN
484: l_conversion_type := l_default_conversion_type;
485: END IF;
486:
487: IF(l_conversion_date IS NULL OR l_conversion_date = FND_API.G_MISS_DATE) THEN
488: l_conversion_date := l_default_conversion_date;
489: END IF;
490:
491: IF(l_conversion_rate IS NULL OR l_conversion_rate = FND_API.G_MISS_NUM) THEN

Line 491: IF(l_conversion_rate IS NULL OR l_conversion_rate = FND_API.G_MISS_NUM) THEN

487: IF(l_conversion_date IS NULL OR l_conversion_date = FND_API.G_MISS_DATE) THEN
488: l_conversion_date := l_default_conversion_date;
489: END IF;
490:
491: IF(l_conversion_rate IS NULL OR l_conversion_rate = FND_API.G_MISS_NUM) THEN
492: l_conversion_rate := l_default_conversion_rate;
493: END IF;
494:
495:

Line 1662: IF FND_API.to_boolean(p_run_autoinvoice_cp) THEN

1658: );
1659: END LOOP;
1660:
1661: /* Calling the Auto Invoice Concurrent Program */
1662: IF FND_API.to_boolean(p_run_autoinvoice_cp) THEN
1663: x_conc_req_ids := FND_TABLE_OF_NUMBER();
1664: FOR r_cp_input IN
1665: ( SELECT DISTINCT org_id,
1666: batch_source_name

Line 1690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1686:
1687: IF l_conc_req_id = 0 THEN
1688: FND_MESSAGE.set_name('AR','AR_EBI_CONC_PRO_SUBMIT_FAILED'); /*Concurrent program submission failed!!!!!*/
1689: FND_MSG_PUB.add;
1690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1691: END IF;
1692:
1693: x_conc_req_ids.EXTEND;
1694: x_conc_req_ids(x_conc_req_ids.COUNT) :=l_conc_req_id;

Line 1698: IF FND_API.to_boolean(p_commit) THEN

1694: x_conc_req_ids(x_conc_req_ids.COUNT) :=l_conc_req_id;
1695: END LOOP;
1696: END IF;
1697:
1698: IF FND_API.to_boolean(p_commit) THEN
1699: COMMIT;
1700: END IF;
1701:
1702: EXCEPTION

Line 1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1699: COMMIT;
1700: END IF;
1701:
1702: EXCEPTION
1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1704: x_return_status := FND_API.G_RET_STS_ERROR;
1705: IF (x_err_msg IS NULL) THEN
1706: FND_MSG_PUB.count_and_get(
1707: p_encoded => FND_API.G_FALSE,

Line 1704: x_return_status := FND_API.G_RET_STS_ERROR;

1700: END IF;
1701:
1702: EXCEPTION
1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1704: x_return_status := FND_API.G_RET_STS_ERROR;
1705: IF (x_err_msg IS NULL) THEN
1706: FND_MSG_PUB.count_and_get(
1707: p_encoded => FND_API.G_FALSE,
1708: p_count => l_msg_count,

Line 1707: p_encoded => FND_API.G_FALSE,

1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1704: x_return_status := FND_API.G_RET_STS_ERROR;
1705: IF (x_err_msg IS NULL) THEN
1706: FND_MSG_PUB.count_and_get(
1707: p_encoded => FND_API.G_FALSE,
1708: p_count => l_msg_count,
1709: p_data => x_err_msg
1710: );
1711: END IF;

Line 1715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1711: END IF;
1712: ROLLBACK TO ar_ebi_invoice_sub_save_pnt;
1713:
1714: WHEN OTHERS THEN
1715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1716: x_err_msg := SQLERRM ||' at EBI_AR_PKG.ar_invoice_submission ';
1717: ROLLBACK TO ar_ebi_invoice_sub_save_pnt;
1718:
1719: END ar_invoice_submission;