DBA Data[Home] [Help]

APPS.AR_IREC_APPLY_CREDITS dependencies on FND_API

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

1035: x_return_status
1036: );
1037: END IF;
1038:
1039: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1040: AR_IREC_PAYMENTS.write_error_messages(x_msg_data,x_msg_count);
1041: END IF;
1042:
1043: EXCEPTION

Line 1193: x_return_status := FND_API.G_RET_STS_ERROR;

1189: x_msg_count := 0;
1190: x_msg_data := '*';
1191: x_open_invoices_status := 'N';
1192: l_sel_cash_receipt_id := 0;
1193: x_return_status := FND_API.G_RET_STS_ERROR;
1194:
1195: l_procedure_name := '.apply_credits_on_payment';
1196:
1197: SAVEPOINT ARI_APPLY_CREDITS_PMT;

Line 1212: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1208: x_credit_ps_id => x_dup_appln_crdt_psid,
1209: x_debit_ps_id => x_dup_appln_dbt_psid
1210: );
1211:
1212: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1213: IF (x_dup_appln_crdt_psid = 0) THEN
1214: ---------------------------------------------------------------------------
1215: l_debug_info := 'An unexpected error has occurred while finding the credit';
1216: ---------------------------------------------------------------------------

Line 1305: p_init_msg_list => FND_API.G_TRUE,

1301: END IF;
1302:
1303: AR_RECEIPT_API_PUB.apply(
1304: p_api_version => 1.0,
1305: p_init_msg_list => FND_API.G_TRUE,
1306: p_commit => FND_API.G_FALSE,
1307: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1308: x_return_status => l_return_status,
1309: x_msg_count => l_msg_count,

Line 1306: p_commit => FND_API.G_FALSE,

1302:
1303: AR_RECEIPT_API_PUB.apply(
1304: p_api_version => 1.0,
1305: p_init_msg_list => FND_API.G_TRUE,
1306: p_commit => FND_API.G_FALSE,
1307: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1308: x_return_status => l_return_status,
1309: x_msg_count => l_msg_count,
1310: x_msg_data => l_msg_data,

Line 1307: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1303: AR_RECEIPT_API_PUB.apply(
1304: p_api_version => 1.0,
1305: p_init_msg_list => FND_API.G_TRUE,
1306: p_commit => FND_API.G_FALSE,
1307: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1308: x_return_status => l_return_status,
1309: x_msg_count => l_msg_count,
1310: x_msg_data => l_msg_data,
1311: p_cash_receipt_id => l_sel_cash_receipt_id,

Line 1330: p_init_msg_list => FND_API.G_TRUE,

1326: END IF;
1327:
1328: AR_RECEIPT_API_PUB.apply_open_receipt
1329: (p_api_version => 1.0,
1330: p_init_msg_list => FND_API.G_TRUE,
1331: p_commit => FND_API.G_FALSE,
1332: x_return_status => l_return_status,
1333: x_msg_count => l_msg_count,
1334: x_msg_data => l_msg_data,

Line 1331: p_commit => FND_API.G_FALSE,

1327:
1328: AR_RECEIPT_API_PUB.apply_open_receipt
1329: (p_api_version => 1.0,
1330: p_init_msg_list => FND_API.G_TRUE,
1331: p_commit => FND_API.G_FALSE,
1332: x_return_status => l_return_status,
1333: x_msg_count => l_msg_count,
1334: x_msg_data => l_msg_data,
1335: p_cash_receipt_id => l_sel_cash_receipt_id,

Line 1349: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1345:
1346: END IF;
1347:
1348: --Check for errors
1349: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351: x_msg_data := x_msg_data || l_msg_data;
1352: x_msg_count := x_msg_count + l_msg_count;
1353:

Line 1350: x_return_status := FND_API.G_RET_STS_ERROR;

1346: END IF;
1347:
1348: --Check for errors
1349: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351: x_msg_data := x_msg_data || l_msg_data;
1352: x_msg_count := x_msg_count + l_msg_count;
1353:
1354: ROLLBACK TO ARI_APPLY_CREDITS_PMT;

Line 1419: p_init_msg_list => FND_API.G_TRUE,

1415: END IF;
1416:
1417: AR_RECEIPT_API_PUB.apply(
1418: p_api_version => 1.0,
1419: p_init_msg_list => FND_API.G_TRUE,
1420: p_commit => FND_API.G_FALSE,
1421: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1422: x_return_status => l_return_status,
1423: x_msg_count => l_msg_count,

Line 1420: p_commit => FND_API.G_FALSE,

1416:
1417: AR_RECEIPT_API_PUB.apply(
1418: p_api_version => 1.0,
1419: p_init_msg_list => FND_API.G_TRUE,
1420: p_commit => FND_API.G_FALSE,
1421: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1422: x_return_status => l_return_status,
1423: x_msg_count => l_msg_count,
1424: x_msg_data => l_msg_data,

Line 1421: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1417: AR_RECEIPT_API_PUB.apply(
1418: p_api_version => 1.0,
1419: p_init_msg_list => FND_API.G_TRUE,
1420: p_commit => FND_API.G_FALSE,
1421: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1422: x_return_status => l_return_status,
1423: x_msg_count => l_msg_count,
1424: x_msg_data => l_msg_data,
1425: p_cash_receipt_id => l_sel_cash_receipt_id,

Line 1435: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1431: p_called_from => 'IREC'
1432: );
1433:
1434: --Check for errors
1435: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1436: x_return_status := FND_API.G_RET_STS_ERROR;
1437: x_msg_data := x_msg_data || l_msg_data;
1438: x_msg_count := x_msg_count + l_msg_count;
1439:

Line 1436: x_return_status := FND_API.G_RET_STS_ERROR;

1432: );
1433:
1434: --Check for errors
1435: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1436: x_return_status := FND_API.G_RET_STS_ERROR;
1437: x_msg_data := x_msg_data || l_msg_data;
1438: x_msg_count := x_msg_count + l_msg_count;
1439:
1440: ROLLBACK TO ARI_APPLY_CREDITS_PMT;

Line 1455: x_return_status := FND_API.G_RET_STS_SUCCESS;

1451: END IF;
1452:
1453: COMMIT;
1454:
1455: x_return_status := FND_API.G_RET_STS_SUCCESS;
1456:
1457: EXCEPTION
1458: WHEN OTHERS THEN
1459: IF (PG_DEBUG = 'Y') THEN

Line 1609: x_return_status := FND_API.G_RET_STS_ERROR;

1605: BEGIN
1606: x_msg_count := 0;
1607: x_msg_data := '*';
1608: x_open_invoices_status := 'N';
1609: x_return_status := FND_API.G_RET_STS_ERROR;
1610:
1611: l_procedure_name := '.apply_credits_on_credit_memo';
1612: l_debit_application_amount := 0;
1613: l_credit_application_amount:= 0;

Line 1874: p_init_msg_list => FND_API.G_TRUE,

1870: arp_standard.debug(l_debug_info);
1871: END IF;
1872: AR_RECEIPT_API_PUB.apply(
1873: p_api_version => 1.0,
1874: p_init_msg_list => FND_API.G_TRUE,
1875: p_commit => FND_API.G_FALSE,
1876: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1877: x_return_status => l_return_status,
1878: x_msg_count => l_msg_count,

Line 1875: p_commit => FND_API.G_FALSE,

1871: END IF;
1872: AR_RECEIPT_API_PUB.apply(
1873: p_api_version => 1.0,
1874: p_init_msg_list => FND_API.G_TRUE,
1875: p_commit => FND_API.G_FALSE,
1876: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1877: x_return_status => l_return_status,
1878: x_msg_count => l_msg_count,
1879: x_msg_data => l_msg_data,

Line 1876: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1872: AR_RECEIPT_API_PUB.apply(
1873: p_api_version => 1.0,
1874: p_init_msg_list => FND_API.G_TRUE,
1875: p_commit => FND_API.G_FALSE,
1876: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1877: x_return_status => l_return_status,
1878: x_msg_count => l_msg_count,
1879: x_msg_data => l_msg_data,
1880: p_cash_receipt_id => credit_trx_record.cash_receipt_id,

Line 1890: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1886: p_apply_date => trunc(sysdate)
1887: );
1888:
1889: -- Check for error
1890: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1891: x_msg_count := l_msg_count;
1892: x_msg_data := l_msg_data;
1893: ROLLBACK TO ARI_APPLY_CREDITS_CM;
1894: RETURN;

Line 1912: x_return_status := FND_API.G_RET_STS_SUCCESS;

1908: CLOSE debit_transactions;
1909:
1910: COMMIT;
1911:
1912: x_return_status := FND_API.G_RET_STS_SUCCESS;
1913:
1914: EXCEPTION
1915: WHEN OTHERS THEN
1916: IF (PG_DEBUG = 'Y') THEN

Line 2137: x_return_status := FND_API.G_RET_STS_ERROR;

2133: credit_to_apply_record credit_to_apply%ROWTYPE;
2134: duplicate_application_record duplicate_application%ROWTYPE;
2135:
2136: BEGIN
2137: x_return_status := FND_API.G_RET_STS_ERROR;
2138: x_credit_ps_id := 0;
2139: x_debit_ps_id := 0;
2140:
2141: l_procedure_name := '.select_credit_to_apply';

Line 2154: x_return_status := FND_API.G_RET_STS_SUCCESS;

2150: OPEN credit_to_apply(p_currency_code);
2151: FETCH credit_to_apply INTO x_credit_ps_id;
2152:
2153: IF (credit_to_apply%FOUND) THEN
2154: x_return_status := FND_API.G_RET_STS_SUCCESS;
2155: ELSE
2156: ---------------------------------------------------------------------------
2157: l_debug_info := 'Open the cursor to return duplicate application transactions';
2158: ---------------------------------------------------------------------------