eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DOCUMENT_ARCHIVE_GRP dependencies on FND_API

Line 35: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds

31: * archive tables
32: * Effects: This procedure archives the document that is passed in
33: *
34: * Returns:
35: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
36: * FND_API.G_RET_STS_ERROR if API fails
37: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
38: * x_msg_data: Contains error msg in case x_return_status returned
39: * FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_UNEXP_ERROR

Line 36: * FND_API.G_RET_STS_ERROR if API fails

32: * Effects: This procedure archives the document that is passed in
33: *
34: * Returns:
35: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
36: * FND_API.G_RET_STS_ERROR if API fails
37: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
38: * x_msg_data: Contains error msg in case x_return_status returned
39: * FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_UNEXP_ERROR
40: */

Line 37: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

33: *
34: * Returns:
35: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
36: * FND_API.G_RET_STS_ERROR if API fails
37: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
38: * x_msg_data: Contains error msg in case x_return_status returned
39: * FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_UNEXP_ERROR
40: */
41:

Line 39: * FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_UNEXP_ERROR

35: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
36: * FND_API.G_RET_STS_ERROR if API fails
37: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
38: * x_msg_data: Contains error msg in case x_return_status returned
39: * FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_UNEXP_ERROR
40: */
41:
42: PROCEDURE archive_po(p_api_version IN NUMBER,
43: p_document_id IN NUMBER,

Line 59: x_return_status := FND_API.G_RET_STS_SUCCESS;

55:
56: BEGIN
57:
58: -- Initialize OUT parameters
59: x_return_status := FND_API.G_RET_STS_SUCCESS;
60: x_msg_count := 0;
61: x_msg_data := NULL;
62:
63: l_progress := '000';

Line 65: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

61: x_msg_data := NULL;
62:
63: l_progress := '000';
64: -- Standard call to check for call compatibility
65: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
66: THEN
67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
68: END IF;
69:

Line 67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

63: l_progress := '000';
64: -- Standard call to check for call compatibility
65: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
66: THEN
67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
68: END IF;
69:
70: l_progress := '010';
71: IF g_fnd_debug = 'Y' THEN

Line 85: RAISE FND_API.G_EXC_ERROR;

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';
89: --check p_document_type

Line 94: RAISE FND_API.G_EXC_ERROR;

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';
98: --check that document_subtype matches

Line 104: RAISE FND_API.G_EXC_ERROR;

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
108: FND_MESSAGE.set_name('PO', 'PO_ARC_GENERAL_ERROR');

Line 111: RAISE FND_API.G_EXC_ERROR;

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
115: FND_MESSAGE.set_name('PO', 'PO_ARC_GENERAL_ERROR');

Line 118: RAISE FND_API.G_EXC_ERROR;

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:
122: l_progress := '040';

Line 141: RAISE FND_API.G_EXC_ERROR;

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';
145: --Call the private Archive_PO

Line 157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

153: x_msg_data => x_msg_data);
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

Line 160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,
163: p_encoded => 'F');
164: x_return_status := FND_API.G_RET_STS_ERROR;

Line 161: WHEN FND_API.G_EXC_ERROR THEN

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,
163: p_encoded => 'F');
164: x_return_status := FND_API.G_RET_STS_ERROR;
165: WHEN OTHERS THEN

Line 164: x_return_status := FND_API.G_RET_STS_ERROR;

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
167: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
168: END IF;

Line 181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
184:
185: /**

Line 206: x_return_status := FND_API.G_RET_STS_SUCCESS;

202: l_when_to_archive PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE;
203: BEGIN
204:
205: -- Initialize OUT parameters
206: x_return_status := FND_API.G_RET_STS_SUCCESS;
207: x_msg_count := 0;
208: x_msg_data := NULL;
209:
210: l_progress := '000';

Line 217: RAISE FND_API.G_EXC_ERROR;

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';
221: -- Check if we need to archive the document

Line 249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

245: p_data => x_msg_data
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

Line 252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,
255: p_encoded => 'F');
256: x_return_status := FND_API.G_RET_STS_ERROR;

Line 253: WHEN FND_API.G_EXC_ERROR THEN

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,
255: p_encoded => 'F');
256: x_return_status := FND_API.G_RET_STS_ERROR;
257: WHEN OTHERS THEN

Line 256: x_return_status := FND_API.G_RET_STS_ERROR;

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
259: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
260: END IF;

Line 273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
276:
277: /**