APPS.INV_PARENT_MMTT_PVT dependencies on FND_API

Line 63: x_return_status := fnd_api.g_ret_sts_success;

59:
60: parent_rec c_get_parent_details%ROWTYPE;
61:
62: BEGIN
63: x_return_status := fnd_api.g_ret_sts_success;
64:
65: SAVEPOINT process_parent_sp;
66:
67: print_version_info;

Line 104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

100: ( 'Exception checking if child WDTH rec exists: ' || sqlerrm
101: , l_api_name
102: );
103: END IF;
104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
105: END;
106:
107: OPEN c_get_parent_details (p_parent_temp_id);
108: FETCH c_get_parent_details INTO parent_rec;

Line 135: l_api_return_status := fnd_api.g_ret_sts_success;

131: , l_api_name
132: );
133: END IF;
134:
135: l_api_return_status := fnd_api.g_ret_sts_success;
136: wms_task_dispatch_put_away.archive_task
137: ( p_temp_id => p_parent_temp_id
138: , p_org_id => parent_rec.organization_id
139: , x_return_status => l_api_return_status

Line 147: IF l_api_return_status <> fnd_api.g_ret_sts_success

143: , p_txn_header_id => l_txn_header_id
144: , p_transfer_lpn_id => parent_rec.transfer_lpn_id
145: );
146:
147: IF l_api_return_status <> fnd_api.g_ret_sts_success
148: THEN
149: IF l_debug = 1 THEN
150: print_debug
151: ( 'Error from wms_task_dispatch_put_away.archive_task: '

Line 156: RAISE FND_API.G_EXC_ERROR;

152: || l_msg_data
153: , l_api_name
154: );
155: END IF;
156: RAISE FND_API.G_EXC_ERROR;
157: END IF;
158:
159: --
160: -- Update parent_transaction_id in WDTH

Line 186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

182: ( 'Exception updating WDTH: ' || sqlerrm
183: , l_api_name
184: );
185: END IF;
186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
187: END;
188:
189: --
190: -- Update child lines

Line 213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

209: ( 'Exception updating WDTH: ' || sqlerrm
210: , l_api_name
211: );
212: END IF;
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END;
215: ELSE
216: DELETE wms_dispatched_tasks
217: WHERE transaction_temp_id = p_parent_temp_id;

Line 224: WHEN fnd_api.g_exc_error THEN

220: WHERE transaction_temp_id = p_parent_temp_id;
221: END IF;
222:
223: EXCEPTION
224: WHEN fnd_api.g_exc_error THEN
225: ROLLBACK TO process_parent_sp;
226:
227: x_return_status := fnd_api.g_ret_sts_error;
228:

Line 227: x_return_status := fnd_api.g_ret_sts_error;

223: EXCEPTION
224: WHEN fnd_api.g_exc_error THEN
225: ROLLBACK TO process_parent_sp;
226:
227: x_return_status := fnd_api.g_ret_sts_error;
228:
229: fnd_msg_pub.count_and_get
230: ( p_count => l_msg_count
231: , p_data => l_msg_data

Line 232: , p_encoded => fnd_api.g_false

228:
229: fnd_msg_pub.count_and_get
230: ( p_count => l_msg_count
231: , p_data => l_msg_data
232: , p_encoded => fnd_api.g_false
233: );
234:
235: IF l_debug = 1 THEN
236: print_debug (l_msg_data, l_api_name);

Line 242: x_return_status := fnd_api.g_ret_sts_unexp_error;

238:
239: WHEN OTHERS THEN
240: ROLLBACK TO process_parent_sp;
241:
242: x_return_status := fnd_api.g_ret_sts_unexp_error;
243:
244: IF l_debug = 1 THEN
245: print_debug ('Other error: ' || sqlerrm, l_api_name);
246: END IF;