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.

[Home] [Help]

APPS.ASO_CHECK_TCA_PVT dependencies on ASO_DEBUG_PUB

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

72: END IF;
73:
74: x_return_status := FND_API.g_ret_sts_success;
75:
76: IF aso_debug_pub.g_debug_flag = 'Y' THEN
77: aso_debug_pub.add('Check_Tca: begin', 1, 'N');
78: aso_debug_pub.add('Check_Tca: p_qte_rec.party_id: '||p_qte_rec.party_id, 1, 'N');
79: aso_debug_pub.add('Check_Tca: p_qte_rec.cust_party_id: '||p_qte_rec.cust_party_id, 1, 'N');
80: aso_debug_pub.add('Check_Tca: p_qte_rec.cust_account_id: '||p_qte_rec.cust_account_id, 1, 'N');

Line 77: aso_debug_pub.add('Check_Tca: begin', 1, 'N');

73:
74: x_return_status := FND_API.g_ret_sts_success;
75:
76: IF aso_debug_pub.g_debug_flag = 'Y' THEN
77: aso_debug_pub.add('Check_Tca: begin', 1, 'N');
78: aso_debug_pub.add('Check_Tca: p_qte_rec.party_id: '||p_qte_rec.party_id, 1, 'N');
79: aso_debug_pub.add('Check_Tca: p_qte_rec.cust_party_id: '||p_qte_rec.cust_party_id, 1, 'N');
80: aso_debug_pub.add('Check_Tca: p_qte_rec.cust_account_id: '||p_qte_rec.cust_account_id, 1, 'N');
81: END IF;

Line 78: aso_debug_pub.add('Check_Tca: p_qte_rec.party_id: '||p_qte_rec.party_id, 1, 'N');

74: x_return_status := FND_API.g_ret_sts_success;
75:
76: IF aso_debug_pub.g_debug_flag = 'Y' THEN
77: aso_debug_pub.add('Check_Tca: begin', 1, 'N');
78: aso_debug_pub.add('Check_Tca: p_qte_rec.party_id: '||p_qte_rec.party_id, 1, 'N');
79: aso_debug_pub.add('Check_Tca: p_qte_rec.cust_party_id: '||p_qte_rec.cust_party_id, 1, 'N');
80: aso_debug_pub.add('Check_Tca: p_qte_rec.cust_account_id: '||p_qte_rec.cust_account_id, 1, 'N');
81: END IF;
82:

Line 79: aso_debug_pub.add('Check_Tca: p_qte_rec.cust_party_id: '||p_qte_rec.cust_party_id, 1, 'N');

75:
76: IF aso_debug_pub.g_debug_flag = 'Y' THEN
77: aso_debug_pub.add('Check_Tca: begin', 1, 'N');
78: aso_debug_pub.add('Check_Tca: p_qte_rec.party_id: '||p_qte_rec.party_id, 1, 'N');
79: aso_debug_pub.add('Check_Tca: p_qte_rec.cust_party_id: '||p_qte_rec.cust_party_id, 1, 'N');
80: aso_debug_pub.add('Check_Tca: p_qte_rec.cust_account_id: '||p_qte_rec.cust_account_id, 1, 'N');
81: END IF;
82:
83: IF (p_application_type_code = 'QUOTING HTML' AND p_operation_code = 'UPDATE') THEN

Line 80: aso_debug_pub.add('Check_Tca: p_qte_rec.cust_account_id: '||p_qte_rec.cust_account_id, 1, 'N');

76: IF aso_debug_pub.g_debug_flag = 'Y' THEN
77: aso_debug_pub.add('Check_Tca: begin', 1, 'N');
78: aso_debug_pub.add('Check_Tca: p_qte_rec.party_id: '||p_qte_rec.party_id, 1, 'N');
79: aso_debug_pub.add('Check_Tca: p_qte_rec.cust_party_id: '||p_qte_rec.cust_party_id, 1, 'N');
80: aso_debug_pub.add('Check_Tca: p_qte_rec.cust_account_id: '||p_qte_rec.cust_account_id, 1, 'N');
81: END IF;
82:
83: IF (p_application_type_code = 'QUOTING HTML' AND p_operation_code = 'UPDATE') THEN
84: l_qte_header_rec := ASO_UTILITY_PVT.query_header_row (p_qte_rec.quote_header_id);

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

199: END IF;
200:
201: END IF; -- party_id is null
202:
203: IF aso_debug_pub.g_debug_flag = 'Y' THEN
204: aso_debug_pub.add('Check_Tca: p_qte_rec.party_id: '||p_qte_rec.party_id, 1, 'N');
205: END IF;
206:
207: IF p_qte_rec.party_id IS NOT NULL AND p_qte_rec.party_id <> FND_API.G_MISS_NUM THEN

Line 204: aso_debug_pub.add('Check_Tca: p_qte_rec.party_id: '||p_qte_rec.party_id, 1, 'N');

200:
201: END IF; -- party_id is null
202:
203: IF aso_debug_pub.g_debug_flag = 'Y' THEN
204: aso_debug_pub.add('Check_Tca: p_qte_rec.party_id: '||p_qte_rec.party_id, 1, 'N');
205: END IF;
206:
207: IF p_qte_rec.party_id IS NOT NULL AND p_qte_rec.party_id <> FND_API.G_MISS_NUM THEN
208:

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

211: OPEN C_Party_Type(p_qte_rec.party_id);
212: FETCH C_Party_Type INTO l_party_type;
213: CLOSE C_Party_Type;
214:
215: IF aso_debug_pub.g_debug_flag = 'Y' THEN
216: aso_debug_pub.add('Check_Tca: l_party_type: '||l_party_type, 1, 'N');
217: END IF;
218:
219: IF l_party_type = 'PERSON' OR l_party_type = 'ORGANIZATION' THEN

Line 216: aso_debug_pub.add('Check_Tca: l_party_type: '||l_party_type, 1, 'N');

212: FETCH C_Party_Type INTO l_party_type;
213: CLOSE C_Party_Type;
214:
215: IF aso_debug_pub.g_debug_flag = 'Y' THEN
216: aso_debug_pub.add('Check_Tca: l_party_type: '||l_party_type, 1, 'N');
217: END IF;
218:
219: IF l_party_type = 'PERSON' OR l_party_type = 'ORGANIZATION' THEN
220:

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

229: END IF;
230:
231: END IF; -- cust_party_id
232:
233: IF aso_debug_pub.g_debug_flag = 'Y' THEN
234: aso_debug_pub.add('Check_Tca: p_qte_rec.cust_party_id: '||p_qte_rec.cust_party_id, 1, 'N');
235: END IF;
236:
237: IF p_qte_rec.cust_account_id IS NULL OR p_qte_rec.cust_account_id = FND_API.G_MISS_NUM THEN

Line 234: aso_debug_pub.add('Check_Tca: p_qte_rec.cust_party_id: '||p_qte_rec.cust_party_id, 1, 'N');

230:
231: END IF; -- cust_party_id
232:
233: IF aso_debug_pub.g_debug_flag = 'Y' THEN
234: aso_debug_pub.add('Check_Tca: p_qte_rec.cust_party_id: '||p_qte_rec.cust_party_id, 1, 'N');
235: END IF;
236:
237: IF p_qte_rec.cust_account_id IS NULL OR p_qte_rec.cust_account_id = FND_API.G_MISS_NUM THEN
238:

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

235: END IF;
236:
237: IF p_qte_rec.cust_account_id IS NULL OR p_qte_rec.cust_account_id = FND_API.G_MISS_NUM THEN
238:
239: IF aso_debug_pub.g_debug_flag = 'Y' THEN
240: aso_debug_pub.add('Check_Tca: before customer account:p_qte_rec.party_id '||p_qte_rec.party_id, 1, 'N');
241: END IF;
242:
243: Customer_Account(

Line 240: aso_debug_pub.add('Check_Tca: before customer account:p_qte_rec.party_id '||p_qte_rec.party_id, 1, 'N');

236:
237: IF p_qte_rec.cust_account_id IS NULL OR p_qte_rec.cust_account_id = FND_API.G_MISS_NUM THEN
238:
239: IF aso_debug_pub.g_debug_flag = 'Y' THEN
240: aso_debug_pub.add('Check_Tca: before customer account:p_qte_rec.party_id '||p_qte_rec.party_id, 1, 'N');
241: END IF;
242:
243: Customer_Account(
244: p_api_version => 1.0,

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

248: x_return_status => x_return_status,
249: x_msg_count => x_msg_count,
250: x_msg_data => x_msg_data);
251:
252: IF aso_debug_pub.g_debug_flag = 'Y' THEN
253: aso_debug_pub.add('Check_Tca: after customer account:x_Return_Status '||x_Return_Status, 1, 'N');
254: END IF;
255: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
256: raise FND_API.G_EXC_ERROR;

Line 253: aso_debug_pub.add('Check_Tca: after customer account:x_Return_Status '||x_Return_Status, 1, 'N');

249: x_msg_count => x_msg_count,
250: x_msg_data => x_msg_data);
251:
252: IF aso_debug_pub.g_debug_flag = 'Y' THEN
253: aso_debug_pub.add('Check_Tca: after customer account:x_Return_Status '||x_Return_Status, 1, 'N');
254: END IF;
255: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
256: raise FND_API.G_EXC_ERROR;
257: END IF;

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

257: END IF;
258:
259: END IF; -- cust_account_id
260:
261: IF aso_debug_pub.g_debug_flag = 'Y' THEN
262: aso_debug_pub.add('Check_Tca: p_qte_rec.cust_account_id: '||p_qte_rec.cust_account_id, 1, 'N');
263: END IF;
264:
265: END IF; -- party_id is not null

Line 262: aso_debug_pub.add('Check_Tca: p_qte_rec.cust_account_id: '||p_qte_rec.cust_account_id, 1, 'N');

258:
259: END IF; -- cust_account_id
260:
261: IF aso_debug_pub.g_debug_flag = 'Y' THEN
262: aso_debug_pub.add('Check_Tca: p_qte_rec.cust_account_id: '||p_qte_rec.cust_account_id, 1, 'N');
263: END IF;
264:
265: END IF; -- party_id is not null
266:

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

266:
267: lx_cust_account_id := p_qte_rec.cust_account_id;
268:
269: IF lx_cust_account_id IS NOT NULL AND lx_cust_account_id <> FND_API.G_MISS_NUM THEN
270: IF aso_debug_pub.g_debug_flag = 'Y' THEN
271: aso_debug_pub.add('before org contact', 1, 'N');
272: END IF;
273: IF p_qte_rec.party_id is not null and
274: p_qte_rec.party_id <> FND_API.G_MISS_NUM THEN

Line 271: aso_debug_pub.add('before org contact', 1, 'N');

267: lx_cust_account_id := p_qte_rec.cust_account_id;
268:
269: IF lx_cust_account_id IS NOT NULL AND lx_cust_account_id <> FND_API.G_MISS_NUM THEN
270: IF aso_debug_pub.g_debug_flag = 'Y' THEN
271: aso_debug_pub.add('before org contact', 1, 'N');
272: END IF;
273: IF p_qte_rec.party_id is not null and
274: p_qte_rec.party_id <> FND_API.G_MISS_NUM THEN
275:

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

272: END IF;
273: IF p_qte_rec.party_id is not null and
274: p_qte_rec.party_id <> FND_API.G_MISS_NUM THEN
275:
276: IF aso_debug_pub.g_debug_flag = 'Y' THEN
277: aso_debug_pub.add('before org contact:p_qte_rec.org_contact_id: '||p_qte_rec.org_contact_id, 1, 'N');
278: END IF;
279: IF p_qte_rec.org_contact_id is NULL OR
280: p_qte_rec.org_contact_id = FND_API.G_MISS_NUM THEN

Line 277: aso_debug_pub.add('before org contact:p_qte_rec.org_contact_id: '||p_qte_rec.org_contact_id, 1, 'N');

273: IF p_qte_rec.party_id is not null and
274: p_qte_rec.party_id <> FND_API.G_MISS_NUM THEN
275:
276: IF aso_debug_pub.g_debug_flag = 'Y' THEN
277: aso_debug_pub.add('before org contact:p_qte_rec.org_contact_id: '||p_qte_rec.org_contact_id, 1, 'N');
278: END IF;
279: IF p_qte_rec.org_contact_id is NULL OR
280: p_qte_rec.org_contact_id = FND_API.G_MISS_NUM THEN
281: ASO_MAP_QUOTE_ORDER_INT.get_org_contact(p_party_id => p_qte_rec.party_id,

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

279: IF p_qte_rec.org_contact_id is NULL OR
280: p_qte_rec.org_contact_id = FND_API.G_MISS_NUM THEN
281: ASO_MAP_QUOTE_ORDER_INT.get_org_contact(p_party_id => p_qte_rec.party_id,
282: x_org_contact => l_org_contact);
283: IF aso_debug_pub.g_debug_flag = 'Y' THEN
284: aso_debug_pub.add('after org contact:l_org_contact: '||l_org_contact, 1, 'N');
285: END IF;
286: ELSE
287: l_org_contact := p_qte_rec.org_contact_id;

Line 284: aso_debug_pub.add('after org contact:l_org_contact: '||l_org_contact, 1, 'N');

280: p_qte_rec.org_contact_id = FND_API.G_MISS_NUM THEN
281: ASO_MAP_QUOTE_ORDER_INT.get_org_contact(p_party_id => p_qte_rec.party_id,
282: x_org_contact => l_org_contact);
283: IF aso_debug_pub.g_debug_flag = 'Y' THEN
284: aso_debug_pub.add('after org contact:l_org_contact: '||l_org_contact, 1, 'N');
285: END IF;
286: ELSE
287: l_org_contact := p_qte_rec.org_contact_id;
288: END IF;

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

286: ELSE
287: l_org_contact := p_qte_rec.org_contact_id;
288: END IF;
289: IF l_org_contact is not NULL AND l_org_contact <> FND_API.G_MISS_NUM THEN
290: IF aso_debug_pub.g_debug_flag = 'Y' THEN
291: aso_debug_pub.add('deriving org_contact_role:l_org_contact: ' || l_org_contact,1, 'N');
292: END IF;
293: ASO_MAP_QUOTE_ORDER_INT.get_org_contact_role(
294: p_Org_Contact_Id => l_org_contact

Line 291: aso_debug_pub.add('deriving org_contact_role:l_org_contact: ' || l_org_contact,1, 'N');

287: l_org_contact := p_qte_rec.org_contact_id;
288: END IF;
289: IF l_org_contact is not NULL AND l_org_contact <> FND_API.G_MISS_NUM THEN
290: IF aso_debug_pub.g_debug_flag = 'Y' THEN
291: aso_debug_pub.add('deriving org_contact_role:l_org_contact: ' || l_org_contact,1, 'N');
292: END IF;
293: ASO_MAP_QUOTE_ORDER_INT.get_org_contact_role(
294: p_Org_Contact_Id => l_org_contact
295: ,p_Cust_account_id => lx_cust_account_id

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

296: ,x_return_status => x_return_status
297: ,x_party_id => l_org_contact_party_id
298: ,x_cust_account_role_id => l_sold_to_contact_id
299: );
300: IF aso_debug_pub.g_debug_flag = 'Y' THEN
301: aso_debug_pub.add('after get org contact. l_org_contact_party_id = ' || l_org_contact_party_id ,1, 'N');
302: aso_debug_pub.add('after get org contact. sold_to_contact_id = ' || l_sold_to_contact_id ,1, 'N');
303: END IF;
304: if p_qte_rec.org_contact_id is not null and p_qte_rec.org_contact_id <> FND_API.G_MISS_NUM then

Line 301: aso_debug_pub.add('after get org contact. l_org_contact_party_id = ' || l_org_contact_party_id ,1, 'N');

297: ,x_party_id => l_org_contact_party_id
298: ,x_cust_account_role_id => l_sold_to_contact_id
299: );
300: IF aso_debug_pub.g_debug_flag = 'Y' THEN
301: aso_debug_pub.add('after get org contact. l_org_contact_party_id = ' || l_org_contact_party_id ,1, 'N');
302: aso_debug_pub.add('after get org contact. sold_to_contact_id = ' || l_sold_to_contact_id ,1, 'N');
303: END IF;
304: if p_qte_rec.org_contact_id is not null and p_qte_rec.org_contact_id <> FND_API.G_MISS_NUM then
305: p_qte_rec.party_id := l_org_contact_party_id;

Line 302: aso_debug_pub.add('after get org contact. sold_to_contact_id = ' || l_sold_to_contact_id ,1, 'N');

298: ,x_cust_account_role_id => l_sold_to_contact_id
299: );
300: IF aso_debug_pub.g_debug_flag = 'Y' THEN
301: aso_debug_pub.add('after get org contact. l_org_contact_party_id = ' || l_org_contact_party_id ,1, 'N');
302: aso_debug_pub.add('after get org contact. sold_to_contact_id = ' || l_sold_to_contact_id ,1, 'N');
303: END IF;
304: if p_qte_rec.org_contact_id is not null and p_qte_rec.org_contact_id <> FND_API.G_MISS_NUM then
305: p_qte_rec.party_id := l_org_contact_party_id;
306: end if;

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

313: raise FND_API.G_EXC_ERROR;
314: END IF;
315: IF l_sold_to_contact_id is NULL OR
316: l_sold_to_contact_id = FND_API.G_MISS_NUM THEN
317: IF aso_debug_pub.g_debug_flag = 'Y' THEN
318: aso_debug_pub.add('calling create contact role for org contact ',1, 'N');
319: END IF;
320: ASO_PARTY_INT.Create_Contact_Role (
321: p_api_version => 1.0

Line 318: aso_debug_pub.add('calling create contact role for org contact ',1, 'N');

314: END IF;
315: IF l_sold_to_contact_id is NULL OR
316: l_sold_to_contact_id = FND_API.G_MISS_NUM THEN
317: IF aso_debug_pub.g_debug_flag = 'Y' THEN
318: aso_debug_pub.add('calling create contact role for org contact ',1, 'N');
319: END IF;
320: ASO_PARTY_INT.Create_Contact_Role (
321: p_api_version => 1.0
322: ,p_party_id =>l_org_contact_party_id

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

325: ,x_msg_count => x_msg_count
326: ,x_msg_data => x_msg_data
327: ,x_cust_account_role_id => l_sold_to_contact_id
328: );
329: IF aso_debug_pub.g_debug_flag = 'Y' THEN
330: aso_debug_pub.add('after create contact role. sold_to_contact_id = ' || l_sold_to_contact_id ,1, 'N');
331: aso_debug_pub.add('after create contact role. x_return_status = ' || x_return_status ,1, 'N');
332: END IF;
333: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 330: aso_debug_pub.add('after create contact role. sold_to_contact_id = ' || l_sold_to_contact_id ,1, 'N');

326: ,x_msg_data => x_msg_data
327: ,x_cust_account_role_id => l_sold_to_contact_id
328: );
329: IF aso_debug_pub.g_debug_flag = 'Y' THEN
330: aso_debug_pub.add('after create contact role. sold_to_contact_id = ' || l_sold_to_contact_id ,1, 'N');
331: aso_debug_pub.add('after create contact role. x_return_status = ' || x_return_status ,1, 'N');
332: END IF;
333: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
334: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 331: aso_debug_pub.add('after create contact role. x_return_status = ' || x_return_status ,1, 'N');

327: ,x_cust_account_role_id => l_sold_to_contact_id
328: );
329: IF aso_debug_pub.g_debug_flag = 'Y' THEN
330: aso_debug_pub.add('after create contact role. sold_to_contact_id = ' || l_sold_to_contact_id ,1, 'N');
331: aso_debug_pub.add('after create contact role. x_return_status = ' || x_return_status ,1, 'N');
332: END IF;
333: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
334: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
335: FND_MESSAGE.Set_Name('ASO', 'ASO_ORG_CONTACT');

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

345: END IF;
346:
347: END IF; -- lx_cust_account not null
348:
349: IF aso_debug_pub.g_debug_flag = 'Y' THEN
350: aso_debug_pub.add('before check hdr info ',1, 'N');
351: END IF;
352: check_header_account_info(
353: p_api_version => 1.0,

Line 350: aso_debug_pub.add('before check hdr info ',1, 'N');

346:
347: END IF; -- lx_cust_account not null
348:
349: IF aso_debug_pub.g_debug_flag = 'Y' THEN
350: aso_debug_pub.add('before check hdr info ',1, 'N');
351: END IF;
352: check_header_account_info(
353: p_api_version => 1.0,
354: p_init_msg_list => p_init_msg_list,

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

358: x_return_status => x_return_status,
359: x_msg_count => x_msg_count,
360: x_msg_data => x_msg_data );
361:
362: IF aso_debug_pub.g_debug_flag = 'Y' THEN
363: aso_debug_pub.add('after check hdr info:x_return_status: '||x_return_status,1, 'N');
364: END IF;
365: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
366: raise FND_API.G_EXC_ERROR;

Line 363: aso_debug_pub.add('after check hdr info:x_return_status: '||x_return_status,1, 'N');

359: x_msg_count => x_msg_count,
360: x_msg_data => x_msg_data );
361:
362: IF aso_debug_pub.g_debug_flag = 'Y' THEN
363: aso_debug_pub.add('after check hdr info:x_return_status: '||x_return_status,1, 'N');
364: END IF;
365: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
366: raise FND_API.G_EXC_ERROR;
367: END IF;

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

480: END IF;
481:
482: x_return_status := FND_API.g_ret_sts_success;
483:
484: IF aso_debug_pub.g_debug_flag = 'Y' THEN
485: aso_debug_pub.add('Check_Hdr_Acct: begin ', 1, 'Y');
486: aso_debug_pub.add('Check_Hdr_Acct: before sold to party site id '|| p_qte_rec.sold_to_party_site_id, 1, 'N');
487: aso_debug_pub.add('Check_Hdr_Acct: p_qte_rec.invoice_to_cust_account_id: '|| p_qte_rec.invoice_to_cust_account_id, 1, 'N');
488: aso_debug_pub.add('Check_Hdr_Acct: p_qte_rec.invoice_to_cust_party_id: '|| p_qte_rec.invoice_to_cust_party_id, 1, 'N');

Line 485: aso_debug_pub.add('Check_Hdr_Acct: begin ', 1, 'Y');

481:
482: x_return_status := FND_API.g_ret_sts_success;
483:
484: IF aso_debug_pub.g_debug_flag = 'Y' THEN
485: aso_debug_pub.add('Check_Hdr_Acct: begin ', 1, 'Y');
486: aso_debug_pub.add('Check_Hdr_Acct: before sold to party site id '|| p_qte_rec.sold_to_party_site_id, 1, 'N');
487: aso_debug_pub.add('Check_Hdr_Acct: p_qte_rec.invoice_to_cust_account_id: '|| p_qte_rec.invoice_to_cust_account_id, 1, 'N');
488: aso_debug_pub.add('Check_Hdr_Acct: p_qte_rec.invoice_to_cust_party_id: '|| p_qte_rec.invoice_to_cust_party_id, 1, 'N');
489: aso_debug_pub.add('Check_Hdr_Acct: p_qte_rec.invoice_to_party_site_id: '|| p_qte_rec.invoice_to_party_site_id, 1, 'N');

Line 486: aso_debug_pub.add('Check_Hdr_Acct: before sold to party site id '|| p_qte_rec.sold_to_party_site_id, 1, 'N');

482: x_return_status := FND_API.g_ret_sts_success;
483:
484: IF aso_debug_pub.g_debug_flag = 'Y' THEN
485: aso_debug_pub.add('Check_Hdr_Acct: begin ', 1, 'Y');
486: aso_debug_pub.add('Check_Hdr_Acct: before sold to party site id '|| p_qte_rec.sold_to_party_site_id, 1, 'N');
487: aso_debug_pub.add('Check_Hdr_Acct: p_qte_rec.invoice_to_cust_account_id: '|| p_qte_rec.invoice_to_cust_account_id, 1, 'N');
488: aso_debug_pub.add('Check_Hdr_Acct: p_qte_rec.invoice_to_cust_party_id: '|| p_qte_rec.invoice_to_cust_party_id, 1, 'N');
489: aso_debug_pub.add('Check_Hdr_Acct: p_qte_rec.invoice_to_party_site_id: '|| p_qte_rec.invoice_to_party_site_id, 1, 'N');
490: END IF;

Line 487: aso_debug_pub.add('Check_Hdr_Acct: p_qte_rec.invoice_to_cust_account_id: '|| p_qte_rec.invoice_to_cust_account_id, 1, 'N');

483:
484: IF aso_debug_pub.g_debug_flag = 'Y' THEN
485: aso_debug_pub.add('Check_Hdr_Acct: begin ', 1, 'Y');
486: aso_debug_pub.add('Check_Hdr_Acct: before sold to party site id '|| p_qte_rec.sold_to_party_site_id, 1, 'N');
487: aso_debug_pub.add('Check_Hdr_Acct: p_qte_rec.invoice_to_cust_account_id: '|| p_qte_rec.invoice_to_cust_account_id, 1, 'N');
488: aso_debug_pub.add('Check_Hdr_Acct: p_qte_rec.invoice_to_cust_party_id: '|| p_qte_rec.invoice_to_cust_party_id, 1, 'N');
489: aso_debug_pub.add('Check_Hdr_Acct: p_qte_rec.invoice_to_party_site_id: '|| p_qte_rec.invoice_to_party_site_id, 1, 'N');
490: END IF;
491:

Line 488: aso_debug_pub.add('Check_Hdr_Acct: p_qte_rec.invoice_to_cust_party_id: '|| p_qte_rec.invoice_to_cust_party_id, 1, 'N');

484: IF aso_debug_pub.g_debug_flag = 'Y' THEN
485: aso_debug_pub.add('Check_Hdr_Acct: begin ', 1, 'Y');
486: aso_debug_pub.add('Check_Hdr_Acct: before sold to party site id '|| p_qte_rec.sold_to_party_site_id, 1, 'N');
487: aso_debug_pub.add('Check_Hdr_Acct: p_qte_rec.invoice_to_cust_account_id: '|| p_qte_rec.invoice_to_cust_account_id, 1, 'N');
488: aso_debug_pub.add('Check_Hdr_Acct: p_qte_rec.invoice_to_cust_party_id: '|| p_qte_rec.invoice_to_cust_party_id, 1, 'N');
489: aso_debug_pub.add('Check_Hdr_Acct: p_qte_rec.invoice_to_party_site_id: '|| p_qte_rec.invoice_to_party_site_id, 1, 'N');
490: END IF;
491:
492: IF p_qte_rec.sold_to_party_site_id is not NULL

Line 489: aso_debug_pub.add('Check_Hdr_Acct: p_qte_rec.invoice_to_party_site_id: '|| p_qte_rec.invoice_to_party_site_id, 1, 'N');

485: aso_debug_pub.add('Check_Hdr_Acct: begin ', 1, 'Y');
486: aso_debug_pub.add('Check_Hdr_Acct: before sold to party site id '|| p_qte_rec.sold_to_party_site_id, 1, 'N');
487: aso_debug_pub.add('Check_Hdr_Acct: p_qte_rec.invoice_to_cust_account_id: '|| p_qte_rec.invoice_to_cust_account_id, 1, 'N');
488: aso_debug_pub.add('Check_Hdr_Acct: p_qte_rec.invoice_to_cust_party_id: '|| p_qte_rec.invoice_to_cust_party_id, 1, 'N');
489: aso_debug_pub.add('Check_Hdr_Acct: p_qte_rec.invoice_to_party_site_id: '|| p_qte_rec.invoice_to_party_site_id, 1, 'N');
490: END IF;
491:
492: IF p_qte_rec.sold_to_party_site_id is not NULL
493: AND p_qte_rec.sold_to_party_site_id <> FND_API.G_MISS_NUM THEN

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

493: AND p_qte_rec.sold_to_party_site_id <> FND_API.G_MISS_NUM THEN
494:
495: OPEN C_Site_Use(p_qte_rec.sold_to_party_site_id);
496: FETCH C_Site_Use INTO l_party_site_use_id;
497: IF aso_debug_pub.g_debug_flag = 'Y' THEN
498: aso_debug_pub.add('chk_hdr:party_site_use_id = ' || l_party_site_use_id,1,'N');
499: END IF;
500: IF C_Site_Use%NOTFOUND THEN
501: ASO_PARTY_INT.Create_Party_Site_Use(

Line 498: aso_debug_pub.add('chk_hdr:party_site_use_id = ' || l_party_site_use_id,1,'N');

494:
495: OPEN C_Site_Use(p_qte_rec.sold_to_party_site_id);
496: FETCH C_Site_Use INTO l_party_site_use_id;
497: IF aso_debug_pub.g_debug_flag = 'Y' THEN
498: aso_debug_pub.add('chk_hdr:party_site_use_id = ' || l_party_site_use_id,1,'N');
499: END IF;
500: IF C_Site_Use%NOTFOUND THEN
501: ASO_PARTY_INT.Create_Party_Site_Use(
502: p_api_version => 1.0,

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

506: x_return_status => x_return_status,
507: x_msg_count => x_msg_count,
508: x_msg_data => x_msg_data);
509:
510: IF aso_debug_pub.g_debug_flag = 'Y' THEN
511: aso_debug_pub.add('chk_hdr:party_site_use_id after sold_to = ' || l_party_site_use_id,1,'N');
512: END IF;
513: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
514: raise FND_API.G_EXC_ERROR;

Line 511: aso_debug_pub.add('chk_hdr:party_site_use_id after sold_to = ' || l_party_site_use_id,1,'N');

507: x_msg_count => x_msg_count,
508: x_msg_data => x_msg_data);
509:
510: IF aso_debug_pub.g_debug_flag = 'Y' THEN
511: aso_debug_pub.add('chk_hdr:party_site_use_id after sold_to = ' || l_party_site_use_id,1,'N');
512: END IF;
513: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
514: raise FND_API.G_EXC_ERROR;
515: END IF;

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

527: x_return_status => x_return_status,
528: x_msg_count => x_msg_count,
529: x_msg_data => x_msg_data );
530:
531: IF aso_debug_pub.g_debug_flag = 'Y' THEN
532: aso_debug_pub.add('chk_hdr:after populate_acct_party: ' || x_return_status,1,'N');
533: END IF;
534: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
535: raise FND_API.G_EXC_ERROR;

Line 532: aso_debug_pub.add('chk_hdr:after populate_acct_party: ' || x_return_status,1,'N');

528: x_msg_count => x_msg_count,
529: x_msg_data => x_msg_data );
530:
531: IF aso_debug_pub.g_debug_flag = 'Y' THEN
532: aso_debug_pub.add('chk_hdr:after populate_acct_party: ' || x_return_status,1,'N');
533: END IF;
534: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
535: raise FND_API.G_EXC_ERROR;
536: END IF;

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

540: (p_qte_rec.invoice_to_cust_account_id IS NULL OR
541: p_qte_rec.invoice_to_cust_account_id = FND_API.G_MISS_NUM) THEN
542:
543:
544: IF aso_debug_pub.g_debug_flag = 'Y' THEN
545: aso_debug_pub.add('Check_Tca: before customer account:p_qte_rec.invoice_to_cust_party_id '
546: ||p_qte_rec.invoice_to_cust_party_id, 1, 'N');
547: END IF;
548: Customer_Account(

Line 545: aso_debug_pub.add('Check_Tca: before customer account:p_qte_rec.invoice_to_cust_party_id '

541: p_qte_rec.invoice_to_cust_account_id = FND_API.G_MISS_NUM) THEN
542:
543:
544: IF aso_debug_pub.g_debug_flag = 'Y' THEN
545: aso_debug_pub.add('Check_Tca: before customer account:p_qte_rec.invoice_to_cust_party_id '
546: ||p_qte_rec.invoice_to_cust_party_id, 1, 'N');
547: END IF;
548: Customer_Account(
549: p_api_version => 1.0,

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

553: x_return_status => x_return_status,
554: x_msg_count => x_msg_count,
555: x_msg_data => x_msg_data);
556:
557: IF aso_debug_pub.g_debug_flag = 'Y' THEN
558: aso_debug_pub.add('Check_Tca: after customer account:x_Return_Status '
559: ||x_Return_Status, 1, 'N');
560: END IF;
561: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 558: aso_debug_pub.add('Check_Tca: after customer account:x_Return_Status '

554: x_msg_count => x_msg_count,
555: x_msg_data => x_msg_data);
556:
557: IF aso_debug_pub.g_debug_flag = 'Y' THEN
558: aso_debug_pub.add('Check_Tca: after customer account:x_Return_Status '
559: ||x_Return_Status, 1, 'N');
560: END IF;
561: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
562: raise FND_API.G_EXC_ERROR;

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

563: END IF;
564:
565: END IF; -- invoice_to_cust_account_id
566:
567: IF aso_debug_pub.g_debug_flag = 'Y' THEN
568: aso_debug_pub.add('Check_Tca: p_qte_rec.invoice_to_cust_account_id: '
569: ||p_qte_rec.invoice_to_cust_account_id, 1, 'N');
570: END IF;
571:

Line 568: aso_debug_pub.add('Check_Tca: p_qte_rec.invoice_to_cust_account_id: '

564:
565: END IF; -- invoice_to_cust_account_id
566:
567: IF aso_debug_pub.g_debug_flag = 'Y' THEN
568: aso_debug_pub.add('Check_Tca: p_qte_rec.invoice_to_cust_account_id: '
569: ||p_qte_rec.invoice_to_cust_account_id, 1, 'N');
570: END IF;
571:
572:

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

579: FETCH c_get_cust_account_id INTO l_invoice_cust_account_id;
580: CLOSE c_get_cust_account_id;
581: END IF;
582: END IF;
583: IF aso_debug_pub.g_debug_flag = 'Y' THEN
584: aso_debug_pub.add('chk_hdr:l_invoice_cust_acccount_id = ' || l_invoice_cust_account_id,1,'N' );
585: aso_debug_pub.add('chk_hdr:before invoice to party site id '|| p_qte_rec.invoice_to_party_site_id, 1, 'Y');
586: aso_debug_pub.add('chk_hdr:invoice_to_cust_account = ' || p_qte_rec.invoice_to_cust_account_id,1,'N');
587: END IF;

Line 584: aso_debug_pub.add('chk_hdr:l_invoice_cust_acccount_id = ' || l_invoice_cust_account_id,1,'N' );

580: CLOSE c_get_cust_account_id;
581: END IF;
582: END IF;
583: IF aso_debug_pub.g_debug_flag = 'Y' THEN
584: aso_debug_pub.add('chk_hdr:l_invoice_cust_acccount_id = ' || l_invoice_cust_account_id,1,'N' );
585: aso_debug_pub.add('chk_hdr:before invoice to party site id '|| p_qte_rec.invoice_to_party_site_id, 1, 'Y');
586: aso_debug_pub.add('chk_hdr:invoice_to_cust_account = ' || p_qte_rec.invoice_to_cust_account_id,1,'N');
587: END IF;
588: IF l_invoice_cust_account_id IS NOT NULL AND l_invoice_cust_account_id <> FND_API.G_MISS_NUM THEN

Line 585: aso_debug_pub.add('chk_hdr:before invoice to party site id '|| p_qte_rec.invoice_to_party_site_id, 1, 'Y');

581: END IF;
582: END IF;
583: IF aso_debug_pub.g_debug_flag = 'Y' THEN
584: aso_debug_pub.add('chk_hdr:l_invoice_cust_acccount_id = ' || l_invoice_cust_account_id,1,'N' );
585: aso_debug_pub.add('chk_hdr:before invoice to party site id '|| p_qte_rec.invoice_to_party_site_id, 1, 'Y');
586: aso_debug_pub.add('chk_hdr:invoice_to_cust_account = ' || p_qte_rec.invoice_to_cust_account_id,1,'N');
587: END IF;
588: IF l_invoice_cust_account_id IS NOT NULL AND l_invoice_cust_account_id <> FND_API.G_MISS_NUM THEN
589:

Line 586: aso_debug_pub.add('chk_hdr:invoice_to_cust_account = ' || p_qte_rec.invoice_to_cust_account_id,1,'N');

582: END IF;
583: IF aso_debug_pub.g_debug_flag = 'Y' THEN
584: aso_debug_pub.add('chk_hdr:l_invoice_cust_acccount_id = ' || l_invoice_cust_account_id,1,'N' );
585: aso_debug_pub.add('chk_hdr:before invoice to party site id '|| p_qte_rec.invoice_to_party_site_id, 1, 'Y');
586: aso_debug_pub.add('chk_hdr:invoice_to_cust_account = ' || p_qte_rec.invoice_to_cust_account_id,1,'N');
587: END IF;
588: IF l_invoice_cust_account_id IS NOT NULL AND l_invoice_cust_account_id <> FND_API.G_MISS_NUM THEN
589:
590: IF p_qte_rec.invoice_to_party_site_id is not NULL

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

600: ,x_msg_count => x_msg_count
601: ,x_msg_data => x_msg_data
602: ,x_site_use_id => l_invoice_to_org_id);
603:
604: IF aso_debug_pub.g_debug_flag = 'Y' THEN
605: aso_debug_pub.add('chk_hdr:site_use_id after deriving invoice = ' || l_invoice_to_org_id,1,'N');
606: aso_debug_pub.add('chk_hdr:cust_acct_site_id after deriving invoice = ' || l_inv_cust_acct_site_id,1,'N');
607: END IF;
608: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 605: aso_debug_pub.add('chk_hdr:site_use_id after deriving invoice = ' || l_invoice_to_org_id,1,'N');

601: ,x_msg_data => x_msg_data
602: ,x_site_use_id => l_invoice_to_org_id);
603:
604: IF aso_debug_pub.g_debug_flag = 'Y' THEN
605: aso_debug_pub.add('chk_hdr:site_use_id after deriving invoice = ' || l_invoice_to_org_id,1,'N');
606: aso_debug_pub.add('chk_hdr:cust_acct_site_id after deriving invoice = ' || l_inv_cust_acct_site_id,1,'N');
607: END IF;
608: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
609: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 606: aso_debug_pub.add('chk_hdr:cust_acct_site_id after deriving invoice = ' || l_inv_cust_acct_site_id,1,'N');

602: ,x_site_use_id => l_invoice_to_org_id);
603:
604: IF aso_debug_pub.g_debug_flag = 'Y' THEN
605: aso_debug_pub.add('chk_hdr:site_use_id after deriving invoice = ' || l_invoice_to_org_id,1,'N');
606: aso_debug_pub.add('chk_hdr:cust_acct_site_id after deriving invoice = ' || l_inv_cust_acct_site_id,1,'N');
607: END IF;
608: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
609: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
610: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');

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

613: raise FND_API.G_EXC_ERROR;
614: END IF;
615:
616: END IF;
617: IF aso_debug_pub.g_debug_flag = 'Y' THEN
618: aso_debug_pub.add('chk_hdr: invoice_to_party = ' || p_qte_rec.invoice_to_party_id,1, 'N' );
619: aso_debug_pub.add('chk_hdr: invoice_to_party_site = ' || p_qte_rec.invoice_to_party_site_id,1, 'N' );
620: aso_debug_pub.add('chk_hdr: before Cust_Acct_Contact_Addr:l_invoice_cust_account_id: '||l_invoice_cust_account_id,1,'N');
621: END IF;

Line 618: aso_debug_pub.add('chk_hdr: invoice_to_party = ' || p_qte_rec.invoice_to_party_id,1, 'N' );

614: END IF;
615:
616: END IF;
617: IF aso_debug_pub.g_debug_flag = 'Y' THEN
618: aso_debug_pub.add('chk_hdr: invoice_to_party = ' || p_qte_rec.invoice_to_party_id,1, 'N' );
619: aso_debug_pub.add('chk_hdr: invoice_to_party_site = ' || p_qte_rec.invoice_to_party_site_id,1, 'N' );
620: aso_debug_pub.add('chk_hdr: before Cust_Acct_Contact_Addr:l_invoice_cust_account_id: '||l_invoice_cust_account_id,1,'N');
621: END IF;
622:

Line 619: aso_debug_pub.add('chk_hdr: invoice_to_party_site = ' || p_qte_rec.invoice_to_party_site_id,1, 'N' );

615:
616: END IF;
617: IF aso_debug_pub.g_debug_flag = 'Y' THEN
618: aso_debug_pub.add('chk_hdr: invoice_to_party = ' || p_qte_rec.invoice_to_party_id,1, 'N' );
619: aso_debug_pub.add('chk_hdr: invoice_to_party_site = ' || p_qte_rec.invoice_to_party_site_id,1, 'N' );
620: aso_debug_pub.add('chk_hdr: before Cust_Acct_Contact_Addr:l_invoice_cust_account_id: '||l_invoice_cust_account_id,1,'N');
621: END IF;
622:
623: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

Line 620: aso_debug_pub.add('chk_hdr: before Cust_Acct_Contact_Addr:l_invoice_cust_account_id: '||l_invoice_cust_account_id,1,'N');

616: END IF;
617: IF aso_debug_pub.g_debug_flag = 'Y' THEN
618: aso_debug_pub.add('chk_hdr: invoice_to_party = ' || p_qte_rec.invoice_to_party_id,1, 'N' );
619: aso_debug_pub.add('chk_hdr: invoice_to_party_site = ' || p_qte_rec.invoice_to_party_site_id,1, 'N' );
620: aso_debug_pub.add('chk_hdr: before Cust_Acct_Contact_Addr:l_invoice_cust_account_id: '||l_invoice_cust_account_id,1,'N');
621: END IF;
622:
623: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
624: p_api_version => 1.0,

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

631: x_msg_count => x_msg_count,
632: x_msg_data => x_msg_data,
633: x_cust_account_role_id => l_invoice_to_contact_id);
634:
635: IF aso_debug_pub.g_debug_flag = 'Y' THEN
636: aso_debug_pub.add('mapq line: after Cust_Acct_Contact_Addr:l_invoice_to_contact_id: '||l_invoice_to_contact_id,1,'N');
637: END IF;
638:
639: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 636: aso_debug_pub.add('mapq line: after Cust_Acct_Contact_Addr:l_invoice_to_contact_id: '||l_invoice_to_contact_id,1,'N');

632: x_msg_data => x_msg_data,
633: x_cust_account_role_id => l_invoice_to_contact_id);
634:
635: IF aso_debug_pub.g_debug_flag = 'Y' THEN
636: aso_debug_pub.add('mapq line: after Cust_Acct_Contact_Addr:l_invoice_to_contact_id: '||l_invoice_to_contact_id,1,'N');
637: END IF;
638:
639: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
640: raise FND_API.G_EXC_ERROR;

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

641: END IF;
642:
643: END IF; -- l_invoice_cust_account_id not null
644:
645: IF aso_debug_pub.g_debug_flag = 'Y' THEN
646: aso_debug_pub.add('chk_hdr:beginning of mapping for header end user ', 1, 'N' );
647: END IF;
648:
649: ASO_CHECK_TCA_PVT.Populate_Acct_Party (

Line 646: aso_debug_pub.add('chk_hdr:beginning of mapping for header end user ', 1, 'N' );

642:
643: END IF; -- l_invoice_cust_account_id not null
644:
645: IF aso_debug_pub.g_debug_flag = 'Y' THEN
646: aso_debug_pub.add('chk_hdr:beginning of mapping for header end user ', 1, 'N' );
647: END IF;
648:
649: ASO_CHECK_TCA_PVT.Populate_Acct_Party (
650: p_hdr_cust_acct_id => p_qte_rec.cust_account_id,

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

655: x_return_status => x_return_status,
656: x_msg_count => x_msg_count,
657: x_msg_data => x_msg_data );
658:
659: IF aso_debug_pub.g_debug_flag = 'Y' THEN
660: aso_debug_pub.add('chk_hdr:after populate_acct_party: ' || x_return_status,1,'N');
661: END IF;
662: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
663: raise FND_API.G_EXC_ERROR;

Line 660: aso_debug_pub.add('chk_hdr:after populate_acct_party: ' || x_return_status,1,'N');

656: x_msg_count => x_msg_count,
657: x_msg_data => x_msg_data );
658:
659: IF aso_debug_pub.g_debug_flag = 'Y' THEN
660: aso_debug_pub.add('chk_hdr:after populate_acct_party: ' || x_return_status,1,'N');
661: END IF;
662: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
663: raise FND_API.G_EXC_ERROR;
664: END IF;

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

668: (p_qte_rec.End_Customer_cust_account_id IS NULL OR
669: p_qte_rec.End_Customer_cust_account_id = FND_API.G_MISS_NUM) THEN
670:
671:
672: IF aso_debug_pub.g_debug_flag = 'Y' THEN
673: aso_debug_pub.add('Check_Tca: before customer account:p_qte_rec.End_Customer_cust_party_id '
674: ||p_qte_rec.End_Customer_cust_party_id, 1, 'N');
675: END IF;
676: Customer_Account(

Line 673: aso_debug_pub.add('Check_Tca: before customer account:p_qte_rec.End_Customer_cust_party_id '

669: p_qte_rec.End_Customer_cust_account_id = FND_API.G_MISS_NUM) THEN
670:
671:
672: IF aso_debug_pub.g_debug_flag = 'Y' THEN
673: aso_debug_pub.add('Check_Tca: before customer account:p_qte_rec.End_Customer_cust_party_id '
674: ||p_qte_rec.End_Customer_cust_party_id, 1, 'N');
675: END IF;
676: Customer_Account(
677: p_api_version => 1.0,

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

681: x_return_status => x_return_status,
682: x_msg_count => x_msg_count,
683: x_msg_data => x_msg_data);
684:
685: IF aso_debug_pub.g_debug_flag = 'Y' THEN
686: aso_debug_pub.add('Check_Tca: after customer account:x_Return_Status '
687: ||x_Return_Status, 1, 'N');
688: END IF;
689: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 686: aso_debug_pub.add('Check_Tca: after customer account:x_Return_Status '

682: x_msg_count => x_msg_count,
683: x_msg_data => x_msg_data);
684:
685: IF aso_debug_pub.g_debug_flag = 'Y' THEN
686: aso_debug_pub.add('Check_Tca: after customer account:x_Return_Status '
687: ||x_Return_Status, 1, 'N');
688: END IF;
689: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
690: raise FND_API.G_EXC_ERROR;

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

691: END IF;
692:
693: END IF; -- End_Customer_cust_account_id
694:
695: IF aso_debug_pub.g_debug_flag = 'Y' THEN
696: aso_debug_pub.add('Check_Tca: p_qte_rec.End_Customer_cust_account_id: '
697: ||p_qte_rec.End_Customer_cust_account_id, 1, 'N');
698: END IF;
699:

Line 696: aso_debug_pub.add('Check_Tca: p_qte_rec.End_Customer_cust_account_id: '

692:
693: END IF; -- End_Customer_cust_account_id
694:
695: IF aso_debug_pub.g_debug_flag = 'Y' THEN
696: aso_debug_pub.add('Check_Tca: p_qte_rec.End_Customer_cust_account_id: '
697: ||p_qte_rec.End_Customer_cust_account_id, 1, 'N');
698: END IF;
699:
700:

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

707: FETCH c_get_cust_account_id INTO l_End_cust_account_id;
708: CLOSE c_get_cust_account_id;
709: END IF;
710: END IF;
711: IF aso_debug_pub.g_debug_flag = 'Y' THEN
712: aso_debug_pub.add('chk_hdr:l_End_Customer_cust_acccount_id = ' || l_End_cust_account_id,1,'N' );
713: aso_debug_pub.add('chk_hdr:before End_Customer party site id '|| p_qte_rec.End_Customer_party_site_id, 1, 'Y');
714: aso_debug_pub.add('chk_hdr:End_Customer_cust_account = ' || p_qte_rec.End_Customer_cust_account_id,1,'N');
715: END IF;

Line 712: aso_debug_pub.add('chk_hdr:l_End_Customer_cust_acccount_id = ' || l_End_cust_account_id,1,'N' );

708: CLOSE c_get_cust_account_id;
709: END IF;
710: END IF;
711: IF aso_debug_pub.g_debug_flag = 'Y' THEN
712: aso_debug_pub.add('chk_hdr:l_End_Customer_cust_acccount_id = ' || l_End_cust_account_id,1,'N' );
713: aso_debug_pub.add('chk_hdr:before End_Customer party site id '|| p_qte_rec.End_Customer_party_site_id, 1, 'Y');
714: aso_debug_pub.add('chk_hdr:End_Customer_cust_account = ' || p_qte_rec.End_Customer_cust_account_id,1,'N');
715: END IF;
716: IF l_End_cust_account_id IS NOT NULL AND l_End_cust_account_id <> FND_API.G_MISS_NUM THEN

Line 713: aso_debug_pub.add('chk_hdr:before End_Customer party site id '|| p_qte_rec.End_Customer_party_site_id, 1, 'Y');

709: END IF;
710: END IF;
711: IF aso_debug_pub.g_debug_flag = 'Y' THEN
712: aso_debug_pub.add('chk_hdr:l_End_Customer_cust_acccount_id = ' || l_End_cust_account_id,1,'N' );
713: aso_debug_pub.add('chk_hdr:before End_Customer party site id '|| p_qte_rec.End_Customer_party_site_id, 1, 'Y');
714: aso_debug_pub.add('chk_hdr:End_Customer_cust_account = ' || p_qte_rec.End_Customer_cust_account_id,1,'N');
715: END IF;
716: IF l_End_cust_account_id IS NOT NULL AND l_End_cust_account_id <> FND_API.G_MISS_NUM THEN
717:

Line 714: aso_debug_pub.add('chk_hdr:End_Customer_cust_account = ' || p_qte_rec.End_Customer_cust_account_id,1,'N');

710: END IF;
711: IF aso_debug_pub.g_debug_flag = 'Y' THEN
712: aso_debug_pub.add('chk_hdr:l_End_Customer_cust_acccount_id = ' || l_End_cust_account_id,1,'N' );
713: aso_debug_pub.add('chk_hdr:before End_Customer party site id '|| p_qte_rec.End_Customer_party_site_id, 1, 'Y');
714: aso_debug_pub.add('chk_hdr:End_Customer_cust_account = ' || p_qte_rec.End_Customer_cust_account_id,1,'N');
715: END IF;
716: IF l_End_cust_account_id IS NOT NULL AND l_End_cust_account_id <> FND_API.G_MISS_NUM THEN
717:
718: IF p_qte_rec.End_Customer_party_site_id is not NULL

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

728: ,x_msg_count => x_msg_count
729: ,x_msg_data => x_msg_data
730: ,x_site_use_id => l_End_Customer_org_id);
731:
732: IF aso_debug_pub.g_debug_flag = 'Y' THEN
733: aso_debug_pub.add('chk_hdr:site_use_id after deriving End_Customer = ' || l_End_Customer_org_id,1,'N');
734: aso_debug_pub.add('chk_hdr:cust_acct_site_id after deriving End_Customer = ' || l_end_cust_acct_site_id,1,'N');
735: END IF;
736: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 733: aso_debug_pub.add('chk_hdr:site_use_id after deriving End_Customer = ' || l_End_Customer_org_id,1,'N');

729: ,x_msg_data => x_msg_data
730: ,x_site_use_id => l_End_Customer_org_id);
731:
732: IF aso_debug_pub.g_debug_flag = 'Y' THEN
733: aso_debug_pub.add('chk_hdr:site_use_id after deriving End_Customer = ' || l_End_Customer_org_id,1,'N');
734: aso_debug_pub.add('chk_hdr:cust_acct_site_id after deriving End_Customer = ' || l_end_cust_acct_site_id,1,'N');
735: END IF;
736: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
737: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 734: aso_debug_pub.add('chk_hdr:cust_acct_site_id after deriving End_Customer = ' || l_end_cust_acct_site_id,1,'N');

730: ,x_site_use_id => l_End_Customer_org_id);
731:
732: IF aso_debug_pub.g_debug_flag = 'Y' THEN
733: aso_debug_pub.add('chk_hdr:site_use_id after deriving End_Customer = ' || l_End_Customer_org_id,1,'N');
734: aso_debug_pub.add('chk_hdr:cust_acct_site_id after deriving End_Customer = ' || l_end_cust_acct_site_id,1,'N');
735: END IF;
736: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
737: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
738: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_END_SITE_AC_CRS');

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

741: raise FND_API.G_EXC_ERROR;
742: END IF;
743:
744: END IF;
745: IF aso_debug_pub.g_debug_flag = 'Y' THEN
746: aso_debug_pub.add('chk_hdr: End_Customer_to_party = ' || p_qte_rec.End_Customer_party_id,1, 'N' );
747: aso_debug_pub.add('chk_hdr: End_Customer_party_site = ' || p_qte_rec.End_Customer_party_site_id,1, 'N' );
748: aso_debug_pub.add('chk_hdr: before Cust_Acct_Contact_Addr:l_End_cust_account_id: '||l_End_cust_account_id,1,'N');
749: END IF;

Line 746: aso_debug_pub.add('chk_hdr: End_Customer_to_party = ' || p_qte_rec.End_Customer_party_id,1, 'N' );

742: END IF;
743:
744: END IF;
745: IF aso_debug_pub.g_debug_flag = 'Y' THEN
746: aso_debug_pub.add('chk_hdr: End_Customer_to_party = ' || p_qte_rec.End_Customer_party_id,1, 'N' );
747: aso_debug_pub.add('chk_hdr: End_Customer_party_site = ' || p_qte_rec.End_Customer_party_site_id,1, 'N' );
748: aso_debug_pub.add('chk_hdr: before Cust_Acct_Contact_Addr:l_End_cust_account_id: '||l_End_cust_account_id,1,'N');
749: END IF;
750:

Line 747: aso_debug_pub.add('chk_hdr: End_Customer_party_site = ' || p_qte_rec.End_Customer_party_site_id,1, 'N' );

743:
744: END IF;
745: IF aso_debug_pub.g_debug_flag = 'Y' THEN
746: aso_debug_pub.add('chk_hdr: End_Customer_to_party = ' || p_qte_rec.End_Customer_party_id,1, 'N' );
747: aso_debug_pub.add('chk_hdr: End_Customer_party_site = ' || p_qte_rec.End_Customer_party_site_id,1, 'N' );
748: aso_debug_pub.add('chk_hdr: before Cust_Acct_Contact_Addr:l_End_cust_account_id: '||l_End_cust_account_id,1,'N');
749: END IF;
750:
751: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

Line 748: aso_debug_pub.add('chk_hdr: before Cust_Acct_Contact_Addr:l_End_cust_account_id: '||l_End_cust_account_id,1,'N');

744: END IF;
745: IF aso_debug_pub.g_debug_flag = 'Y' THEN
746: aso_debug_pub.add('chk_hdr: End_Customer_to_party = ' || p_qte_rec.End_Customer_party_id,1, 'N' );
747: aso_debug_pub.add('chk_hdr: End_Customer_party_site = ' || p_qte_rec.End_Customer_party_site_id,1, 'N' );
748: aso_debug_pub.add('chk_hdr: before Cust_Acct_Contact_Addr:l_End_cust_account_id: '||l_End_cust_account_id,1,'N');
749: END IF;
750:
751: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
752: p_api_version => 1.0,

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

759: x_msg_count => x_msg_count,
760: x_msg_data => x_msg_data,
761: x_cust_account_role_id => l_End_Customer_contact_id);
762:
763: IF aso_debug_pub.g_debug_flag = 'Y' THEN
764: aso_debug_pub.add('mapq line: after Cust_Acct_Contact_Addr:l_End_Customer_contact_id: '||l_End_Customer_contact_id,1,'N');
765: END IF;
766:
767: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 764: aso_debug_pub.add('mapq line: after Cust_Acct_Contact_Addr:l_End_Customer_contact_id: '||l_End_Customer_contact_id,1,'N');

760: x_msg_data => x_msg_data,
761: x_cust_account_role_id => l_End_Customer_contact_id);
762:
763: IF aso_debug_pub.g_debug_flag = 'Y' THEN
764: aso_debug_pub.add('mapq line: after Cust_Acct_Contact_Addr:l_End_Customer_contact_id: '||l_End_Customer_contact_id,1,'N');
765: END IF;
766:
767: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
768: raise FND_API.G_EXC_ERROR;

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

769: END IF;
770:
771: END IF; -- l_End_cust_account_id not null
772:
773: IF aso_debug_pub.g_debug_flag = 'Y' THEN
774: aso_debug_pub.add('chk_hdr:beginning of mapping for header shipping ', 1, 'N' );
775: END IF;
776:
777: IF p_header_shipment_tbl.count > 0 THEN

Line 774: aso_debug_pub.add('chk_hdr:beginning of mapping for header shipping ', 1, 'N' );

770:
771: END IF; -- l_End_cust_account_id not null
772:
773: IF aso_debug_pub.g_debug_flag = 'Y' THEN
774: aso_debug_pub.add('chk_hdr:beginning of mapping for header shipping ', 1, 'N' );
775: END IF;
776:
777: IF p_header_shipment_tbl.count > 0 THEN
778: -- OM takes in only one shipment at the header level

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

776:
777: IF p_header_shipment_tbl.count > 0 THEN
778: -- OM takes in only one shipment at the header level
779:
780: IF aso_debug_pub.g_debug_flag = 'Y' THEN
781: aso_debug_pub.add('Check_Hdr_Acct: p_header_shipment_tbl(1).ship_to_cust_account_id: '
782: || p_header_shipment_tbl(1).ship_to_cust_account_id, 1, 'N');
783: aso_debug_pub.add('Check_Hdr_Acct: p_header_shipment_tbl(1).ship_to_cust_party_id: '
784: || p_header_shipment_tbl(1).ship_to_cust_party_id, 1, 'N');

Line 781: aso_debug_pub.add('Check_Hdr_Acct: p_header_shipment_tbl(1).ship_to_cust_account_id: '

777: IF p_header_shipment_tbl.count > 0 THEN
778: -- OM takes in only one shipment at the header level
779:
780: IF aso_debug_pub.g_debug_flag = 'Y' THEN
781: aso_debug_pub.add('Check_Hdr_Acct: p_header_shipment_tbl(1).ship_to_cust_account_id: '
782: || p_header_shipment_tbl(1).ship_to_cust_account_id, 1, 'N');
783: aso_debug_pub.add('Check_Hdr_Acct: p_header_shipment_tbl(1).ship_to_cust_party_id: '
784: || p_header_shipment_tbl(1).ship_to_cust_party_id, 1, 'N');
785: aso_debug_pub.add('Check_Hdr_Acct: p_header_shipment_tbl(1).ship_to_party_site_id: '

Line 783: aso_debug_pub.add('Check_Hdr_Acct: p_header_shipment_tbl(1).ship_to_cust_party_id: '

779:
780: IF aso_debug_pub.g_debug_flag = 'Y' THEN
781: aso_debug_pub.add('Check_Hdr_Acct: p_header_shipment_tbl(1).ship_to_cust_account_id: '
782: || p_header_shipment_tbl(1).ship_to_cust_account_id, 1, 'N');
783: aso_debug_pub.add('Check_Hdr_Acct: p_header_shipment_tbl(1).ship_to_cust_party_id: '
784: || p_header_shipment_tbl(1).ship_to_cust_party_id, 1, 'N');
785: aso_debug_pub.add('Check_Hdr_Acct: p_header_shipment_tbl(1).ship_to_party_site_id: '
786: || p_header_shipment_tbl(1).ship_to_party_site_id, 1, 'N');
787: END IF;

Line 785: aso_debug_pub.add('Check_Hdr_Acct: p_header_shipment_tbl(1).ship_to_party_site_id: '

781: aso_debug_pub.add('Check_Hdr_Acct: p_header_shipment_tbl(1).ship_to_cust_account_id: '
782: || p_header_shipment_tbl(1).ship_to_cust_account_id, 1, 'N');
783: aso_debug_pub.add('Check_Hdr_Acct: p_header_shipment_tbl(1).ship_to_cust_party_id: '
784: || p_header_shipment_tbl(1).ship_to_cust_party_id, 1, 'N');
785: aso_debug_pub.add('Check_Hdr_Acct: p_header_shipment_tbl(1).ship_to_party_site_id: '
786: || p_header_shipment_tbl(1).ship_to_party_site_id, 1, 'N');
787: END IF;
788:
789: ASO_CHECK_TCA_PVT.Populate_Acct_Party (

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

795: x_return_status => x_return_status,
796: x_msg_count => x_msg_count,
797: x_msg_data => x_msg_data );
798:
799: IF aso_debug_pub.g_debug_flag = 'Y' THEN
800: aso_debug_pub.add('chk_hdr:(ship)after populate_acct_party: ' || x_return_status,1,'N');
801: END IF;
802: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
803: raise FND_API.G_EXC_ERROR;

Line 800: aso_debug_pub.add('chk_hdr:(ship)after populate_acct_party: ' || x_return_status,1,'N');

796: x_msg_count => x_msg_count,
797: x_msg_data => x_msg_data );
798:
799: IF aso_debug_pub.g_debug_flag = 'Y' THEN
800: aso_debug_pub.add('chk_hdr:(ship)after populate_acct_party: ' || x_return_status,1,'N');
801: END IF;
802: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
803: raise FND_API.G_EXC_ERROR;
804: END IF;

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

808: (p_header_shipment_tbl(1).ship_to_cust_account_id IS NULL OR
809: p_header_shipment_tbl(1).ship_to_cust_account_id = FND_API.G_MISS_NUM) THEN
810:
811:
812: IF aso_debug_pub.g_debug_flag = 'Y' THEN
813: aso_debug_pub.add('Check_Tca: before customer account:p_header_shipment_tbl(1).
814: ship_to_cust_party_id '||p_header_shipment_tbl(1).ship_to_cust_party_id
815: , 1, 'N');
816: END IF;

Line 813: aso_debug_pub.add('Check_Tca: before customer account:p_header_shipment_tbl(1).

809: p_header_shipment_tbl(1).ship_to_cust_account_id = FND_API.G_MISS_NUM) THEN
810:
811:
812: IF aso_debug_pub.g_debug_flag = 'Y' THEN
813: aso_debug_pub.add('Check_Tca: before customer account:p_header_shipment_tbl(1).
814: ship_to_cust_party_id '||p_header_shipment_tbl(1).ship_to_cust_party_id
815: , 1, 'N');
816: END IF;
817: Customer_Account(

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

822: x_return_status => x_return_status,
823: x_msg_count => x_msg_count,
824: x_msg_data => x_msg_data);
825:
826: IF aso_debug_pub.g_debug_flag = 'Y' THEN
827: aso_debug_pub.add('Check_Tca: after customer account:x_Return_Status '
828: ||x_Return_Status, 1, 'N');
829: END IF;
830: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 827: aso_debug_pub.add('Check_Tca: after customer account:x_Return_Status '

823: x_msg_count => x_msg_count,
824: x_msg_data => x_msg_data);
825:
826: IF aso_debug_pub.g_debug_flag = 'Y' THEN
827: aso_debug_pub.add('Check_Tca: after customer account:x_Return_Status '
828: ||x_Return_Status, 1, 'N');
829: END IF;
830: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
831: raise FND_API.G_EXC_ERROR;

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

832: END IF;
833:
834: END IF; -- cust_account_id
835:
836: IF aso_debug_pub.g_debug_flag = 'Y' THEN
837: aso_debug_pub.add('Check_Tca: p_header_shipment_tbl(1).ship_to_cust_account_id: '||
838: p_header_shipment_tbl(1).ship_to_cust_account_id, 1, 'N');
839: END IF;
840:

Line 837: aso_debug_pub.add('Check_Tca: p_header_shipment_tbl(1).ship_to_cust_account_id: '||

833:
834: END IF; -- cust_account_id
835:
836: IF aso_debug_pub.g_debug_flag = 'Y' THEN
837: aso_debug_pub.add('Check_Tca: p_header_shipment_tbl(1).ship_to_cust_account_id: '||
838: p_header_shipment_tbl(1).ship_to_cust_account_id, 1, 'N');
839: END IF;
840:
841:

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

849: CLOSE c_get_cust_account_id;
850: END IF;
851: END IF;
852:
853: IF aso_debug_pub.g_debug_flag = 'Y' THEN
854: aso_debug_pub.add('chk_hdr:ship cust acccount = ' || l_ship_cust_account_id ,1, 'N');
855: aso_debug_pub.add('chk_hdr:ship to party site = ' || p_header_shipment_tbl(1).ship_to_party_site_id, 1, 'N');
856: END IF;
857: IF l_ship_cust_account_id IS NOT NULL AND l_ship_cust_account_id <> FND_API.G_MISS_NUM THEN

Line 854: aso_debug_pub.add('chk_hdr:ship cust acccount = ' || l_ship_cust_account_id ,1, 'N');

850: END IF;
851: END IF;
852:
853: IF aso_debug_pub.g_debug_flag = 'Y' THEN
854: aso_debug_pub.add('chk_hdr:ship cust acccount = ' || l_ship_cust_account_id ,1, 'N');
855: aso_debug_pub.add('chk_hdr:ship to party site = ' || p_header_shipment_tbl(1).ship_to_party_site_id, 1, 'N');
856: END IF;
857: IF l_ship_cust_account_id IS NOT NULL AND l_ship_cust_account_id <> FND_API.G_MISS_NUM THEN
858:

Line 855: aso_debug_pub.add('chk_hdr:ship to party site = ' || p_header_shipment_tbl(1).ship_to_party_site_id, 1, 'N');

851: END IF;
852:
853: IF aso_debug_pub.g_debug_flag = 'Y' THEN
854: aso_debug_pub.add('chk_hdr:ship cust acccount = ' || l_ship_cust_account_id ,1, 'N');
855: aso_debug_pub.add('chk_hdr:ship to party site = ' || p_header_shipment_tbl(1).ship_to_party_site_id, 1, 'N');
856: END IF;
857: IF l_ship_cust_account_id IS NOT NULL AND l_ship_cust_account_id <> FND_API.G_MISS_NUM THEN
858:
859: IF p_header_shipment_tbl(1).ship_to_party_site_id is not NULL

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

869: ,x_msg_count => x_msg_count
870: ,x_msg_data => x_msg_data
871: ,x_site_use_id => l_ship_to_org_id);
872:
873: IF aso_debug_pub.g_debug_flag = 'Y' THEN
874: aso_debug_pub.add('chk_hdr:ship to org after deriving = ' || l_ship_to_org_id, 1, 'Y');
875: aso_debug_pub.add('chk_hdr:ship cust acct site after deriving = ' || l_shp_cust_acct_site_id, 1, 'Y');
876: END IF;
877: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 874: aso_debug_pub.add('chk_hdr:ship to org after deriving = ' || l_ship_to_org_id, 1, 'Y');

870: ,x_msg_data => x_msg_data
871: ,x_site_use_id => l_ship_to_org_id);
872:
873: IF aso_debug_pub.g_debug_flag = 'Y' THEN
874: aso_debug_pub.add('chk_hdr:ship to org after deriving = ' || l_ship_to_org_id, 1, 'Y');
875: aso_debug_pub.add('chk_hdr:ship cust acct site after deriving = ' || l_shp_cust_acct_site_id, 1, 'Y');
876: END IF;
877: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
878: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 875: aso_debug_pub.add('chk_hdr:ship cust acct site after deriving = ' || l_shp_cust_acct_site_id, 1, 'Y');

871: ,x_site_use_id => l_ship_to_org_id);
872:
873: IF aso_debug_pub.g_debug_flag = 'Y' THEN
874: aso_debug_pub.add('chk_hdr:ship to org after deriving = ' || l_ship_to_org_id, 1, 'Y');
875: aso_debug_pub.add('chk_hdr:ship cust acct site after deriving = ' || l_shp_cust_acct_site_id, 1, 'Y');
876: END IF;
877: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
878: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
879: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_SHP_SITE_AC_CRS');

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

884: END IF;
885:
886: END IF;
887:
888: IF aso_debug_pub.g_debug_flag = 'Y' THEN
889: aso_debug_pub.add('chk_hdr:beginning of map 2:ship_party_id:' || p_header_shipment_tbl(1).ship_to_party_id,1,'N');
890: aso_debug_pub.add('chk_hdr: before Cust_Acct_Contact_Addr:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');
891: END IF;
892:

Line 889: aso_debug_pub.add('chk_hdr:beginning of map 2:ship_party_id:' || p_header_shipment_tbl(1).ship_to_party_id,1,'N');

885:
886: END IF;
887:
888: IF aso_debug_pub.g_debug_flag = 'Y' THEN
889: aso_debug_pub.add('chk_hdr:beginning of map 2:ship_party_id:' || p_header_shipment_tbl(1).ship_to_party_id,1,'N');
890: aso_debug_pub.add('chk_hdr: before Cust_Acct_Contact_Addr:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');
891: END IF;
892:
893: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

Line 890: aso_debug_pub.add('chk_hdr: before Cust_Acct_Contact_Addr:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');

886: END IF;
887:
888: IF aso_debug_pub.g_debug_flag = 'Y' THEN
889: aso_debug_pub.add('chk_hdr:beginning of map 2:ship_party_id:' || p_header_shipment_tbl(1).ship_to_party_id,1,'N');
890: aso_debug_pub.add('chk_hdr: before Cust_Acct_Contact_Addr:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');
891: END IF;
892:
893: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
894: p_api_version => 1.0,

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

901: x_msg_count => x_msg_count,
902: x_msg_data => x_msg_data,
903: x_cust_account_role_id => l_ship_to_contact_id);
904:
905: IF aso_debug_pub.g_debug_flag = 'Y' THEN
906: aso_debug_pub.add('chk_hdr: after Cust_Acct_Contact_Addr:l_ship_to_contact_id: '||l_ship_to_contact_id,1,'N');
907: aso_debug_pub.add('chk_hdr: after Cust_Acct_Contact_Addr:l_shp_cust_acct_site_id: '||l_shp_cust_acct_site_id,1,'N');
908: END IF;
909: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 906: aso_debug_pub.add('chk_hdr: after Cust_Acct_Contact_Addr:l_ship_to_contact_id: '||l_ship_to_contact_id,1,'N');

902: x_msg_data => x_msg_data,
903: x_cust_account_role_id => l_ship_to_contact_id);
904:
905: IF aso_debug_pub.g_debug_flag = 'Y' THEN
906: aso_debug_pub.add('chk_hdr: after Cust_Acct_Contact_Addr:l_ship_to_contact_id: '||l_ship_to_contact_id,1,'N');
907: aso_debug_pub.add('chk_hdr: after Cust_Acct_Contact_Addr:l_shp_cust_acct_site_id: '||l_shp_cust_acct_site_id,1,'N');
908: END IF;
909: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
910: raise FND_API.G_EXC_ERROR;

Line 907: aso_debug_pub.add('chk_hdr: after Cust_Acct_Contact_Addr:l_shp_cust_acct_site_id: '||l_shp_cust_acct_site_id,1,'N');

903: x_cust_account_role_id => l_ship_to_contact_id);
904:
905: IF aso_debug_pub.g_debug_flag = 'Y' THEN
906: aso_debug_pub.add('chk_hdr: after Cust_Acct_Contact_Addr:l_ship_to_contact_id: '||l_ship_to_contact_id,1,'N');
907: aso_debug_pub.add('chk_hdr: after Cust_Acct_Contact_Addr:l_shp_cust_acct_site_id: '||l_shp_cust_acct_site_id,1,'N');
908: END IF;
909: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
910: raise FND_API.G_EXC_ERROR;
911: END IF;

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

913: END IF; -- l_ship_cust_account_id is not null
914:
915: END IF; -- shipment tbl count
916:
917: IF aso_debug_pub.g_debug_flag = 'Y' THEN
918: aso_debug_pub.add('end chk_hdr:after map 2 for header',1,'N');
919: END IF;
920:
921: FND_MSG_PUB.Count_And_Get

Line 918: aso_debug_pub.add('end chk_hdr:after map 2 for header',1,'N');

914:
915: END IF; -- shipment tbl count
916:
917: IF aso_debug_pub.g_debug_flag = 'Y' THEN
918: aso_debug_pub.add('end chk_hdr:after map 2 for header',1,'N');
919: END IF;
920:
921: FND_MSG_PUB.Count_And_Get
922: ( p_count => x_msg_count,

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

1048: END IF;
1049:
1050: x_return_status := FND_API.g_ret_sts_success;
1051:
1052: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1053: aso_debug_pub.add('line account info:begin ',1,'Y');
1054: aso_debug_pub.add('line account info:P_line_Shipment_Tbl.count: '||P_line_Shipment_Tbl.count,1,'N');
1055: END IF;
1056:

Line 1053: aso_debug_pub.add('line account info:begin ',1,'Y');

1049:
1050: x_return_status := FND_API.g_ret_sts_success;
1051:
1052: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1053: aso_debug_pub.add('line account info:begin ',1,'Y');
1054: aso_debug_pub.add('line account info:P_line_Shipment_Tbl.count: '||P_line_Shipment_Tbl.count,1,'N');
1055: END IF;
1056:
1057: FOR j in 1..P_line_Shipment_Tbl.count LOOP

Line 1054: aso_debug_pub.add('line account info:P_line_Shipment_Tbl.count: '||P_line_Shipment_Tbl.count,1,'N');

1050: x_return_status := FND_API.g_ret_sts_success;
1051:
1052: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1053: aso_debug_pub.add('line account info:begin ',1,'Y');
1054: aso_debug_pub.add('line account info:P_line_Shipment_Tbl.count: '||P_line_Shipment_Tbl.count,1,'N');
1055: END IF;
1056:
1057: FOR j in 1..P_line_Shipment_Tbl.count LOOP
1058:

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

1055: END IF;
1056:
1057: FOR j in 1..P_line_Shipment_Tbl.count LOOP
1058:
1059: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1060: aso_debug_pub.add('line account info:p_qte_line_rec.invoice_to_cust_account_id: '||p_qte_line_rec.invoice_to_cust_account_id,1,'N');
1061: aso_debug_pub.add('line account info:p_qte_line_rec.invoice_to_cust_party_id: '||p_qte_line_rec.invoice_to_cust_party_id,1,'N');
1062: aso_debug_pub.add('line account info:p_qte_line_rec.invoice_to_party_site_id: '||p_qte_line_rec.invoice_to_party_site_id,1,'N');
1063: END IF;

Line 1060: aso_debug_pub.add('line account info:p_qte_line_rec.invoice_to_cust_account_id: '||p_qte_line_rec.invoice_to_cust_account_id,1,'N');

1056:
1057: FOR j in 1..P_line_Shipment_Tbl.count LOOP
1058:
1059: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1060: aso_debug_pub.add('line account info:p_qte_line_rec.invoice_to_cust_account_id: '||p_qte_line_rec.invoice_to_cust_account_id,1,'N');
1061: aso_debug_pub.add('line account info:p_qte_line_rec.invoice_to_cust_party_id: '||p_qte_line_rec.invoice_to_cust_party_id,1,'N');
1062: aso_debug_pub.add('line account info:p_qte_line_rec.invoice_to_party_site_id: '||p_qte_line_rec.invoice_to_party_site_id,1,'N');
1063: END IF;
1064:

Line 1061: aso_debug_pub.add('line account info:p_qte_line_rec.invoice_to_cust_party_id: '||p_qte_line_rec.invoice_to_cust_party_id,1,'N');

1057: FOR j in 1..P_line_Shipment_Tbl.count LOOP
1058:
1059: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1060: aso_debug_pub.add('line account info:p_qte_line_rec.invoice_to_cust_account_id: '||p_qte_line_rec.invoice_to_cust_account_id,1,'N');
1061: aso_debug_pub.add('line account info:p_qte_line_rec.invoice_to_cust_party_id: '||p_qte_line_rec.invoice_to_cust_party_id,1,'N');
1062: aso_debug_pub.add('line account info:p_qte_line_rec.invoice_to_party_site_id: '||p_qte_line_rec.invoice_to_party_site_id,1,'N');
1063: END IF;
1064:
1065: IF (P_Qte_Line_Rec.operation_code = 'UPDATE' AND P_Application_Type_Code = 'QUOTING HTML') THEN

Line 1062: aso_debug_pub.add('line account info:p_qte_line_rec.invoice_to_party_site_id: '||p_qte_line_rec.invoice_to_party_site_id,1,'N');

1058:
1059: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1060: aso_debug_pub.add('line account info:p_qte_line_rec.invoice_to_cust_account_id: '||p_qte_line_rec.invoice_to_cust_account_id,1,'N');
1061: aso_debug_pub.add('line account info:p_qte_line_rec.invoice_to_cust_party_id: '||p_qte_line_rec.invoice_to_cust_party_id,1,'N');
1062: aso_debug_pub.add('line account info:p_qte_line_rec.invoice_to_party_site_id: '||p_qte_line_rec.invoice_to_party_site_id,1,'N');
1063: END IF;
1064:
1065: IF (P_Qte_Line_Rec.operation_code = 'UPDATE' AND P_Application_Type_Code = 'QUOTING HTML') THEN
1066: l_qte_line_rec := ASO_UTILITY_PVT.query_qte_line_row (P_Qte_Line_Rec.quote_line_id);

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

1151: x_return_status => x_return_status,
1152: x_msg_count => x_msg_count,
1153: x_msg_data => x_msg_data );
1154:
1155: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1156: aso_debug_pub.add('chk_lin:after populate_acct_party: ' || x_return_status,1,'N');
1157: END IF;
1158: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1159: raise FND_API.G_EXC_ERROR;

Line 1156: aso_debug_pub.add('chk_lin:after populate_acct_party: ' || x_return_status,1,'N');

1152: x_msg_count => x_msg_count,
1153: x_msg_data => x_msg_data );
1154:
1155: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1156: aso_debug_pub.add('chk_lin:after populate_acct_party: ' || x_return_status,1,'N');
1157: END IF;
1158: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1159: raise FND_API.G_EXC_ERROR;
1160: END IF;

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

1165: (p_qte_line_rec.invoice_to_cust_account_id IS NULL OR
1166: p_qte_line_rec.invoice_to_cust_account_id = FND_API.G_MISS_NUM) THEN
1167:
1168:
1169: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1170: aso_debug_pub.add('Check_Tca: before customer account: p_qte_line_rec.invoice_to_cust_party_id '
1171: || p_qte_line_rec.invoice_to_cust_party_id, 1, 'N')
1172: ;
1173: END IF;

Line 1170: aso_debug_pub.add('Check_Tca: before customer account: p_qte_line_rec.invoice_to_cust_party_id '

1166: p_qte_line_rec.invoice_to_cust_account_id = FND_API.G_MISS_NUM) THEN
1167:
1168:
1169: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1170: aso_debug_pub.add('Check_Tca: before customer account: p_qte_line_rec.invoice_to_cust_party_id '
1171: || p_qte_line_rec.invoice_to_cust_party_id, 1, 'N')
1172: ;
1173: END IF;
1174: Customer_Account(

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

1179: x_return_status => x_return_status,
1180: x_msg_count => x_msg_count,
1181: x_msg_data => x_msg_data);
1182:
1183: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1184: aso_debug_pub.add('Check_Tca: after customer account:x_Return_Status '
1185: ||x_Return_Status, 1, 'N');
1186: END IF;
1187: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1184: aso_debug_pub.add('Check_Tca: after customer account:x_Return_Status '

1180: x_msg_count => x_msg_count,
1181: x_msg_data => x_msg_data);
1182:
1183: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1184: aso_debug_pub.add('Check_Tca: after customer account:x_Return_Status '
1185: ||x_Return_Status, 1, 'N');
1186: END IF;
1187: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1188: raise FND_API.G_EXC_ERROR;

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

1188: raise FND_API.G_EXC_ERROR;
1189: END IF;
1190:
1191: END IF; -- invoice_to_cust_account_id
1192: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1193: aso_debug_pub.add('Check_Tca: p_qte_line_rec.invoice_to_cust_account_id: '
1194: ||p_qte_line_rec.invoice_to_cust_account_id, 1, 'N');
1195: END IF;
1196:

Line 1193: aso_debug_pub.add('Check_Tca: p_qte_line_rec.invoice_to_cust_account_id: '

1189: END IF;
1190:
1191: END IF; -- invoice_to_cust_account_id
1192: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1193: aso_debug_pub.add('Check_Tca: p_qte_line_rec.invoice_to_cust_account_id: '
1194: ||p_qte_line_rec.invoice_to_cust_account_id, 1, 'N');
1195: END IF;
1196:
1197:

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

1205: CLOSE C_line_cust;
1206: END IF;
1207: END IF;
1208:
1209: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1210: aso_debug_pub.add('chk_ln: l_invoice_cust_account_id: '||l_invoice_cust_account_id,1,'N');
1211: aso_debug_pub.add('chk_ln: l_End_cust_account_id: '||l_End_cust_account_id,1,'N');
1212: aso_debug_pub.add('line account info: inside shipment loop:party_site: '||p_qte_line_rec.invoice_to_party_site_id,1,'N');
1213: END IF;

Line 1210: aso_debug_pub.add('chk_ln: l_invoice_cust_account_id: '||l_invoice_cust_account_id,1,'N');

1206: END IF;
1207: END IF;
1208:
1209: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1210: aso_debug_pub.add('chk_ln: l_invoice_cust_account_id: '||l_invoice_cust_account_id,1,'N');
1211: aso_debug_pub.add('chk_ln: l_End_cust_account_id: '||l_End_cust_account_id,1,'N');
1212: aso_debug_pub.add('line account info: inside shipment loop:party_site: '||p_qte_line_rec.invoice_to_party_site_id,1,'N');
1213: END IF;
1214:

Line 1211: aso_debug_pub.add('chk_ln: l_End_cust_account_id: '||l_End_cust_account_id,1,'N');

1207: END IF;
1208:
1209: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1210: aso_debug_pub.add('chk_ln: l_invoice_cust_account_id: '||l_invoice_cust_account_id,1,'N');
1211: aso_debug_pub.add('chk_ln: l_End_cust_account_id: '||l_End_cust_account_id,1,'N');
1212: aso_debug_pub.add('line account info: inside shipment loop:party_site: '||p_qte_line_rec.invoice_to_party_site_id,1,'N');
1213: END IF;
1214:
1215: IF l_invoice_cust_account_id IS NOT NULL AND l_invoice_cust_account_id <> FND_API.G_MISS_NUM THEN

Line 1212: aso_debug_pub.add('line account info: inside shipment loop:party_site: '||p_qte_line_rec.invoice_to_party_site_id,1,'N');

1208:
1209: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1210: aso_debug_pub.add('chk_ln: l_invoice_cust_account_id: '||l_invoice_cust_account_id,1,'N');
1211: aso_debug_pub.add('chk_ln: l_End_cust_account_id: '||l_End_cust_account_id,1,'N');
1212: aso_debug_pub.add('line account info: inside shipment loop:party_site: '||p_qte_line_rec.invoice_to_party_site_id,1,'N');
1213: END IF;
1214:
1215: IF l_invoice_cust_account_id IS NOT NULL AND l_invoice_cust_account_id <> FND_API.G_MISS_NUM THEN
1216:

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

1234: FND_MSG_PUB.ADD;
1235: END IF;
1236: raise FND_API.G_EXC_ERROR;
1237: END IF;
1238: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1239: aso_debug_pub.add('line account info: site use after cust account site: '||l_site_use_id,1,'N');
1240: aso_debug_pub.add('line account info: cust_acct_site after cust account site: '||l_inv_cust_acct_site_id,1,'N');
1241: END IF;
1242: END IF;

Line 1239: aso_debug_pub.add('line account info: site use after cust account site: '||l_site_use_id,1,'N');

1235: END IF;
1236: raise FND_API.G_EXC_ERROR;
1237: END IF;
1238: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1239: aso_debug_pub.add('line account info: site use after cust account site: '||l_site_use_id,1,'N');
1240: aso_debug_pub.add('line account info: cust_acct_site after cust account site: '||l_inv_cust_acct_site_id,1,'N');
1241: END IF;
1242: END IF;
1243:

Line 1240: aso_debug_pub.add('line account info: cust_acct_site after cust account site: '||l_inv_cust_acct_site_id,1,'N');

1236: raise FND_API.G_EXC_ERROR;
1237: END IF;
1238: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1239: aso_debug_pub.add('line account info: site use after cust account site: '||l_site_use_id,1,'N');
1240: aso_debug_pub.add('line account info: cust_acct_site after cust account site: '||l_inv_cust_acct_site_id,1,'N');
1241: END IF;
1242: END IF;
1243:
1244: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

1240: aso_debug_pub.add('line account info: cust_acct_site after cust account site: '||l_inv_cust_acct_site_id,1,'N');
1241: END IF;
1242: END IF;
1243:
1244: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1245: aso_debug_pub.add('chk_ln: before Cust_Acct_Contact_Addr:l_invoice_cust_account_id: '||l_invoice_cust_account_id,1,'N');
1246: END IF;
1247:
1248: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

Line 1245: aso_debug_pub.add('chk_ln: before Cust_Acct_Contact_Addr:l_invoice_cust_account_id: '||l_invoice_cust_account_id,1,'N');

1241: END IF;
1242: END IF;
1243:
1244: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1245: aso_debug_pub.add('chk_ln: before Cust_Acct_Contact_Addr:l_invoice_cust_account_id: '||l_invoice_cust_account_id,1,'N');
1246: END IF;
1247:
1248: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
1249: p_api_version => 1.0,

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

1256: x_msg_count => x_msg_count,
1257: x_msg_data => x_msg_data,
1258: x_cust_account_role_id => l_invoice_to_contact_id);
1259:
1260: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1261: aso_debug_pub.add('chk_ln: after Cust_Acct_Contact_Addr:l_invoice_to_contact_id: '||l_invoice_to_contact_id,1,'N');
1262: aso_debug_pub.add('chk_ln: after Cust_Acct_Contact_Addr:l_inv_cust_acct_site_id: '||l_inv_cust_acct_site_id,1,'N');
1263: END IF;
1264:

Line 1261: aso_debug_pub.add('chk_ln: after Cust_Acct_Contact_Addr:l_invoice_to_contact_id: '||l_invoice_to_contact_id,1,'N');

1257: x_msg_data => x_msg_data,
1258: x_cust_account_role_id => l_invoice_to_contact_id);
1259:
1260: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1261: aso_debug_pub.add('chk_ln: after Cust_Acct_Contact_Addr:l_invoice_to_contact_id: '||l_invoice_to_contact_id,1,'N');
1262: aso_debug_pub.add('chk_ln: after Cust_Acct_Contact_Addr:l_inv_cust_acct_site_id: '||l_inv_cust_acct_site_id,1,'N');
1263: END IF;
1264:
1265: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1262: aso_debug_pub.add('chk_ln: after Cust_Acct_Contact_Addr:l_inv_cust_acct_site_id: '||l_inv_cust_acct_site_id,1,'N');

1258: x_cust_account_role_id => l_invoice_to_contact_id);
1259:
1260: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1261: aso_debug_pub.add('chk_ln: after Cust_Acct_Contact_Addr:l_invoice_to_contact_id: '||l_invoice_to_contact_id,1,'N');
1262: aso_debug_pub.add('chk_ln: after Cust_Acct_Contact_Addr:l_inv_cust_acct_site_id: '||l_inv_cust_acct_site_id,1,'N');
1263: END IF;
1264:
1265: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1266: raise FND_API.G_EXC_ERROR;

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

1268:
1269: END IF; -- l_invoice_cust_account_id is not null
1270:
1271:
1272: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1273: aso_debug_pub.add('line account info:p_qte_line_rec.End_Customer_cust_account_id: '||p_qte_line_rec.End_Customer_cust_account_id,1,'N');
1274: aso_debug_pub.add('line account info:p_qte_line_rec.End_Customer_cust_party_id: '||p_qte_line_rec.End_Customer_cust_party_id,1,'N');
1275: aso_debug_pub.add('line account info:p_qte_line_rec.End_Customer_party_site_id: '||p_qte_line_rec.End_Customer_party_site_id,1,'N');
1276: END IF;

Line 1273: aso_debug_pub.add('line account info:p_qte_line_rec.End_Customer_cust_account_id: '||p_qte_line_rec.End_Customer_cust_account_id,1,'N');

1269: END IF; -- l_invoice_cust_account_id is not null
1270:
1271:
1272: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1273: aso_debug_pub.add('line account info:p_qte_line_rec.End_Customer_cust_account_id: '||p_qte_line_rec.End_Customer_cust_account_id,1,'N');
1274: aso_debug_pub.add('line account info:p_qte_line_rec.End_Customer_cust_party_id: '||p_qte_line_rec.End_Customer_cust_party_id,1,'N');
1275: aso_debug_pub.add('line account info:p_qte_line_rec.End_Customer_party_site_id: '||p_qte_line_rec.End_Customer_party_site_id,1,'N');
1276: END IF;
1277:

Line 1274: aso_debug_pub.add('line account info:p_qte_line_rec.End_Customer_cust_party_id: '||p_qte_line_rec.End_Customer_cust_party_id,1,'N');

1270:
1271:
1272: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1273: aso_debug_pub.add('line account info:p_qte_line_rec.End_Customer_cust_account_id: '||p_qte_line_rec.End_Customer_cust_account_id,1,'N');
1274: aso_debug_pub.add('line account info:p_qte_line_rec.End_Customer_cust_party_id: '||p_qte_line_rec.End_Customer_cust_party_id,1,'N');
1275: aso_debug_pub.add('line account info:p_qte_line_rec.End_Customer_party_site_id: '||p_qte_line_rec.End_Customer_party_site_id,1,'N');
1276: END IF;
1277:
1278: /*--bug 5132989

Line 1275: aso_debug_pub.add('line account info:p_qte_line_rec.End_Customer_party_site_id: '||p_qte_line_rec.End_Customer_party_site_id,1,'N');

1271:
1272: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1273: aso_debug_pub.add('line account info:p_qte_line_rec.End_Customer_cust_account_id: '||p_qte_line_rec.End_Customer_cust_account_id,1,'N');
1274: aso_debug_pub.add('line account info:p_qte_line_rec.End_Customer_cust_party_id: '||p_qte_line_rec.End_Customer_cust_party_id,1,'N');
1275: aso_debug_pub.add('line account info:p_qte_line_rec.End_Customer_party_site_id: '||p_qte_line_rec.End_Customer_party_site_id,1,'N');
1276: END IF;
1277:
1278: /*--bug 5132989
1279: l_cust_acct_id := p_qte_line_rec.End_Customer_cust_account_id;

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

1296: x_msg_count => x_msg_count,
1297: x_msg_data => x_msg_data );
1298:
1299: END IF;
1300: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1301: aso_debug_pub.add('chk_lin:after populate_acct_party: ' || x_return_status,1,'N');
1302: END IF;
1303: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1304: raise FND_API.G_EXC_ERROR;

Line 1301: aso_debug_pub.add('chk_lin:after populate_acct_party: ' || x_return_status,1,'N');

1297: x_msg_data => x_msg_data );
1298:
1299: END IF;
1300: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1301: aso_debug_pub.add('chk_lin:after populate_acct_party: ' || x_return_status,1,'N');
1302: END IF;
1303: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1304: raise FND_API.G_EXC_ERROR;
1305: END IF;

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

1310: (p_qte_line_rec.End_Customer_cust_account_id IS NULL OR
1311: p_qte_line_rec.End_Customer_cust_account_id = FND_API.G_MISS_NUM) THEN
1312:
1313:
1314: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1315: aso_debug_pub.add('Check_Tca: before customer account: p_qte_line_rec.End_Customer_cust_party_id '
1316: || p_qte_line_rec.End_Customer_cust_party_id, 1, 'N')
1317: ;
1318: END IF;

Line 1315: aso_debug_pub.add('Check_Tca: before customer account: p_qte_line_rec.End_Customer_cust_party_id '

1311: p_qte_line_rec.End_Customer_cust_account_id = FND_API.G_MISS_NUM) THEN
1312:
1313:
1314: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1315: aso_debug_pub.add('Check_Tca: before customer account: p_qte_line_rec.End_Customer_cust_party_id '
1316: || p_qte_line_rec.End_Customer_cust_party_id, 1, 'N')
1317: ;
1318: END IF;
1319: Customer_Account(

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

1324: x_return_status => x_return_status,
1325: x_msg_count => x_msg_count,
1326: x_msg_data => x_msg_data);
1327:
1328: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1329: aso_debug_pub.add('Check_Tca: after customer account:x_Return_Status '
1330: ||x_Return_Status, 1, 'N');
1331: END IF;
1332: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1329: aso_debug_pub.add('Check_Tca: after customer account:x_Return_Status '

1325: x_msg_count => x_msg_count,
1326: x_msg_data => x_msg_data);
1327:
1328: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1329: aso_debug_pub.add('Check_Tca: after customer account:x_Return_Status '
1330: ||x_Return_Status, 1, 'N');
1331: END IF;
1332: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1333: raise FND_API.G_EXC_ERROR;

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

1333: raise FND_API.G_EXC_ERROR;
1334: END IF;
1335:
1336: END IF; -- End_Customer_cust_account_id
1337: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1338: aso_debug_pub.add('Check_Tca: p_qte_line_rec.End_Customer_cust_account_id: '
1339: ||p_qte_line_rec.End_Customer_cust_account_id, 1, 'N');
1340: END IF;
1341:

Line 1338: aso_debug_pub.add('Check_Tca: p_qte_line_rec.End_Customer_cust_account_id: '

1334: END IF;
1335:
1336: END IF; -- End_Customer_cust_account_id
1337: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1338: aso_debug_pub.add('Check_Tca: p_qte_line_rec.End_Customer_cust_account_id: '
1339: ||p_qte_line_rec.End_Customer_cust_account_id, 1, 'N');
1340: END IF;
1341:
1342:

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

1350: CLOSE C_line_cust;
1351: END IF;
1352: END IF;
1353:
1354: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1355: aso_debug_pub.add('chk_ln: l_End_cust_account_id: '||l_End_cust_account_id,1,'N');
1356: aso_debug_pub.add('line account info: inside shipment loop:party_site: '||p_qte_line_rec.End_Customer_party_site_id,1,'N');
1357: END IF;
1358:

Line 1355: aso_debug_pub.add('chk_ln: l_End_cust_account_id: '||l_End_cust_account_id,1,'N');

1351: END IF;
1352: END IF;
1353:
1354: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1355: aso_debug_pub.add('chk_ln: l_End_cust_account_id: '||l_End_cust_account_id,1,'N');
1356: aso_debug_pub.add('line account info: inside shipment loop:party_site: '||p_qte_line_rec.End_Customer_party_site_id,1,'N');
1357: END IF;
1358:
1359: IF l_End_cust_account_id IS NOT NULL AND l_End_cust_account_id <> FND_API.G_MISS_NUM THEN

Line 1356: aso_debug_pub.add('line account info: inside shipment loop:party_site: '||p_qte_line_rec.End_Customer_party_site_id,1,'N');

1352: END IF;
1353:
1354: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1355: aso_debug_pub.add('chk_ln: l_End_cust_account_id: '||l_End_cust_account_id,1,'N');
1356: aso_debug_pub.add('line account info: inside shipment loop:party_site: '||p_qte_line_rec.End_Customer_party_site_id,1,'N');
1357: END IF;
1358:
1359: IF l_End_cust_account_id IS NOT NULL AND l_End_cust_account_id <> FND_API.G_MISS_NUM THEN
1360:

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

1378: FND_MSG_PUB.ADD;
1379: END IF;
1380: raise FND_API.G_EXC_ERROR;
1381: END IF;
1382: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1383: aso_debug_pub.add('line account info: site use after cust account site: '||l_site_use_id,1,'N');
1384: aso_debug_pub.add('line account info: cust_acct_site after cust account site: '||l_end_cust_acct_site_id,1,'N');
1385: END IF;
1386: END IF;

Line 1383: aso_debug_pub.add('line account info: site use after cust account site: '||l_site_use_id,1,'N');

1379: END IF;
1380: raise FND_API.G_EXC_ERROR;
1381: END IF;
1382: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1383: aso_debug_pub.add('line account info: site use after cust account site: '||l_site_use_id,1,'N');
1384: aso_debug_pub.add('line account info: cust_acct_site after cust account site: '||l_end_cust_acct_site_id,1,'N');
1385: END IF;
1386: END IF;
1387:

Line 1384: aso_debug_pub.add('line account info: cust_acct_site after cust account site: '||l_end_cust_acct_site_id,1,'N');

1380: raise FND_API.G_EXC_ERROR;
1381: END IF;
1382: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1383: aso_debug_pub.add('line account info: site use after cust account site: '||l_site_use_id,1,'N');
1384: aso_debug_pub.add('line account info: cust_acct_site after cust account site: '||l_end_cust_acct_site_id,1,'N');
1385: END IF;
1386: END IF;
1387:
1388: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

1384: aso_debug_pub.add('line account info: cust_acct_site after cust account site: '||l_end_cust_acct_site_id,1,'N');
1385: END IF;
1386: END IF;
1387:
1388: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1389: aso_debug_pub.add('chk_ln: before Cust_Acct_Contact_Addr:l_End_cust_account_id: '||l_End_cust_account_id,1,'N');
1390: END IF;
1391:
1392: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

Line 1389: aso_debug_pub.add('chk_ln: before Cust_Acct_Contact_Addr:l_End_cust_account_id: '||l_End_cust_account_id,1,'N');

1385: END IF;
1386: END IF;
1387:
1388: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1389: aso_debug_pub.add('chk_ln: before Cust_Acct_Contact_Addr:l_End_cust_account_id: '||l_End_cust_account_id,1,'N');
1390: END IF;
1391:
1392: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
1393: p_api_version => 1.0,

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

1400: x_msg_count => x_msg_count,
1401: x_msg_data => x_msg_data,
1402: x_cust_account_role_id => l_End_Customer_contact_id);
1403:
1404: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1405: aso_debug_pub.add('chk_ln: after Cust_Acct_Contact_Addr:l_End_Customer_contact_id: '||l_End_Customer_contact_id,1,'N');
1406: aso_debug_pub.add('chk_ln: after Cust_Acct_Contact_Addr:l_end_cust_acct_site_id: '||l_end_cust_acct_site_id,1,'N');
1407: END IF;
1408:

Line 1405: aso_debug_pub.add('chk_ln: after Cust_Acct_Contact_Addr:l_End_Customer_contact_id: '||l_End_Customer_contact_id,1,'N');

1401: x_msg_data => x_msg_data,
1402: x_cust_account_role_id => l_End_Customer_contact_id);
1403:
1404: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1405: aso_debug_pub.add('chk_ln: after Cust_Acct_Contact_Addr:l_End_Customer_contact_id: '||l_End_Customer_contact_id,1,'N');
1406: aso_debug_pub.add('chk_ln: after Cust_Acct_Contact_Addr:l_end_cust_acct_site_id: '||l_end_cust_acct_site_id,1,'N');
1407: END IF;
1408:
1409: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1406: aso_debug_pub.add('chk_ln: after Cust_Acct_Contact_Addr:l_end_cust_acct_site_id: '||l_end_cust_acct_site_id,1,'N');

1402: x_cust_account_role_id => l_End_Customer_contact_id);
1403:
1404: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1405: aso_debug_pub.add('chk_ln: after Cust_Acct_Contact_Addr:l_End_Customer_contact_id: '||l_End_Customer_contact_id,1,'N');
1406: aso_debug_pub.add('chk_ln: after Cust_Acct_Contact_Addr:l_end_cust_acct_site_id: '||l_end_cust_acct_site_id,1,'N');
1407: END IF;
1408:
1409: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1410: raise FND_API.G_EXC_ERROR;

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

1411: END IF;
1412:
1413: END IF; -- l_End_cust_account_id is not null
1414:
1415: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1416: aso_debug_pub.add('chk_ln: p_line_shipment_tbl(j).ship_to_cust_account_id: '
1417: ||p_line_shipment_tbl(j).ship_to_cust_account_id,1,'N');
1418: aso_debug_pub.add('chk_ln: p_line_shipment_tbl(j).ship_to_cust_party_id: '
1419: ||p_line_shipment_tbl(j).ship_to_cust_party_id,1,'N');

Line 1416: aso_debug_pub.add('chk_ln: p_line_shipment_tbl(j).ship_to_cust_account_id: '

1412:
1413: END IF; -- l_End_cust_account_id is not null
1414:
1415: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1416: aso_debug_pub.add('chk_ln: p_line_shipment_tbl(j).ship_to_cust_account_id: '
1417: ||p_line_shipment_tbl(j).ship_to_cust_account_id,1,'N');
1418: aso_debug_pub.add('chk_ln: p_line_shipment_tbl(j).ship_to_cust_party_id: '
1419: ||p_line_shipment_tbl(j).ship_to_cust_party_id,1,'N');
1420: aso_debug_pub.add('chk_ln: p_line_shipment_tbl(j).ship_to_party_site_id: '

Line 1418: aso_debug_pub.add('chk_ln: p_line_shipment_tbl(j).ship_to_cust_party_id: '

1414:
1415: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1416: aso_debug_pub.add('chk_ln: p_line_shipment_tbl(j).ship_to_cust_account_id: '
1417: ||p_line_shipment_tbl(j).ship_to_cust_account_id,1,'N');
1418: aso_debug_pub.add('chk_ln: p_line_shipment_tbl(j).ship_to_cust_party_id: '
1419: ||p_line_shipment_tbl(j).ship_to_cust_party_id,1,'N');
1420: aso_debug_pub.add('chk_ln: p_line_shipment_tbl(j).ship_to_party_site_id: '
1421: ||p_line_shipment_tbl(j).ship_to_party_site_id,1,'N');
1422: END IF;

Line 1420: aso_debug_pub.add('chk_ln: p_line_shipment_tbl(j).ship_to_party_site_id: '

1416: aso_debug_pub.add('chk_ln: p_line_shipment_tbl(j).ship_to_cust_account_id: '
1417: ||p_line_shipment_tbl(j).ship_to_cust_account_id,1,'N');
1418: aso_debug_pub.add('chk_ln: p_line_shipment_tbl(j).ship_to_cust_party_id: '
1419: ||p_line_shipment_tbl(j).ship_to_cust_party_id,1,'N');
1420: aso_debug_pub.add('chk_ln: p_line_shipment_tbl(j).ship_to_party_site_id: '
1421: ||p_line_shipment_tbl(j).ship_to_party_site_id,1,'N');
1422: END IF;
1423: -- bug 5132989
1424: /*

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

1431: x_return_status => x_return_status,
1432: x_msg_count => x_msg_count,
1433: x_msg_data => x_msg_data );
1434:
1435: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1436: aso_debug_pub.add('chk_lin:(ship)after populate_acct_party: ' || x_return_status,1,'N');
1437: END IF;
1438: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1439: raise FND_API.G_EXC_ERROR;

Line 1436: aso_debug_pub.add('chk_lin:(ship)after populate_acct_party: ' || x_return_status,1,'N');

1432: x_msg_count => x_msg_count,
1433: x_msg_data => x_msg_data );
1434:
1435: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1436: aso_debug_pub.add('chk_lin:(ship)after populate_acct_party: ' || x_return_status,1,'N');
1437: END IF;
1438: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1439: raise FND_API.G_EXC_ERROR;
1440: END IF;

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

1444: (p_line_shipment_tbl(j).ship_to_cust_account_id IS NULL OR
1445: p_line_shipment_tbl(j).ship_to_cust_account_id = FND_API.G_MISS_NUM) THEN
1446:
1447:
1448: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1449: aso_debug_pub.add('Check_Tca: before customer account:p_header_shipment_tbl(j).
1450: ship_to_cust_party_id '||p_line_shipment_tbl(j).ship_to_cust_party_id,
1451: 1, 'N');
1452: END IF;

Line 1449: aso_debug_pub.add('Check_Tca: before customer account:p_header_shipment_tbl(j).

1445: p_line_shipment_tbl(j).ship_to_cust_account_id = FND_API.G_MISS_NUM) THEN
1446:
1447:
1448: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1449: aso_debug_pub.add('Check_Tca: before customer account:p_header_shipment_tbl(j).
1450: ship_to_cust_party_id '||p_line_shipment_tbl(j).ship_to_cust_party_id,
1451: 1, 'N');
1452: END IF;
1453: Customer_Account(

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

1458: x_return_status => x_return_status,
1459: x_msg_count => x_msg_count,
1460: x_msg_data => x_msg_data);
1461:
1462: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1463: aso_debug_pub.add('Check_Tca: after customer account:x_Return_Status '
1464: ||x_Return_Status, 1, 'N');
1465: END IF;
1466: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1463: aso_debug_pub.add('Check_Tca: after customer account:x_Return_Status '

1459: x_msg_count => x_msg_count,
1460: x_msg_data => x_msg_data);
1461:
1462: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1463: aso_debug_pub.add('Check_Tca: after customer account:x_Return_Status '
1464: ||x_Return_Status, 1, 'N');
1465: END IF;
1466: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1467: raise FND_API.G_EXC_ERROR;

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

1468: END IF;
1469:
1470: END IF; -- ship cust_account_id
1471:
1472: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1473: aso_debug_pub.add('Check_Tca: p_line_shipment_tbl(j).ship_to_cust_account_id: '||
1474: p_line_shipment_tbl(j).ship_to_cust_account_id, 1, 'N');
1475: END IF;
1476:

Line 1473: aso_debug_pub.add('Check_Tca: p_line_shipment_tbl(j).ship_to_cust_account_id: '||

1469:
1470: END IF; -- ship cust_account_id
1471:
1472: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1473: aso_debug_pub.add('Check_Tca: p_line_shipment_tbl(j).ship_to_cust_account_id: '||
1474: p_line_shipment_tbl(j).ship_to_cust_account_id, 1, 'N');
1475: END IF;
1476:
1477: IF p_line_shipment_tbl(j).ship_to_cust_account_id is not NULL AND

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

1484: CLOSE C_ship_cust;
1485: END IF;
1486: END IF;
1487:
1488: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1489: aso_debug_pub.add('line acct info: before cust_acct_site:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');
1490: END IF;
1491:
1492: IF l_ship_cust_account_id IS NOT NULL AND l_ship_cust_account_id <> FND_API.G_MISS_NUM THEN

Line 1489: aso_debug_pub.add('line acct info: before cust_acct_site:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');

1485: END IF;
1486: END IF;
1487:
1488: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1489: aso_debug_pub.add('line acct info: before cust_acct_site:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');
1490: END IF;
1491:
1492: IF l_ship_cust_account_id IS NOT NULL AND l_ship_cust_account_id <> FND_API.G_MISS_NUM THEN
1493: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

1489: aso_debug_pub.add('line acct info: before cust_acct_site:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');
1490: END IF;
1491:
1492: IF l_ship_cust_account_id IS NOT NULL AND l_ship_cust_account_id <> FND_API.G_MISS_NUM THEN
1493: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1494: aso_debug_pub.add('line acct info: before cust_acct_site:p_line_shipment_tbl(j).ship_to_party_site_id: '||p_line_shipment_tbl(j).ship_to_party_site_id,1,'N');
1495: END IF;
1496: IF p_line_shipment_tbl(j).ship_to_party_site_id is not NULL AND
1497: p_line_shipment_tbl(j).ship_to_party_site_id <> FND_API.G_MISS_NUM THEN

Line 1494: aso_debug_pub.add('line acct info: before cust_acct_site:p_line_shipment_tbl(j).ship_to_party_site_id: '||p_line_shipment_tbl(j).ship_to_party_site_id,1,'N');

1490: END IF;
1491:
1492: IF l_ship_cust_account_id IS NOT NULL AND l_ship_cust_account_id <> FND_API.G_MISS_NUM THEN
1493: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1494: aso_debug_pub.add('line acct info: before cust_acct_site:p_line_shipment_tbl(j).ship_to_party_site_id: '||p_line_shipment_tbl(j).ship_to_party_site_id,1,'N');
1495: END IF;
1496: IF p_line_shipment_tbl(j).ship_to_party_site_id is not NULL AND
1497: p_line_shipment_tbl(j).ship_to_party_site_id <> FND_API.G_MISS_NUM THEN
1498:

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

1506: ,x_msg_count => x_msg_count
1507: ,x_msg_data => x_msg_data
1508: ,x_site_use_id => l_site_use_id);
1509:
1510: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1511: aso_debug_pub.add('line acct info: after cust_acct_site:l_site_use_id: '||l_site_use_id,1,'N');
1512: aso_debug_pub.add('line acct info: after cust_acct_site:l_shp_cust_acct_site_id: '||l_shp_cust_acct_site_id,1,'N');
1513: END IF;
1514: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1511: aso_debug_pub.add('line acct info: after cust_acct_site:l_site_use_id: '||l_site_use_id,1,'N');

1507: ,x_msg_data => x_msg_data
1508: ,x_site_use_id => l_site_use_id);
1509:
1510: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1511: aso_debug_pub.add('line acct info: after cust_acct_site:l_site_use_id: '||l_site_use_id,1,'N');
1512: aso_debug_pub.add('line acct info: after cust_acct_site:l_shp_cust_acct_site_id: '||l_shp_cust_acct_site_id,1,'N');
1513: END IF;
1514: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1515: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1512: aso_debug_pub.add('line acct info: after cust_acct_site:l_shp_cust_acct_site_id: '||l_shp_cust_acct_site_id,1,'N');

1508: ,x_site_use_id => l_site_use_id);
1509:
1510: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1511: aso_debug_pub.add('line acct info: after cust_acct_site:l_site_use_id: '||l_site_use_id,1,'N');
1512: aso_debug_pub.add('line acct info: after cust_acct_site:l_shp_cust_acct_site_id: '||l_shp_cust_acct_site_id,1,'N');
1513: END IF;
1514: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1515: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1516: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');

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

1521: END IF;
1522:
1523: END IF;
1524:
1525: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1526: aso_debug_pub.add('chk_ln: before Cust_Acct_Contact_Addr:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');
1527: END IF;
1528:
1529: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

Line 1526: aso_debug_pub.add('chk_ln: before Cust_Acct_Contact_Addr:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');

1522:
1523: END IF;
1524:
1525: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1526: aso_debug_pub.add('chk_ln: before Cust_Acct_Contact_Addr:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');
1527: END IF;
1528:
1529: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
1530: p_api_version => 1.0,

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

1537: x_msg_count => x_msg_count,
1538: x_msg_data => x_msg_data,
1539: x_cust_account_role_id => l_ship_to_contact_id);
1540:
1541: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1542: aso_debug_pub.add('chk_ln: after Cust_Acct_Contact_Addr:l_ship_to_contact_id: '||l_ship_to_contact_id,1,'N');
1543: aso_debug_pub.add('chk_ln: after Cust_Acct_Contact_Addr:l_shp_cust_acct_site_id: '||l_shp_cust_acct_site_id,1,'N');
1544: END IF;
1545:

Line 1542: aso_debug_pub.add('chk_ln: after Cust_Acct_Contact_Addr:l_ship_to_contact_id: '||l_ship_to_contact_id,1,'N');

1538: x_msg_data => x_msg_data,
1539: x_cust_account_role_id => l_ship_to_contact_id);
1540:
1541: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1542: aso_debug_pub.add('chk_ln: after Cust_Acct_Contact_Addr:l_ship_to_contact_id: '||l_ship_to_contact_id,1,'N');
1543: aso_debug_pub.add('chk_ln: after Cust_Acct_Contact_Addr:l_shp_cust_acct_site_id: '||l_shp_cust_acct_site_id,1,'N');
1544: END IF;
1545:
1546: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1543: aso_debug_pub.add('chk_ln: after Cust_Acct_Contact_Addr:l_shp_cust_acct_site_id: '||l_shp_cust_acct_site_id,1,'N');

1539: x_cust_account_role_id => l_ship_to_contact_id);
1540:
1541: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1542: aso_debug_pub.add('chk_ln: after Cust_Acct_Contact_Addr:l_ship_to_contact_id: '||l_ship_to_contact_id,1,'N');
1543: aso_debug_pub.add('chk_ln: after Cust_Acct_Contact_Addr:l_shp_cust_acct_site_id: '||l_shp_cust_acct_site_id,1,'N');
1544: END IF;
1545:
1546: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1547: raise FND_API.G_EXC_ERROR;

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

1689: END IF;
1690:
1691: x_return_status := FND_API.G_RET_STS_SUCCESS;
1692:
1693: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1694: aso_debug_pub.add('Chk_TCA.Customer_Account Begin ',1,'N');
1695: aso_debug_pub.add('Customer_Account: p_party_id '||p_party_id,1,'N');
1696: aso_debug_pub.add('Customer_Account: p_error_ret '||p_error_ret,1,'N');
1697: aso_debug_pub.add('Customer_Account: p_calling_api_flag '||p_calling_api_flag,1,'N');

Line 1694: aso_debug_pub.add('Chk_TCA.Customer_Account Begin ',1,'N');

1690:
1691: x_return_status := FND_API.G_RET_STS_SUCCESS;
1692:
1693: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1694: aso_debug_pub.add('Chk_TCA.Customer_Account Begin ',1,'N');
1695: aso_debug_pub.add('Customer_Account: p_party_id '||p_party_id,1,'N');
1696: aso_debug_pub.add('Customer_Account: p_error_ret '||p_error_ret,1,'N');
1697: aso_debug_pub.add('Customer_Account: p_calling_api_flag '||p_calling_api_flag,1,'N');
1698: END IF;

Line 1695: aso_debug_pub.add('Customer_Account: p_party_id '||p_party_id,1,'N');

1691: x_return_status := FND_API.G_RET_STS_SUCCESS;
1692:
1693: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1694: aso_debug_pub.add('Chk_TCA.Customer_Account Begin ',1,'N');
1695: aso_debug_pub.add('Customer_Account: p_party_id '||p_party_id,1,'N');
1696: aso_debug_pub.add('Customer_Account: p_error_ret '||p_error_ret,1,'N');
1697: aso_debug_pub.add('Customer_Account: p_calling_api_flag '||p_calling_api_flag,1,'N');
1698: END IF;
1699:

Line 1696: aso_debug_pub.add('Customer_Account: p_error_ret '||p_error_ret,1,'N');

1692:
1693: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1694: aso_debug_pub.add('Chk_TCA.Customer_Account Begin ',1,'N');
1695: aso_debug_pub.add('Customer_Account: p_party_id '||p_party_id,1,'N');
1696: aso_debug_pub.add('Customer_Account: p_error_ret '||p_error_ret,1,'N');
1697: aso_debug_pub.add('Customer_Account: p_calling_api_flag '||p_calling_api_flag,1,'N');
1698: END IF;
1699:
1700: OPEN party_rec(p_party_id);

Line 1697: aso_debug_pub.add('Customer_Account: p_calling_api_flag '||p_calling_api_flag,1,'N');

1693: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1694: aso_debug_pub.add('Chk_TCA.Customer_Account Begin ',1,'N');
1695: aso_debug_pub.add('Customer_Account: p_party_id '||p_party_id,1,'N');
1696: aso_debug_pub.add('Customer_Account: p_error_ret '||p_error_ret,1,'N');
1697: aso_debug_pub.add('Customer_Account: p_calling_api_flag '||p_calling_api_flag,1,'N');
1698: END IF;
1699:
1700: OPEN party_rec(p_party_id);
1701: FETCH party_rec INTO l_party_type;

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

1700: OPEN party_rec(p_party_id);
1701: FETCH party_rec INTO l_party_type;
1702: CLOSE party_rec;
1703:
1704: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1705: aso_debug_pub.add('Cust_Acct:party type for sold_to = '|| l_party_type,1,'N');
1706: END IF;
1707: IF l_party_type = 'PERSON' OR l_party_type ='ORGANIZATION' THEN
1708:

Line 1705: aso_debug_pub.add('Cust_Acct:party type for sold_to = '|| l_party_type,1,'N');

1701: FETCH party_rec INTO l_party_type;
1702: CLOSE party_rec;
1703:
1704: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1705: aso_debug_pub.add('Cust_Acct:party type for sold_to = '|| l_party_type,1,'N');
1706: END IF;
1707: IF l_party_type = 'PERSON' OR l_party_type ='ORGANIZATION' THEN
1708:
1709: IF p_error_ret = FND_API.G_TRUE AND p_calling_api_flag NOT IN (1,2) THEN

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

1710: OPEN C_Get_Account_Count(p_party_id);
1711: FETCH C_Get_Account_Count INTO l_acct_count;
1712: CLOSE C_Get_Account_Count;
1713:
1714: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1715: aso_debug_pub.add('Cust_Acct:l_acct_count: '|| l_acct_count,1,'N');
1716: END IF;
1717: IF l_acct_count > 1 THEN
1718: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1715: aso_debug_pub.add('Cust_Acct:l_acct_count: '|| l_acct_count,1,'N');

1711: FETCH C_Get_Account_Count INTO l_acct_count;
1712: CLOSE C_Get_Account_Count;
1713:
1714: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1715: aso_debug_pub.add('Cust_Acct:l_acct_count: '|| l_acct_count,1,'N');
1716: END IF;
1717: IF l_acct_count > 1 THEN
1718: x_return_status := FND_API.G_RET_STS_ERROR;
1719: FND_MESSAGE.Set_Name('ASO', 'ASO_MULTIPLE_CUST_ACCOUNT');

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

1727: OPEN C_get_cust_id_from_party_id(p_Party_Id);
1728: FETCH C_get_cust_id_from_party_id INTO lx_cust_id;
1729: CLOSE C_get_cust_id_from_party_id;
1730:
1731: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1732: aso_debug_pub.add('Cust_Acct:cust acct id for sold_to = '|| lx_cust_id,1,'N');
1733: END IF;
1734:
1735: ELSIF l_party_type = 'PARTY_RELATIONSHIP' THEN -- party_type

Line 1732: aso_debug_pub.add('Cust_Acct:cust acct id for sold_to = '|| lx_cust_id,1,'N');

1728: FETCH C_get_cust_id_from_party_id INTO lx_cust_id;
1729: CLOSE C_get_cust_id_from_party_id;
1730:
1731: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1732: aso_debug_pub.add('Cust_Acct:cust acct id for sold_to = '|| lx_cust_id,1,'N');
1733: END IF;
1734:
1735: ELSIF l_party_type = 'PARTY_RELATIONSHIP' THEN -- party_type
1736:

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

1738: OPEN C_Get_Account_User_Count(p_party_id);
1739: FETCH C_Get_Account_User_Count INTO l_acct_count;
1740: CLOSE C_Get_Account_User_Count;
1741:
1742: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1743: aso_debug_pub.add('Cust_Acct:l_acct_count: '|| l_acct_count,1,'N');
1744: END IF;
1745: IF l_acct_count > 1 THEN
1746: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1743: aso_debug_pub.add('Cust_Acct:l_acct_count: '|| l_acct_count,1,'N');

1739: FETCH C_Get_Account_User_Count INTO l_acct_count;
1740: CLOSE C_Get_Account_User_Count;
1741:
1742: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1743: aso_debug_pub.add('Cust_Acct:l_acct_count: '|| l_acct_count,1,'N');
1744: END IF;
1745: IF l_acct_count > 1 THEN
1746: x_return_status := FND_API.G_RET_STS_ERROR;
1747: FND_MESSAGE.Set_Name('ASO', 'ASO_MULTIPLE_CUST_ACCOUNT');

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

1754: OPEN account_user_cur(p_party_id);
1755: FETCH account_user_cur INTO lx_cust_id;
1756: CLOSE account_user_cur;
1757:
1758: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1759: aso_debug_pub.add('cust acct id for sold_to = '|| lx_cust_id,1,'N');
1760: END IF;
1761: END IF; -- party_type
1762:

Line 1759: aso_debug_pub.add('cust acct id for sold_to = '|| lx_cust_id,1,'N');

1755: FETCH account_user_cur INTO lx_cust_id;
1756: CLOSE account_user_cur;
1757:
1758: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1759: aso_debug_pub.add('cust acct id for sold_to = '|| lx_cust_id,1,'N');
1760: END IF;
1761: END IF; -- party_type
1762:
1763: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

1759: aso_debug_pub.add('cust acct id for sold_to = '|| lx_cust_id,1,'N');
1760: END IF;
1761: END IF; -- party_type
1762:
1763: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1764: aso_debug_pub.add('checking for object id of relationship',1,'N');
1765: aso_debug_pub.add('lx_cust_id in rel = ' || lx_cust_id,1,'N');
1766: END IF;
1767:

Line 1764: aso_debug_pub.add('checking for object id of relationship',1,'N');

1760: END IF;
1761: END IF; -- party_type
1762:
1763: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1764: aso_debug_pub.add('checking for object id of relationship',1,'N');
1765: aso_debug_pub.add('lx_cust_id in rel = ' || lx_cust_id,1,'N');
1766: END IF;
1767:
1768: IF lx_cust_id is NULL OR lx_cust_id = FND_API.G_MISS_NUM THEN

Line 1765: aso_debug_pub.add('lx_cust_id in rel = ' || lx_cust_id,1,'N');

1761: END IF; -- party_type
1762:
1763: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1764: aso_debug_pub.add('checking for object id of relationship',1,'N');
1765: aso_debug_pub.add('lx_cust_id in rel = ' || lx_cust_id,1,'N');
1766: END IF;
1767:
1768: IF lx_cust_id is NULL OR lx_cust_id = FND_API.G_MISS_NUM THEN
1769:

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

1768: IF lx_cust_id is NULL OR lx_cust_id = FND_API.G_MISS_NUM THEN
1769:
1770: OPEN party_rel_cur(p_party_id);
1771: FETCH party_rel_cur INTO l_object_party_id;
1772: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1773: aso_debug_pub.add('object_id = ' || l_object_party_id,1,'N');
1774: END IF;
1775: IF party_rel_cur%NOTFOUND THEN
1776: -- x_return_status := FND_API.G_RET_STS_ERROR;

Line 1773: aso_debug_pub.add('object_id = ' || l_object_party_id,1,'N');

1769:
1770: OPEN party_rel_cur(p_party_id);
1771: FETCH party_rel_cur INTO l_object_party_id;
1772: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1773: aso_debug_pub.add('object_id = ' || l_object_party_id,1,'N');
1774: END IF;
1775: IF party_rel_cur%NOTFOUND THEN
1776: -- x_return_status := FND_API.G_RET_STS_ERROR;
1777: CLOSE party_rel_cur;

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

1779: IF p_error_ret = FND_API.G_TRUE AND p_calling_api_flag NOT IN (1,2) THEN
1780: OPEN C_Get_Account_Count(l_object_party_id);
1781: FETCH C_Get_Account_Count INTO l_acct_count;
1782: CLOSE C_Get_Account_Count;
1783: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1784: aso_debug_pub.add('Cust_Acct:l_acct_count: '|| l_acct_count,1,'N');
1785: END IF;
1786:
1787: IF l_acct_count > 1 THEN

Line 1784: aso_debug_pub.add('Cust_Acct:l_acct_count: '|| l_acct_count,1,'N');

1780: OPEN C_Get_Account_Count(l_object_party_id);
1781: FETCH C_Get_Account_Count INTO l_acct_count;
1782: CLOSE C_Get_Account_Count;
1783: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1784: aso_debug_pub.add('Cust_Acct:l_acct_count: '|| l_acct_count,1,'N');
1785: END IF;
1786:
1787: IF l_acct_count > 1 THEN
1788: x_return_status := FND_API.G_RET_STS_ERROR;

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

1795:
1796: OPEN account_user_cur(l_object_party_id);
1797: FETCH account_user_cur INTO lx_cust_id;
1798: CLOSE account_user_cur;
1799: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1800: aso_debug_pub.add('cust acct id for sold_to = '|| lx_cust_id,1,'N');
1801: END IF;
1802:
1803: END IF; -- party_rel_cur

Line 1800: aso_debug_pub.add('cust acct id for sold_to = '|| lx_cust_id,1,'N');

1796: OPEN account_user_cur(l_object_party_id);
1797: FETCH account_user_cur INTO lx_cust_id;
1798: CLOSE account_user_cur;
1799: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1800: aso_debug_pub.add('cust acct id for sold_to = '|| lx_cust_id,1,'N');
1801: END IF;
1802:
1803: END IF; -- party_rel_cur
1804:

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

1803: END IF; -- party_rel_cur
1804:
1805: END IF; -- lx_cust_id
1806: -- create customer account
1807: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1808: aso_debug_pub.add('creating customer account',1,'N');
1809: END IF;
1810: IF lx_cust_id IS NULL OR lx_cust_id = FND_API.G_MISS_NUM THEN
1811: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1808: aso_debug_pub.add('creating customer account',1,'N');

1804:
1805: END IF; -- lx_cust_id
1806: -- create customer account
1807: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1808: aso_debug_pub.add('creating customer account',1,'N');
1809: END IF;
1810: IF lx_cust_id IS NULL OR lx_cust_id = FND_API.G_MISS_NUM THEN
1811: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1812: aso_debug_pub.add('Cust_Acct:l_create_acct_prof: '|| l_create_acct_prof,1,'N');

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

1807: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1808: aso_debug_pub.add('creating customer account',1,'N');
1809: END IF;
1810: IF lx_cust_id IS NULL OR lx_cust_id = FND_API.G_MISS_NUM THEN
1811: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1812: aso_debug_pub.add('Cust_Acct:l_create_acct_prof: '|| l_create_acct_prof,1,'N');
1813: END IF;
1814: IF p_calling_api_flag = 1 AND (l_create_acct_prof = 'PLACE_ORDER') THEN
1815: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1812: aso_debug_pub.add('Cust_Acct:l_create_acct_prof: '|| l_create_acct_prof,1,'N');

1808: aso_debug_pub.add('creating customer account',1,'N');
1809: END IF;
1810: IF lx_cust_id IS NULL OR lx_cust_id = FND_API.G_MISS_NUM THEN
1811: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1812: aso_debug_pub.add('Cust_Acct:l_create_acct_prof: '|| l_create_acct_prof,1,'N');
1813: END IF;
1814: IF p_calling_api_flag = 1 AND (l_create_acct_prof = 'PLACE_ORDER') THEN
1815: x_return_status := FND_API.G_RET_STS_ERROR;
1816: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_CREATE_ACCOUNT');

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

1820:
1821: IF (l_create_acct_prof = 'ALWAYS') OR
1822: (l_create_acct_prof = 'AS_REQUIRED' AND p_calling_api_flag = 1) OR
1823: (p_calling_api_flag = 2) THEN
1824: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1825: aso_debug_pub.add('creating customer account: create_acct_prof: '||l_create_acct_prof,1,'N');
1826: END IF;
1827: IF p_Party_Id is not NULL
1828: AND p_Party_Id <> FND_API.G_MISS_NUM THEN

Line 1825: aso_debug_pub.add('creating customer account: create_acct_prof: '||l_create_acct_prof,1,'N');

1821: IF (l_create_acct_prof = 'ALWAYS') OR
1822: (l_create_acct_prof = 'AS_REQUIRED' AND p_calling_api_flag = 1) OR
1823: (p_calling_api_flag = 2) THEN
1824: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1825: aso_debug_pub.add('creating customer account: create_acct_prof: '||l_create_acct_prof,1,'N');
1826: END IF;
1827: IF p_Party_Id is not NULL
1828: AND p_Party_Id <> FND_API.G_MISS_NUM THEN
1829: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

1825: aso_debug_pub.add('creating customer account: create_acct_prof: '||l_create_acct_prof,1,'N');
1826: END IF;
1827: IF p_Party_Id is not NULL
1828: AND p_Party_Id <> FND_API.G_MISS_NUM THEN
1829: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1830: aso_debug_pub.add('creating cust account',1,'N');
1831: END IF;
1832: ASO_PARTY_INT.Create_Customer_Account(
1833: p_api_version => 1.0,

Line 1830: aso_debug_pub.add('creating cust account',1,'N');

1826: END IF;
1827: IF p_Party_Id is not NULL
1828: AND p_Party_Id <> FND_API.G_MISS_NUM THEN
1829: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1830: aso_debug_pub.add('creating cust account',1,'N');
1831: END IF;
1832: ASO_PARTY_INT.Create_Customer_Account(
1833: p_api_version => 1.0,
1834: P_Party_id => p_Party_Id,

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

1861: x_Cust_Acct_Id := lx_cust_id;
1862:
1863: END IF; -- lx_cust_id
1864:
1865: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1866: aso_debug_pub.add('x_cust_acct_id = '|| x_cust_acct_id,1,'N');
1867: END IF;
1868: FND_MSG_PUB.Count_And_Get
1869: ( p_count => x_msg_count,

Line 1866: aso_debug_pub.add('x_cust_acct_id = '|| x_cust_acct_id,1,'N');

1862:
1863: END IF; -- lx_cust_id
1864:
1865: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1866: aso_debug_pub.add('x_cust_acct_id = '|| x_cust_acct_id,1,'N');
1867: END IF;
1868: FND_MSG_PUB.Count_And_Get
1869: ( p_count => x_msg_count,
1870: p_data => x_msg_data

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

2027: END IF;
2028:
2029: x_return_status := FND_API.G_RET_STS_SUCCESS;
2030:
2031: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2032: aso_debug_pub.add('site type in Customer_Account_Site = ' || p_acct_site_type,1,'N');
2033: END IF;
2034:
2035: IF p_acct_site_type = 'END_USER' THEN

Line 2032: aso_debug_pub.add('site type in Customer_Account_Site = ' || p_acct_site_type,1,'N');

2028:
2029: x_return_status := FND_API.G_RET_STS_SUCCESS;
2030:
2031: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2032: aso_debug_pub.add('site type in Customer_Account_Site = ' || p_acct_site_type,1,'N');
2033: END IF;
2034:
2035: IF p_acct_site_type = 'END_USER' THEN
2036: l_acct_site_type := 'SHIP_TO';

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

2049: FND_MSG_PUB.ADD;
2050: END IF;
2051: raise FND_API.G_EXC_ERROR;
2052: END IF;
2053: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2054: aso_debug_pub.add('party_type in Customer_Account_Site = ' || l_party_type,1,'N');
2055: END IF;
2056: CLOSE party_cur;
2057:

Line 2054: aso_debug_pub.add('party_type in Customer_Account_Site = ' || l_party_type,1,'N');

2050: END IF;
2051: raise FND_API.G_EXC_ERROR;
2052: END IF;
2053: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2054: aso_debug_pub.add('party_type in Customer_Account_Site = ' || l_party_type,1,'N');
2055: END IF;
2056: CLOSE party_cur;
2057:
2058: IF l_party_type = 'PARTY_RELATIONSHIP' THEN

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

2071: ELSE
2072: cur_party_id := l_party_id;
2073: END IF;
2074:
2075: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2076: aso_debug_pub.add('cur_party_id = ' || cur_party_id,1,'N');
2077: END IF;
2078:
2079: -- bug 4947772

Line 2076: aso_debug_pub.add('cur_party_id = ' || cur_party_id,1,'N');

2072: cur_party_id := l_party_id;
2073: END IF;
2074:
2075: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2076: aso_debug_pub.add('cur_party_id = ' || cur_party_id,1,'N');
2077: END IF;
2078:
2079: -- bug 4947772
2080: OPEN active_site_cur;

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

2078:
2079: -- bug 4947772
2080: OPEN active_site_cur;
2081: FETCH active_site_cur INTO x_cust_acct_site_id, cust_acct_site_status;
2082: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2083: aso_debug_pub.add('x_cust_acct_site_id in Customer_Account_Site = ' || x_cust_acct_site_id,1,'N');
2084: aso_debug_pub.add('Customer_Account_Site: cust_acct_site_status: ' || cust_acct_site_status,1,'N');
2085: END IF;
2086:

Line 2083: aso_debug_pub.add('x_cust_acct_site_id in Customer_Account_Site = ' || x_cust_acct_site_id,1,'N');

2079: -- bug 4947772
2080: OPEN active_site_cur;
2081: FETCH active_site_cur INTO x_cust_acct_site_id, cust_acct_site_status;
2082: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2083: aso_debug_pub.add('x_cust_acct_site_id in Customer_Account_Site = ' || x_cust_acct_site_id,1,'N');
2084: aso_debug_pub.add('Customer_Account_Site: cust_acct_site_status: ' || cust_acct_site_status,1,'N');
2085: END IF;
2086:
2087: IF active_site_cur%NOTFOUND THEN

Line 2084: aso_debug_pub.add('Customer_Account_Site: cust_acct_site_status: ' || cust_acct_site_status,1,'N');

2080: OPEN active_site_cur;
2081: FETCH active_site_cur INTO x_cust_acct_site_id, cust_acct_site_status;
2082: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2083: aso_debug_pub.add('x_cust_acct_site_id in Customer_Account_Site = ' || x_cust_acct_site_id,1,'N');
2084: aso_debug_pub.add('Customer_Account_Site: cust_acct_site_status: ' || cust_acct_site_status,1,'N');
2085: END IF;
2086:
2087: IF active_site_cur%NOTFOUND THEN
2088:

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

2116:
2117:
2118: OPEN active_site_use_cur(x_cust_acct_site_id, l_acct_site_type);
2119: FETCH active_site_use_cur INTO x_site_use_id, cust_site_use_status;
2120: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2121: aso_debug_pub.add('Customer_Account_Site: cust_site_use_status: ' || cust_site_use_status,1,'N');
2122: aso_debug_pub.add('Customer_Account_Site: x_site_use_id: ' || x_site_use_id,1,'N');
2123: END IF;
2124: IF (active_site_use_cur%NOTFOUND) THEN

Line 2121: aso_debug_pub.add('Customer_Account_Site: cust_site_use_status: ' || cust_site_use_status,1,'N');

2117:
2118: OPEN active_site_use_cur(x_cust_acct_site_id, l_acct_site_type);
2119: FETCH active_site_use_cur INTO x_site_use_id, cust_site_use_status;
2120: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2121: aso_debug_pub.add('Customer_Account_Site: cust_site_use_status: ' || cust_site_use_status,1,'N');
2122: aso_debug_pub.add('Customer_Account_Site: x_site_use_id: ' || x_site_use_id,1,'N');
2123: END IF;
2124: IF (active_site_use_cur%NOTFOUND) THEN
2125: -- this means there are no active site uses

Line 2122: aso_debug_pub.add('Customer_Account_Site: x_site_use_id: ' || x_site_use_id,1,'N');

2118: OPEN active_site_use_cur(x_cust_acct_site_id, l_acct_site_type);
2119: FETCH active_site_use_cur INTO x_site_use_id, cust_site_use_status;
2120: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2121: aso_debug_pub.add('Customer_Account_Site: cust_site_use_status: ' || cust_site_use_status,1,'N');
2122: aso_debug_pub.add('Customer_Account_Site: x_site_use_id: ' || x_site_use_id,1,'N');
2123: END IF;
2124: IF (active_site_use_cur%NOTFOUND) THEN
2125: -- this means there are no active site uses
2126: OPEN inactive_site_use_cur(x_cust_acct_site_id, l_acct_site_type);

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

2144: CLOSE inactive_site_use_cur;
2145: END IF;
2146: CLOSE active_site_use_cur;
2147:
2148: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2149: aso_debug_pub.add('site_use_id in Customer_Account_Site = ' || x_site_use_id,1,'N');
2150: END IF;
2151:
2152: END IF;

Line 2149: aso_debug_pub.add('site_use_id in Customer_Account_Site = ' || x_site_use_id,1,'N');

2145: END IF;
2146: CLOSE active_site_use_cur;
2147:
2148: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2149: aso_debug_pub.add('site_use_id in Customer_Account_Site = ' || x_site_use_id,1,'N');
2150: END IF;
2151:
2152: END IF;
2153:

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

2150: END IF;
2151:
2152: END IF;
2153:
2154: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2155: aso_debug_pub.add('Customer_Account_Site: x_site_use_id: ' || x_site_use_id,1,'N');
2156: END IF;
2157: IF x_site_use_id is NULL OR
2158: x_site_use_id = FND_API.G_MISS_NUM THEN

Line 2155: aso_debug_pub.add('Customer_Account_Site: x_site_use_id: ' || x_site_use_id,1,'N');

2151:
2152: END IF;
2153:
2154: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2155: aso_debug_pub.add('Customer_Account_Site: x_site_use_id: ' || x_site_use_id,1,'N');
2156: END IF;
2157: IF x_site_use_id is NULL OR
2158: x_site_use_id = FND_API.G_MISS_NUM THEN
2159:

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

2156: END IF;
2157: IF x_site_use_id is NULL OR
2158: x_site_use_id = FND_API.G_MISS_NUM THEN
2159:
2160: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2161: aso_debug_pub.add('calling create accsite uses ',1, 'N');
2162: END IF;
2163: ASO_PARTY_INT.Create_ACCT_SITE_USES (
2164: p_api_version => 1.0

Line 2161: aso_debug_pub.add('calling create accsite uses ',1, 'N');

2157: IF x_site_use_id is NULL OR
2158: x_site_use_id = FND_API.G_MISS_NUM THEN
2159:
2160: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2161: aso_debug_pub.add('calling create accsite uses ',1, 'N');
2162: END IF;
2163: ASO_PARTY_INT.Create_ACCT_SITE_USES (
2164: p_api_version => 1.0
2165: ,P_Cust_Account_Id => p_cust_account_id

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

2174: );
2175:
2176: x_cust_acct_site_id := lx_cust_acct_site_id;
2177:
2178: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2179: aso_debug_pub.add('site_use_id after deriving invoice = ' || x_site_use_id,1, 'Y');
2180: END IF;
2181: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2182: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 2179: aso_debug_pub.add('site_use_id after deriving invoice = ' || x_site_use_id,1, 'Y');

2175:
2176: x_cust_acct_site_id := lx_cust_acct_site_id;
2177:
2178: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2179: aso_debug_pub.add('site_use_id after deriving invoice = ' || x_site_use_id,1, 'Y');
2180: END IF;
2181: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2182: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2183: FND_MESSAGE.Set_Name('ASO', 'ASO_ACCT_SITE_USE');

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

2282: RAISE FND_API.g_exc_unexpected_error;
2283: END IF;
2284:
2285: x_return_status := FND_API.g_ret_sts_success;
2286: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2287: aso_debug_pub.add('Entering cust acct relationship ',1, 'Y');
2288: END IF;
2289:
2290: OPEN c_cust_acct_relate;

Line 2287: aso_debug_pub.add('Entering cust acct relationship ',1, 'Y');

2283: END IF;
2284:
2285: x_return_status := FND_API.g_ret_sts_success;
2286: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2287: aso_debug_pub.add('Entering cust acct relationship ',1, 'Y');
2288: END IF;
2289:
2290: OPEN c_cust_acct_relate;
2291: FETCH c_cust_acct_relate

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

2302: l_cust_acct_flag_match := FND_API.G_TRUE;
2303: END IF;
2304: END IF;
2305:
2306: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2307: aso_debug_pub.add('cust acct relationship: l_cust_acct_match is ' || l_cust_acct_match,1, 'N');
2308: END IF;
2309: IF NOT FND_API.TO_Boolean(l_cust_acct_flag_match) THEN
2310: -- no matching rows

Line 2307: aso_debug_pub.add('cust acct relationship: l_cust_acct_match is ' || l_cust_acct_match,1, 'N');

2303: END IF;
2304: END IF;
2305:
2306: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2307: aso_debug_pub.add('cust acct relationship: l_cust_acct_match is ' || l_cust_acct_match,1, 'N');
2308: END IF;
2309: IF NOT FND_API.TO_Boolean(l_cust_acct_flag_match) THEN
2310: -- no matching rows
2311: IF NOT FND_API.TO_Boolean(l_cust_acct_match) THEN

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

2424: END IF;
2425:
2426: x_return_status := FND_API.G_RET_STS_SUCCESS;
2427:
2428: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2429: aso_debug_pub.add('Cust_acct_contact_Addr: p_role_type: '||p_role_type,1,'N');
2430: END IF;
2431:
2432: IF p_role_type = 'END_USER' THEN

Line 2429: aso_debug_pub.add('Cust_acct_contact_Addr: p_role_type: '||p_role_type,1,'N');

2425:
2426: x_return_status := FND_API.G_RET_STS_SUCCESS;
2427:
2428: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2429: aso_debug_pub.add('Cust_acct_contact_Addr: p_role_type: '||p_role_type,1,'N');
2430: END IF;
2431:
2432: IF p_role_type = 'END_USER' THEN
2433: l_role_type := 'SHIP_TO';

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

2440:
2441: IF p_party_site_id is not NULL AND
2442: p_party_site_id <> FND_API.G_MISS_NUM THEN
2443:
2444: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2445: aso_debug_pub.add('deriving cust acct role for party id ',1,'N');
2446: END IF;
2447:
2448: ASO_MAP_QUOTE_ORDER_INT.get_cust_acct_roles(

Line 2445: aso_debug_pub.add('deriving cust acct role for party id ',1,'N');

2441: IF p_party_site_id is not NULL AND
2442: p_party_site_id <> FND_API.G_MISS_NUM THEN
2443:
2444: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2445: aso_debug_pub.add('deriving cust acct role for party id ',1,'N');
2446: END IF;
2447:
2448: ASO_MAP_QUOTE_ORDER_INT.get_cust_acct_roles(
2449: p_party_id =>p_party_id

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

2452: ,p_cust_account_id => p_cust_account_id
2453: ,x_return_status => x_return_status
2454: ,x_party_id => l_contact_party_id
2455: ,x_cust_account_role_id => l_contact_id);
2456: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2457: aso_debug_pub.add('status after get cust acct roles in Cust_Acct_Contact_Addr = ' || x_return_status,1,'N');
2458: END IF;
2459: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2460: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 2457: aso_debug_pub.add('status after get cust acct roles in Cust_Acct_Contact_Addr = ' || x_return_status,1,'N');

2453: ,x_return_status => x_return_status
2454: ,x_party_id => l_contact_party_id
2455: ,x_cust_account_role_id => l_contact_id);
2456: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2457: aso_debug_pub.add('status after get cust acct roles in Cust_Acct_Contact_Addr = ' || x_return_status,1,'N');
2458: END IF;
2459: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2460: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2461: IF p_role_type = 'BILL_TO' THEN

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

2470: raise FND_API.G_EXC_ERROR;
2471:
2472: ELSE -- x_ret_status = success
2473: IF l_contact_party_id <> FND_API.G_MISS_NUM THEN
2474: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2475: aso_debug_pub.add('cust account site = ' ||p_cust_account_site,1,'N');
2476: END IF;
2477: ASO_PARTY_INT.Create_Contact_Role (
2478: p_api_version => 1.0

Line 2475: aso_debug_pub.add('cust account site = ' ||p_cust_account_site,1,'N');

2471:
2472: ELSE -- x_ret_status = success
2473: IF l_contact_party_id <> FND_API.G_MISS_NUM THEN
2474: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2475: aso_debug_pub.add('cust account site = ' ||p_cust_account_site,1,'N');
2476: END IF;
2477: ASO_PARTY_INT.Create_Contact_Role (
2478: p_api_version => 1.0
2479: ,p_party_id => l_contact_party_id

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

2485: ,x_msg_count => x_msg_count
2486: ,x_msg_data => x_msg_data
2487: ,x_cust_account_role_id => x_cust_account_role_id);
2488:
2489: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2490: aso_debug_pub.add('status after create contact role ship = '|| x_return_status,1,'N');
2491: END IF;
2492:
2493: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2490: aso_debug_pub.add('status after create contact role ship = '|| x_return_status,1,'N');

2486: ,x_msg_data => x_msg_data
2487: ,x_cust_account_role_id => x_cust_account_role_id);
2488:
2489: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2490: aso_debug_pub.add('status after create contact role ship = '|| x_return_status,1,'N');
2491: END IF;
2492:
2493: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2494: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

2631:
2632: -- Initialize API return status to success
2633: x_return_status := FND_API.G_RET_STS_SUCCESS;
2634:
2635: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2636: aso_debug_pub.add('Assign_Customer_Accounts - Begin p_qte_header_id:'|| p_qte_header_id, 1, 'Y');
2637: END IF;
2638:
2639: OPEN C_Validate_Quote (p_qte_header_id);

Line 2636: aso_debug_pub.add('Assign_Customer_Accounts - Begin p_qte_header_id:'|| p_qte_header_id, 1, 'Y');

2632: -- Initialize API return status to success
2633: x_return_status := FND_API.G_RET_STS_SUCCESS;
2634:
2635: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2636: aso_debug_pub.add('Assign_Customer_Accounts - Begin p_qte_header_id:'|| p_qte_header_id, 1, 'Y');
2637: END IF;
2638:
2639: OPEN C_Validate_Quote (p_qte_header_id);
2640: FETCH C_Validate_Quote into l_dummy;

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

2645: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_id), FALSE);
2646: FND_MSG_PUB.ADD;
2647: END IF;
2648:
2649: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2650: aso_debug_pub.add('Assign_Customer_Accounts - Invalid qte_hdr_id', 1, 'Y');
2651: END IF;
2652:
2653: CLOSE C_Validate_Quote;

Line 2650: aso_debug_pub.add('Assign_Customer_Accounts - Invalid qte_hdr_id', 1, 'Y');

2646: FND_MSG_PUB.ADD;
2647: END IF;
2648:
2649: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2650: aso_debug_pub.add('Assign_Customer_Accounts - Invalid qte_hdr_id', 1, 'Y');
2651: END IF;
2652:
2653: CLOSE C_Validate_Quote;
2654: x_return_status := FND_API.G_RET_STS_ERROR;

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

2655: RAISE FND_API.G_EXC_ERROR;
2656: END IF;
2657: CLOSE C_Validate_Quote;
2658:
2659: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2660: aso_debug_pub.add('Assign_Customer_Accounts - After qte_hdr_id check', 1, 'Y');
2661: END IF;
2662:
2663: OPEN C_Get_Hdr_Acct(p_qte_header_id);

Line 2660: aso_debug_pub.add('Assign_Customer_Accounts - After qte_hdr_id check', 1, 'Y');

2656: END IF;
2657: CLOSE C_Validate_Quote;
2658:
2659: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2660: aso_debug_pub.add('Assign_Customer_Accounts - After qte_hdr_id check', 1, 'Y');
2661: END IF;
2662:
2663: OPEN C_Get_Hdr_Acct(p_qte_header_id);
2664: FETCH C_Get_Hdr_Acct INTO

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

2688: l_cust_party := l_qte_header_rec.cust_party_id;
2689: l_inv_cust_party := l_qte_header_rec.invoice_to_cust_party_id;
2690:
2691:
2692: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2693: aso_debug_pub.add('Assign_Customer_Accounts: p_qte_header_id: '||p_qte_header_id, 1, 'N');
2694: aso_debug_pub.add('Assign_Customer_Accounts: p_calling_api_flag: '||p_calling_api_flag, 1, 'N');
2695: aso_debug_pub.add('Assign_Customer_Accounts: l_cust_acct: '||l_cust_acct, 1, 'N');
2696: aso_debug_pub.add('Assign_Customer_Accounts: l_inv_cust_acct: '||l_inv_cust_acct, 1, 'N');

Line 2693: aso_debug_pub.add('Assign_Customer_Accounts: p_qte_header_id: '||p_qte_header_id, 1, 'N');

2689: l_inv_cust_party := l_qte_header_rec.invoice_to_cust_party_id;
2690:
2691:
2692: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2693: aso_debug_pub.add('Assign_Customer_Accounts: p_qte_header_id: '||p_qte_header_id, 1, 'N');
2694: aso_debug_pub.add('Assign_Customer_Accounts: p_calling_api_flag: '||p_calling_api_flag, 1, 'N');
2695: aso_debug_pub.add('Assign_Customer_Accounts: l_cust_acct: '||l_cust_acct, 1, 'N');
2696: aso_debug_pub.add('Assign_Customer_Accounts: l_inv_cust_acct: '||l_inv_cust_acct, 1, 'N');
2697: aso_debug_pub.add('Assign_Customer_Accounts: l_cust_party: '||l_cust_party, 1, 'N');

Line 2694: aso_debug_pub.add('Assign_Customer_Accounts: p_calling_api_flag: '||p_calling_api_flag, 1, 'N');

2690:
2691:
2692: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2693: aso_debug_pub.add('Assign_Customer_Accounts: p_qte_header_id: '||p_qte_header_id, 1, 'N');
2694: aso_debug_pub.add('Assign_Customer_Accounts: p_calling_api_flag: '||p_calling_api_flag, 1, 'N');
2695: aso_debug_pub.add('Assign_Customer_Accounts: l_cust_acct: '||l_cust_acct, 1, 'N');
2696: aso_debug_pub.add('Assign_Customer_Accounts: l_inv_cust_acct: '||l_inv_cust_acct, 1, 'N');
2697: aso_debug_pub.add('Assign_Customer_Accounts: l_cust_party: '||l_cust_party, 1, 'N');
2698: aso_debug_pub.add('Assign_Customer_Accounts: l_inv_cust_party: '||l_inv_cust_party, 1, 'N');

Line 2695: aso_debug_pub.add('Assign_Customer_Accounts: l_cust_acct: '||l_cust_acct, 1, 'N');

2691:
2692: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2693: aso_debug_pub.add('Assign_Customer_Accounts: p_qte_header_id: '||p_qte_header_id, 1, 'N');
2694: aso_debug_pub.add('Assign_Customer_Accounts: p_calling_api_flag: '||p_calling_api_flag, 1, 'N');
2695: aso_debug_pub.add('Assign_Customer_Accounts: l_cust_acct: '||l_cust_acct, 1, 'N');
2696: aso_debug_pub.add('Assign_Customer_Accounts: l_inv_cust_acct: '||l_inv_cust_acct, 1, 'N');
2697: aso_debug_pub.add('Assign_Customer_Accounts: l_cust_party: '||l_cust_party, 1, 'N');
2698: aso_debug_pub.add('Assign_Customer_Accounts: l_inv_cust_party: '||l_inv_cust_party, 1, 'N');
2699: aso_debug_pub.add('Assign_Customer_Accounts: l_end_cust_acct: '||l_end_cust_acct, 1, 'N');

Line 2696: aso_debug_pub.add('Assign_Customer_Accounts: l_inv_cust_acct: '||l_inv_cust_acct, 1, 'N');

2692: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2693: aso_debug_pub.add('Assign_Customer_Accounts: p_qte_header_id: '||p_qte_header_id, 1, 'N');
2694: aso_debug_pub.add('Assign_Customer_Accounts: p_calling_api_flag: '||p_calling_api_flag, 1, 'N');
2695: aso_debug_pub.add('Assign_Customer_Accounts: l_cust_acct: '||l_cust_acct, 1, 'N');
2696: aso_debug_pub.add('Assign_Customer_Accounts: l_inv_cust_acct: '||l_inv_cust_acct, 1, 'N');
2697: aso_debug_pub.add('Assign_Customer_Accounts: l_cust_party: '||l_cust_party, 1, 'N');
2698: aso_debug_pub.add('Assign_Customer_Accounts: l_inv_cust_party: '||l_inv_cust_party, 1, 'N');
2699: aso_debug_pub.add('Assign_Customer_Accounts: l_end_cust_acct: '||l_end_cust_acct, 1, 'N');
2700: aso_debug_pub.add('Assign_Customer_Accounts: l_end_cust_party: '||l_end_cust_party, 1, 'N');

Line 2697: aso_debug_pub.add('Assign_Customer_Accounts: l_cust_party: '||l_cust_party, 1, 'N');

2693: aso_debug_pub.add('Assign_Customer_Accounts: p_qte_header_id: '||p_qte_header_id, 1, 'N');
2694: aso_debug_pub.add('Assign_Customer_Accounts: p_calling_api_flag: '||p_calling_api_flag, 1, 'N');
2695: aso_debug_pub.add('Assign_Customer_Accounts: l_cust_acct: '||l_cust_acct, 1, 'N');
2696: aso_debug_pub.add('Assign_Customer_Accounts: l_inv_cust_acct: '||l_inv_cust_acct, 1, 'N');
2697: aso_debug_pub.add('Assign_Customer_Accounts: l_cust_party: '||l_cust_party, 1, 'N');
2698: aso_debug_pub.add('Assign_Customer_Accounts: l_inv_cust_party: '||l_inv_cust_party, 1, 'N');
2699: aso_debug_pub.add('Assign_Customer_Accounts: l_end_cust_acct: '||l_end_cust_acct, 1, 'N');
2700: aso_debug_pub.add('Assign_Customer_Accounts: l_end_cust_party: '||l_end_cust_party, 1, 'N');
2701: aso_debug_pub.add('l_qte_header_rec.party_id = ' || l_qte_header_rec.party_id,1,'N');

Line 2698: aso_debug_pub.add('Assign_Customer_Accounts: l_inv_cust_party: '||l_inv_cust_party, 1, 'N');

2694: aso_debug_pub.add('Assign_Customer_Accounts: p_calling_api_flag: '||p_calling_api_flag, 1, 'N');
2695: aso_debug_pub.add('Assign_Customer_Accounts: l_cust_acct: '||l_cust_acct, 1, 'N');
2696: aso_debug_pub.add('Assign_Customer_Accounts: l_inv_cust_acct: '||l_inv_cust_acct, 1, 'N');
2697: aso_debug_pub.add('Assign_Customer_Accounts: l_cust_party: '||l_cust_party, 1, 'N');
2698: aso_debug_pub.add('Assign_Customer_Accounts: l_inv_cust_party: '||l_inv_cust_party, 1, 'N');
2699: aso_debug_pub.add('Assign_Customer_Accounts: l_end_cust_acct: '||l_end_cust_acct, 1, 'N');
2700: aso_debug_pub.add('Assign_Customer_Accounts: l_end_cust_party: '||l_end_cust_party, 1, 'N');
2701: aso_debug_pub.add('l_qte_header_rec.party_id = ' || l_qte_header_rec.party_id,1,'N');
2702: aso_debug_pub.add('l_qte_header_rec.sold_to_party_site_id = '||l_qte_header_rec.sold_to_party_site_id,1,'N');

Line 2699: aso_debug_pub.add('Assign_Customer_Accounts: l_end_cust_acct: '||l_end_cust_acct, 1, 'N');

2695: aso_debug_pub.add('Assign_Customer_Accounts: l_cust_acct: '||l_cust_acct, 1, 'N');
2696: aso_debug_pub.add('Assign_Customer_Accounts: l_inv_cust_acct: '||l_inv_cust_acct, 1, 'N');
2697: aso_debug_pub.add('Assign_Customer_Accounts: l_cust_party: '||l_cust_party, 1, 'N');
2698: aso_debug_pub.add('Assign_Customer_Accounts: l_inv_cust_party: '||l_inv_cust_party, 1, 'N');
2699: aso_debug_pub.add('Assign_Customer_Accounts: l_end_cust_acct: '||l_end_cust_acct, 1, 'N');
2700: aso_debug_pub.add('Assign_Customer_Accounts: l_end_cust_party: '||l_end_cust_party, 1, 'N');
2701: aso_debug_pub.add('l_qte_header_rec.party_id = ' || l_qte_header_rec.party_id,1,'N');
2702: aso_debug_pub.add('l_qte_header_rec.sold_to_party_site_id = '||l_qte_header_rec.sold_to_party_site_id,1,'N');
2703: aso_debug_pub.add('l_qte_header_rec.invoice_to_party_id = ' || l_qte_header_rec.invoice_to_party_id,1,'N');

Line 2700: aso_debug_pub.add('Assign_Customer_Accounts: l_end_cust_party: '||l_end_cust_party, 1, 'N');

2696: aso_debug_pub.add('Assign_Customer_Accounts: l_inv_cust_acct: '||l_inv_cust_acct, 1, 'N');
2697: aso_debug_pub.add('Assign_Customer_Accounts: l_cust_party: '||l_cust_party, 1, 'N');
2698: aso_debug_pub.add('Assign_Customer_Accounts: l_inv_cust_party: '||l_inv_cust_party, 1, 'N');
2699: aso_debug_pub.add('Assign_Customer_Accounts: l_end_cust_acct: '||l_end_cust_acct, 1, 'N');
2700: aso_debug_pub.add('Assign_Customer_Accounts: l_end_cust_party: '||l_end_cust_party, 1, 'N');
2701: aso_debug_pub.add('l_qte_header_rec.party_id = ' || l_qte_header_rec.party_id,1,'N');
2702: aso_debug_pub.add('l_qte_header_rec.sold_to_party_site_id = '||l_qte_header_rec.sold_to_party_site_id,1,'N');
2703: aso_debug_pub.add('l_qte_header_rec.invoice_to_party_id = ' || l_qte_header_rec.invoice_to_party_id,1,'N');
2704: aso_debug_pub.add('l_qte_header_rec.invoice_to_party_site_id = '|| l_qte_header_rec.invoice_to_party_site_id,1,'N');

Line 2701: aso_debug_pub.add('l_qte_header_rec.party_id = ' || l_qte_header_rec.party_id,1,'N');

2697: aso_debug_pub.add('Assign_Customer_Accounts: l_cust_party: '||l_cust_party, 1, 'N');
2698: aso_debug_pub.add('Assign_Customer_Accounts: l_inv_cust_party: '||l_inv_cust_party, 1, 'N');
2699: aso_debug_pub.add('Assign_Customer_Accounts: l_end_cust_acct: '||l_end_cust_acct, 1, 'N');
2700: aso_debug_pub.add('Assign_Customer_Accounts: l_end_cust_party: '||l_end_cust_party, 1, 'N');
2701: aso_debug_pub.add('l_qte_header_rec.party_id = ' || l_qte_header_rec.party_id,1,'N');
2702: aso_debug_pub.add('l_qte_header_rec.sold_to_party_site_id = '||l_qte_header_rec.sold_to_party_site_id,1,'N');
2703: aso_debug_pub.add('l_qte_header_rec.invoice_to_party_id = ' || l_qte_header_rec.invoice_to_party_id,1,'N');
2704: aso_debug_pub.add('l_qte_header_rec.invoice_to_party_site_id = '|| l_qte_header_rec.invoice_to_party_site_id,1,'N');
2705: aso_debug_pub.add('l_qte_header_rec.End_Customer_party_id = ' || l_qte_header_rec.End_Customer_party_id,1,'N');

Line 2702: aso_debug_pub.add('l_qte_header_rec.sold_to_party_site_id = '||l_qte_header_rec.sold_to_party_site_id,1,'N');

2698: aso_debug_pub.add('Assign_Customer_Accounts: l_inv_cust_party: '||l_inv_cust_party, 1, 'N');
2699: aso_debug_pub.add('Assign_Customer_Accounts: l_end_cust_acct: '||l_end_cust_acct, 1, 'N');
2700: aso_debug_pub.add('Assign_Customer_Accounts: l_end_cust_party: '||l_end_cust_party, 1, 'N');
2701: aso_debug_pub.add('l_qte_header_rec.party_id = ' || l_qte_header_rec.party_id,1,'N');
2702: aso_debug_pub.add('l_qte_header_rec.sold_to_party_site_id = '||l_qte_header_rec.sold_to_party_site_id,1,'N');
2703: aso_debug_pub.add('l_qte_header_rec.invoice_to_party_id = ' || l_qte_header_rec.invoice_to_party_id,1,'N');
2704: aso_debug_pub.add('l_qte_header_rec.invoice_to_party_site_id = '|| l_qte_header_rec.invoice_to_party_site_id,1,'N');
2705: aso_debug_pub.add('l_qte_header_rec.End_Customer_party_id = ' || l_qte_header_rec.End_Customer_party_id,1,'N');
2706: aso_debug_pub.add('l_qte_header_rec.End_Customer_party_site_id = '|| l_qte_header_rec.End_Customer_party_site_id,1,'N');

Line 2703: aso_debug_pub.add('l_qte_header_rec.invoice_to_party_id = ' || l_qte_header_rec.invoice_to_party_id,1,'N');

2699: aso_debug_pub.add('Assign_Customer_Accounts: l_end_cust_acct: '||l_end_cust_acct, 1, 'N');
2700: aso_debug_pub.add('Assign_Customer_Accounts: l_end_cust_party: '||l_end_cust_party, 1, 'N');
2701: aso_debug_pub.add('l_qte_header_rec.party_id = ' || l_qte_header_rec.party_id,1,'N');
2702: aso_debug_pub.add('l_qte_header_rec.sold_to_party_site_id = '||l_qte_header_rec.sold_to_party_site_id,1,'N');
2703: aso_debug_pub.add('l_qte_header_rec.invoice_to_party_id = ' || l_qte_header_rec.invoice_to_party_id,1,'N');
2704: aso_debug_pub.add('l_qte_header_rec.invoice_to_party_site_id = '|| l_qte_header_rec.invoice_to_party_site_id,1,'N');
2705: aso_debug_pub.add('l_qte_header_rec.End_Customer_party_id = ' || l_qte_header_rec.End_Customer_party_id,1,'N');
2706: aso_debug_pub.add('l_qte_header_rec.End_Customer_party_site_id = '|| l_qte_header_rec.End_Customer_party_site_id,1,'N');
2707: aso_debug_pub.add('l_header_shipment_tbl.count '|| l_header_shipment_tbl.count,1,'N');

Line 2704: aso_debug_pub.add('l_qte_header_rec.invoice_to_party_site_id = '|| l_qte_header_rec.invoice_to_party_site_id,1,'N');

2700: aso_debug_pub.add('Assign_Customer_Accounts: l_end_cust_party: '||l_end_cust_party, 1, 'N');
2701: aso_debug_pub.add('l_qte_header_rec.party_id = ' || l_qte_header_rec.party_id,1,'N');
2702: aso_debug_pub.add('l_qte_header_rec.sold_to_party_site_id = '||l_qte_header_rec.sold_to_party_site_id,1,'N');
2703: aso_debug_pub.add('l_qte_header_rec.invoice_to_party_id = ' || l_qte_header_rec.invoice_to_party_id,1,'N');
2704: aso_debug_pub.add('l_qte_header_rec.invoice_to_party_site_id = '|| l_qte_header_rec.invoice_to_party_site_id,1,'N');
2705: aso_debug_pub.add('l_qte_header_rec.End_Customer_party_id = ' || l_qte_header_rec.End_Customer_party_id,1,'N');
2706: aso_debug_pub.add('l_qte_header_rec.End_Customer_party_site_id = '|| l_qte_header_rec.End_Customer_party_site_id,1,'N');
2707: aso_debug_pub.add('l_header_shipment_tbl.count '|| l_header_shipment_tbl.count,1,'N');
2708: IF l_header_shipment_tbl.count > 0 THEN

Line 2705: aso_debug_pub.add('l_qte_header_rec.End_Customer_party_id = ' || l_qte_header_rec.End_Customer_party_id,1,'N');

2701: aso_debug_pub.add('l_qte_header_rec.party_id = ' || l_qte_header_rec.party_id,1,'N');
2702: aso_debug_pub.add('l_qte_header_rec.sold_to_party_site_id = '||l_qte_header_rec.sold_to_party_site_id,1,'N');
2703: aso_debug_pub.add('l_qte_header_rec.invoice_to_party_id = ' || l_qte_header_rec.invoice_to_party_id,1,'N');
2704: aso_debug_pub.add('l_qte_header_rec.invoice_to_party_site_id = '|| l_qte_header_rec.invoice_to_party_site_id,1,'N');
2705: aso_debug_pub.add('l_qte_header_rec.End_Customer_party_id = ' || l_qte_header_rec.End_Customer_party_id,1,'N');
2706: aso_debug_pub.add('l_qte_header_rec.End_Customer_party_site_id = '|| l_qte_header_rec.End_Customer_party_site_id,1,'N');
2707: aso_debug_pub.add('l_header_shipment_tbl.count '|| l_header_shipment_tbl.count,1,'N');
2708: IF l_header_shipment_tbl.count > 0 THEN
2709: aso_debug_pub.add('l_header_shipment_tbl(1).shipment_id = '|| l_header_shipment_tbl(1).shipment_id,1,'N');

Line 2706: aso_debug_pub.add('l_qte_header_rec.End_Customer_party_site_id = '|| l_qte_header_rec.End_Customer_party_site_id,1,'N');

2702: aso_debug_pub.add('l_qte_header_rec.sold_to_party_site_id = '||l_qte_header_rec.sold_to_party_site_id,1,'N');
2703: aso_debug_pub.add('l_qte_header_rec.invoice_to_party_id = ' || l_qte_header_rec.invoice_to_party_id,1,'N');
2704: aso_debug_pub.add('l_qte_header_rec.invoice_to_party_site_id = '|| l_qte_header_rec.invoice_to_party_site_id,1,'N');
2705: aso_debug_pub.add('l_qte_header_rec.End_Customer_party_id = ' || l_qte_header_rec.End_Customer_party_id,1,'N');
2706: aso_debug_pub.add('l_qte_header_rec.End_Customer_party_site_id = '|| l_qte_header_rec.End_Customer_party_site_id,1,'N');
2707: aso_debug_pub.add('l_header_shipment_tbl.count '|| l_header_shipment_tbl.count,1,'N');
2708: IF l_header_shipment_tbl.count > 0 THEN
2709: aso_debug_pub.add('l_header_shipment_tbl(1).shipment_id = '|| l_header_shipment_tbl(1).shipment_id,1,'N');
2710: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_party_id = '|| l_header_shipment_tbl(1).ship_to_party_id,1,'N');

Line 2707: aso_debug_pub.add('l_header_shipment_tbl.count '|| l_header_shipment_tbl.count,1,'N');

2703: aso_debug_pub.add('l_qte_header_rec.invoice_to_party_id = ' || l_qte_header_rec.invoice_to_party_id,1,'N');
2704: aso_debug_pub.add('l_qte_header_rec.invoice_to_party_site_id = '|| l_qte_header_rec.invoice_to_party_site_id,1,'N');
2705: aso_debug_pub.add('l_qte_header_rec.End_Customer_party_id = ' || l_qte_header_rec.End_Customer_party_id,1,'N');
2706: aso_debug_pub.add('l_qte_header_rec.End_Customer_party_site_id = '|| l_qte_header_rec.End_Customer_party_site_id,1,'N');
2707: aso_debug_pub.add('l_header_shipment_tbl.count '|| l_header_shipment_tbl.count,1,'N');
2708: IF l_header_shipment_tbl.count > 0 THEN
2709: aso_debug_pub.add('l_header_shipment_tbl(1).shipment_id = '|| l_header_shipment_tbl(1).shipment_id,1,'N');
2710: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_party_id = '|| l_header_shipment_tbl(1).ship_to_party_id,1,'N');
2711: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_party_site_id = '|| l_header_shipment_tbl(1).ship_to_party_site_id,1,'N');

Line 2709: aso_debug_pub.add('l_header_shipment_tbl(1).shipment_id = '|| l_header_shipment_tbl(1).shipment_id,1,'N');

2705: aso_debug_pub.add('l_qte_header_rec.End_Customer_party_id = ' || l_qte_header_rec.End_Customer_party_id,1,'N');
2706: aso_debug_pub.add('l_qte_header_rec.End_Customer_party_site_id = '|| l_qte_header_rec.End_Customer_party_site_id,1,'N');
2707: aso_debug_pub.add('l_header_shipment_tbl.count '|| l_header_shipment_tbl.count,1,'N');
2708: IF l_header_shipment_tbl.count > 0 THEN
2709: aso_debug_pub.add('l_header_shipment_tbl(1).shipment_id = '|| l_header_shipment_tbl(1).shipment_id,1,'N');
2710: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_party_id = '|| l_header_shipment_tbl(1).ship_to_party_id,1,'N');
2711: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_party_site_id = '|| l_header_shipment_tbl(1).ship_to_party_site_id,1,'N');
2712: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_cust_party_id = '||l_header_shipment_tbl(1).ship_to_cust_party_id,1,'N');
2713: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_cust_account_id = '|| l_header_shipment_tbl(1).ship_to_cust_account_id,1,'N');

Line 2710: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_party_id = '|| l_header_shipment_tbl(1).ship_to_party_id,1,'N');

2706: aso_debug_pub.add('l_qte_header_rec.End_Customer_party_site_id = '|| l_qte_header_rec.End_Customer_party_site_id,1,'N');
2707: aso_debug_pub.add('l_header_shipment_tbl.count '|| l_header_shipment_tbl.count,1,'N');
2708: IF l_header_shipment_tbl.count > 0 THEN
2709: aso_debug_pub.add('l_header_shipment_tbl(1).shipment_id = '|| l_header_shipment_tbl(1).shipment_id,1,'N');
2710: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_party_id = '|| l_header_shipment_tbl(1).ship_to_party_id,1,'N');
2711: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_party_site_id = '|| l_header_shipment_tbl(1).ship_to_party_site_id,1,'N');
2712: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_cust_party_id = '||l_header_shipment_tbl(1).ship_to_cust_party_id,1,'N');
2713: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_cust_account_id = '|| l_header_shipment_tbl(1).ship_to_cust_account_id,1,'N');
2714: END IF;

Line 2711: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_party_site_id = '|| l_header_shipment_tbl(1).ship_to_party_site_id,1,'N');

2707: aso_debug_pub.add('l_header_shipment_tbl.count '|| l_header_shipment_tbl.count,1,'N');
2708: IF l_header_shipment_tbl.count > 0 THEN
2709: aso_debug_pub.add('l_header_shipment_tbl(1).shipment_id = '|| l_header_shipment_tbl(1).shipment_id,1,'N');
2710: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_party_id = '|| l_header_shipment_tbl(1).ship_to_party_id,1,'N');
2711: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_party_site_id = '|| l_header_shipment_tbl(1).ship_to_party_site_id,1,'N');
2712: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_cust_party_id = '||l_header_shipment_tbl(1).ship_to_cust_party_id,1,'N');
2713: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_cust_account_id = '|| l_header_shipment_tbl(1).ship_to_cust_account_id,1,'N');
2714: END IF;
2715: END IF;

Line 2712: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_cust_party_id = '||l_header_shipment_tbl(1).ship_to_cust_party_id,1,'N');

2708: IF l_header_shipment_tbl.count > 0 THEN
2709: aso_debug_pub.add('l_header_shipment_tbl(1).shipment_id = '|| l_header_shipment_tbl(1).shipment_id,1,'N');
2710: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_party_id = '|| l_header_shipment_tbl(1).ship_to_party_id,1,'N');
2711: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_party_site_id = '|| l_header_shipment_tbl(1).ship_to_party_site_id,1,'N');
2712: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_cust_party_id = '||l_header_shipment_tbl(1).ship_to_cust_party_id,1,'N');
2713: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_cust_account_id = '|| l_header_shipment_tbl(1).ship_to_cust_account_id,1,'N');
2714: END IF;
2715: END IF;
2716:

Line 2713: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_cust_account_id = '|| l_header_shipment_tbl(1).ship_to_cust_account_id,1,'N');

2709: aso_debug_pub.add('l_header_shipment_tbl(1).shipment_id = '|| l_header_shipment_tbl(1).shipment_id,1,'N');
2710: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_party_id = '|| l_header_shipment_tbl(1).ship_to_party_id,1,'N');
2711: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_party_site_id = '|| l_header_shipment_tbl(1).ship_to_party_site_id,1,'N');
2712: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_cust_party_id = '||l_header_shipment_tbl(1).ship_to_cust_party_id,1,'N');
2713: aso_debug_pub.add('l_header_shipment_tbl(1).ship_to_cust_account_id = '|| l_header_shipment_tbl(1).ship_to_cust_account_id,1,'N');
2714: END IF;
2715: END IF;
2716:
2717: IF l_cust_acct IS NULL THEN

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

2727: x_return_status => x_return_status,
2728: x_msg_count => x_msg_count,
2729: x_msg_data => x_msg_data);
2730:
2731: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2732: aso_debug_pub.add('Assign_Customer_Accounts 1: x_return_status: '||x_return_status, 1, 'N');
2733: aso_debug_pub.add('header sold to customer = ' || l_account_id);
2734: END IF;
2735:

Line 2732: aso_debug_pub.add('Assign_Customer_Accounts 1: x_return_status: '||x_return_status, 1, 'N');

2728: x_msg_count => x_msg_count,
2729: x_msg_data => x_msg_data);
2730:
2731: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2732: aso_debug_pub.add('Assign_Customer_Accounts 1: x_return_status: '||x_return_status, 1, 'N');
2733: aso_debug_pub.add('header sold to customer = ' || l_account_id);
2734: END IF;
2735:
2736:

Line 2733: aso_debug_pub.add('header sold to customer = ' || l_account_id);

2729: x_msg_data => x_msg_data);
2730:
2731: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2732: aso_debug_pub.add('Assign_Customer_Accounts 1: x_return_status: '||x_return_status, 1, 'N');
2733: aso_debug_pub.add('header sold to customer = ' || l_account_id);
2734: END IF;
2735:
2736:
2737: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

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

2757:
2758: END IF;
2759:
2760: END IF;
2761: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2762: aso_debug_pub.add('after header sold_to, l_header_check = ' || l_header_check_tca_flag,1,'N');
2763: END IF;
2764:
2765:

Line 2762: aso_debug_pub.add('after header sold_to, l_header_check = ' || l_header_check_tca_flag,1,'N');

2758: END IF;
2759:
2760: END IF;
2761: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2762: aso_debug_pub.add('after header sold_to, l_header_check = ' || l_header_check_tca_flag,1,'N');
2763: END IF;
2764:
2765:
2766: IF l_inv_cust_acct IS NULL THEN

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

2776: x_return_status => x_return_status,
2777: x_msg_count => x_msg_count,
2778: x_msg_data => x_msg_data);
2779:
2780: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2781: aso_debug_pub.add('Assign_Customer_Accounts 2: x_return_status: '||x_return_status, 1, 'N');
2782: aso_debug_pub.add('header invoice to account = ' || l_account_id,1,'N');
2783: END IF;
2784:

Line 2781: aso_debug_pub.add('Assign_Customer_Accounts 2: x_return_status: '||x_return_status, 1, 'N');

2777: x_msg_count => x_msg_count,
2778: x_msg_data => x_msg_data);
2779:
2780: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2781: aso_debug_pub.add('Assign_Customer_Accounts 2: x_return_status: '||x_return_status, 1, 'N');
2782: aso_debug_pub.add('header invoice to account = ' || l_account_id,1,'N');
2783: END IF;
2784:
2785:

Line 2782: aso_debug_pub.add('header invoice to account = ' || l_account_id,1,'N');

2778: x_msg_data => x_msg_data);
2779:
2780: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2781: aso_debug_pub.add('Assign_Customer_Accounts 2: x_return_status: '||x_return_status, 1, 'N');
2782: aso_debug_pub.add('header invoice to account = ' || l_account_id,1,'N');
2783: END IF;
2784:
2785:
2786: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

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

2807:
2808: END IF;
2809:
2810: END IF;
2811: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2812: aso_debug_pub.add('after header sold_to, l_header_check = ' || l_header_check_tca_flag,1,'N');
2813: END IF;
2814:
2815: IF l_end_cust_acct IS NULL THEN

Line 2812: aso_debug_pub.add('after header sold_to, l_header_check = ' || l_header_check_tca_flag,1,'N');

2808: END IF;
2809:
2810: END IF;
2811: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2812: aso_debug_pub.add('after header sold_to, l_header_check = ' || l_header_check_tca_flag,1,'N');
2813: END IF;
2814:
2815: IF l_end_cust_acct IS NULL THEN
2816: l_header_check_tca_flag := 'Y';

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

2825: x_return_status => x_return_status,
2826: x_msg_count => x_msg_count,
2827: x_msg_data => x_msg_data);
2828:
2829: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2830: aso_debug_pub.add('Assign_Customer_Accounts 2: x_return_status: '||x_return_status, 1, 'N');
2831: aso_debug_pub.add('header end customer account = ' || l_account_id,1,'N');
2832: END IF;
2833:

Line 2830: aso_debug_pub.add('Assign_Customer_Accounts 2: x_return_status: '||x_return_status, 1, 'N');

2826: x_msg_count => x_msg_count,
2827: x_msg_data => x_msg_data);
2828:
2829: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2830: aso_debug_pub.add('Assign_Customer_Accounts 2: x_return_status: '||x_return_status, 1, 'N');
2831: aso_debug_pub.add('header end customer account = ' || l_account_id,1,'N');
2832: END IF;
2833:
2834:

Line 2831: aso_debug_pub.add('header end customer account = ' || l_account_id,1,'N');

2827: x_msg_data => x_msg_data);
2828:
2829: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2830: aso_debug_pub.add('Assign_Customer_Accounts 2: x_return_status: '||x_return_status, 1, 'N');
2831: aso_debug_pub.add('header end customer account = ' || l_account_id,1,'N');
2832: END IF;
2833:
2834:
2835: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

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

2856:
2857: END IF;
2858:
2859: END IF;
2860: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2861: aso_debug_pub.add('after header sold_to, l_header_check = ' || l_header_check_tca_flag,1,'N');
2862: END IF;
2863:
2864: IF l_header_shipment_tbl.count > 0 THEN

Line 2861: aso_debug_pub.add('after header sold_to, l_header_check = ' || l_header_check_tca_flag,1,'N');

2857: END IF;
2858:
2859: END IF;
2860: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2861: aso_debug_pub.add('after header sold_to, l_header_check = ' || l_header_check_tca_flag,1,'N');
2862: END IF;
2863:
2864: IF l_header_shipment_tbl.count > 0 THEN
2865:

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

2875: x_return_status => x_return_status,
2876: x_msg_count => x_msg_count,
2877: x_msg_data => x_msg_data);
2878:
2879: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2880: aso_debug_pub.add('Assign_Customer_Accounts 4: x_return_status: '||x_return_status, 1, 'N');
2881: aso_debug_pub.add('header ship to cust party = '||l_header_shipment_tbl(1).ship_to_cust_party_id,1,'N');
2882: aso_debug_pub.add('header ship to account = ' || l_account_id,1,'N');
2883: END IF;

Line 2880: aso_debug_pub.add('Assign_Customer_Accounts 4: x_return_status: '||x_return_status, 1, 'N');

2876: x_msg_count => x_msg_count,
2877: x_msg_data => x_msg_data);
2878:
2879: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2880: aso_debug_pub.add('Assign_Customer_Accounts 4: x_return_status: '||x_return_status, 1, 'N');
2881: aso_debug_pub.add('header ship to cust party = '||l_header_shipment_tbl(1).ship_to_cust_party_id,1,'N');
2882: aso_debug_pub.add('header ship to account = ' || l_account_id,1,'N');
2883: END IF;
2884:

Line 2881: aso_debug_pub.add('header ship to cust party = '||l_header_shipment_tbl(1).ship_to_cust_party_id,1,'N');

2877: x_msg_data => x_msg_data);
2878:
2879: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2880: aso_debug_pub.add('Assign_Customer_Accounts 4: x_return_status: '||x_return_status, 1, 'N');
2881: aso_debug_pub.add('header ship to cust party = '||l_header_shipment_tbl(1).ship_to_cust_party_id,1,'N');
2882: aso_debug_pub.add('header ship to account = ' || l_account_id,1,'N');
2883: END IF;
2884:
2885: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2882: aso_debug_pub.add('header ship to account = ' || l_account_id,1,'N');

2878:
2879: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2880: aso_debug_pub.add('Assign_Customer_Accounts 4: x_return_status: '||x_return_status, 1, 'N');
2881: aso_debug_pub.add('header ship to cust party = '||l_header_shipment_tbl(1).ship_to_cust_party_id,1,'N');
2882: aso_debug_pub.add('header ship to account = ' || l_account_id,1,'N');
2883: END IF;
2884:
2885: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2886: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

2907: END IF;
2908:
2909: END IF; --l_header_shipment_tbl.count
2910:
2911: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2912: aso_debug_pub.add('after header sold_to, l_header_check = ' || l_header_check_tca_flag,1,'N');
2913: END IF;
2914:
2915:

Line 2912: aso_debug_pub.add('after header sold_to, l_header_check = ' || l_header_check_tca_flag,1,'N');

2908:
2909: END IF; --l_header_shipment_tbl.count
2910:
2911: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2912: aso_debug_pub.add('after header sold_to, l_header_check = ' || l_header_check_tca_flag,1,'N');
2913: END IF;
2914:
2915:
2916:

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

2922: p_Header_Shipment_Tbl => l_header_Shipment_Tbl,
2923: x_return_status => x_return_status,
2924: x_msg_count => x_msg_count,
2925: x_msg_data => x_msg_data);
2926: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2927: aso_debug_pub.add('after check tca '||x_return_status, 1, 'N');
2928: END IF;
2929: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2930: RAISE FND_API.G_EXC_ERROR;

Line 2927: aso_debug_pub.add('after check tca '||x_return_status, 1, 'N');

2923: x_return_status => x_return_status,
2924: x_msg_count => x_msg_count,
2925: x_msg_data => x_msg_data);
2926: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2927: aso_debug_pub.add('after check tca '||x_return_status, 1, 'N');
2928: END IF;
2929: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2930: RAISE FND_API.G_EXC_ERROR;
2931: END IF;

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

2930: RAISE FND_API.G_EXC_ERROR;
2931: END IF;
2932: END IF;
2933:
2934: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2935: aso_debug_pub.add('Assign_Customer_Accounts : checking for lines ', 1, 'N');
2936: end if;
2937:
2938: FOR Line_Acct IN C_Get_Line_Acct(p_qte_header_id) LOOP

Line 2935: aso_debug_pub.add('Assign_Customer_Accounts : checking for lines ', 1, 'N');

2931: END IF;
2932: END IF;
2933:
2934: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2935: aso_debug_pub.add('Assign_Customer_Accounts : checking for lines ', 1, 'N');
2936: end if;
2937:
2938: FOR Line_Acct IN C_Get_Line_Acct(p_qte_header_id) LOOP
2939:

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

2957: l_line_shipment_tbl(1).ship_to_party_id := Line_Acct.ship_to_party_id;
2958: l_line_shipment_tbl(1).ship_to_party_site_id := Line_Acct.ship_to_party_site_id;
2959: l_line_shipment_tbl(1).shipment_id := Line_Acct.shipment_id;
2960:
2961: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2962: aso_debug_pub.add('l_qte_line_rec.quote_line_id = '|| l_qte_line_rec.quote_line_id,1,'N');
2963: aso_debug_pub.add('l_qte_line_rec.invoice_to_cust_account_id = '|| l_qte_line_rec.invoice_to_cust_account_id,1,'N');
2964: aso_debug_pub.add('l_qte_line_rec.invoice_to_party_site_id = '|| l_qte_line_rec.invoice_to_party_site_id,1,'N');
2965: aso_debug_pub.add('l_qte_line_rec.invoice_to_cust_party_id = ' || l_qte_line_rec.invoice_to_cust_party_id,1,'N');

Line 2962: aso_debug_pub.add('l_qte_line_rec.quote_line_id = '|| l_qte_line_rec.quote_line_id,1,'N');

2958: l_line_shipment_tbl(1).ship_to_party_site_id := Line_Acct.ship_to_party_site_id;
2959: l_line_shipment_tbl(1).shipment_id := Line_Acct.shipment_id;
2960:
2961: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2962: aso_debug_pub.add('l_qte_line_rec.quote_line_id = '|| l_qte_line_rec.quote_line_id,1,'N');
2963: aso_debug_pub.add('l_qte_line_rec.invoice_to_cust_account_id = '|| l_qte_line_rec.invoice_to_cust_account_id,1,'N');
2964: aso_debug_pub.add('l_qte_line_rec.invoice_to_party_site_id = '|| l_qte_line_rec.invoice_to_party_site_id,1,'N');
2965: aso_debug_pub.add('l_qte_line_rec.invoice_to_cust_party_id = ' || l_qte_line_rec.invoice_to_cust_party_id,1,'N');
2966: aso_debug_pub.add('l_qte_line_rec.invoice_to_party_id = ' || l_qte_line_rec.invoice_to_party_id,1,'N');

Line 2963: aso_debug_pub.add('l_qte_line_rec.invoice_to_cust_account_id = '|| l_qte_line_rec.invoice_to_cust_account_id,1,'N');

2959: l_line_shipment_tbl(1).shipment_id := Line_Acct.shipment_id;
2960:
2961: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2962: aso_debug_pub.add('l_qte_line_rec.quote_line_id = '|| l_qte_line_rec.quote_line_id,1,'N');
2963: aso_debug_pub.add('l_qte_line_rec.invoice_to_cust_account_id = '|| l_qte_line_rec.invoice_to_cust_account_id,1,'N');
2964: aso_debug_pub.add('l_qte_line_rec.invoice_to_party_site_id = '|| l_qte_line_rec.invoice_to_party_site_id,1,'N');
2965: aso_debug_pub.add('l_qte_line_rec.invoice_to_cust_party_id = ' || l_qte_line_rec.invoice_to_cust_party_id,1,'N');
2966: aso_debug_pub.add('l_qte_line_rec.invoice_to_party_id = ' || l_qte_line_rec.invoice_to_party_id,1,'N');
2967: aso_debug_pub.add('l_qte_line_rec.End_Customer_cust_account_id = '|| l_qte_line_rec.End_Customer_cust_account_id,1,'N');

Line 2964: aso_debug_pub.add('l_qte_line_rec.invoice_to_party_site_id = '|| l_qte_line_rec.invoice_to_party_site_id,1,'N');

2960:
2961: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2962: aso_debug_pub.add('l_qte_line_rec.quote_line_id = '|| l_qte_line_rec.quote_line_id,1,'N');
2963: aso_debug_pub.add('l_qte_line_rec.invoice_to_cust_account_id = '|| l_qte_line_rec.invoice_to_cust_account_id,1,'N');
2964: aso_debug_pub.add('l_qte_line_rec.invoice_to_party_site_id = '|| l_qte_line_rec.invoice_to_party_site_id,1,'N');
2965: aso_debug_pub.add('l_qte_line_rec.invoice_to_cust_party_id = ' || l_qte_line_rec.invoice_to_cust_party_id,1,'N');
2966: aso_debug_pub.add('l_qte_line_rec.invoice_to_party_id = ' || l_qte_line_rec.invoice_to_party_id,1,'N');
2967: aso_debug_pub.add('l_qte_line_rec.End_Customer_cust_account_id = '|| l_qte_line_rec.End_Customer_cust_account_id,1,'N');
2968: aso_debug_pub.add('l_qte_line_rec.End_Customer_party_site_id = '|| l_qte_line_rec.End_Customer_party_site_id,1,'N');

Line 2965: aso_debug_pub.add('l_qte_line_rec.invoice_to_cust_party_id = ' || l_qte_line_rec.invoice_to_cust_party_id,1,'N');

2961: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2962: aso_debug_pub.add('l_qte_line_rec.quote_line_id = '|| l_qte_line_rec.quote_line_id,1,'N');
2963: aso_debug_pub.add('l_qte_line_rec.invoice_to_cust_account_id = '|| l_qte_line_rec.invoice_to_cust_account_id,1,'N');
2964: aso_debug_pub.add('l_qte_line_rec.invoice_to_party_site_id = '|| l_qte_line_rec.invoice_to_party_site_id,1,'N');
2965: aso_debug_pub.add('l_qte_line_rec.invoice_to_cust_party_id = ' || l_qte_line_rec.invoice_to_cust_party_id,1,'N');
2966: aso_debug_pub.add('l_qte_line_rec.invoice_to_party_id = ' || l_qte_line_rec.invoice_to_party_id,1,'N');
2967: aso_debug_pub.add('l_qte_line_rec.End_Customer_cust_account_id = '|| l_qte_line_rec.End_Customer_cust_account_id,1,'N');
2968: aso_debug_pub.add('l_qte_line_rec.End_Customer_party_site_id = '|| l_qte_line_rec.End_Customer_party_site_id,1,'N');
2969: aso_debug_pub.add('l_qte_line_rec.End_Customer_cust_party_id = ' || l_qte_line_rec.End_Customer_cust_party_id,1,'N');

Line 2966: aso_debug_pub.add('l_qte_line_rec.invoice_to_party_id = ' || l_qte_line_rec.invoice_to_party_id,1,'N');

2962: aso_debug_pub.add('l_qte_line_rec.quote_line_id = '|| l_qte_line_rec.quote_line_id,1,'N');
2963: aso_debug_pub.add('l_qte_line_rec.invoice_to_cust_account_id = '|| l_qte_line_rec.invoice_to_cust_account_id,1,'N');
2964: aso_debug_pub.add('l_qte_line_rec.invoice_to_party_site_id = '|| l_qte_line_rec.invoice_to_party_site_id,1,'N');
2965: aso_debug_pub.add('l_qte_line_rec.invoice_to_cust_party_id = ' || l_qte_line_rec.invoice_to_cust_party_id,1,'N');
2966: aso_debug_pub.add('l_qte_line_rec.invoice_to_party_id = ' || l_qte_line_rec.invoice_to_party_id,1,'N');
2967: aso_debug_pub.add('l_qte_line_rec.End_Customer_cust_account_id = '|| l_qte_line_rec.End_Customer_cust_account_id,1,'N');
2968: aso_debug_pub.add('l_qte_line_rec.End_Customer_party_site_id = '|| l_qte_line_rec.End_Customer_party_site_id,1,'N');
2969: aso_debug_pub.add('l_qte_line_rec.End_Customer_cust_party_id = ' || l_qte_line_rec.End_Customer_cust_party_id,1,'N');
2970: aso_debug_pub.add('l_qte_line_rec.End_Customer_party_id = ' || l_qte_line_rec.End_Customer_party_id,1,'N');

Line 2967: aso_debug_pub.add('l_qte_line_rec.End_Customer_cust_account_id = '|| l_qte_line_rec.End_Customer_cust_account_id,1,'N');

2963: aso_debug_pub.add('l_qte_line_rec.invoice_to_cust_account_id = '|| l_qte_line_rec.invoice_to_cust_account_id,1,'N');
2964: aso_debug_pub.add('l_qte_line_rec.invoice_to_party_site_id = '|| l_qte_line_rec.invoice_to_party_site_id,1,'N');
2965: aso_debug_pub.add('l_qte_line_rec.invoice_to_cust_party_id = ' || l_qte_line_rec.invoice_to_cust_party_id,1,'N');
2966: aso_debug_pub.add('l_qte_line_rec.invoice_to_party_id = ' || l_qte_line_rec.invoice_to_party_id,1,'N');
2967: aso_debug_pub.add('l_qte_line_rec.End_Customer_cust_account_id = '|| l_qte_line_rec.End_Customer_cust_account_id,1,'N');
2968: aso_debug_pub.add('l_qte_line_rec.End_Customer_party_site_id = '|| l_qte_line_rec.End_Customer_party_site_id,1,'N');
2969: aso_debug_pub.add('l_qte_line_rec.End_Customer_cust_party_id = ' || l_qte_line_rec.End_Customer_cust_party_id,1,'N');
2970: aso_debug_pub.add('l_qte_line_rec.End_Customer_party_id = ' || l_qte_line_rec.End_Customer_party_id,1,'N');
2971: aso_debug_pub.add('l_line_shipment_tbl(1).shipment_id = ' || l_line_shipment_tbl(1).shipment_id,1,'N');

Line 2968: aso_debug_pub.add('l_qte_line_rec.End_Customer_party_site_id = '|| l_qte_line_rec.End_Customer_party_site_id,1,'N');

2964: aso_debug_pub.add('l_qte_line_rec.invoice_to_party_site_id = '|| l_qte_line_rec.invoice_to_party_site_id,1,'N');
2965: aso_debug_pub.add('l_qte_line_rec.invoice_to_cust_party_id = ' || l_qte_line_rec.invoice_to_cust_party_id,1,'N');
2966: aso_debug_pub.add('l_qte_line_rec.invoice_to_party_id = ' || l_qte_line_rec.invoice_to_party_id,1,'N');
2967: aso_debug_pub.add('l_qte_line_rec.End_Customer_cust_account_id = '|| l_qte_line_rec.End_Customer_cust_account_id,1,'N');
2968: aso_debug_pub.add('l_qte_line_rec.End_Customer_party_site_id = '|| l_qte_line_rec.End_Customer_party_site_id,1,'N');
2969: aso_debug_pub.add('l_qte_line_rec.End_Customer_cust_party_id = ' || l_qte_line_rec.End_Customer_cust_party_id,1,'N');
2970: aso_debug_pub.add('l_qte_line_rec.End_Customer_party_id = ' || l_qte_line_rec.End_Customer_party_id,1,'N');
2971: aso_debug_pub.add('l_line_shipment_tbl(1).shipment_id = ' || l_line_shipment_tbl(1).shipment_id,1,'N');
2972: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_cust_account_id = '|| l_line_shipment_tbl(1).ship_to_cust_account_id,1,'N');

Line 2969: aso_debug_pub.add('l_qte_line_rec.End_Customer_cust_party_id = ' || l_qte_line_rec.End_Customer_cust_party_id,1,'N');

2965: aso_debug_pub.add('l_qte_line_rec.invoice_to_cust_party_id = ' || l_qte_line_rec.invoice_to_cust_party_id,1,'N');
2966: aso_debug_pub.add('l_qte_line_rec.invoice_to_party_id = ' || l_qte_line_rec.invoice_to_party_id,1,'N');
2967: aso_debug_pub.add('l_qte_line_rec.End_Customer_cust_account_id = '|| l_qte_line_rec.End_Customer_cust_account_id,1,'N');
2968: aso_debug_pub.add('l_qte_line_rec.End_Customer_party_site_id = '|| l_qte_line_rec.End_Customer_party_site_id,1,'N');
2969: aso_debug_pub.add('l_qte_line_rec.End_Customer_cust_party_id = ' || l_qte_line_rec.End_Customer_cust_party_id,1,'N');
2970: aso_debug_pub.add('l_qte_line_rec.End_Customer_party_id = ' || l_qte_line_rec.End_Customer_party_id,1,'N');
2971: aso_debug_pub.add('l_line_shipment_tbl(1).shipment_id = ' || l_line_shipment_tbl(1).shipment_id,1,'N');
2972: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_cust_account_id = '|| l_line_shipment_tbl(1).ship_to_cust_account_id,1,'N');
2973: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_cust_party_id = '|| l_line_shipment_tbl(1).ship_to_cust_party_id,1,'N');

Line 2970: aso_debug_pub.add('l_qte_line_rec.End_Customer_party_id = ' || l_qte_line_rec.End_Customer_party_id,1,'N');

2966: aso_debug_pub.add('l_qte_line_rec.invoice_to_party_id = ' || l_qte_line_rec.invoice_to_party_id,1,'N');
2967: aso_debug_pub.add('l_qte_line_rec.End_Customer_cust_account_id = '|| l_qte_line_rec.End_Customer_cust_account_id,1,'N');
2968: aso_debug_pub.add('l_qte_line_rec.End_Customer_party_site_id = '|| l_qte_line_rec.End_Customer_party_site_id,1,'N');
2969: aso_debug_pub.add('l_qte_line_rec.End_Customer_cust_party_id = ' || l_qte_line_rec.End_Customer_cust_party_id,1,'N');
2970: aso_debug_pub.add('l_qte_line_rec.End_Customer_party_id = ' || l_qte_line_rec.End_Customer_party_id,1,'N');
2971: aso_debug_pub.add('l_line_shipment_tbl(1).shipment_id = ' || l_line_shipment_tbl(1).shipment_id,1,'N');
2972: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_cust_account_id = '|| l_line_shipment_tbl(1).ship_to_cust_account_id,1,'N');
2973: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_cust_party_id = '|| l_line_shipment_tbl(1).ship_to_cust_party_id,1,'N');
2974: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_party_id = '|| l_line_shipment_tbl(1).ship_to_party_id,1,'N');

Line 2971: aso_debug_pub.add('l_line_shipment_tbl(1).shipment_id = ' || l_line_shipment_tbl(1).shipment_id,1,'N');

2967: aso_debug_pub.add('l_qte_line_rec.End_Customer_cust_account_id = '|| l_qte_line_rec.End_Customer_cust_account_id,1,'N');
2968: aso_debug_pub.add('l_qte_line_rec.End_Customer_party_site_id = '|| l_qte_line_rec.End_Customer_party_site_id,1,'N');
2969: aso_debug_pub.add('l_qte_line_rec.End_Customer_cust_party_id = ' || l_qte_line_rec.End_Customer_cust_party_id,1,'N');
2970: aso_debug_pub.add('l_qte_line_rec.End_Customer_party_id = ' || l_qte_line_rec.End_Customer_party_id,1,'N');
2971: aso_debug_pub.add('l_line_shipment_tbl(1).shipment_id = ' || l_line_shipment_tbl(1).shipment_id,1,'N');
2972: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_cust_account_id = '|| l_line_shipment_tbl(1).ship_to_cust_account_id,1,'N');
2973: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_cust_party_id = '|| l_line_shipment_tbl(1).ship_to_cust_party_id,1,'N');
2974: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_party_id = '|| l_line_shipment_tbl(1).ship_to_party_id,1,'N');
2975: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_party_site_id = '|| l_line_shipment_tbl(1).ship_to_party_site_id,1,'N');

Line 2972: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_cust_account_id = '|| l_line_shipment_tbl(1).ship_to_cust_account_id,1,'N');

2968: aso_debug_pub.add('l_qte_line_rec.End_Customer_party_site_id = '|| l_qte_line_rec.End_Customer_party_site_id,1,'N');
2969: aso_debug_pub.add('l_qte_line_rec.End_Customer_cust_party_id = ' || l_qte_line_rec.End_Customer_cust_party_id,1,'N');
2970: aso_debug_pub.add('l_qte_line_rec.End_Customer_party_id = ' || l_qte_line_rec.End_Customer_party_id,1,'N');
2971: aso_debug_pub.add('l_line_shipment_tbl(1).shipment_id = ' || l_line_shipment_tbl(1).shipment_id,1,'N');
2972: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_cust_account_id = '|| l_line_shipment_tbl(1).ship_to_cust_account_id,1,'N');
2973: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_cust_party_id = '|| l_line_shipment_tbl(1).ship_to_cust_party_id,1,'N');
2974: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_party_id = '|| l_line_shipment_tbl(1).ship_to_party_id,1,'N');
2975: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_party_site_id = '|| l_line_shipment_tbl(1).ship_to_party_site_id,1,'N');
2976: end if;

Line 2973: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_cust_party_id = '|| l_line_shipment_tbl(1).ship_to_cust_party_id,1,'N');

2969: aso_debug_pub.add('l_qte_line_rec.End_Customer_cust_party_id = ' || l_qte_line_rec.End_Customer_cust_party_id,1,'N');
2970: aso_debug_pub.add('l_qte_line_rec.End_Customer_party_id = ' || l_qte_line_rec.End_Customer_party_id,1,'N');
2971: aso_debug_pub.add('l_line_shipment_tbl(1).shipment_id = ' || l_line_shipment_tbl(1).shipment_id,1,'N');
2972: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_cust_account_id = '|| l_line_shipment_tbl(1).ship_to_cust_account_id,1,'N');
2973: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_cust_party_id = '|| l_line_shipment_tbl(1).ship_to_cust_party_id,1,'N');
2974: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_party_id = '|| l_line_shipment_tbl(1).ship_to_party_id,1,'N');
2975: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_party_site_id = '|| l_line_shipment_tbl(1).ship_to_party_site_id,1,'N');
2976: end if;
2977:

Line 2974: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_party_id = '|| l_line_shipment_tbl(1).ship_to_party_id,1,'N');

2970: aso_debug_pub.add('l_qte_line_rec.End_Customer_party_id = ' || l_qte_line_rec.End_Customer_party_id,1,'N');
2971: aso_debug_pub.add('l_line_shipment_tbl(1).shipment_id = ' || l_line_shipment_tbl(1).shipment_id,1,'N');
2972: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_cust_account_id = '|| l_line_shipment_tbl(1).ship_to_cust_account_id,1,'N');
2973: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_cust_party_id = '|| l_line_shipment_tbl(1).ship_to_cust_party_id,1,'N');
2974: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_party_id = '|| l_line_shipment_tbl(1).ship_to_party_id,1,'N');
2975: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_party_site_id = '|| l_line_shipment_tbl(1).ship_to_party_site_id,1,'N');
2976: end if;
2977:
2978:

Line 2975: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_party_site_id = '|| l_line_shipment_tbl(1).ship_to_party_site_id,1,'N');

2971: aso_debug_pub.add('l_line_shipment_tbl(1).shipment_id = ' || l_line_shipment_tbl(1).shipment_id,1,'N');
2972: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_cust_account_id = '|| l_line_shipment_tbl(1).ship_to_cust_account_id,1,'N');
2973: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_cust_party_id = '|| l_line_shipment_tbl(1).ship_to_cust_party_id,1,'N');
2974: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_party_id = '|| l_line_shipment_tbl(1).ship_to_party_id,1,'N');
2975: aso_debug_pub.add('l_line_shipment_tbl(1).ship_to_party_site_id = '|| l_line_shipment_tbl(1).ship_to_party_site_id,1,'N');
2976: end if;
2977:
2978:
2979: IF l_qte_line_rec.invoice_to_cust_account_id IS NULL THEN

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

2987: x_return_status => x_return_status,
2988: x_msg_count => x_msg_count,
2989: x_msg_data => x_msg_data);
2990:
2991: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2992: aso_debug_pub.add('Assign_Customer_Accounts 3: x_return_status: '||x_return_status, 1, 'N');
2993: aso_debug_pub.add('line invoice to customer party = ' ||
2994: l_qte_line_rec.invoice_to_cust_party_id,1,'N');
2995:

Line 2992: aso_debug_pub.add('Assign_Customer_Accounts 3: x_return_status: '||x_return_status, 1, 'N');

2988: x_msg_count => x_msg_count,
2989: x_msg_data => x_msg_data);
2990:
2991: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2992: aso_debug_pub.add('Assign_Customer_Accounts 3: x_return_status: '||x_return_status, 1, 'N');
2993: aso_debug_pub.add('line invoice to customer party = ' ||
2994: l_qte_line_rec.invoice_to_cust_party_id,1,'N');
2995:
2996: aso_debug_pub.add('line invoice to customer account = ' ||

Line 2993: aso_debug_pub.add('line invoice to customer party = ' ||

2989: x_msg_data => x_msg_data);
2990:
2991: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2992: aso_debug_pub.add('Assign_Customer_Accounts 3: x_return_status: '||x_return_status, 1, 'N');
2993: aso_debug_pub.add('line invoice to customer party = ' ||
2994: l_qte_line_rec.invoice_to_cust_party_id,1,'N');
2995:
2996: aso_debug_pub.add('line invoice to customer account = ' ||
2997: l_account_id,1,'N');

Line 2996: aso_debug_pub.add('line invoice to customer account = ' ||

2992: aso_debug_pub.add('Assign_Customer_Accounts 3: x_return_status: '||x_return_status, 1, 'N');
2993: aso_debug_pub.add('line invoice to customer party = ' ||
2994: l_qte_line_rec.invoice_to_cust_party_id,1,'N');
2995:
2996: aso_debug_pub.add('line invoice to customer account = ' ||
2997: l_account_id,1,'N');
2998: END IF;
2999:
3000: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

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

3034: x_return_status => x_return_status,
3035: x_msg_count => x_msg_count,
3036: x_msg_data => x_msg_data);
3037:
3038: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3039: aso_debug_pub.add('Assign_Customer_Accounts 3: x_return_status: '||x_return_status, 1, 'N');
3040: aso_debug_pub.add('line End_Customer customer party = ' ||
3041: l_qte_line_rec.End_Customer_cust_party_id,1,'N');
3042:

Line 3039: aso_debug_pub.add('Assign_Customer_Accounts 3: x_return_status: '||x_return_status, 1, 'N');

3035: x_msg_count => x_msg_count,
3036: x_msg_data => x_msg_data);
3037:
3038: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3039: aso_debug_pub.add('Assign_Customer_Accounts 3: x_return_status: '||x_return_status, 1, 'N');
3040: aso_debug_pub.add('line End_Customer customer party = ' ||
3041: l_qte_line_rec.End_Customer_cust_party_id,1,'N');
3042:
3043: aso_debug_pub.add('line End_Customer customer account = ' ||

Line 3040: aso_debug_pub.add('line End_Customer customer party = ' ||

3036: x_msg_data => x_msg_data);
3037:
3038: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3039: aso_debug_pub.add('Assign_Customer_Accounts 3: x_return_status: '||x_return_status, 1, 'N');
3040: aso_debug_pub.add('line End_Customer customer party = ' ||
3041: l_qte_line_rec.End_Customer_cust_party_id,1,'N');
3042:
3043: aso_debug_pub.add('line End_Customer customer account = ' ||
3044: l_account_id,1,'N');

Line 3043: aso_debug_pub.add('line End_Customer customer account = ' ||

3039: aso_debug_pub.add('Assign_Customer_Accounts 3: x_return_status: '||x_return_status, 1, 'N');
3040: aso_debug_pub.add('line End_Customer customer party = ' ||
3041: l_qte_line_rec.End_Customer_cust_party_id,1,'N');
3042:
3043: aso_debug_pub.add('line End_Customer customer account = ' ||
3044: l_account_id,1,'N');
3045: END IF;
3046:
3047: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

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

3081: x_return_status => x_return_status,
3082: x_msg_count => x_msg_count,
3083: x_msg_data => x_msg_data);
3084:
3085: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3086: aso_debug_pub.add('Assign_Customer_Accounts 4: x_return_status: '||x_return_status, 1, 'N');
3087: aso_debug_pub.add('line ship to customer party = ' ||
3088: Line_Acct.ship_to_cust_party_id,1,'N');
3089:

Line 3086: aso_debug_pub.add('Assign_Customer_Accounts 4: x_return_status: '||x_return_status, 1, 'N');

3082: x_msg_count => x_msg_count,
3083: x_msg_data => x_msg_data);
3084:
3085: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3086: aso_debug_pub.add('Assign_Customer_Accounts 4: x_return_status: '||x_return_status, 1, 'N');
3087: aso_debug_pub.add('line ship to customer party = ' ||
3088: Line_Acct.ship_to_cust_party_id,1,'N');
3089:
3090: aso_debug_pub.add('line ship to customer account = ' ||

Line 3087: aso_debug_pub.add('line ship to customer party = ' ||

3083: x_msg_data => x_msg_data);
3084:
3085: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3086: aso_debug_pub.add('Assign_Customer_Accounts 4: x_return_status: '||x_return_status, 1, 'N');
3087: aso_debug_pub.add('line ship to customer party = ' ||
3088: Line_Acct.ship_to_cust_party_id,1,'N');
3089:
3090: aso_debug_pub.add('line ship to customer account = ' ||
3091: l_account_id,1,'N');

Line 3090: aso_debug_pub.add('line ship to customer account = ' ||

3086: aso_debug_pub.add('Assign_Customer_Accounts 4: x_return_status: '||x_return_status, 1, 'N');
3087: aso_debug_pub.add('line ship to customer party = ' ||
3088: Line_Acct.ship_to_cust_party_id,1,'N');
3089:
3090: aso_debug_pub.add('line ship to customer account = ' ||
3091: l_account_id,1,'N');
3092: END IF;
3093:
3094: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

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

3125: x_return_status => x_return_status,
3126: x_msg_count => x_msg_count,
3127: x_msg_data => x_msg_data);
3128:
3129: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3130: aso_debug_pub.add('after check line account info '||x_return_status, 1, 'N
3131: ');
3132: END IF;
3133: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

Line 3130: aso_debug_pub.add('after check line account info '||x_return_status, 1, 'N

3126: x_msg_count => x_msg_count,
3127: x_msg_data => x_msg_data);
3128:
3129: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3130: aso_debug_pub.add('after check line account info '||x_return_status, 1, 'N
3131: ');
3132: END IF;
3133: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3134: RAISE FND_API.G_EXC_ERROR;

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

3141:
3142:
3143:
3144:
3145: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3146: aso_debug_pub.add('Assign_Customer_Accounts: End ', 1, 'N');
3147: END IF;
3148:
3149: FND_MSG_PUB.Count_And_Get

Line 3146: aso_debug_pub.add('Assign_Customer_Accounts: End ', 1, 'N');

3142:
3143:
3144:
3145: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3146: aso_debug_pub.add('Assign_Customer_Accounts: End ', 1, 'N');
3147: END IF;
3148:
3149: FND_MSG_PUB.Count_And_Get
3150: ( p_count => x_msg_count,

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

3231: OPEN C_Get_Party_From_Acct(p_cust_account_id);
3232: FETCH C_Get_Party_From_Acct INTO l_inv_cust_id;
3233: CLOSE C_Get_Party_From_Acct;
3234:
3235: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3236: aso_debug_pub.add('Check_Hdr_Acct: l_inv_cust_id: '|| l_inv_cust_id, 1, 'N');
3237: END IF;
3238: IF l_inv_cust_id <> p_cust_party_id THEN
3239: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3236: aso_debug_pub.add('Check_Hdr_Acct: l_inv_cust_id: '|| l_inv_cust_id, 1, 'N');

3232: FETCH C_Get_Party_From_Acct INTO l_inv_cust_id;
3233: CLOSE C_Get_Party_From_Acct;
3234:
3235: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3236: aso_debug_pub.add('Check_Hdr_Acct: l_inv_cust_id: '|| l_inv_cust_id, 1, 'N');
3237: END IF;
3238: IF l_inv_cust_id <> p_cust_party_id THEN
3239: x_return_status := FND_API.G_RET_STS_ERROR;
3240: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

3247: END IF;
3248:
3249: END IF;
3250:
3251: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3252: aso_debug_pub.add('Check_Hdr_Acct: p_cust_party_id:1: '|| p_cust_party_id, 1, 'N');
3253: END IF;
3254:
3255: ELSE -- inv_to_cust_acct_id is null

Line 3252: aso_debug_pub.add('Check_Hdr_Acct: p_cust_party_id:1: '|| p_cust_party_id, 1, 'N');

3248:
3249: END IF;
3250:
3251: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3252: aso_debug_pub.add('Check_Hdr_Acct: p_cust_party_id:1: '|| p_cust_party_id, 1, 'N');
3253: END IF;
3254:
3255: ELSE -- inv_to_cust_acct_id is null
3256:

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

3261:
3262: p_cust_account_id := p_hdr_cust_acct_id;
3263: p_cust_party_id := p_hdr_party_id;
3264:
3265: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3266: aso_debug_pub.add('Check_Hdr_Acct: p_cust_account_id: '|| p_cust_account_id, 1, 'N');
3267: aso_debug_pub.add('Check_Hdr_Acct: p_cust_party_id:2: '|| p_cust_party_id, 1, 'N');
3268: END IF;
3269:

Line 3266: aso_debug_pub.add('Check_Hdr_Acct: p_cust_account_id: '|| p_cust_account_id, 1, 'N');

3262: p_cust_account_id := p_hdr_cust_acct_id;
3263: p_cust_party_id := p_hdr_party_id;
3264:
3265: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3266: aso_debug_pub.add('Check_Hdr_Acct: p_cust_account_id: '|| p_cust_account_id, 1, 'N');
3267: aso_debug_pub.add('Check_Hdr_Acct: p_cust_party_id:2: '|| p_cust_party_id, 1, 'N');
3268: END IF;
3269:
3270: END IF;

Line 3267: aso_debug_pub.add('Check_Hdr_Acct: p_cust_party_id:2: '|| p_cust_party_id, 1, 'N');

3263: p_cust_party_id := p_hdr_party_id;
3264:
3265: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3266: aso_debug_pub.add('Check_Hdr_Acct: p_cust_account_id: '|| p_cust_account_id, 1, 'N');
3267: aso_debug_pub.add('Check_Hdr_Acct: p_cust_party_id:2: '|| p_cust_party_id, 1, 'N');
3268: END IF;
3269:
3270: END IF;
3271: END IF;

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

3358:
3359: -- Initialize API return status to success
3360: x_return_status := FND_API.G_RET_STS_SUCCESS;
3361:
3362: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3363: aso_debug_pub.add('Check_Customer_Accounts - Begin', 1, 'Y');
3364: END IF;
3365:
3366: OPEN C_Validate_Quote (p_qte_header_id);

Line 3363: aso_debug_pub.add('Check_Customer_Accounts - Begin', 1, 'Y');

3359: -- Initialize API return status to success
3360: x_return_status := FND_API.G_RET_STS_SUCCESS;
3361:
3362: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3363: aso_debug_pub.add('Check_Customer_Accounts - Begin', 1, 'Y');
3364: END IF;
3365:
3366: OPEN C_Validate_Quote (p_qte_header_id);
3367: FETCH C_Validate_Quote into l_dummy;

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

3372: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_id), FALSE);
3373: FND_MSG_PUB.ADD;
3374: END IF;
3375:
3376: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3377: aso_debug_pub.add('Check_Customer_Accounts - Invalid qte_hdr_id', 1, 'Y');
3378: END IF;
3379:
3380: CLOSE C_Validate_Quote;

Line 3377: aso_debug_pub.add('Check_Customer_Accounts - Invalid qte_hdr_id', 1, 'Y');

3373: FND_MSG_PUB.ADD;
3374: END IF;
3375:
3376: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3377: aso_debug_pub.add('Check_Customer_Accounts - Invalid qte_hdr_id', 1, 'Y');
3378: END IF;
3379:
3380: CLOSE C_Validate_Quote;
3381: x_return_status := FND_API.G_RET_STS_ERROR;

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

3382: RAISE FND_API.G_EXC_ERROR;
3383: END IF;
3384: CLOSE C_Validate_Quote;
3385:
3386: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3387: aso_debug_pub.add('Check_Customer_Accounts - After qte_hdr_id check', 1, 'Y');
3388: aso_debug_pub.add('Check_Customer_Accounts - l_create_acct_prof: '||l_create_acct_prof, 1, 'N');
3389: END IF;
3390:

Line 3387: aso_debug_pub.add('Check_Customer_Accounts - After qte_hdr_id check', 1, 'Y');

3383: END IF;
3384: CLOSE C_Validate_Quote;
3385:
3386: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3387: aso_debug_pub.add('Check_Customer_Accounts - After qte_hdr_id check', 1, 'Y');
3388: aso_debug_pub.add('Check_Customer_Accounts - l_create_acct_prof: '||l_create_acct_prof, 1, 'N');
3389: END IF;
3390:
3391: l_party := NULL;

Line 3388: aso_debug_pub.add('Check_Customer_Accounts - l_create_acct_prof: '||l_create_acct_prof, 1, 'N');

3384: CLOSE C_Validate_Quote;
3385:
3386: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3387: aso_debug_pub.add('Check_Customer_Accounts - After qte_hdr_id check', 1, 'Y');
3388: aso_debug_pub.add('Check_Customer_Accounts - l_create_acct_prof: '||l_create_acct_prof, 1, 'N');
3389: END IF;
3390:
3391: l_party := NULL;
3392: l_cust_acct := NULL;

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

3396: OPEN C_Get_Hdr_CustAcct(p_qte_header_id);
3397: FETCH C_Get_Hdr_CustAcct INTO l_party;
3398: CLOSE C_Get_Hdr_CustAcct;
3399:
3400: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3401: aso_debug_pub.add('Check_Customer_Accounts:hdr_CustAcct - l_party: '||l_party, 1, 'N');
3402: END IF;
3403:
3404: IF l_party IS NOT NULL AND l_party <> FND_API.G_MISS_NUM THEN

Line 3401: aso_debug_pub.add('Check_Customer_Accounts:hdr_CustAcct - l_party: '||l_party, 1, 'N');

3397: FETCH C_Get_Hdr_CustAcct INTO l_party;
3398: CLOSE C_Get_Hdr_CustAcct;
3399:
3400: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3401: aso_debug_pub.add('Check_Customer_Accounts:hdr_CustAcct - l_party: '||l_party, 1, 'N');
3402: END IF;
3403:
3404: IF l_party IS NOT NULL AND l_party <> FND_API.G_MISS_NUM THEN
3405:

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

3406: OPEN C_Chk_Party_Acct (l_party);
3407: FETCH C_Chk_Party_Acct INTO l_cust_acct;
3408: CLOSE C_Chk_Party_Acct;
3409:
3410: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3411: aso_debug_pub.add('Check_Customer_Accounts:hdr_CustAcct - l_cust_acct: '||l_cust_acct, 1, 'N');
3412: END IF;
3413:
3414: IF l_cust_acct IS NULL OR l_cust_acct = FND_API.G_MISS_NUM THEN

Line 3411: aso_debug_pub.add('Check_Customer_Accounts:hdr_CustAcct - l_cust_acct: '||l_cust_acct, 1, 'N');

3407: FETCH C_Chk_Party_Acct INTO l_cust_acct;
3408: CLOSE C_Chk_Party_Acct;
3409:
3410: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3411: aso_debug_pub.add('Check_Customer_Accounts:hdr_CustAcct - l_cust_acct: '||l_cust_acct, 1, 'N');
3412: END IF;
3413:
3414: IF l_cust_acct IS NULL OR l_cust_acct = FND_API.G_MISS_NUM THEN
3415: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

3428: OPEN C_Get_Hdr_InvCustAcct(p_qte_header_id);
3429: FETCH C_Get_Hdr_InvCustAcct INTO l_party;
3430: CLOSE C_Get_Hdr_InvCustAcct;
3431:
3432: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3433: aso_debug_pub.add('Check_Customer_Accounts:hdr_InvCustAcct - l_party: '||l_party, 1, 'N');
3434: END IF;
3435:
3436: IF l_party IS NOT NULL AND l_party <> FND_API.G_MISS_NUM THEN

Line 3433: aso_debug_pub.add('Check_Customer_Accounts:hdr_InvCustAcct - l_party: '||l_party, 1, 'N');

3429: FETCH C_Get_Hdr_InvCustAcct INTO l_party;
3430: CLOSE C_Get_Hdr_InvCustAcct;
3431:
3432: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3433: aso_debug_pub.add('Check_Customer_Accounts:hdr_InvCustAcct - l_party: '||l_party, 1, 'N');
3434: END IF;
3435:
3436: IF l_party IS NOT NULL AND l_party <> FND_API.G_MISS_NUM THEN
3437:

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

3438: OPEN C_Chk_Party_Acct (l_party);
3439: FETCH C_Chk_Party_Acct INTO l_cust_acct;
3440: CLOSE C_Chk_Party_Acct;
3441:
3442: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3443: aso_debug_pub.add('Check_Customer_Accounts:hdr_InvCustAcct - l_cust_acct: '||l_cust_acct, 1, 'N');
3444: END IF;
3445:
3446: IF l_cust_acct IS NULL OR l_cust_acct = FND_API.G_MISS_NUM THEN

Line 3443: aso_debug_pub.add('Check_Customer_Accounts:hdr_InvCustAcct - l_cust_acct: '||l_cust_acct, 1, 'N');

3439: FETCH C_Chk_Party_Acct INTO l_cust_acct;
3440: CLOSE C_Chk_Party_Acct;
3441:
3442: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3443: aso_debug_pub.add('Check_Customer_Accounts:hdr_InvCustAcct - l_cust_acct: '||l_cust_acct, 1, 'N');
3444: END IF;
3445:
3446: IF l_cust_acct IS NULL OR l_cust_acct = FND_API.G_MISS_NUM THEN
3447: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

3460: OPEN C_Get_Hdr_EndCustAcct(p_qte_header_id);
3461: FETCH C_Get_Hdr_EndCustAcct INTO l_party;
3462: CLOSE C_Get_Hdr_EndCustAcct;
3463:
3464: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3465: aso_debug_pub.add('Check_Customer_Accounts:hdr_EndCustAcct - l_party: '||l_party, 1, 'N');
3466: END IF;
3467:
3468: IF l_party IS NOT NULL AND l_party <> FND_API.G_MISS_NUM THEN

Line 3465: aso_debug_pub.add('Check_Customer_Accounts:hdr_EndCustAcct - l_party: '||l_party, 1, 'N');

3461: FETCH C_Get_Hdr_EndCustAcct INTO l_party;
3462: CLOSE C_Get_Hdr_EndCustAcct;
3463:
3464: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3465: aso_debug_pub.add('Check_Customer_Accounts:hdr_EndCustAcct - l_party: '||l_party, 1, 'N');
3466: END IF;
3467:
3468: IF l_party IS NOT NULL AND l_party <> FND_API.G_MISS_NUM THEN
3469:

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

3470: OPEN C_Chk_Party_Acct (l_party);
3471: FETCH C_Chk_Party_Acct INTO l_cust_acct;
3472: CLOSE C_Chk_Party_Acct;
3473:
3474: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3475: aso_debug_pub.add('Check_Customer_Accounts:hdr_EndCustAcct - l_cust_acct: '||l_cust_acct, 1, 'N');
3476: END IF;
3477:
3478: IF l_cust_acct IS NULL OR l_cust_acct = FND_API.G_MISS_NUM THEN

Line 3475: aso_debug_pub.add('Check_Customer_Accounts:hdr_EndCustAcct - l_cust_acct: '||l_cust_acct, 1, 'N');

3471: FETCH C_Chk_Party_Acct INTO l_cust_acct;
3472: CLOSE C_Chk_Party_Acct;
3473:
3474: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3475: aso_debug_pub.add('Check_Customer_Accounts:hdr_EndCustAcct - l_cust_acct: '||l_cust_acct, 1, 'N');
3476: END IF;
3477:
3478: IF l_cust_acct IS NULL OR l_cust_acct = FND_API.G_MISS_NUM THEN
3479: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

3492: l_party := NULL;
3493: l_cust_acct := NULL;
3494: l_party := Line_Acct.invoice_to_cust_party_id;
3495:
3496: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3497: aso_debug_pub.add('Check_Customer_Accounts:line_Acct - l_party: '||l_party, 1, 'N');
3498: END IF;
3499:
3500: IF l_party IS NOT NULL AND l_party <> FND_API.G_MISS_NUM THEN

Line 3497: aso_debug_pub.add('Check_Customer_Accounts:line_Acct - l_party: '||l_party, 1, 'N');

3493: l_cust_acct := NULL;
3494: l_party := Line_Acct.invoice_to_cust_party_id;
3495:
3496: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3497: aso_debug_pub.add('Check_Customer_Accounts:line_Acct - l_party: '||l_party, 1, 'N');
3498: END IF;
3499:
3500: IF l_party IS NOT NULL AND l_party <> FND_API.G_MISS_NUM THEN
3501:

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

3502: OPEN C_Chk_Party_Acct (l_party);
3503: FETCH C_Chk_Party_Acct INTO l_cust_acct;
3504: CLOSE C_Chk_Party_Acct;
3505:
3506: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3507: aso_debug_pub.add('Check_Customer_Accounts:lin_Acct - l_cust_acct: '||l_cust_acct, 1, 'N');
3508: END IF;
3509:
3510: IF l_cust_acct IS NULL OR l_cust_acct = FND_API.G_MISS_NUM THEN

Line 3507: aso_debug_pub.add('Check_Customer_Accounts:lin_Acct - l_cust_acct: '||l_cust_acct, 1, 'N');

3503: FETCH C_Chk_Party_Acct INTO l_cust_acct;
3504: CLOSE C_Chk_Party_Acct;
3505:
3506: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3507: aso_debug_pub.add('Check_Customer_Accounts:lin_Acct - l_cust_acct: '||l_cust_acct, 1, 'N');
3508: END IF;
3509:
3510: IF l_cust_acct IS NULL OR l_cust_acct = FND_API.G_MISS_NUM THEN
3511: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

3526: l_party := NULL;
3527: l_cust_acct := NULL;
3528: l_party := Line_EndCustAcct.End_Customer_cust_party_id;
3529:
3530: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3531: aso_debug_pub.add('Check_Customer_Accounts:line_EndCustAcct - l_party: '||l_party, 1, 'N');
3532: END IF;
3533:
3534: IF l_party IS NOT NULL AND l_party <> FND_API.G_MISS_NUM THEN

Line 3531: aso_debug_pub.add('Check_Customer_Accounts:line_EndCustAcct - l_party: '||l_party, 1, 'N');

3527: l_cust_acct := NULL;
3528: l_party := Line_EndCustAcct.End_Customer_cust_party_id;
3529:
3530: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3531: aso_debug_pub.add('Check_Customer_Accounts:line_EndCustAcct - l_party: '||l_party, 1, 'N');
3532: END IF;
3533:
3534: IF l_party IS NOT NULL AND l_party <> FND_API.G_MISS_NUM THEN
3535:

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

3536: OPEN C_Chk_Party_Acct (l_party);
3537: FETCH C_Chk_Party_Acct INTO l_cust_acct;
3538: CLOSE C_Chk_Party_Acct;
3539:
3540: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3541: aso_debug_pub.add('Check_Customer_Accounts:lin_EndCustAcct - l_cust_acct: '||l_cust_acct, 1, 'N');
3542: END IF;
3543:
3544: IF l_cust_acct IS NULL OR l_cust_acct = FND_API.G_MISS_NUM THEN

Line 3541: aso_debug_pub.add('Check_Customer_Accounts:lin_EndCustAcct - l_cust_acct: '||l_cust_acct, 1, 'N');

3537: FETCH C_Chk_Party_Acct INTO l_cust_acct;
3538: CLOSE C_Chk_Party_Acct;
3539:
3540: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3541: aso_debug_pub.add('Check_Customer_Accounts:lin_EndCustAcct - l_cust_acct: '||l_cust_acct, 1, 'N');
3542: END IF;
3543:
3544: IF l_cust_acct IS NULL OR l_cust_acct = FND_API.G_MISS_NUM THEN
3545: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

3560: l_party := NULL;
3561: l_cust_acct := NULL;
3562: l_party := Ship_Acct.ship_to_cust_party_id;
3563:
3564: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3565: aso_debug_pub.add('Check_Customer_Accounts:shp_Acct - l_party: '||l_party, 1, 'N');
3566: END IF;
3567:
3568: IF l_party IS NOT NULL AND l_party <> FND_API.G_MISS_NUM THEN

Line 3565: aso_debug_pub.add('Check_Customer_Accounts:shp_Acct - l_party: '||l_party, 1, 'N');

3561: l_cust_acct := NULL;
3562: l_party := Ship_Acct.ship_to_cust_party_id;
3563:
3564: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3565: aso_debug_pub.add('Check_Customer_Accounts:shp_Acct - l_party: '||l_party, 1, 'N');
3566: END IF;
3567:
3568: IF l_party IS NOT NULL AND l_party <> FND_API.G_MISS_NUM THEN
3569:

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

3570: OPEN C_Chk_Party_Acct (l_party);
3571: FETCH C_Chk_Party_Acct INTO l_cust_acct;
3572: CLOSE C_Chk_Party_Acct;
3573:
3574: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3575: aso_debug_pub.add('Check_Customer_Accounts:shp_Acct - l_cust_acct: '||l_cust_acct, 1, 'N');
3576: END IF;
3577:
3578: IF l_cust_acct IS NULL OR l_cust_acct = FND_API.G_MISS_NUM THEN

Line 3575: aso_debug_pub.add('Check_Customer_Accounts:shp_Acct - l_cust_acct: '||l_cust_acct, 1, 'N');

3571: FETCH C_Chk_Party_Acct INTO l_cust_acct;
3572: CLOSE C_Chk_Party_Acct;
3573:
3574: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3575: aso_debug_pub.add('Check_Customer_Accounts:shp_Acct - l_cust_acct: '||l_cust_acct, 1, 'N');
3576: END IF;
3577:
3578: IF l_cust_acct IS NULL OR l_cust_acct = FND_API.G_MISS_NUM THEN
3579: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

3589: END LOOP;
3590:
3591: END IF; -- 'Place Order'
3592:
3593: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3594: aso_debug_pub.add('Check_Customer_Accounts: End ', 1, 'N');
3595: END IF;
3596:
3597: FND_MSG_PUB.Count_And_Get

Line 3594: aso_debug_pub.add('Check_Customer_Accounts: End ', 1, 'N');

3590:
3591: END IF; -- 'Place Order'
3592:
3593: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3594: aso_debug_pub.add('Check_Customer_Accounts: End ', 1, 'N');
3595: END IF;
3596:
3597: FND_MSG_PUB.Count_And_Get
3598: ( p_count => x_msg_count,