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.

[Home] [Help]

APPS.FA_MODIFY_DISTRIBUTIONS_PKG dependencies on FND_API

Line 29: l_return_status VARCHAR2(10) := FND_API.G_RET_STS_ERROR;

25: l_asset_id NUMBER := 0;
26: l_trx_reference_num NUMBER := -1;
27: l_trx_type VARCHAR2(15) := NULL;
28:
29: l_return_status VARCHAR2(10) := FND_API.G_RET_STS_ERROR;
30: l_transaction_status VARCHAR2(20) := 'ERRORED';
31:
32: CURSOR MET_C IS
33: SELECT MET.rowid row_id, MET.*

Line 50: X_return_status := FND_API.G_RET_STS_SUCCESS;

46:
47: --- int_debug.enable;
48: --- int_debug.print('Entered modify_distributions ');
49:
50: X_return_status := FND_API.G_RET_STS_SUCCESS;
51:
52:
53: if (not g_log_level_rec.initialized) then
54: if (NOT fa_util_pub.get_log_level_rec (

Line 57: raise FND_API.G_EXC_UNEXPECTED_ERROR;

53: if (not g_log_level_rec.initialized) then
54: if (NOT fa_util_pub.get_log_level_rec (
55: x_log_level_rec => g_log_level_rec
56: )) then
57: raise FND_API.G_EXC_UNEXPECTED_ERROR;
58: end if;
59: end if;
60:
61: -- Standard start of API savepoint.

Line 65: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

61: -- Standard start of API savepoint.
62: ---SAVEPOINT Modify_Dist_PUB;
63:
64: -- Standard call to check for call compatibility.
65: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
66: l_api_name, G_PKG_NAME)
67: THEN
68: X_return_status := FND_API.G_RET_STS_ERROR;
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 68: X_return_status := FND_API.G_RET_STS_ERROR;

64: -- Standard call to check for call compatibility.
65: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
66: l_api_name, G_PKG_NAME)
67: THEN
68: X_return_status := FND_API.G_RET_STS_ERROR;
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: END IF;
71:
72:

Line 69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

65: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
66: l_api_name, G_PKG_NAME)
67: THEN
68: X_return_status := FND_API.G_RET_STS_ERROR;
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: END IF;
71:
72:
73: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 74: IF FND_API.To_Boolean(p_init_msg_list) THEN

70: END IF;
71:
72:
73: -- Initialize message list if p_init_msg_list is set to TRUE.
74: IF FND_API.To_Boolean(p_init_msg_list) THEN
75: -- Initialize error message stack.
76: FA_SRVR_MSG.Init_Server_Message;
77:
78: -- Initialize debug message stack.

Line 164: if (l_return_status = FND_API.G_RET_STS_SUCCESS) then

160: p_Log_level_rec => g_log_level_rec);
161:
162: end if;
163:
164: if (l_return_status = FND_API.G_RET_STS_SUCCESS) then
165: l_transaction_status := 'POSTED';
166: else
167: l_transaction_status := 'ERRORED';
168: X_return_status := FND_API.G_RET_STS_ERROR;

Line 168: X_return_status := FND_API.G_RET_STS_ERROR;

164: if (l_return_status = FND_API.G_RET_STS_SUCCESS) then
165: l_transaction_status := 'POSTED';
166: else
167: l_transaction_status := 'ERRORED';
168: X_return_status := FND_API.G_RET_STS_ERROR;
169: end if;
170:
171: FOR i IN asgn_table.FIRST .. asgn_table.LAST LOOP
172:

Line 180: IF FND_API.To_Boolean(p_commit) THEN

176: AND MET.transaction_status = 'POST';
177:
178: END LOOP;
179:
180: IF FND_API.To_Boolean(p_commit) THEN
181: COMMIT WORK;
182: END IF;
183:
184: g_asgn_count := 0;

Line 252: X_return_status := FND_API.G_RET_STS_ERROR;

248: EXCEPTION
249:
250: when others then
251:
252: X_return_status := FND_API.G_RET_STS_ERROR;
253:
254: if (l_met_c_open = TRUE) then
255: CLOSE MET_C;
256: l_met_c_open := FALSE;

Line 679: h_return_status VARCHAR2(10) := FND_API.G_RET_STS_ERROR;

675: asset_id IN NUMBER
676: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN VARCHAR2
677: IS
678:
679: h_return_status VARCHAR2(10) := FND_API.G_RET_STS_ERROR;
680: h_msg_count NUMBER := 0;
681: h_msg_data VARCHAR2(512) := NULL;
682:
683: X_asset_id NUMBER;

Line 712: l_return_status VARCHAR2(15) := FND_API.G_RET_STS_ERROR;

708: l_FY_Start_Date DATE;
709: l_FY_End_Date DATE;
710: l_total_trans_units NUMBER;
711: l_new_current_units NUMBER;
712: l_return_status VARCHAR2(15) := FND_API.G_RET_STS_ERROR;
713:
714: BEGIN
715:
716: -- check that book_type_code is 'CORPORATE' book

Line 720: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

716: -- check that book_type_code is 'CORPORATE' book
717: l_return_status := check_if_corp_book(book_type_code => book_type_code,
718: p_log_level_rec => p_log_level_rec);
719:
720: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
721:
722: h_return_status := FND_API.G_RET_STS_ERROR;
723: return(h_return_status);
724:

Line 722: h_return_status := FND_API.G_RET_STS_ERROR;

718: p_log_level_rec => p_log_level_rec);
719:
720: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
721:
722: h_return_status := FND_API.G_RET_STS_ERROR;
723: return(h_return_status);
724:
725: end if;
726:

Line 737: h_return_status := FND_API.G_RET_STS_ERROR;

733: if (ADD_C%NOTFOUND) then
734:
735: CLOSE ADD_C;
736:
737: h_return_status := FND_API.G_RET_STS_ERROR;
738: return(h_return_status);
739:
740: end if;
741:

Line 754: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

750: p_location_id => asgn_table(i).location_id,
751: p_ccid_id => asgn_table(i).ccid,
752: p_log_level_rec => p_log_level_rec);
753:
754: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
755:
756: h_return_status := FND_API.G_RET_STS_ERROR;
757: return(h_return_status);
758:

Line 756: h_return_status := FND_API.G_RET_STS_ERROR;

752: p_log_level_rec => p_log_level_rec);
753:
754: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
755:
756: h_return_status := FND_API.G_RET_STS_ERROR;
757: return(h_return_status);
758:
759: end if;
760:

Line 764: h_return_status := FND_API.G_RET_STS_ERROR;

760:
761: if ((asgn_table(i).dist_id is NULL) OR
762: (asgn_table(i).units + asgn_table(i).trans_units < 0)) then
763:
764: h_return_status := FND_API.G_RET_STS_ERROR;
765: return(h_return_status);
766:
767: end if;
768:

Line 777: h_return_status := FND_API.G_RET_STS_ERROR;

773: l_new_current_units := l_total_trans_units + ADDInfo.Current_Units;
774:
775: if (l_new_current_units < 1) then
776:
777: h_return_status := FND_API.G_RET_STS_ERROR;
778: return(h_return_status);
779:
780: end if;
781:

Line 798: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

794: X_return_status => l_return_status,
795: p_log_level_rec => p_log_level_rec
796: );
797:
798: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
799:
800: h_return_status := FND_API.G_RET_STS_ERROR;
801: return(h_return_status);
802:

Line 800: h_return_status := FND_API.G_RET_STS_ERROR;

796: );
797:
798: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
799:
800: h_return_status := FND_API.G_RET_STS_ERROR;
801: return(h_return_status);
802:
803: end if;
804:

Line 817: h_return_status := FND_API.G_RET_STS_ERROR;

813: if (LEA_C%NOTFOUND) then
814:
815: CLOSE LEA_C;
816:
817: h_return_status := FND_API.G_RET_STS_ERROR;
818: return(h_return_status);
819:
820: end if;
821:

Line 829: p_init_msg_list => p_init_msg_list, ----FND_API.G_TRUE,

825:
826: FA_TRANS_API_PUB.Do_Unit_Adjustment(
827: -- Standard Parameters --
828: p_api_version => p_api_version, ----1.0,
829: p_init_msg_list => p_init_msg_list, ----FND_API.G_TRUE,
830: p_commit => p_commit, ----FND_API.G_TRUE,
831: p_validation_level => p_validation_level,
832: ----FND_API.G_VALID_LEVEL_FULL,
833: x_return_status => h_return_status,

Line 830: p_commit => p_commit, ----FND_API.G_TRUE,

826: FA_TRANS_API_PUB.Do_Unit_Adjustment(
827: -- Standard Parameters --
828: p_api_version => p_api_version, ----1.0,
829: p_init_msg_list => p_init_msg_list, ----FND_API.G_TRUE,
830: p_commit => p_commit, ----FND_API.G_TRUE,
831: p_validation_level => p_validation_level,
832: ----FND_API.G_VALID_LEVEL_FULL,
833: x_return_status => h_return_status,
834: x_msg_count => h_msg_count,

Line 832: ----FND_API.G_VALID_LEVEL_FULL,

828: p_api_version => p_api_version, ----1.0,
829: p_init_msg_list => p_init_msg_list, ----FND_API.G_TRUE,
830: p_commit => p_commit, ----FND_API.G_TRUE,
831: p_validation_level => p_validation_level,
832: ----FND_API.G_VALID_LEVEL_FULL,
833: x_return_status => h_return_status,
834: x_msg_count => h_msg_count,
835: x_msg_data => h_msg_data,
836: p_calling_fn =>

Line 881: if (h_return_status <> FND_API.G_RET_STS_SUCCESS) then

877: x_return_status := h_return_status;
878: x_msg_count := h_msg_count;
879: x_msg_data := h_msg_data;
880:
881: if (h_return_status <> FND_API.G_RET_STS_SUCCESS) then
882: h_return_status := FND_API.G_RET_STS_ERROR;
883: end if;
884:
885: return(h_return_status);

Line 882: h_return_status := FND_API.G_RET_STS_ERROR;

878: x_msg_count := h_msg_count;
879: x_msg_data := h_msg_data;
880:
881: if (h_return_status <> FND_API.G_RET_STS_SUCCESS) then
882: h_return_status := FND_API.G_RET_STS_ERROR;
883: end if;
884:
885: return(h_return_status);
886:

Line 890: h_return_status := FND_API.G_RET_STS_ERROR;

886:
887: EXCEPTION
888:
889: when others then
890: h_return_status := FND_API.G_RET_STS_ERROR;
891: x_return_status := h_return_status;
892: x_msg_count := h_msg_count;
893: x_msg_data := h_msg_data;
894:

Line 912: h_return_status VARCHAR2(10) := FND_API.G_RET_STS_ERROR;

908: asset_id IN NUMBER
909: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN VARCHAR2
910: IS
911:
912: h_return_status VARCHAR2(10) := FND_API.G_RET_STS_ERROR;
913: h_msg_count NUMBER := 0;
914: h_msg_data VARCHAR2(512) := NULL;
915:
916: X_asset_id NUMBER;

Line 935: l_return_status VARCHAR2(15) := FND_API.G_RET_STS_ERROR;

931: l_Calendar_Period_Close_Date DATE;
932: l_FY_Start_Date DATE;
933: l_FY_End_Date DATE;
934: l_total_trans_units NUMBER;
935: l_return_status VARCHAR2(15) := FND_API.G_RET_STS_ERROR;
936: l_count number := 0;
937: l_txn_type_code varchar2(20);
938: l_book varchar2(30);
939: l_asset number;

Line 949: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

945: -- check that book_type_code is 'CORPORATE' book
946: l_return_status := check_if_corp_book(book_type_code => book_type_code,
947: p_Log_level_rec => g_log_level_rec);
948:
949: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
950:
951: h_return_status := FND_API.G_RET_STS_ERROR;
952: return(h_return_status);
953:

Line 951: h_return_status := FND_API.G_RET_STS_ERROR;

947: p_Log_level_rec => g_log_level_rec);
948:
949: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
950:
951: h_return_status := FND_API.G_RET_STS_ERROR;
952: return(h_return_status);
953:
954: end if;
955:

Line 966: h_return_status := FND_API.G_RET_STS_ERROR;

962: if (ADD_C%NOTFOUND) then
963:
964: CLOSE ADD_C;
965:
966: h_return_status := FND_API.G_RET_STS_ERROR;
967: return(h_return_status);
968:
969: end if;
970:

Line 985: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

981: p_location_id => asgn_table(i).location_id,
982: p_ccid_id => asgn_table(i).ccid,
983: p_Log_level_rec => g_log_level_rec);
984:
985: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
986:
987: h_return_status := FND_API.G_RET_STS_ERROR;
988: return(h_return_status);
989:

Line 987: h_return_status := FND_API.G_RET_STS_ERROR;

983: p_Log_level_rec => g_log_level_rec);
984:
985: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
986:
987: h_return_status := FND_API.G_RET_STS_ERROR;
988: return(h_return_status);
989:
990: end if;
991:

Line 997: h_return_status := FND_API.G_RET_STS_ERROR;

993: (asgn_table(i).dist_id is NULL)) then
994:
995: --- int_debug.print('trans_units < 0 and dist_id is NULL');
996:
997: h_return_status := FND_API.G_RET_STS_ERROR;
998: return(h_return_status);
999: end if;
1000:
1001: if (asgn_table(i).units + asgn_table(i).trans_units < 0) then

Line 1005: h_return_status := FND_API.G_RET_STS_ERROR;

1001: if (asgn_table(i).units + asgn_table(i).trans_units < 0) then
1002:
1003: --- int_debug.print('units + trans_units < 0');
1004:
1005: h_return_status := FND_API.G_RET_STS_ERROR;
1006: return(h_return_status);
1007: end if;
1008:
1009: l_total_trans_units := l_total_trans_units+asgn_table(i).trans_units;

Line 1017: h_return_status := FND_API.G_RET_STS_ERROR;

1013: if (l_total_trans_units <> 0) then
1014:
1015: --- int_debug.print('l_total_trans_units <> 0');
1016:
1017: h_return_status := FND_API.G_RET_STS_ERROR;
1018: return(h_return_status);
1019: end if;
1020:
1021: --- int_debug.print('Entered get_header_info ');

Line 1039: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

1035: X_return_status => l_return_status,
1036: p_Log_level_rec => g_log_level_rec
1037: );
1038:
1039: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1040: h_return_status := FND_API.G_RET_STS_ERROR;
1041: return(h_return_status);
1042: end if;
1043:

Line 1040: h_return_status := FND_API.G_RET_STS_ERROR;

1036: p_Log_level_rec => g_log_level_rec
1037: );
1038:
1039: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1040: h_return_status := FND_API.G_RET_STS_ERROR;
1041: return(h_return_status);
1042: end if;
1043:
1044: -- fix for 2219293

Line 1068: p_init_msg_list => p_init_msg_list, ----FND_API.G_TRUE,

1064:
1065: FA_TRANS_API_PUB.Do_Transfer(
1066: -- Standard Parameters --
1067: p_api_version => p_api_version, ----1.0,
1068: p_init_msg_list => p_init_msg_list, ----FND_API.G_TRUE,
1069: p_commit => p_commit, ----FND_API.G_TRUE,
1070: p_validation_level => p_validation_level,
1071: ----FND_API.G_VALID_LEVEL_FULL,
1072: x_return_status => h_return_status,

Line 1069: p_commit => p_commit, ----FND_API.G_TRUE,

1065: FA_TRANS_API_PUB.Do_Transfer(
1066: -- Standard Parameters --
1067: p_api_version => p_api_version, ----1.0,
1068: p_init_msg_list => p_init_msg_list, ----FND_API.G_TRUE,
1069: p_commit => p_commit, ----FND_API.G_TRUE,
1070: p_validation_level => p_validation_level,
1071: ----FND_API.G_VALID_LEVEL_FULL,
1072: x_return_status => h_return_status,
1073: x_msg_count => h_msg_count,

Line 1071: ----FND_API.G_VALID_LEVEL_FULL,

1067: p_api_version => p_api_version, ----1.0,
1068: p_init_msg_list => p_init_msg_list, ----FND_API.G_TRUE,
1069: p_commit => p_commit, ----FND_API.G_TRUE,
1070: p_validation_level => p_validation_level,
1071: ----FND_API.G_VALID_LEVEL_FULL,
1072: x_return_status => h_return_status,
1073: x_msg_count => h_msg_count,
1074: x_msg_data => h_msg_data,
1075: p_calling_fn =>

Line 1119: if (h_return_status <> FND_API.G_RET_STS_SUCCESS) then

1115: x_return_status := h_return_status;
1116: x_msg_count := h_msg_count;
1117: x_msg_data := h_msg_data;
1118:
1119: if (h_return_status <> FND_API.G_RET_STS_SUCCESS) then
1120: h_return_status := FND_API.G_RET_STS_ERROR;
1121: end if;
1122:
1123: return(h_return_status);

Line 1120: h_return_status := FND_API.G_RET_STS_ERROR;

1116: x_msg_count := h_msg_count;
1117: x_msg_data := h_msg_data;
1118:
1119: if (h_return_status <> FND_API.G_RET_STS_SUCCESS) then
1120: h_return_status := FND_API.G_RET_STS_ERROR;
1121: end if;
1122:
1123: return(h_return_status);
1124:

Line 1127: h_return_status := FND_API.G_RET_STS_ERROR;

1123: return(h_return_status);
1124:
1125: EXCEPTION
1126: when others then
1127: h_return_status := FND_API.G_RET_STS_ERROR;
1128: x_return_status := h_return_status;
1129: x_msg_count := h_msg_count;
1130: x_msg_data := h_msg_data;
1131:

Line 1190: X_return_status := FND_API.G_RET_STS_SUCCESS;

1186: where asset_id = X_Asset_Id
1187: and book_type_code = X_Book_Type_Code;
1188: -------------------------------------------------
1189:
1190: X_return_status := FND_API.G_RET_STS_SUCCESS;
1191:
1192: EXCEPTION
1193: when others then
1194: X_return_status := FND_API.G_RET_STS_ERROR;

Line 1194: X_return_status := FND_API.G_RET_STS_ERROR;

1190: X_return_status := FND_API.G_RET_STS_SUCCESS;
1191:
1192: EXCEPTION
1193: when others then
1194: X_return_status := FND_API.G_RET_STS_ERROR;
1195:
1196: END get_header_info;
1197:
1198: FUNCTION check_if_corp_book(

Line 1213: l_return_status VARCHAR2(15) := FND_API.G_RET_STS_ERROR;

1209: AND BC.book_class = 'CORPORATE'
1210: AND rownum <= 1;
1211:
1212: l_book_class NUMBER := 0;
1213: l_return_status VARCHAR2(15) := FND_API.G_RET_STS_ERROR;
1214: l_cbc_c_open BOOLEAN := FALSE;
1215:
1216: BEGIN
1217:

Line 1232: l_return_status := FND_API.G_RET_STS_ERROR;

1228: if (Chk_Book_Class_C%NOTFOUND) then
1229:
1230: CLOSE Chk_Book_Class_C;
1231:
1232: l_return_status := FND_API.G_RET_STS_ERROR;
1233: return(l_return_status);
1234:
1235: end if;
1236:

Line 1241: l_return_status := FND_API.G_RET_STS_SUCCESS;

1237: CLOSE Chk_Book_Class_C;
1238:
1239:
1240: if (l_book_class = 1) then
1241: l_return_status := FND_API.G_RET_STS_SUCCESS;
1242: return(l_return_status);
1243: else
1244: l_return_status := FND_API.G_RET_STS_ERROR;
1245: return(l_return_status);

Line 1244: l_return_status := FND_API.G_RET_STS_ERROR;

1240: if (l_book_class = 1) then
1241: l_return_status := FND_API.G_RET_STS_SUCCESS;
1242: return(l_return_status);
1243: else
1244: l_return_status := FND_API.G_RET_STS_ERROR;
1245: return(l_return_status);
1246: end if;
1247:
1248: else

Line 1249: l_return_status := FND_API.G_RET_STS_ERROR;

1245: return(l_return_status);
1246: end if;
1247:
1248: else
1249: l_return_status := FND_API.G_RET_STS_ERROR;
1250: return(l_return_status);
1251: end if;
1252:
1253: EXCEPTION

Line 1262: l_return_status := FND_API.G_RET_STS_ERROR;

1258: CLOSE Chk_Book_Class_C;
1259: l_cbc_c_open := FALSE;
1260: end if;
1261:
1262: l_return_status := FND_API.G_RET_STS_ERROR;
1263: return(l_return_status);
1264:
1265:
1266: END check_if_corp_book;

Line 1294: l_return_status VARCHAR2(15) := FND_API.G_RET_STS_ERROR;

1290: AND rownum <= 1;
1291:
1292: l_loc_out NUMBER := 0;
1293: l_ccid_out NUMBER := 0;
1294: l_return_status VARCHAR2(15) := FND_API.G_RET_STS_ERROR;
1295: l_cl_c_open BOOLEAN := FALSE;
1296: l_cc_c_open BOOLEAN := FALSE;
1297:
1298:

Line 1316: l_return_status := FND_API.G_RET_STS_ERROR;

1312: OPEN Chk_Location_C;
1313: FETCH Chk_Location_C INTO l_loc_out;
1314:
1315: if (Chk_Location_C%NOTFOUND) then
1316: l_return_status := FND_API.G_RET_STS_ERROR;
1317: end if;
1318:
1319: CLOSE Chk_Location_C;
1320: l_cl_c_open := TRUE;

Line 1323: l_return_status := FND_API.G_RET_STS_SUCCESS;

1319: CLOSE Chk_Location_C;
1320: l_cl_c_open := TRUE;
1321:
1322: if (l_loc_out = 1) then
1323: l_return_status := FND_API.G_RET_STS_SUCCESS;
1324: else
1325: l_return_status := FND_API.G_RET_STS_ERROR;
1326: return(l_return_status);
1327: end if;

Line 1325: l_return_status := FND_API.G_RET_STS_ERROR;

1321:
1322: if (l_loc_out = 1) then
1323: l_return_status := FND_API.G_RET_STS_SUCCESS;
1324: else
1325: l_return_status := FND_API.G_RET_STS_ERROR;
1326: return(l_return_status);
1327: end if;
1328:
1329: l_ccid_out := 0;

Line 1336: l_return_status := FND_API.G_RET_STS_ERROR;

1332: OPEN Chk_Ccid_C;
1333: FETCH Chk_Ccid_C INTO l_ccid_out;
1334:
1335: if (Chk_Ccid_C%NOTFOUND) then
1336: l_return_status := FND_API.G_RET_STS_ERROR;
1337: end if;
1338:
1339: CLOSE Chk_Ccid_C;
1340: l_cc_c_open := TRUE;

Line 1343: l_return_status := FND_API.G_RET_STS_SUCCESS;

1339: CLOSE Chk_Ccid_C;
1340: l_cc_c_open := TRUE;
1341:
1342: if (l_ccid_out = 1) then
1343: l_return_status := FND_API.G_RET_STS_SUCCESS;
1344: return(l_return_status);
1345: else
1346: l_return_status := FND_API.G_RET_STS_ERROR;
1347: return(l_return_status);

Line 1346: l_return_status := FND_API.G_RET_STS_ERROR;

1342: if (l_ccid_out = 1) then
1343: l_return_status := FND_API.G_RET_STS_SUCCESS;
1344: return(l_return_status);
1345: else
1346: l_return_status := FND_API.G_RET_STS_ERROR;
1347: return(l_return_status);
1348: end if;
1349:
1350: EXCEPTION

Line 1364: l_return_status := FND_API.G_RET_STS_ERROR;

1360: CLOSE Chk_Ccid_C;
1361: l_cc_c_open := FALSE;
1362: end if;
1363:
1364: l_return_status := FND_API.G_RET_STS_ERROR;
1365: return(l_return_status);
1366:
1367:
1368: END check_location_ccid;