DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_COPY_GRP dependencies on FND_MSG_PUB

Line 757: LOG_MESSAGE('copy_negotiation','Initializing the FND_MSG_PUB stack');

753: -- value to p_init_msg_list in case this initialization is not
754: -- wanted
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;

Line 758: FND_MSG_PUB.INITIALIZE;

754: -- wanted
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:

Line 799: FND_MSG_PUB.ADD;

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: --
803: -- Get the company name for the given trading_partner_id

Line 817: FND_MSG_PUB.ADD;

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:
821: --

Line 853: FND_MSG_PUB.ADD;

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:
857: g_err_loc := '-1. Doing validation checks prior to copy';

Line 900: FND_MSG_PUB.ADD;

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;
904:

Line 920: FND_MSG_PUB.ADD;

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;
924:

Line 931: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

927: EXCEPTION
928: WHEN FND_API.G_EXC_ERROR THEN
929: ROLLBACK TO PON_NEGOTIATION_COPY_GRP;
930: x_return_status := FND_API.G_RET_STS_ERROR ;
931: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
932: p_data => x_msg_data
933: );
934:
935: LOG_MESSAGE('copy_negotiation','An error in the procedure. Error at:'||g_err_loc || ' :' || SQLCODE || ' :' || SQLERRM);

Line 966: FND_MSG_PUB.ADD;

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:
970: -- load data for negotiation style

Line 1310: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

1306: EXCEPTION
1307: WHEN OTHERS THEN
1308: ROLLBACK TO PON_NEGOTIATION_COPY_GRP;
1309: x_return_status := FND_API.G_RET_STS_ERROR;
1310: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
1311: p_data => x_msg_data
1312: );
1313: LOG_MESSAGE('copy_negotiation','An error in the procedure. Error at:'||g_err_loc || ' :' || SQLCODE || ' :' || SQLERRM);
1314: return;

Line 1795: FND_MSG_PUB.ADD;

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;
1797:
1798:
1799: --

Line 1811: FND_MSG_PUB.ADD;

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:
1815: --

Line 3659: FND_MSG_PUB.ADD;

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:
3663: -- Set the warning flag on

Line 6037: FND_MSG_PUB.ADD;

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;
6041:

Line 6104: FND_MSG_PUB.ADD;

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;
6108: END IF; --}

Line 6448: -- Add the invalid Negotiation Team members on the FND_MSG_PUB stack

6444: l_last_notif_date(x)
6445: ) ;
6446:
6447: --
6448: -- Add the invalid Negotiation Team members on the FND_MSG_PUB stack
6449: -- for the display as warning message.
6450: --
6451: -- It is assumed that if there are any extra team members having 'N' type
6452: -- in the original negotiation (as compared to the newly created negotiation)

Line 6498: FND_MSG_PUB.ADD;

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 ;
6502: --}

Line 6832: FND_MSG_PUB.ADD;

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 ;
6836: END IF;

Line 9142: FND_MSG_PUB.ADD;

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:
9146:

Line 9180: FND_MSG_PUB.ADD;

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;
9184:

Line 9211: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

9207:
9208: --
9209: -- Now get message count to initialize the OUT variable (x_msg_count)
9210: --
9211: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
9212: p_data => x_msg_data
9213: );
9214:
9215: --

Line 9232: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

9228: EXCEPTION
9229: WHEN FND_API.G_EXC_ERROR THEN
9230: ROLLBACK TO PON_NEGOTIATION_COPY_GRP;
9231: x_return_status := FND_API.G_RET_STS_ERROR ;
9232: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
9233: p_data => x_msg_data
9234: );
9235:
9236: LOG_MESSAGE('copy_lines_and_children','An error in the procedure. Error at:'||g_err_loc || ' :' || SQLCODE || ' :' || SQLERRM);

Line 9242: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

9238: -- Why another block? We can have only one block. Let me see
9239: WHEN OTHERS THEN
9240: ROLLBACK TO PON_NEGOTIATION_COPY_GRP;
9241: x_return_status := FND_API.G_RET_STS_ERROR;
9242: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
9243: p_data => x_msg_data
9244: );
9245: LOG_MESSAGE('copy_lines_and_children','An error in the procedure. Error at:'||g_err_loc || ' :' || SQLCODE || ' :' || SQLERRM);
9246:

Line 9302: FND_MSG_PUB.ADD;

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:
9306: g_rfi_doctype_id := l_rfi_doctype_id;

Line 9318: FND_MSG_PUB.ADD;

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:
9322: g_rfq_doctype_id := l_rfq_doctype_id;

Line 9334: FND_MSG_PUB.ADD;

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:
9338: g_auction_doctype_id := l_auction_doctype_id;

Line 10200: FND_MSG_PUB.ADD;

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:
10204: --

Line 10464: FND_MSG_PUB.ADD;

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;
10468:

Line 10506: FND_MSG_PUB.ADD;

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;
10510:

Line 10587: FND_MSG_PUB.ADD;

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;
10591: --}

Line 10744: FND_MSG_PUB.ADD;

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:
10748: else

Line 10762: FND_MSG_PUB.ADD;

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:
10766: end if;