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 1761: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

1757:
1758: -- Standard Start of API savepoint
1759: SAVEPOINT CREATE_ORDER_PVT;
1760:
1761: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1762:
1763: -- Standard call to check for call compatibility.
1764: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1765: p_api_version,

Line 1836: END IF;-- FND_PROFILE.Value

1832: END IF;
1833:
1834: END IF;-- p_hd_payment
1835:
1836: END IF;-- FND_PROFILE.Value
1837: -- Validate_Payment;(-- there should be only one rec if payment_option<>'SPLIT')
1838: IF (l_split_pay_prof = 'Y') THEN
1839: IF p_header_payment_tbl.count > 1 THEN
1840: FOR i IN 1..p_header_payment_tbl.count LOOP

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

1922: IF l_CC_Auth_Prof = 'Y' AND P_Control_Rec.CC_By_Fax <> FND_API.G_TRUE THEN
1923:
1924: FOR x IN 1..l_Header_Payment_tbl.count LOOP
1925: IF l_Header_Payment_tbl(x).Payment_Type_Code = 'CREDIT_CARD' AND l_Header_Payment_tbl(x).trxn_extension_id IS NOT NULL THEN
1926: --l_cc_auth_failure_prof := NVL(FND_PROFILE.Value('ASO_CC_AUTH_FAILURE'), 'REJECT');
1927: l_enable_risk_mgmt_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_CC_AUTH'), 'Y');
1928:
1929: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1930: aso_debug_pub.add('Create_Order: l_enable_risk_mgmt_prof: '||l_enable_risk_mgmt_prof, 1, 'N');

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

1923:
1924: FOR x IN 1..l_Header_Payment_tbl.count LOOP
1925: IF l_Header_Payment_tbl(x).Payment_Type_Code = 'CREDIT_CARD' AND l_Header_Payment_tbl(x).trxn_extension_id IS NOT NULL THEN
1926: --l_cc_auth_failure_prof := NVL(FND_PROFILE.Value('ASO_CC_AUTH_FAILURE'), 'REJECT');
1927: l_enable_risk_mgmt_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_CC_AUTH'), 'Y');
1928:
1929: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1930: aso_debug_pub.add('Create_Order: l_enable_risk_mgmt_prof: '||l_enable_risk_mgmt_prof, 1, 'N');
1931: END IF;

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

1938: aso_debug_pub.add('Create_Order: l_request_tbl(i).param2: '|| l_request_tbl(i).param2, 1, 'N');
1939: END IF;
1940:
1941: IF l_enable_risk_mgmt_prof = 'Y' THEN
1942: --l_risk_mgmt_failure_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_FAILURE'), 'REJECT');
1943:
1944: l_request_tbl(i).param1 := 'Y';
1945: --l_request_tbl(i).param3 := l_risk_mgmt_failure_prof;
1946: ELSE

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

1951: END LOOP; -- l_Header_Payment_tbl
1952:
1953: FOR x IN 1..l_Line_Payment_tbl.count LOOP
1954: IF l_Line_Payment_tbl(x).Payment_Type_Code = 'CREDIT_CARD' AND l_Line_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_Line_Payment_tbl.count LOOP
1954: IF l_Line_Payment_tbl(x).Payment_Type_Code = 'CREDIT_CARD' AND l_Line_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 1972: --l_risk_mgmt_failure_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_FAILURE'), 'REJECT');

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

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

2380: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2381: lx_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2382: lx_request_tbl OE_Order_PUB.Request_Tbl_Type;
2383:
2384: l_split_pay_prof VARCHAR2(2) := FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT');
2385: l_CC_Auth_Prof VARCHAR2(2) := FND_PROFILE.Value('ASO_CC_AUTHORIZATION_ENABLED');
2386: l_Enable_Risk_Mgmt_Prof VARCHAR2(2);
2387: l_CC_Auth_Failure_Prof VARCHAR2(20);
2388: l_Risk_Mgmt_Failure_Prof VARCHAR2(20);

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

2381: lx_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2382: lx_request_tbl OE_Order_PUB.Request_Tbl_Type;
2383:
2384: l_split_pay_prof VARCHAR2(2) := FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT');
2385: l_CC_Auth_Prof VARCHAR2(2) := FND_PROFILE.Value('ASO_CC_AUTHORIZATION_ENABLED');
2386: l_Enable_Risk_Mgmt_Prof VARCHAR2(2);
2387: l_CC_Auth_Failure_Prof VARCHAR2(20);
2388: l_Risk_Mgmt_Failure_Prof VARCHAR2(20);
2389:

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

2391: BEGIN
2392: -- Standard Start of API savepoint
2393: SAVEPOINT UPDATE_order_PVT;
2394:
2395: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2396:
2397: -- Standard call to check for call compatibility.
2398: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2399: p_api_version ,

Line 2481: END IF;-- FND_PROFILE.Value

2477: END IF;
2478:
2479: END IF;-- p_hd_payment
2480:
2481: END IF;-- FND_PROFILE.Value
2482: IF (l_split_pay_prof = 'Y') THEN
2483: IF p_header_payment_tbl.count > 1 THEN
2484: FOR i IN 1..p_header_payment_tbl.count LOOP
2485: IF p_header_payment_tbl(i).payment_option <> 'SPLIT' THEN

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

2564: IF l_CC_Auth_Prof = 'Y' AND P_Control_Rec.CC_By_Fax <> FND_API.G_TRUE THEN
2565:
2566: FOR x IN 1..l_Header_Payment_tbl.count LOOP
2567: IF l_Header_Payment_tbl(x).Payment_Type_Code = 'CREDIT_CARD' AND l_Header_Payment_tbl(x).trxn_extension_id IS NOT NULL THEN
2568: --l_cc_auth_failure_prof := NVL(FND_PROFILE.Value('ASO_CC_AUTH_FAILURE'), 'REJECT');
2569: l_enable_risk_mgmt_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_CC_AUTH'), 'Y');
2570:
2571: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2572: aso_debug_pub.add('Create_Order: l_enable_risk_mgmt_prof: '||l_enable_risk_mgmt_prof, 1, 'N');

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

2565:
2566: FOR x IN 1..l_Header_Payment_tbl.count LOOP
2567: IF l_Header_Payment_tbl(x).Payment_Type_Code = 'CREDIT_CARD' AND l_Header_Payment_tbl(x).trxn_extension_id IS NOT NULL THEN
2568: --l_cc_auth_failure_prof := NVL(FND_PROFILE.Value('ASO_CC_AUTH_FAILURE'), 'REJECT');
2569: l_enable_risk_mgmt_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_CC_AUTH'), 'Y');
2570:
2571: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2572: aso_debug_pub.add('Create_Order: l_enable_risk_mgmt_prof: '||l_enable_risk_mgmt_prof, 1, 'N');
2573: END IF;

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

2580: aso_debug_pub.add('Create_Order: l_request_tbl(i).param2: '|| l_request_tbl(i).param2, 1, 'N');
2581: END IF;
2582:
2583: IF l_enable_risk_mgmt_prof = 'Y' THEN
2584: --l_risk_mgmt_failure_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_FAILURE'), 'REJECT');
2585: l_request_tbl(i).param1 := 'Y';
2586: --l_request_tbl(i).param3 := l_risk_mgmt_failure_prof;
2587: ELSE
2588: l_request_tbl(i).param1 := 'N';

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

2592: END LOOP; -- l_Header_Payment_tbl
2593:
2594: FOR x IN 1..l_Line_Payment_tbl.count LOOP
2595: IF l_Line_Payment_tbl(x).Payment_Type_Code = 'CREDIT_CARD' AND l_Line_Payment_tbl(x).trxn_extension_id IS NOT NULL THEN
2596: --l_cc_auth_failure_prof := NVL(FND_PROFILE.Value('ASO_CC_AUTH_FAILURE'), 'REJECT');
2597: l_enable_risk_mgmt_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_CC_AUTH'), 'Y');
2598:
2599: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2600: aso_debug_pub.add('Create_Order: l_enable_risk_mgmt_prof: '||l_enable_risk_mgmt_prof, 1, 'N');

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

2593:
2594: FOR x IN 1..l_Line_Payment_tbl.count LOOP
2595: IF l_Line_Payment_tbl(x).Payment_Type_Code = 'CREDIT_CARD' AND l_Line_Payment_tbl(x).trxn_extension_id IS NOT NULL THEN
2596: --l_cc_auth_failure_prof := NVL(FND_PROFILE.Value('ASO_CC_AUTH_FAILURE'), 'REJECT');
2597: l_enable_risk_mgmt_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_CC_AUTH'), 'Y');
2598:
2599: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2600: aso_debug_pub.add('Create_Order: l_enable_risk_mgmt_prof: '||l_enable_risk_mgmt_prof, 1, 'N');
2601: END IF;

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

2609: aso_debug_pub.add('Create_Order: l_request_tbl(i).param2: '|| l_request_tbl(i).param2, 1, 'N');
2610: END IF;
2611:
2612: IF l_enable_risk_mgmt_prof = 'Y' THEN
2613: --l_risk_mgmt_failure_prof := NVL(FND_PROFILE.Value('ASO_RISK_MANAGE_FAILURE'), 'REJECT');
2614: l_request_tbl(i).param1 := 'Y';
2615: --l_request_tbl(i).param3 := l_risk_mgmt_failure_prof;
2616: ELSE
2617: l_request_tbl(i).param1 := 'N';

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

3076: IS
3077: l_total number;
3078: begin
3079:
3080: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
3081:
3082: l_total := OE_Totals_GRP.GET_Order_Total (
3083: P_HEADER_ID ,
3084: P_LINE_ID,

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

3119: l_party_type VARCHAR2(30);
3120: l_site_use_id number;
3121: begin
3122:
3123: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
3124:
3125: x_return_status := FND_API.G_RET_STS_SUCCESS;
3126:
3127: OPEN relationship_cur;

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

3186: l_party_type VARCHAR2(30);
3187: l_cust_account_role_id number;
3188: begin
3189:
3190: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
3191:
3192: x_return_status := FND_API.G_RET_STS_SUCCESS;
3193:
3194: OPEN relationship_cur;