DBA Data[Home] [Help]

APPS.PAY_PPMV4_SS dependencies on FND_MSG_PUB

Line 90: fnd_msg_pub.initialize;

86: l_force boolean;
87: l_success boolean;
88: begin
89: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'ENTER', 0);
90: fnd_msg_pub.initialize;
91: --
92: -- Rollback any existing HR transaction table data.
93: --
94: hr_transaction_ss.rollback_transaction

Line 143: fnd_msg_pub.add;

139: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'EXIT:FAIL:1', 25);
140: fnd_message.set_name('PAY', 'PAY_51518_PSS_ASSERT_ERROR');
141: fnd_message.set_token('WHERE', l_proc);
142: fnd_message.set_token('ADDITIONAL_INFO', '');
143: fnd_msg_pub.add;
144: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
145: fnd_msg_pub.count_and_get
146: (p_count => p_msg_count
147: ,p_data => p_msg_data

Line 145: fnd_msg_pub.count_and_get

141: fnd_message.set_token('WHERE', l_proc);
142: fnd_message.set_token('ADDITIONAL_INFO', '');
143: fnd_msg_pub.add;
144: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
145: fnd_msg_pub.count_and_get
146: (p_count => p_msg_count
147: ,p_data => p_msg_data
148: );
149: return;

Line 182: fnd_msg_pub.add;

178: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'EXIT:FAIL:2', 50);
179: fnd_message.set_name('PAY', 'PAY_51518_PSS_ASSERT_ERROR');
180: fnd_message.set_token('WHERE', l_proc);
181: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
182: fnd_msg_pub.add;
183: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
184: fnd_msg_pub.count_and_get
185: (p_count => p_msg_count
186: ,p_data => p_msg_data

Line 184: fnd_msg_pub.count_and_get

180: fnd_message.set_token('WHERE', l_proc);
181: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
182: fnd_msg_pub.add;
183: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
184: fnd_msg_pub.count_and_get
185: (p_count => p_msg_count
186: ,p_data => p_msg_data
187: );
188: return;

Line 498: fnd_msg_pub.initialize;

494:
495: savepoint db2tts;
496: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'ENTER', 0);
497: --
498: fnd_msg_pub.initialize;
499: -------------------------------------------------------------------
500: -- Check if this routine has been called before and use workflow --
501: -- item attributes to return the values. --
502: -------------------------------------------------------------------

Line 514: fnd_msg_pub.count_and_get

510: --
511: -- Set successful return status.
512: --
513: p_return_status := fnd_api.G_RET_STS_SUCCESS;
514: fnd_msg_pub.count_and_get
515: (p_count => p_msg_count
516: ,p_data => p_msg_data
517: );
518: return;

Line 703: fnd_msg_pub.initialize;

699: -- Set up messages to Oracle Applications API standards as these
700: -- are handled "for free" using checkErrors.
701: --
702: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
703: fnd_msg_pub.initialize;
704: fnd_message.set_name('PAY', 'PAY_51518_PSS_ASSERT_ERROR');
705: fnd_message.set_token('WHERE', l_proc);
706: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
707: fnd_msg_pub.add;

Line 707: fnd_msg_pub.add;

703: fnd_msg_pub.initialize;
704: fnd_message.set_name('PAY', 'PAY_51518_PSS_ASSERT_ERROR');
705: fnd_message.set_token('WHERE', l_proc);
706: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
707: fnd_msg_pub.add;
708: fnd_msg_pub.count_and_get
709: (p_count => p_msg_count
710: ,p_data => p_msg_data
711: );

Line 708: fnd_msg_pub.count_and_get

704: fnd_message.set_name('PAY', 'PAY_51518_PSS_ASSERT_ERROR');
705: fnd_message.set_token('WHERE', l_proc);
706: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
707: fnd_msg_pub.add;
708: fnd_msg_pub.count_and_get
709: (p_count => p_msg_count
710: ,p_data => p_msg_data
711: );
712: return;

