DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_COPY_GRP dependencies on FND_MSG_PUB

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

804: -- value to p_init_msg_list in case this initialization is not
805: -- wanted
806: --
807: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
808: LOG_MESSAGE('copy_negotiation','Initializing the FND_MSG_PUB stack');
809: FND_MSG_PUB.INITIALIZE;
810: LOG_MESSAGE('copy_negotiation','Clearing the FND_MESSAGE stack');
811: FND_MESSAGE.CLEAR;
812: END IF;

Line 809: FND_MSG_PUB.INITIALIZE;

805: -- wanted
806: --
807: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
808: LOG_MESSAGE('copy_negotiation','Initializing the FND_MSG_PUB stack');
809: FND_MSG_PUB.INITIALIZE;
810: LOG_MESSAGE('copy_negotiation','Clearing the FND_MESSAGE stack');
811: FND_MESSAGE.CLEAR;
812: END IF;
813:

Line 869: FND_MSG_PUB.ADD;

865: -- So, please be aware of that
866: LOG_MESSAGE('copy_negotiation','wrong tp contact id');
867:
868: FND_MESSAGE.SET_NAME('PON','PON_INVALID_TP_CONTACT_ID');
869: FND_MSG_PUB.ADD;
870: RAISE FND_API.G_EXC_ERROR;
871: END;
872:
873: --For testing

Line 875: FND_MSG_PUB.ADD;

871: END;
872:
873: --For testing
874: /*FND_MESSAGE.SET_NAME('PON','PON_INVALID_TP_CONTACT_ID');
875: FND_MSG_PUB.ADD;
876: FND_MESSAGE.SET_NAME('PON','PON_INV_COPY_OPTION');
877: FND_MSG_PUB.ADD;
878: RAISE FND_API.G_EXC_ERROR;*/
879: --

Line 877: FND_MSG_PUB.ADD;

873: --For testing
874: /*FND_MESSAGE.SET_NAME('PON','PON_INVALID_TP_CONTACT_ID');
875: FND_MSG_PUB.ADD;
876: FND_MESSAGE.SET_NAME('PON','PON_INV_COPY_OPTION');
877: FND_MSG_PUB.ADD;
878: RAISE FND_API.G_EXC_ERROR;*/
879: --
880: -- Get the company name for the given trading_partner_id
881: -- The resultant company name will be used in the trading partner

Line 897: FND_MSG_PUB.ADD;

893: -- So, please be aware of that
894:
895: LOG_MESSAGE('copy_negotiation','wrong tp id');
896: FND_MESSAGE.SET_NAME('PON','PON_INVALID_TP_ID');
897: FND_MSG_PUB.ADD;
898: RAISE FND_API.G_EXC_ERROR;
899: END;
900:
901: --

Line 935: FND_MSG_PUB.ADD;

931: -- So, please be aware of that
932: LOG_MESSAGE('copy_negotiation','wrong copy type');
933:
934: FND_MESSAGE.SET_NAME('PON','PON_INV_COPY_OPTION');
935: FND_MSG_PUB.ADD;
936: RAISE FND_API.G_EXC_ERROR;
937: END IF;
938:
939: g_err_loc := '-1. Doing validation checks prior to copy';

Line 981: FND_MSG_PUB.ADD;

977: if l_newround_amendment_count <> 0 then
978:
979: LOG_MESSAGE('copy_negotiation','Adding error to the FND stack to indicate parallel new rounds creation error and raising FND_API.G_EXC_ERROR');
980: FND_MESSAGE.SET_NAME('PON','PON_MULTI_NEWRND_OR_AMND_ERR');
981: FND_MSG_PUB.ADD;
982: RAISE FND_API.G_EXC_ERROR;
983:
984: end if;
985:

Line 1001: FND_MSG_PUB.ADD;

997: if l_newround_amendment_count <> 0 then
998:
999: LOG_MESSAGE('copy_negotiation','Adding error to the FND stack to indicate parallel amendments creation error and raising FND_API.G_EXC_ERROR;');
1000: FND_MESSAGE.SET_NAME('PON','PON_MULTI_NEWRND_OR_AMND_ERR');
1001: FND_MSG_PUB.ADD;
1002: RAISE FND_API.G_EXC_ERROR;
1003:
1004: end if;
1005: elsif p_copy_type = g_conformed_doc_copy then

Line 1022: FND_MSG_PUB.ADD;

1018: if l_newround_amendment_count <> 0 then
1019:
1020: LOG_MESSAGE('copy_negotiation','Adding error to the FND stack to indicate parallel amendments creation error and raising FND_API.G_EXC_ERROR;');
1021: FND_MESSAGE.SET_NAME('PON','PON_MULTI_NEWRND_OR_AMND_ERR');
1022: FND_MSG_PUB.ADD;
1023: RAISE FND_API.G_EXC_ERROR;
1024:
1025: end if;
1026:

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

1030: EXCEPTION
1031: WHEN FND_API.G_EXC_ERROR THEN
1032: ROLLBACK TO PON_NEGOTIATION_COPY_GRP;
1033: x_return_status := FND_API.G_RET_STS_ERROR ;
1034: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
1035: p_data => x_msg_data
1036: );
1037:
1038: LOG_MESSAGE('copy_negotiation','An error in the procedure. Error at:'||g_err_loc || ' :' || SQLCODE || ' :' || SQLERRM);

Line 1070: FND_MSG_PUB.ADD;

1066: -- The way I am adding this error may get changed in the future.
1067: -- So, please be aware of that
1068:
1069: FND_MESSAGE.SET_NAME('PON','PON_INVALID_NEG_NUM');
1070: FND_MSG_PUB.ADD;
1071: RAISE FND_API.G_EXC_ERROR;
1072: END;
1073: -- load data for negotiation style
1074: LOG_MESSAGE('copy_negotiation','Call to SET_NEG_STYLE');

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

1468: EXCEPTION
1469: WHEN OTHERS THEN
1470: ROLLBACK TO PON_NEGOTIATION_COPY_GRP;
1471: x_return_status := FND_API.G_RET_STS_ERROR;
1472: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
1473: p_data => x_msg_data
1474: );
1475: LOG_MESSAGE('copy_negotiation','An error in the procedure. Error at:'||g_err_loc || ' :' || SQLCODE || ' :' || SQLERRM);
1476: return;

Line 2258: fnd_msg_pub.ADD;

2254: );
2255: fnd_message.set_token (token => 'PROC_CALLED',
2256: VALUE => 'PO_DOC_NUMBERING_PKG.DEFAULT_DOC_NUMBER_UDA'
2257: );
2258: fnd_msg_pub.ADD;
2259: RAISE FND_API.G_EXC_ERROR;
2260: WHEN OTHERS THEN
2261: LOG_MESSAGE('copy_negotiation','error in defauling doc number');
2262: RAISE l_uda_template_exception;

Line 2306: fnd_msg_pub.ADD;

2302: fnd_message.set_token (token => 'PROC_CALLER',
2303: VALUE => 'PON_NEGOTIATION_COPY_GRP.COPY_HEADER_BASIC');
2304: fnd_message.set_token (token => 'PROC_CALLED',
2305: VALUE => 'PO_DOC_NUMBERING_PKG.DEFAULT_DOC_NUMBER_UDA');
2306: fnd_msg_pub.ADD;
2307: RAISE FND_API.G_EXC_ERROR;
2308: WHEN OTHERS THEN
2309: LOG_MESSAGE('copy_negotiation : active','error in defauling doc number');
2310: RAISE l_uda_template_exception;

Line 2435: FND_MSG_PUB.ADD;

2431: -- PON_AUC_NEXT_ROUND_WARNING variants
2432: FND_MESSAGE.SET_NAME('PON','PON_NEG_NEXT_ROUND_WARNING');
2433: -- The way I am adding this error may get changed in the future.
2434: -- So, please be aware of that
2435: FND_MSG_PUB.ADD;
2436: END IF;
2437:
2438:
2439: --

Line 2451: FND_MSG_PUB.ADD;

