DBA Data[Home] [Help]

APPS.PAY_AU_RETRO_UPGRADE dependencies on FND_FILE

Line 1447: fnd_file.put_line( FND_FILE.LOG,'WARNING: User Defined Element ' ||l_retro_element_name || ' already exist, cannot upgrade '|| l_upg_element_name || ' (Element Type ID: ' || p_element_type_id || ').'); /* 5461629 */

1443: FETCH upgraded_element_check INTO l_upgraded_element;
1444: CLOSE upgraded_element_check;
1445: -- GT12,LT12 elements were not created by upgrade process
1446: if l_upgraded_element <> 'Y' then
1447: fnd_file.put_line( FND_FILE.LOG,'WARNING: User Defined Element ' ||l_retro_element_name || ' already exist, cannot upgrade '|| l_upg_element_name || ' (Element Type ID: ' || p_element_type_id || ').'); /* 5461629 */
1448: l_user_element_exist :='Y';
1449: l_upgrade_element_exist := 'N';
1450: exit;
1451: else

Line 1712: fnd_file.put_line(FND_FILE.LOG,'MESSAGE: Element ' || lv_element_name || ' (Element Type ID: ' || p_object_id|| ')'|| ' does not require upgrade as not included in a Retro Element set.');

1708: /* Bug 5731490 - Moved statement outside IF Block */
1709: if ((lv_classification_name = 'Earnings' AND lv_label = 'Standard')
1710: OR lv_classification_name = 'Pre Tax Deductions'
1711: OR ln_retro_summ_ele_id IS NOT NULL) and lv_qualified ='N' and ln_element_set_exist = TRUE then
1712: fnd_file.put_line(FND_FILE.LOG,'MESSAGE: Element ' || lv_element_name || ' (Element Type ID: ' || p_object_id|| ')'|| ' does not require upgrade as not included in a Retro Element set.');
1713: elsif NOT ((lv_classification_name = 'Earnings' AND lv_label = 'Standard')
1714: OR lv_classification_name = 'Pre Tax Deductions'
1715: OR ln_retro_summ_ele_id IS NOT NULL) and ln_element_set_exist = TRUE then
1716: fnd_file.put_line(FND_FILE.LOG,'MESSAGE: Element ' || lv_element_name || ' (Element Type ID: ' || p_object_id|| ')'|| ' with classification ' ||lv_classification_name||' '||lv_label||' does not require upgrade.');

Line 1716: fnd_file.put_line(FND_FILE.LOG,'MESSAGE: Element ' || lv_element_name || ' (Element Type ID: ' || p_object_id|| ')'|| ' with classification ' ||lv_classification_name||' '||lv_label||' does not require upgrade.');

1712: fnd_file.put_line(FND_FILE.LOG,'MESSAGE: Element ' || lv_element_name || ' (Element Type ID: ' || p_object_id|| ')'|| ' does not require upgrade as not included in a Retro Element set.');
1713: elsif NOT ((lv_classification_name = 'Earnings' AND lv_label = 'Standard')
1714: OR lv_classification_name = 'Pre Tax Deductions'
1715: OR ln_retro_summ_ele_id IS NOT NULL) and ln_element_set_exist = TRUE then
1716: fnd_file.put_line(FND_FILE.LOG,'MESSAGE: Element ' || lv_element_name || ' (Element Type ID: ' || p_object_id|| ')'|| ' with classification ' ||lv_classification_name||' '||lv_label||' does not require upgrade.');
1717: end if;
1718:
1719: IF g_debug THEN
1720: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);

Line 1942: fnd_file.put_line(FND_FILE.LOG,'MESSAGE: Retro Component already exist for Element ' || lv_element_name || ' (Element Type ID: ' || p_element_type_id || ').' );

1938: FETCH c_get_retro_components INTO ln_retro_comp_exists;
1939: CLOSE c_get_retro_components;
1940:
1941: if ln_retro_comp_exists <> 0 then /* 5461629 */
1942: fnd_file.put_line(FND_FILE.LOG,'MESSAGE: Retro Component already exist for Element ' || lv_element_name || ' (Element Type ID: ' || p_element_type_id || ').' );
1943: end if;
1944: /* Bug#5583165 */
1945: if ln_retro_comp_exists = 0 then
1946: -- Procedure sets p_user_element_exist to 'Y' if GT12,LT12 elements of retro element were created by user

Line 2152: fnd_file.put_line(FND_FILE.LOG,'MESSAGE: Successfully upgraded Element ' || lv_element_name || ' (Element Type ID: ' || p_element_type_id || ').');

2148: insert_event_group(ln_ele_business_group_id
2149: ,p_element_type_id
2150: ,ln_event_group_id);
2151:
2152: fnd_file.put_line(FND_FILE.LOG,'MESSAGE: Successfully upgraded Element ' || lv_element_name || ' (Element Type ID: ' || p_element_type_id || ').');
2153:
2154: END IF;
2155:
2156: close c_retro_info;

Line 2216: fnd_file.put_line(FND_FILE.LOG,'MESSAGE: Successfully upgraded Element ' || lv_element_name || ' (Element Type ID: ' || p_element_type_id || ').');

2212: insert_event_group(ln_ele_business_group_id
2213: ,p_element_type_id
2214: ,ln_event_group_id);
2215:
2216: fnd_file.put_line(FND_FILE.LOG,'MESSAGE: Successfully upgraded Element ' || lv_element_name || ' (Element Type ID: ' || p_element_type_id || ').');
2217:
2218: END IF;
2219: CLOSE c_retro_info;
2220:

Line 3246: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Enhanced Retropay Rule Enabled ');

3242: l_leg_rule := pay_au_retro_upgrade.set_retro_leg_rule(p_calling_form => 'UPGRADE');
3243:
3244: IF ( l_leg_rule = 'Y')
3245: THEN
3246: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Enhanced Retropay Rule Enabled ');
3247: pay_au_retro_upgrade.create_enhanced_retro_defn;
3248: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Enhanced Retropay Retro Definitions Created ');
3249: pay_au_retro_upgrade.set_enh_retro_request_group;
3250: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Request Group - programs for Enhanced Retropay added ');

Line 3248: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Enhanced Retropay Retro Definitions Created ');

3244: IF ( l_leg_rule = 'Y')
3245: THEN
3246: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Enhanced Retropay Rule Enabled ');
3247: pay_au_retro_upgrade.create_enhanced_retro_defn;
3248: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Enhanced Retropay Retro Definitions Created ');
3249: pay_au_retro_upgrade.set_enh_retro_request_group;
3250: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Request Group - programs for Enhanced Retropay added ');
3251: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Enhanced Retropay is enabled for the following Australian Business Groups :');
3252:

Line 3250: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Request Group - programs for Enhanced Retropay added ');

3246: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Enhanced Retropay Rule Enabled ');
3247: pay_au_retro_upgrade.create_enhanced_retro_defn;
3248: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Enhanced Retropay Retro Definitions Created ');
3249: pay_au_retro_upgrade.set_enh_retro_request_group;
3250: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Request Group - programs for Enhanced Retropay added ');
3251: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Enhanced Retropay is enabled for the following Australian Business Groups :');
3252:
3253: FOR i IN csr_get_business_group_name /*Bug 5879422 */
3254: LOOP

Line 3251: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Enhanced Retropay is enabled for the following Australian Business Groups :');

3247: pay_au_retro_upgrade.create_enhanced_retro_defn;
3248: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Enhanced Retropay Retro Definitions Created ');
3249: pay_au_retro_upgrade.set_enh_retro_request_group;
3250: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Request Group - programs for Enhanced Retropay added ');
3251: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Enhanced Retropay is enabled for the following Australian Business Groups :');
3252:
3253: FOR i IN csr_get_business_group_name /*Bug 5879422 */
3254: LOOP
3255: fnd_file.put_line(FND_FILE.LOG,' '||to_char(i.ROW_NUM)||') '||i.BUS_GROUP_NAME);

Line 3255: fnd_file.put_line(FND_FILE.LOG,' '||to_char(i.ROW_NUM)||') '||i.BUS_GROUP_NAME);

3251: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Enhanced Retropay is enabled for the following Australian Business Groups :');
3252:
3253: FOR i IN csr_get_business_group_name /*Bug 5879422 */
3254: LOOP
3255: fnd_file.put_line(FND_FILE.LOG,' '||to_char(i.ROW_NUM)||') '||i.BUS_GROUP_NAME);
3256: END LOOP; /*Bug 5879422 */
3257:
3258: fnd_file.put_line(FND_FILE.LOG,' WARNING: Customers who have enabled Enhanced Retro Pay should note that Retro Pay by Element should no longer be used and should be removed from all customer menus.');/*Bug 5879422 */
3259: ELSE

Line 3258: fnd_file.put_line(FND_FILE.LOG,' WARNING: Customers who have enabled Enhanced Retro Pay should note that Retro Pay by Element should no longer be used and should be removed from all customer menus.');/*Bug 5879422 */

3254: LOOP
3255: fnd_file.put_line(FND_FILE.LOG,' '||to_char(i.ROW_NUM)||') '||i.BUS_GROUP_NAME);
3256: END LOOP; /*Bug 5879422 */
3257:
3258: fnd_file.put_line(FND_FILE.LOG,' WARNING: Customers who have enabled Enhanced Retro Pay should note that Retro Pay by Element should no longer be used and should be removed from all customer menus.');/*Bug 5879422 */
3259: ELSE
3260: fnd_file.put_line(fnd_file.output,' MESSAGE: Enhanced Retropay Rule NOT Enabled ');
3261: END IF;
3262:

Line 3260: fnd_file.put_line(fnd_file.output,' MESSAGE: Enhanced Retropay Rule NOT Enabled ');

3256: END LOOP; /*Bug 5879422 */
3257:
3258: fnd_file.put_line(FND_FILE.LOG,' WARNING: Customers who have enabled Enhanced Retro Pay should note that Retro Pay by Element should no longer be used and should be removed from all customer menus.');/*Bug 5879422 */
3259: ELSE
3260: fnd_file.put_line(fnd_file.output,' MESSAGE: Enhanced Retropay Rule NOT Enabled ');
3261: END IF;
3262:
3263: END enable_au_enhanced_retro;
3264: