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.AHL_OSP_SHIPMENT_PUB dependencies on FND_PROFILE

Line 404: IF (FND_PROFILE.VALUE('AHL_OSP_OE_MIXED_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') = '') THEN

400: END IF;
401:
402: -- Start processing
403:
404: IF (FND_PROFILE.VALUE('AHL_OSP_OE_MIXED_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') = '') THEN
405: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
406: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Mixed Order Type ID');
407: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_MIXED_ID'));
408: FND_MSG_PUB.ADD;

Line 415: IF (FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID') = '' ) THEN

411: END IF;
412: RAISE Fnd_Api.g_exc_error;
413: END IF;
414:
415: IF (FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID') = '' ) THEN
416: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
417: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Ship Only Line Type ID');
418: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_SHIP_ONLY_ID'));
419: FND_MSG_PUB.ADD;

Line 426: IF (FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') = '') THEN

422: END IF;
423: RAISE Fnd_Api.g_exc_error;
424: END IF;
425:
426: IF (FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') = '') THEN
427: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
428: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Return Line Type ID');
429: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_RETURN_ID'));
430: FND_MSG_PUB.ADD;

Line 648: IF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN

644: FOR i IN p_x_lines_tbl.FIRST..p_x_lines_tbl.LAST LOOP
645: IF (p_x_lines_tbl(i).operation = 'C') THEN
646: -- Update the line_id
647: p_x_lines_tbl(i).line_id := x_line_tbl(i).line_id;
648: IF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN
649: l_line_type := 'ORDER';
650: ELSIF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN
651: l_line_type := 'RETURN';
652: END IF;

Line 650: ELSIF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN

646: -- Update the line_id
647: p_x_lines_tbl(i).line_id := x_line_tbl(i).line_id;
648: IF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN
649: l_line_type := 'ORDER';
650: ELSIF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN
651: l_line_type := 'RETURN';
652: END IF;
653:
654: IF p_x_lines_tbl(i).csi_item_instance_id IS NOT NULL THEN

Line 693: IF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN

689:
690: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
691: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call Update_OSP_Order_Lines');
692: END IF;
693: IF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN
694: Update_OSP_Order_Lines(
695: p_osp_order_id => p_x_lines_tbl(i).osp_order_id,
696: p_item_instance_id => p_x_lines_tbl(i).csi_item_instance_id,
697: p_oe_ship_line_id => p_x_lines_tbl(i).line_id,

Line 699: ELSIF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN

695: p_osp_order_id => p_x_lines_tbl(i).osp_order_id,
696: p_item_instance_id => p_x_lines_tbl(i).csi_item_instance_id,
697: p_oe_ship_line_id => p_x_lines_tbl(i).line_id,
698: p_oe_return_line_id => FND_API.G_MISS_NUM);
699: ELSIF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN
700: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
701: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Calling Update_OSP_Order_Lines with p_oe_return_line_id = ' || p_x_lines_tbl(i).line_id );
702: END IF;
703: Update_OSP_Order_Lines(

Line 716: IF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN

712: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
713: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call Update_OSP_Order_Lines');
714: END IF;
715: IF p_x_lines_tbl(i).osp_line_id IS NOT NULL THEN
716: IF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN
717: Update_OSP_Order_Lines(
718: p_osp_order_id => p_x_lines_tbl(i).osp_order_id,
719: p_osp_line_id => p_x_lines_tbl(i).osp_line_id,
720: p_oe_ship_line_id => p_x_lines_tbl(i).line_id,

Line 722: ELSIF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN

718: p_osp_order_id => p_x_lines_tbl(i).osp_order_id,
719: p_osp_line_id => p_x_lines_tbl(i).osp_line_id,
720: p_oe_ship_line_id => p_x_lines_tbl(i).line_id,
721: p_oe_return_line_id => FND_API.G_MISS_NUM);
722: ELSIF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN
723: --mpothuku modified on 14-Sep-2007 to fix the Bug 6398921
724: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
725: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'p_x_lines_tbl(i).order_type :' ||p_x_lines_tbl(i).order_type);
726: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'p_x_lines_tbl(i).line_id :' ||p_x_lines_tbl(i).line_id);

Line 1548: FROM fnd_profile_options_vl

1544: RETURN VARCHAR2
1545: IS
1546: CURSOR get_user_prf_opt_name_csr(c_prf_opt_name IN VARCHAR2) IS
1547: SELECT USER_PROFILE_OPTION_NAME
1548: FROM fnd_profile_options_vl
1549: WHERE profile_option_name = c_prf_opt_name;
1550:
1551: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.get_user_profile_option_name';
1552: l_usr_prf_opt_name VARCHAR2(240);

Line 1610: -- AND def.operating_unit = FND_PROFILE.VALUE('DEFAULT_ORG_ID')

1606: SELECT org.organization_id
1607: FROM OE_SHIP_FROM_ORGS_V org, inv_organization_info_v def
1608: WHERE org.organization_id = def.organization_id
1609: -- Changed by jaramana on Sep 9, 2005 for MOAC Uptake
1610: -- AND def.operating_unit = FND_PROFILE.VALUE('DEFAULT_ORG_ID')
1611: AND def.operating_unit = MO_GLOBAL.get_current_org_id()
1612: AND org.name = p_name;
1613:
1614: CURSOR ahl_sold_to_orgs_csr(p_cust_number IN VARCHAR2) IS

Line 1908: x_header_rec.shipment_priority_code := FND_PROFILE.VALUE('AHL_OSP_OE_SHIPMENT_PRIORITY');

1904: x_header_rec.freight_terms_code := FND_API.G_MISS_CHAR;
1905: x_header_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
1906: x_header_rec.fob_point_code := FND_API.G_MISS_CHAR;
1907: -- Get this from the profile
1908: x_header_rec.shipment_priority_code := FND_PROFILE.VALUE('AHL_OSP_OE_SHIPMENT_PRIORITY');
1909: END IF;
1910:
1911: /*
1912: -- JR: Coded on 8/19/2003 as fix for Bug 3095543

Line 1947: x_header_rec.tax_exempt_reason_code := FND_PROFILE.VALUE('AHL_OSP_TAX_EXEMPT_REASON');

1943: END IF;
1944: IF x_header_rec.tax_exempt_flag IS NULL THEN
1945: IF (p_header_rec.operation = 'C') THEN
1946: x_header_rec.tax_exempt_flag := 'E'; -- Default is Exempted.
1947: x_header_rec.tax_exempt_reason_code := FND_PROFILE.VALUE('AHL_OSP_TAX_EXEMPT_REASON');
1948: END IF;
1949: END IF;
1950: x_header_rec.shipping_instructions := p_header_rec.shipping_instructions;
1951: x_header_rec.packing_instructions := p_header_rec.packing_instructions;

Line 1965: x_header_rec.order_type_id := FND_PROFILE.VALUE('AHL_OSP_OE_MIXED_ID');

1961: CLOSE ahl_trxn_curr_code_csr;
1962:
1963: --Set the ORDER_TYPE to 'MIXED'
1964: IF (p_header_rec.operation = 'C') THEN
1965: x_header_rec.order_type_id := FND_PROFILE.VALUE('AHL_OSP_OE_MIXED_ID');
1966:
1967: x_header_rec.ordered_date := sysdate;
1968: x_header_rec.pricing_date := sysdate;
1969: END IF;

Line 2695: IF (FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') IS NULL OR FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') = '') THEN

2691: END IF;
2692:
2693: IF l_service_duration is null THEN
2694: -- Check if the Default Duration Profile has been Set
2695: IF (FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') IS NULL OR FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') = '') THEN
2696: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
2697: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: Vendor Service Duration');
2698: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_VENDOR_SERVICE_DURATION'));
2699: FND_MSG_PUB.ADD;

Line 2706: l_service_duration := FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION');

2702: END IF;
2703: RAISE Fnd_Api.g_exc_error;
2704: END IF;
2705:
2706: l_service_duration := FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION');
2707:
2708: END IF;
2709: -- yazhou 31-Jul-2006 ends
2710:

Line 2772: ((p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) AND

2768: -- Bug fix#5189285
2769:
2770: -- For Exchange Order Return lines, use the exchange instance id instead
2771: IF (p_x_line_tbl(i).operation <> 'D') AND
2772: ((p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) AND
2773: (p_x_line_tbl(i).order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE)) THEN
2774:
2775: -- yazhou 26-Apr-2006 ends
2776: /*

Line 2946: IF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN

2942: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2943: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Not a Shipment Delete Operation');
2944: END IF;
2945:
2946: IF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN
2947: -- Ship-Only Line
2948: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2949: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Processing a Ship-Only Line');
2950: END IF;

Line 3035: ELSIF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN

3031: END IF; -- Return Date < Ship Date
3032: END IF; -- Borrow or Exchange or Other
3033: END IF; -- Return Date is not null
3034: CLOSE ahl_oe_schedule_date_csr;
3035: ELSIF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN
3036: -- Return Line
3037: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3038: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Processing a Return Line');
3039: END IF;

Line 3056: p_x_line_tbl(i).return_reason_code := FND_PROFILE.VALUE('AHL_OSP_OE_LINE_RET_REASON_CODE');

3052:
3053: END IF; -- If Return Date is not Set
3054:
3055: IF p_x_line_tbl(i).return_reason_code IS NULL THEN
3056: p_x_line_tbl(i).return_reason_code := FND_PROFILE.VALUE('AHL_OSP_OE_LINE_RET_REASON_CODE');
3057: END IF;
3058:
3059: -- For Create only, check that no previous oe return line exists for this job
3060: --yazhou 06-Jun-2006 starts

Line 3173: ((p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) AND

3169: -- Bug fix#5189285
3170:
3171: -- For Exchange Order Return lines, use the exchange instance id instead
3172: IF (p_x_line_tbl(i).operation <> 'D') AND
3173: ((p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) AND
3174: (p_x_line_tbl(i).order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE)) THEN
3175:
3176: -- yazhou 26-Apr-2006 ends
3177:

Line 3348: IF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN

3344: IF (p_x_line_tbl(i).operation <> 'D') THEN
3345: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3346: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Not a Shipment Delete Operation');
3347: END IF;
3348: IF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN
3349: -- Ship-Only Line
3350: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3351: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Processing a Ship-Only Line');
3352: END IF;

Line 3452: ELSIF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN

3448: END IF; -- Return Date < Ship Date
3449: END IF; -- Borrow or Exchange or Other
3450: END IF; -- Return Date is not null
3451: CLOSE ahl_oe_Inv_schedule_date_csr;
3452: ELSIF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN
3453: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3454: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Processing a Return Line');
3455: END IF;
3456: IF (p_x_line_tbl(i).schedule_ship_date IS NULL OR p_x_line_tbl(i).schedule_ship_date = FND_API.G_MISS_DATE) THEN

Line 3472: p_x_line_tbl(i).return_reason_code := FND_PROFILE.VALUE('AHL_OSP_OE_LINE_RET_REASON_CODE');

3468:
3469: END IF; -- If Return Date is not Set
3470:
3471: IF p_x_line_tbl(i).return_reason_code IS NULL THEN
3472: p_x_line_tbl(i).return_reason_code := FND_PROFILE.VALUE('AHL_OSP_OE_LINE_RET_REASON_CODE');
3473: END IF;
3474:
3475: --For Create only, check that no previous oe return line exists for the Item
3476: --yazhou 06-Jun-2006 starts

Line 3562: IF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN

3558: Fnd_Msg_Pub.ADD;
3559: RAISE Fnd_Api.g_exc_error;
3560: END IF;
3561:
3562: IF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN
3563: p_x_line_tbl(i).line_type := 'SHIP';
3564: ELSIF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN
3565: p_x_line_tbl(i).line_type := 'RETURN';
3566: ELSE

Line 3564: ELSIF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN

3560: END IF;
3561:
3562: IF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN
3563: p_x_line_tbl(i).line_type := 'SHIP';
3564: ELSIF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN
3565: p_x_line_tbl(i).line_type := 'RETURN';
3566: ELSE
3567: Fnd_Message.set_name('AHL', 'AHL_OSP_LINE_TYPE_NULL');
3568: Fnd_Msg_Pub.ADD;

Line 3648: p_x_line_tbl(l_index).line_type_id := FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID');

3644: p_x_line_tbl(l_index).line_id := NULL;
3645: p_x_line_tbl(l_index).line_number := NULL;
3646: p_x_line_tbl(l_index).header_id := l_osp_header_det.OE_HEADER_ID;
3647: p_x_line_tbl(l_index).order_type := l_osp_header_det.ORDER_TYPE_CODE;
3648: p_x_line_tbl(l_index).line_type_id := FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID');
3649: p_x_line_tbl(l_index).line_type := 'RETURN';
3650: p_x_line_tbl(l_index).operation := 'C';
3651: /* NOTE: Exchange Order is handled in a special way below
3652: after the ship-only lines are created*/

Line 3665: p_x_line_tbl(l_index).return_reason_code := FND_PROFILE.VALUE('AHL_OSP_OE_LINE_RET_REASON_CODE');

3661: p_x_line_tbl(l_index).ordered_quantity := I.INVENTORY_ITEM_QUANTITY;
3662: p_x_line_tbl(l_index).order_quantity_uom := I.INVENTORY_ITEM_UOM;
3663:
3664: -- Default the Return Reason from the Profile
3665: p_x_line_tbl(l_index).return_reason_code := FND_PROFILE.VALUE('AHL_OSP_OE_LINE_RET_REASON_CODE');
3666: IF p_x_line_tbl(l_index).return_reason_code IS NULL THEN
3667: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
3668: -- @@@@@ jaramana June 4, 2004: May become a translation issue
3669: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OM Line Return Reason');

Line 3693: IF (FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') IS NULL OR FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') = '') THEN

3689: END IF;
3690:
3691: IF l_service_duration is null THEN
3692: -- Check if the Default Duration Profile has been Set
3693: IF (FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') IS NULL OR FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') = '') THEN
3694: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
3695: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: Vendor Service Duration');
3696: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_VENDOR_SERVICE_DURATION'));
3697: FND_MSG_PUB.ADD;

Line 3704: l_service_duration := FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION');

3700: END IF;
3701: RAISE Fnd_Api.g_exc_error;
3702: END IF;
3703:
3704: l_service_duration := FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION');
3705:
3706: END IF;
3707:
3708:

Line 3826: p_x_line_tbl(l_ship_index).line_type_id:=FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID');

3822: END IF;
3823:
3824: -- Copy all the details about from the Return Line
3825: p_x_line_tbl(l_ship_index) := p_x_line_tbl(l_index);
3826: p_x_line_tbl(l_ship_index).line_type_id:=FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID');
3827: p_x_line_tbl(l_ship_index).line_type:='SHIP';
3828: p_x_line_tbl(l_ship_index).return_reason_code:=NULL;
3829:
3830: IF p_x_line_tbl(l_ship_index).order_type = 'BORROW' THEN

Line 3907: -- AND def.operating_unit = FND_PROFILE.VALUE('DEFAULT_ORG_ID')

3903: SELECT org.organization_id
3904: FROM OE_SHIP_FROM_ORGS_V org, inv_organization_info_v def
3905: WHERE org.organization_id = def.organization_id
3906: -- Changed by jaramana on Sep 9, 2005 for MOAC Uptake
3907: -- AND def.operating_unit = FND_PROFILE.VALUE('DEFAULT_ORG_ID')
3908: AND def.operating_unit = MO_GLOBAL.get_current_org_id()
3909: AND org.name = p_name;
3910:
3911: CURSOR ahl_oe_lot_serial_id (p_oe_line_id IN NUMBER) IS

Line 4084: IF (p_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') AND

4080: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
4081: END IF;
4082:
4083: -- NEED TO FIX: 'Return'
4084: IF (p_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') AND
4085: p_line_tbl(i).serial_number IS NOT NULL AND
4086: p_line_tbl(i).serial_number <> FND_API.G_MISS_CHAR) THEN
4087: IF (p_line_tbl(i).operation = 'C') THEN
4088: l_lot_serial_rec := OE_ORDER_PUB.G_MISS_LOT_SERIAL_REC;

Line 5089: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_EXC_SHIP');

5085:
5086: -- get csi transaction ID for sub type based on OSP Order type
5087: IF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE THEN
5088: --l_subtxn_name := G_SUBTXN_EXC_ORDER; --for ER 4746426
5089: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_EXC_SHIP');
5090: IF l_subtxn_id IS NULL THEN
5091: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5092: --FND_MESSAGE.Set_Token('TYPE','Exchange Order Ship');
5093: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');

Line 5153: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_SER_SHIP');

5149: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, ' RELATIONSHIP_TYPE_CODE = ' || l_party_account_rec.RELATIONSHIP_TYPE_CODE);
5150: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, ' TXN_PARTY_DETAILS_INDEX = ' || l_party_account_rec.TXN_PARTY_DETAILS_INDEX);
5151: END IF;
5152: ELSIF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE THEN
5153: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_SER_SHIP');
5154: IF l_subtxn_id IS NULL THEN
5155: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5156: --FND_MESSAGE.Set_Token('TYPE','Service Order Ship');
5157: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');

Line 5165: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_BOR_SHIP');

5161: RETURN;
5162: END IF;
5163: ELSIF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_BORROW THEN
5164: --l_subtxn_name := G_SUBTXN_ORDER;
5165: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_BOR_SHIP');
5166: IF l_subtxn_id IS NULL THEN
5167: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5168: --FND_MESSAGE.Set_Token('TYPE','Borrow Order Ship');
5169: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');

Line 5208: l_subtxn_id := fnd_profile.VALUE('AHL_OSP_IB_SUBTXN_EXC_RETURN');

5204:
5205: -- get csi transaction ID for sub type based on OSP Order type
5206: IF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE THEN
5207: --l_subtxn_name := G_SUBTXN_EXC_RETURN; --for ER 4746426
5208: l_subtxn_id := fnd_profile.VALUE('AHL_OSP_IB_SUBTXN_EXC_RETURN');
5209: IF l_subtxn_id IS NULL THEN
5210: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5211: --FND_MESSAGE.Set_Token('TYPE','Exchange Order Return');
5212: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');

Line 5265: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_SER_RETURN');

5261: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, ' TXN_LINE_DETAILS_INDEX = ' || l_party_dtl_rec.TXN_LINE_DETAILS_INDEX);
5262: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, ' INSTANCE_PARTY_ID = ' || l_party_dtl_rec.INSTANCE_PARTY_ID);
5263: END IF;
5264: ELSIF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE THEN
5265: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_SER_RETURN');
5266: IF l_subtxn_id IS NULL THEN
5267: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5268: --FND_MESSAGE.Set_Token('TYPE','Service Order Return');
5269: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');

Line 5276: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_BOR_RETURN');

5272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5273: RETURN;
5274: END IF;
5275: ELSIF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_BORROW THEN
5276: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_BOR_RETURN');
5277: IF l_subtxn_id IS NULL THEN
5278: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5279: --FND_MESSAGE.Set_Token('TYPE','Borrow Order Return');
5280: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');