DBA Data[Home] [Help]

APPS.OKC_XPRT_QUESTION_PVT dependencies on FND_API

Line 21: g_false CONSTANT VARCHAR2 (1) := fnd_api.g_false;

17: g_app_name CONSTANT VARCHAR2 (3) := okc_api.g_app_name;
18: ------------------------------------------------------------------------------
19: -- GLOBAL CONSTANTS
20: ------------------------------------------------------------------------------
21: g_false CONSTANT VARCHAR2 (1) := fnd_api.g_false;
22: g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;
23: g_ret_sts_success CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_success;
24: g_ret_sts_error CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_error;
25: g_ret_sts_unexp_error CONSTANT VARCHAR2 (1)

Line 22: g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;

18: ------------------------------------------------------------------------------
19: -- GLOBAL CONSTANTS
20: ------------------------------------------------------------------------------
21: g_false CONSTANT VARCHAR2 (1) := fnd_api.g_false;
22: g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;
23: g_ret_sts_success CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_success;
24: g_ret_sts_error CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_error;
25: g_ret_sts_unexp_error CONSTANT VARCHAR2 (1)
26: := fnd_api.g_ret_sts_unexp_error;

Line 23: g_ret_sts_success CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_success;

19: -- GLOBAL CONSTANTS
20: ------------------------------------------------------------------------------
21: g_false CONSTANT VARCHAR2 (1) := fnd_api.g_false;
22: g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;
23: g_ret_sts_success CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_success;
24: g_ret_sts_error CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_error;
25: g_ret_sts_unexp_error CONSTANT VARCHAR2 (1)
26: := fnd_api.g_ret_sts_unexp_error;
27: g_unexpected_error CONSTANT VARCHAR2 (200) := 'OKC_UNEXPECTED_ERROR';

Line 24: g_ret_sts_error CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_error;

20: ------------------------------------------------------------------------------
21: g_false CONSTANT VARCHAR2 (1) := fnd_api.g_false;
22: g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;
23: g_ret_sts_success CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_success;
24: g_ret_sts_error CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_error;
25: g_ret_sts_unexp_error CONSTANT VARCHAR2 (1)
26: := fnd_api.g_ret_sts_unexp_error;
27: g_unexpected_error CONSTANT VARCHAR2 (200) := 'OKC_UNEXPECTED_ERROR';
28: g_sqlerrm_token CONSTANT VARCHAR2 (200) := 'ERROR_MESSAGE';

Line 26: := fnd_api.g_ret_sts_unexp_error;

22: g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;
23: g_ret_sts_success CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_success;
24: g_ret_sts_error CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_error;
25: g_ret_sts_unexp_error CONSTANT VARCHAR2 (1)
26: := fnd_api.g_ret_sts_unexp_error;
27: g_unexpected_error CONSTANT VARCHAR2 (200) := 'OKC_UNEXPECTED_ERROR';
28: g_sqlerrm_token CONSTANT VARCHAR2 (200) := 'ERROR_MESSAGE';
29: g_sqlcode_token CONSTANT VARCHAR2 (200) := 'ERROR_CODE';
30: l_OKC_I_NOT_NULL VARCHAR2 (30) := 'OKC_I_NOT_NULL';

Line 740: l_message := fnd_msg_pub.get (i, p_encoded => fnd_api.g_false);

736:
737:
738: FOR i IN 1 .. fnd_msg_pub.count_msg
739: LOOP
740: l_message := fnd_msg_pub.get (i, p_encoded => fnd_api.g_false);
741:
742:
743: IF LENGTH (l_message) + LENGTH (Nvl(x_message,' ')) <= 2500
744: THEN

Line 783: l_message := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);

779: p_token1 => 'PROCEDURE',
780: p_token1_value => p_process
781: );
782:
783: l_message := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);
784: l_message := l_message || fnd_msg_pub.get (2, p_encoded => fnd_api.g_false);
785:
786: x_message := x_message ||' '||l_message;
787:

Line 784: l_message := l_message || fnd_msg_pub.get (2, p_encoded => fnd_api.g_false);

780: p_token1_value => p_process
781: );
782:
783: l_message := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);
784: l_message := l_message || fnd_msg_pub.get (2, p_encoded => fnd_api.g_false);
785:
786: x_message := x_message ||' '||l_message;
787:
788:

Line 798: p_commit IN VARCHAR2 := FND_API.G_FALSE,

794: END read_message;
795:
796: PROCEDURE create_question (
797: p_xprt_question_rec IN OUT NOCOPY xprt_qn_const_rec_type,
798: p_commit IN VARCHAR2 := FND_API.G_FALSE,
799: x_return_status OUT NOCOPY VARCHAR2,
800: x_msg_data OUT NOCOPY VARCHAR2
801: )
802: IS

Line 902: IF FND_API.To_Boolean( p_commit ) THEN

898: ROLLBACK TO create_question_sp;
899: RETURN;
900: END IF;
901:
902: IF FND_API.To_Boolean( p_commit ) THEN
903: COMMIT ;
904: END IF;
905:
906: EXCEPTION

Line 920: p_commit IN VARCHAR2 := FND_API.G_FALSE,

916: );
917: END create_question;
918:
919: PROCEDURE update_question(p_xprt_update_question_rec IN OUT NOCOPY xprt_qn_const_rec_type,
920: p_commit IN VARCHAR2 := FND_API.G_FALSE,
921: x_return_status OUT NOCOPY VARCHAR2,
922: x_msg_data OUT NOCOPY VARCHAR2) IS
923:
924: l_update_flag VARCHAR2(1);

Line 1007: x_msg_data := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);

1003: p_msg_name => l_okc_i_invalid_value,
1004: p_token1 => l_field,
1005: p_token1_value => 'QUESTION_ID'
1006: );
1007: x_msg_data := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);
1008: FND_MSG_PUB.initialize;
1009: RETURN;
1010:
1011: WHEN OTHERS THEN

Line 1020: x_msg_data := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);

1016: p_token1 => G_SQLCODE_TOKEN,
1017: p_token1_value => sqlcode,
1018: p_token2 => G_SQLERRM_TOKEN,
1019: p_token2_value => sqlerrm);
1020: x_msg_data := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);
1021: FND_MSG_PUB.initialize;
1022: RETURN;
1023: END;
1024:

Line 1035: x_msg_data := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);

1031: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1032: p_msg_name => 'OKC_I_NO_CHANGE',
1033: p_token1 => 'FIELD',
1034: p_token1_value => 'QUESTION_TYPE' );
1035: x_msg_data := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);
1036: FND_MSG_PUB.initialize;
1037: RETURN;
1038: END IF;
1039:

Line 1258: IF FND_API.To_Boolean( p_commit ) THEN

1254: AND LANGUAGE = p_xprt_update_question_rec.lang;
1255:
1256: x_return_status := G_RET_STS_SUCCESS;
1257:
1258: IF FND_API.To_Boolean( p_commit ) THEN
1259: COMMIT ;
1260: END IF;
1261:
1262: EXCEPTION

Line 1273: x_msg_data := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);

1269: p_token1_value => sqlcode,
1270: p_token2 => G_SQLERRM_TOKEN,
1271: p_token2_value => sqlerrm);
1272:
1273: x_msg_data := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);
1274: ROLLBACK TO update_question_sp;
1275: END update_question;
1276: END okc_xprt_question_pvt;