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

Line 217: x_return_status := fnd_api.g_ret_sts_success;

213: l_api_name CONSTANT VARCHAR2 (30) := 'VALIDATE_ROW';
214: l_full_name CONSTANT VARCHAR2 (60) := G_PKG_NAME || '.' || l_api_name;
215: BEGIN
216:
217: x_return_status := fnd_api.g_ret_sts_success;
218:
219: IF NOT fnd_api.compatible_api_call ( l_api_version,
220: p_api_version,
221: l_api_name,

Line 219: IF NOT fnd_api.compatible_api_call ( l_api_version,

215: BEGIN
216:
217: x_return_status := fnd_api.g_ret_sts_success;
218:
219: IF NOT fnd_api.compatible_api_call ( l_api_version,
220: p_api_version,
221: l_api_name,
222: G_PKG_NAME
223: )

Line 225: RAISE fnd_api.g_exc_unexpected_error;

221: l_api_name,
222: G_PKG_NAME
223: )
224: THEN
225: RAISE fnd_api.g_exc_unexpected_error;
226: END IF;
227:
228: IF (NOT CHECK_CONFIG_NAME_UNIQUE(p_configuration_rec.config_name, p_configuration_rec.configuration_id)) THEN
229: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

Line 233: x_return_status := fnd_api.g_ret_sts_error;

229: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
230: fnd_message.set_name('JTS', 'JTS_CONFIG_NAME_EXISTS');
231: fnd_msg_pub.add;
232: END IF;
233: x_return_status := fnd_api.g_ret_sts_error;
234: END IF;
235:
236: IF (NOT CHECK_FLOW_EXISTS(p_configuration_rec.flow_id)) THEN
237: raise FND_API.g_exc_unexpected_error;

Line 237: raise FND_API.g_exc_unexpected_error;

233: x_return_status := fnd_api.g_ret_sts_error;
234: END IF;
235:
236: IF (NOT CHECK_FLOW_EXISTS(p_configuration_rec.flow_id)) THEN
237: raise FND_API.g_exc_unexpected_error;
238: END IF;
239:
240: EXCEPTION
241: WHEN fnd_api.g_exc_unexpected_error THEN

Line 241: WHEN fnd_api.g_exc_unexpected_error THEN

237: raise FND_API.g_exc_unexpected_error;
238: END IF;
239:
240: EXCEPTION
241: WHEN fnd_api.g_exc_unexpected_error THEN
242: x_return_status := fnd_api.g_ret_sts_unexp_error;
243: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name || ': flow_id not found');
244: WHEN OTHERS THEN
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 242: x_return_status := fnd_api.g_ret_sts_unexp_error;

238: END IF;
239:
240: EXCEPTION
241: WHEN fnd_api.g_exc_unexpected_error THEN
242: x_return_status := fnd_api.g_ret_sts_unexp_error;
243: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name || ': flow_id not found');
244: WHEN OTHERS THEN
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

241: WHEN fnd_api.g_exc_unexpected_error THEN
242: x_return_status := fnd_api.g_ret_sts_unexp_error;
243: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name || ': flow_id not found');
244: WHEN OTHERS THEN
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
247: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
248: END IF;
249: END VALIDATE_ROW;

Line 275: x_return_status := fnd_api.G_RET_STS_SUCCESS;

271: l_version_id JTS_CONFIG_VERSIONS_B.version_id%TYPE;
272: --l_version_rec JTS_CONFIG_VERSION_PVT.Config_Version_Rec_Type;
273: l_flows JTS_SETUP_FLOW_PVT.Setup_Flow_Tbl_Type;
274: BEGIN
275: x_return_status := fnd_api.G_RET_STS_SUCCESS;
276:
277: -- Standard Start of API savepoint
278: SAVEPOINT create_configuration;
279:

Line 282: IF NOT fnd_api.compatible_api_call ( l_api_version,

278: SAVEPOINT create_configuration;
279:
280: fnd_msg_pub.initialize;
281:
282: IF NOT fnd_api.compatible_api_call ( l_api_version,
283: p_api_version,
284: l_api_name,
285: G_PKG_NAME
286: )

Line 288: RAISE fnd_api.g_exc_unexpected_error;

284: l_api_name,
285: G_PKG_NAME
286: )
287: THEN
288: RAISE fnd_api.g_exc_unexpected_error;
289: END IF;
290:
291: VALIDATE_ROW(p_api_version,
292: p_configuration_rec,

Line 295: IF (x_return_status = fnd_api.g_ret_sts_success) THEN

291: VALIDATE_ROW(p_api_version,
292: p_configuration_rec,
293: x_return_status ); --server-side validation for unique name
294:
295: IF (x_return_status = fnd_api.g_ret_sts_success) THEN
296: INSERT_ROW(p_configuration_rec,
297: x_config_id);
298: --Create the initial version
299: --FND_MESSAGE.set_name('JTS', 'JTS_INITIAL_VERSION');

Line 308: p_commit => FND_API.G_FALSE,

304: --l_version_rec.description := FND_MESSAGE.get;
305:
306: JTS_CONFIG_VERSION_PVT.CREATE_VERSION(
307: p_api_version => p_api_version,
308: p_commit => FND_API.G_FALSE,
309: p_configuration_id => x_config_id,
310: p_init_version => FND_API.G_TRUE,
311: x_version_id => l_version_id,
312: x_return_status => x_return_status,

Line 310: p_init_version => FND_API.G_TRUE,

306: JTS_CONFIG_VERSION_PVT.CREATE_VERSION(
307: p_api_version => p_api_version,
308: p_commit => FND_API.G_FALSE,
309: p_configuration_id => x_config_id,
310: p_init_version => FND_API.G_TRUE,
311: x_version_id => l_version_id,
312: x_return_status => x_return_status,
313: x_msg_count => x_msg_count,
314: x_msg_data => x_msg_data);

Line 315: IF (x_return_status = fnd_api.g_ret_sts_success) THEN

311: x_version_id => l_version_id,
312: x_return_status => x_return_status,
313: x_msg_count => x_msg_count,
314: x_msg_data => x_msg_data);
315: IF (x_return_status = fnd_api.g_ret_sts_success) THEN
316: Commit;
317: ELSE
318: raise fnd_api.g_exc_unexpected_error;
319: END IF;

Line 318: raise fnd_api.g_exc_unexpected_error;

314: x_msg_data => x_msg_data);
315: IF (x_return_status = fnd_api.g_ret_sts_success) THEN
316: Commit;
317: ELSE
318: raise fnd_api.g_exc_unexpected_error;
319: END IF;
320: END IF;
321:
322: fnd_msg_pub.count_and_get (

Line 323: p_encoded=> fnd_api.g_false

319: END IF;
320: END IF;
321:
322: fnd_msg_pub.count_and_get (
323: p_encoded=> fnd_api.g_false
324: ,p_count=> x_msg_count
325: ,p_data=> x_msg_data
326: );
327:

Line 329: WHEN FND_API.G_EXC_ERROR THEN

325: ,p_data=> x_msg_data
326: );
327:
328: EXCEPTION
329: WHEN FND_API.G_EXC_ERROR THEN
330: ROLLBACK TO create_configuration;
331: x_return_status := FND_API.G_RET_STS_ERROR;
332: -- Standard call to get message count and if count=1, get the message
333: FND_MSG_PUB.Count_And_Get (

Line 331: x_return_status := FND_API.G_RET_STS_ERROR;

327:
328: EXCEPTION
329: WHEN FND_API.G_EXC_ERROR THEN
330: ROLLBACK TO create_configuration;
331: x_return_status := FND_API.G_RET_STS_ERROR;
332: -- Standard call to get message count and if count=1, get the message
333: FND_MSG_PUB.Count_And_Get (
334: p_encoded => FND_API.G_FALSE,
335: p_count => x_msg_count,

Line 334: p_encoded => FND_API.G_FALSE,

330: ROLLBACK TO create_configuration;
331: x_return_status := FND_API.G_RET_STS_ERROR;
332: -- Standard call to get message count and if count=1, get the message
333: FND_MSG_PUB.Count_And_Get (
334: p_encoded => FND_API.G_FALSE,
335: p_count => x_msg_count,
336: p_data => x_msg_data
337: );
338: WHEN OTHERS THEN

Line 340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

336: p_data => x_msg_data
337: );
338: WHEN OTHERS THEN
339: ROLLBACK TO create_configuration;
340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
341: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
342: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
343: END IF;
344: -- Standard call to get message count and if count=1, get the message

Line 346: p_encoded => FND_API.G_FALSE,

342: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
343: END IF;
344: -- Standard call to get message count and if count=1, get the message
345: FND_MSG_PUB.Count_And_Get (
346: p_encoded => FND_API.G_FALSE,
347: p_count => x_msg_count,
348: p_data => x_msg_data
349: );
350: END CREATE_CONFIGURATION;

Line 374: x_return_status := fnd_api.g_ret_sts_success;

370: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_ NAME_DESC';
371: l_full_name CONSTANT VARCHAR2 (60) := G_PKG_NAME || '.' || l_api_name;
372: l_config_rec Config_Rec_Type;
373: BEGIN
374: x_return_status := fnd_api.g_ret_sts_success;
375:
376: -- Standard Start of API savepoint
377: SAVEPOINT update_name_and_desc;
378:

Line 381: IF NOT fnd_api.compatible_api_call ( l_api_version,

377: SAVEPOINT update_name_and_desc;
378:
379: Fnd_msg_pub.initialize;
380:
381: IF NOT fnd_api.compatible_api_call ( l_api_version,
382: p_api_version,
383: l_api_name,
384: G_PKG_NAME
385: )

Line 387: RAISE fnd_api.g_exc_unexpected_error;

383: l_api_name,
384: G_PKG_NAME
385: )
386: THEN
387: RAISE fnd_api.g_exc_unexpected_error;
388: END IF;
389:
390: l_config_rec.configuration_id := p_config_id;
391: l_config_rec.config_name := p_config_name;

Line 399: IF (x_return_status = fnd_api.g_ret_sts_success) THEN

395: VALIDATE_ROW(p_api_version => p_api_version,
396: p_configuration_rec => l_config_rec,
397: x_return_status => x_return_status);
398:
399: IF (x_return_status = fnd_api.g_ret_sts_success) THEN
400: UPDATE jts_configurations_b
401: SET config_name = p_config_name,
402: last_update_date = sysdate,
403: last_updated_by = FND_GLOBAL.user_id,

Line 420: p_encoded => FND_API.G_FALSE,

416: COMMIT;
417: END IF;
418:
419: FND_MSG_PUB.Count_And_Get (
420: p_encoded => FND_API.G_FALSE,
421: p_count => x_msg_count,
422: p_data => x_msg_data
423: );
424: EXCEPTION

Line 425: WHEN FND_API.G_EXC_ERROR THEN

421: p_count => x_msg_count,
422: p_data => x_msg_data
423: );
424: EXCEPTION
425: WHEN FND_API.G_EXC_ERROR THEN
426: ROLLBACK TO update_name_and_desc;
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: -- Standard call to get message count and if count=1, get the message
429: FND_MSG_PUB.Count_And_Get (

Line 427: x_return_status := FND_API.G_RET_STS_ERROR;

423: );
424: EXCEPTION
425: WHEN FND_API.G_EXC_ERROR THEN
426: ROLLBACK TO update_name_and_desc;
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: -- Standard call to get message count and if count=1, get the message
429: FND_MSG_PUB.Count_And_Get (
430: p_encoded => FND_API.G_FALSE,
431: p_count => x_msg_count,

Line 430: p_encoded => FND_API.G_FALSE,

426: ROLLBACK TO update_name_and_desc;
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: -- Standard call to get message count and if count=1, get the message
429: FND_MSG_PUB.Count_And_Get (
430: p_encoded => FND_API.G_FALSE,
431: p_count => x_msg_count,
432: p_data => x_msg_data
433: );
434: WHEN OTHERS THEN

Line 436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

432: p_data => x_msg_data
433: );
434: WHEN OTHERS THEN
435: ROLLBACK TO update_name_and_desc;
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
437: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
438: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
439: END IF;
440: -- Standard call to get message count and if count=1, get the message

Line 442: p_encoded => FND_API.G_FALSE,

438: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
439: END IF;
440: -- Standard call to get message count and if count=1, get the message
441: FND_MSG_PUB.Count_And_Get (
442: p_encoded => FND_API.G_FALSE,
443: p_count => x_msg_count,
444: p_data => x_msg_data
445: );
446: END UPDATE_NAME_DESC;

Line 461: x_return_status := FND_API.G_RET_STS_SUCCESS;

457: l_api_version CONSTANT NUMBER := 1.0;
458: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_CONFIGURATION';
459: l_full_name CONSTANT VARCHAR2 (60) := G_PKG_NAME || '.' || l_api_name;
460: BEGIN
461: x_return_status := FND_API.G_RET_STS_SUCCESS;
462:
463: -- Standard Start of API savepoint
464: SAVEPOINT delete_configuration;
465:

Line 468: IF NOT fnd_api.compatible_api_call ( l_api_version,

464: SAVEPOINT delete_configuration;
465:
466: fnd_msg_pub.initialize;
467:
468: IF NOT fnd_api.compatible_api_call ( l_api_version,
469: p_api_version,
470: l_api_name,
471: G_PKG_NAME
472: )

Line 474: RAISE fnd_api.g_exc_unexpected_error;

470: l_api_name,
471: G_PKG_NAME
472: )
473: THEN
474: RAISE fnd_api.g_exc_unexpected_error;
475: END IF;
476:
477: JTS_CONFIG_VERSION_PVT.DELETE_VERSIONS(p_api_version,
478: p_config_id);

Line 483: p_encoded => FND_API.G_FALSE,

479: JTS_CONFIGURATIONS_PKG.DELETE_ROW(p_config_id);
480: Commit;
481:
482: FND_MSG_PUB.Count_And_Get (
483: p_encoded => FND_API.G_FALSE,
484: p_count => x_msg_count,
485: p_data => x_msg_data
486: );
487: EXCEPTION

Line 490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

486: );
487: EXCEPTION
488: WHEN OTHERS THEN
489: ROLLBACK TO delete_configuration;
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
491: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
492: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
493: END IF;
494: -- Standard call to get message count and if count=1, get the message

Line 496: p_encoded => FND_API.G_FALSE,

492: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
493: END IF;
494: -- Standard call to get message count and if count=1, get the message
495: FND_MSG_PUB.Count_And_Get (
496: p_encoded => FND_API.G_FALSE,
497: p_count => x_msg_count,
498: p_data => x_msg_data
499: );
500: END DELETE_CONFIGURATION;

Line 505: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

501:
502: -- Retrieves a configuration given a config_id
503: PROCEDURE GET_CONFIGURATION(
504: p_api_version IN NUMBER,
505: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
506: p_config_id IN NUMBER,
507: x_configuration_rec OUT NOCOPY Config_Rec_Type,
508: x_return_status OUT VARCHAR2,
509: x_msg_count OUT NUMBER,

Line 517: x_return_status := fnd_api.G_RET_STS_SUCCESS;

513: l_api_name CONSTANT VARCHAR2 (30) := 'GET_CONFIGURATION';
514: l_full_name CONSTANT VARCHAR2 (60) := G_PKG_NAME || '.' || l_api_name;
515:
516: BEGIN
517: x_return_status := fnd_api.G_RET_STS_SUCCESS;
518:
519: IF (FND_API.to_boolean(p_init_msg_list)) THEN
520: fnd_msg_pub.initialize;
521: END IF;

Line 519: IF (FND_API.to_boolean(p_init_msg_list)) THEN

515:
516: BEGIN
517: x_return_status := fnd_api.G_RET_STS_SUCCESS;
518:
519: IF (FND_API.to_boolean(p_init_msg_list)) THEN
520: fnd_msg_pub.initialize;
521: END IF;
522:
523: IF NOT fnd_api.compatible_api_call ( l_api_version,

Line 523: IF NOT fnd_api.compatible_api_call ( l_api_version,

519: IF (FND_API.to_boolean(p_init_msg_list)) THEN
520: fnd_msg_pub.initialize;
521: END IF;
522:
523: IF NOT fnd_api.compatible_api_call ( l_api_version,
524: p_api_version,
525: l_api_name,
526: G_PKG_NAME
527: )

Line 529: RAISE fnd_api.g_exc_unexpected_error;

525: l_api_name,
526: G_PKG_NAME
527: )
528: THEN
529: RAISE fnd_api.g_exc_unexpected_error;
530: END IF;
531:
532: SELECT c.configuration_id, c.config_name, c.description, c.flow_id, fl.flow_name, fl.flow_type,
533: lf.meaning, c.record_mode, l.meaning, c.attribute_category, c.attribute1, c.attribute2,

Line 556: p_encoded => FND_API.G_FALSE,

552: AND u1.user_id (+) = c.created_by
553: AND u2.user_id (+) = c.last_updated_by;
554:
555: FND_MSG_PUB.Count_And_Get (
556: p_encoded => FND_API.G_FALSE,
557: p_count => x_msg_count,
558: p_data => x_msg_data
559: );
560:

Line 563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

559: );
560:
561: EXCEPTION
562: WHEN OTHERS THEN
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
565: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
566: END IF;
567: -- Standard call to get message count and if count=1, get the message

Line 569: p_encoded => FND_API.G_FALSE,

565: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
566: END IF;
567: -- Standard call to get message count and if count=1, get the message
568: FND_MSG_PUB.Count_And_Get (
569: p_encoded => FND_API.G_FALSE,
570: p_count => x_msg_count,
571: p_data => x_msg_data
572: );
573: END GET_CONFIGURATION;

Line 599: x_return_status := fnd_api.G_RET_STS_SUCCESS;

595: l_how_to_order VARCHAR2(30);
596: l_order_by VARCHAR2(30) := upper(p_order_by);
597: BEGIN
598:
599: x_return_status := fnd_api.G_RET_STS_SUCCESS;
600:
601: fnd_msg_pub.initialize;
602:
603: IF NOT fnd_api.compatible_api_call ( l_api_version,

Line 603: IF NOT fnd_api.compatible_api_call ( l_api_version,

599: x_return_status := fnd_api.G_RET_STS_SUCCESS;
600:
601: fnd_msg_pub.initialize;
602:
603: IF NOT fnd_api.compatible_api_call ( l_api_version,
604: p_api_version,
605: l_api_name,
606: G_PKG_NAME
607: )

Line 609: RAISE fnd_api.g_exc_unexpected_error;

605: l_api_name,
606: G_PKG_NAME
607: )
608: THEN
609: RAISE fnd_api.g_exc_unexpected_error;
610: END IF;
611:
612: l_how_to_order := substrb(upper(p_how_to_order), 1,30);
613: IF (l_how_to_order <> 'ASC' AND l_how_to_order <> 'DESC') THEN

Line 696: p_encoded => FND_API.G_FALSE,

692: END LOOP;
693: CLOSE config_csr;
694:
695: FND_MSG_PUB.Count_And_Get (
696: p_encoded => FND_API.G_FALSE,
697: p_count => x_msg_count,
698: p_data => x_msg_data
699: );
700:

Line 703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

699: );
700:
701: EXCEPTION
702: WHEN OTHERS THEN
703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
704: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
705: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
706: END IF;
707: -- Standard call to get message count and if count=1, get the message

Line 709: p_encoded => FND_API.G_FALSE,

705: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
706: END IF;
707: -- Standard call to get message count and if count=1, get the message
708: FND_MSG_PUB.Count_And_Get (
709: p_encoded => FND_API.G_FALSE,
710: p_count => x_msg_count,
711: p_data => x_msg_data
712: );
713: END GET_CONFIGURATIONS;