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.AMS_ADI_COMMON_PVT dependencies on FND_API

Line 65: p_commit IN VARCHAR2 := FND_API.G_TRUE

61: -- HISTORY
62: --
63: --========================================================================
64: PROCEDURE handle_success_row(
65: p_commit IN VARCHAR2 := FND_API.G_TRUE
66: )
67: IS
68: BEGIN
69: IF(p_commit = FND_API.G_TRUE) THEN

Line 69: IF(p_commit = FND_API.G_TRUE) THEN

65: p_commit IN VARCHAR2 := FND_API.G_TRUE
66: )
67: IS
68: BEGIN
69: IF(p_commit = FND_API.G_TRUE) THEN
70: COMMIT; --commits the current row processed
71: END IF;
72: g_success_row_count := g_success_row_count+1;
73: END handle_success_row;

Line 89: p_write_conc_log IN VARCHAR2 := FND_API.G_TRUE,

85: -- HISTORY
86: --
87: --========================================================================
88: PROCEDURE handle_error_row(
89: p_write_conc_log IN VARCHAR2 := FND_API.G_TRUE,
90: p_rollback IN VARCHAR2 := FND_API.G_TRUE,
91: p_error_code IN VARCHAR2 := NULL,
92: p_error_message IN VARCHAR2 := NULL,
93: p_object_id IN NUMBER,

Line 90: p_rollback IN VARCHAR2 := FND_API.G_TRUE,

86: --
87: --========================================================================
88: PROCEDURE handle_error_row(
89: p_write_conc_log IN VARCHAR2 := FND_API.G_TRUE,
90: p_rollback IN VARCHAR2 := FND_API.G_TRUE,
91: p_error_code IN VARCHAR2 := NULL,
92: p_error_message IN VARCHAR2 := NULL,
93: p_object_id IN NUMBER,
94: p_object_name IN VARCHAR2,

Line 106: IF (p_rollback = FND_API.G_TRUE) THEN

102: l_error_rec ams_adi_error_rec;
103: l_error_message VARCHAR2(4000) := ' ';
104: l_temp_message VARCHAR2(4000);
105: BEGIN
106: IF (p_rollback = FND_API.G_TRUE) THEN
107: ROLLBACK;
108: END IF;
109:
110: IF(p_write_conc_log = FND_API.G_TRUE) THEN

Line 110: IF(p_write_conc_log = FND_API.G_TRUE) THEN

106: IF (p_rollback = FND_API.G_TRUE) THEN
107: ROLLBACK;
108: END IF;
109:
110: IF(p_write_conc_log = FND_API.G_TRUE) THEN
111: AMS_Utility_PVT.Write_Conc_Log();
112: END IF;
113:
114: g_error_row_count := g_error_row_count+1;

Line 132: l_temp_message := FND_MSG_PUB.get(l_count-l_cnt+1, FND_API.g_false);

128: IF(l_cnt > g_max_error_messages) THEN
129: EXIT; -- g_max_error_messages messages are enough, rest in concurrent log
130: END IF;
131:
132: l_temp_message := FND_MSG_PUB.get(l_count-l_cnt+1, FND_API.g_false);
133:
134: l_cum_length := LENGTH(l_error_message);
135: l_cur_length := LENGTH(l_temp_message)+10;
136:

Line 168: p_write_conc_log IN VARCHAR2 := FND_API.G_TRUE,

164: -- HISTORY
165: --
166: --========================================================================
167: PROCEDURE handle_fatal_error(
168: p_write_conc_log IN VARCHAR2 := FND_API.G_TRUE,
169: p_rollback IN VARCHAR2 := FND_API.G_TRUE
170: )
171: IS
172: l_count PLS_INTEGER;

Line 169: p_rollback IN VARCHAR2 := FND_API.G_TRUE

165: --
166: --========================================================================
167: PROCEDURE handle_fatal_error(
168: p_write_conc_log IN VARCHAR2 := FND_API.G_TRUE,
169: p_rollback IN VARCHAR2 := FND_API.G_TRUE
170: )
171: IS
172: l_count PLS_INTEGER;
173: l_error_rec ams_adi_error_rec;

Line 176: IF (p_rollback = FND_API.G_TRUE) THEN

172: l_count PLS_INTEGER;
173: l_error_rec ams_adi_error_rec;
174: l_error_message VARCHAR2(4000);
175: BEGIN
176: IF (p_rollback = FND_API.G_TRUE) THEN
177: ROLLBACK;
178: END IF;
179:
180: IF(p_write_conc_log = FND_API.G_TRUE) THEN

Line 180: IF(p_write_conc_log = FND_API.G_TRUE) THEN

176: IF (p_rollback = FND_API.G_TRUE) THEN
177: ROLLBACK;
178: END IF;
179:
180: IF(p_write_conc_log = FND_API.G_TRUE) THEN
181: AMS_Utility_PVT.Write_Conc_Log();
182: END IF;
183: END handle_fatal_error;
184:

Line 201: p_use_object_id_as_pk IN VARCHAR2 := FND_API.G_TRUE,

197: --========================================================================
198: PROCEDURE complete_batch(
199: p_update_table_name IN VARCHAR2,
200: p_upload_batch_id IN NUMBER,
201: p_use_object_id_as_pk IN VARCHAR2 := FND_API.G_TRUE,
202: p_commit IN VARCHAR2 := FND_API.G_TRUE,
203: p_error_records IN OUT NOCOPY ams_adi_error_rec_t
204: )
205: IS

Line 202: p_commit IN VARCHAR2 := FND_API.G_TRUE,

198: PROCEDURE complete_batch(
199: p_update_table_name IN VARCHAR2,
200: p_upload_batch_id IN NUMBER,
201: p_use_object_id_as_pk IN VARCHAR2 := FND_API.G_TRUE,
202: p_commit IN VARCHAR2 := FND_API.G_TRUE,
203: p_error_records IN OUT NOCOPY ams_adi_error_rec_t
204: )
205: IS
206: l_count PLS_INTEGER := 0;

Line 214: IF(p_commit = FND_API.G_TRUE) THEN

210: l_object_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
211: l_object_names ams_object_names_t := ams_object_names_t();
212: l_parent_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
213: BEGIN
214: IF(p_commit = FND_API.G_TRUE) THEN
215: COMMIT; --commits the current row processed
216: END IF;
217:
218: IF (AMS_DEBUG_HIGH_ON) THEN

Line 224: IF(p_use_object_id_as_pk = FND_API.G_TRUE) THEN

220: END IF;
221:
222: l_count := p_error_records.COUNT;
223:
224: IF(p_use_object_id_as_pk = FND_API.G_TRUE) THEN
225: -- use object id as primary key
226:
227: IF (AMS_DEBUG_HIGH_ON) THEN
228: AMS_UTILITY_PVT.debug_message('Using Id primary key');

Line 299: p_write_conc_out IN VARCHAR2 := FND_API.G_TRUE,

295: -- HISTORY
296: --
297: --========================================================================
298: PROCEDURE complete_all(
299: p_write_conc_out IN VARCHAR2 := FND_API.G_TRUE,
300: p_commit IN VARCHAR2 := FND_API.G_TRUE,
301: p_upload_batch_id IN NUMBER := 0
302: )
303: IS

Line 300: p_commit IN VARCHAR2 := FND_API.G_TRUE,

296: --
297: --========================================================================
298: PROCEDURE complete_all(
299: p_write_conc_out IN VARCHAR2 := FND_API.G_TRUE,
300: p_commit IN VARCHAR2 := FND_API.G_TRUE,
301: p_upload_batch_id IN NUMBER := 0
302: )
303: IS
304: BEGIN

Line 310: IF(p_commit = FND_API.G_TRUE) THEN

306: set operation_status = 'SUCCESS'
307: where upload_batch_id = p_upload_batch_id
308: and operation_status = 'NEW';
309:
310: IF(p_commit = FND_API.G_TRUE) THEN
311: COMMIT; -- commits all
312: END IF;
313:
314: IF(p_write_conc_out = FND_API.G_TRUE) THEN

Line 314: IF(p_write_conc_out = FND_API.G_TRUE) THEN

310: IF(p_commit = FND_API.G_TRUE) THEN
311: COMMIT; -- commits all
312: END IF;
313:
314: IF(p_write_conc_out = FND_API.G_TRUE) THEN
315: AMS_Utility_PVT.Write_Conc_Log();
316: END IF;
317: END complete_all;
318: