APPS.AMS_DMSELECTION_PVT dependencies on FND_API

Line 529: x_return_status := FND_API.G_RET_STS_SUCCESS;

525: l_return_status VARCHAR2(1);
526: l_return_status_log VARCHAR2(1);
527: BEGIN
528: -- Initialize API return status to SUCCESS
529: x_return_status := FND_API.G_RET_STS_SUCCESS;
530:
531: AMS_Utility_PVT.create_log (
532: x_return_status => l_return_status_log,
533: p_arc_log_used_by => p_arc_object,

Line 587: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

583: p_log_used_by_id => p_object_id,
584: p_msg_data => L_API_NAME || ': After purge_target_staging Status= ' || l_return_status
585: );
586:
587: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: END IF;
590:
591: -- populate the staging table by going

Line 588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

584: p_msg_data => L_API_NAME || ': After purge_target_staging Status= ' || l_return_status
585: );
586:
587: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: END IF;
590:
591: -- populate the staging table by going
592: -- against all the different data sources.

Line 607: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

603: p_log_used_by_id => p_object_id,
604: p_msg_data => L_API_NAME || ': After populate_target_staging Status= ' || l_return_status
605: );
606:
607: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
609: END IF;
610:
611: -- Only need to summarize the targeted column if

Line 608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

604: p_msg_data => L_API_NAME || ': After populate_target_staging Status= ' || l_return_status
605: );
606:
607: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
609: END IF;
610:
611: -- Only need to summarize the targeted column if
612: -- process is model building -- target value is

Line 630: , p_init_msg_list => FND_API.g_false

626: );
627: IF l_seeded_data_source = FALSE AND l_target_attached_to_seeded = TRUE THEN
628: AMS_DMExtract_pvt.ExtractMain (
629: p_api_version => 1.0
630: , p_init_msg_list => FND_API.g_false
631: , p_commit => FND_API.g_true
632: , x_return_status => l_return_status
633: , x_msg_count => l_msg_count
634: , x_msg_data => l_msg_data

Line 631: , p_commit => FND_API.g_true

627: IF l_seeded_data_source = FALSE AND l_target_attached_to_seeded = TRUE THEN
628: AMS_DMExtract_pvt.ExtractMain (
629: p_api_version => 1.0
630: , p_init_msg_list => FND_API.g_false
631: , p_commit => FND_API.g_true
632: , x_return_status => l_return_status
633: , x_msg_count => l_msg_count
634: , x_msg_data => l_msg_data
635: , p_mode => 'I'

Line 640: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

636: , p_model_id => p_object_id
637: , p_model_type => p_arc_object
638: );
639: END IF;
640: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
642: END IF;
643: populate_targets (
644: p_model_id => p_object_id,

Line 641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

637: , p_model_type => p_arc_object
638: );
639: END IF;
640: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
642: END IF;
643: populate_targets (
644: p_model_id => p_object_id,
645: p_seeded_data_source => l_seeded_data_source,

Line 656: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

652: p_log_used_by_id => p_object_id,
653: p_msg_data => L_API_NAME || ': After populate_targets Status= ' || l_return_status
654: );
655:
656: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
658: END IF;
659: END IF;
660:

Line 657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

653: p_msg_data => L_API_NAME || ': After populate_targets Status= ' || l_return_status
654: );
655:
656: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
658: END IF;
659: END IF;
660:
661: -- Update the list select actions table

Line 679: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

675: p_log_used_by_id => p_object_id,
676: p_msg_data => L_API_NAME || ': After update_action_summary Status= ' || l_return_status
677: );
678:
679: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
681: END IF;
682:
683: -- Insert into ams_dm_source a distinct set of parties

Line 680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

676: p_msg_data => L_API_NAME || ': After update_action_summary Status= ' || l_return_status
677: );
678:
679: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
681: END IF;
682:
683: -- Insert into ams_dm_source a distinct set of parties
684: -- with target values where applicable. If a party has

Line 700: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

696: p_msg_data => L_API_NAME || ': After populate_source Status= ' || l_return_status
697: );
698:
699:
700: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
702: END IF;
703:
704: -- purge the data from all staging tables.

Line 701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

697: );
698:
699:
700: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
702: END IF;
703:
704: -- purge the data from all staging tables.
705: purge_target_staging (

Line 714: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

710: p_count => 'FINAL',
711: x_return_status => l_return_status
712: );
713:
714: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
716: END IF;
717:
718:

Line 715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

711: x_return_status => l_return_status
712: );
713:
714: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
716: END IF;
717:
718:
719: EXCEPTION

Line 720: WHEN FND_API.G_EXC_ERROR THEN

716: END IF;
717:
718:
719: EXCEPTION
720: WHEN FND_API.G_EXC_ERROR THEN
721: x_return_status := FND_API.G_RET_STS_ERROR;
722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: WHEN OTHERS THEN

Line 721: x_return_status := FND_API.G_RET_STS_ERROR;

717:
718:
719: EXCEPTION
720: WHEN FND_API.G_EXC_ERROR THEN
721: x_return_status := FND_API.G_RET_STS_ERROR;
722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: WHEN OTHERS THEN
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

718:
719: EXCEPTION
720: WHEN FND_API.G_EXC_ERROR THEN
721: x_return_status := FND_API.G_RET_STS_ERROR;
722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: WHEN OTHERS THEN
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

719: EXCEPTION
720: WHEN FND_API.G_EXC_ERROR THEN
721: x_return_status := FND_API.G_RET_STS_ERROR;
722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: WHEN OTHERS THEN
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
727: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

721: x_return_status := FND_API.G_RET_STS_ERROR;
722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: WHEN OTHERS THEN
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
727: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
728: END IF;
729: END Preview_Selections;

Line 745: x_return_status := FND_API.G_RET_STS_SUCCESS;

741: IS
742: L_API_NAME CONSTANT VARCHAR2(30) := 'Aggregate Selections';
743: BEGIN
744: -- Initialize API return status to SUCCESS
745: x_return_status := FND_API.G_RET_STS_SUCCESS;
746:
747: -- Re-perform the preview selections to
748: -- generate the source data set. If user
749: -- has removed some selections, we cannot

Line 757: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

753: p_arc_object => p_arc_object,
754: p_object_id => p_object_id,
755: x_return_status => x_return_status
756: );
757: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
759: END IF;
760:
761: /* - choang - 04-jun-2002 - callout replaced with logic in populate_source

Line 758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

754: p_object_id => p_object_id,
755: x_return_status => x_return_status
756: );
757: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
759: END IF;
760:
761: /* - choang - 04-jun-2002 - callout replaced with logic in populate_source
762: and populate_targets

Line 768: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

764: p_object_type => p_arc_object,
765: p_object_id => p_object_id,
766: x_return_status => x_return_status
767: );
768: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
770: END IF;
771: */
772: EXCEPTION

Line 769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

765: p_object_id => p_object_id,
766: x_return_status => x_return_status
767: );
768: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
770: END IF;
771: */
772: EXCEPTION
773: /*

Line 774: WHEN FND_API.G_EXC_ERROR THEN

770: END IF;
771: */
772: EXCEPTION
773: /*
774: WHEN FND_API.G_EXC_ERROR THEN
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
778: */

Line 775: x_return_status := FND_API.G_RET_STS_ERROR;

771: */
772: EXCEPTION
773: /*
774: WHEN FND_API.G_EXC_ERROR THEN
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
778: */
779: WHEN OTHERS THEN

Line 776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

772: EXCEPTION
773: /*
774: WHEN FND_API.G_EXC_ERROR THEN
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
778: */
779: WHEN OTHERS THEN
780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

773: /*
774: WHEN FND_API.G_EXC_ERROR THEN
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
778: */
779: WHEN OTHERS THEN
780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
781: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
778: */
779: WHEN OTHERS THEN
780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
781: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
782: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
783: END IF;
784: END Aggregate_Selections;

Line 868: x_return_status := FND_API.G_RET_STS_SUCCESS;

864: l_insert_string VARCHAR2(32000);
865: l_is_b2b_custprof BOOLEAN := FALSE;
866: BEGIN
867: -- Initialize API return status to SUCCESS
868: x_return_status := FND_API.G_RET_STS_SUCCESS;
869:
870: l_model_id:=p_object_for_id;
871:
872: IF p_arc_object_for = 'MODL' THEN

Line 912: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

908: validate_product_selections (
909: p_model_id => l_model_id,
910: x_return_status => x_return_status
911: );
912: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
913: RAISE FND_API.G_EXC_ERROR;
914: END IF;
915: END IF;
916: -- process all the source selections

Line 913: RAISE FND_API.G_EXC_ERROR;

909: p_model_id => l_model_id,
910: x_return_status => x_return_status
911: );
912: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
913: RAISE FND_API.G_EXC_ERROR;
914: END IF;
915: END IF;
916: -- process all the source selections
917: FOR l_object_rec IN c_objects (p_arc_object_for, p_object_for_id) LOOP

Line 939: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

935: p_select_object_type => l_object_rec.arc_incl_object_from,
936: p_select_object_id => l_object_rec.incl_object_id,
937: x_return_status => x_return_status
938: );
939: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
940: RAISE FND_API.G_EXC_ERROR;
941: END IF;
942:
943: get_insert_fields (

Line 940: RAISE FND_API.G_EXC_ERROR;

936: p_select_object_id => l_object_rec.incl_object_id,
937: x_return_status => x_return_status
938: );
939: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
940: RAISE FND_API.G_EXC_ERROR;
941: END IF;
942:
943: get_insert_fields (
944: p_select_object_type => l_object_rec.arc_incl_object_from,

Line 953: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

949: x_insert_fields => l_insert_fields,
950: x_return_status => x_return_status,
951: x_pk_field => l_pk_field
952: );
953: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
955: END IF;
956:
957: get_from_clause (

Line 954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

950: x_return_status => x_return_status,
951: x_pk_field => l_pk_field
952: );
953: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
955: END IF;
956:
957: get_from_clause (
958: p_select_object_type => l_object_rec.arc_incl_object_from,

Line 967: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

963: p_is_b2b_custprof => l_is_b2b_custprof,
964: x_from_clause => l_from_clause,
965: x_return_status => x_return_status
966: );
967: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
969: END IF;
970:
971: get_where_clause (

Line 968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

964: x_from_clause => l_from_clause,
965: x_return_status => x_return_status
966: );
967: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
969: END IF;
970:
971: get_where_clause (
972: p_object_type => p_arc_object_for,

Line 983: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

979: p_is_b2b_custprof => l_is_b2b_custprof,
980: x_where_clause => l_where_clause,
981: x_return_status => x_return_status
982: );
983: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
985: END IF;
986:
987: -- kbasavar For Customer Profitability

Line 984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

980: x_where_clause => l_where_clause,
981: x_return_status => x_return_status
982: );
983: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
985: END IF;
986:
987: -- kbasavar For Customer Profitability
988: IF l_is_b2b AND l_model_type='CUSTOMER_PROFITABILITY' THEN

Line 1053: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1049: x_insert_fields => l_insert_fields,
1050: x_return_status => x_return_status,
1051: x_pk_field => l_pk_field
1052: );
1053: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1055: END IF;
1056:
1057: get_from_clause (

Line 1054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1050: x_return_status => x_return_status,
1051: x_pk_field => l_pk_field
1052: );
1053: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1055: END IF;
1056:
1057: get_from_clause (
1058: p_select_object_type => G_ALTERNATIVE_DATA_SOURCE,

Line 1067: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1063: p_is_b2b_custprof => l_is_b2b_custprof,
1064: x_from_clause => l_from_clause,
1065: x_return_status => x_return_status
1066: );
1067: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1069: END IF;
1070:
1071: -- discoverer workbook can be used as a filter

Line 1068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1064: x_from_clause => l_from_clause,
1065: x_return_status => x_return_status
1066: );
1067: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1069: END IF;
1070:
1071: -- discoverer workbook can be used as a filter
1072: OPEN c_objects (p_arc_object_for, p_object_for_id);

Line 1098: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1094: p_is_b2b_custprof => l_is_b2b_custprof,
1095: x_where_clause => l_where_clause,
1096: x_return_status => x_return_status
1097: );
1098: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1100: END IF;
1101:
1102: l_sql_statement := l_insert_clause || l_insert_fields ||

Line 1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1095: x_where_clause => l_where_clause,
1096: x_return_status => x_return_status
1097: );
1098: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1100: END IF;
1101:
1102: l_sql_statement := l_insert_clause || l_insert_fields ||
1103: ' FROM ' || l_from_clause;

Line 1116: WHEN FND_API.G_EXC_ERROR THEN

1112: EXECUTE IMMEDIATE l_sql_statement
1113: USING p_arc_object_for, p_object_for_id, G_ALTERNATIVE_DATA_SOURCE, l_data_source_id;
1114: END IF;
1115: EXCEPTION
1116: WHEN FND_API.G_EXC_ERROR THEN
1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1120: WHEN OTHERS THEN

Line 1117: x_return_status := FND_API.G_RET_STS_ERROR;

1113: USING p_arc_object_for, p_object_for_id, G_ALTERNATIVE_DATA_SOURCE, l_data_source_id;
1114: END IF;
1115: EXCEPTION
1116: WHEN FND_API.G_EXC_ERROR THEN
1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1120: WHEN OTHERS THEN
1121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1114: END IF;
1115: EXCEPTION
1116: WHEN FND_API.G_EXC_ERROR THEN
1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1120: WHEN OTHERS THEN
1121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1122: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1115: EXCEPTION
1116: WHEN FND_API.G_EXC_ERROR THEN
1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1120: WHEN OTHERS THEN
1121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1122: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1123: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 1121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1120: WHEN OTHERS THEN
1121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1122: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1123: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1124: END IF;
1125: END populate_target_staging;

Line 1162: x_return_status := FND_API.G_RET_STS_SUCCESS;

1158: WHERE discoverer_sql_id = p_discoverer_sql_id
1159: ;
1160: BEGIN
1161: -- Initialize API return status to SUCCESS
1162: x_return_status := FND_API.G_RET_STS_SUCCESS;
1163:
1164: OPEN c_workbook (p_discoverer_sql_id);
1165: FETCH c_workbook INTO l_workbook_name, l_worksheet_name, l_workbook_owner_name;
1166: CLOSE c_workbook;

Line 1175: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1171: p_worksheet_name => l_worksheet_name,
1172: x_customer_field => l_source_pk_field,
1173: x_return_status => x_return_status
1174: );
1175: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: END IF;
1178:
1179: get_from_sql (

Line 1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1172: x_customer_field => l_source_pk_field,
1173: x_return_status => x_return_status
1174: );
1175: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: END IF;
1178:
1179: get_from_sql (
1180: p_workbook_owner_name => l_workbook_owner_name,

Line 1187: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1183: x_from_sql => l_from_and_where,
1184: x_found => l_found,
1185: x_return_status => x_return_status
1186: );
1187: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1189: END IF;
1190:
1191: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1184: x_found => l_found,
1185: x_return_status => x_return_status
1186: );
1187: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1189: END IF;
1190:
1191: IF (AMS_DEBUG_HIGH_ON) THEN
1192: AMS_Utility_PVT.debug_message (L_API_NAME || ': ' || l_from_and_where);

Line 1210: WHEN FND_API.G_EXC_ERROR THEN

1206: 'SELECT :arc_object' || ', :object_id' || ', :disco_wb, :disco_id' || ', ' || l_source_pk_field ||
1207: ' ' || l_from_and_where
1208: USING p_arc_object_for, p_object_for_id, 'DIWB', p_discoverer_sql_id;
1209: EXCEPTION
1210: WHEN FND_API.G_EXC_ERROR THEN
1211: x_return_status := FND_API.G_RET_STS_ERROR;
1212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1214: WHEN OTHERS THEN

Line 1211: x_return_status := FND_API.G_RET_STS_ERROR;

1207: ' ' || l_from_and_where
1208: USING p_arc_object_for, p_object_for_id, 'DIWB', p_discoverer_sql_id;
1209: EXCEPTION
1210: WHEN FND_API.G_EXC_ERROR THEN
1211: x_return_status := FND_API.G_RET_STS_ERROR;
1212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1214: WHEN OTHERS THEN
1215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1208: USING p_arc_object_for, p_object_for_id, 'DIWB', p_discoverer_sql_id;
1209: EXCEPTION
1210: WHEN FND_API.G_EXC_ERROR THEN
1211: x_return_status := FND_API.G_RET_STS_ERROR;
1212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1214: WHEN OTHERS THEN
1215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1216: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1209: EXCEPTION
1210: WHEN FND_API.G_EXC_ERROR THEN
1211: x_return_status := FND_API.G_RET_STS_ERROR;
1212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1214: WHEN OTHERS THEN
1215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1216: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1217: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 1215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1211: x_return_status := FND_API.G_RET_STS_ERROR;
1212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1214: WHEN OTHERS THEN
1215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1216: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1217: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1218: END IF;
1219: END populate_using_sql;

Line 1262: x_return_status := FND_API.G_RET_STS_SUCCESS;

1258:
1259: l_model_type VARCHAR2(30);
1260: BEGIN
1261: -- Initialize API return status to SUCCESS
1262: x_return_status := FND_API.G_RET_STS_SUCCESS;
1263:
1264: l_result := fnd_installation.get_app_info(
1265: 'AMS',
1266: l_status,

Line 1306: WHEN FND_API.G_EXC_ERROR THEN

1302: -- EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_ams_schema || '.ams_dm_inter_source_stg';
1303: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_ams_schema || '.ams_dm_int_src_stg_gt ';
1304:
1305: EXCEPTION
1306: WHEN FND_API.G_EXC_ERROR THEN
1307: x_return_status := FND_API.G_RET_STS_ERROR;
1308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1310: WHEN OTHERS THEN

Line 1307: x_return_status := FND_API.G_RET_STS_ERROR;

1303: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_ams_schema || '.ams_dm_int_src_stg_gt ';
1304:
1305: EXCEPTION
1306: WHEN FND_API.G_EXC_ERROR THEN
1307: x_return_status := FND_API.G_RET_STS_ERROR;
1308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1310: WHEN OTHERS THEN
1311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1304:
1305: EXCEPTION
1306: WHEN FND_API.G_EXC_ERROR THEN
1307: x_return_status := FND_API.G_RET_STS_ERROR;
1308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1310: WHEN OTHERS THEN
1311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1312: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1305: EXCEPTION
1306: WHEN FND_API.G_EXC_ERROR THEN
1307: x_return_status := FND_API.G_RET_STS_ERROR;
1308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1310: WHEN OTHERS THEN
1311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1312: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1313: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 1311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1307: x_return_status := FND_API.G_RET_STS_ERROR;
1308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1310: WHEN OTHERS THEN
1311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1312: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1313: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1314: END IF;
1315: END purge_target_staging;

Line 1352: x_return_status := FND_API.G_RET_STS_SUCCESS;

1348: AND a.source_type_code = b.source_type_code
1349: ;
1350: BEGIN
1351: -- Initialize API return status to SUCCESS
1352: x_return_status := FND_API.G_RET_STS_SUCCESS;
1353:
1354: -- find the master source type which is used
1355: -- in the workbook. the master source type is
1356: -- needed to identify the pk field to select

Line 1377: EXIT WHEN c_master_types%NOTFOUND OR l_found = FND_API.G_TRUE;

1373: x_position => l_position,
1374: x_overflow => l_overflow
1375: );
1376:
1377: EXIT WHEN c_master_types%NOTFOUND OR l_found = FND_API.G_TRUE;
1378: END LOOP;
1379: CLOSE c_master_types;
1380:
1381: IF l_found = FND_API.G_FALSE THEN

Line 1381: IF l_found = FND_API.G_FALSE THEN

1377: EXIT WHEN c_master_types%NOTFOUND OR l_found = FND_API.G_TRUE;
1378: END LOOP;
1379: CLOSE c_master_types;
1380:
1381: IF l_found = FND_API.G_FALSE THEN
1382: AMS_Utility_PVT.error_message ('AMS_DM_DIWB_NO_SOURCE_TYPE', 'WORKBOOKSHEET', p_workbook_name || '.' || p_worksheet_name);
1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1384: END IF;
1385:

Line 1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1379: CLOSE c_master_types;
1380:
1381: IF l_found = FND_API.G_FALSE THEN
1382: AMS_Utility_PVT.error_message ('AMS_DM_DIWB_NO_SOURCE_TYPE', 'WORKBOOKSHEET', p_workbook_name || '.' || p_worksheet_name);
1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1384: END IF;
1385:
1386: x_customer_field := l_customer_pk_field;
1387: EXCEPTION

Line 1388: WHEN FND_API.G_EXC_ERROR THEN

1384: END IF;
1385:
1386: x_customer_field := l_customer_pk_field;
1387: EXCEPTION
1388: WHEN FND_API.G_EXC_ERROR THEN
1389: x_return_status := FND_API.G_RET_STS_ERROR;
1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1392: WHEN OTHERS THEN

Line 1389: x_return_status := FND_API.G_RET_STS_ERROR;

1385:
1386: x_customer_field := l_customer_pk_field;
1387: EXCEPTION
1388: WHEN FND_API.G_EXC_ERROR THEN
1389: x_return_status := FND_API.G_RET_STS_ERROR;
1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1392: WHEN OTHERS THEN
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1386: x_customer_field := l_customer_pk_field;
1387: EXCEPTION
1388: WHEN FND_API.G_EXC_ERROR THEN
1389: x_return_status := FND_API.G_RET_STS_ERROR;
1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1392: WHEN OTHERS THEN
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1394: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1387: EXCEPTION
1388: WHEN FND_API.G_EXC_ERROR THEN
1389: x_return_status := FND_API.G_RET_STS_ERROR;
1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1392: WHEN OTHERS THEN
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1394: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1395: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1389: x_return_status := FND_API.G_RET_STS_ERROR;
1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1392: WHEN OTHERS THEN
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1394: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1395: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1396: END IF;
1397: END get_customer_field;

Line 1484: x_return_status := FND_API.G_RET_STS_SUCCESS;

1480: l_userId NUMBER := FND_GLOBAL.user_id;
1481: l_concUserId NUMBER := FND_GLOBAL.conc_login_id;
1482: BEGIN
1483: -- Initialize API return status to SUCCESS
1484: x_return_status := FND_API.G_RET_STS_SUCCESS;
1485:
1486: -- purge the existing records
1487: DELETE /*+ index(AMS_DM_SOURCE AMS_DM_SOURCE_U2) */ FROM ams_dm_source
1488: WHERE arc_used_for_object = p_arc_object_for

Line 1652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1648: AND t.party_id = i.party_id)
1649: ;
1650: ELSE
1651: AMS_Utility_PVT.error_message ('AMS_DM_UNSUPPORTED_ACTION');
1652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1653: END IF;
1654: END LOOP;
1655: CLOSE c_sources;
1656: ELSE

Line 1685: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1681: p_arc_object_for => p_arc_object_for,
1682: p_object_for_id => p_object_for_id,
1683: x_return_status => x_return_status
1684: );
1685: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1687: END IF;
1688:
1689: -- ASSUMPTION: source_id only comes from ams_dm_source_s

Line 1686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1682: p_object_for_id => p_object_for_id,
1683: x_return_status => x_return_status
1684: );
1685: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1687: END IF;
1688:
1689: -- ASSUMPTION: source_id only comes from ams_dm_source_s
1690:

Line 1728: RAISE FND_API.G_EXC_ERROR;

1724: --added rosharma 20-aug-2003 bug # 3102421
1725: EXCEPTION
1726: WHEN OTHERS THEN
1727: AMS_Utility_PVT.error_message ('AMS_DM_INVALID_PRIMARY_KEY');
1728: RAISE FND_API.G_EXC_ERROR;
1729: END;
1730: --end add rosharma 20-aug-2003 bug # 3102421
1731:
1732: -- choang - 12-jul-2002 - logic to populate total records

Line 1748: x_return_status := FND_API.G_RET_STS_ERROR;

1744: -- If model is building, then check that the data can be used for building
1745: IF l_status_code = G_STATUS_BUILDING THEN
1746: IF l_total_records <= 0 THEN
1747: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_SELECTIONS_EMPTY');
1748: x_return_status := FND_API.G_RET_STS_ERROR;
1749: RAISE FND_API.G_EXC_ERROR;
1750: END IF;
1751:
1752: IF l_total_positives <= 0 THEN

Line 1749: RAISE FND_API.G_EXC_ERROR;

1745: IF l_status_code = G_STATUS_BUILDING THEN
1746: IF l_total_records <= 0 THEN
1747: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_SELECTIONS_EMPTY');
1748: x_return_status := FND_API.G_RET_STS_ERROR;
1749: RAISE FND_API.G_EXC_ERROR;
1750: END IF;
1751:
1752: IF l_total_positives <= 0 THEN
1753: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_NO_POSITIVE_TGTS');

Line 1754: x_return_status := FND_API.G_RET_STS_ERROR;

1750: END IF;
1751:
1752: IF l_total_positives <= 0 THEN
1753: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_NO_POSITIVE_TGTS');
1754: x_return_status := FND_API.G_RET_STS_ERROR;
1755: RAISE FND_API.G_EXC_ERROR;
1756: END IF;
1757:
1758: IF l_total_positives = l_total_records THEN

Line 1755: RAISE FND_API.G_EXC_ERROR;

1751:
1752: IF l_total_positives <= 0 THEN
1753: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_NO_POSITIVE_TGTS');
1754: x_return_status := FND_API.G_RET_STS_ERROR;
1755: RAISE FND_API.G_EXC_ERROR;
1756: END IF;
1757:
1758: IF l_total_positives = l_total_records THEN
1759: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_ALL_POSITIVE_TGTS');

Line 1760: x_return_status := FND_API.G_RET_STS_ERROR;

1756: END IF;
1757:
1758: IF l_total_positives = l_total_records THEN
1759: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_ALL_POSITIVE_TGTS');
1760: x_return_status := FND_API.G_RET_STS_ERROR;
1761: RAISE FND_API.G_EXC_ERROR;
1762: END IF;
1763: END IF;
1764: ELSE

Line 1761: RAISE FND_API.G_EXC_ERROR;

1757:
1758: IF l_total_positives = l_total_records THEN
1759: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_ALL_POSITIVE_TGTS');
1760: x_return_status := FND_API.G_RET_STS_ERROR;
1761: RAISE FND_API.G_EXC_ERROR;
1762: END IF;
1763: END IF;
1764: ELSE
1765: -- use the results of the previous insert statement

Line 1776: x_return_status := FND_API.G_RET_STS_ERROR;

1772: -- If Scoring Run is scoring, then check that the data can be used for scoring
1773: IF l_status_code = G_STATUS_SCORING THEN
1774: IF l_row_count <= 0 THEN
1775: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORE_SELECTIONS_EMPTY');
1776: x_return_status := FND_API.G_RET_STS_ERROR;
1777: RAISE FND_API.G_EXC_ERROR;
1778: END IF;
1779: END IF;
1780: END IF;

Line 1777: RAISE FND_API.G_EXC_ERROR;

1773: IF l_status_code = G_STATUS_SCORING THEN
1774: IF l_row_count <= 0 THEN
1775: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORE_SELECTIONS_EMPTY');
1776: x_return_status := FND_API.G_RET_STS_ERROR;
1777: RAISE FND_API.G_EXC_ERROR;
1778: END IF;
1779: END IF;
1780: END IF;
1781:

Line 1836: x_return_status := FND_API.G_RET_STS_SUCCESS;

1832: ORDER BY sequence_order
1833: ;
1834: BEGIN
1835: -- Initialize API return status to SUCCESS
1836: x_return_status := FND_API.G_RET_STS_SUCCESS;
1837:
1838: AMS_DiscovererSQL_PVT.search_sql_string (
1839: p_search_string => L_FROM_KEYWORD,
1840: p_workbook_name => p_workbook_name,

Line 1847: IF l_found <> FND_API.G_TRUE THEN

1843: x_found_in_str => l_found_in_str,
1844: x_position => l_position,
1845: x_overflow => l_overflow
1846: );
1847: IF l_found <> FND_API.G_TRUE THEN
1848: AMS_Utility_PVT.error_message ('AMS_SQL_NO_FROM', 'WORKBOOKSHEET', p_workbook_name || '.' || p_worksheet_name);
1849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1850: END IF;
1851:

Line 1849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1845: x_overflow => l_overflow
1846: );
1847: IF l_found <> FND_API.G_TRUE THEN
1848: AMS_Utility_PVT.error_message ('AMS_SQL_NO_FROM', 'WORKBOOKSHEET', p_workbook_name || '.' || p_worksheet_name);
1849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1850: END IF;
1851:
1852: -- fetch the sql string from ams_discoverer_sql
1853: -- and start from the position of FROM. append

Line 1868: WHEN FND_API.G_EXC_ERROR THEN

1864: CLOSE c_sql;
1865:
1866: x_from_sql := l_from_sql;
1867: EXCEPTION
1868: WHEN FND_API.G_EXC_ERROR THEN
1869: x_return_status := FND_API.G_RET_STS_ERROR;
1870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1872: WHEN OTHERS THEN

Line 1869: x_return_status := FND_API.G_RET_STS_ERROR;

1865:
1866: x_from_sql := l_from_sql;
1867: EXCEPTION
1868: WHEN FND_API.G_EXC_ERROR THEN
1869: x_return_status := FND_API.G_RET_STS_ERROR;
1870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1872: WHEN OTHERS THEN
1873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1866: x_from_sql := l_from_sql;
1867: EXCEPTION
1868: WHEN FND_API.G_EXC_ERROR THEN
1869: x_return_status := FND_API.G_RET_STS_ERROR;
1870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1872: WHEN OTHERS THEN
1873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1874: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1867: EXCEPTION
1868: WHEN FND_API.G_EXC_ERROR THEN
1869: x_return_status := FND_API.G_RET_STS_ERROR;
1870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1872: WHEN OTHERS THEN
1873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1874: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1875: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 1873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1869: x_return_status := FND_API.G_RET_STS_ERROR;
1870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1872: WHEN OTHERS THEN
1873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1874: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1875: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1876: END IF;
1877: END get_from_sql;

Line 1960: x_return_status := FND_API.G_RET_STS_SUCCESS;

1956:
1957: l_is_org_prod_affn BOOLEAN;
1958: BEGIN
1959: -- Initialize API return status to SUCCESS
1960: x_return_status := FND_API.G_RET_STS_SUCCESS;
1961:
1962: l_model_id := p_model_id;
1963:
1964: IF (AMS_DEBUG_HIGH_ON) THEN

Line 2064: RAISE FND_API.G_EXC_ERROR;

2060: IF (AMS_DEBUG_HIGH_ON) THEN
2061: AMS_Utility_PVT.debug_message ('Target Field has been disabled. Raising Error.');
2062: END IF;
2063: AMS_Utility_PVT.error_message ('AMS_DM_TARGET_FIELD_DISABLED');
2064: RAISE FND_API.G_EXC_ERROR;
2065: END IF;
2066:
2067: get_target_positive_values ( p_target_id => l_model_rec.target_id,
2068: p_target_field => l_target_source_object || '.' || l_target_field,

Line 2131: RAISE FND_API.G_EXC_ERROR;

2127: IF (AMS_DEBUG_HIGH_ON) THEN
2128: AMS_Utility_PVT.debug_message ('Target Field has been disabled. Raising Error.');
2129: END IF;
2130: AMS_Utility_PVT.error_message ('AMS_DM_TARGET_FIELD_DISABLED');
2131: RAISE FND_API.G_EXC_ERROR;
2132: END IF;
2133:
2134: is_b2b_data_source(
2135: p_model_id => l_model_id,

Line 2223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2219: END IF;
2220:
2221: ELSE
2222: AMS_Utility_PVT.error_message ('AMS_DM_UNSUPPORTED_MODEL', 'MODEL_TYPE', l_model_rec.model_type);
2223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2224: END IF;
2225:
2226: ELSE
2227: OPEN c_target (l_model_rec.target_id);

Line 2236: RAISE FND_API.G_EXC_ERROR;

2232: IF (AMS_DEBUG_HIGH_ON) THEN
2233: AMS_Utility_PVT.debug_message ('Target Field has been disabled. Raising Error.');
2234: END IF;
2235: AMS_Utility_PVT.error_message ('AMS_DM_TARGET_FIELD_DISABLED');
2236: RAISE FND_API.G_EXC_ERROR;
2237: END IF;
2238:
2239: -- get the sql statement that ANDs all the positive values defined for the target
2240: -- and the comparison operators.

Line 2279: RAISE FND_API.G_EXC_ERROR;

2275:
2276: EXCEPTION
2277: WHEN VALUE_ERROR THEN
2278: AMS_Utility_PVT.error_message ('AMS_DM_INVALID_DATA_CONVERT');
2279: RAISE FND_API.G_EXC_ERROR;
2280: END;
2281:
2282: IF (AMS_DEBUG_HIGH_ON) THEN
2283: AMS_Utility_PVT.debug_message ('target sql: ' || l_sql);

Line 2297: WHEN FND_API.G_EXC_ERROR THEN

2293: WHERE arc_object_used_by = G_OBJECT_TYPE_MODEL
2294: AND object_used_by_id = p_model_id
2295: AND target_flag IS NULL;
2296: EXCEPTION
2297: WHEN FND_API.G_EXC_ERROR THEN
2298: x_return_status := FND_API.G_RET_STS_ERROR;
2299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2301: WHEN OTHERS THEN

Line 2298: x_return_status := FND_API.G_RET_STS_ERROR;

2294: AND object_used_by_id = p_model_id
2295: AND target_flag IS NULL;
2296: EXCEPTION
2297: WHEN FND_API.G_EXC_ERROR THEN
2298: x_return_status := FND_API.G_RET_STS_ERROR;
2299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2301: WHEN OTHERS THEN
2302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2295: AND target_flag IS NULL;
2296: EXCEPTION
2297: WHEN FND_API.G_EXC_ERROR THEN
2298: x_return_status := FND_API.G_RET_STS_ERROR;
2299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2301: WHEN OTHERS THEN
2302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2303: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2296: EXCEPTION
2297: WHEN FND_API.G_EXC_ERROR THEN
2298: x_return_status := FND_API.G_RET_STS_ERROR;
2299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2301: WHEN OTHERS THEN
2302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2303: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2304: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 2302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2298: x_return_status := FND_API.G_RET_STS_ERROR;
2299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2301: WHEN OTHERS THEN
2302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2303: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2304: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2305: END IF;
2306: END populate_targets;

Line 2352: x_return_status := FND_API.G_RET_STS_SUCCESS;

2348: GROUP BY arc_object, object_id
2349: ;
2350: BEGIN
2351: -- Initialize API return status to SUCCESS
2352: x_return_status := FND_API.G_RET_STS_SUCCESS;
2353:
2354: -- only perform the summarization for seeded data sources
2355: IF NOT p_seeded_data_source THEN
2356: RETURN;

Line 2371: p_init_msg_list => FND_API.G_FALSE,

2367: l_action_rec.no_of_rows_targeted := l_summary_rec.total_targeted;
2368:
2369: AMS_ListAction_PVT.Update_ListAction (
2370: p_api_version => 1.0,
2371: p_init_msg_list => FND_API.G_FALSE,
2372: p_commit => FND_API.G_TRUE,
2373: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2374: x_return_status => l_return_status,
2375: x_msg_count => l_msg_count,

Line 2372: p_commit => FND_API.G_TRUE,

2368:
2369: AMS_ListAction_PVT.Update_ListAction (
2370: p_api_version => 1.0,
2371: p_init_msg_list => FND_API.G_FALSE,
2372: p_commit => FND_API.G_TRUE,
2373: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2374: x_return_status => l_return_status,
2375: x_msg_count => l_msg_count,
2376: x_msg_data => l_msg_data,

Line 2373: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2369: AMS_ListAction_PVT.Update_ListAction (
2370: p_api_version => 1.0,
2371: p_init_msg_list => FND_API.G_FALSE,
2372: p_commit => FND_API.G_TRUE,
2373: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2374: x_return_status => l_return_status,
2375: x_msg_count => l_msg_count,
2376: x_msg_data => l_msg_data,
2377: p_action_rec => l_action_rec

Line 2379: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2375: x_msg_count => l_msg_count,
2376: x_msg_data => l_msg_data,
2377: p_action_rec => l_action_rec
2378: );
2379: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2380: x_return_status := l_return_status;
2381: END IF;
2382: END LOOP;
2383: EXCEPTION

Line 2384: WHEN FND_API.G_EXC_ERROR THEN

2380: x_return_status := l_return_status;
2381: END IF;
2382: END LOOP;
2383: EXCEPTION
2384: WHEN FND_API.G_EXC_ERROR THEN
2385: x_return_status := FND_API.G_RET_STS_ERROR;
2386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2388: WHEN OTHERS THEN

Line 2385: x_return_status := FND_API.G_RET_STS_ERROR;

2381: END IF;
2382: END LOOP;
2383: EXCEPTION
2384: WHEN FND_API.G_EXC_ERROR THEN
2385: x_return_status := FND_API.G_RET_STS_ERROR;
2386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2388: WHEN OTHERS THEN
2389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2382: END LOOP;
2383: EXCEPTION
2384: WHEN FND_API.G_EXC_ERROR THEN
2385: x_return_status := FND_API.G_RET_STS_ERROR;
2386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2388: WHEN OTHERS THEN
2389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2390: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2383: EXCEPTION
2384: WHEN FND_API.G_EXC_ERROR THEN
2385: x_return_status := FND_API.G_RET_STS_ERROR;
2386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2388: WHEN OTHERS THEN
2389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2390: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 2389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2385: x_return_status := FND_API.G_RET_STS_ERROR;
2386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2388: WHEN OTHERS THEN
2389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2390: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2392: END IF;
2393: END update_action_summary;

Line 2450: x_return_status := FND_API.G_RET_STS_SUCCESS;

2446:
2447: l_seeded_flag BOOLEAN;
2448: BEGIN
2449: -- Initialize API return status to SUCCESS
2450: x_return_status := FND_API.G_RET_STS_SUCCESS;
2451:
2452: IF p_object_type = G_OBJECT_TYPE_MODEL THEN
2453: OPEN c_model_details (p_object_id);
2454: FETCH c_model_details INTO l_object_rec;

Line 2508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2504: WHERE arc_used_for_object = p_object_type
2505: AND used_for_object_id = p_object_id;
2506: ELSE
2507: AMS_Utility_PVT.error_message ('AMS_DM_UNSUPPORTED_MODEL', 'MODEL_TYPE', l_object_rec.model_type);
2508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2509: END IF;
2510:
2511: UPDATE /*+ index(AMS_DM_SOURCE AMS_DM_SOURCE_U2) */ ams_dm_source
2512: SET target_value = L_NEGATIVE_TARGET_VALUE

Line 2517: WHEN FND_API.G_EXC_ERROR THEN

2513: WHERE arc_used_for_object = p_object_type
2514: AND used_for_object_id = p_object_id
2515: AND target_value IS NULL;
2516: EXCEPTION
2517: WHEN FND_API.G_EXC_ERROR THEN
2518: x_return_status := FND_API.G_RET_STS_ERROR;
2519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2521: WHEN OTHERS THEN

Line 2518: x_return_status := FND_API.G_RET_STS_ERROR;

2514: AND used_for_object_id = p_object_id
2515: AND target_value IS NULL;
2516: EXCEPTION
2517: WHEN FND_API.G_EXC_ERROR THEN
2518: x_return_status := FND_API.G_RET_STS_ERROR;
2519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2521: WHEN OTHERS THEN
2522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2515: AND target_value IS NULL;
2516: EXCEPTION
2517: WHEN FND_API.G_EXC_ERROR THEN
2518: x_return_status := FND_API.G_RET_STS_ERROR;
2519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2521: WHEN OTHERS THEN
2522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2523: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2516: EXCEPTION
2517: WHEN FND_API.G_EXC_ERROR THEN
2518: x_return_status := FND_API.G_RET_STS_ERROR;
2519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2521: WHEN OTHERS THEN
2522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2523: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2524: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 2522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2518: x_return_status := FND_API.G_RET_STS_ERROR;
2519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2521: WHEN OTHERS THEN
2522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2523: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2524: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2525: END IF;
2526: END update_source_target;

Line 2547: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2543: p_arc_object => p_arc_object,
2544: p_object_id => p_object_id,
2545: x_return_status => l_return_status
2546: );
2547: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2548: l_msg_count := FND_MSG_PUB.count_msg;
2549: FOR i IN 1 .. l_msg_count LOOP
2550: AMS_Utility_PVT.create_log (
2551: x_return_status => l_return_status,

Line 2554: p_msg_data => FND_MSG_PUB.get(i, FND_API.g_false),

2550: AMS_Utility_PVT.create_log (
2551: x_return_status => l_return_status,
2552: p_arc_log_used_by => p_arc_object,
2553: p_log_used_by_id => p_object_id,
2554: p_msg_data => FND_MSG_PUB.get(i, FND_API.g_false),
2555: p_msg_type => 'ERROR'
2556: );
2557: END LOOP;
2558: retcode := 2;

Line 2590: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2586: p_arc_object => p_arc_object,
2587: p_object_id => p_object_id,
2588: x_return_status => l_return_status
2589: );
2590: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2591: l_msg_count := FND_MSG_PUB.count_msg;
2592: FOR i IN 1 .. l_msg_count LOOP
2593: AMS_Utility_PVT.create_log (
2594: x_return_status => l_return_status,

Line 2597: p_msg_data => FND_MSG_PUB.get(i, FND_API.g_false)

2593: AMS_Utility_PVT.create_log (
2594: x_return_status => l_return_status,
2595: p_arc_log_used_by => p_arc_object,
2596: p_log_used_by_id => p_object_id,
2597: p_msg_data => FND_MSG_PUB.get(i, FND_API.g_false)
2598: );
2599: END LOOP;
2600: retcode := 2;
2601: END IF;

Line 2655: x_return_status := FND_API.G_RET_STS_SUCCESS;

2651: AND object_used_by_id = p_object_id
2652: ;
2653: BEGIN
2654: -- Initialize API return status to SUCCESS
2655: x_return_status := FND_API.G_RET_STS_SUCCESS;
2656:
2657: OPEN c_total_records (p_arc_object_for, p_object_for_id);
2658: FETCH c_total_records INTO l_total_records;
2659: CLOSE c_total_records;

Line 2675: RAISE FND_API.G_EXC_ERROR;

2671: END IF;
2672:
2673: IF l_total_records < NVL (l_min_records, 0) THEN
2674: AMS_Utility_PVT.error_message ('AMS_DM_NOT_ENOUGH_RECORDS', 'NUM_RECORDS', l_total_records);
2675: RAISE FND_API.G_EXC_ERROR;
2676: END IF;
2677:
2678: IF l_row_selection_type = L_SELECTION_TYPE_STANDARD THEN
2679: -- UPDATE ams_dm_inter_source_stg

Line 2697: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2693: p_total_rows => l_total_records,
2694: p_every_nth_row => l_every_nth_row,
2695: x_return_status => x_return_status
2696: );
2697: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2699: END IF;
2700: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message (l_row_selection_type || ': ' || SQL%ROWCOUNT); END IF;
2701: ELSIF l_row_selection_type = L_SELECTION_TYPE_PCT THEN

Line 2698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2694: p_every_nth_row => l_every_nth_row,
2695: x_return_status => x_return_status
2696: );
2697: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2699: END IF;
2700: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message (l_row_selection_type || ': ' || SQL%ROWCOUNT); END IF;
2701: ELSIF l_row_selection_type = L_SELECTION_TYPE_PCT THEN
2702: randomize_by_pct (

Line 2711: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2707: p_total_rows => l_total_records,
2708: p_pct_random => l_pct_random,
2709: x_return_status => x_return_status
2710: );
2711: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2713: END IF;
2714: ELSE
2715: AMS_Utility_PVT.error_message ('AMS_DM_BAD_SELECTION_TYPE', 'SELECTION_TYPE', l_row_selection_type);

Line 2712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2708: p_pct_random => l_pct_random,
2709: x_return_status => x_return_status
2710: );
2711: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2713: END IF;
2714: ELSE
2715: AMS_Utility_PVT.error_message ('AMS_DM_BAD_SELECTION_TYPE', 'SELECTION_TYPE', l_row_selection_type);
2716: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2716: x_return_status := FND_API.G_RET_STS_ERROR;

2712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2713: END IF;
2714: ELSE
2715: AMS_Utility_PVT.error_message ('AMS_DM_BAD_SELECTION_TYPE', 'SELECTION_TYPE', l_row_selection_type);
2716: x_return_status := FND_API.G_RET_STS_ERROR;
2717: END IF;
2718: END apply_sizing_options;
2719:
2720:

Line 2750: x_return_status := FND_API.G_RET_STS_SUCCESS;

2746: ORDER BY random_generated_num
2747: ;
2748: BEGIN
2749: -- Initialize API return status to SUCCESS
2750: x_return_status := FND_API.G_RET_STS_SUCCESS;
2751:
2752: IF l_total_random_rows < NVL (p_min_rows, 0) THEN
2753: AMS_Utility_PVT.error_message ('AMS_DM_NOT_ENOUGH_RECORDS', 'NUM_RECORDS', l_total_random_rows);
2754: RAISE FND_API.G_EXC_ERROR;

Line 2754: RAISE FND_API.G_EXC_ERROR;

2750: x_return_status := FND_API.G_RET_STS_SUCCESS;
2751:
2752: IF l_total_random_rows < NVL (p_min_rows, 0) THEN
2753: AMS_Utility_PVT.error_message ('AMS_DM_NOT_ENOUGH_RECORDS', 'NUM_RECORDS', l_total_random_rows);
2754: RAISE FND_API.G_EXC_ERROR;
2755: END IF;
2756:
2757: -- Randomize the records
2758: -- Seed the random number generator with the Julian

Line 2807: x_return_status := FND_API.G_RET_STS_SUCCESS;

2803:
2804: l_local_max_rows NUMBER := NVL (p_max_rows, p_total_rows);
2805: BEGIN
2806: -- Initialize API return status to SUCCESS
2807: x_return_status := FND_API.G_RET_STS_SUCCESS;
2808:
2809: IF l_total_random_rows < NVL (p_min_rows, 0) THEN
2810: AMS_Utility_PVT.error_message ('AMS_DM_NOT_ENOUGH_RECORDS', 'NUM_RECORDS', l_total_random_rows);
2811: RAISE FND_API.G_EXC_ERROR;

Line 2811: RAISE FND_API.G_EXC_ERROR;

2807: x_return_status := FND_API.G_RET_STS_SUCCESS;
2808:
2809: IF l_total_random_rows < NVL (p_min_rows, 0) THEN
2810: AMS_Utility_PVT.error_message ('AMS_DM_NOT_ENOUGH_RECORDS', 'NUM_RECORDS', l_total_random_rows);
2811: RAISE FND_API.G_EXC_ERROR;
2812: END IF;
2813:
2814: -- two phase updates
2815: -- 1) update all records but only set enabled_flag = Y for the nth row

Line 2884: x_return_status := FND_API.G_RET_STS_SUCCESS;

2880: ;
2881:
2882: l_source_pk_field VARCHAR2(61);
2883: BEGIN
2884: x_return_status := FND_API.G_RET_STS_SUCCESS;
2885:
2886: x_insert_fields := ':p_object_type, :p_object_id , :p_select_object_type, ';
2887: x_insert_fields := x_insert_fields || ':p_select_object_id , ';
2888:

Line 2913: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2909: p_worksheet_name => p_worksheet_name,
2910: x_customer_field => l_source_pk_field,
2911: x_return_status => x_return_status
2912: );
2913: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2915: END IF;
2916:
2917: x_insert_fields := x_insert_fields || l_source_pk_field;

Line 2914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2910: x_customer_field => l_source_pk_field,
2911: x_return_status => x_return_status
2912: );
2913: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2915: END IF;
2916:
2917: x_insert_fields := x_insert_fields || l_source_pk_field;
2918: x_pk_field := l_source_pk_field;--kbasavar

Line 2978: x_return_status := FND_API.G_RET_STS_SUCCESS;

2974: l_found VARCHAR2(1);
2975: l_first VARCHAR2(1) := 'T';
2976: l_where_pos NUMBER;
2977: BEGIN
2978: x_return_status := FND_API.G_RET_STS_SUCCESS;
2979:
2980: IF p_select_object_type = G_ALTERNATIVE_DATA_SOURCE THEN
2981: x_from_clause := '';
2982: OPEN c_source_object (p_select_object_id);

Line 3014: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3010: x_from_sql => l_from_and_where,
3011: x_found => l_found,
3012: x_return_status => x_return_status
3013: );
3014: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3016: END IF;
3017:
3018: l_where_pos := INSTR (UPPER (l_from_and_where), 'WHERE');

Line 3015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3011: x_found => l_found,
3012: x_return_status => x_return_status
3013: );
3014: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3016: END IF;
3017:
3018: l_where_pos := INSTR (UPPER (l_from_and_where), 'WHERE');
3019:

Line 3105: x_return_status := FND_API.G_RET_STS_SUCCESS;

3101: l_found VARCHAR2(1);
3102: l_where_pos NUMBER;
3103: l_child_ds_id NUMBER;
3104: BEGIN
3105: x_return_status := FND_API.G_RET_STS_SUCCESS;
3106:
3107: IF p_select_object_type = G_ALTERNATIVE_DATA_SOURCE THEN
3108: IF p_object_type = G_OBJECT_TYPE_MODEL THEN
3109: OPEN c_target_field (p_object_id);

Line 3123: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3119: p_data_source_id => p_select_object_id,
3120: x_filter => l_perz_filter,
3121: x_return_status => x_return_status
3122: );
3123: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3125: END IF;
3126:
3127: l_relation_cond := '';

Line 3124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3120: x_filter => l_perz_filter,
3121: x_return_status => x_return_status
3122: );
3123: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3125: END IF;
3126:
3127: l_relation_cond := '';
3128: IF p_object_type = G_OBJECT_TYPE_MODEL THEN

Line 3171: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3167: p_worksheet_name => p_worksheet_name,
3168: x_filter => l_wb_filter,
3169: x_return_status => x_return_status
3170: );
3171: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3173: END IF;
3174:
3175: IF l_perz_filter IS NOT NULL THEN

Line 3172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3168: x_filter => l_wb_filter,
3169: x_return_status => x_return_status
3170: );
3171: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3173: END IF;
3174:
3175: IF l_perz_filter IS NOT NULL THEN
3176: IF x_where_clause IS NOT NULL THEN

Line 3234: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3230: p_worksheet_name => p_worksheet_name,
3231: x_filter => l_from_and_where,
3232: x_return_status => x_return_status
3233: );
3234: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3236: END IF;
3237:
3238: x_where_clause := l_from_and_where;

Line 3235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3231: x_filter => l_from_and_where,
3232: x_return_status => x_return_status
3233: );
3234: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3236: END IF;
3237:
3238: x_where_clause := l_from_and_where;
3239: END IF;

Line 3279: x_return_status := FND_API.G_RET_STS_SUCCESS;

3275:
3276: l_msg_count NUMBER;
3277: l_msg_data VARCHAR2(4000);
3278: BEGIN
3279: x_return_status := FND_API.G_RET_STS_SUCCESS;
3280:
3281: AMS_Adv_Filter_PVT.get_filter_data (
3282: p_objType => p_object_type,
3283: p_objectId => p_object_id,

Line 3290: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3286: x_msg_count => l_msg_count,
3287: x_msg_data => l_msg_data,
3288: x_filters => l_filters_tab
3289: );
3290: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3292: END IF;
3293:
3294: IF l_filters_tab.COUNT = 0 THEN

Line 3291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3287: x_msg_data => l_msg_data,
3288: x_filters => l_filters_tab
3289: );
3290: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3292: END IF;
3293:
3294: IF l_filters_tab.COUNT = 0 THEN
3295: x_filter := NULL;

Line 3348: x_return_status := FND_API.G_RET_STS_SUCCESS;

3344: l_from_and_where VARCHAR2(16000);
3345: l_found VARCHAR2(1);
3346: l_where_pos NUMBER;
3347: BEGIN
3348: x_return_status := FND_API.G_RET_STS_SUCCESS;
3349:
3350: IF p_workbook_owner IS NULL THEN
3351: -- no workbook filter selected
3352: x_filter := NULL;

Line 3364: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3360: x_from_sql => l_from_and_where,
3361: x_found => l_found,
3362: x_return_status => x_return_status
3363: );
3364: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3366: END IF;
3367:
3368: l_where_pos := INSTR (UPPER (l_from_and_where), 'WHERE');

Line 3365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3361: x_found => l_found,
3362: x_return_status => x_return_status
3363: );
3364: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3366: END IF;
3367:
3368: l_where_pos := INSTR (UPPER (l_from_and_where), 'WHERE');
3369: -- get the filter condition only if where clause is specified

Line 3761: x_return_status := FND_API.G_RET_STS_SUCCESS;

3757: l_status_code VARCHAR2(30);
3758: l_cell_name VARCHAR2(120);
3759:
3760: BEGIN
3761: x_return_status := FND_API.G_RET_STS_SUCCESS;
3762:
3763: IF p_select_object_type = 'LIST' THEN
3764: OPEN c_valid_list (p_select_object_id);
3765: FETCH c_valid_list INTO l_list_name, l_status_code;

Line 3774: x_return_status := FND_API.G_RET_STS_ERROR;

3770: END IF;
3771:
3772: IF l_status_code NOT IN ('AVAILABLE','LOCKED') THEN
3773: AMS_Utility_PVT.error_message ('AMS_DM_LIST_NOT_AVAILABLE', 'LISTNAME', l_list_name);
3774: x_return_status := FND_API.G_RET_STS_ERROR;
3775: RETURN;
3776: END IF;
3777: ELSIF p_select_object_type = 'CELL' THEN
3778: OPEN c_valid_cell (p_select_object_id);

Line 3788: x_return_status := FND_API.G_RET_STS_ERROR;

3784: END IF;
3785:
3786: IF l_status_code <> 'AVAILABLE' THEN
3787: AMS_Utility_PVT.error_message ('AMS_DM_CELL_NOT_AVAILABLE', 'CELLNAME', l_cell_name);
3788: x_return_status := FND_API.G_RET_STS_ERROR;
3789: RETURN;
3790: END IF;
3791: ELSIF p_select_object_type = 'DIWB' THEN
3792: IF (AMS_DEBUG_HIGH_ON) THEN

Line 3814: x_return_status := FND_API.G_RET_STS_ERROR;

3810: IF instr(l_sql_string, 'ORDER BY') > 0
3811: OR instr(l_sql_string, 'GROUP BY') > 0
3812: THEN
3813: AMS_Utility_PVT.error_message ('AMS_DM_COMPLEX_WORKBOOK_SQL', 'WORKBOOKNAME', p_workbook_name || '::' || p_worksheet_name);
3814: x_return_status := FND_API.G_RET_STS_ERROR;
3815: RETURN;
3816: END IF;
3817: END IF;
3818: END validate_selection_status;

Line 3877: x_return_status := FND_API.G_RET_STS_SUCCESS;

3873: l_org_id NUMBER;
3874: l_cat_set_id NUMBER;
3875:
3876: BEGIN
3877: x_return_status := FND_API.G_RET_STS_SUCCESS;
3878:
3879: -- check for product affinity model that category belongs to the product reporting category set
3880: -- and product belongs to that category
3881: OPEN c_cats_for_model (p_model_id);

Line 3897: x_return_status := FND_API.G_RET_STS_ERROR;

3893: END IF;
3894:
3895: IF l_dummy IS NULL THEN
3896: AMS_Utility_PVT.error_message ('AMS_DM_CAT_NOT_IN_SET');
3897: x_return_status := FND_API.G_RET_STS_ERROR;
3898: RETURN;
3899: END IF;
3900:
3901: --check the product still belongs to this category

Line 3910: x_return_status := FND_API.G_RET_STS_ERROR;

3906: CLOSE c_valid_prod;
3907:
3908: IF l_dummy IS NULL THEN
3909: AMS_Utility_PVT.error_message ('AMS_DM_PROD_NOT_IN_CAT', 'PRODNAME', l_prod_name);
3910: x_return_status := FND_API.G_RET_STS_ERROR;
3911: RETURN;
3912: END IF;
3913: END IF;
3914: END LOOP;

Line 3920: x_return_status := FND_API.G_RET_STS_ERROR;

3916: IF (AMS_DEBUG_HIGH_ON) THEN
3917: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: Raising error...No categories/products selected.');
3918: END IF;
3919: AMS_Utility_PVT.error_message ('AMS_DM_PROD_SEL_EMPTY');
3920: x_return_status := FND_API.G_RET_STS_ERROR;
3921: CLOSE c_cats_for_model;
3922: RETURN;
3923: END IF;
3924: CLOSE c_cats_for_model;