DBA Data[Home] [Help]

APPS.WIP_ATO_JOBS_PRIV dependencies on FND_API

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

86: L_API_NAME CONSTANT VARCHAR2(30) := 'CREATE_JOBS';
87:
88: x_msg_count NUMBER;
89: x_msg_data VARCHAR2(1000);
90: P_INIT_MSG_LIST VARCHAR2(10) := FND_API.G_FALSE;
91: P_COMMIT VARCHAR2(10) := FND_API.G_FALSE;
92:
93: l_all_records_success NUMBER := -1;
94: batch_mode_flag boolean := false;

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

87:
88: x_msg_count NUMBER;
89: x_msg_data VARCHAR2(1000);
90: P_INIT_MSG_LIST VARCHAR2(10) := FND_API.G_FALSE;
91: P_COMMIT VARCHAR2(10) := FND_API.G_FALSE;
92:
93: l_all_records_success NUMBER := -1;
94: batch_mode_flag boolean := false;
95:

Line 111: IF FND_API.to_Boolean( p_init_msg_list ) THEN

107: SAVEPOINT WIP_ATO_JOBS_PRIV;
108:
109:
110: -- Initialize message list if p_init_msg_list is set to TRUE.
111: IF FND_API.to_Boolean( p_init_msg_list ) THEN
112: FND_MSG_PUB.initialize;
113: END IF;
114:
115: -- Initialize API return status to success

Line 116: x_return_status := FND_API.G_RET_STS_SUCCESS;

112: FND_MSG_PUB.initialize;
113: END IF;
114:
115: -- Initialize API return status to success
116: x_return_status := FND_API.G_RET_STS_SUCCESS;
117:
118: select userenv('SESSIONID') into l_audsid from dual;
119: -- fnd_file.log('AUDSID of current session: ' || l_audsid);
120:

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

157: wip_logger.entryPoint(p_procName => 'WIP_ATO_JOBS_PRIV.CREATE_JOBS',
158: p_params => l_params,
159: x_returnStatus => x_return_status);
160:
161: if(x_return_status <> fnd_api.g_ret_sts_success) then
162: raise fnd_api.g_exc_unexpected_error;
163: end if;
164: end if;
165:

Line 162: raise fnd_api.g_exc_unexpected_error;

158: p_params => l_params,
159: x_returnStatus => x_return_status);
160:
161: if(x_return_status <> fnd_api.g_ret_sts_success) then
162: raise fnd_api.g_exc_unexpected_error;
163: end if;
164: end if;
165:
166:

Line 192: IF NOT FND_API.Compatible_API_Call ( l_api_version,

188: fnd_file.new_line(FND_FIlE.LOG,3); --put new line as separators
189: end if;
190:
191: -- Standard call to check for call compatibility.
192: IF NOT FND_API.Compatible_API_Call ( l_api_version,
193: p_api_version,
194: l_api_name,
195: G_PKG_NAME)
196: THEN

Line 197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

193: p_api_version,
194: l_api_name,
195: G_PKG_NAME)
196: THEN
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: END IF;
199:
200:
201: wip_logger.log('************* WIP Autocreate Final Assembly Orders *************', l_returnStatus);

Line 353: WHEN FND_API.G_EXC_ERROR THEN

349:
350: RETCODE := x_return_status;
351:
352: EXCEPTION
353: WHEN FND_API.G_EXC_ERROR THEN
354: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;
355: x_return_status := FND_API.G_RET_STS_ERROR ;
356: GOTO END_program;
357:

Line 355: x_return_status := FND_API.G_RET_STS_ERROR ;

351:
352: EXCEPTION
353: WHEN FND_API.G_EXC_ERROR THEN
354: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;
355: x_return_status := FND_API.G_RET_STS_ERROR ;
356: GOTO END_program;
357:
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;

Line 358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

354: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;
355: x_return_status := FND_API.G_RET_STS_ERROR ;
356: GOTO END_program;
357:
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
361: GOTO END_program;
362:

Line 360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

356: GOTO END_program;
357:
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
361: GOTO END_program;
362:
363: WHEN OTHERS THEN
364: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;

Line 365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

361: GOTO END_program;
362:
363: WHEN OTHERS THEN
364: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
366: GOTO END_program;
367:
368: <>
369: RETCODE := 1;

Line 528: retCode := fnd_api.g_ret_sts_success;

524: report_retcode number;
525:
526: BEGIN
527:
528: retCode := fnd_api.g_ret_sts_success;
529:
530: IF (DEBUG_FLAG) THEN
531: DEBUG_FLAG := TRUE;
532: ELSE

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

561: wip_logger.entryPoint(p_procName => 'WIP_ATO_JOBS_PRIV.LOAD_ORDERS',
562: p_params => l_params,
563: x_returnStatus => l_returnStatus);
564:
565: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
566: raise fnd_api.g_exc_unexpected_error;
567: end if;
568: end if;
569:

Line 566: raise fnd_api.g_exc_unexpected_error;

562: p_params => l_params,
563: x_returnStatus => l_returnStatus);
564:
565: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
566: raise fnd_api.g_exc_unexpected_error;
567: end if;
568: end if;
569:
570: wip_logger.log('Inside Load_Orders.....', l_returnStatus);

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

705: x_errorMsg => errBuf);
706:
707: fnd_file.put_line(which => fnd_file.log, buff => 'Returned from wip_massload_pub.massLoadJobs:');
708:
709: IF (retCode <> fnd_api.g_ret_sts_success) THEN
710: fnd_file.put_line(which => fnd_file.log, buff => 'Failed in wip_massload_pub.massLoadJobs.');
711:
712: if (l_logLevel <= wip_constants.full_logging) then
713: wip_logger.log( 'Dbg:Failed in wip_massload_pub.massLoadJobs', l_returnStatus);

Line 890: raise FND_API.G_EXC_ERROR ;

886: /* report returns with error or waning */
887: if (report_retcode <> -1 ) then
888: FND_FILE.PUT_LINE(FND_FILE.LOG,'Report has errored or has a warning');
889: errbuf := fnd_message.get;
890: raise FND_API.G_EXC_ERROR ;
891: else
892: if (l_logLevel <= wip_constants.full_logging) then
893: wip_logger.log('Report: Assemble To Order Mass Load Report ran successfully ', l_returnStatus);
894: wip_logger.log('Check Output and Log file for Conc Request Number:'|| report_status, l_returnStatus);

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

999: wip_logger.entryPoint(p_procName => 'WIP_ATO_JOBS_PRIV.DELETE_INTERFACE_ORDERS',
1000: p_params => l_params,
1001: x_returnStatus => x_return_status);
1002:
1003: if(x_return_status <> fnd_api.g_ret_sts_success) then
1004: raise fnd_api.g_exc_unexpected_error;
1005: end if;
1006: end if;
1007:

Line 1004: raise fnd_api.g_exc_unexpected_error;

1000: p_params => l_params,
1001: x_returnStatus => x_return_status);
1002:
1003: if(x_return_status <> fnd_api.g_ret_sts_success) then
1004: raise fnd_api.g_exc_unexpected_error;
1005: end if;
1006: end if;
1007:
1008: