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_API

Line 42: -- FND_API.g_ret_sts_success - if the procedure completed successfully

38: -- processing each batch.
39: --OUT:
40: --x_return_status
41: -- Apps API Std
42: -- FND_API.g_ret_sts_success - if the procedure completed successfully
43: -- FND_API.g_ret_sts_error - if an error occurred
44: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
45: --x_msg_count
46: -- Apps API Std

Line 43: -- FND_API.g_ret_sts_error - if an error occurred

39: --OUT:
40: --x_return_status
41: -- Apps API Std
42: -- FND_API.g_ret_sts_success - if the procedure completed successfully
43: -- FND_API.g_ret_sts_error - if an error occurred
44: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
45: --x_msg_count
46: -- Apps API Std
47: -- The number of error messages returned in the FND error stack in case

Line 44: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred

40: --x_return_status
41: -- Apps API Std
42: -- FND_API.g_ret_sts_success - if the procedure completed successfully
43: -- FND_API.g_ret_sts_error - if an error occurred
44: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
45: --x_msg_count
46: -- Apps API Std
47: -- The number of error messages returned in the FND error stack in case
48: -- x_return_status returned FND_API.G_RET_STS_ERROR or

Line 48: -- x_return_status returned FND_API.G_RET_STS_ERROR or

44: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
45: --x_msg_count
46: -- Apps API Std
47: -- The number of error messages returned in the FND error stack in case
48: -- x_return_status returned FND_API.G_RET_STS_ERROR or
49: -- FND_API.G_RET_STS_UNEXP_ERROR
50: --x_msg_data
51: -- Apps API Std
52: -- Contains error msg in case x_return_status returned FND_API.G_RET_STS_ERROR

Line 49: -- FND_API.G_RET_STS_UNEXP_ERROR

45: --x_msg_count
46: -- Apps API Std
47: -- The number of error messages returned in the FND error stack in case
48: -- x_return_status returned FND_API.G_RET_STS_ERROR or
49: -- FND_API.G_RET_STS_UNEXP_ERROR
50: --x_msg_data
51: -- Apps API Std
52: -- Contains error msg in case x_return_status returned FND_API.G_RET_STS_ERROR
53: -- or FND_API.G_RET_STS_UNEXP_ERROR

Line 52: -- Contains error msg in case x_return_status returned FND_API.G_RET_STS_ERROR

48: -- x_return_status returned FND_API.G_RET_STS_ERROR or
49: -- FND_API.G_RET_STS_UNEXP_ERROR
50: --x_msg_data
51: -- Apps API Std
52: -- Contains error msg in case x_return_status returned FND_API.G_RET_STS_ERROR
53: -- or FND_API.G_RET_STS_UNEXP_ERROR
54: --
55: --End of Comments
56: --------------------------------------------------------------------------------

Line 53: -- or FND_API.G_RET_STS_UNEXP_ERROR

49: -- FND_API.G_RET_STS_UNEXP_ERROR
50: --x_msg_data
51: -- Apps API Std
52: -- Contains error msg in case x_return_status returned FND_API.G_RET_STS_ERROR
53: -- or FND_API.G_RET_STS_UNEXP_ERROR
54: --
55: --End of Comments
56: --------------------------------------------------------------------------------
57: PROCEDURE upgrade_existing_docs

Line 60: , p_commit IN VARCHAR2 default FND_API.G_FALSE

56: --------------------------------------------------------------------------------
57: PROCEDURE upgrade_existing_docs
58: (
59: p_api_version IN NUMBER
60: , p_commit IN VARCHAR2 default FND_API.G_FALSE
61: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
62: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
63: , p_log_level IN NUMBER default 1
64: , p_batch_size IN NUMBER default 2500

Line 61: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

57: PROCEDURE upgrade_existing_docs
58: (
59: p_api_version IN NUMBER
60: , p_commit IN VARCHAR2 default FND_API.G_FALSE
61: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
62: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
63: , p_log_level IN NUMBER default 1
64: , p_batch_size IN NUMBER default 2500
65: , x_return_status OUT NOCOPY VARCHAR2

Line 62: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

58: (
59: p_api_version IN NUMBER
60: , p_commit IN VARCHAR2 default FND_API.G_FALSE
61: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
62: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
63: , p_log_level IN NUMBER default 1
64: , p_batch_size IN NUMBER default 2500
65: , x_return_status OUT NOCOPY VARCHAR2
66: , x_msg_count OUT NOCOPY NUMBER

Line 85: IF NOT FND_API.compatible_API_call(

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,
87: p_caller_version_number => p_api_version,
88: p_api_name => l_api_name,
89: p_pkg_name => g_pkg_name)

Line 91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

87: p_caller_version_number => p_api_version,
88: p_api_name => l_api_name,
89: p_pkg_name => g_pkg_name)
90: THEN
91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: END IF;
93:
94: l_progress := '020';
95: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 96: IF FND_API.to_boolean(p_init_msg_list) THEN

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

Line 102: x_return_status := FND_API.G_RET_STS_SUCCESS;

98: END IF;
99:
100: l_progress := '030';
101: -- Initialize API return status to success
102: x_return_status := FND_API.G_RET_STS_SUCCESS;
103: x_msg_count := 0;
104: x_msg_data := NULL;
105:
106: l_progress := '040';

Line 112: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

108: PO_R12_CAT_UPG_EXISTING_DOCS.upgrade_existing_docs(
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';

Line 114: END IF; -- IF (l_return_status = FND_API.G_RET_STS_SUCCESS)

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.
118: IF FND_API.to_boolean(p_commit) THEN

Line 118: IF FND_API.to_boolean(p_commit) THEN

114: END IF; -- IF (l_return_status = FND_API.G_RET_STS_SUCCESS)
115:
116: l_progress := '050';
117: -- Standard check of p_commit.
118: IF FND_API.to_boolean(p_commit) THEN
119: COMMIT;
120: END IF;
121:
122: l_progress := '110';

Line 129: WHEN FND_API.G_EXC_ERROR THEN

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 ;
132: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
133: p_data => x_msg_data );

Line 131: x_return_status := FND_API.G_RET_STS_ERROR ;

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
135: PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'x_return_status='||x_return_status);

Line 139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR 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;
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 );

Line 141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
145: PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'x_return_status='||x_return_status);

Line 152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
156: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 208: -- FND_API.g_ret_sts_success - if the procedure completed successfully

204: -- processing each batch.
205: --OUT:
206: --x_return_status
207: -- Apps API Std
208: -- FND_API.g_ret_sts_success - if the procedure completed successfully
209: -- FND_API.g_ret_sts_error - if an error occurred
210: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
211: --x_msg_count
212: -- Apps API Std

Line 209: -- FND_API.g_ret_sts_error - if an error occurred

205: --OUT:
206: --x_return_status
207: -- Apps API Std
208: -- FND_API.g_ret_sts_success - if the procedure completed successfully
209: -- FND_API.g_ret_sts_error - if an error occurred
210: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
211: --x_msg_count
212: -- Apps API Std
213: -- The number of error messages returned in the FND error stack in case

Line 210: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred

206: --x_return_status
207: -- Apps API Std
208: -- FND_API.g_ret_sts_success - if the procedure completed successfully
209: -- FND_API.g_ret_sts_error - if an error occurred
210: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
211: --x_msg_count
212: -- Apps API Std
213: -- The number of error messages returned in the FND error stack in case
214: -- x_return_status returned FND_API.G_RET_STS_ERROR or

Line 214: -- x_return_status returned FND_API.G_RET_STS_ERROR or

210: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
211: --x_msg_count
212: -- Apps API Std
213: -- The number of error messages returned in the FND error stack in case
214: -- x_return_status returned FND_API.G_RET_STS_ERROR or
215: -- FND_API.G_RET_STS_UNEXP_ERROR
216: --x_msg_data
217: -- Apps API Std
218: -- Contains error msg in case x_return_status returned FND_API.G_RET_STS_ERROR

Line 215: -- FND_API.G_RET_STS_UNEXP_ERROR

211: --x_msg_count
212: -- Apps API Std
213: -- The number of error messages returned in the FND error stack in case
214: -- x_return_status returned FND_API.G_RET_STS_ERROR or
215: -- FND_API.G_RET_STS_UNEXP_ERROR
216: --x_msg_data
217: -- Apps API Std
218: -- Contains error msg in case x_return_status returned FND_API.G_RET_STS_ERROR
219: -- or FND_API.G_RET_STS_UNEXP_ERROR

Line 218: -- Contains error msg in case x_return_status returned FND_API.G_RET_STS_ERROR

214: -- x_return_status returned FND_API.G_RET_STS_ERROR or
215: -- FND_API.G_RET_STS_UNEXP_ERROR
216: --x_msg_data
217: -- Apps API Std
218: -- Contains error msg in case x_return_status returned FND_API.G_RET_STS_ERROR
219: -- or FND_API.G_RET_STS_UNEXP_ERROR
220: --
221: --End of Comments
222: --------------------------------------------------------------------------------

Line 219: -- or FND_API.G_RET_STS_UNEXP_ERROR

215: -- FND_API.G_RET_STS_UNEXP_ERROR
216: --x_msg_data
217: -- Apps API Std
218: -- Contains error msg in case x_return_status returned FND_API.G_RET_STS_ERROR
219: -- or FND_API.G_RET_STS_UNEXP_ERROR
220: --
221: --End of Comments
222: --------------------------------------------------------------------------------
223: PROCEDURE migrate_catalog

Line 226: , p_commit IN VARCHAR2 default FND_API.G_FALSE

222: --------------------------------------------------------------------------------
223: PROCEDURE migrate_catalog
224: (
225: p_api_version IN NUMBER
226: , p_commit IN VARCHAR2 default FND_API.G_FALSE
227: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
228: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
229: , p_log_level IN NUMBER default 1
230: , p_batch_id IN NUMBER

Line 227: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

223: PROCEDURE migrate_catalog
224: (
225: p_api_version IN NUMBER
226: , p_commit IN VARCHAR2 default FND_API.G_FALSE
227: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
228: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
229: , p_log_level IN NUMBER default 1
230: , p_batch_id IN NUMBER
231: , p_batch_size IN NUMBER default 2500

Line 228: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

224: (
225: p_api_version IN NUMBER
226: , p_commit IN VARCHAR2 default FND_API.G_FALSE
227: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
228: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
229: , p_log_level IN NUMBER default 1
230: , p_batch_id IN NUMBER
231: , p_batch_size IN NUMBER default 2500
232: , p_validate_only_mode IN VARCHAR2 default FND_API.G_FALSE

Line 232: , p_validate_only_mode IN VARCHAR2 default FND_API.G_FALSE

228: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
229: , p_log_level IN NUMBER default 1
230: , p_batch_id IN NUMBER
231: , p_batch_size IN NUMBER default 2500
232: , p_validate_only_mode IN VARCHAR2 default FND_API.G_FALSE
233: , x_return_status OUT NOCOPY VARCHAR2
234: , x_msg_count OUT NOCOPY NUMBER
235: , x_msg_data OUT NOCOPY VARCHAR2
236: )

Line 262: IF NOT FND_API.compatible_API_call(

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,
264: p_caller_version_number => p_api_version,
265: p_api_name => l_api_name,
266: p_pkg_name => g_pkg_name)

Line 268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

264: p_caller_version_number => p_api_version,
265: p_api_name => l_api_name,
266: p_pkg_name => g_pkg_name)
267: THEN
268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
269: END IF;
270:
271: l_progress := '020';
272: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 273: IF FND_API.to_boolean(p_init_msg_list) THEN

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

Line 279: x_return_status := FND_API.G_RET_STS_SUCCESS;

275: END IF;
276:
277: l_progress := '030';
278: -- Initialize API return status to success
279: x_return_status := FND_API.G_RET_STS_SUCCESS;
280: x_msg_count := 0;
281: x_msg_data := NULL;
282:
283: PO_R12_CAT_UPG_PVT.get_distinct_orgs(

Line 325: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

321: , x_msg_count => x_msg_count
322: , x_msg_data => x_msg_data);
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:

Line 331: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

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
332: -- Migrate Attribute data for GBPA, BPA, Quotation and ReqTemplates
333: PO_R12_CAT_UPG_PVT.migrate_attributes(p_validate_only_mode => p_validate_only_mode);
334: END IF; -- IF (l_return_status = FND_API.G_RET_STS_SUCCESS)
335:

Line 334: END IF; -- IF (l_return_status = FND_API.G_RET_STS_SUCCESS)

330: l_progress := '070';
331: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
332: -- Migrate Attribute data for GBPA, BPA, Quotation and ReqTemplates
333: PO_R12_CAT_UPG_PVT.migrate_attributes(p_validate_only_mode => p_validate_only_mode);
334: END IF; -- IF (l_return_status = FND_API.G_RET_STS_SUCCESS)
335:
336: l_progress := '080';
337: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
338: -- Migrate TLP data for GBPA, BPA, Quotation and ReqTemplates

Line 337: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

333: PO_R12_CAT_UPG_PVT.migrate_attributes(p_validate_only_mode => p_validate_only_mode);
334: END IF; -- IF (l_return_status = FND_API.G_RET_STS_SUCCESS)
335:
336: l_progress := '080';
337: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
338: -- Migrate TLP data for GBPA, BPA, Quotation and ReqTemplates
339: PO_R12_CAT_UPG_PVT.migrate_attributes_tlp(p_validate_only_mode => p_validate_only_mode);
340: END IF; -- IF (l_return_status = FND_API.G_RET_STS_SUCCESS)
341:

Line 340: END IF; -- IF (l_return_status = FND_API.G_RET_STS_SUCCESS)

336: l_progress := '080';
337: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
338: -- Migrate TLP data for GBPA, BPA, Quotation and ReqTemplates
339: PO_R12_CAT_UPG_PVT.migrate_attributes_tlp(p_validate_only_mode => p_validate_only_mode);
340: END IF; -- IF (l_return_status = FND_API.G_RET_STS_SUCCESS)
341:
342: l_progress := '090';
343: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
344: -- Migrate the data for ReqTemplates

Line 343: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

339: PO_R12_CAT_UPG_PVT.migrate_attributes_tlp(p_validate_only_mode => p_validate_only_mode);
340: END IF; -- IF (l_return_status = FND_API.G_RET_STS_SUCCESS)
341:
342: l_progress := '090';
343: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
344: -- Migrate the data for ReqTemplates
345: PO_R12_CAT_UPG_PVT.update_req_templates
346: ( p_batch_size => p_batch_size
347: , p_validate_only_mode => p_validate_only_mode

Line 351: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

347: , p_validate_only_mode => p_validate_only_mode
348: , x_return_status => l_return_status);
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)

Line 355: END IF; -- IF (l_return_status = FND_API.G_RET_STS_SUCCESS)

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';
358:
359: -- If all lines for a header have errors, then do not create the header.

Line 368: IF FND_API.to_boolean(p_commit) THEN

364:
365: l_progress := '110';
366:
367: -- Standard check of p_commit.
368: IF FND_API.to_boolean(p_commit) THEN
369: COMMIT;
370: END IF;
371:
372: l_progress := '120';

Line 381: WHEN FND_API.G_EXC_ERROR THEN

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 ;
384: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
385: p_data => x_msg_data );

Line 383: x_return_status := FND_API.G_RET_STS_ERROR ;

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
387: PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'x_return_status='||x_return_status);

Line 391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR 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;
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 );

Line 393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
397: PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'x_return_status='||x_return_status);

Line 404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
408: --TODO: remove after manual UT