eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OKL_SETUPFORMULAE_PVT dependencies on OKL_API

Line 30: IF p_fmav_rec.version = OKL_API.G_MISS_CHAR THEN

26:
27: l_check VARCHAR2(1) := '?';
28: l_row_not_found BOOLEAN := FALSE;
29: BEGIN
30: IF p_fmav_rec.version = OKL_API.G_MISS_CHAR THEN
31: x_new_version := G_INIT_VERSION;
32: ELSE
33: -- Check for future versions of the same formula
34: OPEN okl_fma_laterversionsexist_csr (p_fmav_rec.name,

Line 49: x_return_status := OKL_API.G_RET_STS_SUCCESS;

45: + G_VERSION_MINOR_INCREMENT, G_VERSION_FORMAT);
46: END IF;
47: END IF;
48:
49: x_return_status := OKL_API.G_RET_STS_SUCCESS;
50: EXCEPTION
51: WHEN OTHERS THEN
52: -- store SQL error message on message stack
53: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 53: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

49: x_return_status := OKL_API.G_RET_STS_SUCCESS;
50: EXCEPTION
51: WHEN OTHERS THEN
52: -- store SQL error message on message stack
53: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
54: p_msg_name => G_UNEXPECTED_ERROR,
55: p_token1 => G_SQLCODE_TOKEN,
56: p_token1_value => sqlcode,
57: p_token2 => G_SQLERRM_TOKEN,

Line 59: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

55: p_token1 => G_SQLCODE_TOKEN,
56: p_token1_value => sqlcode,
57: p_token2 => G_SQLERRM_TOKEN,
58: p_token2_value => sqlerrm);
59: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
60:
61: IF (okl_fma_laterversionsexist_csr%ISOPEN) THEN
62: CLOSE okl_fma_laterversionsexist_csr;
63: END IF;

Line 87: NVL(DESCRIPTION,OKL_API.G_MISS_CHAR) DESCRIPTION,

83: CGR_ID,
84: FYP_CODE,
85: NAME,
86: FORMULA_STRING,
87: NVL(DESCRIPTION,OKL_API.G_MISS_CHAR) DESCRIPTION,
88: VERSION,
89: START_DATE,
90: NVL(END_DATE,OKL_API.G_MISS_DATE) END_DATE,
91: NVL(ATTRIBUTE_CATEGORY, OKL_API.G_MISS_CHAR) ATTRIBUTE_CATEGORY,

Line 90: NVL(END_DATE,OKL_API.G_MISS_DATE) END_DATE,

86: FORMULA_STRING,
87: NVL(DESCRIPTION,OKL_API.G_MISS_CHAR) DESCRIPTION,
88: VERSION,
89: START_DATE,
90: NVL(END_DATE,OKL_API.G_MISS_DATE) END_DATE,
91: NVL(ATTRIBUTE_CATEGORY, OKL_API.G_MISS_CHAR) ATTRIBUTE_CATEGORY,
92: NVL(ATTRIBUTE1, OKL_API.G_MISS_CHAR) ATTRIBUTE1,
93: NVL(ATTRIBUTE2, OKL_API.G_MISS_CHAR) ATTRIBUTE2,
94: NVL(ATTRIBUTE3, OKL_API.G_MISS_CHAR) ATTRIBUTE3,

Line 91: NVL(ATTRIBUTE_CATEGORY, OKL_API.G_MISS_CHAR) ATTRIBUTE_CATEGORY,

87: NVL(DESCRIPTION,OKL_API.G_MISS_CHAR) DESCRIPTION,
88: VERSION,
89: START_DATE,
90: NVL(END_DATE,OKL_API.G_MISS_DATE) END_DATE,
91: NVL(ATTRIBUTE_CATEGORY, OKL_API.G_MISS_CHAR) ATTRIBUTE_CATEGORY,
92: NVL(ATTRIBUTE1, OKL_API.G_MISS_CHAR) ATTRIBUTE1,
93: NVL(ATTRIBUTE2, OKL_API.G_MISS_CHAR) ATTRIBUTE2,
94: NVL(ATTRIBUTE3, OKL_API.G_MISS_CHAR) ATTRIBUTE3,
95: NVL(ATTRIBUTE4, OKL_API.G_MISS_CHAR) ATTRIBUTE4,

Line 92: NVL(ATTRIBUTE1, OKL_API.G_MISS_CHAR) ATTRIBUTE1,

88: VERSION,
89: START_DATE,
90: NVL(END_DATE,OKL_API.G_MISS_DATE) END_DATE,
91: NVL(ATTRIBUTE_CATEGORY, OKL_API.G_MISS_CHAR) ATTRIBUTE_CATEGORY,
92: NVL(ATTRIBUTE1, OKL_API.G_MISS_CHAR) ATTRIBUTE1,
93: NVL(ATTRIBUTE2, OKL_API.G_MISS_CHAR) ATTRIBUTE2,
94: NVL(ATTRIBUTE3, OKL_API.G_MISS_CHAR) ATTRIBUTE3,
95: NVL(ATTRIBUTE4, OKL_API.G_MISS_CHAR) ATTRIBUTE4,
96: NVL(ATTRIBUTE5, OKL_API.G_MISS_CHAR) ATTRIBUTE5,

Line 93: NVL(ATTRIBUTE2, OKL_API.G_MISS_CHAR) ATTRIBUTE2,

89: START_DATE,
90: NVL(END_DATE,OKL_API.G_MISS_DATE) END_DATE,
91: NVL(ATTRIBUTE_CATEGORY, OKL_API.G_MISS_CHAR) ATTRIBUTE_CATEGORY,
92: NVL(ATTRIBUTE1, OKL_API.G_MISS_CHAR) ATTRIBUTE1,
93: NVL(ATTRIBUTE2, OKL_API.G_MISS_CHAR) ATTRIBUTE2,
94: NVL(ATTRIBUTE3, OKL_API.G_MISS_CHAR) ATTRIBUTE3,
95: NVL(ATTRIBUTE4, OKL_API.G_MISS_CHAR) ATTRIBUTE4,
96: NVL(ATTRIBUTE5, OKL_API.G_MISS_CHAR) ATTRIBUTE5,
97: NVL(ATTRIBUTE6, OKL_API.G_MISS_CHAR) ATTRIBUTE6,

Line 94: NVL(ATTRIBUTE3, OKL_API.G_MISS_CHAR) ATTRIBUTE3,

90: NVL(END_DATE,OKL_API.G_MISS_DATE) END_DATE,
91: NVL(ATTRIBUTE_CATEGORY, OKL_API.G_MISS_CHAR) ATTRIBUTE_CATEGORY,
92: NVL(ATTRIBUTE1, OKL_API.G_MISS_CHAR) ATTRIBUTE1,
93: NVL(ATTRIBUTE2, OKL_API.G_MISS_CHAR) ATTRIBUTE2,
94: NVL(ATTRIBUTE3, OKL_API.G_MISS_CHAR) ATTRIBUTE3,
95: NVL(ATTRIBUTE4, OKL_API.G_MISS_CHAR) ATTRIBUTE4,
96: NVL(ATTRIBUTE5, OKL_API.G_MISS_CHAR) ATTRIBUTE5,
97: NVL(ATTRIBUTE6, OKL_API.G_MISS_CHAR) ATTRIBUTE6,
98: NVL(ATTRIBUTE7, OKL_API.G_MISS_CHAR) ATTRIBUTE7,

Line 95: NVL(ATTRIBUTE4, OKL_API.G_MISS_CHAR) ATTRIBUTE4,

91: NVL(ATTRIBUTE_CATEGORY, OKL_API.G_MISS_CHAR) ATTRIBUTE_CATEGORY,
92: NVL(ATTRIBUTE1, OKL_API.G_MISS_CHAR) ATTRIBUTE1,
93: NVL(ATTRIBUTE2, OKL_API.G_MISS_CHAR) ATTRIBUTE2,
94: NVL(ATTRIBUTE3, OKL_API.G_MISS_CHAR) ATTRIBUTE3,
95: NVL(ATTRIBUTE4, OKL_API.G_MISS_CHAR) ATTRIBUTE4,
96: NVL(ATTRIBUTE5, OKL_API.G_MISS_CHAR) ATTRIBUTE5,
97: NVL(ATTRIBUTE6, OKL_API.G_MISS_CHAR) ATTRIBUTE6,
98: NVL(ATTRIBUTE7, OKL_API.G_MISS_CHAR) ATTRIBUTE7,
99: NVL(ATTRIBUTE8, OKL_API.G_MISS_CHAR) ATTRIBUTE8,

Line 96: NVL(ATTRIBUTE5, OKL_API.G_MISS_CHAR) ATTRIBUTE5,

92: NVL(ATTRIBUTE1, OKL_API.G_MISS_CHAR) ATTRIBUTE1,
93: NVL(ATTRIBUTE2, OKL_API.G_MISS_CHAR) ATTRIBUTE2,
94: NVL(ATTRIBUTE3, OKL_API.G_MISS_CHAR) ATTRIBUTE3,
95: NVL(ATTRIBUTE4, OKL_API.G_MISS_CHAR) ATTRIBUTE4,
96: NVL(ATTRIBUTE5, OKL_API.G_MISS_CHAR) ATTRIBUTE5,
97: NVL(ATTRIBUTE6, OKL_API.G_MISS_CHAR) ATTRIBUTE6,
98: NVL(ATTRIBUTE7, OKL_API.G_MISS_CHAR) ATTRIBUTE7,
99: NVL(ATTRIBUTE8, OKL_API.G_MISS_CHAR) ATTRIBUTE8,
100: NVL(ATTRIBUTE9, OKL_API.G_MISS_CHAR) ATTRIBUTE9,

Line 97: NVL(ATTRIBUTE6, OKL_API.G_MISS_CHAR) ATTRIBUTE6,

93: NVL(ATTRIBUTE2, OKL_API.G_MISS_CHAR) ATTRIBUTE2,
94: NVL(ATTRIBUTE3, OKL_API.G_MISS_CHAR) ATTRIBUTE3,
95: NVL(ATTRIBUTE4, OKL_API.G_MISS_CHAR) ATTRIBUTE4,
96: NVL(ATTRIBUTE5, OKL_API.G_MISS_CHAR) ATTRIBUTE5,
97: NVL(ATTRIBUTE6, OKL_API.G_MISS_CHAR) ATTRIBUTE6,
98: NVL(ATTRIBUTE7, OKL_API.G_MISS_CHAR) ATTRIBUTE7,
99: NVL(ATTRIBUTE8, OKL_API.G_MISS_CHAR) ATTRIBUTE8,
100: NVL(ATTRIBUTE9, OKL_API.G_MISS_CHAR) ATTRIBUTE9,
101: NVL(ATTRIBUTE10, OKL_API.G_MISS_CHAR) ATTRIBUTE10,

Line 98: NVL(ATTRIBUTE7, OKL_API.G_MISS_CHAR) ATTRIBUTE7,

94: NVL(ATTRIBUTE3, OKL_API.G_MISS_CHAR) ATTRIBUTE3,
95: NVL(ATTRIBUTE4, OKL_API.G_MISS_CHAR) ATTRIBUTE4,
96: NVL(ATTRIBUTE5, OKL_API.G_MISS_CHAR) ATTRIBUTE5,
97: NVL(ATTRIBUTE6, OKL_API.G_MISS_CHAR) ATTRIBUTE6,
98: NVL(ATTRIBUTE7, OKL_API.G_MISS_CHAR) ATTRIBUTE7,
99: NVL(ATTRIBUTE8, OKL_API.G_MISS_CHAR) ATTRIBUTE8,
100: NVL(ATTRIBUTE9, OKL_API.G_MISS_CHAR) ATTRIBUTE9,
101: NVL(ATTRIBUTE10, OKL_API.G_MISS_CHAR) ATTRIBUTE10,
102: NVL(ATTRIBUTE11, OKL_API.G_MISS_CHAR) ATTRIBUTE11,

Line 99: NVL(ATTRIBUTE8, OKL_API.G_MISS_CHAR) ATTRIBUTE8,

95: NVL(ATTRIBUTE4, OKL_API.G_MISS_CHAR) ATTRIBUTE4,
96: NVL(ATTRIBUTE5, OKL_API.G_MISS_CHAR) ATTRIBUTE5,
97: NVL(ATTRIBUTE6, OKL_API.G_MISS_CHAR) ATTRIBUTE6,
98: NVL(ATTRIBUTE7, OKL_API.G_MISS_CHAR) ATTRIBUTE7,
99: NVL(ATTRIBUTE8, OKL_API.G_MISS_CHAR) ATTRIBUTE8,
100: NVL(ATTRIBUTE9, OKL_API.G_MISS_CHAR) ATTRIBUTE9,
101: NVL(ATTRIBUTE10, OKL_API.G_MISS_CHAR) ATTRIBUTE10,
102: NVL(ATTRIBUTE11, OKL_API.G_MISS_CHAR) ATTRIBUTE11,
103: NVL(ATTRIBUTE12, OKL_API.G_MISS_CHAR) ATTRIBUTE12,

Line 100: NVL(ATTRIBUTE9, OKL_API.G_MISS_CHAR) ATTRIBUTE9,

96: NVL(ATTRIBUTE5, OKL_API.G_MISS_CHAR) ATTRIBUTE5,
97: NVL(ATTRIBUTE6, OKL_API.G_MISS_CHAR) ATTRIBUTE6,
98: NVL(ATTRIBUTE7, OKL_API.G_MISS_CHAR) ATTRIBUTE7,
99: NVL(ATTRIBUTE8, OKL_API.G_MISS_CHAR) ATTRIBUTE8,
100: NVL(ATTRIBUTE9, OKL_API.G_MISS_CHAR) ATTRIBUTE9,
101: NVL(ATTRIBUTE10, OKL_API.G_MISS_CHAR) ATTRIBUTE10,
102: NVL(ATTRIBUTE11, OKL_API.G_MISS_CHAR) ATTRIBUTE11,
103: NVL(ATTRIBUTE12, OKL_API.G_MISS_CHAR) ATTRIBUTE12,
104: NVL(ATTRIBUTE13, OKL_API.G_MISS_CHAR) ATTRIBUTE13,

Line 101: NVL(ATTRIBUTE10, OKL_API.G_MISS_CHAR) ATTRIBUTE10,

97: NVL(ATTRIBUTE6, OKL_API.G_MISS_CHAR) ATTRIBUTE6,
98: NVL(ATTRIBUTE7, OKL_API.G_MISS_CHAR) ATTRIBUTE7,
99: NVL(ATTRIBUTE8, OKL_API.G_MISS_CHAR) ATTRIBUTE8,
100: NVL(ATTRIBUTE9, OKL_API.G_MISS_CHAR) ATTRIBUTE9,
101: NVL(ATTRIBUTE10, OKL_API.G_MISS_CHAR) ATTRIBUTE10,
102: NVL(ATTRIBUTE11, OKL_API.G_MISS_CHAR) ATTRIBUTE11,
103: NVL(ATTRIBUTE12, OKL_API.G_MISS_CHAR) ATTRIBUTE12,
104: NVL(ATTRIBUTE13, OKL_API.G_MISS_CHAR) ATTRIBUTE13,
105: NVL(ATTRIBUTE14, OKL_API.G_MISS_CHAR) ATTRIBUTE14,

Line 102: NVL(ATTRIBUTE11, OKL_API.G_MISS_CHAR) ATTRIBUTE11,

98: NVL(ATTRIBUTE7, OKL_API.G_MISS_CHAR) ATTRIBUTE7,
99: NVL(ATTRIBUTE8, OKL_API.G_MISS_CHAR) ATTRIBUTE8,
100: NVL(ATTRIBUTE9, OKL_API.G_MISS_CHAR) ATTRIBUTE9,
101: NVL(ATTRIBUTE10, OKL_API.G_MISS_CHAR) ATTRIBUTE10,
102: NVL(ATTRIBUTE11, OKL_API.G_MISS_CHAR) ATTRIBUTE11,
103: NVL(ATTRIBUTE12, OKL_API.G_MISS_CHAR) ATTRIBUTE12,
104: NVL(ATTRIBUTE13, OKL_API.G_MISS_CHAR) ATTRIBUTE13,
105: NVL(ATTRIBUTE14, OKL_API.G_MISS_CHAR) ATTRIBUTE14,
106: NVL(ATTRIBUTE15, OKL_API.G_MISS_CHAR) ATTRIBUTE15,

Line 103: NVL(ATTRIBUTE12, OKL_API.G_MISS_CHAR) ATTRIBUTE12,

99: NVL(ATTRIBUTE8, OKL_API.G_MISS_CHAR) ATTRIBUTE8,
100: NVL(ATTRIBUTE9, OKL_API.G_MISS_CHAR) ATTRIBUTE9,
101: NVL(ATTRIBUTE10, OKL_API.G_MISS_CHAR) ATTRIBUTE10,
102: NVL(ATTRIBUTE11, OKL_API.G_MISS_CHAR) ATTRIBUTE11,
103: NVL(ATTRIBUTE12, OKL_API.G_MISS_CHAR) ATTRIBUTE12,
104: NVL(ATTRIBUTE13, OKL_API.G_MISS_CHAR) ATTRIBUTE13,
105: NVL(ATTRIBUTE14, OKL_API.G_MISS_CHAR) ATTRIBUTE14,
106: NVL(ATTRIBUTE15, OKL_API.G_MISS_CHAR) ATTRIBUTE15,
107: NVL(ORG_ID, OKL_API.G_MISS_NUM) ORG_ID,

Line 104: NVL(ATTRIBUTE13, OKL_API.G_MISS_CHAR) ATTRIBUTE13,

100: NVL(ATTRIBUTE9, OKL_API.G_MISS_CHAR) ATTRIBUTE9,
101: NVL(ATTRIBUTE10, OKL_API.G_MISS_CHAR) ATTRIBUTE10,
102: NVL(ATTRIBUTE11, OKL_API.G_MISS_CHAR) ATTRIBUTE11,
103: NVL(ATTRIBUTE12, OKL_API.G_MISS_CHAR) ATTRIBUTE12,
104: NVL(ATTRIBUTE13, OKL_API.G_MISS_CHAR) ATTRIBUTE13,
105: NVL(ATTRIBUTE14, OKL_API.G_MISS_CHAR) ATTRIBUTE14,
106: NVL(ATTRIBUTE15, OKL_API.G_MISS_CHAR) ATTRIBUTE15,
107: NVL(ORG_ID, OKL_API.G_MISS_NUM) ORG_ID,
108: NVL(THERE_CAN_BE_ONLY_ONE_YN, OKL_API.G_MISS_CHAR) THERE_CAN_BE_ONLY_ONE_YN,

Line 105: NVL(ATTRIBUTE14, OKL_API.G_MISS_CHAR) ATTRIBUTE14,

101: NVL(ATTRIBUTE10, OKL_API.G_MISS_CHAR) ATTRIBUTE10,
102: NVL(ATTRIBUTE11, OKL_API.G_MISS_CHAR) ATTRIBUTE11,
103: NVL(ATTRIBUTE12, OKL_API.G_MISS_CHAR) ATTRIBUTE12,
104: NVL(ATTRIBUTE13, OKL_API.G_MISS_CHAR) ATTRIBUTE13,
105: NVL(ATTRIBUTE14, OKL_API.G_MISS_CHAR) ATTRIBUTE14,
106: NVL(ATTRIBUTE15, OKL_API.G_MISS_CHAR) ATTRIBUTE15,
107: NVL(ORG_ID, OKL_API.G_MISS_NUM) ORG_ID,
108: NVL(THERE_CAN_BE_ONLY_ONE_YN, OKL_API.G_MISS_CHAR) THERE_CAN_BE_ONLY_ONE_YN,
109: CREATED_BY,

Line 106: NVL(ATTRIBUTE15, OKL_API.G_MISS_CHAR) ATTRIBUTE15,

102: NVL(ATTRIBUTE11, OKL_API.G_MISS_CHAR) ATTRIBUTE11,
103: NVL(ATTRIBUTE12, OKL_API.G_MISS_CHAR) ATTRIBUTE12,
104: NVL(ATTRIBUTE13, OKL_API.G_MISS_CHAR) ATTRIBUTE13,
105: NVL(ATTRIBUTE14, OKL_API.G_MISS_CHAR) ATTRIBUTE14,
106: NVL(ATTRIBUTE15, OKL_API.G_MISS_CHAR) ATTRIBUTE15,
107: NVL(ORG_ID, OKL_API.G_MISS_NUM) ORG_ID,
108: NVL(THERE_CAN_BE_ONLY_ONE_YN, OKL_API.G_MISS_CHAR) THERE_CAN_BE_ONLY_ONE_YN,
109: CREATED_BY,
110: CREATION_DATE,

Line 107: NVL(ORG_ID, OKL_API.G_MISS_NUM) ORG_ID,

103: NVL(ATTRIBUTE12, OKL_API.G_MISS_CHAR) ATTRIBUTE12,
104: NVL(ATTRIBUTE13, OKL_API.G_MISS_CHAR) ATTRIBUTE13,
105: NVL(ATTRIBUTE14, OKL_API.G_MISS_CHAR) ATTRIBUTE14,
106: NVL(ATTRIBUTE15, OKL_API.G_MISS_CHAR) ATTRIBUTE15,
107: NVL(ORG_ID, OKL_API.G_MISS_NUM) ORG_ID,
108: NVL(THERE_CAN_BE_ONLY_ONE_YN, OKL_API.G_MISS_CHAR) THERE_CAN_BE_ONLY_ONE_YN,
109: CREATED_BY,
110: CREATION_DATE,
111: LAST_UPDATED_BY,

Line 108: NVL(THERE_CAN_BE_ONLY_ONE_YN, OKL_API.G_MISS_CHAR) THERE_CAN_BE_ONLY_ONE_YN,

104: NVL(ATTRIBUTE13, OKL_API.G_MISS_CHAR) ATTRIBUTE13,
105: NVL(ATTRIBUTE14, OKL_API.G_MISS_CHAR) ATTRIBUTE14,
106: NVL(ATTRIBUTE15, OKL_API.G_MISS_CHAR) ATTRIBUTE15,
107: NVL(ORG_ID, OKL_API.G_MISS_NUM) ORG_ID,
108: NVL(THERE_CAN_BE_ONLY_ONE_YN, OKL_API.G_MISS_CHAR) THERE_CAN_BE_ONLY_ONE_YN,
109: CREATED_BY,
110: CREATION_DATE,
111: LAST_UPDATED_BY,
112: LAST_UPDATE_DATE,

Line 113: NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN

109: CREATED_BY,
110: CREATION_DATE,
111: LAST_UPDATED_BY,
112: LAST_UPDATE_DATE,
113: NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN
114: FROM Okl_Formulae_V
115: WHERE okl_formulae_v.id = p_id;
116: l_okl_fmav_pk okl_fmav_pk_csr%ROWTYPE;
117: l_fmav_rec fmav_rec_type;

Line 119: x_return_status := OKL_API.G_RET_STS_SUCCESS;

115: WHERE okl_formulae_v.id = p_id;
116: l_okl_fmav_pk okl_fmav_pk_csr%ROWTYPE;
117: l_fmav_rec fmav_rec_type;
118: BEGIN
119: x_return_status := OKL_API.G_RET_STS_SUCCESS;
120: x_no_data_found := TRUE;
121:
122: -- Get current database values
123: OPEN okl_fmav_pk_csr (p_fmav_rec.id);

Line 165: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

161: x_fmav_rec := l_fmav_rec;
162: EXCEPTION
163: WHEN OTHERS THEN
164: -- store SQL error message on message stack
165: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
166: p_msg_name => G_UNEXPECTED_ERROR,
167: p_token1 => G_SQLCODE_TOKEN,
168: p_token1_value => sqlcode,
169: p_token2 => G_SQLERRM_TOKEN,

Line 172: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

168: p_token1_value => sqlcode,
169: p_token2 => G_SQLERRM_TOKEN,
170: p_token2_value => sqlerrm);
171: -- notify UNEXPECTED error for calling API.
172: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
173:
174: IF (okl_fmav_pk_csr%ISOPEN) THEN
175: CLOSE okl_fmav_pk_csr;
176: END IF;

Line 202: AND (p_start_date BETWEEN START_DATE AND NVL(END_DATE, OKL_API.G_MISS_DATE) OR

198: SELECT '1'
199: FROM Okl_Formulae_V
200: WHERE NAME = p_name
201: AND ID <> p_id
202: AND (p_start_date BETWEEN START_DATE AND NVL(END_DATE, OKL_API.G_MISS_DATE) OR
203: p_end_date BETWEEN START_DATE AND NVL(END_DATE, OKL_API.G_MISS_DATE))
204: UNION ALL
205: SELECT '2'
206: FROM Okl_Formulae_V

Line 203: p_end_date BETWEEN START_DATE AND NVL(END_DATE, OKL_API.G_MISS_DATE))

199: FROM Okl_Formulae_V
200: WHERE NAME = p_name
201: AND ID <> p_id
202: AND (p_start_date BETWEEN START_DATE AND NVL(END_DATE, OKL_API.G_MISS_DATE) OR
203: p_end_date BETWEEN START_DATE AND NVL(END_DATE, OKL_API.G_MISS_DATE))
204: UNION ALL
205: SELECT '2'
206: FROM Okl_Formulae_V
207: WHERE NAME = p_name

Line 210: AND p_end_date >= NVL(END_DATE, OKL_API.G_MISS_DATE);

206: FROM Okl_Formulae_V
207: WHERE NAME = p_name
208: AND ID <> p_id
209: AND p_start_date <= START_DATE
210: AND p_end_date >= NVL(END_DATE, OKL_API.G_MISS_DATE);
211:
212: l_check VARCHAR2(1) := '?';
213: l_row_not_found BOOLEAN := FALSE;
214: BEGIN

Line 216: x_return_status := OKL_API.G_RET_STS_SUCCESS;

212: l_check VARCHAR2(1) := '?';
213: l_row_not_found BOOLEAN := FALSE;
214: BEGIN
215: x_valid := TRUE;
216: x_return_status := OKL_API.G_RET_STS_SUCCESS;
217:
218: -- Check for formulae overlaps
219: OPEN okl_fma_overlaps_csr (p_fmav_rec.id,
220: p_fmav_rec.name,

Line 228: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

224: l_row_not_found := okl_fma_overlaps_csr%NOTFOUND;
225: CLOSE okl_fma_overlaps_csr;
226:
227: IF l_row_not_found = FALSE then
228: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
229: p_msg_name => G_FMA_VERSION_OVERLAPS);
230: x_valid := FALSE;
231: x_return_status := OKL_API.G_RET_STS_ERROR;
232: END IF;

Line 231: x_return_status := OKL_API.G_RET_STS_ERROR;

227: IF l_row_not_found = FALSE then
228: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
229: p_msg_name => G_FMA_VERSION_OVERLAPS);
230: x_valid := FALSE;
231: x_return_status := OKL_API.G_RET_STS_ERROR;
232: END IF;
233:
234: EXCEPTION
235: WHEN OTHERS THEN

Line 237: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

233:
234: EXCEPTION
235: WHEN OTHERS THEN
236: -- store SQL error message on message stack
237: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
238: p_msg_name => G_UNEXPECTED_ERROR,
239: p_token1 => G_SQLCODE_TOKEN,
240: p_token1_value => sqlcode,
241: p_token2 => G_SQLERRM_TOKEN,

Line 244: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

240: p_token1_value => sqlcode,
241: p_token2 => G_SQLERRM_TOKEN,
242: p_token2_value => sqlerrm);
243: x_valid := FALSE;
244: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
245:
246: IF (okl_fma_overlaps_csr%ISOPEN) THEN
247: CLOSE okl_fma_overlaps_csr;
248: END IF;

Line 292: x_return_status := OKL_API.G_RET_STS_SUCCESS;

288: l_check VARCHAR2(1) := '?';
289: l_row_not_found BOOLEAN := FALSE;
290: BEGIN
291: x_valid := TRUE;
292: x_return_status := OKL_API.G_RET_STS_SUCCESS;
293:
294: -- Check for operand dates
295: OPEN okl_fma_constraints_csr (p_upd_fmav_rec.id,
296: p_upd_fmav_rec.start_date,

Line 303: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

299: l_row_not_found := okl_fma_constraints_csr%NOTFOUND;
300: CLOSE okl_fma_constraints_csr;
301:
302: IF NOT l_row_not_found then
303: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
304: p_msg_name => G_DATES_MISMATCH,
305: p_token1 => G_PARENT_TABLE_TOKEN,
306: p_token1_value => 'Okl_Formulae_V',
307: p_token2 => G_CHILD_TABLE_TOKEN,

Line 310: x_return_status := OKL_API.G_RET_STS_ERROR;

306: p_token1_value => 'Okl_Formulae_V',
307: p_token2 => G_CHILD_TABLE_TOKEN,
308: p_token2_value => 'Okl_Operands_V');
309: x_valid := FALSE;
310: x_return_status := OKL_API.G_RET_STS_ERROR;
311: END IF;
312:
313: EXCEPTION
314: WHEN OTHERS THEN

Line 316: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

312:
313: EXCEPTION
314: WHEN OTHERS THEN
315: -- store SQL error message on message stack
316: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
317: p_msg_name => G_UNEXPECTED_ERROR,
318: p_token1 => G_SQLCODE_TOKEN,
319: p_token1_value => sqlcode,
320: p_token2 => G_SQLERRM_TOKEN,

Line 323: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

319: p_token1_value => sqlcode,
320: p_token2 => G_SQLERRM_TOKEN,
321: p_token2_value => sqlerrm);
322: x_valid := FALSE;
323: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
324:
325: IF (okl_fma_constraints_csr%ISOPEN) THEN
326: CLOSE okl_fma_constraints_csr;
327: END IF;

Line 351: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

347: opd.END_DATE
348: FROM Okl_Operands_B opd
349: WHERE opd.fma_ID = p_fma_id;
350:
351: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
352: l_min_start_date DATE := NULL;
353: l_max_end_date DATE := NULL;
354:
355: BEGIN

Line 356: x_return_status := OKL_API.G_RET_STS_SUCCESS;

352: l_min_start_date DATE := NULL;
353: l_max_end_date DATE := NULL;
354:
355: BEGIN
356: x_return_status := OKL_API.G_RET_STS_SUCCESS;
357:
358: -- Get current database values
359: FOR okl_fma_linkedopds_rec in okl_fma_linkedopds_csr(p_upd_fmav_rec.id)
360: LOOP

Line 377: p_upd_fmav_rec.end_date <> OKL_API.G_MISS_DATE AND

373: END LOOP;
374:
375: IF p_upd_fmav_rec.start_date > l_min_start_date OR
376: (p_upd_fmav_rec.end_date IS NOT NULL AND
377: p_upd_fmav_rec.end_date <> OKL_API.G_MISS_DATE AND
378: p_upd_fmav_rec.end_date < NVL(l_max_end_date, to_date(to_char('31/12/9999','DD/MM/YYYY'), 'DD/MM/YYYY'))) THEN
379: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
380: p_msg_name => G_DATES_MISMATCH,
381: p_token1 => G_PARENT_TABLE_TOKEN,

Line 379: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

375: IF p_upd_fmav_rec.start_date > l_min_start_date OR
376: (p_upd_fmav_rec.end_date IS NOT NULL AND
377: p_upd_fmav_rec.end_date <> OKL_API.G_MISS_DATE AND
378: p_upd_fmav_rec.end_date < NVL(l_max_end_date, to_date(to_char('31/12/9999','DD/MM/YYYY'), 'DD/MM/YYYY'))) THEN
379: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
380: p_msg_name => G_DATES_MISMATCH,
381: p_token1 => G_PARENT_TABLE_TOKEN,
382: p_token1_value => 'Okl_Formulae_V',
383: p_token2 => G_CHILD_TABLE_TOKEN,

Line 392: x_return_status := OKL_API.G_RET_STS_ERROR;

388: EXCEPTION
389: WHEN G_EXCEPTION_HALT_PROCESSING THEN
390: -- no processing necessary; validation can continue
391: -- with the next column
392: x_return_status := OKL_API.G_RET_STS_ERROR;
393:
394: IF (okl_fma_linkedopds_csr%ISOPEN) THEN
395: CLOSE okl_fma_linkedopds_csr;
396: END IF;

Line 400: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

396: END IF;
397:
398: WHEN OTHERS THEN
399: -- store SQL error message on message stack
400: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
401: p_msg_name => G_UNEXPECTED_ERROR,
402: p_token1 => G_SQLCODE_TOKEN,
403: p_token1_value => sqlcode,
404: p_token2 => G_SQLERRM_TOKEN,

Line 407: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

403: p_token1_value => sqlcode,
404: p_token2 => G_SQLERRM_TOKEN,
405: p_token2_value => sqlerrm);
406: -- notify UNEXPECTED error for calling API.
407: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
408:
409: IF (okl_fma_linkedopds_csr%ISOPEN) THEN
410: CLOSE okl_fma_linkedopds_csr;
411: END IF;

Line 440: x_return_status := OKL_API.G_RET_STS_SUCCESS;

436: l_check VARCHAR2(1);
437: l_not_found BOOLEAN;
438:
439: BEGIN
440: x_return_status := OKL_API.G_RET_STS_SUCCESS;
441:
442: OPEN okl_fma_linkedopds_csr (p_upd_fmav_rec.id, p_upd_fmav_rec.start_date, p_upd_fmav_rec.end_date);
443: FETCH okl_fma_linkedopds_csr INTO l_check;
444: l_not_found := okl_fma_linkedopds_csr%NOTFOUND;

Line 448: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

444: l_not_found := okl_fma_linkedopds_csr%NOTFOUND;
445: CLOSE okl_fma_linkedopds_csr;
446:
447: IF NOT l_not_found THEN
448: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
449: p_msg_name => G_DATES_MISMATCH,
450: p_token1 => G_PARENT_TABLE_TOKEN,
451: p_token1_value => 'Formulae',
452: p_token2 => G_CHILD_TABLE_TOKEN,

Line 461: x_return_status := OKL_API.G_RET_STS_ERROR;

457: EXCEPTION
458: WHEN G_EXCEPTION_HALT_PROCESSING THEN
459: -- no processing necessary; validation can continue
460: -- with the next column
461: x_return_status := OKL_API.G_RET_STS_ERROR;
462:
463: IF (okl_fma_linkedopds_csr%ISOPEN) THEN
464: CLOSE okl_fma_linkedopds_csr;
465: END IF;

Line 469: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

465: END IF;
466:
467: WHEN OTHERS THEN
468: -- store SQL error message on message stack
469: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
470: p_msg_name => G_UNEXPECTED_ERROR,
471: p_token1 => G_SQLCODE_TOKEN,
472: p_token1_value => sqlcode,
473: p_token2 => G_SQLERRM_TOKEN,

Line 476: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

472: p_token1_value => sqlcode,
473: p_token2 => G_SQLERRM_TOKEN,
474: p_token2_value => sqlerrm);
475: -- notify UNEXPECTED error for calling API.
476: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
477:
478: IF (okl_fma_linkedopds_csr%ISOPEN) THEN
479: CLOSE okl_fma_linkedopds_csr;
480: END IF;

Line 499: IF p_upd_fmav_rec.description <> OKL_API.G_MISS_CHAR THEN

495: BEGIN
496: /* create a temporary record with all relevant details from db and upd records */
497: l_fmav_rec := p_db_fmav_rec;
498:
499: IF p_upd_fmav_rec.description <> OKL_API.G_MISS_CHAR THEN
500: l_fmav_rec.description := p_upd_fmav_rec.description;
501: END IF;
502:
503: IF p_upd_fmav_rec.start_date <> OKL_API.G_MISS_DATE THEN

Line 503: IF p_upd_fmav_rec.start_date <> OKL_API.G_MISS_DATE THEN

499: IF p_upd_fmav_rec.description <> OKL_API.G_MISS_CHAR THEN
500: l_fmav_rec.description := p_upd_fmav_rec.description;
501: END IF;
502:
503: IF p_upd_fmav_rec.start_date <> OKL_API.G_MISS_DATE THEN
504: l_fmav_rec.start_date := p_upd_fmav_rec.start_date;
505: END IF;
506:
507: IF p_upd_fmav_rec.end_date <> OKL_API.G_MISS_DATE THEN

Line 507: IF p_upd_fmav_rec.end_date <> OKL_API.G_MISS_DATE THEN

503: IF p_upd_fmav_rec.start_date <> OKL_API.G_MISS_DATE THEN
504: l_fmav_rec.start_date := p_upd_fmav_rec.start_date;
505: END IF;
506:
507: IF p_upd_fmav_rec.end_date <> OKL_API.G_MISS_DATE THEN
508: l_fmav_rec.end_date := p_upd_fmav_rec.end_date;
509: END IF;
510:
511: IF p_upd_fmav_rec.cgr_id <> OKL_API.G_MISS_NUM THEN

Line 511: IF p_upd_fmav_rec.cgr_id <> OKL_API.G_MISS_NUM THEN

507: IF p_upd_fmav_rec.end_date <> OKL_API.G_MISS_DATE THEN
508: l_fmav_rec.end_date := p_upd_fmav_rec.end_date;
509: END IF;
510:
511: IF p_upd_fmav_rec.cgr_id <> OKL_API.G_MISS_NUM THEN
512: l_fmav_rec.cgr_id := p_upd_fmav_rec.cgr_id;
513: END IF;
514:
515: IF p_upd_fmav_rec.formula_string <> OKL_API.G_MISS_CHAR THEN

Line 515: IF p_upd_fmav_rec.formula_string <> OKL_API.G_MISS_CHAR THEN

511: IF p_upd_fmav_rec.cgr_id <> OKL_API.G_MISS_NUM THEN
512: l_fmav_rec.cgr_id := p_upd_fmav_rec.cgr_id;
513: END IF;
514:
515: IF p_upd_fmav_rec.formula_string <> OKL_API.G_MISS_CHAR THEN
516: l_fmav_rec.formula_string := p_upd_fmav_rec.formula_string;
517: END IF;
518:
519: IF p_upd_fmav_rec.fyp_code <> OKL_API.G_MISS_CHAR THEN

Line 519: IF p_upd_fmav_rec.fyp_code <> OKL_API.G_MISS_CHAR THEN

515: IF p_upd_fmav_rec.formula_string <> OKL_API.G_MISS_CHAR THEN
516: l_fmav_rec.formula_string := p_upd_fmav_rec.formula_string;
517: END IF;
518:
519: IF p_upd_fmav_rec.fyp_code <> OKL_API.G_MISS_CHAR THEN
520: l_fmav_rec.fyp_code := p_upd_fmav_rec.fyp_code;
521: END IF;
522:
523: IF p_upd_fmav_rec.attribute_category <> OKL_API.G_MISS_CHAR THEN

Line 523: IF p_upd_fmav_rec.attribute_category <> OKL_API.G_MISS_CHAR THEN

519: IF p_upd_fmav_rec.fyp_code <> OKL_API.G_MISS_CHAR THEN
520: l_fmav_rec.fyp_code := p_upd_fmav_rec.fyp_code;
521: END IF;
522:
523: IF p_upd_fmav_rec.attribute_category <> OKL_API.G_MISS_CHAR THEN
524: l_fmav_rec.attribute_category := p_upd_fmav_rec.attribute_category;
525: END IF;
526:
527: IF p_upd_fmav_rec.attribute1 <> OKL_API.G_MISS_CHAR THEN

Line 527: IF p_upd_fmav_rec.attribute1 <> OKL_API.G_MISS_CHAR THEN

523: IF p_upd_fmav_rec.attribute_category <> OKL_API.G_MISS_CHAR THEN
524: l_fmav_rec.attribute_category := p_upd_fmav_rec.attribute_category;
525: END IF;
526:
527: IF p_upd_fmav_rec.attribute1 <> OKL_API.G_MISS_CHAR THEN
528: l_fmav_rec.attribute1 := p_upd_fmav_rec.attribute1;
529: END IF;
530:
531: IF p_upd_fmav_rec.attribute2 <> OKL_API.G_MISS_CHAR THEN

Line 531: IF p_upd_fmav_rec.attribute2 <> OKL_API.G_MISS_CHAR THEN

527: IF p_upd_fmav_rec.attribute1 <> OKL_API.G_MISS_CHAR THEN
528: l_fmav_rec.attribute1 := p_upd_fmav_rec.attribute1;
529: END IF;
530:
531: IF p_upd_fmav_rec.attribute2 <> OKL_API.G_MISS_CHAR THEN
532: l_fmav_rec.attribute2 := p_upd_fmav_rec.attribute2;
533: END IF;
534:
535: IF p_upd_fmav_rec.attribute3 <> OKL_API.G_MISS_CHAR THEN

Line 535: IF p_upd_fmav_rec.attribute3 <> OKL_API.G_MISS_CHAR THEN

531: IF p_upd_fmav_rec.attribute2 <> OKL_API.G_MISS_CHAR THEN
532: l_fmav_rec.attribute2 := p_upd_fmav_rec.attribute2;
533: END IF;
534:
535: IF p_upd_fmav_rec.attribute3 <> OKL_API.G_MISS_CHAR THEN
536: l_fmav_rec.attribute3 := p_upd_fmav_rec.attribute3;
537: END IF;
538:
539: IF p_upd_fmav_rec.attribute4 <> OKL_API.G_MISS_CHAR THEN

Line 539: IF p_upd_fmav_rec.attribute4 <> OKL_API.G_MISS_CHAR THEN

535: IF p_upd_fmav_rec.attribute3 <> OKL_API.G_MISS_CHAR THEN
536: l_fmav_rec.attribute3 := p_upd_fmav_rec.attribute3;
537: END IF;
538:
539: IF p_upd_fmav_rec.attribute4 <> OKL_API.G_MISS_CHAR THEN
540: l_fmav_rec.attribute4 := p_upd_fmav_rec.attribute4;
541: END IF;
542:
543: IF p_upd_fmav_rec.attribute5 <> OKL_API.G_MISS_CHAR THEN

Line 543: IF p_upd_fmav_rec.attribute5 <> OKL_API.G_MISS_CHAR THEN

539: IF p_upd_fmav_rec.attribute4 <> OKL_API.G_MISS_CHAR THEN
540: l_fmav_rec.attribute4 := p_upd_fmav_rec.attribute4;
541: END IF;
542:
543: IF p_upd_fmav_rec.attribute5 <> OKL_API.G_MISS_CHAR THEN
544: l_fmav_rec.attribute5 := p_upd_fmav_rec.attribute5;
545: END IF;
546:
547: IF p_upd_fmav_rec.attribute6 <> OKL_API.G_MISS_CHAR THEN

Line 547: IF p_upd_fmav_rec.attribute6 <> OKL_API.G_MISS_CHAR THEN

543: IF p_upd_fmav_rec.attribute5 <> OKL_API.G_MISS_CHAR THEN
544: l_fmav_rec.attribute5 := p_upd_fmav_rec.attribute5;
545: END IF;
546:
547: IF p_upd_fmav_rec.attribute6 <> OKL_API.G_MISS_CHAR THEN
548: l_fmav_rec.attribute6 := p_upd_fmav_rec.attribute6;
549: END IF;
550:
551: IF p_upd_fmav_rec.attribute7 <> OKL_API.G_MISS_CHAR THEN

Line 551: IF p_upd_fmav_rec.attribute7 <> OKL_API.G_MISS_CHAR THEN

547: IF p_upd_fmav_rec.attribute6 <> OKL_API.G_MISS_CHAR THEN
548: l_fmav_rec.attribute6 := p_upd_fmav_rec.attribute6;
549: END IF;
550:
551: IF p_upd_fmav_rec.attribute7 <> OKL_API.G_MISS_CHAR THEN
552: l_fmav_rec.attribute7 := p_upd_fmav_rec.attribute7;
553: END IF;
554:
555: IF p_upd_fmav_rec.attribute8 <> OKL_API.G_MISS_CHAR THEN

Line 555: IF p_upd_fmav_rec.attribute8 <> OKL_API.G_MISS_CHAR THEN

551: IF p_upd_fmav_rec.attribute7 <> OKL_API.G_MISS_CHAR THEN
552: l_fmav_rec.attribute7 := p_upd_fmav_rec.attribute7;
553: END IF;
554:
555: IF p_upd_fmav_rec.attribute8 <> OKL_API.G_MISS_CHAR THEN
556: l_fmav_rec.attribute8 := p_upd_fmav_rec.attribute8;
557: END IF;
558:
559: IF p_upd_fmav_rec.attribute9 <> OKL_API.G_MISS_CHAR THEN

Line 559: IF p_upd_fmav_rec.attribute9 <> OKL_API.G_MISS_CHAR THEN

555: IF p_upd_fmav_rec.attribute8 <> OKL_API.G_MISS_CHAR THEN
556: l_fmav_rec.attribute8 := p_upd_fmav_rec.attribute8;
557: END IF;
558:
559: IF p_upd_fmav_rec.attribute9 <> OKL_API.G_MISS_CHAR THEN
560: l_fmav_rec.attribute9 := p_upd_fmav_rec.attribute9;
561: END IF;
562:
563: IF p_upd_fmav_rec.attribute10 <> OKL_API.G_MISS_CHAR THEN

Line 563: IF p_upd_fmav_rec.attribute10 <> OKL_API.G_MISS_CHAR THEN

559: IF p_upd_fmav_rec.attribute9 <> OKL_API.G_MISS_CHAR THEN
560: l_fmav_rec.attribute9 := p_upd_fmav_rec.attribute9;
561: END IF;
562:
563: IF p_upd_fmav_rec.attribute10 <> OKL_API.G_MISS_CHAR THEN
564: l_fmav_rec.attribute10 := p_upd_fmav_rec.attribute10;
565: END IF;
566:
567: IF p_upd_fmav_rec.attribute11 <> OKL_API.G_MISS_CHAR THEN

Line 567: IF p_upd_fmav_rec.attribute11 <> OKL_API.G_MISS_CHAR THEN

563: IF p_upd_fmav_rec.attribute10 <> OKL_API.G_MISS_CHAR THEN
564: l_fmav_rec.attribute10 := p_upd_fmav_rec.attribute10;
565: END IF;
566:
567: IF p_upd_fmav_rec.attribute11 <> OKL_API.G_MISS_CHAR THEN
568: l_fmav_rec.attribute11 := p_upd_fmav_rec.attribute11;
569: END IF;
570:
571: IF p_upd_fmav_rec.attribute12 <> OKL_API.G_MISS_CHAR THEN

Line 571: IF p_upd_fmav_rec.attribute12 <> OKL_API.G_MISS_CHAR THEN

567: IF p_upd_fmav_rec.attribute11 <> OKL_API.G_MISS_CHAR THEN
568: l_fmav_rec.attribute11 := p_upd_fmav_rec.attribute11;
569: END IF;
570:
571: IF p_upd_fmav_rec.attribute12 <> OKL_API.G_MISS_CHAR THEN
572: l_fmav_rec.attribute12 := p_upd_fmav_rec.attribute12;
573: END IF;
574:
575: IF p_upd_fmav_rec.attribute13 <> OKL_API.G_MISS_CHAR THEN

Line 575: IF p_upd_fmav_rec.attribute13 <> OKL_API.G_MISS_CHAR THEN

571: IF p_upd_fmav_rec.attribute12 <> OKL_API.G_MISS_CHAR THEN
572: l_fmav_rec.attribute12 := p_upd_fmav_rec.attribute12;
573: END IF;
574:
575: IF p_upd_fmav_rec.attribute13 <> OKL_API.G_MISS_CHAR THEN
576: l_fmav_rec.attribute13 := p_upd_fmav_rec.attribute13;
577: END IF;
578:
579: IF p_upd_fmav_rec.attribute14 <> OKL_API.G_MISS_CHAR THEN

Line 579: IF p_upd_fmav_rec.attribute14 <> OKL_API.G_MISS_CHAR THEN

575: IF p_upd_fmav_rec.attribute13 <> OKL_API.G_MISS_CHAR THEN
576: l_fmav_rec.attribute13 := p_upd_fmav_rec.attribute13;
577: END IF;
578:
579: IF p_upd_fmav_rec.attribute14 <> OKL_API.G_MISS_CHAR THEN
580: l_fmav_rec.attribute14 := p_upd_fmav_rec.attribute14;
581: END IF;
582:
583: IF p_upd_fmav_rec.attribute15 <> OKL_API.G_MISS_CHAR THEN

Line 583: IF p_upd_fmav_rec.attribute15 <> OKL_API.G_MISS_CHAR THEN

579: IF p_upd_fmav_rec.attribute14 <> OKL_API.G_MISS_CHAR THEN
580: l_fmav_rec.attribute14 := p_upd_fmav_rec.attribute14;
581: END IF;
582:
583: IF p_upd_fmav_rec.attribute15 <> OKL_API.G_MISS_CHAR THEN
584: l_fmav_rec.attribute15 := p_upd_fmav_rec.attribute15;
585: END IF;
586:
587: IF p_upd_fmav_rec.org_id <> OKL_API.G_MISS_NUM THEN

Line 587: IF p_upd_fmav_rec.org_id <> OKL_API.G_MISS_NUM THEN

583: IF p_upd_fmav_rec.attribute15 <> OKL_API.G_MISS_CHAR THEN
584: l_fmav_rec.attribute15 := p_upd_fmav_rec.attribute15;
585: END IF;
586:
587: IF p_upd_fmav_rec.org_id <> OKL_API.G_MISS_NUM THEN
588: l_fmav_rec.org_id := p_upd_fmav_rec.org_id;
589: END IF;
590:
591: IF p_upd_fmav_rec.there_can_be_only_one_yn <> OKL_API.G_MISS_CHAR THEN

Line 591: IF p_upd_fmav_rec.there_can_be_only_one_yn <> OKL_API.G_MISS_CHAR THEN

587: IF p_upd_fmav_rec.org_id <> OKL_API.G_MISS_NUM THEN
588: l_fmav_rec.org_id := p_upd_fmav_rec.org_id;
589: END IF;
590:
591: IF p_upd_fmav_rec.there_can_be_only_one_yn <> OKL_API.G_MISS_CHAR THEN
592: l_fmav_rec.there_can_be_only_one_yn := p_upd_fmav_rec.there_can_be_only_one_yn;
593: END IF;
594:
595: RETURN l_fmav_rec;

Line 615: l_upd_fmav_rec.description := OKL_API.G_MISS_CHAR;

611: l_upd_fmav_rec := p_upd_fmav_rec;
612: l_db_fmav_rec := p_db_fmav_rec;
613:
614: IF l_upd_fmav_rec.description = l_db_fmav_rec.description THEN
615: l_upd_fmav_rec.description := OKL_API.G_MISS_CHAR;
616: END IF;
617:
618: IF to_date(to_char(l_upd_fmav_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') = to_date(to_char(l_db_fmav_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') THEN
619: l_upd_fmav_rec.start_date := OKL_API.G_MISS_DATE;

Line 619: l_upd_fmav_rec.start_date := OKL_API.G_MISS_DATE;

615: l_upd_fmav_rec.description := OKL_API.G_MISS_CHAR;
616: END IF;
617:
618: IF to_date(to_char(l_upd_fmav_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') = to_date(to_char(l_db_fmav_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') THEN
619: l_upd_fmav_rec.start_date := OKL_API.G_MISS_DATE;
620: END IF;
621:
622: IF to_date(to_char(l_upd_fmav_rec.end_date,'DD/MM/YYYY'), 'DD/MM/YYYY') = to_date(to_char(l_db_fmav_rec.end_date,'DD/MM/YYYY'), 'DD/MM/YYYY') THEN
623: l_upd_fmav_rec.end_date := OKL_API.G_MISS_DATE;

Line 623: l_upd_fmav_rec.end_date := OKL_API.G_MISS_DATE;

619: l_upd_fmav_rec.start_date := OKL_API.G_MISS_DATE;
620: END IF;
621:
622: IF to_date(to_char(l_upd_fmav_rec.end_date,'DD/MM/YYYY'), 'DD/MM/YYYY') = to_date(to_char(l_db_fmav_rec.end_date,'DD/MM/YYYY'), 'DD/MM/YYYY') THEN
623: l_upd_fmav_rec.end_date := OKL_API.G_MISS_DATE;
624: END IF;
625:
626: IF l_upd_fmav_rec.fyp_code = l_db_fmav_rec.fyp_code THEN
627: l_upd_fmav_rec.fyp_code := OKL_API.G_MISS_CHAR;

Line 627: l_upd_fmav_rec.fyp_code := OKL_API.G_MISS_CHAR;

623: l_upd_fmav_rec.end_date := OKL_API.G_MISS_DATE;
624: END IF;
625:
626: IF l_upd_fmav_rec.fyp_code = l_db_fmav_rec.fyp_code THEN
627: l_upd_fmav_rec.fyp_code := OKL_API.G_MISS_CHAR;
628: END IF;
629:
630: IF l_upd_fmav_rec.cgr_id = l_db_fmav_rec.cgr_id THEN
631: l_upd_fmav_rec.cgr_id := OKL_API.G_MISS_NUM;

Line 631: l_upd_fmav_rec.cgr_id := OKL_API.G_MISS_NUM;

627: l_upd_fmav_rec.fyp_code := OKL_API.G_MISS_CHAR;
628: END IF;
629:
630: IF l_upd_fmav_rec.cgr_id = l_db_fmav_rec.cgr_id THEN
631: l_upd_fmav_rec.cgr_id := OKL_API.G_MISS_NUM;
632: END IF;
633:
634: IF l_upd_fmav_rec.formula_string = l_db_fmav_rec.formula_string THEN
635: l_upd_fmav_rec.formula_string := OKL_API.G_MISS_CHAR;

Line 635: l_upd_fmav_rec.formula_string := OKL_API.G_MISS_CHAR;

631: l_upd_fmav_rec.cgr_id := OKL_API.G_MISS_NUM;
632: END IF;
633:
634: IF l_upd_fmav_rec.formula_string = l_db_fmav_rec.formula_string THEN
635: l_upd_fmav_rec.formula_string := OKL_API.G_MISS_CHAR;
636: END IF;
637:
638: IF l_upd_fmav_rec.attribute_category = l_db_fmav_rec.attribute_category THEN
639: l_upd_fmav_rec.attribute_category := OKL_API.G_MISS_CHAR;

Line 639: l_upd_fmav_rec.attribute_category := OKL_API.G_MISS_CHAR;

635: l_upd_fmav_rec.formula_string := OKL_API.G_MISS_CHAR;
636: END IF;
637:
638: IF l_upd_fmav_rec.attribute_category = l_db_fmav_rec.attribute_category THEN
639: l_upd_fmav_rec.attribute_category := OKL_API.G_MISS_CHAR;
640: END IF;
641:
642: IF l_upd_fmav_rec.attribute1 = l_db_fmav_rec.attribute1 THEN
643: l_upd_fmav_rec.attribute1 := OKL_API.G_MISS_CHAR;

Line 643: l_upd_fmav_rec.attribute1 := OKL_API.G_MISS_CHAR;

639: l_upd_fmav_rec.attribute_category := OKL_API.G_MISS_CHAR;
640: END IF;
641:
642: IF l_upd_fmav_rec.attribute1 = l_db_fmav_rec.attribute1 THEN
643: l_upd_fmav_rec.attribute1 := OKL_API.G_MISS_CHAR;
644: END IF;
645:
646: IF l_upd_fmav_rec.attribute2 = l_db_fmav_rec.attribute2 THEN
647: l_upd_fmav_rec.attribute2 := OKL_API.G_MISS_CHAR;

Line 647: l_upd_fmav_rec.attribute2 := OKL_API.G_MISS_CHAR;

643: l_upd_fmav_rec.attribute1 := OKL_API.G_MISS_CHAR;
644: END IF;
645:
646: IF l_upd_fmav_rec.attribute2 = l_db_fmav_rec.attribute2 THEN
647: l_upd_fmav_rec.attribute2 := OKL_API.G_MISS_CHAR;
648: END IF;
649:
650: IF l_upd_fmav_rec.attribute3 = l_db_fmav_rec.attribute3 THEN
651: l_upd_fmav_rec.attribute3 := OKL_API.G_MISS_CHAR;

Line 651: l_upd_fmav_rec.attribute3 := OKL_API.G_MISS_CHAR;

647: l_upd_fmav_rec.attribute2 := OKL_API.G_MISS_CHAR;
648: END IF;
649:
650: IF l_upd_fmav_rec.attribute3 = l_db_fmav_rec.attribute3 THEN
651: l_upd_fmav_rec.attribute3 := OKL_API.G_MISS_CHAR;
652: END IF;
653:
654: IF l_upd_fmav_rec.attribute4 = l_db_fmav_rec.attribute4 THEN
655: l_upd_fmav_rec.attribute4 := OKL_API.G_MISS_CHAR;

Line 655: l_upd_fmav_rec.attribute4 := OKL_API.G_MISS_CHAR;

651: l_upd_fmav_rec.attribute3 := OKL_API.G_MISS_CHAR;
652: END IF;
653:
654: IF l_upd_fmav_rec.attribute4 = l_db_fmav_rec.attribute4 THEN
655: l_upd_fmav_rec.attribute4 := OKL_API.G_MISS_CHAR;
656: END IF;
657:
658: IF l_upd_fmav_rec.attribute5 = l_db_fmav_rec.attribute5 THEN
659: l_upd_fmav_rec.attribute5 := OKL_API.G_MISS_CHAR;

Line 659: l_upd_fmav_rec.attribute5 := OKL_API.G_MISS_CHAR;

655: l_upd_fmav_rec.attribute4 := OKL_API.G_MISS_CHAR;
656: END IF;
657:
658: IF l_upd_fmav_rec.attribute5 = l_db_fmav_rec.attribute5 THEN
659: l_upd_fmav_rec.attribute5 := OKL_API.G_MISS_CHAR;
660: END IF;
661:
662: IF l_upd_fmav_rec.attribute6 = l_db_fmav_rec.attribute6 THEN
663: l_upd_fmav_rec.attribute6 := OKL_API.G_MISS_CHAR;

Line 663: l_upd_fmav_rec.attribute6 := OKL_API.G_MISS_CHAR;

659: l_upd_fmav_rec.attribute5 := OKL_API.G_MISS_CHAR;
660: END IF;
661:
662: IF l_upd_fmav_rec.attribute6 = l_db_fmav_rec.attribute6 THEN
663: l_upd_fmav_rec.attribute6 := OKL_API.G_MISS_CHAR;
664: END IF;
665:
666: IF l_upd_fmav_rec.attribute7 = l_db_fmav_rec.attribute7 THEN
667: l_upd_fmav_rec.attribute7 := OKL_API.G_MISS_CHAR;

Line 667: l_upd_fmav_rec.attribute7 := OKL_API.G_MISS_CHAR;

663: l_upd_fmav_rec.attribute6 := OKL_API.G_MISS_CHAR;
664: END IF;
665:
666: IF l_upd_fmav_rec.attribute7 = l_db_fmav_rec.attribute7 THEN
667: l_upd_fmav_rec.attribute7 := OKL_API.G_MISS_CHAR;
668: END IF;
669:
670: IF l_upd_fmav_rec.attribute8 = l_db_fmav_rec.attribute8 THEN
671: l_upd_fmav_rec.attribute8 := OKL_API.G_MISS_CHAR;

Line 671: l_upd_fmav_rec.attribute8 := OKL_API.G_MISS_CHAR;

667: l_upd_fmav_rec.attribute7 := OKL_API.G_MISS_CHAR;
668: END IF;
669:
670: IF l_upd_fmav_rec.attribute8 = l_db_fmav_rec.attribute8 THEN
671: l_upd_fmav_rec.attribute8 := OKL_API.G_MISS_CHAR;
672: END IF;
673:
674: IF l_upd_fmav_rec.attribute9 = l_db_fmav_rec.attribute9 THEN
675: l_upd_fmav_rec.attribute9 := OKL_API.G_MISS_CHAR;

Line 675: l_upd_fmav_rec.attribute9 := OKL_API.G_MISS_CHAR;

671: l_upd_fmav_rec.attribute8 := OKL_API.G_MISS_CHAR;
672: END IF;
673:
674: IF l_upd_fmav_rec.attribute9 = l_db_fmav_rec.attribute9 THEN
675: l_upd_fmav_rec.attribute9 := OKL_API.G_MISS_CHAR;
676: END IF;
677:
678: IF l_upd_fmav_rec.attribute10 = l_db_fmav_rec.attribute10 THEN
679: l_upd_fmav_rec.attribute10 := OKL_API.G_MISS_CHAR;

Line 679: l_upd_fmav_rec.attribute10 := OKL_API.G_MISS_CHAR;

675: l_upd_fmav_rec.attribute9 := OKL_API.G_MISS_CHAR;
676: END IF;
677:
678: IF l_upd_fmav_rec.attribute10 = l_db_fmav_rec.attribute10 THEN
679: l_upd_fmav_rec.attribute10 := OKL_API.G_MISS_CHAR;
680: END IF;
681:
682: IF l_upd_fmav_rec.attribute11 = l_db_fmav_rec.attribute11 THEN
683: l_upd_fmav_rec.attribute11 := OKL_API.G_MISS_CHAR;

Line 683: l_upd_fmav_rec.attribute11 := OKL_API.G_MISS_CHAR;

679: l_upd_fmav_rec.attribute10 := OKL_API.G_MISS_CHAR;
680: END IF;
681:
682: IF l_upd_fmav_rec.attribute11 = l_db_fmav_rec.attribute11 THEN
683: l_upd_fmav_rec.attribute11 := OKL_API.G_MISS_CHAR;
684: END IF;
685:
686: IF l_upd_fmav_rec.attribute12 = l_db_fmav_rec.attribute12 THEN
687: l_upd_fmav_rec.attribute12 := OKL_API.G_MISS_CHAR;

Line 687: l_upd_fmav_rec.attribute12 := OKL_API.G_MISS_CHAR;

683: l_upd_fmav_rec.attribute11 := OKL_API.G_MISS_CHAR;
684: END IF;
685:
686: IF l_upd_fmav_rec.attribute12 = l_db_fmav_rec.attribute12 THEN
687: l_upd_fmav_rec.attribute12 := OKL_API.G_MISS_CHAR;
688: END IF;
689:
690: IF l_upd_fmav_rec.attribute13 = l_db_fmav_rec.attribute13 THEN
691: l_upd_fmav_rec.attribute13 := OKL_API.G_MISS_CHAR;

Line 691: l_upd_fmav_rec.attribute13 := OKL_API.G_MISS_CHAR;

687: l_upd_fmav_rec.attribute12 := OKL_API.G_MISS_CHAR;
688: END IF;
689:
690: IF l_upd_fmav_rec.attribute13 = l_db_fmav_rec.attribute13 THEN
691: l_upd_fmav_rec.attribute13 := OKL_API.G_MISS_CHAR;
692: END IF;
693:
694: IF l_upd_fmav_rec.attribute14 = l_db_fmav_rec.attribute14 THEN
695: l_upd_fmav_rec.attribute14 := OKL_API.G_MISS_CHAR;

Line 695: l_upd_fmav_rec.attribute14 := OKL_API.G_MISS_CHAR;

691: l_upd_fmav_rec.attribute13 := OKL_API.G_MISS_CHAR;
692: END IF;
693:
694: IF l_upd_fmav_rec.attribute14 = l_db_fmav_rec.attribute14 THEN
695: l_upd_fmav_rec.attribute14 := OKL_API.G_MISS_CHAR;
696: END IF;
697:
698: IF l_upd_fmav_rec.attribute15 = l_db_fmav_rec.attribute15 THEN
699: l_upd_fmav_rec.attribute15 := OKL_API.G_MISS_CHAR;

Line 699: l_upd_fmav_rec.attribute15 := OKL_API.G_MISS_CHAR;

695: l_upd_fmav_rec.attribute14 := OKL_API.G_MISS_CHAR;
696: END IF;
697:
698: IF l_upd_fmav_rec.attribute15 = l_db_fmav_rec.attribute15 THEN
699: l_upd_fmav_rec.attribute15 := OKL_API.G_MISS_CHAR;
700: END IF;
701:
702: IF l_upd_fmav_rec.there_can_be_only_one_yn = l_db_fmav_rec.there_can_be_only_one_yn THEN
703: l_upd_fmav_rec.there_can_be_only_one_yn := OKL_API.G_MISS_CHAR;

Line 703: l_upd_fmav_rec.there_can_be_only_one_yn := OKL_API.G_MISS_CHAR;

699: l_upd_fmav_rec.attribute15 := OKL_API.G_MISS_CHAR;
700: END IF;
701:
702: IF l_upd_fmav_rec.there_can_be_only_one_yn = l_db_fmav_rec.there_can_be_only_one_yn THEN
703: l_upd_fmav_rec.there_can_be_only_one_yn := OKL_API.G_MISS_CHAR;
704: END IF;
705:
706: IF l_upd_fmav_rec.org_id = l_db_fmav_rec.org_id THEN
707: l_upd_fmav_rec.org_id := OKL_API.G_MISS_NUM;

Line 707: l_upd_fmav_rec.org_id := OKL_API.G_MISS_NUM;

703: l_upd_fmav_rec.there_can_be_only_one_yn := OKL_API.G_MISS_CHAR;
704: END IF;
705:
706: IF l_upd_fmav_rec.org_id = l_db_fmav_rec.org_id THEN
707: l_upd_fmav_rec.org_id := OKL_API.G_MISS_NUM;
708: END IF;
709:
710: p_upd_fmav_rec := l_upd_fmav_rec;
711:

Line 728: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

724: x_return_status OUT NOCOPY VARCHAR2,
725: x_msg_data OUT NOCOPY VARCHAR2
726: ) IS
727: l_fmav_rec fmav_rec_type;
728: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
729: l_valid BOOLEAN;
730: l_attrib_tbl okl_accounting_util.overlap_attrib_tbl_type;
731: BEGIN
732: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 732: x_return_status := OKL_API.G_RET_STS_SUCCESS;

728: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
729: l_valid BOOLEAN;
730: l_attrib_tbl okl_accounting_util.overlap_attrib_tbl_type;
731: BEGIN
732: x_return_status := OKL_API.G_RET_STS_SUCCESS;
733: l_fmav_rec := p_fmav_rec;
734:
735: IF p_upd_fmav_rec.start_date <> OKL_API.G_MISS_DATE OR
736: p_upd_fmav_rec.end_date <> OKL_API.G_MISS_DATE THEN

Line 735: IF p_upd_fmav_rec.start_date <> OKL_API.G_MISS_DATE OR

731: BEGIN
732: x_return_status := OKL_API.G_RET_STS_SUCCESS;
733: l_fmav_rec := p_fmav_rec;
734:
735: IF p_upd_fmav_rec.start_date <> OKL_API.G_MISS_DATE OR
736: p_upd_fmav_rec.end_date <> OKL_API.G_MISS_DATE THEN
737:
738: */
739: /* call check_overlaps */

Line 736: p_upd_fmav_rec.end_date <> OKL_API.G_MISS_DATE THEN

732: x_return_status := OKL_API.G_RET_STS_SUCCESS;
733: l_fmav_rec := p_fmav_rec;
734:
735: IF p_upd_fmav_rec.start_date <> OKL_API.G_MISS_DATE OR
736: p_upd_fmav_rec.end_date <> OKL_API.G_MISS_DATE THEN
737:
738: */
739: /* call check_overlaps */
740: /* l_attrib_tbl(1).attribute := 'NAME';

Line 754: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

750: p_view => 'Okl_Formulae_V',
751: x_return_status => l_return_status,
752: x_valid => l_valid);
753:
754: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
755: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
756: RAISE G_EXCEPTION_HALT_PROCESSING;
757: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
758: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND

Line 755: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

751: x_return_status => l_return_status,
752: x_valid => l_valid);
753:
754: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
755: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
756: RAISE G_EXCEPTION_HALT_PROCESSING;
757: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
758: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
759: l_valid <> TRUE) THEN

Line 757: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR

753:
754: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
755: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
756: RAISE G_EXCEPTION_HALT_PROCESSING;
757: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
758: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
759: l_valid <> TRUE) THEN
760: x_return_status := OKL_API.G_RET_STS_ERROR;
761: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 758: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND

754: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
755: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
756: RAISE G_EXCEPTION_HALT_PROCESSING;
757: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
758: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
759: l_valid <> TRUE) THEN
760: x_return_status := OKL_API.G_RET_STS_ERROR;
761: RAISE G_EXCEPTION_HALT_PROCESSING;
762: END IF;

Line 760: x_return_status := OKL_API.G_RET_STS_ERROR;

756: RAISE G_EXCEPTION_HALT_PROCESSING;
757: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
758: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
759: l_valid <> TRUE) THEN
760: x_return_status := OKL_API.G_RET_STS_ERROR;
761: RAISE G_EXCEPTION_HALT_PROCESSING;
762: END IF;
763: */
764: /* call check_constraints */

Line 769: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

765: /* check_constraints(p_upd_fmav_rec => p_upd_fmav_rec,
766: p_fmav_rec => l_fmav_rec,
767: x_return_status => l_return_status,
768: x_valid => l_valid);
769: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
770: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
771: RAISE G_EXCEPTION_HALT_PROCESSING;
772: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
773: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND

Line 770: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

766: p_fmav_rec => l_fmav_rec,
767: x_return_status => l_return_status,
768: x_valid => l_valid);
769: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
770: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
771: RAISE G_EXCEPTION_HALT_PROCESSING;
772: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
773: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
774: l_valid <> TRUE) THEN

Line 772: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR

768: x_valid => l_valid);
769: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
770: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
771: RAISE G_EXCEPTION_HALT_PROCESSING;
772: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
773: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
774: l_valid <> TRUE) THEN
775: x_return_status := OKL_API.G_RET_STS_ERROR;
776: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 773: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND

769: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
770: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
771: RAISE G_EXCEPTION_HALT_PROCESSING;
772: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
773: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
774: l_valid <> TRUE) THEN
775: x_return_status := OKL_API.G_RET_STS_ERROR;
776: RAISE G_EXCEPTION_HALT_PROCESSING;
777: END IF;

Line 775: x_return_status := OKL_API.G_RET_STS_ERROR;

771: RAISE G_EXCEPTION_HALT_PROCESSING;
772: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
773: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
774: l_valid <> TRUE) THEN
775: x_return_status := OKL_API.G_RET_STS_ERROR;
776: RAISE G_EXCEPTION_HALT_PROCESSING;
777: END IF;
778:
779: END IF;

Line 789: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

785: NULL;
786:
787: WHEN OTHERS THEN
788: -- store SQL error message on message stack for caller
789: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
790: p_msg_name => G_UNEXPECTED_ERROR,
791: p_token1 => G_SQLCODE_TOKEN,
792: p_token1_value => sqlcode,
793: p_token2 => G_SQLERRM_TOKEN,

Line 797: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

793: p_token2 => G_SQLERRM_TOKEN,
794: p_token2_value => sqlerrm );
795: x_msg_data := 'Unexpected Database Error';
796: -- notify caller of an UNEXPECTED error
797: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
798:
799: END check_updates;
800: */
801:

Line 821: /* IF p_upd_fmav_rec.start_date = OKL_API.G_MISS_DATE AND

817: l_sysdate DATE := trunc(SYSDATE);
818: BEGIN
819: */
820: /* Scenario 1: Only description and/or descriptive flexfield changes */
821: /* IF p_upd_fmav_rec.start_date = OKL_API.G_MISS_DATE AND
822: p_upd_fmav_rec.end_date = OKL_API.G_MISS_DATE AND
823: p_upd_fmav_rec.cgr_id = OKL_API.G_MISS_NUM AND
824: p_upd_fmav_rec.fyp_code = OKL_API.G_MISS_CHAR AND
825: p_upd_fmav_rec.formula_string = OKL_API.G_MISS_CHAR THEN

Line 822: p_upd_fmav_rec.end_date = OKL_API.G_MISS_DATE AND

818: BEGIN
819: */
820: /* Scenario 1: Only description and/or descriptive flexfield changes */
821: /* IF p_upd_fmav_rec.start_date = OKL_API.G_MISS_DATE AND
822: p_upd_fmav_rec.end_date = OKL_API.G_MISS_DATE AND
823: p_upd_fmav_rec.cgr_id = OKL_API.G_MISS_NUM AND
824: p_upd_fmav_rec.fyp_code = OKL_API.G_MISS_CHAR AND
825: p_upd_fmav_rec.formula_string = OKL_API.G_MISS_CHAR THEN
826: l_action := '1';

Line 823: p_upd_fmav_rec.cgr_id = OKL_API.G_MISS_NUM AND

819: */
820: /* Scenario 1: Only description and/or descriptive flexfield changes */
821: /* IF p_upd_fmav_rec.start_date = OKL_API.G_MISS_DATE AND
822: p_upd_fmav_rec.end_date = OKL_API.G_MISS_DATE AND
823: p_upd_fmav_rec.cgr_id = OKL_API.G_MISS_NUM AND
824: p_upd_fmav_rec.fyp_code = OKL_API.G_MISS_CHAR AND
825: p_upd_fmav_rec.formula_string = OKL_API.G_MISS_CHAR THEN
826: l_action := '1';
827: */

Line 824: p_upd_fmav_rec.fyp_code = OKL_API.G_MISS_CHAR AND

820: /* Scenario 1: Only description and/or descriptive flexfield changes */
821: /* IF p_upd_fmav_rec.start_date = OKL_API.G_MISS_DATE AND
822: p_upd_fmav_rec.end_date = OKL_API.G_MISS_DATE AND
823: p_upd_fmav_rec.cgr_id = OKL_API.G_MISS_NUM AND
824: p_upd_fmav_rec.fyp_code = OKL_API.G_MISS_CHAR AND
825: p_upd_fmav_rec.formula_string = OKL_API.G_MISS_CHAR THEN
826: l_action := '1';
827: */
828: /* Scenario 2: only changing description/descriptive flexfield changes

Line 825: p_upd_fmav_rec.formula_string = OKL_API.G_MISS_CHAR THEN

821: /* IF p_upd_fmav_rec.start_date = OKL_API.G_MISS_DATE AND
822: p_upd_fmav_rec.end_date = OKL_API.G_MISS_DATE AND
823: p_upd_fmav_rec.cgr_id = OKL_API.G_MISS_NUM AND
824: p_upd_fmav_rec.fyp_code = OKL_API.G_MISS_CHAR AND
825: p_upd_fmav_rec.formula_string = OKL_API.G_MISS_CHAR THEN
826: l_action := '1';
827: */
828: /* Scenario 2: only changing description/descriptive flexfield changes
829: and end date for all records or changing anything for a future record other

Line 831: /* ELSIF (p_upd_fmav_rec.start_date = OKL_API.G_MISS_DATE AND

827: */
828: /* Scenario 2: only changing description/descriptive flexfield changes
829: and end date for all records or changing anything for a future record other
830: than start date or modified start date is less than existing start date */
831: /* ELSIF (p_upd_fmav_rec.start_date = OKL_API.G_MISS_DATE AND
832: (p_upd_fmav_rec.end_date <> OKL_API.G_MISS_DATE OR
833: p_upd_fmav_rec.end_date IS NULL) AND
834: p_upd_fmav_rec.cgr_id = OKL_API.G_MISS_NUM AND
835: p_upd_fmav_rec.fyp_code = OKL_API.G_MISS_CHAR AND

Line 832: (p_upd_fmav_rec.end_date <> OKL_API.G_MISS_DATE OR

828: /* Scenario 2: only changing description/descriptive flexfield changes
829: and end date for all records or changing anything for a future record other
830: than start date or modified start date is less than existing start date */
831: /* ELSIF (p_upd_fmav_rec.start_date = OKL_API.G_MISS_DATE AND
832: (p_upd_fmav_rec.end_date <> OKL_API.G_MISS_DATE OR
833: p_upd_fmav_rec.end_date IS NULL) AND
834: p_upd_fmav_rec.cgr_id = OKL_API.G_MISS_NUM AND
835: p_upd_fmav_rec.fyp_code = OKL_API.G_MISS_CHAR AND
836: p_upd_fmav_rec.formula_string = OKL_API.G_MISS_CHAR) OR

Line 834: p_upd_fmav_rec.cgr_id = OKL_API.G_MISS_NUM AND

830: than start date or modified start date is less than existing start date */
831: /* ELSIF (p_upd_fmav_rec.start_date = OKL_API.G_MISS_DATE AND
832: (p_upd_fmav_rec.end_date <> OKL_API.G_MISS_DATE OR
833: p_upd_fmav_rec.end_date IS NULL) AND
834: p_upd_fmav_rec.cgr_id = OKL_API.G_MISS_NUM AND
835: p_upd_fmav_rec.fyp_code = OKL_API.G_MISS_CHAR AND
836: p_upd_fmav_rec.formula_string = OKL_API.G_MISS_CHAR) OR
837: (p_upd_fmav_rec.start_date = OKL_API.G_MISS_DATE AND
838: p_db_fmav_rec.start_date >= p_date AND

Line 835: p_upd_fmav_rec.fyp_code = OKL_API.G_MISS_CHAR AND

831: /* ELSIF (p_upd_fmav_rec.start_date = OKL_API.G_MISS_DATE AND
832: (p_upd_fmav_rec.end_date <> OKL_API.G_MISS_DATE OR
833: p_upd_fmav_rec.end_date IS NULL) AND
834: p_upd_fmav_rec.cgr_id = OKL_API.G_MISS_NUM AND
835: p_upd_fmav_rec.fyp_code = OKL_API.G_MISS_CHAR AND
836: p_upd_fmav_rec.formula_string = OKL_API.G_MISS_CHAR) OR
837: (p_upd_fmav_rec.start_date = OKL_API.G_MISS_DATE AND
838: p_db_fmav_rec.start_date >= p_date AND
839: (p_upd_fmav_rec.cgr_id <> OKL_API.G_MISS_NUM OR

Line 836: p_upd_fmav_rec.formula_string = OKL_API.G_MISS_CHAR) OR

832: (p_upd_fmav_rec.end_date <> OKL_API.G_MISS_DATE OR
833: p_upd_fmav_rec.end_date IS NULL) AND
834: p_upd_fmav_rec.cgr_id = OKL_API.G_MISS_NUM AND
835: p_upd_fmav_rec.fyp_code = OKL_API.G_MISS_CHAR AND
836: p_upd_fmav_rec.formula_string = OKL_API.G_MISS_CHAR) OR
837: (p_upd_fmav_rec.start_date = OKL_API.G_MISS_DATE AND
838: p_db_fmav_rec.start_date >= p_date AND
839: (p_upd_fmav_rec.cgr_id <> OKL_API.G_MISS_NUM OR
840: p_upd_fmav_rec.fyp_code <> OKL_API.G_MISS_CHAR OR

Line 837: (p_upd_fmav_rec.start_date = OKL_API.G_MISS_DATE AND

833: p_upd_fmav_rec.end_date IS NULL) AND
834: p_upd_fmav_rec.cgr_id = OKL_API.G_MISS_NUM AND
835: p_upd_fmav_rec.fyp_code = OKL_API.G_MISS_CHAR AND
836: p_upd_fmav_rec.formula_string = OKL_API.G_MISS_CHAR) OR
837: (p_upd_fmav_rec.start_date = OKL_API.G_MISS_DATE AND
838: p_db_fmav_rec.start_date >= p_date AND
839: (p_upd_fmav_rec.cgr_id <> OKL_API.G_MISS_NUM OR
840: p_upd_fmav_rec.fyp_code <> OKL_API.G_MISS_CHAR OR
841: p_upd_fmav_rec.formula_string <> OKL_API.G_MISS_CHAR)) OR

Line 839: (p_upd_fmav_rec.cgr_id <> OKL_API.G_MISS_NUM OR

835: p_upd_fmav_rec.fyp_code = OKL_API.G_MISS_CHAR AND
836: p_upd_fmav_rec.formula_string = OKL_API.G_MISS_CHAR) OR
837: (p_upd_fmav_rec.start_date = OKL_API.G_MISS_DATE AND
838: p_db_fmav_rec.start_date >= p_date AND
839: (p_upd_fmav_rec.cgr_id <> OKL_API.G_MISS_NUM OR
840: p_upd_fmav_rec.fyp_code <> OKL_API.G_MISS_CHAR OR
841: p_upd_fmav_rec.formula_string <> OKL_API.G_MISS_CHAR)) OR
842: (p_upd_fmav_rec.start_date <> OKL_API.G_MISS_DATE AND
843: p_db_fmav_rec.start_date > p_date AND

Line 840: p_upd_fmav_rec.fyp_code <> OKL_API.G_MISS_CHAR OR

836: p_upd_fmav_rec.formula_string = OKL_API.G_MISS_CHAR) OR
837: (p_upd_fmav_rec.start_date = OKL_API.G_MISS_DATE AND
838: p_db_fmav_rec.start_date >= p_date AND
839: (p_upd_fmav_rec.cgr_id <> OKL_API.G_MISS_NUM OR
840: p_upd_fmav_rec.fyp_code <> OKL_API.G_MISS_CHAR OR
841: p_upd_fmav_rec.formula_string <> OKL_API.G_MISS_CHAR)) OR
842: (p_upd_fmav_rec.start_date <> OKL_API.G_MISS_DATE AND
843: p_db_fmav_rec.start_date > p_date AND
844: p_upd_fmav_rec.start_date < p_db_fmav_rec.start_date) THEN

Line 841: p_upd_fmav_rec.formula_string <> OKL_API.G_MISS_CHAR)) OR

837: (p_upd_fmav_rec.start_date = OKL_API.G_MISS_DATE AND
838: p_db_fmav_rec.start_date >= p_date AND
839: (p_upd_fmav_rec.cgr_id <> OKL_API.G_MISS_NUM OR
840: p_upd_fmav_rec.fyp_code <> OKL_API.G_MISS_CHAR OR
841: p_upd_fmav_rec.formula_string <> OKL_API.G_MISS_CHAR)) OR
842: (p_upd_fmav_rec.start_date <> OKL_API.G_MISS_DATE AND
843: p_db_fmav_rec.start_date > p_date AND
844: p_upd_fmav_rec.start_date < p_db_fmav_rec.start_date) THEN
845: l_action := '2';

Line 842: (p_upd_fmav_rec.start_date <> OKL_API.G_MISS_DATE AND

838: p_db_fmav_rec.start_date >= p_date AND
839: (p_upd_fmav_rec.cgr_id <> OKL_API.G_MISS_NUM OR
840: p_upd_fmav_rec.fyp_code <> OKL_API.G_MISS_CHAR OR
841: p_upd_fmav_rec.formula_string <> OKL_API.G_MISS_CHAR)) OR
842: (p_upd_fmav_rec.start_date <> OKL_API.G_MISS_DATE AND
843: p_db_fmav_rec.start_date > p_date AND
844: p_upd_fmav_rec.start_date < p_db_fmav_rec.start_date) THEN
845: l_action := '2';
846: ELSE

Line 871: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

867: LABEL
868: FROM Okl_Fmla_Oprnds_V fod
869: WHERE fod.FMA_ID = p_fma_id;
870:
871: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
872: l_count NUMBER := 0;
873: l_fodv_tbl fodv_tbl_type;
874:
875: BEGIN

Line 876: x_return_status := OKL_API.G_RET_STS_SUCCESS;

872: l_count NUMBER := 0;
873: l_fodv_tbl fodv_tbl_type;
874:
875: BEGIN
876: x_return_status := OKL_API.G_RET_STS_SUCCESS;
877:
878: -- Get current database values
879: FOR okl_fod_rec in okl_fodv_fk_csr(p_upd_fmav_rec.id)
880: LOOP

Line 893: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

889:
890: EXCEPTION
891: WHEN OTHERS THEN
892: -- store SQL error message on message stack
893: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
894: p_msg_name => G_UNEXPECTED_ERROR,
895: p_token1 => G_SQLCODE_TOKEN,
896: p_token1_value => sqlcode,
897: p_token2 => G_SQLERRM_TOKEN,

Line 900: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

896: p_token1_value => sqlcode,
897: p_token2 => G_SQLERRM_TOKEN,
898: p_token2_value => sqlerrm );
899: -- notify UNEXPECTED error for calling API.
900: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
901:
902: IF (okl_fodv_fk_csr%ISOPEN) THEN
903: CLOSE okl_fodv_fk_csr;
904: END IF;

Line 914: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

910: ---------------------------------------------------------------------------
911: -- PROCEDURE insert_formulae for: OKL_FORMULAE_V
912: ---------------------------------------------------------------------------
913: PROCEDURE insert_formulae(p_api_version IN NUMBER,
914: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
915: x_return_status OUT NOCOPY VARCHAR2,
916: x_msg_count OUT NOCOPY NUMBER,
917: x_msg_data OUT NOCOPY VARCHAR2,
918: p_fmav_rec IN fmav_rec_type,

Line 924: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

920: ) IS
921: l_api_version CONSTANT NUMBER := 1;
922: l_api_name CONSTANT VARCHAR2(30) := 'insert_formulae';
923: l_valid BOOLEAN := TRUE;
924: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
925: l_fmav_rec fmav_rec_type;
926: l_sysdate DATE := to_date(to_char(SYSDATE,'DD/MM/YYYY'), 'DD/MM/YYYY');
927: BEGIN
928: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 928: x_return_status := OKL_API.G_RET_STS_SUCCESS;

924: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
925: l_fmav_rec fmav_rec_type;
926: l_sysdate DATE := to_date(to_char(SYSDATE,'DD/MM/YYYY'), 'DD/MM/YYYY');
927: BEGIN
928: x_return_status := OKL_API.G_RET_STS_SUCCESS;
929: l_fmav_rec := p_fmav_rec;
930:
931: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
932: p_pkg_name => G_PKG_NAME,

Line 931: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

927: BEGIN
928: x_return_status := OKL_API.G_RET_STS_SUCCESS;
929: l_fmav_rec := p_fmav_rec;
930:
931: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
932: p_pkg_name => G_PKG_NAME,
933: p_init_msg_list => p_init_msg_list,
934: l_api_version => l_api_version,
935: p_api_version => p_api_version,

Line 938: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

934: l_api_version => l_api_version,
935: p_api_version => p_api_version,
936: p_api_type => '_PVT',
937: x_return_status => l_return_status);
938: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
939: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
940: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
941: RAISE OKL_API.G_EXCEPTION_ERROR;
942: END IF;

Line 939: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

935: p_api_version => p_api_version,
936: p_api_type => '_PVT',
937: x_return_status => l_return_status);
938: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
939: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
940: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
941: RAISE OKL_API.G_EXCEPTION_ERROR;
942: END IF;
943:

Line 940: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

936: p_api_type => '_PVT',
937: x_return_status => l_return_status);
938: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
939: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
940: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
941: RAISE OKL_API.G_EXCEPTION_ERROR;
942: END IF;
943:
944: /* check for the records with start and end dates less than sysdate */

Line 941: RAISE OKL_API.G_EXCEPTION_ERROR;

937: x_return_status => l_return_status);
938: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
939: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
940: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
941: RAISE OKL_API.G_EXCEPTION_ERROR;
942: END IF;
943:
944: /* check for the records with start and end dates less than sysdate */
945: /* IF to_date(to_char(l_fmav_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate OR

Line 947: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

943:
944: /* check for the records with start and end dates less than sysdate */
945: /* IF to_date(to_char(l_fmav_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate OR
946: to_date(to_char(l_fmav_rec.end_date,'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate THEN
947: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
948: p_msg_name => G_PAST_RECORDS);
949: RAISE OKL_API.G_EXCEPTION_ERROR;
950: END IF;
951: */

Line 949: RAISE OKL_API.G_EXCEPTION_ERROR;

945: /* IF to_date(to_char(l_fmav_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate OR
946: to_date(to_char(l_fmav_rec.end_date,'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate THEN
947: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
948: p_msg_name => G_PAST_RECORDS);
949: RAISE OKL_API.G_EXCEPTION_ERROR;
950: END IF;
951: */
952:
953: -- Added by Santonyr

Line 956: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

952:
953: -- Added by Santonyr
954:
955: IF to_date(to_char(l_fmav_rec.end_date,'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate THEN
956: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
957: p_msg_name => G_PAST_RECORDS);
958: RAISE OKL_API.G_EXCEPTION_ERROR;
959: END IF;
960:

Line 958: RAISE OKL_API.G_EXCEPTION_ERROR;

954:
955: IF to_date(to_char(l_fmav_rec.end_date,'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate THEN
956: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
957: p_msg_name => G_PAST_RECORDS);
958: RAISE OKL_API.G_EXCEPTION_ERROR;
959: END IF;
960:
961: /* public api to insert formulae */
962: -- Start of wraper code generated automatically by Debug code generator for okl_formulae_pub.insert_formulae

Line 986: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN

982: END;
983: END IF;
984: -- End of wraper code generated automatically by Debug code generator for okl_formulae_pub.insert_formulae
985:
986: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
987: RAISE OKL_API.G_EXCEPTION_ERROR;
988: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
989: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
990: END IF;

Line 987: RAISE OKL_API.G_EXCEPTION_ERROR;

983: END IF;
984: -- End of wraper code generated automatically by Debug code generator for okl_formulae_pub.insert_formulae
985:
986: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
987: RAISE OKL_API.G_EXCEPTION_ERROR;
988: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
989: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
990: END IF;
991: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 988: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

984: -- End of wraper code generated automatically by Debug code generator for okl_formulae_pub.insert_formulae
985:
986: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
987: RAISE OKL_API.G_EXCEPTION_ERROR;
988: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
989: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
990: END IF;
991: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
992: x_msg_data => x_msg_data);

Line 989: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

985:
986: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
987: RAISE OKL_API.G_EXCEPTION_ERROR;
988: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
989: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
990: END IF;
991: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
992: x_msg_data => x_msg_data);
993: EXCEPTION

Line 991: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

987: RAISE OKL_API.G_EXCEPTION_ERROR;
988: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
989: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
990: END IF;
991: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
992: x_msg_data => x_msg_data);
993: EXCEPTION
994: WHEN OKL_API.G_EXCEPTION_ERROR THEN
995: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 994: WHEN OKL_API.G_EXCEPTION_ERROR THEN

990: END IF;
991: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
992: x_msg_data => x_msg_data);
993: EXCEPTION
994: WHEN OKL_API.G_EXCEPTION_ERROR THEN
995: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
996: p_pkg_name => G_PKG_NAME,
997: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
998: x_msg_count => x_msg_count,

Line 995: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

991: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
992: x_msg_data => x_msg_data);
993: EXCEPTION
994: WHEN OKL_API.G_EXCEPTION_ERROR THEN
995: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
996: p_pkg_name => G_PKG_NAME,
997: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
998: x_msg_count => x_msg_count,
999: x_msg_data => x_msg_data,

Line 997: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

993: EXCEPTION
994: WHEN OKL_API.G_EXCEPTION_ERROR THEN
995: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
996: p_pkg_name => G_PKG_NAME,
997: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
998: x_msg_count => x_msg_count,
999: x_msg_data => x_msg_data,
1000: p_api_type => '_PVT');
1001: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1001: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

997: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
998: x_msg_count => x_msg_count,
999: x_msg_data => x_msg_data,
1000: p_api_type => '_PVT');
1001: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1002: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1003: p_pkg_name => G_PKG_NAME,
1004: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1005: x_msg_count => x_msg_count,

Line 1002: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

998: x_msg_count => x_msg_count,
999: x_msg_data => x_msg_data,
1000: p_api_type => '_PVT');
1001: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1002: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1003: p_pkg_name => G_PKG_NAME,
1004: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1005: x_msg_count => x_msg_count,
1006: x_msg_data => x_msg_data,

Line 1004: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1000: p_api_type => '_PVT');
1001: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1002: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1003: p_pkg_name => G_PKG_NAME,
1004: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1005: x_msg_count => x_msg_count,
1006: x_msg_data => x_msg_data,
1007: p_api_type => '_PVT');
1008: WHEN OTHERS THEN

Line 1009: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1005: x_msg_count => x_msg_count,
1006: x_msg_data => x_msg_data,
1007: p_api_type => '_PVT');
1008: WHEN OTHERS THEN
1009: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1010: p_pkg_name => G_PKG_NAME,
1011: p_exc_name => 'OTHERS',
1012: x_msg_count => x_msg_count,
1013: x_msg_data => x_msg_data,

Line 1022: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1018: ---------------------------------------------------------------------------
1019: -- PROCEDURE update_formulae for: OKL_FORMULAE_V
1020: ---------------------------------------------------------------------------
1021: PROCEDURE update_formulae(p_api_version IN NUMBER,
1022: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1023: x_return_status OUT NOCOPY VARCHAR2,
1024: x_msg_count OUT NOCOPY NUMBER,
1025: x_msg_data OUT NOCOPY VARCHAR2,
1026: p_fmav_rec IN fmav_rec_type,

Line 1039: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1035: l_db_fmav_rec fmav_rec_type; /* database copy */
1036: l_upd_fmav_rec fmav_rec_type; /* input copy */
1037: l_fmav_rec fmav_rec_type; /* latest with the retained changes */
1038: l_tmp_fmav_rec fmav_rec_type; /* for any other purposes */
1039: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1040: l_action VARCHAR2(1);
1041: l_new_version VARCHAR2(100);
1042: l_fod_count NUMBER := 0;
1043: l_fodv_tbl fodv_tbl_type;

Line 1047: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1043: l_fodv_tbl fodv_tbl_type;
1044: l_out_fodv_tbl fodv_tbl_type;
1045: l_attrib_tbl okl_accounting_util.overlap_attrib_tbl_type;
1046: BEGIN
1047: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1048: l_upd_fmav_rec := p_fmav_rec;
1049:
1050: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
1051: p_pkg_name => G_PKG_NAME,

Line 1050: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

1046: BEGIN
1047: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1048: l_upd_fmav_rec := p_fmav_rec;
1049:
1050: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
1051: p_pkg_name => G_PKG_NAME,
1052: p_init_msg_list => p_init_msg_list,
1053: l_api_version => l_api_version,
1054: p_api_version => p_api_version,

Line 1057: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1053: l_api_version => l_api_version,
1054: p_api_version => p_api_version,
1055: p_api_type => '_PVT',
1056: x_return_status => l_return_status);
1057: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1058: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1059: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1060: RAISE OKL_API.G_EXCEPTION_ERROR;
1061: END IF;

Line 1058: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1054: p_api_version => p_api_version,
1055: p_api_type => '_PVT',
1056: x_return_status => l_return_status);
1057: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1058: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1059: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1060: RAISE OKL_API.G_EXCEPTION_ERROR;
1061: END IF;
1062:

Line 1059: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1055: p_api_type => '_PVT',
1056: x_return_status => l_return_status);
1057: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1058: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1059: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1060: RAISE OKL_API.G_EXCEPTION_ERROR;
1061: END IF;
1062:
1063: /* fetch old details from the database */

Line 1060: RAISE OKL_API.G_EXCEPTION_ERROR;

1056: x_return_status => l_return_status);
1057: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1058: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1059: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1060: RAISE OKL_API.G_EXCEPTION_ERROR;
1061: END IF;
1062:
1063: /* fetch old details from the database */
1064: get_rec(p_fmav_rec => l_upd_fmav_rec,

Line 1068: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS OR

1064: get_rec(p_fmav_rec => l_upd_fmav_rec,
1065: x_return_status => l_return_status,
1066: x_no_data_found => l_no_data_found,
1067: x_fmav_rec => l_db_fmav_rec);
1068: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS OR
1069: l_no_data_found = TRUE THEN
1070: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1071: END IF;
1072:

Line 1070: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1066: x_no_data_found => l_no_data_found,
1067: x_fmav_rec => l_db_fmav_rec);
1068: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS OR
1069: l_no_data_found = TRUE THEN
1070: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1071: END IF;
1072:
1073: /* to reorganize the input accordingly */
1074: reorganize_inputs(p_upd_fmav_rec => l_upd_fmav_rec,

Line 1079: /* IF to_date(to_char(l_upd_fmav_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(OKL_API.G_MISS_DATE,'DD/MM/YYYY'), 'DD/MM/YYYY') AND

1075: p_db_fmav_rec => l_db_fmav_rec);
1076:
1077:
1078: /* check for start date greater than sysdate */
1079: /* IF to_date(to_char(l_upd_fmav_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(OKL_API.G_MISS_DATE,'DD/MM/YYYY'), 'DD/MM/YYYY') AND
1080: to_date(to_char(l_upd_fmav_rec.start_date,'DD/MM/YYYY'),'DD/MM/YYYY') < l_sysdate THEN
1081: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1082: p_msg_name => G_START_DATE);
1083: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1081: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

1077:
1078: /* check for start date greater than sysdate */
1079: /* IF to_date(to_char(l_upd_fmav_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(OKL_API.G_MISS_DATE,'DD/MM/YYYY'), 'DD/MM/YYYY') AND
1080: to_date(to_char(l_upd_fmav_rec.start_date,'DD/MM/YYYY'),'DD/MM/YYYY') < l_sysdate THEN
1081: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1082: p_msg_name => G_START_DATE);
1083: RAISE OKL_API.G_EXCEPTION_ERROR;
1084: END IF;
1085: */

Line 1083: RAISE OKL_API.G_EXCEPTION_ERROR;

1079: /* IF to_date(to_char(l_upd_fmav_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(OKL_API.G_MISS_DATE,'DD/MM/YYYY'), 'DD/MM/YYYY') AND
1080: to_date(to_char(l_upd_fmav_rec.start_date,'DD/MM/YYYY'),'DD/MM/YYYY') < l_sysdate THEN
1081: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1082: p_msg_name => G_START_DATE);
1083: RAISE OKL_API.G_EXCEPTION_ERROR;
1084: END IF;
1085: */
1086:
1087: /* check for start date greater than sysdate */

Line 1088: IF to_date(to_char(l_upd_fmav_rec.end_date,'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(OKL_API.G_MISS_DATE,'DD/MM/YYYY'), 'DD/MM/YYYY') AND

1084: END IF;
1085: */
1086:
1087: /* check for start date greater than sysdate */
1088: IF to_date(to_char(l_upd_fmav_rec.end_date,'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(OKL_API.G_MISS_DATE,'DD/MM/YYYY'), 'DD/MM/YYYY') AND
1089: to_date(to_char(l_upd_fmav_rec.end_date,'DD/MM/YYYY'),'DD/MM/YYYY') < l_sysdate THEN
1090: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1091: p_msg_name => 'OKL_END_DATE');
1092: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1090: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

1086:
1087: /* check for start date greater than sysdate */
1088: IF to_date(to_char(l_upd_fmav_rec.end_date,'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(OKL_API.G_MISS_DATE,'DD/MM/YYYY'), 'DD/MM/YYYY') AND
1089: to_date(to_char(l_upd_fmav_rec.end_date,'DD/MM/YYYY'),'DD/MM/YYYY') < l_sysdate THEN
1090: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1091: p_msg_name => 'OKL_END_DATE');
1092: RAISE OKL_API.G_EXCEPTION_ERROR;
1093: END IF;
1094:

Line 1092: RAISE OKL_API.G_EXCEPTION_ERROR;

1088: IF to_date(to_char(l_upd_fmav_rec.end_date,'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(OKL_API.G_MISS_DATE,'DD/MM/YYYY'), 'DD/MM/YYYY') AND
1089: to_date(to_char(l_upd_fmav_rec.end_date,'DD/MM/YYYY'),'DD/MM/YYYY') < l_sysdate THEN
1090: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1091: p_msg_name => 'OKL_END_DATE');
1092: RAISE OKL_API.G_EXCEPTION_ERROR;
1093: END IF;
1094:
1095: /*
1096: -- check for start date greater than sysdate

Line 1097: IF to_date(to_char(l_upd_fmav_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(OKL_API.G_MISS_DATE,'DD/MM/YYYY'),'DD/MM/YYYY') AND

1093: END IF;
1094:
1095: /*
1096: -- check for start date greater than sysdate
1097: IF to_date(to_char(l_upd_fmav_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(OKL_API.G_MISS_DATE,'DD/MM/YYYY'),'DD/MM/YYYY') AND
1098: to_date(to_char(l_db_fmav_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(l_upd_fmav_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') AND
1099: to_date(to_char(l_db_fmav_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate THEN
1100: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1101: p_msg_name => G_PAST_RECORDS);

Line 1100: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

1096: -- check for start date greater than sysdate
1097: IF to_date(to_char(l_upd_fmav_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(OKL_API.G_MISS_DATE,'DD/MM/YYYY'),'DD/MM/YYYY') AND
1098: to_date(to_char(l_db_fmav_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(l_upd_fmav_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') AND
1099: to_date(to_char(l_db_fmav_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate THEN
1100: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1101: p_msg_name => G_PAST_RECORDS);
1102: RAISE OKL_API.G_EXCEPTION_ERROR;
1103: END IF;
1104:

Line 1102: RAISE OKL_API.G_EXCEPTION_ERROR;

1098: to_date(to_char(l_db_fmav_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(l_upd_fmav_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') AND
1099: to_date(to_char(l_db_fmav_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate THEN
1100: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1101: p_msg_name => G_PAST_RECORDS);
1102: RAISE OKL_API.G_EXCEPTION_ERROR;
1103: END IF;
1104:
1105:
1106: -- check for the records with start and end dates less than sysdate

Line 1109: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

1105:
1106: -- check for the records with start and end dates less than sysdate
1107: IF to_date(to_char(l_db_fmav_rec.start_date,'DD/MM/YYYY'),'DD/MM/YYYY') < l_sysdate AND
1108: to_date(to_char(l_db_fmav_rec.end_date,'DD/MM/YYYY'),'DD/MM/YYYY') < l_sysdate THEN
1109: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1110: p_msg_name => G_PAST_RECORDS);
1111: RAISE OKL_API.G_EXCEPTION_ERROR;
1112: END IF;
1113: */

Line 1111: RAISE OKL_API.G_EXCEPTION_ERROR;

1107: IF to_date(to_char(l_db_fmav_rec.start_date,'DD/MM/YYYY'),'DD/MM/YYYY') < l_sysdate AND
1108: to_date(to_char(l_db_fmav_rec.end_date,'DD/MM/YYYY'),'DD/MM/YYYY') < l_sysdate THEN
1109: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1110: p_msg_name => G_PAST_RECORDS);
1111: RAISE OKL_API.G_EXCEPTION_ERROR;
1112: END IF;
1113: */
1114:
1115:

Line 1120: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1116: /* check_constraints(p_upd_fmav_rec => l_upd_fmav_rec,
1117: p_fmav_rec => l_db_fmav_rec,
1118: x_return_status => l_return_status,
1119: x_valid => l_valid);
1120: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1121: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1122: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1123: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
1124: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND

Line 1121: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1117: p_fmav_rec => l_db_fmav_rec,
1118: x_return_status => l_return_status,
1119: x_valid => l_valid);
1120: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1121: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1122: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1123: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
1124: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
1125: l_valid <> TRUE) THEN

Line 1122: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1118: x_return_status => l_return_status,
1119: x_valid => l_valid);
1120: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1121: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1122: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1123: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
1124: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
1125: l_valid <> TRUE) THEN
1126: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 1123: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR

1119: x_valid => l_valid);
1120: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1121: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1122: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1123: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
1124: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
1125: l_valid <> TRUE) THEN
1126: x_return_status := OKL_API.G_RET_STS_ERROR;
1127: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1124: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND

1120: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1121: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1122: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1123: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
1124: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
1125: l_valid <> TRUE) THEN
1126: x_return_status := OKL_API.G_RET_STS_ERROR;
1127: RAISE OKL_API.G_EXCEPTION_ERROR;
1128: END IF;

Line 1126: x_return_status := OKL_API.G_RET_STS_ERROR;

1122: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1123: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
1124: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
1125: l_valid <> TRUE) THEN
1126: x_return_status := OKL_API.G_RET_STS_ERROR;
1127: RAISE OKL_API.G_EXCEPTION_ERROR;
1128: END IF;
1129: */
1130:

Line 1127: RAISE OKL_API.G_EXCEPTION_ERROR;

1123: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
1124: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
1125: l_valid <> TRUE) THEN
1126: x_return_status := OKL_API.G_RET_STS_ERROR;
1127: RAISE OKL_API.G_EXCEPTION_ERROR;
1128: END IF;
1129: */
1130:
1131: -- Check if the linked operands are within the date range of function

Line 1137: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1133: check_fma_opd_dates (p_upd_fmav_rec => l_upd_fmav_rec,
1134: p_fmav_rec => l_db_fmav_rec,
1135: x_return_status => l_return_status );
1136:
1137: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1138: RAISE OKL_API.G_EXCEPTION_ERROR;
1139: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1140: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1141: END IF;

Line 1138: RAISE OKL_API.G_EXCEPTION_ERROR;

1134: p_fmav_rec => l_db_fmav_rec,
1135: x_return_status => l_return_status );
1136:
1137: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1138: RAISE OKL_API.G_EXCEPTION_ERROR;
1139: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1140: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1141: END IF;
1142:

Line 1139: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1135: x_return_status => l_return_status );
1136:
1137: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1138: RAISE OKL_API.G_EXCEPTION_ERROR;
1139: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1140: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1141: END IF;
1142:
1143:

Line 1140: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1136:
1137: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1138: RAISE OKL_API.G_EXCEPTION_ERROR;
1139: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1140: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1141: END IF;
1142:
1143:
1144: -- Start of wraper code generated automatically by Debug code generator for okl_formulae_pub.update_formulae

Line 1167: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1163: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSFMB.pls call okl_formulae_pub.update_formulae ');
1164: END;
1165: END IF;
1166: -- End of wraper code generated automatically by Debug code generator for okl_formulae_pub.update_formulae
1167: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1168: RAISE OKL_API.G_EXCEPTION_ERROR;
1169: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1171: END IF;

Line 1168: RAISE OKL_API.G_EXCEPTION_ERROR;

1164: END;
1165: END IF;
1166: -- End of wraper code generated automatically by Debug code generator for okl_formulae_pub.update_formulae
1167: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1168: RAISE OKL_API.G_EXCEPTION_ERROR;
1169: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1171: END IF;
1172:

Line 1169: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1165: END IF;
1166: -- End of wraper code generated automatically by Debug code generator for okl_formulae_pub.update_formulae
1167: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1168: RAISE OKL_API.G_EXCEPTION_ERROR;
1169: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1171: END IF;
1172:
1173:

Line 1170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1166: -- End of wraper code generated automatically by Debug code generator for okl_formulae_pub.update_formulae
1167: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1168: RAISE OKL_API.G_EXCEPTION_ERROR;
1169: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1171: END IF;
1172:
1173:
1174: /* determine how the processing to be done */

Line 1194: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1190: x_msg_count => x_msg_count,
1191: x_msg_data => x_msg_data,
1192: p_fmav_rec => l_upd_fmav_rec,
1193: x_fmav_rec => x_fmav_rec);
1194: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1195: RAISE OKL_API.G_EXCEPTION_ERROR;
1196: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1197: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1198: END IF;

Line 1195: RAISE OKL_API.G_EXCEPTION_ERROR;

1191: x_msg_data => x_msg_data,
1192: p_fmav_rec => l_upd_fmav_rec,
1193: x_fmav_rec => x_fmav_rec);
1194: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1195: RAISE OKL_API.G_EXCEPTION_ERROR;
1196: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1197: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1198: END IF;
1199:

Line 1196: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1192: p_fmav_rec => l_upd_fmav_rec,
1193: x_fmav_rec => x_fmav_rec);
1194: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1195: RAISE OKL_API.G_EXCEPTION_ERROR;
1196: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1197: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1198: END IF;
1199:
1200: -- Scenario 2: only changing description/descriptive flexfield changes

Line 1197: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1193: x_fmav_rec => x_fmav_rec);
1194: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1195: RAISE OKL_API.G_EXCEPTION_ERROR;
1196: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1197: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1198: END IF;
1199:
1200: -- Scenario 2: only changing description/descriptive flexfield changes
1201: -- and end date for all records or changing anything for a future record other

Line 1214: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1210: p_db_fmav_rec => l_db_fmav_rec,
1211: p_fmav_rec => l_fmav_rec,
1212: x_return_status => l_return_status,
1213: x_msg_data => x_msg_data);
1214: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1215: RAISE OKL_API.G_EXCEPTION_ERROR;
1216: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1218: END IF;

Line 1215: RAISE OKL_API.G_EXCEPTION_ERROR;

1211: p_fmav_rec => l_fmav_rec,
1212: x_return_status => l_return_status,
1213: x_msg_data => x_msg_data);
1214: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1215: RAISE OKL_API.G_EXCEPTION_ERROR;
1216: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1218: END IF;
1219:

Line 1216: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1212: x_return_status => l_return_status,
1213: x_msg_data => x_msg_data);
1214: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1215: RAISE OKL_API.G_EXCEPTION_ERROR;
1216: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1218: END IF;
1219:
1220: -- public api to update formulae

Line 1217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1213: x_msg_data => x_msg_data);
1214: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1215: RAISE OKL_API.G_EXCEPTION_ERROR;
1216: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1218: END IF;
1219:
1220: -- public api to update formulae
1221: okl_formulae_pub.update_formulae(p_api_version => p_api_version,

Line 1228: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1224: x_msg_count => x_msg_count,
1225: x_msg_data => x_msg_data,
1226: p_fmav_rec => l_upd_fmav_rec,
1227: x_fmav_rec => x_fmav_rec);
1228: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1229: RAISE OKL_API.G_EXCEPTION_ERROR;
1230: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1232: END IF;

Line 1229: RAISE OKL_API.G_EXCEPTION_ERROR;

1225: x_msg_data => x_msg_data,
1226: p_fmav_rec => l_upd_fmav_rec,
1227: x_fmav_rec => x_fmav_rec);
1228: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1229: RAISE OKL_API.G_EXCEPTION_ERROR;
1230: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1232: END IF;
1233:

Line 1230: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1226: p_fmav_rec => l_upd_fmav_rec,
1227: x_fmav_rec => x_fmav_rec);
1228: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1229: RAISE OKL_API.G_EXCEPTION_ERROR;
1230: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1232: END IF;
1233:
1234: Scenario 3: changing anything else i.e., anything including start date for current

Line 1231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1227: x_fmav_rec => x_fmav_rec);
1228: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1229: RAISE OKL_API.G_EXCEPTION_ERROR;
1230: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1232: END IF;
1233:
1234: Scenario 3: changing anything else i.e., anything including start date for current
1235: records or anything + start date always greater than existing start date for

Line 1240: IF l_upd_fmav_rec.start_date <> OKL_API.G_MISS_DATE THEN

1236: future records
1237: ELSIF l_action = '3' THEN
1238:
1239: -- for old version
1240: IF l_upd_fmav_rec.start_date <> OKL_API.G_MISS_DATE THEN
1241: l_oldversion_enddate := l_upd_fmav_rec.start_date - 1;
1242: ELSE
1243: l_oldversion_enddate := l_sysdate - 1;
1244: END IF;

Line 1256: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1252: p_db_fmav_rec => l_db_fmav_rec,
1253: p_fmav_rec => l_fmav_rec,
1254: x_return_status => l_return_status,
1255: x_msg_data => x_msg_data);
1256: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1257: RAISE OKL_API.G_EXCEPTION_ERROR;
1258: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1259: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1260: END IF;

Line 1257: RAISE OKL_API.G_EXCEPTION_ERROR;

1253: p_fmav_rec => l_fmav_rec,
1254: x_return_status => l_return_status,
1255: x_msg_data => x_msg_data);
1256: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1257: RAISE OKL_API.G_EXCEPTION_ERROR;
1258: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1259: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1260: END IF;
1261: END IF;

Line 1258: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1254: x_return_status => l_return_status,
1255: x_msg_data => x_msg_data);
1256: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1257: RAISE OKL_API.G_EXCEPTION_ERROR;
1258: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1259: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1260: END IF;
1261: END IF;
1262:

Line 1259: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1255: x_msg_data => x_msg_data);
1256: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1257: RAISE OKL_API.G_EXCEPTION_ERROR;
1258: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1259: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1260: END IF;
1261: END IF;
1262:
1263: public api to update formulae

Line 1271: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1267: x_msg_count => x_msg_count,
1268: x_msg_data => x_msg_data,
1269: p_fmav_rec => l_fmav_rec,
1270: x_fmav_rec => x_fmav_rec);
1271: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1272: RAISE OKL_API.G_EXCEPTION_ERROR;
1273: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1274: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1275: END IF;

Line 1272: RAISE OKL_API.G_EXCEPTION_ERROR;

1268: x_msg_data => x_msg_data,
1269: p_fmav_rec => l_fmav_rec,
1270: x_fmav_rec => x_fmav_rec);
1271: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1272: RAISE OKL_API.G_EXCEPTION_ERROR;
1273: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1274: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1275: END IF;
1276:

Line 1273: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1269: p_fmav_rec => l_fmav_rec,
1270: x_fmav_rec => x_fmav_rec);
1271: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1272: RAISE OKL_API.G_EXCEPTION_ERROR;
1273: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1274: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1275: END IF;
1276:
1277: -- for new version

Line 1274: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1270: x_fmav_rec => x_fmav_rec);
1271: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1272: RAISE OKL_API.G_EXCEPTION_ERROR;
1273: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1274: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1275: END IF;
1276:
1277: -- for new version
1278: -- create a temporary record with all relevant details from db and upd records

Line 1282: IF l_upd_fmav_rec.start_date = OKL_API.G_MISS_DATE THEN

1278: -- create a temporary record with all relevant details from db and upd records
1279: l_fmav_rec := defaults_to_actuals(p_upd_fmav_rec => l_upd_fmav_rec,
1280: p_db_fmav_rec => l_db_fmav_rec);
1281:
1282: IF l_upd_fmav_rec.start_date = OKL_API.G_MISS_DATE THEN
1283: l_fmav_rec.start_date := l_sysdate;
1284: END IF;
1285:
1286: l_attrib_tbl(1).attribute := 'NAME';

Line 1298: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1294: p_view => 'Okl_Formulae_V',
1295: x_return_status => l_return_status,
1296: x_new_version => l_new_version);
1297:
1298: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1299: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1300: ELSE
1301: l_fmav_rec.version := l_new_version;
1302: END IF;

Line 1299: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1295: x_return_status => l_return_status,
1296: x_new_version => l_new_version);
1297:
1298: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1299: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1300: ELSE
1301: l_fmav_rec.version := l_new_version;
1302: END IF;
1303:

Line 1304: l_fmav_rec.id := OKL_API.G_MISS_NUM;

1300: ELSE
1301: l_fmav_rec.version := l_new_version;
1302: END IF;
1303:
1304: l_fmav_rec.id := OKL_API.G_MISS_NUM;
1305:
1306: -- call verify changes to update the database
1307: IF l_fmav_rec.end_date > l_db_fmav_rec.end_date THEN
1308: check_updates(p_upd_fmav_rec => l_upd_fmav_rec,

Line 1313: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1309: p_db_fmav_rec => l_db_fmav_rec,
1310: p_fmav_rec => l_fmav_rec,
1311: x_return_status => l_return_status,
1312: x_msg_data => x_msg_data);
1313: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1314: RAISE OKL_API.G_EXCEPTION_ERROR;
1315: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1316: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1317: END IF;

Line 1314: RAISE OKL_API.G_EXCEPTION_ERROR;

1310: p_fmav_rec => l_fmav_rec,
1311: x_return_status => l_return_status,
1312: x_msg_data => x_msg_data);
1313: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1314: RAISE OKL_API.G_EXCEPTION_ERROR;
1315: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1316: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1317: END IF;
1318: END IF;

Line 1315: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1311: x_return_status => l_return_status,
1312: x_msg_data => x_msg_data);
1313: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1314: RAISE OKL_API.G_EXCEPTION_ERROR;
1315: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1316: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1317: END IF;
1318: END IF;
1319:

Line 1316: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1312: x_msg_data => x_msg_data);
1313: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1314: RAISE OKL_API.G_EXCEPTION_ERROR;
1315: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1316: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1317: END IF;
1318: END IF;
1319:
1320: -- public api to insert formulae

Line 1328: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1324: x_msg_count => x_msg_count,
1325: x_msg_data => x_msg_data,
1326: p_fmav_rec => l_fmav_rec,
1327: x_fmav_rec => x_fmav_rec);
1328: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1329: RAISE OKL_API.G_EXCEPTION_ERROR;
1330: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1331: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1332: END IF;

Line 1329: RAISE OKL_API.G_EXCEPTION_ERROR;

1325: x_msg_data => x_msg_data,
1326: p_fmav_rec => l_fmav_rec,
1327: x_fmav_rec => x_fmav_rec);
1328: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1329: RAISE OKL_API.G_EXCEPTION_ERROR;
1330: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1331: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1332: END IF;
1333:

Line 1330: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1326: p_fmav_rec => l_fmav_rec,
1327: x_fmav_rec => x_fmav_rec);
1328: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1329: RAISE OKL_API.G_EXCEPTION_ERROR;
1330: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1331: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1332: END IF;
1333:
1334: -- copy output to input structure to get the id

Line 1331: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1327: x_fmav_rec => x_fmav_rec);
1328: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1329: RAISE OKL_API.G_EXCEPTION_ERROR;
1330: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1331: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1332: END IF;
1333:
1334: -- copy output to input structure to get the id
1335: l_fmav_rec := x_fmav_rec;

Line 1343: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1339: p_fmav_rec => l_fmav_rec,
1340: x_return_status => l_return_status,
1341: x_count => l_fod_count,
1342: x_fodv_tbl => l_fodv_tbl);
1343: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1344: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1345: END IF;
1346:
1347: IF l_fod_count > 0 THEN

Line 1344: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1340: x_return_status => l_return_status,
1341: x_count => l_fod_count,
1342: x_fodv_tbl => l_fodv_tbl);
1343: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1344: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1345: END IF;
1346:
1347: IF l_fod_count > 0 THEN
1348: okl_fmla_oprnds_pub.insert_fmla_oprnds(p_api_version => p_api_version,

Line 1355: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1351: x_msg_count => x_msg_count,
1352: x_msg_data => x_msg_data,
1353: p_fodv_tbl => l_fodv_tbl,
1354: x_fodv_tbl => l_out_fodv_tbl);
1355: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1356: RAISE OKL_API.G_EXCEPTION_ERROR;
1357: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1358: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1359: END IF;

Line 1356: RAISE OKL_API.G_EXCEPTION_ERROR;

1352: x_msg_data => x_msg_data,
1353: p_fodv_tbl => l_fodv_tbl,
1354: x_fodv_tbl => l_out_fodv_tbl);
1355: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1356: RAISE OKL_API.G_EXCEPTION_ERROR;
1357: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1358: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1359: END IF;
1360:

Line 1357: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1353: p_fodv_tbl => l_fodv_tbl,
1354: x_fodv_tbl => l_out_fodv_tbl);
1355: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1356: RAISE OKL_API.G_EXCEPTION_ERROR;
1357: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1358: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1359: END IF;
1360:
1361: END IF;

Line 1358: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1354: x_fodv_tbl => l_out_fodv_tbl);
1355: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1356: RAISE OKL_API.G_EXCEPTION_ERROR;
1357: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1358: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1359: END IF;
1360:
1361: END IF;
1362: END IF;

Line 1365: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

1361: END IF;
1362: END IF;
1363: */
1364:
1365: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1366: x_msg_data => x_msg_data);
1367: EXCEPTION
1368: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1369: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 1368: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1364:
1365: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1366: x_msg_data => x_msg_data);
1367: EXCEPTION
1368: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1369: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1370: p_pkg_name => G_PKG_NAME,
1371: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1372: x_msg_count => x_msg_count,

Line 1369: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1365: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1366: x_msg_data => x_msg_data);
1367: EXCEPTION
1368: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1369: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1370: p_pkg_name => G_PKG_NAME,
1371: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1372: x_msg_count => x_msg_count,
1373: x_msg_data => x_msg_data,

Line 1371: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1367: EXCEPTION
1368: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1369: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1370: p_pkg_name => G_PKG_NAME,
1371: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1372: x_msg_count => x_msg_count,
1373: x_msg_data => x_msg_data,
1374: p_api_type => '_PVT');
1375: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1375: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1371: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1372: x_msg_count => x_msg_count,
1373: x_msg_data => x_msg_data,
1374: p_api_type => '_PVT');
1375: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1376: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1377: p_pkg_name => G_PKG_NAME,
1378: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1379: x_msg_count => x_msg_count,

Line 1376: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1372: x_msg_count => x_msg_count,
1373: x_msg_data => x_msg_data,
1374: p_api_type => '_PVT');
1375: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1376: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1377: p_pkg_name => G_PKG_NAME,
1378: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1379: x_msg_count => x_msg_count,
1380: x_msg_data => x_msg_data,

Line 1378: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1374: p_api_type => '_PVT');
1375: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1376: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1377: p_pkg_name => G_PKG_NAME,
1378: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1379: x_msg_count => x_msg_count,
1380: x_msg_data => x_msg_data,
1381: p_api_type => '_PVT');
1382: WHEN OTHERS THEN

Line 1383: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1379: x_msg_count => x_msg_count,
1380: x_msg_data => x_msg_data,
1381: p_api_type => '_PVT');
1382: WHEN OTHERS THEN
1383: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1384: p_pkg_name => G_PKG_NAME,
1385: p_exc_name => 'OTHERS',
1386: x_msg_count => x_msg_count,
1387: x_msg_data => x_msg_data,