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.OZF_CLAIM_AGING_PVT dependencies on FND_API

Line 18: x_return_status := FND_API.g_ret_sts_success;

14: x_return_status OUT NOCOPY VARCHAR2
15: )
16: IS
17: BEGIN
18: x_return_status := FND_API.g_ret_sts_success;
19: -- insert data
20: INSERT INTO ozf_aging_bucket_dates (
21: aging_bucket_id,
22: aging_bucket_line_id,

Line 38: x_return_status := FND_API.g_ret_sts_error;

34: );
35:
36: EXCEPTION
37: WHEN OTHERS THEN
38: x_return_status := FND_API.g_ret_sts_error;
39: END;
40:
41: --------------------------------------------------------------------------------
42: PROCEDURE populate_aging_dates(

Line 60: x_return_status := FND_API.g_ret_sts_success;

56: l_bucket_date DATE;
57: l_bucket_date_range NUMBER;
58:
59: BEGIN
60: x_return_status := FND_API.g_ret_sts_success;
61:
62: /*
63: FND_PROFILE.get( 'bucket_date_range'
64: , l_high_val

Line 101: IF l_return_status = FND_API.g_ret_sts_error THEN

97: p_bucket_date => l_bucket_date,
98: p_condition_type => l_type,
99: x_return_status => l_return_status
100: );
101: IF l_return_status = FND_API.g_ret_sts_error THEN
102: RAISE FND_API.g_exc_error;
103: END IF;
104: END LOOP;
105: ELSE

Line 102: RAISE FND_API.g_exc_error;

98: p_condition_type => l_type,
99: x_return_status => l_return_status
100: );
101: IF l_return_status = FND_API.g_ret_sts_error THEN
102: RAISE FND_API.g_exc_error;
103: END IF;
104: END LOOP;
105: ELSE
106: IF p_seq_type = 'L' THEN

Line 126: IF l_return_status = FND_API.g_ret_sts_error THEN

122: p_bucket_date => l_bucket_date,
123: p_condition_type => l_type,
124: x_return_status => l_return_status
125: );
126: IF l_return_status = FND_API.g_ret_sts_error THEN
127: RAISE FND_API.g_exc_error;
128: END IF;
129: ELSIF p_seq_type = 'F' THEN
130: --l_type := 'LT';

Line 127: RAISE FND_API.g_exc_error;

123: p_condition_type => l_type,
124: x_return_status => l_return_status
125: );
126: IF l_return_status = FND_API.g_ret_sts_error THEN
127: RAISE FND_API.g_exc_error;
128: END IF;
129: ELSIF p_seq_type = 'F' THEN
130: --l_type := 'LT';
131: IF p_bucket_type = 'PAST' THEN

Line 152: IF l_return_status = FND_API.g_ret_sts_error THEN

148: p_bucket_date => l_bucket_date,
149: p_condition_type => l_type,
150: x_return_status => l_return_status
151: );
152: IF l_return_status = FND_API.g_ret_sts_error THEN
153: RAISE FND_API.g_exc_error;
154: END IF;
155: END IF;
156: END IF;

Line 153: RAISE FND_API.g_exc_error;

149: p_condition_type => l_type,
150: x_return_status => l_return_status
151: );
152: IF l_return_status = FND_API.g_ret_sts_error THEN
153: RAISE FND_API.g_exc_error;
154: END IF;
155: END IF;
156: END IF;
157:

Line 159: WHEN FND_API.g_exc_error THEN

155: END IF;
156: END IF;
157:
158: EXCEPTION
159: WHEN FND_API.g_exc_error THEN
160: x_return_status := FND_API.g_ret_sts_error;
161:
162: WHEN FND_API.g_exc_unexpected_error THEN
163: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 160: x_return_status := FND_API.g_ret_sts_error;

156: END IF;
157:
158: EXCEPTION
159: WHEN FND_API.g_exc_error THEN
160: x_return_status := FND_API.g_ret_sts_error;
161:
162: WHEN FND_API.g_exc_unexpected_error THEN
163: x_return_status := FND_API.g_ret_sts_unexp_error ;
164:

Line 162: WHEN FND_API.g_exc_unexpected_error THEN

158: EXCEPTION
159: WHEN FND_API.g_exc_error THEN
160: x_return_status := FND_API.g_ret_sts_error;
161:
162: WHEN FND_API.g_exc_unexpected_error THEN
163: x_return_status := FND_API.g_ret_sts_unexp_error ;
164:
165: WHEN OTHERS THEN
166: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 163: x_return_status := FND_API.g_ret_sts_unexp_error ;

159: WHEN FND_API.g_exc_error THEN
160: x_return_status := FND_API.g_ret_sts_error;
161:
162: WHEN FND_API.g_exc_unexpected_error THEN
163: x_return_status := FND_API.g_ret_sts_unexp_error ;
164:
165: WHEN OTHERS THEN
166: x_return_status := FND_API.g_ret_sts_unexp_error;
167: END;

Line 166: x_return_status := FND_API.g_ret_sts_unexp_error;

162: WHEN FND_API.g_exc_unexpected_error THEN
163: x_return_status := FND_API.g_ret_sts_unexp_error ;
164:
165: WHEN OTHERS THEN
166: x_return_status := FND_API.g_ret_sts_unexp_error;
167: END;
168:
169: --------------------------------------------------------------------------------
170: PROCEDURE populate_aging_summary(

Line 372: x_return_status := FND_API.g_ret_sts_success;

368: l_aging_summary_rec aging_summary_csr%ROWTYPE;
369: l_aging_col_total_rec aging_col_total_csr%ROWTYPE;
370:
371: BEGIN
372: x_return_status := FND_API.g_ret_sts_success;
373:
374: OPEN aging_summary_csr;
375: LOOP
376: FETCH aging_summary_csr INTO l_aging_summary_rec;

Line 425: x_return_status := FND_API.g_ret_sts_error;

421:
422:
423: EXCEPTION
424: WHEN OTHERS THEN
425: x_return_status := FND_API.g_ret_sts_error;
426: END;
427: --------------------------------------------------------------------------------
428: -- API name : Populate_Aging
429: -- Type : Private

Line 521: RAISE FND_API.g_exc_error;

517: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
518: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_AGING_NO_BUCKET');
519: FND_MSG_PUB.add;
520: END IF;
521: RAISE FND_API.g_exc_error;
522: END IF;
523:
524: -- Truncate existing data
525: /* TRUNCATE TABLE ozf.ozf_aging_summary_all; */

Line 581: IF l_return_status = FND_API.g_ret_sts_error THEN

577: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line#'||i||' -- days_start ::' || l_bucket_lines_tbl(i).days_start);
578: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line#'||i||' -- days_to ::' || l_bucket_lines_tbl(i).days_to);
579: FND_FILE.PUT_LINE(FND_FILE.LOG, 'return status#'||i||' ::' || l_return_status);
580:
581: IF l_return_status = FND_API.g_ret_sts_error THEN
582: -- raise error and log message
583: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
584: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_AGING_SUMMARY_ERR');
585: FND_MSG_PUB.add;

Line 587: RAISE FND_API.g_exc_error;

583: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
584: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_AGING_SUMMARY_ERR');
585: FND_MSG_PUB.add;
586: END IF;
587: RAISE FND_API.g_exc_error;
588: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
589: RAISE FND_API.g_exc_unexpected_error;
590: END IF;
591: END LOOP;

Line 588: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

584: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_AGING_SUMMARY_ERR');
585: FND_MSG_PUB.add;
586: END IF;
587: RAISE FND_API.g_exc_error;
588: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
589: RAISE FND_API.g_exc_unexpected_error;
590: END IF;
591: END LOOP;
592:

Line 589: RAISE FND_API.g_exc_unexpected_error;

585: FND_MSG_PUB.add;
586: END IF;
587: RAISE FND_API.g_exc_error;
588: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
589: RAISE FND_API.g_exc_unexpected_error;
590: END IF;
591: END LOOP;
592:
593: -- populate table ozf_aging_summary

Line 600: IF l_return_status <> FND_API.g_ret_sts_success THEN

596: );
597: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
598: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total number of Bucket lines selected: ' || to_char(l_bucket_lines_tbl.count));
599:
600: IF l_return_status <> FND_API.g_ret_sts_success THEN
601: -- raise error and log message
602: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
603: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_AGING_POPULATE_ERR');
604: FND_MSG_PUB.add;

Line 606: RAISE FND_API.g_exc_error;

602: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
603: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_AGING_POPULATE_ERR');
604: FND_MSG_PUB.add;
605: END IF;
606: RAISE FND_API.g_exc_error;
607: END IF;
608:
609: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );
610: FND_FILE.PUT_LINE(FND_FILE.LOG, '== END populating aging : time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));

Line 618: WHEN FND_API.g_exc_error THEN

614: IF g_debug THEN
615: OZF_Utility_PVT.debug_message('== END populating aging : time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
616: END IF;
617: EXCEPTION
618: WHEN FND_API.g_exc_error THEN
619: ROLLBACK TO Aging_Summary;
620: /*
621: FND_MSG_PUB.count_and_get (
622: p_encoded => FND_API.g_false

Line 622: p_encoded => FND_API.g_false

618: WHEN FND_API.g_exc_error THEN
619: ROLLBACK TO Aging_Summary;
620: /*
621: FND_MSG_PUB.count_and_get (
622: p_encoded => FND_API.g_false
623: ,p_count => l_msg_count
624: ,p_data => l_msg_data
625: );
626: */

Line 628: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_error');

624: ,p_data => l_msg_data
625: );
626: */
627: OZF_UTILITY_PVT.write_conc_log;
628: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_error');
629: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');
630: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
631: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
632:

Line 629: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');

625: );
626: */
627: OZF_UTILITY_PVT.write_conc_log;
628: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_error');
629: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');
630: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
631: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
632:
633: ERRBUF := l_msg_data;

Line 635: WHEN FND_API.g_exc_unexpected_error THEN

631: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
632:
633: ERRBUF := l_msg_data;
634: RETCODE := 2;
635: WHEN FND_API.g_exc_unexpected_error THEN
636: ROLLBACK TO Aging_Summary;
637: /*
638: FND_MSG_PUB.count_and_get (
639: p_encoded => FND_API.g_false

Line 639: p_encoded => FND_API.g_false

635: WHEN FND_API.g_exc_unexpected_error THEN
636: ROLLBACK TO Aging_Summary;
637: /*
638: FND_MSG_PUB.count_and_get (
639: p_encoded => FND_API.g_false
640: ,p_count => l_msg_count
641: ,p_data => l_msg_data
642: );
643: */

Line 645: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_unexpected_error');

641: ,p_data => l_msg_data
642: );
643: */
644: OZF_UTILITY_PVT.write_conc_log;
645: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_unexpected_error');
646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');
647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
649: ERRBUF := l_msg_data;

Line 646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');

642: );
643: */
644: OZF_UTILITY_PVT.write_conc_log;
645: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_unexpected_error');
646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');
647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
649: ERRBUF := l_msg_data;
650: RETCODE := 2;