DBA Data[Home] [Help]

APPS.OE_HOLD_SOURCES_PVT dependencies on FND_MESSAGE

Line 63: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_HOLD_ID');

59: WHEN NO_DATA_FOUND THEN
60: IF l_debug_level > 0 THEN
61: oe_debug_pub.add( 'INVALID HOLD ID' ) ;
62: END IF;
63: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_HOLD_ID');
64: FND_MESSAGE.SET_TOKEN('HOLD_ID',p_hold_id);
65: FND_MSG_PUB.ADD;
66: x_return_status := FND_API.G_RET_STS_ERROR;
67:

Line 64: FND_MESSAGE.SET_TOKEN('HOLD_ID',p_hold_id);

60: IF l_debug_level > 0 THEN
61: oe_debug_pub.add( 'INVALID HOLD ID' ) ;
62: END IF;
63: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_HOLD_ID');
64: FND_MESSAGE.SET_TOKEN('HOLD_ID',p_hold_id);
65: FND_MSG_PUB.ADD;
66: x_return_status := FND_API.G_RET_STS_ERROR;
67:
68: END; -- Validate Hold ID

Line 77: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CODE');

73: IF p_entity_code NOT IN ('C','S','I','O') THEN
74: IF l_debug_level > 0 THEN
75: oe_debug_pub.add( 'INVALID ENTITY CODE' ) ;
76: END IF;
77: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CODE');
78: FND_MESSAGE.SET_TOKEN('ENTITY_CODE',p_entity_code);
79: FND_MSG_PUB.ADD;
80: x_return_status := FND_API.G_RET_STS_ERROR;
81: END IF; -- Validate Entity Code

Line 78: FND_MESSAGE.SET_TOKEN('ENTITY_CODE',p_entity_code);

74: IF l_debug_level > 0 THEN
75: oe_debug_pub.add( 'INVALID ENTITY CODE' ) ;
76: END IF;
77: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CODE');
78: FND_MESSAGE.SET_TOKEN('ENTITY_CODE',p_entity_code);
79: FND_MSG_PUB.ADD;
80: x_return_status := FND_API.G_RET_STS_ERROR;
81: END IF; -- Validate Entity Code
82:

Line 126: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_ID');

122: WHEN NO_DATA_FOUND THEN
123: IF l_debug_level > 0 THEN
124: oe_debug_pub.add( 'INVALID ENTITY ID' ) ;
125: END IF;
126: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_ID');
127: FND_MESSAGE.SET_TOKEN('ENTITY_ID',p_entity_id);
128: FND_MSG_PUB.ADD;
129: RAISE FND_API.G_EXC_ERROR;
130: -- too many rows maybe raised if the same entity id

Line 127: FND_MESSAGE.SET_TOKEN('ENTITY_ID',p_entity_id);

123: IF l_debug_level > 0 THEN
124: oe_debug_pub.add( 'INVALID ENTITY ID' ) ;
125: END IF;
126: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_ID');
127: FND_MESSAGE.SET_TOKEN('ENTITY_ID',p_entity_id);
128: FND_MSG_PUB.ADD;
129: RAISE FND_API.G_EXC_ERROR;
130: -- too many rows maybe raised if the same entity id
131: -- e.g. an item exists in two orgs.

Line 146: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CODE');

142: IF p_entity_code2 NOT IN ('C','S','I','O') THEN
143: IF l_debug_level > 0 THEN
144: oe_debug_pub.add( 'INVALID SECOND ENTITY CODE' ) ;
145: END IF;
146: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CODE');
147: FND_MESSAGE.SET_TOKEN('ENTITY_CODE',p_entity_code2);
148: FND_MSG_PUB.ADD;
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: END IF; -- Validate Entity Code

Line 147: FND_MESSAGE.SET_TOKEN('ENTITY_CODE',p_entity_code2);

143: IF l_debug_level > 0 THEN
144: oe_debug_pub.add( 'INVALID SECOND ENTITY CODE' ) ;
145: END IF;
146: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CODE');
147: FND_MESSAGE.SET_TOKEN('ENTITY_CODE',p_entity_code2);
148: FND_MSG_PUB.ADD;
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: END IF; -- Validate Entity Code
151:

Line 195: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_ID');

191: WHEN NO_DATA_FOUND THEN
192: IF l_debug_level > 0 THEN
193: oe_debug_pub.add( 'INVALID SECOND ENTITY ID' ) ;
194: END IF;
195: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_ID');
196: FND_MESSAGE.SET_TOKEN('ENTITY_ID',p_entity_id2);
197: FND_MSG_PUB.ADD;
198: RAISE FND_API.G_EXC_ERROR;
199: -- too many rows maybe raised if the same entity id

Line 196: FND_MESSAGE.SET_TOKEN('ENTITY_ID',p_entity_id2);

192: IF l_debug_level > 0 THEN
193: oe_debug_pub.add( 'INVALID SECOND ENTITY ID' ) ;
194: END IF;
195: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_ID');
196: FND_MESSAGE.SET_TOKEN('ENTITY_ID',p_entity_id2);
197: FND_MSG_PUB.ADD;
198: RAISE FND_API.G_EXC_ERROR;
199: -- too many rows maybe raised if the same entity id
200: -- e.g. an item exists in two orgs.

Line 311: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');

307: --dbms_output.put_line ('Duplicate Hold Source');
308: IF l_debug_level > 0 THEN
309: oe_debug_pub.add( 'DUPLICATE HOLD SOURCE' ) ;
310: END IF;
311: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
312: FND_MSG_PUB.ADD;
313: RAISE FND_API.G_EXC_ERROR;
314: END IF;
315:

Line 492: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD_SOURCE');

488:
489: OPEN hold_source;
490: FETCH hold_source INTO l_hold_release_rec.hold_source_id;
491: IF (hold_source%NOTFOUND) THEN
492: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD_SOURCE');
493: FND_MSG_PUB.ADD;
494: RAISE FND_API.G_EXC_ERROR;
495: END IF;
496: CLOSE hold_source;

Line 772: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_REASON_CODE');

768:
769: EXCEPTION
770:
771: WHEN NO_DATA_FOUND THEN
772: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_REASON_CODE');
773: FND_MESSAGE.SET_TOKEN('REASON_CODE',p_hold_release_rec.release_reason_code);
774: FND_MSG_PUB.ADD;
775: RAISE FND_API.G_EXC_ERROR;
776:

Line 773: FND_MESSAGE.SET_TOKEN('REASON_CODE',p_hold_release_rec.release_reason_code);

769: EXCEPTION
770:
771: WHEN NO_DATA_FOUND THEN
772: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_REASON_CODE');
773: FND_MESSAGE.SET_TOKEN('REASON_CODE',p_hold_release_rec.release_reason_code);
774: FND_MSG_PUB.ADD;
775: RAISE FND_API.G_EXC_ERROR;
776:
777: END; -- Validate Reason Code