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 513: p_return_status := fnd_api.G_RET_STS_SUCCESS;

509: getwfattr(l_item_type, l_item_key, C_PSS_TXID_WF_ATTRIBUTE, false);
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: );

Line 550: p_return_status := fnd_api.G_RET_STS_SUCCESS;

546: from dual;
547: p_transaction_id := to_char(l_transaction_id);
548: add2wf(l_item_type, l_item_key, C_PSS_TXID_WF_ATTRIBUTE, l_transaction_id);
549: p_msg_count := 0;
550: p_return_status := fnd_api.G_RET_STS_SUCCESS;
551: return;
552: end if;
553: --
554: -- Fetch the PPMs.

Line 675: p_return_status := fnd_api.G_RET_STS_SUCCESS;

671: close csr_ppms;
672: p_transaction_id := l_transaction_id;
673: add2wf(l_item_type, l_item_key, C_PSS_TXID_WF_ATTRIBUTE, l_transaction_id);
674: p_msg_count := 0;
675: p_return_status := fnd_api.G_RET_STS_SUCCESS;
676: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'EXIT:SUCCESS', 60);
677: return;
678: exception
679: when others then

Line 702: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

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

Line 1502: p_return_status := fnd_api.G_RET_STS_SUCCESS;

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

Line 2078: p_return_status := fnd_api.G_RET_STS_SUCCESS;

2074: end if;
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: );

Line 2097: p_return_status := fnd_api.G_RET_STS_ERROR;

2093: when others then
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: );

Line 2710: p_return_status := fnd_api.G_RET_STS_SUCCESS;

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

Line 2775: p_return_status := fnd_api.G_RET_STS_SUCCESS;

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

Line 2929: if l_return_status = fnd_api.G_RET_STS_SUCCESS then

2925: );
2926: --
2927: -- Save the PPM if there were no errors.
2928: --
2929: if l_return_status = fnd_api.G_RET_STS_SUCCESS then
2930: --
2931: -- Increment the logical priorities if this is a brand
2932: -- new PPM - it must be inserted at priority 1.
2933: --

Line 2959: if l_return_status = fnd_api.G_RET_STS_SUCCESS then

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
2960: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'EXIT:SUCCESS', 120);
2961: else
2962: pay_ppmv4_utils_ss.seterrorstage
2963: (l_proc, 'EXIT:VALIDATE_FAIL:' || l_return_status, 125);

Line 2973: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

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

Line 3059: p_return_status := fnd_api.G_RET_STS_ERROR;

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

Line 3120: p_return_status := fnd_api.G_RET_STS_SUCCESS;

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

Line 3138: p_return_status := fnd_api.G_RET_STS_ERROR;

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