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_OPEN_INTERFACE_PVT dependencies on PON_CLM_UTIL_PKG

Line 262: IF PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(p_doc_type_id => l_doctype_id) = 1 THEN

258: INTO l_doctype_id, l_uda_template_id
259: FROM pon_auction_headers_all
260: WHERE auction_header_id = p_auction_header_id;
261:
262: IF PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(p_doc_type_id => l_doctype_id) = 1 THEN
263:
264: select attr_group_id into l_solnum_group_id
265: from ego_attr_groups_v
266: where attr_group_name = 'DOD_SOL'

Line 2349: IF ( PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(neg_header_record_data.doctype_id) = 1 ) THEN

2345:
2346: print_log('Updating internal line number ');
2347: FOR rec IN line_cur LOOP
2348:
2349: IF ( PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(neg_header_record_data.doctype_id) = 1 ) THEN
2350:
2351: UPDATE pon_item_prices_interface
2352: SET disp_line_number = rec.interface_line_id,
2353: sub_line_sequence_number = rec.interface_line_id,

Line 3945: IF ( PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(neg_header_record_data.doctype_id) = 1 ) THEN

3941: print_log('Header record created for batch_id ' || p_batch_id || ' auction_header_id ' || x_auction_header_id
3942: || ' x_return_status ' || x_return_status);
3943:
3944:
3945: IF ( PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(neg_header_record_data.doctype_id) = 1 ) THEN
3946: SELECT uda_template_id INTO l_uda_template_id
3947: FROM pon_auction_Headers_all
3948: WHERE auction_header_id = x_auction_header_id;
3949:

Line 3991: IF ( PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(neg_header_record_data.doctype_id) = 1 ) THEN

3987: RETURN;
3988: END IF;
3989:
3990: -- UDA data insertion for lines
3991: IF ( PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(neg_header_record_data.doctype_id) = 1 ) THEN
3992: SELECT uda_template_id INTO l_uda_template_id
3993: FROM pon_auction_item_prices_all
3994: WHERE auction_header_id = x_auction_header_id
3995: AND ROWNUM=1;

Line 4089: IF ( PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(neg_header_record_data.doctype_id) = 1 ) THEN

4085: FND_MSG_PUB.ADD;
4086: RETURN;
4087: END IF;
4088:
4089: IF ( PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(neg_header_record_data.doctype_id) = 1 ) THEN
4090: default_sol_number(x_auction_header_id,x_return_status);
4091: END IF;
4092: print_Log('Document number created for auction_header_id ' || x_auction_header_id
4093: || ' x_return_status ' || x_return_status);

Line 5023: and Nvl(pdh.clm_flag,'N') = PON_CLM_UTIL_PKG.ISCLMRESP

5019: FROM po_doc_style_headers pdh, po_all_doc_style_Lines pdl
5020: WHERE pdh.style_id = pdl.style_id
5021: AND pdh.status= 'ACTIVE'
5022: AND pdl.enabled_flag= 'Y'
5023: and Nvl(pdh.clm_flag,'N') = PON_CLM_UTIL_PKG.ISCLMRESP
5024: AND pdl.LANGUAGE=UserEnv('LANG')
5025: AND pdl.display_name = l_po_style_name;
5026: END IF;
5027:

Line 5156: and Nvl(clm_flag,'N') = PON_CLM_UTIL_PKG.ISCLMRESP)))

5152: )
5153: --Bug 16801033
5154: WHEN ((l_doctype_id<>rfi_doctype_id AND (l_po_style_id IS NULL
5155: OR NOT EXISTS(SELECT 'Y' FROM po_doc_style_headers WHERE STYLE_ID = l_po_style_id
5156: and Nvl(clm_flag,'N') = PON_CLM_UTIL_PKG.ISCLMRESP)))
5157: OR (l_doctype_id=rfi_doctype_id AND (l_po_style_id IS not NULL OR l_po_style_name IS NOT null))
5158: )
5159: THEN INTO PON_INTERFACE_ERRORS
5160: (

Line 5493: isFederal := PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(neg_header_record_data.doctype_id);

5489:
5490:
5491: SELECT doctype_group_name INTO doctype_name FROM pon_auc_doctypes WHERE doctype_id = neg_header_record_data.doctype_id;
5492:
5493: isFederal := PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(neg_header_record_data.doctype_id);
5494:
5495: INSERT ALL
5496: WHEN ( neg_header_record_data.auction_title IS NULL )
5497: THEN INTO PON_INTERFACE_ERRORS

Line 5931: IF(PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(neg_header_record_data.doctype_id)=1) THEN

5927: l_cp_login_id)
5928:
5929: SELECT 1 from dual;
5930:
5931: IF(PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(neg_header_record_data.doctype_id)=1) THEN
5932:
5933: IF ( p_is_amendment <> 'Y' AND
5934: (neg_header_record_data.standard_form IS NULL OR neg_header_record_data.document_format IS NULL)) THEN
5935:

Line 6620: AND PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(neg_header_record_data.doctype_id) = 1 ) THEN

6616: END IF;
6617:
6618: -- UDA template id and date derivation
6619: IF ( p_is_amendment <> 'Y'
6620: AND PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(neg_header_record_data.doctype_id) = 1 ) THEN
6621: neg_header_record_data.uda_template_id := po_uda_data_util.get_template_id(
6622: p_functional_area => 'SOURCING',
6623: p_document_type => 'SOLICITATION',
6624: p_document_style_id => NULL,

Line 6689: and Nvl(pdh.clm_flag,'N') = PON_CLM_UTIL_PKG.ISCLMRESP

6685: FROM po_doc_style_headers pdh, po_all_doc_style_Lines pdl
6686: WHERE pdh.style_id = pdl.style_id
6687: AND pdh.status= 'ACTIVE'
6688: AND pdl.enabled_flag= 'Y'
6689: and Nvl(pdh.clm_flag,'N') = PON_CLM_UTIL_PKG.ISCLMRESP
6690: AND pdl.LANGUAGE=UserEnv('LANG')
6691: AND pdl.display_name = neg_header_record_data.po_style_name;
6692: END IF;
6693: EXCEPTION

Line 7190: IF PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(p_doc_type_id => l_doctype_id) = 1 THEN

7186: SELECT doctype_id, style_id
7187: INTO l_doctype_id, l_style_id
7188: FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id;
7189:
7190: IF PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(p_doc_type_id => l_doctype_id) = 1 THEN
7191: pon_negotiation_copy_grp.FED_CREATE_AMD_COPY_NEG
7192: (1.0,'F','N',l_auction_header_id,g_trading_partner_id,l_tpc_id,USERENV('LANG'),l_tpc_id,
7193: l_doctype_id,'AMENDMENT',l_award_approval,l_username,l_mgr_id,'Y', 'N', 'Y',null,l_style_id,'N',
7194: x_auction_header_id,x_document_number,x_request_id,x_return_status,x_msg_count,x_msg_data);

Line 7265: IF ( PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(l_doctype_id) = 1 ) THEN

7261: update_amendment_header(x_auction_header_id);
7262:
7263: print_log('Header information updated for amendment ' || x_auction_header_id );
7264:
7265: IF ( PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(l_doctype_id) = 1 ) THEN
7266: SELECT uda_template_id INTO l_uda_template_id
7267: FROM pon_auction_Headers_all
7268: WHERE auction_header_id = x_auction_header_id;
7269:

Line 7323: IF ( PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(l_doctype_id) = 1 ) THEN

7319: NULL,fnd_global.user_id, fnd_global.login_id);
7320: RAISE FND_API.G_EXC_ERROR;
7321: END IF;
7322:
7323: IF ( PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(l_doctype_id) = 1 ) THEN
7324: SELECT uda_template_id INTO l_uda_template_id
7325: FROM pon_auction_item_prices_all
7326: WHERE auction_header_id = x_auction_header_id
7327: AND ROWNUM=1;

Line 7743: IF ( PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(neg_header_record_data.doctype_id) = 1 ) THEN

7739: WHEN OTHERS THEN
7740: NULL;
7741: END;
7742:
7743: IF ( PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(neg_header_record_data.doctype_id) = 1 ) THEN
7744:
7745: INSERT ALL
7746: WHEN (sel_group_type <> 'LINE')
7747: THEN INTO PON_INTERFACE_ERRORS