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

Line 11: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

7: -- NOTE :
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_PURCHASEPRICE_PVT';
11: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
12: G_FILE_NAME CONSTANT VARCHAR2(14) := 'dppvpopb.pls';
13:
14: ---------------------------------------------------------------------
15: -- PROCEDURE

Line 142: FND_MSG_PUB.initialize;

138: END IF;
139: -- Initialize message list if p_init_msg_list is set to TRUE.
140: IF FND_API.to_Boolean( p_init_msg_list )
141: THEN
142: FND_MSG_PUB.initialize;
143: END IF;
144:
145: -- Debug Message
146: IF g_debug THEN

Line 171: FND_MSG_PUB.add;

167: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
168: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');
169: fnd_message.set_token('ERRNO', sqlcode);
170: fnd_message.set_token('REASON', sqlerrm);
171: FND_MSG_PUB.add;
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END;
174: --Getting a valid Price Protection Responsibility at the User Level Profile Options
175: BEGIN

Line 247: FND_MSG_PUB.add;

243: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
244: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');
245: fnd_message.set_token('ERRNO', sqlcode);
246: fnd_message.set_token('REASON', sqlerrm);
247: FND_MSG_PUB.add;
248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
249: END;
250: WHEN OTHERS THEN
251: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 255: FND_MSG_PUB.add;

251: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
252: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');
253: fnd_message.set_token('ERRNO', sqlcode);
254: fnd_message.set_token('REASON', sqlerrm);
255: FND_MSG_PUB.add;
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END;
258: --Getting a valid Price Protection Responsibility at the Responsibility Level Profile Options
259: IF l_responsibility_id = -1 THEN

Line 331: FND_MSG_PUB.add;

327: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
328: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');
329: fnd_message.set_token('ERRNO', sqlcode);
330: fnd_message.set_token('REASON', sqlerrm);
331: FND_MSG_PUB.add;
332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
333: END;
334: WHEN OTHERS THEN
335: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 339: FND_MSG_PUB.add;

335: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
336: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');
337: fnd_message.set_token('ERRNO', sqlcode);
338: fnd_message.set_token('REASON', sqlerrm);
339: FND_MSG_PUB.add;
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END;
342: END IF;
343: --Getting a valid Price Protection Responsibility at the Application Level Profile Options

Line 416: FND_MSG_PUB.add;

412: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
413: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');
414: fnd_message.set_token('ERRNO', sqlcode);
415: fnd_message.set_token('REASON', sqlerrm);
416: FND_MSG_PUB.add;
417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
418: END;
419: WHEN OTHERS THEN
420: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 424: FND_MSG_PUB.add;

420: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
421: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');
422: fnd_message.set_token('ERRNO', sqlcode);
423: fnd_message.set_token('REASON', sqlerrm);
424: FND_MSG_PUB.add;
425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
426: END;
427: END IF;
428: --Getting a valid Price Protection Responsibility at the Site Level Profile Options

Line 501: FND_MSG_PUB.add;

497: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
498: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');
499: fnd_message.set_token('ERRNO', sqlcode);
500: fnd_message.set_token('REASON', sqlerrm);
501: FND_MSG_PUB.add;
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END;
504: WHEN OTHERS THEN
505: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 509: FND_MSG_PUB.add;

505: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
506: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');
507: fnd_message.set_token('ERRNO', sqlcode);
508: fnd_message.set_token('REASON', sqlerrm);
509: FND_MSG_PUB.add;
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
511: END;
512: END IF;
513: --Check if the responsibility id s -1

Line 517: FND_MSG_PUB.add;

513: --Check if the responsibility id s -1
514: IF l_responsibility_id = -1 THEN
515: FND_MESSAGE.set_name('DPP', 'DPP_INVALID_RESP');
516: FND_MESSAGE.set_token('USER', l_user_name);
517: FND_MSG_PUB.add;
518: IF g_debug THEN
519: DPP_UTILITY_PVT.debug_message('Price Protection responsibility not available for Last updated user'||l_user_name);
520: END IF;
521: RAISE FND_API.G_EXC_ERROR;

Line 687: FND_MSG_PUB.add;

683: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
684: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT.Update_PurchasePrice-XML Generation');
685: fnd_message.set_token('ERRNO', sqlcode);
686: fnd_message.set_token('REASON', sqlerrm);
687: FND_MSG_PUB.add;
688: END;
689:
690: l_exe_update_rec.Transaction_Header_ID := l_item_price_rec.Transaction_Header_ID;
691: l_exe_update_rec.Org_ID := l_item_price_rec.Org_ID;

Line 729: FND_MSG_PUB.Count_And_Get

725: IF g_debug THEN
726: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
727: END IF;
728: -- Standard call to get message count and if count is 1, get message info.
729: FND_MSG_PUB.Count_And_Get
730: (p_count => x_msg_count,
731: p_data => x_msg_data
732: );
733: --Exception Handling

Line 739: FND_MSG_PUB.Count_And_Get (

735: WHEN FND_API.G_EXC_ERROR THEN
736: ROLLBACK TO UPDATE_PURCHASEPRICE_PVT;
737: x_return_status := FND_API.G_RET_STS_ERROR;
738: -- Standard call to get message count and if count=1, get the message
739: FND_MSG_PUB.Count_And_Get (
740: p_encoded => FND_API.G_FALSE,
741: p_count => x_msg_count,
742: p_data => x_msg_data
743: );

Line 746: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

742: p_data => x_msg_data
743: );
744: IF x_msg_count > 1 THEN
745: FOR I IN 1..x_msg_count LOOP
746: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
747: END LOOP;
748: END IF;
749:
750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 754: FND_MSG_PUB.Count_And_Get (

750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
751: ROLLBACK TO UPDATE_PURCHASEPRICE_PVT;
752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
753: -- Standard call to get message count and if count=1, get the message
754: FND_MSG_PUB.Count_And_Get (
755: p_encoded => FND_API.G_FALSE,
756: p_count => x_msg_count,
757: p_data => x_msg_data
758: );

Line 761: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

757: p_data => x_msg_data
758: );
759: IF x_msg_count > 1 THEN
760: FOR I IN 1..x_msg_count LOOP
761: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
762: END LOOP;
763: END IF;
764:
765: WHEN OTHERS THEN

Line 772: FND_MSG_PUB.add;

768: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
769: fnd_message.set_token('ROUTINE', l_full_name);
770: fnd_message.set_token('ERRNO', sqlcode);
771: fnd_message.set_token('REASON', sqlerrm);
772: FND_MSG_PUB.add;
773: -- Standard call to get message count and if count=1, get the message
774: FND_MSG_PUB.Count_And_Get (
775: p_encoded => FND_API.G_FALSE,
776: p_count => x_msg_count,

Line 774: FND_MSG_PUB.Count_And_Get (

770: fnd_message.set_token('ERRNO', sqlcode);
771: fnd_message.set_token('REASON', sqlerrm);
772: FND_MSG_PUB.add;
773: -- Standard call to get message count and if count=1, get the message
774: FND_MSG_PUB.Count_And_Get (
775: p_encoded => FND_API.G_FALSE,
776: p_count => x_msg_count,
777: p_data => x_msg_data
778: );

Line 781: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

777: p_data => x_msg_data
778: );
779: IF x_msg_count > 1 THEN
780: FOR I IN 1..x_msg_count LOOP
781: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
782: END LOOP;
783: END IF;
784:
785: END Update_PurchasePrice;

Line 1061: FND_MSG_PUB.initialize;

1057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1058: END IF;
1059: --Initialize message list if p_init_msg_list is set to TRUE.
1060: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1061: FND_MSG_PUB.initialize;
1062: END IF;
1063:
1064: -- Debug Message
1065: IF g_debug THEN

Line 1106: FND_MSG_PUB.add;

1102: DPP_Utility_PVT.debug_message('Inventory Item ID cannot be NULL');
1103: END IF;
1104: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1105: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
1106: FND_MSG_PUB.add;
1107: -- Initializing Nested Table
1108: IF NOT l_po_details_tbl.EXISTS(1) THEN
1109: l_po_details_tbl(1).Document_Number := NULL;
1110: l_po_details_tbl(1).Document_Type := NULL;

Line 1146: FND_MSG_PUB.Count_And_Get

1142: IF g_debug THEN
1143: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1144: END IF;
1145: -- Standard call to get message count and if count is 1, get message info.
1146: FND_MSG_PUB.Count_And_Get
1147: (p_count => x_msg_count,
1148: p_data => x_msg_data
1149: );
1150: EXCEPTION

Line 1154: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

1150: EXCEPTION
1151: WHEN FND_API.G_EXC_ERROR THEN
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153: -- Standard call to get message count and if count=1, get the message
1154: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
1155: p_count => x_msg_count,
1156: p_data => x_msg_data
1157: );
1158: IF x_msg_count > 1 THEN

Line 1160: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

1156: p_data => x_msg_data
1157: );
1158: IF x_msg_count > 1 THEN
1159: FOR I IN 1..x_msg_count LOOP
1160: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1161: END LOOP;
1162: END IF;
1163:
1164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1167: FND_MSG_PUB.Count_And_Get (

1163:
1164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1166: -- Standard call to get message count and if count=1, get the message
1167: FND_MSG_PUB.Count_And_Get (
1168: p_encoded => FND_API.G_FALSE,
1169: p_count => x_msg_count,
1170: p_data => x_msg_data
1171: );

Line 1174: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

1170: p_data => x_msg_data
1171: );
1172: IF x_msg_count > 1 THEN
1173: FOR I IN 1..x_msg_count LOOP
1174: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1175: END LOOP;
1176: END IF;
1177:
1178: WHEN OTHERS THEN

Line 1184: FND_MSG_PUB.add;

1180: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1181: fnd_message.set_token('ROUTINE', l_full_name);
1182: fnd_message.set_token('ERRNO', sqlcode);
1183: fnd_message.set_token('REASON', sqlerrm);
1184: FND_MSG_PUB.add;
1185: -- Standard call to get message count and if count=1, get the message
1186: FND_MSG_PUB.Count_And_Get (
1187: p_encoded => FND_API.G_FALSE,
1188: p_count => x_msg_count,

Line 1186: FND_MSG_PUB.Count_And_Get (

1182: fnd_message.set_token('ERRNO', sqlcode);
1183: fnd_message.set_token('REASON', sqlerrm);
1184: FND_MSG_PUB.add;
1185: -- Standard call to get message count and if count=1, get the message
1186: FND_MSG_PUB.Count_And_Get (
1187: p_encoded => FND_API.G_FALSE,
1188: p_count => x_msg_count,
1189: p_data => x_msg_data
1190: );

Line 1193: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

1189: p_data => x_msg_data
1190: );
1191: IF x_msg_count > 1 THEN
1192: FOR I IN 1..x_msg_count LOOP
1193: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1194: END LOOP;
1195: END IF;
1196:
1197: END Notify_PO;