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_SPLIT_LINE_INT dependencies on ASO_DEBUG_PUB

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

35: where quote_line_id = p_qte_line_id;
36:
37: Begin
38:
39: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
40:
41:
42: x_return_status := fnd_api.g_ret_sts_success;
43:

Line 44: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

40:
41:
42: x_return_status := fnd_api.g_ret_sts_success;
43:
44: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
45: aso_debug_pub.add('ASO_SPLIT_LINE_INT: Split_Quote_line Begin', 1, 'Y');
46: END IF;
47:
48: l_control_rec.pricing_request_type := 'ASO';

Line 45: aso_debug_pub.add('ASO_SPLIT_LINE_INT: Split_Quote_line Begin', 1, 'Y');

41:
42: x_return_status := fnd_api.g_ret_sts_success;
43:
44: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
45: aso_debug_pub.add('ASO_SPLIT_LINE_INT: Split_Quote_line Begin', 1, 'Y');
46: END IF;
47:
48: l_control_rec.pricing_request_type := 'ASO';
49: l_control_rec.header_pricing_event := 'BATCH';

Line 53: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

49: l_control_rec.header_pricing_event := 'BATCH';
50: l_control_rec.calculate_tax_flag := 'Y';
51: l_control_rec.calculate_freight_charge_flag := 'Y';
52:
53: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
54: aso_debug_pub.add('Split_Quote_line: p_qte_line_id: '|| p_qte_line_id);
55: END IF;
56:
57: l_qte_line_rec.quote_line_id := p_qte_line_id;

Line 54: aso_debug_pub.add('Split_Quote_line: p_qte_line_id: '|| p_qte_line_id);

50: l_control_rec.calculate_tax_flag := 'Y';
51: l_control_rec.calculate_freight_charge_flag := 'Y';
52:
53: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
54: aso_debug_pub.add('Split_Quote_line: p_qte_line_id: '|| p_qte_line_id);
55: END IF;
56:
57: l_qte_line_rec.quote_line_id := p_qte_line_id;
58:

Line 63: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

59: open c_qte_header_id;
60: fetch c_qte_header_id into l_qte_header_rec.quote_header_id;
61: close c_qte_header_id;
62:
63: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
64: aso_debug_pub.add('Split_Quote_line: l_qte_header_rec.quote_header_id: '|| l_qte_header_rec.quote_header_id);
65: END IF;
66:
67: split_quote_line(

Line 64: aso_debug_pub.add('Split_Quote_line: l_qte_header_rec.quote_header_id: '|| l_qte_header_rec.quote_header_id);

60: fetch c_qte_header_id into l_qte_header_rec.quote_header_id;
61: close c_qte_header_id;
62:
63: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
64: aso_debug_pub.add('Split_Quote_line: l_qte_header_rec.quote_header_id: '|| l_qte_header_rec.quote_header_id);
65: END IF;
66:
67: split_quote_line(
68: p_api_version_number => p_api_version_number,

Line 81: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

77: x_return_status => x_return_status,
78: x_msg_count => x_msg_count,
79: x_msg_data => x_msg_data );
80:
81: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
82: aso_debug_pub.add('Split_Quote_line: After call to the overloaded split_quote_line procedure');
83: aso_debug_pub.add('Split_Quote_line: x_return_status: '|| x_return_status);
84: END IF;
85:

Line 82: aso_debug_pub.add('Split_Quote_line: After call to the overloaded split_quote_line procedure');

78: x_msg_count => x_msg_count,
79: x_msg_data => x_msg_data );
80:
81: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
82: aso_debug_pub.add('Split_Quote_line: After call to the overloaded split_quote_line procedure');
83: aso_debug_pub.add('Split_Quote_line: x_return_status: '|| x_return_status);
84: END IF;
85:
86: EXCEPTION

Line 83: aso_debug_pub.add('Split_Quote_line: x_return_status: '|| x_return_status);

79: x_msg_data => x_msg_data );
80:
81: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
82: aso_debug_pub.add('Split_Quote_line: After call to the overloaded split_quote_line procedure');
83: aso_debug_pub.add('Split_Quote_line: x_return_status: '|| x_return_status);
84: END IF;
85:
86: EXCEPTION
87:

Line 89: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

85:
86: EXCEPTION
87:
88: WHEN OTHERS THEN
89: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
90: aso_debug_pub.add('Split_Quote_line: Inside when others exception', 1, 'N');
91: END IF;
92:
93: End Split_Quote_line;

Line 90: aso_debug_pub.add('Split_Quote_line: Inside when others exception', 1, 'N');

86: EXCEPTION
87:
88: WHEN OTHERS THEN
89: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
90: aso_debug_pub.add('Split_Quote_line: Inside when others exception', 1, 'N');
91: END IF;
92:
93: End Split_Quote_line;
94:

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

140: where quote_line_id = p_original_qte_line_rec.quote_line_id;
141:
142: Begin
143:
144: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
145:
146:
147: --Standard Start of API savepoint
148: SAVEPOINT SPLIT_QUOTE_LINE_INT;

Line 150: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

146:
147: --Standard Start of API savepoint
148: SAVEPOINT SPLIT_QUOTE_LINE_INT;
149:
150: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
151:
152: aso_debug_pub.add('ASO_SPLIT_LINE_INT: Begin Split_Quote_line', 1, 'Y');
153: aso_debug_pub.add('P_Qte_Header_Rec.pricing_status_indicator: '||P_Qte_Header_Rec.pricing_status_indicator, 1, 'Y');
154: aso_debug_pub.add('P_Qte_Header_Rec.tax_status_indicator: '||P_Qte_Header_Rec.tax_status_indicator, 1, 'Y');

Line 152: aso_debug_pub.add('ASO_SPLIT_LINE_INT: Begin Split_Quote_line', 1, 'Y');

148: SAVEPOINT SPLIT_QUOTE_LINE_INT;
149:
150: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
151:
152: aso_debug_pub.add('ASO_SPLIT_LINE_INT: Begin Split_Quote_line', 1, 'Y');
153: aso_debug_pub.add('P_Qte_Header_Rec.pricing_status_indicator: '||P_Qte_Header_Rec.pricing_status_indicator, 1, 'Y');
154: aso_debug_pub.add('P_Qte_Header_Rec.tax_status_indicator: '||P_Qte_Header_Rec.tax_status_indicator, 1, 'Y');
155: aso_debug_pub.add('P_Qte_Header_Rec.quote_header_id: '||P_Qte_Header_Rec.quote_header_id, 1, 'Y');
156: aso_debug_pub.add('P_Qte_Header_Rec.last_update_date: '||P_Qte_Header_Rec.last_update_date, 1, 'Y');

Line 153: aso_debug_pub.add('P_Qte_Header_Rec.pricing_status_indicator: '||P_Qte_Header_Rec.pricing_status_indicator, 1, 'Y');

149:
150: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
151:
152: aso_debug_pub.add('ASO_SPLIT_LINE_INT: Begin Split_Quote_line', 1, 'Y');
153: aso_debug_pub.add('P_Qte_Header_Rec.pricing_status_indicator: '||P_Qte_Header_Rec.pricing_status_indicator, 1, 'Y');
154: aso_debug_pub.add('P_Qte_Header_Rec.tax_status_indicator: '||P_Qte_Header_Rec.tax_status_indicator, 1, 'Y');
155: aso_debug_pub.add('P_Qte_Header_Rec.quote_header_id: '||P_Qte_Header_Rec.quote_header_id, 1, 'Y');
156: aso_debug_pub.add('P_Qte_Header_Rec.last_update_date: '||P_Qte_Header_Rec.last_update_date, 1, 'Y');
157: aso_debug_pub.add('P_Qte_Header_Rec.price_updated_date: '||P_Qte_Header_Rec.price_updated_date, 1, 'Y');

Line 154: aso_debug_pub.add('P_Qte_Header_Rec.tax_status_indicator: '||P_Qte_Header_Rec.tax_status_indicator, 1, 'Y');

150: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
151:
152: aso_debug_pub.add('ASO_SPLIT_LINE_INT: Begin Split_Quote_line', 1, 'Y');
153: aso_debug_pub.add('P_Qte_Header_Rec.pricing_status_indicator: '||P_Qte_Header_Rec.pricing_status_indicator, 1, 'Y');
154: aso_debug_pub.add('P_Qte_Header_Rec.tax_status_indicator: '||P_Qte_Header_Rec.tax_status_indicator, 1, 'Y');
155: aso_debug_pub.add('P_Qte_Header_Rec.quote_header_id: '||P_Qte_Header_Rec.quote_header_id, 1, 'Y');
156: aso_debug_pub.add('P_Qte_Header_Rec.last_update_date: '||P_Qte_Header_Rec.last_update_date, 1, 'Y');
157: aso_debug_pub.add('P_Qte_Header_Rec.price_updated_date: '||P_Qte_Header_Rec.price_updated_date, 1, 'Y');
158: aso_debug_pub.add('P_Qte_Header_Rec.tax_updated_date: '||P_Qte_Header_Rec.tax_updated_date, 1, 'Y');

Line 155: aso_debug_pub.add('P_Qte_Header_Rec.quote_header_id: '||P_Qte_Header_Rec.quote_header_id, 1, 'Y');

151:
152: aso_debug_pub.add('ASO_SPLIT_LINE_INT: Begin Split_Quote_line', 1, 'Y');
153: aso_debug_pub.add('P_Qte_Header_Rec.pricing_status_indicator: '||P_Qte_Header_Rec.pricing_status_indicator, 1, 'Y');
154: aso_debug_pub.add('P_Qte_Header_Rec.tax_status_indicator: '||P_Qte_Header_Rec.tax_status_indicator, 1, 'Y');
155: aso_debug_pub.add('P_Qte_Header_Rec.quote_header_id: '||P_Qte_Header_Rec.quote_header_id, 1, 'Y');
156: aso_debug_pub.add('P_Qte_Header_Rec.last_update_date: '||P_Qte_Header_Rec.last_update_date, 1, 'Y');
157: aso_debug_pub.add('P_Qte_Header_Rec.price_updated_date: '||P_Qte_Header_Rec.price_updated_date, 1, 'Y');
158: aso_debug_pub.add('P_Qte_Header_Rec.tax_updated_date: '||P_Qte_Header_Rec.tax_updated_date, 1, 'Y');
159: aso_debug_pub.add('P_Qte_Header_Rec.recalculate_flag: '||P_Qte_Header_Rec.recalculate_flag, 1, 'Y');

Line 156: aso_debug_pub.add('P_Qte_Header_Rec.last_update_date: '||P_Qte_Header_Rec.last_update_date, 1, 'Y');

152: aso_debug_pub.add('ASO_SPLIT_LINE_INT: Begin Split_Quote_line', 1, 'Y');
153: aso_debug_pub.add('P_Qte_Header_Rec.pricing_status_indicator: '||P_Qte_Header_Rec.pricing_status_indicator, 1, 'Y');
154: aso_debug_pub.add('P_Qte_Header_Rec.tax_status_indicator: '||P_Qte_Header_Rec.tax_status_indicator, 1, 'Y');
155: aso_debug_pub.add('P_Qte_Header_Rec.quote_header_id: '||P_Qte_Header_Rec.quote_header_id, 1, 'Y');
156: aso_debug_pub.add('P_Qte_Header_Rec.last_update_date: '||P_Qte_Header_Rec.last_update_date, 1, 'Y');
157: aso_debug_pub.add('P_Qte_Header_Rec.price_updated_date: '||P_Qte_Header_Rec.price_updated_date, 1, 'Y');
158: aso_debug_pub.add('P_Qte_Header_Rec.tax_updated_date: '||P_Qte_Header_Rec.tax_updated_date, 1, 'Y');
159: aso_debug_pub.add('P_Qte_Header_Rec.recalculate_flag: '||P_Qte_Header_Rec.recalculate_flag, 1, 'Y');
160: aso_debug_pub.add('P_Control_Rec.pricing_request_type: '||P_Control_Rec.pricing_request_type, 1, 'Y');

Line 157: aso_debug_pub.add('P_Qte_Header_Rec.price_updated_date: '||P_Qte_Header_Rec.price_updated_date, 1, 'Y');

153: aso_debug_pub.add('P_Qte_Header_Rec.pricing_status_indicator: '||P_Qte_Header_Rec.pricing_status_indicator, 1, 'Y');
154: aso_debug_pub.add('P_Qte_Header_Rec.tax_status_indicator: '||P_Qte_Header_Rec.tax_status_indicator, 1, 'Y');
155: aso_debug_pub.add('P_Qte_Header_Rec.quote_header_id: '||P_Qte_Header_Rec.quote_header_id, 1, 'Y');
156: aso_debug_pub.add('P_Qte_Header_Rec.last_update_date: '||P_Qte_Header_Rec.last_update_date, 1, 'Y');
157: aso_debug_pub.add('P_Qte_Header_Rec.price_updated_date: '||P_Qte_Header_Rec.price_updated_date, 1, 'Y');
158: aso_debug_pub.add('P_Qte_Header_Rec.tax_updated_date: '||P_Qte_Header_Rec.tax_updated_date, 1, 'Y');
159: aso_debug_pub.add('P_Qte_Header_Rec.recalculate_flag: '||P_Qte_Header_Rec.recalculate_flag, 1, 'Y');
160: aso_debug_pub.add('P_Control_Rec.pricing_request_type: '||P_Control_Rec.pricing_request_type, 1, 'Y');
161: aso_debug_pub.add('P_Control_Rec.header_pricing_event: '||P_Control_Rec.header_pricing_event, 1, 'Y');

Line 158: aso_debug_pub.add('P_Qte_Header_Rec.tax_updated_date: '||P_Qte_Header_Rec.tax_updated_date, 1, 'Y');

154: aso_debug_pub.add('P_Qte_Header_Rec.tax_status_indicator: '||P_Qte_Header_Rec.tax_status_indicator, 1, 'Y');
155: aso_debug_pub.add('P_Qte_Header_Rec.quote_header_id: '||P_Qte_Header_Rec.quote_header_id, 1, 'Y');
156: aso_debug_pub.add('P_Qte_Header_Rec.last_update_date: '||P_Qte_Header_Rec.last_update_date, 1, 'Y');
157: aso_debug_pub.add('P_Qte_Header_Rec.price_updated_date: '||P_Qte_Header_Rec.price_updated_date, 1, 'Y');
158: aso_debug_pub.add('P_Qte_Header_Rec.tax_updated_date: '||P_Qte_Header_Rec.tax_updated_date, 1, 'Y');
159: aso_debug_pub.add('P_Qte_Header_Rec.recalculate_flag: '||P_Qte_Header_Rec.recalculate_flag, 1, 'Y');
160: aso_debug_pub.add('P_Control_Rec.pricing_request_type: '||P_Control_Rec.pricing_request_type, 1, 'Y');
161: aso_debug_pub.add('P_Control_Rec.header_pricing_event: '||P_Control_Rec.header_pricing_event, 1, 'Y');
162: aso_debug_pub.add('P_Control_Rec.line_pricing_event: '||P_Control_Rec.line_pricing_event, 1, 'Y');

Line 159: aso_debug_pub.add('P_Qte_Header_Rec.recalculate_flag: '||P_Qte_Header_Rec.recalculate_flag, 1, 'Y');

155: aso_debug_pub.add('P_Qte_Header_Rec.quote_header_id: '||P_Qte_Header_Rec.quote_header_id, 1, 'Y');
156: aso_debug_pub.add('P_Qte_Header_Rec.last_update_date: '||P_Qte_Header_Rec.last_update_date, 1, 'Y');
157: aso_debug_pub.add('P_Qte_Header_Rec.price_updated_date: '||P_Qte_Header_Rec.price_updated_date, 1, 'Y');
158: aso_debug_pub.add('P_Qte_Header_Rec.tax_updated_date: '||P_Qte_Header_Rec.tax_updated_date, 1, 'Y');
159: aso_debug_pub.add('P_Qte_Header_Rec.recalculate_flag: '||P_Qte_Header_Rec.recalculate_flag, 1, 'Y');
160: aso_debug_pub.add('P_Control_Rec.pricing_request_type: '||P_Control_Rec.pricing_request_type, 1, 'Y');
161: aso_debug_pub.add('P_Control_Rec.header_pricing_event: '||P_Control_Rec.header_pricing_event, 1, 'Y');
162: aso_debug_pub.add('P_Control_Rec.line_pricing_event: '||P_Control_Rec.line_pricing_event, 1, 'Y');
163: aso_debug_pub.add('P_Control_Rec.CALCULATE_TAX_FLAG: '||P_Control_Rec.CALCULATE_TAX_FLAG, 1, 'Y');

Line 160: aso_debug_pub.add('P_Control_Rec.pricing_request_type: '||P_Control_Rec.pricing_request_type, 1, 'Y');

156: aso_debug_pub.add('P_Qte_Header_Rec.last_update_date: '||P_Qte_Header_Rec.last_update_date, 1, 'Y');
157: aso_debug_pub.add('P_Qte_Header_Rec.price_updated_date: '||P_Qte_Header_Rec.price_updated_date, 1, 'Y');
158: aso_debug_pub.add('P_Qte_Header_Rec.tax_updated_date: '||P_Qte_Header_Rec.tax_updated_date, 1, 'Y');
159: aso_debug_pub.add('P_Qte_Header_Rec.recalculate_flag: '||P_Qte_Header_Rec.recalculate_flag, 1, 'Y');
160: aso_debug_pub.add('P_Control_Rec.pricing_request_type: '||P_Control_Rec.pricing_request_type, 1, 'Y');
161: aso_debug_pub.add('P_Control_Rec.header_pricing_event: '||P_Control_Rec.header_pricing_event, 1, 'Y');
162: aso_debug_pub.add('P_Control_Rec.line_pricing_event: '||P_Control_Rec.line_pricing_event, 1, 'Y');
163: aso_debug_pub.add('P_Control_Rec.CALCULATE_TAX_FLAG: '||P_Control_Rec.CALCULATE_TAX_FLAG, 1, 'Y');
164: aso_debug_pub.add('P_Control_Rec.CALCULATE_FREIGHT_CHARGE_FLAG: '||P_Control_Rec.CALCULATE_FREIGHT_CHARGE_FLAG, 1, 'Y');

Line 161: aso_debug_pub.add('P_Control_Rec.header_pricing_event: '||P_Control_Rec.header_pricing_event, 1, 'Y');

157: aso_debug_pub.add('P_Qte_Header_Rec.price_updated_date: '||P_Qte_Header_Rec.price_updated_date, 1, 'Y');
158: aso_debug_pub.add('P_Qte_Header_Rec.tax_updated_date: '||P_Qte_Header_Rec.tax_updated_date, 1, 'Y');
159: aso_debug_pub.add('P_Qte_Header_Rec.recalculate_flag: '||P_Qte_Header_Rec.recalculate_flag, 1, 'Y');
160: aso_debug_pub.add('P_Control_Rec.pricing_request_type: '||P_Control_Rec.pricing_request_type, 1, 'Y');
161: aso_debug_pub.add('P_Control_Rec.header_pricing_event: '||P_Control_Rec.header_pricing_event, 1, 'Y');
162: aso_debug_pub.add('P_Control_Rec.line_pricing_event: '||P_Control_Rec.line_pricing_event, 1, 'Y');
163: aso_debug_pub.add('P_Control_Rec.CALCULATE_TAX_FLAG: '||P_Control_Rec.CALCULATE_TAX_FLAG, 1, 'Y');
164: aso_debug_pub.add('P_Control_Rec.CALCULATE_FREIGHT_CHARGE_FLAG: '||P_Control_Rec.CALCULATE_FREIGHT_CHARGE_FLAG, 1, 'Y');
165: aso_debug_pub.add('P_Control_Rec.PRICE_MODE: '||P_Control_Rec.PRICE_MODE, 1, 'Y');

Line 162: aso_debug_pub.add('P_Control_Rec.line_pricing_event: '||P_Control_Rec.line_pricing_event, 1, 'Y');

158: aso_debug_pub.add('P_Qte_Header_Rec.tax_updated_date: '||P_Qte_Header_Rec.tax_updated_date, 1, 'Y');
159: aso_debug_pub.add('P_Qte_Header_Rec.recalculate_flag: '||P_Qte_Header_Rec.recalculate_flag, 1, 'Y');
160: aso_debug_pub.add('P_Control_Rec.pricing_request_type: '||P_Control_Rec.pricing_request_type, 1, 'Y');
161: aso_debug_pub.add('P_Control_Rec.header_pricing_event: '||P_Control_Rec.header_pricing_event, 1, 'Y');
162: aso_debug_pub.add('P_Control_Rec.line_pricing_event: '||P_Control_Rec.line_pricing_event, 1, 'Y');
163: aso_debug_pub.add('P_Control_Rec.CALCULATE_TAX_FLAG: '||P_Control_Rec.CALCULATE_TAX_FLAG, 1, 'Y');
164: aso_debug_pub.add('P_Control_Rec.CALCULATE_FREIGHT_CHARGE_FLAG: '||P_Control_Rec.CALCULATE_FREIGHT_CHARGE_FLAG, 1, 'Y');
165: aso_debug_pub.add('P_Control_Rec.PRICE_MODE: '||P_Control_Rec.PRICE_MODE, 1, 'Y');
166:

Line 163: aso_debug_pub.add('P_Control_Rec.CALCULATE_TAX_FLAG: '||P_Control_Rec.CALCULATE_TAX_FLAG, 1, 'Y');

159: aso_debug_pub.add('P_Qte_Header_Rec.recalculate_flag: '||P_Qte_Header_Rec.recalculate_flag, 1, 'Y');
160: aso_debug_pub.add('P_Control_Rec.pricing_request_type: '||P_Control_Rec.pricing_request_type, 1, 'Y');
161: aso_debug_pub.add('P_Control_Rec.header_pricing_event: '||P_Control_Rec.header_pricing_event, 1, 'Y');
162: aso_debug_pub.add('P_Control_Rec.line_pricing_event: '||P_Control_Rec.line_pricing_event, 1, 'Y');
163: aso_debug_pub.add('P_Control_Rec.CALCULATE_TAX_FLAG: '||P_Control_Rec.CALCULATE_TAX_FLAG, 1, 'Y');
164: aso_debug_pub.add('P_Control_Rec.CALCULATE_FREIGHT_CHARGE_FLAG: '||P_Control_Rec.CALCULATE_FREIGHT_CHARGE_FLAG, 1, 'Y');
165: aso_debug_pub.add('P_Control_Rec.PRICE_MODE: '||P_Control_Rec.PRICE_MODE, 1, 'Y');
166:
167: END IF;

Line 164: aso_debug_pub.add('P_Control_Rec.CALCULATE_FREIGHT_CHARGE_FLAG: '||P_Control_Rec.CALCULATE_FREIGHT_CHARGE_FLAG, 1, 'Y');

160: aso_debug_pub.add('P_Control_Rec.pricing_request_type: '||P_Control_Rec.pricing_request_type, 1, 'Y');
161: aso_debug_pub.add('P_Control_Rec.header_pricing_event: '||P_Control_Rec.header_pricing_event, 1, 'Y');
162: aso_debug_pub.add('P_Control_Rec.line_pricing_event: '||P_Control_Rec.line_pricing_event, 1, 'Y');
163: aso_debug_pub.add('P_Control_Rec.CALCULATE_TAX_FLAG: '||P_Control_Rec.CALCULATE_TAX_FLAG, 1, 'Y');
164: aso_debug_pub.add('P_Control_Rec.CALCULATE_FREIGHT_CHARGE_FLAG: '||P_Control_Rec.CALCULATE_FREIGHT_CHARGE_FLAG, 1, 'Y');
165: aso_debug_pub.add('P_Control_Rec.PRICE_MODE: '||P_Control_Rec.PRICE_MODE, 1, 'Y');
166:
167: END IF;
168:

Line 165: aso_debug_pub.add('P_Control_Rec.PRICE_MODE: '||P_Control_Rec.PRICE_MODE, 1, 'Y');

161: aso_debug_pub.add('P_Control_Rec.header_pricing_event: '||P_Control_Rec.header_pricing_event, 1, 'Y');
162: aso_debug_pub.add('P_Control_Rec.line_pricing_event: '||P_Control_Rec.line_pricing_event, 1, 'Y');
163: aso_debug_pub.add('P_Control_Rec.CALCULATE_TAX_FLAG: '||P_Control_Rec.CALCULATE_TAX_FLAG, 1, 'Y');
164: aso_debug_pub.add('P_Control_Rec.CALCULATE_FREIGHT_CHARGE_FLAG: '||P_Control_Rec.CALCULATE_FREIGHT_CHARGE_FLAG, 1, 'Y');
165: aso_debug_pub.add('P_Control_Rec.PRICE_MODE: '||P_Control_Rec.PRICE_MODE, 1, 'Y');
166:
167: END IF;
168:
169: --Initialize API return status to SUCCESS

Line 189: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

185: FND_MSG_PUB.initialize;
186:
187: END IF;
188:
189: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
190:
191: aso_debug_pub.add('Split_Quote_line: p_qte_header_rec.quote_header_id: '|| p_qte_header_rec.quote_header_id);
192: aso_debug_pub.add('Split_Quote_line: p_original_qte_line_rec.quote_line_id: '|| p_original_qte_line_rec.quote_line_id);
193:

Line 191: aso_debug_pub.add('Split_Quote_line: p_qte_header_rec.quote_header_id: '|| p_qte_header_rec.quote_header_id);

187: END IF;
188:
189: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
190:
191: aso_debug_pub.add('Split_Quote_line: p_qte_header_rec.quote_header_id: '|| p_qte_header_rec.quote_header_id);
192: aso_debug_pub.add('Split_Quote_line: p_original_qte_line_rec.quote_line_id: '|| p_original_qte_line_rec.quote_line_id);
193:
194: END IF;
195:

Line 192: aso_debug_pub.add('Split_Quote_line: p_original_qte_line_rec.quote_line_id: '|| p_original_qte_line_rec.quote_line_id);

188:
189: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
190:
191: aso_debug_pub.add('Split_Quote_line: p_qte_header_rec.quote_header_id: '|| p_qte_header_rec.quote_header_id);
192: aso_debug_pub.add('Split_Quote_line: p_original_qte_line_rec.quote_line_id: '|| p_original_qte_line_rec.quote_line_id);
193:
194: END IF;
195:
196: IF p_qte_header_rec.quote_header_id is not null OR

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

210: END IF;
211:
212: close c_quote_header_id;
213:
214: IF aso_debug_pub.g_debug_flag = 'Y' THEN
215: aso_debug_pub.add('split_quote_line: l_quote_header_id: '|| l_quote_header_id);
216: END IF;
217:
218: ELSE

Line 215: aso_debug_pub.add('split_quote_line: l_quote_header_id: '|| l_quote_header_id);

211:
212: close c_quote_header_id;
213:
214: IF aso_debug_pub.g_debug_flag = 'Y' THEN
215: aso_debug_pub.add('split_quote_line: l_quote_header_id: '|| l_quote_header_id);
216: END IF;
217:
218: ELSE
219:

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

216: END IF;
217:
218: ELSE
219:
220: IF aso_debug_pub.g_debug_flag = 'Y' THEN
221: aso_debug_pub.add('Split_Quote_line: Both quote_header_id and quote_line_id is null
222: or g_miss_num');
223: END IF;
224:

Line 221: aso_debug_pub.add('Split_Quote_line: Both quote_header_id and quote_line_id is null

217:
218: ELSE
219:
220: IF aso_debug_pub.g_debug_flag = 'Y' THEN
221: aso_debug_pub.add('Split_Quote_line: Both quote_header_id and quote_line_id is null
222: or g_miss_num');
223: END IF;
224:
225: END IF;

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

223: END IF;
224:
225: END IF;
226:
227: IF aso_debug_pub.g_debug_flag = 'Y' THEN
228: aso_debug_pub.add('split_quote_line: l_call_lock_exist: '|| l_call_lock_exist);
229: END IF;
230:
231: IF l_call_lock_exist = fnd_api.g_true THEN

Line 228: aso_debug_pub.add('split_quote_line: l_call_lock_exist: '|| l_call_lock_exist);

224:
225: END IF;
226:
227: IF aso_debug_pub.g_debug_flag = 'Y' THEN
228: aso_debug_pub.add('split_quote_line: l_call_lock_exist: '|| l_call_lock_exist);
229: END IF;
230:
231: IF l_call_lock_exist = fnd_api.g_true THEN
232:

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

232:
233: aso_conc_req_int.lock_exists( p_quote_header_id => l_quote_header_id,
234: x_status => l_x_status );
235:
236: IF aso_debug_pub.g_debug_flag = 'Y' THEN
237: aso_debug_pub.add('split_quote_line: l_x_status: '|| l_x_status);
238: END IF;
239:
240: if l_x_status = fnd_api.g_true then

Line 237: aso_debug_pub.add('split_quote_line: l_x_status: '|| l_x_status);

233: aso_conc_req_int.lock_exists( p_quote_header_id => l_quote_header_id,
234: x_status => l_x_status );
235:
236: IF aso_debug_pub.g_debug_flag = 'Y' THEN
237: aso_debug_pub.add('split_quote_line: l_x_status: '|| l_x_status);
238: END IF;
239:
240: if l_x_status = fnd_api.g_true then
241:

Line 257: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

253:
254: IF p_original_qte_line_rec.quote_line_id is null OR
255: p_original_qte_line_rec.quote_line_id = FND_API.G_MISS_NUM THEN
256:
257: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
258: aso_debug_pub.add('Split_Quote_line: p_original_qte_line_rec.quote_line_id is null or G_MISS_NUM');
259: END IF;
260:
261: x_return_status := FND_API.G_RET_STS_ERROR;

Line 258: aso_debug_pub.add('Split_Quote_line: p_original_qte_line_rec.quote_line_id is null or G_MISS_NUM');

254: IF p_original_qte_line_rec.quote_line_id is null OR
255: p_original_qte_line_rec.quote_line_id = FND_API.G_MISS_NUM THEN
256:
257: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
258: aso_debug_pub.add('Split_Quote_line: p_original_qte_line_rec.quote_line_id is null or G_MISS_NUM');
259: END IF;
260:
261: x_return_status := FND_API.G_RET_STS_ERROR;
262:

Line 276: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

272: RAISE FND_API.G_EXC_ERROR;
273:
274: ELSIF p_qte_line_tbl.count = 0 THEN
275:
276: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
277: aso_debug_pub.add('Split_Quote_line: p_qte_line_tbl.count: '|| p_qte_line_tbl.count);
278: END IF;
279:
280: x_return_status := FND_API.G_RET_STS_ERROR;

Line 277: aso_debug_pub.add('Split_Quote_line: p_qte_line_tbl.count: '|| p_qte_line_tbl.count);

273:
274: ELSIF p_qte_line_tbl.count = 0 THEN
275:
276: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
277: aso_debug_pub.add('Split_Quote_line: p_qte_line_tbl.count: '|| p_qte_line_tbl.count);
278: END IF;
279:
280: x_return_status := FND_API.G_RET_STS_ERROR;
281:

Line 294: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

290: RAISE FND_API.G_EXC_ERROR;
291:
292: ELSIF p_qte_line_tbl.count = 1 AND p_qte_line_tbl(1).quantity <= 0 THEN
293:
294: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
295: aso_debug_pub.add('Split_Quote_line: Only one record in p_qte_line_tbl with zero line quantity');
296: END IF;
297:
298: x_return_status := FND_API.G_RET_STS_ERROR;

Line 295: aso_debug_pub.add('Split_Quote_line: Only one record in p_qte_line_tbl with zero line quantity');

291:
292: ELSIF p_qte_line_tbl.count = 1 AND p_qte_line_tbl(1).quantity <= 0 THEN
293:
294: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
295: aso_debug_pub.add('Split_Quote_line: Only one record in p_qte_line_tbl with zero line quantity');
296: END IF;
297:
298: x_return_status := FND_API.G_RET_STS_ERROR;
299:

Line 319: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

315: IF l_qte_line_rec.line_category_code = 'RETURN' THEN
316:
317: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_rec.quote_line_id);
318:
319: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
320: aso_debug_pub.add('Split_Quote_Line: l_qte_line_dtl_tbl.count: '||l_qte_line_dtl_tbl.count);
321: END IF;
322:
323: IF l_qte_line_dtl_tbl.count > 0 AND

Line 320: aso_debug_pub.add('Split_Quote_Line: l_qte_line_dtl_tbl.count: '||l_qte_line_dtl_tbl.count);

316:
317: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_rec.quote_line_id);
318:
319: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
320: aso_debug_pub.add('Split_Quote_Line: l_qte_line_dtl_tbl.count: '||l_qte_line_dtl_tbl.count);
321: END IF;
322:
323: IF l_qte_line_dtl_tbl.count > 0 AND
324: l_qte_line_dtl_tbl(1).return_ref_type = 'SALES ORDER' AND

Line 328: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

324: l_qte_line_dtl_tbl(1).return_ref_type = 'SALES ORDER' AND
325: l_qte_line_dtl_tbl(1).return_ref_line_id is not null AND
326: l_qte_line_dtl_tbl(1).instance_id is not null THEN
327:
328: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
329: aso_debug_pub.add('Quote line created from install base having line_category_code = RETURN and refer to an order, can not be spilted.');
330: END IF;
331:
332: x_return_status := FND_API.G_RET_STS_ERROR;

Line 329: aso_debug_pub.add('Quote line created from install base having line_category_code = RETURN and refer to an order, can not be spilted.');

325: l_qte_line_dtl_tbl(1).return_ref_line_id is not null AND
326: l_qte_line_dtl_tbl(1).instance_id is not null THEN
327:
328: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
329: aso_debug_pub.add('Quote line created from install base having line_category_code = RETURN and refer to an order, can not be spilted.');
330: END IF;
331:
332: x_return_status := FND_API.G_RET_STS_ERROR;
333:

Line 347: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

343: END IF;
344:
345: END IF;
346:
347: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
348: aso_debug_pub.add('Split_Quote_line: After querying quote line row');
349: END IF;
350:
351: IF l_qte_line_rec.item_type_code = 'CFG' THEN

Line 348: aso_debug_pub.add('Split_Quote_line: After querying quote line row');

344:
345: END IF;
346:
347: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
348: aso_debug_pub.add('Split_Quote_line: After querying quote line row');
349: END IF;
350:
351: IF l_qte_line_rec.item_type_code = 'CFG' THEN
352:

Line 353: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

349: END IF;
350:
351: IF l_qte_line_rec.item_type_code = 'CFG' THEN
352:
353: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
354: aso_debug_pub.add('Split_Quote_line: Quote line item type code is CFG split of this line is not allowed', 1, 'N');
355: END IF;
356:
357: x_return_status := FND_API.G_RET_STS_ERROR;

Line 354: aso_debug_pub.add('Split_Quote_line: Quote line item type code is CFG split of this line is not allowed', 1, 'N');

350:
351: IF l_qte_line_rec.item_type_code = 'CFG' THEN
352:
353: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
354: aso_debug_pub.add('Split_Quote_line: Quote line item type code is CFG split of this line is not allowed', 1, 'N');
355: END IF;
356:
357: x_return_status := FND_API.G_RET_STS_ERROR;
358:

Line 379: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

375: CLOSE c_config_exist;
376:
377: --Calling the split_model_line API in Copy_Quote
378:
379: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
380: aso_debug_pub.add('Calling the Split Model Line API in Copy Quote',1,'N');
381: END IF;
382:
383: aso_copy_quote_pvt.split_model_line (

Line 380: aso_debug_pub.add('Calling the Split Model Line API in Copy Quote',1,'N');

376:
377: --Calling the split_model_line API in Copy_Quote
378:
379: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
380: aso_debug_pub.add('Calling the Split Model Line API in Copy Quote',1,'N');
381: END IF;
382:
383: aso_copy_quote_pvt.split_model_line (
384: p_api_version_number => p_api_version_number,

Line 396: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

392: x_return_status => x_return_status,
393: x_msg_count => x_msg_count,
394: x_msg_data => x_msg_data );
395:
396: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
397: aso_debug_pub.add('After call to the Split Model Line API in Copy Quote',1,'N');
398: aso_debug_pub.add('Split_Quote_line: x_return_status: '|| x_return_status );
399: END IF;
400:

Line 397: aso_debug_pub.add('After call to the Split Model Line API in Copy Quote',1,'N');

393: x_msg_count => x_msg_count,
394: x_msg_data => x_msg_data );
395:
396: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
397: aso_debug_pub.add('After call to the Split Model Line API in Copy Quote',1,'N');
398: aso_debug_pub.add('Split_Quote_line: x_return_status: '|| x_return_status );
399: END IF;
400:
401: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 398: aso_debug_pub.add('Split_Quote_line: x_return_status: '|| x_return_status );

394: x_msg_data => x_msg_data );
395:
396: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
397: aso_debug_pub.add('After call to the Split Model Line API in Copy Quote',1,'N');
398: aso_debug_pub.add('Split_Quote_line: x_return_status: '|| x_return_status );
399: END IF;
400:
401: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
402:

Line 414: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

410: ELSE
411:
412: CLOSE c_config_exist;
413:
414: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
415: aso_debug_pub.add('Split_Quote_line: Model item but not configured');
416: END IF;
417:
418: l_call_do_split_line := FND_API.G_TRUE;

Line 415: aso_debug_pub.add('Split_Quote_line: Model item but not configured');

411:
412: CLOSE c_config_exist;
413:
414: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
415: aso_debug_pub.add('Split_Quote_line: Model item but not configured');
416: END IF;
417:
418: l_call_do_split_line := FND_API.G_TRUE;
419:

Line 427: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

423:
424:
425: IF l_qte_line_rec.service_item_flag = 'Y' THEN
426:
427: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
428: aso_debug_pub.add('Split_Quote_line: Split of service item line is not allowed');
429: END IF;
430:
431: x_return_status := FND_API.G_RET_STS_ERROR;

Line 428: aso_debug_pub.add('Split_Quote_line: Split of service item line is not allowed');

424:
425: IF l_qte_line_rec.service_item_flag = 'Y' THEN
426:
427: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
428: aso_debug_pub.add('Split_Quote_line: Split of service item line is not allowed');
429: END IF;
430:
431: x_return_status := FND_API.G_RET_STS_ERROR;
432:

Line 444: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

440: RAISE FND_API.G_EXC_ERROR;
441:
442: ELSIF l_qte_line_rec.serviceable_product_flag = 'Y' THEN
443:
444: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
445: aso_debug_pub.add('Split_Quote_line: Serviceable item line');
446: END IF;
447:
448: l_serviceable_item := FND_API.G_TRUE;

Line 445: aso_debug_pub.add('Split_Quote_line: Serviceable item line');

441:
442: ELSIF l_qte_line_rec.serviceable_product_flag = 'Y' THEN
443:
444: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
445: aso_debug_pub.add('Split_Quote_line: Serviceable item line');
446: END IF;
447:
448: l_serviceable_item := FND_API.G_TRUE;
449: l_call_do_split_line := FND_API.G_TRUE;

Line 460: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

456:
457:
458: IF l_call_do_split_line = FND_API.G_TRUE AND l_split_model_line = FND_API.G_FALSE THEN
459:
460: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
461: aso_debug_pub.add('Split_Quote_line: Before call to Do_Split_line');
462: END IF;
463:
464: Do_Split_line( p_qte_header_rec => p_qte_header_rec,

Line 461: aso_debug_pub.add('Split_Quote_line: Before call to Do_Split_line');

457:
458: IF l_call_do_split_line = FND_API.G_TRUE AND l_split_model_line = FND_API.G_FALSE THEN
459:
460: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
461: aso_debug_pub.add('Split_Quote_line: Before call to Do_Split_line');
462: END IF;
463:
464: Do_Split_line( p_qte_header_rec => p_qte_header_rec,
465: p_control_rec => p_control_rec,

Line 477: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

473: x_msg_count => x_msg_count,
474: x_msg_data => x_msg_data
475: );
476:
477: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
478: aso_debug_pub.add('Split_Quote_line: After call to Do_Split_line');
479: aso_debug_pub.add('Split_Quote_line: After call to Do_Split_line: x_return_status: '|| x_return_status);
480: END IF;
481:

Line 478: aso_debug_pub.add('Split_Quote_line: After call to Do_Split_line');

474: x_msg_data => x_msg_data
475: );
476:
477: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
478: aso_debug_pub.add('Split_Quote_line: After call to Do_Split_line');
479: aso_debug_pub.add('Split_Quote_line: After call to Do_Split_line: x_return_status: '|| x_return_status);
480: END IF;
481:
482: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 479: aso_debug_pub.add('Split_Quote_line: After call to Do_Split_line: x_return_status: '|| x_return_status);

475: );
476:
477: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
478: aso_debug_pub.add('Split_Quote_line: After call to Do_Split_line');
479: aso_debug_pub.add('Split_Quote_line: After call to Do_Split_line: x_return_status: '|| x_return_status);
480: END IF;
481:
482: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
483:

Line 484: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

480: END IF;
481:
482: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
483:
484: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
485: aso_debug_pub.add('Split_Quote_Line: Error in Do_Split_Line');
486: END IF;
487:
488: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 485: aso_debug_pub.add('Split_Quote_Line: Error in Do_Split_Line');

481:
482: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
483:
484: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
485: aso_debug_pub.add('Split_Quote_Line: Error in Do_Split_Line');
486: END IF;
487:
488: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
489:

Line 500: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

496: END IF;
497:
498: END IF;
499:
500: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
501: aso_debug_pub.add('Split_Quote_line: l_qte_line_rec.quote_line_id: '|| l_qte_line_rec.quote_line_id);
502: END IF;
503:
504: ELSE

Line 501: aso_debug_pub.add('Split_Quote_line: l_qte_line_rec.quote_line_id: '|| l_qte_line_rec.quote_line_id);

497:
498: END IF;
499:
500: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
501: aso_debug_pub.add('Split_Quote_line: l_qte_line_rec.quote_line_id: '|| l_qte_line_rec.quote_line_id);
502: END IF;
503:
504: ELSE
505:

Line 506: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

502: END IF;
503:
504: ELSE
505:
506: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
507: aso_debug_pub.add('Split_Quote_line: No call to Do_Split_line', 1, 'N');
508: END IF;
509:
510: END IF;

Line 507: aso_debug_pub.add('Split_Quote_line: No call to Do_Split_line', 1, 'N');

503:
504: ELSE
505:
506: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
507: aso_debug_pub.add('Split_Quote_line: No call to Do_Split_line', 1, 'N');
508: END IF;
509:
510: END IF;
511:

Line 520: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

516: --Standard check for p_commit
517:
518: IF FND_API.to_Boolean( p_commit ) THEN
519:
520: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
521: aso_debug_pub.add('Split_Quote_line: Commiting work.', 1, 'N');
522: END IF;
523: COMMIT;
524:

Line 521: aso_debug_pub.add('Split_Quote_line: Commiting work.', 1, 'N');

517:
518: IF FND_API.to_Boolean( p_commit ) THEN
519:
520: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
521: aso_debug_pub.add('Split_Quote_line: Commiting work.', 1, 'N');
522: END IF;
523: COMMIT;
524:
525: END IF;

Line 536: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

532: EXCEPTION
533:
534: WHEN FND_API.G_EXC_ERROR THEN
535:
536: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
537: aso_debug_pub.add('Split_Quote_line: WHEN FND_API.G_EXC_ERROR', 1, 'N');
538: END IF;
539:
540: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,

Line 537: aso_debug_pub.add('Split_Quote_line: WHEN FND_API.G_EXC_ERROR', 1, 'N');

533:
534: WHEN FND_API.G_EXC_ERROR THEN
535:
536: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
537: aso_debug_pub.add('Split_Quote_line: WHEN FND_API.G_EXC_ERROR', 1, 'N');
538: END IF;
539:
540: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
541: P_PKG_NAME => G_PKG_NAME,

Line 550: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

546: X_RETURN_STATUS => X_RETURN_STATUS);
547:
548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
549:
550: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
551: aso_debug_pub.add('Split_Quote_line: WHEN FND_API.G_EXC_UNEXPECTED_ERROR', 1, 'N');
552: END IF;
553:
554: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,

Line 551: aso_debug_pub.add('Split_Quote_line: WHEN FND_API.G_EXC_UNEXPECTED_ERROR', 1, 'N');

547:
548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
549:
550: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
551: aso_debug_pub.add('Split_Quote_line: WHEN FND_API.G_EXC_UNEXPECTED_ERROR', 1, 'N');
552: END IF;
553:
554: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
555: P_PKG_NAME => G_PKG_NAME,

Line 565: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

561:
562:
563: WHEN OTHERS THEN
564:
565: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
566: aso_debug_pub.add('Split_Quote_line: WHEN OTHERS', 1, 'N');
567: END IF;
568:
569: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,

Line 566: aso_debug_pub.add('Split_Quote_line: WHEN OTHERS', 1, 'N');

562:
563: WHEN OTHERS THEN
564:
565: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
566: aso_debug_pub.add('Split_Quote_line: WHEN OTHERS', 1, 'N');
567: END IF;
568:
569: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
570: P_PKG_NAME => G_PKG_NAME,

Line 696: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

692:
693: --Standard Start of API savepoint
694: SAVEPOINT DO_SPLIT_LINE_INT;
695:
696: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
697: aso_debug_pub.add('ASO_SPLIT_LINE_INT: Begin Do_Split_Line procedure', 1, 'Y');
698: END IF;
699:
700: x_return_status := fnd_api.g_ret_sts_success;

Line 697: aso_debug_pub.add('ASO_SPLIT_LINE_INT: Begin Do_Split_Line procedure', 1, 'Y');

693: --Standard Start of API savepoint
694: SAVEPOINT DO_SPLIT_LINE_INT;
695:
696: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
697: aso_debug_pub.add('ASO_SPLIT_LINE_INT: Begin Do_Split_Line procedure', 1, 'Y');
698: END IF;
699:
700: x_return_status := fnd_api.g_ret_sts_success;
701:

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

701:
702: /*
703: l_qte_header_rec := aso_utility_pvt.query_header_row(l_qte_line_rec.quote_header_id);
704:
705: IF aso_debug_pub.g_debug_flag = 'Y' THEN
706: aso_debug_pub.add('Do_Split_Line: After querying quote header row', 1, 'N');
707: END IF;
708: */
709:

Line 706: aso_debug_pub.add('Do_Split_Line: After querying quote header row', 1, 'N');

702: /*
703: l_qte_header_rec := aso_utility_pvt.query_header_row(l_qte_line_rec.quote_header_id);
704:
705: IF aso_debug_pub.g_debug_flag = 'Y' THEN
706: aso_debug_pub.add('Do_Split_Line: After querying quote header row', 1, 'N');
707: END IF;
708: */
709:
710: l_ln_quantity_before_spilt := l_qte_line_rec.quantity;

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

710: l_ln_quantity_before_spilt := l_qte_line_rec.quantity;
711: l_ln_Shipment_Tbl := aso_utility_pvt.Query_Shipment_Rows(l_qte_line_rec.quote_header_id,
712: l_qte_line_rec.quote_line_id);
713:
714: IF aso_debug_pub.g_debug_flag = 'Y' THEN
715: aso_debug_pub.add('Do_Split_Line: After querying shipment rows', 1, 'N');
716: END IF;
717:
718: l_qte_line_dtl_tbl := aso_utility_pvt.query_line_dtl_rows(l_qte_line_rec.quote_line_id);

Line 715: aso_debug_pub.add('Do_Split_Line: After querying shipment rows', 1, 'N');

711: l_ln_Shipment_Tbl := aso_utility_pvt.Query_Shipment_Rows(l_qte_line_rec.quote_header_id,
712: l_qte_line_rec.quote_line_id);
713:
714: IF aso_debug_pub.g_debug_flag = 'Y' THEN
715: aso_debug_pub.add('Do_Split_Line: After querying shipment rows', 1, 'N');
716: END IF;
717:
718: l_qte_line_dtl_tbl := aso_utility_pvt.query_line_dtl_rows(l_qte_line_rec.quote_line_id);
719: /* l_payment_tbl := aso_utility_pvt.query_payment_rows(l_qte_line_rec.quote_header_id,

Line 732: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

728: l_price_adj_attr_tbl := aso_utility_pvt.Query_Price_Adj_Attr_Rows(l_price_adj_tbl);
729:
730: FOR i IN 1 .. P_Qte_Line_Tbl.count LOOP
731:
732: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
733: aso_debug_pub.add('Do_Split_Line: Inside quote line loop', 1, 'N');
734: END IF;
735:
736: IF (p_qte_line_tbl(i).quantity <= 0) OR (p_qte_line_tbl(i).quantity > l_qte_line_rec.quantity) THEN

Line 733: aso_debug_pub.add('Do_Split_Line: Inside quote line loop', 1, 'N');

729:
730: FOR i IN 1 .. P_Qte_Line_Tbl.count LOOP
731:
732: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
733: aso_debug_pub.add('Do_Split_Line: Inside quote line loop', 1, 'N');
734: END IF;
735:
736: IF (p_qte_line_tbl(i).quantity <= 0) OR (p_qte_line_tbl(i).quantity > l_qte_line_rec.quantity) THEN
737:

Line 738: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

734: END IF;
735:
736: IF (p_qte_line_tbl(i).quantity <= 0) OR (p_qte_line_tbl(i).quantity > l_qte_line_rec.quantity) THEN
737:
738: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
739: aso_debug_pub.add('Do_Split_Line: Line quantity is <= 0 OR New quote line to be created qty > original line quantity', 1, 'N');
740: END IF;
741:
742: x_return_status := FND_API.G_RET_STS_ERROR;

Line 739: aso_debug_pub.add('Do_Split_Line: Line quantity is <= 0 OR New quote line to be created qty > original line quantity', 1, 'N');

735:
736: IF (p_qte_line_tbl(i).quantity <= 0) OR (p_qte_line_tbl(i).quantity > l_qte_line_rec.quantity) THEN
737:
738: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
739: aso_debug_pub.add('Do_Split_Line: Line quantity is <= 0 OR New quote line to be created qty > original line quantity', 1, 'N');
740: END IF;
741:
742: x_return_status := FND_API.G_RET_STS_ERROR;
743:

Line 753: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

749: RAISE FND_API.G_EXC_ERROR;
750:
751: ELSE
752:
753: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
754: aso_debug_pub.add('Do_Split_Line: Inside quote line loop Line quantity Else condition', 1, 'N');
755: END IF;
756:
757: l_to_create_quote_line_rec := l_qte_line_rec;

Line 754: aso_debug_pub.add('Do_Split_Line: Inside quote line loop Line quantity Else condition', 1, 'N');

750:
751: ELSE
752:
753: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
754: aso_debug_pub.add('Do_Split_Line: Inside quote line loop Line quantity Else condition', 1, 'N');
755: END IF;
756:
757: l_to_create_quote_line_rec := l_qte_line_rec;
758: l_to_create_quote_line_rec.quantity := p_qte_line_tbl(i).quantity;

Line 786: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

782: --and override with the input value (If exist).
783:
784: FOR j IN 1 .. P_ln_Shipment_Tbl.count LOOP
785:
786: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
787: aso_debug_pub.add('Do_Split_Line: Inside shipment loop', 1, 'N');
788: END IF;
789:
790: IF P_ln_Shipment_Tbl(j).qte_line_index = i THEN

Line 787: aso_debug_pub.add('Do_Split_Line: Inside shipment loop', 1, 'N');

783:
784: FOR j IN 1 .. P_ln_Shipment_Tbl.count LOOP
785:
786: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
787: aso_debug_pub.add('Do_Split_Line: Inside shipment loop', 1, 'N');
788: END IF;
789:
790: IF P_ln_Shipment_Tbl(j).qte_line_index = i THEN
791:

Line 792: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

788: END IF;
789:
790: IF P_ln_Shipment_Tbl(j).qte_line_index = i THEN
791:
792: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
793: aso_debug_pub.add('Do_Split_Line: Inside shipment loop, shipment record exist for given line ');
794: END IF;
795:
796: IF P_ln_Shipment_Tbl(j).ship_to_cust_account_id <> FND_API.G_MISS_NUM THEN

Line 793: aso_debug_pub.add('Do_Split_Line: Inside shipment loop, shipment record exist for given line ');

789:
790: IF P_ln_Shipment_Tbl(j).qte_line_index = i THEN
791:
792: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
793: aso_debug_pub.add('Do_Split_Line: Inside shipment loop, shipment record exist for given line ');
794: END IF;
795:
796: IF P_ln_Shipment_Tbl(j).ship_to_cust_account_id <> FND_API.G_MISS_NUM THEN
797:

Line 799: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

795:
796: IF P_ln_Shipment_Tbl(j).ship_to_cust_account_id <> FND_API.G_MISS_NUM THEN
797:
798: l_to_create_shipment_rec.ship_to_cust_account_id := P_ln_Shipment_Tbl(j).ship_to_cust_account_id;
799: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
800: aso_debug_pub.add('Do_Split_Line: l_to_create_shipment_rec.ship_to_cust_account_id :'||l_to_create_shipment_rec.ship_to_cust_account_id);
801: END IF;
802:
803: END IF;

Line 800: aso_debug_pub.add('Do_Split_Line: l_to_create_shipment_rec.ship_to_cust_account_id :'||l_to_create_shipment_rec.ship_to_cust_account_id);

796: IF P_ln_Shipment_Tbl(j).ship_to_cust_account_id <> FND_API.G_MISS_NUM THEN
797:
798: l_to_create_shipment_rec.ship_to_cust_account_id := P_ln_Shipment_Tbl(j).ship_to_cust_account_id;
799: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
800: aso_debug_pub.add('Do_Split_Line: l_to_create_shipment_rec.ship_to_cust_account_id :'||l_to_create_shipment_rec.ship_to_cust_account_id);
801: END IF;
802:
803: END IF;
804:

Line 809: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

805:
806: IF P_ln_Shipment_Tbl(j).ship_to_party_site_id <> FND_API.G_MISS_NUM THEN
807:
808: l_to_create_shipment_rec.ship_to_party_site_id := P_ln_Shipment_Tbl(j).ship_to_party_site_id;
809: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
810: aso_debug_pub.add('Do_Split_Line: l_to_create_shipment_rec.ship_to_party_site_id :'||l_to_create_shipment_rec.ship_to_party_site_id);
811: END IF;
812:
813: END IF;

Line 810: aso_debug_pub.add('Do_Split_Line: l_to_create_shipment_rec.ship_to_party_site_id :'||l_to_create_shipment_rec.ship_to_party_site_id);

806: IF P_ln_Shipment_Tbl(j).ship_to_party_site_id <> FND_API.G_MISS_NUM THEN
807:
808: l_to_create_shipment_rec.ship_to_party_site_id := P_ln_Shipment_Tbl(j).ship_to_party_site_id;
809: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
810: aso_debug_pub.add('Do_Split_Line: l_to_create_shipment_rec.ship_to_party_site_id :'||l_to_create_shipment_rec.ship_to_party_site_id);
811: END IF;
812:
813: END IF;
814:

Line 820: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

816: IF P_ln_Shipment_Tbl(j).ship_to_party_id <> FND_API.G_MISS_NUM THEN
817:
818: l_to_create_shipment_rec.ship_to_party_id := P_ln_Shipment_Tbl(j).ship_to_party_id;
819:
820: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
821: aso_debug_pub.add('Do_Split_Line: l_to_create_shipment_rec.ship_to_party_id :'||l_to_create_shipment_rec.ship_to_party_id);
822: END IF;
823:
824: END IF;

Line 821: aso_debug_pub.add('Do_Split_Line: l_to_create_shipment_rec.ship_to_party_id :'||l_to_create_shipment_rec.ship_to_party_id);

817:
818: l_to_create_shipment_rec.ship_to_party_id := P_ln_Shipment_Tbl(j).ship_to_party_id;
819:
820: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
821: aso_debug_pub.add('Do_Split_Line: l_to_create_shipment_rec.ship_to_party_id :'||l_to_create_shipment_rec.ship_to_party_id);
822: END IF;
823:
824: END IF;
825:

Line 830: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

826:
827: IF P_ln_Shipment_Tbl(j).ship_method_code <> FND_API.G_MISS_CHAR THEN
828:
829: l_to_create_shipment_rec.ship_method_code := P_ln_Shipment_Tbl(j).ship_method_code;
830: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
831: aso_debug_pub.add('Do_Split_Line: l_to_create_shipment_rec.ship_method_code :'||l_to_create_shipment_rec.ship_method_code);
832: END IF;
833:
834: END IF;

Line 831: aso_debug_pub.add('Do_Split_Line: l_to_create_shipment_rec.ship_method_code :'||l_to_create_shipment_rec.ship_method_code);

827: IF P_ln_Shipment_Tbl(j).ship_method_code <> FND_API.G_MISS_CHAR THEN
828:
829: l_to_create_shipment_rec.ship_method_code := P_ln_Shipment_Tbl(j).ship_method_code;
830: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
831: aso_debug_pub.add('Do_Split_Line: l_to_create_shipment_rec.ship_method_code :'||l_to_create_shipment_rec.ship_method_code);
832: END IF;
833:
834: END IF;
835:

Line 840: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

836:
837: IF P_ln_Shipment_Tbl(j).shipping_instructions <> FND_API.G_MISS_CHAR THEN
838:
839: l_to_create_shipment_rec.shipping_instructions := P_ln_Shipment_Tbl(j).shipping_instructions;
840: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
841: aso_debug_pub.add('Do_Split_Line: l_to_create_shipment_rec.shipping_instructions :'||l_to_create_shipment_rec.shipping_instructions);
842: END IF;
843:
844: END IF;

Line 841: aso_debug_pub.add('Do_Split_Line: l_to_create_shipment_rec.shipping_instructions :'||l_to_create_shipment_rec.shipping_instructions);

837: IF P_ln_Shipment_Tbl(j).shipping_instructions <> FND_API.G_MISS_CHAR THEN
838:
839: l_to_create_shipment_rec.shipping_instructions := P_ln_Shipment_Tbl(j).shipping_instructions;
840: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
841: aso_debug_pub.add('Do_Split_Line: l_to_create_shipment_rec.shipping_instructions :'||l_to_create_shipment_rec.shipping_instructions);
842: END IF;
843:
844: END IF;
845:

Line 850: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

846:
847: IF P_ln_Shipment_Tbl(j).packing_instructions <> FND_API.G_MISS_CHAR THEN
848:
849: l_to_create_shipment_rec.packing_instructions := P_ln_Shipment_Tbl(j).packing_instructions;
850: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
851: aso_debug_pub.add('Do_Split_Line: l_to_create_shipment_rec.packing_instructions :'||l_to_create_shipment_rec.packing_instructions);
852: END IF;
853:
854: END IF;

Line 851: aso_debug_pub.add('Do_Split_Line: l_to_create_shipment_rec.packing_instructions :'||l_to_create_shipment_rec.packing_instructions);

847: IF P_ln_Shipment_Tbl(j).packing_instructions <> FND_API.G_MISS_CHAR THEN
848:
849: l_to_create_shipment_rec.packing_instructions := P_ln_Shipment_Tbl(j).packing_instructions;
850: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
851: aso_debug_pub.add('Do_Split_Line: l_to_create_shipment_rec.packing_instructions :'||l_to_create_shipment_rec.packing_instructions);
852: END IF;
853:
854: END IF;
855:

Line 865: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

861:
862:
863: --Populate quote line details records
864:
865: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
866: aso_debug_pub.add('Do_Split_Line: l_qte_line_dtl_tbl.count :'||l_qte_line_dtl_tbl.count, 1, 'N');
867: END IF;
868:
869: FOR k IN 1 .. l_qte_line_dtl_tbl.count LOOP

Line 866: aso_debug_pub.add('Do_Split_Line: l_qte_line_dtl_tbl.count :'||l_qte_line_dtl_tbl.count, 1, 'N');

862:
863: --Populate quote line details records
864:
865: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
866: aso_debug_pub.add('Do_Split_Line: l_qte_line_dtl_tbl.count :'||l_qte_line_dtl_tbl.count, 1, 'N');
867: END IF;
868:
869: FOR k IN 1 .. l_qte_line_dtl_tbl.count LOOP
870:

Line 871: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

867: END IF;
868:
869: FOR k IN 1 .. l_qte_line_dtl_tbl.count LOOP
870:
871: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
872: aso_debug_pub.add('Do_Split_Line: Inside l_qte_line_dtl_tbl loop', 1, 'N');
873: END IF;
874:
875: l_qte_line_dtl_rec := l_qte_line_dtl_tbl(k);

Line 872: aso_debug_pub.add('Do_Split_Line: Inside l_qte_line_dtl_tbl loop', 1, 'N');

868:
869: FOR k IN 1 .. l_qte_line_dtl_tbl.count LOOP
870:
871: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
872: aso_debug_pub.add('Do_Split_Line: Inside l_qte_line_dtl_tbl loop', 1, 'N');
873: END IF;
874:
875: l_qte_line_dtl_rec := l_qte_line_dtl_tbl(k);
876: l_qte_line_dtl_rec.operation_code := 'CREATE';

Line 887: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

883: l_to_create_qte_line_dtl_tbl(nvl(l_to_create_qte_line_dtl_tbl.count,0)+1) := l_qte_line_dtl_rec;
884: END LOOP;
885:
886: --Populate payment records
887: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
888: aso_debug_pub.add('Do_Split_Line: l_payment_tbl.count :'||l_payment_tbl.count, 1, 'N');
889: END IF;
890:
891: /* FOR k IN 1 .. l_payment_tbl.count LOOP

Line 888: aso_debug_pub.add('Do_Split_Line: l_payment_tbl.count :'||l_payment_tbl.count, 1, 'N');

884: END LOOP;
885:
886: --Populate payment records
887: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
888: aso_debug_pub.add('Do_Split_Line: l_payment_tbl.count :'||l_payment_tbl.count, 1, 'N');
889: END IF;
890:
891: /* FOR k IN 1 .. l_payment_tbl.count LOOP
892:

Line 893: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

889: END IF;
890:
891: /* FOR k IN 1 .. l_payment_tbl.count LOOP
892:
893: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
894: aso_debug_pub.add('Do_Split_Line: Inside l_payment_tbl loop', 1, 'N');
895: END IF;
896:
897: l_payment_rec := l_payment_tbl(k);

Line 894: aso_debug_pub.add('Do_Split_Line: Inside l_payment_tbl loop', 1, 'N');

890:
891: /* FOR k IN 1 .. l_payment_tbl.count LOOP
892:
893: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
894: aso_debug_pub.add('Do_Split_Line: Inside l_payment_tbl loop', 1, 'N');
895: END IF;
896:
897: l_payment_rec := l_payment_tbl(k);
898: l_payment_rec.operation_code := 'CREATE';

Line 912: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

908: END LOOP; */
909:
910: --Populate sales credit records
911:
912: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
913: aso_debug_pub.add('Do_Split_Line: l_sales_credit_tbl.count :'||l_sales_credit_tbl.count, 1, 'N');
914: END IF;
915:
916: FOR k IN 1 .. l_sales_credit_tbl.count LOOP

Line 913: aso_debug_pub.add('Do_Split_Line: l_sales_credit_tbl.count :'||l_sales_credit_tbl.count, 1, 'N');

909:
910: --Populate sales credit records
911:
912: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
913: aso_debug_pub.add('Do_Split_Line: l_sales_credit_tbl.count :'||l_sales_credit_tbl.count, 1, 'N');
914: END IF;
915:
916: FOR k IN 1 .. l_sales_credit_tbl.count LOOP
917:

Line 918: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

914: END IF;
915:
916: FOR k IN 1 .. l_sales_credit_tbl.count LOOP
917:
918: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
919: aso_debug_pub.add('Do_Split_Line: Inside l_sales_credit_tbl', 1, 'N');
920: END IF;
921:
922: l_sales_credit_rec := l_sales_credit_tbl(k);

Line 919: aso_debug_pub.add('Do_Split_Line: Inside l_sales_credit_tbl', 1, 'N');

915:
916: FOR k IN 1 .. l_sales_credit_tbl.count LOOP
917:
918: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
919: aso_debug_pub.add('Do_Split_Line: Inside l_sales_credit_tbl', 1, 'N');
920: END IF;
921:
922: l_sales_credit_rec := l_sales_credit_tbl(k);
923: l_sales_credit_rec.operation_code := 'CREATE';

Line 933: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

929: END LOOP;
930:
931: --Populate price attributes records
932:
933: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
934: aso_debug_pub.add('Do_Split_Line: l_price_attr_tbl.count :'||l_price_attr_tbl.count, 1, 'N');
935: END IF;
936:
937: FOR k IN 1 .. l_price_attr_tbl.count LOOP

Line 934: aso_debug_pub.add('Do_Split_Line: l_price_attr_tbl.count :'||l_price_attr_tbl.count, 1, 'N');

930:
931: --Populate price attributes records
932:
933: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
934: aso_debug_pub.add('Do_Split_Line: l_price_attr_tbl.count :'||l_price_attr_tbl.count, 1, 'N');
935: END IF;
936:
937: FOR k IN 1 .. l_price_attr_tbl.count LOOP
938:

Line 939: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

935: END IF;
936:
937: FOR k IN 1 .. l_price_attr_tbl.count LOOP
938:
939: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
940: aso_debug_pub.add('Do_Split_Line: Inside l_price_attr_tbl loop', 1, 'N');
941: END IF;
942:
943: l_price_attr_rec := l_price_attr_tbl(k);

Line 940: aso_debug_pub.add('Do_Split_Line: Inside l_price_attr_tbl loop', 1, 'N');

936:
937: FOR k IN 1 .. l_price_attr_tbl.count LOOP
938:
939: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
940: aso_debug_pub.add('Do_Split_Line: Inside l_price_attr_tbl loop', 1, 'N');
941: END IF;
942:
943: l_price_attr_rec := l_price_attr_tbl(k);
944: l_price_attr_rec.operation_code := 'CREATE';

Line 954: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

950:
951: END LOOP;
952:
953: --Populate price adjustments records
954: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
955: aso_debug_pub.add('Do_Split_Line: l_price_adj_tbl.count :'||l_price_adj_tbl.count, 1, 'N');
956: END IF;
957:
958: FOR k IN 1 .. l_price_adj_tbl.count LOOP

Line 955: aso_debug_pub.add('Do_Split_Line: l_price_adj_tbl.count :'||l_price_adj_tbl.count, 1, 'N');

951: END LOOP;
952:
953: --Populate price adjustments records
954: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
955: aso_debug_pub.add('Do_Split_Line: l_price_adj_tbl.count :'||l_price_adj_tbl.count, 1, 'N');
956: END IF;
957:
958: FOR k IN 1 .. l_price_adj_tbl.count LOOP
959:

Line 960: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

956: END IF;
957:
958: FOR k IN 1 .. l_price_adj_tbl.count LOOP
959:
960: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
961: aso_debug_pub.add('Do_Split_Line: Inside l_price_adj_tbl loop', 1, 'N');
962: aso_debug_pub.add('l_price_adj_tbl(k).modifier_line_type_code :'||l_price_adj_tbl(k).modifier_line_type_code, 1, 'N');
963: END IF;
964:

Line 961: aso_debug_pub.add('Do_Split_Line: Inside l_price_adj_tbl loop', 1, 'N');

957:
958: FOR k IN 1 .. l_price_adj_tbl.count LOOP
959:
960: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
961: aso_debug_pub.add('Do_Split_Line: Inside l_price_adj_tbl loop', 1, 'N');
962: aso_debug_pub.add('l_price_adj_tbl(k).modifier_line_type_code :'||l_price_adj_tbl(k).modifier_line_type_code, 1, 'N');
963: END IF;
964:
965:

Line 962: aso_debug_pub.add('l_price_adj_tbl(k).modifier_line_type_code :'||l_price_adj_tbl(k).modifier_line_type_code, 1, 'N');

958: FOR k IN 1 .. l_price_adj_tbl.count LOOP
959:
960: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
961: aso_debug_pub.add('Do_Split_Line: Inside l_price_adj_tbl loop', 1, 'N');
962: aso_debug_pub.add('l_price_adj_tbl(k).modifier_line_type_code :'||l_price_adj_tbl(k).modifier_line_type_code, 1, 'N');
963: END IF;
964:
965:
966: l_price_adj_rec := l_price_adj_tbl(k);

Line 971: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

967:
968:
969: l_search_index(l_price_adj_rec.price_adjustment_id) := nvl(l_to_create_price_adj_tbl.count,0)+1; --k;
970:
971: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
972: aso_debug_pub.add('Do_Split_Line: l_search_index(' || l_price_adj_rec.price_adjustment_id || ')' || l_search_index(l_price_adj_rec.price_adjustment_id));
973: END IF;
974:
975: l_price_adj_rec.operation_code := 'CREATE';

Line 972: aso_debug_pub.add('Do_Split_Line: l_search_index(' || l_price_adj_rec.price_adjustment_id || ')' || l_search_index(l_price_adj_rec.price_adjustment_id));

968:
969: l_search_index(l_price_adj_rec.price_adjustment_id) := nvl(l_to_create_price_adj_tbl.count,0)+1; --k;
970:
971: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
972: aso_debug_pub.add('Do_Split_Line: l_search_index(' || l_price_adj_rec.price_adjustment_id || ')' || l_search_index(l_price_adj_rec.price_adjustment_id));
973: END IF;
974:
975: l_price_adj_rec.operation_code := 'CREATE';
976: l_price_adj_rec.price_adjustment_id := FND_API.G_MISS_NUM;

Line 990: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

986: END LOOP;
987:
988: FOR k IN 1 .. l_price_adj_rltship_tbl.count LOOP
989:
990: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
991: aso_debug_pub.add('Do_Split_Line: Inside l_price_adj_rltship_tbl loop', 1, 'N');
992: END IF;
993:
994: l_price_adj_rltship_rec := l_price_adj_rltship_tbl(k);

Line 991: aso_debug_pub.add('Do_Split_Line: Inside l_price_adj_rltship_tbl loop', 1, 'N');

987:
988: FOR k IN 1 .. l_price_adj_rltship_tbl.count LOOP
989:
990: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
991: aso_debug_pub.add('Do_Split_Line: Inside l_price_adj_rltship_tbl loop', 1, 'N');
992: END IF;
993:
994: l_price_adj_rltship_rec := l_price_adj_rltship_tbl(k);
995:

Line 1003: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

999:
1000: l_price_adj_rltship_rec.price_adj_index := l_search_index(l_price_adj_rltship_rec.price_adjustment_id);
1001: l_price_adj_rltship_rec.rltd_price_adj_index := l_search_index(l_price_adj_rltship_rec.rltd_price_adj_id);
1002:
1003: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1004: aso_debug_pub.add('l_price_adj_rltship_rec.price_adj_index :'||l_price_adj_rltship_rec.price_adj_index, 1, 'N');
1005: aso_debug_pub.add('l_price_adj_rltship_rec.rltd_price_adj_index :'||l_price_adj_rltship_rec.rltd_price_adj_index, 1, 'N');
1006: END IF;
1007:

Line 1004: aso_debug_pub.add('l_price_adj_rltship_rec.price_adj_index :'||l_price_adj_rltship_rec.price_adj_index, 1, 'N');

1000: l_price_adj_rltship_rec.price_adj_index := l_search_index(l_price_adj_rltship_rec.price_adjustment_id);
1001: l_price_adj_rltship_rec.rltd_price_adj_index := l_search_index(l_price_adj_rltship_rec.rltd_price_adj_id);
1002:
1003: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1004: aso_debug_pub.add('l_price_adj_rltship_rec.price_adj_index :'||l_price_adj_rltship_rec.price_adj_index, 1, 'N');
1005: aso_debug_pub.add('l_price_adj_rltship_rec.rltd_price_adj_index :'||l_price_adj_rltship_rec.rltd_price_adj_index, 1, 'N');
1006: END IF;
1007:
1008: l_price_adj_rltship_rec.operation_code := 'CREATE';

Line 1005: aso_debug_pub.add('l_price_adj_rltship_rec.rltd_price_adj_index :'||l_price_adj_rltship_rec.rltd_price_adj_index, 1, 'N');

1001: l_price_adj_rltship_rec.rltd_price_adj_index := l_search_index(l_price_adj_rltship_rec.rltd_price_adj_id);
1002:
1003: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1004: aso_debug_pub.add('l_price_adj_rltship_rec.price_adj_index :'||l_price_adj_rltship_rec.price_adj_index, 1, 'N');
1005: aso_debug_pub.add('l_price_adj_rltship_rec.rltd_price_adj_index :'||l_price_adj_rltship_rec.rltd_price_adj_index, 1, 'N');
1006: END IF;
1007:
1008: l_price_adj_rltship_rec.operation_code := 'CREATE';
1009: l_price_adj_rltship_rec.adj_relationship_id := fnd_api.g_miss_num;

Line 1028: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1024:
1025:
1026: FOR k IN 1 .. l_price_adj_attr_tbl.count LOOP
1027:
1028: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1029: aso_debug_pub.add('Do_Split_Line: Inside l_price_adj_attr_tbl loop', 1, 'N');
1030: END IF;
1031:
1032: l_price_adj_attr_rec := l_price_adj_attr_tbl(k);

Line 1029: aso_debug_pub.add('Do_Split_Line: Inside l_price_adj_attr_tbl loop', 1, 'N');

1025:
1026: FOR k IN 1 .. l_price_adj_attr_tbl.count LOOP
1027:
1028: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1029: aso_debug_pub.add('Do_Split_Line: Inside l_price_adj_attr_tbl loop', 1, 'N');
1030: END IF;
1031:
1032: l_price_adj_attr_rec := l_price_adj_attr_tbl(k);
1033:

Line 1048: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1044: l_create_price_adj_attr_tbl(nvl(l_create_price_adj_attr_tbl.count,0)+1) := l_price_adj_attr_rec;
1045:
1046: END LOOP;
1047:
1048: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1049: aso_debug_pub.add('Do_Split_Line: l_srv_line_index: '|| l_srv_line_index, 1, 'N');
1050: aso_debug_pub.add('Do_Split_Line: l_line_count: '|| l_line_count, 1, 'N');
1051: END IF;
1052:

Line 1049: aso_debug_pub.add('Do_Split_Line: l_srv_line_index: '|| l_srv_line_index, 1, 'N');

1045:
1046: END LOOP;
1047:
1048: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1049: aso_debug_pub.add('Do_Split_Line: l_srv_line_index: '|| l_srv_line_index, 1, 'N');
1050: aso_debug_pub.add('Do_Split_Line: l_line_count: '|| l_line_count, 1, 'N');
1051: END IF;
1052:
1053: IF l_srv_line_index <> l_line_count THEN

Line 1050: aso_debug_pub.add('Do_Split_Line: l_line_count: '|| l_line_count, 1, 'N');

1046: END LOOP;
1047:
1048: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1049: aso_debug_pub.add('Do_Split_Line: l_srv_line_index: '|| l_srv_line_index, 1, 'N');
1050: aso_debug_pub.add('Do_Split_Line: l_line_count: '|| l_line_count, 1, 'N');
1051: END IF;
1052:
1053: IF l_srv_line_index <> l_line_count THEN
1054:

Line 1057: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1053: IF l_srv_line_index <> l_line_count THEN
1054:
1055: l_srv_line_index := l_to_create_quote_line_tbl.LAST + 1;
1056:
1057: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1058: aso_debug_pub.add('Do_Split_Line: Inside IF l_srv_line_index <> l_line_count Condition. l_srv_line_index: '||l_srv_line_index, 1, 'N');
1059: END IF;
1060:
1061: END IF;

Line 1058: aso_debug_pub.add('Do_Split_Line: Inside IF l_srv_line_index <> l_line_count Condition. l_srv_line_index: '||l_srv_line_index, 1, 'N');

1054:
1055: l_srv_line_index := l_to_create_quote_line_tbl.LAST + 1;
1056:
1057: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1058: aso_debug_pub.add('Do_Split_Line: Inside IF l_srv_line_index <> l_line_count Condition. l_srv_line_index: '||l_srv_line_index, 1, 'N');
1059: END IF;
1060:
1061: END IF;
1062:

Line 1063: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1059: END IF;
1060:
1061: END IF;
1062:
1063: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1064: aso_debug_pub.add('Do_Split_Line: p_serviceable_item: '||p_serviceable_item, 1, 'N');
1065: END IF;
1066:
1067: IF p_serviceable_item = FND_API.G_TRUE THEN

Line 1064: aso_debug_pub.add('Do_Split_Line: p_serviceable_item: '||p_serviceable_item, 1, 'N');

1060:
1061: END IF;
1062:
1063: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1064: aso_debug_pub.add('Do_Split_Line: p_serviceable_item: '||p_serviceable_item, 1, 'N');
1065: END IF;
1066:
1067: IF p_serviceable_item = FND_API.G_TRUE THEN
1068:

Line 1071: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1067: IF p_serviceable_item = FND_API.G_TRUE THEN
1068:
1069: FOR row IN get_service_lines(l_qte_line_rec.quote_line_id) LOOP
1070:
1071: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1072: aso_debug_pub.add('Do_Split_Line: Inside service items quote line loop', 1, 'N');
1073: END IF;
1074:
1075: l_srv_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(row.quote_line_id);

Line 1072: aso_debug_pub.add('Do_Split_Line: Inside service items quote line loop', 1, 'N');

1068:
1069: FOR row IN get_service_lines(l_qte_line_rec.quote_line_id) LOOP
1070:
1071: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1072: aso_debug_pub.add('Do_Split_Line: Inside service items quote line loop', 1, 'N');
1073: END IF;
1074:
1075: l_srv_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(row.quote_line_id);
1076:

Line 1119: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1115:
1116: l_to_create_shipment_tbl(nvl(l_to_create_shipment_tbl.count,0)+1) := l_to_create_shipment_rec;
1117:
1118: --Populate service quote line details records
1119: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1120: aso_debug_pub.add('Do_Split_Line: l_srv_qte_line_dtl_tbl.count :'||l_srv_qte_line_dtl_tbl.count, 1, 'N');
1121: END IF;
1122: FOR k IN 1 .. l_srv_qte_line_dtl_tbl.count LOOP
1123:

Line 1120: aso_debug_pub.add('Do_Split_Line: l_srv_qte_line_dtl_tbl.count :'||l_srv_qte_line_dtl_tbl.count, 1, 'N');

1116: l_to_create_shipment_tbl(nvl(l_to_create_shipment_tbl.count,0)+1) := l_to_create_shipment_rec;
1117:
1118: --Populate service quote line details records
1119: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1120: aso_debug_pub.add('Do_Split_Line: l_srv_qte_line_dtl_tbl.count :'||l_srv_qte_line_dtl_tbl.count, 1, 'N');
1121: END IF;
1122: FOR k IN 1 .. l_srv_qte_line_dtl_tbl.count LOOP
1123:
1124: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1124: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1120: aso_debug_pub.add('Do_Split_Line: l_srv_qte_line_dtl_tbl.count :'||l_srv_qte_line_dtl_tbl.count, 1, 'N');
1121: END IF;
1122: FOR k IN 1 .. l_srv_qte_line_dtl_tbl.count LOOP
1123:
1124: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1125: aso_debug_pub.add('Do_Split_Line: Inside l_srv_qte_line_dtl_tbl loop', 1, 'N');
1126: END IF;
1127:
1128: l_qte_line_dtl_rec := l_srv_qte_line_dtl_tbl(k);

Line 1125: aso_debug_pub.add('Do_Split_Line: Inside l_srv_qte_line_dtl_tbl loop', 1, 'N');

1121: END IF;
1122: FOR k IN 1 .. l_srv_qte_line_dtl_tbl.count LOOP
1123:
1124: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1125: aso_debug_pub.add('Do_Split_Line: Inside l_srv_qte_line_dtl_tbl loop', 1, 'N');
1126: END IF;
1127:
1128: l_qte_line_dtl_rec := l_srv_qte_line_dtl_tbl(k);
1129: l_qte_line_dtl_rec.operation_code := 'CREATE';

Line 1140: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1136: l_to_create_qte_line_dtl_tbl(nvl(l_to_create_qte_line_dtl_tbl.count,0)+1) := l_qte_line_dtl_rec;
1137: END LOOP;
1138:
1139: --Populate Service payment records
1140: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1141: aso_debug_pub.add('Do_Split_Line: l_srv_payment_tbl.count :'||l_srv_payment_tbl.count, 1, 'N');
1142: END IF;
1143: /* FOR k IN 1 .. l_srv_payment_tbl.count LOOP
1144:

Line 1141: aso_debug_pub.add('Do_Split_Line: l_srv_payment_tbl.count :'||l_srv_payment_tbl.count, 1, 'N');

1137: END LOOP;
1138:
1139: --Populate Service payment records
1140: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1141: aso_debug_pub.add('Do_Split_Line: l_srv_payment_tbl.count :'||l_srv_payment_tbl.count, 1, 'N');
1142: END IF;
1143: /* FOR k IN 1 .. l_srv_payment_tbl.count LOOP
1144:
1145: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1145: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1141: aso_debug_pub.add('Do_Split_Line: l_srv_payment_tbl.count :'||l_srv_payment_tbl.count, 1, 'N');
1142: END IF;
1143: /* FOR k IN 1 .. l_srv_payment_tbl.count LOOP
1144:
1145: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1146: aso_debug_pub.add('Do_Split_Line: Inside l_srv_payment_tbl loop', 1, 'N');
1147: END IF;
1148:
1149: l_payment_rec := l_srv_payment_tbl(k);

Line 1146: aso_debug_pub.add('Do_Split_Line: Inside l_srv_payment_tbl loop', 1, 'N');

1142: END IF;
1143: /* FOR k IN 1 .. l_srv_payment_tbl.count LOOP
1144:
1145: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1146: aso_debug_pub.add('Do_Split_Line: Inside l_srv_payment_tbl loop', 1, 'N');
1147: END IF;
1148:
1149: l_payment_rec := l_srv_payment_tbl(k);
1150: l_payment_rec.operation_code := 'CREATE';

Line 1163: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1159:
1160: END LOOP; */
1161:
1162: --Populate service sales credit records
1163: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1164: aso_debug_pub.add('Do_Split_Line: l_srv_sales_credit_tbl.count :'||l_srv_sales_credit_tbl.count, 1, 'N');
1165: END IF;
1166:
1167: FOR k IN 1 .. l_srv_sales_credit_tbl.count LOOP

Line 1164: aso_debug_pub.add('Do_Split_Line: l_srv_sales_credit_tbl.count :'||l_srv_sales_credit_tbl.count, 1, 'N');

1160: END LOOP; */
1161:
1162: --Populate service sales credit records
1163: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1164: aso_debug_pub.add('Do_Split_Line: l_srv_sales_credit_tbl.count :'||l_srv_sales_credit_tbl.count, 1, 'N');
1165: END IF;
1166:
1167: FOR k IN 1 .. l_srv_sales_credit_tbl.count LOOP
1168:

Line 1169: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1165: END IF;
1166:
1167: FOR k IN 1 .. l_srv_sales_credit_tbl.count LOOP
1168:
1169: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1170: aso_debug_pub.add('Do_Split_Line: Inside l_srv_sales_credit_tbl', 1, 'N');
1171: END IF;
1172:
1173: l_sales_credit_rec := l_srv_sales_credit_tbl(k);

Line 1170: aso_debug_pub.add('Do_Split_Line: Inside l_srv_sales_credit_tbl', 1, 'N');

1166:
1167: FOR k IN 1 .. l_srv_sales_credit_tbl.count LOOP
1168:
1169: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1170: aso_debug_pub.add('Do_Split_Line: Inside l_srv_sales_credit_tbl', 1, 'N');
1171: END IF;
1172:
1173: l_sales_credit_rec := l_srv_sales_credit_tbl(k);
1174: l_sales_credit_rec.operation_code := 'CREATE';

Line 1183: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1179: l_to_create_sales_credit_tbl(nvl(l_to_create_sales_credit_tbl.count,0)+1) := l_sales_credit_rec;
1180: END LOOP;
1181:
1182: --Populate Service price attributes records
1183: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1184: aso_debug_pub.add('Do_Split_Line: l_srv_price_attr_tbl.count :'||l_srv_price_attr_tbl.count, 1, 'N');
1185: END IF;
1186:
1187: FOR k IN 1 .. l_srv_price_attr_tbl.count LOOP

Line 1184: aso_debug_pub.add('Do_Split_Line: l_srv_price_attr_tbl.count :'||l_srv_price_attr_tbl.count, 1, 'N');

1180: END LOOP;
1181:
1182: --Populate Service price attributes records
1183: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1184: aso_debug_pub.add('Do_Split_Line: l_srv_price_attr_tbl.count :'||l_srv_price_attr_tbl.count, 1, 'N');
1185: END IF;
1186:
1187: FOR k IN 1 .. l_srv_price_attr_tbl.count LOOP
1188:

Line 1189: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1185: END IF;
1186:
1187: FOR k IN 1 .. l_srv_price_attr_tbl.count LOOP
1188:
1189: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1190: aso_debug_pub.add('Do_Split_Line: Inside l_srv_price_attr_tbl loop', 1, 'N');
1191: END IF;
1192:
1193: l_price_attr_rec := l_srv_price_attr_tbl(k);

Line 1190: aso_debug_pub.add('Do_Split_Line: Inside l_srv_price_attr_tbl loop', 1, 'N');

1186:
1187: FOR k IN 1 .. l_srv_price_attr_tbl.count LOOP
1188:
1189: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1190: aso_debug_pub.add('Do_Split_Line: Inside l_srv_price_attr_tbl loop', 1, 'N');
1191: END IF;
1192:
1193: l_price_attr_rec := l_srv_price_attr_tbl(k);
1194: l_price_attr_rec.operation_code := 'CREATE';

Line 1203: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1199: l_to_create_price_attr_tbl(nvl(l_to_create_price_attr_tbl.count,0)+1) := l_price_attr_rec;
1200: END LOOP;
1201:
1202: --Populate Service price adjustments records
1203: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1204: aso_debug_pub.add('Do_Split_Line: l_srv_price_adj_tbl.count :'||l_srv_price_adj_tbl.count, 1, 'N');
1205: END IF;
1206: FOR k IN 1 .. l_srv_price_adj_tbl.count LOOP
1207:

Line 1204: aso_debug_pub.add('Do_Split_Line: l_srv_price_adj_tbl.count :'||l_srv_price_adj_tbl.count, 1, 'N');

1200: END LOOP;
1201:
1202: --Populate Service price adjustments records
1203: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1204: aso_debug_pub.add('Do_Split_Line: l_srv_price_adj_tbl.count :'||l_srv_price_adj_tbl.count, 1, 'N');
1205: END IF;
1206: FOR k IN 1 .. l_srv_price_adj_tbl.count LOOP
1207:
1208: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1208: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1204: aso_debug_pub.add('Do_Split_Line: l_srv_price_adj_tbl.count :'||l_srv_price_adj_tbl.count, 1, 'N');
1205: END IF;
1206: FOR k IN 1 .. l_srv_price_adj_tbl.count LOOP
1207:
1208: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1209: aso_debug_pub.add('Do_Split_Line: Inside l_srv_price_adj_tbl loop', 1, 'N');
1210: END IF;
1211:
1212: l_price_adj_rec := l_srv_price_adj_tbl(k);

Line 1209: aso_debug_pub.add('Do_Split_Line: Inside l_srv_price_adj_tbl loop', 1, 'N');

1205: END IF;
1206: FOR k IN 1 .. l_srv_price_adj_tbl.count LOOP
1207:
1208: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1209: aso_debug_pub.add('Do_Split_Line: Inside l_srv_price_adj_tbl loop', 1, 'N');
1210: END IF;
1211:
1212: l_price_adj_rec := l_srv_price_adj_tbl(k);
1213:

Line 1231: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1227:
1228:
1229: FOR k IN 1 .. l_srv_price_adj_rltship_tbl.count LOOP
1230:
1231: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1232: aso_debug_pub.add('Do_Split_Line: Inside l_srv_price_adj_rltship_tbl loop', 1, 'N');
1233: END IF;
1234:
1235: l_price_adj_rltship_rec := l_srv_price_adj_rltship_tbl(k);

Line 1232: aso_debug_pub.add('Do_Split_Line: Inside l_srv_price_adj_rltship_tbl loop', 1, 'N');

1228:
1229: FOR k IN 1 .. l_srv_price_adj_rltship_tbl.count LOOP
1230:
1231: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1232: aso_debug_pub.add('Do_Split_Line: Inside l_srv_price_adj_rltship_tbl loop', 1, 'N');
1233: END IF;
1234:
1235: l_price_adj_rltship_rec := l_srv_price_adj_rltship_tbl(k);
1236:

Line 1261: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1257:
1258:
1259: FOR k IN 1 .. l_srv_price_adj_attr_tbl.count LOOP
1260:
1261: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1262: aso_debug_pub.add('Do_Split_Line: Inside l_srv_price_adj_attr_tbl loop', 1, 'N');
1263: END IF;
1264:
1265: l_price_adj_attr_rec := l_srv_price_adj_attr_tbl(k);

Line 1262: aso_debug_pub.add('Do_Split_Line: Inside l_srv_price_adj_attr_tbl loop', 1, 'N');

1258:
1259: FOR k IN 1 .. l_srv_price_adj_attr_tbl.count LOOP
1260:
1261: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1262: aso_debug_pub.add('Do_Split_Line: Inside l_srv_price_adj_attr_tbl loop', 1, 'N');
1263: END IF;
1264:
1265: l_price_adj_attr_rec := l_srv_price_adj_attr_tbl(k);
1266:

Line 1314: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1310: l_control_rec.DEFAULTING_FLAG := FND_API.G_FALSE;
1311: l_control_rec.DEFAULTING_FWK_FLAG := 'N';
1312:
1313:
1314: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1315: aso_debug_pub.add('Do_Split_Line: Before call to Update Quote', 1, 'Y');
1316: END IF;
1317:
1318: ASO_QUOTE_PUB.Update_quote(

Line 1315: aso_debug_pub.add('Do_Split_Line: Before call to Update Quote', 1, 'Y');

1311: l_control_rec.DEFAULTING_FWK_FLAG := 'N';
1312:
1313:
1314: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1315: aso_debug_pub.add('Do_Split_Line: Before call to Update Quote', 1, 'Y');
1316: END IF;
1317:
1318: ASO_QUOTE_PUB.Update_quote(
1319: P_Api_Version_Number => 1.0,

Line 1375: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1371: X_Msg_Count => x_Msg_Count,
1372: X_Msg_Data => x_Msg_Data
1373: );
1374:
1375: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1376: aso_debug_pub.add('Do_Split_Line: After call to Update Quote');
1377: aso_debug_pub.add('Do_Split_Line: x_Return_Status :'||x_Return_Status, 1, 'N');
1378: END IF;
1379:

Line 1376: aso_debug_pub.add('Do_Split_Line: After call to Update Quote');

1372: X_Msg_Data => x_Msg_Data
1373: );
1374:
1375: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1376: aso_debug_pub.add('Do_Split_Line: After call to Update Quote');
1377: aso_debug_pub.add('Do_Split_Line: x_Return_Status :'||x_Return_Status, 1, 'N');
1378: END IF;
1379:
1380: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1377: aso_debug_pub.add('Do_Split_Line: x_Return_Status :'||x_Return_Status, 1, 'N');

1373: );
1374:
1375: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1376: aso_debug_pub.add('Do_Split_Line: After call to Update Quote');
1377: aso_debug_pub.add('Do_Split_Line: x_Return_Status :'||x_Return_Status, 1, 'N');
1378: END IF;
1379:
1380: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1381:

Line 1382: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1378: END IF;
1379:
1380: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1381:
1382: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1383: aso_debug_pub.add('Do_Split_Line: Error in Update_Quote', 1, 'N');
1384: END IF;
1385:
1386: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1383: aso_debug_pub.add('Do_Split_Line: Error in Update_Quote', 1, 'N');

1379:
1380: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1381:
1382: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1383: aso_debug_pub.add('Do_Split_Line: Error in Update_Quote', 1, 'N');
1384: END IF;
1385:
1386: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1387:

Line 1420: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1416: l_payment_tbl := aso_utility_pvt.query_payment_rows(l_qte_line_rec.quote_header_id,
1417: l_qte_line_rec.quote_line_id);
1418: END IF;
1419:
1420: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1421: aso_debug_pub.add('Do_Split_Line: l_orig_line_deleted: '|| l_orig_line_deleted);
1422: aso_debug_pub.add('Do_Split_Line: l_orig_payment_tbl.count: '|| l_orig_payment_tbl.count);
1423: aso_debug_pub.add('Do_Split_Line: l_payment_tbl.count: '|| l_payment_tbl.count);
1424: END IF;

Line 1421: aso_debug_pub.add('Do_Split_Line: l_orig_line_deleted: '|| l_orig_line_deleted);

1417: l_qte_line_rec.quote_line_id);
1418: END IF;
1419:
1420: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1421: aso_debug_pub.add('Do_Split_Line: l_orig_line_deleted: '|| l_orig_line_deleted);
1422: aso_debug_pub.add('Do_Split_Line: l_orig_payment_tbl.count: '|| l_orig_payment_tbl.count);
1423: aso_debug_pub.add('Do_Split_Line: l_payment_tbl.count: '|| l_payment_tbl.count);
1424: END IF;
1425:

Line 1422: aso_debug_pub.add('Do_Split_Line: l_orig_payment_tbl.count: '|| l_orig_payment_tbl.count);

1418: END IF;
1419:
1420: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1421: aso_debug_pub.add('Do_Split_Line: l_orig_line_deleted: '|| l_orig_line_deleted);
1422: aso_debug_pub.add('Do_Split_Line: l_orig_payment_tbl.count: '|| l_orig_payment_tbl.count);
1423: aso_debug_pub.add('Do_Split_Line: l_payment_tbl.count: '|| l_payment_tbl.count);
1424: END IF;
1425:
1426:

Line 1423: aso_debug_pub.add('Do_Split_Line: l_payment_tbl.count: '|| l_payment_tbl.count);

1419:
1420: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1421: aso_debug_pub.add('Do_Split_Line: l_orig_line_deleted: '|| l_orig_line_deleted);
1422: aso_debug_pub.add('Do_Split_Line: l_orig_payment_tbl.count: '|| l_orig_payment_tbl.count);
1423: aso_debug_pub.add('Do_Split_Line: l_payment_tbl.count: '|| l_payment_tbl.count);
1424: END IF;
1425:
1426:
1427: FOR i IN 1 .. lx_Qte_Line_Tbl.count LOOP

Line 1429: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1425:
1426:
1427: FOR i IN 1 .. lx_Qte_Line_Tbl.count LOOP
1428:
1429: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1430: aso_debug_pub.add('Do_Split_Line: lx_qte_line_tbl('||i||').quote_line_id: '|| lx_qte_line_tbl(i).quote_line_id);
1431: END IF;
1432:
1433: -- Start Copy payment record

Line 1430: aso_debug_pub.add('Do_Split_Line: lx_qte_line_tbl('||i||').quote_line_id: '|| lx_qte_line_tbl(i).quote_line_id);

1426:
1427: FOR i IN 1 .. lx_Qte_Line_Tbl.count LOOP
1428:
1429: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1430: aso_debug_pub.add('Do_Split_Line: lx_qte_line_tbl('||i||').quote_line_id: '|| lx_qte_line_tbl(i).quote_line_id);
1431: END IF;
1432:
1433: -- Start Copy payment record
1434: IF ((l_qte_line_rec.quote_line_id <> lx_Qte_Line_Tbl(i).quote_line_id) and (l_payment_tbl.count > 0)) then

Line 1435: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1431: END IF;
1432:
1433: -- Start Copy payment record
1434: IF ((l_qte_line_rec.quote_line_id <> lx_Qte_Line_Tbl(i).quote_line_id) and (l_payment_tbl.count > 0)) then
1435: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1436: aso_debug_pub.add('Do_Split_Line: Creating the payment record ', 1, 'N');
1437: END IF;
1438:
1439: l_payment_rec := l_payment_tbl(1);

Line 1436: aso_debug_pub.add('Do_Split_Line: Creating the payment record ', 1, 'N');

1432:
1433: -- Start Copy payment record
1434: IF ((l_qte_line_rec.quote_line_id <> lx_Qte_Line_Tbl(i).quote_line_id) and (l_payment_tbl.count > 0)) then
1435: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1436: aso_debug_pub.add('Do_Split_Line: Creating the payment record ', 1, 'N');
1437: END IF;
1438:
1439: l_payment_rec := l_payment_tbl(1);
1440: l_payment_rec.payment_id := null;

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

1442: l_payment_rec.quote_line_id := lx_qte_line_tbl(i).quote_line_id;
1443: l_payment_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
1444: l_payment_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
1445:
1446: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1447: aso_debug_pub.add('Do_Split_Line: Before call to copy_payment_row ', 1, 'Y');
1448: END IF;
1449:
1450: aso_copy_quote_pvt.copy_payment_row(p_payment_rec => l_payment_rec ,

Line 1447: aso_debug_pub.add('Do_Split_Line: Before call to copy_payment_row ', 1, 'Y');

1443: l_payment_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
1444: l_payment_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
1445:
1446: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1447: aso_debug_pub.add('Do_Split_Line: Before call to copy_payment_row ', 1, 'Y');
1448: END IF;
1449:
1450: aso_copy_quote_pvt.copy_payment_row(p_payment_rec => l_payment_rec ,
1451: x_return_status => x_return_status,

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

1451: x_return_status => x_return_status,
1452: x_msg_count => x_msg_count,
1453: x_msg_data => x_msg_data);
1454:
1455: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1456: aso_debug_pub.add('Copy_Header: After call to copy_payment_row: x_return_status: '||x_return_status, 1, 'Y');
1457: END IF;
1458: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1456: aso_debug_pub.add('Copy_Header: After call to copy_payment_row: x_return_status: '||x_return_status, 1, 'Y');

1452: x_msg_count => x_msg_count,
1453: x_msg_data => x_msg_data);
1454:
1455: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1456: aso_debug_pub.add('Copy_Header: After call to copy_payment_row: x_return_status: '||x_return_status, 1, 'Y');
1457: END IF;
1458: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1473: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1469: IF l_qte_line_rec.quote_line_id <> lx_Qte_Line_Tbl(i).quote_line_id
1470: and (lx_Qte_Line_Tbl(i).pricing_line_type_indicator is null or
1471: lx_Qte_Line_Tbl(i).pricing_line_type_indicator = fnd_api.g_miss_char) THEN
1472:
1473: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1474: aso_debug_pub.add('Do_Split_Line: Before call to Copy_Attachments');
1475: END IF;
1476:
1477: ASO_ATTACHMENT_INT.Copy_Attachments(

Line 1474: aso_debug_pub.add('Do_Split_Line: Before call to Copy_Attachments');

1470: and (lx_Qte_Line_Tbl(i).pricing_line_type_indicator is null or
1471: lx_Qte_Line_Tbl(i).pricing_line_type_indicator = fnd_api.g_miss_char) THEN
1472:
1473: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1474: aso_debug_pub.add('Do_Split_Line: Before call to Copy_Attachments');
1475: END IF;
1476:
1477: ASO_ATTACHMENT_INT.Copy_Attachments(
1478: p_api_version => 1.0,

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

1486: x_msg_count => x_msg_count,
1487: x_msg_data => x_msg_data
1488: );
1489:
1490: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1491: aso_debug_pub.add('Do_Split_Line: After call to Copy_Attachments');
1492: aso_debug_pub.add('Do_Split_Line: x_return_status: '|| x_return_status);
1493: END IF;
1494:

Line 1491: aso_debug_pub.add('Do_Split_Line: After call to Copy_Attachments');

1487: x_msg_data => x_msg_data
1488: );
1489:
1490: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1491: aso_debug_pub.add('Do_Split_Line: After call to Copy_Attachments');
1492: aso_debug_pub.add('Do_Split_Line: x_return_status: '|| x_return_status);
1493: END IF;
1494:
1495: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1492: aso_debug_pub.add('Do_Split_Line: x_return_status: '|| x_return_status);

1488: );
1489:
1490: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1491: aso_debug_pub.add('Do_Split_Line: After call to Copy_Attachments');
1492: aso_debug_pub.add('Do_Split_Line: x_return_status: '|| x_return_status);
1493: END IF;
1494:
1495: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1496:

Line 1497: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1493: END IF;
1494:
1495: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1496:
1497: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1498: aso_debug_pub.add('Do_Split_Line: Error in Copy_Attachments');
1499: END IF;
1500:
1501: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1498: aso_debug_pub.add('Do_Split_Line: Error in Copy_Attachments');

1494:
1495: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1496:
1497: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1498: aso_debug_pub.add('Do_Split_Line: Error in Copy_Attachments');
1499: END IF;
1500:
1501: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1502:

Line 1513: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1509: END IF;
1510:
1511: END IF;
1512:
1513: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1514: aso_debug_pub.add('Do_Split_Line: Attachment copied from quote_line_id: '||l_map_qte_line_tbl(i).quote_line_id);
1515: aso_debug_pub.add('Do_Split_Line: Attachment copied to quote_line_id: '||lx_qte_line_tbl(i).quote_line_id);
1516: END IF;
1517:

Line 1514: aso_debug_pub.add('Do_Split_Line: Attachment copied from quote_line_id: '||l_map_qte_line_tbl(i).quote_line_id);

1510:
1511: END IF;
1512:
1513: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1514: aso_debug_pub.add('Do_Split_Line: Attachment copied from quote_line_id: '||l_map_qte_line_tbl(i).quote_line_id);
1515: aso_debug_pub.add('Do_Split_Line: Attachment copied to quote_line_id: '||lx_qte_line_tbl(i).quote_line_id);
1516: END IF;
1517:
1518:

Line 1515: aso_debug_pub.add('Do_Split_Line: Attachment copied to quote_line_id: '||lx_qte_line_tbl(i).quote_line_id);

1511: END IF;
1512:
1513: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1514: aso_debug_pub.add('Do_Split_Line: Attachment copied from quote_line_id: '||l_map_qte_line_tbl(i).quote_line_id);
1515: aso_debug_pub.add('Do_Split_Line: Attachment copied to quote_line_id: '||lx_qte_line_tbl(i).quote_line_id);
1516: END IF;
1517:
1518:
1519: -- changes for sales supp enhancement see bug 2940126

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

1516: END IF;
1517:
1518:
1519: -- changes for sales supp enhancement see bug 2940126
1520: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1521: aso_debug_pub.add('Do_Split_Line: Before call to Copy_Line_Level_Sales_Supp');
1522: END IF;
1523:
1524: ASO_COPY_QUOTE_PVT.INSERT_SALES_SUPP_DATA

Line 1521: aso_debug_pub.add('Do_Split_Line: Before call to Copy_Line_Level_Sales_Supp');

1517:
1518:
1519: -- changes for sales supp enhancement see bug 2940126
1520: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1521: aso_debug_pub.add('Do_Split_Line: Before call to Copy_Line_Level_Sales_Supp');
1522: END IF;
1523:
1524: ASO_COPY_QUOTE_PVT.INSERT_SALES_SUPP_DATA
1525: (

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

1531: X_Return_Status => x_return_status,
1532: X_Msg_Count => X_Msg_Count,
1533: X_Msg_Data => X_Msg_Data );
1534:
1535: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1536: aso_debug_pub.add('Do_Split_Line: After call to Copy_Line_Level_Sales_Supp');
1537: aso_debug_pub.add('Do_Split_Line: x_return_status: '|| x_return_status);
1538: END IF;
1539:

Line 1536: aso_debug_pub.add('Do_Split_Line: After call to Copy_Line_Level_Sales_Supp');

1532: X_Msg_Count => X_Msg_Count,
1533: X_Msg_Data => X_Msg_Data );
1534:
1535: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1536: aso_debug_pub.add('Do_Split_Line: After call to Copy_Line_Level_Sales_Supp');
1537: aso_debug_pub.add('Do_Split_Line: x_return_status: '|| x_return_status);
1538: END IF;
1539:
1540: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1537: aso_debug_pub.add('Do_Split_Line: x_return_status: '|| x_return_status);

1533: X_Msg_Data => X_Msg_Data );
1534:
1535: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1536: aso_debug_pub.add('Do_Split_Line: After call to Copy_Line_Level_Sales_Supp');
1537: aso_debug_pub.add('Do_Split_Line: x_return_status: '|| x_return_status);
1538: END IF;
1539:
1540: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1541:

Line 1542: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1538: END IF;
1539:
1540: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1541:
1542: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1543: aso_debug_pub.add('Do_Split_Line: Error in Copy_Line_Level_Sales_Supp');
1544: END IF;
1545:
1546: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1543: aso_debug_pub.add('Do_Split_Line: Error in Copy_Line_Level_Sales_Supp');

1539:
1540: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1541:
1542: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1543: aso_debug_pub.add('Do_Split_Line: Error in Copy_Line_Level_Sales_Supp');
1544: END IF;
1545:
1546: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1547:

Line 1564: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1560: END LOOP;
1561:
1562: ELSE
1563:
1564: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1565: aso_debug_pub.add('Do_Split_Line: No call made to Update_Quote');
1566: END IF;
1567:
1568: END IF;

Line 1565: aso_debug_pub.add('Do_Split_Line: No call made to Update_Quote');

1561:
1562: ELSE
1563:
1564: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1565: aso_debug_pub.add('Do_Split_Line: No call made to Update_Quote');
1566: END IF;
1567:
1568: END IF;
1569:

Line 1579: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1575: EXCEPTION
1576:
1577: WHEN FND_API.G_EXC_ERROR THEN
1578:
1579: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1580: aso_debug_pub.add('Do_Split_Line: WHEN FND_API.G_EXC_ERROR', 1, 'N');
1581: END IF;
1582:
1583: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,

Line 1580: aso_debug_pub.add('Do_Split_Line: WHEN FND_API.G_EXC_ERROR', 1, 'N');

1576:
1577: WHEN FND_API.G_EXC_ERROR THEN
1578:
1579: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1580: aso_debug_pub.add('Do_Split_Line: WHEN FND_API.G_EXC_ERROR', 1, 'N');
1581: END IF;
1582:
1583: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
1584: P_PKG_NAME => G_PKG_NAME,

Line 1594: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1590: );
1591:
1592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1593:
1594: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1595: aso_debug_pub.add('Do_Split_Line: WHEN FND_API.G_EXC_UNEXPECTED_ERROR', 1, 'N');
1596: END IF;
1597:
1598: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,

Line 1595: aso_debug_pub.add('Do_Split_Line: WHEN FND_API.G_EXC_UNEXPECTED_ERROR', 1, 'N');

1591:
1592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1593:
1594: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1595: aso_debug_pub.add('Do_Split_Line: WHEN FND_API.G_EXC_UNEXPECTED_ERROR', 1, 'N');
1596: END IF;
1597:
1598: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
1599: P_PKG_NAME => G_PKG_NAME,

Line 1609: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1605: );
1606:
1607: WHEN OTHERS THEN
1608:
1609: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1610: aso_debug_pub.add('Do_Split_Line: WHEN OTHERS', 1, 'N');
1611: END IF;
1612:
1613: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,

Line 1610: aso_debug_pub.add('Do_Split_Line: WHEN OTHERS', 1, 'N');

1606:
1607: WHEN OTHERS THEN
1608:
1609: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1610: aso_debug_pub.add('Do_Split_Line: WHEN OTHERS', 1, 'N');
1611: END IF;
1612:
1613: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
1614: P_PKG_NAME => G_PKG_NAME,