4678: --
4679: -- If cancelled, then return "Cancelled"
4680: --
4681: IF (p_auction_status = 'CANCELLED') THEN
4682: v_time_left := fnd_message.get_string('PON', 'PON_AUC_CANCELLED');
4683: RETURN v_time_left;
4684: END IF;
4685:
4686: --
4686: --
4687: -- If amended, then return "N/A"
4688: --
4689: IF (p_auction_status = 'AMENDED') THEN
4690: v_time_left := fnd_message.get_string('PON', 'PON_NOT_APPLICABLE');
4691: RETURN v_time_left;
4692: END IF;
4693:
4694: -- We will check the dates are valid.
4709: ELSE
4710: -- if a staggered auction
4711: --then show STAGGERED CLOSING for close date
4712: IF p_staggered_closing_interval IS NOT NULL THEN
4713: return fnd_message.get_string('PON','PON_STAGGERED_CLOSING_MSG');
4714: END IF;
4715: v_difference := to_number( p_close_bidding_date - p_last_pause_date );
4716: END IF;
4717:
4720: --
4721: -- If closed, then return "0 seconds"
4722: --
4723: IF (p_close_bidding_date < sysdate) THEN
4724: fnd_message.clear;
4725: fnd_message.set_name('PON','PON_AUC_INTERVAL_SEC');
4726: fnd_message.set_token('SECONDS',0);
4727: v_time_left := fnd_message.get;
4728: RETURN v_time_left;
4721: -- If closed, then return "0 seconds"
4722: --
4723: IF (p_close_bidding_date < sysdate) THEN
4724: fnd_message.clear;
4725: fnd_message.set_name('PON','PON_AUC_INTERVAL_SEC');
4726: fnd_message.set_token('SECONDS',0);
4727: v_time_left := fnd_message.get;
4728: RETURN v_time_left;
4729: END IF;
4722: --
4723: IF (p_close_bidding_date < sysdate) THEN
4724: fnd_message.clear;
4725: fnd_message.set_name('PON','PON_AUC_INTERVAL_SEC');
4726: fnd_message.set_token('SECONDS',0);
4727: v_time_left := fnd_message.get;
4728: RETURN v_time_left;
4729: END IF;
4730:
4723: IF (p_close_bidding_date < sysdate) THEN
4724: fnd_message.clear;
4725: fnd_message.set_name('PON','PON_AUC_INTERVAL_SEC');
4726: fnd_message.set_token('SECONDS',0);
4727: v_time_left := fnd_message.get;
4728: RETURN v_time_left;
4729: END IF;
4730:
4731: -- if a staggered auction
4730:
4731: -- if a staggered auction
4732: --then show STAGGERED CLOSING for close date
4733: IF p_staggered_closing_interval IS NOT NULL THEN
4734: return fnd_message.get_string('PON','PON_STAGGERED_CLOSING_MSG');
4735: END IF;
4736: --
4737: -- If the start date is in the future, then
4738: -- calculate the difference from sysdate to start date and
4770: --
4771: -- If we have less than one minute
4772: --
4773: IF(v_days < 1 AND v_hours < 1 AND v_minutes < 1 AND 0 < v_seconds) THEN
4774: v_time_left := fnd_message.get_string('PON', 'PON_LESS_MINUTE'||v_opens_in_suffix);
4775: --
4776: -- If we have less than one second, display 0 minutes
4777: --
4778: ELSIF(v_days < 1 AND v_hours < 1 AND v_minutes < 1 AND v_seconds < 1) THEN
4775: --
4776: -- If we have less than one second, display 0 minutes
4777: --
4778: ELSIF(v_days < 1 AND v_hours < 1 AND v_minutes < 1 AND v_seconds < 1) THEN
4779: fnd_message.clear;
4780: IF (v_opens_in_suffix is not null) THEN
4781: fnd_message.set_name('PON','PON_MINUTES'||v_opens_in_suffix);
4782: fnd_message.set_token('NUM_MINUTES',0);
4783: ELSE
4777: --
4778: ELSIF(v_days < 1 AND v_hours < 1 AND v_minutes < 1 AND v_seconds < 1) THEN
4779: fnd_message.clear;
4780: IF (v_opens_in_suffix is not null) THEN
4781: fnd_message.set_name('PON','PON_MINUTES'||v_opens_in_suffix);
4782: fnd_message.set_token('NUM_MINUTES',0);
4783: ELSE
4784: fnd_message.set_name('PON','PON_AUC_INTERVAL_SEC');
4785: fnd_message.set_token('SECONDS',0);
4778: ELSIF(v_days < 1 AND v_hours < 1 AND v_minutes < 1 AND v_seconds < 1) THEN
4779: fnd_message.clear;
4780: IF (v_opens_in_suffix is not null) THEN
4781: fnd_message.set_name('PON','PON_MINUTES'||v_opens_in_suffix);
4782: fnd_message.set_token('NUM_MINUTES',0);
4783: ELSE
4784: fnd_message.set_name('PON','PON_AUC_INTERVAL_SEC');
4785: fnd_message.set_token('SECONDS',0);
4786: END IF;
4780: IF (v_opens_in_suffix is not null) THEN
4781: fnd_message.set_name('PON','PON_MINUTES'||v_opens_in_suffix);
4782: fnd_message.set_token('NUM_MINUTES',0);
4783: ELSE
4784: fnd_message.set_name('PON','PON_AUC_INTERVAL_SEC');
4785: fnd_message.set_token('SECONDS',0);
4786: END IF;
4787: v_time_left := fnd_message.get;
4788: --
4781: fnd_message.set_name('PON','PON_MINUTES'||v_opens_in_suffix);
4782: fnd_message.set_token('NUM_MINUTES',0);
4783: ELSE
4784: fnd_message.set_name('PON','PON_AUC_INTERVAL_SEC');
4785: fnd_message.set_token('SECONDS',0);
4786: END IF;
4787: v_time_left := fnd_message.get;
4788: --
4789: -- If we have just one minute
4783: ELSE
4784: fnd_message.set_name('PON','PON_AUC_INTERVAL_SEC');
4785: fnd_message.set_token('SECONDS',0);
4786: END IF;
4787: v_time_left := fnd_message.get;
4788: --
4789: -- If we have just one minute
4790: --
4791: ELSIF(v_days < 1 AND v_hours < 1 AND v_minutes = 1) THEN
4788: --
4789: -- If we have just one minute
4790: --
4791: ELSIF(v_days < 1 AND v_hours < 1 AND v_minutes = 1) THEN
4792: v_time_left := fnd_message.get_string('PON', 'PON_MINUTE'||v_opens_in_suffix);
4793: --
4794: -- If we have just minutes
4795: --
4796: ELSIF(v_days < 1 AND v_hours < 1 AND v_minutes > 1 ) THEN
4793: --
4794: -- If we have just minutes
4795: --
4796: ELSIF(v_days < 1 AND v_hours < 1 AND v_minutes > 1 ) THEN
4797: fnd_message.clear;
4798: fnd_message.set_name('PON','PON_MINUTES'||v_opens_in_suffix);
4799: fnd_message.set_token('NUM_MINUTES',v_minutes);
4800: v_time_left := fnd_message.get;
4801: --
4794: -- If we have just minutes
4795: --
4796: ELSIF(v_days < 1 AND v_hours < 1 AND v_minutes > 1 ) THEN
4797: fnd_message.clear;
4798: fnd_message.set_name('PON','PON_MINUTES'||v_opens_in_suffix);
4799: fnd_message.set_token('NUM_MINUTES',v_minutes);
4800: v_time_left := fnd_message.get;
4801: --
4802: -- If we have one hour
4795: --
4796: ELSIF(v_days < 1 AND v_hours < 1 AND v_minutes > 1 ) THEN
4797: fnd_message.clear;
4798: fnd_message.set_name('PON','PON_MINUTES'||v_opens_in_suffix);
4799: fnd_message.set_token('NUM_MINUTES',v_minutes);
4800: v_time_left := fnd_message.get;
4801: --
4802: -- If we have one hour
4803: --
4796: ELSIF(v_days < 1 AND v_hours < 1 AND v_minutes > 1 ) THEN
4797: fnd_message.clear;
4798: fnd_message.set_name('PON','PON_MINUTES'||v_opens_in_suffix);
4799: fnd_message.set_token('NUM_MINUTES',v_minutes);
4800: v_time_left := fnd_message.get;
4801: --
4802: -- If we have one hour
4803: --
4804: ELSIF(v_days < 1 AND v_hours = 1 AND v_minutes < 1) THEN
4801: --
4802: -- If we have one hour
4803: --
4804: ELSIF(v_days < 1 AND v_hours = 1 AND v_minutes < 1) THEN
4805: v_time_left := fnd_message.get_string('PON','PON_HOUR'||v_opens_in_suffix);
4806: --
4807: -- If we have one hour and one minute
4808: --
4809: ELSIF(v_days < 1 AND v_hours = 1 AND v_minutes = 1) THEN
4806: --
4807: -- If we have one hour and one minute
4808: --
4809: ELSIF(v_days < 1 AND v_hours = 1 AND v_minutes = 1) THEN
4810: v_time_left := fnd_message.get_string('PON','PON_HOUR_MINUTE'||v_opens_in_suffix);
4811: --
4812: -- If we have one hour and minutes
4813: --
4814: ELSIF(v_days < 1 AND v_hours = 1 AND v_minutes > 1) THEN
4811: --
4812: -- If we have one hour and minutes
4813: --
4814: ELSIF(v_days < 1 AND v_hours = 1 AND v_minutes > 1) THEN
4815: fnd_message.clear;
4816: fnd_message.set_name('PON','PON_HOUR_MINUTES'||v_opens_in_suffix);
4817: fnd_message.set_token('NUM_MINUTES',v_minutes);
4818: v_time_left := fnd_message.get;
4819: --
4812: -- If we have one hour and minutes
4813: --
4814: ELSIF(v_days < 1 AND v_hours = 1 AND v_minutes > 1) THEN
4815: fnd_message.clear;
4816: fnd_message.set_name('PON','PON_HOUR_MINUTES'||v_opens_in_suffix);
4817: fnd_message.set_token('NUM_MINUTES',v_minutes);
4818: v_time_left := fnd_message.get;
4819: --
4820: -- If we have hours
4813: --
4814: ELSIF(v_days < 1 AND v_hours = 1 AND v_minutes > 1) THEN
4815: fnd_message.clear;
4816: fnd_message.set_name('PON','PON_HOUR_MINUTES'||v_opens_in_suffix);
4817: fnd_message.set_token('NUM_MINUTES',v_minutes);
4818: v_time_left := fnd_message.get;
4819: --
4820: -- If we have hours
4821: --
4814: ELSIF(v_days < 1 AND v_hours = 1 AND v_minutes > 1) THEN
4815: fnd_message.clear;
4816: fnd_message.set_name('PON','PON_HOUR_MINUTES'||v_opens_in_suffix);
4817: fnd_message.set_token('NUM_MINUTES',v_minutes);
4818: v_time_left := fnd_message.get;
4819: --
4820: -- If we have hours
4821: --
4822: ELSIF(v_days < 1 AND v_hours > 1 AND v_minutes < 1) THEN
4819: --
4820: -- If we have hours
4821: --
4822: ELSIF(v_days < 1 AND v_hours > 1 AND v_minutes < 1) THEN
4823: fnd_message.clear;
4824: fnd_message.set_name('PON','PON_HOURS'||v_opens_in_suffix);
4825: fnd_message.set_token('NUM_HOURS',v_hours);
4826: v_time_left := fnd_message.get;
4827: --
4820: -- If we have hours
4821: --
4822: ELSIF(v_days < 1 AND v_hours > 1 AND v_minutes < 1) THEN
4823: fnd_message.clear;
4824: fnd_message.set_name('PON','PON_HOURS'||v_opens_in_suffix);
4825: fnd_message.set_token('NUM_HOURS',v_hours);
4826: v_time_left := fnd_message.get;
4827: --
4828: -- If we have hours and one minute
4821: --
4822: ELSIF(v_days < 1 AND v_hours > 1 AND v_minutes < 1) THEN
4823: fnd_message.clear;
4824: fnd_message.set_name('PON','PON_HOURS'||v_opens_in_suffix);
4825: fnd_message.set_token('NUM_HOURS',v_hours);
4826: v_time_left := fnd_message.get;
4827: --
4828: -- If we have hours and one minute
4829: --
4822: ELSIF(v_days < 1 AND v_hours > 1 AND v_minutes < 1) THEN
4823: fnd_message.clear;
4824: fnd_message.set_name('PON','PON_HOURS'||v_opens_in_suffix);
4825: fnd_message.set_token('NUM_HOURS',v_hours);
4826: v_time_left := fnd_message.get;
4827: --
4828: -- If we have hours and one minute
4829: --
4830: ELSIF(v_days < 1 AND v_hours > 1 AND v_minutes = 1) THEN
4827: --
4828: -- If we have hours and one minute
4829: --
4830: ELSIF(v_days < 1 AND v_hours > 1 AND v_minutes = 1) THEN
4831: fnd_message.clear;
4832: fnd_message.set_name('PON','PON_HOURS_MINUTE'||v_opens_in_suffix);
4833: fnd_message.set_token('NUM_HOURS',v_hours);
4834: v_time_left := fnd_message.get;
4835: --
4828: -- If we have hours and one minute
4829: --
4830: ELSIF(v_days < 1 AND v_hours > 1 AND v_minutes = 1) THEN
4831: fnd_message.clear;
4832: fnd_message.set_name('PON','PON_HOURS_MINUTE'||v_opens_in_suffix);
4833: fnd_message.set_token('NUM_HOURS',v_hours);
4834: v_time_left := fnd_message.get;
4835: --
4836: -- If we have hours and minutes
4829: --
4830: ELSIF(v_days < 1 AND v_hours > 1 AND v_minutes = 1) THEN
4831: fnd_message.clear;
4832: fnd_message.set_name('PON','PON_HOURS_MINUTE'||v_opens_in_suffix);
4833: fnd_message.set_token('NUM_HOURS',v_hours);
4834: v_time_left := fnd_message.get;
4835: --
4836: -- If we have hours and minutes
4837: --
4830: ELSIF(v_days < 1 AND v_hours > 1 AND v_minutes = 1) THEN
4831: fnd_message.clear;
4832: fnd_message.set_name('PON','PON_HOURS_MINUTE'||v_opens_in_suffix);
4833: fnd_message.set_token('NUM_HOURS',v_hours);
4834: v_time_left := fnd_message.get;
4835: --
4836: -- If we have hours and minutes
4837: --
4838: ELSIF(v_days < 1 AND v_hours > 1 AND v_minutes > 1) THEN
4835: --
4836: -- If we have hours and minutes
4837: --
4838: ELSIF(v_days < 1 AND v_hours > 1 AND v_minutes > 1) THEN
4839: fnd_message.clear;
4840: fnd_message.set_name('PON','PON_HOURS_MINUTES'||v_opens_in_suffix);
4841: fnd_message.set_token('NUM_HOURS',v_hours);
4842: fnd_message.set_token('NUM_MINUTES',v_minutes);
4843: v_time_left := fnd_message.get;
4836: -- If we have hours and minutes
4837: --
4838: ELSIF(v_days < 1 AND v_hours > 1 AND v_minutes > 1) THEN
4839: fnd_message.clear;
4840: fnd_message.set_name('PON','PON_HOURS_MINUTES'||v_opens_in_suffix);
4841: fnd_message.set_token('NUM_HOURS',v_hours);
4842: fnd_message.set_token('NUM_MINUTES',v_minutes);
4843: v_time_left := fnd_message.get;
4844: --
4837: --
4838: ELSIF(v_days < 1 AND v_hours > 1 AND v_minutes > 1) THEN
4839: fnd_message.clear;
4840: fnd_message.set_name('PON','PON_HOURS_MINUTES'||v_opens_in_suffix);
4841: fnd_message.set_token('NUM_HOURS',v_hours);
4842: fnd_message.set_token('NUM_MINUTES',v_minutes);
4843: v_time_left := fnd_message.get;
4844: --
4845: -- If we have one day
4838: ELSIF(v_days < 1 AND v_hours > 1 AND v_minutes > 1) THEN
4839: fnd_message.clear;
4840: fnd_message.set_name('PON','PON_HOURS_MINUTES'||v_opens_in_suffix);
4841: fnd_message.set_token('NUM_HOURS',v_hours);
4842: fnd_message.set_token('NUM_MINUTES',v_minutes);
4843: v_time_left := fnd_message.get;
4844: --
4845: -- If we have one day
4846: --
4839: fnd_message.clear;
4840: fnd_message.set_name('PON','PON_HOURS_MINUTES'||v_opens_in_suffix);
4841: fnd_message.set_token('NUM_HOURS',v_hours);
4842: fnd_message.set_token('NUM_MINUTES',v_minutes);
4843: v_time_left := fnd_message.get;
4844: --
4845: -- If we have one day
4846: --
4847: ELSIF(v_days = 1 AND v_hours < 1) THEN
4844: --
4845: -- If we have one day
4846: --
4847: ELSIF(v_days = 1 AND v_hours < 1) THEN
4848: v_time_left := fnd_message.get_string('PON','PON_DAY'||v_opens_in_suffix);
4849: --
4850: -- If we have one day and one hour
4851: --
4852: ELSIF(v_days = 1 AND v_hours = 1) THEN
4849: --
4850: -- If we have one day and one hour
4851: --
4852: ELSIF(v_days = 1 AND v_hours = 1) THEN
4853: v_time_left := fnd_message.get_string('PON','PON_DAY_HOUR'||v_opens_in_suffix);
4854: --
4855: -- If we have one day and hours
4856: --
4857: ELSIF(v_days = 1 AND v_hours > 1) THEN
4854: --
4855: -- If we have one day and hours
4856: --
4857: ELSIF(v_days = 1 AND v_hours > 1) THEN
4858: fnd_message.clear;
4859: fnd_message.set_name('PON','PON_DAY_HOURS'||v_opens_in_suffix);
4860: fnd_message.set_token('NUM_HOURS',v_hours);
4861: v_time_left := fnd_message.get;
4862: --
4855: -- If we have one day and hours
4856: --
4857: ELSIF(v_days = 1 AND v_hours > 1) THEN
4858: fnd_message.clear;
4859: fnd_message.set_name('PON','PON_DAY_HOURS'||v_opens_in_suffix);
4860: fnd_message.set_token('NUM_HOURS',v_hours);
4861: v_time_left := fnd_message.get;
4862: --
4863: -- If we have days
4856: --
4857: ELSIF(v_days = 1 AND v_hours > 1) THEN
4858: fnd_message.clear;
4859: fnd_message.set_name('PON','PON_DAY_HOURS'||v_opens_in_suffix);
4860: fnd_message.set_token('NUM_HOURS',v_hours);
4861: v_time_left := fnd_message.get;
4862: --
4863: -- If we have days
4864: --
4857: ELSIF(v_days = 1 AND v_hours > 1) THEN
4858: fnd_message.clear;
4859: fnd_message.set_name('PON','PON_DAY_HOURS'||v_opens_in_suffix);
4860: fnd_message.set_token('NUM_HOURS',v_hours);
4861: v_time_left := fnd_message.get;
4862: --
4863: -- If we have days
4864: --
4865: ELSIF(v_days > 1 AND v_hours < 1) THEN
4862: --
4863: -- If we have days
4864: --
4865: ELSIF(v_days > 1 AND v_hours < 1) THEN
4866: fnd_message.clear;
4867: fnd_message.set_name('PON','PON_DAYS'||v_opens_in_suffix);
4868: fnd_message.set_token('NUM_DAYS',v_days);
4869: v_time_left := fnd_message.get;
4870: --
4863: -- If we have days
4864: --
4865: ELSIF(v_days > 1 AND v_hours < 1) THEN
4866: fnd_message.clear;
4867: fnd_message.set_name('PON','PON_DAYS'||v_opens_in_suffix);
4868: fnd_message.set_token('NUM_DAYS',v_days);
4869: v_time_left := fnd_message.get;
4870: --
4871: -- If we have days and one hour
4864: --
4865: ELSIF(v_days > 1 AND v_hours < 1) THEN
4866: fnd_message.clear;
4867: fnd_message.set_name('PON','PON_DAYS'||v_opens_in_suffix);
4868: fnd_message.set_token('NUM_DAYS',v_days);
4869: v_time_left := fnd_message.get;
4870: --
4871: -- If we have days and one hour
4872: --
4865: ELSIF(v_days > 1 AND v_hours < 1) THEN
4866: fnd_message.clear;
4867: fnd_message.set_name('PON','PON_DAYS'||v_opens_in_suffix);
4868: fnd_message.set_token('NUM_DAYS',v_days);
4869: v_time_left := fnd_message.get;
4870: --
4871: -- If we have days and one hour
4872: --
4873: ELSIF(v_days > 1 AND v_hours = 1) THEN
4870: --
4871: -- If we have days and one hour
4872: --
4873: ELSIF(v_days > 1 AND v_hours = 1) THEN
4874: fnd_message.clear;
4875: fnd_message.set_name('PON','PON_DAYS_HOUR'||v_opens_in_suffix);
4876: fnd_message.set_token('NUM_DAYS',v_days);
4877: v_time_left := fnd_message.get;
4878: --
4871: -- If we have days and one hour
4872: --
4873: ELSIF(v_days > 1 AND v_hours = 1) THEN
4874: fnd_message.clear;
4875: fnd_message.set_name('PON','PON_DAYS_HOUR'||v_opens_in_suffix);
4876: fnd_message.set_token('NUM_DAYS',v_days);
4877: v_time_left := fnd_message.get;
4878: --
4879: -- If we have days and hours
4872: --
4873: ELSIF(v_days > 1 AND v_hours = 1) THEN
4874: fnd_message.clear;
4875: fnd_message.set_name('PON','PON_DAYS_HOUR'||v_opens_in_suffix);
4876: fnd_message.set_token('NUM_DAYS',v_days);
4877: v_time_left := fnd_message.get;
4878: --
4879: -- If we have days and hours
4880: --
4873: ELSIF(v_days > 1 AND v_hours = 1) THEN
4874: fnd_message.clear;
4875: fnd_message.set_name('PON','PON_DAYS_HOUR'||v_opens_in_suffix);
4876: fnd_message.set_token('NUM_DAYS',v_days);
4877: v_time_left := fnd_message.get;
4878: --
4879: -- If we have days and hours
4880: --
4881: ELSIF(v_days > 1 AND v_hours > 1) THEN
4878: --
4879: -- If we have days and hours
4880: --
4881: ELSIF(v_days > 1 AND v_hours > 1) THEN
4882: fnd_message.clear;
4883: fnd_message.set_name('PON','PON_DAYS_HOURS'||v_opens_in_suffix);
4884: fnd_message.set_token('NUM_DAYS',v_days);
4885: fnd_message.set_token('NUM_HOURS',v_hours);
4886: v_time_left := fnd_message.get;
4879: -- If we have days and hours
4880: --
4881: ELSIF(v_days > 1 AND v_hours > 1) THEN
4882: fnd_message.clear;
4883: fnd_message.set_name('PON','PON_DAYS_HOURS'||v_opens_in_suffix);
4884: fnd_message.set_token('NUM_DAYS',v_days);
4885: fnd_message.set_token('NUM_HOURS',v_hours);
4886: v_time_left := fnd_message.get;
4887: END IF;
4880: --
4881: ELSIF(v_days > 1 AND v_hours > 1) THEN
4882: fnd_message.clear;
4883: fnd_message.set_name('PON','PON_DAYS_HOURS'||v_opens_in_suffix);
4884: fnd_message.set_token('NUM_DAYS',v_days);
4885: fnd_message.set_token('NUM_HOURS',v_hours);
4886: v_time_left := fnd_message.get;
4887: END IF;
4888: --
4881: ELSIF(v_days > 1 AND v_hours > 1) THEN
4882: fnd_message.clear;
4883: fnd_message.set_name('PON','PON_DAYS_HOURS'||v_opens_in_suffix);
4884: fnd_message.set_token('NUM_DAYS',v_days);
4885: fnd_message.set_token('NUM_HOURS',v_hours);
4886: v_time_left := fnd_message.get;
4887: END IF;
4888: --
4889: -- Return the time left
4882: fnd_message.clear;
4883: fnd_message.set_name('PON','PON_DAYS_HOURS'||v_opens_in_suffix);
4884: fnd_message.set_token('NUM_DAYS',v_days);
4885: fnd_message.set_token('NUM_HOURS',v_hours);
4886: v_time_left := fnd_message.get;
4887: END IF;
4888: --
4889: -- Return the time left
4890: --
5559: --message := PON_PROFILE_UTIL_PKG.GET_STRING(PON_AUCTION_PKG.OperationId, 'PON', msg, PON_AUCTION_PKG.SessionLanguage);
5560: message := PON_PROFILE_UTIL_PKG.GET_STRING('PON', msg, PON_AUCTION_PKG.SessionLanguage);
5561:
5562: if (message is null) then
5563: message := fnd_message.get_string('PON', msg);
5564: end if;
5565:
5566: EXCEPTION
5567: WHEN others THEN
13371: --unlocking or unsealing it, then the status has to be Cancelled (Technical Unlocked)
13372: --or Cancelled (Technical Unsealed)
13373: IF (l_auction_status2 in ('CANCELLED') ) THEN
13374:
13375: fnd_message.set_name('PON', 'PON_TWO_PART_CANCELLED');
13376:
13377: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
13378: FND_LOG.string(log_level => FND_LOG.level_statement,
13379: module => g_module_prefix || 'GET_AUCTION_STATUS_DISPLAY',
13379: module => g_module_prefix || 'GET_AUCTION_STATUS_DISPLAY',
13380: message => 'The auction is cancelled after technically unlocking/unsealing it');
13381: END IF;
13382:
13383: fnd_message.set_token('LOCK_STATUS', l_technical_lock_meaning);
13384: fnd_message.set_token('ROUND',get_technical_meaning);
13385:
13386: l_message := fnd_message.get;
13387:
13380: message => 'The auction is cancelled after technically unlocking/unsealing it');
13381: END IF;
13382:
13383: fnd_message.set_token('LOCK_STATUS', l_technical_lock_meaning);
13384: fnd_message.set_token('ROUND',get_technical_meaning);
13385:
13386: l_message := fnd_message.get;
13387:
13388: ELSE
13382:
13383: fnd_message.set_token('LOCK_STATUS', l_technical_lock_meaning);
13384: fnd_message.set_token('ROUND',get_technical_meaning);
13385:
13386: l_message := fnd_message.get;
13387:
13388: ELSE
13389:
13390: -- check if it is buyer
13421: message => 'Auction has a commercial lock on it'
13422: );
13423: END IF;
13424:
13425: fnd_message.set_name('PON', 'PON_TWO_PART_ROUNDCOMP');
13426: fnd_message.set_token('SEALED_STATUS', l_technical_lock_meaning);
13427: fnd_message.set_token('ROUND',get_technical_meaning);
13428: l_message := fnd_message.get;
13429:
13422: );
13423: END IF;
13424:
13425: fnd_message.set_name('PON', 'PON_TWO_PART_ROUNDCOMP');
13426: fnd_message.set_token('SEALED_STATUS', l_technical_lock_meaning);
13427: fnd_message.set_token('ROUND',get_technical_meaning);
13428: l_message := fnd_message.get;
13429:
13430: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
13423: END IF;
13424:
13425: fnd_message.set_name('PON', 'PON_TWO_PART_ROUNDCOMP');
13426: fnd_message.set_token('SEALED_STATUS', l_technical_lock_meaning);
13427: fnd_message.set_token('ROUND',get_technical_meaning);
13428: l_message := fnd_message.get;
13429:
13430: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
13431: FND_LOG.string(log_level => FND_LOG.level_statement,
13424:
13425: fnd_message.set_name('PON', 'PON_TWO_PART_ROUNDCOMP');
13426: fnd_message.set_token('SEALED_STATUS', l_technical_lock_meaning);
13427: fnd_message.set_token('ROUND',get_technical_meaning);
13428: l_message := fnd_message.get;
13429:
13430: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
13431: FND_LOG.string(log_level => FND_LOG.level_statement,
13432: module => g_module_prefix || 'GET_AUCTION_STATUS_DISPLAY',
13434: );
13435: END IF;
13436:
13437: else
13438: fnd_message.set_name('PON', 'PON_AUC_ROUNDCOMP');
13439: l_message := fnd_message.get || ' (' || l_commercial_lock_meaning || ')';
13440:
13441: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
13442: FND_LOG.string(log_level => FND_LOG.level_statement,
13435: END IF;
13436:
13437: else
13438: fnd_message.set_name('PON', 'PON_AUC_ROUNDCOMP');
13439: l_message := fnd_message.get || ' (' || l_commercial_lock_meaning || ')';
13440:
13441: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
13442: FND_LOG.string(log_level => FND_LOG.level_statement,
13443: module => g_module_prefix || 'GET_AUCTION_STATUS_DISPLAY',
13456: );
13457: END IF;
13458:
13459: -- show Evaluation Complete: Technical
13460: fnd_message.set_name('PON', 'PON_EVALUATION_COMPLETE');
13461: --fnd_message.set_token('EVALUATION_COMPLETE', eval_complete_meaning);
13462: fnd_message.set_token('ROUND',get_technical_meaning);
13463: l_message := fnd_message.get;
13464:
13457: END IF;
13458:
13459: -- show Evaluation Complete: Technical
13460: fnd_message.set_name('PON', 'PON_EVALUATION_COMPLETE');
13461: --fnd_message.set_token('EVALUATION_COMPLETE', eval_complete_meaning);
13462: fnd_message.set_token('ROUND',get_technical_meaning);
13463: l_message := fnd_message.get;
13464:
13465: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
13458:
13459: -- show Evaluation Complete: Technical
13460: fnd_message.set_name('PON', 'PON_EVALUATION_COMPLETE');
13461: --fnd_message.set_token('EVALUATION_COMPLETE', eval_complete_meaning);
13462: fnd_message.set_token('ROUND',get_technical_meaning);
13463: l_message := fnd_message.get;
13464:
13465: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
13466: FND_LOG.string(log_level => FND_LOG.level_statement,
13459: -- show Evaluation Complete: Technical
13460: fnd_message.set_name('PON', 'PON_EVALUATION_COMPLETE');
13461: --fnd_message.set_token('EVALUATION_COMPLETE', eval_complete_meaning);
13462: fnd_message.set_token('ROUND',get_technical_meaning);
13463: l_message := fnd_message.get;
13464:
13465: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
13466: FND_LOG.string(log_level => FND_LOG.level_statement,
13467: module => g_module_prefix || 'GET_AUCTION_STATUS_DISPLAY',
13489: );
13490: END IF;
13491:
13492: -- show Evaluation in Progress: Technical (Unsealed)
13493: fnd_message.set_name('PON','PON_EVALUATION_IN_PROGRESS');
13494: --fnd_message.set_token('EVALUATION_IN_PROGRESS',eval_in_prog_meaning);
13495: fnd_message.set_token('ROUND',get_technical_meaning);
13496: --fnd_message.set_token('SEALED_AUCTION_STATUS', l_commercial_lock_meaning);
13497: l_message := fnd_message.get || ' (' || l_technical_lock_meaning || ')';
13490: END IF;
13491:
13492: -- show Evaluation in Progress: Technical (Unsealed)
13493: fnd_message.set_name('PON','PON_EVALUATION_IN_PROGRESS');
13494: --fnd_message.set_token('EVALUATION_IN_PROGRESS',eval_in_prog_meaning);
13495: fnd_message.set_token('ROUND',get_technical_meaning);
13496: --fnd_message.set_token('SEALED_AUCTION_STATUS', l_commercial_lock_meaning);
13497: l_message := fnd_message.get || ' (' || l_technical_lock_meaning || ')';
13498:
13491:
13492: -- show Evaluation in Progress: Technical (Unsealed)
13493: fnd_message.set_name('PON','PON_EVALUATION_IN_PROGRESS');
13494: --fnd_message.set_token('EVALUATION_IN_PROGRESS',eval_in_prog_meaning);
13495: fnd_message.set_token('ROUND',get_technical_meaning);
13496: --fnd_message.set_token('SEALED_AUCTION_STATUS', l_commercial_lock_meaning);
13497: l_message := fnd_message.get || ' (' || l_technical_lock_meaning || ')';
13498:
13499: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
13492: -- show Evaluation in Progress: Technical (Unsealed)
13493: fnd_message.set_name('PON','PON_EVALUATION_IN_PROGRESS');
13494: --fnd_message.set_token('EVALUATION_IN_PROGRESS',eval_in_prog_meaning);
13495: fnd_message.set_token('ROUND',get_technical_meaning);
13496: --fnd_message.set_token('SEALED_AUCTION_STATUS', l_commercial_lock_meaning);
13497: l_message := fnd_message.get || ' (' || l_technical_lock_meaning || ')';
13498:
13499: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
13500: FND_LOG.string(log_level => FND_LOG.level_statement,
13493: fnd_message.set_name('PON','PON_EVALUATION_IN_PROGRESS');
13494: --fnd_message.set_token('EVALUATION_IN_PROGRESS',eval_in_prog_meaning);
13495: fnd_message.set_token('ROUND',get_technical_meaning);
13496: --fnd_message.set_token('SEALED_AUCTION_STATUS', l_commercial_lock_meaning);
13497: l_message := fnd_message.get || ' (' || l_technical_lock_meaning || ')';
13498:
13499: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
13500: FND_LOG.string(log_level => FND_LOG.level_statement,
13501: module => g_module_prefix || 'GET_AUCTION_STATUS_DISPLAY',
13511: message => 'Technical unclocked but commercially locked '
13512: );
13513: END IF;
13514:
13515: fnd_message.set_name('PON', 'PON_EVALUATION_IN_PROGRESS');
13516: --fnd_message.set_token('EVALUATION_IN_PROGRESS', eval_in_prog_meaning);
13517: fnd_message.set_token('ROUND',get_technical_meaning);
13518: l_message := fnd_message.get;
13519:
13512: );
13513: END IF;
13514:
13515: fnd_message.set_name('PON', 'PON_EVALUATION_IN_PROGRESS');
13516: --fnd_message.set_token('EVALUATION_IN_PROGRESS', eval_in_prog_meaning);
13517: fnd_message.set_token('ROUND',get_technical_meaning);
13518: l_message := fnd_message.get;
13519:
13520: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
13513: END IF;
13514:
13515: fnd_message.set_name('PON', 'PON_EVALUATION_IN_PROGRESS');
13516: --fnd_message.set_token('EVALUATION_IN_PROGRESS', eval_in_prog_meaning);
13517: fnd_message.set_token('ROUND',get_technical_meaning);
13518: l_message := fnd_message.get;
13519:
13520: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
13521: FND_LOG.string(log_level => FND_LOG.level_statement,
13514:
13515: fnd_message.set_name('PON', 'PON_EVALUATION_IN_PROGRESS');
13516: --fnd_message.set_token('EVALUATION_IN_PROGRESS', eval_in_prog_meaning);
13517: fnd_message.set_token('ROUND',get_technical_meaning);
13518: l_message := fnd_message.get;
13519:
13520: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
13521: FND_LOG.string(log_level => FND_LOG.level_statement,
13522: module => g_module_prefix || 'GET_AUCTION_STATUS_DISPLAY',
13536: message => 'commercial part unlocked'
13537: );
13538: END IF;
13539:
13540: fnd_message.set_name('PON', 'PON_EVALUATION_IN_PROGRESS');
13541: --fnd_message.set_token('EVALUATION_IN_PROGRESS', eval_in_prog_meaning);
13542: fnd_message.set_token('ROUND',get_commercial_meaning);
13543: l_message := fnd_message.get;
13544:
13537: );
13538: END IF;
13539:
13540: fnd_message.set_name('PON', 'PON_EVALUATION_IN_PROGRESS');
13541: --fnd_message.set_token('EVALUATION_IN_PROGRESS', eval_in_prog_meaning);
13542: fnd_message.set_token('ROUND',get_commercial_meaning);
13543: l_message := fnd_message.get;
13544:
13545: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
13538: END IF;
13539:
13540: fnd_message.set_name('PON', 'PON_EVALUATION_IN_PROGRESS');
13541: --fnd_message.set_token('EVALUATION_IN_PROGRESS', eval_in_prog_meaning);
13542: fnd_message.set_token('ROUND',get_commercial_meaning);
13543: l_message := fnd_message.get;
13544:
13545: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
13546: FND_LOG.string(log_level => FND_LOG.level_statement,
13539:
13540: fnd_message.set_name('PON', 'PON_EVALUATION_IN_PROGRESS');
13541: --fnd_message.set_token('EVALUATION_IN_PROGRESS', eval_in_prog_meaning);
13542: fnd_message.set_token('ROUND',get_commercial_meaning);
13543: l_message := fnd_message.get;
13544:
13545: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
13546: FND_LOG.string(log_level => FND_LOG.level_statement,
13547: module => g_module_prefix || 'GET_AUCTION_STATUS_DISPLAY',
13562: );
13563: END IF;
13564:
13565: -- show Evaluation in Progress: Commercial (Unsealed)
13566: fnd_message.set_name('PON', 'PON_EVALUATION_IN_PROGRESS');
13567: --fnd_message.set_token('EVALUATION_IN_PROGRESS', eval_in_prog_meaning);
13568: fnd_message.set_token('ROUND',get_commercial_meaning);
13569: l_message := fnd_message.get || ' (' || l_commercial_lock_meaning || ')';
13570:
13563: END IF;
13564:
13565: -- show Evaluation in Progress: Commercial (Unsealed)
13566: fnd_message.set_name('PON', 'PON_EVALUATION_IN_PROGRESS');
13567: --fnd_message.set_token('EVALUATION_IN_PROGRESS', eval_in_prog_meaning);
13568: fnd_message.set_token('ROUND',get_commercial_meaning);
13569: l_message := fnd_message.get || ' (' || l_commercial_lock_meaning || ')';
13570:
13571: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
13564:
13565: -- show Evaluation in Progress: Commercial (Unsealed)
13566: fnd_message.set_name('PON', 'PON_EVALUATION_IN_PROGRESS');
13567: --fnd_message.set_token('EVALUATION_IN_PROGRESS', eval_in_prog_meaning);
13568: fnd_message.set_token('ROUND',get_commercial_meaning);
13569: l_message := fnd_message.get || ' (' || l_commercial_lock_meaning || ')';
13570:
13571: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
13572: FND_LOG.string(log_level => FND_LOG.level_statement,
13565: -- show Evaluation in Progress: Commercial (Unsealed)
13566: fnd_message.set_name('PON', 'PON_EVALUATION_IN_PROGRESS');
13567: --fnd_message.set_token('EVALUATION_IN_PROGRESS', eval_in_prog_meaning);
13568: fnd_message.set_token('ROUND',get_commercial_meaning);
13569: l_message := fnd_message.get || ' (' || l_commercial_lock_meaning || ')';
13570:
13571: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
13572: FND_LOG.string(log_level => FND_LOG.level_statement,
13573: module => g_module_prefix || 'GET_AUCTION_STATUS_DISPLAY',
13588: declare
13589: l_closed_meaning VARCHAR2(30);
13590: begin
13591: -- show Closed (Unlocked: Technical) or Closed (Unsealed: Technical)
13592: fnd_message.set_name('PON','PON_AUC_CLOSED_ROUND');
13593: --fnd_message.set_token('CLOSED', l_closed_meaning);
13594: fnd_message.set_token('SEALED_STATUS',l_technical_lock_meaning);
13595: fnd_message.set_token('ROUND',get_technical_meaning);
13596: l_message := fnd_message.get;
13589: l_closed_meaning VARCHAR2(30);
13590: begin
13591: -- show Closed (Unlocked: Technical) or Closed (Unsealed: Technical)
13592: fnd_message.set_name('PON','PON_AUC_CLOSED_ROUND');
13593: --fnd_message.set_token('CLOSED', l_closed_meaning);
13594: fnd_message.set_token('SEALED_STATUS',l_technical_lock_meaning);
13595: fnd_message.set_token('ROUND',get_technical_meaning);
13596: l_message := fnd_message.get;
13597:
13590: begin
13591: -- show Closed (Unlocked: Technical) or Closed (Unsealed: Technical)
13592: fnd_message.set_name('PON','PON_AUC_CLOSED_ROUND');
13593: --fnd_message.set_token('CLOSED', l_closed_meaning);
13594: fnd_message.set_token('SEALED_STATUS',l_technical_lock_meaning);
13595: fnd_message.set_token('ROUND',get_technical_meaning);
13596: l_message := fnd_message.get;
13597:
13598: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
13591: -- show Closed (Unlocked: Technical) or Closed (Unsealed: Technical)
13592: fnd_message.set_name('PON','PON_AUC_CLOSED_ROUND');
13593: --fnd_message.set_token('CLOSED', l_closed_meaning);
13594: fnd_message.set_token('SEALED_STATUS',l_technical_lock_meaning);
13595: fnd_message.set_token('ROUND',get_technical_meaning);
13596: l_message := fnd_message.get;
13597:
13598: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
13599: FND_LOG.string(log_level => FND_LOG.level_statement,
13592: fnd_message.set_name('PON','PON_AUC_CLOSED_ROUND');
13593: --fnd_message.set_token('CLOSED', l_closed_meaning);
13594: fnd_message.set_token('SEALED_STATUS',l_technical_lock_meaning);
13595: fnd_message.set_token('ROUND',get_technical_meaning);
13596: l_message := fnd_message.get;
13597:
13598: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
13599: FND_LOG.string(log_level => FND_LOG.level_statement,
13600: module => g_module_prefix || 'GET_AUCTION_STATUS_DISPLAY',