426: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
427: End if; -- validation error
428: End if; -- validate before inserting
429:
430: l_UserId := nvl(Fnd_Global.USER_ID, -1);
431: l_LoginId := Fnd_Global.LOGIN_ID;
432: l_RequestId := Fnd_Global.CONC_REQUEST_ID;
433: l_ProgramId := Fnd_Global.CONC_PROGRAM_ID;
434: l_ApplicationId := Fnd_Global.PROG_APPL_ID;
427: End if; -- validation error
428: End if; -- validate before inserting
429:
430: l_UserId := nvl(Fnd_Global.USER_ID, -1);
431: l_LoginId := Fnd_Global.LOGIN_ID;
432: l_RequestId := Fnd_Global.CONC_REQUEST_ID;
433: l_ProgramId := Fnd_Global.CONC_PROGRAM_ID;
434: l_ApplicationId := Fnd_Global.PROG_APPL_ID;
435: -- do not use decode because of implicit data type conversions
428: End if; -- validate before inserting
429:
430: l_UserId := nvl(Fnd_Global.USER_ID, -1);
431: l_LoginId := Fnd_Global.LOGIN_ID;
432: l_RequestId := Fnd_Global.CONC_REQUEST_ID;
433: l_ProgramId := Fnd_Global.CONC_PROGRAM_ID;
434: l_ApplicationId := Fnd_Global.PROG_APPL_ID;
435: -- do not use decode because of implicit data type conversions
436: If l_RequestId is null then
429:
430: l_UserId := nvl(Fnd_Global.USER_ID, -1);
431: l_LoginId := Fnd_Global.LOGIN_ID;
432: l_RequestId := Fnd_Global.CONC_REQUEST_ID;
433: l_ProgramId := Fnd_Global.CONC_PROGRAM_ID;
434: l_ApplicationId := Fnd_Global.PROG_APPL_ID;
435: -- do not use decode because of implicit data type conversions
436: If l_RequestId is null then
437: l_ProgramUpdate := null;
430: l_UserId := nvl(Fnd_Global.USER_ID, -1);
431: l_LoginId := Fnd_Global.LOGIN_ID;
432: l_RequestId := Fnd_Global.CONC_REQUEST_ID;
433: l_ProgramId := Fnd_Global.CONC_PROGRAM_ID;
434: l_ApplicationId := Fnd_Global.PROG_APPL_ID;
435: -- do not use decode because of implicit data type conversions
436: If l_RequestId is null then
437: l_ProgramUpdate := null;
438: Else
744: End If; -- validation
745:
746: -- update routing revision
747:
748: l_UserId := nvl(Fnd_Global.USER_ID, -1);
749: l_LoginId := Fnd_Global.LOGIN_ID;
750: l_RequestId := Fnd_Global.CONC_REQUEST_ID;
751: l_ProgramId := Fnd_Global.CONC_PROGRAM_ID;
752: l_ApplicationId := Fnd_Global.PROG_APPL_ID;
745:
746: -- update routing revision
747:
748: l_UserId := nvl(Fnd_Global.USER_ID, -1);
749: l_LoginId := Fnd_Global.LOGIN_ID;
750: l_RequestId := Fnd_Global.CONC_REQUEST_ID;
751: l_ProgramId := Fnd_Global.CONC_PROGRAM_ID;
752: l_ApplicationId := Fnd_Global.PROG_APPL_ID;
753: -- do not use decode because of implicit data type conversions
746: -- update routing revision
747:
748: l_UserId := nvl(Fnd_Global.USER_ID, -1);
749: l_LoginId := Fnd_Global.LOGIN_ID;
750: l_RequestId := Fnd_Global.CONC_REQUEST_ID;
751: l_ProgramId := Fnd_Global.CONC_PROGRAM_ID;
752: l_ApplicationId := Fnd_Global.PROG_APPL_ID;
753: -- do not use decode because of implicit data type conversions
754: If l_RequestId is null then
747:
748: l_UserId := nvl(Fnd_Global.USER_ID, -1);
749: l_LoginId := Fnd_Global.LOGIN_ID;
750: l_RequestId := Fnd_Global.CONC_REQUEST_ID;
751: l_ProgramId := Fnd_Global.CONC_PROGRAM_ID;
752: l_ApplicationId := Fnd_Global.PROG_APPL_ID;
753: -- do not use decode because of implicit data type conversions
754: If l_RequestId is null then
755: l_ProgramUpdate := null;
748: l_UserId := nvl(Fnd_Global.USER_ID, -1);
749: l_LoginId := Fnd_Global.LOGIN_ID;
750: l_RequestId := Fnd_Global.CONC_REQUEST_ID;
751: l_ProgramId := Fnd_Global.CONC_PROGRAM_ID;
752: l_ApplicationId := Fnd_Global.PROG_APPL_ID;
753: -- do not use decode because of implicit data type conversions
754: If l_RequestId is null then
755: l_ProgramUpdate := null;
756: Else