DBA Data[Home] [Help]

APPS.AHL_LTP_ASCP_ORDERS_PVT dependencies on FND_API

Line 16: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

12: -- Parameters :
13: --
14: -- Standard IN Parameters :
15: -- p_api_version IN NUMBER Required
16: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
17: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
18: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
19: -- Standard out Parameters :
20: -- x_return_status OUT VARCHAR2 Required

Line 17: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

13: --
14: -- Standard IN Parameters :
15: -- p_api_version IN NUMBER Required
16: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
17: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
18: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
19: -- Standard out Parameters :
20: -- x_return_status OUT VARCHAR2 Required
21: --

Line 18: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

14: -- Standard IN Parameters :
15: -- p_api_version IN NUMBER Required
16: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
17: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
18: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
19: -- Standard out Parameters :
20: -- x_return_status OUT VARCHAR2 Required
21: --
22: -- Update_Scheduling_Results :

Line 28: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

24: --
25: --
26: PROCEDURE Update_Scheduling_Results (
27: p_api_version IN NUMBER := 1.0,
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_sched_Orders_Tbl IN Sched_Orders_Tbl,
32: x_return_status OUT NOCOPY VARCHAR2)

Line 29: p_commit IN VARCHAR2 := FND_API.g_false,

25: --
26: PROCEDURE Update_Scheduling_Results (
27: p_api_version IN NUMBER := 1.0,
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_sched_Orders_Tbl IN Sched_Orders_Tbl,
32: x_return_status OUT NOCOPY VARCHAR2)
33: IS

Line 30: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

26: PROCEDURE Update_Scheduling_Results (
27: p_api_version IN NUMBER := 1.0,
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_sched_Orders_Tbl IN Sched_Orders_Tbl,
32: x_return_status OUT NOCOPY VARCHAR2)
33: IS
34:

Line 60: IF FND_API.to_boolean(p_init_msg_list)

56: END IF;
57: -- Standard Start of API savepoint
58: SAVEPOINT Update_Scheduling_Results;
59: -- Initialize message list if p_init_msg_list is set to TRUE.
60: IF FND_API.to_boolean(p_init_msg_list)
61: THEN
62: FND_MSG_PUB.initialize;
63: END IF;
64: -- Initialize API return status to success

Line 65: x_return_status := FND_API.G_RET_STS_SUCCESS;

61: THEN
62: FND_MSG_PUB.initialize;
63: END IF;
64: -- Initialize API return status to success
65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66: -- Standard call to check for call compatibility.
67: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
68: l_api_version,
69: l_api_name,G_PKG_NAME)

Line 67: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

63: END IF;
64: -- Initialize API return status to success
65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66: -- Standard call to check for call compatibility.
67: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
68: l_api_version,
69: l_api_name,G_PKG_NAME)
70: THEN
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

67: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
68: l_api_version,
69: l_api_name,G_PKG_NAME)
70: THEN
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;
73:
74: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
75: fnd_log.string

Line 107: RAISE FND_API.G_EXC_ERROR;

103:
104: --Standard check to count messages
105: l_msg_count := FND_MSG_PUB.count_msg;
106: IF l_msg_count > 0 THEN
107: RAISE FND_API.G_EXC_ERROR;
108: END IF;
109:
110: -- Standard check of p_commit
111: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 111: IF FND_API.TO_BOOLEAN(p_commit) THEN

107: RAISE FND_API.G_EXC_ERROR;
108: END IF;
109:
110: -- Standard check of p_commit
111: IF FND_API.TO_BOOLEAN(p_commit) THEN
112: COMMIT WORK;
113: END IF;
114:
115: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

121: );
122: END IF;
123:
124: EXCEPTION
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
126: ROLLBACK TO Update_Scheduling_Results;
127: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
128: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
129: p_count => l_msg_count,

Line 127: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

123:
124: EXCEPTION
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
126: ROLLBACK TO Update_Scheduling_Results;
127: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
128: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
129: p_count => l_msg_count,
130: p_data => l_msg_data);
131:

Line 128: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

124: EXCEPTION
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
126: ROLLBACK TO Update_Scheduling_Results;
127: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
128: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
129: p_count => l_msg_count,
130: p_data => l_msg_data);
131:
132: WHEN FND_API.G_EXC_ERROR THEN

Line 132: WHEN FND_API.G_EXC_ERROR THEN

128: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
129: p_count => l_msg_count,
130: p_data => l_msg_data);
131:
132: WHEN FND_API.G_EXC_ERROR THEN
133: ROLLBACK TO Update_Scheduling_Results;
134: X_return_status := FND_API.G_RET_STS_ERROR;
135: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
136: p_count => l_msg_count,

Line 134: X_return_status := FND_API.G_RET_STS_ERROR;

130: p_data => l_msg_data);
131:
132: WHEN FND_API.G_EXC_ERROR THEN
133: ROLLBACK TO Update_Scheduling_Results;
134: X_return_status := FND_API.G_RET_STS_ERROR;
135: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
136: p_count => l_msg_count,
137: p_data => l_msg_data);
138:

Line 135: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

131:
132: WHEN FND_API.G_EXC_ERROR THEN
133: ROLLBACK TO Update_Scheduling_Results;
134: X_return_status := FND_API.G_RET_STS_ERROR;
135: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
136: p_count => l_msg_count,
137: p_data => l_msg_data);
138:
139: WHEN OTHERS THEN

Line 141: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

137: p_data => l_msg_data);
138:
139: WHEN OTHERS THEN
140: ROLLBACK TO Update_Scheduling_Results;
141: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
143: THEN
144: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_ASCP_ORDERS_PVT',
145: p_procedure_name => 'UPDATE_SCHEDULING_RESULTS',

Line 148: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

144: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_ASCP_ORDERS_PVT',
145: p_procedure_name => 'UPDATE_SCHEDULING_RESULTS',
146: p_error_text => SUBSTR(SQLERRM,1,240));
147: END IF;
148: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
149: p_count => l_msg_count,
150: p_data => l_msg_data);
151:
152: