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

Line 48: IF NOT FND_API.Compatible_API_Call (l_api_version,

44:
45: csi_utility_grp.check_ib_active;
46:
47: -- Standard call to check for call compatibility.
48: IF NOT FND_API.Compatible_API_Call (l_api_version,
49: p_api_version,
50: l_api_name ,
51: g_pkg_name)
52: THEN

Line 53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

49: p_api_version,
50: l_api_name ,
51: g_pkg_name)
52: THEN
53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
54: END IF;
55:
56:
57: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 58: IF FND_API.to_Boolean( p_init_msg_list ) THEN

54: END IF;
55:
56:
57: -- Initialize message list if p_init_msg_list is set to TRUE.
58: IF FND_API.to_Boolean( p_init_msg_list ) THEN
59: FND_MSG_PUB.initialize;
60: END IF;
61:
62:

Line 64: x_return_status := FND_API.G_RET_STS_SUCCESS;

60: END IF;
61:
62:
63: -- Initialize API return status to success
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65:
66:
67: -- Check the profile option debug_level for debug message reporting
68: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

Line 96: IF (p_pricing_attribs_query_rec.pricing_attribute_id = FND_API.G_MISS_NUM)

92: *****/
93:
94: -- Start API body
95: -- check if atleast one query parameters are passed
96: IF (p_pricing_attribs_query_rec.pricing_attribute_id = FND_API.G_MISS_NUM)
97: AND (p_pricing_attribs_query_rec.instance_id = FND_API.G_MISS_NUM) THEN
98: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
99: FND_MSG_PUB.ADD;
100: RAISE FND_API.G_EXC_ERROR;

Line 97: AND (p_pricing_attribs_query_rec.instance_id = FND_API.G_MISS_NUM) THEN

93:
94: -- Start API body
95: -- check if atleast one query parameters are passed
96: IF (p_pricing_attribs_query_rec.pricing_attribute_id = FND_API.G_MISS_NUM)
97: AND (p_pricing_attribs_query_rec.instance_id = FND_API.G_MISS_NUM) THEN
98: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
99: FND_MSG_PUB.ADD;
100: RAISE FND_API.G_EXC_ERROR;
101: END IF;

Line 100: RAISE FND_API.G_EXC_ERROR;

96: IF (p_pricing_attribs_query_rec.pricing_attribute_id = FND_API.G_MISS_NUM)
97: AND (p_pricing_attribs_query_rec.instance_id = FND_API.G_MISS_NUM) THEN
98: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
99: FND_MSG_PUB.ADD;
100: RAISE FND_API.G_EXC_ERROR;
101: END IF;
102:
103:
104: -- Generate the where clause

Line 140: IF (p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE) THEN

136:
137: -- Close the cursor
138: DBMS_SQL.CLOSE_CURSOR(l_cur_get_pri);
139:
140: IF (p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE) THEN
141: IF p_time_stamp <= sysdate THEN
142: csi_pricing_attribs_pvt.Construct_pri_From_Hist(x_pricing_attribs_tbl, p_time_stamp);
143: ELSE
144: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');

Line 147: RAISE FND_API.G_EXC_ERROR;

143: ELSE
144: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
145: FND_MESSAGE.SET_TOKEN('TIME_STAMP',p_time_stamp);
146: FND_MSG_PUB.ADD;
147: RAISE FND_API.G_EXC_ERROR;
148: END IF;
149: END IF;
150:
151: -- End of API body

Line 155: IF FND_API.To_Boolean( p_commit ) THEN

151: -- End of API body
152:
153: -- Standard check of p_commit.
154: /*
155: IF FND_API.To_Boolean( p_commit ) THEN
156: COMMIT WORK;
157: END IF;
158: */
159:

Line 177: WHEN FND_API.G_EXC_ERROR THEN

173:
174:
175: EXCEPTION
176:
177: WHEN FND_API.G_EXC_ERROR THEN
178: -- ROLLBACK TO get_pricing_attribs;
179: x_return_status := FND_API.G_RET_STS_ERROR ;
180: FND_MSG_PUB.Count_And_Get
181: ( p_count => x_msg_count,

Line 179: x_return_status := FND_API.G_RET_STS_ERROR ;

175: EXCEPTION
176:
177: WHEN FND_API.G_EXC_ERROR THEN
178: -- ROLLBACK TO get_pricing_attribs;
179: x_return_status := FND_API.G_RET_STS_ERROR ;
180: FND_MSG_PUB.Count_And_Get
181: ( p_count => x_msg_count,
182: p_data => x_msg_data
183: );

Line 185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

181: ( p_count => x_msg_count,
182: p_data => x_msg_data
183: );
184:
185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
186: -- ROLLBACK TO get_pricing_attribs;
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
188: FND_MSG_PUB.Count_And_Get
189: ( p_count => x_msg_count,

Line 187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

195: DBMS_SQL.CLOSE_CURSOR(l_cur_get_pri);
196: END IF;
197:
198: -- ROLLBACK TO get_pricing_attribs;
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
200:
201: IF FND_MSG_PUB.Check_Msg_Level
202: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
203: THEN

Line 256: IF NOT FND_API.Compatible_API_Call (l_api_version,

252: csi_utility_grp.check_ib_active;
253:
254:
255: -- Standard call to check for call compatibility.
256: IF NOT FND_API.Compatible_API_Call (l_api_version,
257: p_api_version,
258: l_api_name ,
259: g_pkg_name)
260: THEN

Line 261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

257: p_api_version,
258: l_api_name ,
259: g_pkg_name)
260: THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: END IF;
263:
264:
265: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 266: IF FND_API.to_Boolean( p_init_msg_list ) THEN

262: END IF;
263:
264:
265: -- Initialize message list if p_init_msg_list is set to TRUE.
266: IF FND_API.to_Boolean( p_init_msg_list ) THEN
267: FND_MSG_PUB.initialize;
268: END IF;
269:
270:

Line 272: x_return_status := FND_API.G_RET_STS_SUCCESS;

268: END IF;
269:
270:
271: -- Initialize API return status to success
272: x_return_status := FND_API.G_RET_STS_SUCCESS;
273:
274:
275: -- Check the profile option debug_level for debug message reporting
276:

Line 322: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

318: ,x_msg_count => x_msg_count
319: ,x_msg_data => x_msg_data
320: );
321:
322: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
323: l_msg_index := 1;
324: l_msg_count := x_msg_count;
325: WHILE l_msg_count > 0 LOOP
326: x_msg_data := FND_MSG_PUB.GET

Line 328: FND_API.G_FALSE );

324: l_msg_count := x_msg_count;
325: WHILE l_msg_count > 0 LOOP
326: x_msg_data := FND_MSG_PUB.GET
327: ( l_msg_index,
328: FND_API.G_FALSE );
329:
330: csi_gen_utility_pvt.put_line( ' Failed Pub:create_pricing_attribs..');
331: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
332: l_msg_index := l_msg_index + 1;

Line 335: RAISE FND_API.G_EXC_ERROR;

331: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
332: l_msg_index := l_msg_index + 1;
333: l_msg_count := l_msg_count - 1;
334: END LOOP;
335: RAISE FND_API.G_EXC_ERROR;
336: END IF;
337: END IF;
338: END LOOP;
339: END IF;

Line 345: IF FND_API.To_Boolean( p_commit ) THEN

341: -- End of API body
342:
343:
344: -- Standard check of p_commit.
345: IF FND_API.To_Boolean( p_commit ) THEN
346: COMMIT WORK;
347: END IF;
348:
349: /***** srramakr commented for bug # 3304439

Line 366: WHEN FND_API.G_EXC_ERROR THEN

362:
363:
364: EXCEPTION
365:
366: WHEN FND_API.G_EXC_ERROR THEN
367: ROLLBACK TO create_pricing_attribs;
368: x_return_status := FND_API.G_RET_STS_ERROR ;
369: FND_MSG_PUB.Count_And_Get
370: ( p_count => x_msg_count,

Line 368: x_return_status := FND_API.G_RET_STS_ERROR ;

364: EXCEPTION
365:
366: WHEN FND_API.G_EXC_ERROR THEN
367: ROLLBACK TO create_pricing_attribs;
368: x_return_status := FND_API.G_RET_STS_ERROR ;
369: FND_MSG_PUB.Count_And_Get
370: ( p_count => x_msg_count,
371: p_data => x_msg_data
372: );

Line 374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

370: ( p_count => x_msg_count,
371: p_data => x_msg_data
372: );
373:
374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
375: ROLLBACK TO create_pricing_attribs;
376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
377: FND_MSG_PUB.Count_And_Get
378: ( p_count => x_msg_count,

Line 376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

372: );
373:
374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
375: ROLLBACK TO create_pricing_attribs;
376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
377: FND_MSG_PUB.Count_And_Get
378: ( p_count => x_msg_count,
379: p_data => x_msg_data
380: );

Line 384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

380: );
381:
382: WHEN OTHERS THEN
383: ROLLBACK TO create_pricing_attribs;
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385:
386: IF FND_MSG_PUB.Check_Msg_Level
387: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
388: THEN

Line 443: IF NOT FND_API.Compatible_API_Call (l_api_version,

439: csi_utility_grp.check_ib_active;
440:
441:
442: -- Standard call to check for call compatibility.
443: IF NOT FND_API.Compatible_API_Call (l_api_version,
444: p_api_version,
445: l_api_name ,
446: g_pkg_name)
447: THEN

Line 448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

444: p_api_version,
445: l_api_name ,
446: g_pkg_name)
447: THEN
448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
449: END IF;
450:
451:
452: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 453: IF FND_API.to_Boolean( p_init_msg_list ) THEN

449: END IF;
450:
451:
452: -- Initialize message list if p_init_msg_list is set to TRUE.
453: IF FND_API.to_Boolean( p_init_msg_list ) THEN
454: FND_MSG_PUB.initialize;
455: END IF;
456:
457:

Line 459: x_return_status := FND_API.G_RET_STS_SUCCESS;

455: END IF;
456:
457:
458: -- Initialize API return status to success
459: x_return_status := FND_API.G_RET_STS_SUCCESS;
460:
461:
462: -- Check the profile option debug_level for debug message reporting
463: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

Line 497: ,p_commit => fnd_api.g_false

493: LOOP
494: IF p_pricing_attribs_tbl.EXISTS(tab_row) THEN
495: csi_pricing_attribs_pvt.update_pricing_attribs
496: ( p_api_version => p_api_version
497: ,p_commit => fnd_api.g_false
498: ,p_init_msg_list => p_init_msg_list
499: ,p_validation_level => p_validation_level
500: ,p_pricing_attribs_rec => p_pricing_attribs_tbl(tab_row)
501: ,p_txn_rec => p_txn_rec

Line 507: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

503: ,x_msg_count => x_msg_count
504: ,x_msg_data => x_msg_data
505: );
506:
507: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
508: l_msg_index := 1;
509:
510: l_msg_count := x_msg_count;
511: WHILE l_msg_count > 0 LOOP

Line 514: FND_API.G_FALSE );

510: l_msg_count := x_msg_count;
511: WHILE l_msg_count > 0 LOOP
512: x_msg_data := FND_MSG_PUB.GET
513: (l_msg_index,
514: FND_API.G_FALSE );
515:
516: csi_gen_utility_pvt.put_line( ' Failed Pub:update_pricing_attribs..');
517: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
518: l_msg_index := l_msg_index + 1;

Line 521: RAISE FND_API.G_EXC_ERROR;

517: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
518: l_msg_index := l_msg_index + 1;
519: l_msg_count := l_msg_count - 1;
520: END LOOP;
521: RAISE FND_API.G_EXC_ERROR;
522: END IF;
523: END IF;
524: END LOOP;
525: END IF;

Line 531: IF FND_API.To_Boolean( p_commit ) THEN

527: -- End of API body
528:
529:
530: -- Standard check of p_commit.
531: IF FND_API.To_Boolean( p_commit ) THEN
532: COMMIT WORK;
533: END IF;
534:
535: /***** srramakr commented for bug # 3304439

Line 551: WHEN FND_API.G_EXC_ERROR THEN

547: );
548:
549:
550: EXCEPTION
551: WHEN FND_API.G_EXC_ERROR THEN
552: ROLLBACK TO update_pricing_attribs;
553: x_return_status := FND_API.G_RET_STS_ERROR ;
554: FND_MSG_PUB.Count_And_Get
555: ( p_count => x_msg_count,

Line 553: x_return_status := FND_API.G_RET_STS_ERROR ;

549:
550: EXCEPTION
551: WHEN FND_API.G_EXC_ERROR THEN
552: ROLLBACK TO update_pricing_attribs;
553: x_return_status := FND_API.G_RET_STS_ERROR ;
554: FND_MSG_PUB.Count_And_Get
555: ( p_count => x_msg_count,
556: p_data => x_msg_data
557: );

Line 559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

555: ( p_count => x_msg_count,
556: p_data => x_msg_data
557: );
558:
559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
560: ROLLBACK TO update_pricing_attribs;
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
562: FND_MSG_PUB.Count_And_Get
563: ( p_count => x_msg_count,

Line 561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

557: );
558:
559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
560: ROLLBACK TO update_pricing_attribs;
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
562: FND_MSG_PUB.Count_And_Get
563: ( p_count => x_msg_count,
564: p_data => x_msg_data
565: );

Line 569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

565: );
566:
567: WHEN OTHERS THEN
568: ROLLBACK TO update_pricing_attribs;
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
570:
571: IF FND_MSG_PUB.Check_Msg_Level
572: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
573: THEN

Line 627: IF NOT FND_API.Compatible_API_Call (l_api_version,

623:
624: csi_utility_grp.check_ib_active;
625:
626: -- Standard call to check for call compatibility.
627: IF NOT FND_API.Compatible_API_Call (l_api_version,
628: p_api_version,
629: l_api_name ,
630: g_pkg_name)
631: THEN

Line 632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

628: p_api_version,
629: l_api_name ,
630: g_pkg_name)
631: THEN
632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
633: END IF;
634:
635:
636: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 637: IF FND_API.to_Boolean( p_init_msg_list ) THEN

633: END IF;
634:
635:
636: -- Initialize message list if p_init_msg_list is set to TRUE.
637: IF FND_API.to_Boolean( p_init_msg_list ) THEN
638: FND_MSG_PUB.initialize;
639: END IF;
640:
641:

Line 643: x_return_status := FND_API.G_RET_STS_SUCCESS;

639: END IF;
640:
641:
642: -- Initialize API return status to success
643: x_return_status := FND_API.G_RET_STS_SUCCESS;
644:
645:
646: -- Check the profile option debug_level for debug message reporting
647: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

Line 682: ,p_commit => fnd_api.g_false

678: LOOP
679: IF p_pricing_attribs_tbl.EXISTS(tab_row) THEN
680: csi_pricing_attribs_pvt.expire_pricing_attribs
681: ( p_api_version => p_api_version
682: ,p_commit => fnd_api.g_false
683: ,p_init_msg_list => p_init_msg_list
684: ,p_validation_level => p_validation_level
685: ,p_pricing_attribs_rec => p_pricing_attribs_tbl(tab_row)
686: ,p_txn_rec => p_txn_rec

Line 692: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

688: ,x_msg_count => x_msg_count
689: ,x_msg_data => x_msg_data
690: );
691:
692: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
693: l_msg_index := 1;
694: l_msg_count := x_msg_count;
695: WHILE l_msg_count > 0 LOOP
696: x_msg_data := FND_MSG_PUB.GET

Line 698: FND_API.G_FALSE );

694: l_msg_count := x_msg_count;
695: WHILE l_msg_count > 0 LOOP
696: x_msg_data := FND_MSG_PUB.GET
697: (l_msg_index,
698: FND_API.G_FALSE );
699:
700: csi_gen_utility_pvt.put_line( ' Failed Pub:expire_pricing_attribs..');
701: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
702: l_msg_index := l_msg_index + 1;

Line 705: RAISE FND_API.G_EXC_ERROR;

701: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
702: l_msg_index := l_msg_index + 1;
703: l_msg_count := l_msg_count - 1;
704: END LOOP;
705: RAISE FND_API.G_EXC_ERROR;
706: END IF;
707:
708: END IF;
709: END LOOP;

Line 716: IF FND_API.To_Boolean( p_commit ) THEN

712: -- End of API body
713:
714:
715: -- Standard check of p_commit.
716: IF FND_API.To_Boolean( p_commit ) THEN
717: COMMIT WORK;
718: END IF;
719:
720: /***** srramakr commented for bug # 3304439

Line 737: WHEN FND_API.G_EXC_ERROR THEN

733:
734:
735: EXCEPTION
736:
737: WHEN FND_API.G_EXC_ERROR THEN
738:
739: ROLLBACK TO expire_pricing_attribs;
740: x_return_status := FND_API.G_RET_STS_ERROR ;
741: FND_MSG_PUB.Count_And_Get

Line 740: x_return_status := FND_API.G_RET_STS_ERROR ;

736:
737: WHEN FND_API.G_EXC_ERROR THEN
738:
739: ROLLBACK TO expire_pricing_attribs;
740: x_return_status := FND_API.G_RET_STS_ERROR ;
741: FND_MSG_PUB.Count_And_Get
742: ( p_count => x_msg_count,
743: p_data => x_msg_data
744: );

Line 746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

742: ( p_count => x_msg_count,
743: p_data => x_msg_data
744: );
745:
746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
747:
748: ROLLBACK TO expire_pricing_attribs;
749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
750: FND_MSG_PUB.Count_And_Get

Line 749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

745:
746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
747:
748: ROLLBACK TO expire_pricing_attribs;
749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
750: FND_MSG_PUB.Count_And_Get
751: ( p_count => x_msg_count,
752: p_data => x_msg_data
753: );

Line 758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

754:
755: WHEN OTHERS THEN
756:
757: ROLLBACK TO expire_pricing_attribs;
758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
759:
760: IF FND_MSG_PUB.Check_Msg_Level
761: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
762: THEN