eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_ORDER_INT dependencies on ASO_DEBUG_PUB

Line 171: IF aso_debug_pub.g_debug_flag = 'Y' THEN

167: );
168:
169: IF l_msg_count > 0 THEN
170:
171: IF aso_debug_pub.g_debug_flag = 'Y' THEN
172: aso_debug_pub.add('before updating the processing messages table',1,'N');
173: END IF;
174:
175: FOR k IN 1 .. l_msg_count LOOP

Line 172: aso_debug_pub.add('before updating the processing messages table',1,'N');

168:
169: IF l_msg_count > 0 THEN
170:
171: IF aso_debug_pub.g_debug_flag = 'Y' THEN
172: aso_debug_pub.add('before updating the processing messages table',1,'N');
173: END IF;
174:
175: FOR k IN 1 .. l_msg_count LOOP
176:

Line 179: IF aso_debug_pub.g_debug_flag = 'Y' THEN

175: FOR k IN 1 .. l_msg_count LOOP
176:
177: i:=1;
178:
179: IF aso_debug_pub.g_debug_flag = 'Y' THEN
180: aso_debug_pub.add('before calling oe_msg_pub.get',1,'N');
181: END IF;
182: oe_msg_pub.get (
183: p_msg_index => k

Line 180: aso_debug_pub.add('before calling oe_msg_pub.get',1,'N');

176:
177: i:=1;
178:
179: IF aso_debug_pub.g_debug_flag = 'Y' THEN
180: aso_debug_pub.add('before calling oe_msg_pub.get',1,'N');
181: END IF;
182: oe_msg_pub.get (
183: p_msg_index => k
184: ,p_encoded => FND_API.G_FALSE

Line 191: IF aso_debug_pub.g_debug_flag = 'Y' THEN

187:
188: IF (upper(l_msg_data) <> 'ORDER HAS BEEN BOOKED.') THEN -- bug# 1935468
189:
190: BEGIN
191: IF aso_debug_pub.g_debug_flag = 'Y' THEN
192: aso_debug_pub.add('before calling get_msg_context l_msg_index:'||l_msg_index,1,'N');
193: END IF;
194: oe_msg_pub.get_msg_context (
195: p_msg_index => l_msg_index

Line 192: aso_debug_pub.add('before calling get_msg_context l_msg_index:'||l_msg_index,1,'N');

188: IF (upper(l_msg_data) <> 'ORDER HAS BEEN BOOKED.') THEN -- bug# 1935468
189:
190: BEGIN
191: IF aso_debug_pub.g_debug_flag = 'Y' THEN
192: aso_debug_pub.add('before calling get_msg_context l_msg_index:'||l_msg_index,1,'N');
193: END IF;
194: oe_msg_pub.get_msg_context (
195: p_msg_index => l_msg_index
196: ,x_entity_code => l_msg_entity_code

Line 218: IF aso_debug_pub.g_debug_flag = 'Y' THEN

214: );
215:
216: EXCEPTION
217: WHEN others THEN
218: IF aso_debug_pub.g_debug_flag = 'Y' THEN
219: aso_debug_pub.add('Unexpected error in get msg : '||sqlerrm,1,'N');
220: aso_debug_pub.add('Ignoring above message',1,'N');
221: END IF;
222: l_error_index_flag := 'Y';

Line 219: aso_debug_pub.add('Unexpected error in get msg : '||sqlerrm,1,'N');

215:
216: EXCEPTION
217: WHEN others THEN
218: IF aso_debug_pub.g_debug_flag = 'Y' THEN
219: aso_debug_pub.add('Unexpected error in get msg : '||sqlerrm,1,'N');
220: aso_debug_pub.add('Ignoring above message',1,'N');
221: END IF;
222: l_error_index_flag := 'Y';
223: END;

Line 220: aso_debug_pub.add('Ignoring above message',1,'N');

216: EXCEPTION
217: WHEN others THEN
218: IF aso_debug_pub.g_debug_flag = 'Y' THEN
219: aso_debug_pub.add('Unexpected error in get msg : '||sqlerrm,1,'N');
220: aso_debug_pub.add('Ignoring above message',1,'N');
221: END IF;
222: l_error_index_flag := 'Y';
223: END;
224:

Line 228: IF aso_debug_pub.g_debug_flag = 'Y' THEN

224:
225: IF l_error_index_flag = 'Y' THEN
226: EXIT;
227: END IF;
228: IF aso_debug_pub.g_debug_flag = 'Y' THEN
229: aso_debug_pub.add('after calling get_msg_context',1,'N');
230: END IF;
231:
232: IF oe_msg_pub.g_msg_tbl(l_msg_index).message_text IS NULL THEN

Line 229: aso_debug_pub.add('after calling get_msg_context',1,'N');

225: IF l_error_index_flag = 'Y' THEN
226: EXIT;
227: END IF;
228: IF aso_debug_pub.g_debug_flag = 'Y' THEN
229: aso_debug_pub.add('after calling get_msg_context',1,'N');
230: END IF;
231:
232: IF oe_msg_pub.g_msg_tbl(l_msg_index).message_text IS NULL THEN
233: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 233: IF aso_debug_pub.g_debug_flag = 'Y' THEN

229: aso_debug_pub.add('after calling get_msg_context',1,'N');
230: END IF;
231:
232: IF oe_msg_pub.g_msg_tbl(l_msg_index).message_text IS NULL THEN
233: IF aso_debug_pub.g_debug_flag = 'Y' THEN
234: aso_debug_pub.add('In index.message_text is null',1,'N');
235: END IF;
236: x_msg_data := oe_msg_pub.get(l_msg_index, 'F');
237: END IF;

Line 234: aso_debug_pub.add('In index.message_text is null',1,'N');

230: END IF;
231:
232: IF oe_msg_pub.g_msg_tbl(l_msg_index).message_text IS NULL THEN
233: IF aso_debug_pub.g_debug_flag = 'Y' THEN
234: aso_debug_pub.add('In index.message_text is null',1,'N');
235: END IF;
236: x_msg_data := oe_msg_pub.get(l_msg_index, 'F');
237: END IF;
238:

Line 239: IF aso_debug_pub.g_debug_flag = 'Y' THEN

235: END IF;
236: x_msg_data := oe_msg_pub.get(l_msg_index, 'F');
237: END IF;
238:
239: IF aso_debug_pub.g_debug_flag = 'Y' THEN
240: aso_debug_pub.add('l_msg_orig_sys_line_ref'||l_msg_orig_sys_line_ref,1,'N');
241: END IF;
242: IF l_msg_orig_sys_line_ref IS NOT NULL AND l_msg_orig_sys_line_ref <> FND_API.G_MISS_CHAR THEN
243: l_msg_context := 'Error in Line: '||rtrim(l_msg_orig_sys_line_ref)||' :';

Line 240: aso_debug_pub.add('l_msg_orig_sys_line_ref'||l_msg_orig_sys_line_ref,1,'N');

236: x_msg_data := oe_msg_pub.get(l_msg_index, 'F');
237: END IF;
238:
239: IF aso_debug_pub.g_debug_flag = 'Y' THEN
240: aso_debug_pub.add('l_msg_orig_sys_line_ref'||l_msg_orig_sys_line_ref,1,'N');
241: END IF;
242: IF l_msg_orig_sys_line_ref IS NOT NULL AND l_msg_orig_sys_line_ref <> FND_API.G_MISS_CHAR THEN
243: l_msg_context := 'Error in Line: '||rtrim(l_msg_orig_sys_line_ref)||' :';
244: END IF;

Line 248: IF aso_debug_pub.g_debug_flag = 'Y' THEN

244: END IF;
245:
246: x_msg_data := l_msg_context||l_msg_data;
247:
248: IF aso_debug_pub.g_debug_flag = 'Y' THEN
249: aso_debug_pub.add(x_msg_data,1,'N');
250: END IF;
251:
252: l_len_sqlerrm := Length(x_msg_data) ;

Line 249: aso_debug_pub.add(x_msg_data,1,'N');

245:
246: x_msg_data := l_msg_context||l_msg_data;
247:
248: IF aso_debug_pub.g_debug_flag = 'Y' THEN
249: aso_debug_pub.add(x_msg_data,1,'N');
250: END IF;
251:
252: l_len_sqlerrm := Length(x_msg_data) ;
253: WHILE l_len_sqlerrm >= i LOOP

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 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 1831: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1827: FND_MSG_PUB.ADD;
1828: END IF;
1829: RAISE FND_API.G_EXC_ERROR;
1830: END IF;
1831: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1832: aso_debug_pub.add('Create_Order: Begin ', 1, 'N');
1833: END IF;
1834: -- change the org to whatever is stored in the org id column
1835: IF p_qte_rec.org_id is not NULL

Line 1832: aso_debug_pub.add('Create_Order: Begin ', 1, 'N');

1828: END IF;
1829: RAISE FND_API.G_EXC_ERROR;
1830: END IF;
1831: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1832: aso_debug_pub.add('Create_Order: Begin ', 1, 'N');
1833: END IF;
1834: -- change the org to whatever is stored in the org id column
1835: IF p_qte_rec.org_id is not NULL
1836: AND p_qte_rec.org_id <> FND_API.G_MISS_NUM THEN

Line 1843: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1839: MO_GLOBAL.set_policy_context('S', p_qte_rec.org_id) ; --New Code Yogeshwar (MOAC)
1840:
1841: END IF;
1842:
1843: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1844: aso_debug_pub.add('l_split_pay_prof: '||l_split_pay_prof,1,'N');
1845: END IF;
1846:
1847: IF (l_split_pay_prof = 'N') THEN

Line 1844: aso_debug_pub.add('l_split_pay_prof: '||l_split_pay_prof,1,'N');

1840:
1841: END IF;
1842:
1843: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1844: aso_debug_pub.add('l_split_pay_prof: '||l_split_pay_prof,1,'N');
1845: END IF;
1846:
1847: IF (l_split_pay_prof = 'N') THEN
1848: IF p_header_payment_tbl.count > 1 THEN

Line 1881: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1877: END LOOP;
1878: END IF;
1879: END IF;
1880:
1881: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1882: aso_debug_pub.add('Create_Order: Before MAP_QUOTE_ORDER_INT.Map_Quote_to_Order : ', 1, 'N');
1883: END IF;
1884: ASO_MAP_QUOTE_ORDER_INT.Map_Quote_to_order(
1885: p_operation => 'CREATE' ,

Line 1882: aso_debug_pub.add('Create_Order: Before MAP_QUOTE_ORDER_INT.Map_Quote_to_Order : ', 1, 'N');

1878: END IF;
1879: END IF;
1880:
1881: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1882: aso_debug_pub.add('Create_Order: Before MAP_QUOTE_ORDER_INT.Map_Quote_to_Order : ', 1, 'N');
1883: END IF;
1884: ASO_MAP_QUOTE_ORDER_INT.Map_Quote_to_order(
1885: p_operation => 'CREATE' ,
1886: P_Qte_Rec => P_Qte_Rec ,

Line 1934: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1930: X_Lot_Serial_val_tbl => l_Lot_Serial_val_tbl ,
1931: x_Line_Payment_tbl => l_Line_Payment_tbl
1932: );
1933:
1934: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1935: aso_debug_pub.add('Create_Order: After Map_Quote_to_Order: ', 1, 'N');
1936: END IF;
1937:
1938: -- set the control record flags

Line 1935: aso_debug_pub.add('Create_Order: After Map_Quote_to_Order: ', 1, 'N');

1931: x_Line_Payment_tbl => l_Line_Payment_tbl
1932: );
1933:
1934: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1935: aso_debug_pub.add('Create_Order: After Map_Quote_to_Order: ', 1, 'N');
1936: END IF;
1937:
1938: -- set the control record flags
1939: -- book order

Line 1947: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1943: l_request_tbl(i).request_type := OE_GLOBALS.G_BOOK_ORDER;
1944: i := i + 1;
1945: END IF; -- booking
1946:
1947: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1948: aso_debug_pub.add('Create_Order: l_CC_Auth_Prof: '||l_CC_Auth_Prof, 1, 'N');
1949: END IF;
1950:
1951: IF l_CC_Auth_Prof = 'Y' AND P_Control_Rec.CC_By_Fax <> FND_API.G_TRUE THEN

Line 1948: aso_debug_pub.add('Create_Order: l_CC_Auth_Prof: '||l_CC_Auth_Prof, 1, 'N');

1944: i := i + 1;
1945: END IF; -- booking
1946:
1947: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1948: aso_debug_pub.add('Create_Order: l_CC_Auth_Prof: '||l_CC_Auth_Prof, 1, 'N');
1949: END IF;
1950:
1951: IF l_CC_Auth_Prof = 'Y' AND P_Control_Rec.CC_By_Fax <> FND_API.G_TRUE THEN
1952:

Line 1958: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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;
1961:
1962: l_request_tbl(i).request_type := OE_GLOBALS.G_VERIFY_PAYMENT;

Line 1959: aso_debug_pub.add('Create_Order: l_enable_risk_mgmt_prof: '||l_enable_risk_mgmt_prof, 1, 'N');

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;
1961:
1962: l_request_tbl(i).request_type := OE_GLOBALS.G_VERIFY_PAYMENT;
1963: l_request_tbl(i).entity_code := OE_GLOBALS.G_ENTITY_HEADER;

Line 1966: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1962: l_request_tbl(i).request_type := OE_GLOBALS.G_VERIFY_PAYMENT;
1963: l_request_tbl(i).entity_code := OE_GLOBALS.G_ENTITY_HEADER;
1964: --l_request_tbl(i).param2 := l_cc_auth_failure_prof;
1965:
1966: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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

Line 1967: aso_debug_pub.add('Create_Order: l_request_tbl(i).param2: '|| l_request_tbl(i).param2, 1, 'N');

1963: l_request_tbl(i).entity_code := OE_GLOBALS.G_ENTITY_HEADER;
1964: --l_request_tbl(i).param2 := l_cc_auth_failure_prof;
1965:
1966: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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');

Line 1987: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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;
1990:
1991: l_request_tbl(i).request_type := OE_GLOBALS.G_VERIFY_PAYMENT;

Line 1988: aso_debug_pub.add('Create_Order: l_enable_risk_mgmt_prof: '||l_enable_risk_mgmt_prof, 1, 'N');

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;
1990:
1991: l_request_tbl(i).request_type := OE_GLOBALS.G_VERIFY_PAYMENT;
1992: l_request_tbl(i).entity_code := OE_GLOBALS.G_ENTITY_LINE;

Line 1996: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1992: l_request_tbl(i).entity_code := OE_GLOBALS.G_ENTITY_LINE;
1993: l_request_tbl(i).entity_index := l_Line_Payment_tbl(x).Line_Index;
1994: --l_request_tbl(i).param2 := l_cc_auth_failure_prof;
1995:
1996: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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

Line 1997: aso_debug_pub.add('Create_Order: l_request_tbl(i).param2: '||l_request_tbl(i).param2, 1, 'N');

1993: l_request_tbl(i).entity_index := l_Line_Payment_tbl(x).Line_Index;
1994: --l_request_tbl(i).param2 := l_cc_auth_failure_prof;
1995:
1996: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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');

Line 2014: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2010: END LOOP; -- l_Line_Payment_tbl
2011:
2012: END IF; -- l_CC_Auth_Prof
2013:
2014: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2015: aso_debug_pub.add('Create_Order: Before Proc_Order: ', 1, 'N');
2016: aso_utility_pvt.print_login_info();
2017: END IF;
2018:

Line 2015: aso_debug_pub.add('Create_Order: Before Proc_Order: ', 1, 'N');

2011:
2012: END IF; -- l_CC_Auth_Prof
2013:
2014: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2015: aso_debug_pub.add('Create_Order: Before Proc_Order: ', 1, 'N');
2016: aso_utility_pvt.print_login_info();
2017: END IF;
2018:
2019: -- added new debug messages

Line 2022: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2018:
2019: -- added new debug messages
2020: IF l_line_tbl.count > 0 then
2021: for i in 1..l_line_tbl.count loop
2022: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2023: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').operation: ' || l_line_tbl(i).operation, 1, 'N');
2024: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_duration: ' || l_line_tbl(i).service_duration, 1, 'N');
2025: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_period: ' || l_line_tbl(i).service_period, 1, 'N');
2026: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_start_date: ' || l_line_tbl(i).service_start_date, 1, 'N');

Line 2023: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').operation: ' || l_line_tbl(i).operation, 1, 'N');

2019: -- added new debug messages
2020: IF l_line_tbl.count > 0 then
2021: for i in 1..l_line_tbl.count loop
2022: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2023: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').operation: ' || l_line_tbl(i).operation, 1, 'N');
2024: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_duration: ' || l_line_tbl(i).service_duration, 1, 'N');
2025: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_period: ' || l_line_tbl(i).service_period, 1, 'N');
2026: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_start_date: ' || l_line_tbl(i).service_start_date, 1, 'N');
2027: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_end_date: ' || l_line_tbl(i).service_end_date, 1, 'N');

Line 2024: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_duration: ' || l_line_tbl(i).service_duration, 1, 'N');

2020: IF l_line_tbl.count > 0 then
2021: for i in 1..l_line_tbl.count loop
2022: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2023: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').operation: ' || l_line_tbl(i).operation, 1, 'N');
2024: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_duration: ' || l_line_tbl(i).service_duration, 1, 'N');
2025: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_period: ' || l_line_tbl(i).service_period, 1, 'N');
2026: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_start_date: ' || l_line_tbl(i).service_start_date, 1, 'N');
2027: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_end_date: ' || l_line_tbl(i).service_end_date, 1, 'N');
2028: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').inventory_item_id: ' || l_line_tbl(i).inventory_item_id, 1, 'N');

Line 2025: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_period: ' || l_line_tbl(i).service_period, 1, 'N');

2021: for i in 1..l_line_tbl.count loop
2022: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2023: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').operation: ' || l_line_tbl(i).operation, 1, 'N');
2024: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_duration: ' || l_line_tbl(i).service_duration, 1, 'N');
2025: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_period: ' || l_line_tbl(i).service_period, 1, 'N');
2026: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_start_date: ' || l_line_tbl(i).service_start_date, 1, 'N');
2027: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_end_date: ' || l_line_tbl(i).service_end_date, 1, 'N');
2028: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').inventory_item_id: ' || l_line_tbl(i).inventory_item_id, 1, 'N');
2029: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').ordered_quantity: ' || l_line_tbl(i).ordered_quantity, 1, 'N');

Line 2026: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_start_date: ' || l_line_tbl(i).service_start_date, 1, 'N');

2022: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2023: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').operation: ' || l_line_tbl(i).operation, 1, 'N');
2024: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_duration: ' || l_line_tbl(i).service_duration, 1, 'N');
2025: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_period: ' || l_line_tbl(i).service_period, 1, 'N');
2026: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_start_date: ' || l_line_tbl(i).service_start_date, 1, 'N');
2027: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_end_date: ' || l_line_tbl(i).service_end_date, 1, 'N');
2028: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').inventory_item_id: ' || l_line_tbl(i).inventory_item_id, 1, 'N');
2029: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').ordered_quantity: ' || l_line_tbl(i).ordered_quantity, 1, 'N');
2030: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').order_quantity_uom: ' || l_line_tbl(i).order_quantity_uom, 1, 'N');

Line 2027: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_end_date: ' || l_line_tbl(i).service_end_date, 1, 'N');

2023: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').operation: ' || l_line_tbl(i).operation, 1, 'N');
2024: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_duration: ' || l_line_tbl(i).service_duration, 1, 'N');
2025: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_period: ' || l_line_tbl(i).service_period, 1, 'N');
2026: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_start_date: ' || l_line_tbl(i).service_start_date, 1, 'N');
2027: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_end_date: ' || l_line_tbl(i).service_end_date, 1, 'N');
2028: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').inventory_item_id: ' || l_line_tbl(i).inventory_item_id, 1, 'N');
2029: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').ordered_quantity: ' || l_line_tbl(i).ordered_quantity, 1, 'N');
2030: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').order_quantity_uom: ' || l_line_tbl(i).order_quantity_uom, 1, 'N');
2031: END IF;

Line 2028: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').inventory_item_id: ' || l_line_tbl(i).inventory_item_id, 1, 'N');

2024: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_duration: ' || l_line_tbl(i).service_duration, 1, 'N');
2025: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_period: ' || l_line_tbl(i).service_period, 1, 'N');
2026: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_start_date: ' || l_line_tbl(i).service_start_date, 1, 'N');
2027: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_end_date: ' || l_line_tbl(i).service_end_date, 1, 'N');
2028: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').inventory_item_id: ' || l_line_tbl(i).inventory_item_id, 1, 'N');
2029: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').ordered_quantity: ' || l_line_tbl(i).ordered_quantity, 1, 'N');
2030: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').order_quantity_uom: ' || l_line_tbl(i).order_quantity_uom, 1, 'N');
2031: END IF;
2032: end loop;

Line 2029: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').ordered_quantity: ' || l_line_tbl(i).ordered_quantity, 1, 'N');

2025: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_period: ' || l_line_tbl(i).service_period, 1, 'N');
2026: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_start_date: ' || l_line_tbl(i).service_start_date, 1, 'N');
2027: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_end_date: ' || l_line_tbl(i).service_end_date, 1, 'N');
2028: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').inventory_item_id: ' || l_line_tbl(i).inventory_item_id, 1, 'N');
2029: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').ordered_quantity: ' || l_line_tbl(i).ordered_quantity, 1, 'N');
2030: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').order_quantity_uom: ' || l_line_tbl(i).order_quantity_uom, 1, 'N');
2031: END IF;
2032: end loop;
2033: else

Line 2030: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').order_quantity_uom: ' || l_line_tbl(i).order_quantity_uom, 1, 'N');

2026: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_start_date: ' || l_line_tbl(i).service_start_date, 1, 'N');
2027: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_end_date: ' || l_line_tbl(i).service_end_date, 1, 'N');
2028: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').inventory_item_id: ' || l_line_tbl(i).inventory_item_id, 1, 'N');
2029: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').ordered_quantity: ' || l_line_tbl(i).ordered_quantity, 1, 'N');
2030: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').order_quantity_uom: ' || l_line_tbl(i).order_quantity_uom, 1, 'N');
2031: END IF;
2032: end loop;
2033: else
2034: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 2034: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2030: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').order_quantity_uom: ' || l_line_tbl(i).order_quantity_uom, 1, 'N');
2031: END IF;
2032: end loop;
2033: else
2034: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2035: aso_debug_pub.add('Create_Order: l_line_tbl count is 0 ', 1, 'N');
2036: END IF;
2037: end if;
2038:

Line 2035: aso_debug_pub.add('Create_Order: l_line_tbl count is 0 ', 1, 'N');

2031: END IF;
2032: end loop;
2033: else
2034: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2035: aso_debug_pub.add('Create_Order: l_line_tbl count is 0 ', 1, 'N');
2036: END IF;
2037: end if;
2038:
2039: -- bug# 1927450

Line 2043: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order vs value of p' || P ,1,'N');

2039: -- bug# 1927450
2040: OE_STANDARD_WF.SAVE_MESSAGES_OFF;
2041:
2042: /* P:=FND_GLOBAL.APPLICATION_SHORT_NAME;
2043: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order vs value of p' || P ,1,'N');
2044: --Start Fix for Bug bug 12775283
2045: If UPPER(P) IN ('QOT','ASO','ASF','ASL','AST','ASN','ONT') THEN -- 122 branch change
2046: Begin
2047: aso_debug_pub.add('Create_Order: Inside If condition ');

Line 2047: aso_debug_pub.add('Create_Order: Inside If condition ');

2043: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order vs value of p' || P ,1,'N');
2044: --Start Fix for Bug bug 12775283
2045: If UPPER(P) IN ('QOT','ASO','ASF','ASL','AST','ASN','ONT') THEN -- 122 branch change
2046: Begin
2047: aso_debug_pub.add('Create_Order: Inside If condition ');
2048:
2049: --Added this If Condition for bug12984742
2050: If P_Qte_Rec.QUOTE_HEADER_ID is not null then
2051:

Line 2060: aso_debug_pub.add('Create_OrderSQL%NOTFOUND ASO_API_QUOTE_ORDER_PROGRESS ');

2056: and QUOTE_STATUS_ID = P_Qte_Rec.QUOTE_STATUS_ID
2057: FOR UPDATE OF QUOTE_STATUS_ID NOWAIT;
2058:
2059: IF SQL%NOTFOUND THEN
2060: aso_debug_pub.add('Create_OrderSQL%NOTFOUND ASO_API_QUOTE_ORDER_PROGRESS ');
2061: FND_MESSAGE.Set_Name('ASO', 'ASO_API_QUOTE_ORDER_PROGRESS');
2062: FND_MSG_PUB.ADD;
2063: RAISE FND_API.G_EXC_ERROR;
2064: End if;

Line 2067: aso_debug_pub.add('before process_order L_QUOTE_HEADER_ID ' || L_QUOTE_HEADER_ID);

2063: RAISE FND_API.G_EXC_ERROR;
2064: End if;
2065: End If;
2066:
2067: aso_debug_pub.add('before process_order L_QUOTE_HEADER_ID ' || L_QUOTE_HEADER_ID);
2068: aso_debug_pub.add('before process_order L_QUOTE_STATUS_ID ' || L_QUOTE_STATUS_ID);
2069:
2070: EXCEPTION
2071:

Line 2068: aso_debug_pub.add('before process_order L_QUOTE_STATUS_ID ' || L_QUOTE_STATUS_ID);

2064: End if;
2065: End If;
2066:
2067: aso_debug_pub.add('before process_order L_QUOTE_HEADER_ID ' || L_QUOTE_HEADER_ID);
2068: aso_debug_pub.add('before process_order L_QUOTE_STATUS_ID ' || L_QUOTE_STATUS_ID);
2069:
2070: EXCEPTION
2071:
2072: when NO_DATA_FOUND then

Line 2076: aso_debug_pub.add('In others ASO_API_QUOTE_ORDER_PROGRESS ');

2072: when NO_DATA_FOUND then
2073: Null;
2074:
2075: WHEN OTHERS THEN
2076: aso_debug_pub.add('In others ASO_API_QUOTE_ORDER_PROGRESS ');
2077: FND_MESSAGE.SET_NAME('ASO', 'ASO_API_QUOTE_ORDER_PROGRESS');
2078: FND_MSG_PUB.ADD;
2079: RAISE FND_API.G_EXC_ERROR;
2080: END;

Line 2087: aso_debug_pub.add('i value ' || I || 'l_line_adj_tbl.line_index ' || L_LINE_ADJ_TBL(I).LINE_INDEX || 'l_line_adj_tbl.list_line_type_code ' ||

2083:
2084: --Bug 12800776 starts
2085: for I in 1 .. L_LINE_ADJ_TBL.COUNT
2086: LOOP
2087: aso_debug_pub.add('i value ' || I || 'l_line_adj_tbl.line_index ' || L_LINE_ADJ_TBL(I).LINE_INDEX || 'l_line_adj_tbl.list_line_type_code ' ||
2088: L_LINE_ADJ_TBL(I).LIST_LINE_TYPE_CODE ||' L_LINE_ADJ_TBL(I).modifier_header_id' || L_LINE_ADJ_TBL(I).list_header_id);
2089: end loop;
2090:
2091: for line_index in 1..l_line_adj_tbl.count loop

Line 2096: aso_debug_pub.add('Entered in PBH l_line_adj_assoc_tbl(assoc_tbl_index).adj_index' || L_LINE_ADJ_ASSOC_TBL(ASSOC_TBL_INDEX).ADJ_INDEX);

2092: if l_line_adj_tbl(line_index).list_line_type_code in ('PBH','PRG','OID') then
2093: l_line_adj_assoc_tbl(assoc_tbl_index).adj_index:=line_index;
2094: prev_adj_index:=line_index;
2095: mod_head_id := l_line_adj_tbl(line_index).list_header_id;
2096: aso_debug_pub.add('Entered in PBH l_line_adj_assoc_tbl(assoc_tbl_index).adj_index' || L_LINE_ADJ_ASSOC_TBL(ASSOC_TBL_INDEX).ADJ_INDEX);
2097: elsif l_line_adj_tbl(line_index).list_line_type_code = 'DIS' and l_line_adj_tbl(line_index).list_header_id = mod_head_id then
2098: l_line_adj_assoc_tbl(assoc_tbl_index).adj_index:=prev_adj_index;
2099: l_line_adj_assoc_tbl(assoc_tbl_index).rltd_adj_index:=line_index;
2100: aso_debug_pub.add('Entered in Dis l_line_adj_assoc_tbl(assoc_tbl_index).adj_index, rltd_adj_index ' || l_line_adj_assoc_tbl(assoc_tbl_index).adj_index || l_line_adj_assoc_tbl(assoc_tbl_index).rltd_adj_index);

Line 2100: aso_debug_pub.add('Entered in Dis l_line_adj_assoc_tbl(assoc_tbl_index).adj_index, rltd_adj_index ' || l_line_adj_assoc_tbl(assoc_tbl_index).adj_index || l_line_adj_assoc_tbl(assoc_tbl_index).rltd_adj_index);

2096: aso_debug_pub.add('Entered in PBH l_line_adj_assoc_tbl(assoc_tbl_index).adj_index' || L_LINE_ADJ_ASSOC_TBL(ASSOC_TBL_INDEX).ADJ_INDEX);
2097: elsif l_line_adj_tbl(line_index).list_line_type_code = 'DIS' and l_line_adj_tbl(line_index).list_header_id = mod_head_id then
2098: l_line_adj_assoc_tbl(assoc_tbl_index).adj_index:=prev_adj_index;
2099: l_line_adj_assoc_tbl(assoc_tbl_index).rltd_adj_index:=line_index;
2100: aso_debug_pub.add('Entered in Dis l_line_adj_assoc_tbl(assoc_tbl_index).adj_index, rltd_adj_index ' || l_line_adj_assoc_tbl(assoc_tbl_index).adj_index || l_line_adj_assoc_tbl(assoc_tbl_index).rltd_adj_index);
2101: assoc_tbl_index:=assoc_tbl_index+1;
2102: END IF;
2103: end loop;
2104:

Line 2108: aso_debug_pub.add('bug 12800776 after mapping vidya i value ' || i || 'l_line_adj_assoc_tbl(i).Adj_index: ' || l_line_adj_assoc_tbl(i).adj_index

2104:
2105: FOR i IN 1 .. l_line_adj_assoc_tbl.count
2106: LOOP
2107:
2108: aso_debug_pub.add('bug 12800776 after mapping vidya i value ' || i || 'l_line_adj_assoc_tbl(i).Adj_index: ' || l_line_adj_assoc_tbl(i).adj_index
2109: || 'l_line_adj_assoc_tbl(I).Rltd_Adj_index ' || l_line_adj_assoc_tbl(i).rltd_adj_index );
2110: END LOOP;
2111:
2112: --Bug 12800776 ends

Line 2118: If aso_debug_pub.g_debug_flag = 'Y' Then

2114: /*** Start : Code change done for Bug 14358079 ***/
2115:
2116: P := FND_GLOBAL.APPLICATION_SHORT_NAME;
2117:
2118: If aso_debug_pub.g_debug_flag = 'Y' Then
2119: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , Product : ' || P ,1,'N');
2120: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , P_Qte_Rec.QUOTE_HEADER_ID : '||P_Qte_Rec.QUOTE_HEADER_ID ,1,'N');
2121: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , P_Qte_Rec.QUOTE_STATUS_ID : '||P_Qte_Rec.QUOTE_STATUS_ID ,1,'N');
2122: End If;

Line 2119: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , Product : ' || P ,1,'N');

2115:
2116: P := FND_GLOBAL.APPLICATION_SHORT_NAME;
2117:
2118: If aso_debug_pub.g_debug_flag = 'Y' Then
2119: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , Product : ' || P ,1,'N');
2120: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , P_Qte_Rec.QUOTE_HEADER_ID : '||P_Qte_Rec.QUOTE_HEADER_ID ,1,'N');
2121: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , P_Qte_Rec.QUOTE_STATUS_ID : '||P_Qte_Rec.QUOTE_STATUS_ID ,1,'N');
2122: End If;
2123:

Line 2120: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , P_Qte_Rec.QUOTE_HEADER_ID : '||P_Qte_Rec.QUOTE_HEADER_ID ,1,'N');

2116: P := FND_GLOBAL.APPLICATION_SHORT_NAME;
2117:
2118: If aso_debug_pub.g_debug_flag = 'Y' Then
2119: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , Product : ' || P ,1,'N');
2120: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , P_Qte_Rec.QUOTE_HEADER_ID : '||P_Qte_Rec.QUOTE_HEADER_ID ,1,'N');
2121: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , P_Qte_Rec.QUOTE_STATUS_ID : '||P_Qte_Rec.QUOTE_STATUS_ID ,1,'N');
2122: End If;
2123:
2124: If UPPER(P) IN ('QOT','ASO','ASF','ASL','AST','ASN','ONT') Then

Line 2121: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , P_Qte_Rec.QUOTE_STATUS_ID : '||P_Qte_Rec.QUOTE_STATUS_ID ,1,'N');

2117:
2118: If aso_debug_pub.g_debug_flag = 'Y' Then
2119: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , Product : ' || P ,1,'N');
2120: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , P_Qte_Rec.QUOTE_HEADER_ID : '||P_Qte_Rec.QUOTE_HEADER_ID ,1,'N');
2121: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , P_Qte_Rec.QUOTE_STATUS_ID : '||P_Qte_Rec.QUOTE_STATUS_ID ,1,'N');
2122: End If;
2123:
2124: If UPPER(P) IN ('QOT','ASO','ASF','ASL','AST','ASN','ONT') Then
2125:

Line 2130: If aso_debug_pub.g_debug_flag = 'Y' Then

2126: BEGIN
2127: Open C_LOCK(P_Qte_Rec.QUOTE_HEADER_ID,P_Qte_Rec.QUOTE_STATUS_ID);
2128: Fetch C_LOCK Into L_QUOTE_HEADER_ID, L_QUOTE_STATUS_ID;
2129:
2130: If aso_debug_pub.g_debug_flag = 'Y' Then
2131: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , L_QUOTE_HEADER_ID : '||L_QUOTE_HEADER_ID ,1,'N');
2132: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , L_QUOTE_STATUS_ID : '||L_QUOTE_STATUS_ID ,1,'N');
2133: End If;
2134:

Line 2131: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , L_QUOTE_HEADER_ID : '||L_QUOTE_HEADER_ID ,1,'N');

2127: Open C_LOCK(P_Qte_Rec.QUOTE_HEADER_ID,P_Qte_Rec.QUOTE_STATUS_ID);
2128: Fetch C_LOCK Into L_QUOTE_HEADER_ID, L_QUOTE_STATUS_ID;
2129:
2130: If aso_debug_pub.g_debug_flag = 'Y' Then
2131: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , L_QUOTE_HEADER_ID : '||L_QUOTE_HEADER_ID ,1,'N');
2132: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , L_QUOTE_STATUS_ID : '||L_QUOTE_STATUS_ID ,1,'N');
2133: End If;
2134:
2135: If C_LOCK%NOTFOUND Then

Line 2132: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , L_QUOTE_STATUS_ID : '||L_QUOTE_STATUS_ID ,1,'N');

2128: Fetch C_LOCK Into L_QUOTE_HEADER_ID, L_QUOTE_STATUS_ID;
2129:
2130: If aso_debug_pub.g_debug_flag = 'Y' Then
2131: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , L_QUOTE_HEADER_ID : '||L_QUOTE_HEADER_ID ,1,'N');
2132: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , L_QUOTE_STATUS_ID : '||L_QUOTE_STATUS_ID ,1,'N');
2133: End If;
2134:
2135: If C_LOCK%NOTFOUND Then
2136: If aso_debug_pub.g_debug_flag = 'Y' Then

Line 2136: If aso_debug_pub.g_debug_flag = 'Y' Then

2132: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , L_QUOTE_STATUS_ID : '||L_QUOTE_STATUS_ID ,1,'N');
2133: End If;
2134:
2135: If C_LOCK%NOTFOUND Then
2136: If aso_debug_pub.g_debug_flag = 'Y' Then
2137: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , Cursor C_LOCK NOT FOUND ' ,1,'N');
2138: End If;
2139: End if;
2140:

Line 2137: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , Cursor C_LOCK NOT FOUND ' ,1,'N');

2133: End If;
2134:
2135: If C_LOCK%NOTFOUND Then
2136: If aso_debug_pub.g_debug_flag = 'Y' Then
2137: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order , Cursor C_LOCK NOT FOUND ' ,1,'N');
2138: End If;
2139: End if;
2140:
2141: Close C_LOCK;

Line 2147: If aso_debug_pub.g_debug_flag = 'Y' Then

2143: EXCEPTION
2144:
2145: WHEN OTHERS THEN
2146:
2147: If aso_debug_pub.g_debug_flag = 'Y' Then
2148: aso_debug_pub.add('Create_Order: When Others exception occures , ASO_API_QUOTE_ORDER_PROGRESS');
2149: aso_debug_pub.add('SQLCODE : '|| SQLCODE, 1, 'N');
2150: aso_debug_pub.add('SQLERRM : '|| SQLERRM, 1, 'N');
2151: End If;

Line 2148: aso_debug_pub.add('Create_Order: When Others exception occures , ASO_API_QUOTE_ORDER_PROGRESS');

2144:
2145: WHEN OTHERS THEN
2146:
2147: If aso_debug_pub.g_debug_flag = 'Y' Then
2148: aso_debug_pub.add('Create_Order: When Others exception occures , ASO_API_QUOTE_ORDER_PROGRESS');
2149: aso_debug_pub.add('SQLCODE : '|| SQLCODE, 1, 'N');
2150: aso_debug_pub.add('SQLERRM : '|| SQLERRM, 1, 'N');
2151: End If;
2152:

Line 2149: aso_debug_pub.add('SQLCODE : '|| SQLCODE, 1, 'N');

2145: WHEN OTHERS THEN
2146:
2147: If aso_debug_pub.g_debug_flag = 'Y' Then
2148: aso_debug_pub.add('Create_Order: When Others exception occures , ASO_API_QUOTE_ORDER_PROGRESS');
2149: aso_debug_pub.add('SQLCODE : '|| SQLCODE, 1, 'N');
2150: aso_debug_pub.add('SQLERRM : '|| SQLERRM, 1, 'N');
2151: End If;
2152:
2153: If FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) Then

Line 2150: aso_debug_pub.add('SQLERRM : '|| SQLERRM, 1, 'N');

2146:
2147: If aso_debug_pub.g_debug_flag = 'Y' Then
2148: aso_debug_pub.add('Create_Order: When Others exception occures , ASO_API_QUOTE_ORDER_PROGRESS');
2149: aso_debug_pub.add('SQLCODE : '|| SQLCODE, 1, 'N');
2150: aso_debug_pub.add('SQLERRM : '|| SQLERRM, 1, 'N');
2151: End If;
2152:
2153: If FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) Then
2154: FND_MESSAGE.SET_NAME('ASO', 'ASO_API_QUOTE_ORDER_PROGRESS');

Line 2162: IF aso_debug_pub.g_debug_flag = 'Y' Then

2158: END;
2159:
2160: End If;
2161:
2162: IF aso_debug_pub.g_debug_flag = 'Y' Then
2163: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order',1,'N');
2164: END If;
2165:
2166: /*** End : Code change done for Bug 14358079 ***/

Line 2163: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order',1,'N');

2159:
2160: End If;
2161:
2162: IF aso_debug_pub.g_debug_flag = 'Y' Then
2163: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order',1,'N');
2164: END If;
2165:
2166: /*** End : Code change done for Bug 14358079 ***/
2167:

Line 2235: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2231: l_Line_Scredit_tbl := lx_Line_Scredit_tbl;
2232: l_Lot_Serial_tbl := lx_Lot_Serial_tbl;
2233:
2234:
2235: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2236: aso_debug_pub.add('Create_Order: After Proc_Order: x_return_status: '||x_return_status, 1, 'N');
2237: aso_utility_pvt.print_login_info();
2238: END IF;
2239:

Line 2236: aso_debug_pub.add('Create_Order: After Proc_Order: x_return_status: '||x_return_status, 1, 'N');

2232: l_Lot_Serial_tbl := lx_Lot_Serial_tbl;
2233:
2234:
2235: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2236: aso_debug_pub.add('Create_Order: After Proc_Order: x_return_status: '||x_return_status, 1, 'N');
2237: aso_utility_pvt.print_login_info();
2238: END IF;
2239:
2240: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2295: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2291: -- map fulfillment
2292:
2293: -- check if the order can be satisfied by fulfillment alone. If yes, then call
2294: -- to OM can be avoided.
2295: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2296: aso_debug_pub.add('Create_Order: Before fulfilment: ', 1, 'N');
2297: END IF;
2298: IF p_control_rec.INTERFACE_FFM_FLAG = FND_API.G_TRUE
2299: AND x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 2296: aso_debug_pub.add('Create_Order: Before fulfilment: ', 1, 'N');

2292:
2293: -- check if the order can be satisfied by fulfillment alone. If yes, then call
2294: -- to OM can be avoided.
2295: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2296: aso_debug_pub.add('Create_Order: Before fulfilment: ', 1, 'N');
2297: END IF;
2298: IF p_control_rec.INTERFACE_FFM_FLAG = FND_API.G_TRUE
2299: AND x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2300: p_ffm_request_rec.party_id := p_qte_rec.party_id;

Line 2328: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2324: X_Return_Status => x_return_status,
2325: X_Msg_Count => x_msg_count ,
2326: X_Msg_Data => x_msg_data );
2327:
2328: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2329: aso_debug_pub.add('Create_Order: After submit_ffm_request x_return_status: '||x_return_status, 1, 'N');
2330: END IF;
2331: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2332: --retrieve_oe_messages;

Line 2329: aso_debug_pub.add('Create_Order: After submit_ffm_request x_return_status: '||x_return_status, 1, 'N');

2325: X_Msg_Count => x_msg_count ,
2326: X_Msg_Data => x_msg_data );
2327:
2328: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2329: aso_debug_pub.add('Create_Order: After submit_ffm_request x_return_status: '||x_return_status, 1, 'N');
2330: END IF;
2331: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2332: --retrieve_oe_messages;
2333: RAISE FND_API.G_EXC_ERROR;

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 2623: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2619: END IF;
2620: raise FND_API.G_EXC_ERROR;
2621: END IF;
2622:
2623: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2624: aso_debug_pub.add('l_split_pay_prof: '||l_split_pay_prof,1,'N');
2625: END IF;
2626:
2627: IF (l_split_pay_prof = 'N') THEN

Line 2624: aso_debug_pub.add('l_split_pay_prof: '||l_split_pay_prof,1,'N');

2620: raise FND_API.G_EXC_ERROR;
2621: END IF;
2622:
2623: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2624: aso_debug_pub.add('l_split_pay_prof: '||l_split_pay_prof,1,'N');
2625: END IF;
2626:
2627: IF (l_split_pay_prof = 'N') THEN
2628: IF p_header_payment_tbl.count > 1 THEN

Line 2660: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2656: END LOOP;
2657: END IF;
2658: END IF;
2659:
2660: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2661: aso_debug_pub.add('before ASO_MAP_QUOTE_ORDER_INT.Map_Quote_Order_Int: ',1,'N');
2662: aso_debug_pub.add('before ASO_MAP_QUOTE_ORDER_INT.Map_Quote_Order_Int: P_Calculate_Price_Flag '||P_Control_Rec.Calculate_Price,1,'N');
2663: END IF;
2664:

Line 2661: aso_debug_pub.add('before ASO_MAP_QUOTE_ORDER_INT.Map_Quote_Order_Int: ',1,'N');

2657: END IF;
2658: END IF;
2659:
2660: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2661: aso_debug_pub.add('before ASO_MAP_QUOTE_ORDER_INT.Map_Quote_Order_Int: ',1,'N');
2662: aso_debug_pub.add('before ASO_MAP_QUOTE_ORDER_INT.Map_Quote_Order_Int: P_Calculate_Price_Flag '||P_Control_Rec.Calculate_Price,1,'N');
2663: END IF;
2664:
2665: ASO_MAP_QUOTE_ORDER_INT.Map_Quote_to_order(

Line 2662: aso_debug_pub.add('before ASO_MAP_QUOTE_ORDER_INT.Map_Quote_Order_Int: P_Calculate_Price_Flag '||P_Control_Rec.Calculate_Price,1,'N');

2658: END IF;
2659:
2660: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2661: aso_debug_pub.add('before ASO_MAP_QUOTE_ORDER_INT.Map_Quote_Order_Int: ',1,'N');
2662: aso_debug_pub.add('before ASO_MAP_QUOTE_ORDER_INT.Map_Quote_Order_Int: P_Calculate_Price_Flag '||P_Control_Rec.Calculate_Price,1,'N');
2663: END IF;
2664:
2665: ASO_MAP_QUOTE_ORDER_INT.Map_Quote_to_order(
2666: p_operation => 'UPDATE' ,

Line 2726: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2722: l_request_tbl(i).request_type := OE_GLOBALS.G_BOOK_ORDER;
2723: i := i + 1;
2724: END IF; -- booking
2725:
2726: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2727: aso_debug_pub.add('Create_Order: l_CC_Auth_Prof: '||l_CC_Auth_Prof, 1, 'N');
2728: END IF;
2729:
2730: IF l_CC_Auth_Prof = 'Y' AND P_Control_Rec.CC_By_Fax <> FND_API.G_TRUE THEN

Line 2727: aso_debug_pub.add('Create_Order: l_CC_Auth_Prof: '||l_CC_Auth_Prof, 1, 'N');

2723: i := i + 1;
2724: END IF; -- booking
2725:
2726: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2727: aso_debug_pub.add('Create_Order: l_CC_Auth_Prof: '||l_CC_Auth_Prof, 1, 'N');
2728: END IF;
2729:
2730: IF l_CC_Auth_Prof = 'Y' AND P_Control_Rec.CC_By_Fax <> FND_API.G_TRUE THEN
2731:

Line 2737: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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;
2740:
2741: l_request_tbl(i).request_type := OE_GLOBALS.G_VERIFY_PAYMENT;

Line 2738: aso_debug_pub.add('Create_Order: l_enable_risk_mgmt_prof: '||l_enable_risk_mgmt_prof, 1, 'N');

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;
2740:
2741: l_request_tbl(i).request_type := OE_GLOBALS.G_VERIFY_PAYMENT;
2742: l_request_tbl(i).entity_code := OE_GLOBALS.G_ENTITY_HEADER;

Line 2745: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2741: l_request_tbl(i).request_type := OE_GLOBALS.G_VERIFY_PAYMENT;
2742: l_request_tbl(i).entity_code := OE_GLOBALS.G_ENTITY_HEADER;
2743: --l_request_tbl(i).param2 := l_cc_auth_failure_prof;
2744:
2745: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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

Line 2746: aso_debug_pub.add('Create_Order: l_request_tbl(i).param2: '|| l_request_tbl(i).param2, 1, 'N');

2742: l_request_tbl(i).entity_code := OE_GLOBALS.G_ENTITY_HEADER;
2743: --l_request_tbl(i).param2 := l_cc_auth_failure_prof;
2744:
2745: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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');

Line 2765: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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;
2768:
2769: l_request_tbl(i).request_type := OE_GLOBALS.G_VERIFY_PAYMENT;

Line 2766: aso_debug_pub.add('Create_Order: l_enable_risk_mgmt_prof: '||l_enable_risk_mgmt_prof, 1, 'N');

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;
2768:
2769: l_request_tbl(i).request_type := OE_GLOBALS.G_VERIFY_PAYMENT;
2770: l_request_tbl(i).entity_code := OE_GLOBALS.G_ENTITY_LINE;

Line 2774: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2770: l_request_tbl(i).entity_code := OE_GLOBALS.G_ENTITY_LINE;
2771: l_request_tbl(i).entity_index := l_Line_Payment_tbl(x).Line_Index;
2772: --l_request_tbl(i).param2 := l_cc_auth_failure_prof;
2773:
2774: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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

Line 2775: aso_debug_pub.add('Create_Order: l_request_tbl(i).param2: '|| l_request_tbl(i).param2, 1, 'N');

2771: l_request_tbl(i).entity_index := l_Line_Payment_tbl(x).Line_Index;
2772: --l_request_tbl(i).param2 := l_cc_auth_failure_prof;
2773:
2774: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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');

Line 2803: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2799:
2800: END IF;
2801: END LOOP;
2802:
2803: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2804: aso_debug_pub.add('Update_Order: Before Process_order',1,'Y');
2805: aso_utility_pvt.print_login_info();
2806: END IF;
2807:

Line 2804: aso_debug_pub.add('Update_Order: Before Process_order',1,'Y');

2800: END IF;
2801: END LOOP;
2802:
2803: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2804: aso_debug_pub.add('Update_Order: Before Process_order',1,'Y');
2805: aso_utility_pvt.print_login_info();
2806: END IF;
2807:
2808: -- bug# 1927450

Line 2885: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2881: l_Line_Scredit_tbl := lx_Line_Scredit_tbl;
2882: l_Lot_Serial_tbl := lx_Lot_Serial_tbl;
2883: l_request_tbl := lx_request_tbl;
2884:
2885: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2886: aso_debug_pub.add('Update_Order: After Process_Order: x_return_status'||x_return_status,1,'Y');
2887: aso_utility_pvt.print_login_info();
2888: END IF;
2889:

Line 2886: aso_debug_pub.add('Update_Order: After Process_Order: x_return_status'||x_return_status,1,'Y');

2882: l_Lot_Serial_tbl := lx_Lot_Serial_tbl;
2883: l_request_tbl := lx_request_tbl;
2884:
2885: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2886: aso_debug_pub.add('Update_Order: After Process_Order: x_return_status'||x_return_status,1,'Y');
2887: aso_utility_pvt.print_login_info();
2888: END IF;
2889:
2890: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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;