DBA Data[Home] [Help]

APPS.GMP_RESOURCE_DTL_PUB dependencies on FND_FILE

Line 73: fnd_file.put_line(fnd_file.log,'CreateResourceDtlPub');

69: g_return_status := FND_API.G_RET_STS_SUCCESS;
70:
71: SAVEPOINT create_resource_dtl;
72:
73: fnd_file.put_line(fnd_file.log,'CreateResourceDtlPub');
74:
75: /* Set the return status to success initially */
76: x_return_status := FND_API.G_RET_STS_SUCCESS;
77: l_resources_rec := p_resources;

Line 283: fnd_file.put_line(fnd_file.log,'Resource Detail was created successfully');

279: ,p_data => x_message_list);
280:
281: IF x_message_count = 0 THEN
282: -- x_return_status := 'S' ;
283: fnd_file.put_line(fnd_file.log,'Resource Detail was created successfully');
284: END IF;
285:
286: fnd_file.put_line(fnd_file.log,'Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
287: EXCEPTION

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

282: -- x_return_status := 'S' ;
283: fnd_file.put_line(fnd_file.log,'Resource Detail was created successfully');
284: END IF;
285:
286: fnd_file.put_line(fnd_file.log,'Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
287: EXCEPTION
288: WHEN resource_dtl_creation_failure OR invalid_version
289: OR instance_creation_failure THEN
290:

Line 666: fnd_file.put_line(fnd_file.log,'Qty Entered is < 0');

662:
663: WHEN CR_POSITIVE THEN
664: x_return_status := FND_API.G_RET_STS_ERROR;
665: FND_MESSAGE.SET_NAME('GMP','CR_POSITIVE');
666: fnd_file.put_line(fnd_file.log,'Qty Entered is < 0');
667: FND_MSG_PUB.ADD;
668: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
669:
670: WHEN MIN_MAX_CAPACITY_REQUIRED THEN

Line 985: fnd_file.put_line(fnd_file.log,'UpdateResourcePub');

981: g_return_status := FND_API.G_RET_STS_SUCCESS;
982: X_msg := '';
983:
984: SAVEPOINT update_resource_dtl;
985: fnd_file.put_line(fnd_file.log,'UpdateResourcePub');
986:
987: /* Set the return status to success initially */
988: x_return_status := FND_API.G_RET_STS_SUCCESS;
989:

Line 1103: fnd_file.put_line(fnd_file.log,'Resource was Updated successfullly');

1099: ,p_encoded => FND_API.g_false
1100: ,p_data => x_message_list);
1101:
1102: IF x_message_count = 0 THEN
1103: fnd_file.put_line(fnd_file.log,'Resource was Updated successfullly');
1104: END IF;
1105:
1106: fnd_file.put_line(fnd_file.log,'Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
1107:

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

1102: IF x_message_count = 0 THEN
1103: fnd_file.put_line(fnd_file.log,'Resource was Updated successfullly');
1104: END IF;
1105:
1106: fnd_file.put_line(fnd_file.log,'Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
1107:
1108: EXCEPTION
1109:
1110: WHEN resource_update_failure OR invalid_version THEN

Line 1112: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'API not complete');

1108: EXCEPTION
1109:
1110: WHEN resource_update_failure OR invalid_version THEN
1111: ROLLBACK TO SAVEPOINT update_resource_dtl;
1112: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'API not complete');
1113: fnd_msg_pub.count_and_get (
1114: p_count => x_message_count
1115: ,p_encoded => FND_API.g_false
1116: ,p_data => x_message_list);

Line 1127: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);

1123: FND_MSG_PUB.ADD;
1124: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
1125: WHEN OTHERS THEN
1126: ROLLBACK TO SAVEPOINT update_resource_dtl;
1127: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1128: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1129: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1130: FND_MSG_PUB.ADD;
1131: fnd_msg_pub.count_and_get (

Line 1310: fnd_file.put_line(fnd_file.log,'UpdateInstancePub');

1306: v_eff_start_date := NULL ;
1307: X_msg := '';
1308:
1309: SAVEPOINT update_instances;
1310: fnd_file.put_line(fnd_file.log,'UpdateInstancePub');
1311:
1312: /* Set the return status to success initially */
1313: x_return_status := FND_API.G_RET_STS_SUCCESS;
1314:

Line 1409: fnd_file.put_line(fnd_file.log,'Resource was Updated successfullly');

1405: ,p_encoded => FND_API.g_false
1406: ,p_data => x_message_list);
1407:
1408: IF x_message_count = 0 THEN
1409: fnd_file.put_line(fnd_file.log,'Resource was Updated successfullly');
1410: END IF;
1411:
1412: fnd_file.put_line(fnd_file.log,'Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
1413:

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

1408: IF x_message_count = 0 THEN
1409: fnd_file.put_line(fnd_file.log,'Resource was Updated successfullly');
1410: END IF;
1411:
1412: fnd_file.put_line(fnd_file.log,'Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
1413:
1414: EXCEPTION
1415: WHEN instance_update_failure OR invalid_version THEN
1416: ROLLBACK TO SAVEPOINT update_instances;

Line 1417: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'API not complete');

1413:
1414: EXCEPTION
1415: WHEN instance_update_failure OR invalid_version THEN
1416: ROLLBACK TO SAVEPOINT update_instances;
1417: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'API not complete');
1418: fnd_msg_pub.count_and_get (
1419: p_count => x_message_count
1420: ,p_encoded => FND_API.g_false
1421: ,p_data => x_message_list);

Line 1430: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);

1426: FND_MSG_PUB.ADD;
1427: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
1428: WHEN OTHERS THEN
1429: ROLLBACK TO SAVEPOINT update_instances;
1430: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1431: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1432: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1433: FND_MSG_PUB.ADD;
1434: fnd_msg_pub.count_and_get (

Line 1578: fnd_file.put_line(fnd_file.log,'DeleteResourcePub');

1574: v_resource_id := 0;
1575: l_return_status := FND_API.G_RET_STS_SUCCESS;
1576:
1577: SAVEPOINT delete_resources;
1578: fnd_file.put_line(fnd_file.log,'DeleteResourcePub');
1579:
1580: /* Set the return status to success initially */
1581: x_return_status := FND_API.G_RET_STS_SUCCESS;
1582:

Line 1640: fnd_file.put_line(fnd_file.log,'Resource was deleted successfully');

1636: ,p_encoded => FND_API.g_false
1637: ,p_data => x_message_list);
1638:
1639: IF x_message_count = 0 THEN
1640: fnd_file.put_line(fnd_file.log,'Resource was deleted successfully');
1641: END IF;
1642:
1643: fnd_file.put_line(fnd_file.log,'Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
1644:

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

1639: IF x_message_count = 0 THEN
1640: fnd_file.put_line(fnd_file.log,'Resource was deleted successfully');
1641: END IF;
1642:
1643: fnd_file.put_line(fnd_file.log,'Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
1644:
1645: EXCEPTION
1646: WHEN resource_delete_failure OR invalid_version THEN
1647: ROLLBACK TO SAVEPOINT delete_resources;

Line 1648: fnd_file.put_line(fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'API not complete');

1644:
1645: EXCEPTION
1646: WHEN resource_delete_failure OR invalid_version THEN
1647: ROLLBACK TO SAVEPOINT delete_resources;
1648: fnd_file.put_line(fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'API not complete');
1649: fnd_msg_pub.count_and_get (
1650: p_count => x_message_count
1651: ,p_encoded => FND_API.g_false
1652: ,p_data => x_message_list);

Line 1656: fnd_file.put_line(fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);

1652: ,p_data => x_message_list);
1653: x_return_status := FND_API.G_RET_STS_ERROR;
1654: WHEN OTHERS THEN
1655: ROLLBACK TO SAVEPOINT delete_resources;
1656: fnd_file.put_line(fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1657: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1658: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1659: FND_MSG_PUB.ADD;
1660: fnd_msg_pub.count_and_get (