[Home] [Help]
12: g_owner_type CONSTANT VARCHAR2(10) := 'PAYER';
13:
14: -------------------------------------------------------------------------------
15: /* UTILITY FUNCTION#2: ENCODE
16: NOTE: Encoding method was moved to the utility package iby_utility_pvt;
17: this now-wrapper function has not been completely removed b/c
18: it was defined in the spec file and so is public and thus
19: possibly used by existing customers
20: */
21: -------------------------------------------------------------------------------
22:
23: FUNCTION encode(s IN VARCHAR2) RETURN VARCHAR2 IS
24: BEGIN
25: RETURN iby_utility_pvt.encode64(s);
26: END encode;
27:
28: -------------------------------------------------------------------------------
29: /* UTILITY FUNCTION#3: DECODE
32: -------------------------------------------------------------------------------
33:
34: FUNCTION decode(s IN VARCHAR2) RETURN VARCHAR2 IS
35: BEGIN
36: RETURN iby_utility_pvt.decode64(s);
37: END decode;
38:
39:
40: -------------------------------------------------------------------------------
575: WHEN ERROR_FROM_SUBPROC THEN
576: --dbms_output.put_line('ERROR: ERROR_FROM_SUBPROC during call to API ');
577: --dbms_output.put_line('SQLerr is :'||substr(SQLERRM,1,150));
578: x_return_status := FND_API.G_RET_STS_ERROR;
579: iby_utility_pvt.handleException(SQLERRM,SQLCODE);
580: FND_MSG_PUB.Count_And_Get
581: ( p_count => x_msg_count,
582: p_data => x_msg_data
583: );
912: -- this exception is raised as long as the SQLCODE is -20000.
913: WHEN ERROR_FROM_SUBPROC THEN
914:
915: x_return_status := FND_API.G_RET_STS_ERROR;
916: iby_utility_pvt.handleException(SQLERRM,SQLCODE);
917: FND_MSG_PUB.Count_And_Get
918: ( p_count => x_msg_count,
919: p_data => x_msg_data
920: );
1073: -- this exception is raised as long as the SQLCODE is -20000.
1074: WHEN ERROR_FROM_SUBPROC THEN
1075:
1076: x_return_status := FND_API.G_RET_STS_ERROR;
1077: iby_utility_pvt.handleException(SQLERRM,SQLCODE);
1078: FND_MSG_PUB.Count_And_Get
1079: ( p_count => x_msg_count,
1080: p_data => x_msg_data
1081: );
1267:
1268: WHEN OTHERS THEN
1269:
1270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1271: iby_utility_pvt.handleException(SQLERRM,SQLCODE);
1272: FND_MSG_PUB.Count_And_Get
1273: ( p_count => x_msg_count,
1274: p_data => x_msg_data
1275: );
1496:
1497: WHEN OTHERS THEN
1498:
1499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1500: iby_utility_pvt.handleException(SQLERRM,SQLCODE);
1501: FND_MSG_PUB.Count_And_Get
1502: ( p_count => x_msg_count,
1503: p_data => x_msg_data
1504: );