[Home] [Help]
PACKAGE BODY: APPS.ASO_DEFAULTING_INT
Source
1 PACKAGE BODY ASO_DEFAULTING_INT AS
2 /* $Header: asoidefb.pls 120.7 2005/08/11 01:34:33 appldev noship $ */
3 -- Package name : ASO_DEFAULTING_INT
4 -- Purpose :
5 -- History :
6 -- NOTE :
7 -- End of Comments
8
9
10 G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_DEFAULTING_INT';
11
12
13 PROCEDURE Default_Entity (
14 P_API_VERSION IN NUMBER,
15 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
16 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
17 P_CONTROL_REC IN CONTROL_REC_TYPE
18 := G_MISS_CONTROL_REC,
19 P_DATABASE_OBJECT_NAME IN VARCHAR2,
20 P_TRIGGER_ATTRIBUTES_TBL IN ATTRIBUTE_CODES_TBL_TYPE
21 := G_MISS_ATTRIBUTE_CODES_TBL,
22 P_QUOTE_HEADER_REC IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE
23 := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
24 P_OPP_QTE_HEADER_REC IN ASO_OPP_QTE_PUB.OPP_QTE_IN_REC_TYPE
25 := ASO_OPP_QTE_PUB.G_MISS_OPP_QTE_IN_REC,
26 P_HEADER_MISC_REC IN HEADER_MISC_REC_TYPE
27 := G_MISS_HEADER_MISC_REC,
28 P_HEADER_SHIPMENT_REC IN ASO_QUOTE_PUB.SHIPMENT_REC_TYPE
29 := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,
30 P_HEADER_PAYMENT_REC IN ASO_QUOTE_PUB.PAYMENT_REC_TYPE
31 := ASO_QUOTE_PUB.G_MISS_PAYMENT_REC,
32 P_HEADER_TAX_DETAIL_REC IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE
33 := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_REC,
34 P_QUOTE_LINE_REC IN ASO_QUOTE_PUB.QTE_LINE_REC_TYPE
35 := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC,
36 P_LINE_MISC_REC IN LINE_MISC_REC_TYPE
37 := G_MISS_LINE_MISC_REC,
38 P_LINE_SHIPMENT_REC IN ASO_QUOTE_PUB.SHIPMENT_REC_TYPE
39 := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,
40 P_LINE_PAYMENT_REC IN ASO_QUOTE_PUB.PAYMENT_REC_TYPE
41 := ASO_QUOTE_PUB.G_MISS_PAYMENT_REC,
42 P_LINE_TAX_DETAIL_REC IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE
43 := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_REC,
44 X_QUOTE_HEADER_REC OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
45 X_HEADER_MISC_REC OUT NOCOPY /* file.sql.39 change */ HEADER_MISC_REC_TYPE,
46 X_HEADER_SHIPMENT_REC OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.SHIPMENT_REC_TYPE,
47 X_HEADER_PAYMENT_REC OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PAYMENT_REC_TYPE,
48 X_HEADER_TAX_DETAIL_REC OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
49 X_QUOTE_LINE_REC OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.QTE_LINE_REC_TYPE,
50 X_LINE_MISC_REC OUT NOCOPY /* file.sql.39 change */ LINE_MISC_REC_TYPE,
51 X_LINE_SHIPMENT_REC OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.SHIPMENT_REC_TYPE,
52 X_LINE_PAYMENT_REC OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PAYMENT_REC_TYPE,
53 X_LINE_TAX_DETAIL_REC OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
54 X_CHANGED_FLAG OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
55 X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
56 X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
57 X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2
58 )
59
60 IS
61
62 l_api_name CONSTANT VARCHAR2 ( 30 ) := 'Default_Entity';
63
64 l_quote_header_rec ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
65 l_header_misc_rec HEADER_MISC_REC_TYPE;
66 l_opp_qte_header_rec ASO_OPP_QTE_PUB.OPP_QTE_IN_REC_TYPE;
67 l_header_shipment_rec ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
68 l_header_payment_rec ASO_QUOTE_PUB.PAYMENT_REC_TYPE;
69 l_header_tax_detail_rec ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE;
70 l_quote_line_rec ASO_QUOTE_PUB.QTE_LINE_REC_TYPE;
71 l_line_misc_rec LINE_MISC_REC_TYPE;
72 l_line_shipment_rec ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
73 l_line_payment_rec ASO_QUOTE_PUB.PAYMENT_REC_TYPE;
74 l_line_tax_detail_rec ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE;
75
76 l_Qte_Header_Row_Rec ASO_AK_Quote_Header_V%Rowtype;
77 lx_Qte_Header_Row_Rec ASO_AK_Quote_Header_V%Rowtype;
78 l_Qte_Opportunity_Row_Rec ASO_AK_Quote_Oppty_V%Rowtype;
79 lx_Qte_Opportunity_Row_Rec ASO_AK_Quote_Oppty_V%Rowtype;
80 l_Qte_Line_Row_Rec ASO_AK_Quote_Line_V%Rowtype;
81 lx_Qte_Line_Row_Rec ASO_AK_Quote_Line_V%Rowtype;
82
83 l_triggers_id_tbl ASO_DEFAULTING_INT.ATTRIBUTE_IDS_TBL_TYPE;
84
85 l_entity_code VARCHAR2(15);
86 l_dependency_flag VARCHAR2(1);
87
88 l_msg_count_start NUMBER;
89 l_msg_count NUMBER;
90 l_msg_data VARCHAR2(2000);
91 l_org_id NUMBER; -- Variable to store ORG_ID Yogeshwar (MOAC)
92 l_valid_org_id NUMBER; --New variable to store ORG_ID value Yogeshwar (MOAC)
93
94
95 BEGIN
96
97 -- Standard Start of API savepoint
98 SAVEPOINT DEFAULT_ENTITY_INT;
99
100 aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
101
102 -- Initialize message list if p_init_msg_list is set to TRUE.
103 IF FND_API.to_Boolean( p_init_msg_list )
104 THEN
105 FND_MSG_PUB.initialize;
106 END IF;
107
108 -- Initialize API return status to SUCCESS
109 x_return_status := FND_API.G_RET_STS_SUCCESS;
110
111 --
112 -- API body
113 --
114
115 l_Quote_Header_Rec := p_Quote_Header_Rec;
116 l_Header_Misc_Rec := p_Header_Misc_Rec;
117 l_Opp_Qte_Header_Rec := p_Opp_Qte_Header_Rec;
118 l_Header_Shipment_Rec := p_Header_Shipment_Rec;
119 l_Header_Payment_Rec := p_Header_Payment_Rec;
120 l_Header_Tax_Detail_Rec := p_Header_Tax_Detail_Rec;
121 l_Quote_Line_Rec := p_Quote_Line_Rec;
122 l_Line_Misc_Rec := p_Line_Misc_Rec;
123 l_Line_Shipment_Rec := p_Line_Shipment_Rec;
124 l_Line_Payment_Rec := p_Line_Payment_Rec;
125 l_Line_Tax_Detail_Rec := p_Line_Tax_Detail_Rec;
126
127 l_dependency_flag := p_control_rec.dependency_flag;
128
129 ASO_DEPENDENCY_UTIL.Attribute_Code_To_Id
130 (
131 P_ATTRIBUTE_CODES_TBL => p_trigger_attributes_tbl
132 , P_DATABASE_OBJECT_NAME => p_database_object_name
133 , X_ATTRIBUTE_IDS_TBL => l_triggers_id_tbl
134 );
135
136
137 IF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
138 l_entity_code := 'QUOTE_OPPTY';
139
140 IF p_control_rec.defaulting_flow_code like 'CREATE%' THEN
141 l_dependency_flag := FND_API.G_FALSE;
142
143 IF l_Quote_Header_Rec.Created_By = FND_API.G_MISS_NUM OR l_Quote_Header_Rec.Created_By IS NULL THEN
144 l_Quote_Header_Rec.Created_By := FND_GLOBAL.User_Id;
145 END IF;
146
147 --Commented Code Start Yogeshwar (MOAC)
148 /* IF l_Quote_Header_Rec.Org_Id = FND_API.G_MISS_NUM OR l_Quote_Header_Rec.Org_Id IS NULL THEN
149 IF SUBSTRB(USERENV('CLIENT_INFO'),1,1) <> ' ' THEN
150 l_Quote_Header_Rec.Org_Id := TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),1,10));
151 END IF;
152 END IF;
153 */
154 --Commented Code End Yogeshwar (MOAC)
155
156 --New Code Start Yogeshwar (MOAC)
157 -- Commented as per bug 4548593
158 /*
159 If l_Quote_Header_Rec.Org_Id IS NULL THEN
160 l_org_id := FND_API.G_MISS_NUM;
161 Else
162 l_org_id := l_Quote_Header_Rec.Org_Id;
163 End if;
164 l_valid_org_id:= MO_GLOBAL.get_valid_org(l_org_id);
165 IF l_valid_org_id is NULL then
166 x_return_status := FND_API.G_RET_STS_ERROR;
167 RAISE FND_API.G_EXC_ERROR;
168 else
169 l_Quote_Header_Rec.Org_Id := l_valid_org_id;
170
171 End if;
172 */
173 --New Code End Yogeshwar (MOAC)
174
175 END IF;
176
177 ELSIF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN
178 l_entity_code := 'QUOTE_HEADER';
179
180 IF p_control_rec.defaulting_flow_code like 'CREATE%' THEN
181 l_dependency_flag := FND_API.G_FALSE;
182 IF l_Quote_Header_Rec.Created_By = FND_API.G_MISS_NUM OR l_Quote_Header_Rec.Created_By IS NULL THEN
183 l_Quote_Header_Rec.Created_By := FND_GLOBAL.User_Id;
184 END IF;
185
186 --Commented Code Start (MOAC)
187 /*
188 IF l_Quote_Header_Rec.Org_Id = FND_API.G_MISS_NUM OR l_Quote_Header_Rec.Org_Id IS NULL THEN
189 IF SUBSTRB(USERENV('CLIENT_INFO'),1,1) <> ' ' THEN
190 l_Quote_Header_Rec.Org_Id := TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),1,10));
191 END IF;
192 END IF;
193 */
194 --Commented Code End Yogeshwar (MOAC)
195
196 --New Code Start Yogeshwar (MOAC)
197 -- Commented as per bug 4548593
198 /*
199 If l_Quote_Header_Rec.Org_Id IS NULL THEN
200 l_org_id := FND_API.G_MISS_NUM;
201 Else
202 l_org_id := l_Quote_Header_Rec.Org_Id;
203 End if;
204 l_valid_org_id:= MO_GLOBAL.get_valid_org(l_org_id);
205 if l_valid_org_id is NULL then
206 x_return_status := FND_API.G_RET_STS_ERROR;
207 RAISE FND_API.G_EXC_ERROR;
208 Else
209 l_Quote_Header_Rec.Org_Id := l_valid_org_id;
210 End if;
211 */
212 --New Code End Yogeshwar (MOAC)
213
214 END IF;
215
216 ELSIF p_database_object_name = 'ASO_AK_QUOTE_LINE_V' THEN
217 l_entity_code := 'QUOTE_LINE';
218
219 IF p_control_rec.defaulting_flow_code like 'CREATE%' THEN
220 l_dependency_flag := FND_API.G_FALSE;
221 IF l_Quote_Line_Rec.Created_By = FND_API.G_MISS_NUM OR l_Quote_Line_Rec.Created_By IS NULL THEN
222 l_Quote_Line_Rec.Created_By := FND_GLOBAL.User_Id;
223 END IF;
224
225 --Commented Code Start Yogeshwar (MOAC)
226 /*
227 IF l_Quote_Line_Rec.Org_Id = FND_API.G_MISS_NUM OR l_Quote_Line_Rec.Org_Id IS NULL THEN
228 IF SUBSTRB(USERENV('CLIENT_INFO'),1,1) <> ' ' THEN
229 l_Quote_Line_Rec.Org_Id := TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),1,10));
230 END IF;
231 END IF;
232 */
233 --Commented Code End Yogeshwar (MOAC)
234
235 --New Code start yogeshwar (MOAC)
236 -- Commented as per bug 4548593
237 /*
238 If l_Quote_Line_Rec.Org_Id IS NULL THEN
239 l_org_id := FND_API.G_MISS_NUM;
240 Else
241 l_org_id := l_Quote_Line_Rec.Org_Id;
242 End if;
243 l_valid_org_id:= MO_GLOBAL.get_valid_org(l_org_id);
244 if l_valid_org_id is NULL then
245 x_return_status := FND_API.G_RET_STS_ERROR;
246 RAISE FND_API.G_EXC_ERROR;
247 else
248 l_Quote_Header_Rec.Org_Id := l_valid_org_id;
249 End if;
250 */
251 --New Code End Yogeshwar (MOAC)
252
253 END IF;
254
255 ELSE
256 FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
257 FND_MESSAGE.Set_Token('ID', p_database_object_name, FALSE);
258 FND_MSG_PUB.ADD;
259 RAISE FND_API.G_EXC_ERROR;
260 END IF;
261
262 IF p_control_rec.defaulting_flow_code like 'CREATE%' THEN
263 l_dependency_flag := FND_API.G_FALSE;
264
265 END IF;
266
267
268 ASO_DEFAULTING_UTIL.Initialize_Row_Type
269 (
270 P_Entity_Code => l_entity_code,
271 P_Qte_Header_Row_Rec => l_Qte_Header_Row_Rec,
272 P_Qte_Opportunity_Row_Rec => l_Qte_Opportunity_Row_Rec,
273 P_Qte_Line_Row_Rec => l_Qte_Line_Row_Rec);
274
275
276 ASO_DEFAULTING_UTIL.Api_Rec_To_Row_Type
277 (
278 P_Entity_Code => l_entity_code,
279 P_Quote_Header_Rec => l_Quote_Header_Rec,
280 P_Header_Shipment_Rec => l_Header_Shipment_Rec,
281 P_Header_Payment_Rec => l_Header_Payment_Rec,
282 P_Quote_Line_Rec => l_Quote_Line_Rec,
283 P_Line_Shipment_Rec => l_Line_Shipment_Rec,
284 P_Line_Payment_Rec => l_Line_Payment_Rec,
285 P_Control_Rec => p_Control_Rec,
286 P_Opp_Qte_Header_Rec => l_Opp_Qte_Header_Rec,
287 P_Header_Misc_Rec => l_Header_Misc_Rec,
288 P_Header_Tax_Detail_Rec => l_Header_Tax_Detail_Rec,
289 P_Line_Misc_Rec => l_Line_Misc_Rec,
290 P_Line_Tax_Detail_Rec => l_Line_Tax_Detail_Rec,
291 X_Qte_Header_Row_Rec => l_Qte_Header_Row_Rec,
292 X_Qte_Opportunity_Row_Rec => l_Qte_Opportunity_Row_Rec,
293 X_Qte_Line_Row_Rec => l_Qte_Line_Row_Rec);
294
295 IF l_dependency_flag = FND_API.G_TRUE THEN
296
297 IF l_entity_code = 'QUOTE_HEADER' THEN
298
299 ASO_QUOTE_HEADER_DEP_HDLR.Get_Dependent_Attributes_Proc
300 (
301 p_init_msg_list => p_init_msg_list,
302 p_trigger_record => l_Qte_Header_Row_Rec,
303 p_triggers_id_tbl => l_triggers_id_tbl,
304 p_control_record => p_control_rec,
305 x_dependent_record => lx_Qte_Header_Row_Rec,
306 x_return_status => x_return_status,
307 x_msg_count => x_msg_count,
308 x_msg_data => x_msg_data );
309
310 IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
311 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
312 ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
313 RAISE FND_API.G_EXC_ERROR;
314 END IF;
315 l_Qte_Header_Row_Rec := lx_Qte_Header_Row_Rec; --Nocopy changes
316 X_Changed_Flag := FND_API.G_TRUE;
317
318 END IF;
319
320 IF l_entity_code = 'QUOTE_LINE' THEN
321
322 ASO_QUOTE_LINE_DEP_HDLR.Get_Dependent_Attributes_Proc
323 (
324 p_init_msg_list => p_init_msg_list,
325 p_trigger_record => l_Qte_Line_Row_Rec,
326 p_triggers_id_tbl => l_triggers_id_tbl,
327 p_control_record => p_control_rec,
328 x_dependent_record => lx_Qte_Line_Row_Rec,
329 x_return_status => x_return_status,
330 x_msg_count => x_msg_count,
331 x_msg_data => x_msg_data );
332
333 IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
334 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335 ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
336 RAISE FND_API.G_EXC_ERROR;
337 END IF;
338 l_Qte_Line_Row_Rec := lx_Qte_Line_Row_Rec; --Nocopy changes
339 X_Changed_Flag := FND_API.G_TRUE;
340
341 END IF;
342
343 END IF; -- Dependency Flag
344
345 OE_MSG_PUB.Count_And_Get
346 ( p_count => l_msg_count_start,
347 p_data => l_msg_data
348 );
349
350 IF aso_debug_pub.g_debug_flag = 'Y' THEN
351 aso_debug_pub.add('Before Defaulting HDLR:l_msg_count_start: ' || l_msg_count_start,1,'N');
352 END IF;
353
354 IF p_control_rec.defaulting_flag = FND_API.G_TRUE THEN
355
356 IF l_entity_code = 'QUOTE_HEADER' THEN
357
358 IF aso_debug_pub.g_debug_flag = 'Y' THEN
359 aso_debug_pub.add('############# BEFORE QUOTE_HEADER DEFAULT HDLR START #############' ,1,'N');
360 aso_debug_pub.add('QUOTE_HEADER.APPLICATION_TYPE_CODE: ' || l_Qte_Header_Row_Rec.Q_APPLICATION_TYPE_CODE,1,'N');
361 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE1: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE1,1,'N');
362 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE10: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE10,1,'N');
363 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE11: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE11,1,'N');
364 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE12: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE12,1,'N');
365 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE13: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE13,1,'N');
366 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE14: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE14,1,'N');
367 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE15: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE15,1,'N');
368 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE16: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE16,1,'N');
369 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE17: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE17,1,'N');
370 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE18: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE18,1,'N');
371 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE19: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE19,1,'N');
372 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE2: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE2,1,'N');
373 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE20: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE20,1,'N');
374 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE3: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE3,1,'N');
375 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE4: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE4,1,'N');
376 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE5: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE5,1,'N');
377 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE6: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE6,1,'N');
378 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE7: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE7,1,'N');
379 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE8: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE8,1,'N');
380 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE9: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE9,1,'N');
381 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE_CATEGORY: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE_CATEGORY,1,'N');
382 aso_debug_pub.add('QUOTE_HEADER.AUTOMATIC_PRICE_FLAG: ' || l_Qte_Header_Row_Rec.Q_AUTOMATIC_PRICE_FLAG,1,'N');
383 aso_debug_pub.add('QUOTE_HEADER.AUTOMATIC_TAX_FLAG: ' || l_Qte_Header_Row_Rec.Q_AUTOMATIC_TAX_FLAG,1,'N');
384 aso_debug_pub.add('QUOTE_HEADER.CONTRACT_ID: ' || l_Qte_Header_Row_Rec.Q_CONTRACT_ID,1,'N');
385 aso_debug_pub.add('QUOTE_HEADER.CONTRACT_TEMPLATE_ID: ' || l_Qte_Header_Row_Rec.Q_CONTRACT_TEMPLATE_ID,1,'N');
386 aso_debug_pub.add('QUOTE_HEADER.CREATED_BY: ' || l_Qte_Header_Row_Rec.Q_CREATED_BY,1,'N');
387 aso_debug_pub.add('QUOTE_HEADER.CREDIT_CARD_CODE: ' || l_Qte_Header_Row_Rec.Q_CREDIT_CARD_CODE,1,'N');
388 aso_debug_pub.add('QUOTE_HEADER.CREDIT_CARD_EXPIRATION_DATE: ' || l_Qte_Header_Row_Rec.Q_CREDIT_CARD_EXP_DATE,1,'N');
389 aso_debug_pub.add('QUOTE_HEADER.CREDIT_CARD_HOLDER_NAME: ' || l_Qte_Header_Row_Rec.Q_CREDIT_CARD_HLD_NAME,1,'N');
390 aso_debug_pub.add('QUOTE_HEADER.CURRENCY_CODE: ' || l_Qte_Header_Row_Rec.Q_CURRENCY_CODE,1,'N');
391 aso_debug_pub.add('QUOTE_HEADER.CUST_ACCOUNT_ID: ' || l_Qte_Header_Row_Rec.Q_CUST_ACCOUNT_ID,1,'N');
392 aso_debug_pub.add('QUOTE_HEADER.CUST_PARTY_ID: ' || l_Qte_Header_Row_Rec.Q_CUST_PARTY_ID,1,'N');
393 aso_debug_pub.add('QUOTE_HEADER.CUST_PO_NUMBER: ' || l_Qte_Header_Row_Rec.Q_CUST_PO_NUMBER,1,'N');
394 aso_debug_pub.add('QUOTE_HEADER.DEMAND_CLASS_CODE: ' || l_Qte_Header_Row_Rec.Q_DEMAND_CLASS_CODE,1,'N');
395 aso_debug_pub.add('QUOTE_HEADER.END_CUSTOMER_CUST_ACCOUNT_ID: ' || l_Qte_Header_Row_Rec.Q_END_CUST_CUST_ACCT_ID,1,'N');
396 aso_debug_pub.add('QUOTE_HEADER.END_CUSTOMER_CUST_PARTY_ID: ' || l_Qte_Header_Row_Rec.Q_END_CUST_CUST_PTY_ID,1,'N');
397 aso_debug_pub.add('QUOTE_HEADER.END_CUSTOMER_PARTY_ID: ' || l_Qte_Header_Row_Rec.Q_END_CUST_PTY_ID,1,'N');
398 aso_debug_pub.add('QUOTE_HEADER.END_CUSTOMER_PARTY_SITE_ID: ' || l_Qte_Header_Row_Rec.Q_END_CUST_PTY_SITE_ID,1,'N');
399 aso_debug_pub.add('QUOTE_HEADER.FOB_CODE: ' || l_Qte_Header_Row_Rec.Q_FOB_CODE,1,'N');
400 aso_debug_pub.add('QUOTE_HEADER.FREIGHT_TERMS_CODE: ' || l_Qte_Header_Row_Rec.Q_FREIGHT_TERMS_CODE,1,'N');
401 aso_debug_pub.add('QUOTE_HEADER.INVOICE_TO_CUST_ACCOUNT_ID: ' || l_Qte_Header_Row_Rec.Q_INV_TO_CUST_ACCT_ID,1,'N');
402 aso_debug_pub.add('QUOTE_HEADER.INVOICE_TO_CUST_PARTY_ID: ' || l_Qte_Header_Row_Rec.Q_INV_TO_CUST_PTY_ID,1,'N');
403 aso_debug_pub.add('QUOTE_HEADER.INVOICE_TO_PARTY_ID: ' || l_Qte_Header_Row_Rec.Q_INV_TO_PTY_ID,1,'N');
404 aso_debug_pub.add('QUOTE_HEADER.INVOICE_TO_PARTY_SITE_ID: ' || l_Qte_Header_Row_Rec.Q_INV_TO_PTY_SITE_ID,1,'N');
405 aso_debug_pub.add('QUOTE_HEADER.LAST_UPDATE_DATE: ' || l_Qte_Header_Row_Rec.Q_LAST_UPDATE_DATE,1,'N');
406 aso_debug_pub.add('QUOTE_HEADER.MARKETING_SOURCE_CODE_ID: ' || l_Qte_Header_Row_Rec.Q_MKTING_SRC_CODE_ID,1,'N');
407 aso_debug_pub.add('QUOTE_HEADER.OBJECT_VERSION_NUMBER: ' || l_Qte_Header_Row_Rec.Q_OBJECT_VERSION_NUMBER,1,'N');
408 aso_debug_pub.add('QUOTE_HEADER.ORDER_TYPE_ID: ' || l_Qte_Header_Row_Rec.Q_ORDER_TYPE_ID,1,'N');
409 aso_debug_pub.add('QUOTE_HEADER.ORG_ID: ' || l_Qte_Header_Row_Rec.Q_ORG_ID,1,'N');
410 aso_debug_pub.add('QUOTE_HEADER.PACKING_INSTRUCTIONS: ' || l_Qte_Header_Row_Rec.Q_PACKING_INSTRUCTIONS,1,'N');
411 aso_debug_pub.add('QUOTE_HEADER.PARTY_ID: ' || l_Qte_Header_Row_Rec.Q_PARTY_ID,1,'N');
412 aso_debug_pub.add('QUOTE_HEADER.PAYMENT_REF_NUMBER: ' || l_Qte_Header_Row_Rec.Q_PAYMENT_REF_NUMBER,1,'N');
413 aso_debug_pub.add('QUOTE_HEADER.PAYMENT_TERM_ID: ' || l_Qte_Header_Row_Rec.Q_PAYMENT_TERM_ID,1,'N');
414 aso_debug_pub.add('QUOTE_HEADER.PAYMENT_TYPE_CODE: ' || l_Qte_Header_Row_Rec.Q_PAYMENT_TYPE_CODE,1,'N');
415 aso_debug_pub.add('QUOTE_HEADER.PHONE_ID: ' || l_Qte_Header_Row_Rec.Q_PHONE_ID,1,'N');
416 aso_debug_pub.add('QUOTE_HEADER.PRICE_FROZEN_DATE: ' || l_Qte_Header_Row_Rec.Q_PRICE_FROZEN_DATE,1,'N');
417 aso_debug_pub.add('QUOTE_HEADER.PRICE_LIST_ID: ' || l_Qte_Header_Row_Rec.Q_PRICE_LIST_ID,1,'N');
418 aso_debug_pub.add('QUOTE_HEADER.QUOTE_EXPIRATION_DATE: ' || l_Qte_Header_Row_Rec.Q_QUOTE_EXPIRATION_DATE,1,'N');
419 aso_debug_pub.add('QUOTE_HEADER.QUOTE_HEADER_ID: ' || l_Qte_Header_Row_Rec.Q_QUOTE_HEADER_ID,1,'N');
420 aso_debug_pub.add('QUOTE_HEADER.QUOTE_NAME: ' || l_Qte_Header_Row_Rec.Q_QUOTE_NAME,1,'N');
421 aso_debug_pub.add('QUOTE_HEADER.QUOTE_STATUS_ID: ' || l_Qte_Header_Row_Rec.Q_QUOTE_STATUS_ID,1,'N');
422 aso_debug_pub.add('QUOTE_HEADER.QUOTE_TO_CUSTOMER_TYPE: ' || l_Qte_Header_Row_Rec.Q_QUOTE_CUSTOMER_TYPE,1,'N');
423 aso_debug_pub.add('QUOTE_HEADER.REQUEST_DATE: ' || l_Qte_Header_Row_Rec.Q_REQUEST_DATE,1,'N');
424 aso_debug_pub.add('QUOTE_HEADER.REQUEST_DATE_TYPE: ' || l_Qte_Header_Row_Rec.Q_REQUEST_DATE_TYPE,1,'N');
425 aso_debug_pub.add('QUOTE_HEADER.RESOURCE_GRP_ID: ' || l_Qte_Header_Row_Rec.Q_RESOURCE_GRP_ID,1,'N');
426 aso_debug_pub.add('QUOTE_HEADER.RESOURCE_ID: ' || l_Qte_Header_Row_Rec.Q_RESOURCE_ID,1,'N');
427 aso_debug_pub.add('QUOTE_HEADER.SALES_CHANNEL_CODE: ' || l_Qte_Header_Row_Rec.Q_SALES_CHANNEL_CODE,1,'N');
428 aso_debug_pub.add('QUOTE_HEADER.SHIPMENT_PRIORITY_CODE: ' || l_Qte_Header_Row_Rec.Q_SHIPMENT_PRIORITY_CODE,1,'N');
429 aso_debug_pub.add('QUOTE_HEADER.SHIPPING_INSTRUCTIONS: ' || l_Qte_Header_Row_Rec.Q_SHIPPING_INSTRUCTIONS,1,'N');
430 aso_debug_pub.add('QUOTE_HEADER.SHIP_METHOD_CODE: ' || l_Qte_Header_Row_Rec.Q_SHIP_METHOD_CODE,1,'N');
431 aso_debug_pub.add('QUOTE_HEADER.SHIP_TO_CUST_ACCOUNT_ID: ' || l_Qte_Header_Row_Rec.Q_SHIP_TO_CUST_ACCT_ID,1,'N');
432 aso_debug_pub.add('QUOTE_HEADER.SHIP_TO_CUST_PARTY_ID: ' || l_Qte_Header_Row_Rec.Q_SHIP_TO_CUST_PARTY_ID,1,'N');
433 aso_debug_pub.add('QUOTE_HEADER.SHIP_TO_PARTY_ID: ' || l_Qte_Header_Row_Rec.Q_SHIP_TO_PARTY_ID,1,'N');
434 aso_debug_pub.add('QUOTE_HEADER.SHIP_TO_PARTY_SITE_ID: ' || l_Qte_Header_Row_Rec.Q_SHIP_TO_PARTY_SITE_ID,1,'N');
435 aso_debug_pub.add('QUOTE_HEADER.SOLD_TO_PARTY_SITE_ID: ' || l_Qte_Header_Row_Rec.Q_SOLD_TO_PARTY_SITE_ID,1,'N');
436 aso_debug_pub.add('############# BEFORE QUOTE_HEADER DEFAULT HDLR END #############' ,1,'N');
437 END IF;
438
439 ASO_QUOTE_HEADER_DEF_HDLR.Default_Record
440 (
441 p_x_rec => l_Qte_Header_Row_Rec,
442 p_in_old_rec => l_Qte_Header_Row_Rec);
443
444 IF aso_debug_pub.g_debug_flag = 'Y' THEN
445 aso_debug_pub.add('############# AFTER QUOTE_HEADER DEFAULT HDLR START #############' ,1,'N');
446 aso_debug_pub.add('QUOTE_HEADER.APPLICATION_TYPE_CODE: ' || l_Qte_Header_Row_Rec.Q_APPLICATION_TYPE_CODE,1,'N');
447 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE1: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE1,1,'N');
448 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE10: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE10,1,'N');
449 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE11: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE11,1,'N');
450 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE12: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE12,1,'N');
451 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE13: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE13,1,'N');
452 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE14: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE14,1,'N');
453 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE15: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE15,1,'N');
454 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE16: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE16,1,'N');
455 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE17: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE17,1,'N');
456 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE18: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE18,1,'N');
457 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE19: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE19,1,'N');
458 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE2: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE2,1,'N');
459 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE20: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE20,1,'N');
460 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE3: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE3,1,'N');
461 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE4: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE4,1,'N');
462 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE5: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE5,1,'N');
463 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE6: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE6,1,'N');
464 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE7: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE7,1,'N');
465 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE8: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE8,1,'N');
466 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE9: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE9,1,'N');
467 aso_debug_pub.add('QUOTE_HEADER.ATTRIBUTE_CATEGORY: ' || l_Qte_Header_Row_Rec.Q_ATTRIBUTE_CATEGORY,1,'N');
468 aso_debug_pub.add('QUOTE_HEADER.AUTOMATIC_PRICE_FLAG: ' || l_Qte_Header_Row_Rec.Q_AUTOMATIC_PRICE_FLAG,1,'N');
469 aso_debug_pub.add('QUOTE_HEADER.AUTOMATIC_TAX_FLAG: ' || l_Qte_Header_Row_Rec.Q_AUTOMATIC_TAX_FLAG,1,'N');
470 aso_debug_pub.add('QUOTE_HEADER.CONTRACT_ID: ' || l_Qte_Header_Row_Rec.Q_CONTRACT_ID,1,'N');
471 aso_debug_pub.add('QUOTE_HEADER.CONTRACT_TEMPLATE_ID: ' || l_Qte_Header_Row_Rec.Q_CONTRACT_TEMPLATE_ID,1,'N');
472 aso_debug_pub.add('QUOTE_HEADER.CREATED_BY: ' || l_Qte_Header_Row_Rec.Q_CREATED_BY,1,'N');
473 aso_debug_pub.add('QUOTE_HEADER.CREDIT_CARD_CODE: ' || l_Qte_Header_Row_Rec.Q_CREDIT_CARD_CODE,1,'N');
474 aso_debug_pub.add('QUOTE_HEADER.CREDIT_CARD_EXPIRATION_DATE: ' || l_Qte_Header_Row_Rec.Q_CREDIT_CARD_EXP_DATE,1,'N');
475 aso_debug_pub.add('QUOTE_HEADER.CREDIT_CARD_HOLDER_NAME: ' || l_Qte_Header_Row_Rec.Q_CREDIT_CARD_HLD_NAME,1,'N');
476 aso_debug_pub.add('QUOTE_HEADER.CURRENCY_CODE: ' || l_Qte_Header_Row_Rec.Q_CURRENCY_CODE,1,'N');
477 aso_debug_pub.add('QUOTE_HEADER.CUST_ACCOUNT_ID: ' || l_Qte_Header_Row_Rec.Q_CUST_ACCOUNT_ID,1,'N');
478 aso_debug_pub.add('QUOTE_HEADER.CUST_PARTY_ID: ' || l_Qte_Header_Row_Rec.Q_CUST_PARTY_ID,1,'N');
479 aso_debug_pub.add('QUOTE_HEADER.CUST_PO_NUMBER: ' || l_Qte_Header_Row_Rec.Q_CUST_PO_NUMBER,1,'N');
480 aso_debug_pub.add('QUOTE_HEADER.DEMAND_CLASS_CODE: ' || l_Qte_Header_Row_Rec.Q_DEMAND_CLASS_CODE,1,'N');
481 aso_debug_pub.add('QUOTE_HEADER.END_CUSTOMER_CUST_ACCOUNT_ID: ' || l_Qte_Header_Row_Rec.Q_END_CUST_CUST_ACCT_ID,1,'N');
482 aso_debug_pub.add('QUOTE_HEADER.END_CUSTOMER_CUST_PARTY_ID: ' || l_Qte_Header_Row_Rec.Q_END_CUST_CUST_PTY_ID,1,'N');
483 aso_debug_pub.add('QUOTE_HEADER.END_CUSTOMER_PARTY_ID: ' || l_Qte_Header_Row_Rec.Q_END_CUST_PTY_ID,1,'N');
484 aso_debug_pub.add('QUOTE_HEADER.END_CUSTOMER_PARTY_SITE_ID: ' || l_Qte_Header_Row_Rec.Q_END_CUST_PTY_SITE_ID,1,'N');
485 aso_debug_pub.add('QUOTE_HEADER.FOB_CODE: ' || l_Qte_Header_Row_Rec.Q_FOB_CODE,1,'N');
486 aso_debug_pub.add('QUOTE_HEADER.FREIGHT_TERMS_CODE: ' || l_Qte_Header_Row_Rec.Q_FREIGHT_TERMS_CODE,1,'N');
487 aso_debug_pub.add('QUOTE_HEADER.INVOICE_TO_CUST_ACCOUNT_ID: ' || l_Qte_Header_Row_Rec.Q_INV_TO_CUST_ACCT_ID,1,'N');
488 aso_debug_pub.add('QUOTE_HEADER.INVOICE_TO_CUST_PARTY_ID: ' || l_Qte_Header_Row_Rec.Q_INV_TO_CUST_PTY_ID,1,'N');
489 aso_debug_pub.add('QUOTE_HEADER.INVOICE_TO_PARTY_ID: ' || l_Qte_Header_Row_Rec.Q_INV_TO_PTY_ID,1,'N');
490 aso_debug_pub.add('QUOTE_HEADER.INVOICE_TO_PARTY_SITE_ID: ' || l_Qte_Header_Row_Rec.Q_INV_TO_PTY_SITE_ID,1,'N');
491 aso_debug_pub.add('QUOTE_HEADER.LAST_UPDATE_DATE: ' || l_Qte_Header_Row_Rec.Q_LAST_UPDATE_DATE,1,'N');
492 aso_debug_pub.add('QUOTE_HEADER.MARKETING_SOURCE_CODE_ID: ' || l_Qte_Header_Row_Rec.Q_MKTING_SRC_CODE_ID,1,'N');
493 aso_debug_pub.add('QUOTE_HEADER.OBJECT_VERSION_NUMBER: ' || l_Qte_Header_Row_Rec.Q_OBJECT_VERSION_NUMBER,1,'N');
494 aso_debug_pub.add('QUOTE_HEADER.ORDER_TYPE_ID: ' || l_Qte_Header_Row_Rec.Q_ORDER_TYPE_ID,1,'N');
495 aso_debug_pub.add('QUOTE_HEADER.ORG_ID: ' || l_Qte_Header_Row_Rec.Q_ORG_ID,1,'N');
496 aso_debug_pub.add('QUOTE_HEADER.PACKING_INSTRUCTIONS: ' || l_Qte_Header_Row_Rec.Q_PACKING_INSTRUCTIONS,1,'N');
497 aso_debug_pub.add('QUOTE_HEADER.PARTY_ID: ' || l_Qte_Header_Row_Rec.Q_PARTY_ID,1,'N');
498 aso_debug_pub.add('QUOTE_HEADER.PAYMENT_REF_NUMBER: ' || l_Qte_Header_Row_Rec.Q_PAYMENT_REF_NUMBER,1,'N');
499 aso_debug_pub.add('QUOTE_HEADER.PAYMENT_TERM_ID: ' || l_Qte_Header_Row_Rec.Q_PAYMENT_TERM_ID,1,'N');
500 aso_debug_pub.add('QUOTE_HEADER.PAYMENT_TYPE_CODE: ' || l_Qte_Header_Row_Rec.Q_PAYMENT_TYPE_CODE,1,'N');
501 aso_debug_pub.add('QUOTE_HEADER.PHONE_ID: ' || l_Qte_Header_Row_Rec.Q_PHONE_ID,1,'N');
502 aso_debug_pub.add('QUOTE_HEADER.PRICE_FROZEN_DATE: ' || l_Qte_Header_Row_Rec.Q_PRICE_FROZEN_DATE,1,'N');
503 aso_debug_pub.add('QUOTE_HEADER.PRICE_LIST_ID: ' || l_Qte_Header_Row_Rec.Q_PRICE_LIST_ID,1,'N');
504 aso_debug_pub.add('QUOTE_HEADER.QUOTE_EXPIRATION_DATE: ' || l_Qte_Header_Row_Rec.Q_QUOTE_EXPIRATION_DATE,1,'N');
505 aso_debug_pub.add('QUOTE_HEADER.QUOTE_HEADER_ID: ' || l_Qte_Header_Row_Rec.Q_QUOTE_HEADER_ID,1,'N');
506 aso_debug_pub.add('QUOTE_HEADER.QUOTE_NAME: ' || l_Qte_Header_Row_Rec.Q_QUOTE_NAME,1,'N');
507 aso_debug_pub.add('QUOTE_HEADER.QUOTE_STATUS_ID: ' || l_Qte_Header_Row_Rec.Q_QUOTE_STATUS_ID,1,'N');
508 aso_debug_pub.add('QUOTE_HEADER.QUOTE_TO_CUSTOMER_TYPE: ' || l_Qte_Header_Row_Rec.Q_QUOTE_CUSTOMER_TYPE,1,'N');
509 aso_debug_pub.add('QUOTE_HEADER.REQUEST_DATE: ' || l_Qte_Header_Row_Rec.Q_REQUEST_DATE,1,'N');
510 aso_debug_pub.add('QUOTE_HEADER.REQUEST_DATE_TYPE: ' || l_Qte_Header_Row_Rec.Q_REQUEST_DATE_TYPE,1,'N');
511 aso_debug_pub.add('QUOTE_HEADER.RESOURCE_GRP_ID: ' || l_Qte_Header_Row_Rec.Q_RESOURCE_GRP_ID,1,'N');
512 aso_debug_pub.add('QUOTE_HEADER.RESOURCE_ID: ' || l_Qte_Header_Row_Rec.Q_RESOURCE_ID,1,'N');
513 aso_debug_pub.add('QUOTE_HEADER.SALES_CHANNEL_CODE: ' || l_Qte_Header_Row_Rec.Q_SALES_CHANNEL_CODE,1,'N');
514 aso_debug_pub.add('QUOTE_HEADER.SHIPMENT_PRIORITY_CODE: ' || l_Qte_Header_Row_Rec.Q_SHIPMENT_PRIORITY_CODE,1,'N');
515 aso_debug_pub.add('QUOTE_HEADER.SHIPPING_INSTRUCTIONS: ' || l_Qte_Header_Row_Rec.Q_SHIPPING_INSTRUCTIONS,1,'N');
516 aso_debug_pub.add('QUOTE_HEADER.SHIP_METHOD_CODE: ' || l_Qte_Header_Row_Rec.Q_SHIP_METHOD_CODE,1,'N');
517 aso_debug_pub.add('QUOTE_HEADER.SHIP_TO_CUST_ACCOUNT_ID: ' || l_Qte_Header_Row_Rec.Q_SHIP_TO_CUST_ACCT_ID,1,'N');
518 aso_debug_pub.add('QUOTE_HEADER.SHIP_TO_CUST_PARTY_ID: ' || l_Qte_Header_Row_Rec.Q_SHIP_TO_CUST_PARTY_ID,1,'N');
519 aso_debug_pub.add('QUOTE_HEADER.SHIP_TO_PARTY_ID: ' || l_Qte_Header_Row_Rec.Q_SHIP_TO_PARTY_ID,1,'N');
520 aso_debug_pub.add('QUOTE_HEADER.SHIP_TO_PARTY_SITE_ID: ' || l_Qte_Header_Row_Rec.Q_SHIP_TO_PARTY_SITE_ID,1,'N');
521 aso_debug_pub.add('QUOTE_HEADER.SOLD_TO_PARTY_SITE_ID: ' || l_Qte_Header_Row_Rec.Q_SOLD_TO_PARTY_SITE_ID,1,'N');
522 aso_debug_pub.add('############# AFTER QUOTE_HEADER DEFAULT HDLR END #############' ,1,'N');
523 END IF;
524
525 END IF;
526
527 IF l_entity_code = 'QUOTE_LINE' THEN
528
529 IF aso_debug_pub.g_debug_flag = 'Y' THEN
530 aso_debug_pub.add('############# BEFORE QUOTE_LINE DEFAULT HDLR START #############' ,1,'N');
531 aso_debug_pub.add('QUOTE_LINE.AGREEMENT_ID: ' || l_Qte_Line_Row_Rec.L_AGREEMENT_ID,1,'N');
532 aso_debug_pub.add('QUOTE_LINE.APPLICATION_TYPE_CODE: ' || l_Qte_Line_Row_Rec.L_APPLICATION_TYPE_CODE,1,'N');
533 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE1: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE1,1,'N');
534 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE10: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE10,1,'N');
535 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE11: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE11,1,'N');
536 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE12: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE12,1,'N');
537 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE13: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE13,1,'N');
538 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE14: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE14,1,'N');
539 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE15: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE15,1,'N');
540 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE16: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE16,1,'N');
541 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE17: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE17,1,'N');
542 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE18: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE18,1,'N');
543 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE19: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE19,1,'N');
544 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE2: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE2,1,'N');
545 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE20: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE20,1,'N');
546 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE3: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE3,1,'N');
547 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE4: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE4,1,'N');
548 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE5: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE5,1,'N');
549 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE6: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE6,1,'N');
550 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE7: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE7,1,'N');
551 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE8: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE8,1,'N');
552 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE9: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE9,1,'N');
553 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE_CATEGORY: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE_CATEGORY,1,'N');
554 aso_debug_pub.add('QUOTE_LINE.CHARGE_PERIODICITY_CODE: ' || l_Qte_Line_Row_Rec.L_PERIODICITY_CODE,1,'N');
555 aso_debug_pub.add('QUOTE_LINE.CREATED_BY: ' || l_Qte_Line_Row_Rec.L_CREATED_BY,1,'N');
556 aso_debug_pub.add('QUOTE_LINE.CREDIT_CARD_CODE: ' || l_Qte_Line_Row_Rec.L_CREDIT_CARD_CODE,1,'N');
557 aso_debug_pub.add('QUOTE_LINE.CREDIT_CARD_EXPIRATION_DATE: ' || l_Qte_Line_Row_Rec.L_CREDIT_CARD_EXP_DATE,1,'N');
558 aso_debug_pub.add('QUOTE_LINE.CREDIT_CARD_HOLDER_NAME: ' || l_Qte_Line_Row_Rec.L_CREDIT_CARD_HLD_NAME,1,'N');
559 aso_debug_pub.add('QUOTE_LINE.CUST_PO_LINE_NUMBER: ' || l_Qte_Line_Row_Rec.L_CUST_PO_LINE_NUMBER,1,'N');
560 aso_debug_pub.add('QUOTE_LINE.CUST_PO_NUMBER: ' || l_Qte_Line_Row_Rec.L_CUST_PO_NUMBER,1,'N');
561 aso_debug_pub.add('QUOTE_LINE.DEMAND_CLASS_CODE: ' || l_Qte_Line_Row_Rec.L_DEMAND_CLASS_CODE,1,'N');
562 aso_debug_pub.add('QUOTE_LINE.END_CUSTOMER_CUST_ACCOUNT_ID: ' || l_Qte_Line_Row_Rec.L_END_CUST_CUST_ACCT_ID,1,'N');
563 aso_debug_pub.add('QUOTE_LINE.END_CUSTOMER_CUST_PARTY_ID: ' || l_Qte_Line_Row_Rec.L_END_CUST_CUST_PTY_ID,1,'N');
564 aso_debug_pub.add('QUOTE_LINE.END_CUSTOMER_PARTY_ID: ' || l_Qte_Line_Row_Rec.L_END_CUST_PTY_ID,1,'N');
565 aso_debug_pub.add('QUOTE_LINE.END_CUSTOMER_PARTY_SITE_ID: ' || l_Qte_Line_Row_Rec.L_END_CUST_PTY_SITE_ID,1,'N');
566 aso_debug_pub.add('QUOTE_LINE.FOB_CODE: ' || l_Qte_Line_Row_Rec.L_FOB_CODE,1,'N');
567 aso_debug_pub.add('QUOTE_LINE.FREIGHT_TERMS_CODE: ' || l_Qte_Line_Row_Rec.L_FREIGHT_TERMS_CODE,1,'N');
568 aso_debug_pub.add('QUOTE_LINE.INVOICE_TO_CUST_ACCOUNT_ID: ' || l_Qte_Line_Row_Rec.L_INV_TO_CUST_ACCT_ID,1,'N');
569 aso_debug_pub.add('QUOTE_LINE.INVOICE_TO_CUST_PARTY_ID: ' || l_Qte_Line_Row_Rec.L_INV_TO_CUST_PTY_ID,1,'N');
570 aso_debug_pub.add('QUOTE_LINE.INVOICE_TO_PARTY_ID: ' || l_Qte_Line_Row_Rec.L_INV_TO_PTY_ID,1,'N');
571 aso_debug_pub.add('QUOTE_LINE.INVOICE_TO_PARTY_SITE_ID: ' || l_Qte_Line_Row_Rec.L_INV_TO_PTY_SITE_ID,1,'N');
572 aso_debug_pub.add('QUOTE_LINE.ORDER_LINE_TYPE_ID: ' || l_Qte_Line_Row_Rec.L_ORDER_LINE_TYPE_ID,1,'N');
573 aso_debug_pub.add('QUOTE_LINE.LAST_UPDATE_DATE: ' || l_Qte_Line_Row_Rec.L_LAST_UPDATE_DATE,1,'N');
574 aso_debug_pub.add('QUOTE_LINE.LINE_CATEGORY_CODE: ' || l_Qte_Line_Row_Rec.L_LINE_CATEGORY_CODE,1,'N');
575 aso_debug_pub.add('QUOTE_LINE.OBJECT_VERSION_NUMBER: ' || l_Qte_Line_Row_Rec.L_OBJECT_VERSION_NUMBER,1,'N');
576 aso_debug_pub.add('QUOTE_LINE.SHIP_FROM_ORG_ID: ' || l_Qte_Line_Row_Rec.L_SHIP_FROM_ORG_ID,1,'N');
577 aso_debug_pub.add('QUOTE_LINE.ORG_ID: ' || l_Qte_Line_Row_Rec.L_ORG_ID,1,'N');
578 aso_debug_pub.add('QUOTE_LINE.PACKING_INSTRUCTIONS: ' || l_Qte_Line_Row_Rec.L_PACKING_INSTRUCTIONS,1,'N');
579 aso_debug_pub.add('QUOTE_LINE.PAYMENT_REF_NUMBER: ' || l_Qte_Line_Row_Rec.L_PAYMENT_REF_NUMBER,1,'N');
580 aso_debug_pub.add('QUOTE_LINE.PAYMENT_TERM_ID: ' || l_Qte_Line_Row_Rec.L_PAYMENT_TERM_ID,1,'N');
581 aso_debug_pub.add('QUOTE_LINE.PAYMENT_TYPE_CODE: ' || l_Qte_Line_Row_Rec.L_PAYMENT_TYPE_CODE,1,'N');
582 aso_debug_pub.add('QUOTE_LINE.PRICE_LIST_ID: ' || l_Qte_Line_Row_Rec.L_PRICE_LIST_ID,1,'N');
583 aso_debug_pub.add('QUOTE_LINE.QUOTE_HEADER_ID: ' || l_Qte_Line_Row_Rec.L_QUOTE_HEADER_ID,1,'N');
584 aso_debug_pub.add('QUOTE_LINE.QUOTE_LINE_ID: ' || l_Qte_Line_Row_Rec.L_QUOTE_LINE_ID,1,'N');
585 aso_debug_pub.add('QUOTE_LINE.QUOTE_TO_CUSTOMER_TYPE: ' || l_Qte_Line_Row_Rec.L_QUOTE_CUSTOMER_TYPE,1,'N');
586 aso_debug_pub.add('QUOTE_LINE.REQUEST_DATE: ' || l_Qte_Line_Row_Rec.L_REQUEST_DATE,1,'N');
587 aso_debug_pub.add('QUOTE_LINE.SEGMENT1: ' || l_Qte_Line_Row_Rec.L_PRODUCT,1,'N');
588 aso_debug_pub.add('QUOTE_LINE.SHIPMENT_PRIORITY_CODE: ' || l_Qte_Line_Row_Rec.L_SHIPMENT_PRIORITY_CODE,1,'N');
589 aso_debug_pub.add('QUOTE_LINE.SHIPPING_INSTRUCTIONS: ' || l_Qte_Line_Row_Rec.L_SHIPPING_INSTRUCTIONS,1,'N');
590 aso_debug_pub.add('QUOTE_LINE.SHIP_METHOD_CODE: ' || l_Qte_Line_Row_Rec.L_SHIP_METHOD_CODE,1,'N');
591 aso_debug_pub.add('QUOTE_LINE.SHIP_TO_CUST_ACCOUNT_ID: ' || l_Qte_Line_Row_Rec.L_SHIP_TO_CUST_ACCT_ID,1,'N');
592 aso_debug_pub.add('QUOTE_LINE.SHIP_TO_CUST_PARTY_ID: ' || l_Qte_Line_Row_Rec.L_SHIP_TO_CUST_PARTY_ID,1,'N');
593 aso_debug_pub.add('QUOTE_LINE.SHIP_TO_PARTY_ID: ' || l_Qte_Line_Row_Rec.L_SHIP_TO_PARTY_ID,1,'N');
594 aso_debug_pub.add('QUOTE_LINE.SHIP_TO_PARTY_SITE_ID: ' || l_Qte_Line_Row_Rec.L_SHIP_TO_PARTY_SITE_ID,1,'N');
595 aso_debug_pub.add('############# BEFORE QUOTE_LINE DEFAULT HDLR END #############' ,1,'N');
596 END IF;
597
598 ASO_QUOTE_LINE_DEF_HDLR.Default_Record
599 (
600 p_x_rec => l_Qte_Line_Row_Rec,
601 p_in_old_rec => l_Qte_Line_Row_Rec);
602
603 IF aso_debug_pub.g_debug_flag = 'Y' THEN
604 aso_debug_pub.add('############# AFTER QUOTE_LINE DEFAULT HDLR START #############' ,1,'N');
605 aso_debug_pub.add('QUOTE_LINE.AGREEMENT_ID: ' || l_Qte_Line_Row_Rec.L_AGREEMENT_ID,1,'N');
606 aso_debug_pub.add('QUOTE_LINE.APPLICATION_TYPE_CODE: ' || l_Qte_Line_Row_Rec.L_APPLICATION_TYPE_CODE,1,'N');
607 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE1: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE1,1,'N');
608 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE10: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE10,1,'N');
609 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE11: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE11,1,'N');
610 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE12: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE12,1,'N');
611 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE13: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE13,1,'N');
612 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE14: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE14,1,'N');
613 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE15: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE15,1,'N');
614 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE16: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE16,1,'N');
615 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE17: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE17,1,'N');
616 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE18: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE18,1,'N');
617 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE19: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE19,1,'N');
618 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE2: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE2,1,'N');
619 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE20: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE20,1,'N');
620 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE3: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE3,1,'N');
621 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE4: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE4,1,'N');
622 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE5: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE5,1,'N');
623 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE6: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE6,1,'N');
624 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE7: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE7,1,'N');
625 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE8: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE8,1,'N');
626 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE9: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE9,1,'N');
627 aso_debug_pub.add('QUOTE_LINE.ATTRIBUTE_CATEGORY: ' || l_Qte_Line_Row_Rec.L_ATTRIBUTE_CATEGORY,1,'N');
628 aso_debug_pub.add('QUOTE_LINE.CHARGE_PERIODICITY_CODE: ' || l_Qte_Line_Row_Rec.L_PERIODICITY_CODE,1,'N');
629 aso_debug_pub.add('QUOTE_LINE.CREATED_BY: ' || l_Qte_Line_Row_Rec.L_CREATED_BY,1,'N');
630 aso_debug_pub.add('QUOTE_LINE.CREDIT_CARD_CODE: ' || l_Qte_Line_Row_Rec.L_CREDIT_CARD_CODE,1,'N');
631 aso_debug_pub.add('QUOTE_LINE.CREDIT_CARD_EXPIRATION_DATE: ' || l_Qte_Line_Row_Rec.L_CREDIT_CARD_EXP_DATE,1,'N');
632 aso_debug_pub.add('QUOTE_LINE.CREDIT_CARD_HOLDER_NAME: ' || l_Qte_Line_Row_Rec.L_CREDIT_CARD_HLD_NAME,1,'N');
633 aso_debug_pub.add('QUOTE_LINE.CUST_PO_LINE_NUMBER: ' || l_Qte_Line_Row_Rec.L_CUST_PO_LINE_NUMBER,1,'N');
634 aso_debug_pub.add('QUOTE_LINE.CUST_PO_NUMBER: ' || l_Qte_Line_Row_Rec.L_CUST_PO_NUMBER,1,'N');
635 aso_debug_pub.add('QUOTE_LINE.DEMAND_CLASS_CODE: ' || l_Qte_Line_Row_Rec.L_DEMAND_CLASS_CODE,1,'N');
636 aso_debug_pub.add('QUOTE_LINE.END_CUSTOMER_CUST_ACCOUNT_ID: ' || l_Qte_Line_Row_Rec.L_END_CUST_CUST_ACCT_ID,1,'N');
637 aso_debug_pub.add('QUOTE_LINE.END_CUSTOMER_CUST_PARTY_ID: ' || l_Qte_Line_Row_Rec.L_END_CUST_CUST_PTY_ID,1,'N');
638 aso_debug_pub.add('QUOTE_LINE.END_CUSTOMER_PARTY_ID: ' || l_Qte_Line_Row_Rec.L_END_CUST_PTY_ID,1,'N');
639 aso_debug_pub.add('QUOTE_LINE.END_CUSTOMER_PARTY_SITE_ID: ' || l_Qte_Line_Row_Rec.L_END_CUST_PTY_SITE_ID,1,'N');
640 aso_debug_pub.add('QUOTE_LINE.FOB_CODE: ' || l_Qte_Line_Row_Rec.L_FOB_CODE,1,'N');
641 aso_debug_pub.add('QUOTE_LINE.FREIGHT_TERMS_CODE: ' || l_Qte_Line_Row_Rec.L_FREIGHT_TERMS_CODE,1,'N');
642 aso_debug_pub.add('QUOTE_LINE.INVOICE_TO_CUST_ACCOUNT_ID: ' || l_Qte_Line_Row_Rec.L_INV_TO_CUST_ACCT_ID,1,'N');
643 aso_debug_pub.add('QUOTE_LINE.INVOICE_TO_CUST_PARTY_ID: ' || l_Qte_Line_Row_Rec.L_INV_TO_CUST_PTY_ID,1,'N');
644 aso_debug_pub.add('QUOTE_LINE.INVOICE_TO_PARTY_ID: ' || l_Qte_Line_Row_Rec.L_INV_TO_PTY_ID,1,'N');
645 aso_debug_pub.add('QUOTE_LINE.INVOICE_TO_PARTY_SITE_ID: ' || l_Qte_Line_Row_Rec.L_INV_TO_PTY_SITE_ID,1,'N');
646 aso_debug_pub.add('QUOTE_LINE.ORDER_LINE_TYPE_ID: ' || l_Qte_Line_Row_Rec.L_ORDER_LINE_TYPE_ID,1,'N');
647 aso_debug_pub.add('QUOTE_LINE.LAST_UPDATE_DATE: ' || l_Qte_Line_Row_Rec.L_LAST_UPDATE_DATE,1,'N');
648 aso_debug_pub.add('QUOTE_LINE.LINE_CATEGORY_CODE: ' || l_Qte_Line_Row_Rec.L_LINE_CATEGORY_CODE,1,'N');
649 aso_debug_pub.add('QUOTE_LINE.OBJECT_VERSION_NUMBER: ' || l_Qte_Line_Row_Rec.L_OBJECT_VERSION_NUMBER,1,'N');
650 aso_debug_pub.add('QUOTE_LINE.SHIP_FROM_ORG_ID: ' || l_Qte_Line_Row_Rec.L_SHIP_FROM_ORG_ID,1,'N');
651 aso_debug_pub.add('QUOTE_LINE.ORG_ID: ' || l_Qte_Line_Row_Rec.L_ORG_ID,1,'N');
652 aso_debug_pub.add('QUOTE_LINE.PACKING_INSTRUCTIONS: ' || l_Qte_Line_Row_Rec.L_PACKING_INSTRUCTIONS,1,'N');
653 aso_debug_pub.add('QUOTE_LINE.PAYMENT_REF_NUMBER: ' || l_Qte_Line_Row_Rec.L_PAYMENT_REF_NUMBER,1,'N');
654 aso_debug_pub.add('QUOTE_LINE.PAYMENT_TERM_ID: ' || l_Qte_Line_Row_Rec.L_PAYMENT_TERM_ID,1,'N');
655 aso_debug_pub.add('QUOTE_LINE.PAYMENT_TYPE_CODE: ' || l_Qte_Line_Row_Rec.L_PAYMENT_TYPE_CODE,1,'N');
656 aso_debug_pub.add('QUOTE_LINE.PRICE_LIST_ID: ' || l_Qte_Line_Row_Rec.L_PRICE_LIST_ID,1,'N');
657 aso_debug_pub.add('QUOTE_LINE.QUOTE_HEADER_ID: ' || l_Qte_Line_Row_Rec.L_QUOTE_HEADER_ID,1,'N');
658 aso_debug_pub.add('QUOTE_LINE.QUOTE_LINE_ID: ' || l_Qte_Line_Row_Rec.L_QUOTE_LINE_ID,1,'N');
659 aso_debug_pub.add('QUOTE_LINE.QUOTE_TO_CUSTOMER_TYPE: ' || l_Qte_Line_Row_Rec.L_QUOTE_CUSTOMER_TYPE,1,'N');
660 aso_debug_pub.add('QUOTE_LINE.REQUEST_DATE: ' || l_Qte_Line_Row_Rec.L_REQUEST_DATE,1,'N');
661 aso_debug_pub.add('QUOTE_LINE.SEGMENT1: ' || l_Qte_Line_Row_Rec.L_PRODUCT,1,'N');
662 aso_debug_pub.add('QUOTE_LINE.SHIPMENT_PRIORITY_CODE: ' || l_Qte_Line_Row_Rec.L_SHIPMENT_PRIORITY_CODE,1,'N');
663 aso_debug_pub.add('QUOTE_LINE.SHIPPING_INSTRUCTIONS: ' || l_Qte_Line_Row_Rec.L_SHIPPING_INSTRUCTIONS,1,'N');
664 aso_debug_pub.add('QUOTE_LINE.SHIP_METHOD_CODE: ' || l_Qte_Line_Row_Rec.L_SHIP_METHOD_CODE,1,'N');
665 aso_debug_pub.add('QUOTE_LINE.SHIP_TO_CUST_ACCOUNT_ID: ' || l_Qte_Line_Row_Rec.L_SHIP_TO_CUST_ACCT_ID,1,'N');
666 aso_debug_pub.add('QUOTE_LINE.SHIP_TO_CUST_PARTY_ID: ' || l_Qte_Line_Row_Rec.L_SHIP_TO_CUST_PARTY_ID,1,'N');
667 aso_debug_pub.add('QUOTE_LINE.SHIP_TO_PARTY_ID: ' || l_Qte_Line_Row_Rec.L_SHIP_TO_PARTY_ID,1,'N');
668 aso_debug_pub.add('QUOTE_LINE.SHIP_TO_PARTY_SITE_ID: ' || l_Qte_Line_Row_Rec.L_SHIP_TO_PARTY_SITE_ID,1,'N');
669 aso_debug_pub.add('############# AFTER QUOTE_LINE DEFAULT HDLR END #############' ,1,'N');
670 END IF;
671
672 END IF;
673
674 IF l_entity_code = 'QUOTE_OPPTY' THEN
675
676 IF aso_debug_pub.g_debug_flag = 'Y' THEN
677 aso_debug_pub.add('############# BEFORE QUOTE_OPPTY DEFAULT HDLR START #############' ,1,'N');
678 aso_debug_pub.add('QUOTE_OPPTY.APPLICATION_TYPE_CODE: ' || l_Qte_Opportunity_Row_Rec.O_APPLICATION_TYPE_CODE,1,'N');
679 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE1: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE1,1,'N');
680 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE10: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE10,1,'N');
681 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE11: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE11,1,'N');
682 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE12: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE12,1,'N');
683 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE13: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE13,1,'N');
684 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE14: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE14,1,'N');
685 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE15: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE15,1,'N');
686 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE16: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE16,1,'N');
687 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE17: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE17,1,'N');
688 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE18: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE18,1,'N');
689 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE19: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE19,1,'N');
690 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE2: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE2,1,'N');
691 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE20: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE20,1,'N');
692 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE3: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE3,1,'N');
693 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE4: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE4,1,'N');
694 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE5: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE5,1,'N');
695 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE6: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE6,1,'N');
696 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE7: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE7,1,'N');
697 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE8: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE8,1,'N');
698 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE9: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE9,1,'N');
699 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE_CATEGORY: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE_CATEGORY,1,'N');
700 aso_debug_pub.add('QUOTE_OPPTY.AUTOMATIC_PRICE_FLAG: ' || l_Qte_Opportunity_Row_Rec.O_AUTOMATIC_PRICE_FLAG,1,'N');
701 aso_debug_pub.add('QUOTE_OPPTY.AUTOMATIC_TAX_FLAG: ' || l_Qte_Opportunity_Row_Rec.O_AUTOMATIC_TAX_FLAG,1,'N');
702 aso_debug_pub.add('QUOTE_OPPTY.CONTRACT_ID: ' || l_Qte_Opportunity_Row_Rec.O_CONTRACT_ID,1,'N');
703 aso_debug_pub.add('QUOTE_OPPTY.CONTRACT_TEMPLATE_ID: ' || l_Qte_Opportunity_Row_Rec.O_CONTRACT_TEMPLATE_ID,1,'N');
704 aso_debug_pub.add('QUOTE_OPPTY.CREATED_BY: ' || l_Qte_Opportunity_Row_Rec.O_CREATED_BY,1,'N');
705 aso_debug_pub.add('QUOTE_OPPTY.CREDIT_CARD_CODE: ' || l_Qte_Opportunity_Row_Rec.O_CREDIT_CARD_CODE,1,'N');
706 aso_debug_pub.add('QUOTE_OPPTY.CREDIT_CARD_EXPIRATION_DATE: ' || l_Qte_Opportunity_Row_Rec.O_CREDIT_CARD_EXP_DATE,1,'N');
707 aso_debug_pub.add('QUOTE_OPPTY.CREDIT_CARD_HOLDER_NAME: ' || l_Qte_Opportunity_Row_Rec.O_CREDIT_CARD_HLD_NAME,1,'N');
708 aso_debug_pub.add('QUOTE_OPPTY.CURRENCY_CODE: ' || l_Qte_Opportunity_Row_Rec.O_CURRENCY_CODE,1,'N');
709 aso_debug_pub.add('QUOTE_OPPTY.CUST_ACCOUNT_ID: ' || l_Qte_Opportunity_Row_Rec.O_CUST_ACCOUNT_ID,1,'N');
710 aso_debug_pub.add('QUOTE_OPPTY.CUST_PARTY_ID: ' || l_Qte_Opportunity_Row_Rec.O_CUST_PARTY_ID,1,'N');
711 aso_debug_pub.add('QUOTE_OPPTY.CUST_PO_NUMBER: ' || l_Qte_Opportunity_Row_Rec.O_CUST_PO_NUMBER,1,'N');
712 aso_debug_pub.add('QUOTE_OPPTY.DEMAND_CLASS_CODE: ' || l_Qte_Opportunity_Row_Rec.O_DEMAND_CLASS_CODE,1,'N');
713 aso_debug_pub.add('QUOTE_OPPTY.END_CUSTOMER_CUST_ACCOUNT_ID: ' || l_Qte_Opportunity_Row_Rec.O_END_CUST_CUST_ACCT_ID,1,'N');
714 aso_debug_pub.add('QUOTE_OPPTY.END_CUSTOMER_CUST_PARTY_ID: ' || l_Qte_Opportunity_Row_Rec.O_END_CUST_CUST_PTY_ID,1,'N');
715 aso_debug_pub.add('QUOTE_OPPTY.END_CUSTOMER_PARTY_ID: ' || l_Qte_Opportunity_Row_Rec.O_END_CUST_PTY_ID,1,'N');
716 aso_debug_pub.add('QUOTE_OPPTY.END_CUSTOMER_PARTY_SITE_ID: ' || l_Qte_Opportunity_Row_Rec.O_END_CUST_PTY_SITE_ID,1,'N');
717 aso_debug_pub.add('QUOTE_OPPTY.FOB_CODE: ' || l_Qte_Opportunity_Row_Rec.O_FOB_CODE,1,'N');
718 aso_debug_pub.add('QUOTE_OPPTY.FREIGHT_TERMS_CODE: ' || l_Qte_Opportunity_Row_Rec.O_FREIGHT_TERMS_CODE,1,'N');
719 aso_debug_pub.add('QUOTE_OPPTY.INVOICE_TO_CUST_ACCOUNT_ID: ' || l_Qte_Opportunity_Row_Rec.O_INV_CUST_ACCT_ID,1,'N');
720 aso_debug_pub.add('QUOTE_OPPTY.INVOICE_TO_CUST_PARTY_ID: ' || l_Qte_Opportunity_Row_Rec.O_INV_CUST_PTY_ID,1,'N');
721 aso_debug_pub.add('QUOTE_OPPTY.INVOICE_TO_PARTY_ID: ' || l_Qte_Opportunity_Row_Rec.O_INV_PTY_ID,1,'N');
722 aso_debug_pub.add('QUOTE_OPPTY.INVOICE_TO_PARTY_SITE_ID: ' || l_Qte_Opportunity_Row_Rec.O_INV_PTY_SITE_ID,1,'N');
723 aso_debug_pub.add('QUOTE_OPPTY.LAST_UPDATE_DATE: ' || l_Qte_Opportunity_Row_Rec.O_LAST_UPDATE_DATE,1,'N');
724 aso_debug_pub.add('QUOTE_OPPTY.MARKETING_SOURCE_CODE_ID: ' || l_Qte_Opportunity_Row_Rec.O_MKTING_SRC_CODE_ID,1,'N');
725 aso_debug_pub.add('QUOTE_OPPTY.OBJECT_VERSION_NUMBER: ' || l_Qte_Opportunity_Row_Rec.O_OBJECT_VERSION_NUMBER,1,'N');
726 aso_debug_pub.add('QUOTE_OPPTY.OPPTY_CHANNEL_CODE: ' || l_Qte_Opportunity_Row_Rec.O_OPPTY_CHANNEL_CODE,1,'N');
727 aso_debug_pub.add('QUOTE_OPPTY.OPPTY_CURRENCY_CODE: ' || l_Qte_Opportunity_Row_Rec.O_OPPTY_CURRENCY_CODE,1,'N');
728 aso_debug_pub.add('QUOTE_OPPTY.OPPTY_CUST_PARTY_ID: ' || l_Qte_Opportunity_Row_Rec.O_OPPTY_CUST_PARTY_ID,1,'N');
729 aso_debug_pub.add('QUOTE_OPPTY.OPPTY_ID: ' || l_Qte_Opportunity_Row_Rec.O_OPPTY_ID,1,'N');
730 aso_debug_pub.add('QUOTE_OPPTY.OPPTY_MKTG_SRC_CODE_ID: ' || l_Qte_Opportunity_Row_Rec.O_OPPTY_MKTG_SRC_CD_ID,1,'N');
731 aso_debug_pub.add('QUOTE_OPPTY.OPPTY_QUOTE_NAME: ' || l_Qte_Opportunity_Row_Rec.O_OPPTY_QUOTE_NAME,1,'N');
732 aso_debug_pub.add('QUOTE_OPPTY.OPPTY_SOLD_TO_CONTACT_ID: ' || l_Qte_Opportunity_Row_Rec.O_OPPTY_SLD_TO_CONT_ID,1,'N');
733 aso_debug_pub.add('QUOTE_OPPTY.OPPTY_SOLD_TO_PARTY_SITE_ID: ' || l_Qte_Opportunity_Row_Rec.O_OPPTY_SLD_PTY_ST_ID,1,'N');
734 aso_debug_pub.add('QUOTE_OPPTY.ORDER_TYPE_ID: ' || l_Qte_Opportunity_Row_Rec.O_ORDER_TYPE_ID,1,'N');
735 aso_debug_pub.add('QUOTE_OPPTY.ORG_ID: ' || l_Qte_Opportunity_Row_Rec.O_ORG_ID,1,'N');
736 aso_debug_pub.add('QUOTE_OPPTY.PACKING_INSTRUCTIONS: ' || l_Qte_Opportunity_Row_Rec.O_PACKING_INSTRUCTIONS,1,'N');
737 aso_debug_pub.add('QUOTE_OPPTY.PARTY_ID: ' || l_Qte_Opportunity_Row_Rec.O_PARTY_ID,1,'N');
738 aso_debug_pub.add('QUOTE_OPPTY.PAYMENT_REF_NUMBER: ' || l_Qte_Opportunity_Row_Rec.O_PAYMENT_REF_NUMBER,1,'N');
739 aso_debug_pub.add('QUOTE_OPPTY.PAYMENT_TERM_ID: ' || l_Qte_Opportunity_Row_Rec.O_PAYMENT_TERM_ID,1,'N');
740 aso_debug_pub.add('QUOTE_OPPTY.PAYMENT_TYPE_CODE: ' || l_Qte_Opportunity_Row_Rec.O_PAYMENT_TYPE_CODE,1,'N');
741 aso_debug_pub.add('QUOTE_OPPTY.PHONE_ID: ' || l_Qte_Opportunity_Row_Rec.O_PHONE_ID,1,'N');
742 aso_debug_pub.add('QUOTE_OPPTY.PRICE_FROZEN_DATE: ' || l_Qte_Opportunity_Row_Rec.O_PRICE_FROZEN_DATE,1,'N');
743 aso_debug_pub.add('QUOTE_OPPTY.PRICE_LIST_ID: ' || l_Qte_Opportunity_Row_Rec.O_PRICE_LIST_ID,1,'N');
744 aso_debug_pub.add('QUOTE_OPPTY.QUOTE_EXPIRATION_DATE: ' || l_Qte_Opportunity_Row_Rec.O_QUOTE_EXP_DATE,1,'N');
745 aso_debug_pub.add('QUOTE_OPPTY.QUOTE_HEADER_ID: ' || l_Qte_Opportunity_Row_Rec.O_QUOTE_HEADER_ID,1,'N');
746 aso_debug_pub.add('QUOTE_OPPTY.QUOTE_NAME: ' || l_Qte_Opportunity_Row_Rec.O_QUOTE_NAME,1,'N');
747 aso_debug_pub.add('QUOTE_OPPTY.QUOTE_STATUS_ID: ' || l_Qte_Opportunity_Row_Rec.O_QUOTE_STATUS_ID,1,'N');
748 aso_debug_pub.add('QUOTE_OPPTY.QUOTE_TO_CUSTOMER_TYPE: ' || l_Qte_Opportunity_Row_Rec.O_QUOTE_TO_CUST_TYPE,1,'N');
749 aso_debug_pub.add('QUOTE_OPPTY.REQUEST_DATE: ' || l_Qte_Opportunity_Row_Rec.O_REQUEST_DATE,1,'N');
750 aso_debug_pub.add('QUOTE_OPPTY.REQUEST_DATE_TYPE: ' || l_Qte_Opportunity_Row_Rec.O_REQUEST_DATE_TYPE,1,'N');
751 aso_debug_pub.add('QUOTE_OPPTY.RESOURCE_GRP_ID: ' || l_Qte_Opportunity_Row_Rec.O_RESOURCE_GRP_ID,1,'N');
752 aso_debug_pub.add('QUOTE_OPPTY.RESOURCE_ID: ' || l_Qte_Opportunity_Row_Rec.O_RESOURCE_ID,1,'N');
753 aso_debug_pub.add('QUOTE_OPPTY.SALES_CHANNEL_CODE: ' || l_Qte_Opportunity_Row_Rec.O_SALES_CHANNEL_CODE,1,'N');
754 aso_debug_pub.add('QUOTE_OPPTY.SHIPMENT_PRIORITY_CODE: ' || l_Qte_Opportunity_Row_Rec.O_SHIPMENT_PRIORITY_CODE,1,'N');
755 aso_debug_pub.add('QUOTE_OPPTY.SHIPPING_INSTRUCTIONS: ' || l_Qte_Opportunity_Row_Rec.O_SHIPPING_INSTRUCTIONS,1,'N');
756 aso_debug_pub.add('QUOTE_OPPTY.SHIP_METHOD_CODE: ' || l_Qte_Opportunity_Row_Rec.O_SHIP_METHOD_CODE,1,'N');
757 aso_debug_pub.add('QUOTE_OPPTY.SHIP_TO_CUST_ACCOUNT_ID: ' || l_Qte_Opportunity_Row_Rec.O_SHIP_TO_CUST_ACCT_ID,1,'N');
758 aso_debug_pub.add('QUOTE_OPPTY.SHIP_TO_CUST_PARTY_ID: ' || l_Qte_Opportunity_Row_Rec.O_SHIP_TO_CUST_PTY_ID,1,'N');
759 aso_debug_pub.add('QUOTE_OPPTY.SHIP_TO_PARTY_ID: ' || l_Qte_Opportunity_Row_Rec.O_SHIP_TO_PTY_ID,1,'N');
760 aso_debug_pub.add('QUOTE_OPPTY.SHIP_TO_PARTY_SITE_ID: ' || l_Qte_Opportunity_Row_Rec.O_SHIP_TO_PTY_SITE_ID,1,'N');
761 aso_debug_pub.add('QUOTE_OPPTY.SOLD_TO_PARTY_SITE_ID: ' || l_Qte_Opportunity_Row_Rec.O_SOLD_TO_PARTY_SITE_ID,1,'N');
762 aso_debug_pub.add('############# BEFORE QUOTE_OPPTY DEFAULT HDLR END #############' ,1,'N');
763 END IF;
764
765 ASO_QUOTE_OPPTY_DEF_HDLR.Default_Record
766 (
767 p_x_rec => l_Qte_Opportunity_Row_Rec,
768 p_in_old_rec => l_Qte_Opportunity_Row_Rec);
769
770 IF aso_debug_pub.g_debug_flag = 'Y' THEN
771 aso_debug_pub.add('############# AFTER QUOTE_OPPTY DEFAULT HDLR START #############' ,1,'N');
772 aso_debug_pub.add('QUOTE_OPPTY.APPLICATION_TYPE_CODE: ' || l_Qte_Opportunity_Row_Rec.O_APPLICATION_TYPE_CODE,1,'N');
773 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE1: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE1,1,'N');
774 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE10: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE10,1,'N');
775 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE11: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE11,1,'N');
776 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE12: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE12,1,'N');
777 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE13: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE13,1,'N');
778 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE14: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE14,1,'N');
779 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE15: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE15,1,'N');
780 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE16: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE16,1,'N');
781 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE17: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE17,1,'N');
782 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE18: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE18,1,'N');
783 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE19: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE19,1,'N');
784 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE2: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE2,1,'N');
785 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE20: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE20,1,'N');
786 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE3: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE3,1,'N');
787 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE4: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE4,1,'N');
788 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE5: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE5,1,'N');
789 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE6: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE6,1,'N');
790 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE7: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE7,1,'N');
791 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE8: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE8,1,'N');
792 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE9: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE9,1,'N');
793 aso_debug_pub.add('QUOTE_OPPTY.ATTRIBUTE_CATEGORY: ' || l_Qte_Opportunity_Row_Rec.O_ATTRIBUTE_CATEGORY,1,'N');
794 aso_debug_pub.add('QUOTE_OPPTY.AUTOMATIC_PRICE_FLAG: ' || l_Qte_Opportunity_Row_Rec.O_AUTOMATIC_PRICE_FLAG,1,'N');
795 aso_debug_pub.add('QUOTE_OPPTY.AUTOMATIC_TAX_FLAG: ' || l_Qte_Opportunity_Row_Rec.O_AUTOMATIC_TAX_FLAG,1,'N');
796 aso_debug_pub.add('QUOTE_OPPTY.CONTRACT_ID: ' || l_Qte_Opportunity_Row_Rec.O_CONTRACT_ID,1,'N');
797 aso_debug_pub.add('QUOTE_OPPTY.CONTRACT_TEMPLATE_ID: ' || l_Qte_Opportunity_Row_Rec.O_CONTRACT_TEMPLATE_ID,1,'N');
798 aso_debug_pub.add('QUOTE_OPPTY.CREATED_BY: ' || l_Qte_Opportunity_Row_Rec.O_CREATED_BY,1,'N');
799 aso_debug_pub.add('QUOTE_OPPTY.CREDIT_CARD_CODE: ' || l_Qte_Opportunity_Row_Rec.O_CREDIT_CARD_CODE,1,'N');
800 aso_debug_pub.add('QUOTE_OPPTY.CREDIT_CARD_EXPIRATION_DATE: ' || l_Qte_Opportunity_Row_Rec.O_CREDIT_CARD_EXP_DATE,1,'N');
801 aso_debug_pub.add('QUOTE_OPPTY.CREDIT_CARD_HOLDER_NAME: ' || l_Qte_Opportunity_Row_Rec.O_CREDIT_CARD_HLD_NAME,1,'N');
802 aso_debug_pub.add('QUOTE_OPPTY.CURRENCY_CODE: ' || l_Qte_Opportunity_Row_Rec.O_CURRENCY_CODE,1,'N');
803 aso_debug_pub.add('QUOTE_OPPTY.CUST_ACCOUNT_ID: ' || l_Qte_Opportunity_Row_Rec.O_CUST_ACCOUNT_ID,1,'N');
804 aso_debug_pub.add('QUOTE_OPPTY.CUST_PARTY_ID: ' || l_Qte_Opportunity_Row_Rec.O_CUST_PARTY_ID,1,'N');
805 aso_debug_pub.add('QUOTE_OPPTY.CUST_PO_NUMBER: ' || l_Qte_Opportunity_Row_Rec.O_CUST_PO_NUMBER,1,'N');
806 aso_debug_pub.add('QUOTE_OPPTY.DEMAND_CLASS_CODE: ' || l_Qte_Opportunity_Row_Rec.O_DEMAND_CLASS_CODE,1,'N');
807 aso_debug_pub.add('QUOTE_OPPTY.END_CUSTOMER_CUST_ACCOUNT_ID: ' || l_Qte_Opportunity_Row_Rec.O_END_CUST_CUST_ACCT_ID,1,'N');
808 aso_debug_pub.add('QUOTE_OPPTY.END_CUSTOMER_CUST_PARTY_ID: ' || l_Qte_Opportunity_Row_Rec.O_END_CUST_CUST_PTY_ID,1,'N');
809 aso_debug_pub.add('QUOTE_OPPTY.END_CUSTOMER_PARTY_ID: ' || l_Qte_Opportunity_Row_Rec.O_END_CUST_PTY_ID,1,'N');
810 aso_debug_pub.add('QUOTE_OPPTY.END_CUSTOMER_PARTY_SITE_ID: ' || l_Qte_Opportunity_Row_Rec.O_END_CUST_PTY_SITE_ID,1,'N');
811 aso_debug_pub.add('QUOTE_OPPTY.FOB_CODE: ' || l_Qte_Opportunity_Row_Rec.O_FOB_CODE,1,'N');
812 aso_debug_pub.add('QUOTE_OPPTY.FREIGHT_TERMS_CODE: ' || l_Qte_Opportunity_Row_Rec.O_FREIGHT_TERMS_CODE,1,'N');
813 aso_debug_pub.add('QUOTE_OPPTY.INVOICE_TO_CUST_ACCOUNT_ID: ' || l_Qte_Opportunity_Row_Rec.O_INV_CUST_ACCT_ID,1,'N');
814 aso_debug_pub.add('QUOTE_OPPTY.INVOICE_TO_CUST_PARTY_ID: ' || l_Qte_Opportunity_Row_Rec.O_INV_CUST_PTY_ID,1,'N');
815 aso_debug_pub.add('QUOTE_OPPTY.INVOICE_TO_PARTY_ID: ' || l_Qte_Opportunity_Row_Rec.O_INV_PTY_ID,1,'N');
816 aso_debug_pub.add('QUOTE_OPPTY.INVOICE_TO_PARTY_SITE_ID: ' || l_Qte_Opportunity_Row_Rec.O_INV_PTY_SITE_ID,1,'N');
817 aso_debug_pub.add('QUOTE_OPPTY.LAST_UPDATE_DATE: ' || l_Qte_Opportunity_Row_Rec.O_LAST_UPDATE_DATE,1,'N');
818 aso_debug_pub.add('QUOTE_OPPTY.MARKETING_SOURCE_CODE_ID: ' || l_Qte_Opportunity_Row_Rec.O_MKTING_SRC_CODE_ID,1,'N');
819 aso_debug_pub.add('QUOTE_OPPTY.OBJECT_VERSION_NUMBER: ' || l_Qte_Opportunity_Row_Rec.O_OBJECT_VERSION_NUMBER,1,'N');
820 aso_debug_pub.add('QUOTE_OPPTY.OPPTY_CHANNEL_CODE: ' || l_Qte_Opportunity_Row_Rec.O_OPPTY_CHANNEL_CODE,1,'N');
821 aso_debug_pub.add('QUOTE_OPPTY.OPPTY_CURRENCY_CODE: ' || l_Qte_Opportunity_Row_Rec.O_OPPTY_CURRENCY_CODE,1,'N');
822 aso_debug_pub.add('QUOTE_OPPTY.OPPTY_CUST_PARTY_ID: ' || l_Qte_Opportunity_Row_Rec.O_OPPTY_CUST_PARTY_ID,1,'N');
823 aso_debug_pub.add('QUOTE_OPPTY.OPPTY_ID: ' || l_Qte_Opportunity_Row_Rec.O_OPPTY_ID,1,'N');
824 aso_debug_pub.add('QUOTE_OPPTY.OPPTY_MKTG_SRC_CODE_ID: ' || l_Qte_Opportunity_Row_Rec.O_OPPTY_MKTG_SRC_CD_ID,1,'N');
825 aso_debug_pub.add('QUOTE_OPPTY.OPPTY_QUOTE_NAME: ' || l_Qte_Opportunity_Row_Rec.O_OPPTY_QUOTE_NAME,1,'N');
826 aso_debug_pub.add('QUOTE_OPPTY.OPPTY_SOLD_TO_CONTACT_ID: ' || l_Qte_Opportunity_Row_Rec.O_OPPTY_SLD_TO_CONT_ID,1,'N');
827 aso_debug_pub.add('QUOTE_OPPTY.OPPTY_SOLD_TO_PARTY_SITE_ID: ' || l_Qte_Opportunity_Row_Rec.O_OPPTY_SLD_PTY_ST_ID,1,'N');
828 aso_debug_pub.add('QUOTE_OPPTY.ORDER_TYPE_ID: ' || l_Qte_Opportunity_Row_Rec.O_ORDER_TYPE_ID,1,'N');
829 aso_debug_pub.add('QUOTE_OPPTY.ORG_ID: ' || l_Qte_Opportunity_Row_Rec.O_ORG_ID,1,'N');
830 aso_debug_pub.add('QUOTE_OPPTY.PACKING_INSTRUCTIONS: ' || l_Qte_Opportunity_Row_Rec.O_PACKING_INSTRUCTIONS,1,'N');
831 aso_debug_pub.add('QUOTE_OPPTY.PARTY_ID: ' || l_Qte_Opportunity_Row_Rec.O_PARTY_ID,1,'N');
832 aso_debug_pub.add('QUOTE_OPPTY.PAYMENT_REF_NUMBER: ' || l_Qte_Opportunity_Row_Rec.O_PAYMENT_REF_NUMBER,1,'N');
833 aso_debug_pub.add('QUOTE_OPPTY.PAYMENT_TERM_ID: ' || l_Qte_Opportunity_Row_Rec.O_PAYMENT_TERM_ID,1,'N');
834 aso_debug_pub.add('QUOTE_OPPTY.PAYMENT_TYPE_CODE: ' || l_Qte_Opportunity_Row_Rec.O_PAYMENT_TYPE_CODE,1,'N');
835 aso_debug_pub.add('QUOTE_OPPTY.PHONE_ID: ' || l_Qte_Opportunity_Row_Rec.O_PHONE_ID,1,'N');
836 aso_debug_pub.add('QUOTE_OPPTY.PRICE_FROZEN_DATE: ' || l_Qte_Opportunity_Row_Rec.O_PRICE_FROZEN_DATE,1,'N');
837 aso_debug_pub.add('QUOTE_OPPTY.PRICE_LIST_ID: ' || l_Qte_Opportunity_Row_Rec.O_PRICE_LIST_ID,1,'N');
838 aso_debug_pub.add('QUOTE_OPPTY.QUOTE_EXPIRATION_DATE: ' || l_Qte_Opportunity_Row_Rec.O_QUOTE_EXP_DATE,1,'N');
839 aso_debug_pub.add('QUOTE_OPPTY.QUOTE_HEADER_ID: ' || l_Qte_Opportunity_Row_Rec.O_QUOTE_HEADER_ID,1,'N');
840 aso_debug_pub.add('QUOTE_OPPTY.QUOTE_NAME: ' || l_Qte_Opportunity_Row_Rec.O_QUOTE_NAME,1,'N');
841 aso_debug_pub.add('QUOTE_OPPTY.QUOTE_STATUS_ID: ' || l_Qte_Opportunity_Row_Rec.O_QUOTE_STATUS_ID,1,'N');
842 aso_debug_pub.add('QUOTE_OPPTY.QUOTE_TO_CUSTOMER_TYPE: ' || l_Qte_Opportunity_Row_Rec.O_QUOTE_TO_CUST_TYPE,1,'N');
843 aso_debug_pub.add('QUOTE_OPPTY.REQUEST_DATE: ' || l_Qte_Opportunity_Row_Rec.O_REQUEST_DATE,1,'N');
844 aso_debug_pub.add('QUOTE_OPPTY.REQUEST_DATE_TYPE: ' || l_Qte_Opportunity_Row_Rec.O_REQUEST_DATE_TYPE,1,'N');
845 aso_debug_pub.add('QUOTE_OPPTY.RESOURCE_GRP_ID: ' || l_Qte_Opportunity_Row_Rec.O_RESOURCE_GRP_ID,1,'N');
846 aso_debug_pub.add('QUOTE_OPPTY.RESOURCE_ID: ' || l_Qte_Opportunity_Row_Rec.O_RESOURCE_ID,1,'N');
847 aso_debug_pub.add('QUOTE_OPPTY.SALES_CHANNEL_CODE: ' || l_Qte_Opportunity_Row_Rec.O_SALES_CHANNEL_CODE,1,'N');
848 aso_debug_pub.add('QUOTE_OPPTY.SHIPMENT_PRIORITY_CODE: ' || l_Qte_Opportunity_Row_Rec.O_SHIPMENT_PRIORITY_CODE,1,'N');
849 aso_debug_pub.add('QUOTE_OPPTY.SHIPPING_INSTRUCTIONS: ' || l_Qte_Opportunity_Row_Rec.O_SHIPPING_INSTRUCTIONS,1,'N');
850 aso_debug_pub.add('QUOTE_OPPTY.SHIP_METHOD_CODE: ' || l_Qte_Opportunity_Row_Rec.O_SHIP_METHOD_CODE,1,'N');
851 aso_debug_pub.add('QUOTE_OPPTY.SHIP_TO_CUST_ACCOUNT_ID: ' || l_Qte_Opportunity_Row_Rec.O_SHIP_TO_CUST_ACCT_ID,1,'N');
852 aso_debug_pub.add('QUOTE_OPPTY.SHIP_TO_CUST_PARTY_ID: ' || l_Qte_Opportunity_Row_Rec.O_SHIP_TO_CUST_PTY_ID,1,'N');
853 aso_debug_pub.add('QUOTE_OPPTY.SHIP_TO_PARTY_ID: ' || l_Qte_Opportunity_Row_Rec.O_SHIP_TO_PTY_ID,1,'N');
854 aso_debug_pub.add('QUOTE_OPPTY.SHIP_TO_PARTY_SITE_ID: ' || l_Qte_Opportunity_Row_Rec.O_SHIP_TO_PTY_SITE_ID,1,'N');
855 aso_debug_pub.add('QUOTE_OPPTY.SOLD_TO_PARTY_SITE_ID: ' || l_Qte_Opportunity_Row_Rec.O_SOLD_TO_PARTY_SITE_ID,1,'N');
856 aso_debug_pub.add('############# AFTER QUOTE_OPPTY DEFAULT HDLR END #############' ,1,'N');
857 END IF;
858
859 END IF;
860
861 END IF; -- Defaulting Flag
862
863 OE_MSG_PUB.Count_And_Get
864 ( p_count => l_msg_count,
865 p_data => l_msg_data
866 );
867
868 x_msg_count := 0;
869
870 IF l_msg_count > l_msg_count_start THEN
871
872 x_msg_count := l_msg_count;
873 x_msg_data := l_msg_data;
874
875 FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_DEFAULTING_RULE');
876 FND_MSG_PUB.ADD;
877 RAISE FND_API.G_EXC_ERROR;
878
879 END IF;
880
881 ASO_DEFAULTING_UTIL.Row_To_Api_Rec_Type
882 (
883 p_entity_code => l_entity_code,
884 P_Qte_Header_Row_Rec => l_Qte_Header_Row_Rec,
885 P_Qte_Opportunity_Row_Rec => l_Qte_Opportunity_Row_Rec,
886 P_Qte_Line_Row_Rec => l_Qte_Line_Row_Rec,
887 X_Quote_Header_Rec => l_Quote_Header_Rec,
888 X_Header_Shipment_Rec => l_Header_Shipment_Rec,
889 X_Header_Payment_Rec => l_Header_Payment_Rec,
890 X_Quote_Line_Rec => l_Quote_Line_Rec,
891 X_Line_Shipment_Rec => l_Line_Shipment_Rec,
892 X_Line_Payment_Rec => l_Line_Payment_Rec,
893 X_Header_Misc_Rec => l_Header_Misc_Rec,
894 X_Header_Tax_Detail_Rec => l_Header_Tax_Detail_Rec,
895 X_Line_Misc_Rec => l_Line_Misc_Rec,
896 X_Line_Tax_Detail_Rec => l_Line_Tax_Detail_Rec);
897
898
899 X_Quote_Header_Rec := l_Quote_Header_Rec;
900 X_Header_Shipment_Rec := l_Header_Shipment_Rec;
901 X_Header_Payment_Rec := l_Header_Payment_Rec;
902 X_Quote_Line_Rec := l_Quote_Line_Rec;
903 X_Line_Shipment_Rec := l_Line_Shipment_Rec;
904 X_Line_Payment_Rec := l_Line_Payment_Rec;
905 X_Header_Misc_Rec := l_Header_Misc_Rec;
906 X_Header_Tax_Detail_Rec := l_Header_Tax_Detail_Rec;
907 X_Line_Misc_Rec := l_Line_Misc_Rec;
908 X_Line_Tax_Detail_Rec := l_Line_Tax_Detail_Rec;
909
910 EXCEPTION
911
912 WHEN FND_API.G_EXC_ERROR THEN
913 ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
914 P_API_NAME => L_API_NAME,
915 P_PKG_NAME => G_PKG_NAME,
916 P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
917 P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
918 P_SQLCODE => SQLCODE,
919 P_SQLERRM => SQLERRM,
920 X_MSG_COUNT => X_MSG_COUNT,
921 X_MSG_DATA => X_MSG_DATA,
922 X_RETURN_STATUS => X_RETURN_STATUS
923 );
924
925 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
926 ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
927 P_API_NAME => L_API_NAME,
928 P_PKG_NAME => G_PKG_NAME,
929 P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
930 P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
931 P_SQLCODE => SQLCODE,
932 P_SQLERRM => SQLERRM,
933 X_MSG_COUNT => X_MSG_COUNT,
934 X_MSG_DATA => X_MSG_DATA,
935 X_RETURN_STATUS => X_RETURN_STATUS
936 );
937
938 WHEN OTHERS THEN
939 ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
940 P_API_NAME => L_API_NAME,
941 P_PKG_NAME => G_PKG_NAME,
942 P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
943 P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
944 P_SQLCODE => SQLCODE,
945 P_SQLERRM => SQLERRM,
946 X_MSG_COUNT => X_MSG_COUNT,
947 X_MSG_DATA => X_MSG_DATA,
948 X_RETURN_STATUS => X_RETURN_STATUS
949 );
950
951 END DEFAULT_ENTITY;
952
953
954 END ASO_DEFAULTING_INT;