[Home] [Help]
43: WHERE site_use_id = p_hold_entity_id;
44: EXCEPTION
45: WHEN no_data_found then
46: --x_return_status := FND_API.G_RET_STS_ERROR;
47: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_SITE_USE_ID');
48: OE_MSG_PUB.ADD;
49: fnd_message.set_token('SITE_USE_ID',
50: to_char(p_hold_entity_id));
51: IF l_debug_level > 0 THEN
45: WHEN no_data_found then
46: --x_return_status := FND_API.G_RET_STS_ERROR;
47: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_SITE_USE_ID');
48: OE_MSG_PUB.ADD;
49: fnd_message.set_token('SITE_USE_ID',
50: to_char(p_hold_entity_id));
51: IF l_debug_level > 0 THEN
52: oe_debug_pub.add( 'HOLD_SITE_CODE:INVALID SITE USE ID' , 1 ) ;
53: END IF;
90: IF l_org_id IS NULL THEN
91: -- org_id is null, raise an error.
92: oe_debug_pub.add('Org_Id is NULL',1);
93: x_return_status := FND_API.G_RET_STS_ERROR ;
94: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
95: FND_MSG_PUB.ADD;
96: RAISE FND_API.G_EXC_ERROR;
97: END IF;
98:
516:
517:
518: EXCEPTION
519: WHEN FND_API.G_EXC_ERROR THEN
520: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTITY_NOT_ON_ORDER_OR_LINE');
521: OE_MSG_PUB.ADD;
522: IF l_debug_level > 0 THEN
523: oe_debug_pub.add( 'EXPECTED ERROR IN VALIDATEORDER' ) ;
524: END IF;
571: IF l_org_id IS NULL THEN
572: -- org_id is null, raise an error.
573: oe_debug_pub.add('Org_Id is NULL',1);
574: x_return_status := FND_API.G_RET_STS_ERROR;
575: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
576: FND_MSG_PUB.ADD;
577: RAISE FND_API.G_EXC_ERROR;
578: END IF;
579:
650: IF l_org_id IS NULL THEN
651: -- org_id is null, raise an error.
652: oe_debug_pub.add('Org_Id is NULL',1);
653: x_return_status := FND_API.G_RET_STS_ERROR;
654: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
655: FND_MSG_PUB.ADD;
656: RAISE FND_API.G_EXC_ERROR;
657: END IF;
658:
733: IF l_org_id IS NULL THEN
734: -- org_id is null, raise an error.
735: oe_debug_pub.add('Org_Id is NULL',1);
736: x_return_status := FND_API.G_RET_STS_ERROR;
737: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
738: FND_MSG_PUB.ADD;
739: RAISE FND_API.G_EXC_ERROR;
740: END IF;
741:
816: IF l_org_id IS NULL THEN
817: -- org_id is null, raise an error.
818: oe_debug_pub.add('Org_Id is NULL',1);
819: x_return_status := FND_API.G_RET_STS_ERROR;
820: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
821: FND_MSG_PUB.ADD;
822: RAISE FND_API.G_EXC_ERROR;
823: END IF;
824:
827:
828: for j in 1..p_order_tbl.COUNT loop
829: if p_order_tbl(j).header_id is NULL AND
830: p_order_tbl(j).line_id is NULL THEN
831: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTER_HEADER_OR_LINE_ID');
832: OE_MSG_PUB.ADD;
833: RAISE FND_API.G_EXC_ERROR;
834: ELSIF p_order_tbl(j).header_id is NULL THEN
835: SELECT header_id
945: IF l_org_id IS NULL THEN
946: -- org_id is null, raise an error.
947: oe_debug_pub.add('Org_Id is NULL',1);
948: x_return_status := FND_API.G_RET_STS_ERROR;
949: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
950: FND_MSG_PUB.ADD;
951: RAISE FND_API.G_EXC_ERROR;
952: END IF;
953:
991: WHEN NO_DATA_FOUND THEN
992: IF l_debug_level > 0 THEN
993: oe_debug_pub.add( 'INVALID HOLD SOURCE ID' ) ;
994: END IF;
995: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_HOLD_SOURCE_ID');
996: FND_MESSAGE.SET_TOKEN('HOLD_SOURCE_ID' , p_hold_source_id);
997: OE_MSG_PUB.ADD;
998: RAISE FND_API.G_EXC_ERROR;
999: END;
992: IF l_debug_level > 0 THEN
993: oe_debug_pub.add( 'INVALID HOLD SOURCE ID' ) ;
994: END IF;
995: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_HOLD_SOURCE_ID');
996: FND_MESSAGE.SET_TOKEN('HOLD_SOURCE_ID' , p_hold_source_id);
997: OE_MSG_PUB.ADD;
998: RAISE FND_API.G_EXC_ERROR;
999: END;
1000:
1005: -------------------------------------------------------------
1006: ELSE
1007: -- Check for Missing Values
1008: IF p_hold_source_rec.hold_id IS NULL THEN
1009: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD_ID');
1010: OE_MSG_PUB.ADD;
1011: RAISE FND_API.G_EXC_ERROR;
1012: END IF;
1013:
1011: RAISE FND_API.G_EXC_ERROR;
1012: END IF;
1013:
1014: IF p_hold_source_rec.hold_entity_code IS NULL THEN
1015: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_ENTITY_CODE');
1016: OE_MSG_PUB.ADD;
1017: RAISE FND_API.G_EXC_ERROR;
1018: END IF;
1019:
1017: RAISE FND_API.G_EXC_ERROR;
1018: END IF;
1019:
1020: IF p_hold_source_rec.hold_entity_id IS NULL THEN
1021: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_ENTITY_ID');
1022: OE_MSG_PUB.ADD;
1023: RAISE FND_API.G_EXC_ERROR;
1024: END IF;
1025: -- NOTE: No need to check for HOLD_ENTITY_CODE2 and HOLD_ENTITY_ID2
1041: END IF; -- END of check to see WHETHER HOLD SOURCE ID is passed.
1042: /*
1043: IF p_hold_source_rec.hold_entity_code = 'O' THEN
1044: IF p_line_id IS NULL AND p_header_id IS NULL THEN
1045: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTER_HEADER_OR_LINE_ID');
1046: OE_MSG_PUB.ADD;
1047: RAISE FND_API.G_EXC_ERROR;
1048: ELSIF p_header_id IS NULL THEN
1049: SELECT header_id
1068: AND HOLD_RELEASE_ID IS NULL
1069: AND ROWNUM = 1;
1070:
1071: IF (sql%found) THEN
1072: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
1073: OE_MSG_PUB.ADD;
1074: OE_Debug_PUB.Add('Duplicate Hold');
1075: RAISE FND_API.G_EXC_ERROR;
1076: END IF;
1760:
1761: -- Check for Missing Input Parameters
1762: IF p_header_id IS NULL AND p_line_id IS NULL THEN
1763:
1764: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTER_HEADER_OR_LINE_ID');
1765: OE_MSG_PUB.ADD;
1766: RAISE FND_API.G_EXC_ERROR;
1767:
1768: END IF;
2260: IF l_debug_level > 0 THEN
2261: oe_debug_pub.add( 'ENTER HOLD_ENTITY_CODE OR HOLD_ENTITY_ID' ) ;
2262: END IF;
2263: /* TO_DO: Seed a more meaningfull message */
2264: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
2265: OE_MSG_PUB.ADD;
2266: RAISE FND_API.G_EXC_ERROR;
2267:
2268: END IF;
2419: IF l_org_id IS NULL THEN
2420: -- org_id is null, raise an error.
2421: oe_debug_pub.add('Org_Id is NULL',1);
2422: x_return_status := FND_API.G_RET_STS_ERROR;
2423: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
2424: FND_MSG_PUB.ADD;
2425: RAISE FND_API.G_EXC_ERROR;
2426: END IF;
2427:
2454: WHERE hold_source_id = l_hold_source_id;
2455:
2456: EXCEPTION
2457: WHEN NO_DATA_FOUND THEN
2458: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD_SOURCE');
2459: OE_MSG_PUB.ADD;
2460: RAISE FND_API.G_EXC_ERROR;
2461: WHEN OTHERS THEN
2462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2465: -- Retrieving order hold information
2466: OPEN order_hold;
2467: FETCH order_hold INTO l_order_hold_id;
2468: IF order_hold%notfound THEN
2469: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD');
2470: OE_MSG_PUB.ADD;
2471: RAISE FND_API.G_EXC_ERROR;
2472: END IF;
2473: CLOSE order_hold;
2482: oe_debug_pub.add( 'HOLD SOURCE ID IS NOT PASSED' ) ;
2483: END IF;
2484: -- Check for Missing Values
2485: IF p_hold_id IS NULL THEN
2486: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD_ID');
2487: OE_MSG_PUB.ADD;
2488: RAISE FND_API.G_EXC_ERROR;
2489: END IF;
2490:
2488: RAISE FND_API.G_EXC_ERROR;
2489: END IF;
2490:
2491: IF p_entity_code IS NULL THEN
2492: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_ENTITY_CODE');
2493: OE_MSG_PUB.ADD;
2494: RAISE FND_API.G_EXC_ERROR;
2495: ELSE
2496: l_entity_code := p_entity_code;
2496: l_entity_code := p_entity_code;
2497: END IF;
2498:
2499: IF p_entity_id IS NULL THEN
2500: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_ENTITY_ID');
2501: OE_MSG_PUB.ADD;
2502: RAISE FND_API.G_EXC_ERROR;
2503: END IF;
2504:
2503: END IF;
2504:
2505: /*
2506: IF p_line_id IS NULL AND p_header_id IS NULL THEN
2507: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HEADER_AND_LINE_ID');
2508: OE_MSG_PUB.ADD;
2509: RAISE FND_API.G_EXC_ERROR;
2510: END IF;
2511: */
2514: /*
2515: OPEN hold_source;
2516: FETCH hold_source INTO l_hold_source_id, l_order_hold_id;
2517: IF hold_source%notfound THEN
2518: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD');
2519: OE_MSG_PUB.ADD;
2520: RAISE FND_API.G_EXC_ERROR;
2521: END IF;
2522: CLOSE hold_source;
2657: IF l_org_id IS NULL THEN
2658: -- org_id is null, raise an error.
2659: oe_debug_pub.add('Org_Id is NULL',1);
2660: x_return_status := FND_API.G_RET_STS_ERROR;
2661: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
2662: FND_MSG_PUB.ADD;
2663: RAISE FND_API.G_EXC_ERROR;
2664: END IF;
2665:
2672:
2673: IF (p_header_id = FND_API.G_MISS_NUM AND
2674: p_line_id = FND_API.G_MISS_NUM) THEN
2675:
2676: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTER_HEADER_OR_LINE_ID');
2677: OE_MSG_PUB.ADD;
2678: RAISE FND_API.G_EXC_ERROR;
2679:
2680: END IF;
3182: IF l_debug_level > 0 THEN
3183: oe_debug_pub.add( 'HOLD REMOVED' ) ;
3184: END IF;
3185: END IF; --ER#7479609
3186: --fnd_message.set_name('ONT','OE_HOLD_REMOVED');
3187: --OE_MSG_PUB.ADD;
3188: END LOOP;
3189: CLOSE prev_hold;
3190:
3248: IF l_debug_level > 0 THEN
3249: oe_debug_pub.add( 'HOLD REMOVED FOR SECOND ENTITY' ) ;
3250: END IF;
3251: END IF; --ER#7479609
3252: --fnd_message.set_name('ONT','OE_HOLD_REMOVED');
3253: --OE_MSG_PUB.ADD;
3254: END LOOP;
3255: CLOSE prev_hold_entity2;
3256:
3608: END IF;
3609: end if;
3610:
3611: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
3612: fnd_message.set_name('ONT','OE_HLD_APPLIED');
3613: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
3614: OE_MSG_PUB.ADD;
3615: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
3616: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
3609: end if;
3610:
3611: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
3612: fnd_message.set_name('ONT','OE_HLD_APPLIED');
3613: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
3614: OE_MSG_PUB.ADD;
3615: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
3616: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
3617: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN
3614: OE_MSG_PUB.ADD;
3615: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
3616: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
3617: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN
3618: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
3619: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
3620: -- Get the line number from the line record
3621: --SELECT line_number
3622: -- INTO l_line_number
3615: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
3616: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
3617: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN
3618: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
3619: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
3620: -- Get the line number from the line record
3621: --SELECT line_number
3622: -- INTO l_line_number
3623: -- FROM OE_ORDER_LINES
3621: --SELECT line_number
3622: -- INTO l_line_number
3623: -- FROM OE_ORDER_LINES
3624: -- WHERE LINE_ID = p_entity_id;
3625: --FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3626: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3627: OE_MSG_PUB.ADD;
3628: END IF;
3629: END IF; -- if create_order_hold was successful
3622: -- INTO l_line_number
3623: -- FROM OE_ORDER_LINES
3624: -- WHERE LINE_ID = p_entity_id;
3625: --FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3626: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3627: OE_MSG_PUB.ADD;
3628: END IF;
3629: END IF; -- if create_order_hold was successful
3630: END IF; -- l_create_order_hold_flag = 'Y'
3877: END IF;
3878: end if;
3879:
3880: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
3881: fnd_message.set_name('ONT','OE_HLD_APPLIED');
3882: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
3883: OE_MSG_PUB.ADD;
3884: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
3885: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
3878: end if;
3879:
3880: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
3881: fnd_message.set_name('ONT','OE_HLD_APPLIED');
3882: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
3883: OE_MSG_PUB.ADD;
3884: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
3885: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
3886: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN --ER#7479609
3883: OE_MSG_PUB.ADD;
3884: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
3885: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
3886: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN --ER#7479609
3887: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
3888: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
3889: -- Get the line number from the line record
3890: --SELECT line_number
3891: -- INTO l_line_number
3884: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
3885: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
3886: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN --ER#7479609
3887: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
3888: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
3889: -- Get the line number from the line record
3890: --SELECT line_number
3891: -- INTO l_line_number
3892: -- FROM OE_ORDER_LINES
3890: --SELECT line_number
3891: -- INTO l_line_number
3892: -- FROM OE_ORDER_LINES
3893: -- WHERE LINE_ID = p_entity_id;
3894: --FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3895: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3896: OE_MSG_PUB.ADD;
3897: END IF;
3898: END IF; -- if apply hold was successful
3891: -- INTO l_line_number
3892: -- FROM OE_ORDER_LINES
3893: -- WHERE LINE_ID = p_entity_id;
3894: --FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3895: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3896: OE_MSG_PUB.ADD;
3897: END IF;
3898: END IF; -- if apply hold was successful
3899: END IF; -- l_create_order_hold_flag = 'Y'
4100:
4101: l_attribute := 'Customer';
4102:
4103:
4104: fnd_message.set_name('ONT','OE_HLD_APPLIED');
4105: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4106: OE_MSG_PUB.ADD;
4107: END IF; -- if create_order_hold was successful
4108: END LOOP;
4101: l_attribute := 'Customer';
4102:
4103:
4104: fnd_message.set_name('ONT','OE_HLD_APPLIED');
4105: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4106: OE_MSG_PUB.ADD;
4107: END IF; -- if create_order_hold was successful
4108: END LOOP;
4109: CLOSE curr_hold_source;
4779: end if;
4780:
4781:
4782: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
4783: fnd_message.set_name('ONT','OE_HLD_APPLIED');
4784: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4785: OE_MSG_PUB.ADD;
4786: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
4787: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
4780:
4781:
4782: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
4783: fnd_message.set_name('ONT','OE_HLD_APPLIED');
4784: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4785: OE_MSG_PUB.ADD;
4786: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
4787: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
4788: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4783: fnd_message.set_name('ONT','OE_HLD_APPLIED');
4784: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4785: OE_MSG_PUB.ADD;
4786: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
4787: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
4788: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4789: --ER#7479609 FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
4790: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_rec.line_number); --ER#7479609
4791: OE_MSG_PUB.ADD;
4784: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4785: OE_MSG_PUB.ADD;
4786: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
4787: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
4788: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4789: --ER#7479609 FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
4790: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_rec.line_number); --ER#7479609
4791: OE_MSG_PUB.ADD;
4792: END IF;
4785: OE_MSG_PUB.ADD;
4786: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
4787: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
4788: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4789: --ER#7479609 FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
4790: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_rec.line_number); --ER#7479609
4791: OE_MSG_PUB.ADD;
4792: END IF;
4793:
4786: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
4787: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
4788: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4789: --ER#7479609 FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
4790: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_rec.line_number); --ER#7479609
4791: OE_MSG_PUB.ADD;
4792: END IF;
4793:
4794: END IF; -- if create_order_hold was successful
4907: END IF;
4908: end if;
4909:
4910: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
4911: fnd_message.set_name('ONT','OE_HLD_APPLIED');
4912: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4913: OE_MSG_PUB.ADD;
4914: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
4915: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
4908: end if;
4909:
4910: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
4911: fnd_message.set_name('ONT','OE_HLD_APPLIED');
4912: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4913: OE_MSG_PUB.ADD;
4914: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
4915: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
4916: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4911: fnd_message.set_name('ONT','OE_HLD_APPLIED');
4912: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4913: OE_MSG_PUB.ADD;
4914: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
4915: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
4916: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4917: -- Get the line number from the line record
4918: --SELECT line_number
4919: -- INTO l_line_number
4912: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4913: OE_MSG_PUB.ADD;
4914: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
4915: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
4916: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4917: -- Get the line number from the line record
4918: --SELECT line_number
4919: -- INTO l_line_number
4920: -- FROM OE_ORDER_LINES
4918: --SELECT line_number
4919: -- INTO l_line_number
4920: -- FROM OE_ORDER_LINES
4921: -- WHERE LINE_ID = p_entity_id;
4922: --FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
4923: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
4924: OE_MSG_PUB.ADD;
4925: END IF;
4926: END IF; -- if apply hold was successful
4919: -- INTO l_line_number
4920: -- FROM OE_ORDER_LINES
4921: -- WHERE LINE_ID = p_entity_id;
4922: --FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
4923: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
4924: OE_MSG_PUB.ADD;
4925: END IF;
4926: END IF; -- if apply hold was successful
4927: END IF; -- l_create_order_hold_flag = 'Y'
5241: END IF;
5242: EXCEPTION
5243: WHEN no_data_found then
5244: --x_return_status := FND_API.G_RET_STS_ERROR;
5245: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_SITE_USE_ID');
5246: OE_MSG_PUB.ADD;
5247: fnd_message.set_token('SITE_USE_ID', to_char(p_hold_entity_id));
5248:
5249: RAISE FND_API.G_EXC_ERROR;
5243: WHEN no_data_found then
5244: --x_return_status := FND_API.G_RET_STS_ERROR;
5245: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_SITE_USE_ID');
5246: OE_MSG_PUB.ADD;
5247: fnd_message.set_token('SITE_USE_ID', to_char(p_hold_entity_id));
5248:
5249: RAISE FND_API.G_EXC_ERROR;
5250: END;
5251:
5385:
5386: SAVEPOINT oe_process_holds;
5387:
5388: IF p_action IS NULL OR p_action NOT IN ('APPLY','RELEASE') THEN
5389: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ACTION'); -- message taken from oe_holds
5390: fnd_message.set_token('ACTION',p_action);
5391: OE_MSG_PUB.ADD;
5392: RAISE FND_API.G_EXC_ERROR;
5393: END IF;
5386: SAVEPOINT oe_process_holds;
5387:
5388: IF p_action IS NULL OR p_action NOT IN ('APPLY','RELEASE') THEN
5389: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ACTION'); -- message taken from oe_holds
5390: fnd_message.set_token('ACTION',p_action);
5391: OE_MSG_PUB.ADD;
5392: RAISE FND_API.G_EXC_ERROR;
5393: END IF;
5394:
5392: RAISE FND_API.G_EXC_ERROR;
5393: END IF;
5394:
5395: IF p_hold_entity_code IS NULL OR p_hold_entity_code NOT IN ('S','C') THEN
5396: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_HOLD_ENTITY_CODE'); -- message need to be seeded or use any existing one
5397: OE_MSG_PUB.ADD;
5398: RAISE FND_API.G_EXC_ERROR;
5399: END IF;
5400: -- hold the original org id being used by programs when calling process_holds.
5435: FETCH c_valid_acct into l_valid_acct;
5436: CLOSE c_valid_acct;
5437:
5438: IF l_valid_acct <> 'Y' THEN
5439: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_CUST_ACCOUNT'); -- get the correct message new or existing??
5440: -- fnd_message.set_token('',p_action);
5441: OE_MSG_PUB.ADD;
5442: RAISE FND_API.G_EXC_ERROR;
5443: END IF;
5436: CLOSE c_valid_acct;
5437:
5438: IF l_valid_acct <> 'Y' THEN
5439: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_CUST_ACCOUNT'); -- get the correct message new or existing??
5440: -- fnd_message.set_token('',p_action);
5441: OE_MSG_PUB.ADD;
5442: RAISE FND_API.G_EXC_ERROR;
5443: END IF;
5444: