1755:
1756: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1757:
1758: EXCEPTION
1759: WHEN FND_API.G_EXC_ERROR THEN
1760: -- -------------------------------------------------------------------
1761: -- Retrieve the last message from the message queue which
1762: -- contains the exception raised by the called program
1763: -- e.g. currency_conversion
1769: -- Go back to the second to last message which contains the message
1770: -- raised by the called program (e.g. currency_conversion)
1771: -- -------------------------------------------------------------------
1772: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
1773: p_encoded => FND_API.g_false);
1774: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
1775: p_encoded => FND_API.g_false);
1776: Debug(l_last_message);
1777:
1771: -- -------------------------------------------------------------------
1772: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
1773: p_encoded => FND_API.g_false);
1774: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
1775: p_encoded => FND_API.g_false);
1776: Debug(l_last_message);
1777:
1778: Debug('Attribute ID: ' || x.attribute_id);
1779: Debug('~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~');
2569: (DBMS_UTILITY.get_time - l_start2) || ' hsec');
2570:
2571:
2572: EXCEPTION
2573: WHEN FND_API.G_EXC_ERROR THEN
2574: Debug('&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&');
2575: -- -------------------------------------------------------------------
2576: -- Retrieve the last message from the message queue which
2577: -- contains the exception raised by the called program
2584: -- Go back to the second to last message which contains the message
2585: -- raised by the called program (e.g. currency_conversion)
2586: -- -------------------------------------------------------------------
2587: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
2588: p_encoded => FND_API.g_false);
2589: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
2590: p_encoded => FND_API.g_false);
2591: Debug(l_last_message);
2592:
2586: -- -------------------------------------------------------------------
2587: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
2588: p_encoded => FND_API.g_false);
2589: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
2590: p_encoded => FND_API.g_false);
2591: Debug(l_last_message);
2592:
2593: Debug('----------------------------------------------------');
2594: Debug('Attribute ID: ' || x.attribute_id);
3286: END IF;
3287: END If;
3288:
3289: EXCEPTION
3290: WHEN FND_API.G_EXC_ERROR THEN
3291: -- -------------------------------------------------------------------
3292: -- Retrieve the last message from the message queue which
3293: -- contains the exception raised by the called program
3294: -- e.g. currency_conversion
3300: -- Go back to the second to last message which contains the message
3301: -- raised by the called program (e.g. currency_conversion)
3302: -- -------------------------------------------------------------------
3303: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
3304: p_encoded => FND_API.g_false);
3305: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
3306: p_encoded => FND_API.g_false);
3307: Debug(l_last_message);
3308:
3302: -- -------------------------------------------------------------------
3303: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
3304: p_encoded => FND_API.g_false);
3305: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
3306: p_encoded => FND_API.g_false);
3307: Debug(l_last_message);
3308:
3309: Debug('Attribute ID: ' || p_attribute_id);
3310: Debug('Partner ID: ' || p_partner_id);
3402: Debug('Full Refresh of performance attributes does not use sql_text.');
3403: END If;
3404:
3405: EXCEPTION
3406: WHEN FND_API.G_EXC_ERROR THEN
3407: -- -------------------------------------------------------------------
3408: -- Retrieve the last message from the message queue which
3409: -- contains the exception raised by the called program
3410: -- e.g. currency_conversion
3416: -- Go back to the second to last message which contains the message
3417: -- raised by the called program (e.g. currency_conversion)
3418: -- -------------------------------------------------------------------
3419: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
3420: p_encoded => FND_API.g_false);
3421: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
3422: p_encoded => FND_API.g_false);
3423: Debug(l_last_message);
3424:
3418: -- -------------------------------------------------------------------
3419: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
3420: p_encoded => FND_API.g_false);
3421: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
3422: p_encoded => FND_API.g_false);
3423: Debug(l_last_message);
3424:
3425: Debug('Attribute ID: ' || p_attribute_id);
3426: Debug('Partner ID: ' || p_partner_id);