DBA Data[Home] [Help]

APPS.AS_STATUS_PUB dependencies on FND_MESSAGE

Line 93: fnd_message.set_name('AS', 'AS_INVALID_VERSION');

89: l_api_name,
90: G_PKG_NAME
91: )
92: THEN
93: fnd_message.set_name('AS', 'AS_INVALID_VERSION');
94: fnd_msg_pub.add;
95: END IF;
96:
97: -- Initialize api return status

Line 103: fnd_message.set_name('AS', 'AS_INVALID_VERSION');

99:
100: -- Check if the version number passed is 2.0 else error out
101: IF p_api_version_number <> 2.0
102: THEN
103: fnd_message.set_name('AS', 'AS_INVALID_VERSION');
104: fnd_msg_pub.add;
105: END IF;
106:
107:

Line 116: fnd_message.set_name('AS', 'AS_ENABLED_FLAG_INVALID');

112: IF (p_status_rec.enabled_flag NOT IN ('Y','N')
113: OR p_status_rec.enabled_flag = FND_API.G_MISS_CHAR
114: OR TRIM(p_status_rec.enabled_flag) IS NULL)
115: THEN
116: fnd_message.set_name('AS', 'AS_ENABLED_FLAG_INVALID');
117: fnd_msg_pub.add;
118: END IF;
119: IF (p_status_rec.lead_flag NOT IN ('Y','N')
120: OR p_status_rec.lead_flag = FND_API.G_MISS_CHAR

Line 123: fnd_message.set_name('AS', 'AS_LEAD_FLAG_INVALID');

119: IF (p_status_rec.lead_flag NOT IN ('Y','N')
120: OR p_status_rec.lead_flag = FND_API.G_MISS_CHAR
121: OR TRIM(p_status_rec.lead_flag) IS NULL)
122: THEN
123: fnd_message.set_name('AS', 'AS_LEAD_FLAG_INVALID');
124: fnd_msg_pub.add;
125: END IF;
126: IF (p_status_rec.opp_flag NOT IN ('Y','N')
127: OR p_status_rec.opp_flag = FND_API.G_MISS_CHAR

Line 130: fnd_message.set_name('AS', 'AS_OPP_FLAG_INVALID');

126: IF (p_status_rec.opp_flag NOT IN ('Y','N')
127: OR p_status_rec.opp_flag = FND_API.G_MISS_CHAR
128: OR TRIM(p_status_rec.opp_flag) IS NULL)
129: THEN
130: fnd_message.set_name('AS', 'AS_OPP_FLAG_INVALID');
131: fnd_msg_pub.add;
132: END IF;
133: IF (p_status_rec.opp_open_status_flag NOT IN ('Y','N')
134: OR TRIM(p_status_rec.opp_open_status_flag) = FND_API.G_MISS_CHAR

Line 137: fnd_message.set_name('AS', 'AS_OPP_OPEN_FLAG_INVALID');

133: IF (p_status_rec.opp_open_status_flag NOT IN ('Y','N')
134: OR TRIM(p_status_rec.opp_open_status_flag) = FND_API.G_MISS_CHAR
135: OR TRIM(p_status_rec.opp_open_status_flag) IS NULL)
136: THEN
137: fnd_message.set_name('AS', 'AS_OPP_OPEN_FLAG_INVALID');
138: fnd_msg_pub.add;
139: END IF;
140: IF (p_status_rec.opp_decision_date_flag NOT IN ('Y','N')
141: OR p_status_rec.opp_decision_date_flag = FND_API.G_MISS_CHAR

Line 144: fnd_message.set_name('AS', 'AS_DECISION_FLAG_INVALID');

140: IF (p_status_rec.opp_decision_date_flag NOT IN ('Y','N')
141: OR p_status_rec.opp_decision_date_flag = FND_API.G_MISS_CHAR
142: OR TRIM(p_status_rec.opp_decision_date_flag) IS NULL)
143: THEN
144: fnd_message.set_name('AS', 'AS_DECISION_FLAG_INVALID');
145: fnd_msg_pub.add;
146: END IF;
147: IF (p_status_rec.forecast_rollup_flag NOT IN ('Y','N')
148: OR p_status_rec.forecast_rollup_flag = FND_API.G_MISS_CHAR

Line 151: fnd_message.set_name('AS', 'AS_FORECAST_FLAG_INVALID');

147: IF (p_status_rec.forecast_rollup_flag NOT IN ('Y','N')
148: OR p_status_rec.forecast_rollup_flag = FND_API.G_MISS_CHAR
149: OR TRIM(p_status_rec.forecast_rollup_flag) IS NULL)
150: THEN
151: fnd_message.set_name('AS', 'AS_FORECAST_FLAG_INVALID');
152: fnd_msg_pub.add;
153: END IF;
154:
155: IF (p_status_rec.win_loss_indicator NOT IN ('W','L')

Line 159: fnd_message.set_name('AS', 'AS_WIN_IND_INVALID');

155: IF (p_status_rec.win_loss_indicator NOT IN ('W','L')
156: OR p_status_rec.win_loss_indicator= FND_API.G_MISS_CHAR
157: OR TRIM(p_status_rec.win_loss_indicator) IS NULL)
158: THEN
159: fnd_message.set_name('AS', 'AS_WIN_IND_INVALID');
160: fnd_msg_pub.add;
161: END IF;
162:
163: -- Check if the required field Meaning is passed

Line 167: fnd_message.set_name('AS', 'AS_MEANING');

163: -- Check if the required field Meaning is passed
164: IF (p_status_rec.meaning = FND_API.G_MISS_CHAR
165: OR TRIM(p_status_rec.meaning) IS NULL)
166: THEN
167: fnd_message.set_name('AS', 'AS_MEANING');
168: fnd_msg_pub.add;
169: END IF;
170:
171: -- End Validation Section

Line 180: fnd_message.set_name('AS', 'AS_DUPLICATE_STATUS_CODE');

176: OPEN status_dup_cur(TRIM(NLS_UPPER(p_status_rec.status_code)));
177: FETCH status_dup_cur INTO l_count;
178: IF (status_dup_cur%FOUND)
179: THEN
180: fnd_message.set_name('AS', 'AS_DUPLICATE_STATUS_CODE');
181: fnd_message.set_token('STATUS_CODE', p_status_rec.status_code);
182: fnd_msg_pub.add;
183: CLOSE status_dup_cur;
184: END IF;

Line 181: fnd_message.set_token('STATUS_CODE', p_status_rec.status_code);

177: FETCH status_dup_cur INTO l_count;
178: IF (status_dup_cur%FOUND)
179: THEN
180: fnd_message.set_name('AS', 'AS_DUPLICATE_STATUS_CODE');
181: fnd_message.set_token('STATUS_CODE', p_status_rec.status_code);
182: fnd_msg_pub.add;
183: CLOSE status_dup_cur;
184: END IF;
185: CLOSE status_dup_cur;

Line 351: fnd_message.set_name('AS', 'AS_INVALID_WL_STATUS_COMBO');

347: p_status_rec.win_loss_indicator IS NULL)
348: OR (p_status_rec.opp_open_status_flag = 'N' AND
349: p_status_rec.win_loss_indicator IN ('W','L')))
350: THEN
351: fnd_message.set_name('AS', 'AS_INVALID_WL_STATUS_COMBO');
352: fnd_msg_pub.add;
353: END IF;
354:
355: IF (FND_MSG_PUB.COUNT_MSG > 0)

Line 357: fnd_message.set_name('AS', 'AS_STATUS_INSERT_FAILED');

353: END IF;
354:
355: IF (FND_MSG_PUB.COUNT_MSG > 0)
356: THEN
357: fnd_message.set_name('AS', 'AS_STATUS_INSERT_FAILED');
358: fnd_msg_pub.add;
359: RAISE fnd_api.g_exc_error;
360: END IF;
361:

Line 593: fnd_message.set_name('AS', 'AS_INVALID_VERSION');

589: l_api_name,
590: G_PKG_NAME
591: )
592: THEN
593: fnd_message.set_name('AS', 'AS_INVALID_VERSION');
594: fnd_msg_pub.add;
595: END IF;
596:
597: -- Initialize api return status

Line 603: fnd_message.set_name('AS', 'AS_INVALID_VERSION');

599:
600: -- Check if the version number passed is 2.0 else error out
601: IF p_api_version_number <> 2.0
602: THEN
603: fnd_message.set_name('AS', 'AS_INVALID_VERSION');
604: fnd_msg_pub.add;
605: END IF;
606:
607:

Line 671: fnd_message.set_name('AS', 'AS_WIN_IND_INVALID');

667: v_win_loss_indicator := l_win_loss_indicator;
668: ELSIF v_win_loss_indicator NOT IN ('W','L')
669: AND v_win_loss_indicator IS NOT NULL
670: THEN
671: fnd_message.set_name('AS', 'AS_WIN_IND_INVALID');
672: fnd_msg_pub.add;
673: ELSE
674: v_win_loss_indicator := p_status_rec.win_loss_indicator;
675: END IF;

Line 677: fnd_message.set_name('AS', 'AS_OPP_OPEN_FLAG_INVALID');

673: ELSE
674: v_win_loss_indicator := p_status_rec.win_loss_indicator;
675: END IF;
676: ELSE
677: fnd_message.set_name('AS', 'AS_OPP_OPEN_FLAG_INVALID');
678: fnd_msg_pub.add;
679: END IF;
680: END IF;
681:

Line 857: fnd_message.set_name('AS', 'AS_WIN_IND_INVALID');

853: -- Check for valid values being passed
854:
855: IF TRIM(p_status_rec.win_loss_indicator) NOT IN ('W','L', NULL)
856: THEN
857: fnd_message.set_name('AS', 'AS_WIN_IND_INVALID');
858: fnd_msg_pub.add;
859: ELSE
860: v_win_loss_indicator:=p_status_rec.win_loss_indicator;
861: END IF;

Line 864: fnd_message.set_name('AS', 'AS_ENABLED_FLAG_INVALID');

860: v_win_loss_indicator:=p_status_rec.win_loss_indicator;
861: END IF;
862: IF v_enabled_flag NOT IN ('Y','N')
863: THEN
864: fnd_message.set_name('AS', 'AS_ENABLED_FLAG_INVALID');
865: fnd_msg_pub.add;
866: END IF;
867: IF v_lead_flag NOT IN ('Y','N')
868: THEN

Line 869: fnd_message.set_name('AS', 'AS_LEAD_FLAG_INVALID');

865: fnd_msg_pub.add;
866: END IF;
867: IF v_lead_flag NOT IN ('Y','N')
868: THEN
869: fnd_message.set_name('AS', 'AS_LEAD_FLAG_INVALID');
870: fnd_msg_pub.add;
871: END IF;
872: IF v_opp_flag NOT IN ('Y','N')
873: THEN

Line 874: fnd_message.set_name('AS', 'AS_OPP_FLAG_INVALID');

870: fnd_msg_pub.add;
871: END IF;
872: IF v_opp_flag NOT IN ('Y','N')
873: THEN
874: fnd_message.set_name('AS', 'AS_OPP_FLAG_INVALID');
875: fnd_msg_pub.add;
876: END IF;
877: IF v_opp_decision_date_flag NOT IN ('Y','N')
878: THEN

Line 879: fnd_message.set_name('AS', 'AS_DECISION_FLAG_INVALID');

875: fnd_msg_pub.add;
876: END IF;
877: IF v_opp_decision_date_flag NOT IN ('Y','N')
878: THEN
879: fnd_message.set_name('AS', 'AS_DECISION_FLAG_INVALID');
880: fnd_msg_pub.add;
881: END IF;
882: IF v_forecast_rollup_flag NOT IN ('Y','N')
883: THEN

Line 884: fnd_message.set_name('AS', 'AS_FORECAST_FLAG_INVALID');

880: fnd_msg_pub.add;
881: END IF;
882: IF v_forecast_rollup_flag NOT IN ('Y','N')
883: THEN
884: fnd_message.set_name('AS', 'AS_FORECAST_FLAG_INVALID');
885: fnd_msg_pub.add;
886: END IF;
887:
888: -- if opp_open_status_flag is Y and win_loss_indicator IS NULL else

Line 897: fnd_message.set_name('AS', 'AS_INVALID_WL_STATUS_COMBO');

893: TRIM(v_win_loss_indicator) IS NULL)
894: OR (v_opp_open_status_flag ='N' AND
895: v_win_loss_indicator IN ('W','L')))
896: THEN
897: fnd_message.set_name('AS', 'AS_INVALID_WL_STATUS_COMBO');
898: fnd_message.set_token('WIN_LOSS_IND', p_status_rec.win_loss_indicator);
899: fnd_msg_pub.add;
900: END IF;
901:

Line 898: fnd_message.set_token('WIN_LOSS_IND', p_status_rec.win_loss_indicator);

894: OR (v_opp_open_status_flag ='N' AND
895: v_win_loss_indicator IN ('W','L')))
896: THEN
897: fnd_message.set_name('AS', 'AS_INVALID_WL_STATUS_COMBO');
898: fnd_message.set_token('WIN_LOSS_IND', p_status_rec.win_loss_indicator);
899: fnd_msg_pub.add;
900: END IF;
901:
902: IF (FND_MSG_PUB.COUNT_MSG > 0)

Line 904: fnd_message.set_name('AS', 'AS_STATUS_UPDATE_FAILED');

900: END IF;
901:
902: IF (FND_MSG_PUB.COUNT_MSG > 0)
903: THEN
904: fnd_message.set_name('AS', 'AS_STATUS_UPDATE_FAILED');
905: fnd_msg_pub.add;
906: RAISE fnd_api.g_exc_error;
907: END IF;
908:

Line 923: fnd_message.set_name('AS', 'AS_RECORD_UPDATED');

919: END IF;
920:
921: IF l_last_update_date <> l_current_last_update_date
922: THEN
923: fnd_message.set_name('AS', 'AS_RECORD_UPDATED');
924: fnd_msg_pub.add;
925: RAISE fnd_api.g_exc_error;
926: END IF;
927: