[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:
586:
587:
588: EXCEPTION
589: WHEN FND_API.G_EXC_ERROR THEN
590: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTITY_NOT_ON_ORDER_OR_LINE');
591: OE_MSG_PUB.ADD;
592: IF l_debug_level > 0 THEN
593: oe_debug_pub.add( 'EXPECTED ERROR IN VALIDATEORDER' ) ;
594: END IF;
645: IF l_org_id IS NULL THEN
646: -- org_id is null, raise an error.
647: oe_debug_pub.add('Org_Id is NULL',1);
648: x_return_status := FND_API.G_RET_STS_ERROR;
649: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
650: FND_MSG_PUB.ADD;
651: RAISE FND_API.G_EXC_ERROR;
652: END IF;
653:
729: IF l_org_id IS NULL THEN
730: -- org_id is null, raise an error.
731: oe_debug_pub.add('Org_Id is NULL',1);
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
734: FND_MSG_PUB.ADD;
735: RAISE FND_API.G_EXC_ERROR;
736: END IF;
737:
815: IF l_org_id IS NULL THEN
816: -- org_id is null, raise an error.
817: oe_debug_pub.add('Org_Id is NULL',1);
818: x_return_status := FND_API.G_RET_STS_ERROR;
819: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
820: FND_MSG_PUB.ADD;
821: RAISE FND_API.G_EXC_ERROR;
822: END IF;
823:
901: IF l_org_id IS NULL THEN
902: -- org_id is null, raise an error.
903: oe_debug_pub.add('Org_Id is NULL',1);
904: x_return_status := FND_API.G_RET_STS_ERROR;
905: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
906: FND_MSG_PUB.ADD;
907: RAISE FND_API.G_EXC_ERROR;
908: END IF;
909:
912:
913: for j in 1..p_order_tbl.COUNT loop
914: if p_order_tbl(j).header_id is NULL AND
915: p_order_tbl(j).line_id is NULL THEN
916: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTER_HEADER_OR_LINE_ID');
917: OE_MSG_PUB.ADD;
918: RAISE FND_API.G_EXC_ERROR;
919: ELSIF p_order_tbl(j).header_id is NULL THEN
920: SELECT header_id
1033: IF l_org_id IS NULL THEN
1034: -- org_id is null, raise an error.
1035: oe_debug_pub.add('Org_Id is NULL',1);
1036: x_return_status := FND_API.G_RET_STS_ERROR;
1037: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
1038: FND_MSG_PUB.ADD;
1039: RAISE FND_API.G_EXC_ERROR;
1040: END IF;
1041:
1079: WHEN NO_DATA_FOUND THEN
1080: IF l_debug_level > 0 THEN
1081: oe_debug_pub.add( 'INVALID HOLD SOURCE ID' ) ;
1082: END IF;
1083: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_HOLD_SOURCE_ID');
1084: FND_MESSAGE.SET_TOKEN('HOLD_SOURCE_ID' , p_hold_source_id);
1085: OE_MSG_PUB.ADD;
1086: RAISE FND_API.G_EXC_ERROR;
1087: END;
1080: IF l_debug_level > 0 THEN
1081: oe_debug_pub.add( 'INVALID HOLD SOURCE ID' ) ;
1082: END IF;
1083: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_HOLD_SOURCE_ID');
1084: FND_MESSAGE.SET_TOKEN('HOLD_SOURCE_ID' , p_hold_source_id);
1085: OE_MSG_PUB.ADD;
1086: RAISE FND_API.G_EXC_ERROR;
1087: END;
1088:
1093: -------------------------------------------------------------
1094: ELSE
1095: -- Check for Missing Values
1096: IF p_hold_source_rec.hold_id IS NULL THEN
1097: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD_ID');
1098: OE_MSG_PUB.ADD;
1099: RAISE FND_API.G_EXC_ERROR;
1100: END IF;
1101:
1099: RAISE FND_API.G_EXC_ERROR;
1100: END IF;
1101:
1102: IF p_hold_source_rec.hold_entity_code IS NULL THEN
1103: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_ENTITY_CODE');
1104: OE_MSG_PUB.ADD;
1105: RAISE FND_API.G_EXC_ERROR;
1106: END IF;
1107:
1105: RAISE FND_API.G_EXC_ERROR;
1106: END IF;
1107:
1108: IF p_hold_source_rec.hold_entity_id IS NULL THEN
1109: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_ENTITY_ID');
1110: OE_MSG_PUB.ADD;
1111: RAISE FND_API.G_EXC_ERROR;
1112: END IF;
1113: -- NOTE: No need to check for HOLD_ENTITY_CODE2 and HOLD_ENTITY_ID2
1129: END IF; -- END of check to see WHETHER HOLD SOURCE ID is passed.
1130: /*
1131: IF p_hold_source_rec.hold_entity_code = 'O' THEN
1132: IF p_line_id IS NULL AND p_header_id IS NULL THEN
1133: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTER_HEADER_OR_LINE_ID');
1134: OE_MSG_PUB.ADD;
1135: RAISE FND_API.G_EXC_ERROR;
1136: ELSIF p_header_id IS NULL THEN
1137: SELECT header_id
1156: AND HOLD_RELEASE_ID IS NULL
1157: AND ROWNUM = 1;
1158:
1159: IF (sql%found) THEN
1160: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
1161: OE_MSG_PUB.ADD;
1162: OE_Debug_PUB.Add('Duplicate Hold');
1163: RAISE FND_API.G_EXC_ERROR;
1164: END IF;
1849:
1850: -- Check for Missing Input Parameters
1851: IF p_header_id IS NULL AND p_line_id IS NULL THEN
1852:
1853: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTER_HEADER_OR_LINE_ID');
1854: OE_MSG_PUB.ADD;
1855: RAISE FND_API.G_EXC_ERROR;
1856:
1857: END IF;
2349: IF l_debug_level > 0 THEN
2350: oe_debug_pub.add( 'ENTER HOLD_ENTITY_CODE OR HOLD_ENTITY_ID' ) ;
2351: END IF;
2352: /* TO_DO: Seed a more meaningfull message */
2353: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
2354: OE_MSG_PUB.ADD;
2355: RAISE FND_API.G_EXC_ERROR;
2356:
2357: END IF;
2510: IF l_org_id IS NULL THEN
2511: -- org_id is null, raise an error.
2512: oe_debug_pub.add('Org_Id is NULL',1);
2513: x_return_status := FND_API.G_RET_STS_ERROR;
2514: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
2515: FND_MSG_PUB.ADD;
2516: RAISE FND_API.G_EXC_ERROR;
2517: END IF;
2518:
2545: WHERE hold_source_id = l_hold_source_id;
2546:
2547: EXCEPTION
2548: WHEN NO_DATA_FOUND THEN
2549: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD_SOURCE');
2550: OE_MSG_PUB.ADD;
2551: RAISE FND_API.G_EXC_ERROR;
2552: WHEN OTHERS THEN
2553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2556: -- Retrieving order hold information
2557: OPEN order_hold;
2558: FETCH order_hold INTO l_order_hold_id;
2559: IF order_hold%notfound THEN
2560: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD');
2561: OE_MSG_PUB.ADD;
2562: RAISE FND_API.G_EXC_ERROR;
2563: END IF;
2564: CLOSE order_hold;
2573: oe_debug_pub.add( 'HOLD SOURCE ID IS NOT PASSED' ) ;
2574: END IF;
2575: -- Check for Missing Values
2576: IF p_hold_id IS NULL THEN
2577: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD_ID');
2578: OE_MSG_PUB.ADD;
2579: RAISE FND_API.G_EXC_ERROR;
2580: END IF;
2581:
2579: RAISE FND_API.G_EXC_ERROR;
2580: END IF;
2581:
2582: IF p_entity_code IS NULL THEN
2583: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_ENTITY_CODE');
2584: OE_MSG_PUB.ADD;
2585: RAISE FND_API.G_EXC_ERROR;
2586: ELSE
2587: l_entity_code := p_entity_code;
2587: l_entity_code := p_entity_code;
2588: END IF;
2589:
2590: IF p_entity_id IS NULL THEN
2591: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_ENTITY_ID');
2592: OE_MSG_PUB.ADD;
2593: RAISE FND_API.G_EXC_ERROR;
2594: END IF;
2595:
2594: END IF;
2595:
2596: /*
2597: IF p_line_id IS NULL AND p_header_id IS NULL THEN
2598: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HEADER_AND_LINE_ID');
2599: OE_MSG_PUB.ADD;
2600: RAISE FND_API.G_EXC_ERROR;
2601: END IF;
2602: */
2605: /*
2606: OPEN hold_source;
2607: FETCH hold_source INTO l_hold_source_id, l_order_hold_id;
2608: IF hold_source%notfound THEN
2609: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD');
2610: OE_MSG_PUB.ADD;
2611: RAISE FND_API.G_EXC_ERROR;
2612: END IF;
2613: CLOSE hold_source;
2749: IF l_org_id IS NULL THEN
2750: -- org_id is null, raise an error.
2751: oe_debug_pub.add('Org_Id is NULL',1);
2752: x_return_status := FND_API.G_RET_STS_ERROR;
2753: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
2754: FND_MSG_PUB.ADD;
2755: RAISE FND_API.G_EXC_ERROR;
2756: END IF;
2757:
2764:
2765: IF (p_header_id = FND_API.G_MISS_NUM AND
2766: p_line_id = FND_API.G_MISS_NUM) THEN
2767:
2768: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTER_HEADER_OR_LINE_ID');
2769: OE_MSG_PUB.ADD;
2770: RAISE FND_API.G_EXC_ERROR;
2771:
2772: END IF;
3312: IF l_debug_level > 0 THEN
3313: oe_debug_pub.add( 'HOLD REMOVED' ) ;
3314: END IF;
3315: END IF; --ER#7479609
3316: --fnd_message.set_name('ONT','OE_HOLD_REMOVED');
3317: --OE_MSG_PUB.ADD;
3318: END LOOP;
3319: CLOSE prev_hold;
3320:
3385: IF l_debug_level > 0 THEN
3386: oe_debug_pub.add( 'HOLD REMOVED FOR SECOND ENTITY' ) ;
3387: END IF;
3388: END IF; --ER#7479609
3389: --fnd_message.set_name('ONT','OE_HOLD_REMOVED');
3390: --OE_MSG_PUB.ADD;
3391: END LOOP;
3392: CLOSE prev_hold_entity2;
3393:
3803: END IF;
3804: end if;
3805:
3806: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
3807: fnd_message.set_name('ONT','OE_HLD_APPLIED');
3808: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
3809: OE_MSG_PUB.ADD;
3810: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
3811: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
3804: end if;
3805:
3806: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
3807: fnd_message.set_name('ONT','OE_HLD_APPLIED');
3808: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
3809: OE_MSG_PUB.ADD;
3810: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
3811: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
3812: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN
3809: OE_MSG_PUB.ADD;
3810: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
3811: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
3812: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN
3813: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
3814: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
3815: -- Get the line number from the line record
3816: --SELECT line_number
3817: -- INTO l_line_number
3810: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
3811: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
3812: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN
3813: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
3814: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
3815: -- Get the line number from the line record
3816: --SELECT line_number
3817: -- INTO l_line_number
3818: -- FROM OE_ORDER_LINES
3816: --SELECT line_number
3817: -- INTO l_line_number
3818: -- FROM OE_ORDER_LINES
3819: -- WHERE LINE_ID = p_entity_id;
3820: --FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3821: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_rec.line_number); --8254521
3822: OE_MSG_PUB.ADD;
3823: END IF;
3824: END IF; -- if create_order_hold was successful
3817: -- INTO l_line_number
3818: -- FROM OE_ORDER_LINES
3819: -- WHERE LINE_ID = p_entity_id;
3820: --FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3821: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_rec.line_number); --8254521
3822: OE_MSG_PUB.ADD;
3823: END IF;
3824: END IF; -- if create_order_hold was successful
3825: END IF; -- l_create_order_hold_flag = 'Y'
4135: END IF;
4136: end if;
4137:
4138: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
4139: fnd_message.set_name('ONT','OE_HLD_APPLIED');
4140: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4141: OE_MSG_PUB.ADD;
4142: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
4143: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
4136: end if;
4137:
4138: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
4139: fnd_message.set_name('ONT','OE_HLD_APPLIED');
4140: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4141: OE_MSG_PUB.ADD;
4142: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
4143: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
4144: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN --ER#7479609
4141: OE_MSG_PUB.ADD;
4142: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
4143: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
4144: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN --ER#7479609
4145: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
4146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4147: -- Get the line number from the line record
4148: --SELECT line_number
4149: -- INTO l_line_number
4142: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
4143: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
4144: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN --ER#7479609
4145: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
4146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4147: -- Get the line number from the line record
4148: --SELECT line_number
4149: -- INTO l_line_number
4150: -- FROM OE_ORDER_LINES
4148: --SELECT line_number
4149: -- INTO l_line_number
4150: -- FROM OE_ORDER_LINES
4151: -- WHERE LINE_ID = p_entity_id;
4152: --FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
4153: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_rec.line_number); --8254521
4154: OE_MSG_PUB.ADD;
4155: END IF;
4156: END IF; -- if apply hold was successful
4149: -- INTO l_line_number
4150: -- FROM OE_ORDER_LINES
4151: -- WHERE LINE_ID = p_entity_id;
4152: --FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
4153: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_rec.line_number); --8254521
4154: OE_MSG_PUB.ADD;
4155: END IF;
4156: END IF; -- if apply hold was successful
4157: END IF; -- l_create_order_hold_flag = 'Y'
4358:
4359: l_attribute := 'Customer';
4360:
4361:
4362: fnd_message.set_name('ONT','OE_HLD_APPLIED');
4363: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4364: OE_MSG_PUB.ADD;
4365: END IF; -- if create_order_hold was successful
4366: END LOOP;
4359: l_attribute := 'Customer';
4360:
4361:
4362: fnd_message.set_name('ONT','OE_HLD_APPLIED');
4363: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4364: OE_MSG_PUB.ADD;
4365: END IF; -- if create_order_hold was successful
4366: END LOOP;
4367: CLOSE curr_hold_source;
5305: end if;
5306:
5307:
5308: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
5309: fnd_message.set_name('ONT','OE_HLD_APPLIED');
5310: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
5311: OE_MSG_PUB.ADD;
5312: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
5313: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
5306:
5307:
5308: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
5309: fnd_message.set_name('ONT','OE_HLD_APPLIED');
5310: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
5311: OE_MSG_PUB.ADD;
5312: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
5313: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
5314: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
5309: fnd_message.set_name('ONT','OE_HLD_APPLIED');
5310: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
5311: OE_MSG_PUB.ADD;
5312: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
5313: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
5314: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
5315: --ER#7479609 FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
5316: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_rec.line_number); --ER#7479609
5317: OE_MSG_PUB.ADD;
5310: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
5311: OE_MSG_PUB.ADD;
5312: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
5313: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
5314: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
5315: --ER#7479609 FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
5316: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_rec.line_number); --ER#7479609
5317: OE_MSG_PUB.ADD;
5318: END IF;
5311: OE_MSG_PUB.ADD;
5312: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
5313: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
5314: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
5315: --ER#7479609 FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
5316: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_rec.line_number); --ER#7479609
5317: OE_MSG_PUB.ADD;
5318: END IF;
5319:
5312: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
5313: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
5314: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
5315: --ER#7479609 FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
5316: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_rec.line_number); --ER#7479609
5317: OE_MSG_PUB.ADD;
5318: END IF;
5319:
5320: END IF; -- if create_order_hold was successful
5439: END IF;
5440: end if;
5441:
5442: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
5443: fnd_message.set_name('ONT','OE_HLD_APPLIED');
5444: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
5445: OE_MSG_PUB.ADD;
5446: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
5447: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
5440: end if;
5441:
5442: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
5443: fnd_message.set_name('ONT','OE_HLD_APPLIED');
5444: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
5445: OE_MSG_PUB.ADD;
5446: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
5447: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
5448: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
5443: fnd_message.set_name('ONT','OE_HLD_APPLIED');
5444: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
5445: OE_MSG_PUB.ADD;
5446: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
5447: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
5448: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
5449: -- Get the line number from the line record
5450: --SELECT line_number
5451: -- INTO l_line_number
5444: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
5445: OE_MSG_PUB.ADD;
5446: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
5447: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
5448: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
5449: -- Get the line number from the line record
5450: --SELECT line_number
5451: -- INTO l_line_number
5452: -- FROM OE_ORDER_LINES
5450: --SELECT line_number
5451: -- INTO l_line_number
5452: -- FROM OE_ORDER_LINES
5453: -- WHERE LINE_ID = p_entity_id;
5454: --FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
5455: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_rec.line_number); --8254521
5456: OE_MSG_PUB.ADD;
5457: END IF;
5458: END IF; -- if apply hold was successful
5451: -- INTO l_line_number
5452: -- FROM OE_ORDER_LINES
5453: -- WHERE LINE_ID = p_entity_id;
5454: --FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
5455: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_rec.line_number); --8254521
5456: OE_MSG_PUB.ADD;
5457: END IF;
5458: END IF; -- if apply hold was successful
5459: END IF; -- l_create_order_hold_flag = 'Y'
5788: END IF;
5789: EXCEPTION
5790: WHEN no_data_found then
5791: --x_return_status := FND_API.G_RET_STS_ERROR;
5792: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_SITE_USE_ID');
5793: OE_MSG_PUB.ADD;
5794: fnd_message.set_token('SITE_USE_ID', to_char(p_hold_entity_id));
5795:
5796: RAISE FND_API.G_EXC_ERROR;
5790: WHEN no_data_found then
5791: --x_return_status := FND_API.G_RET_STS_ERROR;
5792: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_SITE_USE_ID');
5793: OE_MSG_PUB.ADD;
5794: fnd_message.set_token('SITE_USE_ID', to_char(p_hold_entity_id));
5795:
5796: RAISE FND_API.G_EXC_ERROR;
5797: END;
5798:
5932:
5933: SAVEPOINT oe_process_holds;
5934:
5935: IF p_action IS NULL OR p_action NOT IN ('APPLY','RELEASE') THEN
5936: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ACTION'); -- message taken from oe_holds
5937: fnd_message.set_token('ACTION',p_action);
5938: OE_MSG_PUB.ADD;
5939: RAISE FND_API.G_EXC_ERROR;
5940: END IF;
5933: SAVEPOINT oe_process_holds;
5934:
5935: IF p_action IS NULL OR p_action NOT IN ('APPLY','RELEASE') THEN
5936: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ACTION'); -- message taken from oe_holds
5937: fnd_message.set_token('ACTION',p_action);
5938: OE_MSG_PUB.ADD;
5939: RAISE FND_API.G_EXC_ERROR;
5940: END IF;
5941:
5939: RAISE FND_API.G_EXC_ERROR;
5940: END IF;
5941:
5942: IF p_hold_entity_code IS NULL OR p_hold_entity_code NOT IN ('S','C') THEN
5943: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_HOLD_ENTITY_CODE'); -- message need to be seeded or use any existing one
5944: OE_MSG_PUB.ADD;
5945: RAISE FND_API.G_EXC_ERROR;
5946: END IF;
5947: -- hold the original org id being used by programs when calling process_holds.
5982: FETCH c_valid_acct into l_valid_acct;
5983: CLOSE c_valid_acct;
5984:
5985: IF l_valid_acct <> 'Y' THEN
5986: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_CUST_ACCOUNT'); -- get the correct message new or existing??
5987: -- fnd_message.set_token('',p_action);
5988: OE_MSG_PUB.ADD;
5989: RAISE FND_API.G_EXC_ERROR;
5990: END IF;
5983: CLOSE c_valid_acct;
5984:
5985: IF l_valid_acct <> 'Y' THEN
5986: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_CUST_ACCOUNT'); -- get the correct message new or existing??
5987: -- fnd_message.set_token('',p_action);
5988: OE_MSG_PUB.ADD;
5989: RAISE FND_API.G_EXC_ERROR;
5990: END IF;
5991: