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_CP_INTRFAC_TO_TRANSACTION dependencies on FND_LOG

Line 110: ----IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

106: l_module CONSTANT VARCHAR2(30) := 'DEFAULT_PREV_ROUND_AMEND_LINES';
107:
108: begin
109: --{
110: ----IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
111: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
112: print_debug_log(l_module,'DEFAULT_PREV_ROUND_AMEND_LINES START p_auction_header_id = '||p_auction_header_id||
113: ' p_batch_id = '||p_batch_id);
114: END IF;

Line 111: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

107:
108: begin
109: --{
110: ----IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
111: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
112: print_debug_log(l_module,'DEFAULT_PREV_ROUND_AMEND_LINES START p_auction_header_id = '||p_auction_header_id||
113: ' p_batch_id = '||p_batch_id);
114: END IF;
115:

Line 392: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

388: and pah.max_internal_line_num >= paip_int.auction_line_number
389: and paip_int.action = g_update_action);
390:
391: END IF;
392: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
393: print_debug_log(l_module,'DEFAULT_PREV_ROUND_AMEND_LINES END p_auction_header_id = '||p_auction_header_id||
394: ' p_batch_id = '||p_batch_id);
395: END IF;
396:

Line 419: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

415: l_next_sequence_number number;
416:
417: BEGIN
418: --{
419: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
420: print_debug_log(l_module,'GET_NEXT_PE_SEQUENCE_NUMBER START');
421: END IF;
422:
423: l_next_sequence_number := g_price_element_seq_number + 10;

Line 441: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

437: where
438: auction_header_id = p_auction_header
439: and line_number = p_line_number;
440:
441: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
442: print_debug_log(l_module,'GET_NEXT_PE_SEQUENCE_NUMBER LINE Number is not same '||
443: ' p_line_number = '||p_line_number||
444: ' g_price_element_line_number = '||g_price_element_line_number);
445: END IF;

Line 458: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

454: end if;
455: */
456: g_price_element_seq_number := l_next_sequence_number;
457:
458: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
459: print_debug_log(l_module,'GET_NEXT_PE_SEQUENCE_NUMBER END l_next_sequence_number = '||l_next_sequence_number);
460: END IF;
461:
462: return l_next_sequence_number;

Line 491: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

487: l_exception_msg VARCHAR2(100);
488:
489: BEGIN
490: --{
491: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
492: print_debug_log(l_module,'INITIALIZE_LINE_ATTR_GROUP START p_party_id = '||p_party_id);
493: END IF;
494:
495: pon_profile_util_pkg.retrieve_party_pref_cover(

Line 505: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

501: x_status => l_status,
502: x_exception_msg => l_exception_msg
503: );
504:
505: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
506: print_debug_log(l_module,'INITIALIZE_LINE_ATTR_GROUP END p_party_id = '||p_party_id||
507: 'l_default_pary_group = '||l_default_pary_group||
508: 'l_pref_meaning = '||l_pref_meaning||
509: 'l_status = '||l_status||

Line 526: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

522: INTO g_price_element_seq_number
523: FROM pon_price_elements
524: WHERE auction_header_id = g_auction_header_id;
525:
526: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
527: print_debug_log(l_module,'INITIALIZE_LINE_ATTR_GROUP END p_party_id = '||p_party_id||
528: 'g_default_attribute_group = '|| g_default_attribute_group ||
529: 'g_price_element_seq_number = '|| g_price_element_seq_number);
530: END IF;

Line 759: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

755:
756:
757: BEGIN
758: --{
759: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
760: print_debug_log(l_module,'DELETE_LINES_WITH_CHILDREN START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
761: END IF;
762:
763: --delete from PON_AUCTION_ATTRIBUTES

Line 1006: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1002: and p1.action = g_delete_action
1003: and item_prices.line_number = p1.auction_line_number);
1004:
1005:
1006: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1007: print_debug_log(l_module,'DELETE_LINES_WITH_CHILDREN END g_batch_id = '|| g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1008: END IF;
1009:
1010: --}

Line 1083: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1079: l_is_fed := 'N';
1080: END;
1081:
1082:
1083: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1084: print_debug_log(l_module,'ADD_LINES START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1085: END IF;
1086:
1087: -- price break line setting

Line 1281: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1277: The procedure PON_NEGOTIATION_PUBLISH_PVT.SET_ITEM_HAS_CHILDREN_FLAGS
1278: will be used for this. This would be called after lined have been updated
1279: added or deleted.
1280: */
1281: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1282: print_debug_log(l_module,'Inserted records into pon_auction_item_prices_all');
1283: END IF;
1284:
1285: --clm clin/slin changes

Line 1388: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1384: END IF;
1385:
1386:
1387:
1388: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1389: print_debug_log(l_module,'ADD_LINES END g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1390: END IF;
1391:
1392: --}

Line 1414: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1410: l_module CONSTANT VARCHAR2(17) := 'ADD_PRICE_FACTORS';
1411:
1412: BEGIN
1413: --{
1414: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1415: print_debug_log(l_module,'ADD_PRICE_FACTORS START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1416: END IF;
1417:
1418: insert into PON_PRICE_ELEMENTS

Line 1459: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1455: and p1.auction_line_number = pe_int.auction_line_number
1456: and nvl(p1.action,g_add_action) = g_add_action
1457: order by sequence_number;
1458:
1459: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1460: print_debug_log(l_module,'ADD_PRICE_FACTORS END g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1461: END IF;
1462:
1463: --}

Line 1482: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1478: l_module CONSTANT VARCHAR2(23) := 'ADD_PRICE_DIFFERENTIALS';
1479:
1480: BEGIN
1481: --{
1482: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1483: print_debug_log(l_module,'ADD_PRICE_DIFFERENTIALS START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1484: END IF;
1485:
1486: insert into PON_PRICE_DIFFERENTIALS

Line 1522: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1518: and nvl(p1.action,'+') = g_add_action
1519: AND Nvl(pdf_int.auction_shipment_number,-1) = -1;
1520:
1521:
1522: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1523: print_debug_log(l_module,'ADD_PRICE_DIFFERENTIALS END g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1524: END IF;
1525:
1526: --}

Line 1547: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1543: l_module CONSTANT VARCHAR2(14) := 'ADD_ATTRIBUTES';
1544:
1545: BEGIN
1546: --{
1547: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1548: print_debug_log(l_module,'ADD_ATTRIBUTES START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1549: END IF;
1550:
1551: insert into pon_auction_attributes

Line 1621: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1617: and p1.batch_id = paa_int.batch_id
1618: and p1.auction_line_number = paa_int.auction_line_number
1619: and nvl(p1.action,'+') = g_add_action;
1620:
1621: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1622: print_debug_log(l_module,'ADD_ATTRIBUTES END g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1623: END IF;
1624:
1625: --}

Line 1653: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1649: l_module CONSTANT VARCHAR2(20) := 'ADD_ATTRIBUTE_SCORES';
1650:
1651: BEGIN
1652: --{
1653: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1654: print_debug_log(l_module,'ADD_ATTRIBUTE_SCORES START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1655: END IF;
1656:
1657: insert into pon_attribute_scores

Line 1710: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1706: and interface_attributes.attribute_name = auction_attributes.attribute_name
1707: and interface_attributes.response_type_name = 'PON_FROM_TEMPLATE' ;
1708:
1709:
1710: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1711: print_debug_log(l_module,'ADD_ATTRIBUTE_SCORES END g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1712: END IF;
1713:
1714: --}

Line 1734: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1730: l_template_id pon_auction_headers_all.template_id%type;
1731:
1732: BEGIN
1733: --{
1734: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1735: print_debug_log(l_module,'ADD_NEW_LINE_WITH_CHILDREN START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1736: END IF;
1737:
1738: SELECT

Line 1775: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1771: END if;
1772:
1773: end if;
1774:
1775: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1776: print_debug_log(l_module,'ADD_NEW_LINE_WITH_CHILDREN END g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1777: END IF;
1778:
1779: --}

Line 1858: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1854: l_clm_pop_duration_uom PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1855:
1856: BEGIN
1857: --{
1858: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1859: print_debug_log(l_module,'UPDATE_LINES START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1860: END IF;
1861:
1862: SELECT

Line 2152: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2148: AUCTION_HEADER_ID = g_auction_header_id AND
2149: LINE_NUMBER = l_line_number (x);
2150:
2151:
2152: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2153: print_debug_log(l_module,'UPDATE_LINES END g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
2154: END IF;
2155:
2156: --}

Line 2176: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2172: l_module CONSTANT VARCHAR2(25) := 'UPDATE_PRICE_DIFFERNTIALS';
2173:
2174: BEGIN
2175: --{
2176: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2177: print_debug_log(l_module,'UPDATE_PRICE_DIFFERNTIALS START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
2178: END IF;
2179:
2180: -- Delete existing price differentials for updated lines

Line 2234: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2230: AND Nvl(price_diff_int.auction_shipment_number,-1) = -1;
2231:
2232:
2233:
2234: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2235: print_debug_log(l_module,'UPDATE_PRICE_DIFFERNTIALS END g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
2236: END IF;
2237:
2238: --}

Line 2267: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2263: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2264: l_display_to_suppliers_flag VARCHAR2(1) := 'Y';
2265: BEGIN
2266: --{
2267: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2268: print_debug_log(l_module,'UPDATE_PRICE_FACTORS START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
2269: END IF;
2270:
2271: -- Delete supplier price factors from auction tables that are

Line 2393: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2389: and pe_int.auction_line_number = pe1.line_number
2390: and pe_int.price_element_type_id = pe1.price_element_type_id)
2391: order by pe_int.sequence_number;
2392:
2393: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2394: print_debug_log(l_module,'UPDATE_PRICE_FACTORS END g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
2395: END IF;
2396:
2397: --}

Line 2438: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2434:
2435:
2436: BEGIN
2437: --{
2438: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2439: print_debug_log(l_module,'UPDATE_LINE_ATTRIBUTES START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
2440: END IF;
2441:
2442:

Line 2604: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2600: pon_auction_attributes
2601: WHERE
2602: AUCTION_HEADER_ID = g_auction_header_id;
2603:
2604: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2605: print_debug_log(l_module,'UPDATE_LINE_ATTRIBUTES END g_batch_id = '||g_batch_id ||
2606: ' g_auction_header_id '||g_auction_header_id ||
2607: ' l_max_neg_line_attr_seq_num = '||l_max_neg_line_attr_seq_num);
2608: END IF;

Line 2678: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2674: and paa_int.auction_line_number = auction_attributes.line_number
2675: and paa_int.attribute_name = auction_attributes.attribute_name)
2676: order by paa_int.auction_line_number,paa_int.sequence_number;
2677:
2678: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2679: print_debug_log(l_module,'UPDATE_LINE_ATTRIBUTES END g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
2680: END IF;
2681:
2682: --}

Line 2701: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2697: l_module CONSTANT VARCHAR2(26) := 'UPDATE_LINES_WITH_CHILDREN';
2698:
2699: BEGIN
2700: --{
2701: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2702: print_debug_log(l_module,'UPDATE_LINES_WITH_CHILDREN START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
2703: END IF;
2704:
2705: UPDATE_LINES;

Line 2725: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2721: UPDATE_LINE_ATTRIBUTES;
2722:
2723: end if;
2724:
2725: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2726: print_debug_log(l_module,'UPDATE_LINES_WITH_CHILDREN END g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
2727: END IF;
2728:
2729: --}

Line 2751: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2747:
2748: begin
2749: --{
2750:
2751: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2752: print_debug_log(l_module,'SYNCH_PF_VALUES_FOR_UPLOAD START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
2753: END IF;
2754:
2755: -- Get distinct price factor and pricing basis by scanning the pon_price_elements

Line 2769: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2765: WHERE
2766: auction_header_id = g_auction_header_id
2767: and PF_TYPE = 'BUYER';
2768:
2769: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2770: print_debug_log(l_module,'SYNCH_PF_VALUES_FOR_UPLOAD START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id|| ' : Got Pf Values');
2771: END IF;
2772:
2773: -- Delete values that do not exist

Line 2782: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2778: auction_header_id = g_auction_header_id
2779: and PRICE_ELEMENT_TYPE_ID <> l_PRICE_ELEMENT_TYPE_ID(x)
2780: and PRICING_BASIS <> l_PRICING_BASIS(x);
2781:
2782: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2783: print_debug_log(l_module,'SYNCH_PF_VALUES_FOR_UPLOAD START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id|| ' : Deleted unused Pf Values');
2784: END IF;
2785:
2786: -- Insert new values

Line 2824: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2820: and pf_values.supplier_seq_number = PBP.sequence
2821: and pf_values.price_element_type_id = l_PRICE_ELEMENT_TYPE_ID(x)
2822: and pf_values.pricing_basis = l_PRICING_BASIS(x));
2823:
2824: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2825: print_debug_log(l_module,'SYNCH_PF_VALUES_FOR_UPLOAD END g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
2826: END IF;
2827:
2828: --}

Line 2911: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2907: l_staggered_closing_interval pon_auction_headers_all.staggered_closing_interval%TYPE;
2908:
2909: BEGIN
2910: --{
2911: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2912: print_debug_log(l_module,'SYNCH_FROM_INTERFACE START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
2913: END IF;
2914:
2915: -- Update Global variables

Line 2921: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2917: g_auction_header_id := p_auction_header_id;
2918: g_user_id := p_user_id;
2919: INITIALIZE_LINE_ATTR_GROUP(p_party_id);
2920:
2921: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2922: l_progress := 'INITIALIZE_LINE_ATTR_GROUP completed for p_auction_header_id = '||p_auction_header_id;
2923: END if;
2924:
2925: select

Line 2967: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2963: auction_header_id = p_auction_header_id
2964: and doctypes.doctype_id = pah.doctype_id;
2965:
2966:
2967: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2968: print_debug_log(l_module,'SYNCH_FROM_INTERFACE START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id ||
2969: ' l_line_attribute_enabled_flag = '|| l_line_attribute_enabled_flag ||
2970: ' l_contract_type = '|| l_contract_type ||
2971: ' l_internal_name = '|| l_internal_name ||

Line 3025: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

3021: g_is_amendment := 'Y';
3022: END IF;
3023:
3024:
3025: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3026: print_debug_log(l_module,'SYNCH_FROM_INTERFACE g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id ||
3027: ' g_line_attribute_enabled = '|| g_line_attribute_enabled ||
3028: ' g_attribute_score_enabled_flag = '|| g_attribute_score_enabled_flag ||
3029: ' g_price_differentials_flag = '|| g_price_differentials_flag ||

Line 3060: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

3056: p_pk4_value => NULL,
3057: p_pk5_value => NULL);
3058: END LOOP;
3059:
3060: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3061: l_progress := 'Data copied for p_auction_header_id = '||p_auction_header_id;
3062: END if;
3063:
3064: /* Set the following fields for all records in pon_auction_item_prices all

Line 3076: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

3072: PON_NEGOTIATION_PUBLISH_PVT.SET_ITEM_HAS_CHILDREN_FLAGS
3073: (p_auction_header_id => p_auction_header_id,
3074: p_close_bidding_date => null);
3075:
3076: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3077: l_progress := 'PON_NEGOTIATION_PUBLISH_PVT.SET_ITEM_HAS_CHILDREN_FLAGS p_auction_header_id = '||p_auction_header_id;
3078: END if;
3079:
3080: /*

Line 3098: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

3094: p_start_disp_line_number => 0,
3095: x_last_line_close_date => x_last_line_close_date);
3096: end if;
3097:
3098: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3099: l_progress := 'PON_NEGOTIATION_PUBLISH_PVT.UPDATE_STAG_LINES_CLOSE_DATES' ||
3100: 'l_first_line_close_date = ' || to_char(l_first_line_close_date, 'dd-mon-yyyy hh24:mi:ss') ||
3101: 'l_staggered_closing_interval = ' || l_staggered_closing_interval ||
3102: 'x_last_line_close_date = ' || to_char(x_last_line_close_date, 'dd-mon-yyyy hh24:mi:ss');

Line 3150: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

3146: paip.auction_header_id = p_auction_header_id;
3147: end if;
3148:
3149:
3150: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3151: l_progress := 'PON_NEGOTIATION_PUBLISH_PVT.RENUMBER_LINES p_auction_header_id = '||p_auction_header_id||' l_max_display_number = '||l_max_display_number;
3152: END if;
3153:
3154:

Line 3165: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

3161: delete from pon_auc_price_differ_int where batch_id = g_batch_id;
3162: delete from pon_auc_price_elements_int where batch_id = g_batch_id;
3163:
3164:
3165: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3166: l_progress := 'delete completed p_auction_header_id = '||p_auction_header_id;
3167: END if;
3168: END IF;
3169:

Line 3175: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

3171: INTO l_number_of_lines
3172: FROM pon_auction_item_prices_all
3173: WHERE auction_header_id = g_auction_header_id;
3174:
3175: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3176: l_progress := 'delete completed g_batch_id = '||g_batch_id ||
3177: ' g_auction_header_id ='||g_auction_header_id;
3178: END if;
3179:

Line 3183: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

3179:
3180: x_number_of_lines := l_number_of_lines;
3181: x_max_disp_line := l_max_display_number;
3182:
3183: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3184: l_progress := 'delete completed g_batch_id = '||g_batch_id ||
3185: ' g_auction_header_id ='||g_auction_header_id;
3186:
3187: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 3187: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

3183: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3184: l_progress := 'delete completed g_batch_id = '||g_batch_id ||
3185: ' g_auction_header_id ='||g_auction_header_id;
3186:
3187: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3188: print_debug_log(l_module,'SYNCH_FROM_INTERFACE END g_batch_id = '||g_batch_id ||
3189: ' g_auction_header_id ='||g_auction_header_id);
3190: END IF;
3191:

Line 3202: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

3198: WHEN OTHERS THEN
3199: x_result := 'F';
3200: x_error_code := SQLCODE;
3201: x_error_message := SUBSTR(SQLERRM, 1, 100);
3202: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3203: print_error_log(l_module, 'EXCEPTION - l_progress='||l_progress||' x_result=' || x_result || ' x_error_code=' || x_error_code || ' x_error_message=' || x_error_message || ' SQLERRM=' || SQLERRM);
3204: END if;
3205:
3206: --}

Line 3297: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

3293: AND papi.attachment_desc IS NOT NULL;
3294:
3295: BEGIN
3296: --{
3297: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3298: print_debug_log(l_module,'SYNCH_PAYMENTS_FROM_INTERFACE START p_batch_id = '||p_batch_id ||' p_auction_header_id '||p_auction_header_id);
3299: END IF;
3300:
3301: -- If the payment_display_number and line_number combination already exists

Line 3430: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

3426: fnd_global.login_id
3427: ) ;
3428:
3429:
3430: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3431: l_progress := 'Merge into pon_auc_payments_shipments is successful for auction_header_id = '||p_auction_header_id;
3432: END if;
3433:
3434: --create URL Attachments

Line 3463: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

3459: -- Clear the interface tables
3460: -- What is there is an error? need to clear these always
3461: delete from pon_auc_payments_interface where batch_id = p_batch_id;
3462:
3463: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3464: l_progress := 'delete from pon_auc_payments_interface completed for p_batch_id = '||p_batch_id||'p_auction_header_id = '||p_auction_header_id;
3465: END if;
3466:
3467: --Mark which lines are changed during amendment

Line 3543: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

3539:
3540: x_result := 'E';
3541: x_error_code := SQLCODE;
3542: x_error_message := SUBSTR(SQLERRM, 1, 100);
3543: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3544: print_error_log(l_module, 'EXCEPTION - l_progress='||l_progress||' x_result=' || x_result || ' x_error_code=' || x_error_code || ' x_error_message=' || x_error_message || ' SQLERRM=' || SQLERRM);
3545: END if;
3546: END;
3547:

Line 3557: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

3553: WHEN OTHERS THEN
3554: x_result := 'E';
3555: x_error_code := SQLCODE;
3556: x_error_message := SUBSTR(SQLERRM, 1, 100);
3557: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3558: print_error_log(l_module, 'EXCEPTION - l_progress='||l_progress||' x_result=' || x_result || ' x_error_code=' || x_error_code || ' x_error_message=' || x_error_message || ' SQLERRM=' || SQLERRM);
3559: END if;
3560:
3561: --}

Line 3627: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

3623: l_module CONSTANT VARCHAR2(30) := 'SYNCH_PAYMENTS_FROM_INTERFACE';
3624:
3625: BEGIN
3626:
3627: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3628: print_debug_log(l_module,'UPDATE_CONCURRENT_ERRORS Start g_batch_id = '||g_batch_id ||
3629: ' g_auction_header_id ='||g_auction_header_id);
3630: END if;
3631:

Line 3789: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

3785:
3786: l_progress := 'Records inserted';
3787:
3788:
3789: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3790: print_debug_log(l_module,'UPDATE_CONCURRENT_ERRORS END g_batch_id = '||g_batch_id ||
3791: ' g_auction_header_id ='||g_auction_header_id);
3792: END if;
3793:

Line 3801: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

3797: WHEN OTHERS THEN
3798: x_result := 'F';
3799: x_error_code := SQLCODE;
3800: x_error_message := SUBSTR(SQLERRM, 1, 100);
3801: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3802: print_error_log(l_module, 'EXCEPTION - l_progress='|| l_progress ||' x_result=' || x_result || ' x_error_code=' || x_error_code || ' x_error_message=' || x_error_message || ' SQLERRM=' || SQLERRM);
3803: END if;
3804:
3805:

Line 3812: FND logs

3808: /*======================================================================
3809: PROCEDURE: PRINT_DEBUG_LOG PRIVATE
3810: PARAMETERS:
3811: COMMENT : This procedure is used to print debug messages into
3812: FND logs
3813: ======================================================================*/
3814: PROCEDURE print_debug_log(p_module IN VARCHAR2,
3815: p_message IN VARCHAR2)
3816: IS

Line 3820: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

3816: IS
3817:
3818: BEGIN
3819:
3820: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3821: FND_LOG.string(log_level => FND_LOG.level_statement,
3822: module => g_module_prefix || p_module,
3823: message => p_message);
3824: END if;

Line 3821: FND_LOG.string(log_level => FND_LOG.level_statement,

3817:
3818: BEGIN
3819:
3820: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3821: FND_LOG.string(log_level => FND_LOG.level_statement,
3822: module => g_module_prefix || p_module,
3823: message => p_message);
3824: END if;
3825:

Line 3832: error messages into FND logs

3828: /*======================================================================
3829: PROCEDURE: PRINT_ERROR_LOG PRIVATE
3830: PARAMETERS:
3831: COMMENT : This procedure is used to print unexpected exceptions or
3832: error messages into FND logs
3833: ======================================================================*/
3834:
3835: PROCEDURE print_error_log(p_module IN VARCHAR2,
3836: p_message IN VARCHAR2)

Line 3840: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

3836: p_message IN VARCHAR2)
3837: IS
3838: BEGIN
3839:
3840: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3841: FND_LOG.string(log_level => FND_LOG.level_procedure,
3842: module => g_module_prefix || p_module,
3843: message => p_message);
3844: END if;

Line 3841: FND_LOG.string(log_level => FND_LOG.level_procedure,

3837: IS
3838: BEGIN
3839:
3840: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3841: FND_LOG.string(log_level => FND_LOG.level_procedure,
3842: module => g_module_prefix || p_module,
3843: message => p_message);
3844: END if;
3845: