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

Line 55: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

51:
52:
53: PROCEDURE period_status (
54: p_api_version IN NUMBER,
55: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
56: p_commit IN VARCHAR2 := fnd_api.g_false,
57: p_eff_period_num IN NUMBER,
58: p_sob_id IN NUMBER,
59: x_status OUT NOCOPY VARCHAR2,

Line 56: p_commit IN VARCHAR2 := fnd_api.g_false,

52:
53: PROCEDURE period_status (
54: p_api_version IN NUMBER,
55: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
56: p_commit IN VARCHAR2 := fnd_api.g_false,
57: p_eff_period_num IN NUMBER,
58: p_sob_id IN NUMBER,
59: x_status OUT NOCOPY VARCHAR2,
60: x_return_status OUT NOCOPY VARCHAR2,

Line 85: IF NOT FND_API.Compatible_API_Call (

81: -- Standard Start of API savepoint
82: SAVEPOINT period_status_grp;
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) THEN

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) THEN
90:
91: RAISE fnd_api.g_exc_unexpected_error;
92:
93: END IF;
94:
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:
93: END IF;
94:
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: -- Initialize API return status to success

Line 101: x_return_status := FND_API.G_RET_STS_SUCCESS;

97: fnd_msg_pub.initialize;
98: END IF;
99:
100: -- Initialize API return status to success
101: x_return_status := FND_API.G_RET_STS_SUCCESS;
102:
103: OPEN status;
104: FETCH status INTO x_status;
105: CLOSE status;

Line 112: WHEN fnd_api.g_exc_error THEN

108: arp_util.debug( 'ar_match_rev_cogs_grp.period_status()- ');
109: END IF;
110:
111: EXCEPTION
112: WHEN fnd_api.g_exc_error THEN
113: ROLLBACK TO period_status_grp;
114: x_return_status := FND_API.G_RET_STS_ERROR ;
115: fnd_msg_pub.count_and_get (
116: p_encoded => fnd_api.g_false,

Line 114: x_return_status := FND_API.G_RET_STS_ERROR ;

110:
111: EXCEPTION
112: WHEN fnd_api.g_exc_error THEN
113: ROLLBACK TO period_status_grp;
114: x_return_status := FND_API.G_RET_STS_ERROR ;
115: fnd_msg_pub.count_and_get (
116: p_encoded => fnd_api.g_false,
117: p_count => x_msg_count,
118: p_data => x_msg_data);

Line 116: p_encoded => fnd_api.g_false,

112: WHEN fnd_api.g_exc_error THEN
113: ROLLBACK TO period_status_grp;
114: x_return_status := FND_API.G_RET_STS_ERROR ;
115: fnd_msg_pub.count_and_get (
116: p_encoded => fnd_api.g_false,
117: p_count => x_msg_count,
118: p_data => x_msg_data);
119:
120: WHEN fnd_api.g_exc_unexpected_error THEN

Line 120: WHEN fnd_api.g_exc_unexpected_error THEN

116: p_encoded => fnd_api.g_false,
117: p_count => x_msg_count,
118: p_data => x_msg_data);
119:
120: WHEN fnd_api.g_exc_unexpected_error THEN
121: ROLLBACK TO period_status_grp;
122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
123: fnd_msg_pub.count_and_get (
124: p_encoded => fnd_api.g_false,

Line 122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

118: p_data => x_msg_data);
119:
120: WHEN fnd_api.g_exc_unexpected_error THEN
121: ROLLBACK TO period_status_grp;
122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
123: fnd_msg_pub.count_and_get (
124: p_encoded => fnd_api.g_false,
125: p_count => x_msg_count,
126: p_data => x_msg_data);

Line 124: p_encoded => fnd_api.g_false,

120: WHEN fnd_api.g_exc_unexpected_error THEN
121: ROLLBACK TO period_status_grp;
122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
123: fnd_msg_pub.count_and_get (
124: p_encoded => fnd_api.g_false,
125: p_count => x_msg_count,
126: p_data => x_msg_data);
127:
128: WHEN OTHERS THEN

Line 130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

126: p_data => x_msg_data);
127:
128: WHEN OTHERS THEN
129: ROLLBACK TO period_status_grp;
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
131: fnd_msg_pub.count_and_get (
132: p_encoded => fnd_api.g_false,
133: p_count => x_msg_count,
134: p_data => x_msg_data);

Line 132: p_encoded => fnd_api.g_false,

128: WHEN OTHERS THEN
129: ROLLBACK TO period_status_grp;
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
131: fnd_msg_pub.count_and_get (
132: p_encoded => fnd_api.g_false,
133: p_count => x_msg_count,
134: p_data => x_msg_data);
135:
136: END period_status;

Line 144: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;

140: p_period_name VARCHAR2)
141: RETURN VARCHAR2 IS
142:
143: l_api_version NUMBER := 1.0;
144: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
145: l_eff_period_num NUMBER;
146: l_set_of_books_id NUMBER;
147: l_status VARCHAR2(30);
148: l_return_status VARCHAR2(30);

Line 196: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

192:
193:
194: PROCEDURE populate_cst_tables (
195: p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
197: p_commit IN VARCHAR2 := fnd_api.g_false,
198: p_from_gl_date DATE,
199: p_to_gl_date DATE,
200: p_ledger_id IN NUMBER DEFAULT NULL,

Line 197: p_commit IN VARCHAR2 := fnd_api.g_false,

193:
194: PROCEDURE populate_cst_tables (
195: p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
197: p_commit IN VARCHAR2 := fnd_api.g_false,
198: p_from_gl_date DATE,
199: p_to_gl_date DATE,
200: p_ledger_id IN NUMBER DEFAULT NULL,
201: x_status OUT NOCOPY VARCHAR2,

Line 277: IF NOT FND_API.Compatible_API_Call (

273: -- Standard Start of API savepoint
274: SAVEPOINT populate_cst_tables_grp;
275:
276: -- Standard call to check for call compatibility.
277: IF NOT FND_API.Compatible_API_Call (
278: p_current_version_number => l_api_version,
279: p_caller_version_number => p_api_version,
280: p_api_name => l_api_name,
281: p_pkg_name => g_pkg_name) THEN

Line 283: RAISE fnd_api.g_exc_unexpected_error;

279: p_caller_version_number => p_api_version,
280: p_api_name => l_api_name,
281: p_pkg_name => g_pkg_name) THEN
282:
283: RAISE fnd_api.g_exc_unexpected_error;
284:
285: END IF;
286:
287: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 288: IF FND_API.to_Boolean( p_init_msg_list ) THEN

284:
285: END IF;
286:
287: -- Initialize message list if p_init_msg_list is set to TRUE.
288: IF FND_API.to_Boolean( p_init_msg_list ) THEN
289: fnd_msg_pub.initialize;
290: END IF;
291:
292: -- Initialize API return status to success

Line 293: x_return_status := FND_API.G_RET_STS_SUCCESS;

289: fnd_msg_pub.initialize;
290: END IF;
291:
292: -- Initialize API return status to success
293: x_return_status := FND_API.G_RET_STS_SUCCESS;
294:
295: -- Populate WHO column variables
296: l_request_id := fnd_global.conc_request_id;
297: l_user_id := fnd_global.user_id;

Line 520: WHEN fnd_api.g_exc_error THEN

516: arp_util.debug( 'ar_match_rev_cogs_grp.populate_cst_tables()- ');
517: END IF;
518:
519: EXCEPTION
520: WHEN fnd_api.g_exc_error THEN
521: ROLLBACK TO populate_cst_tables_grp;
522: x_return_status := FND_API.G_RET_STS_ERROR ;
523: fnd_msg_pub.count_and_get (
524: p_encoded => fnd_api.g_false,

Line 522: x_return_status := FND_API.G_RET_STS_ERROR ;

518:
519: EXCEPTION
520: WHEN fnd_api.g_exc_error THEN
521: ROLLBACK TO populate_cst_tables_grp;
522: x_return_status := FND_API.G_RET_STS_ERROR ;
523: fnd_msg_pub.count_and_get (
524: p_encoded => fnd_api.g_false,
525: p_count => x_msg_count,
526: p_data => x_msg_data);

Line 524: p_encoded => fnd_api.g_false,

520: WHEN fnd_api.g_exc_error THEN
521: ROLLBACK TO populate_cst_tables_grp;
522: x_return_status := FND_API.G_RET_STS_ERROR ;
523: fnd_msg_pub.count_and_get (
524: p_encoded => fnd_api.g_false,
525: p_count => x_msg_count,
526: p_data => x_msg_data);
527:
528: WHEN fnd_api.g_exc_unexpected_error THEN

Line 528: WHEN fnd_api.g_exc_unexpected_error THEN

524: p_encoded => fnd_api.g_false,
525: p_count => x_msg_count,
526: p_data => x_msg_data);
527:
528: WHEN fnd_api.g_exc_unexpected_error THEN
529: ROLLBACK TO populate_cst_tables_grp;
530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
531: fnd_msg_pub.count_and_get (
532: p_encoded => fnd_api.g_false,

Line 530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

526: p_data => x_msg_data);
527:
528: WHEN fnd_api.g_exc_unexpected_error THEN
529: ROLLBACK TO populate_cst_tables_grp;
530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
531: fnd_msg_pub.count_and_get (
532: p_encoded => fnd_api.g_false,
533: p_count => x_msg_count,
534: p_data => x_msg_data);

Line 532: p_encoded => fnd_api.g_false,

528: WHEN fnd_api.g_exc_unexpected_error THEN
529: ROLLBACK TO populate_cst_tables_grp;
530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
531: fnd_msg_pub.count_and_get (
532: p_encoded => fnd_api.g_false,
533: p_count => x_msg_count,
534: p_data => x_msg_data);
535:
536: WHEN OTHERS THEN

Line 539: x_return_status := FND_API.G_RET_STS_ERROR ;

535:
536: WHEN OTHERS THEN
537: IF (SQLCODE = -20001) THEN
538: ROLLBACK TO populate_cst_tables_grp;
539: x_return_status := FND_API.G_RET_STS_ERROR ;
540: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
541: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ar_match_rev_cogs_grp.populate_cst_tables : '||SQLERRM);
542: FND_MSG_PUB.Add;
543:

Line 545: p_encoded => fnd_api.g_false,

541: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ar_match_rev_cogs_grp.populate_cst_tables : '||SQLERRM);
542: FND_MSG_PUB.Add;
543:
544: fnd_msg_pub.count_and_get (
545: p_encoded => fnd_api.g_false,
546: p_count => x_msg_count,
547: p_data => x_msg_data);
548: RETURN;
549: ELSE

Line 550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

546: p_count => x_msg_count,
547: p_data => x_msg_data);
548: RETURN;
549: ELSE
550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
551: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
552: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ar_match_rev_cogs_grp.populate_cst_tables : '||SQLERRM);
553: FND_MSG_PUB.Add;
554: END IF;

Line 563: p_encoded => fnd_api.g_false,

559: END IF;
560:
561: ROLLBACK TO populate_cst_tables_grp;
562: fnd_msg_pub.count_and_get (
563: p_encoded => fnd_api.g_false,
564: p_count => x_msg_count,
565: p_data => x_msg_data);
566:
567: END populate_cst_tables;