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 216: FND_MSG_PUB.Add;

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

Line 243: FND_MSG_PUB.Count_And_Get

239:
240: l_progress := '100';
241: -- Standard call to get message count and if count is 1,
242: -- get message info.
243: FND_MSG_PUB.Count_And_Get
244: (p_count => x_msg_count,
245: p_data => x_msg_data
246: );
247:

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

246: );
247:
248: EXCEPTION
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
251: p_encoded => 'F');
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
253: WHEN FND_API.G_EXC_ERROR THEN
254: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

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

250: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
251: p_encoded => 'F');
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
253: WHEN FND_API.G_EXC_ERROR THEN
254: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
255: p_encoded => 'F');
256: x_return_status := FND_API.G_RET_STS_ERROR;
257: WHEN OTHERS THEN
258: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

254: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
255: p_encoded => 'F');
256: x_return_status := FND_API.G_RET_STS_ERROR;
257: WHEN OTHERS THEN
258: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
259: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
260: END IF;
261:
262: IF (g_fnd_debug = 'Y') THEN

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

255: p_encoded => 'F');
256: x_return_status := FND_API.G_RET_STS_ERROR;
257: WHEN OTHERS THEN
258: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
259: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
260: END IF;
261:
262: IF (g_fnd_debug = 'Y') THEN
263: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

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

267: || ', EXCEPTION: '||sqlerrm);
268: END IF;
269: END IF;
270:
271: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
272: p_encoded => 'F');
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274:
275: END archive_po;