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 284: fnd_file.put_line(fnd_file.log,'Resource Detail was created successfully');

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

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

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

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

681:
682: WHEN CR_POSITIVE THEN
683: x_return_status := FND_API.G_RET_STS_ERROR;
684: FND_MESSAGE.SET_NAME('GMP','CR_POSITIVE');
685: fnd_file.put_line(fnd_file.log,'Qty Entered is < 0');
686: FND_MSG_PUB.ADD;
687: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
688:
689: WHEN MIN_MAX_CAPACITY_REQUIRED THEN

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

1003: g_return_status := FND_API.G_RET_STS_SUCCESS;
1004: X_msg := '';
1005:
1006: SAVEPOINT update_resource_dtl;
1007: fnd_file.put_line(fnd_file.log,'UpdateResourcePub');
1008:
1009: /* Set the return status to success initially */
1010: x_return_status := FND_API.G_RET_STS_SUCCESS;
1011:

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

1122: ,p_encoded => FND_API.g_false
1123: ,p_data => x_message_list);
1124:
1125: IF x_message_count = 0 THEN
1126: fnd_file.put_line(fnd_file.log,'Resource was Updated successfullly');
1127: END IF;
1128:
1129: fnd_file.put_line(fnd_file.log,'Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
1130:

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

1125: IF x_message_count = 0 THEN
1126: fnd_file.put_line(fnd_file.log,'Resource was Updated successfullly');
1127: END IF;
1128:
1129: fnd_file.put_line(fnd_file.log,'Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
1130:
1131: EXCEPTION
1132:
1133: WHEN resource_update_failure OR invalid_version THEN

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

1131: EXCEPTION
1132:
1133: WHEN resource_update_failure OR invalid_version THEN
1134: ROLLBACK TO SAVEPOINT update_resource_dtl;
1135: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'API not complete');
1136: fnd_msg_pub.count_and_get (
1137: p_count => x_message_count
1138: ,p_encoded => FND_API.g_false
1139: ,p_data => x_message_list);

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

1146: FND_MSG_PUB.ADD;
1147: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
1148: WHEN OTHERS THEN
1149: ROLLBACK TO SAVEPOINT update_resource_dtl;
1150: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1151: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1152: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1153: FND_MSG_PUB.ADD;
1154: fnd_msg_pub.count_and_get (

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

1333: v_eff_start_date := NULL ;
1334: X_msg := '';
1335:
1336: SAVEPOINT update_instances;
1337: fnd_file.put_line(fnd_file.log,'UpdateInstancePub');
1338:
1339: /* Set the return status to success initially */
1340: x_return_status := FND_API.G_RET_STS_SUCCESS;
1341:

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

1432: ,p_encoded => FND_API.g_false
1433: ,p_data => x_message_list);
1434:
1435: IF x_message_count = 0 THEN
1436: fnd_file.put_line(fnd_file.log,'Resource was Updated successfullly');
1437: END IF;
1438:
1439: fnd_file.put_line(fnd_file.log,'Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
1440:

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

1435: IF x_message_count = 0 THEN
1436: fnd_file.put_line(fnd_file.log,'Resource was Updated successfullly');
1437: END IF;
1438:
1439: fnd_file.put_line(fnd_file.log,'Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
1440:
1441: EXCEPTION
1442: WHEN instance_update_failure OR invalid_version THEN
1443: ROLLBACK TO SAVEPOINT update_instances;

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

1440:
1441: EXCEPTION
1442: WHEN instance_update_failure OR invalid_version THEN
1443: ROLLBACK TO SAVEPOINT update_instances;
1444: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'API not complete');
1445: fnd_msg_pub.count_and_get (
1446: p_count => x_message_count
1447: ,p_encoded => FND_API.g_false
1448: ,p_data => x_message_list);

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

1453: FND_MSG_PUB.ADD;
1454: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
1455: WHEN OTHERS THEN
1456: ROLLBACK TO SAVEPOINT update_instances;
1457: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1458: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1459: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1460: FND_MSG_PUB.ADD;
1461: fnd_msg_pub.count_and_get (

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

1601: v_resource_id := 0;
1602: l_return_status := FND_API.G_RET_STS_SUCCESS;
1603:
1604: SAVEPOINT delete_resources;
1605: fnd_file.put_line(fnd_file.log,'DeleteResourcePub');
1606:
1607: /* Set the return status to success initially */
1608: x_return_status := FND_API.G_RET_STS_SUCCESS;
1609:

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

1663: ,p_encoded => FND_API.g_false
1664: ,p_data => x_message_list);
1665:
1666: IF x_message_count = 0 THEN
1667: fnd_file.put_line(fnd_file.log,'Resource was deleted successfully');
1668: END IF;
1669:
1670: fnd_file.put_line(fnd_file.log,'Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
1671:

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

1666: IF x_message_count = 0 THEN
1667: fnd_file.put_line(fnd_file.log,'Resource was deleted successfully');
1668: END IF;
1669:
1670: fnd_file.put_line(fnd_file.log,'Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
1671:
1672: EXCEPTION
1673: WHEN resource_delete_failure OR invalid_version THEN
1674: ROLLBACK TO SAVEPOINT delete_resources;

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

1671:
1672: EXCEPTION
1673: WHEN resource_delete_failure OR invalid_version THEN
1674: ROLLBACK TO SAVEPOINT delete_resources;
1675: fnd_file.put_line(fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'API not complete');
1676: fnd_msg_pub.count_and_get (
1677: p_count => x_message_count
1678: ,p_encoded => FND_API.g_false
1679: ,p_data => x_message_list);

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

1679: ,p_data => x_message_list);
1680: x_return_status := FND_API.G_RET_STS_ERROR;
1681: WHEN OTHERS THEN
1682: ROLLBACK TO SAVEPOINT delete_resources;
1683: fnd_file.put_line(fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1684: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1685: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1686: FND_MSG_PUB.ADD;
1687: fnd_msg_pub.count_and_get (