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.

APPS.CSD_RULES_ENGINE_PVT dependencies on FND_API

Line 28: SELECT fnd_api.g_true

24: IS
25: l_return_val VARCHAR2(1);
26: BEGIN
27: BEGIN
28: SELECT fnd_api.g_true
29: INTO l_return_val
30: FROM mtl_item_categories mic,wip_entities we
31: WHERE mic.inventory_item_id = p_mtl_txn_item_id
32: AND mic.category_id = p_criterion

Line 37: l_return_val := fnd_api.g_false;

33: AND mic.organization_id = we.organization_id
34: AND we.wip_entity_id = p_wip_entity_id;
35: EXCEPTION
36: WHEN no_data_found THEN
37: l_return_val := fnd_api.g_false;
38: END;
39: if p_operator = G_NOT_EQUALS
40: then
41: if l_return_val = fnd_api.g_true

Line 41: if l_return_val = fnd_api.g_true

37: l_return_val := fnd_api.g_false;
38: END;
39: if p_operator = G_NOT_EQUALS
40: then
41: if l_return_val = fnd_api.g_true
42: then
43: l_return_val := fnd_api.g_false;
44: else
45: l_return_val := fnd_api.g_true;

Line 43: l_return_val := fnd_api.g_false;

39: if p_operator = G_NOT_EQUALS
40: then
41: if l_return_val = fnd_api.g_true
42: then
43: l_return_val := fnd_api.g_false;
44: else
45: l_return_val := fnd_api.g_true;
46: end if;
47: end if;

Line 45: l_return_val := fnd_api.g_true;

41: if l_return_val = fnd_api.g_true
42: then
43: l_return_val := fnd_api.g_false;
44: else
45: l_return_val := fnd_api.g_true;
46: end if;
47: end if;
48:
49: return l_return_val;

Line 78: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

74: /* */
75: /*--------------------------------------------------------------------*/
76: PROCEDURE PROCESS_RULE_MATCHING(
77: p_api_version_number IN NUMBER,
78: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
79: p_commit IN VARCHAR2 := FND_API.G_FALSE,
80: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81: px_rule_matching_rec IN OUT NOCOPY CSD_RULE_MATCHING_REC_TYPE,
82: x_return_status OUT NOCOPY VARCHAR2,

Line 79: p_commit IN VARCHAR2 := FND_API.G_FALSE,

75: /*--------------------------------------------------------------------*/
76: PROCEDURE PROCESS_RULE_MATCHING(
77: p_api_version_number IN NUMBER,
78: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
79: p_commit IN VARCHAR2 := FND_API.G_FALSE,
80: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81: px_rule_matching_rec IN OUT NOCOPY CSD_RULE_MATCHING_REC_TYPE,
82: x_return_status OUT NOCOPY VARCHAR2,
83: x_msg_count OUT NOCOPY NUMBER,

Line 80: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

76: PROCEDURE PROCESS_RULE_MATCHING(
77: p_api_version_number IN NUMBER,
78: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
79: p_commit IN VARCHAR2 := FND_API.G_FALSE,
80: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81: px_rule_matching_rec IN OUT NOCOPY CSD_RULE_MATCHING_REC_TYPE,
82: x_return_status OUT NOCOPY VARCHAR2,
83: x_msg_count OUT NOCOPY NUMBER,
84: x_msg_data OUT NOCOPY VARCHAR2

Line 97: l_match_condition_ret_val VARCHAR2(1) := FND_API.G_FALSE;

93: l_rule_type VARCHAR2(30) := NULL;
94: l_attr_type VARCHAR2(30) := NULL;
95: l_attr_code VARCHAR2(30) := NULL;
96: l_event_type VARCHAR2(30) := NULL;
97: l_match_condition_ret_val VARCHAR2(1) := FND_API.G_FALSE;
98: l_is_match VARCHAR2(1) := FND_API.G_FALSE;
99: l_tbl_last_ind NUMBER := 1;
100: l_repair_line_id NUMBER := NULL;
101:

Line 98: l_is_match VARCHAR2(1) := FND_API.G_FALSE;

94: l_attr_type VARCHAR2(30) := NULL;
95: l_attr_code VARCHAR2(30) := NULL;
96: l_event_type VARCHAR2(30) := NULL;
97: l_match_condition_ret_val VARCHAR2(1) := FND_API.G_FALSE;
98: l_is_match VARCHAR2(1) := FND_API.G_FALSE;
99: l_tbl_last_ind NUMBER := 1;
100: l_repair_line_id NUMBER := NULL;
101:
102: ---- cursors ----

Line 139: IF NOT FND_API.Compatible_API_Call ( c_API_VERSION_NUMBER,

135: --* Standard Start of API savepoint
136: SAVEPOINT PROCESS_RULE_MATCHING_PVT;
137:
138: --* Standard call to check for call compatibility.
139: IF NOT FND_API.Compatible_API_Call ( c_API_VERSION_NUMBER,
140: p_api_version_number,
141: c_API_NAME,
142: G_PKG_NAME)
143: THEN

Line 144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

140: p_api_version_number,
141: c_API_NAME,
142: G_PKG_NAME)
143: THEN
144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145: END IF;
146:
147: -- Initialize message list if p_init_msg_list is set to TRUE.
148: IF FND_API.to_Boolean( p_init_msg_list )

Line 148: IF FND_API.to_Boolean( p_init_msg_list )

144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145: END IF;
146:
147: -- Initialize message list if p_init_msg_list is set to TRUE.
148: IF FND_API.to_Boolean( p_init_msg_list )
149: THEN
150: FND_MSG_PUB.initialize;
151: END IF;
152:

Line 154: x_return_status := FND_API.G_RET_STS_SUCCESS;

150: FND_MSG_PUB.initialize;
151: END IF;
152:
153: -- Initialize API return status to SUCCESS
154: x_return_status := FND_API.G_RET_STS_SUCCESS;
155:
156: --* logic starts here *--
157:
158: --* populate p_rule_input_rec

Line 204: l_is_match := FND_API.G_FALSE;

200: --** debug starts!!
201: --dbms_output.put_line('PROCESS_RULE_MATCHING - LP - get_rules - rule id = ' || l_rule_rec.rule_id || '<-----');
202: --** debug ends!!
203: --* default to false, assume not match unless otherwise returned by match_condition
204: l_is_match := FND_API.G_FALSE;
205: FOR l_rule_cond_rec IN cur_get_rule_conditions(l_rule_rec.rule_id, l_rule_type) LOOP
206: --** debug starts!!
207: --dbms_output.put_line('> PROCESS_RULE_MATCHING - LP - get_rule_cond - attr_cat = ' || l_rule_cond_rec.attribute_category);
208: --dbms_output.put_line('> PROCESS_RULE_MATCHING - LP - get_rule_cond - attr1 = ' || l_rule_cond_rec.attribute1);

Line 219: IF (l_is_match = FND_API.G_FALSE )THEN

215: p_rule_input_rec => px_rule_matching_rec.RULE_INPUT_REC
216: );
217:
218:
219: IF (l_is_match = FND_API.G_FALSE )THEN
220: --** debug starts!!
221: --dbms_output.put_line('PROCESS_RULE_MATCHING -> l_match_condition_ret_val = FALSE - l_is_match = ' || l_is_match);
222: --** debug ends!!
223:

Line 225: END IF; --* end IF (l_match_condition_ret_val = FND_API.G_FALSE ) *--

221: --dbms_output.put_line('PROCESS_RULE_MATCHING -> l_match_condition_ret_val = FALSE - l_is_match = ' || l_is_match);
222: --** debug ends!!
223:
224: EXIT; --* a condition didn't match, so no need to go on
225: END IF; --* end IF (l_match_condition_ret_val = FND_API.G_FALSE ) *--
226:
227: END LOOP; --* end FOR l_rule_cond_rec... *--
228:
229: IF (l_is_match = FND_API.G_TRUE) THEN

Line 229: IF (l_is_match = FND_API.G_TRUE) THEN

225: END IF; --* end IF (l_match_condition_ret_val = FND_API.G_FALSE ) *--
226:
227: END LOOP; --* end FOR l_rule_cond_rec... *--
228:
229: IF (l_is_match = FND_API.G_TRUE) THEN
230: -- we only need to find the first match, so we can exit out of the loop.
231: l_tbl_last_ind := px_rule_matching_rec.RULE_RESULTS_TBL.COUNT;
232: l_tbl_last_ind := l_tbl_last_ind+1;
233: --** debug starts!!

Line 252: END IF; --* end IF (l_is_match = FND_API.G_TRUE) *--

248:
249: IF (px_rule_matching_rec.RULE_MATCH_CODE = G_RULE_MATCH_ONE) THEN
250: EXIT;
251: END IF; --* end I(px_rule_matching_rec.RULE_MATCH_CODE = G_RULE_MATCH_ONE) *--
252: END IF; --* end IF (l_is_match = FND_API.G_TRUE) *--
253: --** debug starts!!
254: --dbms_output.put_line('PROCESS_RULE_MATCHING -> before exiting rules loop');
255: --** debug ends!!
256:

Line 262: IF FND_API.to_Boolean( p_commit ) THEN

258:
259: --* logic ends here *--
260:
261: --* Standard check for p_commit
262: IF FND_API.to_Boolean( p_commit ) THEN
263: COMMIT WORK;
264: END IF;
265:
266: --** debug starts!!

Line 281: WHEN FND_API.G_EXC_ERROR THEN

277: --dbms_output.put_line('PROCESS_RULE_MATCHING -> after standard call to message count');
278: --** debug ends!!
279:
280: EXCEPTION
281: WHEN FND_API.G_EXC_ERROR THEN
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: --** debug starts!!
284: --dbms_output.put_line('PROCESS_RULE_MATCHING -> exception 1');
285: --** debug ends!!

Line 282: x_return_status := FND_API.G_RET_STS_ERROR;

278: --** debug ends!!
279:
280: EXCEPTION
281: WHEN FND_API.G_EXC_ERROR THEN
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: --** debug starts!!
284: --dbms_output.put_line('PROCESS_RULE_MATCHING -> exception 1');
285: --** debug ends!!
286:

Line 296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

292: ,X_MSG_COUNT => X_MSG_COUNT
293: ,X_MSG_DATA => X_MSG_DATA
294: ,X_RETURN_STATUS => X_RETURN_STATUS);
295:
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: x_return_status := FND_API.G_RET_STS_ERROR;
298: --** debug starts!!
299: --dbms_output.put_line('PROCESS_RULE_MATCHING -> exception 2');
300: --** debug ends!!

Line 297: x_return_status := FND_API.G_RET_STS_ERROR;

293: ,X_MSG_DATA => X_MSG_DATA
294: ,X_RETURN_STATUS => X_RETURN_STATUS);
295:
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: x_return_status := FND_API.G_RET_STS_ERROR;
298: --** debug starts!!
299: --dbms_output.put_line('PROCESS_RULE_MATCHING -> exception 2');
300: --** debug ends!!
301:

Line 312: x_return_status := FND_API.G_RET_STS_ERROR;

308: ,X_MSG_DATA => X_MSG_DATA
309: ,X_RETURN_STATUS => X_RETURN_STATUS);
310:
311: WHEN OTHERS THEN
312: x_return_status := FND_API.G_RET_STS_ERROR;
313: --** debug starts!!
314: --dbms_output.put_line('PROCESS_RULE_MATCHING -> exception 3');
315: --** debug ends!!
316:

Line 331: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

327: END PROCESS_RULE_MATCHING;
328:
329: PROCEDURE SOO_DEFAULTING (
330: p_api_version_number IN NUMBER,
331: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
332: p_commit IN VARCHAR2 := FND_API.G_FALSE,
333: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
334: p_event_type IN VARCHAR2,
335: p_rule_input_rec IN CSD_RULE_INPUT_REC_TYPE,

Line 332: p_commit IN VARCHAR2 := FND_API.G_FALSE,

328:
329: PROCEDURE SOO_DEFAULTING (
330: p_api_version_number IN NUMBER,
331: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
332: p_commit IN VARCHAR2 := FND_API.G_FALSE,
333: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
334: p_event_type IN VARCHAR2,
335: p_rule_input_rec IN CSD_RULE_INPUT_REC_TYPE,
336: x_rule_id OUT NOCOPY NUMBER,

Line 333: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

329: PROCEDURE SOO_DEFAULTING (
330: p_api_version_number IN NUMBER,
331: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
332: p_commit IN VARCHAR2 := FND_API.G_FALSE,
333: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
334: p_event_type IN VARCHAR2,
335: p_rule_input_rec IN CSD_RULE_INPUT_REC_TYPE,
336: x_rule_id OUT NOCOPY NUMBER,
337: x_return_status OUT NOCOPY VARCHAR2,

Line 359: IF NOT FND_API.Compatible_API_Call ( c_API_VERSION_NUMBER,

355: --* Standard Start of API savepoint
356: SAVEPOINT GET_SOO_VALUES;
357:
358: --* Standard call to check for call compatibility.
359: IF NOT FND_API.Compatible_API_Call ( c_API_VERSION_NUMBER,
360: p_api_version_number,
361: c_API_NAME,
362: G_PKG_NAME)
363: THEN

Line 364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

360: p_api_version_number,
361: c_API_NAME,
362: G_PKG_NAME)
363: THEN
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365: END IF;
366:
367: --* Initialize message list if p_init_msg_list is set to TRUE.
368: IF FND_API.to_Boolean( p_init_msg_list )

Line 368: IF FND_API.to_Boolean( p_init_msg_list )

364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365: END IF;
366:
367: --* Initialize message list if p_init_msg_list is set to TRUE.
368: IF FND_API.to_Boolean( p_init_msg_list )
369: THEN
370: FND_MSG_PUB.initialize;
371: END IF;
372:

Line 374: x_return_status := FND_API.G_RET_STS_SUCCESS;

370: FND_MSG_PUB.initialize;
371: END IF;
372:
373: --* Initialize API return status to SUCCESS
374: x_return_status := FND_API.G_RET_STS_SUCCESS;
375:
376: --* logic starts here *--
377:
378: --* init l_rule_matching_rec

Line 386: p_commit => fnd_api.g_false,

382: l_rule_matching_rec.rule_input_rec := p_rule_input_rec;
383:
384: PROCESS_RULE_MATCHING(
385: p_api_version_number => p_api_version_number,
386: p_commit => fnd_api.g_false,
387: p_init_msg_list => p_init_msg_list,
388: p_validation_level => p_validation_level,
389: px_rule_matching_rec => l_rule_matching_rec,
390: x_return_status => x_return_status,

Line 395: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

391: x_msg_count => x_msg_count,
392: x_msg_data => x_msg_data
393: );
394:
395: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
396: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
397: FND_MESSAGE.Set_Name('CSD', 'CSD_RULE_MATCH_FAILED');
398: FND_MSG_PUB.Add;
399: END IF;

Line 400: RAISE FND_API.G_EXC_ERROR;

396: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
397: FND_MESSAGE.Set_Name('CSD', 'CSD_RULE_MATCH_FAILED');
398: FND_MSG_PUB.Add;
399: END IF;
400: RAISE FND_API.G_EXC_ERROR;
401: END IF; --* end IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) *--
402:
403: l_tbl_count := l_rule_matching_rec.RULE_RESULTS_TBL.COUNT;
404:

Line 401: END IF; --* end IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) *--

397: FND_MESSAGE.Set_Name('CSD', 'CSD_RULE_MATCH_FAILED');
398: FND_MSG_PUB.Add;
399: END IF;
400: RAISE FND_API.G_EXC_ERROR;
401: END IF; --* end IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) *--
402:
403: l_tbl_count := l_rule_matching_rec.RULE_RESULTS_TBL.COUNT;
404:
405: IF (l_tbl_count > 0) THEN

Line 412: p_commit => fnd_api.g_false,

408: l_ro_status_reason := l_rule_matching_rec.RULE_RESULTS_TBL(1).FLOW_STATUS_REASON_CODE;
409: l_action := l_rule_matching_rec.RULE_RESULTS_TBL(1).ACTION;
410:
411: PROCESS_SOO_RULE(p_api_version_number => p_api_version_number,
412: p_commit => fnd_api.g_false,
413: p_init_msg_list => p_init_msg_list,
414: p_validation_level => p_validation_level,
415: p_ro_flow_status_id => l_flow_status_id,
416: p_flow_status_reason_code => l_ro_status_reason,

Line 423: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

419: x_return_status => x_return_status,
420: x_msg_count => x_msg_count,
421: x_msg_data => x_msg_data);
422:
423: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
424: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
425: FND_MESSAGE.Set_Name('CSD', 'CSD_PROCESS_SOO_RULE_FAILED');
426: FND_MSG_PUB.Add;
427: END IF;

Line 428: RAISE FND_API.G_EXC_ERROR;

424: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
425: FND_MESSAGE.Set_Name('CSD', 'CSD_PROCESS_SOO_RULE_FAILED');
426: FND_MSG_PUB.Add;
427: END IF;
428: RAISE FND_API.G_EXC_ERROR;
429: END IF; --* end IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) *--
430:
431: END IF; --* end IF (l_tbl_count > 0) *--
432:

Line 429: END IF; --* end IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) *--

425: FND_MESSAGE.Set_Name('CSD', 'CSD_PROCESS_SOO_RULE_FAILED');
426: FND_MSG_PUB.Add;
427: END IF;
428: RAISE FND_API.G_EXC_ERROR;
429: END IF; --* end IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) *--
430:
431: END IF; --* end IF (l_tbl_count > 0) *--
432:
433: x_rule_id := l_default_rule_id;

Line 437: IF FND_API.To_Boolean( p_commit ) THEN

433: x_rule_id := l_default_rule_id;
434: --* logic ends here *--
435:
436: -- Standard check of p_commit.
437: IF FND_API.To_Boolean( p_commit ) THEN
438: COMMIT WORK;
439: END IF;
440:
441: x_msg_count := fnd_msg_pub.count_msg;

Line 444: WHEN FND_API.G_EXC_ERROR THEN

440:
441: x_msg_count := fnd_msg_pub.count_msg;
442:
443: EXCEPTION
444: WHEN FND_API.G_EXC_ERROR THEN
445: x_return_status := FND_API.G_RET_STS_ERROR;
446: x_msg_count := fnd_msg_pub.count_msg;
447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
448: x_return_status := FND_API.G_RET_STS_ERROR;

Line 445: x_return_status := FND_API.G_RET_STS_ERROR;

441: x_msg_count := fnd_msg_pub.count_msg;
442:
443: EXCEPTION
444: WHEN FND_API.G_EXC_ERROR THEN
445: x_return_status := FND_API.G_RET_STS_ERROR;
446: x_msg_count := fnd_msg_pub.count_msg;
447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: x_msg_count := fnd_msg_pub.count_msg;

Line 447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

443: EXCEPTION
444: WHEN FND_API.G_EXC_ERROR THEN
445: x_return_status := FND_API.G_RET_STS_ERROR;
446: x_msg_count := fnd_msg_pub.count_msg;
447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: x_msg_count := fnd_msg_pub.count_msg;
450: WHEN OTHERS THEN
451: x_return_status := FND_API.G_RET_STS_ERROR;

Line 448: x_return_status := FND_API.G_RET_STS_ERROR;

444: WHEN FND_API.G_EXC_ERROR THEN
445: x_return_status := FND_API.G_RET_STS_ERROR;
446: x_msg_count := fnd_msg_pub.count_msg;
447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: x_msg_count := fnd_msg_pub.count_msg;
450: WHEN OTHERS THEN
451: x_return_status := FND_API.G_RET_STS_ERROR;
452: x_msg_count := fnd_msg_pub.count_msg;

Line 451: x_return_status := FND_API.G_RET_STS_ERROR;

447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: x_msg_count := fnd_msg_pub.count_msg;
450: WHEN OTHERS THEN
451: x_return_status := FND_API.G_RET_STS_ERROR;
452: x_msg_count := fnd_msg_pub.count_msg;
453:
454: END SOO_DEFAULTING;
455:

Line 458: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

