128: p_sel_tab := g_sel_tab;
129:
130: EXCEPTION
131: WHEN OTHERS THEN
132: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
133: THEN
134: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
135: , 'get_type_struct'
136: );
130: EXCEPTION
131: WHEN OTHERS THEN
132: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
133: THEN
134: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
135: , 'get_type_struct'
136: );
137: END IF;
138: RAISE;
165: g_sel_tab := p_sel_tab;
166:
167: EXCEPTION
168: WHEN OTHERS THEN
169: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
170: THEN
171: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
172: , 'set_type_struct'
173: );
167: EXCEPTION
168: WHEN OTHERS THEN
169: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
170: THEN
171: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
172: , 'set_type_struct'
173: );
174: END IF;
175: RAISE;
313: END LOOP;
314:
315: EXCEPTION
316: WHEN OTHERS THEN
317: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
318: THEN
319: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
320: , 'populate_type_struct'
321: );
315: EXCEPTION
316: WHEN OTHERS THEN
317: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
318: THEN
319: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
320: , 'populate_type_struct'
321: );
322: END IF;
323: RAISE;
341: g_current_att_index := 0;
342:
343: EXCEPTION
344: WHEN OTHERS THEN
345: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
346: THEN
347: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
348: , 'clear_type_struct'
349: );
343: EXCEPTION
344: WHEN OTHERS THEN
345: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
346: THEN
347: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
348: , 'clear_type_struct'
349: );
350: END IF;
351: RAISE;
1151: COMMIT;
1152:
1153: EXCEPTION
1154: WHEN OTHERS THEN
1155: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1156: THEN
1157: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
1158: , 'populate_temp_table'
1159: );
1153: EXCEPTION
1154: WHEN OTHERS THEN
1155: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1156: THEN
1157: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
1158: , 'populate_temp_table'
1159: );
1160: END IF;
1161: RAISE;
1187: commit;
1188:
1189: EXCEPTION
1190: WHEN OTHERS THEN
1191: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1192: THEN
1193: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
1194: , 'clear_temp_table'
1195: );
1189: EXCEPTION
1190: WHEN OTHERS THEN
1191: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1192: THEN
1193: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
1194: , 'clear_temp_table'
1195: );
1196: END IF;
1197: RAISE;
1250: p_org_tab := g_org_tab;
1251:
1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1255: THEN
1256: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
1257: , 'find_org_list'
1258: );
1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1255: THEN
1256: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
1257: , 'find_org_list'
1258: );
1259: END IF;
1260: END find_org_list;
1287: x_retcode := 0;
1288:
1289: EXCEPTION
1290: WHEN OTHERS THEN
1291: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1292: THEN
1293: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
1294: , 'call_item_update'
1295: );
1289: EXCEPTION
1290: WHEN OTHERS THEN
1291: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1292: THEN
1293: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
1294: , 'call_item_update'
1295: );
1296: END IF;
1297: x_retcode := 2;
1294: , 'call_item_update'
1295: );
1296: END IF;
1297: x_retcode := 2;
1298: x_errbuff := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
1299: END call_item_update;
1300:
1301: --=========================================================================
1302: -- PROCEDURE : Determine_Return_Code PRIVATE
2064: FND_MESSAGE.Set_Name('INV', 'INV_UNABLE_TO_SUBMIT_CONC');
2065: x_errbuff := SUBSTR(FND_MESSAGE.Get, 1, 255);
2066: x_retcode := RETCODE_ERROR;
2067: WHEN OTHERS THEN
2068: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2069: THEN
2070: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
2071: , 'batch_item_update'
2072: );
2066: x_retcode := RETCODE_ERROR;
2067: WHEN OTHERS THEN
2068: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2069: THEN
2070: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
2071: , 'batch_item_update'
2072: );
2073: x_retcode := RETCODE_ERROR;
2074: x_errbuff := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
2070: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
2071: , 'batch_item_update'
2072: );
2073: x_retcode := RETCODE_ERROR;
2074: x_errbuff := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
2075: END IF;
2076:
2077: END batch_item_update;
2078:
2154: x_seq_id := l_seq_id;
2155:
2156: EXCEPTION
2157: WHEN OTHERS THEN
2158: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2159: THEN
2160: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
2161: , 'populate_temp_tables'
2162: );
2156: EXCEPTION
2157: WHEN OTHERS THEN
2158: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2159: THEN
2160: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
2161: , 'populate_temp_tables'
2162: );
2163: END IF;
2164: RAISE;