eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_RM_ROUTE_PVT dependencies on FND_API

Line 27: x_return_status := FND_API.G_RET_STS_SUCCESS;

23: l_return_status VARCHAR2(1);
24: l_msg_data VARCHAR2(2000);
25:
26: BEGIN
27: x_return_status := FND_API.G_RET_STS_SUCCESS;
28:
29: -- Validate DML Operation
30: IF ( p_route_rec.dml_operation IS NULL OR
31: (

Line 40: x_return_status := FND_API.G_RET_STS_ERROR;

36: THEN
37: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML_REC' );
38: FND_MESSAGE.set_token( 'FIELD', p_route_rec.dml_operation );
39: FND_MSG_PUB.add;
40: x_return_status := FND_API.G_RET_STS_ERROR;
41: RETURN;
42: END IF;
43:
44: END validate_api_inputs;

Line 56: ELSIF ( p_x_route_rec.route_type = FND_API.G_MISS_CHAR ) THEN

52:
53: BEGIN
54: IF ( p_x_route_rec.route_type IS NULL ) THEN
55: p_x_route_rec.route_type_code := NULL;
56: ELSIF ( p_x_route_rec.route_type = FND_API.G_MISS_CHAR ) THEN
57: p_x_route_rec.route_type_code := FND_API.G_MISS_CHAR;
58: END IF;
59:
60: --bachandr Enigma Phase I changes -- start

Line 57: p_x_route_rec.route_type_code := FND_API.G_MISS_CHAR;

53: BEGIN
54: IF ( p_x_route_rec.route_type IS NULL ) THEN
55: p_x_route_rec.route_type_code := NULL;
56: ELSIF ( p_x_route_rec.route_type = FND_API.G_MISS_CHAR ) THEN
57: p_x_route_rec.route_type_code := FND_API.G_MISS_CHAR;
58: END IF;
59:
60: --bachandr Enigma Phase I changes -- start
61: IF ( p_x_route_rec.model_meaning IS NULL ) THEN

Line 63: ELSIF ( p_x_route_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN

59:
60: --bachandr Enigma Phase I changes -- start
61: IF ( p_x_route_rec.model_meaning IS NULL ) THEN
62: p_x_route_rec.model_code := NULL;
63: ELSIF ( p_x_route_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN
64: p_x_route_rec.model_code := FND_API.G_MISS_CHAR;
65: END IF;
66: --bachandr Enigma Phase I changes -- end
67:

Line 64: p_x_route_rec.model_code := FND_API.G_MISS_CHAR;

60: --bachandr Enigma Phase I changes -- start
61: IF ( p_x_route_rec.model_meaning IS NULL ) THEN
62: p_x_route_rec.model_code := NULL;
63: ELSIF ( p_x_route_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN
64: p_x_route_rec.model_code := FND_API.G_MISS_CHAR;
65: END IF;
66: --bachandr Enigma Phase I changes -- end
67:
68: --snarkhed Enigma Phase II changes --start

Line 71: ELSIF ( p_x_route_rec.job_card_lyt_meaning = FND_API.G_MISS_CHAR ) THEN

67:
68: --snarkhed Enigma Phase II changes --start
69: IF ( p_x_route_rec.job_card_lyt_meaning IS NULL ) THEN
70: p_x_route_rec.job_card_lyt_code := NULL;
71: ELSIF ( p_x_route_rec.job_card_lyt_meaning = FND_API.G_MISS_CHAR ) THEN
72: p_x_route_rec.job_card_lyt_code := FND_API.G_MISS_CHAR;
73: END IF;
74: --snarkhed Enigma Phase II changes --end
75:

Line 72: p_x_route_rec.job_card_lyt_code := FND_API.G_MISS_CHAR;

68: --snarkhed Enigma Phase II changes --start
69: IF ( p_x_route_rec.job_card_lyt_meaning IS NULL ) THEN
70: p_x_route_rec.job_card_lyt_code := NULL;
71: ELSIF ( p_x_route_rec.job_card_lyt_meaning = FND_API.G_MISS_CHAR ) THEN
72: p_x_route_rec.job_card_lyt_code := FND_API.G_MISS_CHAR;
73: END IF;
74: --snarkhed Enigma Phase II changes --end
75:
76: IF ( p_x_route_rec.process IS NULL ) THEN

Line 78: ELSIF ( p_x_route_rec.process = FND_API.G_MISS_CHAR ) THEN

74: --snarkhed Enigma Phase II changes --end
75:
76: IF ( p_x_route_rec.process IS NULL ) THEN
77: p_x_route_rec.process_code := NULL;
78: ELSIF ( p_x_route_rec.process = FND_API.G_MISS_CHAR ) THEN
79: p_x_route_rec.process_code := FND_API.G_MISS_CHAR;
80: END IF;
81:
82: IF ( p_x_route_rec.product_type IS NULL ) THEN

Line 79: p_x_route_rec.process_code := FND_API.G_MISS_CHAR;

75:
76: IF ( p_x_route_rec.process IS NULL ) THEN
77: p_x_route_rec.process_code := NULL;
78: ELSIF ( p_x_route_rec.process = FND_API.G_MISS_CHAR ) THEN
79: p_x_route_rec.process_code := FND_API.G_MISS_CHAR;
80: END IF;
81:
82: IF ( p_x_route_rec.product_type IS NULL ) THEN
83: p_x_route_rec.product_type_code := NULL;

Line 84: ELSIF ( p_x_route_rec.product_type = FND_API.G_MISS_CHAR ) THEN

80: END IF;
81:
82: IF ( p_x_route_rec.product_type IS NULL ) THEN
83: p_x_route_rec.product_type_code := NULL;
84: ELSIF ( p_x_route_rec.product_type = FND_API.G_MISS_CHAR ) THEN
85: p_x_route_rec.product_type_code := FND_API.G_MISS_CHAR;
86: END IF;
87:
88: IF ( p_x_route_rec.operator_name IS NULL ) THEN

Line 85: p_x_route_rec.product_type_code := FND_API.G_MISS_CHAR;

81:
82: IF ( p_x_route_rec.product_type IS NULL ) THEN
83: p_x_route_rec.product_type_code := NULL;
84: ELSIF ( p_x_route_rec.product_type = FND_API.G_MISS_CHAR ) THEN
85: p_x_route_rec.product_type_code := FND_API.G_MISS_CHAR;
86: END IF;
87:
88: IF ( p_x_route_rec.operator_name IS NULL ) THEN
89: p_x_route_rec.operator_party_id := NULL;

Line 90: ELSIF ( p_x_route_rec.operator_name = FND_API.G_MISS_CHAR ) THEN

86: END IF;
87:
88: IF ( p_x_route_rec.operator_name IS NULL ) THEN
89: p_x_route_rec.operator_party_id := NULL;
90: ELSIF ( p_x_route_rec.operator_name = FND_API.G_MISS_CHAR ) THEN
91: p_x_route_rec.operator_party_id := FND_API.G_MISS_NUM;
92: END IF;
93:
94: IF ( p_x_route_rec.zone IS NULL ) THEN

Line 91: p_x_route_rec.operator_party_id := FND_API.G_MISS_NUM;

87:
88: IF ( p_x_route_rec.operator_name IS NULL ) THEN
89: p_x_route_rec.operator_party_id := NULL;
90: ELSIF ( p_x_route_rec.operator_name = FND_API.G_MISS_CHAR ) THEN
91: p_x_route_rec.operator_party_id := FND_API.G_MISS_NUM;
92: END IF;
93:
94: IF ( p_x_route_rec.zone IS NULL ) THEN
95: p_x_route_rec.zone_code := NULL;

Line 96: ELSIF ( p_x_route_rec.zone = FND_API.G_MISS_CHAR ) THEN

92: END IF;
93:
94: IF ( p_x_route_rec.zone IS NULL ) THEN
95: p_x_route_rec.zone_code := NULL;
96: ELSIF ( p_x_route_rec.zone = FND_API.G_MISS_CHAR ) THEN
97: p_x_route_rec.zone_code := FND_API.G_MISS_CHAR;
98: END IF;
99:
100: IF ( p_x_route_rec.sub_zone IS NULL ) THEN

Line 97: p_x_route_rec.zone_code := FND_API.G_MISS_CHAR;

93:
94: IF ( p_x_route_rec.zone IS NULL ) THEN
95: p_x_route_rec.zone_code := NULL;
96: ELSIF ( p_x_route_rec.zone = FND_API.G_MISS_CHAR ) THEN
97: p_x_route_rec.zone_code := FND_API.G_MISS_CHAR;
98: END IF;
99:
100: IF ( p_x_route_rec.sub_zone IS NULL ) THEN
101: p_x_route_rec.sub_zone_code := NULL;

Line 102: ELSIF ( p_x_route_rec.sub_zone = FND_API.G_MISS_CHAR ) THEN

98: END IF;
99:
100: IF ( p_x_route_rec.sub_zone IS NULL ) THEN
101: p_x_route_rec.sub_zone_code := NULL;
102: ELSIF ( p_x_route_rec.sub_zone = FND_API.G_MISS_CHAR ) THEN
103: p_x_route_rec.sub_zone_code := FND_API.G_MISS_CHAR;
104: END IF;
105:
106: IF ( p_x_route_rec.service_item_number IS NULL ) THEN

Line 103: p_x_route_rec.sub_zone_code := FND_API.G_MISS_CHAR;

99:
100: IF ( p_x_route_rec.sub_zone IS NULL ) THEN
101: p_x_route_rec.sub_zone_code := NULL;
102: ELSIF ( p_x_route_rec.sub_zone = FND_API.G_MISS_CHAR ) THEN
103: p_x_route_rec.sub_zone_code := FND_API.G_MISS_CHAR;
104: END IF;
105:
106: IF ( p_x_route_rec.service_item_number IS NULL ) THEN
107: p_x_route_rec.service_item_id := NULL;

Line 109: ELSIF ( p_x_route_rec.service_item_number = FND_API.G_MISS_CHAR ) THEN

105:
106: IF ( p_x_route_rec.service_item_number IS NULL ) THEN
107: p_x_route_rec.service_item_id := NULL;
108: p_x_route_rec.service_item_org_id := NULL;
109: ELSIF ( p_x_route_rec.service_item_number = FND_API.G_MISS_CHAR ) THEN
110: p_x_route_rec.service_item_id := FND_API.G_MISS_NUM;
111: p_x_route_rec.service_item_org_id := FND_API.G_MISS_NUM;
112: END IF;
113:

Line 110: p_x_route_rec.service_item_id := FND_API.G_MISS_NUM;

106: IF ( p_x_route_rec.service_item_number IS NULL ) THEN
107: p_x_route_rec.service_item_id := NULL;
108: p_x_route_rec.service_item_org_id := NULL;
109: ELSIF ( p_x_route_rec.service_item_number = FND_API.G_MISS_CHAR ) THEN
110: p_x_route_rec.service_item_id := FND_API.G_MISS_NUM;
111: p_x_route_rec.service_item_org_id := FND_API.G_MISS_NUM;
112: END IF;
113:
114: IF ( p_x_route_rec.accounting_class IS NULL ) THEN

Line 111: p_x_route_rec.service_item_org_id := FND_API.G_MISS_NUM;

107: p_x_route_rec.service_item_id := NULL;
108: p_x_route_rec.service_item_org_id := NULL;
109: ELSIF ( p_x_route_rec.service_item_number = FND_API.G_MISS_CHAR ) THEN
110: p_x_route_rec.service_item_id := FND_API.G_MISS_NUM;
111: p_x_route_rec.service_item_org_id := FND_API.G_MISS_NUM;
112: END IF;
113:
114: IF ( p_x_route_rec.accounting_class IS NULL ) THEN
115: p_x_route_rec.accounting_class_code := NULL;

Line 117: ELSIF ( p_x_route_rec.accounting_class = FND_API.G_MISS_CHAR ) THEN

113:
114: IF ( p_x_route_rec.accounting_class IS NULL ) THEN
115: p_x_route_rec.accounting_class_code := NULL;
116: p_x_route_rec.accounting_class_org_id := NULL;
117: ELSIF ( p_x_route_rec.accounting_class = FND_API.G_MISS_CHAR ) THEN
118: p_x_route_rec.accounting_class_code := FND_API.G_MISS_CHAR;
119: p_x_route_rec.accounting_class_org_id := FND_API.G_MISS_NUM;
120: END IF;
121:

Line 118: p_x_route_rec.accounting_class_code := FND_API.G_MISS_CHAR;

114: IF ( p_x_route_rec.accounting_class IS NULL ) THEN
115: p_x_route_rec.accounting_class_code := NULL;
116: p_x_route_rec.accounting_class_org_id := NULL;
117: ELSIF ( p_x_route_rec.accounting_class = FND_API.G_MISS_CHAR ) THEN
118: p_x_route_rec.accounting_class_code := FND_API.G_MISS_CHAR;
119: p_x_route_rec.accounting_class_org_id := FND_API.G_MISS_NUM;
120: END IF;
121:
122: IF ( p_x_route_rec.task_template_group IS NULL ) THEN

Line 119: p_x_route_rec.accounting_class_org_id := FND_API.G_MISS_NUM;

115: p_x_route_rec.accounting_class_code := NULL;
116: p_x_route_rec.accounting_class_org_id := NULL;
117: ELSIF ( p_x_route_rec.accounting_class = FND_API.G_MISS_CHAR ) THEN
118: p_x_route_rec.accounting_class_code := FND_API.G_MISS_CHAR;
119: p_x_route_rec.accounting_class_org_id := FND_API.G_MISS_NUM;
120: END IF;
121:
122: IF ( p_x_route_rec.task_template_group IS NULL ) THEN
123: p_x_route_rec.task_template_group_id := NULL;

Line 124: ELSIF ( p_x_route_rec.task_template_group = FND_API.G_MISS_CHAR ) THEN

120: END IF;
121:
122: IF ( p_x_route_rec.task_template_group IS NULL ) THEN
123: p_x_route_rec.task_template_group_id := NULL;
124: ELSIF ( p_x_route_rec.task_template_group = FND_API.G_MISS_CHAR ) THEN
125: p_x_route_rec.task_template_group_id := FND_API.G_MISS_NUM;
126: END IF;
127:
128: --MANESING::Supplier Warranty, 25-Aug-2010, included changes for warranty template name lov

Line 125: p_x_route_rec.task_template_group_id := FND_API.G_MISS_NUM;

121:
122: IF ( p_x_route_rec.task_template_group IS NULL ) THEN
123: p_x_route_rec.task_template_group_id := NULL;
124: ELSIF ( p_x_route_rec.task_template_group = FND_API.G_MISS_CHAR ) THEN
125: p_x_route_rec.task_template_group_id := FND_API.G_MISS_NUM;
126: END IF;
127:
128: --MANESING::Supplier Warranty, 25-Aug-2010, included changes for warranty template name lov
129: IF ( p_x_route_rec.warranty_template_name IS NULL ) THEN

Line 131: ELSIF ( p_x_route_rec.warranty_template_name = FND_API.G_MISS_CHAR ) THEN

127:
128: --MANESING::Supplier Warranty, 25-Aug-2010, included changes for warranty template name lov
129: IF ( p_x_route_rec.warranty_template_name IS NULL ) THEN
130: p_x_route_rec.warranty_template_id := NULL;
131: ELSIF ( p_x_route_rec.warranty_template_name = FND_API.G_MISS_CHAR ) THEN
132: p_x_route_rec.warranty_template_id := FND_API.G_MISS_NUM;
133: END IF;
134:
135: IF ( p_x_route_rec.qa_inspection_type_desc IS NULL ) THEN

Line 132: p_x_route_rec.warranty_template_id := FND_API.G_MISS_NUM;

128: --MANESING::Supplier Warranty, 25-Aug-2010, included changes for warranty template name lov
129: IF ( p_x_route_rec.warranty_template_name IS NULL ) THEN
130: p_x_route_rec.warranty_template_id := NULL;
131: ELSIF ( p_x_route_rec.warranty_template_name = FND_API.G_MISS_CHAR ) THEN
132: p_x_route_rec.warranty_template_id := FND_API.G_MISS_NUM;
133: END IF;
134:
135: IF ( p_x_route_rec.qa_inspection_type_desc IS NULL ) THEN
136: p_x_route_rec.qa_inspection_type := NULL;

Line 137: ELSIF ( p_x_route_rec.qa_inspection_type_desc = FND_API.G_MISS_CHAR ) THEN

133: END IF;
134:
135: IF ( p_x_route_rec.qa_inspection_type_desc IS NULL ) THEN
136: p_x_route_rec.qa_inspection_type := NULL;
137: ELSIF ( p_x_route_rec.qa_inspection_type_desc = FND_API.G_MISS_CHAR ) THEN
138: p_x_route_rec.qa_inspection_type := FND_API.G_MISS_CHAR;
139: END IF;
140:
141: IF ( p_x_route_rec.revision_status IS NULL ) THEN

Line 138: p_x_route_rec.qa_inspection_type := FND_API.G_MISS_CHAR;

134:
135: IF ( p_x_route_rec.qa_inspection_type_desc IS NULL ) THEN
136: p_x_route_rec.qa_inspection_type := NULL;
137: ELSIF ( p_x_route_rec.qa_inspection_type_desc = FND_API.G_MISS_CHAR ) THEN
138: p_x_route_rec.qa_inspection_type := FND_API.G_MISS_CHAR;
139: END IF;
140:
141: IF ( p_x_route_rec.revision_status IS NULL ) THEN
142: p_x_route_rec.revision_status_code := NULL;

Line 143: ELSIF ( p_x_route_rec.revision_status = FND_API.G_MISS_CHAR ) THEN

139: END IF;
140:
141: IF ( p_x_route_rec.revision_status IS NULL ) THEN
142: p_x_route_rec.revision_status_code := NULL;
143: ELSIF ( p_x_route_rec.revision_status = FND_API.G_MISS_CHAR ) THEN
144: p_x_route_rec.revision_status_code := FND_API.G_MISS_CHAR;
145: END IF;
146:
147: END clear_lov_attribute_ids;

Line 144: p_x_route_rec.revision_status_code := FND_API.G_MISS_CHAR;

140:
141: IF ( p_x_route_rec.revision_status IS NULL ) THEN
142: p_x_route_rec.revision_status_code := NULL;
143: ELSIF ( p_x_route_rec.revision_status = FND_API.G_MISS_CHAR ) THEN
144: p_x_route_rec.revision_status_code := FND_API.G_MISS_CHAR;
145: END IF;
146:
147: END clear_lov_attribute_ids;
148:

Line 161: x_return_status := FND_API.G_RET_STS_SUCCESS;

157: l_return_status VARCHAR2(1);
158: l_msg_data VARCHAR2(2000);
159:
160: BEGIN
161: x_return_status := FND_API.G_RET_STS_SUCCESS;
162:
163: -- Convert / Validate Route Type
164: IF ( ( p_x_route_rec.route_type_code IS NOT NULL AND
165: p_x_route_rec.route_type_code <> FND_API.G_MISS_CHAR ) OR

Line 165: p_x_route_rec.route_type_code <> FND_API.G_MISS_CHAR ) OR

161: x_return_status := FND_API.G_RET_STS_SUCCESS;
162:
163: -- Convert / Validate Route Type
164: IF ( ( p_x_route_rec.route_type_code IS NOT NULL AND
165: p_x_route_rec.route_type_code <> FND_API.G_MISS_CHAR ) OR
166: ( p_x_route_rec.route_type IS NOT NULL AND
167: p_x_route_rec.route_type <> FND_API.G_MISS_CHAR ) ) THEN
168:
169: AHL_RM_ROUTE_UTIL.validate_lookup

Line 167: p_x_route_rec.route_type <> FND_API.G_MISS_CHAR ) ) THEN

163: -- Convert / Validate Route Type
164: IF ( ( p_x_route_rec.route_type_code IS NOT NULL AND
165: p_x_route_rec.route_type_code <> FND_API.G_MISS_CHAR ) OR
166: ( p_x_route_rec.route_type IS NOT NULL AND
167: p_x_route_rec.route_type <> FND_API.G_MISS_CHAR ) ) THEN
168:
169: AHL_RM_ROUTE_UTIL.validate_lookup
170: (
171: x_return_status => l_return_status,

Line 178: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

174: p_lookup_meaning => p_x_route_rec.route_type,
175: p_x_lookup_code => p_x_route_rec.route_type_code
176: );
177:
178: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
179: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
180: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ROUTE_TYPE' );
181: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
182: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ROUTE_TYPES' );

Line 188: p_x_route_rec.route_type = FND_API.G_MISS_CHAR ) THEN

184: FND_MESSAGE.set_name( 'AHL', l_msg_data );
185: END IF;
186:
187: IF ( p_x_route_rec.route_type IS NULL OR
188: p_x_route_rec.route_type = FND_API.G_MISS_CHAR ) THEN
189: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.route_type_code );
190: ELSE
191: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.route_type );
192: END IF;

Line 202: p_x_route_rec.model_code <> FND_API.G_MISS_CHAR ) OR

198:
199: --bachandr Enigma Phase I changes -- start
200: -- Convert / Validate Model
201: IF ( ( p_x_route_rec.model_code IS NOT NULL AND
202: p_x_route_rec.model_code <> FND_API.G_MISS_CHAR ) OR
203: ( p_x_route_rec.model_meaning IS NOT NULL AND
204: p_x_route_rec.model_meaning <> FND_API.G_MISS_CHAR ) ) THEN
205:
206: AHL_RM_ROUTE_UTIL.validate_lookup

Line 204: p_x_route_rec.model_meaning <> FND_API.G_MISS_CHAR ) ) THEN

200: -- Convert / Validate Model
201: IF ( ( p_x_route_rec.model_code IS NOT NULL AND
202: p_x_route_rec.model_code <> FND_API.G_MISS_CHAR ) OR
203: ( p_x_route_rec.model_meaning IS NOT NULL AND
204: p_x_route_rec.model_meaning <> FND_API.G_MISS_CHAR ) ) THEN
205:
206: AHL_RM_ROUTE_UTIL.validate_lookup
207: (
208: x_return_status => l_return_status,

Line 215: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

211: p_lookup_meaning => p_x_route_rec.model_meaning,
212: p_x_lookup_code => p_x_route_rec.model_code
213: );
214:
215: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
216: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
217: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_INVALID_MODEL' );
218: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
219: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_TOO_MANY_MODELS' );

Line 225: p_x_route_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN

221: FND_MESSAGE.set_name( 'AHL', l_msg_data );
222: END IF;
223:
224: IF ( p_x_route_rec.model_meaning IS NULL OR
225: p_x_route_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN
226: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.model_code );
227: ELSE
228: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.model_meaning );
229: END IF;

Line 239: p_x_route_rec.process_code <> FND_API.G_MISS_CHAR ) OR

235: --bachandr Enigma Phase I changes -- end
236:
237: -- Convert / Validate Process
238: IF ( ( p_x_route_rec.process_code IS NOT NULL AND
239: p_x_route_rec.process_code <> FND_API.G_MISS_CHAR ) OR
240: ( p_x_route_rec.process IS NOT NULL AND
241: p_x_route_rec.process <> FND_API.G_MISS_CHAR ) ) THEN
242:
243: AHL_RM_ROUTE_UTIL.validate_lookup

Line 241: p_x_route_rec.process <> FND_API.G_MISS_CHAR ) ) THEN

237: -- Convert / Validate Process
238: IF ( ( p_x_route_rec.process_code IS NOT NULL AND
239: p_x_route_rec.process_code <> FND_API.G_MISS_CHAR ) OR
240: ( p_x_route_rec.process IS NOT NULL AND
241: p_x_route_rec.process <> FND_API.G_MISS_CHAR ) ) THEN
242:
243: AHL_RM_ROUTE_UTIL.validate_lookup
244: (
245: x_return_status => l_return_status,

Line 252: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

248: p_lookup_meaning => p_x_route_rec.process,
249: p_x_lookup_code => p_x_route_rec.process_code
250: );
251:
252: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
253: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
254: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PROCESS' );
255: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
256: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_PROCESSES' );

Line 262: p_x_route_rec.process = FND_API.G_MISS_CHAR ) THEN

258: FND_MESSAGE.set_name( 'AHL', l_msg_data );
259: END IF;
260:
261: IF ( p_x_route_rec.process IS NULL OR
262: p_x_route_rec.process = FND_API.G_MISS_CHAR ) THEN
263: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.process_code );
264: ELSE
265: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.process );
266: END IF;

Line 275: p_x_route_rec.product_type_code <> FND_API.G_MISS_CHAR ) OR

271: END IF;
272:
273: -- Convert / Validate Product Type
274: IF ( ( p_x_route_rec.product_type_code IS NOT NULL AND
275: p_x_route_rec.product_type_code <> FND_API.G_MISS_CHAR ) OR
276: ( p_x_route_rec.product_type IS NOT NULL AND
277: p_x_route_rec.product_type <> FND_API.G_MISS_CHAR ) ) THEN
278:
279: AHL_RM_ROUTE_UTIL.validate_lookup

Line 277: p_x_route_rec.product_type <> FND_API.G_MISS_CHAR ) ) THEN

273: -- Convert / Validate Product Type
274: IF ( ( p_x_route_rec.product_type_code IS NOT NULL AND
275: p_x_route_rec.product_type_code <> FND_API.G_MISS_CHAR ) OR
276: ( p_x_route_rec.product_type IS NOT NULL AND
277: p_x_route_rec.product_type <> FND_API.G_MISS_CHAR ) ) THEN
278:
279: AHL_RM_ROUTE_UTIL.validate_lookup
280: (
281: x_return_status => l_return_status,

Line 288: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

284: p_lookup_meaning => p_x_route_rec.product_type,
285: p_x_lookup_code => p_x_route_rec.product_type_code
286: );
287:
288: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
289: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
290: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PRODUCT_TYPE' );
291: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
292: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_PRODUCT_TYPES' );

Line 298: p_x_route_rec.product_type = FND_API.G_MISS_CHAR ) THEN

294: FND_MESSAGE.set_name( 'AHL', l_msg_data );
295: END IF;
296:
297: IF ( p_x_route_rec.product_type IS NULL OR
298: p_x_route_rec.product_type = FND_API.G_MISS_CHAR ) THEN
299: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.product_type_code );
300: ELSE
301: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.product_type );
302: END IF;

Line 311: p_x_route_rec.operator_name <> FND_API.G_MISS_CHAR ) OR

307: END IF;
308:
309: -- Convert / Validate Operator
310: IF ( ( p_x_route_rec.operator_name IS NOT NULL AND
311: p_x_route_rec.operator_name <> FND_API.G_MISS_CHAR ) OR
312: ( p_x_route_rec.operator_party_id IS NOT NULL AND
313: p_x_route_rec.operator_party_id <> FND_API.G_MISS_NUM ) ) THEN
314:
315: AHL_RM_ROUTE_UTIL.validate_operator

Line 313: p_x_route_rec.operator_party_id <> FND_API.G_MISS_NUM ) ) THEN

309: -- Convert / Validate Operator
310: IF ( ( p_x_route_rec.operator_name IS NOT NULL AND
311: p_x_route_rec.operator_name <> FND_API.G_MISS_CHAR ) OR
312: ( p_x_route_rec.operator_party_id IS NOT NULL AND
313: p_x_route_rec.operator_party_id <> FND_API.G_MISS_NUM ) ) THEN
314:
315: AHL_RM_ROUTE_UTIL.validate_operator
316: (
317: x_return_status => l_return_status,

Line 323: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

319: p_operator_name => p_x_route_rec.operator_name,
320: p_x_operator_party_id => p_x_route_rec.operator_party_id
321: );
322:
323: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
324: FND_MESSAGE.set_name( 'AHL', l_msg_data );
325:
326: IF ( p_x_route_rec.operator_name IS NULL OR
327: p_x_route_rec.operator_name = FND_API.G_MISS_CHAR ) THEN

Line 327: p_x_route_rec.operator_name = FND_API.G_MISS_CHAR ) THEN

323: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
324: FND_MESSAGE.set_name( 'AHL', l_msg_data );
325:
326: IF ( p_x_route_rec.operator_name IS NULL OR
327: p_x_route_rec.operator_name = FND_API.G_MISS_CHAR ) THEN
328: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.operator_party_id ) );
329: ELSE
330: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.operator_name );
331: END IF;

Line 340: p_x_route_rec.zone_code <> FND_API.G_MISS_CHAR ) OR

336: END IF;
337:
338: -- Convert / Validate Zone
339: IF ( ( p_x_route_rec.zone_code IS NOT NULL AND
340: p_x_route_rec.zone_code <> FND_API.G_MISS_CHAR ) OR
341: ( p_x_route_rec.zone IS NOT NULL AND
342: p_x_route_rec.zone <> FND_API.G_MISS_CHAR ) ) THEN
343:
344: AHL_RM_ROUTE_UTIL.validate_lookup

Line 342: p_x_route_rec.zone <> FND_API.G_MISS_CHAR ) ) THEN

338: -- Convert / Validate Zone
339: IF ( ( p_x_route_rec.zone_code IS NOT NULL AND
340: p_x_route_rec.zone_code <> FND_API.G_MISS_CHAR ) OR
341: ( p_x_route_rec.zone IS NOT NULL AND
342: p_x_route_rec.zone <> FND_API.G_MISS_CHAR ) ) THEN
343:
344: AHL_RM_ROUTE_UTIL.validate_lookup
345: (
346: x_return_status => l_return_status,

Line 353: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

349: p_lookup_meaning => p_x_route_rec.zone,
350: p_x_lookup_code => p_x_route_rec.zone_code
351: );
352:
353: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
354: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
355: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ZONE' );
356: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
357: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ZONES' );

Line 363: p_x_route_rec.zone = FND_API.G_MISS_CHAR ) THEN

359: FND_MESSAGE.set_name( 'AHL', l_msg_data );
360: END IF;
361:
362: IF ( p_x_route_rec.zone IS NULL OR
363: p_x_route_rec.zone = FND_API.G_MISS_CHAR ) THEN
364: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.zone_code );
365: ELSE
366: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.zone );
367: END IF;

Line 376: p_x_route_rec.sub_zone_code <> FND_API.G_MISS_CHAR ) OR

372: END IF;
373:
374: -- Convert / Validate Sub Zone
375: IF ( ( p_x_route_rec.sub_zone_code IS NOT NULL AND
376: p_x_route_rec.sub_zone_code <> FND_API.G_MISS_CHAR ) OR
377: ( p_x_route_rec.sub_zone IS NOT NULL AND
378: p_x_route_rec.sub_zone <> FND_API.G_MISS_CHAR ) ) THEN
379:
380: AHL_RM_ROUTE_UTIL.validate_lookup

Line 378: p_x_route_rec.sub_zone <> FND_API.G_MISS_CHAR ) ) THEN

374: -- Convert / Validate Sub Zone
375: IF ( ( p_x_route_rec.sub_zone_code IS NOT NULL AND
376: p_x_route_rec.sub_zone_code <> FND_API.G_MISS_CHAR ) OR
377: ( p_x_route_rec.sub_zone IS NOT NULL AND
378: p_x_route_rec.sub_zone <> FND_API.G_MISS_CHAR ) ) THEN
379:
380: AHL_RM_ROUTE_UTIL.validate_lookup
381: (
382: x_return_status => l_return_status,

Line 389: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

385: p_lookup_meaning => p_x_route_rec.sub_zone,
386: p_x_lookup_code => p_x_route_rec.sub_zone_code
387: );
388:
389: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
390: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
391: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_SUB_ZONE' );
392: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
393: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_SUB_ZONES' );

Line 399: p_x_route_rec.sub_zone = FND_API.G_MISS_CHAR ) THEN

395: FND_MESSAGE.set_name( 'AHL', l_msg_data );
396: END IF;
397:
398: IF ( p_x_route_rec.sub_zone IS NULL OR
399: p_x_route_rec.sub_zone = FND_API.G_MISS_CHAR ) THEN
400: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.sub_zone_code );
401: ELSE
402: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.sub_zone );
403: END IF;

Line 412: p_x_route_rec.service_item_number <> FND_API.G_MISS_CHAR ) OR

408: END IF;
409:
410: -- Convert / Validate Service Item
411: IF ( ( p_x_route_rec.service_item_number IS NOT NULL AND
412: p_x_route_rec.service_item_number <> FND_API.G_MISS_CHAR ) OR
413: ( p_x_route_rec.service_item_id IS NOT NULL AND
414: p_x_route_rec.service_item_id <> FND_API.G_MISS_NUM AND
415: p_x_route_rec.service_item_org_id IS NOT NULL AND
416: p_x_route_rec.service_item_org_id <> FND_API.G_MISS_NUM ) ) THEN

Line 414: p_x_route_rec.service_item_id <> FND_API.G_MISS_NUM AND

410: -- Convert / Validate Service Item
411: IF ( ( p_x_route_rec.service_item_number IS NOT NULL AND
412: p_x_route_rec.service_item_number <> FND_API.G_MISS_CHAR ) OR
413: ( p_x_route_rec.service_item_id IS NOT NULL AND
414: p_x_route_rec.service_item_id <> FND_API.G_MISS_NUM AND
415: p_x_route_rec.service_item_org_id IS NOT NULL AND
416: p_x_route_rec.service_item_org_id <> FND_API.G_MISS_NUM ) ) THEN
417:
418: AHL_RM_ROUTE_UTIL.validate_service_item

Line 416: p_x_route_rec.service_item_org_id <> FND_API.G_MISS_NUM ) ) THEN

412: p_x_route_rec.service_item_number <> FND_API.G_MISS_CHAR ) OR
413: ( p_x_route_rec.service_item_id IS NOT NULL AND
414: p_x_route_rec.service_item_id <> FND_API.G_MISS_NUM AND
415: p_x_route_rec.service_item_org_id IS NOT NULL AND
416: p_x_route_rec.service_item_org_id <> FND_API.G_MISS_NUM ) ) THEN
417:
418: AHL_RM_ROUTE_UTIL.validate_service_item
419: (
420: x_return_status => l_return_status,

Line 427: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

423: p_x_inventory_item_id => p_x_route_rec.service_item_id,
424: p_x_inventory_org_id => p_x_route_rec.service_item_org_id
425: );
426:
427: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
428: FND_MESSAGE.set_name( 'AHL', l_msg_data );
429:
430: IF ( p_x_route_rec.service_item_number IS NULL OR
431: p_x_route_rec.service_item_number = FND_API.G_MISS_CHAR ) THEN

Line 431: p_x_route_rec.service_item_number = FND_API.G_MISS_CHAR ) THEN

427: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
428: FND_MESSAGE.set_name( 'AHL', l_msg_data );
429:
430: IF ( p_x_route_rec.service_item_number IS NULL OR
431: p_x_route_rec.service_item_number = FND_API.G_MISS_CHAR ) THEN
432: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.service_item_id ) || TO_CHAR( p_x_route_rec.service_item_org_id ) );
433: ELSE
434: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.service_item_number );
435: END IF;

Line 444: p_x_route_rec.accounting_class_code <> FND_API.G_MISS_CHAR AND

440: END IF;
441:
442: -- Convert / Validate Accounting Class
443: IF ( ( p_x_route_rec.accounting_class_code IS NOT NULL AND
444: p_x_route_rec.accounting_class_code <> FND_API.G_MISS_CHAR AND
445: p_x_route_rec.accounting_class_org_id IS NOT NULL AND
446: p_x_route_rec.accounting_class_org_id <> FND_API.G_MISS_NUM ) OR
447: ( p_x_route_rec.accounting_class IS NOT NULL AND
448: p_x_route_rec.accounting_class <> FND_API.G_MISS_CHAR ) ) THEN

Line 446: p_x_route_rec.accounting_class_org_id <> FND_API.G_MISS_NUM ) OR

442: -- Convert / Validate Accounting Class
443: IF ( ( p_x_route_rec.accounting_class_code IS NOT NULL AND
444: p_x_route_rec.accounting_class_code <> FND_API.G_MISS_CHAR AND
445: p_x_route_rec.accounting_class_org_id IS NOT NULL AND
446: p_x_route_rec.accounting_class_org_id <> FND_API.G_MISS_NUM ) OR
447: ( p_x_route_rec.accounting_class IS NOT NULL AND
448: p_x_route_rec.accounting_class <> FND_API.G_MISS_CHAR ) ) THEN
449:
450: AHL_RM_ROUTE_UTIL.validate_accounting_class

Line 448: p_x_route_rec.accounting_class <> FND_API.G_MISS_CHAR ) ) THEN

444: p_x_route_rec.accounting_class_code <> FND_API.G_MISS_CHAR AND
445: p_x_route_rec.accounting_class_org_id IS NOT NULL AND
446: p_x_route_rec.accounting_class_org_id <> FND_API.G_MISS_NUM ) OR
447: ( p_x_route_rec.accounting_class IS NOT NULL AND
448: p_x_route_rec.accounting_class <> FND_API.G_MISS_CHAR ) ) THEN
449:
450: AHL_RM_ROUTE_UTIL.validate_accounting_class
451: (
452: x_return_status => l_return_status,

Line 459: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

455: p_x_accounting_class_code => p_x_route_rec.accounting_class_code,
456: p_x_accounting_class_org_id => p_x_route_rec.accounting_class_org_id
457: );
458:
459: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
460: FND_MESSAGE.set_name( 'AHL', l_msg_data );
461:
462: IF ( p_x_route_rec.accounting_class IS NULL OR
463: p_x_route_rec.accounting_class = FND_API.G_MISS_CHAR ) THEN

Line 463: p_x_route_rec.accounting_class = FND_API.G_MISS_CHAR ) THEN

459: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
460: FND_MESSAGE.set_name( 'AHL', l_msg_data );
461:
462: IF ( p_x_route_rec.accounting_class IS NULL OR
463: p_x_route_rec.accounting_class = FND_API.G_MISS_CHAR ) THEN
464: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.accounting_class_code || '-' || TO_CHAR( p_x_route_rec.accounting_class_org_id ) );
465: ELSE
466: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.accounting_class );
467: END IF;

Line 476: p_x_route_rec.task_template_group <> FND_API.G_MISS_CHAR ) OR

472: END IF;
473:
474: -- Convert / Validate Task Template Group
475: IF ( ( p_x_route_rec.task_template_group IS NOT NULL AND
476: p_x_route_rec.task_template_group <> FND_API.G_MISS_CHAR ) OR
477: ( p_x_route_rec.task_template_group_id IS NOT NULL AND
478: p_x_route_rec.task_template_group_id <> FND_API.G_MISS_NUM ) ) THEN
479:
480: AHL_RM_ROUTE_UTIL.validate_task_template_group

Line 478: p_x_route_rec.task_template_group_id <> FND_API.G_MISS_NUM ) ) THEN

474: -- Convert / Validate Task Template Group
475: IF ( ( p_x_route_rec.task_template_group IS NOT NULL AND
476: p_x_route_rec.task_template_group <> FND_API.G_MISS_CHAR ) OR
477: ( p_x_route_rec.task_template_group_id IS NOT NULL AND
478: p_x_route_rec.task_template_group_id <> FND_API.G_MISS_NUM ) ) THEN
479:
480: AHL_RM_ROUTE_UTIL.validate_task_template_group
481: (
482: x_return_status => l_return_status,

Line 488: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

484: p_task_template_group => p_x_route_rec.task_template_group,
485: p_x_task_template_group_id => p_x_route_rec.task_template_group_id
486: );
487:
488: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
489: FND_MESSAGE.set_name( 'AHL', l_msg_data );
490:
491: IF ( p_x_route_rec.task_template_group IS NULL OR
492: p_x_route_rec.task_template_group = FND_API.G_MISS_CHAR ) THEN

Line 492: p_x_route_rec.task_template_group = FND_API.G_MISS_CHAR ) THEN

488: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
489: FND_MESSAGE.set_name( 'AHL', l_msg_data );
490:
491: IF ( p_x_route_rec.task_template_group IS NULL OR
492: p_x_route_rec.task_template_group = FND_API.G_MISS_CHAR ) THEN
493: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.task_template_group_id ) );
494: ELSE
495: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.task_template_group );
496: END IF;

Line 506: p_x_route_rec.warranty_template_name <> FND_API.G_MISS_CHAR ) OR

502:
503: -- MANESING::Supplier Warranty, 25-Aug-2010
504: -- Convert / Validate Warranty Template name
505: IF ( ( p_x_route_rec.warranty_template_name IS NOT NULL AND
506: p_x_route_rec.warranty_template_name <> FND_API.G_MISS_CHAR ) OR
507: ( p_x_route_rec.warranty_template_id IS NOT NULL AND
508: p_x_route_rec.warranty_template_id <> FND_API.G_MISS_NUM ) ) THEN
509:
510: AHL_RM_ROUTE_UTIL.validate_warr_template_name

Line 508: p_x_route_rec.warranty_template_id <> FND_API.G_MISS_NUM ) ) THEN

504: -- Convert / Validate Warranty Template name
505: IF ( ( p_x_route_rec.warranty_template_name IS NOT NULL AND
506: p_x_route_rec.warranty_template_name <> FND_API.G_MISS_CHAR ) OR
507: ( p_x_route_rec.warranty_template_id IS NOT NULL AND
508: p_x_route_rec.warranty_template_id <> FND_API.G_MISS_NUM ) ) THEN
509:
510: AHL_RM_ROUTE_UTIL.validate_warr_template_name
511: (
512: x_return_status => l_return_status,

Line 518: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

514: p_warranty_template_name => p_x_route_rec.warranty_template_name,
515: p_x_warranty_template_id => p_x_route_rec.warranty_template_id
516: );
517:
518: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
519:
520: FND_MESSAGE.set_name( 'AHL', l_msg_data );
521: IF ( p_x_route_rec.warranty_template_name IS NULL OR
522: p_x_route_rec.warranty_template_name = FND_API.G_MISS_CHAR ) THEN

Line 522: p_x_route_rec.warranty_template_name = FND_API.G_MISS_CHAR ) THEN

518: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
519:
520: FND_MESSAGE.set_name( 'AHL', l_msg_data );
521: IF ( p_x_route_rec.warranty_template_name IS NULL OR
522: p_x_route_rec.warranty_template_name = FND_API.G_MISS_CHAR ) THEN
523: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.warranty_template_id ) );
524: ELSE
525: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.warranty_template_name );
526: END IF;

Line 549: p_x_route_rec.qa_inspection_type_desc <> FND_API.G_MISS_CHAR ) OR

545: END IF;
546:
547: -- Convert / Validate QA Plan
548: IF ( ( p_x_route_rec.qa_inspection_type_desc IS NOT NULL AND
549: p_x_route_rec.qa_inspection_type_desc <> FND_API.G_MISS_CHAR ) OR
550: ( p_x_route_rec.qa_inspection_type IS NOT NULL AND
551: p_x_route_rec.qa_inspection_type <> FND_API.G_MISS_CHAR ) ) THEN
552:
553: AHL_RM_ROUTE_UTIL.validate_qa_inspection_type

Line 551: p_x_route_rec.qa_inspection_type <> FND_API.G_MISS_CHAR ) ) THEN

547: -- Convert / Validate QA Plan
548: IF ( ( p_x_route_rec.qa_inspection_type_desc IS NOT NULL AND
549: p_x_route_rec.qa_inspection_type_desc <> FND_API.G_MISS_CHAR ) OR
550: ( p_x_route_rec.qa_inspection_type IS NOT NULL AND
551: p_x_route_rec.qa_inspection_type <> FND_API.G_MISS_CHAR ) ) THEN
552:
553: AHL_RM_ROUTE_UTIL.validate_qa_inspection_type
554: (
555: x_return_status => l_return_status,

Line 561: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

557: p_qa_inspection_type_desc => p_x_route_rec.qa_inspection_type_desc,
558: p_x_qa_inspection_type => p_x_route_rec.qa_inspection_type
559: );
560:
561: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
562: FND_MESSAGE.set_name( 'AHL', l_msg_data );
563:
564: IF ( p_x_route_rec.qa_inspection_type_desc IS NULL OR
565: p_x_route_rec.qa_inspection_type_desc = FND_API.G_MISS_CHAR ) THEN

Line 565: p_x_route_rec.qa_inspection_type_desc = FND_API.G_MISS_CHAR ) THEN

561: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
562: FND_MESSAGE.set_name( 'AHL', l_msg_data );
563:
564: IF ( p_x_route_rec.qa_inspection_type_desc IS NULL OR
565: p_x_route_rec.qa_inspection_type_desc = FND_API.G_MISS_CHAR ) THEN
566: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.qa_inspection_type );
567: ELSE
568: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.qa_inspection_type_desc );
569: END IF;

Line 578: p_x_route_rec.revision_status_code <> FND_API.G_MISS_CHAR ) OR

574: END IF;
575:
576: -- Convert / Validate Revision Status
577: IF ( ( p_x_route_rec.revision_status_code IS NOT NULL AND
578: p_x_route_rec.revision_status_code <> FND_API.G_MISS_CHAR ) OR
579: ( p_x_route_rec.revision_status IS NOT NULL AND
580: p_x_route_rec.revision_status <> FND_API.G_MISS_CHAR ) ) THEN
581:
582: AHL_RM_ROUTE_UTIL.validate_lookup

Line 580: p_x_route_rec.revision_status <> FND_API.G_MISS_CHAR ) ) THEN

576: -- Convert / Validate Revision Status
577: IF ( ( p_x_route_rec.revision_status_code IS NOT NULL AND
578: p_x_route_rec.revision_status_code <> FND_API.G_MISS_CHAR ) OR
579: ( p_x_route_rec.revision_status IS NOT NULL AND
580: p_x_route_rec.revision_status <> FND_API.G_MISS_CHAR ) ) THEN
581:
582: AHL_RM_ROUTE_UTIL.validate_lookup
583: (
584: x_return_status => l_return_status,

Line 591: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

587: p_lookup_meaning => p_x_route_rec.revision_status,
588: p_x_lookup_code => p_x_route_rec.revision_status_code
589: );
590:
591: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
592: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
593: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_STATUS' );
594: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
595: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_STATUSES' );

Line 601: p_x_route_rec.revision_status = FND_API.G_MISS_CHAR ) THEN

597: FND_MESSAGE.set_name( 'AHL', l_msg_data );
598: END IF;
599:
600: IF ( p_x_route_rec.revision_status IS NULL OR
601: p_x_route_rec.revision_status = FND_API.G_MISS_CHAR ) THEN
602: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.revision_status_code );
603: ELSE
604: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.revision_status );
605: END IF;

Line 615: p_x_route_rec.unit_receipt_update_flag <> FND_API.G_MISS_CHAR ) OR

611:
612: -- pdoki added for Bug 6504159
613: -- Convert / Validate unit receipt update
614: IF ( ( p_x_route_rec.unit_receipt_update_flag IS NOT NULL AND
615: p_x_route_rec.unit_receipt_update_flag <> FND_API.G_MISS_CHAR ) OR
616: ( p_x_route_rec.unit_receipt_update IS NOT NULL AND
617: p_x_route_rec.unit_receipt_update <> FND_API.G_MISS_CHAR ) ) THEN
618:
619: AHL_RM_ROUTE_UTIL.validate_lookup

Line 617: p_x_route_rec.unit_receipt_update <> FND_API.G_MISS_CHAR ) ) THEN

613: -- Convert / Validate unit receipt update
614: IF ( ( p_x_route_rec.unit_receipt_update_flag IS NOT NULL AND
615: p_x_route_rec.unit_receipt_update_flag <> FND_API.G_MISS_CHAR ) OR
616: ( p_x_route_rec.unit_receipt_update IS NOT NULL AND
617: p_x_route_rec.unit_receipt_update <> FND_API.G_MISS_CHAR ) ) THEN
618:
619: AHL_RM_ROUTE_UTIL.validate_lookup
620: (
621: x_return_status => l_return_status,

Line 628: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

624: p_lookup_meaning => p_x_route_rec.unit_receipt_update,
625: p_x_lookup_code => p_x_route_rec.unit_receipt_update_flag
626: );
627:
628: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
629: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
630: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_UNIT_RECEIPT' );
631: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
632: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_UNIT_RECEIPTS' );

Line 638: p_x_route_rec.unit_receipt_update = FND_API.G_MISS_CHAR ) THEN

634: FND_MESSAGE.set_name( 'AHL', l_msg_data );
635: END IF;
636:
637: IF ( p_x_route_rec.unit_receipt_update IS NULL OR
638: p_x_route_rec.unit_receipt_update = FND_API.G_MISS_CHAR ) THEN
639: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.unit_receipt_update_flag );
640: ELSE
641: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.unit_receipt_update );
642: END IF;

Line 650: p_x_route_rec.job_card_lyt_code <> FND_API.G_MISS_CHAR ) OR

646: END IF;
647: --Enigma Phase II Changes Start
648: -- Validate the Job Card Layout Code
649: IF ( ( p_x_route_rec.job_card_lyt_code IS NOT NULL AND
650: p_x_route_rec.job_card_lyt_code <> FND_API.G_MISS_CHAR ) OR
651: ( p_x_route_rec.job_card_lyt_meaning IS NOT NULL AND
652: p_x_route_rec.job_card_lyt_meaning <> FND_API.G_MISS_CHAR ) ) THEN
653:
654: AHL_RM_ROUTE_UTIL.validate_lookup

Line 652: p_x_route_rec.job_card_lyt_meaning <> FND_API.G_MISS_CHAR ) ) THEN

648: -- Validate the Job Card Layout Code
649: IF ( ( p_x_route_rec.job_card_lyt_code IS NOT NULL AND
650: p_x_route_rec.job_card_lyt_code <> FND_API.G_MISS_CHAR ) OR
651: ( p_x_route_rec.job_card_lyt_meaning IS NOT NULL AND
652: p_x_route_rec.job_card_lyt_meaning <> FND_API.G_MISS_CHAR ) ) THEN
653:
654: AHL_RM_ROUTE_UTIL.validate_lookup
655: (
656: x_return_status => l_return_status,

Line 663: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

659: p_lookup_meaning => p_x_route_rec.job_card_lyt_meaning,
660: p_x_lookup_code => p_x_route_rec.job_card_lyt_code
661: );
662:
663: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
664: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
665: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_INVALID_JOB_CARD_LYT' );
666: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
667: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_TOO_MANY_JOB_CARD_LYT' );

Line 673: p_x_route_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN

669: FND_MESSAGE.set_name( 'AHL', l_msg_data );
670: END IF;
671:
672: IF ( p_x_route_rec.model_meaning IS NULL OR
673: p_x_route_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN
674: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.job_card_lyt_code );
675: ELSE
676: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.job_card_lyt_meaning );
677: END IF;

Line 721: IF ( p_x_route_rec.route_type_code = FND_API.G_MISS_CHAR ) THEN

717:
718: BEGIN
719:
720: -- Convert G_MISS values to NULL
721: IF ( p_x_route_rec.route_type_code = FND_API.G_MISS_CHAR ) THEN
722: p_x_route_rec.route_type_code := null;
723: END IF;
724:
725: IF ( p_x_route_rec.route_type = FND_API.G_MISS_CHAR ) THEN

Line 725: IF ( p_x_route_rec.route_type = FND_API.G_MISS_CHAR ) THEN

721: IF ( p_x_route_rec.route_type_code = FND_API.G_MISS_CHAR ) THEN
722: p_x_route_rec.route_type_code := null;
723: END IF;
724:
725: IF ( p_x_route_rec.route_type = FND_API.G_MISS_CHAR ) THEN
726: p_x_route_rec.route_type := null;
727: END IF;
728:
729: IF ( p_x_route_rec.process_code = FND_API.G_MISS_CHAR ) THEN

Line 729: IF ( p_x_route_rec.process_code = FND_API.G_MISS_CHAR ) THEN

725: IF ( p_x_route_rec.route_type = FND_API.G_MISS_CHAR ) THEN
726: p_x_route_rec.route_type := null;
727: END IF;
728:
729: IF ( p_x_route_rec.process_code = FND_API.G_MISS_CHAR ) THEN
730: p_x_route_rec.process_code := null;
731: END IF;
732:
733: IF ( p_x_route_rec.process = FND_API.G_MISS_CHAR ) THEN

Line 733: IF ( p_x_route_rec.process = FND_API.G_MISS_CHAR ) THEN

729: IF ( p_x_route_rec.process_code = FND_API.G_MISS_CHAR ) THEN
730: p_x_route_rec.process_code := null;
731: END IF;
732:
733: IF ( p_x_route_rec.process = FND_API.G_MISS_CHAR ) THEN
734: p_x_route_rec.process := null;
735: END IF;
736:
737: IF ( p_x_route_rec.product_type_code = FND_API.G_MISS_CHAR ) THEN

Line 737: IF ( p_x_route_rec.product_type_code = FND_API.G_MISS_CHAR ) THEN

733: IF ( p_x_route_rec.process = FND_API.G_MISS_CHAR ) THEN
734: p_x_route_rec.process := null;
735: END IF;
736:
737: IF ( p_x_route_rec.product_type_code = FND_API.G_MISS_CHAR ) THEN
738: p_x_route_rec.product_type_code := null;
739: END IF;
740:
741: IF ( p_x_route_rec.product_type = FND_API.G_MISS_CHAR ) THEN

Line 741: IF ( p_x_route_rec.product_type = FND_API.G_MISS_CHAR ) THEN

737: IF ( p_x_route_rec.product_type_code = FND_API.G_MISS_CHAR ) THEN
738: p_x_route_rec.product_type_code := null;
739: END IF;
740:
741: IF ( p_x_route_rec.product_type = FND_API.G_MISS_CHAR ) THEN
742: p_x_route_rec.product_type := null;
743: END IF;
744:
745: -- bachandr Enigma Phase I changes -- start

Line 749: IF ( p_x_route_rec.enigma_doc_id IS NULL OR p_x_route_rec.enigma_doc_id = FND_API.G_MISS_CHAR ) THEN

745: -- bachandr Enigma Phase I changes -- start
746: -- Default the model code and meaning to null only
747: -- when the route in a non-Enigma route.
748:
749: IF ( p_x_route_rec.enigma_doc_id IS NULL OR p_x_route_rec.enigma_doc_id = FND_API.G_MISS_CHAR ) THEN
750: IF ( p_x_route_rec.model_code = FND_API.G_MISS_CHAR ) THEN
751: p_x_route_rec.model_code := null;
752: END IF;
753:

Line 750: IF ( p_x_route_rec.model_code = FND_API.G_MISS_CHAR ) THEN

