DBA Data[Home] [Help]

APPS.ASO_ORDER_INT dependencies on FND_PROFILE

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

616:
617: -- Standard Start of API savepoint
618: SAVEPOINT CREATE_ORDER_PVT;
619:
620: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
621:
622: -- Standard call to check for call compatibility.
623: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
624: p_api_version_number,

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

825: BEGIN
826: -- Standard Start of API savepoint
827: SAVEPOINT UPDATE_order_PVT;
828:
829: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
830:
831: -- Standard call to check for call compatibility.
832: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
833: p_api_version_number,

Line 1746: l_split_pay_prof VARCHAR2(2) := FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT');

1742: l_ffm_content_tbl ASO_FFM_INT.FFM_CONTENT_TBL_TYPE;
1743: l_ffm_bind_tbl ASO_FFM_INT.FFM_Bind_Tbl_Type;
1744: X_Request_ID NUMBER;
1745:
1746: l_split_pay_prof VARCHAR2(2) := FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT');
1747: l_CC_Auth_Prof VARCHAR2(2) := FND_PROFILE.Value('ASO_CC_AUTHORIZATION_ENABLED');
1748: l_Enable_Risk_Mgmt_Prof VARCHAR2(2);
1749: l_CC_Auth_Failure_Prof VARCHAR2(20);
1750: l_Risk_Mgmt_Failure_Prof VARCHAR2(20);

Line 1747: l_CC_Auth_Prof VARCHAR2(2) := FND_PROFILE.Value('ASO_CC_AUTHORIZATION_ENABLED');

1743: l_ffm_bind_tbl ASO_FFM_INT.FFM_Bind_Tbl_Type;
1744: X_Request_ID NUMBER;
1745:
1746: l_split_pay_prof VARCHAR2(2) := FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT');
1747: l_CC_Auth_Prof VARCHAR2(2) := FND_PROFILE.Value('ASO_CC_AUTHORIZATION_ENABLED');
1748: l_Enable_Risk_Mgmt_Prof VARCHAR2(2);
1749: l_CC_Auth_Failure_Prof VARCHAR2(20);
1750: l_Risk_Mgmt_Failure_Prof VARCHAR2(20);
1751:

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

1786: BEGIN
1787: -- Standard Start of API savepoint
1788: SAVEPOINT CREATE_ORDER_PVT;
1789:
1790: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1791:
1792: -- Standard call to check for call compatibility.
1793: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1794: p_api_version,

Line 1865: END IF;-- FND_PROFILE.Value

1861: END IF;
1862:
1863: END IF;-- p_hd_payment
1864:
1865: END IF;-- FND_PROFILE.Value
1866: -- Validate_Payment;(-- there should be only one rec if payment_option<>'SPLIT')
1867: IF (l_split_pay_prof = 'Y') THEN
1868: IF p_header_payment_tbl.count > 1 THEN
1869: FOR i IN 1..p_header_payment_tbl.count LOOP

Line 1955: --l_cc_auth_failure_prof := NVL(FND_PROFILE.Value('ASO_CC_AUTH_FAILURE'), 'REJECT');

1951: IF l_CC_Auth_Prof = 'Y' AND P_Control_Rec.CC_By_Fax <> FND_API.G_TRUE THEN
1952:
1953: FOR x IN 1..l_Header_Payment_tbl.count LOOP
1954: IF l_Header_Payment_tbl(x).Payment_Type_Code = 'CREDIT_CARD' AND l_Header_Payment_tbl(x).trxn_extension_id IS NOT NULL THEN
1955: --l_cc_auth_failure_prof := NVL(FND_PROFILE.Value('ASO_CC_AUTH_FAILURE'), 'REJECT');
1956: l_enable_risk_mgmt_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_CC_AUTH'), 'Y');
1957:
1958: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1959: aso_debug_pub.add('Create_Order: l_enable_risk_mgmt_prof: '||l_enable_risk_mgmt_prof, 1, 'N');

Line 1956: l_enable_risk_mgmt_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_CC_AUTH'), 'Y');

1952:
1953: FOR x IN 1..l_Header_Payment_tbl.count LOOP
1954: IF l_Header_Payment_tbl(x).Payment_Type_Code = 'CREDIT_CARD' AND l_Header_Payment_tbl(x).trxn_extension_id IS NOT NULL THEN
1955: --l_cc_auth_failure_prof := NVL(FND_PROFILE.Value('ASO_CC_AUTH_FAILURE'), 'REJECT');
1956: l_enable_risk_mgmt_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_CC_AUTH'), 'Y');
1957:
1958: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1959: aso_debug_pub.add('Create_Order: l_enable_risk_mgmt_prof: '||l_enable_risk_mgmt_prof, 1, 'N');
1960: END IF;

Line 1971: --l_risk_mgmt_failure_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_FAILURE'), 'REJECT');

1967: aso_debug_pub.add('Create_Order: l_request_tbl(i).param2: '|| l_request_tbl(i).param2, 1, 'N');
1968: END IF;
1969:
1970: IF l_enable_risk_mgmt_prof = 'Y' THEN
1971: --l_risk_mgmt_failure_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_FAILURE'), 'REJECT');
1972:
1973: l_request_tbl(i).param1 := 'Y';
1974: --l_request_tbl(i).param3 := l_risk_mgmt_failure_prof;
1975: ELSE

Line 1984: --l_cc_auth_failure_prof := NVL(FND_PROFILE.Value('ASO_CC_AUTH_FAILURE'), 'REJECT');

1980: END LOOP; -- l_Header_Payment_tbl
1981:
1982: FOR x IN 1..l_Line_Payment_tbl.count LOOP
1983: IF l_Line_Payment_tbl(x).Payment_Type_Code = 'CREDIT_CARD' AND l_Line_Payment_tbl(x).trxn_extension_id IS NOT NULL THEN
1984: --l_cc_auth_failure_prof := NVL(FND_PROFILE.Value('ASO_CC_AUTH_FAILURE'), 'REJECT');
1985: l_enable_risk_mgmt_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_CC_AUTH'), 'Y');
1986:
1987: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1988: aso_debug_pub.add('Create_Order: l_enable_risk_mgmt_prof: '||l_enable_risk_mgmt_prof, 1, 'N');

Line 1985: l_enable_risk_mgmt_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_CC_AUTH'), 'Y');

1981:
1982: FOR x IN 1..l_Line_Payment_tbl.count LOOP
1983: IF l_Line_Payment_tbl(x).Payment_Type_Code = 'CREDIT_CARD' AND l_Line_Payment_tbl(x).trxn_extension_id IS NOT NULL THEN
1984: --l_cc_auth_failure_prof := NVL(FND_PROFILE.Value('ASO_CC_AUTH_FAILURE'), 'REJECT');
1985: l_enable_risk_mgmt_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_CC_AUTH'), 'Y');
1986:
1987: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1988: aso_debug_pub.add('Create_Order: l_enable_risk_mgmt_prof: '||l_enable_risk_mgmt_prof, 1, 'N');
1989: END IF;

Line 2001: --l_risk_mgmt_failure_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_FAILURE'), 'REJECT');

1997: aso_debug_pub.add('Create_Order: l_request_tbl(i).param2: '||l_request_tbl(i).param2, 1, 'N');
1998: END IF;
1999:
2000: IF l_enable_risk_mgmt_prof = 'Y' THEN
2001: --l_risk_mgmt_failure_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_FAILURE'), 'REJECT');
2002:
2003: l_request_tbl(i).param1 := 'Y';
2004: --l_request_tbl(i).param3 := l_risk_mgmt_failure_prof;
2005: ELSE

Line 2548: l_split_pay_prof VARCHAR2(2) := FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT');

2544: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2545: lx_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2546: lx_request_tbl OE_Order_PUB.Request_Tbl_Type;
2547:
2548: l_split_pay_prof VARCHAR2(2) := FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT');
2549: l_CC_Auth_Prof VARCHAR2(2) := FND_PROFILE.Value('ASO_CC_AUTHORIZATION_ENABLED');
2550: l_Enable_Risk_Mgmt_Prof VARCHAR2(2);
2551: l_CC_Auth_Failure_Prof VARCHAR2(20);
2552: l_Risk_Mgmt_Failure_Prof VARCHAR2(20);

Line 2549: l_CC_Auth_Prof VARCHAR2(2) := FND_PROFILE.Value('ASO_CC_AUTHORIZATION_ENABLED');

2545: lx_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2546: lx_request_tbl OE_Order_PUB.Request_Tbl_Type;
2547:
2548: l_split_pay_prof VARCHAR2(2) := FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT');
2549: l_CC_Auth_Prof VARCHAR2(2) := FND_PROFILE.Value('ASO_CC_AUTHORIZATION_ENABLED');
2550: l_Enable_Risk_Mgmt_Prof VARCHAR2(2);
2551: l_CC_Auth_Failure_Prof VARCHAR2(20);
2552: l_Risk_Mgmt_Failure_Prof VARCHAR2(20);
2553:

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

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

Line 2645: END IF;-- FND_PROFILE.Value

2641: END IF;
2642:
2643: END IF;-- p_hd_payment
2644:
2645: END IF;-- FND_PROFILE.Value
2646: IF (l_split_pay_prof = 'Y') THEN
2647: IF p_header_payment_tbl.count > 1 THEN
2648: FOR i IN 1..p_header_payment_tbl.count LOOP
2649: IF p_header_payment_tbl(i).payment_option <> 'SPLIT' THEN

Line 2734: --l_cc_auth_failure_prof := NVL(FND_PROFILE.Value('ASO_CC_AUTH_FAILURE'), 'REJECT');

2730: IF l_CC_Auth_Prof = 'Y' AND P_Control_Rec.CC_By_Fax <> FND_API.G_TRUE THEN
2731:
2732: FOR x IN 1..l_Header_Payment_tbl.count LOOP
2733: IF l_Header_Payment_tbl(x).Payment_Type_Code = 'CREDIT_CARD' AND l_Header_Payment_tbl(x).trxn_extension_id IS NOT NULL THEN
2734: --l_cc_auth_failure_prof := NVL(FND_PROFILE.Value('ASO_CC_AUTH_FAILURE'), 'REJECT');
2735: l_enable_risk_mgmt_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_CC_AUTH'), 'Y');
2736:
2737: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2738: aso_debug_pub.add('Create_Order: l_enable_risk_mgmt_prof: '||l_enable_risk_mgmt_prof, 1, 'N');

Line 2735: l_enable_risk_mgmt_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_CC_AUTH'), 'Y');

2731:
2732: FOR x IN 1..l_Header_Payment_tbl.count LOOP
2733: IF l_Header_Payment_tbl(x).Payment_Type_Code = 'CREDIT_CARD' AND l_Header_Payment_tbl(x).trxn_extension_id IS NOT NULL THEN
2734: --l_cc_auth_failure_prof := NVL(FND_PROFILE.Value('ASO_CC_AUTH_FAILURE'), 'REJECT');
2735: l_enable_risk_mgmt_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_CC_AUTH'), 'Y');
2736:
2737: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2738: aso_debug_pub.add('Create_Order: l_enable_risk_mgmt_prof: '||l_enable_risk_mgmt_prof, 1, 'N');
2739: END IF;

Line 2750: --l_risk_mgmt_failure_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_FAILURE'), 'REJECT');

2746: aso_debug_pub.add('Create_Order: l_request_tbl(i).param2: '|| l_request_tbl(i).param2, 1, 'N');
2747: END IF;
2748:
2749: IF l_enable_risk_mgmt_prof = 'Y' THEN
2750: --l_risk_mgmt_failure_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_FAILURE'), 'REJECT');
2751: l_request_tbl(i).param1 := 'Y';
2752: --l_request_tbl(i).param3 := l_risk_mgmt_failure_prof;
2753: ELSE
2754: l_request_tbl(i).param1 := 'N';

Line 2762: --l_cc_auth_failure_prof := NVL(FND_PROFILE.Value('ASO_CC_AUTH_FAILURE'), 'REJECT');

2758: END LOOP; -- l_Header_Payment_tbl
2759:
2760: FOR x IN 1..l_Line_Payment_tbl.count LOOP
2761: IF l_Line_Payment_tbl(x).Payment_Type_Code = 'CREDIT_CARD' AND l_Line_Payment_tbl(x).trxn_extension_id IS NOT NULL THEN
2762: --l_cc_auth_failure_prof := NVL(FND_PROFILE.Value('ASO_CC_AUTH_FAILURE'), 'REJECT');
2763: l_enable_risk_mgmt_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_CC_AUTH'), 'Y');
2764:
2765: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2766: aso_debug_pub.add('Create_Order: l_enable_risk_mgmt_prof: '||l_enable_risk_mgmt_prof, 1, 'N');

Line 2763: l_enable_risk_mgmt_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_CC_AUTH'), 'Y');

2759:
2760: FOR x IN 1..l_Line_Payment_tbl.count LOOP
2761: IF l_Line_Payment_tbl(x).Payment_Type_Code = 'CREDIT_CARD' AND l_Line_Payment_tbl(x).trxn_extension_id IS NOT NULL THEN
2762: --l_cc_auth_failure_prof := NVL(FND_PROFILE.Value('ASO_CC_AUTH_FAILURE'), 'REJECT');
2763: l_enable_risk_mgmt_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_CC_AUTH'), 'Y');
2764:
2765: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2766: aso_debug_pub.add('Create_Order: l_enable_risk_mgmt_prof: '||l_enable_risk_mgmt_prof, 1, 'N');
2767: END IF;

Line 2779: --l_risk_mgmt_failure_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_FAILURE'), 'REJECT');

2775: aso_debug_pub.add('Create_Order: l_request_tbl(i).param2: '|| l_request_tbl(i).param2, 1, 'N');
2776: END IF;
2777:
2778: IF l_enable_risk_mgmt_prof = 'Y' THEN
2779: --l_risk_mgmt_failure_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_FAILURE'), 'REJECT');
2780: l_request_tbl(i).param1 := 'Y';
2781: --l_request_tbl(i).param3 := l_risk_mgmt_failure_prof;
2782: ELSE
2783: l_request_tbl(i).param1 := 'N';

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

3242: IS
3243: l_total number;
3244: begin
3245:
3246: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
3247:
3248: l_total := OE_Totals_GRP.GET_Order_Total (
3249: P_HEADER_ID ,
3250: P_LINE_ID,

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

3285: l_party_type VARCHAR2(30);
3286: l_site_use_id number;
3287: begin
3288:
3289: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
3290:
3291: x_return_status := FND_API.G_RET_STS_SUCCESS;
3292:
3293: OPEN relationship_cur;

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

3352: l_party_type VARCHAR2(30);
3353: l_cust_account_role_id number;
3354: begin
3355:
3356: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
3357:
3358: x_return_status := FND_API.G_RET_STS_SUCCESS;
3359:
3360: OPEN relationship_cur;