eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_OSP_QUERIES_PVT dependencies on FND_API

Line 35: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

31: -- Parameters :
32: --
33: -- Standard IN Parameters :
34: -- p_api_version IN NUMBER Required
35: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
36: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
37: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
38: -- p_module_type IN VARCHAR2 Default Null
39: -- Standard OUT Parameters :

Line 36: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

32: --
33: -- Standard IN Parameters :
34: -- p_api_version IN NUMBER Required
35: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
36: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
37: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
38: -- p_module_type IN VARCHAR2 Default Null
39: -- Standard OUT Parameters :
40: -- x_return_status OUT VARCHAR2 Required

Line 37: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

33: -- Standard IN Parameters :
34: -- p_api_version IN NUMBER Required
35: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
36: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
37: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
38: -- p_module_type IN VARCHAR2 Default Null
39: -- Standard OUT Parameters :
40: -- x_return_status OUT VARCHAR2 Required
41: -- x_msg_count OUT NUMBER Required

Line 136: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

132:
133: END IF;
134:
135: -- Standard call to check for call compatibility
136: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
137: G_PKG_NAME) THEN
138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139: END IF;
140:

Line 138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

134:
135: -- Standard call to check for call compatibility
136: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
137: G_PKG_NAME) THEN
138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139: END IF;
140:
141: -- Initialize message list if p_init_msg_list is set to TRUE
142: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 142: IF FND_API.To_Boolean(p_init_msg_list) THEN

138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139: END IF;
140:
141: -- Initialize message list if p_init_msg_list is set to TRUE
142: IF FND_API.To_Boolean(p_init_msg_list) THEN
143: FND_MSG_PUB.Initialize;
144: END IF;
145:
146: --Commented by mpothuku as this API is not being used. At a later point, need to consider removing the

Line 150: x_return_status := FND_API.G_RET_STS_SUCCESS;

146: --Commented by mpothuku as this API is not being used. At a later point, need to consider removing the
147: --declaration in Spec, Record Structure for Criteria and Rosetta
148: /*
149: -- Initialize API return status to success
150: x_return_status := FND_API.G_RET_STS_SUCCESS;
151:
152:
153: -- Begin build Query
154: l_sql_string := 'SELECT DISTINCT OSP.OSP_ORDER_ID ';

Line 362: WHEN FND_API.G_EXC_ERROR THEN

358: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'End Procedure');
359: END IF;
360: */
361: EXCEPTION
362: WHEN FND_API.G_EXC_ERROR THEN
363: --dbms_output.put_line('Excep 1 ');
364: x_return_status := FND_API.G_RET_STS_ERROR;
365: -- Rollback to Search_OSP_Pvt;
366: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 364: x_return_status := FND_API.G_RET_STS_ERROR;

360: */
361: EXCEPTION
362: WHEN FND_API.G_EXC_ERROR THEN
363: --dbms_output.put_line('Excep 1 ');
364: x_return_status := FND_API.G_RET_STS_ERROR;
365: -- Rollback to Search_OSP_Pvt;
366: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
367: p_data => x_msg_data,
368: p_encoded => fnd_api.g_false);

Line 368: p_encoded => fnd_api.g_false);

364: x_return_status := FND_API.G_RET_STS_ERROR;
365: -- Rollback to Search_OSP_Pvt;
366: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
367: p_data => x_msg_data,
368: p_encoded => fnd_api.g_false);
369:
370: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
371: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Exception: ' || x_msg_data);
372: END IF;

Line 374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

370: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
371: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Exception: ' || x_msg_data);
372: END IF;
373:
374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
375: -- dbms_output.put_line('Excep 2 ');
376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
377: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
378: p_data => x_msg_data,

Line 376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

372: END IF;
373:
374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
375: -- dbms_output.put_line('Excep 2 ');
376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
377: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
378: p_data => x_msg_data,
379: p_encoded => fnd_api.g_false);
380: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 379: p_encoded => fnd_api.g_false);

375: -- dbms_output.put_line('Excep 2 ');
376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
377: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
378: p_data => x_msg_data,
379: p_encoded => fnd_api.g_false);
380: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
381: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
382: END IF;
383:

Line 386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

382: END IF;
383:
384: WHEN OTHERS THEN
385: -- dbms_output.put_line('Excep 3 ');
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387: -- Rollback to Search_OSP_Pvt;
388: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
389: p_procedure_name => 'Search_OSP_Orders',
390: p_error_text => SQLERRM);

Line 394: p_encoded => fnd_api.g_false);

390: p_error_text => SQLERRM);
391:
392: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
393: p_data => x_msg_data,
394: p_encoded => fnd_api.g_false);
395:
396: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
397: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
398: END IF;

Line 420: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

416: -- Parameters :
417: --
418: -- Standard IN Parameters :
419: -- p_api_version IN NUMBER Required
420: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
421: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
422: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
423: -- p_module_type IN VARCHAR2 Default Null
424: -- Standard OUT Parameters :

Line 421: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

417: --
418: -- Standard IN Parameters :
419: -- p_api_version IN NUMBER Required
420: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
421: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
422: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
423: -- p_module_type IN VARCHAR2 Default Null
424: -- Standard OUT Parameters :
425: -- x_return_status OUT VARCHAR2 Required

Line 422: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

418: -- Standard IN Parameters :
419: -- p_api_version IN NUMBER Required
420: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
421: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
422: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
423: -- p_module_type IN VARCHAR2 Default Null
424: -- Standard OUT Parameters :
425: -- x_return_status OUT VARCHAR2 Required
426: -- x_msg_count OUT NUMBER Required

Line 509: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

505:
506: END IF;
507:
508: -- Standard call to check for call compatibility
509: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
510: G_PKG_NAME) THEN
511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
512: END IF;
513:

Line 511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

507:
508: -- Standard call to check for call compatibility
509: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
510: G_PKG_NAME) THEN
511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
512: END IF;
513:
514: -- Initialize message list if p_init_msg_list is set to TRUE
515: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 515: IF FND_API.To_Boolean(p_init_msg_list) THEN

511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
512: END IF;
513:
514: -- Initialize message list if p_init_msg_list is set to TRUE
515: IF FND_API.To_Boolean(p_init_msg_list) THEN
516: FND_MSG_PUB.Initialize;
517: END IF;
518:
519: --Commented by mpothuku as this API is not being used. At a later point, need to consider removing the

Line 523: x_return_status := FND_API.G_RET_STS_SUCCESS;

519: --Commented by mpothuku as this API is not being used. At a later point, need to consider removing the
520: --declaration in Spec, Record Structure for Criteria and Rosetta
521: /*
522: -- Initialize API return status to success
523: x_return_status := FND_API.G_RET_STS_SUCCESS;
524:
525: l_sql_string := 'SELECT WORKORDER_ID';
526: l_sql_string:= l_sql_string || ', JOB_NUMBER';
527: l_sql_string:= l_sql_string || ', WO_PART_NUMBER';

Line 672: WHEN FND_API.G_EXC_ERROR THEN

668: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'End Procedure');
669: END IF;
670: */
671: EXCEPTION
672: WHEN FND_API.G_EXC_ERROR THEN
673: --dbms_output.put_line('Excep 1 ');
674: x_return_status := FND_API.G_RET_STS_ERROR;
675: -- Rollback to Search_WO_pvt;
676: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 674: x_return_status := FND_API.G_RET_STS_ERROR;

670: */
671: EXCEPTION
672: WHEN FND_API.G_EXC_ERROR THEN
673: --dbms_output.put_line('Excep 1 ');
674: x_return_status := FND_API.G_RET_STS_ERROR;
675: -- Rollback to Search_WO_pvt;
676: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
677: p_data => x_msg_data,
678: p_encoded => fnd_api.g_false);

Line 678: p_encoded => fnd_api.g_false);

674: x_return_status := FND_API.G_RET_STS_ERROR;
675: -- Rollback to Search_WO_pvt;
676: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
677: p_data => x_msg_data,
678: p_encoded => fnd_api.g_false);
679:
680: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
681: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Exception: ' || x_msg_data);
682: END IF;

Line 684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

680: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
681: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Exception: ' || x_msg_data);
682: END IF;
683:
684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
685: -- dbms_output.put_line('Excep 2 ');
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
687: --Rollback to Search_WO_pvt;
688: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

682: END IF;
683:
684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
685: -- dbms_output.put_line('Excep 2 ');
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
687: --Rollback to Search_WO_pvt;
688: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
689: p_data => x_msg_data,
690: p_encoded => fnd_api.g_false);

Line 690: p_encoded => fnd_api.g_false);

686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
687: --Rollback to Search_WO_pvt;
688: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
689: p_data => x_msg_data,
690: p_encoded => fnd_api.g_false);
691:
692:
693: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
694: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);

Line 699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

695: END IF;
696:
697: WHEN OTHERS THEN
698: -- dbms_output.put_line('Excep 3 ');
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: --Rollback to Search_WO_pvt;
701: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
702: p_procedure_name => 'Search_WO',
703: p_error_text => SQLERRM);

Line 707: p_encoded => fnd_api.g_false);

703: p_error_text => SQLERRM);
704:
705: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
706: p_data => x_msg_data,
707: p_encoded => fnd_api.g_false);
708:
709: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
710: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
711: END IF;

Line 735: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

731: -- Parameters :
732: --
733: -- Standard IN Parameters :
734: -- p_api_version IN NUMBER Required
735: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
736: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
737: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
738: -- p_module_type IN VARCHAR2 Default Null
739: -- Standard OUT Parameters :

Line 736: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

732: --
733: -- Standard IN Parameters :
734: -- p_api_version IN NUMBER Required
735: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
736: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
737: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
738: -- p_module_type IN VARCHAR2 Default Null
739: -- Standard OUT Parameters :
740: -- x_return_status OUT VARCHAR2 Required

Line 737: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

733: -- Standard IN Parameters :
734: -- p_api_version IN NUMBER Required
735: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
736: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
737: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
738: -- p_module_type IN VARCHAR2 Default Null
739: -- Standard OUT Parameters :
740: -- x_return_status OUT VARCHAR2 Required
741: -- x_msg_count OUT NUMBER Required

Line 835: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

831: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
832: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
833: END IF;
834: -- Standard call to check for call compatibility
835: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
836: G_PKG_NAME) THEN
837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
838: END IF;
839:

Line 837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

833: END IF;
834: -- Standard call to check for call compatibility
835: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
836: G_PKG_NAME) THEN
837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
838: END IF;
839:
840: -- Initialize message list if p_init_msg_list is set to TRUE
841: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 841: IF FND_API.To_Boolean(p_init_msg_list) THEN

837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
838: END IF;
839:
840: -- Initialize message list if p_init_msg_list is set to TRUE
841: IF FND_API.To_Boolean(p_init_msg_list) THEN
842: FND_MSG_PUB.Initialize;
843: END IF;
844:
845: -- Initialize API return status to success

Line 846: x_return_status := FND_API.G_RET_STS_SUCCESS;

842: FND_MSG_PUB.Initialize;
843: END IF;
844:
845: -- Initialize API return status to success
846: x_return_status := FND_API.G_RET_STS_SUCCESS;
847:
848:
849:
850: IF (P_OSP_ID IS NOT NULL) THEN

Line 863: p_default => FND_API.G_TRUE,

859: p_api_version => p_api_version ,
860: p_init_msg_list => p_init_msg_list,
861: p_commit => p_commit,
862: p_validation_level => p_validation_level,
863: p_default => FND_API.G_TRUE,
864: p_module_type => p_module_type,
865: p_osp_order_id => P_OSP_ID,
866: x_po_header_id => l_po_header_id,
867: x_return_status => x_return_status,

Line 1038: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1034: END IF;
1035:
1036:
1037: -- Check return status.
1038: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1039: RAISE FND_API.G_EXC_ERROR;
1040: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1042: END IF;

Line 1039: RAISE FND_API.G_EXC_ERROR;

1035:
1036:
1037: -- Check return status.
1038: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1039: RAISE FND_API.G_EXC_ERROR;
1040: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1042: END IF;
1043:

Line 1040: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1036:
1037: -- Check return status.
1038: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1039: RAISE FND_API.G_EXC_ERROR;
1040: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1042: END IF;
1043:
1044: -- Standard check of p_commit

Line 1041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1037: -- Check return status.
1038: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1039: RAISE FND_API.G_EXC_ERROR;
1040: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1042: END IF;
1043:
1044: -- Standard check of p_commit
1045: /*IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 1045: /*IF FND_API.TO_BOOLEAN(p_commit) THEN

1041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1042: END IF;
1043:
1044: -- Standard check of p_commit
1045: /*IF FND_API.TO_BOOLEAN(p_commit) THEN
1046: COMMIT WORK;
1047: END IF;
1048: */
1049:

Line 1054: p_encoded => fnd_api.g_false

1050: -- Standard call to get message count and if count is 1, get message info
1051: FND_MSG_PUB.Count_And_Get
1052: ( p_count => x_msg_count,
1053: p_data => x_msg_data,
1054: p_encoded => fnd_api.g_false
1055: );
1056:
1057: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1058: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'End Procedure');

Line 1062: WHEN FND_API.G_EXC_ERROR THEN

1058: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'End Procedure');
1059: END IF;
1060:
1061: EXCEPTION
1062: WHEN FND_API.G_EXC_ERROR THEN
1063: --dbms_output.put_line('Excep 1 ');
1064: x_return_status := FND_API.G_RET_STS_ERROR;
1065: --Rollback to get_header_lines_pvt;
1066: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1064: x_return_status := FND_API.G_RET_STS_ERROR;

1060:
1061: EXCEPTION
1062: WHEN FND_API.G_EXC_ERROR THEN
1063: --dbms_output.put_line('Excep 1 ');
1064: x_return_status := FND_API.G_RET_STS_ERROR;
1065: --Rollback to get_header_lines_pvt;
1066: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1067: p_data => x_msg_data,
1068: p_encoded => fnd_api.g_false);

Line 1068: p_encoded => fnd_api.g_false);

1064: x_return_status := FND_API.G_RET_STS_ERROR;
1065: --Rollback to get_header_lines_pvt;
1066: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1067: p_data => x_msg_data,
1068: p_encoded => fnd_api.g_false);
1069: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1070: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Exception: ' || x_msg_data);
1071: END IF;
1072:

Line 1074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1070: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Exception: ' || x_msg_data);
1071: END IF;
1072:
1073:
1074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1075: -- dbms_output.put_line('Excep 2 ');
1076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1077: -- Rollback to get_header_lines_pvt;
1078: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1072:
1073:
1074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1075: -- dbms_output.put_line('Excep 2 ');
1076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1077: -- Rollback to get_header_lines_pvt;
1078: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1079: p_data => x_msg_data,
1080: p_encoded => fnd_api.g_false);

Line 1080: p_encoded => fnd_api.g_false);

1076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1077: -- Rollback to get_header_lines_pvt;
1078: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1079: p_data => x_msg_data,
1080: p_encoded => fnd_api.g_false);
1081: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1082: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
1083: END IF;
1084:

Line 1087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1083: END IF;
1084:
1085: WHEN OTHERS THEN
1086: --dbms_output.put_line('Excep 3 ');
1087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1088: -- Rollback to get_header_lines_pvt;
1089: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
1090: p_procedure_name => 'GET_HEADER_AND_LINES',
1091: p_error_text => SQLERRM);

Line 1095: p_encoded => fnd_api.g_false);

1091: p_error_text => SQLERRM);
1092:
1093: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1094: p_data => x_msg_data,
1095: p_encoded => fnd_api.g_false);
1096: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1097: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
1098: END IF;
1099: END Get_Header_And_Lines;

Line 1118: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

1114: -- Parameters :
1115: --
1116: -- Standard IN Parameters :
1117: -- p_api_version IN NUMBER Required
1118: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1119: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1120: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1121: -- p_module_type IN VARCHAR2 Default Null
1122: -- Standard OUT Parameters :

Line 1119: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

1115: --
1116: -- Standard IN Parameters :
1117: -- p_api_version IN NUMBER Required
1118: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1119: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1120: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1121: -- p_module_type IN VARCHAR2 Default Null
1122: -- Standard OUT Parameters :
1123: -- x_return_status OUT VARCHAR2 Required

Line 1120: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

1116: -- Standard IN Parameters :
1117: -- p_api_version IN NUMBER Required
1118: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1119: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1120: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1121: -- p_module_type IN VARCHAR2 Default Null
1122: -- Standard OUT Parameters :
1123: -- x_return_status OUT VARCHAR2 Required
1124: -- x_msg_count OUT NUMBER Required

Line 1228: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

1224:
1225: END IF;
1226:
1227: -- Standard call to check for call compatibility
1228: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1229: G_PKG_NAME) THEN
1230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1231: END IF;
1232:

Line 1230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1226:
1227: -- Standard call to check for call compatibility
1228: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1229: G_PKG_NAME) THEN
1230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1231: END IF;
1232:
1233: -- Initialize message list if p_init_msg_list is set to TRUE
1234: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 1234: IF FND_API.To_Boolean(p_init_msg_list) THEN

1230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1231: END IF;
1232:
1233: -- Initialize message list if p_init_msg_list is set to TRUE
1234: IF FND_API.To_Boolean(p_init_msg_list) THEN
1235: FND_MSG_PUB.Initialize;
1236: END IF;
1237:
1238: -- Initialize API return status to success

Line 1239: x_return_status := FND_API.G_RET_STS_SUCCESS;

1235: FND_MSG_PUB.Initialize;
1236: END IF;
1237:
1238: -- Initialize API return status to success
1239: x_return_status := FND_API.G_RET_STS_SUCCESS;
1240: IF(P_OSP_ID IS NOT NULL) THEN
1241: l_line_queries := 'SELECT OSP_ORDER_LINE_ID ';
1242: l_line_queries := l_line_queries ||', OBJECT_VERSION_NUMBER ';
1243: l_line_queries := l_line_queries ||', OSP_ORDER_ID ';

Line 1452: WHEN FND_API.G_EXC_ERROR THEN

1448: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'End Procedure');
1449: END IF;
1450:
1451: EXCEPTION
1452: WHEN FND_API.G_EXC_ERROR THEN
1453: --dbms_output.put_line('Excep 1 ');
1454: x_return_status := FND_API.G_RET_STS_ERROR;
1455: --Rollback to get_order_lines_pvt;
1456: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1454: x_return_status := FND_API.G_RET_STS_ERROR;

1450:
1451: EXCEPTION
1452: WHEN FND_API.G_EXC_ERROR THEN
1453: --dbms_output.put_line('Excep 1 ');
1454: x_return_status := FND_API.G_RET_STS_ERROR;
1455: --Rollback to get_order_lines_pvt;
1456: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1457: p_data => x_msg_data,
1458: p_encoded => fnd_api.g_false);

Line 1458: p_encoded => fnd_api.g_false);

1454: x_return_status := FND_API.G_RET_STS_ERROR;
1455: --Rollback to get_order_lines_pvt;
1456: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1457: p_data => x_msg_data,
1458: p_encoded => fnd_api.g_false);
1459: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1460: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Exception: ' || x_msg_data);
1461: END IF;
1462:

Line 1463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1459: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1460: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Exception: ' || x_msg_data);
1461: END IF;
1462:
1463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1464: --dbms_output.put_line('Excep 2 ');
1465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1466: --Rollback to get_order_lines_pvt;
1467: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1461: END IF;
1462:
1463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1464: --dbms_output.put_line('Excep 2 ');
1465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1466: --Rollback to get_order_lines_pvt;
1467: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1468: p_data => x_msg_data,
1469: p_encoded => fnd_api.g_false);

Line 1469: p_encoded => fnd_api.g_false);

1465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1466: --Rollback to get_order_lines_pvt;
1467: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1468: p_data => x_msg_data,
1469: p_encoded => fnd_api.g_false);
1470: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1471: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
1472: END IF;
1473:

Line 1476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1472: END IF;
1473:
1474: WHEN OTHERS THEN
1475: --dbms_output.put_line('Excep 3 ');
1476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1477: -- Rollback to get_order_lines_pvt;
1478: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
1479: p_procedure_name => 'GET_ORDER_LINES',
1480: p_error_text => SQLERRM);

Line 1484: p_encoded => fnd_api.g_false);

1480: p_error_text => SQLERRM);
1481:
1482: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1483: p_data => x_msg_data,
1484: p_encoded => fnd_api.g_false);
1485: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1486: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
1487: END IF;
1488: