DBA Data[Home] [Help]

APPS.INV_ITEM_REVISION_PUB dependencies on ERROR_HANDLER

Line 120: Error_Handler.Add_Error_Message

116: BEGIN
117:
118: IF G_Message_API = 'BOM' THEN
119: IF p_message_text IS NULL THEN
120: Error_Handler.Add_Error_Message
121: ( p_message_name => p_message_name
122: , p_application_id => p_application_short_name
123: , p_token_tbl => Error_Handler.G_MISS_TOKEN_TBL
124: , p_message_type => 'E'

Line 123: , p_token_tbl => Error_Handler.G_MISS_TOKEN_TBL

119: IF p_message_text IS NULL THEN
120: Error_Handler.Add_Error_Message
121: ( p_message_name => p_message_name
122: , p_application_id => p_application_short_name
123: , p_token_tbl => Error_Handler.G_MISS_TOKEN_TBL
124: , p_message_type => 'E'
125: , p_row_identifier => NULL
126: , p_entity_id => NULL
127: , p_entity_index => NULL

Line 132: Error_Handler.Add_Error_Message

128: , p_table_name => NULL
129: , p_entity_code => 'INV_ITEM_REVISION'
130: );
131: ELSE
132: Error_Handler.Add_Error_Message
133: ( p_message_text => p_message_text
134: , p_message_type => 'E'
135: , p_row_identifier => NULL
136: , p_entity_id => NULL

Line 179: IF Error_Handler.Get_Debug = 'Y' THEN

175: IS
176:
177: BEGIN
178:
179: IF Error_Handler.Get_Debug = 'Y' THEN
180: Error_Handler.Write_Debug (p_debug_message);
181: END IF;
182:
183: END;

Line 180: Error_Handler.Write_Debug (p_debug_message);

176:
177: BEGIN
178:
179: IF Error_Handler.Get_Debug = 'Y' THEN
180: Error_Handler.Write_Debug (p_debug_message);
181: END IF;
182:
183: END;
184:

Line 1127: x_msg_count := Error_Handler.Get_Message_Count;

1123:
1124: -- Standard call to get message count and if count is 1, get message info.
1125:
1126: IF G_Message_API = 'BOM' THEN
1127: x_msg_count := Error_Handler.Get_Message_Count;
1128: ELSE
1129: FND_MSG_PUB.Count_And_Get
1130: ( p_count => x_msg_count
1131: , p_data => x_msg_data

Line 1148: x_msg_count := Error_Handler.Get_Message_Count;

1144: ROLLBACK TO Create_Item_Revision_PUB;
1145: x_return_status := FND_API.g_RET_STS_ERROR;
1146:
1147: IF G_Message_API = 'BOM' THEN
1148: x_msg_count := Error_Handler.Get_Message_Count;
1149: ELSE
1150: FND_MSG_PUB.Count_And_Get
1151: ( p_count => x_msg_count
1152: , p_data => x_msg_data

Line 1166: x_msg_count := Error_Handler.Get_Message_Count;

1162: ROLLBACK TO Create_Item_Revision_PUB;
1163: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
1164:
1165: IF G_Message_API = 'BOM' THEN
1166: x_msg_count := Error_Handler.Get_Message_Count;
1167: ELSE
1168: FND_MSG_PUB.Count_And_Get
1169: ( p_count => x_msg_count
1170: , p_data => x_msg_data

Line 1189: x_msg_count := Error_Handler.Get_Message_Count;

1185: , p_message_text => 'UNEXP_ERROR : ' || SQLERRM
1186: );
1187:
1188: IF G_Message_API = 'BOM' THEN
1189: x_msg_count := Error_Handler.Get_Message_Count;
1190: ELSE
1191: FND_MSG_PUB.Count_And_Get
1192: ( p_count => x_msg_count
1193: , p_data => x_msg_data

Line 1813: x_msg_count := Error_Handler.Get_Message_Count;

1809:
1810: -- Standard call to get message count and if count is 1, get message info.
1811:
1812: IF G_Message_API = 'BOM' THEN
1813: x_msg_count := Error_Handler.Get_Message_Count;
1814: ELSE
1815: FND_MSG_PUB.Count_And_Get
1816: ( p_count => x_msg_count
1817: , p_data => x_msg_data

Line 1833: x_msg_count := Error_Handler.Get_Message_Count;

1829: ROLLBACK TO Update_Item_Revision_PUB;
1830: x_return_status := FND_API.g_RET_STS_ERROR;
1831:
1832: IF G_Message_API = 'BOM' THEN
1833: x_msg_count := Error_Handler.Get_Message_Count;
1834: ELSE
1835: FND_MSG_PUB.Count_And_Get
1836: ( p_count => x_msg_count
1837: , p_data => x_msg_data

Line 1851: x_msg_count := Error_Handler.Get_Message_Count;

1847: ROLLBACK TO Update_Item_Revision_PUB;
1848: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
1849:
1850: IF G_Message_API = 'BOM' THEN
1851: x_msg_count := Error_Handler.Get_Message_Count;
1852: ELSE
1853: FND_MSG_PUB.Count_And_Get
1854: ( p_count => x_msg_count
1855: , p_data => x_msg_data

Line 1874: x_msg_count := Error_Handler.Get_Message_Count;

1870: , p_message_text => 'UNEXP_ERROR : ' || SQLERRM
1871: );
1872:
1873: IF G_Message_API = 'BOM' THEN
1874: x_msg_count := Error_Handler.Get_Message_Count;
1875: ELSE
1876: FND_MSG_PUB.Count_And_Get
1877: ( p_count => x_msg_count
1878: , p_data => x_msg_data

Line 1982: x_msg_count := Error_Handler.Get_Message_Count;

1978:
1979: -- Standard call to get message count and if count is 1, get message info.
1980:
1981: IF G_Message_API = 'BOM' THEN
1982: x_msg_count := Error_Handler.Get_Message_Count;
1983: ELSE
1984: FND_MSG_PUB.Count_And_Get
1985: ( p_count => x_msg_count
1986: , p_data => x_msg_data

Line 2002: x_msg_count := Error_Handler.Get_Message_Count;

1998: ROLLBACK TO Lock_Item_Revision_PUB;
1999: x_return_status := FND_API.g_RET_STS_ERROR;
2000:
2001: IF G_Message_API = 'BOM' THEN
2002: x_msg_count := Error_Handler.Get_Message_Count;
2003: ELSE
2004: FND_MSG_PUB.Count_And_Get
2005: ( p_count => x_msg_count
2006: , p_data => x_msg_data

Line 2020: x_msg_count := Error_Handler.Get_Message_Count;

2016: ROLLBACK TO Lock_Item_Revision_PUB;
2017: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2018:
2019: IF G_Message_API = 'BOM' THEN
2020: x_msg_count := Error_Handler.Get_Message_Count;
2021: ELSE
2022: FND_MSG_PUB.Count_And_Get
2023: ( p_count => x_msg_count
2024: , p_data => x_msg_data

Line 2043: x_msg_count := Error_Handler.Get_Message_Count;

2039: , p_message_text => 'UNEXP_ERROR : ' || SQLERRM
2040: );
2041:
2042: IF G_Message_API = 'BOM' THEN
2043: x_msg_count := Error_Handler.Get_Message_Count;
2044: ELSE
2045: FND_MSG_PUB.Count_And_Get
2046: ( p_count => x_msg_count
2047: , p_data => x_msg_data

Line 2178: x_msg_count := Error_Handler.Get_Message_Count;

2174:
2175: -- Standard call to get message count and if count is 1, get message info.
2176:
2177: IF G_Message_API = 'BOM' THEN
2178: x_msg_count := Error_Handler.Get_Message_Count;
2179: ELSE
2180: FND_MSG_PUB.Count_And_Get
2181: ( p_count => x_msg_count
2182: , p_data => x_msg_data

Line 2198: x_msg_count := Error_Handler.Get_Message_Count;

2194: ROLLBACK TO Delete_Item_Revision_PUB;
2195: x_return_status := FND_API.g_RET_STS_ERROR;
2196:
2197: IF G_Message_API = 'BOM' THEN
2198: x_msg_count := Error_Handler.Get_Message_Count;
2199: ELSE
2200: FND_MSG_PUB.Count_And_Get
2201: ( p_count => x_msg_count
2202: , p_data => x_msg_data

Line 2216: x_msg_count := Error_Handler.Get_Message_Count;

2212: ROLLBACK TO Delete_Item_Revision_PUB;
2213: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2214:
2215: IF G_Message_API = 'BOM' THEN
2216: x_msg_count := Error_Handler.Get_Message_Count;
2217: ELSE
2218: FND_MSG_PUB.Count_And_Get
2219: ( p_count => x_msg_count
2220: , p_data => x_msg_data

Line 2239: x_msg_count := Error_Handler.Get_Message_Count;

2235: , p_message_text => 'UNEXP_ERROR : ' || SQLERRM
2236: );
2237:
2238: IF G_Message_API = 'BOM' THEN
2239: x_msg_count := Error_Handler.Get_Message_Count;
2240: ELSE
2241: FND_MSG_PUB.Count_And_Get
2242: ( p_count => x_msg_count
2243: , p_data => x_msg_data

Line 2321: Error_Handler.Initialize;

2317:
2318: -- Initialize message list
2319: IF G_Message_API = 'BOM' THEN
2320: IF FND_API.To_Boolean (p_init_msg_list) THEN
2321: Error_Handler.Initialize;
2322: Error_Handler.Set_BO_Identifier ('INV_ITEM_REVISION');
2323: END IF;
2324: ELSE
2325: /* G_Message_API = 'FND' THEN */

Line 2322: Error_Handler.Set_BO_Identifier ('INV_ITEM_REVISION');

2318: -- Initialize message list
2319: IF G_Message_API = 'BOM' THEN
2320: IF FND_API.To_Boolean (p_init_msg_list) THEN
2321: Error_Handler.Initialize;
2322: Error_Handler.Set_BO_Identifier ('INV_ITEM_REVISION');
2323: END IF;
2324: ELSE
2325: /* G_Message_API = 'FND' THEN */
2326: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 2335: Error_Handler.Set_Debug (p_debug_flag => 'Y');

2331: -- Open the debug session
2332:
2333: IF p_debug = 'Y' THEN
2334:
2335: Error_Handler.Set_Debug (p_debug_flag => 'Y');
2336:
2337: Error_Handler.Open_Debug_Session
2338: ( p_debug_filename => p_debug_filename
2339: , p_output_dir => p_output_dir

Line 2337: Error_Handler.Open_Debug_Session

2333: IF p_debug = 'Y' THEN
2334:
2335: Error_Handler.Set_Debug (p_debug_flag => 'Y');
2336:
2337: Error_Handler.Open_Debug_Session
2338: ( p_debug_filename => p_debug_filename
2339: , p_output_dir => p_output_dir
2340: , x_return_status => l_debug_return_status
2341: , x_error_mesg => l_debug_error_message

Line 2351: Error_Handler.Write_Debug('Debug file mode is '||Error_Handler.Get_Debug);

2347: END IF;
2348:
2349: END IF;
2350:
2351: Error_Handler.Write_Debug('Debug file mode is '||Error_Handler.Get_Debug);
2352:
2353: Error_Handler.Write_Debug('Sysdate is '||to_char(G_sysdate,'DD-MON-YYYY HH24:MI:SS')||' Effectivity date is '||to_char(p_effectivity_date,'DD-MON-YYYY HH24:MI:SS'));
2354:
2355: -- Convert the transaction type if it is SYNC

Line 2353: Error_Handler.Write_Debug('Sysdate is '||to_char(G_sysdate,'DD-MON-YYYY HH24:MI:SS')||' Effectivity date is '||to_char(p_effectivity_date,'DD-MON-YYYY HH24:MI:SS'));

2349: END IF;
2350:
2351: Error_Handler.Write_Debug('Debug file mode is '||Error_Handler.Get_Debug);
2352:
2353: Error_Handler.Write_Debug('Sysdate is '||to_char(G_sysdate,'DD-MON-YYYY HH24:MI:SS')||' Effectivity date is '||to_char(p_effectivity_date,'DD-MON-YYYY HH24:MI:SS'));
2354:
2355: -- Convert the transaction type if it is SYNC
2356:
2357: IF p_transaction_type = 'SYNC' THEN

Line 2389: x_msg_count := Error_Handler.Get_Message_Count;

2385: Add_Message ('INV', 'INV_INVALID_TRANS_TYPE');
2386: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2387:
2388: IF G_Message_API = 'BOM' THEN
2389: x_msg_count := Error_Handler.Get_Message_Count;
2390: ELSE
2391: FND_MSG_PUB.Count_And_Get
2392: ( p_count => x_msg_count
2393: , p_data => l_msg_data

Line 2401: IF Error_Handler.Get_Debug = 'Y' THEN

2397: l_msg_data := fnd_msg_pub.get(x_msg_count,FND_API.G_FALSE);
2398: END IF;
2399: END IF;
2400:
2401: IF Error_Handler.Get_Debug = 'Y' THEN
2402: Error_Handler.Close_Debug_Session;
2403: END IF;
2404:
2405: Return;

Line 2402: Error_Handler.Close_Debug_Session;

2398: END IF;
2399: END IF;
2400:
2401: IF Error_Handler.Get_Debug = 'Y' THEN
2402: Error_Handler.Close_Debug_Session;
2403: END IF;
2404:
2405: Return;
2406:

Line 2515: IF Error_Handler.Get_Debug = 'Y' THEN

2511:
2512: x_revision_id := G_revision_id;
2513: x_object_version_number := G_object_version_number;
2514:
2515: IF Error_Handler.Get_Debug = 'Y' THEN
2516: Error_Handler.Close_Debug_Session;
2517: END IF;
2518:
2519: EXCEPTION WHEN OTHERS THEN

Line 2516: Error_Handler.Close_Debug_Session;

2512: x_revision_id := G_revision_id;
2513: x_object_version_number := G_object_version_number;
2514:
2515: IF Error_Handler.Get_Debug = 'Y' THEN
2516: Error_Handler.Close_Debug_Session;
2517: END IF;
2518:
2519: EXCEPTION WHEN OTHERS THEN
2520:

Line 2529: x_msg_count := Error_Handler.Get_Message_Count;

2525: , p_message_text => 'UNEXP_ERROR : ' || SQLERRM
2526: );
2527:
2528: IF G_Message_API = 'BOM' THEN
2529: x_msg_count := Error_Handler.Get_Message_Count;
2530: ELSE
2531: FND_MSG_PUB.Count_And_Get
2532: ( p_count => x_msg_count
2533: , p_data => l_msg_data

Line 2541: IF Error_Handler.Get_Debug = 'Y' THEN

2537: l_msg_data := fnd_msg_pub.get(x_msg_count,FND_API.G_FALSE);
2538: END IF;
2539: END IF;
2540:
2541: IF Error_Handler.Get_Debug = 'Y' THEN
2542: Error_Handler.Close_Debug_Session;
2543: END IF;
2544:
2545: END Process_Item_Revision;

Line 2542: Error_Handler.Close_Debug_Session;

2538: END IF;
2539: END IF;
2540:
2541: IF Error_Handler.Get_Debug = 'Y' THEN
2542: Error_Handler.Close_Debug_Session;
2543: END IF;
2544:
2545: END Process_Item_Revision;
2546: