46: * Modifies: None. [The custom code has to be written by customer.]
47: * Effects: This procedure runs the custom document submission checks on
48: * passed in document.
49: * Returns:
50: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
51: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
52: *
53: * NOTE: For writing custom code, please refer to the instructions given at
54: * the top of this file.
47: * Effects: This procedure runs the custom document submission checks on
48: * passed in document.
49: * Returns:
50: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
51: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
52: *
53: * NOTE: For writing custom code, please refer to the instructions given at
54: * the top of this file.
55: */
95: po_log.proc_begin(d_mod, 'p_sequence', p_sequence);
96: END IF;
97:
98: -- Standard call to check for call compatibility
99: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name,
100: g_pkg_name)
101: THEN
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: END IF;
98: -- Standard call to check for call compatibility
99: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name,
100: g_pkg_name)
101: THEN
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: END IF;
104: d_position := 10;
105:
106: -- TODO: Add custom code here.
143: --p_sequence := p_sequence + SQL%ROWCOUNT;
144: --
145: -- *** Sample Code END ***
146:
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148: d_position := 100;
149:
150: EXCEPTION
151: WHEN OTHERS
149:
150: EXCEPTION
151: WHEN OTHERS
152: THEN
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: IF po_log.d_exc
155: THEN
156: PO_LOG.exc(d_mod, d_position, SQLCODE || ': ' || SQLERRM);
157: PO_LOG.proc_end(d_mod, 'd_position', d_position);
189: * Modifies: None. [The custom code has to be written by customer.]
190: * Effects: This procedure runs the custom document submission checks on
191: * passed in document.
192: * Returns:
193: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
194: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
195: *
196: * NOTE: For writing custom code, please refer to the instructions given at
197: * the top of this file.
190: * Effects: This procedure runs the custom document submission checks on
191: * passed in document.
192: * Returns:
193: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
194: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
195: *
196: * NOTE: For writing custom code, please refer to the instructions given at
197: * the top of this file.
198: */
238: po_log.proc_begin(d_mod, 'p_sequence', p_sequence);
239: END IF;
240:
241: -- Standard call to check for call compatibility
242: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name,
243: g_pkg_name)
244: THEN
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: END IF;
241: -- Standard call to check for call compatibility
242: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name,
243: g_pkg_name)
244: THEN
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: END IF;
247: d_position := 10;
248:
249: -- TODO: Add custom code here.
247: d_position := 10;
248:
249: -- TODO: Add custom code here.
250:
251: x_return_status := FND_API.G_RET_STS_SUCCESS;
252: d_position := 100;
253:
254: EXCEPTION
255: WHEN OTHERS
253:
254: EXCEPTION
255: WHEN OTHERS
256: THEN
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258: IF po_log.d_exc
259: THEN
260: PO_LOG.exc(d_mod, d_position, SQLCODE || ': ' || SQLERRM);
261: PO_LOG.proc_end(d_mod, 'd_position', d_position);