DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ARCHIVE_GRP dependencies on FND_MSG_PUB

Line 84: FND_MSG_PUB.Add;

80: IF ((p_document_id is NULL) OR (p_document_type is NULL) OR
81: (p_document_subtype IS NULL)) THEN
82: FND_MESSAGE.set_name('PO', 'PO_ARC_GENERAL_ERROR');
83: FND_MESSAGE.set_token('ERROR_TEXT', 'Mandatory parameters are NULL');
84: FND_MSG_PUB.Add;
85: RAISE FND_API.G_EXC_ERROR;
86: END IF; /*(p_document_id is NULL) OR (p_document_type is NULL)*/
87:
88: l_progress := '030';

Line 93: FND_MSG_PUB.Add;

89: --check p_document_type
90: IF p_document_type NOT IN ('RELEASE', 'PO', 'PA') THEN
91: FND_MESSAGE.set_name('PO', 'PO_ARC_GENERAL_ERROR');
92: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid document type');
93: FND_MSG_PUB.Add;
94: RAISE FND_API.G_EXC_ERROR;
95: END IF; /*p_document_type NOT IN ('RELEASE', 'PO', 'PA')*/
96:
97: l_progress := '040';

Line 103: FND_MSG_PUB.Add;

99: IF p_document_type = 'RELEASE' THEN
100: IF p_document_subtype NOT IN ('SCHEDULED', 'BLANKET') THEN
101: FND_MESSAGE.set_name('PO', 'PO_ARC_GENERAL_ERROR');
102: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Release document subtype');
103: FND_MSG_PUB.Add;
104: RAISE FND_API.G_EXC_ERROR;
105: END IF;
106: ELSIF p_document_type = 'PO' THEN
107: IF p_document_subtype NOT IN ('STANDARD', 'PLANNED') THEN

Line 110: FND_MSG_PUB.Add;

106: ELSIF p_document_type = 'PO' THEN
107: IF p_document_subtype NOT IN ('STANDARD', 'PLANNED') THEN
108: FND_MESSAGE.set_name('PO', 'PO_ARC_GENERAL_ERROR');
109: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid PO document subtype');
110: FND_MSG_PUB.Add;
111: RAISE FND_API.G_EXC_ERROR;
112: END IF;
113: ELSIF p_document_type = 'PA' THEN
114: IF p_document_subtype NOT IN ('BLANKET', 'CONTRACT') THEN

Line 117: FND_MSG_PUB.Add;

113: ELSIF p_document_type = 'PA' THEN
114: IF p_document_subtype NOT IN ('BLANKET', 'CONTRACT') THEN
115: FND_MESSAGE.set_name('PO', 'PO_ARC_GENERAL_ERROR');
116: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid PA document subtype');
117: FND_MSG_PUB.Add;
118: RAISE FND_API.G_EXC_ERROR;
119: END IF;
120: END IF; /*p_document_type = 'RELEASE'*/
121:

Line 140: FND_MSG_PUB.Add;

136: EXCEPTION
137: WHEN NO_DATA_FOUND THEN
138: FND_MESSAGE.set_name('PO', 'PO_ARC_GENERAL_ERROR');
139: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid document_id passed');
140: FND_MSG_PUB.Add;
141: RAISE FND_API.G_EXC_ERROR;
142: END;
143:
144: l_progress := '100';

Line 158: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

154:
155: l_progress := '200';
156: EXCEPTION
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
158: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
159: p_encoded => 'F');
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161: WHEN FND_API.G_EXC_ERROR THEN
162: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

Line 162: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

158: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
159: p_encoded => 'F');
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161: WHEN FND_API.G_EXC_ERROR THEN
162: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
163: p_encoded => 'F');
164: x_return_status := FND_API.G_RET_STS_ERROR;
165: WHEN OTHERS THEN
166: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 166: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

162: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
163: p_encoded => 'F');
164: x_return_status := FND_API.G_RET_STS_ERROR;
165: WHEN OTHERS THEN
166: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
167: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
168: END IF;
169:
170: IF (g_fnd_debug = 'Y') THEN

Line 167: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

163: p_encoded => 'F');
164: x_return_status := FND_API.G_RET_STS_ERROR;
165: WHEN OTHERS THEN
166: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
167: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
168: END IF;
169:
170: IF (g_fnd_debug = 'Y') THEN
171: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 179: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

175: || ', EXCEPTION: '||sqlerrm);
176: END IF;
177: END IF;
178:
179: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
180: p_encoded => 'F');
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182:
183: END archive_po;

Line 217: FND_MSG_PUB.Add;

213: IF (p_process is NULL OR
214: p_process NOT IN ('PRINT', 'APPROVE')) THEN
215: FND_MESSAGE.set_name('PO', 'PO_ARC_GENERAL_ERROR');
216: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid process value');
217: FND_MSG_PUB.Add;
218: RAISE FND_API.G_EXC_ERROR;
219: END IF; /* p_process NOT IN ('PRINT', 'APPROVE')*/
220:
221: l_progress := '010';

Line 249: FND_MSG_PUB.Count_And_Get

245:
246: l_progress := '100';
247: -- Standard call to get message count and if count is 1,
248: -- get message info.
249: FND_MSG_PUB.Count_And_Get
250: (p_count => x_msg_count,
251: p_data => x_msg_data
252: );
253:

Line 256: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

252: );
253:
254: EXCEPTION
255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
256: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
257: p_encoded => 'F');
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
259: WHEN FND_API.G_EXC_ERROR THEN
260: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

Line 260: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

256: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
257: p_encoded => 'F');
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
259: WHEN FND_API.G_EXC_ERROR THEN
260: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
261: p_encoded => 'F');
262: x_return_status := FND_API.G_RET_STS_ERROR;
263: WHEN OTHERS THEN
264: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 264: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

260: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
261: p_encoded => 'F');
262: x_return_status := FND_API.G_RET_STS_ERROR;
263: WHEN OTHERS THEN
264: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
265: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
266: END IF;
267:
268: IF (g_fnd_debug = 'Y') THEN

Line 265: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

261: p_encoded => 'F');
262: x_return_status := FND_API.G_RET_STS_ERROR;
263: WHEN OTHERS THEN
264: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
265: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
266: END IF;
267:
268: IF (g_fnd_debug = 'Y') THEN
269: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 277: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

273: || ', EXCEPTION: '||sqlerrm);
274: END IF;
275: END IF;
276:
277: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
278: p_encoded => 'F');
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280:
281: END archive_po;