APPS.HZ_IMP_LOAD_STAGE2 dependencies on FND_API

Line 146: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

142: -- l_rerun_flag VARCHAR2(1) := 'N';
143: l_start_error_id NUMBER;
144: l_current_error_id NUMBER;
145: l_real_error_count NUMBER;
146: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
147: l_msg_count NUMBER;
148: l_msg_data VARCHAR2(2000);
149: l_what_if_sg_data_exists VARCHAR2(1) ;
150: l_batch_run_before VARCHAR2(1) ;

Line 540: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

536: x_msg_count => l_msg_count,
537: x_msg_data => l_msg_data
538: );
539:
540: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
541: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DQM return status ERROR');
542: FND_FILE.PUT_LINE(FND_FILE.LOG, SubStr('l_msg_data = '||l_msg_data,1,255));
543: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
544: FND_FILE.PUT_LINE(FND_FILE.LOG, 'message[' ||I||']=');

Line 545: FND_FILE.PUT_LINE(FND_FILE.LOG, Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,255));

541: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DQM return status ERROR');
542: FND_FILE.PUT_LINE(FND_FILE.LOG, SubStr('l_msg_data = '||l_msg_data,1,255));
543: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
544: FND_FILE.PUT_LINE(FND_FILE.LOG, 'message[' ||I||']=');
545: FND_FILE.PUT_LINE(FND_FILE.LOG, Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,255));
546: END LOOP;
547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
548: END IF;
549: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DQM complete successfully ');

Line 547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

543: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
544: FND_FILE.PUT_LINE(FND_FILE.LOG, 'message[' ||I||']=');
545: FND_FILE.PUT_LINE(FND_FILE.LOG, Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,255));
546: END LOOP;
547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
548: END IF;
549: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DQM complete successfully ');
550:
551: END IF;

Line 570: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

566: X_MSG_COUNT => l_msg_count,
567: X_MSG_DATA => l_msg_data
568: );
569:
570: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
572: END IF;
573:
574: FND_FILE.PUT_LINE(FND_FILE.LOG, 'LOAD_PARTIES successfully ');

Line 571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

567: X_MSG_DATA => l_msg_data
568: );
569:
570: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
572: END IF;
573:
574: FND_FILE.PUT_LINE(FND_FILE.LOG, 'LOAD_PARTIES successfully ');
575:

Line 658: FND_FILE.PUT_LINE(FND_FILE.LOG, Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,255));

654: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stage 2 worker: SQLERRM: ' || SQLERRM);
655: FND_FILE.PUT_LINE(FND_FILE.LOG, SubStr('l_msg_data = '||l_msg_data,1,255));
656: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
657: FND_FILE.PUT_LINE(FND_FILE.LOG, 'message[' ||I||']=');
658: FND_FILE.PUT_LINE(FND_FILE.LOG, Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,255));
659: END LOOP;
660:
661:
662: END WORKER_PROCESS;