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.OKL_SETUP_DISB_RULES_PVT dependencies on FND_API

Line 5: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

1: PACKAGE BODY OKL_SETUP_DISB_RULES_PVT AS
2: /* $Header: OKLRSDRB.pls 120.10 2007/08/17 09:35:12 gkhuntet noship $ */
3:
4: PROCEDURE validate_rule_eff_dates( p_api_version IN NUMBER
5: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
6: , x_return_status OUT NOCOPY VARCHAR2
7: , x_msg_count OUT NOCOPY NUMBER
8: , x_msg_data OUT NOCOPY VARCHAR2
9: , p_drav_rec IN drav_rec_type

Line 66: IF ((l_disb_start_date IS NOT NULL) AND (l_disb_start_date <> FND_API.G_MISS_DATE)

62:
63: ----g_debug_proc('DATE from DRAV ' || l_disb_start_date || ' ' || l_disb_end_date);
64: --DBMS_OUTPUT.PUT_LINE('Date count DRAV ' || l_disb_start_date || ' ' || l_disb_end_date);
65:
66: IF ((l_disb_start_date IS NOT NULL) AND (l_disb_start_date <> FND_API.G_MISS_DATE)
67: AND (l_disb_end_date IS NOT NULL) AND (l_disb_end_date <> FND_API.G_MISS_DATE)) THEN
68: IF (l_disb_end_date < l_disb_start_date) THEN
69: OKL_API.SET_MESSAGE( p_app_name => g_app_name
70: , p_msg_name => G_OKL_ST_DISB_EFF_DATE_ERR);

Line 67: AND (l_disb_end_date IS NOT NULL) AND (l_disb_end_date <> FND_API.G_MISS_DATE)) THEN

63: ----g_debug_proc('DATE from DRAV ' || l_disb_start_date || ' ' || l_disb_end_date);
64: --DBMS_OUTPUT.PUT_LINE('Date count DRAV ' || l_disb_start_date || ' ' || l_disb_end_date);
65:
66: IF ((l_disb_start_date IS NOT NULL) AND (l_disb_start_date <> FND_API.G_MISS_DATE)
67: AND (l_disb_end_date IS NOT NULL) AND (l_disb_end_date <> FND_API.G_MISS_DATE)) THEN
68: IF (l_disb_end_date < l_disb_start_date) THEN
69: OKL_API.SET_MESSAGE( p_app_name => g_app_name
70: , p_msg_name => G_OKL_ST_DISB_EFF_DATE_ERR);
71: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 88: IF ((l_vsite_start_date IS NOT NULL) AND (l_vsite_start_date <> FND_API.G_MISS_DATE)

84:
85: --DBMS_OUTPUT.PUT_LINE('Date count DRV ' || l_vsite_start_date || ' ' || l_vsite_end_date);
86: --DBMS_OUTPUT.PUT_LINE('Date count DRAV ' || l_disb_start_date || ' ' || l_disb_end_date);
87:
88: IF ((l_vsite_start_date IS NOT NULL) AND (l_vsite_start_date <> FND_API.G_MISS_DATE)
89: AND (l_vsite_end_date IS NOT NULL) AND (l_vsite_end_date <> FND_API.G_MISS_DATE)) THEN
90: IF (l_vsite_end_date < l_vsite_start_date) THEN
91: OKL_API.SET_MESSAGE( p_app_name => g_app_name
92: , p_msg_name => G_OKL_ST_DISB_VSITE_DATE_ERR);

Line 89: AND (l_vsite_end_date IS NOT NULL) AND (l_vsite_end_date <> FND_API.G_MISS_DATE)) THEN

85: --DBMS_OUTPUT.PUT_LINE('Date count DRV ' || l_vsite_start_date || ' ' || l_vsite_end_date);
86: --DBMS_OUTPUT.PUT_LINE('Date count DRAV ' || l_disb_start_date || ' ' || l_disb_end_date);
87:
88: IF ((l_vsite_start_date IS NOT NULL) AND (l_vsite_start_date <> FND_API.G_MISS_DATE)
89: AND (l_vsite_end_date IS NOT NULL) AND (l_vsite_end_date <> FND_API.G_MISS_DATE)) THEN
90: IF (l_vsite_end_date < l_vsite_start_date) THEN
91: OKL_API.SET_MESSAGE( p_app_name => g_app_name
92: , p_msg_name => G_OKL_ST_DISB_VSITE_DATE_ERR);
93: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 104: IF ((l_vsite_start_date IS NOT NULL) AND (l_vsite_start_date <> FND_API.G_MISS_DATE)

100: -- effective date range
101: ----g_debug_proc('Date from DRV ' || vsite_count || ' ' || l_vsite_start_date || ' ' || l_vsite_end_date);
102:
103: --DBMS_OUTPUT.PUT_LINE('DATE COUNTE ');
104: IF ((l_vsite_start_date IS NOT NULL) AND (l_vsite_start_date <> FND_API.G_MISS_DATE)
105: AND (l_vsite_start_date < l_disb_start_date)) THEN
106: OKL_API.SET_MESSAGE( p_app_name => g_app_name
107: , p_msg_name => G_OKL_ST_DISB_VSITE_DATE_ERR);
108: --g_debug_proc('1');

Line 110: ELSIF ((l_disb_end_date IS NOT NULL) AND (l_disb_end_date <> FND_API.G_MISS_DATE)

106: OKL_API.SET_MESSAGE( p_app_name => g_app_name
107: , p_msg_name => G_OKL_ST_DISB_VSITE_DATE_ERR);
108: --g_debug_proc('1');
109: RAISE OKL_API.G_EXCEPTION_ERROR;
110: ELSIF ((l_disb_end_date IS NOT NULL) AND (l_disb_end_date <> FND_API.G_MISS_DATE)
111: AND (l_vsite_start_date > l_disb_end_date)) THEN
112: OKL_API.SET_MESSAGE( p_app_name => g_app_name
113: , p_msg_name => G_OKL_ST_DISB_VSITE_DATE_ERR);
114: --g_debug_proc('2');

Line 116: ELSIF ((l_vsite_end_date IS NOT NULL) AND (l_vsite_end_date <> FND_API.G_MISS_DATE)

112: OKL_API.SET_MESSAGE( p_app_name => g_app_name
113: , p_msg_name => G_OKL_ST_DISB_VSITE_DATE_ERR);
114: --g_debug_proc('2');
115: RAISE OKL_API.G_EXCEPTION_ERROR;
116: ELSIF ((l_vsite_end_date IS NOT NULL) AND (l_vsite_end_date <> FND_API.G_MISS_DATE)
117: AND (l_vsite_end_date > l_disb_end_date)) THEN
118: OKL_API.SET_MESSAGE( p_app_name => g_app_name
119: , p_msg_name => G_OKL_ST_DISB_VSITE_DATE_ERR);
120: --g_debug_proc('3');

Line 147: IF ( (l_exist_start_date IS NOT NULL) AND (l_exist_start_date <> FND_API.G_MISS_DATE)) THEN

143: l_exist_start_date := vsite_eff_dates_rec.start_date;
144: l_exist_end_date := vsite_eff_dates_rec.end_date;
145: l_vsite_start_date := p_drv_tbl(vsite_count).start_date;
146: l_vsite_end_date := p_drv_tbl(vsite_count).end_date;
147: IF ( (l_exist_start_date IS NOT NULL) AND (l_exist_start_date <> FND_API.G_MISS_DATE)) THEN
148: IF ( (l_exist_end_date IS NOT NULL) AND (l_exist_end_date <> FND_API.G_MISS_DATE)) THEN
149: IF ( ((l_vsite_start_date IS NOT NULL) AND (l_vsite_start_date <> FND_API.G_MISS_DATE)
150: AND (l_vsite_start_date BETWEEN l_exist_start_date AND l_exist_end_date))
151: OR

Line 148: IF ( (l_exist_end_date IS NOT NULL) AND (l_exist_end_date <> FND_API.G_MISS_DATE)) THEN

144: l_exist_end_date := vsite_eff_dates_rec.end_date;
145: l_vsite_start_date := p_drv_tbl(vsite_count).start_date;
146: l_vsite_end_date := p_drv_tbl(vsite_count).end_date;
147: IF ( (l_exist_start_date IS NOT NULL) AND (l_exist_start_date <> FND_API.G_MISS_DATE)) THEN
148: IF ( (l_exist_end_date IS NOT NULL) AND (l_exist_end_date <> FND_API.G_MISS_DATE)) THEN
149: IF ( ((l_vsite_start_date IS NOT NULL) AND (l_vsite_start_date <> FND_API.G_MISS_DATE)
150: AND (l_vsite_start_date BETWEEN l_exist_start_date AND l_exist_end_date))
151: OR
152: ((l_vsite_end_date IS NOT NULL) AND (l_vsite_end_date <> FND_API.G_MISS_DATE)

Line 149: IF ( ((l_vsite_start_date IS NOT NULL) AND (l_vsite_start_date <> FND_API.G_MISS_DATE)

145: l_vsite_start_date := p_drv_tbl(vsite_count).start_date;
146: l_vsite_end_date := p_drv_tbl(vsite_count).end_date;
147: IF ( (l_exist_start_date IS NOT NULL) AND (l_exist_start_date <> FND_API.G_MISS_DATE)) THEN
148: IF ( (l_exist_end_date IS NOT NULL) AND (l_exist_end_date <> FND_API.G_MISS_DATE)) THEN
149: IF ( ((l_vsite_start_date IS NOT NULL) AND (l_vsite_start_date <> FND_API.G_MISS_DATE)
150: AND (l_vsite_start_date BETWEEN l_exist_start_date AND l_exist_end_date))
151: OR
152: ((l_vsite_end_date IS NOT NULL) AND (l_vsite_end_date <> FND_API.G_MISS_DATE)
153: AND (l_vsite_end_date BETWEEN l_exist_start_date AND l_exist_end_date)) ) THEN

Line 152: ((l_vsite_end_date IS NOT NULL) AND (l_vsite_end_date <> FND_API.G_MISS_DATE)

148: IF ( (l_exist_end_date IS NOT NULL) AND (l_exist_end_date <> FND_API.G_MISS_DATE)) THEN
149: IF ( ((l_vsite_start_date IS NOT NULL) AND (l_vsite_start_date <> FND_API.G_MISS_DATE)
150: AND (l_vsite_start_date BETWEEN l_exist_start_date AND l_exist_end_date))
151: OR
152: ((l_vsite_end_date IS NOT NULL) AND (l_vsite_end_date <> FND_API.G_MISS_DATE)
153: AND (l_vsite_end_date BETWEEN l_exist_start_date AND l_exist_end_date)) ) THEN
154: OKL_API.SET_MESSAGE( p_app_name => g_app_name
155: , p_msg_name => G_OKL_ST_DISB_VSITE_DATE_ERR);
156: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 158: ELSIF ((l_vsite_end_date IS NULL) OR (l_vsite_end_date = FND_API.G_MISS_DATE)

154: OKL_API.SET_MESSAGE( p_app_name => g_app_name
155: , p_msg_name => G_OKL_ST_DISB_VSITE_DATE_ERR);
156: RAISE OKL_API.G_EXCEPTION_ERROR;
157: END IF;
158: ELSIF ((l_vsite_end_date IS NULL) OR (l_vsite_end_date = FND_API.G_MISS_DATE)
159: OR ( l_vsite_end_date > l_exist_start_date )) THEN
160: --DBMS_OUTPUT.PUT_LINE('D2 b');
161: OKL_API.SET_MESSAGE( p_app_name => g_app_name
162: , p_msg_name => G_OKL_ST_DISB_VSITE_DATE_ERR);

Line 212: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

208: -- History : gboomina created.
209: -- End of comments
210:
211: PROCEDURE validate_sequence_range( p_api_version IN NUMBER
212: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
213: , x_return_status OUT NOCOPY VARCHAR2
214: , x_msg_count OUT NOCOPY NUMBER
215: , x_msg_data OUT NOCOPY VARCHAR2
216: , p_drv_tbl IN drv_tbl_type

Line 263: IF ((l_new_seq_start IS NOT NULL) AND (l_new_seq_start <> FND_API.G_MISS_NUM)

259: LOOP
260: l_new_seq_start := p_drv_tbl(vsite_count).invoice_seq_start;
261: l_new_seq_end := p_drv_tbl(vsite_count).invoice_seq_end;
262: -- Check whether new seq end is greater than seq start
263: IF ((l_new_seq_start IS NOT NULL) AND (l_new_seq_start <> FND_API.G_MISS_NUM)
264: AND (l_new_seq_end IS NOT NULL) AND (l_new_seq_end <> FND_API.G_MISS_NUM)
265: AND (l_new_seq_end < l_new_seq_start)) THEN
266: OKL_API.SET_MESSAGE( p_app_name => g_app_name
267: , p_msg_name => G_OKL_ST_DISB_SEQ_RANGE_ERR);

Line 264: AND (l_new_seq_end IS NOT NULL) AND (l_new_seq_end <> FND_API.G_MISS_NUM)

260: l_new_seq_start := p_drv_tbl(vsite_count).invoice_seq_start;
261: l_new_seq_end := p_drv_tbl(vsite_count).invoice_seq_end;
262: -- Check whether new seq end is greater than seq start
263: IF ((l_new_seq_start IS NOT NULL) AND (l_new_seq_start <> FND_API.G_MISS_NUM)
264: AND (l_new_seq_end IS NOT NULL) AND (l_new_seq_end <> FND_API.G_MISS_NUM)
265: AND (l_new_seq_end < l_new_seq_start)) THEN
266: OKL_API.SET_MESSAGE( p_app_name => g_app_name
267: , p_msg_name => G_OKL_ST_DISB_SEQ_RANGE_ERR);
268: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 281: IF ( (l_existing_seq_start IS NOT NULL) AND (l_existing_seq_start <> FND_API.G_MISS_NUM)) THEN

277: LOOP
278: l_existing_seq_start := vendor_site_seq_range_rec.invoice_seq_start;
279: l_existing_seq_end := vendor_site_seq_range_rec.invoice_seq_end;
280: --DBMS_OUTPUT.PUT_LINE('S2 ' || l_existing_seq_start || ' ' || l_existing_seq_end);
281: IF ( (l_existing_seq_start IS NOT NULL) AND (l_existing_seq_start <> FND_API.G_MISS_NUM)) THEN
282: IF ( (l_existing_seq_end IS NOT NULL) AND (l_existing_seq_end <> FND_API.G_MISS_NUM)) THEN
283: IF ( ((l_new_seq_start IS NOT NULL) AND (l_new_seq_start <> FND_API.G_MISS_NUM)
284: AND (l_new_seq_start BETWEEN l_existing_seq_start AND l_existing_seq_end))
285: OR

Line 282: IF ( (l_existing_seq_end IS NOT NULL) AND (l_existing_seq_end <> FND_API.G_MISS_NUM)) THEN

278: l_existing_seq_start := vendor_site_seq_range_rec.invoice_seq_start;
279: l_existing_seq_end := vendor_site_seq_range_rec.invoice_seq_end;
280: --DBMS_OUTPUT.PUT_LINE('S2 ' || l_existing_seq_start || ' ' || l_existing_seq_end);
281: IF ( (l_existing_seq_start IS NOT NULL) AND (l_existing_seq_start <> FND_API.G_MISS_NUM)) THEN
282: IF ( (l_existing_seq_end IS NOT NULL) AND (l_existing_seq_end <> FND_API.G_MISS_NUM)) THEN
283: IF ( ((l_new_seq_start IS NOT NULL) AND (l_new_seq_start <> FND_API.G_MISS_NUM)
284: AND (l_new_seq_start BETWEEN l_existing_seq_start AND l_existing_seq_end))
285: OR
286: ((l_new_seq_end IS NOT NULL) AND (l_new_seq_end <> FND_API.G_MISS_NUM)

Line 283: IF ( ((l_new_seq_start IS NOT NULL) AND (l_new_seq_start <> FND_API.G_MISS_NUM)

279: l_existing_seq_end := vendor_site_seq_range_rec.invoice_seq_end;
280: --DBMS_OUTPUT.PUT_LINE('S2 ' || l_existing_seq_start || ' ' || l_existing_seq_end);
281: IF ( (l_existing_seq_start IS NOT NULL) AND (l_existing_seq_start <> FND_API.G_MISS_NUM)) THEN
282: IF ( (l_existing_seq_end IS NOT NULL) AND (l_existing_seq_end <> FND_API.G_MISS_NUM)) THEN
283: IF ( ((l_new_seq_start IS NOT NULL) AND (l_new_seq_start <> FND_API.G_MISS_NUM)
284: AND (l_new_seq_start BETWEEN l_existing_seq_start AND l_existing_seq_end))
285: OR
286: ((l_new_seq_end IS NOT NULL) AND (l_new_seq_end <> FND_API.G_MISS_NUM)
287: AND (l_new_seq_end BETWEEN l_existing_seq_start AND l_existing_seq_end)) ) THEN

Line 286: ((l_new_seq_end IS NOT NULL) AND (l_new_seq_end <> FND_API.G_MISS_NUM)

282: IF ( (l_existing_seq_end IS NOT NULL) AND (l_existing_seq_end <> FND_API.G_MISS_NUM)) THEN
283: IF ( ((l_new_seq_start IS NOT NULL) AND (l_new_seq_start <> FND_API.G_MISS_NUM)
284: AND (l_new_seq_start BETWEEN l_existing_seq_start AND l_existing_seq_end))
285: OR
286: ((l_new_seq_end IS NOT NULL) AND (l_new_seq_end <> FND_API.G_MISS_NUM)
287: AND (l_new_seq_end BETWEEN l_existing_seq_start AND l_existing_seq_end)) ) THEN
288: OKL_API.SET_MESSAGE( p_app_name => g_app_name
289: , p_msg_name => G_OKL_ST_DISB_SEQ_OVERLAP);
290: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 292: ELSIF ((l_new_seq_end IS NULL) OR (l_new_seq_end = FND_API.G_MISS_NUM)

288: OKL_API.SET_MESSAGE( p_app_name => g_app_name
289: , p_msg_name => G_OKL_ST_DISB_SEQ_OVERLAP);
290: RAISE OKL_API.G_EXCEPTION_ERROR;
291: END IF;
292: ELSIF ((l_new_seq_end IS NULL) OR (l_new_seq_end = FND_API.G_MISS_NUM)
293: OR ( l_new_seq_end > l_existing_seq_start )) THEN
294: OKL_API.SET_MESSAGE( p_app_name => g_app_name
295: , p_msg_name => G_OKL_ST_DISB_SEQ_OVERLAP);
296: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 348: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

344: -- History : gboomina created.
345: -- End of comments
346:
347: PROCEDURE del_disb_rule_vendor_sites( p_api_version IN NUMBER
348: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
349: , x_return_status OUT NOCOPY VARCHAR2
350: , x_msg_count OUT NOCOPY NUMBER
351: , x_msg_data OUT NOCOPY VARCHAR2
352: , p_disb_rule_id IN okl_disb_rules_v.disb_rule_id%TYPE

Line 481: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

477: -- End of comments
478:
479:
480: PROCEDURE create_v_disbursement_rule( p_api_version IN NUMBER
481: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
482: , x_return_status OUT NOCOPY VARCHAR2
483: , x_msg_count OUT NOCOPY NUMBER
484: , x_msg_data OUT NOCOPY VARCHAR2
485: , p_drv_tbl IN drv_tbl_type

Line 580: IF(FND_API.G_MISS_NUM = p_drv_tbl(p_drv_tbl.FIRST).disb_rule_vendor_site_id) THEN

576: END IF;
577:
578:
579:
580: IF(FND_API.G_MISS_NUM = p_drv_tbl(p_drv_tbl.FIRST).disb_rule_vendor_site_id) THEN
581: flag :='yes';
582: ELSE
583: flag :='no';
584: END IF;

Line 837: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

833: -- History : gboomina created.
834: -- End of comments
835:
836: PROCEDURE validate_disb_rule_name( p_api_version IN NUMBER
837: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
838: , x_return_status OUT NOCOPY VARCHAR2
839: , x_msg_count OUT NOCOPY NUMBER
840: , x_msg_data OUT NOCOPY VARCHAR2
841: , p_disb_rule_name IN OKL_DISB_RULES_V.RULE_NAME%TYPE

Line 929: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

925: -- History : gboomina created.
926: -- End of comments
927:
928: PROCEDURE validate_disbursement_rule( p_api_version IN NUMBER
929: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
930: , x_return_status OUT NOCOPY VARCHAR2
931: , x_msg_count OUT NOCOPY NUMBER
932: , x_msg_data OUT NOCOPY VARCHAR2
933: , p_drav_rec IN drav_rec_type

Line 1099: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

1095: -- History : gboomina created.
1096: -- End of comments
1097:
1098: PROCEDURE create_disbursement_rule( p_api_version IN NUMBER
1099: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1100: , x_return_status OUT NOCOPY VARCHAR2
1101: , x_msg_count OUT NOCOPY NUMBER
1102: , x_msg_data OUT NOCOPY VARCHAR2
1103: , p_drav_rec IN drav_rec_type

Line 1312: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

1308: -- History : gboomina created.
1309: -- End of comments
1310:
1311: PROCEDURE delete_disb_rule_sty_types( p_api_version IN NUMBER
1312: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1313: , x_return_status OUT NOCOPY VARCHAR2
1314: , x_msg_count OUT NOCOPY NUMBER
1315: , x_msg_data OUT NOCOPY VARCHAR2
1316: , p_disb_rule_id IN okl_disb_rules_v.disb_rule_id%type

Line 1450: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

1446: -- History : gboomina created.
1447: -- End of comments
1448:
1449: PROCEDURE update_disbursement_rule( p_api_version IN NUMBER
1450: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1451: , x_return_status OUT NOCOPY VARCHAR2
1452: , x_msg_count OUT NOCOPY NUMBER
1453: , x_msg_data OUT NOCOPY VARCHAR2
1454: , p_drav_rec IN drav_rec_type