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_R12_CAT_UPG_GRP dependencies on FND_MSG_PUB

Line 17: -- b) FND_MSG_PUB on unhandled exceptions.

13: -- The datamodel changes for Unified Catlog Upgrade should have been applied.
14: --Modifies:
15: -- a) PO Transaction tables (headers, lines, attributes, TLP,
16: -- po_reqexpress_lines_all, po_approved_supplier_list)
17: -- b) FND_MSG_PUB on unhandled exceptions.
18: --Locks:
19: -- None.
20: --Function:
21: -- PASS 1: Migrate existing agreeements(and quotations)/Req templates.

Line 97: FND_MSG_PUB.initialize;

93:
94: l_progress := '020';
95: -- Initialize message list if p_init_msg_list is set to TRUE.
96: IF FND_API.to_boolean(p_init_msg_list) THEN
97: FND_MSG_PUB.initialize;
98: END IF;
99:
100: l_progress := '030';
101: -- Initialize API return status to success

Line 124: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

120: END IF;
121:
122: l_progress := '110';
123: -- Standard call to get message count and if count is 1, get message info.
124: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
125: p_data => x_msg_data );
126:
127: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'END'); END IF;
128: EXCEPTION

Line 132: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

128: EXCEPTION
129: WHEN FND_API.G_EXC_ERROR THEN
130: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'EXPECTED Start'); END IF;
131: x_return_status := FND_API.G_RET_STS_ERROR ;
132: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
133: p_data => x_msg_data );
134: IF g_debug THEN
135: PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'x_return_status='||x_return_status);
136: PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'EXPECTED End');

Line 142: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

138:
139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
140: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'UNEXPECTED Start'); END IF;
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
142: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
143: p_data => x_msg_data );
144: IF g_debug THEN
145: PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'x_return_status='||x_return_status);
146: PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'UNEXPECTED End');

Line 156: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153:
154: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'x_return_status='||x_return_status); END IF;
155:
156: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
157: FND_MSG_PUB.add_exc_msg(G_PKG_NAME,l_api_name,SQLERRM);
158: END IF;
159:
160: -- Standard call to get message count and if count is 1, get message info.

Line 157: FND_MSG_PUB.add_exc_msg(G_PKG_NAME,l_api_name,SQLERRM);

153:
154: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'x_return_status='||x_return_status); END IF;
155:
156: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
157: FND_MSG_PUB.add_exc_msg(G_PKG_NAME,l_api_name,SQLERRM);
158: END IF;
159:
160: -- Standard call to get message count and if count is 1, get message info.
161: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

Line 161: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

157: FND_MSG_PUB.add_exc_msg(G_PKG_NAME,l_api_name,SQLERRM);
158: END IF;
159:
160: -- Standard call to get message count and if count is 1, get message info.
161: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
162: p_data => x_msg_data );
163:
164: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'OTHERS End'); END IF;
165: EXCEPTION

Line 181: -- c) FND_MSG_PUB on unhandled exceptions.

177: -- a) PO Interface Tables (inserts new po_header_id for successful rows, back
178: -- to the Interface tables.
179: -- b) PO_INTERFACE_ERRORS table: Inserts error messages for those rows that
180: -- failed the migration.
181: -- c) FND_MSG_PUB on unhandled exceptions.
182: --Locks:
183: -- None.
184: --Function:
185: -- Migrate the iP Catalog Data to PO. This API should be called during the

Line 274: FND_MSG_PUB.initialize;

270:
271: l_progress := '020';
272: -- Initialize message list if p_init_msg_list is set to TRUE.
273: IF FND_API.to_boolean(p_init_msg_list) THEN
274: FND_MSG_PUB.initialize;
275: END IF;
276:
277: l_progress := '030';
278: -- Initialize API return status to success

Line 375: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

371:
372: l_progress := '120';
373:
374: -- Standard call to get message count and if count is 1, get message info.
375: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
376: p_data => x_msg_data );
377:
378: l_progress := '130';
379: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'END'); END IF;

Line 384: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

380: EXCEPTION
381: WHEN FND_API.G_EXC_ERROR THEN
382: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'EXPECTED Start'); END IF;
383: x_return_status := FND_API.G_RET_STS_ERROR ;
384: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
385: p_data => x_msg_data );
386: IF g_debug THEN
387: PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'x_return_status='||x_return_status);
388: PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'EXPECTED End');

Line 394: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

390:
391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
392: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'UNEXPECTED Start'); END IF;
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
394: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
395: p_data => x_msg_data );
396: IF g_debug THEN
397: PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'x_return_status='||x_return_status);
398: PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'UNEXPECTED End');

Line 411: --IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

407:
408: --TODO: remove after manual UT
409: RAISE_APPLICATION_ERROR(-20000,l_module||','||l_progress || ','|| SQLERRM);
410:
411: --IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
412: -- FND_MSG_PUB.add_exc_msg(G_PKG_NAME,l_api_name,SQLERRM);
413: --END IF;
414:
415: -- Standard call to get message count and if count is 1, get message info.

Line 412: -- FND_MSG_PUB.add_exc_msg(G_PKG_NAME,l_api_name,SQLERRM);

408: --TODO: remove after manual UT
409: RAISE_APPLICATION_ERROR(-20000,l_module||','||l_progress || ','|| SQLERRM);
410:
411: --IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
412: -- FND_MSG_PUB.add_exc_msg(G_PKG_NAME,l_api_name,SQLERRM);
413: --END IF;
414:
415: -- Standard call to get message count and if count is 1, get message info.
416: --FND_MSG_PUB.count_and_get(p_count => x_msg_count,

Line 416: --FND_MSG_PUB.count_and_get(p_count => x_msg_count,

412: -- FND_MSG_PUB.add_exc_msg(G_PKG_NAME,l_api_name,SQLERRM);
413: --END IF;
414:
415: -- Standard call to get message count and if count is 1, get message info.
416: --FND_MSG_PUB.count_and_get(p_count => x_msg_count,
417: -- p_data => x_msg_data );
418:
419: --IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'x_msg_count='||x_msg_count); END IF;
420: --IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'x_msg_data='||x_msg_data); END IF;