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.11.12020000.3 2013/02/10 13:29:57 vegajula ship $*/
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.11.12020000.3 2013/02/10 13:29:57 vegajula ship $*/
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 982: x_assembly_quantity := PO_INQ_SV.GET_ASSEMBLY_QUANTITY(

978:
979: x_base_currency := po_core_s2.get_base_currency;
980:
981: IF x_wip_entity_id IS NOT NULL THEN
982: x_assembly_quantity := PO_INQ_SV.GET_ASSEMBLY_QUANTITY(
983: x_item_id,
984: x_wip_entity_id,
985: x_wip_operation_seq_num,
986: x_wip_resource_seq_num,

Line 991: x_resource_quantity := PO_INQ_SV.GET_RESOURCE_QUANTITY(

987: x_destination_org_id,
988: x_wip_rep_schedule_id,
989: x_quantity_ordered);
990:
991: x_resource_quantity := PO_INQ_SV.GET_RESOURCE_QUANTITY(
992: x_item_id,
993: x_wip_entity_id,
994: x_wip_operation_seq_num,
995: x_wip_resource_seq_num,

Line 1001: x_wip_operation_code := PO_INQ_SV.GET_WIP_OPERATION_CODE(

997: x_wip_rep_schedule_id,
998: x_quantity_ordered);
999:
1000:
1001: x_wip_operation_code := PO_INQ_SV.GET_WIP_OPERATION_CODE(
1002: x_WIP_ENTITY_ID,
1003: x_WIP_OPERATION_SEQ_NUM,
1004: x_DESTINATION_ORG_ID,
1005: x_WIP_REP_SCHEDULE_ID) ;

Line 1007: x_bom_department_code := PO_INQ_SV.GET_BOM_DEPARTMENT_CODE(

1003: x_WIP_OPERATION_SEQ_NUM,
1004: x_DESTINATION_ORG_ID,
1005: x_WIP_REP_SCHEDULE_ID) ;
1006:
1007: x_bom_department_code := PO_INQ_SV.GET_BOM_DEPARTMENT_CODE(
1008: x_WIP_ENTITY_ID,
1009: x_WIP_OPERATION_SEQ_NUM,
1010: x_DESTINATION_ORG_ID,
1011: x_WIP_REP_SCHEDULE_ID);

Line 1019: x_distribution_amount := PO_INQ_SV.GET_DIST_AMOUNT(

1015: /* Changed due to bug 601388
1016: Removed the IN parameter x_rate when calling the function
1017: */
1018:
1019: x_distribution_amount := PO_INQ_SV.GET_DIST_AMOUNT(
1020: x_QUANTITY_ORDERED,
1021: x_PRICE_OVERRIDE,
1022: X_AMOUNT_ORDERED, --
1023: X_LINE_LOCATION_ID, --

Line 1027: x_active_encumb_amount := PO_INQ_SV.GET_ACTIVE_ENC_AMOUNT(

1023: X_LINE_LOCATION_ID, --
1024: x_po_distribution_id); -- Bug 13440718
1025:
1026:
1027: x_active_encumb_amount := PO_INQ_SV.GET_ACTIVE_ENC_AMOUNT(
1028: x_RATE,
1029: x_ENCUMBERED_AMOUNT,
1030: x_SHIPMENT_TYPE,
1031: x_PO_DISTRIBUTION_ID);

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

1090: end if;
1091:
1092: EXCEPTION
1093: WHEN OTHERS THEN
1094: po_message_s.sql_error('po_inq_sv.get_org_info', x_progress, sqlcode);
1095: raise;
1096: END;
1097:
1098: /*===========================================================================

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

1149: end if;
1150:
1151: EXCEPTION
1152: WHEN OTHERS THEN
1153: po_message_s.sql_error('po_inq_sv.get_location_info', x_progress, sqlcode);
1154: raise;
1155: END;
1156:
1157: /*===========================================================================

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

1188:
1189: EXCEPTION
1190:
1191: WHEN OTHERS THEN
1192: po_message_s.sql_error('po_inq_sv.get_project_info', x_progress, sqlcode);
1193: raise;
1194: END;
1195:
1196: /*===========================================================================

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

1264:
1265:
1266: EXCEPTION
1267: WHEN OTHERS THEN
1268: po_message_s.sql_error('po_inq_sv.get_wip_bom_info', x_progress, sqlcode);
1269: raise;
1270: END;
1271:
1272: /*===========================================================================

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

1313: end if;
1314:
1315: EXCEPTION
1316: WHEN OTHERS THEN
1317: po_message_s.sql_error('po_inq_sv.get_vendor_info', x_progress, sqlcode);
1318: raise;
1319: END;
1320:
1321: /*===========================================================================

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

1342: CLOSE c1;
1343:
1344: EXCEPTION
1345: WHEN OTHERS THEN
1346: po_message_s.sql_error('po_inq_sv.get_ap_terms', x_progress, sqlcode);
1347: raise;
1348: END;
1349:
1350: /*===========================================================================

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

1451: x_return_status => l_return_status);
1452:
1453: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
1454: APP_EXCEPTION.raise_exception(
1455: exception_type => 'PO_INQ_SV.get_dist_info_pq',
1456: exception_code => 0,
1457: exception_text => 'Exception in PO_SHARED_PROC_PVT.' ||
1458: 'get_ou_and_coa_from_inv_org() - '||
1459: 'po_line_location_id='||x_po_line_location_id||

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

1477: AND gsb.set_of_books_id = fspa.set_of_books_id;
1478: EXCEPTION
1479: WHEN OTHERS THEN
1480: APP_EXCEPTION.raise_exception(
1481: exception_type => 'PO_INQ_SV.get_dist_info_pq',
1482: exception_code => 0,
1483: exception_text => 'Could not find Chart of Accounts for ' ||
1484: 'Purchasing Operating Unit - '||
1485: 'po_line_location_id='||x_po_line_location_id);

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

1538: x_progress := '007';
1539:
1540: EXCEPTION
1541: WHEN OTHERS THEN
1542: po_message_s.sql_error('po_inq_sv.get_dist_info_pq', x_progress, sqlcode);
1543: raise;
1544: END;
1545:
1546: /*===========================================================================

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

1647: --Bug 2947251 END
1648:
1649: EXCEPTION
1650: WHEN OTHERS THEN
1651: po_message_s.sql_error('po_inq_sv.get_shipments_pq_lookups', x_progress, sqlcode);
1652: raise;
1653: END;
1654:
1655: /*===========================================================================

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

1708: end if;
1709:
1710: EXCEPTION
1711: WHEN OTHERS THEN
1712: po_message_s.sql_error('po_inq_sv.get_dist_pq_lookups', x_progress, sqlcode);
1713: raise;
1714: END get_dist_pq_lookups;
1715:
1716: /*===========================================================================

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

1798:
1799:
1800: EXCEPTION
1801: WHEN OTHERS THEN
1802: po_message_s.sql_error('po_inq_sv.get_lines_pq_lookups', x_progress, sqlcode);
1803: raise;
1804: END;
1805:
1806: /*===========================================================================

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

1872: --
1873:
1874: EXCEPTION
1875: WHEN OTHERS THEN
1876: po_message_s.sql_error('po_inq_sv.get_headers_pq_lookups', x_progress, sqlcode);
1877: raise;
1878: END;
1879:
1880: /*===========================================================================

Line 2246: END PO_INQ_SV;

2242: RETURN NULL;
2243: END get_vendor_email;
2244: --
2245:
2246: END PO_INQ_SV;