DBA Data[Home] [Help]

APPS.CTO_AUTO_PROCURE_PK dependencies on FND_CONCURRENT

Line 1267: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',Current_Error_Code);

1263: -- In the case of RETCODE = 1 it should complete the batch program with Warning
1264:
1265: IF RETCODE = 1 THEN
1266:
1267: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',Current_Error_Code);
1268:
1269: ELSE
1270:
1271: RETCODE := 0 ;

Line 1272: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',Current_Error_Code);

1268:
1269: ELSE
1270:
1271: RETCODE := 0 ;
1272: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',Current_Error_Code);
1273:
1274: END IF;
1275:
1276:

Line 1285: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);

1281: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'AUTO_CREATE_PUR_REQ_CR::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
1282: rollback to begin_line; --bug fix 3590305/3599860
1283: x_return_status := FND_API.G_RET_STS_ERROR;
1284: RETCODE := 2;
1285: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
1286:
1287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1288: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'AUTO_CREATE_PUR_REQ_CR::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
1289: rollback to begin_line; --bug fix 3590305/3599860

Line 1292: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);

1288: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'AUTO_CREATE_PUR_REQ_CR::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
1289: rollback to begin_line; --bug fix 3590305/3599860
1290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1291: RETCODE := 2;
1292: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
1293:
1294: WHEN OTHERS THEN
1295: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'AUTO_CREATE_PUR_REQ_CR::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
1296: rollback to begin_line; --bug fix 3590305/3599860

Line 1299: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);

1295: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'AUTO_CREATE_PUR_REQ_CR::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
1296: rollback to begin_line; --bug fix 3590305/3599860
1297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1298: RETCODE := 2;
1299: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
1300:
1301: END auto_create_pur_req_cr;
1302:
1303:

Line 4559: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',Current_Error_Code);

4555:
4556: if p_perform_rollup = 2 then
4557: oe_debug_pub.add('Perform Rollup parameter is set to NO.');
4558: RETCODE := 0 ;
4559: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',Current_Error_Code);
4560: return;
4561: end if;
4562:
4563: OPEN pprollup_cur FOR

Line 4782: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',Current_Error_Code);

4778: END IF;
4779:
4780:
4781: IF RETCODE = 1 THEN
4782: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',Current_Error_Code);
4783:
4784: ELSE
4785: RETCODE := 0 ;
4786: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',Current_Error_Code);

Line 4786: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',Current_Error_Code);

4782: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',Current_Error_Code);
4783:
4784: ELSE
4785: RETCODE := 0 ;
4786: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',Current_Error_Code);
4787:
4788: END IF;
4789:
4790: IF PG_DEBUG <> 0 THEN

Line 4809: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);

4805: (p_msg_count => x_msg_count
4806: ,p_msg_data => x_msg_data
4807: );
4808: RETCODE := 2 ;
4809: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
4810:
4811: when FND_API.G_EXC_ERROR then
4812: IF PG_DEBUG <> 0 THEN
4813: oe_debug_pub.add('Create_purchase_doc_batch::exp error::'||l_stmt_num||sqlerrm,1);

Line 4820: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);

4816: CTO_MSG_PUB.Count_And_Get
4817: (p_msg_count => x_msg_count
4818: ,p_msg_data => x_msg_data);
4819: RETCODE := 2 ;
4820: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
4821:
4822: when others then
4823: IF PG_DEBUG <> 0 THEN
4824: oe_debug_pub.add('Create_purchase_doc_batch::others::'||l_stmt_num||sqlerrm,1);

Line 4832: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);

4828: (p_msg_count => x_msg_count
4829: ,p_msg_data => x_msg_data
4830: );
4831: RETCODE := 2 ;
4832: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
4833:
4834: END Create_purchase_doc_batch;
4835:
4836: