DBA Data[Home] [Help]

APPS.EC_DOCUMENT dependencies on FND_API

Line 7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EC_DOCUMENT';
4:
5: PROCEDURE send(
6: p_api_version_number IN NUMBER,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_count OUT NOCOPY NUMBER,

Line 8: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4:
5: PROCEDURE send(
6: p_api_version_number IN NUMBER,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_count OUT NOCOPY NUMBER,
12: x_msg_data OUT NOCOPY VARCHAR2,

Line 9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

5: PROCEDURE send(
6: p_api_version_number IN NUMBER,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_count OUT NOCOPY NUMBER,
12: x_msg_data OUT NOCOPY VARCHAR2,
13: call_status OUT NOCOPY BOOLEAN,

Line 52: IF NOT fnd_api.Compatible_API_Call(l_api_version,

48: p_Output_Path VARCHAR2(250);
49: p_Debug_Mode NUMBER;
50: BEGIN
51: SAVEPOINT ECSEND_PUB;
52: IF NOT fnd_api.Compatible_API_Call(l_api_version,
53: p_api_version_number,
54: l_api_name,
55: G_PKG_NAME)
56: THEN

Line 57: RAISE fnd_api.g_exc_unexpected_error;

53: p_api_version_number,
54: l_api_name,
55: G_PKG_NAME)
56: THEN
57: RAISE fnd_api.g_exc_unexpected_error;
58: END IF;
59:
60: IF fnd_api.to_Boolean(p_init_msg_list) THEN
61: fnd_msg_pub.initialize;

Line 60: IF fnd_api.to_Boolean(p_init_msg_list) THEN

56: THEN
57: RAISE fnd_api.g_exc_unexpected_error;
58: END IF;
59:
60: IF fnd_api.to_Boolean(p_init_msg_list) THEN
61: fnd_msg_pub.initialize;
62: END IF;
63:
64: x_return_status := fnd_api.g_ret_sts_success;

Line 64: x_return_status := fnd_api.g_ret_sts_success;

60: IF fnd_api.to_Boolean(p_init_msg_list) THEN
61: fnd_msg_pub.initialize;
62: END IF;
63:
64: x_return_status := fnd_api.g_ret_sts_success;
65:
66: p_Output_Path := i_Output_Path;
67: IF p_Output_Path IS NULL THEN
68: -- Retrieve the system profile option ECE_OUT_FILE_PATH. This will

Line 118: if fnd_api.to_Boolean(p_commit) then

114: call_status := FND_CONCURRENT.GET_REQUEST_STATUS(request_id,
115: ' ',' ', rphase, rstatus, dphase, dstatus, message);
116:
117: -- Standard check of p_commit
118: if fnd_api.to_Boolean(p_commit) then
119: COMMIT WORK;
120: end if;
121:
122: -- Standard call to get message count and if count is 1, get message info.

Line 128: WHEN fnd_api.g_exc_error THEN

124: p_count => x_msg_count,
125: p_data => x_msg_data);
126:
127: EXCEPTION
128: WHEN fnd_api.g_exc_error THEN
129: ROLLBACK TO ECSEND_PUB;
130: x_return_status := fnd_api.g_ret_sts_error;
131: fnd_msg_pub.count_and_get(p_count => x_msg_count,
132: p_data => x_msg_data);

Line 130: x_return_status := fnd_api.g_ret_sts_error;

126:
127: EXCEPTION
128: WHEN fnd_api.g_exc_error THEN
129: ROLLBACK TO ECSEND_PUB;
130: x_return_status := fnd_api.g_ret_sts_error;
131: fnd_msg_pub.count_and_get(p_count => x_msg_count,
132: p_data => x_msg_data);
133: WHEN fnd_api.g_exc_unexpected_error THEN
134: ROLLBACK TO ECSEND_PUB;

Line 133: WHEN fnd_api.g_exc_unexpected_error THEN

129: ROLLBACK TO ECSEND_PUB;
130: x_return_status := fnd_api.g_ret_sts_error;
131: fnd_msg_pub.count_and_get(p_count => x_msg_count,
132: p_data => x_msg_data);
133: WHEN fnd_api.g_exc_unexpected_error THEN
134: ROLLBACK TO ECSEND_PUB;
135: x_return_status := fnd_api.g_ret_sts_unexp_error;
136: fnd_msg_pub.count_and_get(p_count => x_msg_count,
137: p_data => x_msg_data);

Line 135: x_return_status := fnd_api.g_ret_sts_unexp_error;

131: fnd_msg_pub.count_and_get(p_count => x_msg_count,
132: p_data => x_msg_data);
133: WHEN fnd_api.g_exc_unexpected_error THEN
134: ROLLBACK TO ECSEND_PUB;
135: x_return_status := fnd_api.g_ret_sts_unexp_error;
136: fnd_msg_pub.count_and_get(p_count => x_msg_count,
137: p_data => x_msg_data);
138: WHEN OTHERS THEN
139: ROLLBACK TO ECSEND_PUB;

Line 140: x_return_status := fnd_api.g_ret_sts_unexp_error;

136: fnd_msg_pub.count_and_get(p_count => x_msg_count,
137: p_data => x_msg_data);
138: WHEN OTHERS THEN
139: ROLLBACK TO ECSEND_PUB;
140: x_return_status := fnd_api.g_ret_sts_unexp_error;
141: IF fnd_msg_pub.Check_Msg_Level
142: (fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
143: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
144: END IF;