DBA Data[Home] [Help]

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 464: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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