DBA Data[Home] [Help]

APPS.PAY_PPMV4_SS dependencies on FND_API

Line 144: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

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
148: );

Line 173: p_return_status := fnd_api.G_RET_STS_SUCCESS;

169: );
170: end loop;
171: commit;
172: end if;
173: p_return_status := fnd_api.G_RET_STS_SUCCESS;
174: p_msg_count := 0;
175: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'EXIT:SUCCESS', 40);
176: exception
177: when others then

Line 183: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

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
187: );

Line 582: p_return_status := fnd_api.G_RET_STS_SUCCESS;

578: getwfattr(l_item_type, l_item_key, C_PSS_TXID_WF_ATTRIBUTE, false);
579: --
580: -- Set successful return status.
581: --
582: p_return_status := fnd_api.G_RET_STS_SUCCESS;
583: fnd_msg_pub.count_and_get
584: (p_count => p_msg_count
585: ,p_data => p_msg_data
586: );

Line 619: p_return_status := fnd_api.G_RET_STS_SUCCESS;

615: from dual;
616: p_transaction_id := to_char(l_transaction_id);
617: add2wf(l_item_type, l_item_key, C_PSS_TXID_WF_ATTRIBUTE, l_transaction_id);
618: p_msg_count := 0;
619: p_return_status := fnd_api.G_RET_STS_SUCCESS;
620: return;
621: end if;
622: --
623: -- Fetch the PPMs.

Line 744: p_return_status := fnd_api.G_RET_STS_SUCCESS;

740: close csr_ppms;
741: p_transaction_id := l_transaction_id;
742: add2wf(l_item_type, l_item_key, C_PSS_TXID_WF_ATTRIBUTE, l_transaction_id);
743: p_msg_count := 0;
744: p_return_status := fnd_api.G_RET_STS_SUCCESS;
745: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'EXIT:SUCCESS', 60);
746: return;
747: exception
748: when others then

Line 771: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

767: --
768: -- Set up messages to Oracle Applications API standards as these
769: -- are handled "for free" using checkErrors.
770: --
771: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
772: fnd_msg_pub.initialize;
773: fnd_message.set_name('PAY', 'PAY_51518_PSS_ASSERT_ERROR');
774: fnd_message.set_token('WHERE', l_proc);
775: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);

Line 1577: p_return_status := fnd_api.G_RET_STS_SUCCESS;

1573:
1574: --
1575: -- Set successful return status.
1576: --
1577: p_return_status := fnd_api.G_RET_STS_SUCCESS;
1578: fnd_msg_pub.count_and_get
1579: (p_count => p_msg_count
1580: ,p_data => p_msg_data
1581: );

Line 2153: p_return_status := fnd_api.G_RET_STS_SUCCESS;

2149: end if;
2150: --
2151: -- Set up success status.
2152: --
2153: p_return_status := fnd_api.G_RET_STS_SUCCESS;
2154: fnd_msg_pub.count_and_get
2155: (p_count => p_msg_count
2156: ,p_data => p_msg_data
2157: );

Line 2172: p_return_status := fnd_api.G_RET_STS_ERROR;

2168: when others then
2169: --
2170: -- Errors should have already been added.
2171: --
2172: p_return_status := fnd_api.G_RET_STS_ERROR;
2173: fnd_msg_pub.count_and_get
2174: (p_count => l_msg_count
2175: ,p_data => p_msg_data
2176: );

Line 2872: p_return_status := fnd_api.G_RET_STS_SUCCESS;

2868: --
2869: -- Set up messages to Oracle Applications API standards as these
2870: -- are handled "for free" using checkErrors.
2871: --
2872: p_return_status := fnd_api.G_RET_STS_SUCCESS;
2873: fnd_msg_pub.count_and_get
2874: (p_count => p_msg_count
2875: ,p_data => p_msg_data
2876: );

Line 2969: p_return_status := fnd_api.G_RET_STS_SUCCESS;

2965: --
2966: -- Set up messages to Oracle Applications API standards as these
2967: -- are handled "for free" using checkErrors().
2968: --
2969: p_return_status := fnd_api.G_RET_STS_SUCCESS;
2970: fnd_msg_pub.count_and_get
2971: (p_count => p_msg_count
2972: ,p_data => p_msg_data
2973: );

Line 3154: if l_return_status = fnd_api.G_RET_STS_SUCCESS then

3150: );
3151: --
3152: -- Save the PPM if there were no errors.
3153: --
3154: if l_return_status = fnd_api.G_RET_STS_SUCCESS then
3155: --
3156: -- Increment the logical priorities if this is a brand
3157: -- new PPM - it must be inserted at priority 1.
3158: --

Line 3184: if l_return_status = fnd_api.G_RET_STS_SUCCESS then

3180: fnd_msg_pub.count_and_get
3181: (p_count => p_msg_count
3182: ,p_data => p_msg_data
3183: );
3184: if l_return_status = fnd_api.G_RET_STS_SUCCESS then
3185: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'EXIT:SUCCESS', 120);
3186: else
3187: pay_ppmv4_utils_ss.seterrorstage
3188: (l_proc, 'EXIT:VALIDATE_FAIL:' || l_return_status, 125);

Line 3198: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

3194: --
3195: -- Set up messages to Oracle Applications API standards as these
3196: -- are handled "for free" using checkErrors().
3197: --
3198: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
3199: fnd_msg_pub.add_exc_msg
3200: (p_pkg_name => g_package
3201: ,p_procedure_name => 'enter_ppm'
3202: );

Line 3284: p_return_status := fnd_api.G_RET_STS_ERROR;

3280: -- b) 3rd Party Payroll interface does not allow zap deletes.
3281: --
3282: fnd_message.set_name('PAY', 'PAY_51519_PSS_CANNOT_DELETE');
3283: fnd_msg_pub.add;
3284: p_return_status := fnd_api.G_RET_STS_ERROR;
3285: fnd_msg_pub.count_and_get
3286: (p_count => p_msg_count
3287: ,p_data => p_msg_data
3288: );

Line 3378: p_return_status := fnd_api.G_RET_STS_SUCCESS;

3374: --
3375: -- Set up messages to Oracle Applications API standards as these
3376: -- are handled "for free" using checkErrors().
3377: --
3378: p_return_status := fnd_api.G_RET_STS_SUCCESS;
3379: fnd_msg_pub.count_and_get
3380: (p_count => p_msg_count
3381: ,p_data => p_msg_data
3382: );

Line 3396: p_return_status := fnd_api.G_RET_STS_ERROR;

3392: fnd_message.set_name('PAY', 'PAY_51518_PSS_ASSERT_ERROR');
3393: fnd_message.set_token('WHERE', l_proc);
3394: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
3395: fnd_msg_pub.add;
3396: p_return_status := fnd_api.G_RET_STS_ERROR;
3397: fnd_msg_pub.count_and_get
3398: (p_count => p_msg_count
3399: ,p_data => p_msg_data
3400: );