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 72: fnd_message.set_name('EGO', 'EGO_ITEM_REV_LC_PROJ_EXISTS');

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

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

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

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

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

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

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

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

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

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

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

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

86: ELSE
87: fnd_message.set_name('EGO', p_message_name);
88: END IF;
89: fnd_message.set_token('ITEM_NUMBER', l_item_number);
90: fnd_message.set_token('ORG_NAME', l_org_name);
91:
92: x_msg_count := 1;
93: x_msg_data := fnd_message.get();
94: /* Bug Fix 7628987: added the below code */

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

89: fnd_message.set_token('ITEM_NUMBER', l_item_number);
90: fnd_message.set_token('ORG_NAME', l_org_name);
91:
92: x_msg_count := 1;
93: x_msg_data := fnd_message.get();
94: /* Bug Fix 7628987: added the below code */
95: IF p_message_name = 'EGO_ITEM_PENDING_CHANGES_EXIST' THEN
96: INV_ITEM_MSG.Add_Message (p_Msg_Name => 'INV_ITEM_PEND_CHGS_EXIST',
97: p_token1 => 'ITEM_NUMBER',

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

100: p_value2 => l_org_name);
101: END IF;
102: /* End of Bug Fix 7628987 */
103: ELSE
104: fnd_message.set_name('EGO', p_message_name);
105: x_msg_count := 1;
106: x_msg_data := fnd_message.get();
107: END IF;
108:

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

102: /* End of Bug Fix 7628987 */
103: ELSE
104: fnd_message.set_name('EGO', p_message_name);
105: x_msg_count := 1;
106: x_msg_data := fnd_message.get();
107: END IF;
108:
109: --
110: -- return status as Error

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

112: x_return_status := FND_API.G_RET_STS_ERROR;
113: EXCEPTION
114: WHEN OTHERS THEN
115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
116: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
117: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
118: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'GET_ERROR_MSG');
119: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
120: x_msg_count := 1;

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

113: EXCEPTION
114: WHEN OTHERS THEN
115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
116: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
117: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
118: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'GET_ERROR_MSG');
119: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
120: x_msg_count := 1;
121: x_msg_data := FND_MESSAGE.GET;

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

114: WHEN OTHERS THEN
115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
116: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
117: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
118: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'GET_ERROR_MSG');
119: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
120: x_msg_count := 1;
121: x_msg_data := FND_MESSAGE.GET;
122: END Get_Error_Msg;

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

115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
116: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
117: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
118: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'GET_ERROR_MSG');
119: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
120: x_msg_count := 1;
121: x_msg_data := FND_MESSAGE.GET;
122: END Get_Error_Msg;
123:

Line 121: x_msg_data := FND_MESSAGE.GET;

117: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
118: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'GET_ERROR_MSG');
119: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
120: x_msg_count := 1;
121: x_msg_data := FND_MESSAGE.GET;
122: END Get_Error_Msg;
123:
124: ------------------------------------------------------------------------------
125: -- Start OF comments

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

298: IF c_get_item_rev_details%ISOPEN THEN
299: CLOSE c_get_item_rev_details;
300: END IF;
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
303: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
304: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'SYNC_ITEM_REVISIONS');
305: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
306: x_msg_count := 1;

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

299: CLOSE c_get_item_rev_details;
300: END IF;
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
303: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
304: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'SYNC_ITEM_REVISIONS');
305: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
306: x_msg_count := 1;
307: x_msg_data := FND_MESSAGE.GET;

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

300: END IF;
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
303: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
304: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'SYNC_ITEM_REVISIONS');
305: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
306: x_msg_count := 1;
307: x_msg_data := FND_MESSAGE.GET;
308: code_debug(' Exception in Sync_Item_Revisions : ' ||x_msg_data );

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

301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
303: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
304: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'SYNC_ITEM_REVISIONS');
305: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
306: x_msg_count := 1;
307: x_msg_data := FND_MESSAGE.GET;
308: code_debug(' Exception in Sync_Item_Revisions : ' ||x_msg_data );
309: END Sync_Item_Revisions;

Line 307: x_msg_data := FND_MESSAGE.GET;

303: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
304: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'SYNC_ITEM_REVISIONS');
305: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
306: x_msg_count := 1;
307: x_msg_data := FND_MESSAGE.GET;
308: code_debug(' Exception in Sync_Item_Revisions : ' ||x_msg_data );
309: END Sync_Item_Revisions;
310:
311: ------------------------------------------------------------------------------

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

665: IF c_get_item_curr_data%ISOPEN THEN
666: CLOSE c_get_item_curr_data;
667: END IF;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
670: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
671: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
672: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
673: x_msg_count := 1;

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

666: CLOSE c_get_item_curr_data;
667: END IF;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
670: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
671: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
672: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
673: x_msg_count := 1;
674: x_msg_data := FND_MESSAGE.GET;

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

667: END IF;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
670: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
671: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
672: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
673: x_msg_count := 1;
674: x_msg_data := FND_MESSAGE.GET;
675: code_debug(' Exception in '||l_api_name||' : ' ||x_msg_data );

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

668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
670: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
671: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
672: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
673: x_msg_count := 1;
674: x_msg_data := FND_MESSAGE.GET;
675: code_debug(' Exception in '||l_api_name||' : ' ||x_msg_data );
676: END Change_Item_Lifecycle;

Line 674: x_msg_data := FND_MESSAGE.GET;

670: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
671: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
672: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
673: x_msg_count := 1;
674: x_msg_data := FND_MESSAGE.GET;
675: code_debug(' Exception in '||l_api_name||' : ' ||x_msg_data );
676: END Change_Item_Lifecycle;
677:
678: ------------------------------------------------------------------------------

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

1035: IF c_get_master_org_details%ISOPEN THEN
1036: CLOSE c_get_master_org_details;
1037: END IF;
1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1039: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1040: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1041: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
1042: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1043: x_msg_count := 1;

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

1036: CLOSE c_get_master_org_details;
1037: END IF;
1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1039: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1040: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1041: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
1042: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1043: x_msg_count := 1;
1044: x_msg_data := FND_MESSAGE.GET;

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

1037: END IF;
1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1039: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1040: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1041: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
1042: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1043: x_msg_count := 1;
1044: x_msg_data := FND_MESSAGE.GET;
1045: code_debug(' Exception in '||l_api_name||' : ' ||x_msg_data );

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

1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1039: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1040: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1041: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
1042: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1043: x_msg_count := 1;
1044: x_msg_data := FND_MESSAGE.GET;
1045: code_debug(' Exception in '||l_api_name||' : ' ||x_msg_data );
1046: END Change_Item_Catalog;

Line 1044: x_msg_data := FND_MESSAGE.GET;

1040: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1041: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
1042: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1043: x_msg_count := 1;
1044: x_msg_data := FND_MESSAGE.GET;
1045: code_debug(' Exception in '||l_api_name||' : ' ||x_msg_data );
1046: END Change_Item_Catalog;
1047:
1048:

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

1324: IF c_check_cc_hier%ISOPEN THEN
1325: CLOSE c_check_cc_hier;
1326: END IF;
1327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1328: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1329: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1330: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
1331: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1332: x_msg_count := 1;

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

1325: CLOSE c_check_cc_hier;
1326: END IF;
1327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1328: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1329: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1330: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
1331: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1332: x_msg_count := 1;
1333: x_msg_data := FND_MESSAGE.GET;

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

1326: END IF;
1327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1328: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1329: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1330: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
1331: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1332: x_msg_count := 1;
1333: x_msg_data := FND_MESSAGE.GET;
1334: code_debug(' Exception in Validate_And_Change_Item_LC : ' ||x_msg_data );

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

1327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1328: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1329: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1330: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
1331: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1332: x_msg_count := 1;
1333: x_msg_data := FND_MESSAGE.GET;
1334: code_debug(' Exception in Validate_And_Change_Item_LC : ' ||x_msg_data );
1335:

Line 1333: x_msg_data := FND_MESSAGE.GET;

1329: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1330: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
1331: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1332: x_msg_count := 1;
1333: x_msg_data := FND_MESSAGE.GET;
1334: code_debug(' Exception in Validate_And_Change_Item_LC : ' ||x_msg_data );
1335:
1336: END Validate_And_Change_Item_LC;
1337:

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

1614: IF c_pending_phase_change%ISOPEN THEN
1615: CLOSE c_pending_phase_change;
1616: END IF;
1617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1618: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1619: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1620: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHANGE_ITEM_LC_DEPENDENCIES');
1621: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1622: x_msg_count := 1;

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

1615: CLOSE c_pending_phase_change;
1616: END IF;
1617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1618: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1619: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1620: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHANGE_ITEM_LC_DEPENDENCIES');
1621: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1622: x_msg_count := 1;
1623: x_msg_data := FND_MESSAGE.GET;

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

1616: END IF;
1617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1618: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1619: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1620: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHANGE_ITEM_LC_DEPENDENCIES');
1621: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1622: x_msg_count := 1;
1623: x_msg_data := FND_MESSAGE.GET;
1624: code_debug(' Exception in '||l_api_name ||': '||x_msg_data );

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

1617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1618: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1619: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1620: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHANGE_ITEM_LC_DEPENDENCIES');
1621: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1622: x_msg_count := 1;
1623: x_msg_data := FND_MESSAGE.GET;
1624: code_debug(' Exception in '||l_api_name ||': '||x_msg_data );
1625: END Change_Item_LC_Dependecies;

Line 1623: x_msg_data := FND_MESSAGE.GET;

1619: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1620: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHANGE_ITEM_LC_DEPENDENCIES');
1621: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1622: x_msg_count := 1;
1623: x_msg_data := FND_MESSAGE.GET;
1624: code_debug(' Exception in '||l_api_name ||': '||x_msg_data );
1625: END Change_Item_LC_Dependecies;
1626:
1627:

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

1710: IF FND_API.To_Boolean( p_commit ) THEN
1711: ROLLBACK TO Create_Phase_History_SP;
1712: END IF;
1713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1714: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1715: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1716: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CREATE_PHASE_HISTORY_RECORD');
1717: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1718: x_msg_count := 1;

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

1711: ROLLBACK TO Create_Phase_History_SP;
1712: END IF;
1713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1714: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1715: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1716: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CREATE_PHASE_HISTORY_RECORD');
1717: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1718: x_msg_count := 1;
1719: x_msg_data := FND_MESSAGE.GET;

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

1712: END IF;
1713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1714: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1715: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1716: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CREATE_PHASE_HISTORY_RECORD');
1717: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1718: x_msg_count := 1;
1719: x_msg_data := FND_MESSAGE.GET;
1720: END Create_phase_History_Record;

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

1713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1714: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1715: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1716: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CREATE_PHASE_HISTORY_RECORD');
1717: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1718: x_msg_count := 1;
1719: x_msg_data := FND_MESSAGE.GET;
1720: END Create_phase_History_Record;
1721:

Line 1719: x_msg_data := FND_MESSAGE.GET;

1715: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1716: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CREATE_PHASE_HISTORY_RECORD');
1717: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
1718: x_msg_count := 1;
1719: x_msg_data := FND_MESSAGE.GET;
1720: END Create_phase_History_Record;
1721:
1722: ------------------------------------------------------------------------------
1723: -- Start OF comments

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

1779: IF p_change_line_id IS NOT NULL THEN
1780: --
1781: -- this should never occur
1782: --
1783: FND_MESSAGE.Set_Name(G_APP_NAME, 'EGO_PKG_MAND_VALUES_MISS');
1784: FND_MESSAGE.Set_Token('PACKAGE', G_PKG_NAME||l_api_name);
1785: FND_MESSAGE.Set_Token('VALUE1', 'CHECK_ID');
1786: FND_MESSAGE.Set_Token('VALUE2', 'CHANGE_LINE_ID');
1787: x_msg_count := 1;

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

1780: --
1781: -- this should never occur
1782: --
1783: FND_MESSAGE.Set_Name(G_APP_NAME, 'EGO_PKG_MAND_VALUES_MISS');
1784: FND_MESSAGE.Set_Token('PACKAGE', G_PKG_NAME||l_api_name);
1785: FND_MESSAGE.Set_Token('VALUE1', 'CHECK_ID');
1786: FND_MESSAGE.Set_Token('VALUE2', 'CHANGE_LINE_ID');
1787: x_msg_count := 1;
1788: x_msg_data := FND_MESSAGE.GET;

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

1781: -- this should never occur
1782: --
1783: FND_MESSAGE.Set_Name(G_APP_NAME, 'EGO_PKG_MAND_VALUES_MISS');
1784: FND_MESSAGE.Set_Token('PACKAGE', G_PKG_NAME||l_api_name);
1785: FND_MESSAGE.Set_Token('VALUE1', 'CHECK_ID');
1786: FND_MESSAGE.Set_Token('VALUE2', 'CHANGE_LINE_ID');
1787: x_msg_count := 1;
1788: x_msg_data := FND_MESSAGE.GET;
1789: x_return_status := FND_API.G_RET_STS_ERROR;

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

1782: --
1783: FND_MESSAGE.Set_Name(G_APP_NAME, 'EGO_PKG_MAND_VALUES_MISS');
1784: FND_MESSAGE.Set_Token('PACKAGE', G_PKG_NAME||l_api_name);
1785: FND_MESSAGE.Set_Token('VALUE1', 'CHECK_ID');
1786: FND_MESSAGE.Set_Token('VALUE2', 'CHANGE_LINE_ID');
1787: x_msg_count := 1;
1788: x_msg_data := FND_MESSAGE.GET;
1789: x_return_status := FND_API.G_RET_STS_ERROR;
1790: RETURN;

Line 1788: x_msg_data := FND_MESSAGE.GET;

1784: FND_MESSAGE.Set_Token('PACKAGE', G_PKG_NAME||l_api_name);
1785: FND_MESSAGE.Set_Token('VALUE1', 'CHECK_ID');
1786: FND_MESSAGE.Set_Token('VALUE2', 'CHANGE_LINE_ID');
1787: x_msg_count := 1;
1788: x_msg_data := FND_MESSAGE.GET;
1789: x_return_status := FND_API.G_RET_STS_ERROR;
1790: RETURN;
1791: END IF;
1792: l_change_notice := FND_API.G_MISS_CHAR;

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

2151: IF l_dynamic_cursor%ISOPEN THEN
2152: CLOSE l_dynamic_cursor;
2153: END IF;
2154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2155: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
2156: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
2157: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHECK_PENDING_CHANGE_ORDERS');
2158: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
2159: x_msg_count := 1;

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

2152: CLOSE l_dynamic_cursor;
2153: END IF;
2154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2155: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
2156: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
2157: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHECK_PENDING_CHANGE_ORDERS');
2158: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
2159: x_msg_count := 1;
2160: x_msg_data := FND_MESSAGE.GET;

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

2153: END IF;
2154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2155: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
2156: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
2157: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHECK_PENDING_CHANGE_ORDERS');
2158: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
2159: x_msg_count := 1;
2160: x_msg_data := FND_MESSAGE.GET;
2161: END Check_pending_Change_Orders;

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

2154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2155: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
2156: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
2157: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHECK_PENDING_CHANGE_ORDERS');
2158: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
2159: x_msg_count := 1;
2160: x_msg_data := FND_MESSAGE.GET;
2161: END Check_pending_Change_Orders;
2162:

Line 2160: x_msg_data := FND_MESSAGE.GET;

2156: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
2157: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHECK_PENDING_CHANGE_ORDERS');
2158: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
2159: x_msg_count := 1;
2160: x_msg_data := FND_MESSAGE.GET;
2161: END Check_pending_Change_Orders;
2162:
2163:
2164: END EGO_INV_ITEM_CATALOG_PVT;