DBA Data[Home] [Help]

APPS.PJM_INTEGRATION_PROJ_MFG dependencies on FND_MESSAGE

Line 64: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE BEFORE');

60: END;
61:
62: IF p_time_point='BEFORE_START' then
63: IF p_schedule_date-p_tolerance_days > nvl(d_task_start_date,nvl(d_proj_start_date,p_schedule_date-p_tolerance_days+1)) THEN
64: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE BEFORE');
65: --international calendar support
66: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(
67: dateval=>nvl(d_task_start_date,d_proj_start_date), calendar_aware=>2));
68: p_error_msg := FND_MESSAGE.GET;

Line 66: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(

62: IF p_time_point='BEFORE_START' then
63: IF p_schedule_date-p_tolerance_days > nvl(d_task_start_date,nvl(d_proj_start_date,p_schedule_date-p_tolerance_days+1)) THEN
64: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE BEFORE');
65: --international calendar support
66: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(
67: dateval=>nvl(d_task_start_date,d_proj_start_date), calendar_aware=>2));
68: p_error_msg := FND_MESSAGE.GET;
69: RETURN n_invalid;
70: END IF;

Line 68: p_error_msg := FND_MESSAGE.GET;

64: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE BEFORE');
65: --international calendar support
66: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(
67: dateval=>nvl(d_task_start_date,d_proj_start_date), calendar_aware=>2));
68: p_error_msg := FND_MESSAGE.GET;
69: RETURN n_invalid;
70: END IF;
71: END IF;
72:

Line 75: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE BEFORE');

71: END IF;
72:
73: IF upper(p_time_point)='BEFORE_END' then
74: IF p_schedule_date-p_tolerance_days > nvl(d_task_end_date,nvl(d_proj_end_date,p_schedule_date-p_tolerance_days+1)) THEN
75: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE BEFORE');
76: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(
77: dateval=>nvl(d_task_end_date, d_proj_end_date), calendar_aware=>2));
78: p_error_msg := FND_MESSAGE.GET;
79: RETURN n_invalid;

Line 76: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(

72:
73: IF upper(p_time_point)='BEFORE_END' then
74: IF p_schedule_date-p_tolerance_days > nvl(d_task_end_date,nvl(d_proj_end_date,p_schedule_date-p_tolerance_days+1)) THEN
75: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE BEFORE');
76: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(
77: dateval=>nvl(d_task_end_date, d_proj_end_date), calendar_aware=>2));
78: p_error_msg := FND_MESSAGE.GET;
79: RETURN n_invalid;
80: END IF;

Line 78: p_error_msg := FND_MESSAGE.GET;

74: IF p_schedule_date-p_tolerance_days > nvl(d_task_end_date,nvl(d_proj_end_date,p_schedule_date-p_tolerance_days+1)) THEN
75: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE BEFORE');
76: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(
77: dateval=>nvl(d_task_end_date, d_proj_end_date), calendar_aware=>2));
78: p_error_msg := FND_MESSAGE.GET;
79: RETURN n_invalid;
80: END IF;
81: END IF;
82:

Line 85: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE AFTER');

81: END IF;
82:
83: IF upper(p_time_point)='AFTER_START' then
84: IF p_schedule_date+p_tolerance_days < nvl(d_task_start_date,nvl(d_proj_start_date,p_schedule_date+p_tolerance_days-1)) THEN
85: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE AFTER');
86: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(
87: dateval=>nvl(d_task_start_date,d_proj_start_date), calendar_aware=>2));
88: p_error_msg := FND_MESSAGE.GET;
89: RETURN n_invalid;

Line 86: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(

82:
83: IF upper(p_time_point)='AFTER_START' then
84: IF p_schedule_date+p_tolerance_days < nvl(d_task_start_date,nvl(d_proj_start_date,p_schedule_date+p_tolerance_days-1)) THEN
85: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE AFTER');
86: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(
87: dateval=>nvl(d_task_start_date,d_proj_start_date), calendar_aware=>2));
88: p_error_msg := FND_MESSAGE.GET;
89: RETURN n_invalid;
90: END IF;

Line 88: p_error_msg := FND_MESSAGE.GET;

84: IF p_schedule_date+p_tolerance_days < nvl(d_task_start_date,nvl(d_proj_start_date,p_schedule_date+p_tolerance_days-1)) THEN
85: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE AFTER');
86: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(
87: dateval=>nvl(d_task_start_date,d_proj_start_date), calendar_aware=>2));
88: p_error_msg := FND_MESSAGE.GET;
89: RETURN n_invalid;
90: END IF;
91: END IF;
92:

Line 95: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE AFTER');

91: END IF;
92:
93: IF upper(p_time_point)='AFTER_END' then
94: IF p_schedule_date+p_tolerance_days < nvl(d_task_end_date,nvl(d_proj_end_date,p_schedule_date+p_tolerance_days-1)) THEN
95: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE AFTER');
96: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(
97: dateval=>nvl(d_task_end_date, d_proj_end_date), calendar_aware=>2));
98: p_error_msg := FND_MESSAGE.GET;
99: RETURN n_invalid;

Line 96: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(

92:
93: IF upper(p_time_point)='AFTER_END' then
94: IF p_schedule_date+p_tolerance_days < nvl(d_task_end_date,nvl(d_proj_end_date,p_schedule_date+p_tolerance_days-1)) THEN
95: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE AFTER');
96: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(
97: dateval=>nvl(d_task_end_date, d_proj_end_date), calendar_aware=>2));
98: p_error_msg := FND_MESSAGE.GET;
99: RETURN n_invalid;
100: END IF;

Line 98: p_error_msg := FND_MESSAGE.GET;

94: IF p_schedule_date+p_tolerance_days < nvl(d_task_end_date,nvl(d_proj_end_date,p_schedule_date+p_tolerance_days-1)) THEN
95: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE AFTER');
96: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(
97: dateval=>nvl(d_task_end_date, d_proj_end_date), calendar_aware=>2));
98: p_error_msg := FND_MESSAGE.GET;
99: RETURN n_invalid;
100: END IF;
101: END IF;
102:

Line 106: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE BETWEEN');

102:
103: IF upper(p_time_point)='BETWEEN' then
104: IF (p_schedule_date+p_tolerance_days < nvl(d_task_start_date,nvl(d_proj_start_date,p_schedule_date+p_tolerance_days-1)) OR
105: p_schedule_date-p_tolerance_days > nvl(d_task_end_date,nvl(d_proj_end_date,p_schedule_date-p_tolerance_days+1))) THEN
106: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE BETWEEN');
107: FND_MESSAGE.SET_TOKEN('START_DATE', FND_DATE.DATE_TO_DISPLAYDATE(
108: dateval=>nvl(d_task_start_date,d_proj_start_date), calendar_aware=>2));
109: FND_MESSAGE.SET_TOKEN('END_DATE', FND_DATE.DATE_TO_DISPLAYDATE(
110: dateval=>nvl(d_task_end_date, d_proj_end_date), calendar_aware=>2));

Line 107: FND_MESSAGE.SET_TOKEN('START_DATE', FND_DATE.DATE_TO_DISPLAYDATE(

103: IF upper(p_time_point)='BETWEEN' then
104: IF (p_schedule_date+p_tolerance_days < nvl(d_task_start_date,nvl(d_proj_start_date,p_schedule_date+p_tolerance_days-1)) OR
105: p_schedule_date-p_tolerance_days > nvl(d_task_end_date,nvl(d_proj_end_date,p_schedule_date-p_tolerance_days+1))) THEN
106: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE BETWEEN');
107: FND_MESSAGE.SET_TOKEN('START_DATE', FND_DATE.DATE_TO_DISPLAYDATE(
108: dateval=>nvl(d_task_start_date,d_proj_start_date), calendar_aware=>2));
109: FND_MESSAGE.SET_TOKEN('END_DATE', FND_DATE.DATE_TO_DISPLAYDATE(
110: dateval=>nvl(d_task_end_date, d_proj_end_date), calendar_aware=>2));
111: p_error_msg := FND_MESSAGE.GET;

Line 109: FND_MESSAGE.SET_TOKEN('END_DATE', FND_DATE.DATE_TO_DISPLAYDATE(

105: p_schedule_date-p_tolerance_days > nvl(d_task_end_date,nvl(d_proj_end_date,p_schedule_date-p_tolerance_days+1))) THEN
106: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE BETWEEN');
107: FND_MESSAGE.SET_TOKEN('START_DATE', FND_DATE.DATE_TO_DISPLAYDATE(
108: dateval=>nvl(d_task_start_date,d_proj_start_date), calendar_aware=>2));
109: FND_MESSAGE.SET_TOKEN('END_DATE', FND_DATE.DATE_TO_DISPLAYDATE(
110: dateval=>nvl(d_task_end_date, d_proj_end_date), calendar_aware=>2));
111: p_error_msg := FND_MESSAGE.GET;
112: RETURN n_invalid;
113: END IF;

Line 111: p_error_msg := FND_MESSAGE.GET;

107: FND_MESSAGE.SET_TOKEN('START_DATE', FND_DATE.DATE_TO_DISPLAYDATE(
108: dateval=>nvl(d_task_start_date,d_proj_start_date), calendar_aware=>2));
109: FND_MESSAGE.SET_TOKEN('END_DATE', FND_DATE.DATE_TO_DISPLAYDATE(
110: dateval=>nvl(d_task_end_date, d_proj_end_date), calendar_aware=>2));
111: p_error_msg := FND_MESSAGE.GET;
112: RETURN n_invalid;
113: END IF;
114: END IF;
115: