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_CONTERMS_UTL_GRP dependencies on PON_CONTERMS_UTL_PVT

Line 10: return PON_CONTERMS_UTL_PVT.is_contracts_installed();

6: FUNCTION is_contracts_installed RETURN VARCHAR2 IS
7:
8: BEGIN
9:
10: return PON_CONTERMS_UTL_PVT.is_contracts_installed();
11:
12: EXCEPTION
13: WHEN OTHERS THEN
14: RAISE;

Line 25: return pon_conterms_utl_pvt.get_response_doc_type(p_doctype_id);

21: RETURN VARCHAR2 IS
22:
23: BEGIN
24: IF (p_is_response = 'Y') THEN
25: return pon_conterms_utl_pvt.get_response_doc_type(p_doctype_id);
26: ELSE
27: return pon_conterms_utl_pvt.get_negotiation_doc_type(p_doctype_id);
28: END IF;
29: END get_contracts_document_type;

Line 27: return pon_conterms_utl_pvt.get_negotiation_doc_type(p_doctype_id);

23: BEGIN
24: IF (p_is_response = 'Y') THEN
25: return pon_conterms_utl_pvt.get_response_doc_type(p_doctype_id);
26: ELSE
27: return pon_conterms_utl_pvt.get_negotiation_doc_type(p_doctype_id);
28: END IF;
29: END get_contracts_document_type;
30:
31:

Line 65: pon_conterms_utl_pvt.get_auction_header_id(p_doctype_id,

61: FND_MSG_PUB.initialize();
62: END IF;
63:
64: -- get auction_header_id
65: pon_conterms_utl_pvt.get_auction_header_id(p_doctype_id,
66: p_doc_id,
67: l_auction_header_id,
68: x_return_status,
69: x_msg_data,

Line 208: if (p_doctype_id = PON_CONTERMS_UTL_PVT.BID or

204: return ;
205: end if;
206:
207: -- determine which query to execute depending on the doctype
208: if (p_doctype_id = PON_CONTERMS_UTL_PVT.BID or
209: p_doctype_id = PON_CONTERMS_UTL_PVT.QUOTE or
210: p_doctype_id = PON_CONTERMS_UTL_PVT.RESPONSE) then
211:
212: -- this is a response

Line 209: p_doctype_id = PON_CONTERMS_UTL_PVT.QUOTE or

205: end if;
206:
207: -- determine which query to execute depending on the doctype
208: if (p_doctype_id = PON_CONTERMS_UTL_PVT.BID or
209: p_doctype_id = PON_CONTERMS_UTL_PVT.QUOTE or
210: p_doctype_id = PON_CONTERMS_UTL_PVT.RESPONSE) then
211:
212: -- this is a response
213:

Line 210: p_doctype_id = PON_CONTERMS_UTL_PVT.RESPONSE) then

206:
207: -- determine which query to execute depending on the doctype
208: if (p_doctype_id = PON_CONTERMS_UTL_PVT.BID or
209: p_doctype_id = PON_CONTERMS_UTL_PVT.QUOTE or
210: p_doctype_id = PON_CONTERMS_UTL_PVT.RESPONSE) then
211:
212: -- this is a response
213:
214: l_progress := 101;

Line 329: pon_conterms_utl_pvt.get_legal_entity_id(pah.org_id) entity,

325:
326: begin
327: select
328: pah.org_id organization,
329: pon_conterms_utl_pvt.get_legal_entity_id(pah.org_id) entity,
330: -- Bug 4099936
331: -- Decode the doctype_id to the internal name as in PO valueset for the variable POC_XPRT_DOC_TYPE
332: -- Note that this piece of code may not be used as of today since Contract expert is not used for
333: -- response documents

Line 460: elsif (p_doctype_id = PON_CONTERMS_UTL_PVT.AUCTION or

456: x_msg_data := 'no data found for ' || p_doc_id;
457: x_return_status := fnd_api.g_ret_sts_error;
458: return;
459: end;
460: elsif (p_doctype_id = PON_CONTERMS_UTL_PVT.AUCTION or
461: p_doctype_id = PON_CONTERMS_UTL_PVT.REQUEST_FOR_QUOTE or
462: p_doctype_id = PON_CONTERMS_UTL_PVT.REQUEST_FOR_INFORMATION) then
463:
464: -- this is an auction

Line 461: p_doctype_id = PON_CONTERMS_UTL_PVT.REQUEST_FOR_QUOTE or

457: x_return_status := fnd_api.g_ret_sts_error;
458: return;
459: end;
460: elsif (p_doctype_id = PON_CONTERMS_UTL_PVT.AUCTION or
461: p_doctype_id = PON_CONTERMS_UTL_PVT.REQUEST_FOR_QUOTE or
462: p_doctype_id = PON_CONTERMS_UTL_PVT.REQUEST_FOR_INFORMATION) then
463:
464: -- this is an auction
465:

Line 462: p_doctype_id = PON_CONTERMS_UTL_PVT.REQUEST_FOR_INFORMATION) then

458: return;
459: end;
460: elsif (p_doctype_id = PON_CONTERMS_UTL_PVT.AUCTION or
461: p_doctype_id = PON_CONTERMS_UTL_PVT.REQUEST_FOR_QUOTE or
462: p_doctype_id = PON_CONTERMS_UTL_PVT.REQUEST_FOR_INFORMATION) then
463:
464: -- this is an auction
465:
466: l_progress := 102;

Line 587: pon_conterms_utl_pvt.get_legal_entity_id(pah.org_id) entity,

583:
584: begin
585: select
586: pah.org_id organization,
587: pon_conterms_utl_pvt.get_legal_entity_id(pah.org_id) entity,
588: -- Bug 4099936
589: -- decode doctype_id to the document type code as per the po value set POC_XPRT_DOC_TYPE associated
590: -- with the doc type system variable.
591: DECODE(pah.doctype_id, 21, 'SOURCING RFI', 5, 'SOURCING RFQ', 1, 'BUYER AUCTION') document_type,

Line 881: if (p_doctype_id = PON_CONTERMS_UTL_PVT.BID or

877: return ;
878: end if;
879:
880: -- determine which query to execute depending on the doctype
881: if (p_doctype_id = PON_CONTERMS_UTL_PVT.BID or
882: p_doctype_id = PON_CONTERMS_UTL_PVT.QUOTE or
883: p_doctype_id = PON_CONTERMS_UTL_PVT.RESPONSE) then
884:
885: l_progress := 101;

Line 882: p_doctype_id = PON_CONTERMS_UTL_PVT.QUOTE or

878: end if;
879:
880: -- determine which query to execute depending on the doctype
881: if (p_doctype_id = PON_CONTERMS_UTL_PVT.BID or
882: p_doctype_id = PON_CONTERMS_UTL_PVT.QUOTE or
883: p_doctype_id = PON_CONTERMS_UTL_PVT.RESPONSE) then
884:
885: l_progress := 101;
886:

Line 883: p_doctype_id = PON_CONTERMS_UTL_PVT.RESPONSE) then

879:
880: -- determine which query to execute depending on the doctype
881: if (p_doctype_id = PON_CONTERMS_UTL_PVT.BID or
882: p_doctype_id = PON_CONTERMS_UTL_PVT.QUOTE or
883: p_doctype_id = PON_CONTERMS_UTL_PVT.RESPONSE) then
884:
885: l_progress := 101;
886:
887: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then

Line 905: elsif (p_doctype_id = PON_CONTERMS_UTL_PVT.AUCTION or

901:
902: x_return_status := fnd_api.g_ret_sts_error;
903: x_msg_data := l_api_name || ' did not expect call with doctype ' || p_doctype_id;
904: return;
905: elsif (p_doctype_id = PON_CONTERMS_UTL_PVT.AUCTION or
906: p_doctype_id = PON_CONTERMS_UTL_PVT.REQUEST_FOR_QUOTE or
907: p_doctype_id = PON_CONTERMS_UTL_PVT.REQUEST_FOR_INFORMATION) then
908:
909: l_progress := 102;

Line 906: p_doctype_id = PON_CONTERMS_UTL_PVT.REQUEST_FOR_QUOTE or

902: x_return_status := fnd_api.g_ret_sts_error;
903: x_msg_data := l_api_name || ' did not expect call with doctype ' || p_doctype_id;
904: return;
905: elsif (p_doctype_id = PON_CONTERMS_UTL_PVT.AUCTION or
906: p_doctype_id = PON_CONTERMS_UTL_PVT.REQUEST_FOR_QUOTE or
907: p_doctype_id = PON_CONTERMS_UTL_PVT.REQUEST_FOR_INFORMATION) then
908:
909: l_progress := 102;
910:

Line 907: p_doctype_id = PON_CONTERMS_UTL_PVT.REQUEST_FOR_INFORMATION) then

903: x_msg_data := l_api_name || ' did not expect call with doctype ' || p_doctype_id;
904: return;
905: elsif (p_doctype_id = PON_CONTERMS_UTL_PVT.AUCTION or
906: p_doctype_id = PON_CONTERMS_UTL_PVT.REQUEST_FOR_QUOTE or
907: p_doctype_id = PON_CONTERMS_UTL_PVT.REQUEST_FOR_INFORMATION) then
908:
909: l_progress := 102;
910:
911: -- this is an auction

Line 968: decode(pon_conterms_utl_pvt.get_legal_entity_id(pah1.org_id),

964:
965: -- select either 'N' or the System Variable code if a value has changed
966: select
967: decode(pah1.org_id,pah2.org_id,'N','OKC$B_ORGANIZATION'),
968: decode(pon_conterms_utl_pvt.get_legal_entity_id(pah1.org_id),
969: pon_conterms_utl_pvt.get_legal_entity_id(pah2.org_id),
970: 'N','OKC$B_LEGAL_ENTITY'),
971: decode(pah1.doctype_id,pah2.doctype_id,'N','OKC$B_DOCUMENT_TYPE'),
972: decode(pah1.document_number,pah2.document_number,'N','OKC$B_SOURCING_DOC_NUMBER'),

Line 969: pon_conterms_utl_pvt.get_legal_entity_id(pah2.org_id),

965: -- select either 'N' or the System Variable code if a value has changed
966: select
967: decode(pah1.org_id,pah2.org_id,'N','OKC$B_ORGANIZATION'),
968: decode(pon_conterms_utl_pvt.get_legal_entity_id(pah1.org_id),
969: pon_conterms_utl_pvt.get_legal_entity_id(pah2.org_id),
970: 'N','OKC$B_LEGAL_ENTITY'),
971: decode(pah1.doctype_id,pah2.doctype_id,'N','OKC$B_DOCUMENT_TYPE'),
972: decode(pah1.document_number,pah2.document_number,'N','OKC$B_SOURCING_DOC_NUMBER'),
973: decode(pah1.ship_to_location_id,pah2.ship_to_location_id,'N','OKC$B_SHIP_TO_ADDRESS'),

Line 1214: pon_conterms_utl_pvt.get_auction_header_id(p_doctype_id,

1210: FND_MSG_PUB.initialize();
1211: END IF;
1212:
1213: -- get auction_header_id
1214: pon_conterms_utl_pvt.get_auction_header_id(p_doctype_id,
1215: p_doc_id,
1216: l_auction_header_id,
1217: x_return_status,
1218: x_msg_data,