eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_ATO_JOBS_PRIV dependencies on FND_API

Line 146: P_INIT_MSG_LIST VARCHAR2(10) := FND_API.G_FALSE;

142: L_API_NAME CONSTANT VARCHAR2(30) := 'CREATE_JOBS';
143:
144: x_msg_count NUMBER;
145: x_msg_data VARCHAR2(1000);
146: P_INIT_MSG_LIST VARCHAR2(10) := FND_API.G_FALSE;
147: P_COMMIT VARCHAR2(10) := FND_API.G_FALSE;
148:
149: l_all_records_success NUMBER := -1;
150: batch_mode_flag boolean := false;

Line 147: P_COMMIT VARCHAR2(10) := FND_API.G_FALSE;

143:
144: x_msg_count NUMBER;
145: x_msg_data VARCHAR2(1000);
146: P_INIT_MSG_LIST VARCHAR2(10) := FND_API.G_FALSE;
147: P_COMMIT VARCHAR2(10) := FND_API.G_FALSE;
148:
149: l_all_records_success NUMBER := -1;
150: batch_mode_flag boolean := false;
151:

Line 167: IF FND_API.to_Boolean( p_init_msg_list ) THEN

163: SAVEPOINT WIP_ATO_JOBS_PRIV;
164:
165:
166: -- Initialize message list if p_init_msg_list is set to TRUE.
167: IF FND_API.to_Boolean( p_init_msg_list ) THEN
168: FND_MSG_PUB.initialize;
169: END IF;
170:
171: -- Initialize API return status to success

Line 172: x_return_status := FND_API.G_RET_STS_SUCCESS;

168: FND_MSG_PUB.initialize;
169: END IF;
170:
171: -- Initialize API return status to success
172: x_return_status := FND_API.G_RET_STS_SUCCESS;
173:
174: select userenv('SESSIONID') into l_audsid from dual;
175: -- fnd_file.log('AUDSID of current session: ' || l_audsid);
176:

Line 226: if(x_return_status <> fnd_api.g_ret_sts_success) then

222: wip_logger.entryPoint(p_procName => 'WIP_ATO_JOBS_PRIV.CREATE_JOBS',
223: p_params => l_params,
224: x_returnStatus => x_return_status);
225:
226: if(x_return_status <> fnd_api.g_ret_sts_success) then
227: raise fnd_api.g_exc_unexpected_error;
228: end if;
229: end if;
230:

Line 227: raise fnd_api.g_exc_unexpected_error;

223: p_params => l_params,
224: x_returnStatus => x_return_status);
225:
226: if(x_return_status <> fnd_api.g_ret_sts_success) then
227: raise fnd_api.g_exc_unexpected_error;
228: end if;
229: end if;
230:
231:

Line 257: IF NOT FND_API.Compatible_API_Call ( l_api_version,

253: fnd_file.new_line(FND_FIlE.LOG,3); --put new line as separators
254: end if;
255:
256: -- Standard call to check for call compatibility.
257: IF NOT FND_API.Compatible_API_Call ( l_api_version,
258: p_api_version,
259: l_api_name,
260: G_PKG_NAME)
261: THEN

Line 262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

258: p_api_version,
259: l_api_name,
260: G_PKG_NAME)
261: THEN
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: END IF;
264:
265:
266: wip_logger.log('************* WIP Autocreate Final Assembly Orders *************', l_returnStatus);

Line 432: WHEN FND_API.G_EXC_ERROR THEN

428:
429: RETCODE := x_return_status;
430:
431: EXCEPTION
432: WHEN FND_API.G_EXC_ERROR THEN
433: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;
434: x_return_status := FND_API.G_RET_STS_ERROR ;
435: GOTO END_program;
436:

Line 434: x_return_status := FND_API.G_RET_STS_ERROR ;

430:
431: EXCEPTION
432: WHEN FND_API.G_EXC_ERROR THEN
433: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;
434: x_return_status := FND_API.G_RET_STS_ERROR ;
435: GOTO END_program;
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;

Line 437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

433: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;
434: x_return_status := FND_API.G_RET_STS_ERROR ;
435: GOTO END_program;
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
440: GOTO END_program;
441:

Line 439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

435: GOTO END_program;
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
440: GOTO END_program;
441:
442: WHEN OTHERS THEN
443: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;

Line 444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

440: GOTO END_program;
441:
442: WHEN OTHERS THEN
443: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
445: GOTO END_program;
446:
447: <>
448: RETCODE := 1;

Line 614: retCode := fnd_api.g_ret_sts_success;

610: l_line_count number := 0;
611:
612: BEGIN
613:
614: retCode := fnd_api.g_ret_sts_success;
615:
616: IF (DEBUG_FLAG) THEN
617: DEBUG_FLAG := TRUE;
618: ELSE

Line 651: if(l_returnStatus <> fnd_api.g_ret_sts_success) then

647: wip_logger.entryPoint(p_procName => 'WIP_ATO_JOBS_PRIV.LOAD_ORDERS',
648: p_params => l_params,
649: x_returnStatus => l_returnStatus);
650:
651: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
652: raise fnd_api.g_exc_unexpected_error;
653: end if;
654: end if;
655:

Line 652: raise fnd_api.g_exc_unexpected_error;

648: p_params => l_params,
649: x_returnStatus => l_returnStatus);
650:
651: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
652: raise fnd_api.g_exc_unexpected_error;
653: end if;
654: end if;
655:
656: wip_logger.log('Inside Load_Orders.....', l_returnStatus);

Line 822: IF (retCode <> fnd_api.g_ret_sts_success) THEN

818: x_errorMsg => errBuf);
819:
820: fnd_file.put_line(which => fnd_file.log, buff => 'Returned from wip_massload_pub.massLoadJobs:');
821:
822: IF (retCode <> fnd_api.g_ret_sts_success) THEN
823: fnd_file.put_line(which => fnd_file.log, buff => 'Failed in wip_massload_pub.massLoadJobs.');
824:
825: if (l_logLevel <= wip_constants.full_logging) then
826: wip_logger.log( 'Dbg:Failed in wip_massload_pub.massLoadJobs', l_returnStatus);

Line 1041: raise FND_API.G_EXC_ERROR ;

1037: /* report returns with error or waning */
1038: if (report_retcode <> -1 ) then
1039: FND_FILE.PUT_LINE(FND_FILE.LOG,'Report has errored or has a warning');
1040: errbuf := fnd_message.get;
1041: raise FND_API.G_EXC_ERROR ;
1042: else
1043: if (l_logLevel <= wip_constants.full_logging) then
1044: wip_logger.log('Report: Assemble To Order Mass Load Report ran successfully ', l_returnStatus);
1045: wip_logger.log('Check Output and Log file for Conc Request Number:'|| report_status, l_returnStatus);

Line 1154: if(x_return_status <> fnd_api.g_ret_sts_success) then

1150: wip_logger.entryPoint(p_procName => 'WIP_ATO_JOBS_PRIV.DELETE_INTERFACE_ORDERS',
1151: p_params => l_params,
1152: x_returnStatus => x_return_status);
1153:
1154: if(x_return_status <> fnd_api.g_ret_sts_success) then
1155: raise fnd_api.g_exc_unexpected_error;
1156: end if;
1157: end if;
1158:

Line 1155: raise fnd_api.g_exc_unexpected_error;

1151: p_params => l_params,
1152: x_returnStatus => x_return_status);
1153:
1154: if(x_return_status <> fnd_api.g_ret_sts_success) then
1155: raise fnd_api.g_exc_unexpected_error;
1156: end if;
1157: end if;
1158:
1159: