DBA Data[Home] [Help]

APPS.ASO_QUOTE_PUB dependencies on FND_PROFILE

Line 33: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

29: IS
30: l_party_rec ASO_PARTY_INT.Party_Rec_Type;
31: BEGIN
32:
33: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
34:
35: x_party_id := p_party_id;
36: x_return_status := FND_API.G_RET_STS_SUCCESS;
37: IF (p_party_id IS NOT NULL

Line 87: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

83: l_msg_count NUMBER;
84:
85: BEGIN
86:
87: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
88:
89: x_party_site_id := p_party_site_id;
90: x_return_status := FND_API.G_RET_STS_SUCCESS;
91: IF (p_party_site_id IS NOT NULL

Line 134: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

130: l_any_errors BOOLEAN := FALSE;
131: l_return_status VARCHAR2(1);
132: BEGIN
133:
134: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
135:
136: x_qte_header_rec := p_qte_header_rec;
137: -- party_id
138: Convert_Party_To_Id (

Line 209: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

205: l_any_errors BOOLEAN := FALSE;
206: l_return_status VARCHAR2(1);
207: BEGIN
208:
209: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
210:
211: x_shipment_rec := p_shipment_rec;
212: -- ship_to_party_id
213: Convert_Party_To_Id (

Line 264: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

260: x_QTE_Line_rec OUT NOCOPY /* file.sql.39 change */ QTE_Line_Rec_Type
261: )
262: IS
263: BEGIN
264: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
265: x_qte_line_rec := p_qte_line_rec;
266: null;
267: END;
268:

Line 323: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

319: x_ln_Sales_Credit_Tbl Sales_Credit_Tbl_Type ;
320: x_ln_Quote_Party_Tbl Quote_Party_Tbl_Type;
321:
322: BEGIN
323: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
324:
325: Create_quote(
326: P_Api_Version_Number => 1.0,
327: P_Init_Msg_List => p_init_msg_list,

Line 432: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

428: x_ln_Sales_Credit_Tbl Sales_Credit_Tbl_Type ;
429: x_ln_Quote_Party_Tbl Quote_Party_Tbl_Type;
430:
431: BEGIN
432: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
433:
434: Update_quote(
435: P_Api_Version_Number => 1.0,
436: P_Init_Msg_List => p_init_msg_list,

Line 508: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

504: BEGIN
505: -- Standard Start of API savepoint
506: SAVEPOINT DELETE_QUOTE_PUB;
507:
508: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
509:
510: -- Standard call to check for call compatibility.
511: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
512: p_api_version_number,

Line 728: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

724: BEGIN
725: -- Standard Start of API savepoint
726: SAVEPOINT GET_QUOTE_PUB;
727:
728: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
729:
730: -- Standard call to check for call compatibility.
731: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
732: p_api_version_number,

Line 841: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

837: BEGIN
838: -- Standard Start of API savepoint
839: SAVEPOINT validate_QUOTE_PUB;
840:
841: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
842:
843: -- Standard call to check for call compatibility.
844: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
845: p_api_version_number,

Line 950: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

946: BEGIN
947: -- Standard Start of API savepoint
948: SAVEPOINT SUBMIT_QUOTE_PUB;
949:
950: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
951:
952: -- Standard call to check for call compatibility.
953: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
954: p_api_version_number,

Line 1164: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

1160: BEGIN
1161: -- Standard Start of API savepoint
1162: SAVEPOINT COPY_QUOTE_PUB;
1163:
1164: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1165:
1166: -- Standard call to check for call compatibility.
1167: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1168: p_api_version_number,

Line 1415: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

1411: l_Qte_Number NUMBER;
1412: l_NEW_Qte_Header_Id NUMBER;
1413: BEGIN
1414:
1415: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1416:
1417: ASO_QUOTE_HEADERS_PVT.Copy_Quote(
1418: P_Api_Version_Number => 1.0,
1419: P_Init_Msg_List => FND_API.G_FALSE,

Line 1511: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

1507: X_Sales_Credit_Tbl Sales_Credit_Tbl_Type;
1508: X_Quote_Party_Tbl Quote_Party_Tbl_Type;
1509: BEGIN
1510:
1511: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1512:
1513: Create_Quote_Line(
1514: P_Api_Version_Number => p_api_version_number,
1515: P_Init_Msg_List => p_init_msg_list,

Line 1626: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

1622: X_Sales_Credit_Tbl Sales_Credit_Tbl_Type;
1623: X_Quote_Party_Tbl Quote_Party_Tbl_Type;
1624: BEGIN
1625:
1626: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1627:
1628: Update_Quote_Line(
1629: P_Api_Version_Number => 1.0,
1630: P_Init_Msg_List => p_init_msg_list,

Line 1706: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

1702: )
1703: IS
1704:
1705: BEGIN
1706: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1707: Delete_Quote_Line(
1708: P_Api_Version_Number => 1.0,
1709: P_Init_Msg_List => P_Init_Msg_List ,
1710: P_Commit => p_commit,

Line 1801: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

1797: x_Qte_Access_Tbl Qte_Access_Tbl_Type;
1798: x_Template_Tbl Template_Tbl_Type;
1799: X_Related_Obj_Tbl Related_Obj_Tbl_Type;
1800: BEGIN
1801: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1802:
1803: if aso_debug_pub.g_debug_flag = 'Y' then
1804: aso_debug_pub.add('Before call to the second overloaded create_quote procedure.',1, 'Y');
1805: end if;

Line 1940: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

1936: x_Qte_Access_Tbl Qte_Access_Tbl_Type;
1937: x_Template_Tbl Template_Tbl_Type;
1938: X_Related_Obj_Tbl Related_Obj_Tbl_Type;
1939: BEGIN
1940: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1941:
1942: if aso_debug_pub.g_debug_flag = 'Y' then
1943: aso_debug_pub.add('Before call to the second overloaded update_quote procedure.',1, 'Y');
1944: end if;

Line 2036: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

2032: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2033: )
2034: IS
2035: BEGIN
2036: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2037: Submit_quote(
2038: P_Api_Version_Number => P_Api_Version_Number,
2039: P_Init_Msg_List => P_Init_Msg_List ,
2040: P_control_rec => P_control_rec,

Line 2138: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

2134:
2135: -- Standard Start of API savepoint
2136: SAVEPOINT CREATE_QUOTE_LINE_PUB;
2137:
2138: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2139:
2140: -- Standard call to check for call compatibility.
2141: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2142: p_api_version_number,

Line 2558: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

2554: BEGIN
2555: -- Standard Start of API savepoint
2556: SAVEPOINT UPDATE_QUOTE_LINE_PUB;
2557:
2558: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2559:
2560: -- Standard call to check for call compatibility.
2561: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2562: p_api_version_number,

Line 2923: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

2919: BEGIN
2920: -- Standard Start of API savepoint
2921: SAVEPOINT DELETE_QUOTE_LINE_PUB;
2922:
2923: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2924:
2925: -- Standard call to check for call compatibility.
2926: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2927: p_api_version_number,

Line 3168: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

3164: IS
3165:
3166: BEGIN
3167:
3168: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
3169: ASO_QUOTE_HEADERS_PVT.Quote_Security_Check(
3170: P_Api_Version_Number => P_Api_Version_Number,
3171: P_Init_Msg_List => P_Init_Msg_List,
3172: P_User_Id => P_User_Id,

Line 3221: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

3217:
3218: -- Standard Start of API savepoint
3219: SAVEPOINT SUBMIT_QUOTE_PUB;
3220:
3221: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
3222:
3223: -- Standard call to check for call compatibility.
3224: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3225: p_api_version_number,

Line 3430: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

3426: l_api_version_number CONSTANT NUMBER := 1.0;
3427:
3428: BEGIN
3429:
3430: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
3431:
3432: -- Standard Start of API savepoint
3433: SAVEPOINT ALLOCATE_SALES_CREDITS_PUB;
3434:

Line 3659: p_value => fnd_profile.value( 'USER_ID'),

3655: l_event_key := to_char(sysdate,'MMDDYYYY HH24MISS');
3656:
3657: wf_event.AddParameterToList (
3658: p_name => 'USER_ID',
3659: p_value => fnd_profile.value( 'USER_ID'),
3660: p_parameterlist => l_list );
3661:
3662: wf_event.AddParameterToList (
3663: p_name => 'RESP_ID',

Line 3664: p_value => fnd_profile.value( 'RESP_ID'),

3660: p_parameterlist => l_list );
3661:
3662: wf_event.AddParameterToList (
3663: p_name => 'RESP_ID',
3664: p_value => fnd_profile.value( 'RESP_ID'),
3665: p_parameterlist => l_list );
3666:
3667: wf_event.AddParameterToList (
3668: p_name => 'RESP_APPL_ID',

Line 3669: p_value => fnd_profile.value( 'RESP_APPL_ID'),

3665: p_parameterlist => l_list );
3666:
3667: wf_event.AddParameterToList (
3668: p_name => 'RESP_APPL_ID',
3669: p_value => fnd_profile.value( 'RESP_APPL_ID'),
3670: p_parameterlist => l_list );
3671:
3672: wf_event.AddParameterToList (
3673: p_name => 'ORG_ID',

Line 3674: p_value => fnd_profile.value( 'ORG_ID'),

3670: p_parameterlist => l_list );
3671:
3672: wf_event.AddParameterToList (
3673: p_name => 'ORG_ID',
3674: p_value => fnd_profile.value( 'ORG_ID'),
3675: p_parameterlist => l_list );
3676:
3677: wf_event.AddParameterToList (
3678: p_name => 'DOCUMENT_ID',

Line 3715: p_value => fnd_profile.value( 'USER_ID'),

3711: l_event_key := to_char(sysdate,'MMDDYYYY HH24MISS');
3712:
3713: wf_event.AddParameterToList (
3714: p_name => 'USER_ID',
3715: p_value => fnd_profile.value( 'USER_ID'),
3716: p_parameterlist => l_list );
3717:
3718: wf_event.AddParameterToList (
3719: p_name => 'RESP_ID',

Line 3720: p_value => fnd_profile.value( 'RESP_ID'),

3716: p_parameterlist => l_list );
3717:
3718: wf_event.AddParameterToList (
3719: p_name => 'RESP_ID',
3720: p_value => fnd_profile.value( 'RESP_ID'),
3721: p_parameterlist => l_list );
3722:
3723: wf_event.AddParameterToList (
3724: p_name => 'RESP_APPL_ID',

Line 3725: p_value => fnd_profile.value( 'RESP_APPL_ID'),

3721: p_parameterlist => l_list );
3722:
3723: wf_event.AddParameterToList (
3724: p_name => 'RESP_APPL_ID',
3725: p_value => fnd_profile.value( 'RESP_APPL_ID'),
3726: p_parameterlist => l_list );
3727:
3728: wf_event.AddParameterToList (
3729: p_name => 'ORG_ID',

Line 3730: p_value => fnd_profile.value( 'ORG_ID'),

3726: p_parameterlist => l_list );
3727:
3728: wf_event.AddParameterToList (
3729: p_name => 'ORG_ID',
3730: p_value => fnd_profile.value( 'ORG_ID'),
3731: p_parameterlist => l_list );
3732:
3733: wf_event.AddParameterToList (
3734: p_name => 'DOCUMENT_ID',

Line 3876: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

3872: BEGIN
3873: -- Standard Start of API savepoint
3874: SAVEPOINT CREATE_QUOTE_PUB;
3875:
3876: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
3877:
3878: -- Standard call to check for call compatibility.
3879: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3880: p_api_version_number,

Line 4490: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

4486: BEGIN
4487: -- Standard Start of API savepoint
4488: SAVEPOINT CREATE_QUOTE_SERVICE_PUB;
4489:
4490: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
4491:
4492: -- Standard call to check for call compatibility.
4493: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4494: p_api_version_number,

Line 4883: aso_debug_pub.add('Profile Value ASO_CALCULATE_PRICE is ' ||fnd_profile.value('ASO_CALCULATE_PRICE'), 1, 'N');

4879:
4880: -- Prepare Control Record
4881: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4882: aso_debug_pub.add('ASO_QUOTE_PUB.Create_Quote_Service: Start to prepare control record');
4883: aso_debug_pub.add('Profile Value ASO_CALCULATE_PRICE is ' ||fnd_profile.value('ASO_CALCULATE_PRICE'), 1, 'N');
4884: aso_debug_pub.add('Profile Value ASO_CALCULATE_TAX is ' ||fnd_profile.value('ASO_CALCULATE_TAX'), 1, 'N');
4885: END IF;
4886:
4887: IF NVL(FND_PROFILE.VALUE('ASO_CALCULATE_PRICE'), 'A')='M' THEN

Line 4884: aso_debug_pub.add('Profile Value ASO_CALCULATE_TAX is ' ||fnd_profile.value('ASO_CALCULATE_TAX'), 1, 'N');

4880: -- Prepare Control Record
4881: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4882: aso_debug_pub.add('ASO_QUOTE_PUB.Create_Quote_Service: Start to prepare control record');
4883: aso_debug_pub.add('Profile Value ASO_CALCULATE_PRICE is ' ||fnd_profile.value('ASO_CALCULATE_PRICE'), 1, 'N');
4884: aso_debug_pub.add('Profile Value ASO_CALCULATE_TAX is ' ||fnd_profile.value('ASO_CALCULATE_TAX'), 1, 'N');
4885: END IF;
4886:
4887: IF NVL(FND_PROFILE.VALUE('ASO_CALCULATE_PRICE'), 'A')='M' THEN
4888: l_control_rec.pricing_request_type := 'ASO';

Line 4887: IF NVL(FND_PROFILE.VALUE('ASO_CALCULATE_PRICE'), 'A')='M' THEN

4883: aso_debug_pub.add('Profile Value ASO_CALCULATE_PRICE is ' ||fnd_profile.value('ASO_CALCULATE_PRICE'), 1, 'N');
4884: aso_debug_pub.add('Profile Value ASO_CALCULATE_TAX is ' ||fnd_profile.value('ASO_CALCULATE_TAX'), 1, 'N');
4885: END IF;
4886:
4887: IF NVL(FND_PROFILE.VALUE('ASO_CALCULATE_PRICE'), 'A')='M' THEN
4888: l_control_rec.pricing_request_type := 'ASO';
4889: l_control_rec.price_mode := NULL;
4890: l_control_rec.header_pricing_event := NULL;
4891: l_control_rec.calculate_freight_charge_flag := 'N';

Line 4901: IF NVL(FND_PROFILE.VALUE('ASO_CALCULATE_TAX'), 'A')='M' THEN

4897: l_control_rec.calculate_freight_charge_flag := 'Y';
4898: l_qte_header_rec.pricing_status_indicator := 'C';
4899: END IF;
4900:
4901: IF NVL(FND_PROFILE.VALUE('ASO_CALCULATE_TAX'), 'A')='M' THEN
4902: l_control_rec.calculate_tax_flag := 'N';
4903: l_qte_header_rec.tax_status_indicator := 'I';
4904: ELSE
4905: l_control_rec.calculate_tax_flag := 'Y';

Line 5152: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

5148: BEGIN
5149: -- Standard Start of API savepoint
5150: SAVEPOINT UPDATE_QUOTE_PUB;
5151:
5152: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
5153:
5154: -- Standard call to check for call compatibility.
5155: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
5156: p_api_version_number,

Line 5677: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

5673: Begin
5674:
5675: SAVEPOINT validate_model_cfg_pub;
5676:
5677: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
5678:
5679: --dbms_output.put_line('Testing in Progress');
5680: x_return_status := FND_API.G_RET_STS_SUCCESS;
5681: