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.ITG_ORGEFF_PVT dependencies on FND_API

Line 81: IF l_orgind <> FND_API.G_TRUE THEN

77: END IF;
78:
79: /* Check the nitty-gritty itty-bitty effectivity. :) */
80: l_orgid := p_organization_id;
81: IF l_orgind <> FND_API.G_TRUE THEN
82: l_orgid := NULL;
83: END IF;
84: OPEN orgeff_csr(l_orgid, p_cln_doc_type, p_doc_direction);
85: FETCH orgeff_csr INTO l_orgeff;

Line 92: IF l_orgeff.effectivity_enabled = FND_API.G_TRUE THEN

88: /* In the older wildcard scheme, we wouldn't care if more records are
89: available. There shouldn't be any more now with the new query. */
90:
91: IF l_found THEN
92: IF l_orgeff.effectivity_enabled = FND_API.G_TRUE THEN
93: IF (l_orgeff.start_date IS NULL OR l_orgeff.start_date <= SYSDATE) AND
94: (l_orgeff.end_date IS NULL OR l_orgeff.end_date >= SYSDATE) THEN
95: ITG_Debug.msg('Effective: all tests passed.');
96: RETURN TRUE;

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

107: END Check_Effective;
108:
109: PROCEDURE Update_Effectivity(
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114:
115: x_return_status OUT NOCOPY VARCHAR2, /* VARCHAR2(1) */

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

108:
109: PROCEDURE Update_Effectivity(
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114:
115: x_return_status OUT NOCOPY VARCHAR2, /* VARCHAR2(1) */
116: x_msg_count OUT NOCOPY NUMBER,

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

109: PROCEDURE Update_Effectivity(
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114:
115: x_return_status OUT NOCOPY VARCHAR2, /* VARCHAR2(1) */
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2, /* VARCHAR2(2000) */

Line 143: x_return_status := FND_API.G_RET_STS_SUCCESS;

139: AND cln_doc_type = p_cln_doc_type
140: AND doc_direction = p_doc_direction;
141:
142: BEGIN
143: x_return_status := FND_API.G_RET_STS_SUCCESS;
144:
145: BEGIN
146: SAVEPOINT Update_Effectivity_PVT;
147: ITG_Debug.setup(

Line 151: IF NOT FND_API.Compatible_API_Call(

147: ITG_Debug.setup(
148: p_reset => TRUE,
149: p_pkg_name => G_PKG_NAME,
150: p_proc_name => l_api_name);
151: IF NOT FND_API.Compatible_API_Call(
152: l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: END IF;
155: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

149: p_pkg_name => G_PKG_NAME,
150: p_proc_name => l_api_name);
151: IF NOT FND_API.Compatible_API_Call(
152: l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: END IF;
155: IF FND_API.To_Boolean(p_init_msg_list) THEN
156: FND_MSG_PUB.Initialize;
157: END IF;

Line 155: IF FND_API.To_Boolean(p_init_msg_list) THEN

151: IF NOT FND_API.Compatible_API_Call(
152: l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: END IF;
155: IF FND_API.To_Boolean(p_init_msg_list) THEN
156: FND_MSG_PUB.Initialize;
157: END IF;
158:
159: ITG_Debug.msg('UE', 'Top of procedure.');

Line 167: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

163: ITG_Debug.msg('UE', 'p_start_date', p_start_date);
164: ITG_Debug.msg('UE', 'p_end_date', p_end_date);
165: ITG_Debug.msg('UE', 'p_effective', p_effective);
166:
167: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
168: ITG_Debug.msg('UE', 'Validating input arguments.');
169:
170: IF p_cln_doc_type IS NULL THEN
171: l_count := 0;

Line 183: RAISE FND_API.G_EXC_ERROR;

179: END IF;
180:
181: IF l_count <> 1 THEN
182: ITG_MSG.invalid_argument('p_cln_doc_type', p_cln_doc_type);
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185:
186: IF p_doc_direction <> 'P' AND p_doc_direction <> 'S' THEN
187: ITG_MSG.invalid_doc_direction(p_doc_direction);

Line 188: RAISE FND_API.G_EXC_ERROR;

184: END IF;
185:
186: IF p_doc_direction <> 'P' AND p_doc_direction <> 'S' THEN
187: ITG_MSG.invalid_doc_direction(p_doc_direction);
188: RAISE FND_API.G_EXC_ERROR;
189: END IF;
190:
191: OPEN orgind_csr(p_cln_doc_type, p_doc_direction);
192: FETCH orgind_csr INTO l_dummy;

Line 197: RAISE FND_API.G_EXC_ERROR;

193: l_found := orgind_csr%FOUND;
194: CLOSE orgind_csr;
195: IF NOT l_found THEN
196: ITG_MSG.missing_orgind(p_cln_doc_type, p_doc_direction);
197: RAISE FND_API.G_EXC_ERROR;
198: END IF;
199: END IF;
200:
201: IF p_effective = FND_API.G_TRUE OR

Line 201: IF p_effective = FND_API.G_TRUE OR

197: RAISE FND_API.G_EXC_ERROR;
198: END IF;
199: END IF;
200:
201: IF p_effective = FND_API.G_TRUE OR
202: p_effective = FND_API.G_FALSE THEN
203: l_flag := p_effective;
204: ELSE
205: l_flag := NULL;

Line 202: p_effective = FND_API.G_FALSE THEN

198: END IF;
199: END IF;
200:
201: IF p_effective = FND_API.G_TRUE OR
202: p_effective = FND_API.G_FALSE THEN
203: l_flag := p_effective;
204: ELSE
205: l_flag := NULL;
206: END IF;

Line 230: RAISE FND_API.G_EXC_ERROR;

226: EXCEPTION
227: WHEN NO_DATA_FOUND THEN
228: ITG_MSG.effectivity_update_fail(
229: p_organization_id, p_cln_doc_type, p_doc_direction, l_eff_id);
230: RAISE FND_API.G_EXC_ERROR;
231: END;
232: ELSE
233: ITG_Debug.msg('UE', 'Inserting new effectivity row.');
234: BEGIN

Line 255: NVL(l_flag, FND_API.G_TRUE),

251: p_cln_doc_type,
252: p_doc_direction,
253: p_start_date,
254: p_end_date,
255: NVL(l_flag, FND_API.G_TRUE),
256: FND_GLOBAL.user_id,
257: SYSDATE,
258: FND_GLOBAL.user_id,
259: SYSDATE,

Line 266: RAISE FND_API.G_EXC_ERROR;

262: EXCEPTION
263: WHEN NO_DATA_FOUND THEN
264: ITG_MSG.effectivity_insert_fail(
265: p_organization_id, p_cln_doc_type, p_doc_direction);
266: RAISE FND_API.G_EXC_ERROR;
267: END;
268: END IF;
269:
270: IF FND_API.To_Boolean(p_commit) THEN

Line 270: IF FND_API.To_Boolean(p_commit) THEN

266: RAISE FND_API.G_EXC_ERROR;
267: END;
268: END IF;
269:
270: IF FND_API.To_Boolean(p_commit) THEN
271: ITG_Debug.msg('UE', 'Committing work.');
272: COMMIT WORK;
273: END IF;
274: ITG_Debug.msg('UE', 'Done.');

Line 277: WHEN FND_API.G_EXC_ERROR THEN

273: END IF;
274: ITG_Debug.msg('UE', 'Done.');
275:
276: EXCEPTION
277: WHEN FND_API.G_EXC_ERROR THEN
278: ROLLBACK TO Update_Effectivity_PVT;
279: x_return_status := FND_API.G_RET_STS_ERROR;
280: ITG_Debug.add_error;
281: ITG_Debug.msg('UE', 'EXCEPTION, checked error.', TRUE);

Line 279: x_return_status := FND_API.G_RET_STS_ERROR;

275:
276: EXCEPTION
277: WHEN FND_API.G_EXC_ERROR THEN
278: ROLLBACK TO Update_Effectivity_PVT;
279: x_return_status := FND_API.G_RET_STS_ERROR;
280: ITG_Debug.add_error;
281: ITG_Debug.msg('UE', 'EXCEPTION, checked error.', TRUE);
282:
283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

279: x_return_status := FND_API.G_RET_STS_ERROR;
280: ITG_Debug.add_error;
281: ITG_Debug.msg('UE', 'EXCEPTION, checked error.', TRUE);
282:
283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
284: ROLLBACK TO Update_Effectivity_PVT;
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: ITG_Debug.msg('UE', 'EXCEPTION, un-expected error.', TRUE);
287:

Line 285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

281: ITG_Debug.msg('UE', 'EXCEPTION, checked error.', TRUE);
282:
283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
284: ROLLBACK TO Update_Effectivity_PVT;
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: ITG_Debug.msg('UE', 'EXCEPTION, un-expected error.', TRUE);
287:
288: WHEN OTHERS THEN
289: ROLLBACK TO Update_Effectivity_PVT;

Line 290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

286: ITG_Debug.msg('UE', 'EXCEPTION, un-expected error.', TRUE);
287:
288: WHEN OTHERS THEN
289: ROLLBACK TO Update_Effectivity_PVT;
290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
291: ITG_Debug.add_exc_error(G_PKG_NAME, l_api_name);
292: ITG_Debug.msg('UE', 'EXCEPTION, other error.', TRUE);
293: END;
294: