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

Line 396: IF (p_is_preview = FND_API.g_true) THEN

392: G_XML_IRCODE || '="' || l_item_reference_code || '" ' ||
393: G_XML_REF || '="f" ' ||
394: G_XML_ENC || '="' || LOWER(p_encrypt_flag) || '" ';
395: -- // Preview Url
396: IF (p_is_preview = FND_API.g_true) THEN
397: l_buffer := l_buffer ||
398: G_XML_URL || '="' || Ibc_Utilities_Pub.G_PCITEM_SERVLET_URL || 'cItemId=' || p_content_item_id
399: || Fnd_Global.local_chr(38) || 'amp;cItemVerId=' || p_citem_version_id ||
400: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(p_encrypt_flag) ||

Line 515: IF (p_root_tag_only_flag = Fnd_Api.G_FALSE) THEN

511: G_XML_REF || '="f" ' ||
512: '>';
513:
514: -- Include Name, Description and Attachment tags
515: IF (p_root_tag_only_flag = Fnd_Api.G_FALSE) THEN
516: l_buffer := l_buffer ||
517: ' 518: p_content_item_name ||
519: ']]>' ||

Line 751: l_temp_msg := Fnd_Msg_Pub.get(Fnd_Msg_Pub.g_next, Fnd_Api.g_true);

747: AND lng.LANGUAGE_CODE = msg.language_code
748: AND lng.language_id = x_lang_id;
749: BEGIN
750: FOR l_count IN 1..NVL(p_message_count,0) LOOP
751: l_temp_msg := Fnd_Msg_Pub.get(Fnd_Msg_Pub.g_next, Fnd_Api.g_true);
752: Fnd_Message.parse_encoded(l_temp_msg, l_appl_short_name, l_message_name);
753: OPEN Get_Appl_Id (l_appl_short_name);
754: FETCH Get_Appl_Id INTO l_id;
755: CLOSE Get_Appl_Id;

Line 766: l_temp_msg := Fnd_Msg_Pub.get(Fnd_Msg_Pub.g_previous, Fnd_Api.g_true);

762: FETCH Get_Message_Num INTO l_message_num;
763: CLOSE Get_Message_Num;
764: END IF;
765:
766: l_temp_msg := Fnd_Msg_Pub.get(Fnd_Msg_Pub.g_previous, Fnd_Api.g_true);
767:
768: IF NVL(l_message_num, 0) <> 0
769: THEN
770: l_temp_msg := 'APP-' || TO_CHAR(l_message_num) || ': ';

Line 778: Fnd_Msg_Pub.get(Fnd_Msg_Pub.g_first, Fnd_Api.g_false);

774:
775: IF l_count = 1
776: THEN
777: l_msg_list := l_msg_list || l_temp_msg ||
778: Fnd_Msg_Pub.get(Fnd_Msg_Pub.g_first, Fnd_Api.g_false);
779: ELSE
780: l_msg_list := l_msg_list || l_temp_msg ||
781: Fnd_Msg_Pub.get(Fnd_Msg_Pub.g_next, Fnd_Api.g_false);
782: END IF;

Line 781: Fnd_Msg_Pub.get(Fnd_Msg_Pub.g_next, Fnd_Api.g_false);

777: l_msg_list := l_msg_list || l_temp_msg ||
778: Fnd_Msg_Pub.get(Fnd_Msg_Pub.g_first, Fnd_Api.g_false);
779: ELSE
780: l_msg_list := l_msg_list || l_temp_msg ||
781: Fnd_Msg_Pub.get(Fnd_Msg_Pub.g_next, Fnd_Api.g_false);
782: END IF;
783:
784: l_msg_list := l_msg_list || '
785: ';

Line 832: x_return_status := Fnd_Api.G_RET_STS_ERROR;

828: -- DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || p_package_type);
829:
830: IF p_exception_level = Fnd_Msg_Pub.G_MSG_LVL_ERROR
831: THEN
832: x_return_status := Fnd_Api.G_RET_STS_ERROR;
833: x_msg_count := Fnd_Msg_Pub.Count_msg();
834: x_msg_data := Fnd_Msg_Pub.get(Fnd_Msg_Pub.G_FIRST);
835: ELSIF p_exception_level = Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
836: THEN

Line 837: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

833: x_msg_count := Fnd_Msg_Pub.Count_msg();
834: x_msg_data := Fnd_Msg_Pub.get(Fnd_Msg_Pub.G_FIRST);
835: ELSIF p_exception_level = Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
836: THEN
837: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
838: x_msg_count := Fnd_Msg_Pub.Count_msg();
839: x_msg_data := Fnd_Msg_Pub.get(Fnd_Msg_Pub.G_FIRST);
840: ELSIF p_exception_level = G_EXC_OTHERS
841: THEN

Line 842: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

838: x_msg_count := Fnd_Msg_Pub.Count_msg();
839: x_msg_data := Fnd_Msg_Pub.get(Fnd_Msg_Pub.G_FIRST);
840: ELSIF p_exception_level = G_EXC_OTHERS
841: THEN
842: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
843:
844: Fnd_Message.Set_Name('IBC', 'IBC_ERROR_RETURNED');
845: Fnd_Message.Set_token('PKG_NAME' , p_pkg_name);
846: Fnd_Message.Set_token('API_NAME' , p_api_name);

Line 876: IF p_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

872:
873: PROCEDURE Handle_Ret_Status(p_return_Status VARCHAR2)
874: IS
875: BEGIN
876: IF p_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
877: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
878: ELSIF p_return_status = Fnd_Api.G_RET_STS_ERROR THEN
879: RAISE Fnd_Api.G_EXC_ERROR;
880: END IF;

Line 877: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

873: PROCEDURE Handle_Ret_Status(p_return_Status VARCHAR2)
874: IS
875: BEGIN
876: IF p_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
877: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
878: ELSIF p_return_status = Fnd_Api.G_RET_STS_ERROR THEN
879: RAISE Fnd_Api.G_EXC_ERROR;
880: END IF;
881:

Line 878: ELSIF p_return_status = Fnd_Api.G_RET_STS_ERROR THEN

874: IS
875: BEGIN
876: IF p_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
877: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
878: ELSIF p_return_status = Fnd_Api.G_RET_STS_ERROR THEN
879: RAISE Fnd_Api.G_EXC_ERROR;
880: END IF;
881:
882: END Handle_Ret_Status;

Line 879: RAISE Fnd_Api.G_EXC_ERROR;

875: BEGIN
876: IF p_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
877: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
878: ELSIF p_return_status = Fnd_Api.G_RET_STS_ERROR THEN
879: RAISE Fnd_Api.G_EXC_ERROR;
880: END IF;
881:
882: END Handle_Ret_Status;
883:

Line 920: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

916: )
917: IS
918: l_api_name CONSTANT VARCHAR2(30) := 'insert_attachment';
919: BEGIN
920: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
921:
922: -- *** VALIDATION OF VALUES ******
923: -- file format
924: IF ((p_file_format <> 'text') AND (p_file_format <> 'binary')) THEN

Line 925: x_return_status := Fnd_Api.G_RET_STS_ERROR;

921:
922: -- *** VALIDATION OF VALUES ******
923: -- file format
924: IF ((p_file_format <> 'text') AND (p_file_format <> 'binary')) THEN
925: x_return_status := Fnd_Api.G_RET_STS_ERROR;
926: Fnd_Message.Set_Name('IBC', 'BAD_INPUT_VALUE');
927: Fnd_Message.Set_Token('INPUT', 'p_file_format', FALSE);
928: Fnd_Msg_Pub.ADD;
929: END IF;

Line 932: x_return_status := Fnd_Api.G_RET_STS_ERROR;

928: Fnd_Msg_Pub.ADD;
929: END IF;
930: -- mime type
931: IF (p_mime_type IS NULL) THEN
932: x_return_status := Fnd_Api.G_RET_STS_ERROR;
933: Fnd_Message.Set_Name('IBC', 'BAD_INPUT_VALUE');
934: Fnd_Message.Set_Token('INPUT', 'p_mime_type', FALSE);
935: Fnd_Msg_Pub.ADD;
936: END IF;

Line 970: x_return_status := Fnd_Api.G_RET_STS_ERROR;

966: );
967:
968: EXCEPTION
969: WHEN OTHERS THEN
970: x_return_status := Fnd_Api.G_RET_STS_ERROR;
971: Fnd_Message.Set_Name('IBC', 'LOB_INSERT_ERROR');
972: Fnd_Msg_Pub.ADD;
973: END;
974:

Line 1037: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1033: IS
1034: l_api_name CONSTANT VARCHAR2(30) := 'insert_attribute_bundle';
1035:
1036: BEGIN
1037: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1038:
1039: -- Getting next fnd_lobs sequence number
1040: SELECT ibc_attribute_bundles_s1.NEXTVAL
1041: INTO x_lob_file_id

Line 1065: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1061: ,1
1062: );
1063: EXCEPTION
1064: WHEN OTHERS THEN
1065: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1066: Fnd_Message.Set_Name('IBC', 'LOB_INSERT_ERROR');
1067: Fnd_Msg_Pub.ADD;
1068: END;
1069:

Line 1097: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1093: )
1094: IS
1095: l_api_name CONSTANT VARCHAR2(30) := 'touch_attribute_bundle';
1096: BEGIN
1097: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1098:
1099: -- Getting next fnd_lobs sequence number
1100: SELECT
1101: fnd_lobs_s.NEXTVAL

Line 1131: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1127: 'text');
1128:
1129: EXCEPTION
1130: WHEN OTHERS THEN
1131: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1132: Fnd_Message.Set_Name('IBC', 'LOB_INSERT_ERROR');
1133: Fnd_Msg_Pub.ADD;
1134: END;
1135:

Line 1396: -- DESCRIPTION: Returns FND_API.g_true, it's useful

1392: END post_insert_attrib;
1393:
1394: ---------------------------------------------------------
1395: -- FUNCTION: g_true
1396: -- DESCRIPTION: Returns FND_API.g_true, it's useful
1397: -- to access the value from SQL stmts
1398: ---------------------------------------------------------
1399: FUNCTION g_true RETURN VARCHAR2 IS
1400: BEGIN

Line 1401: RETURN Fnd_Api.g_true;

1397: -- to access the value from SQL stmts
1398: ---------------------------------------------------------
1399: FUNCTION g_true RETURN VARCHAR2 IS
1400: BEGIN
1401: RETURN Fnd_Api.g_true;
1402: END g_true;
1403:
1404: ---------------------------------------------------------
1405: -- FUNCTION: g_false

Line 1406: -- DESCRIPTION: Returns FND_API.g_false, it's useful

1402: END g_true;
1403:
1404: ---------------------------------------------------------
1405: -- FUNCTION: g_false
1406: -- DESCRIPTION: Returns FND_API.g_false, it's useful
1407: -- to access the value from SQL stmts
1408: ---------------------------------------------------------
1409: FUNCTION g_false RETURN VARCHAR2 IS
1410: BEGIN

Line 1411: RETURN Fnd_Api.g_false;

1407: -- to access the value from SQL stmts
1408: ---------------------------------------------------------
1409: FUNCTION g_false RETURN VARCHAR2 IS
1410: BEGIN
1411: RETURN Fnd_Api.g_false;
1412: END g_false;
1413:
1414: ---------------------------------------------------------
1415: -- FUNCTION: Is_Name_Already_Used

Line 1526: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1522: PRAGMA AUTONOMOUS_TRANSACTION;
1523:
1524: BEGIN
1525:
1526: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1527: -- Getting next fnd_lobs sequence number
1528: SELECT
1529: fnd_lobs_s.NEXTVAL INTO x_file_id
1530: FROM

Line 1559: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1555: COMMIT;
1556:
1557: EXCEPTION
1558: WHEN OTHERS THEN
1559: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1560: Fnd_Message.Set_Name('IBC', 'LOB_INSERT_ERROR');
1561: Fnd_Msg_Pub.ADD;
1562:
1563: END Create_Autonomous_Upload;

Line 1606: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1602:
1603: l_pcatquery VARCHAR2(1000) := 'SELECT CATEGORY_DESC assoc_name,CONCAT_CAT_PARENTAGE assoc_code FROM ENI_PROD_DEN_HRCHY_PARENTS_V WHERE CATEGORY_ID = :p_assoc_object_val2 AND CATEGORY_SET_ID = :p_assoc_object_val1';
1604:
1605: BEGIN
1606: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1607:
1608: IF (p_assoc_type_code = 'IBC_PRODUCT') THEN
1609: OPEN c_product_info;
1610: FETCH c_product_info INTO l_assoc_name, l_assoc_code;

Line 1625: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1621: END IF;
1622:
1623: EXCEPTION
1624: WHEN OTHERS THEN
1625: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1626: END Get_Object_Name;
1627:
1628: --------------------------------------------------------------------------------
1629: -- Start of comments