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 194: x_contract_type = 'STANDARD')) THEN

190: end if;
191:
192: IF (x_origination_code = 'REQUISITION' AND
193: ((x_contract_type = 'BLANKET' AND x_source_reqs_flag = 'Y') OR
194: x_contract_type = 'STANDARD')) THEN
195:
196: -- Call procedure to automatically allocate unallocated items
197: ALLOC_ALL_UNALLOC_ITEMS (p_auction_header_id,
198: x_allocation_result,

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

923: -- then fulfilling the requisition demand one by one with the supplier's award
924: -- quantity in a FIFO manner. The ordering is as follows. Requisitions are
925: -- ordered by need_by_date ascending, then creation_date ascending. Awarded
926: -- Suppliers are ordered by promise date ascending, awarded quantity
927: -- descending, bid price ascending, then bid number ascending for standard
928: -- purchase orders. In the case of blanket agreements, promise
929: -- date is implicitly excluded from the ordering, as it will be null.
930:
931:

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

1527: auh.doctype_id = dt.doctype_id;
1528:
1529: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
1530:
1531: IF (x_contract_type = 'STANDARD') THEN
1532: -- x_purchase_order := 'Standard Purchase Order';
1533: -- x_purchase_orders := 'Standard Purchase Orders';
1534: x_purchase_order := PON_AUCTION_PKG.getMessage('PON_MI_AUCOUTCM_SPOT');
1535: x_purchase_orders := PON_AUCTION_PKG.getMessage('PON_MI_AUCOUTCM_SPOS');

Line 1532: -- x_purchase_order := 'Standard Purchase Order';

1528:
1529: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
1530:
1531: IF (x_contract_type = 'STANDARD') THEN
1532: -- x_purchase_order := 'Standard Purchase Order';
1533: -- x_purchase_orders := 'Standard Purchase Orders';
1534: x_purchase_order := PON_AUCTION_PKG.getMessage('PON_MI_AUCOUTCM_SPOT');
1535: x_purchase_orders := PON_AUCTION_PKG.getMessage('PON_MI_AUCOUTCM_SPOS');
1536: wf_engine.SetItemAttrText (itemtype => x_itemtype,

Line 1533: -- x_purchase_orders := 'Standard Purchase Orders';

1529: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
1530:
1531: IF (x_contract_type = 'STANDARD') THEN
1532: -- x_purchase_order := 'Standard Purchase Order';
1533: -- x_purchase_orders := 'Standard Purchase Orders';
1534: x_purchase_order := PON_AUCTION_PKG.getMessage('PON_MI_AUCOUTCM_SPOT');
1535: x_purchase_orders := PON_AUCTION_PKG.getMessage('PON_MI_AUCOUTCM_SPOS');
1536: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1537: itemkey => x_itemkey,

Line 2199: decode(x_pdoi_header.contract_type, 'STANDARD',NULL,x_pdoi_header.umbrella_program_id),

2195: sysdate, -- creation_date
2196: p_user_id, -- last_update_by
2197: SYSDATE,
2198: x_pdoi_header.clm_external_idv,
2199: decode(x_pdoi_header.contract_type, 'STANDARD',NULL,x_pdoi_header.umbrella_program_id),
2200: decode(Nvl(x_pdoi_header.fair_opp_notice_flag,'N'), 'Y',x_pdoi_header.auction_header_id,NULL)); -- last_update_date
2201:
2202:
2203: x_progress := '15: CREATE_PO_STRUCTURE: INSERTING the following data into po_headers_interface: ' ||

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

2250:
2251: --Bug : 14134092 : If line type structure changes are enabled, then fund allocation will be done for all lines.
2252: l_is_line_type_enabled := PON_CLM_UTIL_PKG.get_line_structure_enabled(p_auction_header_id => p_auction_header_id);
2253:
2254: IF (x_pdoi_header.contract_type = 'STANDARD') THEN --{
2255:
2256: OPEN reqlineLevelInfo(l_is_fed);
2257:
2258: LOOP --{ -- loop over reqlineLevelInfo

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

2294: || 'award quantity: ' || x_award_quantity;
2295: log_message(x_progress);
2296:
2297:
2298: /* contract type is standard and this line comes from a
2299: backing requisition and the sum of the allocated quantity
2300: to the backing requisitions is greater than 0 */
2301:
2302: /*

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

2823:
2824:
2825: /* rrkulkar-large-auction-support changes */
2826: --------------------------------------------------------------------------------------------------------------
2827: --BATCHING FOR OUTCOME = STANDARD PURCHASE ORDER : STARTS HERE
2828: --------------------------------------------------------------------------------------------------------------
2829:
2830: --get the number of rows to be copied
2831: select nvl(max(line_number),0)

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

3042: -- end of clm clin/slin changes
3043:
3044:
3045:
3046: x_progress := '35.1: CREATE_PO_STRUCTURE: STANDARD CASE: END OF BULK INSERT';
3047:
3048: log_message(x_progress);
3049:
3050: x_progress := '35.1.1: CREATE_PAYMENTS: STANDARD CASE: CHECK IF COMPLEX WORK';

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

3046: x_progress := '35.1: CREATE_PO_STRUCTURE: STANDARD CASE: END OF BULK INSERT';
3047:
3048: log_message(x_progress);
3049:
3050: x_progress := '35.1.1: CREATE_PAYMENTS: STANDARD CASE: CHECK IF COMPLEX WORK';
3051:
3052: log_message(x_progress);
3053:
3054: -- Insert all Payments for all lines in one go, if any and complex work

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

3052: log_message(x_progress);
3053:
3054: -- Insert all Payments for all lines in one go, if any and complex work
3055: IF (x_pdoi_header.progress_payment_type IN ('ACTUAL','FINANCE')) THEN
3056: x_progress := '35.1.5: CREATE_PAYMENTS: STANDARD CASE: IT IS COMPLEX WORK';
3057:
3058: log_message(x_progress);
3059:
3060: INSERT INTO po_line_locations_interface (

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

3175: nvl(bpys.bid_currency_price,0) <> 0 and
3176: pbip.line_number >= l_batch_start and
3177: pbip.line_number <= l_batch_end;
3178:
3179: x_progress := '35.1.10: CREATE_PAYMENTS: STANDARD CASE: END INSERTING PAYMENTS';
3180:
3181: log_message(x_progress);
3182: END IF;-- if complex work
3183:

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

3181: log_message(x_progress);
3182: END IF;-- if complex work
3183:
3184:
3185: x_progress := '35.2: CREATE_PO_STRUCTURE: STANDARD CASE: BATCH FROM '
3186: || l_batch_start ||' TO '||l_batch_end ||' (inclusive)';
3187: log_message(x_progress);
3188: l_batch_start := l_batch_end + 1;
3189:

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

3205: */
3206:
3207: IF(l_commit_flag = TRUE) THEN
3208: COMMIT;
3209: x_progress := '35.3: CREATE_PO_STRUCTURE: STANDARD CASE: BATCH-COMMIT SUCCESSFUL ';
3210: log_message(x_progress);
3211: END IF;
3212:
3213: END LOOP; --} --end-loop- batching-SPO

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

3228: END IF;
3229:
3230:
3231: --------------------------------------------------------------------------------------------------------------
3232: --BATCHING FOR OUTCOME = STANDARD PURCHASE ORDER : ENDS HERE
3233: --------------------------------------------------------------------------------------------------------------
3234:
3235: END IF; -- End of Standard
3236:

Line 3235: END IF; -- End of Standard

3231: --------------------------------------------------------------------------------------------------------------
3232: --BATCHING FOR OUTCOME = STANDARD PURCHASE ORDER : ENDS HERE
3233: --------------------------------------------------------------------------------------------------------------
3234:
3235: END IF; -- End of Standard
3236:
3237:
3238: /* Blanket Agreement case: will do bulk insert from one table to another */
3239:

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

3754:
3755:
3756: /* Bug 9883780 - Start */
3757:
3758: IF (x_pdoi_header.contract_type = 'STANDARD') THEN --{
3759:
3760: /* The following code is added only for logging purpose. */
3761: IF (g_fnd_debug = 'Y') THEN
3762: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 4903: /* STANDARD */

4899: elsif (x_doc_type_to_create = 'CONTRACT') then
4900: x_doc_type := 'PA';
4901: x_doc_subtype := 'CONTRACT';
4902: else
4903: /* STANDARD */
4904: x_doc_type := 'PO';
4905: x_doc_subtype := 'STANDARD';
4906: end if;
4907:

Line 4905: x_doc_subtype := 'STANDARD';

4901: x_doc_subtype := 'CONTRACT';
4902: else
4903: /* STANDARD */
4904: x_doc_type := 'PO';
4905: x_doc_subtype := 'STANDARD';
4906: end if;
4907:
4908: /* Need to get item_type and workflow process from po_document_types.
4909: * They may be different based on the doc/org.

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

5188: WHERE auction_header_id = x_auction_header_id;
5189:
5190: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_user_name, x_language_code);
5191: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null, x_language_code);
5192: IF (x_contract_type = 'STANDARD') THEN
5193: -- x_purchase_orders := 'Standard Purchase Order';
5194: x_purchase_orders := PON_AUCTION_PKG.getMessage('PON_MI_AUCOUTCM_SPOT');
5195: msgNumCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_SUCC_PO');
5196: msgPOdetails := PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO_DETAILS');

Line 5193: -- x_purchase_orders := 'Standard Purchase Order';

5189:
5190: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_user_name, x_language_code);
5191: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null, x_language_code);
5192: IF (x_contract_type = 'STANDARD') THEN
5193: -- x_purchase_orders := 'Standard Purchase Order';
5194: x_purchase_orders := PON_AUCTION_PKG.getMessage('PON_MI_AUCOUTCM_SPOT');
5195: msgNumCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_SUCC_PO');
5196: msgPOdetails := PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO_DETAILS');
5197: ELSIF (x_contract_type = 'BLANKET') THEN

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

5360: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_user_name, x_language_code);
5361: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null, x_language_code);
5362:
5363:
5364: IF (x_contract_type = 'STANDARD') THEN
5365: -- x_purchase_orders := 'Standard Purchase Order';
5366: x_purchase_orders := PON_AUCTION_PKG.getMessage('PON_MI_AUCOUTCM_SPOT');
5367: msgNumNotCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_FAIL_PO');
5368: ELSIF (x_contract_type = 'BLANKET') THEN

Line 5365: -- x_purchase_orders := 'Standard Purchase Order';

5361: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null, x_language_code);
5362:
5363:
5364: IF (x_contract_type = 'STANDARD') THEN
5365: -- x_purchase_orders := 'Standard Purchase Order';
5366: x_purchase_orders := PON_AUCTION_PKG.getMessage('PON_MI_AUCOUTCM_SPOT');
5367: msgNumNotCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_FAIL_PO');
5368: ELSIF (x_contract_type = 'BLANKET') THEN
5369: -- x_purchase_orders := 'Blanket Purchase Agreement';