DBA Data[Home] [Help]

APPS.PA_OPPORTUNITY_MGT_PVT dependencies on PA_DEBUG

Line 13: PA_DEBUG.WRITE(

9: PROCEDURE debug(p_msg IN VARCHAR2) IS
10: BEGIN
11: --dbms_output.put_line('pa_opportunity_mgt_pvt'|| ' : ' || p_msg);
12:
13: PA_DEBUG.WRITE(
14: x_module => 'pa.plsql.pa_opportunity_mgt_pvt',
15: x_msg => p_msg,
16: x_log_level => 3);
17: pa_debug.write_file('LOG', p_msg);

Line 17: pa_debug.write_file('LOG', p_msg);

13: PA_DEBUG.WRITE(
14: x_module => 'pa.plsql.pa_opportunity_mgt_pvt',
15: x_msg => p_msg,
16: x_log_level => 3);
17: pa_debug.write_file('LOG', p_msg);
18: END debug;
19:
20: --
21: -- Procedure : modify_project_attributes

Line 57: --Bug:4469336 Added for avoiding blind calls to pa_debug.write and pa_debug.write_file

53: l_new1_dummy_number NUMBER;
54: l_new2_dummy_number NUMBER;
55: --Bug: 4537865
56: l_msg_index_out NUMBER;
57: --Bug:4469336 Added for avoiding blind calls to pa_debug.write and pa_debug.write_file
58: l_debug_mode VARCHAR2(10);
59: --Bug:4469336
60:
61: l_can_not_convert_currency EXCEPTION;

Line 67: --Bug:4469336 Added for avoiding blind calls to pa_debug.write and pa_debug.write_file

63:
64: BEGIN
65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66:
67: --Bug:4469336 Added for avoiding blind calls to pa_debug.write and pa_debug.write_file
68: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
69: --Bug:4469336
70:
71: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file

Line 68: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

64: BEGIN
65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66:
67: --Bug:4469336 Added for avoiding blind calls to pa_debug.write and pa_debug.write_file
68: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
69: --Bug:4469336
70:
71: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file
72: IF l_debug_mode = 'Y' then

Line 71: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file

67: --Bug:4469336 Added for avoiding blind calls to pa_debug.write and pa_debug.write_file
68: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
69: --Bug:4469336
70:
71: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file
72: IF l_debug_mode = 'Y' then
73:
74: debug('p_project_id = '||p_project_id);
75: debug('p_opportunity_value = ' || p_opportunity_value);

Line 98: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file

94: -- fails if currency is null. Therefore, we bypass the call in the
95: -- case that currency is null.
96: IF p_opportunity_value IS NULL THEN
97:
98: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file
99:
100: IF l_debug_mode = 'Y' then
101: debug('p_opportunity_value is null');
102: END IF;

Line 119: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file

115: x_msg_count => x_msg_count,
116: x_msg_data => x_msg_data);
117: ELSIF p_opportunity_value = 0 THEN
118:
119: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file
120: IF l_debug_mode = 'Y' THEN
121: debug('p_opportunity_value = 0');
122: END IF;
123:

Line 148: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file

144: x_return_status => x_return_status,
145: x_msg_count => x_msg_count,
146: x_msg_data => x_msg_data);
147:
148: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file
149: IF l_debug_mode = 'Y' THEN
150: debug('After validate_value_fields: x_return_status = ' || x_return_status);
151: END IF;
152:

Line 169: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file

165: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
166: PA_UTILS.ADD_MESSAGE('PA', x_msg_data);
167: END IF ;
168: -- End of 5214782
169: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file
170: IF l_debug_mode = 'Y' THEN
171: debug('l_opp_value_currency_code = ' || l_opp_value_currency_code);
172: debug('After check_currency_name_or_code: x_return_status = ' || x_return_status);
173: END IF;

Line 180: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file

176:
177: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
178: IF l_opp_value_currency_code = v_c1.projfunc_currency_code AND l_opp_value_currency_code = v_c1.project_currency_code THEN
179:
180: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file
181: IF l_debug_mode = 'Y' THEN
182: debug('SAME currency codes');
183: END IF;
184:

Line 200: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file

196: x_msg_count => x_msg_count,
197: x_msg_data => x_msg_data);
198: ELSIF PA_OPPORTUNITY_MGT_PVT.is_opp_multi_currency_setup = 'Y' THEN
199:
200: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file
201:
202: IF l_debug_mode = 'Y' THEN
203: debug('is_opp_multi_currency_setup = Y');
204: debug('Need currency conversion');

Line 217: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file

213: x_return_status => x_return_status,
214: x_msg_count => x_msg_count,
215: x_msg_data => x_msg_data);
216:
217: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file
218:
219: IF l_debug_mode = 'Y' THEN
220: debug('l_default_rate_type = '|| l_default_rate_type);
221: END IF;

Line 229: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file

225: p_ei_date => p_expected_approval_date,
226: p_gl_date => sysdate,
227: p_org_id => v_c1.org_id);
228:
229: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file
230:
231: IF l_debug_mode = 'Y' THEN
232: debug('l_conversion_date = '|| l_conversion_date);
233: END IF;

Line 260: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file

256: --p_rate => l_dummy_number, Bug: 4537865
257: p_rate => l_new2_dummy_number, --Bug: 4537865
258: x_status => l_status);
259:
260: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file
261:
262: IF l_debug_mode = 'Y' THEN
263: debug('l_status = '|| l_status);
264: END IF;

Line 268: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file

264: END IF;
265:
266: IF l_status IS NOT NULL AND l_status <> 'N' THEN
267:
268: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file
269:
270: IF l_debug_mode = 'Y' THEN
271: debug('Raise l_can_not_convert_currency :1');
272: END IF;

Line 302: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file

298: --p_rate => l_dummy_number, Bug: 4537865
299: p_rate => l_new2_dummy_number, --Bug: 4537865
300: x_status => l_status);
301:
302: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file
303:
304: IF l_debug_mode = 'Y' THEN
305: debug('l_project_opp_value = '|| l_project_opp_value);
306: debug('l_status = '|| l_status);

Line 311: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file

307: END IF;
308:
309: IF l_status IS NOT NULL AND l_status <> 'N' THEN
310:
311: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file
312: IF l_debug_mode = 'Y' THEN
313: debug('Raise l_can_not_convert_currency :2');
314: END IF;
315:

Line 333: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file

329: x_return_status => x_return_status,
330: x_msg_count => x_msg_count,
331: x_msg_data => x_msg_data);
332:
333: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file
334: IF l_debug_mode = 'Y' THEN
335: debug('After update_row');
336: END IF;
337: END IF;

Line 470: --Bug:4469336 Added for avoiding blind calls to pa_debug.write and pa_debug.write_file

466: l_msg_index_out NUMBER;
467:
468: l_can_not_convert_currency EXCEPTION;
469:
470: --Bug:4469336 Added for avoiding blind calls to pa_debug.write and pa_debug.write_file
471: l_debug_mode VARCHAR2(10);
472: --Bug:4469336
473:
474: BEGIN

Line 477: --Bug:4469336 Added for avoiding blind calls to pa_debug.write and pa_debug.write_file

473:
474: BEGIN
475: x_return_status := FND_API.G_RET_STS_SUCCESS;
476:
477: --Bug:4469336 Added for avoiding blind calls to pa_debug.write and pa_debug.write_file
478: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
479: --Bug:4469336
480:
481: OPEN c1;

Line 478: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

474: BEGIN
475: x_return_status := FND_API.G_RET_STS_SUCCESS;
476:
477: --Bug:4469336 Added for avoiding blind calls to pa_debug.write and pa_debug.write_file
478: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
479: --Bug:4469336
480:
481: OPEN c1;
482: FETCH c1 INTO v_c1;

Line 546: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file

542: --p_rate => l_dummy_number, Bug: 4537865
543: p_rate => l_new2_dummy_number, --Bug: 4537865
544: x_status => l_status);
545:
546: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file
547: IF l_debug_mode = 'Y' THEN
548: debug('l_converted_amount = ' || l_converted_amount);
549: debug('l_status = '|| l_status);
550: END IF;

Line 849: --Bug:4469336 Added for avoiding blind calls to pa_debug.write and pa_debug.write_file

845:
846: v_c1 c1%ROWTYPE;
847: l_result VARCHAR2(1);
848:
849: --Bug:4469336 Added for avoiding blind calls to pa_debug.write and pa_debug.write_file
850: l_debug_mode VARCHAR2(10);
851: --Bug:4469336
852:
853: BEGIN

Line 855: --Bug:4469336 Added for avoiding blind calls to pa_debug.write and pa_debug.write_file

851: --Bug:4469336
852:
853: BEGIN
854:
855: --Bug:4469336 Added for avoiding blind calls to pa_debug.write and pa_debug.write_file
856: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
857: --Bug:4469336
858:
859: OPEN c1;

Line 856: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

852:
853: BEGIN
854:
855: --Bug:4469336 Added for avoiding blind calls to pa_debug.write and pa_debug.write_file
856: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
857: --Bug:4469336
858:
859: OPEN c1;
860: FETCH c1 INTO v_c1;

Line 868: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file

864: IF v_c1.default_rate_type IS NULL THEN
865: l_result := 'N';
866: ELSE
867:
868: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file
869: IF l_debug_mode = 'Y' THEN
870: debug('default_rate_type = '|| v_c1.default_rate_type);
871: END IF;
872: l_result := 'Y';

Line 904: --Bug:4469336 Added for avoiding blind calls to pa_debug.write and pa_debug.write_file

900:
901: v_c1 c1%ROWTYPE;
902: l_result VARCHAR2(1);
903:
904: --Bug:4469336 Added for avoiding blind calls to pa_debug.write and pa_debug.write_file
905: l_debug_mode VARCHAR2(10);
906: --Bug:4469336
907:
908: BEGIN

Line 910: --Bug:4469336 Added for avoiding blind calls to pa_debug.write and pa_debug.write_file

906: --Bug:4469336
907:
908: BEGIN
909:
910: --Bug:4469336 Added for avoiding blind calls to pa_debug.write and pa_debug.write_file
911: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
912: --Bug:4469336
913:
914: OPEN c1;

Line 911: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

907:
908: BEGIN
909:
910: --Bug:4469336 Added for avoiding blind calls to pa_debug.write and pa_debug.write_file
911: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
912: --Bug:4469336
913:
914: OPEN c1;
915: FETCH c1 INTO v_c1;

Line 923: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file

919: IF v_c1.default_rate_type IS NULL THEN
920: l_result := 'N';
921: ELSE
922:
923: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file
924: IF l_debug_mode = 'Y' then
925: debug('default_rate_type = '|| v_c1.default_rate_type);
926: end IF;
927: