DBA Data[Home] [Help]

APPS.AHL_UC_INSTANCE_PUB dependencies on FND_MESSAGE

Line 37: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');

33: x_return_status := FND_API.G_RET_STS_SUCCESS;
34: x_uc_header_id := p_uc_header_id;
35:
36: IF p_uc_header_id IS NULL AND p_uc_name IS NULL THEN
37: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
38: FND_MESSAGE.set_token('NAME', 'uc_name');
39: FND_MESSAGE.set_token('VALUE', p_uc_name);
40: FND_MSG_PUB.add;
41: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 38: FND_MESSAGE.set_token('NAME', 'uc_name');

34: x_uc_header_id := p_uc_header_id;
35:
36: IF p_uc_header_id IS NULL AND p_uc_name IS NULL THEN
37: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
38: FND_MESSAGE.set_token('NAME', 'uc_name');
39: FND_MESSAGE.set_token('VALUE', p_uc_name);
40: FND_MSG_PUB.add;
41: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
42: ELSIF p_uc_header_id IS NULL AND p_uc_name IS NOT NULL THEN

Line 39: FND_MESSAGE.set_token('VALUE', p_uc_name);

35:
36: IF p_uc_header_id IS NULL AND p_uc_name IS NULL THEN
37: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
38: FND_MESSAGE.set_token('NAME', 'uc_name');
39: FND_MESSAGE.set_token('VALUE', p_uc_name);
40: FND_MSG_PUB.add;
41: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
42: ELSIF p_uc_header_id IS NULL AND p_uc_name IS NOT NULL THEN
43: OPEN get_uc_header_id;

Line 46: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');

42: ELSIF p_uc_header_id IS NULL AND p_uc_name IS NOT NULL THEN
43: OPEN get_uc_header_id;
44: FETCH get_uc_header_id INTO x_uc_header_id;
45: IF get_uc_header_id%NOTFOUND THEN
46: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
47: FND_MESSAGE.set_token('NAME', 'uc_name');
48: FND_MESSAGE.set_token('VALUE', p_uc_name);
49: FND_MSG_PUB.add;
50: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 47: FND_MESSAGE.set_token('NAME', 'uc_name');

43: OPEN get_uc_header_id;
44: FETCH get_uc_header_id INTO x_uc_header_id;
45: IF get_uc_header_id%NOTFOUND THEN
46: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
47: FND_MESSAGE.set_token('NAME', 'uc_name');
48: FND_MESSAGE.set_token('VALUE', p_uc_name);
49: FND_MSG_PUB.add;
50: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
51: END IF;

Line 48: FND_MESSAGE.set_token('VALUE', p_uc_name);

44: FETCH get_uc_header_id INTO x_uc_header_id;
45: IF get_uc_header_id%NOTFOUND THEN
46: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
47: FND_MESSAGE.set_token('NAME', 'uc_name');
48: FND_MESSAGE.set_token('VALUE', p_uc_name);
49: FND_MSG_PUB.add;
50: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
51: END IF;
52: CLOSE get_uc_header_id;

Line 57: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');

53: ELSIF p_uc_header_id IS NOT NULL AND p_uc_name IS NULL THEN
54: OPEN check_uc_header_id;
55: FETCH check_uc_header_id INTO x_uc_header_id;
56: IF check_uc_header_id%NOTFOUND THEN
57: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
58: FND_MESSAGE.set_token('NAME', 'uc_header_id');
59: FND_MESSAGE.set_token('VALUE', p_uc_header_id);
60: FND_MSG_PUB.add;
61: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 58: FND_MESSAGE.set_token('NAME', 'uc_header_id');

54: OPEN check_uc_header_id;
55: FETCH check_uc_header_id INTO x_uc_header_id;
56: IF check_uc_header_id%NOTFOUND THEN
57: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
58: FND_MESSAGE.set_token('NAME', 'uc_header_id');
59: FND_MESSAGE.set_token('VALUE', p_uc_header_id);
60: FND_MSG_PUB.add;
61: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
62: END IF;

Line 59: FND_MESSAGE.set_token('VALUE', p_uc_header_id);

55: FETCH check_uc_header_id INTO x_uc_header_id;
56: IF check_uc_header_id%NOTFOUND THEN
57: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
58: FND_MESSAGE.set_token('NAME', 'uc_header_id');
59: FND_MESSAGE.set_token('VALUE', p_uc_header_id);
60: FND_MSG_PUB.add;
61: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
62: END IF;
63: CLOSE check_uc_header_id;

Line 68: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');

64: ELSIF p_uc_header_id IS NOT NULL AND p_uc_name IS NOT NULL THEN
65: OPEN get_uc_header_id;
66: FETCH get_uc_header_id INTO x_uc_header_id;
67: IF get_uc_header_id%NOTFOUND OR p_uc_header_id <> x_uc_header_id THEN
68: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
69: FND_MESSAGE.set_token('NAME', 'uc_name');
70: FND_MESSAGE.set_token('VALUE', p_uc_name);
71: FND_MSG_PUB.add;
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 69: FND_MESSAGE.set_token('NAME', 'uc_name');

65: OPEN get_uc_header_id;
66: FETCH get_uc_header_id INTO x_uc_header_id;
67: IF get_uc_header_id%NOTFOUND OR p_uc_header_id <> x_uc_header_id THEN
68: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
69: FND_MESSAGE.set_token('NAME', 'uc_name');
70: FND_MESSAGE.set_token('VALUE', p_uc_name);
71: FND_MSG_PUB.add;
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
73: END IF;

Line 70: FND_MESSAGE.set_token('VALUE', p_uc_name);

66: FETCH get_uc_header_id INTO x_uc_header_id;
67: IF get_uc_header_id%NOTFOUND OR p_uc_header_id <> x_uc_header_id THEN
68: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
69: FND_MESSAGE.set_token('NAME', 'uc_name');
70: FND_MESSAGE.set_token('VALUE', p_uc_name);
71: FND_MSG_PUB.add;
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
73: END IF;
74: CLOSE get_uc_header_id;

Line 97: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');

93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94: x_instance_id := p_instance_id;
95:
96: IF p_instance_id IS NULL AND p_instance_num IS NULL THEN
97: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
98: FND_MESSAGE.set_token('NAME', 'instance_number');
99: FND_MESSAGE.set_token('VALUE', p_instance_num);
100: FND_MSG_PUB.add;
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 98: FND_MESSAGE.set_token('NAME', 'instance_number');

94: x_instance_id := p_instance_id;
95:
96: IF p_instance_id IS NULL AND p_instance_num IS NULL THEN
97: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
98: FND_MESSAGE.set_token('NAME', 'instance_number');
99: FND_MESSAGE.set_token('VALUE', p_instance_num);
100: FND_MSG_PUB.add;
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
102: ELSIF p_instance_id IS NULL AND p_instance_num IS NOT NULL THEN

Line 99: FND_MESSAGE.set_token('VALUE', p_instance_num);

95:
96: IF p_instance_id IS NULL AND p_instance_num IS NULL THEN
97: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
98: FND_MESSAGE.set_token('NAME', 'instance_number');
99: FND_MESSAGE.set_token('VALUE', p_instance_num);
100: FND_MSG_PUB.add;
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
102: ELSIF p_instance_id IS NULL AND p_instance_num IS NOT NULL THEN
103: OPEN get_instance_id;

Line 106: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');

102: ELSIF p_instance_id IS NULL AND p_instance_num IS NOT NULL THEN
103: OPEN get_instance_id;
104: FETCH get_instance_id INTO x_instance_id;
105: IF get_instance_id%NOTFOUND THEN
106: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
107: FND_MESSAGE.set_token('NAME', 'instance_number');
108: FND_MESSAGE.set_token('VALUE', p_instance_num);
109: FND_MSG_PUB.add;
110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 107: FND_MESSAGE.set_token('NAME', 'instance_number');

103: OPEN get_instance_id;
104: FETCH get_instance_id INTO x_instance_id;
105: IF get_instance_id%NOTFOUND THEN
106: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
107: FND_MESSAGE.set_token('NAME', 'instance_number');
108: FND_MESSAGE.set_token('VALUE', p_instance_num);
109: FND_MSG_PUB.add;
110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
111: END IF;

Line 108: FND_MESSAGE.set_token('VALUE', p_instance_num);

104: FETCH get_instance_id INTO x_instance_id;
105: IF get_instance_id%NOTFOUND THEN
106: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
107: FND_MESSAGE.set_token('NAME', 'instance_number');
108: FND_MESSAGE.set_token('VALUE', p_instance_num);
109: FND_MSG_PUB.add;
110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
111: END IF;
112: CLOSE get_instance_id;

Line 117: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');

113: ELSIF p_instance_id IS NOT NULL AND p_instance_num IS NULL THEN
114: OPEN check_instance_id;
115: FETCH check_instance_id INTO x_instance_id;
116: IF check_instance_id%NOTFOUND THEN
117: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
118: FND_MESSAGE.set_token('NAME', 'instance_id');
119: FND_MESSAGE.set_token('VALUE', p_instance_id);
120: FND_MSG_PUB.add;
121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 118: FND_MESSAGE.set_token('NAME', 'instance_id');

114: OPEN check_instance_id;
115: FETCH check_instance_id INTO x_instance_id;
116: IF check_instance_id%NOTFOUND THEN
117: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
118: FND_MESSAGE.set_token('NAME', 'instance_id');
119: FND_MESSAGE.set_token('VALUE', p_instance_id);
120: FND_MSG_PUB.add;
121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
122: END IF;

Line 119: FND_MESSAGE.set_token('VALUE', p_instance_id);

115: FETCH check_instance_id INTO x_instance_id;
116: IF check_instance_id%NOTFOUND THEN
117: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
118: FND_MESSAGE.set_token('NAME', 'instance_id');
119: FND_MESSAGE.set_token('VALUE', p_instance_id);
120: FND_MSG_PUB.add;
121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
122: END IF;
123: CLOSE check_instance_id;

Line 128: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');

124: ELSIF p_instance_id IS NOT NULL AND p_instance_num IS NOT NULL THEN
125: OPEN get_instance_id;
126: FETCH get_instance_id INTO x_instance_id;
127: IF get_instance_id%NOTFOUND OR p_instance_id <> x_instance_id THEN
128: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
129: FND_MESSAGE.set_token('NAME', 'instance_number');
130: FND_MESSAGE.set_token('VALUE', p_instance_num);
131: FND_MSG_PUB.add;
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 129: FND_MESSAGE.set_token('NAME', 'instance_number');

125: OPEN get_instance_id;
126: FETCH get_instance_id INTO x_instance_id;
127: IF get_instance_id%NOTFOUND OR p_instance_id <> x_instance_id THEN
128: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
129: FND_MESSAGE.set_token('NAME', 'instance_number');
130: FND_MESSAGE.set_token('VALUE', p_instance_num);
131: FND_MSG_PUB.add;
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
133: END IF;

Line 130: FND_MESSAGE.set_token('VALUE', p_instance_num);

126: FETCH get_instance_id INTO x_instance_id;
127: IF get_instance_id%NOTFOUND OR p_instance_id <> x_instance_id THEN
128: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
129: FND_MESSAGE.set_token('NAME', 'instance_number');
130: FND_MESSAGE.set_token('VALUE', p_instance_num);
131: FND_MSG_PUB.add;
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
133: END IF;
134: CLOSE get_instance_id;

Line 219: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');

215: --p_instance_id is installed in p_uc_header_id which is done in the private API.
216: OPEN get_csi_ii_ovn(l_instance_id);
217: FETCH get_csi_ii_ovn INTO l_csi_ii_ovn;
218: IF get_csi_ii_ovn%NOTFOUND THEN
219: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
220: FND_MESSAGE.set_token('NAME', 'instance_id');
221: FND_MESSAGE.set_token('VALUE', l_instance_id);
222: FND_MSG_PUB.add;
223: CLOSE get_csi_ii_ovn;

Line 220: FND_MESSAGE.set_token('NAME', 'instance_id');

216: OPEN get_csi_ii_ovn(l_instance_id);
217: FETCH get_csi_ii_ovn INTO l_csi_ii_ovn;
218: IF get_csi_ii_ovn%NOTFOUND THEN
219: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
220: FND_MESSAGE.set_token('NAME', 'instance_id');
221: FND_MESSAGE.set_token('VALUE', l_instance_id);
222: FND_MSG_PUB.add;
223: CLOSE get_csi_ii_ovn;
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 221: FND_MESSAGE.set_token('VALUE', l_instance_id);

217: FETCH get_csi_ii_ovn INTO l_csi_ii_ovn;
218: IF get_csi_ii_ovn%NOTFOUND THEN
219: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
220: FND_MESSAGE.set_token('NAME', 'instance_id');
221: FND_MESSAGE.set_token('VALUE', l_instance_id);
222: FND_MSG_PUB.add;
223: CLOSE get_csi_ii_ovn;
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;

Line 381: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');

377: --p_instance_id is installed in p_uc_header_id which is done in the private API.
378: OPEN get_csi_ii_ovn(l_instance_id);
379: FETCH get_csi_ii_ovn INTO l_csi_ii_ovn;
380: IF get_csi_ii_ovn%NOTFOUND THEN
381: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
382: FND_MESSAGE.set_token('NAME', 'instance_id');
383: FND_MESSAGE.set_token('VALUE', l_instance_id);
384: FND_MSG_PUB.add;
385: CLOSE get_csi_ii_ovn;

Line 382: FND_MESSAGE.set_token('NAME', 'instance_id');

378: OPEN get_csi_ii_ovn(l_instance_id);
379: FETCH get_csi_ii_ovn INTO l_csi_ii_ovn;
380: IF get_csi_ii_ovn%NOTFOUND THEN
381: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
382: FND_MESSAGE.set_token('NAME', 'instance_id');
383: FND_MESSAGE.set_token('VALUE', l_instance_id);
384: FND_MSG_PUB.add;
385: CLOSE get_csi_ii_ovn;
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 383: FND_MESSAGE.set_token('VALUE', l_instance_id);

379: FETCH get_csi_ii_ovn INTO l_csi_ii_ovn;
380: IF get_csi_ii_ovn%NOTFOUND THEN
381: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
382: FND_MESSAGE.set_token('NAME', 'instance_id');
383: FND_MESSAGE.set_token('VALUE', l_instance_id);
384: FND_MSG_PUB.add;
385: CLOSE get_csi_ii_ovn;
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: END IF;