[Home] [Help]
755: --
756: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
757: LOG_MESSAGE('copy_negotiation','Initializing the FND_MSG_PUB stack');
758: FND_MSG_PUB.INITIALIZE;
759: LOG_MESSAGE('copy_negotiation','Clearing the FND_MESSAGE stack');
760: FND_MESSAGE.CLEAR;
761: END IF;
762:
763: --
756: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
757: LOG_MESSAGE('copy_negotiation','Initializing the FND_MSG_PUB stack');
758: FND_MSG_PUB.INITIALIZE;
759: LOG_MESSAGE('copy_negotiation','Clearing the FND_MESSAGE stack');
760: FND_MESSAGE.CLEAR;
761: END IF;
762:
763: --
764: -- Initialize APIto return the status as success initially
794: EXCEPTION
795: WHEN NO_DATA_FOUND THEN
796: -- The way I am adding this error may get changed in the future.
797: -- So, please be aware of that
798: FND_MESSAGE.SET_NAME('PON','PON_INVALID_TP_CONTACT_ID');
799: FND_MSG_PUB.ADD;
800: RAISE FND_API.G_EXC_ERROR;
801: END;
802: --
812: EXCEPTION
813: WHEN NO_DATA_FOUND THEN
814: -- The way I am adding this error may get changed in the future.
815: -- So, please be aware of that
816: FND_MESSAGE.SET_NAME('PON','PON_INVALID_TP_ID');
817: FND_MSG_PUB.ADD;
818: RAISE FND_API.G_EXC_ERROR;
819: END;
820:
848:
849: -- The way I am adding this error may get changed in the
850: -- future.
851: -- So, please be aware of that
852: FND_MESSAGE.SET_NAME('PON','PON_INV_COPY_OPTION');
853: FND_MSG_PUB.ADD;
854: RAISE FND_API.G_EXC_ERROR;
855: END IF;
856:
895:
896: if l_newround_amendment_count <> 0 then
897:
898: LOG_MESSAGE('copy_negotiation','Adding error to the FND stack to indicate parallel new rounds creation error and raising FND_API.G_EXC_ERROR');
899: FND_MESSAGE.SET_NAME('PON','PON_MULTI_NEWRND_OR_AMND_ERR');
900: FND_MSG_PUB.ADD;
901: RAISE FND_API.G_EXC_ERROR;
902:
903: end if;
915:
916: if l_newround_amendment_count <> 0 then
917:
918: LOG_MESSAGE('copy_negotiation','Adding error to the FND stack to indicate parallel amendments creation error and raising FND_API.G_EXC_ERROR;');
919: FND_MESSAGE.SET_NAME('PON','PON_MULTI_NEWRND_OR_AMND_ERR');
920: FND_MSG_PUB.ADD;
921: RAISE FND_API.G_EXC_ERROR;
922:
923: end if;
961: EXCEPTION
962: WHEN NO_DATA_FOUND THEN
963: -- The way I am adding this error may get changed in the future.
964: -- So, please be aware of that
965: FND_MESSAGE.SET_NAME('PON','PON_INVALID_NEG_NUM');
966: FND_MSG_PUB.ADD;
967: RAISE FND_API.G_EXC_ERROR;
968: END;
969:
1788: t_record.NUMBER_OF_BIDS > 0) THEN
1789:
1790: -- Now there will be a new generic message instead of the old doctype specific
1791: -- PON_AUC_NEXT_ROUND_WARNING variants
1792: FND_MESSAGE.SET_NAME('PON','PON_NEG_NEXT_ROUND_WARNING');
1793: -- The way I am adding this error may get changed in the future.
1794: -- So, please be aware of that
1795: FND_MSG_PUB.ADD;
1796: END IF;
1806: FROM PON_AUC_DOCTYPES
1807: WHERE DOCTYPE_ID = p_doctype_id;
1808: EXCEPTION
1809: WHEN OTHERS THEN
1810: FND_MESSAGE.SET_NAME('PON','PON_AUC_NO_DATA_EXISTS');
1811: FND_MSG_PUB.ADD;
1812: RAISE FND_API.G_EXC_ERROR;
1813: END;
1814:
3654: -- The way I am adding this warning may get changed in the future.
3655: -- So, please be aware of that. No need to add the doctype variant of the message
3656: -- as they are all practically same
3657: --
3658: FND_MESSAGE.SET_NAME('PON','PON_AUC_INACTIVE_ATTR_GROUP');
3659: FND_MSG_PUB.ADD;
3660:
3661: g_added_inactv_attr_grp_msg := 'Y';
3662:
6031: -- } End of loop
6032: END LOOP;
6033:
6034: -- give warning for inactive suppliers
6035: FND_MESSAGE.SET_NAME('PON','PON_INACTIVE_SUPP_INVITEE_W'||'_'||g_message_suffix);
6036: FND_MESSAGE.SET_TOKEN('LIST',l_supplier_names);
6037: FND_MSG_PUB.ADD;
6038: g_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6039: --}
6032: END LOOP;
6033:
6034: -- give warning for inactive suppliers
6035: FND_MESSAGE.SET_NAME('PON','PON_INACTIVE_SUPP_INVITEE_W'||'_'||g_message_suffix);
6036: FND_MESSAGE.SET_TOKEN('LIST',l_supplier_names);
6037: FND_MSG_PUB.ADD;
6038: g_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6039: --}
6040: END IF;
6098: -- } End of loop
6099: END LOOP;
6100:
6101: -- give warning for inactive suppliers
6102: FND_MESSAGE.SET_NAME('PON','PON_RS_REJECTED_INVITEE_W'||'_'||g_message_suffix);
6103: FND_MESSAGE.SET_TOKEN('LIST',l_supplier_names);
6104: FND_MSG_PUB.ADD;
6105: g_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6106: --}
6099: END LOOP;
6100:
6101: -- give warning for inactive suppliers
6102: FND_MESSAGE.SET_NAME('PON','PON_RS_REJECTED_INVITEE_W'||'_'||g_message_suffix);
6103: FND_MESSAGE.SET_TOKEN('LIST',l_supplier_names);
6104: FND_MSG_PUB.ADD;
6105: g_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6106: --}
6107: END IF;
6482: -- Add the invalid users in the stack
6483: --
6484: IF (l_full_name.COUNT <> 0) THEN
6485: --{
6486: FND_MESSAGE.SET_NAME('PON','PON_AUC_INACTIVE_MEMBERS_W'||'_'|| g_message_suffix);
6487: l_inactive_mem := '; 1. '||l_full_name(1);
6488:
6489: g_err_loc := '9.10 ';
6490: FOR x IN 2..l_full_name.COUNT
6493: END LOOP;
6494:
6495: -- The way I am adding this error may get changed in the future.
6496: -- So, please be aware of that
6497: FND_MESSAGE.SET_TOKEN('LIST',l_inactive_mem);
6498: FND_MSG_PUB.ADD;
6499:
6500: -- Set the status
6501: g_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6827: IF (l_inactive_sections > 0) THEN
6828:
6829: -- The way I am adding this error may get changed in the future.
6830: -- So, please be aware of that
6831: FND_MESSAGE.SET_NAME('PON','PON_INACTIVE_FORMS_COPY_INFO');
6832: FND_MSG_PUB.ADD;
6833:
6834: -- Set the status
6835: g_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9125: AND P.PRICE_ELEMENT_TYPE_ID = VL.PRICE_ELEMENT_TYPE_ID
9126: AND VL.ENABLED_FLAG = 'N';
9127:
9128: IF (l_name.COUNT <> 0) THEN
9129: FND_MESSAGE.SET_NAME('PON','PON_AUC_INACTIVE_PE_W'||'_'||g_message_suffix);
9130: FND_MESSAGE.SET_TOKEN('AUCTION_NUMBER',p_source_doc_num);
9131: l_inactive_pe_name := '; 1. '||l_name(1);
9132: LOG_MESSAGE('copy_lines_and_children','Copy PE: 2. l_inactive_pe_name:'||l_inactive_pe_name);
9133:
9126: AND VL.ENABLED_FLAG = 'N';
9127:
9128: IF (l_name.COUNT <> 0) THEN
9129: FND_MESSAGE.SET_NAME('PON','PON_AUC_INACTIVE_PE_W'||'_'||g_message_suffix);
9130: FND_MESSAGE.SET_TOKEN('AUCTION_NUMBER',p_source_doc_num);
9131: l_inactive_pe_name := '; 1. '||l_name(1);
9132: LOG_MESSAGE('copy_lines_and_children','Copy PE: 2. l_inactive_pe_name:'||l_inactive_pe_name);
9133:
9134: FOR x IN 2..l_name.COUNT
9137: END LOOP;
9138: -- The way I am adding this error may get changed in the future.
9139: -- So, please be aware of that
9140: LOG_MESSAGE('copy_lines_and_children','Copy PE: 3. l_inactive_pe_name:'||l_inactive_pe_name);
9141: FND_MESSAGE.SET_TOKEN('LIST',l_inactive_pe_name);
9142: FND_MSG_PUB.ADD;
9143: END IF;
9144: END IF;
9145:
9174:
9175: IF (l_error_code_update <> 'SUCCESS' ) THEN
9176: -- The way I am adding this error may get changed in the future.
9177: -- So, please be aware of that
9178: FND_MESSAGE.SET_NAME('PON','PON_GENERIC_ERR');
9179: FND_MESSAGE.SET_TOKEN('TOKEN',l_error_code_update||' - '||l_error_msg_update);
9180: FND_MSG_PUB.ADD;
9181: LOG_MESSAGE('copy_lines_and_children','Error while updating source negotiation. Error:'||l_error_msg_update);
9182: RAISE FND_API.G_EXC_ERROR;
9175: IF (l_error_code_update <> 'SUCCESS' ) THEN
9176: -- The way I am adding this error may get changed in the future.
9177: -- So, please be aware of that
9178: FND_MESSAGE.SET_NAME('PON','PON_GENERIC_ERR');
9179: FND_MESSAGE.SET_TOKEN('TOKEN',l_error_code_update||' - '||l_error_msg_update);
9180: FND_MSG_PUB.ADD;
9181: LOG_MESSAGE('copy_lines_and_children','Error while updating source negotiation. Error:'||l_error_msg_update);
9182: RAISE FND_API.G_EXC_ERROR;
9183: END IF;
9297: EXCEPTION
9298: WHEN OTHERS THEN
9299: -- The way I am adding this error may get changed in the future.
9300: -- So, please be aware of that
9301: FND_MESSAGE.SET_NAME('PON','PON_AUC_NO_DATA_EXISTS');
9302: FND_MSG_PUB.ADD;
9303: RAISE FND_API.G_EXC_ERROR;
9304: END;
9305:
9313: FROM PON_AUC_DOCTYPES
9314: WHERE DOCTYPE_GROUP_NAME = 'REQUEST_FOR_QUOTE';
9315: EXCEPTION
9316: WHEN OTHERS THEN
9317: FND_MESSAGE.SET_NAME('PON','PON_AUC_NO_DATA_EXISTS');
9318: FND_MSG_PUB.ADD;
9319: RAISE FND_API.G_EXC_ERROR;
9320: END;
9321:
9329: FROM PON_AUC_DOCTYPES
9330: WHERE DOCTYPE_GROUP_NAME = 'BUYER_AUCTION';
9331: EXCEPTION
9332: WHEN OTHERS THEN
9333: FND_MESSAGE.SET_NAME('PON','PON_AUC_NO_DATA_EXISTS');
9334: FND_MSG_PUB.ADD;
9335: RAISE FND_API.G_EXC_ERROR;
9336: END;
9337:
10195:
10196: -- The way I am adding this error may get changed in the future.
10197: -- So, please be aware of that
10198: --
10199: FND_MESSAGE.SET_NAME('PON','PON_INVALID_BIZ_RULE');
10200: FND_MSG_PUB.ADD;
10201: RAISE FND_API.G_EXC_ERROR;
10202: END;
10203:
10458: LOG_MESSAGE('copy_negotiation','Enterprise Party Id is NULL. Error returned by GET_ENTERPRISE_PARTYID method is - ' || SUBSTR(l_error_message,1,150));
10459: --
10460: -- The way I am adding this error may get changed in the future.
10461: -- So, please be aware of that
10462: FND_MESSAGE.SET_NAME('PON','PON_CONTRACT_COPY_ERR');
10463: FND_MESSAGE.SET_TOKEN('REASON',SUBSTR(l_error_message,1,300));
10464: FND_MSG_PUB.ADD;
10465: RAISE FND_API.G_EXC_ERROR;
10466: RETURN;
10459: --
10460: -- The way I am adding this error may get changed in the future.
10461: -- So, please be aware of that
10462: FND_MESSAGE.SET_NAME('PON','PON_CONTRACT_COPY_ERR');
10463: FND_MESSAGE.SET_TOKEN('REASON',SUBSTR(l_error_message,1,300));
10464: FND_MSG_PUB.ADD;
10465: RAISE FND_API.G_EXC_ERROR;
10466: RETURN;
10467: END IF;
10500: LOG_MESSAGE('copy_negotiation','Could not determine contact_id for fnd_user_id ' || fnd_global.user_id());
10501: --
10502: -- The way I am adding this error may get changed in the future.
10503: -- So, please be aware of that
10504: FND_MESSAGE.SET_NAME('PON','PON_CONTRACT_COPY_ERR');
10505: FND_MESSAGE.SET_TOKEN('REASON','Could not determine contact_id for fnd_user_id ' || fnd_global.user_id());
10506: FND_MSG_PUB.ADD;
10507: RAISE FND_API.G_EXC_ERROR;
10508: RETURN;
10501: --
10502: -- The way I am adding this error may get changed in the future.
10503: -- So, please be aware of that
10504: FND_MESSAGE.SET_NAME('PON','PON_CONTRACT_COPY_ERR');
10505: FND_MESSAGE.SET_TOKEN('REASON','Could not determine contact_id for fnd_user_id ' || fnd_global.user_id());
10506: FND_MSG_PUB.ADD;
10507: RAISE FND_API.G_EXC_ERROR;
10508: RETURN;
10509: END;
10581: --
10582: -- The way I am adding this error may get changed in the future.
10583: -- So, please be aware of that
10584: --
10585: FND_MESSAGE.SET_NAME('PON','PON_CONTRACT_COPY_ERR');
10586: FND_MESSAGE.SET_TOKEN('REASON','Can not copy contracts for source_id =' || l_source_doc_id || '. Error returned by OKC_TERMS_COPY_GRP.COPY_DOC API is - ' || SUBSTR(l_msg_data,1,150));
10587: FND_MSG_PUB.ADD;
10588: RAISE FND_API.G_EXC_ERROR;
10589: RETURN;
10582: -- The way I am adding this error may get changed in the future.
10583: -- So, please be aware of that
10584: --
10585: FND_MESSAGE.SET_NAME('PON','PON_CONTRACT_COPY_ERR');
10586: FND_MESSAGE.SET_TOKEN('REASON','Can not copy contracts for source_id =' || l_source_doc_id || '. Error returned by OKC_TERMS_COPY_GRP.COPY_DOC API is - ' || SUBSTR(l_msg_data,1,150));
10587: FND_MSG_PUB.ADD;
10588: RAISE FND_API.G_EXC_ERROR;
10589: RETURN;
10590: END IF;
10739: FROM PON_NEGOTIATION_STYLES
10740: WHERE style_id = p_style_id;
10741: EXCEPTION
10742: WHEN NO_DATA_FOUND THEN
10743: FND_MESSAGE.SET_NAME('PON','PON_INVALID_STYLE_ID');
10744: FND_MSG_PUB.ADD;
10745: RAISE FND_API.G_EXC_ERROR;
10746: END;
10747:
10757: FROM PON_AUCTION_HEADERS_ALL
10758: WHERE auction_header_id = p_source_auction_header_id;
10759: EXCEPTION
10760: WHEN NO_DATA_FOUND THEN
10761: FND_MESSAGE.SET_NAME('PON','PON_INVALID_NEG_NUM');
10762: FND_MSG_PUB.ADD;
10763: RAISE FND_API.G_EXC_ERROR;
10764: END;
10765: