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 58: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

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

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

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

Line 88: IF NOT FND_API.Compatible_API_Call (

84: -- Standard Start of API savepoint
85: SAVEPOINT period_status_grp;
86:
87: -- Standard call to check for call compatibility.
88: IF NOT FND_API.Compatible_API_Call (
89: p_current_version_number => l_api_version,
90: p_caller_version_number => p_api_version,
91: p_api_name => l_api_name,
92: p_pkg_name => g_pkg_name) THEN

Line 94: RAISE fnd_api.g_exc_unexpected_error;

90: p_caller_version_number => p_api_version,
91: p_api_name => l_api_name,
92: p_pkg_name => g_pkg_name) THEN
93:
94: RAISE fnd_api.g_exc_unexpected_error;
95:
96: END IF;
97:
98: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 99: IF FND_API.to_Boolean( p_init_msg_list ) THEN

95:
96: END IF;
97:
98: -- Initialize message list if p_init_msg_list is set to TRUE.
99: IF FND_API.to_Boolean( p_init_msg_list ) THEN
100: fnd_msg_pub.initialize;
101: END IF;
102:
103: -- Initialize API return status to success

Line 104: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 115: WHEN fnd_api.g_exc_error THEN

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

Line 117: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 119: p_encoded => fnd_api.g_false,

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

Line 123: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 127: p_encoded => fnd_api.g_false,

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

Line 133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 135: p_encoded => fnd_api.g_false,

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

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

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

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

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

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

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

Line 351: IF NOT FND_API.Compatible_API_Call (

347: -- Standard Start of API savepoint
348: SAVEPOINT populate_cst_tables_grp;
349:
350: -- Standard call to check for call compatibility.
351: IF NOT FND_API.Compatible_API_Call (
352: p_current_version_number => l_api_version,
353: p_caller_version_number => p_api_version,
354: p_api_name => l_api_name,
355: p_pkg_name => g_pkg_name) THEN

Line 357: RAISE fnd_api.g_exc_unexpected_error;

353: p_caller_version_number => p_api_version,
354: p_api_name => l_api_name,
355: p_pkg_name => g_pkg_name) THEN
356:
357: RAISE fnd_api.g_exc_unexpected_error;
358:
359: END IF;
360:
361: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 362: IF FND_API.to_Boolean( p_init_msg_list ) THEN

358:
359: END IF;
360:
361: -- Initialize message list if p_init_msg_list is set to TRUE.
362: IF FND_API.to_Boolean( p_init_msg_list ) THEN
363: fnd_msg_pub.initialize;
364: END IF;
365:
366: -- Initialize API return status to success

Line 367: x_return_status := FND_API.G_RET_STS_SUCCESS;

363: fnd_msg_pub.initialize;
364: END IF;
365:
366: -- Initialize API return status to success
367: x_return_status := FND_API.G_RET_STS_SUCCESS;
368:
369: -- Populate WHO column variables
370: l_request_id := fnd_global.conc_request_id;
371: l_user_id := fnd_global.user_id;

Line 810: WHEN fnd_api.g_exc_error THEN

806: arp_debug.debug( 'ar_match_rev_cogs_grp.populate_cst_tables()- ');
807: END IF;
808:
809: EXCEPTION
810: WHEN fnd_api.g_exc_error THEN
811: ROLLBACK TO populate_cst_tables_grp;
812: x_return_status := FND_API.G_RET_STS_ERROR ;
813: fnd_msg_pub.count_and_get (
814: p_encoded => fnd_api.g_false,

Line 812: x_return_status := FND_API.G_RET_STS_ERROR ;

808:
809: EXCEPTION
810: WHEN fnd_api.g_exc_error THEN
811: ROLLBACK TO populate_cst_tables_grp;
812: x_return_status := FND_API.G_RET_STS_ERROR ;
813: fnd_msg_pub.count_and_get (
814: p_encoded => fnd_api.g_false,
815: p_count => x_msg_count,
816: p_data => x_msg_data);

Line 814: p_encoded => fnd_api.g_false,

810: WHEN fnd_api.g_exc_error THEN
811: ROLLBACK TO populate_cst_tables_grp;
812: x_return_status := FND_API.G_RET_STS_ERROR ;
813: fnd_msg_pub.count_and_get (
814: p_encoded => fnd_api.g_false,
815: p_count => x_msg_count,
816: p_data => x_msg_data);
817:
818: WHEN fnd_api.g_exc_unexpected_error THEN

Line 818: WHEN fnd_api.g_exc_unexpected_error THEN

814: p_encoded => fnd_api.g_false,
815: p_count => x_msg_count,
816: p_data => x_msg_data);
817:
818: WHEN fnd_api.g_exc_unexpected_error THEN
819: ROLLBACK TO populate_cst_tables_grp;
820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
821: fnd_msg_pub.count_and_get (
822: p_encoded => fnd_api.g_false,

Line 820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

816: p_data => x_msg_data);
817:
818: WHEN fnd_api.g_exc_unexpected_error THEN
819: ROLLBACK TO populate_cst_tables_grp;
820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
821: fnd_msg_pub.count_and_get (
822: p_encoded => fnd_api.g_false,
823: p_count => x_msg_count,
824: p_data => x_msg_data);

Line 822: p_encoded => fnd_api.g_false,

818: WHEN fnd_api.g_exc_unexpected_error THEN
819: ROLLBACK TO populate_cst_tables_grp;
820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
821: fnd_msg_pub.count_and_get (
822: p_encoded => fnd_api.g_false,
823: p_count => x_msg_count,
824: p_data => x_msg_data);
825:
826: WHEN OTHERS THEN

Line 829: x_return_status := FND_API.G_RET_STS_ERROR ;

825:
826: WHEN OTHERS THEN
827: IF (SQLCODE = -20001) THEN
828: ROLLBACK TO populate_cst_tables_grp;
829: x_return_status := FND_API.G_RET_STS_ERROR ;
830: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
831: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ar_match_rev_cogs_grp.populate_cst_tables : '||SQLERRM);
832: FND_MSG_PUB.Add;
833:

Line 835: p_encoded => fnd_api.g_false,

831: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ar_match_rev_cogs_grp.populate_cst_tables : '||SQLERRM);
832: FND_MSG_PUB.Add;
833:
834: fnd_msg_pub.count_and_get (
835: p_encoded => fnd_api.g_false,
836: p_count => x_msg_count,
837: p_data => x_msg_data);
838: RETURN;
839: ELSE

Line 840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

836: p_count => x_msg_count,
837: p_data => x_msg_data);
838: RETURN;
839: ELSE
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
841: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
842: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ar_match_rev_cogs_grp.populate_cst_tables : '||SQLERRM);
843: FND_MSG_PUB.Add;
844: END IF;

Line 853: p_encoded => fnd_api.g_false,

849: END IF;
850:
851: ROLLBACK TO populate_cst_tables_grp;
852: fnd_msg_pub.count_and_get (
853: p_encoded => fnd_api.g_false,
854: p_count => x_msg_count,
855: p_data => x_msg_data);
856:
857: END populate_cst_tables;