DBA Data[Home] [Help]

APPS.PO_R12_CAT_UPG_FINAL_GRP dependencies on FND_API

Line 66: -- FND_API.g_ret_sts_success - if the procedure completed successfully

62: -- processing each batch.
63: --OUT:
64: --x_return_status
65: -- Apps API Std
66: -- FND_API.g_ret_sts_success - if the procedure completed successfully
67: -- FND_API.g_ret_sts_error - if an error occurred
68: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
69: --x_msg_count
70: -- Apps API Std

Line 67: -- FND_API.g_ret_sts_error - if an error occurred

63: --OUT:
64: --x_return_status
65: -- Apps API Std
66: -- FND_API.g_ret_sts_success - if the procedure completed successfully
67: -- FND_API.g_ret_sts_error - if an error occurred
68: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
69: --x_msg_count
70: -- Apps API Std
71: -- The number of error messages returned in the FND error stack in case

Line 68: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred

64: --x_return_status
65: -- Apps API Std
66: -- FND_API.g_ret_sts_success - if the procedure completed successfully
67: -- FND_API.g_ret_sts_error - if an error occurred
68: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
69: --x_msg_count
70: -- Apps API Std
71: -- The number of error messages returned in the FND error stack in case
72: -- x_return_status returned FND_API.G_RET_STS_ERROR or

Line 72: -- x_return_status returned FND_API.G_RET_STS_ERROR or

68: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
69: --x_msg_count
70: -- Apps API Std
71: -- The number of error messages returned in the FND error stack in case
72: -- x_return_status returned FND_API.G_RET_STS_ERROR or
73: -- FND_API.G_RET_STS_UNEXP_ERROR
74: --x_msg_data
75: -- Apps API Std
76: -- Contains error msg in case x_return_status returned FND_API.G_RET_STS_ERROR

Line 73: -- FND_API.G_RET_STS_UNEXP_ERROR

69: --x_msg_count
70: -- Apps API Std
71: -- The number of error messages returned in the FND error stack in case
72: -- x_return_status returned FND_API.G_RET_STS_ERROR or
73: -- FND_API.G_RET_STS_UNEXP_ERROR
74: --x_msg_data
75: -- Apps API Std
76: -- Contains error msg in case x_return_status returned FND_API.G_RET_STS_ERROR
77: -- or FND_API.G_RET_STS_UNEXP_ERROR

Line 76: -- Contains error msg in case x_return_status returned FND_API.G_RET_STS_ERROR

72: -- x_return_status returned FND_API.G_RET_STS_ERROR or
73: -- FND_API.G_RET_STS_UNEXP_ERROR
74: --x_msg_data
75: -- Apps API Std
76: -- Contains error msg in case x_return_status returned FND_API.G_RET_STS_ERROR
77: -- or FND_API.G_RET_STS_UNEXP_ERROR
78: --
79: --End of Comments
80: --------------------------------------------------------------------------------

Line 77: -- or FND_API.G_RET_STS_UNEXP_ERROR

73: -- FND_API.G_RET_STS_UNEXP_ERROR
74: --x_msg_data
75: -- Apps API Std
76: -- Contains error msg in case x_return_status returned FND_API.G_RET_STS_ERROR
77: -- or FND_API.G_RET_STS_UNEXP_ERROR
78: --
79: --End of Comments
80: --------------------------------------------------------------------------------
81: PROCEDURE R12_upgrade_processing

Line 84: , p_commit IN VARCHAR2 default FND_API.G_FALSE

80: --------------------------------------------------------------------------------
81: PROCEDURE R12_upgrade_processing
82: (
83: p_api_version IN NUMBER
84: , p_commit IN VARCHAR2 default FND_API.G_FALSE
85: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
86: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
87: , p_log_level IN NUMBER default 1
88: , p_start_rowid IN rowid default NULL --Bug#5156673

Line 85: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

81: PROCEDURE R12_upgrade_processing
82: (
83: p_api_version IN NUMBER
84: , p_commit IN VARCHAR2 default FND_API.G_FALSE
85: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
86: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
87: , p_log_level IN NUMBER default 1
88: , p_start_rowid IN rowid default NULL --Bug#5156673
89: , p_end_rowid IN rowid default NULL --Bug#5156673

Line 86: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

82: (
83: p_api_version IN NUMBER
84: , p_commit IN VARCHAR2 default FND_API.G_FALSE
85: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
86: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
87: , p_log_level IN NUMBER default 1
88: , p_start_rowid IN rowid default NULL --Bug#5156673
89: , p_end_rowid IN rowid default NULL --Bug#5156673
90: , p_batch_size IN NUMBER default 2500

Line 129: IF NOT FND_API.compatible_API_call(

125:
126: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'START'); END IF;
127:
128: -- Standard call to check for call compatibility
129: IF NOT FND_API.compatible_API_call(
130: p_current_version_number => l_api_version,
131: p_caller_version_number => p_api_version,
132: p_api_name => l_api_name,
133: p_pkg_name => g_pkg_name)

Line 135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

131: p_caller_version_number => p_api_version,
132: p_api_name => l_api_name,
133: p_pkg_name => g_pkg_name)
134: THEN
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: END IF;
137:
138: l_progress := '020';
139: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 140: IF FND_API.to_boolean(p_init_msg_list) THEN

136: END IF;
137:
138: l_progress := '020';
139: -- Initialize message list if p_init_msg_list is set to TRUE.
140: IF FND_API.to_boolean(p_init_msg_list) THEN
141: FND_MSG_PUB.initialize;
142: END IF;
143:
144: l_progress := '030';

Line 146: x_return_status := FND_API.G_RET_STS_SUCCESS;

142: END IF;
143:
144: l_progress := '030';
145: -- Initialize API return status to success
146: x_return_status := FND_API.G_RET_STS_SUCCESS;
147: x_msg_count := 0;
148: x_msg_data := NULL;
149:
150: l_progress := '020';

Line 285: IF FND_API.to_boolean(p_commit) THEN

281: -- attach_gbpa_numbers_in_cpa;
282:
283: l_progress := '150';
284: -- Standard check of p_commit.
285: IF FND_API.to_boolean(p_commit) THEN
286: COMMIT;
287: END IF;
288:
289: l_progress := '160';

Line 302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

298: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'OTHERS Start'); END IF;
299: IF (transferred_gbpas_csr%ISOPEN) THEN
300: CLOSE transferred_gbpas_csr;
301: END IF;
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303:
304: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'x_return_status='||x_return_status); END IF;
305:
306: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN