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.

[Home] [Help]

APPS.CSTPACDP dependencies on FND_API

Line 620: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

616:
617: IF (l_debug = 'Y' ) THEN
618: FND_FILE.put_line( FND_FILE.log, 'Encumbrance Amount: '||l_enc_amount||', Encumbrance Account: '||l_enc_acct );
619: END IF;
620: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
622: END IF;
623: /* Create the encumbrance for this transaction against the receipt
624: organization */

Line 621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

617: IF (l_debug = 'Y' ) THEN
618: FND_FILE.put_line( FND_FILE.log, 'Encumbrance Amount: '||l_enc_amount||', Encumbrance Account: '||l_enc_acct );
619: END IF;
620: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
622: END IF;
623: /* Create the encumbrance for this transaction against the receipt
624: organization */
625: CSTPACDP.encumbrance_account(i_org_id, i_txn_id, l_item_id,

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

1891: p_transaction_date => i_txn_date,
1892: p_cost_group_id => i_cost_grp_id,
1893: p_quantity => (-1*i_p_qty)); -- track issue quantities as positive values
1894:
1895: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1896: l_err_num := -1;
1897: FND_MSG_PUB.count_and_get
1898: ( p_count => l_msg_count,
1899: p_data => l_msg_data,

Line 1900: p_encoded => FND_API.g_false

1896: l_err_num := -1;
1897: FND_MSG_PUB.count_and_get
1898: ( p_count => l_msg_count,
1899: p_data => l_msg_data,
1900: p_encoded => FND_API.g_false
1901: );
1902: IF (l_msg_count = 1) THEN
1903: l_err_msg := substr(l_msg_data,1,240);
1904: ELSE

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

2073: p_req_id => i_req_id,
2074: p_prg_appl_id => i_prg_appl_id,
2075: p_prg_id => i_prg_id);
2076:
2077: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2078: l_err_num := -1;
2079: IF (l_msg_count = 1) THEN
2080: l_err_msg := substr(l_msg_data,1,240);
2081: ELSE

Line 2394: l_return_status := fnd_api.g_ret_sts_success;

2390: l_intransit := 0;
2391: l_subinv := i_subinv;
2392:
2393: l_earn_moh := 1;
2394: l_return_status := fnd_api.g_ret_sts_success;
2395: l_msg_count := 0;
2396:
2397:
2398: fnd_file.put_line(fnd_file.log,'interorg_cost_txn(..)');

Line 3570: IF l_return_status <> FND_API.g_ret_sts_success

3566: x_return_status => l_return_status,
3567: x_msg_count => l_msg_count,
3568: x_msg_data => l_msg_data);
3569:
3570: IF l_return_status <> FND_API.g_ret_sts_success
3571: THEN
3572: CST_UTILITY_PUB.writelogmessages
3573: ( p_api_version => 1.0,
3574: p_msg_count => l_msg_count,

Line 3839: IF l_return_status <> FND_API.g_ret_sts_success THEN

3835: x_return_status => l_return_status,
3836: x_msg_count => l_msg_count,
3837: x_msg_data => l_msg_data);
3838:
3839: IF l_return_status <> FND_API.g_ret_sts_success THEN
3840:
3841: CST_UTILITY_PUB.writelogmessages
3842: ( p_api_version => 1.0,
3843: p_msg_count => l_msg_count,

Line 4701: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

4697: l_err_num NUMBER;
4698: l_err_code VARCHAR2(240);
4699: l_err_msg VARCHAR2(240);
4700: l_msg_count NUMBER;
4701: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4702: l_msg_data VARCHAR2(2000);
4703: l_cost_method NUMBER;
4704:
4705: l_def_cogs_acct_id NUMBER; -- Revenue COGS Matching

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

4807: p_prg_appl_id => i_prg_appl_id,
4808: p_prg_id => i_prg_id);
4809:
4810: -- check return status
4811: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4812: l_err_num := -1;
4813: IF (l_msg_count = 1) THEN
4814: l_err_msg := substr(l_msg_data,1,240);
4815: ELSE

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

4888: p_transaction_date => i_txn_date,
4889: p_cost_group_id => i_cost_grp_id,
4890: p_quantity => (-1*i_p_qty)); /* track issue quantities as positive values */
4891:
4892: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4893: l_err_num := -1;
4894: FND_MSG_PUB.count_and_get
4895: ( p_count => l_msg_count,
4896: p_data => l_msg_data,

Line 4897: p_encoded => FND_API.g_false

4893: l_err_num := -1;
4894: FND_MSG_PUB.count_and_get
4895: ( p_count => l_msg_count,
4896: p_data => l_msg_data,
4897: p_encoded => FND_API.g_false
4898: );
4899: IF (l_msg_count = 1) THEN
4900: l_err_msg := substr(l_msg_data,1,240);
4901: ELSE

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

4948: p_req_id => i_req_id,
4949: p_prg_appl_id => i_prg_appl_id,
4950: p_prg_id => i_prg_id);
4951:
4952: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4953: l_err_num := -1;
4954: FND_MSG_PUB.count_and_get
4955: ( p_count => l_msg_count,
4956: p_data => l_msg_data,

Line 4957: p_encoded => FND_API.g_false

4953: l_err_num := -1;
4954: FND_MSG_PUB.count_and_get
4955: ( p_count => l_msg_count,
4956: p_data => l_msg_data,
4957: p_encoded => FND_API.g_false
4958: );
4959: IF (l_msg_count = 1) THEN
4960: l_err_msg := substr(l_msg_data,1,240);
4961: ELSE

Line 5872: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

5868: l_cost_method NUMBER;
5869: l_ce_round_cost NUMBER;/* Bug 6030328*/
5870:
5871: l_elemental_cost number_table;
5872: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5873: l_msg_count NUMBER;
5874: l_msg_data VARCHAR2(2000);
5875:
5876: BEGIN

Line 6026: p_init_msg_list => FND_API.G_TRUE,

6022: -- COGS recognition events can use these same unit costs.
6023:
6024: CST_RevenueCogsMatch_PVT.Record_SoIssueCost(
6025: p_api_version => 1.0,
6026: p_init_msg_list => FND_API.G_TRUE,
6027: p_user_id => i_user_id,
6028: p_login_id => i_login_id,
6029: p_request_id => i_req_id,
6030: p_pgm_app_id => i_prg_appl_id,

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

6041: p_unit_overhead_cost => l_elemental_cost(5),
6042: p_unit_cost => l_elemental_cost(1) + l_elemental_cost(2) + l_elemental_cost(3) + l_elemental_cost(4) + l_elemental_cost(5),
6043: p_txn_quantity => i_p_qty);
6044:
6045: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6046: l_err_num := -1;
6047: FND_MSG_PUB.count_and_get
6048: ( p_count => l_msg_count,
6049: p_data => l_msg_data,

Line 6050: p_encoded => FND_API.g_false

6046: l_err_num := -1;
6047: FND_MSG_PUB.count_and_get
6048: ( p_count => l_msg_count,
6049: p_data => l_msg_data,
6050: p_encoded => FND_API.g_false
6051: );
6052: IF (l_msg_count = 1) THEN
6053: l_err_msg := substr(l_msg_data,1,240);
6054: ELSE

Line 7705: IF l_return_status <> FND_API.g_ret_sts_success

7701: x_return_status => l_return_status,
7702: x_msg_count => l_msg_count,
7703: x_msg_data => l_msg_data);
7704:
7705: IF l_return_status <> FND_API.g_ret_sts_success
7706: THEN
7707:
7708: CST_UTILITY_PUB.writelogmessages
7709: ( p_api_version => 1.0,

Line 9411: p_init_msg_list => FND_API.G_FALSE,

9407: l_stmt_num := 960;
9408:
9409: CST_XLA_PVT.Create_INVXLAEvent (
9410: p_api_version => 1.0,
9411: p_init_msg_list => FND_API.G_FALSE,
9412: p_commit => FND_API.G_FALSE,
9413: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9414: x_return_status => l_return_status,
9415: x_msg_count => l_msg_count,

Line 9412: p_commit => FND_API.G_FALSE,

9408:
9409: CST_XLA_PVT.Create_INVXLAEvent (
9410: p_api_version => 1.0,
9411: p_init_msg_list => FND_API.G_FALSE,
9412: p_commit => FND_API.G_FALSE,
9413: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9414: x_return_status => l_return_status,
9415: x_msg_count => l_msg_count,
9416: x_msg_data => l_msg_data,

Line 9413: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

9409: CST_XLA_PVT.Create_INVXLAEvent (
9410: p_api_version => 1.0,
9411: p_init_msg_list => FND_API.G_FALSE,
9412: p_commit => FND_API.G_FALSE,
9413: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9414: x_return_status => l_return_status,
9415: x_msg_count => l_msg_count,
9416: x_msg_data => l_msg_data,
9417: p_trx_info => l_trx_info

Line 9423: RAISE FND_API.g_exc_unexpected_error;

9419: IF l_return_status <> 'S' THEN
9420: o_error_num := -1;
9421: o_error_code := 'Error raising SLA Event for transaction: '||to_char(trans_id);
9422: o_error_message := 'CSTPLCIN.COST_INV_TXN:('||l_stmt_num||'): '||o_error_code;
9423: RAISE FND_API.g_exc_unexpected_error;
9424: END IF;
9425:
9426:
9427: -- }

Line 9467: WHEN FND_API.g_exc_unexpected_error THEN

9463:
9464: l_stmt_num := 1020;
9465: COMMIT;
9466:
9467: WHEN FND_API.g_exc_unexpected_error THEN
9468: rollback;
9469:
9470: UPDATE mtl_material_transactions
9471: SET costed_flag = 'E',