DBA Data[Home] [Help]

APPS.GMP_RESOURCES_PUB dependencies on GMD_DEBUG

Line 43: gmd_debug.log_initialize('CreateResourcesPub');

39: X_msg varchar2(2000) := '';
40:
41: BEGIN
42: SAVEPOINT create_resources;
43: gmd_debug.log_initialize('CreateResourcesPub');
44:
45: /* Set the return status to success initially */
46: x_return_status := FND_API.G_RET_STS_SUCCESS;
47: l_resources_rec := p_resources;

Line 144: gmd_debug.put_line('Resource Header was created successfully');

140: ,p_encoded => FND_API.g_false
141: ,p_data => x_message_list);
142:
143: IF x_message_count = 0 THEN
144: gmd_debug.put_line('Resource Header was created successfully');
145: END IF;
146:
147: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
148: commit;

Line 147: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));

143: IF x_message_count = 0 THEN
144: gmd_debug.put_line('Resource Header was created successfully');
145: END IF;
146:
147: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
148: commit;
149:
150: EXCEPTION
151: WHEN resource_creation_failure OR invalid_version THEN

Line 469: gmd_debug.log_initialize('UpdateResourcePub');

465: invalid_version EXCEPTION;
466:
467: BEGIN
468: SAVEPOINT update_resources;
469: gmd_debug.log_initialize('UpdateResourcePub');
470:
471: /* Set the return status to success initially */
472: x_return_status := FND_API.G_RET_STS_SUCCESS;
473:

Line 549: gmd_debug.put_line('Resource was Updated successfullly');

545: ,p_encoded => FND_API.g_false
546: ,p_data => x_message_list);
547:
548: IF x_message_count = 0 THEN
549: gmd_debug.put_line('Resource was Updated successfullly');
550: END IF;
551:
552: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
553:

Line 552: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));

548: IF x_message_count = 0 THEN
549: gmd_debug.put_line('Resource was Updated successfullly');
550: END IF;
551:
552: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
553:
554: EXCEPTION
555: WHEN resource_update_failure OR invalid_version THEN
556: ROLLBACK TO SAVEPOINT update_resources;

Line 557: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');

553:
554: EXCEPTION
555: WHEN resource_update_failure OR invalid_version THEN
556: ROLLBACK TO SAVEPOINT update_resources;
557: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
558: fnd_msg_pub.count_and_get (
559: p_count => x_message_count
560: ,p_encoded => FND_API.g_false
561: ,p_data => x_message_list);

Line 565: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);

561: ,p_data => x_message_list);
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: WHEN OTHERS THEN
564: ROLLBACK TO SAVEPOINT update_resources;
565: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
566: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
567: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
568: FND_MSG_PUB.ADD;
569: fnd_msg_pub.count_and_get (

Line 613: gmd_debug.log_initialize('DeleteResourcePub');

609: resource_delete_failure EXCEPTION;
610: invalid_version EXCEPTION;
611: BEGIN
612: SAVEPOINT delete_resources;
613: gmd_debug.log_initialize('DeleteResourcePub');
614:
615: /* Set the return status to success initially */
616: x_return_status := FND_API.G_RET_STS_SUCCESS;
617:

Line 638: GMD_DEBUG.PUT_LINE('Resource to be deleted Does Not Exist ');

634: CLOSE Cur_resources;
635:
636: IF (l_counter = 0 ) then
637: l_return_status := 'E';
638: GMD_DEBUG.PUT_LINE('Resource to be deleted Does Not Exist ');
639: FND_MSG_PUB.ADD;
640: RAISE resource_delete_failure;
641: ELSE
642: delete from cr_rsrc_mst_tl

Line 656: gmd_debug.put_line('Resource was deleted successfully');

652: ,p_encoded => FND_API.g_false
653: ,p_data => x_message_list);
654:
655: IF x_message_count = 0 THEN
656: gmd_debug.put_line('Resource was deleted successfully');
657: END IF;
658:
659: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
660:

Line 659: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));

655: IF x_message_count = 0 THEN
656: gmd_debug.put_line('Resource was deleted successfully');
657: END IF;
658:
659: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
660:
661: EXCEPTION
662: WHEN resource_delete_failure OR invalid_version THEN
663: ROLLBACK TO SAVEPOINT delete_resources;

Line 664: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');

660:
661: EXCEPTION
662: WHEN resource_delete_failure OR invalid_version THEN
663: ROLLBACK TO SAVEPOINT delete_resources;
664: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
665: fnd_msg_pub.count_and_get (
666: p_count => x_message_count
667: ,p_encoded => FND_API.g_false
668: ,p_data => x_message_list);

Line 672: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);

668: ,p_data => x_message_list);
669: x_return_status := FND_API.G_RET_STS_ERROR;
670: WHEN OTHERS THEN
671: ROLLBACK TO SAVEPOINT delete_resources;
672: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
673: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
674: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
675: FND_MSG_PUB.ADD;
676: fnd_msg_pub.count_and_get (