DBA Data[Home] [Help]

APPS.OKC_OPPORTUNITY_PVT dependencies on OKC_OPPORTUNITY_PVT

Line 1: PACKAGE BODY OKC_OPPORTUNITY_PVT AS

1: PACKAGE BODY OKC_OPPORTUNITY_PVT AS
2: /* $Header: OKCROPPB.pls 120.0 2005/05/25 19:31:13 appldev noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:

Line 28: okc_debug.log('1000: Entering okc_opportunity_pvt.create_opportunity', 2);

24:
25: Begin
26: IF (l_debug = 'Y') THEN
27: okc_debug.Set_Indentation('Create_Opportunity');
28: okc_debug.log('1000: Entering okc_opportunity_pvt.create_opportunity', 2);
29: END IF;
30: x_return_status := okc_api.g_ret_sts_success;
31: --
32: IF (l_debug = 'Y') THEN

Line 93: okc_debug.log('2000: Exiting okc_opportunity_pvt.create_opportunity', 2);

89: --
90:
91: x_lead_id := l_lead_id;
92: IF (l_debug = 'Y') THEN
93: okc_debug.log('2000: Exiting okc_opportunity_pvt.create_opportunity', 2);
94: okc_debug.Reset_Indentation;
95: END IF;
96: Exception
97: When g_exception_halt_validation Then

Line 100: okc_debug.log('1970: Exiting okc_opportunity_pvt.create_opportunity', 2);

96: Exception
97: When g_exception_halt_validation Then
98: x_return_status := l_return_status;
99: IF (l_debug = 'Y') THEN
100: okc_debug.log('1970: Exiting okc_opportunity_pvt.create_opportunity', 2);
101: okc_debug.Reset_Indentation;
102: END IF;
103: When Others Then
104: okc_api.Set_Message(p_app_name => g_app_name,

Line 112: okc_debug.log('1990: Exiting okc_opportunity_pvt.create_opportunity', 2);

108: p_token2 => g_sqlerrm_token,
109: p_token2_value => sqlerrm);
110: x_return_status := okc_api.g_ret_sts_unexp_error;
111: IF (l_debug = 'Y') THEN
112: okc_debug.log('1990: Exiting okc_opportunity_pvt.create_opportunity', 2);
113: okc_debug.Reset_Indentation;
114: END IF;
115: End Create_Opportunity;
116:

Line 231: okc_debug.log('3000: Entering okc_opportunity_pvt.create_opp_header', 2);

227:
228: Begin
229: IF (l_debug = 'Y') THEN
230: okc_debug.Set_Indentation('Create_Opp_Header');
231: okc_debug.log('3000: Entering okc_opportunity_pvt.create_opp_header', 2);
232: END IF;
233: x_return_status := okc_api.g_ret_sts_success;
234: --
235: IF (l_debug = 'Y') THEN

Line 526: okc_debug.log('4000: Exiting okc_opportunity_pvt.create_opp_header', 2);

522: x_msg_data := l_msg_data;
523: x_msg_count := l_msg_count;
524:
525: IF (l_debug = 'Y') THEN
526: okc_debug.log('4000: Exiting okc_opportunity_pvt.create_opp_header', 2);
527: okc_debug.Reset_Indentation;
528: END IF;
529: Exception
530: When g_exception_halt_validation Then

Line 533: okc_debug.log('3980: Exiting okc_opportunity_pvt.create_opp_header', 2);

529: Exception
530: When g_exception_halt_validation Then
531: x_return_status := l_return_status;
532: IF (l_debug = 'Y') THEN
533: okc_debug.log('3980: Exiting okc_opportunity_pvt.create_opp_header', 2);
534: okc_debug.Reset_Indentation;
535: END IF;
536: When Others Then
537: okc_api.Set_Message(p_app_name => g_app_name,

Line 545: okc_debug.log('3990: Exiting okc_opportunity_pvt.create_opp_header', 2);

541: p_token2 => g_sqlerrm_token,
542: p_token2_value => sqlerrm);
543: x_return_status := okc_api.g_ret_sts_unexp_error;
544: IF (l_debug = 'Y') THEN
545: okc_debug.log('3990: Exiting okc_opportunity_pvt.create_opp_header', 2);
546: okc_debug.Reset_Indentation;
547: END IF;
548: End Create_Opp_Header;
549: --

Line 764: okc_debug.log('5000: Entering okc_opportunity_pvt.create_opp_lines', 2);

760: --
761: Begin
762: IF (l_debug = 'Y') THEN
763: okc_debug.Set_Indentation('Create_Opp_Lines');
764: okc_debug.log('5000: Entering okc_opportunity_pvt.create_opp_lines', 2);
765: okc_debug.log(' with next parameters:', 2);
766: okc_debug.log(' p_context = '||p_context);
767: okc_debug.log(' p_contract_id = '||p_contract_id);
768: okc_debug.log(' p_lead_id = '||p_lead_id);

Line 1100: okc_debug.log('6000: Exiting okc_opportunity_pvt.create_opp_lines', 2);

1096: x_msg_data := l_msg_data;
1097: x_msg_count := l_msg_count;
1098:
1099: IF (l_debug = 'Y') THEN
1100: okc_debug.log('6000: Exiting okc_opportunity_pvt.create_opp_lines', 2);
1101: okc_debug.Reset_Indentation;
1102: END IF;
1103: Exception
1104: When g_exception_halt_validation Then

Line 1107: okc_debug.log('5980: Exiting okc_opportunity_pvt.create_opp_lines', 2);

1103: Exception
1104: When g_exception_halt_validation Then
1105: x_return_status := l_return_status;
1106: IF (l_debug = 'Y') THEN
1107: okc_debug.log('5980: Exiting okc_opportunity_pvt.create_opp_lines', 2);
1108: okc_debug.Reset_Indentation;
1109: END IF;
1110: When Others Then
1111: okc_api.Set_Message(p_app_name => g_app_name,

Line 1119: okc_debug.log('5990: Exiting okc_opportunity_pvt.create_opp_lines', 2);

1115: p_token2 => g_sqlerrm_token,
1116: p_token2_value => sqlerrm);
1117: x_return_status := okc_api.g_ret_sts_unexp_error;
1118: IF (l_debug = 'Y') THEN
1119: okc_debug.log('5990: Exiting okc_opportunity_pvt.create_opp_lines', 2);
1120: okc_debug.Reset_Indentation;
1121: END IF;
1122: End Create_Opp_Lines;
1123:

Line 1208: okc_debug.log('7000: Entering okc_opportunity_pvt.is_opp_creation_allowed', 2);

1204: --
1205: Begin
1206: IF (l_debug = 'Y') THEN
1207: okc_debug.Set_Indentation('Is_Opp_Creation_Allowed');
1208: okc_debug.log('7000: Entering okc_opportunity_pvt.is_opp_creation_allowed', 2);
1209: END IF;
1210: x_return_status := okc_api.g_ret_sts_success;
1211: -- Get contract's details
1212: Open k_csr;

Line 1361: okc_debug.log('8000: Exiting okc_opportunity_pvt.is_opp_creation_allowed', 2);

1357: End If;
1358: --
1359: IF (l_debug = 'Y') THEN
1360: okc_debug.log('7500: Opportunity Creation is allowed');
1361: okc_debug.log('8000: Exiting okc_opportunity_pvt.is_opp_creation_allowed', 2);
1362: okc_debug.Reset_Indentation;
1363: END IF;
1364: Exception
1365: When g_exception_halt_validation Then

Line 1369: okc_debug.log('7980: Exiting okc_opportunity_pvt.is_opp_creation_allowed', 2);

1365: When g_exception_halt_validation Then
1366: x_return_status := okc_api.g_ret_sts_error;
1367: IF (l_debug = 'Y') THEN
1368: okc_debug.log('7600: Opportunity Creation is not allowed');
1369: okc_debug.log('7980: Exiting okc_opportunity_pvt.is_opp_creation_allowed', 2);
1370: okc_debug.Reset_Indentation;
1371: END IF;
1372: When Others Then
1373: okc_api.Set_Message(p_app_name => g_app_name,

Line 1381: okc_debug.log('7990: Exiting okc_opportunity_pvt.is_opp_creation_allowed', 2);

1377: p_token2 => g_sqlerrm_token,
1378: p_token2_value => sqlerrm);
1379: x_return_status := okc_api.g_ret_sts_unexp_error;
1380: IF (l_debug = 'Y') THEN
1381: okc_debug.log('7990: Exiting okc_opportunity_pvt.is_opp_creation_allowed', 2);
1382: okc_debug.Reset_Indentation;
1383: END IF;
1384: End Is_Opp_Creation_Allowed;
1385:

Line 1407: okc_debug.log('9000: Entering okc_opportunity_pvt.get_opp_defaults', 2);

1403: --
1404: Begin
1405: IF (l_debug = 'Y') THEN
1406: okc_debug.Set_Indentation('Get_Opp_Defaults');
1407: okc_debug.log('9000: Entering okc_opportunity_pvt.get_opp_defaults', 2);
1408: okc_debug.log('9010: Calling Mode - ' || p_context);
1409: END IF;
1410: x_return_status := okc_api.g_ret_sts_success;
1411: --

Line 1448: okc_debug.log('10000: Exiting okc_opportunity_pvt.get_opp_defaults', 2);

1444: --
1445: IF (l_debug = 'Y') THEN
1446: okc_debug.log('9070: x_win_probability - ' || x_win_probability);
1447: okc_debug.log('9080: x_closing_date_days - ' || x_closing_date_days);
1448: okc_debug.log('10000: Exiting okc_opportunity_pvt.get_opp_defaults', 2);
1449: okc_debug.Reset_Indentation;
1450: END IF;
1451: Exception
1452: When Others Then

Line 1461: okc_debug.log('9990: Exiting okc_opportunity_pvt.get_opp_defaults', 2);

1457: p_token2 => g_sqlerrm_token,
1458: p_token2_value => sqlerrm);
1459: x_return_status := okc_api.g_ret_sts_unexp_error;
1460: IF (l_debug = 'Y') THEN
1461: okc_debug.log('9990: Exiting okc_opportunity_pvt.get_opp_defaults', 2);
1462: okc_debug.Reset_Indentation;
1463: END IF;
1464: End Get_Opp_Defaults;
1465: END OKC_OPPORTUNITY_PVT;

Line 1465: END OKC_OPPORTUNITY_PVT;

1461: okc_debug.log('9990: Exiting okc_opportunity_pvt.get_opp_defaults', 2);
1462: okc_debug.Reset_Indentation;
1463: END IF;
1464: End Get_Opp_Defaults;
1465: END OKC_OPPORTUNITY_PVT;