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.CSTPAVCP dependencies on FND_API

Line 2572: l_return_status := fnd_api.g_ret_sts_success;

2568:
2569: l_msg_data := NULL;
2570: l_msg_count := 0;
2571:
2572: l_return_status := fnd_api.g_ret_sts_success;
2573:
2574: l_zero_cost_flag := -1;
2575:
2576: IF g_debug = 'Y' THEN

Line 2703: if (l_return_status <> fnd_api.g_ret_sts_success) then

2699: p_txn_id => i_txn_id,
2700: x_zero_cost_flag => l_zero_cost_flag
2701: );
2702:
2703: if (l_return_status <> fnd_api.g_ret_sts_success) then
2704: FND_FILE.put_line(FND_FILE.log, l_msg_data);
2705: l_api_message := 'get_zeroCostIssue_flag returned unexpected error';
2706: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
2707: FND_MESSAGE.set_token('TEXT', l_api_message);

Line 2709: raise fnd_api.g_exc_unexpected_error;

2705: l_api_message := 'get_zeroCostIssue_flag returned unexpected error';
2706: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
2707: FND_MESSAGE.set_token('TEXT', l_api_message);
2708: FND_MSG_pub.add;
2709: raise fnd_api.g_exc_unexpected_error;
2710: end if;
2711:
2712: if (g_debug = 'Y') then
2713: FND_FILE.PUT_LINE(FND_FILE.LOG,'>>>Zero Cost Issue Flag:'|| to_char(l_zero_cost_flag));

Line 2957: l_return_status := fnd_api.g_ret_sts_success;

2953: IF g_debug = 'Y' THEN
2954: fnd_file.put_line(fnd_file.log, 'Apply_Material_Overhead <<<');
2955: END IF;
2956: l_earn_moh := 1;
2957: l_return_status := fnd_api.g_ret_sts_success;
2958: l_msg_count := 0;
2959:
2960: -- Applying material overhead on the sum(actual_cost) in CACD. There should
2961: -- not be any material overhead rows! This check will need to be

Line 2982: IF l_return_status <> FND_API.g_ret_sts_success THEN

2978: x_return_status => l_return_status,
2979: x_msg_count => l_msg_count,
2980: x_msg_data => l_msg_data);
2981:
2982: IF l_return_status <> FND_API.g_ret_sts_success THEN
2983:
2984: CST_UTILITY_PUB.writelogmessages
2985: ( p_api_version => 1.0,
2986: p_msg_count => l_msg_count,

Line 4645: l_return_status := fnd_api.g_ret_sts_success;

4641: IF g_debug = 'Y' THEN
4642: fnd_file.put_line(fnd_file.log, '>>>Inside CSTPAVCP.interorg Interorg');
4643: END IF;
4644: l_earn_moh := 1;
4645: l_return_status := fnd_api.g_ret_sts_success;
4646: l_msg_count := 0;
4647:
4648: l_txfr_std_exp := 0;
4649: l_to_std_exp := 0;

Line 5040: IF l_return_status <> FND_API.g_ret_sts_success THEN

5036: x_return_status => l_return_status,
5037: x_msg_count => l_msg_count,
5038: x_msg_data => l_msg_data);
5039:
5040: IF l_return_status <> FND_API.g_ret_sts_success THEN
5041:
5042: CST_UTILITY_PUB.writelogmessages
5043: ( p_api_version => 1.0,
5044: p_msg_count => l_msg_count,

Line 6730: /p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,/

6726: ----------------------------------------------------------------------------
6727:
6728: PROCEDURE Cost_Acct_Events (
6729: p_api_version IN NUMBER,
6730: /*p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,*/
6731: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6732: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6733: p_debug IN VARCHAR2 ,
6734:

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

6727:
6728: PROCEDURE Cost_Acct_Events (
6729: p_api_version IN NUMBER,
6730: /*p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,*/
6731: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6732: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6733: p_debug IN VARCHAR2 ,
6734:
6735: p_org_id IN NUMBER,

Line 6732: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

6728: PROCEDURE Cost_Acct_Events (
6729: p_api_version IN NUMBER,
6730: /*p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,*/
6731: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6732: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6733: p_debug IN VARCHAR2 ,
6734:
6735: p_org_id IN NUMBER,
6736: p_txn_id IN NUMBER,

Line 6824: IF NOT fnd_api.compatible_api_call (

6820:
6821: -------------------------------------------------------------------------
6822: -- standard call to check for call compatibility
6823: -------------------------------------------------------------------------
6824: IF NOT fnd_api.compatible_api_call (
6825: l_api_version,
6826: p_api_version,
6827: l_api_name,
6828: G_PKG_NAME ) then

Line 6830: RAISE fnd_api.g_exc_unexpected_error;

6826: p_api_version,
6827: l_api_name,
6828: G_PKG_NAME ) then
6829:
6830: RAISE fnd_api.g_exc_unexpected_error;
6831:
6832: END IF;
6833:
6834: -------------------------------------------------------------------------

Line 6848: RAISE FND_API.g_exc_error;

6844:
6845: if (p_parent_id is NULL and p_txn_id is NULL) then
6846: x_err_msg := 'Parent and Transaction Id are both null';
6847:
6848: RAISE FND_API.g_exc_error;
6849:
6850: end if;
6851:
6852: -------------------------------------------------------------------------

Line 6866: RAISE FND_API.g_exc_error;

6862: -------------------------------------------------------------------------
6863:
6864: if (c_mmt_txn_rec.distribution_account_id is NULL) then
6865: l_err_msg := 'No Account exists for txn: ' || c_mmt_txn_rec.transaction_id;
6866: RAISE FND_API.g_exc_error;
6867: end if;
6868:
6869: /* If a physical transaction, then it should be the parent */
6870:

Line 6876: RAISE FND_API.g_exc_error;

6872: nvl(c_mmt_txn_rec.parent_id, -1) <> c_mmt_txn_rec.transaction_id) then
6873: l_err_msg := 'Physical Transaction' ||
6874: c_mmt_txn_rec.transaction_id || 'should be the parent';
6875:
6876: RAISE FND_API.g_exc_error;
6877: end if;
6878:
6879:
6880: -------------------------------------------------------------------------

Line 6956: RAISE FND_API.g_exc_error;

6952: if (l_mctcd_count = 0) then
6953: if (c_mmt_txn_rec.transaction_type_id = 20) then
6954: --Retroactive Price Update
6955: l_err_msg := 'No details in MCTCD: ' || c_mmt_txn_rec.transaction_id;
6956: RAISE FND_API.g_exc_error;
6957: else
6958: if (l_log_in_phy = 1) then
6959: /* This is a logical transaction in the parent physical organization -
6960: that is the Logical Intercompany Shipment in the org where the Physical

Line 6989: raise fnd_api.g_exc_error;

6985: x_err_code => l_err_code,
6986: x_err_msg => l_err_msg);
6987:
6988: if (l_error_num <> 0) then
6989: raise fnd_api.g_exc_error;
6990: end if;
6991: end if;
6992: end if;
6993: else

Line 7003: raise fnd_api.g_exc_error;

6999: c_mmt_txn_rec.cost_group_id,
7000: l_error_num, l_err_code, l_err_msg);
7001: -- check error
7002: if (l_error_num <> 0) then
7003: raise fnd_api.g_exc_error;
7004: end if;
7005:
7006: -- create a layer
7007: if (l_layer_id = 0) then

Line 7017: raise fnd_api.g_exc_error;

7013: c_mmt_txn_rec.transaction_id,
7014: l_error_num, l_err_code, l_err_msg);
7015: -- check error
7016: if (l_layer_id = 0) then
7017: raise fnd_api.g_exc_error;
7018: end if;
7019: end if;
7020: end if;
7021:

Line 7139: raise fnd_api.g_exc_error;

7135: if (l_error_num <> 0 ) then
7136: if (g_debug = 'Y') then
7137: fnd_file.put_line (fnd_file.log, 'Error Calling cost_txn');
7138: end if;
7139: raise fnd_api.g_exc_error;
7140: end if;
7141:
7142: end if; /* c_mmt_txn_rec.logical_transaction = 1 OR c_mmt_txn_rec.transaction_type_id = 20 */
7143:

Line 7159: p_init_msg_list => FND_API.G_FALSE,

7155:
7156: l_stmt_num := 60;
7157: CST_XLA_PVT.Create_INVXLAEvent (
7158: p_api_version => 1.0,
7159: p_init_msg_list => FND_API.G_FALSE,
7160: p_commit => FND_API.G_FALSE,
7161: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
7162: x_return_status => l_return_status,
7163: x_msg_count => l_msg_count,

Line 7160: p_commit => FND_API.G_FALSE,

7156: l_stmt_num := 60;
7157: CST_XLA_PVT.Create_INVXLAEvent (
7158: p_api_version => 1.0,
7159: p_init_msg_list => FND_API.G_FALSE,
7160: p_commit => FND_API.G_FALSE,
7161: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
7162: x_return_status => l_return_status,
7163: x_msg_count => l_msg_count,
7164: x_msg_data => l_msg_data,

Line 7161: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

7157: CST_XLA_PVT.Create_INVXLAEvent (
7158: p_api_version => 1.0,
7159: p_init_msg_list => FND_API.G_FALSE,
7160: p_commit => FND_API.G_FALSE,
7161: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
7162: x_return_status => l_return_status,
7163: x_msg_count => l_msg_count,
7164: x_msg_data => l_msg_data,
7165: p_trx_info => l_trx_info

Line 7170: RAISE FND_API.g_exc_unexpected_error;

7166: );
7167: IF l_return_status <> 'S' THEN
7168: l_error_num := -1;
7169: l_err_code := 'Error raising SLA Event for transaction: '||to_char(c_mmt_txn_rec.transaction_id);
7170: RAISE FND_API.g_exc_unexpected_error;
7171: END IF;
7172:
7173: END LOOP;
7174:

Line 7196: when fnd_api.g_exc_error then

7192: fnd_file.put_line(fnd_file.log, 'Cost_Acct_Events >>>');
7193: END IF;
7194:
7195: EXCEPTION
7196: when fnd_api.g_exc_error then
7197: ROLLBACK ;
7198: x_err_num := -1;
7199: x_err_code := l_err_code;
7200: x_err_msg := 'CSTPAVCP.COST_ACCT_EVENTS:' || '(' || l_stmt_num || '):' ||

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

7302: ----------------------------------------------------------------------------
7303:
7304: PROCEDURE Compute_MCACD_Costs(
7305: p_api_version IN NUMBER,
7306: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7307: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7308: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
7309:
7310: p_org_id IN NUMBER,

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

7303:
7304: PROCEDURE Compute_MCACD_Costs(
7305: p_api_version IN NUMBER,
7306: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7307: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7308: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
7309:
7310: p_org_id IN NUMBER,
7311: p_txn_id IN NUMBER,

Line 7308: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

7304: PROCEDURE Compute_MCACD_Costs(
7305: p_api_version IN NUMBER,
7306: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7307: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7308: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
7309:
7310: p_org_id IN NUMBER,
7311: p_txn_id IN NUMBER,
7312: p_parent_txn_id IN NUMBER,

Line 7363: IF FND_API.to_Boolean(p_init_msg_list) THEN

7359: -------------------------------------------------------------------------
7360: -- Initialize message list if p_init_msg_list is set to TRUE
7361: -------------------------------------------------------------------------
7362:
7363: IF FND_API.to_Boolean(p_init_msg_list) THEN
7364: FND_MSG_PUB.initialize;
7365: END IF;
7366:
7367: -------------------------------------------------------------------------

Line 7617: raise fnd_api.g_exc_error;

7613: p_cost_group_id,
7614: l_error_num, l_err_code, l_err_msg);
7615: -- check error
7616: if (l_error_num <> 0) then
7617: raise fnd_api.g_exc_error;
7618: end if;
7619:
7620: -- create a layer
7621: if (l_layer_id = 0) then

Line 7631: raise fnd_api.g_exc_error;

7627: p_parent_txn_id,
7628: l_error_num, l_err_code, l_err_msg);
7629: -- check error
7630: if (l_layer_id = 0) then
7631: raise fnd_api.g_exc_error;
7632: end if;
7633: end if;
7634:
7635:

Line 7673: raise fnd_api.g_exc_error;

7669: o_err_code => l_err_code,
7670: o_err_msg => l_err_msg);
7671: END IF;
7672: if (l_error_num <> 0) then
7673: raise fnd_api.g_exc_error;
7674: end if;
7675: end if;
7676:
7677: -------------------------------------------------------------------------

Line 7706: raise fnd_api.g_exc_error;

7702: l_error_num,
7703: l_err_code,
7704: l_err_msg);
7705: if (l_error_num <> 0) then
7706: raise fnd_api.g_exc_error;
7707: end if;
7708:
7709: else
7710: l_new_cost := 1;

Line 7737: raise fnd_api.g_exc_error;

7733: l_err_code,
7734: l_err_msg);
7735:
7736: if (l_error_num <> 0) then
7737: raise fnd_api.g_exc_error;
7738: end if;
7739: else
7740:
7741: l_stmt_num := 80;

Line 7764: raise fnd_api.g_exc_error;

7760: l_err_code,
7761: l_err_msg);
7762:
7763: if (l_error_num <> 0) then
7764: raise fnd_api.g_exc_error;
7765: end if;
7766: end if;
7767:
7768: elsif (p_cost_method in (5,6)) then

Line 7801: raise fnd_api.g_exc_error;

7797: l_err_code,
7798: l_err_msg);
7799:
7800: if (l_error_num <> 0) then
7801: raise fnd_api.g_exc_error;
7802: end if;
7803:
7804: l_stmt_num := 50;
7805:

Line 7827: raise fnd_api.g_exc_error;

7823: l_err_msg);
7824:
7825:
7826: if (l_error_num <> 0) then
7827: raise fnd_api.g_exc_error;
7828: end if;
7829: end if;
7830:
7831: l_stmt_num := 100;

Line 7883: when fnd_api.g_exc_error then

7879: END IF;
7880:
7881: EXCEPTION
7882:
7883: when fnd_api.g_exc_error then
7884: x_err_num := -1;
7885: x_err_code := l_err_code;
7886: x_err_msg := 'CSTPAVCP.COMPUTE_MCACD_COSTS:' || '(' || l_stmt_num || '):' ||
7887: l_err_msg;

Line 8437: raise fnd_api.g_exc_error;

8433: l_err_num,
8434: l_err_code,
8435: l_err_msg );
8436: if (l_err_num <> 0) then
8437: raise fnd_api.g_exc_error;
8438: end if;
8439:
8440: -- Create a layer, if necessary
8441: if (l_layer_id = 0) then

Line 8455: raise fnd_api.g_exc_error;

8451: l_err_num,
8452: l_err_code,
8453: l_err_msg );
8454: if (l_err_num <> 0) then
8455: raise fnd_api.g_exc_error;
8456: end if;
8457: end if;
8458: ELSE
8459: l_layer_id := -1;

Line 8774: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

8770: x_encumbrance_amount => l_enc_amount,
8771: x_encumbrance_account => l_enc_account,
8772: x_return_status => l_return_status,
8773: x_return_message => l_return_message );
8774: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8776: END IF;
8777: IF ( l_enc_amount <> 0 AND l_enc_account is not null ) THEN
8778: l_stmt_num := 150;

Line 8775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8771: x_encumbrance_account => l_enc_account,
8772: x_return_status => l_return_status,
8773: x_return_message => l_return_message );
8774: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8776: END IF;
8777: IF ( l_enc_amount <> 0 AND l_enc_account is not null ) THEN
8778: l_stmt_num := 150;
8779: CSTPACDP.ENCUMBRANCE_ACCOUNT(

Line 8866: p_init_msg_list => FND_API.G_FALSE,

8862: l_stmt_num := 170;
8863:
8864: CST_XLA_PVT.Create_INVXLAEvent (
8865: p_api_version => 1.0,
8866: p_init_msg_list => FND_API.G_FALSE,
8867: p_commit => FND_API.G_FALSE,
8868: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
8869: x_return_status => l_return_status,
8870: x_msg_count => l_msg_count,

Line 8867: p_commit => FND_API.G_FALSE,

8863:
8864: CST_XLA_PVT.Create_INVXLAEvent (
8865: p_api_version => 1.0,
8866: p_init_msg_list => FND_API.G_FALSE,
8867: p_commit => FND_API.G_FALSE,
8868: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
8869: x_return_status => l_return_status,
8870: x_msg_count => l_msg_count,
8871: x_msg_data => l_msg_data,

Line 8868: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

8864: CST_XLA_PVT.Create_INVXLAEvent (
8865: p_api_version => 1.0,
8866: p_init_msg_list => FND_API.G_FALSE,
8867: p_commit => FND_API.G_FALSE,
8868: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
8869: x_return_status => l_return_status,
8870: x_msg_count => l_msg_count,
8871: x_msg_data => l_msg_data,
8872: p_trx_info => l_trx_info

Line 8884: RAISE FND_API.g_exc_unexpected_error;

8880: IF g_debug = 'Y' THEN
8881: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CSTPAVCP.Cost_LogicalSOReceipt >>>');
8882: END IF;
8883:
8884: RAISE FND_API.g_exc_unexpected_error;
8885: END IF;
8886: /* End bug 5349860 */
8887:
8888: IF g_debug = 'Y' THEN

Line 8916: WHEN FND_API.g_exc_unexpected_error THEN

8912: x_err_msg := l_err_msg;
8913: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_code);
8914: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
8915:
8916: WHEN FND_API.g_exc_unexpected_error THEN
8917: rollback;
8918: UPDATE mtl_material_transactions
8919: SET costed_flag = 'E',
8920: error_code = substrb(x_err_code,1,240),

Line 9044: l_return_status := fnd_api.g_ret_sts_success;

9040: fnd_file.put_line(fnd_file.log, '- Process/Discrete Transfer -');
9041: END IF;
9042:
9043: l_earn_moh := 1;
9044: l_return_status := fnd_api.g_ret_sts_success;
9045: l_msg_count := 0;
9046:
9047: l_txfr_std_exp := 0;
9048: l_to_std_exp := 0;

Line 9398: x_return_status := FND_API.G_RET_STS_SUCCESS;

9394: /* Bug 6405593*/
9395:
9396: BEGIN
9397:
9398: x_return_status := FND_API.G_RET_STS_SUCCESS;
9399:
9400: if g_debug = 'Y' then
9401: fnd_file.put_line(fnd_file.log, 'CompEncumbrance_IntOrdersExp << ');
9402: end if;

Line 9406: IF NOT FND_API.Compatible_API_Call (

9402: end if;
9403:
9404: l_stmt_num := 5;
9405:
9406: IF NOT FND_API.Compatible_API_Call (
9407: l_api_version,
9408: p_api_version,
9409: l_api_name,
9410: G_PKG_NAME ) THEN

Line 9411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9407: l_api_version,
9408: p_api_version,
9409: l_api_name,
9410: G_PKG_NAME ) THEN
9411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9412: END IF;
9413:
9414:
9415:

Line 9460: x_return_status := FND_API.G_RET_STS_ERROR;

9456: item_id => p_item_id,
9457: uom_rate => l_uom_rate );
9458: IF ( l_uom_rate = -99999) THEN
9459: x_return_message := 'Inv_Convert.inv_um_conversion() failed to get the UOM rate';
9460: x_return_status := FND_API.G_RET_STS_ERROR;
9461: RAISE FND_API.G_EXC_ERROR;
9462: END IF;
9463:
9464: l_doc_rcv_qty := p_total_primary_qty * l_uom_rate;

Line 9461: RAISE FND_API.G_EXC_ERROR;

9457: uom_rate => l_uom_rate );
9458: IF ( l_uom_rate = -99999) THEN
9459: x_return_message := 'Inv_Convert.inv_um_conversion() failed to get the UOM rate';
9460: x_return_status := FND_API.G_RET_STS_ERROR;
9461: RAISE FND_API.G_EXC_ERROR;
9462: END IF;
9463:
9464: l_doc_rcv_qty := p_total_primary_qty * l_uom_rate;
9465: l_doc_primary_qty := p_primary_qty * l_uom_rate;

Line 9546: WHEN FND_API.G_EXC_ERROR THEN

9542: fnd_file.put_line(fnd_file.log, 'CompEncumbrance_IntOrdersExp >>');
9543: end if;
9544:
9545: EXCEPTION
9546: WHEN FND_API.G_EXC_ERROR THEN
9547: x_return_status := fnd_api.g_ret_sts_error;
9548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9549: x_return_status := fnd_api.g_ret_sts_unexp_error;
9550: WHEN process_error THEN

Line 9547: x_return_status := fnd_api.g_ret_sts_error;

9543: end if;
9544:
9545: EXCEPTION
9546: WHEN FND_API.G_EXC_ERROR THEN
9547: x_return_status := fnd_api.g_ret_sts_error;
9548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9549: x_return_status := fnd_api.g_ret_sts_unexp_error;
9550: WHEN process_error THEN
9551: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 9548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9544:
9545: EXCEPTION
9546: WHEN FND_API.G_EXC_ERROR THEN
9547: x_return_status := fnd_api.g_ret_sts_error;
9548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9549: x_return_status := fnd_api.g_ret_sts_unexp_error;
9550: WHEN process_error THEN
9551: x_return_status := fnd_api.g_ret_sts_unexp_error;
9552: x_return_message := 'Error in CSTPAVCP.CompEncumbrance_IntOrdersExp('||l_stmt_num||')';

Line 9549: x_return_status := fnd_api.g_ret_sts_unexp_error;

9545: EXCEPTION
9546: WHEN FND_API.G_EXC_ERROR THEN
9547: x_return_status := fnd_api.g_ret_sts_error;
9548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9549: x_return_status := fnd_api.g_ret_sts_unexp_error;
9550: WHEN process_error THEN
9551: x_return_status := fnd_api.g_ret_sts_unexp_error;
9552: x_return_message := 'Error in CSTPAVCP.CompEncumbrance_IntOrdersExp('||l_stmt_num||')';
9553: WHEN OTHERS THEN

Line 9551: x_return_status := fnd_api.g_ret_sts_unexp_error;

9547: x_return_status := fnd_api.g_ret_sts_error;
9548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9549: x_return_status := fnd_api.g_ret_sts_unexp_error;
9550: WHEN process_error THEN
9551: x_return_status := fnd_api.g_ret_sts_unexp_error;
9552: x_return_message := 'Error in CSTPAVCP.CompEncumbrance_IntOrdersExp('||l_stmt_num||')';
9553: WHEN OTHERS THEN
9554: x_return_status := fnd_api.g_ret_sts_unexp_error;
9555: x_return_message := 'Error in CST_UTIL_PUB.CompEncumbrance_IntOrdersExp('||l_stmt_num||')';

Line 9554: x_return_status := fnd_api.g_ret_sts_unexp_error;

9550: WHEN process_error THEN
9551: x_return_status := fnd_api.g_ret_sts_unexp_error;
9552: x_return_message := 'Error in CSTPAVCP.CompEncumbrance_IntOrdersExp('||l_stmt_num||')';
9553: WHEN OTHERS THEN
9554: x_return_status := fnd_api.g_ret_sts_unexp_error;
9555: x_return_message := 'Error in CST_UTIL_PUB.CompEncumbrance_IntOrdersExp('||l_stmt_num||')';
9556:
9557: END CompEncumbrance_IntOrdersExp;
9558:

Line 9587: x_return_status := FND_API.G_RET_STS_SUCCESS;

9583: l_api_version NUMBER := 1.0;
9584:
9585: BEGIN
9586:
9587: x_return_status := FND_API.G_RET_STS_SUCCESS;
9588:
9589: if g_debug = 'Y' then
9590: fnd_file.put_line(fnd_file.log, 'CompEncumbrance_IntOrdersExp (T) <<');
9591: end if;

Line 9594: IF NOT FND_API.Compatible_API_Call (

9590: fnd_file.put_line(fnd_file.log, 'CompEncumbrance_IntOrdersExp (T) <<');
9591: end if;
9592: l_stmt_num := 5;
9593:
9594: IF NOT FND_API.Compatible_API_Call (
9595: l_api_version,
9596: p_api_version,
9597: l_api_name,
9598: G_PKG_NAME ) THEN

Line 9599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9595: l_api_version,
9596: p_api_version,
9597: l_api_name,
9598: G_PKG_NAME ) THEN
9599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9600: END IF;
9601:
9602: l_stmt_num := 10;
9603:

Line 9726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9722: fnd_file.put_line(fnd_file.log, 'CompEncumbrance_IntOrdersExp (T) >>');
9723: end if;
9724:
9725: EXCEPTION
9726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9727: x_return_status := fnd_api.g_ret_sts_unexp_error;
9728: x_return_message := 'Error in CST_UTIL_PUB.CompEncumbrance_IntOrdersExp('||l_stmt_num||')';
9729: WHEN OTHERS THEN
9730: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 9727: x_return_status := fnd_api.g_ret_sts_unexp_error;

9723: end if;
9724:
9725: EXCEPTION
9726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9727: x_return_status := fnd_api.g_ret_sts_unexp_error;
9728: x_return_message := 'Error in CST_UTIL_PUB.CompEncumbrance_IntOrdersExp('||l_stmt_num||')';
9729: WHEN OTHERS THEN
9730: x_return_status := fnd_api.g_ret_sts_unexp_error;
9731: x_return_message := 'Error in CST_UTIL_PUB.CompEncumbrance_IntOrdersExp('||l_stmt_num||')';

Line 9730: x_return_status := fnd_api.g_ret_sts_unexp_error;

9726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9727: x_return_status := fnd_api.g_ret_sts_unexp_error;
9728: x_return_message := 'Error in CST_UTIL_PUB.CompEncumbrance_IntOrdersExp('||l_stmt_num||')';
9729: WHEN OTHERS THEN
9730: x_return_status := fnd_api.g_ret_sts_unexp_error;
9731: x_return_message := 'Error in CST_UTIL_PUB.CompEncumbrance_IntOrdersExp('||l_stmt_num||')';
9732:
9733:
9734: END CompEncumbrance_IntOrdersExp;