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

Line 24: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

20: --------------------------------------------------------------------------------
21:
22: PROCEDURE Create_resource_rollup
23: ( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
25: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
26: ,x_msg_count OUT NOCOPY NUMBER
27: ,x_msg_data OUT NOCOPY VARCHAR2
28: ,x_return_status OUT NOCOPY VARCHAR2

Line 25: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

21:
22: PROCEDURE Create_resource_rollup
23: ( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
25: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
26: ,x_msg_count OUT NOCOPY NUMBER
27: ,x_msg_data OUT NOCOPY VARCHAR2
28: ,x_return_status OUT NOCOPY VARCHAR2
29: ,p_project_id IN NUMBER

Line 55: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,

51:
52: -- Standard call to check for call compatibility.
53:
54:
55: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
56: p_api_version_number ,
57: l_api_name ,
58: G_PKG_NAME )
59: THEN

Line 61: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

57: l_api_name ,
58: G_PKG_NAME )
59: THEN
60:
61: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
62:
63: END IF;
64:
65:

Line 68: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

64:
65:
66: -- Initialize the message table if requested.
67:
68: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
69:
70: FND_MSG_PUB.initialize;
71:
72: END IF;

Line 76: x_return_status := FND_API.G_RET_STS_SUCCESS;

72: END IF;
73:
74: -- Set API return status to success
75:
76: x_return_status := FND_API.G_RET_STS_SUCCESS;
77:
78: -- CHECK FOR MANDATORY FIELDS
79:
80: IF P_PROJECT_ID IS NULL THEN

Line 95: x_return_status := FND_API.G_RET_STS_ERROR;

91: ,p_attribute3 => ''
92: ,p_attribute4 => ''
93: ,p_attribute5 => '');
94: END IF;
95: x_return_status := FND_API.G_RET_STS_ERROR;
96: RAISE FND_API.G_EXC_ERROR;
97: END IF;
98:
99: IF P_PLAN_VERSION_ID_TBL.COUNT = 0 THEN

Line 96: RAISE FND_API.G_EXC_ERROR;

92: ,p_attribute4 => ''
93: ,p_attribute5 => '');
94: END IF;
95: x_return_status := FND_API.G_RET_STS_ERROR;
96: RAISE FND_API.G_EXC_ERROR;
97: END IF;
98:
99: IF P_PLAN_VERSION_ID_TBL.COUNT = 0 THEN
100:

Line 114: x_return_status := FND_API.G_RET_STS_ERROR;

110: ,p_attribute3 => ''
111: ,p_attribute4 => ''
112: ,p_attribute5 => '');
113: END IF;
114: x_return_status := FND_API.G_RET_STS_ERROR;
115: RAISE FND_API.G_EXC_ERROR;
116: END IF;
117:
118: IF P_RBS_VERSION_ID_TBL.COUNT = 0 THEN

Line 115: RAISE FND_API.G_EXC_ERROR;

111: ,p_attribute4 => ''
112: ,p_attribute5 => '');
113: END IF;
114: x_return_status := FND_API.G_RET_STS_ERROR;
115: RAISE FND_API.G_EXC_ERROR;
116: END IF;
117:
118: IF P_RBS_VERSION_ID_TBL.COUNT = 0 THEN
119:

Line 133: x_return_status := FND_API.G_RET_STS_ERROR;

129: ,p_attribute3 => ''
130: ,p_attribute4 => ''
131: ,p_attribute5 => '');
132: END IF;
133: x_return_status := FND_API.G_RET_STS_ERROR;
134: RAISE FND_API.G_EXC_ERROR;
135: END IF;
136:
137: begin

Line 134: RAISE FND_API.G_EXC_ERROR;

130: ,p_attribute4 => ''
131: ,p_attribute5 => '');
132: END IF;
133: x_return_status := FND_API.G_RET_STS_ERROR;
134: RAISE FND_API.G_EXC_ERROR;
135: END IF;
136:
137: begin
138: SELECT distinct WBS_VERSION_ID

Line 145: x_return_status := FND_API.G_RET_STS_ERROR;

141: WHERE PROJECT_ID = p_project_id
142: AND PLAN_VERSION_ID = p_plan_version_id_tbl(1);
143: exception
144: when no_data_found then
145: x_return_status := FND_API.G_RET_STS_ERROR;
146: RAISE FND_API.G_EXC_ERROR;
147: when too_many_rows then
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: RAISE FND_API.G_EXC_ERROR;

Line 146: RAISE FND_API.G_EXC_ERROR;

142: AND PLAN_VERSION_ID = p_plan_version_id_tbl(1);
143: exception
144: when no_data_found then
145: x_return_status := FND_API.G_RET_STS_ERROR;
146: RAISE FND_API.G_EXC_ERROR;
147: when too_many_rows then
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: RAISE FND_API.G_EXC_ERROR;
150: end;

Line 148: x_return_status := FND_API.G_RET_STS_ERROR;

144: when no_data_found then
145: x_return_status := FND_API.G_RET_STS_ERROR;
146: RAISE FND_API.G_EXC_ERROR;
147: when too_many_rows then
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: RAISE FND_API.G_EXC_ERROR;
150: end;
151: Pji_Fm_Xbs_Accum_Maint.maintain_smart_slice (
152: p_rbs_version_id_tbl =>p_rbs_version_id_tbl,

Line 149: RAISE FND_API.G_EXC_ERROR;

145: x_return_status := FND_API.G_RET_STS_ERROR;
146: RAISE FND_API.G_EXC_ERROR;
147: when too_many_rows then
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: RAISE FND_API.G_EXC_ERROR;
150: end;
151: Pji_Fm_Xbs_Accum_Maint.maintain_smart_slice (
152: p_rbs_version_id_tbl =>p_rbs_version_id_tbl,
153: p_plan_version_id_tbl =>p_plan_version_id_tbl,

Line 166: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

162: x_msg_data =>x_msg_data,
163: x_return_status =>l_return_status);
164:
165:
166: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
168: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
169: RAISE FND_API.G_EXC_ERROR;
170: END IF;

Line 167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

163: x_return_status =>l_return_status);
164:
165:
166: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
168: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
169: RAISE FND_API.G_EXC_ERROR;
170: END IF;
171:

Line 168: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

164:
165:
166: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
168: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
169: RAISE FND_API.G_EXC_ERROR;
170: END IF;
171:
172: IF (FND_API.to_boolean( p_commit )) THEN

Line 169: RAISE FND_API.G_EXC_ERROR;

165:
166: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
168: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
169: RAISE FND_API.G_EXC_ERROR;
170: END IF;
171:
172: IF (FND_API.to_boolean( p_commit )) THEN
173: COMMIT ;

Line 172: IF (FND_API.to_boolean( p_commit )) THEN

168: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
169: RAISE FND_API.G_EXC_ERROR;
170: END IF;
171:
172: IF (FND_API.to_boolean( p_commit )) THEN
173: COMMIT ;
174: else
175: ROLLBACK TO Create_resource_pub;
176: END IF;

Line 180: WHEN FND_API.G_EXC_ERROR THEN

176: END IF;
177:
178:
179: EXCEPTION
180: WHEN FND_API.G_EXC_ERROR THEN
181: ROLLBACK TO create_resource_pub;
182: x_return_status := FND_API.G_RET_STS_ERROR;
183:
184: FND_MSG_PUB.Count_And_Get

Line 182: x_return_status := FND_API.G_RET_STS_ERROR;

178:
179: EXCEPTION
180: WHEN FND_API.G_EXC_ERROR THEN
181: ROLLBACK TO create_resource_pub;
182: x_return_status := FND_API.G_RET_STS_ERROR;
183:
184: FND_MSG_PUB.Count_And_Get
185: ( p_count => x_msg_count ,
186: p_data => x_msg_data );

Line 188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

184: FND_MSG_PUB.Count_And_Get
185: ( p_count => x_msg_count ,
186: p_data => x_msg_data );
187:
188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
189: ROLLBACK TO create_resource_pub;
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
191:
192: FND_MSG_PUB.Count_And_Get

Line 190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

186: p_data => x_msg_data );
187:
188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
189: ROLLBACK TO create_resource_pub;
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
191:
192: FND_MSG_PUB.Count_And_Get
193: ( p_count => x_msg_count ,
194: p_data => x_msg_data );

Line 198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

194: p_data => x_msg_data );
195:
196: WHEN OTHERS THEN
197: ROLLBACK TO create_resource_pub;
198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
199:
200: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
201: THEN
202: FND_MSG_PUB.add_exc_msg

Line 219: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

215:
216:
217: PROCEDURE Delete_resource_rollup
218: ( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
219: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
220: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
221: ,x_msg_count OUT NOCOPY NUMBER
222: ,x_msg_data OUT NOCOPY VARCHAR2
223: ,x_return_status OUT NOCOPY VARCHAR2

Line 220: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

216:
217: PROCEDURE Delete_resource_rollup
218: ( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
219: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
220: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
221: ,x_msg_count OUT NOCOPY NUMBER
222: ,x_msg_data OUT NOCOPY VARCHAR2
223: ,x_return_status OUT NOCOPY VARCHAR2
224: ,p_project_id IN NUMBER

Line 247: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,

243:
244: -- Standard call to check for call compatibility.
245:
246:
247: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
248: p_api_version_number ,
249: l_api_name ,
250: G_PKG_NAME )
251: THEN

Line 253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

249: l_api_name ,
250: G_PKG_NAME )
251: THEN
252:
253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
254:
255: END IF;
256:
257:

Line 260: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

256:
257:
258: -- Initialize the message table if requested.
259:
260: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
261:
262: FND_MSG_PUB.initialize;
263:
264: END IF;

Line 268: x_return_status := FND_API.G_RET_STS_SUCCESS;

264: END IF;
265:
266: -- Set API return status to success
267:
268: x_return_status := FND_API.G_RET_STS_SUCCESS;
269:
270: -- CHECK FOR MANDATORY FIELDS
271:
272: IF P_PROJECT_ID IS NULL THEN

Line 287: x_return_status := FND_API.G_RET_STS_ERROR;

283: ,p_attribute3 => ''
284: ,p_attribute4 => ''
285: ,p_attribute5 => '');
286: END IF;
287: x_return_status := FND_API.G_RET_STS_ERROR;
288: RAISE FND_API.G_EXC_ERROR;
289: END IF;
290:
291: IF p_plan_version_id_tbl.COUNT=0 and p_rbs_version_id_tbl.COUNT=0 then

Line 288: RAISE FND_API.G_EXC_ERROR;

284: ,p_attribute4 => ''
285: ,p_attribute5 => '');
286: END IF;
287: x_return_status := FND_API.G_RET_STS_ERROR;
288: RAISE FND_API.G_EXC_ERROR;
289: END IF;
290:
291: IF p_plan_version_id_tbl.COUNT=0 and p_rbs_version_id_tbl.COUNT=0 then
292: DELETE FROM pji_rollup_level_status

Line 374: IF (FND_API.to_boolean( p_commit )) THEN

370: NULL;
371: END IF;
372:
373:
374: IF (FND_API.to_boolean( p_commit )) THEN
375: COMMIT ;
376: else
377: ROLLBACK to Delete_resource_pub;
378: END IF;

Line 381: WHEN FND_API.G_EXC_ERROR THEN

377: ROLLBACK to Delete_resource_pub;
378: END IF;
379:
380: EXCEPTION
381: WHEN FND_API.G_EXC_ERROR THEN
382: ROLLBACK TO delete_resource_pub;
383: x_return_status := FND_API.G_RET_STS_ERROR;
384:
385: FND_MSG_PUB.Count_And_Get

Line 383: x_return_status := FND_API.G_RET_STS_ERROR;

379:
380: EXCEPTION
381: WHEN FND_API.G_EXC_ERROR THEN
382: ROLLBACK TO delete_resource_pub;
383: x_return_status := FND_API.G_RET_STS_ERROR;
384:
385: FND_MSG_PUB.Count_And_Get
386: ( p_count => x_msg_count ,
387: p_data => x_msg_data );

Line 389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

385: FND_MSG_PUB.Count_And_Get
386: ( p_count => x_msg_count ,
387: p_data => x_msg_data );
388:
389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
390: ROLLBACK TO delete_resource_pub;
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392:
393: FND_MSG_PUB.Count_And_Get

Line 391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

387: p_data => x_msg_data );
388:
389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
390: ROLLBACK TO delete_resource_pub;
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392:
393: FND_MSG_PUB.Count_And_Get
394: ( p_count => x_msg_count ,
395: p_data => x_msg_data );

Line 399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

395: p_data => x_msg_data );
396:
397: WHEN OTHERS THEN
398: ROLLBACK TO delete_resource_pub;
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400:
401: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
402: THEN
403: FND_MSG_PUB.add_exc_msg