DBA Data[Home] [Help]

APPS.EAM_PN_EXTRACTION_PUB dependencies on FND_API

Line 28: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

24: end pn_check_eam_asset;
25:
26: PROCEDURE pn_eam_export_mode(
27: P_API_VERSION IN NUMBER,
28: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
29: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
30: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: P_PN_LOCATION_ID IN NUMBER,
32: P_PARENT_LOCATION_ID IN NUMBER,

Line 29: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

25:
26: PROCEDURE pn_eam_export_mode(
27: P_API_VERSION IN NUMBER,
28: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
29: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
30: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: P_PN_LOCATION_ID IN NUMBER,
32: P_PARENT_LOCATION_ID IN NUMBER,
33: P_ACTIVE_START_DATE IN DATE,

Line 30: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

26: PROCEDURE pn_eam_export_mode(
27: P_API_VERSION IN NUMBER,
28: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
29: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
30: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: P_PN_LOCATION_ID IN NUMBER,
32: P_PARENT_LOCATION_ID IN NUMBER,
33: P_ACTIVE_START_DATE IN DATE,
34: P_ACTIVE_END_DATE IN DATE,

Line 76: IF NOT fnd_api.compatible_api_call(

72:
73: l_stmt_num := 20;
74:
75: -- Standard call to check for call compatibility.
76: IF NOT fnd_api.compatible_api_call(
77: l_api_version
78: ,p_api_version
79: ,l_api_name
80: ,g_pkg_name) THEN

Line 81: RAISE fnd_api.g_exc_unexpected_error;

77: l_api_version
78: ,p_api_version
79: ,l_api_name
80: ,g_pkg_name) THEN
81: RAISE fnd_api.g_exc_unexpected_error;
82: END IF;
83:
84: l_stmt_num := 30;
85: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 86: IF fnd_api.to_boolean(p_init_msg_list) THEN

82: END IF;
83:
84: l_stmt_num := 30;
85: -- Initialize message list if p_init_msg_list is set to TRUE.
86: IF fnd_api.to_boolean(p_init_msg_list) THEN
87: fnd_msg_pub.initialize;
88: END IF;
89:
90: x_insert := 1;

Line 182: WHEN fnd_api.g_exc_error THEN

178: end if;
179:
180:
181: EXCEPTION
182: WHEN fnd_api.g_exc_error THEN
183:
184: ROLLBACK TO pn_eam_export_mode_PUB;
185: x_return_status := fnd_api.g_ret_sts_error;
186: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 185: x_return_status := fnd_api.g_ret_sts_error;

181: EXCEPTION
182: WHEN fnd_api.g_exc_error THEN
183:
184: ROLLBACK TO pn_eam_export_mode_PUB;
185: x_return_status := fnd_api.g_ret_sts_error;
186: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
187:
188: WHEN fnd_api.g_exc_unexpected_error THEN
189:

Line 186: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

182: WHEN fnd_api.g_exc_error THEN
183:
184: ROLLBACK TO pn_eam_export_mode_PUB;
185: x_return_status := fnd_api.g_ret_sts_error;
186: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
187:
188: WHEN fnd_api.g_exc_unexpected_error THEN
189:
190: ROLLBACK TO pn_eam_export_mode_PUB;

Line 188: WHEN fnd_api.g_exc_unexpected_error THEN

184: ROLLBACK TO pn_eam_export_mode_PUB;
185: x_return_status := fnd_api.g_ret_sts_error;
186: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
187:
188: WHEN fnd_api.g_exc_unexpected_error THEN
189:
190: ROLLBACK TO pn_eam_export_mode_PUB;
191: x_return_status := fnd_api.g_ret_sts_unexp_error;
192: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 191: x_return_status := fnd_api.g_ret_sts_unexp_error;

187:
188: WHEN fnd_api.g_exc_unexpected_error THEN
189:
190: ROLLBACK TO pn_eam_export_mode_PUB;
191: x_return_status := fnd_api.g_ret_sts_unexp_error;
192: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
193:
194: WHEN OTHERS THEN
195:

Line 192: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

188: WHEN fnd_api.g_exc_unexpected_error THEN
189:
190: ROLLBACK TO pn_eam_export_mode_PUB;
191: x_return_status := fnd_api.g_ret_sts_unexp_error;
192: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
193:
194: WHEN OTHERS THEN
195:
196: ROLLBACK TO pn_eam_export_mode_PUB;

Line 197: x_return_status := fnd_api.g_ret_sts_unexp_error;

193:
194: WHEN OTHERS THEN
195:
196: ROLLBACK TO pn_eam_export_mode_PUB;
197: x_return_status := fnd_api.g_ret_sts_unexp_error;
198:
199: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
200: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
201: END IF;

Line 203: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

199: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
200: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
201: END IF;
202:
203: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
204:
205: END PN_EAM_EXPORT_MODE;
206:
207: