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.EGO_INV_ITEM_CATALOG_PVT dependencies on FND_MESSAGE

Line 71: fnd_message.set_name('EGO', 'EGO_ITEM_REV_LC_PROJ_EXISTS');

67: --
68: -- bug: 3696801 decoding the messages
69: --
70: IF p_message_name = 'ITEM_LC_PROJ_EXISTS' THEN
71: fnd_message.set_name('EGO', 'EGO_ITEM_REV_LC_PROJ_EXISTS');
72: ELSIF p_message_name = 'EGO_ITEM_PENDING_CHANGES_EXIST' THEN
73: fnd_message.set_name('EGO', 'EGO_REV_PEND_CHANGES_EXIST');
74: ELSIF p_message_name = 'EGO_ITEM_PENDING_REC_EXISTS' THEN
75: fnd_message.set_name('EGO', 'EGO_REV_PEND_REC_EXISTS');

Line 73: fnd_message.set_name('EGO', 'EGO_REV_PEND_CHANGES_EXIST');

69: --
70: IF p_message_name = 'ITEM_LC_PROJ_EXISTS' THEN
71: fnd_message.set_name('EGO', 'EGO_ITEM_REV_LC_PROJ_EXISTS');
72: ELSIF p_message_name = 'EGO_ITEM_PENDING_CHANGES_EXIST' THEN
73: fnd_message.set_name('EGO', 'EGO_REV_PEND_CHANGES_EXIST');
74: ELSIF p_message_name = 'EGO_ITEM_PENDING_REC_EXISTS' THEN
75: fnd_message.set_name('EGO', 'EGO_REV_PEND_REC_EXISTS');
76: END IF;
77: --

Line 75: fnd_message.set_name('EGO', 'EGO_REV_PEND_REC_EXISTS');

71: fnd_message.set_name('EGO', 'EGO_ITEM_REV_LC_PROJ_EXISTS');
72: ELSIF p_message_name = 'EGO_ITEM_PENDING_CHANGES_EXIST' THEN
73: fnd_message.set_name('EGO', 'EGO_REV_PEND_CHANGES_EXIST');
74: ELSIF p_message_name = 'EGO_ITEM_PENDING_REC_EXISTS' THEN
75: fnd_message.set_name('EGO', 'EGO_REV_PEND_REC_EXISTS');
76: END IF;
77: --
78: -- get revision name
79: --

Line 84: fnd_message.set_token('REVISION', l_revision);

80: SELECT revision
81: INTO l_revision
82: FROM mtl_item_revisions_b
83: WHERE revision_id = p_item_revision_id;
84: fnd_message.set_token('REVISION', l_revision);
85: ELSE
86: fnd_message.set_name('EGO', p_message_name);
87: END IF;
88: fnd_message.set_token('ITEM_NUMBER', l_item_number);

Line 86: fnd_message.set_name('EGO', p_message_name);

82: FROM mtl_item_revisions_b
83: WHERE revision_id = p_item_revision_id;
84: fnd_message.set_token('REVISION', l_revision);
85: ELSE
86: fnd_message.set_name('EGO', p_message_name);
87: END IF;
88: fnd_message.set_token('ITEM_NUMBER', l_item_number);
89: fnd_message.set_token('ORG_NAME', l_org_name);
90: ELSE

Line 88: fnd_message.set_token('ITEM_NUMBER', l_item_number);

84: fnd_message.set_token('REVISION', l_revision);
85: ELSE
86: fnd_message.set_name('EGO', p_message_name);
87: END IF;
88: fnd_message.set_token('ITEM_NUMBER', l_item_number);
89: fnd_message.set_token('ORG_NAME', l_org_name);
90: ELSE
91: fnd_message.set_name('EGO', p_message_name);
92: END IF;

Line 89: fnd_message.set_token('ORG_NAME', l_org_name);

85: ELSE
86: fnd_message.set_name('EGO', p_message_name);
87: END IF;
88: fnd_message.set_token('ITEM_NUMBER', l_item_number);
89: fnd_message.set_token('ORG_NAME', l_org_name);
90: ELSE
91: fnd_message.set_name('EGO', p_message_name);
92: END IF;
93: x_msg_count := 1;

Line 91: fnd_message.set_name('EGO', p_message_name);

87: END IF;
88: fnd_message.set_token('ITEM_NUMBER', l_item_number);
89: fnd_message.set_token('ORG_NAME', l_org_name);
90: ELSE
91: fnd_message.set_name('EGO', p_message_name);
92: END IF;
93: x_msg_count := 1;
94: x_msg_data := fnd_message.get();
95: --

Line 94: x_msg_data := fnd_message.get();

90: ELSE
91: fnd_message.set_name('EGO', p_message_name);
92: END IF;
93: x_msg_count := 1;
94: x_msg_data := fnd_message.get();
95: --
96: -- return status as Error
97: --
98: x_return_status := FND_API.G_RET_STS_ERROR;

Line 102: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);

98: x_return_status := FND_API.G_RET_STS_ERROR;
99: EXCEPTION
100: WHEN OTHERS THEN
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
102: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
103: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
104: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'GET_ERROR_MSG');
105: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
106: x_msg_count := 1;

Line 103: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);

99: EXCEPTION
100: WHEN OTHERS THEN
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
102: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
103: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
104: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'GET_ERROR_MSG');
105: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
106: x_msg_count := 1;
107: x_msg_data := FND_MESSAGE.GET;

Line 104: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'GET_ERROR_MSG');

100: WHEN OTHERS THEN
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
102: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
103: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
104: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'GET_ERROR_MSG');
105: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
106: x_msg_count := 1;
107: x_msg_data := FND_MESSAGE.GET;
108: END Get_Error_Msg;

Line 105: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
102: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
103: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
104: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'GET_ERROR_MSG');
105: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
106: x_msg_count := 1;
107: x_msg_data := FND_MESSAGE.GET;
108: END Get_Error_Msg;
109:

Line 107: x_msg_data := FND_MESSAGE.GET;

103: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
104: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'GET_ERROR_MSG');
105: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
106: x_msg_count := 1;
107: x_msg_data := FND_MESSAGE.GET;
108: END Get_Error_Msg;
109:
110: ------------------------------------------------------------------------------
111: -- Start OF comments

Line 288: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);

284: IF c_get_item_rev_details%ISOPEN THEN
285: CLOSE c_get_item_rev_details;
286: END IF;
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
289: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
290: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'SYNC_ITEM_REVISIONS');
291: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
292: x_msg_count := 1;

Line 289: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);

285: CLOSE c_get_item_rev_details;
286: END IF;
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
289: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
290: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'SYNC_ITEM_REVISIONS');
291: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
292: x_msg_count := 1;
293: x_msg_data := FND_MESSAGE.GET;

Line 290: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'SYNC_ITEM_REVISIONS');

286: END IF;
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
289: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
290: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'SYNC_ITEM_REVISIONS');
291: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
292: x_msg_count := 1;
293: x_msg_data := FND_MESSAGE.GET;
294: code_debug(' Exception in Sync_Item_Revisions : ' ||x_msg_data );

Line 291: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
289: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
290: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'SYNC_ITEM_REVISIONS');
291: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
292: x_msg_count := 1;
293: x_msg_data := FND_MESSAGE.GET;
294: code_debug(' Exception in Sync_Item_Revisions : ' ||x_msg_data );
295: END Sync_Item_Revisions;

Line 293: x_msg_data := FND_MESSAGE.GET;

289: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
290: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'SYNC_ITEM_REVISIONS');
291: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
292: x_msg_count := 1;
293: x_msg_data := FND_MESSAGE.GET;
294: code_debug(' Exception in Sync_Item_Revisions : ' ||x_msg_data );
295: END Sync_Item_Revisions;
296:
297: ------------------------------------------------------------------------------

Line 643: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);

639: IF c_get_item_curr_data%ISOPEN THEN
640: CLOSE c_get_item_curr_data;
641: END IF;
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
644: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
645: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
646: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
647: x_msg_count := 1;

Line 644: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);

640: CLOSE c_get_item_curr_data;
641: END IF;
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
644: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
645: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
646: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
647: x_msg_count := 1;
648: x_msg_data := FND_MESSAGE.GET;

Line 645: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);

641: END IF;
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
644: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
645: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
646: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
647: x_msg_count := 1;
648: x_msg_data := FND_MESSAGE.GET;
649: code_debug(' Exception in '||l_api_name||' : ' ||x_msg_data );

Line 646: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
644: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
645: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
646: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
647: x_msg_count := 1;
648: x_msg_data := FND_MESSAGE.GET;
649: code_debug(' Exception in '||l_api_name||' : ' ||x_msg_data );
650: END Change_Item_Lifecycle;

Line 648: x_msg_data := FND_MESSAGE.GET;

644: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
645: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
646: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
647: x_msg_count := 1;
648: x_msg_data := FND_MESSAGE.GET;
649: code_debug(' Exception in '||l_api_name||' : ' ||x_msg_data );
650: END Change_Item_Lifecycle;
651:
652: ------------------------------------------------------------------------------

Line 972: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);

968: IF c_get_master_org_details%ISOPEN THEN
969: CLOSE c_get_master_org_details;
970: END IF;
971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
972: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
973: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
974: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
975: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
976: x_msg_count := 1;

Line 973: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);

969: CLOSE c_get_master_org_details;
970: END IF;
971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
972: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
973: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
974: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
975: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
976: x_msg_count := 1;
977: x_msg_data := FND_MESSAGE.GET;

Line 974: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);

970: END IF;
971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
972: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
973: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
974: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
975: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
976: x_msg_count := 1;
977: x_msg_data := FND_MESSAGE.GET;
978: code_debug(' Exception in '||l_api_name||' : ' ||x_msg_data );

Line 975: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
972: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
973: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
974: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
975: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
976: x_msg_count := 1;
977: x_msg_data := FND_MESSAGE.GET;
978: code_debug(' Exception in '||l_api_name||' : ' ||x_msg_data );
979: END Change_Item_Catalog;

Line 977: x_msg_data := FND_MESSAGE.GET;

973: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
974: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
975: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
976: x_msg_count := 1;
977: x_msg_data := FND_MESSAGE.GET;
978: code_debug(' Exception in '||l_api_name||' : ' ||x_msg_data );
979: END Change_Item_Catalog;
980:
981:

Line 1258: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);

1254: IF c_check_cc_hier%ISOPEN THEN
1255: CLOSE c_check_cc_hier;
1256: END IF;
1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1258: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1259: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1260: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
1261: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1262: x_msg_count := 1;

Line 1259: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);

1255: CLOSE c_check_cc_hier;
1256: END IF;
1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1258: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1259: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1260: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
1261: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1262: x_msg_count := 1;
1263: x_msg_data := FND_MESSAGE.GET;

Line 1260: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);

1256: END IF;
1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1258: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1259: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1260: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
1261: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1262: x_msg_count := 1;
1263: x_msg_data := FND_MESSAGE.GET;
1264: code_debug(' Exception in Validate_And_Change_Item_LC : ' ||x_msg_data );

Line 1261: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1258: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1259: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1260: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
1261: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1262: x_msg_count := 1;
1263: x_msg_data := FND_MESSAGE.GET;
1264: code_debug(' Exception in Validate_And_Change_Item_LC : ' ||x_msg_data );
1265:

Line 1263: x_msg_data := FND_MESSAGE.GET;

1259: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1260: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
1261: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1262: x_msg_count := 1;
1263: x_msg_data := FND_MESSAGE.GET;
1264: code_debug(' Exception in Validate_And_Change_Item_LC : ' ||x_msg_data );
1265:
1266: END Validate_And_Change_Item_LC;
1267:

Line 1545: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);

1541: IF c_pending_phase_change%ISOPEN THEN
1542: CLOSE c_pending_phase_change;
1543: END IF;
1544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1545: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1546: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1547: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHANGE_ITEM_LC_DEPENDENCIES');
1548: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1549: x_msg_count := 1;

Line 1546: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);

1542: CLOSE c_pending_phase_change;
1543: END IF;
1544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1545: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1546: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1547: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHANGE_ITEM_LC_DEPENDENCIES');
1548: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1549: x_msg_count := 1;
1550: x_msg_data := FND_MESSAGE.GET;

Line 1547: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHANGE_ITEM_LC_DEPENDENCIES');

1543: END IF;
1544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1545: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1546: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1547: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHANGE_ITEM_LC_DEPENDENCIES');
1548: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1549: x_msg_count := 1;
1550: x_msg_data := FND_MESSAGE.GET;
1551: code_debug(' Exception in '||l_api_name ||': '||x_msg_data );

Line 1548: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

1544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1545: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1546: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1547: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHANGE_ITEM_LC_DEPENDENCIES');
1548: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1549: x_msg_count := 1;
1550: x_msg_data := FND_MESSAGE.GET;
1551: code_debug(' Exception in '||l_api_name ||': '||x_msg_data );
1552: END Change_Item_LC_Dependecies;

Line 1550: x_msg_data := FND_MESSAGE.GET;

1546: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1547: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHANGE_ITEM_LC_DEPENDENCIES');
1548: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1549: x_msg_count := 1;
1550: x_msg_data := FND_MESSAGE.GET;
1551: code_debug(' Exception in '||l_api_name ||': '||x_msg_data );
1552: END Change_Item_LC_Dependecies;
1553:
1554:

Line 1641: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);

1637: IF FND_API.To_Boolean( p_commit ) THEN
1638: ROLLBACK TO Create_Phase_History_SP;
1639: END IF;
1640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1641: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1642: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1643: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CREATE_PHASE_HISTORY_RECORD');
1644: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1645: x_msg_count := 1;

Line 1642: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);

1638: ROLLBACK TO Create_Phase_History_SP;
1639: END IF;
1640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1641: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1642: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1643: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CREATE_PHASE_HISTORY_RECORD');
1644: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1645: x_msg_count := 1;
1646: x_msg_data := FND_MESSAGE.GET;

Line 1643: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CREATE_PHASE_HISTORY_RECORD');

1639: END IF;
1640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1641: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1642: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1643: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CREATE_PHASE_HISTORY_RECORD');
1644: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1645: x_msg_count := 1;
1646: x_msg_data := FND_MESSAGE.GET;
1647: END Create_phase_History_Record;

Line 1644: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

1640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1641: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1642: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1643: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CREATE_PHASE_HISTORY_RECORD');
1644: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1645: x_msg_count := 1;
1646: x_msg_data := FND_MESSAGE.GET;
1647: END Create_phase_History_Record;
1648:

Line 1646: x_msg_data := FND_MESSAGE.GET;

1642: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1643: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CREATE_PHASE_HISTORY_RECORD');
1644: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1645: x_msg_count := 1;
1646: x_msg_data := FND_MESSAGE.GET;
1647: END Create_phase_History_Record;
1648:
1649: ------------------------------------------------------------------------------
1650: -- Start OF comments

Line 1710: FND_MESSAGE.Set_Name(G_APP_NAME, 'EGO_PKG_MAND_VALUES_MISS');

1706: IF p_change_line_id IS NOT NULL THEN
1707: --
1708: -- this should never occur
1709: --
1710: FND_MESSAGE.Set_Name(G_APP_NAME, 'EGO_PKG_MAND_VALUES_MISS');
1711: FND_MESSAGE.Set_Token('PACKAGE', G_PKG_NAME||l_api_name);
1712: FND_MESSAGE.Set_Token('VALUE1', 'CHECK_ID');
1713: FND_MESSAGE.Set_Token('VALUE2', 'CHANGE_LINE_ID');
1714: x_msg_count := 1;

Line 1711: FND_MESSAGE.Set_Token('PACKAGE', G_PKG_NAME||l_api_name);

1707: --
1708: -- this should never occur
1709: --
1710: FND_MESSAGE.Set_Name(G_APP_NAME, 'EGO_PKG_MAND_VALUES_MISS');
1711: FND_MESSAGE.Set_Token('PACKAGE', G_PKG_NAME||l_api_name);
1712: FND_MESSAGE.Set_Token('VALUE1', 'CHECK_ID');
1713: FND_MESSAGE.Set_Token('VALUE2', 'CHANGE_LINE_ID');
1714: x_msg_count := 1;
1715: x_msg_data := FND_MESSAGE.GET;

Line 1712: FND_MESSAGE.Set_Token('VALUE1', 'CHECK_ID');

1708: -- this should never occur
1709: --
1710: FND_MESSAGE.Set_Name(G_APP_NAME, 'EGO_PKG_MAND_VALUES_MISS');
1711: FND_MESSAGE.Set_Token('PACKAGE', G_PKG_NAME||l_api_name);
1712: FND_MESSAGE.Set_Token('VALUE1', 'CHECK_ID');
1713: FND_MESSAGE.Set_Token('VALUE2', 'CHANGE_LINE_ID');
1714: x_msg_count := 1;
1715: x_msg_data := FND_MESSAGE.GET;
1716: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1713: FND_MESSAGE.Set_Token('VALUE2', 'CHANGE_LINE_ID');

1709: --
1710: FND_MESSAGE.Set_Name(G_APP_NAME, 'EGO_PKG_MAND_VALUES_MISS');
1711: FND_MESSAGE.Set_Token('PACKAGE', G_PKG_NAME||l_api_name);
1712: FND_MESSAGE.Set_Token('VALUE1', 'CHECK_ID');
1713: FND_MESSAGE.Set_Token('VALUE2', 'CHANGE_LINE_ID');
1714: x_msg_count := 1;
1715: x_msg_data := FND_MESSAGE.GET;
1716: x_return_status := FND_API.G_RET_STS_ERROR;
1717: RETURN;

Line 1715: x_msg_data := FND_MESSAGE.GET;

1711: FND_MESSAGE.Set_Token('PACKAGE', G_PKG_NAME||l_api_name);
1712: FND_MESSAGE.Set_Token('VALUE1', 'CHECK_ID');
1713: FND_MESSAGE.Set_Token('VALUE2', 'CHANGE_LINE_ID');
1714: x_msg_count := 1;
1715: x_msg_data := FND_MESSAGE.GET;
1716: x_return_status := FND_API.G_RET_STS_ERROR;
1717: RETURN;
1718: END IF;
1719: l_change_notice := FND_API.G_MISS_CHAR;

Line 2073: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);

2069: IF l_dynamic_cursor%ISOPEN THEN
2070: CLOSE l_dynamic_cursor;
2071: END IF;
2072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2073: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
2074: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
2075: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHECK_PENDING_CHANGE_ORDERS');
2076: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
2077: x_msg_count := 1;

Line 2074: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);

2070: CLOSE l_dynamic_cursor;
2071: END IF;
2072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2073: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
2074: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
2075: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHECK_PENDING_CHANGE_ORDERS');
2076: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
2077: x_msg_count := 1;
2078: x_msg_data := FND_MESSAGE.GET;

Line 2075: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHECK_PENDING_CHANGE_ORDERS');

2071: END IF;
2072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2073: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
2074: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
2075: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHECK_PENDING_CHANGE_ORDERS');
2076: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
2077: x_msg_count := 1;
2078: x_msg_data := FND_MESSAGE.GET;
2079: END Check_pending_Change_Orders;

Line 2076: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

2072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2073: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
2074: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
2075: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHECK_PENDING_CHANGE_ORDERS');
2076: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
2077: x_msg_count := 1;
2078: x_msg_data := FND_MESSAGE.GET;
2079: END Check_pending_Change_Orders;
2080:

Line 2078: x_msg_data := FND_MESSAGE.GET;

2074: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
2075: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHECK_PENDING_CHANGE_ORDERS');
2076: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
2077: x_msg_count := 1;
2078: x_msg_data := FND_MESSAGE.GET;
2079: END Check_pending_Change_Orders;
2080:
2081:
2082: END EGO_INV_ITEM_CATALOG_PVT;