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

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

8:
9: l_api_name VARCHAR2(30) := 'GET_SOL_TOTAL_AMT';
10:
11: BEGIN
12: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
13: FND_LOG.string(log_level => FND_LOG.level_statement,
14: module => l_api_name,
15: message => 'Entered with parameters p_auction_header_id : ' || p_auction_header_id);
16: END IF;

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

9: l_api_name VARCHAR2(30) := 'GET_SOL_TOTAL_AMT';
10:
11: BEGIN
12: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
13: FND_LOG.string(log_level => FND_LOG.level_statement,
14: module => l_api_name,
15: message => 'Entered with parameters p_auction_header_id : ' || p_auction_header_id);
16: END IF;
17:

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

19: INTO l_sol_total_amt
20: FROM pon_auction_item_prices_all
21: WHERE auction_header_id = p_auction_header_id;
22:
23: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24: FND_LOG.string(log_level => FND_LOG.level_statement,
25: module => l_api_name,
26: message => 'l_sol_total_amt : ' || l_sol_total_amt);
27: END IF;

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

20: FROM pon_auction_item_prices_all
21: WHERE auction_header_id = p_auction_header_id;
22:
23: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24: FND_LOG.string(log_level => FND_LOG.level_statement,
25: module => l_api_name,
26: message => 'l_sol_total_amt : ' || l_sol_total_amt);
27: END IF;
28:

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

29: RETURN l_sol_total_amt;
30:
31: EXCEPTION
32: WHEN OTHERS THEN
33: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
34: FND_LOG.string(log_level => FND_LOG.level_statement,
35: module => l_api_name,
36: message => 'Error Occured when fetching data');
37: END IF;

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

30:
31: EXCEPTION
32: WHEN OTHERS THEN
33: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
34: FND_LOG.string(log_level => FND_LOG.level_statement,
35: module => l_api_name,
36: message => 'Error Occured when fetching data');
37: END IF;
38: RETURN l_sol_total_amt;

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

58: l_api_name VARCHAR2(30) := 'GET_SBCR_DETAILS';
59:
60: BEGIN
61:
62: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
63: FND_LOG.string(log_level => FND_LOG.level_statement,
64: module => l_api_name,
65: message => 'Entered with parameters p_auction_header_id : ' || p_auction_header_id);
66: END IF;

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

59:
60: BEGIN
61:
62: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
63: FND_LOG.string(log_level => FND_LOG.level_statement,
64: module => l_api_name,
65: message => 'Entered with parameters p_auction_header_id : ' || p_auction_header_id);
66: END IF;
67:

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

70:
71: l_contract_rec.contract_type := l_contract_type;
72:
73:
74: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
75: FND_LOG.string(log_level => FND_LOG.level_statement,
76: module => l_api_name,
77: message => 'Passing the following parameters to OKC_REP_CONTRACT_IMP_PUB.check_contract_exists ' ||
78: 'l_document_rec.business_document_id : ' || p_auction_header_id ||

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

71: l_contract_rec.contract_type := l_contract_type;
72:
73:
74: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
75: FND_LOG.string(log_level => FND_LOG.level_statement,
76: module => l_api_name,
77: message => 'Passing the following parameters to OKC_REP_CONTRACT_IMP_PUB.check_contract_exists ' ||
78: 'l_document_rec.business_document_id : ' || p_auction_header_id ||
79: 'l_document_rec.business_document_type : SOLICITATION' ||

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

96: x_contract_status_code := l_contract_rec.contract_status_code;
97: x_coordination_type := l_contract_rec.sbcr_coordination_type;
98:
99:
100: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
101: FND_LOG.string(log_level => FND_LOG.level_statement,
102: module => l_api_name,
103: message => 'Exited OKC_REP_CONTRACT_IMP_PUB.check_contract_exists with return status : ' || x_return_status);
104: END IF;

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

97: x_coordination_type := l_contract_rec.sbcr_coordination_type;
98:
99:
100: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
101: FND_LOG.string(log_level => FND_LOG.level_statement,
102: module => l_api_name,
103: message => 'Exited OKC_REP_CONTRACT_IMP_PUB.check_contract_exists with return status : ' || x_return_status);
104: END IF;
105:

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

104: END IF;
105:
106: EXCEPTION
107: WHEN OTHERS THEN
108: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
109: FND_LOG.string(log_level => FND_LOG.level_statement,
110: module => l_api_name,
111: message => 'Exception when getting SBCR details. Returning with status : ' || x_return_status);
112: END IF;

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

105:
106: EXCEPTION
107: WHEN OTHERS THEN
108: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
109: FND_LOG.string(log_level => FND_LOG.level_statement,
110: module => l_api_name,
111: message => 'Exception when getting SBCR details. Returning with status : ' || x_return_status);
112: END IF;
113:

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

126: l_api_name VARCHAR2(30) := 'DELETE_SBCR';
127:
128: BEGIN
129:
130: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
131: FND_LOG.string(log_level => FND_LOG.level_statement,
132: module => l_api_name,
133: message => 'Entered with parameters p_auction_header_id : ' || p_auction_header_id ||
134: 'p_contract_id : ' || p_contract_id);

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

127:
128: BEGIN
129:
130: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
131: FND_LOG.string(log_level => FND_LOG.level_statement,
132: module => l_api_name,
133: message => 'Entered with parameters p_auction_header_id : ' || p_auction_header_id ||
134: 'p_contract_id : ' || p_contract_id);
135: END IF;

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

137: l_document_rec.business_document_type := 'SOLICITATION';
138: l_document_rec.business_document_id := p_auction_header_id;
139:
140:
141: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
142: FND_LOG.string(log_level => FND_LOG.level_statement,
143: module => l_api_name,
144: message => 'Passing the following parameters to OKC_REP_CONTRACT_IMP_PUB.check_contract_exists ' ||
145: 'l_document_rec.business_document_id : ' || p_auction_header_id ||

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

138: l_document_rec.business_document_id := p_auction_header_id;
139:
140:
141: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
142: FND_LOG.string(log_level => FND_LOG.level_statement,
143: module => l_api_name,
144: message => 'Passing the following parameters to OKC_REP_CONTRACT_IMP_PUB.check_contract_exists ' ||
145: 'l_document_rec.business_document_id : ' || p_auction_header_id ||
146: 'l_document_rec.business_document_type : SOLICITATION' ||

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

157: x_msg_count => l_msg_count,
158: x_return_status => x_return_status);
159:
160:
161: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
162: FND_LOG.string(log_level => FND_LOG.level_statement,
163: module => l_api_name,
164: message => 'Exited OKC_REP_CONTRACT_IMP_PUB.delete_contract with return status : ' || x_return_status);
165: END IF;

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

158: x_return_status => x_return_status);
159:
160:
161: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
162: FND_LOG.string(log_level => FND_LOG.level_statement,
163: module => l_api_name,
164: message => 'Exited OKC_REP_CONTRACT_IMP_PUB.delete_contract with return status : ' || x_return_status);
165: END IF;
166:

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

165: END IF;
166:
167: EXCEPTION
168: WHEN OTHERS THEN
169: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
170: FND_LOG.string(log_level => FND_LOG.level_statement,
171: module => l_api_name,
172: message => 'Exception when deleting SBCR for auction_header_id : ' || p_auction_header_id || '. Returning with status : ' || x_return_status);
173: END IF;

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

166:
167: EXCEPTION
168: WHEN OTHERS THEN
169: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
170: FND_LOG.string(log_level => FND_LOG.level_statement,
171: module => l_api_name,
172: message => 'Exception when deleting SBCR for auction_header_id : ' || p_auction_header_id || '. Returning with status : ' || x_return_status);
173: END IF;
174: