DBA Data[Home] [Help]

APPS.JTF_CAL_EXCEPTIONS_PKG dependencies on FND_MESSAGE

Line 46: --fnd_message.set_name('JTF', 'START_DATE CANNOT BE NULL');

42: p_rec NUMBER;
43: begin
44: fnd_msg_pub.initialize;
45: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_START_DATE_TIME) = FALSE THEN
46: --fnd_message.set_name('JTF', 'START_DATE CANNOT BE NULL');
47: --app_exception.raise_exception;
48: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');
49: fnd_msg_pub.add;
50:

Line 48: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');

44: fnd_msg_pub.initialize;
45: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_START_DATE_TIME) = FALSE THEN
46: --fnd_message.set_name('JTF', 'START_DATE CANNOT BE NULL');
47: --app_exception.raise_exception;
48: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');
49: fnd_msg_pub.add;
50:
51: v_error := 'Y';
52: END IF;

Line 55: --fnd_message.set_name('JTF', 'EXCEPTION CATEGORY CANNOT BE NULL');

51: v_error := 'Y';
52: END IF;
53:
54: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_EXCEPTION_CATEGORY) = FALSE THEN
55: --fnd_message.set_name('JTF', 'EXCEPTION CATEGORY CANNOT BE NULL');
56: --app_exception.raise_exception;
57: fnd_message.set_name('JTF', 'JTF_CAL_EXCEPTION_CATEGORY');
58: --fnd_message.set_token('P_Name', 'EXCEPTION_CATEGORY');
59: fnd_msg_pub.add;

Line 57: fnd_message.set_name('JTF', 'JTF_CAL_EXCEPTION_CATEGORY');

53:
54: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_EXCEPTION_CATEGORY) = FALSE THEN
55: --fnd_message.set_name('JTF', 'EXCEPTION CATEGORY CANNOT BE NULL');
56: --app_exception.raise_exception;
57: fnd_message.set_name('JTF', 'JTF_CAL_EXCEPTION_CATEGORY');
58: --fnd_message.set_token('P_Name', 'EXCEPTION_CATEGORY');
59: fnd_msg_pub.add;
60: v_error := 'Y';
61: END IF;

Line 58: --fnd_message.set_token('P_Name', 'EXCEPTION_CATEGORY');

54: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_EXCEPTION_CATEGORY) = FALSE THEN
55: --fnd_message.set_name('JTF', 'EXCEPTION CATEGORY CANNOT BE NULL');
56: --app_exception.raise_exception;
57: fnd_message.set_name('JTF', 'JTF_CAL_EXCEPTION_CATEGORY');
58: --fnd_message.set_token('P_Name', 'EXCEPTION_CATEGORY');
59: fnd_msg_pub.add;
60: v_error := 'Y';
61: END IF;
62:

Line 65: --fnd_message.set_name('JTF', 'EXCEPTION NAME CANNOT BE NULL');

61: END IF;
62:
63:
64: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_EXCEPTION_NAME) = FALSE THEN
65: --fnd_message.set_name('JTF', 'EXCEPTION NAME CANNOT BE NULL');
66: --app_exception.raise_exception;
67: fnd_message.set_name('JTF', 'JTF_CAL_EXCEPTION_NAME');
68: --fnd_message.set_token('P_Name', 'EXCEPTION_NAME');
69: fnd_msg_pub.add;

Line 67: fnd_message.set_name('JTF', 'JTF_CAL_EXCEPTION_NAME');

63:
64: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_EXCEPTION_NAME) = FALSE THEN
65: --fnd_message.set_name('JTF', 'EXCEPTION NAME CANNOT BE NULL');
66: --app_exception.raise_exception;
67: fnd_message.set_name('JTF', 'JTF_CAL_EXCEPTION_NAME');
68: --fnd_message.set_token('P_Name', 'EXCEPTION_NAME');
69: fnd_msg_pub.add;
70: v_error := 'Y';
71: END IF;

Line 68: --fnd_message.set_token('P_Name', 'EXCEPTION_NAME');

64: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_EXCEPTION_NAME) = FALSE THEN
65: --fnd_message.set_name('JTF', 'EXCEPTION NAME CANNOT BE NULL');
66: --app_exception.raise_exception;
67: fnd_message.set_name('JTF', 'JTF_CAL_EXCEPTION_NAME');
68: --fnd_message.set_token('P_Name', 'EXCEPTION_NAME');
69: fnd_msg_pub.add;
70: v_error := 'Y';
71: END IF;
72:

Line 74: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');

70: v_error := 'Y';
71: END IF;
72:
73: IF JTF_CAL_EXCEPTIONS_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_TIME, X_END_DATE_TIME) = FALSE THEN
74: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
75: --app_exception.raise_exception;
76: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
77: fnd_message.set_token('P_Start_Date', X_START_DATE_TIME);
78: fnd_message.set_token('P_End_Date', X_END_DATE_TIME);

Line 76: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');

72:
73: IF JTF_CAL_EXCEPTIONS_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_TIME, X_END_DATE_TIME) = FALSE THEN
74: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
75: --app_exception.raise_exception;
76: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
77: fnd_message.set_token('P_Start_Date', X_START_DATE_TIME);
78: fnd_message.set_token('P_End_Date', X_END_DATE_TIME);
79: fnd_msg_pub.add;
80: v_error := 'Y';

Line 77: fnd_message.set_token('P_Start_Date', X_START_DATE_TIME);

73: IF JTF_CAL_EXCEPTIONS_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_TIME, X_END_DATE_TIME) = FALSE THEN
74: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
75: --app_exception.raise_exception;
76: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
77: fnd_message.set_token('P_Start_Date', X_START_DATE_TIME);
78: fnd_message.set_token('P_End_Date', X_END_DATE_TIME);
79: fnd_msg_pub.add;
80: v_error := 'Y';
81: END IF;

Line 78: fnd_message.set_token('P_End_Date', X_END_DATE_TIME);

74: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
75: --app_exception.raise_exception;
76: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
77: fnd_message.set_token('P_Start_Date', X_START_DATE_TIME);
78: fnd_message.set_token('P_End_Date', X_END_DATE_TIME);
79: fnd_msg_pub.add;
80: v_error := 'Y';
81: END IF;
82:

Line 96: fnd_message.set_name('JTF', 'JTF_CAL_DUPLICATE');

92: nvl(end_date_time,to_date('12/31/9999','mm/dd/yyyy')) >= X_START_DATE_TIME
93: ) ;
94:
95: if p_rec > 0 then
96: fnd_message.set_name('JTF', 'JTF_CAL_DUPLICATE');
97: fnd_message.set_token('P_NAME', X_EXCEPTION_NAME);
98:
99: fnd_msg_pub.add;
100: v_error := 'Y';

Line 97: fnd_message.set_token('P_NAME', X_EXCEPTION_NAME);

93: ) ;
94:
95: if p_rec > 0 then
96: fnd_message.set_name('JTF', 'JTF_CAL_DUPLICATE');
97: fnd_message.set_token('P_NAME', X_EXCEPTION_NAME);
98:
99: fnd_msg_pub.add;
100: v_error := 'Y';
101: end if;

Line 275: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

271: open c;
272: fetch c into recinfo;
273: if (c%notfound) then
274: close c;
275: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
276: app_exception.raise_exception;
277: end if;
278: close c;
279:

Line 321: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

317: OR ((recinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null)))
318: ) then
319: null;
320: else
321: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
322: app_exception.raise_exception;
323: end if;
324:
325: for tlinfo in c1 loop

Line 334: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

330: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
331: ) then
332: null;
333: else
334: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
335: app_exception.raise_exception;
336: end if;
337: end if;
338: end loop;

Line 378: --fnd_message.set_name('JTF', 'START_DATE CANNOT BE NULL');

374: begin
375: fnd_msg_pub.initialize;
376:
377: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_START_DATE_TIME) = FALSE THEN
378: --fnd_message.set_name('JTF', 'START_DATE CANNOT BE NULL');
379: --app_exception.raise_exception;
380: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');
381: fnd_msg_pub.add;
382:

Line 380: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');

376:
377: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_START_DATE_TIME) = FALSE THEN
378: --fnd_message.set_name('JTF', 'START_DATE CANNOT BE NULL');
379: --app_exception.raise_exception;
380: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');
381: fnd_msg_pub.add;
382:
383: v_error := 'Y';
384: END IF;

Line 387: --fnd_message.set_name('JTF', 'EXCEPTION CATEGORY CANNOT BE NULL');

383: v_error := 'Y';
384: END IF;
385:
386: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_EXCEPTION_CATEGORY) = FALSE THEN
387: --fnd_message.set_name('JTF', 'EXCEPTION CATEGORY CANNOT BE NULL');
388: --app_exception.raise_exception;
389: fnd_message.set_name('JTF', 'JTF_CAL_EXCEPTION_CATEGORY');
390: --fnd_message.set_token('P_Name', 'EXCEPTION_CATEGORY');
391: fnd_msg_pub.add;

Line 389: fnd_message.set_name('JTF', 'JTF_CAL_EXCEPTION_CATEGORY');

385:
386: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_EXCEPTION_CATEGORY) = FALSE THEN
387: --fnd_message.set_name('JTF', 'EXCEPTION CATEGORY CANNOT BE NULL');
388: --app_exception.raise_exception;
389: fnd_message.set_name('JTF', 'JTF_CAL_EXCEPTION_CATEGORY');
390: --fnd_message.set_token('P_Name', 'EXCEPTION_CATEGORY');
391: fnd_msg_pub.add;
392: v_error := 'Y';
393: END IF;

Line 390: --fnd_message.set_token('P_Name', 'EXCEPTION_CATEGORY');