454: END SOO_DEFAULTING;
455:
456: PROCEDURE PROCESS_SOO_RULE(
457: p_api_version_number IN NUMBER,
458: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
459: p_commit IN VARCHAR2 := FND_API.G_FALSE,
460: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
461: p_ro_flow_status_id IN NUMBER,
462: p_flow_status_reason_code IN VARCHAR2,

Line 459: p_commit IN VARCHAR2 := FND_API.G_FALSE,

455:
456: PROCEDURE PROCESS_SOO_RULE(
457: p_api_version_number IN NUMBER,
458: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
459: p_commit IN VARCHAR2 := FND_API.G_FALSE,
460: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
461: p_ro_flow_status_id IN NUMBER,
462: p_flow_status_reason_code IN VARCHAR2,
463: p_action IN VARCHAR2,

Line 460: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

456: PROCEDURE PROCESS_SOO_RULE(
457: p_api_version_number IN NUMBER,
458: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
459: p_commit IN VARCHAR2 := FND_API.G_FALSE,
460: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
461: p_ro_flow_status_id IN NUMBER,
462: p_flow_status_reason_code IN VARCHAR2,
463: p_action IN VARCHAR2,
464: p_rule_input_rec IN CSD_RULE_INPUT_REC_TYPE,

Line 490: IF NOT FND_API.Compatible_API_Call ( G_L_API_VERSION_NUMBER,

486: BEGIN
487: SAVEPOINT PROCESS_SOO_RULE;
488:
489: --* Standard call to check for call compatibility.
490: IF NOT FND_API.Compatible_API_Call ( G_L_API_VERSION_NUMBER,
491: p_api_version_number,
492: c_API_NAME,
493: G_PKG_NAME)
494: THEN

Line 495: RAISE FND_API.G_EXC_ERROR;

491: p_api_version_number,
492: c_API_NAME,
493: G_PKG_NAME)
494: THEN
495: RAISE FND_API.G_EXC_ERROR;
496: END IF;
497:
498: --* Initialize message list if p_init_msg_list is set to TRUE.
499: IF FND_API.to_Boolean( p_init_msg_list )

Line 499: IF FND_API.to_Boolean( p_init_msg_list )

495: RAISE FND_API.G_EXC_ERROR;
496: END IF;
497:
498: --* Initialize message list if p_init_msg_list is set to TRUE.
499: IF FND_API.to_Boolean( p_init_msg_list )
500: THEN
501: FND_MSG_PUB.initialize;
502: END IF;
503:

Line 505: x_return_status := FND_API.G_RET_STS_SUCCESS;

501: FND_MSG_PUB.initialize;
502: END IF;
503:
504: --* Initialize API return status to SUCCESS
505: x_return_status := FND_API.G_RET_STS_SUCCESS;
506:
507:
508: IF p_ro_flow_status_id is not null THEN
509: select cr.object_version_number

Line 522: p_commit => fnd_api.g_false,

518:
519: l_status_upd_control_rec.check_task_wip := 'N';
520:
521: csd_repairs_pvt.update_ro_status(p_api_version => p_api_version_number,
522: p_commit => fnd_api.g_false,
523: p_init_msg_list => p_init_msg_list,
524: p_validation_level => p_validation_level,
525: x_return_status => x_return_status,
526: x_msg_count => x_msg_count,

Line 531: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

527: x_msg_data => x_msg_data,
528: p_repair_status_Rec => l_repair_status_rec,
529: p_status_control_rec => l_status_upd_control_rec,
530: x_object_version_number => x_object_version_number);
531: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
532: RAISE FND_API.G_EXC_ERROR;
533: END IF;
534: END IF;
535: IF p_action is not null THEN

Line 532: RAISE FND_API.G_EXC_ERROR;

528: p_repair_status_Rec => l_repair_status_rec,
529: p_status_control_rec => l_status_upd_control_rec,
530: x_object_version_number => x_object_version_number);
531: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
532: RAISE FND_API.G_EXC_ERROR;
533: END IF;
534: END IF;
535: IF p_action is not null THEN
536: l_sql_stmt := c_BEGIN

Line 552: IF FND_API.To_Boolean( p_commit ) THEN

548:
549: END IF;
550:
551: -- Standard check of p_commit.
552: IF FND_API.To_Boolean( p_commit ) THEN
553: COMMIT WORK;
554: END IF;
555:
556: x_msg_count := fnd_msg_pub.count_msg;

Line 559: WHEN FND_API.G_EXC_ERROR THEN

555:
556: x_msg_count := fnd_msg_pub.count_msg;
557:
558: EXCEPTION
559: WHEN FND_API.G_EXC_ERROR THEN
560: x_return_status := FND_API.G_RET_STS_ERROR;
561: x_msg_count := fnd_msg_pub.count_msg;
562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
563: x_return_status := FND_API.G_RET_STS_ERROR;

Line 560: x_return_status := FND_API.G_RET_STS_ERROR;

556: x_msg_count := fnd_msg_pub.count_msg;
557:
558: EXCEPTION
559: WHEN FND_API.G_EXC_ERROR THEN
560: x_return_status := FND_API.G_RET_STS_ERROR;
561: x_msg_count := fnd_msg_pub.count_msg;
562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
563: x_return_status := FND_API.G_RET_STS_ERROR;
564: x_msg_count := fnd_msg_pub.count_msg;

Line 562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

558: EXCEPTION
559: WHEN FND_API.G_EXC_ERROR THEN
560: x_return_status := FND_API.G_RET_STS_ERROR;
561: x_msg_count := fnd_msg_pub.count_msg;
562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
563: x_return_status := FND_API.G_RET_STS_ERROR;
564: x_msg_count := fnd_msg_pub.count_msg;
565: WHEN OTHERS THEN
566: x_return_status := FND_API.G_RET_STS_ERROR;

Line 563: x_return_status := FND_API.G_RET_STS_ERROR;

559: WHEN FND_API.G_EXC_ERROR THEN
560: x_return_status := FND_API.G_RET_STS_ERROR;
561: x_msg_count := fnd_msg_pub.count_msg;
562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
563: x_return_status := FND_API.G_RET_STS_ERROR;
564: x_msg_count := fnd_msg_pub.count_msg;
565: WHEN OTHERS THEN
566: x_return_status := FND_API.G_RET_STS_ERROR;
567: x_msg_count := fnd_msg_pub.count_msg;

Line 566: x_return_status := FND_API.G_RET_STS_ERROR;

562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
563: x_return_status := FND_API.G_RET_STS_ERROR;
564: x_msg_count := fnd_msg_pub.count_msg;
565: WHEN OTHERS THEN
566: x_return_status := FND_API.G_RET_STS_ERROR;
567: x_msg_count := fnd_msg_pub.count_msg;
568:
569: END PROCESS_SOO_RULE;
570:

Line 600: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

596: /* */
597: /*--------------------------------------------------------------------*/
598: PROCEDURE GET_DEFAULT_VALUE_FROM_RULE (
599: p_api_version_number IN NUMBER,
600: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
601: p_commit IN VARCHAR2 := FND_API.G_FALSE,
602: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
603: p_entity_attribute_type IN VARCHAR2,
604: p_entity_attribute_code IN VARCHAR2,

Line 601: p_commit IN VARCHAR2 := FND_API.G_FALSE,

597: /*--------------------------------------------------------------------*/
598: PROCEDURE GET_DEFAULT_VALUE_FROM_RULE (
599: p_api_version_number IN NUMBER,
600: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
601: p_commit IN VARCHAR2 := FND_API.G_FALSE,
602: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
603: p_entity_attribute_type IN VARCHAR2,
604: p_entity_attribute_code IN VARCHAR2,
605: p_rule_input_rec IN CSD_RULE_INPUT_REC_TYPE,

Line 602: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

598: PROCEDURE GET_DEFAULT_VALUE_FROM_RULE (
599: p_api_version_number IN NUMBER,
600: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
601: p_commit IN VARCHAR2 := FND_API.G_FALSE,
602: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
603: p_entity_attribute_type IN VARCHAR2,
604: p_entity_attribute_code IN VARCHAR2,
605: p_rule_input_rec IN CSD_RULE_INPUT_REC_TYPE,
606: x_default_value OUT NOCOPY VARCHAR2,

Line 629: IF NOT FND_API.Compatible_API_Call ( c_API_VERSION_NUMBER,

625: --* Standard Start of API savepoint
626: SAVEPOINT GET_DFLT_VAL_FROM_RULE_PVT;
627:
628: --* Standard call to check for call compatibility.
629: IF NOT FND_API.Compatible_API_Call ( c_API_VERSION_NUMBER,
630: p_api_version_number,
631: c_API_NAME,
632: G_PKG_NAME)
633: THEN

Line 634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

630: p_api_version_number,
631: c_API_NAME,
632: G_PKG_NAME)
633: THEN
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: END IF;
636:
637: --* Initialize message list if p_init_msg_list is set to TRUE.
638: IF FND_API.to_Boolean( p_init_msg_list )

Line 638: IF FND_API.to_Boolean( p_init_msg_list )

634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: END IF;
636:
637: --* Initialize message list if p_init_msg_list is set to TRUE.
638: IF FND_API.to_Boolean( p_init_msg_list )
639: THEN
640: FND_MSG_PUB.initialize;
641: END IF;
642:

Line 644: x_return_status := FND_API.G_RET_STS_SUCCESS;

640: FND_MSG_PUB.initialize;
641: END IF;
642:
643: --* Initialize API return status to SUCCESS
644: x_return_status := FND_API.G_RET_STS_SUCCESS;
645:
646: --* logic starts here *--
647:
648: /* BEGIN: Algorithm:

Line 693: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

689: --** debug starts!!
690: --dbms_output.put_line('GET_DEFAULT_VALUE_FROM_RULE -> x_return_status = ' || x_return_status);
691: --** debug ends!!
692:
693: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
694: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
695: FND_MESSAGE.Set_Name('CSD', 'CSD_RULE_MATCH_FAILED');
696: FND_MSG_PUB.Add;
697: END IF;

Line 698: RAISE FND_API.G_EXC_ERROR;

694: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
695: FND_MESSAGE.Set_Name('CSD', 'CSD_RULE_MATCH_FAILED');
696: FND_MSG_PUB.Add;
697: END IF;
698: RAISE FND_API.G_EXC_ERROR;
699: END IF; --* end IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) *--
700:
701: l_tbl_count := l_rule_matching_rec.RULE_RESULTS_TBL.COUNT;
702:

Line 699: END IF; --* end IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) *--

695: FND_MESSAGE.Set_Name('CSD', 'CSD_RULE_MATCH_FAILED');
696: FND_MSG_PUB.Add;
697: END IF;
698: RAISE FND_API.G_EXC_ERROR;
699: END IF; --* end IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) *--
700:
701: l_tbl_count := l_rule_matching_rec.RULE_RESULTS_TBL.COUNT;
702:
703: --** debug starts!!

Line 743: WHEN FND_API.G_EXC_ERROR THEN

739: p_data => x_msg_data
740: );
741:
742: EXCEPTION
743: WHEN FND_API.G_EXC_ERROR THEN
744: x_return_status := FND_API.G_RET_STS_ERROR;
745: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
746: P_API_NAME => c_API_NAME
747: ,P_PKG_NAME => G_PKG_NAME

Line 744: x_return_status := FND_API.G_RET_STS_ERROR;

740: );
741:
742: EXCEPTION
743: WHEN FND_API.G_EXC_ERROR THEN
744: x_return_status := FND_API.G_RET_STS_ERROR;
745: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
746: P_API_NAME => c_API_NAME
747: ,P_PKG_NAME => G_PKG_NAME
748: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

750: ,X_MSG_COUNT => X_MSG_COUNT
751: ,X_MSG_DATA => X_MSG_DATA
752: ,X_RETURN_STATUS => X_RETURN_STATUS);
753:
754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
755: x_return_status := FND_API.G_RET_STS_ERROR;
756: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
757: P_API_NAME => c_API_NAME
758: ,P_PKG_NAME => G_PKG_NAME

Line 755: x_return_status := FND_API.G_RET_STS_ERROR;

751: ,X_MSG_DATA => X_MSG_DATA
752: ,X_RETURN_STATUS => X_RETURN_STATUS);
753:
754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
755: x_return_status := FND_API.G_RET_STS_ERROR;
756: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
757: P_API_NAME => c_API_NAME
758: ,P_PKG_NAME => G_PKG_NAME
759: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 766: x_return_status := FND_API.G_RET_STS_ERROR;

762: ,X_MSG_DATA => X_MSG_DATA
763: ,X_RETURN_STATUS => X_RETURN_STATUS);
764:
765: WHEN OTHERS THEN
766: x_return_status := FND_API.G_RET_STS_ERROR;
767: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
768: P_API_NAME => c_API_NAME
769: ,P_PKG_NAME => G_PKG_NAME
770: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

Line 809: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

805: /* */
806: /*--------------------------------------------------------------------*/
807: PROCEDURE GET_DEFAULT_VALUE_FROM_RULE (
808: p_api_version_number IN NUMBER,
809: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
810: p_commit IN VARCHAR2 := FND_API.G_FALSE,
811: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
812: p_entity_attribute_type IN VARCHAR2,
813: p_entity_attribute_code IN VARCHAR2,

Line 810: p_commit IN VARCHAR2 := FND_API.G_FALSE,

806: /*--------------------------------------------------------------------*/
807: PROCEDURE GET_DEFAULT_VALUE_FROM_RULE (
808: p_api_version_number IN NUMBER,
809: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
810: p_commit IN VARCHAR2 := FND_API.G_FALSE,
811: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
812: p_entity_attribute_type IN VARCHAR2,
813: p_entity_attribute_code IN VARCHAR2,
814: p_rule_input_rec IN CSD_RULE_INPUT_REC_TYPE,

Line 811: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

807: PROCEDURE GET_DEFAULT_VALUE_FROM_RULE (
808: p_api_version_number IN NUMBER,
809: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
810: p_commit IN VARCHAR2 := FND_API.G_FALSE,
811: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
812: p_entity_attribute_type IN VARCHAR2,
813: p_entity_attribute_code IN VARCHAR2,
814: p_rule_input_rec IN CSD_RULE_INPUT_REC_TYPE,
815: x_default_value OUT NOCOPY NUMBER,

Line 852: WHEN FND_API.G_EXC_ERROR THEN

848: x_default_value := to_number(l_default_val_str);
849:
850: --* logic ends here *--
851: EXCEPTION
852: WHEN FND_API.G_EXC_ERROR THEN
853: x_return_status := FND_API.G_RET_STS_ERROR;
854: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
855: P_API_NAME => c_API_NAME
856: ,P_PKG_NAME => G_PKG_NAME

Line 853: x_return_status := FND_API.G_RET_STS_ERROR;

849:
850: --* logic ends here *--
851: EXCEPTION
852: WHEN FND_API.G_EXC_ERROR THEN
853: x_return_status := FND_API.G_RET_STS_ERROR;
854: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
855: P_API_NAME => c_API_NAME
856: ,P_PKG_NAME => G_PKG_NAME
857: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

859: ,X_MSG_COUNT => X_MSG_COUNT
860: ,X_MSG_DATA => X_MSG_DATA
861: ,X_RETURN_STATUS => X_RETURN_STATUS);
862:
863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
864: x_return_status := FND_API.G_RET_STS_ERROR;
865: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
866: P_API_NAME => c_API_NAME
867: ,P_PKG_NAME => G_PKG_NAME

Line 864: x_return_status := FND_API.G_RET_STS_ERROR;

860: ,X_MSG_DATA => X_MSG_DATA
861: ,X_RETURN_STATUS => X_RETURN_STATUS);
862:
863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
864: x_return_status := FND_API.G_RET_STS_ERROR;
865: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
866: P_API_NAME => c_API_NAME
867: ,P_PKG_NAME => G_PKG_NAME
868: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 875: x_return_status := FND_API.G_RET_STS_ERROR;

871: ,X_MSG_DATA => X_MSG_DATA
872: ,X_RETURN_STATUS => X_RETURN_STATUS);
873:
874: WHEN OTHERS THEN
875: x_return_status := FND_API.G_RET_STS_ERROR;
876: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
877: P_API_NAME => c_API_NAME
878: ,P_PKG_NAME => G_PKG_NAME
879: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

Line 918: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

914: /* */
915: /*--------------------------------------------------------------------*/
916: PROCEDURE GET_DEFAULT_VALUE_FROM_RULE (
917: p_api_version_number IN NUMBER,
918: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
919: p_commit IN VARCHAR2 := FND_API.G_FALSE,
920: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
921: p_entity_attribute_type IN VARCHAR2,
922: p_entity_attribute_code IN VARCHAR2,

Line 919: p_commit IN VARCHAR2 := FND_API.G_FALSE,

915: /*--------------------------------------------------------------------*/
916: PROCEDURE GET_DEFAULT_VALUE_FROM_RULE (
917: p_api_version_number IN NUMBER,
918: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
919: p_commit IN VARCHAR2 := FND_API.G_FALSE,
920: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
921: p_entity_attribute_type IN VARCHAR2,
922: p_entity_attribute_code IN VARCHAR2,
923: p_rule_input_rec IN CSD_RULE_INPUT_REC_TYPE,

Line 920: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

916: PROCEDURE GET_DEFAULT_VALUE_FROM_RULE (
917: p_api_version_number IN NUMBER,
918: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
919: p_commit IN VARCHAR2 := FND_API.G_FALSE,
920: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
921: p_entity_attribute_type IN VARCHAR2,
922: p_entity_attribute_code IN VARCHAR2,
923: p_rule_input_rec IN CSD_RULE_INPUT_REC_TYPE,
924: x_default_value OUT NOCOPY DATE,

Line 962: WHEN FND_API.G_EXC_ERROR THEN

958:
959:
960: --* logic ends here *--
961: EXCEPTION
962: WHEN FND_API.G_EXC_ERROR THEN
963: x_return_status := FND_API.G_RET_STS_ERROR;
964: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
965: P_API_NAME => c_API_NAME
966: ,P_PKG_NAME => G_PKG_NAME

Line 963: x_return_status := FND_API.G_RET_STS_ERROR;

959:
960: --* logic ends here *--
961: EXCEPTION
962: WHEN FND_API.G_EXC_ERROR THEN
963: x_return_status := FND_API.G_RET_STS_ERROR;
964: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
965: P_API_NAME => c_API_NAME
966: ,P_PKG_NAME => G_PKG_NAME
967: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

969: ,X_MSG_COUNT => X_MSG_COUNT
970: ,X_MSG_DATA => X_MSG_DATA
971: ,X_RETURN_STATUS => X_RETURN_STATUS);
972:
973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
974: x_return_status := FND_API.G_RET_STS_ERROR;
975: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
976: P_API_NAME => c_API_NAME
977: ,P_PKG_NAME => G_PKG_NAME

Line 974: x_return_status := FND_API.G_RET_STS_ERROR;

970: ,X_MSG_DATA => X_MSG_DATA
971: ,X_RETURN_STATUS => X_RETURN_STATUS);
972:
973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
974: x_return_status := FND_API.G_RET_STS_ERROR;
975: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
976: P_API_NAME => c_API_NAME
977: ,P_PKG_NAME => G_PKG_NAME
978: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 985: x_return_status := FND_API.G_RET_STS_ERROR;

981: ,X_MSG_DATA => X_MSG_DATA
982: ,X_RETURN_STATUS => X_RETURN_STATUS);
983:
984: WHEN OTHERS THEN
985: x_return_status := FND_API.G_RET_STS_ERROR;
986: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
987: P_API_NAME => c_API_NAME
988: ,P_PKG_NAME => G_PKG_NAME
989: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

Line 1025: l_return_val VARCHAR2(1) := Fnd_Api.G_FALSE;

1021: p_criterion IN VARCHAR2,
1022: p_rule_input_rec IN CSD_RULE_INPUT_REC_TYPE
1023: ) RETURN VARCHAR2 IS
1024: ---- local variables ----
1025: l_return_val VARCHAR2(1) := Fnd_Api.G_FALSE;
1026: l_rule_input_rec CSD_RULE_INPUT_REC_TYPE;
1027: l_number_input NUMBER := -1;
1028: l_short_string_input VARCHAR2(30) := NULL;
1029: l_repair_line_id NUMBER := NULL;

Line 1421: l_return_val VARCHAR2(1):= FND_API.G_FALSE;

1417: p_input_param IN NUMBER,
1418: p_operator IN VARCHAR2,
1419: p_criterion IN NUMBER
1420: ) RETURN VARCHAR2 IS
1421: l_return_val VARCHAR2(1):= FND_API.G_FALSE;
1422: BEGIN
1423:
1424: --** debug starts!!
1425: --dbms_output.put_line('NNN CHECK_CONDITION_MATCH_N top p_input_param = ' || p_input_param);

Line 1432: l_return_val := FND_API.G_TRUE;

1428: --** debug ends!!
1429:
1430:
1431: IF (p_operator = G_EQUALS AND p_input_param = p_criterion) THEN
1432: l_return_val := FND_API.G_TRUE;
1433: ELSIF (p_operator = G_NOT_EQUALS AND p_input_param <> p_criterion) THEN
1434: l_return_val := FND_API.G_TRUE;
1435: ELSIF (p_operator = G_LESS_THAN AND p_input_param < p_criterion) THEN
1436: l_return_val := FND_API.G_TRUE;

Line 1434: l_return_val := FND_API.G_TRUE;

1430:
1431: IF (p_operator = G_EQUALS AND p_input_param = p_criterion) THEN
1432: l_return_val := FND_API.G_TRUE;
1433: ELSIF (p_operator = G_NOT_EQUALS AND p_input_param <> p_criterion) THEN
1434: l_return_val := FND_API.G_TRUE;
1435: ELSIF (p_operator = G_LESS_THAN AND p_input_param < p_criterion) THEN
1436: l_return_val := FND_API.G_TRUE;
1437: ELSIF (p_operator = G_GREATER_THAN AND p_input_param > p_criterion) THEN
1438: l_return_val := FND_API.G_TRUE;

Line 1436: l_return_val := FND_API.G_TRUE;

1432: l_return_val := FND_API.G_TRUE;
1433: ELSIF (p_operator = G_NOT_EQUALS AND p_input_param <> p_criterion) THEN
1434: l_return_val := FND_API.G_TRUE;
1435: ELSIF (p_operator = G_LESS_THAN AND p_input_param < p_criterion) THEN
1436: l_return_val := FND_API.G_TRUE;
1437: ELSIF (p_operator = G_GREATER_THAN AND p_input_param > p_criterion) THEN
1438: l_return_val := FND_API.G_TRUE;
1439: END IF;
1440:

Line 1438: l_return_val := FND_API.G_TRUE;

1434: l_return_val := FND_API.G_TRUE;
1435: ELSIF (p_operator = G_LESS_THAN AND p_input_param < p_criterion) THEN
1436: l_return_val := FND_API.G_TRUE;
1437: ELSIF (p_operator = G_GREATER_THAN AND p_input_param > p_criterion) THEN
1438: l_return_val := FND_API.G_TRUE;
1439: END IF;
1440:
1441: --** debug starts!!
1442: --dbms_output.put_line('NNN CHECK_CONDITION_MATCH_N l_return_val = ' || l_return_val);

Line 1475: l_return_val VARCHAR2(1) := FND_API.G_FALSE;

1471: p_input_param IN VARCHAR2,
1472: p_operator IN VARCHAR2,
1473: p_criterion IN VARCHAR2
1474: ) RETURN VARCHAR2 IS
1475: l_return_val VARCHAR2(1) := FND_API.G_FALSE;
1476: BEGIN
1477: --** debug starts!!
1478: --dbms_output.put_line('VVV CHECK_CONDITION_MATCH_V top p_input_param = ' || p_input_param);
1479: --dbms_output.put_line('VVV CHECK_CONDITION_MATCH_V top p_operator = ' || p_operator);

Line 1484: l_return_val := FND_API.G_TRUE;

1480: --dbms_output.put_line('VVV CHECK_CONDITION_MATCH_V top p_criterion = ' || p_criterion);
1481: --** debug ends!!
1482:
1483: IF (p_operator = G_EQUALS AND p_input_param = p_criterion) THEN
1484: l_return_val := FND_API.G_TRUE;
1485: ELSIF (p_operator = G_NOT_EQUALS AND p_input_param <> p_criterion) THEN
1486: l_return_val := FND_API.G_TRUE;
1487: END IF;
1488:

Line 1486: l_return_val := FND_API.G_TRUE;

1482:
1483: IF (p_operator = G_EQUALS AND p_input_param = p_criterion) THEN
1484: l_return_val := FND_API.G_TRUE;
1485: ELSIF (p_operator = G_NOT_EQUALS AND p_input_param <> p_criterion) THEN
1486: l_return_val := FND_API.G_TRUE;
1487: END IF;
1488:
1489: --** debug starts!!
1490: --dbms_output.put_line('VVV CHECK_CONDITION_MATCH_V l_return_val = ' || l_return_val);

Line 1494: RETURN l_return_val; -- FND_API.G_FALSE

1490: --dbms_output.put_line('VVV CHECK_CONDITION_MATCH_V l_return_val = ' || l_return_val);
1491: --** debug ends!!
1492:
1493: --* if all of the above cases fail, then there is no match.
1494: RETURN l_return_val; -- FND_API.G_FALSE
1495: END CHECK_CONDITION_MATCH;
1496:
1497:
1498: /*--------------------------------------------------------------------*/

Line 1522: l_return_val VARCHAR2(1) := FND_API.G_FALSE;

1518: p_input_param IN DATE,
1519: p_operator IN VARCHAR2,
1520: p_criterion IN DATE
1521: ) RETURN VARCHAR2 IS
1522: l_return_val VARCHAR2(1) := FND_API.G_FALSE;
1523: BEGIN
1524: --** debug starts!!
1525: --dbms_output.put_line('DDD CHECK_CONDITION_MATCH_D top p_input_param = ' || p_input_param);
1526: --dbms_output.put_line('DDD CHECK_CONDITION_MATCH_D top p_operator = ' || p_operator);

Line 1531: l_return_val := FND_API.G_TRUE;

1527: --dbms_output.put_line('DDD CHECK_CONDITION_MATCH_D top p_criterion = ' || p_criterion);
1528: --** debug ends!!
1529:
1530: IF (p_operator = G_EQUALS AND p_input_param = p_criterion) THEN
1531: l_return_val := FND_API.G_TRUE;
1532: ELSIF (p_operator = G_NOT_EQUALS AND p_input_param <> p_criterion) THEN
1533: l_return_val := FND_API.G_TRUE;
1534: ELSIF (p_operator = G_LESS_THAN AND p_input_param < p_criterion) THEN
1535: l_return_val := FND_API.G_TRUE;

Line 1533: l_return_val := FND_API.G_TRUE;

1529:
1530: IF (p_operator = G_EQUALS AND p_input_param = p_criterion) THEN
1531: l_return_val := FND_API.G_TRUE;
1532: ELSIF (p_operator = G_NOT_EQUALS AND p_input_param <> p_criterion) THEN
1533: l_return_val := FND_API.G_TRUE;
1534: ELSIF (p_operator = G_LESS_THAN AND p_input_param < p_criterion) THEN
1535: l_return_val := FND_API.G_TRUE;
1536: ELSIF (p_operator = G_GREATER_THAN AND p_input_param > p_criterion) THEN
1537: l_return_val := FND_API.G_TRUE;

Line 1535: l_return_val := FND_API.G_TRUE;

1531: l_return_val := FND_API.G_TRUE;
1532: ELSIF (p_operator = G_NOT_EQUALS AND p_input_param <> p_criterion) THEN
1533: l_return_val := FND_API.G_TRUE;
1534: ELSIF (p_operator = G_LESS_THAN AND p_input_param < p_criterion) THEN
1535: l_return_val := FND_API.G_TRUE;
1536: ELSIF (p_operator = G_GREATER_THAN AND p_input_param > p_criterion) THEN
1537: l_return_val := FND_API.G_TRUE;
1538: END IF;
1539:

Line 1537: l_return_val := FND_API.G_TRUE;

1533: l_return_val := FND_API.G_TRUE;
1534: ELSIF (p_operator = G_LESS_THAN AND p_input_param < p_criterion) THEN
1535: l_return_val := FND_API.G_TRUE;
1536: ELSIF (p_operator = G_GREATER_THAN AND p_input_param > p_criterion) THEN
1537: l_return_val := FND_API.G_TRUE;
1538: END IF;
1539:
1540: --** debug starts!!
1541: --dbms_output.put_line('DDD CHECK_CONDITION_MATCH_D l_return_val_D = ' || l_return_val);

Line 1545: RETURN l_return_val; -- FND_API.G_FALSE

1541: --dbms_output.put_line('DDD CHECK_CONDITION_MATCH_D l_return_val_D = ' || l_return_val);
1542: --** debug ends!!
1543:
1544: --* if all of the above cases fail, then there is no match.
1545: RETURN l_return_val; -- FND_API.G_FALSE
1546: END CHECK_CONDITION_MATCH;
1547:
1548:
1549: /*--------------------------------------------------------------------*/

Line 1841: IF (p_value_type IS NULL) OR (p_value_type = FND_API.G_MISS_CHAR) --* bulletin rules does not specify this value

1837: l_return_val := NULL;
1838: END IF; --*end IF (p_attribute_type = G_ATTR_TYPE_RO) ...*--
1839:
1840: ELSE
1841: IF (p_value_type IS NULL) OR (p_value_type = FND_API.G_MISS_CHAR) --* bulletin rules does not specify this value
1842: OR (p_value_type = G_VALUE_TYPE_ATTRIBUTE) THEN
1843: l_return_val := p_defaulting_value;
1844: ELSIF (p_value_type = G_VALUE_TYPE_PROFILE) THEN
1845: l_return_val := FND_PROFILE.VALUE(p_defaulting_value);

Line 1970: l_return_val VARCHAR2(1) := FND_API.G_FALSE;

1966: and organization_id = cs_std.get_item_valdn_orgzn_id;
1967:
1968: -- variables --
1969: l_item_is_in_cat VARCHAR2(1);
1970: l_return_val VARCHAR2(1) := FND_API.G_FALSE;
1971:
1972: BEGIN
1973: OPEN cur_is_item_in_cat (p_ro_item_id, p_criterion);
1974: FETCH cur_is_item_in_cat into l_item_is_in_cat;

Line 1980: l_return_val := FND_API.G_FALSE;

1976:
1977: CASE p_operator
1978: when G_EQUALS then
1979: if (l_item_is_in_cat is null) then
1980: l_return_val := FND_API.G_FALSE;
1981: else
1982: l_return_val := FND_API.G_TRUE;
1983: end if;
1984: when G_NOT_EQUALS then

Line 1982: l_return_val := FND_API.G_TRUE;

1978: when G_EQUALS then
1979: if (l_item_is_in_cat is null) then
1980: l_return_val := FND_API.G_FALSE;
1981: else
1982: l_return_val := FND_API.G_TRUE;
1983: end if;
1984: when G_NOT_EQUALS then
1985: if (l_item_is_in_cat is null) then
1986: l_return_val := FND_API.G_TRUE;

Line 1986: l_return_val := FND_API.G_TRUE;

1982: l_return_val := FND_API.G_TRUE;
1983: end if;
1984: when G_NOT_EQUALS then
1985: if (l_item_is_in_cat is null) then
1986: l_return_val := FND_API.G_TRUE;
1987: else
1988: l_return_val := FND_API.G_FALSE;
1989: end if;
1990: else

Line 1988: l_return_val := FND_API.G_FALSE;

1984: when G_NOT_EQUALS then
1985: if (l_item_is_in_cat is null) then
1986: l_return_val := FND_API.G_TRUE;
1987: else
1988: l_return_val := FND_API.G_FALSE;
1989: end if;
1990: else
1991: l_return_val := FND_API.G_FALSE;
1992: END CASE;

Line 1991: l_return_val := FND_API.G_FALSE;

1987: else
1988: l_return_val := FND_API.G_FALSE;
1989: end if;
1990: else
1991: l_return_val := FND_API.G_FALSE;
1992: END CASE;
1993: return l_return_val;
1994:
1995: END CHECK_RO_ITEM_CATEGORY;

Line 2020: l_return_val VARCHAR2(1) := FND_API.G_FALSE;

2016: p_operator IN VARCHAR2,
2017: p_criterion IN VARCHAR2
2018: ) RETURN VARCHAR2 IS
2019: ---- local variables ----
2020: l_return_val VARCHAR2(1) := FND_API.G_FALSE;
2021: l_number_input NUMBER := NULL;
2022: l_date_field DATE := NULL;
2023:
2024: ---- cursors ----

Line 2040: IF (l_date_field IS NOT NULL) AND (l_date_field <> FND_API.G_MISS_DATE) THEN

2036: --** debug starts!!
2037: --dbms_output.put_line('=== CHECK_PROMISE_DATE , l_date_field = ' || l_date_field);
2038: --** debug ends!!
2039:
2040: IF (l_date_field IS NOT NULL) AND (l_date_field <> FND_API.G_MISS_DATE) THEN
2041: l_number_input := l_date_field - sysdate;
2042: l_return_val := CHECK_CONDITION_MATCH(p_input_param => l_number_input,
2043: p_operator => p_operator,
2044: p_criterion => to_number(p_criterion));

Line 2074: l_return_val VARCHAR2(1) := FND_API.G_FALSE;

2070: p_operator IN VARCHAR2,
2071: p_criterion IN VARCHAR2
2072: ) RETURN VARCHAR2 IS
2073: ---- local variables ----
2074: l_return_val VARCHAR2(1) := FND_API.G_FALSE;
2075: l_number_input NUMBER := NULL;
2076: l_date_field DATE := NULL;
2077: ---- cursors ----
2078: CURSOR cur_get_resolve_by_date(p_repair_line_id NUMBER) IS

Line 2094: IF (l_date_field IS NOT NULL) AND (l_date_field <> FND_API.G_MISS_DATE) THEN

2090: --** debug starts!!
2091: --dbms_output.put_line('==== CHECK_RESOLVE_BY_DATE , l_date_field = ' || l_date_field);
2092: --** debug ends!!
2093:
2094: IF (l_date_field IS NOT NULL) AND (l_date_field <> FND_API.G_MISS_DATE) THEN
2095: l_number_input := l_date_field - sysdate; --get # days for sysdate resolve by date
2096: l_return_val := CHECK_CONDITION_MATCH(p_input_param => l_number_input,
2097: p_operator => p_operator,
2098: p_criterion => to_number(p_criterion));

Line 2137: l_return_val VARCHAR2(1) := FND_API.G_FALSE;

2133: p_operator IN VARCHAR2,
2134: p_criterion IN VARCHAR2
2135: ) RETURN VARCHAR2 IS
2136: ---- local variables ----
2137: l_return_val VARCHAR2(1) := FND_API.G_FALSE;
2138: l_number_input NUMBER := NULL;
2139: l_date_field DATE := NULL;
2140: l_prod_txn_status VARCHAR(30) := NULL;
2141: ---- cursors ----

Line 2162: IF (l_date_field IS NOT NULL) AND (l_date_field <> FND_API.G_MISS_DATE) THEN

2158: --** debug starts!!
2159: --dbms_output.put_line('+++ CHECK_REPEAT_REPAIR , l_date_field = ' || l_date_field);
2160: --** debug ends!!
2161:
2162: IF (l_date_field IS NOT NULL) AND (l_date_field <> FND_API.G_MISS_DATE) THEN
2163: -- swai: bug 7524870 if the line has been received, do not return a match
2164: if (l_prod_txn_status = 'RECEIVED') then
2165: l_return_val := FND_API.G_FALSE;
2166: else

Line 2165: l_return_val := FND_API.G_FALSE;

2161:
2162: IF (l_date_field IS NOT NULL) AND (l_date_field <> FND_API.G_MISS_DATE) THEN
2163: -- swai: bug 7524870 if the line has been received, do not return a match
2164: if (l_prod_txn_status = 'RECEIVED') then
2165: l_return_val := FND_API.G_FALSE;
2166: else
2167: l_number_input := l_date_field - sysdate;
2168: l_return_val := CHECK_CONDITION_MATCH(p_input_param => l_number_input,
2169: p_operator => p_operator,

Line 2205: l_return_val VARCHAR2(1) := FND_API.G_FALSE;

2201: p_operator IN VARCHAR2,
2202: p_criterion IN VARCHAR2
2203: ) RETURN VARCHAR2 IS
2204: ---- local variables ----
2205: l_return_val VARCHAR2(1) := FND_API.G_FALSE;
2206: l_number_input NUMBER := NULL;
2207: l_date_field DATE := NULL;
2208: l_creation_date DATE := NULL;
2209: l_instance_id NUMBER := NULL;

Line 2230: IF (l_creation_date IS NOT NULL) AND (l_creation_date <> FND_API.G_MISS_DATE) THEN

2226: OPEN cur_get_creation_date (p_repair_line_id);
2227: FETCH cur_get_creation_date INTO l_creation_date;
2228: CLOSE cur_get_creation_date;
2229:
2230: IF (l_creation_date IS NOT NULL) AND (l_creation_date <> FND_API.G_MISS_DATE) THEN
2231: l_instance_id := GET_RO_INSTANCE_ID(p_repair_line_id);
2232:
2233: IF (l_instance_id IS NOT NULL) AND (l_instance_id <> FND_API.G_MISS_NUM) THEN
2234: -- found instance id, so get latest repair date

Line 2233: IF (l_instance_id IS NOT NULL) AND (l_instance_id <> FND_API.G_MISS_NUM) THEN

2229:
2230: IF (l_creation_date IS NOT NULL) AND (l_creation_date <> FND_API.G_MISS_DATE) THEN
2231: l_instance_id := GET_RO_INSTANCE_ID(p_repair_line_id);
2232:
2233: IF (l_instance_id IS NOT NULL) AND (l_instance_id <> FND_API.G_MISS_NUM) THEN
2234: -- found instance id, so get latest repair date
2235: OPEN cur_get_latest_repair_date(l_instance_id);
2236: FETCH cur_get_latest_repair_date INTO l_date_field;
2237: CLOSE cur_get_latest_repair_date;

Line 2243: IF (l_date_field IS NOT NULL) AND (l_date_field <> FND_API.G_MISS_DATE) THEN

2239: --** debug starts!!
2240: --dbms_output.put_line('+++ CHECK_REPEAT_REPAIR , l_date_field = ' || l_date_field);
2241: --** debug ends!!
2242:
2243: IF (l_date_field IS NOT NULL) AND (l_date_field <> FND_API.G_MISS_DATE) THEN
2244: l_number_input := sysdate - l_date_field;
2245: l_return_val := CHECK_CONDITION_MATCH(p_input_param => l_number_input,
2246: p_operator => p_operator,
2247: p_criterion => to_number(p_criterion));

Line 2283: l_return_val VARCHAR2(1) := FND_API.G_FALSE;

2279: p_operator IN VARCHAR2,
2280: p_criterion IN VARCHAR2
2281: )RETURN VARCHAR2 IS
2282: ---- local variables ----
2283: l_return_val VARCHAR2(1) := FND_API.G_FALSE;
2284: l_number_input NUMBER := NULL;
2285: l_instance_id NUMBER := NULL;
2286: l_period NUMBER := NULL;
2287:

Line 2308: IF (l_instance_id IS NOT NULL) AND (l_instance_id <> FND_API.G_MISS_NUM) THEN

2304: --dbms_output.put_line('+++>> CHECK_CHRONIC_REPAIR , l_period = ' || l_period);
2305: --** debug ends!!
2306:
2307: l_instance_id := GET_RO_INSTANCE_ID(p_repair_line_id);
2308: IF (l_instance_id IS NOT NULL) AND (l_instance_id <> FND_API.G_MISS_NUM) THEN
2309: --* found instance id, so get the number of repairs in period
2310: OPEN cur_get_chronic_repairs(l_instance_id, l_period);
2311: FETCH cur_get_chronic_repairs into l_number_input;
2312: CLOSE cur_get_chronic_repairs;

Line 2348: l_return_val VARCHAR2(1) := FND_API.G_FALSE;

2344: p_operator IN VARCHAR2,
2345: p_criterion IN VARCHAR2
2346: ) RETURN VARCHAR2 IS
2347: ---- local variables ----
2348: l_return_val VARCHAR2(1) := FND_API.G_FALSE;
2349: l_number_input NUMBER := NULL;
2350: l_ro_contract_id NUMBER := NULL;
2351:
2352: l_return_status VARCHAR2(1) := NULL;

Line 2383: IF (l_ro_contract_id IS NOT NULL) AND (l_ro_contract_id <> FND_API.G_MISS_NUM) THEN

2379: --** debug starts!!
2380: --dbms_output.put_line('+++-- CHECK_CONTRACT_EXP_DATE , l_ro_contract_id = ' || l_ro_contract_id);
2381: --** debug ends!!
2382:
2383: IF (l_ro_contract_id IS NOT NULL) AND (l_ro_contract_id <> FND_API.G_MISS_NUM) THEN
2384: OPEN cur_get_contract_end_date (l_ro_contract_id);
2385: FETCH cur_get_contract_end_date INTO l_contract_end_date;
2386: CLOSE cur_get_contract_end_date;
2387:

Line 2393: IF (l_contract_end_date IS NOT NULL) AND (l_contract_end_date <> FND_API.G_MISS_DATE) THEN

2389: --dbms_output.put_line('+++-- CHECK_CONTRACT_EXP_DATE , l_contract_end_date = ' || l_contract_end_date);
2390: --** debug ends!!
2391:
2392:
2393: IF (l_contract_end_date IS NOT NULL) AND (l_contract_end_date <> FND_API.G_MISS_DATE) THEN
2394: l_number_input := l_contract_end_date - sysdate;
2395: l_return_val := CHECK_CONDITION_MATCH(p_input_param => l_number_input,
2396: p_operator => p_operator,
2397: p_criterion => to_number(p_criterion));

Line 2442: IF ( cur_get_instance_id%NOTFOUND) OR (l_instance_id IS NULL) OR (l_instance_Id = FND_API.G_MISS_NUM) THEN -- no instance, do nothing

2438: IF (p_repair_Line_id IS NOT NULL) THEN
2439: OPEN cur_get_instance_id(p_repair_line_id);
2440: FETCH cur_get_instance_id INTO l_instance_id;
2441:
2442: IF ( cur_get_instance_id%NOTFOUND) OR (l_instance_id IS NULL) OR (l_instance_Id = FND_API.G_MISS_NUM) THEN -- no instance, do nothing
2443: l_instance_id := NULL; -- force value to null
2444: END IF;
2445: CLOSE cur_get_instance_id;
2446: END IF; --* end IF (p_repair_Line_id IS NOT NULL) *--