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 133: gmd_debug.put_line('Resource Header was created successfully');

129: ,p_encoded => FND_API.g_false
130: ,p_data => x_message_list);
131:
132: IF x_message_count = 0 THEN
133: gmd_debug.put_line('Resource Header was created successfully');
134: END IF;
135:
136: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
137: commit;

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

132: IF x_message_count = 0 THEN
133: gmd_debug.put_line('Resource Header was created successfully');
134: END IF;
135:
136: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
137: commit;
138:
139: EXCEPTION
140: WHEN resource_creation_failure OR invalid_version THEN

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

410: invalid_version EXCEPTION;
411:
412: BEGIN
413: SAVEPOINT update_resources;
414: gmd_debug.log_initialize('UpdateResourcePub');
415:
416: /* Set the return status to success initially */
417: x_return_status := FND_API.G_RET_STS_SUCCESS;
418:

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

487: ,p_encoded => FND_API.g_false
488: ,p_data => x_message_list);
489:
490: IF x_message_count = 0 THEN
491: gmd_debug.put_line('Resource was Updated successfullly');
492: END IF;
493:
494: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
495:

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

490: IF x_message_count = 0 THEN
491: gmd_debug.put_line('Resource was Updated successfullly');
492: END IF;
493:
494: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
495:
496: EXCEPTION
497: WHEN resource_update_failure OR invalid_version THEN
498: ROLLBACK TO SAVEPOINT update_resources;

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

495:
496: EXCEPTION
497: WHEN resource_update_failure OR invalid_version THEN
498: ROLLBACK TO SAVEPOINT update_resources;
499: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
500: fnd_msg_pub.count_and_get (
501: p_count => x_message_count
502: ,p_encoded => FND_API.g_false
503: ,p_data => x_message_list);

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

503: ,p_data => x_message_list);
504: x_return_status := FND_API.G_RET_STS_ERROR;
505: WHEN OTHERS THEN
506: ROLLBACK TO SAVEPOINT update_resources;
507: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
508: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
509: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
510: FND_MSG_PUB.ADD;
511: fnd_msg_pub.count_and_get (

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

551: resource_delete_failure EXCEPTION;
552: invalid_version EXCEPTION;
553: BEGIN
554: SAVEPOINT delete_resources;
555: gmd_debug.log_initialize('DeleteResourcePub');
556:
557: /* Set the return status to success initially */
558: x_return_status := FND_API.G_RET_STS_SUCCESS;
559:

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

576: CLOSE Cur_resources;
577:
578: IF (l_counter = 0 ) then
579: l_return_status := 'E';
580: GMD_DEBUG.PUT_LINE('Resource to be deleted Does Not Exist ');
581: FND_MSG_PUB.ADD;
582: RAISE resource_delete_failure;
583: ELSE
584: delete from cr_rsrc_mst_tl

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

594: ,p_encoded => FND_API.g_false
595: ,p_data => x_message_list);
596:
597: IF x_message_count = 0 THEN
598: gmd_debug.put_line('Resource was deleted successfully');
599: END IF;
600:
601: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
602:

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

597: IF x_message_count = 0 THEN
598: gmd_debug.put_line('Resource was deleted successfully');
599: END IF;
600:
601: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
602:
603: EXCEPTION
604: WHEN resource_delete_failure OR invalid_version THEN
605: ROLLBACK TO SAVEPOINT delete_resources;

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

602:
603: EXCEPTION
604: WHEN resource_delete_failure OR invalid_version THEN
605: ROLLBACK TO SAVEPOINT delete_resources;
606: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
607: fnd_msg_pub.count_and_get (
608: p_count => x_message_count
609: ,p_encoded => FND_API.g_false
610: ,p_data => x_message_list);

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

610: ,p_data => x_message_list);
611: x_return_status := FND_API.G_RET_STS_ERROR;
612: WHEN OTHERS THEN
613: ROLLBACK TO SAVEPOINT delete_resources;
614: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
615: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
616: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
617: FND_MSG_PUB.ADD;
618: fnd_msg_pub.count_and_get (