DBA Data[Home] [Help]

APPS.GMP_CALENDAR_API dependencies on FND_FILE

Line 161: FND_FILE.PUT_LINE(FND_FILE.LOG,'Completed '||l_api_name ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));

157: X_msg := 'Calendar/Date ';
158: RAISE CALENDAR_REQUIRED;
159: END IF;
160:
161: FND_FILE.PUT_LINE(FND_FILE.LOG,'Completed '||l_api_name ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
162:
163: EXCEPTION
164: WHEN INVALID_DATA_PASSED OR invalid_version THEN
165:

Line 620: FND_FILE.PUT_LINE(FND_FILE.LOG,'Completed '||l_api_name ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));

616:
617: /* } */
618: END IF ;
619:
620: FND_FILE.PUT_LINE(FND_FILE.LOG,'Completed '||l_api_name ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
621:
622: EXCEPTION
623: WHEN CONTIG_PERIODS_FAILURE OR INVALID_VERSION THEN
624: x_return_status := FND_API.G_RET_STS_ERROR;

Line 743: FND_FILE.PUT_LINE(FND_FILE.LOG,'Date Passed is Out of Calendar Range '||X_msg);

739:
740: EXCEPTION
741: WHEN GMP_DATE_NOT_IN_CAL_RANGE THEN
742: x_return_status := FND_API.G_RET_STS_ERROR;
743: FND_FILE.PUT_LINE(FND_FILE.LOG,'Date Passed is Out of Calendar Range '||X_msg);
744: FND_MESSAGE.SET_NAME('GMP','GMP_DATE_NOT_IN_CAL_RANGE');
745: FND_MSG_PUB.ADD;
746:
747: WHEN ENTER_START_OR_END_DATE THEN

Line 749: FND_FILE.PUT_LINE(FND_FILE.LOG,'Enter Start Or End Date '||X_msg);

745: FND_MSG_PUB.ADD;
746:
747: WHEN ENTER_START_OR_END_DATE THEN
748: x_return_status := FND_API.G_RET_STS_ERROR;
749: FND_FILE.PUT_LINE(FND_FILE.LOG,'Enter Start Or End Date '||X_msg);
750: FND_MESSAGE.SET_NAME('GMP','GMP_ENTER_START_OR_END_DATE');
751: FND_MSG_PUB.ADD;
752:
753: WHEN PS_INVALID_CALENDAR THEN

Line 760: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Value '||X_field||'-'||X_value);

756: FND_MSG_PUB.ADD;
757:
758: WHEN INVALID_VALUE THEN
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Value '||X_field||'-'||X_value);
761: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
762: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
763: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
764: FND_MSG_PUB.ADD;

Line 883: FND_FILE.PUT_LINE(FND_FILE.LOG,'Completed '||l_api_name ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));

879: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
880: FND_MSG_PUB.ADD;
881: END IF;
882:
883: FND_FILE.PUT_LINE(FND_FILE.LOG,'Completed '||l_api_name ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
884:
885: EXCEPTION
886: WHEN check_all_dates_failure OR invalid_version THEN
887: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1007: FND_FILE.PUT_LINE(FND_FILE.LOG,'Completed '||l_api_name ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));

1003: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1004: FND_MSG_PUB.ADD;
1005: END IF;
1006:
1007: FND_FILE.PUT_LINE(FND_FILE.LOG,'Completed '||l_api_name ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
1008:
1009: EXCEPTION
1010: WHEN work_days_failure OR invalid_version THEN
1011: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1124: FND_FILE.PUT_LINE(FND_FILE.LOG,'Completed '||l_api_name ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));

1120: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1121: FND_MSG_PUB.ADD;
1122: END IF;
1123:
1124: FND_FILE.PUT_LINE(FND_FILE.LOG,'Completed '||l_api_name ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
1125:
1126: EXCEPTION
1127: WHEN INVALID_VERSION THEN
1128: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1475: FND_FILE.PUT_LINE(FND_FILE.LOG,'Completed '||l_api_name ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));

1471: X_msg := 'Calendar/Date ';
1472: RAISE CALENDAR_REQUIRED;
1473: END IF;
1474:
1475: FND_FILE.PUT_LINE(FND_FILE.LOG,'Completed '||l_api_name ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
1476:
1477: EXCEPTION
1478: WHEN INVALID_DATA_PASSED OR invalid_version THEN
1479:

Line 1495: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Value '||X_field||'-'||X_value);

1491: RETURN FALSE ;
1492:
1493: WHEN INVALID_VALUE THEN
1494: x_return_status := FND_API.G_RET_STS_ERROR;
1495: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Value '||X_field||'-'||X_value);
1496: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
1497: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
1498: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
1499: FND_MSG_PUB.ADD;

Line 1634: FND_FILE.PUT_LINE ( FND_FILE.LOG,'if not FND_API.compatible_api_call');

1630: IF NOT FND_API.compatible_api_call ( GMP_CALENDAR_API.m_api_version
1631: ,p_api_version
1632: ,'GET_NEAREST_WORKDAYTIME'
1633: ,GMP_CALENDAR_API.m_pkg_name) THEN
1634: FND_FILE.PUT_LINE ( FND_FILE.LOG,'if not FND_API.compatible_api_call');
1635: x_return_status := FND_API.G_RET_STS_ERROR;
1636: x_date := (sysdate - 9999 ) ;
1637: RAISE INVALID_VERSION;
1638: END IF;

Line 1664: FND_FILE.PUT_LINE ( FND_FILE.LOG,p_calendar_id);

1660:
1661:
1662:
1663:
1664: FND_FILE.PUT_LINE ( FND_FILE.LOG,p_calendar_id);
1665: FND_FILE.PUT_LINE ( FND_FILE.LOG,to_char(p_date,'dd/mm/yyyy hh24:mi:ss'));
1666:
1667: IF l_return_status = 'E' THEN
1668:

Line 1665: FND_FILE.PUT_LINE ( FND_FILE.LOG,to_char(p_date,'dd/mm/yyyy hh24:mi:ss'));

1661:
1662:
1663:
1664: FND_FILE.PUT_LINE ( FND_FILE.LOG,p_calendar_id);
1665: FND_FILE.PUT_LINE ( FND_FILE.LOG,to_char(p_date,'dd/mm/yyyy hh24:mi:ss'));
1666:
1667: IF l_return_status = 'E' THEN
1668:
1669: FND_FILE.PUT_LINE ( FND_FILE.LOG,'IF l_return_status = E');

Line 1669: FND_FILE.PUT_LINE ( FND_FILE.LOG,'IF l_return_status = E');

1665: FND_FILE.PUT_LINE ( FND_FILE.LOG,to_char(p_date,'dd/mm/yyyy hh24:mi:ss'));
1666:
1667: IF l_return_status = 'E' THEN
1668:
1669: FND_FILE.PUT_LINE ( FND_FILE.LOG,'IF l_return_status = E');
1670: x_return_status := FND_API.G_RET_STS_ERROR;
1671: x_date := (sysdate - 9999 ) ;
1672: RAISE INVALID_DATA_PASSED;
1673: ELSE

Line 1701: FND_FILE.PUT_LINE ( FND_FILE.LOG,'last else');

1697: END IF; /* IF l_return_status = 'E' */
1698: ELSE
1699:
1700:
1701: FND_FILE.PUT_LINE ( FND_FILE.LOG,'last else');
1702: x_return_status := FND_API.G_RET_STS_ERROR;
1703: x_date := (sysdate - 9999 ) ;
1704: X_msg := 'Calendar/Date ';
1705: RAISE CALENDAR_REQUIRED;

Line 1725: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Value '||X_field||'-'||X_value);

1721:
1722: WHEN INVALID_VALUE THEN
1723: x_return_status := FND_API.G_RET_STS_ERROR;
1724: x_date := (sysdate - 9999 ) ;
1725: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Value '||X_field||'-'||X_value);
1726: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
1727: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
1728: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
1729: FND_MSG_PUB.ADD;

Line 1744: FND_FILE.PUT_LINE( FND_FILE.LOG, pBUFF);

1740:
1741: PROCEDURE LOG_MESSAGE(pBUFF IN VARCHAR2) IS
1742: BEGIN
1743: IF fnd_global.conc_request_id > 0 THEN
1744: FND_FILE.PUT_LINE( FND_FILE.LOG, pBUFF);
1745: ELSE
1746: NULL;
1747: END IF;
1748: