DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_GRP dependencies on FND_MESSAGE

Line 160: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');

156: -- : Support FINAL_CLOSE submission checks
157: IF p_action_requested NOT IN
158: (g_action_DOC_SUBMISSION_CHECK, g_action_UNRESERVE, g_action_FINAL_CLOSE_CHECK)
159: THEN
160: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
161: FND_MESSAGE.set_token('ERROR_TEXT','Invalid Action Requested');
162: FND_MSG_PUB.Add;
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;

Line 161: FND_MESSAGE.set_token('ERROR_TEXT','Invalid Action Requested');

157: IF p_action_requested NOT IN
158: (g_action_DOC_SUBMISSION_CHECK, g_action_UNRESERVE, g_action_FINAL_CLOSE_CHECK)
159: THEN
160: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
161: FND_MESSAGE.set_token('ERROR_TEXT','Invalid Action Requested');
162: FND_MSG_PUB.Add;
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165:

Line 169: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');

165:
166: l_progress := '002';
167: --check p_document_type
168: IF p_document_type NOT IN ('REQUISITION', 'RELEASE', 'PO', 'PA') THEN
169: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
170: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document TYpe');
171: FND_MSG_PUB.Add;
172: RAISE FND_API.G_EXC_ERROR;
173: END IF;

Line 170: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document TYpe');

166: l_progress := '002';
167: --check p_document_type
168: IF p_document_type NOT IN ('REQUISITION', 'RELEASE', 'PO', 'PA') THEN
169: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
170: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document TYpe');
171: FND_MSG_PUB.Add;
172: RAISE FND_API.G_EXC_ERROR;
173: END IF;
174:

Line 180: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');

176:
177: --check that action requested matches
178: IF p_action_requested = g_action_UNRESERVE THEN
179: IF p_document_type NOT IN ('PO', 'RELEASE') THEN
180: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
181: FND_MESSAGE.set_token('ERROR_TEXT', 'UNRESERVE Action Requested for invalid document type');
182: FND_MSG_PUB.Add;
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;

Line 181: FND_MESSAGE.set_token('ERROR_TEXT', 'UNRESERVE Action Requested for invalid document type');

177: --check that action requested matches
178: IF p_action_requested = g_action_UNRESERVE THEN
179: IF p_document_type NOT IN ('PO', 'RELEASE') THEN
180: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
181: FND_MESSAGE.set_token('ERROR_TEXT', 'UNRESERVE Action Requested for invalid document type');
182: FND_MSG_PUB.Add;
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185: --

Line 188: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');

184: END IF;
185: --
186: ELSIF (p_action_requested = g_action_FINAL_CLOSE_CHECK) THEN
187: IF p_document_type NOT IN ('PO', 'PA', 'RELEASE') THEN
188: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
189: FND_MESSAGE.set_token('ERROR_TEXT', 'FINAL_CLOSE Action Requested for invalid document type');
190: FND_MSG_PUB.Add;
191: RAISE FND_API.G_EXC_ERROR;
192: END IF;

Line 189: FND_MESSAGE.set_token('ERROR_TEXT', 'FINAL_CLOSE Action Requested for invalid document type');

185: --
186: ELSIF (p_action_requested = g_action_FINAL_CLOSE_CHECK) THEN
187: IF p_document_type NOT IN ('PO', 'PA', 'RELEASE') THEN
188: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
189: FND_MESSAGE.set_token('ERROR_TEXT', 'FINAL_CLOSE Action Requested for invalid document type');
190: FND_MSG_PUB.Add;
191: RAISE FND_API.G_EXC_ERROR;
192: END IF;
193: --

Line 196: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');

192: END IF;
193: --
194: ELSE
195: IF p_document_level <> g_document_level_HEADER THEN
196: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
197: FND_MESSAGE.set_token('ERROR_TEXT', 'Non-Header level only supported for UNRESERVE action');
198: FND_MSG_PUB.Add;
199: RAISE FND_API.G_EXC_ERROR;
200: END IF;

Line 197: FND_MESSAGE.set_token('ERROR_TEXT', 'Non-Header level only supported for UNRESERVE action');

193: --
194: ELSE
195: IF p_document_level <> g_document_level_HEADER THEN
196: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
197: FND_MESSAGE.set_token('ERROR_TEXT', 'Non-Header level only supported for UNRESERVE action');
198: FND_MSG_PUB.Add;
199: RAISE FND_API.G_EXC_ERROR;
200: END IF;
201: END IF;

Line 207: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');

203: l_progress := '004';
204: --check that document_subtype matches
205: IF p_document_type = 'PO' THEN
206: IF p_document_subtype NOT IN ('STANDARD', 'PLANNED') THEN
207: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
208: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid document type for document type PO');
209: FND_MSG_PUB.Add;
210: RAISE FND_API.G_EXC_ERROR;
211: END IF;

Line 208: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid document type for document type PO');

204: --check that document_subtype matches
205: IF p_document_type = 'PO' THEN
206: IF p_document_subtype NOT IN ('STANDARD', 'PLANNED') THEN
207: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
208: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid document type for document type PO');
209: FND_MSG_PUB.Add;
210: RAISE FND_API.G_EXC_ERROR;
211: END IF;
212: ELSIF p_document_type = 'PA' THEN

Line 214: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');

210: RAISE FND_API.G_EXC_ERROR;
211: END IF;
212: ELSIF p_document_type = 'PA' THEN
213: IF p_document_subtype NOT IN ('BLANKET', 'CONTRACT') THEN
214: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
215: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid document type for document type PA');
216: FND_MSG_PUB.Add;
217: RAISE FND_API.G_EXC_ERROR;
218: END IF;

Line 215: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid document type for document type PA');

211: END IF;
212: ELSIF p_document_type = 'PA' THEN
213: IF p_document_subtype NOT IN ('BLANKET', 'CONTRACT') THEN
214: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
215: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid document type for document type PA');
216: FND_MSG_PUB.Add;
217: RAISE FND_API.G_EXC_ERROR;
218: END IF;
219: END IF;

Line 239: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');

235: FROM PO_HEADERS
236: WHERE po_header_id= l_document_id;
237: EXCEPTION
238: WHEN NO_DATA_FOUND THEN
239: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
240: FND_MESSAGE.set_token('ERROR_TEXT', 'Either Org Context is not set OR Doc_id does not exist');
241: FND_MSG_PUB.Add;
242: WHEN OTHERS THEN
243: RAISE;

Line 240: FND_MESSAGE.set_token('ERROR_TEXT', 'Either Org Context is not set OR Doc_id does not exist');

236: WHERE po_header_id= l_document_id;
237: EXCEPTION
238: WHEN NO_DATA_FOUND THEN
239: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
240: FND_MESSAGE.set_token('ERROR_TEXT', 'Either Org Context is not set OR Doc_id does not exist');
241: FND_MSG_PUB.Add;
242: WHEN OTHERS THEN
243: RAISE;
244: END;

Line 253: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');

249: FROM PO_REQUISITION_HEADERS
250: WHERE requisition_header_id= l_document_id;
251: EXCEPTION
252: WHEN NO_DATA_FOUND THEN
253: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
254: FND_MESSAGE.set_token('ERROR_TEXT', 'Either Org Context is not set OR Doc_id does not exist');
255: FND_MSG_PUB.Add;
256: WHEN OTHERS THEN
257: RAISE;

Line 254: FND_MESSAGE.set_token('ERROR_TEXT', 'Either Org Context is not set OR Doc_id does not exist');

250: WHERE requisition_header_id= l_document_id;
251: EXCEPTION
252: WHEN NO_DATA_FOUND THEN
253: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
254: FND_MESSAGE.set_token('ERROR_TEXT', 'Either Org Context is not set OR Doc_id does not exist');
255: FND_MSG_PUB.Add;
256: WHEN OTHERS THEN
257: RAISE;
258: END;

Line 269: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');

265: FROM PO_RELEASES
266: WHERE po_release_id= l_document_id;
267: EXCEPTION
268: WHEN NO_DATA_FOUND THEN
269: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
270: FND_MESSAGE.set_token('ERROR_TEXT', 'Either Org Context is not set OR Doc_id does not exist');
271: FND_MSG_PUB.Add;
272: WHEN OTHERS THEN
273: RAISE;

Line 270: FND_MESSAGE.set_token('ERROR_TEXT', 'Either Org Context is not set OR Doc_id does not exist');

266: WHERE po_release_id= l_document_id;
267: EXCEPTION
268: WHEN NO_DATA_FOUND THEN
269: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
270: FND_MESSAGE.set_token('ERROR_TEXT', 'Either Org Context is not set OR Doc_id does not exist');
271: FND_MSG_PUB.Add;
272: WHEN OTHERS THEN
273: RAISE;
274: END;

Line 799: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');

795: IF ((p_query_table is NULL) OR (p_owner_id_column is NULL) OR
796: (p_employee_id IS NULL) OR
797: (p_minimum_access_level IS NULL) OR (p_document_type is NULL) OR
798: (p_document_subtype is NULL) OR (p_type_clause is NULL)) THEN
799: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
800: FND_MESSAGE.set_token('ERROR_TEXT', 'Mandatory parameters are NULL');
801: FND_MSG_PUB.Add;
802: RAISE FND_API.G_EXC_ERROR;
803: END IF; /*(p_query_table is NULL) OR (p_owner_id_column is NULL)*/

Line 800: FND_MESSAGE.set_token('ERROR_TEXT', 'Mandatory parameters are NULL');

796: (p_employee_id IS NULL) OR
797: (p_minimum_access_level IS NULL) OR (p_document_type is NULL) OR
798: (p_document_subtype is NULL) OR (p_type_clause is NULL)) THEN
799: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
800: FND_MESSAGE.set_token('ERROR_TEXT', 'Mandatory parameters are NULL');
801: FND_MSG_PUB.Add;
802: RAISE FND_API.G_EXC_ERROR;
803: END IF; /*(p_query_table is NULL) OR (p_owner_id_column is NULL)*/
804:

Line 808: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');

804:
805: l_progress := '020';
806: --Check p_minimum_access_level
807: IF p_minimum_access_level NOT IN ('VIEW_ONLY', 'MODIFY', 'FULL') THEN
808: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
809: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Minimum Access Level');
810: FND_MSG_PUB.Add;
811: RAISE FND_API.G_EXC_ERROR;
812: END IF; /*p_minimum_access_level NOT IN ('VIEW_ONLY', 'MODIFY', 'ALL')*/

Line 809: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Minimum Access Level');

805: l_progress := '020';
806: --Check p_minimum_access_level
807: IF p_minimum_access_level NOT IN ('VIEW_ONLY', 'MODIFY', 'FULL') THEN
808: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
809: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Minimum Access Level');
810: FND_MSG_PUB.Add;
811: RAISE FND_API.G_EXC_ERROR;
812: END IF; /*p_minimum_access_level NOT IN ('VIEW_ONLY', 'MODIFY', 'ALL')*/
813:

Line 819: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');

815: --check p_document_type
816: -- Bug 5054685: Added 'PO_PA' as additional check
817: IF p_document_type NOT IN ('RFQ', 'QUOTATION', 'REQUISITION',
818: 'RELEASE', 'PO', 'PA', 'PO_PA') THEN
819: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
820: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Type');
821: FND_MSG_PUB.Add;
822: RAISE FND_API.G_EXC_ERROR;
823: END IF; /*p_document_type NOT IN ('RFQ', 'QUOTATION', 'REQUISITION',*/

Line 820: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Type');

816: -- Bug 5054685: Added 'PO_PA' as additional check
817: IF p_document_type NOT IN ('RFQ', 'QUOTATION', 'REQUISITION',
818: 'RELEASE', 'PO', 'PA', 'PO_PA') THEN
819: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
820: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Type');
821: FND_MSG_PUB.Add;
822: RAISE FND_API.G_EXC_ERROR;
823: END IF; /*p_document_type NOT IN ('RFQ', 'QUOTATION', 'REQUISITION',*/
824:

Line 829: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');

825: l_progress := '040';
826: --check that document_subtype matches
827: IF p_document_type = 'REQUISITION' THEN
828: IF p_document_subtype NOT IN ('PURCHASE', 'INTERNAL') THEN
829: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
830: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');
831: FND_MSG_PUB.Add;
832: RAISE FND_API.G_EXC_ERROR;
833: END IF;

Line 830: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');

826: --check that document_subtype matches
827: IF p_document_type = 'REQUISITION' THEN
828: IF p_document_subtype NOT IN ('PURCHASE', 'INTERNAL') THEN
829: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
830: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');
831: FND_MSG_PUB.Add;
832: RAISE FND_API.G_EXC_ERROR;
833: END IF;
834: ELSIF p_document_type = 'RELEASE' THEN

Line 836: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');

832: RAISE FND_API.G_EXC_ERROR;
833: END IF;
834: ELSIF p_document_type = 'RELEASE' THEN
835: IF p_document_subtype NOT IN ('SCHEDULED', 'BLANKET') THEN
836: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
837: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');
838: FND_MSG_PUB.Add;
839: RAISE FND_API.G_EXC_ERROR;
840: END IF;

Line 837: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');

833: END IF;
834: ELSIF p_document_type = 'RELEASE' THEN
835: IF p_document_subtype NOT IN ('SCHEDULED', 'BLANKET') THEN
836: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
837: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');
838: FND_MSG_PUB.Add;
839: RAISE FND_API.G_EXC_ERROR;
840: END IF;
841: ELSIF p_document_type = 'PO' THEN

Line 843: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');

839: RAISE FND_API.G_EXC_ERROR;
840: END IF;
841: ELSIF p_document_type = 'PO' THEN
842: IF p_document_subtype NOT IN ('STANDARD', 'PLANNED') THEN
843: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
844: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');
845: FND_MSG_PUB.Add;
846: RAISE FND_API.G_EXC_ERROR;
847: END IF;

Line 844: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');

840: END IF;
841: ELSIF p_document_type = 'PO' THEN
842: IF p_document_subtype NOT IN ('STANDARD', 'PLANNED') THEN
843: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
844: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');
845: FND_MSG_PUB.Add;
846: RAISE FND_API.G_EXC_ERROR;
847: END IF;
848: ELSIF p_document_type = 'PA' THEN

Line 850: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');

846: RAISE FND_API.G_EXC_ERROR;
847: END IF;
848: ELSIF p_document_type = 'PA' THEN
849: IF p_document_subtype NOT IN ('BLANKET', 'CONTRACT') THEN
850: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
851: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');
852: FND_MSG_PUB.Add;
853: RAISE FND_API.G_EXC_ERROR;
854: END IF;

Line 851: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');

847: END IF;
848: ELSIF p_document_type = 'PA' THEN
849: IF p_document_subtype NOT IN ('BLANKET', 'CONTRACT') THEN
850: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
851: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');
852: FND_MSG_PUB.Add;
853: RAISE FND_API.G_EXC_ERROR;
854: END IF;
855: -- Bug 5054685 Start: Performance issue. Collapsed multiple security

Line 859: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');

855: -- Bug 5054685 Start: Performance issue. Collapsed multiple security
856: -- related where-clauses into one.
857: ELSIF p_document_type = 'PO_PA' THEN
858: IF p_document_subtype NOT IN ('ALL') THEN
859: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
860: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');
861: FND_MSG_PUB.Add;
862: RAISE FND_API.G_EXC_ERROR;
863: END IF;

Line 860: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');

856: -- related where-clauses into one.
857: ELSIF p_document_type = 'PO_PA' THEN
858: IF p_document_subtype NOT IN ('ALL') THEN
859: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
860: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');
861: FND_MSG_PUB.Add;
862: RAISE FND_API.G_EXC_ERROR;
863: END IF;
864: -- Bug 5054685 End

Line 983: FND_MESSAGE.set_name('PO', 'PO_STATCHK_ERR_NULL_INPARAM');

979: l_count := p_document_subtype.COUNT;
980: ELSIF p_vendor_order_num IS NOT NULL THEN
981: l_count := p_vendor_order_num.COUNT;
982: ELSE -- The required input table ID parameters are all null !
983: FND_MESSAGE.set_name('PO', 'PO_STATCHK_ERR_NULL_INPARAM');
984: FND_MSG_PUB.Add;
985: RAISE FND_API.G_EXC_ERROR;
986: END IF;
987:

Line 1031: FND_MESSAGE.set_name('PO', 'PO_STATCHK_GENERAL_ERROR');

