eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_LTP_REQST_MATRL_PUB dependencies on FND_API

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

26: -- Parameters :
27: --
28: -- Standard IN Parameters :
29: -- p_api_version IN NUMBER Required
30: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
31: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
32: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
33: -- Based on this flag, the API will set the default attributes.
34: -- p_module_type In VARCHAR2 Default NULL

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

27: --
28: -- Standard IN Parameters :
29: -- p_api_version IN NUMBER Required
30: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
31: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
32: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
33: -- Based on this flag, the API will set the default attributes.
34: -- p_module_type In VARCHAR2 Default NULL
35: -- This will be null.

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

28: -- Standard IN Parameters :
29: -- p_api_version IN NUMBER Required
30: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
31: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
32: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
33: -- Based on this flag, the API will set the default attributes.
34: -- p_module_type In VARCHAR2 Default NULL
35: -- This will be null.
36: -- Standard out Parameters :

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

43: --
44: --
45: PROCEDURE Update_Planned_Materials (
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
48: p_commit IN VARCHAR2 := FND_API.g_false,
49: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
50: p_module_type IN VARCHAR2 := 'JSP',
51: p_planned_Materials_tbl IN Planned_Materials_Tbl,

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

44: --
45: PROCEDURE Update_Planned_Materials (
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
48: p_commit IN VARCHAR2 := FND_API.g_false,
49: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
50: p_module_type IN VARCHAR2 := 'JSP',
51: p_planned_Materials_tbl IN Planned_Materials_Tbl,
52: x_return_status OUT NOCOPY VARCHAR2,

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

45: PROCEDURE Update_Planned_Materials (
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
48: p_commit IN VARCHAR2 := FND_API.g_false,
49: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
50: p_module_type IN VARCHAR2 := 'JSP',
51: p_planned_Materials_tbl IN Planned_Materials_Tbl,
52: x_return_status OUT NOCOPY VARCHAR2,
53: x_msg_count OUT NOCOPY NUMBER,

Line 66: l_commit VARCHAR2(10) := FND_API.g_false;

62: l_msg_data VARCHAR2(2000);
63: l_return_status VARCHAR2(1);
64: l_msg_count NUMBER;
65: --
66: l_commit VARCHAR2(10) := FND_API.g_false;
67: l_planned_materials_tbl planned_materials_tbl := p_planned_materials_tbl;
68: BEGIN
69:
70: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 81: IF FND_API.To_Boolean( p_init_msg_list) THEN

77: END IF;
78: -- Standard start of API savepoint
79: SAVEPOINT Update_Planned_Materials;
80: -- Initialize message list if p_init_msg_list is set to TRUE
81: IF FND_API.To_Boolean( p_init_msg_list) THEN
82: FND_MSG_PUB.Initialize;
83: END IF;
84: -- Initialize API return status to success
85: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 85: x_return_status := FND_API.G_RET_STS_SUCCESS;

81: IF FND_API.To_Boolean( p_init_msg_list) THEN
82: FND_MSG_PUB.Initialize;
83: END IF;
84: -- Initialize API return status to success
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86: --
87: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
88: fnd_log.string
89: (

Line 129: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

125: 'After calling ahl ltp reqst matrl pvt.Update Planned Materials, Return Status : '|| l_return_status
126: );
127: END IF;
128: -- Check Error Message stack.
129: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
130: l_msg_count := FND_MSG_PUB.count_msg;
131: IF l_msg_count > 0 THEN
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;

Line 132: RAISE FND_API.G_EXC_ERROR;

128: -- Check Error Message stack.
129: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
130: l_msg_count := FND_MSG_PUB.count_msg;
131: IF l_msg_count > 0 THEN
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;
134: END IF;
135:
136: -- Standard check of p_commit

Line 137: IF FND_API.TO_BOOLEAN(p_commit) THEN

133: END IF;
134: END IF;
135:
136: -- Standard check of p_commit
137: IF FND_API.TO_BOOLEAN(p_commit) THEN
138: COMMIT WORK;
139: END IF;
140:
141: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 150: WHEN FND_API.G_EXC_ERROR THEN

146: 'At the end of PLSQL procedure'
147: );
148: END IF;
149: EXCEPTION
150: WHEN FND_API.G_EXC_ERROR THEN
151: x_return_status := FND_API.G_RET_STS_ERROR;
152: ROLLBACK TO Update_Planned_Materials;
153: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
154: p_data => x_msg_data,

Line 151: x_return_status := FND_API.G_RET_STS_ERROR;

147: );
148: END IF;
149: EXCEPTION
150: WHEN FND_API.G_EXC_ERROR THEN
151: x_return_status := FND_API.G_RET_STS_ERROR;
152: ROLLBACK TO Update_Planned_Materials;
153: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
154: p_data => x_msg_data,
155: p_encoded => fnd_api.g_false);

Line 155: p_encoded => fnd_api.g_false);

151: x_return_status := FND_API.G_RET_STS_ERROR;
152: ROLLBACK TO Update_Planned_Materials;
153: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
154: p_data => x_msg_data,
155: p_encoded => fnd_api.g_false);
156:
157:
158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

154: p_data => x_msg_data,
155: p_encoded => fnd_api.g_false);
156:
157:
158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160: ROLLBACK TO Update_Planned_Materials;
161: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
162: p_data => x_msg_data,

Line 159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

155: p_encoded => fnd_api.g_false);
156:
157:
158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160: ROLLBACK TO Update_Planned_Materials;
161: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
162: p_data => x_msg_data,
163: p_encoded => fnd_api.g_false);

Line 163: p_encoded => fnd_api.g_false);

159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160: ROLLBACK TO Update_Planned_Materials;
161: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
162: p_data => x_msg_data,
163: p_encoded => fnd_api.g_false);
164:
165:
166: WHEN OTHERS THEN
167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

163: p_encoded => fnd_api.g_false);
164:
165:
166: WHEN OTHERS THEN
167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
168: ROLLBACK TO Update_Planned_Materials;
169: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
170: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
171: p_procedure_name => 'Update_Planned_Materials',

Line 176: p_encoded => fnd_api.g_false);

172: p_error_text => SUBSTR(SQLERRM,1,500));
173: END IF;
174: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
175: p_data => x_msg_data,
176: p_encoded => fnd_api.g_false);
177:
178: END Update_Planned_Materials;
179:
180: END AHL_LTP_REQST_MATRL_PUB;