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 1129: IF x_msg_data is null and FND_MSG_PUB.Count_Msg >0 then

1125: MESSAGE =>'300: End Update_contract Terms.In Exception l_Contracts_call_exception');
1126: END IF;
1127: END IF;
1128: -- Show one error message atleast
1129: IF x_msg_data is null and FND_MSG_PUB.Count_Msg >0 then
1130: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
1131: ELSE
1132: Fnd_message.set_name('PO','PO_API_ERROR');
1133: Fnd_message.set_token( token => 'PROC_CALLER'

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

1126: END IF;
1127: END IF;
1128: -- Show one error message atleast
1129: IF x_msg_data is null and FND_MSG_PUB.Count_Msg >0 then
1130: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
1131: ELSE
1132: Fnd_message.set_name('PO','PO_API_ERROR');
1133: Fnd_message.set_token( token => 'PROC_CALLER'
1134: , VALUE => 'PO_CONTERMS_WF_PVT.UPDATE_CONTRACT_TERMS');

Line 1137: FND_MSG_PUB.Add;

1133: Fnd_message.set_token( token => 'PROC_CALLER'
1134: , VALUE => 'PO_CONTERMS_WF_PVT.UPDATE_CONTRACT_TERMS');
1135: Fnd_message.set_token( token => 'PROC_CALLED'
1136: , VALUE => l_k_api_name);
1137: FND_MSG_PUB.Add;
1138: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
1139:
1140: END IF;
1141: IF g_fnd_debug = 'Y' then

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

1134: , VALUE => 'PO_CONTERMS_WF_PVT.UPDATE_CONTRACT_TERMS');
1135: Fnd_message.set_token( token => 'PROC_CALLED'
1136: , VALUE => l_k_api_name);
1137: FND_MSG_PUB.Add;
1138: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
1139:
1140: END IF;
1141: IF g_fnd_debug = 'Y' then
1142: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

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

1138: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
1139:
1140: END IF;
1141: IF g_fnd_debug = 'Y' then
1142: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1143: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1144: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1145: MODULE =>g_module_prefix||l_api_name,
1146: MESSAGE =>':Errors in stack-'||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

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

1142: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1143: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1144: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1145: MODULE =>g_module_prefix||l_api_name,
1146: MESSAGE =>':Errors in stack-'||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
1147: END IF;
1148: END LOOP;
1149:
1150: END IF;

Line 1153: IF FND_MSG_PUB.Check_Msg_Level

1149:
1150: END IF;
1151: WHEN OTHERS THEN
1152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1153: IF FND_MSG_PUB.Check_Msg_Level
1154: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1155: THEN
1156: FND_MSG_PUB.Add_Exc_Msg
1157: (p_pkg_name => 'PO_CONTERMS_WF_PVT',

Line 1154: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1150: END IF;
1151: WHEN OTHERS THEN
1152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1153: IF FND_MSG_PUB.Check_Msg_Level
1154: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1155: THEN
1156: FND_MSG_PUB.Add_Exc_Msg
1157: (p_pkg_name => 'PO_CONTERMS_WF_PVT',
1158: p_procedure_name =>'UPDATE_CONTRACT_TERMS');

Line 1156: FND_MSG_PUB.Add_Exc_Msg

1152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1153: IF FND_MSG_PUB.Check_Msg_Level
1154: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1155: THEN
1156: FND_MSG_PUB.Add_Exc_Msg
1157: (p_pkg_name => 'PO_CONTERMS_WF_PVT',
1158: p_procedure_name =>'UPDATE_CONTRACT_TERMS');
1159:
1160: END IF; --msg level

Line 1161: FND_MSG_PUB.Count_And_Get

1157: (p_pkg_name => 'PO_CONTERMS_WF_PVT',
1158: p_procedure_name =>'UPDATE_CONTRACT_TERMS');
1159:
1160: END IF; --msg level
1161: FND_MSG_PUB.Count_And_Get
1162: (p_count => x_msg_count,
1163: p_data => x_msg_data );
1164:
1165: IF g_fnd_debug = 'Y' then

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

1169: MESSAGE =>'400: End Update_contract_terms.In Exception others');
1170: END IF;
1171: END IF;
1172: -- show one error message at least
1173: IF x_msg_data is null and FND_MSG_PUB.Count_Msg >0 then
1174: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
1175: IF x_msg_data is null then
1176: x_msg_data := SQLCODE||':'||SQLERRM;
1177: END IF;

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

1170: END IF;
1171: END IF;
1172: -- show one error message at least
1173: IF x_msg_data is null and FND_MSG_PUB.Count_Msg >0 then
1174: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
1175: IF x_msg_data is null then
1176: x_msg_data := SQLCODE||':'||SQLERRM;
1177: END IF;
1178: END IF;

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

1326: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1327: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_STANDARD_CONTRACT', 'l_contracts_call_Exception');
1328:
1329: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1330: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
1331: 'PO_CONTERMS_WF_PVT.IS_STANDARD_CONTRACT');
1332: RAISE;
1333:
1334: WHEN OTHERS THEN

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

1475: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1476: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_TEMPLATE_EXPIRED', 'l_contracts_call_Exception');
1477:
1478: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1479: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
1480: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_TEMPLATE_EXPIRED');
1481: RAISE;
1482:
1483: WHEN OTHERS THEN

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

1626: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1627: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_EXIST', 'l_contracts_call_Exception');
1628:
1629: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1630: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
1631: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_ARTICLES_EXIST');
1632: RAISE;
1633:
1634: WHEN OTHERS THEN

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

1778: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1779: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_AMENDED', 'l_contracts_call_Exception');
1780:
1781: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1782: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
1783: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_ARTICLES_AMENDED');
1784: RAISE;
1785:
1786: WHEN OTHERS THEN

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

1935: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1936: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_EXIST', 'l_contracts_call_Exception');
1937:
1938: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1939: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
1940: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_DELIVRABLS_EXIST');
1941: RAISE;
1942:
1943: WHEN OTHERS THEN

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

2091: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2092: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_AMENDED', 'l_contracts_call_Exception');
2093:
2094: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
2095: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
2096: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_DELIVRABLS_AMENDED');
2097: RAISE;
2098:
2099: WHEN OTHERS THEN