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.RCV_824_SV dependencies on ASN_DEBUG

Line 103: asn_debug.put_line('I am in 824 API');

99:
100: BEGIN
101: x_progress := '001';
102:
103: asn_debug.put_line('I am in 824 API');
104:
105: -- bug 569723 external_reference_1 should be the shipment number.
106:
107: x_external_reference_1 := X_interface_header.header_record.shipment_num;

Line 123: asn_debug.put_line('Vendor Site Id ' || to_char(X_interface_header.header_record.vendor_site_id));

119: x_external_reference_6 := X_interface_header.header_record.processing_status_code; */
120: x_entity_code := X_interface_header.header_record.vendor_num;
121: x_entity_name := X_interface_header.header_record.vendor_name;
122:
123: asn_debug.put_line('Vendor Site Id ' || to_char(X_interface_header.header_record.vendor_site_id));
124: asn_debug.put_line('Vendor Site Code ' || X_interface_header.header_record.vendor_site_code);
125:
126: if X_interface_header.header_record.vendor_site_id is not null then
127:

Line 124: asn_debug.put_line('Vendor Site Code ' || X_interface_header.header_record.vendor_site_code);

120: x_entity_code := X_interface_header.header_record.vendor_num;
121: x_entity_name := X_interface_header.header_record.vendor_name;
122:
123: asn_debug.put_line('Vendor Site Id ' || to_char(X_interface_header.header_record.vendor_site_id));
124: asn_debug.put_line('Vendor Site Code ' || X_interface_header.header_record.vendor_site_code);
125:
126: if X_interface_header.header_record.vendor_site_id is not null then
127:
128: asn_debug.put_line('Getting vendor_site information from vendor_site_id');

Line 128: asn_debug.put_line('Getting vendor_site information from vendor_site_id');

124: asn_debug.put_line('Vendor Site Code ' || X_interface_header.header_record.vendor_site_code);
125:
126: if X_interface_header.header_record.vendor_site_id is not null then
127:
128: asn_debug.put_line('Getting vendor_site information from vendor_site_id');
129:
130: begin
131: select tp_header_id, address_line1, address_line2, address_line3,
132: city, zip, country, state, province, ece_tp_location_code

Line 138: asn_debug.put_line('TP header id ' || to_char(x_tp_header_id));

134: x_entity_city, x_entity_postal_code, x_entity_country, x_entity_state,
135: x_entity_province, x_tp_location_code
136: from po_vendor_sites where po_vendor_sites.vendor_site_id = X_interface_header.header_record.vendor_site_id;
137:
138: asn_debug.put_line('TP header id ' || to_char(x_tp_header_id));
139:
140: exception
141:
142: when others then

Line 143: asn_debug.put_line('Unable to locate vendor site record');

139:
140: exception
141:
142: when others then
143: asn_debug.put_line('Unable to locate vendor site record');
144:
145: end;
146: else
147:

Line 148: asn_debug.put_line('Need to handle vendor_site_code is not null and vendor_site_id is null');

144:
145: end;
146: else
147:
148: asn_debug.put_line('Need to handle vendor_site_code is not null and vendor_site_id is null');
149:
150: end if;
151:
152:

Line 153: asn_debug.put_line('Calling the create advice header ');

149:
150: end if;
151:
152:
153: asn_debug.put_line('Calling the create advice header ');
154:
155: asn_debug.put_line('p_api_version_number ' || x_api_version_number);
156: asn_debug.put_line('p_communication_method ' || x_communication_method);
157: asn_debug.put_line('p_related_document_id ' || x_related_document_id);

Line 155: asn_debug.put_line('p_api_version_number ' || x_api_version_number);

151:
152:
153: asn_debug.put_line('Calling the create advice header ');
154:
155: asn_debug.put_line('p_api_version_number ' || x_api_version_number);
156: asn_debug.put_line('p_communication_method ' || x_communication_method);
157: asn_debug.put_line('p_related_document_id ' || x_related_document_id);
158: asn_debug.put_line('p_tp_header_id ' || x_tp_header_id);
159: asn_debug.put_line('p_tp_location_code ' || x_tp_location_code);

Line 156: asn_debug.put_line('p_communication_method ' || x_communication_method);

152:
153: asn_debug.put_line('Calling the create advice header ');
154:
155: asn_debug.put_line('p_api_version_number ' || x_api_version_number);
156: asn_debug.put_line('p_communication_method ' || x_communication_method);
157: asn_debug.put_line('p_related_document_id ' || x_related_document_id);
158: asn_debug.put_line('p_tp_header_id ' || x_tp_header_id);
159: asn_debug.put_line('p_tp_location_code ' || x_tp_location_code);
160: asn_debug.put_line('p_document_type ' || x_document_type);

Line 157: asn_debug.put_line('p_related_document_id ' || x_related_document_id);

153: asn_debug.put_line('Calling the create advice header ');
154:
155: asn_debug.put_line('p_api_version_number ' || x_api_version_number);
156: asn_debug.put_line('p_communication_method ' || x_communication_method);
157: asn_debug.put_line('p_related_document_id ' || x_related_document_id);
158: asn_debug.put_line('p_tp_header_id ' || x_tp_header_id);
159: asn_debug.put_line('p_tp_location_code ' || x_tp_location_code);
160: asn_debug.put_line('p_document_type ' || x_document_type);
161: asn_debug.put_line('p_document_code ' || x_document_code);

Line 158: asn_debug.put_line('p_tp_header_id ' || x_tp_header_id);

154:
155: asn_debug.put_line('p_api_version_number ' || x_api_version_number);
156: asn_debug.put_line('p_communication_method ' || x_communication_method);
157: asn_debug.put_line('p_related_document_id ' || x_related_document_id);
158: asn_debug.put_line('p_tp_header_id ' || x_tp_header_id);
159: asn_debug.put_line('p_tp_location_code ' || x_tp_location_code);
160: asn_debug.put_line('p_document_type ' || x_document_type);
161: asn_debug.put_line('p_document_code ' || x_document_code);
162: asn_debug.put_line('p_entity_code ' || x_entity_code);

Line 159: asn_debug.put_line('p_tp_location_code ' || x_tp_location_code);

155: asn_debug.put_line('p_api_version_number ' || x_api_version_number);
156: asn_debug.put_line('p_communication_method ' || x_communication_method);
157: asn_debug.put_line('p_related_document_id ' || x_related_document_id);
158: asn_debug.put_line('p_tp_header_id ' || x_tp_header_id);
159: asn_debug.put_line('p_tp_location_code ' || x_tp_location_code);
160: asn_debug.put_line('p_document_type ' || x_document_type);
161: asn_debug.put_line('p_document_code ' || x_document_code);
162: asn_debug.put_line('p_entity_code ' || x_entity_code);
163: asn_debug.put_line('p_entity_name ' || x_entity_name);

Line 160: asn_debug.put_line('p_document_type ' || x_document_type);

156: asn_debug.put_line('p_communication_method ' || x_communication_method);
157: asn_debug.put_line('p_related_document_id ' || x_related_document_id);
158: asn_debug.put_line('p_tp_header_id ' || x_tp_header_id);
159: asn_debug.put_line('p_tp_location_code ' || x_tp_location_code);
160: asn_debug.put_line('p_document_type ' || x_document_type);
161: asn_debug.put_line('p_document_code ' || x_document_code);
162: asn_debug.put_line('p_entity_code ' || x_entity_code);
163: asn_debug.put_line('p_entity_name ' || x_entity_name);
164: asn_debug.put_line('p_entity_address1 ' || x_entity_address1);

Line 161: asn_debug.put_line('p_document_code ' || x_document_code);

157: asn_debug.put_line('p_related_document_id ' || x_related_document_id);
158: asn_debug.put_line('p_tp_header_id ' || x_tp_header_id);
159: asn_debug.put_line('p_tp_location_code ' || x_tp_location_code);
160: asn_debug.put_line('p_document_type ' || x_document_type);
161: asn_debug.put_line('p_document_code ' || x_document_code);
162: asn_debug.put_line('p_entity_code ' || x_entity_code);
163: asn_debug.put_line('p_entity_name ' || x_entity_name);
164: asn_debug.put_line('p_entity_address1 ' || x_entity_address1);
165: asn_debug.put_line('p_entity_address2 ' || x_entity_address2);

Line 162: asn_debug.put_line('p_entity_code ' || x_entity_code);

158: asn_debug.put_line('p_tp_header_id ' || x_tp_header_id);
159: asn_debug.put_line('p_tp_location_code ' || x_tp_location_code);
160: asn_debug.put_line('p_document_type ' || x_document_type);
161: asn_debug.put_line('p_document_code ' || x_document_code);
162: asn_debug.put_line('p_entity_code ' || x_entity_code);
163: asn_debug.put_line('p_entity_name ' || x_entity_name);
164: asn_debug.put_line('p_entity_address1 ' || x_entity_address1);
165: asn_debug.put_line('p_entity_address2 ' || x_entity_address2);
166: asn_debug.put_line('p_entity_address3 ' || x_entity_address3);

Line 163: asn_debug.put_line('p_entity_name ' || x_entity_name);

159: asn_debug.put_line('p_tp_location_code ' || x_tp_location_code);
160: asn_debug.put_line('p_document_type ' || x_document_type);
161: asn_debug.put_line('p_document_code ' || x_document_code);
162: asn_debug.put_line('p_entity_code ' || x_entity_code);
163: asn_debug.put_line('p_entity_name ' || x_entity_name);
164: asn_debug.put_line('p_entity_address1 ' || x_entity_address1);
165: asn_debug.put_line('p_entity_address2 ' || x_entity_address2);
166: asn_debug.put_line('p_entity_address3 ' || x_entity_address3);
167: asn_debug.put_line('p_entity_address4 ' || x_entity_address4);

Line 164: asn_debug.put_line('p_entity_address1 ' || x_entity_address1);

160: asn_debug.put_line('p_document_type ' || x_document_type);
161: asn_debug.put_line('p_document_code ' || x_document_code);
162: asn_debug.put_line('p_entity_code ' || x_entity_code);
163: asn_debug.put_line('p_entity_name ' || x_entity_name);
164: asn_debug.put_line('p_entity_address1 ' || x_entity_address1);
165: asn_debug.put_line('p_entity_address2 ' || x_entity_address2);
166: asn_debug.put_line('p_entity_address3 ' || x_entity_address3);
167: asn_debug.put_line('p_entity_address4 ' || x_entity_address4);
168: asn_debug.put_line('p_entity_city ' || x_entity_city);

Line 165: asn_debug.put_line('p_entity_address2 ' || x_entity_address2);

161: asn_debug.put_line('p_document_code ' || x_document_code);
162: asn_debug.put_line('p_entity_code ' || x_entity_code);
163: asn_debug.put_line('p_entity_name ' || x_entity_name);
164: asn_debug.put_line('p_entity_address1 ' || x_entity_address1);
165: asn_debug.put_line('p_entity_address2 ' || x_entity_address2);
166: asn_debug.put_line('p_entity_address3 ' || x_entity_address3);
167: asn_debug.put_line('p_entity_address4 ' || x_entity_address4);
168: asn_debug.put_line('p_entity_city ' || x_entity_city);
169: asn_debug.put_line('p_entity_postal_code ' || x_entity_postal_code);

Line 166: asn_debug.put_line('p_entity_address3 ' || x_entity_address3);

162: asn_debug.put_line('p_entity_code ' || x_entity_code);
163: asn_debug.put_line('p_entity_name ' || x_entity_name);
164: asn_debug.put_line('p_entity_address1 ' || x_entity_address1);
165: asn_debug.put_line('p_entity_address2 ' || x_entity_address2);
166: asn_debug.put_line('p_entity_address3 ' || x_entity_address3);
167: asn_debug.put_line('p_entity_address4 ' || x_entity_address4);
168: asn_debug.put_line('p_entity_city ' || x_entity_city);
169: asn_debug.put_line('p_entity_postal_code ' || x_entity_postal_code);
170: asn_debug.put_line('p_entity_country ' || x_entity_country);

Line 167: asn_debug.put_line('p_entity_address4 ' || x_entity_address4);

163: asn_debug.put_line('p_entity_name ' || x_entity_name);
164: asn_debug.put_line('p_entity_address1 ' || x_entity_address1);
165: asn_debug.put_line('p_entity_address2 ' || x_entity_address2);
166: asn_debug.put_line('p_entity_address3 ' || x_entity_address3);
167: asn_debug.put_line('p_entity_address4 ' || x_entity_address4);
168: asn_debug.put_line('p_entity_city ' || x_entity_city);
169: asn_debug.put_line('p_entity_postal_code ' || x_entity_postal_code);
170: asn_debug.put_line('p_entity_country ' || x_entity_country);
171: asn_debug.put_line('p_entity_state ' || x_entity_state);

Line 168: asn_debug.put_line('p_entity_city ' || x_entity_city);

164: asn_debug.put_line('p_entity_address1 ' || x_entity_address1);
165: asn_debug.put_line('p_entity_address2 ' || x_entity_address2);
166: asn_debug.put_line('p_entity_address3 ' || x_entity_address3);
167: asn_debug.put_line('p_entity_address4 ' || x_entity_address4);
168: asn_debug.put_line('p_entity_city ' || x_entity_city);
169: asn_debug.put_line('p_entity_postal_code ' || x_entity_postal_code);
170: asn_debug.put_line('p_entity_country ' || x_entity_country);
171: asn_debug.put_line('p_entity_state ' || x_entity_state);
172: asn_debug.put_line('p_entity_province ' || x_entity_province);

Line 169: asn_debug.put_line('p_entity_postal_code ' || x_entity_postal_code);

165: asn_debug.put_line('p_entity_address2 ' || x_entity_address2);
166: asn_debug.put_line('p_entity_address3 ' || x_entity_address3);
167: asn_debug.put_line('p_entity_address4 ' || x_entity_address4);
168: asn_debug.put_line('p_entity_city ' || x_entity_city);
169: asn_debug.put_line('p_entity_postal_code ' || x_entity_postal_code);
170: asn_debug.put_line('p_entity_country ' || x_entity_country);
171: asn_debug.put_line('p_entity_state ' || x_entity_state);
172: asn_debug.put_line('p_entity_province ' || x_entity_province);
173: asn_debug.put_line('p_entity_county ' || x_entity_county);

Line 170: asn_debug.put_line('p_entity_country ' || x_entity_country);

166: asn_debug.put_line('p_entity_address3 ' || x_entity_address3);
167: asn_debug.put_line('p_entity_address4 ' || x_entity_address4);
168: asn_debug.put_line('p_entity_city ' || x_entity_city);
169: asn_debug.put_line('p_entity_postal_code ' || x_entity_postal_code);
170: asn_debug.put_line('p_entity_country ' || x_entity_country);
171: asn_debug.put_line('p_entity_state ' || x_entity_state);
172: asn_debug.put_line('p_entity_province ' || x_entity_province);
173: asn_debug.put_line('p_entity_county ' || x_entity_county);
174: asn_debug.put_line('p_external_reference_1 ' || x_external_reference_1);

Line 171: asn_debug.put_line('p_entity_state ' || x_entity_state);

167: asn_debug.put_line('p_entity_address4 ' || x_entity_address4);
168: asn_debug.put_line('p_entity_city ' || x_entity_city);
169: asn_debug.put_line('p_entity_postal_code ' || x_entity_postal_code);
170: asn_debug.put_line('p_entity_country ' || x_entity_country);
171: asn_debug.put_line('p_entity_state ' || x_entity_state);
172: asn_debug.put_line('p_entity_province ' || x_entity_province);
173: asn_debug.put_line('p_entity_county ' || x_entity_county);
174: asn_debug.put_line('p_external_reference_1 ' || x_external_reference_1);
175: asn_debug.put_line('p_external_reference_2 ' || x_external_reference_2);

Line 172: asn_debug.put_line('p_entity_province ' || x_entity_province);

168: asn_debug.put_line('p_entity_city ' || x_entity_city);
169: asn_debug.put_line('p_entity_postal_code ' || x_entity_postal_code);
170: asn_debug.put_line('p_entity_country ' || x_entity_country);
171: asn_debug.put_line('p_entity_state ' || x_entity_state);
172: asn_debug.put_line('p_entity_province ' || x_entity_province);
173: asn_debug.put_line('p_entity_county ' || x_entity_county);
174: asn_debug.put_line('p_external_reference_1 ' || x_external_reference_1);
175: asn_debug.put_line('p_external_reference_2 ' || x_external_reference_2);
176: asn_debug.put_line('p_external_reference_3 ' || x_external_reference_3);

Line 173: asn_debug.put_line('p_entity_county ' || x_entity_county);

169: asn_debug.put_line('p_entity_postal_code ' || x_entity_postal_code);
170: asn_debug.put_line('p_entity_country ' || x_entity_country);
171: asn_debug.put_line('p_entity_state ' || x_entity_state);
172: asn_debug.put_line('p_entity_province ' || x_entity_province);
173: asn_debug.put_line('p_entity_county ' || x_entity_county);
174: asn_debug.put_line('p_external_reference_1 ' || x_external_reference_1);
175: asn_debug.put_line('p_external_reference_2 ' || x_external_reference_2);
176: asn_debug.put_line('p_external_reference_3 ' || x_external_reference_3);
177: asn_debug.put_line('p_external_reference_4 ' || x_external_reference_4);

Line 174: asn_debug.put_line('p_external_reference_1 ' || x_external_reference_1);

170: asn_debug.put_line('p_entity_country ' || x_entity_country);
171: asn_debug.put_line('p_entity_state ' || x_entity_state);
172: asn_debug.put_line('p_entity_province ' || x_entity_province);
173: asn_debug.put_line('p_entity_county ' || x_entity_county);
174: asn_debug.put_line('p_external_reference_1 ' || x_external_reference_1);
175: asn_debug.put_line('p_external_reference_2 ' || x_external_reference_2);
176: asn_debug.put_line('p_external_reference_3 ' || x_external_reference_3);
177: asn_debug.put_line('p_external_reference_4 ' || x_external_reference_4);
178: asn_debug.put_line('p_external_reference_5 ' || x_external_reference_5);

Line 175: asn_debug.put_line('p_external_reference_2 ' || x_external_reference_2);

171: asn_debug.put_line('p_entity_state ' || x_entity_state);
172: asn_debug.put_line('p_entity_province ' || x_entity_province);
173: asn_debug.put_line('p_entity_county ' || x_entity_county);
174: asn_debug.put_line('p_external_reference_1 ' || x_external_reference_1);
175: asn_debug.put_line('p_external_reference_2 ' || x_external_reference_2);
176: asn_debug.put_line('p_external_reference_3 ' || x_external_reference_3);
177: asn_debug.put_line('p_external_reference_4 ' || x_external_reference_4);
178: asn_debug.put_line('p_external_reference_5 ' || x_external_reference_5);
179: asn_debug.put_line('p_external_reference_6 ' || x_external_reference_6);

Line 176: asn_debug.put_line('p_external_reference_3 ' || x_external_reference_3);

172: asn_debug.put_line('p_entity_province ' || x_entity_province);
173: asn_debug.put_line('p_entity_county ' || x_entity_county);
174: asn_debug.put_line('p_external_reference_1 ' || x_external_reference_1);
175: asn_debug.put_line('p_external_reference_2 ' || x_external_reference_2);
176: asn_debug.put_line('p_external_reference_3 ' || x_external_reference_3);
177: asn_debug.put_line('p_external_reference_4 ' || x_external_reference_4);
178: asn_debug.put_line('p_external_reference_5 ' || x_external_reference_5);
179: asn_debug.put_line('p_external_reference_6 ' || x_external_reference_6);
180: asn_debug.put_line('p_internal_reference_1 ' || x_internal_reference_1);

Line 177: asn_debug.put_line('p_external_reference_4 ' || x_external_reference_4);

173: asn_debug.put_line('p_entity_county ' || x_entity_county);
174: asn_debug.put_line('p_external_reference_1 ' || x_external_reference_1);
175: asn_debug.put_line('p_external_reference_2 ' || x_external_reference_2);
176: asn_debug.put_line('p_external_reference_3 ' || x_external_reference_3);
177: asn_debug.put_line('p_external_reference_4 ' || x_external_reference_4);
178: asn_debug.put_line('p_external_reference_5 ' || x_external_reference_5);
179: asn_debug.put_line('p_external_reference_6 ' || x_external_reference_6);
180: asn_debug.put_line('p_internal_reference_1 ' || x_internal_reference_1);
181: asn_debug.put_line('p_internal_reference_2 ' || x_internal_reference_2);

Line 178: asn_debug.put_line('p_external_reference_5 ' || x_external_reference_5);

174: asn_debug.put_line('p_external_reference_1 ' || x_external_reference_1);
175: asn_debug.put_line('p_external_reference_2 ' || x_external_reference_2);
176: asn_debug.put_line('p_external_reference_3 ' || x_external_reference_3);
177: asn_debug.put_line('p_external_reference_4 ' || x_external_reference_4);
178: asn_debug.put_line('p_external_reference_5 ' || x_external_reference_5);
179: asn_debug.put_line('p_external_reference_6 ' || x_external_reference_6);
180: asn_debug.put_line('p_internal_reference_1 ' || x_internal_reference_1);
181: asn_debug.put_line('p_internal_reference_2 ' || x_internal_reference_2);
182: asn_debug.put_line('p_internal_reference_3 ' || x_internal_reference_3);

Line 179: asn_debug.put_line('p_external_reference_6 ' || x_external_reference_6);

175: asn_debug.put_line('p_external_reference_2 ' || x_external_reference_2);
176: asn_debug.put_line('p_external_reference_3 ' || x_external_reference_3);
177: asn_debug.put_line('p_external_reference_4 ' || x_external_reference_4);
178: asn_debug.put_line('p_external_reference_5 ' || x_external_reference_5);
179: asn_debug.put_line('p_external_reference_6 ' || x_external_reference_6);
180: asn_debug.put_line('p_internal_reference_1 ' || x_internal_reference_1);
181: asn_debug.put_line('p_internal_reference_2 ' || x_internal_reference_2);
182: asn_debug.put_line('p_internal_reference_3 ' || x_internal_reference_3);
183: asn_debug.put_line('p_internal_reference_4 ' || x_internal_reference_4);

Line 180: asn_debug.put_line('p_internal_reference_1 ' || x_internal_reference_1);

176: asn_debug.put_line('p_external_reference_3 ' || x_external_reference_3);
177: asn_debug.put_line('p_external_reference_4 ' || x_external_reference_4);
178: asn_debug.put_line('p_external_reference_5 ' || x_external_reference_5);
179: asn_debug.put_line('p_external_reference_6 ' || x_external_reference_6);
180: asn_debug.put_line('p_internal_reference_1 ' || x_internal_reference_1);
181: asn_debug.put_line('p_internal_reference_2 ' || x_internal_reference_2);
182: asn_debug.put_line('p_internal_reference_3 ' || x_internal_reference_3);
183: asn_debug.put_line('p_internal_reference_4 ' || x_internal_reference_4);
184: asn_debug.put_line('p_internal_reference_5 ' || x_internal_reference_5);

Line 181: asn_debug.put_line('p_internal_reference_2 ' || x_internal_reference_2);

177: asn_debug.put_line('p_external_reference_4 ' || x_external_reference_4);
178: asn_debug.put_line('p_external_reference_5 ' || x_external_reference_5);
179: asn_debug.put_line('p_external_reference_6 ' || x_external_reference_6);
180: asn_debug.put_line('p_internal_reference_1 ' || x_internal_reference_1);
181: asn_debug.put_line('p_internal_reference_2 ' || x_internal_reference_2);
182: asn_debug.put_line('p_internal_reference_3 ' || x_internal_reference_3);
183: asn_debug.put_line('p_internal_reference_4 ' || x_internal_reference_4);
184: asn_debug.put_line('p_internal_reference_5 ' || x_internal_reference_5);
185: asn_debug.put_line('p_internal_reference_6 ' || x_internal_reference_6);

Line 182: asn_debug.put_line('p_internal_reference_3 ' || x_internal_reference_3);

178: asn_debug.put_line('p_external_reference_5 ' || x_external_reference_5);
179: asn_debug.put_line('p_external_reference_6 ' || x_external_reference_6);
180: asn_debug.put_line('p_internal_reference_1 ' || x_internal_reference_1);
181: asn_debug.put_line('p_internal_reference_2 ' || x_internal_reference_2);
182: asn_debug.put_line('p_internal_reference_3 ' || x_internal_reference_3);
183: asn_debug.put_line('p_internal_reference_4 ' || x_internal_reference_4);
184: asn_debug.put_line('p_internal_reference_5 ' || x_internal_reference_5);
185: asn_debug.put_line('p_internal_reference_6 ' || x_internal_reference_6);
186:

Line 183: asn_debug.put_line('p_internal_reference_4 ' || x_internal_reference_4);

179: asn_debug.put_line('p_external_reference_6 ' || x_external_reference_6);
180: asn_debug.put_line('p_internal_reference_1 ' || x_internal_reference_1);
181: asn_debug.put_line('p_internal_reference_2 ' || x_internal_reference_2);
182: asn_debug.put_line('p_internal_reference_3 ' || x_internal_reference_3);
183: asn_debug.put_line('p_internal_reference_4 ' || x_internal_reference_4);
184: asn_debug.put_line('p_internal_reference_5 ' || x_internal_reference_5);
185: asn_debug.put_line('p_internal_reference_6 ' || x_internal_reference_6);
186:
187:

Line 184: asn_debug.put_line('p_internal_reference_5 ' || x_internal_reference_5);

180: asn_debug.put_line('p_internal_reference_1 ' || x_internal_reference_1);
181: asn_debug.put_line('p_internal_reference_2 ' || x_internal_reference_2);
182: asn_debug.put_line('p_internal_reference_3 ' || x_internal_reference_3);
183: asn_debug.put_line('p_internal_reference_4 ' || x_internal_reference_4);
184: asn_debug.put_line('p_internal_reference_5 ' || x_internal_reference_5);
185: asn_debug.put_line('p_internal_reference_6 ' || x_internal_reference_6);
186:
187:
188:

Line 185: asn_debug.put_line('p_internal_reference_6 ' || x_internal_reference_6);

181: asn_debug.put_line('p_internal_reference_2 ' || x_internal_reference_2);
182: asn_debug.put_line('p_internal_reference_3 ' || x_internal_reference_3);
183: asn_debug.put_line('p_internal_reference_4 ' || x_internal_reference_4);
184: asn_debug.put_line('p_internal_reference_5 ' || x_internal_reference_5);
185: asn_debug.put_line('p_internal_reference_6 ' || x_internal_reference_6);
186:
187:
188:
189: EC_APPLICATION_ADVICE_PUB.create_advice (p_api_version_number => x_api_version_number,

Line 226: asn_debug.put_line('Returned Advice header id ' || to_char(x_advice_header_id));

222: p_internal_reference_5 => x_internal_reference_5,
223: p_internal_reference_6 => x_internal_reference_6,
224: p_advice_header_id => x_advice_header_id);
225:
226: asn_debug.put_line('Returned Advice header id ' || to_char(x_advice_header_id));
227: asn_debug.put_line('Return Status ' || x_return_status);
228: asn_debug.put_line('msg count ' || to_char(x_msg_count));
229: asn_debug.put_line('msg data ' || x_msg_data);
230:

Line 227: asn_debug.put_line('Return Status ' || x_return_status);

223: p_internal_reference_6 => x_internal_reference_6,
224: p_advice_header_id => x_advice_header_id);
225:
226: asn_debug.put_line('Returned Advice header id ' || to_char(x_advice_header_id));
227: asn_debug.put_line('Return Status ' || x_return_status);
228: asn_debug.put_line('msg count ' || to_char(x_msg_count));
229: asn_debug.put_line('msg data ' || x_msg_data);
230:
231: -- 824 header level errors

Line 228: asn_debug.put_line('msg count ' || to_char(x_msg_count));

224: p_advice_header_id => x_advice_header_id);
225:
226: asn_debug.put_line('Returned Advice header id ' || to_char(x_advice_header_id));
227: asn_debug.put_line('Return Status ' || x_return_status);
228: asn_debug.put_line('msg count ' || to_char(x_msg_count));
229: asn_debug.put_line('msg data ' || x_msg_data);
230:
231: -- 824 header level errors
232:

Line 229: asn_debug.put_line('msg data ' || x_msg_data);

225:
226: asn_debug.put_line('Returned Advice header id ' || to_char(x_advice_header_id));
227: asn_debug.put_line('Return Status ' || x_return_status);
228: asn_debug.put_line('msg count ' || to_char(x_msg_count));
229: asn_debug.put_line('msg data ' || x_msg_data);
230:
231: -- 824 header level errors
232:
233: for gher in get_header_error_rows loop

Line 235: asn_debug.put_line('Calling the advice lines api for header errors');

231: -- 824 header level errors
232:
233: for gher in get_header_error_rows loop
234:
235: asn_debug.put_line('Calling the advice lines api for header errors');
236:
237: /* 2700139 - The internal reference1 is populated with to_char(0) as external reference1
238: for advice line creation. */
239: x_internal_reference_1 := to_char(0);

Line 279: asn_debug.put_line('Return Status ' || x_return_status);

275: p_advo_message_desc => x_advo_message_desc,
276: p_advo_data_bad => x_advo_data_bad,
277: p_advo_data_good => x_advo_data_good);
278:
279: asn_debug.put_line('Return Status ' || x_return_status);
280: asn_debug.put_line('msg count ' || to_char(x_msg_count));
281: asn_debug.put_line('msg data ' || x_msg_data);
282:
283: end loop;

Line 280: asn_debug.put_line('msg count ' || to_char(x_msg_count));

276: p_advo_data_bad => x_advo_data_bad,
277: p_advo_data_good => x_advo_data_good);
278:
279: asn_debug.put_line('Return Status ' || x_return_status);
280: asn_debug.put_line('msg count ' || to_char(x_msg_count));
281: asn_debug.put_line('msg data ' || x_msg_data);
282:
283: end loop;
284:

Line 281: asn_debug.put_line('msg data ' || x_msg_data);

277: p_advo_data_good => x_advo_data_good);
278:
279: asn_debug.put_line('Return Status ' || x_return_status);
280: asn_debug.put_line('msg count ' || to_char(x_msg_count));
281: asn_debug.put_line('msg data ' || x_msg_data);
282:
283: end loop;
284:
285: -- 824 line level errors

Line 290: asn_debug.put_line('in discrepant_shipment');

286:
287: /* NWANG 9-4-1997 */
288: if (X_Type = 'DISCREPANT_SHIPMENT') then
289:
290: asn_debug.put_line('in discrepant_shipment');
291: for grlr in get_receipt_line_rows loop
292:
293: x_external_reference_1 := grlr.concatenated_segments;
294: x_external_reference_2 := grlr.segment1;

Line 310: asn_debug.put_line(' before create line');

306: x_internal_reference_1 := grlr.line_num;
307:
308:
309:
310: asn_debug.put_line(' before create line');
311:
312: asn_debug.put_line('line_api_version_number ' || x_api_version_number);
313: asn_debug.put_line('line_advice_header_id ' || x_advice_header_id);
314: asn_debug.put_line('line_advice_status_code ' || x_advice_status_code);

Line 312: asn_debug.put_line('line_api_version_number ' || x_api_version_number);

308:
309:
310: asn_debug.put_line(' before create line');
311:
312: asn_debug.put_line('line_api_version_number ' || x_api_version_number);
313: asn_debug.put_line('line_advice_header_id ' || x_advice_header_id);
314: asn_debug.put_line('line_advice_status_code ' || x_advice_status_code);
315: asn_debug.put_line('line_external_reference_1 ' || x_external_reference_1);
316: asn_debug.put_line('line_external_reference_2 ' || x_external_reference_2);

Line 313: asn_debug.put_line('line_advice_header_id ' || x_advice_header_id);

309:
310: asn_debug.put_line(' before create line');
311:
312: asn_debug.put_line('line_api_version_number ' || x_api_version_number);
313: asn_debug.put_line('line_advice_header_id ' || x_advice_header_id);
314: asn_debug.put_line('line_advice_status_code ' || x_advice_status_code);
315: asn_debug.put_line('line_external_reference_1 ' || x_external_reference_1);
316: asn_debug.put_line('line_external_reference_2 ' || x_external_reference_2);
317: asn_debug.put_line('line_external_reference_3 ' || x_external_reference_3);

Line 314: asn_debug.put_line('line_advice_status_code ' || x_advice_status_code);

310: asn_debug.put_line(' before create line');
311:
312: asn_debug.put_line('line_api_version_number ' || x_api_version_number);
313: asn_debug.put_line('line_advice_header_id ' || x_advice_header_id);
314: asn_debug.put_line('line_advice_status_code ' || x_advice_status_code);
315: asn_debug.put_line('line_external_reference_1 ' || x_external_reference_1);
316: asn_debug.put_line('line_external_reference_2 ' || x_external_reference_2);
317: asn_debug.put_line('line_external_reference_3 ' || x_external_reference_3);
318: asn_debug.put_line('line_external_reference_4 ' || x_external_reference_4);

Line 315: asn_debug.put_line('line_external_reference_1 ' || x_external_reference_1);

311:
312: asn_debug.put_line('line_api_version_number ' || x_api_version_number);
313: asn_debug.put_line('line_advice_header_id ' || x_advice_header_id);
314: asn_debug.put_line('line_advice_status_code ' || x_advice_status_code);
315: asn_debug.put_line('line_external_reference_1 ' || x_external_reference_1);
316: asn_debug.put_line('line_external_reference_2 ' || x_external_reference_2);
317: asn_debug.put_line('line_external_reference_3 ' || x_external_reference_3);
318: asn_debug.put_line('line_external_reference_4 ' || x_external_reference_4);
319: asn_debug.put_line('line_external_reference_5 ' || x_external_reference_5);

Line 316: asn_debug.put_line('line_external_reference_2 ' || x_external_reference_2);

312: asn_debug.put_line('line_api_version_number ' || x_api_version_number);
313: asn_debug.put_line('line_advice_header_id ' || x_advice_header_id);
314: asn_debug.put_line('line_advice_status_code ' || x_advice_status_code);
315: asn_debug.put_line('line_external_reference_1 ' || x_external_reference_1);
316: asn_debug.put_line('line_external_reference_2 ' || x_external_reference_2);
317: asn_debug.put_line('line_external_reference_3 ' || x_external_reference_3);
318: asn_debug.put_line('line_external_reference_4 ' || x_external_reference_4);
319: asn_debug.put_line('line_external_reference_5 ' || x_external_reference_5);
320: asn_debug.put_line('line_external_reference_6 ' || x_external_reference_6);

Line 317: asn_debug.put_line('line_external_reference_3 ' || x_external_reference_3);

313: asn_debug.put_line('line_advice_header_id ' || x_advice_header_id);
314: asn_debug.put_line('line_advice_status_code ' || x_advice_status_code);
315: asn_debug.put_line('line_external_reference_1 ' || x_external_reference_1);
316: asn_debug.put_line('line_external_reference_2 ' || x_external_reference_2);
317: asn_debug.put_line('line_external_reference_3 ' || x_external_reference_3);
318: asn_debug.put_line('line_external_reference_4 ' || x_external_reference_4);
319: asn_debug.put_line('line_external_reference_5 ' || x_external_reference_5);
320: asn_debug.put_line('line_external_reference_6 ' || x_external_reference_6);
321: asn_debug.put_line('line_internal_reference_1 ' || x_internal_reference_1);

Line 318: asn_debug.put_line('line_external_reference_4 ' || x_external_reference_4);

314: asn_debug.put_line('line_advice_status_code ' || x_advice_status_code);
315: asn_debug.put_line('line_external_reference_1 ' || x_external_reference_1);
316: asn_debug.put_line('line_external_reference_2 ' || x_external_reference_2);
317: asn_debug.put_line('line_external_reference_3 ' || x_external_reference_3);
318: asn_debug.put_line('line_external_reference_4 ' || x_external_reference_4);
319: asn_debug.put_line('line_external_reference_5 ' || x_external_reference_5);
320: asn_debug.put_line('line_external_reference_6 ' || x_external_reference_6);
321: asn_debug.put_line('line_internal_reference_1 ' || x_internal_reference_1);
322: asn_debug.put_line('line_internal_reference_2 ' || x_internal_reference_2);

Line 319: asn_debug.put_line('line_external_reference_5 ' || x_external_reference_5);

315: asn_debug.put_line('line_external_reference_1 ' || x_external_reference_1);
316: asn_debug.put_line('line_external_reference_2 ' || x_external_reference_2);
317: asn_debug.put_line('line_external_reference_3 ' || x_external_reference_3);
318: asn_debug.put_line('line_external_reference_4 ' || x_external_reference_4);
319: asn_debug.put_line('line_external_reference_5 ' || x_external_reference_5);
320: asn_debug.put_line('line_external_reference_6 ' || x_external_reference_6);
321: asn_debug.put_line('line_internal_reference_1 ' || x_internal_reference_1);
322: asn_debug.put_line('line_internal_reference_2 ' || x_internal_reference_2);
323: asn_debug.put_line('line_internal_reference_3 ' || x_internal_reference_3);