Line 894: fnd_msg_pub.add;

890: execute immediate l_sql_stat into l_opmid;
891: exception
892: when others then
893: fnd_message.set_name('PER', 'PAY_34069_NO_PAY_METHOD');
894: fnd_msg_pub.add;
895: fnd_message.raise_error;
896: end;
897: --
898: open csr_opms(p_assignment_id,p_effective_date,l_category,l_opmid);

Line 903: fnd_msg_pub.add;

899: fetch csr_opms into l_opmid;
900: if csr_opms%notfound then
901: close csr_opms;
902: fnd_message.set_name('PER', 'PAY_34069_NO_PAY_METHOD');
903: fnd_msg_pub.add;
904: fnd_message.raise_error;
905: end if;
906: close csr_opms;
907: --

Line 959: fnd_msg_pub.add;

955: -- Output error message.
956: --
957: if not l_cash_found and not l_check_found and not l_deposit_found then
958: fnd_message.set_name('PER', 'PAY_52626_NO_PAYMENT_TYPES');
959: fnd_msg_pub.add;
960: fnd_message.raise_error;
961: end if;
962: --
963:

Line 1174: fnd_msg_pub.add;

1170: end if;
1171: fnd_message.set_name('PAY', 'PAY_50405_PSS_CFG_PROC_ERROR');
1172: fnd_message.set_token('STAGE', 'GET_OPMS');
1173: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
1174: fnd_msg_pub.add;
1175: fnd_message.raise_error;
1176: end;
1177: --
1178: -- Output error message.

Line 1182: fnd_msg_pub.add;

1178: -- Output error message.
1179: --
1180: if not l_cash_found and not l_check_found and not l_deposit_found then
1181: fnd_message.set_name('PER', 'PAY_52626_NO_PAYMENT_TYPES');
1182: fnd_msg_pub.add;
1183: fnd_message.raise_error;
1184: end if;
1185: end getopms;
1186:

Line 1440: fnd_msg_pub.add;

1436: begin
1437: fnd_message.set_name('PAY', 'PAY_50405_PSS_CFG_PROC_ERROR');
1438: fnd_message.set_token('STAGE', p_stage);
1439: fnd_message.set_token('ADDITIONAL_INFO', p_additional_info);
1440: fnd_msg_pub.add;
1441: fnd_message.raise_error;
1442: end initialerror;
1443: begin
1444: --

Line 1450: fnd_msg_pub.initialize;

1446: --
1447: l_show_paymthd_lov := null;
1448:
1449:
1450: fnd_msg_pub.initialize;
1451: -------------------------------------------------------------------
1452: -- Check if this routine has been called before and use workflow --
1453: -- item attributes to return the values. --
1454: -------------------------------------------------------------------

Line 1503: fnd_msg_pub.count_and_get

1499: --
1500: -- Set successful return status.
1501: --
1502: p_return_status := fnd_api.G_RET_STS_SUCCESS;
1503: fnd_msg_pub.count_and_get
1504: (p_count => p_msg_count
1505: ,p_data => p_msg_data
1506: );
1507: return;

Line 1934: fnd_msg_pub.add;

1930: end if;
1931: --
1932: if l_payment_types is null then
1933: fnd_message.set_name('PER', 'PAY_52626_NO_PAYMENT_TYPES');
1934: fnd_msg_pub.add;
1935: fnd_message.raise_error;
1936: end if;
1937: p_payment_types := l_payment_types;
1938: p_deposit_opmid := to_char(l_deposit_opmid);

Line 2040: fnd_msg_pub.add;

2036: fetch csr_future_ppms into l_option_value;
2037: if csr_future_ppms%found then
2038: close csr_future_ppms;
2039: fnd_message.set_name('PER', 'PAY_52622_FUTURE_PAYMENTS');
2040: fnd_msg_pub.add;
2041: fnd_message.raise_error;
2042: end if;
2043: close csr_future_ppms;
2044: --

Line 2057: fnd_msg_pub.add;

2053: fetch csr_monetary into l_option_value;
2054: if csr_monetary%found then
2055: close csr_monetary;
2056: fnd_message.set_name('PER', 'PAY_52625_PPM_USES_AMOUNT');
2057: fnd_msg_pub.add;
2058: fnd_message.raise_error;
2059: end if;
2060: close csr_monetary;
2061: elsif l_monetary_only then

Line 2070: fnd_msg_pub.add;

2066: fetch csr_percentage into l_option_value;
2067: if csr_percentage%found then
2068: close csr_percentage;
2069: fnd_message.set_name('PER', 'PAY_52624_PPM_USES_PERCENTAGE');
2070: fnd_msg_pub.add;
2071: fnd_message.raise_error;
2072: end if;
2073: close csr_percentage;
2074: end if;

Line 2079: fnd_msg_pub.count_and_get

2075: --
2076: -- Set up success status.
2077: --
2078: p_return_status := fnd_api.G_RET_STS_SUCCESS;
2079: fnd_msg_pub.count_and_get
2080: (p_count => p_msg_count
2081: ,p_data => p_msg_data
2082: );
2083: return;

Line 2087: fnd_msg_pub.add;

2083: return;
2084: <>
2085: fnd_message.set_name('PER', 'PAY_52631_PPMSS_OPTION_ERROR');
2086: fnd_message.set_token('OPTION', l_option);
2087: fnd_msg_pub.add;
2088: fnd_message.raise_error;
2089: exception
2090: --
2091: -- Set up the error status.

Line 2098: fnd_msg_pub.count_and_get

2094: --
2095: -- Errors should have already been added.
2096: --
2097: p_return_status := fnd_api.G_RET_STS_ERROR;
2098: fnd_msg_pub.count_and_get
2099: (p_count => l_msg_count
2100: ,p_data => p_msg_data
2101: );
2102: if l_msg_count = 0 then

Line 2106: fnd_msg_pub.add;

2102: if l_msg_count = 0 then
2103: fnd_message.set_name('PAY', 'PAY_50405_PSS_CFG_PROC_ERROR');
2104: fnd_message.set_token('STAGE', 'UNEXPECTED_ERROR');
2105: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
2106: fnd_msg_pub.add;
2107: fnd_msg_pub.count_and_get
2108: (p_count => l_msg_count
2109: ,p_data => p_msg_data
2110: );

Line 2107: fnd_msg_pub.count_and_get

2103: fnd_message.set_name('PAY', 'PAY_50405_PSS_CFG_PROC_ERROR');
2104: fnd_message.set_token('STAGE', 'UNEXPECTED_ERROR');
2105: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
2106: fnd_msg_pub.add;
2107: fnd_msg_pub.count_and_get
2108: (p_count => l_msg_count
2109: ,p_data => p_msg_data
2110: );
2111: end if;

Line 2640: fnd_msg_pub.initialize;

2636: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'ENTER', 0);
2637: --
2638: -- Initialise the AOL message tables.
2639: --
2640: fnd_msg_pub.initialize;
2641: --
2642: -- Write to a t_ppmv4 structure.
2643: --
2644:

Line 2711: fnd_msg_pub.count_and_get

2707: -- Set up messages to Oracle Applications API standards as these
2708: -- are handled "for free" using checkErrors.
2709: --
2710: p_return_status := fnd_api.G_RET_STS_SUCCESS;
2711: fnd_msg_pub.count_and_get
2712: (p_count => p_msg_count
2713: ,p_data => p_msg_data
2714: );
2715: return;

Line 2776: fnd_msg_pub.count_and_get

2772: -- Set up messages to Oracle Applications API standards as these
2773: -- are handled "for free" using checkErrors().
2774: --
2775: p_return_status := fnd_api.G_RET_STS_SUCCESS;
2776: fnd_msg_pub.count_and_get
2777: (p_count => p_msg_count
2778: ,p_data => p_msg_data
2779: );
2780: return;

Line 2955: fnd_msg_pub.count_and_get

2951: -- Set up messages to Oracle Applications API standards as these
2952: -- are handled "for free" using checkErrors().
2953: --
2954: p_return_status := l_return_status;
2955: fnd_msg_pub.count_and_get
2956: (p_count => p_msg_count
2957: ,p_data => p_msg_data
2958: );
2959: if l_return_status = fnd_api.G_RET_STS_SUCCESS then

Line 2974: fnd_msg_pub.add_exc_msg

2970: -- Set up messages to Oracle Applications API standards as these
2971: -- are handled "for free" using checkErrors().
2972: --
2973: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
2974: fnd_msg_pub.add_exc_msg
2975: (p_pkg_name => g_package
2976: ,p_procedure_name => 'enter_ppm'
2977: );
2978: fnd_msg_pub.count_and_get

Line 2978: fnd_msg_pub.count_and_get

2974: fnd_msg_pub.add_exc_msg
2975: (p_pkg_name => g_package
2976: ,p_procedure_name => 'enter_ppm'
2977: );
2978: fnd_msg_pub.count_and_get
2979: (p_count => p_msg_count
2980: ,p_data => p_msg_data
2981: );
2982: return;

Line 3002: fnd_msg_pub.initialize;

2998: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'ENTER', 0);
2999: --
3000: -- Initialise the AOL message tables.
3001: --
3002: fnd_msg_pub.initialize;
3003: --
3004: -- Get additional information about this PPM.
3005: --
3006: select p.state

Line 3058: fnd_msg_pub.add;

3054: -- a) Prepayments exist.
3055: -- b) 3rd Party Payroll interface does not allow zap deletes.
3056: --
3057: fnd_message.set_name('PAY', 'PAY_51519_PSS_CANNOT_DELETE');
3058: fnd_msg_pub.add;
3059: p_return_status := fnd_api.G_RET_STS_ERROR;
3060: fnd_msg_pub.count_and_get
3061: (p_count => p_msg_count
3062: ,p_data => p_msg_data

Line 3060: fnd_msg_pub.count_and_get

3056: --
3057: fnd_message.set_name('PAY', 'PAY_51519_PSS_CANNOT_DELETE');
3058: fnd_msg_pub.add;
3059: p_return_status := fnd_api.G_RET_STS_ERROR;
3060: fnd_msg_pub.count_and_get
3061: (p_count => p_msg_count
3062: ,p_data => p_msg_data
3063: );
3064: return;

Line 3121: fnd_msg_pub.count_and_get

3117: -- Set up messages to Oracle Applications API standards as these
3118: -- are handled "for free" using checkErrors().
3119: --
3120: p_return_status := fnd_api.G_RET_STS_SUCCESS;
3121: fnd_msg_pub.count_and_get
3122: (p_count => p_msg_count
3123: ,p_data => p_msg_data
3124: );
3125: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'EXIT:SUCCESS', 45);

Line 3137: fnd_msg_pub.add;

3133: --
3134: fnd_message.set_name('PAY', 'PAY_51518_PSS_ASSERT_ERROR');
3135: fnd_message.set_token('WHERE', l_proc);
3136: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
3137: fnd_msg_pub.add;
3138: p_return_status := fnd_api.G_RET_STS_ERROR;
3139: fnd_msg_pub.count_and_get
3140: (p_count => p_msg_count
3141: ,p_data => p_msg_data

Line 3139: fnd_msg_pub.count_and_get

3135: fnd_message.set_token('WHERE', l_proc);
3136: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
3137: fnd_msg_pub.add;
3138: p_return_status := fnd_api.G_RET_STS_ERROR;
3139: fnd_msg_pub.count_and_get
3140: (p_count => p_msg_count
3141: ,p_data => p_msg_data
3142: );
3143: return;