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 2500: FND_MSG_PUB.initialize;

2496: END IF;
2497:
2498: -- Initialize message list if p_init_msg_list is set to TRUE.
2499: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2500: FND_MSG_PUB.initialize;
2501: END IF;
2502:
2503: -- Initialize API return status to success
2504: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2510: FND_MSG_PUB.add;

2506: IF p_item_key IS NULL THEN
2507: l_item_key := get_wf_item_key(p_contract_id);
2508: IF l_item_key IS NULL THEN
2509: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
2510: FND_MSG_PUB.add;
2511: RAISE FND_API.G_EXC_ERROR;
2512: END IF;
2513: ELSE
2514: l_item_key := p_item_key;

Line 2687: fnd_msg_pub.add;

2683: ELSE
2684: -- invalid activity
2685: fnd_message.set_name(G_APP_NAME,'OKS_INVALID_CUST_ACPT_ACTION');
2686: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
2687: fnd_msg_pub.add;
2688: RAISE FND_API.G_EXC_ERROR;
2689: END IF;
2690:
2691: IF FND_API.to_boolean( p_commit ) THEN

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

2692: COMMIT;
2693: END IF;
2694:
2695: -- Standard call to get message count and if count is 1, get message info.
2696: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2697:
2698: -- end debug log
2699: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2700: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,

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

2702: END IF;
2703: EXCEPTION
2704: WHEN FND_API.G_EXC_ERROR THEN
2705: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
2706: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2707: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2708: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
2709: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
2710: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

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

2711: END IF;
2712: x_return_status := G_RET_STS_ERROR;
2713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2714: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
2715: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2716: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2717: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
2718: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
2719: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

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

2725: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2726: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
2727: ||SQLCODE||', sqlerrm = '||SQLERRM);
2728: END IF;
2729: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2730: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2731: x_return_status := G_RET_STS_UNEXP_ERROR ;
2732: END customer_accept_quote;
2733:

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

2726: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
2727: ||SQLCODE||', sqlerrm = '||SQLERRM);
2728: END IF;
2729: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2730: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2731: x_return_status := G_RET_STS_UNEXP_ERROR ;
2732: END customer_accept_quote;
2733:
2734: ---------------------------------------------------

Line 2792: FND_MSG_PUB.initialize;

2788: END IF;
2789:
2790: -- Initialize message list if p_init_msg_list is set to TRUE.
2791: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2792: FND_MSG_PUB.initialize;
2793: END IF;
2794:
2795: -- Initialize API return status to success
2796: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2802: FND_MSG_PUB.add;

2798: IF p_item_key IS NULL THEN
2799: l_item_key := get_wf_item_key(p_contract_id);
2800: IF l_item_key IS NULL THEN
2801: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
2802: FND_MSG_PUB.add;
2803: RAISE FND_API.G_EXC_ERROR;
2804: END IF;
2805: ELSE
2806: l_item_key := p_item_key;

Line 2998: fnd_msg_pub.add;

2994: END IF;
2995: ELSE
2996: FND_MESSAGE.set_name('OKS','OKS_CANT_CANCEL_K'); -- set the message here
2997: FND_MESSAGE.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
2998: fnd_msg_pub.add;
2999: RAISE FND_API.G_EXC_ERROR;
3000: END IF;
3001: ELSE
3002: -- invalid activity

Line 3005: fnd_msg_pub.add;

3001: ELSE
3002: -- invalid activity
3003: fnd_message.set_name(G_APP_NAME,'OKS_INVALID_CUST_DCLN_ACTION');
3004: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3005: fnd_msg_pub.add;
3006: RAISE FND_API.G_EXC_ERROR;
3007: END IF;
3008:
3009: IF FND_API.to_boolean( p_commit ) THEN

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

3010: COMMIT;
3011: END IF;
3012:
3013: -- Standard call to get message count and if count is 1, get message info.
3014: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3015:
3016: -- end debug log
3017: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3018: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

3021:
3022: EXCEPTION
3023: WHEN FND_API.G_EXC_ERROR THEN
3024: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
3025: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3026: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3027: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3028: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
3029: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

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

3030: END IF;
3031: x_return_status := G_RET_STS_ERROR;
3032: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3033: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
3034: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3035: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3036: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3037: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
3038: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

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

3044: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
3045: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
3046: ||SQLCODE||', sqlerrm = '||SQLERRM);
3047: END IF;
3048: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3049: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3050: x_return_status := G_RET_STS_UNEXP_ERROR ;
3051: END customer_decline_quote;
3052:

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

3045: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
3046: ||SQLCODE||', sqlerrm = '||SQLERRM);
3047: END IF;
3048: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3049: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3050: x_return_status := G_RET_STS_UNEXP_ERROR ;
3051: END customer_decline_quote;
3052:
3053: ---------------------------------------------------

Line 3114: FND_MSG_PUB.initialize;

3110: END IF;
3111:
3112: -- Initialize message list if p_init_msg_list is set to TRUE.
3113: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3114: FND_MSG_PUB.initialize;
3115: END IF;
3116:
3117: -- Initialize API return status to success
3118: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3124: FND_MSG_PUB.add;

3120: IF p_item_key IS NULL THEN
3121: l_item_key := get_wf_item_key(p_contract_id);
3122: IF l_item_key IS NULL THEN
3123: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
3124: FND_MSG_PUB.add;
3125: RAISE FND_API.G_EXC_ERROR;
3126: END IF;
3127: ELSE
3128: l_item_key := p_item_key;

Line 3249: FND_MSG_PUB.add;

3245: WHEN OTHERS THEN
3246: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_CREATE_ADHOC_USER_FAILED');
3247: FND_MESSAGE.set_token('USER_NAME',l_user_tbl(k));
3248: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
3249: FND_MSG_PUB.add;
3250: RAISE FND_API.G_EXC_ERROR;
3251: END;
3252:
3253:

Line 3295: FND_MSG_PUB.add;

3291: WHEN OTHERS THEN
3292: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_CREATE_ADHOC_ROLE_FAILED');
3293: FND_MESSAGE.set_token('ROLE_NAME',l_role_name);
3294: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
3295: FND_MSG_PUB.add;
3296: RAISE FND_API.G_EXC_ERROR;
3297: END;
3298:
3299: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 3414: FND_MSG_PUB.add;

3410: ELSE
3411: -- invalid activity
3412: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_REQ_ASST_ACTION');
3413: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3414: FND_MSG_PUB.add;
3415: RAISE FND_API.G_EXC_ERROR;
3416: END IF;
3417:
3418: IF FND_API.to_boolean( p_commit ) THEN

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

3419: COMMIT;
3420: END IF;
3421:
3422: -- Standard call to get message count and if count is 1, get message info.
3423: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3424:
3425: -- end debug log
3426: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3427: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,

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

3430:
3431: EXCEPTION
3432: WHEN FND_API.G_EXC_ERROR THEN
3433: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
3434: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3435: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3436: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3437: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
3438: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

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

3439: END IF;
3440: x_return_status := G_RET_STS_ERROR;
3441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3442: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
3443: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3444: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3445: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3446: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
3447: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

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

3453: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
3454: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
3455: ||SQLCODE||', sqlerrm = '||SQLERRM);
3456: END IF;
3457: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3458: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3459: x_return_status := G_RET_STS_UNEXP_ERROR ;
3460: END customer_request_assistance;
3461:

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

3454: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
3455: ||SQLCODE||', sqlerrm = '||SQLERRM);
3456: END IF;
3457: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3458: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3459: x_return_status := G_RET_STS_UNEXP_ERROR ;
3460: END customer_request_assistance;
3461:
3462: /*=========================================================================

Line 3515: FND_MSG_PUB.initialize;

3511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3512: END IF;
3513:
3514: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3515: FND_MSG_PUB.initialize;
3516: END IF;
3517:
3518: -- Initialize API return status to success
3519: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3547: COMMIT;
3548: END IF;
3549:
3550: -- Standard call to get message count and if count is 1, get message info.
3551: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);
3552:
3553: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3554: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3555: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);

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

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

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

3566: END IF;
3567: x_return_status := G_RET_STS_ERROR;
3568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3569: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
3570: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3571: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3572: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3573: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
3574: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

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

3580: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
3581: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
3582: ||SQLCODE||', sqlerrm = '||SQLERRM);
3583: END IF;
3584: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3585: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3586: x_return_status := G_RET_STS_UNEXP_ERROR ;
3587: END update_negotiation_status;
3588:

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

3581: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
3582: ||SQLCODE||', sqlerrm = '||SQLERRM);
3583: END IF;
3584: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3585: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3586: x_return_status := G_RET_STS_UNEXP_ERROR ;
3587: END update_negotiation_status;
3588:
3589: /*=========================================================================

Line 3889: FND_MSG_PUB.add;

3885:
3886: IF p_contract_id IS NULL THEN
3887: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
3888: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
3889: FND_MSG_PUB.add;
3890: RAISE FND_API.G_EXC_ERROR;
3891: END IF;
3892:
3893: l_notif_attr_rec.CONTRACT_ID := p_contract_id;

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

3939:
3940: EXCEPTION
3941: WHEN FND_API.G_EXC_ERROR THEN
3942: x_return_status := G_RET_STS_ERROR;
3943: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3944: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3945: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
3946: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ERROR');
3947: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,get_fnd_message);

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

3952: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
3953: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
3954: ||SQLCODE||', sqlerrm = '||SQLERRM);
3955: END IF;
3956: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3957: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3958: END set_notification_attr;
3959:
3960: /*=========================================================================

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

3953: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
3954: ||SQLCODE||', sqlerrm = '||SQLERRM);
3955: END IF;
3956: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3957: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3958: END set_notification_attr;
3959:
3960: /*=========================================================================
3961: API name : set_email_attr

Line 4320: FND_MSG_PUB.initialize;

4316:
4317: DBMS_TRANSACTION.SAVEPOINT(l_api_name);
4318: -- Initialize message list if p_init_msg_list is set to TRUE.
4319: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4320: FND_MSG_PUB.initialize;
4321: END IF;
4322:
4323: -- Initialize API return status to success
4324: x_return_status := G_RET_STS_SUCCESS;

Line 4329: FND_MSG_PUB.add;

4325:
4326: IF p_wf_attributes.contract_id IS NULL THEN
4327: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
4328: FND_MESSAGE.SET_TOKEN('HDR_ID','NULL');
4329: FND_MSG_PUB.add;
4330: RAISE FND_API.G_EXC_ERROR;
4331: END IF;
4332:
4333: IF p_wf_attributes.item_key IS NOT NULL THEN

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

4544:
4545: EXCEPTION
4546: WHEN FND_API.G_EXC_ERROR THEN
4547: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
4548: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4549: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4550: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
4551: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
4552: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

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

4558: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
4559: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
4560: ||SQLCODE||', sqlerrm = '||SQLERRM);
4561: END IF;
4562: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4563: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4564: x_return_status := G_RET_STS_UNEXP_ERROR ;
4565: END launch_k_process_wf;
4566:

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

4559: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
4560: ||SQLCODE||', sqlerrm = '||SQLERRM);
4561: END IF;
4562: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4563: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4564: x_return_status := G_RET_STS_UNEXP_ERROR ;
4565: END launch_k_process_wf;
4566:
4567: /*=========================================================================

Line 4624: FND_MSG_PUB.initialize;

4620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4621: END IF;
4622: -- Initialize message list if p_init_msg_list is set to TRUE.
4623: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4624: FND_MSG_PUB.initialize;
4625: END IF;
4626:
4627: -- Initialize API return status to success
4628: x_return_status := G_RET_STS_SUCCESS;

Line 4633: FND_MSG_PUB.add;

4629:
4630: IF p_contract_id IS NULL THEN
4631: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
4632: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
4633: FND_MSG_PUB.add;
4634: RAISE FND_API.G_EXC_ERROR;
4635: END IF;
4636:
4637: IF p_item_key IS NULL THEN

Line 4641: FND_MSG_PUB.add;

4637: IF p_item_key IS NULL THEN
4638: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
4639: IF l_item_key IS NULL THEN
4640: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
4641: FND_MSG_PUB.add;
4642: RAISE FND_API.G_EXC_ERROR;
4643: END IF;
4644: ELSE
4645: l_item_key := p_item_key;

Line 4684: FND_MSG_PUB.add;

4680: END IF;
4681: ELSE
4682: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_RE_PUBLISH_ACTION');
4683: FND_MESSAGE.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
4684: FND_MSG_PUB.add;
4685: RAISE FND_API.G_EXC_ERROR;
4686: END IF;
4687:
4688: IF FND_API.to_boolean( p_commit ) THEN

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

4689: COMMIT;
4690: END IF;
4691:
4692: -- Standard call to get message count and if count is 1, get message info.
4693: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);
4694:
4695: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4696: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
4697: 'Leaving '||G_PKG_NAME ||'.'||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 4712: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

4708: END IF;
4709: x_return_status := G_RET_STS_ERROR;
4710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4711: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
4712: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4713: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4714: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
4715: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
4716: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

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

4722: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
4723: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
4724: ||SQLCODE||', sqlerrm = '||SQLERRM);
4725: END IF;
4726: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4727: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4728: x_return_status := G_RET_STS_UNEXP_ERROR ;
4729: END assign_new_qto_contact;
4730:

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

4723: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
4724: ||SQLCODE||', sqlerrm = '||SQLERRM);
4725: END IF;
4726: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4727: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4728: x_return_status := G_RET_STS_UNEXP_ERROR ;
4729: END assign_new_qto_contact;
4730:
4731: /*=========================================================================

Line 4786: FND_MSG_PUB.initialize;

4782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4783: END IF;
4784: -- Initialize message list if p_init_msg_list is set to TRUE.
4785: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4786: FND_MSG_PUB.initialize;
4787: END IF;
4788:
4789: -- Initialize API return status to success
4790: x_return_status := G_RET_STS_SUCCESS;

Line 4795: FND_MSG_PUB.add;

4791:
4792: IF p_contract_id IS NULL THEN
4793: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
4794: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
4795: FND_MSG_PUB.add;
4796: RAISE FND_API.G_EXC_ERROR;
4797: END IF;
4798:
4799: IF p_item_key IS NULL THEN

Line 4803: FND_MSG_PUB.add;

4799: IF p_item_key IS NULL THEN
4800: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
4801: IF l_item_key IS NULL THEN
4802: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
4803: FND_MSG_PUB.add;
4804: RAISE FND_API.G_EXC_ERROR;
4805: END IF;
4806: ELSE
4807: l_item_key := p_item_key;

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

4836: COMMIT;
4837: END IF;
4838:
4839: -- Standard call to get message count and if count is 1, get message info.
4840: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);
4841:
4842: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4843: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
4844: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);

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

4846:
4847: EXCEPTION
4848: WHEN FND_API.G_EXC_ERROR THEN
4849: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
4850: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4851: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4852: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
4853: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
4854: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

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

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

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

4869: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
4870: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
4871: ||SQLCODE||', sqlerrm = '||SQLERRM);
4872: END IF;
4873: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4874: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4875: x_return_status := G_RET_STS_UNEXP_ERROR ;
4876: END clean_wf;
4877:

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

4870: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
4871: ||SQLCODE||', sqlerrm = '||SQLERRM);
4872: END IF;
4873: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4874: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4875: x_return_status := G_RET_STS_UNEXP_ERROR ;
4876: END clean_wf;
4877:
4878: /*=========================================================================

Line 5552: FND_MSG_PUB.initialize;

5548: END IF;
5549:
5550: -- Initialize message list if p_init_msg_list is set to TRUE.
5551: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5552: FND_MSG_PUB.initialize;
5553: END IF;
5554:
5555: -- Initialize API return status to success
5556: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5561: FND_MSG_PUB.add;

5557:
5558: IF p_contract_id IS NULL THEN
5559: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
5560: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
5561: FND_MSG_PUB.add;
5562: RAISE FND_API.G_EXC_ERROR;
5563: END IF;
5564:
5565: IF p_item_key IS NULL THEN

Line 5569: FND_MSG_PUB.add;

5565: IF p_item_key IS NULL THEN
5566: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
5567: IF l_item_key IS NULL THEN
5568: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
5569: FND_MSG_PUB.add;
5570: RAISE FND_API.G_EXC_ERROR;
5571: END IF;
5572: ELSE
5573: l_item_key := p_item_key;

Line 5592: FND_MSG_PUB.add;

5588: x_return_status := G_RET_STS_SUCCESS;
5589: ELSIF x_activity_name = G_CUST_ACTION THEN
5590: FND_MESSAGE.set_name(G_APP_NAME,'OKS_WAIT_CUST_ACCEPTANCE');
5591: FND_MESSAGE.SET_TOKEN('K_NUMBER',get_concat_k_number(p_contract_id));
5592: FND_MSG_PUB.add;
5593: x_return_status := G_RET_STS_WARNING;
5594: x_activity_name := G_CUST_ACTION;
5595: ELSE
5596: FND_MESSAGE.set_name(G_APP_NAME,'OKS_SUBMIT_APRVL_NOT_ALWD');

Line 5598: FND_MSG_PUB.add;

5594: x_activity_name := G_CUST_ACTION;
5595: ELSE
5596: FND_MESSAGE.set_name(G_APP_NAME,'OKS_SUBMIT_APRVL_NOT_ALWD');
5597: FND_MESSAGE.SET_TOKEN('K_NUMBER',get_concat_k_number(p_contract_id));
5598: FND_MSG_PUB.add;
5599: RAISE FND_API.G_EXC_ERROR;
5600: END IF;
5601: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5602: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,

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

5603: 'Activity: '||x_activity_name||' Return status '||x_return_status);
5604: END IF;
5605:
5606: -- Standard call to get message count and if count is 1, get message info.
5607: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);
5608:
5609: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5610: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
5611: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);

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

5613:
5614: EXCEPTION
5615: WHEN FND_API.G_EXC_ERROR THEN
5616: x_return_status := G_RET_STS_ERROR;
5617: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5618: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5619: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
5620: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ERROR');
5621: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,get_fnd_message);

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

5626: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
5627: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
5628: ||SQLCODE||', sqlerrm = '||SQLERRM);
5629: END IF;
5630: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5631: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5632: END is_submit_for_approval_allowed;
5633:
5634: FUNCTION set_user_context

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

5627: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
5628: ||SQLCODE||', sqlerrm = '||SQLERRM);
5629: END IF;
5630: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5631: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5632: END is_submit_for_approval_allowed;
5633:
5634: FUNCTION set_user_context
5635: (

Line 5814: FND_MSG_PUB.initialize;

5810: END IF;
5811:
5812: -- Initialize message list if p_init_msg_list is set to TRUE.
5813: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5814: FND_MSG_PUB.initialize;
5815: END IF;
5816:
5817: -- Initialize API return status to success
5818: x_return_status := G_RET_STS_SUCCESS;

Line 5823: FND_MSG_PUB.add;

5819:
5820: IF p_contract_id IS NULL THEN
5821: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
5822: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
5823: FND_MSG_PUB.add;
5824: RAISE FND_API.G_EXC_ERROR;
5825: END IF;
5826:
5827: -- Check whether submit for approval actions is applicable for this contract

Line 5838: FND_MSG_PUB.add;

5834: IF p_item_key IS NULL THEN
5835: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
5836: IF l_item_key IS NULL THEN
5837: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
5838: FND_MSG_PUB.add;
5839: RAISE FND_API.G_EXC_ERROR;
5840: END IF;
5841: ELSE
5842: l_item_key := p_item_key;

Line 5875: FND_MSG_PUB.add;

5871: ,p_item_key => l_item_key
5872: );
5873: IF l_activity_name NOT IN (G_SALESREP_ACTION, G_CUST_ACTION) THEN
5874: FND_MESSAGE.set_name(G_APP_NAME,'OKS_SUBMIT_APPROVAL_NOT_ALLOWED');
5875: FND_MSG_PUB.add;
5876: RAISE FND_API.G_EXC_ERROR;
5877: ELSIF l_activity_name = G_CUST_ACTION THEN
5878:
5879: -- bug 5845505, send email only if template for the document type is setup

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

6042: IF FND_API.to_boolean( p_commit ) THEN
6043: COMMIT;
6044: END IF;
6045: -- Standard call to get message count and if count is 1, get message info.
6046: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);
6047:
6048: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6049: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6050: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);

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

6052:
6053: EXCEPTION
6054: WHEN ActionNotAllowedException THEN
6055: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
6056: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6057: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6058: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
6059: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ActionNotAllowedException '||
6060: ' Contract is either waiting for customer acceptance or not in entered status');

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

6060: ' Contract is either waiting for customer acceptance or not in entered status');
6061: END IF;
6062: WHEN FND_API.G_EXC_ERROR THEN
6063: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
6064: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6065: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6066: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6067: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
6068: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

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

6069: END IF;
6070: x_return_status := G_RET_STS_ERROR;
6071: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6072: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
6073: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6074: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6075: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6076: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
6077: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

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

6083: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
6084: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
6085: ||SQLCODE||', sqlerrm = '||SQLERRM);
6086: END IF;
6087: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6088: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6089: x_return_status := G_RET_STS_UNEXP_ERROR ;
6090: END submit_for_approval;
6091:

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

6084: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
6085: ||SQLCODE||', sqlerrm = '||SQLERRM);
6086: END IF;
6087: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6088: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6089: x_return_status := G_RET_STS_UNEXP_ERROR ;
6090: END submit_for_approval;
6091:
6092: /*=========================================================================

Line 6152: FND_MSG_PUB.initialize;

6148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6149: END IF;
6150: -- Initialize message list if p_init_msg_list is set to TRUE.
6151: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6152: FND_MSG_PUB.initialize;
6153: END IF;
6154:
6155: -- Initialize API return status to success
6156: x_return_status := G_RET_STS_SUCCESS;

Line 6161: FND_MSG_PUB.add;

6157:
6158: IF p_contract_id IS NULL THEN
6159: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
6160: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
6161: FND_MSG_PUB.add;
6162: RAISE FND_API.G_EXC_ERROR;
6163: END IF;
6164:
6165: OPEN l_nego_sts_csr (p_contract_id);

Line 6191: FND_MSG_PUB.add;

6187: IF p_item_key IS NULL THEN
6188: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
6189: IF l_item_key IS NULL THEN
6190: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
6191: FND_MSG_PUB.add;
6192: RAISE FND_API.G_EXC_ERROR;
6193: END IF;
6194: ELSE
6195: l_item_key := p_item_key;

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

6239: COMMIT;
6240: END IF;
6241:
6242: -- Standard call to get message count and if count is 1, get message info.
6243: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);
6244:
6245: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6246: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6247: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);

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

6249:
6250: EXCEPTION
6251: WHEN ActionNotAllowedException THEN
6252: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
6253: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6254: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6255: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
6256: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ActionNotAllowedException '||
6257: ' Contract cannot be published since it is not in entered status');

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

6258: END IF;
6259: x_return_status := G_RET_STS_ACTION_NOT_ALWD;
6260: WHEN AlreadyPublishedException THEN
6261: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
6262: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6263: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6264: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6265: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from AlreadyPublishedException');
6266: END IF;

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

6266: END IF;
6267: x_return_status := G_RET_STS_ALREADY_PUBLISHED;
6268: WHEN FND_API.G_EXC_ERROR THEN
6269: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
6270: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6271: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6272: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6273: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
6274: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

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

6275: END IF;
6276: x_return_status := G_RET_STS_ERROR;
6277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6278: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
6279: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6280: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6281: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6282: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
6283: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

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

6289: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
6290: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
6291: ||SQLCODE||', sqlerrm = '||SQLERRM);
6292: END IF;
6293: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6294: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6295: x_return_status := G_RET_STS_UNEXP_ERROR ;
6296: END publish_to_customer;
6297:

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

6290: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
6291: ||SQLCODE||', sqlerrm = '||SQLERRM);
6292: END IF;
6293: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6294: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6295: x_return_status := G_RET_STS_UNEXP_ERROR ;
6296: END publish_to_customer;
6297:
6298: /*=========================================================================

Line 6397: FND_MSG_PUB.add;

6393: l_qa_rec.contract_number_modifier);
6394: ELSE
6395: FND_MESSAGE.SET_TOKEN('CONTRACT_NUM',l_qa_rec.contract_number);
6396: END IF;
6397: FND_MSG_PUB.add;
6398: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6399: FND_LOG.STRING(FND_LOG.LEVEL_ERROR ,G_MODULE||l_api_name,'Invalid QA checklist ');
6400: END IF;
6401: RAISE FND_API.G_EXC_ERROR;

Line 6480: FND_MSG_PUB.initialize;

6476: IF l_qa_calling_process = G_NEG_STS_PEND_PUBLISH THEN
6477:
6478: -- Message stack is initialized since QA checks above will post
6479: -- 'Contracts QA process has completed successfully' message after completion
6480: FND_MSG_PUB.initialize;
6481: -- Since we are here we know that this QA check is called from Online process
6482: -- There are two qualifying paths for which a process can enter into this IF condition
6483: -- 1.Online process, 2.Publish quote online process
6484: BEGIN

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

6490: RAISE FND_API.G_EXC_ERROR;
6491: END IF;
6492: EXCEPTION
6493: WHEN FND_API.G_EXC_ERROR THEN
6494: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );
6495: -- Set the message only when a vacant message item attribute is available
6496: IF (l_msg_ctr < 10) THEN
6497: wf_engine.SetItemAttrText
6498: (

Line 7787: FND_MSG_PUB.initialize;

7783: END IF;
7784:
7785: -- Initialize message list if p_init_msg_list is set to TRUE.
7786: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7787: FND_MSG_PUB.initialize;
7788: END IF;
7789:
7790: -- Initialize API return status to success
7791: x_return_status := G_RET_STS_SUCCESS;

Line 7796: FND_MSG_PUB.add;

7792:
7793: IF p_contract_id IS NULL THEN
7794: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
7795: FND_MESSAGE.SET_TOKEN('HDR_ID','NULL');
7796: FND_MSG_PUB.add;
7797: RAISE FND_API.G_EXC_ERROR;
7798: END IF;
7799:
7800: IF p_item_key IS NULL THEN

Line 7804: FND_MSG_PUB.add;

7800: IF p_item_key IS NULL THEN
7801: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
7802: IF l_item_key IS NULL THEN
7803: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
7804: FND_MSG_PUB.add;
7805: RAISE FND_API.G_EXC_ERROR;
7806: END IF;
7807: ELSE
7808: l_item_key := p_item_key;

Line 7864: FND_MSG_PUB.add;

7860: ,p_item_key => l_item_key
7861: );
7862: IF l_activity_name NOT IN (G_SALESREP_ACTION, G_CUST_ACTION) THEN
7863: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INV_SALESREP_ACPT_ACTION');
7864: FND_MSG_PUB.add;
7865: RAISE FND_API.G_EXC_ERROR;
7866: END IF;
7867:
7868: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

7894: COMMIT;
7895: END IF;
7896:
7897: -- Standard call to get message count and if count is 1, get message info.
7898: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);
7899:
7900: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7901: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
7902: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);

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

7904:
7905: EXCEPTION
7906: WHEN FND_API.G_EXC_ERROR THEN
7907: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
7908: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
7909: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7910: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
7911: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
7912: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

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

7913: END IF;
7914: x_return_status := G_RET_STS_ERROR;
7915: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7916: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
7917: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
7918: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7919: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
7920: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
7921: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

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

7927: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
7928: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
7929: ||SQLCODE||', sqlerrm = '||SQLERRM);
7930: END IF;
7931: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
7932: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
7933: x_return_status := G_RET_STS_UNEXP_ERROR ;
7934: END accept_quote;
7935:

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

7928: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
7929: ||SQLCODE||', sqlerrm = '||SQLERRM);
7930: END IF;
7931: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
7932: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
7933: x_return_status := G_RET_STS_UNEXP_ERROR ;
7934: END accept_quote;
7935:
7936: /*=========================================================================

Line 8020: FND_MSG_PUB.initialize;

8016: END IF;
8017:
8018: -- Initialize message list if p_init_msg_list is set to TRUE.
8019: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8020: FND_MSG_PUB.initialize;
8021: END IF;
8022:
8023: -- Initialize API return status to success
8024: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8029: FND_MSG_PUB.add;

8025:
8026: IF p_contract_id IS NULL THEN
8027: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
8028: FND_MESSAGE.SET_TOKEN('HDR_ID','NULL');
8029: FND_MSG_PUB.add;
8030: RAISE FND_API.G_EXC_ERROR;
8031: END IF;
8032:
8033: IF p_item_key IS NULL THEN

Line 8037: FND_MSG_PUB.add;

8033: IF p_item_key IS NULL THEN
8034: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
8035: IF l_item_key IS NULL THEN
8036: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
8037: FND_MSG_PUB.add;
8038: RAISE FND_API.G_EXC_ERROR;
8039: END IF;
8040: ELSE
8041: l_item_key := p_item_key;

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

8240: COMMIT;
8241: END IF;
8242:
8243: -- Standard call to get message count and if count is 1, get message info.
8244: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);
8245:
8246: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8247: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
8248: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);

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

8271: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
8272: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
8273: ||SQLCODE||', sqlerrm = '||SQLERRM);
8274: END IF;
8275: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
8276: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
8277: x_return_status := G_RET_STS_UNEXP_ERROR ;
8278: END cancel_contract;
8279:

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

8272: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
8273: ||SQLCODE||', sqlerrm = '||SQLERRM);
8274: END IF;
8275: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
8276: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
8277: x_return_status := G_RET_STS_UNEXP_ERROR ;
8278: END cancel_contract;
8279:
8280: /*=========================================================================

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

8631: --try the next batch
8632: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
8633: l_errcount := l_errcount + l_k_rec_tbl.COUNT;
8634: FOR j IN 1..l_msg_count LOOP
8635: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.get(j, 'F'));
8636: END LOOP;
8637: RAISE FND_API.g_exc_unexpected_error;
8638: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
8639: --just log the error and continue

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

8639: --just log the error and continue
8640: l_errcount := l_errcount + l_k_rec_tbl.COUNT;
8641: retcode := 1;
8642: FOR j IN 1..l_msg_count LOOP
8643: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.get(j, 'F'));
8644: END LOOP;
8645: ELSE
8646: l_wfcount := l_wfcount + l_k_rec_tbl.COUNT;
8647: END IF;

Line 8763: FND_MSG_PUB.initialize;

8759: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
8760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8761: END IF;
8762: IF FND_API.to_boolean(p_init_msg_list ) THEN
8763: FND_MSG_PUB.initialize;
8764: END IF;
8765: x_return_status := FND_API.G_RET_STS_SUCCESS;
8766:
8767: IF (p_wf_attributes_tbl.count = 0 ) THEN

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

8940: END IF;
8941: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8942: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
8943: END IF;
8944: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
8945:
8946: EXCEPTION
8947: WHEN FND_API.g_exc_error THEN
8948: ROLLBACK TO launch_k_process_wf_blk_PVT;

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

8950:
8951: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
8952: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
8953: END IF;
8954: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
8955:
8956: WHEN FND_API.g_exc_unexpected_error THEN
8957: ROLLBACK TO launch_k_process_wf_blk_PVT;
8958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

8959:
8960: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
8961: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
8962: END IF;
8963: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
8964:
8965: WHEN OTHERS THEN
8966: ROLLBACK TO launch_k_process_wf_blk_PVT;
8967:

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

8972: --workflow error
8973: WF_CORE.clear;
8974: --set the status to error, so that calling program can handle it
8975: x_return_status := FND_API.g_ret_sts_error ;
8976: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_wf_err_name||' '||l_wf_err_msg);
8977:
8978: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
8979: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_workflow_error', 'x_return_status=' || x_return_status);
8980: 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 8992: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

8988: --first log the sqlerrm
8989: l_error_text := substr (SQLERRM, 1, 240);
8990: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
8991: --then add it to the message api list
8992: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
8993: END IF;
8994: END IF;
8995:
8996: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

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

8992: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
8993: END IF;
8994: END IF;
8995:
8996: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
8997:
8998: END launch_k_process_wf_blk;
8999:
9000: END OKS_WF_K_PROCESS_PVT;