DBA Data[Home] [Help]

APPS.ASO_COPY_QUOTE_PVT dependencies on FND_PROFILE

Line 240: IF ( NVL ( FND_PROFILE.VALUE ('ASO_AUTO_NUMBERING' ), 'Y' ) = 'Y' ) THEN

236: IF ( P_Copy_Quote_Control_Rec.New_Version = FND_API.G_FALSE ) THEN
237: IF ( P_Copy_Quote_Header_Rec.Quote_Number IS NULL
238: OR P_Copy_Quote_Header_Rec.Quote_Number = FND_API.G_MISS_NUM
239: ) THEN
240: IF ( NVL ( FND_PROFILE.VALUE ('ASO_AUTO_NUMBERING' ), 'Y' ) = 'Y' ) THEN
241: IF aso_debug_pub.g_debug_flag = 'Y' THEN
242: aso_debug_pub.ADD ( 'Copy_Quote - AUTO_NUMBERING is Y ' , 1 , 'N' );
243: END IF;
244:

Line 378: OPEN c_qte_status_id ( fnd_profile.VALUE ('ASO_DEFAULT_STATUS_CODE' ) );

374: WHERE Quote_Header_Id = l_qte_header_id;
375:
376: END IF; -- p_new_version
377:
378: OPEN c_qte_status_id ( fnd_profile.VALUE ('ASO_DEFAULT_STATUS_CODE' ) );
379: FETCH c_qte_status_id INTO l_qte_header_rec.quote_status_id;
380:
381: IF c_qte_status_id%NOTFOUND THEN
382: x_return_status := FND_API.G_RET_STS_ERROR;

Line 670: IF NVL(FND_PROFILE.Value('OKC_ENABLE_SALES_CONTRACTS'),'N') = 'Y'

666: END IF; -- Header_pricing_event/Tax_flag = TRUE
667:
668: -- hyang new okc
669:
670: IF NVL(FND_PROFILE.Value('OKC_ENABLE_SALES_CONTRACTS'),'N') = 'Y'
671: THEN
672:
673: IF aso_debug_pub.g_debug_flag = 'Y' THEN
674: aso_debug_pub.add(

Line 923: l_sales_team_prof VARCHAR2(30) := FND_PROFILE.value('ASO_AUTO_TEAM_ASSIGN');

919: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
920:
921: l_old_qte_num NUMBER;
922: l_sequence NUMBER := null;
923: l_sales_team_prof VARCHAR2(30) := FND_PROFILE.value('ASO_AUTO_TEAM_ASSIGN');
924:
925: --BC4J Fix
926: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
927:

Line 1443: aso_debug_pub.ADD ( 'Copy_Quote: value of ASO_API_ENABLE_SECURITY: ' || FND_PROFILE.VALUE ('ASO_API_ENABLE_SECURITY' ) , 1 , 'Y' );

1439: IF P_Copy_Quote_Control_Rec.New_Version = FND_API.G_FALSE THEN
1440: -- security changes
1441:
1442: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1443: aso_debug_pub.ADD ( 'Copy_Quote: value of ASO_API_ENABLE_SECURITY: ' || FND_PROFILE.VALUE ('ASO_API_ENABLE_SECURITY' ) , 1 , 'Y' );
1444: END IF;
1445:
1446: l_qte_header_rec.batch_price_flag := FND_API.G_FALSE;
1447:

Line 1448: IF NVL ( FND_PROFILE.VALUE ('ASO_API_ENABLE_SECURITY' ), 'N' ) = 'Y' THEN

1444: END IF;
1445:
1446: l_qte_header_rec.batch_price_flag := FND_API.G_FALSE;
1447:
1448: IF NVL ( FND_PROFILE.VALUE ('ASO_API_ENABLE_SECURITY' ), 'N' ) = 'Y' THEN
1449:
1450: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1451: aso_debug_pub.ADD ( 'Copy_Quote: Sales_Team: l_sales_team_prof: ' || l_sales_team_prof , 1 , 'N' );
1452: END IF;

Line 1969: l_appl_param_rec.calling_application_id := nvl(FND_PROFILE.value('JTF_PROFILE_DEFAULT_APPLICATION'),697);

1965:
1966:
1967: /*
1968: -- Validating if the item is a container item
1969: l_appl_param_rec.calling_application_id := nvl(FND_PROFILE.value('JTF_PROFILE_DEFAULT_APPLICATION'),697);
1970:
1971: cz_network_api_pub.is_container(p_api_version => 1.0
1972: ,p_inventory_item_id => l_qte_line_rec.inventory_item_id
1973: ,p_organization_id => l_qte_line_rec.organization_id

Line 3870: := FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_CAL' );

3866: AND Period_Set_Name = l_Def_Cal
3867: AND SYSDATE BETWEEN Start_Date AND End_Date;
3868:
3869: l_Default_Cal_Prof VARCHAR2 ( 15 )
3870: := FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_CAL' );
3871: l_Default_Per_Prof VARCHAR2 ( 15 )
3872: := FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_PERIOD' );
3873: l_qte_duration_prof NUMBER
3874: := FND_PROFILE.VALUE ('ASO_QUOTE_DURATION' );

Line 3872: := FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_PERIOD' );

3868:
3869: l_Default_Cal_Prof VARCHAR2 ( 15 )
3870: := FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_CAL' );
3871: l_Default_Per_Prof VARCHAR2 ( 15 )
3872: := FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_PERIOD' );
3873: l_qte_duration_prof NUMBER
3874: := FND_PROFILE.VALUE ('ASO_QUOTE_DURATION' );
3875:
3876: BEGIN

Line 3874: := FND_PROFILE.VALUE ('ASO_QUOTE_DURATION' );

3870: := FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_CAL' );
3871: l_Default_Per_Prof VARCHAR2 ( 15 )
3872: := FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_PERIOD' );
3873: l_qte_duration_prof NUMBER
3874: := FND_PROFILE.VALUE ('ASO_QUOTE_DURATION' );
3875:
3876: BEGIN
3877:
3878: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

Line 3896: X_Quote_Exp_Date := sysdate + NVL(FND_PROFILE.value('ASO_QUOTE_DURATION'), 30);

3892: X_Quote_Exp_Date := SYSDATE + l_qte_duration_prof;
3893: ELSE
3894: /* If profile ASO_QUOTE_DURATION is null, then exp date is sysdate + 30
3895: see bug 3704719 for more detaisl */
3896: X_Quote_Exp_Date := sysdate + NVL(FND_PROFILE.value('ASO_QUOTE_DURATION'), 30);
3897: END IF;
3898:
3899: END IF;
3900:

Line 3910: X_Quote_Exp_Date := sysdate + NVL(FND_PROFILE.value('ASO_QUOTE_DURATION'), 30);

3906: X_Quote_Exp_Date := SYSDATE + l_qte_duration_prof;
3907: ELSE
3908: /* If profile ASO_QUOTE_DURATION is null, then exp date is sysdate + 30
3909: see bug 3704719 for more detaisl */
3910: X_Quote_Exp_Date := sysdate + NVL(FND_PROFILE.value('ASO_QUOTE_DURATION'), 30);
3911: END IF;
3912:
3913: END IF;
3914:

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

5676: SELECT ASO_PAYMENTS_S.nextval FROM sys.dual;
5677:
5678: begin
5679: SAVEPOINT COPY_PAYMENT_ROW_PVT;
5680: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
5681:
5682: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5683: aso_debug_pub.add('Begin copy_payment_row ', 1, 'Y');
5684: aso_debug_pub.add('l_payment_rec.Quote_Header_Id: ' || l_payment_rec.Quote_Header_Id, 1, 'Y');