DBA Data[Home] [Help]

APPS.PON_RESPONSE_IMPORT_PKG dependencies on FND_LOG

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

451: l_has_profile_value_numeric VARCHAR2(1) := 'N';
452: BEGIN
453:
454:
455: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
456: FND_LOG.string(log_level => FND_LOG.level_procedure,
457: module => g_module_prefix || l_module,
458: message => 'BEGIN validate_attribute_datatypes procedure '||' p_auc_header_id=' || p_auc_header_id || ' p_bid_number=' || p_bid_number || ' p_userid=' || p_userid|| ' p_suffix=' || p_suffix|| ' p_batch_id=' || p_batch_id);
459: END if;

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

452: BEGIN
453:
454:
455: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
456: FND_LOG.string(log_level => FND_LOG.level_procedure,
457: module => g_module_prefix || l_module,
458: message => 'BEGIN validate_attribute_datatypes procedure '||' p_auc_header_id=' || p_auc_header_id || ' p_bid_number=' || p_bid_number || ' p_userid=' || p_userid|| ' p_suffix=' || p_suffix|| ' p_batch_id=' || p_batch_id);
459: END if;
460:

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

492:
493: IF(l_numeric_characters IS NOT NULL) THEN
494: l_has_profile_value_numeric := 'Y';
495: END IF;
496: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
497: FND_LOG.string(log_level => FND_LOG.level_procedure,
498: module => g_module_prefix || l_module,
499: message => 'l_has_profile_value_numeric='|| l_has_profile_value_numeric|| ' g_error_int='||g_error_int||
500: ' l_numeric_characters=' || l_numeric_characters || ' l_decimal_separator_character=' ||

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

493: IF(l_numeric_characters IS NOT NULL) THEN
494: l_has_profile_value_numeric := 'Y';
495: END IF;
496: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
497: FND_LOG.string(log_level => FND_LOG.level_procedure,
498: module => g_module_prefix || l_module,
499: message => 'l_has_profile_value_numeric='|| l_has_profile_value_numeric|| ' g_error_int='||g_error_int||
500: ' l_numeric_characters=' || l_numeric_characters || ' l_decimal_separator_character=' ||
501: l_decimal_separator_character || ' l_grouping_separator_character=' || l_grouping_separator_character);

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

521: AND bai.interface_line_id = l_int_lines(i)
522: AND bai.attribute_name = l_attr_names(i);
523:
524:
525: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
526: FND_LOG.string(log_level => FND_LOG.level_procedure,
527: module => g_module_prefix || l_module,
528: message => 'IN validate_attribute_datatypes after FORALL');
529: END if;

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

522: AND bai.attribute_name = l_attr_names(i);
523:
524:
525: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
526: FND_LOG.string(log_level => FND_LOG.level_procedure,
527: module => g_module_prefix || l_module,
528: message => 'IN validate_attribute_datatypes after FORALL');
529: END if;
530:

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

542: FOR i IN 1..l_num_errors LOOP
543:
544: l_index := SQL%BULK_EXCEPTIONS(i).ERROR_INDEX;
545:
546: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
547: FND_LOG.string(log_level => FND_LOG.level_procedure,
548: module => g_module_prefix || l_module,
549: message => 'IN EXCEPTION BLOCK p_suffix='|| p_suffix ||' l_int_lines(l_index)=' || l_int_lines(l_index) ||
550: ' l_values(l_index)=' || l_values(l_index) || ' l_line_numbers(l_index)=' || l_line_numbers(l_index) ||

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

543:
544: l_index := SQL%BULK_EXCEPTIONS(i).ERROR_INDEX;
545:
546: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
547: FND_LOG.string(log_level => FND_LOG.level_procedure,
548: module => g_module_prefix || l_module,
549: message => 'IN EXCEPTION BLOCK p_suffix='|| p_suffix ||' l_int_lines(l_index)=' || l_int_lines(l_index) ||
550: ' l_values(l_index)=' || l_values(l_index) || ' l_line_numbers(l_index)=' || l_line_numbers(l_index) ||
551: ' l_attr_names(l_index)=' || l_attr_names(l_index) || 'Error: ' || i ||

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

600:
601: END LOOP;
602:
603:
604: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
605: FND_LOG.string(log_level => FND_LOG.level_procedure,
606: module => g_module_prefix || l_module,
607: message => 'END validate_attribute_datatypes');
608: END if;

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

601: END LOOP;
602:
603:
604: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
605: FND_LOG.string(log_level => FND_LOG.level_procedure,
606: module => g_module_prefix || l_module,
607: message => 'END validate_attribute_datatypes');
608: END if;
609:

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

1485: END IF;
1486:
1487: EXCEPTION
1488: WHEN OTHERS THEN
1489: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1490: FND_LOG.string(log_level => FND_LOG.level_procedure,
1491: module => g_module_prefix || l_module,
1492: message => ' Error Code=' || SQLCODE || ' SQLERRM=' || SQLERRM);
1493: END if;

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

1486:
1487: EXCEPTION
1488: WHEN OTHERS THEN
1489: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1490: FND_LOG.string(log_level => FND_LOG.level_procedure,
1491: module => g_module_prefix || l_module,
1492: message => ' Error Code=' || SQLCODE || ' SQLERRM=' || SQLERRM);
1493: END if;
1494: END;

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

1548: -- change to From Supplier: Technical
1549: l_target_category := pon_auction_pkg.g_technical_attachment;
1550: END IF; -- }
1551:
1552: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN -- {
1553: FND_LOG.string(log_level => FND_LOG.level_statement,
1554: module => g_module_prefix || 'create_url_attachments',
1555: message => 'l_two_part_flag: ' || l_two_part_flag || '; l_target_category: ' || l_target_category);
1556: END IF; -- }

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

1549: l_target_category := pon_auction_pkg.g_technical_attachment;
1550: END IF; -- }
1551:
1552: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN -- {
1553: FND_LOG.string(log_level => FND_LOG.level_statement,
1554: module => g_module_prefix || 'create_url_attachments',
1555: message => 'l_two_part_flag: ' || l_two_part_flag || '; l_target_category: ' || l_target_category);
1556: END IF; -- }
1557:

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

3439:
3440:
3441: for r_lineCursor in lineCursor loop
3442:
3443: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3444: FND_LOG.string(log_level => FND_LOG.level_statement,
3445: module => 'process_spreadsheet_uda_data for import',
3446: message => 'Invoking PO_UDA_IMPORT_PKG.IMPORT_UDA_ATTRS for line Number'||r_lineCursor.lno);
3447: END IF;

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

3440:
3441: for r_lineCursor in lineCursor loop
3442:
3443: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3444: FND_LOG.string(log_level => FND_LOG.level_statement,
3445: module => 'process_spreadsheet_uda_data for import',
3446: message => 'Invoking PO_UDA_IMPORT_PKG.IMPORT_UDA_ATTRS for line Number'||r_lineCursor.lno);
3447: END IF;
3448: l_uda_data_present := IS_UDA_DATA_IN_INTERFACE(p_bid_number,r_lineCursor.lno);

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

3452: --Adding p_transaction_id to the call as per the latest API for IMPORT_UDA_ATTRS
3453: PO_UDA_IMPORT_PKG.IMPORT_UDA_ATTRS
3454: ('PON_BID_PRICES_EXT_ATTRS',p_bid_number,r_lineCursor.lno,null,null,null,po_uda_array,ego_value_pairs_table,l_return_status,l_errorcode,msgCount,msgData,'N',p_transaction_id);
3455:
3456: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3457: FND_LOG.string(log_level => FND_LOG.level_statement,
3458: module => 'process_spreadsheet_uda_data for import',
3459: message => ' PO_UDA_IMPORT_PKG.IMPORT_UDA_ATTRS returned'|| x_return_status ||' with msgData' || msgData);
3460: END IF;

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

3453: PO_UDA_IMPORT_PKG.IMPORT_UDA_ATTRS
3454: ('PON_BID_PRICES_EXT_ATTRS',p_bid_number,r_lineCursor.lno,null,null,null,po_uda_array,ego_value_pairs_table,l_return_status,l_errorcode,msgCount,msgData,'N',p_transaction_id);
3455:
3456: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3457: FND_LOG.string(log_level => FND_LOG.level_statement,
3458: module => 'process_spreadsheet_uda_data for import',
3459: message => ' PO_UDA_IMPORT_PKG.IMPORT_UDA_ATTRS returned'|| x_return_status ||' with msgData' || msgData);
3460: END IF;
3461:

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

3466: end if;
3467:
3468:
3469: IF(x_return_status='E') THEN
3470: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3471: FND_LOG.string(log_level => FND_LOG.level_statement,
3472: module => 'process_spreadsheet_uda_data for import',
3473: message => 'EXITING THE PROCEDURE. ERROR :' || x_return_status ||' AT LINE '|| r_lineCursor.lno || ':'|| msgData );
3474: END IF;

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

3467:
3468:
3469: IF(x_return_status='E') THEN
3470: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3471: FND_LOG.string(log_level => FND_LOG.level_statement,
3472: module => 'process_spreadsheet_uda_data for import',
3473: message => 'EXITING THE PROCEDURE. ERROR :' || x_return_status ||' AT LINE '|| r_lineCursor.lno || ':'|| msgData );
3474: END IF;
3475: