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_CONFIG_VERSION_PVT dependencies on FND_API

Line 139: x_return_status := FND_API.G_RET_STS_SUCCESS;

135: l_api_name CONSTANT VARCHAR2 (30) := 'VALIDATE_ROW';
136: l_full_name CONSTANT VARCHAR2 (60) := G_PKG_NAME || '.' || l_api_name;
137: BEGIN
138:
139: x_return_status := FND_API.G_RET_STS_SUCCESS;
140: IF NOT fnd_api.compatible_api_call ( l_api_version,
141: p_api_version,
142: l_api_name,
143: G_PKG_NAME

Line 140: IF NOT fnd_api.compatible_api_call ( l_api_version,

136: l_full_name CONSTANT VARCHAR2 (60) := G_PKG_NAME || '.' || l_api_name;
137: BEGIN
138:
139: x_return_status := FND_API.G_RET_STS_SUCCESS;
140: IF NOT fnd_api.compatible_api_call ( l_api_version,
141: p_api_version,
142: l_api_name,
143: G_PKG_NAME
144: )

Line 146: RAISE fnd_api.g_exc_unexpected_error;

142: l_api_name,
143: G_PKG_NAME
144: )
145: THEN
146: RAISE fnd_api.g_exc_unexpected_error;
147: END IF;
148:
149: IF (NOT CHECK_VERSION_NAME_UNIQUE(p_version_rec.version_name,
150: p_version_rec.version_id,

Line 156: x_return_status := fnd_api.g_ret_sts_error;

152: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
153: FND_MESSAGE.set_name('JTS', 'JTS_VERSION_NAME_NOT_UNIQUE');
154: FND_MSG_PUB.add;
155: END IF;
156: x_return_status := fnd_api.g_ret_sts_error;
157: END IF;
158:
159: EXCEPTION
160: WHEN fnd_api.g_exc_unexpected_error THEN

Line 160: WHEN fnd_api.g_exc_unexpected_error THEN

156: x_return_status := fnd_api.g_ret_sts_error;
157: END IF;
158:
159: EXCEPTION
160: WHEN fnd_api.g_exc_unexpected_error THEN
161: x_return_status := fnd_api.g_ret_sts_unexp_error;
162: WHEN OTHERS THEN
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 161: x_return_status := fnd_api.g_ret_sts_unexp_error;

157: END IF;
158:
159: EXCEPTION
160: WHEN fnd_api.g_exc_unexpected_error THEN
161: x_return_status := fnd_api.g_ret_sts_unexp_error;
162: WHEN OTHERS THEN
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
165: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

159: EXCEPTION
160: WHEN fnd_api.g_exc_unexpected_error THEN
161: x_return_status := fnd_api.g_ret_sts_unexp_error;
162: WHEN OTHERS THEN
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
165: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
166: END IF;
167: END VALIDATE_ROW;

Line 188: --IF (FND_API.to_boolean(p_init_version)) THEN --initial version

184:
185: l_config_name := JTS_CONFIGURATION_PVT.get_config_name(p_configuration_id);
186:
187: --nodpfxml
188: --IF (FND_API.to_boolean(p_init_version)) THEN --initial version
189: -- FND_MESSAGE.set_name('JTS', 'JTS_INITIAL_VERSION');
190: -- l_version_name := FND_MESSAGE.get;
191: --ELSE
192: FND_MESSAGE.set_name('JTS', 'JTS_VERSION_NAME');

Line 323: P_commit IN Varchar2 DEFAULT FND_API.G_FALSE,

319: -- description
320: -- configuration_id
321: -----------------------------------------------------------------
322: PROCEDURE CREATE_VERSION(p_api_version IN Number,
323: P_commit IN Varchar2 DEFAULT FND_API.G_FALSE,
324: p_configuration_id IN NUMBER,
325: p_init_version IN VARCHAR2 DEFAULT FND_API.G_FALSE,
326: x_version_id OUT NUMBER,
327: x_return_status OUT VARCHAR2,

Line 325: p_init_version IN VARCHAR2 DEFAULT FND_API.G_FALSE,

321: -----------------------------------------------------------------
322: PROCEDURE CREATE_VERSION(p_api_version IN Number,
323: P_commit IN Varchar2 DEFAULT FND_API.G_FALSE,
324: p_configuration_id IN NUMBER,
325: p_init_version IN VARCHAR2 DEFAULT FND_API.G_FALSE,
326: x_version_id OUT NUMBER,
327: x_return_status OUT VARCHAR2,
328: x_msg_count OUT NUMBER,
329: x_msg_data OUT VARCHAR2) IS

Line 337: x_return_status := FND_API.G_RET_STS_SUCCESS;

333: l_full_name CONSTANT VARCHAR2 (60) := G_PKG_NAME || '.' || l_api_name;
334: l_flows JTS_SETUP_FLOW_PVT.Setup_Flow_Tbl_Type;
335: l_flow_id JTS_CONFIGURATIONS_B.flow_id%TYPE;
336: BEGIN
337: x_return_status := FND_API.G_RET_STS_SUCCESS;
338:
339: -- Standard Start of API savepoint
340: SAVEPOINT create_version;
341:

Line 344: IF NOT fnd_api.compatible_api_call ( l_api_version,

340: SAVEPOINT create_version;
341:
342: fnd_msg_pub.initialize;
343:
344: IF NOT fnd_api.compatible_api_call ( l_api_version,
345: p_api_version,
346: l_api_name,
347: G_PKG_NAME
348: )

Line 350: RAISE fnd_api.g_exc_unexpected_error;

346: l_api_name,
347: G_PKG_NAME
348: )
349: THEN
350: RAISE fnd_api.g_exc_unexpected_error;
351: END IF;
352:
353:
354: If (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 354: If (x_return_status = fnd_api.g_ret_sts_success) THEN

350: RAISE fnd_api.g_exc_unexpected_error;
351: END IF;
352:
353:
354: If (x_return_status = fnd_api.g_ret_sts_success) THEN
355: INSERT_ROW(p_configuration_id,
356: p_init_version,
357: x_version_id);
358:

Line 375: p_commit => FND_API.G_FALSE,

371: p_flow_hiearchy => l_flows);
372:
373: JTS_CONFIG_VER_STATUS_PVT.CREATE_VERSION_STATUS(
374: p_api_version => p_api_version,
375: p_commit => FND_API.G_FALSE,
376: p_version_id => x_version_id,
377: p_status => JTS_CONFIG_VER_STATUS_PVT.C_INIT_VERSION_STATUS);
378:
379: IF (FND_API.to_boolean(p_commit)) THEN

Line 379: IF (FND_API.to_boolean(p_commit)) THEN

375: p_commit => FND_API.G_FALSE,
376: p_version_id => x_version_id,
377: p_status => JTS_CONFIG_VER_STATUS_PVT.C_INIT_VERSION_STATUS);
378:
379: IF (FND_API.to_boolean(p_commit)) THEN
380: COMMIT;
381: END IF;
382:
383: END IF;

Line 386: p_encoded => FND_API.G_FALSE,

382:
383: END IF;
384:
385: FND_MSG_PUB.Count_And_Get (
386: p_encoded => FND_API.G_FALSE,
387: p_count => x_msg_count,
388: p_data => x_msg_data);
389: EXCEPTION
390: WHEN OTHERS THEN

Line 392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

388: p_data => x_msg_data);
389: EXCEPTION
390: WHEN OTHERS THEN
391: ROLLBACK TO create_version;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
394: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
395: END IF;
396: -- Standard call to get message count and if count=1, get the message

Line 398: p_encoded => FND_API.G_FALSE,

394: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
395: END IF;
396: -- Standard call to get message count and if count=1, get the message
397: FND_MSG_PUB.Count_And_Get (
398: p_encoded => FND_API.G_FALSE,
399: p_count => x_msg_count,
400: p_data => x_msg_data
401: );
402: END CREATE_VERSION;

Line 412: IF NOT fnd_api.compatible_api_call ( l_api_version,

408: ) IS
409: l_api_version CONSTANT NUMBER := 1.0;
410: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_VERSION_STAT';
411: BEGIN
412: IF NOT fnd_api.compatible_api_call ( l_api_version,
413: p_api_version,
414: l_api_name,
415: G_PKG_NAME
416: )

Line 418: RAISE fnd_api.g_exc_unexpected_error;

414: l_api_name,
415: G_PKG_NAME
416: )
417: THEN
418: RAISE fnd_api.g_exc_unexpected_error;
419: END IF;
420:
421: UPDATE jts_config_versions_b
422: SET version_status_code = p_status,

Line 440: IF NOT fnd_api.compatible_api_call ( l_api_version,

436: ) IS
437: l_api_version CONSTANT NUMBER := 1.0;
438: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_REPLAY_DATA';
439: BEGIN
440: IF NOT fnd_api.compatible_api_call ( l_api_version,
441: p_api_version,
442: l_api_name,
443: G_PKG_NAME
444: )

Line 446: RAISE fnd_api.g_exc_unexpected_error;

442: l_api_name,
443: G_PKG_NAME
444: )
445: THEN
446: RAISE fnd_api.g_exc_unexpected_error;
447: END IF;
448:
449: UPDATE jts_config_versions_b
450: SET replay_status_code = p_status,

Line 469: IF NOT fnd_api.compatible_api_call ( l_api_version,

465: ) IS
466: l_api_version CONSTANT NUMBER := 1.0;
467: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_LAST_MODIFIED';
468: BEGIN
469: IF NOT fnd_api.compatible_api_call ( l_api_version,
470: p_api_version,
471: l_api_name,
472: G_PKG_NAME
473: )

Line 475: RAISE fnd_api.g_exc_unexpected_error;

471: l_api_name,
472: G_PKG_NAME
473: )
474: THEN
475: RAISE fnd_api.g_exc_unexpected_error;
476: END IF;
477:
478: UPDATE jts_config_versions_b
479: SET last_update_date = sysdate,

Line 504: x_return_status := FND_API.G_RET_STS_SUCCESS;

500: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_NAME_DESC';
501: l_full_name CONSTANT VARCHAR2 (60) := G_PKG_NAME || '.' || l_api_name;
502: l_version_rec Config_Version_Rec_Type;
503: BEGIN
504: x_return_status := FND_API.G_RET_STS_SUCCESS;
505:
506: -- Standard Start of API savepoint
507: SAVEPOINT UPDATE_NAME_DESC;
508:

Line 511: IF NOT fnd_api.compatible_api_call ( l_api_version,

507: SAVEPOINT UPDATE_NAME_DESC;
508:
509: fnd_msg_pub.initialize;
510:
511: IF NOT fnd_api.compatible_api_call ( l_api_version,
512: p_api_version,
513: l_api_name,
514: G_PKG_NAME
515: )

Line 517: RAISE fnd_api.g_exc_unexpected_error;

513: l_api_name,
514: G_PKG_NAME
515: )
516: THEN
517: RAISE fnd_api.g_exc_unexpected_error;
518: END IF;
519:
520: l_version_rec.version_id := p_version_id;
521: l_version_rec.configuration_id := p_config_id;

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

525: VALIDATE_ROW(p_api_version => p_api_version,
526: p_version_rec => l_version_rec,
527: x_return_status => x_return_status);
528:
529: IF (x_return_status = fnd_api.g_ret_sts_success) THEN
530: UPDATE jts_config_versions_b
531: SET version_name = p_version_name,
532: last_update_date = sysdate,
533: last_updated_by = FND_GLOBAL.user_id,

Line 550: p_encoded => FND_API.G_FALSE,

546: COMMIT;
547: END IF;
548:
549: FND_MSG_PUB.Count_And_Get (
550: p_encoded => FND_API.G_FALSE,
551: p_count => x_msg_count,
552: p_data => x_msg_data);
553: EXCEPTION
554: WHEN OTHERS THEN

Line 556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

552: p_data => x_msg_data);
553: EXCEPTION
554: WHEN OTHERS THEN
555: ROLLBACK TO UPDATE_NAME_DESC;
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
557: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
558: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
559: END IF;
560: -- Standard call to get message count and if count=1, get the message

Line 562: p_encoded => FND_API.G_FALSE,

558: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
559: END IF;
560: -- Standard call to get message count and if count=1, get the message
561: FND_MSG_PUB.Count_And_Get (
562: p_encoded => FND_API.G_FALSE,
563: p_count => x_msg_count,
564: p_data => x_msg_data
565: );
566: END UPDATE_NAME_DESC;

Line 571: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

567:
568: -- Deletes a version and its corresponding version_statuses and
569: -- version_flows
570: PROCEDURE DELETE_VERSION(p_api_version IN Number,
571: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
572: p_version_id IN NUMBER
573: ) IS
574: l_api_version CONSTANT NUMBER := 1.0;
575: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_VERSION';

Line 581: IF NOT fnd_api.compatible_api_call ( l_api_version,

577: BEGIN
578: -- Standard Start of API savepoint
579: SAVEPOINT DELETE_VERSION;
580:
581: IF NOT fnd_api.compatible_api_call ( l_api_version,
582: p_api_version,
583: l_api_name,
584: G_PKG_NAME
585: )

Line 587: RAISE fnd_api.g_exc_unexpected_error;

583: l_api_name,
584: G_PKG_NAME
585: )
586: THEN
587: RAISE fnd_api.g_exc_unexpected_error;
588: END IF;
589:
590: JTS_CONFIG_VER_STATUS_PVT.DELETE_VERSION_STATUSES(p_api_version, p_version_id);
591: JTS_CONFIG_VERSION_FLOW_PVT.DELETE_VERSION_FLOWS(p_api_version, p_version_id);

Line 593: IF (FND_API.to_boolean(p_commit)) THEN

589:
590: JTS_CONFIG_VER_STATUS_PVT.DELETE_VERSION_STATUSES(p_api_version, p_version_id);
591: JTS_CONFIG_VERSION_FLOW_PVT.DELETE_VERSION_FLOWS(p_api_version, p_version_id);
592: JTS_CONFIG_VERSIONS_PKG.DELETE_ROW(p_version_id);
593: IF (FND_API.to_boolean(p_commit)) THEN
594: COMMIT;
595: END IF;
596:
597: EXCEPTION

Line 599: IF (FND_API.to_boolean(p_commit)) THEN

595: END IF;
596:
597: EXCEPTION
598: WHEN OTHERS THEN
599: IF (FND_API.to_boolean(p_commit)) THEN
600: ROLLBACK TO DELETE_VERSION;
601: ELSE
602: APP_EXCEPTION.RAISE_EXCEPTION;
603: END IF;

Line 620: IF NOT fnd_api.compatible_api_call ( l_api_version,

616:
617: -- Standard Start of API savepoint
618: SAVEPOINT DELETE_SOME_VERSIONS;
619:
620: IF NOT fnd_api.compatible_api_call ( l_api_version,
621: p_api_version,
622: l_api_name,
623: G_PKG_NAME
624: ) THEN

Line 625: RAISE fnd_api.g_exc_unexpected_error;

621: p_api_version,
622: l_api_name,
623: G_PKG_NAME
624: ) THEN
625: RAISE fnd_api.g_exc_unexpected_error;
626: END IF;
627:
628: FOR I IN 1..p_version_tbl.count LOOP --loop through p_version_tbl
629: DELETE_VERSION(p_api_version => p_api_version,

Line 630: p_commit => FND_API.G_FALSE,

626: END IF;
627:
628: FOR I IN 1..p_version_tbl.count LOOP --loop through p_version_tbl
629: DELETE_VERSION(p_api_version => p_api_version,
630: p_commit => FND_API.G_FALSE,
631: p_version_id => p_version_tbl(i));
632: END LOOP;
633: COMMIT;
634:

Line 650: IF NOT fnd_api.compatible_api_call ( l_api_version,

646: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_VERSIONS';
647: l_full_name CONSTANT VARCHAR2 (60) := G_PKG_NAME || '.' || l_api_name;
648: BEGIN
649:
650: IF NOT fnd_api.compatible_api_call ( l_api_version,
651: p_api_version,
652: l_api_name,
653: G_PKG_NAME
654: )

Line 656: RAISE fnd_api.g_exc_unexpected_error;

652: l_api_name,
653: G_PKG_NAME
654: )
655: THEN
656: RAISE fnd_api.g_exc_unexpected_error;
657: END IF;
658:
659: JTS_CONFIG_VER_STATUS_PVT.DELETE_CONFIG_VER_STATUSES(p_api_version, p_config_id);
660: JTS_CONFIG_VERSION_FLOW_PVT.DELETE_CONFIG_VERSION_FLOWS(p_api_version, p_config_id);

Line 682: x_return_status := FND_API.G_RET_STS_SUCCESS;

678: l_full_name CONSTANT VARCHAR2 (60) := G_PKG_NAME || '.' || l_api_name;
679: l_config_rec JTS_CONFIGURATION_PVT.Config_Rec_Type;
680: l_debug_info VARCHAR2(2000);
681: BEGIN
682: x_return_status := FND_API.G_RET_STS_SUCCESS;
683:
684: fnd_msg_pub.initialize;
685:
686: IF NOT fnd_api.compatible_api_call ( l_api_version,

Line 686: IF NOT fnd_api.compatible_api_call ( l_api_version,

682: x_return_status := FND_API.G_RET_STS_SUCCESS;
683:
684: fnd_msg_pub.initialize;
685:
686: IF NOT fnd_api.compatible_api_call ( l_api_version,
687: p_api_version,
688: l_api_name,
689: G_PKG_NAME
690: )

Line 692: RAISE fnd_api.g_exc_unexpected_error;

688: l_api_name,
689: G_PKG_NAME
690: )
691: THEN
692: RAISE fnd_api.g_exc_unexpected_error;
693: END IF;
694:
695: l_debug_info := 'Version select';
696: SELECT configuration_id, version_id, version_name, version_number, v.description, queue_name,

Line 757: p_init_msg_list => FND_API.G_FALSE,

753: l_debug_info := 'Configuration';
754: -- Get Configuration Data for Version
755: JTS_CONFIGURATION_PVT.GET_CONFIGURATION(
756: p_api_version => p_api_version,
757: p_init_msg_list => FND_API.G_FALSE,
758: p_config_id => x_version_rec.configuration_id,
759: x_configuration_rec => l_config_rec,
760: x_return_status => x_return_status,
761: x_msg_count => x_msg_count,

Line 765: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

761: x_msg_count => x_msg_count,
762: x_msg_data => x_msg_data
763: );
764:
765: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
766: raise fnd_api.g_exc_unexpected_error;
767: END IF;
768:
769: l_debug_info := 'Set Record';

Line 766: raise fnd_api.g_exc_unexpected_error;

762: x_msg_data => x_msg_data
763: );
764:
765: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
766: raise fnd_api.g_exc_unexpected_error;
767: END IF;
768:
769: l_debug_info := 'Set Record';
770: -- Store Configuration Data for Version in the version record

Line 784: p_encoded => FND_API.G_FALSE,

780: x_version_rec.percent_completed := JTS_CONFIG_VERSION_FLOW_PVT.GET_PERCENT_COMPLETE(p_api_version,
781: x_version_rec.version_id);
782:
783: FND_MSG_PUB.Count_And_Get (
784: p_encoded => FND_API.G_FALSE,
785: p_count => x_msg_count,
786: p_data => x_msg_data);
787: EXCEPTION
788: WHEN OTHERS THEN

Line 789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

785: p_count => x_msg_count,
786: p_data => x_msg_data);
787: EXCEPTION
788: WHEN OTHERS THEN
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
790: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
791: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
792: END IF;
793: -- Standard call to get message count and if count=1, get the message

Line 795: p_encoded => FND_API.G_FALSE,

791: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
792: END IF;
793: -- Standard call to get message count and if count=1, get the message
794: FND_MSG_PUB.Count_And_Get (
795: p_encoded => FND_API.G_FALSE,
796: p_count => x_msg_count,
797: p_data => x_msg_data
798: );
799: END GET_VERSION;

Line 827: x_return_status := fnd_api.G_RET_STS_SUCCESS;

823: l_how_to_order VARCHAR2(30);
824: l_order_by VARCHAR2(30) := upper(p_order_by);
825: BEGIN
826:
827: x_return_status := fnd_api.G_RET_STS_SUCCESS;
828:
829: fnd_msg_pub.initialize;
830:
831: IF NOT fnd_api.compatible_api_call ( l_api_version,

Line 831: IF NOT fnd_api.compatible_api_call ( l_api_version,

827: x_return_status := fnd_api.G_RET_STS_SUCCESS;
828:
829: fnd_msg_pub.initialize;
830:
831: IF NOT fnd_api.compatible_api_call ( l_api_version,
832: p_api_version,
833: l_api_name,
834: G_PKG_NAME
835: )

Line 837: RAISE fnd_api.g_exc_unexpected_error;

833: l_api_name,
834: G_PKG_NAME
835: )
836: THEN
837: RAISE fnd_api.g_exc_unexpected_error;
838: END IF;
839:
840:
841: -- Get Configuration Data for Version

Line 844: p_init_msg_list => FND_API.G_FALSE,

840:
841: -- Get Configuration Data for Version
842: JTS_CONFIGURATION_PVT.GET_CONFIGURATION(
843: p_api_version => p_api_version,
844: p_init_msg_list => FND_API.G_FALSE,
845: p_config_id => p_config_id,
846: x_configuration_rec => l_config_rec,
847: x_return_status => x_return_status,
848: x_msg_count => x_msg_count,

Line 852: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

848: x_msg_count => x_msg_count,
849: x_msg_data => x_msg_data
850: );
851:
852: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
853: raise fnd_api.g_exc_unexpected_error;
854: END IF;
855:
856: l_how_to_order := substrb(upper(p_how_to_order), 1, 30);

Line 853: raise fnd_api.g_exc_unexpected_error;

849: x_msg_data => x_msg_data
850: );
851:
852: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
853: raise fnd_api.g_exc_unexpected_error;
854: END IF;
855:
856: l_how_to_order := substrb(upper(p_how_to_order), 1, 30);
857: IF (l_how_to_order <> 'ASC' AND l_how_to_order <> 'DESC') THEN

Line 963: p_encoded => FND_API.G_FALSE,

959: END LOOP;
960: CLOSE version_csr;
961:
962: FND_MSG_PUB.Count_And_Get (
963: p_encoded => FND_API.G_FALSE,
964: p_count => x_msg_count,
965: p_data => x_msg_data
966: );
967:

Line 970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

966: );
967:
968: EXCEPTION
969: WHEN OTHERS THEN
970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
971: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
972: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
973: END IF;
974: -- Standard call to get message count and if count=1, get the message

Line 976: p_encoded => FND_API.G_FALSE,

972: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
973: END IF;
974: -- Standard call to get message count and if count=1, get the message
975: FND_MSG_PUB.Count_And_Get (
976: p_encoded => FND_API.G_FALSE,
977: p_count => x_msg_count,
978: p_data => x_msg_data
979: );
980: END GET_VERSIONS;