75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76:
77: IF P_STATUS_RULE_Name is NULL
78: THEN
79: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');
80: FND_MESSAGE.Set_Token('API_NAME', 'Validate_Status_Rule_Name', FALSE);
81: FND_MESSAGE.Set_Token('MISSING_PARAM', 'STATUS_RULE_NAME', FALSE);
82: FND_MSG_PUB.Add;
83: x_return_status := FND_API.G_RET_STS_ERROR;
76:
77: IF P_STATUS_RULE_Name is NULL
78: THEN
79: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');
80: FND_MESSAGE.Set_Token('API_NAME', 'Validate_Status_Rule_Name', FALSE);
81: FND_MESSAGE.Set_Token('MISSING_PARAM', 'STATUS_RULE_NAME', FALSE);
82: FND_MSG_PUB.Add;
83: x_return_status := FND_API.G_RET_STS_ERROR;
84:
77: IF P_STATUS_RULE_Name is NULL
78: THEN
79: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');
80: FND_MESSAGE.Set_Token('API_NAME', 'Validate_Status_Rule_Name', FALSE);
81: FND_MESSAGE.Set_Token('MISSING_PARAM', 'STATUS_RULE_NAME', FALSE);
82: FND_MSG_PUB.Add;
83: x_return_status := FND_API.G_RET_STS_ERROR;
84:
85: ELSE -- IF P_STATUS_RULE_Name is NULL
90: IF (C_Get_Status_Rule_Name%FOUND)
91: THEN
92: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
93: THEN
94: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');
95: FND_MESSAGE.Set_Token('COLUMN', 'STATUS_RULE_NAME', FALSE);
96: FND_MESSAGE.Set_Token('VALUE', p_status_rule_Name, FALSE);
97: FND_MSG_PUB.Add;
98: END IF;
91: THEN
92: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
93: THEN
94: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');
95: FND_MESSAGE.Set_Token('COLUMN', 'STATUS_RULE_NAME', FALSE);
96: FND_MESSAGE.Set_Token('VALUE', p_status_rule_Name, FALSE);
97: FND_MSG_PUB.Add;
98: END IF;
99: x_return_status := FND_API.G_RET_STS_ERROR;
92: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
93: THEN
94: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');
95: FND_MESSAGE.Set_Token('COLUMN', 'STATUS_RULE_NAME', FALSE);
96: FND_MESSAGE.Set_Token('VALUE', p_status_rule_Name, FALSE);
97: FND_MSG_PUB.Add;
98: END IF;
99: x_return_status := FND_API.G_RET_STS_ERROR;
100: x_dup_status := IEX_DUPLICATE_NAME;
137: x_return_status := FND_API.G_RET_STS_SUCCESS;
138:
139: IF P_STATUS_RULE_Name is NULL
140: THEN
141: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');
142: FND_MESSAGE.Set_Token('API_NAME', 'Validate_STATUS_RULE_ID_Name', FALSE);
143: FND_MESSAGE.Set_Token('MISSING_PARAM', 'STATUS_RULE_NAME', FALSE);
144: FND_MSG_PUB.Add;
145: x_return_status := FND_API.G_RET_STS_ERROR;
138:
139: IF P_STATUS_RULE_Name is NULL
140: THEN
141: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');
142: FND_MESSAGE.Set_Token('API_NAME', 'Validate_STATUS_RULE_ID_Name', FALSE);
143: FND_MESSAGE.Set_Token('MISSING_PARAM', 'STATUS_RULE_NAME', FALSE);
144: FND_MSG_PUB.Add;
145: x_return_status := FND_API.G_RET_STS_ERROR;
146:
139: IF P_STATUS_RULE_Name is NULL
140: THEN
141: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');
142: FND_MESSAGE.Set_Token('API_NAME', 'Validate_STATUS_RULE_ID_Name', FALSE);
143: FND_MESSAGE.Set_Token('MISSING_PARAM', 'STATUS_RULE_NAME', FALSE);
144: FND_MSG_PUB.Add;
145: x_return_status := FND_API.G_RET_STS_ERROR;
146:
147: ELSE -- IF P_STATUS_RULE_Name is NULL or P_STATUS_RULE_Name = FND_API.G_FALSE
152: IF (C_Get_Status_Rule_ID_Name%FOUND)
153: THEN
154: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
155: THEN
156: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');
157: FND_MESSAGE.Set_Token('COLUMN', 'STATUS_RULE_NAME', FALSE);
158: FND_MESSAGE.Set_Token('VALUE', p_status_rule_Name, FALSE);
159: FND_MSG_PUB.Add;
160: END IF;
153: THEN
154: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
155: THEN
156: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');
157: FND_MESSAGE.Set_Token('COLUMN', 'STATUS_RULE_NAME', FALSE);
158: FND_MESSAGE.Set_Token('VALUE', p_status_rule_Name, FALSE);
159: FND_MSG_PUB.Add;
160: END IF;
161: x_return_status := FND_API.G_RET_STS_ERROR;
154: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
155: THEN
156: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');
157: FND_MESSAGE.Set_Token('COLUMN', 'STATUS_RULE_NAME', FALSE);
158: FND_MESSAGE.Set_Token('VALUE', p_status_rule_Name, FALSE);
159: FND_MSG_PUB.Add;
160: END IF;
161: x_return_status := FND_API.G_RET_STS_ERROR;
162: x_dup_status := IEX_DUPLICATE_NAME;
421:
422: IF ( C_Get_STATUS_RULE_REC%NOTFOUND) THEN
423: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
424: THEN
425: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
426: FND_MESSAGE.Set_Token ('INFO', 'iex_status_rules', FALSE);
427: FND_MSG_PUB.Add;
428: END IF;
429: RAISE FND_API.G_EXC_ERROR;
422: IF ( C_Get_STATUS_RULE_REC%NOTFOUND) THEN
423: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
424: THEN
425: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
426: FND_MESSAGE.Set_Token ('INFO', 'iex_status_rules', FALSE);
427: FND_MSG_PUB.Add;
428: END IF;
429: RAISE FND_API.G_EXC_ERROR;
430: END IF;
436: IF (l_status_rule_rec.last_update_date is NULL)
437: THEN
438: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
439: THEN
440: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
441: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
442: FND_MSG_PUB.ADD;
443: END IF;
444: RAISE FND_API.G_EXC_ERROR;
437: THEN
438: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
439: THEN
440: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
441: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
442: FND_MSG_PUB.ADD;
443: END IF;
444: RAISE FND_API.G_EXC_ERROR;
445: End IF;
594:
595: IF ( C_Get_Status_Rule%NOTFOUND) THEN
596: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
597: THEN
598: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
599: FND_MESSAGE.Set_Token ('INFO', 'iex_status_rules', FALSE);
600: FND_MSG_PUB.Add;
601: END IF;
602: RAISE FND_API.G_EXC_ERROR;
595: IF ( C_Get_Status_Rule%NOTFOUND) THEN
596: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
597: THEN
598: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
599: FND_MESSAGE.Set_Token ('INFO', 'iex_status_rules', FALSE);
600: FND_MSG_PUB.Add;
601: END IF;
602: RAISE FND_API.G_EXC_ERROR;
603: END IF;
865:
866: IF ( C_Get_status_rule_line_REC%NOTFOUND) THEN
867: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
868: THEN
869: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
870: FND_MESSAGE.Set_Token ('INFO', 'iex_status_rule_lines', FALSE);
871: FND_MSG_PUB.Add;
872: END IF;
873: RAISE FND_API.G_EXC_ERROR;
866: IF ( C_Get_status_rule_line_REC%NOTFOUND) THEN
867: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
868: THEN
869: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
870: FND_MESSAGE.Set_Token ('INFO', 'iex_status_rule_lines', FALSE);
871: FND_MSG_PUB.Add;
872: END IF;
873: RAISE FND_API.G_EXC_ERROR;
874: END IF;
880: IF (l_status_rule_line_rec.last_update_date is NULL)
881: THEN
882: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
883: THEN
884: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
885: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
886: FND_MSG_PUB.ADD;
887: END IF;
888: RAISE FND_API.G_EXC_ERROR;
881: THEN
882: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
883: THEN
884: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
885: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
886: FND_MSG_PUB.ADD;
887: END IF;
888: RAISE FND_API.G_EXC_ERROR;
889: End IF;
1022:
1023: IF ( C_Get_status_rule_line%NOTFOUND) THEN
1024: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1025: THEN
1026: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
1027: FND_MESSAGE.Set_Token ('INFO', 'iex_status_rule_lines', FALSE);
1028: FND_MSG_PUB.Add;
1029: END IF;
1030: RAISE FND_API.G_EXC_ERROR;
1023: IF ( C_Get_status_rule_line%NOTFOUND) THEN
1024: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1025: THEN
1026: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
1027: FND_MESSAGE.Set_Token ('INFO', 'iex_status_rule_lines', FALSE);
1028: FND_MSG_PUB.Add;
1029: END IF;
1030: RAISE FND_API.G_EXC_ERROR;
1031: END IF;