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

1798: FND_MSG_PUB.ADD;
1799: END IF;
1800: RAISE FND_API.G_EXC_ERROR;
1801: END IF;
1802: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1803: aso_debug_pub.add('Create_Order: Begin ', 1, 'N');
1804: END IF;
1805: -- change the org to whatever is stored in the org id column
1806: IF p_qte_rec.org_id is not NULL

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

1799: END IF;
1800: RAISE FND_API.G_EXC_ERROR;
1801: END IF;
1802: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1803: aso_debug_pub.add('Create_Order: Begin ', 1, 'N');
1804: END IF;
1805: -- change the org to whatever is stored in the org id column
1806: IF p_qte_rec.org_id is not NULL
1807: AND p_qte_rec.org_id <> FND_API.G_MISS_NUM THEN

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

1810: MO_GLOBAL.set_policy_context('S', p_qte_rec.org_id) ; --New Code Yogeshwar (MOAC)
1811:
1812: END IF;
1813:
1814: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1815: aso_debug_pub.add('l_split_pay_prof: '||l_split_pay_prof,1,'N');
1816: END IF;
1817:
1818: IF (l_split_pay_prof = 'N') THEN

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

1811:
1812: END IF;
1813:
1814: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1815: aso_debug_pub.add('l_split_pay_prof: '||l_split_pay_prof,1,'N');
1816: END IF;
1817:
1818: IF (l_split_pay_prof = 'N') THEN
1819: IF p_header_payment_tbl.count > 1 THEN

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

1848: END LOOP;
1849: END IF;
1850: END IF;
1851:
1852: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1853: aso_debug_pub.add('Create_Order: Before MAP_QUOTE_ORDER_INT.Map_Quote_to_Order : ', 1, 'N');
1854: END IF;
1855: ASO_MAP_QUOTE_ORDER_INT.Map_Quote_to_order(
1856: p_operation => 'CREATE' ,

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

1849: END IF;
1850: END IF;
1851:
1852: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1853: aso_debug_pub.add('Create_Order: Before MAP_QUOTE_ORDER_INT.Map_Quote_to_Order : ', 1, 'N');
1854: END IF;
1855: ASO_MAP_QUOTE_ORDER_INT.Map_Quote_to_order(
1856: p_operation => 'CREATE' ,
1857: P_Qte_Rec => P_Qte_Rec ,

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

1901: X_Lot_Serial_val_tbl => l_Lot_Serial_val_tbl ,
1902: x_Line_Payment_tbl => l_Line_Payment_tbl
1903: );
1904:
1905: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1906: aso_debug_pub.add('Create_Order: After Map_Quote_to_Order: ', 1, 'N');
1907: END IF;
1908:
1909: -- set the control record flags

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

1902: x_Line_Payment_tbl => l_Line_Payment_tbl
1903: );
1904:
1905: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1906: aso_debug_pub.add('Create_Order: After Map_Quote_to_Order: ', 1, 'N');
1907: END IF;
1908:
1909: -- set the control record flags
1910: -- book order

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

1914: l_request_tbl(i).request_type := OE_GLOBALS.G_BOOK_ORDER;
1915: i := i + 1;
1916: END IF; -- booking
1917:
1918: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1919: aso_debug_pub.add('Create_Order: l_CC_Auth_Prof: '||l_CC_Auth_Prof, 1, 'N');
1920: END IF;
1921:
1922: IF l_CC_Auth_Prof = 'Y' AND P_Control_Rec.CC_By_Fax <> FND_API.G_TRUE THEN

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

1915: i := i + 1;
1916: END IF; -- booking
1917:
1918: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1919: aso_debug_pub.add('Create_Order: l_CC_Auth_Prof: '||l_CC_Auth_Prof, 1, 'N');
1920: END IF;
1921:
1922: IF l_CC_Auth_Prof = 'Y' AND P_Control_Rec.CC_By_Fax <> FND_API.G_TRUE THEN
1923:

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

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

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

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;
1932:
1933: l_request_tbl(i).request_type := OE_GLOBALS.G_VERIFY_PAYMENT;
1934: l_request_tbl(i).entity_code := OE_GLOBALS.G_ENTITY_HEADER;

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

1933: l_request_tbl(i).request_type := OE_GLOBALS.G_VERIFY_PAYMENT;
1934: l_request_tbl(i).entity_code := OE_GLOBALS.G_ENTITY_HEADER;
1935: --l_request_tbl(i).param2 := l_cc_auth_failure_prof;
1936:
1937: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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

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

1934: l_request_tbl(i).entity_code := OE_GLOBALS.G_ENTITY_HEADER;
1935: --l_request_tbl(i).param2 := l_cc_auth_failure_prof;
1936:
1937: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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');

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

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;
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_LINE;

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

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

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

1964: l_request_tbl(i).entity_index := l_Line_Payment_tbl(x).Line_Index;
1965: --l_request_tbl(i).param2 := l_cc_auth_failure_prof;
1966:
1967: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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');

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

1981: END LOOP; -- l_Line_Payment_tbl
1982:
1983: END IF; -- l_CC_Auth_Prof
1984:
1985: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1986: aso_debug_pub.add('Create_Order: Before Proc_Order: ', 1, 'N');
1987: aso_utility_pvt.print_login_info();
1988: END IF;
1989:

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

1982:
1983: END IF; -- l_CC_Auth_Prof
1984:
1985: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1986: aso_debug_pub.add('Create_Order: Before Proc_Order: ', 1, 'N');
1987: aso_utility_pvt.print_login_info();
1988: END IF;
1989:
1990: -- added new debug messages

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

1989:
1990: -- added new debug messages
1991: IF l_line_tbl.count > 0 then
1992: for i in 1..l_line_tbl.count loop
1993: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1994: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').operation: ' || l_line_tbl(i).operation, 1, 'N');
1995: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_duration: ' || l_line_tbl(i).service_duration, 1, 'N');
1996: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_period: ' || l_line_tbl(i).service_period, 1, 'N');
1997: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_start_date: ' || l_line_tbl(i).service_start_date, 1, 'N');

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

1990: -- added new debug messages
1991: IF l_line_tbl.count > 0 then
1992: for i in 1..l_line_tbl.count loop
1993: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1994: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').operation: ' || l_line_tbl(i).operation, 1, 'N');
1995: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_duration: ' || l_line_tbl(i).service_duration, 1, 'N');
1996: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_period: ' || l_line_tbl(i).service_period, 1, 'N');
1997: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_start_date: ' || l_line_tbl(i).service_start_date, 1, 'N');
1998: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_end_date: ' || l_line_tbl(i).service_end_date, 1, 'N');

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

1991: IF l_line_tbl.count > 0 then
1992: for i in 1..l_line_tbl.count loop
1993: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1994: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').operation: ' || l_line_tbl(i).operation, 1, 'N');
1995: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_duration: ' || l_line_tbl(i).service_duration, 1, 'N');
1996: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_period: ' || l_line_tbl(i).service_period, 1, 'N');
1997: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_start_date: ' || l_line_tbl(i).service_start_date, 1, 'N');
1998: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_end_date: ' || l_line_tbl(i).service_end_date, 1, 'N');
1999: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').inventory_item_id: ' || l_line_tbl(i).inventory_item_id, 1, 'N');

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

1992: for i in 1..l_line_tbl.count loop
1993: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1994: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').operation: ' || l_line_tbl(i).operation, 1, 'N');
1995: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_duration: ' || l_line_tbl(i).service_duration, 1, 'N');
1996: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_period: ' || l_line_tbl(i).service_period, 1, 'N');
1997: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_start_date: ' || l_line_tbl(i).service_start_date, 1, 'N');
1998: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_end_date: ' || l_line_tbl(i).service_end_date, 1, 'N');
1999: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').inventory_item_id: ' || l_line_tbl(i).inventory_item_id, 1, 'N');
2000: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').ordered_quantity: ' || l_line_tbl(i).ordered_quantity, 1, 'N');

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

1993: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1994: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').operation: ' || l_line_tbl(i).operation, 1, 'N');
1995: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_duration: ' || l_line_tbl(i).service_duration, 1, 'N');
1996: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_period: ' || l_line_tbl(i).service_period, 1, 'N');
1997: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_start_date: ' || l_line_tbl(i).service_start_date, 1, 'N');
1998: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_end_date: ' || l_line_tbl(i).service_end_date, 1, 'N');
1999: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').inventory_item_id: ' || l_line_tbl(i).inventory_item_id, 1, 'N');
2000: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').ordered_quantity: ' || l_line_tbl(i).ordered_quantity, 1, 'N');
2001: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').order_quantity_uom: ' || l_line_tbl(i).order_quantity_uom, 1, 'N');

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

1994: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').operation: ' || l_line_tbl(i).operation, 1, 'N');
1995: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_duration: ' || l_line_tbl(i).service_duration, 1, 'N');
1996: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_period: ' || l_line_tbl(i).service_period, 1, 'N');
1997: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_start_date: ' || l_line_tbl(i).service_start_date, 1, 'N');
1998: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_end_date: ' || l_line_tbl(i).service_end_date, 1, 'N');
1999: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').inventory_item_id: ' || l_line_tbl(i).inventory_item_id, 1, 'N');
2000: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').ordered_quantity: ' || l_line_tbl(i).ordered_quantity, 1, 'N');
2001: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').order_quantity_uom: ' || l_line_tbl(i).order_quantity_uom, 1, 'N');
2002: END IF;

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

1995: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_duration: ' || l_line_tbl(i).service_duration, 1, 'N');
1996: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_period: ' || l_line_tbl(i).service_period, 1, 'N');
1997: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_start_date: ' || l_line_tbl(i).service_start_date, 1, 'N');
1998: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_end_date: ' || l_line_tbl(i).service_end_date, 1, 'N');
1999: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').inventory_item_id: ' || l_line_tbl(i).inventory_item_id, 1, 'N');
2000: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').ordered_quantity: ' || l_line_tbl(i).ordered_quantity, 1, 'N');
2001: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').order_quantity_uom: ' || l_line_tbl(i).order_quantity_uom, 1, 'N');
2002: END IF;
2003: end loop;

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

1996: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_period: ' || l_line_tbl(i).service_period, 1, 'N');
1997: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_start_date: ' || l_line_tbl(i).service_start_date, 1, 'N');
1998: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_end_date: ' || l_line_tbl(i).service_end_date, 1, 'N');
1999: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').inventory_item_id: ' || l_line_tbl(i).inventory_item_id, 1, 'N');
2000: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').ordered_quantity: ' || l_line_tbl(i).ordered_quantity, 1, 'N');
2001: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').order_quantity_uom: ' || l_line_tbl(i).order_quantity_uom, 1, 'N');
2002: END IF;
2003: end loop;
2004: else

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

1997: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_start_date: ' || l_line_tbl(i).service_start_date, 1, 'N');
1998: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').service_end_date: ' || l_line_tbl(i).service_end_date, 1, 'N');
1999: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').inventory_item_id: ' || l_line_tbl(i).inventory_item_id, 1, 'N');
2000: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').ordered_quantity: ' || l_line_tbl(i).ordered_quantity, 1, 'N');
2001: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').order_quantity_uom: ' || l_line_tbl(i).order_quantity_uom, 1, 'N');
2002: END IF;
2003: end loop;
2004: else
2005: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

2001: aso_debug_pub.add('Create_Order: l_line_tbl('|| i ||').order_quantity_uom: ' || l_line_tbl(i).order_quantity_uom, 1, 'N');
2002: END IF;
2003: end loop;
2004: else
2005: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2006: aso_debug_pub.add('Create_Order: l_line_tbl count is 0 ', 1, 'N');
2007: END IF;
2008: end if;
2009:

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

2002: END IF;
2003: end loop;
2004: else
2005: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2006: aso_debug_pub.add('Create_Order: l_line_tbl count is 0 ', 1, 'N');
2007: END IF;
2008: end if;
2009:
2010: -- bug# 1927450

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

2076: l_Line_Scredit_tbl := lx_Line_Scredit_tbl;
2077: l_Lot_Serial_tbl := lx_Lot_Serial_tbl;
2078:
2079:
2080: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2081: aso_debug_pub.add('Create_Order: After Proc_Order: x_return_status: '||x_return_status, 1, 'N');
2082: aso_utility_pvt.print_login_info();
2083: END IF;
2084:

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

2077: l_Lot_Serial_tbl := lx_Lot_Serial_tbl;
2078:
2079:
2080: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2081: aso_debug_pub.add('Create_Order: After Proc_Order: x_return_status: '||x_return_status, 1, 'N');
2082: aso_utility_pvt.print_login_info();
2083: END IF;
2084:
2085: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

2136: -- map fulfillment
2137:
2138: -- check if the order can be satisfied by fulfillment alone. If yes, then call
2139: -- to OM can be avoided.
2140: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2141: aso_debug_pub.add('Create_Order: Before fulfilment: ', 1, 'N');
2142: END IF;
2143: IF p_control_rec.INTERFACE_FFM_FLAG = FND_API.G_TRUE
2144: AND x_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

2137:
2138: -- check if the order can be satisfied by fulfillment alone. If yes, then call
2139: -- to OM can be avoided.
2140: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2141: aso_debug_pub.add('Create_Order: Before fulfilment: ', 1, 'N');
2142: END IF;
2143: IF p_control_rec.INTERFACE_FFM_FLAG = FND_API.G_TRUE
2144: AND x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2145: p_ffm_request_rec.party_id := p_qte_rec.party_id;

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

2169: X_Return_Status => x_return_status,
2170: X_Msg_Count => x_msg_count ,
2171: X_Msg_Data => x_msg_data );
2172:
2173: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2174: aso_debug_pub.add('Create_Order: After submit_ffm_request x_return_status: '||x_return_status, 1, 'N');
2175: END IF;
2176: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2177: --retrieve_oe_messages;

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

2170: X_Msg_Count => x_msg_count ,
2171: X_Msg_Data => x_msg_data );
2172:
2173: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2174: aso_debug_pub.add('Create_Order: After submit_ffm_request x_return_status: '||x_return_status, 1, 'N');
2175: END IF;
2176: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2177: --retrieve_oe_messages;
2178: RAISE FND_API.G_EXC_ERROR;

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

2455: END IF;
2456: raise FND_API.G_EXC_ERROR;
2457: END IF;
2458:
2459: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2460: aso_debug_pub.add('l_split_pay_prof: '||l_split_pay_prof,1,'N');
2461: END IF;
2462:
2463: IF (l_split_pay_prof = 'N') THEN

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

2456: raise FND_API.G_EXC_ERROR;
2457: END IF;
2458:
2459: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2460: aso_debug_pub.add('l_split_pay_prof: '||l_split_pay_prof,1,'N');
2461: END IF;
2462:
2463: IF (l_split_pay_prof = 'N') THEN
2464: IF p_header_payment_tbl.count > 1 THEN

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

2492: END LOOP;
2493: END IF;
2494: END IF;
2495:
2496: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2497: aso_debug_pub.add('before ASO_MAP_QUOTE_ORDER_INT.Map_Quote_Order_Int: ',1,'N');
2498: END IF;
2499:
2500: ASO_MAP_QUOTE_ORDER_INT.Map_Quote_to_order(

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

2493: END IF;
2494: END IF;
2495:
2496: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2497: aso_debug_pub.add('before ASO_MAP_QUOTE_ORDER_INT.Map_Quote_Order_Int: ',1,'N');
2498: END IF;
2499:
2500: ASO_MAP_QUOTE_ORDER_INT.Map_Quote_to_order(
2501: p_operation => 'UPDATE' ,

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

2556: l_request_tbl(i).request_type := OE_GLOBALS.G_BOOK_ORDER;
2557: i := i + 1;
2558: END IF; -- booking
2559:
2560: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2561: aso_debug_pub.add('Create_Order: l_CC_Auth_Prof: '||l_CC_Auth_Prof, 1, 'N');
2562: END IF;
2563:
2564: IF l_CC_Auth_Prof = 'Y' AND P_Control_Rec.CC_By_Fax <> FND_API.G_TRUE THEN

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

2557: i := i + 1;
2558: END IF; -- booking
2559:
2560: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2561: aso_debug_pub.add('Create_Order: l_CC_Auth_Prof: '||l_CC_Auth_Prof, 1, 'N');
2562: END IF;
2563:
2564: IF l_CC_Auth_Prof = 'Y' AND P_Control_Rec.CC_By_Fax <> FND_API.G_TRUE THEN
2565:

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

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

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

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;
2574:
2575: l_request_tbl(i).request_type := OE_GLOBALS.G_VERIFY_PAYMENT;
2576: l_request_tbl(i).entity_code := OE_GLOBALS.G_ENTITY_HEADER;

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

2575: l_request_tbl(i).request_type := OE_GLOBALS.G_VERIFY_PAYMENT;
2576: l_request_tbl(i).entity_code := OE_GLOBALS.G_ENTITY_HEADER;
2577: --l_request_tbl(i).param2 := l_cc_auth_failure_prof;
2578:
2579: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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

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

2576: l_request_tbl(i).entity_code := OE_GLOBALS.G_ENTITY_HEADER;
2577: --l_request_tbl(i).param2 := l_cc_auth_failure_prof;
2578:
2579: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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');

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

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

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

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;
2602:
2603: l_request_tbl(i).request_type := OE_GLOBALS.G_VERIFY_PAYMENT;
2604: l_request_tbl(i).entity_code := OE_GLOBALS.G_ENTITY_LINE;

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

2604: l_request_tbl(i).entity_code := OE_GLOBALS.G_ENTITY_LINE;
2605: l_request_tbl(i).entity_index := l_Line_Payment_tbl(x).Line_Index;
2606: --l_request_tbl(i).param2 := l_cc_auth_failure_prof;
2607:
2608: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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

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

2605: l_request_tbl(i).entity_index := l_Line_Payment_tbl(x).Line_Index;
2606: --l_request_tbl(i).param2 := l_cc_auth_failure_prof;
2607:
2608: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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');

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

2633:
2634: END IF;
2635: END LOOP;
2636:
2637: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2638: aso_debug_pub.add('Update_Order: Before Process_order',1,'Y');
2639: aso_utility_pvt.print_login_info();
2640: END IF;
2641:

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

2634: END IF;
2635: END LOOP;
2636:
2637: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2638: aso_debug_pub.add('Update_Order: Before Process_order',1,'Y');
2639: aso_utility_pvt.print_login_info();
2640: END IF;
2641:
2642: -- bug# 1927450

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

2715: l_Line_Scredit_tbl := lx_Line_Scredit_tbl;
2716: l_Lot_Serial_tbl := lx_Lot_Serial_tbl;
2717: l_request_tbl := lx_request_tbl;
2718:
2719: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2720: aso_debug_pub.add('Update_Order: After Process_Order: x_return_status'||x_return_status,1,'Y');
2721: aso_utility_pvt.print_login_info();
2722: END IF;
2723:

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

2716: l_Lot_Serial_tbl := lx_Lot_Serial_tbl;
2717: l_request_tbl := lx_request_tbl;
2718:
2719: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2720: aso_debug_pub.add('Update_Order: After Process_Order: x_return_status'||x_return_status,1,'Y');
2721: aso_utility_pvt.print_login_info();
2722: END IF;
2723:
2724: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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;