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

Line 242: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

238: temp_segs varchar2(150);
239: DLT_NOT_FOUND EXCEPTION;
240: BEGIN
241:
242: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
243: X_Error_Message := Null;
244:
245: delimiter := fnd_flex_ext.get_delimiter(p_short_name, p_flex_code, struct_num);
246: if delimiter is null then

Line 264: x_Return_Status := FND_API.G_RET_STS_ERROR;

260: IF (l_debug = 'Y') THEN
261: cse_debug_pub.add('API CSE_UTIL_PKG.get_combine_segments Exception: ' || l_err_text);
262: END IF;
263: x_Error_Message := l_err_text;
264: x_Return_Status := FND_API.G_RET_STS_ERROR;
265: -- return;
266: WHEN OTHERS THEN
267: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
268: fnd_message.set_token('ERR_MSG', sqlerrm);

Line 274: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

270: IF (l_debug = 'Y') THEN
271: cse_debug_pub.add('API CSE_UTIL_PKG.get_combine_segments other exception: ' || l_err_text);
272: END IF;
273: x_Error_Message :=l_err_text;
274: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
275: END get_combine_segments;
276:
277: PROCEDURE get_concat_segments(
278: p_short_name IN VARCHAR2,

Line 297: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

293: tf boolean DEFAULT TRUE;
294: DLT_NOT_FOUND EXCEPTION;
295: SEGS_NOT_FOUND EXCEPTION;
296: BEGIN
297: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
298: X_Error_Message := Null;
299:
300: delimiter := fnd_flex_ext.get_delimiter(p_short_name, p_flex_code, struct_num);
301: if delimiter is null then

Line 319: x_Return_Status := FND_API.G_RET_STS_ERROR;

315: l_err_text := fnd_message.get;
316: IF (l_debug = 'Y') THEN
317: cse_debug_pub.add('API CSE_UTIL_PKG.get_combine_segments Exception: ' || l_err_text);
318: END IF;
319: x_Return_Status := FND_API.G_RET_STS_ERROR;
320: X_Error_Message :=l_err_text;
321: WHEN DLT_NOT_FOUND THEN
322: fnd_message.set_name('CSE', 'CSE_DELIMITER_NOT_FOUND');
323: l_err_text := fnd_message.get;

Line 327: x_Return_Status := FND_API.G_RET_STS_ERROR;

323: l_err_text := fnd_message.get;
324: IF (l_debug = 'Y') THEN
325: cse_debug_pub.add('API CSE_UTIL_PKG.get_combine_segments Exception: ' || l_err_text);
326: END IF;
327: x_Return_Status := FND_API.G_RET_STS_ERROR;
328: X_Error_Message :=l_err_text;
329: WHEN OTHERS THEN
330: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
331: fnd_message.set_token('ERR_MSG', sqlerrm);

Line 336: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

332: l_err_text := fnd_message.get;
333: IF (l_debug = 'Y') THEN
334: cse_debug_pub.add('API CSE_UTIL_PKG.get_combine_segments other exception: ' || l_err_text);
335: END IF;
336: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
337: X_Error_Message :=l_err_text;
338: END get_concat_segments;
339:
340: FUNCTION is_eib_installed RETURN VARCHAR2

Line 415: l_Point_Active_Rec VARCHAR2(1) DEFAULT FND_API.G_FALSE;

411:
412: l_Api_Name CONSTANT VARCHAR2(50) :='CSE_UTIL_PKG.GET_DESTINATION_INSTANCE';
413: l_Active_Rec_Count NUMBER:=0;
414: l_Zero_Exp_Rec_Count NUMBER:=0;
415: l_Point_Active_Rec VARCHAR2(1) DEFAULT FND_API.G_FALSE;
416: l_Point_Zero_Exp_Rec VARCHAR2(1) DEFAULT FND_API.G_FALSE;
417: l_Dest_Instance_Found VARCHAR2(1) DEFAULT FND_API.G_FALSE;
418: i PLS_INTEGER;
419: Multiple_Active_Exp EXCEPTION;

Line 416: l_Point_Zero_Exp_Rec VARCHAR2(1) DEFAULT FND_API.G_FALSE;

412: l_Api_Name CONSTANT VARCHAR2(50) :='CSE_UTIL_PKG.GET_DESTINATION_INSTANCE';
413: l_Active_Rec_Count NUMBER:=0;
414: l_Zero_Exp_Rec_Count NUMBER:=0;
415: l_Point_Active_Rec VARCHAR2(1) DEFAULT FND_API.G_FALSE;
416: l_Point_Zero_Exp_Rec VARCHAR2(1) DEFAULT FND_API.G_FALSE;
417: l_Dest_Instance_Found VARCHAR2(1) DEFAULT FND_API.G_FALSE;
418: i PLS_INTEGER;
419: Multiple_Active_Exp EXCEPTION;
420: a NUMBER := 0;

Line 417: l_Dest_Instance_Found VARCHAR2(1) DEFAULT FND_API.G_FALSE;

413: l_Active_Rec_Count NUMBER:=0;
414: l_Zero_Exp_Rec_Count NUMBER:=0;
415: l_Point_Active_Rec VARCHAR2(1) DEFAULT FND_API.G_FALSE;
416: l_Point_Zero_Exp_Rec VARCHAR2(1) DEFAULT FND_API.G_FALSE;
417: l_Dest_Instance_Found VARCHAR2(1) DEFAULT FND_API.G_FALSE;
418: i PLS_INTEGER;
419: Multiple_Active_Exp EXCEPTION;
420: a NUMBER := 0;
421: l_instance_status_id NUMBER;

Line 428: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

424: FROM csi_instance_statuses
425: WHERE upper(name) ='CREATED';
426: e_Nothing EXCEPTION;
427: BEGIN
428: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
429: X_Error_Message := Null;
430: X_Instance_Rec := Null;
431: --count active instances and expired instances with zero quantity
432: IF P_Dest_Instance_Tbl.COUNT = 0

Line 460: l_Point_Active_Rec :=FND_API.G_TRUE;

456: --Check if there exist active destination instance or expired dest instance
457: --with zero quantity
458:
459: ELSIF(l_Active_Rec_Count=1) THEN
460: l_Point_Active_Rec :=FND_API.G_TRUE;
461: l_Dest_Instance_Found :=FND_API.G_TRUE;
462:
463: ELSIF(l_Active_Rec_Count=0 AND l_Zero_Exp_Rec_Count>0) THEN
464: l_Point_Zero_Exp_Rec :=FND_API.G_TRUE;

Line 461: l_Dest_Instance_Found :=FND_API.G_TRUE;

457: --with zero quantity
458:
459: ELSIF(l_Active_Rec_Count=1) THEN
460: l_Point_Active_Rec :=FND_API.G_TRUE;
461: l_Dest_Instance_Found :=FND_API.G_TRUE;
462:
463: ELSIF(l_Active_Rec_Count=0 AND l_Zero_Exp_Rec_Count>0) THEN
464: l_Point_Zero_Exp_Rec :=FND_API.G_TRUE;
465: l_Dest_Instance_Found :=FND_API.G_TRUE;

Line 464: l_Point_Zero_Exp_Rec :=FND_API.G_TRUE;

460: l_Point_Active_Rec :=FND_API.G_TRUE;
461: l_Dest_Instance_Found :=FND_API.G_TRUE;
462:
463: ELSIF(l_Active_Rec_Count=0 AND l_Zero_Exp_Rec_Count>0) THEN
464: l_Point_Zero_Exp_Rec :=FND_API.G_TRUE;
465: l_Dest_Instance_Found :=FND_API.G_TRUE;
466:
467: ELSIF(l_Active_Rec_Count=0 AND l_Zero_Exp_Rec_Count=0) THEN
468: l_Dest_Instance_Found :=FND_API.G_FALSE;

Line 465: l_Dest_Instance_Found :=FND_API.G_TRUE;

461: l_Dest_Instance_Found :=FND_API.G_TRUE;
462:
463: ELSIF(l_Active_Rec_Count=0 AND l_Zero_Exp_Rec_Count>0) THEN
464: l_Point_Zero_Exp_Rec :=FND_API.G_TRUE;
465: l_Dest_Instance_Found :=FND_API.G_TRUE;
466:
467: ELSIF(l_Active_Rec_Count=0 AND l_Zero_Exp_Rec_Count=0) THEN
468: l_Dest_Instance_Found :=FND_API.G_FALSE;
469:

Line 468: l_Dest_Instance_Found :=FND_API.G_FALSE;

464: l_Point_Zero_Exp_Rec :=FND_API.G_TRUE;
465: l_Dest_Instance_Found :=FND_API.G_TRUE;
466:
467: ELSIF(l_Active_Rec_Count=0 AND l_Zero_Exp_Rec_Count=0) THEN
468: l_Dest_Instance_Found :=FND_API.G_FALSE;
469:
470: END IF;
471:
472: -- get the record pointer

Line 476: IF ((l_Point_Active_Rec=FND_API.G_TRUE) AND

472: -- get the record pointer
473:
474: FOR i IN P_Dest_Instance_Tbl.FIRST ..P_Dest_Instance_Tbl.LAST
475: LOOP
476: IF ((l_Point_Active_Rec=FND_API.G_TRUE) AND
477: (P_Dest_Instance_Tbl(i).Active_End_Date IS NULL)) THEN
478: a := i;
479: EXIT;
480: ELSIF((l_Point_Zero_Exp_Rec=FND_API.G_TRUE) AND

Line 480: ELSIF((l_Point_Zero_Exp_Rec=FND_API.G_TRUE) AND

476: IF ((l_Point_Active_Rec=FND_API.G_TRUE) AND
477: (P_Dest_Instance_Tbl(i).Active_End_Date IS NULL)) THEN
478: a := i;
479: EXIT;
480: ELSIF((l_Point_Zero_Exp_Rec=FND_API.G_TRUE) AND
481: (P_Dest_Instance_Tbl(i).Active_End_Date IS NOT NULL AND
482: P_Dest_Instance_Tbl(i).Quantity = 0)) THEN
483: a := i;
484: EXIT;

Line 488: IF (l_Dest_Instance_Found =FND_API.G_TRUE) THEN

484: EXIT;
485: END IF;
486: END LOOP;
487:
488: IF (l_Dest_Instance_Found =FND_API.G_TRUE) THEN
489:
490: X_Instance_Rec.INSTANCE_ID := P_Dest_Instance_Tbl(a).INSTANCE_ID;
491: X_Instance_Rec.INSTANCE_NUMBER := P_Dest_Instance_Tbl(a).INSTANCE_NUMBER;
492: X_Instance_Rec.EXTERNAL_REFERENCE := P_Dest_Instance_Tbl(a).EXTERNAL_REFERENCE;

Line 564: x_return_status :=FND_API.G_RET_STS_ERROR;

560: WHEN Multiple_Active_Exp THEN
561: fnd_message.set_name('CSE','CSE_MULTIPLE_ACT_INST_FOUND');
562: fnd_message.set_token('INV_ITEM',P_Dest_Instance_Tbl(1).INVENTORY_ITEM_ID);
563: x_error_message := fnd_message.get;
564: x_return_status :=FND_API.G_RET_STS_ERROR;
565: WHEN OTHERS THEN
566: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
567: fnd_message.set_token('API_NAME',l_api_name);
568: fnd_message.set_token('SQL_ERROR',SQLERRM);

Line 570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

566: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
567: fnd_message.set_token('API_NAME',l_api_name);
568: fnd_message.set_token('SQL_ERROR',SQLERRM);
569: x_error_message := fnd_message.get;
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571:
572: END get_destination_instance;
573:
574: PROCEDURE get_hz_location (p_network_location_code IN VARCHAR2,

Line 590: x_return_status:=FND_API.G_RET_STS_SUCCESS;

586: l_loop_count NUMBER:=0;
587: hz_loc_not_found EXCEPTION;
588:
589: BEGIN
590: x_return_status:=FND_API.G_RET_STS_SUCCESS;
591: x_error_message:=null;
592:
593: FOR hz_loc_rec in hz_loc
594: LOOP

Line 610: x_return_status :=FND_API.G_RET_STS_ERROR;

606: WHEN hz_loc_not_found THEN
607: fnd_message.set_name('CSE','CSE_HZ_LOC_ID_NOTFOUND');
608: fnd_message.set_token('NETWORK_LOC_CODE',p_network_location_code);
609: x_error_message := fnd_message.get;
610: x_return_status :=FND_API.G_RET_STS_ERROR;
611: WHEN others THEN
612: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
613: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
614: x_error_message := fnd_message.get;

Line 615: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

611: WHEN others THEN
612: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
613: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
614: x_error_message := fnd_message.get;
615: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
616:
617: END get_hz_location;
618:
619: PROCEDURE get_hz_location (p_party_site_id IN NUMBER,

Line 635: x_return_status:=FND_API.G_RET_STS_SUCCESS;

631: l_loop_count NUMBER:=0;
632: hz_loc_not_found EXCEPTION;
633:
634: BEGIN
635: x_return_status:=FND_API.G_RET_STS_SUCCESS;
636: x_error_message:=null;
637:
638: FOR hz_loc_rec in hz_loc
639: LOOP

Line 655: x_return_status :=FND_API.G_RET_STS_ERROR;

651: WHEN hz_loc_not_found THEN
652: fnd_message.set_name('CSE','CSE_PARTY_SITE_NOTFOUND');
653: fnd_message.set_token('PARTY_SITE',p_party_site_id);
654: x_error_message := fnd_message.get;
655: x_return_status :=FND_API.G_RET_STS_ERROR;
656: WHEN others THEN
657: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
658: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
659: x_error_message := fnd_message.get;

Line 660: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

656: WHEN others THEN
657: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
658: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
659: x_error_message := fnd_message.get;
660: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
661:
662: END get_hz_location;
663:
664: PROCEDURE get_fa_location(p_hz_location_id IN NUMBER,

Line 681: x_return_status:=FND_API.G_RET_STS_SUCCESS;

677: fa_loc_not_found EXCEPTION;
678: l_api_name CONSTANT VARCHAR2(30) := 'GET_FA_LOCATION';
679:
680: BEGIN
681: x_return_status:=FND_API.G_RET_STS_SUCCESS;
682: x_error_message:=null;
683: FOR fa_loc_rec in fa_loc
684: LOOP
685:

Line 700: x_return_status :=FND_API.G_RET_STS_ERROR;

696: WHEN fa_loc_not_found THEN
697: fnd_message.set_name('CSE','CSE_FA_LOC_ID_NOTFOUND');
698: fnd_message.set_token('HZ_LOCATION_ID',p_hz_location_id);
699: x_error_message := fnd_message.get;
700: x_return_status :=FND_API.G_RET_STS_ERROR;
701: WHEN others THEN
702: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
703: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
704: x_error_message := fnd_message.get;

Line 705: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

701: WHEN others THEN
702: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
703: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
704: x_error_message := fnd_message.get;
705: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
706: END;
707:
708: PROCEDURE get_master_organization(p_organization_id IN NUMBER,
709: p_master_organization_id OUT NOCOPY NUMBER,

Line 716: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

712: IS
713:
714: l_sql_error VARCHAR2(500);
715: l_org_code VARCHAR2(3);
716: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
717: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
718: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
719: l_error_message VARCHAR2(2000);
720: e_procedure_error EXCEPTION;

Line 717: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

713:
714: l_sql_error VARCHAR2(500);
715: l_org_code VARCHAR2(3);
716: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
717: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
718: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
719: l_error_message VARCHAR2(2000);
720: e_procedure_error EXCEPTION;
721:

Line 718: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

714: l_sql_error VARCHAR2(500);
715: l_org_code VARCHAR2(3);
716: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
717: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
718: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
719: l_error_message VARCHAR2(2000);
720: e_procedure_error EXCEPTION;
721:
722: CURSOR c_name is

Line 936: l_Txn_Status_Code := FND_API.G_MISS_CHAR;

932:
933: FUNCTION Get_Txn_Status_Code(P_Txn_Status IN VARCHAR2) RETURN VARCHAR2 IS
934: l_Txn_Status_Code VARCHAR2(30) ;
935: BEGIN
936: l_Txn_Status_Code := FND_API.G_MISS_CHAR;
937: RETURN l_Txn_Status_Code;
938: END Get_Txn_Status_Code;
939:
940: FUNCTION Get_Location_Type_Code(P_Location_Meaning in VARCHAR2) RETURN VARCHAR2 IS

Line 1006: l_Txn_Action_Code := FND_API.G_MISS_CHAR;

1002: FUNCTION Get_Txn_Action_Code(P_Txn_Action IN VARCHAR2) RETURN VARCHAR2 IS
1003: l_Txn_Action_Code VARCHAR2(30) ;
1004:
1005: BEGIN
1006: l_Txn_Action_Code := FND_API.G_MISS_CHAR;
1007: RETURN l_Txn_Action_Code;
1008: END Get_Txn_Action_Code;
1009:
1010: FUNCTION Get_Fnd_Employee_Id(P_Last_Updated IN NUMBER) RETURN NUMBER IS

Line 1252: x_return_status := FND_API.G_RET_STS_SUCCESS;

1248: and ciir2.subject_id = p_id);
1249:
1250: l_dummy PLS_INTEGER;
1251: BEGIN
1252: x_return_status := FND_API.G_RET_STS_SUCCESS;
1253: x_yes_top_assembly := FALSE;
1254:
1255: OPEN check_top_assembly(p_instance_id);
1256: FETCH check_top_assembly INTO l_dummy;

Line 1270: x_return_status := fnd_api.g_ret_sts_unexp_error;

1266: THEN CLOSE check_top_assembly;
1267: END IF;
1268: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
1269: fnd_message.set_token('ERR_MSG', sqlerrm);
1270: x_return_status := fnd_api.g_ret_sts_unexp_error;
1271: x_error_message := fnd_message.get;
1272: -- CSE_DEBUG_PUB.ADD('API CSE_UTIL_PKG.check_top_assembly others exception: ' || l_err_text);
1273: END check_if_top_assembly;
1274:

Line 1310: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

1306: AND ct.transaction_date < NVL(p_transaction_date, SYSDATE)
1307: AND ct.transaction_type_id IN (l_out_of_sev, l_proj_insev, l_issue_hz, l_misc_issue_hz) ;
1308:
1309: BEGIN
1310: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
1311: x_redeploy_flag := 'N' ;
1312:
1313: l_out_of_sev := get_txn_type_id('OUT_OF_SERVICE','CSE');
1314: l_proj_insev := get_txn_type_id('PROJECT_ITEM_IN_SERVICE','CSE');

Line 1324: x_return_status := fnd_api.G_RET_STS_ERROR ;

1320: CLOSE get_redeploy_flag_cur ;
1321:
1322: EXCEPTION
1323: WHEN OTHERS THEN
1324: x_return_status := fnd_api.G_RET_STS_ERROR ;
1325: x_error_message := SQLERRM ;
1326: END get_redeploy_flag ;
1327:
1328:

Line 1347: l_commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;

1343: -- For each component and the instance itself get the instance details
1344: -- Populate the out table
1345: -------------------------------------------------------------------------------
1346: l_api_version NUMBER DEFAULT 1.0;
1347: l_commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
1348: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_TRUE;
1349: l_validation_level NUMBER := fnd_api.g_valid_level_full;
1350: l_instance_header_tbl_out csi_datastructures_pub.instance_header_tbl;
1351: l_resolve_id_columns VARCHAR2(1) DEFAULT FND_API.G_FALSE;

Line 1348: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_TRUE;

1344: -- Populate the out table
1345: -------------------------------------------------------------------------------
1346: l_api_version NUMBER DEFAULT 1.0;
1347: l_commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
1348: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_TRUE;
1349: l_validation_level NUMBER := fnd_api.g_valid_level_full;
1350: l_instance_header_tbl_out csi_datastructures_pub.instance_header_tbl;
1351: l_resolve_id_columns VARCHAR2(1) DEFAULT FND_API.G_FALSE;
1352: l_msg_index NUMBER;

Line 1349: l_validation_level NUMBER := fnd_api.g_valid_level_full;

1345: -------------------------------------------------------------------------------
1346: l_api_version NUMBER DEFAULT 1.0;
1347: l_commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
1348: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_TRUE;
1349: l_validation_level NUMBER := fnd_api.g_valid_level_full;
1350: l_instance_header_tbl_out csi_datastructures_pub.instance_header_tbl;
1351: l_resolve_id_columns VARCHAR2(1) DEFAULT FND_API.G_FALSE;
1352: l_msg_index NUMBER;
1353: l_msg_data VARCHAR2(2000);

Line 1351: l_resolve_id_columns VARCHAR2(1) DEFAULT FND_API.G_FALSE;

1347: l_commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
1348: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_TRUE;
1349: l_validation_level NUMBER := fnd_api.g_valid_level_full;
1350: l_instance_header_tbl_out csi_datastructures_pub.instance_header_tbl;
1351: l_resolve_id_columns VARCHAR2(1) DEFAULT FND_API.G_FALSE;
1352: l_msg_index NUMBER;
1353: l_msg_data VARCHAR2(2000);
1354: l_msg_count NUMBER;
1355: l_return_status VARCHAR2(1);

Line 1407: IF l_return_status = fnd_api.g_ret_sts_error

1403:
1404: cse_util_pkg.write_log('Return Status : '|| l_return_status);
1405:
1406:
1407: IF l_return_status = fnd_api.g_ret_sts_error
1408: THEN
1409: l_msg_index := 1;
1410: l_error_message:=l_msg_data;
1411: WHILE l_msg_count > 0

Line 1413: l_error_message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE)||l_error_message;

1409: l_msg_index := 1;
1410: l_error_message:=l_msg_data;
1411: WHILE l_msg_count > 0
1412: LOOP
1413: l_error_message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE)||l_error_message;
1414: l_msg_index := l_msg_index + 1;
1415: l_msg_count := l_msg_count - 1;
1416: END LOOP;
1417: RAISE e_error;

Line 1436: p_active_relationship_only => fnd_api.g_true,

1432: p_validation_level => l_validation_level ,
1433: p_relationship_query_rec => l_relationship_query_rec ,
1434: p_depth => NULL,
1435: p_time_stamp => p_transaction_date,
1436: p_active_relationship_only => fnd_api.g_true,
1437: x_relationship_tbl => l_ii_relationship_tbl ,
1438: x_return_status => l_return_status ,
1439: x_msg_count => l_msg_count ,
1440: x_msg_data => l_msg_data);

Line 1442: IF l_return_status = fnd_api.g_ret_sts_error

1438: x_return_status => l_return_status ,
1439: x_msg_count => l_msg_count ,
1440: x_msg_data => l_msg_data);
1441:
1442: IF l_return_status = fnd_api.g_ret_sts_error
1443: THEN
1444: l_msg_index := 1;
1445: l_error_message:=l_msg_data;
1446: WHILE l_msg_count > 0

Line 1448: l_error_message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE)||l_error_message;

1444: l_msg_index := 1;
1445: l_error_message:=l_msg_data;
1446: WHILE l_msg_count > 0
1447: LOOP
1448: l_error_message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE)||l_error_message;
1449: l_msg_index := l_msg_index + 1;
1450: l_msg_count := l_msg_count - 1;
1451: END LOOP;
1452: RAISE e_error;

Line 1488: IF l_return_status = fnd_api.g_ret_sts_error

1484: x_return_status => l_return_status,
1485: x_msg_count => l_Msg_Count,
1486: x_msg_data => l_Msg_Data );
1487:
1488: IF l_return_status = fnd_api.g_ret_sts_error
1489: THEN
1490: l_msg_index := 1;
1491: l_error_message:=l_msg_data;
1492: WHILE l_msg_count > 0

Line 1494: l_error_message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE)||l_error_message;

1490: l_msg_index := 1;
1491: l_error_message:=l_msg_data;
1492: WHILE l_msg_count > 0
1493: LOOP
1494: l_error_message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE)||l_error_message;
1495: l_msg_index := l_msg_index + 1;
1496: l_msg_count := l_msg_count - 1;
1497: END LOOP;
1498: RAISE e_error;

Line 1516: x_return_status := fnd_api.G_RET_STS_ERROR ;

1512: END LOOP ;
1513:
1514: EXCEPTION
1515: WHEN e_error THEN
1516: x_return_status := fnd_api.G_RET_STS_ERROR ;
1517: x_error_message := l_error_message ;
1518: cse_util_pkg.write_log('In error :'||substr(x_error_message,1,200));
1519: WHEN OTHERS THEN
1520: x_return_status := fnd_api.G_RET_STS_ERROR ;

Line 1520: x_return_status := fnd_api.G_RET_STS_ERROR ;

1516: x_return_status := fnd_api.G_RET_STS_ERROR ;
1517: x_error_message := l_error_message ;
1518: cse_util_pkg.write_log('In error :'||substr(x_error_message,1,200));
1519: WHEN OTHERS THEN
1520: x_return_status := fnd_api.G_RET_STS_ERROR ;
1521: x_error_message := SQLERRM ;
1522: cse_util_pkg.write_log('In other exception :'||x_error_message);
1523: END get_inst_n_comp_dtls ;
1524:

Line 1544: p_encoded => fnd_api.g_false,

1540: FOR l_ind IN 1..l_msg_count
1541: LOOP
1542: fnd_msg_pub.get(
1543: p_msg_index => l_ind,
1544: p_encoded => fnd_api.g_false,
1545: p_data => l_msg_data,
1546: p_msg_index_out => l_msg_index_out);
1547:
1548: x_msg_data := ltrim(x_msg_data||' '||l_msg_data);