386: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_EXCEPTION_CATEGORY) = FALSE THEN
387: --fnd_message.set_name('JTF', 'EXCEPTION CATEGORY CANNOT BE NULL');
388: --app_exception.raise_exception;
389: fnd_message.set_name('JTF', 'JTF_CAL_EXCEPTION_CATEGORY');
390: --fnd_message.set_token('P_Name', 'EXCEPTION_CATEGORY');
391: fnd_msg_pub.add;
392: v_error := 'Y';
393: END IF;
394:

Line 397: --fnd_message.set_name('JTF', 'EXCEPTION NAME CANNOT BE NULL');

393: END IF;
394:
395:
396: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_EXCEPTION_NAME) = FALSE THEN
397: --fnd_message.set_name('JTF', 'EXCEPTION NAME CANNOT BE NULL');
398: --app_exception.raise_exception;
399: fnd_message.set_name('JTF', 'JTF_CAL_EXCEPTION_NAME');
400: --fnd_message.set_token('P_Name', 'EXCEPTION_NAME');
401: fnd_msg_pub.add;

Line 399: fnd_message.set_name('JTF', 'JTF_CAL_EXCEPTION_NAME');

395:
396: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_EXCEPTION_NAME) = FALSE THEN
397: --fnd_message.set_name('JTF', 'EXCEPTION NAME CANNOT BE NULL');
398: --app_exception.raise_exception;
399: fnd_message.set_name('JTF', 'JTF_CAL_EXCEPTION_NAME');
400: --fnd_message.set_token('P_Name', 'EXCEPTION_NAME');
401: fnd_msg_pub.add;
402: v_error := 'Y';
403: END IF;

Line 400: --fnd_message.set_token('P_Name', 'EXCEPTION_NAME');

396: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_EXCEPTION_NAME) = FALSE THEN
397: --fnd_message.set_name('JTF', 'EXCEPTION NAME CANNOT BE NULL');
398: --app_exception.raise_exception;
399: fnd_message.set_name('JTF', 'JTF_CAL_EXCEPTION_NAME');
400: --fnd_message.set_token('P_Name', 'EXCEPTION_NAME');
401: fnd_msg_pub.add;
402: v_error := 'Y';
403: END IF;
404:

Line 406: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');

402: v_error := 'Y';
403: END IF;
404:
405: IF JTF_CAL_EXCEPTIONS_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_TIME, X_END_DATE_TIME) = FALSE THEN
406: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
407: --app_exception.raise_exception;
408: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
409: fnd_message.set_token('P_Start_Date', X_START_DATE_TIME);
410: fnd_message.set_token('P_End_Date', X_END_DATE_TIME);

Line 408: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');

404:
405: IF JTF_CAL_EXCEPTIONS_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_TIME, X_END_DATE_TIME) = FALSE THEN
406: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
407: --app_exception.raise_exception;
408: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
409: fnd_message.set_token('P_Start_Date', X_START_DATE_TIME);
410: fnd_message.set_token('P_End_Date', X_END_DATE_TIME);
411: fnd_msg_pub.add;
412: v_error := 'Y';

Line 409: fnd_message.set_token('P_Start_Date', X_START_DATE_TIME);

405: IF JTF_CAL_EXCEPTIONS_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_TIME, X_END_DATE_TIME) = FALSE THEN
406: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
407: --app_exception.raise_exception;
408: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
409: fnd_message.set_token('P_Start_Date', X_START_DATE_TIME);
410: fnd_message.set_token('P_End_Date', X_END_DATE_TIME);
411: fnd_msg_pub.add;
412: v_error := 'Y';
413: END IF;

Line 410: fnd_message.set_token('P_End_Date', X_END_DATE_TIME);

406: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
407: --app_exception.raise_exception;
408: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
409: fnd_message.set_token('P_Start_Date', X_START_DATE_TIME);
410: fnd_message.set_token('P_End_Date', X_END_DATE_TIME);
411: fnd_msg_pub.add;
412: v_error := 'Y';
413: END IF;
414:

Line 428: fnd_message.set_name('JTF', 'JTF_CAL_DUPLICATE');

424: )
425: AND exception_id <> X_EXCEPTION_ID;
426:
427: if p_rec > 0 then
428: fnd_message.set_name('JTF', 'JTF_CAL_DUPLICATE');
429: fnd_message.set_token('P_NAME', X_EXCEPTION_NAME);
430: fnd_msg_pub.add;
431: v_error := 'Y';
432: end if;

Line 429: fnd_message.set_token('P_NAME', X_EXCEPTION_NAME);

425: AND exception_id <> X_EXCEPTION_ID;
426:
427: if p_rec > 0 then
428: fnd_message.set_name('JTF', 'JTF_CAL_DUPLICATE');
429: fnd_message.set_token('P_NAME', X_EXCEPTION_NAME);
430: fnd_msg_pub.add;
431: v_error := 'Y';
432: end if;
433: