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

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

2: /* $Header: csmpgpdb.pls 120.2 2008/02/29 09:16:01 anaraman noship $*/
3:
4: PROCEDURE assign_related_group
5: ( p_api_version_number IN NUMBER,
6: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
7: p_group_id IN NUMBER,
8: p_related_group_id IN NUMBER,
9: p_operation IN VARCHAR2,
10: x_msg_count OUT NOCOPY NUMBER,

Line 48: IF FND_API.TO_BOOLEAN (p_init_msg_list)

44: BEGIN
45:
46: CSM_UTIL_PKG.LOG('Entering CSM_GROUP_DOWNLOAD_PUB.ASSIGN_RELATED_GROUP Package ', 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_RELATED_GROUP',FND_LOG.LEVEL_EXCEPTION);
47:
48: IF FND_API.TO_BOOLEAN (p_init_msg_list)
49:
50: THEN
51:
52: FND_MSG_PUB.INITIALIZE;

Line 69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

65: FND_MSG_PUB.ADD;
66:
67: x_error_message := 'NO owner found for the given group - '||p_group_id;
68:
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70:
71: END IF;
72:
73: CLOSE csr_grp_owner_id;

Line 105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

101: THEN
102:
103: x_error_message := l_error_message;
104:
105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
106:
107: END IF;
108:
109: OPEN csr_rel_grp (p_related_group_id);

Line 151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

147: THEN
148:
149: x_error_message := l_rel_error_message;
150:
151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
152:
153: END IF;
154:
155: IF p_operation IS NULL

Line 180: x_return_status := FND_API.G_RET_STS_SUCCESS;

176: CLOSE csr_rel_grp;
177:
178: END IF;
179:
180: x_return_status := FND_API.G_RET_STS_SUCCESS;
181: x_msg_count := 0;
182: x_error_message := 'Downloading related group to a group through CSM_GROUP_DOWNLOAD_PVT is done successfully';
183: CSM_UTIL_PKG.LOG('Leaving CSM_GROUP_DOWNLOAD_PUB.ASSIGN_RELATED_GROUP Package ', 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_RELATED_GROUP ',FND_LOG.LEVEL_EXCEPTION);
184:

Line 187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

183: CSM_UTIL_PKG.LOG('Leaving CSM_GROUP_DOWNLOAD_PUB.ASSIGN_RELATED_GROUP Package ', 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_RELATED_GROUP ',FND_LOG.LEVEL_EXCEPTION);
184:
185: EXCEPTION
186:
187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
188:
189: THEN
190:
191: FND_MSG_PUB.COUNT_AND_GET

Line 194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

190:
191: FND_MSG_PUB.COUNT_AND_GET
192: ( p_count => x_msg_count,
193: p_data => l_msg_data );
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
195: x_error_message := x_error_message || ' - the error message is :'||l_msg_data;
196: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_RELATED_GROUP',FND_LOG.LEVEL_EXCEPTION);
197:
198: WHEN OTHERS

Line 205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

201:
202: FND_MESSAGE.SET_NAME ('CSM', 'CSM_GROUP_DWNLD_UNKNOWN_ERROR');
203: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
204: FND_MSG_PUB.ADD;
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
206: l_sqlerrno := TO_CHAR(SQLCODE);
207: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
208: FND_MSG_PUB.COUNT_AND_GET
209: ( p_count => x_msg_count,

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

215: END assign_related_group;
216:
217: PROCEDURE assign_mutiple_related_groups
218: ( p_api_version_number IN NUMBER,
219: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
220: p_group_id IN NUMBER,
221: p_related_group_lst IN l_group_id_tbl_type,
222: p_operation IN VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,

Line 263: IF FND_API.TO_BOOLEAN (p_init_msg_list)

259: BEGIN
260:
261: CSM_UTIL_PKG.LOG('Entering CSM_GROUP_DOWNLOAD_PUB.ASSIGN_MUTIPLE_RELATED_GROUPS Package ', 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_RELATED_GROUP',FND_LOG.LEVEL_EXCEPTION);
262:
263: IF FND_API.TO_BOOLEAN (p_init_msg_list)
264:
265: THEN
266:
267: FND_MSG_PUB.INITIALIZE;

Line 284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

280: FND_MSG_PUB.ADD;
281:
282: x_error_message := 'NO owner found for the given group - '||p_group_id;
283:
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
285:
286: END IF;
287:
288: CLOSE csr_grp_owner_id;

Line 321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

317: THEN
318:
319: x_error_message := l_error_message;
320:
321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
322:
323: END IF;
324:
325: IF l_rel_group_id_tbl.COUNT > 0 THEN

Line 380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

376: THEN
377:
378: x_error_message := l_rel_error_message;
379:
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381:
382: END IF;
383:
384: END LOOP;

Line 412: x_return_status := FND_API.G_RET_STS_SUCCESS;

408: CLOSE csr_rel_grp;
409:
410: END IF;
411:
412: x_return_status := FND_API.G_RET_STS_SUCCESS;
413: x_msg_count := 0;
414: x_error_message := 'Downloading related group to a group through CSM_GROUP_DOWNLOAD_PVT is done successfully';
415: CSM_UTIL_PKG.LOG('Leaving CSM_GROUP_DOWNLOAD_PUB.ASSIGN_MUTIPLE_RELATED_GROUPS Package ', 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_MUTIPLE_RELATED_GROUPS ',FND_LOG.LEVEL_EXCEPTION);
416:

Line 419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

415: CSM_UTIL_PKG.LOG('Leaving CSM_GROUP_DOWNLOAD_PUB.ASSIGN_MUTIPLE_RELATED_GROUPS Package ', 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_MUTIPLE_RELATED_GROUPS ',FND_LOG.LEVEL_EXCEPTION);
416:
417: EXCEPTION
418:
419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
420:
421: THEN
422:
423: FND_MSG_PUB.COUNT_AND_GET

Line 426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

422:
423: FND_MSG_PUB.COUNT_AND_GET
424: ( p_count => x_msg_count,
425: p_data => l_msg_data );
426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
427: ROLLBACK;
428: x_error_message := x_error_message || ' - the error message is :'||l_msg_data;
429: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_MUTIPLE_RELATED_GROUPS',FND_LOG.LEVEL_EXCEPTION);
430:

Line 439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

435: FND_MESSAGE.SET_NAME ('CSM', 'CSM_GROUP_DWNLD_UNKNOWN_ERROR');
436: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
437: FND_MSG_PUB.ADD;
438: ROLLBACK;
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
440: l_sqlerrno := TO_CHAR(SQLCODE);
441: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
442: FND_MSG_PUB.COUNT_AND_GET
443: ( p_count => x_msg_count,

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

449: END assign_mutiple_related_groups;
450:
451: PROCEDURE get_related_groups
452: ( p_api_version_number IN NUMBER,
453: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
454: p_group_id IN NUMBER,
455: p_related_group_lst OUT NOCOPY l_group_id_tbl_type,
456: x_msg_count OUT NOCOPY NUMBER,
457: x_return_status OUT NOCOPY VARCHAR2,

Line 489: IF FND_API.TO_BOOLEAN (p_init_msg_list)

485: BEGIN
486:
487: CSM_UTIL_PKG.LOG('Entering CSM_GROUP_DOWNLOAD_PUB.GET_RELATED_GROUPS PACKAGE ', 'CSM_GROUP_DOWNLOAD_PUB.GET_RELATED_GROUPS',FND_LOG.LEVEL_EXCEPTION);
488:
489: IF FND_API.TO_BOOLEAN (p_init_msg_list)
490:
491: THEN
492:
493: FND_MSG_PUB.INITIALIZE;

Line 510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

506: FND_MSG_PUB.ADD;
507:
508: l_error_message := 'NO Data found for the given group - '||p_group_id;
509:
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
511:
512: END IF;
513:
514: CLOSE csr_get_owner_id;

Line 537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

533: FND_MSG_PUB.ADD;
534:
535: x_error_message := 'NO related groups for the given group id - '||p_group_id;
536:
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
538:
539: END IF;
540:
541: CLOSE csr_get_rel_grp_id;

Line 561: x_return_status := FND_API.G_RET_STS_SUCCESS;

557: CLOSE csr_get_rel_grp_id;
558:
559: END IF;
560:
561: x_return_status := FND_API.G_RET_STS_SUCCESS;
562: x_msg_count := 0;
563: x_error_message := 'The related groups for the group id are fetched successfully';
564: CSM_UTIL_PKG.LOG('Leaving CSM_GROUP_DOWNLOAD_PUB.GET_RELATED_GROUPS Package ', 'CSM_GROUP_DOWNLOAD_PUB.GET_RELATED_GROUPS',FND_LOG.LEVEL_EXCEPTION);
565:

Line 568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

564: CSM_UTIL_PKG.LOG('Leaving CSM_GROUP_DOWNLOAD_PUB.GET_RELATED_GROUPS Package ', 'CSM_GROUP_DOWNLOAD_PUB.GET_RELATED_GROUPS',FND_LOG.LEVEL_EXCEPTION);
565:
566: EXCEPTION
567:
568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
569:
570: THEN
571:
572: FND_MSG_PUB.COUNT_AND_GET

Line 576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

572: FND_MSG_PUB.COUNT_AND_GET
573: ( p_encoded => 'T',
574: p_count => x_msg_count,
575: p_data => l_msg_data );
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
577: x_error_message := l_error_message || ' - the error message is :'||l_msg_data;
578: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_GROUP_DOWNLOAD_PUB.GET_RELATED_GROUPS',FND_LOG.LEVEL_EXCEPTION);
579:
580: WHEN OTHERS

Line 587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

583:
584: FND_MESSAGE.SET_NAME ('CSM', 'CSM_GROUP_UNKNOWN_ERROR');
585: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
586: FND_MSG_PUB.ADD;
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: l_sqlerrno := TO_CHAR(SQLCODE);
589: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
590: FND_MSG_PUB.COUNT_AND_GET
591: ( p_count => x_msg_count,