746: -- Default the model code and meaning to null only
747: -- when the route in a non-Enigma route.
748:
749: IF ( p_x_route_rec.enigma_doc_id IS NULL OR p_x_route_rec.enigma_doc_id = FND_API.G_MISS_CHAR ) THEN
750: IF ( p_x_route_rec.model_code = FND_API.G_MISS_CHAR ) THEN
751: p_x_route_rec.model_code := null;
752: END IF;
753:
754: IF ( p_x_route_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN

Line 754: IF ( p_x_route_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN

750: IF ( p_x_route_rec.model_code = FND_API.G_MISS_CHAR ) THEN
751: p_x_route_rec.model_code := null;
752: END IF;
753:
754: IF ( p_x_route_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN
755: p_x_route_rec.model_meaning := null;
756: END IF;
757: END IF;
758:

Line 759: IF ( p_x_route_rec.time_span = FND_API.G_MISS_NUM ) THEN

755: p_x_route_rec.model_meaning := null;
756: END IF;
757: END IF;
758:
759: IF ( p_x_route_rec.time_span = FND_API.G_MISS_NUM ) THEN
760: p_x_route_rec.time_span := null;
761: END IF;
762:
763: --bachandr Enigma Phase I changes -- end

Line 766: IF (p_x_route_rec.job_card_lyt_meaning = FND_API.G_MISS_CHAR) THEN

762:
763: --bachandr Enigma Phase I changes -- end
764: --snarkhed Enigma Phase II changes --start
765:
766: IF (p_x_route_rec.job_card_lyt_meaning = FND_API.G_MISS_CHAR) THEN
767: p_x_route_rec.job_card_lyt_code := null;
768: END IF;
769:
770: IF ( p_x_route_rec.enigma_doc_id = FND_API.G_MISS_CHAR ) THEN

Line 770: IF ( p_x_route_rec.enigma_doc_id = FND_API.G_MISS_CHAR ) THEN

766: IF (p_x_route_rec.job_card_lyt_meaning = FND_API.G_MISS_CHAR) THEN
767: p_x_route_rec.job_card_lyt_code := null;
768: END IF;
769:
770: IF ( p_x_route_rec.enigma_doc_id = FND_API.G_MISS_CHAR ) THEN
771: p_x_route_rec.enigma_doc_id := null;
772: END IF;
773: --snarkhed Enigma Phase II changes --end
774:

Line 776: IF ( p_x_route_rec.operator_party_id = FND_API.G_MISS_NUM ) THEN

772: END IF;
773: --snarkhed Enigma Phase II changes --end
774:
775:
776: IF ( p_x_route_rec.operator_party_id = FND_API.G_MISS_NUM ) THEN
777: p_x_route_rec.operator_party_id := null;
778: END IF;
779:
780: IF ( p_x_route_rec.operator_name = FND_API.G_MISS_CHAR ) THEN

Line 780: IF ( p_x_route_rec.operator_name = FND_API.G_MISS_CHAR ) THEN

776: IF ( p_x_route_rec.operator_party_id = FND_API.G_MISS_NUM ) THEN
777: p_x_route_rec.operator_party_id := null;
778: END IF;
779:
780: IF ( p_x_route_rec.operator_name = FND_API.G_MISS_CHAR ) THEN
781: p_x_route_rec.operator_name := null;
782: END IF;
783:
784: IF ( p_x_route_rec.zone_code = FND_API.G_MISS_CHAR ) THEN

Line 784: IF ( p_x_route_rec.zone_code = FND_API.G_MISS_CHAR ) THEN

780: IF ( p_x_route_rec.operator_name = FND_API.G_MISS_CHAR ) THEN
781: p_x_route_rec.operator_name := null;
782: END IF;
783:
784: IF ( p_x_route_rec.zone_code = FND_API.G_MISS_CHAR ) THEN
785: p_x_route_rec.zone_code := null;
786: END IF;
787:
788: IF ( p_x_route_rec.zone = FND_API.G_MISS_CHAR ) THEN

Line 788: IF ( p_x_route_rec.zone = FND_API.G_MISS_CHAR ) THEN

784: IF ( p_x_route_rec.zone_code = FND_API.G_MISS_CHAR ) THEN
785: p_x_route_rec.zone_code := null;
786: END IF;
787:
788: IF ( p_x_route_rec.zone = FND_API.G_MISS_CHAR ) THEN
789: p_x_route_rec.zone := null;
790: END IF;
791:
792: IF ( p_x_route_rec.sub_zone_code = FND_API.G_MISS_CHAR ) THEN

Line 792: IF ( p_x_route_rec.sub_zone_code = FND_API.G_MISS_CHAR ) THEN

788: IF ( p_x_route_rec.zone = FND_API.G_MISS_CHAR ) THEN
789: p_x_route_rec.zone := null;
790: END IF;
791:
792: IF ( p_x_route_rec.sub_zone_code = FND_API.G_MISS_CHAR ) THEN
793: p_x_route_rec.sub_zone_code := null;
794: END IF;
795:
796: IF ( p_x_route_rec.sub_zone = FND_API.G_MISS_CHAR ) THEN

Line 796: IF ( p_x_route_rec.sub_zone = FND_API.G_MISS_CHAR ) THEN

792: IF ( p_x_route_rec.sub_zone_code = FND_API.G_MISS_CHAR ) THEN
793: p_x_route_rec.sub_zone_code := null;
794: END IF;
795:
796: IF ( p_x_route_rec.sub_zone = FND_API.G_MISS_CHAR ) THEN
797: p_x_route_rec.sub_zone := null;
798: END IF;
799:
800: IF ( p_x_route_rec.service_item_id = FND_API.G_MISS_NUM ) THEN

Line 800: IF ( p_x_route_rec.service_item_id = FND_API.G_MISS_NUM ) THEN

796: IF ( p_x_route_rec.sub_zone = FND_API.G_MISS_CHAR ) THEN
797: p_x_route_rec.sub_zone := null;
798: END IF;
799:
800: IF ( p_x_route_rec.service_item_id = FND_API.G_MISS_NUM ) THEN
801: p_x_route_rec.service_item_id := null;
802: END IF;
803:
804: IF ( p_x_route_rec.service_item_org_id = FND_API.G_MISS_NUM ) THEN

Line 804: IF ( p_x_route_rec.service_item_org_id = FND_API.G_MISS_NUM ) THEN

800: IF ( p_x_route_rec.service_item_id = FND_API.G_MISS_NUM ) THEN
801: p_x_route_rec.service_item_id := null;
802: END IF;
803:
804: IF ( p_x_route_rec.service_item_org_id = FND_API.G_MISS_NUM ) THEN
805: p_x_route_rec.service_item_org_id := null;
806: END IF;
807:
808: IF ( p_x_route_rec.service_item_number = FND_API.G_MISS_CHAR ) THEN

Line 808: IF ( p_x_route_rec.service_item_number = FND_API.G_MISS_CHAR ) THEN

804: IF ( p_x_route_rec.service_item_org_id = FND_API.G_MISS_NUM ) THEN
805: p_x_route_rec.service_item_org_id := null;
806: END IF;
807:
808: IF ( p_x_route_rec.service_item_number = FND_API.G_MISS_CHAR ) THEN
809: p_x_route_rec.service_item_number := null;
810: END IF;
811:
812: IF ( p_x_route_rec.accounting_class_code = FND_API.G_MISS_CHAR ) THEN

Line 812: IF ( p_x_route_rec.accounting_class_code = FND_API.G_MISS_CHAR ) THEN

808: IF ( p_x_route_rec.service_item_number = FND_API.G_MISS_CHAR ) THEN
809: p_x_route_rec.service_item_number := null;
810: END IF;
811:
812: IF ( p_x_route_rec.accounting_class_code = FND_API.G_MISS_CHAR ) THEN
813: p_x_route_rec.accounting_class_code := null;
814: END IF;
815:
816: IF ( p_x_route_rec.accounting_class_org_id = FND_API.G_MISS_NUM ) THEN

Line 816: IF ( p_x_route_rec.accounting_class_org_id = FND_API.G_MISS_NUM ) THEN

812: IF ( p_x_route_rec.accounting_class_code = FND_API.G_MISS_CHAR ) THEN
813: p_x_route_rec.accounting_class_code := null;
814: END IF;
815:
816: IF ( p_x_route_rec.accounting_class_org_id = FND_API.G_MISS_NUM ) THEN
817: p_x_route_rec.accounting_class_org_id := null;
818: END IF;
819:
820: IF ( p_x_route_rec.accounting_class = FND_API.G_MISS_CHAR ) THEN

Line 820: IF ( p_x_route_rec.accounting_class = FND_API.G_MISS_CHAR ) THEN

816: IF ( p_x_route_rec.accounting_class_org_id = FND_API.G_MISS_NUM ) THEN
817: p_x_route_rec.accounting_class_org_id := null;
818: END IF;
819:
820: IF ( p_x_route_rec.accounting_class = FND_API.G_MISS_CHAR ) THEN
821: p_x_route_rec.accounting_class := null;
822: END IF;
823:
824: IF ( p_x_route_rec.task_template_group_id = FND_API.G_MISS_NUM ) THEN

Line 824: IF ( p_x_route_rec.task_template_group_id = FND_API.G_MISS_NUM ) THEN

820: IF ( p_x_route_rec.accounting_class = FND_API.G_MISS_CHAR ) THEN
821: p_x_route_rec.accounting_class := null;
822: END IF;
823:
824: IF ( p_x_route_rec.task_template_group_id = FND_API.G_MISS_NUM ) THEN
825: p_x_route_rec.task_template_group_id := null;
826: END IF;
827:
828: IF ( p_x_route_rec.task_template_group = FND_API.G_MISS_CHAR ) THEN

Line 828: IF ( p_x_route_rec.task_template_group = FND_API.G_MISS_CHAR ) THEN

824: IF ( p_x_route_rec.task_template_group_id = FND_API.G_MISS_NUM ) THEN
825: p_x_route_rec.task_template_group_id := null;
826: END IF;
827:
828: IF ( p_x_route_rec.task_template_group = FND_API.G_MISS_CHAR ) THEN
829: p_x_route_rec.task_template_group := null;
830: END IF;
831:
832: --MANESING::Supplier Warranty, 25-Aug-2010, included changes for warranty template id and name

Line 833: IF ( p_x_route_rec.warranty_template_id = FND_API.G_MISS_NUM ) THEN

829: p_x_route_rec.task_template_group := null;
830: END IF;
831:
832: --MANESING::Supplier Warranty, 25-Aug-2010, included changes for warranty template id and name
833: IF ( p_x_route_rec.warranty_template_id = FND_API.G_MISS_NUM ) THEN
834: p_x_route_rec.warranty_template_id := null;
835: END IF;
836:
837: IF ( p_x_route_rec.warranty_template_name = FND_API.G_MISS_CHAR ) THEN

Line 837: IF ( p_x_route_rec.warranty_template_name = FND_API.G_MISS_CHAR ) THEN

833: IF ( p_x_route_rec.warranty_template_id = FND_API.G_MISS_NUM ) THEN
834: p_x_route_rec.warranty_template_id := null;
835: END IF;
836:
837: IF ( p_x_route_rec.warranty_template_name = FND_API.G_MISS_CHAR ) THEN
838: p_x_route_rec.warranty_template_name := null;
839: END IF;
840:
841: --MANESING::VWP Enhancements, 18-Jan-2011, included changes for Duplicate and Return to supply flags

Line 850: IF ( p_x_route_rec.qa_inspection_type = FND_API.G_MISS_CHAR ) THEN

846: IF ( p_x_route_rec.return_to_supply_flag IS NULL ) THEN
847: p_x_route_rec.return_to_supply_flag := 'N';
848: END IF;
849:
850: IF ( p_x_route_rec.qa_inspection_type = FND_API.G_MISS_CHAR ) THEN
851: p_x_route_rec.qa_inspection_type := null;
852: END IF;
853:
854: IF ( p_x_route_rec.qa_inspection_type_desc = FND_API.G_MISS_CHAR ) THEN

Line 854: IF ( p_x_route_rec.qa_inspection_type_desc = FND_API.G_MISS_CHAR ) THEN

850: IF ( p_x_route_rec.qa_inspection_type = FND_API.G_MISS_CHAR ) THEN
851: p_x_route_rec.qa_inspection_type := null;
852: END IF;
853:
854: IF ( p_x_route_rec.qa_inspection_type_desc = FND_API.G_MISS_CHAR ) THEN
855: p_x_route_rec.qa_inspection_type_desc := null;
856: END IF;
857:
858: IF ( p_x_route_rec.remarks = FND_API.G_MISS_CHAR ) THEN

Line 858: IF ( p_x_route_rec.remarks = FND_API.G_MISS_CHAR ) THEN

854: IF ( p_x_route_rec.qa_inspection_type_desc = FND_API.G_MISS_CHAR ) THEN
855: p_x_route_rec.qa_inspection_type_desc := null;
856: END IF;
857:
858: IF ( p_x_route_rec.remarks = FND_API.G_MISS_CHAR ) THEN
859: p_x_route_rec.remarks := null;
860: END IF;
861:
862: IF ( p_x_route_rec.revision_notes = FND_API.G_MISS_CHAR ) THEN

Line 862: IF ( p_x_route_rec.revision_notes = FND_API.G_MISS_CHAR ) THEN

858: IF ( p_x_route_rec.remarks = FND_API.G_MISS_CHAR ) THEN
859: p_x_route_rec.remarks := null;
860: END IF;
861:
862: IF ( p_x_route_rec.revision_notes = FND_API.G_MISS_CHAR ) THEN
863: p_x_route_rec.revision_notes := null;
864: END IF;
865:
866: IF ( p_x_route_rec.segment1 = FND_API.G_MISS_CHAR ) THEN

Line 866: IF ( p_x_route_rec.segment1 = FND_API.G_MISS_CHAR ) THEN

862: IF ( p_x_route_rec.revision_notes = FND_API.G_MISS_CHAR ) THEN
863: p_x_route_rec.revision_notes := null;
864: END IF;
865:
866: IF ( p_x_route_rec.segment1 = FND_API.G_MISS_CHAR ) THEN
867: p_x_route_rec.segment1 := null;
868: END IF;
869:
870: IF ( p_x_route_rec.segment2 = FND_API.G_MISS_CHAR ) THEN

Line 870: IF ( p_x_route_rec.segment2 = FND_API.G_MISS_CHAR ) THEN

866: IF ( p_x_route_rec.segment1 = FND_API.G_MISS_CHAR ) THEN
867: p_x_route_rec.segment1 := null;
868: END IF;
869:
870: IF ( p_x_route_rec.segment2 = FND_API.G_MISS_CHAR ) THEN
871: p_x_route_rec.segment2 := null;
872: END IF;
873:
874: IF ( p_x_route_rec.segment3 = FND_API.G_MISS_CHAR ) THEN

Line 874: IF ( p_x_route_rec.segment3 = FND_API.G_MISS_CHAR ) THEN

870: IF ( p_x_route_rec.segment2 = FND_API.G_MISS_CHAR ) THEN
871: p_x_route_rec.segment2 := null;
872: END IF;
873:
874: IF ( p_x_route_rec.segment3 = FND_API.G_MISS_CHAR ) THEN
875: p_x_route_rec.segment3 := null;
876: END IF;
877:
878: IF ( p_x_route_rec.segment4 = FND_API.G_MISS_CHAR ) THEN

Line 878: IF ( p_x_route_rec.segment4 = FND_API.G_MISS_CHAR ) THEN

874: IF ( p_x_route_rec.segment3 = FND_API.G_MISS_CHAR ) THEN
875: p_x_route_rec.segment3 := null;
876: END IF;
877:
878: IF ( p_x_route_rec.segment4 = FND_API.G_MISS_CHAR ) THEN
879: p_x_route_rec.segment4 := null;
880: END IF;
881:
882: IF ( p_x_route_rec.segment5 = FND_API.G_MISS_CHAR ) THEN

Line 882: IF ( p_x_route_rec.segment5 = FND_API.G_MISS_CHAR ) THEN

878: IF ( p_x_route_rec.segment4 = FND_API.G_MISS_CHAR ) THEN
879: p_x_route_rec.segment4 := null;
880: END IF;
881:
882: IF ( p_x_route_rec.segment5 = FND_API.G_MISS_CHAR ) THEN
883: p_x_route_rec.segment5 := null;
884: END IF;
885:
886: IF ( p_x_route_rec.segment6 = FND_API.G_MISS_CHAR ) THEN

Line 886: IF ( p_x_route_rec.segment6 = FND_API.G_MISS_CHAR ) THEN

882: IF ( p_x_route_rec.segment5 = FND_API.G_MISS_CHAR ) THEN
883: p_x_route_rec.segment5 := null;
884: END IF;
885:
886: IF ( p_x_route_rec.segment6 = FND_API.G_MISS_CHAR ) THEN
887: p_x_route_rec.segment6 := null;
888: END IF;
889:
890: IF ( p_x_route_rec.segment7 = FND_API.G_MISS_CHAR ) THEN

Line 890: IF ( p_x_route_rec.segment7 = FND_API.G_MISS_CHAR ) THEN

886: IF ( p_x_route_rec.segment6 = FND_API.G_MISS_CHAR ) THEN
887: p_x_route_rec.segment6 := null;
888: END IF;
889:
890: IF ( p_x_route_rec.segment7 = FND_API.G_MISS_CHAR ) THEN
891: p_x_route_rec.segment7 := null;
892: END IF;
893:
894: IF ( p_x_route_rec.segment8 = FND_API.G_MISS_CHAR ) THEN

Line 894: IF ( p_x_route_rec.segment8 = FND_API.G_MISS_CHAR ) THEN

890: IF ( p_x_route_rec.segment7 = FND_API.G_MISS_CHAR ) THEN
891: p_x_route_rec.segment7 := null;
892: END IF;
893:
894: IF ( p_x_route_rec.segment8 = FND_API.G_MISS_CHAR ) THEN
895: p_x_route_rec.segment8 := null;
896: END IF;
897:
898: IF ( p_x_route_rec.segment9 = FND_API.G_MISS_CHAR ) THEN

Line 898: IF ( p_x_route_rec.segment9 = FND_API.G_MISS_CHAR ) THEN

894: IF ( p_x_route_rec.segment8 = FND_API.G_MISS_CHAR ) THEN
895: p_x_route_rec.segment8 := null;
896: END IF;
897:
898: IF ( p_x_route_rec.segment9 = FND_API.G_MISS_CHAR ) THEN
899: p_x_route_rec.segment9 := null;
900: END IF;
901:
902: IF ( p_x_route_rec.segment10 = FND_API.G_MISS_CHAR ) THEN

Line 902: IF ( p_x_route_rec.segment10 = FND_API.G_MISS_CHAR ) THEN

898: IF ( p_x_route_rec.segment9 = FND_API.G_MISS_CHAR ) THEN
899: p_x_route_rec.segment9 := null;
900: END IF;
901:
902: IF ( p_x_route_rec.segment10 = FND_API.G_MISS_CHAR ) THEN
903: p_x_route_rec.segment10 := null;
904: END IF;
905:
906: IF ( p_x_route_rec.segment11 = FND_API.G_MISS_CHAR ) THEN

Line 906: IF ( p_x_route_rec.segment11 = FND_API.G_MISS_CHAR ) THEN

902: IF ( p_x_route_rec.segment10 = FND_API.G_MISS_CHAR ) THEN
903: p_x_route_rec.segment10 := null;
904: END IF;
905:
906: IF ( p_x_route_rec.segment11 = FND_API.G_MISS_CHAR ) THEN
907: p_x_route_rec.segment11 := null;
908: END IF;
909:
910: IF ( p_x_route_rec.segment12 = FND_API.G_MISS_CHAR ) THEN

Line 910: IF ( p_x_route_rec.segment12 = FND_API.G_MISS_CHAR ) THEN

906: IF ( p_x_route_rec.segment11 = FND_API.G_MISS_CHAR ) THEN
907: p_x_route_rec.segment11 := null;
908: END IF;
909:
910: IF ( p_x_route_rec.segment12 = FND_API.G_MISS_CHAR ) THEN
911: p_x_route_rec.segment12 := null;
912: END IF;
913:
914: IF ( p_x_route_rec.segment13 = FND_API.G_MISS_CHAR ) THEN

Line 914: IF ( p_x_route_rec.segment13 = FND_API.G_MISS_CHAR ) THEN

910: IF ( p_x_route_rec.segment12 = FND_API.G_MISS_CHAR ) THEN
911: p_x_route_rec.segment12 := null;
912: END IF;
913:
914: IF ( p_x_route_rec.segment13 = FND_API.G_MISS_CHAR ) THEN
915: p_x_route_rec.segment13 := null;
916: END IF;
917:
918: IF ( p_x_route_rec.segment14 = FND_API.G_MISS_CHAR ) THEN

Line 918: IF ( p_x_route_rec.segment14 = FND_API.G_MISS_CHAR ) THEN

914: IF ( p_x_route_rec.segment13 = FND_API.G_MISS_CHAR ) THEN
915: p_x_route_rec.segment13 := null;
916: END IF;
917:
918: IF ( p_x_route_rec.segment14 = FND_API.G_MISS_CHAR ) THEN
919: p_x_route_rec.segment14 := null;
920: END IF;
921:
922: IF ( p_x_route_rec.segment15 = FND_API.G_MISS_CHAR ) THEN

Line 922: IF ( p_x_route_rec.segment15 = FND_API.G_MISS_CHAR ) THEN

918: IF ( p_x_route_rec.segment14 = FND_API.G_MISS_CHAR ) THEN
919: p_x_route_rec.segment14 := null;
920: END IF;
921:
922: IF ( p_x_route_rec.segment15 = FND_API.G_MISS_CHAR ) THEN
923: p_x_route_rec.segment15 := null;
924: END IF;
925:
926: IF ( p_x_route_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN

Line 926: IF ( p_x_route_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN

922: IF ( p_x_route_rec.segment15 = FND_API.G_MISS_CHAR ) THEN
923: p_x_route_rec.segment15 := null;
924: END IF;
925:
926: IF ( p_x_route_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
927: p_x_route_rec.attribute_category := null;
928: END IF;
929:
930: IF ( p_x_route_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN

Line 930: IF ( p_x_route_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN

926: IF ( p_x_route_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
927: p_x_route_rec.attribute_category := null;
928: END IF;
929:
930: IF ( p_x_route_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
931: p_x_route_rec.attribute1 := null;
932: END IF;
933:
934: IF ( p_x_route_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN

Line 934: IF ( p_x_route_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN

930: IF ( p_x_route_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
931: p_x_route_rec.attribute1 := null;
932: END IF;
933:
934: IF ( p_x_route_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
935: p_x_route_rec.attribute2 := null;
936: END IF;
937:
938: IF ( p_x_route_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN

Line 938: IF ( p_x_route_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN

934: IF ( p_x_route_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
935: p_x_route_rec.attribute2 := null;
936: END IF;
937:
938: IF ( p_x_route_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
939: p_x_route_rec.attribute3 := null;
940: END IF;
941:
942: IF ( p_x_route_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN

Line 942: IF ( p_x_route_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN

938: IF ( p_x_route_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
939: p_x_route_rec.attribute3 := null;
940: END IF;
941:
942: IF ( p_x_route_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
943: p_x_route_rec.attribute4 := null;
944: END IF;
945:
946: IF ( p_x_route_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN

Line 946: IF ( p_x_route_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN

942: IF ( p_x_route_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
943: p_x_route_rec.attribute4 := null;
944: END IF;
945:
946: IF ( p_x_route_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
947: p_x_route_rec.attribute5 := null;
948: END IF;
949:
950: IF ( p_x_route_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN

Line 950: IF ( p_x_route_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN

946: IF ( p_x_route_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
947: p_x_route_rec.attribute5 := null;
948: END IF;
949:
950: IF ( p_x_route_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
951: p_x_route_rec.attribute6 := null;
952: END IF;
953:
954: IF ( p_x_route_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN

Line 954: IF ( p_x_route_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN

950: IF ( p_x_route_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
951: p_x_route_rec.attribute6 := null;
952: END IF;
953:
954: IF ( p_x_route_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
955: p_x_route_rec.attribute7 := null;
956: END IF;
957:
958: IF ( p_x_route_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN

Line 958: IF ( p_x_route_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN

954: IF ( p_x_route_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
955: p_x_route_rec.attribute7 := null;
956: END IF;
957:
958: IF ( p_x_route_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
959: p_x_route_rec.attribute8 := null;
960: END IF;
961:
962: IF ( p_x_route_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN

Line 962: IF ( p_x_route_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN

958: IF ( p_x_route_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
959: p_x_route_rec.attribute8 := null;
960: END IF;
961:
962: IF ( p_x_route_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
963: p_x_route_rec.attribute9 := null;
964: END IF;
965:
966: IF ( p_x_route_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN

Line 966: IF ( p_x_route_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN

962: IF ( p_x_route_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
963: p_x_route_rec.attribute9 := null;
964: END IF;
965:
966: IF ( p_x_route_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
967: p_x_route_rec.attribute10 := null;
968: END IF;
969:
970: IF ( p_x_route_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN

Line 970: IF ( p_x_route_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN

966: IF ( p_x_route_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
967: p_x_route_rec.attribute10 := null;
968: END IF;
969:
970: IF ( p_x_route_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
971: p_x_route_rec.attribute11 := null;
972: END IF;
973:
974: IF ( p_x_route_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN

Line 974: IF ( p_x_route_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN

970: IF ( p_x_route_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
971: p_x_route_rec.attribute11 := null;
972: END IF;
973:
974: IF ( p_x_route_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
975: p_x_route_rec.attribute12 := null;
976: END IF;
977:
978: IF ( p_x_route_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN

Line 978: IF ( p_x_route_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN

974: IF ( p_x_route_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
975: p_x_route_rec.attribute12 := null;
976: END IF;
977:
978: IF ( p_x_route_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
979: p_x_route_rec.attribute13 := null;
980: END IF;
981:
982: IF ( p_x_route_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN

Line 982: IF ( p_x_route_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN

978: IF ( p_x_route_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
979: p_x_route_rec.attribute13 := null;
980: END IF;
981:
982: IF ( p_x_route_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
983: p_x_route_rec.attribute14 := null;
984: END IF;
985:
986: IF ( p_x_route_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN

Line 986: IF ( p_x_route_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN

982: IF ( p_x_route_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
983: p_x_route_rec.attribute14 := null;
984: END IF;
985:
986: IF ( p_x_route_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN
987: p_x_route_rec.attribute15 := null;
988: END IF;
989:
990: --pdoki added for Bug 6504159

Line 991: IF ( p_x_route_rec.unit_receipt_update_flag = FND_API.G_MISS_CHAR ) THEN

987: p_x_route_rec.attribute15 := null;
988: END IF;
989:
990: --pdoki added for Bug 6504159
991: IF ( p_x_route_rec.unit_receipt_update_flag = FND_API.G_MISS_CHAR ) THEN
992: p_x_route_rec.unit_receipt_update_flag := 'N';
993: END IF;
994: END default_missing_attributes;
995:

Line 1098: x_return_status := FND_API.G_RET_STS_SUCCESS;

1094: FROM AHL_ROUTES_V
1095: WHERE route_id = c_route_id;
1096:
1097: BEGIN
1098: x_return_status := FND_API.G_RET_STS_SUCCESS;
1099:
1100: -- Get the old record from AHL_ROUTES_V.
1101: OPEN get_old_rec( p_route_id );
1102:

Line 1192: x_return_status := FND_API.G_RET_STS_ERROR;

1188: p_x_route_rec.attribute15;
1189:
1190: IF ( get_old_rec%NOTFOUND ) THEN
1191: x_msg_data := 'AHL_RM_INVALID_ROUTE';
1192: x_return_status := FND_API.G_RET_STS_ERROR;
1193: END IF;
1194:
1195: IF ( p_x_route_rec.object_version_number <> p_object_version_number ) THEN
1196: x_msg_data := 'AHL_COM_RECORD_CHANGED';

Line 1197: x_return_status := FND_API.G_RET_STS_ERROR;

1193: END IF;
1194:
1195: IF ( p_x_route_rec.object_version_number <> p_object_version_number ) THEN
1196: x_msg_data := 'AHL_COM_RECORD_CHANGED';
1197: x_return_status := FND_API.G_RET_STS_ERROR;
1198: END IF;
1199:
1200: CLOSE get_old_rec;
1201:

Line 1229: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

1225: p_object_version_number => p_x_route_rec.object_version_number,
1226: p_x_route_rec => l_old_route_rec
1227: );
1228:
1229: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1230: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1231: FND_MSG_PUB.add;
1232: RAISE FND_API.G_EXC_ERROR;
1233: END IF;

Line 1232: RAISE FND_API.G_EXC_ERROR;

1228:
1229: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1230: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1231: FND_MSG_PUB.add;
1232: RAISE FND_API.G_EXC_ERROR;
1233: END IF;
1234:
1235: -- Convert G_MISS values to NULL and NULL values to Old values
1236: IF ( p_x_route_rec.revision_status_code IS NULL ) THEN

Line 1260: ELSIF ( p_x_route_rec.model_code = FND_API.G_MISS_CHAR ) THEN

1256: -- reorganized the in phase I for model code validation
1257: -- Model code change is not allowed for automatic routes.
1258: IF ( p_x_route_rec.model_code IS NULL ) THEN
1259: p_x_route_rec.model_code := l_old_route_rec.model_code;
1260: ELSIF ( p_x_route_rec.model_code = FND_API.G_MISS_CHAR ) THEN
1261: p_x_route_rec.model_code := null;
1262: END IF;
1263:
1264: IF( upper(l_old_route_rec.enigma_source_code) = 'AUTOMATIC' AND p_x_route_rec.model_code <> l_old_route_rec.model_code ) THEN

Line 1271: ELSIF ( p_x_route_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN

1267: END IF;
1268:
1269: IF ( p_x_route_rec.model_meaning IS NULL ) THEN
1270: p_x_route_rec.model_meaning := l_old_route_rec.model_meaning;
1271: ELSIF ( p_x_route_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN
1272: p_x_route_rec.model_meaning := null;
1273: END IF;
1274:
1275: IF (upper(l_old_route_rec.enigma_source_code) = 'AUTOMATIC' AND p_x_route_rec.model_meaning <> l_old_route_rec.model_meaning ) THEN

Line 1282: ELSIF ( p_x_route_rec.file_id = FND_API.G_MISS_NUM) THEN

1278: END IF;
1279:
1280: IF ( upper(l_old_route_rec.enigma_source_code) = 'AUTOMATIC' AND p_x_route_rec.file_id IS NULL ) THEN
1281: p_x_route_rec.file_id := l_old_route_rec.file_id;
1282: ELSIF ( p_x_route_rec.file_id = FND_API.G_MISS_NUM) THEN
1283: p_x_route_rec.file_id := null;
1284: END IF;
1285: --bachandr Enigma Phase I changes -- end
1286: --snarkhed Enigma Phase II changes --start

Line 1289: IF ( p_x_route_rec.enigma_doc_id = FND_API.G_MISS_CHAR ) THEN

1285: --bachandr Enigma Phase I changes -- end
1286: --snarkhed Enigma Phase II changes --start
1287: -- For automatic enigma doc id can only be changed through BPEL.
1288:
1289: IF ( p_x_route_rec.enigma_doc_id = FND_API.G_MISS_CHAR ) THEN
1290: p_x_route_rec.enigma_doc_id := NULL;
1291: ELSIF ( p_x_route_rec.enigma_doc_id = NULL ) THEN
1292: p_x_route_rec.enigma_doc_id := l_old_route_rec.enigma_doc_id;
1293: END IF;

Line 1303: ELSIF (p_x_route_rec.job_card_lyt_meaning = FND_API.G_MISS_CHAR) THEN

1299:
1300: -- IF Job Card Layout Defaulting logic.
1301: IF ( p_x_route_rec.job_card_lyt_meaning IS NULL) THEN
1302: p_x_route_rec.job_card_lyt_code := l_old_route_rec.job_card_lyt_code;
1303: ELSIF (p_x_route_rec.job_card_lyt_meaning = FND_API.G_MISS_CHAR) THEN
1304: p_x_route_rec.job_card_lyt_code := NULL;
1305: END IF;
1306:
1307: --snarkhed Enigma Phase II changes End

Line 1344: ELSIF ( p_x_route_rec.active_start_date = FND_API.G_MISS_DATE ) THEN

1340: ELSE
1341: IF ( l_read_only_flag = 'Y' ) THEN
1342: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ST_DATE_RO' );
1343: FND_MSG_PUB.add;
1344: ELSIF ( p_x_route_rec.active_start_date = FND_API.G_MISS_DATE ) THEN
1345: p_x_route_rec.active_start_date := NULL;
1346: END IF;
1347: END IF;
1348:

Line 1360: ELSIF ( p_x_route_rec.route_type_code = FND_API.G_MISS_CHAR ) THEN

1356: END IF;
1357:
1358: IF ( p_x_route_rec.route_type_code IS NULL ) THEN
1359: p_x_route_rec.route_type_code := l_old_route_rec.route_type_code;
1360: ELSIF ( p_x_route_rec.route_type_code = FND_API.G_MISS_CHAR ) THEN
1361: p_x_route_rec.route_type_code := null;
1362: END IF;
1363:
1364: IF ( p_x_route_rec.route_type IS NULL ) THEN

Line 1366: ELSIF ( p_x_route_rec.route_type = FND_API.G_MISS_CHAR ) THEN

1362: END IF;
1363:
1364: IF ( p_x_route_rec.route_type IS NULL ) THEN
1365: p_x_route_rec.route_type := l_old_route_rec.route_type;
1366: ELSIF ( p_x_route_rec.route_type = FND_API.G_MISS_CHAR ) THEN
1367: p_x_route_rec.route_type := null;
1368: END IF;
1369: --pdoki added for Bug 6504159
1370: IF ( p_x_route_rec.unit_receipt_update_flag IS NULL ) THEN

Line 1372: ELSIF ( p_x_route_rec.unit_receipt_update_flag = FND_API.G_MISS_CHAR ) THEN

1368: END IF;
1369: --pdoki added for Bug 6504159
1370: IF ( p_x_route_rec.unit_receipt_update_flag IS NULL ) THEN
1371: p_x_route_rec.unit_receipt_update_flag := l_old_route_rec.unit_receipt_update_flag;
1372: ELSIF ( p_x_route_rec.unit_receipt_update_flag = FND_API.G_MISS_CHAR ) THEN
1373: p_x_route_rec.unit_receipt_update_flag := 'N';
1374: END IF;
1375:
1376: --bachandr Enigma Phase I changes -- start

Line 1381: ELSIF ( p_x_route_rec.model_code = FND_API.G_MISS_CHAR ) THEN

1377: --snarkhed Moved this logic above
1378: /* IF ( l_old_route_rec.enigma_doc_id IS NULL ) THEN
1379: IF ( p_x_route_rec.model_code IS NULL ) THEN
1380: p_x_route_rec.model_code := l_old_route_rec.model_code;
1381: ELSIF ( p_x_route_rec.model_code = FND_API.G_MISS_CHAR ) THEN
1382: p_x_route_rec.model_code := null;
1383: END IF;
1384:
1385: IF ( p_x_route_rec.model_meaning IS NULL ) THEN

Line 1387: ELSIF ( p_x_route_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN

1383: END IF;
1384:
1385: IF ( p_x_route_rec.model_meaning IS NULL ) THEN
1386: p_x_route_rec.model_meaning := l_old_route_rec.model_meaning;
1387: ELSIF ( p_x_route_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN
1388: p_x_route_rec.model_meaning := null;
1389: END IF;
1390: END IF;*/
1391: --bachandr Enigma Phase I changes -- end

Line 1395: ELSIF ( p_x_route_rec.process_code = FND_API.G_MISS_CHAR ) THEN

1391: --bachandr Enigma Phase I changes -- end
1392:
1393: IF ( p_x_route_rec.process_code IS NULL ) THEN
1394: p_x_route_rec.process_code := l_old_route_rec.process_code;
1395: ELSIF ( p_x_route_rec.process_code = FND_API.G_MISS_CHAR ) THEN
1396: p_x_route_rec.process_code := null;
1397: END IF;
1398:
1399: IF ( p_x_route_rec.process IS NULL ) THEN

Line 1401: ELSIF ( p_x_route_rec.process = FND_API.G_MISS_CHAR ) THEN

1397: END IF;
1398:
1399: IF ( p_x_route_rec.process IS NULL ) THEN
1400: p_x_route_rec.process := l_old_route_rec.process;
1401: ELSIF ( p_x_route_rec.process = FND_API.G_MISS_CHAR ) THEN
1402: p_x_route_rec.process := null;
1403: END IF;
1404:
1405: IF ( p_x_route_rec.product_type_code IS NULL ) THEN

Line 1407: ELSIF ( p_x_route_rec.product_type_code = FND_API.G_MISS_CHAR ) THEN

1403: END IF;
1404:
1405: IF ( p_x_route_rec.product_type_code IS NULL ) THEN
1406: p_x_route_rec.product_type_code := l_old_route_rec.product_type_code;
1407: ELSIF ( p_x_route_rec.product_type_code = FND_API.G_MISS_CHAR ) THEN
1408: p_x_route_rec.product_type_code := null;
1409: END IF;
1410:
1411: IF ( p_x_route_rec.product_type IS NULL ) THEN

Line 1413: ELSIF ( p_x_route_rec.product_type = FND_API.G_MISS_CHAR ) THEN

1409: END IF;
1410:
1411: IF ( p_x_route_rec.product_type IS NULL ) THEN
1412: p_x_route_rec.product_type := l_old_route_rec.product_type;
1413: ELSIF ( p_x_route_rec.product_type = FND_API.G_MISS_CHAR ) THEN
1414: p_x_route_rec.product_type := null;
1415: END IF;
1416:
1417: IF ( p_x_route_rec.operator_party_id IS NULL ) THEN

Line 1424: IF ( p_x_route_rec.operator_party_id = FND_API.G_MISS_NUM ) THEN

1420: IF ( l_read_only_flag = 'Y' ) THEN
1421: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_OPERATOR_RO' );
1422: FND_MSG_PUB.add;
1423: ELSE
1424: IF ( p_x_route_rec.operator_party_id = FND_API.G_MISS_NUM ) THEN
1425: p_x_route_rec.operator_party_id := null;
1426: END IF;
1427: END IF;
1428: END IF;

Line 1437: IF ( p_x_route_rec.operator_name = FND_API.G_MISS_CHAR ) THEN

1433: IF ( l_read_only_flag = 'Y' ) THEN
1434: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_OPERATOR_RO' );
1435: FND_MSG_PUB.add;
1436: ELSE
1437: IF ( p_x_route_rec.operator_name = FND_API.G_MISS_CHAR ) THEN
1438: p_x_route_rec.operator_name := null;
1439: END IF;
1440: END IF;
1441: END IF;

Line 1445: ELSIF ( p_x_route_rec.zone_code = FND_API.G_MISS_CHAR ) THEN

1441: END IF;
1442:
1443: IF ( p_x_route_rec.zone_code IS NULL ) THEN
1444: p_x_route_rec.zone_code := l_old_route_rec.zone_code;
1445: ELSIF ( p_x_route_rec.zone_code = FND_API.G_MISS_CHAR ) THEN
1446: p_x_route_rec.zone_code := null;
1447: END IF;
1448:
1449: IF ( p_x_route_rec.zone IS NULL ) THEN

Line 1451: ELSIF ( p_x_route_rec.zone = FND_API.G_MISS_CHAR ) THEN

1447: END IF;
1448:
1449: IF ( p_x_route_rec.zone IS NULL ) THEN
1450: p_x_route_rec.zone := l_old_route_rec.zone;
1451: ELSIF ( p_x_route_rec.zone = FND_API.G_MISS_CHAR ) THEN
1452: p_x_route_rec.zone := null;
1453: END IF;
1454:
1455: IF ( p_x_route_rec.sub_zone_code IS NULL ) THEN

Line 1457: ELSIF ( p_x_route_rec.sub_zone_code = FND_API.G_MISS_CHAR ) THEN

1453: END IF;
1454:
1455: IF ( p_x_route_rec.sub_zone_code IS NULL ) THEN
1456: p_x_route_rec.sub_zone_code := l_old_route_rec.sub_zone_code;
1457: ELSIF ( p_x_route_rec.sub_zone_code = FND_API.G_MISS_CHAR ) THEN
1458: p_x_route_rec.sub_zone_code := null;
1459: END IF;
1460:
1461: IF ( p_x_route_rec.sub_zone IS NULL ) THEN

Line 1463: ELSIF ( p_x_route_rec.sub_zone = FND_API.G_MISS_CHAR ) THEN

1459: END IF;
1460:
1461: IF ( p_x_route_rec.sub_zone IS NULL ) THEN
1462: p_x_route_rec.sub_zone := l_old_route_rec.sub_zone;
1463: ELSIF ( p_x_route_rec.sub_zone = FND_API.G_MISS_CHAR ) THEN
1464: p_x_route_rec.sub_zone := null;
1465: END IF;
1466:
1467: IF ( p_x_route_rec.service_item_id IS NULL ) THEN

Line 1474: IF ( p_x_route_rec.service_item_id = FND_API.G_MISS_NUM ) THEN

1470: IF ( l_read_only_flag = 'Y' ) THEN
1471: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_SVC_ITEM_RO' );
1472: FND_MSG_PUB.add;
1473: ELSE
1474: IF ( p_x_route_rec.service_item_id = FND_API.G_MISS_NUM ) THEN
1475: p_x_route_rec.service_item_id := null;
1476: END IF;
1477: END IF;
1478: END IF;

Line 1487: IF ( p_x_route_rec.service_item_org_id = FND_API.G_MISS_NUM ) THEN

1483: IF ( l_read_only_flag = 'Y' ) THEN
1484: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_SVC_ITEM_RO' );
1485: FND_MSG_PUB.add;
1486: ELSE
1487: IF ( p_x_route_rec.service_item_org_id = FND_API.G_MISS_NUM ) THEN
1488: p_x_route_rec.service_item_org_id := null;
1489: END IF;
1490: END IF;
1491: END IF;

Line 1500: IF ( p_x_route_rec.service_item_number = FND_API.G_MISS_CHAR ) THEN

1496: IF ( l_read_only_flag = 'Y' ) THEN
1497: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_SVC_ITEM_RO' );
1498: FND_MSG_PUB.add;
1499: ELSE
1500: IF ( p_x_route_rec.service_item_number = FND_API.G_MISS_CHAR ) THEN
1501: p_x_route_rec.service_item_number := null;
1502: END IF;
1503: END IF;
1504: END IF;

Line 1508: ELSIF ( p_x_route_rec.accounting_class_code = FND_API.G_MISS_CHAR ) THEN

1504: END IF;
1505:
1506: IF ( p_x_route_rec.accounting_class_code IS NULL ) THEN
1507: p_x_route_rec.accounting_class_code := l_old_route_rec.accounting_class_code;
1508: ELSIF ( p_x_route_rec.accounting_class_code = FND_API.G_MISS_CHAR ) THEN
1509: p_x_route_rec.accounting_class_code := null;
1510: END IF;
1511:
1512: IF ( p_x_route_rec.accounting_class_org_id IS NULL ) THEN

Line 1514: ELSIF ( p_x_route_rec.accounting_class_org_id = FND_API.G_MISS_NUM ) THEN

1510: END IF;
1511:
1512: IF ( p_x_route_rec.accounting_class_org_id IS NULL ) THEN
1513: p_x_route_rec.accounting_class_org_id := l_old_route_rec.accounting_class_org_id;
1514: ELSIF ( p_x_route_rec.accounting_class_org_id = FND_API.G_MISS_NUM ) THEN
1515: p_x_route_rec.accounting_class_org_id := null;
1516: END IF;
1517:
1518: IF ( p_x_route_rec.accounting_class IS NULL ) THEN

Line 1520: ELSIF ( p_x_route_rec.accounting_class = FND_API.G_MISS_CHAR ) THEN

1516: END IF;
1517:
1518: IF ( p_x_route_rec.accounting_class IS NULL ) THEN
1519: p_x_route_rec.accounting_class := l_old_route_rec.accounting_class;
1520: ELSIF ( p_x_route_rec.accounting_class = FND_API.G_MISS_CHAR ) THEN
1521: p_x_route_rec.accounting_class := null;
1522: END IF;
1523:
1524: IF ( p_x_route_rec.task_template_group_id IS NULL ) THEN

Line 1531: IF ( p_x_route_rec.task_template_group_id = FND_API.G_MISS_NUM ) THEN

1527: IF ( l_read_only_flag = 'Y' ) THEN
1528: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_TASK_TEMP_RO' );
1529: FND_MSG_PUB.add;
1530: ELSE
1531: IF ( p_x_route_rec.task_template_group_id = FND_API.G_MISS_NUM ) THEN
1532: p_x_route_rec.task_template_group_id := null;
1533: END IF;
1534: END IF;
1535: END IF;

Line 1544: IF ( p_x_route_rec.task_template_group = FND_API.G_MISS_CHAR ) THEN

1540: IF ( l_read_only_flag = 'Y' ) THEN
1541: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_TASK_TEMP_RO' );
1542: FND_MSG_PUB.add;
1543: ELSE
1544: IF ( p_x_route_rec.task_template_group = FND_API.G_MISS_CHAR ) THEN
1545: p_x_route_rec.task_template_group := null;
1546: END IF;
1547: END IF;
1548: END IF;

Line 1558: IF ( p_x_route_rec.warranty_template_id = FND_API.G_MISS_NUM ) THEN

1554: IF ( l_read_only_flag = 'Y' ) THEN
1555: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_WARR_TEMP_NAME_RO' );
1556: FND_MSG_PUB.add;
1557: ELSE
1558: IF ( p_x_route_rec.warranty_template_id = FND_API.G_MISS_NUM ) THEN
1559: p_x_route_rec.warranty_template_id := null;
1560: END IF;
1561: END IF;
1562: END IF;

Line 1571: IF ( p_x_route_rec.warranty_template_name = FND_API.G_MISS_CHAR ) THEN

1567: IF ( l_read_only_flag = 'Y' ) THEN
1568: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_WARR_TEMP_NAME_RO' );
1569: FND_MSG_PUB.add;
1570: ELSE
1571: IF ( p_x_route_rec.warranty_template_name = FND_API.G_MISS_CHAR ) THEN
1572: p_x_route_rec.warranty_template_name := null;
1573: END IF;
1574: END IF;
1575: END IF;

Line 1599: IF ( p_x_route_rec.qa_inspection_type = FND_API.G_MISS_CHAR ) THEN

1595: IF ( l_read_only_flag = 'Y' ) THEN
1596: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_QA_INSP_TYPE_RO' );
1597: FND_MSG_PUB.add;
1598: ELSE
1599: IF ( p_x_route_rec.qa_inspection_type = FND_API.G_MISS_CHAR ) THEN
1600: p_x_route_rec.qa_inspection_type := null;
1601: END IF;
1602: END IF;
1603: END IF;

Line 1612: IF ( p_x_route_rec.qa_inspection_type_desc = FND_API.G_MISS_CHAR ) THEN

1608: IF ( l_read_only_flag = 'Y' ) THEN
1609: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_QA_INSP_TYPE_RO' );
1610: FND_MSG_PUB.add;
1611: ELSE
1612: IF ( p_x_route_rec.qa_inspection_type_desc = FND_API.G_MISS_CHAR ) THEN
1613: p_x_route_rec.qa_inspection_type_desc := null;
1614: END IF;
1615: END IF;
1616: END IF;

Line 1620: ELSIF ( p_x_route_rec.time_span = FND_API.G_MISS_NUM ) THEN

1616: END IF;
1617:
1618: IF ( p_x_route_rec.time_span IS NULL ) THEN
1619: p_x_route_rec.time_span := l_old_route_rec.time_span;
1620: ELSIF ( p_x_route_rec.time_span = FND_API.G_MISS_NUM ) THEN
1621: p_x_route_rec.time_span := null;
1622: END IF;
1623:
1624: IF ( p_x_route_rec.remarks IS NULL ) THEN

Line 1626: ELSIF ( p_x_route_rec.remarks = FND_API.G_MISS_CHAR ) THEN

1622: END IF;
1623:
1624: IF ( p_x_route_rec.remarks IS NULL ) THEN
1625: p_x_route_rec.remarks := l_old_route_rec.remarks;
1626: ELSIF ( p_x_route_rec.remarks = FND_API.G_MISS_CHAR ) THEN
1627: p_x_route_rec.remarks := null;
1628: END IF;
1629:
1630: IF ( p_x_route_rec.revision_notes IS NULL ) THEN

Line 1632: ELSIF ( p_x_route_rec.revision_notes = FND_API.G_MISS_CHAR ) THEN

1628: END IF;
1629:
1630: IF ( p_x_route_rec.revision_notes IS NULL ) THEN
1631: p_x_route_rec.revision_notes := l_old_route_rec.revision_notes;
1632: ELSIF ( p_x_route_rec.revision_notes = FND_API.G_MISS_CHAR ) THEN
1633: p_x_route_rec.revision_notes := null;
1634: END IF;
1635:
1636: IF ( p_x_route_rec.segment1 IS NULL ) THEN

Line 1638: ELSIF ( p_x_route_rec.segment1 = FND_API.G_MISS_CHAR ) THEN

1634: END IF;
1635:
1636: IF ( p_x_route_rec.segment1 IS NULL ) THEN
1637: p_x_route_rec.segment1 := l_old_route_rec.segment1;
1638: ELSIF ( p_x_route_rec.segment1 = FND_API.G_MISS_CHAR ) THEN
1639: p_x_route_rec.segment1 := null;
1640: END IF;
1641:
1642: IF ( p_x_route_rec.segment2 IS NULL ) THEN

Line 1644: ELSIF ( p_x_route_rec.segment2 = FND_API.G_MISS_CHAR ) THEN

1640: END IF;
1641:
1642: IF ( p_x_route_rec.segment2 IS NULL ) THEN
1643: p_x_route_rec.segment2 := l_old_route_rec.segment2;
1644: ELSIF ( p_x_route_rec.segment2 = FND_API.G_MISS_CHAR ) THEN
1645: p_x_route_rec.segment2 := null;
1646: END IF;
1647:
1648: IF ( p_x_route_rec.segment3 IS NULL ) THEN

Line 1650: ELSIF ( p_x_route_rec.segment3 = FND_API.G_MISS_CHAR ) THEN

1646: END IF;
1647:
1648: IF ( p_x_route_rec.segment3 IS NULL ) THEN
1649: p_x_route_rec.segment3 := l_old_route_rec.segment3;
1650: ELSIF ( p_x_route_rec.segment3 = FND_API.G_MISS_CHAR ) THEN
1651: p_x_route_rec.segment3 := null;
1652: END IF;
1653:
1654: IF ( p_x_route_rec.segment4 IS NULL ) THEN

Line 1656: ELSIF ( p_x_route_rec.segment4 = FND_API.G_MISS_CHAR ) THEN

1652: END IF;
1653:
1654: IF ( p_x_route_rec.segment4 IS NULL ) THEN
1655: p_x_route_rec.segment4 := l_old_route_rec.segment4;
1656: ELSIF ( p_x_route_rec.segment4 = FND_API.G_MISS_CHAR ) THEN
1657: p_x_route_rec.segment4 := null;
1658: END IF;
1659:
1660: IF ( p_x_route_rec.segment5 IS NULL ) THEN

Line 1662: ELSIF ( p_x_route_rec.segment5 = FND_API.G_MISS_CHAR ) THEN

1658: END IF;
1659:
1660: IF ( p_x_route_rec.segment5 IS NULL ) THEN
1661: p_x_route_rec.segment5 := l_old_route_rec.segment5;
1662: ELSIF ( p_x_route_rec.segment5 = FND_API.G_MISS_CHAR ) THEN
1663: p_x_route_rec.segment5 := null;
1664: END IF;
1665:
1666: IF ( p_x_route_rec.segment6 IS NULL ) THEN

Line 1668: ELSIF ( p_x_route_rec.segment6 = FND_API.G_MISS_CHAR ) THEN

1664: END IF;
1665:
1666: IF ( p_x_route_rec.segment6 IS NULL ) THEN
1667: p_x_route_rec.segment6 := l_old_route_rec.segment6;
1668: ELSIF ( p_x_route_rec.segment6 = FND_API.G_MISS_CHAR ) THEN
1669: p_x_route_rec.segment6 := null;
1670: END IF;
1671:
1672: IF ( p_x_route_rec.segment7 IS NULL ) THEN

Line 1674: ELSIF ( p_x_route_rec.segment7 = FND_API.G_MISS_CHAR ) THEN

1670: END IF;
1671:
1672: IF ( p_x_route_rec.segment7 IS NULL ) THEN
1673: p_x_route_rec.segment7 := l_old_route_rec.segment7;
1674: ELSIF ( p_x_route_rec.segment7 = FND_API.G_MISS_CHAR ) THEN
1675: p_x_route_rec.segment7 := null;
1676: END IF;
1677:
1678: IF ( p_x_route_rec.segment8 IS NULL ) THEN

Line 1680: ELSIF ( p_x_route_rec.segment8 = FND_API.G_MISS_CHAR ) THEN

1676: END IF;
1677:
1678: IF ( p_x_route_rec.segment8 IS NULL ) THEN
1679: p_x_route_rec.segment8 := l_old_route_rec.segment8;
1680: ELSIF ( p_x_route_rec.segment8 = FND_API.G_MISS_CHAR ) THEN
1681: p_x_route_rec.segment8 := null;
1682: END IF;
1683:
1684: IF ( p_x_route_rec.segment9 IS NULL ) THEN

Line 1686: ELSIF ( p_x_route_rec.segment9 = FND_API.G_MISS_CHAR ) THEN

1682: END IF;
1683:
1684: IF ( p_x_route_rec.segment9 IS NULL ) THEN
1685: p_x_route_rec.segment9 := l_old_route_rec.segment9;
1686: ELSIF ( p_x_route_rec.segment9 = FND_API.G_MISS_CHAR ) THEN
1687: p_x_route_rec.segment9 := null;
1688: END IF;
1689:
1690: IF ( p_x_route_rec.segment10 IS NULL ) THEN

Line 1692: ELSIF ( p_x_route_rec.segment10 = FND_API.G_MISS_CHAR ) THEN

1688: END IF;
1689:
1690: IF ( p_x_route_rec.segment10 IS NULL ) THEN
1691: p_x_route_rec.segment10 := l_old_route_rec.segment10;
1692: ELSIF ( p_x_route_rec.segment10 = FND_API.G_MISS_CHAR ) THEN
1693: p_x_route_rec.segment10 := null;
1694: END IF;
1695:
1696: IF ( p_x_route_rec.segment11 IS NULL ) THEN

Line 1698: ELSIF ( p_x_route_rec.segment11 = FND_API.G_MISS_CHAR ) THEN

1694: END IF;
1695:
1696: IF ( p_x_route_rec.segment11 IS NULL ) THEN
1697: p_x_route_rec.segment11 := l_old_route_rec.segment11;
1698: ELSIF ( p_x_route_rec.segment11 = FND_API.G_MISS_CHAR ) THEN
1699: p_x_route_rec.segment11 := null;
1700: END IF;
1701:
1702: IF ( p_x_route_rec.segment12 IS NULL ) THEN

Line 1704: ELSIF ( p_x_route_rec.segment12 = FND_API.G_MISS_CHAR ) THEN

1700: END IF;
1701:
1702: IF ( p_x_route_rec.segment12 IS NULL ) THEN
1703: p_x_route_rec.segment12 := l_old_route_rec.segment12;
1704: ELSIF ( p_x_route_rec.segment12 = FND_API.G_MISS_CHAR ) THEN
1705: p_x_route_rec.segment12 := null;
1706: END IF;
1707:
1708: IF ( p_x_route_rec.segment13 IS NULL ) THEN

Line 1710: ELSIF ( p_x_route_rec.segment13 = FND_API.G_MISS_CHAR ) THEN

1706: END IF;
1707:
1708: IF ( p_x_route_rec.segment13 IS NULL ) THEN
1709: p_x_route_rec.segment13 := l_old_route_rec.segment13;
1710: ELSIF ( p_x_route_rec.segment13 = FND_API.G_MISS_CHAR ) THEN
1711: p_x_route_rec.segment13 := null;
1712: END IF;
1713:
1714: IF ( p_x_route_rec.segment14 IS NULL ) THEN

Line 1716: ELSIF ( p_x_route_rec.segment14 = FND_API.G_MISS_CHAR ) THEN

1712: END IF;
1713:
1714: IF ( p_x_route_rec.segment14 IS NULL ) THEN
1715: p_x_route_rec.segment14 := l_old_route_rec.segment14;
1716: ELSIF ( p_x_route_rec.segment14 = FND_API.G_MISS_CHAR ) THEN
1717: p_x_route_rec.segment14 := null;
1718: END IF;
1719:
1720: IF ( p_x_route_rec.segment15 IS NULL ) THEN

Line 1722: ELSIF ( p_x_route_rec.segment15 = FND_API.G_MISS_CHAR ) THEN

1718: END IF;
1719:
1720: IF ( p_x_route_rec.segment15 IS NULL ) THEN
1721: p_x_route_rec.segment15 := l_old_route_rec.segment15;
1722: ELSIF ( p_x_route_rec.segment15 = FND_API.G_MISS_CHAR ) THEN
1723: p_x_route_rec.segment15 := null;
1724: END IF;
1725:
1726: IF ( p_x_route_rec.attribute_category IS NULL ) THEN

Line 1728: ELSIF ( p_x_route_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN

1724: END IF;
1725:
1726: IF ( p_x_route_rec.attribute_category IS NULL ) THEN
1727: p_x_route_rec.attribute_category := l_old_route_rec.attribute_category;
1728: ELSIF ( p_x_route_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
1729: p_x_route_rec.attribute_category := null;
1730: END IF;
1731:
1732: IF ( p_x_route_rec.attribute1 IS NULL ) THEN

Line 1734: ELSIF ( p_x_route_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN

1730: END IF;
1731:
1732: IF ( p_x_route_rec.attribute1 IS NULL ) THEN
1733: p_x_route_rec.attribute1 := l_old_route_rec.attribute1;
1734: ELSIF ( p_x_route_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
1735: p_x_route_rec.attribute1 := null;
1736: END IF;
1737:
1738: IF ( p_x_route_rec.attribute2 IS NULL ) THEN

Line 1740: ELSIF ( p_x_route_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN

1736: END IF;
1737:
1738: IF ( p_x_route_rec.attribute2 IS NULL ) THEN
1739: p_x_route_rec.attribute2 := l_old_route_rec.attribute2;
1740: ELSIF ( p_x_route_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
1741: p_x_route_rec.attribute2 := null;
1742: END IF;
1743:
1744: IF ( p_x_route_rec.attribute3 IS NULL ) THEN

Line 1746: ELSIF ( p_x_route_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN

1742: END IF;
1743:
1744: IF ( p_x_route_rec.attribute3 IS NULL ) THEN
1745: p_x_route_rec.attribute3 := l_old_route_rec.attribute3;
1746: ELSIF ( p_x_route_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
1747: p_x_route_rec.attribute3 := null;
1748: END IF;
1749:
1750: IF ( p_x_route_rec.attribute4 IS NULL ) THEN

Line 1752: ELSIF ( p_x_route_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN

1748: END IF;
1749:
1750: IF ( p_x_route_rec.attribute4 IS NULL ) THEN
1751: p_x_route_rec.attribute4 := l_old_route_rec.attribute4;
1752: ELSIF ( p_x_route_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
1753: p_x_route_rec.attribute4 := null;
1754: END IF;
1755:
1756: IF ( p_x_route_rec.attribute5 IS NULL ) THEN

Line 1758: ELSIF ( p_x_route_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN

1754: END IF;
1755:
1756: IF ( p_x_route_rec.attribute5 IS NULL ) THEN
1757: p_x_route_rec.attribute5 := l_old_route_rec.attribute5;
1758: ELSIF ( p_x_route_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
1759: p_x_route_rec.attribute5 := null;
1760: END IF;
1761:
1762: IF ( p_x_route_rec.attribute6 IS NULL ) THEN

Line 1764: ELSIF ( p_x_route_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN

1760: END IF;
1761:
1762: IF ( p_x_route_rec.attribute6 IS NULL ) THEN
1763: p_x_route_rec.attribute6 := l_old_route_rec.attribute6;
1764: ELSIF ( p_x_route_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
1765: p_x_route_rec.attribute6 := null;
1766: END IF;
1767:
1768: IF ( p_x_route_rec.attribute7 IS NULL ) THEN

Line 1770: ELSIF ( p_x_route_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN

1766: END IF;
1767:
1768: IF ( p_x_route_rec.attribute7 IS NULL ) THEN
1769: p_x_route_rec.attribute7 := l_old_route_rec.attribute7;
1770: ELSIF ( p_x_route_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
1771: p_x_route_rec.attribute7 := null;
1772: END IF;
1773:
1774: IF ( p_x_route_rec.attribute8 IS NULL ) THEN

Line 1776: ELSIF ( p_x_route_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN

1772: END IF;
1773:
1774: IF ( p_x_route_rec.attribute8 IS NULL ) THEN
1775: p_x_route_rec.attribute8 := l_old_route_rec.attribute8;
1776: ELSIF ( p_x_route_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
1777: p_x_route_rec.attribute8 := null;
1778: END IF;
1779:
1780: IF ( p_x_route_rec.attribute9 IS NULL ) THEN

Line 1782: ELSIF ( p_x_route_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN

1778: END IF;
1779:
1780: IF ( p_x_route_rec.attribute9 IS NULL ) THEN
1781: p_x_route_rec.attribute9 := l_old_route_rec.attribute9;
1782: ELSIF ( p_x_route_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
1783: p_x_route_rec.attribute9 := null;
1784: END IF;
1785:
1786: IF ( p_x_route_rec.attribute10 IS NULL ) THEN

Line 1788: ELSIF ( p_x_route_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN

1784: END IF;
1785:
1786: IF ( p_x_route_rec.attribute10 IS NULL ) THEN
1787: p_x_route_rec.attribute10 := l_old_route_rec.attribute10;
1788: ELSIF ( p_x_route_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
1789: p_x_route_rec.attribute10 := null;
1790: END IF;
1791:
1792: IF ( p_x_route_rec.attribute11 IS NULL ) THEN

Line 1794: ELSIF ( p_x_route_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN

1790: END IF;
1791:
1792: IF ( p_x_route_rec.attribute11 IS NULL ) THEN
1793: p_x_route_rec.attribute11 := l_old_route_rec.attribute11;
1794: ELSIF ( p_x_route_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
1795: p_x_route_rec.attribute11 := null;
1796: END IF;
1797:
1798: IF ( p_x_route_rec.attribute12 IS NULL ) THEN

Line 1800: ELSIF ( p_x_route_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN

1796: END IF;
1797:
1798: IF ( p_x_route_rec.attribute12 IS NULL ) THEN
1799: p_x_route_rec.attribute12 := l_old_route_rec.attribute12;
1800: ELSIF ( p_x_route_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
1801: p_x_route_rec.attribute12 := null;
1802: END IF;
1803:
1804: IF ( p_x_route_rec.attribute13 IS NULL ) THEN

Line 1806: ELSIF ( p_x_route_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN

1802: END IF;
1803:
1804: IF ( p_x_route_rec.attribute13 IS NULL ) THEN
1805: p_x_route_rec.attribute13 := l_old_route_rec.attribute13;
1806: ELSIF ( p_x_route_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
1807: p_x_route_rec.attribute13 := null;
1808: END IF;
1809:
1810: IF ( p_x_route_rec.attribute14 IS NULL ) THEN

Line 1812: ELSIF ( p_x_route_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN

1808: END IF;
1809:
1810: IF ( p_x_route_rec.attribute14 IS NULL ) THEN
1811: p_x_route_rec.attribute14 := l_old_route_rec.attribute14;
1812: ELSIF ( p_x_route_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
1813: p_x_route_rec.attribute14 := null;
1814: END IF;
1815:
1816: IF ( p_x_route_rec.attribute15 IS NULL ) THEN

Line 1818: ELSIF ( p_x_route_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN

1814: END IF;
1815:
1816: IF ( p_x_route_rec.attribute15 IS NULL ) THEN
1817: p_x_route_rec.attribute15 := l_old_route_rec.attribute15;
1818: ELSIF ( p_x_route_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN
1819: p_x_route_rec.attribute15 := null;
1820: END IF;
1821:
1822: END default_unchanged_attributes;

Line 1849: x_return_status := FND_API.G_RET_STS_SUCCESS;

1845: l_enigma_avail varchar2(80);
1846: --bachandr Enigma Phase I changes -- end
1847:
1848: BEGIN
1849: x_return_status := FND_API.G_RET_STS_SUCCESS;
1850:
1851: -- Check if the Revision Status code does not column contains a null value.
1852: /*
1853: * Removing this as revision status for a newly created route is always DRAFT and need not be passed from

Line 1860: p_route_rec.revision_status_code = FND_API.G_MISS_CHAR ) THEN

1856: */
1857: /*
1858: IF ( ( p_route_rec.dml_operation = 'C' AND
1859: p_route_rec.revision_status_code IS NULL ) OR
1860: p_route_rec.revision_status_code = FND_API.G_MISS_CHAR ) THEN
1861: FND_MESSAGE.set_name( 'AHL','AHL_RM_STATUS_NULL' );
1862: FND_MSG_PUB.add;
1863: END IF;
1864: */

Line 1869: p_route_rec.route_no = FND_API.G_MISS_CHAR ) THEN

1865:
1866: -- Check if the Route Number does not column contains a null value.
1867: IF ( ( p_route_rec.dml_operation = 'C' AND
1868: p_route_rec.route_no IS NULL ) OR
1869: p_route_rec.route_no = FND_API.G_MISS_CHAR ) THEN
1870: FND_MESSAGE.set_name( 'AHL','AHL_RM_ROUTE_NO_NULL' );
1871: FND_MSG_PUB.add;
1872: END IF;
1873:

Line 1877: p_route_rec.title = FND_API.G_MISS_CHAR ) THEN

1873:
1874: -- Check if the Route Title does not column contains a null value.
1875: IF ( ( p_route_rec.dml_operation = 'C' AND
1876: p_route_rec.title IS NULL ) OR
1877: p_route_rec.title = FND_API.G_MISS_CHAR ) THEN
1878: FND_MESSAGE.set_name( 'AHL','AHL_RM_ROUTE_TITLE_NULL' );
1879: FND_MSG_PUB.add;
1880: END IF;
1881:

Line 1885: p_route_rec.active_start_date = FND_API.G_MISS_DATE ) THEN

1881:
1882: -- Check if the Route Start Date does not column contains a null value.
1883: IF ( ( p_route_rec.dml_operation = 'C' AND
1884: p_route_rec.active_start_date IS NULL ) OR
1885: p_route_rec.active_start_date = FND_API.G_MISS_DATE ) THEN
1886: FND_MESSAGE.set_name( 'AHL','AHL_RM_ST_DATE_NULL' );
1887: FND_MSG_PUB.add;
1888: END IF;
1889:

Line 1898: p_route_rec.time_span = FND_API.G_MISS_NUM ) THEN

1894: SELECT trim(fnd_profile.value('AHL_ENIGMA_3C_URL')) INTO l_enigma_avail FROM dual;
1895: IF l_enigma_avail = 'N' THEN
1896: IF ( ( p_route_rec.dml_operation = 'C' AND
1897: p_route_rec.time_span IS NULL ) OR
1898: p_route_rec.time_span = FND_API.G_MISS_NUM ) THEN
1899: FND_MESSAGE.set_name( 'AHL','AHL_RM_TIME_SPAN_NULL' );
1900: FND_MSG_PUB.add;
1901: END IF;
1902: END IF;

Line 1908: IF (( p_route_rec.model_code IS NULL OR p_route_rec.model_code = FND_API.G_MISS_CHAR ) AND

1904: -- Check if the model code or meaning is not null for create
1905: -- when the route is created from Enigma
1906: -- modified by snarkhed since from enigma phase II:: Model code is mandatory for Enigma Routes
1907: IF ( (upper(p_route_rec.enigma_source_code) = 'AUTOMATIC') OR upper(p_route_rec.enigma_source_code) = 'MANUAL') THEN
1908: IF (( p_route_rec.model_code IS NULL OR p_route_rec.model_code = FND_API.G_MISS_CHAR ) AND
1909: ( p_route_rec.model_meaning IS NULL OR p_route_rec.model_meaning = FND_API.G_MISS_CHAR ) )THEN
1910: FND_MESSAGE.set_name( 'AHL','AHL_RM_MODEL_CODE_NULL' );
1911: FND_MSG_PUB.add;
1912: END IF;

Line 1909: ( p_route_rec.model_meaning IS NULL OR p_route_rec.model_meaning = FND_API.G_MISS_CHAR ) )THEN

1905: -- when the route is created from Enigma
1906: -- modified by snarkhed since from enigma phase II:: Model code is mandatory for Enigma Routes
1907: IF ( (upper(p_route_rec.enigma_source_code) = 'AUTOMATIC') OR upper(p_route_rec.enigma_source_code) = 'MANUAL') THEN
1908: IF (( p_route_rec.model_code IS NULL OR p_route_rec.model_code = FND_API.G_MISS_CHAR ) AND
1909: ( p_route_rec.model_meaning IS NULL OR p_route_rec.model_meaning = FND_API.G_MISS_CHAR ) )THEN
1910: FND_MESSAGE.set_name( 'AHL','AHL_RM_MODEL_CODE_NULL' );
1911: FND_MSG_PUB.add;
1912: END IF;
1913: END IF;

Line 1918: p_route_rec.time_span <> FND_API.G_MISS_NUM AND

1914: --bachandr Enigma Phase I changes -- end
1915:
1916: -- Check if Time Span is not less than or equal to zero
1917: IF ( p_route_rec.time_span IS NOT NULL AND
1918: p_route_rec.time_span <> FND_API.G_MISS_NUM AND
1919: p_route_rec.time_span <= 0 ) THEN
1920: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_TIME_SPAN' );
1921: FND_MESSAGE.set_token( 'FIELD', p_route_rec.time_span );
1922: FND_MSG_PUB.add;

Line 1931: p_route_rec.route_id = FND_API.G_MISS_NUM ) THEN

1927: END IF;
1928:
1929: -- Check if the mandatory Route ID column contains a null value.
1930: IF ( p_route_rec.route_id IS NULL OR
1931: p_route_rec.route_id = FND_API.G_MISS_NUM ) THEN
1932: FND_MESSAGE.set_name( 'AHL','AHL_RM_ROUTE_ID_NULL' );
1933: FND_MSG_PUB.add;
1934: RETURN;
1935: END IF;

Line 1939: p_route_rec.object_version_number = FND_API.G_MISS_NUM ) THEN

1935: END IF;
1936:
1937: -- Check if the mandatory Object Version Number column contains a null value.
1938: IF ( p_route_rec.object_version_number IS NULL OR
1939: p_route_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
1940: FND_MESSAGE.set_name( 'AHL','AHL_RM_OBJ_VERSION_NULL' );
1941: FND_MSG_PUB.add;
1942: RETURN;
1943: END IF;

Line 1947: p_route_rec.time_span <> FND_API.G_MISS_NUM AND

1943: END IF;
1944:
1945: -- Validate whether the Time Span of the Route is Greater than the Longest Resource Duration for the Same Route and all the Associated Operations
1946: IF ( p_route_rec.time_span IS NOT NULL AND
1947: p_route_rec.time_span <> FND_API.G_MISS_NUM AND
1948: p_route_rec.time_span > 0 ) THEN
1949:
1950: -- Bug # 8639648 - start
1951: AHL_RM_ROUTE_UTIL.validate_route_time_span

Line 1963: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

1959: );
1960:
1961: -- Bug # 8639648 - end
1962:
1963: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1964: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1965: FND_MESSAGE.set_token( 'FIELD1', l_res_max_duration );
1966: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.time_span );
1967: FND_MSG_PUB.add;

Line 1976: x_return_status := FND_API.G_RET_STS_ERROR;

1972: IF (p_route_rec.dml_operation = 'U' AND p_route_rec.revision_status_code IN ('COMPLETE', 'APPROVAL_PENDING', 'TERMINATION_PENDING', 'TERMINATED'))
1973: THEN
1974: FND_MESSAGE.set_name( 'AHL','AHL_RM_RT_STS_NO_UPD' );
1975: FND_MSG_PUB.add;
1976: x_return_status := FND_API.G_RET_STS_ERROR;
1977: END IF;
1978: -- Added by Tamal for Bug #3854052
1979:
1980: IF (p_route_rec.dml_operation IN ('U','D'))

Line 2015: --x_return_status := FND_API.G_RET_STS_SUCCESS;

2011: WHERE UPPER(TRIM(route_no)) = UPPER(TRIM(c_route_no))
2012: AND revision_number = nvl(c_revision_number,1);
2013:
2014: BEGIN
2015: --x_return_status := FND_API.G_RET_STS_SUCCESS;
2016:
2017: -- Check if Duplicate Route Number exists
2018: OPEN get_dup_rec( p_route_rec.route_no , p_route_rec.revision_number );
2019:

Line 2028: x_return_status := FND_API.G_RET_STS_ERROR;

2024: -- if its create then p_route_rec.route_id = null and any duplicate record should make you throw an err.
2025: IF ( get_dup_rec%FOUND ) THEN
2026: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );
2027: FND_MSG_PUB.add;
2028: x_return_status := FND_API.G_RET_STS_ERROR;
2029: END IF;
2030: ELSIF ( p_route_rec.dml_operation = 'U' )
2031: THEN
2032: IF ( l_route_id <> p_route_rec.route_id ) THEN

Line 2035: x_return_status := FND_API.G_RET_STS_ERROR;

2031: THEN
2032: IF ( l_route_id <> p_route_rec.route_id ) THEN
2033: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );
2034: FND_MSG_PUB.add;
2035: x_return_status := FND_API.G_RET_STS_ERROR;
2036: END IF;
2037: END IF;
2038:
2039: CLOSE get_dup_rec;

Line 2046: p_route_rec.active_start_date <> FND_API.G_MISS_DATE AND

2042: /*
2043: IF ( ( p_route_rec.revision_status_code = 'DRAFT' OR
2044: p_route_rec.revision_status_code = 'APPROVAL_REJECTED' ) AND
2045: p_route_rec.active_start_date IS NOT NULL AND
2046: p_route_rec.active_start_date <> FND_API.G_MISS_DATE AND
2047: TRUNC( p_route_rec.active_start_date ) < TRUNC( SYSDATE ) ) THEN
2048: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_ST_DATE' );
2049: FND_MESSAGE.set_token( 'FIELD', SYSDATE );
2050: FND_MSG_PUB.add;

Line 2070: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

2066: p_start_date => p_route_rec.active_start_date,
2067: x_start_date => l_start_date
2068: );
2069:
2070: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
2071: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2072: FND_MESSAGE.set_token( 'FIELD', l_start_date );
2073: FND_MSG_PUB.add;
2074: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2074: x_return_status := FND_API.G_RET_STS_ERROR;

2070: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
2071: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2072: FND_MESSAGE.set_token( 'FIELD', l_start_date );
2073: FND_MSG_PUB.add;
2074: x_return_status := FND_API.G_RET_STS_ERROR;
2075: END IF;
2076: END IF;
2077:
2078: -- Check if Zone contains a value but, the Product Type is NULL

Line 2085: x_return_status := FND_API.G_RET_STS_ERROR;

2081: ( p_route_rec.product_type IS NULL AND
2082: p_route_rec.product_type_code IS NULL ) ) THEN
2083: FND_MESSAGE.set_name( 'AHL','AHL_RM_PT_NULL_ZONE_NOTNULL' );
2084: FND_MSG_PUB.add;
2085: x_return_status := FND_API.G_RET_STS_ERROR;
2086: END IF;
2087:
2088: -- Check if Sub Zone contains a value but, the Product Type or Zone are NULL
2089: IF ( ( p_route_rec.sub_zone IS NOT NULL OR

Line 2097: x_return_status := FND_API.G_RET_STS_ERROR;

2093: ( p_route_rec.zone IS NULL AND
2094: p_route_rec.zone_code IS NULL ) ) ) THEN
2095: FND_MESSAGE.set_name( 'AHL','AHL_RM_PT_NULL_SUBZONE_NOTNULL' );
2096: FND_MSG_PUB.add;
2097: x_return_status := FND_API.G_RET_STS_ERROR;
2098: END IF;
2099:
2100: -- Check if the Zone is valid for the Product Type
2101: IF ( p_route_rec.product_type_code IS NOT NULL AND

Line 2112: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

2108: p_product_type_code => p_route_rec.product_type_code,
2109: p_zone_code => p_route_rec.zone_code
2110: );
2111:
2112: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
2113: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2114: IF ( p_route_rec.zone IS NULL ) THEN
2115: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.zone_code );
2116: ELSE

Line 2127: x_return_status := FND_API.G_RET_STS_ERROR;

2123: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.product_type );
2124: END IF;
2125:
2126: FND_MSG_PUB.add;
2127: x_return_status := FND_API.G_RET_STS_ERROR;
2128: END IF;
2129: END IF;
2130:
2131: -- Check if the Sub Zone is valid for the Product Type and Zone

Line 2145: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

2141: p_zone_code => p_route_rec.zone_code,
2142: p_sub_zone_code => p_route_rec.sub_zone_code
2143: );
2144:
2145: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
2146: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2147: IF ( p_route_rec.sub_zone IS NULL ) THEN
2148: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.sub_zone_code );
2149: ELSE

Line 2166: x_return_status := FND_API.G_RET_STS_ERROR;

2162: FND_MESSAGE.set_token( 'FIELD3', p_route_rec.product_type );
2163: END IF;
2164:
2165: FND_MSG_PUB.add;
2166: x_return_status := FND_API.G_RET_STS_ERROR;
2167: END IF;
2168: END IF;
2169:
2170: END validate_record;

Line 2175: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

2171:
2172: PROCEDURE process_route
2173: (
2174: p_api_version IN NUMBER := '1.0',
2175: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2176: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2178: p_default IN VARCHAR2 := FND_API.G_FALSE,
2179: p_module_type IN VARCHAR2 := NULL,

Line 2176: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2172: PROCEDURE process_route
2173: (
2174: p_api_version IN NUMBER := '1.0',
2175: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2176: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2178: p_default IN VARCHAR2 := FND_API.G_FALSE,
2179: p_module_type IN VARCHAR2 := NULL,
2180: x_return_status OUT NOCOPY VARCHAR2,

Line 2177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2173: (
2174: p_api_version IN NUMBER := '1.0',
2175: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2176: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2178: p_default IN VARCHAR2 := FND_API.G_FALSE,
2179: p_module_type IN VARCHAR2 := NULL,
2180: x_return_status OUT NOCOPY VARCHAR2,
2181: x_msg_count OUT NOCOPY NUMBER,

Line 2178: p_default IN VARCHAR2 := FND_API.G_FALSE,

2174: p_api_version IN NUMBER := '1.0',
2175: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2176: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2178: p_default IN VARCHAR2 := FND_API.G_FALSE,
2179: p_module_type IN VARCHAR2 := NULL,
2180: x_return_status OUT NOCOPY VARCHAR2,
2181: x_msg_count OUT NOCOPY NUMBER,
2182: x_msg_data OUT NOCOPY VARCHAR2,

Line 2231: x_return_status := FND_API.G_RET_STS_SUCCESS;

2227:
2228:
2229: BEGIN
2230: -- Initialize API return status to success
2231: x_return_status := FND_API.G_RET_STS_SUCCESS;
2232:
2233: -- Standard Start of API savepoint
2234: SAVEPOINT process_route_PVT;
2235:

Line 2237: IF NOT FND_API.compatible_api_call

2233: -- Standard Start of API savepoint
2234: SAVEPOINT process_route_PVT;
2235:
2236: -- Standard call to check for call compatibility.
2237: IF NOT FND_API.compatible_api_call
2238: (
2239: l_api_version,
2240: p_api_version,
2241: l_api_name,

Line 2245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2241: l_api_name,
2242: G_PKG_NAME
2243: )
2244: THEN
2245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2246: END IF;
2247:
2248: -- Initialize message list if p_init_msg_list is set to TRUE.
2249: IF FND_API.to_boolean( p_init_msg_list ) THEN

Line 2249: IF FND_API.to_boolean( p_init_msg_list ) THEN

2245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2246: END IF;
2247:
2248: -- Initialize message list if p_init_msg_list is set to TRUE.
2249: IF FND_API.to_boolean( p_init_msg_list ) THEN
2250: FND_MSG_PUB.initialize;
2251: END IF;
2252:
2253: -- Enable Debug (optional)

Line 2298: IF (p_x_route_rec.enigma_doc_id <> FND_API.G_MISS_CHAR) THEN

2294: END IF;
2295: END IF;
2296:
2297: IF (p_x_route_rec.enigma_source_code IS NULL OR UPPER(p_x_route_rec.enigma_source_code) = 'MANUAL') THEN
2298: IF (p_x_route_rec.enigma_doc_id <> FND_API.G_MISS_CHAR) THEN
2299: p_x_route_rec.enigma_source_code := 'MANUAL';
2300: ELSE
2301: p_x_route_rec.enigma_source_code := NULL;
2302: END IF;

Line 2315: IF FND_API.to_boolean( p_commit ) THEN

2311: UPDATE ahl_routes_b
2312: set file_id = p_x_route_rec.file_id
2313: where route_id = p_x_route_rec.route_id;
2314: END IF ;
2315: IF FND_API.to_boolean( p_commit ) THEN
2316: COMMIT WORK;
2317: END IF;
2318: RETURN ;
2319: END IF;

Line 2327: (p_x_route_rec.route_id IS NULL OR p_x_route_rec.route_id = FND_API.G_MISS_NUM)

2323: END IF;
2324: -- Enigma Phase II changes End
2325: -- Generate route_id from route_number and revision_number if it is not provided.
2326: IF (p_x_route_rec.dml_operation <> 'C' AND p_x_route_rec.dml_operation <> 'c') AND
2327: (p_x_route_rec.route_id IS NULL OR p_x_route_rec.route_id = FND_API.G_MISS_NUM)
2328: THEN
2329: -- Function to convert route_number, route_revision to id
2330: AHL_RM_ROUTE_UTIL.Route_Number_To_Id(
2331: p_route_number => p_x_route_rec.route_no,

Line 2337: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2333: x_route_id => p_x_route_rec.route_id,
2334: x_return_status => x_return_status
2335: );
2336:
2337: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2338: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2339: fnd_log.string
2340: (
2341: fnd_log.level_statement,

Line 2346: RAISE FND_API.G_EXC_ERROR;

2342: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2343: 'Error in converting Route Number, Route Revision to ID'
2344: );
2345: END IF;
2346: RAISE FND_API.G_EXC_ERROR;
2347: END IF;
2348: END IF;
2349:
2350: --This is to be added before calling validate_api_inputs

Line 2363: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2359: x_msg_data => x_msg_data
2360: );
2361:
2362: -- If any severe error occurs, then, abort API.
2363: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2364: RAISE FND_API.G_EXC_ERROR;
2365: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2367: END IF;

Line 2364: RAISE FND_API.G_EXC_ERROR;

2360: );
2361:
2362: -- If any severe error occurs, then, abort API.
2363: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2364: RAISE FND_API.G_EXC_ERROR;
2365: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2367: END IF;
2368:

Line 2365: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2361:
2362: -- If any severe error occurs, then, abort API.
2363: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2364: RAISE FND_API.G_EXC_ERROR;
2365: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2367: END IF;
2368:
2369: END IF ;

Line 2366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2362: -- If any severe error occurs, then, abort API.
2363: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2364: RAISE FND_API.G_EXC_ERROR;
2365: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2367: END IF;
2368:
2369: END IF ;
2370:

Line 2379: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2375: l_return_status -- OUT
2376: );
2377:
2378: -- If any severe error occurs, then, abort API.
2379: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2380: RAISE FND_API.G_EXC_ERROR;
2381: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2383: END IF;

Line 2380: RAISE FND_API.G_EXC_ERROR;

2376: );
2377:
2378: -- If any severe error occurs, then, abort API.
2379: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2380: RAISE FND_API.G_EXC_ERROR;
2381: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2383: END IF;
2384:

Line 2381: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2377:
2378: -- If any severe error occurs, then, abort API.
2379: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2380: RAISE FND_API.G_EXC_ERROR;
2381: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2383: END IF;
2384:
2385: -- If the module type is JSP, then default values for ID columns of LOV attributes

Line 2382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2378: -- If any severe error occurs, then, abort API.
2379: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2380: RAISE FND_API.G_EXC_ERROR;
2381: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2383: END IF;
2384:
2385: -- If the module type is JSP, then default values for ID columns of LOV attributes
2386: IF ( p_module_type = 'JSP' ) THEN

Line 2395: --IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN

2391: END IF;
2392:
2393: -- Convert Values into Ids.
2394: -- Balaji removed p_validation_level check in 11510+ as a part of public api cleanup.
2395: --IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN
2396: convert_values_to_ids
2397: (
2398: p_x_route_rec , -- IN OUT Record with Values and Ids
2399: l_return_status -- OUT

Line 2403: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2399: l_return_status -- OUT
2400: );
2401:
2402: -- If any severe error occurs, then, abort API.
2403: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2404: RAISE FND_API.G_EXC_ERROR;
2405: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2407: END IF;

Line 2404: RAISE FND_API.G_EXC_ERROR;

2400: );
2401:
2402: -- If any severe error occurs, then, abort API.
2403: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2404: RAISE FND_API.G_EXC_ERROR;
2405: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2407: END IF;
2408: --END IF;

Line 2405: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2401:
2402: -- If any severe error occurs, then, abort API.
2403: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2404: RAISE FND_API.G_EXC_ERROR;
2405: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2407: END IF;
2408: --END IF;
2409:

Line 2406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2402: -- If any severe error occurs, then, abort API.
2403: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2404: RAISE FND_API.G_EXC_ERROR;
2405: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2407: END IF;
2408: --END IF;
2409:
2410: IF G_DEBUG = 'Y' THEN

Line 2416: IF FND_API.to_boolean( p_default ) THEN

2412: END IF;
2413:
2414: /* Balaji removed it as a part of public API cleanup as this defaulting logic should not be bound by p_default value. Instead the logic is moved to DML.
2415: -- Default route attributes.
2416: IF FND_API.to_boolean( p_default ) THEN
2417: default_attributes
2418: (
2419: p_x_route_rec -- IN OUT
2420: );

Line 2448: --IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN

2444: END IF;
2445:
2446: -- Validate all attributes (Item level validation)
2447: -- Balaji removed p_validation_level check in 11510+ as a part of public api cleanup.
2448: --IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN
2449: validate_attributes
2450: (
2451: p_x_route_rec, -- IN
2452: l_return_status -- OUT

Line 2456: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2452: l_return_status -- OUT
2453: );
2454:
2455: -- If any severe error occurs, then, abort API.
2456: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2457: RAISE FND_API.G_EXC_ERROR;
2458: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2460: END IF;

Line 2457: RAISE FND_API.G_EXC_ERROR;

2453: );
2454:
2455: -- If any severe error occurs, then, abort API.
2456: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2457: RAISE FND_API.G_EXC_ERROR;
2458: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2460: END IF;
2461: --END IF;

Line 2458: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2454:
2455: -- If any severe error occurs, then, abort API.
2456: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2457: RAISE FND_API.G_EXC_ERROR;
2458: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2460: END IF;
2461: --END IF;
2462:

Line 2459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2455: -- If any severe error occurs, then, abort API.
2456: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2457: RAISE FND_API.G_EXC_ERROR;
2458: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2460: END IF;
2461: --END IF;
2462:
2463: IF G_DEBUG = 'Y' THEN

Line 2469: --IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN

2465: END IF;
2466:
2467: -- Perform cross attribute validation and missing attribute checks (Record level validation)
2468: -- Balaji removed p_validation_level check in 11510+ as a part of public api cleanup.
2469: --IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN
2470: validate_record
2471: (
2472: p_x_route_rec, -- IN
2473: l_return_status -- OUT

Line 2477: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2473: l_return_status -- OUT
2474: );
2475:
2476: -- If any severe error occurs, then, abort API.
2477: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2478: RAISE FND_API.G_EXC_ERROR;
2479: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2481: END IF;

Line 2478: RAISE FND_API.G_EXC_ERROR;

2474: );
2475:
2476: -- If any severe error occurs, then, abort API.
2477: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2478: RAISE FND_API.G_EXC_ERROR;
2479: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2481: END IF;
2482: --END IF;

Line 2479: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2475:
2476: -- If any severe error occurs, then, abort API.
2477: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2478: RAISE FND_API.G_EXC_ERROR;
2479: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2481: END IF;
2482: --END IF;
2483:

Line 2480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2476: -- If any severe error occurs, then, abort API.
2477: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2478: RAISE FND_API.G_EXC_ERROR;
2479: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2481: END IF;
2482: --END IF;
2483:
2484: IF G_DEBUG = 'Y' THEN

Line 2492: RAISE FND_API.G_EXC_ERROR;

2488: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
2489: l_msg_count := FND_MSG_PUB.count_msg;
2490: IF l_msg_count > 0 THEN
2491: x_msg_count := l_msg_count;
2492: RAISE FND_API.G_EXC_ERROR;
2493: END IF;
2494:
2495: -- Perform the DML by invoking the Table Handler.
2496: IF ( p_x_route_rec.dml_operation = 'C' ) THEN

Line 2507: IF ( (p_x_route_rec.model_code IS NOT NULL ) AND (p_x_route_rec.model_code <> FND_API.G_MISS_CHAR ) ) THEN

2503: FROM DUAL;
2504:
2505: --bachandr Enigma Phase I changes -- start
2506: -- Append the model code if any to the route No
2507: IF ( (p_x_route_rec.model_code IS NOT NULL ) AND (p_x_route_rec.model_code <> FND_API.G_MISS_CHAR ) ) THEN
2508: --AND (p_x_route_rec.model_meaning IS NOT NULL ) AND (p_x_route_rec.model_meaning <> FND_API.G_MISS_CHAR )) THEN
2509: p_x_route_rec.route_no := p_x_route_rec.model_code || concat || p_x_route_rec.route_no ;
2510:
2511: --dbms_output.put_line('Inside If');

Line 2508: --AND (p_x_route_rec.model_meaning IS NOT NULL ) AND (p_x_route_rec.model_meaning <> FND_API.G_MISS_CHAR )) THEN

2504:
2505: --bachandr Enigma Phase I changes -- start
2506: -- Append the model code if any to the route No
2507: IF ( (p_x_route_rec.model_code IS NOT NULL ) AND (p_x_route_rec.model_code <> FND_API.G_MISS_CHAR ) ) THEN
2508: --AND (p_x_route_rec.model_meaning IS NOT NULL ) AND (p_x_route_rec.model_meaning <> FND_API.G_MISS_CHAR )) THEN
2509: p_x_route_rec.route_no := p_x_route_rec.model_code || concat || p_x_route_rec.route_no ;
2510:
2511: --dbms_output.put_line('Inside If');
2512: END IF;

Line 2753: RAISE FND_API.G_EXC_ERROR;

2749: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
2750: l_msg_count := FND_MSG_PUB.count_msg;
2751: IF l_msg_count > 0 THEN
2752: x_msg_count := l_msg_count;
2753: RAISE FND_API.G_EXC_ERROR;
2754: END IF;
2755:
2756: -- Perform the Commit (if requested)
2757: IF FND_API.to_boolean( p_commit ) THEN

Line 2757: IF FND_API.to_boolean( p_commit ) THEN

2753: RAISE FND_API.G_EXC_ERROR;
2754: END IF;
2755:
2756: -- Perform the Commit (if requested)
2757: IF FND_API.to_boolean( p_commit ) THEN
2758: COMMIT WORK;
2759: END IF;
2760:
2761: -- Count and Get messages (optional)

Line 2764: p_encoded => FND_API.G_FALSE,

2760:
2761: -- Count and Get messages (optional)
2762: FND_MSG_PUB.count_and_get
2763: (
2764: p_encoded => FND_API.G_FALSE,
2765: p_count => x_msg_count,
2766: p_data => x_msg_data
2767: );
2768:

Line 2776: WHEN FND_API.G_EXC_ERROR THEN

2772: END IF;
2773:
2774: EXCEPTION
2775:
2776: WHEN FND_API.G_EXC_ERROR THEN
2777: ROLLBACK TO process_route_PVT;
2778: x_return_status := FND_API.G_RET_STS_ERROR ;
2779: FND_MSG_PUB.count_and_get
2780: (

Line 2778: x_return_status := FND_API.G_RET_STS_ERROR ;

2774: EXCEPTION
2775:
2776: WHEN FND_API.G_EXC_ERROR THEN
2777: ROLLBACK TO process_route_PVT;
2778: x_return_status := FND_API.G_RET_STS_ERROR ;
2779: FND_MSG_PUB.count_and_get
2780: (
2781: p_encoded => FND_API.G_FALSE,
2782: p_count => x_msg_count,

Line 2781: p_encoded => FND_API.G_FALSE,

2777: ROLLBACK TO process_route_PVT;
2778: x_return_status := FND_API.G_RET_STS_ERROR ;
2779: FND_MSG_PUB.count_and_get
2780: (
2781: p_encoded => FND_API.G_FALSE,
2782: p_count => x_msg_count,
2783: p_data => x_msg_data
2784: );
2785:

Line 2791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2787: IF ( G_DEBUG = 'Y' ) THEN
2788: AHL_DEBUG_PUB.disable_debug;
2789: END IF;
2790:
2791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2792: ROLLBACK TO process_route_PVT;
2793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2794: FND_MSG_PUB.count_and_get
2795: (

Line 2793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2789: END IF;
2790:
2791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2792: ROLLBACK TO process_route_PVT;
2793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2794: FND_MSG_PUB.count_and_get
2795: (
2796: p_encoded => FND_API.G_FALSE,
2797: p_count => x_msg_count,

Line 2796: p_encoded => FND_API.G_FALSE,

2792: ROLLBACK TO process_route_PVT;
2793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2794: FND_MSG_PUB.count_and_get
2795: (
2796: p_encoded => FND_API.G_FALSE,
2797: p_count => x_msg_count,
2798: p_data => x_msg_data
2799: );
2800:

Line 2808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2804: END IF;
2805:
2806: WHEN OTHERS THEN
2807: ROLLBACK TO process_route_PVT;
2808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2809: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2810: THEN
2811: FND_MSG_PUB.add_exc_msg
2812: (

Line 2820: p_encoded => FND_API.G_FALSE,

2816: );
2817: END IF;
2818: FND_MSG_PUB.count_and_get
2819: (
2820: p_encoded => FND_API.G_FALSE,
2821: p_count => x_msg_count,
2822: p_data => x_msg_data
2823: );
2824:

Line 2835: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

2831:
2832: PROCEDURE delete_route
2833: (
2834: p_api_version IN NUMBER := '1.0',
2835: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2836: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2837: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2838: p_default IN VARCHAR2 := FND_API.G_FALSE,
2839: p_module_type IN VARCHAR2 := NULL,

Line 2836: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2832: PROCEDURE delete_route
2833: (
2834: p_api_version IN NUMBER := '1.0',
2835: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2836: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2837: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2838: p_default IN VARCHAR2 := FND_API.G_FALSE,
2839: p_module_type IN VARCHAR2 := NULL,
2840: x_return_status OUT NOCOPY VARCHAR2,

Line 2837: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2833: (
2834: p_api_version IN NUMBER := '1.0',
2835: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2836: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2837: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2838: p_default IN VARCHAR2 := FND_API.G_FALSE,
2839: p_module_type IN VARCHAR2 := NULL,
2840: x_return_status OUT NOCOPY VARCHAR2,
2841: x_msg_count OUT NOCOPY NUMBER,

Line 2838: p_default IN VARCHAR2 := FND_API.G_FALSE,

2834: p_api_version IN NUMBER := '1.0',
2835: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2836: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2837: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2838: p_default IN VARCHAR2 := FND_API.G_FALSE,
2839: p_module_type IN VARCHAR2 := NULL,
2840: x_return_status OUT NOCOPY VARCHAR2,
2841: x_msg_count OUT NOCOPY NUMBER,
2842: x_msg_data OUT NOCOPY VARCHAR2,

Line 2886: x_return_status := FND_API.G_RET_STS_SUCCESS;

2882:
2883: BEGIN
2884:
2885: -- Initialize API return status to success
2886: x_return_status := FND_API.G_RET_STS_SUCCESS;
2887:
2888: -- Standard Start of API savepoint
2889: SAVEPOINT delete_route_PVT;
2890:

Line 2892: IF NOT FND_API.compatible_api_call

2888: -- Standard Start of API savepoint
2889: SAVEPOINT delete_route_PVT;
2890:
2891: -- Standard call to check for call compatibility.
2892: IF NOT FND_API.compatible_api_call
2893: (
2894: l_api_version,
2895: p_api_version,
2896: l_api_name,

Line 2900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2896: l_api_name,
2897: G_PKG_NAME
2898: )
2899: THEN
2900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2901: END IF;
2902:
2903: -- Initialize message list if p_init_msg_list is set to TRUE.
2904: IF FND_API.to_boolean( p_init_msg_list ) THEN

Line 2904: IF FND_API.to_boolean( p_init_msg_list ) THEN

2900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2901: END IF;
2902:
2903: -- Initialize message list if p_init_msg_list is set to TRUE.
2904: IF FND_API.to_boolean( p_init_msg_list ) THEN
2905: FND_MSG_PUB.initialize;
2906: END IF;
2907:
2908: -- Enable Debug (optional)

Line 2928: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2924: x_msg_data => x_msg_data
2925: );
2926:
2927: -- If any severe error occurs, then, abort API.
2928: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2929: RAISE FND_API.G_EXC_ERROR;
2930: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2932: END IF;

Line 2929: RAISE FND_API.G_EXC_ERROR;

2925: );
2926:
2927: -- If any severe error occurs, then, abort API.
2928: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2929: RAISE FND_API.G_EXC_ERROR;
2930: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2932: END IF;
2933:

Line 2930: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2926:
2927: -- If any severe error occurs, then, abort API.
2928: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2929: RAISE FND_API.G_EXC_ERROR;
2930: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2932: END IF;
2933:
2934: IF ( p_route_id IS NULL OR

Line 2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2927: -- If any severe error occurs, then, abort API.
2928: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2929: RAISE FND_API.G_EXC_ERROR;
2930: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2932: END IF;
2933:
2934: IF ( p_route_id IS NULL OR
2935: p_route_id = FND_API.G_MISS_NUM OR

Line 2935: p_route_id = FND_API.G_MISS_NUM OR

2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2932: END IF;
2933:
2934: IF ( p_route_id IS NULL OR
2935: p_route_id = FND_API.G_MISS_NUM OR
2936: p_object_version_number IS NULL OR
2937: p_object_version_number = FND_API.G_MISS_NUM ) THEN
2938: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
2939: FND_MESSAGE.set_token( 'PROCEDURE', l_api_name );

Line 2937: p_object_version_number = FND_API.G_MISS_NUM ) THEN

2933:
2934: IF ( p_route_id IS NULL OR
2935: p_route_id = FND_API.G_MISS_NUM OR
2936: p_object_version_number IS NULL OR
2937: p_object_version_number = FND_API.G_MISS_NUM ) THEN
2938: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
2939: FND_MESSAGE.set_token( 'PROCEDURE', l_api_name );
2940: FND_MSG_PUB.add;
2941: RAISE FND_API.G_EXC_ERROR;

Line 2941: RAISE FND_API.G_EXC_ERROR;

2937: p_object_version_number = FND_API.G_MISS_NUM ) THEN
2938: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
2939: FND_MESSAGE.set_token( 'PROCEDURE', l_api_name );
2940: FND_MSG_PUB.add;
2941: RAISE FND_API.G_EXC_ERROR;
2942: END IF;
2943:
2944: OPEN validate_route_ovn;
2945: FETCH validate_route_ovn INTO l_dummy;

Line 2950: x_return_status := FND_API.G_RET_STS_ERROR;

2946: IF (validate_route_ovn%NOTFOUND)
2947: THEN
2948: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
2949: FND_MSG_PUB.add;
2950: x_return_status := FND_API.G_RET_STS_ERROR;
2951: RAISE FND_API.G_EXC_ERROR;
2952: END IF;
2953:
2954: --bachandr Enigma Phase I changes -- start

Line 2951: RAISE FND_API.G_EXC_ERROR;

2947: THEN
2948: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
2949: FND_MSG_PUB.add;
2950: x_return_status := FND_API.G_RET_STS_ERROR;
2951: RAISE FND_API.G_EXC_ERROR;
2952: END IF;
2953:
2954: --bachandr Enigma Phase I changes -- start
2955: -- Fetch the doc_id and if the doc_id is not null( ie an Enigma Route) then

Line 2973: x_return_status := FND_API.G_RET_STS_ERROR;

2969: AHL_DEBUG_PUB.debug( 'Enigma Route Id IS NOT NULL');
2970: END IF;
2971: FND_MESSAGE.set_name('AHL', 'AHL_RM_ROUTE_ENIG_DEL');
2972: FND_MSG_PUB.add;
2973: x_return_status := FND_API.G_RET_STS_ERROR;
2974: RAISE FND_API.G_EXC_ERROR;
2975: END IF;
2976: CLOSE get_enigma_route_id;
2977: END IF;

Line 2974: RAISE FND_API.G_EXC_ERROR;

2970: END IF;
2971: FND_MESSAGE.set_name('AHL', 'AHL_RM_ROUTE_ENIG_DEL');
2972: FND_MSG_PUB.add;
2973: x_return_status := FND_API.G_RET_STS_ERROR;
2974: RAISE FND_API.G_EXC_ERROR;
2975: END IF;
2976: CLOSE get_enigma_route_id;
2977: END IF;
2978: --change by snarkhed end.

Line 2988: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

2984: x_msg_data => l_msg_data,
2985: x_return_status => l_return_status
2986: );
2987:
2988: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
2989: IF ( l_msg_data = 'AHL_RM_INVALID_ROUTE_STATUS' ) THEN
2990: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_STATUS_NOT_DRAFT' );
2991: ELSE
2992: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 2996: RAISE FND_API.G_EXC_ERROR;

2992: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2993: END IF;
2994:
2995: FND_MSG_PUB.add;
2996: RAISE FND_API.G_EXC_ERROR;
2997: END IF;
2998:
2999:
3000: IF G_DEBUG = 'Y' THEN

Line 3098: RAISE FND_API.G_EXC_ERROR;

3094: EXCEPTION
3095: WHEN NO_DATA_FOUND THEN
3096: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
3097: FND_MSG_PUB.add;
3098: RAISE FND_API.G_EXC_ERROR;
3099: WHEN OTHERS THEN
3100: RAISE;
3101: END;
3102:

Line 3108: IF FND_API.to_boolean( p_commit ) THEN

3104: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Associated Operations' );
3105: END IF;
3106:
3107: -- Perform the Commit (if requested)
3108: IF FND_API.to_boolean( p_commit ) THEN
3109: COMMIT WORK;
3110: END IF;
3111:
3112: -- Count and Get messages (optional)

Line 3115: p_encoded => FND_API.G_FALSE,

3111:
3112: -- Count and Get messages (optional)
3113: FND_MSG_PUB.count_and_get
3114: (
3115: p_encoded => FND_API.G_FALSE,
3116: p_count => x_msg_count,
3117: p_data => x_msg_data
3118: );
3119:

Line 3127: WHEN FND_API.G_EXC_ERROR THEN

3123: END IF;
3124:
3125: EXCEPTION
3126:
3127: WHEN FND_API.G_EXC_ERROR THEN
3128: ROLLBACK TO delete_route_PVT;
3129: x_return_status := FND_API.G_RET_STS_ERROR ;
3130: FND_MSG_PUB.count_and_get
3131: (

Line 3129: x_return_status := FND_API.G_RET_STS_ERROR ;

3125: EXCEPTION
3126:
3127: WHEN FND_API.G_EXC_ERROR THEN
3128: ROLLBACK TO delete_route_PVT;
3129: x_return_status := FND_API.G_RET_STS_ERROR ;
3130: FND_MSG_PUB.count_and_get
3131: (
3132: p_encoded => FND_API.G_FALSE,
3133: p_count => x_msg_count,

Line 3132: p_encoded => FND_API.G_FALSE,

3128: ROLLBACK TO delete_route_PVT;
3129: x_return_status := FND_API.G_RET_STS_ERROR ;
3130: FND_MSG_PUB.count_and_get
3131: (
3132: p_encoded => FND_API.G_FALSE,
3133: p_count => x_msg_count,
3134: p_data => x_msg_data
3135: );
3136:

Line 3142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3138: IF ( G_DEBUG = 'Y' ) THEN
3139: AHL_DEBUG_PUB.disable_debug;
3140: END IF;
3141:
3142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3143: ROLLBACK TO delete_route_PVT;
3144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3145: FND_MSG_PUB.count_and_get
3146: (

Line 3144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3140: END IF;
3141:
3142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3143: ROLLBACK TO delete_route_PVT;
3144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3145: FND_MSG_PUB.count_and_get
3146: (
3147: p_encoded => FND_API.G_FALSE,
3148: p_count => x_msg_count,

Line 3147: p_encoded => FND_API.G_FALSE,

3143: ROLLBACK TO delete_route_PVT;
3144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3145: FND_MSG_PUB.count_and_get
3146: (
3147: p_encoded => FND_API.G_FALSE,
3148: p_count => x_msg_count,
3149: p_data => x_msg_data
3150: );
3151:

Line 3159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3155: END IF;
3156:
3157: WHEN OTHERS THEN
3158: ROLLBACK TO delete_route_PVT;
3159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3160: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
3161: THEN
3162: FND_MSG_PUB.add_exc_msg
3163: (

Line 3171: p_encoded => FND_API.G_FALSE,

3167: );
3168: END IF;
3169: FND_MSG_PUB.count_and_get
3170: (
3171: p_encoded => FND_API.G_FALSE,
3172: p_count => x_msg_count,
3173: p_data => x_msg_data
3174: );
3175:

Line 3186: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

3182:
3183: PROCEDURE create_route_revision
3184: (
3185: p_api_version IN NUMBER := '1.0',
3186: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
3187: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3188: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3189: p_default IN VARCHAR2 := FND_API.G_FALSE,
3190: p_module_type IN VARCHAR2 := NULL,

Line 3187: p_commit IN VARCHAR2 := FND_API.G_FALSE,

3183: PROCEDURE create_route_revision
3184: (
3185: p_api_version IN NUMBER := '1.0',
3186: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
3187: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3188: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3189: p_default IN VARCHAR2 := FND_API.G_FALSE,
3190: p_module_type IN VARCHAR2 := NULL,
3191: x_return_status OUT NOCOPY VARCHAR2,

Line 3188: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

3184: (
3185: p_api_version IN NUMBER := '1.0',
3186: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
3187: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3188: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3189: p_default IN VARCHAR2 := FND_API.G_FALSE,
3190: p_module_type IN VARCHAR2 := NULL,
3191: x_return_status OUT NOCOPY VARCHAR2,
3192: x_msg_count OUT NOCOPY NUMBER,

Line 3189: p_default IN VARCHAR2 := FND_API.G_FALSE,

3185: p_api_version IN NUMBER := '1.0',
3186: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
3187: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3188: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3189: p_default IN VARCHAR2 := FND_API.G_FALSE,
3190: p_module_type IN VARCHAR2 := NULL,
3191: x_return_status OUT NOCOPY VARCHAR2,
3192: x_msg_count OUT NOCOPY NUMBER,
3193: x_msg_data OUT NOCOPY VARCHAR2,

Line 3403: x_return_status := FND_API.G_RET_STS_SUCCESS;

3399: l_rt_op_id_tbl rt_op_id_tbl_type;
3400:
3401: BEGIN
3402: -- Initialize API return status to success
3403: x_return_status := FND_API.G_RET_STS_SUCCESS;
3404:
3405: -- Standard Start of API savepoint
3406: SAVEPOINT create_route_revision_PVT;
3407:

Line 3409: IF NOT FND_API.compatible_api_call

3405: -- Standard Start of API savepoint
3406: SAVEPOINT create_route_revision_PVT;
3407:
3408: -- Standard call to check for call compatibility.
3409: IF NOT FND_API.compatible_api_call
3410: (
3411: l_api_version,
3412: p_api_version,
3413: l_api_name,

Line 3417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3413: l_api_name,
3414: G_PKG_NAME
3415: )
3416: THEN
3417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3418: END IF;
3419:
3420: -- Initialize message list if p_init_msg_list is set to TRUE.
3421: IF FND_API.to_boolean( p_init_msg_list ) THEN

Line 3421: IF FND_API.to_boolean( p_init_msg_list ) THEN

3417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3418: END IF;
3419:
3420: -- Initialize message list if p_init_msg_list is set to TRUE.
3421: IF FND_API.to_boolean( p_init_msg_list ) THEN
3422: FND_MSG_PUB.initialize;
3423: END IF;
3424:
3425: -- Enable Debug (optional)

Line 3445: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3441: x_msg_data => x_msg_data
3442: );
3443:
3444: -- If any severe error occurs, then, abort API.
3445: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3446: RAISE FND_API.G_EXC_ERROR;
3447: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3449: END IF;

Line 3446: RAISE FND_API.G_EXC_ERROR;

3442: );
3443:
3444: -- If any severe error occurs, then, abort API.
3445: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3446: RAISE FND_API.G_EXC_ERROR;
3447: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3449: END IF;
3450:

Line 3447: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3443:
3444: -- If any severe error occurs, then, abort API.
3445: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3446: RAISE FND_API.G_EXC_ERROR;
3447: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3449: END IF;
3450:
3451:

Line 3448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3444: -- If any severe error occurs, then, abort API.
3445: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3446: RAISE FND_API.G_EXC_ERROR;
3447: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3449: END IF;
3450:
3451:
3452: IF ( p_route_id IS NULL OR

Line 3453: p_route_id = FND_API.G_MISS_NUM OR

3449: END IF;
3450:
3451:
3452: IF ( p_route_id IS NULL OR
3453: p_route_id = FND_API.G_MISS_NUM OR
3454: p_object_version_number IS NULL OR
3455: p_object_version_number = FND_API.G_MISS_NUM ) THEN
3456: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
3457: FND_MSG_PUB.add;

Line 3455: p_object_version_number = FND_API.G_MISS_NUM ) THEN

3451:
3452: IF ( p_route_id IS NULL OR
3453: p_route_id = FND_API.G_MISS_NUM OR
3454: p_object_version_number IS NULL OR
3455: p_object_version_number = FND_API.G_MISS_NUM ) THEN
3456: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
3457: FND_MSG_PUB.add;
3458: RAISE FND_API.G_EXC_ERROR;
3459: END IF;

Line 3458: RAISE FND_API.G_EXC_ERROR;

3454: p_object_version_number IS NULL OR
3455: p_object_version_number = FND_API.G_MISS_NUM ) THEN
3456: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
3457: FND_MSG_PUB.add;
3458: RAISE FND_API.G_EXC_ERROR;
3459: END IF;
3460:
3461: get_route_record
3462: (

Line 3470: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

3466: p_object_version_number => p_object_version_number,
3467: p_x_route_rec => l_old_route_rec
3468: );
3469:
3470: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
3471: FND_MESSAGE.set_name( 'AHL', l_msg_data );
3472: FND_MSG_PUB.add;
3473: RAISE FND_API.G_EXC_ERROR;
3474: END IF;

Line 3473: RAISE FND_API.G_EXC_ERROR;

3469:
3470: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
3471: FND_MESSAGE.set_name( 'AHL', l_msg_data );
3472: FND_MSG_PUB.add;
3473: RAISE FND_API.G_EXC_ERROR;
3474: END IF;
3475:
3476: -- Check if the Status is COMPLETE
3477: IF ( l_old_route_rec.revision_status_code <> 'COMPLETE' ) THEN

Line 3481: RAISE FND_API.G_EXC_ERROR;

3477: IF ( l_old_route_rec.revision_status_code <> 'COMPLETE' ) THEN
3478: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_STATUS_NOT_COMPLETE' );
3479: FND_MESSAGE.set_token( 'RECORD', l_old_route_rec.route_no );
3480: FND_MSG_PUB.add;
3481: RAISE FND_API.G_EXC_ERROR;
3482: END IF;
3483:
3484: -- Check if this revision is not Terminated
3485: IF ( l_old_route_rec.active_end_date IS NOT NULL ) THEN

Line 3489: RAISE FND_API.G_EXC_ERROR;

3485: IF ( l_old_route_rec.active_end_date IS NOT NULL ) THEN
3486: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_END_DATE_NOT_NULL' );
3487: FND_MESSAGE.set_token( 'RECORD', l_old_route_rec.route_no );
3488: FND_MSG_PUB.add;
3489: RAISE FND_API.G_EXC_ERROR;
3490: END IF;
3491:
3492: -- Check if this revision is the latest complete revision of this Route
3493: OPEN get_latest_revision( l_old_route_rec.route_no );

Line 3503: RAISE FND_API.G_EXC_ERROR;

3499: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_REVISION_NOT_LATEST' );
3500: FND_MESSAGE.set_token( 'RECORD', l_old_route_rec.route_no );
3501: FND_MSG_PUB.add;
3502: CLOSE get_latest_revision;
3503: RAISE FND_API.G_EXC_ERROR;
3504: END IF;
3505:
3506: CLOSE get_latest_revision;
3507:

Line 4318: IF FND_API.to_boolean( p_commit ) THEN

4314: -- Set the OUT values.
4315: x_route_id := l_route_id;
4316:
4317: -- Perform the Commit (if requested)
4318: IF FND_API.to_boolean( p_commit ) THEN
4319: COMMIT WORK;
4320: END IF;
4321:
4322: -- Count and Get messages (optional)

Line 4325: p_encoded => FND_API.G_FALSE,

4321:
4322: -- Count and Get messages (optional)
4323: FND_MSG_PUB.count_and_get
4324: (
4325: p_encoded => FND_API.G_FALSE,
4326: p_count => x_msg_count,
4327: p_data => x_msg_data
4328: );
4329:

Line 4337: WHEN FND_API.G_EXC_ERROR THEN

4333: END IF;
4334:
4335: EXCEPTION
4336:
4337: WHEN FND_API.G_EXC_ERROR THEN
4338: ROLLBACK TO create_route_revision_PVT;
4339: x_return_status := FND_API.G_RET_STS_ERROR ;
4340: FND_MSG_PUB.count_and_get
4341: (

Line 4339: x_return_status := FND_API.G_RET_STS_ERROR ;

4335: EXCEPTION
4336:
4337: WHEN FND_API.G_EXC_ERROR THEN
4338: ROLLBACK TO create_route_revision_PVT;
4339: x_return_status := FND_API.G_RET_STS_ERROR ;
4340: FND_MSG_PUB.count_and_get
4341: (
4342: p_encoded => FND_API.G_FALSE,
4343: p_count => x_msg_count,

Line 4342: p_encoded => FND_API.G_FALSE,

4338: ROLLBACK TO create_route_revision_PVT;
4339: x_return_status := FND_API.G_RET_STS_ERROR ;
4340: FND_MSG_PUB.count_and_get
4341: (
4342: p_encoded => FND_API.G_FALSE,
4343: p_count => x_msg_count,
4344: p_data => x_msg_data
4345: );
4346:

Line 4352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4348: IF ( G_DEBUG = 'Y' ) THEN
4349: AHL_DEBUG_PUB.disable_debug;
4350: END IF;
4351:
4352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4353: ROLLBACK TO create_route_revision_PVT;
4354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4355: FND_MSG_PUB.count_and_get
4356: (

Line 4354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4350: END IF;
4351:
4352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4353: ROLLBACK TO create_route_revision_PVT;
4354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4355: FND_MSG_PUB.count_and_get
4356: (
4357: p_encoded => FND_API.G_FALSE,
4358: p_count => x_msg_count,

Line 4357: p_encoded => FND_API.G_FALSE,

4353: ROLLBACK TO create_route_revision_PVT;
4354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4355: FND_MSG_PUB.count_and_get
4356: (
4357: p_encoded => FND_API.G_FALSE,
4358: p_count => x_msg_count,
4359: p_data => x_msg_data
4360: );
4361:

Line 4369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4365: END IF;
4366:
4367: WHEN OTHERS THEN
4368: ROLLBACK TO create_route_revision_PVT;
4369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4370: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
4371: THEN
4372: FND_MSG_PUB.add_exc_msg
4373: (

Line 4381: p_encoded => FND_API.G_FALSE,

4377: );
4378: END IF;
4379: FND_MSG_PUB.count_and_get
4380: (
4381: p_encoded => FND_API.G_FALSE,
4382: p_count => x_msg_count,
4383: p_data => x_msg_data
4384: );
4385: