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.PO_INQ_SV dependencies on PO_INQ_SV

Line 1: PACKAGE BODY PO_INQ_SV as

1: PACKAGE BODY PO_INQ_SV as
2: /* $Header: POXPOVPB.pls 120.3 2006/04/12 16:53:59 dreddy noship $*/
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PO_INQ_SV';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PO_INQ_SV';

1: PACKAGE BODY PO_INQ_SV as
2: /* $Header: POXPOVPB.pls 120.3 2006/04/12 16:53:59 dreddy noship $*/
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PO_INQ_SV';
6: G_LOG_HEAD CONSTANT VARCHAR2(50) := 'po.plsql.'||G_PKG_NAME||'.';
7: G_DEBUG_STMT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
8: G_DEBUG_UNEXP BOOLEAN := PO_DEBUG.is_debug_unexp_on;
9: --

Line 11: /============================= PO_INQ_SV ===============================/

7: G_DEBUG_STMT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
8: G_DEBUG_UNEXP BOOLEAN := PO_DEBUG.is_debug_unexp_on;
9: --
10:
11: /*============================= PO_INQ_SV ===============================*/
12: /* Local procedure */
13: PROCEDURE get_lookup_dsp(p_lookup_type IN PO_LOOKUP_CODES.lookup_type%TYPE,
14: p_lookup_code IN PO_LOOKUP_CODES.lookup_code%TYPE,
15: x_displayed_field OUT NOCOPY PO_LOOKUP_CODES.displayed_field%TYPE);

Line 930: x_assembly_quantity := PO_INQ_SV.GET_ASSEMBLY_QUANTITY(

926:
927: x_base_currency := po_core_s2.get_base_currency;
928:
929: IF x_wip_entity_id IS NOT NULL THEN
930: x_assembly_quantity := PO_INQ_SV.GET_ASSEMBLY_QUANTITY(
931: x_item_id,
932: x_wip_entity_id,
933: x_wip_operation_seq_num,
934: x_wip_resource_seq_num,

Line 939: x_resource_quantity := PO_INQ_SV.GET_RESOURCE_QUANTITY(

935: x_destination_org_id,
936: x_wip_rep_schedule_id,
937: x_quantity_ordered);
938:
939: x_resource_quantity := PO_INQ_SV.GET_RESOURCE_QUANTITY(
940: x_item_id,
941: x_wip_entity_id,
942: x_wip_operation_seq_num,
943: x_wip_resource_seq_num,

Line 949: x_wip_operation_code := PO_INQ_SV.GET_WIP_OPERATION_CODE(

945: x_wip_rep_schedule_id,
946: x_quantity_ordered);
947:
948:
949: x_wip_operation_code := PO_INQ_SV.GET_WIP_OPERATION_CODE(
950: x_WIP_ENTITY_ID,
951: x_WIP_OPERATION_SEQ_NUM,
952: x_DESTINATION_ORG_ID,
953: x_WIP_REP_SCHEDULE_ID) ;

Line 955: x_bom_department_code := PO_INQ_SV.GET_BOM_DEPARTMENT_CODE(

951: x_WIP_OPERATION_SEQ_NUM,
952: x_DESTINATION_ORG_ID,
953: x_WIP_REP_SCHEDULE_ID) ;
954:
955: x_bom_department_code := PO_INQ_SV.GET_BOM_DEPARTMENT_CODE(
956: x_WIP_ENTITY_ID,
957: x_WIP_OPERATION_SEQ_NUM,
958: x_DESTINATION_ORG_ID,
959: x_WIP_REP_SCHEDULE_ID);

Line 967: x_distribution_amount := PO_INQ_SV.GET_DIST_AMOUNT(

963: /* Changed due to bug 601388
964: Removed the IN parameter x_rate when calling the function
965: */
966:
967: x_distribution_amount := PO_INQ_SV.GET_DIST_AMOUNT(
968: x_QUANTITY_ORDERED,
969: x_PRICE_OVERRIDE,
970: X_AMOUNT_ORDERED, --
971: X_LINE_LOCATION_ID) ; --

Line 973: x_active_encumb_amount := PO_INQ_SV.GET_ACTIVE_ENC_AMOUNT(

969: x_PRICE_OVERRIDE,
970: X_AMOUNT_ORDERED, --
971: X_LINE_LOCATION_ID) ; --
972:
973: x_active_encumb_amount := PO_INQ_SV.GET_ACTIVE_ENC_AMOUNT(
974: x_RATE,
975: x_ENCUMBERED_AMOUNT,
976: x_SHIPMENT_TYPE,
977: x_PO_DISTRIBUTION_ID);

Line 1040: po_message_s.sql_error('po_inq_sv.get_org_info', x_progress, sqlcode);

1036: end if;
1037:
1038: EXCEPTION
1039: WHEN OTHERS THEN
1040: po_message_s.sql_error('po_inq_sv.get_org_info', x_progress, sqlcode);
1041: raise;
1042: END;
1043:
1044: /*===========================================================================

Line 1099: po_message_s.sql_error('po_inq_sv.get_location_info', x_progress, sqlcode);

1095: end if;
1096:
1097: EXCEPTION
1098: WHEN OTHERS THEN
1099: po_message_s.sql_error('po_inq_sv.get_location_info', x_progress, sqlcode);
1100: raise;
1101: END;
1102:
1103: /*===========================================================================

Line 1138: po_message_s.sql_error('po_inq_sv.get_project_info', x_progress, sqlcode);

1134:
1135: EXCEPTION
1136:
1137: WHEN OTHERS THEN
1138: po_message_s.sql_error('po_inq_sv.get_project_info', x_progress, sqlcode);
1139: raise;
1140: END;
1141:
1142: /*===========================================================================

Line 1214: po_message_s.sql_error('po_inq_sv.get_wip_bom_info', x_progress, sqlcode);

1210:
1211:
1212: EXCEPTION
1213: WHEN OTHERS THEN
1214: po_message_s.sql_error('po_inq_sv.get_wip_bom_info', x_progress, sqlcode);
1215: raise;
1216: END;
1217:
1218: /*===========================================================================

Line 1263: po_message_s.sql_error('po_inq_sv.get_vendor_info', x_progress, sqlcode);

1259: end if;
1260:
1261: EXCEPTION
1262: WHEN OTHERS THEN
1263: po_message_s.sql_error('po_inq_sv.get_vendor_info', x_progress, sqlcode);
1264: raise;
1265: END;
1266:
1267: /*===========================================================================

Line 1292: po_message_s.sql_error('po_inq_sv.get_ap_terms', x_progress, sqlcode);

1288: CLOSE c1;
1289:
1290: EXCEPTION
1291: WHEN OTHERS THEN
1292: po_message_s.sql_error('po_inq_sv.get_ap_terms', x_progress, sqlcode);
1293: raise;
1294: END;
1295:
1296: /*===========================================================================

Line 1401: exception_type => 'PO_INQ_SV.get_dist_info_pq',

1397: x_return_status => l_return_status);
1398:
1399: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
1400: APP_EXCEPTION.raise_exception(
1401: exception_type => 'PO_INQ_SV.get_dist_info_pq',
1402: exception_code => 0,
1403: exception_text => 'Exception in PO_SHARED_PROC_PVT.' ||
1404: 'get_ou_and_coa_from_inv_org() - '||
1405: 'po_line_location_id='||x_po_line_location_id||

Line 1427: exception_type => 'PO_INQ_SV.get_dist_info_pq',

1423: AND gsb.set_of_books_id = fspa.set_of_books_id;
1424: EXCEPTION
1425: WHEN OTHERS THEN
1426: APP_EXCEPTION.raise_exception(
1427: exception_type => 'PO_INQ_SV.get_dist_info_pq',
1428: exception_code => 0,
1429: exception_text => 'Could not find Chart of Accounts for ' ||
1430: 'Purchasing Operating Unit - '||
1431: 'po_line_location_id='||x_po_line_location_id);

Line 1488: po_message_s.sql_error('po_inq_sv.get_dist_info_pq', x_progress, sqlcode);

1484: x_progress := '007';
1485:
1486: EXCEPTION
1487: WHEN OTHERS THEN
1488: po_message_s.sql_error('po_inq_sv.get_dist_info_pq', x_progress, sqlcode);
1489: raise;
1490: END;
1491:
1492: /*===========================================================================

Line 1597: po_message_s.sql_error('po_inq_sv.get_shipments_pq_lookups', x_progress, sqlcode);

1593: --Bug 2947251 END
1594:
1595: EXCEPTION
1596: WHEN OTHERS THEN
1597: po_message_s.sql_error('po_inq_sv.get_shipments_pq_lookups', x_progress, sqlcode);
1598: raise;
1599: END;
1600:
1601: /*===========================================================================

Line 1658: po_message_s.sql_error('po_inq_sv.get_dist_pq_lookups', x_progress, sqlcode);

1654: end if;
1655:
1656: EXCEPTION
1657: WHEN OTHERS THEN
1658: po_message_s.sql_error('po_inq_sv.get_dist_pq_lookups', x_progress, sqlcode);
1659: raise;
1660: END get_dist_pq_lookups;
1661:
1662: /*===========================================================================

Line 1748: po_message_s.sql_error('po_inq_sv.get_lines_pq_lookups', x_progress, sqlcode);

1744:
1745:
1746: EXCEPTION
1747: WHEN OTHERS THEN
1748: po_message_s.sql_error('po_inq_sv.get_lines_pq_lookups', x_progress, sqlcode);
1749: raise;
1750: END;
1751:
1752: /*===========================================================================

Line 1822: po_message_s.sql_error('po_inq_sv.get_headers_pq_lookups', x_progress, sqlcode);

1818: --
1819:
1820: EXCEPTION
1821: WHEN OTHERS THEN
1822: po_message_s.sql_error('po_inq_sv.get_headers_pq_lookups', x_progress, sqlcode);
1823: raise;
1824: END;
1825:
1826: /*===========================================================================

Line 2190: END PO_INQ_SV;

2186: RETURN NULL;
2187: END get_vendor_email;
2188: --
2189:
2190: END PO_INQ_SV;