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.PON_AUCTION_CREATE_PO_PKG dependencies on STANDARD

Line 184: x_contract_type = 'STANDARD')) THEN

180: end if;
181:
182: IF (x_origination_code = 'REQUISITION' AND
183: ((x_contract_type = 'BLANKET' AND x_source_reqs_flag = 'Y') OR
184: x_contract_type = 'STANDARD')) THEN
185:
186: -- Call procedure to automatically allocate unallocated items
187: ALLOC_ALL_UNALLOC_ITEMS (p_auction_header_id,
188: x_allocation_result,

Line 875: -- descending, bid price ascending, then bid number ascending for standard

871: -- then fulfilling the requisition demand one by one with the supplier's award
872: -- quantity in a FIFO manner. The ordering is as follows. Requisitions are
873: -- ordered by need_by_date ascending, then creation_date ascending. Awarded
874: -- Suppliers are ordered by promise date ascending, awarded quantity
875: -- descending, bid price ascending, then bid number ascending for standard
876: -- purchase orders. In the case of blanket agreements, promise
877: -- date is implicitly excluded from the ordering, as it will be null.
878:
879:

Line 1456: IF (x_contract_type = 'STANDARD') THEN

1452: auh.doctype_id = dt.doctype_id;
1453:
1454: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
1455:
1456: IF (x_contract_type = 'STANDARD') THEN
1457: x_purchase_order := 'Standard Purchase Order';
1458: x_purchase_orders := 'Standard Purchase Orders';
1459: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1460: itemkey => x_itemkey,

Line 1457: x_purchase_order := 'Standard Purchase Order';

1453:
1454: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
1455:
1456: IF (x_contract_type = 'STANDARD') THEN
1457: x_purchase_order := 'Standard Purchase Order';
1458: x_purchase_orders := 'Standard Purchase Orders';
1459: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1460: itemkey => x_itemkey,
1461: aname => 'PON_AUC_WF_PO_CREATE_SUBJ',

Line 1458: x_purchase_orders := 'Standard Purchase Orders';

1454: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
1455:
1456: IF (x_contract_type = 'STANDARD') THEN
1457: x_purchase_order := 'Standard Purchase Order';
1458: x_purchase_orders := 'Standard Purchase Orders';
1459: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1460: itemkey => x_itemkey,
1461: aname => 'PON_AUC_WF_PO_CREATE_SUBJ',
1462: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO_CREATE_SUBJ', x_msg_suffix, 'DOC_NUMBER', x_doc_number_dsp));

Line 1980: IF (x_pdoi_header.contract_type = 'STANDARD') THEN --{

1976: 'last_update_by: ' || to_char(p_user_id);
1977:
1978: log_message(x_progress);
1979:
1980: IF (x_pdoi_header.contract_type = 'STANDARD') THEN --{
1981:
1982: OPEN reqlineLevelInfo;
1983:
1984: LOOP --{ -- loop over reqlineLevelInfo

Line 2024: /* contract type is standard and this line comes from a

2020: || 'award quantity: ' || x_award_quantity;
2021: log_message(x_progress);
2022:
2023:
2024: /* contract type is standard and this line comes from a
2025: backing requisition and the sum of the allocated quantity
2026: to the backing requisitions is greater than 0 */
2027:
2028: /*

Line 2382: --BATCHING FOR OUTCOME = STANDARD PURCHASE ORDER : STARTS HERE

2378: close reqlineLevelInfo;
2379:
2380: /* rrkulkar-large-auction-support changes */
2381: --------------------------------------------------------------------------------------------------------------
2382: --BATCHING FOR OUTCOME = STANDARD PURCHASE ORDER : STARTS HERE
2383: --------------------------------------------------------------------------------------------------------------
2384:
2385: --get the number of rows to be copied
2386: select nvl(max(line_number),0)

Line 2533: x_progress := '35.1: CREATE_PO_STRUCTURE: STANDARD CASE: END OF BULK INSERT';

2529: pbs.line_number(+) = pbip.line_number and
2530: pbs.shipment_number(+) = pbip.award_shipment_number;
2531:
2532:
2533: x_progress := '35.1: CREATE_PO_STRUCTURE: STANDARD CASE: END OF BULK INSERT';
2534:
2535: log_message(x_progress);
2536:
2537: x_progress := '35.1.1: CREATE_PAYMENTS: STANDARD CASE: CHECK IF COMPLEX WORK';

Line 2537: x_progress := '35.1.1: CREATE_PAYMENTS: STANDARD CASE: CHECK IF COMPLEX WORK';

2533: x_progress := '35.1: CREATE_PO_STRUCTURE: STANDARD CASE: END OF BULK INSERT';
2534:
2535: log_message(x_progress);
2536:
2537: x_progress := '35.1.1: CREATE_PAYMENTS: STANDARD CASE: CHECK IF COMPLEX WORK';
2538:
2539: log_message(x_progress);
2540:
2541: -- Insert all Payments for all lines in one go, if any and complex work

Line 2543: x_progress := '35.1.5: CREATE_PAYMENTS: STANDARD CASE: IT IS COMPLEX WORK';

2539: log_message(x_progress);
2540:
2541: -- Insert all Payments for all lines in one go, if any and complex work
2542: IF (x_pdoi_header.progress_payment_type IN ('ACTUAL','FINANCE')) THEN
2543: x_progress := '35.1.5: CREATE_PAYMENTS: STANDARD CASE: IT IS COMPLEX WORK';
2544:
2545: log_message(x_progress);
2546:
2547: INSERT INTO po_line_locations_interface (

Line 2666: x_progress := '35.1.10: CREATE_PAYMENTS: STANDARD CASE: END INSERTING PAYMENTS';

2662: nvl(bpys.bid_currency_price,0) <> 0 and
2663: pbip.line_number >= l_batch_start and
2664: pbip.line_number <= l_batch_end;
2665:
2666: x_progress := '35.1.10: CREATE_PAYMENTS: STANDARD CASE: END INSERTING PAYMENTS';
2667:
2668: log_message(x_progress);
2669: END IF;-- if complex work
2670:

Line 2672: x_progress := '35.2: CREATE_PO_STRUCTURE: STANDARD CASE: BATCH FROM '

2668: log_message(x_progress);
2669: END IF;-- if complex work
2670:
2671:
2672: x_progress := '35.2: CREATE_PO_STRUCTURE: STANDARD CASE: BATCH FROM '
2673: || l_batch_start ||' TO '||l_batch_end ||' (inclusive)';
2674: log_message(x_progress);
2675: l_batch_start := l_batch_end + 1;
2676:

Line 2696: x_progress := '35.3: CREATE_PO_STRUCTURE: STANDARD CASE: BATCH-COMMIT SUCCESSFUL ';

2692: */
2693:
2694: IF(l_commit_flag = TRUE) THEN
2695: COMMIT;
2696: x_progress := '35.3: CREATE_PO_STRUCTURE: STANDARD CASE: BATCH-COMMIT SUCCESSFUL ';
2697: log_message(x_progress);
2698: END IF;
2699:
2700: END LOOP; --} --end-loop- batching-SPO

Line 2703: --BATCHING FOR OUTCOME = STANDARD PURCHASE ORDER : ENDS HERE

2699:
2700: END LOOP; --} --end-loop- batching-SPO
2701:
2702: --------------------------------------------------------------------------------------------------------------
2703: --BATCHING FOR OUTCOME = STANDARD PURCHASE ORDER : ENDS HERE
2704: --------------------------------------------------------------------------------------------------------------
2705:
2706: END IF; -- End of Standard
2707:

Line 2706: END IF; -- End of Standard

2702: --------------------------------------------------------------------------------------------------------------
2703: --BATCHING FOR OUTCOME = STANDARD PURCHASE ORDER : ENDS HERE
2704: --------------------------------------------------------------------------------------------------------------
2705:
2706: END IF; -- End of Standard
2707:
2708:
2709: /* Blanket Agreement case: will do bulk insert from one table to another */
2710:

Line 3921: /* STANDARD */

3917: elsif (x_doc_type_to_create = 'CONTRACT') then
3918: x_doc_type := 'PA';
3919: x_doc_subtype := 'CONTRACT';
3920: else
3921: /* STANDARD */
3922: x_doc_type := 'PO';
3923: x_doc_subtype := 'STANDARD';
3924: end if;
3925:

Line 3923: x_doc_subtype := 'STANDARD';

3919: x_doc_subtype := 'CONTRACT';
3920: else
3921: /* STANDARD */
3922: x_doc_type := 'PO';
3923: x_doc_subtype := 'STANDARD';
3924: end if;
3925:
3926: /* Need to get item_type and workflow process from po_document_types.
3927: * They may be different based on the doc/org.

Line 4210: IF (x_contract_type = 'STANDARD') THEN

4206: WHERE auction_header_id = x_auction_header_id;
4207:
4208: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_user_name, x_language_code);
4209: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null, x_language_code);
4210: IF (x_contract_type = 'STANDARD') THEN
4211: x_purchase_orders := 'Standard Purchase Order';
4212: msgNumCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_SUCC_PO');
4213: msgPOdetails := PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO_DETAILS');
4214: ELSIF (x_contract_type = 'BLANKET') THEN

Line 4211: x_purchase_orders := 'Standard Purchase Order';

4207:
4208: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_user_name, x_language_code);
4209: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null, x_language_code);
4210: IF (x_contract_type = 'STANDARD') THEN
4211: x_purchase_orders := 'Standard Purchase Order';
4212: msgNumCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_SUCC_PO');
4213: msgPOdetails := PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO_DETAILS');
4214: ELSIF (x_contract_type = 'BLANKET') THEN
4215: x_purchase_orders := 'Blanket Purchase Agreement';

Line 4379: IF (x_contract_type = 'STANDARD') THEN

4375: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_user_name, x_language_code);
4376: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null, x_language_code);
4377:
4378:
4379: IF (x_contract_type = 'STANDARD') THEN
4380: x_purchase_orders := 'Standard Purchase Order';
4381: msgNumNotCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_FAIL_PO');
4382: ELSIF (x_contract_type = 'BLANKET') THEN
4383: x_purchase_orders := 'Blanket Purchase Agreement';

Line 4380: x_purchase_orders := 'Standard Purchase Order';

4376: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null, x_language_code);
4377:
4378:
4379: IF (x_contract_type = 'STANDARD') THEN
4380: x_purchase_orders := 'Standard Purchase Order';
4381: msgNumNotCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_FAIL_PO');
4382: ELSIF (x_contract_type = 'BLANKET') THEN
4383: x_purchase_orders := 'Blanket Purchase Agreement';
4384: msgNumNotCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_FAIL_BL');