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

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

30: l_exp_date := SYSDATE + 7;
31: l_interface_type := 'BIDPYMTUPLOAD'; --Radhika-- do i need to change this for Xml upload?
32: l_entity_name := 'PON_AUC_PAYMENTS';
33:
34: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
35: print_debug_log(l_module,'VALIDATE_RESPONSE START p_batch_id = '||p_batch_id
36: ||' p_bid_number = ' ||p_bid_number || ' p_auction_header_id = '|| p_auction_header_id);
37: END IF;
38:

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

100: AND pbp.payment_display_number = pbpi2.payment_display_number
101: AND pbp.batch_id = pbpi2.batch_id
102: AND pbp.interface_line_id <> pbpi2.interface_line_id);
103:
104: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
105: print_debug_log(l_module,'After valiating for duplicate payitems for p_batch_id = '||p_batch_id);
106: END IF;
107:
108: -- If we don't delete duplicate records Merge statement won't work

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

119: AND pbpi.batch_id = pbpi2.batch_id
120: AND pbpi.interface_line_id <> pbpi2.interface_line_id);
121: EXCEPTION
122: WHEN OTHERS THEN
123: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
124: print_error_log(l_module, 'EXCEPTION - l_progress='||l_progress||' Error Code=' || SQLCODE || ' SQLERRM=' || SQLERRM);
125: END if;
126: END;
127:

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

557: AND pbh.bid_number(+) = p_bid_number
558: AND pbi.bid_number(+) = p_bid_number
559: ;
560:
561: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
562: print_debug_log(l_module,'After Insert all for validate_response p_batch_id = '||p_batch_id);
563: END IF;
564:
565:

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

606: AND pah.auction_header_id = pbp.auction_header_id
607: AND pah.supplier_enterable_pymt_flag = 'N'
608: AND pbp.batch_id = p_batch_id;
609:
610: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
611: print_debug_log(l_module,'After valiating for supplier enterable flag for p_batch_id = '||p_batch_id);
612: END IF;
613:
614: EXCEPTION

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

612: END IF;
613:
614: EXCEPTION
615: WHEN OTHERS THEN
616: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
617: print_error_log(l_module, 'EXCEPTION - l_progress='||l_progress||' Error Code=' || SQLCODE || ' SQLERRM=' || SQLERRM);
618: END if;
619: END validate_response;
620:

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

652: l_loginid := fnd_global.login_id;
653: l_exp_date := SYSDATE + 7;
654: l_interface_type := 'NEGPYMTUPLOAD';
655:
656: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
657: print_debug_log(l_module,'Before insert all valiations of validate_creation for p_batch_id = '||p_batch_id);
658: END IF;
659:
660: INSERT ALL

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

1270: WHERE pbr.auction_header_id= pai.auction_header_id
1271: AND pbr.line_number = pai.line_number
1272: AND pbr.requisition_line_id = pr.requisition_line_id))));
1273:
1274: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1275: print_debug_log(l_module,'After insert all valiations of validate_creation for p_batch_id = '||p_batch_id);
1276: END IF;
1277:
1278: --Validate project fields with PATC

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

1301: p_called_from => 'PAYMENTS_SP');
1302: END IF;
1303: END LOOP;
1304:
1305: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1306: print_debug_log(l_module,'After calling projects validations for p_batch_id = '||p_batch_id);
1307: END IF;
1308: EXCEPTION
1309:

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

1307: END IF;
1308: EXCEPTION
1309:
1310: WHEN OTHERS THEN
1311: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1312: print_error_log(l_module, 'EXCEPTION - l_progress='||l_progress||' Error Code=' || SQLCODE || ' SQLERRM=' || SQLERRM);
1313: END if;
1314: END validate_creation;
1315: --

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

1363: BEGIN
1364:
1365: x_result := 'S';
1366:
1367: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1368: print_debug_log(l_module,'COPY_PAYMENTS_FROM_INT_TO_TXN START p_batch_id = '||p_batch_id);
1369: END IF;
1370:
1371: -- select some variables that we need for currency conversion

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

1471: fnd_global.user_id ,
1472: fnd_global.login_id
1473: ) ;
1474:
1475: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1476: l_progress := 'Merge into pon_bid_payments_shipments is successful for batch_id = '||p_batch_id;
1477: END if;
1478:
1479: IF (p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_txt_upload_mode) THEN

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

1534:
1535: END IF;
1536:
1537:
1538: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1539: l_progress := 'creting URL Attachments is complete for p_batch_id = '||p_batch_id;
1540: END if;
1541:
1542:

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

1567:
1568: -- Clear the interface tables
1569: delete from pon_bid_payments_interface where batch_id = p_batch_id;
1570:
1571: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1572: l_progress := 'delete from pon_bid_payments_interface completed for p_batch_id = '||p_batch_id;
1573: END if;
1574:
1575: EXCEPTION

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

1576: WHEN OTHERS THEN
1577: x_result := 'E';
1578: x_error_code := SQLCODE;
1579: x_error_message := SUBSTR(SQLERRM, 1, 100);
1580: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1581: 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);
1582: END if;
1583: END copy_payments_from_int_to_txn;
1584:

Line 1590: error messages into FND logs

1586: /*======================================================================
1587: PROCEDURE: PRINT_ERROR_LOG PRIVATE
1588: PARAMETERS:
1589: COMMENT : This procedure is used to print unexpected exceptions or
1590: error messages into FND logs
1591: ======================================================================*/
1592:
1593: PROCEDURE print_error_log(p_module IN VARCHAR2,
1594: p_message IN VARCHAR2)

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

1594: p_message IN VARCHAR2)
1595: IS
1596: BEGIN
1597:
1598: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1599: FND_LOG.string(log_level => FND_LOG.level_procedure,
1600: module => g_module_prefix || p_module,
1601: message => p_message);
1602: END if;

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

1595: IS
1596: BEGIN
1597:
1598: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1599: FND_LOG.string(log_level => FND_LOG.level_procedure,
1600: module => g_module_prefix || p_module,
1601: message => p_message);
1602: END if;
1603:

Line 1610: FND logs

1606: /*======================================================================
1607: PROCEDURE: PRINT_DEBUG_LOG PRIVATE
1608: PARAMETERS:
1609: COMMENT : This procedure is used to print debug messages into
1610: FND logs
1611: ======================================================================*/
1612: PROCEDURE print_debug_log(p_module IN VARCHAR2,
1613: p_message IN VARCHAR2)
1614: IS

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

1614: IS
1615:
1616: BEGIN
1617:
1618: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1619: FND_LOG.string(log_level => FND_LOG.level_statement,
1620: module => g_module_prefix || p_module,
1621: message => p_message);
1622: END if;

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

1615:
1616: BEGIN
1617:
1618: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1619: FND_LOG.string(log_level => FND_LOG.level_statement,
1620: module => g_module_prefix || p_module,
1621: message => p_message);
1622: END if;
1623: