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.PON_NEGOTIATION_PUBLISH_PVT dependencies on FND_LOG

Line 241: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

237: END IF;
238: EXCEPTION
239: WHEN OTHERS THEN
240:
241: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
242: FND_LOG.string (log_level => FND_LOG.level_exception,
243: module => g_module_prefix || 'VALIDATE_PROJECTS_DETAILS',
244: message => 'Exception occured validate_projects_details'
245: || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200));

Line 242: FND_LOG.string (log_level => FND_LOG.level_exception,

238: EXCEPTION
239: WHEN OTHERS THEN
240:
241: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
242: FND_LOG.string (log_level => FND_LOG.level_exception,
243: module => g_module_prefix || 'VALIDATE_PROJECTS_DETAILS',
244: message => 'Exception occured validate_projects_details'
245: || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200));
246: END IF;

Line 263: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

259: IS
260: l_exhibits_links NUMBER;
261: BEGIN
262:
263: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
264: FND_LOG.string(log_level => FND_LOG.level_procedure,
265: module => g_module_prefix || 'val_exhibits',
266: message => 'Entering PON_NEGOTIATION_HELPER_PVT.val_exhibits'
267: || ', p_auction_header_id = ' || p_auction_header_id

Line 264: FND_LOG.string(log_level => FND_LOG.level_procedure,

260: l_exhibits_links NUMBER;
261: BEGIN
262:
263: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
264: FND_LOG.string(log_level => FND_LOG.level_procedure,
265: module => g_module_prefix || 'val_exhibits',
266: message => 'Entering PON_NEGOTIATION_HELPER_PVT.val_exhibits'
267: || ', p_auction_header_id = ' || p_auction_header_id
268: || ', p_user_id = ' || p_user_id

Line 403: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

399: l_doctype_id PON_AUCTION_HEADERS_ALL.doctype_id%TYPE;
400:
401: BEGIN
402:
403: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
404: FND_LOG.string(log_level => FND_LOG.level_procedure,
405: module => g_module_prefix || 'val_item_prices_all',
406: message => 'Entering PON_NEGOTIATION_HELPER_PVT.val_item_prices_all'
407: || ', p_auction_header_id = ' || p_auction_header_id

Line 404: FND_LOG.string(log_level => FND_LOG.level_procedure,

400:
401: BEGIN
402:
403: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
404: FND_LOG.string(log_level => FND_LOG.level_procedure,
405: module => g_module_prefix || 'val_item_prices_all',
406: message => 'Entering PON_NEGOTIATION_HELPER_PVT.val_item_prices_all'
407: || ', p_auction_header_id = ' || p_auction_header_id
408: || ', p_expiration_date = ' || p_expiration_date

Line 2319: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

2315: PON_AUCTION_ITEM_PRICES_ALL
2316: WHERE
2317: AUCTION_HEADER_ID = p_auction_header_id;
2318:
2319: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
2320: FND_LOG.string(log_level => FND_LOG.level_procedure,
2321: module => g_module_prefix || 'val_item_prices_all',
2322: message => 'Leaving PON_NEGOTIATION_HELPER_PVT.val_item_prices_all'
2323: || ', p_auction_header_id = ' || p_auction_header_id);

Line 2320: FND_LOG.string(log_level => FND_LOG.level_procedure,

2316: WHERE
2317: AUCTION_HEADER_ID = p_auction_header_id;
2318:
2319: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
2320: FND_LOG.string(log_level => FND_LOG.level_procedure,
2321: module => g_module_prefix || 'val_item_prices_all',
2322: message => 'Leaving PON_NEGOTIATION_HELPER_PVT.val_item_prices_all'
2323: || ', p_auction_header_id = ' || p_auction_header_id);
2324: END IF; --}

Line 2359: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --

2355: l_temp NUMBER;
2356: l_temp_fnd NUMBER;
2357: BEGIN
2358:
2359: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --
2360: FND_LOG.string(log_level => FND_LOG.level_procedure,
2361: module => g_module_prefix || 'val_item_prices_po_lines',
2362: message => 'Entering PON_NEGOTIATION_HELPER_PV.val_item_prices_po_lines'
2363: || ', p_auction_header_id = ' || p_auction_header_id);

Line 2360: FND_LOG.string(log_level => FND_LOG.level_procedure,

2356: l_temp_fnd NUMBER;
2357: BEGIN
2358:
2359: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --
2360: FND_LOG.string(log_level => FND_LOG.level_procedure,
2361: module => g_module_prefix || 'val_item_prices_po_lines',
2362: message => 'Entering PON_NEGOTIATION_HELPER_PV.val_item_prices_po_lines'
2363: || ', p_auction_header_id = ' || p_auction_header_id);
2364: END IF; --

Line 2738: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

2734: WHERE
2735: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
2736: PLTB.LINE_TYPE_ID = PAIP.LINE_TYPE_ID;
2737:
2738: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
2739: FND_LOG.string(log_level => FND_LOG.level_procedure,
2740: module => g_module_prefix || 'val_item_prices_po_lines',
2741: message => 'Returning PON_NEGOTIATION_HELPER_PVT.val_item_prices_po_lines'
2742: || ', p_auction_header_id = ' || p_auction_header_id);

Line 2739: FND_LOG.string(log_level => FND_LOG.level_procedure,

2735: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
2736: PLTB.LINE_TYPE_ID = PAIP.LINE_TYPE_ID;
2737:
2738: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
2739: FND_LOG.string(log_level => FND_LOG.level_procedure,
2740: module => g_module_prefix || 'val_item_prices_po_lines',
2741: message => 'Returning PON_NEGOTIATION_HELPER_PVT.val_item_prices_po_lines'
2742: || ', p_auction_header_id = ' || p_auction_header_id);
2743: END IF; --}

Line 2764: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

2760: ) IS
2761:
2762: l_doctype_suffix VARCHAR2(10);
2763: BEGIN
2764: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
2765: FND_LOG.string(log_level => FND_LOG.level_procedure,
2766: module => g_module_prefix || 'VAL_LINE_AMOUNT_MULTI_CURR',
2767: message => 'Entering PON_NEGOTIATION_HELPER_PVT.VAL_LINE_AMOUNT_MULTI_CURR'
2768: || ', p_auction_header_id = ' || p_auction_header_id);

Line 2765: FND_LOG.string(log_level => FND_LOG.level_procedure,

2761:
2762: l_doctype_suffix VARCHAR2(10);
2763: BEGIN
2764: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
2765: FND_LOG.string(log_level => FND_LOG.level_procedure,
2766: module => g_module_prefix || 'VAL_LINE_AMOUNT_MULTI_CURR',
2767: message => 'Entering PON_NEGOTIATION_HELPER_PVT.VAL_LINE_AMOUNT_MULTI_CURR'
2768: || ', p_auction_header_id = ' || p_auction_header_id);
2769: END IF; --}

Line 2807: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

2803: PLTB.ORDER_TYPE_LOOKUP_CODE = g_amount AND
2804: ROWNUM =1;
2805: END IF; --}
2806:
2807: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
2808: FND_LOG.string(log_level => FND_LOG.level_procedure,
2809: module => g_module_prefix || 'VAL_LINE_AMOUNT_MULTI_CURR',
2810: message => 'Returning PON_NEGOTIATION_HELPER_PVT.VAL_LINE_AMOUNT_MULTI_CURR'
2811: || ', p_auction_header_id = ' || p_auction_header_id);

Line 2808: FND_LOG.string(log_level => FND_LOG.level_procedure,

2804: ROWNUM =1;
2805: END IF; --}
2806:
2807: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
2808: FND_LOG.string(log_level => FND_LOG.level_procedure,
2809: module => g_module_prefix || 'VAL_LINE_AMOUNT_MULTI_CURR',
2810: message => 'Returning PON_NEGOTIATION_HELPER_PVT.VAL_LINE_AMOUNT_MULTI_CURR'
2811: || ', p_auction_header_id = ' || p_auction_header_id);
2812: END IF; --}

Line 2839: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

2835: p_full_quantity_bid_code IN VARCHAR2,
2836: p_bid_ranking IN VARCHAR2
2837: ) IS
2838: BEGIN
2839: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
2840: FND_LOG.string(log_level => FND_LOG.level_procedure,
2841: module => g_module_prefix || 'VAL_ATTRIBUTES',
2842: message => 'Entering procedure'
2843: || ', p_auction_header_id = ' || p_auction_header_id);

Line 2840: FND_LOG.string(log_level => FND_LOG.level_procedure,

2836: p_bid_ranking IN VARCHAR2
2837: ) IS
2838: BEGIN
2839: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
2840: FND_LOG.string(log_level => FND_LOG.level_procedure,
2841: module => g_module_prefix || 'VAL_ATTRIBUTES',
2842: message => 'Entering procedure'
2843: || ', p_auction_header_id = ' || p_auction_header_id);
2844: END IF; --}

Line 3173: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

3169: PAA.AUCTION_HEADER_ID = p_auction_header_id AND
3170: PAIP.LINE_NUMBER = PAA.LINE_NUMBER AND
3171: PAA.ATTR_LEVEL = 'LINE';
3172:
3173: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
3174: FND_LOG.string(log_level => FND_LOG.level_procedure,
3175: module => g_module_prefix || 'VAL_ATTRIBUTES',
3176: message => 'Leaving procedure'
3177: || ', p_auction_header_id = ' || p_auction_header_id);

Line 3174: FND_LOG.string(log_level => FND_LOG.level_procedure,

3170: PAIP.LINE_NUMBER = PAA.LINE_NUMBER AND
3171: PAA.ATTR_LEVEL = 'LINE';
3172:
3173: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
3174: FND_LOG.string(log_level => FND_LOG.level_procedure,
3175: module => g_module_prefix || 'VAL_ATTRIBUTES',
3176: message => 'Leaving procedure'
3177: || ', p_auction_header_id = ' || p_auction_header_id);
3178: END IF; --}

Line 3196: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

3192: p_login_id IN NUMBER,
3193: p_batch_id IN NUMBER
3194: ) IS
3195: BEGIN
3196: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
3197: FND_LOG.string(log_level => FND_LOG.level_procedure,
3198: module => g_module_prefix || 'VAL_ATTR_NAME_UNIQUE',
3199: message => 'Entering PON_NEGOTIATION_HELPER_PVT.VAL_ATTR_NAME_UNIQUE'
3200: || ', p_auction_header_id = ' || p_auction_header_id);

Line 3197: FND_LOG.string(log_level => FND_LOG.level_procedure,

3193: p_batch_id IN NUMBER
3194: ) IS
3195: BEGIN
3196: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
3197: FND_LOG.string(log_level => FND_LOG.level_procedure,
3198: module => g_module_prefix || 'VAL_ATTR_NAME_UNIQUE',
3199: message => 'Entering PON_NEGOTIATION_HELPER_PVT.VAL_ATTR_NAME_UNIQUE'
3200: || ', p_auction_header_id = ' || p_auction_header_id);
3201: END IF; --}

Line 3235: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

3231: AUCTION_HEADER_ID=p_auction_header_id
3232: GROUP by AUCTION_HEADER_ID, LINE_NUMBER, attribute_name
3233: HAVING count(LINE_NUMBER) > 1;
3234:
3235: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
3236: FND_LOG.string(log_level => FND_LOG.level_procedure,
3237: module => g_module_prefix || 'VAL_ATTR_NAME_UNIQUE',
3238: message => 'Returning PON_NEGOTIATION_HELPER_PVT.VAL_ATTR_NAME_UNIQUE'
3239: || ', p_auction_header_id = ' || p_auction_header_id);

Line 3236: FND_LOG.string(log_level => FND_LOG.level_procedure,

3232: GROUP by AUCTION_HEADER_ID, LINE_NUMBER, attribute_name
3233: HAVING count(LINE_NUMBER) > 1;
3234:
3235: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
3236: FND_LOG.string(log_level => FND_LOG.level_procedure,
3237: module => g_module_prefix || 'VAL_ATTR_NAME_UNIQUE',
3238: message => 'Returning PON_NEGOTIATION_HELPER_PVT.VAL_ATTR_NAME_UNIQUE'
3239: || ', p_auction_header_id = ' || p_auction_header_id);
3240: END IF; --}

Line 3257: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

3253: p_login_id IN NUMBER,
3254: p_batch_id IN NUMBER
3255: ) IS
3256: BEGIN
3257: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
3258: FND_LOG.string(log_level => FND_LOG.level_procedure,
3259: module => g_module_prefix || 'VAL_ATTR_SCORES',
3260: message => 'Entering PON_NEGOTIATION_HELPER_PVT.VAL_ATTR_SCORES'
3261: || ', p_auction_header_id = ' || p_auction_header_id);

Line 3258: FND_LOG.string(log_level => FND_LOG.level_procedure,

3254: p_batch_id IN NUMBER
3255: ) IS
3256: BEGIN
3257: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
3258: FND_LOG.string(log_level => FND_LOG.level_procedure,
3259: module => g_module_prefix || 'VAL_ATTR_SCORES',
3260: message => 'Entering PON_NEGOTIATION_HELPER_PVT.VAL_ATTR_SCORES'
3261: || ', p_auction_header_id = ' || p_auction_header_id);
3262: END IF; --}

Line 3336: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

3332: WHERE
3333: AUCTION_HEADER_ID = p_auction_header_id AND
3334: LINE_NUMBER > 0;
3335:
3336: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
3337: FND_LOG.string(log_level => FND_LOG.level_procedure,
3338: module => g_module_prefix || 'VAL_ATTR_SCORES',
3339: message => 'Returning PON_NEGOTIATION_HELPER_PVT.VAL_ATTR_SCORES'
3340: || ', p_auction_header_id = ' || p_auction_header_id);

Line 3337: FND_LOG.string(log_level => FND_LOG.level_procedure,

3333: AUCTION_HEADER_ID = p_auction_header_id AND
3334: LINE_NUMBER > 0;
3335:
3336: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
3337: FND_LOG.string(log_level => FND_LOG.level_procedure,
3338: module => g_module_prefix || 'VAL_ATTR_SCORES',
3339: message => 'Returning PON_NEGOTIATION_HELPER_PVT.VAL_ATTR_SCORES'
3340: || ', p_auction_header_id = ' || p_auction_header_id);
3341: END IF; --}

Line 3379: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

3375:
3376: l_temp NUMBER;
3377: BEGIN
3378:
3379: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
3380: FND_LOG.string(log_level => FND_LOG.level_procedure,
3381: module => g_module_prefix || 'VAL_PRICE_BREAKS',
3382: message => 'Entering Procedure' || ', p_auction_header_id = ' || p_auction_header_id);
3383: END IF; --}

Line 3380: FND_LOG.string(log_level => FND_LOG.level_procedure,

3376: l_temp NUMBER;
3377: BEGIN
3378:
3379: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
3380: FND_LOG.string(log_level => FND_LOG.level_procedure,
3381: module => g_module_prefix || 'VAL_PRICE_BREAKS',
3382: message => 'Entering Procedure' || ', p_auction_header_id = ' || p_auction_header_id);
3383: END IF; --}
3384:

Line 3909: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

3905: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
3906: PASA.AUCTION_HEADER_ID = p_auction_header_id AND
3907: PAIP.LINE_NUMBER = PASA.LINE_NUMBER;
3908:
3909: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
3910: FND_LOG.string(log_level => FND_LOG.level_procedure,
3911: module => g_module_prefix || 'VAL_PRICE_BREAKS',
3912: message => 'Leaving procedure');
3913: END IF; --}

Line 3910: FND_LOG.string(log_level => FND_LOG.level_procedure,

3906: PASA.AUCTION_HEADER_ID = p_auction_header_id AND
3907: PAIP.LINE_NUMBER = PASA.LINE_NUMBER;
3908:
3909: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
3910: FND_LOG.string(log_level => FND_LOG.level_procedure,
3911: module => g_module_prefix || 'VAL_PRICE_BREAKS',
3912: message => 'Leaving procedure');
3913: END IF; --}
3914:

Line 3940: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

3936:
3937: l_temp NUMBER;
3938: BEGIN
3939:
3940: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
3941: FND_LOG.string(log_level => FND_LOG.level_procedure,
3942: module => g_module_prefix || 'VAL_QTY_BASED_PRICE_TIERS',
3943: message => 'Entering Procedure' || ', p_auction_header_id = ' || p_auction_header_id);
3944: END IF; --}

Line 3941: FND_LOG.string(log_level => FND_LOG.level_procedure,

3937: l_temp NUMBER;
3938: BEGIN
3939:
3940: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
3941: FND_LOG.string(log_level => FND_LOG.level_procedure,
3942: module => g_module_prefix || 'VAL_QTY_BASED_PRICE_TIERS',
3943: message => 'Entering Procedure' || ', p_auction_header_id = ' || p_auction_header_id);
3944: END IF; --}
3945:

Line 4208: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

4204: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
4205: PASA.AUCTION_HEADER_ID = p_auction_header_id AND
4206: PAIP.LINE_NUMBER = PASA.LINE_NUMBER;
4207:
4208: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
4209: FND_LOG.string(log_level => FND_LOG.level_procedure,
4210: module => g_module_prefix || 'VAL_PRICE_BREAKS',
4211: message => 'Leaving procedure');
4212: END IF; --}

Line 4209: FND_LOG.string(log_level => FND_LOG.level_procedure,

4205: PASA.AUCTION_HEADER_ID = p_auction_header_id AND
4206: PAIP.LINE_NUMBER = PASA.LINE_NUMBER;
4207:
4208: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
4209: FND_LOG.string(log_level => FND_LOG.level_procedure,
4210: module => g_module_prefix || 'VAL_PRICE_BREAKS',
4211: message => 'Leaving procedure');
4212: END IF; --}
4213:

Line 4268: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

4264: p_login_id IN NUMBER,
4265: p_batch_id IN NUMBER
4266: ) IS
4267: BEGIN
4268: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
4269: FND_LOG.string(log_level => FND_LOG.level_procedure,
4270: module => g_module_prefix || 'VAL_PD_UNIQUE',
4271: message => 'Entering procedure' || ', p_auction_header_id = ' || p_auction_header_id);
4272: END IF; --}

Line 4269: FND_LOG.string(log_level => FND_LOG.level_procedure,

4265: p_batch_id IN NUMBER
4266: ) IS
4267: BEGIN
4268: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
4269: FND_LOG.string(log_level => FND_LOG.level_procedure,
4270: module => g_module_prefix || 'VAL_PD_UNIQUE',
4271: message => 'Entering procedure' || ', p_auction_header_id = ' || p_auction_header_id);
4272: END IF; --}
4273:

Line 4360: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

4356: PAS.SHIPMENT_NUMBER
4357: HAVING
4358: COUNT(PPD.LINE_NUMBER) > 1;
4359:
4360: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
4361: FND_LOG.string(log_level => FND_LOG.level_procedure,
4362: module => g_module_prefix || 'VAL_PD_UNIQUE',
4363: message => 'Leaving procedure');
4364: END IF; --}

Line 4361: FND_LOG.string(log_level => FND_LOG.level_procedure,

4357: HAVING
4358: COUNT(PPD.LINE_NUMBER) > 1;
4359:
4360: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
4361: FND_LOG.string(log_level => FND_LOG.level_procedure,
4362: module => g_module_prefix || 'VAL_PD_UNIQUE',
4363: message => 'Leaving procedure');
4364: END IF; --}
4365: END VAL_PD_UNIQUE;

Line 4384: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

4380: p_login_id IN NUMBER,
4381: p_batch_id IN NUMBER
4382: ) IS
4383: BEGIN
4384: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
4385: FND_LOG.string(log_level => FND_LOG.level_procedure,
4386: module => g_module_prefix || 'VAL_PRICE_DIFFERENTIALS',
4387: message => 'Entering procedure' || ', p_auction_header_id = ' || p_auction_header_id);
4388: END IF; --}

Line 4385: FND_LOG.string(log_level => FND_LOG.level_procedure,

4381: p_batch_id IN NUMBER
4382: ) IS
4383: BEGIN
4384: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
4385: FND_LOG.string(log_level => FND_LOG.level_procedure,
4386: module => g_module_prefix || 'VAL_PRICE_DIFFERENTIALS',
4387: message => 'Entering procedure' || ', p_auction_header_id = ' || p_auction_header_id);
4388: END IF; --}
4389:

Line 4584: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

4580: PASA.LINE_NUMBER = PPD.LINE_NUMBER AND
4581: PPDL.PRICE_DIFFERENTIAL_TYPE = PPD.PRICE_TYPE AND
4582: PASA.SHIPMENT_NUMBER = PPD.SHIPMENT_NUMBER;
4583:
4584: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
4585: FND_LOG.string(log_level => FND_LOG.level_procedure,
4586: module => g_module_prefix || 'VAL_PRICE_DIFFERENTIALS',
4587: message => 'Leaving procedure');
4588: END IF; --}

Line 4585: FND_LOG.string(log_level => FND_LOG.level_procedure,

4581: PPDL.PRICE_DIFFERENTIAL_TYPE = PPD.PRICE_TYPE AND
4582: PASA.SHIPMENT_NUMBER = PPD.SHIPMENT_NUMBER;
4583:
4584: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
4585: FND_LOG.string(log_level => FND_LOG.level_procedure,
4586: module => g_module_prefix || 'VAL_PRICE_DIFFERENTIALS',
4587: message => 'Leaving procedure');
4588: END IF; --}
4589: END VAL_PRICE_DIFFERENTIALS;

Line 4621: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

4617: l_temp_fnd NUMBER;
4618: l_doctype_suffix VARCHAR2(10);
4619: BEGIN
4620:
4621: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
4622: FND_LOG.string(log_level => FND_LOG.level_procedure,
4623: module => g_module_prefix || 'VAL_PRICE_ELEMENTS',
4624: message => 'Entering procedure with:' || ' p_auction_header_id = ' || p_auction_header_id ||
4625: ', p_trading_partner_id = ' || p_trading_partner_id);

Line 4622: FND_LOG.string(log_level => FND_LOG.level_procedure,

4618: l_doctype_suffix VARCHAR2(10);
4619: BEGIN
4620:
4621: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
4622: FND_LOG.string(log_level => FND_LOG.level_procedure,
4623: module => g_module_prefix || 'VAL_PRICE_ELEMENTS',
4624: message => 'Entering procedure with:' || ' p_auction_header_id = ' || p_auction_header_id ||
4625: ', p_trading_partner_id = ' || p_trading_partner_id);
4626: END IF; --}

Line 4950: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

4946: PPE.PRICE_ELEMENT_TYPE_ID = PPETL.PRICE_ELEMENT_TYPE_ID(+) AND
4947: PPE.PRICE_ELEMENT_TYPE_ID = PPET.PRICE_ELEMENT_TYPE_ID(+) AND
4948: PPETL.LANGUAGE(+) = USERENV ('LANG');
4949:
4950: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
4951: FND_LOG.string(log_level => FND_LOG.level_procedure,
4952: module => g_module_prefix || 'VAL_PRICE_ELEMENTS',
4953: message => 'Leaving procedure');
4954: END IF; --}

Line 4951: FND_LOG.string(log_level => FND_LOG.level_procedure,

4947: PPE.PRICE_ELEMENT_TYPE_ID = PPET.PRICE_ELEMENT_TYPE_ID(+) AND
4948: PPETL.LANGUAGE(+) = USERENV ('LANG');
4949:
4950: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
4951: FND_LOG.string(log_level => FND_LOG.level_procedure,
4952: module => g_module_prefix || 'VAL_PRICE_ELEMENTS',
4953: message => 'Leaving procedure');
4954: END IF; --}
4955: END VAL_PRICE_ELEMENTS;

Line 4971: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

4967: p_login_id IN NUMBER,
4968: p_batch_id IN NUMBER
4969: ) IS
4970: BEGIN
4971: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
4972: FND_LOG.string(log_level => FND_LOG.level_procedure,
4973: module => g_module_prefix || 'VAL_PE_UNIQUE',
4974: message => 'Entering PON_NEGOTIATION_HELPER_PVT.VAL_PE_UNIQUE'
4975: || ', p_auction_header_id = ' || p_auction_header_id);

Line 4972: FND_LOG.string(log_level => FND_LOG.level_procedure,

4968: p_batch_id IN NUMBER
4969: ) IS
4970: BEGIN
4971: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
4972: FND_LOG.string(log_level => FND_LOG.level_procedure,
4973: module => g_module_prefix || 'VAL_PE_UNIQUE',
4974: message => 'Entering PON_NEGOTIATION_HELPER_PVT.VAL_PE_UNIQUE'
4975: || ', p_auction_header_id = ' || p_auction_header_id);
4976: END IF; --}

Line 5024: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

5020: PPETL.NAME
5021: HAVING
5022: COUNT (PPE.LINE_NUMBER) > 1;
5023:
5024: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
5025: FND_LOG.string(log_level => FND_LOG.level_procedure,
5026: module => g_module_prefix || 'VAL_PE_UNIQUE',
5027: message => 'Leaving procedure');
5028: END IF; --}

Line 5025: FND_LOG.string(log_level => FND_LOG.level_procedure,

5021: HAVING
5022: COUNT (PPE.LINE_NUMBER) > 1;
5023:
5024: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
5025: FND_LOG.string(log_level => FND_LOG.level_procedure,
5026: module => g_module_prefix || 'VAL_PE_UNIQUE',
5027: message => 'Leaving procedure');
5028: END IF; --}
5029: END VAL_PE_UNIQUE;

Line 5044: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

5040: ) IS
5041:
5042: l_major_line_count NUMBER;
5043: BEGIN
5044: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
5045: FND_LOG.string(log_level => FND_LOG.level_procedure,
5046: module => g_module_prefix || 'VAL_PARTY_EXCLUSIONS',
5047: message => 'Entering Procedure' || ', p_auction_header_id = ' || p_auction_header_id);
5048: END IF; --}

Line 5045: FND_LOG.string(log_level => FND_LOG.level_procedure,

5041:
5042: l_major_line_count NUMBER;
5043: BEGIN
5044: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
5045: FND_LOG.string(log_level => FND_LOG.level_procedure,
5046: module => g_module_prefix || 'VAL_PARTY_EXCLUSIONS',
5047: message => 'Entering Procedure' || ', p_auction_header_id = ' || p_auction_header_id);
5048: END IF; --}
5049:

Line 5098: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

5094: pple.trading_partner_id = pbp.trading_partner_id AND
5095: pple.vendor_site_id = pbp.vendor_site_id AND
5096: pple.auction_header_id = p_auction_header_id) = l_major_line_count;
5097:
5098: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
5099: FND_LOG.string(log_level => FND_LOG.level_procedure,
5100: module => g_module_prefix || 'VAL_PARTY_EXCLUSIONS',
5101: message => 'Leaving Procedure');
5102: END IF; --}

Line 5099: FND_LOG.string(log_level => FND_LOG.level_procedure,

5095: pple.vendor_site_id = pbp.vendor_site_id AND
5096: pple.auction_header_id = p_auction_header_id) = l_major_line_count;
5097:
5098: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
5099: FND_LOG.string(log_level => FND_LOG.level_procedure,
5100: module => g_module_prefix || 'VAL_PARTY_EXCLUSIONS',
5101: message => 'Leaving Procedure');
5102: END IF; --}
5103:

Line 5115: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

5111: p_login_id IN NUMBER,
5112: p_batch_id IN NUMBER
5113: ) IS
5114: BEGIN
5115: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
5116: FND_LOG.string(log_level => FND_LOG.level_procedure,
5117: module => g_module_prefix || 'VAL_LINE_REF_DATA',
5118: message => 'Entering Procedure p_auction_header_id = ' || p_auction_header_id);
5119: END IF; --}

Line 5116: FND_LOG.string(log_level => FND_LOG.level_procedure,

5112: p_batch_id IN NUMBER
5113: ) IS
5114: BEGIN
5115: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
5116: FND_LOG.string(log_level => FND_LOG.level_procedure,
5117: module => g_module_prefix || 'VAL_LINE_REF_DATA',
5118: message => 'Entering Procedure p_auction_header_id = ' || p_auction_header_id);
5119: END IF; --}
5120: INSERT ALL

Line 5611: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

5607: PSA.AUCTION_HEADER_ID = P_AUCTION_HEADER_ID AND
5608: PAIP.AUCTION_HEADER_ID = P_AUCTION_HEADER_ID AND
5609: PSA.LINE_NUMBER = PAIP.LINE_NUMBER;
5610:
5611: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
5612: FND_LOG.string(log_level => FND_LOG.level_procedure,
5613: module => g_module_prefix || 'VAL_LINE_REF_DATA',
5614: message => 'Leaving Procedure');
5615: END IF; --}

Line 5612: FND_LOG.string(log_level => FND_LOG.level_procedure,

5608: PAIP.AUCTION_HEADER_ID = P_AUCTION_HEADER_ID AND
5609: PSA.LINE_NUMBER = PAIP.LINE_NUMBER;
5610:
5611: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
5612: FND_LOG.string(log_level => FND_LOG.level_procedure,
5613: module => g_module_prefix || 'VAL_LINE_REF_DATA',
5614: message => 'Leaving Procedure');
5615: END IF; --}
5616:

Line 5632: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

5628:
5629: l_outside_flag NUMBER;
5630: BEGIN
5631:
5632: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
5633: FND_LOG.string(log_level => FND_LOG.level_procedure,
5634: module => g_module_prefix || 'VAL_OUTSIDE_FLAG_EXISTS',
5635: message => 'Entering Procedure p_auction_header_id = ' || p_auction_header_id);
5636: END IF; --}

Line 5633: FND_LOG.string(log_level => FND_LOG.level_procedure,

5629: l_outside_flag NUMBER;
5630: BEGIN
5631:
5632: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
5633: FND_LOG.string(log_level => FND_LOG.level_procedure,
5634: module => g_module_prefix || 'VAL_OUTSIDE_FLAG_EXISTS',
5635: message => 'Entering Procedure p_auction_header_id = ' || p_auction_header_id);
5636: END IF; --}
5637:

Line 5644: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN --{

5640:
5641: --ONLY ONE ERROR WILL BE SHOWN SO ROWNUM = 1
5642: IF (p_is_global_agreement) THEN
5643:
5644: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN --{
5645: FND_LOG.string(log_level => FND_LOG.level_statement,
5646: module => g_module_prefix || 'VAL_OUTSIDE_FLAG_EXISTS',
5647: message => 'This is a global agreement so validation for outside ops');
5648: END IF; --}

Line 5645: FND_LOG.string(log_level => FND_LOG.level_statement,

5641: --ONLY ONE ERROR WILL BE SHOWN SO ROWNUM = 1
5642: IF (p_is_global_agreement) THEN
5643:
5644: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN --{
5645: FND_LOG.string(log_level => FND_LOG.level_statement,
5646: module => g_module_prefix || 'VAL_OUTSIDE_FLAG_EXISTS',
5647: message => 'This is a global agreement so validation for outside ops');
5648: END IF; --}
5649:

Line 5679: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

5675: PLTB.OUTSIDE_OPERATION_FLAG='Y' AND
5676: ROWNUM=1;
5677: END IF;
5678:
5679: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
5680: FND_LOG.string(log_level => FND_LOG.level_procedure,
5681: module => g_module_prefix || 'VAL_OUTSIDE_FLAG_EXISTS',
5682: message => 'Leaving Procedure');
5683: END IF; --}

Line 5680: FND_LOG.string(log_level => FND_LOG.level_procedure,

5676: ROWNUM=1;
5677: END IF;
5678:
5679: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
5680: FND_LOG.string(log_level => FND_LOG.level_procedure,
5681: module => g_module_prefix || 'VAL_OUTSIDE_FLAG_EXISTS',
5682: message => 'Leaving Procedure');
5683: END IF; --}
5684: END VAL_OUTSIDE_FLAG_EXISTS;

Line 6423: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

6419: HAVING count(*) > 1;
6420:
6421: EXCEPTION
6422: WHEN OTHERS THEN
6423: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
6424: FND_LOG.string (log_level => FND_LOG.level_exception,
6425: module => g_module_prefix || 'VALIDATE_COMPLEXWORK_LINES',
6426: message => 'Exception occured in duplicate payitem check of validate_complexwork_lines'
6427: || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200));

Line 6424: FND_LOG.string (log_level => FND_LOG.level_exception,

6420:
6421: EXCEPTION
6422: WHEN OTHERS THEN
6423: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
6424: FND_LOG.string (log_level => FND_LOG.level_exception,
6425: module => g_module_prefix || 'VALIDATE_COMPLEXWORK_LINES',
6426: message => 'Exception occured in duplicate payitem check of validate_complexwork_lines'
6427: || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200));
6428: END IF;

Line 6467: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

6463: BEGIN
6464:
6465:
6466:
6467: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
6468: FND_LOG.string(log_level => FND_LOG.level_procedure,
6469: module => g_module_prefix || 'VALIDATE_PAYMENTS',
6470: message => 'Entering PON_NEGOTIATION_PUBLISH_PVT.VALIDATE_PAYMENTS'
6471: || ', p_auction_header_id = ' || p_auction_header_id

Line 6468: FND_LOG.string(log_level => FND_LOG.level_procedure,

6464:
6465:
6466:
6467: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
6468: FND_LOG.string(log_level => FND_LOG.level_procedure,
6469: module => g_module_prefix || 'VALIDATE_PAYMENTS',
6470: message => 'Entering PON_NEGOTIATION_PUBLISH_PVT.VALIDATE_PAYMENTS'
6471: || ', p_auction_header_id = ' || p_auction_header_id
6472: || ', p_request_id = ' || p_request_id

Line 7015: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

7011: AND ppi.project_expenditure_type IS NOT NULL
7012: AND ppi.project_exp_organization_id IS NOT NULL
7013: AND ppi.project_expenditure_item_date IS NOT NULL;
7014:
7015: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
7016: FND_LOG.string(log_level => FND_LOG.level_procedure,
7017: module => g_module_prefix || 'VALIDATE_PAYMENTS',
7018: message => 'Leaving PON_NEGOTIATION_PUBLISH_PVT.VALIDATE_PAYMENTS'
7019: || ', p_auction_header_id = ' || p_auction_header_id);

Line 7016: FND_LOG.string(log_level => FND_LOG.level_procedure,

7012: AND ppi.project_exp_organization_id IS NOT NULL
7013: AND ppi.project_expenditure_item_date IS NOT NULL;
7014:
7015: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
7016: FND_LOG.string(log_level => FND_LOG.level_procedure,
7017: module => g_module_prefix || 'VALIDATE_PAYMENTS',
7018: message => 'Leaving PON_NEGOTIATION_PUBLISH_PVT.VALIDATE_PAYMENTS'
7019: || ', p_auction_header_id = ' || p_auction_header_id);
7020: END IF; --}

Line 7047: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

7043:
7044: EXCEPTION
7045: WHEN OTHERS THEN
7046:
7047: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
7048: FND_LOG.string (log_level => FND_LOG.level_exception,
7049: module => g_module_prefix || 'VALIDATE_PAYMENTS',
7050: message => 'Exception occured validate_payments'
7051: || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200));

Line 7048: FND_LOG.string (log_level => FND_LOG.level_exception,

7044: EXCEPTION
7045: WHEN OTHERS THEN
7046:
7047: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
7048: FND_LOG.string (log_level => FND_LOG.level_exception,
7049: module => g_module_prefix || 'VALIDATE_PAYMENTS',
7050: message => 'Exception occured validate_payments'
7051: || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200));
7052: END IF;

Line 7332: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

7328: l_module_name := 'validate_lines';
7329:
7330: x_result := FND_API.G_RET_STS_SUCCESS;
7331:
7332: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
7333: FND_LOG.string(log_level => FND_LOG.level_procedure,
7334: module => g_module_prefix || l_module_name,
7335: message => 'Entering procedure:'
7336: || 'p_auction_header_id = ' || p_auction_header_id

Line 7333: FND_LOG.string(log_level => FND_LOG.level_procedure,

7329:
7330: x_result := FND_API.G_RET_STS_SUCCESS;
7331:
7332: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
7333: FND_LOG.string(log_level => FND_LOG.level_procedure,
7334: module => g_module_prefix || l_module_name,
7335: message => 'Entering procedure:'
7336: || 'p_auction_header_id = ' || p_auction_header_id
7337: || ', p_doctype_id = ' || p_doctype_id

Line 7377: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

7373: FROM DUAL;
7374:
7375: x_batch_id := l_batch_id;
7376:
7377: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7378: FND_LOG.string(log_level => FND_LOG.level_statement,
7379: module => g_module_prefix || l_module_name,
7380: message => 'Validating Lines: Validations that do not require join with po line types');
7381: END IF; --}

Line 7378: FND_LOG.string(log_level => FND_LOG.level_statement,

7374:
7375: x_batch_id := l_batch_id;
7376:
7377: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7378: FND_LOG.string(log_level => FND_LOG.level_statement,
7379: module => g_module_prefix || l_module_name,
7380: message => 'Validating Lines: Validations that do not require join with po line types');
7381: END IF; --}
7382:

Line 7392: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

7388: p_fnd_currency_precision, p_close_bidding_date, p_contract_type,
7389: p_global_agreement_flag, p_bid_ranking, p_doctype_id,
7390: p_invitees_count, p_bid_list_type);
7391:
7392: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7393: FND_LOG.string(log_level => FND_LOG.level_statement,
7394: module => g_module_prefix || l_module_name,
7395: message => 'Validating Lines: Validations that require join with po line types');
7396: END IF; --}

Line 7393: FND_LOG.string(log_level => FND_LOG.level_statement,

7389: p_global_agreement_flag, p_bid_ranking, p_doctype_id,
7390: p_invitees_count, p_bid_list_type);
7391:
7392: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7393: FND_LOG.string(log_level => FND_LOG.level_statement,
7394: module => g_module_prefix || l_module_name,
7395: message => 'Validating Lines: Validations that require join with po line types');
7396: END IF; --}
7397:

Line 7413: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

7409: */
7410: -- Attribute validations only if the p_line_attribute_enabled_flag is set to Y
7411: IF (NVL (p_line_attribute_enabled_flag, 'Y') = 'Y') THEN
7412:
7413: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7414: FND_LOG.string(log_level => FND_LOG.level_statement,
7415: module => g_module_prefix || l_module_name,
7416: message => 'Validation attributes');
7417: END IF; --}

Line 7414: FND_LOG.string(log_level => FND_LOG.level_statement,

7410: -- Attribute validations only if the p_line_attribute_enabled_flag is set to Y
7411: IF (NVL (p_line_attribute_enabled_flag, 'Y') = 'Y') THEN
7412:
7413: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7414: FND_LOG.string(log_level => FND_LOG.level_statement,
7415: module => g_module_prefix || l_module_name,
7416: message => 'Validation attributes');
7417: END IF; --}
7418: val_attributes (

Line 7422: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

7418: val_attributes (
7419: p_auction_header_id, p_request_id, l_expiration_date, l_user_id,
7420: l_login_id, l_batch_id, p_full_quantity_bid_code, p_bid_ranking);
7421:
7422: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7423: FND_LOG.string(log_level => FND_LOG.level_statement,
7424: module => g_module_prefix || l_module_name,
7425: message => 'Validation attributes for uniqueness withing a line');
7426: END IF; --}

Line 7423: FND_LOG.string(log_level => FND_LOG.level_statement,

7419: p_auction_header_id, p_request_id, l_expiration_date, l_user_id,
7420: l_login_id, l_batch_id, p_full_quantity_bid_code, p_bid_ranking);
7421:
7422: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7423: FND_LOG.string(log_level => FND_LOG.level_statement,
7424: module => g_module_prefix || l_module_name,
7425: message => 'Validation attributes for uniqueness withing a line');
7426: END IF; --}
7427: val_attr_name_unique(

Line 7436: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

7432: -- We are not checking for NVL (p_line_mas_enabled_flag, 'Y') = 'Y' because bid ranking can be set to
7433: -- MAS only if the condition is true
7434: IF (p_bid_ranking = 'MULTI_ATTRIBUTE_SCORING') THEN
7435:
7436: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7437: FND_LOG.string(log_level => FND_LOG.level_statement,
7438: module => g_module_prefix || l_module_name,
7439: message => 'Validation attribute scores');
7440: END IF; --}

Line 7437: FND_LOG.string(log_level => FND_LOG.level_statement,

7433: -- MAS only if the condition is true
7434: IF (p_bid_ranking = 'MULTI_ATTRIBUTE_SCORING') THEN
7435:
7436: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7437: FND_LOG.string(log_level => FND_LOG.level_statement,
7438: module => g_module_prefix || l_module_name,
7439: message => 'Validation attribute scores');
7440: END IF; --}
7441: val_attr_scores(

Line 7456: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

7452: -- and if price tiers indicator is price breaks, if price tiers indicator is price breaks then
7453: -- we can assume that negotiation is not an RFI and is either a BLANKET or a CONTRACT
7454: IF (p_price_tiers_indicator = 'PRICE_BREAKS') THEN
7455:
7456: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7457: FND_LOG.string(log_level => FND_LOG.level_statement,
7458: module => g_module_prefix || l_module_name,
7459: message => 'Validating price breaks');
7460: END IF; --}

Line 7457: FND_LOG.string(log_level => FND_LOG.level_statement,

7453: -- we can assume that negotiation is not an RFI and is either a BLANKET or a CONTRACT
7454: IF (p_price_tiers_indicator = 'PRICE_BREAKS') THEN
7455:
7456: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7457: FND_LOG.string(log_level => FND_LOG.level_statement,
7458: module => g_module_prefix || l_module_name,
7459: message => 'Validating price breaks');
7460: END IF; --}
7461: val_price_breaks (

Line 7474: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

7470: -- Shipment validation only if it is not an RFI
7471: -- and if price tiers indicator is Quantity based price tiers
7472: IF (p_price_tiers_indicator = 'QUANTITY_BASED') THEN
7473:
7474: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7475: FND_LOG.string(log_level => FND_LOG.level_statement,
7476: module => g_module_prefix || l_module_name,
7477: message => 'Validating quantity based price tiers');
7478: END IF; --}

Line 7475: FND_LOG.string(log_level => FND_LOG.level_statement,

7471: -- and if price tiers indicator is Quantity based price tiers
7472: IF (p_price_tiers_indicator = 'QUANTITY_BASED') THEN
7473:
7474: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7475: FND_LOG.string(log_level => FND_LOG.level_statement,
7476: module => g_module_prefix || l_module_name,
7477: message => 'Validating quantity based price tiers');
7478: END IF; --}
7479: val_qty_based_price_tiers (

Line 7492: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

7488: -- Price differential validation only if this is an RFI or this is a global agreement
7489: IF (g_document_type_names (p_doctype_id) = PON_CONTERMS_UTL_PVT.SRC_REQUEST_FOR_INFORMATION OR
7490: l_is_global_agreement) THEN
7491:
7492: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7493: FND_LOG.string(log_level => FND_LOG.level_statement,
7494: module => g_module_prefix || l_module_name,
7495: message => 'Validating for unique price differentials');
7496: END IF; --}

Line 7493: FND_LOG.string(log_level => FND_LOG.level_statement,

7489: IF (g_document_type_names (p_doctype_id) = PON_CONTERMS_UTL_PVT.SRC_REQUEST_FOR_INFORMATION OR
7490: l_is_global_agreement) THEN
7491:
7492: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7493: FND_LOG.string(log_level => FND_LOG.level_statement,
7494: module => g_module_prefix || l_module_name,
7495: message => 'Validating for unique price differentials');
7496: END IF; --}
7497: val_pd_unique(

Line 7501: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

7497: val_pd_unique(
7498: p_auction_header_id, p_request_id, l_expiration_date, l_user_id, l_login_id,
7499: l_batch_id);
7500:
7501: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7502: FND_LOG.string(log_level => FND_LOG.level_statement,
7503: module => g_module_prefix || l_module_name,
7504: message => 'Validating price differentials');
7505: END IF; --}

Line 7502: FND_LOG.string(log_level => FND_LOG.level_statement,

7498: p_auction_header_id, p_request_id, l_expiration_date, l_user_id, l_login_id,
7499: l_batch_id);
7500:
7501: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7502: FND_LOG.string(log_level => FND_LOG.level_statement,
7503: module => g_module_prefix || l_module_name,
7504: message => 'Validating price differentials');
7505: END IF; --}
7506: val_price_differentials(

Line 7517: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

7513: * COST FACTOR VALIDATIONS
7514: */
7515: IF (p_pf_type_allowed <> 'NONE') THEN
7516:
7517: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7518: FND_LOG.string(log_level => FND_LOG.level_statement,
7519: module => g_module_prefix || l_module_name,
7520: message => 'Validating price elements');
7521: END IF; --}

Line 7518: FND_LOG.string(log_level => FND_LOG.level_statement,

7514: */
7515: IF (p_pf_type_allowed <> 'NONE') THEN
7516:
7517: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7518: FND_LOG.string(log_level => FND_LOG.level_statement,
7519: module => g_module_prefix || l_module_name,
7520: message => 'Validating price elements');
7521: END IF; --}
7522: val_price_elements (p_auction_header_id, p_request_id, l_expiration_date, l_user_id,

Line 7526: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

7522: val_price_elements (p_auction_header_id, p_request_id, l_expiration_date, l_user_id,
7523: l_login_id, l_batch_id, p_auction_currency_precision, p_fnd_currency_precision,
7524: p_trading_partner_id);
7525:
7526: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7527: FND_LOG.string(log_level => FND_LOG.level_statement,
7528: module => g_module_prefix || l_module_name,
7529: message => 'Validation for unique price elements');
7530: END IF; --}

Line 7527: FND_LOG.string(log_level => FND_LOG.level_statement,

7523: l_login_id, l_batch_id, p_auction_currency_precision, p_fnd_currency_precision,
7524: p_trading_partner_id);
7525:
7526: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7527: FND_LOG.string(log_level => FND_LOG.level_statement,
7528: module => g_module_prefix || l_module_name,
7529: message => 'Validation for unique price elements');
7530: END IF; --}
7531: val_pe_unique (

Line 7540: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

7536:
7537: -- Validate party exclusions only if this is not a large negotiation
7538: IF (nvl (p_large_neg_enabled_flag, 'N') <> 'Y') THEN
7539:
7540: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7541: FND_LOG.string(log_level => FND_LOG.level_statement,
7542: module => g_module_prefix || l_module_name,
7543: message => 'Validating party exclusions:');
7544: END IF; --}

Line 7541: FND_LOG.string(log_level => FND_LOG.level_statement,

7537: -- Validate party exclusions only if this is not a large negotiation
7538: IF (nvl (p_large_neg_enabled_flag, 'N') <> 'Y') THEN
7539:
7540: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7541: FND_LOG.string(log_level => FND_LOG.level_statement,
7542: module => g_module_prefix || l_module_name,
7543: message => 'Validating party exclusions:');
7544: END IF; --}
7545: val_party_exclusions (

Line 7553: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

7549:
7550: -- The reference data validation should happen only in case of publication
7551: -- and concurrent flow
7552: IF ('N' = p_for_approval AND p_request_id IS NOT NULL) THEN
7553: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7554: FND_LOG.string(log_level => FND_LOG.level_statement,
7555: module => g_module_prefix || l_module_name,
7556: message => 'Validating reference data');
7557: END IF; --}

Line 7554: FND_LOG.string(log_level => FND_LOG.level_statement,

7550: -- The reference data validation should happen only in case of publication
7551: -- and concurrent flow
7552: IF ('N' = p_for_approval AND p_request_id IS NOT NULL) THEN
7553: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7554: FND_LOG.string(log_level => FND_LOG.level_statement,
7555: module => g_module_prefix || l_module_name,
7556: message => 'Validating reference data');
7557: END IF; --}
7558: val_line_ref_data (

Line 7563: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

7559: p_auction_header_id, p_request_id, l_expiration_date, l_user_id, l_login_id,
7560: l_batch_id);
7561: END IF;
7562:
7563: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7564: FND_LOG.string(log_level => FND_LOG.level_statement,
7565: module => g_module_prefix || l_module_name,
7566: message => 'Validation for multi currency aution with amount based lines');
7567: END IF; --}

Line 7564: FND_LOG.string(log_level => FND_LOG.level_statement,

7560: l_batch_id);
7561: END IF;
7562:
7563: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7564: FND_LOG.string(log_level => FND_LOG.level_statement,
7565: module => g_module_prefix || l_module_name,
7566: message => 'Validation for multi currency aution with amount based lines');
7567: END IF; --}
7568: val_line_amount_multi_curr (

Line 7572: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

7568: val_line_amount_multi_curr (
7569: p_auction_header_id, p_allow_other_bid_currency, p_request_id, l_expiration_date,
7570: l_user_id, l_login_id, l_batch_id);
7571:
7572: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7573: FND_LOG.string(log_level => FND_LOG.level_statement,
7574: module => g_module_prefix || l_module_name,
7575: message => 'Validating if outside operation lines are included in a global agreement');
7576: END IF; --}

Line 7573: FND_LOG.string(log_level => FND_LOG.level_statement,

7569: p_auction_header_id, p_allow_other_bid_currency, p_request_id, l_expiration_date,
7570: l_user_id, l_login_id, l_batch_id);
7571:
7572: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7573: FND_LOG.string(log_level => FND_LOG.level_statement,
7574: module => g_module_prefix || l_module_name,
7575: message => 'Validating if outside operation lines are included in a global agreement');
7576: END IF; --}
7577: val_outside_flag_exists (

Line 7581: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

7577: val_outside_flag_exists (
7578: p_auction_header_id, l_is_global_agreement, p_request_id, l_expiration_date, l_user_id,
7579: l_login_id, l_batch_id);
7580:
7581: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7582: FND_LOG.string(log_level => FND_LOG.level_statement,
7583: module => g_module_prefix || l_module_name,
7584: message => 'Validating Complex work fields');
7585: END IF; --}

Line 7582: FND_LOG.string(log_level => FND_LOG.level_statement,

7578: p_auction_header_id, l_is_global_agreement, p_request_id, l_expiration_date, l_user_id,
7579: l_login_id, l_batch_id);
7580:
7581: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7582: FND_LOG.string(log_level => FND_LOG.level_statement,
7583: module => g_module_prefix || l_module_name,
7584: message => 'Validating Complex work fields');
7585: END IF; --}
7586: validate_complexwork_lines (

Line 7591: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

7587: p_auction_header_id, p_request_id, l_expiration_date, l_user_id, l_login_id,
7588: l_batch_id, p_fnd_currency_precision);
7589:
7590: IF p_progress_payment_type <> 'NONE' AND p_contract_type = 'STANDARD' THEN
7591: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7592: FND_LOG.string(log_level => FND_LOG.level_statement,
7593: module => g_module_prefix || 'VALIDATE_LINES',
7594: message => 'Validating payments:');
7595: END IF; --}

Line 7592: FND_LOG.string(log_level => FND_LOG.level_statement,

7588: l_batch_id, p_fnd_currency_precision);
7589:
7590: IF p_progress_payment_type <> 'NONE' AND p_contract_type = 'STANDARD' THEN
7591: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7592: FND_LOG.string(log_level => FND_LOG.level_statement,
7593: module => g_module_prefix || 'VALIDATE_LINES',
7594: message => 'Validating payments:');
7595: END IF; --}
7596: VALIDATE_PAYMENTS (p_auction_header_id, p_request_id, l_expiration_date, l_user_id, l_login_id, l_batch_id, p_auction_currency_precision);

Line 7605: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

7601: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
7602: x_error_code := SQLCODE;
7603: x_error_message := SUBSTR(SQLERRM, 1, 100);
7604:
7605: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
7606: FND_LOG.string (log_level => FND_LOG.level_exception,
7607: module => g_module_prefix || l_module_name,
7608: message => 'Unexpected exception occured error_code = ' || x_error_code ||
7609: ', error_message = ' || x_error_message);

Line 7606: FND_LOG.string (log_level => FND_LOG.level_exception,

7602: x_error_code := SQLCODE;
7603: x_error_message := SUBSTR(SQLERRM, 1, 100);
7604:
7605: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
7606: FND_LOG.string (log_level => FND_LOG.level_exception,
7607: module => g_module_prefix || l_module_name,
7608: message => 'Unexpected exception occured error_code = ' || x_error_code ||
7609: ', error_message = ' || x_error_message);
7610: END IF;

Line 7671: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

7667:
7668: l_batch_id NUMBER;
7669: BEGIN
7670:
7671: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7672: FND_LOG.string(log_level => FND_LOG.level_statement,
7673: module => g_module_prefix || 'CHECK_ACTION_ERRORS_PRESENT',
7674: message => 'Checking if any errors are present for batch id = ' || p_batch_id);
7675: END IF; --}

Line 7672: FND_LOG.string(log_level => FND_LOG.level_statement,

7668: l_batch_id NUMBER;
7669: BEGIN
7670:
7671: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7672: FND_LOG.string(log_level => FND_LOG.level_statement,
7673: module => g_module_prefix || 'CHECK_ACTION_ERRORS_PRESENT',
7674: message => 'Checking if any errors are present for batch id = ' || p_batch_id);
7675: END IF; --}
7676:

Line 7924: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

7920:
7921: l_module_name := 'update_line_flag_seq_closedate';
7922: x_result := FND_API.g_ret_sts_success;
7923:
7924: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
7925: FND_LOG.string (log_level => FND_LOG.level_procedure,
7926: module => g_module_prefix || l_module_name,
7927: message => 'Entered procedure = ' || l_module_name);
7928: END IF;

Line 7925: FND_LOG.string (log_level => FND_LOG.level_procedure,

7921: l_module_name := 'update_line_flag_seq_closedate';
7922: x_result := FND_API.g_ret_sts_success;
7923:
7924: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
7925: FND_LOG.string (log_level => FND_LOG.level_procedure,
7926: module => g_module_prefix || l_module_name,
7927: message => 'Entered procedure = ' || l_module_name);
7928: END IF;
7929:

Line 8044: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

8040: auction_header_id = p_auction_header_id AND
8041: line_number >= p_curr_from_line_number AND
8042: line_number <= p_curr_to_line_number;
8043:
8044: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8045: FND_LOG.string (log_level => FND_LOG.level_procedure,
8046: module => g_module_prefix || l_module_name,
8047: message => 'Leaving procedure = ' || l_module_name);
8048: END IF;

Line 8045: FND_LOG.string (log_level => FND_LOG.level_procedure,

8041: line_number >= p_curr_from_line_number AND
8042: line_number <= p_curr_to_line_number;
8043:
8044: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8045: FND_LOG.string (log_level => FND_LOG.level_procedure,
8046: module => g_module_prefix || l_module_name,
8047: message => 'Leaving procedure = ' || l_module_name);
8048: END IF;
8049:

Line 8056: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

8052: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
8053: x_error_code := SQLCODE;
8054: x_error_message := SUBSTR(SQLERRM, 1, 100);
8055:
8056: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
8057: FND_LOG.string (log_level => FND_LOG.level_exception,
8058: module => g_module_prefix || l_module_name,
8059: message => 'Unexpected exception occured error_code = ' || x_error_code || ', error_message = ' || x_error_message);
8060: END IF;

Line 8057: FND_LOG.string (log_level => FND_LOG.level_exception,

8053: x_error_code := SQLCODE;
8054: x_error_message := SUBSTR(SQLERRM, 1, 100);
8055:
8056: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
8057: FND_LOG.string (log_level => FND_LOG.level_exception,
8058: module => g_module_prefix || l_module_name,
8059: message => 'Unexpected exception occured error_code = ' || x_error_code || ', error_message = ' || x_error_message);
8060: END IF;
8061:

Line 8074: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

8070: l_module_name VARCHAR2(30);
8071: BEGIN
8072:
8073: l_module_name := 'process_price_factors';
8074: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8075: FND_LOG.string (log_level => FND_LOG.level_procedure,
8076: module => g_module_prefix || l_module_name,
8077: message => 'Entering procedure = ' || l_module_name);
8078: END IF;

Line 8075: FND_LOG.string (log_level => FND_LOG.level_procedure,

8071: BEGIN
8072:
8073: l_module_name := 'process_price_factors';
8074: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8075: FND_LOG.string (log_level => FND_LOG.level_procedure,
8076: module => g_module_prefix || l_module_name,
8077: message => 'Entering procedure = ' || l_module_name);
8078: END IF;
8079:

Line 8256: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

8252:
8253: l_module_name := 'process_payments_batch';
8254: x_result := FND_API.g_ret_sts_success;
8255:
8256: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8257: FND_LOG.string (log_level => FND_LOG.level_procedure,
8258: module => g_module_prefix || l_module_name,
8259: message => 'Entered procedure = ' || l_module_name);
8260: END IF;

Line 8257: FND_LOG.string (log_level => FND_LOG.level_procedure,

8253: l_module_name := 'process_payments_batch';
8254: x_result := FND_API.g_ret_sts_success;
8255:
8256: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8257: FND_LOG.string (log_level => FND_LOG.level_procedure,
8258: module => g_module_prefix || l_module_name,
8259: message => 'Entered procedure = ' || l_module_name);
8260: END IF;
8261:

Line 8262: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

8258: module => g_module_prefix || l_module_name,
8259: message => 'Entered procedure = ' || l_module_name);
8260: END IF;
8261:
8262: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8263: FND_LOG.string (log_level => FND_LOG.level_procedure,
8264: module => g_module_prefix || l_module_name,
8265: message => 'Update Payments Fields = ' || l_module_name);
8266: END IF;

Line 8263: FND_LOG.string (log_level => FND_LOG.level_procedure,

8259: message => 'Entered procedure = ' || l_module_name);
8260: END IF;
8261:
8262: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8263: FND_LOG.string (log_level => FND_LOG.level_procedure,
8264: module => g_module_prefix || l_module_name,
8265: message => 'Update Payments Fields = ' || l_module_name);
8266: END IF;
8267:

Line 8288: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

8284: auction_header_id = p_auction_header_id AND
8285: line_number >= p_curr_from_line_number AND
8286: line_number <= p_curr_to_line_number;
8287:
8288: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8289: FND_LOG.string (log_level => FND_LOG.level_procedure,
8290: module => g_module_prefix || l_module_name,
8291: message => 'Before call Delete_Payment_Attachments = ' || l_module_name);
8292: END IF;

Line 8289: FND_LOG.string (log_level => FND_LOG.level_procedure,

8285: line_number >= p_curr_from_line_number AND
8286: line_number <= p_curr_to_line_number;
8287:
8288: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8289: FND_LOG.string (log_level => FND_LOG.level_procedure,
8290: module => g_module_prefix || l_module_name,
8291: message => 'Before call Delete_Payment_Attachments = ' || l_module_name);
8292: END IF;
8293:

Line 8300: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

8296: p_auction_header_id => p_auction_header_id,
8297: p_curr_from_line_number => p_curr_from_line_number,
8298: p_curr_to_line_number => p_curr_to_line_number);
8299:
8300: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8301: FND_LOG.string (log_level => FND_LOG.level_procedure,
8302: module => g_module_prefix || l_module_name,
8303: message => 'After Call Delete_Payment_Attachments = ' || l_module_name);
8304: END IF;

Line 8301: FND_LOG.string (log_level => FND_LOG.level_procedure,

8297: p_curr_from_line_number => p_curr_from_line_number,
8298: p_curr_to_line_number => p_curr_to_line_number);
8299:
8300: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8301: FND_LOG.string (log_level => FND_LOG.level_procedure,
8302: module => g_module_prefix || l_module_name,
8303: message => 'After Call Delete_Payment_Attachments = ' || l_module_name);
8304: END IF;
8305:

Line 8306: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

8302: module => g_module_prefix || l_module_name,
8303: message => 'After Call Delete_Payment_Attachments = ' || l_module_name);
8304: END IF;
8305:
8306: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8307: FND_LOG.string (log_level => FND_LOG.level_procedure,
8308: module => g_module_prefix || l_module_name,
8309: message => 'Leaving procedure = ' || l_module_name);
8310: END IF;

Line 8307: FND_LOG.string (log_level => FND_LOG.level_procedure,

8303: message => 'After Call Delete_Payment_Attachments = ' || l_module_name);
8304: END IF;
8305:
8306: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8307: FND_LOG.string (log_level => FND_LOG.level_procedure,
8308: module => g_module_prefix || l_module_name,
8309: message => 'Leaving procedure = ' || l_module_name);
8310: END IF;
8311:

Line 8318: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

8314: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
8315: x_error_code := SQLCODE;
8316: x_error_message := SUBSTR(SQLERRM, 1, 100);
8317:
8318: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
8319: FND_LOG.string (log_level => FND_LOG.level_exception,
8320: module => g_module_prefix || l_module_name,
8321: message => 'Unexpected exception occured error_code = ' || x_error_code || ', error_message = ' || x_error_message);
8322: END IF;

Line 8319: FND_LOG.string (log_level => FND_LOG.level_exception,

8315: x_error_code := SQLCODE;
8316: x_error_message := SUBSTR(SQLERRM, 1, 100);
8317:
8318: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
8319: FND_LOG.string (log_level => FND_LOG.level_exception,
8320: module => g_module_prefix || l_module_name,
8321: message => 'Unexpected exception occured error_code = ' || x_error_code || ', error_message = ' || x_error_message);
8322: END IF;
8323:

Line 8347: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

8343:
8344: l_module_name := 'process_payments_auto';
8345: x_result := FND_API.g_ret_sts_success;
8346:
8347: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8348: FND_LOG.string (log_level => FND_LOG.level_procedure,
8349: module => g_module_prefix || l_module_name,
8350: message => 'Entered procedure = ' || l_module_name);
8351: END IF;

Line 8348: FND_LOG.string (log_level => FND_LOG.level_procedure,

8344: l_module_name := 'process_payments_auto';
8345: x_result := FND_API.g_ret_sts_success;
8346:
8347: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8348: FND_LOG.string (log_level => FND_LOG.level_procedure,
8349: module => g_module_prefix || l_module_name,
8350: message => 'Entered procedure = ' || l_module_name);
8351: END IF;
8352:

Line 8368: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

8364: ROLLBACK;
8365: return;
8366: END IF;
8367:
8368: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8369: FND_LOG.string(log_level => FND_LOG.level_statement,
8370: module => g_module_prefix || l_module_name,
8371: message => 'Commiting data for lines between ' || p_curr_from_line_number || ' and ' || p_curr_to_line_number);
8372: END IF; --}

Line 8369: FND_LOG.string(log_level => FND_LOG.level_statement,

8365: return;
8366: END IF;
8367:
8368: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8369: FND_LOG.string(log_level => FND_LOG.level_statement,
8370: module => g_module_prefix || l_module_name,
8371: message => 'Commiting data for lines between ' || p_curr_from_line_number || ' and ' || p_curr_to_line_number);
8372: END IF; --}
8373:

Line 8376: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

8372: END IF; --}
8373:
8374: COMMIT;
8375:
8376: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8377: FND_LOG.string (log_level => FND_LOG.level_procedure,
8378: module => g_module_prefix || l_module_name,
8379: message => 'Leaving procedure = ' || l_module_name);
8380: END IF;

Line 8377: FND_LOG.string (log_level => FND_LOG.level_procedure,

8373:
8374: COMMIT;
8375:
8376: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8377: FND_LOG.string (log_level => FND_LOG.level_procedure,
8378: module => g_module_prefix || l_module_name,
8379: message => 'Leaving procedure = ' || l_module_name);
8380: END IF;
8381:

Line 8389: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

8385: x_error_code := SQLCODE;
8386: x_error_message := SUBSTR(SQLERRM, 1, 100);
8387: Rollback;
8388:
8389: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
8390: FND_LOG.string (log_level => FND_LOG.level_exception,
8391: module => g_module_prefix || l_module_name,
8392: message => 'Unexpected exception occured error_code = ' || x_error_code || ', error_message = ' || x_error_message);
8393: END IF;

Line 8390: FND_LOG.string (log_level => FND_LOG.level_exception,

8386: x_error_message := SUBSTR(SQLERRM, 1, 100);
8387: Rollback;
8388:
8389: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
8390: FND_LOG.string (log_level => FND_LOG.level_exception,
8391: module => g_module_prefix || l_module_name,
8392: message => 'Unexpected exception occured error_code = ' || x_error_code || ', error_message = ' || x_error_message);
8393: END IF;
8394:

Line 8422: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

8418:
8419: l_module_name := 'process_payments';
8420: x_result := FND_API.g_ret_sts_success;
8421:
8422: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8423: FND_LOG.string (log_level => FND_LOG.level_procedure,
8424: module => g_module_prefix || l_module_name,
8425: message => 'Entered procedure = ' || l_module_name);
8426: END IF;

Line 8423: FND_LOG.string (log_level => FND_LOG.level_procedure,

8419: l_module_name := 'process_payments';
8420: x_result := FND_API.g_ret_sts_success;
8421:
8422: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8423: FND_LOG.string (log_level => FND_LOG.level_procedure,
8424: module => g_module_prefix || l_module_name,
8425: message => 'Entered procedure = ' || l_module_name);
8426: END IF;
8427:

Line 8435: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

8431: INTO l_max_line_number
8432: FROM pon_auction_item_prices_all
8433: WHERE auction_header_id = p_auction_header_id;
8434:
8435: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8436: FND_LOG.string (log_level => FND_LOG.level_procedure,
8437: module => g_module_prefix || l_module_name,
8438: message => 'Update Payments Fields = ' || l_module_name);
8439: END IF;

Line 8436: FND_LOG.string (log_level => FND_LOG.level_procedure,

8432: FROM pon_auction_item_prices_all
8433: WHERE auction_header_id = p_auction_header_id;
8434:
8435: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8436: FND_LOG.string (log_level => FND_LOG.level_procedure,
8437: module => g_module_prefix || l_module_name,
8438: message => 'Update Payments Fields = ' || l_module_name);
8439: END IF;
8440:

Line 8447: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

8443:
8444: --determine the max line number for this batch
8445: IF (l_max_line_number <= l_batch_size) THEN
8446: l_batch_end := l_max_line_number;
8447: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8448: FND_LOG.string(log_level => FND_LOG.level_statement,
8449: module => g_module_prefix || l_module_name,
8450: message => 'before call to Process_Payments_batch l_curr_to_line_number = ' || l_batch_end ||
8451: ' p_auction_header_id = ' || p_auction_header_id ||

Line 8448: FND_LOG.string(log_level => FND_LOG.level_statement,

8444: --determine the max line number for this batch
8445: IF (l_max_line_number <= l_batch_size) THEN
8446: l_batch_end := l_max_line_number;
8447: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8448: FND_LOG.string(log_level => FND_LOG.level_statement,
8449: module => g_module_prefix || l_module_name,
8450: message => 'before call to Process_Payments_batch l_curr_to_line_number = ' || l_batch_end ||
8451: ' p_auction_header_id = ' || p_auction_header_id ||
8452: ', p_user_id = ' || p_user_id ||

Line 8469: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

8465: p_curr_from_line_number => l_batch_start ,
8466: p_curr_to_line_number => l_batch_end);
8467:
8468:
8469: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8470: FND_LOG.string (log_level => FND_LOG.level_procedure,
8471: module => g_module_prefix || l_module_name,
8472: message => 'After Call Process_Payments_batch = ' || l_module_name);
8473: END IF;

Line 8470: FND_LOG.string (log_level => FND_LOG.level_procedure,

8466: p_curr_to_line_number => l_batch_end);
8467:
8468:
8469: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8470: FND_LOG.string (log_level => FND_LOG.level_procedure,
8471: module => g_module_prefix || l_module_name,
8472: message => 'After Call Process_Payments_batch = ' || l_module_name);
8473: END IF;
8474:

Line 8482: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

8478:
8479: -- loop for each batch
8480: WHILE (l_batch_start <= l_max_line_number) LOOP --{
8481:
8482: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8483: FND_LOG.string(log_level => FND_LOG.level_statement,
8484: module => g_module_prefix || l_module_name,
8485: message => 'before call to Process_Payments_auto l_curr_to_line_number = ' || l_batch_end ||
8486: ' p_auction_header_id = ' || p_auction_header_id ||

Line 8483: FND_LOG.string(log_level => FND_LOG.level_statement,

8479: -- loop for each batch
8480: WHILE (l_batch_start <= l_max_line_number) LOOP --{
8481:
8482: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8483: FND_LOG.string(log_level => FND_LOG.level_statement,
8484: module => g_module_prefix || l_module_name,
8485: message => 'before call to Process_Payments_auto l_curr_to_line_number = ' || l_batch_end ||
8486: ' p_auction_header_id = ' || p_auction_header_id ||
8487: ', p_user_id = ' || p_user_id ||

Line 8504: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

8500: p_curr_from_line_number => l_batch_start ,
8501: p_curr_to_line_number => l_batch_end);
8502:
8503:
8504: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8505: FND_LOG.string (log_level => FND_LOG.level_procedure,
8506: module => g_module_prefix || l_module_name,
8507: message => 'After Call Process_Payments_auto = ' || l_module_name);
8508: END IF;

Line 8505: FND_LOG.string (log_level => FND_LOG.level_procedure,

8501: p_curr_to_line_number => l_batch_end);
8502:
8503:
8504: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8505: FND_LOG.string (log_level => FND_LOG.level_procedure,
8506: module => g_module_prefix || l_module_name,
8507: message => 'After Call Process_Payments_auto = ' || l_module_name);
8508: END IF;
8509:

Line 8522: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

8518: ELSE
8519: l_batch_end := l_batch_end + l_batch_size;
8520: END IF;
8521:
8522: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8523: FND_LOG.string(log_level => FND_LOG.level_statement,
8524: module => g_module_prefix || l_module_name,
8525: message => 'Calculated new l_curr_from_line_number = ' || l_batch_start);
8526: END IF; --}

Line 8523: FND_LOG.string(log_level => FND_LOG.level_statement,

8519: l_batch_end := l_batch_end + l_batch_size;
8520: END IF;
8521:
8522: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8523: FND_LOG.string(log_level => FND_LOG.level_statement,
8524: module => g_module_prefix || l_module_name,
8525: message => 'Calculated new l_curr_from_line_number = ' || l_batch_start);
8526: END IF; --}
8527:

Line 8531: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

8527:
8528: END LOOP; --}
8529:
8530: END IF;--}
8531: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8532: FND_LOG.string (log_level => FND_LOG.level_procedure,
8533: module => g_module_prefix || l_module_name,
8534: message => 'Leaving procedure = ' || l_module_name);
8535: END IF;

Line 8532: FND_LOG.string (log_level => FND_LOG.level_procedure,

8528: END LOOP; --}
8529:
8530: END IF;--}
8531: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8532: FND_LOG.string (log_level => FND_LOG.level_procedure,
8533: module => g_module_prefix || l_module_name,
8534: message => 'Leaving procedure = ' || l_module_name);
8535: END IF;
8536:

Line 8543: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

8539: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
8540: x_error_code := SQLCODE;
8541: x_error_message := SUBSTR(SQLERRM, 1, 100);
8542:
8543: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
8544: FND_LOG.string (log_level => FND_LOG.level_exception,
8545: module => g_module_prefix || l_module_name,
8546: message => 'Unexpected exception occured error_code = ' || x_error_code || ', error_message = ' || x_error_message);
8547: END IF;

Line 8544: FND_LOG.string (log_level => FND_LOG.level_exception,

8540: x_error_code := SQLCODE;
8541: x_error_message := SUBSTR(SQLERRM, 1, 100);
8542:
8543: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
8544: FND_LOG.string (log_level => FND_LOG.level_exception,
8545: module => g_module_prefix || l_module_name,
8546: message => 'Unexpected exception occured error_code = ' || x_error_code || ', error_message = ' || x_error_message);
8547: END IF;
8548:

Line 8595: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

8591: l_attributes_exist := 'OPTIONAL';
8592: END;
8593: END IF; --}
8594:
8595: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8596: FND_LOG.string(log_level => FND_LOG.level_statement,
8597: module => g_module_prefix || l_module_name,
8598: message => 'Done getting the flag l_attributes_exist = ' || l_attributes_exist);
8599: END IF; --}

Line 8596: FND_LOG.string(log_level => FND_LOG.level_statement,

8592: END;
8593: END IF; --}
8594:
8595: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8596: FND_LOG.string(log_level => FND_LOG.level_statement,
8597: module => g_module_prefix || l_module_name,
8598: message => 'Done getting the flag l_attributes_exist = ' || l_attributes_exist);
8599: END IF; --}
8600:

Line 8613: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

8609: EXCEPTION WHEN NO_DATA_FOUND THEN --{
8610: l_has_price_elements := 'N';
8611: END;
8612:
8613: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8614: FND_LOG.string(log_level => FND_LOG.level_statement,
8615: module => g_module_prefix || l_module_name,
8616: message => 'Done getting the flag l_has_price_elements = ' || l_has_price_elements);
8617: END IF; --}

Line 8614: FND_LOG.string(log_level => FND_LOG.level_statement,

8610: l_has_price_elements := 'N';
8611: END;
8612:
8613: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8614: FND_LOG.string(log_level => FND_LOG.level_statement,
8615: module => g_module_prefix || l_module_name,
8616: message => 'Done getting the flag l_has_price_elements = ' || l_has_price_elements);
8617: END IF; --}
8618:

Line 8638: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

8634:
8635: l_has_pe_for_all_items := 'N';
8636: END IF; --}
8637:
8638: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8639: FND_LOG.string(log_level => FND_LOG.level_statement,
8640: module => g_module_prefix || l_module_name,
8641: message => 'Done getting the flag l_has_pe_for_all_items = ' || l_has_pe_for_all_items);
8642: END IF; --}

Line 8639: FND_LOG.string(log_level => FND_LOG.level_statement,

8635: l_has_pe_for_all_items := 'N';
8636: END IF; --}
8637:
8638: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8639: FND_LOG.string(log_level => FND_LOG.level_statement,
8640: module => g_module_prefix || l_module_name,
8641: message => 'Done getting the flag l_has_pe_for_all_items = ' || l_has_pe_for_all_items);
8642: END IF; --}
8643:

Line 8675: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

8671: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
8672: x_error_code := SQLCODE;
8673: x_error_message := SUBSTR(SQLERRM, 1, 100);
8674:
8675: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
8676: FND_LOG.string (log_level => FND_LOG.level_exception,
8677: module => g_module_prefix || l_module_name,
8678: message => 'Unexpected exception occured error_code = ' ||
8679: x_error_code || ', error_message = ' || x_error_message);

Line 8676: FND_LOG.string (log_level => FND_LOG.level_exception,

8672: x_error_code := SQLCODE;
8673: x_error_message := SUBSTR(SQLERRM, 1, 100);
8674:
8675: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
8676: FND_LOG.string (log_level => FND_LOG.level_exception,
8677: module => g_module_prefix || l_module_name,
8678: message => 'Unexpected exception occured error_code = ' ||
8679: x_error_code || ', error_message = ' || x_error_message);
8680: END IF;

Line 8711: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

8707: l_batch_size := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
8708: l_module_name := 'update_lines_before_publish';
8709: x_result := FND_API.g_ret_sts_success;
8710:
8711: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8712: FND_LOG.string(log_level => FND_LOG.level_statement,
8713: module => g_module_prefix || l_module_name,
8714: message => 'Batch size is = ' || l_batch_size);
8715: END IF; --}

Line 8712: FND_LOG.string(log_level => FND_LOG.level_statement,

8708: l_module_name := 'update_lines_before_publish';
8709: x_result := FND_API.g_ret_sts_success;
8710:
8711: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8712: FND_LOG.string(log_level => FND_LOG.level_statement,
8713: module => g_module_prefix || l_module_name,
8714: message => 'Batch size is = ' || l_batch_size);
8715: END IF; --}
8716:

Line 8781: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

8777:
8778: -- loop for each batch
8779: WHILE (l_batch_start <= l_max_line_number) LOOP --{
8780:
8781: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8782: FND_LOG.string(log_level => FND_LOG.level_statement,
8783: module => g_module_prefix || l_module_name,
8784: message => 'Calculated new l_curr_to_line_number = ' || l_batch_end ||
8785: ' Calling process_price_factors, pon_lrg_draft_to_ord_pf_copy '||

Line 8782: FND_LOG.string(log_level => FND_LOG.level_statement,

8778: -- loop for each batch
8779: WHILE (l_batch_start <= l_max_line_number) LOOP --{
8780:
8781: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8782: FND_LOG.string(log_level => FND_LOG.level_statement,
8783: module => g_module_prefix || l_module_name,
8784: message => 'Calculated new l_curr_to_line_number = ' || l_batch_end ||
8785: ' Calling process_price_factors, pon_lrg_draft_to_ord_pf_copy '||
8786: ' and update_line_flag_seq_closedate with' ||

Line 8836: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

8832: IF (x_result <> FND_API.g_ret_sts_success) THEN
8833: return;
8834: END IF;
8835:
8836: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8837: FND_LOG.string(log_level => FND_LOG.level_statement,
8838: module => g_module_prefix || l_module_name,
8839: message => 'Commiting data for lines between ' || l_batch_start || ' and ' || l_batch_end);
8840: END IF; --}

Line 8837: FND_LOG.string(log_level => FND_LOG.level_statement,

8833: return;
8834: END IF;
8835:
8836: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8837: FND_LOG.string(log_level => FND_LOG.level_statement,
8838: module => g_module_prefix || l_module_name,
8839: message => 'Commiting data for lines between ' || l_batch_start || ' and ' || l_batch_end);
8840: END IF; --}
8841:

Line 8852: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

8848: ELSE
8849: l_batch_end := l_batch_end + l_batch_size;
8850: END IF;
8851:
8852: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8853: FND_LOG.string(log_level => FND_LOG.level_statement,
8854: module => g_module_prefix || l_module_name,
8855: message => 'Calculated new l_curr_from_line_number = ' || l_batch_start);
8856: END IF; --}

Line 8853: FND_LOG.string(log_level => FND_LOG.level_statement,

8849: l_batch_end := l_batch_end + l_batch_size;
8850: END IF;
8851:
8852: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8853: FND_LOG.string(log_level => FND_LOG.level_statement,
8854: module => g_module_prefix || l_module_name,
8855: message => 'Calculated new l_curr_from_line_number = ' || l_batch_start);
8856: END IF; --}
8857:

Line 8866: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

8862: x_result := FND_API.g_ret_sts_unexp_error;
8863: x_error_code := SQLCODE;
8864: x_error_message := SUBSTR(SQLERRM, 1, 100);
8865:
8866: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
8867: FND_LOG.string (log_level => FND_LOG.level_exception,
8868: module => g_module_prefix || l_module_name,
8869: message => 'Unexpected exception occured error_code = ' || x_error_code || ', error_message = ' || x_error_message);
8870: END IF;

Line 8867: FND_LOG.string (log_level => FND_LOG.level_exception,

8863: x_error_code := SQLCODE;
8864: x_error_message := SUBSTR(SQLERRM, 1, 100);
8865:
8866: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
8867: FND_LOG.string (log_level => FND_LOG.level_exception,
8868: module => g_module_prefix || l_module_name,
8869: message => 'Unexpected exception occured error_code = ' || x_error_code || ', error_message = ' || x_error_message);
8870: END IF;
8871: END update_lines_before_publish;

Line 8889: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

8885:
8886: l_module_name := 'update_before_publish';
8887: x_result := FND_API.g_ret_sts_success;
8888:
8889: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8890: FND_LOG.string (log_level => FND_LOG.level_procedure,
8891: module => g_module_prefix || l_module_name,
8892: message => 'Entered procedure = ' || l_module_name);
8893: END IF;

Line 8890: FND_LOG.string (log_level => FND_LOG.level_procedure,

8886: l_module_name := 'update_before_publish';
8887: x_result := FND_API.g_ret_sts_success;
8888:
8889: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8890: FND_LOG.string (log_level => FND_LOG.level_procedure,
8891: module => g_module_prefix || l_module_name,
8892: message => 'Entered procedure = ' || l_module_name);
8893: END IF;
8894:

Line 8942: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

8938: last_update_date = sysdate
8939: WHERE
8940: auction_header_id = p_auction_header_id;
8941:
8942: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8943: FND_LOG.string (log_level => FND_LOG.level_procedure,
8944: module => g_module_prefix || l_module_name,
8945: message => 'Leaving procedure = ' || l_module_name);
8946: END IF;

Line 8943: FND_LOG.string (log_level => FND_LOG.level_procedure,

8939: WHERE
8940: auction_header_id = p_auction_header_id;
8941:
8942: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8943: FND_LOG.string (log_level => FND_LOG.level_procedure,
8944: module => g_module_prefix || l_module_name,
8945: message => 'Leaving procedure = ' || l_module_name);
8946: END IF;
8947:

Line 8954: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

8950: x_result := FND_API.g_ret_sts_unexp_error;
8951: x_error_code := SQLCODE;
8952: x_error_message := SUBSTR(SQLERRM, 1, 100);
8953:
8954: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
8955: FND_LOG.string (log_level => FND_LOG.level_exception,
8956: module => g_module_prefix || l_module_name,
8957: message => 'Unexpected exception occured error_code = ' || x_error_code || ', error_message = ' || x_error_message);
8958: END IF;

Line 8955: FND_LOG.string (log_level => FND_LOG.level_exception,

8951: x_error_code := SQLCODE;
8952: x_error_message := SUBSTR(SQLERRM, 1, 100);
8953:
8954: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
8955: FND_LOG.string (log_level => FND_LOG.level_exception,
8956: module => g_module_prefix || l_module_name,
8957: message => 'Unexpected exception occured error_code = ' || x_error_code || ', error_message = ' || x_error_message);
8958: END IF;
8959: END update_before_publish;

Line 8977: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

8973:
8974: l_module_name := 'report_concurrent_failure';
8975: x_result := FND_API.g_ret_sts_success;
8976:
8977: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8978: FND_LOG.string (log_level => FND_LOG.level_procedure,
8979: module => g_module_prefix || l_module_name,
8980: message => 'Entered procedure = ' || l_module_name);
8981: END IF;

Line 8978: FND_LOG.string (log_level => FND_LOG.level_procedure,

8974: l_module_name := 'report_concurrent_failure';
8975: x_result := FND_API.g_ret_sts_success;
8976:
8977: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8978: FND_LOG.string (log_level => FND_LOG.level_procedure,
8979: module => g_module_prefix || l_module_name,
8980: message => 'Entered procedure = ' || l_module_name);
8981: END IF;
8982:

Line 8983: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

8979: module => g_module_prefix || l_module_name,
8980: message => 'Entered procedure = ' || l_module_name);
8981: END IF;
8982:
8983: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8984: FND_LOG.string(log_level => FND_LOG.level_statement,
8985: module => g_module_prefix || 'report_concurrent_failure',
8986: message => 'Calling the notification genration procedure to inform failure'
8987: || ', p_request_id = ' || p_request_id

Line 8984: FND_LOG.string(log_level => FND_LOG.level_statement,

8980: message => 'Entered procedure = ' || l_module_name);
8981: END IF;
8982:
8983: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8984: FND_LOG.string(log_level => FND_LOG.level_statement,
8985: module => g_module_prefix || 'report_concurrent_failure',
8986: message => 'Calling the notification genration procedure to inform failure'
8987: || ', p_request_id = ' || p_request_id
8988: || ', p_messagetype = ' || 'E'

Line 9007: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

9003: p_ProgramTypeCode => p_program_type_code,
9004: p_DestinationPageCode => 'PON_CONCURRENT_ERRORS',
9005: p_bid_number => NULL);
9006:
9007: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9008: FND_LOG.string (log_level => FND_LOG.level_procedure,
9009: module => g_module_prefix || l_module_name,
9010: message => 'Leaving procedure = ' || l_module_name);
9011: END IF;

Line 9008: FND_LOG.string (log_level => FND_LOG.level_procedure,

9004: p_DestinationPageCode => 'PON_CONCURRENT_ERRORS',
9005: p_bid_number => NULL);
9006:
9007: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9008: FND_LOG.string (log_level => FND_LOG.level_procedure,
9009: module => g_module_prefix || l_module_name,
9010: message => 'Leaving procedure = ' || l_module_name);
9011: END IF;
9012:

Line 9019: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

9015: x_result := FND_API.g_ret_sts_unexp_error;
9016: x_error_code := SQLCODE;
9017: x_error_message := SUBSTR(SQLERRM, 1, 100);
9018:
9019: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
9020: FND_LOG.string (log_level => FND_LOG.level_exception,
9021: module => g_module_prefix || l_module_name,
9022: message => 'Unexpected exception occured error_code = ' ||
9023: x_error_code || ', error_message = ' || x_error_message);

Line 9020: FND_LOG.string (log_level => FND_LOG.level_exception,

9016: x_error_code := SQLCODE;
9017: x_error_message := SUBSTR(SQLERRM, 1, 100);
9018:
9019: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
9020: FND_LOG.string (log_level => FND_LOG.level_exception,
9021: module => g_module_prefix || l_module_name,
9022: message => 'Unexpected exception occured error_code = ' ||
9023: x_error_code || ', error_message = ' || x_error_message);
9024: END IF;

Line 9045: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

9041:
9042: l_module_name := 'report_concurrent_success';
9043: x_result := FND_API.g_ret_sts_success;
9044:
9045: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9046: FND_LOG.string (log_level => FND_LOG.level_procedure,
9047: module => g_module_prefix || l_module_name,
9048: message => 'Entered procedure = ' || l_module_name);
9049: END IF;

Line 9046: FND_LOG.string (log_level => FND_LOG.level_procedure,

9042: l_module_name := 'report_concurrent_success';
9043: x_result := FND_API.g_ret_sts_success;
9044:
9045: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9046: FND_LOG.string (log_level => FND_LOG.level_procedure,
9047: module => g_module_prefix || l_module_name,
9048: message => 'Entered procedure = ' || l_module_name);
9049: END IF;
9050:

Line 9059: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9055: ELSE
9056: l_destination_page_code := 'PON_NEG_SUMMARY';
9057: END IF;
9058:
9059: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9060: FND_LOG.string(log_level => FND_LOG.level_statement,
9061: module => g_module_prefix || l_module_name,
9062: message => 'Calling the notification genration procedure to inform success'
9063: || ', p_request_id = ' || p_request_id

Line 9060: FND_LOG.string(log_level => FND_LOG.level_statement,

9056: l_destination_page_code := 'PON_NEG_SUMMARY';
9057: END IF;
9058:
9059: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9060: FND_LOG.string(log_level => FND_LOG.level_statement,
9061: module => g_module_prefix || l_module_name,
9062: message => 'Calling the notification genration procedure to inform success'
9063: || ', p_request_id = ' || p_request_id
9064: || ', p_messagetype = ' || 'S'

Line 9083: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

9079: p_ProgramTypeCode => p_program_type_code,
9080: p_DestinationPageCode => l_destination_page_code,
9081: p_bid_number => NULL);
9082:
9083: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9084: FND_LOG.string (log_level => FND_LOG.level_procedure,
9085: module => g_module_prefix || l_module_name,
9086: message => 'Leaving procedure = ' || l_module_name);
9087: END IF;

Line 9084: FND_LOG.string (log_level => FND_LOG.level_procedure,

9080: p_DestinationPageCode => l_destination_page_code,
9081: p_bid_number => NULL);
9082:
9083: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9084: FND_LOG.string (log_level => FND_LOG.level_procedure,
9085: module => g_module_prefix || l_module_name,
9086: message => 'Leaving procedure = ' || l_module_name);
9087: END IF;
9088:

Line 9095: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

9091: x_result := FND_API.g_ret_sts_unexp_error;
9092: x_error_code := SQLCODE;
9093: x_error_message := SUBSTR(SQLERRM, 1, 100);
9094:
9095: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
9096: FND_LOG.string (log_level => FND_LOG.level_exception,
9097: module => g_module_prefix || l_module_name,
9098: message => 'Unexpected exception occured error_code = ' ||
9099: x_error_code || ', error_message = ' || x_error_message);

Line 9096: FND_LOG.string (log_level => FND_LOG.level_exception,

9092: x_error_code := SQLCODE;
9093: x_error_message := SUBSTR(SQLERRM, 1, 100);
9094:
9095: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
9096: FND_LOG.string (log_level => FND_LOG.level_exception,
9097: module => g_module_prefix || l_module_name,
9098: message => 'Unexpected exception occured error_code = ' ||
9099: x_error_code || ', error_message = ' || x_error_message);
9100: END IF;

Line 9124: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

9120:
9121: l_module_name := 'handle_fatal_exception';
9122: x_result := FND_API.g_ret_sts_success;
9123:
9124: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9125: FND_LOG.string (log_level => FND_LOG.level_procedure,
9126: module => g_module_prefix || l_module_name,
9127: message => 'Entered procedure = ' || l_module_name);
9128: END IF;

Line 9125: FND_LOG.string (log_level => FND_LOG.level_procedure,

9121: l_module_name := 'handle_fatal_exception';
9122: x_result := FND_API.g_ret_sts_success;
9123:
9124: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9125: FND_LOG.string (log_level => FND_LOG.level_procedure,
9126: module => g_module_prefix || l_module_name,
9127: message => 'Entered procedure = ' || l_module_name);
9128: END IF;
9129:

Line 9134: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

9130: -- Rollback any changes
9131: ROLLBACK;
9132:
9133: -- Log the error message
9134: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
9135: FND_LOG.string (log_level => FND_LOG.level_exception,
9136: module => g_module_prefix || l_module_name,
9137: message => 'Fatal Error Message = ' || p_log_message);
9138: END IF;

Line 9135: FND_LOG.string (log_level => FND_LOG.level_exception,

9131: ROLLBACK;
9132:
9133: -- Log the error message
9134: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
9135: FND_LOG.string (log_level => FND_LOG.level_exception,
9136: module => g_module_prefix || l_module_name,
9137: message => 'Fatal Error Message = ' || p_log_message);
9138: END IF;
9139:

Line 9173: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

9169:
9170: -- commit
9171: COMMIT;
9172:
9173: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9174: FND_LOG.string (log_level => FND_LOG.level_procedure,
9175: module => g_module_prefix || l_module_name,
9176: message => 'Leaving procedure = ' || l_module_name);
9177: END IF;

Line 9174: FND_LOG.string (log_level => FND_LOG.level_procedure,

9170: -- commit
9171: COMMIT;
9172:
9173: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9174: FND_LOG.string (log_level => FND_LOG.level_procedure,
9175: module => g_module_prefix || l_module_name,
9176: message => 'Leaving procedure = ' || l_module_name);
9177: END IF;
9178:

Line 9185: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

9181: x_result := FND_API.g_ret_sts_unexp_error;
9182: x_error_code := SQLCODE;
9183: x_error_message := SUBSTR(SQLERRM, 1, 100);
9184:
9185: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
9186: FND_LOG.string (log_level => FND_LOG.level_exception,
9187: module => g_module_prefix || l_module_name,
9188: message => 'Unexpected exception occured error_code = ' ||
9189: x_error_code || ', error_message = ' || x_error_message);

Line 9186: FND_LOG.string (log_level => FND_LOG.level_exception,

9182: x_error_code := SQLCODE;
9183: x_error_message := SUBSTR(SQLERRM, 1, 100);
9184:
9185: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
9186: FND_LOG.string (log_level => FND_LOG.level_exception,
9187: module => g_module_prefix || l_module_name,
9188: message => 'Unexpected exception occured error_code = ' ||
9189: x_error_code || ', error_message = ' || x_error_message);
9190: END IF;

Line 9329: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{

9325:
9326: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
9327: l_login_id := FND_GLOBAL.LOGIN_ID;
9328:
9329: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{
9330: FND_LOG.string(log_level => FND_LOG.level_procedure,
9331: module => g_module_prefix || l_module_name,
9332: message => 'Entered procedure: p_auction_header_id = ' || p_auction_header_id
9333: || ', p_for_approval = ' || BOOLEAN_TO_STRING (p_for_approval)

Line 9330: FND_LOG.string(log_level => FND_LOG.level_procedure,

9326: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
9327: l_login_id := FND_GLOBAL.LOGIN_ID;
9328:
9329: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{
9330: FND_LOG.string(log_level => FND_LOG.level_procedure,
9331: module => g_module_prefix || l_module_name,
9332: message => 'Entered procedure: p_auction_header_id = ' || p_auction_header_id
9333: || ', p_for_approval = ' || BOOLEAN_TO_STRING (p_for_approval)
9334: || ', p_note_to_approvers = ' || p_note_to_approvers

Line 9346: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9342: || ', p_company_party_id = ' || p_company_party_id
9343: || ', p_curr_language = ' || p_curr_language);
9344: END IF; --}
9345:
9346: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9347: FND_LOG.string(log_level => FND_LOG.level_statement,
9348: module => g_module_prefix || l_module_name,
9349: message => 'Collection auction information');
9350: END IF; --}

Line 9347: FND_LOG.string(log_level => FND_LOG.level_statement,

9343: || ', p_curr_language = ' || p_curr_language);
9344: END IF; --}
9345:
9346: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9347: FND_LOG.string(log_level => FND_LOG.level_statement,
9348: module => g_module_prefix || l_module_name,
9349: message => 'Collection auction information');
9350: END IF; --}
9351:

Line 9457: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9453: INTO l_invitees_count
9454: FROM pon_bidding_parties
9455: WHERE auction_header_id = p_auction_header_id;
9456:
9457: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9458: FND_LOG.string(log_level => FND_LOG.level_statement,
9459: module => g_module_prefix || l_module_name,
9460: message => 'Auction information collected: ' ||
9461: 'l_draft_locked = ' || l_draft_locked ||

Line 9458: FND_LOG.string(log_level => FND_LOG.level_statement,

9454: FROM pon_bidding_parties
9455: WHERE auction_header_id = p_auction_header_id;
9456:
9457: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9458: FND_LOG.string(log_level => FND_LOG.level_statement,
9459: module => g_module_prefix || l_module_name,
9460: message => 'Auction information collected: ' ||
9461: 'l_draft_locked = ' || l_draft_locked ||
9462: ', l_draft_locked_by_contact_id = ' || l_draft_locked_by_contact_id ||

Line 9496: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9492: ', l_bid_visibility_code = ' || l_bid_visibility_code ||
9493: ', l_price_tiers_indicator = ' || l_price_tiers_indicator);
9494: END IF; --}
9495:
9496: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9497: FND_LOG.string(log_level => FND_LOG.level_statement,
9498: module => g_module_prefix || l_module_name,
9499: message => 'Checking for lock on the negotiation');
9500: END IF; --}

Line 9497: FND_LOG.string(log_level => FND_LOG.level_statement,

9493: ', l_price_tiers_indicator = ' || l_price_tiers_indicator);
9494: END IF; --}
9495:
9496: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9497: FND_LOG.string(log_level => FND_LOG.level_statement,
9498: module => g_module_prefix || l_module_name,
9499: message => 'Checking for lock on the negotiation');
9500: END IF; --}
9501:

Line 9506: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9502: --CHECK FOR DRAFT LOCK ON THE NEGOTIATION
9503:
9504: IF (NOT ('Y' = l_draft_locked AND l_draft_locked_by_contact_id = p_user_party_id)) THEN --{
9505:
9506: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9507: FND_LOG.string(log_level => FND_LOG.level_statement,
9508: module => g_module_prefix || l_module_name,
9509: message => 'The person who initiated the concurrent program no longer has the lock on the negotiation');
9510: END IF; --}

Line 9507: FND_LOG.string(log_level => FND_LOG.level_statement,

9503:
9504: IF (NOT ('Y' = l_draft_locked AND l_draft_locked_by_contact_id = p_user_party_id)) THEN --{
9505:
9506: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9507: FND_LOG.string(log_level => FND_LOG.level_statement,
9508: module => g_module_prefix || l_module_name,
9509: message => 'The person who initiated the concurrent program no longer has the lock on the negotiation');
9510: END IF; --}
9511:

Line 9529: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9525: p_auction_header_id => p_auction_header_id,
9526: p_expiration_date => SYSDATE + 7,
9527: p_user_id => p_user_id);
9528:
9529: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9530: FND_LOG.string(log_level => FND_LOG.level_statement,
9531: module => g_module_prefix || l_module_name,
9532: message => 'Setting return code to 2 and returning after logging PON_NO_DRAFT_LOCK error');
9533: END IF; --}

Line 9530: FND_LOG.string(log_level => FND_LOG.level_statement,

9526: p_expiration_date => SYSDATE + 7,
9527: p_user_id => p_user_id);
9528:
9529: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9530: FND_LOG.string(log_level => FND_LOG.level_statement,
9531: module => g_module_prefix || l_module_name,
9532: message => 'Setting return code to 2 and returning after logging PON_NO_DRAFT_LOCK error');
9533: END IF; --}
9534:

Line 9568: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9564: l_prev_document_number := l_auction_header_id_prev_round;
9565: END IF; --}
9566:
9567:
9568: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9569: FND_LOG.string(log_level => FND_LOG.level_statement,
9570: module => g_module_prefix || l_module_name,
9571: message => 'New round/amendment variables initialized' ||
9572: ', l_is_new_round = ' || BOOLEAN_TO_STRING (l_is_new_round)||

Line 9569: FND_LOG.string(log_level => FND_LOG.level_statement,

9565: END IF; --}
9566:
9567:
9568: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9569: FND_LOG.string(log_level => FND_LOG.level_statement,
9570: module => g_module_prefix || l_module_name,
9571: message => 'New round/amendment variables initialized' ||
9572: ', l_is_new_round = ' || BOOLEAN_TO_STRING (l_is_new_round)||
9573: ', l_is_amendment = ' || BOOLEAN_TO_STRING (l_is_amendment)||

Line 9582: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9578: --If the negotiation that the buyer is amending becomes closed or cancelled,
9579:
9580: IF (l_is_amendment) THEN
9581:
9582: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9583: FND_LOG.string(log_level => FND_LOG.level_statement,
9584: module => g_module_prefix || l_module_name,
9585: message => 'This is an amendment, checking if the amendment can be published or not');
9586: END IF; --}

Line 9583: FND_LOG.string(log_level => FND_LOG.level_statement,

9579:
9580: IF (l_is_amendment) THEN
9581:
9582: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9583: FND_LOG.string(log_level => FND_LOG.level_statement,
9584: module => g_module_prefix || l_module_name,
9585: message => 'This is an amendment, checking if the amendment can be published or not');
9586: END IF; --}
9587:

Line 9592: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9588: PON_NEG_UPDATE_PKG.CAN_EDIT_DRAFT_AMEND (
9589: p_auction_header_id_prev_doc => l_auction_header_id_prev_amend,
9590: x_error_code => l_error_code);
9591:
9592: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9593: FND_LOG.string(log_level => FND_LOG.level_statement,
9594: module => g_module_prefix || l_module_name,
9595: message => 'The return code from call to PON_NEG_UPDATE_PKG.CAN_EDIT_DRAFT_AMEND = ' || l_error_code);
9596: END IF; --}

Line 9593: FND_LOG.string(log_level => FND_LOG.level_statement,

9589: p_auction_header_id_prev_doc => l_auction_header_id_prev_amend,
9590: x_error_code => l_error_code);
9591:
9592: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9593: FND_LOG.string(log_level => FND_LOG.level_statement,
9594: module => g_module_prefix || l_module_name,
9595: message => 'The return code from call to PON_NEG_UPDATE_PKG.CAN_EDIT_DRAFT_AMEND = ' || l_error_code);
9596: END IF; --}
9597:

Line 9600: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9596: END IF; --}
9597:
9598: IF (l_error_code <> 'SUCCESS') THEN
9599:
9600: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9601: FND_LOG.string(log_level => FND_LOG.level_statement,
9602: module => g_module_prefix || l_module_name,
9603: message => 'The return code is not success so logging error and exiting');
9604: END IF; --}

Line 9601: FND_LOG.string(log_level => FND_LOG.level_statement,

9597:
9598: IF (l_error_code <> 'SUCCESS') THEN
9599:
9600: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9601: FND_LOG.string(log_level => FND_LOG.level_statement,
9602: module => g_module_prefix || l_module_name,
9603: message => 'The return code is not success so logging error and exiting');
9604: END IF; --}
9605:

Line 9635: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9631: RETURN;
9632: END IF;
9633: END IF;
9634:
9635: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9636: FND_LOG.string(log_level => FND_LOG.level_statement,
9637: module => g_module_prefix || l_module_name,
9638: message => 'Calling validate lines procedure');
9639: END IF; --}

Line 9636: FND_LOG.string(log_level => FND_LOG.level_statement,

9632: END IF;
9633: END IF;
9634:
9635: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9636: FND_LOG.string(log_level => FND_LOG.level_statement,
9637: module => g_module_prefix || l_module_name,
9638: message => 'Calling validate lines procedure');
9639: END IF; --}
9640:

Line 9691: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9687: RETCODE := 2;
9688: RETURN;
9689: END IF; --}
9690:
9691: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9692: FND_LOG.string(log_level => FND_LOG.level_statement,
9693: module => g_module_prefix || l_module_name,
9694: message => 'Calling CHECK_ACTION_ERRORS_PRESENT with l_batch_id = ' || l_batch_id);
9695: END IF; --}

Line 9692: FND_LOG.string(log_level => FND_LOG.level_statement,

9688: RETURN;
9689: END IF; --}
9690:
9691: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9692: FND_LOG.string(log_level => FND_LOG.level_statement,
9693: module => g_module_prefix || l_module_name,
9694: message => 'Calling CHECK_ACTION_ERRORS_PRESENT with l_batch_id = ' || l_batch_id);
9695: END IF; --}
9696:

Line 9700: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9696:
9697: -- Check if there are any errors logged by the VALIDATE_LINES procedure
9698: l_errors_present := CHECK_ACTION_ERRORS_PRESENT (l_batch_id);
9699:
9700: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9701: FND_LOG.string(log_level => FND_LOG.level_statement,
9702: module => g_module_prefix || l_module_name,
9703: message => 'Return value from CHECK_ACTION_ERRORS_PRESENT = ' || BOOLEAN_TO_STRING (l_errors_present));
9704: END IF; --}

Line 9701: FND_LOG.string(log_level => FND_LOG.level_statement,

9697: -- Check if there are any errors logged by the VALIDATE_LINES procedure
9698: l_errors_present := CHECK_ACTION_ERRORS_PRESENT (l_batch_id);
9699:
9700: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9701: FND_LOG.string(log_level => FND_LOG.level_statement,
9702: module => g_module_prefix || l_module_name,
9703: message => 'Return value from CHECK_ACTION_ERRORS_PRESENT = ' || BOOLEAN_TO_STRING (l_errors_present));
9704: END IF; --}
9705:

Line 9711: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9707:
9708: -- If errors are present then the concurrent program status should be set to ERROR
9709: RETCODE := 2;
9710:
9711: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9712: FND_LOG.string(log_level => FND_LOG.level_statement,
9713: module => g_module_prefix || l_module_name,
9714: message => 'Errors were found while validating, exiting with return code = ' || RETCODE);
9715: END IF; --}

Line 9712: FND_LOG.string(log_level => FND_LOG.level_statement,

9708: -- If errors are present then the concurrent program status should be set to ERROR
9709: RETCODE := 2;
9710:
9711: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9712: FND_LOG.string(log_level => FND_LOG.level_statement,
9713: module => g_module_prefix || l_module_name,
9714: message => 'Errors were found while validating, exiting with return code = ' || RETCODE);
9715: END IF; --}
9716:

Line 9717: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9713: module => g_module_prefix || l_module_name,
9714: message => 'Errors were found while validating, exiting with return code = ' || RETCODE);
9715: END IF; --}
9716:
9717: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9718: FND_LOG.string(log_level => FND_LOG.level_statement,
9719: module => g_module_prefix || l_module_name,
9720: message => 'Rolling back the transaction and saving the errors');
9721: END IF; --}

Line 9718: FND_LOG.string(log_level => FND_LOG.level_statement,

9714: message => 'Errors were found while validating, exiting with return code = ' || RETCODE);
9715: END IF; --}
9716:
9717: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9718: FND_LOG.string(log_level => FND_LOG.level_statement,
9719: module => g_module_prefix || l_module_name,
9720: message => 'Rolling back the transaction and saving the errors');
9721: END IF; --}
9722:

Line 9748: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9744:
9745: l_redirect_func := 'PON_NEG_CRT_REVIEW';
9746: END IF; --}
9747:
9748: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9749: FND_LOG.string(log_level => FND_LOG.level_statement,
9750: module => g_module_prefix || l_module_name,
9751: message => 'l_redirect_func = ' || l_redirect_func);
9752: END IF; --}

Line 9749: FND_LOG.string(log_level => FND_LOG.level_statement,

9745: l_redirect_func := 'PON_NEG_CRT_REVIEW';
9746: END IF; --}
9747:
9748: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9749: FND_LOG.string(log_level => FND_LOG.level_statement,
9750: module => g_module_prefix || l_module_name,
9751: message => 'l_redirect_func = ' || l_redirect_func);
9752: END IF; --}
9753:

Line 9759: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9755: -- on the draft and initiate the approval workflow
9756:
9757: IF (p_for_approval) THEN --{
9758:
9759: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9760: FND_LOG.string(log_level => FND_LOG.level_statement,
9761: module => g_module_prefix || l_module_name,
9762: message => 'This is for approval');
9763: END IF; --}

Line 9760: FND_LOG.string(log_level => FND_LOG.level_statement,

9756:
9757: IF (p_for_approval) THEN --{
9758:
9759: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9760: FND_LOG.string(log_level => FND_LOG.level_statement,
9761: module => g_module_prefix || l_module_name,
9762: message => 'This is for approval');
9763: END IF; --}
9764:

Line 9779: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9775: LAST_UPDATED_BY = p_user_id
9776: WHERE
9777: AUCTION_HEADER_ID = p_auction_header_id;
9778:
9779: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9780: FND_LOG.string(log_level => FND_LOG.level_statement,
9781: module => g_module_prefix || l_module_name,
9782: message => 'Initiating the approval workflow'
9783: || ', p_encrypted_auction_header_id = ' || p_encrypted_auction_header_id

Line 9780: FND_LOG.string(log_level => FND_LOG.level_statement,

9776: WHERE
9777: AUCTION_HEADER_ID = p_auction_header_id;
9778:
9779: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9780: FND_LOG.string(log_level => FND_LOG.level_statement,
9781: module => g_module_prefix || l_module_name,
9782: message => 'Initiating the approval workflow'
9783: || ', p_encrypted_auction_header_id = ' || p_encrypted_auction_header_id
9784: || ', P_AUCTION_HEADER_ID = ' || p_auction_header_id

Line 9820: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9816: Newly created conformed document will be published.
9817: */
9818: IF (PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(l_doctype_id) = 1 AND l_amendment_flag = 'Y') THEN
9819:
9820: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9821: FND_LOG.string(log_level => FND_LOG.level_statement,
9822: module => g_module_prefix || l_module_name,
9823: message => 'This is for creating conformed document. Calling pon_negotiation_copy_grp.CONFORM_AMENDMENT');
9824: END IF; --}

Line 9821: FND_LOG.string(log_level => FND_LOG.level_statement,

9817: */
9818: IF (PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(l_doctype_id) = 1 AND l_amendment_flag = 'Y') THEN
9819:
9820: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9821: FND_LOG.string(log_level => FND_LOG.level_statement,
9822: module => g_module_prefix || l_module_name,
9823: message => 'This is for creating conformed document. Calling pon_negotiation_copy_grp.CONFORM_AMENDMENT');
9824: END IF; --}
9825:

Line 9837: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9833: x_revision => l_conf_doc_revision);
9834:
9835: IF (l_result <> FND_API.G_RET_STS_SUCCESS) THEN
9836:
9837: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9838: FND_LOG.string(log_level => FND_LOG.level_statement,
9839: module => g_module_prefix || l_module_name,
9840: message => 'Error occured while creating conformed document, errors are as below:');
9841: END IF; --}

Line 9838: FND_LOG.string(log_level => FND_LOG.level_statement,

9834:
9835: IF (l_result <> FND_API.G_RET_STS_SUCCESS) THEN
9836:
9837: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9838: FND_LOG.string(log_level => FND_LOG.level_statement,
9839: module => g_module_prefix || l_module_name,
9840: message => 'Error occured while creating conformed document, errors are as below:');
9841: END IF; --}
9842:

Line 9845: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9841: END IF; --}
9842:
9843: FOR i IN 1..l_msg_count LOOP
9844: l_error_msg := FND_MSG_PUB.Get(p_msg_index => i,p_encoded => 'F');
9845: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9846: FND_LOG.string(log_level => FND_LOG.level_statement,
9847: module => g_module_prefix || l_module_name,
9848: message => l_error_msg);
9849: END IF; --}

Line 9846: FND_LOG.string(log_level => FND_LOG.level_statement,

9842:
9843: FOR i IN 1..l_msg_count LOOP
9844: l_error_msg := FND_MSG_PUB.Get(p_msg_index => i,p_encoded => 'F');
9845: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9846: FND_LOG.string(log_level => FND_LOG.level_statement,
9847: module => g_module_prefix || l_module_name,
9848: message => l_error_msg);
9849: END IF; --}
9850: --Log this error in the PON_INTERFACE_ERRORS TABLE

Line 9865: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9861: p_user_id => p_user_id);
9862:
9863: END LOOP;
9864:
9865: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9866: FND_LOG.string(log_level => FND_LOG.level_statement,
9867: module => g_module_prefix || l_module_name,
9868: message => 'Setting return code to 2 and returning after logging errors.');
9869: END IF; --}

Line 9866: FND_LOG.string(log_level => FND_LOG.level_statement,

9862:
9863: END LOOP;
9864:
9865: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9866: FND_LOG.string(log_level => FND_LOG.level_statement,
9867: module => g_module_prefix || l_module_name,
9868: message => 'Setting return code to 2 and returning after logging errors.');
9869: END IF; --}
9870:

Line 9889: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9885: COMMIT;
9886: RETURN;
9887: END IF;
9888: ELSE
9889: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9890: FND_LOG.string(log_level => FND_LOG.level_statement,
9891: module => g_module_prefix || l_module_name,
9892: message => 'This is for publish');
9893: END IF; --}

Line 9890: FND_LOG.string(log_level => FND_LOG.level_statement,

9886: RETURN;
9887: END IF;
9888: ELSE
9889: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9890: FND_LOG.string(log_level => FND_LOG.level_statement,
9891: module => g_module_prefix || l_module_name,
9892: message => 'This is for publish');
9893: END IF; --}
9894:

Line 9895: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9891: module => g_module_prefix || l_module_name,
9892: message => 'This is for publish');
9893: END IF; --}
9894:
9895: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9896: FND_LOG.string(log_level => FND_LOG.level_statement,
9897: module => g_module_prefix || l_module_name,
9898: message => 'Calling update lines before publish');
9899: END IF; --}

Line 9896: FND_LOG.string(log_level => FND_LOG.level_statement,

9892: message => 'This is for publish');
9893: END IF; --}
9894:
9895: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9896: FND_LOG.string(log_level => FND_LOG.level_statement,
9897: module => g_module_prefix || l_module_name,
9898: message => 'Calling update lines before publish');
9899: END IF; --}
9900:

Line 9930: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9926: RETCODE := 2;
9927: RETURN;
9928: END IF; --}
9929:
9930: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9931: FND_LOG.string(log_level => FND_LOG.level_statement,
9932: module => g_module_prefix || l_module_name,
9933: message => 'Calling update header before publish');
9934: END IF; --}

Line 9931: FND_LOG.string(log_level => FND_LOG.level_statement,

9927: RETURN;
9928: END IF; --}
9929:
9930: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9931: FND_LOG.string(log_level => FND_LOG.level_statement,
9932: module => g_module_prefix || l_module_name,
9933: message => 'Calling update header before publish');
9934: END IF; --}
9935:

Line 9961: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9957: RETCODE := 2;
9958: RETURN;
9959: END IF; --}
9960:
9961: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9962: FND_LOG.string(log_level => FND_LOG.level_statement,
9963: module => g_module_prefix || l_module_name,
9964: message => 'Checking if this is a new round or amendment');
9965: END IF; --}

Line 9962: FND_LOG.string(log_level => FND_LOG.level_statement,

9958: RETURN;
9959: END IF; --}
9960:
9961: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9962: FND_LOG.string(log_level => FND_LOG.level_statement,
9963: module => g_module_prefix || l_module_name,
9964: message => 'Checking if this is a new round or amendment');
9965: END IF; --}
9966:

Line 9977: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

9973: ELSE
9974: l_transaction_type := 'CREATE_NEW_ROUND';
9975: END IF;
9976:
9977: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9978: FND_LOG.string(log_level => FND_LOG.level_statement,
9979: module => g_module_prefix || l_module_name,
9980: message => 'Calling update_to_new_document');
9981: END IF; --}

Line 9978: FND_LOG.string(log_level => FND_LOG.level_statement,

9974: l_transaction_type := 'CREATE_NEW_ROUND';
9975: END IF;
9976:
9977: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9978: FND_LOG.string(log_level => FND_LOG.level_statement,
9979: module => g_module_prefix || l_module_name,
9980: message => 'Calling update_to_new_document');
9981: END IF; --}
9982:

Line 9998: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN --{

9994:
9995: IF (nvl (l_error_code, g_invalid_string) <> 'SUCCESS') THEN
9996:
9997: --EXCEPTION: EXIT FROM CONCURRENT PROGRAM
9998: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN --{
9999: FND_LOG.string(log_level => FND_LOG.level_exception,
10000: module => g_module_prefix || l_module_name,
10001: message => 'Exception in update_to_new_document call = ' || l_error_msg);
10002: END IF; --}

Line 9999: FND_LOG.string(log_level => FND_LOG.level_exception,

9995: IF (nvl (l_error_code, g_invalid_string) <> 'SUCCESS') THEN
9996:
9997: --EXCEPTION: EXIT FROM CONCURRENT PROGRAM
9998: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN --{
9999: FND_LOG.string(log_level => FND_LOG.level_exception,
10000: module => g_module_prefix || l_module_name,
10001: message => 'Exception in update_to_new_document call = ' || l_error_msg);
10002: END IF; --}
10003:

Line 10040: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

10036: RETURN;
10037: END IF;
10038: END IF; -- end IF (l_is_amendment OR l_is_new_round)}
10039:
10040: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
10041: FND_LOG.string(log_level => FND_LOG.level_statement,
10042: module => g_module_prefix || l_module_name,
10043: message => 'Inserting row into pon discussions');
10044: END IF; --}

Line 10041: FND_LOG.string(log_level => FND_LOG.level_statement,

10037: END IF;
10038: END IF; -- end IF (l_is_amendment OR l_is_new_round)}
10039:
10040: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
10041: FND_LOG.string(log_level => FND_LOG.level_statement,
10042: module => g_module_prefix || l_module_name,
10043: message => 'Inserting row into pon discussions');
10044: END IF; --}
10045:

Line 10240: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN --{

10236: -- In case of an exception then
10237: -- rollback any changes done and send out a failure notification
10238: ROLLBACK;
10239:
10240: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN --{
10241: FND_LOG.string(log_level => FND_LOG.level_exception,
10242: module => g_module_prefix || l_module_name,
10243: message => substrb(SQLERRM, 1, 500));
10244: END IF; --}

Line 10241: FND_LOG.string(log_level => FND_LOG.level_exception,

10237: -- rollback any changes done and send out a failure notification
10238: ROLLBACK;
10239:
10240: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN --{
10241: FND_LOG.string(log_level => FND_LOG.level_exception,
10242: module => g_module_prefix || l_module_name,
10243: message => substrb(SQLERRM, 1, 500));
10244: END IF; --}
10245:

Line 10275: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{

10271: END; --}
10272:
10273: COMMIT;
10274:
10275: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{
10276: FND_LOG.string(log_level => FND_LOG.level_procedure,
10277: module => g_module_prefix || l_module_name,
10278: message => 'Leaving concurrent program');
10279: END IF; --}

Line 10276: FND_LOG.string(log_level => FND_LOG.level_procedure,

10272:
10273: COMMIT;
10274:
10275: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{
10276: FND_LOG.string(log_level => FND_LOG.level_procedure,
10277: module => g_module_prefix || l_module_name,
10278: message => 'Leaving concurrent program');
10279: END IF; --}
10280: