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

Line 41: x_return_status := FND_API.G_RET_STS_SUCCESS;

37: l_loading_status VARCHAR2(80);
38:
39: BEGIN
40: -- Initialize API return status to success
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42: x_loading_status := p_loading_status ;
43: --+
44: -- Check Miss And Null Parameters.
45: --+

Line 51: x_loading_status => l_loading_status)) = FND_API.G_TRUE ) THEN

47: IF ( (cn_api.chk_null_char_para
48: (p_char_para => p_quota_name,
49: p_obj_name => l_lkup_meaning,
50: p_loading_status => x_loading_status,
51: x_loading_status => l_loading_status)) = FND_API.G_TRUE ) THEN
52: RAISE FND_API.G_EXC_ERROR ;
53: END IF;
54: l_lkup_meaning := cn_api.get_lkup_meaning('','PM_OBJECT_TYPE');
55: IF ( (cn_api.chk_null_char_para

Line 52: RAISE FND_API.G_EXC_ERROR ;

48: (p_char_para => p_quota_name,
49: p_obj_name => l_lkup_meaning,
50: p_loading_status => x_loading_status,
51: x_loading_status => l_loading_status)) = FND_API.G_TRUE ) THEN
52: RAISE FND_API.G_EXC_ERROR ;
53: END IF;
54: l_lkup_meaning := cn_api.get_lkup_meaning('','PM_OBJECT_TYPE');
55: IF ( (cn_api.chk_null_char_para
56: (p_char_para => p_rev_class_name,

Line 59: x_loading_status => l_loading_status)) = FND_API.G_TRUE ) THEN

55: IF ( (cn_api.chk_null_char_para
56: (p_char_para => p_rev_class_name,
57: p_obj_name => l_lkup_meaning,
58: p_loading_status => x_loading_status,
59: x_loading_status => l_loading_status)) = FND_API.G_TRUE ) THEN
60: RAISE FND_API.G_EXC_ERROR ;
61: END IF;
62: -- Quota ID
63: x_quota_id := cn_chk_plan_element_pkg.get_quota_id(Ltrim(Rtrim(p_quota_name)),p_org_id);

Line 60: RAISE FND_API.G_EXC_ERROR ;

56: (p_char_para => p_rev_class_name,
57: p_obj_name => l_lkup_meaning,
58: p_loading_status => x_loading_status,
59: x_loading_status => l_loading_status)) = FND_API.G_TRUE ) THEN
60: RAISE FND_API.G_EXC_ERROR ;
61: END IF;
62: -- Quota ID
63: x_quota_id := cn_chk_plan_element_pkg.get_quota_id(Ltrim(Rtrim(p_quota_name)),p_org_id);
64: -- Get the Revenue Class ID

Line 75: RAISE FND_API.G_EXC_ERROR ;

71: THEN
72: FND_MESSAGE.SET_NAME('CN' , 'CN_PLN_NOT_EXIST');
73: FND_MESSAGE.SET_TOKEN('PE_NAME',p_quota_name);
74: FND_MSG_PUB.Add;
75: RAISE FND_API.G_EXC_ERROR ;
76: END IF;
77: END IF;
78: END IF;
79:

Line 88: RAISE FND_API.G_EXC_ERROR ;

84: FND_MESSAGE.SET_NAME ('CN' , 'CN_REV_CLASS_NOT_EXIST');
85: FND_MSG_PUB.Add;
86: END IF;
87: x_loading_status := 'CN_REV_CLASS_NOT_EXIST';
88: RAISE FND_API.G_EXC_ERROR ;
89: END IF ;
90: END IF;
91:
92:

Line 100: RAISE FND_API.G_EXC_ERROR ;

96: FND_MESSAGE.SET_NAME ('CN' , 'CN_QUOTA_RULE_NOT_EXIST');
97: FND_MSG_PUB.Add;
98: END IF;
99: x_loading_status := 'CN_QUOTA_RULE_NOT_EXIST';
100: RAISE FND_API.G_EXC_ERROR ;
101: END IF;
102: -- End Check Valid Quotas.
103:
104: END check_valid_quotas;

Line 135: x_return_status := FND_API.G_RET_STS_SUCCESS;

131: l_loading_status VARCHAR2(80);
132:
133: BEGIN
134: -- Initialize API return status to success
135: x_return_status := FND_API.G_RET_STS_SUCCESS;
136: x_loading_status := p_loading_status ;
137: --+
138: -- Check Miss And Null Parameters.
139: --+

Line 146: x_loading_status => l_loading_status)) = FND_API.G_TRUE)

142: IF((cn_api.chk_null_char_para
143: (p_char_para => p_trx_factor_rec.trx_type,
144: p_obj_name => l_lkup_meaning,
145: p_loading_status => x_loading_status,
146: x_loading_status => l_loading_status)) = FND_API.G_TRUE)
147: THEN
148: RAISE FND_API.G_EXC_ERROR ;
149: END IF;
150:

Line 148: RAISE FND_API.G_EXC_ERROR ;

144: p_obj_name => l_lkup_meaning,
145: p_loading_status => x_loading_status,
146: x_loading_status => l_loading_status)) = FND_API.G_TRUE)
147: THEN
148: RAISE FND_API.G_EXC_ERROR ;
149: END IF;
150:
151:
152: l_lkup_meaning := cn_api.get_lkup_meaning('REV_CLASS_NAME','PM_OBJECT_TYPE');

Line 157: x_loading_status => l_loading_status)) = FND_API.G_TRUE)

153: IF((cn_api.chk_null_char_para
154: (p_char_para => p_trx_factor_rec.rev_class_name,
155: p_obj_name => l_lkup_meaning,
156: p_loading_status => x_loading_status,
157: x_loading_status => l_loading_status)) = FND_API.G_TRUE)
158: THEN
159: RAISE FND_API.G_EXC_ERROR ;
160: END IF;
161:

Line 159: RAISE FND_API.G_EXC_ERROR ;

155: p_obj_name => l_lkup_meaning,
156: p_loading_status => x_loading_status,
157: x_loading_status => l_loading_status)) = FND_API.G_TRUE)
158: THEN
159: RAISE FND_API.G_EXC_ERROR ;
160: END IF;
161:
162: l_lkup_meaning := cn_api.get_lkup_meaning('EVENT_FACTOR','PM_OBJECT_TYPE');
163:

Line 168: x_loading_status => l_loading_status)) = FND_API.G_TRUE )

164: IF ( (cn_api.chk_null_num_para
165: (p_num_para => p_trx_factor_rec.event_factor,
166: p_obj_name => l_lkup_meaning,
167: p_loading_status => x_loading_status,
168: x_loading_status => l_loading_status)) = FND_API.G_TRUE )
169: THEN
170: RAISE FND_API.G_EXC_ERROR ;
171: END IF;
172:

Line 170: RAISE FND_API.G_EXC_ERROR ;

166: p_obj_name => l_lkup_meaning,
167: p_loading_status => x_loading_status,
168: x_loading_status => l_loading_status)) = FND_API.G_TRUE )
169: THEN
170: RAISE FND_API.G_EXC_ERROR ;
171: END IF;
172:
173: IF ltrim(Rtrim(p_rev_class_name)) <> Ltrim(Rtrim(p_trx_factor_rec.rev_class_name))
174: THEN

Line 181: RAISE FND_API.G_EXC_ERROR ;

177: FND_MESSAGE.SET_NAME ('CN' , 'CN_INCONSISTENT_REV_CLASS');
178: FND_MSG_PUB.Add;
179: END IF;
180: x_loading_status := 'CN_INCONSISTENT_REV_CLASS';
181: RAISE FND_API.G_EXC_ERROR ;
182: END IF;
183: -- +
184: -- Check Record Already exists.
185: --+

Line 205: p_encoded => FND_API.G_FALSE

201: FND_MSG_PUB.Count_And_Get
202: (
203: p_count => x_msg_count,
204: p_data => x_msg_data,
205: p_encoded => FND_API.G_FALSE
206: );
207: EXCEPTION
208: WHEN FND_API.G_EXC_ERROR THEN
209: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 208: WHEN FND_API.G_EXC_ERROR THEN

204: p_data => x_msg_data,
205: p_encoded => FND_API.G_FALSE
206: );
207: EXCEPTION
208: WHEN FND_API.G_EXC_ERROR THEN
209: x_return_status := FND_API.G_RET_STS_ERROR ;
210: FND_MSG_PUB.Count_And_Get
211: (
212: p_count => x_msg_count ,

Line 209: x_return_status := FND_API.G_RET_STS_ERROR ;

205: p_encoded => FND_API.G_FALSE
206: );
207: EXCEPTION
208: WHEN FND_API.G_EXC_ERROR THEN
209: x_return_status := FND_API.G_RET_STS_ERROR ;
210: FND_MSG_PUB.Count_And_Get
211: (
212: p_count => x_msg_count ,
213: p_data => x_msg_data ,

Line 214: p_encoded => FND_API.G_FALSE

210: FND_MSG_PUB.Count_And_Get
211: (
212: p_count => x_msg_count ,
213: p_data => x_msg_data ,
214: p_encoded => FND_API.G_FALSE
215: );
216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
218: x_loading_status := 'UNEXPECTED_ERR';

Line 216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

212: p_count => x_msg_count ,
213: p_data => x_msg_data ,
214: p_encoded => FND_API.G_FALSE
215: );
216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
218: x_loading_status := 'UNEXPECTED_ERR';
219: FND_MSG_PUB.Count_And_Get
220: (

Line 217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

213: p_data => x_msg_data ,
214: p_encoded => FND_API.G_FALSE
215: );
216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
218: x_loading_status := 'UNEXPECTED_ERR';
219: FND_MSG_PUB.Count_And_Get
220: (
221: p_count => x_msg_count ,

Line 223: p_encoded => FND_API.G_FALSE

219: FND_MSG_PUB.Count_And_Get
220: (
221: p_count => x_msg_count ,
222: p_data => x_msg_data ,
223: p_encoded => FND_API.G_FALSE
224: );
225: WHEN OTHERS THEN
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
227: x_loading_status := 'UNEXPECTED_ERR';

Line 226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

222: p_data => x_msg_data ,
223: p_encoded => FND_API.G_FALSE
224: );
225: WHEN OTHERS THEN
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
227: x_loading_status := 'UNEXPECTED_ERR';
228: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
229: THEN
230: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

Line 236: p_encoded=> FND_API.G_FALSE

232: FND_MSG_PUB.Count_And_Get
233: (
234: p_count => x_msg_count,
235: p_data => x_msg_data,
236: p_encoded=> FND_API.G_FALSE
237: );
238: END Validate_trx_factors;
239: --|/*---------------n--------------------------------------------------------+
240: --| Procedure Name : Update Trx Factors

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

242: --|----------------------------------------------------------------------- */
243: PROCEDURE update_trx_factors
244: (
245: p_api_version IN NUMBER,
246: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
247: p_commit IN VARCHAR2 := FND_API.G_FALSE,
248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
249: x_return_status OUT NOCOPY VARCHAR2,
250: x_msg_count OUT NOCOPY NUMBER,

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

243: PROCEDURE update_trx_factors
244: (
245: p_api_version IN NUMBER,
246: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
247: p_commit IN VARCHAR2 := FND_API.G_FALSE,
248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
249: x_return_status OUT NOCOPY VARCHAR2,
250: x_msg_count OUT NOCOPY NUMBER,
251: x_msg_data OUT NOCOPY VARCHAR2,

Line 248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

244: (
245: p_api_version IN NUMBER,
246: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
247: p_commit IN VARCHAR2 := FND_API.G_FALSE,
248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
249: x_return_status OUT NOCOPY VARCHAR2,
250: x_msg_count OUT NOCOPY NUMBER,
251: x_msg_data OUT NOCOPY VARCHAR2,
252: p_quota_name IN VARCHAR2,

Line 278: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

274: SAVEPOINT Update_trx_Factors ;
275: --+
276: -- Standard call to check for call compatibility.
277: --+
278: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
279: p_api_version ,
280: l_api_name ,
281: G_PKG_NAME )
282: THEN

Line 283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

279: p_api_version ,
280: l_api_name ,
281: G_PKG_NAME )
282: THEN
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284: END IF;
285: --+
286: -- Initialize message list if p_init_msg_list is set to TRUE.
287: -- +

Line 288: IF FND_API.to_Boolean( p_init_msg_list ) THEN

284: END IF;
285: --+
286: -- Initialize message list if p_init_msg_list is set to TRUE.
287: -- +
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 294: x_return_status := FND_API.G_RET_STS_SUCCESS;

290: END IF;
291: -- +
292: -- Initialize API return status to success
293: --+
294: x_return_status := FND_API.G_RET_STS_SUCCESS;
295: x_loading_status := 'CN_UPDATED';
296:
297: IF p_trx_factor_rec_tbl.COUNT > 0 THEN
298:

Line 315: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

311: );
312: x_loading_status := l_loading_status;
313: END IF;
314:
315: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
316: RAISE FND_API.G_EXC_ERROR ;
317: ELSIF ( x_return_status = FND_API.G_RET_STS_SUCCESS )
318: AND ( x_loading_status = 'CN_UPDATED' )
319: THEN

Line 316: RAISE FND_API.G_EXC_ERROR ;

312: x_loading_status := l_loading_status;
313: END IF;
314:
315: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
316: RAISE FND_API.G_EXC_ERROR ;
317: ELSIF ( x_return_status = FND_API.G_RET_STS_SUCCESS )
318: AND ( x_loading_status = 'CN_UPDATED' )
319: THEN
320: IF p_trx_factor_rec_tbl.COUNT > 0 THEN

Line 317: ELSIF ( x_return_status = FND_API.G_RET_STS_SUCCESS )

313: END IF;
314:
315: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
316: RAISE FND_API.G_EXC_ERROR ;
317: ELSIF ( x_return_status = FND_API.G_RET_STS_SUCCESS )
318: AND ( x_loading_status = 'CN_UPDATED' )
319: THEN
320: IF p_trx_factor_rec_tbl.COUNT > 0 THEN
321: FOR i IN p_trx_factor_rec_tbl.first .. p_trx_factor_rec_tbl.last LOOP

Line 344: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

340: p_loading_status => x_loading_status,
341: x_loading_status => l_loading_status );
342: x_loading_status := l_loading_status;
343:
344: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
345: RAISE FND_API.G_EXC_ERROR ;
346: ELSIF ( x_return_status = FND_API.G_RET_STS_SUCCESS )
347: AND ( x_loading_status = 'TRX_FACTORS_EXISTS' ) THEN
348: x_loading_status := 'CN_UPDATED' ;

Line 345: RAISE FND_API.G_EXC_ERROR ;

341: x_loading_status => l_loading_status );
342: x_loading_status := l_loading_status;
343:
344: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
345: RAISE FND_API.G_EXC_ERROR ;
346: ELSIF ( x_return_status = FND_API.G_RET_STS_SUCCESS )
347: AND ( x_loading_status = 'TRX_FACTORS_EXISTS' ) THEN
348: x_loading_status := 'CN_UPDATED' ;
349: UPDATE cn_trx_factors

Line 346: ELSIF ( x_return_status = FND_API.G_RET_STS_SUCCESS )

342: x_loading_status := l_loading_status;
343:
344: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
345: RAISE FND_API.G_EXC_ERROR ;
346: ELSIF ( x_return_status = FND_API.G_RET_STS_SUCCESS )
347: AND ( x_loading_status = 'TRX_FACTORS_EXISTS' ) THEN
348: x_loading_status := 'CN_UPDATED' ;
349: UPDATE cn_trx_factors
350: SET event_factor = p_trx_factor_rec_tbl(i).event_factor

Line 366: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

362: p_loading_status => x_loading_status,
363: x_loading_status => l_loading_status
364: );
365: x_loading_status := l_loading_status;
366: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
367: RAISE FND_API.G_EXC_ERROR ;
368: END IF;
369: END IF;
370: END IF;

Line 367: RAISE FND_API.G_EXC_ERROR ;

363: x_loading_status => l_loading_status
364: );
365: x_loading_status := l_loading_status;
366: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
367: RAISE FND_API.G_EXC_ERROR ;
368: END IF;
369: END IF;
370: END IF;
371: -- End of API body.

Line 374: IF FND_API.To_Boolean( p_commit ) THEN

370: END IF;
371: -- End of API body.
372: -- Standard check of p_commit.
373: --+
374: IF FND_API.To_Boolean( p_commit ) THEN
375: COMMIT WORK;
376: END IF;
377: --+
378: -- Standard call to get message count and if count is 1, get message info.

Line 384: p_encoded => FND_API.G_FALSE

380: FND_MSG_PUB.Count_And_Get
381: (
382: p_count => x_msg_count ,
383: p_data => x_msg_data ,
384: p_encoded => FND_API.G_FALSE
385: );
386: EXCEPTION
387: WHEN FND_API.G_EXC_ERROR THEN
388: ROLLBACK TO Update_Trx_Factors;

Line 387: WHEN FND_API.G_EXC_ERROR THEN

383: p_data => x_msg_data ,
384: p_encoded => FND_API.G_FALSE
385: );
386: EXCEPTION
387: WHEN FND_API.G_EXC_ERROR THEN
388: ROLLBACK TO Update_Trx_Factors;
389: x_return_status := FND_API.G_RET_STS_ERROR ;
390: FND_MSG_PUB.Count_And_Get
391: (

Line 389: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 394: p_encoded => FND_API.G_FALSE

390: FND_MSG_PUB.Count_And_Get
391: (
392: p_count => x_msg_count ,
393: p_data => x_msg_data ,
394: p_encoded => FND_API.G_FALSE
395: );
396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
397: ROLLBACK TO Update_Trx_Factors;
398: x_loading_status := 'UNEXPECTED_ERR';

Line 396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

392: p_count => x_msg_count ,
393: p_data => x_msg_data ,
394: p_encoded => FND_API.G_FALSE
395: );
396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
397: ROLLBACK TO Update_Trx_Factors;
398: x_loading_status := 'UNEXPECTED_ERR';
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
400: FND_MSG_PUB.Count_And_Get

Line 399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

395: );
396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
397: ROLLBACK TO Update_Trx_Factors;
398: x_loading_status := 'UNEXPECTED_ERR';
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
400: FND_MSG_PUB.Count_And_Get
401: (
402: p_count => x_msg_count ,
403: p_data => x_msg_data ,

Line 404: p_encoded => FND_API.G_FALSE

400: FND_MSG_PUB.Count_And_Get
401: (
402: p_count => x_msg_count ,
403: p_data => x_msg_data ,
404: p_encoded => FND_API.G_FALSE
405: );
406: WHEN OTHERS THEN
407: ROLLBACK TO Update_Trx_Factors;
408: x_loading_status := 'UNEXPECTED_ERR';

Line 409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

405: );
406: WHEN OTHERS THEN
407: ROLLBACK TO Update_Trx_Factors;
408: x_loading_status := 'UNEXPECTED_ERR';
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
410: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
411: THEN
412: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
413: END IF;

Line 418: p_encoded => FND_API.G_FALSE

414: FND_MSG_PUB.Count_And_Get
415: (
416: p_count => x_msg_count ,
417: p_data => x_msg_data ,
418: p_encoded => FND_API.G_FALSE
419: );
420: END Update_Trx_Factors;
421:
422: