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

APPS.ASO_SHIPMENT_PVT dependencies on ASO_DEBUG_PUB

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

184:
185: open c_item_type_code;
186: fetch c_item_type_code into l_item_type_code;
187:
188: IF aso_debug_pub.g_debug_flag = 'Y' THEN
189: aso_debug_pub.add('Get_invoice_to_party_site_id: c_item_type_code: l_item_type_code: '||l_item_type_code);
190: END IF;
191:
192: IF c_item_type_code%FOUND and l_item_type_code = 'CFG' THEN

Line 189: aso_debug_pub.add('Get_invoice_to_party_site_id: c_item_type_code: l_item_type_code: '||l_item_type_code);

185: open c_item_type_code;
186: fetch c_item_type_code into l_item_type_code;
187:
188: IF aso_debug_pub.g_debug_flag = 'Y' THEN
189: aso_debug_pub.add('Get_invoice_to_party_site_id: c_item_type_code: l_item_type_code: '||l_item_type_code);
190: END IF;
191:
192: IF c_item_type_code%FOUND and l_item_type_code = 'CFG' THEN
193:

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

195:
196: open c_root_model_line_id;
197: fetch c_root_model_line_id into l_model_quote_line_id;
198:
199: IF aso_debug_pub.g_debug_flag = 'Y' THEN
200: aso_debug_pub.add('Get_invoice_to_party_site_id: c_root_model_line_id: l_model_quote_line_id: ' ||l_model_quote_line_id);
201: END IF;
202:
203: IF c_root_model_line_id%FOUND and l_model_quote_line_id is not null THEN

Line 200: aso_debug_pub.add('Get_invoice_to_party_site_id: c_root_model_line_id: l_model_quote_line_id: ' ||l_model_quote_line_id);

196: open c_root_model_line_id;
197: fetch c_root_model_line_id into l_model_quote_line_id;
198:
199: IF aso_debug_pub.g_debug_flag = 'Y' THEN
200: aso_debug_pub.add('Get_invoice_to_party_site_id: c_root_model_line_id: l_model_quote_line_id: ' ||l_model_quote_line_id);
201: END IF;
202:
203: IF c_root_model_line_id%FOUND and l_model_quote_line_id is not null THEN
204:

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

205: close c_root_model_line_id;
206:
207: l_inv_site_id := Get_invoice_to_party_site_id(p_qte_header_id, l_model_quote_line_id);
208:
209: IF aso_debug_pub.g_debug_flag = 'Y' THEN
210: aso_debug_pub.add('Get_invoice_to_party_site_id: Model l_inv_site_id: '||l_inv_site_id);
211: END IF;
212:
213: return l_inv_site_id;

Line 210: aso_debug_pub.add('Get_invoice_to_party_site_id: Model l_inv_site_id: '||l_inv_site_id);

206:
207: l_inv_site_id := Get_invoice_to_party_site_id(p_qte_header_id, l_model_quote_line_id);
208:
209: IF aso_debug_pub.g_debug_flag = 'Y' THEN
210: aso_debug_pub.add('Get_invoice_to_party_site_id: Model l_inv_site_id: '||l_inv_site_id);
211: END IF;
212:
213: return l_inv_site_id;
214:

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

297: l_item_type_code VARCHAR2(30);
298:
299: BEGIN
300:
301: IF aso_debug_pub.g_debug_flag = 'Y' THEN
302: aso_debug_pub.add('ASO_SHIPMENT_PVT: Get_cust_to_party_site_id: Begin');
303: END IF;
304:
305: OPEN c_inv_site1;

Line 302: aso_debug_pub.add('ASO_SHIPMENT_PVT: Get_cust_to_party_site_id: Begin');

298:
299: BEGIN
300:
301: IF aso_debug_pub.g_debug_flag = 'Y' THEN
302: aso_debug_pub.add('ASO_SHIPMENT_PVT: Get_cust_to_party_site_id: Begin');
303: END IF;
304:
305: OPEN c_inv_site1;
306: FETCH c_inv_site1 INTO l_inv_site_id;

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

357: return l_bill_site_use_id;
358:
359: ELSE
360:
361: IF aso_debug_pub.g_debug_flag = 'Y' THEN
362: aso_debug_pub.add('Get_cust_to_party_site_id: Else c_inv_site1');
363: END IF;
364:
365: CLOSE c_inv_site1;

Line 362: aso_debug_pub.add('Get_cust_to_party_site_id: Else c_inv_site1');

358:
359: ELSE
360:
361: IF aso_debug_pub.g_debug_flag = 'Y' THEN
362: aso_debug_pub.add('Get_cust_to_party_site_id: Else c_inv_site1');
363: END IF;
364:
365: CLOSE c_inv_site1;
366:

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

366:
367: open c_item_type_code;
368: fetch c_item_type_code into l_item_type_code;
369:
370: IF aso_debug_pub.g_debug_flag = 'Y' THEN
371: aso_debug_pub.add('Get_cust_to_party_site_id: c_item_type_code: l_item_type_code: '||l_item_type_code);
372: END IF;
373:
374: IF c_item_type_code%FOUND and l_item_type_code = 'CFG' THEN

Line 371: aso_debug_pub.add('Get_cust_to_party_site_id: c_item_type_code: l_item_type_code: '||l_item_type_code);

367: open c_item_type_code;
368: fetch c_item_type_code into l_item_type_code;
369:
370: IF aso_debug_pub.g_debug_flag = 'Y' THEN
371: aso_debug_pub.add('Get_cust_to_party_site_id: c_item_type_code: l_item_type_code: '||l_item_type_code);
372: END IF;
373:
374: IF c_item_type_code%FOUND and l_item_type_code = 'CFG' THEN
375:

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

377:
378: open c_root_model_line_id;
379: fetch c_root_model_line_id into l_model_quote_line_id;
380:
381: IF aso_debug_pub.g_debug_flag = 'Y' THEN
382: aso_debug_pub.add('Get_cust_to_party_site_id: c_root_model_line_id: l_model_quote_line_id: '||l_model_quote_line_id);
383: END IF;
384:
385: IF c_root_model_line_id%FOUND and l_model_quote_line_id is not null THEN

Line 382: aso_debug_pub.add('Get_cust_to_party_site_id: c_root_model_line_id: l_model_quote_line_id: '||l_model_quote_line_id);

378: open c_root_model_line_id;
379: fetch c_root_model_line_id into l_model_quote_line_id;
380:
381: IF aso_debug_pub.g_debug_flag = 'Y' THEN
382: aso_debug_pub.add('Get_cust_to_party_site_id: c_root_model_line_id: l_model_quote_line_id: '||l_model_quote_line_id);
383: END IF;
384:
385: IF c_root_model_line_id%FOUND and l_model_quote_line_id is not null THEN
386:

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

541: l_model_quote_line_id NUMBER;
542: l_model_shipment_id NUMBER;
543:
544: BEGIN
545: IF aso_debug_pub.g_debug_flag = 'Y' THEN
546: aso_debug_pub.add('ASO_SHIPMENT_PVT:p_qte_header_id ' || p_qte_header_id, 1, 'N');
547: aso_debug_pub.add('ASO_SHIPMENT_PVT:quote_line_id ' || p_qte_line_id, 1, 'N');
548: aso_debug_pub.add('ASO_SHIPMENT_PVT:shipment_id ' || p_shipment_id, 1, 'N');
549: END IF;

Line 546: aso_debug_pub.add('ASO_SHIPMENT_PVT:p_qte_header_id ' || p_qte_header_id, 1, 'N');

542: l_model_shipment_id NUMBER;
543:
544: BEGIN
545: IF aso_debug_pub.g_debug_flag = 'Y' THEN
546: aso_debug_pub.add('ASO_SHIPMENT_PVT:p_qte_header_id ' || p_qte_header_id, 1, 'N');
547: aso_debug_pub.add('ASO_SHIPMENT_PVT:quote_line_id ' || p_qte_line_id, 1, 'N');
548: aso_debug_pub.add('ASO_SHIPMENT_PVT:shipment_id ' || p_shipment_id, 1, 'N');
549: END IF;
550:

Line 547: aso_debug_pub.add('ASO_SHIPMENT_PVT:quote_line_id ' || p_qte_line_id, 1, 'N');

543:
544: BEGIN
545: IF aso_debug_pub.g_debug_flag = 'Y' THEN
546: aso_debug_pub.add('ASO_SHIPMENT_PVT:p_qte_header_id ' || p_qte_header_id, 1, 'N');
547: aso_debug_pub.add('ASO_SHIPMENT_PVT:quote_line_id ' || p_qte_line_id, 1, 'N');
548: aso_debug_pub.add('ASO_SHIPMENT_PVT:shipment_id ' || p_shipment_id, 1, 'N');
549: END IF;
550:
551: OPEN c_ship_site1;

Line 548: aso_debug_pub.add('ASO_SHIPMENT_PVT:shipment_id ' || p_shipment_id, 1, 'N');

544: BEGIN
545: IF aso_debug_pub.g_debug_flag = 'Y' THEN
546: aso_debug_pub.add('ASO_SHIPMENT_PVT:p_qte_header_id ' || p_qte_header_id, 1, 'N');
547: aso_debug_pub.add('ASO_SHIPMENT_PVT:quote_line_id ' || p_qte_line_id, 1, 'N');
548: aso_debug_pub.add('ASO_SHIPMENT_PVT:shipment_id ' || p_shipment_id, 1, 'N');
549: END IF;
550:
551: OPEN c_ship_site1;
552: FETCH c_ship_site1 INTO l_ship_site_id, l_ship_cust_acct_id;

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

550:
551: OPEN c_ship_site1;
552: FETCH c_ship_site1 INTO l_ship_site_id, l_ship_cust_acct_id;
553:
554: IF aso_debug_pub.g_debug_flag = 'Y' THEN
555: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_site1 l_ship_site_id ' || l_ship_site_id, 1, 'N');
556: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_site1 l_ship_cust_acct_id ' || l_ship_cust_acct_id, 1, 'N');
557: END IF;
558:

Line 555: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_site1 l_ship_site_id ' || l_ship_site_id, 1, 'N');

551: OPEN c_ship_site1;
552: FETCH c_ship_site1 INTO l_ship_site_id, l_ship_cust_acct_id;
553:
554: IF aso_debug_pub.g_debug_flag = 'Y' THEN
555: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_site1 l_ship_site_id ' || l_ship_site_id, 1, 'N');
556: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_site1 l_ship_cust_acct_id ' || l_ship_cust_acct_id, 1, 'N');
557: END IF;
558:
559: IF c_ship_site1%FOUND and l_ship_site_id IS NOT NULL and l_ship_site_id <> FND_API.G_MISS_NUM THEN

Line 556: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_site1 l_ship_cust_acct_id ' || l_ship_cust_acct_id, 1, 'N');

552: FETCH c_ship_site1 INTO l_ship_site_id, l_ship_cust_acct_id;
553:
554: IF aso_debug_pub.g_debug_flag = 'Y' THEN
555: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_site1 l_ship_site_id ' || l_ship_site_id, 1, 'N');
556: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_site1 l_ship_cust_acct_id ' || l_ship_cust_acct_id, 1, 'N');
557: END IF;
558:
559: IF c_ship_site1%FOUND and l_ship_site_id IS NOT NULL and l_ship_site_id <> FND_API.G_MISS_NUM THEN
560:

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

563: --Get the ship_to_cust_account if present
564: OPEN c_ship_cust_id;
565: FETCH c_ship_cust_id into l_cust_id;
566:
567: IF aso_debug_pub.g_debug_flag = 'Y' THEN
568: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_cust_id l_cust_id ' || l_cust_id, 1, 'N');
569: END IF;
570:
571: IF c_ship_cust_id%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN

Line 568: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_cust_id l_cust_id ' || l_cust_id, 1, 'N');

564: OPEN c_ship_cust_id;
565: FETCH c_ship_cust_id into l_cust_id;
566:
567: IF aso_debug_pub.g_debug_flag = 'Y' THEN
568: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_cust_id l_cust_id ' || l_cust_id, 1, 'N');
569: END IF;
570:
571: IF c_ship_cust_id%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN
572:

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

574:
575: OPEN c_ship_cust_id1;
576: FETCH c_ship_cust_id1 into l_cust_id;
577:
578: IF aso_debug_pub.g_debug_flag = 'Y' THEN
579: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_cust_id1 l_cust_id ' || l_cust_id, 1, 'N');
580: END IF;
581:
582: IF c_ship_cust_id1%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN

Line 579: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_cust_id1 l_cust_id ' || l_cust_id, 1, 'N');

575: OPEN c_ship_cust_id1;
576: FETCH c_ship_cust_id1 into l_cust_id;
577:
578: IF aso_debug_pub.g_debug_flag = 'Y' THEN
579: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_cust_id1 l_cust_id ' || l_cust_id, 1, 'N');
580: END IF;
581:
582: IF c_ship_cust_id1%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN
583:

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

587: OPEN c_cust_id;
588: FETCH c_cust_id INTO l_cust_id;
589: CLOSE c_cust_id;
590:
591: IF aso_debug_pub.g_debug_flag = 'Y' THEN
592: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_cust_id l_cust_id ' || l_cust_id, 1, 'N');
593: END IF;
594:
595: OPEN C_site_use(l_cust_id , l_ship_site_id);

Line 592: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_cust_id l_cust_id ' || l_cust_id, 1, 'N');

588: FETCH c_cust_id INTO l_cust_id;
589: CLOSE c_cust_id;
590:
591: IF aso_debug_pub.g_debug_flag = 'Y' THEN
592: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_cust_id l_cust_id ' || l_cust_id, 1, 'N');
593: END IF;
594:
595: OPEN C_site_use(l_cust_id , l_ship_site_id);
596: FETCH C_site_use into l_ship_site_use_id;

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

594:
595: OPEN C_site_use(l_cust_id , l_ship_site_id);
596: FETCH C_site_use into l_ship_site_use_id;
597:
598: IF aso_debug_pub.g_debug_flag = 'Y' THEN
599: aso_debug_pub.add('ASO_SHIPMENT_PVT:C_site_use1 l_ship_site_use_id ' || l_ship_site_use_id, 1, 'N');
600: END IF;
601: CLOSE C_site_use;
602:

Line 599: aso_debug_pub.add('ASO_SHIPMENT_PVT:C_site_use1 l_ship_site_use_id ' || l_ship_site_use_id, 1, 'N');

595: OPEN C_site_use(l_cust_id , l_ship_site_id);
596: FETCH C_site_use into l_ship_site_use_id;
597:
598: IF aso_debug_pub.g_debug_flag = 'Y' THEN
599: aso_debug_pub.add('ASO_SHIPMENT_PVT:C_site_use1 l_ship_site_use_id ' || l_ship_site_use_id, 1, 'N');
600: END IF;
601: CLOSE C_site_use;
602:
603: return l_ship_site_use_id;

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

608:
609: OPEN C_site_use(l_cust_id , l_ship_site_id);
610: FETCH C_site_use into l_ship_site_use_id;
611:
612: IF aso_debug_pub.g_debug_flag = 'Y' THEN
613: aso_debug_pub.add('ASO_SHIPMENT_PVT:C_site_use2 l_ship_site_use_id ' || l_ship_site_use_id, 1, 'N');
614: END IF;
615: CLOSE C_site_use;
616:

Line 613: aso_debug_pub.add('ASO_SHIPMENT_PVT:C_site_use2 l_ship_site_use_id ' || l_ship_site_use_id, 1, 'N');

609: OPEN C_site_use(l_cust_id , l_ship_site_id);
610: FETCH C_site_use into l_ship_site_use_id;
611:
612: IF aso_debug_pub.g_debug_flag = 'Y' THEN
613: aso_debug_pub.add('ASO_SHIPMENT_PVT:C_site_use2 l_ship_site_use_id ' || l_ship_site_use_id, 1, 'N');
614: END IF;
615: CLOSE C_site_use;
616:
617: return l_ship_site_use_id;

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

625:
626: OPEN C_site_use(l_cust_id , l_ship_site_id);
627: FETCH C_site_use into l_ship_site_use_id;
628:
629: IF aso_debug_pub.g_debug_flag = 'Y' THEN
630: aso_debug_pub.add('ASO_SHIPMENT_PVT:C_site_use3 l_ship_site_use_id ' || l_ship_site_use_id, 1, 'N');
631: END IF;
632: CLOSE C_site_use;
633:

Line 630: aso_debug_pub.add('ASO_SHIPMENT_PVT:C_site_use3 l_ship_site_use_id ' || l_ship_site_use_id, 1, 'N');

626: OPEN C_site_use(l_cust_id , l_ship_site_id);
627: FETCH C_site_use into l_ship_site_use_id;
628:
629: IF aso_debug_pub.g_debug_flag = 'Y' THEN
630: aso_debug_pub.add('ASO_SHIPMENT_PVT:C_site_use3 l_ship_site_use_id ' || l_ship_site_use_id, 1, 'N');
631: END IF;
632: CLOSE C_site_use;
633:
634: return l_ship_site_use_id;

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

639:
640: open c_item_type_code;
641: fetch c_item_type_code into l_item_type_code;
642:
643: IF aso_debug_pub.g_debug_flag = 'Y' THEN
644: aso_debug_pub.add('Get_Ship_To_site_Id: c_item_type_code: l_item_type_code: '||l_item_type_code);
645: END IF;
646:
647: IF c_item_type_code%FOUND and l_item_type_code = 'CFG' THEN

Line 644: aso_debug_pub.add('Get_Ship_To_site_Id: c_item_type_code: l_item_type_code: '||l_item_type_code);

640: open c_item_type_code;
641: fetch c_item_type_code into l_item_type_code;
642:
643: IF aso_debug_pub.g_debug_flag = 'Y' THEN
644: aso_debug_pub.add('Get_Ship_To_site_Id: c_item_type_code: l_item_type_code: '||l_item_type_code);
645: END IF;
646:
647: IF c_item_type_code%FOUND and l_item_type_code = 'CFG' THEN
648:

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

650:
651: open c_root_model_line_id;
652: fetch c_root_model_line_id into l_model_quote_line_id;
653:
654: IF aso_debug_pub.g_debug_flag = 'Y' THEN
655: aso_debug_pub.add('Get_Ship_To_site_Id: c_root_model_line_id: l_model_quote_line_id: '||l_model_quote_line_id);
656: END IF;
657:
658: IF c_root_model_line_id%FOUND and l_model_quote_line_id is not null THEN

Line 655: aso_debug_pub.add('Get_Ship_To_site_Id: c_root_model_line_id: l_model_quote_line_id: '||l_model_quote_line_id);

651: open c_root_model_line_id;
652: fetch c_root_model_line_id into l_model_quote_line_id;
653:
654: IF aso_debug_pub.g_debug_flag = 'Y' THEN
655: aso_debug_pub.add('Get_Ship_To_site_Id: c_root_model_line_id: l_model_quote_line_id: '||l_model_quote_line_id);
656: END IF;
657:
658: IF c_root_model_line_id%FOUND and l_model_quote_line_id is not null THEN
659:

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

661:
662: open c_shipment_id(l_model_quote_line_id);
663: fetch c_shipment_id into l_model_shipment_id;
664:
665: IF aso_debug_pub.g_debug_flag = 'Y' THEN
666: aso_debug_pub.add('Get_Ship_To_site_Id: c_shipment_id: l_model_shipment_id: '||l_model_shipment_id);
667: END IF;
668:
669: IF c_shipment_id%FOUND and l_model_shipment_id is not null THEN

Line 666: aso_debug_pub.add('Get_Ship_To_site_Id: c_shipment_id: l_model_shipment_id: '||l_model_shipment_id);

662: open c_shipment_id(l_model_quote_line_id);
663: fetch c_shipment_id into l_model_shipment_id;
664:
665: IF aso_debug_pub.g_debug_flag = 'Y' THEN
666: aso_debug_pub.add('Get_Ship_To_site_Id: c_shipment_id: l_model_shipment_id: '||l_model_shipment_id);
667: END IF;
668:
669: IF c_shipment_id%FOUND and l_model_shipment_id is not null THEN
670:

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

670:
671: close c_shipment_id;
672:
673: l_ship_site_use_id := Get_Ship_To_site_Id(p_qte_header_id, l_model_quote_line_id, l_model_shipment_id);
674: IF aso_debug_pub.g_debug_flag = 'Y' THEN
675: aso_debug_pub.add('Get_Ship_To_site_Id: l_ship_site_use_id: '||l_ship_site_use_id);
676: END IF;
677:
678: return l_ship_site_use_id;

Line 675: aso_debug_pub.add('Get_Ship_To_site_Id: l_ship_site_use_id: '||l_ship_site_use_id);

671: close c_shipment_id;
672:
673: l_ship_site_use_id := Get_Ship_To_site_Id(p_qte_header_id, l_model_quote_line_id, l_model_shipment_id);
674: IF aso_debug_pub.g_debug_flag = 'Y' THEN
675: aso_debug_pub.add('Get_Ship_To_site_Id: l_ship_site_use_id: '||l_ship_site_use_id);
676: END IF;
677:
678: return l_ship_site_use_id;
679:

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

694:
695: OPEN c_ship_site2;
696: FETCH c_ship_site2 INTO l_ship_site_id, l_ship_cust_acct_id;
697:
698: IF aso_debug_pub.g_debug_flag = 'Y' THEN
699: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_site2 l_ship_site_id ' || l_ship_site_id, 1, 'N');
700: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_site2 l_ship_cust_acct_id ' || l_ship_cust_acct_id, 1, 'N');
701: END IF;
702:

Line 699: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_site2 l_ship_site_id ' || l_ship_site_id, 1, 'N');

695: OPEN c_ship_site2;
696: FETCH c_ship_site2 INTO l_ship_site_id, l_ship_cust_acct_id;
697:
698: IF aso_debug_pub.g_debug_flag = 'Y' THEN
699: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_site2 l_ship_site_id ' || l_ship_site_id, 1, 'N');
700: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_site2 l_ship_cust_acct_id ' || l_ship_cust_acct_id, 1, 'N');
701: END IF;
702:
703: IF c_ship_site2%FOUND AND l_ship_site_id IS NOT NULL and l_ship_site_id <> FND_API.G_MISS_NUM THEN

Line 700: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_site2 l_ship_cust_acct_id ' || l_ship_cust_acct_id, 1, 'N');

696: FETCH c_ship_site2 INTO l_ship_site_id, l_ship_cust_acct_id;
697:
698: IF aso_debug_pub.g_debug_flag = 'Y' THEN
699: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_site2 l_ship_site_id ' || l_ship_site_id, 1, 'N');
700: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_site2 l_ship_cust_acct_id ' || l_ship_cust_acct_id, 1, 'N');
701: END IF;
702:
703: IF c_ship_site2%FOUND AND l_ship_site_id IS NOT NULL and l_ship_site_id <> FND_API.G_MISS_NUM THEN
704:

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

706: --Get the ship_to_cust_account if present
707: OPEN c_ship_cust_id;
708: FETCH c_ship_cust_id into l_cust_id;
709:
710: IF aso_debug_pub.g_debug_flag = 'Y' THEN
711: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_cust_id l_cust_id ' || l_cust_id, 1, 'N');
712: END IF;
713:
714: IF c_ship_cust_id%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN

Line 711: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_cust_id l_cust_id ' || l_cust_id, 1, 'N');

707: OPEN c_ship_cust_id;
708: FETCH c_ship_cust_id into l_cust_id;
709:
710: IF aso_debug_pub.g_debug_flag = 'Y' THEN
711: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_cust_id l_cust_id ' || l_cust_id, 1, 'N');
712: END IF;
713:
714: IF c_ship_cust_id%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN
715:

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

717: OPEN c_ship_cust_id1;
718:
719: FETCH c_ship_cust_id1 into l_cust_id;
720:
721: IF aso_debug_pub.g_debug_flag = 'Y' THEN
722: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_cust_id1 l_cust_id ' || l_cust_id, 1, 'N');
723: END IF;
724:
725: IF c_ship_cust_id1%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN

Line 722: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_cust_id1 l_cust_id ' || l_cust_id, 1, 'N');

718:
719: FETCH c_ship_cust_id1 into l_cust_id;
720:
721: IF aso_debug_pub.g_debug_flag = 'Y' THEN
722: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_cust_id1 l_cust_id ' || l_cust_id, 1, 'N');
723: END IF;
724:
725: IF c_ship_cust_id1%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN
726:

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

729: OPEN c_cust_id;
730: FETCH c_cust_id INTO l_cust_id;
731: CLOSE c_cust_id;
732:
733: IF aso_debug_pub.g_debug_flag = 'Y' THEN
734: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_cust_id l_cust_id ' || l_cust_id, 1, 'N');
735: END IF;
736:
737: OPEN C_site_use(l_cust_id , l_ship_site_id);

Line 734: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_cust_id l_cust_id ' || l_cust_id, 1, 'N');

730: FETCH c_cust_id INTO l_cust_id;
731: CLOSE c_cust_id;
732:
733: IF aso_debug_pub.g_debug_flag = 'Y' THEN
734: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_cust_id l_cust_id ' || l_cust_id, 1, 'N');
735: END IF;
736:
737: OPEN C_site_use(l_cust_id , l_ship_site_id);
738: FETCH C_site_use into l_ship_site_use_id;

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

736:
737: OPEN C_site_use(l_cust_id , l_ship_site_id);
738: FETCH C_site_use into l_ship_site_use_id;
739:
740: IF aso_debug_pub.g_debug_flag = 'Y' THEN
741: aso_debug_pub.add('ASO_SHIPMENT_PVT:C_site_use4 l_ship_site_use_id ' || l_ship_site_use_id, 1, 'N');
742: END IF;
743:
744: CLOSE C_site_use;

Line 741: aso_debug_pub.add('ASO_SHIPMENT_PVT:C_site_use4 l_ship_site_use_id ' || l_ship_site_use_id, 1, 'N');

737: OPEN C_site_use(l_cust_id , l_ship_site_id);
738: FETCH C_site_use into l_ship_site_use_id;
739:
740: IF aso_debug_pub.g_debug_flag = 'Y' THEN
741: aso_debug_pub.add('ASO_SHIPMENT_PVT:C_site_use4 l_ship_site_use_id ' || l_ship_site_use_id, 1, 'N');
742: END IF;
743:
744: CLOSE C_site_use;
745: return l_ship_site_use_id;

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

750:
751: OPEN C_site_use(l_cust_id , l_ship_site_id);
752: FETCH C_site_use into l_ship_site_use_id;
753:
754: IF aso_debug_pub.g_debug_flag = 'Y' THEN
755: aso_debug_pub.add('ASO_SHIPMENT_PVT:C_site_use5 l_ship_site_use_id ' || l_ship_site_use_id, 1, 'N');
756: END IF;
757:
758: CLOSE C_site_use;

Line 755: aso_debug_pub.add('ASO_SHIPMENT_PVT:C_site_use5 l_ship_site_use_id ' || l_ship_site_use_id, 1, 'N');

751: OPEN C_site_use(l_cust_id , l_ship_site_id);
752: FETCH C_site_use into l_ship_site_use_id;
753:
754: IF aso_debug_pub.g_debug_flag = 'Y' THEN
755: aso_debug_pub.add('ASO_SHIPMENT_PVT:C_site_use5 l_ship_site_use_id ' || l_ship_site_use_id, 1, 'N');
756: END IF;
757:
758: CLOSE C_site_use;
759: return l_ship_site_use_id;

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

765:
766: OPEN C_site_use(l_cust_id , l_ship_site_id);
767: FETCH C_site_use into l_ship_site_use_id;
768:
769: IF aso_debug_pub.g_debug_flag = 'Y' THEN
770: aso_debug_pub.add('ASO_SHIPMENT_PVT:C_site_use6 l_ship_site_use_id ' || l_ship_site_use_id, 1, 'N');
771: END IF;
772: CLOSE C_site_use;
773:

Line 770: aso_debug_pub.add('ASO_SHIPMENT_PVT:C_site_use6 l_ship_site_use_id ' || l_ship_site_use_id, 1, 'N');

766: OPEN C_site_use(l_cust_id , l_ship_site_id);
767: FETCH C_site_use into l_ship_site_use_id;
768:
769: IF aso_debug_pub.g_debug_flag = 'Y' THEN
770: aso_debug_pub.add('ASO_SHIPMENT_PVT:C_site_use6 l_ship_site_use_id ' || l_ship_site_use_id, 1, 'N');
771: END IF;
772: CLOSE C_site_use;
773:
774: return l_ship_site_use_id;

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

839:
840: open c_item_type_code;
841: fetch c_item_type_code into l_item_type_code;
842:
843: IF aso_debug_pub.g_debug_flag = 'Y' THEN
844: aso_debug_pub.add('Get_Ship_To_party_site_Id: c_item_type_code: l_item_type_code: '||l_item_type_code);
845: END IF;
846:
847: IF c_item_type_code%FOUND and l_item_type_code = 'CFG' THEN

Line 844: aso_debug_pub.add('Get_Ship_To_party_site_Id: c_item_type_code: l_item_type_code: '||l_item_type_code);

840: open c_item_type_code;
841: fetch c_item_type_code into l_item_type_code;
842:
843: IF aso_debug_pub.g_debug_flag = 'Y' THEN
844: aso_debug_pub.add('Get_Ship_To_party_site_Id: c_item_type_code: l_item_type_code: '||l_item_type_code);
845: END IF;
846:
847: IF c_item_type_code%FOUND and l_item_type_code = 'CFG' THEN
848:

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

850:
851: open c_root_model_line_id;
852: fetch c_root_model_line_id into l_model_quote_line_id;
853:
854: IF aso_debug_pub.g_debug_flag = 'Y' THEN
855: aso_debug_pub.add('Get_Ship_To_party_site_Id: c_root_model_line_id: l_model_quote_line_id: '||l_model_quote_line_id);
856: END IF;
857:
858: IF c_root_model_line_id%FOUND and l_model_quote_line_id is not null THEN

Line 855: aso_debug_pub.add('Get_Ship_To_party_site_Id: c_root_model_line_id: l_model_quote_line_id: '||l_model_quote_line_id);

851: open c_root_model_line_id;
852: fetch c_root_model_line_id into l_model_quote_line_id;
853:
854: IF aso_debug_pub.g_debug_flag = 'Y' THEN
855: aso_debug_pub.add('Get_Ship_To_party_site_Id: c_root_model_line_id: l_model_quote_line_id: '||l_model_quote_line_id);
856: END IF;
857:
858: IF c_root_model_line_id%FOUND and l_model_quote_line_id is not null THEN
859:

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

861:
862: open c_shipment_id(l_model_quote_line_id);
863: fetch c_shipment_id into l_model_shipment_id;
864:
865: IF aso_debug_pub.g_debug_flag = 'Y' THEN
866: aso_debug_pub.add('Get_Ship_To_party_site_Id: c_shipment_id: l_model_shipment_id: '||l_model_shipment_id);
867: END IF;
868:
869: IF c_shipment_id%FOUND and l_model_shipment_id is not null THEN

Line 866: aso_debug_pub.add('Get_Ship_To_party_site_Id: c_shipment_id: l_model_shipment_id: '||l_model_shipment_id);

862: open c_shipment_id(l_model_quote_line_id);
863: fetch c_shipment_id into l_model_shipment_id;
864:
865: IF aso_debug_pub.g_debug_flag = 'Y' THEN
866: aso_debug_pub.add('Get_Ship_To_party_site_Id: c_shipment_id: l_model_shipment_id: '||l_model_shipment_id);
867: END IF;
868:
869: IF c_shipment_id%FOUND and l_model_shipment_id is not null THEN
870:

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

871: close c_shipment_id;
872:
873: l_ship_site_id := Get_Ship_To_party_site_Id(p_qte_header_id, l_model_quote_line_id, l_model_shipment_id);
874:
875: IF aso_debug_pub.g_debug_flag = 'Y' THEN
876: aso_debug_pub.add('Get_Ship_To_party_site_Id: l_ship_site_id: '||l_ship_site_id);
877: END IF;
878:
879: return l_ship_site_id;

Line 876: aso_debug_pub.add('Get_Ship_To_party_site_Id: l_ship_site_id: '||l_ship_site_id);

872:
873: l_ship_site_id := Get_Ship_To_party_site_Id(p_qte_header_id, l_model_quote_line_id, l_model_shipment_id);
874:
875: IF aso_debug_pub.g_debug_flag = 'Y' THEN
876: aso_debug_pub.add('Get_Ship_To_party_site_Id: l_ship_site_id: '||l_ship_site_id);
877: END IF;
878:
879: return l_ship_site_id;
880:

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

1093: l_ship_from_org_id NUMBER;
1094:
1095:
1096: Begin
1097: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1098: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_from_org_id: p_qte_header_id :'||p_qte_header_id, 1, 'N');
1099: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_from_org_id: p_qte_line_id :'||p_qte_line_id, 1, 'N');
1100: END IF;
1101:

Line 1098: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_from_org_id: p_qte_header_id :'||p_qte_header_id, 1, 'N');

1094:
1095:
1096: Begin
1097: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1098: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_from_org_id: p_qte_header_id :'||p_qte_header_id, 1, 'N');
1099: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_from_org_id: p_qte_line_id :'||p_qte_line_id, 1, 'N');
1100: END IF;
1101:
1102: -- Look for line-shipment level ship_from_org_id

Line 1099: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_from_org_id: p_qte_line_id :'||p_qte_line_id, 1, 'N');

1095:
1096: Begin
1097: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1098: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_from_org_id: p_qte_header_id :'||p_qte_header_id, 1, 'N');
1099: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_from_org_id: p_qte_line_id :'||p_qte_line_id, 1, 'N');
1100: END IF;
1101:
1102: -- Look for line-shipment level ship_from_org_id
1103:

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

1103:
1104: open c_line_shipment;
1105: fetch c_line_shipment into l_ship_from_org_id;
1106:
1107: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1108: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_from_org_id: c_line_shipment: l_ship_from_org_id'||l_ship_from_org_id, 1, 'N');
1109: END IF;
1110:
1111: -- Line-shipment level ship_from_org_id doesn't exist then look for header-shipment level ship_from_org_id

Line 1108: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_from_org_id: c_line_shipment: l_ship_from_org_id'||l_ship_from_org_id, 1, 'N');

1104: open c_line_shipment;
1105: fetch c_line_shipment into l_ship_from_org_id;
1106:
1107: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1108: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_from_org_id: c_line_shipment: l_ship_from_org_id'||l_ship_from_org_id, 1, 'N');
1109: END IF;
1110:
1111: -- Line-shipment level ship_from_org_id doesn't exist then look for header-shipment level ship_from_org_id
1112:

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

1113: IF c_line_shipment%NOTFOUND OR l_ship_from_org_id IS NULL OR l_ship_from_org_id = FND_API.G_MISS_NUM THEN
1114: open c_header_shipment;
1115: fetch c_header_shipment into l_ship_from_org_id;
1116:
1117: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1118: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_from_org_id: c_header_shipment: l_ship_from_org_id'||l_ship_from_org_id, 1, 'N');
1119: END IF;
1120:
1121: close c_header_shipment;

Line 1118: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_from_org_id: c_header_shipment: l_ship_from_org_id'||l_ship_from_org_id, 1, 'N');

1114: open c_header_shipment;
1115: fetch c_header_shipment into l_ship_from_org_id;
1116:
1117: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1118: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_from_org_id: c_header_shipment: l_ship_from_org_id'||l_ship_from_org_id, 1, 'N');
1119: END IF;
1120:
1121: close c_header_shipment;
1122: END IF;

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

1144: l_ship_method_code varchar2(30) := null;
1145:
1146: Begin
1147:
1148: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1149: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_method_code: p_qte_header_id : '||p_qte_header_id, 1, 'Y');
1150: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_method_code: p_qte_line_id : '||p_qte_line_id, 1, 'Y');
1151: END IF;
1152:

Line 1149: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_method_code: p_qte_header_id : '||p_qte_header_id, 1, 'Y');

1145:
1146: Begin
1147:
1148: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1149: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_method_code: p_qte_header_id : '||p_qte_header_id, 1, 'Y');
1150: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_method_code: p_qte_line_id : '||p_qte_line_id, 1, 'Y');
1151: END IF;
1152:
1153: -- Look for line-shipment level ship_method_code

Line 1150: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_method_code: p_qte_line_id : '||p_qte_line_id, 1, 'Y');

1146: Begin
1147:
1148: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1149: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_method_code: p_qte_header_id : '||p_qte_header_id, 1, 'Y');
1150: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_method_code: p_qte_line_id : '||p_qte_line_id, 1, 'Y');
1151: END IF;
1152:
1153: -- Look for line-shipment level ship_method_code
1154:

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

1156:
1157: open c_line_shipment;
1158: fetch c_line_shipment into l_ship_method_code;
1159:
1160: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1161: aso_debug_pub.add('Get_ship_method_code: c_line_shipment: l_ship_method_code: '||l_ship_method_code, 1, 'N');
1162: END IF;
1163:
1164: -- Line-shipment level ship_method_code doesn't exist then look for header-shipment level ship_method_code

Line 1161: aso_debug_pub.add('Get_ship_method_code: c_line_shipment: l_ship_method_code: '||l_ship_method_code, 1, 'N');

1157: open c_line_shipment;
1158: fetch c_line_shipment into l_ship_method_code;
1159:
1160: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1161: aso_debug_pub.add('Get_ship_method_code: c_line_shipment: l_ship_method_code: '||l_ship_method_code, 1, 'N');
1162: END IF;
1163:
1164: -- Line-shipment level ship_method_code doesn't exist then look for header-shipment level ship_method_code
1165:

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

1167:
1168: open c_header_shipment;
1169: fetch c_header_shipment into l_ship_method_code;
1170:
1171: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1172: aso_debug_pub.add('Get_ship_method_code: c_header_shipment: l_ship_method_code: '||l_ship_method_code, 1, 'N');
1173: END IF;
1174:
1175: close c_header_shipment;

Line 1172: aso_debug_pub.add('Get_ship_method_code: c_header_shipment: l_ship_method_code: '||l_ship_method_code, 1, 'N');

1168: open c_header_shipment;
1169: fetch c_header_shipment into l_ship_method_code;
1170:
1171: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1172: aso_debug_pub.add('Get_ship_method_code: c_header_shipment: l_ship_method_code: '||l_ship_method_code, 1, 'N');
1173: END IF;
1174:
1175: close c_header_shipment;
1176: END IF;

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

1181:
1182: open c_header_shipment;
1183: fetch c_header_shipment into l_ship_method_code;
1184:
1185: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1186: aso_debug_pub.add('Get_ship_from_org_id: c_header_shipment: l_ship_method_code: '||l_ship_method_code, 1, 'N');
1187: END IF;
1188:
1189: close c_header_shipment;

Line 1186: aso_debug_pub.add('Get_ship_from_org_id: c_header_shipment: l_ship_method_code: '||l_ship_method_code, 1, 'N');

1182: open c_header_shipment;
1183: fetch c_header_shipment into l_ship_method_code;
1184:
1185: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1186: aso_debug_pub.add('Get_ship_from_org_id: c_header_shipment: l_ship_method_code: '||l_ship_method_code, 1, 'N');
1187: END IF;
1188:
1189: close c_header_shipment;
1190:

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

1214: l_demand_class_code varchar2(30) := null;
1215:
1216: Begin
1217:
1218: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1219: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_demand_class_code: p_qte_header_id : '||p_qte_header_id, 1, 'Y');
1220: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_demand_class_code: p_qte_line_id : '||p_qte_line_id, 1, 'Y');
1221: END IF;
1222:

Line 1219: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_demand_class_code: p_qte_header_id : '||p_qte_header_id, 1, 'Y');

1215:
1216: Begin
1217:
1218: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1219: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_demand_class_code: p_qte_header_id : '||p_qte_header_id, 1, 'Y');
1220: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_demand_class_code: p_qte_line_id : '||p_qte_line_id, 1, 'Y');
1221: END IF;
1222:
1223: -- Look for line-shipment level demand_class_code

Line 1220: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_demand_class_code: p_qte_line_id : '||p_qte_line_id, 1, 'Y');

1216: Begin
1217:
1218: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1219: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_demand_class_code: p_qte_header_id : '||p_qte_header_id, 1, 'Y');
1220: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_demand_class_code: p_qte_line_id : '||p_qte_line_id, 1, 'Y');
1221: END IF;
1222:
1223: -- Look for line-shipment level demand_class_code
1224:

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

1226:
1227: open c_line_shipment;
1228: fetch c_line_shipment into l_demand_class_code;
1229:
1230: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1231: aso_debug_pub.add('Get_demand_class_code: c_line_shipment: l_demand_class_code: '||l_demand_class_code, 1, 'N');
1232: END IF;
1233:
1234: -- Line-shipment level demand_class_code doesn't exist then look for header-shipment level demand_class_code

Line 1231: aso_debug_pub.add('Get_demand_class_code: c_line_shipment: l_demand_class_code: '||l_demand_class_code, 1, 'N');

1227: open c_line_shipment;
1228: fetch c_line_shipment into l_demand_class_code;
1229:
1230: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1231: aso_debug_pub.add('Get_demand_class_code: c_line_shipment: l_demand_class_code: '||l_demand_class_code, 1, 'N');
1232: END IF;
1233:
1234: -- Line-shipment level demand_class_code doesn't exist then look for header-shipment level demand_class_code
1235:

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

1237:
1238: open c_header_shipment;
1239: fetch c_header_shipment into l_demand_class_code;
1240:
1241: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1242: aso_debug_pub.add('Get_demand_class_code: c_header_shipment: l_demand_class_code: '||l_demand_class_code, 1, 'N');
1243: END IF;
1244:
1245: close c_header_shipment;

Line 1242: aso_debug_pub.add('Get_demand_class_code: c_header_shipment: l_demand_class_code: '||l_demand_class_code, 1, 'N');

1238: open c_header_shipment;
1239: fetch c_header_shipment into l_demand_class_code;
1240:
1241: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1242: aso_debug_pub.add('Get_demand_class_code: c_header_shipment: l_demand_class_code: '||l_demand_class_code, 1, 'N');
1243: END IF;
1244:
1245: close c_header_shipment;
1246: END IF;

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

1251:
1252: open c_header_shipment;
1253: fetch c_header_shipment into l_demand_class_code;
1254:
1255: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1256: aso_debug_pub.add('Get_demand_class_code: c_header_shipment: l_demand_class_code: '||l_demand_class_code, 1, 'N');
1257: END IF;
1258:
1259: close c_header_shipment;

Line 1256: aso_debug_pub.add('Get_demand_class_code: c_header_shipment: l_demand_class_code: '||l_demand_class_code, 1, 'N');

1252: open c_header_shipment;
1253: fetch c_header_shipment into l_demand_class_code;
1254:
1255: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1256: aso_debug_pub.add('Get_demand_class_code: c_header_shipment: l_demand_class_code: '||l_demand_class_code, 1, 'N');
1257: END IF;
1258:
1259: close c_header_shipment;
1260:

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

1284: l_ship_to_party_site_id number := null;
1285:
1286: Begin
1287:
1288: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1289: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_to_party_site_id: p_qte_header_id : '||p_qte_header_id, 1, 'Y');
1290: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_to_party_site_id: p_qte_line_id : '||p_qte_line_id, 1, 'Y');
1291: END IF;
1292:

Line 1289: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_to_party_site_id: p_qte_header_id : '||p_qte_header_id, 1, 'Y');

1285:
1286: Begin
1287:
1288: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1289: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_to_party_site_id: p_qte_header_id : '||p_qte_header_id, 1, 'Y');
1290: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_to_party_site_id: p_qte_line_id : '||p_qte_line_id, 1, 'Y');
1291: END IF;
1292:
1293: -- Look for line-shipment level ship_to_party_site_id

Line 1290: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_to_party_site_id: p_qte_line_id : '||p_qte_line_id, 1, 'Y');

1286: Begin
1287:
1288: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1289: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_to_party_site_id: p_qte_header_id : '||p_qte_header_id, 1, 'Y');
1290: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_to_party_site_id: p_qte_line_id : '||p_qte_line_id, 1, 'Y');
1291: END IF;
1292:
1293: -- Look for line-shipment level ship_to_party_site_id
1294:

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

1296:
1297: open c_line_shipment;
1298: fetch c_line_shipment into l_ship_to_party_site_id;
1299:
1300: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1301: aso_debug_pub.add('Get_ship_to_party_site_id: c_line_shipment: l_ship_to_party_site_id: '||l_ship_to_party_site_id, 1, 'N');
1302: END IF;
1303:
1304: -- Line-shipment level ship_to_party_site_id doesn't exist then look for header-shipment level ship_to_party_site_id

Line 1301: aso_debug_pub.add('Get_ship_to_party_site_id: c_line_shipment: l_ship_to_party_site_id: '||l_ship_to_party_site_id, 1, 'N');

1297: open c_line_shipment;
1298: fetch c_line_shipment into l_ship_to_party_site_id;
1299:
1300: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1301: aso_debug_pub.add('Get_ship_to_party_site_id: c_line_shipment: l_ship_to_party_site_id: '||l_ship_to_party_site_id, 1, 'N');
1302: END IF;
1303:
1304: -- Line-shipment level ship_to_party_site_id doesn't exist then look for header-shipment level ship_to_party_site_id
1305:

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

1307:
1308: open c_header_shipment;
1309: fetch c_header_shipment into l_ship_to_party_site_id;
1310:
1311: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1312: aso_debug_pub.add('Get_ship_to_party_site_id: c_header_shipment: l_ship_to_party_site_id: '||l_ship_to_party_site_id, 1, 'N');
1313: END IF;
1314:
1315: close c_header_shipment;

Line 1312: aso_debug_pub.add('Get_ship_to_party_site_id: c_header_shipment: l_ship_to_party_site_id: '||l_ship_to_party_site_id, 1, 'N');

1308: open c_header_shipment;
1309: fetch c_header_shipment into l_ship_to_party_site_id;
1310:
1311: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1312: aso_debug_pub.add('Get_ship_to_party_site_id: c_header_shipment: l_ship_to_party_site_id: '||l_ship_to_party_site_id, 1, 'N');
1313: END IF;
1314:
1315: close c_header_shipment;
1316: END IF;

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

1321:
1322: open c_header_shipment;
1323: fetch c_header_shipment into l_ship_to_party_site_id;
1324:
1325: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1326: aso_debug_pub.add('Get_ship_to_party_site_id: c_header_shipment: l_ship_to_party_site_id: '||l_ship_to_party_site_id, 1, 'N');
1327: END IF;
1328:
1329: close c_header_shipment;

Line 1326: aso_debug_pub.add('Get_ship_to_party_site_id: c_header_shipment: l_ship_to_party_site_id: '||l_ship_to_party_site_id, 1, 'N');

1322: open c_header_shipment;
1323: fetch c_header_shipment into l_ship_to_party_site_id;
1324:
1325: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1326: aso_debug_pub.add('Get_ship_to_party_site_id: c_header_shipment: l_ship_to_party_site_id: '||l_ship_to_party_site_id, 1, 'N');
1327: END IF;
1328:
1329: close c_header_shipment;
1330:

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

1354: l_ship_to_cust_account_id number := null;
1355:
1356: Begin
1357:
1358: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1359: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_to_cust_account_id: p_qte_header_id : '||p_qte_header_id, 1, 'Y');
1360: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_to_cust_account_id: p_qte_line_id : '||p_qte_line_id, 1, 'Y');
1361: END IF;
1362:

Line 1359: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_to_cust_account_id: p_qte_header_id : '||p_qte_header_id, 1, 'Y');

1355:
1356: Begin
1357:
1358: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1359: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_to_cust_account_id: p_qte_header_id : '||p_qte_header_id, 1, 'Y');
1360: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_to_cust_account_id: p_qte_line_id : '||p_qte_line_id, 1, 'Y');
1361: END IF;
1362:
1363: -- Look for line-shipment level ship_to_cust_account_id

Line 1360: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_to_cust_account_id: p_qte_line_id : '||p_qte_line_id, 1, 'Y');

1356: Begin
1357:
1358: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1359: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_to_cust_account_id: p_qte_header_id : '||p_qte_header_id, 1, 'Y');
1360: aso_debug_pub.add('ASO_SHIPMENT_PVT.Get_ship_to_cust_account_id: p_qte_line_id : '||p_qte_line_id, 1, 'Y');
1361: END IF;
1362:
1363: -- Look for line-shipment level ship_to_cust_account_id
1364:

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

1366:
1367: open c_line_shipment;
1368: fetch c_line_shipment into l_ship_to_cust_account_id;
1369:
1370: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1371: aso_debug_pub.add('Get_ship_to_party_site_id: c_line_shipment: l_ship_to_cust_account_id: '||l_ship_to_cust_account_id, 1, 'N');
1372: END IF;
1373:
1374: -- Line-shipment level ship_to_cust_account_id doesn't exist then look for header-shipment level ship_to_cust_account_id

Line 1371: aso_debug_pub.add('Get_ship_to_party_site_id: c_line_shipment: l_ship_to_cust_account_id: '||l_ship_to_cust_account_id, 1, 'N');

1367: open c_line_shipment;
1368: fetch c_line_shipment into l_ship_to_cust_account_id;
1369:
1370: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1371: aso_debug_pub.add('Get_ship_to_party_site_id: c_line_shipment: l_ship_to_cust_account_id: '||l_ship_to_cust_account_id, 1, 'N');
1372: END IF;
1373:
1374: -- Line-shipment level ship_to_cust_account_id doesn't exist then look for header-shipment level ship_to_cust_account_id
1375:

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

1377:
1378: open c_header_shipment;
1379: fetch c_header_shipment into l_ship_to_cust_account_id;
1380:
1381: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1382: aso_debug_pub.add('Get_ship_to_cust_account_id: c_header_shipment: l_ship_to_cust_account_id: '||l_ship_to_cust_account_id, 1, 'N');
1383: END IF;
1384:
1385: close c_header_shipment;

Line 1382: aso_debug_pub.add('Get_ship_to_cust_account_id: c_header_shipment: l_ship_to_cust_account_id: '||l_ship_to_cust_account_id, 1, 'N');

1378: open c_header_shipment;
1379: fetch c_header_shipment into l_ship_to_cust_account_id;
1380:
1381: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1382: aso_debug_pub.add('Get_ship_to_cust_account_id: c_header_shipment: l_ship_to_cust_account_id: '||l_ship_to_cust_account_id, 1, 'N');
1383: END IF;
1384:
1385: close c_header_shipment;
1386: END IF;

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

1391:
1392: open c_header_shipment;
1393: fetch c_header_shipment into l_ship_to_cust_account_id;
1394:
1395: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1396: aso_debug_pub.add('Get_ship_to_cust_account_id: c_header_shipment: l_ship_to_cust_account_id: '||l_ship_to_cust_account_id, 1, 'N');
1397: END IF;
1398:
1399: close c_header_shipment;

Line 1396: aso_debug_pub.add('Get_ship_to_cust_account_id: c_header_shipment: l_ship_to_cust_account_id: '||l_ship_to_cust_account_id, 1, 'N');

1392: open c_header_shipment;
1393: fetch c_header_shipment into l_ship_to_cust_account_id;
1394:
1395: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1396: aso_debug_pub.add('Get_ship_to_cust_account_id: c_header_shipment: l_ship_to_cust_account_id: '||l_ship_to_cust_account_id, 1, 'N');
1397: END IF;
1398:
1399: close c_header_shipment;
1400: