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 2405: l_return_status := fnd_api.g_ret_sts_success;

2401:
2402: l_msg_data := NULL;
2403: l_msg_count := 0;
2404:
2405: l_return_status := fnd_api.g_ret_sts_success;
2406:
2407: l_zero_cost_flag := -1;
2408:
2409: IF g_debug = 'Y' THEN

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

2532: p_txn_id => i_txn_id,
2533: x_zero_cost_flag => l_zero_cost_flag
2534: );
2535:
2536: if (l_return_status <> fnd_api.g_ret_sts_success) then
2537: FND_FILE.put_line(FND_FILE.log, l_msg_data);
2538: l_api_message := 'get_zeroCostIssue_flag returned unexpected error';
2539: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
2540: FND_MESSAGE.set_token('TEXT', l_api_message);

Line 2542: raise fnd_api.g_exc_unexpected_error;

2538: l_api_message := 'get_zeroCostIssue_flag returned unexpected error';
2539: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
2540: FND_MESSAGE.set_token('TEXT', l_api_message);
2541: FND_MSG_pub.add;
2542: raise fnd_api.g_exc_unexpected_error;
2543: end if;
2544:
2545: if (g_debug = 'Y') then
2546: FND_FILE.PUT_LINE(FND_FILE.LOG,'>>>Zero Cost Issue Flag:'|| to_char(l_zero_cost_flag));

Line 2790: l_return_status := fnd_api.g_ret_sts_success;

2786: IF g_debug = 'Y' THEN
2787: fnd_file.put_line(fnd_file.log, 'Apply_Material_Overhead <<<');
2788: END IF;
2789: l_earn_moh := 1;
2790: l_return_status := fnd_api.g_ret_sts_success;
2791: l_msg_count := 0;
2792:
2793: -- Applying material overhead on the sum(actual_cost) in CACD. There should
2794: -- not be any material overhead rows! This check will need to be

Line 2815: IF l_return_status <> FND_API.g_ret_sts_success THEN

2811: x_return_status => l_return_status,
2812: x_msg_count => l_msg_count,
2813: x_msg_data => l_msg_data);
2814:
2815: IF l_return_status <> FND_API.g_ret_sts_success THEN
2816:
2817: CST_UTILITY_PUB.writelogmessages
2818: ( p_api_version => 1.0,
2819: p_msg_count => l_msg_count,

Line 4470: l_return_status := fnd_api.g_ret_sts_success;

4466: IF g_debug = 'Y' THEN
4467: fnd_file.put_line(fnd_file.log, '>>>Inside CSTPAVCP.interorg Interorg');
4468: END IF;
4469: l_earn_moh := 1;
4470: l_return_status := fnd_api.g_ret_sts_success;
4471: l_msg_count := 0;
4472:
4473: l_txfr_std_exp := 0;
4474: l_to_std_exp := 0;

Line 4865: IF l_return_status <> FND_API.g_ret_sts_success THEN

4861: x_return_status => l_return_status,
4862: x_msg_count => l_msg_count,
4863: x_msg_data => l_msg_data);
4864:
4865: IF l_return_status <> FND_API.g_ret_sts_success THEN
4866:
4867: CST_UTILITY_PUB.writelogmessages
4868: ( p_api_version => 1.0,
4869: p_msg_count => l_msg_count,

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

6533: ----------------------------------------------------------------------------
6534:
6535: PROCEDURE Cost_Acct_Events (
6536: p_api_version IN NUMBER,
6537: /*p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,*/
6538: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6539: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6540: p_debug IN VARCHAR2 ,
6541:

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

6534:
6535: PROCEDURE Cost_Acct_Events (
6536: p_api_version IN NUMBER,
6537: /*p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,*/
6538: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6539: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6540: p_debug IN VARCHAR2 ,
6541:
6542: p_org_id IN NUMBER,

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

6535: PROCEDURE Cost_Acct_Events (
6536: p_api_version IN NUMBER,
6537: /*p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,*/
6538: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6539: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6540: p_debug IN VARCHAR2 ,
6541:
6542: p_org_id IN NUMBER,
6543: p_txn_id IN NUMBER,

Line 6631: IF NOT fnd_api.compatible_api_call (

6627:
6628: -------------------------------------------------------------------------
6629: -- standard call to check for call compatibility
6630: -------------------------------------------------------------------------
6631: IF NOT fnd_api.compatible_api_call (
6632: l_api_version,
6633: p_api_version,
6634: l_api_name,
6635: G_PKG_NAME ) then

Line 6637: RAISE fnd_api.g_exc_unexpected_error;

6633: p_api_version,
6634: l_api_name,
6635: G_PKG_NAME ) then
6636:
6637: RAISE fnd_api.g_exc_unexpected_error;
6638:
6639: END IF;
6640:
6641: -------------------------------------------------------------------------

Line 6655: RAISE FND_API.g_exc_error;

6651:
6652: if (p_parent_id is NULL and p_txn_id is NULL) then
6653: x_err_msg := 'Parent and Transaction Id are both null';
6654:
6655: RAISE FND_API.g_exc_error;
6656:
6657: end if;
6658:
6659: -------------------------------------------------------------------------

Line 6673: RAISE FND_API.g_exc_error;

6669: -------------------------------------------------------------------------
6670:
6671: if (c_mmt_txn_rec.distribution_account_id is NULL) then
6672: l_err_msg := 'No Account exists for txn: ' || c_mmt_txn_rec.transaction_id;
6673: RAISE FND_API.g_exc_error;
6674: end if;
6675:
6676: /* If a physical transaction, then it should be the parent */
6677:

Line 6683: RAISE FND_API.g_exc_error;

6679: nvl(c_mmt_txn_rec.parent_id, -1) <> c_mmt_txn_rec.transaction_id) then
6680: l_err_msg := 'Physical Transaction' ||
6681: c_mmt_txn_rec.transaction_id || 'should be the parent';
6682:
6683: RAISE FND_API.g_exc_error;
6684: end if;
6685:
6686:
6687: -------------------------------------------------------------------------

Line 6763: RAISE FND_API.g_exc_error;

6759: if (l_mctcd_count = 0) then
6760: if (c_mmt_txn_rec.transaction_type_id = 20) then
6761: --Retroactive Price Update
6762: l_err_msg := 'No details in MCTCD: ' || c_mmt_txn_rec.transaction_id;
6763: RAISE FND_API.g_exc_error;
6764: else
6765: if (l_log_in_phy = 1) then
6766: /* This is a logical transaction in the parent physical organization -
6767: that is the Logical Intercompany Shipment in the org where the Physical

Line 6796: raise fnd_api.g_exc_error;

6792: x_err_code => l_err_code,
6793: x_err_msg => l_err_msg);
6794:
6795: if (l_error_num <> 0) then
6796: raise fnd_api.g_exc_error;
6797: end if;
6798: end if;
6799: end if;
6800: else

Line 6810: raise fnd_api.g_exc_error;

6806: c_mmt_txn_rec.cost_group_id,
6807: l_error_num, l_err_code, l_err_msg);
6808: -- check error
6809: if (l_error_num <> 0) then
6810: raise fnd_api.g_exc_error;
6811: end if;
6812:
6813: -- create a layer
6814: if (l_layer_id = 0) then

Line 6824: raise fnd_api.g_exc_error;

6820: c_mmt_txn_rec.transaction_id,
6821: l_error_num, l_err_code, l_err_msg);
6822: -- check error
6823: if (l_layer_id = 0) then
6824: raise fnd_api.g_exc_error;
6825: end if;
6826: end if;
6827: end if;
6828:

Line 6946: raise fnd_api.g_exc_error;

6942: if (l_error_num <> 0 ) then
6943: if (g_debug = 'Y') then
6944: fnd_file.put_line (fnd_file.log, 'Error Calling cost_txn');
6945: end if;
6946: raise fnd_api.g_exc_error;
6947: end if;
6948:
6949: end if; /* c_mmt_txn_rec.logical_transaction = 1 OR c_mmt_txn_rec.transaction_type_id = 20 */
6950:

Line 6966: p_init_msg_list => FND_API.G_FALSE,

6962:
6963: l_stmt_num := 60;
6964: CST_XLA_PVT.Create_INVXLAEvent (
6965: p_api_version => 1.0,
6966: p_init_msg_list => FND_API.G_FALSE,
6967: p_commit => FND_API.G_FALSE,
6968: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
6969: x_return_status => l_return_status,
6970: x_msg_count => l_msg_count,

Line 6967: p_commit => FND_API.G_FALSE,

6963: l_stmt_num := 60;
6964: CST_XLA_PVT.Create_INVXLAEvent (
6965: p_api_version => 1.0,
6966: p_init_msg_list => FND_API.G_FALSE,
6967: p_commit => FND_API.G_FALSE,
6968: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
6969: x_return_status => l_return_status,
6970: x_msg_count => l_msg_count,
6971: x_msg_data => l_msg_data,

Line 6968: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

6964: CST_XLA_PVT.Create_INVXLAEvent (
6965: p_api_version => 1.0,
6966: p_init_msg_list => FND_API.G_FALSE,
6967: p_commit => FND_API.G_FALSE,
6968: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
6969: x_return_status => l_return_status,
6970: x_msg_count => l_msg_count,
6971: x_msg_data => l_msg_data,
6972: p_trx_info => l_trx_info

Line 6977: RAISE FND_API.g_exc_unexpected_error;

6973: );
6974: IF l_return_status <> 'S' THEN
6975: l_error_num := -1;
6976: l_err_code := 'Error raising SLA Event for transaction: '||to_char(c_mmt_txn_rec.transaction_id);
6977: RAISE FND_API.g_exc_unexpected_error;
6978: END IF;
6979:
6980: END LOOP;
6981:

Line 7003: when fnd_api.g_exc_error then

6999: fnd_file.put_line(fnd_file.log, 'Cost_Acct_Events >>>');
7000: END IF;
7001:
7002: EXCEPTION
7003: when fnd_api.g_exc_error then
7004: x_err_num := -1;
7005: x_err_code := l_err_code;
7006: x_err_msg := 'CSTPAVCP.COST_ACCT_EVENTS:' || '(' || l_stmt_num || '):' ||
7007: l_err_msg || ':' || substr(SQLERRM,1,200);

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

7107: ----------------------------------------------------------------------------
7108:
7109: PROCEDURE Compute_MCACD_Costs(
7110: p_api_version IN NUMBER,
7111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
7114:
7115: p_org_id IN NUMBER,

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

7108:
7109: PROCEDURE Compute_MCACD_Costs(
7110: p_api_version IN NUMBER,
7111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
7114:
7115: p_org_id IN NUMBER,
7116: p_txn_id IN NUMBER,

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

7109: PROCEDURE Compute_MCACD_Costs(
7110: p_api_version IN NUMBER,
7111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
7114:
7115: p_org_id IN NUMBER,
7116: p_txn_id IN NUMBER,
7117: p_parent_txn_id IN NUMBER,

Line 7168: IF FND_API.to_Boolean(p_init_msg_list) THEN

7164: -------------------------------------------------------------------------
7165: -- Initialize message list if p_init_msg_list is set to TRUE
7166: -------------------------------------------------------------------------
7167:
7168: IF FND_API.to_Boolean(p_init_msg_list) THEN
7169: FND_MSG_PUB.initialize;
7170: END IF;
7171:
7172: -------------------------------------------------------------------------

Line 7422: raise fnd_api.g_exc_error;

7418: p_cost_group_id,
7419: l_error_num, l_err_code, l_err_msg);
7420: -- check error
7421: if (l_error_num <> 0) then
7422: raise fnd_api.g_exc_error;
7423: end if;
7424:
7425: -- create a layer
7426: if (l_layer_id = 0) then

Line 7436: raise fnd_api.g_exc_error;

7432: p_parent_txn_id,
7433: l_error_num, l_err_code, l_err_msg);
7434: -- check error
7435: if (l_layer_id = 0) then
7436: raise fnd_api.g_exc_error;
7437: end if;
7438: end if;
7439:
7440:

Line 7478: raise fnd_api.g_exc_error;

7474: o_err_code => l_err_code,
7475: o_err_msg => l_err_msg);
7476: END IF;
7477: if (l_error_num <> 0) then
7478: raise fnd_api.g_exc_error;
7479: end if;
7480: end if;
7481:
7482: -------------------------------------------------------------------------

Line 7511: raise fnd_api.g_exc_error;

7507: l_error_num,
7508: l_err_code,
7509: l_err_msg);
7510: if (l_error_num <> 0) then
7511: raise fnd_api.g_exc_error;
7512: end if;
7513:
7514: else
7515: l_new_cost := 1;

Line 7542: raise fnd_api.g_exc_error;

7538: l_err_code,
7539: l_err_msg);
7540:
7541: if (l_error_num <> 0) then
7542: raise fnd_api.g_exc_error;
7543: end if;
7544: else
7545:
7546: l_stmt_num := 80;

Line 7569: raise fnd_api.g_exc_error;

7565: l_err_code,
7566: l_err_msg);
7567:
7568: if (l_error_num <> 0) then
7569: raise fnd_api.g_exc_error;
7570: end if;
7571: end if;
7572:
7573: elsif (p_cost_method in (5,6)) then

Line 7606: raise fnd_api.g_exc_error;

7602: l_err_code,
7603: l_err_msg);
7604:
7605: if (l_error_num <> 0) then
7606: raise fnd_api.g_exc_error;
7607: end if;
7608:
7609: l_stmt_num := 50;
7610:

Line 7632: raise fnd_api.g_exc_error;

7628: l_err_msg);
7629:
7630:
7631: if (l_error_num <> 0) then
7632: raise fnd_api.g_exc_error;
7633: end if;
7634: end if;
7635:
7636: l_stmt_num := 100;

Line 7688: when fnd_api.g_exc_error then

7684: END IF;
7685:
7686: EXCEPTION
7687:
7688: when fnd_api.g_exc_error then
7689: x_err_num := -1;
7690: x_err_code := l_err_code;
7691: x_err_msg := 'CSTPAVCP.COMPUTE_MCACD_COSTS:' || '(' || l_stmt_num || '):' ||
7692: l_err_msg;

Line 8240: raise fnd_api.g_exc_error;

8236: l_err_num,
8237: l_err_code,
8238: l_err_msg );
8239: if (l_err_num <> 0) then
8240: raise fnd_api.g_exc_error;
8241: end if;
8242:
8243: -- Create a layer, if necessary
8244: if (l_layer_id = 0) then

Line 8258: raise fnd_api.g_exc_error;

8254: l_err_num,
8255: l_err_code,
8256: l_err_msg );
8257: if (l_err_num <> 0) then
8258: raise fnd_api.g_exc_error;
8259: end if;
8260: end if;
8261: ELSE
8262: l_layer_id := -1;

Line 8577: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

8573: x_encumbrance_amount => l_enc_amount,
8574: x_encumbrance_account => l_enc_account,
8575: x_return_status => l_return_status,
8576: x_return_message => l_return_message );
8577: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8579: END IF;
8580: IF ( l_enc_amount <> 0 AND l_enc_account is not null ) THEN
8581: l_stmt_num := 150;

Line 8578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8574: x_encumbrance_account => l_enc_account,
8575: x_return_status => l_return_status,
8576: x_return_message => l_return_message );
8577: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8579: END IF;
8580: IF ( l_enc_amount <> 0 AND l_enc_account is not null ) THEN
8581: l_stmt_num := 150;
8582: CSTPACDP.ENCUMBRANCE_ACCOUNT(

Line 8669: p_init_msg_list => FND_API.G_FALSE,

8665: l_stmt_num := 170;
8666:
8667: CST_XLA_PVT.Create_INVXLAEvent (
8668: p_api_version => 1.0,
8669: p_init_msg_list => FND_API.G_FALSE,
8670: p_commit => FND_API.G_FALSE,
8671: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
8672: x_return_status => l_return_status,
8673: x_msg_count => l_msg_count,

Line 8670: p_commit => FND_API.G_FALSE,

8666:
8667: CST_XLA_PVT.Create_INVXLAEvent (
8668: p_api_version => 1.0,
8669: p_init_msg_list => FND_API.G_FALSE,
8670: p_commit => FND_API.G_FALSE,
8671: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
8672: x_return_status => l_return_status,
8673: x_msg_count => l_msg_count,
8674: x_msg_data => l_msg_data,

Line 8671: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

8667: CST_XLA_PVT.Create_INVXLAEvent (
8668: p_api_version => 1.0,
8669: p_init_msg_list => FND_API.G_FALSE,
8670: p_commit => FND_API.G_FALSE,
8671: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
8672: x_return_status => l_return_status,
8673: x_msg_count => l_msg_count,
8674: x_msg_data => l_msg_data,
8675: p_trx_info => l_trx_info

Line 8687: RAISE FND_API.g_exc_unexpected_error;

8683: IF g_debug = 'Y' THEN
8684: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CSTPAVCP.Cost_LogicalSOReceipt >>>');
8685: END IF;
8686:
8687: RAISE FND_API.g_exc_unexpected_error;
8688: END IF;
8689: /* End bug 5349860 */
8690:
8691: IF g_debug = 'Y' THEN

Line 8719: WHEN FND_API.g_exc_unexpected_error THEN

8715: x_err_msg := l_err_msg;
8716: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_code);
8717: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
8718:
8719: WHEN FND_API.g_exc_unexpected_error THEN
8720: rollback;
8721: UPDATE mtl_material_transactions
8722: SET costed_flag = 'E',
8723: error_code = substrb(x_err_code,1,240),

Line 8847: l_return_status := fnd_api.g_ret_sts_success;

8843: fnd_file.put_line(fnd_file.log, '- Process/Discrete Transfer -');
8844: END IF;
8845:
8846: l_earn_moh := 1;
8847: l_return_status := fnd_api.g_ret_sts_success;
8848: l_msg_count := 0;
8849:
8850: l_txfr_std_exp := 0;
8851: l_to_std_exp := 0;

Line 9201: x_return_status := FND_API.G_RET_STS_SUCCESS;

9197: /* Bug 6405593*/
9198:
9199: BEGIN
9200:
9201: x_return_status := FND_API.G_RET_STS_SUCCESS;
9202:
9203: if g_debug = 'Y' then
9204: fnd_file.put_line(fnd_file.log, 'CompEncumbrance_IntOrdersExp << ');
9205: end if;

Line 9209: IF NOT FND_API.Compatible_API_Call (

9205: end if;
9206:
9207: l_stmt_num := 5;
9208:
9209: IF NOT FND_API.Compatible_API_Call (
9210: l_api_version,
9211: p_api_version,
9212: l_api_name,
9213: G_PKG_NAME ) THEN

Line 9214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9210: l_api_version,
9211: p_api_version,
9212: l_api_name,
9213: G_PKG_NAME ) THEN
9214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9215: END IF;
9216:
9217:
9218:

Line 9263: x_return_status := FND_API.G_RET_STS_ERROR;

9259: item_id => p_item_id,
9260: uom_rate => l_uom_rate );
9261: IF ( l_uom_rate = -99999) THEN
9262: x_return_message := 'Inv_Convert.inv_um_conversion() failed to get the UOM rate';
9263: x_return_status := FND_API.G_RET_STS_ERROR;
9264: RAISE FND_API.G_EXC_ERROR;
9265: END IF;
9266:
9267: l_doc_rcv_qty := p_total_primary_qty * l_uom_rate;

Line 9264: RAISE FND_API.G_EXC_ERROR;

9260: uom_rate => l_uom_rate );
9261: IF ( l_uom_rate = -99999) THEN
9262: x_return_message := 'Inv_Convert.inv_um_conversion() failed to get the UOM rate';
9263: x_return_status := FND_API.G_RET_STS_ERROR;
9264: RAISE FND_API.G_EXC_ERROR;
9265: END IF;
9266:
9267: l_doc_rcv_qty := p_total_primary_qty * l_uom_rate;
9268: l_doc_primary_qty := p_primary_qty * l_uom_rate;

Line 9349: WHEN FND_API.G_EXC_ERROR THEN

9345: fnd_file.put_line(fnd_file.log, 'CompEncumbrance_IntOrdersExp >>');
9346: end if;
9347:
9348: EXCEPTION
9349: WHEN FND_API.G_EXC_ERROR THEN
9350: x_return_status := fnd_api.g_ret_sts_error;
9351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9352: x_return_status := fnd_api.g_ret_sts_unexp_error;
9353: WHEN process_error THEN

Line 9350: x_return_status := fnd_api.g_ret_sts_error;

9346: end if;
9347:
9348: EXCEPTION
9349: WHEN FND_API.G_EXC_ERROR THEN
9350: x_return_status := fnd_api.g_ret_sts_error;
9351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9352: x_return_status := fnd_api.g_ret_sts_unexp_error;
9353: WHEN process_error THEN
9354: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 9351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9347:
9348: EXCEPTION
9349: WHEN FND_API.G_EXC_ERROR THEN
9350: x_return_status := fnd_api.g_ret_sts_error;
9351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9352: x_return_status := fnd_api.g_ret_sts_unexp_error;
9353: WHEN process_error THEN
9354: x_return_status := fnd_api.g_ret_sts_unexp_error;
9355: x_return_message := 'Error in CSTPAVCP.CompEncumbrance_IntOrdersExp('||l_stmt_num||')';

Line 9352: x_return_status := fnd_api.g_ret_sts_unexp_error;

9348: EXCEPTION
9349: WHEN FND_API.G_EXC_ERROR THEN
9350: x_return_status := fnd_api.g_ret_sts_error;
9351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9352: x_return_status := fnd_api.g_ret_sts_unexp_error;
9353: WHEN process_error THEN
9354: x_return_status := fnd_api.g_ret_sts_unexp_error;
9355: x_return_message := 'Error in CSTPAVCP.CompEncumbrance_IntOrdersExp('||l_stmt_num||')';
9356: WHEN OTHERS THEN

Line 9354: x_return_status := fnd_api.g_ret_sts_unexp_error;

9350: x_return_status := fnd_api.g_ret_sts_error;
9351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9352: x_return_status := fnd_api.g_ret_sts_unexp_error;
9353: WHEN process_error THEN
9354: x_return_status := fnd_api.g_ret_sts_unexp_error;
9355: x_return_message := 'Error in CSTPAVCP.CompEncumbrance_IntOrdersExp('||l_stmt_num||')';
9356: WHEN OTHERS THEN
9357: x_return_status := fnd_api.g_ret_sts_unexp_error;
9358: x_return_message := 'Error in CST_UTIL_PUB.CompEncumbrance_IntOrdersExp('||l_stmt_num||')';

Line 9357: x_return_status := fnd_api.g_ret_sts_unexp_error;

9353: WHEN process_error THEN
9354: x_return_status := fnd_api.g_ret_sts_unexp_error;
9355: x_return_message := 'Error in CSTPAVCP.CompEncumbrance_IntOrdersExp('||l_stmt_num||')';
9356: WHEN OTHERS THEN
9357: x_return_status := fnd_api.g_ret_sts_unexp_error;
9358: x_return_message := 'Error in CST_UTIL_PUB.CompEncumbrance_IntOrdersExp('||l_stmt_num||')';
9359:
9360: END CompEncumbrance_IntOrdersExp;
9361:

Line 9390: x_return_status := FND_API.G_RET_STS_SUCCESS;

9386: l_api_version NUMBER := 1.0;
9387:
9388: BEGIN
9389:
9390: x_return_status := FND_API.G_RET_STS_SUCCESS;
9391:
9392: if g_debug = 'Y' then
9393: fnd_file.put_line(fnd_file.log, 'CompEncumbrance_IntOrdersExp (T) <<');
9394: end if;

Line 9397: IF NOT FND_API.Compatible_API_Call (

9393: fnd_file.put_line(fnd_file.log, 'CompEncumbrance_IntOrdersExp (T) <<');
9394: end if;
9395: l_stmt_num := 5;
9396:
9397: IF NOT FND_API.Compatible_API_Call (
9398: l_api_version,
9399: p_api_version,
9400: l_api_name,
9401: G_PKG_NAME ) THEN

Line 9402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9398: l_api_version,
9399: p_api_version,
9400: l_api_name,
9401: G_PKG_NAME ) THEN
9402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9403: END IF;
9404:
9405: l_stmt_num := 10;
9406:

Line 9529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9525: fnd_file.put_line(fnd_file.log, 'CompEncumbrance_IntOrdersExp (T) >>');
9526: end if;
9527:
9528: EXCEPTION
9529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9530: x_return_status := fnd_api.g_ret_sts_unexp_error;
9531: x_return_message := 'Error in CST_UTIL_PUB.CompEncumbrance_IntOrdersExp('||l_stmt_num||')';
9532: WHEN OTHERS THEN
9533: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 9530: x_return_status := fnd_api.g_ret_sts_unexp_error;

9526: end if;
9527:
9528: EXCEPTION
9529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9530: x_return_status := fnd_api.g_ret_sts_unexp_error;
9531: x_return_message := 'Error in CST_UTIL_PUB.CompEncumbrance_IntOrdersExp('||l_stmt_num||')';
9532: WHEN OTHERS THEN
9533: x_return_status := fnd_api.g_ret_sts_unexp_error;
9534: x_return_message := 'Error in CST_UTIL_PUB.CompEncumbrance_IntOrdersExp('||l_stmt_num||')';

Line 9533: x_return_status := fnd_api.g_ret_sts_unexp_error;

9529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9530: x_return_status := fnd_api.g_ret_sts_unexp_error;
9531: x_return_message := 'Error in CST_UTIL_PUB.CompEncumbrance_IntOrdersExp('||l_stmt_num||')';
9532: WHEN OTHERS THEN
9533: x_return_status := fnd_api.g_ret_sts_unexp_error;
9534: x_return_message := 'Error in CST_UTIL_PUB.CompEncumbrance_IntOrdersExp('||l_stmt_num||')';
9535:
9536:
9537: END CompEncumbrance_IntOrdersExp;