APPS.PO_VENDOR_SITES_SV dependencies on PO_MESSAGE_S

Line 140: po_message_s.sql_error('PO_VENDOR_SITES_SV.val_vendor_site',l_progress,sqlcode);

136:
137: when no_data_found then
138: return (FALSE);
139: when others then
140: po_message_s.sql_error('PO_VENDOR_SITES_SV.val_vendor_site',l_progress,sqlcode);
141: raise;
142:
143: END val_vendor_site_id;
144:

Line 225: po_message_s.sql_error('get_def_vendor_site', X_progress, sqlcode);

221: X_vendor_site_id := '';
222: X_vendor_site_code := '';
223:
224: WHEN OTHERS THEN
225: po_message_s.sql_error('get_def_vendor_site', X_progress, sqlcode);
226: raise;
227:
228: END get_def_vendor_site;
229:

Line 300: po_message_s.sql_error('get_vendor_site_info', X_progress, sqlcode);

296: end if;
297:
298: exception
299: when others then
300: po_message_s.sql_error('get_vendor_site_info', X_progress, sqlcode);
301: raise;
302:
303: END get_vendor_site_info;
304:

Line 556: po_message_s.sql_error('val_vendor_site', X_progress, sqlcode);

552: X_vendor_contact_name);
553:
554: exception
555: when others then
556: po_message_s.sql_error('val_vendor_site', X_progress, sqlcode);
557: raise;
558:
559: END val_vendor_site;
560:

Line 603: po_message_s.sql_error('get_vendor_site_name', X_progress, sqlcode);

599:
600: EXCEPTION
601: when others then
602: --dbms_output.put_line('In exception');
603: po_message_s.sql_error('get_vendor_site_name', X_progress, sqlcode);
604:
605: END get_vendor_site_name;
606:
607: /*===================================================================

Line 1094: po_message_s.sql_error('Get_Transmission_Defaults',

1090: FROM po_headers_all poh
1091: WHERE poh.po_header_id = p_document_id;
1092: exception
1093: when others then
1094: po_message_s.sql_error('Get_Transmission_Defaults',
1095: l_progress, sqlcode);
1096: raise;
1097: end;
1098: /* Bug 7232666, get approved_date from po_releases_all */

Line 1121: po_message_s.sql_error('Get_Transmission_Defaults',

1117: where por.po_release_id = p_document_id and
1118: poh.po_header_id = por.po_header_id ;
1119: exception
1120: when others then
1121: po_message_s.sql_error('Get_Transmission_Defaults',
1122: l_progress, sqlcode);
1123: end;
1124: end if; /*If ((p_document_type = 'PO') OR (p_document_type = 'PA'))*/
1125:

Line 1256: po_message_s.sql_error('Get_Transmission_Defaults',

1252: x_default_method := null;
1253: END IF;
1254: exception
1255: when others then
1256: po_message_s.sql_error('Get_Transmission_Defaults',
1257: l_progress, sqlcode);
1258: raise;
1259: end;
1260:

Line 1291: po_message_s.sql_error('Get_Transmission_Defaults',

1287: por.po_release_id = p_document_id and
1288: pvs.vendor_site_id = NVL(pvc.vendor_site_id, pvs.vendor_site_id);
1289: exception
1290: when others then
1291: po_message_s.sql_error('Get_Transmission_Defaults',
1292: l_progress, sqlcode);
1293: raise;
1294: end;
1295:

Line 1308: po_message_s.sql_error('Get_Transmission_Defaults',

1304: end if; /* x_default_method is null */
1305:
1306: EXCEPTION
1307: when others then
1308: po_message_s.sql_error('Get_Transmission_Defaults',
1309: l_progress, sqlcode);
1310: raise;
1311:
1312: END Get_Transmission_Defaults;