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.CSP_TO_FORM_MOHEADERS dependencies on FND_MSG_PUB

Line 88: FND_MSG_PUB.initialize;

84: savepoint Validate_And_Write_PUB;
85:
86: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
87: -- initialize message list
88: FND_MSG_PUB.initialize;
89: END IF;
90:
91: -- Standard call to check for call compatibility.
92: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 105: fnd_msg_pub.add;

101: -- check p_action_code
102: IF p_action_code not in (0, 1, 2) THEN
103: fnd_message.set_name('INV', 'INV-INVALID ACTION');
104: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
105: fnd_msg_pub.add;
106: RAISE EXCP_USER_DEFINED;
107: END IF;
108:
109: IF p_action_code = 0 THEN

Line 114: FND_MSG_PUB.ADD;

110: -- For inserting, we need to validate the header_id and the carrier.
111: IF nvl(p_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
112: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
113: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_header_id', FALSE);
114: FND_MSG_PUB.ADD;
115: RAISE EXCP_USER_DEFINED;
116: ELSE
117: -- First we need to validate whether the given header_id already exists in the csp_moveorder_headers.
118: OPEN l_Get_Header_ID_Csr;

Line 131: FND_MSG_PUB.ADD;

127: EXCEPTION
128: WHEN NO_DATA_FOUND THEN
129: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_MOVEORDER');
130: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_header_id), FALSE);
131: FND_MSG_PUB.ADD;
132: RAISE EXCP_USER_DEFINED;
133: WHEN OTHERS THEN
134: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
135: fnd_message.set_token('ERR_FIELD', 'p_header_id', FALSE);

Line 138: FND_MSG_PUB.ADD;

134: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
135: fnd_message.set_token('ERR_FIELD', 'p_header_id', FALSE);
136: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
137: fnd_message.set_token('TABLE', 'MTL_TXN_REQUEST_HEADERS', FALSE);
138: FND_MSG_PUB.ADD;
139: RAISE EXCP_USER_DEFINED;
140:
141: END;
142: ELSE

Line 144: fnd_msg_pub.add;

140:
141: END;
142: ELSE
143: fnd_message.set_name ('CSP', 'CSP_DUPLICATE_RECORD');
144: fnd_msg_pub.add;
145: RAISE EXCP_USER_DEFINED;
146: END IF;
147: CLOSE l_Get_Header_ID_Csr;
148:

Line 163: FND_MSG_PUB.ADD;

159: EXCEPTION
160: WHEN NO_DATA_FOUND THEN
161: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_CARRIER');
162: FND_MESSAGE.SET_TOKEN('CARRIER_CODE', p_carrier, FALSE);
163: FND_MSG_PUB.ADD;
164: RAISE EXCP_USER_DEFINED;
165: WHEN OTHERS THEN
166: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
167: fnd_message.set_token('ERR_FIELD', 'p_carrier', FALSE);

Line 170: FND_MSG_PUB.ADD;

166: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
167: fnd_message.set_token('ERR_FIELD', 'p_carrier', FALSE);
168: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
169: fnd_message.set_token('TABLE', 'ORG_FREIGHT_TL', FALSE);
170: FND_MSG_PUB.ADD;
171: RAISE EXCP_USER_DEFINED;
172: END;
173: END IF;
174:

Line 200: FND_MSG_PUB.ADD;

196: ELSIF p_action_code = 1 THEN
197: IF nvl(p_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
198: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
199: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_header_id', FALSE);
200: FND_MSG_PUB.ADD;
201: RAISE EXCP_USER_DEFINED;
202: ELSE
203: -- Validate whether the given header_id exists in the mtl_txn_request_headers table.
204: BEGIN

Line 213: FND_MSG_PUB.ADD;

209: EXCEPTION
210: WHEN NO_DATA_FOUND THEN
211: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_MOVEORDER');
212: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_header_id), FALSE);
213: FND_MSG_PUB.ADD;
214: RAISE EXCP_USER_DEFINED;
215: WHEN OTHERS THEN
216: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
217: fnd_message.set_token('ERR_FIELD', 'p_header_id', FALSE);

Line 220: FND_MSG_PUB.ADD;

216: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
217: fnd_message.set_token('ERR_FIELD', 'p_header_id', FALSE);
218: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
219: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_HEADERS', FALSE);
220: FND_MSG_PUB.ADD;
221: RAISE EXCP_USER_DEFINED;
222:
223: END;
224: END IF;

Line 238: FND_MSG_PUB.ADD;

234: EXCEPTION
235: WHEN NO_DATA_FOUND THEN
236: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_CARRIER');
237: FND_MESSAGE.SET_TOKEN('CARRIER_CODE', p_carrier, FALSE);
238: FND_MSG_PUB.ADD;
239: RAISE EXCP_USER_DEFINED;
240: WHEN OTHERS THEN
241: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
242: fnd_message.set_token('ERR_FIELD', 'p_carrier', FALSE);

Line 245: FND_MSG_PUB.ADD;

241: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
242: fnd_message.set_token('ERR_FIELD', 'p_carrier', FALSE);
243: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
244: fnd_message.set_token('TABLE', 'ORG_FREIGHT_TL', FALSE);
245: FND_MSG_PUB.ADD;
246: RAISE EXCP_USER_DEFINED;
247: END;
248: END IF;
249:

Line 260: FND_MSG_PUB.ADD;

256: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
257: fnd_message.set_token('ERR_FIELD', 'p_cretaion_date', FALSE);
258: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
259: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_HEADERS', FALSE);
260: FND_MSG_PUB.ADD;
261: RAISE EXCP_USER_DEFINED;
262: End if;
263: Close l_Get_Creation_Date_Csr;
264: END IF;

Line 273: FND_MSG_PUB.ADD;

269: ELSE -- p_action_code = 2
270: IF nvl(p_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
271: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
272: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_header_id', FALSE);
273: FND_MSG_PUB.ADD;
274: RAISE EXCP_USER_DEFINED;
275: ELSE
276: -- Validate whether the given header_id exists in the mtl_txn_request_headers table.
277: BEGIN

Line 286: FND_MSG_PUB.ADD;

282: EXCEPTION
283: WHEN NO_DATA_FOUND THEN
284: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_MOVEORDER');
285: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_header_id), FALSE);
286: FND_MSG_PUB.ADD;
287: RAISE EXCP_USER_DEFINED;
288: WHEN OTHERS THEN
289: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
290: fnd_message.set_token('ERR_FIELD', 'p_header_id', FALSE);

Line 293: FND_MSG_PUB.ADD;

289: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
290: fnd_message.set_token('ERR_FIELD', 'p_header_id', FALSE);
291: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
292: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_HEADERS', FALSE);
293: FND_MSG_PUB.ADD;
294: RAISE EXCP_USER_DEFINED;
295:
296: END;
297: END IF;

Line 383: fnd_msg_pub.count_and_get

379: EXCEPTION
380: WHEN EXCP_USER_DEFINED THEN
381: Rollback to Validate_And_Write_PUB;
382: x_return_status := FND_API.G_RET_STS_ERROR;
383: fnd_msg_pub.count_and_get
384: ( p_count => x_msg_count
385: , p_data => x_msg_data);
386: --for debugging purpose
387: --x_msg_data := l_msg_data;

Line 392: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

388: WHEN FND_API.G_EXC_ERROR THEN
389: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
390: P_API_NAME => L_API_NAME
391: ,P_PKG_NAME => G_PKG_NAME
392: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
393: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
394: ,X_MSG_COUNT => X_MSG_COUNT
395: ,X_MSG_DATA => X_MSG_DATA
396: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 401: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
398: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
399: P_API_NAME => L_API_NAME
400: ,P_PKG_NAME => G_PKG_NAME
401: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
402: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
403: ,X_MSG_COUNT => X_MSG_COUNT
404: ,X_MSG_DATA => X_MSG_DATA
405: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 411: fnd_msg_pub.add;

407: Rollback to Validate_And_Write_PUB;
408: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
409: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
410: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
411: fnd_msg_pub.add;
412: fnd_msg_pub.count_and_get
413: ( p_count => x_msg_count
414: , p_data => x_msg_data);
415: x_return_status := fnd_api.g_ret_sts_error;

Line 412: fnd_msg_pub.count_and_get

408: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
409: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
410: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
411: fnd_msg_pub.add;
412: fnd_msg_pub.count_and_get
413: ( p_count => x_msg_count
414: , p_data => x_msg_data);
415: x_return_status := fnd_api.g_ret_sts_error;
416: