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: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(
66: nvl(d_task_start_date,d_proj_start_date)));
67: p_error_msg := FND_MESSAGE.GET;
68: RETURN n_invalid;

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

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: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(
66: nvl(d_task_start_date,d_proj_start_date)));
67: p_error_msg := FND_MESSAGE.GET;
68: RETURN n_invalid;
69: END IF;

Line 67: p_error_msg := FND_MESSAGE.GET;

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: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(
66: nvl(d_task_start_date,d_proj_start_date)));
67: p_error_msg := FND_MESSAGE.GET;
68: RETURN n_invalid;
69: END IF;
70: END IF;
71:

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

70: END IF;
71:
72: IF upper(p_time_point)='BEFORE_END' then
73: 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
74: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE BEFORE');
75: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(
76: nvl(d_task_end_date, d_proj_end_date)));
77: p_error_msg := FND_MESSAGE.GET;
78: RETURN n_invalid;

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

71:
72: IF upper(p_time_point)='BEFORE_END' then
73: 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
74: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE BEFORE');
75: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(
76: nvl(d_task_end_date, d_proj_end_date)));
77: p_error_msg := FND_MESSAGE.GET;
78: RETURN n_invalid;
79: END IF;

Line 77: p_error_msg := FND_MESSAGE.GET;

73: 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
74: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE BEFORE');
75: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(
76: nvl(d_task_end_date, d_proj_end_date)));
77: p_error_msg := FND_MESSAGE.GET;
78: RETURN n_invalid;
79: END IF;
80: END IF;
81:

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

80: END IF;
81:
82: IF upper(p_time_point)='AFTER_START' then
83: 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
84: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE AFTER');
85: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(
86: nvl(d_task_start_date,d_proj_start_date)));
87: p_error_msg := FND_MESSAGE.GET;
88: RETURN n_invalid;

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

81:
82: IF upper(p_time_point)='AFTER_START' then
83: 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
84: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE AFTER');
85: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(
86: nvl(d_task_start_date,d_proj_start_date)));
87: p_error_msg := FND_MESSAGE.GET;
88: RETURN n_invalid;
89: END IF;

Line 87: p_error_msg := FND_MESSAGE.GET;

83: 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
84: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE AFTER');
85: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(
86: nvl(d_task_start_date,d_proj_start_date)));
87: p_error_msg := FND_MESSAGE.GET;
88: RETURN n_invalid;
89: END IF;
90: END IF;
91:

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

90: END IF;
91:
92: IF upper(p_time_point)='AFTER_END' then
93: 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
94: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE AFTER');
95: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(
96: nvl(d_task_end_date, d_proj_end_date)));
97: p_error_msg := FND_MESSAGE.GET;
98: RETURN n_invalid;

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

91:
92: IF upper(p_time_point)='AFTER_END' then
93: 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
94: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE AFTER');
95: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(
96: nvl(d_task_end_date, d_proj_end_date)));
97: p_error_msg := FND_MESSAGE.GET;
98: RETURN n_invalid;
99: END IF;

Line 97: p_error_msg := FND_MESSAGE.GET;

93: 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
94: FND_MESSAGE.SET_NAME('PJM','SCHED-DATE AFTER');
95: FND_MESSAGE.SET_TOKEN('DATE', FND_DATE.DATE_TO_DISPLAYDATE(
96: nvl(d_task_end_date, d_proj_end_date)));
97: p_error_msg := FND_MESSAGE.GET;
98: RETURN n_invalid;
99: END IF;
100: END IF;
101:

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

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

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

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

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

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

Line 110: p_error_msg := FND_MESSAGE.GET;

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