eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_WF_K_PROCESS_PVT dependencies on FND_MSG_PUB

Line 103: FOR i in 1..fnd_msg_pub.count_msg

99: l_msg_data VARCHAR2(2000);
100: l_msg_index_out NUMBER;
101: l_mesg VARCHAR2(2000) := NULL;
102: BEGIN
103: FOR i in 1..fnd_msg_pub.count_msg
104: LOOP
105: fnd_msg_pub.get
106: (
107: p_msg_index => i,

Line 105: fnd_msg_pub.get

101: l_mesg VARCHAR2(2000) := NULL;
102: BEGIN
103: FOR i in 1..fnd_msg_pub.count_msg
104: LOOP
105: fnd_msg_pub.get
106: (
107: p_msg_index => i,
108: p_encoded => 'F',
109: p_data => l_msg_data,

Line 168: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

164: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
165: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
166: ||SQLCODE||', sqlerrm = '||SQLERRM);
167: END IF;
168: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
169: RETURN NULL;
170: END replace_token;
171:
172: FUNCTION get_message

Line 227: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

223: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
224: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
225: ||SQLCODE||', sqlerrm = '||SQLERRM);
226: END IF;
227: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
228: RETURN NULL;
229: END get_message;
230:
231: FUNCTION get_concat_k_number

Line 288: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

284: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
285: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
286: ||SQLCODE||', sqlerrm = '||SQLERRM);
287: END IF;
288: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
289: RETURN NULL;
290: END get_concat_k_number;
291:
292: FUNCTION get_lookup_meaning

Line 337: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

333: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
334: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
335: ||SQLCODE||', sqlerrm = '||SQLERRM);
336: END IF;
337: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
338: RETURN NULL;
339: END get_lookup_meaning;
340:
341: FUNCTION get_wf_item_key

Line 391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

387: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
388: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
389: ||SQLCODE||', sqlerrm = '||SQLERRM);
390: END IF;
391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
392: END get_wf_item_key;
393:
394: -- Check if a template is defined for a particular type of document
395: -- like ACTIVE, ACCEPT or DECLINE etc

Line 462: FND_MSG_PUB.initialize;

458: END IF;
459:
460: -- Initialize message list if p_init_msg_list is set to TRUE.
461: IF FND_API.to_Boolean( p_init_msg_list ) THEN
462: FND_MSG_PUB.initialize;
463: END IF;
464:
465: -- Initialize API return status to success
466: x_return_status := G_RET_STS_SUCCESS;

Line 472: FND_MSG_PUB.add;

468:
469: IF p_contract_id IS NULL THEN
470: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
471: FND_MESSAGE.SET_TOKEN('HDR_ID','null');
472: FND_MSG_PUB.add;
473: RAISE FND_API.G_EXC_ERROR;
474: END IF;
475: okc_context.set_okc_org_context(p_chr_id => p_contract_id);
476:

Line 629: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);

625: END IF;
626: END IF;
627:
628: -- Standard call to get message count and if count is 1, get message info.
629: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);
630:
631: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
632: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
633: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 639: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

635:
636: EXCEPTION
637: WHEN FND_API.G_EXC_ERROR THEN
638: x_return_status := G_RET_STS_ERROR;
639: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
640: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
641: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
642: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ERROR');
643: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,get_fnd_message);

Line 652: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

648: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
649: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
650: ||SQLCODE||', sqlerrm = '||SQLERRM);
651: END IF;
652: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
653: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
654: END is_template_defined;
655:
656: FUNCTION get_irr_flag

Line 653: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

649: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
650: ||SQLCODE||', sqlerrm = '||SQLERRM);
651: END IF;
652: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
653: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
654: END is_template_defined;
655:
656: FUNCTION get_irr_flag
657: (

Line 680: FND_MSG_PUB.add;

676: l_item_key := get_wf_item_key(p_contract_id);
677: ELSE
678: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
679: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
680: FND_MSG_PUB.add;
681: RAISE FND_API.G_EXC_ERROR;
682: END IF;
683: ELSE
684: l_item_key := p_item_key;

Line 729: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

725: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
726: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
727: ||SQLCODE||', sqlerrm = '||SQLERRM);
728: END IF;
729: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
730: RETURN NULL;
731: END get_irr_flag;
732:
733: FUNCTION activity_exist_in_process

Line 774: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

770: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
771: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
772: ||SQLCODE||', sqlerrm = '||SQLERRM);
773: END IF;
774: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
775: RETURN FALSE;
776: END activity_exist_in_process;
777:
778: FUNCTION get_notified_activity

Line 816: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

812: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
813: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
814: ||SQLCODE||', sqlerrm = '||SQLERRM);
815: END IF;
816: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
817: RETURN 'ERR';
818: END get_notified_activity;
819:
820: /*=========================================================================

Line 880: FND_MSG_PUB.initialize;

876: END IF;
877:
878: -- Initialize message list if p_init_msg_list is set to TRUE.
879: IF FND_API.to_Boolean( p_init_msg_list ) THEN
880: FND_MSG_PUB.initialize;
881: END IF;
882:
883: -- Initialize API return status to success
884: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 889: FND_MSG_PUB.add;

885:
886: IF p_contract_id IS NULL THEN
887: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
888: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
889: FND_MSG_PUB.add;
890: RAISE FND_API.G_EXC_ERROR;
891: END IF;
892:
893: IF p_item_key IS NULL THEN

Line 897: FND_MSG_PUB.add;

893: IF p_item_key IS NULL THEN
894: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
895: IF l_item_key IS NULL THEN
896: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
897: FND_MSG_PUB.add;
898: RAISE FND_API.G_EXC_ERROR;
899: END IF;
900: ELSE
901: l_item_key := p_item_key;

Line 934: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);

930: ' Process Type '|| l_process_type ||
931: ' Online YN ' || x_online_yn);
932: END IF;
933: -- Standard call to get message count and if count is 1, get message info.
934: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);
935:
936: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
937: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
938: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 944: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

940:
941: EXCEPTION
942: WHEN FND_API.G_EXC_ERROR THEN
943: x_return_status := G_RET_STS_ERROR;
944: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
945: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
946: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
947: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ERROR');
948: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,get_fnd_message);

Line 957: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

953: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
954: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
955: ||SQLCODE||', sqlerrm = '||SQLERRM);
956: END IF;
957: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
958: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
959: END is_online_k_yn;
960:
961: PROCEDURE complete_activity

Line 958: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

954: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
955: ||SQLCODE||', sqlerrm = '||SQLERRM);
956: END IF;
957: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
958: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
959: END is_online_k_yn;
960:
961: PROCEDURE complete_activity
962: (

Line 996: FND_MSG_PUB.initialize;

992: END IF;
993:
994: -- Initialize message list if p_init_msg_list is set to TRUE.
995: IF FND_API.to_Boolean( p_init_msg_list ) THEN
996: FND_MSG_PUB.initialize;
997: END IF;
998:
999: -- Initialize API return status to success
1000: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1006: FND_MSG_PUB.add;

1002: IF p_item_key IS NULL THEN
1003: l_item_key := get_wf_item_key(p_contract_id);
1004: IF l_item_key IS NULL THEN
1005: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
1006: FND_MSG_PUB.add;
1007: RAISE FND_API.G_EXC_ERROR;
1008: END IF;
1009: ELSE
1010: l_item_key := p_item_key;

Line 1061: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1057: );
1058:
1059:
1060: -- Standard call to get message count and if count is 1, get message info.
1061: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1062:
1063: -- end debug log
1064: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1065: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1072: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1068: END IF;
1069:
1070: EXCEPTION
1071: WHEN FND_API.G_EXC_ERROR THEN
1072: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1073: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1074: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
1075: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
1076: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

Line 1081: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1077: END IF;
1078: x_return_status := G_RET_STS_ERROR ;
1079:
1080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1081: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1082: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1083: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
1084: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
1085: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

Line 1095: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1091: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1092: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
1093: ||SQLCODE||', sqlerrm = '||SQLERRM);
1094: END IF;
1095: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1096: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1097: x_return_status := G_RET_STS_UNEXP_ERROR ;
1098: END complete_activity;
1099:

Line 1096: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1092: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
1093: ||SQLCODE||', sqlerrm = '||SQLERRM);
1094: END IF;
1095: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1096: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1097: x_return_status := G_RET_STS_UNEXP_ERROR ;
1098: END complete_activity;
1099:
1100: FUNCTION get_negotiation_status

Line 1127: fnd_msg_pub.add;

1123: CLOSE l_NegotiationStatus_csr;
1124:
1125: IF l_negotiation_status IS NULL THEN
1126: fnd_message.set_name(G_APP_NAME,'OKS_INVALID_NEG_STATUS');
1127: fnd_msg_pub.add;
1128: RAISE FND_API.G_EXC_ERROR;
1129: END IF;
1130:
1131: -- end debug log

Line 1151: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1147: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
1148: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
1149: ||SQLCODE||', sqlerrm = '||SQLERRM);
1150: END IF;
1151: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1152: RETURN NULL;
1153:
1154: END get_negotiation_status;
1155:

Line 1250: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1246: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
1247: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
1248: ||SQLCODE||', sqlerrm = '||SQLERRM);
1249: END IF;
1250: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1251: RETURN NULL;
1252: END in_process_yn;
1253:
1254: FUNCTION get_qto_email

Line 1288: fnd_msg_pub.add;

1284: CLOSE l_QToContact_csr;
1285:
1286: IF l_contact_id IS NULL THEN
1287: fnd_message.set_name(G_APP_NAME,'OKS_NO_QTO_CONTACT');
1288: fnd_msg_pub.add;
1289: RAISE FND_API.G_EXC_ERROR;
1290: END IF;
1291:
1292: OPEN l_emailAddress_csr (l_contact_id) ;

Line 1298: fnd_msg_pub.add;

1294: CLOSE l_emailAddress_csr;
1295:
1296: IF l_qto_email IS NULL THEN
1297: fnd_message.set_name(G_APP_NAME,'OKS_NO_QTO_EMAIL');
1298: fnd_msg_pub.add;
1299: RAISE FND_API.G_EXC_ERROR;
1300: END IF;
1301:
1302: -- end debug log

Line 1322: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1318: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
1319: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
1320: ||SQLCODE||', sqlerrm = '||SQLERRM);
1321: END IF;
1322: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1323: RETURN NULL;
1324:
1325: END get_qto_email;
1326:

Line 1453: FND_MSG_PUB.initialize;

1449: END IF;
1450:
1451: -- Initialize message list if p_init_msg_list is set to TRUE.
1452: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1453: FND_MSG_PUB.initialize;
1454: END IF;
1455:
1456: -- Initialize API return status to success
1457: x_return_status := G_RET_STS_SUCCESS;

Line 1466: FND_MSG_PUB.add;

1462: CLOSE l_kdetails_csr;
1463: IF l_rownotfound THEN
1464: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
1465: FND_MESSAGE.SET_TOKEN('HDR_ID',p_notif_attr.CONTRACT_ID);
1466: FND_MSG_PUB.add;
1467: RAISE FND_API.G_EXC_ERROR;
1468: END IF;
1469:
1470: IF l_kdetails_rec.contract_number_modifier IS NULL THEN

Line 1760: l_msg_count := NVL(fnd_msg_pub.count_msg,0);

1756:
1757: -- If this flag is set to Y, retrieve messages from error stack and assign them
1758: -- to the message attibutes.
1759: IF NVL(p_notif_attr.MSGS_FROM_STACK_YN,'N') = 'Y' THEN
1760: l_msg_count := NVL(fnd_msg_pub.count_msg,0);
1761: IF l_msg_count>0 THEN
1762:
1763: IF l_msg_count>10 THEN l_msg_count := 10; END IF;
1764: FOR l_counter in 1..l_msg_count Loop

Line 1765: fnd_msg_pub.get

1761: IF l_msg_count>0 THEN
1762:
1763: IF l_msg_count>10 THEN l_msg_count := 10; END IF;
1764: FOR l_counter in 1..l_msg_count Loop
1765: fnd_msg_pub.get
1766: (
1767: p_msg_index => l_counter,
1768: p_encoded => 'F',
1769: p_data => l_msg_data,

Line 1891: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);

1887: 'Successfully set workflow attributes ');
1888: END IF;
1889:
1890: -- Standard call to get message count and if count is 1, get message info.
1891: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);
1892:
1893: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1894: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
1895: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1901: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1897:
1898: EXCEPTION
1899: WHEN FND_API.G_EXC_ERROR THEN
1900: x_return_status := G_RET_STS_ERROR;
1901: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1902: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1903: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
1904: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ERROR');
1905: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,get_fnd_message);

Line 1914: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1910: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
1911: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
1912: ||SQLCODE||', sqlerrm = '||SQLERRM);
1913: END IF;
1914: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1915: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1916: END set_notification_attributes;
1917:
1918: /*=========================================================================

Line 1915: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1911: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
1912: ||SQLCODE||', sqlerrm = '||SQLERRM);
1913: END IF;
1914: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1915: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1916: END set_notification_attributes;
1917:
1918: /*=========================================================================
1919: API name : set_email_attributes

Line 2030: FND_MSG_PUB.initialize;

2026: END IF;
2027:
2028: -- Initialize message list if p_init_msg_list is set to TRUE.
2029: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2030: FND_MSG_PUB.initialize;
2031: END IF;
2032:
2033: -- Initialize API return status to success
2034: x_return_status := G_RET_STS_SUCCESS;

Line 2039: FND_MSG_PUB.add;

2035:
2036: IF p_email_attr.CONTRACT_ID IS NULL THEN
2037: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
2038: FND_MESSAGE.SET_TOKEN('HDR_ID','null');
2039: FND_MSG_PUB.add;
2040: RAISE FND_API.G_EXC_ERROR;
2041: END IF;
2042:
2043: IF p_email_attr.TO_EMAIL IS NULL THEN

Line 2095: FND_MSG_PUB.add;

2091: IF l_rownotfound THEN
2092: -- Sender email is not found
2093: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_EMAIL_NOT_FOUND');
2094: FND_MESSAGE.SET_TOKEN('USER_NAME',l_salesrep_name);
2095: FND_MSG_PUB.add;
2096: RAISE FND_API.G_EXC_ERROR;
2097: END IF;
2098: ELSE
2099: l_sender_email := p_email_attr.SENDER_EMAIL;

Line 2114: FND_MSG_PUB.add;

2110: IF p_email_attr.ITEM_KEY IS NULL THEN
2111: l_item_key := get_wf_item_key(p_contract_id => p_email_attr.CONTRACT_ID);
2112: IF l_item_key IS NULL THEN
2113: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
2114: FND_MSG_PUB.add;
2115: RAISE FND_API.G_EXC_ERROR;
2116: END IF;
2117: ELSE
2118: l_item_key := p_email_attr.ITEM_KEY;

Line 2426: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);

2422: 'Successfully set workflow attributes ');
2423: END IF;
2424:
2425: -- Standard call to get message count and if count is 1, get message info.
2426: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);
2427:
2428: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2429: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
2430: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2436: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

2432:
2433: EXCEPTION
2434: WHEN FND_API.G_EXC_ERROR THEN
2435: x_return_status := G_RET_STS_ERROR;
2436: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2437: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2438: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
2439: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ERROR');
2440: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,get_fnd_message);

Line 2449: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

2445: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
2446: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
2447: ||SQLCODE||', sqlerrm = '||SQLERRM);
2448: END IF;
2449: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2450: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2451: END set_email_attributes;
2452:
2453: ---------------------------------------------------

Line 2450: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

2446: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
2447: ||SQLCODE||', sqlerrm = '||SQLERRM);
2448: END IF;
2449: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2450: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2451: END set_email_attributes;
2452:
2453: ---------------------------------------------------
2454: PROCEDURE customer_accept_quote

Line 2518: FND_MSG_PUB.initialize;

2514: END IF;
2515:
2516: -- Initialize message list if p_init_msg_list is set to TRUE.
2517: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2518: FND_MSG_PUB.initialize;
2519: END IF;
2520:
2521: -- Initialize API return status to success
2522: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2528: FND_MSG_PUB.add;

2524: IF p_item_key IS NULL THEN
2525: l_item_key := get_wf_item_key(p_contract_id);
2526: IF l_item_key IS NULL THEN
2527: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
2528: FND_MSG_PUB.add;
2529: RAISE FND_API.G_EXC_ERROR;
2530: END IF;
2531: ELSE
2532: l_item_key := p_item_key;

Line 2743: fnd_msg_pub.add;

2739: ELSE
2740: -- invalid activity
2741: fnd_message.set_name(G_APP_NAME,'OKS_INVALID_CUST_ACPT_ACTION');
2742: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
2743: fnd_msg_pub.add;
2744: RAISE FND_API.G_EXC_ERROR;
2745: END IF;
2746:
2747: IF FND_API.to_boolean( p_commit ) THEN

Line 2752: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

2748: COMMIT;
2749: END IF;
2750:
2751: -- Standard call to get message count and if count is 1, get message info.
2752: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2753:
2754: -- end debug log
2755: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2756: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,

Line 2762: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

2758: END IF;
2759: EXCEPTION
2760: WHEN FND_API.G_EXC_ERROR THEN
2761: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
2762: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2763: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2764: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
2765: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
2766: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

Line 2771: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

2767: END IF;
2768: x_return_status := G_RET_STS_ERROR;
2769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2770: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
2771: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2772: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
2774: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
2775: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

Line 2785: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

2781: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2782: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
2783: ||SQLCODE||', sqlerrm = '||SQLERRM);
2784: END IF;
2785: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2786: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2787: x_return_status := G_RET_STS_UNEXP_ERROR ;
2788: END customer_accept_quote;
2789:

Line 2786: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

2782: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
2783: ||SQLCODE||', sqlerrm = '||SQLERRM);
2784: END IF;
2785: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2786: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2787: x_return_status := G_RET_STS_UNEXP_ERROR ;
2788: END customer_accept_quote;
2789:
2790: ---------------------------------------------------

Line 2870: FND_MSG_PUB.initialize;

2866: END IF;
2867:
2868: -- Initialize message list if p_init_msg_list is set to TRUE.
2869: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2870: FND_MSG_PUB.initialize;
2871: END IF;
2872:
2873: -- Initialize API return status to success
2874: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2880: FND_MSG_PUB.add;

2876: IF p_item_key IS NULL THEN
2877: l_item_key := get_wf_item_key(p_contract_id);
2878: IF l_item_key IS NULL THEN
2879: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
2880: FND_MSG_PUB.add;
2881: RAISE FND_API.G_EXC_ERROR;
2882: END IF;
2883: ELSE
2884: l_item_key := p_item_key;

Line 3114: fnd_msg_pub.add;

3110: END IF;
3111: ELSE
3112: FND_MESSAGE.set_name('OKS','OKS_CANT_CANCEL_K'); -- set the message here
3113: FND_MESSAGE.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3114: fnd_msg_pub.add;
3115: RAISE FND_API.G_EXC_ERROR;
3116: END IF;
3117: ELSE
3118: -- invalid activity

Line 3121: fnd_msg_pub.add;

3117: ELSE
3118: -- invalid activity
3119: fnd_message.set_name(G_APP_NAME,'OKS_INVALID_CUST_DCLN_ACTION');
3120: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3121: fnd_msg_pub.add;
3122: RAISE FND_API.G_EXC_ERROR;
3123: END IF;
3124:
3125: IF FND_API.to_boolean( p_commit ) THEN

Line 3130: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3126: COMMIT;
3127: END IF;
3128:
3129: -- Standard call to get message count and if count is 1, get message info.
3130: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3131:
3132: -- end debug log
3133: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3134: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 3141: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3137:
3138: EXCEPTION
3139: WHEN FND_API.G_EXC_ERROR THEN
3140: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
3141: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3142: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3143: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3144: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
3145: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

Line 3150: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3146: END IF;
3147: x_return_status := G_RET_STS_ERROR;
3148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3149: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
3150: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3151: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3152: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3153: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
3154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

Line 3164: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

3160: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
3161: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
3162: ||SQLCODE||', sqlerrm = '||SQLERRM);
3163: END IF;
3164: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3165: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3166: x_return_status := G_RET_STS_UNEXP_ERROR ;
3167: END customer_decline_quote;
3168:

Line 3165: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3161: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
3162: ||SQLCODE||', sqlerrm = '||SQLERRM);
3163: END IF;
3164: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3165: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3166: x_return_status := G_RET_STS_UNEXP_ERROR ;
3167: END customer_decline_quote;
3168:
3169: ---------------------------------------------------

Line 3230: FND_MSG_PUB.initialize;

3226: END IF;
3227:
3228: -- Initialize message list if p_init_msg_list is set to TRUE.
3229: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3230: FND_MSG_PUB.initialize;
3231: END IF;
3232:
3233: -- Initialize API return status to success
3234: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3240: FND_MSG_PUB.add;

3236: IF p_item_key IS NULL THEN
3237: l_item_key := get_wf_item_key(p_contract_id);
3238: IF l_item_key IS NULL THEN
3239: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
3240: FND_MSG_PUB.add;
3241: RAISE FND_API.G_EXC_ERROR;
3242: END IF;
3243: ELSE
3244: l_item_key := p_item_key;

Line 3365: FND_MSG_PUB.add;

3361: WHEN OTHERS THEN
3362: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_CREATE_ADHOC_USER_FAILED');
3363: FND_MESSAGE.set_token('USER_NAME',l_user_tbl(k));
3364: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
3365: FND_MSG_PUB.add;
3366: RAISE FND_API.G_EXC_ERROR;
3367: END;
3368:
3369:

Line 3411: FND_MSG_PUB.add;

3407: WHEN OTHERS THEN
3408: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_CREATE_ADHOC_ROLE_FAILED');
3409: FND_MESSAGE.set_token('ROLE_NAME',l_role_name);
3410: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
3411: FND_MSG_PUB.add;
3412: RAISE FND_API.G_EXC_ERROR;
3413: END;
3414:
3415: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 3530: FND_MSG_PUB.add;

3526: ELSE
3527: -- invalid activity
3528: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_REQ_ASST_ACTION');
3529: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3530: FND_MSG_PUB.add;
3531: RAISE FND_API.G_EXC_ERROR;
3532: END IF;
3533:
3534: IF FND_API.to_boolean( p_commit ) THEN

Line 3539: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3535: COMMIT;
3536: END IF;
3537:
3538: -- Standard call to get message count and if count is 1, get message info.
3539: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3540:
3541: -- end debug log
3542: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3543: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,

Line 3550: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3546:
3547: EXCEPTION
3548: WHEN FND_API.G_EXC_ERROR THEN
3549: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
3550: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3551: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3552: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3553: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
3554: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

Line 3559: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3555: END IF;
3556: x_return_status := G_RET_STS_ERROR;
3557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3558: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
3559: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3560: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3561: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3562: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
3563: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

Line 3573: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

3569: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
3570: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
3571: ||SQLCODE||', sqlerrm = '||SQLERRM);
3572: END IF;
3573: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3574: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3575: x_return_status := G_RET_STS_UNEXP_ERROR ;
3576: END customer_request_assistance;
3577:

Line 3574: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3570: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
3571: ||SQLCODE||', sqlerrm = '||SQLERRM);
3572: END IF;
3573: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3574: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3575: x_return_status := G_RET_STS_UNEXP_ERROR ;
3576: END customer_request_assistance;
3577:
3578: /*=========================================================================

Line 3631: FND_MSG_PUB.initialize;

3627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3628: END IF;
3629:
3630: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3631: FND_MSG_PUB.initialize;
3632: END IF;
3633:
3634: -- Initialize API return status to success
3635: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3669: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);

3665: COMMIT;
3666: END IF;
3667:
3668: -- Standard call to get message count and if count is 1, get message info.
3669: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);
3670:
3671: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3672: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3673: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 3679: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3675:
3676: EXCEPTION
3677: WHEN FND_API.G_EXC_ERROR THEN
3678: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
3679: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3680: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3681: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3682: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
3683: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

Line 3688: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3684: END IF;
3685: x_return_status := G_RET_STS_ERROR;
3686: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3687: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
3688: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3689: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3690: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3691: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
3692: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

Line 3702: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

3698: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
3699: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
3700: ||SQLCODE||', sqlerrm = '||SQLERRM);
3701: END IF;
3702: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3703: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3704: x_return_status := G_RET_STS_UNEXP_ERROR ;
3705: END update_negotiation_status;
3706:

Line 3703: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3699: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
3700: ||SQLCODE||', sqlerrm = '||SQLERRM);
3701: END IF;
3702: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3703: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3704: x_return_status := G_RET_STS_UNEXP_ERROR ;
3705: END update_negotiation_status;
3706:
3707: /*=========================================================================

Line 4007: FND_MSG_PUB.add;

4003:
4004: IF p_contract_id IS NULL THEN
4005: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
4006: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
4007: FND_MSG_PUB.add;
4008: RAISE FND_API.G_EXC_ERROR;
4009: END IF;
4010:
4011: l_notif_attr_rec.CONTRACT_ID := p_contract_id;

Line 4061: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

4057:
4058: EXCEPTION
4059: WHEN FND_API.G_EXC_ERROR THEN
4060: x_return_status := G_RET_STS_ERROR;
4061: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4062: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4063: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
4064: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ERROR');
4065: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,get_fnd_message);

Line 4074: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

4070: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
4071: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
4072: ||SQLCODE||', sqlerrm = '||SQLERRM);
4073: END IF;
4074: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4075: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4076: END set_notification_attr;
4077:
4078: /*=========================================================================

Line 4075: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

4071: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
4072: ||SQLCODE||', sqlerrm = '||SQLERRM);
4073: END IF;
4074: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4075: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4076: END set_notification_attr;
4077:
4078: /*=========================================================================
4079: API name : set_email_attr

Line 4447: FND_MSG_PUB.initialize;

4443:
4444: DBMS_TRANSACTION.SAVEPOINT(l_api_name);
4445: -- Initialize message list if p_init_msg_list is set to TRUE.
4446: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4447: FND_MSG_PUB.initialize;
4448: END IF;
4449:
4450: -- Initialize API return status to success
4451: x_return_status := G_RET_STS_SUCCESS;

Line 4456: FND_MSG_PUB.add;

4452:
4453: IF p_wf_attributes.contract_id IS NULL THEN
4454: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
4455: FND_MESSAGE.SET_TOKEN('HDR_ID','NULL');
4456: FND_MSG_PUB.add;
4457: RAISE FND_API.G_EXC_ERROR;
4458: END IF;
4459:
4460: IF p_wf_attributes.item_key IS NOT NULL THEN

Line 4681: FND_MSG_PUB.add;

4677: ' Please check the workflow background engine');
4678: END IF;
4679: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NO_WF_PROCESS');
4680: FND_MESSAGE.SET_TOKEN('CONTRACT_NUMBER',l_contract_number);
4681: FND_MSG_PUB.add;
4682: RAISE FND_API.G_EXC_ERROR;
4683: ELSE
4684: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4685: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4703: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

4699:
4700: EXCEPTION
4701: WHEN FND_API.G_EXC_ERROR THEN
4702: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
4703: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4704: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4705: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
4706: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
4707: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

Line 4717: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

4713: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
4714: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
4715: ||SQLCODE||', sqlerrm = '||SQLERRM);
4716: END IF;
4717: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4718: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4719: x_return_status := G_RET_STS_UNEXP_ERROR ;
4720: END launch_k_process_wf;
4721:

Line 4718: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

4714: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
4715: ||SQLCODE||', sqlerrm = '||SQLERRM);
4716: END IF;
4717: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4718: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4719: x_return_status := G_RET_STS_UNEXP_ERROR ;
4720: END launch_k_process_wf;
4721:
4722: /*=========================================================================

Line 4779: FND_MSG_PUB.initialize;

4775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4776: END IF;
4777: -- Initialize message list if p_init_msg_list is set to TRUE.
4778: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4779: FND_MSG_PUB.initialize;
4780: END IF;
4781:
4782: -- Initialize API return status to success
4783: x_return_status := G_RET_STS_SUCCESS;

Line 4788: FND_MSG_PUB.add;

4784:
4785: IF p_contract_id IS NULL THEN
4786: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
4787: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
4788: FND_MSG_PUB.add;
4789: RAISE FND_API.G_EXC_ERROR;
4790: END IF;
4791:
4792: IF p_item_key IS NULL THEN

Line 4796: FND_MSG_PUB.add;

4792: IF p_item_key IS NULL THEN
4793: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
4794: IF l_item_key IS NULL THEN
4795: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
4796: FND_MSG_PUB.add;
4797: RAISE FND_API.G_EXC_ERROR;
4798: END IF;
4799: ELSE
4800: l_item_key := p_item_key;

Line 4839: FND_MSG_PUB.add;

4835: END IF;
4836: ELSE
4837: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_RE_PUBLISH_ACTION');
4838: FND_MESSAGE.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
4839: FND_MSG_PUB.add;
4840: RAISE FND_API.G_EXC_ERROR;
4841: END IF;
4842:
4843: IF FND_API.to_boolean( p_commit ) THEN

Line 4848: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);

4844: COMMIT;
4845: END IF;
4846:
4847: -- Standard call to get message count and if count is 1, get message info.
4848: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);
4849:
4850: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4851: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
4852: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 4858: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

4854:
4855: EXCEPTION
4856: WHEN FND_API.G_EXC_ERROR THEN
4857: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
4858: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4859: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4860: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
4861: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
4862: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

Line 4867: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

4863: END IF;
4864: x_return_status := G_RET_STS_ERROR;
4865: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4866: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
4867: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4868: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4869: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
4870: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
4871: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

Line 4881: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

4877: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
4878: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
4879: ||SQLCODE||', sqlerrm = '||SQLERRM);
4880: END IF;
4881: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4882: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4883: x_return_status := G_RET_STS_UNEXP_ERROR ;
4884: END assign_new_qto_contact;
4885:

Line 4882: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

4878: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
4879: ||SQLCODE||', sqlerrm = '||SQLERRM);
4880: END IF;
4881: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4882: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4883: x_return_status := G_RET_STS_UNEXP_ERROR ;
4884: END assign_new_qto_contact;
4885:
4886: /*=========================================================================

Line 4941: FND_MSG_PUB.initialize;

4937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4938: END IF;
4939: -- Initialize message list if p_init_msg_list is set to TRUE.
4940: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4941: FND_MSG_PUB.initialize;
4942: END IF;
4943:
4944: -- Initialize API return status to success
4945: x_return_status := G_RET_STS_SUCCESS;

Line 4950: FND_MSG_PUB.add;

4946:
4947: IF p_contract_id IS NULL THEN
4948: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
4949: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
4950: FND_MSG_PUB.add;
4951: RAISE FND_API.G_EXC_ERROR;
4952: END IF;
4953:
4954: IF p_item_key IS NULL THEN

Line 4958: FND_MSG_PUB.add;

4954: IF p_item_key IS NULL THEN
4955: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
4956: IF l_item_key IS NULL THEN
4957: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
4958: FND_MSG_PUB.add;
4959: RAISE FND_API.G_EXC_ERROR;
4960: END IF;
4961: ELSE
4962: l_item_key := p_item_key;

Line 5006: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);

5002:
5003: END IF; -- Added for Bug#14150408
5004:
5005: -- Standard call to get message count and if count is 1, get message info.
5006: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);
5007:
5008: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5009: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
5010: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 5016: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

5012:
5013: EXCEPTION
5014: WHEN FND_API.G_EXC_ERROR THEN
5015: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
5016: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5017: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5018: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
5019: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
5020: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

Line 5025: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

5021: END IF;
5022: x_return_status := G_RET_STS_ERROR;
5023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5024: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
5025: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5026: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5027: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
5028: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
5029: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

Line 5039: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

5035: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
5036: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
5037: ||SQLCODE||', sqlerrm = '||SQLERRM);
5038: END IF;
5039: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5040: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5041: x_return_status := G_RET_STS_UNEXP_ERROR ;
5042: END clean_wf;
5043:

Line 5040: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

5036: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
5037: ||SQLCODE||', sqlerrm = '||SQLERRM);
5038: END IF;
5039: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5040: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5041: x_return_status := G_RET_STS_UNEXP_ERROR ;
5042: END clean_wf;
5043:
5044: /*=========================================================================

Line 5856: FND_MSG_PUB.initialize;

5852: END IF;
5853:
5854: -- Initialize message list if p_init_msg_list is set to TRUE.
5855: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5856: FND_MSG_PUB.initialize;
5857: END IF;
5858:
5859: -- Initialize API return status to success
5860: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5865: FND_MSG_PUB.add;

5861:
5862: IF p_contract_id IS NULL THEN
5863: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
5864: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
5865: FND_MSG_PUB.add;
5866: RAISE FND_API.G_EXC_ERROR;
5867: END IF;
5868:
5869: IF p_item_key IS NULL THEN

Line 5873: FND_MSG_PUB.add;

5869: IF p_item_key IS NULL THEN
5870: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
5871: IF l_item_key IS NULL THEN
5872: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
5873: FND_MSG_PUB.add;
5874: RAISE FND_API.G_EXC_ERROR;
5875: END IF;
5876: ELSE
5877: l_item_key := p_item_key;

Line 5896: FND_MSG_PUB.add;

5892: x_return_status := G_RET_STS_SUCCESS;
5893: ELSIF x_activity_name = G_CUST_ACTION THEN
5894: FND_MESSAGE.set_name(G_APP_NAME,'OKS_WAIT_CUST_ACCEPTANCE');
5895: FND_MESSAGE.SET_TOKEN('K_NUMBER',get_concat_k_number(p_contract_id));
5896: FND_MSG_PUB.add;
5897: x_return_status := G_RET_STS_WARNING;
5898: x_activity_name := G_CUST_ACTION;
5899: ELSE
5900: FND_MESSAGE.set_name(G_APP_NAME,'OKS_SUBMIT_APRVL_NOT_ALWD');

Line 5902: FND_MSG_PUB.add;

5898: x_activity_name := G_CUST_ACTION;
5899: ELSE
5900: FND_MESSAGE.set_name(G_APP_NAME,'OKS_SUBMIT_APRVL_NOT_ALWD');
5901: FND_MESSAGE.SET_TOKEN('K_NUMBER',get_concat_k_number(p_contract_id));
5902: FND_MSG_PUB.add;
5903: RAISE FND_API.G_EXC_ERROR;
5904: END IF;
5905: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5906: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,

Line 5911: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);

5907: 'Activity: '||x_activity_name||' Return status '||x_return_status);
5908: END IF;
5909:
5910: -- Standard call to get message count and if count is 1, get message info.
5911: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);
5912:
5913: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5914: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
5915: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 5921: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

5917:
5918: EXCEPTION
5919: WHEN FND_API.G_EXC_ERROR THEN
5920: x_return_status := G_RET_STS_ERROR;
5921: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5922: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5923: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
5924: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ERROR');
5925: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,get_fnd_message);

Line 5934: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

5930: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
5931: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
5932: ||SQLCODE||', sqlerrm = '||SQLERRM);
5933: END IF;
5934: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5935: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5936: END is_submit_for_approval_allowed;
5937:
5938: FUNCTION set_user_context

Line 5935: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

5931: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
5932: ||SQLCODE||', sqlerrm = '||SQLERRM);
5933: END IF;
5934: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5935: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5936: END is_submit_for_approval_allowed;
5937:
5938: FUNCTION set_user_context
5939: (

Line 6118: FND_MSG_PUB.initialize;

6114: END IF;
6115:
6116: -- Initialize message list if p_init_msg_list is set to TRUE.
6117: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6118: FND_MSG_PUB.initialize;
6119: END IF;
6120:
6121: -- Initialize API return status to success
6122: x_return_status := G_RET_STS_SUCCESS;

Line 6127: FND_MSG_PUB.add;

6123:
6124: IF p_contract_id IS NULL THEN
6125: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
6126: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
6127: FND_MSG_PUB.add;
6128: RAISE FND_API.G_EXC_ERROR;
6129: END IF;
6130:
6131: -- Check whether submit for approval actions is applicable for this contract

Line 6142: FND_MSG_PUB.add;

6138: IF p_item_key IS NULL THEN
6139: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
6140: IF l_item_key IS NULL THEN
6141: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
6142: FND_MSG_PUB.add;
6143: RAISE FND_API.G_EXC_ERROR;
6144: END IF;
6145: ELSE
6146: l_item_key := p_item_key;

Line 6179: FND_MSG_PUB.add;

6175: ,p_item_key => l_item_key
6176: );
6177: IF l_activity_name NOT IN (G_SALESREP_ACTION, G_CUST_ACTION) THEN
6178: FND_MESSAGE.set_name(G_APP_NAME,'OKS_SUBMIT_APPROVAL_NOT_ALLOWED');
6179: FND_MSG_PUB.add;
6180: RAISE FND_API.G_EXC_ERROR;
6181: ELSIF l_activity_name = G_CUST_ACTION THEN
6182:
6183: -- bug 5845505, send email only if template for the document type is setup

Line 6350: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);

6346: IF FND_API.to_boolean( p_commit ) THEN
6347: COMMIT;
6348: END IF;
6349: -- Standard call to get message count and if count is 1, get message info.
6350: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);
6351:
6352: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6353: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6354: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 6360: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

6356:
6357: EXCEPTION
6358: WHEN ActionNotAllowedException THEN
6359: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
6360: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6361: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6362: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
6363: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ActionNotAllowedException '||
6364: ' Contract is either waiting for customer acceptance or not in entered status');

Line 6368: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

6364: ' Contract is either waiting for customer acceptance or not in entered status');
6365: END IF;
6366: WHEN FND_API.G_EXC_ERROR THEN
6367: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
6368: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6369: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6370: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6371: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
6372: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

Line 6377: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

6373: END IF;
6374: x_return_status := G_RET_STS_ERROR;
6375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6376: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
6377: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6378: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6379: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6380: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
6381: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

Line 6391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

6387: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
6388: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
6389: ||SQLCODE||', sqlerrm = '||SQLERRM);
6390: END IF;
6391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6392: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6393: x_return_status := G_RET_STS_UNEXP_ERROR ;
6394: END submit_for_approval;
6395:

Line 6392: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

6388: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
6389: ||SQLCODE||', sqlerrm = '||SQLERRM);
6390: END IF;
6391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6392: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6393: x_return_status := G_RET_STS_UNEXP_ERROR ;
6394: END submit_for_approval;
6395:
6396: /*=========================================================================

Line 6456: FND_MSG_PUB.initialize;

6452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6453: END IF;
6454: -- Initialize message list if p_init_msg_list is set to TRUE.
6455: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6456: FND_MSG_PUB.initialize;
6457: END IF;
6458:
6459: -- Initialize API return status to success
6460: x_return_status := G_RET_STS_SUCCESS;

Line 6465: FND_MSG_PUB.add;

6461:
6462: IF p_contract_id IS NULL THEN
6463: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
6464: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
6465: FND_MSG_PUB.add;
6466: RAISE FND_API.G_EXC_ERROR;
6467: END IF;
6468:
6469: OPEN l_nego_sts_csr (p_contract_id);

Line 6495: FND_MSG_PUB.add;

6491: IF p_item_key IS NULL THEN
6492: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
6493: IF l_item_key IS NULL THEN
6494: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
6495: FND_MSG_PUB.add;
6496: RAISE FND_API.G_EXC_ERROR;
6497: END IF;
6498: ELSE
6499: l_item_key := p_item_key;

Line 6547: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);

6543: COMMIT;
6544: END IF;
6545:
6546: -- Standard call to get message count and if count is 1, get message info.
6547: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);
6548:
6549: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6550: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6551: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 6557: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

6553:
6554: EXCEPTION
6555: WHEN ActionNotAllowedException THEN
6556: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
6557: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6558: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6559: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
6560: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ActionNotAllowedException '||
6561: ' Contract cannot be published since it is not in entered status');

Line 6566: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

6562: END IF;
6563: x_return_status := G_RET_STS_ACTION_NOT_ALWD;
6564: WHEN AlreadyPublishedException THEN
6565: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
6566: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6567: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6568: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6569: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from AlreadyPublishedException');
6570: END IF;

Line 6574: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

6570: END IF;
6571: x_return_status := G_RET_STS_ALREADY_PUBLISHED;
6572: WHEN FND_API.G_EXC_ERROR THEN
6573: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
6574: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6575: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6576: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6577: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
6578: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

Line 6583: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

6579: END IF;
6580: x_return_status := G_RET_STS_ERROR;
6581: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6582: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
6583: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6584: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6585: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6586: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
6587: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

Line 6597: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

6593: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
6594: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
6595: ||SQLCODE||', sqlerrm = '||SQLERRM);
6596: END IF;
6597: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6598: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6599: x_return_status := G_RET_STS_UNEXP_ERROR ;
6600: END publish_to_customer;
6601:

Line 6598: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

6594: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
6595: ||SQLCODE||', sqlerrm = '||SQLERRM);
6596: END IF;
6597: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6598: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6599: x_return_status := G_RET_STS_UNEXP_ERROR ;
6600: END publish_to_customer;
6601:
6602: /*=========================================================================

Line 6701: FND_MSG_PUB.add;

6697: l_qa_rec.contract_number_modifier);
6698: ELSE
6699: FND_MESSAGE.SET_TOKEN('CONTRACT_NUM',l_qa_rec.contract_number);
6700: END IF;
6701: FND_MSG_PUB.add;
6702: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6703: FND_LOG.STRING(FND_LOG.LEVEL_ERROR ,G_MODULE||l_api_name,'Invalid QA checklist ');
6704: END IF;
6705: RAISE FND_API.G_EXC_ERROR;

Line 6784: FND_MSG_PUB.initialize;

6780: IF l_qa_calling_process = G_NEG_STS_PEND_PUBLISH THEN
6781:
6782: -- Message stack is initialized since QA checks above will post
6783: -- 'Contracts QA process has completed successfully' message after completion
6784: FND_MSG_PUB.initialize;
6785: -- Since we are here we know that this QA check is called from Online process
6786: -- There are two qualifying paths for which a process can enter into this IF condition
6787: -- 1.Online process, 2.Publish quote online process
6788: BEGIN

Line 6798: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );

6794: RAISE FND_API.G_EXC_ERROR;
6795: END IF;
6796: EXCEPTION
6797: WHEN FND_API.G_EXC_ERROR THEN
6798: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );
6799: -- Set the message only when a vacant message item attribute is available
6800: IF (l_msg_ctr < 10) THEN
6801: wf_engine.SetItemAttrText
6802: (

Line 8091: FND_MSG_PUB.initialize;

8087: END IF;
8088:
8089: -- Initialize message list if p_init_msg_list is set to TRUE.
8090: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8091: FND_MSG_PUB.initialize;
8092: END IF;
8093:
8094: -- Initialize API return status to success
8095: x_return_status := G_RET_STS_SUCCESS;

Line 8100: FND_MSG_PUB.add;

8096:
8097: IF p_contract_id IS NULL THEN
8098: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
8099: FND_MESSAGE.SET_TOKEN('HDR_ID','NULL');
8100: FND_MSG_PUB.add;
8101: RAISE FND_API.G_EXC_ERROR;
8102: END IF;
8103:
8104: IF p_item_key IS NULL THEN

Line 8108: FND_MSG_PUB.add;

8104: IF p_item_key IS NULL THEN
8105: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
8106: IF l_item_key IS NULL THEN
8107: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
8108: FND_MSG_PUB.add;
8109: RAISE FND_API.G_EXC_ERROR;
8110: END IF;
8111: ELSE
8112: l_item_key := p_item_key;

Line 8168: FND_MSG_PUB.add;

8164: ,p_item_key => l_item_key
8165: );
8166: IF l_activity_name NOT IN (G_SALESREP_ACTION, G_CUST_ACTION) THEN
8167: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INV_SALESREP_ACPT_ACTION');
8168: FND_MSG_PUB.add;
8169: RAISE FND_API.G_EXC_ERROR;
8170: END IF;
8171:
8172: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 8202: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);

8198: COMMIT;
8199: END IF;
8200:
8201: -- Standard call to get message count and if count is 1, get message info.
8202: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);
8203:
8204: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8205: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
8206: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 8212: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

8208:
8209: EXCEPTION
8210: WHEN FND_API.G_EXC_ERROR THEN
8211: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
8212: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
8213: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8214: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
8215: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
8216: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

Line 8221: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

8217: END IF;
8218: x_return_status := G_RET_STS_ERROR;
8219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8220: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
8221: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
8222: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8223: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
8224: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
8225: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

Line 8235: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

8231: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
8232: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
8233: ||SQLCODE||', sqlerrm = '||SQLERRM);
8234: END IF;
8235: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
8236: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
8237: x_return_status := G_RET_STS_UNEXP_ERROR ;
8238: END accept_quote;
8239:

Line 8236: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

8232: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
8233: ||SQLCODE||', sqlerrm = '||SQLERRM);
8234: END IF;
8235: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
8236: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
8237: x_return_status := G_RET_STS_UNEXP_ERROR ;
8238: END accept_quote;
8239:
8240: /*=========================================================================

Line 8324: FND_MSG_PUB.initialize;

8320: END IF;
8321:
8322: -- Initialize message list if p_init_msg_list is set to TRUE.
8323: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8324: FND_MSG_PUB.initialize;
8325: END IF;
8326:
8327: -- Initialize API return status to success
8328: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8333: FND_MSG_PUB.add;

8329:
8330: IF p_contract_id IS NULL THEN
8331: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
8332: FND_MESSAGE.SET_TOKEN('HDR_ID','NULL');
8333: FND_MSG_PUB.add;
8334: RAISE FND_API.G_EXC_ERROR;
8335: END IF;
8336:
8337: IF p_item_key IS NULL THEN

Line 8341: FND_MSG_PUB.add;

8337: IF p_item_key IS NULL THEN
8338: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
8339: IF l_item_key IS NULL THEN
8340: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
8341: FND_MSG_PUB.add;
8342: RAISE FND_API.G_EXC_ERROR;
8343: END IF;
8344: ELSE
8345: l_item_key := p_item_key;

Line 8548: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);

8544: COMMIT;
8545: END IF;
8546:
8547: -- Standard call to get message count and if count is 1, get message info.
8548: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);
8549:
8550: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8551: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
8552: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 8579: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

8575: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
8576: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
8577: ||SQLCODE||', sqlerrm = '||SQLERRM);
8578: END IF;
8579: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
8580: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
8581: x_return_status := G_RET_STS_UNEXP_ERROR ;
8582: END cancel_contract;
8583:

Line 8580: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

8576: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
8577: ||SQLCODE||', sqlerrm = '||SQLERRM);
8578: END IF;
8579: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
8580: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
8581: x_return_status := G_RET_STS_UNEXP_ERROR ;
8582: END cancel_contract;
8583:
8584: /*=========================================================================

Line 8939: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.get(j, 'F'));

8935: --try the next batch
8936: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
8937: l_errcount := l_errcount + l_k_rec_tbl.COUNT;
8938: FOR j IN 1..l_msg_count LOOP
8939: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.get(j, 'F'));
8940: END LOOP;
8941: RAISE FND_API.g_exc_unexpected_error;
8942: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
8943: --just log the error and continue

Line 8947: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.get(j, 'F'));

8943: --just log the error and continue
8944: l_errcount := l_errcount + l_k_rec_tbl.COUNT;
8945: retcode := 1;
8946: FOR j IN 1..l_msg_count LOOP
8947: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.get(j, 'F'));
8948: END LOOP;
8949: ELSE
8950: l_wfcount := l_wfcount + l_k_rec_tbl.COUNT;
8951: END IF;

Line 9067: FND_MSG_PUB.initialize;

9063: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
9064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9065: END IF;
9066: IF FND_API.to_boolean(p_init_msg_list ) THEN
9067: FND_MSG_PUB.initialize;
9068: END IF;
9069: x_return_status := FND_API.G_RET_STS_SUCCESS;
9070:
9071: IF (p_wf_attributes_tbl.count = 0 ) THEN

Line 9248: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

9244: END IF;
9245: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9246: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
9247: END IF;
9248: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
9249:
9250: EXCEPTION
9251: WHEN FND_API.g_exc_error THEN
9252: ROLLBACK TO launch_k_process_wf_blk_PVT;

Line 9258: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

9254:
9255: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
9256: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
9257: END IF;
9258: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
9259:
9260: WHEN FND_API.g_exc_unexpected_error THEN
9261: ROLLBACK TO launch_k_process_wf_blk_PVT;
9262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 9267: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

9263:
9264: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
9265: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
9266: END IF;
9267: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
9268:
9269: WHEN OTHERS THEN
9270: ROLLBACK TO launch_k_process_wf_blk_PVT;
9271:

Line 9280: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_wf_err_name||' '||l_wf_err_msg);

9276: --workflow error
9277: WF_CORE.clear;
9278: --set the status to error, so that calling program can handle it
9279: x_return_status := FND_API.g_ret_sts_error ;
9280: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_wf_err_name||' '||l_wf_err_msg);
9281:
9282: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
9283: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_workflow_error', 'x_return_status=' || x_return_status);
9284: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_workflow_error', 'err_name=' || l_wf_err_name||', err_msg='|| l_wf_err_msg||',err_stack='|| l_wf_err_stack);

Line 9296: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

9292: --first log the sqlerrm
9293: l_error_text := substr (SQLERRM, 1, 240);
9294: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
9295: --then add it to the message api list
9296: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
9297: END IF;
9298: END IF;
9299:
9300: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

Line 9300: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

9296: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
9297: END IF;
9298: END IF;
9299:
9300: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
9301:
9302: END launch_k_process_wf_blk;
9303:
9304: END OKS_WF_K_PROCESS_PVT;