Line 320: asn_debug.put_line('line_external_reference_6 ' || x_external_reference_6);

316: asn_debug.put_line('line_external_reference_2 ' || x_external_reference_2);
317: asn_debug.put_line('line_external_reference_3 ' || x_external_reference_3);
318: asn_debug.put_line('line_external_reference_4 ' || x_external_reference_4);
319: asn_debug.put_line('line_external_reference_5 ' || x_external_reference_5);
320: asn_debug.put_line('line_external_reference_6 ' || x_external_reference_6);
321: asn_debug.put_line('line_internal_reference_1 ' || x_internal_reference_1);
322: asn_debug.put_line('line_internal_reference_2 ' || x_internal_reference_2);
323: asn_debug.put_line('line_internal_reference_3 ' || x_internal_reference_3);
324: asn_debug.put_line('line_internal_reference_4 ' || x_internal_reference_4);

Line 321: asn_debug.put_line('line_internal_reference_1 ' || x_internal_reference_1);

317: asn_debug.put_line('line_external_reference_3 ' || x_external_reference_3);
318: asn_debug.put_line('line_external_reference_4 ' || x_external_reference_4);
319: asn_debug.put_line('line_external_reference_5 ' || x_external_reference_5);
320: asn_debug.put_line('line_external_reference_6 ' || x_external_reference_6);
321: asn_debug.put_line('line_internal_reference_1 ' || x_internal_reference_1);
322: asn_debug.put_line('line_internal_reference_2 ' || x_internal_reference_2);
323: asn_debug.put_line('line_internal_reference_3 ' || x_internal_reference_3);
324: asn_debug.put_line('line_internal_reference_4 ' || x_internal_reference_4);
325: asn_debug.put_line('line_internal_reference_5 ' || x_internal_reference_5);

Line 322: asn_debug.put_line('line_internal_reference_2 ' || x_internal_reference_2);

318: asn_debug.put_line('line_external_reference_4 ' || x_external_reference_4);
319: asn_debug.put_line('line_external_reference_5 ' || x_external_reference_5);
320: asn_debug.put_line('line_external_reference_6 ' || x_external_reference_6);
321: asn_debug.put_line('line_internal_reference_1 ' || x_internal_reference_1);
322: asn_debug.put_line('line_internal_reference_2 ' || x_internal_reference_2);
323: asn_debug.put_line('line_internal_reference_3 ' || x_internal_reference_3);
324: asn_debug.put_line('line_internal_reference_4 ' || x_internal_reference_4);
325: asn_debug.put_line('line_internal_reference_5 ' || x_internal_reference_5);
326: asn_debug.put_line('line_internal_reference_6 ' || x_internal_reference_6);

Line 323: asn_debug.put_line('line_internal_reference_3 ' || x_internal_reference_3);

319: asn_debug.put_line('line_external_reference_5 ' || x_external_reference_5);
320: asn_debug.put_line('line_external_reference_6 ' || x_external_reference_6);
321: asn_debug.put_line('line_internal_reference_1 ' || x_internal_reference_1);
322: asn_debug.put_line('line_internal_reference_2 ' || x_internal_reference_2);
323: asn_debug.put_line('line_internal_reference_3 ' || x_internal_reference_3);
324: asn_debug.put_line('line_internal_reference_4 ' || x_internal_reference_4);
325: asn_debug.put_line('line_internal_reference_5 ' || x_internal_reference_5);
326: asn_debug.put_line('line_internal_reference_6 ' || x_internal_reference_6);
327: asn_debug.put_line('line_advo_message_code ' || x_advo_message_code);

Line 324: asn_debug.put_line('line_internal_reference_4 ' || x_internal_reference_4);

320: asn_debug.put_line('line_external_reference_6 ' || x_external_reference_6);
321: asn_debug.put_line('line_internal_reference_1 ' || x_internal_reference_1);
322: asn_debug.put_line('line_internal_reference_2 ' || x_internal_reference_2);
323: asn_debug.put_line('line_internal_reference_3 ' || x_internal_reference_3);
324: asn_debug.put_line('line_internal_reference_4 ' || x_internal_reference_4);
325: asn_debug.put_line('line_internal_reference_5 ' || x_internal_reference_5);
326: asn_debug.put_line('line_internal_reference_6 ' || x_internal_reference_6);
327: asn_debug.put_line('line_advo_message_code ' || x_advo_message_code);
328: asn_debug.put_line('line_advo_message_desc ' || x_advo_message_desc);

Line 325: asn_debug.put_line('line_internal_reference_5 ' || x_internal_reference_5);

321: asn_debug.put_line('line_internal_reference_1 ' || x_internal_reference_1);
322: asn_debug.put_line('line_internal_reference_2 ' || x_internal_reference_2);
323: asn_debug.put_line('line_internal_reference_3 ' || x_internal_reference_3);
324: asn_debug.put_line('line_internal_reference_4 ' || x_internal_reference_4);
325: asn_debug.put_line('line_internal_reference_5 ' || x_internal_reference_5);
326: asn_debug.put_line('line_internal_reference_6 ' || x_internal_reference_6);
327: asn_debug.put_line('line_advo_message_code ' || x_advo_message_code);
328: asn_debug.put_line('line_advo_message_desc ' || x_advo_message_desc);
329: asn_debug.put_line('line_advo_data_bad ' || x_advo_data_bad);

Line 326: asn_debug.put_line('line_internal_reference_6 ' || x_internal_reference_6);

322: asn_debug.put_line('line_internal_reference_2 ' || x_internal_reference_2);
323: asn_debug.put_line('line_internal_reference_3 ' || x_internal_reference_3);
324: asn_debug.put_line('line_internal_reference_4 ' || x_internal_reference_4);
325: asn_debug.put_line('line_internal_reference_5 ' || x_internal_reference_5);
326: asn_debug.put_line('line_internal_reference_6 ' || x_internal_reference_6);
327: asn_debug.put_line('line_advo_message_code ' || x_advo_message_code);
328: asn_debug.put_line('line_advo_message_desc ' || x_advo_message_desc);
329: asn_debug.put_line('line_advo_data_bad ' || x_advo_data_bad);
330: asn_debug.put_line('line_advo_data_goog ' || x_advo_data_good);

Line 327: asn_debug.put_line('line_advo_message_code ' || x_advo_message_code);

323: asn_debug.put_line('line_internal_reference_3 ' || x_internal_reference_3);
324: asn_debug.put_line('line_internal_reference_4 ' || x_internal_reference_4);
325: asn_debug.put_line('line_internal_reference_5 ' || x_internal_reference_5);
326: asn_debug.put_line('line_internal_reference_6 ' || x_internal_reference_6);
327: asn_debug.put_line('line_advo_message_code ' || x_advo_message_code);
328: asn_debug.put_line('line_advo_message_desc ' || x_advo_message_desc);
329: asn_debug.put_line('line_advo_data_bad ' || x_advo_data_bad);
330: asn_debug.put_line('line_advo_data_goog ' || x_advo_data_good);
331:

Line 328: asn_debug.put_line('line_advo_message_desc ' || x_advo_message_desc);

324: asn_debug.put_line('line_internal_reference_4 ' || x_internal_reference_4);
325: asn_debug.put_line('line_internal_reference_5 ' || x_internal_reference_5);
326: asn_debug.put_line('line_internal_reference_6 ' || x_internal_reference_6);
327: asn_debug.put_line('line_advo_message_code ' || x_advo_message_code);
328: asn_debug.put_line('line_advo_message_desc ' || x_advo_message_desc);
329: asn_debug.put_line('line_advo_data_bad ' || x_advo_data_bad);
330: asn_debug.put_line('line_advo_data_goog ' || x_advo_data_good);
331:
332: EC_APPLICATION_ADVICE_PUB.create_advice_line (p_api_version_number => x_api_version_number,

Line 329: asn_debug.put_line('line_advo_data_bad ' || x_advo_data_bad);

325: asn_debug.put_line('line_internal_reference_5 ' || x_internal_reference_5);
326: asn_debug.put_line('line_internal_reference_6 ' || x_internal_reference_6);
327: asn_debug.put_line('line_advo_message_code ' || x_advo_message_code);
328: asn_debug.put_line('line_advo_message_desc ' || x_advo_message_desc);
329: asn_debug.put_line('line_advo_data_bad ' || x_advo_data_bad);
330: asn_debug.put_line('line_advo_data_goog ' || x_advo_data_good);
331:
332: EC_APPLICATION_ADVICE_PUB.create_advice_line (p_api_version_number => x_api_version_number,
333: p_return_status => x_return_status,

Line 330: asn_debug.put_line('line_advo_data_goog ' || x_advo_data_good);

326: asn_debug.put_line('line_internal_reference_6 ' || x_internal_reference_6);
327: asn_debug.put_line('line_advo_message_code ' || x_advo_message_code);
328: asn_debug.put_line('line_advo_message_desc ' || x_advo_message_desc);
329: asn_debug.put_line('line_advo_data_bad ' || x_advo_data_bad);
330: asn_debug.put_line('line_advo_data_goog ' || x_advo_data_good);
331:
332: EC_APPLICATION_ADVICE_PUB.create_advice_line (p_api_version_number => x_api_version_number,
333: p_return_status => x_return_status,
334: p_msg_count => x_msg_count,

Line 356: asn_debug.put_line('Return Status -- ' || x_return_status);

352: p_advo_message_desc => x_advo_message_desc,
353: p_advo_data_bad => x_advo_data_bad,
354: p_advo_data_good => x_advo_data_good);
355:
356: asn_debug.put_line('Return Status -- ' || x_return_status);
357: asn_debug.put_line('msg count -- ' || to_char(x_msg_count));
358: asn_debug.put_line('msg data -- ' || x_msg_data);
359: end loop;
360:

Line 357: asn_debug.put_line('msg count -- ' || to_char(x_msg_count));

353: p_advo_data_bad => x_advo_data_bad,
354: p_advo_data_good => x_advo_data_good);
355:
356: asn_debug.put_line('Return Status -- ' || x_return_status);
357: asn_debug.put_line('msg count -- ' || to_char(x_msg_count));
358: asn_debug.put_line('msg data -- ' || x_msg_data);
359: end loop;
360:
361: else

Line 358: asn_debug.put_line('msg data -- ' || x_msg_data);

354: p_advo_data_good => x_advo_data_good);
355:
356: asn_debug.put_line('Return Status -- ' || x_return_status);
357: asn_debug.put_line('msg count -- ' || to_char(x_msg_count));
358: asn_debug.put_line('msg data -- ' || x_msg_data);
359: end loop;
360:
361: else
362: for gler in get_line_error_rows loop

Line 407: asn_debug.put_line('Return Status ' || x_return_status);

403: p_advo_message_desc => x_advo_message_desc,
404: p_advo_data_bad => x_advo_data_bad,
405: p_advo_data_good => x_advo_data_good);
406:
407: asn_debug.put_line('Return Status ' || x_return_status);
408: asn_debug.put_line('msg count ' || to_char(x_msg_count));
409: asn_debug.put_line('msg data ' || x_msg_data);
410: end loop;
411: end if;

Line 408: asn_debug.put_line('msg count ' || to_char(x_msg_count));

404: p_advo_data_bad => x_advo_data_bad,
405: p_advo_data_good => x_advo_data_good);
406:
407: asn_debug.put_line('Return Status ' || x_return_status);
408: asn_debug.put_line('msg count ' || to_char(x_msg_count));
409: asn_debug.put_line('msg data ' || x_msg_data);
410: end loop;
411: end if;
412:

Line 409: asn_debug.put_line('msg data ' || x_msg_data);

405: p_advo_data_good => x_advo_data_good);
406:
407: asn_debug.put_line('Return Status ' || x_return_status);
408: asn_debug.put_line('msg count ' || to_char(x_msg_count));
409: asn_debug.put_line('msg data ' || x_msg_data);
410: end loop;
411: end if;
412:
413: EXCEPTION

Line 415: asn_debug.put_line('RCV_824_S.RCV_824_INSERT ' || sqlcode);

411: end if;
412:
413: EXCEPTION
414: WHEN others THEN
415: asn_debug.put_line('RCV_824_S.RCV_824_INSERT ' || sqlcode);
416: END RCV_824_INSERT;
417:
418: PROCEDURE rcv_824_insert(
419: x_interface_header IN rcv_shipment_header_sv.headerrectype,