APPS.HZ_IMP_LOAD_STAGE2 dependencies on FND_MSG_PUB

Line 543: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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||']=');
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 ;

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 656: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

652: COMMIT;
653:
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:

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;