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

Line 329: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM) RETURN BOOLEAN

325: END;
326:
327: FUNCTION Check_Notif_Exists(
328: p_notif_setup_id IN NUMBER,
329: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM) RETURN BOOLEAN
330: IS
331: l_exists VARCHAR2(1) := '0';
332: BEGIN
333: if( p_object_version_number = FND_API.G_MISS_NUM OR p_object_version_number is NULL ) then

Line 333: if( p_object_version_number = FND_API.G_MISS_NUM OR p_object_version_number is NULL ) then

329: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM) RETURN BOOLEAN
330: IS
331: l_exists VARCHAR2(1) := '0';
332: BEGIN
333: if( p_object_version_number = FND_API.G_MISS_NUM OR p_object_version_number is NULL ) then
334: select '1'
335: into l_exists
336: From Dual
337: where exists(

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

377:
378:
379: procedure Save_WF_NOTIF_Setup(
380: p_api_version IN NUMBER,
381: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
382: p_commit IN VARCHAR2 := FND_API.G_FALSE,
383: x_return_status OUT NOCOPY VARCHAR2,
384: x_msg_count OUT NOCOPY NUMBER,
385: x_msg_data OUT NOCOPY VARCHAR2,

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

378:
379: procedure Save_WF_NOTIF_Setup(
380: p_api_version IN NUMBER,
381: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
382: p_commit IN VARCHAR2 := FND_API.G_FALSE,
383: x_return_status OUT NOCOPY VARCHAR2,
384: x_msg_count OUT NOCOPY NUMBER,
385: x_msg_data OUT NOCOPY VARCHAR2,
386: P_NOTIF_SETUP_ID in NUMBER,

Line 393: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,

389: P_USER_TYPE_FLAG in VARCHAR2,
390: P_ENABLED_FLAG in VARCHAR2,
391: P_DEFAULT_MESSAGE_NAME in VARCHAR2,
392: P_UPDATE_ENABLED_FLAG in VARCHAR2,
393: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
394: P_NOTIFICATION_NAME in VARCHAR2,
395: p_customized_flag IN VARCHAR2
396: ) IS
397: l_api_name CONSTANT VARCHAR2(30) := 'save_wf_notif_setup';

Line 415: if NOT FND_API.Compatible_Api_Call(g_api_version, p_api_version, l_api_name, g_pkg_name) THEN

411: BEGIN
412: --debug('Save_wf_notif_setup 1');
413: savepoint save_wf_notif_setup;
414:
415: if NOT FND_API.Compatible_Api_Call(g_api_version, p_api_version, l_api_name, g_pkg_name) THEN
416: --debug('Save_wf_notif_setup 2');
417: raise FND_API.G_EXC_UNEXPECTED_ERROR;
418: end if;
419:

Line 417: raise FND_API.G_EXC_UNEXPECTED_ERROR;

413: savepoint save_wf_notif_setup;
414:
415: if NOT FND_API.Compatible_Api_Call(g_api_version, p_api_version, l_api_name, g_pkg_name) THEN
416: --debug('Save_wf_notif_setup 2');
417: raise FND_API.G_EXC_UNEXPECTED_ERROR;
418: end if;
419:
420: if FND_API.To_Boolean(p_init_msg_list) then
421: --debug('Save_wf_notif_setup 3');

Line 420: if FND_API.To_Boolean(p_init_msg_list) then

416: --debug('Save_wf_notif_setup 2');
417: raise FND_API.G_EXC_UNEXPECTED_ERROR;
418: end if;
419:
420: if FND_API.To_Boolean(p_init_msg_list) then
421: --debug('Save_wf_notif_setup 3');
422: FND_MSG_PUB.initialize;
423: end if;
424:

Line 426: x_return_status := FND_API.G_RET_STS_SUCCESS;

422: FND_MSG_PUB.initialize;
423: end if;
424:
425: --debug('Save_wf_notif_setup 4');
426: x_return_status := FND_API.G_RET_STS_SUCCESS;
427:
428: if p_notif_setup_id IS NOT NULL THEN
429: --debug('Save_wf_notif_setup 5');
430: if( check_notif_exists(p_notif_setup_id, p_object_version_number) = TRUE ) then

Line 432: if( p_object_version_number = FND_API.G_MISS_NUM ) then

428: if p_notif_setup_id IS NOT NULL THEN
429: --debug('Save_wf_notif_setup 5');
430: if( check_notif_exists(p_notif_setup_id, p_object_version_number) = TRUE ) then
431: l_operation_type :='UPDATE';
432: if( p_object_version_number = FND_API.G_MISS_NUM ) then
433: select object_version_number
434: into l_object_version_number
435: from ibe_wf_notif_setup
436: where notif_setup_id = p_notif_setup_id;

Line 442: raise FND_API.G_EXC_ERROR;

438: l_object_version_number := p_object_version_number;
439: end if;
440: l_object_version_number := l_object_version_number +1;
441: else
442: raise FND_API.G_EXC_ERROR;
443: end if;
444: end if;
445:
446: if( p_notification_name is not null AND l_operation_type = 'INSERT') then

Line 450: raise FND_API.G_EXC_ERROR;

446: if( p_notification_name is not null AND l_operation_type = 'INSERT') then
447: --debug('Save_wf_notif_setup 6');
448: if( check_notif_duplicate(p_notification_name) <> TRUE ) then
449: --debug('save_wf_notif_setup 7');
450: raise FND_API.G_EXC_ERROR;
451: end if;
452: --debug('save_wf_notif_setup 7a');
453:
454: elsif( p_notification_name is null AND l_operation_type = 'INSERT') then

Line 460: raise FND_API.G_EXC_ERROR;

456: --debug('save_wf_notif_setup 9');
457: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_NOTIF_NAME');
458: FND_MESSAGE.SET_TOKEN('NAME', p_notification_name);
459: FND_MSG_PUB.ADD;
460: raise FND_API.G_EXC_ERROR;
461: end if;
462:
463: --debug('save_wf_notif_setup 10');
464: -- now validate if all parameters that are required is not null

Line 470: raise FND_API.G_EXC_ERROR;

466: if( p_org_id_flag is null ) then
467: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_FIELD');
468: FND_MESSAGE.SET_TOKEN('NAME', 'ORG_ID_FLAG');
469: FND_MSG_PUB.ADD;
470: raise FND_API.G_EXC_ERROR;
471: elsif( p_msite_id_flag is null ) THEN
472: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_FIELD');
473: FND_MESSAGE.SET_TOKEN('NAME', 'MSITE_ID_FLAG');
474: FND_MSG_PUB.ADD;

Line 475: raise FND_API.G_EXC_ERROR;

471: elsif( p_msite_id_flag is null ) THEN
472: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_FIELD');
473: FND_MESSAGE.SET_TOKEN('NAME', 'MSITE_ID_FLAG');
474: FND_MSG_PUB.ADD;
475: raise FND_API.G_EXC_ERROR;
476: elsif( p_user_type_flag is null ) THEN
477: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_FIELD');
478: FND_MESSAGE.SET_TOKEN('NAME', 'USER_TYPE_FLAG');
479: FND_MSG_PUB.ADD;

Line 480: raise FND_API.G_EXC_ERROR;

476: elsif( p_user_type_flag is null ) THEN
477: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_FIELD');
478: FND_MESSAGE.SET_TOKEN('NAME', 'USER_TYPE_FLAG');
479: FND_MSG_PUB.ADD;
480: raise FND_API.G_EXC_ERROR;
481: elsif( p_enabled_flag is null ) THEN
482: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_FIELD');
483: FND_MESSAGE.SET_TOKEN('NAME', 'ENABLED_FLAG');
484: FND_MSG_PUB.ADD;

Line 485: raise FND_API.G_EXC_ERROR;

481: elsif( p_enabled_flag is null ) THEN
482: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_FIELD');
483: FND_MESSAGE.SET_TOKEN('NAME', 'ENABLED_FLAG');
484: FND_MSG_PUB.ADD;
485: raise FND_API.G_EXC_ERROR;
486: elsif( p_default_MESSAGE_NAME is null ) THEN
487: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_FIELD');
488: FND_MESSAGE.SET_TOKEN('NAME', 'DEFAULT_MESSAGE_NAME');
489: FND_MSG_PUB.ADD;

Line 490: raise FND_API.G_EXC_ERROR;

486: elsif( p_default_MESSAGE_NAME is null ) THEN
487: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_FIELD');
488: FND_MESSAGE.SET_TOKEN('NAME', 'DEFAULT_MESSAGE_NAME');
489: FND_MSG_PUB.ADD;
490: raise FND_API.G_EXC_ERROR;
491: end if;
492:
493: if( l_operation_type = 'INSERT' ) THEN
494: --debug('save_wf_notif_setup 11');

Line 553: if FND_API.to_Boolean(p_commit) THEN

549: );
550: --debug('save_wf_notif_setup 15');
551: end if;
552:
553: if FND_API.to_Boolean(p_commit) THEN
554: --debug('save_wf_notif_setup 16');
555: commit;
556: end if;
557:

Line 559: x_return_status := FND_API.G_RET_STS_SUCCESS;

555: commit;
556: end if;
557:
558: --debug('save_wf_notif_setup 17');
559: x_return_status := FND_API.G_RET_STS_SUCCESS;
560:
561: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
562: if( x_msg_count > 1 ) then
563: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

Line 561: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

557:
558: --debug('save_wf_notif_setup 17');
559: x_return_status := FND_API.G_RET_STS_SUCCESS;
560:
561: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
562: if( x_msg_count > 1 ) then
563: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
564: end if;
565: --debug('save_wf_notif_setup 18');

Line 563: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

559: x_return_status := FND_API.G_RET_STS_SUCCESS;
560:
561: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
562: if( x_msg_count > 1 ) then
563: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
564: end if;
565: --debug('save_wf_notif_setup 18');
566: EXCEPTION
567: when FND_API.G_EXC_ERROR THEN

Line 567: when FND_API.G_EXC_ERROR THEN

563: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
564: end if;
565: --debug('save_wf_notif_setup 18');
566: EXCEPTION
567: when FND_API.G_EXC_ERROR THEN
568: rollback to save_wf_notif_setup;
569: x_return_status := FND_API.G_RET_STS_ERROR;
570: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
571: if( x_msg_count > 1 ) then

Line 569: x_return_status := FND_API.G_RET_STS_ERROR;

565: --debug('save_wf_notif_setup 18');
566: EXCEPTION
567: when FND_API.G_EXC_ERROR THEN
568: rollback to save_wf_notif_setup;
569: x_return_status := FND_API.G_RET_STS_ERROR;
570: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
571: if( x_msg_count > 1 ) then
572: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
573: end if;

Line 570: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

566: EXCEPTION
567: when FND_API.G_EXC_ERROR THEN
568: rollback to save_wf_notif_setup;
569: x_return_status := FND_API.G_RET_STS_ERROR;
570: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
571: if( x_msg_count > 1 ) then
572: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
573: end if;
574: when FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 572: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

568: rollback to save_wf_notif_setup;
569: x_return_status := FND_API.G_RET_STS_ERROR;
570: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
571: if( x_msg_count > 1 ) then
572: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
573: end if;
574: when FND_API.G_EXC_UNEXPECTED_ERROR THEN
575: rollback to save_wf_notif_setup;
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 574: when FND_API.G_EXC_UNEXPECTED_ERROR THEN

570: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
571: if( x_msg_count > 1 ) then
572: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
573: end if;
574: when FND_API.G_EXC_UNEXPECTED_ERROR THEN
575: rollback to save_wf_notif_setup;
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
577: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
578: if( x_msg_count > 1 ) then

Line 576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

572: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
573: end if;
574: when FND_API.G_EXC_UNEXPECTED_ERROR THEN
575: rollback to save_wf_notif_setup;
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
577: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
578: if( x_msg_count > 1 ) then
579: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
580: end if;

Line 577: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

573: end if;
574: when FND_API.G_EXC_UNEXPECTED_ERROR THEN
575: rollback to save_wf_notif_setup;
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
577: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
578: if( x_msg_count > 1 ) then
579: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
580: end if;
581:

Line 579: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

575: rollback to save_wf_notif_setup;
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
577: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
578: if( x_msg_count > 1 ) then
579: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
580: end if;
581:
582: when OTHERS then
583: rollback to save_wf_notif_setup;

Line 584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

580: end if;
581:
582: when OTHERS then
583: rollback to save_wf_notif_setup;
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
585: if FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
586: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
587: end if;
588: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

Line 588: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
585: if FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
586: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
587: end if;
588: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
589: if( x_msg_count > 1 ) then
590: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
591: end if;
592: END save_wf_notif_setup;

Line 590: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

586: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
587: end if;
588: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
589: if( x_msg_count > 1 ) then
590: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
591: end if;
592: END save_wf_notif_setup;
593:
594: PROCEDURE delete_wf_notif_setup

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

593:
594: PROCEDURE delete_wf_notif_setup
595: (
596: p_api_version IN NUMBER,
597: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
598: p_commit IN VARCHAR2 := FND_API.G_FALSE,
599: x_return_status OUT NOCOPY VARCHAR2,
600: x_msg_count OUT NOCOPY NUMBER,
601: x_msg_data OUT NOCOPY VARCHAR2,

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

594: PROCEDURE delete_wf_notif_setup
595: (
596: p_api_version IN NUMBER,
597: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
598: p_commit IN VARCHAR2 := FND_API.G_FALSE,
599: x_return_status OUT NOCOPY VARCHAR2,
600: x_msg_count OUT NOCOPY NUMBER,
601: x_msg_data OUT NOCOPY VARCHAR2,
602: p_notification_name IN VARCHAR2

Line 625: IF NOT FND_API.compatible_api_call(g_api_version, p_api_version, l_api_name, g_pkg_name ) THEN

621: BEGIN
622: -- null;
623: savepoint delete_wf_notif_setup;
624:
625: IF NOT FND_API.compatible_api_call(g_api_version, p_api_version, l_api_name, g_pkg_name ) THEN
626: RAISE FND_API.g_exc_unexpected_error;
627: END IF;
628:
629: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 626: RAISE FND_API.g_exc_unexpected_error;

622: -- null;
623: savepoint delete_wf_notif_setup;
624:
625: IF NOT FND_API.compatible_api_call(g_api_version, p_api_version, l_api_name, g_pkg_name ) THEN
626: RAISE FND_API.g_exc_unexpected_error;
627: END IF;
628:
629: IF FND_API.to_boolean(p_init_msg_list) THEN
630: FND_MSG_PUB.initialize;

Line 629: IF FND_API.to_boolean(p_init_msg_list) THEN

625: IF NOT FND_API.compatible_api_call(g_api_version, p_api_version, l_api_name, g_pkg_name ) THEN
626: RAISE FND_API.g_exc_unexpected_error;
627: END IF;
628:
629: IF FND_API.to_boolean(p_init_msg_list) THEN
630: FND_MSG_PUB.initialize;
631: END IF;
632:
633: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 633: x_return_status := FND_API.G_RET_STS_SUCCESS;

629: IF FND_API.to_boolean(p_init_msg_list) THEN
630: FND_MSG_PUB.initialize;
631: END IF;
632:
633: x_return_status := FND_API.G_RET_STS_SUCCESS;
634:
635: if( p_notification_name IS NOT NULL ) THEN
636: OPEN wf_notif_setup(p_notification_name);
637: FETCH WF_NOTIF_SETUP into l_notif_setup_id;

Line 647: p_init_msg_list => FND_API.G_FALSE,

643: exit when wf_Notif_Msg_Maps%NOTFOUND;
644:
645: IBE_WF_NOTIF_MSG_MAPS_PVT.Delete_Wf_Notif_Msg_MAPS(
646: p_api_version => 1.0,
647: p_init_msg_list => FND_API.G_FALSE,
648: p_commit => FND_API.G_FALSE,
649: x_return_status => l_return_status,
650: x_msg_count => x_msg_count,
651: x_msg_data => x_msg_data,

Line 648: p_commit => FND_API.G_FALSE,

644:
645: IBE_WF_NOTIF_MSG_MAPS_PVT.Delete_Wf_Notif_Msg_MAPS(
646: p_api_version => 1.0,
647: p_init_msg_list => FND_API.G_FALSE,
648: p_commit => FND_API.G_FALSE,
649: x_return_status => l_return_status,
650: x_msg_count => x_msg_count,
651: x_msg_data => x_msg_data,
652: p_notification_name => p_notification_name,

Line 656: if( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

652: p_notification_name => p_notification_name,
653: p_notif_msg_map_id => l_notif_msg_map_id,
654: p_message_name => l_message_name);
655:
656: if( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
657: raise FND_API.G_EXC_ERROR;
658: end if;
659: END LOOP;
660: close wf_notif_msg_maps;

Line 657: raise FND_API.G_EXC_ERROR;

653: p_notif_msg_map_id => l_notif_msg_map_id,
654: p_message_name => l_message_name);
655:
656: if( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
657: raise FND_API.G_EXC_ERROR;
658: end if;
659: END LOOP;
660: close wf_notif_msg_maps;
661: Delete_Row(p_notif_setup_id => l_notif_setup_id);

Line 666: raise FND_API.G_EXC_ERROR;

662: else
663: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_NOTIF_NAME');
664: FND_MESSAGE.SET_TOKEN('NAME', 'Notification_Name');
665: FND_MSG_PUB.ADD;
666: raise FND_API.G_EXC_ERROR;
667: end if;
668: EXCEPTION
669: WHEN FND_API.g_exc_error THEN
670: ROLLBACK TO delete_wf_notif_setup;

Line 669: WHEN FND_API.g_exc_error THEN

665: FND_MSG_PUB.ADD;
666: raise FND_API.G_EXC_ERROR;
667: end if;
668: EXCEPTION
669: WHEN FND_API.g_exc_error THEN
670: ROLLBACK TO delete_wf_notif_setup;
671: x_return_status := FND_API.g_ret_sts_error;
672: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data );
673: if( x_msg_count > 1 ) then

Line 671: x_return_status := FND_API.g_ret_sts_error;

667: end if;
668: EXCEPTION
669: WHEN FND_API.g_exc_error THEN
670: ROLLBACK TO delete_wf_notif_setup;
671: x_return_status := FND_API.g_ret_sts_error;
672: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data );
673: if( x_msg_count > 1 ) then
674: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
675: end if;

Line 672: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data );

668: EXCEPTION
669: WHEN FND_API.g_exc_error THEN
670: ROLLBACK TO delete_wf_notif_setup;
671: x_return_status := FND_API.g_ret_sts_error;
672: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data );
673: if( x_msg_count > 1 ) then
674: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
675: end if;
676:

Line 674: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

670: ROLLBACK TO delete_wf_notif_setup;
671: x_return_status := FND_API.g_ret_sts_error;
672: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data );
673: if( x_msg_count > 1 ) then
674: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
675: end if;
676:
677: WHEN FND_API.g_exc_unexpected_error THEN
678: ROLLBACK TO delete_wf_notif_setup;

Line 677: WHEN FND_API.g_exc_unexpected_error THEN

673: if( x_msg_count > 1 ) then
674: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
675: end if;
676:
677: WHEN FND_API.g_exc_unexpected_error THEN
678: ROLLBACK TO delete_wf_notif_setup;
679: x_return_status := FND_API.g_ret_sts_unexp_error ;
680: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data );
681: if( x_msg_count > 1 ) then

Line 679: x_return_status := FND_API.g_ret_sts_unexp_error ;

675: end if;
676:
677: WHEN FND_API.g_exc_unexpected_error THEN
678: ROLLBACK TO delete_wf_notif_setup;
679: x_return_status := FND_API.g_ret_sts_unexp_error ;
680: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data );
681: if( x_msg_count > 1 ) then
682: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
683: end if;

Line 680: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data );

676:
677: WHEN FND_API.g_exc_unexpected_error THEN
678: ROLLBACK TO delete_wf_notif_setup;
679: x_return_status := FND_API.g_ret_sts_unexp_error ;
680: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data );
681: if( x_msg_count > 1 ) then
682: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
683: end if;
684: WHEN OTHERS THEN

Line 682: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

678: ROLLBACK TO delete_wf_notif_setup;
679: x_return_status := FND_API.g_ret_sts_unexp_error ;
680: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data );
681: if( x_msg_count > 1 ) then
682: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
683: end if;
684: WHEN OTHERS THEN
685: ROLLBACK TO delete_wf_notif_setup;
686: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 686: x_return_status := FND_API.g_ret_sts_unexp_error ;

682: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
683: end if;
684: WHEN OTHERS THEN
685: ROLLBACK TO delete_wf_notif_setup;
686: x_return_status := FND_API.g_ret_sts_unexp_error ;
687: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
688: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
689: END IF;
690: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data );

Line 690: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data );

686: x_return_status := FND_API.g_ret_sts_unexp_error ;
687: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
688: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
689: END IF;
690: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data );
691: if( x_msg_count > 1 ) then
692: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
693: end if;
694: END Delete_wf_notif_setup;

Line 692: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

688: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
689: END IF;
690: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data );
691: if( x_msg_count > 1 ) then
692: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
693: end if;
694: END Delete_wf_notif_setup;
695:
696: procedure Update_Wf_notif_setup(

Line 721: x_return_status(1) := FND_API.G_RET_STS_ERROR;

717: x_return_status := JTF_VARCHAR2_TABLE_100();
718: x_msg_data := JTF_VARCHAR2_TABLE_2000();
719: if( p_notif_name_tbl IS NULL ) THEN
720: x_return_status.extend(1);
721: x_return_status(1) := FND_API.G_RET_STS_ERROR;
722: x_msg_data.extend(1);
723: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_NOTIF_NAME');
724: FND_MESSAGE.SET_TOKEN('NAME', 'Notification_Name');
725: x_msg_data(1) := FND_MESSAGE.GET;

Line 729: x_return_status(1) := FND_API.G_RET_STS_ERROR;

725: x_msg_data(1) := FND_MESSAGE.GET;
726: x_msg_count := 1;
727: elsif( p_notif_name_tbl.COUNT <> p_enabled_flag_tbl.COUNT ) THEN
728: x_return_status.extend(1);
729: x_return_status(1) := FND_API.G_RET_STS_ERROR;
730: x_msg_data.extend(1);
731: x_msg_data(1) := FND_MESSAGE.GET_STRING('IBE', 'IBE_WF_NOTIF_UPDATE_ERROR');
732: x_msg_count := 1;
733: else

Line 743: x_return_status(i) := FND_API.G_RET_STS_SUCCESS;

739: x_msg_data.extend(p_notif_name_tbl.COUNT);
740: --debug('number of notif is ' || p_notif_name_tbl.COUNT);
741: for i in 1..p_notif_name_tbl.COUNT LOOP
742: --debug('p_notif_name ' || i || ' is ' || p_notif_name_tbl(i));
743: x_return_status(i) := FND_API.G_RET_STS_SUCCESS;
744: if( p_notif_name_tbl(i) IS NOT NULL ) THEN
745: BEGIN
746: select msite_id_flag, org_id_flag, user_type_flag, default_message_name, update_enabled_flag,
747: customized_flag, notif_setup_id, object_version_number

Line 754: x_return_status(i) := FND_API.G_RET_STS_ERROR;

750: from ibe_Wf_notif_setup
751: where notification_name = p_notif_name_tbl(i);
752: EXCEPTION
753: when no_data_found THEN
754: x_return_status(i) := FND_API.G_RET_STS_ERROR;
755: x_msg_count := x_msg_count + 1;
756: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_NAME_NOT_FOUND');
757: FND_MESSAGE.SET_TOKEN('NAME', p_notif_name_tbl(i));
758: x_msg_data(i) := FND_MESSAGE.GET;

Line 762: if( x_return_status(i) = FND_API.G_RET_STS_SUCCESS ) then

758: x_msg_data(i) := FND_MESSAGE.GET;
759: end;
760: --debug('l_notif_setup_id is ' || l_notif_setup_id);
761: --debug('l_object_version_number is ' || l_object_version_number);
762: if( x_return_status(i) = FND_API.G_RET_STS_SUCCESS ) then
763: IBE_WF_NOTIF_SETUP_PVT.save_wf_notif_setup(
764: p_api_version => 1.0,
765: p_init_msg_list => FND_API.G_TRUE,
766: p_commit => FND_API.G_TRUE,

Line 765: p_init_msg_list => FND_API.G_TRUE,

761: --debug('l_object_version_number is ' || l_object_version_number);
762: if( x_return_status(i) = FND_API.G_RET_STS_SUCCESS ) then
763: IBE_WF_NOTIF_SETUP_PVT.save_wf_notif_setup(
764: p_api_version => 1.0,
765: p_init_msg_list => FND_API.G_TRUE,
766: p_commit => FND_API.G_TRUE,
767: x_return_Status => l_return_status,
768: x_msg_count => l_msg_count,
769: x_msg_data => l_msg_data,

Line 766: p_commit => FND_API.G_TRUE,

762: if( x_return_status(i) = FND_API.G_RET_STS_SUCCESS ) then
763: IBE_WF_NOTIF_SETUP_PVT.save_wf_notif_setup(
764: p_api_version => 1.0,
765: p_init_msg_list => FND_API.G_TRUE,
766: p_commit => FND_API.G_TRUE,
767: x_return_Status => l_return_status,
768: x_msg_count => l_msg_count,
769: x_msg_data => l_msg_data,
770: p_notif_setup_id => l_notif_setup_id,

Line 785: x_return_status(i) := FND_API.G_RET_STS_ERROR;

781: x_msg_data(i) := l_msg_data;
782: x_msg_count := x_msg_count + l_msg_count;
783: end if;
784: else
785: x_return_status(i) := FND_API.G_RET_STS_ERROR;
786: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_NOTIF_NAME');
787: FND_MESSAGE.SET_TOKEN('NAME', 'Notification_Name');
788: x_msg_data(i) := FND_MESSAGE.GET;
789: x_msg_count := x_msg_count + 1;