DBA Data[Home] [Help]

APPS.PO_INTERFACE_S dependencies on PO_INTERFACE_S

Line 1: PACKAGE BODY PO_INTERFACE_S AS

1: PACKAGE BODY PO_INTERFACE_S AS
2: /* $Header: POXBWP1B.pls 120.73.12010000.5 2009/01/06 06:37:38 adbharga ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_INTERFACE_S'; --
5: g_log_head CONSTANT VARCHAR2(30) := 'po.plsql.PO_INTERFACE_S.';

Line 4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_INTERFACE_S'; --

1: PACKAGE BODY PO_INTERFACE_S AS
2: /* $Header: POXBWP1B.pls 120.73.12010000.5 2009/01/06 06:37:38 adbharga ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_INTERFACE_S'; --
5: g_log_head CONSTANT VARCHAR2(30) := 'po.plsql.PO_INTERFACE_S.';
6:
7: --
8: g_dest_type_code_SHOP_FLOOR CONSTANT

Line 5: g_log_head CONSTANT VARCHAR2(30) := 'po.plsql.PO_INTERFACE_S.';

1: PACKAGE BODY PO_INTERFACE_S AS
2: /* $Header: POXBWP1B.pls 120.73.12010000.5 2009/01/06 06:37:38 adbharga ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_INTERFACE_S'; --
5: g_log_head CONSTANT VARCHAR2(30) := 'po.plsql.PO_INTERFACE_S.';
6:
7: --
8: g_dest_type_code_SHOP_FLOOR CONSTANT
9: PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE

Line 1066: x_return_status := PO_INTERFACE_S.G_RET_STS_DUP_DOC_NUM ; --

1062: else
1063: if g_sourcing_errorcode =2 then
1064: --this will be set to 2 when dup_val_on_idex happen in create_po.
1065: x_errorcode:=2;
1066: x_return_status := PO_INTERFACE_S.G_RET_STS_DUP_DOC_NUM ; --
1067: else
1068: --when 0 lines are created, we assume that there is some erro happened
1069: --which is not related to manual PO numbering.
1070: x_errorcode:=3;

Line 2432: po_interface_s2.update_terms(x_document_id);

2428: /* FPI GA start Update the terms after the successful completion of PO */
2429:
2430: IF (g_document_subtype = 'STANDARD') and
2431: (g_interface_source_code <> 'CONSUMPTION_ADVICE') then -- CONSIGNED FPI
2432: po_interface_s2.update_terms(x_document_id);
2433: END IF;
2434:
2435: /* FPI GA end */
2436: l_progress := '370';

Line 2539: , VALUE => 'PO_INTERFACE_S.CREATE_PO');

2535: ROLLBACK TO TAX_CALCULATION_ERROR;
2536: x_document_id := NULL;
2537: fnd_message.set_name('PO','PO_API_ERROR');
2538: fnd_message.set_token( TOKEN => 'PROC_CALLER'
2539: , VALUE => 'PO_INTERFACE_S.CREATE_PO');
2540: fnd_message.set_token( TOKEN => 'PROC_CALLED'
2541: , VALUE => 'PO_TAX_INTERFACE_PVT.CALCULATE_TAX');
2542: fnd_msg_pub.add;
2543: fnd_message.set_name('PO','PO_AP_TAX_ENGINE_FAILED_WARN');

Line 2568: , VALUE => 'PO_INTERFACE_S.CREATE_PO');

2564: ROLLBACK TO TAX_CALCULATION_ERROR;
2565: x_document_id := NULL;
2566: fnd_message.set_name('PO','PO_API_ERROR');
2567: fnd_message.set_token( TOKEN => 'PROC_CALLER'
2568: , VALUE => 'PO_INTERFACE_S.CREATE_PO');
2569: fnd_message.set_token( TOKEN => 'PROC_CALLED'
2570: , VALUE => 'PO_TAX_INTERFACE_PVT.CALCULATE_TAX');
2571: fnd_msg_pub.add;
2572: fnd_message.set_name('PO','PO_AP_TAX_ENGINE_FAILED_WARN');

Line 2609: , VALUE => 'PO_INTERFACE_S.CREATE_PO');

2605: p_message => 'Create_po: Inside l_contracts_call_exception');
2606: END IF;
2607: Fnd_message.set_name('PO','PO_API_ERROR');
2608: Fnd_message.set_token( token => 'PROC_CALLER'
2609: , VALUE => 'PO_INTERFACE_S.CREATE_PO');
2610: Fnd_message.set_token( token => 'PROC_CALLED'
2611: , VALUE => 'OKC_TERMS_CPOY_GRP.COPY_DOC');
2612: FND_MSG_PUB.Add;
2613:

Line 3478: PO_INTERFACE_S.do_currency_conversion(

3474:
3475:
3476: --
3477: -- Perform currency conversion on price/amount/quantity.
3478: PO_INTERFACE_S.do_currency_conversion(
3479: p_order_type_lookup_code => x_order_type_lookup_code,
3480: p_interface_source_code => g_interface_source_code,
3481: p_rate => l_rate_for_req_fields, --
3482: p_po_currency_code => interface.h_currency_code,

Line 4472: PO_INTERFACE_S.do_currency_conversion(

4468: END IF;
4469:
4470: -- Perform currency conversion on price/amount/quantity.
4471: --
4472: PO_INTERFACE_S.do_currency_conversion(
4473: p_order_type_lookup_code => x_order_type_lookup_code,
4474: p_interface_source_code => g_interface_source_code,
4475: p_rate => l_rate_for_req_fields, --
4476: p_po_currency_code => interface.h_currency_code,

Line 5663: PO_INTERFACE_S.do_currency_conversion(

5659: IF ( x_order_type_lookup_code = 'QUANTITY' ) THEN
5660: x_quantity := round(x_quantity,15);
5661: ELSIF ( x_order_type_lookup_code = 'AMOUNT' ) THEN
5662: -- Bug 7661419, No conversion for same currency.
5663: PO_INTERFACE_S.do_currency_conversion(
5664: p_order_type_lookup_code => 'AMOUNT',
5665: p_interface_source_code => g_interface_source_code,
5666: p_rate => p_rate_for_req_fields, --
5667: p_po_currency_code => interface.h_currency_code,

Line 5893: PO_INTERFACE_S.do_currency_conversion(

5889: x_quantity := round(x_quantity,15);
5890:
5891: ELSIF ( x_order_type_lookup_code = 'AMOUNT' ) THEN --
5892: -- Bug 7661419, No conversion for same currency.
5893: PO_INTERFACE_S.do_currency_conversion(
5894: p_order_type_lookup_code => 'AMOUNT',
5895: p_interface_source_code => g_interface_source_code,
5896: p_rate => p_rate_for_req_fields, --
5897: p_po_currency_code => interface.h_currency_code,

Line 7127: PO_INTERFACE_S.calibrate_last_dist_amount(x_line_location_id);

7123: -- Correct last distribution amount for any conversion and
7124: -- rounding inaccuracies to ensure that the distribution amounts add up
7125: -- to their corresponding shipment amount.
7126: --
7127: PO_INTERFACE_S.calibrate_last_dist_amount(x_line_location_id);
7128:
7129:
7130: end if;
7131: -- Bug 882050: Dist level global attribute

Line 7320: d_module VARCHAR2(70) := 'po.plsql.PO_INTERFACE_S.calibrate_last_dist_quantity';

7316: p_line_location_id IN NUMBER
7317: )
7318: IS
7319:
7320: d_module VARCHAR2(70) := 'po.plsql.PO_INTERFACE_S.calibrate_last_dist_quantity';
7321: d_progress NUMBER;
7322:
7323: l_sum_dist_quantities PO_DISTRIBUTIONS_ALL.quantity_ordered%TYPE;
7324: l_last_dist_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;

Line 8209: PO_INTERFACE_S.do_currency_conversion (

8205: l_rate_for_req_fields := l_req_header_rate;
8206: END IF;
8207:
8208: -- First convert from the ROU currency to the PO currency.
8209: PO_INTERFACE_S.do_currency_conversion (
8210: p_order_type_lookup_code => l_order_type_lookup_code,
8211: p_interface_source_code => g_interface_source_code,
8212: p_rate => NVL(l_rate_for_req_fields,1),
8213: p_po_currency_code => l_po_currency_code,

Line 9250: AND pol.line_num = po_interface_s.source_blanket_line(

9246: AND pli.requisition_line_id = prl.requisition_line_id(+)
9247: AND plt.line_type_id = nvl(prl.line_type_id,pli.line_type_id)
9248: AND pol.po_header_id = x_po_header_id
9249: -- 2082757 : new
9250: AND pol.line_num = po_interface_s.source_blanket_line(
9251: x_po_header_id,
9252: prl.requisition_line_id,
9253: pli.line_num, -- Bug 2707576:
9254: NVL(x_uom_convert,'N'),

Line 13479: d_module VARCHAR2(70) := 'po.plsql.PO_INTERFACE_S.get_ship_to_loc';

13475:
13476: l_ship_to_location_id NUMBER;
13477: l_found BOOLEAN := FALSE;
13478:
13479: d_module VARCHAR2(70) := 'po.plsql.PO_INTERFACE_S.get_ship_to_loc';
13480: d_progress NUMBER;
13481:
13482: BEGIN
13483:

Line 14008: d_module VARCHAR2(70) := 'po.plsql.PO_INTERFACE_S.create_payitems';

14004: )
14005: IS
14006:
14007: d_progress NUMBER;
14008: d_module VARCHAR2(70) := 'po.plsql.PO_INTERFACE_S.create_payitems';
14009:
14010: l_po_header_id PO_LINES_ALL.po_header_id%TYPE;
14011: l_line_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE;
14012: l_line_matching_basis PO_LINES_ALL.matching_basis%TYPE;

Line 14734: d_module VARCHAR2(70) := 'po.plsql.PO_INTERFACE_S.create_payitem_dists';

14730: )
14731: IS
14732:
14733: d_progress NUMBER;
14734: d_module VARCHAR2(70) := 'po.plsql.PO_INTERFACE_S.create_payitem_dists';
14735:
14736: CURSOR payitem_acct_gen_cursor(p_po_line_id NUMBER)
14737: IS
14738: SELECT pod.po_distribution_id

Line 15528: END PO_INTERFACE_S;

15524: END create_payitem_dists;
15525:
15526: --
15527:
15528: END PO_INTERFACE_S;