[Home] [Help]
127: sorted_list(i).mendthreshold > g_attr_max_threshold or
128: sorted_list(i).mendthreshold < g_attr_min_threshold or
129: sorted_list(i).mstartthreshold > sorted_list(i).mendthreshold ) then
130: x_return_status := fnd_api.g_ret_sts_error;
131: fnd_message.set_name('cs','CS_TP_TEMPLATE_ATTR_THRESH');
132: fnd_msg_pub.add;
133: raise fnd_api.g_exc_error;
134: elsif (sorted_list(i).mstartthreshold=0 and sorted_list(i).mendthreshold=0) then
135: null;
134: elsif (sorted_list(i).mstartthreshold=0 and sorted_list(i).mendthreshold=0) then
135: null;
136: elsif (sorted_list(i).mendthreshold >= sorted_list(i+1).mstartthreshold) then
137: x_return_status := fnd_api.g_ret_sts_error;
138: fnd_message.set_name('CS','CS_TP_TEMPLATE_ATTR_THRESH');
139: fnd_msg_pub.add;
140: raise fnd_api.g_exc_error;
141: end if;
142: end loop;
146: sorted_list(sorted_list.last).mendthreshold > g_attr_max_threshold or
147: sorted_list(sorted_list.last).mendthreshold < g_attr_min_threshold or
148: sorted_list(sorted_list.last).mstartthreshold > sorted_list(sorted_list.last).mendthreshold ) then
149: x_return_status := fnd_api.g_ret_sts_error;
150: fnd_message.set_name('CS','CS_TP_TEMPLATE_ATTR_THRESH');
151: fnd_msg_pub.add;
152: raise fnd_api.g_exc_error;
153: end if;
154: end Check_Attribute_Error;
215:
216: if p_one_template.mtemplatename is null or
217: p_one_template.mtemplatename = fnd_api.g_miss_char then
218: x_return_status := fnd_api.g_ret_sts_error;
219: fnd_message.set_name('CS','CS_TP_TEMPLATE_NAME_INVALID');
220: fnd_msg_pub.add;
221: raise fnd_api.g_exc_error;
222: end if;
223:
224: if (to_date(p_one_template.mEndDate, l_date_format))
225: < (to_date(p_one_template.mStartDate, l_date_format)) then
226: --incorrect date format, raise generic exception
227: x_return_status := fnd_api.g_ret_sts_error;
228: fnd_message.set_name('CS','CS_TP_TEMPLATE_DATE_INVALID');
229: fnd_msg_pub.add;
230: raise fnd_api.g_exc_error;
231: end if;
232:
371:
372: l_date_format := get_date_format_from_user_two;
373: IF(nvl(p_one_template.mTemplateName,fnd_api.g_miss_char)=fnd_api.g_miss_char) THEN
374: X_Return_Status := FND_API.G_RET_STS_ERROR;
375: FND_MESSAGE.SET_NAME('CS','CS_TP_TEMPLATE_NAME_INVALID');
376: FND_MSG_PUB.Add;
377: RAISE FND_API.G_EXC_ERROR;
378: END IF;
379:
378: END IF;
379:
380: IF (nvl(P_One_Template.mDefaultFlag,fnd_api.g_miss_char)=fnd_api.g_miss_char) THEN
381: X_Return_Status := FND_API.G_RET_STS_ERROR;
382: FND_MESSAGE.SET_NAME('CS','CS_TP_TEMPLATE_ATTR_INVALID');
383: FND_MSG_PUB.Add;
384: RAISE FND_API.G_EXC_ERROR;
385: END IF;
386:
386:
387: IF TO_DATE(P_One_Template.mEndDate, l_date_format)
388: < TO_DATE (P_One_Template.mStartDate, l_date_format) THEN
389: X_Return_Status := FND_API.G_RET_STS_ERROR;
390: FND_MESSAGE.SET_NAME('CS','CS_TP_TEMPLATE_DATE_INVALID');
391: FND_MSG_PUB.Add;
392: RAISE FND_API.G_EXC_ERROR;
393: END IF;
394: --check to see if the template is modified after the client's query
396: Fetch c Into l_last_updated_date;
397: If (c%notfound) Then
398: Close c;
399: X_Return_Status := FND_API.G_RET_STS_ERROR;
400: FND_MESSAGE.SET_NAME('CS','CS_TP_TEMPLATE_ID_INVALID');
401: FND_MSG_PUB.Add;
402: Raise no_data_found;
403: End If;
404: Close c;
406: If (P_One_Template.mLast_Updated_Date Is Null
407: OR length(P_One_Template.mLast_Updated_Date) <=0
408: OR P_One_Template.mLast_Updated_Date = FND_API.G_MISS_CHAR) then
409: X_Return_Status := FND_API.G_RET_STS_ERROR;
410: FND_MESSAGE.SET_NAME('CS','CS_TP_LASTUPDATE_DATE_NULL');
411: FND_MSG_PUB.Add;
412: RAISE FND_API.G_EXC_ERROR;
413: End If;
414:
417: -- is the last updated date from db later than the date from client
418: If (l_last_updated_date >
419: to_date(P_One_Template.mLast_Updated_Date, l_default_update_format2)) Then
420: X_Return_Status := FND_API.G_RET_STS_ERROR;
421: FND_MESSAGE.SET_NAME('CS','CS_TP_TEMPLATE_UPDATED');
422: FND_MSG_PUB.Add;
423: RAISE FND_API.G_EXC_ERROR;
424: End If;
425:
522: l_One_Template_Attribute := P_Template_Attributes (i);
523: If (nvl(l_One_Template_Attribute.mAttributeName,FND_API.G_MISS_CHAR)
524: = FND_API.G_MISS_CHAR) Then
525: X_Return_Status := FND_API.G_RET_STS_ERROR;
526: FND_MESSAGE.SET_NAME('CS','CS_TP_TEMPLATE_ATTR_NAME');
527: FND_MSG_PUB.Add;
528: RAISE FND_API.G_EXC_ERROR;
529: End If;
530:
533: and (l_One_Template_Attribute.mLast_Updated_Date is NULL
534: OR l_One_Template_Attribute.mLast_Updated_Date =
535: FND_API.G_MISS_CHAR)) Then
536: X_Return_Status := FND_API.G_RET_STS_ERROR;
537: FND_MESSAGE.SET_NAME('CS','CS_TP_TEM_AT_LUPD_NULL');
538: FND_MSG_PUB.Add;
539: RAISE FND_API.G_EXC_ERROR;
540: End If;
541:
551: Elsif (l_One_Template_Attribute.mAttributeID Is Null
552: OR l_One_Template_Attribute.mAttributeID = FND_API.G_MISS_NUM) Then
553: -- row is already inserted
554: X_Return_Status := FND_API.G_RET_STS_ERROR;
555: FND_MESSAGE.SET_NAME('CS','CS_TP_TEMPLATE_ATTR_UPDATED');
556: FND_MSG_PUB.Add;
557: RAISE FND_API.G_EXC_ERROR;
558: Elsif (l_last_updated_date >
559: TO_DATE (l_One_Template_Attribute.mLast_Updated_Date,
560: l_default_last_up_date_format ))
561: Then
562: -- row is already updated
563: X_Return_Status := FND_API.G_RET_STS_ERROR;
564: FND_MESSAGE.SET_NAME('CS','CS_TP_TEMPLATE_ATTR_UPDATED');
565: FND_MSG_PUB.Add;
566: RAISE FND_API.G_EXC_ERROR;
567: End If;
568: If (Last_Updated_Date_C%ISOPEN) Then
677: Fetch C Into l_template_count_with_id;
678: If (l_template_count_with_id <=0 ) Then
679: Close C;
680: X_Return_Status := FND_API.G_RET_STS_ERROR;
681: FND_MESSAGE.SET_NAME('CS','CS_TP_TEMPLATE_Link_TID_INV');
682: FND_MSG_PUB.Add;
683: Raise FND_API.G_EXC_ERROR ;
684: End If;
685: Close C;
822: -- validation
823: If (l_start_template > l_end_template
824: Or l_start_template <= 0 Or l_end_template <= 0) Then
825: X_Return_Status := FND_API.G_RET_STS_ERROR;
826: FND_MESSAGE.SET_NAME('CS','CS_TP_TEMPLATE_INQUIRY_INVALID');
827: FND_MSG_PUB.Add;
828: RAISE FND_API.G_EXC_ERROR;
829: End If;
830:
1342: Into l_SELECT_ID, l_SELECT_NAME, l_FROM_TABLE, l_where_clause, l_ORDER_BY_CLAUSE;
1343: If (JTF_OBJ_C%notfound) Then
1344: Close JTF_OBJ_C;
1345: X_Return_Status := FND_API.G_RET_STS_ERROR;
1346: FND_MESSAGE.SET_NAME('CS','CS_TP_TEMPLATE_ATTR_JTFOB');
1347: FND_MSG_PUB.Add;
1348: RAISE FND_API.G_EXC_ERROR;
1349: End If;
1350: Close JTF_OBJ_C;
1508: l_WHERE_CLAUSE, l_ORDER_BY_CLAUSE;
1509: If (JTF_OBJ_C%notfound) Then
1510: Close JTF_OBJ_C;
1511: X_Return_Status := FND_API.G_RET_STS_ERROR;
1512: FND_MESSAGE.SET_NAME('CS','CS_TP_TEMPLATE_ATTR_JTFOB');
1513: FND_MSG_PUB.Add;
1514: RAISE FND_API.G_EXC_ERROR;
1515: End If;
1516: Close JTF_OBJ_C;
1718: l_FROM_TABLE,l_WHERE_CLAUSE, l_ORDER_BY_CLAUSE;
1719: If (JTF_OBJ_C%notfound) Then
1720: Close JTF_OBJ_C;
1721: X_Return_Status := FND_API.G_RET_STS_ERROR;
1722: FND_MESSAGE.SET_NAME('CS','CS_TP_TEMPLATE_ATTR_JTFOB');
1723: FND_MSG_PUB.Add;
1724: RAISE FND_API.G_EXC_ERROR;
1725: End If;
1726: Close JTF_OBJ_C;
1906: x_return_status := FND_API.G_RET_STS_ERROR;
1907: If (JTF_OBJECT_CURSOR%ISOPEN) Then
1908: Close JTF_OBJECT_CURSOR;
1909: End If;
1910: FND_MESSAGE.SET_NAME('CS','CS_TP_Link_Iden_INVALID');
1911: FND_MSG_PUB.Add;
1912: RAISE FND_API.G_EXC_ERROR;
1913: End If;
1914:
1928: Close JTF_OBJECT_CURSOR;
1929:
1930: If (i<0) Then
1931: X_Return_Status := FND_API.G_RET_STS_ERROR;
1932: FND_MESSAGE.SET_NAME('CS','CS_TP_Link_Unseeded');
1933: FND_MSG_PUB.Add;
1934: RAISE FND_API.G_EXC_ERROR;
1935: End If;
1936:
2526: -- validation
2527: If (l_start_link > l_end_link
2528: Or l_start_link <= 0 Or l_end_link <= 0) Then
2529: X_Return_Status := FND_API.G_RET_STS_ERROR;
2530: FND_MESSAGE.SET_NAME('CS','CS_TP_TEMPLATE_LINK_INQUIRY_INVALID');
2531: FND_MSG_PUB.Add;
2532: RAISE FND_API.G_EXC_ERROR;
2533: End If;
2534:
2540: l_WHERE_CLAUSE, l_ORDER_BY_CLAUSE;
2541: If (JTF_OBJ_C%notfound) Then
2542: Close JTF_OBJ_C;
2543: X_Return_Status := FND_API.G_RET_STS_ERROR;
2544: FND_MESSAGE.SET_NAME('CS','CS_TP_TEMPLATE_ATTR_JTFOB');
2545: FND_MSG_PUB.Add;
2546: RAISE FND_API.G_EXC_ERROR;
2547: End If;
2548: Close JTF_OBJ_C;
2794: -- validation
2795: If (l_start_link > l_end_link
2796: Or l_start_link <= 0 Or l_end_link <= 0) Then
2797: X_Return_Status := FND_API.G_RET_STS_ERROR;
2798: FND_MESSAGE.SET_NAME('CS','CS_TP_TEMPLATE_LINK_INQUIRY_INVALID');
2799: FND_MSG_PUB.Add;
2800: RAISE FND_API.G_EXC_ERROR;
2801: End If;
2802:
2808: l_FROM_TABLE,l_WHERE_CLAUSE, l_ORDER_BY_CLAUSE;
2809: If (JTF_OBJ_C%notfound) Then
2810: Close JTF_OBJ_C;
2811: X_Return_Status := FND_API.G_RET_STS_ERROR;
2812: FND_MESSAGE.SET_NAME('CS','CS_TP_TEMPLATE_ATTR_JTFOB');
2813: FND_MSG_PUB.Add;
2814: RAISE FND_API.G_EXC_ERROR;
2815: End If;
2816: Close JTF_OBJ_C;
3147: Fetch C Into l_template_count_with_id;
3148: If (l_template_count_with_id <=0 ) Then
3149: Close C;
3150: X_Return_Status := FND_API.G_RET_STS_ERROR;
3151: FND_MESSAGE.SET_NAME('CS','CS_TP_TEMPLATE_Link_TID_INV');
3152: FND_MSG_PUB.Add;
3153: Raise FND_API.G_EXC_ERROR ;
3154: End If;
3155: Close C;
3218: Fetch C Into l_template_count_with_id;
3219: If (l_template_count_with_id <=0 ) Then
3220: Close C;
3221: X_Return_Status := FND_API.G_RET_STS_ERROR;
3222: FND_MESSAGE.SET_NAME('CS','CS_TP_TEMPLATE_Link_TID_INV');
3223: FND_MSG_PUB.Add;
3224: Raise FND_API.G_EXC_ERROR ;
3225: End If;
3226: Close C;