72: ROLLBACK TO sp_adv_mon;
73: x_return_status := Fnd_Api.G_RET_STS_ERROR;
74: x_msg_count := l_msg_count ;
75: x_msg_data := l_msg_data ;
76: Fnd_Msg_Pub.count_and_get(
77: p_count => x_msg_count
78: ,p_data => x_msg_data);
79: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
80: ROLLBACK TO sp_adv_mon;
80: ROLLBACK TO sp_adv_mon;
81: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
82: x_msg_count := l_msg_count ;
83: x_msg_data := l_msg_data ;
84: Fnd_Msg_Pub.count_and_get(
85: p_count => x_msg_count
86: ,p_data => x_msg_data);
87: WHEN OTHERS THEN
88: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
85: p_count => x_msg_count
86: ,p_data => x_msg_data);
87: WHEN OTHERS THEN
88: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
89: Fnd_Msg_Pub.ADD_EXC_MSG (
90: p_pkg_name => G_PKG_NAME,
91: p_procedure_name => l_api_name);
92: Fnd_Msg_Pub.Count_and_get (
93: p_encoded => Okc_Api.G_FALSE,
88: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
89: Fnd_Msg_Pub.ADD_EXC_MSG (
90: p_pkg_name => G_PKG_NAME,
91: p_procedure_name => l_api_name);
92: Fnd_Msg_Pub.Count_and_get (
93: p_encoded => Okc_Api.G_FALSE,
94: p_count => x_msg_count,
95: p_data => x_msg_data);
96:
175: ROLLBACK TO sp_adv_mon;
176: x_return_status := Fnd_Api.G_RET_STS_ERROR;
177: x_msg_count := l_msg_count ;
178: x_msg_data := l_msg_data ;
179: Fnd_Msg_Pub.count_and_get(
180: p_count => x_msg_count
181: ,p_data => x_msg_data);
182: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
183: ROLLBACK TO sp_adv_mon;
183: ROLLBACK TO sp_adv_mon;
184: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
185: x_msg_count := l_msg_count ;
186: x_msg_data := l_msg_data ;
187: Fnd_Msg_Pub.count_and_get(
188: p_count => x_msg_count
189: ,p_data => x_msg_data);
190: WHEN OTHERS THEN
191: ROLLBACK TO sp_adv_mon;
189: ,p_data => x_msg_data);
190: WHEN OTHERS THEN
191: ROLLBACK TO sp_adv_mon;
192: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
193: Fnd_Msg_Pub.ADD_EXC_MSG (
194: p_pkg_name => G_PKG_NAME,
195: p_procedure_name => l_api_name);
196: Fnd_Msg_Pub.Count_and_get (
197: p_encoded => Okc_Api.G_FALSE,
192: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
193: Fnd_Msg_Pub.ADD_EXC_MSG (
194: p_pkg_name => G_PKG_NAME,
195: p_procedure_name => l_api_name);
196: Fnd_Msg_Pub.Count_and_get (
197: p_encoded => Okc_Api.G_FALSE,
198: p_count => x_msg_count,
199: p_data => x_msg_data);
200:
318: WHEN okl_api.g_exception_error THEN
319: retcode := 2;
320: -- print the error message in the output file
321:
322: IF (fnd_msg_pub.count_msg > 0) THEN
323:
324: FOR l_counter IN 1..fnd_msg_pub.count_msg LOOP
325: fnd_msg_pub.get(p_msg_index => l_counter
326: ,p_encoded => 'F'
320: -- print the error message in the output file
321:
322: IF (fnd_msg_pub.count_msg > 0) THEN
323:
324: FOR l_counter IN 1..fnd_msg_pub.count_msg LOOP
325: fnd_msg_pub.get(p_msg_index => l_counter
326: ,p_encoded => 'F'
327: ,p_data => l_data
328: ,p_msg_index_out => l_msg_index_out);
321:
322: IF (fnd_msg_pub.count_msg > 0) THEN
323:
324: FOR l_counter IN 1..fnd_msg_pub.count_msg LOOP
325: fnd_msg_pub.get(p_msg_index => l_counter
326: ,p_encoded => 'F'
327: ,p_data => l_data
328: ,p_msg_index_out => l_msg_index_out);
329: fnd_file.put_line(fnd_file.log, l_data);
335: retcode := 2;
336:
337: -- print the error message in the output file
338:
339: IF (fnd_msg_pub.count_msg > 0) THEN
340:
341: FOR l_counter IN 1..fnd_msg_pub.count_msg LOOP
342: fnd_msg_pub.get(p_msg_index => l_counter
343: ,p_encoded => 'F'
337: -- print the error message in the output file
338:
339: IF (fnd_msg_pub.count_msg > 0) THEN
340:
341: FOR l_counter IN 1..fnd_msg_pub.count_msg LOOP
342: fnd_msg_pub.get(p_msg_index => l_counter
343: ,p_encoded => 'F'
344: ,p_data => l_data
345: ,p_msg_index_out => l_msg_index_out);
338:
339: IF (fnd_msg_pub.count_msg > 0) THEN
340:
341: FOR l_counter IN 1..fnd_msg_pub.count_msg LOOP
342: fnd_msg_pub.get(p_msg_index => l_counter
343: ,p_encoded => 'F'
344: ,p_data => l_data
345: ,p_msg_index_out => l_msg_index_out);
346: fnd_file.put_line(fnd_file.log, l_data);
353: errbuf := sqlerrm;
354:
355: -- print the error message in the output file
356:
357: IF (fnd_msg_pub.count_msg > 0) THEN
358:
359: FOR l_counter IN 1..fnd_msg_pub.count_msg LOOP
360: fnd_msg_pub.get(p_msg_index => l_counter
361: ,p_encoded => 'F'
355: -- print the error message in the output file
356:
357: IF (fnd_msg_pub.count_msg > 0) THEN
358:
359: FOR l_counter IN 1..fnd_msg_pub.count_msg LOOP
360: fnd_msg_pub.get(p_msg_index => l_counter
361: ,p_encoded => 'F'
362: ,p_data => l_data
363: ,p_msg_index_out => l_msg_index_out);
356:
357: IF (fnd_msg_pub.count_msg > 0) THEN
358:
359: FOR l_counter IN 1..fnd_msg_pub.count_msg LOOP
360: fnd_msg_pub.get(p_msg_index => l_counter
361: ,p_encoded => 'F'
362: ,p_data => l_data
363: ,p_msg_index_out => l_msg_index_out);
364: fnd_file.put_line(fnd_file.log, l_data);
431: ROLLBACK TO sp_adv_mon_w_rcpt;
432: x_return_status := Fnd_Api.G_RET_STS_ERROR;
433: x_msg_count := l_msg_count ;
434: x_msg_data := l_msg_data ;
435: Fnd_Msg_Pub.count_and_get(
436: p_count => x_msg_count
437: ,p_data => x_msg_data);
438: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
439: ROLLBACK TO sp_adv_mon_w_rcpt;
439: ROLLBACK TO sp_adv_mon_w_rcpt;
440: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
441: x_msg_count := l_msg_count ;
442: x_msg_data := l_msg_data ;
443: Fnd_Msg_Pub.count_and_get(
444: p_count => x_msg_count
445: ,p_data => x_msg_data);
446: WHEN OTHERS THEN
447: ROLLBACK TO sp_adv_mon_w_rcpt;
445: ,p_data => x_msg_data);
446: WHEN OTHERS THEN
447: ROLLBACK TO sp_adv_mon_w_rcpt;
448: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
449: Fnd_Msg_Pub.ADD_EXC_MSG (
450: p_pkg_name => G_PKG_NAME,
451: p_procedure_name => l_api_name);
452: Fnd_Msg_Pub.Count_and_get (
453: p_encoded => Okc_Api.G_FALSE,
448: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
449: Fnd_Msg_Pub.ADD_EXC_MSG (
450: p_pkg_name => G_PKG_NAME,
451: p_procedure_name => l_api_name);
452: Fnd_Msg_Pub.Count_and_get (
453: p_encoded => Okc_Api.G_FALSE,
454: p_count => x_msg_count,
455: p_data => x_msg_data);
456:
544: WHEN okl_api.g_exception_error THEN
545: retcode := 2;
546: -- print the error message in the output file
547:
548: IF (fnd_msg_pub.count_msg > 0) THEN
549:
550: FOR l_counter IN 1..fnd_msg_pub.count_msg LOOP
551: fnd_msg_pub.get(p_msg_index => l_counter
552: ,p_encoded => 'F'
546: -- print the error message in the output file
547:
548: IF (fnd_msg_pub.count_msg > 0) THEN
549:
550: FOR l_counter IN 1..fnd_msg_pub.count_msg LOOP
551: fnd_msg_pub.get(p_msg_index => l_counter
552: ,p_encoded => 'F'
553: ,p_data => l_data
554: ,p_msg_index_out => l_msg_index_out);
547:
548: IF (fnd_msg_pub.count_msg > 0) THEN
549:
550: FOR l_counter IN 1..fnd_msg_pub.count_msg LOOP
551: fnd_msg_pub.get(p_msg_index => l_counter
552: ,p_encoded => 'F'
553: ,p_data => l_data
554: ,p_msg_index_out => l_msg_index_out);
555: fnd_file.put_line(fnd_file.log, l_data);
561: retcode := 2;
562:
563: -- print the error message in the output file
564:
565: IF (fnd_msg_pub.count_msg > 0) THEN
566:
567: FOR l_counter IN 1..fnd_msg_pub.count_msg LOOP
568: fnd_msg_pub.get(p_msg_index => l_counter
569: ,p_encoded => 'F'
563: -- print the error message in the output file
564:
565: IF (fnd_msg_pub.count_msg > 0) THEN
566:
567: FOR l_counter IN 1..fnd_msg_pub.count_msg LOOP
568: fnd_msg_pub.get(p_msg_index => l_counter
569: ,p_encoded => 'F'
570: ,p_data => l_data
571: ,p_msg_index_out => l_msg_index_out);
564:
565: IF (fnd_msg_pub.count_msg > 0) THEN
566:
567: FOR l_counter IN 1..fnd_msg_pub.count_msg LOOP
568: fnd_msg_pub.get(p_msg_index => l_counter
569: ,p_encoded => 'F'
570: ,p_data => l_data
571: ,p_msg_index_out => l_msg_index_out);
572: fnd_file.put_line(fnd_file.log, l_data);
579: errbuf := sqlerrm;
580:
581: -- print the error message in the output file
582:
583: IF (fnd_msg_pub.count_msg > 0) THEN
584:
585: FOR l_counter IN 1..fnd_msg_pub.count_msg LOOP
586: fnd_msg_pub.get(p_msg_index => l_counter
587: ,p_encoded => 'F'
581: -- print the error message in the output file
582:
583: IF (fnd_msg_pub.count_msg > 0) THEN
584:
585: FOR l_counter IN 1..fnd_msg_pub.count_msg LOOP
586: fnd_msg_pub.get(p_msg_index => l_counter
587: ,p_encoded => 'F'
588: ,p_data => l_data
589: ,p_msg_index_out => l_msg_index_out);
582:
583: IF (fnd_msg_pub.count_msg > 0) THEN
584:
585: FOR l_counter IN 1..fnd_msg_pub.count_msg LOOP
586: fnd_msg_pub.get(p_msg_index => l_counter
587: ,p_encoded => 'F'
588: ,p_data => l_data
589: ,p_msg_index_out => l_msg_index_out);
590: fnd_file.put_line(fnd_file.log, l_data);
682: ROLLBACK TO sp_adv_mon;
683: x_return_status := Fnd_Api.G_RET_STS_ERROR;
684: x_msg_count := l_msg_count ;
685: x_msg_data := l_msg_data ;
686: Fnd_Msg_Pub.count_and_get(
687: p_count => x_msg_count
688: ,p_data => x_msg_data);
689: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
690: ROLLBACK TO sp_adv_mon;
690: ROLLBACK TO sp_adv_mon;
691: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
692: x_msg_count := l_msg_count ;
693: x_msg_data := l_msg_data ;
694: Fnd_Msg_Pub.count_and_get(
695: p_count => x_msg_count
696: ,p_data => x_msg_data);
697: WHEN OTHERS THEN
698: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
695: p_count => x_msg_count
696: ,p_data => x_msg_data);
697: WHEN OTHERS THEN
698: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
699: Fnd_Msg_Pub.ADD_EXC_MSG (
700: p_pkg_name => G_PKG_NAME,
701: p_procedure_name => l_api_name);
702: Fnd_Msg_Pub.Count_and_get (
703: p_encoded => Okc_Api.G_FALSE,
698: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
699: Fnd_Msg_Pub.ADD_EXC_MSG (
700: p_pkg_name => G_PKG_NAME,
701: p_procedure_name => l_api_name);
702: Fnd_Msg_Pub.Count_and_get (
703: p_encoded => Okc_Api.G_FALSE,
704: p_count => x_msg_count,
705: p_data => x_msg_data);
706: