DBA Data[Home] [Help]

APPS.CSTPACDP dependencies on FND_API

Line 705: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

701:
702: IF (l_debug = 'Y' ) THEN
703: FND_FILE.put_line( FND_FILE.log, 'Encumbrance Amount: '||l_enc_amount||', Encumbrance Account: '||l_enc_acct );
704: END IF;
705: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
707: END IF;
708:
709:

Line 706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

702: IF (l_debug = 'Y' ) THEN
703: FND_FILE.put_line( FND_FILE.log, 'Encumbrance Amount: '||l_enc_amount||', Encumbrance Account: '||l_enc_acct );
704: END IF;
705: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
707: END IF;
708:
709:
710: /* Create the encumbrance for this transaction against the receipt

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

1982: p_transaction_date => i_txn_date,
1983: p_cost_group_id => i_cost_grp_id,
1984: p_quantity => (-1*i_p_qty)); -- track issue quantities as positive values
1985:
1986: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1987: l_err_num := -1;
1988: FND_MSG_PUB.count_and_get
1989: ( p_count => l_msg_count,
1990: p_data => l_msg_data,

Line 1991: p_encoded => FND_API.g_false

1987: l_err_num := -1;
1988: FND_MSG_PUB.count_and_get
1989: ( p_count => l_msg_count,
1990: p_data => l_msg_data,
1991: p_encoded => FND_API.g_false
1992: );
1993: IF (l_msg_count = 1) THEN
1994: l_err_msg := substr(l_msg_data,1,240);
1995: ELSE

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

2164: p_req_id => i_req_id,
2165: p_prg_appl_id => i_prg_appl_id,
2166: p_prg_id => i_prg_id);
2167:
2168: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2169: l_err_num := -1;
2170: IF (l_msg_count = 1) THEN
2171: l_err_msg := substr(l_msg_data,1,240);
2172: ELSE

Line 2485: l_return_status := fnd_api.g_ret_sts_success;

2481: l_intransit := 0;
2482: l_subinv := i_subinv;
2483:
2484: l_earn_moh := 1;
2485: l_return_status := fnd_api.g_ret_sts_success;
2486: l_msg_count := 0;
2487:
2488:
2489: fnd_file.put_line(fnd_file.log,'interorg_cost_txn(..)');

Line 3661: IF l_return_status <> FND_API.g_ret_sts_success

3657: x_return_status => l_return_status,
3658: x_msg_count => l_msg_count,
3659: x_msg_data => l_msg_data);
3660:
3661: IF l_return_status <> FND_API.g_ret_sts_success
3662: THEN
3663: CST_UTILITY_PUB.writelogmessages
3664: ( p_api_version => 1.0,
3665: p_msg_count => l_msg_count,

Line 3930: IF l_return_status <> FND_API.g_ret_sts_success THEN

3926: x_return_status => l_return_status,
3927: x_msg_count => l_msg_count,
3928: x_msg_data => l_msg_data);
3929:
3930: IF l_return_status <> FND_API.g_ret_sts_success THEN
3931:
3932: CST_UTILITY_PUB.writelogmessages
3933: ( p_api_version => 1.0,
3934: p_msg_count => l_msg_count,

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

4788: l_err_num NUMBER;
4789: l_err_code VARCHAR2(240);
4790: l_err_msg VARCHAR2(240);
4791: l_msg_count NUMBER;
4792: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4793: l_msg_data VARCHAR2(2000);
4794: l_cost_method NUMBER;
4795:
4796: l_def_cogs_acct_id NUMBER; -- Revenue COGS Matching

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

4898: p_prg_appl_id => i_prg_appl_id,
4899: p_prg_id => i_prg_id);
4900:
4901: -- check return status
4902: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4903: l_err_num := -1;
4904: IF (l_msg_count = 1) THEN
4905: l_err_msg := substr(l_msg_data,1,240);
4906: ELSE

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

4979: p_transaction_date => i_txn_date,
4980: p_cost_group_id => i_cost_grp_id,
4981: p_quantity => (-1*i_p_qty)); /* track issue quantities as positive values */
4982:
4983: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4984: l_err_num := -1;
4985: FND_MSG_PUB.count_and_get
4986: ( p_count => l_msg_count,
4987: p_data => l_msg_data,

Line 4988: p_encoded => FND_API.g_false

4984: l_err_num := -1;
4985: FND_MSG_PUB.count_and_get
4986: ( p_count => l_msg_count,
4987: p_data => l_msg_data,
4988: p_encoded => FND_API.g_false
4989: );
4990: IF (l_msg_count = 1) THEN
4991: l_err_msg := substr(l_msg_data,1,240);
4992: ELSE

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

5039: p_req_id => i_req_id,
5040: p_prg_appl_id => i_prg_appl_id,
5041: p_prg_id => i_prg_id);
5042:
5043: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5044: l_err_num := -1;
5045: FND_MSG_PUB.count_and_get
5046: ( p_count => l_msg_count,
5047: p_data => l_msg_data,

Line 5048: p_encoded => FND_API.g_false

5044: l_err_num := -1;
5045: FND_MSG_PUB.count_and_get
5046: ( p_count => l_msg_count,
5047: p_data => l_msg_data,
5048: p_encoded => FND_API.g_false
5049: );
5050: IF (l_msg_count = 1) THEN
5051: l_err_msg := substr(l_msg_data,1,240);
5052: ELSE

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

5960: l_cost_method NUMBER;
5961: l_ce_round_cost NUMBER;/* Bug 6030328*/
5962:
5963: l_elemental_cost number_table;
5964: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5965: l_msg_count NUMBER;
5966: l_msg_data VARCHAR2(2000);
5967:
5968: BEGIN

Line 6118: p_init_msg_list => FND_API.G_TRUE,

6114: -- COGS recognition events can use these same unit costs.
6115:
6116: CST_RevenueCogsMatch_PVT.Record_SoIssueCost(
6117: p_api_version => 1.0,
6118: p_init_msg_list => FND_API.G_TRUE,
6119: p_user_id => i_user_id,
6120: p_login_id => i_login_id,
6121: p_request_id => i_req_id,
6122: p_pgm_app_id => i_prg_appl_id,

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

6133: p_unit_overhead_cost => l_elemental_cost(5),
6134: p_unit_cost => l_elemental_cost(1) + l_elemental_cost(2) + l_elemental_cost(3) + l_elemental_cost(4) + l_elemental_cost(5),
6135: p_txn_quantity => i_p_qty);
6136:
6137: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6138: l_err_num := -1;
6139: FND_MSG_PUB.count_and_get
6140: ( p_count => l_msg_count,
6141: p_data => l_msg_data,

Line 6142: p_encoded => FND_API.g_false

6138: l_err_num := -1;
6139: FND_MSG_PUB.count_and_get
6140: ( p_count => l_msg_count,
6141: p_data => l_msg_data,
6142: p_encoded => FND_API.g_false
6143: );
6144: IF (l_msg_count = 1) THEN
6145: l_err_msg := substr(l_msg_data,1,240);
6146: ELSE

Line 7904: IF l_return_status <> FND_API.g_ret_sts_success

7900: x_return_status => l_return_status,
7901: x_msg_count => l_msg_count,
7902: x_msg_data => l_msg_data);
7903:
7904: IF l_return_status <> FND_API.g_ret_sts_success
7905: THEN
7906:
7907: CST_UTILITY_PUB.writelogmessages
7908: ( p_api_version => 1.0,

Line 9610: p_init_msg_list => FND_API.G_FALSE,

9606: l_stmt_num := 960;
9607:
9608: CST_XLA_PVT.Create_INVXLAEvent (
9609: p_api_version => 1.0,
9610: p_init_msg_list => FND_API.G_FALSE,
9611: p_commit => FND_API.G_FALSE,
9612: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9613: x_return_status => l_return_status,
9614: x_msg_count => l_msg_count,

Line 9611: p_commit => FND_API.G_FALSE,

9607:
9608: CST_XLA_PVT.Create_INVXLAEvent (
9609: p_api_version => 1.0,
9610: p_init_msg_list => FND_API.G_FALSE,
9611: p_commit => FND_API.G_FALSE,
9612: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9613: x_return_status => l_return_status,
9614: x_msg_count => l_msg_count,
9615: x_msg_data => l_msg_data,

Line 9612: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

9608: CST_XLA_PVT.Create_INVXLAEvent (
9609: p_api_version => 1.0,
9610: p_init_msg_list => FND_API.G_FALSE,
9611: p_commit => FND_API.G_FALSE,
9612: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9613: x_return_status => l_return_status,
9614: x_msg_count => l_msg_count,
9615: x_msg_data => l_msg_data,
9616: p_trx_info => l_trx_info

Line 9622: RAISE FND_API.g_exc_unexpected_error;

9618: IF l_return_status <> 'S' THEN
9619: o_error_num := -1;
9620: o_error_code := 'Error raising SLA Event for transaction: '||to_char(trans_id);
9621: o_error_message := 'CSTPLCIN.COST_INV_TXN:('||l_stmt_num||'): '||o_error_code;
9622: RAISE FND_API.g_exc_unexpected_error;
9623: END IF;
9624:
9625:
9626: -- }

Line 9666: WHEN FND_API.g_exc_unexpected_error THEN

9662:
9663: l_stmt_num := 1020;
9664: COMMIT;
9665:
9666: WHEN FND_API.g_exc_unexpected_error THEN
9667: rollback;
9668:
9669: UPDATE mtl_material_transactions
9670: SET costed_flag = 'E',