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.PO_CONTERMS_WF_PVT dependencies on FND_MSG_PUB

Line 46: l_count number:= FND_MSG_PUB.Count_Msg;

42: itemkey IN VARCHAR2,
43: p_api_name IN VARCHAR2,
44: p_return_status IN VARCHAR2) IS
45:
46: l_count number:= FND_MSG_PUB.Count_Msg;
47: BEGIN
48: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
49: '10: Start show error');
50: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

Line 54: (20+i)||':Error-'||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

50: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
51: '20:Return status for '||p_api_name||':'||p_return_status);
52: FOR i IN 1..l_count LOOP
53: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
54: (20+i)||':Error-'||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
55: END LOOP;
56: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
57: '100: End show error');
58: END show_error;

Line 705: IF x_msg_data is null and FND_MSG_PUB.Count_Msg >0 then

701: END IF;
702:
703: END IF;
704: -- Show one error message atleast
705: IF x_msg_data is null and FND_MSG_PUB.Count_Msg >0 then
706: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
707: ELSE
708: Fnd_message.set_name('PO','PO_API_ERROR');
709: Fnd_message.set_token( token => 'PROC_CALLER'

Line 706: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );

702:
703: END IF;
704: -- Show one error message atleast
705: IF x_msg_data is null and FND_MSG_PUB.Count_Msg >0 then
706: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
707: ELSE
708: Fnd_message.set_name('PO','PO_API_ERROR');
709: Fnd_message.set_token( token => 'PROC_CALLER'
710: , VALUE => 'PO_CONTERMS_WF_PVT.UPDATE_CONTERMS_DATES');

Line 713: FND_MSG_PUB.Add;

709: Fnd_message.set_token( token => 'PROC_CALLER'
710: , VALUE => 'PO_CONTERMS_WF_PVT.UPDATE_CONTERMS_DATES');
711: Fnd_message.set_token( token => 'PROC_CALLED'
712: , VALUE => l_k_api_name);
713: FND_MSG_PUB.Add;
714: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
715:
716: END IF;
717: IF g_fnd_debug = 'Y' then

Line 714: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );

710: , VALUE => 'PO_CONTERMS_WF_PVT.UPDATE_CONTERMS_DATES');
711: Fnd_message.set_token( token => 'PROC_CALLED'
712: , VALUE => l_k_api_name);
713: FND_MSG_PUB.Add;
714: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
715:
716: END IF;
717: IF g_fnd_debug = 'Y' then
718: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

Line 718: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

714: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
715:
716: END IF;
717: IF g_fnd_debug = 'Y' then
718: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
719: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
720: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
721: MODULE =>g_module_prefix||l_api_name,
722: MESSAGE =>':Errors in stack-'||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

Line 722: MESSAGE =>':Errors in stack-'||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

718: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
719: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
720: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
721: MODULE =>g_module_prefix||l_api_name,
722: MESSAGE =>':Errors in stack-'||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
723: END IF;
724: END LOOP;
725:
726: END IF;

Line 737: IF FND_MSG_PUB.Check_Msg_Level

733: END IF;
734:
735: END IF;
736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
737: IF FND_MSG_PUB.Check_Msg_Level
738: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
739: THEN
740: FND_MSG_PUB.Add_Exc_Msg
741: (p_pkg_name => 'PO_CONTERMS_WF_PVT',

Line 738: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

734:
735: END IF;
736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
737: IF FND_MSG_PUB.Check_Msg_Level
738: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
739: THEN
740: FND_MSG_PUB.Add_Exc_Msg
741: (p_pkg_name => 'PO_CONTERMS_WF_PVT',
742: p_procedure_name =>'UPDATE_CONTERMS_DATES');

Line 740: FND_MSG_PUB.Add_Exc_Msg

736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
737: IF FND_MSG_PUB.Check_Msg_Level
738: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
739: THEN
740: FND_MSG_PUB.Add_Exc_Msg
741: (p_pkg_name => 'PO_CONTERMS_WF_PVT',
742: p_procedure_name =>'UPDATE_CONTERMS_DATES');
743:
744: END IF; --msg level

Line 745: FND_MSG_PUB.Count_And_Get

741: (p_pkg_name => 'PO_CONTERMS_WF_PVT',
742: p_procedure_name =>'UPDATE_CONTERMS_DATES');
743:
744: END IF; --msg level
745: FND_MSG_PUB.Count_And_Get
746: (p_count => x_msg_count,
747: p_data => x_msg_data );
748: -- show one error message at least
749: IF x_msg_data is null and FND_MSG_PUB.Count_Msg >0 then

Line 749: IF x_msg_data is null and FND_MSG_PUB.Count_Msg >0 then

745: FND_MSG_PUB.Count_And_Get
746: (p_count => x_msg_count,
747: p_data => x_msg_data );
748: -- show one error message at least
749: IF x_msg_data is null and FND_MSG_PUB.Count_Msg >0 then
750: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
751: IF x_msg_data is null then
752: x_msg_data := SQLCODE||':'||SQLERRM;
753: END IF;

Line 750: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );

746: (p_count => x_msg_count,
747: p_data => x_msg_data );
748: -- show one error message at least
749: IF x_msg_data is null and FND_MSG_PUB.Count_Msg >0 then
750: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
751: IF x_msg_data is null then
752: x_msg_data := SQLCODE||':'||SQLERRM;
753: END IF;
754: END IF;

Line 1148: IF x_msg_data is null and FND_MSG_PUB.Count_Msg >0 then

1144: MESSAGE =>'300: End Update_contract Terms.In Exception l_Contracts_call_exception');
1145: END IF;
1146: END IF;
1147: -- Show one error message atleast
1148: IF x_msg_data is null and FND_MSG_PUB.Count_Msg >0 then
1149: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
1150: ELSE
1151: Fnd_message.set_name('PO','PO_API_ERROR');
1152: Fnd_message.set_token( token => 'PROC_CALLER'

Line 1149: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );

1145: END IF;
1146: END IF;
1147: -- Show one error message atleast
1148: IF x_msg_data is null and FND_MSG_PUB.Count_Msg >0 then
1149: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
1150: ELSE
1151: Fnd_message.set_name('PO','PO_API_ERROR');
1152: Fnd_message.set_token( token => 'PROC_CALLER'
1153: , VALUE => 'PO_CONTERMS_WF_PVT.UPDATE_CONTRACT_TERMS');

Line 1156: FND_MSG_PUB.Add;

1152: Fnd_message.set_token( token => 'PROC_CALLER'
1153: , VALUE => 'PO_CONTERMS_WF_PVT.UPDATE_CONTRACT_TERMS');
1154: Fnd_message.set_token( token => 'PROC_CALLED'
1155: , VALUE => l_k_api_name);
1156: FND_MSG_PUB.Add;
1157: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
1158:
1159: END IF;
1160: IF g_fnd_debug = 'Y' then

Line 1157: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );

1153: , VALUE => 'PO_CONTERMS_WF_PVT.UPDATE_CONTRACT_TERMS');
1154: Fnd_message.set_token( token => 'PROC_CALLED'
1155: , VALUE => l_k_api_name);
1156: FND_MSG_PUB.Add;
1157: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
1158:
1159: END IF;
1160: IF g_fnd_debug = 'Y' then
1161: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

Line 1161: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

1157: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
1158:
1159: END IF;
1160: IF g_fnd_debug = 'Y' then
1161: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1162: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1163: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1164: MODULE =>g_module_prefix||l_api_name,
1165: MESSAGE =>':Errors in stack-'||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

Line 1165: MESSAGE =>':Errors in stack-'||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

1161: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1162: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1163: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1164: MODULE =>g_module_prefix||l_api_name,
1165: MESSAGE =>':Errors in stack-'||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
1166: END IF;
1167: END LOOP;
1168:
1169: END IF;

Line 1172: IF FND_MSG_PUB.Check_Msg_Level

1168:
1169: END IF;
1170: WHEN OTHERS THEN
1171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1172: IF FND_MSG_PUB.Check_Msg_Level
1173: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1174: THEN
1175: FND_MSG_PUB.Add_Exc_Msg
1176: (p_pkg_name => 'PO_CONTERMS_WF_PVT',

Line 1173: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1169: END IF;
1170: WHEN OTHERS THEN
1171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1172: IF FND_MSG_PUB.Check_Msg_Level
1173: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1174: THEN
1175: FND_MSG_PUB.Add_Exc_Msg
1176: (p_pkg_name => 'PO_CONTERMS_WF_PVT',
1177: p_procedure_name =>'UPDATE_CONTRACT_TERMS');

Line 1175: FND_MSG_PUB.Add_Exc_Msg

1171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1172: IF FND_MSG_PUB.Check_Msg_Level
1173: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1174: THEN
1175: FND_MSG_PUB.Add_Exc_Msg
1176: (p_pkg_name => 'PO_CONTERMS_WF_PVT',
1177: p_procedure_name =>'UPDATE_CONTRACT_TERMS');
1178:
1179: END IF; --msg level

Line 1180: FND_MSG_PUB.Count_And_Get

1176: (p_pkg_name => 'PO_CONTERMS_WF_PVT',
1177: p_procedure_name =>'UPDATE_CONTRACT_TERMS');
1178:
1179: END IF; --msg level
1180: FND_MSG_PUB.Count_And_Get
1181: (p_count => x_msg_count,
1182: p_data => x_msg_data );
1183:
1184: IF g_fnd_debug = 'Y' then

Line 1192: IF x_msg_data is null and FND_MSG_PUB.Count_Msg >0 then

1188: MESSAGE =>'400: End Update_contract_terms.In Exception others');
1189: END IF;
1190: END IF;
1191: -- show one error message at least
1192: IF x_msg_data is null and FND_MSG_PUB.Count_Msg >0 then
1193: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
1194: IF x_msg_data is null then
1195: x_msg_data := SQLCODE||':'||SQLERRM;
1196: END IF;

Line 1193: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );

1189: END IF;
1190: END IF;
1191: -- show one error message at least
1192: IF x_msg_data is null and FND_MSG_PUB.Count_Msg >0 then
1193: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
1194: IF x_msg_data is null then
1195: x_msg_data := SQLCODE||':'||SQLERRM;
1196: END IF;
1197: END IF;

Line 1349: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),

1345: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1346: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_STANDARD_CONTRACT', 'l_contracts_call_Exception');
1347:
1348: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1349: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
1350: 'PO_CONTERMS_WF_PVT.IS_STANDARD_CONTRACT');
1351: RAISE;
1352:
1353: WHEN OTHERS THEN

Line 1498: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),

1494: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1495: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_TEMPLATE_EXPIRED', 'l_contracts_call_Exception');
1496:
1497: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1498: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
1499: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_TEMPLATE_EXPIRED');
1500: RAISE;
1501:
1502: WHEN OTHERS THEN

Line 1649: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),

1645: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1646: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_EXIST', 'l_contracts_call_Exception');
1647:
1648: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1649: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
1650: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_ARTICLES_EXIST');
1651: RAISE;
1652:
1653: WHEN OTHERS THEN

Line 1801: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),

1797: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1798: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_AMENDED', 'l_contracts_call_Exception');
1799:
1800: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1801: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
1802: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_ARTICLES_AMENDED');
1803: RAISE;
1804:
1805: WHEN OTHERS THEN

Line 1958: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),

1954: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1955: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_EXIST', 'l_contracts_call_Exception');
1956:
1957: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1958: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
1959: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_DELIVRABLS_EXIST');
1960: RAISE;
1961:
1962: WHEN OTHERS THEN

Line 2114: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),

2110: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2111: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_AMENDED', 'l_contracts_call_Exception');
2112:
2113: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
2114: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
2115: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_DELIVRABLS_AMENDED');
2116: RAISE;
2117:
2118: WHEN OTHERS THEN