DBA Data[Home] [Help]

APPS.GMO_DISPENSE_SETUP_PVT dependencies on FND_API

Line 187: P_INIT_MSG_LIST => FND_API.G_FALSE,

183: --Call the API to create a definition context.
184: GMO_INSTRUCTION_GRP.CREATE_DEFN_CONTEXT
185: (
186: P_API_VERSION => 1.0,
187: P_INIT_MSG_LIST => FND_API.G_FALSE,
188: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_NONE,
189: P_ENTITY_NAME => L_ENTITY_NAME,
190: P_ENTITY_KEY => L_ENTITY_KEY,
191: P_ENTITY_DISPLAYNAME => L_ENTITY_DISPLAYNAME,

Line 188: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_NONE,

184: GMO_INSTRUCTION_GRP.CREATE_DEFN_CONTEXT
185: (
186: P_API_VERSION => 1.0,
187: P_INIT_MSG_LIST => FND_API.G_FALSE,
188: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_NONE,
189: P_ENTITY_NAME => L_ENTITY_NAME,
190: P_ENTITY_KEY => L_ENTITY_KEY,
191: P_ENTITY_DISPLAYNAME => L_ENTITY_DISPLAYNAME,
192: P_INSTRUCTION_TYPE => P_INSTRUCTION_TYPE,

Line 203: IF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR OR L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

199: X_MSG_DATA => L_MSG_DATA
200: );
201:
202: --If the return status is not success then raise an exception.
203: IF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR OR L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
204: RAISE CREATE_ERROR;
205: END IF;
206:
207: EXCEPTION

Line 303: P_INIT_MSG_LIST => FND_API.G_FALSE,

299: --Call the API to update the context parameters of the existing definition context.
300: GMO_INSTRUCTION_GRP.CREATE_DEFN_CONTEXT
301: (
302: P_API_VERSION => 1.0,
303: P_INIT_MSG_LIST => FND_API.G_FALSE,
304: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_NONE,
305: P_CURR_INSTR_PROCESS_ID => P_INSTRUCTION_PROCESS_ID,
306: P_ENTITY_NAME => L_ENTITY_NAME,
307: P_ENTITY_KEY => L_ENTITY_KEY,

Line 304: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_NONE,

300: GMO_INSTRUCTION_GRP.CREATE_DEFN_CONTEXT
301: (
302: P_API_VERSION => 1.0,
303: P_INIT_MSG_LIST => FND_API.G_FALSE,
304: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_NONE,
305: P_CURR_INSTR_PROCESS_ID => P_INSTRUCTION_PROCESS_ID,
306: P_ENTITY_NAME => L_ENTITY_NAME,
307: P_ENTITY_KEY => L_ENTITY_KEY,
308: P_ENTITY_DISPLAYNAME => L_ENTITY_DISPLAYNAME,

Line 319: IF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR OR L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

315: X_MSG_DATA => L_MSG_DATA
316: );
317:
318: --If the return status is not success then raise an exception.
319: IF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR OR L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
320: RAISE UPDATE_ERROR;
321: END IF;
322:
323: EXCEPTION

Line 388: P_INIT_MSG_LIST => FND_API.G_FALSE,

384: --Call the PL/SQL API to fetch the instruction set details in XML format for the specified
385: --process ID.
386: GMO_INSTRUCTION_GRP.GET_INSTR_XML
387: (P_API_VERSION => 1.0,
388: P_INIT_MSG_LIST => FND_API.G_FALSE,
389: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_NONE,
390: P_INSTRUCTION_PROCESS_ID => P_INSTR_PROCESS_ID,
391: X_OUTPUT_XML => L_INSTR_XML,
392: X_RETURN_STATUS => L_RETURN_STATUS,

Line 389: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_NONE,

385: --process ID.
386: GMO_INSTRUCTION_GRP.GET_INSTR_XML
387: (P_API_VERSION => 1.0,
388: P_INIT_MSG_LIST => FND_API.G_FALSE,
389: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_NONE,
390: P_INSTRUCTION_PROCESS_ID => P_INSTR_PROCESS_ID,
391: X_OUTPUT_XML => L_INSTR_XML,
392: X_RETURN_STATUS => L_RETURN_STATUS,
393: X_MSG_COUNT => L_MSG_COUNT,

Line 397: IF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR OR L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

393: X_MSG_COUNT => L_MSG_COUNT,
394: X_MSG_DATA => L_MSG_DATA);
395:
396: --If the return status is not success then raise an error.
397: IF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR OR L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
398: RAISE XML_ERROR;
399: END IF;
400:
401: --Append the XML of instruction set details to the final XML.

Line 478: P_INIT_MSG_LIST => FND_API.G_TRUE,

474: --Create a definition from definition for each instruction type.
475: GMO_INSTRUCTION_GRP.CREATE_DEFN_FROM_DEFN
476: (
477: P_API_VERSION => 1.0,
478: P_INIT_MSG_LIST => FND_API.G_TRUE,
479: P_COMMIT => FND_API.G_FALSE,
480: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_NONE,
481: P_SOURCE_ENTITY_NAME => P_ENTITY_NAME,
482: P_SOURCE_ENTITY_KEY => P_SOURCE_ENTITY_KEY,

Line 479: P_COMMIT => FND_API.G_FALSE,

475: GMO_INSTRUCTION_GRP.CREATE_DEFN_FROM_DEFN
476: (
477: P_API_VERSION => 1.0,
478: P_INIT_MSG_LIST => FND_API.G_TRUE,
479: P_COMMIT => FND_API.G_FALSE,
480: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_NONE,
481: P_SOURCE_ENTITY_NAME => P_ENTITY_NAME,
482: P_SOURCE_ENTITY_KEY => P_SOURCE_ENTITY_KEY,
483: P_TARGET_ENTITY_NAME => P_ENTITY_NAME,

Line 480: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_NONE,

476: (
477: P_API_VERSION => 1.0,
478: P_INIT_MSG_LIST => FND_API.G_TRUE,
479: P_COMMIT => FND_API.G_FALSE,
480: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_NONE,
481: P_SOURCE_ENTITY_NAME => P_ENTITY_NAME,
482: P_SOURCE_ENTITY_KEY => P_SOURCE_ENTITY_KEY,
483: P_TARGET_ENTITY_NAME => P_ENTITY_NAME,
484: P_TARGET_ENTITY_KEY => P_TARGET_ENTITY_KEY,

Line 493: IF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR OR L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

489: X_INSTRUCTION_SET_ID => L_INSTRUCTION_SET_ID
490: );
491:
492: --If the return status is not success then raise an exception.
493: IF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR OR L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
494: RAISE SEND_ACKN_ERROR;
495: END IF;
496: END LOOP;
497:

Line 506: P_INIT_MSG_LIST => FND_API.G_FALSE,

502: --Call the PL/SQL API to send the definition acknowledgement.
503: GMO_INSTRUCTION_GRP.SEND_DEFN_ACKN
504: (
505: P_API_VERSION => 1.0,
506: P_INIT_MSG_LIST => FND_API.G_FALSE,
507: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_NONE,
508: P_INSTRUCTION_PROCESS_ID => P_INSTR_PROCESS_ID,
509: P_ENTITY_NAME => P_ENTITY_NAME,
510: P_SOURCE_ENTITY_KEY => P_SOURCE_ENTITY_KEY,

Line 507: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_NONE,

503: GMO_INSTRUCTION_GRP.SEND_DEFN_ACKN
504: (
505: P_API_VERSION => 1.0,
506: P_INIT_MSG_LIST => FND_API.G_FALSE,
507: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_NONE,
508: P_INSTRUCTION_PROCESS_ID => P_INSTR_PROCESS_ID,
509: P_ENTITY_NAME => P_ENTITY_NAME,
510: P_SOURCE_ENTITY_KEY => P_SOURCE_ENTITY_KEY,
511: P_TARGET_ENTITY_KEY => P_TARGET_ENTITY_KEY,

Line 518: IF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR OR L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

514: X_MSG_DATA => L_MSG_DATA
515: );
516:
517: --If the return status is not success then raise an exception.
518: IF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR OR L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
519: RAISE SEND_ACKN_ERROR;
520: END IF;
521:
522: EXCEPTION

Line 738: RETURN FND_API.G_FALSE;

734: NULL);
735: END IF;
736:
737: IF (L_RETURN_VALUE = -99999) THEN
738: RETURN FND_API.G_FALSE;
739: END IF;
740:
741: RETURN FND_API.G_TRUE;
742:

Line 741: RETURN FND_API.G_TRUE;

737: IF (L_RETURN_VALUE = -99999) THEN
738: RETURN FND_API.G_FALSE;
739: END IF;
740:
741: RETURN FND_API.G_TRUE;
742:
743: EXCEPTION WHEN OTHERS THEN
744: RETURN FND_API.G_FALSE;
745:

Line 744: RETURN FND_API.G_FALSE;

740:
741: RETURN FND_API.G_TRUE;
742:
743: EXCEPTION WHEN OTHERS THEN
744: RETURN FND_API.G_FALSE;
745:
746: END IS_CONV_WITH_PRIMARY_UOM;
747:
748:

Line 894: IF FND_API.TO_BOOLEAN( P_INIT_MSG_LIST ) THEN

890:
891: BEGIN
892:
893: --Initialize the message list if specified so.
894: IF FND_API.TO_BOOLEAN( P_INIT_MSG_LIST ) THEN
895:
896: FND_MSG_PUB.INITIALIZE;
897:
898: END IF;

Line 900: IF P_AUTO_COMMIT = FND_API.G_TRUE THEN

896: FND_MSG_PUB.INITIALIZE;
897:
898: END IF;
899:
900: IF P_AUTO_COMMIT = FND_API.G_TRUE THEN
901: INSTANTIATE_DISP_SETUP_AUTO
902: (P_DISPENSE_CONFIG_ID => P_DISPENSE_CONFIG_ID,
903: P_ENTITY_NAME => P_ENTITY_NAME,
904: P_ENTITY_KEY => P_ENTITY_KEY,

Line 939: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

935: ELSE
936: RAISE GMO_NO_DISPENSE_CONFIG_ERR;
937: END IF;
938:
939: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
940:
941: END IF;
942:
943: EXCEPTION

Line 946: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

942:
943: EXCEPTION
944: WHEN GMO_NO_DISPENSE_CONFIG_ERR THEN
945:
946: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
947:
948: FND_MESSAGE.SET_NAME('GMO','GMO_INVALID_DISPENSE_CONFIG_ID');
949: FND_MESSAGE.SET_TOKEN('CONFIG_ID',P_DISPENSE_CONFIG_ID);
950: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);

Line 967: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

963: END IF;
964:
965: WHEN OTHERS THEN
966:
967: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
968:
969: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
970: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
971: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_DISPENSE_SETUP_PVT');

Line 1021: IF FND_API.TO_BOOLEAN( P_INIT_MSG_LIST ) THEN

1017:
1018: BEGIN
1019:
1020: --Initialize the message list if specified so.
1021: IF FND_API.TO_BOOLEAN( P_INIT_MSG_LIST ) THEN
1022:
1023: FND_MSG_PUB.INITIALIZE;
1024:
1025: END IF;

Line 1058: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1054: END IF;
1055:
1056: COMMIT;
1057:
1058: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1059:
1060: EXCEPTION
1061: WHEN GMO_NO_DISPENSE_CONFIG_ERR THEN
1062: ROLLBACK;

Line 1064: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1060: EXCEPTION
1061: WHEN GMO_NO_DISPENSE_CONFIG_ERR THEN
1062: ROLLBACK;
1063:
1064: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1065:
1066: FND_MESSAGE.SET_NAME('GMO','GMO_INVALID_DISPENSE_CONFIG_ID');
1067: FND_MESSAGE.SET_TOKEN('CONFIG_ID',P_DISPENSE_CONFIG_ID);
1068: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);

Line 1086: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

1082:
1083: WHEN OTHERS THEN
1084: ROLLBACK;
1085:
1086: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
1087:
1088: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1089: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1090: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_DISPENSE_SETUP_PVT');

Line 1135: --two seconds. Based on this condition it returns FND_API.G_TRUE or FND_API.G_FALSE.

1131:
1132: END GET_SETUP_STATUS;
1133:
1134: --This function checks if the the difference between the specified dates is atleast
1135: --two seconds. Based on this condition it returns FND_API.G_TRUE or FND_API.G_FALSE.
1136: FUNCTION IS_DATE_DIFF_SUFFICIENT(P_FIRST_DATE DATE,
1137: P_SECOND_DATE DATE)
1138:
1139: RETURN VARCHAR2

Line 1151: RETURN FND_API.G_TRUE;

1147: IF P_FIRST_DATE IS NOT NULL AND P_SECOND_DATE IS NOT NULL THEN
1148: L_DIFF := P_SECOND_DATE - P_FIRST_DATE;
1149:
1150: IF L_DIFF > 1/86400 THEN
1151: RETURN FND_API.G_TRUE;
1152: ELSE
1153: RETURN FND_API.G_FALSE;
1154: END IF;
1155: ELSE

Line 1153: RETURN FND_API.G_FALSE;

1149:
1150: IF L_DIFF > 1/86400 THEN
1151: RETURN FND_API.G_TRUE;
1152: ELSE
1153: RETURN FND_API.G_FALSE;
1154: END IF;
1155: ELSE
1156: RETURN FND_API.G_TRUE;
1157: END IF;

Line 1156: RETURN FND_API.G_TRUE;

1152: ELSE
1153: RETURN FND_API.G_FALSE;
1154: END IF;
1155: ELSE
1156: RETURN FND_API.G_TRUE;
1157: END IF;
1158:
1159: END IS_DATE_DIFF_SUFFICIENT;
1160: