DBA Data[Home] [Help]

APPS.JTF_EBI_PUB dependencies on FND_API

Line 59: x_return_status := FND_API.G_RET_STS_SUCCESS;

55: IS
56: BEGIN
57:
58: FND_MSG_PUB.initialize;
59: x_return_status := FND_API.G_RET_STS_SUCCESS;
60:
61: -- set apps context
62: IF p_user_name IS NOT NULL AND p_responsibility IS NOT NULL
63: THEN

Line 81: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

77: ,x_msg_count => x_msg_count
78: ,x_msg_data => x_msg_data
79: );
80:
81: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
82: RAISE FND_API.g_exc_unexpected_error;
83: END IF;
84:
85: IF( JTF_EBI_UTIL.is_resource_error_exists (p_batch_id => p_batch_id) = FND_API.g_true ) THEN

Line 82: RAISE FND_API.g_exc_unexpected_error;

78: ,x_msg_data => x_msg_data
79: );
80:
81: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
82: RAISE FND_API.g_exc_unexpected_error;
83: END IF;
84:
85: IF( JTF_EBI_UTIL.is_resource_error_exists (p_batch_id => p_batch_id) = FND_API.g_true ) THEN
86: x_return_status := 'P';

Line 85: IF( JTF_EBI_UTIL.is_resource_error_exists (p_batch_id => p_batch_id) = FND_API.g_true ) THEN

81: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
82: RAISE FND_API.g_exc_unexpected_error;
83: END IF;
84:
85: IF( JTF_EBI_UTIL.is_resource_error_exists (p_batch_id => p_batch_id) = FND_API.g_true ) THEN
86: x_return_status := 'P';
87: ELSE
88: x_return_status := FND_API.G_RET_STS_SUCCESS;
89: END IF;

Line 88: x_return_status := FND_API.G_RET_STS_SUCCESS;

84:
85: IF( JTF_EBI_UTIL.is_resource_error_exists (p_batch_id => p_batch_id) = FND_API.g_true ) THEN
86: x_return_status := 'P';
87: ELSE
88: x_return_status := FND_API.G_RET_STS_SUCCESS;
89: END IF;
90:
91: IF p_commit = FND_API.g_true THEN
92: COMMIT;

Line 91: IF p_commit = FND_API.g_true THEN

87: ELSE
88: x_return_status := FND_API.G_RET_STS_SUCCESS;
89: END IF;
90:
91: IF p_commit = FND_API.g_true THEN
92: COMMIT;
93: END IF;
94:
95: EXCEPTION

Line 96: WHEN FND_API.g_exc_unexpected_error THEN

92: COMMIT;
93: END IF;
94:
95: EXCEPTION
96: WHEN FND_API.g_exc_unexpected_error THEN
97: x_return_status := FND_API.g_ret_sts_error;
98: IF(x_msg_data IS NULL) THEN
99: FND_MSG_PUB.count_and_get(
100: p_encoded => FND_API.g_false

Line 97: x_return_status := FND_API.g_ret_sts_error;

93: END IF;
94:
95: EXCEPTION
96: WHEN FND_API.g_exc_unexpected_error THEN
97: x_return_status := FND_API.g_ret_sts_error;
98: IF(x_msg_data IS NULL) THEN
99: FND_MSG_PUB.count_and_get(
100: p_encoded => FND_API.g_false
101: ,p_count => x_msg_count

Line 100: p_encoded => FND_API.g_false

96: WHEN FND_API.g_exc_unexpected_error THEN
97: x_return_status := FND_API.g_ret_sts_error;
98: IF(x_msg_data IS NULL) THEN
99: FND_MSG_PUB.count_and_get(
100: p_encoded => FND_API.g_false
101: ,p_count => x_msg_count
102: ,p_data => x_msg_data
103: );
104: END IF;

Line 106: x_return_status := FND_API.g_ret_sts_unexp_error;

102: ,p_data => x_msg_data
103: );
104: END IF;
105: WHEN OTHERS THEN
106: x_return_status := FND_API.g_ret_sts_unexp_error;
107: x_msg_data := SQLERRM ||' in Package JTF_EBI_PUB Procedure process_resource_intf';
108: END process_resource_intf;
109:
110: PROCEDURE process_salesrep_intf(

Line 136: x_return_status := FND_API.G_RET_STS_SUCCESS;

132: interface_id;
133: BEGIN
134:
135: FND_MSG_PUB.initialize;
136: x_return_status := FND_API.G_RET_STS_SUCCESS;
137:
138: -- set apps context
139: IF p_user_name IS NOT NULL AND p_responsibility IS NOT NULL
140: THEN

Line 176: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

172: ,x_msg_count => x_msg_count
173: ,x_msg_data => x_msg_data
174: );
175:
176: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
177: RAISE FND_API.g_exc_unexpected_error;
178: END IF;
179:
180: IF( JTF_EBI_UTIL.is_salesrep_error_exists (p_batch_id => p_batch_id) = FND_API.g_true ) THEN

Line 177: RAISE FND_API.g_exc_unexpected_error;

173: ,x_msg_data => x_msg_data
174: );
175:
176: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
177: RAISE FND_API.g_exc_unexpected_error;
178: END IF;
179:
180: IF( JTF_EBI_UTIL.is_salesrep_error_exists (p_batch_id => p_batch_id) = FND_API.g_true ) THEN
181: x_return_status := 'P';

Line 180: IF( JTF_EBI_UTIL.is_salesrep_error_exists (p_batch_id => p_batch_id) = FND_API.g_true ) THEN

176: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
177: RAISE FND_API.g_exc_unexpected_error;
178: END IF;
179:
180: IF( JTF_EBI_UTIL.is_salesrep_error_exists (p_batch_id => p_batch_id) = FND_API.g_true ) THEN
181: x_return_status := 'P';
182: ELSE
183: x_return_status := FND_API.G_RET_STS_SUCCESS;
184: END IF;

Line 183: x_return_status := FND_API.G_RET_STS_SUCCESS;

179:
180: IF( JTF_EBI_UTIL.is_salesrep_error_exists (p_batch_id => p_batch_id) = FND_API.g_true ) THEN
181: x_return_status := 'P';
182: ELSE
183: x_return_status := FND_API.G_RET_STS_SUCCESS;
184: END IF;
185:
186: IF p_commit = FND_API.g_true THEN
187: COMMIT;

Line 186: IF p_commit = FND_API.g_true THEN

182: ELSE
183: x_return_status := FND_API.G_RET_STS_SUCCESS;
184: END IF;
185:
186: IF p_commit = FND_API.g_true THEN
187: COMMIT;
188: END IF;
189:
190: EXCEPTION

Line 191: WHEN FND_API.g_exc_unexpected_error THEN

187: COMMIT;
188: END IF;
189:
190: EXCEPTION
191: WHEN FND_API.g_exc_unexpected_error THEN
192: x_return_status := FND_API.g_ret_sts_error;
193: IF(x_msg_data IS NULL) THEN
194: FND_MSG_PUB.count_and_get(
195: p_encoded => FND_API.g_false

Line 192: x_return_status := FND_API.g_ret_sts_error;

188: END IF;
189:
190: EXCEPTION
191: WHEN FND_API.g_exc_unexpected_error THEN
192: x_return_status := FND_API.g_ret_sts_error;
193: IF(x_msg_data IS NULL) THEN
194: FND_MSG_PUB.count_and_get(
195: p_encoded => FND_API.g_false
196: ,p_count => x_msg_count

Line 195: p_encoded => FND_API.g_false

191: WHEN FND_API.g_exc_unexpected_error THEN
192: x_return_status := FND_API.g_ret_sts_error;
193: IF(x_msg_data IS NULL) THEN
194: FND_MSG_PUB.count_and_get(
195: p_encoded => FND_API.g_false
196: ,p_count => x_msg_count
197: ,p_data => x_msg_data
198: );
199: END IF;

Line 201: x_return_status := FND_API.g_ret_sts_unexp_error;

197: ,p_data => x_msg_data
198: );
199: END IF;
200: WHEN OTHERS THEN
201: x_return_status := FND_API.g_ret_sts_unexp_error;
202: x_msg_data := SQLERRM ||' in Package JTF_EBI_PUB Procedure process_salesrep_intf';
203: END process_salesrep_intf;
204:
205: END JTF_EBI_PUB;