175: , ViewSyntax
176: , SecViewName
177: );
178:
179: FND_MESSAGE.SET_NAME('OKE' , 'OKE_SEC_GEN_VIEW_SUCC');
180: FND_MESSAGE.SET_TOKEN('VIEW' , SecViewName);
181: Print_Text_Buffer( FND_FILE.LOG , FND_MESSAGE.GET , FALSE );
182:
183: IF ( X_Create_History_View ) THEN
176: , SecViewName
177: );
178:
179: FND_MESSAGE.SET_NAME('OKE' , 'OKE_SEC_GEN_VIEW_SUCC');
180: FND_MESSAGE.SET_TOKEN('VIEW' , SecViewName);
181: Print_Text_Buffer( FND_FILE.LOG , FND_MESSAGE.GET , FALSE );
182:
183: IF ( X_Create_History_View ) THEN
184:
177: );
178:
179: FND_MESSAGE.SET_NAME('OKE' , 'OKE_SEC_GEN_VIEW_SUCC');
180: FND_MESSAGE.SET_TOKEN('VIEW' , SecViewName);
181: Print_Text_Buffer( FND_FILE.LOG , FND_MESSAGE.GET , FALSE );
182:
183: IF ( X_Create_History_View ) THEN
184:
185: UnsecViewName := X_Object_Name || '_FULL_HV';
207: , ViewSyntax
208: , SecViewName
209: );
210:
211: FND_MESSAGE.SET_NAME('OKE' , 'OKE_SEC_GEN_VIEW_SUCC');
212: FND_MESSAGE.SET_TOKEN('VIEW' , SecViewName);
213: Print_Text_Buffer( FND_FILE.LOG , FND_MESSAGE.GET , FALSE );
214:
215: END IF;
208: , SecViewName
209: );
210:
211: FND_MESSAGE.SET_NAME('OKE' , 'OKE_SEC_GEN_VIEW_SUCC');
212: FND_MESSAGE.SET_TOKEN('VIEW' , SecViewName);
213: Print_Text_Buffer( FND_FILE.LOG , FND_MESSAGE.GET , FALSE );
214:
215: END IF;
216:
209: );
210:
211: FND_MESSAGE.SET_NAME('OKE' , 'OKE_SEC_GEN_VIEW_SUCC');
212: FND_MESSAGE.SET_TOKEN('VIEW' , SecViewName);
213: Print_Text_Buffer( FND_FILE.LOG , FND_MESSAGE.GET , FALSE );
214:
215: END IF;
216:
217: EXCEPTION
215: END IF;
216:
217: EXCEPTION
218: WHEN OTHERS THEN
219: FND_MESSAGE.SET_NAME('OKE' , 'OKE_SEC_GEN_VIEW_FAILED');
220: FND_MESSAGE.SET_TOKEN('VIEW' , SecViewName);
221: Print_Text_Buffer( FND_FILE.LOG , FND_MESSAGE.GET , FALSE );
222: Print_Text_Buffer( FND_FILE.LOG , sqlerrm , TRUE );
223: IF ( AD_DDL.ERROR_BUF IS NOT NULL ) THEN
216:
217: EXCEPTION
218: WHEN OTHERS THEN
219: FND_MESSAGE.SET_NAME('OKE' , 'OKE_SEC_GEN_VIEW_FAILED');
220: FND_MESSAGE.SET_TOKEN('VIEW' , SecViewName);
221: Print_Text_Buffer( FND_FILE.LOG , FND_MESSAGE.GET , FALSE );
222: Print_Text_Buffer( FND_FILE.LOG , sqlerrm , TRUE );
223: IF ( AD_DDL.ERROR_BUF IS NOT NULL ) THEN
224: X_Error_Buf := AD_DDL.Error_Buf;
217: EXCEPTION
218: WHEN OTHERS THEN
219: FND_MESSAGE.SET_NAME('OKE' , 'OKE_SEC_GEN_VIEW_FAILED');
220: FND_MESSAGE.SET_TOKEN('VIEW' , SecViewName);
221: Print_Text_Buffer( FND_FILE.LOG , FND_MESSAGE.GET , FALSE );
222: Print_Text_Buffer( FND_FILE.LOG , sqlerrm , TRUE );
223: IF ( AD_DDL.ERROR_BUF IS NOT NULL ) THEN
224: X_Error_Buf := AD_DDL.Error_Buf;
225: Print_Text_Buffer( FND_FILE.LOG , AD_DDL.Error_Buf , TRUE );