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

139: END IF;
140: -- Initialize message list if p_init_msg_list is set to TRUE.
141: IF FND_API.to_Boolean( p_init_msg_list )
142: THEN
143: FND_MSG_PUB.initialize;
144: END IF;
145:
146: -- Debug Message
147: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'start');

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:
519: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Price Protection responsibility not available for Last updated user'||l_user_name);
520:
521: RAISE FND_API.G_EXC_ERROR;

Line 679: FND_MSG_PUB.add;

675: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
676: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT.Update_PurchasePrice-XML Generation');
677: fnd_message.set_token('ERRNO', sqlcode);
678: fnd_message.set_token('REASON', sqlerrm);
679: FND_MSG_PUB.add;
680: END;
681:
682: l_exe_update_rec.Transaction_Header_ID := l_item_price_rec.Transaction_Header_ID;
683: l_exe_update_rec.Org_ID := l_item_price_rec.Org_ID;

Line 719: FND_MSG_PUB.Count_And_Get

715: -- Debug Message
716: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'end');
717:
718: -- Standard call to get message count and if count is 1, get message info.
719: FND_MSG_PUB.Count_And_Get
720: (p_count => x_msg_count,
721: p_data => x_msg_data
722: );
723: --Exception Handling

Line 729: FND_MSG_PUB.Count_And_Get (

725: WHEN FND_API.G_EXC_ERROR THEN
726: ROLLBACK TO UPDATE_PURCHASEPRICE_PVT;
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: -- Standard call to get message count and if count=1, get the message
729: FND_MSG_PUB.Count_And_Get (
730: p_encoded => FND_API.G_FALSE,
731: p_count => x_msg_count,
732: p_data => x_msg_data
733: );

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

732: p_data => x_msg_data
733: );
734: IF x_msg_count > 1 THEN
735: FOR I IN 1..x_msg_count LOOP
736: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
737: END LOOP;
738: END IF;
739:
740: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 744: FND_MSG_PUB.Count_And_Get (

740: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
741: ROLLBACK TO UPDATE_PURCHASEPRICE_PVT;
742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
743: -- Standard call to get message count and if count=1, get the message
744: FND_MSG_PUB.Count_And_Get (
745: p_encoded => FND_API.G_FALSE,
746: p_count => x_msg_count,
747: p_data => x_msg_data
748: );

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

747: p_data => x_msg_data
748: );
749: IF x_msg_count > 1 THEN
750: FOR I IN 1..x_msg_count LOOP
751: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
752: END LOOP;
753: END IF;
754:
755: WHEN OTHERS THEN

Line 762: FND_MSG_PUB.add;

758: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
759: fnd_message.set_token('ROUTINE', l_full_name);
760: fnd_message.set_token('ERRNO', sqlcode);
761: fnd_message.set_token('REASON', sqlerrm);
762: FND_MSG_PUB.add;
763: -- Standard call to get message count and if count=1, get the message
764: FND_MSG_PUB.Count_And_Get (
765: p_encoded => FND_API.G_FALSE,
766: p_count => x_msg_count,

Line 764: FND_MSG_PUB.Count_And_Get (

760: fnd_message.set_token('ERRNO', sqlcode);
761: fnd_message.set_token('REASON', sqlerrm);
762: FND_MSG_PUB.add;
763: -- Standard call to get message count and if count=1, get the message
764: FND_MSG_PUB.Count_And_Get (
765: p_encoded => FND_API.G_FALSE,
766: p_count => x_msg_count,
767: p_data => x_msg_data
768: );

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

767: p_data => x_msg_data
768: );
769: IF x_msg_count > 1 THEN
770: FOR I IN 1..x_msg_count LOOP
771: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
772: END LOOP;
773: END IF;
774:
775: END Update_PurchasePrice;

Line 1052: FND_MSG_PUB.initialize;

1048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1049: END IF;
1050: --Initialize message list if p_init_msg_list is set to TRUE.
1051: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1052: FND_MSG_PUB.initialize;
1053: END IF;
1054:
1055: -- Debug Message
1056: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'start');

Line 1096: FND_MSG_PUB.add;

1092: DPP_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Inventory Item ID cannot be NULL');
1093: END IF;
1094: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1095: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
1096: FND_MSG_PUB.add;
1097: -- Initializing Nested Table
1098: IF NOT l_po_details_tbl.EXISTS(1) THEN
1099: l_po_details_tbl(1).Document_Number := NULL;
1100: l_po_details_tbl(1).Document_Type := NULL;

Line 1136: FND_MSG_PUB.Count_And_Get

1132: IF g_debug THEN
1133: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'end');
1134: END IF;
1135: -- Standard call to get message count and if count is 1, get message info.
1136: FND_MSG_PUB.Count_And_Get
1137: (p_count => x_msg_count,
1138: p_data => x_msg_data
1139: );
1140: EXCEPTION

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

1140: EXCEPTION
1141: WHEN FND_API.G_EXC_ERROR THEN
1142: x_return_status := FND_API.G_RET_STS_ERROR;
1143: -- Standard call to get message count and if count=1, get the message
1144: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
1145: p_count => x_msg_count,
1146: p_data => x_msg_data
1147: );
1148: IF x_msg_count > 1 THEN

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

1146: p_data => x_msg_data
1147: );
1148: IF x_msg_count > 1 THEN
1149: FOR I IN 1..x_msg_count LOOP
1150: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1151: END LOOP;
1152: END IF;
1153:
1154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1157: FND_MSG_PUB.Count_And_Get (

1153:
1154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1156: -- Standard call to get message count and if count=1, get the message
1157: FND_MSG_PUB.Count_And_Get (
1158: p_encoded => FND_API.G_FALSE,
1159: p_count => x_msg_count,
1160: p_data => x_msg_data
1161: );

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

1160: p_data => x_msg_data
1161: );
1162: IF x_msg_count > 1 THEN
1163: FOR I IN 1..x_msg_count LOOP
1164: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1165: END LOOP;
1166: END IF;
1167:
1168: WHEN OTHERS THEN

Line 1174: FND_MSG_PUB.add;

1170: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1171: fnd_message.set_token('ROUTINE', l_full_name);
1172: fnd_message.set_token('ERRNO', sqlcode);
1173: fnd_message.set_token('REASON', sqlerrm);
1174: FND_MSG_PUB.add;
1175: -- Standard call to get message count and if count=1, get the message
1176: FND_MSG_PUB.Count_And_Get (
1177: p_encoded => FND_API.G_FALSE,
1178: p_count => x_msg_count,

Line 1176: FND_MSG_PUB.Count_And_Get (

1172: fnd_message.set_token('ERRNO', sqlcode);
1173: fnd_message.set_token('REASON', sqlerrm);
1174: FND_MSG_PUB.add;
1175: -- Standard call to get message count and if count=1, get the message
1176: FND_MSG_PUB.Count_And_Get (
1177: p_encoded => FND_API.G_FALSE,
1178: p_count => x_msg_count,
1179: p_data => x_msg_data
1180: );

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

1179: p_data => x_msg_data
1180: );
1181: IF x_msg_count > 1 THEN
1182: FOR I IN 1..x_msg_count LOOP
1183: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1184: END LOOP;
1185: END IF;
1186:
1187: END Notify_PO;