2447: WHERE DOCTYPE_ID = p_doctype_id;
2448: EXCEPTION
2449: WHEN OTHERS THEN
2450: FND_MESSAGE.SET_NAME('PON','PON_AUC_NO_DATA_EXISTS');
2451: FND_MSG_PUB.ADD;
2452: RAISE FND_API.G_EXC_ERROR;
2453: END;
2454:
2455: --

Line 3371: FND_MSG_PUB.ADD;

3367: LOG_MESSAGE('Copy Header Basic','Copy Header UDA Status '||l_return_status);
3368: IF ( nvl(l_return_status,'S') <> 'S' ) THEN
3369: FND_MESSAGE.SET_NAME('PON','PON_GENERIC_ERR');
3370: FND_MESSAGE.SET_TOKEN('TOKEN','Error during Header UDA Copy '||l_msg_data);
3371: FND_MSG_PUB.ADD;
3372: LOG_MESSAGE('copy header basic','Error while copy header udas:'||l_msg_data||SQLERRM);
3373: RAISE FND_API.G_EXC_ERROR;
3374:
3375: END IF;

Line 4672: FND_MSG_PUB.ADD;

4668: EXCEPTION
4669: WHEN OTHERS THEN
4670: FND_MESSAGE.SET_NAME('PON','PON_GENERIC_ERR');
4671: FND_MESSAGE.SET_TOKEN('TOKEN','Error during Line UDA Copy '||l_msg_data);
4672: FND_MSG_PUB.ADD;
4673: LOG_MESSAGE('copy_lines','EXCEPTION WHILE COPYING LINE UDA '||SQLERRM);
4674: RAISE FND_API.G_EXC_ERROR;
4675: END;
4676:

Line 4681: FND_MSG_PUB.ADD;

4677: LOG_MESSAGE('Copy_Lines','Copy Line UDA Status '||l_return_status||' '||l_line_number(x));
4678: IF ( nvl(l_return_status,'S') <> 'S' ) THEN
4679: FND_MESSAGE.SET_NAME('PON','PON_GENERIC_ERR');
4680: FND_MESSAGE.SET_TOKEN('TOKEN','Error during Line UDA Copy '||l_msg_data);
4681: FND_MSG_PUB.ADD;
4682: LOG_MESSAGE('copy_lines','Error while copy line udas: '||l_msg_data);
4683: RAISE FND_API.G_EXC_ERROR;
4684: END IF;
4685:

Line 4706: FND_MSG_PUB.ADD;

4702: -- So, please be aware of that. No need to add the doctype variant of the message
4703: -- as they are all practically same
4704: --
4705: FND_MESSAGE.SET_NAME('PON','PON_AUC_INACTIVE_ATTR_GROUP');
4706: FND_MSG_PUB.ADD;
4707:
4708: g_added_inactv_attr_grp_msg := 'Y';
4709:
4710: -- Set the warning flag on

Line 7183: FND_MSG_PUB.ADD;

7179:
7180: -- give warning for inactive suppliers
7181: FND_MESSAGE.SET_NAME('PON','PON_INACTIVE_SUPP_INVITEE_W'||'_'||g_message_suffix);
7182: FND_MESSAGE.SET_TOKEN('LIST',l_supplier_names);
7183: FND_MSG_PUB.ADD;
7184: g_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7185: --}
7186: END IF;
7187:

Line 7250: FND_MSG_PUB.ADD;

7246:
7247: -- give warning for inactive suppliers
7248: FND_MESSAGE.SET_NAME('PON','PON_RS_REJECTED_INVITEE_W'||'_'||g_message_suffix);
7249: FND_MESSAGE.SET_TOKEN('LIST',l_supplier_names);
7250: FND_MSG_PUB.ADD;
7251: g_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7252: --}
7253: END IF;
7254: END IF; --}

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

7600: l_last_notif_date(x)
7601: ) ;
7602:
7603: --
7604: -- Add the invalid Negotiation Team members on the FND_MSG_PUB stack
7605: -- for the display as warning message.
7606: --
7607: -- It is assumed that if there are any extra team members having 'N' type
7608: -- in the original negotiation (as compared to the newly created negotiation)

Line 7654: FND_MSG_PUB.ADD;

7650:
7651: -- The way I am adding this error may get changed in the future.
7652: -- So, please be aware of that
7653: FND_MESSAGE.SET_TOKEN('LIST',l_inactive_mem);
7654: FND_MSG_PUB.ADD;
7655:
7656: -- Set the status
7657: g_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7658: --}

Line 7995: FND_MSG_PUB.ADD;

7991:
7992: -- The way I am adding this error may get changed in the future.
7993: -- So, please be aware of that
7994: FND_MESSAGE.SET_NAME('PON','PON_INACTIVE_FORMS_COPY_INFO');
7995: FND_MSG_PUB.ADD;
7996:
7997: -- Set the status
7998: g_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7999: END IF;

Line 10339: FND_MSG_PUB.ADD;

10335: -- The way I am adding this error may get changed in the future.
10336: -- So, please be aware of that
10337: LOG_MESSAGE('copy_lines_and_children','Copy PE: 3. l_inactive_pe_name:'||l_inactive_pe_name);
10338: FND_MESSAGE.SET_TOKEN('LIST',l_inactive_pe_name);
10339: FND_MSG_PUB.ADD;
10340: END IF;
10341: END IF;
10342:
10343:

Line 10379: FND_MSG_PUB.ADD;

10375: -- The way I am adding this error may get changed in the future.
10376: -- So, please be aware of that
10377: FND_MESSAGE.SET_NAME('PON','PON_GENERIC_ERR');
10378: FND_MESSAGE.SET_TOKEN('TOKEN',l_error_code_update||' - '||l_error_msg_update);
10379: FND_MSG_PUB.ADD;
10380: LOG_MESSAGE('copy_lines_and_children','Error while updating source negotiation. Error:'||l_error_msg_update);
10381: RAISE FND_API.G_EXC_ERROR;
10382: END IF;
10383:

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

10406:
10407: --
10408: -- Now get message count to initialize the OUT variable (x_msg_count)
10409: --
10410: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
10411: p_data => x_msg_data
10412: );
10413:
10414: --

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

10430: EXCEPTION
10431: WHEN FND_API.G_EXC_ERROR THEN
10432: ROLLBACK TO PON_NEGOTIATION_COPY_GRP;
10433: x_return_status := FND_API.G_RET_STS_ERROR ;
10434: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
10435: p_data => x_msg_data
10436: );
10437:
10438: LOG_MESSAGE('copy_lines_and_children','An error in the procedure. Error at:'||g_err_loc || ' :' || SQLCODE || ' :' || SQLERRM);

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

10440: -- Why another block? We can have only one block. Let me see
10441: WHEN OTHERS THEN
10442: ROLLBACK TO PON_NEGOTIATION_COPY_GRP;
10443: x_return_status := FND_API.G_RET_STS_ERROR;
10444: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
10445: p_data => x_msg_data
10446: );
10447: LOG_MESSAGE('copy_lines_and_children','An error in the procedure. Error at:'||g_err_loc || ' :' || SQLCODE || ' :' || SQLERRM);
10448:

Line 10574: FND_MSG_PUB.ADD;

10570: WHEN OTHERS THEN
10571: -- The way I am adding this error may get changed in the future.
10572: -- So, please be aware of that
10573: FND_MESSAGE.SET_NAME('PON','PON_AUC_NO_DATA_EXISTS');
10574: FND_MSG_PUB.ADD;
10575: RAISE FND_API.G_EXC_ERROR;
10576: END;
10577:
10578: g_rfi_doctype_id := l_rfi_doctype_id;

Line 10590: FND_MSG_PUB.ADD;

10586: WHERE DOCTYPE_GROUP_NAME = 'REQUEST_FOR_QUOTE';
10587: EXCEPTION
10588: WHEN OTHERS THEN
10589: FND_MESSAGE.SET_NAME('PON','PON_AUC_NO_DATA_EXISTS');
10590: FND_MSG_PUB.ADD;
10591: RAISE FND_API.G_EXC_ERROR;
10592: END;
10593:
10594: g_rfq_doctype_id := l_rfq_doctype_id;

Line 10608: FND_MSG_PUB.ADD;

10604: WHERE DOCTYPE_GROUP_NAME = 'SOLICITATION';
10605: EXCEPTION
10606: WHEN OTHERS THEN
10607: FND_MESSAGE.SET_NAME('PON','PON_AUC_NO_DATA_EXISTS');
10608: FND_MSG_PUB.ADD;
10609: RAISE FND_API.G_EXC_ERROR;
10610: END;
10611:
10612: g_sol_doctype_id := l_sol_doctype_id;

Line 10627: FND_MSG_PUB.ADD;

10623: WHERE DOCTYPE_GROUP_NAME = 'BUYER_AUCTION';
10624: EXCEPTION
10625: WHEN OTHERS THEN
10626: FND_MESSAGE.SET_NAME('PON','PON_AUC_NO_DATA_EXISTS');
10627: FND_MSG_PUB.ADD;
10628: RAISE FND_API.G_EXC_ERROR;
10629: END;
10630:
10631: g_auction_doctype_id := l_auction_doctype_id;

Line 11539: FND_MSG_PUB.ADD;

11535: -- The way I am adding this error may get changed in the future.
11536: -- So, please be aware of that
11537: --
11538: FND_MESSAGE.SET_NAME('PON','PON_INVALID_BIZ_RULE');
11539: FND_MSG_PUB.ADD;
11540: RAISE FND_API.G_EXC_ERROR;
11541: END;
11542:
11543: --

Line 11814: FND_MSG_PUB.ADD;

11810: -- The way I am adding this error may get changed in the future.
11811: -- So, please be aware of that
11812: FND_MESSAGE.SET_NAME('PON','PON_CONTRACT_COPY_ERR');
11813: FND_MESSAGE.SET_TOKEN('REASON',SUBSTR(l_error_message,1,300));
11814: FND_MSG_PUB.ADD;
11815: RAISE FND_API.G_EXC_ERROR;
11816: RETURN;
11817: END IF;
11818:

Line 11859: FND_MSG_PUB.ADD;

11855: -- The way I am adding this error may get changed in the future.
11856: -- So, please be aware of that
11857: FND_MESSAGE.SET_NAME('PON','PON_CONTRACT_COPY_ERR');
11858: FND_MESSAGE.SET_TOKEN('REASON','Could not determine contact_id for fnd_user_id ' || fnd_global.user_id());
11859: FND_MSG_PUB.ADD;
11860: RAISE FND_API.G_EXC_ERROR;
11861: RETURN;
11862: END;
11863:

Line 11940: FND_MSG_PUB.ADD;

11936: -- So, please be aware of that
11937: --
11938: FND_MESSAGE.SET_NAME('PON','PON_CONTRACT_COPY_ERR');
11939: 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));
11940: FND_MSG_PUB.ADD;
11941: RAISE FND_API.G_EXC_ERROR;
11942: RETURN;
11943: END IF;
11944: --}

Line 12177: FND_MSG_PUB.ADD;

12173: FND_MESSAGE.SET_NAME('PON','PON_INVALID_STYLE_ID');
12174: ELSE
12175: FND_MESSAGE.SET_NAME('PON','PON_INVALID_NEG_NUM');
12176: END IF;
12177: FND_MSG_PUB.ADD;
12178: RAISE FND_API.G_EXC_ERROR;
12179: END;
12180:
12181: else

Line 12203: FND_MSG_PUB.ADD;

12199: EXCEPTION
12200: WHEN NO_DATA_FOUND THEN
12201: LOG_MESSAGE('SET_NEG_STYLE','Invalid Neg Num');
12202: FND_MESSAGE.SET_NAME('PON','PON_INVALID_NEG_NUM');
12203: FND_MSG_PUB.ADD;
12204: RAISE FND_API.G_EXC_ERROR;
12205: END;
12206:
12207: end if;