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

Line 76: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

72: AND pay.bid_line_number BETWEEN p_batch_start AND p_batch_end;
73: BEGIN
74: l_module_name := 'Delete_bid_Payment_Attachments';
75:
76: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
77: FND_LOG.string (log_level => FND_LOG.level_procedure,
78: module => g_module_prefix || l_module_name,
79: message => 'Entered procedure = ' || l_module_name);
80: END IF;

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

73: BEGIN
74: l_module_name := 'Delete_bid_Payment_Attachments';
75:
76: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
77: FND_LOG.string (log_level => FND_LOG.level_procedure,
78: module => g_module_prefix || l_module_name,
79: message => 'Entered procedure = ' || l_module_name);
80: END IF;
81: -- Delete all attachments for the bid payments

Line 83: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

79: message => 'Entered procedure = ' || l_module_name);
80: END IF;
81: -- Delete all attachments for the bid payments
82: FOR payment IN bid_payments_with_attachments LOOP
83: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
84: FND_LOG.string (log_level => FND_LOG.level_procedure,
85: module => g_module_prefix || l_module_name,
86: message => 'Deleting fnd attachments for bid payment id ' ||payment.bid_payment_id||'='|| l_module_name);
87: END IF;

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

80: END IF;
81: -- Delete all attachments for the bid payments
82: FOR payment IN bid_payments_with_attachments LOOP
83: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
84: FND_LOG.string (log_level => FND_LOG.level_procedure,
85: module => g_module_prefix || l_module_name,
86: message => 'Deleting fnd attachments for bid payment id ' ||payment.bid_payment_id||'='|| l_module_name);
87: END IF;
88:

Line 98: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

94: x_pk3_value => payment.bid_payment_id,
95: x_delete_document_flag => 'Y');
96: END LOOP;
97:
98: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
99: FND_LOG.string (log_level => FND_LOG.level_procedure,
100: module => g_module_prefix || l_module_name,
101: message => 'After Call FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS = ' || l_module_name);
102: END IF;

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

95: x_delete_document_flag => 'Y');
96: END LOOP;
97:
98: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
99: FND_LOG.string (log_level => FND_LOG.level_procedure,
100: module => g_module_prefix || l_module_name,
101: message => 'After Call FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS = ' || l_module_name);
102: END IF;
103:

Line 104: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

100: module => g_module_prefix || l_module_name,
101: message => 'After Call FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS = ' || l_module_name);
102: END IF;
103:
104: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
105: FND_LOG.string (log_level => FND_LOG.level_procedure,
106: module => g_module_prefix || l_module_name,
107: message => 'Leaving procedure = ' || l_module_name);
108: END IF;

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

101: message => 'After Call FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS = ' || l_module_name);
102: END IF;
103:
104: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
105: FND_LOG.string (log_level => FND_LOG.level_procedure,
106: module => g_module_prefix || l_module_name,
107: message => 'Leaving procedure = ' || l_module_name);
108: END IF;
109:

Line 265: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

261:
262: -- Check if call was unsuccessful
263: IF (NOT l_success) THEN
264: IF (g_debug_mode = 'Y'
265: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
266: FND_LOG.string(log_level => FND_LOG.level_statement,
267: module => g_module_prefix || 'get_request_info',
268: message => x_message);
269: END IF;

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

262: -- Check if call was unsuccessful
263: IF (NOT l_success) THEN
264: IF (g_debug_mode = 'Y'
265: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
266: FND_LOG.string(log_level => FND_LOG.level_statement,
267: module => g_module_prefix || 'get_request_info',
268: message => x_message);
269: END IF;
270:

Line 278: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

274:
275: EXCEPTION
276: WHEN OTHERS THEN
277: IF (g_debug_mode = 'Y'
278: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
279: FND_LOG.string(log_level => FND_LOG.level_statement,
280: module => g_module_prefix || 'get_request_info',
281: message => SQLERRM);
282: END IF;

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

275: EXCEPTION
276: WHEN OTHERS THEN
277: IF (g_debug_mode = 'Y'
278: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
279: FND_LOG.string(log_level => FND_LOG.level_statement,
280: module => g_module_prefix || 'get_request_info',
281: message => SQLERRM);
282: END IF;
283:

Line 536: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

532: IF (l_success) THEN
533: RETURN null;
534: ELSE
535: IF (g_debug_mode = 'Y'
536: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
537: FND_LOG.string(log_level => FND_LOG.level_statement,
538: module => g_module_prefix || 'cancel_concurrent_request',
539: message => l_message);
540: END IF;

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

533: RETURN null;
534: ELSE
535: IF (g_debug_mode = 'Y'
536: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
537: FND_LOG.string(log_level => FND_LOG.level_statement,
538: module => g_module_prefix || 'cancel_concurrent_request',
539: message => l_message);
540: END IF;
541: RETURN l_message;

Line 616: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

612:
613: x_result := FND_API.g_ret_sts_success;
614:
615: IF (g_debug_mode = 'Y'
616: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
617: FND_LOG.string(log_level => FND_LOG.level_statement,
618: module => l_api_name,
619: message => 'BEGIN ::' || p_auction_id || ':::'
620: || p_request_id || ':::' || p_requested_by || ':::'

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

613: x_result := FND_API.g_ret_sts_success;
614:
615: IF (g_debug_mode = 'Y'
616: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
617: FND_LOG.string(log_level => FND_LOG.level_statement,
618: module => l_api_name,
619: message => 'BEGIN ::' || p_auction_id || ':::'
620: || p_request_id || ':::' || p_requested_by || ':::'
621: || p_request_date || ':::' || p_import_file || ':::'

Line 650: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

646:
647: END IF;
648:
649: IF (g_debug_mode = 'Y'
650: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
651: FND_LOG.string(log_level => FND_LOG.level_statement,
652: module => l_api_name,
653: message => 'END ::' || p_auction_id || ':::'
654: || p_request_id || ':::' || p_requested_by || ':::'

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

647: END IF;
648:
649: IF (g_debug_mode = 'Y'
650: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
651: FND_LOG.string(log_level => FND_LOG.level_statement,
652: module => l_api_name,
653: message => 'END ::' || p_auction_id || ':::'
654: || p_request_id || ':::' || p_requested_by || ':::'
655: || p_request_date || ':::' || p_import_file || ':::'

Line 665: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

661: EXCEPTION
662:
663: WHEN OTHERS THEN
664: IF (g_debug_mode = 'Y'
665: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
666: FND_LOG.string(log_level => FND_LOG.level_statement,
667: module => l_api_name,
668: message => 'EXCEPTION ::' || p_auction_id || ':::'
669: || p_request_id || ':::' || p_requested_by

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

662:
663: WHEN OTHERS THEN
664: IF (g_debug_mode = 'Y'
665: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
666: FND_LOG.string(log_level => FND_LOG.level_statement,
667: module => l_api_name,
668: message => 'EXCEPTION ::' || p_auction_id || ':::'
669: || p_request_id || ':::' || p_requested_by
670: || ':::' || p_request_date || ':::' || p_import_file || ':::'

Line 925: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN

921: DEV_PHASE => l_devphase,
922: DEV_STATUS => l_devstatus,
923: MESSAGE => l_message);
924:
925: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
926: FND_LOG.string(log_level => FND_LOG.level_statement,
927:
928: module => g_module_prefix || 'IS_REQUEST_COMPLETE',
929:

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

922: DEV_STATUS => l_devstatus,
923: MESSAGE => l_message);
924:
925: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
926: FND_LOG.string(log_level => FND_LOG.level_statement,
927:
928: module => g_module_prefix || 'IS_REQUEST_COMPLETE',
929:
930: message => 'l_request_id : '|| l_request_id ||

Line 950: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN

946: END IF;
947: END IF;
948:
949:
950: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
951: FND_LOG.string(log_level => FND_LOG.level_statement,
952:
953: module => g_module_prefix || 'IS_REQUEST_COMPLETE',
954:

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

947: END IF;
948:
949:
950: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
951: FND_LOG.string(log_level => FND_LOG.level_statement,
952:
953: module => g_module_prefix || 'IS_REQUEST_COMPLETE',
954:
955: message => 'returning '|| v_request_complete);

Line 1034: if FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then

1030: EXCEPTION
1031: WHEN PON_FAIL_CALL_DEL_DOC THEN
1032: x_return_status := FND_API.G_RET_STS_ERROR ;
1033:
1034: if FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
1035: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'PON_FAIL_CALL_DEL_DOC');
1036: end if;
1037: WHEN OTHERS THEN
1038:

Line 1035: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'PON_FAIL_CALL_DEL_DOC');

1031: WHEN PON_FAIL_CALL_DEL_DOC THEN
1032: x_return_status := FND_API.G_RET_STS_ERROR ;
1033:
1034: if FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
1035: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'PON_FAIL_CALL_DEL_DOC');
1036: end if;
1037: WHEN OTHERS THEN
1038:
1039: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1041: if FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then

1037: WHEN OTHERS THEN
1038:
1039: x_return_status := FND_API.G_RET_STS_ERROR;
1040:
1041: if FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
1042: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'Others:' || substr(1, 255, sqlerrm) );
1043: end if;
1044: END delete_bid_by_header;
1045:

Line 1042: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'Others:' || substr(1, 255, sqlerrm) );

1038:
1039: x_return_status := FND_API.G_RET_STS_ERROR;
1040:
1041: if FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
1042: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'Others:' || substr(1, 255, sqlerrm) );
1043: end if;
1044: END delete_bid_by_header;
1045:
1046: -- Delete bid header attachment