DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_GRP dependencies on FND_MESSAGE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

785: IF ((p_query_table is NULL) OR (p_owner_id_column is NULL) OR
786: (p_employee_id IS NULL) OR
787: (p_minimum_access_level IS NULL) OR (p_document_type is NULL) OR
788: (p_document_subtype is NULL) OR (p_type_clause is NULL)) THEN
789: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
790: FND_MESSAGE.set_token('ERROR_TEXT', 'Mandatory parameters are NULL');
791: FND_MSG_PUB.Add;
792: RAISE FND_API.G_EXC_ERROR;
793: END IF; /*(p_query_table is NULL) OR (p_owner_id_column is NULL)*/

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

786: (p_employee_id IS NULL) OR
787: (p_minimum_access_level IS NULL) OR (p_document_type is NULL) OR
788: (p_document_subtype is NULL) OR (p_type_clause is NULL)) THEN
789: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
790: FND_MESSAGE.set_token('ERROR_TEXT', 'Mandatory parameters are NULL');
791: FND_MSG_PUB.Add;
792: RAISE FND_API.G_EXC_ERROR;
793: END IF; /*(p_query_table is NULL) OR (p_owner_id_column is NULL)*/
794:

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

794:
795: l_progress := '020';
796: --Check p_minimum_access_level
797: IF p_minimum_access_level NOT IN ('VIEW_ONLY', 'MODIFY', 'FULL') THEN
798: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
799: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Minimum Access Level');
800: FND_MSG_PUB.Add;
801: RAISE FND_API.G_EXC_ERROR;
802: END IF; /*p_minimum_access_level NOT IN ('VIEW_ONLY', 'MODIFY', 'ALL')*/

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

795: l_progress := '020';
796: --Check p_minimum_access_level
797: IF p_minimum_access_level NOT IN ('VIEW_ONLY', 'MODIFY', 'FULL') THEN
798: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
799: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Minimum Access Level');
800: FND_MSG_PUB.Add;
801: RAISE FND_API.G_EXC_ERROR;
802: END IF; /*p_minimum_access_level NOT IN ('VIEW_ONLY', 'MODIFY', 'ALL')*/
803:

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

805: --check p_document_type
806: -- Bug 5054685: Added 'PO_PA' as additional check
807: IF p_document_type NOT IN ('RFQ', 'QUOTATION', 'REQUISITION',
808: 'RELEASE', 'PO', 'PA', 'PO_PA') THEN
809: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
810: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Type');
811: FND_MSG_PUB.Add;
812: RAISE FND_API.G_EXC_ERROR;
813: END IF; /*p_document_type NOT IN ('RFQ', 'QUOTATION', 'REQUISITION',*/

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

806: -- Bug 5054685: Added 'PO_PA' as additional check
807: IF p_document_type NOT IN ('RFQ', 'QUOTATION', 'REQUISITION',
808: 'RELEASE', 'PO', 'PA', 'PO_PA') THEN
809: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
810: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Type');
811: FND_MSG_PUB.Add;
812: RAISE FND_API.G_EXC_ERROR;
813: END IF; /*p_document_type NOT IN ('RFQ', 'QUOTATION', 'REQUISITION',*/
814:

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

815: l_progress := '040';
816: --check that document_subtype matches
817: IF p_document_type = 'REQUISITION' THEN
818: IF p_document_subtype NOT IN ('PURCHASE', 'INTERNAL') THEN
819: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
820: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');
821: FND_MSG_PUB.Add;
822: RAISE FND_API.G_EXC_ERROR;
823: END IF;

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

816: --check that document_subtype matches
817: IF p_document_type = 'REQUISITION' THEN
818: IF p_document_subtype NOT IN ('PURCHASE', 'INTERNAL') THEN
819: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
820: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');
821: FND_MSG_PUB.Add;
822: RAISE FND_API.G_EXC_ERROR;
823: END IF;
824: ELSIF p_document_type = 'RELEASE' THEN

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

822: RAISE FND_API.G_EXC_ERROR;
823: END IF;
824: ELSIF p_document_type = 'RELEASE' THEN
825: IF p_document_subtype NOT IN ('SCHEDULED', 'BLANKET') THEN
826: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
827: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');
828: FND_MSG_PUB.Add;
829: RAISE FND_API.G_EXC_ERROR;
830: END IF;

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

823: END IF;
824: ELSIF p_document_type = 'RELEASE' THEN
825: IF p_document_subtype NOT IN ('SCHEDULED', 'BLANKET') THEN
826: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
827: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');
828: FND_MSG_PUB.Add;
829: RAISE FND_API.G_EXC_ERROR;
830: END IF;
831: ELSIF p_document_type = 'PO' THEN

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

829: RAISE FND_API.G_EXC_ERROR;
830: END IF;
831: ELSIF p_document_type = 'PO' THEN
832: IF p_document_subtype NOT IN ('STANDARD', 'PLANNED') THEN
833: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
834: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');
835: FND_MSG_PUB.Add;
836: RAISE FND_API.G_EXC_ERROR;
837: END IF;

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

830: END IF;
831: ELSIF p_document_type = 'PO' THEN
832: IF p_document_subtype NOT IN ('STANDARD', 'PLANNED') THEN
833: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
834: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');
835: FND_MSG_PUB.Add;
836: RAISE FND_API.G_EXC_ERROR;
837: END IF;
838: ELSIF p_document_type = 'PA' THEN

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

836: RAISE FND_API.G_EXC_ERROR;
837: END IF;
838: ELSIF p_document_type = 'PA' THEN
839: IF p_document_subtype NOT IN ('BLANKET', 'CONTRACT') THEN
840: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
841: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');
842: FND_MSG_PUB.Add;
843: RAISE FND_API.G_EXC_ERROR;
844: END IF;

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

837: END IF;
838: ELSIF p_document_type = 'PA' THEN
839: IF p_document_subtype NOT IN ('BLANKET', 'CONTRACT') THEN
840: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
841: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');
842: FND_MSG_PUB.Add;
843: RAISE FND_API.G_EXC_ERROR;
844: END IF;
845: -- Bug 5054685 Start: Performance issue. Collapsed multiple security

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

845: -- Bug 5054685 Start: Performance issue. Collapsed multiple security
846: -- related where-clauses into one.
847: ELSIF p_document_type = 'PO_PA' THEN
848: IF p_document_subtype NOT IN ('ALL') THEN
849: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
850: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');
851: FND_MSG_PUB.Add;
852: RAISE FND_API.G_EXC_ERROR;
853: END IF;

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

846: -- related where-clauses into one.
847: ELSIF p_document_type = 'PO_PA' THEN
848: IF p_document_subtype NOT IN ('ALL') THEN
849: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
850: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');
851: FND_MSG_PUB.Add;
852: RAISE FND_API.G_EXC_ERROR;
853: END IF;
854: -- Bug 5054685 End

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

969: l_count := p_document_subtype.COUNT;
970: ELSIF p_vendor_order_num IS NOT NULL THEN
971: l_count := p_vendor_order_num.COUNT;
972: ELSE -- The required input table ID parameters are all null !
973: FND_MESSAGE.set_name('PO', 'PO_STATCHK_ERR_NULL_INPARAM');
974: FND_MSG_PUB.Add;
975: RAISE FND_API.G_EXC_ERROR;
976: END IF;
977:

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

1017: OR l_count <> p_line_id.count
1018: OR l_count <> p_line_location_id.count
1019: OR l_count <> p_distribution_id.count THEN
1020:
1021: FND_MESSAGE.set_name('PO', 'PO_STATCHK_GENERAL_ERROR');
1022: FND_MESSAGE.set_token('ERROR_TEXT', 'The input table ID parameters are not of same size !');
1023: FND_MSG_PUB.Add;
1024: RAISE FND_API.G_EXC_ERROR;
1025: END IF;

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

1018: OR l_count <> p_line_location_id.count
1019: OR l_count <> p_distribution_id.count THEN
1020:
1021: FND_MESSAGE.set_name('PO', 'PO_STATCHK_GENERAL_ERROR');
1022: FND_MESSAGE.set_token('ERROR_TEXT', 'The input table ID parameters are not of same size !');
1023: FND_MSG_PUB.Add;
1024: RAISE FND_API.G_EXC_ERROR;
1025: END IF;
1026:

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

1033: --bug 4931241 - p_vendor_order_num and p_document_num/p_document_subtype don't
1034: --uniquely identify a document. Hence we have to rely on p_header_id or p_release_id
1035: IF (p_header_id(i) IS NULL) AND (p_release_id(i) IS NULL) THEN
1036: -- Means that no Header/Release is specified
1037: FND_MESSAGE.set_name('PO', 'PO_STATCHK_GENERAL_ERROR');
1038: FND_MESSAGE.set_token('ERROR_TEXT', 'There is no Header/Release specified at index ' || i);
1039: FND_MSG_PUB.Add;
1040: RAISE FND_API.G_EXC_ERROR;
1041: END IF;

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

1034: --uniquely identify a document. Hence we have to rely on p_header_id or p_release_id
1035: IF (p_header_id(i) IS NULL) AND (p_release_id(i) IS NULL) THEN
1036: -- Means that no Header/Release is specified
1037: FND_MESSAGE.set_name('PO', 'PO_STATCHK_GENERAL_ERROR');
1038: FND_MESSAGE.set_token('ERROR_TEXT', 'There is no Header/Release specified at index ' || i);
1039: FND_MSG_PUB.Add;
1040: RAISE FND_API.G_EXC_ERROR;
1041: END IF;
1042:

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

1405: x_price_updateable := PO_CORE_S.G_PARAMETER_NO;
1406: x_retroactive_price_change := PO_CORE_S.G_PARAMETER_NO;
1407:
1408: IF (p_add_reasons_to_msg_list = PO_CORE_S.G_PARAMETER_YES) THEN
1409: FND_MESSAGE.set_name('PO','PO_RETRO_PRICING_NOT_ALLOWED');
1410: FND_MSG_PUB.add;
1411: END IF;
1412: END IF;
1413:

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

1423:
1424: IF (l_accrue_invoice_count > 0) THEN
1425: x_price_updateable := PO_CORE_S.G_PARAMETER_NO;
1426: IF (p_add_reasons_to_msg_list = PO_CORE_S.G_PARAMETER_YES) THEN
1427: FND_MESSAGE.set_name('PO','PO_CHNG_PRICE_RESTRICTED');
1428: FND_MSG_PUB.add;
1429: END IF;
1430: END IF;
1431: END IF; -- if retro mode is all_releases

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

1441: = PO_CORE_S.G_PARAMETER_NO)
1442: AND (l_allow_price_override = 'N') THEN
1443: x_price_updateable := PO_CORE_S.G_PARAMETER_NO;
1444: IF (p_add_reasons_to_msg_list = PO_CORE_S.G_PARAMETER_YES) THEN
1445: FND_MESSAGE.set_name('PO','PO_CHNG_GA_NO_PRICE_OVERRIDE');
1446: FND_MSG_PUB.add;
1447: END IF;
1448: END IF; -- l_has_ga_ref
1449:

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

1467:
1468: IF (l_accrue_invoice_count > 0) THEN
1469: x_price_updateable := PO_CORE_S.G_PARAMETER_NO;
1470: IF (p_add_reasons_to_msg_list = PO_CORE_S.G_PARAMETER_YES) THEN
1471: FND_MESSAGE.set_name('PO','PO_CHNG_PRICE_RESTRICTED');
1472: FND_MSG_PUB.add;
1473: END IF;
1474: END IF;
1475: END IF; -- IF (l_is_financing_po) THEN

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

1497:
1498: IF (l_pending_rcv_transactions > 0) THEN
1499: x_price_updateable := PO_CORE_S.G_PARAMETER_NO;
1500: IF (p_add_reasons_to_msg_list = PO_CORE_S.G_PARAMETER_YES) THEN
1501: FND_MESSAGE.set_name('PO','PO_RCV_TRANSACTION_PENDING');
1502: FND_MSG_PUB.add;
1503: END IF;
1504: END IF;
1505:

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

1664: x_price_updateable := PO_CORE_S.G_PARAMETER_NO;
1665: x_retroactive_price_change := PO_CORE_S.G_PARAMETER_NO;
1666:
1667: IF (p_add_reasons_to_msg_list = PO_CORE_S.G_PARAMETER_YES) THEN
1668: FND_MESSAGE.set_name('PO','PO_RETRO_PRICING_NOT_ALLOWED');
1669: FND_MSG_PUB.add;
1670: END IF;
1671: END IF;
1672:

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

1674: IF ((l_qty_received > 0) AND (l_accrue_flag = 'Y'))
1675: OR (l_qty_billed > 0) THEN
1676: x_price_updateable := PO_CORE_S.G_PARAMETER_NO;
1677: IF (p_add_reasons_to_msg_list = PO_CORE_S.G_PARAMETER_YES) THEN
1678: FND_MESSAGE.set_name('PO','PO_CHNG_PRICE_RESTRICTED');
1679: FND_MSG_PUB.add;
1680: END IF;
1681: END IF;
1682: END IF; -- g_retropricing_mode

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

1690: = PO_CORE_S.G_PARAMETER_NO)
1691: AND (l_allow_price_override = 'N') THEN
1692: x_price_updateable := PO_CORE_S.G_PARAMETER_NO;
1693: IF (p_add_reasons_to_msg_list = PO_CORE_S.G_PARAMETER_YES) THEN
1694: FND_MESSAGE.set_name('PO','PO_CHNG_NO_PRICE_OVERRIDE');
1695: FND_MSG_PUB.add;
1696: END IF;
1697: END IF;
1698:

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

1716:
1717: IF (l_pending_rcv_transactions > 0) THEN
1718: x_price_updateable := PO_CORE_S.G_PARAMETER_NO;
1719: IF (p_add_reasons_to_msg_list = PO_CORE_S.G_PARAMETER_YES) THEN
1720: FND_MESSAGE.set_name('PO','PO_RCV_TRANSACTION_PENDING');
1721: FND_MSG_PUB.add;
1722: END IF;
1723: END IF;
1724: