72: BEGIN
73: XNP$SUBSCRIPTION_TN := XDP_ENGINE.get_workitem_param_value ( p_wi_instance_id,
74: 'SUBSCRIPTION_TN' );
75: EXCEPTION WHEN NO_DATA_FOUND THEN
76: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
77: fnd_message.set_token( 'PARAMETER','SUBSCRIPTION_TN' ) ;
78: x_error_message := fnd_message.get ;
79: END;
80: IF ( XNP$SUBSCRIPTION_TN IS NULL) THEN
73: XNP$SUBSCRIPTION_TN := XDP_ENGINE.get_workitem_param_value ( p_wi_instance_id,
74: 'SUBSCRIPTION_TN' );
75: EXCEPTION WHEN NO_DATA_FOUND THEN
76: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
77: fnd_message.set_token( 'PARAMETER','SUBSCRIPTION_TN' ) ;
78: x_error_message := fnd_message.get ;
79: END;
80: IF ( XNP$SUBSCRIPTION_TN IS NULL) THEN
81: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
74: 'SUBSCRIPTION_TN' );
75: EXCEPTION WHEN NO_DATA_FOUND THEN
76: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
77: fnd_message.set_token( 'PARAMETER','SUBSCRIPTION_TN' ) ;
78: x_error_message := fnd_message.get ;
79: END;
80: IF ( XNP$SUBSCRIPTION_TN IS NULL) THEN
81: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
82: fnd_message.set_token( 'ATTRIBUTE','SUBSCRIPTION_TN' ) ;
77: fnd_message.set_token( 'PARAMETER','SUBSCRIPTION_TN' ) ;
78: x_error_message := fnd_message.get ;
79: END;
80: IF ( XNP$SUBSCRIPTION_TN IS NULL) THEN
81: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
82: fnd_message.set_token( 'ATTRIBUTE','SUBSCRIPTION_TN' ) ;
83: x_error_message := fnd_message.get ;
84: RAISE e_MISSING_MANDATORY_DATA ;
85: END IF ;
78: x_error_message := fnd_message.get ;
79: END;
80: IF ( XNP$SUBSCRIPTION_TN IS NULL) THEN
81: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
82: fnd_message.set_token( 'ATTRIBUTE','SUBSCRIPTION_TN' ) ;
83: x_error_message := fnd_message.get ;
84: RAISE e_MISSING_MANDATORY_DATA ;
85: END IF ;
86: XNP_XML_UTILS.write_leaf_element ( 'SUBSCRIPTION_TN', XNP$SUBSCRIPTION_TN ) ;
79: END;
80: IF ( XNP$SUBSCRIPTION_TN IS NULL) THEN
81: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
82: fnd_message.set_token( 'ATTRIBUTE','SUBSCRIPTION_TN' ) ;
83: x_error_message := fnd_message.get ;
84: RAISE e_MISSING_MANDATORY_DATA ;
85: END IF ;
86: XNP_XML_UTILS.write_leaf_element ( 'SUBSCRIPTION_TN', XNP$SUBSCRIPTION_TN ) ;
87: BEGIN
87: BEGIN
88: XNP$CUSTOMER_NAME := XDP_ENGINE.get_workitem_param_value ( p_wi_instance_id,
89: 'CUSTOMER_NAME' );
90: EXCEPTION WHEN NO_DATA_FOUND THEN
91: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
92: fnd_message.set_token( 'PARAMETER','CUSTOMER_NAME' ) ;
93: x_error_message := fnd_message.get ;
94: END;
95: IF ( XNP$CUSTOMER_NAME IS NULL) THEN
88: XNP$CUSTOMER_NAME := XDP_ENGINE.get_workitem_param_value ( p_wi_instance_id,
89: 'CUSTOMER_NAME' );
90: EXCEPTION WHEN NO_DATA_FOUND THEN
91: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
92: fnd_message.set_token( 'PARAMETER','CUSTOMER_NAME' ) ;
93: x_error_message := fnd_message.get ;
94: END;
95: IF ( XNP$CUSTOMER_NAME IS NULL) THEN
96: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
89: 'CUSTOMER_NAME' );
90: EXCEPTION WHEN NO_DATA_FOUND THEN
91: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
92: fnd_message.set_token( 'PARAMETER','CUSTOMER_NAME' ) ;
93: x_error_message := fnd_message.get ;
94: END;
95: IF ( XNP$CUSTOMER_NAME IS NULL) THEN
96: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
97: fnd_message.set_token( 'ATTRIBUTE','CUSTOMER_NAME' ) ;
92: fnd_message.set_token( 'PARAMETER','CUSTOMER_NAME' ) ;
93: x_error_message := fnd_message.get ;
94: END;
95: IF ( XNP$CUSTOMER_NAME IS NULL) THEN
96: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
97: fnd_message.set_token( 'ATTRIBUTE','CUSTOMER_NAME' ) ;
98: x_error_message := fnd_message.get ;
99: RAISE e_MISSING_MANDATORY_DATA ;
100: END IF ;
93: x_error_message := fnd_message.get ;
94: END;
95: IF ( XNP$CUSTOMER_NAME IS NULL) THEN
96: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
97: fnd_message.set_token( 'ATTRIBUTE','CUSTOMER_NAME' ) ;
98: x_error_message := fnd_message.get ;
99: RAISE e_MISSING_MANDATORY_DATA ;
100: END IF ;
101: XNP_XML_UTILS.write_leaf_element ( 'CUSTOMER_NAME', XNP$CUSTOMER_NAME ) ;
94: END;
95: IF ( XNP$CUSTOMER_NAME IS NULL) THEN
96: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
97: fnd_message.set_token( 'ATTRIBUTE','CUSTOMER_NAME' ) ;
98: x_error_message := fnd_message.get ;
99: RAISE e_MISSING_MANDATORY_DATA ;
100: END IF ;
101: XNP_XML_UTILS.write_leaf_element ( 'CUSTOMER_NAME', XNP$CUSTOMER_NAME ) ;
102: BEGIN
102: BEGIN
103: XNP$ADDRESS_LINE1 := XDP_ENGINE.get_workitem_param_value ( p_wi_instance_id,
104: 'ADDRESS_LINE1' );
105: EXCEPTION WHEN NO_DATA_FOUND THEN
106: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
107: fnd_message.set_token( 'PARAMETER','ADDRESS_LINE1' ) ;
108: x_error_message := fnd_message.get ;
109: END;
110: IF ( XNP$ADDRESS_LINE1 IS NULL) THEN
103: XNP$ADDRESS_LINE1 := XDP_ENGINE.get_workitem_param_value ( p_wi_instance_id,
104: 'ADDRESS_LINE1' );
105: EXCEPTION WHEN NO_DATA_FOUND THEN
106: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
107: fnd_message.set_token( 'PARAMETER','ADDRESS_LINE1' ) ;
108: x_error_message := fnd_message.get ;
109: END;
110: IF ( XNP$ADDRESS_LINE1 IS NULL) THEN
111: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
104: 'ADDRESS_LINE1' );
105: EXCEPTION WHEN NO_DATA_FOUND THEN
106: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
107: fnd_message.set_token( 'PARAMETER','ADDRESS_LINE1' ) ;
108: x_error_message := fnd_message.get ;
109: END;
110: IF ( XNP$ADDRESS_LINE1 IS NULL) THEN
111: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
112: fnd_message.set_token( 'ATTRIBUTE','ADDRESS_LINE1' ) ;
107: fnd_message.set_token( 'PARAMETER','ADDRESS_LINE1' ) ;
108: x_error_message := fnd_message.get ;
109: END;
110: IF ( XNP$ADDRESS_LINE1 IS NULL) THEN
111: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
112: fnd_message.set_token( 'ATTRIBUTE','ADDRESS_LINE1' ) ;
113: x_error_message := fnd_message.get ;
114: RAISE e_MISSING_MANDATORY_DATA ;
115: END IF ;
108: x_error_message := fnd_message.get ;
109: END;
110: IF ( XNP$ADDRESS_LINE1 IS NULL) THEN
111: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
112: fnd_message.set_token( 'ATTRIBUTE','ADDRESS_LINE1' ) ;
113: x_error_message := fnd_message.get ;
114: RAISE e_MISSING_MANDATORY_DATA ;
115: END IF ;
116: XNP_XML_UTILS.write_leaf_element ( 'ADDRESS_LINE1', XNP$ADDRESS_LINE1 ) ;
109: END;
110: IF ( XNP$ADDRESS_LINE1 IS NULL) THEN
111: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
112: fnd_message.set_token( 'ATTRIBUTE','ADDRESS_LINE1' ) ;
113: x_error_message := fnd_message.get ;
114: RAISE e_MISSING_MANDATORY_DATA ;
115: END IF ;
116: XNP_XML_UTILS.write_leaf_element ( 'ADDRESS_LINE1', XNP$ADDRESS_LINE1 ) ;
117: BEGIN
117: BEGIN
118: XNP$ADDRESS_LINE2 := XDP_ENGINE.get_workitem_param_value ( p_wi_instance_id,
119: 'ADDRESS_LINE2' );
120: EXCEPTION WHEN NO_DATA_FOUND THEN
121: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
122: fnd_message.set_token( 'PARAMETER','ADDRESS_LINE2' ) ;
123: x_error_message := fnd_message.get ;
124: END;
125: IF ( XNP$ADDRESS_LINE2 IS NULL) THEN
118: XNP$ADDRESS_LINE2 := XDP_ENGINE.get_workitem_param_value ( p_wi_instance_id,
119: 'ADDRESS_LINE2' );
120: EXCEPTION WHEN NO_DATA_FOUND THEN
121: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
122: fnd_message.set_token( 'PARAMETER','ADDRESS_LINE2' ) ;
123: x_error_message := fnd_message.get ;
124: END;
125: IF ( XNP$ADDRESS_LINE2 IS NULL) THEN
126: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
119: 'ADDRESS_LINE2' );
120: EXCEPTION WHEN NO_DATA_FOUND THEN
121: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
122: fnd_message.set_token( 'PARAMETER','ADDRESS_LINE2' ) ;
123: x_error_message := fnd_message.get ;
124: END;
125: IF ( XNP$ADDRESS_LINE2 IS NULL) THEN
126: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
127: fnd_message.set_token( 'ATTRIBUTE','ADDRESS_LINE2' ) ;
122: fnd_message.set_token( 'PARAMETER','ADDRESS_LINE2' ) ;
123: x_error_message := fnd_message.get ;
124: END;
125: IF ( XNP$ADDRESS_LINE2 IS NULL) THEN
126: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
127: fnd_message.set_token( 'ATTRIBUTE','ADDRESS_LINE2' ) ;
128: x_error_message := fnd_message.get ;
129: RAISE e_MISSING_MANDATORY_DATA ;
130: END IF ;
123: x_error_message := fnd_message.get ;
124: END;
125: IF ( XNP$ADDRESS_LINE2 IS NULL) THEN
126: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
127: fnd_message.set_token( 'ATTRIBUTE','ADDRESS_LINE2' ) ;
128: x_error_message := fnd_message.get ;
129: RAISE e_MISSING_MANDATORY_DATA ;
130: END IF ;
131: XNP_XML_UTILS.write_leaf_element ( 'ADDRESS_LINE2', XNP$ADDRESS_LINE2 ) ;
124: END;
125: IF ( XNP$ADDRESS_LINE2 IS NULL) THEN
126: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
127: fnd_message.set_token( 'ATTRIBUTE','ADDRESS_LINE2' ) ;
128: x_error_message := fnd_message.get ;
129: RAISE e_MISSING_MANDATORY_DATA ;
130: END IF ;
131: XNP_XML_UTILS.write_leaf_element ( 'ADDRESS_LINE2', XNP$ADDRESS_LINE2 ) ;
132: BEGIN
132: BEGIN
133: XNP$CITY := XDP_ENGINE.get_workitem_param_value ( p_wi_instance_id,
134: 'CITY' );
135: EXCEPTION WHEN NO_DATA_FOUND THEN
136: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
137: fnd_message.set_token( 'PARAMETER','CITY' ) ;
138: x_error_message := fnd_message.get ;
139: END;
140: IF ( XNP$CITY IS NULL) THEN
133: XNP$CITY := XDP_ENGINE.get_workitem_param_value ( p_wi_instance_id,
134: 'CITY' );
135: EXCEPTION WHEN NO_DATA_FOUND THEN
136: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
137: fnd_message.set_token( 'PARAMETER','CITY' ) ;
138: x_error_message := fnd_message.get ;
139: END;
140: IF ( XNP$CITY IS NULL) THEN
141: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
134: 'CITY' );
135: EXCEPTION WHEN NO_DATA_FOUND THEN
136: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
137: fnd_message.set_token( 'PARAMETER','CITY' ) ;
138: x_error_message := fnd_message.get ;
139: END;
140: IF ( XNP$CITY IS NULL) THEN
141: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
142: fnd_message.set_token( 'ATTRIBUTE','CITY' ) ;
137: fnd_message.set_token( 'PARAMETER','CITY' ) ;
138: x_error_message := fnd_message.get ;
139: END;
140: IF ( XNP$CITY IS NULL) THEN
141: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
142: fnd_message.set_token( 'ATTRIBUTE','CITY' ) ;
143: x_error_message := fnd_message.get ;
144: RAISE e_MISSING_MANDATORY_DATA ;
145: END IF ;
138: x_error_message := fnd_message.get ;
139: END;
140: IF ( XNP$CITY IS NULL) THEN
141: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
142: fnd_message.set_token( 'ATTRIBUTE','CITY' ) ;
143: x_error_message := fnd_message.get ;
144: RAISE e_MISSING_MANDATORY_DATA ;
145: END IF ;
146: XNP_XML_UTILS.write_leaf_element ( 'CITY', XNP$CITY ) ;
139: END;
140: IF ( XNP$CITY IS NULL) THEN
141: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
142: fnd_message.set_token( 'ATTRIBUTE','CITY' ) ;
143: x_error_message := fnd_message.get ;
144: RAISE e_MISSING_MANDATORY_DATA ;
145: END IF ;
146: XNP_XML_UTILS.write_leaf_element ( 'CITY', XNP$CITY ) ;
147: BEGIN
147: BEGIN
148: XNP$ZIP_CODE := XDP_ENGINE.get_workitem_param_value ( p_wi_instance_id,
149: 'ZIP_CODE' );
150: EXCEPTION WHEN NO_DATA_FOUND THEN
151: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
152: fnd_message.set_token( 'PARAMETER','ZIP_CODE' ) ;
153: x_error_message := fnd_message.get ;
154: END;
155: IF ( XNP$ZIP_CODE IS NULL) THEN
148: XNP$ZIP_CODE := XDP_ENGINE.get_workitem_param_value ( p_wi_instance_id,
149: 'ZIP_CODE' );
150: EXCEPTION WHEN NO_DATA_FOUND THEN
151: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
152: fnd_message.set_token( 'PARAMETER','ZIP_CODE' ) ;
153: x_error_message := fnd_message.get ;
154: END;
155: IF ( XNP$ZIP_CODE IS NULL) THEN
156: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
149: 'ZIP_CODE' );
150: EXCEPTION WHEN NO_DATA_FOUND THEN
151: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
152: fnd_message.set_token( 'PARAMETER','ZIP_CODE' ) ;
153: x_error_message := fnd_message.get ;
154: END;
155: IF ( XNP$ZIP_CODE IS NULL) THEN
156: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
157: fnd_message.set_token( 'ATTRIBUTE','ZIP_CODE' ) ;
152: fnd_message.set_token( 'PARAMETER','ZIP_CODE' ) ;
153: x_error_message := fnd_message.get ;
154: END;
155: IF ( XNP$ZIP_CODE IS NULL) THEN
156: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
157: fnd_message.set_token( 'ATTRIBUTE','ZIP_CODE' ) ;
158: x_error_message := fnd_message.get ;
159: RAISE e_MISSING_MANDATORY_DATA ;
160: END IF ;
153: x_error_message := fnd_message.get ;
154: END;
155: IF ( XNP$ZIP_CODE IS NULL) THEN
156: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
157: fnd_message.set_token( 'ATTRIBUTE','ZIP_CODE' ) ;
158: x_error_message := fnd_message.get ;
159: RAISE e_MISSING_MANDATORY_DATA ;
160: END IF ;
161: XNP_XML_UTILS.write_leaf_element ( 'ZIP_CODE', XNP$ZIP_CODE ) ;
154: END;
155: IF ( XNP$ZIP_CODE IS NULL) THEN
156: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
157: fnd_message.set_token( 'ATTRIBUTE','ZIP_CODE' ) ;
158: x_error_message := fnd_message.get ;
159: RAISE e_MISSING_MANDATORY_DATA ;
160: END IF ;
161: XNP_XML_UTILS.write_leaf_element ( 'ZIP_CODE', XNP$ZIP_CODE ) ;
162: BEGIN
162: BEGIN
163: XNP$SERVICE_TYPE := XDP_ENGINE.get_workitem_param_value ( p_wi_instance_id,
164: 'SERVICE_TYPE' );
165: EXCEPTION WHEN NO_DATA_FOUND THEN
166: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
167: fnd_message.set_token( 'PARAMETER','SERVICE_TYPE' ) ;
168: x_error_message := fnd_message.get ;
169: END;
170: IF ( XNP$SERVICE_TYPE IS NULL) THEN
163: XNP$SERVICE_TYPE := XDP_ENGINE.get_workitem_param_value ( p_wi_instance_id,
164: 'SERVICE_TYPE' );
165: EXCEPTION WHEN NO_DATA_FOUND THEN
166: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
167: fnd_message.set_token( 'PARAMETER','SERVICE_TYPE' ) ;
168: x_error_message := fnd_message.get ;
169: END;
170: IF ( XNP$SERVICE_TYPE IS NULL) THEN
171: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
164: 'SERVICE_TYPE' );
165: EXCEPTION WHEN NO_DATA_FOUND THEN
166: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
167: fnd_message.set_token( 'PARAMETER','SERVICE_TYPE' ) ;
168: x_error_message := fnd_message.get ;
169: END;
170: IF ( XNP$SERVICE_TYPE IS NULL) THEN
171: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
172: fnd_message.set_token( 'ATTRIBUTE','SERVICE_TYPE' ) ;
167: fnd_message.set_token( 'PARAMETER','SERVICE_TYPE' ) ;
168: x_error_message := fnd_message.get ;
169: END;
170: IF ( XNP$SERVICE_TYPE IS NULL) THEN
171: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
172: fnd_message.set_token( 'ATTRIBUTE','SERVICE_TYPE' ) ;
173: x_error_message := fnd_message.get ;
174: RAISE e_MISSING_MANDATORY_DATA ;
175: END IF ;
168: x_error_message := fnd_message.get ;
169: END;
170: IF ( XNP$SERVICE_TYPE IS NULL) THEN
171: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
172: fnd_message.set_token( 'ATTRIBUTE','SERVICE_TYPE' ) ;
173: x_error_message := fnd_message.get ;
174: RAISE e_MISSING_MANDATORY_DATA ;
175: END IF ;
176: XNP_XML_UTILS.write_leaf_element ( 'SERVICE_TYPE', XNP$SERVICE_TYPE ) ;
169: END;
170: IF ( XNP$SERVICE_TYPE IS NULL) THEN
171: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
172: fnd_message.set_token( 'ATTRIBUTE','SERVICE_TYPE' ) ;
173: x_error_message := fnd_message.get ;
174: RAISE e_MISSING_MANDATORY_DATA ;
175: END IF ;
176: XNP_XML_UTILS.write_leaf_element ( 'SERVICE_TYPE', XNP$SERVICE_TYPE ) ;
177: BEGIN
177: BEGIN
178: XNP$STATUS := XDP_ENGINE.get_workitem_param_value ( p_wi_instance_id,
179: 'STATUS' );
180: EXCEPTION WHEN NO_DATA_FOUND THEN
181: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
182: fnd_message.set_token( 'PARAMETER','STATUS' ) ;
183: x_error_message := fnd_message.get ;
184: END;
185: IF ( XNP$STATUS IS NULL) THEN
178: XNP$STATUS := XDP_ENGINE.get_workitem_param_value ( p_wi_instance_id,
179: 'STATUS' );
180: EXCEPTION WHEN NO_DATA_FOUND THEN
181: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
182: fnd_message.set_token( 'PARAMETER','STATUS' ) ;
183: x_error_message := fnd_message.get ;
184: END;
185: IF ( XNP$STATUS IS NULL) THEN
186: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
179: 'STATUS' );
180: EXCEPTION WHEN NO_DATA_FOUND THEN
181: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
182: fnd_message.set_token( 'PARAMETER','STATUS' ) ;
183: x_error_message := fnd_message.get ;
184: END;
185: IF ( XNP$STATUS IS NULL) THEN
186: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
187: fnd_message.set_token( 'ATTRIBUTE','STATUS' ) ;
182: fnd_message.set_token( 'PARAMETER','STATUS' ) ;
183: x_error_message := fnd_message.get ;
184: END;
185: IF ( XNP$STATUS IS NULL) THEN
186: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
187: fnd_message.set_token( 'ATTRIBUTE','STATUS' ) ;
188: x_error_message := fnd_message.get ;
189: RAISE e_MISSING_MANDATORY_DATA ;
190: END IF ;
183: x_error_message := fnd_message.get ;
184: END;
185: IF ( XNP$STATUS IS NULL) THEN
186: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
187: fnd_message.set_token( 'ATTRIBUTE','STATUS' ) ;
188: x_error_message := fnd_message.get ;
189: RAISE e_MISSING_MANDATORY_DATA ;
190: END IF ;
191: XNP_XML_UTILS.write_leaf_element ( 'STATUS', XNP$STATUS ) ;
184: END;
185: IF ( XNP$STATUS IS NULL) THEN
186: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
187: fnd_message.set_token( 'ATTRIBUTE','STATUS' ) ;
188: x_error_message := fnd_message.get ;
189: RAISE e_MISSING_MANDATORY_DATA ;
190: END IF ;
191: XNP_XML_UTILS.write_leaf_element ( 'STATUS', XNP$STATUS ) ;
192: BEGIN
192: BEGIN
193: XNP$CUSTOMER_TYPE := XDP_ENGINE.get_workitem_param_value ( p_wi_instance_id,
194: 'CUSTOMER_TYPE' );
195: EXCEPTION WHEN NO_DATA_FOUND THEN
196: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
197: fnd_message.set_token( 'PARAMETER','CUSTOMER_TYPE' ) ;
198: x_error_message := fnd_message.get ;
199: END;
200: IF ( XNP$CUSTOMER_TYPE IS NULL) THEN
193: XNP$CUSTOMER_TYPE := XDP_ENGINE.get_workitem_param_value ( p_wi_instance_id,
194: 'CUSTOMER_TYPE' );
195: EXCEPTION WHEN NO_DATA_FOUND THEN
196: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
197: fnd_message.set_token( 'PARAMETER','CUSTOMER_TYPE' ) ;
198: x_error_message := fnd_message.get ;
199: END;
200: IF ( XNP$CUSTOMER_TYPE IS NULL) THEN
201: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
194: 'CUSTOMER_TYPE' );
195: EXCEPTION WHEN NO_DATA_FOUND THEN
196: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
197: fnd_message.set_token( 'PARAMETER','CUSTOMER_TYPE' ) ;
198: x_error_message := fnd_message.get ;
199: END;
200: IF ( XNP$CUSTOMER_TYPE IS NULL) THEN
201: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
202: fnd_message.set_token( 'ATTRIBUTE','CUSTOMER_TYPE' ) ;
197: fnd_message.set_token( 'PARAMETER','CUSTOMER_TYPE' ) ;
198: x_error_message := fnd_message.get ;
199: END;
200: IF ( XNP$CUSTOMER_TYPE IS NULL) THEN
201: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
202: fnd_message.set_token( 'ATTRIBUTE','CUSTOMER_TYPE' ) ;
203: x_error_message := fnd_message.get ;
204: RAISE e_MISSING_MANDATORY_DATA ;
205: END IF ;
198: x_error_message := fnd_message.get ;
199: END;
200: IF ( XNP$CUSTOMER_TYPE IS NULL) THEN
201: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
202: fnd_message.set_token( 'ATTRIBUTE','CUSTOMER_TYPE' ) ;
203: x_error_message := fnd_message.get ;
204: RAISE e_MISSING_MANDATORY_DATA ;
205: END IF ;
206: XNP_XML_UTILS.write_leaf_element ( 'CUSTOMER_TYPE', XNP$CUSTOMER_TYPE ) ;
199: END;
200: IF ( XNP$CUSTOMER_TYPE IS NULL) THEN
201: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
202: fnd_message.set_token( 'ATTRIBUTE','CUSTOMER_TYPE' ) ;
203: x_error_message := fnd_message.get ;
204: RAISE e_MISSING_MANDATORY_DATA ;
205: END IF ;
206: XNP_XML_UTILS.write_leaf_element ( 'CUSTOMER_TYPE', XNP$CUSTOMER_TYPE ) ;
207: BEGIN
207: BEGIN
208: XNP$FEATURE_TYPE := XDP_ENGINE.get_workitem_param_value ( p_wi_instance_id,
209: 'FEATURE_TYPE' );
210: EXCEPTION WHEN NO_DATA_FOUND THEN
211: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
212: fnd_message.set_token( 'PARAMETER','FEATURE_TYPE' ) ;
213: x_error_message := fnd_message.get ;
214: END;
215: IF ( XNP$FEATURE_TYPE IS NULL) THEN
208: XNP$FEATURE_TYPE := XDP_ENGINE.get_workitem_param_value ( p_wi_instance_id,
209: 'FEATURE_TYPE' );
210: EXCEPTION WHEN NO_DATA_FOUND THEN
211: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
212: fnd_message.set_token( 'PARAMETER','FEATURE_TYPE' ) ;
213: x_error_message := fnd_message.get ;
214: END;
215: IF ( XNP$FEATURE_TYPE IS NULL) THEN
216: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
209: 'FEATURE_TYPE' );
210: EXCEPTION WHEN NO_DATA_FOUND THEN
211: fnd_message.set_name('XNP', 'XNP_WI_DATA_NOT_FOUND' );
212: fnd_message.set_token( 'PARAMETER','FEATURE_TYPE' ) ;
213: x_error_message := fnd_message.get ;
214: END;
215: IF ( XNP$FEATURE_TYPE IS NULL) THEN
216: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
217: fnd_message.set_token( 'ATTRIBUTE','FEATURE_TYPE' ) ;
212: fnd_message.set_token( 'PARAMETER','FEATURE_TYPE' ) ;
213: x_error_message := fnd_message.get ;
214: END;
215: IF ( XNP$FEATURE_TYPE IS NULL) THEN
216: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
217: fnd_message.set_token( 'ATTRIBUTE','FEATURE_TYPE' ) ;
218: x_error_message := fnd_message.get ;
219: RAISE e_MISSING_MANDATORY_DATA ;
220: END IF ;
213: x_error_message := fnd_message.get ;
214: END;
215: IF ( XNP$FEATURE_TYPE IS NULL) THEN
216: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
217: fnd_message.set_token( 'ATTRIBUTE','FEATURE_TYPE' ) ;
218: x_error_message := fnd_message.get ;
219: RAISE e_MISSING_MANDATORY_DATA ;
220: END IF ;
221: XNP_XML_UTILS.write_leaf_element ( 'FEATURE_TYPE', XNP$FEATURE_TYPE ) ;
214: END;
215: IF ( XNP$FEATURE_TYPE IS NULL) THEN
216: fnd_message.set_name('XNP', 'XNP_MISSING_MANDATORY_ATTR' );
217: fnd_message.set_token( 'ATTRIBUTE','FEATURE_TYPE' ) ;
218: x_error_message := fnd_message.get ;
219: RAISE e_MISSING_MANDATORY_DATA ;
220: END IF ;
221: XNP_XML_UTILS.write_leaf_element ( 'FEATURE_TYPE', XNP$FEATURE_TYPE ) ;
222: XNP_XML_UTILS.end_segment ( 'XDP_PERF_BM_EVT' ) ;