61: END IF;
62:
63: -- Debug Message
64: IF g_debug THEN
65: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
66: END IF;
67: -- Initialize API return status to sucess
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69:
106: l_txn_hdr_rec.LAST_REFRESHED_DATE, l_txn_hdr_rec.TRX_CURRENCY);
107:
108: -- Debug Message
109: IF g_debug THEN
110: DPP_UTILITY_PVT.debug_message('Debug Profile Option Value: ' || l_profile_option_value || '. Record inserted into DPP_TRANSACTION_HEADERS_LOG.');
111: END IF;
112:
113: ELSE
114: -- Debug Message
112:
113: ELSE
114: -- Debug Message
115: IF g_debug THEN
116: DPP_UTILITY_PVT.debug_message('Debug Profile Option Value: ' || l_profile_option_value || '. No Logging.');
117: END IF;
118:
119: END IF;
120:
124: COMMIT WORK;
125: END IF;
126: -- Debug Message
127: IF g_debug THEN
128: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
129: END IF;
130: -- Standard call to get message count and if count is 1, get message info.
131: FND_MSG_PUB.Count_And_Get
132: (p_count => x_msg_count,
207: END IF;
208:
209: -- Debug Message
210: IF g_debug THEN
211: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
212: END IF;
213: -- Initialize API return status to sucess
214: x_return_status := FND_API.G_RET_STS_SUCCESS;
215:
268: END LOOP;
269:
270: -- Debug Message
271: IF g_debug THEN
272: DPP_UTILITY_PVT.debug_message('Debug Profile Option Value: ' || l_profile_option_value || '. Record(s) inserted into DPP_TRANSACTION_LINES_LOG.');
273: END IF;
274:
275: ELSE
276: -- Debug Message
274:
275: ELSE
276: -- Debug Message
277: IF g_debug THEN
278: DPP_UTILITY_PVT.debug_message('Debug Profile Option Value: ' || l_profile_option_value || '. No Logging.');
279: END IF;
280:
281: END IF;
282:
286: COMMIT WORK;
287: END IF;
288: -- Debug Message
289: IF g_debug THEN
290: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
291: END IF;
292: -- Standard call to get message count and if count is 1, get message info.
293: FND_MSG_PUB.Count_And_Get
294: (p_count => x_msg_count,
351: END IF;
352:
353: -- Debug Message
354: IF g_debug THEN
355: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
356: END IF;
357: -- Initialize API return status to sucess
358: x_return_status := FND_API.G_RET_STS_SUCCESS;
359:
406: END LOOP;
407:
408: -- Debug Message
409: IF g_debug THEN
410: DPP_UTILITY_PVT.debug_message('Debug Profile Option Value: ' || l_profile_option_value || '. Record(s) inserted into DPP_CUSTOMER_CLAIMS_LOG.');
411: END IF;
412:
413: ELSE
414: -- Debug Message
412:
413: ELSE
414: -- Debug Message
415: IF g_debug THEN
416: DPP_UTILITY_PVT.debug_message('Debug Profile Option Value: ' || l_profile_option_value || '. No Logging.');
417: END IF;
418:
419: END IF;
420:
424: COMMIT WORK;
425: END IF;
426: -- Debug Message
427: IF g_debug THEN
428: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
429: END IF;
430: -- Standard call to get message count and if count is 1, get message info.
431: FND_MSG_PUB.Count_And_Get
432: (p_count => x_msg_count,