DBA Data[Home] [Help]

APPS.ECE_POO_TRANSACTION dependencies on ECE_ATTACHMENT_DETAILS_S

Line 5165: SELECT ece_attachment_details_s.NEXTVAL INTO n_detail_fkey

5161: BEGIN
5162: xProgress := 'POOB-70-1620';
5163: ec_debug.pl(3,'xProgress: ',xProgress);
5164:
5165: SELECT ece_attachment_details_s.NEXTVAL INTO n_detail_fkey
5166: FROM DUAL;
5167: if ec_debug.G_debug_level = 3 then
5168: ec_debug.pl(3,'n_detail_fkey: ',n_detail_fkey);
5169: end if;

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

5168: ec_debug.pl(3,'n_detail_fkey: ',n_detail_fkey);
5169: end if;
5170: EXCEPTION
5171: WHEN NO_DATA_FOUND THEN
5172: ec_debug.pl(0,'EC','ECE_GET_NEXT_SEQ_FAILED','PROGRESS_LEVEL',xProgress,'SEQ','ECE_ATTACHMENT_DETAILS_S');
5173: END;
5174:
5175: -- I have to execute the following few lines of code because, I have no way of knowing at this point
5176: -- whether to set the Continue Flag 'Y' or 'N' until I loop around to the top again. This is how I find