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 PO_R12_CAT_UPG_DEBUG

Line 79: PO_R12_CAT_UPG_DEBUG.set_logging_options(p_log_level => p_log_level);

75: BEGIN
76: l_progress := '010';
77:
78: -- Set logging options
79: PO_R12_CAT_UPG_DEBUG.set_logging_options(p_log_level => p_log_level);
80: g_debug := PO_R12_CAT_UPG_DEBUG.is_logging_enabled;
81:
82: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'START'); END IF;
83:

Line 80: g_debug := PO_R12_CAT_UPG_DEBUG.is_logging_enabled;

76: l_progress := '010';
77:
78: -- Set logging options
79: PO_R12_CAT_UPG_DEBUG.set_logging_options(p_log_level => p_log_level);
80: g_debug := PO_R12_CAT_UPG_DEBUG.is_logging_enabled;
81:
82: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'START'); END IF;
83:
84: -- Standard call to check for call compatibility

Line 82: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'START'); END IF;

78: -- Set logging options
79: PO_R12_CAT_UPG_DEBUG.set_logging_options(p_log_level => p_log_level);
80: g_debug := PO_R12_CAT_UPG_DEBUG.is_logging_enabled;
81:
82: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'START'); END IF;
83:
84: -- Standard call to check for call compatibility
85: IF NOT FND_API.compatible_API_call(
86: p_current_version_number => l_api_version,

Line 113: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'Migration failed.'); END IF;

109: p_batch_size => p_batch_size
110: , x_return_status => x_return_status);
111:
112: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
113: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'Migration failed.'); END IF;
114: END IF; -- IF (l_return_status = FND_API.G_RET_STS_SUCCESS)
115:
116: l_progress := '050';
117: -- Standard check of p_commit.

Line 127: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'END'); END IF;

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
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 ;

Line 130: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'EXPECTED Start'); END IF;

126:
127: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'END'); END IF;
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

Line 135: PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'x_return_status='||x_return_status);

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');
137: END IF;
138:
139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 136: PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'EXPECTED End');

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');
137: END IF;
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;

Line 140: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'UNEXPECTED Start'); END IF;

136: PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'EXPECTED End');
137: END IF;
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

Line 145: PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'x_return_status='||x_return_status);

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');
147: END IF;
148:
149: WHEN OTHERS THEN

Line 146: PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'UNEXPECTED End');

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');
147: END IF;
148:
149: WHEN OTHERS THEN
150: BEGIN

Line 151: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'OTHERS Start'); END IF;

147: END IF;
148:
149: WHEN OTHERS THEN
150: BEGIN
151: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'OTHERS Start'); END IF;
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:

Line 154: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'x_return_status='||x_return_status); END IF;

150: BEGIN
151: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'OTHERS Start'); END IF;
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;

Line 164: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'OTHERS End'); END IF;

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
166: WHEN OTHERS THEN
167: NULL; -- If exception occurs inside the outer exception handling block, ignore it.
168: END;

Line 248: PO_R12_CAT_UPG_DEBUG.set_logging_options(p_log_level => p_log_level);

244: BEGIN
245: l_progress := '010';
246:
247: -- Set logging options
248: PO_R12_CAT_UPG_DEBUG.set_logging_options(p_log_level => p_log_level);
249: g_debug := PO_R12_CAT_UPG_DEBUG.is_logging_enabled;
250:
251: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'START'); END IF;
252: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_api_version='||p_api_version); END IF;

Line 249: g_debug := PO_R12_CAT_UPG_DEBUG.is_logging_enabled;

245: l_progress := '010';
246:
247: -- Set logging options
248: PO_R12_CAT_UPG_DEBUG.set_logging_options(p_log_level => p_log_level);
249: g_debug := PO_R12_CAT_UPG_DEBUG.is_logging_enabled;
250:
251: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'START'); END IF;
252: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_api_version='||p_api_version); END IF;
253: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_commit='||p_commit); END IF;

Line 251: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'START'); END IF;

247: -- Set logging options
248: PO_R12_CAT_UPG_DEBUG.set_logging_options(p_log_level => p_log_level);
249: g_debug := PO_R12_CAT_UPG_DEBUG.is_logging_enabled;
250:
251: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'START'); END IF;
252: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_api_version='||p_api_version); END IF;
253: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_commit='||p_commit); END IF;
254: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_init_msg_list='||p_init_msg_list); END IF;
255: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_validation_level='||p_validation_level); END IF;

Line 252: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_api_version='||p_api_version); END IF;

248: PO_R12_CAT_UPG_DEBUG.set_logging_options(p_log_level => p_log_level);
249: g_debug := PO_R12_CAT_UPG_DEBUG.is_logging_enabled;
250:
251: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'START'); END IF;
252: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_api_version='||p_api_version); END IF;
253: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_commit='||p_commit); END IF;
254: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_init_msg_list='||p_init_msg_list); END IF;
255: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_validation_level='||p_validation_level); END IF;
256: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_log_level='||p_log_level); END IF;

Line 253: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_commit='||p_commit); END IF;

249: g_debug := PO_R12_CAT_UPG_DEBUG.is_logging_enabled;
250:
251: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'START'); END IF;
252: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_api_version='||p_api_version); END IF;
253: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_commit='||p_commit); END IF;
254: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_init_msg_list='||p_init_msg_list); END IF;
255: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_validation_level='||p_validation_level); END IF;
256: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_log_level='||p_log_level); END IF;
257: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_batch_id='||p_batch_id); END IF;

Line 254: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_init_msg_list='||p_init_msg_list); END IF;

250:
251: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'START'); END IF;
252: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_api_version='||p_api_version); END IF;
253: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_commit='||p_commit); END IF;
254: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_init_msg_list='||p_init_msg_list); END IF;
255: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_validation_level='||p_validation_level); END IF;
256: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_log_level='||p_log_level); END IF;
257: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_batch_id='||p_batch_id); END IF;
258: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_batch_size='||p_batch_size); END IF;

Line 255: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_validation_level='||p_validation_level); END IF;

251: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'START'); END IF;
252: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_api_version='||p_api_version); END IF;
253: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_commit='||p_commit); END IF;
254: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_init_msg_list='||p_init_msg_list); END IF;
255: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_validation_level='||p_validation_level); END IF;
256: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_log_level='||p_log_level); END IF;
257: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_batch_id='||p_batch_id); END IF;
258: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_batch_size='||p_batch_size); END IF;
259: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_validate_only_mode='||p_validate_only_mode); END IF;

Line 256: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_log_level='||p_log_level); END IF;

252: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_api_version='||p_api_version); END IF;
253: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_commit='||p_commit); END IF;
254: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_init_msg_list='||p_init_msg_list); END IF;
255: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_validation_level='||p_validation_level); END IF;
256: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_log_level='||p_log_level); END IF;
257: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_batch_id='||p_batch_id); END IF;
258: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_batch_size='||p_batch_size); END IF;
259: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_validate_only_mode='||p_validate_only_mode); END IF;
260:

Line 257: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_batch_id='||p_batch_id); END IF;

253: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_commit='||p_commit); END IF;
254: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_init_msg_list='||p_init_msg_list); END IF;
255: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_validation_level='||p_validation_level); END IF;
256: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_log_level='||p_log_level); END IF;
257: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_batch_id='||p_batch_id); END IF;
258: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_batch_size='||p_batch_size); END IF;
259: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_validate_only_mode='||p_validate_only_mode); END IF;
260:
261: -- Standard call to check for call compatibility

Line 258: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_batch_size='||p_batch_size); END IF;

254: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_init_msg_list='||p_init_msg_list); END IF;
255: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_validation_level='||p_validation_level); END IF;
256: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_log_level='||p_log_level); END IF;
257: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_batch_id='||p_batch_id); END IF;
258: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_batch_size='||p_batch_size); END IF;
259: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_validate_only_mode='||p_validate_only_mode); END IF;
260:
261: -- Standard call to check for call compatibility
262: IF NOT FND_API.compatible_API_call(

Line 259: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_validate_only_mode='||p_validate_only_mode); END IF;

255: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_validation_level='||p_validation_level); END IF;
256: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_log_level='||p_log_level); END IF;
257: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_batch_id='||p_batch_id); END IF;
258: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_batch_size='||p_batch_size); END IF;
259: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'p_validate_only_mode='||p_validate_only_mode); END IF;
260:
261: -- Standard call to check for call compatibility
262: IF NOT FND_API.compatible_API_call(
263: p_current_version_number => l_api_version,

Line 311: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'Migration for org='||PO_R12_CAT_UPG_PVT.g_job.org_id); END IF;

307: /*PO_UC12*/
308: mo_global.set_policy_context('S', PO_R12_CAT_UPG_PVT.g_job.org_id); -- Bug#5259328
309: /*/PO_UC12*/
310:
311: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'Migration for org='||PO_R12_CAT_UPG_PVT.g_job.org_id); END IF;
312:
313: l_progress := '060';
314: -- Migrate GBPA, BPA, Quotation (Headers and Lines) from interface tables
315: PO_R12_CAT_UPG_PVT.migrate_documents

Line 327: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'Document migration failed.'); END IF;

323:
324: -- If return status is not success, no further migration should be performed
325: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
326: x_return_status := l_return_status;
327: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'Document migration failed.'); END IF;
328: END IF;
329:
330: l_progress := '070';
331: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 353: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'Document migration failed.'); END IF;

349:
350: -- If return status is not success, no further migration should be performed
351: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
352: x_return_status := l_return_status;
353: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'Document migration failed.'); END IF;
354: END IF;
355: END IF; -- IF (l_return_status = FND_API.G_RET_STS_SUCCESS)
356:
357: l_progress := '100';

Line 379: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'END'); END IF;

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;
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 ;

Line 382: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'EXPECTED Start'); END IF;

378: l_progress := '130';
379: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'END'); END IF;
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

Line 387: PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'x_return_status='||x_return_status);

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');
389: END IF;
390:
391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 388: PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'EXPECTED End');

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');
389: END IF;
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;

Line 392: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'UNEXPECTED Start'); END IF;

388: PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'EXPECTED End');
389: END IF;
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

Line 397: PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'x_return_status='||x_return_status);

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');
399: END IF;
400:
401: WHEN OTHERS THEN

Line 398: PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'UNEXPECTED End');

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');
399: END IF;
400:
401: WHEN OTHERS THEN
402: BEGIN

Line 403: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'OTHERS Start'); END IF;

399: END IF;
400:
401: WHEN OTHERS THEN
402: BEGIN
403: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'OTHERS Start'); END IF;
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405:
406: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'x_return_status='||x_return_status); END IF;
407:

Line 406: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'x_return_status='||x_return_status); END IF;

402: BEGIN
403: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'OTHERS Start'); END IF;
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405:
406: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'x_return_status='||x_return_status); END IF;
407:
408: --TODO: remove after manual UT
409: RAISE_APPLICATION_ERROR(-20000,l_module||','||l_progress || ','|| SQLERRM);
410:

Line 419: --IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'x_msg_count='||x_msg_count); END IF;

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;
421:
422: --IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'OTHERS End'); END IF;
423:

Line 420: --IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'x_msg_data='||x_msg_data); END IF;

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;
421:
422: --IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'OTHERS End'); END IF;
423:
424: EXCEPTION

Line 422: --IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'OTHERS End'); END IF;

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;
421:
422: --IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'OTHERS End'); END IF;
423:
424: EXCEPTION
425: WHEN OTHERS THEN
426: NULL; -- If exception occurs inside the outer exception handling block, ignore it.