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 1312: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

1308: AND ct.transaction_date < NVL(p_transaction_date, SYSDATE)
1309: AND ct.transaction_type_id IN (l_out_of_sev, l_proj_insev, l_issue_hz, l_misc_issue_hz) ;
1310:
1311: BEGIN
1312: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
1313: x_redeploy_flag := 'N' ;
1314: --Added client extension call for bug 9644951
1315: cse_asset_client_ext_stub.get_redeploy_flag( p_inventory_item_id,
1316: p_serial_number,

Line 1337: x_return_status := fnd_api.G_RET_STS_ERROR ;

1333: END IF;
1334:
1335: EXCEPTION
1336: WHEN OTHERS THEN
1337: x_return_status := fnd_api.G_RET_STS_ERROR ;
1338: x_error_message := SQLERRM ;
1339: END get_redeploy_flag ;
1340:
1341:

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

1356: -- For each component and the instance itself get the instance details
1357: -- Populate the out table
1358: -------------------------------------------------------------------------------
1359: l_api_version NUMBER DEFAULT 1.0;
1360: l_commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
1361: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_TRUE;
1362: l_validation_level NUMBER := fnd_api.g_valid_level_full;
1363: l_instance_header_tbl_out csi_datastructures_pub.instance_header_tbl;
1364: l_resolve_id_columns VARCHAR2(1) DEFAULT FND_API.G_FALSE;

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

1357: -- Populate the out table
1358: -------------------------------------------------------------------------------
1359: l_api_version NUMBER DEFAULT 1.0;
1360: l_commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
1361: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_TRUE;
1362: l_validation_level NUMBER := fnd_api.g_valid_level_full;
1363: l_instance_header_tbl_out csi_datastructures_pub.instance_header_tbl;
1364: l_resolve_id_columns VARCHAR2(1) DEFAULT FND_API.G_FALSE;
1365: l_msg_index NUMBER;

Line 1362: l_validation_level NUMBER := fnd_api.g_valid_level_full;

1358: -------------------------------------------------------------------------------
1359: l_api_version NUMBER DEFAULT 1.0;
1360: l_commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
1361: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_TRUE;
1362: l_validation_level NUMBER := fnd_api.g_valid_level_full;
1363: l_instance_header_tbl_out csi_datastructures_pub.instance_header_tbl;
1364: l_resolve_id_columns VARCHAR2(1) DEFAULT FND_API.G_FALSE;
1365: l_msg_index NUMBER;
1366: l_msg_data VARCHAR2(2000);

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

1360: l_commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
1361: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_TRUE;
1362: l_validation_level NUMBER := fnd_api.g_valid_level_full;
1363: l_instance_header_tbl_out csi_datastructures_pub.instance_header_tbl;
1364: l_resolve_id_columns VARCHAR2(1) DEFAULT FND_API.G_FALSE;
1365: l_msg_index NUMBER;
1366: l_msg_data VARCHAR2(2000);
1367: l_msg_count NUMBER;
1368: l_return_status VARCHAR2(1);

Line 1420: IF l_return_status = fnd_api.g_ret_sts_error

1416:
1417: cse_util_pkg.write_log('Return Status : '|| l_return_status);
1418:
1419:
1420: IF l_return_status = fnd_api.g_ret_sts_error
1421: THEN
1422: l_msg_index := 1;
1423: l_error_message:=l_msg_data;
1424: WHILE l_msg_count > 0

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

1422: l_msg_index := 1;
1423: l_error_message:=l_msg_data;
1424: WHILE l_msg_count > 0
1425: LOOP
1426: l_error_message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE)||l_error_message;
1427: l_msg_index := l_msg_index + 1;
1428: l_msg_count := l_msg_count - 1;
1429: END LOOP;
1430: RAISE e_error;

Line 1449: p_active_relationship_only => fnd_api.g_true,

1445: p_validation_level => l_validation_level ,
1446: p_relationship_query_rec => l_relationship_query_rec ,
1447: p_depth => NULL,
1448: p_time_stamp => p_transaction_date,
1449: p_active_relationship_only => fnd_api.g_true,
1450: x_relationship_tbl => l_ii_relationship_tbl ,
1451: x_return_status => l_return_status ,
1452: x_msg_count => l_msg_count ,
1453: x_msg_data => l_msg_data);

Line 1455: IF l_return_status = fnd_api.g_ret_sts_error

1451: x_return_status => l_return_status ,
1452: x_msg_count => l_msg_count ,
1453: x_msg_data => l_msg_data);
1454:
1455: IF l_return_status = fnd_api.g_ret_sts_error
1456: THEN
1457: l_msg_index := 1;
1458: l_error_message:=l_msg_data;
1459: WHILE l_msg_count > 0

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

1457: l_msg_index := 1;
1458: l_error_message:=l_msg_data;
1459: WHILE l_msg_count > 0
1460: LOOP
1461: l_error_message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE)||l_error_message;
1462: l_msg_index := l_msg_index + 1;
1463: l_msg_count := l_msg_count - 1;
1464: END LOOP;
1465: RAISE e_error;

Line 1501: IF l_return_status = fnd_api.g_ret_sts_error

1497: x_return_status => l_return_status,
1498: x_msg_count => l_Msg_Count,
1499: x_msg_data => l_Msg_Data );
1500:
1501: IF l_return_status = fnd_api.g_ret_sts_error
1502: THEN
1503: l_msg_index := 1;
1504: l_error_message:=l_msg_data;
1505: WHILE l_msg_count > 0

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

1503: l_msg_index := 1;
1504: l_error_message:=l_msg_data;
1505: WHILE l_msg_count > 0
1506: LOOP
1507: l_error_message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE)||l_error_message;
1508: l_msg_index := l_msg_index + 1;
1509: l_msg_count := l_msg_count - 1;
1510: END LOOP;
1511: RAISE e_error;

Line 1529: x_return_status := fnd_api.G_RET_STS_ERROR ;

1525: END LOOP ;
1526:
1527: EXCEPTION
1528: WHEN e_error THEN
1529: x_return_status := fnd_api.G_RET_STS_ERROR ;
1530: x_error_message := l_error_message ;
1531: cse_util_pkg.write_log('In error :'||substr(x_error_message,1,200));
1532: WHEN OTHERS THEN
1533: x_return_status := fnd_api.G_RET_STS_ERROR ;

Line 1533: x_return_status := fnd_api.G_RET_STS_ERROR ;

1529: x_return_status := fnd_api.G_RET_STS_ERROR ;
1530: x_error_message := l_error_message ;
1531: cse_util_pkg.write_log('In error :'||substr(x_error_message,1,200));
1532: WHEN OTHERS THEN
1533: x_return_status := fnd_api.G_RET_STS_ERROR ;
1534: x_error_message := SQLERRM ;
1535: cse_util_pkg.write_log('In other exception :'||x_error_message);
1536: END get_inst_n_comp_dtls ;
1537:

Line 1557: p_encoded => fnd_api.g_false,

1553: FOR l_ind IN 1..l_msg_count
1554: LOOP
1555: fnd_msg_pub.get(
1556: p_msg_index => l_ind,
1557: p_encoded => fnd_api.g_false,
1558: p_data => l_msg_data,
1559: p_msg_index_out => l_msg_index_out);
1560:
1561: x_msg_data := ltrim(x_msg_data||' '||l_msg_data);