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

Line 40: x_return_status := fnd_api.g_ret_sts_success;

36: AND sysdate BETWEEN nvl(active_start_date, sysdate - 1)
37: AND nvl(active_end_date, sysdate + 1);
38: BEGIN
39:
40: x_return_status := fnd_api.g_ret_sts_success;
41:
42: debug(' location_type_code : '||p_location_type_code);
43: debug(' location_id : '||p_location_id);
44:

Line 68: RAISE fnd_api.g_exc_error;

64: exit;
65: END LOOP;
66:
67: IF x_fa_location_id is null then
68: RAISE fnd_api.g_exc_error;
69: END IF;
70: EXCEPTION
71: WHEN fnd_api.g_exc_error THEN
72: x_return_status := fnd_api.g_ret_sts_error;

Line 71: WHEN fnd_api.g_exc_error THEN

67: IF x_fa_location_id is null then
68: RAISE fnd_api.g_exc_error;
69: END IF;
70: EXCEPTION
71: WHEN fnd_api.g_exc_error THEN
72: x_return_status := fnd_api.g_ret_sts_error;
73: END get_fa_location_id;
74:
75: PROCEDURE interface_nl_to_pa(

Line 72: x_return_status := fnd_api.g_ret_sts_error;

68: RAISE fnd_api.g_exc_error;
69: END IF;
70: EXCEPTION
71: WHEN fnd_api.g_exc_error THEN
72: x_return_status := fnd_api.g_ret_sts_error;
73: END get_fa_location_id;
74:
75: PROCEDURE interface_nl_to_pa(
76: p_in_srv_pa_attr_rec IN cse_datastructures_pub.proj_itm_insv_pa_attr_rec_type,

Line 82: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

78: x_return_status OUT NOCOPY VARCHAR2,
79: x_error_message OUT NOCOPY VARCHAR2)
80: IS
81: l_api_name CONSTANT VARCHAR2(30) := 'cse_proj_item_in_service_pkg';
82: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
83: l_error_message VARCHAR2(2000);
84: l_msg_count NUMBER;
85: l_msg_data VARCHAR2(2000);
86: l_api_version NUMBER DEFAULT 1.0;

Line 87: l_commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;

83: l_error_message VARCHAR2(2000);
84: l_msg_count NUMBER;
85: l_msg_data VARCHAR2(2000);
86: l_api_version NUMBER DEFAULT 1.0;
87: l_commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
88: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_TRUE;
89: l_validation_level NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL;
90: l_active_instance_only VARCHAR2(1) DEFAULT FND_API.G_TRUE;
91: l_txn_rec csi_datastructures_pub.transaction_rec;

Line 88: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_TRUE;

84: l_msg_count NUMBER;
85: l_msg_data VARCHAR2(2000);
86: l_api_version NUMBER DEFAULT 1.0;
87: l_commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
88: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_TRUE;
89: l_validation_level NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL;
90: l_active_instance_only VARCHAR2(1) DEFAULT FND_API.G_TRUE;
91: l_txn_rec csi_datastructures_pub.transaction_rec;
92: l_asset_location_rec csi_datastructures_pub.instance_asset_location_rec;

Line 89: l_validation_level NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL;

85: l_msg_data VARCHAR2(2000);
86: l_api_version NUMBER DEFAULT 1.0;
87: l_commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
88: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_TRUE;
89: l_validation_level NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL;
90: l_active_instance_only VARCHAR2(1) DEFAULT FND_API.G_TRUE;
91: l_txn_rec csi_datastructures_pub.transaction_rec;
92: l_asset_location_rec csi_datastructures_pub.instance_asset_location_rec;
93: l_asset_location_tbl csi_datastructures_pub.instance_asset_location_tbl;

Line 90: l_active_instance_only VARCHAR2(1) DEFAULT FND_API.G_TRUE;

86: l_api_version NUMBER DEFAULT 1.0;
87: l_commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
88: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_TRUE;
89: l_validation_level NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL;
90: l_active_instance_only VARCHAR2(1) DEFAULT FND_API.G_TRUE;
91: l_txn_rec csi_datastructures_pub.transaction_rec;
92: l_asset_location_rec csi_datastructures_pub.instance_asset_location_rec;
93: l_asset_location_tbl csi_datastructures_pub.instance_asset_location_tbl;
94: l_nl_pa_interface_tbl CSE_IPA_TRANS_PKG.nl_pa_interface_tbl_type;

Line 287: x_return_status := FND_API.G_RET_STS_SUCCESS;

283: x_nl_pa_interface_rec.document_distribution_type := p_ei_rec.document_distribution_type;
284: END reversal_exp_item;
285:
286: BEGIN
287: x_return_status := FND_API.G_RET_STS_SUCCESS;
288: x_error_message := NULL;
289:
290: cse_util_pkg.set_debug;
291:

Line 342: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

338: p_location_id => l_location_id,
339: x_fa_location_id => l_fa_location_id,
340: x_return_status => l_return_status);
341:
342: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
343: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
344: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');
345: fnd_message.set_token('CSI_TRANSACTION_ID',p_in_srv_pa_attr_rec.transaction_id);
346: l_error_message := fnd_message.get;

Line 347: RAISE fnd_api.g_exc_error;

343: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
344: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');
345: fnd_message.set_token('CSI_TRANSACTION_ID',p_in_srv_pa_attr_rec.transaction_id);
346: l_error_message := fnd_message.get;
347: RAISE fnd_api.g_exc_error;
348: END IF;
349:
350: debug(' fa_location_id : '||l_fa_location_id);
351:

Line 371: IF l_return_status <> fnd_api.g_ret_sts_success THEN

367: debug(' attribute8 : '||l_attribute8);
368: debug(' attribute9 : '||l_attribute9);
369: debug(' attribute10 : '||l_attribute10);
370:
371: IF l_return_status <> fnd_api.g_ret_sts_success THEN
372: debug('CSE_IPA_TRANS_PKG.get_grouping_attribute failed : '||l_error_message);
373: RAISE fnd_api.g_exc_error;
374: END IF;
375:

Line 373: RAISE fnd_api.g_exc_error;

369: debug(' attribute10 : '||l_attribute10);
370:
371: IF l_return_status <> fnd_api.g_ret_sts_success THEN
372: debug('CSE_IPA_TRANS_PKG.get_grouping_attribute failed : '||l_error_message);
373: RAISE fnd_api.g_exc_error;
374: END IF;
375:
376: SELECT segment1, org_id -- Bug 6492235, changed to support multiple FA book
377: INTO l_project_number, l_ou_id -- Bug 6492235, changed to support multiple FA book

Line 600: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN

596: p_nl_pa_interface_tbl => l_nl_pa_interface_tbl,
597: x_return_status => l_return_status,
598: x_error_message => l_error_message);
599:
600: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
601: debug('error_ message : '||l_error_message);
602: RAISE fnd_api.g_exc_error;
603: END IF;
604:

Line 602: RAISE fnd_api.g_exc_error;

598: x_error_message => l_error_message);
599:
600: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
601: debug('error_ message : '||l_error_message);
602: RAISE fnd_api.g_exc_error;
603: END IF;
604:
605: --update transaction record with new txn_status_code = 'INTERFACE_TO_PA'
606: l_txn_rec := CSE_UTIL_PKG.init_txn_rec;

Line 627: x_return_status := fnd_api.g_ret_sts_unexp_error;

623: WHEN OTHERS THEN
624: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
625: fnd_message.set_token('ERR_MSG',l_api_name||'='|| SQLERRM);
626: x_error_message := fnd_message.get;
627: x_return_status := fnd_api.g_ret_sts_unexp_error;
628: debug('Inside OTHERS in interface_nl_to_pa : ' ||x_error_message);
629: END;
630: --End Changes for Bug 7354734
631:

Line 645: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

641: x_return_status => l_return_status,
642: x_msg_count => l_msg_count,
643: x_msg_data => l_msg_data);
644:
645: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
646: l_error_message := cse_util_pkg.dump_error_stack ;
647: RAISE fnd_api.g_exc_error;
648: END IF;
649: END IF;

Line 647: RAISE fnd_api.g_exc_error;

643: x_msg_data => l_msg_data);
644:
645: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
646: l_error_message := cse_util_pkg.dump_error_stack ;
647: RAISE fnd_api.g_exc_error;
648: END IF;
649: END IF;
650:
651: EXCEPTION

Line 652: WHEN fnd_api.g_exc_error THEN

648: END IF;
649: END IF;
650:
651: EXCEPTION
652: WHEN fnd_api.g_exc_error THEN
653: x_return_status := l_return_status;
654: x_error_message := l_error_message;
655: debug('error in interface_nl_to_pa : '||x_error_message);
656: WHEN OTHERS THEN

Line 660: x_return_status := fnd_api.g_ret_sts_unexp_error;

656: WHEN OTHERS THEN
657: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
658: fnd_message.set_token('ERR_MSG',l_api_name||'='|| SQLERRM);
659: x_error_message := fnd_message.get;
660: x_return_status := fnd_api.g_ret_sts_unexp_error;
661: debug('Inside OTHERS in interface_nl_to_pa : ' ||x_error_message);
662: END interface_nl_to_pa;
663:
664: PROCEDURE interface_nl_to_pa(

Line 689: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

685: WHEN OTHERS THEN
686: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
687: fnd_message.set_token('ERR_MSG','CSE_PROJ_ITEM_IN_SRV_PKG.Interface_Nl_To_PA'||'='|| SQLERRM);
688: x_error_message := fnd_message.get;
689: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
690: END interface_nl_to_pa;
691:
692: END cse_proj_item_in_srv_pkg;