DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CONTROL_PUB dependencies on FND_API

Line 24: * changes will be committed upon success if p_commit is FND_API.G_TRUE.

20: * level if the final doc_id, line_id, and line_loc_id are not NULL. Executes
21: * at line level if only the final doc_id and line_id are not NULL. Executes
22: * at header level if only the final doc_id is not NULL. The document will be
23: * printed if it is a PO, PA, or RELEASE, and the p_print_flag is 'Y'. All
24: * changes will be committed upon success if p_commit is FND_API.G_TRUE.
25: * Appends to API message list on error, and leaves the document unchanged.
26: * Returns:
27: * x_return_status - FND_API.G_RET_STS_SUCCESS if control action succeeds
28: * FND_API.G_RET_STS_ERROR if control action fails

Line 27: * x_return_status - FND_API.G_RET_STS_SUCCESS if control action succeeds

23: * printed if it is a PO, PA, or RELEASE, and the p_print_flag is 'Y'. All
24: * changes will be committed upon success if p_commit is FND_API.G_TRUE.
25: * Appends to API message list on error, and leaves the document unchanged.
26: * Returns:
27: * x_return_status - FND_API.G_RET_STS_SUCCESS if control action succeeds
28: * FND_API.G_RET_STS_ERROR if control action fails
29: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
30: */
31: PROCEDURE control_document

Line 28: * FND_API.G_RET_STS_ERROR if control action fails

24: * changes will be committed upon success if p_commit is FND_API.G_TRUE.
25: * Appends to API message list on error, and leaves the document unchanged.
26: * Returns:
27: * x_return_status - FND_API.G_RET_STS_SUCCESS if control action succeeds
28: * FND_API.G_RET_STS_ERROR if control action fails
29: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
30: */
31: PROCEDURE control_document
32: (p_api_version IN NUMBER,

Line 29: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

25: * Appends to API message list on error, and leaves the document unchanged.
26: * Returns:
27: * x_return_status - FND_API.G_RET_STS_SUCCESS if control action succeeds
28: * FND_API.G_RET_STS_ERROR if control action fails
29: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
30: */
31: PROCEDURE control_document
32: (p_api_version IN NUMBER,
33: p_init_msg_list IN VARCHAR2,

Line 63: IF FND_API.to_boolean(p_init_msg_list) THEN

59: l_org_id PO_HEADERS_ALL.org_id%type := p_org_id;
60: BEGIN
61: -- Start standard API initialization
62: SAVEPOINT control_document_PUB;
63: IF FND_API.to_boolean(p_init_msg_list) THEN
64: FND_MSG_PUB.initialize;
65: END IF;
66: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
67: l_api_name, g_pkg_name)

Line 66: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,

62: SAVEPOINT control_document_PUB;
63: IF FND_API.to_boolean(p_init_msg_list) THEN
64: FND_MSG_PUB.initialize;
65: END IF;
66: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
67: l_api_name, g_pkg_name)
68: THEN
69: RAISE FND_API.g_exc_unexpected_error;
70: END IF;

Line 69: RAISE FND_API.g_exc_unexpected_error;

65: END IF;
66: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
67: l_api_name, g_pkg_name)
68: THEN
69: RAISE FND_API.g_exc_unexpected_error;
70: END IF;
71: x_return_status := FND_API.g_ret_sts_success;
72: -- End standard API initialization
73:

Line 71: x_return_status := FND_API.g_ret_sts_success;

67: l_api_name, g_pkg_name)
68: THEN
69: RAISE FND_API.g_exc_unexpected_error;
70: END IF;
71: x_return_status := FND_API.g_ret_sts_success;
72: -- End standard API initialization
73:
74: IF (g_fnd_debug = 'Y') THEN
75: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 90: p_init_msg_list => FND_API.G_FALSE,

86: --
87:
88: PO_Document_Control_GRP.control_document
89: (p_api_version => 1.0,
90: p_init_msg_list => FND_API.G_FALSE,
91: p_commit => FND_API.G_FALSE,
92: x_return_status => x_return_status,
93: p_doc_type => p_doc_type,
94: p_doc_subtype => p_doc_subtype,

Line 91: p_commit => FND_API.G_FALSE,

87:
88: PO_Document_Control_GRP.control_document
89: (p_api_version => 1.0,
90: p_init_msg_list => FND_API.G_FALSE,
91: p_commit => FND_API.G_FALSE,
92: x_return_status => x_return_status,
93: p_doc_type => p_doc_type,
94: p_doc_subtype => p_doc_subtype,
95: p_doc_id => p_doc_id,

Line 113: IF (x_return_status = FND_API.g_ret_sts_error) THEN

109: p_note_to_vendor => p_note_to_vendor,
110: p_use_gldate => p_use_gldate --
111: );
112:
113: IF (x_return_status = FND_API.g_ret_sts_error) THEN
114: RAISE FND_API.g_exc_error;
115: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
116: RAISE FND_API.g_exc_unexpected_error;
117: END IF;

Line 114: RAISE FND_API.g_exc_error;

110: p_use_gldate => p_use_gldate --
111: );
112:
113: IF (x_return_status = FND_API.g_ret_sts_error) THEN
114: RAISE FND_API.g_exc_error;
115: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
116: RAISE FND_API.g_exc_unexpected_error;
117: END IF;
118:

Line 115: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN

111: );
112:
113: IF (x_return_status = FND_API.g_ret_sts_error) THEN
114: RAISE FND_API.g_exc_error;
115: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
116: RAISE FND_API.g_exc_unexpected_error;
117: END IF;
118:
119:

Line 116: RAISE FND_API.g_exc_unexpected_error;

112:
113: IF (x_return_status = FND_API.g_ret_sts_error) THEN
114: RAISE FND_API.g_exc_error;
115: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
116: RAISE FND_API.g_exc_unexpected_error;
117: END IF;
118:
119:
120: -- Standard API check of p_commit

Line 121: IF FND_API.to_boolean(p_commit) THEN

117: END IF;
118:
119:
120: -- Standard API check of p_commit
121: IF FND_API.to_boolean(p_commit) THEN
122: COMMIT WORK;
123: END IF;
124: EXCEPTION
125: WHEN FND_API.g_exc_error THEN

Line 125: WHEN FND_API.g_exc_error THEN

121: IF FND_API.to_boolean(p_commit) THEN
122: COMMIT WORK;
123: END IF;
124: EXCEPTION
125: WHEN FND_API.g_exc_error THEN
126: ROLLBACK TO control_document_PUB;
127: x_return_status := FND_API.g_ret_sts_error;
128: WHEN FND_API.g_exc_unexpected_error THEN
129: ROLLBACK TO control_document_PUB;

Line 127: x_return_status := FND_API.g_ret_sts_error;

123: END IF;
124: EXCEPTION
125: WHEN FND_API.g_exc_error THEN
126: ROLLBACK TO control_document_PUB;
127: x_return_status := FND_API.g_ret_sts_error;
128: WHEN FND_API.g_exc_unexpected_error THEN
129: ROLLBACK TO control_document_PUB;
130: x_return_status := FND_API.g_ret_sts_unexp_error;
131: WHEN OTHERS THEN

Line 128: WHEN FND_API.g_exc_unexpected_error THEN

124: EXCEPTION
125: WHEN FND_API.g_exc_error THEN
126: ROLLBACK TO control_document_PUB;
127: x_return_status := FND_API.g_ret_sts_error;
128: WHEN FND_API.g_exc_unexpected_error THEN
129: ROLLBACK TO control_document_PUB;
130: x_return_status := FND_API.g_ret_sts_unexp_error;
131: WHEN OTHERS THEN
132: ROLLBACK TO control_document_PUB;

Line 130: x_return_status := FND_API.g_ret_sts_unexp_error;

126: ROLLBACK TO control_document_PUB;
127: x_return_status := FND_API.g_ret_sts_error;
128: WHEN FND_API.g_exc_unexpected_error THEN
129: ROLLBACK TO control_document_PUB;
130: x_return_status := FND_API.g_ret_sts_unexp_error;
131: WHEN OTHERS THEN
132: ROLLBACK TO control_document_PUB;
133: x_return_status := FND_API.g_ret_sts_unexp_error;
134: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 133: x_return_status := FND_API.g_ret_sts_unexp_error;

129: ROLLBACK TO control_document_PUB;
130: x_return_status := FND_API.g_ret_sts_unexp_error;
131: WHEN OTHERS THEN
132: ROLLBACK TO control_document_PUB;
133: x_return_status := FND_API.g_ret_sts_unexp_error;
134: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
135: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
136: IF (g_fnd_debug = 'Y') THEN
137: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN