DBA Data[Home] [Help]

APPS.CSI_EAM_INTERFACE_GRP dependencies on FND_API

Line 23: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

19: l_message_id number;
20: l_error_code number;
21: l_error_message varchar2(4000);
22: l_bypass_flag varchar2(1);
23: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
24: l_error_rec csi_datastructures_pub.transaction_error_rec;
25: publish_error exception;
26: BEGIN
27:

Line 28: x_return_status := fnd_api.g_ret_sts_success;

24: l_error_rec csi_datastructures_pub.transaction_error_rec;
25: publish_error exception;
26: BEGIN
27:
28: x_return_status := fnd_api.g_ret_sts_success;
29:
30: csi_t_gen_utility_pvt.build_file_name(
31: p_file_segment1 => 'csiinv',
32: p_file_segment2 => 'hook');

Line 77: IF l_return_status <> fnd_api.g_ret_sts_success THEN

73: p_organization_id => p_organization_id,
74: px_trx_error_rec => l_error_rec,
75: x_return_status => l_return_status);
76:
77: IF l_return_status <> fnd_api.g_ret_sts_success THEN
78: RAISE fnd_api.g_exc_error;
79: END IF;
80:
81: END IF;

Line 78: RAISE fnd_api.g_exc_error;

74: px_trx_error_rec => l_error_rec,
75: x_return_status => l_return_status);
76:
77: IF l_return_status <> fnd_api.g_ret_sts_success THEN
78: RAISE fnd_api.g_exc_error;
79: END IF;
80:
81: END IF;
82:

Line 84: WHEN fnd_api.g_exc_error THEN

80:
81: END IF;
82:
83: EXCEPTION
84: WHEN fnd_api.g_exc_error THEN
85: csi_inv_trxs_pkg.log_csi_error(l_error_rec);
86: x_return_status := fnd_api.g_ret_sts_success;
87: WHEN publish_error THEN
88: csi_inv_trxs_pkg.log_csi_error(l_error_rec);

Line 86: x_return_status := fnd_api.g_ret_sts_success;

82:
83: EXCEPTION
84: WHEN fnd_api.g_exc_error THEN
85: csi_inv_trxs_pkg.log_csi_error(l_error_rec);
86: x_return_status := fnd_api.g_ret_sts_success;
87: WHEN publish_error THEN
88: csi_inv_trxs_pkg.log_csi_error(l_error_rec);
89: x_return_status := fnd_api.g_ret_sts_success;
90: END wip_completion;

Line 89: x_return_status := fnd_api.g_ret_sts_success;

85: csi_inv_trxs_pkg.log_csi_error(l_error_rec);
86: x_return_status := fnd_api.g_ret_sts_success;
87: WHEN publish_error THEN
88: csi_inv_trxs_pkg.log_csi_error(l_error_rec);
89: x_return_status := fnd_api.g_ret_sts_success;
90: END wip_completion;
91:
92:
93: PROCEDURE rebuildable_return(

Line 105: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

101: l_error_code number;
102: l_error_message varchar2(4000);
103: l_inventory_item_id number;
104: l_bypass_flag varchar2(1);
105: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
106: l_error_rec csi_datastructures_pub.transaction_error_rec;
107: publish_error exception;
108: BEGIN
109:

Line 110: x_return_status := fnd_api.g_ret_sts_success;

106: l_error_rec csi_datastructures_pub.transaction_error_rec;
107: publish_error exception;
108: BEGIN
109:
110: x_return_status := fnd_api.g_ret_sts_success;
111:
112: csi_t_gen_utility_pvt.build_file_name(
113: p_file_segment1 => 'csiinv',
114: p_file_segment2 => 'hook');

Line 162: IF l_return_status <> fnd_api.g_ret_sts_success THEN

158: p_instance_id => p_instance_id,
159: px_trx_error_rec => l_error_rec,
160: x_return_status => l_return_status);
161:
162: IF l_return_status <> fnd_api.g_ret_sts_success THEN
163: RAISE fnd_api.g_exc_error;
164: END IF;
165:
166: END IF;

Line 163: RAISE fnd_api.g_exc_error;

159: px_trx_error_rec => l_error_rec,
160: x_return_status => l_return_status);
161:
162: IF l_return_status <> fnd_api.g_ret_sts_success THEN
163: RAISE fnd_api.g_exc_error;
164: END IF;
165:
166: END IF;
167:

Line 169: WHEN fnd_api.g_exc_error THEN

165:
166: END IF;
167:
168: EXCEPTION
169: WHEN fnd_api.g_exc_error THEN
170: csi_inv_trxs_pkg.log_csi_error(l_error_rec);
171: x_return_status := fnd_api.g_ret_sts_success;
172: WHEN publish_error THEN
173: csi_inv_trxs_pkg.log_csi_error(l_error_rec);

Line 171: x_return_status := fnd_api.g_ret_sts_success;

167:
168: EXCEPTION
169: WHEN fnd_api.g_exc_error THEN
170: csi_inv_trxs_pkg.log_csi_error(l_error_rec);
171: x_return_status := fnd_api.g_ret_sts_success;
172: WHEN publish_error THEN
173: csi_inv_trxs_pkg.log_csi_error(l_error_rec);
174: x_return_status := fnd_api.g_ret_sts_success;
175: END rebuildable_return;

Line 174: x_return_status := fnd_api.g_ret_sts_success;

170: csi_inv_trxs_pkg.log_csi_error(l_error_rec);
171: x_return_status := fnd_api.g_ret_sts_success;
172: WHEN publish_error THEN
173: csi_inv_trxs_pkg.log_csi_error(l_error_rec);
174: x_return_status := fnd_api.g_ret_sts_success;
175: END rebuildable_return;
176:
177: END csi_eam_interface_grp;