DBA Data[Home] [Help]

APPS.ECE_POO_TRANSACTION dependencies on ECE_ATTACHMENT_DETAILS_S

Line 5198: SELECT ece_attachment_details_s.NEXTVAL INTO n_detail_fkey

5194: BEGIN
5195: xProgress := 'POOB-70-1620';
5196: ec_debug.pl(3,'xProgress: ',xProgress);
5197:
5198: SELECT ece_attachment_details_s.NEXTVAL INTO n_detail_fkey
5199: FROM DUAL;
5200: if ec_debug.G_debug_level = 3 then
5201: ec_debug.pl(3,'n_detail_fkey: ',n_detail_fkey);
5202: end if;

Line 5205: ec_debug.pl(0,'EC','ECE_GET_NEXT_SEQ_FAILED','PROGRESS_LEVEL',xProgress,'SEQ','ECE_ATTACHMENT_DETAILS_S');

5201: ec_debug.pl(3,'n_detail_fkey: ',n_detail_fkey);
5202: end if;
5203: EXCEPTION
5204: WHEN NO_DATA_FOUND THEN
5205: ec_debug.pl(0,'EC','ECE_GET_NEXT_SEQ_FAILED','PROGRESS_LEVEL',xProgress,'SEQ','ECE_ATTACHMENT_DETAILS_S');
5206: END;
5207:
5208: -- I have to execute the following few lines of code because, I have no way of knowing at this point
5209: -- whether to set the Continue Flag 'Y' or 'N' until I loop around to the top again. This is how I find