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_SHIPMENT_PVT

Line 1: PACKAGE BODY ASO_SHIPMENT_PVT as

1: PACKAGE BODY ASO_SHIPMENT_PVT as
2: /* $Header: asovshpb.pls 120.3 2006/10/25 18:04:21 skulkarn ship $ */
3: --
4: -- NAME
5: -- ASO_SHIPMENT_PVT

Line 5: -- ASO_SHIPMENT_PVT

1: PACKAGE BODY ASO_SHIPMENT_PVT as
2: /* $Header: asovshpb.pls 120.3 2006/10/25 18:04:21 skulkarn ship $ */
3: --
4: -- NAME
5: -- ASO_SHIPMENT_PVT
6: --
7: -- HISTORY
8: --
9:

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_SHIPMENT_PVT';

6: --
7: -- HISTORY
8: --
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_SHIPMENT_PVT';
11:
12: PROCEDURE Delete_shipment(
13: P_Api_Version_Number IN NUMBER,
14: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 1407: END ASO_SHIPMENT_PVT;

1403: return l_ship_to_cust_account_id;
1404:
1405: End Get_ship_to_cust_account_id;
1406:
1407: END ASO_SHIPMENT_PVT;