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 108: ----IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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

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

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

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

383: and pah.max_internal_line_num >= paip_int.auction_line_number
384: and paip_int.action = g_update_action);
385:
386: END IF;
387: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
388: print_debug_log(l_module,'DEFAULT_PREV_ROUND_AMEND_LINES END p_auction_header_id = '||p_auction_header_id||
389: ' p_batch_id = '||p_batch_id);
390: END IF;
391:

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

410: l_next_sequence_number number;
411:
412: BEGIN
413: --{
414: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
415: print_debug_log(l_module,'GET_NEXT_PE_SEQUENCE_NUMBER START');
416: END IF;
417:
418: l_next_sequence_number := g_price_element_seq_number + 10;

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

432: where
433: auction_header_id = p_auction_header
434: and line_number = p_line_number;
435:
436: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
437: print_debug_log(l_module,'GET_NEXT_PE_SEQUENCE_NUMBER LINE Number is not same '||
438: ' p_line_number = '||p_line_number||
439: ' g_price_element_line_number = '||g_price_element_line_number);
440: END IF;

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

449: end if;
450: */
451: g_price_element_seq_number := l_next_sequence_number;
452:
453: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
454: print_debug_log(l_module,'GET_NEXT_PE_SEQUENCE_NUMBER END l_next_sequence_number = '||l_next_sequence_number);
455: END IF;
456:
457: return l_next_sequence_number;

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

482: l_exception_msg VARCHAR2(100);
483:
484: BEGIN
485: --{
486: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
487: print_debug_log(l_module,'INITIALIZE_LINE_ATTR_GROUP START p_party_id = '||p_party_id);
488: END IF;
489:
490: pon_profile_util_pkg.retrieve_party_pref_cover(

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

496: x_status => l_status,
497: x_exception_msg => l_exception_msg
498: );
499:
500: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
501: print_debug_log(l_module,'INITIALIZE_LINE_ATTR_GROUP END p_party_id = '||p_party_id||
502: 'l_default_pary_group = '||l_default_pary_group||
503: 'l_pref_meaning = '||l_pref_meaning||
504: 'l_status = '||l_status||

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

517: INTO g_price_element_seq_number
518: FROM pon_price_elements
519: WHERE auction_header_id = g_auction_header_id;
520:
521: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
522: print_debug_log(l_module,'INITIALIZE_LINE_ATTR_GROUP END p_party_id = '||p_party_id||
523: 'g_default_attribute_group = '|| g_default_attribute_group ||
524: 'g_price_element_seq_number = '|| g_price_element_seq_number);
525: END IF;

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

743:
744:
745: BEGIN
746: --{
747: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
748: print_debug_log(l_module,'DELETE_LINES_WITH_CHILDREN START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
749: END IF;
750:
751: --delete from PON_AUCTION_ATTRIBUTES

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

970: and p1.action = g_delete_action
971: and item_prices.line_number = p1.auction_line_number);
972:
973:
974: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
975: print_debug_log(l_module,'DELETE_LINES_WITH_CHILDREN END g_batch_id = '|| g_batch_id ||' g_auction_header_id '||g_auction_header_id);
976: END IF;
977:
978: --}

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

998: l_price_break_neg_flag pon_auction_item_prices_all.price_break_neg_flag%type;
999:
1000: BEGIN
1001: --{
1002: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1003: print_debug_log(l_module,'ADD_LINES START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1004: END IF;
1005:
1006: -- price break line setting

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

1163: added or deleted.
1164: */
1165:
1166:
1167: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1168: print_debug_log(l_module,'ADD_LINES END g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1169: END IF;
1170:
1171: --}

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

1189: l_module CONSTANT VARCHAR2(17) := 'ADD_PRICE_FACTORS';
1190:
1191: BEGIN
1192: --{
1193: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1194: print_debug_log(l_module,'ADD_PRICE_FACTORS START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1195: END IF;
1196:
1197: insert into PON_PRICE_ELEMENTS

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

1234: and p1.auction_line_number = pe_int.auction_line_number
1235: and nvl(p1.action,g_add_action) = g_add_action
1236: order by sequence_number;
1237:
1238: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1239: print_debug_log(l_module,'ADD_PRICE_FACTORS END g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1240: END IF;
1241:
1242: --}

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

1257: l_module CONSTANT VARCHAR2(23) := 'ADD_PRICE_DIFFERENTIALS';
1258:
1259: BEGIN
1260: --{
1261: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1262: print_debug_log(l_module,'ADD_PRICE_DIFFERENTIALS START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1263: END IF;
1264:
1265: insert into PON_PRICE_DIFFERENTIALS

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

1296: and p1.auction_line_number = pdf_int.auction_line_number
1297: and nvl(p1.action,'+') = g_add_action;
1298:
1299:
1300: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1301: print_debug_log(l_module,'ADD_PRICE_DIFFERENTIALS END g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1302: END IF;
1303:
1304: --}

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

1321: l_module CONSTANT VARCHAR2(14) := 'ADD_ATTRIBUTES';
1322:
1323: BEGIN
1324: --{
1325: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1326: print_debug_log(l_module,'ADD_ATTRIBUTES START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1327: END IF;
1328:
1329: insert into pon_auction_attributes

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

1395: and p1.batch_id = paa_int.batch_id
1396: and p1.auction_line_number = paa_int.auction_line_number
1397: and nvl(p1.action,'+') = g_add_action;
1398:
1399: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1400: print_debug_log(l_module,'ADD_ATTRIBUTES END g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1401: END IF;
1402:
1403: --}

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

1427: l_module CONSTANT VARCHAR2(20) := 'ADD_ATTRIBUTE_SCORES';
1428:
1429: BEGIN
1430: --{
1431: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1432: print_debug_log(l_module,'ADD_ATTRIBUTE_SCORES START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1433: END IF;
1434:
1435: insert into pon_attribute_scores

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

1484: and interface_attributes.attribute_name = auction_attributes.attribute_name
1485: and interface_attributes.response_type_name = 'PON_FROM_TEMPLATE' ;
1486:
1487:
1488: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1489: print_debug_log(l_module,'ADD_ATTRIBUTE_SCORES END g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1490: END IF;
1491:
1492: --}

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

1508: l_template_id pon_auction_headers_all.template_id%type;
1509:
1510: BEGIN
1511: --{
1512: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1513: 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);
1514: END IF;
1515:
1516: SELECT

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

1549: END if;
1550:
1551: end if;
1552:
1553: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1554: 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);
1555: END IF;
1556:
1557: --}

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

1621: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1622:
1623: BEGIN
1624: --{
1625: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1626: print_debug_log(l_module,'UPDATE_LINES START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1627: END IF;
1628:
1629: SELECT

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

1888: AUCTION_HEADER_ID = g_auction_header_id AND
1889: LINE_NUMBER = l_line_number (x);
1890:
1891:
1892: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1893: print_debug_log(l_module,'UPDATE_LINES END g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1894: END IF;
1895:
1896: --}

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

1912: l_module CONSTANT VARCHAR2(25) := 'UPDATE_PRICE_DIFFERNTIALS';
1913:
1914: BEGIN
1915: --{
1916: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1917: print_debug_log(l_module,'UPDATE_PRICE_DIFFERNTIALS START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1918: END IF;
1919:
1920: -- Delete existing price differentials for updated lines

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

1969: and paip_int.action = g_update_action;
1970:
1971:
1972:
1973: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1974: print_debug_log(l_module,'UPDATE_PRICE_DIFFERNTIALS END g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1975: END IF;
1976:
1977: --}

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

2002: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2003: l_display_to_suppliers_flag VARCHAR2(1) := 'Y';
2004: BEGIN
2005: --{
2006: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2007: print_debug_log(l_module,'UPDATE_PRICE_FACTORS START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
2008: END IF;
2009:
2010: -- Delete supplier price factors from auction tables that are

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

2128: and pe_int.auction_line_number = pe1.line_number
2129: and pe_int.price_element_type_id = pe1.price_element_type_id)
2130: order by pe_int.sequence_number;
2131:
2132: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2133: print_debug_log(l_module,'UPDATE_PRICE_FACTORS END g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
2134: END IF;
2135:
2136: --}

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

2173:
2174:
2175: BEGIN
2176: --{
2177: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2178: print_debug_log(l_module,'UPDATE_LINE_ATTRIBUTES START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
2179: END IF;
2180:
2181:

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

2339: pon_auction_attributes
2340: WHERE
2341: AUCTION_HEADER_ID = g_auction_header_id;
2342:
2343: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2344: print_debug_log(l_module,'UPDATE_LINE_ATTRIBUTES END g_batch_id = '||g_batch_id ||
2345: ' g_auction_header_id '||g_auction_header_id ||
2346: ' l_max_neg_line_attr_seq_num = '||l_max_neg_line_attr_seq_num);
2347: END IF;

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

2413: and paa_int.auction_line_number = auction_attributes.line_number
2414: and paa_int.attribute_name = auction_attributes.attribute_name)
2415: order by paa_int.auction_line_number,paa_int.sequence_number;
2416:
2417: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2418: print_debug_log(l_module,'UPDATE_LINE_ATTRIBUTES END g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
2419: END IF;
2420:
2421: --}

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

2436: l_module CONSTANT VARCHAR2(26) := 'UPDATE_LINES_WITH_CHILDREN';
2437:
2438: BEGIN
2439: --{
2440: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2441: print_debug_log(l_module,'UPDATE_LINES_WITH_CHILDREN START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
2442: END IF;
2443:
2444: UPDATE_LINES;

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

2460: UPDATE_LINE_ATTRIBUTES;
2461:
2462: end if;
2463:
2464: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2465: print_debug_log(l_module,'UPDATE_LINES_WITH_CHILDREN END g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
2466: END IF;
2467:
2468: --}

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

2486:
2487: begin
2488: --{
2489:
2490: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2491: 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);
2492: END IF;
2493:
2494: -- Get distinct price factor and pricing basis by scanning the pon_price_elements

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

2504: WHERE
2505: auction_header_id = g_auction_header_id
2506: and PF_TYPE = 'BUYER';
2507:
2508: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2509: 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');
2510: END IF;
2511:
2512: -- Delete values that do not exist

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

2517: auction_header_id = g_auction_header_id
2518: and PRICE_ELEMENT_TYPE_ID <> l_PRICE_ELEMENT_TYPE_ID(x)
2519: and PRICING_BASIS <> l_PRICING_BASIS(x);
2520:
2521: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2522: 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');
2523: END IF;
2524:
2525: -- Insert new values

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

2559: and pf_values.supplier_seq_number = PBP.sequence
2560: and pf_values.price_element_type_id = l_PRICE_ELEMENT_TYPE_ID(x)
2561: and pf_values.pricing_basis = l_PRICING_BASIS(x));
2562:
2563: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2564: 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);
2565: END IF;
2566:
2567: --}

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

2646: l_staggered_closing_interval pon_auction_headers_all.staggered_closing_interval%TYPE;
2647:
2648: BEGIN
2649: --{
2650: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2651: print_debug_log(l_module,'SYNCH_FROM_INTERFACE START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
2652: END IF;
2653:
2654: -- Update Global variables

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

2656: g_auction_header_id := p_auction_header_id;
2657: g_user_id := p_user_id;
2658: INITIALIZE_LINE_ATTR_GROUP(p_party_id);
2659:
2660: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2661: l_progress := 'INITIALIZE_LINE_ATTR_GROUP completed for p_auction_header_id = '||p_auction_header_id;
2662: END if;
2663:
2664: select

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

2702: auction_header_id = p_auction_header_id
2703: and doctypes.doctype_id = pah.doctype_id;
2704:
2705:
2706: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2707: print_debug_log(l_module,'SYNCH_FROM_INTERFACE START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id ||
2708: ' l_line_attribute_enabled_flag = '|| l_line_attribute_enabled_flag ||
2709: ' l_contract_type = '|| l_contract_type ||
2710: ' l_internal_name = '|| l_internal_name ||

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

2760: g_is_amendment := 'Y';
2761: END IF;
2762:
2763:
2764: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2765: print_debug_log(l_module,'SYNCH_FROM_INTERFACE g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id ||
2766: ' g_line_attribute_enabled = '|| g_line_attribute_enabled ||
2767: ' g_attribute_score_enabled_flag = '|| g_attribute_score_enabled_flag ||
2768: ' g_price_differentials_flag = '|| g_price_differentials_flag ||

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

2795: p_pk4_value => NULL,
2796: p_pk5_value => NULL);
2797: END LOOP;
2798:
2799: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2800: l_progress := 'Data copied for p_auction_header_id = '||p_auction_header_id;
2801: END if;
2802:
2803: /* Set the following fields for all records in pon_auction_item_prices all

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

2811: PON_NEGOTIATION_PUBLISH_PVT.SET_ITEM_HAS_CHILDREN_FLAGS
2812: (p_auction_header_id => p_auction_header_id,
2813: p_close_bidding_date => null);
2814:
2815: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2816: l_progress := 'PON_NEGOTIATION_PUBLISH_PVT.SET_ITEM_HAS_CHILDREN_FLAGS p_auction_header_id = '||p_auction_header_id;
2817: END if;
2818:
2819: /*

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

2833: p_start_disp_line_number => 0,
2834: x_last_line_close_date => x_last_line_close_date);
2835: end if;
2836:
2837: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2838: l_progress := 'PON_NEGOTIATION_PUBLISH_PVT.UPDATE_STAG_LINES_CLOSE_DATES' ||
2839: 'l_first_line_close_date = ' || to_char(l_first_line_close_date, 'dd-mon-yyyy hh24:mi:ss') ||
2840: 'l_staggered_closing_interval = ' || l_staggered_closing_interval ||
2841: 'x_last_line_close_date = ' || to_char(x_last_line_close_date, 'dd-mon-yyyy hh24:mi:ss');

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

2885: paip.auction_header_id = p_auction_header_id;
2886: end if;
2887:
2888:
2889: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2890: l_progress := 'PON_NEGOTIATION_PUBLISH_PVT.RENUMBER_LINES p_auction_header_id = '||p_auction_header_id||' l_max_display_number = '||l_max_display_number;
2891: END if;
2892:
2893:

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

2898: delete from pon_auc_payments_interface where batch_id = g_batch_id;
2899: delete from pon_auc_price_differ_int where batch_id = g_batch_id;
2900: delete from pon_auc_price_elements_int where batch_id = g_batch_id;
2901:
2902: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2903: l_progress := 'delete completed p_auction_header_id = '||p_auction_header_id;
2904: END if;
2905:
2906: SELECT count(line_number)

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

2907: INTO l_number_of_lines
2908: FROM pon_auction_item_prices_all
2909: WHERE auction_header_id = g_auction_header_id;
2910:
2911: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2912: l_progress := 'delete completed g_batch_id = '||g_batch_id ||
2913: ' g_auction_header_id ='||g_auction_header_id;
2914: END if;
2915:

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

2915:
2916: x_number_of_lines := l_number_of_lines;
2917: x_max_disp_line := l_max_display_number;
2918:
2919: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2920: l_progress := 'delete completed g_batch_id = '||g_batch_id ||
2921: ' g_auction_header_id ='||g_auction_header_id;
2922:
2923: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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

2919: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2920: l_progress := 'delete completed g_batch_id = '||g_batch_id ||
2921: ' g_auction_header_id ='||g_auction_header_id;
2922:
2923: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2924: print_debug_log(l_module,'SYNCH_FROM_INTERFACE END g_batch_id = '||g_batch_id ||
2925: ' g_auction_header_id ='||g_auction_header_id);
2926: END IF;
2927:

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

2934: WHEN OTHERS THEN
2935: x_result := 'F';
2936: x_error_code := SQLCODE;
2937: x_error_message := SUBSTR(SQLERRM, 1, 100);
2938: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2939: 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);
2940: END if;
2941:
2942: --}

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

2998: AND papi.attachment_desc IS NOT NULL;
2999:
3000: BEGIN
3001: --{
3002: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3003: print_debug_log(l_module,'SYNCH_PAYMENTS_FROM_INTERFACE START p_batch_id = '||p_batch_id ||' p_auction_header_id '||p_auction_header_id);
3004: END IF;
3005:
3006: -- If the payment_display_number and line_number combination already exists

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

3131: fnd_global.login_id
3132: ) ;
3133:
3134:
3135: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3136: l_progress := 'Merge into pon_auc_payments_shipments is successful for auction_header_id = '||p_auction_header_id;
3137: END if;
3138:
3139: --create URL Attachments

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

3164: -- Clear the interface tables
3165: -- What is there is an error? need to clear these always
3166: delete from pon_auc_payments_interface where batch_id = p_batch_id;
3167:
3168: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3169: l_progress := 'delete from pon_auc_payments_interface completed for p_batch_id = '||p_batch_id||'p_auction_header_id = '||p_auction_header_id;
3170: END if;
3171:
3172: --Mark which lines are changed during amendment

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

3244:
3245: x_result := 'E';
3246: x_error_code := SQLCODE;
3247: x_error_message := SUBSTR(SQLERRM, 1, 100);
3248: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3249: 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);
3250: END if;
3251: END;
3252:

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

3258: WHEN OTHERS THEN
3259: x_result := 'E';
3260: x_error_code := SQLCODE;
3261: x_error_message := SUBSTR(SQLERRM, 1, 100);
3262: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3263: 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);
3264: END if;
3265:
3266: --}

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

3328: l_module CONSTANT VARCHAR2(30) := 'SYNCH_PAYMENTS_FROM_INTERFACE';
3329:
3330: BEGIN
3331:
3332: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3333: print_debug_log(l_module,'UPDATE_CONCURRENT_ERRORS Start g_batch_id = '||g_batch_id ||
3334: ' g_auction_header_id ='||g_auction_header_id);
3335: END if;
3336:

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

3490:
3491: l_progress := 'Records inserted';
3492:
3493:
3494: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3495: print_debug_log(l_module,'UPDATE_CONCURRENT_ERRORS END g_batch_id = '||g_batch_id ||
3496: ' g_auction_header_id ='||g_auction_header_id);
3497: END if;
3498:

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

3502: WHEN OTHERS THEN
3503: x_result := 'F';
3504: x_error_code := SQLCODE;
3505: x_error_message := SUBSTR(SQLERRM, 1, 100);
3506: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3507: 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);
3508: END if;
3509:
3510:

Line 3517: FND logs

3513: /*======================================================================
3514: PROCEDURE: PRINT_DEBUG_LOG PRIVATE
3515: PARAMETERS:
3516: COMMENT : This procedure is used to print debug messages into
3517: FND logs
3518: ======================================================================*/
3519: PROCEDURE print_debug_log(p_module IN VARCHAR2,
3520: p_message IN VARCHAR2)
3521: IS

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

3521: IS
3522:
3523: BEGIN
3524:
3525: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3526: FND_LOG.string(log_level => FND_LOG.level_statement,
3527: module => g_module_prefix || p_module,
3528: message => p_message);
3529: END if;

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

3522:
3523: BEGIN
3524:
3525: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3526: FND_LOG.string(log_level => FND_LOG.level_statement,
3527: module => g_module_prefix || p_module,
3528: message => p_message);
3529: END if;
3530:

Line 3537: error messages into FND logs

3533: /*======================================================================
3534: PROCEDURE: PRINT_ERROR_LOG PRIVATE
3535: PARAMETERS:
3536: COMMENT : This procedure is used to print unexpected exceptions or
3537: error messages into FND logs
3538: ======================================================================*/
3539:
3540: PROCEDURE print_error_log(p_module IN VARCHAR2,
3541: p_message IN VARCHAR2)

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

3541: p_message IN VARCHAR2)
3542: IS
3543: BEGIN
3544:
3545: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3546: FND_LOG.string(log_level => FND_LOG.level_procedure,
3547: module => g_module_prefix || p_module,
3548: message => p_message);
3549: END if;

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

3542: IS
3543: BEGIN
3544:
3545: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3546: FND_LOG.string(log_level => FND_LOG.level_procedure,
3547: module => g_module_prefix || p_module,
3548: message => p_message);
3549: END if;
3550: