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.PO_INTERFACE_S2 dependencies on FND_LOG

Line 281: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

277:
278: l_api_name CONSTANT VARCHAR2(30) := 'update_terms ';
279:
280: BEGIN
281: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
282: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || '.begin','update terms');
283: END IF;
284: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
285: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || 'new PO ' , to_char(p_new_po_id));

Line 282: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || '.begin','update terms');

278: l_api_name CONSTANT VARCHAR2(30) := 'update_terms ';
279:
280: BEGIN
281: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
282: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || '.begin','update terms');
283: END IF;
284: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
285: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || 'new PO ' , to_char(p_new_po_id));
286: END IF;

Line 284: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

280: BEGIN
281: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
282: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || '.begin','update terms');
283: END IF;
284: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
285: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || 'new PO ' , to_char(p_new_po_id));
286: END IF;
287:
288:

Line 285: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || 'new PO ' , to_char(p_new_po_id));

281: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
282: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || '.begin','update terms');
283: END IF;
284: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
285: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || 'new PO ' , to_char(p_new_po_id));
286: END IF;
287:
288:
289: --

Line 329: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

325: po_headers_all POC
326: WHERE POL.po_header_id = p_new_po_id
327: AND POL.from_header_id = POSRC.po_header_id (+)
328: AND POL.contract_id = POC.po_header_id (+);
329: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
330: FND_LOG.string( FND_LOG.LEVEL_STATEMENT,
331: c_log_head || l_api_name || '.after_get_cnt',
332: ' ga cnt = ' || l_ga_count || ' quot cnt = ' ||
333: l_quotation_count || ' lc cnt = ' || l_lc_count ||

Line 330: FND_LOG.string( FND_LOG.LEVEL_STATEMENT,

326: WHERE POL.po_header_id = p_new_po_id
327: AND POL.from_header_id = POSRC.po_header_id (+)
328: AND POL.contract_id = POC.po_header_id (+);
329: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
330: FND_LOG.string( FND_LOG.LEVEL_STATEMENT,
331: c_log_head || l_api_name || '.after_get_cnt',
332: ' ga cnt = ' || l_ga_count || ' quot cnt = ' ||
333: l_quotation_count || ' lc cnt = ' || l_lc_count ||
334: ' gc cnt = ' || l_gc_count);

Line 400: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

396:
397: --
398:
399: IF (l_source_doc_id IS NOT NULL) THEN -- bug2930830
400: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
401: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || 'source ' , to_char(l_source_doc_id));
402: END IF;
403:
404: Select terms_id,

Line 401: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || 'source ' , to_char(l_source_doc_id));

397: --
398:
399: IF (l_source_doc_id IS NOT NULL) THEN -- bug2930830
400: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
401: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || 'source ' , to_char(l_source_doc_id));
402: END IF;
403:
404: Select terms_id,
405: fob_lookup_code,

Line 426: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

422: l_ship_to_location_id, -- <2748409>
423: l_shipping_control --
424: From po_headers_all
425: Where po_header_id = l_source_doc_id;
426: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
427: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || 'After SELECTing Terms and Conditions.' , 0);
428: END IF;
429:
430: -- Bug 3807992: Added nvl to the terms to retain existing values if the

Line 427: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || 'After SELECTing Terms and Conditions.' , 0);

423: l_shipping_control --
424: From po_headers_all
425: Where po_header_id = l_source_doc_id;
426: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
427: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || 'After SELECTing Terms and Conditions.' , 0);
428: END IF;
429:
430: -- Bug 3807992: Added nvl to the terms to retain existing values if the
431: -- source doc does not have terms

Line 440: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

436: note_to_vendor = l_supplier_note,
437: note_to_receiver = l_receiver_note,
438: shipping_control = nvl(l_shipping_control,shipping_control) --
439: where po_header_id = p_new_po_id;
440: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
441: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || 'After UPDATEing Global Terms and Conditions.' , 0);
442: END IF;
443:
444: -- <2748409 START>: If Req references a Global Agreement in the

Line 441: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || 'After UPDATEing Global Terms and Conditions.' , 0);

437: note_to_receiver = l_receiver_note,
438: shipping_control = nvl(l_shipping_control,shipping_control) --
439: where po_header_id = p_new_po_id;
440: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
441: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || 'After UPDATEing Global Terms and Conditions.' , 0);
442: END IF;
443:
444: -- <2748409 START>: If Req references a Global Agreement in the
445: -- Owning Org, update PO w/ Local Terms and Conditions from the GA.

Line 463: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

459: ship_to_location_id = l_ship_to_location_id
460: WHERE po_header_id = p_new_po_id;
461:
462: END IF;
463: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
464: --
465: -- <2748409 END>
466:
467: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || 'After UPDATEing Local Terms and Conditions.' , 0);

Line 467: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || 'After UPDATEing Local Terms and Conditions.' , 0);

463: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
464: --
465: -- <2748409 END>
466:
467: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || 'After UPDATEing Local Terms and Conditions.' , 0);
468: END IF;
469:
470: end if;
471:

Line 477: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

473: -- Auto Apply the contract terms if the PO does not have any source
474: -- documents on any of the lines. We already have variables above
475: -- which have the src doc count. we will use these to check
476: -- Bug 4618614: GSCC error to check the log level
477: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
478: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name ||
479: 'Auto Apply Contract terms if applicable.' , 0);
480: END IF;
481:

Line 478: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name ||

474: -- documents on any of the lines. We already have variables above
475: -- which have the src doc count. we will use these to check
476: -- Bug 4618614: GSCC error to check the log level
477: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
478: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name ||
479: 'Auto Apply Contract terms if applicable.' , 0);
480: END IF;
481:
482: IF l_ga_count = 0 AND

Line 494: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

490: x_return_status => l_return_status);
491: END IF;
492:
493: -- Bug 4618614: GSCC error to check the log level
494: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
495: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name ||
496: 'Return Status: '||l_return_status , 0);
497: END IF;
498: -- < 11i10+ - R12 Contracts ER End>

Line 495: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name ||

491: END IF;
492:
493: -- Bug 4618614: GSCC error to check the log level
494: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
495: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name ||
496: 'Return Status: '||l_return_status , 0);
497: END IF;
498: -- < 11i10+ - R12 Contracts ER End>
499:

Line 502: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

498: -- < 11i10+ - R12 Contracts ER End>
499:
500: exception
501: when others then
502: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
503: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,c_log_head || l_api_name ||'.EXCEPTION', 'update terms: Inside exception :'|| '000' ||sqlcode);
504: END IF;
505: END update_terms;
506:

Line 503: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,c_log_head || l_api_name ||'.EXCEPTION', 'update terms: Inside exception :'|| '000' ||sqlcode);

499:
500: exception
501: when others then
502: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
503: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,c_log_head || l_api_name ||'.EXCEPTION', 'update terms: Inside exception :'|| '000' ||sqlcode);
504: END IF;
505: END update_terms;
506:
507: --