1027: OR l_count <> p_line_id.count
1028: OR l_count <> p_line_location_id.count
1029: OR l_count <> p_distribution_id.count THEN
1030:
1031: FND_MESSAGE.set_name('PO', 'PO_STATCHK_GENERAL_ERROR');
1032: FND_MESSAGE.set_token('ERROR_TEXT', 'The input table ID parameters are not of same size !');
1033: FND_MSG_PUB.Add;
1034: RAISE FND_API.G_EXC_ERROR;
1035: END IF;

Line 1032: FND_MESSAGE.set_token('ERROR_TEXT', 'The input table ID parameters are not of same size !');

1028: OR l_count <> p_line_location_id.count
1029: OR l_count <> p_distribution_id.count THEN
1030:
1031: FND_MESSAGE.set_name('PO', 'PO_STATCHK_GENERAL_ERROR');
1032: FND_MESSAGE.set_token('ERROR_TEXT', 'The input table ID parameters are not of same size !');
1033: FND_MSG_PUB.Add;
1034: RAISE FND_API.G_EXC_ERROR;
1035: END IF;
1036:

Line 1047: FND_MESSAGE.set_name('PO', 'PO_STATCHK_GENERAL_ERROR');

1043: --bug 4931241 - p_vendor_order_num and p_document_num/p_document_subtype don't
1044: --uniquely identify a document. Hence we have to rely on p_header_id or p_release_id
1045: IF (p_header_id(i) IS NULL) AND (p_release_id(i) IS NULL) THEN
1046: -- Means that no Header/Release is specified
1047: FND_MESSAGE.set_name('PO', 'PO_STATCHK_GENERAL_ERROR');
1048: FND_MESSAGE.set_token('ERROR_TEXT', 'There is no Header/Release specified at index ' || i);
1049: FND_MSG_PUB.Add;
1050: RAISE FND_API.G_EXC_ERROR;
1051: END IF;

Line 1048: FND_MESSAGE.set_token('ERROR_TEXT', 'There is no Header/Release specified at index ' || i);

1044: --uniquely identify a document. Hence we have to rely on p_header_id or p_release_id
1045: IF (p_header_id(i) IS NULL) AND (p_release_id(i) IS NULL) THEN
1046: -- Means that no Header/Release is specified
1047: FND_MESSAGE.set_name('PO', 'PO_STATCHK_GENERAL_ERROR');
1048: FND_MESSAGE.set_token('ERROR_TEXT', 'There is no Header/Release specified at index ' || i);
1049: FND_MSG_PUB.Add;
1050: RAISE FND_API.G_EXC_ERROR;
1051: END IF;
1052:

Line 1419: FND_MESSAGE.set_name('PO','PO_RETRO_PRICING_NOT_ALLOWED');

1415: x_price_updateable := PO_CORE_S.G_PARAMETER_NO;
1416: x_retroactive_price_change := PO_CORE_S.G_PARAMETER_NO;
1417:
1418: IF (p_add_reasons_to_msg_list = PO_CORE_S.G_PARAMETER_YES) THEN
1419: FND_MESSAGE.set_name('PO','PO_RETRO_PRICING_NOT_ALLOWED');
1420: FND_MSG_PUB.add;
1421: END IF;
1422: END IF;
1423:

Line 1437: FND_MESSAGE.set_name('PO','PO_CHNG_PRICE_RESTRICTED');

1433:
1434: IF (l_accrue_invoice_count > 0) THEN
1435: x_price_updateable := PO_CORE_S.G_PARAMETER_NO;
1436: IF (p_add_reasons_to_msg_list = PO_CORE_S.G_PARAMETER_YES) THEN
1437: FND_MESSAGE.set_name('PO','PO_CHNG_PRICE_RESTRICTED');
1438: FND_MSG_PUB.add;
1439: END IF;
1440: END IF;
1441: END IF; -- if retro mode is all_releases

Line 1455: FND_MESSAGE.set_name('PO','PO_CHNG_GA_NO_PRICE_OVERRIDE');

1451: = PO_CORE_S.G_PARAMETER_NO)
1452: AND (l_allow_price_override = 'N') THEN
1453: x_price_updateable := PO_CORE_S.G_PARAMETER_NO;
1454: IF (p_add_reasons_to_msg_list = PO_CORE_S.G_PARAMETER_YES) THEN
1455: FND_MESSAGE.set_name('PO','PO_CHNG_GA_NO_PRICE_OVERRIDE');
1456: FND_MSG_PUB.add;
1457: END IF;
1458: END IF; -- l_has_ga_ref
1459:

Line 1481: FND_MESSAGE.set_name('PO','PO_CHNG_PRICE_RESTRICTED');

1477:
1478: IF (l_accrue_invoice_count > 0) THEN
1479: x_price_updateable := PO_CORE_S.G_PARAMETER_NO;
1480: IF (p_add_reasons_to_msg_list = PO_CORE_S.G_PARAMETER_YES) THEN
1481: FND_MESSAGE.set_name('PO','PO_CHNG_PRICE_RESTRICTED');
1482: FND_MSG_PUB.add;
1483: END IF;
1484: END IF;
1485: END IF; -- IF (l_is_financing_po) THEN

Line 1511: FND_MESSAGE.set_name('PO','PO_RCV_TRANSACTION_PENDING');

1507:
1508: IF (l_pending_rcv_transactions > 0) THEN
1509: x_price_updateable := PO_CORE_S.G_PARAMETER_NO;
1510: IF (p_add_reasons_to_msg_list = PO_CORE_S.G_PARAMETER_YES) THEN
1511: FND_MESSAGE.set_name('PO','PO_RCV_TRANSACTION_PENDING');
1512: FND_MSG_PUB.add;
1513: END IF;
1514: END IF;
1515:

Line 1678: FND_MESSAGE.set_name('PO','PO_RETRO_PRICING_NOT_ALLOWED');

1674: x_price_updateable := PO_CORE_S.G_PARAMETER_NO;
1675: x_retroactive_price_change := PO_CORE_S.G_PARAMETER_NO;
1676:
1677: IF (p_add_reasons_to_msg_list = PO_CORE_S.G_PARAMETER_YES) THEN
1678: FND_MESSAGE.set_name('PO','PO_RETRO_PRICING_NOT_ALLOWED');
1679: FND_MSG_PUB.add;
1680: END IF;
1681: END IF;
1682:

Line 1688: FND_MESSAGE.set_name('PO','PO_CHNG_PRICE_RESTRICTED');

1684: IF ((l_qty_received > 0) AND (l_accrue_flag = 'Y'))
1685: OR (l_qty_billed > 0) THEN
1686: x_price_updateable := PO_CORE_S.G_PARAMETER_NO;
1687: IF (p_add_reasons_to_msg_list = PO_CORE_S.G_PARAMETER_YES) THEN
1688: FND_MESSAGE.set_name('PO','PO_CHNG_PRICE_RESTRICTED');
1689: FND_MSG_PUB.add;
1690: END IF;
1691: END IF;
1692: END IF; -- g_retropricing_mode

Line 1704: FND_MESSAGE.set_name('PO','PO_CHNG_NO_PRICE_OVERRIDE');

1700: = PO_CORE_S.G_PARAMETER_NO)
1701: AND (l_allow_price_override = 'N') THEN
1702: x_price_updateable := PO_CORE_S.G_PARAMETER_NO;
1703: IF (p_add_reasons_to_msg_list = PO_CORE_S.G_PARAMETER_YES) THEN
1704: FND_MESSAGE.set_name('PO','PO_CHNG_NO_PRICE_OVERRIDE');
1705: FND_MSG_PUB.add;
1706: END IF;
1707: END IF;
1708:

Line 1730: FND_MESSAGE.set_name('PO','PO_RCV_TRANSACTION_PENDING');

1726:
1727: IF (l_pending_rcv_transactions > 0) THEN
1728: x_price_updateable := PO_CORE_S.G_PARAMETER_NO;
1729: IF (p_add_reasons_to_msg_list = PO_CORE_S.G_PARAMETER_YES) THEN
1730: FND_MESSAGE.set_name('PO','PO_RCV_TRANSACTION_PENDING');
1731: FND_MSG_PUB.add;
1732: END IF;
1733: END IF;
1734: